Mike,
Your system sounds pretty sound to me. However, if I was to do it that way, not ONLY would I have to include the 8 main roads, but I would also have to include all the staging roads, private shippers, any lease rolling stock, and other rolling stock that any of the 8 roads have inherited or purchased from liquidated roads.
Of course, any liquidated stock I would have hoped to run it through the paintshop first before putting it on the road, but there are those oddball cars that are just labeled and not repainted.
So, instead of 8 roads, we are now talking quite a bit!
Umm, go ahead and send me the spreadsheet. Wait. What program was it created in? I cannot use Excel 2000 because I cannot find my stupid confirmation code from Microsoft when I had it installed the last time. I totally forgot about the program shutting down after 50 times. I was just glad I got all of my databases converted to Office 97 format before the program asked me to enter my confirmation code in again. Whew!
If you could convert the spreadsheet over to Excel 97 format, that would be great.
I included the autoracks as part of my intermodal car listing, but now I have to go back and redo it for private shippers, leased stock, and liquidated stock that may have old paint schemes but new labels and road numbers. LOL!
Your opinon...Should I include these other numbers (exception being the liquidated stock) in the overall percentages (leased and private shippers), or include them with each road's individual percentages?
Finally, how would I convert the percentages to actual numbers, after the percentages are figured out? Hey, I am a computer tech, not a math whiz. LOL!
