{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["база клиентов","2018 год"],"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":27,"n_cols":5,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["№ п/п","ФИО","День рождения","Год","№ телефона"]
[1,"Иванова Марь Иванна","2018-01-01"]
[{"$f":"1+A2","v":2},"Петрова Евдокия Семеновна","1950-02-15"]
[{"$f":"1+A3","v":3}]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]

{"sheet":"2018 год","index":1,"n_rows":76,"n_cols":20,"rows_kept":76,"cut":false,"hidden":false,"merged":[[58,2,61,2],[38,0,41,0],[46,0,49,0],[46,2,49,2],[37,1,37,2],[50,0,53,0],[50,2,53,2],[54,0,57,0],[54,2,57,2],[58,0,61,0],[74,1,74,2],[75,1,75,2],[62,0,65,0],[62,2,65,2],[66,0,69,0],[66,2,69,2],[70,0,73,0],[70,2,73,2],[25,0,28,0],[29,0,32,0],[38,2,41,2],[42,0,45,0],[42,2,45,2],[1,2,4,2],[1,0,4,0],[5,0,8,0],[33,0,36,0],[5,2,8,2],[9,2,12,2],[13,2,16,2],[17,2,20,2],[21,2,24,2],[25,2,28,2],[29,2,32,2],[33,2,36,2],[9,0,12,0],[13,0,16,0],[17,0,20,0],[21,0,24,0]]}
["№ п/п","Дата","Специалисты","Запись","08:00:00","09:00:00","10:00:00","11:00:00","12:00:00","13:00:00","14:00:00","15:00:00","16:00:00","17:00:00","18:00:00","19:00:00","20:00:00","21:00:00","22:00:00","Итого на конец дня"]
[1,"2018-07-25","Маникюр Лена","ФИО","Иванова Марь Иванна"]
[null,{"$f":"B2","v":"2018-07-25"},null,"дата рожд.","2018-07-07"]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E5:S5)","v":0}]
[2,"2018-07-25","Маникюр Света","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E9:S9)","v":0}]
[3,"2018-07-25","Парикмахер Катя","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E13:S13)","v":0}]
[4,"2018-07-25","Парикмахер Ольга","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E17:S17)","v":0}]
[5,"2018-07-25","Бровист","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E21:S21)","v":0}]
[6,"2018-07-25","Шугаринг","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E25:S25)","v":0}]
[7,"2018-07-25","Косметолог","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E29:S29)","v":0}]
[8,"2018-07-25","Татуаж","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E33:S33)","v":0}]
[9,"2018-07-25","Массаж","ФИО"]
[null,"2018-07-25",null,"дата рожд."]
[null,"2018-07-25",null,"тел."]
[null,"2018-07-25",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E37:S37)","v":0}]
[null,{"$f":"CONCATENATE(\"Всего за \",TEXT(B37,\"ДД.ММ.гггг\"))","v":"Всего за 25.07.2018"},null,null,{"$f":"SUMIF($D2:$D37,\"сумма\",E2:E37)","v":0},{"$f":"SUMIF($D2:$D37,\"сумма\",F2:F37)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUMIF($D2:$D37,\"сумма\",T2:T37)","v":0}]
[1,"2018-07-26","Маникюр Лена","ФИО"]
[null,{"$f":"B39","v":"2018-07-26"},null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E42:S42)","v":0}]
[2,"2018-07-26","Маникюр Света","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E46:S46)","v":0}]
[3,"2018-07-26","Парикмахер Катя","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E50:S50)","v":0}]
[4,"2018-07-26","Парикмахер Ольга","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E54:S54)","v":0}]
[5,"2018-07-26","Бровист","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E58:S58)","v":0}]
[6,"2018-07-26","Шугаринг","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E62:S62)","v":0}]
[7,"2018-07-26","Косметолог","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E66:S66)","v":0}]
[8,"2018-07-26","Татуаж","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E70:S70)","v":0}]
[9,"2018-07-26","Массаж","ФИО"]
[null,"2018-07-26",null,"дата рожд."]
[null,"2018-07-26",null,"тел."]
[null,"2018-07-26",null,"сумма",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E74:S74)","v":0}]
[null,{"$f":"CONCATENATE(\"Всего за \",TEXT(B74,\"ДД.ММ.гггг\"))","v":"Всего за 26.07.2018"},null,null,{"$f":"SUMIF($D39:$D74,\"сумма\",E39:E74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",F39:F74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",G39:G74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",H39:H74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",I39:I74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",J39:J74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",K39:K74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",L39:L74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",M39:M74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",N39:N74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",O39:O74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",P39:P74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",Q39:Q74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",R39:R74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",S39:S74)","v":0},{"$f":"SUMIF($D39:$D74,\"сумма\",T39:T74)","v":0}]
[null,"Всего за 2018 год",null,null,{"$f":"SUMIF($D2:$D75,\"сумма\",E2:E75)","v":0},{"$f":"SUMIF($D2:$D75,\"сумма\",F2:F75)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0]