Jump to content

Worksheet totals not consistent

Recommended Posts

I'm just learning about worksheets and generating reports.

I've created a worksheet for a wall style and have 2 issues i can't resolve.


1)  When multiplying Net Area and Price/ SqFt, the numbers are off.  (The functions maybe wrong?)


2)  Using =COMPNAMEBYCLASS  i have the wall components listed to determine price/sqFt. but the total Net Area for each component and the wall styles don't match up. Or are they not supposed to?


Attached is the file.  Any insight into what i'm doing wrong is greatly appreciated.



Link to comment

Look in File > Document Settings > Units.  Your file has the area precision set to 1.  So in the worksheet it displays the the area rounded off to the nearest whole number, but in the calculation it uses all the decimal points it has.


A couple options:  

1.  Increase the precision of the document area units.

2.  If you want the area to display in whole units then round it in the worksheet.  Then the calculations will use the rounded value and not the actual, hidden value.  To do this just use the existing function call inside a ROUND Function.  So in Column C the =WALLAREA_NET call would be =ROUND(WALLAREA_NET)

Link to comment

The component on the outside of a corner is going to have more area than on the inside of that corner.  The difference will be the thickness of the connecting wall.  So the exterior components will usually have more area than the interior gyp board. 


If you draw a single straight wall with no corners all the components will have equal area.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...