SEASONALITY STOCK REPORTS

[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