Monday Update: Rounding Error

I was looking through some old posts today, and realized that there was a problem with my planting mix schedule from my previous post on Planting Styles and Mixes.

update_rounding error

The counts for each type (in blue) do not add up to the correct total count (in red). The Count (in red) is the correct total, but since the Count is derived from a formula using an Area, it is not an integer. So when it is put through another formula, it results in too many plants in the mix Type counts.

The fix is quite simple: simply modify the Count to round within the Type Count formula:

update_rounding error_round

I have now updated the original post and Project file, but if you have used or downloaded the old planting mix schedule, be sure to make the change or get the updated version.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s