{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Main","Data"],"not_rendered":{"images":2,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Main","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"merged":[[1,1,1,6],[2,1,2,2],[2,4,2,6],[21,2,23,2],[21,4,23,6],[25,4,28,6]]}
[]
[null,"Rabail Power Cable Design Tool (V1.0)\nDeveloped by Rabail Technologies"]
[null,"Input Data",null,null,"Results"]
[null,"HP",{"v":5.5,"d":"5.50"},null,"Safety Factor",{"$f":"C18","v":"Motors (continuous)"},{"$f":"VLOOKUP(C18,Data!A123:C127,3,FALSE)","v":1.25}]
[null,"Voltage (V)",{"v":400,"d":"400.00"},null,"Ambient Temp Factor",{"$f":"C17","v":45},{"$f":"IF(C15=\"PVC\",VLOOKUP(C17,Data!A100:B107,2,FALSE),VLOOKUP(C17,Data!A110:B119,2,FALSE))","v":0.82}]
[null,"Phase","Three Phase",null,"Installation Factor, Fin",{"$f":"C9","v":"Free air"},{"$f":"VLOOKUP($C$9,Data!$A$85:$C$89,3,FALSE)","v":{"v":1,"d":"1.00"}}]
[null,"Efficiency (Decimal)",0.85,null,"Grouping Factor, Fgr",{"$f":"C10","v":2},{"$f":"IF(C18=\"solar DC\",0.75,IF($C$10>12,0.5,(VLOOKUP($C$10,Data!$A$33:$B$44,2,FALSE))))","v":{"v":0.8,"d":"0.80"}}]
[null,"Power Factor (Decimal)",0.85,null,"Start/Hr, Fs",{"$f":"C11","v":1},{"$f":"IF(C18=\"Solar DC\",\"N/A for Sol dc\",IF($C$11>30,1.4,(VLOOKUP($C$11,Data!$A$50:$C$79,3,FALSE))))","v":{"v":1,"d":"1.00"}}]
[null,"Installation Method","Free air",null,"Motor Start Multiplier, Msm",{"$f":"C16","v":"DOL"},{"$f":"IF(C18=\"solar dc\",\"N/A for Sol dc\",IF($C$6=\"Single Phase\",4,VLOOKUP(C16,Data!A93:B96,2,FALSE)))","v":{"v":6,"d":"6.00"}}]
[null,"Nos. of Cable in Conduit/Burried Togther (Nos)",{"v":2,"d":"2.00"},null,"Full Load Current, FLC","Amp",{"$f":"IF(C18=\"Solar DC\",C19*C21,IF($C$6=\"three phase\",($C$4*746)/($C$7*$C$8*$C$5*SQRT(3)),(($C$4*746)/($C$7*$C$8*$C$5))))","v":{"v":8.196775621055485,"d":"8.20"}}]
[null,"Nos. of Starts/hr (important due to inrush current)",{"v":1,"d":"1.00"},null,"Design Current, FLC xSFxFs","Amp",{"$f":"IF(C18=\"Solar DC\",G10*G4,G10*G8*G4)","v":{"v":10.245969526319357,"d":"10.25"}}]
[null,"Cable Length (m)",{"v":40,"d":"40.00"},null,"Inrush Current, FLCxMsm","Amp",{"$f":"IF(C18=\"Solar DC\",\"N/A for Sol dc\",G10*G9)","v":{"v":49.180653726332906,"d":"49.18"}}]
[null,"Selected Cable (mm²)",{"v":2.5,"d":"2.50"},null,"Required Ampacity, AMPr","Amp",{"$f":"G11/G5/G6/G7","v":{"v":15.618855985242922,"d":"15.62"}}]
[null,"Cable Material","Copper",null,"Running Voltage Drop, VDr (V)","Volt",{"$f":"IF(AND(C14=\"Copper\",C18=\"Solar DC\",C21>=1),2*C12*G11*0.0175/C13,IF(AND(C14=\"Copper\",C18=\"Solar DC\",C21<=0),\"Nos of Array Shall be atleast 1\",IF(AND(C18=\"Solar DC\",C14<>\"Copper\"),\"Select Copper Cable for Solar\",IF(AND($C$6=\"three phase\",$C$14=\"copper\"),SQRT(3)*$C$12*$G$11*0.0175/$C$13,IF(AND($C$6=\"three phase\",$C$14=\"aluminium\"),SQRT(3)*$C$12*$G$11*0.0282/$C$13,IF(AND($C$6=\"single phase\",$C$14=\"copper\"),2*$G$11*$C$12*0.0175/$C$13,IF(AND($C$6=\"single phase\",$C$14=\"almunium\"),2*$G$11*$C$12*0.0282/$C$13,0)))))))","v":{"v":4.969031141868514,"d":"4.969"}}]
[null,"Insulation Material","PVC",null,"Running VDr %",{"$f":"IF(C18=\"Solar DC\",\"Keep it below 2%\",\"Keep it 3% to 5%. \n3% is Best\")","v":"Keep it 3% to 5%. \n3% is Best"},{"$f":"IF(G14=\"Select Copper Cable for Solar\",\"Select Copper Cable for Solar\",IF(G14=\"Nos of Array Shall be atleast 1\",\"Nos of Array Shall be atleast 1\",IF(C18=\"Solar DC\",G14/C20,G14/C5)))","v":{"v":0.012422577854671284,"d":"1.24%"}}]
[null,"Motor Starting Method","DOL",null,"Starting Voltage Drop, VDs (V)","Volt",{"$f":"IF(C18=\"Solar DC\",\"N/A for Sol dc\",IF(AND($C$6=\"three phase\",$C$14=\"copper\"),SQRT(3)*$C$12*$G$12*0.0175/$C$13,IF(AND($C$6=\"three phase\",$C$14=\"aluminium\"),SQRT(3)*$C$12*$G$12*0.0282/$C$13,IF(AND($C$6=\"single phase\",$C$14=\"copper\"),2*$G$12*$C$12*0.0175/$C$13,IF(AND($C$6=\"single phase\",$C$14=\"almunium\"),2*$G$12*$C$12*0.0282/$C$13,0)))))","v":{"v":23.85134948096886,"d":"23.851"}}]
[null,"Ambeint Temp (Use 50 Deg C for Pakistan)",45,null,"Starting VDs %","Keep< 10%",{"$f":"IF(C18=\"Solar DC\",\"N/A for Sol dc\",G16/C5)","v":{"v":0.059628373702422154,"d":"5.96%"}}]
[null,"Load Type","Motors (continuous)",null,"Available Ampacity, AMPa","Amp",{"$f":"IF(AND($C$14=\"copper\",$C$15=\"pvc\"),VLOOKUP(C13,Data!$A$2:$C$14,2,FALSE),IF(AND($C$14=\"copper\",$C$15=\"xlpe\"),VLOOKUP($C$13,Data!$A$2:$C$14,3,FALSE),IF(AND($C$14=\"aluminium\",$C$15=\"pvc\"),VLOOKUP($C$13,Data!$A$18:$C$29,2,FALSE),VLOOKUP($C$13,Data!$A$18:$C$29,3,FALSE))))","v":{"v":20,"d":"20.00"}}]
[null,"Solar Panel Short Circuit Current, Isc",{"v":8,"d":"8.00"},null,"Difference of AMPa & AMPr","Must >= 0",{"$f":"G18-G13","v":{"v":4.381144014757078,"d":"4.38"}}]
[null,"Single Array Open Circuit Voltage, Voc",{"v":600,"d":"600.00"},null,"Ampacity Status","Must = Pass",{"$f":"IF(G18=\"n/a\",\"Fail (Cable Size Not Available)\",IF($G$18>=$G$13,\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,"Nos. of Arrays",{"v":1,"d":"1.00"},null,"Overall Status","Must = Pass",{"$f":"IF(AND(C18=\"Solar DC\",G15<2%,G20=\"PASS\"),\"PASS\",IF(AND(G15<=5%,G17<=10%,G20=\"PASS\"),\"PASS\",\"FAIL\"))","v":"PASS"}]
[null,null,"Conclusion",null,{"$f":"IF(G21=\"PASS\",IF($C$18=\"Solar DC\",CONCATENATE(\"Solar Cable Voltage Rating Shall be Above \",$C$20,\" Volts.\",\" Use \",$C$14,$C$15,\" Cable of \",$C$13,\" Sq mm, \",$C$12,\" mtr Long\"),IF(AND($C$18<>\"Solar DC\",$C$6=\"Single Phase\",$C$5<=230),CONCATENATE(\"For Single Phase \",$C$5,\" Volts System Use \",$C$14,$C$15,\", atleast 300/500 Volt, 2 Core Cable, \",$C$13,\" Sq mm, \",$C$12,\" mtr Long\"),IF(AND($C$18<>\"Solar DC\",$C$6=\"Three Phase\",$C$5>=300,$C$5<=455),CONCATENATE(\"For Three Phase \",$C$5,\" Volts System Use \",$C$14,$C$15,\", atleast 450/750 Volt, 3 Core Cable, \",$C$13,\" Sq mm, \",$C$12,\" mtr Long\"),\"Check Cable Voltage or Phase or Load Type\"))),IF(AND(G21=\"FAIL\",C18=\"Solar DC\",G14<>\"Nos of Array Shall be atleast 1\"),\"Selected Cable is NOT Suitable for Required Solar System, Please Redesign\",IF(G14=\"Nos of Array Shall be atleast 1\",\"Please Enter Nos of Arrays\",CONCATENATE(\"Selected \",$C$14,$C$15,\" Cable of Diameter \",$C$13,\"sq mm is NOT Suitable for \",$C$4,\" HP and \",$C$12,\" mtr Length. Redesign Please.\"))))","v":"For Three Phase 400 Volts System Use CopperPVC, atleast 450/750 Volt, 3 Core Cable, 2.5 Sq mm, 40 mtr Long"}]

{"sheet":"Data","index":1,"n_rows":127,"n_cols":3,"rows_kept":127,"hidden":true,"merged":[[0,0,0,2],[15,0,15,2],[97,0,97,1],[107,0,107,1]]}
["Ampacity"]
["Size (mm²)","Copper (A)pvc","Copper (A) xlpe"]
[{"v":1,"d":"1.00"},{"v":11,"d":"11.00"},{"v":14,"d":"14.00"}]
[{"v":1.5,"d":"1.50"},{"v":14,"d":"14.00"},{"v":18,"d":"18.00"}]
[{"v":2.5,"d":"2.50"},{"v":20,"d":"20.00"},{"v":26,"d":"26.00"}]
[{"v":4,"d":"4.00"},{"v":26,"d":"26.00"},{"v":34,"d":"34.00"}]
[{"v":6,"d":"6.00"},{"v":32,"d":"32.00"},{"v":44,"d":"44.00"}]
[{"v":10,"d":"10.00"},{"v":45,"d":"45.00"},{"v":61,"d":"61.00"}]
[{"v":16,"d":"16.00"},{"v":61,"d":"61.00"},{"v":82,"d":"82.00"}]
[{"v":25,"d":"25.00"},{"v":80,"d":"80.00"},{"v":108,"d":"108.00"}]
[{"v":35,"d":"35.00"},{"v":100,"d":"100.00"},{"v":135,"d":"135.00"}]
[{"v":50,"d":"50.00"},{"v":125,"d":"125.00"},{"v":170,"d":"170.00"}]
[{"v":70,"d":"70.00"},{"v":160,"d":"160.00"},{"v":215,"d":"215.00"}]
[{"v":95,"d":"95.00"},195,260]
[]
["Ampacity"]
["Size (mm²)","Aluminium (A)pvc","Aluminium (A) xlpe"]
[1,"N/A","N/A"]
[1.5,"N/A","N/A"]
[2.5,16,20]
[4,21,26]
[6,27,34]
[10,36,46]
[16,48,61]
[25,63,80]
[35,78,100]
[50,95,125]
[70,120,160]
[95,145,195]
[]
[]
["No. of loaded cables / circuits","Grouping factor (Kgroup)"]
[1,1]
[2,0.8]
[3,0.7]
[4,0.65]
[5,0.65]
[6,0.65]
[7,0.6]
[8,0.6]
[9,0.6]
[10,0.55]
[11,0.55]
[12,0.55]
[">12",0.5]
["Loaded” means actually carrying current, not spare cables"]
[]
[]
["Starts per hour","Condition","Fs"]
[1,"Normal",1]
[2,"Normal",1]
[3,"Normal",1]
[4,"Normal",1]
[5,"Normal",1]
[6,"Moderate",1.1]
[7,"Moderate",1.1]
[8,"Moderate",1.1]
[9,"Moderate",1.1]
[10,"Moderate",1.1]
[11,"Moderate",1.1]
[12,"Moderate",1.1]
[13,"Moderate",1.1]
[14,"Moderate",1.1]
[15,"Moderate",1.1]
[16,"Frequent",1.25]
[17,"Frequent",1.25]
[18,"Frequent",1.25]
[19,"Frequent",1.25]
[20,"Frequent",1.25]
[21,"Frequent",1.25]
[22,"Frequent",1.25]
[23,"Frequent",1.25]
[24,"Frequent",1.25]
[25,"Frequent",1.25]
[26,"Frequent",1.25]
[27,"Frequent",1.25]
[28,"Frequent",1.25]
[29,"Frequent",1.25]
[30,"Frequent",1.25]
["> 30","Very frequent",1.4]
[]
[]
[]
["Installation method","Installation factor (Kinst)","Average Value"]
["Free air",1,1]
["PVC conduit (surface/concealed)",0.85,0.85]
["Buried direct","0.75–0.80",0.775]
["Underground duct","0.70–0.75",0.725]
["Embedded in concrete","≈ 0.70",0.7]
[]
[]
["Method","Use this Kstart"]
["DOL",6]
["Star Delta",2]
["Soft Starter",3]
["VFD",1.1]
[]
["Ambient Temp, PVC Insulation"]
["Ambient Temp (°C)","Ktemp"]
[30,1]
[35,0.94]
[40,0.88]
[45,0.82]
[50,0.75]
[55,0.67]
[60,0.58]
[65,0.5]
["Ambient Temp, xlpe Insulation"]
["Ambient Temp (°C)","Ktemp"]
[30,1]
[35,0.96]
[40,0.91]
[45,0.87]
[50,0.82]
[55,0.76]
[60,0.71]
[65,0.65]
[70,0.58]
[75,0.5]
[]
[]
["Load Type","Nature","Recommended Safety Factor"]
["Lighting (intermittent)","Short duty",1.1]
["Socket outlets","Mixed",1.175]
["Motors (continuous)","Long duty",1.25]
["Heaters","Continuous",1.25]
["Solar DC","Continuous, hot",1.25]