{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["3+1 Estimator","1+1 Estimator","Sheet1","Wire Types","Constant and Variable Data"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"3+1 Estimator","index":0,"n_rows":78,"n_cols":8,"rows_kept":78,"cut":false,"hidden":false,"merged":[[39,2,39,5],[40,2,41,6],[42,2,42,6],[43,2,45,2],[43,3,45,3],[43,4,45,4],[43,5,45,5],[43,6,45,6],[50,3,50,6],[51,3,51,4],[51,5,51,6],[52,3,52,4],[52,5,52,6],[56,6,58,6],[64,3,64,6],[55,3,55,7],[65,3,67,3],[65,4,67,4],[65,5,67,5],[65,6,67,6],[56,7,58,7],[37,8,48,10],[13,6,15,6],[22,2,23,6],[24,2,24,5],[25,2,26,6],[27,2,27,6],[28,2,30,2],[37,2,38,6],[28,3,30,3],[28,4,30,4],[28,5,30,5],[28,6,30,6],[22,8,33,10],[13,2,15,2],[13,3,15,3],[13,4,15,4],[1,4,1,5],[61,2,61,4],[63,2,63,4],[70,2,70,6],[71,2,72,6],[4,2,4,7],[9,2,9,5],[10,2,11,6],[12,2,12,6],[13,5,15,5],[1,2,2,3],[2,4,2,6],[7,2,8,6],[56,3,58,3],[56,4,58,4],[56,5,58,5]]}
[]
[null,null,null,null,"  JOB/ORDER:___________________",null,"DATE:__________"]
[null,null,null,null," CUSTOMER:____________________________________"]
[]
[null,null,"3+1 Estimator"]
[]
[]
[null,null,"Step 1: Choose Your Wire Type for 1st Run In Yellow Box"]
[]
[null,null,"Type of Wire - 1st Run",null,null,null,"SELECT"]
[null,null,"Step 2: Choose Your Wire Gauge and Enter Wire Length For Each Compartment In Yellow Boxes"]
[]
[null,null," Gauge and Length of Wire - 1st Run"]
[null,null,"Reel Compartment","#1","#2","#3","#4 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"'Constant and Variable Data'!M2","v":4.0336362129898262E+20},{"$f":"'Constant and Variable Data'!N2","v":4.0336362129898262E+20},{"$f":"'Constant and Variable Data'!O2","v":4.0336362129898262E+20},{"$f":"'Constant and Variable Data'!P2","v":4.0336362129898262E+20}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length"]
[]
[]
[]
[null,null,"Step 3: (Only For Use If Stacking) Choose Your Wire Type for 2nd Run In Yellow Box"]
[]
[null,null,"Type of Wire - 2nd Run",null,null,null,"SELECT"]
[null,null,"Step 4: (Only For Use If Stacking) Choose Your Wire Gauge and Enter Wire Length For Each Compartment In Yellow Boxes"]
[]
[null,null,"Gauge and Length of Wire - 2nd Run"]
[null,null,"Reel Compartment","#1","#2","#3","#4 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"IF(ABS('Constant and Variable Data'!M7)>100000,\"##################\",'Constant and Variable Data'!M7)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!N7)>100000,\"##################\",'Constant and Variable Data'!N7)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!O7)>100000,\"##################\",'Constant and Variable Data'!O7)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!P7)>100000,\"##################\",'Constant and Variable Data'!P7)","v":"##################"}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length"]
[null,null,null,null,null,null,123]
[]
[]
[null,null,"Step 5: (Only For Use If Stacking) Choose Your Wire Type for 3rd Run In Yellow Box"]
[]
[null,null,"Type of Wire - 3rd Run",null,null,null,"SELECT"]
[null,null,"Step 6: (Only For Use If Stacking) Choose Your Wire Gauge and Enter Wire Length for Each Compartment In Yellow Boxes"]
[]
[null,null,"Gauge and Length of Wire - 3rd Run"]
[null,null,"Reel Compartment","#1","#2","#3","#4 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"IF(ABS('Constant and Variable Data'!M12)>100000,\"##################\",'Constant and Variable Data'!M12)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!N12)>100000,\"##################\",'Constant and Variable Data'!N12)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!O12)>100000,\"##################\",'Constant and Variable Data'!O12)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!P12)>100000,\"##################\",'Constant and Variable Data'!P12)","v":"##################"}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length"]
[]
[null,null,null,"Results"]
[null,null,null,"Will the Total Wire Length Fit on the ReelRover?",null,"Will the Total Wire Weight Be Under the 2000LB Limit?"]
[null,null,null,{"$f":"IF(OR(D69>100%, E69>100%, F69>100%, G69>100%),\"NO\",\"YES\")","v":"YES"},null,{"$f":"IF(H60<=2000, \"YES\", \"NO\")","v":"YES"}]
[]
[]
[null,null,null,"Wire Weight Estimate Per Compartment (lbs)"]
[null,null,null,"Wire Weight  Compartment #1","Wire Weight Compartment #2","Wire Weight Compartment #3","Wire Weight Compartment #4","Total Wire Weight for All Compartments"]
[]
[]
[null,null,null,{"$f":"SUM((D19*'Constant and Variable Data'!B5)+(D34*'Constant and Variable Data'!B10)+(D49*'Constant and Variable Data'!B15))","v":0},{"$f":"SUM((E19*'Constant and Variable Data'!C5)+(E34*'Constant and Variable Data'!C10)+(E49*'Constant and Variable Data'!C15))","v":0},{"$f":"SUM((F19*'Constant and Variable Data'!D5)+(F34*'Constant and Variable Data'!D10)+(F49*'Constant and Variable Data'!D15))","v":0},{"$f":"SUM((G19*'Constant and Variable Data'!E5)+(G34*'Constant and Variable Data'!E10)+(G49*'Constant and Variable Data'!E15))","v":0},{"$f":"SUM(D60+E60+F60+G60)","v":0}]
[]
[null,null,"Total Wire Weight:",null,null,{"$f":"H60","v":0},"LBS"]
[]
[null,null,"Loaded ReelRover Weight:",null,null,{"$f":"SUM(700+F62)","v":700},"LBS"]
[null,null,null,"Total Wire Length Capacity Per Compartment Estimate (ft)"]
[null,null,null,"Wire Length Compartment #1 (%Full)","Wire Length Compartment #2 (%Full)","Wire Length Compartment #3 (%Full)","Wire Length Compartment #4 (Free-Spinning) (%Full)"]
[]
[]
[null,null,null,{"$f":"'Constant and Variable Data'!M15","v":0},{"$f":"'Constant and Variable Data'!N15","v":0},{"$f":"'Constant and Variable Data'!O15","v":0},{"$f":"'Constant and Variable Data'!P15","v":0}]
[]
[null,null,"Conclusion"]
[null,null,{"$f":"IF(AND(D53=\"YES\",F53=\"YES\"),\"Loading Successful\",\"Incorrect Loading - Correct Items Highlighted In Red Before Loading ReelRover\")","v":"Loading Successful"}]
[]
[]
[null,null,null,null," 1099 Thompson Road SE"]
[null,null,null,null,"Hartselle, AL 35640"]
[null,null,null,null,"256.773.2522",null,"Revision C 07/2020"]
[null,null,null,null,"Cerrowire.com"]

{"sheet":"1+1 Estimator","index":1,"n_rows":83,"n_cols":9,"rows_kept":83,"cut":false,"hidden":false,"merged":[[1,2,2,3],[1,4,1,6],[2,4,2,7],[7,2,8,7],[7,9,20,11],[9,2,9,7],[12,2,13,7],[15,7,17,7],[4,2,4,7],[24,9,37,11],[32,7,34,7],[41,9,54,11],[49,7,51,7],[14,2,14,7],[15,2,17,2],[15,3,17,3],[15,4,17,4],[15,5,17,5],[15,6,17,6],[24,2,25,7],[26,2,26,7],[29,2,30,7],[31,2,31,7],[32,2,34,2],[32,3,34,3],[32,4,34,4],[32,5,34,5],[32,6,34,6],[41,2,42,7],[43,2,43,7],[46,2,47,7],[48,2,48,7],[49,2,51,2],[49,3,51,3],[49,6,51,6],[49,4,51,4],[49,5,51,5],[61,3,63,3],[61,4,63,4],[61,5,63,5],[61,6,63,6],[56,3,56,6],[57,3,57,4],[57,5,57,6],[58,5,58,6],[60,2,60,7],[58,3,58,4],[79,4,79,5],[80,4,80,5],[81,4,81,5],[82,4,82,5],[61,7,63,7],[70,6,72,6],[75,2,75,7],[76,2,77,7],[66,2,66,5],[68,2,68,5],[69,2,69,6],[70,2,72,2],[70,3,72,3],[70,4,72,4],[70,5,72,5],[61,2,63,2]]}
[]
[null,null,null,null,"    JOB/ORDER:_____________________________________",null,null,"DATE:___________"]
[null,null,null,null,"   CUSTOMER:_______________________________________________________"]
[]
[null,null,"1+1 Estimator"]
[]
[]
[null,null,"Step 1: Choose Your Wire Type for 1st Run In Yellow Boxes"]
[]
[null,null,"Types of Wire - 1st Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[null,null,"Wire Type","SELECT","SELECT","SELECT","SELECT","SELECT"]
[null,null,"Step 2: Choose Your Wire Gauge and Enter Wire Length For Each Compartment In Yellow Boxes"]
[]
[null,null," Gauge and Length of Wire - 1st Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"'Constant and Variable Data'!M18","v":1.2608556513579906E+21},{"$f":"'Constant and Variable Data'!N18","v":1.2608556513579906E+21},{"$f":"'Constant and Variable Data'!O18","v":1.2608556513579906E+21},{"$f":"'Constant and Variable Data'!P18","v":1.2608556513579906E+21},{"$f":"'Constant and Variable Data'!Q18","v":4.0336362129898262E+20}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length"]
[]
[]
[]
[null,null,"Step 3: (Only For Use If Stacking) Choose Your Wire Type for 2nd Run In Yellow Box"]
[]
[null,null,"Type of Wire - 2nd Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[null,null,"Wire Type","SELECT","SELECT","SELECT","SELECT","SELECT"]
[null,null,"Step 4: (Only For Use If Stacking) Choose Your Wire Gauge and Enter Wire Length For Each Compartment In Yellow Boxes"]
[]
[null,null,"Gauge and Length of Wire - 2nd Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"IF(ABS('Constant and Variable Data'!M23)>100000,\"##################\",'Constant and Variable Data'!M23)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!N23)>100000,\"##################\",'Constant and Variable Data'!N23)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!O23)>100000,\"##################\",'Constant and Variable Data'!O23)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!P23)>100000,\"##################\",'Constant and Variable Data'!P23)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!Q23)>100000,\"##################\",'Constant and Variable Data'!Q23)","v":"##################"}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length"]
[]
[]
[]
[null,null,"Step 5: (Only For Use If Stacking) Choose Your Wire Type for 3rd Run In Yellow Box"]
[]
[null,null,"Type of Wire - 3rd Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[null,null,"Wire Type","SELECT","SELECT","SELECT","SELECT","SELECT"]
[null,null,"Step 6: (Only For Use If Stacking) Choose Your Wire Gauge and Enter Wire Length for Each Compartment In Yellow Boxes"]
[]
[null,null,"Gauge and Length of Wire - 3rd Run"]
[null,null,"Number of Wires (Parallel)","Wire #1","Wire #2","Wire #3","Wire #4","Wire #5 (Free-Spinning)"]
[]
[]
[null,null,"Wire Gauge","EMPTY","EMPTY","EMPTY","EMPTY","EMPTY"]
[null,null,"Estimated Maximum Length (Ft)",{"$f":"IF(ABS('Constant and Variable Data'!M28)>100000,\"##################\",'Constant and Variable Data'!M28)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!N28)>100000,\"##################\",'Constant and Variable Data'!N28)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!O28)>100000,\"##################\",'Constant and Variable Data'!O28)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!P28)>100000,\"##################\",'Constant and Variable Data'!P28)","v":"##################"},{"$f":"IF(ABS('Constant and Variable Data'!Q28)>100000,\"##################\",'Constant and Variable Data'!Q28)","v":"##################"}]
[null,null,"Wire Length (Ft) Must Be Lower Than Maximum Length",null,null,null,null,null,4]
[]
[null,null,null,"Results"]
[null,null,null,"Will the Total Wire Length Fit on the ReelRover?",null,"Will the Total Wire Weight Be Under the 2000LB Limit?"]
[null,null,null,{"$f":"IF(OR(C74>100%, D74>100%, E74>100%, F74>100%,G74>100%),\"NO\",\"YES\")","v":"YES"},null,{"$f":"IF(H65<=2000, \"YES\", \"NO\")","v":"YES"}]
[]
[null,null,"Wire Weight Estimate Per Compartment (lbs)"]
[null,null,"Wire Weight  Compartment #1","Wire Weight Compartment #2","Wire Weight Compartment #3","Wire Weight Compartment #4","Wire Weight Compartment #5","Total Wire Weight for All Compartments"]
[]
[]
[null,null,{"$f":"SUM((D21*'Constant and Variable Data'!B21)+(D38*'Constant and Variable Data'!B26)+(D55*'Constant and Variable Data'!B31))","v":0},{"$f":"SUM((E21*'Constant and Variable Data'!C21)+(E38*'Constant and Variable Data'!C26)+(E55*'Constant and Variable Data'!C31))","v":0},{"$f":"SUM((F21*'Constant and Variable Data'!D21)+(F38*'Constant and Variable Data'!D26)+(F55*'Constant and Variable Data'!D31))","v":0},{"$f":"SUM((G21*'Constant and Variable Data'!E21)+(G38*'Constant and Variable Data'!E26)+(G55*'Constant and Variable Data'!E31))","v":0},{"$f":"SUM((H21*'Constant and Variable Data'!F21)+(H38*'Constant and Variable Data'!F26)+(H55*'Constant and Variable Data'!F31))","v":0},{"$f":"SUM(C65+D65+E65+F65+G65)","v":0}]
[]
[null,null,"Total Wire Weight:",null,null,null,{"$f":"H65","v":0},"LBS"]
[]
[null,null,"Loaded ReelRover Weight:",null,null,null,{"$f":"SUM(700+G67)","v":700},"LBS"]
[null,null,"Total Wire Length Capacity Per Compartment Estimate (ft)"]
[null,null,"Wire Length Compartment #1 (%Full)","Wire Length Compartment #2 (%Full)","Wire Length Compartment #3 (%Full)","Wire Length Compartment #4 (%Full)","Wire Length Compartment #5 (Free-Spinning) (%Full)"]
[]
[]
[null,null,{"$f":"'Constant and Variable Data'!M31","v":0},{"$f":"'Constant and Variable Data'!N31","v":0},{"$f":"'Constant and Variable Data'!O31","v":0},{"$f":"'Constant and Variable Data'!P31","v":0},{"$f":"'Constant and Variable Data'!Q31","v":0}]
[]
[null,null,"Conclusion"]
[null,null,{"$f":"IF(AND(D59=\"YES\",F59=\"YES\"),\"Loading Successful\",\"Incorrect Loading - Correct Items Highlighted In Red Before Loading ReelRover\")","v":"Loading Successful"}]
[]
[]
[null,null,null,null," 1099 Thompson Road SE"]
[null,null,null,null,"Hartselle, AL 35640"]
[null,null,null,null,"256.773.2522",null,null,"Revision C 07/2020"]
[null,null,null,null,"Cerrowire.com"]

{"sheet":"Sheet1","index":2,"n_rows":36,"n_cols":7,"rows_kept":36,"cut":false,"hidden":true,"merged":[[1,1,3,6],[5,1,5,5],[7,1,7,5],[8,1,10,1],[8,2,10,2],[8,3,10,3],[8,4,10,4],[8,5,10,5],[13,1,13,5],[15,1,15,5],[16,1,18,4],[16,5,18,5],[19,1,19,4],[21,1,21,4],[26,1,28,4],[29,1,29,4],[31,1,31,5],[32,1,34,4],[32,5,34,5],[35,1,35,4],[22,1,22,2],[22,3,22,4],[23,1,23,2],[23,3,23,4],[25,1,25,6],[26,5,28,5],[26,6,28,6]]}
[]
[null,"ReelRover 1+1 Configuration - Wire Loading Estimator"]
[]
[]
[]
[null,"Enter Length of Each Wire In the Compartments (Feet) in Yellow Box Below (leave blank if not applicable):"]
[]
[null,"Length of Wire"]
[null,"Length of 1st Wire in Compartment","Length of 2nd Wire in Compartment","Length of 3rd Wire in Compartment","Length of 4th Wire in Compartment","Length of Wire in Free-Spinning Compartment "]
[]
[]
[null,284,284,284,284,262]
[]
[null,"Click Yellow Box Below to Select Type of Wire from Drop-Down List:"]
[]
[null,"Type of Wire"]
[null,"Type of Wire in Compartment #1",null,null,null,"Ground Wire in Compartment #2              (Free-Spinning)"]
[]
[]
[null,"Copper 600 THHN",null,null,null,"Copper 600 THHN"]
[]
[null,"Conclusions"]
[null,"Will the Total Wire Length Fit on the ReelRover?",null,"Will the Total Wire Weight Be Under the 2000lb Limit?"]
[null,{"$f":"IF((OR(B36+1<B12, B36+1<C12, B36+1<D12, B36+1<E12,F36+1<F12 )),\"NO\",\"YES\")","v":{"$error":"#DIV/0!"}},null,{"$f":"IF(G30<=2000, \"YES\", \"NO\")","v":"YES"}]
[]
[null,"Wire Weight Estimate Per Compartment (lbs)"]
[null,"Wire Weight Compartment #1",null,null,null,"Total Wire Weight Free-Spinning Compartment","Total Wire Weight for All Compartments"]
[]
[]
[null,{"$f":"SUM((B12*'Constant and Variable Data'!B21)+(C12*'Constant and Variable Data'!B21)+(D12*'Constant and Variable Data'!B21)+(E12*'Constant and Variable Data'!B21))","v":1.136E-8},null,null,null,{"$f":"SUM(F12*'Constant and Variable Data'!C21)","v":2.6200000000000005E-9},{"$f":"SUM(B30+C30+D30+E30+F30)","v":1.398E-8}]
[]
[null,"Total Wire Length Capacity Per Compartment Estimate (ft)"]
[null,"Wire Length Capacity Compartment #1",null,null,null,"Wire Length Capacity Free-Spinning Compartment "]
[]
[]
[null,{"$f":"(3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B20))*(0.95*'Constant and Variable Data'!B20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B20))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!B20)/'Constant and Variable Data'!K20)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C20))*(0.95*'Constant and Variable Data'!C20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C20))*TRUNC(0.85*'Constant and Variable Data'!J20/'Constant and Variable Data'!C20)","v":4.0336362129898262E+20}]

{"sheet":"Wire Types","index":3,"n_rows":154,"n_cols":7,"rows_kept":154,"cut":false,"hidden":true,"merged":[]}
["Wire Type",null,null,null,"CopperTHHN Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
["CopperTHHN",null,null,null,"8 AWG THHN CU",0.216,61]
["CopperXHHW",null,null,null,"6 AWG THHN CU",0.254,93]
["AluminumTHHN",null,null,null,"4 AWG THHN CU",0.32400000000000001,149.11000000000001]
["AluminumXHHW",null,null,null,"3 AWG THHN CU",0.36199999999999999,184]
["CU_MC_Circuit",null,null,null,"2 AWG THHN CU",0.38400000000000001,225.08]
["CU_MC_Intermediate_and_Feeder",null,null,null,"1 AWG THHN CU",0.44600000000000001,287.99]
["AL_MC_Intermediate_and_Feeder",null,null,null,"1/0 AWG THHN CU",0.48599999999999999,356.74]
["SELECT",null,null,null,"2/0 AWG THHN CU",0.53200000000000003,441.14]
[null,null,null,null,"3/0 AWG THHN CU",0.58399999999999996,550.45000000000005]
[null,null,null,null,"4/0 AWG THHN CU",0.64200000000000002,692.2]
[null,null,null,null,"250 MCM THHN CU",0.71099999999999997,824.8]
[null,null,null,null,"300 MCM THHN CU",0.76600000000000001,984.5]
[null,null,null,null,"350 MCM THHN CU",0.81699999999999995,1142.27]
[null,null,null,null,"400 MCM THHN CU",0.86399999999999999,1296.06]
[null,null,null,null,"500 MCM THHN CU",0.94899999999999995,1598.67]
[null,null,null,null,"600 MCM THHN CU",1.0509999999999999,1933.88]
[null,null,null,null,"750 MCM THHN CU",1.1559999999999999,2423.79]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null,"CopperXHHW Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"8 AWG XHHW CU",0.23300000000000001,63]
[null,null,null,null,"6 AWG XHHW CU",0.27200000000000002,95]
[null,null,null,null,"4 AWG XHHW CU",0.318,145]
[null,null,null,null,"3 AWG XHHW CU",0.34599999999999997,180]
[null,null,null,null,"2 AWG XHHW CU",0.377,223]
[null,null,null,null,"1 AWG XHHW CU",0.433,281]
[null,null,null,null,"1/0 AWG XHHW CU",0.47099999999999997,348]
[null,null,null,null,"2/0 AWG XHHW CU",0.51500000000000001,434]
[null,null,null,null,"3/0 AWG XHHW CU",0.56399999999999995,541]
[null,null,null,null,"4/0 AWG XHHW CU",0.62,674]
[null,null,null,null,"250 MCM XHHW CU",0.68500000000000005,813]
[null,null,null,null,"300 MCM XHHW CU",0.73499999999999999,973]
[null,null,null,null,"350 MCM XHHW CU",0.78400000000000003,1121]
[null,null,null,null,"400 MCM XHHW CU",0.83099999999999996,1280]
[null,null,null,null,"500 MCM XHHW CU",0.91500000000000004,1587]
[null,null,null,null,"600 MCM XHHW CU",1.04,1919]
[null,null,null,null,"750 MCM XHHW CU",1.143,2417]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null,"AluminumTHHN Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"8 AWG THHN AL",0.20399999999999999,26]
[null,null,null,null,"6 AWG THHN AL",0.23899999999999999,37]
[null,null,null,null,"4 AWG THHN AL",0.30499999999999999,60]
[null,null,null,null,"3 AWG THHN AL",0.33,73]
[null,null,null,null,"2 AWG THHN AL",0.36,88]
[null,null,null,null,"1 AWG THHN AL",0.41299999999999998,115]
[null,null,null,null,"1/0 AWG THHN AL",0.45,139]
[null,null,null,null,"2/0 AWG THHN AL",0.49,169]
[null,null,null,null,"3/0 AWG THHN AL",0.53700000000000003,206]
[null,null,null,null,"4/0 AWG THHN AL",0.58899999999999997,253]
[null,null,null,null,"250 MCM THHN AL",0.65600000000000003,306]
[null,null,null,null,"300 MCM THHN AL",0.70599999999999996,359]
[null,null,null,null,"350 MCM THHN AL",0.752,411]
[null,null,null,null,"400 MCM THHN AL",0.79500000000000004,463]
[null,null,null,null,"500 MCM THHN AL",0.872,568]
[null,null,null,null,"600 MCM THHN AL",0.97099999999999997,690]
[null,null,null,null,"750 MCM THHN AL",1.0660000000000001,844]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null,"AluminumXHHW Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"8 AWG XHHW AL",0.224,27]
[null,null,null,null,"6 AWG XHHW AL",0.25900000000000001,38]
[null,null,null,null,"4 AWG XHHW AL",0.3,56]
[null,null,null,null,"3 AWG XHHW AL",0.32800000000000001,67]
[null,null,null,null,"2 AWG XHHW AL",0.35799999999999998,82]
[null,null,null,null,"1 AWG XHHW AL",0.40899999999999997,106]
[null,null,null,null,"1/0 AWG XHHW AL",0.44600000000000001,129]
[null,null,null,null,"2/0 AWG XHHW AL",0.48599999999999999,158]
[null,null,null,null,"3/0 AWG XHHW AL",0.53300000000000003,195]
[null,null,null,null,"4/0 AWG XHHW AL",0.58499999999999996,240]
[null,null,null,null,"250 MCM XHHW AL",0.65,288]
[null,null,null,null,"300 MCM XHHW AL",0.7,338]
[null,null,null,null,"350 MCM XHHW AL",0.746,390]
[null,null,null,null,"400 MCM XHHW AL",0.78900000000000003,441]
[null,null,null,null,"500 MCM XHHW AL",0.86599999999999999,543]
[null,null,null,null,"600 MCM XHHW AL",0.97299999999999998,664]
[null,null,null,null,"750 MCM XHHW AL",1.0680000000000001,815]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null,"MC_Circuit Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"12-2 MC CU",0.48699999999999999,106]
[null,null,null,null,"12-3 MC CU",0.495,132]
[null,null,null,null,"12-4 MC CU",0.50900000000000001,158]
[null,null,null,null,"10-2 MC CU",0.51,153]
[null,null,null,null,"10-3 MC CU",0.54900000000000004,193]
[null,null,null,null,"10-4 MC CU",0.59199999999999997,233]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null," Copper MC Intermediate and Feeder Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"8-3 MC CU",0.81299999999999994,296]
[null,null,null,null,"8-4 MC CU",0.84799999999999998,362.5]
[null,null,null,null,"6-3 MC CU",0.94499999999999995,428.7]
[null,null,null,null,"6-4 MC CU",1.026,532]
[null,null,null,null,"4-3 MC CU",1.0569999999999999,616.70000000000005]
[null,null,null,null,"4-4 MC CU",1.08,845]
[null,null,null,null,"3-3 MC CU",1.1080000000000001,788.4]
[null,null,null,null,"3-4 MC CU",1.1559999999999999,983.3]
[null,null,null,null,"2-3 MC CU",1.1519999999999999,956]
[null,null,null,null,"2-4 MC CU",1.2250000000000001,1208.3]
[null,null,null,null,"1-3 MC CU",1.3129999999999999,1191.2]
[null,null,null,null,"1-4 MC CU",1.3560000000000001,1506]
[null,null,null,null,"1/0-3 MC CU",1.31,1398]
[null,null,null,null,"1/0-4 MC CU",1.43,1789]
[null,null,null,null,"2/0-3 MC CU",1.41,1689]
[null,null,null,null,"2/0-4 MC CU",1.55,2174]
[null,null,null,null,"3/0-3 MC CU",1.51,2098]
[null,null,null,null,"3/0-4 MC CU",1.65,2700]
[null,null,null,null,"4/0-3 MC CU",1.63,2586]
[null,null,null,null,"4/0-4 MC CU",1.79,3295]
[null,null,null,null,"250/3 MC CU",1.81,3123]
[null,null,null,null,"250/4 MC CU",1.99,4027]
[null,null,null,null,"300/3 MC CU",1.93,3654]
[null,null,null,null,"300/4 MC CU",2.13,4717]
[null,null,null,null,"350/3 MC CU",2.0499999999999998,4224]
[null,null,null,null,"350/4 MC CU",2.25,5465]
[null,null,null,null,"400/3 MC CU",2.17,4712]
[null,null,null,null,"400/4 MC CU",2.37,6104]
[null,null,null,null,"500/3 MC CU",2.33,5842]
[null,null,null,null,"500/4 MC CU",2.57,7585]
[null,null,null,null,"600/3 MC CU",2.57,6948.8]
[null,null,null,null,"600/4 MC CU",2.85,9040]
[null,null,null,null,"750/3 MC CU",2.85,8618]
[null,null,null,null,"750/4 MC CU",3.09,11212]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]
[null,null,null,null," Aluminum MC Intermediate and Feeder Wire Gauge","Single Wire Diameter","Wire Weight /1000'"]
[null,null,null,null,"6-3 MC AL",0.74099999999999999,215]
[null,null,null,null,"6-4 MC AL",0.80500000000000005,257]
[null,null,null,null,"4-3 MC AL",0.874,295]
[null,null,null,null,"4-4 MC AL",0.95599999999999996,363]
[null,null,null,null,"3-3 MC AL",0.97199999999999998,336]
[null,null,null,null,"3-4 MC AL",1.069,418]
[null,null,null,null,"2-3 MC AL",0.998,406]
[null,null,null,null,"2-4 MC AL",1.0920000000000001,504]
[null,null,null,null,"1-3 MC AL",1.1200000000000001,505]
[null,null,null,null,"1-4 MC AL",1.2430000000000001,650]
[null,null,null,null,"1/0-3 MC AL",1.19,602]
[null,null,null,null,"1/0-4 MC AL",1.304,758]
[null,null,null,null,"2/0-3 MC AL",1.276,705]
[null,null,null,null,"2/0-4 MC AL",1.401,893]
[null,null,null,null,"3/0-3 MC AL",1.38,833]
[null,null,null,null,"3/0-4 MC AL",1.61,1138]
[null,null,null,null,"4/0-3 MC AL",1.59,1089]
[null,null,null,null,"4/0-4 MC AL",1.74,1374]
[null,null,null,null,"250/3 MC AL",1.7350000000000001,1292]
[null,null,null,null,"250/4 MC AL",1.91,1635]
[null,null,null,null,"300/3 MC AL",1.84,1474]
[null,null,null,null,"300/4 MC AL",2.02,1873]
[null,null,null,null,"350/3 MC AL",1.94,1653]
[null,null,null,null,"350/4 MC AL",2.13,2129]
[null,null,null,null,"400/3 MC AL",2.04,1830]
[null,null,null,null,"400/4 MC AL",2.2400000000000002,2420]
[null,null,null,null,"500/3 MC AL",2.42,2373]
[null,null,null,null,"500/4 MC AL",2.42,2955]
[null,null,null,null,"600/3 MC AL",2.6619999999999999,2930]
[null,null,null,null,"600/4 MC AL",2.94,3684]
[null,null,null,null,"750/3 MC AL",2.891,3777]
[null,null,null,null,"750/4 MC AL",3.2,4696]
[null,null,null,null,"EMPTY",1.0000000000000001E-9,1E-8]

{"sheet":"Constant and Variable Data","index":4,"n_rows":31,"n_cols":17,"rows_kept":31,"cut":false,"hidden":true,"merged":[[17,0,17,7],[22,0,22,7],[27,0,27,7],[0,0,0,7],[1,0,1,7],[6,0,6,7],[11,0,11,7],[16,0,16,7]]}
["ReelRover v3.6 3+1 Configuration",null,null,null,null,null,null,null,null,null,null,null,"Length Capactiy #1","Length Capacity #2","Length Capacity #3","Length Capacity #4"]
["1ST RUN",null,null,null,null,null,null,null,null,null,null,"Total Available",{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B4))*(0.95*'Constant and Variable Data'!B4)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B4))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!B4)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C4))*(0.95*'Constant and Variable Data'!C4)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C4))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!C4)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D4))*(0.95*'Constant and Variable Data'!D4)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D4))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!D4)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E4))*(0.95*'Constant and Variable Data'!E4)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E4))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!E4)","v":4.0336362129898262E+20}]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4","Flange","Drum","Traverse ",null,null,null,"Length 1 Entered",{"$f":"'3+1 Estimator'!D19","v":0},{"$f":"'3+1 Estimator'!E19","v":0},{"$f":"'3+1 Estimator'!F19","v":0},{"$f":"'3+1 Estimator'!G19","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('3+1 Estimator'!D17,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!E17,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!F17,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!G17,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},40,16,5.125,null,null,null,"% Occupied by 1",{"$f":"SUM(M3/M2)","v":0},0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('3+1 Estimator'!D17,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!E17,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!F17,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!G17,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,null,null,"% Available",{"$f":"SUM(1-M4)","v":1},1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B9))*(0.95*'Constant and Variable Data'!B9)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B9))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!B9)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C9))*(0.95*'Constant and Variable Data'!C9)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C9))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!C9)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D9))*(0.95*'Constant and Variable Data'!D9)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D9))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!D9)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E9))*(0.95*'Constant and Variable Data'!E9)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E9))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!E9)","v":4.0336362129898262E+20}]
["2ND RUN",null,null,null,null,null,null,null,null,null,null,"Total Available",{"$f":"SUM(M6*M5)","v":4.0336362129898262E+20},4.0336362129898262E+20,4.0336362129898262E+20,4.0336362129898262E+20]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4",null,null,null,null,null,null,"Length 2 Entered",{"$f":"'3+1 Estimator'!D34","v":0},{"$f":"'3+1 Estimator'!E34","v":0},{"$f":"'3+1 Estimator'!F34","v":0},{"$f":"'3+1 Estimator'!G34","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('3+1 Estimator'!D32,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!E32,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!F32,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!G32,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},null,null,null,null,null,null,"% Occupied by 2",{"$f":"SUM(M8/M6)","v":0},0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('3+1 Estimator'!D32,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!E32,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!F32,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!G32,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,null,null,"% Available",{"$f":"SUM(1-(M9+M4))","v":1},1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B14))*(0.95*'Constant and Variable Data'!B14)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!B14))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!B14)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C14))*(0.95*'Constant and Variable Data'!C14)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!C14))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!C14)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D14))*(0.95*'Constant and Variable Data'!D14)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!D14))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!D14)","v":4.0336362129898262E+20},{"$f":"3.14159/12*(+'Constant and Variable Data'!G4+(TRUNC(('Constant and Variable Data'!F4-(2*0)-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E14))*(0.95*'Constant and Variable Data'!E14)))*TRUNC(('Constant and Variable Data'!F4-2*0-'Constant and Variable Data'!G4)/(1.9*'Constant and Variable Data'!E14))*TRUNC(0.85*'Constant and Variable Data'!H4/'Constant and Variable Data'!E14)","v":4.0336362129898262E+20}]
["3RD RUN",null,null,null,null,null,null,null,null,null,null,"Total Available",{"$f":"SUM(M10*M11)","v":4.0336362129898262E+20},4.0336362129898262E+20,4.0336362129898262E+20,4.0336362129898262E+20]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4",null,null,null,null,null,null,"Length 3 Entered",{"$f":"'3+1 Estimator'!D49","v":0},{"$f":"'3+1 Estimator'!E49","v":0},{"$f":"'3+1 Estimator'!F49","v":0},{"$f":"'3+1 Estimator'!G49","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('3+1 Estimator'!D47,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!E47,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!F47,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('3+1 Estimator'!G47,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},null,null,null,null,null,null,"% Occupied by 3",{"$f":"SUM(M13/M11)","v":0},0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('3+1 Estimator'!D47,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!E47,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!F47,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('3+1 Estimator'!G47,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,null,null,"Total % Occupied",{"$f":"ROUNDDOWN(SUM(M14+M9+M4),3)","v":0},0,0,0]
[]
["ReelRover v3.6 1+1 Configuration",null,null,null,null,null,null,null,null,null,null,null,"Length Capactiy #1","Length Capacity #2","Length Capacity #3","Length Capacity #4","Length Capacity #5"]
["1ST RUN",null,null,null,null,null,null,null,null,null,null,"Total Available",{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B20))*(0.95*'Constant and Variable Data'!B20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B20))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!B20)/K24","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C20))*(0.95*'Constant and Variable Data'!C20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C20))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!C20)/K24","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D20))*(0.95*'Constant and Variable Data'!D20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D20))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!D20)/K24","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E20))*(0.95*'Constant and Variable Data'!E20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E20))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!E20)/K24","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F20))*(0.95*'Constant and Variable Data'!F20)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F20))*TRUNC(0.85*'Constant and Variable Data'!J20/'Constant and Variable Data'!F20)","v":4.0336362129898262E+20}]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4","Selected Wire Diameter Compartment #5","Flange","Drum","Conductor Traverse","Ground Traverse","Count","Length 1 Entered",{"$f":"'1+1 Estimator'!D21","v":0},{"$f":"'1+1 Estimator'!E21","v":0},{"$f":"'1+1 Estimator'!F21","v":0},{"$f":"'1+1 Estimator'!G21","v":0},{"$f":"'1+1 Estimator'!H21","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('1+1 Estimator'!D19,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!E19,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!F19,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!G19,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!H19,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},40,16,16.02,5.125,{"$f":"COUNT('1+1 Estimator'!D21:G21)","v":0},"% Occupied by 1",{"$f":"SUM(M19/M18)","v":0},0,0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('1+1 Estimator'!D19,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!E19,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!F19,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!G19,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!H19,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,{"$f":"COUNT('1+1 Estimator'!D38:G38)","v":0},"% Available",{"$f":"SUM(1-M20)","v":1},1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT('1+1 Estimator'!D55:G55)","v":0},"Total",{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B25))*(0.95*'Constant and Variable Data'!B25)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B25))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!B25)/K25","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C25))*(0.95*'Constant and Variable Data'!C25)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C25))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!C25)/K25","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D25))*(0.95*'Constant and Variable Data'!D25)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D25))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!D25)/K25","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E25))*(0.95*'Constant and Variable Data'!E25)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E25))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!E25)/K25","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F25))*(0.95*'Constant and Variable Data'!F25)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F25))*TRUNC(0.85*'Constant and Variable Data'!J20/'Constant and Variable Data'!F25)","v":4.0336362129898262E+20}]
["2ND RUN",null,null,null,null,null,null,null,null,null,"Divider","Total Available",{"$f":"SUM(M22*M21)","v":1.2608556513579906E+21},1.2608556513579906E+21,1.2608556513579906E+21,1.2608556513579906E+21,4.0336362129898262E+20]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4","Selected Wire Diameter Compartment #5",null,null,null,null,{"$f":"IF(K20=0,1,K20)","v":1},"Length 2 Entered",{"$f":"'1+1 Estimator'!D38","v":0},{"$f":"'1+1 Estimator'!E38","v":0},{"$f":"'1+1 Estimator'!F38","v":0},{"$f":"'1+1 Estimator'!G38","v":0},{"$f":"'1+1 Estimator'!H38","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('1+1 Estimator'!D36,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!E36,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!F36,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!G36,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!H36,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},null,null,null,null,1,"% Occupied by 2",{"$f":"SUM(M24/M22)","v":0},0,0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('1+1 Estimator'!D36,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!E36,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!F36,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!G36,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!H36,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,1,"% Available",{"$f":"SUM(1-(M25+M20))","v":1},1,1,1,1]
[null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B30))*(0.95*'Constant and Variable Data'!B30)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!B30))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!B30)/K26","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C30))*(0.95*'Constant and Variable Data'!C30)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!C30))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!C30)/K26","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D30))*(0.95*'Constant and Variable Data'!D30)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!D30))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!D30)/K26","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E30))*(0.95*'Constant and Variable Data'!E30)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!E30))*TRUNC(0.85*'Constant and Variable Data'!I20/'Constant and Variable Data'!E30)/K26","v":1.2608556513579906E+21},{"$f":"3.14159/12*(+'Constant and Variable Data'!H20+(TRUNC(('Constant and Variable Data'!G20-(2*0)-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F30))*(0.95*'Constant and Variable Data'!F30)))*TRUNC(('Constant and Variable Data'!G20-2*0-'Constant and Variable Data'!H20)/(1.9*'Constant and Variable Data'!F30))*TRUNC(0.85*'Constant and Variable Data'!J20/'Constant and Variable Data'!F30)","v":4.0336362129898262E+20}]
["3RD RUN",null,null,null,null,null,null,null,null,null,null,"Total Available",{"$f":"SUM(M26*M27)","v":1.2608556513579906E+21},1.2608556513579906E+21,1.2608556513579906E+21,1.2608556513579906E+21,4.0336362129898262E+20]
[null,"Selected Wire Diameter Compartment #1","Selected Wire Diameter Compartment #2","Selected Wire Diameter Compartment #3","Selected Wire Diameter Compartment #4","Selected Wire Diameter Compartment #5",null,null,null,null,null,"Length 3 Entered",{"$f":"'1+1 Estimator'!D55","v":0},{"$f":"'1+1 Estimator'!E55","v":0},{"$f":"'1+1 Estimator'!F55","v":0},{"$f":"'1+1 Estimator'!G55","v":0},{"$f":"'1+1 Estimator'!H55","v":0}]
["Wire Diameter",{"$f":"VLOOKUP('1+1 Estimator'!D53,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!E53,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!F53,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!G53,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},{"$f":"VLOOKUP('1+1 Estimator'!H53,'Wire Types'!E1:G154,2,FALSE)","v":1.0000000000000001E-9},null,null,null,null,null,"% Occupied by 3",{"$f":"SUM(M29/M27)","v":0},0,0,0,0]
["Wire Weight/FT",{"$f":"VLOOKUP('1+1 Estimator'!D53,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!E53,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!F53,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!G53,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},{"$f":"VLOOKUP('1+1 Estimator'!H53,'Wire Types'!E1:G154,3,FALSE)/1000","v":1.0000000000000001E-11},null,null,null,null,null,"Total % Occupied",{"$f":"ROUNDDOWN(SUM(M30+M25+M20),3)","v":0},0,0,0,0]