{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Авто_Калькулятор"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":7,"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":"Авто_Калькулятор","index":0,"n_rows":90,"n_cols":50,"rows_kept":90,"cut":false,"hidden":false,"merged":[[10,28,10,29],[1,11,1,12],[5,11,5,12],[1,4,1,5],[1,1,1,3],[7,1,7,3],[7,4,7,5],[11,11,11,12],[1,28,1,35],[5,28,5,29],[4,28,4,29],[9,32,9,33],[7,34,7,35],[8,32,8,33],[8,34,8,35],[7,32,7,33],[5,32,5,33],[6,28,6,29],[6,32,6,33],[8,28,8,29],[9,34,9,35],[9,28,9,29],[6,34,6,35],[7,28,7,29],[13,11,13,12],[3,1,3,3],[3,4,3,5],[5,1,5,3],[5,4,5,5],[3,11,3,13],[15,1,15,3],[15,4,15,5],[17,4,17,5],[17,1,17,3],[9,11,9,12],[13,4,13,5],[13,1,13,3],[9,1,9,3],[9,4,9,5],[15,11,15,12],[11,1,11,3],[11,4,11,5],[17,11,17,12],[2,28,2,29],[2,32,2,33],[2,34,2,35],[3,28,3,29],[3,32,3,33],[30,32,30,33],[4,32,4,33],[3,34,3,35],[4,34,4,35],[24,34,24,35],[22,34,22,35],[15,32,15,33],[16,28,16,29],[26,34,26,35],[19,34,19,35],[21,34,21,35],[20,34,20,35],[26,28,26,29],[11,28,11,29],[11,32,11,33],[18,34,18,35],[11,34,11,35],[21,28,21,29],[20,32,20,33],[26,1,26,2],[26,5,26,6],[26,7,26,8],[25,34,25,35],[24,28,24,29],[19,1,19,3],[27,1,27,2],[27,5,27,6],[28,1,28,2],[28,5,28,6],[19,11,19,12],[19,4,19,5],[29,7,29,8],[29,34,29,35],[27,32,27,33],[15,28,15,29],[29,28,29,29],[27,34,27,35],[28,34,28,35],[28,28,28,29],[28,32,28,33],[27,28,27,29],[28,7,28,8],[27,7,27,8],[23,34,23,35],[21,11,22,12],[21,13,22,13],[33,34,33,35],[34,1,34,2],[34,5,34,6],[34,7,34,8],[30,5,30,6],[30,7,30,8],[31,28,31,29],[34,34,34,35],[31,1,31,2],[31,5,31,6],[31,7,31,8],[32,1,32,2],[32,5,32,6],[33,32,33,33],[31,34,31,35],[30,34,30,35],[32,34,32,35],[32,7,32,8],[33,1,33,2],[33,5,33,6],[33,7,33,8],[30,1,30,2],[33,28,33,29],[14,32,14,33],[31,32,31,33],[32,32,32,33],[30,28,30,29],[32,28,32,29],[29,32,29,33],[23,28,23,29],[21,32,21,33],[24,32,24,33],[26,32,26,33],[23,32,23,33],[25,32,25,33],[20,28,20,29],[19,32,19,33],[29,1,29,2],[29,5,29,6],[10,32,10,33],[10,34,10,35],[25,28,25,29],[16,34,16,35],[17,34,17,35],[17,32,17,33],[17,28,17,29],[18,28,18,29],[18,32,18,33],[14,34,14,35],[15,34,15,35],[12,28,12,29],[12,32,12,33],[12,34,12,35],[13,34,13,35],[14,28,14,29],[22,28,22,29],[22,32,22,33],[13,32,13,33],[13,28,13,29],[16,32,16,33],[19,28,19,29],[5,34,5,35],[7,11,7,12],[37,28,37,29],[37,1,37,2],[37,5,37,6],[36,1,36,2],[34,28,34,29],[39,34,39,35],[40,32,40,33],[40,34,40,35],[37,32,37,33],[38,1,38,2],[38,5,38,6],[38,28,38,29],[39,32,39,33],[38,32,38,33],[38,34,38,35],[39,1,39,2],[39,5,39,6],[39,28,39,29],[35,34,35,35],[37,34,37,35],[36,34,36,35],[34,32,34,33],[36,32,36,33],[35,32,35,33],[41,32,41,33],[43,1,43,2],[43,5,43,6],[41,34,41,35],[40,1,40,2],[40,5,40,6],[40,28,40,29],[41,1,41,2],[41,5,41,6],[41,28,41,29],[43,34,43,35],[36,28,36,29],[35,28,35,29],[35,1,35,2],[35,5,35,6],[36,5,36,6],[35,16,35,18],[44,32,44,33],[44,34,44,35],[42,32,42,33],[42,34,42,35],[43,28,43,29],[43,32,43,33],[44,1,44,2],[44,5,44,6],[44,28,44,29],[42,1,42,2],[42,5,42,6],[42,28,42,29],[46,32,46,33],[46,34,46,35],[49,32,49,33],[49,34,49,35],[49,28,49,29],[47,1,47,2],[47,5,47,6],[47,28,47,29],[45,1,45,2],[45,5,45,6],[45,28,45,29],[46,1,46,2],[46,5,46,6],[46,28,46,29],[45,34,45,35],[45,32,45,33],[47,32,47,33],[47,34,47,35],[51,1,51,2],[51,5,51,6],[48,1,48,2],[48,5,48,6],[48,28,48,29],[49,1,49,2],[49,5,49,6],[50,32,50,33],[50,34,50,35],[50,1,50,2],[50,5,50,6],[50,28,50,29],[51,28,51,29],[51,32,51,33],[51,34,51,35],[48,32,48,33],[48,34,48,35],[53,32,53,33],[53,34,53,35],[52,32,52,33],[52,34,52,35],[55,1,55,2],[55,5,55,6],[52,1,52,2],[52,5,52,6],[52,28,52,29],[53,1,53,2],[53,5,53,6],[53,28,53,29],[54,32,54,33],[54,34,54,35],[54,1,54,2],[54,5,54,6],[54,28,54,29],[55,28,55,29],[55,32,55,33],[55,34,55,35],[57,32,57,33],[57,34,57,35],[56,32,56,33],[56,34,56,35],[59,1,59,2],[59,5,59,6],[56,1,56,2],[56,5,56,6],[56,28,56,29],[57,1,57,2],[57,5,57,6],[57,28,57,29],[58,32,58,33],[58,34,58,35],[58,1,58,2],[58,5,58,6],[58,28,58,29],[59,28,59,29],[59,32,59,33],[59,34,59,35],[67,34,67,35],[61,32,61,33],[61,34,61,35],[60,32,60,33],[60,34,60,35],[63,1,63,2],[63,5,63,6],[60,1,60,2],[60,5,60,6],[60,28,60,29],[61,1,61,2],[61,5,61,6],[61,28,61,29],[62,32,62,33],[62,34,62,35],[62,1,62,2],[62,5,62,6],[62,28,62,29],[63,28,63,29],[63,32,63,33],[63,34,63,35],[67,1,67,2],[67,5,67,6],[64,1,64,2],[64,5,64,6],[64,28,64,29],[65,1,65,2],[65,5,65,6],[65,7,65,8],[65,28,65,29],[66,1,66,2],[66,5,66,6],[66,7,66,8],[66,28,66,29],[67,7,67,8],[67,28,67,29],[68,1,68,2],[68,5,68,6],[68,7,68,8],[68,28,68,29],[69,1,69,2],[69,5,69,6],[69,7,69,8],[69,28,69,29],[73,1,73,2],[73,5,73,6],[73,7,73,8],[73,28,73,29],[69,32,69,33],[71,1,71,2],[71,5,71,6],[71,7,71,8],[71,28,71,29],[71,32,71,33],[70,32,70,33],[70,1,70,2],[70,5,70,6],[70,7,70,8],[70,28,70,29],[72,1,72,2],[72,5,72,6],[72,7,72,8],[72,28,72,29],[76,1,76,2],[76,5,76,6],[76,7,76,8],[76,28,76,29],[77,1,77,2],[77,5,77,6],[77,7,77,8],[77,28,77,29],[74,1,74,2],[74,5,74,6],[74,7,74,8],[74,28,74,29],[75,1,75,2],[75,5,75,6],[75,7,75,8],[75,28,75,29],[78,1,78,2],[78,5,78,6],[78,7,78,8],[78,28,78,29],[79,1,79,2],[79,5,79,6],[79,7,79,8],[79,28,79,29],[79,32,79,33],[78,32,78,33],[80,1,80,2],[80,5,80,6],[80,7,80,8],[80,28,80,29],[80,32,80,33],[80,34,80,35],[81,1,81,2],[81,5,81,6],[81,7,81,8],[81,28,81,29],[81,32,81,33],[81,34,81,35],[82,1,82,2],[82,5,82,6],[82,7,82,8],[82,28,82,29],[85,5,85,6],[85,7,85,8],[85,32,85,33],[84,28,84,29],[85,34,85,35],[83,32,83,33],[83,34,83,35],[82,32,82,33],[82,34,82,35],[86,7,86,8],[83,1,83,2],[83,5,83,6],[83,7,83,8],[85,28,85,29],[87,1,87,2],[87,5,87,6],[87,7,87,8],[88,1,88,2],[84,1,84,2],[84,5,84,6],[84,7,84,8],[86,1,86,2],[86,5,86,6],[85,1,85,2],[88,5,88,6],[88,7,88,8],[83,28,83,29],[89,5,89,6],[89,7,89,8],[89,28,89,29],[89,1,89,2],[91,1,91,2],[91,5,91,6],[91,7,91,8],[90,1,90,2],[90,5,90,6],[90,7,90,8],[92,1,92,2],[92,5,92,6],[92,7,92,8],[93,1,93,2],[93,5,93,6],[93,7,93,8],[94,1,94,2],[94,5,94,6],[94,7,94,8],[95,1,95,2],[95,5,95,6],[95,7,95,8],[96,1,96,2],[96,5,96,6],[96,7,96,8],[97,1,97,2],[97,5,97,6],[97,7,97,8],[98,1,98,2],[98,5,98,6],[98,7,98,8],[99,1,99,2],[99,5,99,6],[99,7,99,8],[100,1,100,2],[100,5,100,6],[100,7,100,8],[101,1,101,2],[101,5,101,6],[101,7,101,8],[102,1,102,2],[102,5,102,6],[102,7,102,8],[103,1,103,2],[103,5,103,6],[103,7,103,8],[104,1,104,2],[104,5,104,6],[104,7,104,8],[105,1,105,2],[105,5,105,6],[105,7,105,8],[106,1,106,2],[106,5,106,6],[106,7,106,8],[107,1,107,2],[107,5,107,6],[107,7,107,8],[108,1,108,2],[108,5,108,6],[108,7,108,8],[109,1,109,2],[109,5,109,6],[109,7,109,8],[110,1,110,2],[110,5,110,6],[110,7,110,8],[111,1,111,2],[111,5,111,6],[111,7,111,8],[112,1,112,2],[112,5,112,6],[112,7,112,8],[113,1,113,2],[113,5,113,6],[113,7,113,8],[114,1,114,2],[114,5,114,6],[114,7,114,8],[115,1,115,2],[115,5,115,6],[115,7,115,8],[116,1,116,2],[116,5,116,6],[116,7,116,8],[117,1,117,2],[117,5,117,6],[117,7,117,8],[118,1,118,2],[118,5,118,6],[118,7,118,8],[119,1,119,2],[119,5,119,6],[119,7,119,8],[120,1,120,2],[120,5,120,6],[120,7,120,8],[121,1,121,2],[121,5,121,6],[121,7,121,8],[122,1,122,2],[122,5,122,6],[122,7,122,8],[123,1,123,2],[123,5,123,6],[123,7,123,8],[124,1,124,2],[124,5,124,6],[124,7,124,8],[125,1,125,2],[125,5,125,6],[125,7,125,8],[126,1,126,2],[126,5,126,6],[126,7,126,8],[127,1,127,2],[127,5,127,6],[127,7,127,8],[128,1,128,2],[128,5,128,6],[128,7,128,8],[129,1,129,2],[129,5,129,6],[129,7,129,8],[130,1,130,2],[130,5,130,6],[130,7,130,8],[131,1,131,2],[131,5,131,6],[131,7,131,8],[132,1,132,2],[132,5,132,6],[132,7,132,8],[133,1,133,2],[133,5,133,6],[133,7,133,8],[139,1,139,2],[139,5,139,6],[139,7,139,8],[140,5,140,6],[140,7,140,8],[134,1,134,2],[134,5,134,6],[134,7,134,8],[135,1,135,2],[135,5,135,6],[135,7,135,8],[136,1,136,2],[136,5,136,6],[136,7,136,8],[70,34,70,35],[71,34,71,35],[141,1,141,2],[141,5,141,6],[141,7,141,8],[142,1,142,2],[142,5,142,6],[142,7,142,8],[145,1,145,2],[145,5,145,6],[145,7,145,8],[143,1,143,2],[144,1,144,2],[144,5,144,6],[144,7,144,8],[143,5,143,6],[143,7,143,8],[137,1,137,2],[137,5,137,6],[137,7,137,8],[140,1,140,2],[138,1,138,2],[138,5,138,6],[138,7,138,8],[65,32,65,33],[65,34,65,35],[64,32,64,33],[64,34,64,35],[66,32,66,33],[66,34,66,35],[67,32,67,33],[79,34,79,35],[75,34,75,35],[77,32,77,33],[77,34,77,35],[76,32,76,33],[76,34,76,35],[75,32,75,33],[78,34,78,35],[74,32,74,33],[74,34,74,35],[73,32,73,33],[73,34,73,35],[72,32,72,33],[72,34,72,35],[69,34,69,35],[68,32,68,33],[68,34,68,35],[89,34,89,35],[86,28,86,29],[87,28,87,29],[87,32,87,33],[88,28,88,29],[88,32,88,33],[88,34,88,35],[89,32,89,33],[84,32,84,33],[84,34,84,35],[87,34,87,35],[86,34,86,35],[86,32,86,33],[1,37,1,45],[2,37,2,38],[2,41,2,42],[2,43,2,44],[3,37,3,38],[3,41,3,42],[3,43,3,44],[4,37,4,38],[4,41,4,42],[4,43,4,44],[5,37,5,38],[5,41,5,42],[5,43,5,44],[6,37,6,38],[6,41,6,42],[6,43,6,44],[7,37,7,38],[7,41,7,42],[7,43,7,44],[8,37,8,38],[8,41,8,42],[8,43,8,44],[9,37,9,38],[9,41,9,42],[9,43,9,44],[10,37,10,38],[10,41,10,42],[10,43,10,44],[11,37,11,38],[11,41,11,42],[11,43,11,44],[12,37,12,38],[12,41,12,42],[12,43,12,44],[13,37,13,38],[13,41,13,42],[13,43,13,44],[14,37,14,38],[14,41,14,42],[14,43,14,44],[15,37,15,38],[15,41,15,42],[15,43,15,44],[16,37,16,38],[16,41,16,42],[16,43,16,44],[17,37,17,38],[17,41,17,42],[17,43,17,44],[18,37,18,38],[18,41,18,42],[18,43,18,44],[19,37,19,38],[19,41,19,42],[19,43,19,44],[20,37,20,38],[20,41,20,42],[20,43,20,44],[21,37,21,38],[21,41,21,42],[21,43,21,44],[22,37,22,38],[22,41,22,42],[22,43,22,44],[23,37,23,38],[23,41,23,42],[23,43,23,44],[24,37,24,38],[24,41,24,42],[24,43,24,44],[25,37,25,38],[25,41,25,42],[25,43,25,44],[26,37,26,38],[26,41,26,42],[26,43,26,44],[27,37,27,38],[27,41,27,42],[27,43,27,44],[28,37,28,38],[28,41,28,42],[28,43,28,44],[29,37,29,38],[29,41,29,42],[29,43,29,44],[30,37,30,38],[30,41,30,42],[30,43,30,44],[31,37,31,38],[31,41,31,42],[31,43,31,44],[32,37,32,38],[32,41,32,42],[32,43,32,44],[33,37,33,38],[33,41,33,42],[33,43,33,44],[34,37,34,38],[34,41,34,42],[34,43,34,44],[35,37,35,38],[35,41,35,42],[35,43,35,44],[36,37,36,38],[36,41,36,42],[36,43,36,44],[37,37,37,38],[37,41,37,42],[37,43,37,44],[38,37,38,38],[38,41,38,42],[38,43,38,44],[39,37,39,38],[39,41,39,42],[39,43,39,44],[40,37,40,38],[40,41,40,42],[40,43,40,44],[41,37,41,38],[41,41,41,42],[41,43,41,44],[42,37,42,38],[42,41,42,42],[42,43,42,44],[43,37,43,38],[43,41,43,42],[43,43,43,44],[44,37,44,38],[44,41,44,42],[44,43,44,44],[45,37,45,38],[45,41,45,42],[45,43,45,44],[46,37,46,38],[46,41,46,42],[46,43,46,44],[47,37,47,38],[47,41,47,42],[47,43,47,44],[48,37,48,38],[48,41,48,42],[48,43,48,44],[49,37,49,38],[49,41,49,42],[49,43,49,44],[50,37,50,38],[50,41,50,42],[50,43,50,44],[51,37,51,38],[51,41,51,42],[51,43,51,44],[52,37,52,38],[52,41,52,42],[52,43,52,44],[53,37,53,38],[53,41,53,42],[53,43,53,44],[54,37,54,38],[54,41,54,42],[54,43,54,44],[55,37,55,38],[55,41,55,42],[55,43,55,44],[56,37,56,38],[56,41,56,42],[56,43,56,44],[57,37,57,38],[57,41,57,42],[57,43,57,44],[58,37,58,38],[58,41,58,42],[58,43,58,44],[59,37,59,38],[59,41,59,42],[59,43,59,44],[60,37,60,38],[60,41,60,42],[60,43,60,44],[61,37,61,38],[61,41,61,42],[61,43,61,44],[62,37,62,38],[62,41,62,42],[62,43,62,44],[63,37,63,38],[63,41,63,42],[63,43,63,44],[64,37,64,38],[64,41,64,42],[64,43,64,44],[65,37,65,38],[65,41,65,42],[65,43,65,44],[66,37,66,38],[66,41,66,42],[66,43,66,44],[71,37,71,38],[71,41,71,42],[71,43,71,44],[73,41,73,42],[73,43,73,44],[74,37,74,38],[74,41,74,42],[74,43,74,44],[73,37,73,38],[72,37,72,38],[72,41,72,42],[67,37,67,38],[67,41,67,42],[67,43,67,44],[68,37,68,38],[68,41,68,42],[68,43,68,44],[72,43,72,44],[69,37,69,38],[69,41,69,42],[69,43,69,44],[70,37,70,38],[70,41,70,42],[70,43,70,44],[77,43,77,44],[78,37,78,38],[78,41,78,42],[78,43,78,44],[77,37,77,38],[77,41,77,42],[75,37,75,38],[75,41,75,42],[75,43,75,44],[76,37,76,38],[76,41,76,42],[76,43,76,44],[81,37,81,38],[81,41,81,42],[85,43,85,44],[86,37,86,38],[86,41,86,42],[79,37,79,38],[79,41,79,42],[79,43,79,44],[80,37,80,38],[80,41,80,42],[80,43,80,44],[86,43,86,44],[83,37,83,38],[83,41,83,42],[83,43,83,44],[84,37,84,38],[84,41,84,42],[84,43,84,44],[81,43,81,44],[82,37,82,38],[82,41,82,42],[82,43,82,44],[85,37,85,38],[85,41,85,42],[89,43,89,44],[87,37,87,38],[87,41,87,42],[87,43,87,44],[88,37,88,38],[88,41,88,42],[88,43,88,44],[89,37,89,38],[89,41,89,42]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Термін",null,null,null,null,null,null,null,null,null,null,"Ануїтет",null,null,null,null,null,null,null,null,"Класика"]
[null,"Вартість транспортного засобу (грн)",null,null,null,null,null,null,null,null,null,"Бажана сума кредиту",null,null,null,null,null,12,null,null,"Ануїтетна",null,{"$f":"IF(AND(V3=1,W3=1),2,0)","v":0},null,null,null,null,null,"ГРАФІК ПОГАШЕННЯ КРЕДИТУ ",null,null,null,null,null,null,null,null,"ГРАФІК ПОГАШЕННЯ КРЕДИТУ ",null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E8=R8,N8+AW16+AW28+AW40+AW52+AW64+AW76,IF(E8=R7,N8+AW16+AW28+AW40+AW52+AW64,IF(E8=R6,N8+AW16+AW28+AW40+AW52,IF(E8=R5,N8+AW16+AW28+AW40,IF(E8=R4,N8+AW16+AW28,IF(E8=R3,N8+AW16,IF(E8=R2,N8)))))))","v":{"$error":"#VALUE!"}},{"$f":"IF(E8=R8,N10+AX16+AX28+AX40+AX52+AX64+AX76,IF(E8=R7,N10+AX16+AX28+AX40+AX52+AX64,IF(E8=R6,N10+AX16+AX28+AX40+AX52,IF(E8=R5,N10+AX16+AX28+AX40,IF(E8=R4,N10+AX16+AX28,IF(E8=R3,N10+AX16,IF(E8=R2,N10)))))))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24,null,null,"Формат для авансу Продукту",{"$f":"IF(E25=\"\",0,1)","v":0},{"$f":"IF(E2=\"\",0,1)","v":0},{"$f":"IF(AND(F4=0,F6=0),0,IF(AND(F4>0,F6=\"\"),1,IF(AND(F4=0,F6>0),2,3)))","v":0},null,null,null,"Місяць","№ платежу",null,"Розмір щомісячних внесків з повернення кредиту, грн.","Щомісячна плата за кредитне обслуговування, грн.","Розмір щомісячних процентних внесків, грн.",null,"Загальна сума внесків до повернення в місяць, грн.",null,"Місяць","№ платежу",null,"Розмір щомісячних внесків з повернення кредиту, грн.","Щомісячна плата за кредитне обслуговування, грн.","Розмір щомісячних процентних внесків, грн.",null,"Загальна сума внесків до повернення в місяць, грн.",null,"Залишок заборгованості",{"$f":"-N2+N8+N10+N12+N6+N14","v":{"$error":"#VALUE!"}}]
[null,"Рік випуску авто",null,null,null,null,null,null,null,null,null,{"$f":"IF(N2>E18,\"Сума бажаного кредиту перевищує максимальний розмір допустимого кредиту \"&E18,\"\")","v":""},null,null,null,null,null,36,null,null,{"$f":"IF(N2>E18,1,0)","v":0},{"$f":"IF(E4=\"\",0,1)","v":0},{"$f":"IF(E6=\"\",0,1)","v":0},{"$f":"IF(AND(V4=1,W4=0),1,IF(AND(W4=1,V4=0),2,IF(AND(V4=1,W4=1),3,IF(AND(V4=0,W4=0),4))))","v":4},null,null,null,{"$f":"DATE(YEAR($V$19),MONTH($V$19)+1,DAY(1)-1)","v":"2020-08-31"},1,null,{"$f":"IF($U$2=$X$17,PPMT($E$14/1200,AC4,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($AE$4=0,$N$2*($E$14/100)*(AB4-$V$19+1)/360,IPMT($E$14/1200,AC4,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"AG4+AE4","v":{"$error":"#VALUE!"}},null,{"$f":"DATE(YEAR($V$19),MONTH($V$19)+1,DAY(1)-1)","v":"2020-08-31"},1,null,{"$f":"IF($V$20>15,0,$N$2/$E$8)","v":0},null,{"$f":"IF(AN4=0,$N$2*($E$14/100)*(AK4-$V$19+1)/360,$N$2*$E$14/100*31/360)","v":{"$error":"#VALUE!"}},null,{"$f":"AP4","v":{"$error":"#VALUE!"}},null,null,{"$f":"AI4","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,48,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC5=\"\",\"\",DATE(YEAR(AB4),MONTH(AB4)+2,DAY(1)-1))","v":"2020-09-30"},2,null,{"$f":"IF($AE$4=0,PPMT($E$14/1200,AC4,$E$8,-$N$2),PPMT($E$14/1200,AC5,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($AE$4=0,IPMT($E$14/1200,AC4,$E$8,-$N$2),IPMT($E$14/1200,AC5,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"AG5+AE5","v":{"$error":"#VALUE!"}},null,{"$f":"IF(AL5=\"\",\"\",DATE(YEAR(AK4),MONTH(AK4)+2,DAY(1)-1))","v":"2020-09-30"},2,null,{"$f":"$N$2/$E$8","v":{"$error":"#DIV/0!"}},null,{"$f":"AT5*$E$14/100*(AK5-AK4)/360","v":{"$error":"#VALUE!"}},null,{"$f":"AN5+AP5","v":{"$error":"#DIV/0!"}},null,{"$f":"$N$2-AN4","v":0},{"$f":"AI5","v":{"$error":"#VALUE!"}}]
[null,"Період перебування транспортного засобу у власності особи, яка передає його в заставу Банку",null,null,null,null,null,null,null,null,null,"Комісія за видачу кредиту (грн)",null,{"$f":"IF(E14=\"\",\"\",Y42*N2)","v":""},null,null,null,60,null,null,null,null,null,null,null,null,null,"2020-10-31",3,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$f":"AG6+AE6","v":{"$error":"#VALUE!"}},null,"2020-10-31",3,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"AT5-AN5","v":{"$error":"#DIV/0!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-11-30",4,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2020-11-30",4,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Термін кредитування (міс)",null,null,null,null,null,null,null,null,null,"Страхування КАСКО щорічно (грн)",null,{"$f":"IF(E8=0,\"\",(T33/100)*E2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-31",5,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2020-12-31",5,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-01-31",6,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-01-31",6,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Вік автомобіля на момент початку дії \nдоговору, (міс)",null,null,{"$f":"IF(E4=\"\",0,(YEAR(NOW())-E4)*12)","v":0},{"$f":"IF(#REF!=\"\",0,(YEAR(NOW())-#REF!)*12)","v":{"$error":"#REF!"}},null,null,null,null,null,"Страхування НВ щорічно (грн)",null,{"$f":"IFERROR(ROUND($Q$22*$R$12,2)+($R$12*$N$8),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"2021-02-28",7,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-02-28",7,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Варіанти НВ",null,null,null,null,null,null,null,null,null,"2021-03-31",8,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-03-31",8,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Вік автомобіля на момент завершення дії \nдоговору, (міс.)",null,null,{"$f":"IF(E10=\"\",\"\",E10+E8)","v":0},null,null,null,null,null,null,"Нотаріальні послуги (одноразово)",null,{"$f":"IF(E8=0,\"\",3085)","v":""},null,null,null,2.9899999999999999E-2,null,null,null,null,null,null,null,null,null,"2021-04-30",9,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-04-30",9,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(R12=0,0%,5.99%)","v":5.9900000000000002E-2},null,null,null,null,null,null,null,null,null,"2021-05-31",10,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-05-31",10,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Відсоткова ставка річна (%)",null,null,{"$f":"IF(P42=0,\"\",P42)","v":""},null,null,null,null,null,null,"Витрати оцінювача (одноразово)",null,{"$f":"IF(E8=0,\"\",U33)","v":""},null,null,null,"Сума кредиту",null,null,null,null,null,"Так",null,null,null,"2021-06-30",11,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-06-30",11,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"без комісії за видачу",{"$f":"$E$2-IF($X$4=1,$F$4,IF($X$4=2,$E$2/100*$F$6,0))+$N$8","v":{"$error":"#VALUE!"}},null,null,null,null,null,"Ні",null,null,null,"2021-07-31",12,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-07-31",12,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Співвідношення суми кредиту до граничної вартості транспортного засобу",null,null,{"$f":"O37","v":0},null,null,null,null,null,null,"Суму платежу за розрахунковий період (місяць) (грн)",null,{"$f":"IFERROR(AI4,\"\")","v":""},null,null,"вартість-аванс",{"$f":"$E$2-IF($X$4=1,$F$4,IF($X$4=2,$E$2/100*$F$6))","v":0},null,null,null,null,null,null,null,null,null,"2021-08-31",13,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-08-31",13,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI16+AW16+AX16","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$2,$E$2*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$2,(AE90-SUM(AE4:AE15))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ануїтетна",null,null,null,"2021-09-30",14,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-09-30",14,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Максимальний розмір кредиту",null,null,{"$f":"IF(E2=\"\",\"\",E2*E16)","v":""},null,null,null,null,null,null,"Сума процентів за користування кредитом",null,{"$f":"IF(E18=\"\",\"\",AG90)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(L4=S28,L4=S31),\"Класична\",\"\")","v":"Класична"},null,null,null,"2021-10-31",15,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-10-31",15,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"сума дод. страхування",null,null,"Дата",{"$f":"TODAY()","v":"2020-08-31"},null,1,31,null,null,"2021-11-30",16,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-11-30",16,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,"Реальна річна процентна ставка, відсотків річних",null,null,{"$f":"IFERROR(IF(E8=\"\",\"\",IF(E8=R2,XIRR(AU3:AU15,AB4:AB16),IF(E8=R3,XIRR(AU3:AU27,AB4:AB28),IF(E8=R4,XIRR(AU3:AU39,AB4:AB40),IF(E8=R5,XIRR(AU3:AU51,AB4:AB52),IF(E8=R6,XIRR(AU3:AU63,AB4:AB64))))))),\"\")","v":""},null,null,null,null,null,null,"Загальна вартість кредиту для клієнта (грн)",null,{"$f":"IF(L4=\"\",IF(N12=\"\",\"\",AW2+AX2+N14+N2+N6+N18+N12),\"\")","v":""},null,null,null,{"$f":"IF(#REF!=\"Так\",ROUND((E2-F6+N8)*#REF!/100,2),IF(#REF!=\"Ні\",ROUND((E2-F6)*#REF!/100,2),0))","v":{"$error":"#REF!"}},null,null,"Число",{"$f":"DAY(V19)","v":31},null,2,28,null,null,"2021-12-31",17,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2021-12-31",17,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(ROUND($N$2*$R$12,2)+($R$12*$N$8),\"\")","v":""},null,null,null,"Місяць",{"$f":"MONTH(V19)","v":8},null,3,31,null,null,"2022-01-31",18,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-01-31",18,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,"Загальні витрати за кредитом (грн)",null,{"$f":"IFERROR(N20-N2,\"\")","v":""},null,null,{"$f":"IFERROR(($N$2-$Q$21)-$N$8,\"\")","v":""},null,null,null,"Максимальна сума кредиту",1200000,null,4,30,null,null,{"$f":"IF(AC22=\"\",\"\",DATE(YEAR(AB21),MONTH(AB21)+2,DAY(1)-1))","v":"2022-02-28"},19,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-02-28",19,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%,Участь власними коштами",{"$f":"IF(X4=1,F4/E2*100,IF(X4=2,F6,0))","v":0},null,5,31,null,null,"2022-03-31",20,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-03-31",20,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2020-08-31"},"Дата","ПМ",null,null,null,null,null,null,null,null,"2022-04-30",21,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-04-30",21,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q24<R26,S25,IF(Q24<R27,S26,S27))","v":2197},"2020-01-01",2102,null,null,null,null,6,30,null,null,"2022-05-31",22,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-05-31",22,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-07-01",2197,null,null,null,null,7,31,null,null,"2022-06-30",{"$f":"AC25+1","v":23},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-06-30",23,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-12-01",2270,null,null,null,null,8,31,null,null,"2022-07-31",{"$f":"AC26+1","v":24},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-07-31",24,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9,30,null,null,"2022-08-31",{"$f":"AC27+1","v":25},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-08-31",25,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI28+AW28+AX28","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$3,$E$2*0.9*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$3,(AE90-SUM(AE4:AE27))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10,31,null,null,"2022-09-30",26,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-09-30",26,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11,30,null,null,"2022-10-31",27,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-10-31",27,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12,31,null,null,"2022-11-30",28,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-11-30",28,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ставка","Комісія","Каско","Витрати оцінювача",null,null,null,null,null,null,"2022-12-31",29,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2022-12-31",29,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"P42","v":0},0,7.12,750,null,null,null,null,null,null,"2023-01-31",30,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-01-31",30,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-02-28",31,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-02-28",31,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-03-31",32,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-03-31",32,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Вік транспортного засобу",null,"Період перебування транспортного засобу у власності особи, яка передає його в заставу Банку",null,null,null,null,null,null,null,null,null,null,"2023-04-30",33,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-04-30",33,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O38:O41)","v":0},0,"до 1 міс. вкл.","1-6 міс. вкл.","більше 6 міс. вкл.",null,null,null,null,null,null,null,null,"2023-05-31",34,null,{"$f":"IF($AE$4=0,PPMT($E$14/1200,AC36,$E$8,-$N$2),PPMT($E$14/1200,AC37,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($AE$4=0,IPMT($E$14/1200,AC36,$E$8,-$N$2),IPMT($E$14/1200,AC37,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,"2023-05-31",34,null,{"$f":"$N$2/$E$8","v":{"$error":"#DIV/0!"}},null,{"$f":"AT37*$E$14/100*(AK37-AK36)/360","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($E$6=Q37,OR($E$12=12,$E$12=0)),Q38,\nIF(AND($E$6=R37,OR($E$12=0,$E$12=12)),R38,\nIF(AND($E$6=S37,OR($E$12=0,$E$12=12)),S38,0)))","v":0},"До 1року",0.8,0.8,0.8,null,null,null,null,null,null,null,null,"2023-06-30",35,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-06-30",35,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($E$6=$Q$37,OR($E$12=24,$E$12=36)),Q39,\nIF(AND($E$6=$R$37,OR($E$12=24,$E$12=36)),R39,\nIF(AND($E$6=$S$37,OR($E$12=24,$E$12=36)),S39,0)))","v":0},"1-3 роки вкл.",0.8,0.7,0.65,null,null,null,null,null,null,null,null,"2023-07-31",36,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-07-31",36,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,"Нотаріальні послуги:",null,null,null,{"$f":"IF(AND($E$6=$Q$37,OR($E$12=48,$E$12=60,$E$12=72,$E$12=84)),Q40,\nIF(AND($E$6=$R$37,OR($E$12=48,$E$12=60,$E$12=72,$E$12=84)),R40,\nIF(AND($E$6=$S$37,OR($E$12=48,$E$12=60,$E$12=72,$E$12=84)),S40,0)))","v":0},"3-7 років вкл.",0.8,0.6,0.55000000000000004,null,null,null,null,null,null,null,null,"2023-08-31",37,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-08-31",37,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI40+AW40+AX40","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$4,$E$2*0.9*0.9*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$4,(AE90-SUM(AE4:AE39))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND($E$6=$Q$37,$E$12>84),Q41,\nIF(AND($E$6=$R$37,$E$12>84),R41,\nIF(AND($E$6=$S$37,$E$12>84),S41,0)))","v":0},"більше 7 років",0.8,0.55000000000000004,0.5,null,null,null,null,null,null,null,null,"2023-09-30",38,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-09-30",38,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P44)","v":0},null,null,null,null,null,null,null,null,0,null,null,"2023-10-31",39,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-10-31",39,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Авансовий платіж","Ставка","Продукти:",12,24,36,48,60,72,84,"Видача кредиту, комісія",null,null,{"$f":"IF(AC43=\"\",\"\",DATE(YEAR(AB42),MONTH(AB42)+2,DAY(1)-1))","v":"2023-11-30"},{"$f":"AC42+1","v":40},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-11-30",40,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF($G$2=Q44,IF(AND($G$2=Q44,$U$23<10),\"Авансовий платіж має бути не менше 10%\",IF(AND($G$2=Q44,$U$23>19.99),\"Авансовий платіж має бути менше 20%\",\"Авансовий платіж достатній\")),\"\")","v":""},{"$f":"IF($E$8=$R$43,R44,\nIF($E$8=$S$43,S44,\nIF($E$8=$T$43,T44,\nIF($E$8=$U$43,U44,\nIF($E$8=$V$43,V44,\"\")))))","v":""},"Під заставу ТЗ",17.489999999999998,16.489999999999998,15.49,14.49,13.49,null,null,0,null,null,"2023-12-31",41,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2023-12-31",41,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2024-01-31",42,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-01-31",42,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2005,null,null,null,null,null,null,null,null,null,null,null,null,"2024-02-29",43,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-02-29",43,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2006,null,null,null,null,null,null,null,null,null,null,null,null,"2024-03-31",44,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-03-31",44,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,null,null,null,null,null,null,null,null,null,null,null,null,"2024-04-30",45,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-04-30",45,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,null,null,null,null,null,null,null,null,null,null,null,null,"2024-05-31",46,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-05-31",46,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,null,null,null,null,null,null,null,null,null,null,null,null,"2024-06-30",47,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-06-30",47,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,"ВСЬОГО ВИТРАТ",null,null,null,2010,null,null,null,null,null,null,null,null,null,null,null,null,"2024-07-31",48,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-07-31",48,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,null,null,null,null,null,null,null,null,null,null,null,null,"2024-08-31",49,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-08-31",49,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI52+AW52+AX52","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$5,$E$2*0.9*0.9*0.9*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$5,(AE90-SUM(AE4:AE51))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,null,null,null,null,null,null,null,null,null,null,null,null,"2024-09-30",50,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-09-30",50,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,null,null,null,null,null,null,null,null,null,null,null,null,"2024-10-31",51,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-10-31",51,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,null,null,null,null,null,null,null,null,null,null,null,null,"2024-11-30",52,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-11-30",52,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,null,null,null,null,null,null,null,null,null,null,null,null,"2024-12-31",53,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2024-12-31",53,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,null,null,null,null,null,null,null,null,null,null,null,null,"2025-01-31",54,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-01-31",54,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,null,null,null,null,null,null,null,null,null,null,null,null,"2025-02-28",55,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-02-28",55,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,null,null,null,null,null,null,null,null,null,null,null,null,"2025-03-31",56,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-03-31",56,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,null,null,null,null,null,null,null,null,null,null,null,null,"2025-04-30",57,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-04-30",57,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,null,null,null,null,null,null,null,null,null,null,null,null,"2025-05-31",58,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-05-31",58,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-06-30",59,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-06-30",59,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-07-31",60,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-07-31",60,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-08-31",61,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-08-31",61,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI64+AW64+AX64","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$6,$E$2*0.9*0.9*0.9*0.9*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$6,(AE90-SUM(AE4:AE63))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-09-30",62,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-09-30",62,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-10-31",63,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-10-31",63,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-11-30",64,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-11-30",64,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2025-12-31",65,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2025-12-31",65,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AC69=\"\",\"\",DATE(YEAR(AB68),MONTH(AB68)+2,DAY(1)-1))","v":"2026-01-31"},66,null,{"$f":"IF($AE$4=0,PPMT($E$14/1200,AC68,$E$8,-$N$2),PPMT($E$14/1200,AC69,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($AE$4=0,IPMT($E$14/1200,AC68,$E$8,-$N$2),IPMT($E$14/1200,AC69,$E$8,-$N$2))","v":{"$error":"#VALUE!"}},null,{"$error":"#VALUE!"},null,{"$f":"IF(AL69=\"\",\"\",DATE(YEAR(AK68),MONTH(AK68)+2,DAY(1)-1))","v":"2026-01-31"},66,null,{"$f":"$N$2/$E$8","v":{"$error":"#DIV/0!"}},null,{"$f":"AT69*$E$14/100*(AK69-AK68)/360","v":{"$error":"#DIV/0!"}},null,{"$f":"AN69+AP69","v":{"$error":"#DIV/0!"}},null,{"$error":"#DIV/0!"},{"$f":"AI69","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-02-28",67,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$f":"AG70+AE70","v":{"$error":"#VALUE!"}},null,"2026-02-28",67,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$f":"AT69-AN69","v":{"$error":"#DIV/0!"}},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-03-31",68,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-03-31",68,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-04-30",69,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-04-30",69,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-05-31",70,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-05-31",70,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-06-30",71,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-06-30",71,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-07-31",72,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-07-31",72,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-08-31",73,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-08-31",73,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$f":"AI76+AW76+AX76","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8>$R$7,$E$2*0.9*0.9*0.9*0.9*0.9*0.9*5.5%,\"\")","v":""},{"$f":"IF($E$8>$R$7,(AE90-SUM(AE4:AE75))*0.0299,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-09-30",74,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-09-30",74,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-10-31",75,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-10-31",75,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-11-30",{"$f":"AC78+1","v":76},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-11-30",76,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2026-12-31",{"$f":"AC79+1","v":77},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2026-12-31",77,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-01-31",78,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-01-31",78,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-02-28",79,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-02-28",79,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-03-31",80,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-03-31",80,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-04-30",81,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-04-30",81,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-05-31",82,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-05-31",82,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-06-30",83,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-06-30",83,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-07-31",{"$f":"AC86+1","v":84},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-07-31",84,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-08-31",85,null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,"2027-08-31",85,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-09-30",{"$f":"AC88+1","v":86},null,{"$error":"#VALUE!"},null,{"$error":"#VALUE!"},null,{"$f":"AG89+AE89","v":{"$error":"#VALUE!"}},null,"2027-09-30",86,null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},null,{"$error":"#DIV/0!"},{"$error":"#VALUE!"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2027-10-31","Всього",null,{"$f":"IF($E$8=$R$2,SUM(AE4:AF15),IF($E$8=$R$3,SUM(AE4:AF27),IF($E$8=$R$4,SUM(AE4:AF39),IF($E$8=$R$5,SUM(AE4:AF51),IF($E$8=$R$6,SUM(AE4:AF63),IF($E$8=$R$7,SUM(AE4:AF75),IF($E$8=$R$8,SUM(AE4:AF87))))))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8=$R$2,SUM(AG4:AH15),IF($E$8=$R$3,SUM(AG4:AH27),IF($E$8=$R$4,SUM(AG4:AH39),IF($E$8=$R$5,SUM(AG4:AH51),IF($E$8=$R$6,SUM(AG4:AH63),IF($E$8=$R$7,SUM(AG4:AH75),IF($E$8=$R$8,SUM(AG4:AH87))))))))","v":{"$error":"#VALUE!"}},null,{"$f":"IF($E$8=$R$2,SUM(AI4:AJ15),IF($E$8=$R$3,SUM(AI4:AJ27),IF($E$8=$R$4,SUM(AI4:AJ39),IF($E$8=$R$5,SUM(AI4:AJ51),IF($E$8=$R$6,SUM(AI4:AJ63),IF($E$8=$R$7,SUM(AI4:AJ75),IF($E$8=$R$8,SUM(AI4:AJ87))))))))","v":{"$error":"#VALUE!"}},null,null,"Всього",null,{"$f":"SUM(AN4:AN89)","v":{"$error":"#DIV/0!"}},null,{"$f":"SUM(AP4:AQ88)","v":{"$error":"#VALUE!"}},null,{"$f":"SUM(AR4:AS89)","v":{"$error":"#VALUE!"}},null,null,{"$error":"#VALUE!"}]