{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Quotatore","EXTRA","parametri","SL","GL","OL","DSU","TPU","Assistenza"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":206,"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":"Quotatore","index":0,"n_rows":153,"n_cols":28,"rows_kept":153,"cut":false,"hidden":false,"merged":[[91,24,91,25],[91,26,91,27],[109,1,109,2],[111,1,111,19],[110,3,110,19],[110,1,110,2],[95,2,95,5],[97,2,97,5],[99,2,99,5],[101,2,101,5],[103,2,103,5],[95,12,95,14],[85,4,85,18],[105,12,105,16],[140,4,140,18],[151,4,151,18],[132,4,132,18],[112,1,112,19],[113,1,113,19],[97,12,97,14],[99,12,99,14],[101,12,101,14],[11,6,11,18],[41,4,41,18],[58,4,58,18],[77,4,77,18],[49,4,49,18],[22,0,22,20]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2023-12-31"]
[]
[]
[]
[]
[]
[]
[null,null,"TIPOLOGIA PRODOTTO",null,"Rimborso spese mediche",null,"DATA EFFETTO",null,{"$f":"TODAY()","v":"2023-01-16"}]
[]
[null,null,"N. ASSICURATI",null,1]
[]
[null,null,"SCONTO NUCLEO",null,"NO",null,"Lo sconto nucleo è concedibile se si assicura la totalità  del nucleo familiare come risultante da stato di  famiglia con la possibilità di includere anche i  figli non conviventi fino all'indipendenza  economica comunque non oltre i 30 anni, purchè  residenti in italia."]
[]
[]
[]
[null,null,"ASSICURATO",null,"Assicurato 1",null,{"$f":"IF($E$10>=2,\"Assicurato 2\",\"\")","v":""},null,{"$f":"IF($E$10>=3,\"Assicurato 3\",\"\")","v":""},null,{"$f":"IF($E$10>=4,\"Assicurato 4\",\"\")","v":""},null,{"$f":"IF($E$10>=5,\"Assicurato 5\",\"\")","v":""},null,{"$f":"IF($E$10>=6,\"Assicurato 6\",\"\")","v":""},null,{"$f":"IF($E$10>=7,\"Assicurato 7\",\"\")","v":""},null,{"$f":"IF($E$10>=8,\"Assicurato 8\",\"\")","v":""}]
[]
[null,null,"DATA NASCITA",null,"1969-07-30"]
[]
[null,null,"ETÀ",null,{"$f":"IF(c_datanascita1<>\"\",DATEDIF(c_datanascita1,c_dataeffetto,\"y\"),\"\")","v":53},null,{"$f":"IF(c_datanascita2<>\"\",DATEDIF(c_datanascita2,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita3<>\"\",DATEDIF(c_datanascita3,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita4<>\"\",DATEDIF(c_datanascita4,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita5<>\"\",DATEDIF(c_datanascita5,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita6<>\"\",DATEDIF(c_datanascita6,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita7<>\"\",DATEDIF(c_datanascita7,c_dataeffetto,\"y\"),\"\")","v":""},null,{"$f":"IF(c_datanascita8<>\"\",DATEDIF(c_datanascita8,c_dataeffetto,\"y\"),\"\")","v":""}]
[]
[]
[{"$f":"IF(OR(AND(E28<>\"\",E28<>parametri!$C$3,E28<>parametri!$C$4,E28<>parametri!$C$5,E28<>parametri!$C$6,E28<>parametri!$C$7),AND(G28<>\"\",G28<>parametri!$C$3,G28<>parametri!$C$4,G28<>parametri!$C$5,G28<>parametri!$C$6,G28<>parametri!$C$7),AND(I28<>\"\",I28<>parametri!$C$3,I28<>parametri!$C$4,I28<>parametri!$C$5,I28<>parametri!$C$6,I28<>parametri!$C$7),AND(K28<>\"\",K28<>parametri!$C$3,K28<>parametri!$C$4,K28<>parametri!$C$5,K28<>parametri!$C$6,K28<>parametri!$C$7),AND(M28<>\"\",M28<>parametri!$C$3,M28<>parametri!$C$4,M28<>parametri!$C$5,M28<>parametri!$C$6,M28<>parametri!$C$7),AND(O28<>\"\",O28<>parametri!$C$3,O28<>parametri!$C$4,O28<>parametri!$C$5,O28<>parametri!$C$6,O28<>parametri!$C$7),AND(Q28<>\"\",Q28<>parametri!$C$3,Q28<>parametri!$C$4,Q28<>parametri!$C$5,Q28<>parametri!$C$6,Q28<>parametri!$C$7),AND(S28<>\"\",S28<>parametri!$C$3,S28<>parametri!$C$4,S28<>parametri!$C$5,S28<>parametri!$C$6,S28<>parametri!$C$7),AND(E32<>\"\",E32<>parametri!$K$3,E32<>parametri!$K$4,E32<>parametri!$K$5),AND(G32<>\"\",G32<>parametri!$K$3,G32<>parametri!$K$4,G32<>parametri!$K$5),AND(I32<>\"\",I32<>parametri!$K$3,I32<>parametri!$K$4,I32<>parametri!$K$5),AND(K32<>\"\",K32<>parametri!$K$3,K32<>parametri!$K$4,K32<>parametri!$K$5),AND(M32<>\"\",M32<>parametri!$K$3,M32<>parametri!$K$4,M32<>parametri!$K$5),AND(O32<>\"\",O32<>parametri!$K$3,O32<>parametri!$K$4,O32<>parametri!$K$5),AND(Q32<>\"\",Q32<>parametri!$K$3,Q32<>parametri!$K$4,Q32<>parametri!$K$5),AND(S32<>\"\",S32<>parametri!$K$3,S32<>parametri!$K$4,S32<>parametri!$K$5)),\"Entrare nelle celle evidenziate in rosso per aggiornare i massimali\",\"\")","v":""}]
[null,null,"RIMBORSO SPESE MEDICHE"]
[]
[null,"SEZIONE MALATTIE",null,null,{"$f":"E$16","v":"Assicurato 1"},null,{"$f":"G$16","v":""},null,{"$f":"I$16","v":""},null,{"$f":"K$16","v":""},null,{"$f":"M$16","v":""},null,{"$f":"O$16","v":""},null,{"$f":"Q$16","v":""},null,{"$f":"S$16","v":""}]
[]
[null,null,"RIMBORSO SPESE MEDICHE",null,"SILVER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"c_normal","v":"NORMAL"}]
[]
[null,null,"RADDOPPIO PRESTAZIONI PER GRANDI INTERVENTI ",null,"NO"]
[]
[null,null,"PRESTAZIONE INTEGRATIVA PER INTERVENTI CHIRURGICI",null,"NO"]
[]
[null,null,"Scoperto fuori network",null,"NO"]
[]
[null,null,"Franchigia",null,"NO"]
[]
[null,null,"Retta per l'accompagnatore",null,"NO"]
[]
[null,null,"Spese pre/post ricovero senza int",null,"NO"]
[]
[null,null,"Premio netto",null,{"$f":"SUM(E119:S121)","v":4305.33}]
[]
[]
[]
[null,"SEZIONE ASSISTENZA",null,null,{"$f":"E$16","v":"Assicurato 1"},null,{"$f":"G$16","v":""},null,{"$f":"I$16","v":""},null,{"$f":"K$16","v":""},null,{"$f":"M$16","v":""},null,{"$f":"O$16","v":""},null,{"$f":"Q$16","v":""},null,{"$f":"S$16","v":""}]
[]
[null,null,"ASSISTENZA",null,{"$f":"IF($E$8=c_rsm,\"SI\",\"NO\")","v":"SI"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=2),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=3),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=4),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=5),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=6),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=7),\"SI\",\"NO\")","v":"NO"},null,{"$f":"IF(AND($E$8=c_rsm,$E$10>=8),\"SI\",\"NO\")","v":"NO"}]
[]
[null,null,"Premio netto",null,{"$f":"SUM(E122:S122)","v":16.53}]
[]
[null,null,"SOLUZIONE EXTRARICOVERO"]
[]
[null,"SEZIONE MALATTIE",null,null,{"$f":"E$16","v":"Assicurato 1"},null,{"$f":"G$16","v":""},null,{"$f":"I$16","v":""},null,{"$f":"K$16","v":""},null,{"$f":"M$16","v":""},null,{"$f":"O$16","v":""},null,{"$f":"Q$16","v":""},null,{"$f":"S$16","v":""}]
[]
[null,null,"VISITE SPECIALISTICHE E ACCERTAMENTI DIAGNOSTICI",null,"Deluxe"]
[null,null,"Rinuncia alla forma diretta",null,"NO"]
[]
[null,null,"Premio netto",null,{"$f":"SUM(E136:S136)","v":322.86}]
[]
[]
[]
[null,null,"DIARIA"]
[]
[null,"SEZIONE MALATTIE",null,null,{"$f":"E$16","v":"Assicurato 1"},null,{"$f":"G$16","v":""},null,{"$f":"I$16","v":""},null,{"$f":"K$16","v":""},null,{"$f":"M$16","v":""},null,{"$f":"O$16","v":""},null,{"$f":"Q$16","v":""},null,{"$f":"S$16","v":""}]
[]
[]
[null,null,"DIARIA"]
[]
[null,null,"Tipo diaria"]
[]
[null,null,"Diaria per l'accompagnatore"]
[]
[null,null,"Convalescenza da malattia/parto"]
[]
[null,null,"Ingessatura"]
[]
[null,null,"Premio netto",null,{"$f":"SUM(E144:S144)","v":0}]
[]
[]
[]
[null,"SEZIONE ASSISTENZA",null,null,{"$f":"E$16","v":"Assicurato 1"},null,{"$f":"G$16","v":""},null,{"$f":"I$16","v":""},null,{"$f":"K$16","v":""},null,{"$f":"M$16","v":""},null,{"$f":"O$16","v":""},null,{"$f":"Q$16","v":""},null,{"$f":"S$16","v":""}]
[]
[null,null,"ASSISTENZA"]
[]
[null,null,"Premio netto",null,{"$f":"SUM(E145:S145)","v":0}]
[]
[]
[]
[null,null,{"$f":"IF(c_prodotto=c_rsm,\"RIMBORSO SPESE MEDICHE\",IF(c_prodotto=c_diaria,\"DIARIA\",\"\"))","v":"RIMBORSO SPESE MEDICHE"},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(c_prodotto=c_rsm,T134>=1),\"SOLUZIONE ETRARICOVERO\",\"\")","v":"SOLUZIONE ETRARICOVERO"}]
[]
[null,null,"DIRITTI",null,"NO",null,null,null,null,null,null,null,"DIRITTI",null,"NO",null,null,null,null,null,null,null,null,null,"ANNUO",null,"FRAZ con INT"]
[]
[null,null,"FRAZIONAMENTO",null,"Annuale",null,"Annuo",null,"di Rata",null,null,null,"FRAZIONAMENTO",null,"Annuale",null,"Annuo",null,"di Rata",null,null,null,null,null,"MALATTIA","ASSISTENZA","MALATTIA","ASSISTENZA"]
[]
[null,null,"PREMIO NETTO",null,null,null,{"$f":"IF(c_prodotto=c_rsm,SUM(E119:S122),IF(c_prodotto=c_diaria,SUM(E144:S145),0))","v":4321.8599999999997},null,{"$f":"ROUND(G96/VLOOKUP(c_fraz,t_fraz,3,FALSE),2)","v":4321.8599999999997},null,null,null,"PREMIO NETTO ANNUO",null,null,null,{"$f":"SUM($E$136:$S$136)","v":322.86},null,{"$f":"ROUND(Q96/VLOOKUP(c_frazextra,t_fraz,3,FALSE),2)","v":322.86},null,null,null,null,null,{"$f":"IF(c_prodotto=c_rsm,SUM(E119:S121),IF(c_prodotto=c_diaria,SUM(E144:S144),0))","v":4305.33},{"$f":"IF(c_prodotto=c_rsm,SUM(E122:S122),IF(c_prodotto=c_diaria,SUM(E145:S145),0))","v":16.53},{"$f":"ROUND(Y96*(1+VLOOKUP(c_fraz,t_fraz,2,FALSE)),2)","v":4305.33},{"$f":"ROUND(Z96*(1+VLOOKUP(c_fraz,t_fraz,2,FALSE)),2)","v":16.53}]
[]
[null,null,"ACCESSORI",null,null,null,{"$f":"IF(c_prodotto=c_rsm,SUM(E124:S127),IF(c_prodotto=c_diaria,SUM(E147:S148),0))","v":432.17999999999995},null,{"$f":"ROUND(G98/VLOOKUP(c_fraz,t_fraz,3,FALSE),2)","v":432.18},null,null,null,"ACCESSORI",null,null,null,{"$f":"SUM($E$138:$S$138)","v":32.29},null,{"$f":"ROUND(Q98/VLOOKUP(c_frazextra,t_fraz,3,FALSE),2)","v":32.29},null,null,null,null,null,{"$f":"IF(c_prodotto=c_rsm,SUM(E124:S126),IF(c_prodotto=c_diaria,SUM(E147:S147),0))","v":430.53},{"$f":"IF(c_prodotto=c_rsm,SUM(E127:S127),IF(c_prodotto=c_diaria,SUM(E148:S148),0))","v":1.65},{"$f":"ROUND(Y98*(1+VLOOKUP(c_fraz,t_fraz,2,FALSE)),2)","v":430.53},{"$f":"ROUND(Z98*(1+VLOOKUP(c_fraz,t_fraz,2,FALSE)),2)","v":1.65}]
[]
[null,null,"DIRITTI",null,null,null,{"$f":"IF(E92=\"SI\",MIN(ROUND(10%*(G96+G98),2),65),0)","v":0},null,{"$f":"ROUND(G100/VLOOKUP(c_fraz,t_fraz,3,FALSE),2)","v":0},null,null,null,"DIRITTI",null,null,null,{"$f":"IF(O92=\"SI\",MIN(ROUND(10%*(Q96+Q98),2),65),0)","v":0},null,{"$f":"ROUND(Q100/VLOOKUP(c_frazextra,t_fraz,3,FALSE),2)","v":0},null,null,null,null,null,null,null,{"$f":"ROUND(G100*SUM(AA96:AA98)/SUM(AA96:AB98),2)","v":0},{"$f":"G100-AA100","v":0}]
[]
[null,null,"Interessi di frazionamento",null,null,null,{"$f":"IF(c_fraz=parametri!$V$3,0,ROUND(3%*(G96+G98),2))","v":0},null,{"$f":"ROUND(G102/VLOOKUP(c_fraz,t_fraz,3,FALSE),2)","v":0},null,null,null,"IMPOSTE",null,null,null,{"$f":"SUM($E$140:$S$141)","v":8.8800000000000008},null,{"$f":"ROUND(Q102/VLOOKUP(c_frazextra,t_fraz,3,FALSE),2)","v":8.8800000000000008}]
[]
[null,null,"IMPOSTE",null,null,null,null,null,{"$f":"ROUND((ROUND(SUM(AA96:AA98,AA100)*2.5%,2)+ROUND(SUM(AB96:AB98,AB100)*10%,2))/VLOOKUP(c_fraz,t_fraz,3,FALSE),2)","v":120.22}]
[]
[null,null,"PREMIO LORDO DI RATA FINITO",null,null,null,null,null,{"$f":"SUM(I96,I98,I100,I102,I104)","v":4874.26},null,null,null,"PREMIO LORDO DI RATA FINITO",null,null,null,null,null,{"$f":"ROUND(SUM(Q96,Q98,Q100,Q102)/VLOOKUP(c_frazextra,t_fraz,3,FALSE),3)","v":364.03}]
[]
[]
[]
[null,{"$f":"TODAY()","v":"2023-01-16"}]
[null,"NOTE :"]
[null,""]
[null,""]
[null,""]
[]
[]
[null,null,"RIMBORSO SPESE MEDICHE"]
[null,null,"NETTO",null,"Assicurato 1",null,"Assicurato 2",null,"Assicurato 3",null,"Assicurato 4",null,"Assicurato 5",null,"Assicurato 6",null,"Assicurato 7",null,"Assicurato 8"]
[null,null,"rimborso spese mediche",null,{"$f":"ROUND(IF($E$8=c_rsm,ROUND(VLOOKUP(IF(ISBLANK(D$28),c_eta1,D$28),t_sl,VLOOKUP(LEFT(E$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(E$34=\"SI\",1-10%,1)*IF(E$36<>\"NO\",1-VLOOKUP(E$36,t_franchigia,2,FALSE),1)*IF(E$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(E$40=\"SI\",1+5%,1),0),2)*(1+E$29)","v":4305.33},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta2<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(F$28),c_eta2,F$28),t_sl,VLOOKUP(LEFT(G$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(G$34=\"SI\",1-10%,1)*IF(G$36<>\"NO\",1-VLOOKUP(G$36,t_franchigia,2,FALSE),1)*IF(G$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(G$40=\"SI\",1+5%,1),0),2)*(1+G$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta3<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(H$28),c_eta3,H$28),t_sl,VLOOKUP(LEFT(I$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(I$34=\"SI\",1-10%,1)*IF(I$36<>\"NO\",1-VLOOKUP(I$36,t_franchigia,2,FALSE),1)*IF(I$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(I$40=\"SI\",1+5%,1),0),2)*(1+I$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta4<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(J$28),c_eta4,J$28),t_sl,VLOOKUP(LEFT(K$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(K$34=\"SI\",1-10%,1)*IF(K$36<>\"NO\",1-VLOOKUP(K$36,t_franchigia,2,FALSE),1)*IF(K$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(K$40=\"SI\",1+5%,1),0),2)*(1+K$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta5<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(L$28),c_eta5,L$28),t_sl,VLOOKUP(LEFT(M$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(M$34=\"SI\",1-10%,1)*IF(M$36<>\"NO\",1-VLOOKUP(M$36,t_franchigia,2,FALSE),1)*IF(M$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(M$40=\"SI\",1+5%,1),0),2)*(1+M$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta6<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(N$28),c_eta6,N$28),t_sl,VLOOKUP(LEFT(O$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(O$34=\"SI\",1-10%,1)*IF(O$36<>\"NO\",1-VLOOKUP(O$36,t_franchigia,2,FALSE),1)*IF(O$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(O$40=\"SI\",1+5%,1),0),2)*(1+O$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta7<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(P$28),c_eta7,P$28),t_sl,VLOOKUP(LEFT(Q$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(Q$34=\"SI\",1-10%,1)*IF(Q$36<>\"NO\",1-VLOOKUP(Q$36,t_franchigia,2,FALSE),1)*IF(Q$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(Q$40=\"SI\",1+5%,1),0),2)*(1+Q$29)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta8<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(R$28),c_eta8,R$28),t_sl,VLOOKUP(LEFT(S$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(S$34=\"SI\",1-10%,1)*IF(S$36<>\"NO\",1-VLOOKUP(S$36,t_franchigia,2,FALSE),1)*IF(S$38=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(S$40=\"SI\",1+5%,1),0),2)*(1+S$29)","v":0}]
[null,null,"raddoppio prestazioni per grandi interventi ",null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl1=\"SI\"),ROUND(VLOOKUP(IF(ISBLANK(D$30),c_eta1,D$30),t_gl,VLOOKUP(LEFT(E$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(E$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+E$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl2=\"SI\",c_eta2<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(F$30),c_eta2,F$30),t_gl,VLOOKUP(LEFT(G$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(G$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+G$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl3=\"SI\",c_eta3<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(H$30),c_eta3,H$30),t_gl,VLOOKUP(LEFT(I$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(I$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+I$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl4=\"SI\",c_eta4<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(J$30),c_eta4,J$30),t_gl,VLOOKUP(LEFT(K$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(K$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+K$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl5=\"SI\",c_eta5<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(L$30),c_eta5,L$30),t_gl,VLOOKUP(LEFT(M$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(M$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+M$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl6=\"SI\",c_eta6<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(N$30),c_eta6,N$30),t_gl,VLOOKUP(LEFT(O$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(O$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+O$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl7=\"SI\",c_eta7<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(P$30),c_eta7,P$30),t_gl,VLOOKUP(LEFT(Q$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(Q$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+Q$31)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_gl8=\"SI\",c_eta8<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(R$30),c_eta8,R$30),t_gl,VLOOKUP(LEFT(S$28,3)&\"*\",t_cv_rsm,2,FALSE),FALSE)*c_indicetot,2)*IF(S$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+S$31)","v":0}]
[null,null,"prestazione integrativa per interventi chirurgici",null,{"$f":"ROUND(IF(AND($E$8=c_rsm,E$32<>\"NO\"),ROUND(VLOOKUP(IF(ISBLANK(D$32),c_eta1,D$32),t_ol,VLOOKUP(LEFT(E$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(E$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+E$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,G$32<>\"NO\",c_eta2<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(F$32),c_eta2,F$32),t_ol,VLOOKUP(LEFT(G$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(G$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+G$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,I$32<>\"NO\",c_eta3<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(H$32),c_eta3,H$32),t_ol,VLOOKUP(LEFT(I$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(I$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+I$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,K$32<>\"NO\",c_eta4<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(J$32),c_eta4,J$32),t_ol,VLOOKUP(LEFT(K$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(K$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+K$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,M$32<>\"NO\",c_eta5<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(L$32),c_eta5,L$32),t_ol,VLOOKUP(LEFT(M$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(M$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+M$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,O$32<>\"NO\",c_eta6<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(N$32),c_eta6,N$32),t_ol,VLOOKUP(LEFT(O$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(O$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+O$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,Q$32<>\"NO\",c_eta7<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(P$32),c_eta7,P$32),t_ol,VLOOKUP(LEFT(Q$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(Q$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+Q$33)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,S$32<>\"NO\",c_eta8<>\"\"),ROUND(VLOOKUP(IF(ISBLANK(R$32),c_eta8,R$32),t_ol,VLOOKUP(LEFT(S$32,9)&\"*\",parametri!$K$3:$L$5,2,FALSE),FALSE)*c_indicetot,2)*IF(S$34=\"SI\",1-10%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1),0),2)*(1+S$33)","v":0}]
[null,null,"assistenza",null,{"$f":"IF($E$8=c_rsm,c_ass_rsm,0)","v":16.53},null,{"$f":"IF(AND($E$8=c_rsm,c_eta2<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta3<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta4<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta5<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta6<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta7<>\"\"),c_ass_rsm,0)","v":0},null,{"$f":"IF(AND($E$8=c_rsm,c_eta8<>\"\"),c_ass_rsm,0)","v":0}]
[null,null,"accessori"]
[null,null,"rimborso spese mediche",null,{"$f":"ROUND(E119*10%,2)","v":430.53},null,{"$f":"ROUND(G119*10%,2)","v":0},null,{"$f":"ROUND(I119*10%,2)","v":0},null,{"$f":"ROUND(K119*10%,2)","v":0},null,{"$f":"ROUND(M119*10%,2)","v":0},null,{"$f":"ROUND(O119*10%,2)","v":0},null,{"$f":"ROUND(Q119*10%,2)","v":0},null,{"$f":"ROUND(S119*10%,2)","v":0}]
[null,null,"raddoppio prestazioni per grandi interventi ",null,{"$f":"ROUND(E120*10%,2)","v":0},null,{"$f":"ROUND(G120*10%,2)","v":0},null,{"$f":"ROUND(I120*10%,2)","v":0},null,{"$f":"ROUND(K120*10%,2)","v":0},null,{"$f":"ROUND(M120*10%,2)","v":0},null,{"$f":"ROUND(O120*10%,2)","v":0},null,{"$f":"ROUND(Q120*10%,2)","v":0},null,{"$f":"ROUND(S120*10%,2)","v":0}]
[null,null,"prestazione integrativa per interventi chirurgici",null,{"$f":"ROUND(E121*10%,2)","v":0},null,{"$f":"ROUND(G121*10%,2)","v":0},null,{"$f":"ROUND(I121*10%,2)","v":0},null,{"$f":"ROUND(K121*10%,2)","v":0},null,{"$f":"ROUND(M121*10%,2)","v":0},null,{"$f":"ROUND(O121*10%,2)","v":0},null,{"$f":"ROUND(Q121*10%,2)","v":0},null,{"$f":"ROUND(S121*10%,2)","v":0}]
[null,null,"assistenza",null,{"$f":"ROUND(E122*10%,2)","v":1.65},null,{"$f":"ROUND(G122*10%,2)","v":0},null,{"$f":"ROUND(I122*10%,2)","v":0},null,{"$f":"ROUND(K122*10%,2)","v":0},null,{"$f":"ROUND(M122*10%,2)","v":0},null,{"$f":"ROUND(O122*10%,2)","v":0},null,{"$f":"ROUND(Q122*10%,2)","v":0},null,{"$f":"ROUND(S122*10%,2)","v":0}]
[null,null,"imposte"]
[null,null,"rimborso spese mediche",null,{"$f":"ROUND(SUM(E119+E124)*2.5%,2)","v":118.4},null,{"$f":"ROUND(SUM(G119+G124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(I119+I124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(K119+K124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(M119+M124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(O119+O124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(Q119+Q124)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(S119+S124)*2.5%,2)","v":0}]
[null,null,"raddoppio prestazioni per grandi interventi ",null,{"$f":"ROUND(SUM(E120+E125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(G120+G125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(I120+I125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(K120+K125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(M120+M125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(O120+O125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(Q120+Q125)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(S120+S125)*2.5%,2)","v":0}]
[null,null,"prestazione integrativa per interventi chirurgici",null,{"$f":"ROUND(SUM(E121+E126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(G121+G126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(I121+I126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(K121+K126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(M121+M126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(O121+O126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(Q121+Q126)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(S121+S126)*2.5%,2)","v":0}]
[null,null,"assistenza",null,{"$f":"ROUND(SUM(E122+E127)*10%,2)","v":1.82},null,{"$f":"ROUND(SUM(G122+G127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(I122+I127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(K122+K127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(M122+M127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(O122+O127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(Q122+Q127)*10%,2)","v":0},null,{"$f":"ROUND(SUM(S122+S127)*10%,2)","v":0}]
[null,null,"diritti",null,{"$f":"ROUND(SUM(E119:S121,E124:S126)/SUM(E119:S122,E124:S127)*G100*2.5%,2)+ROUND(SUM(E122:S122,E127:S127)/SUM(E119:S122,E124:S127)*G100*10%,2)","v":0}]
[null,null,"SOLUZIONE EXTRARICOVERO",null,{"$f":"IF(OR(E$56=\"Comfort\",E$56=\"Deluxe\"),1,0)","v":1},null,{"$f":"IF(OR(G$56=\"Comfort\",G$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(I$56=\"Comfort\",I$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(K$56=\"Comfort\",K$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(M$56=\"Comfort\",M$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(O$56=\"Comfort\",O$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(Q$56=\"Comfort\",Q$56=\"Deluxe\"),1,0)","v":0},null,{"$f":"IF(OR(S$56=\"Comfort\",S$56=\"Deluxe\"),1,0)","v":0},{"$f":"SUM(E134:S134)","v":1}]
[null,null,"netto",null,"Assicurato 1",null,"Assicurato 2",null,"Assicurato 3",null,"Assicurato 4",null,"Assicurato 5",null,"Assicurato 6",null,"Assicurato 7",null,"Assicurato 8"]
[null,null,"visite specialistiche \ne accertamenti diagnostici",null,{"$f":"ROUND(IF(AND($E$8=c_rsm,E$56<>\"NO\"),ROUND(VLOOKUP(c_eta1,t_extra,VLOOKUP(E$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)*IF(E$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":322.86},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta2<>\"\",G$56<>\"NO\"),ROUND(VLOOKUP(c_eta2,t_extra,VLOOKUP(G$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(G$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta3<>\"\",I$56<>\"NO\"),ROUND(VLOOKUP(c_eta3,t_extra,VLOOKUP(I$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(I$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta4<>\"\",K$56<>\"NO\"),ROUND(VLOOKUP(c_eta4,t_extra,VLOOKUP(K$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(K$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta5<>\"\",M$56<>\"NO\"),ROUND(VLOOKUP(c_eta5,t_extra,VLOOKUP(M$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(M$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta6<>\"\",O$56<>\"NO\"),ROUND(VLOOKUP(c_eta6,t_extra,VLOOKUP(O$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(O$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta7<>\"\",Q$56<>\"NO\"),ROUND(VLOOKUP(c_eta7,t_extra,VLOOKUP(Q$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(Q$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_rsm,c_eta8<>\"\",S$56<>\"NO\"),ROUND(VLOOKUP(c_eta8,t_extra,VLOOKUP(S$56,t_cv_extra,2,FALSE),FALSE)*c_indicetot_extra,2)     *IF(S$57=\"SI\",1-17%,1),0),2)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)","v":0}]
[null,null,"accessori"]
[null,null,"visite specialistiche \ne accertamenti diagnostici",null,{"$f":"ROUND(E136*10%,2)","v":32.29},null,{"$f":"ROUND(G136*10%,2)","v":0},null,{"$f":"ROUND(I136*10%,2)","v":0},null,{"$f":"ROUND(K136*10%,2)","v":0},null,{"$f":"ROUND(M136*10%,2)","v":0},null,{"$f":"ROUND(O136*10%,2)","v":0},null,{"$f":"ROUND(Q136*10%,2)","v":0},null,{"$f":"ROUND(S136*10%,2)","v":0}]
[null,null,"imposte"]
[null,null,"visite specialistiche \ne accertamenti diagnostici",null,{"$f":"ROUND(SUM(E136+E138)*2.5%,2)","v":8.8800000000000008},null,{"$f":"ROUND(SUM(G136+G138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(I136+I138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(K136+K138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(M136+M138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(O136+O138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(Q136+Q138)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(S136+S138)*2.5%,2)","v":0}]
[null,null,"diritti"]
[null,null,"DIARIA"]
[null,null,"netto",null,"Assicurato 1",null,"Assicurato 2",null,"Assicurato 3",null,"Assicurato 4",null,"Assicurato 5",null,"Assicurato 6",null,"Assicurato 7",null,"Assicurato 8"]
[null,null,"diaria",null,{"$f":"ROUND(IF($E$8=c_diaria,VLOOKUP(c_eta1,IF(E$68=c_standard,t_dsu,t_tpu),VLOOKUP(E$70,t_cv_diaria,2,FALSE),FALSE)*IF(E$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(E$68=c_standard,E$74=\"SI\"),1+30%,1)*IF(AND(E$68=c_standard,E$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta2<>\"\"),VLOOKUP(c_eta2,IF(G$68=c_standard,t_dsu,t_tpu),VLOOKUP(G$70,t_cv_diaria,2,FALSE),FALSE)*IF(G$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(G$68=c_standard,G$74=\"SI\"),1+30%,1)*IF(AND(G$68=c_standard,G$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta3<>\"\"),VLOOKUP(c_eta3,IF(I$68=c_standard,t_dsu,t_tpu),VLOOKUP(I$70,t_cv_diaria,2,FALSE),FALSE)*IF(I$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(I$68=c_standard,I$74=\"SI\"),1+30%,1)*IF(AND(I$68=c_standard,I$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta4<>\"\"),VLOOKUP(c_eta4,IF(K$68=c_standard,t_dsu,t_tpu),VLOOKUP(K$70,t_cv_diaria,2,FALSE),FALSE)*IF(K$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(K$68=c_standard,K$74=\"SI\"),1+30%,1)*IF(AND(K$68=c_standard,K$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta5<>\"\"),VLOOKUP(c_eta5,IF(M$68=c_standard,t_dsu,t_tpu),VLOOKUP(M$70,t_cv_diaria,2,FALSE),FALSE)*IF(M$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(M$68=c_standard,M$74=\"SI\"),1+30%,1)*IF(AND(M$68=c_standard,M$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta6<>\"\"),VLOOKUP(c_eta6,IF(O$68=c_standard,t_dsu,t_tpu),VLOOKUP(O$70,t_cv_diaria,2,FALSE),FALSE)*IF(O$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(O$68=c_standard,O$74=\"SI\"),1+30%,1)*IF(AND(O$68=c_standard,O$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta7<>\"\"),VLOOKUP(c_eta7,IF(Q$68=c_standard,t_dsu,t_tpu),VLOOKUP(Q$70,t_cv_diaria,2,FALSE),FALSE)*IF(Q$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(Q$68=c_standard,Q$74=\"SI\"),1+30%,1)*IF(AND(Q$68=c_standard,Q$76=\"SI\"),1+10%,1),0),2)","v":0},null,{"$f":"ROUND(IF(AND($E$8=c_diaria,c_eta8<>\"\"),VLOOKUP(c_eta8,IF(S$68=c_standard,t_dsu,t_tpu),VLOOKUP(S$70,t_cv_diaria,2,FALSE),FALSE)*IF(S$72=\"SI\",1+5%,1)*IF($E$12<>\"NO\",1-VLOOKUP($E$10,t_nucleo,2,FALSE),1)*IF(AND(S$68=c_standard,S$74=\"SI\"),1+30%,1)*IF(AND(S$68=c_standard,S$76=\"SI\"),1+10%,1),0),2)","v":0}]
[null,null,"assistenza",null,{"$f":"IF(AND($E$8=c_diaria,E$84=\"SI\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,G$84=\"SI\",G20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,I$84=\"SI\",I20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,K$84=\"SI\",K20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,M$84=\"SI\",M20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,O$84=\"SI\",O20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,Q$84=\"SI\",Q20<>\"\"),c_ass_diaria,0)","v":0},null,{"$f":"IF(AND($E$8=c_diaria,S$84=\"SI\",S20<>\"\"),c_ass_diaria,0)","v":0}]
[null,null,"accessori"]
[null,null,"diaria",null,{"$f":"ROUND(E144*10%,2)","v":0},null,{"$f":"ROUND(G144*10%,2)","v":0},null,{"$f":"ROUND(I144*10%,2)","v":0},null,{"$f":"ROUND(K144*10%,2)","v":0},null,{"$f":"ROUND(M144*10%,2)","v":0},null,{"$f":"ROUND(O144*10%,2)","v":0},null,{"$f":"ROUND(Q144*10%,2)","v":0},null,{"$f":"ROUND(S144*10%,2)","v":0}]
[null,null,"assistenza",null,{"$f":"ROUND(E145*10%,2)","v":0},null,{"$f":"ROUND(G145*10%,2)","v":0},null,{"$f":"ROUND(I145*10%,2)","v":0},null,{"$f":"ROUND(K145*10%,2)","v":0},null,{"$f":"ROUND(M145*10%,2)","v":0},null,{"$f":"ROUND(O145*10%,2)","v":0},null,{"$f":"ROUND(Q145*10%,2)","v":0},null,{"$f":"ROUND(S145*10%,2)","v":0}]
[null,null,"imposte"]
[null,null,"diaria",null,{"$f":"ROUND(SUM(E144+E147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(G144+G147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(I144+I147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(K144+K147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(M144+M147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(O144+O147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(Q144+Q147)*2.5%,2)","v":0},null,{"$f":"ROUND(SUM(S144+S147)*2.5%,2)","v":0}]
[null,null,"assistenza",null,{"$f":"ROUND(SUM(E145+E148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(G145+G148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(I145+I148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(K145+K148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(M145+M148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(O145+O148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(Q145+Q148)*10%,2)","v":0},null,{"$f":"ROUND(SUM(S145+S148)*10%,2)","v":0}]
[null,null,"diritti",null,{"$f":"ROUND(SUM(E144:S144,E147:S147)/SUM(E144:S145,E147:S148)*$G$100*2.5%,2)+ROUND(SUM(E145:S145,E148:S148)/SUM(E144:S145,E147:S148)*$G$100*10%,2)","v":{"$error":"#DIV/0!"}}]
[null,null,""]

