{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Line Power Simulator","Instruction","LPS_LPR_Table"],"not_rendered":{"charts":0,"images":14,"macros":1,"external_links":0,"defined_names":5,"comments":1,"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":"Line Power Simulator","index":0,"n_rows":91,"n_cols":37,"rows_kept":91,"cut":false,"hidden":false,"merged":[[88,10,88,12],[82,12,82,13],[83,12,83,13],[84,12,84,13],[78,12,78,13],[66,3,67,3],[53,28,53,32],[56,29,57,29],[53,1,53,6],[53,16,53,26],[53,8,53,14],[55,3,55,5],[55,19,55,21],[85,28,86,32],[64,9,65,9],[70,10,71,12],[72,10,73,12],[68,9,69,13]]}
[]
[null,null,"1) GIVEN PARAMETERS:"]
[]
[null,null,null,"Remote Load Qualification:",null,null,null,null,null,null,null,null,null,"Cable Selection:"]
[null,null,{"$f":"IF(OR($AD$57<=0, $AD$57>S22), \"out of range\", $AD$57)","v":1},{"$f":"IF(C5=\"out of range\", S22, C5)","v":1},"==> Pout; Remote Equipment Load",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($AD$17,LPS_LPR_Table!$B$26:$C$45,2,FALSE)","v":20},"==> Selected Wire Size",null,null,null,null,null,"Critical Distance - kft =",{"$f":"IF(N40,  \"Equipment NOT compatible\",\nIF(D27<=0, \"Not Capable\",  D27)\n)","v":"Equipment NOT compatible"}]
[null,null,null,{"$f":"IFERROR(IF(AD16=\"Integrated Remote Load\", $D$5, $D$5/$V$63),0)","v":1.0989010989010988},"==> Pin; Remote Equipment Input Power",null,null,null,null,null,null,null,null,{"$f":"VLOOKUP($AD$18,LPS_LPR_Table!$B$50:$C$51,2,FALSE)","v":165},"==> Selected Temperature",null,null,null,null,null,"Critical Distance - km =",{"$f":"IF(N42,  \"-\",\nIF(D27<=0, \"-\",  D28)\n)","v":"-"}]
[null,null,null,{"$f":"N40","v":true},"==> Is remote load setting OK?",null,null,null,null,null,null,null,null,{"$f":"2*(10370/((10^((50-$N$5)*0.0501394))^2))*(1+0.002176*($N$6-68))","v":24.63852559187886},"==> Loop Resistance over Distance"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Text Box =",{"$f":"\"* Equivalent Loop Resistance = \"&ROUND(N7,1)&\" Ohm/kft\"","v":"* Equivalent Loop Resistance = 24.6 Ohm/kft"}]
[null,null,null,"Manual Distance Adjustment:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Type =","Custom Upconverter"]
[null,null,1330,{"$f":"C10","v":1330},"==> Slider Bar 2 (DISTANCE) adjustment",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load Type 1 =","Custom Downconverter"]
[null,null,null,{"$f":"IFERROR(($D$10*$N$7)/J65, 0)","v":32769.23903719888},"==> Equivalent Resistance based on current distance (Slider Bar 2)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Load Type 2 =","Integrated Remote Load"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intermediate Distance =",{"$f":"IF(AND(N42,N40),\nIF(D10>K71, K71, D10),\"\")","v":1329.6250166364694}]
[null,null,null,"Critical Resistance - Condition 1:  (Resistance is limited by the UVLO setting of the Downconverter)"]
[null,null,"EQUATION 1",{"$f":"IFERROR((($F$60*$V$60-$V$60^2)/M47),0)","v":32760.000000000004},"==> Critical resistance:  RLOOP = (Vuc_out * Vdc_cutoff - Vdc_cutoff^2) / (Pin_per_channel)",null,null,null,null,null,null,null,null,null,null,null,null,"5000",null,null,"Distance Slider Range"]
[null,null,null,{"$f":"($D$14/$N$7)*$J$65","v":1329.6250166364694},"==> Equivalent Distance",null,null,null,null,null,null,null,null,null,null,null,null,5,"Selection",null,4,"Selection",null,null,null,null,null,null,"Upconverter Selection Index =","LPS36"]
[null,null,"EQUATION 2",{"$f":"IFERROR(($F$60-SQRT($F$60^2-4*$D$14*M47))/(2*$D$14),  0)","v":5.4945054945054941E-3},"==> Calculated Input Current:  Icalc_max = [Vuc_out  -  SQRT(Vuc_out^2 - 4 * RLOOP * Pin_per_channel)]  /  (2 * RLOOP)",null,null,null,null,null,null,null,null,null,null,null,null,1,75,null,1,10,null,null,null,null,null,null,"Downconverter Selection Index =","LPR48-300"]
[null,null,null,{"$f":"IF($D$16<$V$61,  TRUE,  FALSE)","v":true},"==> Is RLOOP qualified as critical resistance?",null,null,null,null,null,null,null,null,null,null,null,null,2,100,null,2,20,null,null,null,null,null,null,"Wire Size Selection Index =","20 AWG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,3,250,null,3,50,null,null,null,null,null,null,"Installation Type Index =","Aerial Cable Installation, 165°F/74°C"]
[null,null,null,"Critical Resistance - Condition 2:  (Resistance is limited by the Max Current Limit of the Downconverter)",null,null,null,null,null,null,null,null,null,null,null,null,null,4,500,null,4,100]
[null,null,"EQUATION 3",{"$f":"IFERROR((($F$60*$V$61-M47)/$V$61^2), 0)","v":1532.7130179275121},"==> Critical resistance:  RLOOP = [Vuc_out  *  Imax_current_limit  - Pin_per_channel] / ( Imax_current_limit)^2",null,null,null,null,null,null,null,null,null,null,null,null,5,1000,null,5,500,null,null,null,null,null,null,"Custom Selection =",{"$f":"IF(AD16=\"Integrated Remote Load\",\"Maximum Input Power Consumption =\", \"Total Output Power (per module) =\")","v":"Total Output Power (per module) ="}]
[null,null,null,{"$f":"($D$20/$N$7)*$J$65","v":62.207984492087945},"==> Equivalent Distance",null,null,null,null,null,null,null,null,null,null,null,null,6,5000,null,6,1000]
[null,null,"EQUATION 4",{"$f":"IFERROR($F$60-$V$61*$D$20,FALSE)","v":4.4853106077595726},"==> Calculated Vdc input terminal voltage:   Vdc_in  = Vuc_out  -  Imax_current_limit  * RLOOP",null,null,null,null,null,null,null,null,null,null,null,null,7,10000]
[null,null,null,{"$f":"IF(AND(D22>=V60, D22<F60, D20>0),  TRUE,  FALSE)","v":false},"==> Is RLOOP qualified as critical resistance?",null,null,null,null,null,null,null,null,null,null,null,null,"Selected Range =",{"$f":"VLOOKUP($R$15,$R$16:$S$22,2,FALSE)","v":1000},null,"Dynamic Range =",{"$f":"IF(D27<=0, 1,IFERROR($D$27,1))","v":1329.6250166364694}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Max Range =",{"$f":"IF(V23>30000, 30000,ROUNDUP(V23,0))","v":1330},null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Upconverter Input Validation:"]
[null,null,null,"Dominant Critical RLOOP:",null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(D67/F59,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($G$59>0, $G$59<300)","v":true},"AND($G$59>0, $G$59<300)"]
[null,null,null,{"$f":"IF(N42,\nIF(D17,D14, IF(D23,D20,\n\"0\")))","v":32760.000000000004},"==> Critical resistance:  MINIMUM(Equation 1+2, Equation 3+4)",null,null,null,null,null,null,null,{"$f":"ROUNDUP(V59/D67,0)","v":4},null,null,null,null,"Total Pin =",{"$f":"IFERROR($S$30*D67,\"\")","v":1.0989010989010988},null,"Total Pout =",{"$f":"IFERROR($V$30*D67,\"\")","v":2.0879120879120876},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($G$60>0, $G$60<751, $G$60>V60)","v":true},"AND($G$60>0, $G$60<750)"]
[null,null,null,{"$f":"($D$26/$N$7)*$J$65","v":1329.6250166364694},"==> Equivalent Distance",null,null,null,null,null,null,null,null,null,null,null,null,"Total Pin Text =",{"$f":"IF(D67>1, \"Total Input Power for \" &D67& \" pairs = \", \"Total Input Power for \" &D67& \" pair  = \")","v":"Total Input Power for 1 pair  = "},null,"Total Pout Text =",{"$f":"IF(D67>1, \"Total Output Power for \" &D67& \" pairs = \", \"Total Output Power for \" &D67& \" pair  = \")","v":"Total Output Power for 1 pair  = "},null,null,null,null,{"$f":"\"Total # of pairs (AWG\" &N5& \") for remote load   = \"","v":"Total # of pairs (AWG20) for remote load   = "},null,null,null,{"$f":"IF(D27<=0,  \"\", D67*J65)","v":1},null,null,null,null,{"$f":"AND($G$61>0, $G$61<100, $G$61>V61)","v":true},"AND($G$61>0, $G$61<100, $G$61>V61)"]
[null,null,null,{"$f":"$D$27*0.3048","v":405.26970507079591},"==> Equivalent Distance (km)",null,null,null,null,null,null,null,null,null,null,null,null,"Input Current =",{"$f":"IFERROR(D35*1000,\"\")","v":5.4945054945054936},null,"LPS Current =",{"$f":"IFERROR(D35*1000,\"\")","v":5.4945054945054936},null,null,null,null,"Unconverter Total Input Current (@48VDC)  = ",null,null,null,{"$f":"IFERROR(($V$30*D67/F63)/48,\"\")","v":4.7280617932791841E-2},null,null,null,null,{"$f":"AND($G$62>0, $G$62<10000, $G$62>=AJ33)","v":true},"AND($G$62>0, $G$62<10000, $G$62>AJ33)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Voltage =",{"$f":"IF(AND(N42,N40), D36, \"\")","v":200},null,"LPS Voltage =",{"$f":"IF(AND(N42,N40), F60, \"\")","v":380},null,null,null,null,"Unconverter Total Input Power (@48VDC)  = ",null,null,null,{"$f":"IFERROR($V$30*D67/F63,\"\")","v":2.2694696607740084},null,null,null,null,{"$f":"AND($G$63>0, $G$63<=100)","v":true},"AND($G$63>0, $G$63<=100)"]
[null,null,null,"Intermediate to Max Display Value:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Power =",{"$f":"IF(AND(N42,N40), G42, \"\")","v":1.0989010989010988},null,"LPS Power =",{"$f":"IFERROR(M84+S30,\"\")","v":2.0879120879120876},null,null,null,null,null,null,null,null,null,null,null,null,"Input Validation:",{"$f":"AND(AJ25,AJ26,AJ27,AJ28,AJ29)","v":true}]
[null,null,null,{"$f":"MIN(D26,D11)","v":32760.000000000004},"==> Intermediate RLOOP  ",null,null,null,null,null,null,null,null,null,null,null,null,"Total Pin per module Text =",{"$f":"\"Input Power per Downconverter  = \"","v":"Input Power per Downconverter  = "},null,"Total Pout  per module Text =",{"$f":"\"Output Power per Upconverter converter  = \"","v":"Output Power per Upconverter converter  = "}]
[null,null,null,{"$f":"($D$31/$N$7)*$J$65","v":1329.6250166364694},"==> Intermediate Distance (kft)",null,null,null,null,null,null,null,null,null,null,null,null,"Total Pin per module  =",{"$f":"D6/W59","v":0.10989010989010987}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of LPS36",null,null,null,null,"Pin per Custom Downconverter Input =",{"$f":"IFERROR(V62/V59,FALSE)","v":75},null,null,null,"Effective Remote Load per channel =",{"$f":"IF($AD$16=\"Custom Downconverter\", AE33,\nIF($AD$16=\"Integrated Remote Load\",AE34,\nV62/V59))","v":75}]
[null,null,null,"Instantaneous Voltage & Current:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LPS36 Message:",{"$f":"\"Required # of Upconverter Modules (\" &AD15& \")  = \"","v":"Required # of Upconverter Modules (LPS36)  = "},null,null,null,null,{"$f":"IF(D27<=0,\"\",IF(F59>=V59,ROUNDUP(D67/F59,0),ROUNDUP(V59/D67,0)))","v":1},null,{"$f":"IF(AND(N42,N40), Y34, \"\")","v":1},null,null,"Pin per Integrated Remote Load Input =",{"$f":"IFERROR(D6/V59,FALSE)","v":0.27472527472527469}]
[null,null,null,{"$f":"IF(AND($N$42,$D$7),\nIFERROR(((F60-SQRT(F60^2-4*D31*(D6/D67)))/(2*D31)),  0),\n\"-\"\n)","v":5.4945054945054941E-3},"==> Idc_in_max = [Vuc_out  -  SQRT(Vuc_out^2 - 4 * RLOOP * Pin)]  /  (2 * RLOOP)",null,null,null,null,null,null,null,null,null,null,null,null,null,"LPR Message:",{"$f":"\"Required # of Downconverter Modules (\" &AD16& \")  =  \"","v":"Required # of Downconverter Modules (LPR48-300)  =  "},null,null,null,null,{"$f":"IF(D27<=0,  \"\", ROUNDUP(D67/V59,0))","v":1},null,{"$f":"IF(AND(N42,N40), Y35, \"\")","v":1}]
[null,null,null,{"$f":"IF(AND($N$42,$D$7),\nIFERROR(($F$60+SQRT($F$60^2-4*(1)*($D$6/$D$67)*($D$31)))/(2*1),  0),\n\"-\"\n)","v":200},"==> Vdc_in_min:   Vdc_cutoff = Vuc_out +/- SQRT(Vuc_out^2 - 4(1)(Pin)(RLOOP)) / 2(1)",null,null,null,null,null,null,null,null,"Design Note:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUATION1/2",{"$f":"OR($AD$16=$AD$10,$AD$16=$AD$11)","v":false},"OR($AD$16=$AD$10,$AD$16=$AD$11)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(NOT($N$40), D67<=0, IF($AD$15=$AD$9, NOT(AND(AJ25,AJ26,AJ27,AJ28,AJ29)),FALSE)),\"Parameter values highlighted in Red are NOT valid or compatible with the system. Enter a new proper value.\",\nIF(NOT($N$42),\"System is NOT capable.  Reduce the load or increase the total number of 100VA Input Channels to \"&(N47)&\".\",\nIF(D10<D27,\"Operating condition at intermediate distance of \"&V12&\"kft...\",\nIF(AND($D$17,$D$7),\"Maximum Loop Distance is limited by the maximum allowable line voltage drop based from selected wire size.\",\nIF(AND($D$23,$D$7),\"Maximum Loop Distance is limited by the input current rating of the selected Downconverter.\")))))","v":"Maximum Loop Distance is limited by the maximum allowable line voltage drop based from selected wire size."},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"EQUATION2/2",{"$f":"OR($W$59<=0, $W$59<$AC$34,$W$60>=$F$60, $W$60<=0,$W$61>=$F$61, $W$61<=0,$W$62<=0,  $W$62/$W$59>$F$62,$W$63<=0, $W$63>1, D67<=0, AD57<=0, J65<=0)","v":true},"OR($W$59<=0, $W$59<$AC$34,$W$60>=$F$60, $W$60<=0,$W$61>=$F$61, $W$61<=0,$W$62<=0,  $W$62/$W$59>$F$62,$W$63<=0, $W$63>1, D67<=0, AD57<=0, J65<=0)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($W$59>0, AE34<F62)","v":true},"AND($W$59>0, AE34<F62)",null,null,null,{"$f":"AND($W$59>0, AE33<=F62)","v":true},"AND($W$59>0, AE33<F62)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Compatibility of Selected Equipmentt:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($W$60>0,  $W$60<=$F$60)","v":true},"AND($W$60>0,  $W$60<=$F$60)",null,null,null,{"$f":"AND($W$60>0,  $W$60<$F$60)","v":true},"AND($W$60>0,  $W$60<=$F$60)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$15=$AD$9, $AJ$30, $AE$44)","v":true},"==> Returns TRUE if equipment is compatible (First checking)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AND($W$61>0,  $W$61<$F$61)","v":true},"AND($W$61>0,  $W$61<$F$61)",null,null,null,{"$f":"AND($W$61>0,  $W$61<$F$61)","v":true},"AND($W$61>0,  $W$61<$F$61)"]
[null,null,null,null,null,"Max Line Loss  per pair (W) =",{"$f":"IF(D27<=0, \"-\", D35^2*D31)","v":0.98901098901098894},null,null,null,null,null,null,"System Capability:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Alpha Standard Downconverter Validation:",{"$f":"AND(F60>V60, F61>V61,F62>AJ33)","v":true},null,null,null,null,{"$f":"AND($W$62>0, $W$62<=10000)","v":true},"AND($W$62>0, $W$62<=10000)"]
[null,null,null,null,null,"Max Remote Input Load per pair (W) =",{"$f":"IF(D27<=0, \"-\",  D35*D36)","v":1.0989010989010988},null,null,null,null,null,null,{"$f":"IF(AND($N$40,$D$67>=$N$46,$N$46>0,$D$67>0,$J$65>0,OR(D17,D23)),TRUE,FALSE)","v":true},"==> Returns TRUE if system is capable",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Integrated Remote Load Validation:",{"$f":"AND(AE38,AE39,AE40)","v":true},null,null,null,null,{"$f":"AND($W$63>0, $W$63<=1)","v":true},"AND($W$63>0, $W$63<=100)"]
[null,null,null,null,null,"LPS Max Output Delivery per pair (W) =",{"$f":"IF(D27<=0,\"-\", G41+G42)","v":2.0879120879120876},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Custom Downconverter Validation:",{"$f":"AND(AJ38,AJ39,AJ40,AJ41,AJ42)","v":true}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Cable Pair Conditional Statement:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Combined Validation:",{"$f":"IF($AD$16=AD10,AE43,\nIF($AD$16=AD11,AE42, AE41))","v":true}]
[null,null,null,null,null,"Total Line Loss (W) =",{"$f":"IF(D27<=0, \"-\", G41*D67)","v":0.98901098901098894}]
[null,null,null,null,null,"Total Remote Input Load (W) =",{"$f":"IF(D27<=0, \"-\", G42*D67)","v":1.0989010989010988},null,null,null,null,"Max # of 100VA Channels =",{"$f":"MAX($D$67,$N$46)","v":1},{"$f":"IFERROR(IF(N49,N47, ROUNDDOWN(D6/AJ33,0)+1), FALSE)","v":1},"==> Minimum number of Input pairs for Downconverter (based on Total Load Power & Eff)"]
[null,null,null,null,null,"Total LPS Output Delivery(W) =",{"$f":"IF(D27<=0, \"-\", G45+G46)","v":2.0879120879120876},null,null,null,null,"Pin per input channel =",{"$f":"D6/M46","v":1.0989010989010988},{"$f":"IFERROR(ROUNDUP(AD57/AJ33,0),FALSE)","v":1},"==> Suggested Minimum number of LPS channels based on Load"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Downconverter Output Multiple (if exacr value):",{"$f":"IF(AND($AD$16=$AD$10, (D6/$V$62-TRUNC(D6/$V$62))>0), FALSE, TRUE)","v":true}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision 4.3  (May 2020)"]
[null,"Upconverter Parameters",null,null,null,null,null,null,"Outside Plant (OSP) Parameters",null,null,null,null,null,null,null,"Downconverter Parameters",null,null,null,null,null,null,null,null,null,null,null,"Remote Load"]
[]
[null,null,null,"Select Upconverter Model:",null,null,null,null,null,"Select Wire Size (AWG):",null,null,null,null,null,null,null,null,null,"Select Downconverter Model:",null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$16=\"Integrated Remote Load\", \"Set Maximum Input Power Consumption:\",  \"Set Maximum Load:\")","v":"Set Maximum Load:"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
[]
[null,null,null,null,"Number of Output Channels =",{"$f":"IF($AD$15=AD9,  G59,  VLOOKUP($AD$15,LPS_LPR_Table!B2:G5,6,FALSE))","v":4},1,null,null,null,null,null,null,null,null,null,null,null,null,null,"# of Input Channels =",{"$f":"IF(OR($AD$16=AD10,$AD$16=AD11),  ROUND(W59,0),  VLOOKUP($AD$16,LPS_LPR_Table!B11:G19,6,FALSE))","v":4},10,null,null,null,null,null,null,16]
[null,null,null,null,"Rated Output Voltage =",{"$f":"IF($AD$15=AD9,  G60,  VLOOKUP($AD$15,LPS_LPR_Table!B2:G5,2,FALSE))","v":380},380,null,null,"Select Type of Installation:",null,null,null,null,null,null,null,null,null,null,"Minimum Operating Input Voltage =",{"$f":"IF(OR($AD$16=AD10,$AD$16=AD11),  W60,  VLOOKUP($AD$16,LPS_LPR_Table!B11:G19,2,FALSE))","v":200},200]
[null,null,null,null,"Maximum  Current Limit (per channel) =",{"$f":"IF($AD$15=AD9,  G61,  VLOOKUP($AD$15,LPS_LPR_Table!B2:G5,3,FALSE))","v":0.255},4,null,null,null,null,null,null,null,null,null,null,null,null,null,"Input Current Limit (per channel) =",{"$f":"IF(OR($AD$16=AD10,$AD$16=AD11),  W61,  VLOOKUP($AD$16,LPS_LPR_Table!B11:G19,3,FALSE))","v":0.245},0.24]
[null,null,null,null,"Maximum Output Power (per channel) =",{"$f":"IF($AD$15=AD9,  G62,  VLOOKUP($AD$15,LPS_LPR_Table!B2:G5,4,FALSE))","v":96},1500,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AD20","v":"Total Output Power (per module) ="},{"$f":"IF(OR($AD$16=AD10,$AD$16=AD11),  W62,  VLOOKUP($AD$16,LPS_LPR_Table!B11:G19,4,FALSE))","v":300},1500]
[null,null,null,null,"Module Efficiency =",{"$f":"IF($AD$15=AD9,  G63,  VLOOKUP($AD$15,LPS_LPR_Table!B2:G5,5,FALSE))","v":0.92},1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Module Efficiency =",{"$f":"IF(OR($AD$16=AD10,$AD$16=AD11),  W63,  VLOOKUP($AD$16,LPS_LPR_Table!B11:G19,5,FALSE))","v":0.91},1]
[null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$15=AD9, \"Number of bonded conductors per channel:\",  \"Number of bonded conductors per 100VA channel:\")","v":"Number of bonded conductors per 100VA channel:"}]
[null,null,null,null,null,null,null,null,null,1]
[null,null,null,{"$f":"IF($AD$15=AD9, \"Total Number of Channels:\",  \"Total Number of 100VA Channels:\")","v":"Total Number of 100VA Channels:"}]
[null,null,null,1]
[]
[null,null,null,null,null,null,null,null,null,"Maximum Span Distance ="]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(N40),  \"Not Compatible\",\nIF(NOT(N42), \"Not Capable\",  D27)\n)","v":1329.6250166364694}]
[]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NOT(N40),  \" \",\nIF(NOT(N42), \" \",  D28)\n)","v":405.26970507079591}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,"Equivalent Loop Resistance =",{"$f":"IF(AND(N42,N40),  D31, \"\")","v":32760.000000000004}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($AD$15=AD9, \"Line Loss per  channel =\",  \"Line Loss per 100VA channel =\")","v":"Line Loss per 100VA channel ="},{"$f":"IF(AND(N42,N40), $G$41, \"\")","v":0.98901098901098894}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":" IF(D67>1, \"Total Line Loss for ALL channels =\", \"Total Line Loss for 1 100VA channel =\")","v":"Total Line Loss for 1 100VA channel ="},{"$f":"IF(AND(N42,N40), $G$41*D67, \"\")","v":0.98901098901098894}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"ROUNDUP(D67/V59,0)","v":1}]

{"sheet":"Instruction","index":1,"n_rows":84,"n_cols":4,"rows_kept":84,"cut":false,"hidden":true,"merged":[]}
[]
[null,"How To Use This Calculator Tool:"]
[]
[null,"Note: In order to use the full functionality of this tool, make sure that the Macro is ENABLED."]
[]
[null,null,"STEP 1:  ","Enter the maximum power of the remote load either by typing the value inside the box or by using the slider bar."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 2:  ","Select the Alpha Upconverter module for the application using the pull-down menu. The specs and rating of the selected Upconverter is shown automatically."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 3:  ","Select the Alpha Downconverter module for the application using the pull-down menu. The specs and rating of the selected Downconverter is shown automatically."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 4:  ","Select the Cable Size from the pull-down menu."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 5:  ","Select the Type of Installation from the pull-down menu."]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 6:  ","Select how many number of conductors that will be bonded or connected together in parallel in order to reduce further the line impedance or increase reliability."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 7:  ","Select how many number of 100VA channels from the Upconverter that will be required. "]
[null,null,null,"If the number of channels selected is not enough, the calculator will prompt a warning message \"Not Capable\". If this is the case, increase the number of  100VA channels"]
[null,null,null,"to the appropriate minimum value required as indicated in the status window."]
[]
[]
[]
[]
[]
[]
[]
[null,null,"STEP 8:  ","This function is optional. It will allow calculation of the actual operating parameters (Iin, Vin, Pin, line loss, etc.) for specific distance that's less than the maximum hypothetical value."]

