{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Calcoli"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":0,"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":"Calcoli","index":0,"n_rows":39,"n_cols":4,"rows_kept":39,"cut":false,"hidden":false,"merged":[[28,1,28,3],[3,1,3,3],[14,2,14,3],[15,2,15,3],[17,1,17,3],[19,1,19,2],[26,1,26,2],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3]]}
[]
[]
[]
[null,"Input dati"]
[]
[null,"Dati dello studio"]
[]
[null,"Fornitore"]
[null,"Data fattura"]
[null,"Numero fattura"]
[null,"Prot. IVA"]
[]
[null,"Aliquote"]
[]
[null,"Imposta Ires",0.24]
[null,"Imposta Irap",3.9E-2]
[]
[null,"Calcoli"]
[]
[null,"Importo bene agevolato",null,100000]
[null,"Credito d'imposta bonus Sud",0.45,{"$f":"+D20*C21","v":45000}]
[null,"Credito d'imposta L. 178/2020",0.5,{"$f":"+D20*C22","v":50000}]
[null,"Mancata tassazione Ires ",{"$f":"C22*C15","v":0.12},{"$f":"+D20*C23","v":12000}]
[null,"Mancata tassazione Irap ",{"$f":"+C22*C16","v":1.95E-2},{"$f":"+D20*C24","v":1950}]
[null,"Totale agevolazione",{"$f":"SUM(C21:C24)","v":1.0894999999999999},{"$f":"SUM(D21:D24)","v":108950}]
[]
[null,"Eccedenza agevolazione",null,{"$f":"+D25-D20","v":8950}]
[]
[null,"Ricalcolo"]
[]
[null,{"$f":"+B20","v":"Importo bene agevolato"},null,{"$f":"+D20","v":100000}]
[null,"Credito d'imposta bonus Sud",0.45,{"$f":"+D31*C32","v":45000}]
[null,"Credito d'imposta L. 178/2020 ricalcolato",{"$f":"+D33/D31","v":0.43002345582486307},43002.345582486305]
[null,"Mancata tassazione Ires",{"$f":"C33*C15","v":0.10320562939796714},{"$f":"D33*C15","v":10320.562939796713}]
[null,"Mancata tassazione Irap",{"$f":"+C33*C16","v":1.677091477716966E-2},{"$f":"D33*C16","v":1677.091477716966}]
[null,"Totale agevolazione",{"$f":"SUM(C32:C35)","v":0.99999999999999989},{"$f":"SUM(D32:D35)","v":99999.999999999985}]
[null,"Riduzione credito d'imposta L. 178/2020",null,{"$f":"+D22-D33","v":6997.6544175136951}]
[]
[null,"Eccedenza agevolazione",null,{"$f":"+D31-D36","v":0}]