{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","RCenL","transformer","voorbeeld 3,2,6 blad 3.11","condensator","ster driehoek","Sheet2","verzadiging","bh curve","magnetic core","voorbeeld 3,8 blad 3.10"],"not_rendered":{"charts":9,"images":9,"macros":1,"external_links":0,"defined_names":63,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Intro","index":0,"n_rows":26,"n_cols":15,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["zie voor een video","http://www.yentel.nl/phasors.mp4"]
["insert a horizontal line using \"insert shape\" and call it 'X_as'"]
["insert a vertical line using \"insert shape\" and call it 'Y_as'"]
["insert a range of 6 columns and a number of rows equal to the amount of arrows + 1 and call it \"gebied\""]
["the header of this gebied is named \"shapeName\"; \"Xo\";\"Yo\";\"Xe\";\"Ye\";\"TextVisble\""]
["draw your shapes and give them a name"]
["insert this name in the first column of \"gebied\""]
[]
["go to visual basic,to your sheet code and insert"]
["Private Sub Worksheet_SelectionChange(ByVal Target As Range)",null,null,null,null,null,null,null,null,null,"real","im.","complex"]
["    changePhasor",null,null,null,null,null,null,null,null,"R",1,0,{"$f":"COMPLEX(K11,L11,\"j\")","v":"1"},null,"Ohm"]
["End Sub",null,null,null,null,null,null,null,null,"L",0,0.5,{"$f":"COMPLEX(K12,L12,\"j\")","v":"0.5j"}]
["If you put an \"X\" in columns \"TextVisible\" then the text will be visible",null,null,null,null,null,null,null,null,"Z",null,null,{"$f":"IMSUM(M11,M12)","v":"1+0.5j"}]
["You can change the layout properties in the normal way like color and width",null,null,null,null,null,null,null,null,"U",300,20,{"$f":"COMPLEX(K14,L14,\"j\")","v":"300+20j"},null,"invoer"]
[null,null,null,null,null,null,null,null,null,"I",{"$f":"IMREAL(M15)","v":248},{"$f":"IMAGINARY(M15)","v":-104},{"$f":"IMDIV(M14,M13)","v":"248-104j"}]
["below, you have the area \"gebied\". Change the Xo, Yo, Ye and Xe and see what happens",null,null,null,null,null,null,null,null,"UL",{"$f":"IMREAL(M16)","v":52},{"$f":"IMAGINARY(M16)","v":124},{"$f":"IMPRODUCT(M15,M12)","v":"52+124j"}]
["Insert as many rows as you want for more arrows.",null,null,null,null,null,null,null,null,"UR",{"$f":"IMREAL(M17)","v":248},{"$f":"IMAGINARY(M17)","v":-104},{"$f":"IMPRODUCT(M15,M11)","v":"248-104j"}]
[null,"schaal",0.5]
["shapename","Xo","Yo","Xe","Ye","TextVisible"]
["I",0,0,{"$f":"K15","v":248},{"$f":"L15","v":-104},"X"]
["U",0,0,{"$f":"K14","v":300},{"$f":"L14","v":20},"x"]
["UL",0,0,{"$f":"K16","v":52},{"$f":"L16","v":124},"X"]
["UR",{"$f":"D22","v":52},{"$f":"E22","v":124},{"$f":"B23+K17","v":300},{"$f":"C23+L17","v":20},"X"]
[]
[]
["onder page layout zit een knop \"selection pane\" waarmee u alle shapes kunt selecteren"]

{"sheet":"RCenL","index":1,"n_rows":52,"n_cols":6,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[null,"schaal van vectoren",null,1]
["shapename","Xo","Yo","Xe","Ye","TextVisible"]
["V",0,0,{"$f":"E35","v":230},{"$f":"F35","v":230}]
["I",0,0,{"$f":"D48","v":69},{"$f":"E48","v":-23},"x"]
["UoverR",0,0,{"$f":"D50","v":138},{"$f":"E50","v":-46}]
["UoverL",{"$f":"D5","v":138},{"$f":"E5","v":-46},{"$f":"B6+D51","v":184},{"$f":"C6+E51","v":92}]
["UoverC",{"$f":"D6","v":184},{"$f":"E6","v":92},{"$f":"B7+D52","v":230},{"$f":"C7+E52","v":230}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"i"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"C"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"INPUT"]
[null,null,"complex",null,"real","Im"]
[null,"V",{"$f":"COMPLEX(E35,F35,\"j\")","v":"230+230j"},null,230,230]
[null,"R",{"$f":"COMPLEX(E36,F36,\"j\")","v":"2"},null,2,0]
[null,"X",{"$f":"COMPLEX(E37,F37,\"j\")","v":"2j"},null,0,2]
[null,"C",{"$f":"COMPLEX(E38,F38,\"j\")","v":"2j"},null,0,{"$f":"F37","v":2}]
[]
[null,"wat is de totale impedantie?"]
[]
[null,"R",{"$f":"C36","v":"2"}]
[null,"X",{"$f":"C37","v":"2j"}]
[null,"C",{"$f":"C38","v":"2j"}]
[null,null,null,"reeel","im"]
[null,"som",{"$f":"IMSUM(C42,C43,C44)","v":"2+4j"},{"$f":"IMREAL(C46)","v":2},{"$f":"IMAGINARY(C46)","v":4}]
[]
[null,"stroom",{"$f":"IMDIV(C35,C46)","v":"69-23j"},{"$f":"IMREAL(C48)","v":69},{"$f":"IMAGINARY(C48)","v":-23}]
[]
[null,"U over R",{"$f":"IMPRODUCT(C48,C42)","v":"138-46j"},{"$f":"IMREAL(C50)","v":138},{"$f":"IMAGINARY(C50)","v":-46}]
[null,"U over X",{"$f":"IMPRODUCT(C48,C43)","v":"46+138j"},{"$f":"IMREAL(C51)","v":46},{"$f":"IMAGINARY(C51)","v":138}]
[null,"U over C",{"$f":"IMPRODUCT(C48,C44)","v":"46+138j"},46,138]

{"sheet":"transformer","index":2,"n_rows":79,"n_cols":9,"rows_kept":79,"cut":false,"hidden":false,"merged":[]}
[null,"schaal van vectoren",null,0.5]
["shapename","Xo","Yo","Xe","Ye","TextVisible","cos phi"]
["Gen",0,0,{"$f":"D43","v":0},{"$f":"E43","v":500},"x",{"$f":"D3/((D3^2+E3^2)^0.5)","v":0},{"$f":"((D3^2+E3^2)^0.5)","v":500}]
["E2",0,0,{"$f":"G73","v":78.480581904802406},{"$f":"H73","v":299.247096856523},"x",{"$f":"D4/((D4^2+E4^2)^0.5)","v":0.25368105400667579},{"$f":"((D4^2+E4^2)^0.5)","v":309.3671390325315}]
["Uz1",{"$f":"D3","v":0},{"$f":"E3","v":500},{"$f":"B5-G70","v":78.480581904802406},{"$f":"C5-H70","v":299.247096856523},"x",{"$f":"D5/((D5^2+E5^2)^0.5)","v":0.25368105400667579},{"$f":"((D5^2+E5^2)^0.5)","v":309.3671390325315},{"$f":"H5/25/SQRT(3)","v":7.1445280399542579}]
["I2",0,0,{"$f":"G76","v":49.895187495118797},{"$f":"H76","v":32.6774753844036},null,{"$f":"D6/((D6^2+E6^2)^0.5)","v":0.83655699634737579},{"$f":"((D6^2+E6^2)^0.5)","v":59.643500338858068},{"$f":"H6/25/SQRT(3)","v":1.3774076390420498}]
["V2",0,0,{"$f":"G79","v":83.451637298035806},{"$f":"H79","v":90.302544516366595},"x"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"ìnput"]
[null,null,"complex","real","Im"]
[null,"R1",{"$f":"COMPLEX(D35,E35,\"j\")","v":"1"},1,0]
[null,"X1","2j",0,2]
[null,"X2","j",0,1]
[null,"R2","1",{"$f":"D35","v":1},0]
[null,"Xm","100j",0,100]
[null,"Rm","100",100,0]
[null,"Xb","0,5j",0,0.5]
[null,"Rb","2",2,0]
[null,"V1","500j",0,500]
[]
[]
[null,"calculate the impedance of magnetizing branch",null,null,null,null,"reeel","imaginair"]
[null,"Xm",{"$f":"Xm","v":"100j"},null,null,null,{"$f":"IMREAL(C47)","v":0},{"$f":"IMAGINARY(C47)","v":100}]
[null,"Rm",{"$f":"Rm","v":"100"},null,null,null,{"$f":"IMREAL(C48)","v":100},{"$f":"IMAGINARY(C48)","v":0}]
[null,"Xm//Rm",{"$f":"IMDIV((IMPRODUCT(C47,C48)),IMSUM(C47,C48))","v":"50+50j"},null,null,null,50,50]
[]
[null,"calculate the impedance of load branch",null,null,null,null,0,0]
[null,"X2",{"$f":"X2_","v":"j"},null,null,null,0,1]
[null,"R2",{"$f":"_R2","v":"1"},null,null,null,1,0]
[null,"Rb",{"$f":"Rb","v":"2"},null,null,null,2,0]
[null,"Xb",{"$f":"Xb","v":"0,5j"},null,null,null,0,0.5]
[null,null,{"$f":"IMSUM(C52,C53,C54,C55)","v":"3+1,5j"},null,null,null,3,1.5]
[]
[null,"calculate the impedance of parallel load and magnetizing branch"]
[null,"Zm//Zb",{"$f":"IMDIV((IMPRODUCT(C56,C49)),IMSUM(C56,C49))","v":"2,84962233920806+1,47631036850538j"},null,null,null,2.84962233920806,1.47631036850538]
[]
[null,"Calculate serie impedance"]
[null,"Z1+Zm//Zb",{"$f":"IMSUM(_R1,X1_,C59)","v":"3,84962233920806+3,47631036850538j"},null,null,null,3.84962233920806,3.4763103685053802]
[]
[null,"what's the current I1"]
[null,"V/Z",{"$f":"IMDIV(transformer!V1_,C62)","v":"64,6050448764302+71,5428133906163j"},null,null,null,64.605044876430199,71.542813390616303]
[]
[null,"what is Z1?"]
[null,null,{"$f":"IMSUM(_R1,X1_)","v":"1+2j"},null,null,null,1,2]
[null,"and the voltage drop over Z1?"]
[null,"Z1*I1",{"$f":"IMPRODUCT(C68,C65)","v":"-78,4805819048024+200,752903143477j"},null,null,null,-78.480581904802406,200.752903143477]
[]
[null,"and E2?"]
[null,null,{"$f":"IMSUB(V1_,C70)","v":"78,4805819048024+299,247096856523j"},null,null,null,78.480581904802406,299.247096856523]
[]
[null,"and I2"]
[null,"I2",{"$f":"IMDIV(C73,C62)","v":"49,8951874951188+32,6774753844036j"},null,null,null,{"$f":"IMREAL(C76)","v":49.895187495118797},{"$f":"IMAGINARY(C76)","v":32.6774753844036}]
[]
[null,"and V2?"]
[null,"V2",{"$f":"IMPRODUCT(C76,IMSUM(transformer!Xb,transformer!Rb))","v":"83,4516372980358+90,3025445163666j"},null,null,null,{"$f":"IMREAL(C79)","v":83.451637298035806},{"$f":"IMAGINARY(C79)","v":90.302544516366595}]

{"sheet":"voorbeeld 3,2,6 blad 3.11","index":3,"n_rows":81,"n_cols":17,"rows_kept":81,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wijzig de waarden in de rode cirkels"]
[null,null,null,null,null,null,null,null,null,"Ia","graden",null,null,null,null,null,"de rode cellen geven de stromen weer."]
[null,null,null,null,null,"Ua","graden",null,null,{"$f":"I67","v":5.6717119841969339},{"$f":"J67","v":5.7105931374996626}]
[null,null,null,null,null,5.7,90,null,null,null,null,null,"Ra","Xa"]
[null,null,null,null,null,null,null,null,null,null,null,null,0.1,1]
[]
[]
[]
[]
[null,null,null,null,null,null,"In","graden","Rn","Xn",null,null,"Un","graden"]
[null,null,"Uc","graden",null,null,{"$f":"I73","v":4.113410486866635E-19},{"$f":"J73","v":-71.161515256426668},9999,999,null,null,{"$f":"I65","v":4.1334761639712656E-15},{"$f":"J65","v":-65.456028239536693}]
[null,null,5.7,210]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Rb","Xb"]
[null,null,null,null,null,null,null,null,"Rc","Xc",null,null,null,0.1,1]
[null,null,null,null,null,null,null,null,0.1,1]
[]
[null,null,null,null,"Ub","graden"]
[null,null,null,null,5.7,-30]
[]
[]
[null,null,null,null,"Ic","graden",null,null,null,null,null,"Ib","graden"]
[null,null,null,null,{"$f":"I71","v":5.6717119841969383},{"$f":"J71","v":125.7105931374997},null,null,null,null,null,{"$f":"I69","v":5.6717119841969428},{"$f":"J69","v":-114.28940686250037}]
[]
[]
[]
[]
[null,"EVZ01dl3-driefasensystemen hogeschool rotterdam",null,null,null,"EVZ01dl3-driefasensystemen.pdf"]
[null,null,null,null,"schaal",50]
[null,null,"shapename","Xo","Yo","Xe","Ye","TextVisible"]
[null,null,"_Ua",0,0,{"$f":"D45","v":3.491673096489567E-16},5.7,"x"]
[null,null,"_Ub",0,0,4.936344801571301,-2.8499999999999996,"x"]
[null,null,"_Uc",0,0,-4.9363448015713001,-2.8500000000000005,"x"]
[null,null,"_Un",0,0,{"$f":"G65","v":1.71701074847516E-15},{"$f":"H65","v":-3.7599866073882997E-15},"x"]
[null,null,"Ub-Un",0,0,{"$f":"G68","v":4.9363448015713001},{"$f":"H68","v":-2.85},"x"]
[null,null,"_In",0,0,{"$f":"G73","v":1.32822630549E-19},{"$f":"H73","v":-3.8930657218789398E-19},"x"]
[null,null,"_Ia",0,0,{"$f":"G67","v":5.6435643564356397},{"$f":"H67","v":0.56435643564356597},"x"]
[null,null,"_Ib",0,0,{"$f":"G69","v":-2.3330351681612602},{"$f":"H69","v":-5.1696483183874298},"x"]
[null,null,"_Ic",0,0,{"$f":"G71","v":-3.3105291882743901},{"$f":"H71","v":4.6052918827438596},"x"]
[]
[null,null,null,"X","Y",null,"Re","Im","abs","hoek"]
[null,null,"Ua",{"$f":"F8*COS(G8*2*PI()/360)","v":3.491673096489567E-16},{"$f":"F8*SIN(G8*2*PI()/360)","v":5.7},{"$f":"COMPLEX(D45,E45,\"i\")","v":"3,49167309648957E-16+5,7i"},{"$f":"IMREAL(F45)","v":3.49167309648957E-16},{"$f":"IMAGINARY(F45)","v":5.7},{"$f":"IMABS(F45)","v":5.7},{"$f":"IMARGUMENT(F45)*360/2/PI()","v":90}]
[null,null,"Ub",{"$f":"E22*COS(F22*2*PI()/360)","v":4.936344801571301},{"$f":"E22*SIN(F22*2*PI()/360)","v":-2.8499999999999996},{"$f":"COMPLEX(D46,E46,\"i\")","v":"4,9363448015713-2,85i"},{"$f":"IMREAL(F46)","v":4.9363448015713001},{"$f":"IMAGINARY(F46)","v":-2.85},5.7,-30.000000000000004]
[null,null,"Uc",{"$f":"C16*COS(D16*2*PI()/360)","v":-4.9363448015713001},{"$f":"C16*SIN(D16*2*PI()/360)","v":-2.8500000000000005},{"$f":"COMPLEX(D47,E47,\"i\")","v":"-4,9363448015713-2,85i"},-4.9363448015713001,-2.85,5.7,-149.99999999999997]
[null,null,"Za",null,null,{"$f":"COMPLEX(M9,N9,\"i\")","v":"0,1+i"},0.1,1,1.004987562112089,84.289406862500371]
[null,null,"Zb",null,null,{"$f":"COMPLEX(N18,O18,\"i\")","v":"0,1+i"},0.1,1,1.004987562112089,84.289406862500371]
[null,null,"Zc",null,null,{"$f":"COMPLEX(I19,J19,\"i\")","v":"0,1+i"},0.1,1,1.004987562112089,84.289406862500371]
[null,null,"Zn",null,null,{"$f":"COMPLEX(I15,J15,\"i\")","v":"9999+999i"},null,null,10048.781120116011,5.7054870168899461]
[]
[null,null,"Ia",null,null,{"$f":"IMDIV(F45,F48)","v":"5,64356435643564+0,564356435643564i"},null,null,{"$f":"IMABS(F53)","v":5.6717119841969339},{"$f":"IMARGUMENT(F53)*360/2/PI()","v":5.710593137499643}]
[null,null,"Ib",null,null,{"$f":"IMDIV(F46,F49)","v":"-2,33303516816126-5,16964831838743i"},null,null,{"$f":"IMABS(F54)","v":5.6717119841969428},{"$f":"IMARGUMENT(F54)*360/2/PI()","v":-114.28940686250037}]
[null,null,"Ic",null,null,{"$f":"IMDIV(F47,F50)","v":"-3,31052918827439+4,60529188274386i"},null,null,{"$f":"IMABS(F55)","v":5.6717119841969383},{"$f":"IMARGUMENT(F55)*360/2/PI()","v":125.7105931374997}]
[]
[null,null,"som stromen",null,null,{"$f":"IMSUM(F54,F55,F53)","v":"-1,06581410364015E-14-6,21724893790088E-15i"},null,null,{"$f":"IMABS(F57)","v":1.233896894832203E-14},{"$f":"IMARGUMENT(F57)*360/2/PI()","v":-149.74356283647069}]
[]
[null,null,"1/Za",null,null,{"$f":"IMDIV(1,F48)","v":"0,099009900990099-0,99009900990099i"},null,null,0.99503719020998893,-84.289406862500371]
[null,null,"1/Zb",null,null,{"$f":"IMDIV(1,F49)","v":"0,099009900990099-0,99009900990099i"},null,null,0.99503719020998893,-84.289406862500371]
[null,null,"1/Zc",null,null,{"$f":"IMDIV(1,F50)","v":"0,099009900990099-0,99009900990099i"},null,null,0.99503719020998893,-84.289406862500371]
[null,null,"1/Zn",null,null,{"$f":"IMDIV(1,F51)","v":"0,0000990215670933952-9,89324387701789E-06i"},null,null,9.9514556844925554E-5,-5.7054870168899505]
[null,null,"som Z",null,null,{"$f":"IMSUM(F59,F60,F61,F62)","v":"0,29712872453739-2,97030692294685i"},null,null,2.9851312693835093,-84.287534596934037]
[]
[null,"a. berekening Un","Un",null,null,{"$f":"IMDIV(F57,F63)","v":"1,71701074847516E-15-3,7599866073883E-15i"},1.71701074847516E-15,{"$f":"IMAGINARY(F65)","v":-3.7599866073882997E-15},{"$f":"IMABS(F65)","v":4.1334761639712656E-15},{"$f":"IMARGUMENT(F65)*360/2/PI()","v":-65.456028239536693}]
[null,"b","Ua-Un",null,null,{"$f":"IMSUB(F45,F65)","v":"-1,3678434388262E-15+5,7i"},-1.3678434388261999E-15,{"$f":"IMAGINARY(F66)","v":5.7},5.7,90.000000000000014]
[null,null,"Ia",null,null,{"$f":"IMDIV(F66,F48)","v":"5,64356435643564+0,564356435643566i"},5.6435643564356397,0.56435643564356597,5.6717119841969339,5.7105931374996626]
[null,null,"Ub-Un",null,null,{"$f":"IMSUB(F46,F65)","v":"4,9363448015713-2,85i"},4.9363448015713001,-2.85,5.7,-30.000000000000004]
[null,null,"Ib",null,null,{"$f":"IMDIV(F68,F49)","v":"-2,33303516816126-5,16964831838743i"},{"$f":"IMREAL(F69)","v":-2.3330351681612602},-5.1696483183874298,5.6717119841969428,-114.28940686250037]
[null,null,"Uc-Un",null,null,{"$f":"IMSUB(F47,F65)","v":"-4,9363448015713-2,85i"},{"$f":"IMREAL(F70)","v":-4.9363448015713001},-2.85,5.7,-149.99999999999997]
[null,null,"Ic",null,null,{"$f":"IMDIV(F70,F50)","v":"-3,31052918827439+4,60529188274386i"},-3.3105291882743901,4.6052918827438596,5.6717119841969383,125.7105931374997]
[null,null,"Un-ster",null,null,{"$f":"IMSUB(F65,0)","v":"1,71701074847516E-15-3,7599866073883E-15i"},1.71701074847516E-15,{"$f":"IMAGINARY(F72)","v":-3.7599866073882997E-15},4.1334761639712656E-15,-65.456028239536693]
[null,null,"In",null,null,{"$f":"IMDIV(F72,F51)","v":"1,32822630549E-19-3,89306572187894E-19i"},1.32822630549E-19,-3.8930657218789398E-19,4.113410486866635E-19,-71.161515256426668]
[null,"c","PspanningA",null,null,{"$f":"IMPRODUCT(F67,F45)","v":"-3,21683168316832+32,1683168316831i"},-3.2168316831683201,{"$f":"IMAGINARY(F74)","v":32.1683168316831},32.328758309922478,95.710593137499657]
[null,null,"PspanningB",null,null,{"$f":"IMPRODUCT(F69,F46)","v":"-26,25016373164-18,870016373164i"},-26.250163731640001,-18.870016373163999,32.328758309922534,-144.28940686250036]
[null,null,"PspanningC",null,null,{"$f":"IMPRODUCT(F71,F47)","v":"29,4669954148083-13,2983004585191i"},29.466995414808299,-13.298300458519099,32.328758309922492,-24.289406862500272]
[null,"d","vermogenA",null,null,{"$f":"IMPRODUCT(IMPOWER(F67,2),F48)","v":"-3,21683168316834+32,1683168316831i"},-3.2168316831683401,32.1683168316831,32.328758309922485,95.7105931374997]
[null,null,"vermogenB",null,null,{"$f":"IMPRODUCT(IMPOWER(F69,2),F49)","v":"-26,2501637316401-18,870016373164i"},-26.2501637316401,-18.870016373163999,32.328758309922613,-144.28940686250044]
[null,null,"vermogenC",null,null,{"$f":"IMPRODUCT(IMPOWER(F71,2),F50)","v":"29,4669954148083-13,2983004585191i"},29.466995414808299,-13.298300458519099,32.328758309922492,-24.289406862500272]
[null,null,"vermogen nul",null,null,{"$f":"IMPRODUCT(IMPOWER(F73,2),F51)","v":"-1,23572961330135E-33-1,16785488092095E-33i"},-1.23572961330135E-33,{"$f":"IMAGINARY(F80)","v":-1.1678548809209499E-33},1.7002684200092611E-33,-136.61754349596356]
[null,null,"som vermogen",null,null,{"$f":"IMSUM(F78,F79)","v":"3,2168316831682-32,1683168316831i"},3.2168316831681998,-32.1683168316831,32.32875830992247,-84.28940686250057]

{"sheet":"condensator","index":4,"n_rows":67,"n_cols":20,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
[null,"schaal van vectoren",null,1]
["shapename","Xo","Yo","Xe","Ye","TextVisible"]
["V1_",0,0,{"$f":"D38","v":400},0,"x"]
["E1-",0,0,0,0]
["R1I1",0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,"spanning",400,"V"]
["X1I1",0,0,0,0]
["I1-",0,0,{"$f":"D45","v":180.42195912175808},{"$f":"D46","v":135.31646934131854},"x"]
["V2-",0,0,0,0]
["R2I2",0,0,{"$f":"D45","v":180.42195912175808},0,"x"]
["X2I2",{"$f":"D9","v":180.42195912175808},0,{"$f":"B10","v":180.42195912175808},{"$f":"D46","v":135.31646934131854},"x"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"de connected load is dan",{"$f":"S13*S5*SQRT(3)/1000","v":131.57894736842107},"kVA"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LF current",{"$f":"S18/S5/SQRT(3)*1000","v":189.91785170711375}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eff omvormer",0.95]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ingaand omvormer vermogen",{"$f":"S24/S17","v":131.57894736842107},"kW"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elek vermogen",{"$f":"S28/S30","v":125},"kW"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LF current",{"$f":"S27/S5*1000/SQRT(3)","v":225.52744890219759}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"elek vermogen",{"$f":"S28/S29/S30","v":156.25},"kVA"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"asvermogen",100,"kW"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pF",0.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"eff",0.8]
[]
[]
["een motor van ",null,null,100,"kW"]
["en een rendement van ",null,null,0.8]
["heeft een ingaand vermogen van",null,null,{"$f":"D33/D34","v":125},"kW"]
["en een cos phi van",null,null,0.8,null,"als voorbeeld zoals PTW het wil"]
["is het vermogen",null,null,{"$f":"D35/D36","v":156.25},"kVA"]
["bij een spanning van ",null,null,400,"V"]
["vraagt een stroom van",null,null,{"$f":"D37/D38*1000/SQRT(3)","v":225.52744890219759},"A"]
["de impedantie Z is",null,null,{"$f":"D38/D39","v":1.7736200269505302},"Ohm"]
["reeel deel R2",null,null,{"$f":"D40*D36","v":1.4188960215604243},"Ohm"]
["imaginair X2",null,null,{"$f":"(D40^2-D41^2)^0.5","v":1.0641720161703181},"Ohm"]
[]
["sin phi",null,null,{"$f":"D42/D40","v":0.6}]
["reele stroom",null,null,{"$f":"D39*D36","v":180.42195912175808},"A"]
["blindstroom",null,null,{"$f":"D39*D44","v":135.31646934131854},"A"]
[]
["om de blindstroom te compenseren"]
["Zc",null,null,{"$f":"D38/D46","v":2.9560333782508841},"Ohm"]
[]
["wat is dat dan in pu?"]
["er staat een base MVA van ",null,null,100000,"kVA"]
["en een base spanning van ",null,null,400,"V"]
["mijn base stroom is dan",null,null,{"$f":"D52/D53","v":250},"kA"]
["mijn base impedance",null,null,{"$f":"D53/D54/1000","v":1.6000000000000001E-3},"Ohm"]
[]
["met de z van",null,null,{"$f":"D40","v":1.7736200269505302},"Ohm"]
["dus mijn Zpu is dan",null,null,{"$f":"D40/D55","v":1108.5125168440813}]
[]
["mijn Zc is",null,null,{"$f":"D49","v":2.9560333782508841},"Ohm"]
["en mijn Zc pu is dan",null,null,{"$f":"D60/D55","v":1847.5208614068024}]
[]
[]
[]
[]
["stroom in pu",null,"Upu/Zc pu",{"$f":"1/D61","v":5.4126587736527416E-4}]
["werklijke stroom",null,null,{"$f":"D66*D54*1000","v":135.31646934131854},"A"]

{"sheet":"ster driehoek","index":5,"n_rows":74,"n_cols":21,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,null,null,null,null,null,null,"naam","P","cosphi","S","ywaarde","xo","yo","x1","y1","arccos","sinphi"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A17","v":"_L1"},100,0.8,{"$f":"L3/M3","v":125},{"$f":"N3*U3","v":74.999999999999986},0,0,{"$f":"L3","v":100},{"$f":"U3*N3","v":74.999999999999986},{"$f":"ACOS(M3)","v":0.64350110879328426},{"$f":"SIN(T3)","v":0.59999999999999987}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"A18","v":"_L2"},100,1,{"$f":"L4/M4","v":100},{"$f":"N4*U4","v":0},{"$f":"R3","v":100},{"$f":"S3","v":74.999999999999986},{"$f":"L4+P4","v":200},{"$f":"U4*N4+Q4","v":74.999999999999986},{"$f":"ACOS(M4)","v":0},{"$f":"SIN(T4)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"_L3",100,0.5,200,173.20508075688772,{"$f":"R4","v":200},{"$f":"S4","v":74.999999999999986},{"$f":"L5+P5","v":300},{"$f":"U5*N5+Q5","v":248.2050807568877},1.0471975511965976,0.8660254037844386]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L3:L5)","v":300},null,{"$f":"SUM(N3:N5)","v":425},{"$f":"SUM(O3:O5)","v":248.2050807568877},null,null,null,{"$f":"SUM(S3:S5)","v":398.2050807568877}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"(L6^2+O6^2)^0.5","v":389.36584610560431}]
[]
[null,null,null,"verplaats",300]
[]
[]
[]
[null,null,"schaal",0.5,null,null,null,null,null,null,"fasen",null,"3e"]
["shapename","Xo","Yo","Xe","Ye","TextVisible",null,null,null,10,200,null,30,100]
["_L1",{"$f":"D18","v":173.20508075688775},{"$f":"E18","v":-99.999999999999957},{"$f":"K17","v":0},{"$f":"L17","v":200},"x",null,null,null,0,{"$f":"SIN(J17*2*PI()/360)*$K$16","v":0},{"$f":"COS(J17*2*PI()/360)*$K$16","v":200},30,{"$f":"SIN(M17*2*PI()/360)*$N$16","v":49.999999999999993},{"$f":"COS(M17*2*PI()/360)*$N$16","v":86.602540378443877}]
["_L2",{"$f":"D19","v":-173.20508075688767},{"$f":"E19","v":-100.00000000000009},{"$f":"K29","v":173.20508075688775},{"$f":"L29","v":-99.999999999999957},"x",null,null,null,{"$f":"J17+J$16","v":10},34.729635533386066,196.9615506024416,{"$f":"M17+M$16","v":60},{"$f":"SIN(M18*2*PI()/360)*$N$16","v":86.602540378443862},{"$f":"COS(M18*2*PI()/360)*$N$16","v":50.000000000000014}]
["_L3",{"$f":"D17","v":0},{"$f":"E17","v":200},{"$f":"K41","v":-173.20508075688767},{"$f":"L41","v":-100.00000000000009},"x",null,null,null,{"$f":"J18+J$16","v":20},68.404028665133737,187.93852415718169,{"$f":"M18+M$16","v":90},100,6.1257422745431001E-15]
["_L4",0,{"$f":"0-E$11","v":-300},{"$f":"(B17-D17)/2","v":86.602540378443877},{"$f":"(C17-E17)/2-E$11","v":-450},"x",null,null,null,30,99.999999999999986,173.20508075688775,120,86.602540378443877,-49.999999999999979]
["_L5",0,{"$f":"0-E$11","v":-300},{"$f":"(B18-D18)/2","v":-173.2050807568877},{"$f":"(C18-E18)/2-E$11","v":-300.00000000000006},"x",null,null,null,40,128.55752193730785,153.20888862379562,150,49.999999999999993,-86.602540378443877]
["_L6",0,{"$f":"0-E$11","v":-300},86.602540378443834,{"$f":"(C19-E19)/2-E$11","v":-149.99999999999994},"x",null,null,null,50,153.20888862379562,128.55752193730788,180,1.22514845490862E-14,-100]
["_L7",{"$f":"D20","v":86.602540378443877},{"$f":"E20","v":-450},{"$f":"D21","v":-173.2050807568877},{"$f":"E21","v":-300.00000000000006},"x",null,null,null,60,173.20508075688772,100.00000000000003,210,-50.000000000000014,-86.602540378443862]
["_L8",{"$f":"D21","v":-173.2050807568877},-300.00000000000006,{"$f":"D22","v":86.602540378443834},-149.99999999999994,"x",null,null,null,70,187.93852415718166,68.404028665133765,240,-86.602540378443834,-50.000000000000043]
["_L9",{"$f":"D22","v":86.602540378443834},{"$f":"E22","v":-149.99999999999994},{"$f":"D20","v":86.602540378443877},{"$f":"E20","v":-450},"x",null,null,null,80,196.9615506024416,34.72963553338608,270,-100,-1.83772268236293E-14]
[null,null,null,null,null,null,null,null,null,90,200,1.22514845490862E-14,300,-86.602540378443862,50.000000000000014]
[null,null,null,null,null,null,null,null,null,100,196.9615506024416,-34.729635533386059,330,-50.000000000000043,86.602540378443834]
[null,null,null,null,null,null,null,null,null,110,187.93852415718169,-68.404028665133737,360,-2.45029690981724E-14,100]
["_3L1",0,0,300,{"$f":"O17","v":86.602540378443877},null,null,null,null,120,173.20508075688775,-99.999999999999957,390,49.999999999999929,86.602540378443905]
["_3L2",0,0,300,{"$f":"O21","v":-86.602540378443877},null,null,null,null,{"$f":"J29+J$16","v":130},{"$f":"SIN(J30*2*PI()/360)*$K$16","v":153.20888862379562},{"$f":"COS(J30*2*PI()/360)*$K$16","v":-128.55752193730788},420,86.602540378443877,{"$f":"COS(M30*2*PI()/360)*$N$16","v":49.999999999999972}]
["_3L3",0,0,300,{"$f":"O29","v":86.602540378443905},"x",null,null,null,140,128.55752193730788,-153.20888862379559,450,100,3.06287113727155E-14]
[null,null,null,null,null,null,null,null,null,150,99.999999999999986,-173.20508075688775,480,86.602540378443919,-49.999999999999922]
[null,null,"S totaal",{"$f":"(D31^2+E31^2)^0.5","v":312.24989991991993},425,null,null,null,null,160,68.404028665133779,-187.93852415718166,510,49.999999999999979,-86.602540378443877]
[null,null,"U",400,400,null,null,null,null,170,34.729635533386052,-196.9615506024416,540,3.67544536472586E-14,-100]
[null,null,"I",{"$f":"D33/D34/SQRT(3)","v":0.4506939094329987},{"$f":"E33/E34/SQRT(3)","v":0.61343466101397737},null,null,null,null,180,2.45029690981724E-14,-200,570,-50.000000000000064,-86.60254037844382]
[null,null,null,null,null,null,null,null,null,190,-34.729635533386094,-196.9615506024416,600,-86.602540378443877,-49.999999999999986]
[null,null,null,null,null,null,null,null,null,200,-68.404028665133737,-187.93852415718169,630,-100,-4.28801959218017E-14]
[null,null,null,null,null,null,null,null,null,210,-100.00000000000003,-173.20508075688772,660,-86.602540378443919,49.999999999999915]
[null,null,null,null,null,null,null,null,null,220,-128.55752193730785,-153.20888862379562,690,-49.999999999999986,86.602540378443877]
[null,null,null,null,null,null,null,null,null,230,-153.20888862379559,-128.55752193730788,720,-4.90059381963448E-14,100]
[null,null,null,null,null,null,null,null,null,240,-173.20508075688767,-100.00000000000009,750,49.999999999999908,86.602540378443919]
[null,null,null,null,null,null,null,null,null,250,-187.93852415718163,-68.404028665133879,780,86.602540378443777,50.000000000000142]
[null,null,null,null,null,null,null,null,null,260,-196.9615506024416,-34.729635533386066,810,100,2.3276736441091295E-13]
[null,null,null,null,null,null,null,null,null,270,-200,-3.67544536472586E-14,840,86.602540378443834,-50.000000000000057]
[null,null,null,null,null,null,null,null,null,280,-196.96155060244163,34.729635533385995,870,50,-86.602540378443862]
[null,null,null,null,null,null,null,null,null,290,-187.93852415718172,68.404028665133637,900,6.1257422745431001E-14,-100]
[null,null,null,null,null,null,null,null,null,300,-173.20508075688772,100.00000000000003,930,-49.999999999999893,-86.602540378443933]
[null,null,null,null,null,null,null,null,null,310,-153.20888862379562,128.55752193730785,960,-86.602540378443777,-50.000000000000156]
[null,null,null,null,null,null,null,null,null,320,-128.55752193730791,153.20888862379556,990,-100,1.1025251892005095E-13]
[null,null,null,null,null,null,null,null,null,330,-100.00000000000009,173.20508075688767,1020,-86.602540378443834,50.000000000000043]
[null,null,null,null,null,null,null,null,null,340,-68.404028665133723,187.93852415718169,1050,-50.000000000000014,86.602540378443862]
[null,null,null,null,null,null,null,null,null,350,-34.729635533386258,196.96155060244158,1080,-7.3508907294517201E-14,100]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,{"$f":"360.8+577.4","v":938.2}]

{"sheet":"Sheet2","index":6,"n_rows":78,"n_cols":23,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"vp",230,"V"]
[null,"stap",5.0000000000000001E-4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"f"]
[null,"basefreq",50,"Hz"]
[null,"3thHarmFreq",150,"Hz"]
[]
[]
[]
[]
[]
[null,"KWADRAAT",null,{"$f":"D12^2","v":0},{"$f":"E12^2","v":4.0000000000000008E-2},2.2499999999999999E-2,1.0000000000000002E-2,null,"SOM",{"$f":"SUM(D10:G10)","v":7.2500000000000009E-2},"WORTEL",{"$f":"J10^0.5","v":0.26925824035672524}]
[null,"harmonische",1,3,5,7,9,null,null,null,"THD",{"$f":"L10*100","v":26.925824035672523},"%"]
[null,"percentage",1,0,0.2,0.15,0.1]
["tijd","hoek",null,null,null,null,null,null,null,null,null,null,null,null,null,"VL3L1",null,null,null,"sin(3wt)",null,null,"i"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"vp*SIN(3*2*basefreq*PI()*A18)","v":-28.826643719789942},{"$f":"vp*SIN(3*2*basefreq*PI()*A18)","v":-28.826643719789942}]
[]
["[s]","wt","1e","3e","5e","7e","9e","som",null,null,null,null,null,null,null,{"$f":"P13","v":"VL3L1"},null,null,null,{"$f":"T13","v":"sin(3wt)"},null,null,{"$f":"W13","v":"i"}]
[-3.2000000000000002E-3,{"$f":"2*PI()*A18*basefreq","v":-1.0053096491487339},{"$f":"SIN(C$11*$B18)*vp*C$12","v":-194.19542286546346},0,43.748599749577068,-23.616875154539777,-8.4668647117475935,{"$f":"SUM(C18:G18)","v":-182.53056298217376},null,null,null,null,null,null,null,{"$f":"E18-C18","v":237.94402261504052},{"$f":"F18+G18+P18","v":205.86028274875315},null,null,null,null,null,0]
[{"$f":"A18+stap","v":-2.7000000000000001E-3},-0.84823001646924423,-172.52554601500572,0,40.986300112664942,11.686458248462555,-22.446085524591197,{"$f":"SUM(C19:G19)","v":-142.29887317846942},null,null,null,null,null,null,null,{"$f":"E19-C19","v":213.51184612767065},{"$f":"F19+G19+P19","v":202.75221885154201},null,null,null,null,null,{"$f":"C19/U19*vp/10","v":{"$error":"#DIV/0!"}}]
[-2.2000000000000001E-3,-0.69115038378975446,-146.60751764219862,0,14.214781741247576,34.227957195349489,1.4441819491742256,-96.720596756427327,null,null,null,null,null,null,null,160.82229938344619,196.49443852796992,null,null,null,null,null,{"$error":"#DIV/0!"}]
[-1.7000000000000001E-3,-0.53407075111026492,-117.07952562258541,0,-20.88356298801914,19.391876535898522,22.897925185870839,-95.673286888835207,null,null,null,null,null,null,null,96.195962634566271,138.48576435633564,null,null,null,null,null,{"$error":"#DIV/0!"}]
[-1.2000000000000001E-3,-0.37699111843077521,-84.668647117475928,0,-43.748599749577068,-16.620501756509174,5.7198674047916658,-139.31788121877051,null,null,null,null,null,null,null,40.92004736789886,30.019413016181353,null,null,null,null,null,{"$error":"#DIV/0!"}]
[-7.000000000000001E-4,-0.21991148575128558,-50.172945521204795,0,-40.986300112664928,-34.482976332617739,-21.108356390731561,-146.75057835721901,null,null,null,null,null,null,null,9.1866454085398672,-46.404687314809429,null,null,null,null,null,{"$error":"#DIV/0!"}]
[-2.0000000000000009E-4,-6.2831853071795896E-2,-14.441819491742082,0,-14.21478174124759,-14.689385558995012,-12.324016284516929,-55.670003076501615,null,null,null,null,null,null,null,0.22703775049449249,-26.78636409301745,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.9999999999999992E-4,9.4247779607693774E-2,21.644912063258289,0,20.88356298801915,21.145293351027686,17.25255460150057,80.926323003805692,null,null,null,null,null,null,null,-0.76134907523913853,37.636498877289114,null,null,null,null,null,{"$error":"#DIV/0!"}]
[7.9999999999999993E-4,0.25132741228718347,57.198674047916604,0,43.748599749577068,33.888910150139758,17.721804583843152,152.55798853147658,null,null,null,null,null,null,null,-13.450074298339537,38.160640435643373,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.2999999999999999E-3,0.40840704496667307,91.344014845999524,0,40.986300112664928,9.6251931583534187,-11.70795256225853,130.24755555475934,null,null,null,null,null,null,null,-50.357714733334596,-52.440474137239704,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.8E-3,0.56548667764616278,{"$f":"SIN(C$11*$B28)*vp*C$12","v":123.24016284516924},0,14.214781741247586,-25.1494176460387,-21.384859175429781,90.920667764948334,null,null,null,null,null,null,null,-109.02538110392165,-155.55965792539013,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.3E-3,0.72256631032565244,152.10172902443992,0,-20.88356298801915,-32.460386528920779,5.017294552120485,103.77507405962048,null,null,null,null,null,null,null,-172.98529201245907,-200.42838398925937,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.8E-3,0.87964594300514209,177.21804583843152,0,-43.748599749577068,-4.3239965579685107,22.954614753850247,152.10006428473619,null,null,null,null,null,null,null,-220.96664558800859,-202.33602739212685,null,null,null,null,null,{"$error":"#DIV/0!"}]
[3.3E-3,1.0367255756846316,197.97066621090701,0,-40.986300112664949,28.534279812472374,2.1644912063258661,187.68313711704027,null,null,null,null,null,null,null,-238.95696632357198,-208.25819530477372,null,null,null,null,null,{"$error":"#DIV/0!"}]
[3.8E-3,1.1938052083641213,213.84859175429781,0,-14.214781741247592,30.232580461513315,-22.277412705958511,207.58897776860502,null,null,null,null,null,null,null,-228.06337349554542,-220.10820573999061,null,null,null,null,null,{"$error":"#DIV/0!"}]
[4.3E-3,1.3508848410436112,224.46085524591192,0,20.883562988019179,-1.0836711881954684,-9.1344014845999535,235.12634556113568,null,null,null,null,null,null,null,-203.57729225789274,-213.79536493068815,null,null,null,null,null,{"$error":"#DIV/0!"}]
[4.8000000000000004E-3,1.5079644737231008,229.54614753850245,0,43.748599749577075,-31.216533310077679,19.41954228654636,261.49775626454817,null,null,null,null,null,null,null,-185.79754778892539,-197.5945388124567,null,null,null,null,null,{"$error":"#DIV/0!"}]
[5.3000000000000009E-3,1.6650441064025907,228.97925185870841,0,40.986300112664907,-27.260347926961252,15.210172902443965,257.91537694685604,null,null,null,null,null,null,null,-187.9929517460435,-200.04312677056078,null,null,null,null,null,{"$error":"#DIV/0!"}]
[5.8000000000000013E-3,1.8221237390820804,222.77412705958514,0,14.214781741247519,6.4646553532075668,-14.660751764219908,228.79281238982034,null,null,null,null,null,null,null,-208.55934531833762,-216.75544172934997,null,null,null,null,null,{"$error":"#DIV/0!"}]
[6.3000000000000018E-3,1.9792033717615705,211.08356390731558,0,-20.883562988019321,33.130132155854582,-19.797066621090622,203.53306645406025,null,null,null,null,null,null,null,-231.9671268953349,-218.63406136057094,null,null,null,null,null,{"$error":"#DIV/0!"}]
[6.8000000000000022E-3,2.1362830044410601,{"$f":"SIN(C$11*$B38)*vp*C$12","v":194.1954228654634},0,-43.74859974957711,23.616875154539624,8.4668647117477587,182.53056298217365,null,null,null,null,null,null,null,-237.94402261504052,-205.86028274875315,null,null,null,null,null,{"$error":"#DIV/0!"}]
[7.3000000000000027E-3,2.2933626371205498,172.52554601500557,0,-40.986300112664843,-11.686458248462758,22.446085524591169,142.29887317846914,null,null,null,null,null,null,null,-213.51184612767042,-202.75221885154201,null,null,null,null,null,{"$error":"#DIV/0!"}]
[7.8000000000000031E-3,2.4504422698000394,146.6075176421985,0,-14.214781741247448,-34.227957195349511,-1.4441819491743431,96.720596756427199,null,null,null,null,null,null,null,-160.82229938344594,-196.49443852796981,null,null,null,null,null,{"$error":"#DIV/0!"}]
[8.3000000000000036E-3,2.6075219024795295,117.07952562258518,0,20.883562988019388,-19.391876535898277,-22.897925185870864,95.67328688883542,null,null,null,null,null,null,null,-96.195962634565788,-138.48576435633493,null,null,null,null,null,{"$error":"#DIV/0!"}]
[8.800000000000004E-3,2.7646015351590192,84.668647117475686,0,43.74859974957716,16.620501756509391,-5.7198674047914126,139.31788121877082,null,null,null,null,null,null,null,-40.920047367898526,-30.019413016180547,null,null,null,null,null,{"$error":"#DIV/0!"}]
[9.3000000000000044E-3,2.9216811678385088,50.172945521204532,0,40.986300112664807,34.482976332617731,21.108356390731643,146.75057835721873,null,null,null,null,null,null,null,-9.1866454085397251,46.404687314809649,null,null,null,null,null,{"$error":"#DIV/0!"}]
[9.8000000000000049E-3,3.0787608005179989,14.441819491741715,0,14.21478174124722,14.689385558994623,12.324016284516675,55.67000307650023,null,null,null,null,null,null,null,-0.22703775049449426,26.7863640930168,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.0300000000000005E-2,3.2358404331974886,-21.644912063258651,0,-20.883562988019527,-21.145293351027998,-17.252554601500776,-80.926323003806957,null,null,null,null,null,null,null,0.76134907523912432,-37.636498877289654,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.0800000000000006E-2,3.3929200658769783,-57.198674047916946,0,-43.748599749577153,-33.888910150139694,-17.721804583842943,-152.55798853147675,null,null,null,null,null,null,null,13.450074298339793,-38.16064043564284,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.1300000000000006E-2,3.5499996985564684,-91.344014845999965,0,-40.986300112664701,-9.6251931583529782,11.707952562258914,-130.24755555475872,null,null,null,null,null,null,null,50.357714733335264,52.440474137241196,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.1800000000000007E-2,3.707079331235958,{"$f":"SIN(C$11*$B48)*vp*C$12","v":-123.24016284516961},0,-14.214781741247069,25.149417646038984,21.384859175429614,-90.920667764948078,null,null,null,null,null,null,null,109.02538110392254,155.55965792539115,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.2300000000000007E-2,3.8641589639154477,-152.10172902444029,0,20.88356298801952,32.460386528920608,-5.0172945521209389,-103.7750740596211,null,null,null,null,null,null,null,172.98529201245981,200.42838398925949,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.2800000000000008E-2,{"$f":"2*PI()*A50*basefreq","v":4.0212385965949373},-177.21804583843181,0,43.74859974957721,4.3239965579680231,-22.954614753850215,-152.10006428473679,null,null,null,null,null,null,null,220.96664558800902,202.33602739212682,null,null,null,null,null,{"$error":"#DIV/0!"}]
[{"$f":"A50+stap","v":1.3300000000000008E-2},4.1783182292744279,-197.97066621090738,0,40.986300112664622,-28.534279812472771,-2.1644912063253221,-187.68313711704084,null,null,null,null,null,null,null,238.956966323572,208.25819530477392,null,null,null,null,null,{"$f":"C51/U51*vp/10","v":{"$error":"#DIV/0!"}}]
[1.3800000000000008E-2,4.3353978619539175,-213.84859175429807,0,14.214781741246918,-30.232580461512974,22.27741270595865,-207.58897776860547,null,null,null,null,null,null,null,228.06337349554499,220.10820573999067,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.4300000000000009E-2,4.4924774946334072,-224.46085524591203,0,-20.883562988019666,1.0836711881961738,9.1344014845994508,-235.12634556113608,null,null,null,null,null,null,null,203.57729225789237,213.79536493068798,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.4800000000000009E-2,4.6495571273128968,-229.54614753850251,0,-43.748599749577252,31.216533310077978,-19.419542286546651,-261.4977562645484,null,null,null,null,null,null,null,185.79754778892527,197.59453881245659,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.530000000000001E-2,4.8066367599923865,-228.97925185870835,0,-40.98630011266463,27.2603479269609,-15.210172902443555,-257.91537694685564,null,null,null,null,null,null,null,187.99295174604373,200.04312677056109,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.5800000000000008E-2,4.9637163926718753,-222.77412705958506,0,-14.21478174124708,-6.4646553532078981,14.660751764220203,-228.7928123898198,null,null,null,null,null,null,null,208.55934531833799,216.75544172935031,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.6300000000000009E-2,5.1207960253513658,-211.08356390731541,0,20.883562988019804,-33.13013215585471,19.797066621090387,-203.53306645405993,null,null,null,null,null,null,null,231.96712689533521,218.63406136057088,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.6800000000000009E-2,5.2778756580308555,{"$f":"SIN(C$11*$B58)*vp*C$12","v":-194.19542286546312},0,43.748599749577252,-23.616875154539329,-8.4668647117481921,-182.53056298217342,null,null,null,null,null,null,null,237.94402261504035,205.86028274875284,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.730000000000001E-2,5.4349552907103451,-172.52554601500526,0,40.98630011266463,11.686458248463074,-22.446085524591048,-142.29887317846863,null,null,null,null,null,null,null,213.51184612766988,202.7522188515419,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.780000000000001E-2,5.5920349233898348,-146.60751764219813,0,14.214781741246931,34.227957195349582,1.4441819491747254,-96.720596756426914,null,null,null,null,null,null,null,160.82229938344506,196.49443852796935,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.8300000000000011E-2,5.7491145560693253,-117.07952562258467,0,-20.883562988019946,19.391876535897694,22.897925185870907,-95.673286888836017,null,null,null,null,null,null,null,96.195962634564722,138.48576435633333,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.8800000000000011E-2,5.906194188748815,-84.668647117475146,0,-43.748599749577302,-16.620501756510009,5.7198674047909632,-139.3178812187715,null,null,null,null,null,null,null,40.920047367897844,30.019413016178799,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.9300000000000012E-2,6.0632738214283037,-50.172945521204163,0,-40.986300112664637,-34.482976332617717,-21.108356390731799,-146.75057835721833,null,null,null,null,null,null,null,9.1866454085395262,-46.404687314809991,null,null,null,null,null,{"$error":"#DIV/0!"}]
[1.9800000000000012E-2,6.2203534541077943,-14.441819491741237,0,-14.214781741246782,-14.689385558994207,-12.324016284516283,-55.67000307649851,null,null,null,null,null,null,null,0.22703775049445518,-26.786364093016033,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.0300000000000012E-2,6.377433086787283,21.644912063258928,0,20.883562988019793,21.145293351028165,17.252554601500979,80.926323003807866,null,null,null,null,null,null,null,-0.76134907523913498,37.636498877290009,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.0800000000000013E-2,6.5345127194667745,57.198674047917613,0,43.748599749577352,33.888910150139552,17.721804583842541,152.55798853147706,null,null,null,null,null,null,null,-13.450074298340262,38.160640435641831,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.1300000000000013E-2,6.6915923521462641,91.344014846000505,0,40.986300112664416,9.6251931583524151,-11.707952562259385,130.24755555475795,null,null,null,null,null,null,null,-50.357714733336088,-52.440474137243058,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.1800000000000014E-2,6.8486719848257538,{"$f":"SIN(C$11*$B68)*vp*C$12","v":123.2401628451701},0,14.214781741246632,-25.149417646039385,-21.384859175429416,90.920667764947936,null,null,null,null,null,null,null,-109.02538110392348,-155.55965792539229,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.2300000000000014E-2,7.0057516175052434,152.10172902444071,0,-20.883562988019936,-32.460386528920367,5.0172945521213137,103.77507405962172,null,null,null,null,null,null,null,-172.98529201246066,-200.42838398925971,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.2800000000000015E-2,7.1628312501847331,177.2180458384322,0,-43.748599749577401,-4.3239965579673232,22.954614753850194,152.10006428473767,null,null,null,null,null,null,null,-220.96664558800961,-202.33602739212674,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.3300000000000015E-2,7.3199108828642228,197.97066621090758,0,-40.986300112664495,28.534279812473031,2.1644912063249406,187.68313711704104,null,null,null,null,null,null,null,-238.95696632357209,-208.25819530477412,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.3800000000000016E-2,7.4769905155437115,213.84859175429813,0,-14.214781741246791,30.232580461512871,-22.277412705958742,207.58897776860547,null,null,null,null,null,null,null,-228.06337349554491,-220.10820573999078,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.4300000000000016E-2,7.634070148223203,224.46085524591217,0,20.883562988020369,-1.0836711881967571,-9.1344014845988006,235.12634556113699,null,null,null,null,null,null,null,-203.5772922578918,-213.79536493068736,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.4800000000000016E-2,7.7911497809026926,229.54614753850254,0,43.748599749577444,-31.216533310078226,19.419542286546857,261.49775626454857,null,null,null,null,null,null,null,-185.7975477889251,-197.59453881245648,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.5300000000000017E-2,7.9482294135821823,228.9792518587083,0,40.986300112664424,-27.260347926960542,15.210172902443269,257.91537694685547,null,null,null,null,null,null,null,-187.99295174604387,-200.04312677056114,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.5800000000000017E-2,8.1053090462616719,222.77412705958483,0,14.21478174124633,6.4646553532087125,-14.660751764220628,228.79281238981923,null,null,null,null,null,null,null,-208.5593453183385,-216.75544172935042,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.6300000000000018E-2,8.2623886789411607,211.08356390731527,0,-20.883562988020216,33.130132155854803,-19.797066621090192,203.53306645405968,null,null,null,null,null,null,null,-231.96712689533547,-218.63406136057085,null,null,null,null,null,{"$error":"#DIV/0!"}]
[2.6800000000000018E-2,8.4194683116206512,194.1954228654628,0,-43.748599749577401,23.616875154538725,8.4668647117485474,182.53056298217265,null,null,null,null,null,null,null,-237.94402261504021,-205.86028274875292,null,null,null,null,null,{"$error":"#DIV/0!"}]

