Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Help / Recommendation
This past summer you all were wonderfully helpful with a calculation problem
I was having. Now I am seeking help again. I need to know if I am using the best vehicle to track these stats for a client. The client needs to track stats on five sales reps (potential of more reps in the future). Data needs to be recorded on a number of items on a daily basis for the entire school year with week end results, month end results, quarter end results and year end results for each rep and also for all the reps combined. Hope I am clear here. What I have done since Excel will not give me enough room for an entire calendar year is I have created a workbook with a worksheet for each quarter and a year end for each individual rep plus another set for the combined totals...for a whopping total of 25 sheets. I am currently looking at almost 3.5 meg on this workbook. As the school year turns over the dates need to be readjusted along with checking to make sure week end, month end, etc. all changes accordingly. Fine for someone that knows how to work with Excel not for someone who doesn't. The other wrinkle, which I just found out about a month or so back, is that the person who does all of the data entry at the school uses a Mac whereas I use an IBM so we have had some interesting translation issues...and I thought I was creating the problems!! Anyway, is Excel the best tool to use? Should we be looking at something else like a data base or statistical software? Any thoughts, recommendations would be greatly appreciated. Thanks so much in advance! Pat |