{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Preventivo","Conteggio finale","Einstellungen"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"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"}

{"sheet":"Preventivo","index":0,"n_rows":64,"n_cols":7,"rows_kept":64,"cut":false,"hidden":false,"merged":[[62,6,62,10],[2,2,2,6],[2,9,2,10],[63,0,63,1],[63,6,63,10],[24,1,24,2],[54,1,54,2],[56,1,56,2],[61,1,61,2],[59,1,59,2],[21,1,21,2],[40,1,40,2],[42,1,42,2],[44,1,44,2],[49,1,49,2],[52,1,52,2],[38,1,38,2],[4,1,4,6],[26,1,26,2],[14,1,14,2],[8,1,8,2],[10,1,10,2],[12,1,12,2],[18,1,18,4],[28,1,28,2],[30,1,30,2],[32,1,32,2],[34,1,34,2],[36,1,36,2]]}
["Riassunto del preventivo"]
[]
["Nome progetto"]
[]
["1","Costi per l’intera durata del progetto"]
[]
[{"$nulls":4},"Importo in CHF"]
[]
[1.1000000000000001,"Costi interni per il personale"]
[]
[1.2,"Costi beni e servizi e prest. di terzi"]
[]
["1.3","Riserve"]
[]
[1,"Totale costi",null,null,{"$f":"SUM(E9:E13)","v":0}]
[]
[]
[]
[2,"Proventi per l’intera durata del progetto"]
[]
[{"$nulls":4},"Importo in CHF",null,"Quota"]
["2.1","Contributo dell'FPT",{"$nulls":4},{"$f":"IF(E15>0,E22/E15,\"\")","v":""}]
[]
[]
["2.2","Altri finanziatori",null,null,"Importo in CHF",null,"Stato"]
[]
["2.2.1"]
[]
["2.2.2"]
[]
["2.2.3"]
[]
["2.2.4"]
[]
["2.2.5"]
[]
["2.2.6"]
[]
["2.2.7"]
[]
["2.2.8"]
[]
["2.2.9"]
[]
["2.2.10","Altri (non specificati)"]
[]
[]
[{"$nulls":4},"Importo in CHF"]
[]
["2.3","Prestazioni proprie"]
[]
[]
["2.4","Altri proventi",null,null,"Importo in CHF"]
[]
["2.4.1","Interessi sui sussidi FPT"]
[]
["2.4.2","Altre"]
[]
[]
["2","Totale proventi",null,null,{"$f":"E22+SUM(E27:E45)+SUM(E50:E50)+SUM(E55:E57)","v":0}]
[]
[null,"Utile (+) o perdita (-)",null,null,{"$f":"E60-E15","v":0}]
[]
["Luogo, data",null,null,null,"Firma"]

{"sheet":"Conteggio finale","index":1,"n_rows":86,"n_cols":10,"rows_kept":86,"cut":false,"hidden":false,"merged":[[84,6,84,10],[85,6,85,10],[41,1,41,2],[44,1,44,2],[46,1,46,2],[72,1,72,2],[50,1,50,2],[56,1,56,2],[58,1,58,2],[60,1,60,2],[52,1,52,2],[54,1,54,2],[48,1,48,2],[35,1,35,2],[37,1,37,2],[39,1,39,2],[2,11,2,12],[85,0,85,1],[74,1,74,2],[76,1,76,2],[78,1,78,2],[81,1,81,2],[83,1,83,2],[62,1,62,2],[64,1,64,2],[66,1,66,2],[68,1,68,2],[70,1,70,2],[23,1,23,2],[2,2,2,6],[8,1,8,2],[10,1,10,2],[12,1,12,2],[4,1,4,4],[29,1,29,2],[31,1,31,2],[33,1,33,2],[15,1,15,4],[18,1,18,2],[21,1,21,2],[25,1,25,2],[27,1,27,2]]}
["Riassunto del conteggio finale"]
[]
["Nome progetto",null,{"$f":"IF(Preventivo!C3<>\"\",Preventivo!C3,\"\")","v":""},{"$nulls":6},"Decisione n.:"]
[]
["1","Costi per l’intera durata del progetto"]
[]
[{"$nulls":4},"Importo in CHF",null,"Preventivo",null,"Scostamento"]
[]
[1.1000000000000001,"Costi interni per il personale",{"$nulls":4},{"$f":"Preventivo!E9","v":0},null,{"$f":"E9-G9","v":0}]
[]
[1.2,"Costi beni e servizi e prest. di terzi",{"$nulls":4},{"$f":"Preventivo!E11","v":0},null,{"$f":"E11-G11","v":0}]
[]
[1,"Totale costi",null,null,{"$f":"SUM(E9:E12)","v":0},null,null,null,{"$f":"SUM(I9:I12)","v":0}]
[]
[]
[2,"Proventi per l’intera durata del progetto"]
[]
[]
["2.1","Versamenti dell'FPT",null,null,"Importo in CHF"]
[]
[]
["2.1.1","Primo versamento"]
[]
["2.1.2","Secondo versamento"]
[]
["2.1.3","Terzo versamento"]
[]
["2.1.4","Quarto versamento"]
[]
["2.1.5","Quinto versamento"]
[]
["2.1.6","Sesto versamento"]
[]
["2.1.7","Settimo versamento"]
[]
["2.1.8","Ottavo versamento"]
[]
["2.1.9","Nono versamento"]
[]
["2.1.10","Decimo versamento"]
[]
["2.1.11","Versamento finale richiesto"]
[{"$nulls":6},"Preventivo",null,"Scostamento"]
[]
["2.1","Totale FPT",null,null,{"$f":"SUM(E22:E42)","v":0},null,{"$f":"Preventivo!E22","v":0},null,{"$f":"E45-G45","v":0}]
[]
[null,"Quota FPT",null,null,{"$f":"IF(E13>0,E45/E13,\"\")","v":""}]
[]
["2.2","Altri finanziatori",null,null,"Importo in CHF",null,"Preventivo",null,"Scostamento"]
[]
["2.2.1",{"$nulls":5},{"$f":"IF(Preventivo!E27<>\"\",Preventivo!E27,\"\")","v":""},null,{"$f":"IF(E51=\"\",IF(G51=\"\",\"\",0-G51),IF(G51=\"\",E51-0,E51-G51))","v":""}]
[]
["2.2.2",{"$nulls":5},{"$f":"IF(Preventivo!E29<>\"\",Preventivo!E29,\"\")","v":""},null,{"$f":"IF(E53=\"\",IF(G53=\"\",\"\",0-G53),IF(G53=\"\",E53-0,E53-G53))","v":""}]
[]
["2.2.3",{"$nulls":5},{"$f":"IF(Preventivo!E31<>\"\",Preventivo!E31,\"\")","v":""},null,{"$f":"IF(E55=\"\",IF(G55=\"\",\"\",0-G55),IF(G55=\"\",E55-0,E55-G55))","v":""}]
[]
["2.2.4",{"$nulls":5},{"$f":"IF(Preventivo!E33<>\"\",Preventivo!E33,\"\")","v":""},null,{"$f":"IF(E57=\"\",IF(G57=\"\",\"\",0-G57),IF(G57=\"\",E57-0,E57-G57))","v":""}]
[]
["2.2.5",{"$nulls":5},{"$f":"IF(Preventivo!E35<>\"\",Preventivo!E35,\"\")","v":""},null,{"$f":"IF(E59=\"\",IF(G59=\"\",\"\",0-G59),IF(G59=\"\",E59-0,E59-G59))","v":""}]
[]
["2.2.6",{"$nulls":5},{"$f":"IF(Preventivo!E37<>\"\",Preventivo!E37,\"\")","v":""},null,{"$f":"IF(E61=\"\",IF(G61=\"\",\"\",0-G61),IF(G61=\"\",E61-0,E61-G61))","v":""}]
[]
["2.2.7",{"$nulls":5},{"$f":"IF(Preventivo!E39<>\"\",Preventivo!E39,\"\")","v":""},null,{"$f":"IF(E63=\"\",IF(G63=\"\",\"\",0-G63),IF(G63=\"\",E63-0,E63-G63))","v":""}]
[]
["2.2.8",{"$nulls":5},{"$f":"IF(Preventivo!E41<>\"\",Preventivo!E41,\"\")","v":""},null,{"$f":"IF(E65=\"\",IF(G65=\"\",\"\",0-G65),IF(G65=\"\",E65-0,E65-G65))","v":""}]
[]
["2.2.9",{"$nulls":5},{"$f":"IF(Preventivo!E43<>\"\",Preventivo!E43,\"\")","v":""},null,{"$f":"IF(E67=\"\",IF(G67=\"\",\"\",0-G67),IF(G67=\"\",E67-0,E67-G67))","v":""}]
[]
["2.2.10","Ulteriori finanziatori",{"$nulls":4},{"$f":"IF(Preventivo!E45<>\"\",Preventivo!E45,\"\")","v":""},null,{"$f":"IF(E69=\"\",IF(G69=\"\",\"\",0-G69),IF(G69=\"\",E69-0,E69-G69))","v":""}]
[]
["2.3",null,null,null,"Importo in CHF",null,"Preventivo",null,"Scostamento"]
[]
["2.3","Prestazioni proprie",{"$nulls":4},{"$f":"IF(Preventivo!E50<>\"\",Preventivo!E50,\"\")","v":""},null,{"$f":"IF(E73=\"\",IF(G73=\"\",\"\",0-G73),IF(G73=\"\",E73-0,E73-G73))","v":""}]
[]
["2.4","Altri proventi",null,null,"Importo in CHF",null,"Preventivo",null,"Scostamento"]
[]
["2.4.1","Interessi sui sussidi FPT",{"$nulls":4},{"$f":"IF(Preventivo!E55<>\"\",Preventivo!E55,\"\")","v":""},null,{"$f":"IF(E77=\"\",IF(G77=\"\",\"\",0-G77),IF(G77=\"\",E77-0,E77-G77))","v":""}]
[]
["2.4.2","Altre",{"$nulls":4},{"$f":"IF(Preventivo!E57<>\"\",Preventivo!E57,\"\")","v":""},null,{"$f":"IF(E79=\"\",IF(G79=\"\",\"\",0-G79),IF(G79=\"\",E79-0,E79-G79))","v":""}]
[]
[]
["2","Totale proventi",null,null,{"$f":"E45+SUM(E51:E70)+SUM(E73:E73)+SUM(E77:E79)","v":0}]
[]
[null,"Utile (+) o perdita (-)",null,null,{"$f":"E82-E13","v":0}]
[]
["Luogo, data",null,null,null,"Firma"]

{"sheet":"Einstellungen","index":2,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["zugesichert"]
["angefragt"]
["geplant"]