{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Доставка + накладная","Способы оплаты"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":6,"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":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":false,"merged":[[34,5,34,8],[52,1,52,7],[50,0,50,10],[37,1,46,2],[0,5,1,8],[0,0,1,2],[0,3,1,4],[0,9,1,10],[9,0,9,3],[9,4,9,10],[4,0,5,3],[4,4,5,10],[2,0,3,3],[2,4,3,10],[6,0,8,3],[6,4,8,10],[10,0,10,3],[10,4,10,10],[11,0,12,3],[11,4,12,10],[13,0,17,3],[13,4,17,10],[18,0,19,3],[21,0,21,7],[22,0,22,7],[33,9,33,10],[25,0,25,7],[27,0,27,7],[26,0,26,7],[32,9,32,10],[33,5,33,8],[32,0,32,7],[28,0,28,7],[29,0,29,7],[30,0,30,7],[23,0,23,7],[18,4,19,10],[33,3,33,4],[73,0,82,10],[68,2,68,7],[69,2,69,7],[67,2,67,9],[24,0,24,7],[65,0,65,2],[34,3,34,4],[34,0,34,2],[55,1,55,7],[56,1,56,7],[53,1,53,7],[59,1,59,7],[60,1,60,7],[35,5,35,10],[37,4,45,10],[46,4,46,10],[33,0,33,2],[31,0,31,7],[66,0,66,10],[65,5,65,10],[57,1,57,7],[58,1,58,7],[62,1,62,7],[63,0,64,8],[61,1,61,7],[54,1,54,7],[47,0,48,10],[49,0,49,4],[49,5,49,10],[51,1,51,7],[35,0,35,4],[34,9,34,10]]}
["Дата  доставки:",null,null,"2019-05-21",null,"Время доставки:"]
[]
["Имя / ФИО клиента:"]
[]
["Телефоны клиента:"]
[]
["Адреса доставки (+ТК):"]
[]
[]
["Ближайшее метро:"]
["E-Mail:"]
["Паспортные\nданные для ТК:"]
[]
["Комментарий к заказу:"]
[]
[]
[]
[]
["Автомобиль: \nмарка, модель, год выпуска, тип кузова,\nкол-во дверей, способ крепления багажника"]
[]
["Перечень оборудования",null,null,null,null,null,null,null,"Кол-во","Цена","Сумма"]
["hjkhjk",null,null,null,null,null,null,null,null,null,{"$f":"IF(J22=\"\",\"\",I22*J22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IF(J23=\"\",\"\",I23*J23)","v":""}]
["yukk",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,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,null,null,null,{"$f":"IF(I30=\"\",\"\",30)","v":""},{"$f":"IF(I30=\"\",\"\",I30*J30)","v":""}]
["Доставка до ТК",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,"ИТОГО:",{"$f":"IF(SUM(K22:K32)>0,SUM(K22:K32),\"\")","v":""}]
["Дата оформления:",null,null,{"$f":"NOW()","v":"2019-05-20T10:47:43.630"},null,"Заказ оформил:",null,null,null,"АЧ-"]
["Дата выполнения:",null,null,null,null,"Заказ доставил:"]
["Откуда узнали о нас: ",null,null,null,null,"Avtobagazniki.ru"]
[]
[null,"Место\nчека",null,null,"Благодарим Вас за покупку в нашем магазине,\nс наилучшеми пожеланиями!"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Накладная от",null,null,null,null,{"$f":"IF(D1>0,D1,\"\")","v":"2019-05-21"}]
[]
["№","Наименование товара",null,null,null,null,null,null,"Кол-во","Цена","Всего"]
[1,{"$f":"IF(A22>0,A22,\"\")","v":"hjkhjk"},null,null,null,null,null,null,{"$f":"IF(I22>0,I22,\"\")","v":""},{"$f":"IF(J22=\"\",\"\",J22)","v":""},{"$f":"IF(J53=\"\",\"\",I53*J53)","v":""}]
[2,"",null,null,null,null,null,null,"","",{"$f":"IF(J54=\"\",\"\",I54*J54)","v":""}]
[3,"yukk",null,null,null,null,null,null,"","",""]
[4,"",null,null,null,null,null,null,"","",""]
[5,"",null,null,null,null,null,null,"","",""]
[6,"",null,null,null,null,null,null,"","",""]
[7,"",null,null,null,null,null,null,{"$f":"IF(I28>0,I28,\"\")","v":""},"",""]
[8,"",null,null,null,null,null,null,{"$f":"IF(I29>0,I29,\"\")","v":""},"",""]
[9,"Доставка за МКАД",null,null,null,null,null,null,"",{"$f":"IF(I30=\"\",\"\",J30)","v":""},{"$f":"IF(I61=\"\",\"\",I61*J61)","v":""}]
[10,"Доставка до ТК",null,null,null,null,null,null,"",{"$f":"IF(J31=\"\",\"\",J31)","v":""},""]
[11,"Доставка до адреса",null,null,null,null,null,null,"",{"$f":"IF(J32=\"\",\"\",J32)","v":""},""]
["Обмен или возврат бывшего в употреблении товара не производится!",null,null,null,null,null,null,null,null,"Итого:",{"$f":"IF(SUM(K53:K63)=0,\"\",SUM(K53:K63))","v":""}]
[]
["Всего наименований",null,null,{"$f":"11-COUNTBLANK(K53:K63)&\" шт.\"","v":"0 шт."},"на сумму:",{"$f":"K64","v":""}]
[]
[null,"Покупатель:",{"$f":"IF(E3>0,E3,\"\")","v":""}]
[null,"Код заказа:",{"$f":"IF(J34>0,J34,\"\")","v":"АЧ-"}]
[null,"Отпустил:","✓"]
[null,null,null,null,null,"М.П."]
[]
[]
["Внешний вид и комплектацию товара проверил. Механических повреждений и дефектов не обнаружил. Претензий не имею.\n\nПредупреждён обо всех нюансах использования автобоксов на багажных системах с установленными в дуги резиновыми уплотнителями. В случае возникновения трещин в местах соприкосновения автобокса с резиновым уплотнителем претензий к магазину не имею."]

{"sheet":"Способы оплаты","index":1,"n_rows":18,"n_cols":3,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Наличные",null,"Яндекс"]
["Банковская карта",null,"Google"]
["Перевод на карту",null,"Avito"]
["Оплата по счёту",null,"Юла"]
[null,null,"Багажники-Автобоксы"]
[null,null,"Bagaz-Auto.ru"]
[null,null,"ProkatBagazhnikov.ru"]
[null,null,"Avtobagazniki.ru"]
[null,null,"Autobox4you"]
[null,null,"Boxteam"]
[null,null,"BoxNation"]
[null,null,"Instagram"]
[null,null,"YouTube"]
[null,null,"ВКонтакте"]
[null,null,"Facebook"]
[null,null,"От знакомых"]
[null,null,"Визитки"]
[null,null,"Уже был"]