{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["FORMULE","ITALIANI","STRANIERI","CALCOLI","Foglio1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"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":"FORMULE","index":0,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":true,"merged":[[18,1,18,2]]}
[]
[null,"ISEE","FORMULA"]
[null,"fino a 22000",0]
[null,"TRA 22001 E 24000","(isee- 22000)*0,014"]
[null,"TRA 24001 E 26000","(isee- 22000)*0,035"]
[null,"TRA 26001 E 28000","(isee- 22000)*0,0525"]
[null,"TRA 28001 E 30000","(isee- 22000)*0,063"]
[null,"TRA 30001 E 40000","0,0225*ISEE-170"]
[null,"TRA 40001 E 50000","0,052*ISEE-1350,3"]
[null,"TRA 50001 E 60000","0,02*ISEE+249,88"]
[null,"TRA 60001 E 70000","0,02*ISEE+249,86"]
[null,"TRA 70001 E 80000","0,025*ISEE-100,20"]
[null,"TRA 80001 E 90000","0,025*ISEE-100,23"]
[null,"TRA 90001 E 100000","0,025*ISEE-100,25"]
[null,"OLTRE 100000","2400 EURO"]
[]
[]
[]
[null,"SENZA REQUISITI"]
[null,"TRA 0 E 30000",1600]
[null,"DA 30001 A 50000",1900]
[null,"DA 50001 A 70000",2300]
[null,"DA 70001 A 90000",2500]
[null,"DA 90001",2700]

{"sheet":"ITALIANI","index":1,"n_rows":31,"n_cols":18,"rows_kept":31,"cut":false,"hidden":true,"merged":[[16,1,16,2],[16,4,16,11],[0,1,1,11],[20,1,20,2],[25,1,26,1],[10,1,10,2],[8,1,9,2],[22,1,22,2],[24,1,24,2],[23,1,23,2],[2,1,3,11],[17,1,17,10],[19,1,19,2],[21,1,21,2],[6,1,6,2],[7,1,7,2],[5,1,5,2],[4,1,4,8],[10,4,10,11],[15,1,15,2],[12,1,12,2],[13,1,13,2],[14,1,14,2],[12,4,12,11],[13,4,13,11],[14,4,14,11],[15,4,15,11]]}
[null,"CONSERVATORIO DI FROSINONE - SIMULATORE CALCOLO CONTRIBUTO E TASSE CORSI ACCADEMICI DI I E II LIVELLO"]
[]
[null,"Attraverso il Simulatore tasse puoi ottenere una stima dell’importo che dovrai pagare in base alla tua situazione."]
[]
[null,"Per visualizzare gli importi simulati devi inserire i seguenti dati"]
[null,"ISEE UNIVERSITA'",null,"-","se non hai ISEE valido inserisci un trattino nella casella -"]
[null,"Corso",null,"TRIENNIO"]
[null,"Anno di Corso ",null,"PT1"]
[null,"Tiplogia di frequenza "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"fino a € 22.000,00","€ 200,00"]
[null,"Numero crediti acquisiti dal 10 AGOSTO 2022 al 10 AGOSTO 2023",null,{"$f":"IF(OR($D$8=CALCOLI!D9,$D$8=CALCOLI!D16,$D$8=CALCOLI!E9,$D$8=CALCOLI!E14),0,\"INSERISCI CREDITI NELLA CASELLA SOTTOSTANTE\")","v":"INSERISCI CREDITI NELLA CASELLA SOTTOSTANTE"},"Se stai iscrivendo agli anni successivi al primo puoi visualizzare il numero di crediti richiesti, nella tua pagina di isidata in \"controllo crediti\" inserendo nel filtro in alto le date qui indicate e visualizzando il risultato in \"crediti acquisiti\"",null,null,null,null,null,null,null,null,null,null,null,"da € 22.000,01 a € 24.000,00","€ 400,00"]
[null,null,null,6,null,null,null,null,null,null,null,null,null,null,null,null,"da € 24.000,01 a € 26.000,00","€ 600,00"]
[null,"sei uno studente con invalidità superiore o uguale al 66%?",null,"SI","rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,null,"da € 26.000,01 a € 28.000,00","€ 800,00"]
[null,"sei idoneo o vincitore della borsa di studio Laziodisco?",null,"NO","rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,null,"da € 28.000,01 a € 30.000,00","€ 1000,00"]
[null,"hai genitori beneficiari di pensione di inabilità?",null,"NO","rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,null,"da € 30.000,01 a € 40.000,00","€ 1200,00"]
[null,"hai familiari portatori di handicap con invalidità superiore o uguale all'80%?",null,"NO","rispondi SI o NO",null,null,null,null,null,null,null,null,null,6.04,null,"da € 40.000,01 a € 50.000,00","€ 1400,00"]
[null,"ti stai iscrivendo al primo anni di Arpa o Fagotto?",null,"NO","rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,null,"da € 50.000,01 a € 60.000,00","€ 1600,00"]
[null,"Stima delle tasse accademiche  in base ai dati inseriti",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"da € 60.000,01 a € 70.000,00","€ 1800,00"]
[null,null,null,null,"Modalità di pagamento",null,null,null,null,null,null,null,null,null,1600,null,"da € 70.000,01 a € 80.000,00","€ 2150,00"]
[null,"Valore ISEE Dichiarato: ",null,{"$f":"D6","v":"-"},null,null,null,null,null,null,null,null,null,null,1900,null,"da € 80.000,01 a € 90.000,00","€ 2350,00"]
[null,"il requisito crediti è soddisfatto?",null,{"$f":"IF(OR(AND(D8=1,D12=0),AND(D8=\"PT1\",D12=0),AND(D8=2,D12>=10),AND(D8=\"BIS1\",D12>=10),AND(D8=3,D12>=25),AND(D8=\"FC1\",D12>=25),AND(D8=\"PT2\",D12>=25),AND(D8=\"PT3\",D12>=25),AND(D8=\"BIS2\",D12>=25), AND(D8=\"BIS3\",D12>=25),AND(D8=\"FC3\",D12>=25),AND(D8=\"FC2\",D12>=25)),\"SI\",\"NO\")","v":"NO"},null,null,null,null,null,null,null,null,null,null,2300,null,"da € 90.000,01 a € 100.000,00","€ 2550,00"]
[null,"Marca da Bollo",null,16,"procedura Pago PA https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108",null,null,null,null,null,null,null,null,null,2500,null,"da € 100.000,01 in avanti","€ 2550,00"]
[null,"Tassa regionale laziodisco",null,{"$f":"IF($D$13=\"SI\",0,140)","v":0},"procedura Pago PA Laziodisco http://www.laziodisco.it/pagopa/",null,null,null,null,null,null,null,null,null,2700]
[null,"Tassa di immatricolazione",null,{"$f":"IF(OR($D$13=\"SI\",$D$15=\"SI\",D8=2,D8=3,D8=\"FC1\",D8=\"FC2\",D8=\"FC3\",D8=\"PT2\",D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\"),0,6.04)","v":0},"C/C 1016 intestato Agenzia delle entrate- centro operativo di Pescara- tasse scolastiche"]
[null,"Tassa di Frequenza",null,{"$f":"IF(OR($D$13=\"SI\",$D$15=\"SI\"),0,21.43)","v":0},"C/C 1016 intestato Agenzia delle entrate- centro operativo di Pescara- tasse scolastiche",{"$f":"IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R10,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R11,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R12,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R13,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R14,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R15,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R16,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R17,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R18,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R19,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R20,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R21,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),R22,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1000*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2150*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2350*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0)))))))))))))))))))))))))))))))))))))))","v":false},{"$f":"IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1000*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2150*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2350*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75)))))))))))))","v":false},{"$f":"IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0)))))))))))))","v":false}]
[null,"Totale Contributo accademico",false,false]
[null,null,{"$f":"IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),SUM(F27:I27),IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),SUM(J27:P27),IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),SUM(F27:I27)*0.75,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),SUM(J27:P27)*0.75,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D21=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),K28,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D21=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),K28*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),200,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),400,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),600,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),800,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1000,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1200,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1400,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1600,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1800,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2150,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2350,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2550,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2550,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1000*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1200*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1400*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1600*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1800*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2150*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2350*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D6=\"-\",OR(D21=\"NO\",D21=\"SI\"),OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,Q27))))))))))))))))))))))))))))))))))))))))))))))","v":0},{"$f":"IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),SUM(F27:I27)/2,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),SUM(J27:P27)/2,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),SUM(F27:I27)*0.75/2,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\"),$D20<100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),SUM(J27:P27)*0.75/2,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D21=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),K28/2,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D21=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),K28*0.75/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),200/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),400/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),600/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),800/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1000/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1200/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1400/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1600/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),1800/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2150/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2350/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2550/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\",D17=\"NO\"),2550/2,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),200/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),400/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),600/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),800/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1000/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1200/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1400/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1600/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),1800/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2150/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2350/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"SI\",D17=\"NO\"),2550/2*0.75,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6<=22000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=22001,D6<=24000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=24001,D6<=26000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=26001,D6<=28000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=28001,D6<=30000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=30001,D6<=40000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=40001,D6<=50000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=50001,D6<=60000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=60001,D6<=70000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=70001,D6<=80000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=80001,D6<=90000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=90001,D6<=100000,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=\"FC2\",D8=\"FC3\"),D6>=100001,D21=\"SI\",OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,IF(AND(OR(D8=1,D8=\"PT1\",D8=2,D8=\"PT2\",D8=3,D8=\"PT3\",D8=\"BIS1\",D8=\"BIS2\",D8=\"BIS3\",D8=\"FC1\",D8=\"FC2\",D8=\"FC3\"),D6=\"-\",OR(D21=\"NO\",D21=\"SI\"),OR(D13=\"SI\",D14=\"SI\",D15=\"SI\",D16=\"NO\",D17=\"SI\")),0,Q27/2))))))))))))))))))))))))))))))))))))))))))))))","v":0},"puoi versare il contributo in una unica soluzione oppure in più rate",{"$f":"IF($D20>22000,+($D20-22000)*0.014,0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>24000,+($D20-22000)*0.035-F27,0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>26000,+($D20-22000)*0.0525-F27-G27,0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>28000,+($D20-22000)*0.063-F27-G27-H27,0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>30000,+(0.0225*$D20-170),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>40000,+(0.052*$D20 -1350.3-J27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>50000,+(0.02*$D20+249.88-J27-K27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>60000,+(0.02*$D20+249.86-J27-K27-L27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>70000,+(0.025*$D20-100.2-J27-K27-L27-M27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>80000,+(0.025*$D20-100.23-J27-K27-L27-M27-N27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>90000,+(0.025*$D20-100.25-J27-K27-L27-M27-N27),0)","v":{"$error":"#VALUE!"}},{"$f":"IF($D20>=100000,(\"€ 2400\"),0)","v":"€ 2400"}]
[null,null,"Per i Full Time","Per i Part time",null,{"$f":"IF(AND(D6<=30000, D21=\"NO\"),O19,0)","v":0},{"$f":"IF(AND(D6>30000,D6<=50000, D21=\"NO\"),O20,0)","v":0},{"$f":"IF(AND(D6>50000,D6<=70000, D21=\"NO\"),O21,0)","v":0},{"$f":"IF(AND(D6>70000,D6<=90000, D21=\"NO\"),O22,0)","v":0},{"$f":"IF(AND(D6>90000, D21=\"NO\"),O23,0)","v":2700},{"$f":"SUM(F28:J28)","v":2700}]
[null,"I RATA                                      SCADENZA 25 LUGLIO PER ISCRIZIONE ANNI SUCCESIVI AL PRIMO, 5 OTTOBRE PER IMMATRICOLAZIONI",{"$f":"IF(C27<=500,C27/2,C27/3)","v":0},{"$f":"C29/2","v":0},"procedura Pago PA https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108","500,00"]
[null,"II RATA                                      SCADENZA 5 NOVEMBRE",{"$f":"IF(C27<=500,C27/2,C27/3)","v":0},{"$f":"C30/2","v":0},"procedura Pago PA https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]
[null,"III RATA                                                              SCADENZA 5 DICEMBRE",{"$f":"IF(C27<=500,0,C27/3)","v":0},{"$f":"C31/2","v":0},"procedura Pago PA https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]

{"sheet":"STRANIERI","index":2,"n_rows":28,"n_cols":17,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,4,10,11],[12,1,12,2],[22,1,22,2],[13,1,13,2],[13,4,13,11],[14,1,14,2],[14,4,14,11],[21,1,21,2],[20,1,20,2],[15,1,15,2],[6,4,6,11],[0,1,1,11],[16,1,16,10],[18,1,18,2],[19,1,19,2],[9,4,9,11],[11,4,11,11],[12,4,12,11],[2,1,3,11],[4,1,4,8],[5,1,5,2],[6,1,6,2],[7,1,8,2],[9,1,9,2],[11,1,11,2],[15,4,15,11]]}
[null,"CONSERVATORIO DI FROSINONE - SIMULATORE CALCOLO CONTRIBUTO E TASSE CORSI ACCADEMICI DI I E II LIVELLO STUDENTI STRANIERI"]
[]
[null,"Attraverso il Simulatore tasse puoi ottenere una stima dell’importo che dovrai pagare in base alla tua situazione."]
[]
[null,"Per visualizzare gli importi simulati, devi inserire tutti i campi nella parte grigia (I CAMPI SONO TUTTI OBBLIGATORI)"]
[null,"Corso"]
[null,"Anno di Corso ",null,null,"vedi la legenda corsi"]
[null,"Tiplogia di frequenza "]
[]
[null,"Numero crediti acquisiti dal 10 AGOSTO 2022 al 10 AGOSTO 2023",null,{"$f":"IF(OR($D$7=1, $D$7=\"PT1\"),0,\"INSERISCI IL NUMERO CREDITI NELLA CASELLA SOTTO\")","v":"INSERISCI IL NUMERO CREDITI NELLA CASELLA SOTTO"},"puoi visualizzare il numero di crediti richiesti, nella tua pagina di isidata in \"controllo crediti\" inserendo nel filtro in alto le date qui indicate e visualizzando il risultato in \"crediti acquisiti\""]
[null,null,null,null,"Se stai iscrivendo agli anni successivi al primo e hai zero crediti non inserire nulla"]
[null,"sei uno studente con invalidità superiore o uguale al 66%?",null,null,"rispondi SI o NO"]
[null,"sei idoneo o vincitore della borsa di studio Laziodisco?",null,null,"rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,1400]
[null,"hai genitori beneficiari di pensione di inabilità?",null,null,"rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,1600,6.04]
[null,"hai familiari portatori di handicap con invalidità superiore o uguale all'80%?",null,null,"rispondi SI o NO",null,null,null,null,null,null,null,null,null,null,2300]
[null,"ti stai iscrivendo al primo anni di Arpa o Fagotto?",null,null,"rispondi SI o NO"]
[null,"Stima delle tasse accademiche  in base ai dati inseriti"]
[null,null,null,null,"Modalità di pagamento"]
[null,"il requisito crediti è soddisfatto?",null,{"$f":"IF(OR(AND($D$7=1,$D$11=0),AND($D$7=2,$D$11>=10),AND($D$7=3,$D$11>=25),AND($D$7=\"FC1\",$D$11>=25),AND($D$7=\"FC2\",$D$11>=25),AND($D$7=\"FC3\",$D$11>=25), AND($D$7=\"PT1\", $D$11=0), AND($D$7=\"PT2\",$D$11>=5),AND($D$7=\"PT3\",$D$11>=13),AND($D$7=\"BIS2\",$D$11>=13), AND($D$7=\"BIS3\",$D$11>=25),AND($D$7=\"BIS1\",$D$11>=5), AND($D$7=\"2daBIS1\",$D$11>=5),AND($D$7=\"3daBIS2\",$D$11>=13)),\"SI\",\"NO\")","v":"NO"}]
[null,"Marca da Bollo",null,16,"https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]
[null,"Tassa regionale laziodisco",null,{"$f":"IF(D12=\"SI\",0,140)","v":140},"http://www.laziodisco.it/pagopa/"]
[null,"Tassa di immatricolazione",null,{"$f":"IF(OR($D$12=\"SI\",$D$14=\"SI\",D7=2,D7=3,D7=\"FC1\",D7=\"FC2\",D7=\"FC3\",D7=\"PT2\",D7=\"PT3\",D7=\"BIS1\",D7=\"BIS2\",D7=\"BIS3\",D7=\"2daBIS1\",D7=\"3daBIS2\"),0,6.04)","v":6.04},"C/C 1016 intestato Agenzia delle entrate- centro operativo di Pescara- tasse scolastiche"]
[null,"Tassa di Frequenza",null,{"$f":"IF(OR($D$12=\"SI\",$D$14=\"SI\"),0,21.43)","v":21.43},"C/C 1016 intestato Agenzia delle entrate- centro operativo di Pescara- tasse scolastiche"]
[null,"Totale Contributo accademico",{"$f":"$I$25","v":0},{"$f":"$I$25/2","v":0},"puoi versare il contributo in una unica soluzione oppure in più rate"]
[null,null,"Per i Full Time","Per i Part time",null,{"$f":"IF(OR(AND(D7=1,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=2,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=3,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"FC1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"PT1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"PT2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"PT3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"BIS1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"BIS2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"BIS3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"2daBIS1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"3daBIS2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\")),P13,IF(OR(AND(D7=1,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=2,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=3,D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"FC1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"PT1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"PT2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"PT3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"BIS1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"BIS2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"BIS3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"2daBIS1\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"3daBIS2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\")),P13-(P13*25/100),0))","v":0},{"$f":"IF(OR(AND(D7=\"FC2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\"),AND(D7=\"FC3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\",D16=\"NO\")),P14,IF(OR(AND(D7=\"FC2\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\"),AND(D7=\"FC3\",D19=\"SI\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\")),P14-(P14*25/100),0))","v":0},{"$f":"IF(AND(D19=\"NO\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"NO\", D16=\"NO\"),P15,IF(OR(AND(D19=\"NO\",D12=\"NO\",D13=\"NO\",D14=\"NO\",D15=\"SI\",D16=\"NO\")),P15-(P15*25/100),0))","v":0},{"$f":"SUM(F25:H25)","v":0}]
[null,"I RATA                                      SCADENZA 25 LUGLIO PER ISCRIZIONE ANNI SUCCESIVI AL PRIMO, 5 OTTOBRE PER IMMATRICOLAZIONI",{"$f":"IF($C$24<=500,$C$24/2, $C$24/3)","v":0},{"$f":"$C$26/2","v":0},"https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]
[null,"II RATA                                      SCADENZA 5 NOVEMBRE",{"$f":"IF($C$24<=500,$C$24/2,$C$24/3)","v":0},{"$f":"$C$27/2","v":0},"https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]
[null,"III RATA                                                              SCADENZA 5 DICEMBRE",{"$f":"IF($C$24<=500,0,$C$24/3)","v":0},{"$f":"$C$28/2","v":0},"https://secure.pmpay.it/pmPortal/PM108/home/direct?codCompany=PM108"]

{"sheet":"CALCOLI","index":3,"n_rows":29,"n_cols":10,"rows_kept":29,"cut":false,"hidden":true,"merged":[[7,8,7,9]]}
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"TRIENNIO","BIENNIO","TRIENNIO","CREDITI FORMATIVI",null,"PER IL PART TIME CFA"]
[null,null,null,1,1,1,0,null,"1 PT",0]
[null,null,null,2,2,2,">= 10",null,"1 BIS",10]
[null,null,null,3,"PT1",3,">=25",null,"2 PT",25]
[null,null,null,"PT1","BIS1","4 (1FC)","crediti non sufficienti",null,"2 BIS",25]
[null,null,null,"BIS1","2daBIS1","5 (2 FC)",">=25",null,"3 PT",25]
[null,null,null,"2daBIS1","PT2","6 (3 FC)",">=25",null,"3 BIS",25]
[null,null,null,"PT2","BIS2","1 PT",0,null,4,25]
[null,null,null,"BIS2","FC1","1 BIS","crediti non sufficienti",null,5,25]
[null,null,null,"3daBIS2","FC2","2 PT",null,null,6,25]
[null,null,null,"PT3",null,"2 BIS"]
[null,null,null,"BIS3",null,"3 PT "]
[null,null,null,"FC1",null,"3 BIS"]
[null,null,null,"FC2"]
[null,null,null,"FC3"]
[]
[]
[]
[]
[null,null,null,null,"Elenco corsi","Tipo di frequenza"]
[null,null,null,null,"TRIENNIO","Full time"]
[null,null,null,null,"BIENNIO","Part time"]

{"sheet":"Foglio1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}