Upcoming Games

(UTC times)


Full list
Add a game

Upcoming Events

No events to display

SimSig Length Calculator v2.2

You are here: Home > Forum > General > General questions, comments, and issues > SimSig Length Calculator v2.2

Page 1 of 1

SimSig Length Calculator v2.2 01/05/2019 at 15:56 #117994
bugsy
Avatar
1766 posts
Online
[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.

Everything that you make will be useful - providing it's made of chocolate.
Log in to reply
SimSig Length Calculator v2.2 01/05/2019 at 16:04 #117995
HST125Scorton
Avatar
1192 posts
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

Aaron (AJRO) | Timetable Writer
Log in to reply
SimSig Length Calculator v2.2 01/05/2019 at 16:21 #117996
postal
Avatar
5265 posts
Online
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.

Post has attachments. Log in to view them.
“In life, there is always someone out there, who won’t like you, for whatever reason, don’t let the insecurities in their lives affect yours.” – Rashida Rowe
Log in to reply
The following user said thank you: HST125Scorton
SimSig Length Calculator v2.2 01/05/2019 at 16:28 #117997
bugsy
Avatar
1766 posts
Online
postal in post 117996 said:
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.
Ah. Ok. That gives me something to work on.

Obviously, as you've relessed an amended copy that now works, I'll just play around with it for fun.

Everything that you make will be useful - providing it's made of chocolate.
Log in to reply
SimSig Length Calculator v2.2 01/05/2019 at 16:30 #117998
HST125Scorton
Avatar
1192 posts
postal in post 117996 said:
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.

Aaron (AJRO) | Timetable Writer
Log in to reply
The following user said thank you: postal
SimSig Length Calculator v2.2 01/05/2019 at 17:38 #118003
postal
Avatar
5265 posts
Online
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.

“In life, there is always someone out there, who won’t like you, for whatever reason, don’t let the insecurities in their lives affect yours.” – Rashida Rowe
Log in to reply
The following user said thank you: HST125Scorton
SimSig Length Calculator v2.2 01/05/2019 at 18:44 #118004
HST125Scorton
Avatar
1192 posts
postal in post 118003 said:
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.
I have now uploaded v2.3 and added couple more bits & bobs.

Aaron (AJRO) | Timetable Writer
Log in to reply