Forum

Using a reference t...
 
Notifications
Clear all

Using a reference table and applying calculations to subtotalled amounts

5 Posts
2 Users
0 Reactions
66 Views
(@ttsurv)
Posts: 20
Eminent Member
Topic starter
 

Hi,

 

Typically in construction projects, a general contractor manages various subcontractors who carry out tradeworks. They then oversee and take responsibility for these works. The general contractor applies oncosts including preliminaries and margin on top of the tradeworks. The percentage of preliminaries and margin can have a large influence on total project cost.

 

Is it possible to use Power Query to carry out calculations which require to reference subtotals elsewhere in a construction estimate? I have included an Excel file showing what I mean.

 

Thank you

 

Tom

 
Posted : 01/08/2022 10:13 am
(@jstewart)
Posts: 216
Estimable Member
 

Hi Tom,

There is no file attached. After attaching your file click on 'Start Upload' and wait for the grey checkmark before posting.

 
Posted : 02/08/2022 11:45 am
(@ttsurv)
Posts: 20
Eminent Member
Topic starter
 

Thank you Jessica. This should now be attached.

 
Posted : 03/08/2022 1:28 am
(@jstewart)
Posts: 216
Estimable Member
 

Try this on for size, and see how it works for you. 🙂

 
Posted : 03/08/2022 1:02 pm
(@ttsurv)
Posts: 20
Eminent Member
Topic starter
 

Thank you Jessica. This is very clever and let's me run a lot of scenarios with a big error-prone spreadsheet.

 
Posted : 05/08/2022 12:00 am
Share: