{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Исходная таблица","Товарный чек","Лист3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":51,"n_cols":9,"rows_kept":51,"cut":false,"hidden":false,"merged":[[49,1,49,3],[49,4,49,5],[50,1,50,3],[50,4,50,5],[46,1,46,3],[46,4,46,5],[47,1,47,3],[47,4,47,5],[48,1,48,3],[48,4,48,5],[43,1,43,3],[43,4,43,5],[44,1,44,3],[44,4,44,5],[45,1,45,3],[45,4,45,5],[42,4,42,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[34,4,34,5],[35,4,35,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[39,4,39,5],[40,4,40,5],[41,4,41,5],[30,4,30,5],[19,4,19,5],[20,4,20,5],[21,4,21,5],[22,4,22,5],[23,4,23,5],[24,4,24,5],[25,4,25,5],[26,4,26,5],[27,4,27,5],[28,4,28,5],[29,4,29,5],[18,4,18,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[12,4,12,5],[13,4,13,5],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[42,1,42,3],[31,1,31,3],[32,1,32,3],[33,1,33,3],[34,1,34,3],[35,1,35,3],[36,1,36,3],[37,1,37,3],[38,1,38,3],[39,1,39,3],[40,1,40,3],[41,1,41,3],[30,1,30,3],[19,1,19,3],[20,1,20,3],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[25,1,25,3],[26,1,26,3],[27,1,27,3],[28,1,28,3],[29,1,29,3],[18,1,18,3],[7,1,7,3],[8,1,8,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[12,1,12,3],[13,1,13,3],[14,1,14,3],[15,1,15,3],[16,1,16,3],[17,1,17,3],[2,1,2,3],[2,4,2,5],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[3,4,3,5],[4,4,4,5],[5,4,5,5],[6,4,6,5]]}
["                                                                 Ценник"]
["                                                                Февраля",null,null,"Март"]
["              №","                 Наименование",null,null,"          Категория",null,"    Цена",null,"   Кол-во"]
[1,"Маргарита",null,null,"пицца 40",null,310]
[2,"Маргарита",null,null,"пицца 32",null,210]
[3,"Папперони",null,null,"пицца 40",null,500]
[4,"Папперони",null,null,"пицца 32",null,400]
[5,"Морская",null,null,"пицца 40",null,540]
[6,"Морская",null,null,"пицца 32",null,440]
[7,"Классика",null,null,"пицца 40",null,550]
[8,"Классика",null,null,"пицца 32",null,450]
[9,"Жульен",null,null,"пицца 40",null,520]
[10,"Жульен",null,null,"пицца 32",null,420]
[11,"Ветчина с грибами",null,null,"пицца 40",null,510]
[12,"Ветчина с грибами",null,null,"пицца 32",null,410]
[13,"Филадельфия",null,null,"классические роллы",null,230]
[14,"Калифорния",null,null,"классические роллы",null,230]
[15,"Канада",null,null,"классические роллы",null,230]
[16,"Красный дракон",null,null,"классические роллы",null,230]
[17,"Калифорния с лососем",null,null,"классические роллы",null,230]
[18,"Хонсю",null,null,"классические роллы",null,230]
[19,"Нежный",null,null,"классические роллы",null,230]
[20,"Харакири",null,null,"классические роллы",null,230]
[21,"Эби темпура",null,null,"классические роллы",null,230]
[22,"Пирамида",null,null,"классические роллы",null,230]
[23,"Аляска",null,null,"классические роллы",null,230]
[24,"Батакон",null,null,"классические роллы",null,230]
[25,"Сяке хот",null,null,"горячие роллы",null,250]
[26,"Эби с пармезаном",null,null,"горячие роллы",null,250]
[27,"Хотате",null,null,"горячие роллы",null,250]
[28,"Унаги хот",null,null,"горячие роллы",null,250]
[29,"Хоккайдо",null,null,"горячие роллы",null,250]
[30,"Фирменный \"ЕЩЁ\"",null,null,"фирмнный",null,250]
[31,"Острый с гребешком",null,null,"гунканы",null,80]
[32,"Острый с лососем",null,null,"гунканы",null,80]
[33,"Острый с креветкой",null,null,"гунканы",null,80]
[34,"Острый с угрем",null,null,"гунканы",null,80]
[35,"Острый с тунцом",null,null,"гунканы",null,80]
[36,"С красной икрой",null,null,"гунканы",null,80]
[37,"С икрой тобико",null,null,"гунканы",null,80]
[38,"С лососем",null,null,"мини маки",null,100]
[39,"С копч.лососем",null,null,"мини маки",null,100]
[40,"С креветкой",null,null,"мини маки",null,100]
[41,"С угрем",null,null,"мини маки",null,100]
[42,"С тунцом",null,null,"мини маки",null,100]
[43,"С огурцом",null,null,"мини маки",null,70]
[44,"С авокадо",null,null,"мини маки",null,70]
[45,"Спайс лосось",null,null,"острые мини маки",null,100]
[46,"Спайс угорь",null,null,"острые мини маки",null,100]
[47,"Спайс тунец",null,null,"острые мини маки",null,100]
[48,"Спайс креветка",null,null,"острые мини маки",null,100]

{"sheet":"Товарный чек","index":1,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[1,0,1,8],[27,0,27,8],[42,1,42,4],[39,4,39,5],[12,4,12,5],[13,4,13,5],[30,4,30,5],[31,4,31,5],[32,4,32,5],[33,4,33,5],[35,4,35,5],[34,4,34,5],[36,4,36,5],[37,4,37,5],[38,4,38,5],[16,1,16,4],[38,1,38,3],[39,1,39,3],[32,1,32,3],[33,1,33,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,1,7,3],[8,1,8,3],[12,1,12,3],[13,1,13,3],[9,1,9,3],[10,1,10,3],[11,1,11,3],[4,4,4,5],[5,4,5,5],[37,1,37,3],[29,1,29,3],[29,4,29,5],[30,1,30,3],[31,1,31,3],[11,4,11,5],[6,4,6,5],[7,4,7,5],[8,4,8,5],[9,4,9,5],[10,4,10,5],[34,1,34,3],[35,1,35,3],[36,1,36,3]]}
["ООО\"ЕвроТрейд\" г.С-Петербург "]
["                                               Квитанция № 03/        от     марта   2011г."]
[]
["              №","                Наименование",null,null,"           Категория",null,"    Цена","  Кол-во","Стои-ть"]
[1,"Ветчина с грибами",null,null,"пицца 32",null,410,null,{"$f":"IF(ISERROR(MMULT(G5,H5)),\"\",MMULT(G5,H5))","v":""}]
[2,"С угрем",null,null,"мини маки",null,100,null,{"$f":"IF(ISERROR(MMULT(G6,H6)),\"\",MMULT(G6,H6))","v":""}]
[3,"Спайс тунец",null,null,"острые мини маки",null,100,null,""]
[4,null,null,null,null,null,null,null,""]
[5,null,null,null,null,null,null,null,""]
[6,null,null,null,null,null,null,null,""]
[7,null,null,null,null,null,null,null,""]
[8,null,null,null,null,null,null,null,""]
[9,null,null,null,null,null,null,null,""]
[10,null,null,null,null,null,null,null,""]
["          Итог",null,null,null,null,null,null,null,{"$f":"SUM(I5:I14)","v":0}]
[]
["         Итог: ",{"$f":"Сумма_прописью(I15)","v":""},null,null,null,"00 коп."]
[]
["Товар принял:_____________________/                                   /"]
[]
["Деньги получил:___________________/                                        /"]
[]
["                                   м.п",null,null,null,"Кассир:_______________/                               /"]
[]
[]
[]
["ООО\"ЕвроТрейд\" г.С-Петербург "]
["                                        Товарный чек № 03/        от      марта   2011 г."]
[]
["              №","      Наименование",null,null,"  Категория",null,"    Цена","   Кол-во","Стои-ть"]
[1,{"$f":"IF(B5<>\"\",B5,\"\")","v":"Ветчина с грибами"},null,null,{"$f":"IF(E5<>\"\",E5,\"\")","v":"пицца 32"},null,{"$f":"IF(G5<>\"\",G5,\"\")","v":410},{"$f":"IF(H5<>\"\",H5,\"\")","v":""},{"$f":"I5","v":""}]
[2,{"$f":"IF(B6<>\"\",B6,\"\")","v":"С угрем"},null,null,{"$f":"IF(E6<>\"\",E6,\"\")","v":"мини маки"},null,{"$f":"IF(G6<>\"\",G6,\"\")","v":100},"",{"$f":"I6","v":""}]
[3,"Спайс тунец",null,null,"острые мини маки",null,100,"",""]
[4,"",null,null,"",null,"","",""]
[5,"",null,null,"",null,"","",""]
[6,"",null,null,"",null,"","",""]
[7,"",null,null,"",null,"","",""]
[8,"",null,null,"",null,"","",""]
[9,"",null,null,"",null,"","",""]
[10,"",null,null,"",null,"","",""]
["          Итог",null,null,null,null,null,null,null,{"$f":"I15","v":0}]
[]
["         Итог:",{"$f":"Сумма_прописью(I15)","v":""},null,null,null,"00 коп"]
[]
["Товар принял:_____________________/                                   /"]
[]
["Деньги получил:___________________/                                        /"]
[]
["                                   м.п",null,null,null,"Кассир:_______________/                               /"]

{"sheet":"Лист3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}