{"text_format":"3","workbook":"xls","n_sheets":8,"sheets":["Customer_Sum","Main","dim","all","pull_list","prices","'file:///home/bus/notes-data-handouts/editable/spreadsheet-sampler.sxc'#Sheet1","labels"],"not_rendered":{"images":1,"external_links":2,"comments":22},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Customer_Sum","index":0,"n_rows":103,"n_cols":7,"rows_kept":103,"merged":[[1,0,1,6],[3,1,3,4],[8,0,8,2],[9,0,10,2],[10,5,10,6],[101,0,101,6],[102,0,102,6]],"flags":["formulas_cached_only"]}
[]
["Cable and Connector Price Estimate"]
[]
["Customer:","name"]
["Job number:","k---"]
["Date:","2008-08-21"]
["Revision:",0.2]
[]
["Copyright 2006-2008, Designs and Ideas, Inc.   www.dni-inc.com   Some rights reserved.",{"$nulls":5},"Cable Sub-total: $114.93"]
["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.",{"$nulls":5},"Connector Sub-total: $26.00"]
[{"$nulls":4},"Grand Total",{"v":114.925,"d":"$114.93"}]
[null,"Cable"]
["Description","Use","Part num.","Mfg.","Qty","Price/ft","Line Total"]
["shielded twisted pair, 22AWG","Mic, line",291,"WestPenn",55,{"v":0.115,"d":"$0.115"},{"v":6.325,"d":"$6.33"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
["RG59 Coax, low-loss","VGA","rgb-819","WestPenn",55,{"v":1.8,"d":"$1.800"},{"v":99,"d":"$99.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
["twisted pair, 16AWG","70V spk",225,"WestPenn",40,{"v":0.24,"d":"$0.240"},{"v":9.6,"d":"$9.60"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
[0,0,0,0,0,0,{"v":0,"d":"$0.00"}]
["Note: A 15% discount will apply to full spool purchases",{"$nulls":5},"Cable Sub-total: $114.93"]
["Note: This price is an estimate based on information available"]
["at the date listed above. It is not to be taken as a quote, as the"]
["price and quantity will almost certainly change during the install!"]
[]
[]
[null,"Connectors"]
["Part num.","Description","Mfg.","Qty to Order","Total Qty","Price","Line Total"]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
[null,"Connectors - continued on the next page"]
[]
[]
[null,"Connectors - continued"]
["Part num.","Description","Mfg.","Qty to Order","Total Qty","Price","Line Total"]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
["NBNC75BLP9","bnc","Neutrik",10,10,{"v":2.5,"d":"$2.500"},{"v":25,"d":"$25.00"}]
[{"v":0,"d":"$0.000"},"crimp",{"v":0,"d":"$0.000"},1,1,{"v":1,"d":"$1.000"},{"v":1,"d":"$1.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
["",0,"","","","",{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},""]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[{"$error":"#N/A"},"wire",{"$error":"#N/A"},3,3,{"$error":"#N/A"},""]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
[0,0,"",0,0,{"v":0,"d":"$0.000"},{"v":0,"d":"$0.00"}]
["",0,"",0,"","",{"v":0,"d":"$0.00"}]
[{"$nulls":6},"Connector Sub-total: $26.00"]
[]
["Note: This price is an estimate based on information available"]
["at the date listed above. It is not to be taken as a quote, as the"]
["price and quantity will almost certainly change during the install!"]
{"$rows_empty":8}
["Copyright 2006, Designs and Ideas, Inc.   www.dni-inc.com   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."]

{"sheet":"Main","index":1,"n_rows":76,"n_cols":7,"rows_kept":76,"merged":[[1,1,1,5],[4,1,4,2],[74,0,74,6],[75,0,75,6]],"flags":["formulas_cached_only"]}
[null,null,"Cable Use and Identification",{"$nulls":3},"template v3.99"]
["Customer:","name",{"$nulls":4},"Sell Price"]
["Job Num:","k---",{"$nulls":3},"Connector Total",{"v":26,"d":"$26.00"}]
["Rev:",0.2,{"$nulls":3},"Cable Total",{"v":114.925,"d":"$114.93"}]
["Date:","2008-08-21",{"$nulls":3},"Grand Total",{"v":140.925,"d":"$140.93"}]
[]
["Sell price","Qty","Use","Price/ft","Item","Description","Mfg."]
[{"v":6.325,"d":"$6.33"},55,"Mic, line",{"v":0.115,"d":"$0.115"},291,"shielded twisted pair, 22AWG","WestPenn"]
[{"v":0,"d":"$0.00"},0,"speaker",{"v":0.62,"d":"$0.620"},227,"twisted pair, 12AWG","WestPenn"]
[{"v":0,"d":"$0.00"},0,"Video",{"v":0.242,"d":"$0.242"},815,"RG59 Coax","WestPenn"]
[{"v":99,"d":"$99.00"},55,"VGA",{"v":1.8,"d":"$1.800"},"rgb-819","RG59 Coax, low-loss","WestPenn"]
[{"v":0,"d":"$0.00"},0,"network",{"v":0.13,"d":"$0.130"},4245,"CAT5e ","WestPenn"]
[{"v":9.6,"d":"$9.60"},40,"70V spk",{"v":0.24,"d":"$0.240"},225,"twisted pair, 16AWG","WestPenn"]
[{"v":0,"d":"$0.00"},0,"speaker",{"v":0.365,"d":"$0.365"},226,"twisted pair, 14 AWG","WestPenn"]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[{"v":0,"d":"$0.00"},0,"","",null,"",""]
[]
["Sell price","Order Qty","Total Qty","Sell price","Description","Part num","Mfg."]
[{"v":0,"d":"$0.00"},0,0,{"v":12,"d":"$12.00"},"10ft d-rca/mini","24-6275",{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},0,0,{"v":0,"d":"$0.00"},"15ft install mic",{"v":0,"d":"$0.000"},"ProCo"]
[{"v":0,"d":"$0.00"},0,0,{"v":11,"d":"$11.00"},"25ft RCA v","C-RVM/RVM-25","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":29,"d":"$29.00"},"25ft VGA","C-GM/GM-25","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":37,"d":"$37.00"},"25ft VGA w audio","C-GMA/GMA-25","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":13,"d":"$13.00"},"25ft y/c","C-SM/SM-25","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":13,"d":"$13.00"},"3ft VGA","C-GM/GM-3","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":20,"d":"$20.00"},"3ft VGA w audio","C-GMA/GMA-3","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":13,"d":"$13.00"},"6ft bnc-rca",{"v":0,"d":"$0.000"},{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},0,0,{"v":3,"d":"$3.00"},"6ft d-rca",{"v":0,"d":"$0.000"},{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},0,0,{"v":8,"d":"$8.00"},"6ft d-rca/mini","24-6270",{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},0,0,{"v":8,"d":"$8.00"},"6ft rca v","C-RVM/RVM-6","Kramer"]
[{"v":0,"d":"$0.00"},0,0,{"v":10,"d":"$10.00"},"6ft rca v+a","C-3RVAM/3RVAM-6","Kramer"]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},0,0,{"v":23,"d":"$23.00"},"6ft VGA w audio","C-GMA/GMA-6","Kramer"]
[{"v":25,"d":"$25.00"},10,10,{"v":2.5,"d":"$2.50"},"bnc","NBNC75BLP9","Neutrik"]
[{"v":1,"d":"$1.00"},1,1,{"v":1,"d":"$1.00"},"crimp",{"v":0,"d":"$0.000"},{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
[{"v":0,"d":"$0.00"},0,0,{"v":5.25,"d":"$5.25"},"nl4","NL4FX","Neutrik"]
[{"v":0,"d":"$0.00"},0,0,{"v":2,"d":"$2.00"},"rca-c","10-21001-240",{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},0,0,{"v":1.6,"d":"$1.60"},"rca-s","NYS373 ","Neutrik"]
["",0,0,{"$error":"#N/A"},"RJ45",{"$error":"#N/A"},{"$error":"#N/A"}]
[{"v":0,"d":"$0.00"},0,0,{"v":5.5,"d":"$5.50"},"TRS","BF3PM-BGR","G&H"]
["",3,3,{"$error":"#N/A"},"wire",{"$error":"#N/A"},{"$error":"#N/A"}]
[{"v":0,"d":"$0.00"},0,0,{"v":5,"d":"$5.00"},"xlr-f","NC3FXX-B","Neutrik"]
[{"v":0,"d":"$0.00"},0,0,{"v":4.6,"d":"$4.60"},"xlr-m","NC3MXX-B","Neutrik"]
[{"v":0,"d":"$0.00"},"","","",null,"",""]
["Connectors, adapters, etc that are not counted automatically"]
[{"v":0,"d":"$0.00"},null,null,{"v":23,"d":"$23.00"},"hd15 breakout","C-GM/5BF-1","Kramer"]
[{"v":0,"d":"$0.00"},null,null,{"v":13,"d":"$13.00"},"3ft Y/C converter",{"v":0,"d":"$0.000"},{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},null,null,{"v":5,"d":"$5.00"},"Y/C barrel","27-1270",{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},null,null,{"v":3,"d":"$3.00"},"RCA barrel","NYS355","Neutrik"]
[{"v":0,"d":"$0.00"},null,null,{"v":8,"d":"$8.00"},"RCA 1f/2m","24-770",{"v":0,"d":"$0.000"}]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,null,"",null,"",""]
[{"v":0,"d":"$0.00"},null,"","",null,"",""]
[]
["Copyright 2006-2008, Designs and Ideas, Inc.   www.dni-inc.com   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."]

{"sheet":"dim","index":2,"n_rows":10,"n_cols":53,"rows_kept":10,"flags":["formulas_cached_only"]}
["Dimensions"]
["Source",null,"JP1","JP2"]
["Destination",null,"JP2","JP5"]
["Length",null,55,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Manual override"]
["Run","Ft"]
["in booth",20,1,1]
["amp rack",10,1]
["at pockets & plates",5,1]
["floor to ceiling",20,1,1]

{"sheet":"all","index":3,"n_rows":201,"n_cols":13,"rows_kept":201,"merged":[[0,2,0,3],[0,5,0,7],[0,8,0,10]],"flags":["formulas_cached_only"]}
[null,null,"Label",null,null,"source",null,null,"destination"]
["length","P","line one","line two","cable type","Conn.","Location","T","Conn.","Location","T","function","notes"]
[55,null,"mic",{"v":1,"d":"01"},291,"wire","JP1",null,"crimp","JP2",null,null,"step 1"]
[40,null,"line",{"v":1,"d":"01"},225,"wire","JP2",null,"wire","JP5",null,"FOH Sub","DSP to amp"]
[0]
[0]
[0]
[0]
[0]
[55,null,"RGB 01","blue","rgb-819","bnc","JP1",null,"bnc","JP2"]
[55,null,"RGB 01","green","rgb-819","bnc","JP1",null,"bnc","JP2"]
[55,null,"RGB 01","horiz","rgb-819","bnc","JP1",null,"bnc","JP2"]
[55,null,"RGB 01","red","rgb-819","bnc","JP1",null,"bnc","JP2"]
[55,null,"RGB 01","vert","rgb-819","bnc","JP1",null,"bnc","JP2"]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]
[0]

{"sheet":"pull_list","index":4,"n_rows":25,"n_cols":52,"rows_kept":25,"merged":[[0,6,1,20],[23,0,23,13],[24,0,24,13]],"flags":["formulas_cached_only"]}
[null,"Pull List",{"$nulls":4},"This sheet uses the data from the \"dim\" sheet for Source and Destination. It uses the \"Main\" sheet for a list of the cable used. It then finds the quantity of each cable type for each source and destination from the sheet \"all\"."]
[]
["Source","JP1","JP2",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Destination","JP2","JP5",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["Length",55,40,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[291,1,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[227,0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[815,0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["rgb-819",5,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[4245,0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[225,0,1,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[226,0,0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
[0,"","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","","",""]
["Total",6,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]
[]
["NOTE: This sheet does not distinguish which cables go in each one of multiple conduits."]
[]
["Copyright 2006-2008, Designs and Ideas, Inc.   www.dni-inc.com   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."]

{"sheet":"prices","index":5,"n_rows":75,"n_cols":5,"rows_kept":75,"flags":["formulas_cached_only"]}
["Parts and cable prices",null,null,"NOTE: Some data is pulled from another document"]
[{"$nulls":3},"delinked?","still linked"]
["Sell Price","Mfg Part number","Manufacturer","short desc.","Description"]
[{"v":15,"d":"$15.00"},"33-530",0,"10ft bnc-rca",0]
[{"v":12,"d":"$12.00"},"24-6275",0,"10ft d-rca/mini","10ft dual RCA to stereo 3.5mm mini cable"]
[{"v":42,"d":"$42.00"},"C-DM/DM-15","Kramer","15ft DVI",0]
[{"v":0,"d":"$0.00"},0,"ProCo","15ft install mic","15 ft cable with install grade cables"]
[{"v":11,"d":"$11.00"},"C-RVM/RVM-25","Kramer","25ft RCA v","25ft RCA video cable"]
[{"v":29,"d":"$29.00"},"C-GM/GM-25","Kramer","25ft VGA",0]
[{"v":37,"d":"$37.00"},"C-GMA/GMA-25","Kramer","25ft VGA w audio",0]
[{"v":13,"d":"$13.00"},"C-SM/SM-25","Kramer","25ft y/c","25ft Y/C video cable"]
[{"v":13,"d":"$13.00"},"C-GM/GM-3","Kramer","3ft VGA",0]
[{"v":20,"d":"$20.00"},"C-GMA/GMA-3","Kramer","3ft VGA w audio",0]
[{"v":13,"d":"$13.00"},0,0,"3ft Y/C converter","Y/C to composite converter cable"]
[{"v":13,"d":"$13.00"},0,0,"6ft bnc-rca","6ft BNC to RCA video cable"]
[{"v":3,"d":"$3.00"},0,0,"6ft d-rca",0]
[{"v":8,"d":"$8.00"},"24-6270",0,"6ft d-rca/mini","6ft dual RCA to stereo 3.5mm mini cable"]
[{"v":8,"d":"$8.00"},"C-RVM/RVM-6","Kramer","6ft rca v","6ft RCA video cable"]
[{"v":10,"d":"$10.00"},"C-3RVAM/3RVAM-6","Kramer","6ft rca v+a","6ft RCA video plus dual RCA audio cable"]
[{"v":15,"d":"$15.00"},"C-GM/GM-6","Kramer","6ft VGA",0]
[{"v":23,"d":"$23.00"},"C-GMA/GMA-6","Kramer","6ft VGA w audio",0]
[{"v":0.24,"d":"$0.24"},225,"WestPenn","70V spk","twisted pair, 16AWG"]
[{"v":2.5,"d":"$2.50"},"NBNC75BLP9","Neutrik","BNC",0]
[{"v":0,"d":"$0.00"},0,0,"BNC barrel",0]
[{"v":1,"d":"$1.00"},0,0,"crimp",0]
[{"v":23,"d":"$23.00"},"C-GM/5BF-1","Kramer","hd15 breakout","HD15 to 5) BNC-f"]
[{"v":0.115,"d":"$0.12"},291,"WestPenn","Mic, line","shielded twisted pair, 22AWG"]
[{"v":7.5,"d":"$7.50"},"3.5TRS-key ",0,"mini-j",0]
[{"v":6.05,"d":"$6.05"},"35HDNN ","Switchcraft","mini-p",0]
[{"v":0.13,"d":"$0.13"},4245,"WestPenn","network","CAT5e "]
[{"v":5.25,"d":"$5.25"},"NL4FX","Neutrik","NL4",0]
[{"v":3,"d":"$3.00"},"PL-259",0,"PL-259",0]
[{"v":8,"d":"$8.00"},"24-770",0,"RCA 1f/2m","short adapter wye cable, one RCA-f to two RCA-m"]
[{"v":3,"d":"$3.00"},"NYS355","Neutrik","RCA barrel",0]
[{"v":2,"d":"$2.00"},"10-21001-240",0,"rca-c",0]
[{"v":1.6,"d":"$1.60"},"NYS373 ","Neutrik","rca-s",0]
[{"v":1,"d":"$1.00"},"RJ45-P ",0,"RJ45-P",0]
[{"v":0.62,"d":"$0.62"},227,"WestPenn","speaker","twisted pair, 12AWG"]
[{"v":5.5,"d":"$5.50"},"BF3PM-BGR","G&H","TRS",0]
[{"v":1.8,"d":"$1.80"},"rgb-819","WestPenn","VGA","RG59 Coax, low-loss"]
[{"v":0.242,"d":"$0.24"},815,"WestPenn","Video","RG59 Coax"]
[{"v":5,"d":"$5.00"},"NC3FXX-B","Neutrik","xlr-f",0]
[{"v":4.6,"d":"$4.60"},"NC3MXX-B","Neutrik","xlr-m",0]
[{"v":5,"d":"$5.00"},"27-1270",0,"Y/C barrel","Y/C jack to jack adapter"]
[{"v":0.365,"d":"$0.37"},226,"WestPenn","speaker","twisted pair, 14 AWG"]
[{"v":13,"d":"$13.00"},"M3-B","ProCo","3ft mic","Mic cable, 3ft"]
[{"v":16,"d":"$16.00"},"M6-B","ProCo","6ft mic","Mic cable, 6ft"]
[{"v":21,"d":"$21.00"},"YMXF2XM-1               ","ProCo","XLR-wye","XLR wye cable, two M, one F"]
[{"v":3,"d":"$3.00"},"SJP-PP",0,"SPJ, per pole","Speaker Junction, per pole. Mount equals a pole"]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]
[{"v":0,"d":"$0.00"},0,0,0,0]

{"sheet":"'file:///home/bus/notes-data-handouts/editable/spreadsheet-sampler.sxc'#Sheet1","index":6,"n_rows":184,"n_cols":7,"rows_kept":184,"hidden":true,"merged":[[57,3,57,4],[104,1,104,4],[118,1,118,4]],"flags":["formulas_cached_only"]}
[]
["Some examples"]
["V1.4"]
[null,null,"Use a lookup table."]
[]
[null,"Input","foo",null,"choices","output"]
[null,"Result","bar",null,4,50]
[{"$nulls":4},"cat","tail"]
["Enter something in the cell next to",{"$nulls":3},"foo","bar"]
["“Input”. If it matches a cell under ",{"$nulls":3},"price",{"v":3,"d":"$3.00"}]
["“choices”, then “Result” will be"]
["from the same row, but from the"]
["column “output”."]
[]
["I usually use colored backgrounds for the cells that are computed - and plain, white for ones that"]
["require data entry."]
[]
["This does not work quite the same in OpenOffice2. It seems that if the data is _not_ sorted, it will get confused"]
["Therefore, I have shifted to using “index” and “match” to accomplish the same functionallity."]
[]
[null,"Input","foo"]
[null,"Result","bar"]
[]
[]
[null,null,"choices",4,"cat","foo","price"]
[null,null,"output",50,"tail","bar",{"v":3,"d":"$3.00"}]
[]
["INDEX(C26:G26;C26;MATCH(C21;C25:G25;0))"]
["Index has three values. The first is the range that I want the output collected from (c26:g26)"]
["Next, is the row of the output (1, meaning the first row). This too could be a “match” to make a 2D lookup."]
["The third is column (output of “match”)."]
[]
["Match has three values. First is what I'm searching for (c21), then where to look for it (c25:g25)"]
["and finally a zero if I want only exact matches. If I would rather it pick the closest one, I could use"]
["somthing else."]
[]
[null,null,"Different action if a cell is blank"]
[]
[null,"input","calculate","unit"]
[null,1,{"v":1,"d":"1.0000"},"feet"]
[null,null,{"v":12,"d":"12.0000"},"inch"]
[null,null,{"v":0.304841802346672,"d":"0.3048"},"meter"]
[]
["Here, enter a number into only one of the “input” cells. Note that  “calculate” column shows "]
["the same number as “input” for that particular unit."]
[]
["This is part of a bigger spreadsheet. I needed to figure area, etc and wanted to do all the math"]
["in meters. My final output could then also be converted to other units. With this for my input, "]
["I can enter data with whatever unit my tape measure is, I get to see the result of the conversion,"]
["and the rest of the sheet can use “calulate/meter” for further math."]
[]
[]
[null,null,"The power of “if”"]
[]
["Here is a test that only works with numbers. That is, if there is no number or there is text, the “if” returns false."]
[]
[null,"Input","evaluate","= input x evaluate"]
[null,3,0.30000000000000004,0.9]
[]
[]
["On this one, if either of the white cells has the letter “y” in it, the blue cell displays “yes”."]
["Note that to use text rather than numbers for logic stuff the text must be in quotes."]
[null,"y",null,"yes"]
[]
["“exact” can be used for comparing cell content for a text “equals”"]
["The orange cells pull data from the white cells. If the result is a exactly the same (case sensitive)"]
["then the purple cell tells us they match"]
[null,"a","b","one","two"]
[null,"Blue","blue","Blue","blue","different"]
[]
[]
[null,null,"Round off"]
[]
["Round off a number to a particular number of decimals. The last variable giving is the number of decimal"]
["places. If it is a negative number, the decimal move to the left."]
[]
[null,"first num","second","whole","rounded","another round"]
[null,300,7,{"v":42.8571428571429,"d":"42.857143"},42.86,40]
[]
[null,null,"Complex math"]
[]
[22,"N"]
[484,"N squared"]
[4.69041575982343,"square root of N"]
[113379904,"N raised to the 6th power"]
[1.34242268082221,"base-10 log of N"]
[3.09104245335832,"Natural log of N"]
[-0.008851309290403881,"sin N"]
[44602.2381005655,"Surface area of a sphere with a radius of N"]
[90.9090909090909,"the Nth root of 2000"]
[3.78470576309943,"inverse hyperbolic sin of N"]
["10110","N in binary"]
["16","N in hexadecimal"]
[{"v":3.14159265358979,"d":"3.1415926536"},"pi"]
[]
[null,null,"Difference, either up or down"]
[]
["I use cable that has printed on the jacket, the number of feet. This number doesn't start or end with"]
["my spool - and it isn't always the same direction! Sometimes the foot-number gets larger toward the "]
["center of the spool, and sometimes it gets smaller. So, I use this table to figure out how much"]
["cable is left on the spool."]
[]
["Note that I use the first two numbers to set the order. That is, are the numbers increasing, or decreasing?"]
[]
[null,"Speaker cable"]
[null,"Date","printed","used","left"]
[null,"Starting num",1200,null,1000]
[null,"1st job",1100,100,900]
[null,"2nd job",1300,-200,1100]
[{"$nulls":3},0,1100]
[{"$nulls":3},0,1100]
[{"$nulls":3},0,1100]
[{"$nulls":3},0,1100]
[{"$nulls":3},0,1100]
[]
["I have the sheet set so that “zero” is not displayed. Then I also use an “if” and a “isblank” to enter an"]
["invisible zero if there is nothing in the “Printed” column."]
[]
[null,"Speaker cable"]
[null,"Date","printed","used","left"]
[null,"Starting num",1200,null,1000]
[null,"1st job",1100,100,900]
[null,"2nd job",1300,-200,1100]
[{"$nulls":3},0,0]
[{"$nulls":3},0,0]
[{"$nulls":3},0,0]
[{"$nulls":3},0,0]
[{"$nulls":3},0,0]
[]
[]
[null,null,"Stuff with dates"]
[]
["2005-06-12","Date one"]
["2004-05-03","Date two"]
[-405,"Number of days between “date one” and “date two”"]
[30,"The number of days in the month entered in “Date one”"]
[]
[null,null,"Combine cell text"]
[]
["Red, ","First cell"]
["Green, ","Second cell"]
["Blue, ","Third cell"]
["Red, Green, Blue, ","Concatinate the three cells. Note that it does not put in spaces or commas. It just"]
[null,"runs it all together."]
[]
[null,null,"Sum if"]
["A","B"]
[123,"super","I want to add togethor (sum) all the numbers in “A”, but only if “B” has a"]
[452,"super","particular value"]
[33,"ball"]
[33,null,"ball","particular value"]
[]
[null,null,"Count if"]
["A"]
["super",null,"This time, I want to count the number of cells that contain a particular value."]
["ball"]
["ball",null,"super","particular value"]
[1]
[]
[null,null,"What size do I need?"]
[]
[null,null,"The final formula is a two step, so I'll break it out and show each step by its self."]
[]
["Eeny",null,"Position in the array."]
["Meeny",null,"Find the particular value and display it's position"]
["Miney"]
["Moe"]
[2,"meeny","particular value"]
[]
[null,null,"What value is at an array position."]
["Eeny",null,"This kind of works the other way. That is, I give it an number and the result is"]
["Meeny",null,"the content of whatever cell is in that position."]
["Miney"]
["Moe"]
["Meeny",2,"particular value"]
[]
[null,null,"Put it all together"]
[{"$nulls":4},"Here I enter a cable diameter. I have the spreadsheet"]
[{"v":0.4,"d":"0.400"},"cable diameter",null,null,"compute the area. Then I use “match” to compare it"]
[{"v":0.31415926535897903,"d":"0.31416"},"cable area",null,null,"to known conduit area and use the resulting number"]
[1,"minimum conduit size necessary",null,null,"in “offset” to display the conduit size."]
[]
[0,0.5,0.75,1,1.25,"conduit size"]
[0,0.121543193219143,0.21330660135637802,0.34570116976028603,0.59828490494964,"fill area. (this is pre-figured for 40% conduit fill)"]

{"sheet":"labels","index":7,"n_rows":369,"n_cols":2,"rows_kept":369,"flags":["formulas_cached_only"]}
["mic",{"v":1,"d":"01"}]
["line",{"v":1,"d":"01"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
["RGB 01","blue"]
["RGB 01","green"]
["RGB 01","horiz"]
["RGB 01","red"]
["RGB 01","vert"]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]
[0,{"v":0,"d":"00"}]