{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["2022"],"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":"2022","index":0,"n_rows":14,"n_cols":19,"rows_kept":14,"cut":false,"hidden":false,"merged":[[7,18,9,18],[0,16,1,16],[0,8,0,9],[0,10,0,11],[0,12,1,12],[0,13,1,13],[0,14,1,14],[0,15,1,15],[0,0,1,0],[0,1,1,1],[0,2,1,2],[0,3,1,3],[0,4,0,5],[0,6,0,7],[2,1,4,1],[2,2,4,2],[2,3,4,3],[2,4,4,4],[2,5,4,5],[2,6,4,6],[2,7,4,7],[2,8,4,8],[2,9,4,9],[2,10,4,10],[2,11,4,11],[2,12,4,12],[2,16,4,16],[7,1,9,1],[7,2,9,2],[7,3,9,3],[7,4,9,4],[7,5,9,5],[7,6,9,6],[7,7,9,7],[7,8,9,8],[7,9,9,9],[7,10,9,10],[7,11,9,11],[7,12,9,12],[7,16,9,16],[2,13,4,13],[7,13,9,13]]}
["№ счета \nАнт-Снаб","Дата \nдоставки","Перевозчик","Стоимость","Счет перевозчика",null,"Оплата",null,"Акт",null,"Счет-фактура\nили УПД",null,"Маршрут","Расходы в 1с","Комментарий","Сэкономленно","Проверено"]
[null,null,null,null,"№","дата","п/п","дата","№","дата","№","дата"]
[3341,"2022-08-08","ООО \"Яндекс.Доставка\"",2692.8,"ОПЛ-1",null,null,null,null,null,null,null,null,4200,null,{"$f":"IF(N3<>\"\",N3/IFERROR(MyMergeCount(N3),1),N3)-(IF(ISNUMBER(A3),(IF(IF(E3<>\"\",E3,#REF!)>1,IF(D3<>\"\",D3,#REF!)*1/IFERROR(MyMergeCount(D3),1),IF(D3<>\"\",D3,#REF!)*1.2/IFERROR(MyMergeCount(D3),1))),IF(D3<>\"\",D3,#REF!)*1/IFERROR(MyMergeCount(D3),1)))","v":502.4},"✓","Вот тут сейчас корректно"]
[3314,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N4<>\"\",N4/IFERROR(MyMergeCount(N4),1),N4)-(IF(ISNUMBER(A4),(IF(IF(E4<>\"\",E4,P3)>1,IF(D4<>\"\",D4,P3)*1/IFERROR(MyMergeCount(D4),1),IF(D4<>\"\",D4,P3)*1.2/IFERROR(MyMergeCount(D4),1))),IF(D4<>\"\",D4,P3)*1/IFERROR(MyMergeCount(D4),1)))","v":-167.46666666666667},null,"А вот тут почему то 310, хотя должно быть 502"]
[3333,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N5<>\"\",N5/IFERROR(MyMergeCount(N5),1),N5)-(IF(ISNUMBER(A5),(IF(IF(E5<>\"\",E5,P4)>1,IF(D5<>\"\",D5,P4)*1/IFERROR(MyMergeCount(D5),1),IF(D5<>\"\",D5,P4)*1.2/IFERROR(MyMergeCount(D5),1))),IF(D5<>\"\",D5,P4)*1/IFERROR(MyMergeCount(D5),1)))","v":66.986666666666665},null,"А вот тут вообще 181, хотя тоже додно быть 502"]
["уу555","2022-09-26","Андрей (Юду)",500,null,null,null,null,null,null,null,null,null,1100,null,{"$f":"IF(N6<>\"\",N6/IFERROR(MyMergeCount(N6),1),N6)-(IF(ISNUMBER(A6),(IF(IF(E6<>\"\",E6,P5)>1,IF(D6<>\"\",D6,P5)*1/IFERROR(MyMergeCount(D6),1),IF(D6<>\"\",D6,P5)*1.2/IFERROR(MyMergeCount(D6),1))),IF(D6<>\"\",D6,P5)*1/IFERROR(MyMergeCount(D6),1)))","v":600},"✓","Вот тут корректно"]
["Склад","2022-09-27","Иван",3000,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(N7<>\"\",N7/IFERROR(MyMergeCount(N7),1),N7)-(IF(ISNUMBER(A7),(IF(IF(E7<>\"\",E7,P6)>1,IF(D7<>\"\",D7,P6)*1/IFERROR(MyMergeCount(D7),1),IF(D7<>\"\",D7,P6)*1.2/IFERROR(MyMergeCount(D7),1))),IF(D7<>\"\",D7,P6)*1/IFERROR(MyMergeCount(D7),1)))","v":-3000},"✓","Вот тут нужно сделать *1.2 (Если склад, и №счета перевозчика отсутствует)"]
[3341,"2022-08-08","ООО \"Яндекс.Доставка\"",2692.8,"ОПЛ-1",null,null,null,null,null,null,null,null,4200,null,{"$f":"IF(N8<>\"\",N8/IFERROR(MyMergeCount(N8),1),N8)-(IF(ISNUMBER(A8),(IF(IF(E8<>\"\",E8,P7)>1,IF(D8<>\"\",D8,P7)*1/IFERROR(MyMergeCount(D8),1),IF(D8<>\"\",D8,P7)*1.2/IFERROR(MyMergeCount(D8),1))),IF(D8<>\"\",D8,P7)*1/IFERROR(MyMergeCount(D8),1)))","v":502.4},"✓",null,"Это дубль первых строк, просто перетянул"]
[3314,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N9<>\"\",N9/IFERROR(MyMergeCount(N9),1),N9)-(IF(ISNUMBER(A9),(IF(IF(E9<>\"\",E9,P8)>1,IF(D9<>\"\",D9,P8)*1/IFERROR(MyMergeCount(D9),1),IF(D9<>\"\",D9,P8)*1.2/IFERROR(MyMergeCount(D9),1))),IF(D9<>\"\",D9,P8)*1/IFERROR(MyMergeCount(D9),1)))","v":-167.46666666666667}]
[3333,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N10<>\"\",N10/IFERROR(MyMergeCount(N10),1),N10)-(IF(ISNUMBER(A10),(IF(IF(E10<>\"\",E10,P9)>1,IF(D10<>\"\",D10,P9)*1/IFERROR(MyMergeCount(D10),1),IF(D10<>\"\",D10,P9)*1.2/IFERROR(MyMergeCount(D10),1))),IF(D10<>\"\",D10,P9)*1/IFERROR(MyMergeCount(D10),1)))","v":66.986666666666665}]
["Склад","2022-10-06","Александр (Юду)",2500,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(N11<>\"\",N11/IFERROR(MyMergeCount(N11),1),N11)-(IF(ISNUMBER(A11),(IF(IF(E11<>\"\",E11,P10)>1,IF(D11<>\"\",D11,P10)*1/IFERROR(MyMergeCount(D11),1),IF(D11<>\"\",D11,P10)*1.2/IFERROR(MyMergeCount(D11),1))),IF(D11<>\"\",D11,P10)*1/IFERROR(MyMergeCount(D11),1)))","v":-2500},"✓","Вот тут нужно сделать *1.2 (Если склад, и №счета перевозчика отсутствует)"]
[4481,"2022-10-06","ООО \"Слияние\"",11176,"ОПЛ-1",null,null,null,null,null,null,null,null,12000,null,{"$f":"IF(N12<>\"\",N12/IFERROR(MyMergeCount(N12),1),N12)-(IF(ISNUMBER(A12),(IF(IF(E12<>\"\",E12,P11)>1,IF(D12<>\"\",D12,P11)*1/IFERROR(MyMergeCount(D12),1),IF(D12<>\"\",D12,P11)*1.2/IFERROR(MyMergeCount(D12),1))),IF(D12<>\"\",D12,P11)*1/IFERROR(MyMergeCount(D12),1)))","v":824},"✓","и тут корректно"]
["Склад","2022-10-07","Александр (Юду)",2500,null,null,null,null,null,null,null,null,null,0,null,{"$f":"IF(N13<>\"\",N13/IFERROR(MyMergeCount(N13),1),N13)-(IF(ISNUMBER(A13),(IF(IF(E13<>\"\",E13,P12)>1,IF(D13<>\"\",D13,P12)*1/IFERROR(MyMergeCount(D13),1),IF(D13<>\"\",D13,P12)*1.2/IFERROR(MyMergeCount(D13),1))),IF(D13<>\"\",D13,P12)*1/IFERROR(MyMergeCount(D13),1)))","v":-2500},"✓","Вот тут нужно сделать *1.2 (Если склад, и №счета перевозчика отсутствует)"]
[4388,"2022-10-28","ООО \"Яндекс.Доставка\"",1939.2,"ОПЛ-1",null,null,null,null,null,null,null,null,3600,null,{"$f":"IF(N14<>\"\",N14/IFERROR(MyMergeCount(N14),1),N14)-(IF(ISNUMBER(A14),(IF(IF(E14<>\"\",E14,P13)>1,IF(D14<>\"\",D14,P13)*1/IFERROR(MyMergeCount(D14),1),IF(D14<>\"\",D14,P13)*1.2/IFERROR(MyMergeCount(D14),1))),IF(D14<>\"\",D14,P13)*1/IFERROR(MyMergeCount(D14),1)))","v":1660.8},"✓","и тут корректно"]