{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Main","Quick Notes","Instructions & Training","Calculations","Tables","CDN RSL & WS","Revision Notes","Other"],"not_rendered":{"charts":1,"images":12,"macros":1,"external_links":0,"defined_names":43,"comments":2,"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":"1900"}

{"sheet":"Main","index":0,"n_rows":40,"n_cols":12,"rows_kept":40,"cut":false,"hidden":false,"merged":[[39,1,77,6],[14,1,14,3],[21,1,21,3],[5,1,5,3],[34,1,34,4],[28,1,29,1],[31,1,31,4],[35,1,35,4],[32,1,32,4],[18,1,19,1],[18,3,19,3],[24,1,24,4],[28,3,29,3],[28,4,29,4],[33,1,33,4],[5,10,6,10],[5,11,6,11],[5,9,7,9],[18,2,19,2],[28,2,29,2],[8,9,8,11],[24,9,24,11],[25,11,28,11],[25,10,28,10],[22,10,23,10],[22,11,23,11],[14,11,21,11],[14,10,21,10],[9,11,13,11],[9,10,13,10],[8,1,8,3]]}
[null,null,null,null,null,null,"Version 4"]
[null,null,null,null,null,null,{"$f":"TODAY()","v":"2024-02-02"}]
[null,null,null,null,null,"Customer Name:"]
[null,null,null,null,null,"PO Number:"]
[null,null,null,null,null,"AGI Westeel Sales Order Number:"]
[null,"Location Usage",null,null,null,null,null,null,null,"Bin Series","Standard Peak Load","Higher Rated Peak Load"]
[null,"Location Type","*",{"$f":"INDEX(Tables!$F$8:$F$10,Tables!L19)","v":" "},null,"* - Mandatory Fields"]
[null,null,null,null,null,null,null,null,null,null,"lbs (kN)","lbs (kN)"]
[null,"Bin Requirements",null,null,null,null,null,null,null,"Non-Structural Roof"]
[null,"Bin Type","*",{"$f":"INDEX(Tables!$F$13:$F$20,Tables!L20)","v":" "},null,null,null,null,null,15,"4000 (17.8)","8000 (35.6)"]
[null,"Diameter [ft.]","*",{"$f":"INDEX(Tables!$A$2:$A$18,Tables!L21)","v":" "},null,null,null,null,null,16]
[null,"Tier","*",{"$f":"INDEX(Tables!$H$2:$H$16,Tables!L22)","v":" "},null,null,null,null,null,18]
[null,"Peak Load [lbs.]","*",{"$f":"INDEX(Tables!$J$2:$J$5,Tables!L23)","v":" "},null,null,null,null,null,21]
[null,null,null,null,null,null,null,null,null,24]
[null,"Bin Location",null,null,null,null,null,null,null,27,"5000 (22.2)","10000 (44.5)"]
[null,"Location Name","*",null,null,null,null,null,null,30]
[null,"Location Latitude [degrees]","*",null,null,null,null,null,null,33]
[null,"Location Longitude [degrees]","*",null,null,null,null,null,null,36]
[null,"Location Environmental Data is based on",null,{"$f":"IFERROR(IF(OR(LAT=\"\",LONG=\"\"),\"\",IF(RSL='CDN RSL & WS'!F3,'CDN RSL & WS'!B3,\"\")),\"\")","v":""},null,null,null,null,null,39]
[null,null,null,null,null,null,null,null,null,42]
[null,null,null,null,null,null,null,null,null,45]
[null,"Cable Monitoring System",null,null,null,null,null,null,null,48]
[null,"Cable Type","*",{"$f":"INDEX(Tables!$F$2:$F$5,Tables!L24)","v":" "},null,null,null,null,null,51,"8000 (35.6)","12000 (53.4)"]
[null,null,null,null,null,null,null,null,null,54]
[null,"Results",null,null,null,null,null,null,null,"Structural Roof"]
[null,"Roof Requirements",null,"Description","Part Number",null,null,null,null,48,"20000 (89.0)","60000 (266.9)"]
[null,"Standard Roof",null,{"$f":"IF(D23=\" \",\"-\",IFERROR(INDEX(Tables!$V$1:$V$17,MATCH(nDia,Tables!$U$1:$U$17,0)),\"-\"))","v":"-"},{"$f":"IF(D23=\" \",\"-\",IFERROR(INDEX(Tables!$W$1:$W$17,MATCH(nDia,Tables!$U$1:$U$17,0)),\"-\"))","v":"-"},null,null,null,null,51]
[null,"Roof Upgrade Required",null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"-\",INDEX(Tables!$V$18:$V$42,MATCH($E$28,Tables!$W$18:$W$42,0))),\"-\")","v":"-"},{"$f":"IF(Tables!N24=\" \",\"-\",IF(OR(BT=\"Westeel EasyDry SGL Fan Inlet\",BT=\"Westeel EasyDry DBL Fan Inlet\"),IFERROR(INDEX(Tables!Y1:AC5,MATCH(nDia,Tables!Y1:Y16,0),MATCH(HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE),Tables!L1:P1,0)),\"-\"),IFERROR(INDEX(Tables!L1:P16,MATCH(nDia,Tables!L1:L16,0),MATCH(HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE),Tables!L1:P1,0)),\"-\")))","v":"-"},null,null,null,null,54]
[null,"Required Monitoring Cable Hanger System",null,{"$f":"IF(RCBLTYPE=\"None\",\"-\",IF(OR(E27=212601,E28=212610,E28=212599,E28=212598),Calculations!E18,\"-\"))","v":"-"},{"$f":"IFERROR(IF(OR(E27=212601,E28=212610,E28=212599,E28=212598),Calculations!D18,\"-\"),\"-\")","v":"-"},null,null,null,null,60]
[]
[null,"Remaining Peak Load",null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"-\",ROUNDDOWN(RPL,0)&\" lbs (\"&ROUNDDOWN(RPL/224.80894387096,1)&\" kN)\"),\"\")","v":"-"}]
[null,{"$f":"IF(COUNTIF($D$28,\"*Structural Roof\")=1,\"Structural roof replaces standard roof. You will need to purchase \"&E28&\" instead of the standard roof.\",\"\")","v":""}]
[null,{"$f":"IF(LT=\"Commercial\", \"Please contact AGI Westeel Customer Service about seismic considerations.\", \"\")","v":""},null,{"$f":"IF(B33=\"Commercial\", \"  Please contact Westeel Engineering about seismic considerations\", \"\")","v":""},{"$f":"IF(D33=\"Commercial\", \"  Please contact Westeel Engineering about seismic considerations\", \"\")","v":""}]
[null,{"$f":"IF(D23=\" \",\"\",IFERROR(IF(WIND>0.57,\"Please contact AGI Westeel Customer Service for potential wind upgrades.\",\"\"),\"\"))","v":""}]
[null,{"$f":"IFERROR(IF(Tables!N24=\" \",\"\",IF(AND(RCBLTYPE=\"None\", nDia<=21, MIN(Calculations!C28:F29)<>9999), \"\",IF(MIN(Calculations!C28:F29)=9999,\"ROOF IS OVERLOADED. Neither the standard roof nor any standard roof upgrades will accommodate the loads. Please contact AGI Westeel Customer Service for potential further roof upgrades.\",\"\"))),\"\")","v":""}]
[null,{"$f":"IF(D23=\" \",\"\",IF(BT=\"Stiffened AGI Westeel Hopper\",\"Currently AGI Westeel 15'-27' welded hopper bottoms are manufactured for unstiffened bins only. Please ensure the third-party hopper you are using will work with AGI Westeel Products.\",\"\"))","v":""}]
[]
[]
[]
[null,"Important Notes\n- For Flat Bottom Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables end 2ft. up from the floor.\n- For Hopper Bottom Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables attach to the hopper cone.\n- For SSK Bins: This tool assumes the AGI SureTrack Monitoring System for all bin sizes, and the cables attach to the hopper cone.\n- If your Monitoring Cable System does not fall under these parameters please contact AGI Westeel Customer Service for a custom analysis.\n- Monitoring Cable Systems are not available for AGI Westeel EasyDry Bins.\n\n- If your bin is using an AGI SureTrack Monitoring System Package, the package will come with a standard AGI SureTrack hanger system.\n- If your Monitoring Cable Hanger System is different from the one this tool has recommended, please contact AGI Westeel Customer Service for further information.\n\n- For SSK Hoppers the angle of the hopper sheets are 45° for 15'-21' bins and 40° for 24'-27' bins.\n- For Welded Hoppers the angle of the hopper sheets are 35° for 15'-27' bins."]