{"sheet":"EXTRA","index":1,"n_rows":84,"n_cols":4,"rows_kept":84,"cut":false,"hidden":true,"merged":[[2,1,2,3],[7,2,7,3]]}
[]
[null,"PREMI DELLA GARANZIA EXTRA-RICOVERO IN ABBINAMENTO AL PRODOTTO VITA INTERA"]
[null,"Le condizioni della garanzia sono le stesse del prodotto RealmenteInSalute ad eccezione della componente di Alta Diagnostica che è già compresa nella tariffa SL.\nSu RealmenteInSalute formula FULL, il peso del premio AD sulla garanzia Accertamenti Diagnostici e Visite Specialistiche è pari al 36%. Tuttavia il premio è stato ridotto solo del 20% come da calcolo di premio puro."]
[]
[]
[]
[null,"Annuali","OPZIONE COMFORT","OPZIONE DELUXE"]
[null,"età","PREMI NETTI"]
[null,0,42.72,167.28]
[null,1,46.49,168.91]
[null,2,50.27,170.56]
[null,3,54.05,172.2]
[null,4,57.83,173.84]
[null,5,61.61,175.48]
[null,6,65.39,177.13]
[null,7,69.17,178.76]
[null,8,72.95,180.4]
[null,9,76.739999999999995,182.05]
[null,10,80.510000000000005,183.69]
[null,11,84.28,185.32]
[null,12,88.07,187.56]
[null,13,91.85,190.37]
[null,14,95.63,193.19]
[null,15,99.41,196.01]
[null,16,103.19,198.81]
[null,17,106.96,201.63]
[null,18,110.74,204.45]
[null,19,114.52,207.26]
[null,20,118.3,210.07]
[null,21,122.09,212.89]
[null,22,125.86,215.71]
[null,23,129.63999999999999,218.52]
[null,24,133.43,221.34]
[null,25,137.19999999999999,224.15]
[null,26,140.97999999999999,226.97]
[null,27,144.76,229.79]
[null,28,148.54,232.59]
[null,29,152.32,235.41]
[null,30,156.1,238.23]
[null,31,159.88,241.04]
[null,32,163.65,243.86]
[null,33,167.44,246.67]
[null,34,171.21,249.49]
[null,35,174.99,252.31]
[null,36,178.78,255.12]
[null,37,182.55,257.93]
[null,38,186.33,260.76]
[null,39,190.11,263.57]
[null,40,193.89,266.38]
[null,41,194.25,269.20999999999998]
[null,42,195.16,272.01]
[null,43,196.61,274.82]
[null,44,198.61,277.64999999999998]
[null,45,201.15,278.83999999999997]
[null,46,204.25,280.89]
[null,47,207.88,283.79000000000002]
[null,48,212.07,287.55]
[null,49,216.81,292.16000000000003]
[null,50,222.08,297.63]
[null,51,227.91,303.95]
[null,52,234.29,311.13]
[null,53,241.2,319.16000000000003]
[null,54,248.67,328.04]
[null,55,256.68,337.78]
[null,56,265.24,348.38]
[null,57,274.35000000000002,359.83]
[null,58,284,372.12]
[null,59,294.2,385.28]
[null,60,304.95,399.29]
[null,61,316.24,414.16]
[null,62,328.09,429.87]
[null,63,340.47,446.45]
[null,64,353.41,463.88]
[null,65,366.88,482.16]
[null,66,380.9,501.29]
[null,67,395.49,521.28]
[null,68,410.6,542.13]
[null,69,426.28,563.83000000000004]
[null,70,442.49,586.38]
[null,71,459.25,609.79]
[null,72,476.55,634.04999999999995]
[null,73,494.41,659.17]
[null,74,512.80999999999995,685.14]
[null,75,531.76,711.96]

