{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["box","fill","pulllist"],"not_rendered":{"external_links":1,"defined_names":1,"comments":14},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"box","index":0,"n_rows":40,"n_cols":25,"rows_kept":40,"merged":[[1,2,1,3],[2,2,2,3],[3,2,3,3],[4,2,4,3],[4,4,4,7],[8,4,8,5],[8,6,8,7],[8,8,8,9],[8,10,8,11],[8,12,8,13],[8,14,8,15],[8,16,8,17],[8,18,8,19],[8,20,8,21],[8,22,8,23],[8,24,8,25],[9,4,9,5],[9,6,9,7],[9,8,9,9],[9,10,9,11],[9,12,9,13],[9,14,9,15],[9,16,9,17],[9,18,9,19],[9,20,9,21],[9,22,9,23],[9,24,9,25],[10,4,10,5],[10,6,10,7],[10,8,10,9],[10,10,10,11],[10,12,10,13],[10,14,10,15],[10,16,10,17],[10,18,10,19],[10,20,10,21],[10,22,10,23],[10,24,10,25],[38,1,38,2],[39,1,39,12]],"flags":["formulas_cached_only"]}
[null,"Junction Point Assignment Worksheet"]
[null,null,"Customer:",null,"name"]
[null,null,"Job Num:",null,"k"]
[null,null,"Rev:",null,0.30000000000000004]
[null,null,"Date:",null,"2008-03-04"]
[]
[null,null,"This sheet is to aid in platform pocket and plate layout. The “Total” row will keep a running total of the quantity of a particular type of cable."]
[null,null,"The “Total” column will keep a running total of the number of connectors at a given box/plate."]
[{"$nulls":4},"Mic/line","","Mic/line",null,"Spk 4",null,"CAT5e",null,"Video",null,"VGA",null,"Spk 2",null,{"$error":"#N/A"},null,{"$error":"#N/A"},null,"",null,""]
[null,null,"Start","End",291,null,291,null,227,null,4245,null,815,null,"819-5",null,225,null,"bnc",null,"spk"]
["skip?","Total",null,null,14,null,5,null,4,null,2,null,1,null,1,null,4,null,0,null,0,null,0,null,0]
[null,11,"JP1","Booth",1,"xlr-f",3,"xlr-f",2,"NL4",null,null,1,"bnc",null,null,4]
[null,7,"JP2","pull box",6,"xlr-f",{"$nulls":8},1,"hd15"]
[null,11,"JP3","pull box",7,"xlr-f",null,null,2,"NL4",2,"RJ45"]
["y",14,"pull box","Booth",14,"xlr-m"]
[null,2,"Booth","Amp Rack",null,null,2]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[null,0]
[]
[null,"Version 1.2",null,"Copyright 2006-2008 by Designs and Ideas, Inc.    Some rights reserved"]
[null,"This work is licensed under the Creative Commons Attribution-ShareAlike License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/2.5/ or send a letter to Creative Commons, 559 Nathan Abbott Way, Stanford, California 94305, USA."]

