{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FSPL","Antenna Placement","3OIP Calc","Wave Calc","VSWR"],"not_rendered":{"charts":2,"images":1,"macros":1,"external_links":0,"defined_names":10,"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":"1904"}

{"sheet":"FSPL","index":0,"n_rows":94,"n_cols":22,"rows_kept":94,"cut":false,"hidden":false,"merged":[[2,8,2,10],[3,8,3,9],[4,8,4,10],[5,8,5,9],[14,8,14,10],[6,1,6,6],[7,2,7,4],[6,13,6,18],[63,1,63,6],[17,1,17,6],[19,1,19,6],[27,1,27,6],[40,1,40,6],[35,1,35,6],[34,1,34,6],[8,1,8,6],[9,8,9,10],[13,1,13,6],[55,1,55,6],[27,13,27,15],[48,1,48,6],[52,1,52,6],[7,20,7,21],[7,13,7,14],[7,15,7,16],[7,17,7,18],[15,8,15,9],[16,8,16,10],[17,8,17,9],[92,1,92,6],[87,1,87,6],[64,1,64,6],[73,1,73,6],[68,1,68,6],[82,1,82,6]]}
[]
[null,null,null,null,"Path Loss Calculator"]
[null,null,null,null,"Calculates RF Path Loss"]
[]
[null,"http://rfcoordinationnyc.com"]
[]
[null,"Units",null,null,null,null,null,null,null,null,null,null,null,"Cable Type"]
[null,"feet or meters","select feet of meters in dropdown menu",null,null,"feet",null,null,null,null,null,null,null,null,null,"loss @ 100 feet",null,"loss @ 100 meters",null,null,"Gain @ Distance & Freq"]
[null,"Frequency",null,null,null,null,null,null,null,null,null,null,null,"Cable Type","units","400MHz","900MHz","400MHz","900MHz",null,null,"units"]
[null,null,"variable","units",null,null,"units",null,"Custom Antennas",null,null,null,null,"none","dBi",0,0,{"$f":"P10*3.28","v":0},{"$f":"Q10*3.28","v":0},null,{"$f":"(((Q10-P10)/500)*(F11-400)+P10)*(F21/100)","v":0},"dBi"]
[null,"Frequency","f","MHz","frequency of transmitter",550,"MHz",null,"Custom Antenna A",3,"dBi",null,null,"RG-174","dBi",19,31,{"$f":"P11*3.28","v":62.319999999999993},{"$f":"Q11*3.28","v":101.67999999999999},null,{"$f":"(((Q11-P11)/500)*(F11-400)+P11)*(F21/100)","v":5.65},"dBi"]
[null,"Transmitter Power","P","mW","power of transmitter in mW",20,"mW",null,"Custom Antenna B",6,"dBi",null,null,"LMR-195","dBi",7.3,11.1,23.943999999999999,36.407999999999994,null,{"$f":"(((Q12-P12)/500)*(F11-400)+P12)*(F21/100)","v":2.11},"dBi"]
[null,"Noise Floor",null,"dBm",null,-90,"dBm",null,null,null,null,null,null,"LMR-240","dBi",5,7.6,16.399999999999999,24.927999999999997,null,{"$f":"(((Q13-P13)/500)*(F11-400)+P13)*(F21/100)","v":1.4449999999999998},"dBi"]
[null,"TX System",null,null,null,null,null,null,null,null,null,null,null,"LMR-240-UF","dBi",6,9.1,19.68,29.847999999999995,null,{"$f":"(((Q14-P14)/500)*(F11-400)+P14)*(F21/100)","v":1.7324999999999999},"dBi"]
[null,"Cable Distance Transmit","d",{"$f":"IF(J15=\"feet\", (\"feet\"), (\"meters\"))","v":"meters"},"length of transmit cable",10,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,"Comments or suggestions are welcome",null,null,null,null,"RG8X","dBi",6.6,10.7,21.647999999999996,35.095999999999997,null,{"$f":"(((Q15-P15)/500)*(F11-400)+P15)*(F21/100)","v":1.9574999999999998},"dBi"]
[null,"Cable Type Transmit",null,"n/a","select type of cable","LMR-240-UF",null,null,"Paul McDermott",null,null,null,null,"Belden 9240 RG58","dBi",6.6,10.1,21.647999999999996,33.128,null,{"$f":"(((Q16-P16)/500)*(F11-400)+P16)*(F21/100)","v":1.9124999999999999},"dBi"]
[null,"Antenna Type  Transmit",null,"dBi","gain referenced to isotropic","LPDA",null,null,"http://rfcoordinationnyc.com",null,null,null,null,"Belden 8267 RG213","dBi",4.0999999999999996,7.6,13.447999999999999,24.927999999999997,null,{"$f":"(((Q17-P17)/500)*(F11-400)+P17)*(F21/100)","v":1.2874999999999999},"dBi"]
[null,"Free Space Loss",null,null,null,null,null,null,"thunderpaul@me.com",null,null,null,null,"LMR-400-UF","dBi",3.1,4.7,10.167999999999999,15.416,null,{"$f":"(((Q18-P18)/500)*(F11-400)+P18)*(F21/100)","v":0.89500000000000002},"dBi"]
[null,"Free Space Distance","d","f","Free Space Loss",10,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,"Belden 9913 RG8/U","dBi",3,4.7,9.84,15.416,null,{"$f":"(((Q19-P19)/500)*(F11-400)+P19)*(F21/100)","v":0.87749999999999995},"dBi"]
[null,"Rx System",null,null,null,null,null,null,null,null,null,null,null,"Wireman CQ106","dBi",3,4.5,9.84,14.76,null,{"$f":"(((Q20-P20)/500)*(F11-400)+P20)*(F21/100)","v":0.86250000000000004},"dBi"]
[null,"Cable Distance Receive","d","f","length of Receiver cable",25,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,"Gepco V5010","dBi",2.6,4,8.5280000000000005,13.12,null,{"$f":"(((Q21-P21)/500)*(F11-400)+P21)*(F21/100)","v":0.755},"dBi"]
[null,"Antenna Type Receive",null,"dBi","gain referenced to isotropic","LPDA",null,null,null,null,null,null,null,"LMR-400","dBi",2.5,3.9,8.1999999999999993,12.792,null,{"$f":"(((Q22-P22)/500)*(F11-400)+P22)*(F21/100)","v":0.73},"dBi"]
[null,"Cable Type",null,"n/a","select type of cable","LMR-240"]
[null,"line amp Gain",null,null,"includes amp on active antenna",0,"dB"]
[null,"attenuation",null,null,null,0,"dB"]
[null,"BNC Connections",null,null,"# of BNC connections",0]
[]
[null,"Results",null,null,null,null,null,null,null,null,null,null,null,"Antenna Type"]
[null,"TX System EIRP",null,null,"Effective Radiated Power at Tx antenna",{"$f":"F54","v":18.817299956639815},"dBm",null,null,null,null,null,null,"Antenna Type","variable","units",null,"Unit"]
[null,"Free Space Loss",null,null,"Loss due to distance between Tx and Rx",{"$f":"F62","v":-36.927253789884865},"dBm",null,null,null,null,null,null,"Mic or Belt pack",-0.85,"dBi",null,"feet"]
[null,"Rx System Loss",null,null,null,{"$f":"F89","v":5.0549999999999997},"dBm",null,null,null,null,null,null,"1/4 wave whip",-0.85,"dBi",null,"meters"]
[null,"Total Path Loss",null,null,null,{"$f":"F94","v":-13.054953833245051},"dBm",null,null,null,null,null,null,"1/2 wave whip",2.15,"dBi"]
[null,"Signal to Noise Ratio",null,null,"Difference between signal compared to noise floor",{"$f":"-(F13-F32)","v":76.945046166754949},"dB",null,null,null,null,null,null,"Dipole",2.7,"dBi"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"LPDA",6.5,"dBi"]
[null,"Tx System",null,null,null,null,null,null,null,null,null,null,null,"Helical",14,"dBi"]
[null,"Tx Power",null,null,null,null,null,null,null,null,null,null,null,"Domed Helical",8,"dBi"]
[null,null,"variable","units","Equation",null,"units",null,null,null,null,null,null,"Wideband Dipole",2.15,"dBi"]
[null,"Transmitter Power","P","mW","power of transmitter in mW",{"$f":"F12","v":20},"mW",null,null,null,null,null,null,"Isotropic",0,"dBi"]
[null,"EIRP","P","dBm","EIRP(dBm) = 10 ⋅ log10( P(W) / 1W) + 30",{"$f":"10*(LOG10(F38/1000))+30","v":13.010299956639813},"dBm"]
[null,"ERP","P","dBm","ERP = EIRP(dBm) - 2.15",{"$f":"F39-2.15","v":10.860299956639812},"dBm",null,null,null,null,null,null,"Custom A",{"$f":"J11","v":3},"dBi"]
[null," Tx Cable Loss Calculator (feet)",null,null,null,null,null,null,null,null,null,null,null,"Custom B",{"$f":"J12","v":6},"dBi"]
[null,null,"variable","units","Equation",null,"units"]
[null,"Frequency","f","MHz","frequency of transmitter",{"$f":"F11","v":550},"MHz"]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"length of Tx cable",{"$f":"F15","v":10},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,"Antenna Amp Gain Type","variable","units"]
[null,"Cable Type",null,"n/a","select type of cable",{"$f":"F16","v":"LMR-240-UF"},null,null,null,null,null,null,null,0,0,"dBi"]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 400MHz per 100 feet\",\"Loss @ 400MHz per 100 meters\")","v":"Loss @ 400MHz per 100 feet"},null,"dB",null,{"$f":"VLOOKUP(F45,$N$10:$S$22,IF(F8=\"feet\",3,5),FALSE)","v":6},"dB",null,null,null,null,null,null,3,3,"dBi"]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 900MHz per 100 feet\",\"Loss @ 900MHz per 100 meters\")","v":"Loss @ 900MHz per 100 feet"},null,"dB",null,{"$f":"VLOOKUP(F45,$N$10:$S$22,IF(F8=\"feet\",4,6),FALSE)","v":9.1},"dB",null,null,null,null,null,null,6,6,"dBi"]
[null,"Cable Loss @ f0",null,"dB","Cable loss @ f0",{"$f":"-(((F47-F46)/500)*(F43-400)+F46)*(F44/100)","v":-0.69300000000000006},"dB",null,null,null,null,null,null,9,9,"dBi"]
[null," Tx Antenna Gain",null,null,null,null,null,null,null,null,null,null,null,12,12,"dBi"]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,18,18,"dBi"]
[null,"Antenna Type ",null,"dBi","gain referenced to isotropic",{"$f":"F17","v":"LPDA"},"dBi",null,null,null,null,null,null,24,24,"dBi"]
[null,"antenna Gain",null,null,null,{"$f":"VLOOKUP(F51,$N$30:$P$41,2,FALSE)","v":6.5}]
[null,"Tx Results"]
[null,"Total Tx System Loss",null,null,null,{"$f":"F39+F48+F52","v":18.817299956639815},"dBm",null,null,null,null,null,null,"Attenuation","variable","units"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"dB"]
[null,"Free Space Path Loss Calculator (feet)",null,null,null,null,null,null,null,null,null,null,null,-3,-3,"dB"]
[null,null,"variable","units","Equation",null,"units",null,null,null,null,null,null,-6,-6,"dB"]
[null,"Frequency","f","MHz",null,{"$f":"F11","v":550},"MHz",null,null,null,null,null,null,-9,-9,"dB"]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"Free Space Loss",{"$f":"F19","v":10},{"$f":"J15","v":0},null,null,null,null,null,null,-10,-10,"dB"]
[null,"Speed of Light (Feet)","c","f/s",-37.880000000000003,983571056.42999995,"f/s",null,null,null,null,null,null,-20,-20,"dB"]
[null,"Speed of Light (Meters)","c","m/s",-27.55,299792458,"m/s",null,null,null,null,null,null,-30,-30,"dB"]
[null,"Free Space Path Loss","FSPL","dB","20log10(d)+20log10(f)+20log10(4π/c)",{"$f":"-(20*LOG10(F59)+20*LOG10(F58)-IF(F8=\"feet\",37.88,27.55))","v":-36.927253789884865},"dB"]
[]
[null,"Rx System"]
[null,"Rx Antenna Gain"]
[null,null,"variable","units",null,null,"units"]
[null,"Antenna Type ",null,"dBi","gain referenced to isotropic antenna",{"$f":"F22","v":"LPDA"},"dBi"]
[null,"antenna Gain",null,null,null,{"$f":"VLOOKUP(F67,$N$30:$P$41,2,FALSE)","v":6.5}]
[null,"Rx Amp Gain "]
[null,null,"variable","units",null,null,"units"]
[null,"line amp Gain",null,null,null,{"$f":"F24","v":0},"dB"]
[null,"attenuators",null,null,null,{"$f":"F25","v":0},"dB"]
[null,"couplers",null,null,".5 dB for each BNC connection",{"$f":"F26*-0.5","v":0},"dB"]
[null,"Rx Cable Loss"]
[null,null,"variable","units","Equation",null,"units"]
[null,"Frequency","f","MHz","frequency of transmitter",{"$f":"F11","v":550},"MHz"]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"length of Rx cable",{"$f":"F21","v":25},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"Cable Type",null,"n/a","select type of cable",{"$f":"F23","v":"LMR-240"}]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 400MHz per 100 feet\",\"Loss @ 400MHz per 100 meters\")","v":"Loss @ 400MHz per 100 feet"},"L400","dB",{"$f":"IF(F8=\"feet\",\"loss per 100 feet\",\"loss per 100 meters\")","v":"loss per 100 feet"},{"$f":"VLOOKUP(F78,$N$10:$S$22,IF(F8=\"feet\",3,5),FALSE)","v":5},"dB"]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 900MHz per 100 feet\",\"Loss @ 900MHz per 100 meters\")","v":"Loss @ 900MHz per 100 feet"},"L900","dB",{"$f":"IF(F8=\"feet\",\"loss per 100 feet\",\"loss per 100 meters\")","v":"loss per 100 feet"},{"$f":"VLOOKUP(F78,$N$10:$S$22,IF(F8=\"feet\",4,6),FALSE)","v":7.6},"dB"]
[null,"Cable Loss @ f0",null,"dB","(((Lf2-Lf1)/(f2-f1))*(f0-f1)+Lf1)*(d/100)",{"$f":"-(((F80-F79)/500)*(F76-400)+F79)*(F77/100)","v":-1.4449999999999998},"dB"]
[]
[null,"Rx RF Distribution Gain"]
[null,null,"variable","units",null,null,"units"]
[null,"line amp Gain","gAm","dB",null,null,"dB"]
[null,"attenuators","gAt","dB",null,null,"dB"]
[null,"couplers","gC","dB","# of BNC connections * -.5",{"$f":"F42*-0.5","v":0},"dB"]
[null,"Rx Results"]
[null,"Total Tx System Loss",null,null,null,{"$f":"F68+F71+F72+F73+F81+F85+F86+F87","v":5.0549999999999997},"dBm"]
[]
[]
[]
[null,"Total Loss "]
[null,"Total Path Loss",null,null,null,{"$f":"F54+F62+F89","v":-13.054953833245051},"dBm"]

