{"text_format":"3","workbook":"ods","n_sheets":8,"sheets":["Finanzierung","TILHyp1","TILHyp2","TIL_B1","TIL_B2","Verlauf","Dia_Belastung","Dia_ZinsTilg"],"not_rendered":{"charts":2,"images":2,"defined_names":21,"comments":9},"read":"whole","date_system":"iso_in_file"}

{"sheet":"Finanzierung","index":0,"n_rows":33,"n_cols":11,"rows_kept":33}
[{"$nulls":6},"Berechnung der Hypothek für ein Haus"]
[null,"Erwerbskosten",{"$nulls":8},"Betrag"]
[{"$nulls":3},"Kaufpreis Immobilie",null,null,"Neu / Gebraucht:","G",null,null,{"v":200000,"d":"200.000 €"}]
[{"$nulls":3},"Grundstückswert",{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":3},"Grunderwerbssteuer",null,null,{"v":0.035,"d":"3,50%"},{"$nulls":3},{"$f":"of:=IF([.K4]=0;[.K3]*[.G5];[.K4]*[.G5])","v":7000}]
[{"$nulls":3},"Notar-/Gerichtskosten",null,null,{"v":0.02,"d":"2,00%"},{"$nulls":3},{"$f":"of:=([.K3]+[.K4])*[.G6]","v":{"v":4000,"d":"4.000 €"}}]
[{"$nulls":3},"Maklerkosten","[j/n]:","J",{"v":0.05,"d":"5,00%"},{"$nulls":3},{"$f":"of:=IF([.F7]=\"J\";([.K3]+[.K4])*[.G7];0)","v":{"v":10000,"d":"10.000 €"}}]
[{"$nulls":3},"Erschließungskosten",{"$nulls":6},{"v":0,"d":"0 €"}]
[{"$nulls":3},"Renovierung-/Modernisierung",{"$nulls":6},{"v":10000,"d":"10.000 €"}]
[{"$nulls":9},"Summe",{"$f":"of:=SUM([.K3:.K9])","v":{"v":231000,"d":"231.000 €"}}]
[]
[{"$nulls":3},"Eigenkapital (bar)",{"$nulls":6},{"v":100000,"d":"100.000 €"}]
[{"$nulls":8},"Finanzierungsbedarf",null,{"$f":"of:=[.K10]-[.K12]","v":{"v":131000,"d":"131.000 €"}}]
[null,"Berechnung der anfänglichen Zinskosten"]
[{"$nulls":3},"Bank",null,"Laufz. [Jahre]","Darlehn","Zins (nom.)","Fest-schreibung [Jahre]","Zins (eff.)","Mtl. Belastung"]
[null,null,1,"Bank1",null,{"$f":"of:=ROUND(IF([.G16]>0;-NPER(Zins1;[TILHyp1.E5];0;[.G16]);0);0)","v":17},{"v":100000,"d":"100.000 €"},{"v":0.0193,"d":"1,93%"},15,{"$f":"of:=EFFECT([.H16];12)","v":{"v":0.0194716431774804,"d":"1,95 %"}},{"$f":"of:=[.G16]*[.H16]/12","v":{"v":160.833333333333,"d":"161 €"}}]
[null,null,2,"Bank2 (KfW?)",null,{"$f":"of:=ROUND(IF([.G17]>0;-NPER(Zins2;[TILHyp2.E5];0;[.G17]);0);0)","v":32},{"v":31000,"d":"31.000 €"},{"v":0.027,"d":"2,70%"},10,{"$f":"of:=EFFECT([.H17];12)","v":{"v":0.0273366436696005,"d":"2,73 %"}},{"$f":"of:=[.G17]*[.H17]/12","v":{"v":69.75,"d":"70 €"}}]
[null,null,3,"Bank3",null,{"$f":"of:=ROUND(IF([.G18]>0;-NPER(ZinsBank1;[TIL_B1.E5];0;[.G18];0));0)","v":0},{"v":0,"d":"0 €"},{"v":0.000001,"d":"0,00%"},null,{"$f":"of:=EFFECT([.H18];12)","v":{"v":0.00000100000045843984,"d":"0,00 %"}},{"$f":"of:=[.G18]*[.H18]/12","v":{"v":0,"d":"0 €"}}]
[null,null,4,"Bank4",null,{"$f":"of:=ROUND(IF([.G19]>0;-NPER(ZinsBank2;[TIL_B2.E5];0;[.G19]);0);0)","v":0},{"v":0,"d":"0 €"},{"v":0.000001,"d":"0,00%"},null,{"$f":"of:=EFFECT([.H19];12)","v":{"v":0.00000100000045843984,"d":"0,00 %"}},{"$f":"of:=[.G19]*[.H19]/12","v":{"v":0,"d":"0 €"}}]
[{"$nulls":6},{"$f":"of:=[.G16]+[.G17]","v":{"v":131000,"d":"131.000 €"}},{"$f":"of:=IF([.G20]<>[.K13];\"X\";\"\")","v":""},"Summe Zinsen",null,{"$f":"of:=SUM([.K16:.K19])","v":230.583333333333}]
[null,"Berechnung der anfänglichen Tilgungsaufwendungen",{"$nulls":5},{"$f":"of:=IF([.H20]=\"X\";\"ACHTUNG: Summe der Darlehn stimmt nicht mit dem Finanzierungsbedarf überein!\";\"\")","v":null}]
[{"$nulls":5},"ca. Laufz.",null,"Tilgung"]
[null,null,1,{"$f":"of:=[.$D$16]","v":"Bank1"},null,{"$f":"of:=[.F16]","v":17},null,{"v":0.05,"d":"5,00%"},null,null,{"$f":"of:=[.G16]*[.H23]/12","v":416.666666666667}]
[null,null,2,{"$f":"of:=[.$D$17]","v":"Bank2 (KfW?)"},null,{"$f":"of:=[.F17]","v":32},null,{"v":0.02,"d":"2,00%"},null,null,{"$f":"of:=[.G17]*[.H24]/12","v":{"v":51.6666666666667,"d":"52 €"}}]
[null,null,3,{"$f":"of:=[.$D$18]","v":"Bank3"},null,{"$f":"of:=[.F18]","v":0},null,{"v":0,"d":"0,00%"},null,null,{"$f":"of:=[.G18]*[.H25]/12","v":{"v":0,"d":"0 €"}}]
[null,null,4,{"$f":"of:=[.$D$19]","v":"Bank4"},null,{"$f":"of:=[.F19]","v":0},null,{"v":0,"d":"0,00%"},null,null,{"$f":"of:=[.G19]*[.H26]/12","v":{"v":0,"d":"0 €"}}]
[{"$nulls":8},"Summe Tilgung",null,{"$f":"of:=SUM([.K23:.K26])","v":{"v":468.333333333334,"d":"468 €"}}]
[{"$nulls":8},"Summe Belastung mtl.",null,{"$f":"of:=[.K20]+[.K27]","v":{"v":698.916666666667,"d":"699 €"}}]
[null,"Steuerl. Entlastung"]
[]
[{"$nulls":3},"Eigenheimzul.j/n",null,"n",{"$f":"of:=IF([.F31]=\"J\";IF([.H3]=\"N\";2556.46+([.F32]*766.94);(1278.23+([.F32]*766.94)));0)","v":{"v":0,"d":"0,00 €"}},{"$f":"of:=[.G31]*8","v":0},null,null,{"$f":"of:=[.G31]/12","v":{"v":0,"d":"0 €"}}]
[{"$nulls":3},"Anzahl Kinder",null,0]
[{"$nulls":8},"Eff. Belastung",null,{"$f":"of:=[.K28]-[.K31]","v":{"v":698.916666666667,"d":"699 €"}}]

{"sheet":"TILHyp1","index":1,"n_rows":40,"n_cols":6,"rows_kept":40}
[{"$f":"of:=[$Finanzierung.$D$16]","v":"Bank1"},{"$f":"of:=Hypo1","v":{"v":100000,"d":"100.000 €"}},null,"Zins",{"$f":"of:=Zins1","v":{"v":0.0193,"d":"1,93 %"}}]
[]
["Jahr","Zinsen","Zinsen/a","Tilgung/a","Annuität/a","Restschuld"]
[null,{"$f":"of:=[.E1]","v":{"v":0.0193,"d":"1,93%"}},{"$nulls":3},{"$f":"of:=Hypo1","v":{"v":100000,"d":"100.000 €"}}]
["1.",{"$f":"of:=[.B4]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F4]*[.B4]","v":{"v":1930,"d":"1.930 €"}},{"$f":"of:=TIL1*12","v":5000},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F4]-[.D5]","v":{"v":95000,"d":"95.000 €"}}]
["2.",{"$f":"of:=[.B5]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F5]*[.B5]","v":{"v":1833.5,"d":"1.834 €"}},{"$f":"of:=[.E6]-[.C6]","v":{"v":5096.5,"d":"5.097 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F5]-[.D5]","v":{"v":90000,"d":"90.000 €"}}]
["3.",{"$f":"of:=[.B6]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F6]*[.B6]","v":{"v":1737,"d":"1.737 €"}},{"$f":"of:=[.E7]-[.C7]","v":{"v":5193,"d":"5.193 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F6]-[.D6]","v":{"v":84903.5,"d":"84.904 €"}}]
["4.",{"$f":"of:=[.B7]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F7]*[.B7]","v":{"v":1638.63755,"d":"1.639 €"}},{"$f":"of:=[.E8]-[.C8]","v":{"v":5291.36245,"d":"5.291 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F7]-[.D7]","v":{"v":79710.5,"d":"79.711 €"}}]
["5.",{"$f":"of:=[.B8]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F8]*[.B8]","v":{"v":1538.41265,"d":"1.538 €"}},{"$f":"of:=[.E9]-[.C9]","v":{"v":5391.58735,"d":"5.392 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F8]-[.D8]","v":{"v":74419.13755,"d":"74.419 €"}}]
["6.",{"$f":"of:=[.B9]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F9]*[.B9]","v":{"v":1436.289354715,"d":"1.436 €"}},{"$f":"of:=[.E10]-[.C10]","v":{"v":5493.710645285,"d":"5.494 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F9]-[.D9]","v":{"v":69027.5502,"d":"69.028 €"}}]
["7.",{"$f":"of:=[.B10]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F10]*[.B10]","v":{"v":1332.23171886,"d":"1.332 €"}},{"$f":"of:=[.E11]-[.C11]","v":{"v":5597.76828114,"d":"5.598 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F10]-[.D10]","v":{"v":63533.839554715,"d":"63.534 €"}}]
["8.",{"$f":"of:=[.B11]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F11]*[.B11]","v":{"v":1226.203103406,"d":"1.226 €"}},{"$f":"of:=[.E12]-[.C12]","v":{"v":5703.796896594,"d":"5.704 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=[.F11]-[.D11]","v":{"v":57936.071273575,"d":"57.936 €"}}]
["9.",{"$f":"of:=[.B12]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F12]*[.B12]","v":{"v":1118.16617558,"d":"1.118 €"}},{"$f":"of:=IF([.F13]=0;0;[.E13]-[.C13])","v":{"v":5811.83382442,"d":"5.812 €"}},{"$f":"of:=IF([.F13]<=0;0;[.E12])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F12]-[.D12]>0;[.F12]-[.D12];0)","v":{"v":52232.274376981,"d":"52.232 €"}}]
["10.",{"$f":"of:=[.B13]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F13]*[.B13]","v":{"v":1008.08289547573,"d":"1.008 €"}},{"$f":"of:=IF([.F14]=0;0;[.E14]-[.C14])","v":{"v":5921.91710452427,"d":"5.922 €"}},{"$f":"of:=IF([.F14]<=0;0;[.E13])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F13]-[.D13]>0;[.F13]-[.D13];0)","v":{"v":46420.440552561,"d":"46.420 €"}}]
["11.",{"$f":"of:=[.B14]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F14]*[.B14]","v":{"v":895.914502664427,"d":"896 €"}},{"$f":"of:=IF([.F15]=0;0;[.E15]-[.C15])","v":{"v":6034.08549733557,"d":"6.034 €"}},{"$f":"of:=IF([.F15]<=0;0;[.E14])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F14]-[.D14]>0;[.F14]-[.D14];0)","v":{"v":40498.5234480367,"d":"40.499 €"}}]
["12.",{"$f":"of:=[.B15]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F15]*[.B15]","v":{"v":781.621502547109,"d":"782 €"}},{"$f":"of:=IF([.F16]=0;0;[.E16]-[.C16])","v":{"v":6148.37849745289,"d":"6.148 €"}},{"$f":"of:=IF([.F16]<=0;0;[.E15])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F15]-[.D15]>0;[.F15]-[.D15];0)","v":{"v":34464.4379507011,"d":"34.464 €"}}]
["13.",{"$f":"of:=[.B16]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F16]*[.B16]","v":{"v":665.163652448532,"d":"665 €"}},{"$f":"of:=IF([.F17]=0;0;[.E17]-[.C17])","v":{"v":6264.83634755147,"d":"6.265 €"}},{"$f":"of:=IF([.F17]<=0;0;[.E16])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F16]-[.D16]>0;[.F16]-[.D16];0)","v":{"v":28316.0594532483,"d":"28.316 €"}}]
["14.",{"$f":"of:=[.B17]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F17]*[.B17]","v":{"v":546.499947447691,"d":"546 €"}},{"$f":"of:=IF([.F18]=0;0;[.E18]-[.C18])","v":{"v":6383.50005255231,"d":"6.384 €"}},{"$f":"of:=IF([.F18]<=0;0;[.E17])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F17]-[.D17]>0;[.F17]-[.D17];0)","v":{"v":22051.2231056968,"d":"22.051 €"}}]
["15.",{"$f":"of:=[.B18]","v":{"v":0.0193,"d":"1,93%"}},{"$f":"of:=[.F18]*[.B18]","v":{"v":425.588605939948,"d":"426 €"}},{"$f":"of:=IF([.F19]=0;0;[.E19]-[.C19])","v":{"v":6504.41139406005,"d":"6.504 €"}},{"$f":"of:=IF([.F19]<=0;0;[.E18])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F18]-[.D18]>0;[.F18]-[.D18];0)","v":{"v":15667.7230531445,"d":"15.668 €"}}]
["16.",{"v":0.06,"d":"6,00%"},{"$f":"of:=[.F19]*[.B19]","v":{"v":302.387054925689,"d":"302 €"}},{"$f":"of:=IF([.F20]=0;0;[.E20]-[.C20])","v":{"v":6627.61294507431,"d":"6.628 €"}},{"$f":"of:=IF([.F20]<=0;0;[.E19])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F19]-[.D19]>0;[.F19]-[.D19];0)","v":{"v":9163.31165908443,"d":"9.163 €"}}]
["17.",{"$f":"of:=[.B20]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F20]*[.B20]","v":{"v":549.798699545066,"d":"550 €"}},{"$f":"of:=IF([.F21]=0;0;[.E21]-[.C21])","v":{"v":6380.20130045493,"d":"6.380 €"}},{"$f":"of:=IF([.F21]<=0;0;[.E20])","v":{"v":6930,"d":"6.930 €"}},{"$f":"of:=IF([.F20]-[.D20]>0;[.F20]-[.D20];0)","v":{"v":2535.69871401012,"d":"2.536 €"}}]
["18.",{"$f":"of:=[.B21]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F21]*[.B21]","v":{"v":152.141922840607,"d":"152 €"}},{"$f":"of:=IF([.F22]=0;0;[.E22]-[.C22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]<=0;0;[.E21])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]-[.D21]>0;[.F21]-[.D21];0)","v":{"v":0,"d":"0 €"}}]
["19.",{"$f":"of:=[.B22]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F22]*[.B22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]=0;0;[.E23]-[.C23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]<=0;0;[.E22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]-[.D22]>0;[.F22]-[.D22];0)","v":{"v":0,"d":"0 €"}}]
["20.",{"$f":"of:=[.B23]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F23]*[.B23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]=0;0;[.E24]-[.C24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]<=0;0;[.E23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]-[.D23]>0;[.F23]-[.D23];0)","v":{"v":0,"d":"0 €"}}]
["21.",{"$f":"of:=[.B24]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F24]*[.B24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]=0;0;[.E25]-[.C25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]<=0;0;[.E24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]-[.D24]>0;[.F24]-[.D24];0)","v":{"v":0,"d":"0 €"}}]
["22.",{"$f":"of:=[.B25]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F25]*[.B25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]=0;0;[.E26]-[.C26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]<=0;0;[.E25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]-[.D25]>0;[.F25]-[.D25];0)","v":{"v":0,"d":"0 €"}}]
["23.",{"$f":"of:=[.B26]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F26]*[.B26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]=0;0;[.E27]-[.C27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]<=0;0;[.E26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]-[.D26]>0;[.F26]-[.D26];0)","v":{"v":0,"d":"0 €"}}]
["24.",{"$f":"of:=[.B27]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F27]*[.B27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]=0;0;[.E28]-[.C28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]<=0;0;[.E27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]-[.D27]>0;[.F27]-[.D27];0)","v":{"v":0,"d":"0 €"}}]
["25.",{"$f":"of:=[.B28]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F28]*[.B28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]=0;0;[.E29]-[.C29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]<=0;0;[.E28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]-[.D28]>0;[.F28]-[.D28];0)","v":{"v":0,"d":"0 €"}}]
["26.",{"$f":"of:=[.B29]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F29]*[.B29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]=0;0;[.E30]-[.C30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]<=0;0;[.E29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]-[.D29]>0;[.F29]-[.D29];0)","v":{"v":0,"d":"0 €"}}]
["27.",{"$f":"of:=[.B30]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F30]*[.B30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]=0;0;[.E31]-[.C31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]<=0;0;[.E30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]-[.D30]>0;[.F30]-[.D30];0)","v":{"v":0,"d":"0 €"}}]
["28.",{"$f":"of:=[.B31]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F31]*[.B31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]=0;0;[.E32]-[.C32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]<=0;0;[.E31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]-[.D31]>0;[.F31]-[.D31];0)","v":{"v":0,"d":"0 €"}}]
["29.",{"$f":"of:=[.B32]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F32]*[.B32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]=0;0;[.E33]-[.C33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]<=0;0;[.E32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]-[.D32]>0;[.F32]-[.D32];0)","v":{"v":0,"d":"0 €"}}]
["30.",{"$f":"of:=[.B33]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F33]*[.B33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]=0;0;[.E34]-[.C34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]<=0;0;[.E33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]-[.D33]>0;[.F33]-[.D33];0)","v":{"v":0,"d":"0 €"}}]
["31.",{"$f":"of:=[.B34]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F34]*[.B34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]=0;0;[.E35]-[.C35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]<=0;0;[.E34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]-[.D34]>0;[.F34]-[.D34];0)","v":{"v":0,"d":"0 €"}}]
["32.",{"$f":"of:=[.B35]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F35]*[.B35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]=0;0;[.E36]-[.C36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]<=0;0;[.E35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]-[.D35]>0;[.F35]-[.D35];0)","v":{"v":0,"d":"0 €"}}]
["33.",{"$f":"of:=[.B36]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F36]*[.B36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]=0;0;[.E37]-[.C37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]<=0;0;[.E36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]-[.D36]>0;[.F36]-[.D36];0)","v":{"v":0,"d":"0 €"}}]
["34.",{"$f":"of:=[.B37]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F37]*[.B37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]=0;0;[.E38]-[.C38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]<=0;0;[.E37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]-[.D37]>0;[.F37]-[.D37];0)","v":{"v":0,"d":"0 €"}}]
["35.",{"$f":"of:=[.B38]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F38]*[.B38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]=0;0;[.E39]-[.C39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]<=0;0;[.E38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]-[.D38]>0;[.F38]-[.D38];0)","v":{"v":0,"d":"0 €"}}]
["36.",{"$f":"of:=[.B39]","v":{"v":0.06,"d":"6,00%"}},{"$f":"of:=[.F39]*[.B39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]=0;0;[.E40]-[.C40])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]<=0;0;[.E39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]-[.D39]>0;[.F39]-[.D39];0)","v":{"v":0,"d":"0 €"}}]

{"sheet":"TILHyp2","index":2,"n_rows":39,"n_cols":8,"rows_kept":39}
[{"$f":"of:=[$Finanzierung.$D$17]","v":"Bank2 (KfW?)"},{"$f":"of:=Hypo2","v":{"v":31000,"d":"31.000 €"}},null,"Zins",{"$f":"of:=Zins2","v":{"v":0.027,"d":"2,70 %"}}]
[]
["Jahr","Zinsen","Zinsen/a","Tilgung/a","Annuität/a","Restschuld"]
[null,{"$f":"of:=[.E1]","v":{"v":0.027,"d":"2,70%"}},{"$nulls":3},{"$f":"of:=Hypo2","v":{"v":31000,"d":"31.000 €"}}]
["1.",{"$f":"of:=[.B4]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F4]*[.B4]","v":{"v":837,"d":"837 €"}},{"$f":"of:=TIL2*12","v":620},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=Hypo2","v":{"v":31000,"d":"31.000 €"}}]
["2.",{"$f":"of:=[.B5]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F5]*[.B5]","v":{"v":837,"d":"837 €"}},{"$f":"of:=[.E6]-[.C6]","v":{"v":620,"d":"620 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F5]-[.D5]","v":{"v":30380,"d":"30.380 €"}}]
["3.",{"$f":"of:=[.B6]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F6]*[.B6]","v":{"v":820.26,"d":"820 €"}},{"$f":"of:=[.E7]-[.C7]","v":{"v":636.74,"d":"637 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F6]-[.D6]","v":{"v":29760,"d":"29.760 €"}}]
["4.",{"$f":"of:=[.B7]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F7]*[.B7]","v":{"v":803.52,"d":"804 €"}},{"$f":"of:=[.E8]-[.C8]","v":{"v":653.48,"d":"653 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F7]-[.D7]","v":{"v":29123.26,"d":"29.123 €"}}]
["5.",{"$f":"of:=[.B8]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F8]*[.B8]","v":{"v":786.32802,"d":"786 €"}},{"$f":"of:=[.E9]-[.C9]","v":{"v":670.67198,"d":"671 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F8]-[.D8]","v":{"v":28469.78,"d":"28.470 €"}}]
["6.",{"$f":"of:=[.B9]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F9]*[.B9]","v":{"v":768.68406,"d":"769 €"}},{"$f":"of:=[.E10]-[.C10]","v":{"v":688.31594,"d":"688 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F9]-[.D9]","v":{"v":27799.10802,"d":"27.799 €"}}]
["7.",{"$f":"of:=[.B10]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F10]*[.B10]","v":{"v":750.57591654,"d":"751 €"}},{"$f":"of:=[.E11]-[.C11]","v":{"v":706.42408346,"d":"706 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F10]-[.D10]","v":{"v":27110.79208,"d":"27.111 €"}}]
["8.",{"$f":"of:=[.B11]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F11]*[.B11]","v":{"v":731.99138616,"d":"732 €"}},{"$f":"of:=[.E12]-[.C12]","v":{"v":725.00861384,"d":"725 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F11]-[.D11]","v":{"v":26404.36799654,"d":"26.404 €"}}]
["9.",{"$f":"of:=[.B12]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F12]*[.B12]","v":{"v":712.91793590658,"d":"713 €"}},{"$f":"of:=IF([.F13]=0;0;[.E13]-[.C13])","v":{"v":744.08206409342,"d":"744 €"}},{"$f":"of:=IF([.F13]<=0;0;[.E12])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F12]-[.D12]>0;[.F12]-[.D12];0)","v":{"v":25679.3593827,"d":"25.679 €"}}]
["10.",{"$f":"of:=[.B13]","v":{"v":0.027,"d":"2,70%"}},{"$f":"of:=[.F13]*[.B13]","v":{"v":693.3427033329,"d":"693 €"}},{"$f":"of:=IF([.F14]=0;0;[.E14]-[.C14])","v":{"v":763.6572966671,"d":"764 €"}},{"$f":"of:=IF([.F14]<=0;0;[.E13])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F13]-[.D13]>0;[.F13]-[.D13];0)","v":{"v":24935.2773186066,"d":"24.935 €"}}]
["11.",{"v":0.03,"d":"3,00%"},{"$f":"of:=[.F14]*[.B14]","v":{"v":673.252487602378,"d":"673 €"}},{"$f":"of:=IF([.F15]=0;0;[.E15]-[.C15])","v":{"v":783.747512397622,"d":"784 €"}},{"$f":"of:=[.E14]","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=[.F14]-[.D14]","v":{"v":24171.6200219395,"d":"24.172 €"}},null,"ACHTUNG: in Zelle B15 ist ein neuer Zinssatz nach Ablauf "]
["12.",{"$f":"of:=[.B15]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F15]*[.B15]","v":{"v":725.148600658184,"d":"725 €"}},{"$f":"of:=IF([.F16]=0;0;[.E16]-[.C16])","v":{"v":731.851399341816,"d":"732 €"}},{"$f":"of:=IF([.F16]<=0;0;[.E15])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F15]-[.D15]>0;[.F15]-[.D15];0)","v":{"v":23387.8725095419,"d":"23.388 €"}},null,"der Zinsbindung eingegeben (Mittelwert der letzten Jahre)"]
["13.",{"$f":"of:=[.B16]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F16]*[.B16]","v":{"v":701.636175286256,"d":"702 €"}},{"$f":"of:=IF([.F17]=0;0;[.E17]-[.C17])","v":{"v":755.363824713744,"d":"755 €"}},{"$f":"of:=IF([.F17]<=0;0;[.E16])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F16]-[.D16]>0;[.F16]-[.D16];0)","v":{"v":22656.0211102,"d":"22.656 €"}},null,"Ggf. Muß die Annuität (hier E15) erhöht werden, damit keine"]
["14.",{"$f":"of:=[.B17]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F17]*[.B17]","v":{"v":679.680633306001,"d":"680 €"}},{"$f":"of:=IF([.F18]=0;0;[.E18]-[.C18])","v":{"v":777.319366693999,"d":"777 €"}},{"$f":"of:=IF([.F18]<=0;0;[.E17])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F17]-[.D17]>0;[.F17]-[.D17];0)","v":{"v":21900.6572854863,"d":"21.901 €"}},null,"negativen Werte entstehen."]
["15.",{"$f":"of:=[.B18]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F18]*[.B18]","v":{"v":657.019718564589,"d":"657 €"}},{"$f":"of:=IF([.F19]=0;0;[.E19]-[.C19])","v":{"v":799.980281435411,"d":"800 €"}},{"$f":"of:=IF([.F19]<=0;0;[.E18])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F18]-[.D18]>0;[.F18]-[.D18];0)","v":{"v":21123.3379187923,"d":"21.123 €"}}]
["16.",{"$f":"of:=[.B19]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F19]*[.B19]","v":{"v":633.700137563769,"d":"634 €"}},{"$f":"of:=IF([.F20]=0;0;[.E20]-[.C20])","v":{"v":823.299862436231,"d":"823 €"}},{"$f":"of:=IF([.F20]<=0;0;[.E19])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F19]-[.D19]>0;[.F19]-[.D19];0)","v":{"v":20323.3576373569,"d":"20.323 €"}}]
["17.",{"$f":"of:=[.B20]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F20]*[.B20]","v":{"v":609.700729120706,"d":"610 €"}},{"$f":"of:=IF([.F21]=0;0;[.E21]-[.C21])","v":{"v":847.299270879294,"d":"847 €"}},{"$f":"of:=IF([.F21]<=0;0;[.E20])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F20]-[.D20]>0;[.F20]-[.D20];0)","v":{"v":19500.0577749207,"d":"19.500 €"}}]
["18.",{"$f":"of:=[.B21]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F21]*[.B21]","v":{"v":585.00173324762,"d":"585 €"}},{"$f":"of:=IF([.F22]=0;0;[.E22]-[.C22])","v":{"v":871.998266752381,"d":"872 €"}},{"$f":"of:=IF([.F22]<=0;0;[.E21])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F21]-[.D21]>0;[.F21]-[.D21];0)","v":{"v":18652.7585040414,"d":"18.653 €"}}]
["19.",{"$f":"of:=[.B22]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F22]*[.B22]","v":{"v":559.582755121241,"d":"560 €"}},{"$f":"of:=IF([.F23]=0;0;[.E23]-[.C23])","v":{"v":897.417244878759,"d":"897 €"}},{"$f":"of:=IF([.F23]<=0;0;[.E22])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F22]-[.D22]>0;[.F22]-[.D22];0)","v":{"v":17780.760237289,"d":"17.781 €"}}]
["20.",{"$f":"of:=[.B23]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F23]*[.B23]","v":{"v":533.422807118669,"d":"533 €"}},{"$f":"of:=IF([.F24]=0;0;[.E24]-[.C24])","v":{"v":923.577192881331,"d":"924 €"}},{"$f":"of:=IF([.F24]<=0;0;[.E23])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F23]-[.D23]>0;[.F23]-[.D23];0)","v":{"v":16883.3429924102,"d":"16.883 €"}}]
["21.",{"$f":"of:=[.B24]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F24]*[.B24]","v":{"v":506.500289772307,"d":"507 €"}},{"$f":"of:=IF([.F25]=0;0;[.E25]-[.C25])","v":{"v":950.499710227693,"d":"950 €"}},{"$f":"of:=IF([.F25]<=0;0;[.E24])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F24]-[.D24]>0;[.F24]-[.D24];0)","v":{"v":15959.7657995289,"d":"15.960 €"}}]
["22.",{"$f":"of:=[.B25]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F25]*[.B25]","v":{"v":478.792973985867,"d":"479 €"}},{"$f":"of:=IF([.F26]=0;0;[.E26]-[.C26])","v":{"v":978.207026014133,"d":"978 €"}},{"$f":"of:=IF([.F26]<=0;0;[.E25])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F25]-[.D25]>0;[.F25]-[.D25];0)","v":{"v":15009.2660893012,"d":"15.009 €"}}]
["23.",{"$f":"of:=[.B26]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F26]*[.B26]","v":{"v":450.277982679036,"d":"450 €"}},{"$f":"of:=IF([.F27]=0;0;[.E27]-[.C27])","v":{"v":1006.72201732096,"d":"1.007 €"}},{"$f":"of:=IF([.F27]<=0;0;[.E26])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F26]-[.D26]>0;[.F26]-[.D26];0)","v":{"v":14031.0590632871,"d":"14.031 €"}}]
["24.",{"$f":"of:=[.B27]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F27]*[.B27]","v":{"v":420.931771898612,"d":"421 €"}},{"$f":"of:=IF([.F28]=0;0;[.E28]-[.C28])","v":{"v":1036.06822810139,"d":"1.036 €"}},{"$f":"of:=IF([.F28]<=0;0;[.E27])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F27]-[.D27]>0;[.F27]-[.D27];0)","v":{"v":13024.3370459661,"d":"13.024 €"}}]
["25.",{"$f":"of:=[.B28]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F28]*[.B28]","v":{"v":390.730111378983,"d":"391 €"}},{"$f":"of:=IF([.F29]=0;0;[.E29]-[.C29])","v":{"v":1066.26988862102,"d":"1.066 €"}},{"$f":"of:=IF([.F29]<=0;0;[.E28])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F28]-[.D28]>0;[.F28]-[.D28];0)","v":{"v":11988.2688178647,"d":"11.988 €"}}]
["26.",{"$f":"of:=[.B29]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F29]*[.B29]","v":{"v":359.648064535941,"d":"360 €"}},{"$f":"of:=IF([.F30]=0;0;[.E30]-[.C30])","v":{"v":1097.35193546406,"d":"1.097 €"}},{"$f":"of:=IF([.F30]<=0;0;[.E29])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F29]-[.D29]>0;[.F29]-[.D29];0)","v":{"v":10921.9989292437,"d":"10.922 €"}}]
["27.",{"$f":"of:=[.B30]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F30]*[.B30]","v":{"v":327.659967877311,"d":"328 €"}},{"$f":"of:=IF([.F31]=0;0;[.E31]-[.C31])","v":{"v":1129.34003212269,"d":"1.129 €"}},{"$f":"of:=IF([.F31]<=0;0;[.E30])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F30]-[.D30]>0;[.F30]-[.D30];0)","v":{"v":9824.64699377964,"d":"9.825 €"}}]
["28.",{"$f":"of:=[.B31]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F31]*[.B31]","v":{"v":294.739409813389,"d":"295 €"}},{"$f":"of:=IF([.F32]=0;0;[.E32]-[.C32])","v":{"v":1162.26059018661,"d":"1.162 €"}},{"$f":"of:=IF([.F32]<=0;0;[.E31])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F31]-[.D31]>0;[.F31]-[.D31];0)","v":{"v":8695.30696165695,"d":"8.695 €"}}]
["29.",{"$f":"of:=[.B32]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F32]*[.B32]","v":{"v":260.859208849708,"d":"261 €"}},{"$f":"of:=IF([.F33]=0;0;[.E33]-[.C33])","v":{"v":1196.14079115029,"d":"1.196 €"}},{"$f":"of:=IF([.F33]<=0;0;[.E32])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F32]-[.D32]>0;[.F32]-[.D32];0)","v":{"v":7533.04637147034,"d":"7.533 €"}}]
["30.",{"$f":"of:=[.B33]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F33]*[.B33]","v":{"v":225.99139114411,"d":"226 €"}},{"$f":"of:=IF([.F34]=0;0;[.E34]-[.C34])","v":{"v":1231.00860885589,"d":"1.231 €"}},{"$f":"of:=IF([.F34]<=0;0;[.E33])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F33]-[.D33]>0;[.F33]-[.D33];0)","v":{"v":6336.90558032005,"d":"6.337 €"}}]
["31.",{"$f":"of:=[.B34]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F34]*[.B34]","v":{"v":190.107167409601,"d":"190 €"}},{"$f":"of:=IF([.F35]=0;0;[.E35]-[.C35])","v":{"v":1266.8928325904,"d":"1.267 €"}},{"$f":"of:=IF([.F35]<=0;0;[.E34])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F34]-[.D34]>0;[.F34]-[.D34];0)","v":{"v":5105.89697146416,"d":"5.106 €"}}]
["32.",{"$f":"of:=[.B35]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F35]*[.B35]","v":{"v":153.176909143925,"d":"153 €"}},{"$f":"of:=IF([.F36]=0;0;[.E36]-[.C36])","v":{"v":1303.82309085608,"d":"1.304 €"}},{"$f":"of:=IF([.F36]<=0;0;[.E35])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F35]-[.D35]>0;[.F35]-[.D35];0)","v":{"v":3839.00413887376,"d":"3.839 €"}}]
["33.",{"$f":"of:=[.B36]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F36]*[.B36]","v":{"v":115.170124166213,"d":"115 €"}},{"$f":"of:=IF([.F37]=0;0;[.E37]-[.C37])","v":{"v":1341.82987583379,"d":"1.342 €"}},{"$f":"of:=IF([.F37]<=0;0;[.E36])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F36]-[.D36]>0;[.F36]-[.D36];0)","v":{"v":2535.18104801768,"d":"2.535 €"}}]
["34.",{"$f":"of:=[.B37]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F37]*[.B37]","v":{"v":76.0554314405305,"d":"76 €"}},{"$f":"of:=IF([.F38]=0;0;[.E38]-[.C38])","v":{"v":1380.94456855947,"d":"1.381 €"}},{"$f":"of:=IF([.F38]<=0;0;[.E37])","v":{"v":1457,"d":"1.457 €"}},{"$f":"of:=IF([.F37]-[.D37]>0;[.F37]-[.D37];0)","v":{"v":1193.35117218389,"d":"1.193 €"}}]
["35.",{"$f":"of:=[.B38]","v":{"v":0.03,"d":"3,00%"}},{"$f":"of:=[.F38]*[.B38]","v":{"v":35.8005351655168,"d":"36 €"}},{"$f":"of:=IF([.F39]=0;0;[.E39]-[.C39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]<=0;0;[.E38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]-[.D38]>0;[.F38]-[.D38];0)","v":{"v":0,"d":"0 €"}}]

{"sheet":"TIL_B1","index":3,"n_rows":40,"n_cols":6,"rows_kept":40}
[{"$f":"of:=[$Finanzierung.$D$18]","v":"Bank3"},{"$f":"of:=Bank1","v":{"v":0,"d":"0 €"}},null,"Zins",{"$f":"of:=ZinsBank1","v":{"v":0.000001,"d":"0,00 %"}}]
[]
["Jahr","Zinsen","Zinsen/a","Tilgung/a","Annuität/a","Restschuld"]
[null,{"$f":"of:=ZinsBank1","v":{"v":0.000001,"d":"0,00%"}},{"$nulls":3},{"$f":"of:=[.B1]","v":{"v":0,"d":"0 €"}}]
["1.",{"$f":"of:=[.B4]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F4]*[.B4]","v":{"v":0,"d":"0 €"}},{"$f":"of:=TIL3*12","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F4]-[.D5]","v":{"v":0,"d":"0 €"}}]
["2.",{"$f":"of:=[.B5]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F5]*[.B5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E6]-[.C6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F5]-[.D5]","v":{"v":0,"d":"0 €"}}]
["3.",{"$f":"of:=[.B6]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F6]*[.B6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E7]-[.C7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F6]-[.D6]","v":{"v":0,"d":"0 €"}}]
["4.",{"$f":"of:=[.B7]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F7]*[.B7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E8]-[.C8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F7]-[.D7]","v":{"v":0,"d":"0 €"}}]
["5.",{"$f":"of:=[.B8]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F8]*[.B8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E9]-[.C9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F8]-[.D8]","v":{"v":0,"d":"0 €"}}]
["6.",{"$f":"of:=[.B9]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F9]*[.B9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E10]-[.C10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F9]-[.D9]","v":{"v":0,"d":"0 €"}}]
["7.",{"$f":"of:=[.B10]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F10]*[.B10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E11]-[.C11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F10]-[.D10]","v":{"v":0,"d":"0 €"}}]
["8.",{"$f":"of:=[.B11]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F11]*[.B11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E12]-[.C12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F11]-[.D11]","v":{"v":0,"d":"0 €"}}]
["9.",{"$f":"of:=[.B12]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F12]*[.B12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]=0;0;[.E13]-[.C13])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]<=0;0;[.E12])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F12]-[.D12]>0;[.F12]-[.D12];0)","v":{"v":0,"d":"0 €"}}]
["10.",{"$f":"of:=[.B13]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F13]*[.B13]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]=0;0;[.E14]-[.C14])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]<=0;0;[.E13])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]-[.D13]>0;[.F13]-[.D13];0)","v":{"v":0,"d":"0 €"}}]
["11.",{"$f":"of:=[.B14]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F14]*[.B14]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]=0;0;[.E15]-[.C15])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]<=0;0;[.E14])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]-[.D14]>0;[.F14]-[.D14];0)","v":{"v":0,"d":"0 €"}}]
["12.",{"$f":"of:=[.B15]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F15]*[.B15]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]=0;0;[.E16]-[.C16])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]<=0;0;[.E15])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]-[.D15]>0;[.F15]-[.D15];0)","v":{"v":0,"d":"0 €"}}]
["13.",{"$f":"of:=[.B16]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F16]*[.B16]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]=0;0;[.E17]-[.C17])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]<=0;0;[.E16])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]-[.D16]>0;[.F16]-[.D16];0)","v":{"v":0,"d":"0 €"}}]
["14.",{"$f":"of:=[.B17]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F17]*[.B17]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]=0;0;[.E18]-[.C18])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]<=0;0;[.E17])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]-[.D17]>0;[.F17]-[.D17];0)","v":{"v":0,"d":"0 €"}}]
["15.",{"$f":"of:=[.B18]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F18]*[.B18]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]=0;0;[.E19]-[.C19])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]<=0;0;[.E18])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]-[.D18]>0;[.F18]-[.D18];0)","v":{"v":0,"d":"0 €"}}]
["16.",{"$f":"of:=[.B19]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F19]*[.B19]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]=0;0;[.E20]-[.C20])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]<=0;0;[.E19])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]-[.D19]>0;[.F19]-[.D19];0)","v":{"v":0,"d":"0 €"}}]
["17.",{"$f":"of:=[.B20]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F20]*[.B20]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]=0;0;[.E21]-[.C21])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]<=0;0;[.E20])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]-[.D20]>0;[.F20]-[.D20];0)","v":{"v":0,"d":"0 €"}}]
["18.",{"$f":"of:=[.B21]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F21]*[.B21]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]=0;0;[.E22]-[.C22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]<=0;0;[.E21])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]-[.D21]>0;[.F21]-[.D21];0)","v":{"v":0,"d":"0 €"}}]
["19.",{"$f":"of:=[.B22]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F22]*[.B22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]=0;0;[.E23]-[.C23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]<=0;0;[.E22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]-[.D22]>0;[.F22]-[.D22];0)","v":{"v":0,"d":"0 €"}}]
["20.",{"$f":"of:=[.B23]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F23]*[.B23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]=0;0;[.E24]-[.C24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]<=0;0;[.E23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]-[.D23]>0;[.F23]-[.D23];0)","v":{"v":0,"d":"0 €"}}]
["21.",{"$f":"of:=[.B24]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F24]*[.B24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]=0;0;[.E25]-[.C25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]<=0;0;[.E24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]-[.D24]>0;[.F24]-[.D24];0)","v":{"v":0,"d":"0 €"}}]
["22.",{"$f":"of:=[.B25]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F25]*[.B25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]=0;0;[.E26]-[.C26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]<=0;0;[.E25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]-[.D25]>0;[.F25]-[.D25];0)","v":{"v":0,"d":"0 €"}}]
["23.",{"$f":"of:=[.B26]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F26]*[.B26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]=0;0;[.E27]-[.C27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]<=0;0;[.E26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]-[.D26]>0;[.F26]-[.D26];0)","v":{"v":0,"d":"0 €"}}]
["24.",{"$f":"of:=[.B27]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F27]*[.B27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]=0;0;[.E28]-[.C28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]<=0;0;[.E27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]-[.D27]>0;[.F27]-[.D27];0)","v":{"v":0,"d":"0 €"}}]
["25.",{"$f":"of:=[.B28]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F28]*[.B28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]=0;0;[.E29]-[.C29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]<=0;0;[.E28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]-[.D28]>0;[.F28]-[.D28];0)","v":{"v":0,"d":"0 €"}}]
["26.",{"$f":"of:=[.B29]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F29]*[.B29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]=0;0;[.E30]-[.C30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]<=0;0;[.E29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]-[.D29]>0;[.F29]-[.D29];0)","v":{"v":0,"d":"0 €"}}]
["27.",{"$f":"of:=[.B30]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F30]*[.B30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]=0;0;[.E31]-[.C31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]<=0;0;[.E30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]-[.D30]>0;[.F30]-[.D30];0)","v":{"v":0,"d":"0 €"}}]
["28.",{"$f":"of:=[.B31]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F31]*[.B31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]=0;0;[.E32]-[.C32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]<=0;0;[.E31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]-[.D31]>0;[.F31]-[.D31];0)","v":{"v":0,"d":"0 €"}}]
["29.",{"$f":"of:=[.B32]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F32]*[.B32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]=0;0;[.E33]-[.C33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]<=0;0;[.E32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]-[.D32]>0;[.F32]-[.D32];0)","v":{"v":0,"d":"0 €"}}]
["30.",{"$f":"of:=[.B33]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F33]*[.B33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]=0;0;[.E34]-[.C34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]<=0;0;[.E33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]-[.D33]>0;[.F33]-[.D33];0)","v":{"v":0,"d":"0 €"}}]
["31.",{"$f":"of:=[.B34]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F34]*[.B34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]=0;0;[.E35]-[.C35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]<=0;0;[.E34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]-[.D34]>0;[.F34]-[.D34];0)","v":{"v":0,"d":"0 €"}}]
["32.",{"$f":"of:=[.B35]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F35]*[.B35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]=0;0;[.E36]-[.C36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]<=0;0;[.E35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]-[.D35]>0;[.F35]-[.D35];0)","v":{"v":0,"d":"0 €"}}]
["33.",{"$f":"of:=[.B36]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F36]*[.B36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]=0;0;[.E37]-[.C37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]<=0;0;[.E36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]-[.D36]>0;[.F36]-[.D36];0)","v":{"v":0,"d":"0 €"}}]
["34.",{"$f":"of:=[.B37]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F37]*[.B37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]=0;0;[.E38]-[.C38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]<=0;0;[.E37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]-[.D37]>0;[.F37]-[.D37];0)","v":{"v":0,"d":"0 €"}}]
["35.",{"$f":"of:=[.B38]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F38]*[.B38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]=0;0;[.E39]-[.C39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]<=0;0;[.E38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]-[.D38]>0;[.F38]-[.D38];0)","v":{"v":0,"d":"0 €"}}]
["36.",{"$f":"of:=[.B39]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F39]*[.B39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]=0;0;[.E40]-[.C40])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]<=0;0;[.E39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]-[.D39]>0;[.F39]-[.D39];0)","v":{"v":0,"d":"0 €"}}]

{"sheet":"TIL_B2","index":4,"n_rows":40,"n_cols":6,"rows_kept":40}
[{"$f":"of:=[$Finanzierung.$D$19]","v":"Bank4"},{"$f":"of:=Bank2","v":{"v":0,"d":"0 €"}},null,"Zins",{"$f":"of:=ZinsBank2","v":{"v":0.000001,"d":"0,00 %"}}]
[]
["Datum","Zinsen","Zinsen/a","Tilgung/a","Annuität/a","Restschuld"]
[null,{"$f":"of:=ZinsBank2","v":{"v":0.000001,"d":"0,00%"}},{"$nulls":3},{"$f":"of:=Bank2","v":{"v":0,"d":"0 €"}}]
["1.",{"$f":"of:=[.B4]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F4]*[.B4]","v":{"v":0,"d":"0 €"}},{"$f":"of:=TIL4*12","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F4]-[.D5]","v":{"v":0,"d":"0 €"}}]
["2.",{"$f":"of:=[.B5]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F5]*[.B5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E6]-[.C6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F5]-[.D5]","v":{"v":0,"d":"0 €"}}]
["3.",{"$f":"of:=[.B6]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F6]*[.B6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E7]-[.C7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F6]-[.D6]","v":{"v":0,"d":"0 €"}}]
["4.",{"$f":"of:=[.B7]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F7]*[.B7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E8]-[.C8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F7]-[.D7]","v":{"v":0,"d":"0 €"}}]
["5.",{"$f":"of:=[.B8]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F8]*[.B8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E9]-[.C9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F8]-[.D8]","v":{"v":0,"d":"0 €"}}]
["6.",{"$f":"of:=[.B9]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F9]*[.B9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E10]-[.C10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F9]-[.D9]","v":{"v":0,"d":"0 €"}}]
["7.",{"$f":"of:=[.B10]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F10]*[.B10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E11]-[.C11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F10]-[.D10]","v":{"v":0,"d":"0 €"}}]
["8.",{"$f":"of:=[.B11]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F11]*[.B11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.E12]-[.C12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.$C$5]+[.$D$5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.F11]-[.D11]","v":{"v":0,"d":"0 €"}}]
["9.",{"$f":"of:=[.B12]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F12]*[.B12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]=0;0;[.E13]-[.C13])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]<=0;0;[.E12])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F12]-[.D12]>0;[.F12]-[.D12];0)","v":{"v":0,"d":"0 €"}}]
["10.",{"$f":"of:=[.B13]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F13]*[.B13]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]=0;0;[.E14]-[.C14])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]<=0;0;[.E13])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F13]-[.D13]>0;[.F13]-[.D13];0)","v":{"v":0,"d":"0 €"}}]
["11.",{"$f":"of:=[.B14]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F14]*[.B14]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]=0;0;[.E15]-[.C15])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]<=0;0;[.E14])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F14]-[.D14]>0;[.F14]-[.D14];0)","v":{"v":0,"d":"0 €"}}]
["12.",{"$f":"of:=[.B15]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F15]*[.B15]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]=0;0;[.E16]-[.C16])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]<=0;0;[.E15])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F15]-[.D15]>0;[.F15]-[.D15];0)","v":{"v":0,"d":"0 €"}}]
["13.",{"$f":"of:=[.B16]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F16]*[.B16]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]=0;0;[.E17]-[.C17])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]<=0;0;[.E16])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F16]-[.D16]>0;[.F16]-[.D16];0)","v":{"v":0,"d":"0 €"}}]
["14.",{"$f":"of:=[.B17]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F17]*[.B17]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]=0;0;[.E18]-[.C18])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]<=0;0;[.E17])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F17]-[.D17]>0;[.F17]-[.D17];0)","v":{"v":0,"d":"0 €"}}]
["15.",{"$f":"of:=[.B18]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F18]*[.B18]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]=0;0;[.E19]-[.C19])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]<=0;0;[.E18])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F18]-[.D18]>0;[.F18]-[.D18];0)","v":{"v":0,"d":"0 €"}}]
["16.",{"$f":"of:=[.B19]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F19]*[.B19]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]=0;0;[.E20]-[.C20])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]<=0;0;[.E19])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F19]-[.D19]>0;[.F19]-[.D19];0)","v":{"v":0,"d":"0 €"}}]
["17.",{"$f":"of:=[.B20]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F20]*[.B20]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]=0;0;[.E21]-[.C21])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]<=0;0;[.E20])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F20]-[.D20]>0;[.F20]-[.D20];0)","v":{"v":0,"d":"0 €"}}]
["18.",{"$f":"of:=[.B21]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F21]*[.B21]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]=0;0;[.E22]-[.C22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]<=0;0;[.E21])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F21]-[.D21]>0;[.F21]-[.D21];0)","v":{"v":0,"d":"0 €"}}]
["19.",{"$f":"of:=[.B22]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F22]*[.B22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]=0;0;[.E23]-[.C23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]<=0;0;[.E22])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F22]-[.D22]>0;[.F22]-[.D22];0)","v":{"v":0,"d":"0 €"}}]
["20.",{"$f":"of:=[.B23]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F23]*[.B23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]=0;0;[.E24]-[.C24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]<=0;0;[.E23])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F23]-[.D23]>0;[.F23]-[.D23];0)","v":{"v":0,"d":"0 €"}}]
["21.",{"$f":"of:=[.B24]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F24]*[.B24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]=0;0;[.E25]-[.C25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]<=0;0;[.E24])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F24]-[.D24]>0;[.F24]-[.D24];0)","v":{"v":0,"d":"0 €"}}]
["22.",{"$f":"of:=[.B25]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F25]*[.B25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]=0;0;[.E26]-[.C26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]<=0;0;[.E25])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F25]-[.D25]>0;[.F25]-[.D25];0)","v":{"v":0,"d":"0 €"}}]
["23.",{"$f":"of:=[.B26]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F26]*[.B26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]=0;0;[.E27]-[.C27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]<=0;0;[.E26])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F26]-[.D26]>0;[.F26]-[.D26];0)","v":{"v":0,"d":"0 €"}}]
["24.",{"$f":"of:=[.B27]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F27]*[.B27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]=0;0;[.E28]-[.C28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]<=0;0;[.E27])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F27]-[.D27]>0;[.F27]-[.D27];0)","v":{"v":0,"d":"0 €"}}]
["25.",{"$f":"of:=[.B28]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F28]*[.B28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]=0;0;[.E29]-[.C29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]<=0;0;[.E28])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F28]-[.D28]>0;[.F28]-[.D28];0)","v":{"v":0,"d":"0 €"}}]
["26.",{"$f":"of:=[.B29]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F29]*[.B29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]=0;0;[.E30]-[.C30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]<=0;0;[.E29])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F29]-[.D29]>0;[.F29]-[.D29];0)","v":{"v":0,"d":"0 €"}}]
["27.",{"$f":"of:=[.B30]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F30]*[.B30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]=0;0;[.E31]-[.C31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]<=0;0;[.E30])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F30]-[.D30]>0;[.F30]-[.D30];0)","v":{"v":0,"d":"0 €"}}]
["28.",{"$f":"of:=[.B31]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F31]*[.B31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]=0;0;[.E32]-[.C32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]<=0;0;[.E31])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F31]-[.D31]>0;[.F31]-[.D31];0)","v":{"v":0,"d":"0 €"}}]
["29.",{"$f":"of:=[.B32]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F32]*[.B32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]=0;0;[.E33]-[.C33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]<=0;0;[.E32])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F32]-[.D32]>0;[.F32]-[.D32];0)","v":{"v":0,"d":"0 €"}}]
["30.",{"$f":"of:=[.B33]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F33]*[.B33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]=0;0;[.E34]-[.C34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]<=0;0;[.E33])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F33]-[.D33]>0;[.F33]-[.D33];0)","v":{"v":0,"d":"0 €"}}]
["31.",{"$f":"of:=[.B34]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F34]*[.B34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]=0;0;[.E35]-[.C35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]<=0;0;[.E34])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F34]-[.D34]>0;[.F34]-[.D34];0)","v":{"v":0,"d":"0 €"}}]
["32.",{"$f":"of:=[.B35]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F35]*[.B35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]=0;0;[.E36]-[.C36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]<=0;0;[.E35])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F35]-[.D35]>0;[.F35]-[.D35];0)","v":{"v":0,"d":"0 €"}}]
["33.",{"$f":"of:=[.B36]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F36]*[.B36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]=0;0;[.E37]-[.C37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]<=0;0;[.E36])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F36]-[.D36]>0;[.F36]-[.D36];0)","v":{"v":0,"d":"0 €"}}]
["34.",{"$f":"of:=[.B37]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F37]*[.B37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]=0;0;[.E38]-[.C38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]<=0;0;[.E37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F37]-[.D37]>0;[.F37]-[.D37];0)","v":{"v":0,"d":"0 €"}}]
["35.",{"$f":"of:=[.B38]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F38]*[.B38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]=0;0;[.E39]-[.C39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]<=0;0;[.E38])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F38]-[.D38]>0;[.F38]-[.D38];0)","v":{"v":0,"d":"0 €"}}]
["36.",{"$f":"of:=[.B39]","v":{"v":0.000001,"d":"0,00%"}},{"$f":"of:=[.F39]*[.B39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]=0;0;[.E40]-[.C40])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F40]<=0;0;[.E39])","v":{"v":0,"d":"0 €"}},{"$f":"of:=IF([.F39]-[.D39]>0;[.F39]-[.D39];0)","v":{"v":0,"d":"0 €"}}]

{"sheet":"Verlauf","index":5,"n_rows":37,"n_cols":17,"rows_kept":37}
[null,"Annuität",null,"m. EHZ","Ohne EHZ",null,null,"Zinsen",null,"Eigenheim-",null,null,"Tilgung"]
[null,"Zinsen","Tilgung","Belast./Mon.","Belast/Mon.","Hyp1","Hyp2","Bank1","Bank2","zulage","Hyp1","Hyp2","Bank1","Bank2"]
["1.",{"$f":"of:=SUM([.F3:.I3])","v":{"v":2767,"d":"2.767 €"}},{"$f":"of:=SUM([.K3:.N3])","v":{"v":5620,"d":"5.620 €"}},{"$f":"of:=([.B3]+[.C3])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B3]+[.C3])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C5]","v":{"v":1930,"d":"1.930 €"}},{"$f":"of:=[$TILHyp2.C5]","v":{"v":837,"d":"837 €"}},{"$f":"of:=[$TIL_B1.C5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=([Finanzierung.K31])*-1","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D5]","v":{"v":5000,"d":"5.000 €"}},{"$f":"of:=[$TILHyp2.D5]","v":{"v":620,"d":"620 €"}},{"$f":"of:=[$TIL_B1.D5]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D5]","v":{"v":0,"d":"0 €"}}]
["2.",{"$f":"of:=SUM([.F4:.I4])","v":{"v":2670.5,"d":"2.671 €"}},{"$f":"of:=SUM([.K4:.N4])","v":{"v":5716.5,"d":"5.717 €"}},{"$f":"of:=([.B4]+[.C4])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B4]+[.C4])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C6]","v":{"v":1833.5,"d":"1.834 €"}},{"$f":"of:=[$TILHyp2.C6]","v":{"v":837,"d":"837 €"}},{"$f":"of:=[$TIL_B1.C6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=([Finanzierung.K31])*-1","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D6]","v":{"v":5096.5,"d":"5.097 €"}},{"$f":"of:=[$TILHyp2.D6]","v":{"v":620,"d":"620 €"}},{"$f":"of:=[$TIL_B1.D6]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D6]","v":{"v":0,"d":"0 €"}}]
["3.",{"$f":"of:=SUM([.F5:.I5])","v":{"v":2557.26,"d":"2.557 €"}},{"$f":"of:=SUM([.K5:.N5])","v":{"v":5829.74,"d":"5.830 €"}},{"$f":"of:=([.B5]+[.C5])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B5]+[.C5])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C7]","v":{"v":1737,"d":"1.737 €"}},{"$f":"of:=[$TILHyp2.C7]","v":{"v":820.26,"d":"820 €"}},{"$f":"of:=[$TIL_B1.C7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D7]","v":{"v":5193,"d":"5.193 €"}},{"$f":"of:=[$TILHyp2.D7]","v":{"v":636.74,"d":"637 €"}},{"$f":"of:=[$TIL_B1.D7]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D7]","v":{"v":0,"d":"0 €"}}]
["4.",{"$f":"of:=SUM([.F6:.I6])","v":{"v":2442.15755,"d":"2.442 €"}},{"$f":"of:=SUM([.K6:.N6])","v":{"v":5944.84245,"d":"5.945 €"}},{"$f":"of:=([.B6]+[.C6])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B6]+[.C6])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C8]","v":{"v":1638.63755,"d":"1.639 €"}},{"$f":"of:=[$TILHyp2.C8]","v":{"v":803.52,"d":"804 €"}},{"$f":"of:=[$TIL_B1.C8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D8]","v":{"v":5291.36245,"d":"5.291 €"}},{"$f":"of:=[$TILHyp2.D8]","v":{"v":653.48,"d":"653 €"}},{"$f":"of:=[$TIL_B1.D8]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D8]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$Finanzierung.$K$23]","v":416.666666666667},{"$f":"of:=[$Finanzierung.$H$16]","v":{"v":0.0193,"d":"1,93%"}}]
["5.",{"$f":"of:=SUM([.F7:.I7])","v":{"v":2324.74067,"d":"2.325 €"}},{"$f":"of:=SUM([.K7:.N7])","v":{"v":6062.25933,"d":"6.062 €"}},{"$f":"of:=([.B7]+[.C7])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B7]+[.C7])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C9]","v":{"v":1538.41265,"d":"1.538 €"}},{"$f":"of:=[$TILHyp2.C9]","v":{"v":786.32802,"d":"786 €"}},{"$f":"of:=[$TIL_B1.C9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D9]","v":{"v":5391.58735,"d":"5.392 €"}},{"$f":"of:=[$TILHyp2.D9]","v":{"v":670.67198,"d":"671 €"}},{"$f":"of:=[$TIL_B1.D9]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D9]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$Finanzierung.$K$24]","v":{"v":51.6666666666667,"d":"52 €"}},{"$f":"of:=[$Finanzierung.$H$17]","v":{"v":0.027,"d":"2,70%"}}]
["6.",{"$f":"of:=SUM([.F8:.I8])","v":{"v":2204.973414715,"d":"2.205 €"}},{"$f":"of:=SUM([.K8:.N8])","v":{"v":6182.026585285,"d":"6.182 €"}},{"$f":"of:=([.B8]+[.C8])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B8]+[.C8])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C10]","v":{"v":1436.289354715,"d":"1.436 €"}},{"$f":"of:=[$TILHyp2.C10]","v":{"v":768.68406,"d":"769 €"}},{"$f":"of:=[$TIL_B1.C10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D10]","v":{"v":5493.710645285,"d":"5.494 €"}},{"$f":"of:=[$TILHyp2.D10]","v":{"v":688.31594,"d":"688 €"}},{"$f":"of:=[$TIL_B1.D10]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D10]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$Finanzierung.$K$24]","v":{"v":51.6666666666667,"d":"52 €"}},{"$f":"of:=[$Finanzierung.$H$18]","v":{"v":0.000001,"d":"0,00%"}}]
["7.",{"$f":"of:=SUM([.F9:.I9])","v":{"v":2082.8076354,"d":"2.083 €"}},{"$f":"of:=SUM([.K9:.N9])","v":{"v":6304.1923646,"d":"6.304 €"}},{"$f":"of:=([.B9]+[.C9])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B9]+[.C9])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C11]","v":{"v":1332.23171886,"d":"1.332 €"}},{"$f":"of:=[$TILHyp2.C11]","v":{"v":750.57591654,"d":"751 €"}},{"$f":"of:=[$TIL_B1.C11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D11]","v":{"v":5597.76828114,"d":"5.598 €"}},{"$f":"of:=[$TILHyp2.D11]","v":{"v":706.42408346,"d":"706 €"}},{"$f":"of:=[$TIL_B1.D11]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D11]","v":{"v":0,"d":"0 €"}}]
["8.",{"$f":"of:=SUM([.F10:.I10])","v":{"v":1958.194489566,"d":"1.958 €"}},{"$f":"of:=SUM([.K10:.N10])","v":{"v":6428.805510434,"d":"6.429 €"}},{"$f":"of:=([.B10]+[.C10])/12+[.J3]","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B10]+[.C10])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C12]","v":{"v":1226.203103406,"d":"1.226 €"}},{"$f":"of:=[$TILHyp2.C12]","v":{"v":731.99138616,"d":"732 €"}},{"$f":"of:=[$TIL_B1.C12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[.J3]","v":{"v":-0,"d":"0 €"}},{"$f":"of:=[$TILHyp1.D12]","v":{"v":5703.796896594,"d":"5.704 €"}},{"$f":"of:=[$TILHyp2.D12]","v":{"v":725.00861384,"d":"725 €"}},{"$f":"of:=[$TIL_B1.D12]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D12]","v":{"v":0,"d":"0 €"}}]
["9.",{"$f":"of:=SUM([.F11:.I11])","v":{"v":1831.08411148658,"d":"1.831 €"}},{"$f":"of:=SUM([.K11:.N11])","v":{"v":6555.91588851342,"d":"6.556 €"}},{"$f":"of:=([.B11]+[.C11])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B11]+[.C11])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C13]","v":{"v":1118.16617558,"d":"1.118 €"}},{"$f":"of:=[$TILHyp2.C13]","v":{"v":712.91793590658,"d":"713 €"}},{"$f":"of:=[$TIL_B1.C13]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C13]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D13]","v":{"v":5811.83382442,"d":"5.812 €"}},{"$f":"of:=[$TILHyp2.D13]","v":{"v":744.08206409342,"d":"744 €"}},{"$f":"of:=[$TIL_B1.D13]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D13]","v":{"v":0,"d":"0 €"}}]
["10.",{"$f":"of:=SUM([.F12:.I12])","v":{"v":1701.42559880863,"d":"1.701 €"}},{"$f":"of:=SUM([.K12:.N12])","v":{"v":6685.57440119137,"d":"6.686 €"}},{"$f":"of:=([.B12]+[.C12])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B12]+[.C12])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C14]","v":{"v":1008.08289547573,"d":"1.008 €"}},{"$f":"of:=[$TILHyp2.C14]","v":{"v":693.3427033329,"d":"693 €"}},{"$f":"of:=[$TIL_B1.C14]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C14]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D14]","v":{"v":5921.91710452427,"d":"5.922 €"}},{"$f":"of:=[$TILHyp2.D14]","v":{"v":763.6572966671,"d":"764 €"}},{"$f":"of:=[$TIL_B1.D14]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D14]","v":{"v":0,"d":"0 €"}}]
["11.",{"$f":"of:=SUM([.F13:.I13])","v":{"v":1569.1669902668,"d":"1.569 €"}},{"$f":"of:=SUM([.K13:.N13])","v":{"v":6817.83300973319,"d":"6.818 €"}},{"$f":"of:=([.B13]+[.C13])/12","v":{"v":698.916666666666,"d":"698,92 €"}},{"$f":"of:=([.B13]+[.C13])/12","v":{"v":698.916666666666,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C15]","v":{"v":895.914502664427,"d":"896 €"}},{"$f":"of:=[$TILHyp2.C15]","v":{"v":673.252487602378,"d":"673 €"}},{"$f":"of:=[$TIL_B1.C15]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C15]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D15]","v":{"v":6034.08549733557,"d":"6.034 €"}},{"$f":"of:=[$TILHyp2.D15]","v":{"v":783.747512397622,"d":"784 €"}},{"$f":"of:=[$TIL_B1.D15]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D15]","v":{"v":0,"d":"0 €"}}]
["12.",{"$f":"of:=SUM([.F14:.I14])","v":{"v":1506.77010320529,"d":"1.507 €"}},{"$f":"of:=SUM([.K14:.N14])","v":{"v":6880.22989679471,"d":"6.880 €"}},{"$f":"of:=([.B14]+[.C14])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B14]+[.C14])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C16]","v":{"v":781.621502547109,"d":"782 €"}},{"$f":"of:=[$TILHyp2.C16]","v":{"v":725.148600658184,"d":"725 €"}},{"$f":"of:=[$TIL_B1.C16]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C16]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D16]","v":{"v":6148.37849745289,"d":"6.148 €"}},{"$f":"of:=[$TILHyp2.D16]","v":{"v":731.851399341816,"d":"732 €"}},{"$f":"of:=[$TIL_B1.D16]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D16]","v":{"v":0,"d":"0 €"}}]
["13.",{"$f":"of:=SUM([.F15:.I15])","v":{"v":1366.79982773479,"d":"1.367 €"}},{"$f":"of:=SUM([.K15:.N15])","v":{"v":7020.20017226521,"d":"7.020 €"}},{"$f":"of:=([.B15]+[.C15])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B15]+[.C15])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C17]","v":{"v":665.163652448532,"d":"665 €"}},{"$f":"of:=[$TILHyp2.C17]","v":{"v":701.636175286256,"d":"702 €"}},{"$f":"of:=[$TIL_B1.C17]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C17]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D17]","v":{"v":6264.83634755147,"d":"6.265 €"}},{"$f":"of:=[$TILHyp2.D17]","v":{"v":755.363824713744,"d":"755 €"}},{"$f":"of:=[$TIL_B1.D17]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D17]","v":{"v":0,"d":"0 €"}}]
["14.",{"$f":"of:=SUM([.F16:.I16])","v":{"v":1226.18058075369,"d":"1.226 €"}},{"$f":"of:=SUM([.K16:.N16])","v":{"v":7160.81941924631,"d":"7.161 €"}},{"$f":"of:=([.B16]+[.C16])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B16]+[.C16])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C18]","v":{"v":546.499947447691,"d":"546 €"}},{"$f":"of:=[$TILHyp2.C18]","v":{"v":679.680633306001,"d":"680 €"}},{"$f":"of:=[$TIL_B1.C18]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C18]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D18]","v":{"v":6383.50005255231,"d":"6.384 €"}},{"$f":"of:=[$TILHyp2.D18]","v":{"v":777.319366693999,"d":"777 €"}},{"$f":"of:=[$TIL_B1.D18]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D18]","v":{"v":0,"d":"0 €"}}]
["15.",{"$f":"of:=SUM([.F17:.I17])","v":{"v":1082.60832450454,"d":"1.083 €"}},{"$f":"of:=SUM([.K17:.N17])","v":{"v":7304.39167549546,"d":"7.304 €"}},{"$f":"of:=([.B17]+[.C17])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B17]+[.C17])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C19]","v":{"v":425.588605939948,"d":"426 €"}},{"$f":"of:=[$TILHyp2.C19]","v":{"v":657.019718564589,"d":"657 €"}},{"$f":"of:=[$TIL_B1.C19]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C19]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D19]","v":{"v":6504.41139406005,"d":"6.504 €"}},{"$f":"of:=[$TILHyp2.D19]","v":{"v":799.980281435411,"d":"800 €"}},{"$f":"of:=[$TIL_B1.D19]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D19]","v":{"v":0,"d":"0 €"}}]
["16.",{"$f":"of:=SUM([.F18:.I18])","v":{"v":936.087192489458,"d":"936 €"}},{"$f":"of:=SUM([.K18:.N18])","v":{"v":7450.91280751054,"d":"7.451 €"}},{"$f":"of:=([.B18]+[.C18])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=([.B18]+[.C18])/12","v":{"v":698.916666666667,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C20]","v":{"v":302.387054925689,"d":"302 €"}},{"$f":"of:=[$TILHyp2.C20]","v":{"v":633.700137563769,"d":"634 €"}},{"$f":"of:=[$TIL_B1.C20]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C20]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D20]","v":{"v":6627.61294507431,"d":"6.628 €"}},{"$f":"of:=[$TILHyp2.D20]","v":{"v":823.299862436231,"d":"823 €"}},{"$f":"of:=[$TIL_B1.D20]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D20]","v":{"v":0,"d":"0 €"}}]
["17.",{"$f":"of:=SUM([.F19:.I19])","v":{"v":1159.49942866577,"d":"1.159 €"}},{"$f":"of:=SUM([.K19:.N19])","v":{"v":7227.50057133422,"d":"7.228 €"}},{"$f":"of:=([.B19]+[.C19])/12","v":{"v":698.916666666666,"d":"698,92 €"}},{"$f":"of:=([.B19]+[.C19])/12","v":{"v":698.916666666666,"d":"698,92 €"}},{"$f":"of:=[$TILHyp1.C21]","v":{"v":549.798699545066,"d":"550 €"}},{"$f":"of:=[$TILHyp2.C21]","v":{"v":609.700729120706,"d":"610 €"}},{"$f":"of:=[$TIL_B1.C21]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C21]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D21]","v":{"v":6380.20130045493,"d":"6.380 €"}},{"$f":"of:=[$TILHyp2.D21]","v":{"v":847.299270879294,"d":"847 €"}},{"$f":"of:=[$TIL_B1.D21]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D21]","v":{"v":0,"d":"0 €"}}]
["18.",{"$f":"of:=SUM([.F20:.I20])","v":{"v":737.143656088227,"d":"737 €"}},{"$f":"of:=SUM([.K20:.N20])","v":{"v":871.998266752381,"d":"872 €"}},{"$f":"of:=([.B20]+[.C20])/12","v":{"v":134.095160236717,"d":"134,10 €"}},{"$f":"of:=([.B20]+[.C20])/12","v":{"v":134.095160236717,"d":"134,10 €"}},{"$f":"of:=[$TILHyp1.C22]","v":{"v":152.141922840607,"d":"152 €"}},{"$f":"of:=[$TILHyp2.C22]","v":{"v":585.00173324762,"d":"585 €"}},{"$f":"of:=[$TIL_B1.C22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C22]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D22]","v":{"v":871.998266752381,"d":"872 €"}},{"$f":"of:=[$TIL_B1.D22]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D22]","v":{"v":0,"d":"0 €"}}]
["19.",{"$f":"of:=SUM([.F21:.I21])","v":{"v":559.582755121241,"d":"560 €"}},{"$f":"of:=SUM([.K21:.N21])","v":{"v":897.417244878759,"d":"897 €"}},{"$f":"of:=([.B21]+[.C21])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B21]+[.C21])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C23]","v":{"v":559.582755121241,"d":"560 €"}},{"$f":"of:=[$TIL_B1.C23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C23]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D23]","v":{"v":897.417244878759,"d":"897 €"}},{"$f":"of:=[$TIL_B1.D23]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D23]","v":{"v":0,"d":"0 €"}}]
["20.",{"$f":"of:=SUM([.F22:.I22])","v":{"v":533.422807118669,"d":"533 €"}},{"$f":"of:=SUM([.K22:.N22])","v":{"v":923.577192881331,"d":"924 €"}},{"$f":"of:=([.B22]+[.C22])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B22]+[.C22])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C24]","v":{"v":533.422807118669,"d":"533 €"}},{"$f":"of:=[$TIL_B1.C24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C24]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D24]","v":{"v":923.577192881331,"d":"924 €"}},{"$f":"of:=[$TIL_B1.D24]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D24]","v":{"v":0,"d":"0 €"}}]
["21.",{"$f":"of:=SUM([.F23:.I23])","v":{"v":506.500289772307,"d":"507 €"}},{"$f":"of:=SUM([.K23:.N23])","v":{"v":950.499710227693,"d":"950 €"}},{"$f":"of:=([.B23]+[.C23])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B23]+[.C23])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C25]","v":{"v":506.500289772307,"d":"507 €"}},{"$f":"of:=[$TIL_B1.C25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C25]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D25]","v":{"v":950.499710227693,"d":"950 €"}},{"$f":"of:=[$TIL_B1.D25]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D25]","v":{"v":0,"d":"0 €"}}]
["22.",{"$f":"of:=SUM([.F24:.I24])","v":{"v":478.792973985867,"d":"479 €"}},{"$f":"of:=SUM([.K24:.N24])","v":{"v":978.207026014133,"d":"978 €"}},{"$f":"of:=([.B24]+[.C24])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B24]+[.C24])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C26]","v":{"v":478.792973985867,"d":"479 €"}},{"$f":"of:=[$TIL_B1.C26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C26]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D26]","v":{"v":978.207026014133,"d":"978 €"}},{"$f":"of:=[$TIL_B1.D26]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D26]","v":{"v":0,"d":"0 €"}}]
["23.",{"$f":"of:=SUM([.F25:.I25])","v":{"v":450.277982679036,"d":"450 €"}},{"$f":"of:=SUM([.K25:.N25])","v":{"v":1006.72201732096,"d":"1.007 €"}},{"$f":"of:=([.B25]+[.C25])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B25]+[.C25])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C27]","v":{"v":450.277982679036,"d":"450 €"}},{"$f":"of:=[$TIL_B1.C27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C27]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D27]","v":{"v":1006.72201732096,"d":"1.007 €"}},{"$f":"of:=[$TIL_B1.D27]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D27]","v":{"v":0,"d":"0 €"}}]
["24.",{"$f":"of:=SUM([.F26:.I26])","v":{"v":420.931771898612,"d":"421 €"}},{"$f":"of:=SUM([.K26:.N26])","v":{"v":1036.06822810139,"d":"1.036 €"}},{"$f":"of:=([.B26]+[.C26])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B26]+[.C26])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C28]","v":{"v":420.931771898612,"d":"421 €"}},{"$f":"of:=[$TIL_B1.C28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C28]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D28]","v":{"v":1036.06822810139,"d":"1.036 €"}},{"$f":"of:=[$TIL_B1.D28]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D28]","v":{"v":0,"d":"0 €"}}]
["25.",{"$f":"of:=SUM([.F27:.I27])","v":{"v":390.730111378983,"d":"391 €"}},{"$f":"of:=SUM([.K27:.N27])","v":{"v":1066.26988862102,"d":"1.066 €"}},{"$f":"of:=([.B27]+[.C27])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B27]+[.C27])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C29]","v":{"v":390.730111378983,"d":"391 €"}},{"$f":"of:=[$TIL_B1.C29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C29]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D29]","v":{"v":1066.26988862102,"d":"1.066 €"}},{"$f":"of:=[$TIL_B1.D29]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D29]","v":{"v":0,"d":"0 €"}}]
["26.",{"$f":"of:=SUM([.F28:.I28])","v":{"v":359.648064535941,"d":"360 €"}},{"$f":"of:=SUM([.K28:.N28])","v":{"v":1097.35193546406,"d":"1.097 €"}},{"$f":"of:=([.B28]+[.C28])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B28]+[.C28])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C30]","v":{"v":359.648064535941,"d":"360 €"}},{"$f":"of:=[$TIL_B1.C30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C30]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D30]","v":{"v":1097.35193546406,"d":"1.097 €"}},{"$f":"of:=[$TIL_B1.D30]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D30]","v":{"v":0,"d":"0 €"}}]
["27.",{"$f":"of:=SUM([.F29:.I29])","v":{"v":327.659967877311,"d":"328 €"}},{"$f":"of:=SUM([.K29:.N29])","v":{"v":1129.34003212269,"d":"1.129 €"}},{"$f":"of:=([.B29]+[.C29])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B29]+[.C29])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C31]","v":{"v":327.659967877311,"d":"328 €"}},{"$f":"of:=[$TIL_B1.C31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C31]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D31]","v":{"v":1129.34003212269,"d":"1.129 €"}},{"$f":"of:=[$TIL_B1.D31]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D31]","v":{"v":0,"d":"0 €"}}]
["28.",{"$f":"of:=SUM([.F30:.I30])","v":{"v":294.739409813389,"d":"295 €"}},{"$f":"of:=SUM([.K30:.N30])","v":{"v":1162.26059018661,"d":"1.162 €"}},{"$f":"of:=([.B30]+[.C30])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B30]+[.C30])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C32]","v":{"v":294.739409813389,"d":"295 €"}},{"$f":"of:=[$TIL_B1.C32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C32]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D32]","v":{"v":1162.26059018661,"d":"1.162 €"}},{"$f":"of:=[$TIL_B1.D32]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D32]","v":{"v":0,"d":"0 €"}}]
["29.",{"$f":"of:=SUM([.F31:.I31])","v":{"v":260.859208849708,"d":"261 €"}},{"$f":"of:=SUM([.K31:.N31])","v":{"v":1196.14079115029,"d":"1.196 €"}},{"$f":"of:=([.B31]+[.C31])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B31]+[.C31])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C33]","v":{"v":260.859208849708,"d":"261 €"}},{"$f":"of:=[$TIL_B1.C33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C33]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D33]","v":{"v":1196.14079115029,"d":"1.196 €"}},{"$f":"of:=[$TIL_B1.D33]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D33]","v":{"v":0,"d":"0 €"}}]
["30.",{"$f":"of:=SUM([.F32:.I32])","v":{"v":225.99139114411,"d":"226 €"}},{"$f":"of:=SUM([.K32:.N32])","v":{"v":1231.00860885589,"d":"1.231 €"}},{"$f":"of:=([.B32]+[.C32])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B32]+[.C32])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C34]","v":{"v":225.99139114411,"d":"226 €"}},{"$f":"of:=[$TIL_B1.C34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C34]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D34]","v":{"v":1231.00860885589,"d":"1.231 €"}},{"$f":"of:=[$TIL_B1.D34]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D34]","v":{"v":0,"d":"0 €"}}]
["31.",{"$f":"of:=SUM([.F33:.I33])","v":{"v":190.107167409601,"d":"190 €"}},{"$f":"of:=SUM([.K33:.N33])","v":{"v":1266.8928325904,"d":"1.267 €"}},{"$f":"of:=([.B33]+[.C33])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B33]+[.C33])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C35]","v":{"v":190.107167409601,"d":"190 €"}},{"$f":"of:=[$TIL_B1.C35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C35]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D35]","v":{"v":1266.8928325904,"d":"1.267 €"}},{"$f":"of:=[$TIL_B1.D35]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D35]","v":{"v":0,"d":"0 €"}}]
["32.",{"$f":"of:=SUM([.F34:.I34])","v":{"v":153.176909143925,"d":"153 €"}},{"$f":"of:=SUM([.K34:.N34])","v":{"v":1303.82309085608,"d":"1.304 €"}},{"$f":"of:=([.B34]+[.C34])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B34]+[.C34])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C36]","v":{"v":153.176909143925,"d":"153 €"}},{"$f":"of:=[$TIL_B1.C36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C36]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D36]","v":{"v":1303.82309085608,"d":"1.304 €"}},{"$f":"of:=[$TIL_B1.D36]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D36]","v":{"v":0,"d":"0 €"}}]
["33.",{"$f":"of:=SUM([.F35:.I35])","v":{"v":115.170124166213,"d":"115 €"}},{"$f":"of:=SUM([.K35:.N35])","v":{"v":1341.82987583379,"d":"1.342 €"}},{"$f":"of:=([.B35]+[.C35])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B35]+[.C35])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C37]","v":{"v":115.170124166213,"d":"115 €"}},{"$f":"of:=[$TIL_B1.C37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C37]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D37]","v":{"v":1341.82987583379,"d":"1.342 €"}},{"$f":"of:=[$TIL_B1.D37]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D37]","v":{"v":0,"d":"0 €"}}]
["34.",{"$f":"of:=SUM([.F36:.I36])","v":{"v":76.0554314405305,"d":"76 €"}},{"$f":"of:=SUM([.K36:.N36])","v":{"v":1380.94456855947,"d":"1.381 €"}},{"$f":"of:=([.B36]+[.C36])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=([.B36]+[.C36])/12","v":{"v":121.416666666667,"d":"121,42 €"}},{"$f":"of:=[$TILHyp1.C38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C38]","v":{"v":76.0554314405305,"d":"76 €"}},{"$f":"of:=[$TIL_B1.C38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C38]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D38]","v":{"v":1380.94456855947,"d":"1.381 €"}},{"$f":"of:=[$TIL_B1.D38]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D38]","v":{"v":0,"d":"0 €"}}]
["35.",{"$f":"of:=SUM([.F37:.I37])","v":{"v":35.8005351655168,"d":"36 €"}},{"$f":"of:=SUM([.K37:.N37])","v":{"v":0,"d":"0 €"}},{"$f":"of:=([.B37]+[.C37])/12","v":{"v":2.98337793045974,"d":"2,98 €"}},{"$f":"of:=([.B37]+[.C37])/12","v":{"v":2.98337793045974,"d":"2,98 €"}},{"$f":"of:=[$TILHyp1.C39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.C39]","v":{"v":35.8005351655168,"d":"36 €"}},{"$f":"of:=[$TIL_B1.C39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.C39]","v":{"v":0,"d":"0 €"}},null,{"$f":"of:=[$TILHyp1.D39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TILHyp2.D39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B1.D39]","v":{"v":0,"d":"0 €"}},{"$f":"of:=[$TIL_B2.D39]","v":{"v":0,"d":"0 €"}}]

{"sheet":"Dia_Belastung","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Dia_ZinsTilg","index":7,"n_rows":0,"n_cols":0,"rows_kept":0}