{"sheet":"verzadiging","index":7,"n_rows":78,"n_cols":13,"rows_kept":78,"cut":false,"hidden":false,"merged":[]}
[null,"vp",230,null,"V"]
[null,"stap",8.0000000000000004E-4]
[null,"basefreq",50,null,"Hz"]
[null,"3thHarmFreq",150,null,"Hz"]
[]
[]
[]
[]
[null,null,100,100,50,10,0.8]
[]
[]
[]
[]
["max",null,null,null,100]
["min",null,null,null,-40]
["vermenigv",null,200,150,50,0.9,0.9,5,0]
["[s]","wt","spanning","stroom zonder e","flux","tegen emk","stroom met e","spanning sec","som","a","b","c","d"]
[0,{"$f":"2*PI()*A18*basefreq","v":0},{"$f":"SIN($B18)*$C$16","v":0},{"$f":"COS($B18)*$D$16","v":150},{"$f":"IF(COS($B18)*$E$16>$E$14,$E$14,IF(COS($B18)*$E$16<$E$15,$E$15,COS($B18)*$E$16))","v":50},0,{"$f":"IF(F18=0,D18*$G$16,E18*$G$16)","v":135},0]
[{"$f":"A18+stap","v":8.0000000000000004E-4},0.25132741228718347,{"$f":"SIN($B19)*$C$16","v":49.737977432970958},{"$f":"COS($B19)*$D$16","v":145.28747416929465},{"$f":"IF(COS($B19)*$E$16>$E$14,$E$14,IF(COS($B19)*$E$16<$E$15,$E$15,COS($B19)*$E$16))","v":48.429158056431554},{"$f":"IF(E19-E18=0,0,C18*$F$16)","v":0},{"$f":"IF(F19=0,D19*$G$16,E19*$G$16)","v":130.75872675236519},{"$f":"-1*(E19-E18)*$H$16","v":7.854209717842231}]
[1.6000000000000001E-3,0.50265482457436694,96.350734820343064,131.44600200657953,43.815334002193183,{"$f":"IF(E20-E19=0,0,C19*$F$16)","v":44.76417968967386},39.433800601973864,{"$f":"-1*(E20-E19)*$H$16","v":23.069120271191856}]
[2.4000000000000002E-3,0.75398223686155041,136.90942118573776,109.34529411321174,36.448431371070576,86.715661338308763,32.803588233963517,36.834513155613031]
[3.2000000000000002E-3,1.0053096491487339,168.86558510040302,80.374019246849485,26.791339748949827,123.21847906716398,24.112205774054846,48.285458110603741]
[4.0000000000000001E-3,1.2566370614359172,190.2113032590307,46.352549156242119,15.450849718747373,151.97902659036274,13.905764746872636,56.702450151012272]
[4.8000000000000004E-3,1.5079644737231008,199.6053456856543,9.4185779293969958,3.1395259764656651,171.19017293312763,2.8255733788190986,61.556618711408539]
[5.6000000000000008E-3,1.7592918860102846,196.45745014573771,-28.107197187858755,-9.3690657292862518,179.64481111708886,-8.4321591563576277,62.542958528759584]
[6.4000000000000012E-3,2.0106192982974678,180.9654104932039,-63.866893734760907,-21.288964578253637,176.81170513116393,-19.160068120428274,59.599494244836926]
[7.2000000000000015E-3,2.2619467105846516,154.10264855515777,-95.613598462303514,-31.871199487434502,162.86886944388351,-28.684079538691051,52.911174545904331]
[8.0000000000000019E-3,2.5132741228718349,117.55705045849456,-121.35254915624215,-40,138.69238369964199,-36,40.644002562827488]
[8.8000000000000023E-3,2.7646015351590187,73.62491053693546,-139.46647288323774,-40,0,-125.51982559491397,0]
[9.6000000000000026E-3,3.0159289474462021,25.066646712860731,-148.81720519717169,-40,0,-133.93548467745453,0]
[1.0400000000000003E-2,3.2672563597333859,-25.066646712861036,-148.81720519717166,-40,0,-133.9354846774545,0]
[1.1200000000000003E-2,3.5185837720205693,-73.624910536935744,-139.46647288323766,-40,0,-125.5198255949139,0]
[1.2000000000000004E-2,3.7699111843077531,-117.55705045849483,-121.35254915624201,-40,0,-109.2172942406178,0]
[1.2800000000000004E-2,4.0212385965949364,-154.102648555158,-95.613598462303329,-31.871199487434442,-105.80134541264535,-28.684079538690998,-40.644002562827794]
[1.3600000000000004E-2,4.2725660088821202,-180.96541049320402,-63.866893734760701,-21.288964578253566,-138.69238369964219,-19.16006812042821,-52.91117454590438]
[1.4400000000000005E-2,4.5238934211693032,-196.45745014573777,-28.107197187858564,-9.3690657292861879,-162.86886944388363,-8.4321591563575691,-59.59949424483689]
[1.5200000000000005E-2,4.775220833456487,-199.6053456856543,9.4185779293971912,3.1395259764657304,-176.81170513116399,2.8255733788191573,-62.542958528759591]
[1.6000000000000004E-2,5.0265482457436699,-190.21130325903067,46.352549156242212,15.450849718747403,-179.64481111708886,13.905764746872663,-61.556618711408362]
[1.6800000000000002E-2,5.2778756580308537,-168.86558510040291,80.374019246849628,26.791339748949877,-171.1901729331276,24.112205774054889,-56.702450151012371]
[1.7600000000000001E-2,5.5292030703180357,-136.90942118573778,109.34529411321168,36.448431371070562,-151.97902659036262,32.803588233963509,-48.285458110603429]
[1.84E-2,5.7805304826052195,-96.350734820343064,131.44600200657953,43.815334002193183,-123.21847906716401,39.433800601973864,-36.834513155613102]
[1.9199999999999998E-2,6.0318578948924024,-49.737977432971071,145.28747416929465,48.429158056431547,-86.715661338308763,43.586242250788395,-23.069120271191821]
[1.9999999999999997E-2,6.2831853071795853,-2.2664162213636985E-13,150,50,-44.764179689673966,45,-7.8542097178422665]
[2.0799999999999996E-2,6.5345127194667691,49.737977432970801,145.28747416929468,48.429158056431568,-2.0397745992273286E-13,43.586242250788409,7.8542097178421599]
[2.1599999999999994E-2,6.7858401317539503,96.35073482034251,131.44600200657976,43.815334002193254,44.764179689673725,39.433800601973928,23.069120271191572]
[2.2399999999999993E-2,7.0371675440411341,136.90942118573733,109.34529411321202,36.448431371070669,86.715661338308266,32.803588233963602,36.834513155612925]
[2.3199999999999991E-2,7.2884949563283179,168.86558510040274,80.374019246849798,26.791339748949934,123.2184790671636,24.112205774054942,48.28545811060367]
[2.399999999999999E-2,7.5398223686155008,190.21130325903053,46.352549156242532,15.450849718747511,151.97902659036248,13.905764746872761,56.702450151012115]
[2.4799999999999989E-2,7.7911497809026828,199.60534568565427,9.4185779293976637,3.139525976465888,171.19017293312749,2.8255733788192994,61.556618711408113]
[2.5599999999999987E-2,{"$f":"2*PI()*A50*basefreq","v":8.0424771931898658},196.45745014573791,-28.10719718785797,-9.3690657292859907,179.64481111708884,-8.4321591563573914,62.542958528759399]
[{"$f":"A50+stap","v":2.6399999999999986E-2},8.2938046054770496,180.9654104932043,-63.866893734760275,-21.288964578253424,176.81170513116413,-19.160068120428082,59.599494244837167]
[2.7199999999999985E-2,8.5451320177642334,154.1026485551584,-95.61359846230296,-31.871199487434321,162.86886944388388,-28.684079538690888,52.911174545904487]
[2.7999999999999983E-2,8.7964594300514154,117.55705045849554,-121.35254915624162,-40,138.69238369964256,-36,40.644002562828391]
[2.8799999999999982E-2,9.0477868423385974,73.624910536936909,-139.46647288323732,-40,0,-125.51982559491358,0]
[2.959999999999998E-2,9.2991142546257812,25.066646712862191,-148.81720519717155,-40,0,-133.93548467745438,0]
[3.0399999999999979E-2,9.550441666912965,-25.066646712859576,-148.8172051971718,-40,0,-133.93548467745464,0]
[3.1199999999999978E-2,9.8017690792001471,-73.624910536934124,-139.46647288323814,-40,0,-125.51982559491432,0]
[3.199999999999998E-2,10.053096491487331,-117.55705045849341,-121.35254915624277,-40,0,-109.2172942406185,0]
[3.2799999999999982E-2,10.304423903774516,-154.10264855515717,-95.613598462304083,-31.871199487434694,-105.80134541264407,-28.684079538691226,-40.644002562826529]
[3.3599999999999984E-2,10.5557513160617,-180.96541049320348,-63.866893734761582,-21.288964578253861,-138.69238369964145,-19.160068120428477,-52.911174545904167]
[3.4399999999999986E-2,10.807078728348884,-196.45745014573757,-28.107197187859384,-9.3690657292864614,-162.86886944388314,-8.432159156357816,-59.599494244836997]
[3.5199999999999988E-2,11.058406140636068,-199.60534568565436,9.4185779293963563,3.1395259764654524,-176.81170513116382,2.8255733788189072,-62.54295852875957]
[3.599999999999999E-2,11.309733552923253,-190.21130325903087,46.3525491562418,15.450849718747268,-179.64481111708892,13.905764746872542,-61.556618711409072]
[3.6799999999999992E-2,11.561060965210435,-168.86558510040342,80.374019246849031,26.791339748949678,-171.1901729331278,24.112205774054711,-56.702450151012052]
[3.7599999999999995E-2,11.812388377497621,-136.90942118573795,109.34529411321157,36.448431371070519,-151.97902659036308,32.803588233963467,-48.28545811060421]
[3.8399999999999997E-2,12.063715789784805,-96.350734820343263,131.44600200657945,43.815334002193154,-123.21847906716417,39.433800601973843,-36.834513155613173]
[3.9199999999999999E-2,12.315043202071989,-49.737977432971121,145.28747416929465,48.429158056431547,-86.715661338308934,43.586242250788395,-23.069120271191963]
[0.04,12.566370614359174,2.5725949148736049E-13,150,50,-44.764179689674009,45,-7.8542097178422665]
[4.0800000000000003E-2,12.817698026646356,49.737977432970929,145.28747416929468,48.429158056431561,2.3153354233862444E-13,43.586242250788409,7.8542097178421955]
[4.1600000000000005E-2,13.06902543893354,96.350734820343092,131.44600200657953,43.815334002193175,44.764179689673838,39.433800601973857,23.069120271191927]
[4.2400000000000007E-2,13.320352851220726,136.90942118573807,109.34529411321148,36.448431371070491,86.715661338308792,32.803588233963445,36.834513155613422]
[4.3200000000000009E-2,13.571680263507909,168.86558510040331,80.374019246849144,26.791339748949717,123.21847906716427,24.112205774054747,48.285458110603869]
[4.4000000000000011E-2,13.823007675795093,190.2113032590309,46.352549156241686,15.450849718747229,151.97902659036299,13.905764746872507,56.702450151012442]
[4.4800000000000013E-2,14.074335088082277,199.60534568565436,9.4185779293965037,3.1395259764655012,171.19017293312783,2.8255733788189512,61.556618711408639]
[4.5600000000000016E-2,14.325662500369463,196.45745014573751,-28.107197187859501,-9.3690657292865005,179.64481111708892,-8.4321591563578515,62.54295852876001]
[4.6400000000000018E-2,14.576989912656646,180.96541049320339,-63.866893734761689,-21.288964578253896,176.81170513116376,-19.160068120428509,59.599494244836976]
[4.720000000000002E-2,14.828317324943828,154.10264855515729,-95.613598462303955,-31.871199487434655,162.86886944388306,-28.68407953869119,52.911174545903791]
[4.8000000000000022E-2,15.079644737231012,117.55705045849385,-121.35254915624253,-40,138.69238369964157,-36,40.644002562826728]

