{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Параметры","График аренды"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["ПАРАМЕТРЫ МОДЕЛИ"]
["Минимальная дата периодов аренды",{"$f":"MIN('График аренды'!C:C)","v":"2020-01-01"}]
["Максимальная дата периодов аренды",{"$f":"EOMONTH(MAX('График аренды'!D:D),1)","v":"2022-03-31"}]

{"sheet":"График аренды","index":1,"n_rows":14,"n_cols":35,"rows_kept":14,"cut":false,"hidden":false,"merged":[[0,7,0,34]]}
["Календарный график аренды автомобилей",null,null,null,null,null,null,"Настраиваемый период аренды"]
["авто","стоимость аренды, руб./сут.","дата начала аренды","дата окончания аренды","длительность аренды, сут.","стоимость аренды за период, руб.",null,{"$f":"Параметры!B2","v":"2020-01-01"},{"$f":"IFERROR(IF(EOMONTH(H2,1)<=Параметры!$B$3,EOMONTH(H2,1),\"\"),\"\")","v":"2020-02-29"},{"$f":"IFERROR(IF(EOMONTH(I2,1)<=Параметры!$B$3,EOMONTH(I2,1),\"\"),\"\")","v":"2020-03-31"},{"$f":"IFERROR(IF(EOMONTH(J2,1)<=Параметры!$B$3,EOMONTH(J2,1),\"\"),\"\")","v":"2020-04-30"},{"$f":"IFERROR(IF(EOMONTH(K2,1)<=Параметры!$B$3,EOMONTH(K2,1),\"\"),\"\")","v":"2020-05-31"},{"$f":"IFERROR(IF(EOMONTH(L2,1)<=Параметры!$B$3,EOMONTH(L2,1),\"\"),\"\")","v":"2020-06-30"},{"$f":"IFERROR(IF(EOMONTH(M2,1)<=Параметры!$B$3,EOMONTH(M2,1),\"\"),\"\")","v":"2020-07-31"},{"$f":"IFERROR(IF(EOMONTH(N2,1)<=Параметры!$B$3,EOMONTH(N2,1),\"\"),\"\")","v":"2020-08-31"},{"$f":"IFERROR(IF(EOMONTH(O2,1)<=Параметры!$B$3,EOMONTH(O2,1),\"\"),\"\")","v":"2020-09-30"},{"$f":"IFERROR(IF(EOMONTH(P2,1)<=Параметры!$B$3,EOMONTH(P2,1),\"\"),\"\")","v":"2020-10-31"},{"$f":"IFERROR(IF(EOMONTH(Q2,1)<=Параметры!$B$3,EOMONTH(Q2,1),\"\"),\"\")","v":"2020-11-30"},{"$f":"IFERROR(IF(EOMONTH(R2,1)<=Параметры!$B$3,EOMONTH(R2,1),\"\"),\"\")","v":"2020-12-31"},{"$f":"IFERROR(IF(EOMONTH(S2,1)<=Параметры!$B$3,EOMONTH(S2,1),\"\"),\"\")","v":"2021-01-31"},{"$f":"IFERROR(IF(EOMONTH(T2,1)<=Параметры!$B$3,EOMONTH(T2,1),\"\"),\"\")","v":"2021-02-28"},{"$f":"IFERROR(IF(EOMONTH(U2,1)<=Параметры!$B$3,EOMONTH(U2,1),\"\"),\"\")","v":"2021-03-31"},{"$f":"IFERROR(IF(EOMONTH(V2,1)<=Параметры!$B$3,EOMONTH(V2,1),\"\"),\"\")","v":"2021-04-30"},{"$f":"IFERROR(IF(EOMONTH(W2,1)<=Параметры!$B$3,EOMONTH(W2,1),\"\"),\"\")","v":"2021-05-31"},{"$f":"IFERROR(IF(EOMONTH(X2,1)<=Параметры!$B$3,EOMONTH(X2,1),\"\"),\"\")","v":"2021-06-30"},{"$f":"IFERROR(IF(EOMONTH(Y2,1)<=Параметры!$B$3,EOMONTH(Y2,1),\"\"),\"\")","v":"2021-07-31"},{"$f":"IFERROR(IF(EOMONTH(Z2,1)<=Параметры!$B$3,EOMONTH(Z2,1),\"\"),\"\")","v":"2021-08-31"},{"$f":"IFERROR(IF(EOMONTH(AA2,1)<=Параметры!$B$3,EOMONTH(AA2,1),\"\"),\"\")","v":"2021-09-30"},{"$f":"IFERROR(IF(EOMONTH(AB2,1)<=Параметры!$B$3,EOMONTH(AB2,1),\"\"),\"\")","v":"2021-10-31"},{"$f":"IFERROR(IF(EOMONTH(AC2,1)<=Параметры!$B$3,EOMONTH(AC2,1),\"\"),\"\")","v":"2021-11-30"},{"$f":"IFERROR(IF(EOMONTH(AD2,1)<=Параметры!$B$3,EOMONTH(AD2,1),\"\"),\"\")","v":"2021-12-31"},{"$f":"IFERROR(IF(EOMONTH(AE2,1)<=Параметры!$B$3,EOMONTH(AE2,1),\"\"),\"\")","v":"2022-01-31"},{"$f":"IFERROR(IF(EOMONTH(AF2,1)<=Параметры!$B$3,EOMONTH(AF2,1),\"\"),\"\")","v":"2022-02-28"},{"$f":"IFERROR(IF(EOMONTH(AG2,1)<=Параметры!$B$3,EOMONTH(AG2,1),\"\"),\"\")","v":"2022-03-31"},{"$f":"IFERROR(IF(EOMONTH(AH2,1)<=Параметры!$B$3,EOMONTH(AH2,1),\"\"),\"\")","v":""}]
["ГАЗ \"Волга\"",1000,"2021-02-16","2021-08-28",{"$f":"D3-C3+1","v":194},{"$f":"E3*B3","v":194000},null,{"$f":"TimeWithinRent(H$2,$C3,$D3)","v":"-"},{"$f":"TimeWithinRent(I$2,$C3,$D3)","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","+","+","-","-","-","-","-",{"$f":"TimeWithinRent(AG$2,$C3,$D3)","v":"-"},"-"]
["BMW",1500,"2021-03-16","2021-05-15",{"$f":"D4-C4+1","v":61},{"$f":"E4*B4","v":91500},null,{"$f":"TimeWithinRent(H$2,$C4,$D4)","v":"-"},"-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","-","-","-","-","-","-","-","-","-","-"]
["Renault",1400,"2020-01-01","2021-02-02",399,558600,null,"+","+","+","+","+","+","+","+","+","+","+","+","+","+","-","-","-","-","-","-","-","-","-","-","-","-","-"]
["Audi",1800,"2021-05-11","2021-12-09",213,383400,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","+","+","+","-","-","-"]
["ВАЗ",1000,"2021-07-18","2022-01-01",168,168000,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","+","+","-","-"]
["Cadillac",1700,"2021-01-31","2021-07-04",155,263500,null,"-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","+","+","-","-","-","-","-","-","-","-"]
["Honda",1200,"2021-04-10","2021-08-20",133,159600,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","-","-","-","-","-","-","-"]
["Mazda",1300,"2021-03-06","2021-05-25",81,105300,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","-","-","-","-","-","-","-","-","-","-"]
["Opel",1400,"2020-02-21","2021-03-29",403,564200,null,"-","+","+","+","+","+","+","+","+","+","+","+","+","+","+","-","-","-","-","-","-","-","-","-","-","-","-"]
["Ford",1800,"2021-06-19","2021-12-19",184,331200,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","+","+","-","-","-"]
["Fiat",1600,"2021-10-17","2022-02-09",116,185600,null,"-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","-","+","+","+","+","+","-"]
["Dodge ",1000,"2021-01-03","2021-07-04",183,183000,null,"-","-","-","-","-","-","-",{"$f":"TimeWithinRent(O$2,$C14,$D14)","v":"-"},"-","-","-","-","+","+","+","+","+","+","+","-","-","-","-","-","-","-","-"]