This is my revised spreadsheet; the first one I posted here took me about 15 minutes, while this one took a lot longer because I put the time in to do all the references and check the formulas. This spreadsheet is intended to be used WITH the code book and not in lieu of the code book. If something does not seem right, question it.
Once again, if you are not skilled in excel, don’t even bother down loading this.
Revised Kitchen Load Calc Worksheet 1) General Illumination- (1A) Just the minimum table value, and if you know specifically what fixtures are being used then use (1B) instead. Don’t use both.
2) Count them up and put them in.
3) Some restaurants have a show window.
4) Outside lights, remember that if there is even one outside like that a minimum 1200va circuit at 125% is required.
5) Sign circuit, one is required at minimum.
6) Water heater, if it is under 120gal it goes in at 125%
7) List all your known loads (not kitchen) and note which one is the biggest motor load for later.
8) List all your kitchen loads, and the factor from T-220.56 should automatically update. If you need more lines “insert” one in the middle, if you do it on the end it will bork the formula. Also make sure you fill in a quantity or the formula wont work.
9) Heat and AC, note RTU’s are in at zero because the heat is bigger, and AHUs run for heat and AC so they stay in.
10) Largest motor from 7 OR 8
11) Future is not required but I always put it in there for the times when the owner tells me he will be expanding later.
I am still refining this for a cleaner look but it seems to work for now.
