{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Configurazione","Mesi","Lavoratori","Itinerari","Rimborso Spese"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Configurazione","index":0,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Sede di lavoro"]
["Firenze"]
[]
["Appellativi"]
["Il sig."]
["La sig.ra"]

{"sheet":"Mesi","index":1,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":true,"merged":[]}
["Numero","Nome","Numero"]
["01","Gennaio",{"$f":"A2","v":"01"}]
["02","Febbraio",{"$f":"A3","v":"02"}]
["03","Marzo","03"]
["04","Aprile","04"]
["05","Maggio","05"]
["06","Giugno","06"]
["07","Luglio","07"]
["08","Agosto","08"]
["09","Settembre","09"]
["10","Ottobre","10"]
["11","Novembre","11"]
["12","Dicembre","12"]

{"sheet":"Lavoratori","index":2,"n_rows":3,"n_cols":5,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["Nome","Carburante","Rimborso al Km","Modello auto","Targa"]
["Mario Rossi","DIESEL",0.57999999999999996,"VOLKSWAGEN GOLF 2.0 TDI (115 CV)","AA000AA"]
["Luca Bianchi","BENZINA",0.48,"FIAT PANDA 1.2 FIRE (69 CV)","BB111BB"]

{"sheet":"Itinerari","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["Motivazione (visita/incontro)","Località","Itinerario","Km"]
["Alfa Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B2)","v":"Firenze-Milano"},303]
["Beta Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B3)","v":"Firenze-Bologna"},105]
["Gamma Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B4)","v":"Firenze-Roma"},274]
["Delta Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B5)","v":"Firenze-Napoli"},472]
["Epsilon Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B6)","v":"Firenze-Milano"},303]
["Zeta Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B7)","v":"Firenze-Bologna"},105]
["Eta Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B8)","v":"Firenze-Roma"},274]
["Theta Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B9)","v":"Firenze-Napoli"},472]
["Iota Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B10)","v":"Firenze-Milano"},303]
["Kappa Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B11)","v":"Firenze-Bologna"},105]
["Lambda Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B12)","v":"Firenze-Roma"},274]
["Mu Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B13)","v":"Firenze-Napoli"},472]
["Nu Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B14)","v":"Firenze-Milano"},303]
["Xi Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B15)","v":"Firenze-Bologna"},105]
["Omicron Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B16)","v":"Firenze-Roma"},274]
["Pi Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B17)","v":"Firenze-Napoli"},472]
["Rho Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B18)","v":"Firenze-Milano"},303]
["Sigma Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B19)","v":"Firenze-Bologna"},105]
["Tau Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B20)","v":"Firenze-Roma"},274]
["Upsilon Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B21)","v":"Firenze-Napoli"},472]
["Phi Srl","Milano",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B22)","v":"Firenze-Milano"},303]
["Chi Spa","Bologna",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B23)","v":"Firenze-Bologna"},105]
["Psi Srl","Roma",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B24)","v":"Firenze-Roma"},274]
["Omega Spa","Napoli",{"$f":"CONCATENATE(Configurazione!$A$2,\"-\", B25)","v":"Firenze-Napoli"},472]

