{"text_format":"2","workbook":"xls","n_sheets":3,"sheets":["GENERALE","LM","KASKO"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"GENERALE","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,7,1,7],[0,0,0,6],[0,8,1,8]],"flags":["formulas_cached_only"]}
["PORTAFOGLIO COMUNE DI SOLESINO",{"$nulls":6},"Note","CIG"]
["Compagnia","Numero Pol.    ","Ramo ","Rischio                        ","Descrizione                                                                                                                                  ","Premio annuo netto","Premio annuo lordo"]
["LLOYD'S  - AEC Underwriting Agenzia di Assicurazione e Riassicurazione Società per Azioni con socio unico – Corrispondente e Coverholder dei Lloyd’s\nPiazza delle Muse 7 - 00197 Roma\nCodice Fiscale e P. Iva 02170331207 \n",1903650,"RCTO","Rischi vari                    "," RCTO                                                                                                           ",5949.06,8000,null,"ZAE17975EF"]
["ITAS  AGENZIA Antonio Mantovani\nMantovani Assicurazioni SAS\nV.le Q. Sella, 67 - 36100 Vicenza . P.I. 02510330240\n\n","M10658043","All risks ","Incendio, furto, elettronica",null,5316.97,6500,null,"ZB817A8642"]
["ITAS  AGENZIA Antonio Mantovani\nMantovani Assicurazioni SAS\nV.le Q. Sella, 67 - 36100 Vicenza . P.I. 02510330240\n\n","M10659381","INF  ","Cumulativo                     "," CONDUCENTI VEICOLI di proprieta' comunale; VOLONTARI DELLA PROTEZIONE CIVILE; LAVORATORI PUBBLICA UTILITA' ",1663.42,1705,null,"ZB817A8642"]
["AIG AIG  Europe Limited – Rappresentanza Generale per l’Italia, Via della Chiusa, 2, 20123, Milano, Italia.  P.I. 08037550962. ","    IFL0007116 ","RCG  ","Rischi vari                    "," RC COLPA LIEVE ENTE                                                                                                       ",2862.99,3500,null,"Z8B17A82F4"]
["DAS D.A.S. Difesa Automobilistica Sinistri S.p.A. di Assicurazione\nVia Enrico Fermi 9/B - 37135 Verona  - P. Iva 00220930234",196124,"TUT  ","Tutela                         "," TUTELA LEGALE                                                                                                        ",1567.01,1900,null,"Z9F17A846C "]
["UNIPOLSAI AG MONSELICE VIA S. LUIGI 3, 35043 MONSELICE (PD) - P.IVA 04472270281",46123,"ARD  ","Kasko                          ","KASKO DIPENDENTI E AMM.RI IN MISSIONE                                                                                ",881.06,1000,null,"Z0417A140D"]
["UNIPOLSAI AG MONSELICE VIA S. LUIGI 3, 35043 MONSELICE (PD) - P.IVA 04472270281",67898,"RCA  ","Auto LM                        ","PARCO VEICOLI COMUNALI                                                                                                                               ",5033.18,6245.28,null,"Z0417A140D"]
[{"$nulls":5},23273.690000000002,28850.28]

{"sheet":"LM","index":1,"n_rows":62,"n_cols":35,"rows_kept":62,"cut":false,"hidden":false,"merged":[[1,0,5,0],[1,1,5,1],[1,2,5,2],[1,3,5,3],[1,4,5,4],[1,5,5,5],[1,6,5,6],[1,7,5,7],[1,8,5,8],[1,9,5,9],[1,10,5,10],[1,18,5,18],[1,19,5,19],[1,20,5,20],[1,21,5,21],[1,22,5,22],[1,23,5,23],[1,24,5,24],[1,25,5,25],[1,26,5,26],[1,27,5,27],[1,28,5,28],[1,29,5,29],[1,30,5,30],[1,31,5,31],[1,32,5,32],[1,33,5,33],[1,34,5,34],[6,0,10,0],[6,1,10,1],[6,2,10,2],[6,3,10,3],[6,4,10,4],[6,5,10,5],[6,6,10,6],[6,7,10,7],[6,8,10,8],[6,9,10,9],[6,10,10,10],[6,18,10,18],[6,19,10,19],[6,20,10,20],[6,21,10,21],[6,22,10,22],[6,23,10,23],[6,24,10,24],[6,25,10,25],[6,26,10,26],[6,27,10,27],[6,28,10,28],[6,29,10,29],[6,30,10,30],[6,31,10,31],[6,32,10,32],[6,33,10,33],[6,34,10,34],[11,0,15,0],[11,1,15,1],[11,2,15,2],[11,3,15,3],[11,4,15,4],[11,5,15,5],[11,6,15,6],[11,7,15,7],[11,8,15,8],[11,9,15,9],[11,10,15,10],[11,18,15,18],[11,19,15,19],[11,20,15,20],[11,21,15,21],[11,22,15,22],[11,23,15,23],[11,24,15,24],[11,25,15,25],[11,26,15,26],[11,27,15,27],[11,28,15,28],[11,29,15,29],[11,30,15,30],[11,31,15,31],[11,32,15,32],[11,33,15,33],[11,34,15,34],[16,0,20,0],[16,1,20,1],[16,2,20,2],[16,3,20,3],[16,4,20,4],[16,5,20,5],[16,6,20,6],[16,7,20,7],[16,8,20,8],[16,9,20,9],[16,10,20,10],[16,18,20,18],[16,19,20,19],[16,20,20,20],[16,21,20,21],[16,22,20,22],[16,23,20,23],[16,24,20,24],[16,25,20,25],[16,26,20,26],[16,27,20,27],[16,28,20,28],[16,29,20,29],[16,30,20,30],[16,31,20,31],[16,32,20,32],[16,33,20,33],[16,34,20,34],[21,0,25,0],[21,1,25,1],[21,2,25,2],[21,3,25,3],[21,4,25,4],[21,5,25,5],[21,6,25,6],[21,7,25,7],[21,8,25,8],[21,9,25,9],[21,10,25,10],[21,18,25,18],[21,19,25,19],[21,20,25,20],[21,21,25,21],[21,22,25,22],[21,23,25,23],[21,24,25,24],[21,25,25,25],[21,26,25,26],[21,27,25,27],[21,28,25,28],[21,29,25,29],[21,30,25,30],[21,31,25,31],[21,32,25,32],[21,33,25,33],[21,34,25,34],[26,0,30,0],[26,1,30,1],[26,2,30,2],[26,3,30,3],[26,4,30,4],[26,5,30,5],[26,6,30,6],[26,7,30,7],[26,8,30,8],[26,9,30,9],[26,10,30,10],[26,18,30,18],[26,19,30,19],[26,20,30,20],[26,21,30,21],[26,22,30,22],[26,23,30,23],[26,24,30,24],[26,25,30,25],[26,26,30,26],[26,27,30,27],[26,28,30,28],[26,29,30,29],[26,30,30,30],[26,31,30,31],[26,32,30,32],[26,33,30,33],[26,34,30,34],[31,0,35,0],[31,1,35,1],[31,2,35,2],[31,3,35,3],[31,4,35,4],[31,5,35,5],[31,6,35,6],[31,7,35,7],[31,8,35,8],[31,9,35,9],[31,10,35,10],[31,18,35,18],[31,19,35,19],[31,20,35,20],[31,21,35,21],[31,22,35,22],[31,23,35,23],[31,24,35,24],[31,25,35,25],[31,26,35,26],[31,27,35,27],[31,28,35,28],[31,29,35,29],[31,30,35,30],[31,31,35,31],[31,32,35,32],[31,33,35,33],[31,34,35,34],[36,0,40,0],[36,1,40,1],[36,2,40,2],[36,3,40,3],[36,4,40,4],[36,5,40,5],[36,6,40,6],[36,7,40,7],[36,8,40,8],[36,9,40,9],[36,10,40,10],[36,18,40,18],[36,19,40,19],[36,20,40,20],[36,21,40,21],[36,22,40,22],[36,23,40,23],[36,24,40,24],[36,25,40,25],[36,26,40,26],[36,27,40,27],[36,28,40,28],[36,29,40,29],[36,30,40,30],[36,31,40,31],[36,32,40,32],[36,33,40,33],[36,34,40,34],[41,0,45,0],[41,1,45,1],[41,2,45,2],[41,3,45,3],[41,4,45,4],[41,5,45,5],[41,6,45,6],[41,7,45,7],[41,8,45,8],[41,9,45,9],[41,10,45,10],[41,18,45,18],[41,19,45,19],[41,20,45,20],[41,21,45,21],[41,22,45,22],[41,23,45,23],[41,24,45,24],[41,25,45,25],[41,26,45,26],[41,27,45,27],[41,28,45,28],[41,29,45,29],[41,30,45,30],[41,31,45,31],[41,32,45,32],[41,33,45,33],[41,34,45,34],[46,0,50,0],[46,1,50,1],[46,2,50,2],[46,3,50,3],[46,4,50,4],[46,5,50,5],[46,6,50,6],[46,7,50,7],[46,8,50,8],[46,9,50,9],[46,10,50,10],[46,18,50,18],[46,19,50,19],[46,20,50,20],[46,21,50,21],[46,22,50,22],[46,23,50,23],[46,24,50,24],[46,25,50,25],[46,26,50,26],[46,27,50,27],[46,28,50,28],[46,29,50,29],[46,30,50,30],[46,31,50,31],[46,32,50,32],[46,33,50,33],[46,34,50,34],[51,0,55,0],[51,1,55,1],[51,2,55,2],[51,3,55,3],[51,4,55,4],[51,5,55,5],[51,6,55,6],[51,7,55,7],[51,8,55,8],[51,9,55,9],[51,10,55,10],[51,18,55,18],[51,19,55,19],[51,20,55,20],[51,21,55,21],[51,22,55,22],[51,23,55,23],[51,24,55,24],[51,25,55,25],[51,26,55,26],[51,27,55,27],[51,28,55,28],[51,29,55,29],[51,30,55,30],[51,31,55,31],[51,32,55,32],[51,33,55,33],[51,34,55,34],[56,0,60,0],[56,1,60,1],[56,2,60,2],[56,3,60,3],[56,4,60,4],[56,5,60,5],[56,6,60,6],[56,7,60,7],[56,8,60,8],[56,9,60,9],[56,10,60,10],[56,18,60,18],[56,19,60,19],[56,20,60,20],[56,21,60,21],[56,22,60,22],[56,23,60,23],[56,24,60,24],[56,31,60,31],[56,32,60,32],[56,33,60,33],[56,34,60,34],[56,25,60,25],[56,26,60,26],[56,27,60,27],[56,28,60,28],[56,29,60,29],[56,30,60,30]],"flags":["formulas_cached_only"]}
[null,"TIPO VEICOLO","MARCA","TARGA","IMM.NE","CC","CVF","KW","ALIM","Q.LI/P.TI","TARIFFA","09","10","11","12","13","14","15","MAX RCA ","INCENDIO","FURTO","EVENTI NATURALI","EV. SOCIOPOLITICI/VANDALICI","KASKO","GAR. ACCESSORIE","ASSISTENZA","TUTELA LEGALE","VALORE COM. 2015","VALORE COM. 2016","PREMIO LORDO 2015","QUOTAZIONE UNIPOL","QUOTAZIONE VITTORIA","QUOTAZIONE ITAS","QUOTAZIONE AXA","QUOTAZIONE GENERALI ITALIA"]
[1,"AUTOCARRO TRASP. COSE CONTO PROPRIO","FIAT IVECO","PD 937363","1993-01-01",null,null,null,"D",80,"B/M CU ASS.NE 07","00","00","00","00","00","01","--",6000000,{"$nulls":5},"X",null,"X",null,null,1306.53,1306.53]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[2,"AUTOCARRO TRASP. COSE CONTO PROPRIO","FIAT FIORINO","BK650NR","2000-09-01",1372,null,49,"B",17,"B/M CU ASS.NE 04","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,644.67,644.67]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[3,"AUTOVETTURA USO PROPRIO","FIAT PUNTO 60 5 PTE","BD808GL","1999-06-01",1242,14,44,"B",null,"B/M CU ASS.NE 01","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,237.76,237.76]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[4,"AUTOVETTURA USO PROPRIO","FIAT PANDA 900 i.e.","BK718NM","2000-07-01",899,12,29,"B",null,"B/M CU ASS.NE 01","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,204.28,204.28]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[5,"AUTOVETTURA USO PROPRIO","FIAT MULTIPLA 100 16V","BH283YB","2000-06-01",1581,17,76,"B",null,"B/M CU ASS.NE 01","00","00","00","00","00","00","--",6000000,"X","X","X","X","X","X",null,"X",3800,3400,559.73,533.06]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[6,"AUTOCARRO TRASP. COSE CONTO PROPRIO","LAND ROVER DEFENDER 110 C","ZA054NA","2001-08-01",2495,null,90,"D","30 + 35 rim","B/M CU ASS.NE 01","00","00","00","00","00","00","--",6000000,"X","X","X","X","X","X",null,"X",7200,6500,1131.98,1091.4]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[7,"RIMORCHIO CONTO PROPRIO","RSA ITALIA","AC63902","2003-02-01",{"$nulls":4},13,"B/M CU ASS.NE 02","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,32.19,32.19]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[8,"MACCHINA OPERATRICE SEMOVENTE","CARRARO","ABV252","2004-07-01",{"$nulls":4},13,"TARIFFA FISSA","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,194.09,194.09]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[9,"AUTOVEICOLO USO SPECIALE","FIAT DOBLO'","DA044AD","2006-02-01",1910,19,77,"D",20,"B/M CU ASS.NE 05","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,439.4,439.4]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[10,"AUTOVETTURA USO PROPRIO","FIAT PANDA 1.2","DA561ZF","2006-07-01",1242,14,44,"B",null,"B/M CU ASS.NE 05","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,257.91,244.28]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[11,"AUTOVETTURA USO PROPRIO","FIAT DUCATO 2.2","DJ628AR","2007-07-01",2198,21,74,"D",null,"B/M CU ASS.NE 06","00","00","00","00","00","00","--",6000000,{"$nulls":5},"X",null,"X",null,null,587.41,559.99]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[12,"AUTOCARRO TRASP. COSE CONTO PROPRIO","PIAGGIO PORTER","DZ713AG","2009-09-01",1296,null,48,"B",15,"B/M CU ASS.NE 09","00","00","00","00","00","00","--",6000000,"X","X","X","X","X","X",null,"X",8300,5500,899.51,757.63]
[{"$nulls":11},"00","00","00","00","00","00","--"]
[{"$nulls":11},"--","--","--","--","--","--","01"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":11},"--","--","--","--","--","--","00"]
[{"$nulls":4},"COMUNE DI SOLESINO ",{"$nulls":24},6495.46,6245.28,"NON HA QUOTATO PERCHE' FUORI MERCATO","NON HA QUOTATO PERCHE' FUORI MERCATO","NON HA QUOTATO PERCHE' FUORI MERCATO","NON HA QUOTATO PERCHE' FUORI MERCATO"]

{"sheet":"KASKO","index":2,"n_rows":3,"n_cols":19,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,14,0,16],[0,18,1,18],[0,0,1,0],[0,1,1,1],[0,2,0,4],[0,5,0,7],[0,8,0,10],[0,11,0,13]],"flags":["formulas_cached_only"]}
["TIPO POLIZZA","RISCHIO ASSICURATO","UNIPOL ASS.NI ",null,null,"ITAS ASS.NI",null,null,"AXA ASS.NI",null,null,"GENERALI ITALIA ASS.NI",null,null,"VITTORIA ASS.NI",null,null,null,"CIG"]
[null,null,"PREMIO ANNUO","MAX/SOMME ASSICURATI","ALTRE CONDIZIONI NORMATIVE","PREMIO ANNUO","MAX/SOMME ASSICURATI","ALTRE CONDIZIONI NORMATIVE","PREMIO ANNUO","MAX/SOMME ASSICURATI","ALTRE CONDIZIONI NORMATIVE","PREMIO ANNUO","MAX/SOMME ASSICURATI","ALTRE CONDIZIONI NORMATIVE","PREMIO ANNUO","MAX/SOMME ASSICURATI","ALTRE CONDIZIONI NORMATIVE"]
["POLIZZA KASKO DIPENDENTI E AMMINISTRATORI IN MISSIONE","INCENDIO/FURTO/KASKO/CRISTALLI/ASSISTENZA",1000,"€ 10.000,00 PER VEICOLO - KM PREVENTIVATI 3.000 ",null,1200,"VALORE EUROTAX DEL VEICOLO AL MOMENTO DEL SX - KM PREVENTIVATI 3.000","PROPOSTO PREMIO MINIMO PER 10000 KM ANTICIPATI","NON HA QUOTATO IL RISCHIO PERCHE' FUORI MERCATO ( PREMIO MINIMO € 3.000,00 )",null,null,"NON HA QUOTATO IL RISCHIO PERCHE' FUORI MERCATO ( PREMIO MINIMO € 2.000,00 )",null,null,"NON HA QUOTATO IL RISCHIO PERCHE' FUORI MERCATO ",null,null,null,"_____________"]