Page 1 of 1
| SimSig Length Calculator v2.2 01/05/2019 at 15:56 #117994 | |
bugsy
1766 posts |
[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
1192 posts 
|
bugsy in post 117994 said:[Quote}TitleFrom 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
5265 posts |
HST125Scorton in post 117995 said:bugsy in post 117994 said: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.[Quote}TitleFrom Wagon all way to the end. It just throws up #N/A. 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
1766 posts |
postal in post 117996 said:HST125Scorton in post 117995 said:Ah. Ok. That gives me something to work on.bugsy in post 117994 said: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.[Quote}TitleFrom Wagon all way to the end. It just throws up #N/A. 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
1192 posts
|
postal in post 117996 said:HST125Scorton in post 117995 said:Thank you for that Postal, I'm no expert in Excel to fix anything but it seemed like it was simple fix.bugsy in post 117994 said: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.[Quote}TitleFrom Wagon all way to the end. It just throws up #N/A. 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
5265 posts |
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
1192 posts
|
postal in post 118003 said:HST125Scorton in post 117998 said:I have now uploaded v2.3 and added couple more bits & bobs.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. Aaron (AJRO) | Timetable Writer Log in to reply |