{"sheet":"Antenna Placement","index":1,"n_rows":103,"n_cols":25,"rows_kept":103,"cut":false,"hidden":false,"merged":[[4,8,4,10],[5,8,5,9],[6,1,6,6],[1,8,3,10],[7,23,7,24],[78,1,78,6],[86,1,86,6],[90,1,90,6],[93,1,93,6],[44,1,44,6],[18,1,18,6],[16,1,17,4],[42,8,42,10],[43,8,43,9],[44,8,44,10],[45,8,45,9],[23,1,23,6],[39,1,39,6],[40,1,40,6],[30,8,30,9],[31,19,31,22],[96,1,96,6],[97,1,97,6],[28,1,28,6],[7,2,7,4],[7,19,7,20],[7,21,7,22],[24,8,24,11],[29,8,29,9],[74,1,74,6],[52,1,52,6],[57,1,57,6],[60,1,60,6],[68,1,68,6],[69,1,69,6],[1,19,1,24],[36,1,37,6],[57,19,57,21],[70,19,70,22],[8,2,8,4],[9,2,9,4],[10,2,10,4],[11,2,11,4],[12,2,12,4],[13,2,13,4],[32,8,32,11],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[6,19,6,24]]}
[]
[null,null,null,null,"Tx Rx Antenna Placement Calculator",null,null,null,"This Calculatr is a brta version. \nIf anyone wants to help with accurate\n antenna polar patterns send mw an email.",null,null,null,null,null,null,null,null,null,null,"Validation Tables"]
[null,null,null,null,"Calculates 2T3rd Order IMDs Created in Antenna Distribution"]
[]
[null,"http://rfcoordinationnyc.com"]
[null,null,null,null,null,null,null,null,null,null,null,"Orientation"]
[null,"Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Type"]
[null,"feet or meters","select feet of meters",null,null,"feet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"loss @ 100 feet",null,"loss @ 100 meters"]
[null,"Orientation","Orientation between Antennas",null,null,"Rx Forward",null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Type","units","400MHz","900MHz","400MHz","900MHz"]
[null,"Transmitter Power","power of transmitter in mW",null,null,50,"mW",null,null,null,null,null,null,null,null,null,null,null,null,"none","dBi",0,0,{"$f":"V10*3.28","v":0},{"$f":"W10*3.28","v":0}]
[null,"Antenna Type  Transmit","Transmit Antenna",null,null,"Isotropic",null,null,null,null,null,null,null,null,null,null,null,null,null,"RG-174","dBi",19,31,{"$f":"V11*3.28","v":62.319999999999993},101.67999999999999]
[null,"Antenna Type Receive","Receive Antenna",null,null,"Isotropic",null,null,null,null,null,null,null,null,null,null,null,null,null,"LMR-195","dBi",7.3,11.1,23.943999999999999,36.407999999999994]
[null,"Free Space Distance","Distance Between Antennas",null,null,3,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,null,null,null,null,"LMR-240","dBi",5,7.6,16.399999999999999,24.927999999999997]
[null,"TOIP","Third Order intercept point of Antenna Ditribution",null,null,21,"dBm",null,null,null,null,"Distance",null,null,null,null,null,null,null,"LMR-240-UF","dBi",6,9.1,19.68,29.847999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RG8X","dBi",6.6,10.7,21.647999999999996,35.095999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belden 9240 RG58","dBi",6.6,10.1,21.647999999999996,33.128]
[null,"Advanced Parameters",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belden 8267 RG213","dBi",4.0999999999999996,7.6,13.447999999999999,24.927999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LMR-400-UF","dBi",3.1,4.7,10.167999999999999,15.416]
[null,"TX System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Belden 9913 RG8/U","dBi",3,4.7,9.84,15.416]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,null,null,null,null,null,null,"Wireman CQ106","dBi",3,4.5,9.84,14.76]
[null,"Frequency","f0","MHz","frequency of transmitter",470,"MHz",null,null,null,null,null,null,null,null,null,null,null,null,"Gepco V5010","dBi",2.6,4,8.5280000000000005,13.12]
[null,"Cable Distance Transmit","d",{"$f":"IF(J43=\"feet\", (\"feet\"), (\"meters\"))","v":"meters"},"length of transmit cable",0,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,null,null,null,null,"LMR-400","dBi",2.5,3.9,8.1999999999999993,12.792]
[null,"Cable Type Transmit",null,"n/a","select type of cable","RG8X"]
[null,"Rx System"]
[null,"Cable Distance Receive","d","f","length of Receiver cable",0,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,"Results"]
[null,"Cable Type",null,"n/a","select type of cable","RG8X",null,null,"Effective Radiated Power at Tx antenna",null,{"$f":"F59","v":16.989700043360187},"dBm",null,null,null,null,null,null,null,"Unit",null,"Orientation","TX Antenna","Rx Antenna"]
[null,"line amp Gain",null,null,"includes amp on active antenna",0,"dB",null,"Loss due to distance between Tx and Rx",null,{"$f":"F67","v":-25.104382253107595},"dBm",null,null,null,null,null,null,null,"feet",null,"Parallel","90 Gain","90 Gain"]
[null,"Attenuation",null,null,"Additional Attenuation",0,"dB",null,"EIRP at Tx Antenna",null,{"$f":"F92","v":0},"dBm",null,null,null,null,null,null,null,"meters",null,"Tx Forward","180 Gain","Forward Gain"]
[null,"Noise Floor",null,null,null,null,null,null,"Total RF Gain It Antenna Distribution",null,{"$f":"F95","v":-8.1146822097474072},"dBm",null,null,null,null,null,null,null,null,null,"Rx Forward","Forward Gain","180 Gain"]
[null,"Noise Floor",null,null,null,-100,null,null,"2T3O IMD Generated in Distribution",null,{"$f":"F101","v":-66.344046629242229},"dBm"]
[null,null,null,null,null,null,null,null,"2T3O IMD relation to Noise Floor",null,{"$f":"F103","v":33.655953370757771},"dBm"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Antenna Type"]
[null,null,null,null,null,null,null,null,"Custom Antennas",null,null,null,null,null,null,null,null,null,null,"Antenna Type","Forward Gain","180º Gain","90º Gain"]
[null,null,null,null,null,null,null,null,null,"Forward G","180º Gain","90º Gain",null,null,null,null,null,null,null,"Mic or Belt pack",-0.85,-0.85,-0.85]
[null,null,null,null,null,null,null,null,"Custom Antenna A",9,3,3,null,null,null,null,null,null,null,"1/4 wave whip",-0.85,-0.85,-0.85]
[null,null,null,null,null,null,null,null,"Custom Antenna B",6,6,3,null,null,null,null,null,null,null,"1/2 wave whip",2.15,2.15,2.15]
[null,"Use For Calculation For Reference Only Do not edit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Dipole",2.7,2.7,2.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LPDA",6.5,-6.5,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Helical",14,-16,-26]
[null,"Tx System",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Domed Helical",10,-4,-8]
[null,"Tx Power",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Wideband Dipole",2.15,2.15,2.15]
[null,null,"variable","units","Equation",null,"units",null,null,null,null,null,null,null,null,null,null,null,null,"Isotropic",0,0,0]
[null,"Transmitter Power","P","mW","power of transmitter in mW",{"$f":"F10","v":50},"mW",null,"Comments or suggestions are welcome"]
[null,"EIRP","P","dBm","EIRP(dBm) = 10 ⋅ log10( P(W) / 1W) + 30",{"$f":"10*(LOG10(F43/1000))+30","v":16.989700043360187},"dBm",null,"Paul McDermott",null,null,null,null,null,null,null,null,null,null,"Custom A",{"$f":"J35","v":9},3,3]
[null," Tx Cable Loss Calculator (feet)",null,null,null,null,null,null,"http://rfcoordinationnyc.com",null,null,null,null,null,null,null,null,null,null,"Custom B",6,6,3]
[null,null,"variable","units","Equation",null,"units",null,"thunderpaul@me.com"]
[null,"Frequency","f0","MHz","frequency of transmitter",{"$f":"F21","v":470},"MHz"]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"length of Tx cable",{"$f":"F22","v":0},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,null,null,null,null,"Ant Amp Gain","variable","units",null,"numbers"]
[null,"Cable Type",null,"n/a","select type of cable",{"$f":"F23","v":"RG8X"},null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"dBi",null,"#"]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 400MHz per 100 feet\",\"Loss @ 400MHz per 100 meters\")","v":"Loss @ 400MHz per 100 feet"},null,"dB",null,{"$f":"VLOOKUP(F49,$T$10:$Y$22,IF(F8=\"feet\",3,5),FALSE)","v":6.6},"dB",null,null,null,null,null,null,null,null,null,null,null,null,3,3,"dBi",null,0]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 900MHz per 100 feet\",\"Loss @ 900MHz per 100 meters\")","v":"Loss @ 900MHz per 100 feet"},null,"dB",null,{"$f":"VLOOKUP(F49,$T$10:$Y$22,IF(F8=\"feet\",4,6),FALSE)","v":10.7},"dB",null,null,null,null,null,null,null,null,null,null,null,null,6,6,"dBi",null,1]
[null,"Cable Loss @ f0",null,"dB","Cable loss @ f0",{"$f":"-(((F51-F50)/500)*(F47-400)+F50)*(F48/100)","v":0},"dB",null,null,null,null,null,null,null,null,null,null,null,null,9,9,"dBi",null,2]
[null," Tx Antenna Gain",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,12,"dBi",null,3]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,null,null,null,null,null,null,18,18,"dBi",null,4]
[null,"Antenna Type ",null,"dBi","gain referenced to isotropic",{"$f":"F11","v":"Isotropic"},"dBi",null,null,null,null,null,null,null,null,null,null,null,null,24,24,"dBi",null,5]
[null,"Antenna Orientation",null,null,null,{"$f":"VLOOKUP(F9,$V$27:$X$29,2,FALSE)","v":"Forward Gain"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,"antenna Gain",null,null,null,{"$f":"VLOOKUP(F55,$T$34:$W$45,IF(F56=\"Forward Gain\",2,IF(F56=\"180 Gain\",3,4)),FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7]
[null,"Tx Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Attenuation",null,null,null,8]
[null,"Total Tx System Loss",null,null,"TX System EIRP",{"$f":"F44+F52+F57","v":16.989700043360187},"dBm",null,null,null,null,null,null,null,null,null,null,null,null,"Attenuation","variable","units",null,9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,"dB",null,10]
[null,"Free Space Path Loss Calculator (feet)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,-3,-3,"dB",null,11]
[null,null,"variable","units","Equation",null,"units",null,null,null,null,null,null,null,null,null,null,null,null,-6,-6,"dB",null,12]
[null,"Frequency","f0","MHz",null,{"$f":"F21","v":470},"MHz",null,null,null,null,null,null,null,null,null,null,null,null,-9,-9,"dB",null,13]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"Free Space Loss",{"$f":"F13","v":3},{"$f":"J43","v":0},null,null,null,null,null,null,null,null,null,null,null,null,-10,-10,"dB",null,14]
[null,"Speed of Light (Feet)","c","f/s",-37.880000000000003,983571056.42999995,"f/s",null,null,null,null,null,null,null,null,null,null,null,null,-20,-20,"dB",null,15]
[null,"Speed of Light (Meters)","c","m/s",-27.55,299792458,"m/s",null,null,null,null,null,null,null,null,null,null,null,null,-30,-30,"dB",null,16]
[null,"dB Above Noise Floor","FSPL","dB","20log10(d)+20log10(f)+20log10(4π/c)",{"$f":"-(20*LOG10(F64)+20*LOG10(F63)-IF(F8=\"feet\",37.88,27.55))","v":-25.104382253107595},"dB"]
[]
[null,"Rx System"]
[null,"Rx Antenna Gain"]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,null,null,null,null,null,null,"Chart Data"]
[null,"Antenna Type ",null,"dBi","gain referenced to isotropic antenna",{"$f":"F12","v":"Isotropic"},"dBi",null,null,null,null,null,null,null,null,null,null,null,null,null,"dBm","MHz","MHz"]
[null,"Antenna Orientation",null,null,null,{"$f":"VLOOKUP(F9,$V$27:$X$29,3,FALSE)","v":"180 Gain"},null,null,null,null,null,null,null,null,null,null,null,null,null,"1st Tone",-120,{"$f":"K29","v":-8.1146822097474072},{"$f":"F21","v":470}]
[null,"antenna Gain",null,null,null,{"$f":"VLOOKUP(F72,$T$34:$W$45,IF(F73=\"Forward Gain\",2,IF(F73=\"180 Gain\",3,4)),FALSE)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"1st Tone",-120,-120,{"$f":"F21","v":470}]
[null,"Rx Amp Gain ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2nd Tone",-120,{"$f":"K29","v":-8.1146822097474072},{"$f":"F21+1","v":471}]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,null,null,null,null,null,null,"2nd Tone",-120,-120,{"$f":"F21+1","v":471}]
[null,"line amp Gain",null,null,null,{"$f":"F27","v":0},"dB",null,null,null,null,null,null,null,null,null,null,null,null,"Lower 2T3O IMD",null,{"$f":"K30","v":-66.344046629242229},{"$f":"W73-1","v":469}]
[null,"attenuators",null,null,null,{"$f":"F28","v":0},"dB",null,null,null,null,null,null,null,null,null,null,null,null,"Lower 2T3O IMD",null,-120,{"$f":"W73-1","v":469}]
[null,"Rx Cable Loss",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Upper 2T3O IMD",null,{"$f":"K30","v":-66.344046629242229},{"$f":"W75+1","v":472}]
[null,null,"variable","units","Equation",null,"units",null,null,null,null,null,null,null,null,null,null,null,null,"Upper 2T3O IMD",null,-120,{"$f":"W75+1","v":472}]
[null,"Frequency","f0","MHz","frequency of transmitter",{"$f":"F21","v":470},"MHz"]
[null,"Distance","d",{"$f":"IF(F8=\"feet\", (\"f\"), (\"m\"))","v":"f"},"length of Rx cable",{"$f":"F25","v":0},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"Cable Type",null,"n/a","select type of cable",{"$f":"F26","v":"RG8X"}]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 400MHz per 100 feet\",\"Loss @ 400MHz per 100 meters\")","v":"Loss @ 400MHz per 100 feet"},"L400","dB",{"$f":"IF(F8=\"feet\",\"loss per 100 feet\",\"loss per 100 meters\")","v":"loss per 100 feet"},{"$f":"VLOOKUP(F83,$T$10:$Y$22,IF(F8=\"feet\",3,5),FALSE)","v":6.6},"dB"]
[null,{"$f":"IF(F8=\"feet\",\"Loss @ 900MHz per 100 feet\",\"Loss @ 900MHz per 100 meters\")","v":"Loss @ 900MHz per 100 feet"},"L900","dB",{"$f":"IF(F8=\"feet\",\"loss per 100 feet\",\"loss per 100 meters\")","v":"loss per 100 feet"},{"$f":"VLOOKUP(F83,$T$10:$Y$22,IF(F8=\"feet\",4,6),FALSE)","v":10.7},"dB"]
[null,"Cable Loss @ f0",null,"dB","(((Lf2-Lf1)/(f2-f1))*(f0-f1)+Lf1)*(d/100)",{"$f":"-(((F85-F84)/500)*(F81-400)+F84)*(F82/100)","v":0},"dB"]
[null,"Rx RF Distribution Gain"]
[null,null,"variable","units",null,null,"units"]
[null,"line amp Gain","gAm","dB",null,{"$f":"F27","v":0},"dB"]
[null,"attenuators","gAt","dB",null,{"$f":"F28","v":0},"dB"]
[null,"Rx Results"]
[null,"Total Tx System Loss",null,null,null,{"$f":"F74+F77+F78+F86+F89+F90","v":0},"dBm"]
[]
[null,"Total Loss "]
[null,"Total Path Loss",null,null,null,{"$f":"F59+F67+F92","v":-8.1146822097474072},"dBm"]
[]
[null,"3OIP Calculation"]
[null,"Rx Antenna Gain"]
[null,"Total Path Loss",null,null,null,{"$f":"F95","v":-8.1146822097474072}]
[null,"TOIP",null,null,null,{"$f":"F14","v":21}]
[null,"2T3O IMD",null,null,null,{"$f":"F100+((F99-F100)*3)","v":-66.344046629242229}]
[null,"Noise Floor",null,null,"noise floor",{"$f":"F30","v":-100}]
[null,"dB Above Noise Floor",null,null,"above noise floor",{"$f":"F101-F102","v":33.655953370757771}]

{"sheet":"3OIP Calc","index":2,"n_rows":45,"n_cols":9,"rows_kept":45,"cut":false,"hidden":false,"merged":[[24,1,24,6],[28,1,28,6],[6,8,17,10],[17,1,17,6],[7,1,7,6],[6,1,6,6],[12,1,12,6]]}
[]
[null,null,"Third Order Intercept Point Calculator"]
[null,null,"Three little calculators for 3OIP"]
[]
[null,"http://rfcoordinationnyc.com"]
[]
[null,"Output Intercept Point Calculator",null,null,null,null,null,null,"This calculator can be used for comparison of scenarios in RF setups and educational purposes. In all three calculators the compression point is ignored to simplify the data needed to make the calculation. Therefore calculators are more accurate at lower values."]
[null,"Calculate Primary Product Power"]
[null,null,"variable","units","formula",null,"units"]
[null,"OIP3","i","dBm",null,24,"dBm"]
[null,"3rd odder IMD","IMD3","dBm",null,-100,"dBm"]
[null,"1st product power","P","dBm","P=i+((IMD3-i)/3)",{"$f":"F10+((F11-F10)/3)","v":-17.333333333333336},"dBm"]
[null,"Calculate 3rd Order IMD"]
[null,null,"variable","units","formula",null,"units"]
[null,"OIP3","i","dBm",null,24,"dBm"]
[null,"1st product power","P","dBm",null,-17,"dBm"]
[null,"3rd odder IMD","IMD3","dBm","IMD3=i+((P-i)*3)",{"$f":"F15+((F16-F15)*3)","v":-99},"dBm"]
[null,"Calculate OIP3"]
[null,null,"variable","units","formula",null,"units"]
[null,"1st product power","P","dBm",null,0,"dBm"]
[null,"3rd odder IMD","IMD3","dBm",null,-20,"dBm"]
[null,"OIP3","i","dBm","i=(3P - IMD3)/2",{"$f":"((3*F20)-F21)/2","v":10},"dBm"]
[]
[]
[null,"Reference "]
[null,null,"variable","units","formula",null,"units"]
[null,"OIP3","i","dBm",null,21,"dBm"]
[null,null,null,null,null,30]
[null,"Calculate 3rd Order IMD"]
[null,null,"1st P","units","formula","2T3O","2T3O"]
[null,1,6,"dBm","IMD3=i+((P-i)*3)",{"$f":"F$27+((C31-F$27)*3)","v":-24},{"$f":"F$28+((C31-F$28)*3)","v":-42}]
[null,2,3,"dBm","IMD3=i+((P-i)*3)",{"$f":"F$27+((C32-F$27)*3)","v":-33},{"$f":"F$28+((C32-F$28)*3)","v":-51}]
[null,3,0,"dBm","IMD3=i+((P-i)*3)",-42,-60]
[null,4,-3,"dBm","IMD3=i+((P-i)*3)",-51,-69]
[null,5,-6,"dBm","IMD3=i+((P-i)*3)",-60,-78]
[null,6,-9,"dBm","IMD3=i+((P-i)*3)",-69,-87]
[null,7,-12,"dBm","IMD3=i+((P-i)*3)",-78,-96]
[null,8,-15,"dBm","IMD3=i+((P-i)*3)",-87,-105]
[null,9,-18,"dBm","IMD3=i+((P-i)*3)",-96,-114]
[null,10,-21,"dBm","IMD3=i+((P-i)*3)",-105,-123]
[null,11,-24,"dBm","IMD3=i+((P-i)*3)",{"$f":"F$27+((C41-F$27)*3)","v":-114},{"$f":"F$28+((C41-F$28)*3)","v":-132}]
[null,12,-27,"dBm","IMD3=i+((P-i)*3)",-123,-141]
[null,13,-30,"dBm","IMD3=i+((P-i)*3)",-132,-150]
[null,14,-33,"dBm","IMD3=i+((P-i)*3)",-141,-159]
[null,15,-36,"dBm","IMD3=i+((P-i)*3)",-150,-168]

{"sheet":"Wave Calc","index":3,"n_rows":30,"n_cols":21,"rows_kept":30,"cut":false,"hidden":false,"merged":[[18,1,18,6],[19,2,19,4],[20,1,20,6],[26,1,26,6],[6,1,6,6],[7,2,7,4],[8,1,8,6],[12,1,12,6]]}
[]
[null,null,null,null,"Wavelength Calculators"]
[null,null,null,null,"Electromagnetic and Acoustic Wavelength Calculators"]
[null,"http://rfcoordinationnyc.com"]
[]
[]
[null,"Electromagnetic Wavelength Calculator"]
[null,"feet or meters","select feet of meters in dropdown menu",null,null,"feet"]
[null,"Enter Variables Here",null,null,null,null,null,null,null,null,null,null,null,null,null,"Unit"]
[null,null,"variable","units",null,null,"units",null,null,null,null,null,null,null,null,"feet"]
[null,"Frequency","f","MHz",null,608,"MHz",null,null,null,null,null,null,null,null,"meters"]
[null,"Distance Between Antennas","D",{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,100,{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"Results",null,null,null,null,null,null,null,null,null,null,null,null,null,"Speed of Light","c","f/s",null,983571056.42999995,"f/s"]
[null,"Wavelength","λ",{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},"λ = c/f0",{"$f":"IF(F8=\"Feet\",T13/(F11*1000000),T14/(F11*1000000))","v":1.6177155533388157},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,"Speed of Light","c","m/s",null,299792548,"m/s"]
[null,"1/2 Wavelength","λ",{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,{"$f":"IF(F8=\"Feet\",T13/(F11*1000000),T14/(F11*1000000))/2","v":0.80885777666940784},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"1/4 Wavelength","λ",{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,{"$f":"IF(F8=\"Feet\",T13/(F11*1000000),T14/(F11*1000000))/4","v":0.40442888833470392},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,"Speed of Sound","c","f/s",null,1087,"f/s"]
[null,"1st Fresnel Radius","r",{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},"1st Fresnel Zone Max Radius",{"$f":"SQRT(F12/(4*F11))*IF(F8=\"meters\",17.31,IF(F8=\"feet\",31.35))","v":6.3570519405617576},{"$f":"IF(F8=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,null,null,null,null,null,null,null,"Speed of Sound","c","m/s",null,331.3,"m/s"]
[]
[null,"Acoustic Wavelength Calculator"]
[null,"feet or meters","select feet of meters in dropdown menu",null,null,"feet"]
[null,"Enter Variables Here"]
[null,null,"variable","units",null,null,"units"]
[null,"Frequency","f0","Hz",null,100,"Hz"]
[null,"Temperature","t",{"$f":"IF(F20=\"feet\", (\"ºF\"), (\"ºC\"))","v":"ºF"},null,72,{"$f":"IF(F20=\"feet\", (\"ºF\"), (\"ºC\"))","v":"ºF"}]
[null,"Speed of Sound @ 0º C","c",{"$f":"IF(F20=\"feet\", (\"f/s\"), (\"m/s\"))","v":"f/s"},null,{"$f":"IF(F20=\"feet\", (\"1087\"), (\"331.3\"))","v":"1087"},{"$f":"IF(F20=\"feet\", (\"f/s\"), (\"m/s\"))","v":"f/s"}]
[null,"Speed of Sound @ Temp","c",{"$f":"IF(F20=\"feet\", (\"f/s\"), (\"m/s\"))","v":"f/s"},null,{"$f":"IF(F20=\"feet\", (F25+(1.08*(F24-32))), (F25+(0.6*F24)))","v":1130.2},{"$f":"IF(F20=\"feet\", (\"f/s\"), (\"m/s\"))","v":"f/s"}]
[null,"Results"]
[null,"Wavelength","λ",{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},"λ = c/f0",{"$f":"F26/F23","v":11.302},{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"1/2 Wavelength","λ",{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,{"$f":"(F26/F23)/2","v":5.6509999999999998},{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]
[null,"1/4 Wavelength","λ",{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"},null,{"$f":"(F26/F23)/4","v":2.8254999999999999},{"$f":"IF(F20=\"feet\", (\"feet\"), (\"meters\"))","v":"feet"}]

{"sheet":"VSWR","index":4,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[[6,1,6,6],[11,1,11,6],[2,8,2,10],[3,8,3,9],[4,8,4,10],[5,8,5,9]]}
[]
[null,null,null,"VSWR Calculator"]
[null,null,null,"Calculate reflected power and mismatch loss"]
[]
[null,"http://rfcoordinationnyc.com"]
[]
[null,"VSWR Calculator"]
[null,"VSWR","Reflection Coefficient","Reflected Voltage (%)","Reflected Power (%)","Reflected Power/Return Loss (dB)","Mismatch Loss (dB)"]
[null,"(1+r)/(1-r)","(VSWR - 1)/(VSWR +1)","100 * Rc","100 * Rc^2","10*LOG(Rc^2)","10*LOG10(1-Rc^2)"]
[null,1.2,{"$f":"(B10-1)/(B10+1)","v":9.0909090909090884E-2},{"$f":"100*C10","v":9.0909090909090882},{"$f":"100*C10^2","v":0.82644628099173501},{"$f":"10*LOG(C10^2)","v":-20.827853703164504},{"$f":"-10*LOG10(1-C10^2)","v":3.6041242688252415E-2}]
[]
[null,"VSWR Reference"]
[null,"VSWR","Reflection Coefficient",null,"Reflected Power (%)","Reflected Power (dB)","Mismatch Loss (dB)"]
[null,1,{"$f":"(B14-1)/(B14+1)","v":0},{"$f":"100*C14","v":0},{"$f":"100*C14^2","v":0},"-Infinity",{"$f":"-10*LOG10(1-C14^2)","v":0}]
[null,1.5,0.2,{"$f":"100*C15","v":20},{"$f":"100*C15^2","v":4.0000000000000009},{"$f":"10*LOG(C15^2)","v":-13.979400086720375},{"$f":"-10*LOG10(1-C15^2)","v":0.17728766960431602}]
[null,2,0.33333333333333331,33.333333333333329,11.111111111111111,-9.5424250943932485,0.5115252244738131]
[null,2.5,0.42857142857142855,42.857142857142854,18.367346938775508,-7.3595357058918882,0.88136088700551252]
[null,3,0.5,50,25,-6.0205999132796242,1.2493873660829995]
[null,3.5,0.55555555555555558,55.555555555555557,30.864197530864203,-5.1054501020661212,1.6029699187244937]
[null,4,0.6,60,36,-4.4369749923271273,1.9382002601611281]
[null,5,0.66666666666666663,66.666666666666657,44.444444444444443,-3.5218251811136252,2.5527250510330606]
[null,6,0.7142857142857143,71.428571428571431,51.020408163265309,-2.92256071356476,3.0998483831690766]
[null,7,0.75,75,56.25,-2.498774732165999,3.5902194264166791]
[null,8,0.77777777777777779,77.777777777777786,60.493827160493829,-2.1828893885013607,4.0333504055874378]
[null,9,0.8,80,64.000000000000014,-1.9382002601611275,4.4369749923271291]
[null,10,0.81818181818181823,81.818181818181827,66.942148760330582,-1.7430035143780027,4.8072537898848786]
[null,15,0.875,87.5,76.5625,-1.159838939553735,6.30088714928206]
[null,20,0.90476190476190477,{"$f":"100*C28","v":90.476190476190482},81.859410430839006,-0.86931387562180573,7.4134860247589511]
[null,50,0.96078431372549022,96.078431372549019,92.310649750096118,-0.34748192138845396,11.141103565318918]