{"sheet":"fill","index":1,"n_rows":74,"n_cols":26,"rows_kept":74,"merged":[[0,8,0,9],[0,10,0,18],[1,0,1,1],[1,2,1,7],[1,8,1,18],[2,0,2,1],[2,2,2,4],[3,0,3,1],[4,0,4,1],[4,2,4,3],[4,7,4,8],[5,0,7,6],[5,7,5,8],[6,7,6,8],[7,7,7,8],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,3,9,3],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[63,0,63,1],[68,0,68,1],[68,2,68,3],[69,2,69,3],[70,2,70,3],[71,2,71,3],[72,2,72,3],[73,2,73,3]],"flags":["formulas_cached_only"]}
["Conduit Fill Computation",{"$nulls":7},"Version 1.2",null,"Copyright 2006-2008 by Designs and Ideas, Inc.    Some rights reserved"]
["Customer:",null,"name",{"$nulls":5},"This work is licensed under the Creative Commons Attribution-ShareAlike License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/2.5/ or send a letter to Creative Commons, 559 Nathan Abbott Way, Stanford, California 94305, USA."]
["Job Num:",null,"k",{"$nulls":4},"in-use",291,291,227,4245,"Video","VGA","Spk 2",0,0,0,0]
["Rev:",null,0.30000000000000004]
["Date:",null,"2007-07-13",{"$nulls":4},"Use",null,"Mic/line","Video","CAT5e","VGA","","","","","",""]
["This sheet is to aid in figuring what size conduit is needed - or for determining how many cables will fit in a particular size conduit.",{"$nulls":6},"Cable Part #",null,291,815,4245,"819-5"]
[{"$nulls":7},"OD",null,0.131,0.232,{"v":0.20800000000000002,"d":"0.208"},0.232,{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[{"$nulls":7},"Cable area",null,{"v":0.013478249400000001,"d":"0.013"},{"v":0.0422733696,"d":"0.042"},{"v":0.03397954560000001,"d":"0.034"},{"v":0.0422733696,"d":"0.042"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
["Start","-","End","Qty","Conduit Size","Conduit Area","Cable Area","Extra Space","Min. size"]
[]
[{"$nulls":9},8,1,4]
["JP1","-","Booth",1,1,{"v":0.3457011697602862,"d":"0.35"},{"v":0.28601754720000006,"d":"0.29"},{"v":0.05968362256028614,"d":"0.0597"},1,8,1,4,"","","","","","",""]
[{"$nulls":9},8,1,4]
["JP2","-","pull box",1,1,{"v":0.3457011697602862,"d":"0.35"},{"v":0.28601754720000006,"d":"0.29"},{"v":0.05968362256028614,"d":"0.0597"},1,8,1,4,"","","","","","",""]
[{"$nulls":9},8,null,2,1]
["JP3","-","pull box",1,1,{"v":0.3457011697602862,"d":"0.35"},{"v":0.218058456,"d":"0.22"},{"v":0.12764271376028619,"d":"0.1276"},1,8,"",2,1,"","","","","",""]
[{"$nulls":9},8,null,2]
["pull box","-","Booth",1,1.25,{"v":0.5982849049496404,"d":"0.60"},{"v":0.5953143504,"d":"0.60"},{"v":0.0029705545496403474,"d":"0.0030"},1.25,24,"",8,"","","","","","",""]
[{"$nulls":9},6,null,4]
["Booth","-","Amp Rack",2,2,{"v":2.684484010988641,"d":"2.68"},{"v":1.0558462068,"d":"1.06"},{"v":1.628637804188641,"d":"1.6286"},2,38,"",16,"","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
[0,0,0,null,null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.0000"},0,"","","","","","","","","",""]
[]
["Conduit",null,"Size",null,0.5,0.75,1,1.25,1.5,2,2.5,3,3.5,4,4.5,5]
[null,null,"I.D.",null,0.622,{"v":0.8240000000000001,"d":"0.824"},1.049,{"v":1.38,"d":"1.380"},{"v":1.61,"d":"1.610"},2.067,2.469,3.068,3.548,4.026,4.506,5.047]
[null,null,"Fill area",0,0.12154319321914336,0.21330660135637838,{"v":0.3457011697602862,"d":"0.35"},0.5982849049496404,0.8143322317370103,1.3422420054943205,1.9151026294169886,2.957063040940298,3.954732336755501,5.092105744601719,6.378701033582271,8.00233046651038]
[null,null,"Fill Percent",40]
[]
["Cable",null,"Use",null,"Spk 1","Spk 2","Spk 4","Mic/line","CAT5e","Video","VGA","RG6","Biamp","Spk 3"]
[null,null,"Part number",null,224,225,227,291,4245,815,"819-5",841,77350,226]
[null,null,"O.D.",null,0.155,0.189,0.269,0.131,{"v":0.20800000000000002,"d":"0.208"},0.232,0.232,0.254,0.255,0.234]
[null,null,"Fill area",null,{"v":0.018869235,"d":"0.019"},{"v":0.0280552734,"d":"0.028"},{"v":0.056832329400000006,"d":"0.057"},{"v":0.013478249400000001,"d":"0.013"},{"v":0.03397954560000001,"d":"0.034"},{"v":0.0422733696,"d":"0.042"},{"v":0.0422733696,"d":"0.042"},{"v":0.0506708664,"d":"0.051"},{"v":0.051070634999999996,"d":"0.051"},{"v":0.043005362400000004,"d":"0.043"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"},{"v":0,"d":"0.000"}]
[null,null,"Quantity",null,1,1,1,1,1,1,5,1,1,1]
[null,null,"Description",null,"18 AWG TP","16 AWG TP","12 AWG TP","22 AWG STP","4 pr UTP","RG59 Coax","lo-loss RG59","CATV Coax","Biamp Conrol","14 AWG TP"]

{"sheet":"pulllist","index":2,"n_rows":46,"n_cols":15,"rows_kept":46,"merged":[[1,1,1,2],[1,4,1,5],[2,1,2,2],[2,4,2,5],[3,1,3,2],[3,4,3,5],[4,1,4,2],[4,4,4,5],[4,6,4,9],[7,0,7,1],[8,2,8,4],[44,0,44,1],[44,2,44,10],[45,0,45,10]],"flags":["formulas_cached_only"]}
["Loose cable lengths",{"$nulls":4},"Cable pull chart"]
["15ft","at the booth",null,null,"Customer:",null,"name"]
["10ft","at the rack",null,null,"Job Num:",null,"k"]
["5ft","Other boxes",null,null,"Rev:",null,0.30000000000000004]
[{"$nulls":4},"Date:",null,"2008-03-04"]
[{"$nulls":4},"Description",0,0,0,0,0,0,0,0,0,0]
[{"$nulls":4},"Use",0,0,0,0,0,0,0,0,0,0]
["Conduit",{"$nulls":3},"Cable Type",291,815,4245,"819-5",0,0,0,0,0,0]
["Qty","Size","Locations"]
[1,1,"JP1","-","Booth",8,1,4,"","","","","","",""]
[1,1,"JP2","-","pull box",8,1,4,"","","","","","",""]
[1,1,"JP3","-","pull box",8,"",2,1,"","","","","",""]
[1,1.25,"pull box","-","Booth",24,"",8,"","","","","","",""]
[2,2,"Booth","-","Amp Rack",38,"",16,"","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
[0,0,0,0,0,"","","","","","","","","",""]
{"$rows_empty":9}
["Version 1.2",null,"Copyright 2006-2008 by Designs and Ideas, Inc.    Some rights reserved"]
["This work is licensed under the Creative Commons Attribution-ShareAlike License. To view a copy of this license, visit http://creativecommons.org/licenses/by-sa/2.5/ or send a letter to Creative Commons, 559 Nathan Abbott Way, Stanford, California 94305, USA."]