{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["ApplicationForm","OperationsInput","PrintInvoice","DataForOPECriticalIllness","DataForPrint","master","ContractNUmberCreator","SummToText_test","SummToText","PrintPolicy"],"not_rendered":{"charts":0,"images":5,"macros":1,"external_links":0,"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":"ApplicationForm","index":0,"n_rows":62,"n_cols":4,"rows_kept":62,"cut":false,"hidden":false,"merged":[[33,3,41,15]]}
["Выбор программы"]
["Программа (для выбора ) / Program ","Базовая","<Please select>"]
["Стоимость / Price",null,{"$f":"VLOOKUP(B2,master!A:C,2,TRUE)","v":5000},{"$f":"VLOOKUP(B2,master!A:C,3,TRUE)","v":"RUB"}]
[]
["Форма для заполнения сотрудником"]
[]
["Данные застрахованного лица / Insured person information"]
["Фамилия / Surname *",null,"<Please type in>"]
["Имя / First Name *",null,"<Please type in>"]
["Отчество / Patronymic name",null,"<Please type in>"]
["Дата рождения / Birth Date *",null,"<Please type in>",{"$f":"IF(B11=\"\",\"\",IF(AND((YEAR(NOW())-YEAR(B11))>17,((YEAR(NOW())-YEAR(B11))<65)),\"\",\"Возраст клиента должен быть от 18 до 64 лет включительно. / Client's age is out of the allowed age interval from 18 till 64 years.\"))","v":""}]
["Пол / Gender *","<please choose>","<Please select>"]
["ИНН / TIN (Identification number of taxpayer)",null,"<Please type in>"]
["Место рождения / Place of birth *",null,"<Please type in>"]
[]
["Документ удостоверяющий личность / Type of identity document"]
["Документ удостоверяющий личность / Type of identity document *","<please choose>","<Please select>"]
["Гражданство / Citizenship *",null,"<Please type in>"]
["Серия / Document series *",null,"<Please type in>"]
["Номер / Document  number *",null,"<Please type in>"]
["Выдан (кем) / Place document was issued *",null,"<Please type in>"]
["Дата выдачи / Date of issuing Document *",null,"<Please type in>"]
["Код подразделения / Code of issuing place *",null,"<Please type in>"]
[]
["Миграционные документы / Mirgation Documents"]
["Номер миграционной карты / Migration Card number",null,"<Please type in>"]
["Дата начала действия МК / Migration Card from",null,"<Please type in>"]
["Дата окончания МК / Migration Card to",null,"<Please type in>"]
["Type of the document confirming the right to stay in Russia","<please choose>","<Please select>"]
["Право нахождения с / Right to stay from",null,"<Please type in>"]
["Право нахождения по / Right to stay to",null,"<Please type in>"]
[]
["Публичное должностное лицо / Foreign Public Authority"]
["Является ли клиент публичным должностным лицом, его супругом или родственником / Is Insured person foreign public authority or close relative? *","<please choose>","<Please select>","* Понятие «публичное должностное лицо» включает в себя категории: иностранное публичное должностное лицо (т.е. любых назначаемых или избираемых лиц, занимающих какую-либо должность в законодательном, исполнительном, административном или судебном органе иностранного государства, и любых лиц, выполняющих какую-либо публичную функцию для иностранного государства, в т.ч., для публичного ведомства или государственного предприятия); должностное лицо публичной международной организации (т.е. международных гражданских служащих или любых лиц, которые уполномочены действовать от имени международной организации); а также российское публичное должностное лицо (т.е. лицо, замещающее/занимающее государственные должности Российской Федерации, должности членов Совета директоров Центрального банка РФ, должности федеральной государственной службы, назначение на которые и освобождение от которых осуществляются Президентом РФ или Правительством РФ, должности в ЦБ РФ, государственных корпорациях и иных организациях, созданных РФ на основании федеральных законов, включенные в перечни должностей, определяемые Президентом РФ)."]
["Категория или организация ПДЛ / Public authority category or organization",null,"<Please type in>"]
["Должность ПДЛ / Public authority position",null,"<Please type in>"]
["Работодатель ПДЛ / Public authority employer name",null,"<Please type in>"]
["Адрес работодателя ПДЛ / Public authority employer address",null,"<Please type in>"]
["Степень родства / Degree of relationship",null,"<Please type in>"]
["Имя родственника / Relative name",null,"<Please type in>"]
["Должность занимаемая родственником / Relative position",null,"<Please type in>"]
["Источник доходов / Source of funds",null,"<Please type in>"]
[]
["Фактический адрес (проживания) / Actual Address"]
["Страна / country *",null,"<Please type in>"]
["Индекс / zip code *",null,"<Please type in>"]
["Регион / region *",null,"<Please type in>"]
["Город, населенный пункт / city *",null,"<Please type in>"]
["Улица / street",null,"<Please type in>"]
["Дом / house *",null,"<Please type in>"]
["Строение / buiding",null,"<Please type in>"]
["Корпус / corpus",null,"<Please type in>"]
["Квартира / apartment",null,"<Please type in>"]
[]
[]
["Контакты и реквизиты / Contacts"]
["E-mail*",null,"<Please type in>"]
["Контактный телефон / Contact phone",null,"<Please type in>"]
[]
["№ банковского счета / Bank Account number",null,"<Please type in>","* Номер Вашего счёта в ПАО РОСБАНК Вы можете посмотреть в мобильном и интернет приложении банка"]
[]
[{"$f":"IF(OR(B8=\"\",B9=\"\",B10=\"\",B11=\"\",B12=\"<please choose>\",B34=\"<please choose>\",B14=\"\",B45=\"\",B46=\"\",B47=\"\",B48=\"\",B50=\"\",B17=\"\",B18=\"\",B22=\"\",B57=\"\",B20=\"\",D11<>\"\"),\"Не все обязательные поля заполнены, просьба их заполнить. / Not all mandatory fields are filled. Please type them in.\",\"\")","v":"Не все обязательные поля заполнены, просьба их заполнить. / Not all mandatory fields are filled. Please type them in."}]

{"sheet":"OperationsInput","index":1,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":true,"merged":[]}
["Форма для заполнения бек-офисом после получения заполненной формы",null,{"$f":"CONCATENATE(\"SG-\",ContractNUmberCreator!N3)","v":"SG-LR-0605-090416-2"}]
["Договор №",null,"<------------------"]
["Договор От",null,"<Please type in>"]
[]
["Курс ЦБ (Евро) на дату заключения договора",null,"<Please type in>"]
["Цена полиса в Руб на дату заключения договора (RUB)",{"$f":"IF(ApplicationForm!D3=\"RUB\",ApplicationForm!C3,ROUND(ApplicationForm!C3*B5,2))","v":5000},"<Calculated>"]
[]
["Страховая сумма",{"$f":"VLOOKUP(ApplicationForm!B2,master!A:D,4)","v":12500000}]

{"sheet":"PrintInvoice","index":2,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":true,"merged":[[15,1,15,7],[20,1,20,7],[21,6,21,7],[7,1,7,3],[7,6,7,7],[8,6,8,7],[9,1,9,3],[9,6,9,7],[12,2,12,7],[14,2,14,7]]}
[]
[]
[null,"Общество с ограниченной ответственностью \"РБ Страхование Жизни\""]
[null,"107078, г. Москва, ул. Маши Порываевой, д. 34, этаж 2, ком. 58"]
[]
[null,"ИНН ",7706625952," КПП 770801001"]
[null,"Получатель"]
[null,"ООО \"РБ Страхование Жизни\"",null,null,null,"Сч. №","40702810797180000108"]
[null,"Банк получателя",null,null,null,"БИК","044525256"]
[null,"Московский филиал ПАО РОСБАНК г. Москва",null,null,null,"Сч. №","30101810000000000256"]
[null,{"$f":"IF(ApplicationForm!A62<>\"\",\"Счет не может быть сформирован - в заявке присутствуют незаполненные обязательные поля! Просьба вернутьзаявку клиенту/сотруднику для корректировки заполнения.\",\"\")","v":"Счет не может быть сформирован - в заявке присутствуют незаполненные обязательные поля! Просьба вернутьзаявку клиенту/сотруднику для корректировки заполнения."}]
[null,{"$f":"IF(B11<>\"\",\"\",\"СЧЕТ\")","v":""}]
[null,{"$f":"IF(B11<>\"\",\"\",\"Плательщик:\")","v":""},{"$f":"IF(B11<>\"\",\"\",CONCATENATE(ApplicationForm!B8,\" \",ApplicationForm!B9,\" \",ApplicationForm!B10))","v":""}]
[]
[null,{"$f":"IF(B11<>\"\",\"\",\"Назначение платежа:\")","v":""},{"$f":"IF(B11<>\"\",\"\",CONCATENATE(\"Стр. премия. по дог. \",OperationsInput!B2,\" от \",TEXT(OperationsInput!B3,\"ДД-ММ-ГГГГ\"),\", \",C13))","v":""}]
[null,{"$f":"IF(B11<>\"\",\"\",\"НДС не облагается\")","v":""}]
[]
[null,null,null,null,null,"Итого:",{"$f":"OperationsInput!$B$6","v":5000},"Рублей РФ"]
[null,null,null,null,null,"НДС не облагается.","   -"]
[null,null,null,null,null,"Всего к оплате:",{"$f":"OperationsInput!$B$6","v":5000},"Рублей РФ"]
[null,{"$f":"CONCATENATE(SummToText!B3)","v":"Пять тысяч рублей  РФ, 00 коп."}]
[null,null,null,null,null,null,"Генеральный директор\n"]
[null,null,null,null,null,null,"Гаврилов Д.А."]

{"sheet":"DataForOPECriticalIllness","index":3,"n_rows":1,"n_cols":56,"rows_kept":1,"cut":false,"hidden":true,"merged":[]}
[{"$f":"OperationsInput!B2","v":"00:00:00"},{"$f":"IF(ApplicationForm!D3 = \"EUR\",\"евро\",\"руб\")","v":"руб"},{"$f":"OperationsInput!B3","v":"00:00:00"},12,{"$f":"C1+120+1","v":"1900-04-30"},"Оформлен",{"$f":"ApplicationForm!B8","v":0},{"$f":"ApplicationForm!B9","v":0},{"$f":"IF(ApplicationForm!$B10=\"\",\"\",ApplicationForm!$B10)","v":""},{"$f":"ApplicationForm!B12","v":"<please choose>"},{"$f":"ApplicationForm!B11","v":"00:00:00"},{"$f":"ApplicationForm!B18","v":0},{"$f":"ApplicationForm!B14","v":0},{"$f":"ApplicationForm!B17","v":"<please choose>"},{"$f":"ApplicationForm!B19","v":0},{"$f":"ApplicationForm!B20","v":0},{"$f":"IF(ApplicationForm!$B21=\"\",\"\",ApplicationForm!$B21)","v":""},{"$f":"ApplicationForm!B22","v":"00:00:00"},{"$f":"ApplicationForm!B23","v":0},{"$f":"IF(ApplicationForm!$B26=\"\",\"\",ApplicationForm!$B26)","v":""},{"$f":"IF(ApplicationForm!$B27=\"\",\"\",ApplicationForm!$B27)","v":""},{"$f":"IF(ApplicationForm!$B28=\"\",\"\",ApplicationForm!$B28)","v":""},{"$f":"IF(ApplicationForm!$B29=\"<please choose>\",\"\",ApplicationForm!$B29)","v":""},{"$f":"IF(ApplicationForm!B30=\"\",\"\",ApplicationForm!B30)","v":""},{"$f":"IF(ApplicationForm!B31=\"\",\"\",ApplicationForm!B31)","v":""},{"$f":"IF(ApplicationForm!B13=\"\",\"ИНН не предъявлен\",ApplicationForm!B13)","v":"ИНН не предъявлен"},{"$f":"IF(ApplicationForm!B34=\"Нет\",\"Нет\",IF(ApplicationForm!B34=\"<please choose>\",\"Нет\"))","v":"Нет"},{"$f":"IF(ApplicationForm!B35=\"\",\"\",ApplicationForm!B35)","v":""},{"$f":"IF(ApplicationForm!B36=\"\",\"\",ApplicationForm!B36)","v":""},{"$f":"IF(ApplicationForm!B37=\"\",\"\",ApplicationForm!B37)","v":""},{"$f":"IF(ApplicationForm!B38=\"\",\"\",ApplicationForm!B38)","v":""},{"$f":"IF(ApplicationForm!B39=\"\",\"\",ApplicationForm!B39)","v":""},{"$f":"IF(ApplicationForm!B40=\"\",\"\",ApplicationForm!B40)","v":""},{"$f":"IF(ApplicationForm!B41=\"\",\"\",ApplicationForm!B41)","v":""},{"$f":"IF(ApplicationForm!B42=\"\",\"\",ApplicationForm!B42)","v":""},{"$f":"ApplicationForm!B45","v":0},{"$f":"ApplicationForm!B46","v":0},{"$f":"ApplicationForm!B47","v":0},{"$f":"ApplicationForm!B48","v":0},{"$f":"ApplicationForm!B49","v":0},{"$f":"ApplicationForm!B50","v":0},{"$f":"ApplicationForm!B51","v":0},{"$f":"ApplicationForm!B52","v":0},{"$f":"ApplicationForm!B53","v":0},{"$f":"ApplicationForm!B57","v":0},{"$f":"ApplicationForm!B58","v":0},{"$f":"CONCATENATE(ApplicationForm!B2,\"_INT\")","v":"Базовая_INT"},{"$f":"IF($AU$1=\"Премиум_INT\",OperationsInput!B6,IF($AU$1=\"Комфорт_INT\",OperationsInput!B6,OperationsInput!B6))","v":5000},{"$f":"IF($AU$1=\"Премиум_INT\",ApplicationForm!C3,IF($AU$1=\"Комфорт_INT\",ApplicationForm!C3,\"\"))","v":""},{"$f":"IF($AU$1=\"Премиум_INT\",0,IF($AU$1=\"Комфорт_INT\",0,12500000))","v":12500000},{"$f":"IF($AU$1=\"Премиум_INT\",400000,IF($AU$1=\"Комфорт_INT\",200000,0))","v":0},null,null,null,null,{"$f":"ApplicationForm!B60","v":0}]

{"sheet":"DataForPrint","index":4,"n_rows":2,"n_cols":97,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Contract number","Contract currency","Date of policy signing","Contract term, month","Coverage start date","Policy status","Surname of the client","Name of the client","Patronymic of the client","Gender","Birth date","Citizenship","Place of birth","Type of identity document","Document series ","Document  number","Place document was issued","Date of issuing Document","Code of issuing place","Migration Card number","Migration Card from","Migration Card to","Type of the document confirming the right to stay in Russia","Right to stay from","Right to stay to","Identification number of taxpayer","Is Insured person foreign public authority or close relative?","Public authority category/organization","Public authority position","Public authority employer name","Public authority employer address","Degree of relationship","Relative name","Relative position","Source of funds","Actual address: country","Actual address: zip code","Actual address:  region","Actual address: city","Actual address:  street","Actual address:  house","Actual address: buiding","Actual address: corpus","Actual address: apartment","E-mail","Contact phone","Insurance Program"," Insurance premium, rub "," Insurance premium, euro ","Insurance Sum, rub","Insurance Sum, euro"," EUR rate ","Additional office number","Additional office OKATO"," Previous contract number ","Client’s bank account number"," Original policy in OSG ","Auto-renewal","Refusal from auto-renewal date"," Sum of payment ","Payment date"," Comission amount ","Closing date","Closing reason","Refund application date","Refund amount, rub","Refund type","Refund reason","Refund payment date","Refund currencry","Refund amount in currency","Type of refund posting","Premium accrual posting date","Premium payment posting date","Premium storno posting date","Premium storno amount","Refund accrual posting date","Refund payment posting date","Date of last modification","Reinsurance premium Gen Re, rub","Reinsurance premium Gen Re, euro","Reinsurance premium Gen Re accrual posting date"," Reinsurance premium Gen Re refund, rub "," Reinsurance premium Gen Re refund, euro "," Reinsurance premium Gen Re refund accrual posting date "," Reinsurance premium Gen Re reversal accrual posting date ","Reinsurance premium NRC, rub","Reinsurance premium NRC, euro","Reinsurance premium NRC accrual posting date"," Reinsurance premium NRC refund, rub "," Reinsurance premium NRC refund, euro "," Reinsurance premium NRC refund accrual posting date "," Reinsurance premium NRC reversal accrual posting date ","Сверка оплаченной премиии","Комментарии","ДляПечати_Страховая_Сумма","ДляПечати_СуммаКОплате_РУБ"]
[{"$f":"OperationsInput!B2","v":"00:00:00"},{"$f":"IF(ApplicationForm!D3 = \"EUR\",\"евро\",\"руб\")","v":"руб"},{"$f":"OperationsInput!B3","v":"00:00:00"},12,null,"Оформлен",{"$f":"ApplicationForm!B8","v":0},{"$f":"ApplicationForm!B9","v":0},{"$f":"ApplicationForm!B10","v":0},{"$f":"ApplicationForm!B12","v":"<please choose>"},{"$f":"ApplicationForm!B11","v":"00:00:00"},{"$f":"ApplicationForm!B18","v":0},{"$f":"ApplicationForm!B14","v":0},{"$f":"ApplicationForm!B17","v":"<please choose>"},{"$f":"ApplicationForm!B19","v":0},{"$f":"ApplicationForm!B20","v":0},{"$f":"IF(ApplicationForm!$B21=\"\",\"\",ApplicationForm!$B21)","v":""},{"$f":"ApplicationForm!B22","v":"00:00:00"},{"$f":"ApplicationForm!B23","v":0},{"$f":"IF(ApplicationForm!$B26=\"\",\"\",ApplicationForm!$B26)","v":""},{"$f":"IF(ApplicationForm!$B27=\"\",\"\",ApplicationForm!$B27)","v":""},{"$f":"IF(ApplicationForm!$B28=\"\",\"\",ApplicationForm!$B28)","v":""},{"$f":"IF(ApplicationForm!$B29=\"<please choose>\",\"\",ApplicationForm!$B29)","v":""},{"$f":"IF(ApplicationForm!B30=\"\",\"\",ApplicationForm!B30)","v":""},{"$f":"IF(ApplicationForm!B31=\"\",\"\",ApplicationForm!B31)","v":""},{"$f":"IF(ApplicationForm!B13=\"\",\"\",ApplicationForm!B13)","v":""},{"$f":"IF(ApplicationForm!B34=\"Нет\",\"Нет\",IF(ApplicationForm!B34=\"<please choose>\",\"Нет\"))","v":"Нет"},{"$f":"IF(ApplicationForm!B35=\"\",\"\",ApplicationForm!B35)","v":""},{"$f":"IF(ApplicationForm!B36=\"\",\"\",ApplicationForm!B36)","v":""},{"$f":"IF(ApplicationForm!B37=\"\",\"\",ApplicationForm!B37)","v":""},{"$f":"IF(ApplicationForm!B38=\"\",\"\",ApplicationForm!B38)","v":""},{"$f":"IF(ApplicationForm!B39=\"\",\"\",ApplicationForm!B39)","v":""},{"$f":"IF(ApplicationForm!B40=\"\",\"\",ApplicationForm!B40)","v":""},{"$f":"IF(ApplicationForm!B41=\"\",\"\",ApplicationForm!B41)","v":""},{"$f":"IF(ApplicationForm!B42=\"\",\"\",ApplicationForm!B42)","v":""},{"$f":"IF(LEN(ApplicationForm!B45)>0,ApplicationForm!B45,\"\")","v":""},{"$f":"IF(ApplicationForm!B46=\"\",\"\",ApplicationForm!B46)","v":""},{"$f":"IF(ApplicationForm!B47=\"\",\"\",ApplicationForm!B47)","v":""},{"$f":"IF(ApplicationForm!B48=\"\",\"\",ApplicationForm!B48)","v":""},{"$f":"IF(ApplicationForm!B49=\"\",\"\",ApplicationForm!B49)","v":""},{"$f":"IF(ApplicationForm!B50=\"\",\"\",\", дом \"&ApplicationForm!B50)","v":""},{"$f":"IF(ApplicationForm!B51=\"\",\"\",\", стр. \"&ApplicationForm!B51)","v":""},{"$f":"IF(ApplicationForm!B52=\"\",\"\",\", корп. \"&ApplicationForm!B52)","v":""},{"$f":"IF(ApplicationForm!B53=\"\",\"\",\", кв. \"&ApplicationForm!B53)","v":""},{"$f":"IF(ApplicationForm!B57=0,\"\",ApplicationForm!B57)","v":""},{"$f":"IF(ApplicationForm!B58=0,\"\",ApplicationForm!B58)","v":""},{"$f":"CONCATENATE(ApplicationForm!B2,\"_INT\")","v":"Базовая_INT"},{"$f":"IF($AU$1=\"Премиум_INT\",OperationsInput!B6,IF($AU$1=\"Комфорт_INT\",OperationsInput!B6,OperationsInput!B6))","v":5000},{"$f":"IF($AU$2=\"Премиум_INT\",ApplicationForm!C3,IF($AU$2=\"Комфорт_INT\",ApplicationForm!C3,\"\"))","v":""},{"$f":"IF($AU$2=\"Премиум_INT\",0,IF($AU$2=\"Комфорт_INT\",0,12500000))","v":12500000},{"$f":"IF($AU$2=\"Премиум_INT\",400000,IF($AU$2=\"Комфорт_INT\",200000,0))","v":0},{"$f":"OperationsInput!B5","v":0},null,null,null,{"$f":"IF(ApplicationForm!B60=0,\"\",ApplicationForm!B60)","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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"OperationsInput!B6","v":5000}]

{"sheet":"master","index":5,"n_rows":7,"n_cols":16,"rows_kept":7,"cut":false,"hidden":true,"merged":[]}
["Программа","цена","валюта","Покрытие","Пол",null,"ДокументУдостоверяющийЛичность",null,"ТипДокументаПодтверждающегоПравоИностранногоГражданинаИлиЛицаБезГражданстваНаПроживание_Пребывание",null,"Да-Нет",null,"Is Insured person foreign public authority or close relative?",null,"Наименование программы","Код программы для номера договора"]
["Базовая",5000,"RUB",12500000,"Мужской",null,"Паспорт гражданина РФ",null,"Разрешение на временное проживание",null,"Да / Yes",null,"Нет",null,"Базовая","R"]
["Комфорт",137,"EUR",200000,"Женский",null,"Загранпаспорт",null,"Вид на жительство",null,"Нет / No",null,"Российское ПДЛ",null,"Комфорт","U"]
["Премиум",276,"EUR",400000,null,null,"Дипломатический паспорт, служебный паспорт",null,"Виза",null,null,null,"Иностранное ПДЛ",null,"Премиум","W"]
[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":"ContractNUmberCreator","index":6,"n_rows":3,"n_cols":17,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["now",null,"Year","Month","Day","hours","Minutes","Sec",null,"Concatenate",null,"LU-7481-009411-5","ControlNu","Contract Number",null,null,"ContractNo in 1 formula"]
[{"$f":"NOW()","v":"2023-06-05T09:04:15.800"},null,{"$f":"YEAR(A2)","v":2023},{"$f":"MONTH(A2)","v":6},{"$f":"DAY(A2)","v":5},{"$f":"HOUR(A2)","v":9},{"$f":"MINUTE(A2)","v":4},{"$f":"SECOND(A2)","v":16},null,{"$f":"CONCATENATE(C2,D2,E2,F2,G2,H2)","v":"2023659416"},null,{"$f":"CONCATENATE(\"LW-\",D2,E2,\"-\",F2,G2,H2,\"-1\")","v":"LW-65-9416-1"}]
[{"$f":"NOW()","v":"2023-06-05T09:04:15.800"},null,{"$f":"YEAR(A3)","v":2023},{"$f":"IF(LEN(D2)<2,CONCATENATE(\"0\",D2),D2)","v":"06"},{"$f":"IF(LEN(E2)<2,CONCATENATE(\"0\",E2),E2)","v":"05"},{"$f":"IF(LEN(F2)<2,CONCATENATE(\"0\",F2),F2)","v":"09"},{"$f":"IF(LEN(G2)<2,CONCATENATE(\"0\",G2),G2)","v":"04"},{"$f":"IF(LEN(H2)<2,CONCATENATE(\"0\",H2),H2)","v":16},null,null,null,{"$f":"CONCATENATE(\"L\",VLOOKUP(ApplicationForm!B2,master!$O$1:$P$4,2,FALSE),\"-\",D3,E3,\"-\",F3,G3,H3)","v":"LR-0605-090416"},{"$f":"ROUND((ROUNDUP((MID(L3,9,1)*1+MID(L3,10,1)*3+MID(L3,11,1)*1+MID(L3,12,1)*3+MID(L3,13,1)*1+MID(L3,14,1)*3)/10,0)-(MID(L3,9,1)*1+MID(L3,10,1)*3+MID(L3,11,1)*1+MID(L3,12,1)*3+MID(L3,13,1)*1+MID(L3,14,1)*3)/10)*10,0)","v":2},{"$f":"CONCATENATE(L3,\"-\",M3)","v":"LR-0605-090416-2"},null,null,{"$f":"CONCATENATE(CONCATENATE(\"LI-\",D3,E3,\"-\",F3,G3,H3),\"-\",ROUND((ROUNDUP((MID(L3,9,1)*1+MID(L3,10,1)*3+MID(L3,11,1)*1+MID(L3,12,1)*3+MID(L3,13,1)*1+MID(L3,14,1)*3)/10,0)-(MID(L3,9,1)*1+MID(L3,10,1)*3+MID(L3,11,1)*1+MID(L3,12,1)*3+MID(L3,13,1)*1+MID(L3,14,1)*3)/10)*10,0))","v":"LI-0605-090416-2"}]

{"sheet":"SummToText_test","index":7,"n_rows":39,"n_cols":21,"rows_kept":39,"cut":false,"hidden":true,"merged":[]}
["рубли","десятки тысяч","текст","тысячи рубли","текст","сотни рублей","текст","десятки рублей","текст","рубли","текст","десятки копеек","текст","копейки","текст"]
[null,1,"десять",1,"одна тысяча",1,"сто",1,"десять",1,"один рубль",1,"десять",1,"одна",null,null,{"$f":"PrintInvoice!G20","v":5000},{"$f":"IF(R2=5000,\"Пять тысяч рублей\",CONCATENATE(S6,\" \",S7,\" \",S8,\" \",S9,\" \",S10))","v":"Пять тысяч рублей"},{"$f":"MID(R2,1,1)","v":"5"},{"$f":"VLOOKUP(VALUE(T2),B:C,2,FALSE)","v":"пятьдесят"}]
[null,2,"двадцать",2,"две тысячи",2,"двести",2,"двадцать",2,"два рубля",2,"двадцать",2,"две"]
[null,3,"тридцать",3,"три тысячи",3,"триста",3,"тридцать",3,"три рубля",3,"тридцать",3,"три",null,null,null,{"$f":"RIGHT(R2,2)","v":"00"}]
[null,4,"сорок",4,"четыре тысячи",4,"четыреста",4,"сорок",4,"четыре рубля",4,"сорок",4,"четыре ",null,null,null,"По частям:"]
[null,5,"пятьдесят",5,"пять тысяч",5,"пятьсот",5,"пятьдесят",5,"пять рублей",5,"пятьдесят",5,"пять",null,null,null,{"$f":"VLOOKUP(VALUE(MID(R2,1,1)),B:C,2,FALSE)","v":"пятьдесят"}]
[null,6,"шестьдесят",6,"шесть тысяч",6,"шестьсот",6,"шестьдесят",6,"шесть рублей",6,"шестьдесят",6,"шесть",null,null,null,{"$f":"IF(VALUE(MID(R2,2,1))=0,\"тысяч\",VLOOKUP(VALUE(MID(R2,2,1)),D:E,2,FALSE))","v":"тысяч"}]
[null,7,"семьдесят",7,"семь тысячи",7,"семьсот",7,"семьдесят",7,"семь рублей",7,"семьдесят",7,"семь",null,null,null,{"$f":"VLOOKUP(VALUE(MID(R2,3,1)),F:G,2,FALSE)","v":{"$error":"#N/A"}}]
[null,8,"восемьдесят",8,"восемь тысяч",8,"восемьсот",8,"восемьдесят",8,"восемь рублей",8,"восемьдесят",8,"восемь",null,null,null,{"$f":"IF(VALUE(MID(R2,4,1))=0,\"\",(VLOOKUP(VALUE(MID(R2,4,1)),H:I,2,FALSE)))","v":""}]
[null,9,"девяность",9,"девять тысячи",9,"девятьсот",9,"девяность",9,"девять рублей",9,"девяность",9,"девять",null,null,null,{"$f":"IF(VALUE(MID(R2,4,1))=0,\"рублей\",(VLOOKUP(VALUE(MID(R2,5,1)),J:K,2,FALSE)))","v":"рублей"}]
[null,null,null,10,"десять",null,null,null,null,10,"десять рублей",10,null,10,"десять"]
[null,null,null,11,"одиннадцать",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(TRUNC(R2/10000,0)>0,VLOOKUP(VALUE(MID(R2,1,1)),B:C,2,FALSE),\"\")","v":""},"Если меньше 10 000 то "]
[null,null,null,12,"двенадцать"]
[null,null,null,13,"тринадцать"]
[null,null,null,14,"четырнадцать"]
[null,null,null,15,"пятнадцать",null,null,null,null,null,null,null,null,null,null,null,null,6850]
[null,null,null,16,"шестнадцать"]
[null,null,null,17,"семнадцать"]
[null,null,null,18,"восемнадцать"]
[null,null,null,19,"девятнадцать"]
[null,null,null,20,"двадцать"]
[null,null,null,21]
[null,null,null,22]
[null,null,null,23]
[null,null,null,24]
[null,null,null,25]
[null,null,null,26]
[null,null,null,27]
[null,null,null,28]
[null,null,null,29]
[null,30,null,30]
[null,31,null,31]
[null,32,null,32]
[null,33,null,33]
[null,34,null,34]
[null,35,null,35]
[null,36,null,36]
[null,37,null,37]
[null,38,null,38]

{"sheet":"SummToText","index":8,"n_rows":43,"n_cols":7,"rows_kept":43,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,null,{"$f":"OperationsInput!B6","v":5000}]
["Заглавная без НДС",{"$f":"SUBSTITUTE(B5,F9,F10,1)","v":"Пять тысяч рублей  РФ, 00 коп."}]
["Заглавная с НДС",{"$f":"SUBSTITUTE(B6,F9,F10,1)","v":"Пять тысяч рублей 00 коп.)"}]
["маленькая без НДС",{"$f":"CONCATENATE(A8,A9,A10,A11,\" РФ, \",A12)","v":"пять тысяч рублей  РФ, 00 коп."}]
["маленькая с НДС",{"$f":"CONCATENATE(A8,A9,A10,A11,A12,B8,B9,C9)","v":"пять тысяч рублей 00 коп.)"}]
[]
["",null,null,null,null,{"$f":"CODE(B6)","v":239}]
["",null,")",null,null,{"$f":"CHAR(F8)","v":"п"}]
[{"$f":"CONCATENATE(IF(B23=0,\"\",E23),IF(C25<20,IF(C25<16,IF(C25<10,E24,D25),F25),E24),IF(B25=0,\"\",IF(NOT(B24=1),E25,\"\")),F26)","v":"пять тысяч "},null,null,null,null,{"$f":"PROPER(F9)","v":"П"}]
[{"$f":"CONCATENATE(IF(B27=0,\"\",E27),IF(C29<20,IF(C29<16,IF(C29<10,E28,D29),F29),E28),IF(B29=0,\"\",IF(NOT(B28=1),E29,\"\")),F30)","v":"рублей "}]
[{"$f":"CONCATENATE(IF(C31=0,\"0\",C31),IF(C32=0,\"0\",C32),\" \",F33)","v":"00 коп."}]
[null,null,null,null,{"$f":"E2","v":5000},"рублей"]
[{"$f":"TRUNC(A15/10)","v":0}]
[{"$f":"TRUNC(A16/10)","v":0},{"$f":"TRUNC(RIGHT(A15))","v":0},{"$f":"B15","v":0},null,{"$f":"IF(B15=1,E43,IF(B15=2,G35,IF(B15=3,G36,IF(B15=4,G37,IF(B15=5,G38,IF(B15=6,G39,IF(B15=7,G40,IF(B15=8,G41,G42))))))))","v":"девятьсот "}]
[{"$f":"TRUNC(A17/10)","v":0},{"$f":"TRUNC(RIGHT(A16))","v":0},{"$f":"IF(B16=1,\"\",B16)","v":0},null,{"$f":"IF(OR(C16=0,B16=1),\"\",IF(B16=2,E35,IF(B16=3,E36,IF(B16=4,E37,IF(B16=5,E38,IF(B16=6,E39,IF(B16=7,E40,IF(B16=8,E41,E42))))))))","v":""}]
[{"$f":"TRUNC(A19/10)","v":0},{"$f":"TRUNC(RIGHT(A17))","v":0},{"$f":"IF(B16=1,B17+10,IF(B17=0,0,B17))","v":0},{"$f":"IF(AND(C17>9,C17<16),IF(C17=10,D34,IF(C17=11,D35,IF(C17=12,D36,IF(C17=13,D37,IF(C17=14,D38,IF(C17=15,D39,)))))),\"\")","v":""},{"$f":"IF(B17=1,A34,IF(B17=2,A35,IF(B17=3,A36,IF(B17=4,A37,IF(B17=5,A38,IF(B17=6,A39,IF(B17=7,A40,IF(B17=8,A41,A42))))))))","v":"девять "},{"$f":"IF(AND(C17>15,C17<20),IF(C17=16,D40,IF(C17=17,D41,IF(C17=18,D42,IF(C17=19,D43,)))),\"\")","v":""}]
[null,null,null,null,{"$f":"B17+B16*10+B15*100","v":0},{"$f":"IF(E18=0,\"\",IF(B16=1,\"миллиардов \",IF(B17=1,\"милиард \",IF(OR(B17=2,B17=3,B17=4),\"миллиарда \",\"милиардов \"))))","v":""}]
[{"$f":"TRUNC(A20/10)","v":0},{"$f":"TRUNC(RIGHT(A19))","v":0},{"$f":"B19","v":0},null,{"$f":"IF(B19=1,E43,IF(B19=2,G35,IF(B19=3,G36,IF(B19=4,G37,IF(B19=5,G38,IF(B19=6,G39,IF(B19=7,G40,IF(B19=8,G41,G42))))))))","v":"девятьсот "}]
[{"$f":"TRUNC(A21/10)","v":0},{"$f":"TRUNC(RIGHT(A20))","v":0},{"$f":"IF(B20=1,\"\",B20)","v":0},null,{"$f":"IF(OR(C20=0,B20=1),\"\",IF(B20=2,E35,IF(B20=3,E36,IF(B20=4,E37,IF(B20=5,E38,IF(B20=6,E39,IF(B20=7,E40,IF(B20=8,E41,E42))))))))","v":""}]
[{"$f":"TRUNC(A23/10)","v":0},{"$f":"TRUNC(RIGHT(A21))","v":0},{"$f":"IF(B20=1,B21+10,IF(B21=0,0,B21))","v":0},{"$f":"IF(AND(C21>9,C21<16),IF(C21=10,D34,IF(C21=11,D35,IF(C21=12,D36,IF(C21=13,D37,IF(C21=14,D38,IF(C21=15,D39,)))))),\"\")","v":""},{"$f":"IF(B21=1,A34,IF(B21=2,A35,IF(B21=3,A36,IF(B21=4,A37,IF(B21=5,A38,IF(B21=6,A39,IF(B21=7,A40,IF(B21=8,A41,A42))))))))","v":"девять "},{"$f":"IF(AND(C21>15,C21<20),IF(C21=16,D40,IF(C21=17,D41,IF(C21=18,D42,IF(C21=19,D43,)))),\"\")","v":""}]
[null,null,null,null,{"$f":"B21+B20*10+B19*100","v":0},{"$f":"IF(E22=0,\"\",IF(B20=1,\"миллионов \",IF(B21=1,\"миллион \",IF(OR(B21=2,B21=3,B21=4),\"миллиона \",\"миллионов \"))))","v":""}]
[{"$f":"TRUNC(A24/10)","v":0},{"$f":"TRUNC(RIGHT(A23))","v":0},{"$f":"B23","v":0},null,{"$f":"IF(B23=1,E43,IF(B23=2,G35,IF(B23=3,G36,IF(B23=4,G37,IF(B23=5,G38,IF(B23=6,G39,IF(B23=7,G40,IF(B23=8,G41,G42))))))))","v":"девятьсот "}]
[{"$f":"TRUNC(A25/10)","v":0},{"$f":"TRUNC(RIGHT(A24))","v":0},{"$f":"IF(B24=1,\"\",B24)","v":0},null,{"$f":"IF(OR(C24=0,B24=1),\"\",IF(B24=2,E35,IF(B24=3,E36,IF(B24=4,E37,IF(B24=5,E38,IF(B24=6,E39,IF(B24=7,E40,IF(B24=8,E41,E42))))))))","v":""}]
[{"$f":"TRUNC(A27/10)","v":5},{"$f":"TRUNC(RIGHT(A25))","v":5},{"$f":"IF(B24=1,B25+10,IF(B25=0,0,B25))","v":5},{"$f":"IF(AND(C25>9,C25<16),IF(C25=10,D34,IF(C25=11,D35,IF(C25=12,D36,IF(C25=13,D37,IF(C25=14,D38,IF(C25=15,D39,)))))),\"\")","v":""},{"$f":"IF(B25=1,B34,IF(B25=2,B35,IF(B25=3,A36,IF(B25=4,A37,IF(B25=5,A38,IF(B25=6,A39,IF(B25=7,A40,IF(B25=8,A41,A42))))))))","v":"пять "},{"$f":"IF(AND(C25>15,C25<20),IF(C25=16,D40,IF(C25=17,D41,IF(C25=18,D42,IF(C25=19,D43,)))),\"\")","v":""}]
[null,null,null,null,{"$f":"B23*100+B24*10+B25","v":5},{"$f":"IF(E26=0,\"\",IF(B24=1,\"тысяч \",IF(B25=1,\"тысяча \",IF(OR(B25=2,B25=3,B25=4),\"тысячи \",\"тысяч \"))))","v":"тысяч "}]
[{"$f":"TRUNC(A28/10)","v":50},{"$f":"TRUNC(RIGHT(A27))","v":0},{"$f":"B27","v":0},null,{"$f":"IF(B27=1,E43,IF(B27=2,G35,IF(B27=3,G36,IF(B27=4,G37,IF(B27=5,G38,IF(B27=6,G39,IF(B27=7,G40,IF(B27=8,G41,G42))))))))","v":"девятьсот "}]
[{"$f":"TRUNC(A29/10)","v":500},{"$f":"TRUNC(RIGHT(A28))","v":0},{"$f":"IF(B28=1,\"\",B28)","v":0},null,{"$f":"IF(OR(C28=0,B28=1),\"\",IF(C28=2,E35,IF(C28=3,E36,IF(C28=4,E37,IF(C28=5,E38,IF(C28=6,E39,IF(C28=7,E40,IF(C28=8,E41,E42))))))))","v":""}]
[{"$f":"E13","v":5000},{"$f":"TRUNC(RIGHT(A29))","v":0},{"$f":"IF(B28=1,B29+10,IF(B29=0,0,B29))","v":0},{"$f":"IF(AND(C29>9,C29<16),IF(C29=10,D34,IF(C29=11,D35,IF(C29=12,D36,IF(C29=13,D37,IF(C29=14,D38,IF(C29=15,D39,)))))),\"\")","v":""},{"$f":"IF(B29=1,A34,IF(B29=2,A35,IF(B29=3,A36,IF(B29=4,A37,IF(B29=5,A38,IF(B29=6,A39,IF(B29=7,A40,IF(B29=8,A41,A42))))))))","v":"девять "},{"$f":"IF(AND(C29>15,C29<20),IF(C29=16,D40,IF(C29=17,D41,IF(C29=18,D42,IF(C29=19,D43,)))),\"\")","v":""}]
[null,null,null,null,{"$f":"B27*100+B28*10+B29","v":0},{"$f":"IF(E30+E26+E22+E18=0,\"ноль рублей \",IF(C29=1,\"рубль \",IF(OR(C29=2,C29=3,C29=4),\"рубля \",\"рублей \")))","v":"рублей "}]
[{"$f":"ROUND(100*(E2-E13),0)","v":0},null,{"$f":"TRUNC(A31/10)","v":0},null,{"$f":"IF(OR(C31=1,C31=0),\"\",IF(C31=2,E35,IF(C31=3,E36,IF(C31=4,E37,IF(C31=5,E38,IF(C31=6,E39,IF(C31=7,E40,IF(C31=8,E41,E42))))))))","v":""}]
[null,null,{"$f":"TRUNC(A31-C31*10)","v":0},null,{"$f":"IF(C32=1,B34,IF(C32=2,B35,IF(C32=3,A36,IF(C32=4,A37,IF(C32=5,A38,IF(C32=6,A39,IF(C32=7,A40,IF(C32=8,A41,A42))))))))","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,"восемьсот "]
["девять ",null,null,"восемнадцать ","девяносто ",null,"девятьсот "]
[null,null,null,"девятнадцать ","сто "]

{"sheet":"PrintPolicy","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}