{"sheet":"bh curve","index":8,"n_rows":26,"n_cols":10,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
[]
[null,"u0",0.5]
[null,"ur",10]
[null,"H",4]
[null,"bmax",1000]
[null,"b=",{"$f":"IF(u0*H+u0*(ur-1)*H>bmax,bmax,u0*H+u0*(ur-1)*H)","v":20},null,null,null,"B"]
[]
[null,null,null,"B"]
[null,null,"H",{"$f":"C6","v":20},null,{"$f":"C6","v":20},0.01,0.5,1,2]
[null,null,-8,-40,null,-8,-0.79999999999999993,-40,-80,-160]
[null,null,-7,-35,null,-7,-0.7,-35,-70,-140]
[null,null,-6,-30,null,-6,-0.60000000000000009,-30,-60,-120]
[null,null,-5,-25,null,-5,-0.49999999999999994,-25,-50,-100]
[null,null,-4,-20,null,-4,-0.39999999999999997,-20,-40,-80]
[null,null,-3,-15,null,-3,-0.30000000000000004,-15,-30,-60]
[null,null,-2,-10,null,-2,-0.19999999999999998,-10,-20,-40]
[null,null,-1,-5,null,-1,-9.9999999999999992E-2,-5,-10,-20]
[null,null,0,0,null,0,0,0,0,0]
[null,null,1,5,null,1,9.9999999999999992E-2,5,10,20]
[null,null,2,10,null,2,0.19999999999999998,10,20,40]
[null,null,3,15,null,3,0.30000000000000004,15,30,60]
[null,null,4,20,null,4,0.39999999999999997,20,40,80]
[null,null,5,25,null,5,0.49999999999999994,25,50,100]
[null,null,6,30,null,6,0.60000000000000009,30,60,120]
[null,null,7,35,null,7,0.7,35,70,140]
[null,null,8,40,null,8,0.79999999999999993,40,80,160]

{"sheet":"magnetic core","index":9,"n_rows":63,"n_cols":15,"rows_kept":63,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"wat is de stroom?",null,null,null,"wat is het magneetveld bij een stroom?"]
[null,null,"luchtspleet","Lspleet",5.0000000000000001E-3,"cm"]
[null,null,"lengte ijzer","Lcore",0.23499999999999999,"cm"]
[null,null,"oppervlak core","Acore",5.9999999999999995E-4,"m2"]
[null,null,"oppervlak lucht","Alucht",8.7500000000000002E-4,"m2"]
[null,null,null,"ugap",{"$f":"4*PI()*0.0000001","v":1.2566370614359173E-6}]
[null,null,null,"ucore",7.5399999999999998E-3,null,null,"stroom",{"$f":"stroom","v":2.0121628054479843}]
[null,null,null,null,null,null,null,"N",500]
[null,null,null,"Rcore",{"$f":"Lcore/ucore/Acore","v":51945.181255526084},"A.turns/Wb",null,"MMF",{"$f":"I26*I25","v":1006.0814027239921}]
[null,null,null,"Rgap",{"$f":"Lspleet/ugap/Alucht","v":4547284.0883398671},"A.turns/Wb",null,"Rtotal",{"$f":"Rtotal","v":4599229.269595393}]
["R",null,null,"Rtotal",{"$f":"Rgap+Rcore","v":4599229.269595393},null,null,"fluxGap",{"$f":"I27/I28","v":2.1874999999999998E-4}]
[null,null,null,null,null,null,null,"Bgap",{"$f":"I29/Alucht","v":0.24999999999999997}]
[null,null,null,"Bgap",0.25,"T"]
[null,null,null,"fluxGap",{"$f":"Bgap*Alucht","v":2.1875E-4}]
["U",null,"f","MMF",{"$f":"fluxGap*Rtotal","v":1006.0814027239923},"A.turns"]
[null,null,null,"N",500]
[null,null,null,"stroom",{"$f":"MMF/N","v":2.0121628054479843},"A"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"hoe kleiner de luchtspleet, hoe hoger de B bij een bepaalde stroom"]
[]
[]
[null,null,null,"luchtspleet lengte"]
[null,null,{"$f":"stroom","v":2.0121628054479843},1E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3,null,{"$f":"I30","v":0.24999999999999997},1E-3,2E-3,3.0000000000000001E-3,4.0000000000000001E-3,5.0000000000000001E-3]
[null,"Bgap",0.1,0.1682453498116124,0.32740029290350781,0.48655523599540312,0.64571017908729844,0.80486512217919393,null,0.5,0.29718503397559559,0.15271825066673389,0.10276325543534463,7.7434120785697155E-2,6.2122209823956172E-2]
[null,null,0.15,0.25236802471741854,0.4911004393552616,0.7298328539931046,0.9685652686309475,1.2072976832687905,null,1,0.59437006795119118,0.30543650133346778,0.20552651087068927,0.15486824157139431,0.12424441964791234]
[null,null,0.2,0.33649069962322481,0.65480058580701561,0.97311047199080625,1.2914203581745969,1.6097302443583879,null,1.5,0.89155510192678689,0.45815475200020173,0.30828976630603389,0.23230236235709145,0.18636662947186855]
[null,null,0.25,0.42061337452903097,0.8185007322587694,1.2163880899885078,1.6142754477182459,2.0121628054479843,null,2,1.1887401359023824,0.61087300266693556,0.41105302174137853,0.30973648314278862,0.24848883929582469]
[null,null,0.3,0.50473604943483708,0.9822008787105232,1.4596657079862092,1.937130537261895,2.414595366537581,null,2.5,1.4859251698779781,0.76359125333366962,0.51381627717672329,0.38717060392848573,0.31061104911978088]
[null,null,0.35,0.58885872434064335,1.1459010251622772,1.7029433259839106,2.2599856268055443,2.8170279276271781,null,3,1.7831102038535738,0.91630950400040345,0.61657953261206777,0.4646047247141829,0.3727332589437371]
[null,null,0.4,0.67298139924644962,1.3096011716140312,1.9462209439816125,2.5828407163491938,3.2194604887167757,null,3.5,2.0802952378291693,1.0690277546671374,0.71934278804741247,0.54203884549988002,0.43485546876769321]
[null,null,0.45,0.75710407415225578,1.473301318065785,2.1894985619793137,2.9056958058928428,3.6218930498063719,null,4,2.3774802718047647,1.2217460053338711,0.82210604348275707,0.61947296628557724,0.49697767859164937]
[null,null,0.5,0.84122674905806194,1.6370014645175388,2.4327761799770156,3.2285508954364919,4.0243256108959686,null,4.5,2.6746653057803607,1.3744642560006053,0.92486929891810188,0.69690708707127436,0.55909988841560565]
[null,null,0.55000000000000004,0.92534942396386832,1.8007016109692928,2.6760537979747174,3.5514059849801414,4.4267581719855658,null,5,2.9718503397559561,1.5271825066673392,1.0276325543534466,0.77434120785697147,0.62122209823956176]

{"sheet":"voorbeeld 3,8 blad 3.10","index":10,"n_rows":85,"n_cols":17,"rows_kept":85,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"wijzig de waarden in de rode cirkels"]
[null,null,null,null,null,null,null,null,null,"Ia","graden",null,null,null,null,null,"de rode cellen geven de stromen weer."]
[null,null,null,null,null,null,null,null,null,{"$f":"I71","v":{"$error":"#NUM!"}},{"$f":"J71","v":{"$error":"#NUM!"}}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"Ra","Xa"]
[null,null,null,null,null,null,null,null,null,null,null,null,10,0]
[]
[null,"Uc","graden",null,null,null,"Ua","graden",null,null,null,null,"Un","graden"]
[null,400,210,null,null,null,400,90,null,null,null,null,{"$f":"I69","v":{"$error":"#NUM!"}},{"$f":"J69","v":{"$error":"#NUM!"}}]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Rc","Xc",null,null,"Rb","Xb"]
[null,null,null,null,null,null,null,null,null,0,-10,null,null,0,10]
[]
[]
[]
[null,null,null,null,"Ub","graden"]
[null,null,null,null,400,-30]
[]
[]
[null,null,null,null,"Ic","graden",null,null,null,null,null,"Ib","graden"]
[null,null,null,null,{"$f":"I75","v":{"$error":"#NUM!"}},{"$f":"J75","v":{"$error":"#NUM!"}},null,null,null,null,null,{"$f":"I73","v":{"$error":"#NUM!"}},{"$f":"J73","v":{"$error":"#NUM!"}}]
[null,"EVZ01dl3-driefasensystemen hogeschool rotterdam",null,null,null,"EVZ01dl3-driefasensystemen.pdf"]
[null,null,null,null,"schaal",1]
[null,null,"shapename","Xo","Yo","Xe","Ye","TextVisible"]
[null,null,"_Ua",0,0,100,100,"x"]
[null,null,"_Ub",{"$f":"F36","v":-346.41016151377545},{"$f":"G36","v":-200.00000000000006},{"$f":"D46","v":346.41016151377551},-199.99999999999997,"x"]
[null,null,"_Uc",{"$f":"F34","v":100},{"$f":"G34","v":100},{"$f":"D47","v":-346.41016151377545},-200.00000000000006,"x"]
[null,null,"_Un",0,0,{"$f":"G69","v":{"$error":"#NUM!"}},{"$f":"H69","v":{"$error":"#NUM!"}},"x"]
[null,null,"Ub-Un",0,0,{"$f":"G72","v":{"$error":"#NUM!"}},{"$f":"H72","v":{"$error":"#NUM!"}},"x"]
[null,null,"_In",0,0,{"$f":"G77","v":{"$error":"#NUM!"}},{"$f":"H77","v":{"$error":"#NUM!"}},"x"]
[null,null,"_Ia",0,0,{"$f":"G71","v":{"$error":"#NUM!"}},{"$f":"H71","v":{"$error":"#NUM!"}},"x"]
[null,null,"_Ib",0,0,{"$f":"G73","v":{"$error":"#NUM!"}},{"$f":"H73","v":{"$error":"#NUM!"}},"x"]
[null,null,"_Ic",0,0,{"$f":"G75","v":{"$error":"#NUM!"}},{"$f":"H75","v":{"$error":"#NUM!"}},"x"]
[]
[null,null,null,"X","Y",null,"Re","Im","abs","hoek"]
[null,null,"Ua",{"$f":"G15*COS(H15*2*PI()/360)","v":2.45029690981724E-14},{"$f":"G15*SIN(H15*2*PI()/360)","v":400},{"$f":"COMPLEX(D45,E45,\"i\")","v":"2,45029690981724E-14+400i"},{"$f":"IMREAL(F45)","v":2.45029690981724E-14},{"$f":"IMAGINARY(F45)","v":400},{"$f":"IMABS(F45)","v":400},{"$f":"IMARGUMENT(F45)*360/2/PI()","v":90}]
[null,null,"Ub",{"$f":"E26*COS(F26*2*PI()/360)","v":346.41016151377551},{"$f":"E26*SIN(F26*2*PI()/360)","v":-199.99999999999997},{"$f":"COMPLEX(D46,E46,\"i\")","v":"346,410161513776-200i"},{"$f":"IMREAL(F46)","v":346.41016151377602},{"$f":"IMAGINARY(F46)","v":-200},400.00000000000045,-29.999999999999961]
[null,null,"Uc",{"$f":"B15*COS(C15*2*PI()/360)","v":-346.41016151377545},{"$f":"B15*SIN(C15*2*PI()/360)","v":-200.00000000000006},{"$f":"COMPLEX(D47,E47,\"i\")","v":"-346,410161513775-200i"},-346.41016151377499,-200,399.9999999999996,-149.99999999999997]
[null,null,"Za",null,null,{"$f":"COMPLEX(M12,N12,\"i\")","v":"10"},10,0,10,0]
[null,null,"Zb",null,null,{"$f":"COMPLEX(N21,O21,\"i\")","v":"10i"},0,10,10,90]
[null,null,"Zc",null,null,{"$f":"COMPLEX(J21,K21,\"i\")","v":"-10i"},0,-10,10,-90]
[]
[null,null,"Zab",null,null,{"$f":"IMSUM(F48,F49,IMDIV(IMPRODUCT(F48,F49),F50))","v":"10i"},{"$f":"IMREAL(F52)","v":0},{"$f":"IMAGINARY(F52)","v":10},{"$f":"IMABS(F52)","v":10},{"$f":"IMARGUMENT(F52)*360/2/PI()","v":90}]
[null,null,"Zbc",null,null,{"$f":"IMSUM(F49,F50,IMDIV(IMPRODUCT(F49,F50),F48))","v":"10"},{"$f":"IMREAL(F53)","v":10},{"$f":"IMAGINARY(F53)","v":0},{"$f":"IMABS(F53)","v":10},{"$f":"IMARGUMENT(F53)*360/2/PI()","v":0}]
[null,null,"Zca",null,null,{"$f":"IMSUM(F50,F48,IMDIV(IMPRODUCT(F50,F48),F49))","v":"-10i"},0,-10,10,-90]
[]
[]
[null,null,"Ia",null,null,{"$f":"IMDIV(F45,F52)","v":"40-2,45029690981724E-15i"},null,null,{"$f":"IMABS(F57)","v":40},{"$f":"IMARGUMENT(F57)*360/2/PI()","v":-3.5097917871618886E-15}]
[null,null,"Ib",null,null,{"$f":"IMDIV(F46,F53)","v":"34,6410161513776-20i"},null,null,{"$f":"IMABS(F58)","v":40.000000000000043},{"$f":"IMARGUMENT(F58)*360/2/PI()","v":-29.999999999999961}]
[null,null,"Ic",null,null,"20-34,6410161513775i",null,null,{"$f":"IMABS(F59)","v":39.999999999999957},{"$f":"IMARGUMENT(F59)*360/2/PI()","v":-59.999999999999972}]
[]
[null,null,"som stromen",null,null,{"$f":"IMSUM(F58,F59,F57)","v":"94,6410161513776-54,6410161513775i"},null,null,{"$f":"IMABS(F61)","v":109.2820323027551},{"$f":"IMARGUMENT(F61)*360/2/PI()","v":-29.999999999999964}]
[]
[null,null,"1/Za",null,null,{"$f":"IMDIV(1,F48)","v":"0,1"},null,null,0.1,0]
[null,null,"1/Zb",null,null,{"$f":"IMDIV(1,F49)","v":"-0,1i"},null,null,0.1,-90]
[null,null,"1/Zc",null,null,{"$f":"IMDIV(1,F50)","v":"0,1i"},null,null,0.1,90]
[null,null,"1/Zn",null,null,{"$f":"IMDIV(1,F51)","v":{"$error":"#NUM!"}},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"som Z",null,null,{"$f":"IMSUM(F63,F64,F65,F66)","v":{"$error":"#NUM!"}},null,null,{"$error":"#NUM!"},{"$error":"#NUM!"}]
[]
[null,"a. berekening Un","Un",null,null,{"$f":"IMDIV(F61,F67)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$f":"IMAGINARY(F69)","v":{"$error":"#NUM!"}},{"$f":"IMABS(F69)","v":{"$error":"#NUM!"}},{"$f":"IMARGUMENT(F69)*360/2/PI()","v":{"$error":"#NUM!"}}]
[null,"b","Ua-Un",null,null,{"$f":"IMSUB(F45,F69)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Ia",null,null,{"$f":"IMDIV(F70,F48)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Ub-Un",null,null,{"$f":"IMSUB(F46,F69)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Ib",null,null,{"$f":"IMDIV(F72,F49)","v":{"$error":"#NUM!"}},{"$f":"IMREAL(F73)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Uc-Un",null,null,{"$f":"IMSUB(F47,F69)","v":{"$error":"#NUM!"}},{"$f":"IMREAL(F74)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Ic",null,null,{"$f":"IMDIV(F74,F50)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"Un-ster",null,null,{"$f":"IMSUB(F69,0)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"In",null,null,{"$f":"IMDIV(F76,F51)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"c","PspanningA",null,null,{"$f":"IMPRODUCT(F71,F45)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"PspanningB",null,null,{"$f":"IMPRODUCT(F73,F46)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"PspanningC",null,null,{"$f":"IMPRODUCT(F75,F47)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"d","vermogenA",null,null,{"$f":"IMPRODUCT(IMPOWER(F71,2),F48)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"vermogenB",null,null,{"$f":"IMPRODUCT(IMPOWER(F73,2),F49)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"vermogenC",null,null,{"$f":"IMPRODUCT(IMPOWER(F75,2),F50)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"vermogen nul",null,null,{"$f":"IMPRODUCT(IMPOWER(F77,2),F51)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,null,"som vermogen",null,null,{"$f":"IMSUM(F82,F83)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]