{"sheet":"Rimborso Spese","index":4,"n_rows":31,"n_cols":23,"rows_kept":31,"cut":false,"hidden":false,"merged":[[1,3,1,7],[1,0,1,2],[1,8,1,9],[6,1,6,2],[3,0,3,1],[3,3,3,4],[8,3,8,4],[10,9,10,10],[9,3,9,4],[10,3,10,4],[3,5,3,6],[9,9,9,10],[5,7,5,9],[6,7,6,9],[6,4,6,5],[20,9,20,10],[21,9,21,10],[22,9,22,10],[19,9,19,10],[23,9,23,10],[25,3,25,4],[26,3,26,4],[18,3,18,4],[19,3,19,4],[20,3,20,4],[21,3,21,4],[22,3,22,4],[23,3,23,4],[24,3,24,4],[16,3,16,4],[17,3,17,4],[15,3,15,4],[18,9,18,10],[11,3,11,4],[13,3,13,4],[14,3,14,4],[15,9,15,10],[16,9,16,10],[17,9,17,10],[11,9,11,10],[13,9,13,10],[14,9,14,10],[12,9,12,10],[12,3,12,4],[28,5,28,8],[28,9,28,10],[30,5,30,8],[30,9,30,10],[24,9,24,10],[25,9,25,10],[26,9,26,10]]}
[]
["NOME AZIENDA SRL",null,null,"RIMBORSO SPESE DEL MESE DI",null,null,null,null,{"$f":"VLOOKUP(TEXT(MONTH(TODAY())-1,\"00\"),Mesi!$A$2:$B$13,2,FALSE)","v":"Maggio"},null,{"$f":"YEAR(TODAY())","v":2026}]
[]
["Il sig.",null,"Mario Rossi","sede di lavoro:",null,{"$f":"Configurazione!$A$2","v":"Firenze"}]
["ha effettuato i viaggi sotto elencati per raggiungere le destinazioni indicate a scopo di lavoro."]
["Essendo preventivamente autorizzato, ha utilizzato il proprio automezzo",null,null,null,null,null,null,"Carburante utilizzato",null,null,{"$f":"IF($C$4=\"\",\"\",VLOOKUP($C$4,Lavoratori!$A$2:$C$3,2,FALSE))","v":"DIESEL"}]
["modello",{"$f":"IF($C$4=\"\",\"\",VLOOKUP($C$4,Lavoratori!$A$2:$E$3,4,FALSE))","v":"VOLKSWAGEN GOLF 2.0 TDI (115 CV)"},null,"targa",{"$f":"IF($C$4=\"\",\"\",VLOOKUP($C$4,Lavoratori!$A$2:$E$3,5,FALSE))","v":"AA000AA"},null,null,"quota kilometrica (€/Km)",null,null,{"$f":"IF($C$4=\"\",0,VLOOKUP($C$4,Lavoratori!$A$2:$C$3,3,FALSE))","v":0.57999999999999996}]
[]
[null,"località","itinerario",null,null,"autostr.","treno","bus","pasti"," "]
["data","raggiunta","andata e ritorno","Km",null,"parking","aereo","metro","pernot.","motivazione (visita/incontro)",null,null,null,null,null,null,null,null,null,null,null,null,"Giorno"]
[{"$f":"IF(OR($W11=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W11,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":"01/05/2026"},{"$f":"IF($J11=\"\",\"\",VLOOKUP($J11,Itinerari!$A$2:$D$83,2,FALSE))","v":"Milano"},{"$f":"IF($J11=\"\",\"\",VLOOKUP($J11,Itinerari!$A$2:$D$83,3,FALSE))","v":"Firenze-Milano"},{"$f":"IF($J11=\"\",\"\",VLOOKUP($J11,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":606},null,48.48,null,null,15,"Alfa Srl",null,null,null,null,null,null,null,null,null,null,null,null,"1"]
[{"$f":"IF(OR($W12=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W12,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":"02/05/2026"},{"$f":"IF($J12=\"\",\"\",VLOOKUP($J12,Itinerari!$A$2:$D$83,2,FALSE))","v":"Bologna"},{"$f":"IF($J12=\"\",\"\",VLOOKUP($J12,Itinerari!$A$2:$D$83,3,FALSE))","v":"Firenze-Bologna"},{"$f":"IF($J12=\"\",\"\",VLOOKUP($J12,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":210},null,16.8,null,null,11,"Beta Spa",null,null,null,null,null,null,null,null,null,null,null,null,"2"]
[{"$f":"IF(OR($W13=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W13,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":"03/05/2026"},{"$f":"IF($J13=\"\",\"\",VLOOKUP($J13,Itinerari!$A$2:$D$83,2,FALSE))","v":"Roma"},{"$f":"IF($J13=\"\",\"\",VLOOKUP($J13,Itinerari!$A$2:$D$83,3,FALSE))","v":"Firenze-Roma"},{"$f":"IF($J13=\"\",\"\",VLOOKUP($J13,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":548},null,43.84,null,null,25,"Gamma Srl",null,null,null,null,null,null,null,null,null,null,null,null,"3"]
[{"$f":"IF(OR($W14=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W14,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J14=\"\",\"\",VLOOKUP($J14,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J14=\"\",\"\",VLOOKUP($J14,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J14=\"\",\"\",VLOOKUP($J14,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W15=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W15,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J15=\"\",\"\",VLOOKUP($J15,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J15=\"\",\"\",VLOOKUP($J15,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J15=\"\",\"\",VLOOKUP($J15,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W16=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W16,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J16=\"\",\"\",VLOOKUP($J16,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J16=\"\",\"\",VLOOKUP($J16,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J16=\"\",\"\",VLOOKUP($J16,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W17=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W17,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J17=\"\",\"\",VLOOKUP($J17,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J17=\"\",\"\",VLOOKUP($J17,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J17=\"\",\"\",VLOOKUP($J17,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W18=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W18,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J18=\"\",\"\",VLOOKUP($J18,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J18=\"\",\"\",VLOOKUP($J18,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J18=\"\",\"\",VLOOKUP($J18,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W19=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W19,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J19=\"\",\"\",VLOOKUP($J19,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J19=\"\",\"\",VLOOKUP($J19,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J19=\"\",\"\",VLOOKUP($J19,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W20=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W20,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J20=\"\",\"\",VLOOKUP($J20,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J20=\"\",\"\",VLOOKUP($J20,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J20=\"\",\"\",VLOOKUP($J20,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W21=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W21,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J21=\"\",\"\",VLOOKUP($J21,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J21=\"\",\"\",VLOOKUP($J21,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J21=\"\",\"\",VLOOKUP($J21,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W22=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W22,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J22=\"\",\"\",VLOOKUP($J22,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J22=\"\",\"\",VLOOKUP($J22,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J22=\"\",\"\",VLOOKUP($J22,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W23=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W23,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J23=\"\",\"\",VLOOKUP($J23,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J23=\"\",\"\",VLOOKUP($J23,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J23=\"\",\"\",VLOOKUP($J23,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W24=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W24,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J24=\"\",\"\",VLOOKUP($J24,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J24=\"\",\"\",VLOOKUP($J24,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J24=\"\",\"\",VLOOKUP($J24,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W25=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W25,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J25=\"\",\"\",VLOOKUP($J25,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J25=\"\",\"\",VLOOKUP($J25,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J25=\"\",\"\",VLOOKUP($J25,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W26=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W26,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J26=\"\",\"\",VLOOKUP($J26,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J26=\"\",\"\",VLOOKUP($J26,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J26=\"\",\"\",VLOOKUP($J26,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[{"$f":"IF(OR($W27=\"\",$I$2=\"\"),\"\",CONCATENATE(TEXT($W27,\"00\"),\"/\",VLOOKUP($I$2,Mesi!$B$2:$C$13,2,FALSE),\"/\",$K$2))","v":""},{"$f":"IF($J27=\"\",\"\",VLOOKUP($J27,Itinerari!$A$2:$D$83,2,FALSE))","v":""},{"$f":"IF($J27=\"\",\"\",VLOOKUP($J27,Itinerari!$A$2:$D$83,3,FALSE))","v":""},{"$f":"IF($J27=\"\",\"\",VLOOKUP($J27,Itinerari!$A$2:$D$83,4,FALSE)*2)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,""]
[null,null,"Totali",{"$f":"SUM(D11:D27)","v":1364},{"$f":"D28*K7","v":791.11999999999989},{"$f":"SUM(F11:F27)","v":109.12},{"$f":"SUM(G11:G27)","v":0},{"$f":"SUM(H11:H27)","v":0},{"$f":"SUM(I11:I27)","v":51},"Tot. Spese",{"$f":"E28+F28+G28+H28+I28","v":951.2399999999999}]
[null,null,null,null,null,"firma interessato",null,null,null,"    visto contabilità per rimborso"]
["data ",null,"numero giustificativi"]
[{"$f":"TODAY()","v":"2026-06-18"}]