I need help calculating this.

  • Thread starter Thread starter TroyM
  • Start date Start date
T

TroyM

I need help doing this. I work for a music company and i have to enter
in sales once a week. I'll try to explain it the best way i can. And
will attach a picture to help.

When you get the picture opened; every week i type in numbers under
"TW"=This Week sales when i do that i have to get a calculator and add
the numbers i just typed in for TW into the YTD and LTD. That is what
takes be forever.

So is there anyway whatever gets typed in the TW auto calculates into
YTD and LTD? Thanks alot!

http://img340.imageshack.us/img340/5254/untitled5vk.jpg
 
If you explain what exactly you are hand calculating (i.e. what numbers
go into LW, 2W, 3W and YTD), then I'll be able to help.
 
What you are doing may have worked -- or may have appeared to have
worked -- in the past but it is bad design.

By overwriting information in a cell and keeping only a YTD figure,
there is no audit trail. If there was an error in the past there is no
knowing if it was corrected and if a correction was attempted if it was
done correctly.

While I am not an expert on the subject, my guess would be that if you
work for a company subject to Sarbanes-Oxley and your work is part of
the financial reporting chain or part of the internal management
controls system, the CEO cannot possibly certify the company as "in
compliance."

Obviously, you are welcome to continue doing what you are doing but you
may want to talk with your boss / accounting / audit group to figure
out how to retain an audit trail of sales information. Basically, you
need to timestamp every change and *never* allow an 'undo' of a
transaction once it is committed to persistent storage.

FWIW, with a proper system, the YTD can be computed quite easily.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
William said:
If you explain what exactly you are hand calculating (i.e. what numbers
go into LW, 2W, 3W and YTD), then I'll be able to help.
Click to expand...

Ok i was sent this file to take over. at the end of each column (LW,
2W, 3W, etc.) are all the totals (which adds up correctly) When i type
in the TW, the following week 2W will have that number and TW will have
a new one. Everything adds up correctly, i just need to find a way to
make the TW numbers i type in auto-add in the LTD and YTD.
 
1. I still don't feel I have enough info to help in any real way. I
sent you a private message with my email so if you'd like my help send
me the file.

2. Although I didn't want to say it, at first glance I'd have to agree
with TM ... bad initial design.
 
Back
Top