{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Контрагенти","Платежі","Договори","Звіт"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ЗВІТ ПРО РОЗРАХУНКИ - станом на 12.11.2016",null,null,"Заголовок 1"]
["ЧП \"Дождик\"",null,null,"Стиль заголовка"]
["ООО \"Радуга\"",null,null,"Стиль примечания"]

{"sheet":"Платежі","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":true,"merged":[]}
["Ключ","НомерДог","ДатаДог","Контрагент","Товар","План-факт","Дата оплати","Сума оплати",null,"=СУММЕСЛИМН([Сума оплати];[Ключ];[@Ключ];[План-факт];\"План\";[Дата оплати];\"<\"&СЕГОДНЯ())-СУММЕСЛИМН([Сума оплати];[Ключ];[@Ключ];[План-факт];\"Факт\")"]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","План","2016-07-06",762725.3]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-03",362725.3]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","План","2016-07-14",1900000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-04",200000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","План","2016-07-20",1900000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-05",200000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-09",400000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-10",400000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-12",800000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-13",300000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-16",400000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-17",400000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-19",500000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-20",200000]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1","Факт","2016-07-23",200000]
["103/НГ (30.06.2016)","103/НГ","2016-06-30","ООО \"Радуга\"","Товар2","План","2016-07-20",363330.71]
["103/НГ (30.06.2016)","103/НГ","2016-06-30","ООО \"Радуга\"","Товар2","Факт","2016-07-19",400000]
["103/НГ (30.06.2016)","103/НГ","2016-06-30","ООО \"Радуга\"","Товар2","План","2016-08-01",847771.64]

{"sheet":"Договори","index":2,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Ключ","НомерДог","ДатаДог","Контрагент","Товар","Обсяг","Ціна з ПДВ","Сума з ПДВ","Заборгованість","Ресурс","ПСГ","Прострочена заборгованість",null,"=ОКРУГЛ(СУММЕСЛИМН(Payments[Сума оплати];Payments[Ключ];[@Ключ];Payments[План-факт];\"План\";Payments[Дата оплати];\"<\"&СЕГОДНЯ());2)-ОКРУГЛ(СУММЕСЛИМН(Payments[Сума оплати];Payments[Ключ];[@Ключ];Payments[План-факт];\"Факт\");2)"]
["25/06 (25.06.2016)","25/06","2016-06-25","ЧП \"Дождик\"","Товар1",1440,3168.5592361111112,{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\"),2)","v":4562725.3},{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\"),2)-ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"Факт\"),2)","v":200000},{"$f":"IF(Договори[[#This Row],[Товар]]=\"Товар1\",VLOOKUP(Договори[[#This Row],[Ключ]],#REF!,7,0),\"\")","v":{"$error":"#REF!"}},{"$f":"IFERROR(IF(VLOOKUP(Договори[[#This Row],[Ключ]],#REF!,8,0)=0,\"\",\"ПСГ\"),\"\")","v":""},{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\",Платежі[Дата оплати],\"<\"&TODAY()),2)-ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"Факт\"),2)","v":200000}]
["103/НГ (30.06.2016)","103/НГ","2016-06-30","ООО \"Радуга\"","Товар2",300,4037.0078333333336,{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\"),2)","v":1211102.3500000001},{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\"),2)-ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"Факт\"),2)","v":811102.35000000009},{"$f":"IF(Договори[[#This Row],[Товар]]=\"Товар1\",VLOOKUP(Договори[[#This Row],[Ключ]],#REF!,7,0),\"\")","v":""},{"$f":"IFERROR(IF(VLOOKUP(Договори[[#This Row],[Ключ]],#REF!,8,0)=0,\"\",\"ПСГ\"),\"\")","v":""},{"$f":"ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"План\",Платежі[Дата оплати],\"<\"&TODAY()),2)-ROUND(SUMIFS(Платежі[Сума оплати],Платежі[Ключ],Договори[[#This Row],[Ключ]],Платежі[План-факт],\"Факт\"),2)","v":811102.35000000009}]

{"sheet":"Звіт","index":3,"n_rows":19,"n_cols":7,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["ЗВІТ ПРО РОЗРАХУНКИ - станом на 13.11.2016"]
[]
["25/06 (25.06.2016)","ЧП \"Дождик\""]
["Товар1",null,"Планова дата","Планова сума","Дата сплати","Фактична сума","Заборгованість"]
["Ресурс #ССЫЛКА!","",null,null,"2016-07-03",362725.3,{"$f":"D5-F5","v":-362725.3}]
["Обсяг, тис.м3:",1440,null,null,"2016-07-04",200000,{"$f":"G5+D6-F6","v":-562725.30000000005}]
["Ціна (з ПДВ), грн/тис.м3:",3168.5592361111112,null,null,"2016-07-05",200000,{"$f":"G6+D7-F7","v":-762725.3}]
["Сума (з ПДВ), грн:",4562725.3,"2016-07-06",762725.3,null,null,{"$f":"G7+D8-F8","v":0}]
["Поточна заборгованість, грн:",200000,null,null,"2016-07-09",400000,{"$f":"G8+D9-F9","v":-400000}]
["Дні прострочки:",null,null,null,"2016-07-10",400000,{"$f":"G9+D10-F10","v":-800000}]
[null,null,null,null,"2016-07-12",800000,{"$f":"G10+D11-F11","v":-1600000}]
[null,null,null,null,"2016-07-13",300000,{"$f":"G11+D12-F12","v":-1900000}]
[null,null,"2016-07-14",1900000,null,null,{"$f":"G12+D13-F13","v":0}]
[null,null,null,null,"2016-07-16",400000,{"$f":"G13+D14-F14","v":-400000}]
[null,null,null,null,"2016-07-17",400000,{"$f":"G14+D15-F15","v":-800000}]
[null,null,null,null,"2016-07-19",500000,{"$f":"G15+D16-F16","v":-1300000}]
[null,null,"2016-07-20",1900000,"2016-07-20",200000,{"$f":"G16+D17-F17","v":400000}]
[null,null,null,null,"2016-07-23",200000,{"$f":"G17+D18-F18","v":200000}]
[null,null,{"$f":"IF(MAX(C$5:C18)=0,\"\",MAX(C$5:C18))","v":"2016-07-20"},{"$f":"SUM(D$5:D18)","v":4562725.3},{"$f":"IF(MAX(E$5:E18)=0,\"\",MAX(E$5:E18))","v":"2016-07-23"},{"$f":"SUM(F$5:F18)","v":4362725.3},{"$f":"D19-F19","v":200000}]