Forum Discussion
Using a complex formula
Hey all!
I have created an excel sheet that calculates heat load in a room lets call it a formulas sheet. Now I don´t want to bore anyone with the complexity of this computation. I will just say I will need one output (as a sum of 8 partial final outputs) and there are up to 20 inputs for the formulas to obtain the desired output(s) for a single room. I have made a table with about 50 rooms with assigned parameters for the computation, let´s call it a table of rooms.
Can anyone please help me to use this formulas sheet for calculating heat load of multiple rooms while obtaining a result for every single room? This result should be listed at the end of the formulas sheet along with the partial outputs.
I hope I made it understandable, thank you for your help!
2 Replies
I would define Lambda functions to calculate the heat load and then it can be reused for multiple sets of data. Older technology might include using a Data table (Formulas / What if Analysis).
- It sounds do-able but it's not clear what you're data looks like. If you're able to provide a sample workbook or a link to a host like OneDrive, I'm sure you'll get some formulas suggested.
