{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Zinsstaffel"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":12,"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":"Zinsstaffel","index":0,"n_rows":65,"n_cols":15,"rows_kept":65,"cut":false,"hidden":false,"merged":[[3,2,3,3]]}
[null,null,null,"Schweizer/Deutsche Usanz (30/360)",{"$f":"IF(LEFT(Zinsusanzwahl,4)=\"Schw\",\"CH\",IF(LEFT(Zinsusanzwahl,4)=\"Inte\",\"FR\",\"EN\"))","v":"CH"},{"$f":"IF(OR(Zinsusanz=\"CH\",Zinsusanz=\"FR\"),360,365)","v":360},"aktiv",null,null,null,null,true,null,"Schweizer/Deutsche Usanz (30/360)","aktiv"]
["Musterfirma GmbH",null,null,null,null,null,null,null,null,null,null,"Zinsberechnung",null,"Internationale/französiche Usanz (echt/360)","passiv"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Englische Usanz (echt/echt)"]
["Konto",null,"2220 KK Peter Huber",null,null,null,null,null,"0=nicht rechn.",null,"von","2014-01-01"]
["Zinssatz Soll",null,1.4999999999999999E-2,null,null,null,null,null,"1=normal",null,"bis","2014-12-31"]
["Zinssatz Haben",null,3.7499999999999999E-2,null,null,null,null,null,"2=letzte Zeile",null,"Tage",{"$f":"L5+1-L4","v":365}]
[]
["Datum","Valuta","Beleg","Buchungstext","G-Kto.","Soll","Haben","Saldo",null,"hat Schalttag","Anz. Tg.","Zinsen"]
[null,{"$f":"von-1","v":"2013-12-31"},null,"Saldovortrag",null,null,null,50000,{"$f":"IF(B9=B10,0,IF(ISBLANK(B10),2,1))","v":1},{"$f":"IF(AND(Zinsusanz=\"EN\",I9<>0),IF(hatSchalttag(B9,IF(I9=2,bis,B10)),1,0),0)","v":0},{"$f":"IF(I9=1,IF(Zinsusanz=\"CH\",DAYS360(B9,B10,TRUE),B10-B9),IF(I9=2,IF(Zinsusanz=\"CH\",DAYS360(B9,bis,TRUE),bis-B9),\"\"))","v":38},{"$f":"IF(K9=\"\",\"\",H9*K9*IF(Kontotyp=\"aktiv\",IF(H9>=0,p_soll,p_haben),IF(H9>=0,p_haben,p_soll))/(Zinsbasis+J9))","v":79.166666666666671}]
["2014-02-08","2014-02-08",null,"Einbuchung",null,4500,null,{"$f":"IF(NOT(ISBLANK(B10)),H9+IF(Kontotyp=\"aktiv\",+F10-G10,-F10+G10),\"\")","v":54500},1,{"$f":"IF(AND(Zinsusanz=\"EN\",I10<>0),IF(hatSchalttag(B10,IF(I10=2,bis,B11)),1,0),0)","v":0},233,529.10416666666663]
["2014-09-30","2014-10-01",null,"Belastung",null,null,14500,40000,2,{"$f":"IF(AND(Zinsusanz=\"EN\",I11<>0),IF(hatSchalttag(B11,IF(I11=2,bis,B12)),1,0),0)","v":0},89,148.33333333333334]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I12<>0),IF(hatSchalttag(B12,IF(I12=2,bis,B13)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I13<>0),IF(hatSchalttag(B13,IF(I13=2,bis,B14)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I14<>0),IF(hatSchalttag(B14,IF(I14=2,bis,B15)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I15<>0),IF(hatSchalttag(B15,IF(I15=2,bis,B16)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I16<>0),IF(hatSchalttag(B16,IF(I16=2,bis,B17)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I17<>0),IF(hatSchalttag(B17,IF(I17=2,bis,B18)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I18<>0),IF(hatSchalttag(B18,IF(I18=2,bis,B19)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I19<>0),IF(hatSchalttag(B19,IF(I19=2,bis,B20)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I20<>0),IF(hatSchalttag(B20,IF(I20=2,bis,B21)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I21<>0),IF(hatSchalttag(B21,IF(I21=2,bis,B22)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I22<>0),IF(hatSchalttag(B22,IF(I22=2,bis,B23)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I23<>0),IF(hatSchalttag(B23,IF(I23=2,bis,B24)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I24<>0),IF(hatSchalttag(B24,IF(I24=2,bis,B25)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I25<>0),IF(hatSchalttag(B25,IF(I25=2,bis,B26)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I26<>0),IF(hatSchalttag(B26,IF(I26=2,bis,B27)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I27<>0),IF(hatSchalttag(B27,IF(I27=2,bis,B28)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I28<>0),IF(hatSchalttag(B28,IF(I28=2,bis,B29)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I29<>0),IF(hatSchalttag(B29,IF(I29=2,bis,B30)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I30<>0),IF(hatSchalttag(B30,IF(I30=2,bis,B31)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I31<>0),IF(hatSchalttag(B31,IF(I31=2,bis,B32)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I32<>0),IF(hatSchalttag(B32,IF(I32=2,bis,B33)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I33<>0),IF(hatSchalttag(B33,IF(I33=2,bis,B34)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I34<>0),IF(hatSchalttag(B34,IF(I34=2,bis,B35)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I35<>0),IF(hatSchalttag(B35,IF(I35=2,bis,B36)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I36<>0),IF(hatSchalttag(B36,IF(I36=2,bis,B37)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I37<>0),IF(hatSchalttag(B37,IF(I37=2,bis,B38)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I38<>0),IF(hatSchalttag(B38,IF(I38=2,bis,B39)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I39<>0),IF(hatSchalttag(B39,IF(I39=2,bis,B40)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I40<>0),IF(hatSchalttag(B40,IF(I40=2,bis,B41)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",{"$f":"IF(B41=B42,0,IF(ISBLANK(B42),2,1))","v":0},{"$f":"IF(AND(Zinsusanz=\"EN\",I41<>0),IF(hatSchalttag(B41,IF(I41=2,bis,B42)),1,0),0)","v":0},{"$f":"IF(I41=1,IF(Zinsusanz=\"CH\",DAYS360(B41,B42,TRUE),B42-B41),IF(I41=2,IF(Zinsusanz=\"CH\",DAYS360(B41,bis,TRUE),bis-B41),\"\"))","v":""},{"$f":"IF(K41=\"\",\"\",H41*K41*IF(Kontotyp=\"aktiv\",IF(H41>=0,p_soll,p_haben),IF(H41>=0,p_haben,p_soll))/(Zinsbasis+J41))","v":""}]
[null,null,null,null,null,null,null,{"$f":"IF(NOT(ISBLANK(B42)),H41+IF(Kontotyp=\"aktiv\",+F42-G42,-F42+G42),\"\")","v":""},0,{"$f":"IF(AND(Zinsusanz=\"EN\",I42<>0),IF(hatSchalttag(B42,IF(I42=2,bis,B43)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I43<>0),IF(hatSchalttag(B43,IF(I43=2,bis,B44)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I44<>0),IF(hatSchalttag(B44,IF(I44=2,bis,B45)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I45<>0),IF(hatSchalttag(B45,IF(I45=2,bis,B46)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I46<>0),IF(hatSchalttag(B46,IF(I46=2,bis,B47)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I47<>0),IF(hatSchalttag(B47,IF(I47=2,bis,B48)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I48<>0),IF(hatSchalttag(B48,IF(I48=2,bis,B49)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I49<>0),IF(hatSchalttag(B49,IF(I49=2,bis,B50)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I50<>0),IF(hatSchalttag(B50,IF(I50=2,bis,B51)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I51<>0),IF(hatSchalttag(B51,IF(I51=2,bis,B52)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I52<>0),IF(hatSchalttag(B52,IF(I52=2,bis,B53)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I53<>0),IF(hatSchalttag(B53,IF(I53=2,bis,B54)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I54<>0),IF(hatSchalttag(B54,IF(I54=2,bis,B55)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I55<>0),IF(hatSchalttag(B55,IF(I55=2,bis,B56)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I56<>0),IF(hatSchalttag(B56,IF(I56=2,bis,B57)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I57<>0),IF(hatSchalttag(B57,IF(I57=2,bis,B58)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",{"$f":"IF(B58=B59,0,IF(ISBLANK(B59),2,1))","v":0},{"$f":"IF(AND(Zinsusanz=\"EN\",I58<>0),IF(hatSchalttag(B58,IF(I58=2,bis,B59)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",{"$f":"IF(B59=B60,0,IF(ISBLANK(B60),2,1))","v":0},{"$f":"IF(AND(Zinsusanz=\"EN\",I59<>0),IF(hatSchalttag(B59,IF(I59=2,bis,B60)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I60<>0),IF(hatSchalttag(B60,IF(I60=2,bis,B61)),1,0),0)","v":0},"",""]
[null,null,null,null,null,null,null,"",0,{"$f":"IF(AND(Zinsusanz=\"EN\",I61<>0),IF(hatSchalttag(B61,IF(I61=2,bis,B62)),1,0),0)","v":0},"",""]
[null,null,null,"Rundung",null,null,null,{"$f":"IF(NOT(ISBLANK(B62)),H61+IF(Kontotyp=\"aktiv\",+F62-G62,-F62+G62),\"\")","v":""},null,null,null,{"$f":"IF(Rundung,H65-H63-L64,0)","v":-4.1666666680839626E-3}]
[{"$f":"bis","v":"2014-12-31"},{"$f":"bis","v":"2014-12-31"},null,"Total",null,{"$f":"SUM(F$9:F62)","v":4500},{"$f":"SUM(G$9:G62)","v":14500},{"$f":"IF(Kontotyp=\"aktiv\",H9+F63-G63,H9-F63+G63)","v":40000},null,null,{"$f":"SUM(K$9:K62)","v":360},{"$f":"SUM(L$9:L62)","v":756.59999999999854}]
[null,null,null,"Total Zinsbetrag",null,{"$f":"IF(L63<0,-L63,\"\")","v":""},{"$f":"IF(L63>=0,L63,\"\")","v":756.59999999999854},null,null,null,null,{"$f":"SUM(L9:L61)","v":756.60416666666663}]
[null,null,null,"Neuer Saldo",null,null,null,{"$f":"ROUND((H63+L64)/5,2)*5","v":40756.6}]