{"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 4.4",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":53,"n_cols":26,"rows_kept":53,"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],[42,0,42,1],[47,0,47,1]],"flags":["formulas_cached_only"]}
["Conduit Fill Computation",{"$nulls":7},"Version 4.4",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,"2008-03-04",{"$nulls":4},"Use",null,"Mic/line","Spk 4","CAT5e","Video","VGA","Spk 2","","","",""]
["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",null,291,227,4245,815,"819-5",225]
[{"$nulls":7},"OD",null,0.131,0.269,{"v":0.20800000000000002,"d":"0.208"},0.232,0.232,0.189,{"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.056832329400000006,"d":"0.057"},{"v":0.03397954560000001,"d":"0.034"},{"v":0.0422733696,"d":"0.042"},{"v":0.0422733696,"d":"0.042"},{"v":0.0280552734,"d":"0.028"},{"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"]
[]
["JP1","-","Booth",1,0.5,{"v":0.12154319321914336,"d":"0.12"},{"v":0.32207211960000004,"d":"0.32"},{"v":-0.20052892638085668,"d":"0.2005"},1,4,2,0,1,0,4,0,0,0,0]
["JP2","-","pull box",1,0.5,{"v":0.12154319321914336,"d":"0.12"},{"v":0.2922363444,"d":"0.29"},{"v":-0.17069315118085665,"d":"0.1707"},1,6,0,0,0,5,0,0,0,0,0]
["JP3","-","pull box",1,0.5,{"v":0.12154319321914336,"d":"0.12"},{"v":0.2759714958,"d":"0.28"},{"v":-0.15442830258085666,"d":"0.1544"},1,7,2,2,0,0,0,0,0,0,0]
["pull box","-","Booth",null,null,{"v":0,"d":"0.00"},{"v":0.18869549160000001,"d":"0.19"},{"v":-0.18869549160000001,"d":"0.1887"},0.75,14,0,0,0,0,0,0,0,0,0]
["Booth","-","Amp Rack",null,null,{"v":0,"d":"0.00"},{"v":0.026956498800000003,"d":"0.03"},{"v":-0.026956498800000003,"d":"0.0270"},0.5,2,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,0]
[0,0,0,1,1,{"v":0.4580540499323792,"d":"0.46"},{"v":0,"d":"0.00"},{"v":0.4580540499323792,"d":"0.4581"},0,0,0,0,0,0,0,0,0,0,0]
[0,0,0,1,1,{"v":0.4580540499323792,"d":"0.46"},{"v":0,"d":"0.00"},{"v":0.4580540499323792,"d":"0.4581"},0,0,0,0,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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,0,0,0,0,0,0,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","2-ij","4-ij","8-ij","16-ij","8pr","12pr","16pr","20pr","Spk 3"]
[null,null,"Part number",null,224,225,227,291,4245,815,"819-5",841,77350,"AC2","AC4","AC8","AC16","DLA8","DLA12","DLA16","DLA20",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.335,0.307,{"v":0.47500000000000003,"d":"0.475"},0.738,{"v":0.41500000000000004,"d":"0.415"},{"v":0.5,"d":"0.500"},{"v":0.5700000000000001,"d":"0.570"},{"v":0.63,"d":"0.630"},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.08814151500000002,"d":"0.088"},{"v":0.0740231646,"d":"0.074"},{"v":0.177205875,"d":"0.177"},{"v":0.4277633976,"d":"0.428"},{"v":0.135265515,"d":"0.135"},{"v":0.19635,"d":"0.196"},{"v":0.25517646000000005,"d":"0.255"},{"v":0.31172526,"d":"0.312"},{"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"}]
[null,null,"Quantity",null,1,1,1,1,1,1,5,1,1,1,1,1,1,1,1,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","snake cable","snake cable","snake cable","snake cable","snake cable","snake cable","snake cable","snake cable","14 AWG TP"]

{"sheet":"pulllist","index":2,"n_rows":38,"n_cols":15,"rows_kept":38,"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],[36,0,36,1],[36,2,36,10],[37,0,37,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","22 AWG STP","12 AWG TP","4 pr UTP","RG59 Coax","lo-loss RG59","16 AWG TP","","","",""]
[{"$nulls":4},"Use","Mic/line","Spk 4","CAT5e","Video","VGA","Spk 2","","","",""]
["Conduit",{"$nulls":3},"Cable Type",291,227,4245,815,"819-5",225,0,0,0,0]
["Qty","Size","Locations"]
[1,0.5,"JP1","-","Booth",4,2,0,1,0,4,0,0,0,0]
[1,0.5,"JP2","-","pull box",6,0,0,0,5,0,0,0,0,0]
[1,0.5,"JP3","-","pull box",7,2,2,0,0,0,0,0,0,0]
[0,0,"pull box","-","Booth",14,0,0,0,0,0,0,0,0,0]
[0,0,"Booth","-","Amp Rack",2,0,0,0,0,0,0,0,0,0]
[0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,1,0,0,0,0,0,0,0,0,0,0,0,0,0]
[1,1,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,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,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]
[]
["Version 4.4",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."]