{"sheet":"Quick Notes","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions & Training","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Calculations","index":3,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":true,"merged":[]}
["Radial Cable Loads"]
["Central Cable Radial Distance [ft]","rc =",{"$f":"INDEX(STCCL,MATCH(nDia,DIAMETER,0))","v":0},"(SureTrack Central Cable locations)"]
["Maximum Calculated Cable Length for Flat Bottom Bins [ft]","Lcf =",{"$f":"IF(RCBLTYPE=\"None\",0,IF(OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),((1.25+nT*44)/12-2)+(nDia/2-rcable)*TAN(RADIANS(30)),0))","v":0},"(Length of cable from roof sheet to bin floor)"]
["Maximum Calculated Cable Length for Hopper Bottom and SSK Bins [ft]","Lch =",{"$f":"IF(OR(RCBLTYPE=\"None\",BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),0,((1.25+nT*44)/12)+(nDia/2-rcable)*TAN(RADIANS(30))+(nDia/2-rcable)*TAN(RADIANS(45)))","v":{"$error":"#VALUE!"}},"(Length of cable from roof sheet to hopper cone, assumes angle of hopper is 45°)"]
["Cable Length [ft]","L =",{"$f":"IF(RCBLTYPE=\" \",NA(),IF(RCBLTYPE=\"None\",0,IF(OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),Lcf,IF(OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),Lch))))","v":{"$error":"#N/A"}}]
["Product Density [lb/ft3]","p =",{"$f":"CONVERT(772*1000,\"g\",\"lbm\")/(CONVERT(1,\"m\",\"ft\"))^3","v":48.194385564783637},"(Assume product used is wheat = 772 kg/m3)"]
["Coefficient of Friction","u =",0.37]
["Lateral to Vertical Pressure Ratio","k =",0.5,null,"Coefficients of OPI radial cable loads"]
["Sensor Spacing [ft]","ss =",6,"(OPI)","OPI","C1","C2"]
["Sensor Weight [lbs/sensor]","Ps =",45,"(OPI)","MDR",2.38402777777778E-2,0.75819999999999999]
["Central Temperature Cable Force [lbs]","PRT =",{"$f":"COEFFC1*p*(nDia/2)^2/(mu^2*k)*(-1+EXP(-mu*k*L/(nDia/2)))+(COEFFC1*p*nDia/(mu*2)+COEFFC2)*L","v":{"$error":"#N/A"}},null,"CDR",3.3191666666666668E-2,1.4527000000000001]
["Central Moisture Cable Force [lbs]","PRM =",{"$f":"MOISTC1*p*(nDia/2)^2/(mu^2*k)*(-1+EXP(-mu*k*L/(nDia/2)))+(MOISTC1*p*nDia/(mu*2)+MOISTC2)*L + Ps/ss*L","v":{"$error":"#VALUE!"}},null,"C, DUE TO L",{"$f":"IF(L>80,F11,MDRC1)","v":{"$error":"#N/A"}},{"$f":"IF(L>80,G11,MDRC2)","v":{"$error":"#N/A"}}]
["Chosen Central Cable Force [lbs]",{"$f":"IF(RCBLTYPE=\"None\",\"None\",IF(RCBLTYPE=\"Temperature\",B11,B12))","v":"PRM ="},{"$f":"IF(RCBLTYPE=\"AGI SureTrack Temp\",PRT,IF(RCBLTYPE=\"AGI SureTrack Moist/Moist & Temp\",PRM,0))","v":0},null,"MOIST.",1.3513194444444444E-2,5.6208000000000001E-2]
[]
["Determining Cable Support System",null,null,"Indicator","PN","Logic"]
["Rib Caps",null,{"$f":"IF(AND(nDia<60,nDia>11),1,0)","v":0},"1 if used","Varies by Dia","12' - 54' non-structural roofs, 16 tiers or less for flat bottom bins, 14 tiers or less for hopper bins"]
["Internal Bracket Hanging under Rafters, 48'-108' Diameter Roof",null,{"$f":"IF(OR(nDia=\" \",nT=\" \"),NA(),IF(AND(BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>=48),2,0))","v":{"$error":"#N/A"}},"2 if used",212777,"structural roof, stiffened bin"]
["Radial Cable Support Chosen:",null,{"$f":"IF(OR(RCBLTYPE=\"None\",RCBLTYPE=\" \"),\"\",IF(OR(Main!E27=212601,Main!E28=212610,Main!E28=212599,Main!E28=212598),2,MAX(C16)))","v":""},{"$f":"INDEX($E$16:$E$17,MATCH($C$18,CBLSPT,0))","v":{"$error":"#N/A"}},{"$f":"IFERROR(INDEX($A$16:$A$17,MATCH($C$18,CBLSPT,0)),\"\")","v":""}]
[]
["Determining Remaining Peak Load","RPL =",{"$f":"ROUNDDOWN(IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia=60),INDEX(Peak_Loads[HRSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",nDia=60),INDEX(Peak_Loads[STDSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia>47,nDia<55,OR(Tables!S2=212598,Tables!S2=212599,Tables!S2=212610)),INDEX(Peak_Loads[HRSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",nDia>47,nDia<55,OR(Tables!S2=212598,Tables!S2=212599,Tables!S2=212610)),INDEX(Peak_Loads[STDSTRUCTURAL],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),OR(nDia<22,AND(nDia>35,nDia<55))),INDEX(Peak_Loads[HR],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(PEAK_TYPE=\"Standard\",OR(nDia<22,AND(nDia>35,nDia<55))),INDEX(Peak_Loads[STD],MATCH(nDia,Peak_Loads[DIAMETER]),0)-CABLE_LOAD,IF(AND(OR(PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),nDia>22,nDia<35),INDEX(Peak_Loads[HR],MATCH(nDia,Peak_Loads[DIAMETER]),0),INDEX(Peak_Loads[STD],MATCH(nDia,Peak_Loads[DIAMETER]),0)))))))),0)","v":{"$error":"#N/A"}}]
[]
["Max Roof Cap. w/ RSL, & Std Peak Load Applied","CBLSPT","STD","UP1","UP2","UP3","Formulas"]
["Rib Caps [psf]",{"$f":"$C$16","v":0},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[STD],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[STD],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP1],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP1],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP2],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP2],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\",INDEX(Leftover_RSL_at_SPL_RibCaps[UP3],MATCH(nDia,Leftover_RSL_at_SPL_RibCaps[DIAMETER]),0),INDEX(Leftover_RSL_at_UPL_RibCaps[UP3],MATCH(nDia,Leftover_RSL_at_UPL_RibCaps[DIAMETER]),0))","v":{"$error":"#N/A"}},"= Rs - RSL"]
["Hanging Bracket [psf]",{"$f":"$C$17","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[STD],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[STD],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP1],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP1],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP2],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP2],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},{"$f":"IF(PEAK_TYPE=\"Standard\", INDEX(Leftover_RSL_at_SPL_Hanging[UP3],MATCH(nDia,Leftover_RSL_at_SPL_Hanging[DIAMETER]),0), INDEX(Leftover_RSL_at_UPL_Hanging[UP3],MATCH(nDia,Leftover_RSL_at_UPL_Hanging[DIAMETER]),0))","v":{"$error":"#N/A"}},"= Rs - RSL"]
[]
[null,null,10,20,30,40]
["Determining Roof Upgrade","CBLSPT","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3"]
["Rib Caps",{"$f":"$C$16","v":0},{"$f":"IF(AND($B28>0,C23>0,C23<>\"N/A\"),C$26,9999)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
["Hanging Bracket",{"$f":"$C$17","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]

{"sheet":"Tables","index":4,"n_rows":142,"n_cols":29,"rows_kept":142,"cut":false,"hidden":true,"merged":[[25,6,25,10],[44,6,44,10],[25,12,25,16],[105,0,122,0],[124,0,141,0],[25,0,25,4],[44,0,44,4],[103,0,103,5],[65,0,82,0],[63,0,63,5],[84,0,101,0]]}
["DIAMETER","AGI SURETRACK CABLE QTY CENTRE","AGI SURETRACK CABLE QTY RAD 1","AGI SURETRACK CENTER CABLE RADIAL DISTANCE",null,"Cable Type",null,"TIER",null,"Peak Load",null,"Roof","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3",null,"Roof Upgrade Required",{"$f":"HLOOKUP(MIN(Calculations!$C$28:$F$29),Calculations!$C$26:$F$27,2,FALSE)","v":{"$error":"#N/A"}},null,"Size","Description","Part Number",null,"EasyDry\nRoof","Standard Roof","Upgrade 1","Upgrade 2","Upgrade 3"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),15,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(7.1*COS(RADIANS(30))))/12","v":1.887398363905793},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(LAT)=FALSE,ISBLANK(LONG)=FALSE)),\"None\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia=16),\"\",IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia>0,nDia<30),3,\"\"))","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Standard\",\"\")","v":""},null,15,"-",null,null,null,null,"Roof Upgrade Part Number",{"$f":"INDEX(Tables!L1:P16,MATCH(nDia,Tables!L1:L16,0),MATCH($S$1,Tables!L1:P1,0))","v":{"$error":"#N/A"}},null,15,{"$f":"U2&\"' \"&\"Non-Structural Roof\"","v":"15' Non-Structural Roof"},212015,null,24,"-","212024U1-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\"),16,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(7.1*COS(RADIANS(30))))/12","v":1.887398363905793},null,{"$f":"IF(OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),\"\",IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(LAT)=FALSE,ISBLANK(LONG)=FALSE)),\"AGI SureTrack Temp\",\"\"))","v":""},null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",nDia=16),AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia=39)),\"\",IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>0,nDia<54),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),4,\"\"))","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Higher Rated\",\"\")","v":""},null,16,"-",null,null,null,null,"Cable Support Required",{"$f":"Calculations!$E$18","v":""},null,16,"16' Non-Structural Roof",212016,null,27,"-","212027U1"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),18,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(11.55*COS(RADIANS(30))))/12","v":2.2085494511425221},null,{"$f":"IF(OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),\"\",IF(AND(LT=\"Farm (Price List)\",OR(PEAK_TYPE=\"Standard\",PEAK_TYPE=\"Higher Rated\",PEAK_TYPE=\"Unknown\"),AND(ISBLANK(Main!D16)=FALSE,ISBLANK(LAT)=FALSE,ISBLANK(LONG)=FALSE)),\"AGI SureTrack Moist/Moist & Temp\",\"\"))","v":""},null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),5,\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",ISNUMBER(N22)),\"Unknown\",\"\")","v":""},null,18,"-",null,null,null,null,"Support Part Number",{"$f":"Calculations!$D$18","v":{"$error":"#N/A"}},null,18,"18' Non-Structural Roof",212018,null,30,"-","212030U1","212030U2-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),21,\"\")","v":""},1,"N/A",{"$f":"((33/2)+(15.75*COS(RADIANS(30))))/12","v":2.5116583424670758},null," ",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33)),6,\"\")","v":""},null," ",null,21,"-","212021U1",null,null,null,null,null,null,21,"21' Non-Structural Roof",212021,null,36,"-","212036U1","212036U2-ED"]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),24,\"\")","v":""},null,3,{"$f":"((33/2)+(19.94*COS(RADIANS(30))))/12","v":2.8140455459551426},null,null,null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",OR(nDia=15,nDia=16,nDia=18)),\"\",IF(OR(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\"),nDia>0,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<30)),7,\"\"))","v":""},null," ",null,24,"-","212024U1",null,null,null,null,null,null,24,"24' Non-Structural Roof",212024]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Unstiffened AGI Westeel Hopper\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\")),27,\"\")","v":""},null,3,{"$f":"((33/2)+(24.14*COS(RADIANS(30))))/12","v":3.1171544372796958},null,"Location Type",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Hopper\",OR(nDia=15,nDia=16,nDia=18,nDia=24))),\"\",IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>18,nDia<60),AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Hopper\",BT=\"Stiffened AGI Westeel SSK\"),nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),8,\"\"))","v":""},null," ",null,27,"-","212027U1",null,null,null,null,null,null,27,"27' Non-Structural Roof",212027]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\")),30,\"\")","v":""},null,3,{"$f":"((52/2)+(17.36*COS(RADIANS(30))))/12","v":3.4195167508081545},null,"Farm (Price List)",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Unstiffened AGI Westeel Flat Bottom\",nDia>24,nDia<60),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel SSK\",nDia>0,nDia<30),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),9,\"\")","v":""},null," ",null,30,"-","212030U1","212030U2",null,null,null,null,null,30,"30' Non-Structural Roof",212030]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Hopper\")),33,\"\")","v":""},null,3,{"$f":"((52/2)+(21.55*COS(RADIANS(30))))/12","v":3.7219039542962213},null,"Commercial",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel SSK\",nDia>0,nDia<27),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia>0,nDia<=33),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>0,nDia<39)),10,\"\")","v":""},null," ",null,33,"-","212033U1","212033U2",null,null,null,null,null,33,"33' Non-Structural Roof",212033]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\",BT=\"Stiffened AGI Westeel Flat Bottom\")),36,\"\")","v":""},1,3,{"$f":"((52/2)+(25.75*COS(RADIANS(30))))/12","v":4.0250128456207745},null," ",null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>24,nDia<39)),11,\"\")","v":""},null," ",null,36,"-","212036U1","212036U2",null,null,null,null,null,36,"36' Non-Structural Roof",212036]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),39,\"\")","v":""},1,3,{"$f":"((52/2)+(30*COS(RADIANS(30))))/12","v":4.3317301761277633},null,null,null,{"$f":"IF(OR(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Hopper\",nDia=27),AND(LT=\"Farm (Price List)\",OR(BT=\"AGI Westeel EasyDry SGL Fan Inlet\",BT=\"AGI Westeel EasyDry DBL Fan Inlet\"),nDia>24,nDia<39)),12,\"\")","v":""},null," ",null,39,"-","212039U1","212039U2",null,null,null,null,null,39,"39' Non-Structural Roof",212039]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),42,\"\")","v":""},1,4,{"$f":"((52/2)+(34.1*COS(RADIANS(30))))/12","v":4.6276221890874467},null,"Bin Type",null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),13,\"\")","v":""},null," ",null,42,"-","212042U1","212042U2",null,null,null,null,null,42,"42' Non-Structural Roof",212042]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),45,\"\")","v":""},1,4,{"$f":"((52/2)+(38.32*COS(RADIANS(30))))/12","v":4.9321744560849741},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Unstiffened AGI Westeel Flat Bottom\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>0,nDia<66),14,\"\")","v":""},null," ",null,45,"-","212045U1","212045U2",null,null,null,null,null,45,"45' Non-Structural Roof",212045]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),48,\"\")","v":""},1,5,{"$f":"((52/2)+(42.51*COS(RADIANS(30))))/12","v":5.2345616595730409},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel Flat Bottom\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>21,nDia<66),15,\"\")","v":""},null," ",null,48,"-","212048U1","212048U2",212598,null,null,null,null,48,"48' Non-Structural Roof",212048]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),51,\"\")","v":""},1,6,{"$f":"((60/2)+(42.09*COS(RADIANS(30))))/12","v":5.5375841037739191},null,{"$f":"IF(LT=\"Farm (Price List)\",\"AGI Westeel EasyDry SGL Fan Inlet\",\"\")","v":""},null,{"$f":"IF(AND(LT=\"Farm (Price List)\",BT=\"Stiffened AGI Westeel Flat Bottom\",nDia>21,nDia<66),16,\"\")","v":""},null,null,null,51,"-","212051U1",212599,null,null,null,null,null,51,"51' Non-Structural Roof",212051]
[{"$f":"IF(AND(LT=\"Farm (Price List)\",OR(BT=\"Unstiffened AGI Westeel Flat Bottom\",BT=\"Stiffened AGI Westeel Flat Bottom\")),54,\"\")","v":""},1,6,{"$f":"((60/2)+(46.28*COS(RADIANS(30))))/12","v":5.8399713072619859},null,{"$f":"IF(LT=\"Farm (Price List)\",\"AGI Westeel EasyDry DBL Fan Inlet\",\"\")","v":""},null," ",null,null,null,54,"-","212054U1",212610,null,null,null,null,null,54,"54' Non-Structural Roof",212054]
[{"$f":"IF(AND(LT=\"Farm (Price List)\", BT=\"Stiffened AGI Westeel Flat Bottom\"),60,\"\")","v":""},1,7,{"$f":"((52/2)+(17.36*COS(RADIANS(30))))/12","v":3.4195167508081545},null,{"$f":"IF(LT=\"Farm (Price List)\",\"Unstiffened AGI Westeel Hopper\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,60,{"$f":"U17&\"' \"&\"Structural Roof\"","v":"60' Structural Roof"},212601]
[" ",null,null,null,null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel Hopper\",\"\")","v":""},null,null,null,null,null,"Developer Drop Down Lists",null,null,null,null,null,null,null,null,null,"21' Upgrade 1","212021U1"]
[null,null,null,null,null,{"$f":"IF(LT=\"Farm (Price List)\",\"Stiffened AGI Westeel SSK\",\"\")","v":""},null,null,null,null,null,3,null,{"$f":"INDEX(Tables!$F$8:$F$10,Tables!L19)","v":" "},null,null,null,null,null,null,null,"24' Upgrade 1","212024U1"]
[null,null,null,null,null," ",null,null,null,null,null,8,null,{"$f":"INDEX(Tables!$F$13:$F$20,Tables!L20)","v":" "},null,null,null,null,null,null,null,"24' EasyDry Uprgrade 1","212024U1-ED"]
[null,null,null,null,null," ",null,null,null,null,null,17,null,{"$f":"INDEX(Tables!$A$2:$A$18,Tables!L21)","v":" "},null,null,null,null,null,null,null,"27' Upgrade 1","212027U1"]
[null,null,null,null,null,null,null,null,null,null,null,15,null,{"$f":"INDEX(Tables!$H$2:$H$16,Tables!L22)","v":" "},null,null,null,null,null,null,null,"30' Upgrade 1","212030U1"]
[null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"INDEX(Tables!$J$2:$J$5,Tables!L23)","v":" "},null,null,null,null,null,null,null,"33' Upgrade 1","212033U1"]
[null,null,null,null,null,null,null,null,null,null,null,4,null,{"$f":"INDEX(Tables!$F$2:$F$5,Tables!L24)","v":" "},null,null,null,null,null,null,null,"36' Upgrade 1","212036U1"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"39' Upgrade 1","212039U1"]
["(Rs, psf) Max Roof Snow Load @ Standard Peak Load",null,null,null,null,null,"(U, psf) Ultimate FEA Roof Snow Load Capacities\n@ Standard Peak Load",null,null,null,null,null,"Peak Loads",null,null,null,null,null,null,null,null,"42' Upgrade 1","212042U1"]
["DIAMETER","STD","UP1","UP2","UP3",null,"DIAMETER","STD","UP1","UP2","UP3",null,"DIAMETER","STD","HR","STDSTRUCTURAL","HRSTRUCTURAL",null,null,null,null,"45' Upgrade 1","212045U1"]
[15,45,"N/A","N/A","N/A",null,15,75.48,"N/A","N/A","N/A",null,15,4000,8000,"N/A","N/A",null,null,null,null,"48' Upgrade 1","212048U1"]
[16,45,"N/A","N/A","N/A",null,16,75.48,"N/A","N/A","N/A",null,16,4000,8000,"N/A","N/A",null,null,null,null,"51' Upgrade 1","212051U1"]
[18,45,"N/A","N/A","N/A",null,18,75.48,"N/A","N/A","N/A",null,18,4000,8000,"N/A","N/A",null,null,null,null,"54' Upgrade 1","212054U1"]
[21,30,49,"N/A","N/A",null,21,51.55,81.67,"N/A","N/A",null,21,4000,8000,"N/A","N/A",null,null,null,null,"30' Upgrade 2","212030U2"]
[24,21,40,"N/A","N/A",null,24,36.58,67.84,"N/A","N/A",null,24,4000,8000,"N/A","N/A",null,null,null,null,"30' EasyDry Upgrade 2","212030U2-ED"]
[27,24,39,"N/A","N/A",null,27,40.56,65.17,"N/A","N/A",null,27,5000,10000,"N/A","N/A",null,null,null,null,"33' Upgrade 2","212033U2"]
[30,20,32,40,"N/A",null,30,34.58,53.53,67.17,"N/A",null,30,5000,10000,"N/A","N/A",null,null,null,null,"36' Upgrade 2","212036U2"]
[33,23,33,44,"N/A",null,33,39.909999999999997,56.53,73.819999999999993,"N/A",null,33,5000,10000,"N/A","N/A",null,null,null,null,"36' EasyDry Upgrade 2","212036U2-ED"]
[36,24,30,38,"N/A",null,36,41.23,51.55,64.849999999999994,"N/A",null,36,5000,10000,"N/A","N/A",null,null,null,null,"39' Upgrade 2","212039U2"]
[39,22,27,36,"N/A",null,39,37.24,45.22,61.52,"N/A",null,39,5000,10000,"N/A","N/A",null,null,null,null,"42' Upgrade 2","212042U2"]
[42,19,24,34,"N/A",null,42,33.26,41.57,58.2,"N/A",null,42,5000,10000,"N/A","N/A",null,null,null,null,"45' Upgrade 2","212045U2"]
[45,16,23,32,"N/A",null,45,28.27,39.909999999999997,53.87,"N/A",null,45,5000,10000,"N/A","N/A",null,null,null,null,"48' Upgrade 2","212048U2"]
[48,21,26,33,39,null,48,35.9,44.23,55.53,73.16,null,48,5000,10000,20000,60000,null,null,null,null,"48' Structural Roof",212598]
[51,20,28,39,"N/A",null,51,34.25,48.22,73.16,"N/A",null,51,8000,12000,20000,60000,null,null,null,null,"51' Structural Roof",212599]
[54,17,27,39,"N/A",null,54,29.93,46.26,73.16,"N/A",null,54,8000,12000,20000,60000,null,null,null,null,"54' Structural Roof",212610]
[60,39,"N/A","N/A","N/A",null,60,73.16,"N/A","N/A","N/A",null,60,"N/A","N/A",20000,60000]
[]
["(Rs, psf) Max Roof Snow Load @ Upgraded Peak Load",null,null,null,null,null,"(U, psf) Ultimate FEA Roof Snow Load Capacities\n@ Upgraded Peak Load"]
["DIAMETER","STD","UP1","UP2","UP3",null,"DIAMETER","STD","UP1","UP2","UP3",null,null,null,"Rs*Rlf*Sif <= U*Rfs","- this can be rearranged to give the maximum roof snow load capacity of the roof: Rs = U*Rfs/(Rlf*Sif)"]
[15,29,"N/A","N/A","N/A",null,15,58.91,"N/A","N/A","N/A",null,null,null,null,"Rs = "," the maximum roof snow load capacity of the roof"]
[16,29,"N/A","N/A","N/A",null,16,58.91,"N/A","N/A","N/A",null,null,null,null,"U = "," the ultimate roof snow load capacity as found by our FEA models"]
[18,29,"N/A","N/A","N/A",null,18,58.91,"N/A","N/A","N/A",null,null,null,0.9,"= Rfs = "," the roof steel resistance factor.  We use 0.9 following CSA S136"]
[21,24,40,"N/A","N/A",null,21,49.55,81.8,"N/A","N/A",null,null,null,1.5,"= Rlf = "," the roof snow load factor.  We use 1.5 as per NBCC 2015 load combination 3"]
[24,17,27,"N/A","N/A",null,24,34.92,55.54,"N/A","N/A",null,null,null,0.8,"= Sif = "," the snow load importance factor (Occupancy).  We use 0.8 as per NBCC 4.1.6.2"]
[27,19,28,"N/A","N/A",null,27,38.24,56.53,"N/A","N/A"]
[30,15,24,33,"N/A",null,30,31.26,48.17,67.84,"N/A"]
[33,18,24,36,"N/A",null,33,37.909999999999997,48.22,72.78,"N/A"]
[36,18,23,31,"N/A",null,36,36.9,46.38,63.19,"N/A"]
[39,16,21,30,"N/A",null,39,33.51,42.9,60.52,"N/A"]
[42,14,19,27,"N/A",null,42,29.93,39.909999999999997,55.29,"N/A"]
[45,13,18,25,"N/A",null,45,26.27,36.58,50.54,"N/A"]
[48,16,21,26,38,null,48,33.26,42.9,52.54,71.5]
[51,14,21,38,"N/A",null,51,29.93,43.32,71.5,"N/A"]
[54,13,20,38,"N/A",null,54,26.27,40.9,71.5,"N/A"]
[60,38,"N/A","N/A","N/A",null,60,71.5,"N/A","N/A","N/A"]
[]
["Left Over Roof Snow Load @ Standard Peak Load With:\nRS = U*Rfs/(Rlf*Sif)-RSL"]
[]
["Rib Caps",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,{"$f":"B28-RSL","v":{"$error":"#N/A"}},"N/A","N/A","N/A"]
[null,16,{"$error":"#N/A"},"N/A","N/A",{"$f":"M70","v":0}]
[null,18,{"$error":"#N/A"},"N/A","N/A","N/A"]
[null,21,{"$error":"#N/A"},{"$f":"C31-RSL","v":{"$error":"#N/A"}},"N/A","N/A"]
[null,24,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,27,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,30,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"D34-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,33,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,36,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,39,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,42,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,45,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,48,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,51,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,54,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,60,"N/A","N/A","N/A","N/A"]
[]
["Hanging Bracket Support System",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,"N/A","N/A","N/A","N/A"]
[null,16,"N/A","N/A","N/A","N/A"]
[null,18,"N/A","N/A","N/A","N/A"]
[null,21,"N/A","N/A","N/A","N/A"]
[null,24,"N/A","N/A","N/A","N/A"]
[null,27,"N/A","N/A","N/A","N/A"]
[null,30,"N/A","N/A","N/A","N/A"]
[null,33,"N/A","N/A","N/A","N/A"]
[null,36,"N/A","N/A","N/A","N/A"]
[null,39,"N/A","N/A","N/A","N/A"]
[null,42,"N/A","N/A","N/A","N/A"]
[null,45,"N/A","N/A","N/A","N/A"]
[null,48,"N/A","N/A","N/A",{"$f":"E40-RSL","v":{"$error":"#N/A"}}]
[null,51,"N/A","N/A",{"$f":"D41-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,54,"N/A","N/A",{"$f":"D42-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,60,{"$f":"B43-RSL","v":{"$error":"#N/A"}},"N/A","N/A","N/A"]
[]
["Left Over Roof Snow Load @ Upgraded Peak Load With:\nRS = U*Rfs/(Rlf*Sif)-RSL"]
[]
["Ribs Caps",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,{"$f":"B47-RSL","v":{"$error":"#N/A"}},"N/A","N/A","N/A"]
[null,16,{"$error":"#N/A"},"N/A","N/A","N/A"]
[null,18,{"$error":"#N/A"},"N/A","N/A","N/A"]
[null,21,{"$error":"#N/A"},{"$f":"C50-RSL","v":{"$error":"#N/A"}},"N/A","N/A"]
[null,24,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,27,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,30,{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"D53-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,33,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,36,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,39,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,42,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,45,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,48,{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},"N/A"]
[null,51,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,54,{"$error":"#N/A"},{"$error":"#N/A"},"N/A","N/A"]
[null,60,"N/A","N/A","N/A","N/A"]
[]
["Hanging Bracket Support System",null,"Cable Load:",{"$f":"Calculations!$B$13","v":"PRM ="},{"$f":"Calculations!$C$13","v":0}]
[null,"DIAMETER","STD","UP1","UP2","UP3"]
[null,15,"N/A","N/A","N/A","N/A"]
[null,16,"N/A","N/A","N/A","N/A"]
[null,18,"N/A","N/A","N/A","N/A"]
[null,21,"N/A","N/A","N/A","N/A"]
[null,24,"N/A","N/A","N/A","N/A"]
[null,27,"N/A","N/A","N/A","N/A"]
[null,30,"N/A","N/A","N/A","N/A"]
[null,33,"N/A","N/A","N/A","N/A"]
[null,36,"N/A","N/A","N/A","N/A"]
[null,39,"N/A","N/A","N/A","N/A"]
[null,42,"N/A","N/A","N/A","N/A"]
[null,45,"N/A","N/A","N/A","N/A"]
[null,48,"N/A","N/A","N/A",{"$f":"E59-RSL","v":{"$error":"#N/A"}}]
[null,51,"N/A","N/A",{"$f":"D60-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,54,"N/A","N/A",{"$f":"D61-RSL","v":{"$error":"#N/A"}},"N/A"]
[null,60,{"$f":"B62-RSL","v":{"$error":"#N/A"}},"N/A","N/A","N/A"]

{"sheet":"CDN RSL & WS","index":5,"n_rows":684,"n_cols":19,"rows_kept":684,"cut":false,"hidden":true,"merged":[]}
[null,"Location","Latitude","Longitude","Distance Between (km)","Roof (psf)","Wind (kpa)"]
["Location In Question",{"$f":"Main!D16","v":0},{"$f":"ABS(LAT)","v":0},{"$f":"ABS(LONG)","v":0},"N/A",{"$f":"IF(OR(C2=0,D2=0),NA(),F3)","v":{"$error":"#N/A"}},{"$f":"IF(OR(C2=0,D2=0),NA(),G3)","v":{"$error":"#N/A"}}]
["1st Nearest NBCC Location",{"$f":"VLOOKUP(\"yes\",$A$24:$H$684,2,FALSE)","v":"Cape Race"},{"$f":"VLOOKUP(\"yes\",$A$24:$H$684,3,FALSE)","v":46.666670000000003},{"$f":"VLOOKUP(\"yes\",$A$24:$H$684,4,FALSE)","v":53.066670000000002},{"$f":"VLOOKUP(\"yes\",$A$24:$H$684,5,FALSE)","v":7299.646606280372},{"$f":"VLOOKUP(\"yes\",$A$24:$H$684,8,FALSE)","v":32.191409439999994},{"$f":"VLOOKUP(\"yes\",$A$24:$I$684,9,FALSE)","v":1.05}]
["2nd Nearest NBCC Location",{"$f":"VLOOKUP(\"yes\",$L$24:$Q$684,2,FALSE)","v":"St. John's"},{"$f":"VLOOKUP(\"yes\",$L$24:$Q$684,3,FALSE)","v":47.560540000000003},{"$f":"VLOOKUP(\"yes\",$L$24:$Q$684,4,FALSE)","v":52.712829999999997},{"$f":"VLOOKUP(\"yes\",$L$24:$Q$684,5,FALSE)","v":7324.4171770141811},{"$f":"VLOOKUP(\"yes\",$L$24:$Q$684,6,FALSE)","v":37.538079519999997},{"$f":"VLOOKUP(\"yes\",$L$24:$R$684,7,FALSE)","v":0.78}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["1st Nearest?","Location","Latitude","Longitude","Dist. Between 1st (km)","Ss","Sr","Roof (psf)","Wind 1/50 (kpa)","Wind Speed (mph)",null,"2nd Nearest?","Location","Latitude","Longitude","Dist Between 2nd (km)","Roof (psf)","Wind 1/50 (kpa)","Wind Speed (mph)"]
[{"$f":"IF(E24=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Ailsa Craig",43.116999999999997,81.533799999999999,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C24))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C24))*COS(RADIANS(D24-ABS(LONG))))*6371","v":9321.5336690259755},2.2000000000000002,0.4,{"$f":"0.8*((F24*0.8*2/3+G24)*20.88543)","v":26.287794560000005},0.5,{"$f":"ROUNDUP(SQRT(2*I24/0.00064645)*2.236936141,0)","v":88},null,{"$f":"IF(P24=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B24","v":"Ailsa Craig"},{"$f":"C24","v":43.116999999999997},{"$f":"D24","v":81.533799999999999},{"$f":"IF(A24<>\"yes\",E24,\"\")","v":9321.5336690259755},{"$f":"H24","v":26.287794560000005},0.5,{"$f":"ROUNDUP(SQRT(2*R24/0.00064645)*2.236936141,0)","v":88}]
[{"$f":"IF(E25=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Ajax",43.85,79.0167,9129.4112114015115,1,0.4,{"$f":"0.8*((F25*0.8*2/3+G25)*20.88543)","v":15.594454400000002},0.48,{"$f":"ROUNDUP(SQRT(2*I25/0.00064645)*2.236936141,0)","v":87},null,{"$f":"IF(P25=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B25","v":"Ajax"},{"$f":"C25","v":43.85},{"$f":"D25","v":79.0167},{"$f":"IF(A25<>\"yes\",E25,\"\")","v":9129.4112114015115},{"$f":"H25","v":15.594454400000002},0.48,{"$f":"ROUNDUP(SQRT(2*R25/0.00064645)*2.236936141,0)","v":87}]
["","Alexandria",45.311199999999999,74.636700000000005,8813.5240277528846,2.4,0.4,28.070017920000005,0.4,79,null,"","Alexandria",45.311199999999999,74.636700000000005,8813.5240277528846,28.070017920000005,0.4,79]
["","Alliston",44.149900000000002,79.863200000000006,9200.8417544356744,2,0.4,24.505571200000002,0.36,75,null,"","Alliston",44.149900000000002,79.863200000000006,9200.8417544356744,24.505571200000002,0.36,75]
["","Almonte",45.226300000000002,76.194500000000005,8931.6839361718321,2.5,0.4,28.9611296,0.41,80,null,"","Almonte",45.226300000000002,76.194500000000005,8931.6839361718321,28.9611296,0.41,80]
["","Armstrong",47.708300000000001,79.825000000000003,9248.4129980408561,2.7,0.4,30.743352960000006,0.3,69,null,"","Armstrong",47.708300000000001,79.825000000000003,9248.4129980408561,30.743352960000006,0.3,69]
["","Arnprior",45.433300000000003,76.349999999999994,8947.6001494374104,2.5,0.4,28.9611296,0.37,76,null,"","Arnprior",45.433300000000003,76.349999999999994,8947.6001494374104,28.9611296,0.37,76]
["","Atikokan",48.75,91.616699999999994,10126.064337141979,2.4,0.3,26.399183520000005,0.3,69,null,"","Atikokan",48.75,91.616699999999994,10126.064337141979,26.399183520000005,0.3,69]
["","Attawapiskat",52.933100000000003,82.4,9499.1259257710317,2.8,0.3,29.963630240000001,0.41,80,null,"","Attawapiskat",52.933100000000003,82.4,9499.1259257710317,29.963630240000001,0.41,80]
["","Aurora",44,79.466700000000003,9167.3213209616315,2,0.4,24.505571200000002,0.44,83,null,"","Aurora",44,79.466700000000003,9167.3213209616315,24.505571200000002,0.44,83]
["","Bancroft",45.05,77.849999999999994,9056.6744533390465,3.1,0.4,34.307799680000009,0.32,71,null,"","Bancroft",45.05,77.849999999999994,9056.6744533390465,34.307799680000009,0.32,71]
["","Barrie",44.389360000000003,79.690330000000003,9190.5109799844504,2.5,0.4,28.9611296,0.36,75,null,"","Barrie",44.389360000000003,79.690330000000003,9190.5109799844504,28.9611296,0.36,75]
["","Barriefield",44.240279999999998,76.463120000000004,8934.0972026749168,2.1,0.4,25.39668288,0.47,86,null,"","Barriefield",44.240279999999998,76.463120000000004,8934.0972026749168,25.39668288,0.47,86]
["","Beaverton",44.429369999999999,79.153469999999999,9148.8026981377479,2.2000000000000002,0.4,26.287794560000005,0.36,75,null,"","Beaverton",44.429369999999999,79.153469999999999,9148.8026981377479,26.287794560000005,0.36,75]
["","Belleville",44.162759999999999,77.383229999999998,9005.1218758580344,1.7,0.4,21.832236160000001,0.43,82,null,"","Belleville",44.162759999999999,77.383229999999998,9005.1218758580344,21.832236160000001,0.43,82]
["","Belmont",42.881399999999999,81.087519999999998,9282.7202744059196,1.7,0.4,21.832236160000001,0.47,86,null,"","Belmont",42.881399999999999,81.087519999999998,9282.7202744059196,21.832236160000001,0.47,86]
["","Kitchenuhmaykoosib",53.823889999999999,89.880830000000003,9999.7216865430528,3.2,0.2,31.857242560000003,0.42,81,null,"","Kitchenuhmaykoosib",53.823889999999999,89.880830000000003,9999.7216865430528,31.857242560000003,0.42,81]
["","CFB Borden",44.27176,79.911910000000006,9206.3666476683484,2.2000000000000002,0.4,26.287794560000005,0.36,75,null,"","CFB Borden",44.27176,79.911910000000006,9206.3666476683484,26.287794560000005,0.36,75]
["","Bracebridge",45.038960000000003,79.307879999999997,9169.8855156514837,3.1,0.4,34.307799680000009,0.35,74,null,"","Bracebridge",45.038960000000003,79.307879999999997,9169.8855156514837,34.307799680000009,0.35,74]
["","Bradford",44.120220000000003,79.562299999999993,9176.604257005305,2.1,0.4,25.39668288,0.36,75,null,"","Bradford",44.120220000000003,79.562299999999993,9176.604257005305,25.39668288,0.36,75]
["","Brampton",43.683329999999998,79.766670000000005,9186.7538313074365,1.3,0.4,18.267789439999998,0.44,83,null,"","Brampton",43.683329999999998,79.766670000000005,9186.7538313074365,18.267789439999998,0.44,83]
["","Brantford",43.139389999999999,80.264430000000004,9219.4048264838875,1.3,0.4,18.267789439999998,0.42,81,null,"","Brantford",43.139389999999999,80.264430000000004,9219.4048264838875,18.267789439999998,0.42,81]
["","Brighton",44.042259999999999,77.736879999999999,9031.0000686293115,1.6,0.4,20.941124480000003,0.48,87,null,"","Brighton",44.042259999999999,77.736879999999999,9031.0000686293115,20.941124480000003,0.48,87]
["","Brockville",44.58952,75.684290000000004,8879.7895525545973,2.2000000000000002,0.4,26.287794560000005,0.44,83,null,"","Brockville",44.58952,75.684290000000004,8879.7895525545973,26.287794560000005,0.44,83]
["","Burk's Falls",45.619880000000002,79.408749999999998,9186.2568077271244,2.7,0.4,30.743352960000006,0.35,74,null,"","Burk's Falls",45.619880000000002,79.408749999999998,9186.2568077271244,30.743352960000006,0.35,74]
["","Burlington",43.325519999999997,79.799030000000002,9184.4448099245164,1.1000000000000001,0.4,16.485566080000002,0.46,85,null,"","Burlington",43.325519999999997,79.799030000000002,9184.4448099245164,16.485566080000002,0.46,85]
["","Cambridge",43.361620000000002,80.314430000000002,9226.3044638161737,1.6,0.4,20.941124480000003,0.36,75,null,"","Cambridge",43.361620000000002,80.314430000000002,9226.3044638161737,20.941124480000003,0.36,75]
["","Campbellford",44.301290000000002,77.7988,9040.1853786938482,1.7,0.4,21.832236160000001,0.41,80,null,"","Campbellford",44.301290000000002,77.7988,9040.1853786938482,21.832236160000001,0.41,80]
["","Cannington",44.35022,79.038659999999993,9138.5862664305168,2.2000000000000002,0.4,26.287794560000005,0.36,75,null,"","Cannington",44.35022,79.038659999999993,9138.5862664305168,26.287794560000005,0.36,75]
["","Carleton Place",45.140599999999999,76.146550000000005,8926.3426390265777,2.5,0.4,28.9611296,0.41,80,null,"","Carleton Place",45.140599999999999,76.146550000000005,8926.3426390265777,28.9611296,0.41,80]
["","Cavan",44.199669999999998,78.468720000000005,9091.3396412918737,2,0.4,24.505571200000002,0.44,83,null,"","Cavan",44.199669999999998,78.468720000000005,9091.3396412918737,24.505571200000002,0.44,83]
["","Centralia",43.283909999999999,81.472200000000001,9318.4547154206593,2.2999999999999998,0.4,27.17890624,0.49,88,null,"","Centralia",43.283909999999999,81.472200000000001,9318.4547154206593,27.17890624,0.49,88]
["","Chapleau",47.84449,83.40437,9515.9237898935316,3.6,0.4,38.76335808000001,0.3,69,null,"","Chapleau",47.84449,83.40437,9515.9237898935316,38.76335808000001,0.3,69]
["","Chatham",42.404800000000002,82.191040000000001,9367.2853143186439,1,0.4,15.594454400000002,0.43,82,null,"","Chatham",42.404800000000002,82.191040000000001,9367.2853143186439,15.594454400000002,0.43,82]
["","Chesley",44.302759999999999,81.096710000000002,9300.4374550823431,2.8,0.4,31.634464639999994,0.48,87,null,"","Chesley",44.302759999999999,81.096710000000002,9300.4374550823431,31.634464639999994,0.48,87]
["","Clinton",43.617280000000001,81.539400000000001,9327.6384050226334,2.6,0.4,29.852241280000001,0.49,88,null,"","Clinton",43.617280000000001,81.539400000000001,9327.6384050226334,29.852241280000001,0.49,88]
["","Coboconk",44.657780000000002,78.798569999999998,9124.3745174853339,2.5,0.4,28.9611296,0.35,74,null,"","Coboconk",44.657780000000002,78.798569999999998,9124.3745174853339,28.9611296,0.35,74]
["","Cobourg",43.959339999999997,78.167739999999995,9063.737859525665,1.2,0.4,17.376677760000003,0.49,88,null,"","Cobourg",43.959339999999997,78.167739999999995,9063.737859525665,17.376677760000003,0.49,88]
["","Cochrane",49.06503,81.029929999999993,9355.5566234952676,2.8,0.3,29.963630240000001,0.35,74,null,"","Cochrane",49.06503,81.029929999999993,9355.5566234952676,29.963630240000001,0.35,74]
["","Colborne",44.005555999999999,77.888889000000006,9042.4134881504342,1.6,0.4,20.941124480000003,0.49,88,null,"","Colborne",44.005555999999999,77.888889000000006,9042.4134881504342,20.941124480000003,0.49,88]
["","Collingwood",44.500770000000003,80.216899999999995,9233.5195284196816,2.7,0.4,30.743352960000006,0.39,78,null,"","Collingwood",44.500770000000003,80.216899999999995,9233.5195284196816,30.743352960000006,0.39,78]
["","Cornwall",45.021279999999997,74.730350000000001,8814.5849184439903,2.2000000000000002,0.4,26.287794560000005,0.41,80,null,"","Cornwall",45.021279999999997,74.730350000000001,8814.5849184439903,26.287794560000005,0.41,80]
["","Corunna",42.882719999999999,82.450959999999995,9393.2904696859387,1,0.4,15.594454400000002,0.47,86,null,"","Corunna",42.882719999999999,82.450959999999995,9393.2904696859387,15.594454400000002,0.47,86]
["","Deep River",46.097659999999998,77.493340000000003,9047.2117020942187,2.5,0.4,28.9611296,0.35,74,null,"","Deep River",46.097659999999998,77.493340000000003,9047.2117020942187,28.9611296,0.35,74]
["","Deseronto",44.195399999999999,77.048730000000006,8979.3413901469958,1.9,0.4,23.614459520000004,0.43,82,null,"","Deseronto",44.195399999999999,77.048730000000006,8979.3413901469958,23.614459520000004,0.43,82]
["","Dorchester",42.985210000000002,81.049130000000005,9280.8413409988134,1.9,0.4,23.614459520000004,0.47,86,null,"","Dorchester",42.985210000000002,81.049130000000005,9280.8413409988134,23.614459520000004,0.47,86]
["","Dorion",48.785719999999998,88.561989999999994,9902.1956151331597,2.8,0.4,31.634464639999994,0.39,78,null,"","Dorion",48.785719999999998,88.561989999999994,9902.1956151331597,31.634464639999994,0.39,78]
["","Dresden",42.589559999999999,82.183310000000006,9368.5504737894116,1,0.4,15.594454400000002,0.43,82,null,"","Dresden",42.589559999999999,82.183310000000006,9368.5504737894116,15.594454400000002,0.43,82]
["","Dryden",49.780090000000001,92.836960000000005,10211.191783654149,2.4,0.3,26.399183520000005,0.3,69,null,"","Dryden",49.780090000000001,92.836960000000005,10211.191783654149,26.399183520000005,0.3,69]
["","Dundalk",44.167670000000001,80.393569999999997,9243.0809417516375,3.2,0.4,35.198911360000004,0.42,81,null,"","Dundalk",44.167670000000001,80.393569999999997,9243.0809417516375,35.198911360000004,0.42,81]
["","Dunnville",42.90354,79.617000000000004,9164.0028343601789,2,0.4,24.505571200000002,0.46,85,null,"","Dunnville",42.90354,79.617000000000004,9164.0028343601789,24.505571200000002,0.46,85]
["","Durham",44.176310000000001,80.818430000000006,9276.8525721612841,2.8,0.4,31.634464639999994,0.44,83,null,"","Durham",44.176310000000001,80.818430000000006,9276.8525721612841,31.634464639999994,0.44,83]
["","Dutton",42.663789999999999,81.502709999999993,9313.9251832683149,1.3,0.4,18.267789439999998,0.47,86,null,"","Dutton",42.663789999999999,81.502709999999993,9313.9251832683149,18.267789439999998,0.47,86]
["","Earlton",47.710709999999999,79.824640000000002,9248.421566607487,3.1,0.4,34.307799680000009,0.45,84,null,"","Earlton",47.710709999999999,79.824640000000002,9248.421566607487,34.307799680000009,0.45,84]
["","Edison",44.309060000000002,78.319749999999999,9081.3208611956143,2.4,0.3,26.399183520000005,0.31,70,null,"","Edison",44.309060000000002,78.319749999999999,9081.3208611956143,26.399183520000005,0.31,70]
["","Elliot Lake",46.386180000000003,82.650940000000006,9444.6710064807066,2.9,0.4,32.525576319999999,0.38,77,null,"","Elliot Lake",46.386180000000003,82.650940000000006,9444.6710064807066,32.525576319999999,0.38,77]
["","Elmvale",44.583629999999999,79.866069999999993,9207.0501584036683,2.6,0.4,29.852241280000001,0.36,75,null,"","Elmvale",44.583629999999999,79.866069999999993,9207.0501584036683,29.852241280000001,0.36,75]
["","Embro",43.1556,80.901060000000001,9270.9268648071902,2,0.4,24.505571200000002,0.48,87,null,"","Embro",43.1556,80.901060000000001,9270.9268648071902,24.505571200000002,0.48,87]
["","Engelhart",47.824240000000003,79.873829999999998,9253.7250741837361,2.8,0.4,31.634464639999994,0.41,80,null,"","Engelhart",47.824240000000003,79.873829999999998,9253.7250741837361,31.634464639999994,0.41,80]
["","Espanola",46.265720000000002,81.771060000000006,9376.1182358660044,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Espanola",46.265720000000002,81.771060000000006,9376.1182358660044,27.17890624,0.42,81]
["","Exeter",43.345750000000002,81.479929999999996,9319.7801254233182,2.4,0.4,28.070017920000005,0.49,88,null,"","Exeter",43.345750000000002,81.479929999999996,9319.7801254233182,28.070017920000005,0.49,88]
["","Fenelon Falls",44.537019999999998,78.736130000000003,9117.6236290881607,2.2999999999999998,0.4,27.17890624,0.36,75,null,"","Fenelon Falls",44.537019999999998,78.736130000000003,9117.6236290881607,27.17890624,0.36,75]
["","Fergus",43.705950000000001,80.377830000000003,9235.8360708547734,2.2000000000000002,0.4,26.287794560000005,0.36,75,null,"","Fergus",43.705950000000001,80.377830000000003,9235.8360708547734,26.287794560000005,0.36,75]
["","Forest",43.1,82,9359.00962459533,2,0.4,24.505571200000002,0.48,87,null,"","Forest",43.1,82,9359.00962459533,24.505571200000002,0.48,87]
["","Fort Erie",42.901780000000002,78.972170000000006,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C88))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C88))*COS(RADIANS(D88-ABS(LONG))))*6371","v":9111.8852244319223},2.2999999999999998,0.4,27.17890624,0.46,85,null,"","Fort Erie",42.901780000000002,78.972170000000006,9111.8852244319223,27.17890624,0.46,85]
[{"$f":"IF(E89=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Fort Erie (Ridgeway)",42.883609999999997,79.057429999999997,9118.5064343141221,2.2999999999999998,0.4,{"$f":"0.8*((F89*0.8*2/3+G89)*20.88543)","v":27.17890624},0.46,{"$f":"ROUNDUP(SQRT(2*I89/0.00064645)*2.236936141,0)","v":85},null,{"$f":"IF(P89=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B89","v":"Fort Erie (Ridgeway)"},{"$f":"C89","v":42.883609999999997},{"$f":"D89","v":79.057429999999997},{"$f":"IF(A89<>\"yes\",E89,\"\")","v":9118.5064343141221},{"$f":"H89","v":27.17890624},0.46,{"$f":"ROUNDUP(SQRT(2*R89/0.00064645)*2.236936141,0)","v":85}]
["","Fort Frances",48.609949999999998,93.395529999999994,10257.100605698133,2.2999999999999998,0.3,25.508071839999999,0.31,70,null,"","Fort Frances",48.609949999999998,93.395529999999994,10257.100605698133,25.508071839999999,0.31,70]
["","Gananoque",44.330620000000003,76.161860000000004,8912.1400080068015,2.1,0.4,25.39668288,0.47,86,null,"","Gananoque",44.330620000000003,76.161860000000004,8912.1400080068015,25.39668288,0.47,86]
["","Geraldton",49.726770000000002,86.948840000000004,9788.2860435714902,2.9,0.4,32.525576319999999,0.3,69,null,"","Geraldton",49.726770000000002,86.948840000000004,9788.2860435714902,32.525576319999999,0.3,69]
["","Glencoe",42.747259999999997,81.709450000000004,9331.6585018842852,1.5,0.4,20.050012800000005,0.43,82,null,"","Glencoe",42.747259999999997,81.709450000000004,9331.6585018842852,20.050012800000005,0.43,82]
["","Goderich",43.742829999999998,81.713890000000006,9343.0103003040513,2.4,0.4,28.070017920000005,0.55000000000000004,93,null,"","Goderich",43.742829999999998,81.713890000000006,9343.0103003040513,28.070017920000005,0.55000000000000004,93]
["","Gore Bay",45.9114,82.459779999999995,9425.0573517782559,2.6,0.4,29.852241280000001,0.44,83,null,"","Gore Bay",45.9114,82.459779999999995,9425.0573517782559,29.852241280000001,0.44,83]
["","Graham",49.249549999999999,90.5732,10049.148282867038,2.6,0.3,28.181406880000004,0.3,69,null,"","Graham",49.249549999999999,90.5732,10049.148282867038,28.181406880000004,0.3,69]
["","Gravenhurst",44.919640000000001,79.374179999999996,9173.3051145047011,2.7,0.4,30.743352960000006,0.36,75,null,"","Gravenhurst",44.919640000000001,79.374179999999996,9173.3051145047011,30.743352960000006,0.36,75]
["","Grimsby",43.194209999999998,79.562420000000003,9163.6241655681115,0.9,0.4,14.703342720000002,0.46,85,null,"","Grimsby",43.194209999999998,79.562420000000003,9163.6241655681115,14.703342720000002,0.46,85]
["","Guelph",43.544800000000002,80.248170000000002,9223.3754595654318,1.9,0.4,23.614459520000004,0.36,75,null,"","Guelph",43.544800000000002,80.248170000000002,9223.3754595654318,23.614459520000004,0.36,75]
["","Guthrie",44.472799999999999,79.550020000000004,9180.6404122895074,2.5,0.4,28.9611296,0.36,75,null,"","Guthrie",44.472799999999999,79.550020000000004,9180.6404122895074,28.9611296,0.36,75]
["","Haileybury",47.44632,79.635459999999995,9230.4590041077681,2.4,0.4,28.070017920000005,0.44,83,null,"","Haileybury",47.44632,79.635459999999995,9230.4590041077681,28.070017920000005,0.44,83]
["","Haldimand (Caledonia)",43.064869999999999,79.962620000000001,9194.0936909630582,1.2,0.4,17.376677760000003,0.44,83,null,"","Haldimand (Caledonia)",43.064869999999999,79.962620000000001,9194.0936909630582,17.376677760000003,0.44,83]
["","Haldimand (Hagersville)",42.949390000000001,80.045010000000005,9199.212466662666,1.3,0.4,18.267789439999998,0.46,85,null,"","Haldimand (Hagersville)",42.949390000000001,80.045010000000005,9199.212466662666,18.267789439999998,0.46,85]
["","Haliburton",45.083300000000001,78.5,9107.7134121010531,2.9,0.4,32.525576319999999,0.35,74,null,"","Haliburton",45.083300000000001,78.5,9107.7134121010531,32.525576319999999,0.35,74]
["","Halton Hills",43.646990000000002,80.017660000000006,9206.2978515934265,1.4,0.4,19.158901119999996,0.37,76,null,"","Halton Hills",43.646990000000002,80.017660000000006,9206.2978515934265,19.158901119999996,0.37,76]
["","Hamilton",43.250019999999999,79.86609,9188.8075024162008,1.1000000000000001,0.4,16.485566080000002,0.46,85,null,"","Hamilton",43.250019999999999,79.86609,9188.8075024162008,16.485566080000002,0.46,85]
["","Hanover",44.1526,81.025409999999994,9292.9692518488137,2.6,0.4,29.852241280000001,0.48,87,null,"","Hanover",44.1526,81.025409999999994,9292.9692518488137,29.852241280000001,0.48,87]
["","Hastings",44.309579999999997,77.956760000000003,9052.7525440030895,2,0.4,24.505571200000002,0.41,80,null,"","Hastings",44.309579999999997,77.956760000000003,9052.7525440030895,24.505571200000002,0.41,80]
["","Hawkesbury",45.607129999999998,74.604719000000003,8817.4068951437312,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Hawkesbury",45.607129999999998,74.604719000000003,8817.4068951437312,27.17890624,0.41,80]
["","Hearst",49.688020000000002,83.666960000000003,9552.5008219898082,2.8,0.3,29.963630240000001,0.3,69,null,"","Hearst",49.688020000000002,83.666960000000003,9552.5008219898082,29.963630240000001,0.3,69]
["","Honey Harbour",44.871070000000003,79.81711,9207.2112661785959,2.7,0.4,30.743352960000006,0.39,78,null,"","Honey Harbour",44.871070000000003,79.81711,9207.2112661785959,30.743352960000006,0.39,78]
["","Hornepayne",49.21302,84.771069999999995,9628.0273700596572,3.3,0.4,36.090023039999998,0.3,69,null,"","Hornepayne",49.21302,84.771069999999995,9628.0273700596572,36.090023039999998,0.3,69]
["","Huntsville",45.326929999999997,79.216750000000005,9167.0758933500838,2.9,0.4,32.525576319999999,0.35,74,null,"","Huntsville",45.326929999999997,79.216750000000005,9167.0758933500838,32.525576319999999,0.35,74]
["","Ingersoll",43.038159999999998,80.884050000000002,9268.132171447156,1.7,0.4,21.832236160000001,0.48,87,null,"","Ingersoll",43.038159999999998,80.884050000000002,9268.132171447156,21.832236160000001,0.48,87]
["","Iroquios Falls",48.767980000000001,80.673169999999999,9325.6970939374278,2.9,0.3,30.854741919999999,0.37,76,null,"","Iroquios Falls",48.767980000000001,80.673169999999999,9325.6970939374278,30.854741919999999,0.37,76]
["","Jellicoe",49.683329999999998,87.516670000000005,9828.9142088331937,2.7,0.4,30.743352960000006,0.3,69,null,"","Jellicoe",49.683329999999998,87.516670000000005,9828.9142088331937,30.743352960000006,0.3,69]
["","Kapuskasing",49.412509999999997,82.41874,9460.0072712709079,3,0.3,31.745853600000004,0.31,70,null,"","Kapuskasing",49.412509999999997,82.41874,9460.0072712709079,31.745853600000004,0.31,70]
["","Kemptville",45.016390000000001,75.645949999999999,8885.2246481573384,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Kemptville",45.016390000000001,75.645949999999999,8885.2246481573384,27.17890624,0.41,80]
["","Kenora",49.767040000000001,94.48939,10329.781029185384,2.5,0.3,27.290295199999999,0.31,70,null,"","Kenora",49.767040000000001,94.48939,10329.781029185384,27.290295199999999,0.31,70]
["","Killaloe",45.564500000000002,77.419600000000003,9032.2268994179376,2.7,0.4,30.743352960000006,0.35,74,null,"","Killaloe",45.564500000000002,77.419600000000003,9032.2268994179376,30.743352960000006,0.35,74]
["","Kincardine",44.1753,81.636570000000006,9341.712557480043,2.6,0.4,29.852241280000001,0.55000000000000004,93,null,"","Kincardine",44.1753,81.636570000000006,9341.712557480043,29.852241280000001,0.55000000000000004,93]
["","Kingston",44.231169999999999,76.485950000000003,8935.7233082292605,2.1,0.4,25.39668288,0.47,86,null,"","Kingston",44.231169999999999,76.485950000000003,8935.7233082292605,25.39668288,0.47,86]
["","Kinmount",44.781669999999998,78.651499999999999,9114.7809144723451,2.7,0.4,30.743352960000006,0.35,74,null,"","Kinmount",44.781669999999998,78.651499999999999,9114.7809144723451,30.743352960000006,0.35,74]
["","Kirkland Lake",48.151009999999999,80.033029999999997,9270.2136629455745,2.9,0.3,30.854741919999999,0.39,78,null,"","Kirkland Lake",48.151009999999999,80.033029999999997,9270.2136629455745,30.854741919999999,0.39,78]
["","Kitchener",43.434310000000004,80.47775,9240.3448635052246,2,0.4,24.505571200000002,0.37,76,null,"","Kitchener",43.434310000000004,80.47775,9240.3448635052246,24.505571200000002,0.37,76]
["","Lakefield",44.422190000000001,78.273139999999998,9079.4573055914261,2.2000000000000002,0.4,26.287794560000005,0.38,77,null,"","Lakefield",44.422190000000001,78.273139999999998,9079.4573055914261,26.287794560000005,0.38,77]
["","Lansdowne House",52.219470000000001,87.891229999999993,9863.9094104199794,3,0.2,30.075019200000003,0.32,71,null,"","Lansdowne House",52.219470000000001,87.891229999999993,9863.9094104199794,30.075019200000003,0.32,71]
["","Leamington",42.053159999999998,82.599890000000002,9397.3189646280662,0.8,0.4,13.81223104,0.47,86,null,"","Leamington",42.053159999999998,82.599890000000002,9397.3189646280662,13.81223104,0.47,86]
["","Lindsay",44.356569999999998,78.740750000000006,9115.2158959026165,2.2999999999999998,0.4,27.17890624,0.38,77,null,"","Lindsay",44.356569999999998,78.740750000000006,9115.2158959026165,27.17890624,0.38,77]
["","Lion's Head",44.98715,81.25461,9321.1083149587757,2.7,0.4,30.743352960000006,0.48,87,null,"","Lion's Head",44.98715,81.25461,9321.1083149587757,30.743352960000006,0.48,87]
["","Listowel",43.733420000000002,80.95147,9281.9860457530067,2.6,0.4,29.852241280000001,0.47,86,null,"","Listowel",43.733420000000002,80.95147,9281.9860457530067,29.852241280000001,0.47,86]
["","London",42.98695,81.243179999999995,9296.5577619531632,1.9,0.4,23.614459520000004,0.47,86,null,"","London",42.98695,81.243179999999995,9296.5577619531632,23.614459520000004,0.47,86]
["","Lucan",43.187809999999999,81.402839999999998,9311.7692137373288,2.2999999999999998,0.4,27.17890624,0.5,88,null,"","Lucan",43.187809999999999,81.402839999999998,9311.7692137373288,27.17890624,0.5,88]
["","Maitland",44.638309999999997,75.609039999999993,8874.8867091380271,2.2000000000000002,0.4,26.287794560000005,0.44,83,null,"","Maitland",44.638309999999997,75.609039999999993,8874.8867091380271,26.287794560000005,0.44,83]
["","Markdale",44.318680000000001,80.647880000000001,9265.1457750173122,3.2,0.4,35.198911360000004,0.41,80,null,"","Markdale",44.318680000000001,80.647880000000001,9265.1457750173122,35.198911360000004,0.41,80]
["","Markham",43.856099999999998,79.337019999999995,9154.9626705218889,1.3,0.4,18.267789439999998,0.44,83,null,"","Markham",43.856099999999998,79.337019999999995,9154.9626705218889,18.267789439999998,0.44,83]
["","Martin",49.249580000000002,91.147599999999997,10090.83781826733,2.6,0.3,28.181406880000004,0.3,69,null,"","Martin",49.249580000000002,91.147599999999997,10090.83781826733,28.181406880000004,0.3,69]
["","Matheson",48.533810000000003,80.464089999999999,9307.2340331571359,2.8,0.3,29.963630240000001,0.39,78,null,"","Matheson",48.533810000000003,80.464089999999999,9307.2340331571359,29.963630240000001,0.39,78]
["","Mattawa",46.317480000000003,78.702190000000002,9142.8525855642747,2.1,0.4,25.39668288,0.32,71,null,"","Mattawa",46.317480000000003,78.702190000000002,9142.8525855642747,25.39668288,0.32,71]
["","Midland",44.749519999999997,79.892189999999999,9211.3964098975503,2.7,0.4,30.743352960000006,0.39,78,null,"","Midland",44.749519999999997,79.892189999999999,9211.3964098975503,30.743352960000006,0.39,78]
["","Milton",43.518300000000004,79.877399999999994,9193.3478234561062,1.3,0.4,18.267789439999998,0.43,82,null,"","Milton",43.518300000000004,79.877399999999994,9193.3478234561062,18.267789439999998,0.43,82]
["","Milverton",43.565800000000003,80.9221,9277.5973326694111,2.4,0.4,28.070017920000005,0.43,82,null,"","Milverton",43.565800000000003,80.9221,9277.5973326694111,28.070017920000005,0.43,82]
["","Minden",44.92718,78.725380000000001,9122.8078081140593,2.7,0.4,30.743352960000006,0.35,74,null,"","Minden",44.92718,78.725380000000001,9122.8078081140593,30.743352960000006,0.35,74]
["","Mississauga",43.58905,79.644120000000001,9175.6642907005535,1.1000000000000001,0.4,16.485566080000002,0.44,83,null,"","Mississauga",43.58905,79.644120000000001,9175.6642907005535,16.485566080000002,0.44,83]
["","Mitchell",43.467799999999997,81.196870000000004,9298.4510970957053,2.4,0.4,28.070017920000005,0.48,87,null,"","Mitchell",43.467799999999997,81.196870000000004,9298.4510970957053,28.070017920000005,0.48,87]
["","Moosonee",51.273090000000003,80.640050000000002,9358.1911135133359,2.7,0.3,29.072518560000006,0.35,74,null,"","Moosonee",51.273090000000003,80.640050000000002,9358.1911135133359,29.072518560000006,0.35,74]
["","Morrisburg",44.897790000000001,75.183400000000006,8847.0440169148987,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Morrisburg",44.897790000000001,75.183400000000006,8847.0440169148987,27.17890624,0.41,80]
["","Mount Forest",43.981090000000002,80.735870000000006,9267.8628317925595,2.7,0.4,30.743352960000006,0.41,80,null,"","Mount Forest",43.981090000000002,80.735870000000006,9267.8628317925595,30.743352960000006,0.41,80]
["","Nakina",49.766669999999998,87.283330000000007,9812.4720264897205,2.8,0.4,31.634464639999994,0.3,69,null,"","Nakina",49.766669999999998,87.283330000000007,9812.4720264897205,31.634464639999994,0.3,69]
["","Nanticoke",42.809069999999998,80.082279999999997,9200.3811277681798,1.4,0.4,19.158901119999996,0.48,87,null,"","Nanticoke",42.809069999999998,80.082279999999997,9200.3811277681798,19.158901119999996,0.48,87]
["","Napanee",44.248469999999998,76.951139999999995,8972.6017154850742,1.9,0.4,23.614459520000004,0.43,82,null,"","Napanee",44.248469999999998,76.951139999999995,8972.6017154850742,23.614459520000004,0.43,82]
["","New Liskeard",47.508760000000002,79.674310000000006,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C152))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C152))*COS(RADIANS(D152-ABS(LONG))))*6371","v":9234.2784330619888},2.6,0.4,29.852241280000001,0.43,82,null,"","New Liskeard",47.508760000000002,79.674310000000006,9234.2784330619888,29.852241280000001,0.43,82]
[{"$f":"IF(E153=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Newcastle",43.917769999999997,78.587479999999999,9096.3560792027347,1.5,0.4,{"$f":"0.8*((F153*0.8*2/3+G153)*20.88543)","v":20.050012800000005},0.48,{"$f":"ROUNDUP(SQRT(2*I153/0.00064645)*2.236936141,0)","v":87},null,{"$f":"IF(P153=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B153","v":"Newcastle"},{"$f":"C153","v":43.917769999999997},{"$f":"D153","v":78.587479999999999},{"$f":"IF(A153<>\"yes\",E153,\"\")","v":9096.3560792027347},{"$f":"H153","v":20.050012800000005},0.48,{"$f":"ROUNDUP(SQRT(2*R153/0.00064645)*2.236936141,0)","v":87}]
["","Newmarket",44.059190000000001,79.461259999999996,9167.7337723186647,2,0.4,24.505571200000002,0.38,77,null,"","Newmarket",44.059190000000001,79.461259999999996,9167.7337723186647,24.505571200000002,0.38,77]
["","Niagara Falls",43.089559999999999,79.084940000000003,9123.7141442432694,1.8,0.4,22.723347840000002,0.43,82,null,"","Niagara Falls",43.089559999999999,79.084940000000003,9123.7141442432694,22.723347840000002,0.43,82]
["","North Bay",46.30912,79.460819999999998,9200.4309569206907,2.2000000000000002,0.4,26.287794560000005,0.34,73,null,"","North Bay",46.30912,79.460819999999998,9200.4309569206907,26.287794560000005,0.34,73]
["","Norwood",44.382420000000003,77.979920000000007,9055.7675719471954,2.1,0.4,25.39668288,0.41,80,null,"","Norwood",44.382420000000003,77.979920000000007,9055.7675719471954,25.39668288,0.41,80]
["","Oakville",43.46752,79.687669999999997,9177.4640802512095,1.1000000000000001,0.4,16.485566080000002,0.47,86,null,"","Oakville",43.46752,79.687669999999997,9177.4640802512095,16.485566080000002,0.47,86]
["","Orangeville",43.919980000000002,80.094309999999993,9216.061949510382,2.2999999999999998,0.4,27.17890624,0.36,75,null,"","Orangeville",43.919980000000002,80.094309999999993,9216.061949510382,27.17890624,0.36,75]
["","Orillia",44.608249999999998,79.41968,9172.3412585477581,2.4,0.4,28.070017920000005,0.36,75,null,"","Orillia",44.608249999999998,79.41968,9172.3412585477581,28.070017920000005,0.36,75]
["","Oshawa",43.897089999999999,78.865790000000004,9118.1270161920402,1.4,0.4,19.158901119999996,0.48,87,null,"","Oshawa",43.897089999999999,78.865790000000004,9118.1270161920402,19.158901119999996,0.48,87]
["","Ottawa",45.421529999999997,75.697190000000006,8897.2101817607636,2.4,0.4,28.070017920000005,0.41,80,null,"","Ottawa",45.421529999999997,75.697190000000006,8897.2101817607636,28.070017920000005,0.41,80]
["","Owen Sound",44.569029999999998,80.940560000000005,9291.3711925083044,2.8,0.4,31.634464639999994,0.48,87,null,"","Owen Sound",44.569029999999998,80.940560000000005,9291.3711925083044,31.634464639999994,0.48,87]
["","Pagwa River",50.016669999999998,85.216669999999993,9666.008086185233,2.7,0.4,30.743352960000006,0.3,69,null,"","Pagwa River",50.016669999999998,85.216669999999993,9666.008086185233,30.743352960000006,0.3,69]
["","Paris",43.194020000000002,80.384500000000003,9229.7809100663271,1.4,0.4,19.158901119999996,0.42,81,null,"","Paris",43.194020000000002,80.384500000000003,9229.7809100663271,19.158901119999996,0.42,81]
["","Parkhill",43.162269999999999,81.684219999999996,9334.1819531921246,2.1,0.4,25.39668288,0.5,88,null,"","Parkhill",43.162269999999999,81.684219999999996,9334.1819531921246,25.39668288,0.5,88]
["","Parry Sound",45.347389999999997,80.034779999999998,9230.7735146323485,2.8,0.4,31.634464639999994,0.39,78,null,"","Parry Sound",45.347389999999997,80.034779999999998,9230.7735146323485,31.634464639999994,0.39,78]
["","Pelham",43.03772,79.328760000000003,9142.6119507462663,2.1,0.4,25.39668288,0.42,81,null,"","Pelham",43.03772,79.328760000000003,9142.6119507462663,25.39668288,0.42,81]
["","Pembroke",45.826650000000001,77.110879999999995,9013.2113658172966,2.5,0.4,28.9611296,0.35,74,null,"","Pembroke",45.826650000000001,77.110879999999995,9013.2113658172966,28.9611296,0.35,74]
["","Penetanguishene",44.768770000000004,79.933679999999995,9214.9129554365245,2.8,0.4,31.634464639999994,0.39,78,null,"","Penetanguishene",44.768770000000004,79.933679999999995,9214.9129554365245,31.634464639999994,0.39,78]
["","Perth",44.898809999999997,76.248559999999998,8929.6391198896163,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Perth",44.898809999999997,76.248559999999998,8929.6391198896163,27.17890624,0.41,80]
["","Petawawa",45.898260000000001,77.282880000000006,9027.6380945324145,2.6,0.4,29.852241280000001,0.35,74,null,"","Petawawa",45.898260000000001,77.282880000000006,9027.6380945324145,29.852241280000001,0.35,74]
["","Peterborough",44.309060000000002,78.319749999999999,9081.3208611956143,2,0.4,24.505571200000002,0.41,80,null,"","Peterborough",44.309060000000002,78.319749999999999,9081.3208611956143,24.505571200000002,0.41,80]
["","Petrolia",42.881839999999997,82.14443,9368.4110322114466,1.3,0.4,18.267789439999998,0.47,86,null,"","Petrolia",42.881839999999997,82.14443,9368.4110322114466,18.267789439999998,0.47,86]
["","Pickering",43.838410000000003,79.086759999999998,9134.8088567037757,1,0.4,15.594454400000002,0.48,87,null,"","Pickering",43.838410000000003,79.086759999999998,9134.8088567037757,15.594454400000002,0.48,87]
["","Picton",44.008620000000001,77.139219999999995,8983.2061207353454,2,0.4,24.505571200000002,0.49,88,null,"","Picton",44.008620000000001,77.139219999999995,8983.2061207353454,24.505571200000002,0.49,88]
["","Plattsville",43.303249999999998,80.621570000000006,9250.2400998133653,1.9,0.4,23.614459520000004,0.42,81,null,"","Plattsville",43.303249999999998,80.621570000000006,9250.2400998133653,23.614459520000004,0.42,81]
["","Point Alexander",46.133330000000001,77.566670000000002,9053.4179040756117,2.5,0.4,28.9611296,0.35,74,null,"","Point Alexander",46.133330000000001,77.566670000000002,9053.4179040756117,28.9611296,0.35,74]
["","Port Burwell",42.647799999999997,80.800319999999999,9256.6164587107451,1.2,0.4,17.376677760000003,0.47,86,null,"","Port Burwell",42.647799999999997,80.800319999999999,9256.6164587107451,17.376677760000003,0.47,86]
["","Port Colborne",42.886519999999997,79.250860000000003,9134.1756622843877,2.1,0.4,25.39668288,0.46,85,null,"","Port Colborne",42.886519999999997,79.250860000000003,9134.1756622843877,25.39668288,0.46,85]
["","Port Elgin",44.434049999999999,81.392939999999996,9325.4121173607,2.8,0.4,31.634464639999994,0.55000000000000004,93,null,"","Port Elgin",44.434049999999999,81.392939999999996,9325.4121173607,31.634464639999994,0.55000000000000004,93]
["","Port Hope",43.949159999999999,78.293459999999996,9073.5359423296595,1.2,0.4,17.376677760000003,0.48,87,null,"","Port Hope",43.949159999999999,78.293459999999996,9073.5359423296595,17.376677760000003,0.48,87]
["","Port Perry",44.105049999999999,78.944149999999993,9127.4585970265452,2.4,0.4,28.070017920000005,0.44,83,null,"","Port Perry",44.105049999999999,78.944149999999993,9127.4585970265452,28.070017920000005,0.44,83]
["","Port Stanley",42.664140000000003,81.215630000000004,9290.5792454971142,1.2,0.4,17.376677760000003,0.47,86,null,"","Port Stanley",42.664140000000003,81.215630000000004,9290.5792454971142,17.376677760000003,0.47,86]
["","Prescott",44.709290000000003,75.518969999999996,8869.2840961418115,2.2000000000000002,0.4,26.287794560000005,0.44,83,null,"","Prescott",44.709290000000003,75.518969999999996,8869.2840961418115,26.287794560000005,0.44,83]
["","Princeton",43.170050000000003,80.526719999999997,9240.9320672061549,1.5,0.4,20.050012800000005,0.42,81,null,"","Princeton",43.170050000000003,80.526719999999997,9240.9320672061549,20.050012800000005,0.42,81]
["","Raith",48.818559999999998,89.919579999999996,10001.655382814037,2.7,0.4,30.743352960000006,0.3,69,null,"","Raith",48.818559999999998,89.919579999999996,10001.655382814037,30.743352960000006,0.3,69]
["","Rayside-Balfour",46.628680000000003,81.245199999999997,9340.4049919711615,2.5,0.4,28.9611296,0.45,84,null,"","Rayside-Balfour",46.628680000000003,81.245199999999997,9340.4049919711615,28.9611296,0.45,84]
["","Red Lake",51.014600000000002,93.828919999999997,10275.275782719305,2.6,0.3,28.181406880000004,0.3,69,null,"","Red Lake",51.014600000000002,93.828919999999997,10275.275782719305,28.181406880000004,0.3,69]
["","Renfrew",45.474919999999997,76.687719999999999,8974.3457843349443,2.5,0.4,28.9611296,0.35,74,null,"","Renfrew",45.474919999999997,76.687719999999999,8974.3457843349443,28.9611296,0.35,74]
["","Richmond Hill",43.882840000000002,79.440280000000001,9163.554207258876,1.5,0.4,20.050012800000005,0.44,83,null,"","Richmond Hill",43.882840000000002,79.440280000000001,9163.554207258876,20.050012800000005,0.44,83]
["","Rockland",45.548369999999998,75.291610000000006,8868.6753929647384,2.4,0.4,28.070017920000005,0.4,79,null,"","Rockland",45.548369999999998,75.291610000000006,8868.6753929647384,28.070017920000005,0.4,79]
["","Sarnia",42.974539999999998,82.406589999999994,9390.6132230104995,1.1000000000000001,0.4,16.485566080000002,0.47,86,null,"","Sarnia",42.974539999999998,82.406589999999994,9390.6132230104995,16.485566080000002,0.47,86]
["","Sault Ste. Marie",46.521859999999997,84.346090000000004,9575.3287152563862,3.1,0.4,34.307799680000009,0.44,83,null,"","Sault Ste. Marie",46.521859999999997,84.346090000000004,9575.3287152563862,34.307799680000009,0.44,83]
["","Schreiber",48.813310000000001,87.266459999999995,9807.4270823679781,3.3,0.4,36.090023039999998,0.39,78,null,"","Schreiber",48.813310000000001,87.266459999999995,9807.4270823679781,36.090023039999998,0.39,78]
["","Seaforth",43.553429999999999,81.3934,9315.2108563627626,2.5,0.4,28.9611296,0.48,87,null,"","Seaforth",43.553429999999999,81.3934,9315.2108563627626,28.9611296,0.48,87]
["","Shelburne",44.079120000000003,80.201170000000005,9226.667304921255,3.1,0.4,34.307799680000009,0.4,79,null,"","Shelburne",44.079120000000003,80.201170000000005,9226.667304921255,34.307799680000009,0.4,79]
["","Simcoe",42.837260000000001,80.304040000000001,9218.7093089392656,1.3,0.4,18.267789439999998,0.45,84,null,"","Simcoe",42.837260000000001,80.304040000000001,9218.7093089392656,18.267789439999998,0.45,84]
["","Sioux Lookout",50.097830000000002,91.922039999999996,10144.625791742461,2.6,0.3,28.181406880000004,0.3,69,null,"","Sioux Lookout",50.097830000000002,91.922039999999996,10144.625791742461,28.181406880000004,0.3,69]
["","Smiths Falls",44.903750000000002,76.021619999999999,8912.1244276584403,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Smiths Falls",44.903750000000002,76.021619999999999,8912.1244276584403,27.17890624,0.41,80]
["","Smithville",43.095649999999999,79.549419999999998,9161.207129983919,1.5,0.4,20.050012800000005,0.42,81,null,"","Smithville",43.095649999999999,79.549419999999998,9161.207129983919,20.050012800000005,0.42,81]
["","Smooth Rock Falls",49.27534,81.620890000000003,9400.9181195607362,2.7,0.3,29.072518560000006,0.32,71,null,"","Smooth Rock Falls",49.27534,81.620890000000003,9400.9181195607362,29.072518560000006,0.32,71]
["","South River",45.84104,79.379570000000001,9187.280119401441,2.8,0.4,31.634464639999994,0.35,74,null,"","South River",45.84104,79.379570000000001,9187.280119401441,31.634464639999994,0.35,74]
["","Southampton",44.49485,81.369560000000007,9324.280860443283,2.7,0.4,30.743352960000006,0.53,91,null,"","Southampton",44.49485,81.369560000000007,9324.280860443283,30.743352960000006,0.53,91]
["","St. Catherines",43.159370000000003,79.246859999999998,9137.7511300290607,1,0.4,15.594454400000002,0.46,85,null,"","St. Catherines",43.159370000000003,79.246859999999998,9137.7511300290607,15.594454400000002,0.46,85]
["","St. Mary's",43.259590000000003,81.140649999999994,9291.4760508686322,2.2000000000000002,0.4,26.287794560000005,0.47,86,null,"","St. Mary's",43.259590000000003,81.140649999999994,9291.4760508686322,26.287794560000005,0.47,86]
["","St. Thomas",42.777720000000002,81.182649999999995,9289.2191148411184,1.4,0.4,19.158901119999996,0.47,86,null,"","St. Thomas",42.777720000000002,81.182649999999995,9289.2191148411184,19.158901119999996,0.47,86]
["","Stirling",44.296140000000001,77.547489999999996,9020.3278834661414,1.7,0.4,21.832236160000001,0.4,79,null,"","Stirling",44.296140000000001,77.547489999999996,9020.3278834661414,21.832236160000001,0.4,79]
["","Stratford",43.37,80.982230000000001,9280.0500934620668,2.2999999999999998,0.4,27.17890624,0.45,84,null,"","Stratford",43.37,80.982230000000001,9280.0500934620668,27.17890624,0.45,84]
["","Strathroy",42.955419999999997,81.623230000000007,9326.9591049207593,1.9,0.4,23.614459520000004,0.47,86,null,"","Strathroy",42.955419999999997,81.623230000000007,9326.9591049207593,23.614459520000004,0.47,86]
["","Sturgeon Falls",46.36795,79.924473000000006,9236.574044390185,2.4,0.4,28.070017920000005,0.35,74,null,"","Sturgeon Falls",46.36795,79.924473000000006,9236.574044390185,28.070017920000005,0.35,74]
["","Sudbury",46.49,81.010000000000005,9320.7998084990704,2.5,0.4,28.9611296,0.46,85,null,"","Sudbury",46.49,81.010000000000005,9320.7998084990704,28.9611296,0.46,85]
["","Sundridge",45.769030000000001,79.396389999999997,9187.5062505162623,2.8,0.4,31.634464639999994,0.35,74,null,"","Sundridge",45.769030000000001,79.396389999999997,9187.5062505162623,31.634464639999994,0.35,74]
["","Tavistock",43.32159,80.835750000000004,9267.6883002197374,2.1,0.4,25.39668288,0.45,84,null,"","Tavistock",43.32159,80.835750000000004,9267.6883002197374,25.39668288,0.45,84]
["","Temagami",47.064500000000002,79.790940000000006,9236.4811532522272,2.6,0.4,29.852241280000001,0.37,76,null,"","Temagami",47.064500000000002,79.790940000000006,9236.4811532522272,29.852241280000001,0.37,76]
["","Thamesford",43.05789,80.999480000000005,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C216))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C216))*COS(RADIANS(D216-ABS(LONG))))*6371","v":9277.694218949784},1.9,0.4,23.614459520000004,0.48,87,null,"","Thamesford",43.05789,80.999480000000005,9277.694218949784,23.614459520000004,0.48,87]
[{"$f":"IF(E217=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Thedford",43.165430000000001,81.854659999999996,9347.973010391046,2.1,0.4,{"$f":"0.8*((F217*0.8*2/3+G217)*20.88543)","v":25.39668288},0.5,88,null,{"$f":"IF(P217=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B217","v":"Thedford"},{"$f":"C217","v":43.165430000000001},{"$f":"D217","v":81.854659999999996},{"$f":"IF(A217<>\"yes\",E217,\"\")","v":9347.973010391046},{"$f":"H217","v":25.39668288},0.5,88]
["","Thunder Bay",48.380899999999997,89.247680000000003,9951.983245289317,2.9,0.4,32.525576319999999,0.39,{"$f":"ROUNDUP(SQRT(2*I218/0.00064645)*2.236936141,0)","v":78},null,"","Thunder Bay",48.380899999999997,89.247680000000003,9951.983245289317,32.525576319999999,0.39,{"$f":"ROUNDUP(SQRT(2*R218/0.00064645)*2.236936141,0)","v":78}]
["","Tillsonburg",42.86589,80.733320000000006,9253.8394558393175,1.3,0.4,18.267789439999998,0.44,83,null,"","Tillsonburg",42.86589,80.733320000000006,9253.8394558393175,18.267789439999998,0.44,83]
["","Timmins",48.475819999999999,81.330500000000001,9369.841612046399,3.1,0.3,32.636965280000005,0.35,74,null,"","Timmins",48.475819999999999,81.330500000000001,9369.841612046399,32.636965280000005,0.35,74]
["","Toronto",43.653230000000001,79.383179999999996,9155.7328128439985,0.9,0.4,14.703342720000002,0.44,83,null,"","Toronto",43.653230000000001,79.383179999999996,9155.7328128439985,14.703342720000002,0.44,83]
["","Trenton",44.101129999999998,77.576310000000007,9019.3031795386723,1.6,0.4,20.941124480000003,0.47,86,null,"","Trenton",44.101129999999998,77.576310000000007,9019.3031795386723,20.941124480000003,0.47,86]
["","Trout Creek",45.986890000000002,79.359549999999999,9187.912093218567,2.7,0.4,30.743352960000006,0.35,74,null,"","Trout Creek",45.986890000000002,79.359549999999999,9187.912093218567,30.743352960000006,0.35,74]
["","Uxbridge",44.109400000000001,79.120500000000007,9141.4770705849878,2.4,0.4,28.070017920000005,0.42,81,null,"","Uxbridge",44.109400000000001,79.120500000000007,9141.4770705849878,28.070017920000005,0.42,81]
["","Vaughan",43.837209999999999,79.508279999999999,9168.3136336712996,1.1000000000000001,0.4,16.485566080000002,0.44,83,null,"","Vaughan",43.837209999999999,79.508279999999999,9168.3136336712996,16.485566080000002,0.44,83]
["","Vittoria",42.7624,80.32302,9219.2885826319889,1.3,0.4,18.267789439999998,0.47,86,null,"","Vittoria",42.7624,80.32302,9219.2885826319889,18.267789439999998,0.47,86]
["","Walkerton",44.131300000000003,81.150720000000007,9302.6521786869034,2.7,0.4,30.743352960000006,0.5,88,null,"","Walkerton",44.131300000000003,81.150720000000007,9302.6521786869034,30.743352960000006,0.5,88]
["","Wallaceburg",42.592640000000003,82.388249999999999,9385.288469019777,0.9,0.4,14.703342720000002,0.45,84,null,"","Wallaceburg",42.592640000000003,82.388249999999999,9385.288469019777,14.703342720000002,0.45,84]
["","Waterloo",43.464260000000003,80.520409999999998,9244.1468204912799,2,0.4,24.505571200000002,0.37,76,null,"","Waterloo",43.464260000000003,80.520409999999998,9244.1468204912799,24.505571200000002,0.37,76]
["","Watford",42.94876,81.876300000000001,9347.3828978133461,1.9,0.4,23.614459520000004,0.47,86,null,"","Watford",42.94876,81.876300000000001,9347.3828978133461,23.614459520000004,0.47,86]
["","Wawa",47.99239,84.771010000000004,9618.7272245255535,3.4,0.4,36.98113472,0.39,78,null,"","Wawa",47.99239,84.771010000000004,9618.7272245255535,36.98113472,0.39,78]
["","Welland",42.992159999999998,79.248260000000002,9135.472518534616,2,0.4,24.505571200000002,0.43,82,null,"","Welland",42.992159999999998,79.248260000000002,9135.472518534616,24.505571200000002,0.43,82]
["","West Lorne",42.60378,81.606650000000002,9321.7177352623639,1.3,0.4,18.267789439999998,0.47,86,null,"","West Lorne",42.60378,81.606650000000002,9321.7177352623639,18.267789439999998,0.47,86]
["","Whitby",43.897539999999999,78.942930000000004,9124.2582568575344,1.2,0.4,17.376677760000003,0.48,87,null,"","Whitby",43.897539999999999,78.942930000000004,9124.2582568575344,17.376677760000003,0.48,87]
["","White River",48.59395,85.274810000000002,9660.2590086068431,3.6,0.4,38.76335808000001,0.3,69,null,"","White River",48.59395,85.274810000000002,9660.2590086068431,38.76335808000001,0.3,69]
["","Wiarton",44.741970000000002,81.140829999999994,9309.2336421140499,2.7,0.4,30.743352960000006,0.48,87,null,"","Wiarton",44.741970000000002,81.140829999999994,9309.2336421140499,30.743352960000006,0.48,87]
["","Windsor",42.279609999999998,83.008529999999993,9433.0041223459702,0.8,0.4,13.81223104,0.47,86,null,"","Windsor",42.279609999999998,83.008529999999993,9433.0041223459702,13.81223104,0.47,86]
["","Wingham",43.887949999999996,81.311660000000003,9312.5664349778999,2.6,0.4,29.852241280000001,0.5,88,null,"","Wingham",43.887949999999996,81.311660000000003,9312.5664349778999,29.852241280000001,0.5,88]
["","Woodstock",43.131500000000003,80.747169999999997,9258.222634259384,1.9,0.4,23.614459520000004,0.44,83,null,"","Woodstock",43.131500000000003,80.747169999999997,9258.222634259384,23.614459520000004,0.44,83]
["","Wyoming",42.948869999999999,82.118780000000001,9367.0297146679804,1.6,0.4,20.941124480000003,0.47,86,null,"","Wyoming",42.948869999999999,82.118780000000001,9367.0297146679804,20.941124480000003,0.47,86]
["","Acton-Vale",45.65,72.566699999999997,8663.319898699443,2.2999999999999998,0.4,27.17890624,0.35,74,null,"","Acton-Vale",45.65,72.566699999999997,8663.319898699443,27.17890624,0.35,74]
["","Alma",48.550460000000001,71.652770000000004,8670.2287477409063,3.3,0.4,36.090023039999998,0.35,74,null,"","Alma",48.550460000000001,71.652770000000004,8670.2287477409063,36.090023039999998,0.35,74]
["","Amos",48.565019999999997,78.112520000000004,9136.3477492480033,3.2,0.3,33.528076960000007,0.32,71,null,"","Amos",48.565019999999997,78.112520000000004,9136.3477492480033,33.528076960000007,0.32,71]
["","Asbestos",45.774099999999997,71.936719999999994,8618.7234952573017,2.8,0.6,34.976133439999998,0.35,74,null,"","Asbestos",45.774099999999997,71.936719999999994,8618.7234952573017,34.976133439999998,0.35,74]
["","Aylmer",45.394509999999997,75.843959999999996,8907.9514479850732,2.5,0.4,28.9611296,0.41,80,null,"","Aylmer",45.394509999999997,75.843959999999996,8907.9514479850732,28.9611296,0.41,80]
["","Baie-Comeau",49.221299999999999,68.150390000000002,8443.2100448146757,4.3,0.4,45.001139840000008,0.5,88,null,"","Baie-Comeau",49.221299999999999,68.150390000000002,8443.2100448146757,45.001139840000008,0.5,88]
["","Baie-Saint-Paul",47.442410000000002,70.504080000000002,8556.990860266631,3.4,0.6,40.322803520000008,0.48,87,null,"","Baie-Saint-Paul",47.442410000000002,70.504080000000002,8556.990860266631,40.322803520000008,0.48,87]
["","Beauport",46.861559999999997,71.188680000000005,8591.2192248144402,3.4,0.6,40.322803520000008,0.42,81,null,"","Beauport",46.861559999999997,71.188680000000005,8591.2192248144402,40.322803520000008,0.42,81]
["","Bedford",45.121110000000002,72.987449999999995,8682.7339585495356,2.1,0.4,25.39668288,0.41,80,null,"","Bedford",45.121110000000002,72.987449999999995,8682.7339585495356,25.39668288,0.41,80]
["","Beloeil",45.567920000000001,73.203950000000006,8709.7698442411129,2.4,0.4,28.070017920000005,0.37,76,null,"","Beloeil",45.567920000000001,73.203950000000006,8709.7698442411129,28.070017920000005,0.37,76]
["","Brome",45.194049999999997,72.5715,8652.6203582241542,2.5,0.4,28.9611296,0.37,76,null,"","Brome",45.194049999999997,72.5715,8652.6203582241542,28.9611296,0.37,76]
["","Brossard",45.454709999999999,73.470659999999995,8727.4656004069657,2.4,0.4,28.070017920000005,0.42,81,null,"","Brossard",45.454709999999999,73.470659999999995,8727.4656004069657,28.070017920000005,0.42,81]
["","Buckingham",45.586410000000001,75.416870000000003,8879.0366327322336,2.6,0.4,29.852241280000001,0.4,79,null,"","Buckingham",45.586410000000001,75.416870000000003,8879.0366327322336,29.852241280000001,0.4,79]
["","Campbell's Bay",45.733739999999997,76.597250000000003,8972.2210742908737,2.6,0.4,29.852241280000001,0.32,71,null,"","Campbell's Bay",45.733739999999997,76.597250000000003,8972.2210742908737,29.852241280000001,0.32,71]
["","Chambly",45.439160000000001,73.29025,8713.3398674060045,2.2999999999999998,0.4,27.17890624,0.4,79,null,"","Chambly",45.439160000000001,73.29025,8713.3398674060045,27.17890624,0.4,79]
["","Coaticook",45.133690000000001,71.80395,8592.4562181662222,2.2999999999999998,0.6,30.520575040000001,0.35,74,null,"","Coaticook",45.133690000000001,71.80395,8592.4562181662222,30.520575040000001,0.35,74]
["","Contrecoeur",45.852640000000001,73.23433,8718.7556703843329,2.8,0.4,31.634464639999994,0.43,82,null,"","Contrecoeur",45.852640000000001,73.23433,8718.7556703843329,31.634464639999994,0.43,82]
["","Cowansville",45.206290000000003,72.747140000000002,8666.3506003738366,2.2999999999999998,0.4,27.17890624,0.41,80,null,"","Cowansville",45.206290000000003,72.747140000000002,8666.3506003738366,27.17890624,0.41,80]
["","Deux-Montagnes",45.541809999999998,73.893209999999996,8761.6834004752054,2.4,0.4,28.070017920000005,0.37,76,null,"","Deux-Montagnes",45.541809999999998,73.893209999999996,8761.6834004752054,28.070017920000005,0.37,76]
["","Dolbeau",48.877310000000001,72.22672,8719.7779185835971,3.5,0.3,36.201412000000005,0.35,74,null,"","Dolbeau",48.877310000000001,72.22672,8719.7779185835971,36.201412000000005,0.35,74]
["","Drummondville",45.880290000000002,72.484279999999998,8662.7175966141331,2.5,0.4,28.9611296,0.35,74,null,"","Drummondville",45.880290000000002,72.484279999999998,8662.7175966141331,28.9611296,0.35,74]
["","Farnham",45.28313,72.974810000000005,8685.590086200149,2.5,0.4,28.9611296,0.37,76,null,"","Farnham",45.28313,72.974810000000005,8685.590086200149,28.9611296,0.37,76]
["","Fort-Coulonge",45.841540000000002,76.73836,8985.0153368536303,2.5,0.4,28.9611296,0.32,71,null,"","Fort-Coulonge",45.841540000000002,76.73836,8985.0153368536303,28.9611296,0.32,71]
["","Gagnon",51.871099999999998,68.111099999999993,8527.7727139385952,4.5999999999999996,0.4,47.674474879999998,0.39,78,null,"","Gagnon",51.871099999999998,68.111099999999993,8527.7727139385952,47.674474879999998,0.39,78]
["","Gaspe",48.83164,64.486900000000006,8176.051543740552,4.3,0.6,48.342808640000008,0.48,87,null,"","Gaspe",48.83164,64.486900000000006,8176.051543740552,48.342808640000008,0.48,87]
["","Gatineau",45.47654,75.701269999999994,8898.6165999663917,2.5,0.4,28.9611296,0.41,80,null,"","Gatineau",45.47654,75.701269999999994,8898.6165999663917,28.9611296,0.41,80]
["","Gracefield",46.09272,76.053299999999993,8937.6396198428665,2.6,0.4,29.852241280000001,0.32,71,null,"","Gracefield",46.09272,76.053299999999993,8937.6396198428665,29.852241280000001,0.32,71]
["","Granby",45.403230000000001,72.734070000000003,8670.0751200606119,2.2999999999999998,0.4,27.17890624,0.35,74,null,"","Granby",45.403230000000001,72.734070000000003,8670.0751200606119,27.17890624,0.35,74]
["","Harrington-Harbour",50.5,59.483330000000002,7912.1796872923778,4.9000000000000004,0.6,53.689478720000011,0.72,106,null,"","Harrington-Harbour",50.5,59.483330000000002,7912.1796872923778,53.689478720000011,0.72,106]
["","Havre-St-Pierre",50.241810000000001,63.598570000000002,8170.4024112206935,4.0999999999999996,0.6,46.560585279999998,0.63,99,null,"","Havre-St-Pierre",50.241810000000001,63.598570000000002,8170.4024112206935,46.560585279999998,0.63,99]
["","Hemmingford",45.047499999999999,73.584450000000004,8726.8773420396938,2.4,0.4,28.070017920000005,0.4,79,null,"","Hemmingford",45.047499999999999,73.584450000000004,8726.8773420396938,28.070017920000005,0.4,79]
["","Hull",45.428730000000002,75.713369999999998,8898.5955637280258,2.4,0.4,28.070017920000005,0.41,80,null,"","Hull",45.428730000000002,75.713369999999998,8898.5955637280258,28.070017920000005,0.41,80]
["","Iberville",45.308149999999998,73.236140000000006,8706.1580915381692,2.2000000000000002,0.4,26.287794560000005,0.41,80,null,"","Iberville",45.308149999999998,73.236140000000006,8706.1580915381692,26.287794560000005,0.41,80]
["","Inukjuak",58.455120000000001,78.105099999999993,9319.1976683077955,4.0999999999999996,0.2,39.877247680000004,0.6,97,null,"","Inukjuak",58.455120000000001,78.105099999999993,9319.1976683077955,39.877247680000004,0.6,97]
["","Joliette",46.023220000000002,73.439239999999998,8738.2353019362654,3.1,0.4,34.307799680000009,0.36,75,null,"","Joliette",46.023220000000002,73.439239999999998,8738.2353019362654,34.307799680000009,0.36,75]
["","Kuujjuaq",58.103000000000002,68.418840000000003,8761.3882884786617,4.8,0.2,46.115029440000001,0.6,97,null,"","Kuujjuaq",58.103000000000002,68.418840000000003,8761.3882884786617,46.115029440000001,0.6,97]
["","Kuujjuarapik",55.274569999999997,77.763779999999997,9236.4792912851972,4.2,0.3,42.439193760000002,0.55000000000000004,93,null,"","Kuujjuarapik",55.274569999999997,77.763779999999997,9236.4792912851972,42.439193760000002,0.55000000000000004,93]
["","La Pocatiere",47.364879999999999,70.033670000000001,8520.5601331876715,3.2,0.6,38.540580160000012,0.5,88,null,"","La Pocatiere",47.364879999999999,70.033670000000001,8520.5601331876715,38.540580160000012,0.5,88]
["","La-Malbaie",47.656970000000001,70.152190000000004,8537.5399154888673,3.1,0.6,37.649468480000003,0.48,87,null,"","La-Malbaie",47.656970000000001,70.152190000000004,8537.5399154888673,37.649468480000003,0.48,87]
["","La-Tuque",47.438339999999997,72.783929999999998,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C280))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C280))*COS(RADIANS(D280-ABS(LONG))))*6371","v":8723.4358734223133},3.4,0.4,36.98113472,0.35,74,null,"","La-Tuque",47.438339999999997,72.783929999999998,8723.4358734223133,36.98113472,0.35,74]
[{"$f":"IF(E281=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Lac-Megantic",45.580129999999997,70.888099999999994,8534.4698068614543,3.2,0.6,{"$f":"0.8*((F281*0.8*2/3+G281)*20.88543)","v":38.540580160000012},0.35,74,null,{"$f":"IF(P281=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B281","v":"Lac-Megantic"},{"$f":"C281","v":45.580129999999997},{"$f":"D281","v":70.888099999999994},{"$f":"IF(A281<>\"yes\",E281,\"\")","v":8534.4698068614543},{"$f":"H281","v":38.540580160000012},0.35,74]
["","Lachute",45.652059999999999,74.339799999999997,8798.1752679238107,2.4,0.4,28.070017920000005,0.4,{"$f":"ROUNDUP(SQRT(2*I282/0.00064645)*2.236936141,0)","v":79},null,"","Lachute",45.652059999999999,74.339799999999997,8798.1752679238107,28.070017920000005,0.4,{"$f":"ROUNDUP(SQRT(2*R282/0.00064645)*2.236936141,0)","v":79}]
["","Lennoxville",45.367730000000002,71.856359999999995,8602.3593438912449,2.1,0.6,28.738351680000008,0.32,71,null,"","Lennoxville",45.367730000000002,71.856359999999995,8602.3593438912449,28.738351680000008,0.32,71]
["","Lery",45.35,73.8,8750.2507411497736,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Lery",45.35,73.8,8750.2507411497736,27.17890624,0.42,81]
["","Loretteville",46.855029999999999,71.360749999999996,8603.7456176595297,3.7,0.6,42.996138560000006,0.41,80,null,"","Loretteville",46.855029999999999,71.360749999999996,8603.7456176595297,42.996138560000006,0.41,80]
["","Louiseville",46.255989999999997,72.943219999999997,8706.402392058757,2.9,0.4,32.525576319999999,0.43,82,null,"","Louiseville",46.255989999999997,72.943219999999997,8706.402392058757,32.525576319999999,0.43,82]
["","Magog",45.266489999999997,72.147989999999993,8622.0432925406003,2.2999999999999998,0.4,27.17890624,0.35,74,null,"","Magog",45.266489999999997,72.147989999999993,8622.0432925406003,27.17890624,0.35,74]
["","Malartic",48.136620000000001,78.127089999999995,9130.0140418707851,3.3,0.3,34.419188640000002,0.32,71,null,"","Malartic",48.136620000000001,78.127089999999995,9130.0140418707851,34.419188640000002,0.32,71]
["","Maniwaki",46.377519999999997,75.964749999999995,8936.5449115448955,2.4,0.4,28.070017920000005,0.31,70,null,"","Maniwaki",46.377519999999997,75.964749999999995,8936.5449115448955,28.070017920000005,0.31,70]
["","Masson",45.549799999999998,75.417850000000001,8878.3681012533234,2.4,0.4,28.070017920000005,0.4,79,null,"","Masson",45.549799999999998,75.417850000000001,8878.3681012533234,28.070017920000005,0.4,79]
["","Matane",48.844520000000003,67.53058,8387.7061112542633,3.7,0.4,39.654469760000005,0.6,97,null,"","Matane",48.844520000000003,67.53058,8387.7061112542633,39.654469760000005,0.6,97]
["","Mont-Joli",48.585610000000003,68.190100000000001,8425.561125002625,4.0999999999999996,0.4,43.218916479999997,0.52,90,null,"","Mont-Joli",48.585610000000003,68.190100000000001,8425.561125002625,43.218916479999997,0.52,90]
["","Mont-Laurier",46.552700000000002,75.49736,8904.8725056696603,2.6,0.4,29.852241280000001,0.3,69,null,"","Mont-Laurier",46.552700000000002,75.49736,8904.8725056696603,29.852241280000001,0.3,69]
["","Montmagny",46.9801,70.556569999999994,8547.9192119611962,2.9,0.6,35.86724512,0.47,86,null,"","Montmagny",46.9801,70.556569999999994,8547.9192119611962,35.86724512,0.47,86]
["","Beaconsfield",45.430929999999996,73.868279999999999,8757.291411727776,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Beaconsfield",45.430929999999996,73.868279999999999,8757.291411727776,27.17890624,0.42,81]
["","Dorval",45.45,73.75,8748.6841785320594,2.4,0.4,28.070017920000005,0.42,81,null,"","Dorval",45.45,73.75,8748.6841785320594,28.070017920000005,0.42,81]
["","Laval",45.606650000000002,73.712410000000006,8749.3687110973406,2.6,0.4,29.852241280000001,0.42,81,null,"","Laval",45.606650000000002,73.712410000000006,8749.3687110973406,29.852241280000001,0.42,81]
["","Montreal",45.508670000000002,73.553989999999999,8735.0612059463438,2.6,0.4,29.852241280000001,0.42,81,null,"","Montreal",45.508670000000002,73.553989999999999,8735.0612059463438,29.852241280000001,0.42,81]
["","Outremont",45.513770000000001,73.605710000000002,8739.1217899732292,2.8,0.4,31.634464639999994,0.42,81,null,"","Outremont",45.513770000000001,73.605710000000002,8739.1217899732292,31.634464639999994,0.42,81]
["","Pierrefonds",45.484870000000001,73.853110000000001,8757.3441639067059,2.4,0.4,28.070017920000005,0.42,81,null,"","Pierrefonds",45.484870000000001,73.853110000000001,8757.3441639067059,28.070017920000005,0.42,81]
["","St-Lambert",45.49203,73.504180000000005,8730.8809095752131,2.5,0.4,28.9611296,0.42,81,null,"","St-Lambert",45.49203,73.504180000000005,8730.8809095752131,28.9611296,0.42,81]
["","St-Laurent",45.517000000000003,73.667000000000002,8743.8694610790662,2.5,0.4,28.9611296,0.42,81,null,"","St-Laurent",45.517000000000003,73.667000000000002,8743.8694610790662,28.9611296,0.42,81]
["","Ste-Anne-de-Bellevue",45.403280000000002,73.950360000000003,8762.9481197248733,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Ste-Anne-de-Bellevue",45.403280000000002,73.950360000000003,8762.9481197248733,27.17890624,0.42,81]
["","Verdun",45.454830000000001,73.569869999999995,8735.0402826135523,2.5,0.4,28.9611296,0.42,81,null,"","Verdun",45.454830000000001,73.569869999999995,8735.0402826135523,28.9611296,0.42,81]
["","Nicolet (Gentilly)",46.227409999999999,72.619169999999997,8681.3891676731764,2.8,0.4,31.634464639999994,0.42,81,null,"","Nicolet (Gentilly)",46.227409999999999,72.619169999999997,8681.3891676731764,31.634464639999994,0.42,81]
["","Nitchequon",53.194769999999998,70.910709999999995,8751.1499364926676,3.5,0.3,36.201412000000005,0.37,76,null,"","Nitchequon",53.194769999999998,70.910709999999995,8751.1499364926676,36.201412000000005,0.37,76]
["","Noranda",48.247010000000003,79.028199999999998,9197.8932187653736,3.2,0.3,33.528076960000007,0.35,74,null,"","Noranda",48.247010000000003,79.028199999999998,9197.8932187653736,33.528076960000007,0.35,74]
["","Perce",48.524439999999998,64.212680000000006,8145.523747421048,3.8,0.6,43.887250240000007,0.72,106,null,"","Perce",48.524439999999998,64.212680000000006,8145.523747421048,43.887250240000007,0.72,106]
["","Pincourt",45.366390000000003,73.984620000000007,8764.7473824427689,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Pincourt",45.366390000000003,73.984620000000007,8764.7473824427689,27.17890624,0.42,81]
["","Plessisville",46.219450000000002,71.771379999999994,8617.6549471792241,2.8,0.6,34.976133439999998,0.35,74,null,"","Plessisville",46.219450000000002,71.771379999999994,8617.6549471792241,34.976133439999998,0.35,74]
["","Port-Cartier",50.021250000000002,66.876000000000005,8382.4111923674645,4.0999999999999996,0.4,43.218916479999997,0.54,92,null,"","Port-Cartier",50.021250000000002,66.876000000000005,8382.4111923674645,43.218916479999997,0.54,92]
["","Puvirnituq",60.037120000000002,77.269229999999993,9304.9189701653213,4.5,0.2,43.441694400000003,0.6,97,null,"","Puvirnituq",60.037120000000002,77.269229999999993,9304.9189701653213,43.441694400000003,0.6,97]
["","L'Ancienne-Lorette",46.798940000000002,71.361559999999997,8602.3156845759149,3.4,0.6,40.322803520000008,0.41,80,null,"","L'Ancienne-Lorette",46.798940000000002,71.361559999999997,8602.3156845759149,40.322803520000008,0.41,80]
["","Levis",46.740400000000001,71.236339999999998,8591.4975372645113,3.3,0.6,39.431691839999999,0.41,80,null,"","Levis",46.740400000000001,71.236339999999998,8591.4975372645113,39.431691839999999,0.41,80]
["","Quebec",46.803280999999998,71.242699999999999,8593.6474727995083,3.6,0.6,42.105026879999997,0.41,80,null,"","Quebec",46.803280999999998,71.242699999999999,8593.6474727995083,42.105026879999997,0.41,80]
["","Sillery",46.770809999999997,71.265420000000006,8594.4597622749989,3.1,0.6,37.649468480000003,0.41,80,null,"","Sillery",46.770809999999997,71.265420000000006,8594.4597622749989,37.649468480000003,0.41,80]
["","Ste-Foy",46.792720000000003,71.402640000000005,8605.1876979456647,3.7,0.6,42.996138560000006,0.41,80,null,"","Ste-Foy",46.792720000000003,71.402640000000005,8605.1876979456647,42.996138560000006,0.41,80]
["","Richmond QC",45.665819999999997,72.147919999999999,8631.9736691363523,2.4,0.6,31.411686720000002,0.32,71,null,"","Richmond QC",45.665819999999997,72.147919999999999,8631.9736691363523,31.411686720000002,0.32,71]
["","Rimouski",48.433329999999998,68.516670000000005,8443.7957730102462,3.8,0.4,40.545581440000007,0.52,90,null,"","Rimouski",48.433329999999998,68.516670000000005,8443.7957730102462,40.545581440000007,0.52,90]
["","Riviere-du-Loup",47.83596,69.535989999999998,8498.2973814332545,3.5,0.6,41.213915200000002,0.5,88,null,"","Riviere-du-Loup",47.83596,69.535989999999998,8498.2973814332545,41.213915200000002,0.5,88]
["","Roberval",48.51876,72.221999999999994,8710.1058596393141,3.5,0.3,36.201412000000005,0.35,74,null,"","Roberval",48.51876,72.221999999999994,8710.1058596393141,36.201412000000005,0.35,74]
["","Rock-Island",45.016666999999998,72.099999999999994,8612.1827770279087,2,0.4,24.505571200000002,0.35,74,null,"","Rock-Island",45.016666999999998,72.099999999999994,8612.1827770279087,24.505571200000002,0.35,74]
["","Rosemere",45.63897,73.78501,8755.6289569070887,2.6,0.4,29.852241280000001,0.4,79,null,"","Rosemere",45.63897,73.78501,8755.6289569070887,29.852241280000001,0.4,79]
["","Rouyn",48.23424,79.018780000000007,9196.9994745192071,3.1,0.3,32.636965280000005,0.35,74,null,"","Rouyn",48.23424,79.018780000000007,9196.9994745192071,32.636965280000005,0.35,74]
["","Saguenay",48.428049999999999,71.068489999999997,8625.1478236939638,2.7,0.4,30.743352960000006,0.36,75,null,"","Saguenay",48.428049999999999,71.068489999999997,8625.1478236939638,30.743352960000006,0.36,75]
["","Bagotville",48.330599999999997,70.996899999999997,8617.3303723050394,2.7,0.4,30.743352960000006,0.38,77,null,"","Bagotville",48.330599999999997,70.996899999999997,8617.3303723050394,30.743352960000006,0.38,77]
["","Jonquiere",48.4236,71.239549999999994,8637.2551358584042,3.1,0.4,34.307799680000009,0.35,74,null,"","Jonquiere",48.4236,71.239549999999994,8637.2551358584042,34.307799680000009,0.35,74]
["","Kenogami",48.428199999999997,71.230720000000005,8636.7496646382224,3.1,0.4,34.307799680000009,0.35,74,null,"","Kenogami",48.428199999999997,71.230720000000005,8636.7496646382224,34.307799680000009,0.35,74]
["","Saint-Eustache",45.558549999999997,73.896079999999998,8762.278051077983,2.4,0.4,28.070017920000005,0.37,76,null,"","Saint-Eustache",45.558549999999997,73.896079999999998,8762.278051077983,28.070017920000005,0.37,76]
["","Saint-Jean-sur-Richelieu",45.305770000000003,73.254490000000004,8707.5059801045081,2.2000000000000002,0.4,26.287794560000005,0.41,80,null,"","Saint-Jean-sur-Richelieu",45.305770000000003,73.254490000000004,8707.5059801045081,26.287794560000005,0.41,80]
["","Salaberry-de-Valleyfield",45.25009,74.133089999999996,8773.5524817491587,2.2999999999999998,0.4,27.17890624,0.42,81,null,"","Salaberry-de-Valleyfield",45.25009,74.133089999999996,8773.5524817491587,27.17890624,0.42,81]
["","Schefferville",54.800690000000003,66.810770000000005,8548.7568786656539,4.5,0.3,45.1125288,0.42,81,null,"","Schefferville",54.800690000000003,66.810770000000005,8548.7568786656539,45.1125288,0.42,81]
["","Senneterre",48.390599999999999,77.241169999999997,9069.8306871048226,3.3,0.3,34.419188640000002,0.32,71,null,"","Senneterre",48.390599999999999,77.241169999999997,9069.8306871048226,34.419188640000002,0.32,71]
["","Sept-Iles",50.213299999999997,66.375789999999995,8355.2818256676128,4.0999999999999996,0.4,43.218916479999997,0.54,92,null,"","Sept-Iles",50.213299999999997,66.375789999999995,8355.2818256676128,43.218916479999997,0.54,92]
["","Shawinigan",46.561860000000003,72.743530000000007,8698.8829056223713,3.1,0.4,34.307799680000009,0.35,74,null,"","Shawinigan",46.561860000000003,72.743530000000007,8698.8829056223713,34.307799680000009,0.35,74]
["","Shawville",45.603659999999998,76.491460000000004,8961.6786018281437,2.8,0.4,31.634464639999994,0.35,74,null,"","Shawville",45.603659999999998,76.491460000000004,8961.6786018281437,31.634464639999994,0.35,74]
["","Sherbrooke",45.40099,71.882429999999999,8605.1817169517926,2.2000000000000002,0.6,29.629463360000003,0.32,71,null,"","Sherbrooke",45.40099,71.882429999999999,8605.1817169517926,29.629463360000003,0.32,71]
["","Sorel",46.042830000000002,73.112300000000005,8714.0279367692456,2.8,0.4,31.634464639999994,0.43,82,null,"","Sorel",46.042830000000002,73.112300000000005,8714.0279367692456,31.634464639999994,0.43,82]
["","St-Felicien",48.651710000000001,72.448980000000006,8729.7789527864552,3.5,0.3,36.201412000000005,0.35,74,null,"","St-Felicien",48.651710000000001,72.448980000000006,8729.7789527864552,36.201412000000005,0.35,74]
["","St-Georges-de-Cacouna",47.945439999999998,69.492630000000005,8498.4333328965931,3.2,0.6,38.540580160000012,0.5,88,null,"","St-Georges-de-Cacouna",47.945439999999998,69.492630000000005,8498.4333328965931,38.540580160000012,0.5,88]
["","St-Hubert",47.81362,69.152109999999993,8470.0269598685318,2.5,0.4,28.9611296,0.42,81,null,"","St-Hubert",47.81362,69.152109999999993,8470.0269598685318,28.9611296,0.42,81]
["","St-Hyacinthe",45.630690000000001,72.956339999999997,8692.4276554742319,2.2999999999999998,0.4,27.17890624,0.35,74,null,"","St-Hyacinthe",45.630690000000001,72.956339999999997,8692.4276554742319,27.17890624,0.35,74]
["","St-Jerome",45.775359999999999,74.004949999999994,8775.4233321095617,2.7,0.4,30.743352960000006,0.37,76,null,"","St-Jerome",45.775359999999999,74.004949999999994,8775.4233321095617,30.743352960000006,0.37,76]
["","St-Jovite",46.153269999999999,74.583600000000004,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C344))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C344))*COS(RADIANS(D344-ABS(LONG))))*6371","v":8827.5878197759648},2.8,0.4,31.634464639999994,0.33,72,null,"","St-Jovite",46.153269999999999,74.583600000000004,8827.5878197759648,31.634464639999994,0.33,72]
[{"$f":"IF(E345=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"St-Lazare-Hudson",45.458539999999999,74.14067,8778.7261441544142,2.2999999999999998,0.4,{"$f":"0.8*((F345*0.8*2/3+G345)*20.88543)","v":27.17890624},0.42,81,null,{"$f":"IF(P345=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B345","v":"St-Lazare-Hudson"},{"$f":"C345","v":45.458539999999999},{"$f":"D345","v":74.14067},{"$f":"IF(A345<>\"yes\",E345,\"\")","v":8778.7261441544142},{"$f":"H345","v":27.17890624},0.42,81]
["","St-Nicolas",47.161949999999997,70.862359999999995,8575.3727479628469,3.5,0.6,41.213915200000002,0.42,81,null,"","St-Nicolas",47.161949999999997,70.862359999999995,8575.3727479628469,41.213915200000002,0.42,81]
["","Ste-Agathe-Des-Monts",46.048560000000002,74.281599999999997,8802.4670561600378,3.4,0.4,36.98113472,0.35,74,null,"","Ste-Agathe-Des-Monts",46.048560000000002,74.281599999999997,8802.4670561600378,36.98113472,0.35,74]
["","Sutton",45.105890000000002,72.616659999999996,8653.9506336526738,2.4,0.4,28.070017920000005,0.41,80,null,"","Sutton",45.105890000000002,72.616659999999996,8653.9506336526738,28.070017920000005,0.41,80]
["","Tadoussac",48.145980000000002,69.71284,8520.1544438274395,3.7,0.4,39.654469760000005,0.52,90,null,"","Tadoussac",48.145980000000002,69.71284,8520.1544438274395,39.654469760000005,0.52,90]
["","Temiscaming",46.718240000000002,79.100120000000004,9179.2764176813071,2.5,0.4,28.9611296,0.32,71,null,"","Temiscaming",46.718240000000002,79.100120000000004,9179.2764176813071,28.9611296,0.32,71]
["","Terrebonne",45.692979999999999,73.633110000000002,8745.3037865601473,2.6,0.4,29.852241280000001,0.4,79,null,"","Terrebonne",45.692979999999999,73.633110000000002,8745.3037865601473,29.852241280000001,0.4,79]
["","Thetford Mines",46.102829999999997,71.305549999999997,8579.739262045201,3.5,0.6,41.213915200000002,0.35,74,null,"","Thetford Mines",46.102829999999997,71.305549999999997,8579.739262045201,41.213915200000002,0.35,74]
["","Thurso",45.597189999999998,75.243269999999995,8865.979287478036,2.4,0.4,28.070017920000005,0.4,79,null,"","Thurso",45.597189999999998,75.243269999999995,8865.979287478036,28.070017920000005,0.4,79]
["","Trois-Rivieres",46.343240000000002,72.543279999999996,8678.5503331730542,2.8,0.4,31.634464639999994,0.43,82,null,"","Trois-Rivieres",46.343240000000002,72.543279999999996,8678.5503331730542,31.634464639999994,0.43,82]
["","Val-d'Or",48.098709999999997,77.796769999999995,9105.1354030978091,3.4,0.3,35.310300320000003,0.32,71,null,"","Val-d'Or",48.098709999999997,77.796769999999995,9105.1354030978091,35.310300320000003,0.32,71]
["","Varennes",45.67803,73.418490000000006,8728.6490386966088,2.6,0.4,29.852241280000001,0.4,79,null,"","Varennes",45.67803,73.418490000000006,8728.6490386966088,29.852241280000001,0.4,79]
["","Vercheres",45.773339999999997,73.35275,8725.8728746111774,2.7,0.4,30.743352960000006,0.43,82,null,"","Vercheres",45.773339999999997,73.35275,8725.8728746111774,30.743352960000006,0.43,82]
["","Victoriaville",46.055669999999999,71.958960000000005,8627.5356720549717,2.6,0.6,33.193910080000002,0.35,74,null,"","Victoriaville",46.055669999999999,71.958960000000005,8627.5356720549717,33.193910080000002,0.35,74]
["","Ville-Marie",47.332189999999997,79.436800000000005,9213.9308017874027,2.2999999999999998,0.4,27.17890624,0.4,79,null,"","Ville-Marie",47.332189999999997,79.436800000000005,9213.9308017874027,27.17890624,0.4,79]
["","Wakefield",45.631540000000001,75.923990000000003,8918.7436022873826,2.4,0.4,28.070017920000005,0.34,73,null,"","Wakefield",45.631540000000001,75.923990000000003,8918.7436022873826,28.070017920000005,0.34,73]
["","Waterloo",45.344079999999998,72.516400000000004,8652.0493101763404,2.5,0.4,28.9611296,0.35,{"$f":"ROUNDUP(SQRT(2*I361/0.00064645)*2.236936141,0)","v":74},null,"","Waterloo",45.344079999999998,72.516400000000004,8652.0493101763404,28.9611296,0.35,{"$f":"ROUNDUP(SQRT(2*R361/0.00064645)*2.236936141,0)","v":74}]
["","Windsor",45.568869999999997,72.005549999999999,8618.7573989362827,2.2999999999999998,0.4,27.17890624,0.32,71,null,"","Windsor",45.568869999999997,72.005549999999999,8618.7573989362827,27.17890624,0.32,71]
["","Alma",45.6038,64.94144,8090.9197974678209,2.6,0.6,33.193910080000002,0.48,87,null,"","Alma",45.6038,64.94144,8090.9197974678209,33.193910080000002,0.48,87]
["","Bathurst",47.61835,65.651340000000005,8213.3607464265351,4.0999999999999996,0.6,46.560585279999998,0.48,87,null,"","Bathurst",47.61835,65.651340000000005,8213.3607464265351,46.560585279999998,0.48,87]
["","Campbellton",48.007399999999997,66.672210000000007,8299.2678757694448,4.3,0.4,45.001139840000008,0.45,84,null,"","Campbellton",48.007399999999997,66.672210000000007,8299.2678757694448,45.001139840000008,0.45,84]
["","Edmundston",47.3765,68.325299999999999,8397.0170418491834,3.4,0.6,40.322803520000008,0.38,77,null,"","Edmundston",47.3765,68.325299999999999,8397.0170418491834,40.322803520000008,0.38,77]
["","Fredericton",45.963590000000003,66.643119999999996,8228.7821145434318,3.1,0.6,37.649468480000003,0.38,77,null,"","Fredericton",45.963590000000003,66.643119999999996,8228.7821145434318,37.649468480000003,0.38,77]
["","Gagetown",45.837800000000001,66.436700000000002,8209.3707790107801,2.8,0.6,34.976133439999998,0.4,79,null,"","Gagetown",45.837800000000001,66.436700000000002,8209.3707790107801,34.976133439999998,0.4,79]
["","Grand Falls",47.047989999999999,67.739900000000006,8344.2504637173806,3.6,0.6,42.105026879999997,0.38,77,null,"","Grand Falls",47.047989999999999,67.739900000000006,8344.2504637173806,42.105026879999997,0.38,77]
["","Miramichi",47.022500000000001,65.508889999999994,8182.1980454245786,3.4,0.6,40.322803520000008,0.41,80,null,"","Miramichi",47.022500000000001,65.508889999999994,8182.1980454245786,40.322803520000008,0.41,80]
["","Moncton",46.087820000000001,64.778229999999994,8096.112919655422,3,0.6,36.758356800000001,0.5,88,null,"","Moncton",46.087820000000001,64.778229999999994,8096.112919655422,36.758356800000001,0.5,88]
["","Oromocto",45.848660000000002,66.481290000000001,8213.0277384844467,3,0.6,36.758356800000001,0.39,78,null,"","Oromocto",45.848660000000002,66.481290000000001,8213.0277384844467,36.758356800000001,0.39,78]
["","Sackville",45.8979,64.368279999999999,8059.3140859636642,2.5,0.6,32.302798399999993,0.49,88,null,"","Sackville",45.8979,64.368279999999999,8059.3140859636642,32.302798399999993,0.49,88]
["","Saint Andrews",45.073839999999997,67.053089999999997,8230.4623710033484,2.8,0.6,34.976133439999998,0.45,84,null,"","Saint Andrews",45.073839999999997,67.053089999999997,8230.4623710033484,34.976133439999998,0.45,84]
["","Saint George",45.129010000000001,66.831360000000004,8215.5713027676193,2.8,0.6,34.976133439999998,0.45,84,null,"","Saint George",45.129010000000001,66.831360000000004,8215.5713027676193,34.976133439999998,0.45,84]
["","Saint John",45.273319999999998,66.063310000000001,8162.8239059506523,2.2999999999999998,0.6,30.520575040000001,0.53,91,null,"","Saint John",45.273319999999998,66.063310000000001,8162.8239059506523,30.520575040000001,0.53,91]
["","Shippagan",47.743929999999999,64.705690000000004,8150.8950362521782,3.4,0.6,40.322803520000008,0.63,99,null,"","Shippagan",47.743929999999999,64.705690000000004,8150.8950362521782,40.322803520000008,0.63,99]
["","St. Stephen",45.19417,67.275559999999999,8251.0111499954637,2.9,0.6,35.86724512,0.42,81,null,"","St. Stephen",45.19417,67.275559999999999,8251.0111499954637,35.86724512,0.42,81]
["","Woodstock",46.161589999999997,67.586429999999993,8304.8198048991871,3.1,0.6,37.649468480000003,0.37,76,null,"","Woodstock",46.161589999999997,67.586429999999993,8304.8198048991871,37.649468480000003,0.37,76]
["","Amherst",45.816670000000002,64.216719999999995,8045.2710200109632,2.4,0.6,31.411686720000002,0.48,87,null,"","Amherst",45.816670000000002,64.216719999999995,8045.2710200109632,31.411686720000002,0.48,87]
["","Antigonish",45.622599999999998,61.992800000000003,7875.6319148440898,2.2999999999999998,0.6,30.520575040000001,0.54,92,null,"","Antigonish",45.622599999999998,61.992800000000003,7875.6319148440898,30.520575040000001,0.54,92]
["","Bridgewater",44.372120000000002,64.520880000000005,8016.195503734687,1.9,0.6,26.956128320000001,0.55000000000000004,93,null,"","Bridgewater",44.372120000000002,64.520880000000005,8016.195503734687,26.956128320000001,0.55000000000000004,93]
["","Canso",45.336280000000002,60.994439999999997,7791.5500277280098,1.7,0.6,25.173904960000002,0.61,98,null,"","Canso",45.336280000000002,60.994439999999997,7791.5500277280098,25.173904960000002,0.61,98]
["","Debert",45.437719999999999,63.458300000000001,7975.6659862992565,2.1,0.6,28.738351680000008,0.48,87,null,"","Debert",45.437719999999999,63.458300000000001,7975.6659862992565,28.738351680000008,0.48,87]
["","Digby",44.62153,65.757549999999995,8118.0496613859659,2.2000000000000002,0.6,29.629463360000003,0.55000000000000004,93,null,"","Digby",44.62153,65.757549999999995,8118.0496613859659,29.629463360000003,0.55000000000000004,93]
["","Greenwood",44.971719999999998,64.934129999999996,8068.2122404919373,2.7,0.6,34.085021760000004,0.54,92,null,"","Greenwood",44.971719999999998,64.934129999999996,8068.2122404919373,34.085021760000004,0.54,92]
["","Dartmouth",44.665210000000002,63.567740000000001,7955.2046804171532,1.6,0.6,24.282793280000007,0.57999999999999996,95,null,"","Dartmouth",44.665210000000002,63.567740000000001,7955.2046804171532,24.282793280000007,0.57999999999999996,95]
["","Halifax",44.648859999999999,63.575319999999998,7955.171106176831,1.9,0.6,26.956128320000001,0.57999999999999996,95,null,"","Halifax",44.648859999999999,63.575319999999998,7955.171106176831,26.956128320000001,0.57999999999999996,95]
["","Kentville",45.076909999999998,64.494470000000007,8039.1466460023421,2.6,0.6,33.193910080000002,0.54,92,null,"","Kentville",45.076909999999998,64.494470000000007,8039.1466460023421,33.193910080000002,0.54,92]
["","Liverpool",44.032980000000002,64.717680000000001,8019.2470520705465,1.7,6,115.39896256,0.61,98,null,"","Liverpool",44.032980000000002,64.717680000000001,8019.2470520705465,115.39896256,0.61,98]
["","Lockeport",43.699779999999997,65.113799999999998,8038.0211064722034,1.4,0.6,22.500569920000004,0.6,97,null,"","Lockeport",43.699779999999997,65.113799999999998,8038.0211064722034,22.500569920000004,0.6,97]
["","Louisburg",45.922139999999999,59.971310000000003,7742.244473589144,2.1,0.7,30.409186080000001,0.65,101,null,"","Louisburg",45.922139999999999,59.971310000000003,7742.244473589144,30.409186080000001,0.65,101]
["","Lunenburg",44.377009999999999,64.318839999999994,8001.1405716577474,1.9,0.6,26.956128320000001,0.61,98,null,"","Lunenburg",44.377009999999999,64.318839999999994,8001.1405716577474,26.956128320000001,0.61,98]
["","New Glasgow",45.58717,62.645119999999999,7921.7659260280625,2.2000000000000002,0.6,29.629463360000003,0.55000000000000004,93,null,"","New Glasgow",45.58717,62.645119999999999,7921.7659260280625,29.629463360000003,0.55000000000000004,93]
["","North Sydney",46.206479999999999,60.252380000000002,7774.3725808076779,2.4,0.6,31.411686720000002,0.59,96,null,"","North Sydney",46.206479999999999,60.252380000000002,7774.3725808076779,31.411686720000002,0.59,96]
["","Pictou",45.67933,62.720599999999997,7930.8210700874806,2.2000000000000002,0.6,29.629463360000003,0.55000000000000004,93,null,"","Pictou",45.67933,62.720599999999997,7930.8210700874806,29.629463360000003,0.55000000000000004,93]
["","Port Hawkesbury",45.618180000000002,61.358969999999999,7829.4570388681086,2.1,0.6,28.738351680000008,0.74,108,null,"","Port Hawkesbury",45.618180000000002,61.358969999999999,7829.4570388681086,28.738351680000008,0.74,108]
["","Springhill",45.648650000000004,64.059960000000004,8027.6502536443841,3.1,0.6,37.649468480000003,0.48,87,null,"","Springhill",45.648650000000004,64.059960000000004,8027.6502536443841,37.649468480000003,0.48,87]
["","Stewiacke",45.137830000000001,63.349350000000001,7956.4575956965655,1.8,0.6,26.06501664,0.5,88,null,"","Stewiacke",45.137830000000001,63.349350000000001,7956.4575956965655,26.06501664,0.5,88]
["","Sydney",46.136789999999998,60.194220000000001,7767.2762543009676,2.2999999999999998,0.6,30.520575040000001,0.59,96,null,"","Sydney",46.136789999999998,60.194220000000001,7767.2762543009676,30.520575040000001,0.59,96]
["","Tatamagouche",45.709200000000003,63.29419,7973.8141550176142,2.2000000000000002,0.6,29.629463360000003,0.55000000000000004,93,null,"","Tatamagouche",45.709200000000003,63.29419,7973.8141550176142,29.629463360000003,0.55000000000000004,93]
["","Truro",45.365769999999998,63.286940000000001,7960.3762945348335,2,0.6,27.847239999999999,0.48,87,null,"","Truro",45.365769999999998,63.286940000000001,7960.3762945348335,27.847239999999999,0.48,87]
["","Wolfville",45.091760000000001,64.359840000000005,8029.6658708330633,2.6,0.6,33.193910080000002,0.54,92,null,"","Wolfville",45.091760000000001,64.359840000000005,8029.6658708330633,33.193910080000002,0.54,92]
["","Yarmouth",43.83746,66.117379999999997,8119.4951132416591,1.8,0.6,26.06501664,0.56000000000000005,94,null,"","Yarmouth",43.83746,66.117379999999997,8119.4951132416591,26.06501664,0.56000000000000005,94]
["","Charlottetown",46.238239999999998,63.131070000000001,7982.0376648622778,2.7,0.6,34.085021760000004,0.56000000000000005,94,null,"","Charlottetown",46.238239999999998,63.131070000000001,7982.0376648622778,34.085021760000004,0.56000000000000005,94]
["","Souris",46.354979999999998,62.251829999999998,7923.2928717425229,2.7,0.6,34.085021760000004,0.57999999999999996,95,null,"","Souris",46.354979999999998,62.251829999999998,7923.2928717425229,34.085021760000004,0.57999999999999996,95]
["","Summerside",46.393380000000001,63.790230000000001,8035.5109265465207,3.1,0.6,37.649468480000003,0.6,97,null,"","Summerside",46.393380000000001,63.790230000000001,8035.5109265465207,37.649468480000003,0.6,97]
["","Tignish",46.950490000000002,64.03304,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C408))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C408))*COS(RADIANS(D408-ABS(LONG))))*6371","v":8073.7485632868929},3.2,0.6,38.540580160000012,0.66,102,null,"","Tignish",46.950490000000002,64.03304,8073.7485632868929,38.540580160000012,0.66,102]
[{"$f":"IF(E409=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Argentia",47.302050000000001,53.986820000000002,7394.643810079001,2.4,0.7,{"$f":"0.8*((F409*0.8*2/3+G409)*20.88543)","v":33.082521120000003},0.75,108,null,{"$f":"IF(P409=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B409","v":"Argentia"},{"$f":"C409","v":47.302050000000001},{"$f":"D409","v":53.986820000000002},{"$f":"IF(A409<>\"yes\",E409,\"\")","v":7394.643810079001},{"$f":"H409","v":33.082521120000003},0.75,108]
["","Bonavista",48.65334,53.111820000000002,7409.8252677457494,3.1,0.6,37.649468480000003,0.84,115,null,"","Bonavista",48.65334,53.111820000000002,7409.8252677457494,37.649468480000003,0.84,115]
["","Buchans",48.82508,56.855310000000003,7661.5696417157042,4.7,0.6,51.907255360000001,0.6,97,null,"","Buchans",48.82508,56.855310000000003,7661.5696417157042,51.907255360000001,0.6,97]
["","Cape Harrison",54.933329999999998,57.916670000000003,8031.8392392477654,6.3,0.4,62.823373440000005,0.6,97,null,"","Cape Harrison",54.933329999999998,57.916670000000003,8031.8392392477654,62.823373440000005,0.6,97]
["yes","Cape Race",46.666670000000003,53.066670000000002,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C413))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C413))*COS(RADIANS(D413-ABS(LONG))))*6371","v":7299.646606280372},2.2999999999999998,0.7,32.191409439999994,1.05,128,null,"","Cape Race",46.666670000000003,53.066670000000002,"",32.191409439999994,1.05,128]
["","Channel-Port aux Basques",47.572110000000002,59.136429999999997,7755.9721611248633,3.6,0.7,43.775861280000001,0.78,110,null,"","Channel-Port aux Basques",47.572110000000002,59.136429999999997,7755.9721611248633,43.775861280000001,0.78,110]
["","Corner Brook",48.948999999999998,57.950270000000003,7739.6740504342215,3.7,0.6,42.996138560000006,0.55000000000000004,93,null,"","Corner Brook",48.948999999999998,57.950270000000003,7739.6740504342215,42.996138560000006,0.55000000000000004,93]
["","Gander",48.954410000000003,54.610349999999997,7522.1281816055498,3.7,0.6,42.996138560000006,0.6,97,null,"","Gander",48.954410000000003,54.610349999999997,7522.1281816055498,42.996138560000006,0.6,97]
["","Grand Bank",47.100239999999999,55.752490000000002,7502.875160574642,2.4,0.7,33.082521120000003,0.74,108,null,"","Grand Bank",47.100239999999999,55.752490000000002,7502.875160574642,33.082521120000003,0.74,108]
["","Grand Falls",48.929000000000002,55.650489999999998,7588.0625045946563,3.4,0.6,40.322803520000008,0.6,97,null,"","Grand Falls",48.929000000000002,55.650489999999998,7588.0625045946563,40.322803520000008,0.6,97]
["","Happy Valley-Goose Bay",53.301679999999998,60.326079999999997,8094.0399486396927,5.3,0.4,53.912256640000003,0.42,81,null,"","Happy Valley-Goose Bay",53.301679999999998,60.326079999999997,8094.0399486396927,53.912256640000003,0.42,81]
["","Labrador City",52.939,66.91422,8487.6344471159518,4.8,0.3,47.785863839999998,0.4,79,null,"","Labrador City",52.939,66.91422,8487.6344471159518,47.785863839999998,0.4,79]
["","St. Anthony",51.370420000000003,55.595860000000002,7710.8362300667395,6.1,0.6,64.382818880000002,0.87,117,null,"","St. Anthony",51.370420000000003,55.595860000000002,7710.8362300667395,64.382818880000002,0.87,117]
["","St. John's",47.560540000000003,52.712829999999997,7324.4171770141811,2.9,0.7,37.538079519999997,0.78,110,null,"yes","St. John's",47.560540000000003,52.712829999999997,7324.4171770141811,37.538079519999997,0.78,110]
["","Stephenville",48.547969999999999,58.581539999999997,7762.8420040631854,4.0999999999999996,0.6,46.560585279999998,0.57999999999999996,95,null,"","Stephenville",48.547969999999999,58.581539999999997,7762.8420040631854,46.560585279999998,0.57999999999999996,95]
["","Twin Falls",53.500450000000001,64.514139999999998,8358.5843263836323,4.8,0.4,49.456698240000001,0.4,79,null,"","Twin Falls",53.500450000000001,64.514139999999998,8358.5843263836323,49.456698240000001,0.4,79]
["","Wabana",47.643859999999997,52.947240000000001,7344.2783568350878,3,0.7,38.429191200000005,0.75,108,null,"","Wabana",47.643859999999997,52.947240000000001,7344.2783568350878,38.429191200000005,0.75,108]
["","Wabush",52.90043,66.865530000000007,8483.1620721764793,4.8,0.3,47.785863839999998,0.4,79,null,"","Wabush",52.90043,66.865530000000007,8483.1620721764793,47.785863839999998,0.4,79]
["","Aishihik",61.600200000000001,137.50943000000001,12290.509896233028,1.9,0.1,18.601956320000003,0.38,77,null,"","Aishihik",61.600200000000001,137.50943000000001,12290.509896233028,18.601956320000003,0.38,77]
["","Dawson",64.060069999999996,139.43203,12165.56885584416,2.9,0.1,27.513073120000001,0.31,70,null,"","Dawson",64.060069999999996,139.43203,12165.56885584416,27.513073120000001,0.31,70]
["","Destruction Bay",61.252470000000002,138.80082999999999,12366.616429650521,1.9,0.1,18.601956320000003,0.6,97,null,"","Destruction Bay",61.252470000000002,138.80082999999999,12366.616429650521,18.601956320000003,0.6,97]
["","Faro",62.228540000000002,133.35316,12081.883560616132,2.2999999999999998,0.1,22.166403040000002,0.35,74,null,"","Faro",62.228540000000002,133.35316,12081.883560616132,22.166403040000002,0.35,74]
["","Haines Junction",60.754449999999999,137.51177999999999,12355.603318944697,2.2000000000000002,0.1,21.275291360000008,0.34,73,null,"","Haines Junction",60.754449999999999,137.51177999999999,12355.603318944697,21.275291360000008,0.34,73]
["","Snag",62.399239999999999,140.3717,12332.205325907924,2.2000000000000002,0.1,21.275291360000008,0.31,70,null,"","Snag",62.399239999999999,140.3717,12332.205325907924,21.275291360000008,0.31,70]
["","Teslin",60.168610000000001,132.72037,12200.687249149625,3,0.1,28.40418480000001,0.34,73,null,"","Teslin",60.168610000000001,132.72037,12200.687249149625,28.40418480000001,0.34,73]
["","Watson Lake",60.062809999999999,128.71091000000001,12029.727098478517,3.2,0.1,30.18640816000001,0.35,74,null,"","Watson Lake",60.062809999999999,128.71091000000001,12029.727098478517,30.18640816000001,0.35,74]
["","Whitehorse",60.72119,135.05683999999999,12259.535439810621,2,0.1,19.493068000000001,0.38,77,null,"","Whitehorse",60.72119,135.05683999999999,12259.535439810621,19.493068000000001,0.38,77]
["","Aklavik",68.219920000000002,135.00779,11699.125293749485,2.8,0.1,26.621961439999996,0.48,87,null,"","Aklavik",68.219920000000002,135.00779,11699.125293749485,26.621961439999996,0.48,87]
["","Echo Bay / Port Radium",66.116100000000003,118.0188,11226.729642875769,3,0.1,28.40418480000001,0.53,91,null,"","Echo Bay / Port Radium",66.116100000000003,118.0188,11226.729642875769,28.40418480000001,0.53,91]
["","Fort Good Hope",66.255679999999998,128.63401999999999,11626.554202486512,2.9,0.1,27.513073120000001,0.44,83,null,"","Fort Good Hope",66.255679999999998,128.63401999999999,11626.554202486512,27.513073120000001,0.44,83]
["","Fort McPherson",67.436449999999994,134.88076000000001,11754.341353929405,3.2,0.1,30.18640816000001,0.4,79,null,"","Fort McPherson",67.436449999999994,134.88076000000001,11754.341353929405,30.18640816000001,0.4,79]
["","Fort Providence",61.357619999999997,117.66065,11437.228107172123,2.4,0.1,23.05751472,0.35,74,null,"","Fort Providence",61.357619999999997,117.66065,11437.228107172123,23.05751472,0.35,74]
["","Fort Resolution",61.172049999999999,113.67376,11248.867945513428,2.2999999999999998,0.1,22.166403040000002,0.39,78,null,"","Fort Resolution",61.172049999999999,113.67376,11248.867945513428,22.166403040000002,0.39,78]
["","Fort Simpson",61.8628,121.35303,11586.922925870193,2.2999999999999998,0.1,22.166403040000002,0.39,78,null,"","Fort Simpson",61.8628,121.35303,11586.922925870193,22.166403040000002,0.39,78]
["","Fort Smith",60.005519999999997,111.88494,11201.7009216077,2.2999999999999998,0.2,23.837237439999999,0.39,78,null,"","Fort Smith",60.005519999999997,111.88494,11201.7009216077,23.837237439999999,0.39,78]
["","Hay River",60.816220000000001,115.78537,11369.253304925065,2.4,0.1,23.05751472,0.35,74,null,"","Hay River",60.816220000000001,115.78537,11369.253304925065,23.05751472,0.35,74]
["","Holman",70.73639,117.76806000000001,10990.696599755085,2.1,0.1,20.384179680000003,0.86,116,null,"","Holman",70.73639,117.76806000000001,10990.696599755085,20.384179680000003,0.86,116]
["","Inuvik",68.360740000000007,133.72301999999999,11649.487109200081,3.1,0.1,29.295296480000005,0.48,87,null,"","Inuvik",68.360740000000007,133.72301999999999,11649.487109200081,29.295296480000005,0.48,87]
["","Mould Bay",76.777529999999999,118.97208000000001,10714.86604675301,1.5,0.1,15.037509600000002,0.57999999999999996,95,null,"","Mould Bay",76.777529999999999,118.97208000000001,10714.86604675301,15.037509600000002,0.57999999999999996,95]
["","Norman Wells",65.281490000000005,126.82865,11621.682427726504,3,0.1,28.40418480000001,0.44,83,null,"","Norman Wells",65.281490000000005,126.82865,11621.682427726504,28.40418480000001,0.44,83]
["","Rae-Edzo",62.823009999999996,115.98831,11291.293243932412,2.2999999999999998,0.1,22.166403040000002,0.47,86,null,"","Rae-Edzo",62.823009999999996,115.98831,11291.293243932412,22.166403040000002,0.47,86]
["","Tungsten",61.956940000000003,128.20277999999999,11887.07833226092,4.3,0.1,39.98863664000001,0.44,83,null,"","Tungsten",61.956940000000003,128.20277999999999,11887.07833226092,39.98863664000001,0.44,83]
["","Wrigley",63.221469999999997,123.45478,11606.677701682513,2.8,0.1,26.621961439999996,0.39,78,null,"","Wrigley",63.221469999999997,123.45478,11606.677701682513,26.621961439999996,0.39,78]
["","Yellowknife",62.453969999999998,114.37179,11230.871509186127,2.2000000000000002,0.1,21.275291360000008,0.47,86,null,"","Yellowknife",62.453969999999998,114.37179,11230.871509186127,21.275291360000008,0.47,86]
["","Alert",82.501400000000004,62.338900000000002,9621.3240581450591,2.6,0.1,24.839738080000004,0.75,108,null,"","Alert",82.501400000000004,62.338900000000002,9621.3240581450591,24.839738080000004,0.75,108]
["","Arctic Bay",73.037580000000005,85.148030000000006,9850.3151732573515,2.4,0.1,23.05751472,0.55000000000000004,93,null,"","Arctic Bay",73.037580000000005,85.148030000000006,9850.3151732573515,23.05751472,0.55000000000000004,93]
["","Arviat / Eskimo Point",61.108310000000003,94.059950000000001,10225.521936195631,3,0.2,30.075019200000003,0.57999999999999996,95,null,"","Arviat / Eskimo Point",61.108310000000003,94.059950000000001,10225.521936195631,30.075019200000003,0.57999999999999996,95]
["","Baker Lake",64.317599999999999,96.022000000000006,10297.30892713414,3.4,0.2,33.639465920000006,0.54,92,null,"","Baker Lake",64.317599999999999,96.022000000000006,10297.30892713414,33.639465920000006,0.54,92]
["","Cambridge Bay",69.117220000000003,105.05306,10598.195511289472,1.9,0.1,18.601956320000003,0.54,92,null,"","Cambridge Bay",69.117220000000003,105.05306,10598.195511289472,18.601956320000003,0.54,92]
["","Chesterfield Inlet",63.346510000000002,90.736829999999998,10044.2966554102,3.6,0.2,35.421689280000002,0.56000000000000005,94,null,"","Chesterfield Inlet",63.346510000000002,90.736829999999998,10044.2966554102,35.421689280000002,0.56000000000000005,94]
["","Clyde River",70.476370000000003,68.60127,9228.7682699529269,4.2,0.2,40.768359360000005,0.72,106,null,"","Clyde River",70.476370000000003,68.60127,9228.7682699529269,40.768359360000005,0.72,106]
["","Coppermine",67.825599999999994,115.095,11031.784491594612,3.4,0.1,31.968631520000002,0.46,85,null,"","Coppermine",67.825599999999994,115.095,11031.784491594612,31.968631520000002,0.46,85]
["","Coral Harbour",64.138829999999999,83.169899999999998,9676.9031851652308,3.8,0.2,37.203912640000006,0.69,104,null,"","Coral Harbour",64.138829999999999,83.169899999999998,9676.9031851652308,37.203912640000006,0.69,104]
["","Eureka",79.988900000000001,85.940799999999996,9929.1426615591972,1.6,0.1,15.928621280000002,0.55000000000000004,93,null,"","Eureka",79.988900000000001,85.940799999999996,9929.1426615591972,15.928621280000002,0.55000000000000004,93]
["","Iqaluit",63.746690000000001,68.516970000000001,8970.8958553111788,2.9,0.2,29.183907519999998,0.57999999999999996,95,null,"","Iqaluit",63.746690000000001,68.516970000000001,8970.8958553111788,29.183907519999998,0.57999999999999996,95]
["","Isachsen",78.793930000000003,103.55081,10297.746775659649,1.9,0.1,18.601956320000003,0.6,97,null,"","Isachsen",78.793930000000003,103.55081,10297.746775659649,18.601956320000003,0.6,97]
["","Nottingham Island",63.283299999999997,77.916700000000006,9407.0668821416839,4.7,0.2,45.223917760000006,0.78,110,null,"","Nottingham Island",63.283299999999997,77.916700000000006,9407.0668821416839,45.223917760000006,0.78,110]
["","Rankin Inlet",62.80838,92.085290000000001,10113.483698258709,3,0.2,30.075019200000003,0.6,97,null,"","Rankin Inlet",62.80838,92.085290000000001,10113.483698258709,30.075019200000003,0.6,97]
["","Resolute",74.697299999999998,94.829729999999998,10149.122439839875,2,0.1,19.493068000000001,0.69,104,null,"","Resolute",74.697299999999998,94.829729999999998,10149.122439839875,19.493068000000001,0.69,104]
["","Resolution Island",61.313029999999998,64.868989999999997,8699.5752991089212,5.5,0.2,52.352811200000012,1.23,138,null,"","Resolution Island",61.313029999999998,64.868989999999997,8699.5752991089212,52.352811200000012,1.23,138]
["","Beausejour",50.061729999999997,96.51585,10472.073290071794,2,0.2,21.163902399999998,0.41,80,null,"","Beausejour",50.061729999999997,96.51585,10472.073290071794,21.163902399999998,0.41,80]
["","Boisevain",49.230440000000002,100.0595,10735.825248068533,2.2000000000000002,0.2,22.946125760000005,0.52,90,null,"","Boisevain",49.230440000000002,100.0595,10735.825248068533,22.946125760000005,0.52,90]
["","Brandon",49.848469999999999,99.950900000000004,10718.916258717198,2.1,0.2,22.055014080000003,0.49,88,null,"","Brandon",49.848469999999999,99.950900000000004,10718.916258717198,22.055014080000003,0.49,88]
["","Churchill",58.768410000000003,94.164959999999994,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C472))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C472))*COS(RADIANS(D472-ABS(LONG))))*6371","v":10247.51701207143},3,0.2,30.075019200000003,0.55000000000000004,93,null,"","Churchill",58.768410000000003,94.164959999999994,10247.51701207143,30.075019200000003,0.55000000000000004,93]
[{"$f":"IF(E473=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Dauphin",51.150039999999997,100.0497,10706.328515661842,1.9,0.2,{"$f":"0.8*((F473*0.8*2/3+G473)*20.88543)","v":20.272790720000003},0.4,79,null,{"$f":"IF(P473=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B473","v":"Dauphin"},{"$f":"C473","v":51.150039999999997},{"$f":"D473","v":100.0497},{"$f":"IF(A473<>\"yes\",E473,\"\")","v":10706.328515661842},{"$f":"H473","v":20.272790720000003},0.4,79]
["","Flin Flon",54.765770000000003,101.87621,10765.754342050328,2.2000000000000002,0.2,22.946125760000005,0.35,74,null,"","Flin Flon",54.765770000000003,101.87621,10765.754342050328,22.946125760000005,0.35,74]
["","Gimli",50.760480000000001,97.00461,10499.495121488175,1.9,0.2,20.272790720000003,0.4,79,null,"","Gimli",50.760480000000001,97.00461,10499.495121488175,20.272790720000003,0.4,79]
["","Island Lake",53.864800000000002,94.667580000000001,10313.379529173473,2.6,0.2,26.510572480000004,0.37,76,null,"","Island Lake",53.864800000000002,94.667580000000001,10313.379529173473,26.510572480000004,0.37,76]
["","Lac du Bonnet",50.26482,96.216149999999999,10448.875534024543,1.9,0.2,20.272790720000003,0.37,76,null,"","Lac du Bonnet",50.26482,96.216149999999999,10448.875534024543,20.272790720000003,0.37,76]
["","Lynn Lake",56.850340000000003,101.05381,10676.732731192949,2.4,0.2,24.728349120000001,0.37,76,null,"","Lynn Lake",56.850340000000003,101.05381,10676.732731192949,24.728349120000001,0.37,76]
["","Morden",49.192329999999998,98.097729999999999,10594.866332921203,2.2000000000000002,0.2,22.946125760000005,0.52,90,null,"","Morden",49.192329999999998,98.097729999999999,10594.866332921203,22.946125760000005,0.52,90]
["","Neepawa",50.227699999999999,99.466769999999997,10679.151478746508,2.2000000000000002,0.2,22.946125760000005,0.44,83,null,"","Neepawa",50.227699999999999,99.466769999999997,10679.151478746508,22.946125760000005,0.44,83]
["","Pine Falls",50.565449999999998,96.217759999999998,10446.192608228044,1.9,0.2,20.272790720000003,0.39,78,null,"","Pine Falls",50.565449999999998,96.217759999999998,10446.192608228044,20.272790720000003,0.39,78]
["","Portage la Prairie",50.137639999999998,98.253169999999997,10594.544084832392,2.1,0.2,22.055014080000003,0.46,85,null,"","Portage la Prairie",50.137639999999998,98.253169999999997,10594.544084832392,22.055014080000003,0.46,85]
["","Rivers",50.032859999999999,100.23967,10736.623813946278,2.1,0.2,22.055014080000003,0.46,85,null,"","Rivers",50.032859999999999,100.23967,10736.623813946278,22.055014080000003,0.46,85]
["","Sandilands",49.324649999999998,96.293229999999994,10463.109040280697,2.2000000000000002,0.2,22.946125760000005,0.4,79,null,"","Sandilands",49.324649999999998,96.293229999999994,10463.109040280697,22.946125760000005,0.4,79]
["","Selkirk",50.143529999999998,96.875429999999994,10496.799934066585,1.9,0.2,20.272790720000003,0.41,80,null,"","Selkirk",50.143529999999998,96.875429999999994,10496.799934066585,20.272790720000003,0.41,80]
["","Split Lake",56.245139999999999,96.095060000000004,10383.631757265523,2.5,0.2,25.619460799999999,0.39,78,null,"","Split Lake",56.245139999999999,96.095060000000004,10383.631757265523,25.619460799999999,0.39,78]
["","Steinbach",49.525829999999999,96.683890000000005,10489.333512434598,2,0.2,21.163902399999998,0.4,79,null,"","Steinbach",49.525829999999999,96.683890000000005,10489.333512434598,21.163902399999998,0.4,79]
["","Swan River",52.105089999999997,101.27061999999999,10774.193977241483,2,0.2,21.163902399999998,0.35,74,null,"","Swan River",52.105089999999997,101.27061999999999,10774.193977241483,21.163902399999998,0.35,74]
["","The Pas",53.825530000000001,101.24760999999999,10742.648439595472,2.2000000000000002,0.2,22.946125760000005,0.37,76,null,"","The Pas",53.825530000000001,101.24760999999999,10742.648439595472,22.946125760000005,0.37,76]
["","Thompson",55.744929999999997,97.85087,10497.870663340018,2.4,0.2,24.728349120000001,0.36,75,null,"","Thompson",55.744929999999997,97.85087,10497.870663340018,24.728349120000001,0.36,75]
["","Virden",49.848669999999998,100.93253,10788.607095895335,2,0.2,21.163902399999998,0.46,85,null,"","Virden",49.848669999999998,100.93253,10788.607095895335,21.163902399999998,0.46,85]
["","Winnipeg",49.899749999999997,97.13749,10517.981229651332,1.9,0.2,20.272790720000003,0.45,84,null,"","Winnipeg",49.899749999999997,97.13749,10517.981229651332,20.272790720000003,0.45,84]
["","Assiniboia",49.633569999999999,105.99178999999999,11150.465771789493,1.6,0.1,15.928621280000002,0.49,88,null,"","Assiniboia",49.633569999999999,105.99178999999999,11150.465771789493,15.928621280000002,0.49,88]
["","Battrum",50.54862,108.33477000000001,11289.641497315914,1.2,0.1,12.36417456,0.54,92,null,"","Battrum",50.54862,108.33477000000001,11289.641497315914,12.36417456,0.54,92]
["","Biggar",52.05715,107.98356,11224.393172068025,2.1,0.1,20.384179680000003,0.45,84,null,"","Biggar",52.05715,107.98356,11224.393172068025,20.384179680000003,0.45,84]
["","Broadview",50.378059999999998,102.57907,10895.260461930864,1.7,0.1,16.819732960000003,0.46,85,null,"","Broadview",50.378059999999998,102.57907,10895.260461930864,16.819732960000003,0.46,85]
["","Dafoe",51.752299999999998,104.52155,11000.505102367564,1.7,0.1,16.819732960000003,0.37,76,null,"","Dafoe",51.752299999999998,104.52155,11000.505102367564,16.819732960000003,0.37,76]
["","Dundurn",51.80959,106.50763000000001,11132.6333915749,1.5,0.1,15.037509600000002,0.46,85,null,"","Dundurn",51.80959,106.50763000000001,11132.6333915749,15.037509600000002,0.46,85]
["","Estevan",49.13908,102.99148,10947.962141609249,1.6,0.1,15.928621280000002,0.52,90,null,"","Estevan",49.13908,102.99148,10947.962141609249,15.928621280000002,0.52,90]
["","Hudson Bay",52.8568,102.38811,10835.147825099959,2,0.1,19.493068000000001,0.37,76,null,"","Hudson Bay",52.8568,102.38811,10835.147825099959,19.493068000000001,0.37,76]
["","Humboldt",52.201979999999999,105.12287000000001,11030.620145163462,2.1,0.1,20.384179680000003,0.39,78,null,"","Humboldt",52.201979999999999,105.12287000000001,11030.620145163462,20.384179680000003,0.39,78]
["","Island Falls",55.526499999999999,102.34823,10780.623306696692,2.1,0.1,20.384179680000003,0.35,74,null,"","Island Falls",55.526499999999999,102.34823,10780.623306696692,20.384179680000003,0.35,74]
["","Kamsack",51.564880000000002,101.89842,10826.338147271861,2.1,0.2,22.055014080000003,0.4,79,null,"","Kamsack",51.564880000000002,101.89842,10826.338147271861,22.055014080000003,0.4,79]
["","Kindersley",51.467529999999996,109.15468,11319.049095652279,1.4,0.1,14.146397919999998,0.46,85,null,"","Kindersley",51.467529999999996,109.15468,11319.049095652279,14.146397919999998,0.46,85]
["","Lloydminster",53.27796,110.00615000000001,11320.096310459279,2,0.1,19.493068000000001,0.4,79,null,"","Lloydminster",53.27796,110.00615000000001,11320.096310459279,19.493068000000001,0.4,79]
["","Maple Creek",49.906599999999997,109.48017,11386.608481114175,1.2,0.1,12.36417456,0.45,84,null,"","Maple Creek",49.906599999999997,109.48017,11386.608481114175,12.36417456,0.45,84]
["","Meadow Lake",54.13167,108.42803000000001,11194.423631429945,1.7,0.1,16.819732960000003,0.4,79,null,"","Meadow Lake",54.13167,108.42803000000001,11194.423631429945,16.819732960000003,0.4,79]
["","Melfort",52.860840000000003,104.6143,10981.853037595429,2.1,0.1,20.384179680000003,0.36,75,null,"","Melfort",52.860840000000003,104.6143,10981.853037595429,20.384179680000003,0.36,75]
["","Melville",50.929450000000003,102.89046500000001,10906.329760733985,1.7,0.1,16.819732960000003,0.4,79,null,"","Melville",50.929450000000003,102.89046500000001,10906.329760733985,16.819732960000003,0.4,79]
["","Moose Jaw",50.391579999999998,105.53485999999999,11100.736487215148,1.4,0.1,14.146397919999998,0.52,90,null,"","Moose Jaw",50.391579999999998,105.53485999999999,11100.736487215148,14.146397919999998,0.52,90]
["","Nipawin",53.362349999999999,104.01300999999999,10931.380183634104,2,0.1,19.493068000000001,0.38,77,null,"","Nipawin",53.362349999999999,104.01300999999999,10931.380183634104,19.493068000000001,0.38,77]
["","North Battleford",52.776479999999999,108.29746,11224.897224814929,1.7,0.1,16.819732960000003,0.46,85,null,"","North Battleford",52.776479999999999,108.29746,11224.897224814929,16.819732960000003,0.46,85]
["","Prince Albert",53.20335,105.75306999999999,11048.200388683685,1.9,0.1,18.601956320000003,0.38,77,null,"","Prince Albert",53.20335,105.75306999999999,11048.200388683685,18.601956320000003,0.38,77]
["","Qu'Appelle",50.542610000000003,103.87766999999999,10982.446449522016,1.7,0.1,16.819732960000003,0.42,81,null,"","Qu'Appelle",50.542610000000003,103.87766999999999,10982.446449522016,16.819732960000003,0.42,81]
["","Regina",50.454720000000002,104.60666999999999,11034.925886757996,1.4,0.1,14.146397919999998,0.49,88,null,"","Regina",50.454720000000002,104.60666999999999,11034.925886757996,14.146397919999998,0.49,88]
["","Rosetown",51.555489999999999,107.99102999999999,11238.682739958811,1.7,0.1,16.819732960000003,0.49,88,null,"","Rosetown",51.555489999999999,107.99102999999999,11238.682739958811,16.819732960000003,0.49,88]
["","Saskatoon",52.134369999999997,106.64766,11133.727511878054,1.7,0.1,16.819732960000003,0.43,82,null,"","Saskatoon",52.134369999999997,106.64766,11133.727511878054,16.819732960000003,0.43,82]
["","Scott",52.365740000000002,108.82876,11271.35906815347,1.9,0.1,18.601956320000003,0.45,84,null,"","Scott",52.365740000000002,108.82876,11271.35906815347,18.601956320000003,0.45,84]
["","Strasbourg",51.069189999999999,104.95869999999999,11045.502215408269,1.5,0.1,15.037509600000002,0.42,81,null,"","Strasbourg",51.069189999999999,104.95869999999999,11045.502215408269,15.037509600000002,0.42,81]
["","Swift Current",50.285069999999997,107.79716999999999,11259.84548797593,1.4,0.1,14.146397919999998,0.54,92,null,"","Swift Current",50.285069999999997,107.79716999999999,11259.84548797593,14.146397919999998,0.54,92]
["","Uranium City",59.569330000000001,108.61051999999999,11041.886916951909,2,0.1,19.493068000000001,0.36,75,null,"","Uranium City",59.569330000000001,108.61051999999999,11041.886916951909,19.493068000000001,0.36,75]
["","Weyburn",49.66328,103.85329,10998.9307356229,1.8,0.1,17.710844640000001,0.48,87,null,"","Weyburn",49.66328,103.85329,10998.9307356229,17.710844640000001,0.48,87]
["","Yorkton",51.213889999999999,102.46278,10871.443629234152,1.9,0.1,18.601956320000003,0.4,79,null,"","Yorkton",51.213889999999999,102.46278,10871.443629234152,18.601956320000003,0.4,79]
["","Athabasca",54.719700000000003,113.2856,11475.144823648217,1.5,0.1,15.037509600000002,0.36,75,null,"","Athabasca",54.719700000000003,113.2856,11475.144823648217,15.037509600000002,0.36,75]
["","Banff",51.178100000000001,115.5719,11753.287309339106,3.3,0.1,31.077519840000004,0.32,71,null,"","Banff",51.178100000000001,115.5719,11753.287309339106,31.077519840000004,0.32,71]
["","Barrhead",54.116700000000002,114.4,11565.674765082045,1.7,0.1,16.819732960000003,0.44,83,null,"","Barrhead",54.116700000000002,114.4,11565.674765082045,16.819732960000003,0.44,83]
["","Beaverlodge",55.209400000000002,119.42919999999999,11817.935787185261,2.4,0.1,23.05751472,0.36,75,null,"","Beaverlodge",55.209400000000002,119.42919999999999,11817.935787185261,23.05751472,0.36,75]
["","Brooks",50.5642,111.8989,11531.420844929275,1.2,0.1,12.36417456,0.52,90,null,"","Brooks",50.5642,111.8989,11531.420844929275,12.36417456,0.52,90]
["","Calgary",51.05,114.0667,11659.254253784184,1.1000000000000001,0.1,11.473062880000002,0.48,87,null,"","Calgary",51.05,114.0667,11659.254253784184,11.473062880000002,0.48,87]
["","Campsie",54.127800000000001,114.6467,11580.326110965703,1.7,0.1,16.819732960000003,0.44,83,null,"","Campsie",54.127800000000001,114.6467,11580.326110965703,16.819732960000003,0.44,83]
["","Camrose",53.0229,112.8282,11508.127885069711,2,0.1,19.493068000000001,0.39,78,null,"","Camrose",53.0229,112.8282,11508.127885069711,19.493068000000001,0.39,78]
["","Canmore",51.0837,115.36799999999999,11743.597065319982,3.2,0.1,30.18640816000001,0.37,76,null,"","Canmore",51.0837,115.36799999999999,11743.597065319982,30.18640816000001,0.37,76]
["","Cardston",49.202500000000001,113.3019,11673.128369673825,1.5,0.1,15.037509600000002,0.72,106,null,"","Cardston",49.202500000000001,113.3019,11673.128369673825,15.037509600000002,0.72,106]
["","Claresholm",50.019399999999997,113.5783,11663.554942614042,1.3,0.1,13.255286240000002,0.57999999999999996,95,null,"","Claresholm",50.019399999999997,113.5783,11663.554942614042,13.255286240000002,0.57999999999999996,95]
["","Cold Lake",54.464199999999998,110.1825,11293.806570895105,1.7,0.1,16.819732960000003,0.38,77,null,"","Cold Lake",54.464199999999998,110.1825,11293.806570895105,16.819732960000003,0.38,77]
["","Coleman",49.635300000000001,114.5031,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C536))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C536))*COS(RADIANS(D536-ABS(LONG))))*6371","v":11740.123149392251},2.7,0.3,29.072518560000006,0.63,99,null,"","Coleman",49.635300000000001,114.5031,11740.123149392251,29.072518560000006,0.63,99]
[{"$f":"IF(E537=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Coronation",52.087800000000001,111.4333,11450.338655682017,1.9,0.1,{"$f":"0.8*((F537*0.8*2/3+G537)*20.88543)","v":18.601956320000003},0.37,76,null,{"$f":"IF(P537=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B537","v":"Coronation"},{"$f":"C537","v":52.087800000000001},{"$f":"D537","v":111.4333},{"$f":"IF(A537<>\"yes\",E537,\"\")","v":11450.338655682017},{"$f":"H537","v":18.601956320000003},0.37,76]
["","Cowley",49.567700000000002,114.06910000000001,11712.987285885954,1.6,0.1,15.928621280000002,1.01,126,null,"","Cowley",49.567700000000002,114.06910000000001,11712.987285885954,15.928621280000002,1.01,126]
["","Drumheller",51.465179999999997,112.71053000000001,11555.077511423435,1.2,0.1,12.36417456,0.44,83,null,"","Drumheller",51.465179999999997,112.71053000000001,11555.077511423435,12.36417456,0.44,83]
["","Edmonton",53.54439,113.49093000000001,11530.993989929708,1.7,0.1,16.819732960000003,0.45,84,null,"","Edmonton",53.54439,113.49093000000001,11530.993989929708,16.819732960000003,0.45,84]
["","Edson",53.583500000000001,116.4345,11711.501316161348,2.1,0.1,20.384179680000003,0.46,85,null,"","Edson",53.583500000000001,116.4345,11711.501316161348,20.384179680000003,0.46,85]
["","Embarras Portage",58.449820000000003,111.48430999999999,11236.059724294411,2.2000000000000002,0.1,21.275291360000008,0.37,76,null,"","Embarras Portage",58.449820000000003,111.48430999999999,11236.059724294411,21.275291360000008,0.37,76]
["","Fairview",56.06964,118.39167,11719.011650907663,2.4,0.1,23.05751472,0.35,74,null,"","Fairview",56.06964,118.39167,11719.011650907663,23.05751472,0.35,74]
["","Fort MacLeod",49.721679999999999,113.40004,11661.870332967934,1.2,0.1,12.36417456,0.68,103,null,"","Fort MacLeod",49.721679999999999,113.40004,11661.870332967934,12.36417456,0.68,103]
["","Fort McMurray",56.726379999999999,111.38034,11290.459470154214,1.5,0.1,15.037509600000002,0.35,74,null,"","Fort McMurray",56.726379999999999,111.38034,11290.459470154214,15.037509600000002,0.35,74]
["","Fort Saskatchewan",53.700719999999997,113.20947,11507.753582252102,1.6,0.1,15.928621280000002,0.43,82,null,"","Fort Saskatchewan",53.700719999999997,113.20947,11507.753582252102,15.928621280000002,0.43,82]
["","Fort Vermilion",58.38588,116.03055999999999,11486.39556324801,2.1,0.1,20.384179680000003,0.3,69,null,"","Fort Vermilion",58.38588,116.03055999999999,11486.39556324801,20.384179680000003,0.3,69]
["","Grande Prairie",55.169939999999997,118.79862,11783.358240383734,2.2000000000000002,0.1,21.275291360000008,0.43,82,null,"","Grande Prairie",55.169939999999997,118.79862,11783.358240383734,21.275291360000008,0.43,82]
["","Habay",58.811529999999998,118.70714,11609.097591923131,2.4,0.1,23.05751472,0.3,69,null,"","Habay",58.811529999999998,118.70714,11609.097591923131,23.05751472,0.3,69]
["","Hardisty",52.67501,111.30365999999999,11422.605217697279,1.7,0.1,16.819732960000003,0.36,75,null,"","Hardisty",52.67501,111.30365999999999,11422.605217697279,16.819732960000003,0.36,75]
["","High River",50.580100000000002,113.87072999999999,11663.260308183604,1.3,0.1,13.255286240000002,0.65,101,null,"","High River",50.580100000000002,113.87072999999999,11663.260308183604,13.255286240000002,0.65,101]
["","Hinton",53.40654,117.57003,11788.467907278347,2.6,0.1,24.839738080000004,0.46,85,null,"","Hinton",53.40654,117.57003,11788.467907278347,24.839738080000004,0.46,85]
["","Jasper",52.879280000000001,118.07926,11842.564662263861,3,0.1,28.40418480000001,0.32,71,null,"","Jasper",52.879280000000001,118.07926,11842.564662263861,28.40418480000001,0.32,71]
["","Keg River",57.788400000000003,117.85594,11611.227820051821,2.4,0.1,23.05751472,0.3,69,null,"","Keg River",57.788400000000003,117.85594,11611.227820051821,23.05751472,0.3,69]
["","Lac la Biche",54.769640000000003,111.97251,11393.573039156809,1.6,0.1,15.928621280000002,0.36,75,null,"","Lac la Biche",54.769640000000003,111.97251,11393.573039156809,15.928621280000002,0.36,75]
["","Lacombe",52.463050000000003,113.72862000000001,11585.638360090941,1.9,0.1,18.601956320000003,0.4,79,null,"","Lacombe",52.463050000000003,113.72862000000001,11585.638360090941,18.601956320000003,0.4,79]
["","Lethbridge",49.693489999999997,112.84184,11624.674785148743,1.2,0.1,12.36417456,0.66,102,null,"","Lethbridge",49.693489999999997,112.84184,11624.674785148743,12.36417456,0.66,102]
["","Manning",56.923319999999997,117.62864999999999,11637.714351267254,2.2999999999999998,0.1,22.166403040000002,0.3,69,null,"","Manning",56.923319999999997,117.62864999999999,11637.714351267254,22.166403040000002,0.3,69]
["","Medicine Hat",50.040550000000003,110.67643,11464.975888191531,1.1000000000000001,0.1,11.473062880000002,0.48,87,null,"","Medicine Hat",50.040550000000003,110.67643,11464.975888191531,11.473062880000002,0.48,87]
["","Peace River",56.234180000000002,117.28937999999999,11649.143215404994,2.2000000000000002,0.1,21.275291360000008,0.32,71,null,"","Peace River",56.234180000000002,117.28937999999999,11649.143215404994,21.275291360000008,0.32,71]
["","Pincher Creek",49.486350000000002,113.95025,11707.765933014662,1.5,0.1,15.037509600000002,0.96,122,null,"","Pincher Creek",49.486350000000002,113.95025,11707.765933014662,15.037509600000002,0.96,122]
["","Ranfurly",53.400239999999997,111.68368,11422.638154497283,1.9,0.1,18.601956320000003,0.36,75,null,"","Ranfurly",53.400239999999997,111.68368,11422.638154497283,18.601956320000003,0.36,75]
["","Red Deer",52.26811,113.81124,11598.07374553553,1.8,0.1,17.710844640000001,0.4,79,null,"","Red Deer",52.26811,113.81124,11598.07374553553,17.710844640000001,0.4,79]
["","Rocky Mountain House",52.379339999999999,114.91829,11664.724748882943,1.9,0.1,18.601956320000003,0.36,75,null,"","Rocky Mountain House",52.379339999999999,114.91829,11664.724748882943,18.601956320000003,0.36,75]
["","Slave Lake",55.286679999999997,114.77112,11542.503025163644,1.9,0.1,18.601956320000003,0.37,76,null,"","Slave Lake",55.286679999999997,114.77112,11542.503025163644,18.601956320000003,0.37,76]
["","Stettler",52.322749999999999,112.7109,11525.273964165446,1.9,0.1,18.601956320000003,0.36,75,null,"","Stettler",52.322749999999999,112.7109,11525.273964165446,18.601956320000003,0.36,75]
["","Stony Plain",53.53,114.00639,11563.639798660537,1.7,0.1,16.819732960000003,0.45,84,null,"","Stony Plain",53.53,114.00639,11563.639798660537,16.819732960000003,0.45,84]
["","Suffield",50.217230000000001,111.16477999999999,11492.848003072482,1.3,0.1,13.255286240000002,0.49,88,null,"","Suffield",50.217230000000001,111.16477999999999,11492.848003072482,13.255286240000002,0.49,88]
["","Taber",49.785960000000003,112.14964999999999,11574.147278339424,1.2,0.1,12.36417456,0.63,99,null,"","Taber",49.785960000000003,112.14964999999999,11574.147278339424,12.36417456,0.63,99]
["","Turner Valley",50.673900000000003,114.27885999999999,11687.066692068009,1.4,0.1,14.146397919999998,0.65,101,null,"","Turner Valley",50.673900000000003,114.27885999999999,11687.066692068009,14.146397919999998,0.65,101]
["","Valleyview",55.069159999999997,117.28111,11699.422464049034,2.2999999999999998,0.1,22.166403040000002,0.42,81,null,"","Valleyview",55.069159999999997,117.28111,11699.422464049034,22.166403040000002,0.42,81]
["","Vegreville",53.495530000000002,112.05253999999999,11442.635126327579,1.9,0.1,18.601956320000003,0.36,75,null,"","Vegreville",53.495530000000002,112.05253999999999,11442.635126327579,18.601956320000003,0.36,75]
["","Vermilion",53.354019999999998,110.85863000000001,11371.933780822726,1.7,0.1,16.819732960000003,0.36,75,null,"","Vermilion",53.354019999999998,110.85863000000001,11371.933780822726,16.819732960000003,0.36,75]
["","Wagner",55.353819999999999,114.98480000000001,11552.474920514822,1.9,0.1,18.601956320000003,0.37,76,null,"","Wagner",55.353819999999999,114.98480000000001,11552.474920514822,18.601956320000003,0.37,76]
["","Wainwright",52.833069999999999,110.85047,11388.292290011239,2,0.1,19.493068000000001,0.36,75,null,"","Wainwright",52.833069999999999,110.85047,11388.292290011239,19.493068000000001,0.36,75]
["","Wetaskiwin",52.969540000000002,113.37725,11544.823115359686,2,0.1,19.493068000000001,0.39,78,null,"","Wetaskiwin",52.969540000000002,113.37725,11544.823115359686,19.493068000000001,0.39,78]
["","Whitecourt",54.142400000000002,115.68498,11642.960824830341,1.9,0.1,18.601956320000003,0.37,76,null,"","Whitecourt",54.142400000000002,115.68498,11642.960824830341,18.601956320000003,0.37,76]
["","Wimborne",51.86506,113.59421,11598.719609166954,1.6,0.1,15.928621280000002,0.4,79,null,"","Wimborne",51.86506,113.59421,11598.719609166954,15.928621280000002,0.4,79]
["","100 Mile House",51.643970000000003,121.29501,12098.504179145339,2.6,0.3,28.181406880000004,0.35,74,null,"","100 Mile House",51.643970000000003,121.29501,12098.504179145339,28.181406880000004,0.35,74]
["","Abbotsford",49.054589999999997,122.32803,12288.711740447663,2,0.3,22.834736800000002,0.44,83,null,"","Abbotsford",49.054589999999997,122.32803,12288.711740447663,22.834736800000002,0.44,83]
["","Agassiz",49.238939999999999,121.76588,12242.984665807182,2.4,0.7,33.082521120000003,0.47,86,null,"","Agassiz",49.238939999999999,121.76588,12242.984665807182,33.082521120000003,0.47,86]
["","Alberni",49.266669999999998,124.8,12438.766304770228,2.6,0.4,29.852241280000001,0.32,71,null,"","Alberni",49.266669999999998,124.8,12438.766304770228,29.852241280000001,0.32,71]
["","Ashcroft",50.725920000000002,121.28046999999999,12141.275245926197,1.7,0.1,16.819732960000003,0.38,77,null,"","Ashcroft",50.725920000000002,121.28046999999999,12141.275245926197,16.819732960000003,0.38,77]
["","Bamfield",48.833370000000002,125.14261,12483.349050648692,1,0.4,15.594454400000002,0.5,88,null,"","Bamfield",48.833370000000002,125.14261,12483.349050648692,15.594454400000002,0.5,88]
["","Beatton River",57.380090000000003,121.41103,11821.873651697146,3.3,0.1,31.077519840000004,0.3,69,null,"","Beatton River",57.380090000000003,121.41103,11821.873651697146,31.077519840000004,0.3,69]
["","Bella Bella",52.160359999999997,128.14554999999999,12483.405950254202,2.6,0.8,36.535578879999996,0.5,88,null,"","Bella Bella",52.160359999999997,128.14554999999999,12483.405950254202,36.535578879999996,0.5,88]
["","Bella Coola",52.372900000000001,126.76258,12390.671060952003,4.5,0.8,53.466700800000005,0.39,78,null,"","Bella Coola",52.372900000000001,126.76258,12390.671060952003,53.466700800000005,0.39,78]
["","Burns Lake",54.233409999999999,125.76361,12228.577501291891,3.4,0.2,33.639465920000006,0.39,78,null,"","Burns Lake",54.233409999999999,125.76361,12228.577501291891,33.639465920000006,0.39,78]
["","Cache Creek",50.810809999999996,121.32332,12139.979365099187,1.7,0.2,18.49056736,0.39,78,null,"","Cache Creek",50.810809999999996,121.32332,12139.979365099187,18.49056736,0.39,78]
["","Campbell River",50.033119999999997,125.27334,12428.656035319853,2.8,0.4,31.634464639999994,0.52,90,null,"","Campbell River",50.033119999999997,125.27334,12428.656035319853,31.634464639999994,0.52,90]
["","Carmi",49.495489999999997,119.12278000000001,12056.586952901835,3.6,0.2,35.421689280000002,0.38,77,null,"","Carmi",49.495489999999997,119.12278000000001,12056.586952901835,35.421689280000002,0.38,77]
["","Castlegar",49.323740000000001,117.65933,11965.891633199646,4.2,0.1,39.097524960000008,0.34,73,null,"","Castlegar",49.323740000000001,117.65933,11965.891633199646,39.097524960000008,0.34,73]
["","Chetwynd",55.697589999999998,121.62963000000001,11919.016094314398,2.4,0.2,24.728349120000001,0.4,79,null,"","Chetwynd",55.697589999999998,121.62963000000001,11919.016094314398,24.728349120000001,0.4,79]
["","Chilliwack",49.157940000000004,121.95147,12259.020733941134,2.2000000000000002,0.3,24.616960160000005,0.47,86,null,"","Chilliwack",49.157940000000004,121.95147,12259.020733941134,24.616960160000005,0.47,86]
["","Comox",49.67351,124.92827,12425.787509189944,2.4,0.4,28.070017920000005,0.52,90,null,"","Comox",49.67351,124.92827,12425.787509189944,28.070017920000005,0.52,90]
["","Courtenay",49.684139999999999,124.99045,12429.179534226112,2.4,0.4,28.070017920000005,0.52,90,null,"","Courtenay",49.684139999999999,124.99045,12429.179534226112,28.070017920000005,0.52,90]
["","Cranbrook",49.512970000000003,115.7694,11830.684429857705,3,0.2,30.075019200000003,0.33,72,null,"","Cranbrook",49.512970000000003,115.7694,11830.684429857705,30.075019200000003,0.33,72]
["","Crescent Valley",49.446339999999999,117.55779,11954.030193536741,4.2,0.1,39.097524960000008,0.33,72,null,"","Crescent Valley",49.446339999999999,117.55779,11954.030193536741,39.097524960000008,0.33,72]
["","Crofton",48.863840000000003,123.64579999999999,12384.44715889104,1.8,0.2,19.381679040000005,0.4,79,null,"","Crofton",48.863840000000003,123.64579999999999,12384.44715889104,19.381679040000005,0.4,79]
["","Dawson Creek",55.759630000000001,120.23766000000001,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C600))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C600))*COS(RADIANS(D600-ABS(LONG))))*6371","v":11837.851096314707},2.5,0.2,25.619460799999999,0.4,79,null,"","Dawson Creek",55.759630000000001,120.23766000000001,11837.851096314707,25.619460799999999,0.4,79]
[{"$f":"IF(E601=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Dease Lake",58.625990000000002,130.03827999999999,12183.342402505345,2.8,0.1,{"$f":"0.8*((F601*0.8*2/3+G601)*20.88543)","v":26.621961439999996},0.3,69,null,{"$f":"IF(P601=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B601","v":"Dease Lake"},{"$f":"C601","v":58.625990000000002},{"$f":"D601","v":130.03827999999999},{"$f":"IF(A601<>\"yes\",E601,\"\")","v":12183.342402505345},{"$f":"H601","v":26.621961439999996},0.3,69]
["","Dog Creek",51.581609999999998,122.23783,12160.098147462311,1.8,0.2,19.381679040000005,0.35,74,null,"","Dog Creek",51.581609999999998,122.23783,12160.098147462311,19.381679040000005,0.35,74]
["","Duncan",48.778689999999997,123.70793999999999,12392.758406978781,1.8,0.4,22.723347840000002,0.39,78,null,"","Duncan",48.778689999999997,123.70793999999999,12392.758406978781,22.723347840000002,0.39,78]
["","Elko",49.299039999999998,115.11096999999999,11793.959638131448,3.6,0.2,35.421689280000002,0.4,79,null,"","Elko",49.299039999999998,115.11096999999999,11793.959638131448,35.421689280000002,0.4,79]
["","Fernie",49.504049999999999,115.06307,11783.058555679156,4.5,0.2,43.441694400000003,0.4,79,null,"","Fernie",49.504049999999999,115.06307,11783.058555679156,43.441694400000003,0.4,79]
["","Fort Nelson",58.805019999999999,122.69723999999999,11814.252442573857,2.4,0.1,23.05751472,0.3,69,null,"","Fort Nelson",58.805019999999999,122.69723999999999,11814.252442573857,23.05751472,0.3,69]
["","Fort St. John",56.252420000000001,120.84641000000001,11847.767954945071,2.8,0.1,26.621961439999996,0.39,78,null,"","Fort St. John",56.252420000000001,120.84641000000001,11847.767954945071,26.621961439999996,0.39,78]
["","Glacier",51.265779999999999,117.5163,11875.925568938934,9.4,0.2,87.106166720000019,0.32,71,null,"","Glacier",51.265779999999999,117.5163,11875.925568938934,87.106166720000019,0.32,71]
["","Gold River",49.77816,126.04961,12491.030741493565,2.8,0.6,34.976133439999998,0.32,71,null,"","Gold River",49.77816,126.04961,12491.030741493565,34.976133439999998,0.32,71]
["","Golden",51.296120000000002,116.96314,11838.966794032916,3.7,0.2,36.312800960000004,0.35,74,null,"","Golden",51.296120000000002,116.96314,11838.966794032916,36.312800960000004,0.35,74]
["","Grand Forks",49.030090000000001,118.44513999999999,12031.078965665443,2.8,0.1,26.621961439999996,0.4,79,null,"","Grand Forks",49.030090000000001,118.44513999999999,12031.078965665443,26.621961439999996,0.4,79]
["","Greenwood",49.087899999999998,118.6781,12044.333343334552,3.6,0.1,33.750854879999999,0.4,79,null,"","Greenwood",49.087899999999998,118.6781,12044.333343334552,33.750854879999999,0.4,79]
["","Hope",49.380220000000001,121.44434,12215.218245816808,2.8,0.7,36.646967840000002,0.63,99,null,"","Hope",49.380220000000001,121.44434,12215.218245816808,36.646967840000002,0.63,99]
["","Jordan River",48.420459999999999,124.0448,12432.798682044084,1.2,0.4,17.376677760000003,0.55000000000000004,93,null,"","Jordan River",48.420459999999999,124.0448,12432.798682044084,17.376677760000003,0.55000000000000004,93]
["","Kamloops",50.674520000000001,120.32727,12082.712994589299,1.8,0.2,19.381679040000005,0.4,79,null,"","Kamloops",50.674520000000001,120.32727,12082.712994589299,19.381679040000005,0.4,79]
["","Kaslo",49.914250000000003,116.91545000000001,11892.001591359131,2.8,0.1,26.621961439999996,0.31,{"$f":"ROUNDUP(SQRT(2*I616/0.00064645)*2.236936141,0)","v":70},null,"","Kaslo",49.914250000000003,116.91545000000001,11892.001591359131,26.621961439999996,0.31,{"$f":"ROUNDUP(SQRT(2*R616/0.00064645)*2.236936141,0)","v":70}]
["","Kelowna",49.887949999999996,119.49601,12064.092973474828,1.7,0.1,16.819732960000003,0.4,79,null,"","Kelowna",49.887949999999996,119.49601,12064.092973474828,16.819732960000003,0.4,79]
["","Kimberley",49.669719999999998,115.97750000000001,11838.717266216752,3,0.2,30.075019200000003,0.33,72,null,"","Kimberley",49.669719999999998,115.97750000000001,11838.717266216752,30.075019200000003,0.33,72]
["","Kitimat",54.062910000000002,128.63835,12397.950256400112,6.5,0.8,71.288934400000002,0.48,87,null,"","Kitimat",54.062910000000002,128.63835,12397.950256400112,71.288934400000002,0.48,87]
["","Ladysmith",48.995339999999999,123.81610000000001,12388.985170468399,2.4,0.4,28.070017920000005,0.4,79,null,"","Ladysmith",48.995339999999999,123.81610000000001,12388.985170468399,28.070017920000005,0.4,79]
["","Langford",48.449719999999999,123.50449999999999,12395.696455158586,1.8,0.3,21.052513439999998,0.4,79,null,"","Langford",48.449719999999999,123.50449999999999,12395.696455158586,21.052513439999998,0.4,79]
["","Lillooet",50.686300000000003,121.93675,12184.893728550294,2.1,0.1,20.384179680000003,0.44,83,null,"","Lillooet",50.686300000000003,121.93675,12184.893728550294,20.384179680000003,0.44,83]
["","Lytton",50.233260000000001,121.5814,12183.895653819733,2.8,0.3,29.963630240000001,0.43,82,null,"","Lytton",50.233260000000001,121.5814,12183.895653819733,29.963630240000001,0.43,82]
["","Mackenzie",55.338099999999997,123.09443,12019.25528691916,5.0999999999999996,0.2,48.788364480000013,0.32,71,null,"","Mackenzie",55.338099999999997,123.09443,12019.25528691916,48.788364480000013,0.32,71]
["","Masset",54.01146,132.1472,12589.868844052524,1.8,0.4,22.723347840000002,0.61,98,null,"","Masset",54.01146,132.1472,12589.868844052524,22.723347840000002,0.61,98]
["","McBride",53.301349999999999,120.16846,11950.90096026816,4.3,0.2,41.659471040000007,0.35,74,null,"","McBride",53.301349999999999,120.16846,11950.90096026816,41.659471040000007,0.35,74]
["","McLeod Lake",54.993079999999999,123.04387,12034.506254952039,4.0999999999999996,0.2,39.877247680000004,0.32,71,null,"","McLeod Lake",54.993079999999999,123.04387,12034.506254952039,39.877247680000004,0.32,71]
["","Merritt",50.111310000000003,120.78622,12138.256713142051,1.8,0.3,21.052513439999998,0.44,83,null,"","Merritt",50.111310000000003,120.78622,12138.256713142051,21.052513439999998,0.44,83]
["","Mission City",49.200279999999999,122.42025,12287.759501872479,2.4,0.3,26.399183520000005,0.43,82,null,"","Mission City",49.200279999999999,122.42025,12287.759501872479,26.399183520000005,0.43,82]
["","Montrose",49.078969999999998,117.59237,11971.39374628993,4.0999999999999996,0.1,38.20641328,0.35,74,null,"","Montrose",49.078969999999998,117.59237,11971.39374628993,38.20641328,0.35,74]
["","Nakusp",50.239849999999997,117.80110999999999,11937.391720407941,4.4000000000000004,0.1,40.879748320000012,0.33,72,null,"","Nakusp",50.239849999999997,117.80110999999999,11937.391720407941,40.879748320000012,0.33,72]
["","Nanaimo",49.165880000000001,123.94006,12388.456722921906,2.1,0.4,25.39668288,0.5,88,null,"","Nanaimo",49.165880000000001,123.94006,12388.456722921906,25.39668288,0.5,88]
["","Nelson",49.492809999999999,117.29483,11934.457993371258,4.2,0.1,39.097524960000008,0.33,72,null,"","Nelson",49.492809999999999,117.29483,11934.457993371258,39.097524960000008,0.33,72]
["","Ocean Falls",52.354019999999998,127.69374999999999,12445.929324891082,3.9,0.8,48.120030720000003,0.59,96,null,"","Ocean Falls",52.354019999999998,127.69374999999999,12445.929324891082,48.120030720000003,0.59,96]
["","Osoyoos",49.032299999999999,119.46816,12099.801734597027,1.1000000000000001,0.1,11.473062880000002,0.4,79,null,"","Osoyoos",49.032299999999999,119.46816,12099.801734597027,11.473062880000002,0.4,79]
["","Parksville",49.319339999999997,124.31364000000001,12404.789788566719,2,0.4,24.505571200000002,0.5,88,null,"","Parksville",49.319339999999997,124.31364000000001,12404.789788566719,24.505571200000002,0.5,88]
["","Penticton",49.499139999999997,119.59371,12087.697236779746,1.3,0.1,13.255286240000002,0.45,84,null,"","Penticton",49.499139999999997,119.59371,12087.697236779746,13.255286240000002,0.45,84]
["","Port Alberni",49.233890000000002,124.80555,12440.821037465888,2.6,0.4,29.852241280000001,0.32,71,null,"","Port Alberni",49.233890000000002,124.80555,12440.821037465888,29.852241280000001,0.32,71]
["","Port Alice",50.386139999999997,127.45099999999999,12544.199410932231,1.1000000000000001,0.4,16.485566080000002,0.32,71,null,"","Port Alice",50.386139999999997,127.45099999999999,12544.199410932231,16.485566080000002,0.32,71]
["","Port Hardy",50.720820000000003,127.49666999999999,12528.018210535238,0.9,0.4,14.703342720000002,0.52,90,null,"","Port Hardy",50.720820000000003,127.49666999999999,12528.018210535238,14.703342720000002,0.52,90]
["","Port Mcneill",50.590139999999998,127.08476,12510.371212766484,1.1000000000000001,0.4,16.485566080000002,0.52,90,null,"","Port Mcneill",50.590139999999998,127.08476,12510.371212766484,16.485566080000002,0.52,90]
["","Port Renfrew",48.552970000000002,124.42230000000001,12450.898436094576,1.1000000000000001,0.4,16.485566080000002,0.52,90,null,"","Port Renfrew",48.552970000000002,124.42230000000001,12450.898436094576,16.485566080000002,0.52,90]
["","Powell River",49.835259999999998,124.52476,12391.753818642772,1.7,0.4,21.832236160000001,0.51,89,null,"","Powell River",49.835259999999998,124.52476,12391.753818642772,21.832236160000001,0.51,89]
["","Prince George",53.917059999999999,122.74966999999999,12073.402079978499,3.4,0.2,33.639465920000006,0.37,76,null,"","Prince George",53.917059999999999,122.74966999999999,12073.402079978499,33.639465920000006,0.37,76]
["","Prince Rupert",54.315040000000003,130.32082,12473.397364711953,1.9,0.4,23.614459520000004,0.54,92,null,"","Prince Rupert",54.315040000000003,130.32082,12473.397364711953,23.614459520000004,0.54,92]
["","Princeton",49.458959999999998,120.50615999999999,12149.838976225135,2.9,0.6,35.86724512,0.36,75,null,"","Princeton",49.458959999999998,120.50615999999999,12149.838976225135,35.86724512,0.36,75]
["","Qualicum Beach",49.348230000000001,124.44283,12411.619045808033,2,0.4,24.505571200000002,0.53,91,null,"","Qualicum Beach",49.348230000000001,124.44283,12411.619045808033,24.505571200000002,0.53,91]
["","Queen Charlotte City",53.255940000000002,132.08759000000001,12636.137336892616,1.8,0.4,22.723347840000002,0.61,98,null,"","Queen Charlotte City",53.255940000000002,132.08759000000001,12636.137336892616,22.723347840000002,0.61,98]
["","Quesnel",52.981740000000002,122.49491,12105.957286566094,3,0.1,28.40418480000001,0.31,70,null,"","Quesnel",52.981740000000002,122.49491,12105.957286566094,28.40418480000001,0.31,70]
["","Revelstoke",50.99812,118.19567000000001,11931.08945195048,7.2,0.1,65.830875360000007,0.32,71,null,"","Revelstoke",50.99812,118.19567000000001,11931.08945195048,65.830875360000007,0.32,71]
["","Salmon Arm",50.700099999999999,119.28384,12014.3584907246,3.5,0.1,32.859743200000004,0.39,78,null,"","Salmon Arm",50.700099999999999,119.28384,12014.3584907246,32.859743200000004,0.39,78]
["","Sandspit",53.243029999999997,131.82087999999999,12622.577976927854,1.8,0.4,22.723347840000002,0.78,110,null,"","Sandspit",53.243029999999997,131.82087999999999,12622.577976927854,22.723347840000002,0.78,110]
["","Sechelt",49.474170000000001,123.75456,12360.932364769535,1.8,0.4,22.723347840000002,0.48,87,null,"","Sechelt",49.474170000000001,123.75456,12360.932364769535,22.723347840000002,0.48,87]
["","Sidney",48.650239999999997,123.39901,12378.843467471135,1.1000000000000001,0.2,13.143897280000003,0.42,81,null,"","Sidney",48.650239999999997,123.39901,12378.843467471135,13.143897280000003,0.42,81]
["","Smith River",59.882289999999998,126.43300000000001,11935.368665418233,2.8,0.1,26.621961439999996,0.3,69,null,"","Smith River",59.882289999999998,126.43300000000001,11935.368665418233,26.621961439999996,0.3,69]
["","Smithers",54.782359999999997,127.16855,12274.820938032975,3.5,0.2,34.530577600000008,0.4,79,null,"","Smithers",54.782359999999997,127.16855,12274.820938032975,34.530577600000008,0.4,79]
["","Sooke",48.376109999999997,123.73778,12414.757547362129,1.3,0.3,16.596955040000001,0.48,87,null,"","Sooke",48.376109999999997,123.73778,12414.757547362129,16.596955040000001,0.48,87]
["","Squamish",49.701630000000002,123.15581,12311.008829557921,2.8,0.7,36.646967840000002,0.5,88,null,"","Squamish",49.701630000000002,123.15581,12311.008829557921,36.646967840000002,0.5,88]
["","Stewart",55.941310000000001,129.98788999999999,12353.07655630205,7.9,0.8,83.764497920000011,0.36,75,null,"","Stewart",55.941310000000001,129.98788999999999,12353.07655630205,83.764497920000011,0.36,75]
["","Tahsis",49.927860000000003,126.65654000000001,12520.791739457924,1.1000000000000001,0.4,16.485566080000002,0.34,73,null,"","Tahsis",49.927860000000003,126.65654000000001,12520.791739457924,16.485566080000002,0.34,73]
["","Taylor",56.152569999999997,120.68141,11843.543074383097,2.2999999999999998,0.1,22.166403040000002,0.4,79,null,"","Taylor",56.152569999999997,120.68141,11843.543074383097,22.166403040000002,0.4,79]
["","Terrace",54.518189999999997,128.60315,12368.483129144282,5.4,0.6,58.145037120000012,0.36,75,null,"","Terrace",54.518189999999997,128.60315,12368.483129144282,58.145037120000012,0.36,75]
["","Tofino",49.152430000000003,125.90249,12515.33172336092,1.1000000000000001,0.4,16.485566080000002,0.68,103,null,"","Tofino",49.152430000000003,125.90249,12515.33172336092,16.485566080000002,0.68,103]
["","Trail",49.09657,117.71173,{"$f":"ACOS(SIN(RADIANS(ABS(LAT)))*SIN(RADIANS(C664))+COS(RADIANS(ABS(LAT)))*COS(RADIANS(C664))*COS(RADIANS(D664-ABS(LONG))))*6371","v":11978.754835237871},4.0999999999999996,0.1,38.20641328,0.35,74,null,"","Trail",49.09657,117.71173,11978.754835237871,38.20641328,0.35,74]
[{"$f":"IF(E665=MIN($E$24:$E$684),\"yes\",\"\")","v":""},"Ucluelet",48.941600000000001,125.54634,12503.712594449322,1,0.4,{"$f":"0.8*((F665*0.8*2/3+G665)*20.88543)","v":15.594454400000002},0.68,103,null,{"$f":"IF(P665=MIN($P$24:$P$684),\"yes\",\"\")","v":""},{"$f":"B665","v":"Ucluelet"},{"$f":"C665","v":48.941600000000001},{"$f":"D665","v":125.54634},{"$f":"IF(A665<>\"yes\",E665,\"\")","v":12503.712594449322},{"$f":"H665","v":15.594454400000002},0.68,103]
["","Burnaby",49.229489999999998,123.00257999999999,12324.377144108972,2.9,0.7,37.538079519999997,0.47,86,null,"","Burnaby",49.229489999999998,123.00257999999999,12324.377144108972,37.538079519999997,0.47,86]
["","Cloverdale",49.108620000000002,122.7234,12312.044127991556,2.5,0.2,25.619460799999999,0.44,83,null,"","Cloverdale",49.108620000000002,122.7234,12312.044127991556,25.619460799999999,0.44,83]
["","Haney",49.21698,122.62287000000001,12300.207826154654,2.4,0.2,24.728349120000001,0.44,83,null,"","Haney",49.21698,122.62287000000001,12300.207826154654,24.728349120000001,0.44,83]
["","Ladner",49.090009999999999,123.08201,12336.407393078147,1.3,0.2,14.926120640000001,0.46,85,null,"","Ladner",49.090009999999999,123.08201,12336.407393078147,14.926120640000001,0.46,85]
["","Langley",49.074330000000003,122.55932,12302.951599362605,2.4,0.2,24.728349120000001,0.44,83,null,"","Langley",49.074330000000003,122.55932,12302.951599362605,24.728349120000001,0.44,83]
["","New Westminster",49.205719999999999,122.91096,12319.568420982805,2.2999999999999998,0.2,23.837237439999999,0.44,83,null,"","New Westminster",49.205719999999999,122.91096,12319.568420982805,23.837237439999999,0.44,83]
["","North Vancouver",49.319650000000003,123.06824,12324.21821183041,3,0.3,31.745853600000004,0.45,84,null,"","North Vancouver",49.319650000000003,123.06824,12324.21821183041,31.745853600000004,0.45,84]
["","Richmond BC",49.166589999999999,123.13357000000001,12336.006299698854,1.5,0.2,16.708344000000004,0.45,84,null,"","Richmond BC",49.166589999999999,123.13357000000001,12336.006299698854,16.708344000000004,0.45,84]
["","Surrey",49.186500000000002,122.82313000000001,12314.774336910759,2.4,0.3,26.399183520000005,0.44,83,null,"","Surrey",49.186500000000002,122.82313000000001,12314.774336910759,26.399183520000005,0.44,83]
["","Vancouver",49.261229999999998,123.11393,12330.066157036739,1.8,0.2,19.381679040000005,0.45,84,null,"","Vancouver",49.261229999999998,123.11393,12330.066157036739,19.381679040000005,0.45,84]
["","West Vancouver",49.334899999999998,123.16678,12329.866888682454,2.4,0.2,24.728349120000001,0.48,87,null,"","West Vancouver",49.334899999999998,123.16678,12329.866888682454,24.728349120000001,0.48,87]
["","Vernon",50.267009999999999,119.27200999999999,12032.707771720754,2.2000000000000002,0.1,21.275291360000008,0.4,79,null,"","Vernon",50.267009999999999,119.27200999999999,12032.707771720754,21.275291360000008,0.4,79]
["","Gonzales Hts",48.419460000000001,123.33234,12385.797170422762,1.5,0.3,18.379178400000001,0.56999999999999995,94,null,"","Gonzales Hts",48.419460000000001,123.33234,12385.797170422762,18.379178400000001,0.56999999999999995,94]
["","Mt Tolmie",48.46,123.330833,12383.707045514926,2.1,0.3,23.725848480000003,0.63,99,null,"","Mt Tolmie",48.46,123.330833,12383.707045514926,23.725848480000003,0.63,99]
["","Victoria",48.428420000000003,123.36564,12387.561662571703,1.1000000000000001,0.2,13.143897280000003,0.56999999999999995,94,null,"","Victoria",48.428420000000003,123.36564,12387.561662571703,13.143897280000003,0.56999999999999995,94]
["","Whistler",50.116320000000002,122.95735999999999,12277.73566482046,9.5,0.9,99.693119200000012,0.32,71,null,"","Whistler",50.116320000000002,122.95735999999999,12277.73566482046,99.693119200000012,0.32,71]
["","White Rock",49.022030000000001,122.80364,12321.511491279694,2,0.2,21.163902399999998,0.44,83,null,"","White Rock",49.022030000000001,122.80364,12321.511491279694,21.163902399999998,0.44,83]
["","Williams Lake",52.141669999999998,122.14169,12126.550087130661,2.4,0.2,24.728349120000001,0.35,74,null,"","Williams Lake",52.141669999999998,122.14169,12126.550087130661,24.728349120000001,0.35,74]
["","Youbou",48.866700000000002,124.200001,12420.466877466224,3.5,0.7,42.884749600000006,0.32,71,null,"","Youbou",48.866700000000002,124.200001,12420.466877466224,42.884749600000006,0.32,71]

{"sheet":"Revision Notes","index":6,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":true,"merged":[[2,0,7,0],[8,0,13,0],[14,0,19,0],[20,0,23,0]]}
["Version Number","Details"]
[1.1000000000000001,"- Added Heavy Duty Tri-Pod Supports information"]
[1.2,"- Added logic to ensure that Westeel Structural Roof can only be applied to Stiffened Westeel Flat Bottom Bins."]
[null,"- Updated Guardian Standard BIAB information to 2019 data (BIAB BOM R1.5)."]
[null,"- Updated Guardian Cable Locations column in Tables Tab to better estimate central cable location, and location of 42' radial cable."]
[null,"- Updated equation for Maximum Calculated Cable Length for Hopper Bottom and SSK Bins [ft] to better reflect Guardian cable length in bins with hoppers."]
[null,"- Changed main page to read Version X.X instead of Revision X.X."]
[null,"- Updated VBA code to better set print area."]
[1.3,"- Changed main page to not show any results until all mandatory fields are filled in."]
[null,"- Updated 21' and 24' Upgrade 1 roof capacities."]
[null,"- Changed wording on Westeel hopper availability."]
[null,"- Updated logic for choosing the 42'-54' - 4-rib bracket system."]
[null,"- Updated equations for choosing hangar brackets and tri-pod systems to better reflect logic statements."]
[null,"- Added in Westeel EasyDry SGL Fan Inlet and DBL Fan Inlet bin type options."]
["2.0","- Changed all Guardian naming to SureTrack."]
[null,"- Non-structural roofs that will receive monitoring cables will now be supplied with Rib Caps. Rib Caps will take all of the cable load, therefore the cable load will no longer affect Roof Upgrades by reducing the capacity of the roof."]
[null,"- Main tab will now show how much Peak Load is available if a Central Monitoring Cable is installed in the bin."]
[null,"- Removed Unstiffened SSK offering, and updated Stiffened SSK offering."]
[null,"- The calculation to determine the cable length in Flat Bottom Bins has changed from a clearance of 3' to 2' to match SureTrack's worst case scenario."]
[null,"- Important notes updated to reflect change to SureTrack offering."]
["3.0","- Updated Remaing Peak Load to correctly read Unknown Peak Load Type rating as the Higher Rated Peak Load Type rating."]
[null,"- Changed all Westeel and SureTrack naming to AGI Westeel and AGI SureTrack."]
[null,"- Added Quick Notes and Instructions & Training tabs."]
[null,"- Changed Main tab logo from AGI Westeel to AGI."]
[4,"- Updated Stiffened AGI Westeel Hopper to include 2710 & 2712, 3004-10, and 3304-10 models (ECR A8635)"]

{"sheet":"Other","index":7,"n_rows":46,"n_cols":24,"rows_kept":46,"cut":false,"hidden":true,"merged":[[7,2,10,2],[11,2,18,2],[14,9,20,10],[19,2,20,2],[19,7,20,8],[7,5,8,6],[7,7,11,8],[7,9,12,10],[2,1,2,10],[3,1,5,1],[3,2,5,2],[3,3,5,4],[3,5,5,6],[3,7,5,8],[3,9,5,10]]}
[]
[null,"Non-Structural Roof Capacity Chart:"]
[null,"Maximum Roof Snow Load @ Standard Peak Load"]
[null,"Bin Series","Standard Peak Load","Standard Roof",null,"Upgrade 1",null,"Upgrade 2",null,"Upgrade 3"]
[]
[]
[null,null,"lbs (kN)","psf","kPa","psf","kPa","psf","kPa","psf","kPa",null,null,"Bin Series","R","H","L","3 rad cbl","+4 rad cbl",null,null,null,null,"Bin Series"]
[null,15,"4000 (17.8)",49,2.35,"n/a",null,"n/a",null,"n/a",null,null,null,24,{"$f":"N8/2/COS(RADIANS(30))","v":13.856406460551018},{"$f":"N8/2*TAN(RADIANS(30))","v":6.9282032302755088},{"$f":"O8/2","v":6.9282032302755088},{"$f":"N8/2/2","v":6},null,{"$f":"Q8*COS(RADIANS(30))","v":6},{"$f":"T8*12","v":72},null,null,24]
[null,18,null,49,2.35,null,null,null,null,null,null,null,null,27,15.588457268119894,{"$f":"N9/2*TAN(RADIANS(30))","v":7.7942286340599471},{"$f":"O9/2","v":7.7942286340599471},{"$f":"N9/2/2","v":6.75},null,6.75,{"$f":"T9*12","v":81},null,null,27]
[null,21,null,33,1.58,50,2.39,null,null,null,null,null,null,30,17.320508075688771,8.6602540378443855,8.6602540378443855,7.5,null,7.5,90,null,null,30]
[null,24,null,23,1.1000000000000001,36,1.72,null,null,null,null,null,null,33,19.05255888325765,9.5262794416288248,9.5262794416288248,8.25,null,8.25,99,null,null,33]
[null,27,"5000 (22.2)",26,1.24,42,2.0099999999999998,null,null,null,null,null,null,36,20.784609690826525,10.392304845413264,{"$f":"O12/3","v":6.9282032302755079},null,{"$f":"N12/2/3","v":6},{"$f":"Q12*COS(RADIANS(30))","v":5.9999999999999991},71.999999999999986,{"$f":"N12*12/2-U12","v":144},{"$f":"V12/12","v":12},36]
[null,30,null,22,1.05,34,1.63,43,2.06,null,null,null,null,39,22.516660498395403,11.258330249197702,{"$f":"O13/3","v":7.5055534994651341},null,{"$f":"N13/2/3","v":6.5},{"$f":"Q13*COS(RADIANS(30))","v":6.5},78,{"$f":"N13*12/2-U13","v":156},{"$f":"V13/12","v":13},39]
[null,33,null,16,0.77,26,1.24,36,1.72,47,2.25,null,null,42,24.248711305964282,12.124355652982141,8.0829037686547611,null,7,7.0000000000000009,84.000000000000014,168,14,42]
[null,36,null,26,1.24,33,1.58,42,2.0099999999999998,"n/a",null,null,null,45,25.980762113533157,12.990381056766578,8.6602540378443855,null,7.5,7.5,90,180,15,45]
[null,39,null,24,1.1499999999999999,29,1.39,39,1.87,null,null,null,null,48,27.712812921102035,13.856406460551018,9.2376043070340117,null,8,8,96,192,16,48]
[null,42,null,21,1.01,27,1.29,37,1.77,null,null,null,null,51,29.444863728670914,14.722431864335457,9.8149545762236379,null,8.5,8.5,102,204,17,51]
[null,45,null,18,0.86,26,1.24,35,1.68,null,null,null,null,54,31.176914536239789,15.588457268119894,10.392304845413262,null,9,9,108,216,18,54]
[null,48,null,23,1.1000000000000001,28,1.34,36,1.72]
[null,51,"8000 (35.6)",22,1.05,31,1.48,"n/a",null,null,null,null,null,"Guardian"]
[null,54,null,19,0.91,30,1.44,null,null,null,null,null,null,"Diameter","centre","radius 1","radius 2","radius 3"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,15,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,18,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,21,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,"3 @ 7.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,27,null,"3 @ 7.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,null,"3 @ 7.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,33,null,"3 @ 8.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,36,1,"3 @ 9.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,39,1,"3 @ 11.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,42,1,"4 @ 14.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,45,1,"4 @ 15.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,48,1,"5 @ 16.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,51,1,"6 @ 16.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,54,1,"6 @ 18.67 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,60,1,"7 @ 20.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,null,"3 @ 10.00 ft","8 @ 25.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,72,null,"4 @ 10.00 ft","9 @ 27.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,75,null,"4 @ 10.00 ft","10 @ 28.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,78,null,"4 @ 10.00 ft","10 @ 29.50 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,84,1,"5 @ 16.00 ft","10 @ 32.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,90,1,"6 @ 18.00 ft","12 @ 36.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,96,null,"3 @ 10.00 ft","8 @ 23.83 ft","12 @ 40.17 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,102,null,"3 @ 10.00 ft","8 @ 25.83 ft","17 @ 43.17 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,105,null,"3 @ 9.00 ft","9 @ 26.50 ft","16 @ 44.00 ft"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,108,null,"3 @ 9.00 ft","9 @ 27.00 ft","18 @ 45.00 ft"]