Replies to post #210 on SEASONALITY STOCK REPORTS

[kgoodrich]

Hi, lostcowboy. I used the sum button on the EXCEL chart. I assumed it knew how to do it. I don't understand why you placed a 1 in front of the .30% or the .34% that would seem to make it 134%. I will check into it though. You're a genius cowboy. I'd be a fool not to listen to you. See you when I get home from work.

KG

[QuillandPenn]

Lostcowboy,

I guess KG just used the sum keep to vip out the answer.

Just reviewed the .xls file you were looking at and it appears to be kewl. What you are looking at, is roundup of the little dawgies or ballpark numbers. In order to save space, I guess they roundup.

If you click on the percent number, you should see a large digital number ie 30.xxxxxxxxxxxx. But, if you add all up the digital numbers with a calculator and then use minus 20.3898xxxxxx would come out to be 80 and change (80.3852) as a percent. And the excel spreadsheet rounds up or rounds down. Close enought for government werk as they say.

How to get the 34, 30, 34, 3, et., al., is the kewl part. Would be interested on how you achieve the percent numbers as shown.

Just a thought,
QuillandPenn