{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Ark1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Ark1","index":0,"n_rows":46,"n_cols":5,"rows_kept":46,"cut":false,"hidden":false,"merged":[[8,0,9,0],[8,1,9,1],[8,3,9,3],[8,4,9,4]]}
["Oversigt over kontraktforløb i Ribe Amts Indkøbsforening:"]
[]
["Indtastninger:",null,null,"Omkostninger:"]
["Købssum:",150000,null,"Provision:",{"$f":"IF((G5<500),500,(IF((G5>4000),4000,G5)))","v":500}]
["Afdragstid år:",5,null,"Udbetaling:",{"$f":"IF((G6<1),0,G6)","v":0}]
["Rentesats:",2.5,null,"Moms:",{"$f":"(B4*0.25)+(E4*0.25)-(B9*0.25)","v":31375}]
["Terminer pr. år:",4]
["Udbetaling %:",20]
["Værdi af maskine givet i bytte",25000,null,"Betaling ved underskrift:",{"$f":"SUM(E4:E6)","v":31875}]
[]
[]
[]
["Afdragsoversigt:"]
[null,"Rente","Afdrag","Ydelse","Restgæld"]
["Lån:",null,null,null,{"$f":"B4-E5-B9","v":125000}]
["1. termin",{"$f":"IF((E15<>\"\"),(E15*$B$6/100/$B$7),\"\")","v":781.25},{"$f":"IF((E15>0),($E$15/(B$5*B$7)),0)","v":6250},{"$f":"IF((E15>0),(C16+B16),\"\")","v":7031.25},{"$f":"IF((E15-C16)>0,(E15-C16),0)","v":118750}]
["2. termin",742.1875,6250,{"$f":"IF((E16>0),(C17+B17),\"\")","v":6992.1875},{"$f":"IF((E16-C17)>0,(E16-C17),0)","v":112500}]
["3. termin",703.125,6250,6953.125,106250]
["4. termin",664.0625,6250,6914.0625,100000]
["5. termin",625,6250,6875,93750]
["6. termin",585.9375,6250,6835.9375,87500]
["7. termin",546.875,6250,6796.875,81250]
["8. termin",507.8125,6250,6757.8125,75000]
["9. termin",468.75,6250,6718.75,68750]
["10. termin",429.6875,6250,6679.6875,62500]
["11. termin",390.625,6250,6640.625,56250]
["12. termin",351.5625,6250,6601.5625,50000]
["13. termin",312.5,6250,6562.5,43750]
["14. termin",273.4375,6250,6523.4375,37500]
["15. termin",234.375,6250,6484.375,31250]
["16. termin",195.3125,6250,6445.3125,25000]
["17. termin",156.25,6250,6406.25,18750]
["18. termin",117.1875,6250,6367.1875,12500]
["19. termin",78.125,6250,6328.125,6250]
["20. termin",39.0625,6250,6289.0625,0]
["21. termin",0,0,"",0]
["22. termin",0,0,"",0]
["23. termin",0,0,"",0]
["24. termin",0,0,"",0]
["25. termin",0,0,"",0]
["26. termin",0,0,"",0]
["27. termin",0,0,"",0]
["28. termin",0,0,{"$f":"IF((E42>0),(C43+B43),\"\")","v":""},{"$f":"IF((E42-C43)>0,(E42-C43),0)","v":0}]
[]
["Samlet betaling incl. provision:",null,null,{"$f":"SUM(D16:D44)+E4","v":133703.125}]
["Samlede omkostninger incl. provision:",null,null,{"$f":"D45-E15","v":8703.125}]