You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
The goal is to have ability to add total/subtotal and even my own total with my own math at the bottom of the table.
Most folks are very used to doing things very similar to Excel where I can say SUM(A2:A30) + 99 ---- and to use that at the very bottom for "custom" totals that I need (based on rates from my power company). Sum & Average would be useful along with a couple of other common math functions. Please see the very bottom of the attachment to see the calculation as a reference point. However, the concept of using portions of the table in a free-form calculation is certainly more important than my actual power usage calculations on the spreadsheet. Please see the attachment and let me know if something is not making sense.
The goal is to have ability to add total/subtotal and even my own total with my own math at the bottom of the table.
Most folks are very used to doing things very similar to Excel where I can say SUM(A2:A30) + 99 ---- and to use that at the very bottom for "custom" totals that I need (based on rates from my power company). Sum & Average would be useful along with a couple of other common math functions. Please see the very bottom of the attachment to see the calculation as a reference point. However, the concept of using portions of the table in a free-form calculation is certainly more important than my actual power usage calculations on the spreadsheet. Please see the attachment and let me know if something is not making sense.
Excel Energy Calc.xlsx
Thanks again for your hard work @fbaligand!!!
The text was updated successfully, but these errors were encountered: