{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Справочник","Сводная","Продажи","Форма ввода","Счет"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":1},"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":30,"n_cols":8,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["Наименование","Категория","Цена",null,null,"Клиент","Город","Регион"]
["Персик","Фрукты",150,null,null,"Дубинин","Москва","Центр"]
["Лук","Овощи",19,null,null,"Иванов","Брянск","Центр"]
["Нектарин","Фрукты",90,null,null,"Александров","Самара","Центр"]
["Картофель","Овощи",28,null,null,"Кузнецов","Калуга","Центр"]
["Грейпфрут","Фрукты",70,null,null,"Пушкин","Рязань","Центр"]
["Морковь","Овощи",52,null,null,"Васькин","Ульяновск","Центр"]
["Баклажан","Овощи",55,null,null,"Бурлаков","Ярославль","Центр"]
["Салат","Овощи",45,null,null,"Вертолеткин","Архангельск","Север"]
["Киви","Фрукты",200,null,null,"Гаспарян","Вологда","Север"]
["Капуста","Овощи",63,null,null,"Ежов","Санкт-Петербург","Север"]
["Манго","Фрукты",26,null,null,"Истуканов","Мурманск","Север"]
["Мандарины","Фрукты",81,null,null,"Леонидов","Новгород","Север"]
["Банан","Фрукты",54,null,null,"Машков","Иркутск","Восток"]
["Малина","Ягоды",17,null,null,"Опупейкин","Кемерово","Восток"]
["Абрикос","Фрукты",98,null,null,"Ростовцев","Новосибирск","Восток"]
["Груши","Фрукты",96,null,null,"Стукало","Омск","Восток"]
["Огурец","Овощи",50,null,null,"Тимберленов","Владивосток","Восток"]
["Перец","Овощи",35,null,null,"Уфимцев","Чита","Восток"]
["Ежевика","Ягоды",180,null,null,"Феофанов","Красноярск","Восток"]
["Крыжовник","Овощи",14,null,null,"Хорошеев","Курган","Восток"]
["Ананас","Фрукты",54,null,null,"Цыбулин","Свердловск","Восток"]
["Смородина","Ягоды",64,null,null,"Щипачихин","Тюмень","Восток"]
["Клубника","Ягоды",67,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,"Тарасов","Владикавказ","Юг"]

{"sheet":"Сводная","index":1,"n_rows":14,"n_cols":5,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Сумма по столбцу Стоимость","Названия столбцов"]
["Названия строк","Восток","Север","Центр","Общий итог"]
["Овощи",43379,4396,null,47775]
["Картофель",14784,4396,null,19180]
["Лук",11666,null,null,11666]
["Морковь",13104,null,null,13104]
["Салат",3825,null,null,3825]
["Фрукты",90380,31320,7920,129620]
["Грейпфрут",10430,null,null,10430]
["Нектарин",null,31320,7920,39240]
["Персик",79950,null,null,79950]
["Общий итог",133759,35716,7920,177395]

{"sheet":"Продажи","index":2,"n_rows":62,"n_cols":5,"rows_kept":62,"cut":false,"hidden":false,"merged":[]}
["Дата","Товар","Кол-во","Стоимость","Клиент"]
["2016-09-05T15:36:22.183","Картофель",3,84,"Ежов"]
["2016-09-04T20:33:18.842","Нектарин",28,2520,"Истуканов"]
["2016-09-01T00:16:52.492","Нектарин",18,1620,"Леонидов"]
["2016-09-02T21:37:07.014","Лук",94,1786,"Машков"]
["2016-09-02T09:44:00.265","Персик",96,14400,"Опупейкин"]
["2016-09-02T03:27:16.931","Лук",3,57,"Ростовцев"]
["2016-09-03T16:21:56.980","Морковь",59,3068,"Стукало"]
["2016-09-01T08:42:11.936","Картофель",0,0,"Тимберленов"]
["2016-09-05T17:31:14.290","Картофель",16,448,"Уфимцев"]
["2016-09-02T01:51:02.704","Грейпфрут",37,2590,"Феофанов"]
["2016-09-04T12:22:09.258","Лук",89,1691,"Хорошеев"]
["2016-09-03T17:00:28.350","Салат",35,1575,"Машков"]
["2016-09-03T23:41:09.538","Картофель",65,1820,"Опупейкин"]
["2016-09-03T14:53:03.628","Персик",64,9600,"Машков"]
["2016-09-08T11:20:18.510","Нектарин",17,1530,"Дубинин"]
["2016-09-05T15:36:22.183","Картофель",55,1540,"Ежов"]
["2016-09-04T20:33:18.842","Нектарин",21,1890,"Истуканов"]
["2016-09-01T00:16:52.492","Нектарин",74,6660,"Леонидов"]
["2016-09-02T21:37:07.014","Лук",75,1425,"Машков"]
["2016-09-02T09:44:00.265","Персик",43,6450,"Опупейкин"]
["2016-09-02T03:27:16.931","Лук",92,1748,"Ростовцев"]
["2016-09-03T16:21:56.980","Морковь",81,4212,"Стукало"]
["2016-09-01T08:42:11.936","Картофель",29,812,"Тимберленов"]
["2016-09-05T17:31:14.290","Картофель",86,2408,"Уфимцев"]
["2016-09-02T01:51:02.704","Грейпфрут",78,5460,"Феофанов"]
["2016-09-04T12:22:09.258","Лук",8,152,"Хорошеев"]
["2016-09-03T17:00:28.350","Салат",9,405,"Машков"]
["2016-09-03T23:41:09.538","Картофель",69,1932,"Опупейкин"]
["2016-09-03T14:53:03.628","Персик",73,10950,"Машков"]
["2016-09-08T11:20:18.510","Нектарин",9,810,"Дубинин"]
["2016-09-05T15:36:22.183","Картофель",73,2044,"Ежов"]
["2016-09-04T20:33:18.842","Нектарин",10,900,"Истуканов"]
["2016-09-01T00:16:52.492","Нектарин",83,7470,"Леонидов"]
["2016-09-02T21:37:07.014","Лук",98,1862,"Машков"]
["2016-09-02T09:44:00.265","Персик",78,11700,"Опупейкин"]
["2016-09-02T03:27:16.931","Лук",8,152,"Ростовцев"]
["2016-09-03T16:21:56.980","Морковь",71,3692,"Стукало"]
["2016-09-01T08:42:11.936","Картофель",17,476,"Тимберленов"]
["2016-09-05T17:31:14.290","Картофель",1,28,"Уфимцев"]
["2016-09-02T01:51:02.704","Грейпфрут",18,1260,"Феофанов"]
["2016-09-04T12:22:09.258","Лук",25,475,"Хорошеев"]
["2016-09-03T17:00:28.350","Салат",28,1260,"Машков"]
["2016-09-03T23:41:09.538","Картофель",66,1848,"Опупейкин"]
["2016-09-03T14:53:03.628","Персик",54,8100,"Машков"]
["2016-09-08T11:20:18.510","Нектарин",60,5400,"Дубинин"]
["2016-09-05T15:36:22.183","Картофель",26,728,"Ежов"]
["2016-09-04T20:33:18.842","Нектарин",98,8820,"Истуканов"]
["2016-09-01T00:16:52.492","Нектарин",16,1440,"Леонидов"]
["2016-09-02T21:37:07.014","Лук",30,570,"Машков"]
["2016-09-02T09:44:00.265","Персик",72,10800,"Опупейкин"]
["2016-09-02T03:27:16.931","Лук",10,190,"Ростовцев"]
["2016-09-03T16:21:56.980","Морковь",41,2132,"Стукало"]
["2016-09-01T08:42:11.936","Картофель",80,2240,"Тимберленов"]
["2016-09-05T17:31:14.290","Картофель",67,1876,"Уфимцев"]
["2016-09-02T01:51:02.704","Грейпфрут",16,1120,"Феофанов"]
["2016-09-04T12:22:09.258","Лук",82,1558,"Хорошеев"]
["2016-09-03T17:00:28.350","Салат",13,585,"Машков"]
["2016-09-03T23:41:09.538","Картофель",32,896,"Опупейкин"]
["2016-09-03T14:53:03.628","Персик",53,7950,"Машков"]
["2016-09-08T11:20:18.510","Нектарин",2,180,"Дубинин"]
["2016-09-09T15:06:45.580","Нектарин",3,270]

{"sheet":"Форма ввода","index":3,"n_rows":20,"n_cols":5,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["Форма ввода данных о продажах"]
[]
["Дата",{"$f":"NOW()","v":"2016-09-09T15:07:39.480"}]
[]
["Клиент","Иванов"]
[]
["Товар","Картофель"]
[]
["Количество",23]
[]
["Цена",{"$f":"VLOOKUP(B7,Прайс[],3,0)","v":28}]
[]
["Стоимость",{"$f":"B11*B9","v":644}]
[]
[]
[]
[]
[]
[]
[{"$f":"B3","v":"2016-09-09T15:07:39.480"},{"$f":"B7","v":"Картофель"},{"$f":"B9","v":23},{"$f":"B13","v":644},{"$f":"B5","v":"Иванов"}]

{"sheet":"Счет","index":4,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[9,1,9,2],[10,1,10,2],[7,2,7,3],[5,2,5,3],[3,2,3,3]]}
[]
[null,"Счет №",3,"от",{"$f":"TODAY()","v":"2016-09-09"}]
[]
[null,"Заказчик:",{"$f":"INDEX(Продажи[Клиент],C2)","v":"Леонидов"}]
[]
[null,"Город:",{"$f":"VLOOKUP(C4,Клиенты[],2,0)","v":"Новгород"}]
[]
[null,"Регион",{"$f":"VLOOKUP(C4,Клиенты[],3,0)","v":"Север"}]
[]
[null,"Наименование",null,"Кол-во, кг","Стоимость, руб"]
[null,{"$f":"INDEX(Продажи[Товар],C2)","v":"Нектарин"},null,{"$f":"INDEX(Продажи[Кол-во],C2)","v":18},{"$f":"INDEX(Продажи[Стоимость],C2)","v":1620}]