{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":48,"n_cols":10,"rows_kept":48}
["Ricardo Gaspar","Nº 35377"]
["A",{"$f":"2+7","v":9}]
["B",{"$f":"3+7","v":10}]
["C",{"$f":"1+2","v":3}]
["D",{"$f":"5+5","v":10}]
[]
[]
["Exercício 1"]
[]
["R2 (KOhm)",1]
[]
["V1 (V)","R1 (KOhm)","ID1 calculado (mA)","ID1 correcto (mA)","ID2 calculado (mA)","ID2 correcto (mA)"]
[1,{"$f":"$B$2","v":9},{"$f":"((A13-1.8)*$B$10-0.6*B13)/($B$10*B13)","v":-0.6888888888888888},{"$f":"IF(C13<0,0,C13)","v":0},{"$f":"IF(D13=0,(A13-1.8)/(B13+$B$10),(0.6/$B$10)+D13)","v":-0.08},{"$f":"IF(E13<0,0,E13)","v":0}]
[2.2,{"$f":"$B$4","v":3},{"$f":"((A14-1.8)*$B$10-0.6*B14)/($B$10*B14)","v":-0.46666666666666656},{"$f":"IF(C14<0,0,C14)","v":0},{"$f":"IF(D14=0,(A14-1.8)/(B14+$B$10),(0.6/$B$10)+D14)","v":0.10000000000000003},{"$f":"IF(E14<0,0,E14)","v":0.10000000000000003}]
[2.2,{"$f":"$B$3/10","v":1},-0.19999999999999984,0,0.20000000000000007,0.20000000000000007]
[3.8,{"$f":"B4","v":3},0.06666666666666665,0.06666666666666665,0.6666666666666666,0.6666666666666666]
[3.8,{"$f":"$B$4/10","v":0.3},6.066666666666666,6.066666666666666,6.666666666666666,6.666666666666666]
[3.8,{"$f":"$B$3/4","v":2.5},0.1999999999999999,0.1999999999999999,0.7999999999999998,0.7999999999999998]
[3.8,{"$f":"ROUND(B5/3,2)","v":3.33},{"$f":"((A19-1.8)*$B$10-0.6*B19)/($B$10*B19)","v":6.0060060060053444E-4},6.0060060060053444E-4,0.6006006006006005,0.6006006006006005]
[6,{"$f":"$B$2","v":9},-0.13333333333333325,0,0.42000000000000004,0.42000000000000004]
[6,{"$f":"$B$3/5","v":2},1.5,1.5,2.1,2.1]
[6,{"$f":"$B$4/2","v":1.5},2.2,2.2,2.8000000000000003,2.8000000000000003]
[6,{"$f":"$B$2+$B$5+$B$4","v":22},-0.4090909090909091,0,0.1826086956521739,0.1826086956521739]
[]
[]
[]
[]
[]
[]
["Exercício 2"]
[]
["R2 (KOhm)",10]
[]
["V1 (V)","V1 alterado (V)","Vz (V)","Vz funcionamento (V)","R1 (KOhm)","I1 (mA)","I2 (mA)","ID calculado (mA)","ID correcto (mA)"]
[-1,1,{"$f":"$B$2","v":9},0.6,{"$f":"$B$2","v":9},{"$f":"I35+(D35/$B$32)","v":0.044444444444444446},{"$f":"F35","v":0.044444444444444446},{"$f":"((B35-D35)*$B$32-D35*E35)/(E35*$B$32)","v":-0.01555555555555555},{"$f":"H35","v":-0.01555555555555555}]
[-6,6,{"$f":"$B$4","v":3},0.6,{"$f":"$B$3","v":10},{"$f":"I36+(D36/$B$32)","v":0.54},{"$f":"F36","v":0.54},{"$f":"((B36-D36)*$B$32-D36*E36)/(E36*$B$32)","v":0.48},{"$f":"H36","v":0.48}]
[-6,6,{"$f":"$B$3/10","v":1},0.6,{"$f":"$B$4","v":3},1.8,{"$f":"F37","v":1.8},{"$f":"((B37-D37)*$B$32-D37*E37)/(E37*$B$32)","v":1.74},1.74]
[-6,6,{"$f":"B26","v":0},0.6,{"$f":"$B$5","v":10},0.54,{"$f":"F38","v":0.54},0.48,0.48]
[10,10,{"$f":"$B$4/10","v":0.3},{"$f":"C39","v":0.3},{"$f":"$B$2","v":9},1.0777777777777777,{"$f":"F39","v":1.0777777777777777},1.0477777777777777,1.0477777777777777]
[10,10,{"$f":"$B$3/4","v":2.5},{"$f":"C40","v":2.5},{"$f":"$B$3","v":10},0.75,{"$f":"F40","v":0.75},0.5,0.5]
[6,6,{"$f":"ROUND(B3/3,2)","v":3.33},3.33,{"$f":"$B$4","v":3},{"$f":"I41+(D41/$B$32)","v":0.8900000000000001},{"$f":"F41","v":0.8900000000000001},0.557,0.557]
[6,6,{"$f":"$B$2","v":9},9,{"$f":"$B$5","v":10},{"$f":"B42/(E42+B32)","v":0.3},{"$f":"F42","v":0.3},-1.2,0,"Está ao corte"]
[6,6,{"$f":"$B$3/5","v":2},2,{"$f":"$B$2","v":9},{"$f":"I43+(D43/$B$32)","v":0.4444444444444444},0.4444444444444444,0.24444444444444444,{"$f":"H43","v":0.24444444444444444}]
[3,3,{"$f":"$B$4/2","v":1.5},1.5,{"$f":"$B$3","v":10},{"$f":"B44/(E44+B32)","v":0.15},0.15,0,0,"Está ao corte"]
[3,3,{"$f":"$B$2+$B$5+$B$4","v":22},22,{"$f":"$B$4","v":3},{"$f":"B45/(E45+B32)","v":0.23076923076923078},{"$f":"F45","v":0.23076923076923078},-8.533333333333333,0,"Está ao corte"]
[]
[]
[null,null,"Nota: Quando a tensão é negativa, eu optei por virar a fonte. Assim o díodo funciona a 0,6V."]