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

{"sheet":"Товарный чек","index":1,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[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],[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]]}
["ООО\"ЕвроТрейд\" г.С-Петербург "]
["                                               Квитанция № 03/        от     марта   2011г."]
[]
["              №","                Наименование",null,null,"           Категория",null,"    Цена","  Кол-во","Стои-ть"]
[1,"Жульен",null,null,"пицца 32",null,420,null,{"$f":"IF(ISERROR(MMULT(G5,H5)),\"\",MMULT(G5,H5))","v":""}]
[2,"Филадельфия",null,null,"классические роллы",null,230,null,{"$f":"IF(ISERROR(MMULT(G6,H6)),\"\",MMULT(G6,H6))","v":""}]
[3,"Калифорния",null,null,"классические роллы",null,230,null,""]
[4,"Аляска",null,null,"классические роллы",null,230,null,""]
[5,"Батакон",null,null,"классические роллы",null,230,null,""]
[6,"Спайс креветка",null,null,"острые мини маки",null,100,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":420},{"$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":230},"",{"$f":"I6","v":""}]
[3,"Калифорния",null,null,"классические роллы",null,230,"",""]
[4,"Аляска",null,null,"классические роллы",null,230,"",""]
[5,"Батакон",null,null,"классические роллы",null,230,"",""]
[6,"Спайс креветка",null,null,"острые мини маки",null,100,"",""]
[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":[]}