Revit Architecture Forum
Welcome to Autodesk’s Revit Architecture Forums. Share your knowledge, ask questions, and explore popular Revit Architecture topics.
abbrechen
Suchergebnisse werden angezeigt für 
Anzeigen  nur  | Stattdessen suchen nach 
Meintest du: 

URGENT! Schedules - Footer Totals - calculation does not add up

14 ANTWORTEN 14
GELÖST
Antworten
Nachricht 1 von 15
laurenk
3514 Aufrufe, 14 Antworten

URGENT! Schedules - Footer Totals - calculation does not add up

I have created an Area Schedule which calculates the total area - as selected in the Formatting tab. (see attached)

The Area's read:

48

43

37

The Footer (totals checkbox) reads:

Total 127

 

As you can see the total is incorrect. This is likely not using the rounded values in the schedule, but calculating based on the true decimal value of each Area.

ie. 47.6 + 42.6 + 36.6 = 126.8 which rounds to 127

 

How can I adjust this to calculate the value as a rounded figure based on the scheduled values?

ie. 48 + 43 + 37 = 128

 

We require this for calculating areas for SALES CONTRACTS - purchasers enter a contract based on the ROUNDED figures.

It needs to be correct for Legal purposes.

 

Can someone please advise how we can proceed without using a text line for the totals??????

 

 

 

Tags (2)
14 ANTWORTEN 14
Nachricht 2 von 15
barthbradley
als Antwort auf: laurenk

See that box that's checked for Project Units: UN-CHECK IT. Then round to 1 decimal place...or 2...or 3...or...am I possibly not understanding the issue?

Nachricht 3 von 15
laurenk
als Antwort auf: barthbradley

We want each Area to round to 1.

We want to calculate the totals of the rounded areas.


ie.
Area 1.1 = Area rounded to 1
Area 1.6 = Area rounded to 2
Area 1.6 = Area rounded to 2


Total based on decimal areas 1.1 + 1.6 + 1.6 = 4.3 (rounded to 4)
Total based on rounded areas = 1 + 2 + 2 = 5

 

When we select the footer to calculate totals - it reads the total based on decimal areas = 4 

We want a total based on the rounded areas = 5

 

Any ideas please?

 

Nachricht 4 von 15
David_W_Koch
als Antwort auf: laurenk

Add a calculated value column to your schedule table, based on your area parameter [round(Area / 1 SF) * 1 SF].  Total this column, and then hide the actual area column.  The total of the calculated value column will be the total of the calculated values, not the raw areas.

2016-08-15_Revit2016_RoundedCalculatedValueInSchedule.png

 

 

 


David Koch
AutoCAD Architecture and Revit User
Blog | LinkedIn
EESignature

Nachricht 5 von 15
barthbradley
als Antwort auf: laurenk

so the issue is that you want Revit to ROUND UP, not conventionally. Then assign a calculated value parameter field: ROUNDUP("AREA PARAMETER NAME"/1). That work for you? 

Nachricht 6 von 15
laurenk
als Antwort auf: David_W_Koch

Thanks so much David!
Alas, I wish we'd known this before the Contracts were issued.
Nachricht 7 von 15
Keith_Wilkinson
als Antwort auf: laurenk

Surely the Revit total without things being rounded is the 'correct' total?  Essentially if you round up and get to 128 rather than 127 you are selling a m2 of floor space you don't actually have?  On a very large building this 'error' could become significant.

 

On our room areas we always show to 2 decimal places and total accordingly.



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Nachricht 8 von 15
laurenk
als Antwort auf: laurenk

This style of calculation is not determined by us mere architects.
We must conform with the standard.
Nachricht 9 von 15
barthbradley
als Antwort auf: laurenk

Intriguing. Are you referring to an industry standard; perhaps an AIA contract standard? Can you cite that governing standard?

 

But nonetheless, clearly from a common-sense perspective: if all the quantities are rounded, then the reported quantities are skewed – and, as Keith rightfully points out:  significantly so depending on the unit of measurement. 

 

Thank God for CAD and BIM. I don't know what I would have done without them the last 25 years. Probably just rounded my guesstimates. 

Nachricht 10 von 15
Keith_Wilkinson
als Antwort auf: barthbradley

Yes, it would be interesting to see the standard that promotes this approach. Do you have a reference @laurenk?



"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Nachricht 11 von 15
laurenk
als Antwort auf: laurenk

I will assume you are in a different state, country and timezone.
I dont have time to debate.
Nachricht 12 von 15
Keith_Wilkinson
als Antwort auf: laurenk

It wasn't really a debate, just a link to the standard for other peoples reference would have been useful all round. Remember people have given up their time to help you with something, it's sometimes nice to do the same in return. But hey ho, it's up to you.


"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Nachricht 13 von 15
laurenk
als Antwort auf: laurenk

I do appreciate your help Keith.
As mentioned earlier, the measurements are based on local real estate sales standards not architectural standards. I would provide these if i had time. Busy busy.
Nachricht 14 von 15
Keith_Wilkinson
als Antwort auf: laurenk

Can you at least let us know what state you are in so that we can avoid buying a house or renting and office there? ;o)


"Give a man a fish and you feed him for a day; teach a man to fish and you feed him for a lifetime."
Maimonides
Nachricht 15 von 15
ToanDN
als Antwort auf: Keith_Wilkinson

They are most likely self-made rule by developers. When a buyer questions the accuracy of the reported area, they just say it is provided by the architect hurr durr...

Sie finden nicht, was Sie suchen? Fragen Sie die Community oder teilen Sie Ihr Wissen mit anderen.

In Foren veröffentlichen  

Autodesk Design & Make Report