Signals Spreadsheet Signals by By Spreadsheet Dr Gerry
Signals Spreadsheet Signals by By Spreadsheet Dr. Gerry Albers NMRA Life Member Cincinnati Div. 7, MCR SBS 2_blue. pptx 9/10/2021 Slide 1
Signals By Spreadsheet Clinic Checklist (Can I create a signal system? ) Yes! …. If: • You have a computer – PC running Windows 2000 or later (including Windows 8) – MAC running Windows emulator (e. g. , Virtual Machine) • • You can play Solitaire on your computer You can make entries in a spreadsheet You like FREE software You can make an electrical connection to your DCC track bus • You can make a Cab Bus (or Loco. Net®) connection SBS is a Completely Integrated Signal System SBS 2_blue. pptx 9/10/2021 Slide 2
Signals By Spreadsheet SBS Hardware Configuration - General Distributed Input/Output DIO Power Detectors Signals Turnout Positions Cab Bus/Loco. Net DIO/D 29 Features: • 29 Input or Output Terminals per DIO card • User Determines Direction of Each Terminal • Up to 128 DIO cards (3, 712 I/O terminals) • Powered by Track Bus • Can drive signals directly (thru resistors) • Can power occupancy detectors and other accessories (including Tortoise machines) Throttle T T SBS 2_blue. pptx 9/10/2021 Data Power & Commands DCC Command Station Track Bus T Acc Dec Data Slide 3
Signals By Spreadsheet SBS Hardware Configuration - Digitrax Distributed Input/Output SBS USB DIO Loco. Buffer USB Power Detectors Signals Turnout Positions PC or MAC Windows 2000 or Later Loco. Net DIO/D 29 Features: • 29 Input or Output Terminals per DIO card • User Determines Direction of Each Terminal • Up to 128 DIO cards (3, 712 I/O terminals) • Powered by Track Bus • Can drive signals directly (thru resistors) • Can power occupancy detectors and other accessories (including Tortoise machines) Throttle T T SBS 2_blue. pptx 9/10/2021 Data Power & Commands DCC Command Station Track Bus T Acc Dec Data Slide 4
Signals By Spreadsheet SBS Hardware Configuration - Others SBS USB Loco. Buffer USB SBS Data Bus Distributed Input/Output SBS Data Bus DIO Power Detectors Signals Data Bus Interface Turnout Positions PC or MAC Windows 2000 or Later Cab Bus SBS Data Bus DIO/D 29 Features: • 29 Input or Output Terminals per DIO card • User Determines Direction of Each Terminal • Up to 128 DIO cards (3, 712 I/O terminals) • Powered by Track Bus • Can drive signals directly (thru resistors) • Can power occupancy detectors and other accessories (including Tortoise machines) Throttle T T SBS 2_blue. pptx 9/10/2021 Data Power & Commands DCC Command Station Track Bus T Acc Dec Data Slide 5
Signals By Spreadsheet DIO Board Features DCC Track Bus • Power • DCC Signal LED • Green = OK (Receiving Power and DCC Signal) • Red = Address Configuration Mode, Error or No DCC Signal (Try Reset Button) • Red Flash = Address or CV Value Accepted (User Configuration Mode Only) Accessory Power • Off = No Power • +12 to 15 V DC, unregulated. Use for Tortoise driver, etc. • +5 VDC, regulated. Use for occupancy detectors, DCC T 2 Reset Button signals, LED indicators, etc. Vin 1 T 1 +12 V LED 1 Vin 2 +5 V Gnd T 3 PIC 16 F 871/40 P Configure Board Address T 5 B 0 B 1 B 2 B 3 B 4 B 5 B 6 B 7 Gnd T 4 Address Configuration Jumper (Stowed) T 6 D 0 D 1 D 2 D 3 D 4 D 5 D 6 D 7 Gnd JP 1 1 2 3 C 0 C 1 C 2 C 3 C 4 C 5 C 6 C 7 Gnd A 0 A 1 A 2 A 3 A 4 A 5 E 0 Gnd Signal/Command Bus Interface (DIO Only) • Send/Receive Data To/From Computer • “Daisy-Chain” Connectors Mounting holes for #4 screws 29 Input or Output Terminals (C 6 and C 7 are reserved) SBS 2_blue. pptx 9/10/2021 Slide 6
Signals By Spreadsheet The SBS System Architecture Distributed Input/Output SBS Software on PC (or MAC) Data 5 Run Compile Build rd Cda r a IO C Loco. Buffer IOD e r D USB tu efisg o. Tn C Signal 2 DIO T 1 T Signal State Spreadsheets Terminal Definitions & Names Spreadsheets T Data Cab Bus or Loco. Net (or standalone) 4 3 DIO Power Detectors Signals Turnout Positions Command Station SBS 2_blue. pptx 9/10/2021 Track Bus Data Slide 7
Signals By Spreadsheet SBS “Edit DIO Card” Function DIO Spreadsheet • Enter Terminal Direction: “I” (Input) or “O” (Output) • Enter your name for Terminal (See “Acceptable Names” List or use “Help”) • Enter Wire Color (optional, for your documentation) • Enter Comment (optional, for your documentation) Reserved For SBS Use. Active Hi/Lo Switches • Defines Terminal as “Active Hi” or “Active Lo” SBS 2_blue. pptx 9/10/2021 Control Panel • Select previously saved DIO card or … • Select “New” * • Make Spreadsheet Entries (See Above) • DO NOT make entries In “Do Not Use” terminal cells • “Save” spreadsheet • “Configure” DIO Card • Writes Address Into Card If “Configuration Jumper” is in 1 -2 Position • Configures Terminal Directions In Card • “Print” Spreadsheet for your documentation • Use “Help” as needed • “Exit” – Warnings will pop up if changes were made and not “Saved” or not “Configured”. Demo Slide 8
Signals By Spreadsheet Example: Automatic Block Signal Your Rules for S 2 W (It’s your railroad): • Green: both blocks ahead (B 23 and B 24) not occupied (Proceed) • Yellow: block ahead (B 23) not occupied, second block (B 24) occupied (Slow ready to stop) • Red: block ahead B(23) occupied (Stop) B 24 Outputs B 23 B 24 S 2 WG S 2 WY S 2 WR NO = Not Occupied O = Occupied ON = On OFF = Off Blank = “Don’t Care” SBS 2_blue. pptx 9/10/2021 B 23 IF B 23 is not occupied AND… B 24 is not occupied, THEN … S 2 WG ON, S 2 WY OFF, etc. Inputs S 2 W B 23 B 24 NO NO S 2 WG ON S 2 WY OFF S 2 WR OFF NO OFF ON OFF OFF ON O “Don’t Care” O Default = “Off” Slide 9
Signals By Spreadsheet S 2 W Spreadsheet Demo SBS 2_blue. pptx 9/10/2021 Slide 10
Signals By Spreadsheet Example: Automatic Block Signal (Approach Lit) Our New Rules for S 2 W: • Green: B 22 occupied & both blocks ahead (B 23 and B 24) not occupied (Proceed) • Yellow: B 22 occupied & block ahead (B 23) not occupied, second block (B 24) occupied (Slow ready to stop) • Red: B 22 occupied & block ahead (B 23) occupied (Stop) S 2 W • Dark: signal’s block (B 22) not occupied B 24 Inputs Outputs B 22 B 23 B 24 S 2 WG S 2 WY S 2 WR B 23 B 22 B 23 B 24 O NO NO O S 2 WG B 22 S 2 WY S 2 WR ON OFF OFF OFF ON OFF OFF NO = Not Occupied O = Occupied ON = On OFF = Off Blank = “Don’t Care” SBS 2_blue. pptx 9/10/2021 Slide 11
Signals By Spreadsheet S 2 W (Approach Lit) Spreadsheet Demo SBS 2_blue. pptx 9/10/2021 Slide 12
Signals By Spreadsheet The SBS System Architecture Distributed Input/Output SBS Software on PC Data Code Button Compile Build Run Interface T DIO Signal T Signal State Spreadsheets Cab Bus or Loco. Net Repeater Terminal Definitions & Names Spreadsheets T DIO Power Detectors Signals Data DIO DIO Dispatch Panel SBS 2_blue. pptx 9/10/2021 Lights Data Switches Code Buttons 2 Wires From Track Bus or AC/DC Supply Slide 13
Signals By Spreadsheet The SBS System Architecture Distributed Input/Output SBS Software on PC Data Code Button Compile Build Run Interface T DIO Signal T Signal State Spreadsheets Cab Bus or Loco. Net Repeater Terminal Definitions & Names Spreadsheets T DIO Power Detectors Signals Data DIO DIO Dispatch Panel SBS 2_blue. pptx 9/10/2021 Lights Data Switches Code Buttons 2 Wires From Track Bus or AC/DC Supply Slide 14
Signals By Spreadsheet Input Configuration: Active Low (Pull-Down) SBS Input Configurations +12 VDC +5 VDC Terminal GND Transistor/ Detector Out Photodiode Switch Contact DIO Input Terminal Limitations: Maximum input voltages, current: • High: +5 VDC, 20 ma. • Low: 0 VDC, 25 ma. All terminals have a 10 K pull-up to +5 V. Microprocessor 10 k DIO Board Example Inputs Current Detector Track Bus, Rail A Examples Detector Tortoise 9/10/2021 R Contacts on Tortoise DIO GND _ SBS 2_blue. pptx DIO Terminal N DIO +5 V (Optional*) DIO Terminal DIO GND * Team Digital DBD 2 or eq. Track Bus, Rail B Switch Position Indication Optical Detector + Slide 15
Signals By Spreadsheet Output Configuration: Active Low (ON = Pull-Down) +12 VDC +5 VDC 10 k LED Terminal GND Microprocessor 270 Ohms DIO Board Output Configuration: Active High (ON = Push-Up) +12 VDC GND LED SBS 2_blue. pptx 9/10/2021 Microprocessor Terminal 270 Ohms GPDIO Output Terminal Limitations: Max output sink (low) current: 25 ma. Max output source (high) current*: 20 ma All terminals have a 100 K pull-up to +5 V. *Terminal A 4 is not push-pull and cannot source current. Examples Signal - Common Anode Active Low Configuration DIO +5 V or FL 2† 270 Ohms* * To color balance signal LED’s, use individual LED resistors with different values. DIO Terminal +5 VDC 10 k SBS Output Configurations DIO Board Signal - Common Cathode Active High Configuration DIO Terminal †FL 2 – dual flasher unit 270 Ohms* DIO GND or FL 2† Slide 16
Signals By Spreadsheet APB/ABS Cost - Example • • 3 Sidings • 2 Blocks Between Sidings B 2 T 0 B 6 T 1 B 1 12 Blocks (B 0 – B 11) 6 Control Points (OS) – Optical Detectors 6 Turnout Positions (T 0 – T 5) 6 Double Head Signals (5 LED’s) 6 Single Head Signals, Sidings (2 LED’s) 6 Single Head Signals, Mainline (3 LED’s) B 3 T 2 B 4 B 10 T 3 B 5 B 7 T 4 B 8 T 5 B 9 B 11 This example illustrates the cost of signal system equipment only. It does not include the cost of computer, signals, switch machines (Tortoise), Tortoise drivers, accessory decoders, etc. Typical Headblock (Control Point) – 10 LED’s, 6 Places Inputs: • Blocks • Control Points • Turnout Pos. Outputs • Signal LEDs (6 x 10) Total I/O Bits SBS 2_blue. pptx 9/10/2021 12 6 6 60 84 Signals By Spreadsheet Equipment Req. • 1 Loco. Buffer Interface $70 • 3 DIO/D 29 Cards @ $80 ea. $240 • 6 DBD 221 Detectors @ $22 ea. $132 • 6 Photosensors @ $1 $6 Total Cost 2 $448 Note: 1. DBD 22 has two detectors per board 2. DIOs Are Powered By Track Bus = No Power Supply Needed DIOs Power Detectors, Turnouts, Signals = No Power Supply Needed Cab Bus Used To Communicate = No Additional Cabling Programmed Using FREE Spreadsheet Software Slide 17
Signals By Spreadsheet SBS Hardware Configuration - Digitrax Distributed Input/Output SBS USB DIO Loco. Buffer USB Power Detectors Signals Turnout Positions PC or MAC Windows 2000 or Later SBS 2_blue. pptx 9/10/2021 TD 8 RCS Throttle T T T Data Power + Comm Data Acc Dec Local Panel DCC Command Station Track Bus RCS (Route Control System): • 8 Accessory Decoders • Up To 16 Routes • Local or Remote (CTC) Control • Powered by Track Bus • Can Power Tortoises (Need TD 8 Driver) Loco. Net DIO/D 29 Features: • 29 Input or Output Terminals per DIO card • User Determines Direction of Each Terminal • Up to 128 DIO cards (3, 712 I/O terminals) • Powered by Track Bus • Can drive signals directly (thru resistors) • Can power occupancy detectors and other accessories (including Tortoise machines) 8 Turnouts Slide 18
Signals By Spreadsheet SBS Hardware Configuration - Other SBS USB Loco. Buffer USB SBS Data Bus DIO Power Detectors Signals Data Bus Interface USB PC or MAC Windows 2000 or Later Distributed Input/Output Turnout Positions DCC Interface* • Needed To Operate Accessory Decoders Cab Bus (i. e. , Turnout Control) • Lenz: LI-USB NCE: RS 232 or NCE USB Interface SBS 2_blue. pptx 9/10/2021 TD 8 RCS Throttle T T T Data Power + Comm Data Acc Dec Local Panel DCC Command Station Track Bus RCS (Route Control System): • 8 Accessory Decoders • Up To 16 Routes • Local or Remote (SBS/Throttle) Control • Powered by Track Bus • Can Power Tortoises (Need TD 8 Driver) SBS Data Bus DIO/D 29 Features: • 29 Input or Output Terminals per DIO card • User Determines Direction of Each Terminal • Up to 128 DIO cards (3, 712 I/O terminals) • Powered by Track Bus • Can drive signals directly (thru resistors) • Can power occupancy detectors and other accessories (including Tortoise machines) 8 Turnouts Slide 19
Signals By Spreadsheet RCS (Route Control System) DCC Throttle 8 Accessory Decoders with 16 local routes DCC Command Bus (e. g. , Loco. Net) DCC Command Station or Booster* DCC Track (Accessory*) Bus New!!! Can be powered by AC or DC. Must be programmed on DCC. Power + DCC Signal Can Be Cascaded For Unlimited Routes. Vin 1 Vin 2 Think Track – Not Switch Pushbutton Inputs (Up To 16) + 12 VDC GND A 0 – A 5 B 0 – B 1 C 0 – C 7 PIC With RCS Software Logic Outputs (0 – 5 VDC) (Up To 8) RCS E 0 B 6 Locked/Unlocked Signal Logic Hi (+5 V) = Locked Logic Lo (0 V) = Unlocked Local Panel 9/10/2021 Tortoise Driver Board DC Power D 0 – D 7 +5 V GND SBS 2_blue. pptx Throttle Provides: • Switch Machine Activation • Lock/Unlock Function • Address & CV Programming To Next GPDIO (Cascaded RCS’s) Tortoise Switch Machines (Up to 8 independent or 16 Parallel) • Up to 8 independent switches (more with cascaded RCS’s) • Up to 16 independent local routes (more with cascaded RCS’s) • Any or all switch machines may be locked (usually by the dispatcher) *It is strongly suggested that a separate circuit breaker or DCC booster be used to provide a separate DCC Accessory Bus. Slide 20
Signals By Spreadsheet Tortoise Driver Board Each driver board contains 8 independent drive circuits, divided onto 4 mini-boards. Accessory Power To Other Driver Boards (+12 to 15 V DC) (Power can optionally be applied from this end instead) Accessory Power From RCS/DIO (+12 to 15 V DC) Each mini-board has 2 independent drive circuits. Each circuit can drive 2 switch machines in parallel (e. g. , crossovers). SBS 2_blue. pptx 9/10/2021 Tortoise Drivers (2) +V IN GND Tortoise Drivers (2) Snap mini-boards apart to form other combinations (3/1, 2/2, 1/1/2, etc) +V IN GND Tortoise Drivers (2) A In B In A Out 1 A Out 2 B Out 1 B Out 2 Tortoise Drivers (2) +V IN GND GND A In B In A Out 1 A Out 2 B Out 1 B Out 2 +V IN GND Logic signal from RCS/DIO (8 places) Mounting holes for #4 screws To switch machine (8 places) Slide 21
Signals By Spreadsheet AD 30 (Accessory Decoders, 30 max) DCC Throttle 30 Accessory Decoders (no local routes) DCC Command Bus (e. g. , Loco. Net) DCC Command Station or Booster* Throttle Provides: • Switch Machine Activation • Address Programming DCC Track (Accessory*) Bus Power + DCC Signal Vin 1 Vin 2 PIC With AD 30 Software AD 30 + 12 VDC GND A 0 – A 5 B 0 – B 6 C 0 – C 7 D 0 – D 7 E 0 Tortoise Driver Board DC Power Logic Outputs (0 – 5 VDC) (Up To 30) • Up to 30 independent accessory decoders • Up to 30 independent Tortoise (60 parallel) • Tortoise power provided by AD 30 board • AD 30 power provided by DCC Track Bus … … Tortoise Switch Machines (Up to 8 independent or 16 Parallel) *It is strongly suggested that a separate circuit breaker or DCC booster be used to provide a separate DCC Accessory Bus. SBS 2_blue. pptx 9/10/2021 Slide 22
Signals By Spreadsheet STYCS (STaging Yard Control System) 7 Accessory Decoders with 8 local routes Stops train at end of staging yard DCC Throttle DCC Command Bus (e. g. , Loco. Net) DCC Command Station or Booster* DCC Track (Accessory*) Bus Power + DCC Signal Vin 1 Vin 2 Pushbutton Inputs (Up To 8) A 0 – A 5 B 0 – B 1 +5 V GND + 12 VDC GND DC Power Logic Outputs (0 – 5 VDC) (Up To 7) PIC With STYCS Software E 0 Logic Hi (+5 V) = Locked Logic Lo (0 V) = Unlocked 9/10/2021 Tortoise Switch Machines (Up To 7) C 0 – C 7 D 7 Locked/Unlocked Signal Local Panel Tortoise Driver Board D 0 – D 6 GPDIO SBS 2_blue. pptx Throttle Provides: • Switch Machine Activation • Lock/Unlock Function • Address & CV Programming To 5 V Power Relay Photo-detectors (Up To 8) • Up to 7 independent switches (8 tracks) • Up to 8 independent routes (to 8 tracks) • Stops train at end of staging yard • Any or all switch machines may be locked (usually by the dispatcher) *It is strongly suggested that a separate circuit breaker or DCC booster be used to provide a separate DCC Accessory Bus. Slide 23
Signals By Spreadsheet Special Devices Y Z Y Z T 1 X Searchlight Signal Driver J 1 T 3 R 1 J 1 R 1 X T 2 Searchlight Signal Driver U 2 J 1 T 4 T 3 R 1 U 2 J 1 T 4 R 1 +12 V Gnd Gnd C 2 Q 3 C 1 A B C Gnd Q 1 J 2 C 2 Q 2 C 1 Q 3 C 1 T 6 A B C Gnd Dual Searchlight Signal Driver SD 2 9/10/2021 T 5 A B C Gnd J 2 Q 1 C 2 Q 2 C 1 Q 3 R Y G R 2 (5) Q 2 J 2 R 2 (5) Q 1 PAI Copyright 2007 +12 V T 5 SBS 2_blue. pptx X T 1 T 2 U 2 Y Z X T 6 A B C Gnd Dual Flasher Unit FL 2 Slide 24
Signals By Spreadsheet Train Order Operator (TOO) Station Charleston Operator’s Panel Tony Koester Photo TOO Kit Includes: • Power LED (Green) • 4 Station LEDs (Red) • 4 Pushbuttons • 4 Toggle Switches • 4 Photo-transistors • 1 Buzzer Power. Point Panel Layout : • Downloadable (Free) • Prints On Full-Sheet Label • 2 Operator Panels with 4 Stations Each OR 1 Operator with 8 Stations • Photosensor Detects. Train “On Station” (OS) • LED illuminates, “Bell” (buzzer) rings • RESET extinguishes LED • “Cut Out” eliminates repeated “OS-ing” during switching moves SBS 2_blue. pptx 9/10/2021 Slide 25
Signals By Spreadsheet Footnotes • SBS Is Available At: www. Signals. By. Spreadsheet. com – – – SBS 2_blue. pptx Software is free DIO, RCS, STYCS, AD 30, TOO Cards: $80 Tortoise Driver (8): $40 Dual Searchlight Signal Driver: $40 Dual Flasher: $40 TOO Kit: $40 9/10/2021 Slide 26
Signals By Spreadsheet Summary • SBS Hardware & Software Work Together With Existing DCC Systems – Compatible with Digitrax® Loco. Net – No additional communication wiring is needed with Digitrax. – Can be used “standalone” (does not require Cab Bus) • SBS Hardware Is Powered by the DCC Track Bus (Accessory Bus) – No additional power supplies or power wiring are needed. • No Computer Programming! – All entries are made in SBS spreadsheets – SBS software is free ! SBS Hardware & Software Is Available At: www. Signals. By. Spreadsheet. com SBS 2_blue. pptx 9/10/2021 Slide 27
Signals By Spreadsheet Suppliers • Logic/Electronics – See Handout • Signals/Electronics – See Handout • Signal Operating Software – See Handout Acknowledgements • Digitrax and Loco. Net are registered trademarks of Digitrax Corporation SBS 2_blue. pptx 9/10/2021 Slide 28
Signals By Spreadsheet STOP! (Absolute) Q&A Thank you for your interest and attention! SBS 2_blue. pptx 9/10/2021 Slide 29
Signals By Spreadsheet SBS 2_blue. pptx 9/10/2021 Slide 30
- Slides: 30