{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":38,"n_cols":19,"rows_kept":38,"merged":[[0,0,0,13],[2,0,2,3],[2,5,2,7],[2,9,2,11],[28,11,28,13]],"flags":["formulas_cached_only"]}
["Load Calculation Form"]
[]
["Wiring Info",{"$nulls":4},"Voltage Drop Calculation",{"$nulls":3},"Tap Calculations",{"$nulls":3},"Wattage"]
["Run #","Wiring Size",null,"Total Lamp \nWattage on \nWire Run",null,"Amp Load","Length of \nWire\n(one way)","Voltage \nDrop",null,"Calculated\nTap",null,"Tap to Use",null,"Total Watts"]
[1,12,0.00162,140,null,{"v":11.666666666666666,"d":"11.67"},100,{"v":3.7799999999999994,"d":"3.78"},null,15.78,16,16,null,{"v":186.66666666666666,"d":"187"},{"$nulls":3},18,0.006385]
[2,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0,{"$nulls":3},16,0.004016]
[3,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0,{"$nulls":3},14,0.002525]
[4,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0,{"$nulls":3},12,0.00162]
[5,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0,{"$nulls":3},10,0.00108]
[6,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0,{"$nulls":3},8,0.000628]
[7,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[8,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[9,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[10,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[11,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[12,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[13,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[14,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[15,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[16,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[17,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[18,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[19,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[20,null,"0",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},0,0,null,0]
[{"$nulls":17},0]
[{"$nulls":11},"Actual Total Wattage","=",{"v":186.66666666666666,"d":"187"},{"$nulls":3},12,12]
[{"$nulls":11},"total wattage/.9 (safety factor)","=",207.4074074074074,{"$nulls":3},13,13]
[{"$nulls":17},14,14]
[{"$nulls":9},"Transformer Required:",null,300,{"$nulls":5},15,15]
[{"$nulls":17},16,16]
[{"$nulls":17},17,17]
[{"$nulls":17},18,18]
[{"$nulls":17},19,"Change Wire Size or Reduce Wattage"]
[{"$nulls":17},20,20]
[{"$nulls":17},21,"Change Wire Size or Reduce Wattage"]
[{"$nulls":17},22,22]
[]
[{"$nulls":18},"Wire Size Not Sufficient for Wattage"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}