{"sheet":"LPS_LPR_Table","index":2,"n_rows":51,"n_cols":10,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
[null,"Upconverters"]
[null,"Model","Min. Vout (V)","Min. Iout (A)","Min. Pout (W)","Efficiency","# of Output Channels"]
[null,"LPS36",380,0.255,96,0.92,4]
[null,"Custom Upconverter",380,0.25,92,0.9,4]
[]
[]
[]
[]
[null,"Downconverters"]
[null,"Model","Input Cut-off Voltage (V)","Max Current Consumption (A)","Output Power (W)","Efficiency","# of Input Channels",null,null,"Max Input Power @ Vin=200V (W)"]
[null,"LPR48-300",200,0.245,300,0.91,4,null,null,{"$f":"C11*D11","v":49}]
[null,"LPR48-150",200,0.245,150,0.89,2,null,null,{"$f":"C12*D12","v":49}]
[null,"LPR48-60",200,0.245,60,0.88,1,null,null,{"$f":"C13*D13","v":49}]
[null,"LPR48-30",200,0.245,30,0.87,1,null,null,{"$f":"C14*D14","v":49}]
[null,"LPR12-60",200,0.245,60,0.85,1,null,null,{"$f":"C15*D15","v":49}]
[null,"LPR12-30",200,0.245,30,0.85,1,null,null,{"$f":"C16*D16","v":49}]
[null,"CSM46",200,0.23499999999999999,150,0.85,2,null,null,{"$f":"C17*D17","v":47}]
[null,"Custom Downconverter",200,0.245,100,0.95,2,null,null,{"$f":"C18*D18","v":49}]
[null,"Integrated Remote Load",200,0.245,100,0.95,2,null,null,49]
[]
[]
[]
[]
[null,"Cable Size"]
[null,"AWG","Size"]
[null,"30 AWG",30]
[null,"28 AWG",28]
[null,"26 AWG",26]
[null,"25 AWG",25]
[null,"24 AWG",24]
[null,"23 AWG",23]
[null,"22 AWG",22]
[null,"21 AWG",21]
[null,"20 AWG",20]
[null,"19 AWG",19]
[null,"18 AWG",18]
[null,"16 AWG",16]
[null,"14 AWG",14]
[null,"12 AWG",12]
[null,"10 AWG",10]
[null,"8 AWG",8]
[null,"6 AWG",6]
[null,"4 AWG",4]
[null,"2 AWG",2]
[null,"1 AWG",1]
[]
[]
[null,"Temperature"]
[null,"Temp","Size"]
[null,"Underground Cable Installation, 65°F/18°C",65]
[null,"Aerial Cable Installation, 165°F/74°C",165]