{"sheet":"parametri","index":2,"n_rows":30,"n_cols":43,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[]
["e_prodotto",null,"e_rsm","colonna cerca vert",null,"e_franchigia","sconto",null,"e_sn",null,"e_ol","colonna cerca vert",null,"teste",null,null,"e_diaria",null,"e_taglio","colonna cerca vert",null,"e_fraz","Svp","rate",null,"e_extra","colonna cerca vert",null,"TIPO MOVIMENTO",null,null,"e_rsm_2019","e_rsm_2020","e_rsm_2021","e_rsm_2022",null,null,null,null,"e_ol_2019","e_ol_2020","e_ol_2021","e_ol_2022"]
["Rimborso spese mediche",null,"BASIC",2,null,"NO",null,null,"SI",null,"NO",1,null,1,0,null,"Standard",null,"025",2,null,"Annuale",0,1,null,"NO",1,null,"Emissione",null,null,{"$f":"\"BASIC          voce 1: \"&AF12&\n   \" voce 2: \"&TEXT(AF13,\"#.###\")&\n   \" voce 3: \"&TEXT(AF14,\"#.###\")","v":"BASIC          voce 1: 330 voce 2: 33.000 voce 3: 3.300"},{"$f":"\"BASIC          voce 1: \"&AG12&\n   \" voce 2: \"&TEXT(AG13,\"#.###\")&\n   \" voce 3: \"&TEXT(AG14,\"#.###\")","v":"BASIC          voce 1: 338 voce 2: 33.825 voce 3: 3.382"},{"$f":"\"BASIC          voce 1: \"&AH12&\n   \" voce 2: \"&TEXT(AH13,\"#.###\")&\n   \" voce 3: \"&TEXT(AH14,\"#.###\")","v":"BASIC          voce 1: 346 voce 2: 34.671 voce 3: 3.467"},{"$f":"\"BASIC          voce 1: \"&AI12&\n   \" voce 2: \"&TEXT(AI13,\"#.###\")&\n   \" voce 3: \"&TEXT(AI14,\"#.###\")","v":"BASIC          voce 1: 355 voce 2: 35.538 voce 3: 3.553"},null,null,null,null,"NO","NO","NO","NO"]
["Diaria",null,"NORMAL",3,null,1500,0.15,null,"NO",null,"Opzione 1",2,null,2,0.05,null,"Top",null,"050",3,null,"Semestrale",0.03,2,null,"Comfort",2,null,"Quietanza",null,null,{"$f":"\"NORMAL          voce 1: \"&AF15&\n   \" voce 2: \"&TEXT(AF16,\"#.###\")&\n   \" voce 3: \"&TEXT(AF17,\"#.###\")","v":"NORMAL          voce 1: 550 voce 2: 55.000 voce 3: 5.500"},{"$f":"\"NORMAL          voce 1: \"&AG15&\n   \" voce 2: \"&TEXT(AG16,\"#.###\")&\n   \" voce 3: \"&TEXT(AG17,\"#.###\")","v":"NORMAL          voce 1: 563 voce 2: 56.375 voce 3: 5.637"},{"$f":"\"NORMAL          voce 1: \"&AH15&\n   \" voce 2: \"&TEXT(AH16,\"#.###\")&\n   \" voce 3: \"&TEXT(AH17,\"#.###\")","v":"NORMAL          voce 1: 577 voce 2: 57.784 voce 3: 5.778"},{"$f":"\"NORMAL          voce 1: \"&AI15&\n   \" voce 2: \"&TEXT(AI16,\"#.###\")&\n   \" voce 3: \"&TEXT(AI17,\"#.###\")","v":"NORMAL          voce 1: 592 voce 2: 59.229 voce 3: 5.922"},null,null,null,null,{"$f":"\"Opzione 1 - \"&TEXT(AN11,\"#.###\")","v":"Opzione 1 - 12.300"},{"$f":"\"Opzione 1 - \"&TEXT(AO11,\"#.###\")","v":"Opzione 1 - 12.300"},"Opzione 1 - 12.608","Opzione 1 - 12.923"]
[null,null,"SILVER",4,null,2500,0.2,null,null,null,"Opzione 2",3,null,3,0.1,null,null,null,"075",4,null,"Quadrimestrale",0.03,3,null,"Deluxe",3,null,null,null,null,{"$f":"\"SILVER          voce 1: \"&AF18&\n   \" voce 2: \"&TEXT(AF19,\"#.###\")&\n   \" voce 3: \"&TEXT(AF20,\"#.###\")","v":"SILVER          voce 1: 660 voce 2: 66.000 voce 3: 6.600"},{"$f":"\"SILVER          voce 1: \"&AG18&\n   \" voce 2: \"&TEXT(AG19,\"#.###\")&\n   \" voce 3: \"&TEXT(AG20,\"#.###\")","v":"SILVER          voce 1: 676 voce 2: 67.650 voce 3: 6.765"},{"$f":"\"SILVER          voce 1: \"&AH18&\n   \" voce 2: \"&TEXT(AH19,\"#.###\")&\n   \" voce 3: \"&TEXT(AH20,\"#.###\")","v":"SILVER          voce 1: 693 voce 2: 69.341 voce 3: 6.934"},{"$f":"\"SILVER          voce 1: \"&AI18&\n   \" voce 2: \"&TEXT(AI19,\"#.###\")&\n   \" voce 3: \"&TEXT(AI20,\"#.###\")","v":"SILVER          voce 1: 710 voce 2: 71.075 voce 3: 7.107"},null,null,null,null,{"$f":"\"Opzione 2 - \"&TEXT(AN12,\"#.###\")","v":"Opzione 2 - 24.600"},{"$f":"\"Opzione 2 - \"&TEXT(AO12,\"#.###\")","v":"Opzione 2 - 24.600"},"Opzione 2 - 25.215","Opzione 2 - 25.845"]
[null,null,"GOLD",5,null,3500,0.3,null,null,null,null,null,null,4,0.15,null,null,null,"100",5,null,"Trimestrale",0.03,4,null,null,null,null,null,null,null,{"$f":"\"GOLD              voce 1: \"&AF21&\n   \" voce 2: \"&TEXT(AF22,\"#.###\")&\n   \" voce 3: \"&TEXT(AF23,\"#.###\")","v":"GOLD              voce 1: 770 voce 2: 77.000 voce 3: 7.700"},{"$f":"\"GOLD              voce 1: \"&AG21&\n   \" voce 2: \"&TEXT(AG22,\"#.###\")&\n   \" voce 3: \"&TEXT(AG23,\"#.###\")","v":"GOLD              voce 1: 789 voce 2: 78.925 voce 3: 7.892"},{"$f":"\"GOLD               voce 1: \"&AH21&\n   \" voce 2: \"&TEXT(AH22,\"#.###\")&\n   \" voce 3: \"&TEXT(AH23,\"#.###\")","v":"GOLD               voce 1: 808 voce 2: 80.898 voce 3: 8.089"},{"$f":"\"GOLD                        voce 1: \"&AI21&\n   \" voce 2: \"&TEXT(AI22,\"#.###\")&\n   \" voce 3: \"&TEXT(AI23,\"#.###\")","v":"GOLD                        voce 1: 829 voce 2: 82.920 voce 3: 8.292"}]
[null,null,"PLATINUM",6,null,5000,0.4,null,"compresa nella garanzia",null,null,null,null,5,0.15,null,null,null,"125",6,null,"Mensile",0.03,12,null,null,null,null,null,null,null,{"$f":"\"PLATINUM          voce 1: \"&AF24&\n   \" voce 2: \"&TEXT(AF25,\"#.###\")&\n   \" voce 3: \"&TEXT(AF26,\"#.###\")","v":"PLATINUM          voce 1: 880 voce 2: 88.000 voce 3: 8.800"},{"$f":"\"PLATINUM          voce 1: \"&AG24&\n   \" voce 2: \"&TEXT(AG25,\"#.###\")&\n   \" voce 3: \"&TEXT(AG26,\"#.###\")","v":"PLATINUM          voce 1: 902 voce 2: 90.200 voce 3: 9.020"},{"$f":"\"PLATINUM          voce 1: \"&AH24&\n   \" voce 2: \"&TEXT(AH25,\"#.###\")&\n   \" voce 3: \"&TEXT(AH26,\"#.###\")","v":"PLATINUM          voce 1: 924 voce 2: 92.455 voce 3: 9.245"},{"$f":"\"PLATINUM          voce 1: \"&AI24&\n   \" voce 2: \"&TEXT(AI25,\"#.###\")&\n   \" voce 3: \"&TEXT(AI26,\"#.###\")","v":"PLATINUM          voce 1: 947 voce 2: 94.766 voce 3: 9.476"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,6,0.15,null,null,null,"150",7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,7,0.15,null,null,null,"175",8]
[null,null,"Indice RSM",null,null,null,null,null,null,null,null,null,null,8,0.15,null,null,null,"200",9,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,2020,2021,2022]
[null,null,"indicetot",{"$f":"VLOOKUP(YEAR(c_dataeffetto),$C$12:$E$16,3,FALSE)","v":1.1038128906249998},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,2019,2020,2021,2022,null,null,null,null,12300,12300,{"$f":"ROUND(AO11*$D$13,0)","v":12608},{"$f":"ROUND(AP11*$D$14,0)","v":12923}]
[null,null,2019,1,{"$f":"PRODUCT($D$12:D12)","v":1},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,330,{"$f":"INT(AG13/100)","v":338},{"$f":"INT(AH13/100)","v":346},{"$f":"INT(AI13/100)","v":355},null,null,null,null,24600,24600,{"$f":"ROUND(AO12*$D$13,0)","v":25215},{"$f":"ROUND(AP12*$D$14,0)","v":25845}]
[null,null,2020,1.0249999999999999,{"$f":"PRODUCT($D$12:D13)","v":1.0249999999999999},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,33000,{"$f":"ROUND(AF13*$D$13,0)","v":33825},{"$f":"ROUND(AG13*$D$14,0)","v":34671},{"$f":"ROUND(AH13*$D$15,0)","v":35538}]
[null,null,2021,1.0249999999999999,{"$f":"PRODUCT($D$12:D14)","v":1.0506249999999999},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,3300,{"$f":"INT(AG13/10)","v":3382},{"$f":"INT(AH13/10)","v":3467},{"$f":"INT(AI13/10)","v":3553}]
[null,null,2022,1.0249999999999999,{"$f":"PRODUCT($D$12:D15)","v":1.0768906249999999},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,550,{"$f":"INT(AG16/100)","v":563},{"$f":"INT(AH16/100)","v":577},{"$f":"INT(AI16/100)","v":592}]
[null,null,2023,1.0249999999999999,{"$f":"PRODUCT($D$12:D16)","v":1.1038128906249998},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,55000.000000000007,{"$f":"ROUND(AF16*$D$13,0)","v":56375},{"$f":"ROUND(AG16*$D$14,0)","v":57784},{"$f":"ROUND(AH16*$D$15,0)","v":59229}]
[null,null,"Indice Extra",{"$f":"VLOOKUP(YEAR(c_dataeffetto),$C$18:$E$22,3,FALSE)","v":1.0115995454220001},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,5500,{"$f":"INT(AG16/10)","v":5637},{"$f":"INT(AH16/10)","v":5778},{"$f":"INT(AI16/10)","v":5922}]
[null,null,2019,1,{"$f":"PRODUCT($D$18:D18)","v":1},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,660,{"$f":"INT(AG19/100)","v":676},{"$f":"INT(AH19/100)","v":693},{"$f":"INT(AI19/100)","v":710}]
[null,null,2020,1.0048330000000001,{"$f":"PRODUCT($D$18:D19)","v":1.0048330000000001},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,66000,{"$f":"ROUND(AF19*$D$13,0)","v":67650},{"$f":"ROUND(AG19*$D$14,0)","v":69341},{"$f":"ROUND(AH19*$D$15,0)","v":71075}]
[null,null,2021,1.006734,{"$f":"PRODUCT($D$18:D20)","v":1.0115995454220001},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,6600,{"$f":"INT(AG19/10)","v":6765},{"$f":"INT(AH19/10)","v":6934},{"$f":"INT(AI19/10)","v":7107}]
[null,null,2022,1,{"$f":"PRODUCT($D$18:D21)","v":1.0115995454220001},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,770,{"$f":"INT(AG22/100)","v":789},{"$f":"INT(AH22/100)","v":808},{"$f":"INT(AI22/100)","v":829}]
[null,null,2023,1,{"$f":"PRODUCT($D$18:D22)","v":1.0115995454220001},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,77000,{"$f":"ROUND(AF22*$D$13,0)","v":78925},{"$f":"ROUND(AG22*$D$14,0)","v":80898},{"$f":"ROUND(AH22*$D$15,0)","v":82920}]
[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,7700,{"$f":"INT(AG22/10)","v":7892},{"$f":"INT(AH22/10)","v":8089},{"$f":"INT(AI22/10)","v":8292}]
[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,880,{"$f":"INT(AG25/100)","v":902},{"$f":"INT(AH25/100)","v":924},{"$f":"INT(AI25/100)","v":947}]
[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,88000.000000000015,{"$f":"ROUND(AF25*$D$13,0)","v":90200},{"$f":"ROUND(AG25*$D$14,0)","v":92455},{"$f":"ROUND(AH25*$D$15,0)","v":94766}]
[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,8800,{"$f":"INT(AG25/10)","v":9020},{"$f":"INT(AH25/10)","v":9245},{"$f":"INT(AI25/10)","v":9476}]
[]
[]
[null,null,null,"53 nel 2021",3369.34]
[null,null,null,null,{"$f":"E29/E14*E15","v":3453.5735}]

{"sheet":"SL","index":3,"n_rows":108,"n_cols":7,"rows_kept":108,"cut":false,"hidden":true,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[null,"Listino 2019 - Rimborso spese mediche (SL)"]
[null,"Opzione default: NO scoperto"]
[null,"PREMI NETTI"]
[null,"Spese sanitarie",330,550,660,770,880]
[null,"Spese di intervento chirurgico",33000,55000,66000,77000,88000]
[null,"Massimale integrativo",3300,5500,6600,7700,8800]
[null,"ETA","BASIC\nvoce 1: 330\nvoce 2: 33.000\nvoce 3: 3.300","NORMAL \nvoce 1: 550\nvoce 2: 55.000\nvoce 3: 5.500","SILVER \nvoce 1: 660\nvoce 2: 66.000\nvoce 3: 6.600","GOLD \nvoce 1: 770\nvoce 2: 77.000\nvoce 3: 7.700","PLATINUM \nvoce 1: 880\nvoce 2: 88.000\nvoce 3: 8.800"]
[null,0,525.67999999999995,584.09,642.49,700.9,759.31]
[null,1,525.67999999999995,584.09,642.49,700.9,759.31]
[null,2,525.67999999999995,584.09,642.49,700.9,759.31]
[null,3,525.67999999999995,584.09,642.49,700.9,759.31]
[null,4,525.67999999999995,584.09,642.49,700.9,759.31]
[null,5,525.67999999999995,584.09,642.49,700.9,759.31]
[null,6,525.67999999999995,584.09,642.49,700.9,759.31]
[null,7,525.67999999999995,584.09,642.49,700.9,759.31]
[null,8,525.67999999999995,584.09,642.49,700.9,759.31]
[null,9,525.67999999999995,584.09,642.49,700.9,759.31]
[null,10,525.67999999999995,584.09,642.49,700.9,759.31]
[null,11,525.67999999999995,584.09,642.49,700.9,759.31]
[null,12,525.67999999999995,584.09,642.49,700.9,759.31]
[null,13,525.67999999999995,584.09,642.49,700.9,759.31]
[null,14,525.67999999999995,584.09,642.49,700.9,759.31]
[null,15,525.67999999999995,584.09,642.49,700.9,759.31]
[null,16,525.67999999999995,584.09,642.49,700.9,759.31]
[null,17,525.67999999999995,584.09,642.49,700.9,759.31]
[null,18,800.18,889.08,977.99,1066.9000000000001,1155.81]
[null,19,832.73,925.25,1017.78,1110.3,1202.83]
[null,20,868.43,964.92,1061.42,1157.9100000000001,1254.4000000000001]
[null,21,907.29,1008.1,1108.9000000000001,1209.71,1310.52]
[null,22,950.34,1055.93,1161.53,1267.1199999999999,1372.71]
[null,23,996.54,1107.27,1218,1328.73,1439.45]
[null,24,1043.8,1159.78,1275.75,1391.73,1507.71]
[null,25,1090,1211.1099999999999,1332.23,1453.34,1574.45]
[null,26,1136.21,1262.45,1388.7,1514.94,1641.19]
[null,27,1181.3599999999999,1312.62,1443.89,1575.15,1706.41]
[null,28,1225.47,1361.63,1497.79,1633.95,1770.12]
[null,29,1268.52,1409.47,1550.41,1691.36,1832.31]
[null,30,1311.57,1457.3,1603.03,1748.76,1894.5]
[null,31,1354.63,1505.14,1655.66,1806.17,1956.68]
[null,32,1398.73,1554.15,1709.56,1864.98,2020.39]
[null,33,1442.84,1603.15,1763.47,1923.78,2084.1]
[null,34,1487.99,1653.32,1818.65,1983.99,2149.3200000000002]
[null,35,1534.19,1704.66,1875.13,2045.59,2216.06]
[null,36,1583.55,1759.5,1935.45,2111.4,2287.35]
[null,37,1635,1816.67,1998.34,2180.0100000000002,2361.67]
[null,38,1690.66,1878.51,2066.36,2254.21,2442.06]
[null,39,1749.47,1943.85,2138.2399999999998,2332.62,2527.0100000000002]
[null,40,1812.47,2013.86,2215.2399999999998,2416.63,2618.0100000000002]
[null,41,1880.73,2089.6999999999998,2298.67,2507.64,2716.61]
[null,42,1954.23,2171.37,2388.5100000000002,2605.65,2822.78]
[null,43,2034.04,2260.0500000000002,2486.0500000000002,2712.06,2938.06]
[null,44,2119.1,2354.56,2590.0100000000002,2825.47,3060.92]
[null,45,2210.46,2456.0700000000002,2701.67,2947.28,3192.88]
[null,46,2309.17,2565.7399999999998,2822.32,3078.89,3335.46]
[null,47,2414.1799999999998,2682.42,2950.66,3218.9,3487.15]
[null,48,2526.54,2807.26,3087.99,3368.72,3649.44]
[null,49,2645.2,2939.11,3233.02,3526.93,3820.84]
[null,50,2772.26,3080.29,3388.32,3696.35,4004.38]
[null,51,2904.57,3227.3,3550.03,3872.77,4195.5]
[null,52,3045.29,3383.65,3722.02,4060.38,4398.75]
[null,53,3191.25,3545.83,3900.42,4255,4609.58]
[null,54,3344.57,3716.18,4087.8,4459.42,4831.04]
[null,55,3503.13,3892.37,4281.6000000000004,4670.84,5060.08]
[null,56,3666.95,4074.38,4481.82,4889.26,5296.7]
[null,57,3836.01,4262.24,4688.46,5114.68,5540.91]
[null,58,4010.33,4455.92,4901.51,5347.1,5792.7]
[null,59,4188.8500000000004,4654.2700000000004,5119.7,5585.13,6050.55]
[null,60,4370.51,4856.12,5341.74,5827.35,6312.96]
[null,61,4555.33,5061.4799999999996,5567.63,6073.77,6579.92]
[null,62,4742.25,5269.16,5796.08,6323,6849.91]
[null,63,4930.22,5478.02,6025.82,6573.62,7121.42]
[null,64,5120.28,5689.2,6258.12,6827.04,7395.96]
[null,65,5310.35,5900.39,6490.43,7080.47,7670.51]
[null,66,5499.37,6110.41,6721.45,7332.49,7943.53]
[null,67,5688.39,6320.43,6952.47,7584.52,8216.56]
[null,68,5875.3,6528.12,7180.93,7833.74,8486.5499999999993]
[null,69,6060.12,6733.47,7406.82,8080.16,8753.51]
[null,70,6241.79,6935.32,7628.85,8322.39,9015.92]
[null,71,6420.31,7133.67,7847.04,8560.41,9273.77]
[null,72,6595.67,7328.52,8061.38,8794.23,9527.08]
[null,73,6767.89,7519.88,8271.86,9023.85,9775.84]
[null,74,6935.9,7706.56,8477.2199999999993,9247.8700000000008,10018.530000000001]
[null,75,7100.77,7889.74,8678.7199999999993,9467.69,10256.67]
[null,76,7262.49,8069.43,8876.3700000000008,9683.31,10490.26]
[null,77,7422.1,8246.7800000000007,9071.4599999999991,9896.1299999999992,10720.81]
[null,78,7579.62,8421.7900000000009,9263.9699999999993,10106.15,10948.33]
[null,79,7740.28,8600.31,9460.34,10320.370000000001,11180.4]
[null,80,7890.44,8767.16,9643.8799999999992,10520.59,11397.31]
[null,81,8036.41,8929.34,9822.2800000000007,10715.21,11608.15]
[null,82,8179.22,9088.02,9996.83,10905.63,11814.43]
[null,83,8316.7800000000007,9240.8700000000008,10164.959999999999,11089.05,12013.13]
[null,84,8448.0499999999993,9386.7199999999993,10325.39,11264.06,12202.73]
[null,85,8570.91,9523.23,10475.549999999999,11427.88,12380.2]
[null,86,8682.2199999999993,9646.91,10611.6,11576.29,12540.98]
[null,87,8778.83,9754.25,10729.68,11705.1,12680.53]
[null,88,8853.39,9837.09,10820.8,11804.51,12788.22]
[null,89,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,90,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,91,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,92,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,93,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,94,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,95,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,96,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,97,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,98,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,99,8897.49,9886.1,10874.71,11863.32,12851.93]
[null,100,8897.49,9886.1,10874.71,11863.32,12851.93]

{"sheet":"GL","index":4,"n_rows":106,"n_cols":7,"rows_kept":106,"cut":false,"hidden":true,"merged":[[0,1,0,6],[1,1,1,6],[2,1,2,6]]}
[null,"Listino 2019 - Raddoppio prestazioni per Grandi Interventi Chirurgici (GL)"]
[null,"Opzione default: NO scoperto"]
[null,"PREMI NETTI"]
[null,"Spese di intervento chirurgico",33000,55000,66000,77000,88000]
[null,"ETA","BASIC\nvoce 1: 330\nvoce 2: 33.000\nvoce 3: 3.300","NORMAL \nvoce 1: 550\nvoce 2: 55.000\nvoce 3: 5.500","SILVER \nvoce 1: 660\nvoce 2: 66.000\nvoce 3: 6.600","GOLD \nvoce 1: 770\nvoce 2: 77.000\nvoce 3: 7.700","PLATINUM \nvoce 1: 880\nvoce 2: 88.000\nvoce 3: 8.800"]
[null,0,105.14,116.82,128.5,140.18,151.86000000000001]
[null,1,105.14,116.82,128.5,140.18,151.86000000000001]
[null,2,105.14,116.82,128.5,140.18,151.86000000000001]
[null,3,105.14,116.82,128.5,140.18,151.86000000000001]
[null,4,105.14,116.82,128.5,140.18,151.86000000000001]
[null,5,105.14,116.82,128.5,140.18,151.86000000000001]
[null,6,105.14,116.82,128.5,140.18,151.86000000000001]
[null,7,105.14,116.82,128.5,140.18,151.86000000000001]
[null,8,105.14,116.82,128.5,140.18,151.86000000000001]
[null,9,105.14,116.82,128.5,140.18,151.86000000000001]
[null,10,105.14,116.82,128.5,140.18,151.86000000000001]
[null,11,105.14,116.82,128.5,140.18,151.86000000000001]
[null,12,105.14,116.82,128.5,140.18,151.86000000000001]
[null,13,105.14,116.82,128.5,140.18,151.86000000000001]
[null,14,105.14,116.82,128.5,140.18,151.86000000000001]
[null,15,105.14,116.82,128.5,140.18,151.86000000000001]
[null,16,105.14,116.82,128.5,140.18,151.86000000000001]
[null,17,105.14,116.82,128.5,140.18,151.86000000000001]
[null,18,160.04,177.82,195.6,213.38,231.16]
[null,19,166.55,185.05,203.56,222.06,240.57]
[null,20,173.69,192.98,212.28,231.58,250.88]
[null,21,181.46,201.62,221.78,241.94,262.10000000000002]
[null,22,190.07,211.19,232.31,253.42,274.54000000000002]
[null,23,199.31,221.45,243.6,265.75,287.89]
[null,24,208.76,231.96,255.15,278.35000000000002,301.54000000000002]
[null,25,218,242.22,266.45,290.67,314.89]
[null,26,227.24,252.49,277.74,302.99,328.24]
[null,27,236.27,262.52,288.77999999999997,315.02999999999997,341.28]
[null,28,245.09,272.33,299.56,326.79000000000002,354.02]
[null,29,253.7,281.89,310.08,338.27,366.46]
[null,30,262.31,291.45999999999998,320.61,349.75,378.9]
[null,31,270.93,301.02999999999997,331.13,361.23,391.34]
[null,32,279.75,310.83,341.91,373,404.08]
[null,33,288.57,320.63,352.69,384.76,416.82]
[null,34,297.60000000000002,330.66,363.73,396.8,429.86]
[null,35,306.83999999999997,340.93,375.03,409.12,443.21]
[null,36,316.70999999999998,351.9,387.09,422.28,457.47]
[null,37,327,363.33,399.67,436,472.33]
[null,38,338.13,375.7,413.27,450.84,488.41]
[null,39,349.89,388.77,427.65,466.52,505.4]
[null,40,362.49,402.77,443.05,483.33,523.6]
[null,41,376.15,417.94,459.73,501.53,543.32000000000005]
[null,42,390.85,434.27,477.7,521.13,564.55999999999995]
[null,43,406.81,452.01,497.21,542.41,587.61]
[null,44,423.82,470.91,518,565.09,612.17999999999995]
[null,45,442.09,491.21,540.33000000000004,589.46,638.58000000000004]
[null,46,461.83,513.15,564.46,615.78,667.09]
[null,47,482.84,536.48,590.13,643.78,697.43]
[null,48,505.31,561.45000000000005,617.6,673.74,729.89]
[null,49,529.04,587.82000000000005,646.6,705.39,764.17]
[null,50,554.45000000000005,616.05999999999995,677.66,739.27,800.88]
[null,51,580.91,645.46,710.01,774.55,839.1]
[null,52,609.05999999999995,676.73,744.4,812.08,879.75]
[null,53,638.25,709.17,780.08,851,921.92]
[null,54,668.91,743.24,817.56,891.88,966.21]
[null,55,700.63,778.47,856.32,934.17,1012.02]
[null,56,733.39,814.88,896.36,977.85,1059.3399999999999]
[null,57,767.2,852.45,937.69,1022.94,1108.18]
[null,58,802.07,891.18,980.3,1069.42,1158.54]
[null,59,837.77,930.85,1023.94,1117.03,1210.1099999999999]
[null,60,874.1,971.22,1068.3499999999999,1165.47,1262.5899999999999]
[null,61,911.07,1012.3,1113.53,1214.75,1315.98]
[null,62,948.45,1053.83,1159.22,1264.5999999999999,1369.98]
[null,63,986.04,1095.5999999999999,1205.1600000000001,1314.72,1424.28]
[null,64,1024.06,1137.8399999999999,1251.6199999999999,1365.41,1479.19]
[null,65,1062.07,1180.08,1298.0899999999999,1416.09,1534.1]
[null,66,1099.8699999999999,1222.08,1344.29,1466.5,1588.71]
[null,67,1137.68,1264.0899999999999,1390.49,1516.9,1643.31]
[null,68,1175.06,1305.6199999999999,1436.19,1566.75,1697.31]
[null,69,1212.02,1346.69,1481.36,1616.03,1750.7]
[null,70,1248.3599999999999,1387.06,1525.77,1664.48,1803.18]
[null,71,1284.06,1426.73,1569.41,1712.08,1854.75]
[null,72,1319.13,1465.7,1612.28,1758.85,1905.42]
[null,73,1353.58,1503.98,1654.37,1804.77,1955.17]
[null,74,1387.18,1541.31,1695.44,1849.57,2003.71]
[null,75,1420.15,1577.95,1735.74,1893.54,2051.33]
[null,76,1452.5,1613.89,1775.27,1936.66,2098.0500000000002]
[null,77,1484.42,1649.36,1814.29,1979.23,2144.16]
[null,78,1515.92,1684.36,1852.79,2021.23,2189.67]
[null,79,1548.06,1720.06,1892.07,2064.0700000000002,2236.08]
[null,80,1578.09,1753.43,1928.78,2104.12,2279.46]
[null,81,1607.28,1785.87,1964.46,2143.04,2321.63]
[null,82,1635.84,1817.6,1999.37,2181.13,2362.89]
[null,83,1663.36,1848.17,2032.99,2217.81,2402.63]
[null,84,1689.61,1877.34,2065.08,2252.81,2440.5500000000002]
[null,85,1714.18,1904.65,2095.11,2285.58,2476.04]
[null,86,1736.44,1929.38,2122.3200000000002,2315.2600000000002,2508.1999999999998]
[null,87,1755.77,1950.85,2145.94,2341.02,2536.11]
[null,88,1770.68,1967.42,2164.16,2360.9,2557.64]
[null,89,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,90,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,91,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,92,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,93,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,94,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,95,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,96,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,97,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,98,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,99,1779.5,1977.22,2174.94,2372.66,2570.39]
[null,100,1779.5,1977.22,2174.94,2372.66,2570.39]

{"sheet":"OL","index":5,"n_rows":106,"n_cols":4,"rows_kept":106,"cut":false,"hidden":true,"merged":[[0,1,0,3],[1,1,1,3],[2,1,2,6]]}
[null,"Listino 2019 - Prestazione integrativa per Interventi Chirurgici (OL)"]
[null,"Opzione default: NO scoperto"]
[null,"PREMI NETTI"]
[null,"Massimale integrativo",12000,24000]
[null,"ETA","Opzione 1","Opzione 2"]
[null,0,55.49,110.98]
[null,1,55.49,110.98]
[null,2,55.49,110.98]
[null,3,55.49,110.98]
[null,4,55.49,110.98]
[null,5,55.49,110.98]
[null,6,55.49,110.98]
[null,7,55.49,110.98]
[null,8,55.49,110.98]
[null,9,55.49,110.98]
[null,10,55.49,110.98]
[null,11,55.49,110.98]
[null,12,55.49,110.98]
[null,13,55.49,110.98]
[null,14,55.49,110.98]
[null,15,55.49,110.98]
[null,16,55.49,110.98]
[null,17,55.49,110.98]
[null,18,84.46,168.93]
[null,19,87.9,175.8]
[null,20,91.67,183.34]
[null,21,95.77,191.54]
[null,22,100.31,200.63]
[null,23,105.19,210.38]
[null,24,110.18,220.36]
[null,25,115.06,230.11]
[null,26,119.93,239.87]
[null,27,124.7,249.4]
[null,28,129.35,258.70999999999998]
[null,29,133.9,267.8]
[null,30,138.44,276.89]
[null,31,142.99,285.98]
[null,32,147.63999999999999,295.29000000000002]
[null,33,152.30000000000001,304.60000000000002]
[null,34,157.07,314.13]
[null,35,161.94,323.89]
[null,36,167.15,334.3]
[null,37,172.58,345.17]
[null,38,178.46,356.92]
[null,39,184.67,369.33]
[null,40,191.32,382.63]
[null,41,198.52,397.04]
[null,42,206.28,412.56]
[null,43,214.7,429.41]
[null,44,223.68,447.37]
[null,45,233.33,466.65]
[null,46,243.75,487.49]
[null,47,254.83,509.66]
[null,48,266.69,533.38]
[null,49,279.22000000000003,558.42999999999995]
[null,50,292.63,585.26]
[null,51,306.58999999999997,613.19000000000005]
[null,52,321.45,642.89]
[null,53,336.85,673.71]
[null,54,353.04,706.07]
[null,55,369.77,739.55]
[null,56,387.07,774.13]
[null,57,404.91,809.82]
[null,58,423.31,846.62]
[null,59,442.16,884.31]
[null,60,461.33,922.66]
[null,61,480.84,961.68]
[null,62,500.57,1001.14]
[null,63,520.41,1040.82]
[null,64,540.47,1080.95]
[null,65,560.54,1121.07]
[null,66,580.49,1160.98]
[null,67,600.44000000000005,1200.8800000000001]
[null,68,620.16999999999996,1240.3399999999999]
[null,69,639.67999999999995,1279.3599999999999]
[null,70,658.86,1317.71]
[null,71,677.7,1355.4]
[null,72,696.21,1392.42]
[null,73,714.39,1428.78]
[null,74,732.12,1464.25]
[null,75,749.53,1499.05]
[null,76,766.6,1533.19]
[null,77,783.44,1566.89]
[null,78,800.07,1600.14]
[null,79,817.03,1634.06]
[null,80,832.88,1665.76]
[null,81,848.29,1696.58]
[null,82,863.36,1726.72]
[null,83,877.88,1755.77]
[null,84,891.74,1783.48]
[null,85,904.71,1809.41]
[null,86,916.46,1832.91]
[null,87,926.65,1853.31]
[null,88,934.52,1869.05]
[null,89,939.18,1878.36]
[null,90,939.18,1878.36]
[null,91,939.18,1878.36]
[null,92,939.18,1878.36]
[null,93,939.18,1878.36]
[null,94,939.18,1878.36]
[null,95,939.18,1878.36]
[null,96,939.18,1878.36]
[null,97,939.18,1878.36]
[null,98,939.18,1878.36]
[null,99,939.18,1878.36]
[null,100,939.18,1878.36]

{"sheet":"DSU","index":6,"n_rows":104,"n_cols":10,"rows_kept":104,"cut":false,"hidden":true,"merged":[[0,1,0,9],[1,1,1,9]]}
[null,"Listino 2019 - Formula Standard (DSU)"]
[null,"PREMI NETTI"]
[null,"età","DSU025","DSU050","DSU075","DSU100","DSU125","DSU150","DSU175","DSU200"]
[null,0,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,1,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,2,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,3,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,4,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,5,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,6,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,7,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,8,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,9,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,10,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,11,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,12,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,13,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,14,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,15,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,16,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,17,36.14,72.290000000000006,108.43,144.58000000000001,180.72,216.87,253.01,289.14999999999998]
[null,18,40.159999999999997,80.319999999999993,120.48,160.63999999999999,200.8,240.96,281.12,321.27999999999997]
[null,19,40.94,81.87,122.81,163.74,204.68,245.62,286.55,327.49]
[null,20,41.79,83.58,125.37,167.16,208.95,250.74,292.52999999999997,334.32]
[null,21,42.72,85.44,128.16,170.88,213.61,256.33,299.05,341.77]
[null,22,43.73,87.46,131.19,174.92,218.65,262.38,306.11,349.84]
[null,23,44.89,89.79,134.68,179.58,224.47,269.36,314.26,359.15]
[null,24,45.98,91.96,137.94,183.92,229.9,275.88,321.86,367.84]
[null,25,46.91,93.82,140.74,187.65,234.56,281.47000000000003,328.38,375.29]
[null,26,47.84,95.69,143.53,191.37,239.21,287.06,334.9,382.74]
[null,27,48.7,97.39,146.09,194.79,243.48,292.18,340.88,389.57]
[null,28,49.47,98.95,148.41999999999999,197.89,247.36,296.83999999999997,346.31,395.78]
[null,29,50.17,100.34,150.51,200.68,250.86,301.02999999999997,351.2,401.37]
[null,30,50.87,101.74,152.61000000000001,203.48,254.35,305.22000000000003,356.09,406.96]
[null,31,51.57,103.14,154.69999999999999,206.27,257.83999999999997,309.41000000000003,360.98,412.54]
[null,32,52.27,104.53,156.80000000000001,209.07,261.33,313.60000000000002,365.86,418.13]
[null,33,52.96,105.93,158.88999999999999,211.86,264.82,317.79000000000002,370.75,423.72]
[null,34,53.82,107.64,161.46,215.27,269.08999999999997,322.91000000000003,376.73,430.55]
[null,35,54.75,109.5,164.25,219,273.75,328.5,383.25,438]
[null,36,55.76,111.52,167.28,223.03,278.79000000000002,334.55,390.31,446.07]
[null,37,57,114,171,228,285,342,399,456]
[null,38,58.4,116.79,175.19,233.59,291.98,350.38,408.78,467.18]
[null,39,59.95,119.9,179.85,239.8,299.75,359.69,419.64,479.59]
[null,40,61.73,123.47,185.2,246.94,308.67,370.4,432.14,493.87]
[null,41,63.67,127.35,191.02,254.7,318.37,382.04,445.72,509.39]
[null,42,65.92,131.85,197.77,263.7,329.62,395.55,461.47,527.4]
[null,43,68.41,136.82,205.22,273.63,342.04,410.45,478.85,547.26]
[null,44,71.05,142.09,213.14,284.19,355.23,426.28,497.32,568.37]
[null,45,74,147.99,221.99,295.98,369.98,443.97,517.97,591.96]
[null,46,77.180000000000007,154.35,231.53,308.70999999999998,385.88,463.06,540.24,617.41999999999996]
[null,47,80.67,161.34,242.01,322.68,403.35,484.01,564.67999999999995,645.35]
[null,48,84.39,168.79,253.18,337.58,421.97,506.36,590.76,675.15]
[null,49,88.43,176.86,265.29000000000002,353.72,442.15,530.58000000000004,619.01,707.44]
[null,50,92.78,185.55,278.33,371.1,463.88,556.65,649.42999999999995,742.2]
[null,51,97.43,194.86,292.29000000000002,389.73,487.16,584.59,682.02,779.45]
[null,52,102.32,204.64,306.95999999999998,409.28,511.6,613.91999999999996,716.24,818.56]
[null,53,107.6,215.19,322.79000000000002,430.39,537.99,645.58000000000004,753.18,860.78]
[null,54,113.18,226.37,339.55,452.74,565.91999999999996,679.11,792.29,905.48]
[null,55,119.01,238.01,357.02,476.02,595.03,714.03,833.04,952.04]
[null,56,125.21,250.43,375.64,500.85,626.07000000000005,751.28,876.49,1001.71]
[null,57,131.72999999999999,263.45999999999998,395.2,526.92999999999995,658.66,790.39,922.12,1053.8599999999999]
[null,58,138.47999999999999,276.97000000000003,415.45,553.92999999999995,692.42,830.9,969.38,1107.8699999999999]
[null,59,145.62,291.25,436.87,582.49,728.12,873.74,1019.36,1164.98]
[null,60,153.07,306.14999999999998,459.22,612.29,765.36,918.44,1071.51,1224.58]
[null,61,160.76,321.51,482.27,643.02,803.78,964.53,1125.29,1286.05]
[null,62,168.75,337.5,506.25,675,843.74,1012.49,1181.24,1349.99]
[null,63,177.05,354.1,531.16,708.21,885.26,1062.31,1239.3699999999999,1416.42]
[null,64,185.59,371.18,556.77,742.35,927.94,1113.53,1299.1199999999999,1484.71]
[null,65,194.36,388.72,583.07000000000005,777.43,971.79,1166.1500000000001,1360.51,1554.86]
[null,66,203.44,406.87,610.30999999999995,813.75,1017.19,1220.6199999999999,1424.06,1627.5]
[null,67,212.67,425.34,638.02,850.69,1063.3599999999999,1276.03,1488.71,1701.38]
[null,68,222.06,444.12,666.19,888.25,1110.31,1332.37,1554.44,1776.5]
[null,69,231.61,463.21,694.82,926.43,1158.04,1389.64,1621.25,1852.86]
[null,70,241.31,482.62,723.92,965.23,1206.54,1447.85,1689.16,1930.46]
[null,71,251.01,502.02,753.02,1004.03,1255.04,1506.05,1757.06,2008.07]
[null,72,260.70999999999998,521.41999999999996,782.13,1042.83,1303.54,1564.25,1824.96,2085.67]
[null,73,270.33,540.66,810.99,1081.33,1351.66,1621.99,1892.32,2162.65]
[null,74,279.72000000000003,559.44000000000005,839.16,1118.8900000000001,1398.61,1678.33,1958.05,2237.77]
[null,75,288.72000000000003,577.45000000000005,866.17,1154.8900000000001,1443.62,1732.34,2021.06,2309.79]
[null,76,297.18,594.36,891.55,1188.73,1485.91,1783.09,2080.2800000000002,2377.46]
[null,77,304.94,609.89,914.83,1219.77,1524.71,1829.66,2134.6,2439.54]
[null,78,311.69,623.39,935.08,1246.78,1558.47,1870.16,2181.86,2493.5500000000002]
[null,79,316.89,633.79,950.68,1267.57,1584.47,1901.36,2218.25,2535.15]
[null,80,320.14999999999998,640.30999999999995,960.46,1280.6099999999999,1600.76,1920.92,2241.0700000000002,2561.2199999999998]
[null,81,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,82,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,83,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,84,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,85,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,86,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,87,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,88,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,89,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,90,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,91,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,92,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,93,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,94,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,95,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,96,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,97,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,98,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,99,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]
[null,100,322.02,644.03,966.05,1288.06,1610.08,1932.09,2254.11,2576.12]

{"sheet":"TPU","index":7,"n_rows":104,"n_cols":10,"rows_kept":104,"cut":false,"hidden":true,"merged":[[0,1,0,9],[1,1,1,9]]}
[null,"Listino 2019 - Formula Standard (DSU)"]
[null,"PREMI NETTI"]
[null,"età","TPU025","TPU050","TPU075","TPU100","TPU125","TPU150","TPU175","TPU200"]
[null,0,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,1,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,2,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,3,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,4,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,5,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,6,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,7,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,8,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,9,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,10,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,11,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,12,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,13,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,14,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,15,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,16,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,17,56.27,112.54,168.8,225.07,281.33999999999997,337.61,393.88,450.15]
[null,18,62.52,125.04,187.56,250.08,312.60000000000002,375.12,437.64,500.16]
[null,19,63.99,127.99,191.98,255.97,319.95999999999998,383.96,447.95,511.94]
[null,20,65.62,131.25,196.87,262.49,328.12,393.74,459.36,524.99]
[null,21,67.39,134.78,202.17,269.56,336.96,404.35,471.74,539.13]
[null,22,69.31,138.63,207.94,277.25,346.56,415.88,485.19,554.5]
[null,23,71.53,143.05000000000001,214.58,286.10000000000002,357.63,429.15,500.68,572.20000000000005]
[null,24,73.59,147.19,220.78,294.37,367.96,441.56,515.15,588.74]
[null,25,75.36,150.72999999999999,226.09,301.45999999999998,376.82,452.19,527.54999999999995,602.91999999999996]
[null,26,77.14,154.27000000000001,231.41,308.55,385.68,462.82,539.96,617.1]
[null,27,78.760000000000005,157.52000000000001,236.28,315.04000000000002,393.8,472.55,551.30999999999995,630.07000000000005]
[null,28,80.239999999999995,160.47999999999999,240.72,320.95999999999998,401.2,481.44,561.67999999999995,641.91999999999996]
[null,29,81.569999999999993,163.13,244.7,326.27,407.83,489.4,570.97,652.53]
[null,30,82.9,165.8,248.69,331.59,414.49,497.39,580.29,663.18]
[null,31,84.22,168.45,252.67,336.9,421.12,505.35,589.57000000000005,673.8]
[null,32,85.55,171.1,256.64999999999998,342.21,427.76,513.30999999999995,598.86,684.41]
[null,33,86.88,173.76,260.64,347.51,434.39,521.27,608.15,695.03]
[null,34,88.51,177.02,265.52999999999997,354.04,442.55,531.05999999999995,619.55999999999995,708.07]
[null,35,90.28,180.55,270.83,361.11,451.38,541.66,631.94000000000005,722.22]
[null,36,92.2,184.4,276.60000000000002,368.79,460.99,553.19000000000005,645.39,737.59]
[null,37,94.56,189.11,283.67,378.23,472.79,567.34,661.9,756.46]
[null,38,97.22,194.44,291.66000000000003,388.88,486.1,583.32000000000005,680.53,777.75]
[null,39,100.17,200.34,300.5,400.67,500.84,601.01,701.18,801.35]
[null,40,103.57,207.13,310.7,414.27,517.83000000000004,621.4,724.97,828.53]
[null,41,107.26,214.52,321.77999999999997,429.04,536.29999999999995,643.55999999999995,750.82,858.08]
[null,42,111.54,223.09,334.63,446.18,557.72,669.27,780.81,892.36]
[null,43,116.27,232.53,348.8,465.06,581.33000000000004,697.6,813.86,930.13]
[null,44,121.29,242.58,363.87,485.16,606.45000000000005,727.74,849.04,970.33]
[null,45,126.9,253.8,380.69,507.59,634.49,761.39,888.28,1015.18]
[null,46,132.94999999999999,265.89999999999998,398.85,531.79999999999995,664.75,797.7,930.65,1063.5999999999999]
[null,47,139.6,279.19,418.79,558.39,697.98,837.58,977.18,1116.78]
[null,48,146.68,293.37,440.05,586.74,733.42,880.11,1026.79,1173.48]
[null,49,154.36000000000001,308.72000000000003,463.08,617.44000000000005,771.8,926.15,1080.51,1234.8699999999999]
[null,50,162.63,325.26,487.88,650.51,813.14,975.77,1138.4000000000001,1301.03]
[null,51,171.49,342.98,514.48,685.97,857.46,1028.95,1200.45,1371.94]
[null,52,180.79,361.59,542.38,723.17,903.97,1084.76,1265.55,1446.35]
[null,53,190.83,381.67,572.5,763.34,954.17,1145.01,1335.84,1526.68]
[null,54,201.47,402.93,604.4,805.86,1007.33,1208.8,1410.26,1611.73]
[null,55,212.53,425.07,637.6,850.14,1062.67,1275.21,1487.74,1700.28]
[null,56,224.35,448.7,673.06,897.41,1121.76,1346.11,1570.46,1794.82]
[null,57,236.76,473.51,710.27,947.02,1183.78,1420.54,1657.29,1894.05]
[null,58,249.6,499.2,748.8,998.4,1248,1497.6,1747.2,1996.81]
[null,59,263.19,526.37,789.56,1052.74,1315.93,1579.11,1842.3,2105.4899999999998]
[null,60,277.36,554.72,832.08,1109.45,1386.81,1664.17,1941.53,2218.89]
[null,61,291.98,583.97,875.95,1167.93,1459.91,1751.9,2043.88,2335.86]
[null,62,307.19,614.37,921.56,1228.74,1535.93,1843.11,2150.3000000000002,2457.48]
[null,63,322.99,645.98,968.96,1291.95,1614.94,1937.93,2260.91,2583.9]
[null,64,339.23,678.46,1017.69,1356.92,1696.15,2035.39,2374.62,2713.85]
[null,65,355.92,711.84,1067.76,1423.68,1779.6,2135.52,2491.4299999999998,2847.35]
[null,66,373.19,746.39,1119.58,1492.78,1865.97,2239.16,2612.36,2985.55]
[null,67,390.76,781.52,1172.28,1563.04,1953.8,2344.56,2735.32,3126.08]
[null,68,408.62,817.25,1225.8699999999999,1634.5,2043.12,2451.75,2860.37,3269]
[null,69,426.79,853.59,1280.3800000000001,1707.18,2133.9699999999998,2560.7600000000002,2987.56,3414.35]
[null,70,445.25,890.49,1335.74,1780.98,2226.23,2671.47,3116.72,3561.96]
[null,71,463.7,927.4,1391.1,1854.81,2318.5100000000002,2782.21,3245.91,3709.61]
[null,72,482.17,964.33,1446.5,1928.66,2410.83,2893,3375.16,3857.33]
[null,73,500.47,1000.94,1501.42,2001.89,2502.36,3002.83,3503.31,4003.78]
[null,74,518.34,1036.67,1555.01,2073.35,2591.69,3110.02,3628.36,4146.7]
[null,75,535.47,1070.93,1606.4,2141.87,2677.33,3212.8,3748.27,4283.7299999999996]
[null,76,551.55999999999995,1103.1300000000001,1654.69,2206.2600000000002,2757.82,3309.39,3860.95,4412.51]
[null,77,566.33000000000004,1132.6600000000001,1698.99,2265.3200000000002,2831.65,3397.98,3964.31,4530.6499999999996]
[null,78,579.16999999999996,1158.3399999999999,1737.51,2316.6799999999998,2895.86,3475.03,4054.2,4633.37]
[null,79,589.05999999999995,1178.1199999999999,1767.19,2356.25,2945.31,3534.37,4123.4399999999996,4712.5]
[null,80,595.26,1190.53,1785.79,2381.06,2976.32,3571.59,4166.8500000000004,4762.1099999999997]
[null,81,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,82,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,83,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,84,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,85,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,86,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,87,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,88,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,89,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,90,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,91,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,92,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,93,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,94,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,95,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,96,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,97,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,98,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,99,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]
[null,100,598.80999999999995,1197.6300000000001,1796.44,2395.25,2994.06,3592.88,4191.6899999999996,4790.5]

{"sheet":"Assistenza","index":8,"n_rows":3,"n_cols":2,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["Bene","Premi netti Assistenza"]
["Rimborso ",16.53]
["Diaria",24.79]