Tom Turner
Member
Members
Forum Posts: 18
Member Since:
March 9, 2022
March 9, 2022
Offline
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
Jessica Stewart
Northern USA
Member
Members
Trusted Members
Trusted Members
Forum Posts: 219
Member Since:
February 13, 2021
February 13, 2021
Offline
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Mynda Treacy, Maria Gonzalez, Jeff Finkelstein
Guest(s) 9
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 286
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Jeffree Bunning
Jackie Memije
John Franzon
Darcie Clayton
trevor mir
Ruby White
Marisa Bradshaw
Eugene Augustine
MacNaughton Finance
Tanu Rai
Forum Stats:
Groups: 3
Forums: 24
Topics: 6872
Posts: 30117
Member Stats:
Guest Posters: 49
Members: 33667
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —