{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Вид 1","Вид 2","Вид 3","Заказ"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Вид 1","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["№","Артикул","Наименование","Цена","Заказ"]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA17","Товар 1",100.15]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA18","Товар 2",111.18]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA19","Товар 3",90.16]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA20","Товар 4",20.170000000000002]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA21","Товар 5",18.18]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA22","Товар 6",20.100000000000001]
[{"$f":"IF(Вид1[[#This Row],[Заказ]],COUNTIF(Вид1[[#Headers],[Заказ]]:Вид1[[#This Row],[Заказ]],\">0\"),\"\")","v":""},"NA23","Товар 7",29.98]

{"sheet":"Вид 2","index":1,"n_rows":6,"n_cols":6,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["№","Изображение","Артикул","Наименование","Цена","Заказ"]
[{"$f":"IF(Вид2[[#This Row],[Заказ]],COUNTIF(Вид2[[#Headers],[Заказ]]:Вид2[[#This Row],[Заказ]],\">0\")+MAX('Вид 1'!A:A),\"\")","v":""},"pic1","SA101","Товар 21",200.18]
[{"$f":"IF(Вид2[[#This Row],[Заказ]],COUNTIF(Вид2[[#Headers],[Заказ]]:Вид2[[#This Row],[Заказ]],\">0\")+MAX('Вид 1'!A:A),\"\")","v":""},"pic2","SA102","Товар 22",220.12]
[{"$f":"IF(Вид2[[#This Row],[Заказ]],COUNTIF(Вид2[[#Headers],[Заказ]]:Вид2[[#This Row],[Заказ]],\">0\")+MAX('Вид 1'!A:A),\"\")","v":1},"pic3","SA103","Товар 23",180.17,10]
[{"$f":"IF(Вид2[[#This Row],[Заказ]],COUNTIF(Вид2[[#Headers],[Заказ]]:Вид2[[#This Row],[Заказ]],\">0\")+MAX('Вид 1'!A:A),\"\")","v":""},"pic4","SA104","Товар 24",100.87]
[{"$f":"IF(Вид2[[#This Row],[Заказ]],COUNTIF(Вид2[[#Headers],[Заказ]]:Вид2[[#This Row],[Заказ]],\">0\")+MAX('Вид 1'!A:A),\"\")","v":2},"pic5","SA105","Товар 25",95.22,21]

{"sheet":"Вид 3","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["№","ПН","Изображение","Артикул","Наименование","Цена","Заказ"]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic10","KF1008","Товар 80",1005.17]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic11","KF1009","Товар 81",1025.17]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic12","KF1010","Товар 82",1335.17]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic13","KF1011","Товар 83",1045.17]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic14","KF1012","Товар 84",1105.17]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":3},"КН","pic15","KF1013","Товар 85",1235.17,15]
[{"$f":"IF(Вид3[[#This Row],[Заказ]],COUNTIF(Вид3[[#Headers],[Заказ]]:Вид3[[#This Row],[Заказ]],\">0\")+MAX('Вид 2'!A:A),\"\")","v":""},"КН","pic16","KF1014","Товар 86",1205.17]

{"sheet":"Заказ","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,0,0,1],[1,0,1,1],[2,0,2,1]]}
["Заказчик"]
["Скидка",null,0.01]
["Дата заказа"]
["Дата поставки"]
[]
["№ п/п","Артикул","Наименование","Кол-во","Стоимость","Стоимость со скидкой",null,"Итого:",{"$f":"Заказы[[#Totals],[Кол-во]]","v":46}]
[1,"SA103","Товар 23",10,1801.6999999999998,1783.6829999999998,null,"Стоимость:",{"$f":"Заказы[[#Totals],[Стоимость]]","v":22328.870000000003}]
[2,"SA105","Товар 25",21,1999.62,1979.6237999999998,null,"Стоимость со скидкой:",{"$f":"Заказы[[#Totals],[Стоимость со скидкой]]","v":22105.581300000002}]
[3,"KF1013","Товар 85",15,18527.550000000003,18342.274500000003]
["Итого:",{"$f":"IFERROR(SUMPRODUCT(1/COUNTIF(Заказы[Артикул],Заказы[Артикул])),\"\")","v":3},{"$f":"IFERROR(SUMPRODUCT(1/COUNTIF(Заказы[Наименование],Заказы[Наименование])),\"\")","v":3},{"$f":"SUBTOTAL(109,Заказы[Кол-во])","v":46},{"$f":"SUBTOTAL(109,Заказы[Стоимость])","v":22328.870000000003},{"$f":"SUBTOTAL(109,Заказы[Стоимость со скидкой])","v":22105.581300000002}]