{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Foglio1"],"not_rendered":{"charts":3,"images":11,"macros":0,"external_links":0,"defined_names":1,"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":"Foglio1","index":0,"n_rows":55,"n_cols":16,"rows_kept":55,"cut":false,"hidden":false,"merged":[[1,13,1,14],[0,0,1,7],[17,0,17,7],[26,0,27,4],[26,5,27,7],[1,10,1,11]]}
["FLAT TAX INCREMENTALE"]
[null,null,null,null,null,null,null,null,null,null,"IMPOSTE CON  FLAT TAX INCREMENTALE",null,null,"IMPOSTE SENZA FLAT TAX INCREMENTALE "]
["ANNO","2020",null,"2021",null,"2022",null,null,null,null,"MAX SU BASE RAFFFRONTO 2020 - 2022",{"$f":"IF(H10=4,MAX(B4:F4),\"\")","v":50000}]
["reddito",15000,{"$f":"+IF(B4<>\"\",1,0)","v":1},50000,{"$f":"+IF(D4<>\"\",1,0)","v":1},20000,{"$f":"+IF(F4<>\"\",1,0)","v":1},null,null,null,"FRANCHIGIA",{"$f":"IF(H10=4,+L3*5%,\"\")","v":2500}]
[null,null,null,null,null,null,null,null,null,null,"MAX + FRANCHIGIA",{"$f":"IF(H10=4,L3+L4,0)","v":52500}]
[null,null,null,null,null,null,null,null,null,null,"DIFFERENZA ENTRO IL LIMITE MAX",{"$f":"IF(B10-L5>0,(IF((B10-L5)>40000,40000,B10-L5)),\"Diff. Negativa\")","v":27500}]
[null,null,null,null,null,null,null,null,null,null,"REDDITO ASSOGG. A IMPOSTA SOST.",{"$f":"L6","v":27500}]
[null,null,null,null,null,null,null,null,null,null,"IMPOSTA SOSTITUTIVA",{"$f":"IF(L7<>\"Diff. Negativa\",L7*15%,0)","v":4125}]
["ANNO","2023","Colonna1",null,null,null,null,null,null,null,"REDDITO ASSOGGETTATO A IRPEF",{"$f":"IF(L7<>\"Diff. Negativa\",Foglio1!$B$10:$B$10-L7,0)","v":52500}]
["reddito",80000,{"$f":"+IF(B10<>\"\",1,0)","v":1},null,null,null,null,{"$f":"+C4+E4+G4+C10","v":4}]
[null,null,null,null,null,null,null,null,null,null,"IRPEF",null,null,"IRPEF"]
[null,null,null,null,null,null,null,null,null,null,"REDDITO IMPONIBILE",{"$f":"+L9","v":52500},null,"REDDITO IMPONIBILE",{"$f":"+Foglio1!$B$10:$B$10","v":80000}]
[null,null,null,null,null,null,null,null,null,null,"IMPOSTA SULLO SCAGLIONE",{"$f":"+VLOOKUP($L$12,Tabella1[],2,1)","v":6700},null,"IMPOSTA SULLO SCAGLIONE",{"$f":"+VLOOKUP(O12,Tabella1[],2,1)","v":16150}]
[null,null,null,null,null,null,null,null,null,null,"ALIQUOTA SULL'ECCEDENZA",{"$f":"VLOOKUP($L$12,Tabella1[],3,TRUE)","v":0.35},null,"ALIQUOTA SULL'ECCEDENZA",{"$f":"VLOOKUP($O$12,Tabella1[],3,TRUE)","v":0.43}]
[null,null,null,null,null,null,null,null,null,null,"REDDITO ECCEDENZA SCAGLIONE",{"$f":"$L$12-(VLOOKUP($L$12,Tabella1[#All],1,1))","v":24500},null,"REDDITO ECCEDENZA SCAGLIONE",{"$f":"$O$12-(VLOOKUP($O$12,Tabella1[#All],1,1))","v":25000}]
[null,null,null,null,null,null,null,null,null,null,"IMPOSTA SULL'ECCEDENZA",{"$f":"L14*L15","v":8575},null,"IMPOSTA SULL'ECCEDENZA",{"$f":"O14*O15","v":10750}]
[null,null,null,null,null,null,null,null,null,null,"DETRAZIONI  lavoro autonomo",{"$f":"IF($L$12<5500,1265,(IF(AND($L$12<28000,$L$12>=5500),(500+(1265-500))*(28000-$L$12)/(28000-5500),IF(AND($L$12<50000,$L$12>=28000),(500*(50000-$L$12))/(50000-28000),0))))","v":0},null,"DETRAZIONI  lavoro autonomo",{"$f":"IF($O$12<5500,1265,(IF(AND($O$12<28000,$O$12>=5500),(500+(1265-500))*(28000-$O$12)/(28000-5500),IF(AND($O$12<50000,$O$12>=28000),(500*(50000-$O$12))/(50000-28000),0))))","v":0}]
[{"$f":"IF(Foglio1!$B$10:$B$10-MAX(Foglio1!$B$4:$F$4)>0,\"BENEFICIO SPETTANTE\", \"BENEFICIO NON SPETTANTE\")","v":"BENEFICIO SPETTANTE"},null,null,null,null,null,null,null,null,null,"altre detrazioni manuali",null,null,"altre detrazioni manuali"]
[null,null,null,null,null,null,null,null,null,null,"Totale IRPEF",{"$f":"+L13+L16-L17-L18","v":15275},null,"Totale IRPEF",{"$f":"+O13+O16-O17-O18","v":26900}]
[]
[null,null,null,null,null,null,null,null,null,null,"IRPEF + FLAT TAX INCREM.LE",{"$f":"+L8+L19","v":19400},null,"SOLO IRPEF ",{"$f":"+O9+O19","v":26900}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"REDDITO","IRPEF + FLAT TAX ","REDD.TO DISP. W FLAT TAX",null,"SOLO IRPEF ","REDD.TO DISP. W/OUT FT"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(K28/$K$28,\"-\")","v":1},{"$f":"IFERROR(L28/$K$28,\"-\")","v":0.24249999999999999},{"$f":"1-L25","v":0.75750000000000006},null,{"$f":"IFERROR(O28/$K$28,\"_\")","v":0.33624999999999999},{"$f":"1-O25","v":0.66375000000000006}]
[null,null,null,null,null,null,null,null,null,null,null,1,1,null,1,1]
[{"$f":"+IF(H10<4,\"\",\"RISPARMIO\")","v":"RISPARMIO"},null,null,null,null,{"$f":"IF(A18=\"BENEFICIO SPETTANTE\",O21-L21,\"\")","v":7500},null,null,null,null,null,{"$f":"+L25-0.07","v":0.17249999999999999},{"$f":"+M25","v":0.75750000000000006},null,{"$f":"+O25-0.07","v":0.26624999999999999},{"$f":"+P25","v":0.66375000000000006}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"+O12","v":80000},{"$f":"+L21","v":19400},null,null,{"$f":"+O21","v":26900}]
[]
[]
[]
["ALIQUOTE IRPEF","Q.TA FISSA ","SULL'ECCEDENZA"]
[0,0,0.23]
[15000,{"$f":"+Tabella1[[#This Row],[ALIQUOTE IRPEF]]*C33","v":3450},0.25]
[28000,{"$f":"+(Tabella1[[#This Row],[ALIQUOTE IRPEF]]-A34)*C34+B34","v":6700},0.35]
[55000,{"$f":"+(Tabella1[[#This Row],[ALIQUOTE IRPEF]]-A35)*C35+B35","v":16150},0.43]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[{"$f":"+IF($H$10<4,\"COMPILA TUTTE LE CASELLE\",\"\")","v":""}]