{"text_format":"3","workbook":"xls","n_sheets":5,"sheets":["Master","headend","Line1","Line2","tailend"],"not_rendered":{"external_links":1,"defined_names":1,"comments":41},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Master","index":0,"n_rows":25,"n_cols":9,"rows_kept":25,"merged":[[2,2,2,6],[4,2,4,3],[5,2,5,4],[7,0,7,4],[7,5,8,6],[7,7,8,8],[12,0,12,1],[13,3,13,4],[14,3,14,4],[15,3,15,4],[16,3,16,4],[17,3,17,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4]],"flags":["formulas_cached_only"]}
["CATV Cable Loss and Tap Computation"]
[{"$nulls":6},"Version 3.0"]
[null,"Customer:","name"]
[null,"Job Number:","k"]
[null,"Rev:",0.5]
[null,"Date:","2007-02-12"]
[]
["Cable loss",{"$nulls":4},"Source level",null,"Default drop length"]
["loss (in dB)","per","unit","at","Freq"]
[1.5,100,"Ft",50," MHz",7,"dBm",20,"Ft"]
[4.15,100,"Ft",450," MHz"]
[]
["device totals",{"$nulls":3},"Cable lengths"]
["split",2,null,"headend",null,34]
[3,0,null,"Line1",null,275]
[6,0,null,"Line2",null,135]
[9,0,{"$nulls":3},""]
[12,2,{"$nulls":3},""]
[16,6,{"$nulls":3},""]
[20,5,{"$nulls":3},""]
[24,0,{"$nulls":3},""]
[27,0,{"$nulls":3},""]
[30,0,{"$nulls":3},""]
["amp",1,{"$nulls":3},""]
[null,0,null,null,"Grand total",444]

{"sheet":"headend","index":1,"n_rows":47,"n_cols":12,"rows_kept":47,"merged":[[4,2,4,3],[6,1,6,5],[7,1,7,2],[11,1,11,2],[11,4,11,6],[11,7,11,9],[12,5,12,6],[12,7,12,8],[12,11,13,11],[15,0,15,1],[15,4,16,4],[15,7,16,7],[15,8,16,8],[15,11,16,11],[16,0,16,1],[18,0,18,1],[18,4,19,4],[18,7,19,7],[18,8,19,8],[18,11,19,11],[19,0,19,1],[21,0,21,1],[21,4,22,4],[21,7,22,7],[21,8,22,8],[21,11,22,11],[22,0,22,1],[24,0,24,1],[24,4,25,4],[24,7,25,7],[24,8,25,8],[24,11,25,11],[25,0,25,1],[27,0,27,1],[27,4,28,4],[27,7,28,7],[27,8,28,8],[27,11,28,11],[28,0,28,1],[30,0,30,1],[30,4,31,4],[30,7,31,7],[30,8,31,8],[30,11,31,11],[31,0,31,1],[33,0,33,1],[33,4,34,4],[33,7,34,7],[33,8,34,8],[33,11,34,11],[34,0,34,1],[36,0,36,1],[36,4,37,4],[36,7,37,7],[36,8,37,8],[36,11,37,11],[37,0,37,1],[39,0,39,1],[40,0,40,1],[46,0,46,11]],"flags":["formulas_cached_only"]}
["CATV Cable Loss and Tap Computation"]
[null,"Customer:","name",{"$nulls":7},"Page",2]
[null,"Job Number:","k"]
[null,"Rev:",0.5]
[null,"Date:","2007-02-12"]
[]
[null,"Levels",{"$nulls":8},34,"cable length - this sheet"]
["Freq.","Source",null,"Target min","Target max","Sheet output"]
["50 MHz",null,7,5,10,28.490000000000002,null,"typical VCR modulator out is +7 dBm"]
["450 MHz",null,7,5,10,28.490000000000002,null,"typical required TV input level is +5 to +10 dBm"]
[]
[null,"Cable",null,"RF","Tap",null,null,"Tap cable",null,null,"Device"]
[null,"Length","Loss","Level","Value","Loss in dB",null,"Length",null,"Loss","signal","description"]
[null,"Ft","dB","dBm","dB","real","fig.","real",null,"dB","dBm"]
[null,5]
["50 MHz",null,0.075,6.925,"split",null,{"v":4,"d":"4.0"},null,{"v":0,"d":"0.0"},0,2.925,"combiner"]
["450 MHz",null,0.075,6.925,null,null,{"v":4,"d":"4.0"},null,null,0,2.925]
[null,2]
["50 MHz","50 MHz",0.03,2.895,"amp",-30,{"v":-30,"d":"-30.0"},null,{"v":0,"d":"0.0"},0,32.895,"amp"]
["450 MHz","450 MHz",0.03,2.895,null,-30,{"v":-30,"d":"-30.0"},null,null,0,32.895]
[null,2]
["50 MHz",null,0.03,32.865,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,32.865,"booth TV"]
["450 MHz",null,0.03,32.865,null,null,{"v":0,"d":"0.0"},null,null,0,32.865]
[null,25]
["50 MHz",null,0.375,32.49,"split",null,{"v":4,"d":"4.0"},null,{"v":0,"d":"0.0"},0,28.490000000000002]
["450 MHz",null,0.375,32.49,null,null,{"v":4,"d":"4.0"},null,null,0,28.490000000000002]
[]
["50 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,28.490000000000002]
["450 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,null,0,28.490000000000002]
[]
["50 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,28.490000000000002]
["450 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,null,0,28.490000000000002]
[]
["50 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,28.490000000000002]
["450 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,null,0,28.490000000000002]
[]
["50 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,28.490000000000002]
["450 MHz",null,0,28.490000000000002,null,null,{"v":0,"d":"0.0"},null,null,0,28.490000000000002]
[]
["50 MHz",null,0,28.490000000000002]
["450 MHz",null,0,28.490000000000002]
[]
[]
[]
[]
["Version 3.0",null,"Copyright 2006 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."]

{"sheet":"Line1","index":2,"n_rows":50,"n_cols":12,"rows_kept":50,"merged":[[4,2,4,3],[6,1,6,5],[7,1,7,2],[11,1,11,2],[11,4,11,6],[11,7,11,9],[12,5,12,6],[12,7,12,8],[12,11,13,11],[15,0,15,1],[15,4,16,4],[15,7,16,7],[15,8,16,8],[15,11,16,11],[16,0,16,1],[18,0,18,1],[18,4,19,4],[18,7,19,7],[18,8,19,8],[18,11,19,11],[19,0,19,1],[21,0,21,1],[21,4,22,4],[21,7,22,7],[21,8,22,8],[21,11,22,11],[22,0,22,1],[24,0,24,1],[24,4,25,4],[24,7,25,7],[24,8,25,8],[24,11,25,11],[25,0,25,1],[27,0,27,1],[27,4,28,4],[27,7,28,7],[27,8,28,8],[27,11,28,11],[28,0,28,1],[30,0,30,1],[30,4,31,4],[30,7,31,7],[30,8,31,8],[30,11,31,11],[31,0,31,1],[33,0,33,1],[33,4,34,4],[33,7,34,7],[33,8,34,8],[33,11,34,11],[34,0,34,1],[36,0,36,1],[36,4,37,4],[36,7,37,7],[36,8,37,8],[36,11,37,11],[37,0,37,1],[39,0,39,1],[39,4,40,4],[39,7,40,7],[39,8,40,8],[39,11,40,11],[40,0,40,1],[42,0,42,1],[42,4,43,4],[42,7,43,7],[42,8,43,8],[42,11,43,11],[43,0,43,1],[45,0,45,1],[46,0,46,1],[49,0,49,11]],"flags":["formulas_cached_only"]}
["CATV Cable Loss and Tap Computation"]
[null,"Customer:","name",{"$nulls":7},"Page",3]
[null,"Job Number:","k"]
[null,"Rev:",0.5]
[null,"Date:","2007-02-12"]
[]
[null,"Levels",{"$nulls":8},275,"cable length - this sheet"]
["Freq.","Source",null,"Target min","Target max","Sheet output"]
["50 MHz",null,28.490000000000002,5,10,21.42333333333334,null,"typical VCR modulator out is +7 dBm"]
["450 MHz",null,28.490000000000002,5,10,21.42333333333334,null,"typical required TV input level is +5 to +10 dBm"]
[]
[null,"Cable",null,"RF","Tap",null,null,"Tap cable",null,null,"Device"]
[null,"Length","Loss","Level","Value","Loss in dB",null,"Length",null,"Loss","signal","description"]
[null,"Ft","dB","dBm","dB","real","fig.","real",null,"dB","dBm"]
[null,25]
["50 MHz",null,0.375,28.115000000000002,20,null,{"v":0.7000000000000001,"d":"0.7"},null,{"v":20,"d":"20.0"},0.3,7.815000000000002,"Coffee Shop 1"]
["450 MHz",null,0.375,28.115000000000002,null,null,{"v":0.7000000000000001,"d":"0.7"},null,null,0.3,7.815000000000002]
[null,10]
["50 MHz",null,0.15,27.265000000000004,20,null,{"v":0.7000000000000001,"d":"0.7"},{"v":30,"d":"30.0"},{"v":30,"d":"30.0"},0.45,6.815000000000004,"Coffee Shop 2"]
["450 MHz",null,0.15,27.265000000000004,null,null,{"v":0.7000000000000001,"d":"0.7"},null,null,0.45,6.815000000000004]
[null,10]
["50 MHz",null,0.15,26.415000000000006,16,null,{"v":0.875,"d":"0.9"},{"v":40,"d":"40.0"},{"v":40,"d":"40.0"},0.6,9.815000000000007,"Nursery"]
["450 MHz",null,0.15,26.415000000000006,null,null,{"v":0.875,"d":"0.9"},null,null,0.6,9.815000000000007]
[null,20]
["50 MHz",null,0.3,25.240000000000006,16,null,{"v":0.875,"d":"0.9"},null,{"v":20,"d":"20.0"},0.3,8.940000000000005,"Receptionist"]
["450 MHz",null,0.3,25.240000000000006,null,null,{"v":0.875,"d":"0.9"},null,null,0.3,8.940000000000005]
[null,30]
["50 MHz",null,0.45,23.915000000000006,16,null,{"v":0.875,"d":"0.9"},null,{"v":20,"d":"20.0"},0.3,7.615000000000006,"Pastor"]
["450 MHz",null,0.45,23.915000000000006,null,null,{"v":0.875,"d":"0.9"},null,null,0.3,7.615000000000006]
[null,30]
["50 MHz",null,0.45,22.590000000000007,12,null,{"v":1.1666666666666665,"d":"1.2"},null,{"v":20,"d":"20.0"},0.3,10.290000000000006,"Creative Room"]
["450 MHz",null,0.45,22.590000000000007,null,null,{"v":1.1666666666666665,"d":"1.2"},null,null,0.3,10.290000000000006]
[]
["50 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,21.42333333333334]
["450 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,null,0,21.42333333333334]
[]
["50 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,21.42333333333334]
["450 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,null,0,21.42333333333334]
[]
["50 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,21.42333333333334]
["450 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,null,0,21.42333333333334]
[]
["50 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,21.42333333333334]
["450 MHz",null,0,21.42333333333334,null,null,{"v":0,"d":"0.0"},null,null,0,21.42333333333334]
[]
["50 MHz",null,0,21.42333333333334]
["450 MHz",null,0,21.42333333333334]
[]
["Version 3.0",null,"Copyright 2006 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."]

{"sheet":"Line2","index":3,"n_rows":50,"n_cols":12,"rows_kept":50,"merged":[[4,2,4,3],[6,1,6,5],[7,1,7,2],[11,1,11,2],[11,4,11,6],[11,7,11,9],[12,5,12,6],[12,7,12,8],[12,11,13,11],[15,0,15,1],[15,4,16,4],[15,7,16,7],[15,8,16,8],[15,11,16,11],[16,0,16,1],[18,0,18,1],[18,4,19,4],[18,7,19,7],[18,8,19,8],[18,11,19,11],[19,0,19,1],[21,0,21,1],[21,4,22,4],[21,7,22,7],[21,8,22,8],[21,11,22,11],[22,0,22,1],[24,0,24,1],[24,4,25,4],[24,7,25,7],[24,8,25,8],[24,11,25,11],[25,0,25,1],[27,0,27,1],[27,4,28,4],[27,7,28,7],[27,8,28,8],[27,11,28,11],[28,0,28,1],[30,0,30,1],[30,4,31,4],[30,7,31,7],[30,8,31,8],[30,11,31,11],[31,0,31,1],[33,0,33,1],[33,4,34,4],[33,7,34,7],[33,8,34,8],[33,11,34,11],[34,0,34,1],[36,0,36,1],[36,4,37,4],[36,7,37,7],[36,8,37,8],[36,11,37,11],[37,0,37,1],[39,0,39,1],[39,4,40,4],[39,7,40,7],[39,8,40,8],[39,11,40,11],[40,0,40,1],[42,0,42,1],[42,4,43,4],[42,7,43,7],[42,8,43,8],[42,11,43,11],[43,0,43,1],[45,0,45,1],[46,0,46,1],[49,0,49,11]],"flags":["formulas_cached_only"]}
["CATV Cable Loss and Tap Computation"]
[null,"Customer:","name",{"$nulls":7},"Page",4]
[null,"Job Number:","k"]
[null,"Rev:",0.5]
[null,"Date:","2007-02-12"]
[]
[null,"Levels",{"$nulls":8},135,"cable length - this sheet"]
["Freq.","Source",null,"Target min","Target max","Sheet output"]
["50 MHz",null,28.490000000000002,5,10,20.273333333333337,null,"typical VCR modulator out is +7 dBm"]
["450 MHz",null,28.490000000000002,5,10,20.273333333333337,null,"typical required TV input level is +5 to +10 dBm"]
[]
[null,"Cable",null,"RF","Tap",null,null,"Tap cable",null,null,"Device"]
[null,"Length","Loss","Level","Value","Loss in dB",null,"Length",null,"Loss","signal","description"]
[null,"Ft","dB","dBm","dB","real","fig.","real",null,"dB","dBm"]
[null,5]
["50 MHz",null,0.075,28.415000000000003,20,null,{"v":0.7000000000000001,"d":"0.7"},null,{"v":20,"d":"20.0"},0.3,8.115000000000002,"Lobby 1"]
["450 MHz",null,0.075,28.415000000000003,null,null,{"v":0.7000000000000001,"d":"0.7"},null,null,0.3,8.115000000000002]
[null,5]
["50 MHz",null,0.075,27.640000000000004,20,null,{"v":0.7000000000000001,"d":"0.7"},null,{"v":20,"d":"20.0"},0.3,7.340000000000004,"Lobby 2"]
["450 MHz",null,0.075,27.640000000000004,null,null,{"v":0.7000000000000001,"d":"0.7"},null,null,0.3,7.340000000000004]
[null,5]
["50 MHz",null,0.075,26.865000000000006,20,null,{"v":0.7000000000000001,"d":"0.7"},null,{"v":20,"d":"20.0"},0.3,6.565000000000006,"Lobby 3"]
["450 MHz",null,0.075,26.865000000000006,null,null,{"v":0.7000000000000001,"d":"0.7"},null,null,0.3,6.565000000000006]
[null,40]
["50 MHz",null,0.6,25.565000000000005,16,null,{"v":0.875,"d":"0.9"},{"v":30,"d":"30.0"},{"v":30,"d":"30.0"},0.45,9.115000000000006,"Classroom"]
["450 MHz",null,0.6,25.565000000000005,null,null,{"v":0.875,"d":"0.9"},null,null,0.45,9.115000000000006]
[null,20]
["50 MHz",null,0.3,24.390000000000004,16,null,{"v":0.875,"d":"0.9"},null,{"v":20,"d":"20.0"},0.3,8.090000000000003,"future classroom"]
["450 MHz",null,0.3,24.390000000000004,null,null,{"v":0.875,"d":"0.9"},null,null,0.3,8.090000000000003]
[null,30]
["50 MHz",null,0.45,23.065000000000005,16,null,{"v":0.875,"d":"0.9"},null,{"v":20,"d":"20.0"},0.3,6.765000000000005,"future classroom"]
["450 MHz",null,0.45,23.065000000000005,null,null,{"v":0.875,"d":"0.9"},null,null,0.3,6.765000000000005]
[null,30]
["50 MHz",null,0.3,21.890000000000004,12,null,{"v":1.1666666666666665,"d":"1.2"},null,{"v":20,"d":"20.0"},0.3,9.590000000000003,"Music room"]
["450 MHz",null,0.3,21.890000000000004,null,null,{"v":1.1666666666666665,"d":"1.2"},null,null,0.3,9.590000000000003]
[]
["50 MHz",null,0,20.723333333333336,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,20.723333333333336]
["450 MHz",null,0,20.723333333333336,null,null,{"v":0,"d":"0.0"},null,null,0,20.723333333333336]
[]
["50 MHz",null,0.45,20.273333333333337,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,20.273333333333337]
["450 MHz",null,0.45,20.273333333333337,null,null,{"v":0,"d":"0.0"},null,null,0,20.273333333333337]
[]
["50 MHz",null,0,20.273333333333337,null,null,{"v":0,"d":"0.0"},null,{"v":0,"d":"0.0"},0,20.273333333333337]
["450 MHz",null,0,20.273333333333337,null,null,{"v":0,"d":"0.0"},null,null,0,20.273333333333337]
[]
["50 MHz",null,0,20.273333333333337]
["450 MHz",null,0,20.273333333333337]
[]
["Version 3.0",null,"Copyright 2006 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."]

{"sheet":"tailend","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"hidden":true,"flags":["formulas_cached_only"]}