Last Leg
Member
- Location
- Houston, TX
I have a panel schedule I set up on Excel. It adds up the phases, etc, and at the bottom I have misc. catagories - ltg, A/C, largest motor, etc w/ their respective code demands to give me my demand loads. I set up a column adjacent to the circuit numbers to which I want to assign letter (a,b,c...) corresponding to the catagories. How do I write a formula that will insert the corresonding watts into a column so that I can transfer that total automatically to the demand catagories at the bottom?
I want to say - If (my new column) B8=a then (my work column) M8 = (the watts entered on my panel schedule) E8. Can you help?
I want to say - If (my new column) B8=a then (my work column) M8 = (the watts entered on my panel schedule) E8. Can you help?