microphish
New Member
- Joined
- Apr 30, 2002
- Messages
- 1
I am computing annual budget numbers in Excel (whole number amounts) that have to be
spread into 12 months based on a specific monthly spread.
The Budget System that I am uploading these numbers to lops off any decimal amount
and then adds the 12 months together. Of course, this causes a rounding
error and the Annual total in Excel doesn't match the resummed value in my Budget System.
I am trying to head this problem off in Excel by only uploading monthly, whole numbers
by using the ROUND formulas when I spread the Annual amount into 12 months.
Inevitably, as in the budget system, the sum of the months has an absolute variance
from the Annual base number of 1 to 6 usually. Is there a way to force a match to the base without pickout out random months and adding back the 4 or 5. The numbers are
large enough that the 4 or 5 variance is insignificant but over 10,000 entries, the report numbers between Excel and the Budget System vary significantly. Any suggestions?
spread into 12 months based on a specific monthly spread.
The Budget System that I am uploading these numbers to lops off any decimal amount
and then adds the 12 months together. Of course, this causes a rounding
error and the Annual total in Excel doesn't match the resummed value in my Budget System.
I am trying to head this problem off in Excel by only uploading monthly, whole numbers
by using the ROUND formulas when I spread the Annual amount into 12 months.
Inevitably, as in the budget system, the sum of the months has an absolute variance
from the Annual base number of 1 to 6 usually. Is there a way to force a match to the base without pickout out random months and adding back the 4 or 5. The numbers are
large enough that the 4 or 5 variance is insignificant but over 10,000 entries, the report numbers between Excel and the Budget System vary significantly. Any suggestions?