The first round is complete for all 3 divisions, and each team has received its reports by email. there were some flaws in the input, but most will be cured next week. If there is something you do not understand in the report, be sure to ask about it, and we can figure it out.
The most common error, I think, was not selecting your team on the first sheet under the division. that leads to the wrong number in the first column of your lines in the datain sheet, and I have to edit them.
The second most common error was not sending the actual files created, or the original sheet saved. You should not copy and paste the lines from the datain sheet into an email– they won’t be formatted right. I did say this was ok, but it turns out it isn’t. Also don’t copy all of the datain sheet and paste it into another book and send me that. It is much better to send me the file you are actually using.
If you are having the macro trouble on a campus computer, simply save the entire sheet to a file with a good name and send it to me.
I am posting a new version of the Data.xls sheet on the WebCT site. It will be called Data-1d.xls You should use it for the next round. It has the CSUM logo on the first sheet. It has the actual team names in the dropdown lists. Note that in WEST, Team 2 is 49ers (That is Team 10) and Team 3 is Rams (that is our Team 11), and the cities are now right in the reports. I screwed this up before. Also this sheet should allow you to choose where you save the two files that are created when you save the information using the button on the first sheet (the copy of the spreadsheet with a name corresponding to your team and division and your datain.prn file for the period), with descriptive names. When you send me input for week 2, send me both the spreadsheet and the .prn file– that way I can debug any problems. Here is the file name structure:
“datain.prn” Example: datain_01WESTTeam12.prn
“Data.xls” Example: WESTTeam12-Data_01.xls
The _01 is the week. The other codes are self explanatory.
We should be on track for making decisions by Friday night, or no later than Saturday night, I hope. Good luck!
Supply Chain and Logistics 