{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["Paskolos skaičiuoklė"],"not_rendered":{"defined_names":28},"read":"whole","date_system":"1900"}

{"sheet":"Paskolos skaičiuoklė","index":0,"n_rows":377,"n_cols":9,"rows_kept":377,"merged":[[0,0,0,8],[3,0,3,2],[3,5,3,8],[4,0,4,2],[4,5,4,8],[5,0,5,2],[6,0,6,2],[7,0,7,2],[10,0,10,2],[11,0,11,2],[12,0,12,2],[13,0,13,2],[14,0,14,2]]}
["Paskolos skaičiavimai su papildomais mokėjimais"]
[]
[{"$nulls":3},"Įveskite reikšmes",null,"Instrukcijos"]
["Paskolos dydis",{"$nulls":4},"Turi būti nuo 1 iki 30 metų."]
["Metinių palūkanų norma",{"$nulls":4},"Jei papildomi mokėjimai yra nevienodi, įveskite juos į lentelę."]
["Paskolos atidavimo laikotarpis metais"]
["Paskolos pradžios data"]
["Pasirinktinės papildomos įmokos"]
[]
[]
["Planuojama mėnesio įmoka",null,null,{"$f":"IF(Values_Entered,-PMT(Interest_Rate/12,Loan_Years*12,Loan_Amount),\"\")","v":""}]
["Planuojamas įmokų kiekis",null,null,{"$f":"IF(Values_Entered,Loan_Years*12,\"\")","v":""}]
["Tikrasis įmokų kiekis",null,null,{"$f":"IF(Values_Entered,Number_of_Payments,\"\")","v":""}]
["Ankstesnių įmokų suma",null,null,{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Extra_Pay),\"\")","v":""}]
["Iš viso palūkanų",null,null,{"$f":"IF(Values_Entered,SUMIF(Beg_Bal,\">0\",Int),\"\")","v":""}]
[]
["Nr.","Mokėjimo data","Pradinis balansas","Planuota įmoka","Papildoma įmoka","Visa įmoka","Pagrindinė suma","Palūkanos","Galutinis balansas"]
[{"$f":"IF(Values_Entered,1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Loan_Start,\"\")","v":""},{"$f":"IF(Values_Entered,Loan_Amount,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A18+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B18),MONTH(B18)+1,DAY(B18)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I18,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A82+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B82),MONTH(B82)+1,DAY(B82)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I82,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A146+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B146),MONTH(B146)+1,DAY(B146)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I146,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A210+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B210),MONTH(B210)+1,DAY(B210)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I210,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A274+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B274),MONTH(B274)+1,DAY(B274)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I274,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","",{"$f":"IF(Pay_Num<>\"\",Scheduled_Monthly_Payment,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Scheduled_Extra_Payments,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Sched_Pay+Extra_Pay,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Total_Pay-Int,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal*Interest_Rate/12,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",Beg_Bal-Princ,\"\")","v":""}]
[{"$f":"IF(Values_Entered,A338+1,\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",DATE(YEAR(B338),MONTH(B338)+1,DAY(B338)),\"\")","v":""},{"$f":"IF(Pay_Num<>\"\",I338,\"\")","v":""},"","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]
["","","","","","","","",""]