SimSig Length Calculator v2.2

[Quote}Title
SimSig Length Calculator v2.2
Description
Excel spreadsheet that allows users to select traction and rolling stock types to generate consist lengths and maximum speeds.
Full credits to the original owner JC92, and for the original work on this spreadsheet.
Spreadsheet is slightly broken 'will not calculate wagons further down the list'.. not been an excel genius[Quote]

How far down the list does it make calculations successfully?

I'm no genius either, but have dabbled a bit when preparing Excel spreadsheets for technicians many moons ago.

If you wouldn't mind, I'd like to see if I can help. No guarantee though.

bugsy in post 117994 said:

[Quote}Title
SimSig Length Calculator v2.2
Description
Excel spreadsheet that allows users to select traction and rolling stock types to generate consist lengths and maximum speeds.
Full credits to the original owner JC92, and for the original work on this spreadsheet.
Spreadsheet is slightly broken 'will not calculate wagons further down the list'.. not been an excel genius[Quote]

How far down the list does it make calculations successfully?

I'm no genius either, but have dabbled a bit when preparing Excel spreadsheets for technicians many moons ago.

If you wouldn't mind, I'd like to see if I can help. No guarantee though.

From Wagon all way to the end. It just throws up #N/A.
PLA/JLA Procor 80 Car Transporter Wagons

HST125Scorton in post 117995 said:

bugsy in post 117994 said:

[Quote}Title
SimSig Length Calculator v2.2
Description
Excel spreadsheet that allows users to select traction and rolling stock types to generate consist lengths and maximum speeds.
Full credits to the original owner JC92, and for the original work on this spreadsheet.
Spreadsheet is slightly broken 'will not calculate wagons further down the list'.. not been an excel genius[Quote]

How far down the list does it make calculations successfully?

I'm no genius either, but have dabbled a bit when preparing Excel spreadsheets for technicians many moons ago.

If you wouldn't mind, I'd like to see if I can help. No guarantee though.

From Wagon all way to the end. It just throws up #N/A.
PLA/JLA Procor 80 Car Transporter Wagons

The formula in the original file only reads 100 rows (which was far in excess of the number of freight wagons listed in the original). I've reset the formula to read 1000 rows. Updated copy attached.

HST125Scorton in post 117995 said:

bugsy in post 117994 said:

[Quote}Title
SimSig Length Calculator v2.2
Description
Excel spreadsheet that allows users to select traction and rolling stock types to generate consist lengths and maximum speeds.
Full credits to the original owner JC92, and for the original work on this spreadsheet.
Spreadsheet is slightly broken 'will not calculate wagons further down the list'.. not been an excel genius[Quote]

How far down the list does it make calculations successfully?

I'm no genius either, but have dabbled a bit when preparing Excel spreadsheets for technicians many moons ago.

If you wouldn't mind, I'd like to see if I can help. No guarantee though.

From Wagon all way to the end. It just throws up #N/A.
PLA/JLA Procor 80 Car Transporter Wagons

The formula in the original file only reads 100 rows (which was far in excess of the number of freight wagons listed in the original). I've reset the formula to read 1000 rows. Updated copy attached.

Thank you for that Postal, I'm no expert in Excel to fix anything but it seemed like it was simple fix.

HST125Scorton in post 117998 said:

Thank you for that Postal, I'm no expert in Excel to fix anything but it seemed like it was simple fix.

I've had plenty of practice. I've been playing with Excel (and before that Supercalc) since the 1980s. Are you going to re-zip the file and put the update into the downloads section? Also be good if one of the mods could remove the earlier versions of the file.