{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Istruzioni","Input","Scenari","Dashboard","Piano mensile"],"not_rendered":{"comments":1},"read":"whole","date_system":"1900"}

{"sheet":"Istruzioni","index":0,"n_rows":24,"n_cols":2,"rows_kept":24,"merged":[[0,0,0,7],[10,0,10,4],[18,0,18,4]]}
["Simulatore Vendita Cantiere Freesbe"]
[]
["Come usare questo file"]
["1. Compila solo le celle blu nel foglio Input."]
["2. Inserisci le metriche reali del funnel: lead → appuntamento, appuntamento → proposta, proposta → vendita."]
["3. Compila capacità team, quota lead organici/referral e buffer strategici."]
["4. Il foglio Scenari confronta tre ipotesi: Prudente, Realistico, Aggressivo."]
["5. Il foglio Dashboard evidenzia sostenibilità, gap budget, capacità e collo di bottiglia."]
["6. Il foglio Piano mensile traduce lo scenario in target operativi per mese."]
[]
["Logica del modello"]
["• Lead necessari con buffer = Lead necessari × (1 + buffer lead)"]
["• Lead paid necessari = Lead necessari con buffer × (1 - quota lead organici/referral)"]
["• Budget totale con buffer = Lead paid necessari × CPL × (1 + buffer budget)"]
["• Mesi stimati = Unità da vendere / vendite mensili sostenibili con il budget attuale"]
["• Il modello segnala gap di capacità commerciale e la priorità operativa principale"]
[]
[]
["Legenda colori"]
["Blu","input modificabili"]
["Nero","formule e calcoli"]
["Grigio","etichette e note statiche"]
["Teal","KPI principali"]
["Arancione / Rosso chiaro","attenzione, gap o priorità operative"]

{"sheet":"Input","index":1,"n_rows":30,"n_cols":4,"rows_kept":30,"merged":[[0,0,0,4],[3,0,3,2],[12,0,12,2],[18,0,18,3],[24,0,24,3]]}
["Input del progetto"]
["Compila solo le celle blu"]
[]
["Anagrafica progetto"]
["Nome progetto","Residenze Aurora"]
["Area / città","Milano"]
["Tipologia progetto","Nuova costruzione"]
["Unità da vendere",24]
["Prezzo medio per unità (€)",420000]
["Obiettivo di sell-out (mesi)",12]
["Budget marketing mensile disponibile (€)",6500]
[]
["Assunzioni funnel commerciale"]
["Lead → appuntamento",{"v":0.12,"d":"12.0%"}]
["Appuntamento → proposta",{"v":0.35,"d":"35.0%"}]
["Proposta → vendita",{"v":0.28,"d":"28.0%"}]
["CPL medio (€)",38]
[]
["Moltiplicatori scenario"]
["Scenario","Fattore conversioni","Fattore CPL","Nota"]
["Prudente",{"v":0.85,"d":"85.0%"},{"v":1.15,"d":"115.0%"},"più attrito nel funnel, CPL più alto"]
["Realistico",{"v":1,"d":"100.0%"},{"v":1,"d":"100.0%"},"baseline del progetto"]
["Aggressivo",{"v":1.15,"d":"115.0%"},{"v":0.9,"d":"90.0%"},"funnel più efficiente, CPL più basso"]
[]
["Capacità commerciale e margini"]
["Max appuntamenti gestibili / mese",18,null,"capacità reale del team commerciale"]
["Max proposte gestibili / mese",6,null,"quante proposte il team riesce a gestire in media"]
["Quota lead organici / referral",{"v":0.15,"d":"15.0%"},null,"quota dei lead coperta da canali non paid"]
["Buffer lead strategico",{"v":0.1,"d":"10.0%"},null,"margine di sicurezza sui lead necessari"]
["Buffer budget strategico",{"v":0.1,"d":"10.0%"},null,"margine di sicurezza sul budget"]

{"sheet":"Scenari","index":2,"n_rows":58,"n_cols":4,"rows_kept":58,"merged":[[0,0,0,3],[34,0,34,3]]}
["Confronto scenari"]
["Il foglio confronta il progetto in tre letture diverse"]
[null,"Prudente","Realistico","Aggressivo"]
["Fattore conversioni",{"$f":"Input!$B$21","v":{"v":0.85,"d":"85.0%"}},{"$f":"Input!$B$22","v":{"v":1,"d":"100.0%"}},{"$f":"Input!$B$23","v":{"v":1.15,"d":"115.0%"}}]
["Fattore CPL",{"$f":"Input!$C$21","v":{"v":1.15,"d":"115.0%"}},{"$f":"Input!$C$22","v":{"v":1,"d":"100.0%"}},{"$f":"Input!$C$23","v":{"v":0.9,"d":"90.0%"}}]
[]
["Lead → appuntamento effettivo",{"$f":"Input!$B$14*B4","v":{"v":0.102,"d":"10.2%"}},{"$f":"Input!$B$14*C4","v":{"v":0.12,"d":"12.0%"}},{"$f":"Input!$B$14*D4","v":{"v":0.13799999999999998,"d":"13.8%"}}]
["Appuntamento → proposta effettivo",{"$f":"Input!$B$15*B4","v":{"v":0.2975,"d":"29.8%"}},{"$f":"Input!$B$15*C4","v":{"v":0.35,"d":"35.0%"}},{"$f":"Input!$B$15*D4","v":{"v":0.40249999999999997,"d":"40.3%"}}]
["Proposta → vendita effettivo",{"$f":"Input!$B$16*B4","v":{"v":0.23800000000000002,"d":"23.8%"}},{"$f":"Input!$B$16*C4","v":{"v":0.28,"d":"28.0%"}},{"$f":"Input!$B$16*D4","v":{"v":0.322,"d":"32.2%"}}]
["Conversione complessiva",{"$f":"B7*B8*B9","v":{"v":0.0072221099999999995,"d":"0.72%"}},{"$f":"C7*C8*C9","v":{"v":0.01176,"d":"1.18%"}},{"$f":"D7*D8*D9","v":{"v":0.017885489999999997,"d":"1.79%"}}]
["CPL effettivo (€)",{"$f":"Input!$B$17*B5","v":43.699999999999996},{"$f":"Input!$B$17*C5","v":38},{"$f":"Input!$B$17*D5","v":34.2}]
[]
["Unità da vendere",{"$f":"Input!$B$8","v":24},{"$f":"Input!$B$8","v":24},{"$f":"Input!$B$8","v":24}]
["Prezzo medio per unità (€)",{"$f":"Input!$B$9","v":420000},{"$f":"Input!$B$9","v":420000},{"$f":"Input!$B$9","v":420000}]
["Obiettivo di sell-out (mesi)",{"$f":"Input!$B$10","v":12},{"$f":"Input!$B$10","v":12},{"$f":"Input!$B$10","v":12}]
["Budget mensile disponibile (€)",{"$f":"Input!$B$11","v":6500},{"$f":"Input!$B$11","v":6500},{"$f":"Input!$B$11","v":6500}]
[]
["Lead necessari",{"$f":"IFERROR(B13/B10,\"\")","v":{"v":3323.128559382231,"d":"3323"}},{"$f":"IFERROR(C13/C10,\"\")","v":{"v":2040.8163265306123,"d":"2041"}},{"$f":"IFERROR(D13/D10,\"\")","v":{"v":1341.8698621060985,"d":"1342"}}]
["Appuntamenti necessari",{"$f":"IFERROR(B13/(B8*B9),\"\")","v":{"v":338.95911305698746,"d":"339"}},{"$f":"IFERROR(C13/(C8*C9),\"\")","v":{"v":244.89795918367346,"d":"245"}},{"$f":"IFERROR(D13/(D8*D9),\"\")","v":{"v":185.17804097064158,"d":"185"}}]
["Proposte necessarie",{"$f":"IFERROR(B13/B9,\"\")","v":{"v":100.84033613445378,"d":"101"}},{"$f":"IFERROR(C13/C9,\"\")","v":{"v":85.71428571428571,"d":"86"}},{"$f":"IFERROR(D13/D9,\"\")","v":{"v":74.53416149068323,"d":"75"}}]
["Ricavo potenziale (€)",{"$f":"B13*B14","v":10080000},{"$f":"C13*C14","v":10080000},{"$f":"D13*D14","v":10080000}]
[]
["Budget marketing totale richiesto (€)",{"$f":"B18*B11","v":145220.71804500348},{"$f":"C18*C11","v":77551.02040816327},{"$f":"D18*D11","v":45891.949284028575}]
["Costo marketing per unità venduta (€)",{"$f":"IFERROR(B23/B13,\"\")","v":6050.863251875145},{"$f":"IFERROR(C23/C13,\"\")","v":3231.292517006803},{"$f":"IFERROR(D23/D13,\"\")","v":1912.1645535011905}]
["Lead target per mese",{"$f":"IFERROR(B18/B15,\"\")","v":{"v":276.9273799485192,"d":"277"}},{"$f":"IFERROR(C18/C15,\"\")","v":{"v":170.06802721088437,"d":"170"}},{"$f":"IFERROR(D18/D15,\"\")","v":{"v":111.82248850884154,"d":"112"}}]
["Budget richiesto per mese (€)",{"$f":"IFERROR(B23/B15,\"\")","v":12101.72650375029},{"$f":"IFERROR(C23/C15,\"\")","v":6462.585034013606},{"$f":"IFERROR(D23/D15,\"\")","v":3824.329107002381}]
[]
["Lead/mese con budget attuale",{"$f":"IFERROR(B16/B11,\"\")","v":{"v":148.74141876430207,"d":"149"}},{"$f":"IFERROR(C16/C11,\"\")","v":{"v":171.05263157894737,"d":"171"}},{"$f":"IFERROR(D16/D11,\"\")","v":{"v":190.05847953216372,"d":"190"}}]
["Vendite/mese con budget attuale",{"$f":"IFERROR(B28*B10,\"\")","v":{"v":1.0742268878718535,"d":"1.07"}},{"$f":"IFERROR(C28*C10,\"\")","v":{"v":2.011578947368421,"d":"2.01"}},{"$f":"IFERROR(D28*D10,\"\")","v":{"v":3.399289035087718,"d":"3.40"}}]
["Mesi stimati di assorbimento",{"$f":"IFERROR(B13/B29,\"\")","v":{"v":22.341648930000535,"d":"22.3"}},{"$f":"IFERROR(C13/C29,\"\")","v":{"v":11.930926216640502,"d":"11.9"}},{"$f":"IFERROR(D13/D29,\"\")","v":{"v":7.06029988985055,"d":"7.1"}}]
["Gap mesi vs obiettivo",{"$f":"IFERROR(B30-B15,\"\")","v":{"v":10.341648930000535,"d":"10.3"}},{"$f":"IFERROR(C30-C15,\"\")","v":{"v":-0.06907378335949765,"d":"-0.1"}},{"$f":"IFERROR(D30-D15,\"\")","v":{"v":-4.93970011014945,"d":"-4.9"}}]
["Gap budget mensile (€)",{"$f":"B26-B16","v":5601.726503750289},{"$f":"C26-C16","v":-37.414965986394236},{"$f":"D26-D16","v":-2675.670892997619}]
["Stato operativo",{"$f":"IF(B30=\"\", \"Verifica input\", IF(B30<=B15, \"In linea con l'obiettivo\", \"Budget o conversioni da rafforzare\"))","v":"Budget o conversioni da rafforzare"},{"$f":"IF(C30=\"\", \"Verifica input\", IF(C30<=C15, \"In linea con l'obiettivo\", \"Budget o conversioni da rafforzare\"))","v":"In linea con l'obiettivo"},{"$f":"IF(D30=\"\", \"Verifica input\", IF(D30<=D15, \"In linea con l'obiettivo\", \"Budget o conversioni da rafforzare\"))","v":"In linea con l'obiettivo"}]
[]
["Lettura evoluta: mix canali, capacità e buffer"]
["Quota lead organici / referral",{"$f":"Input!$B$28","v":{"v":0.15,"d":"15.0%"}},{"$f":"Input!$B$28","v":{"v":0.15,"d":"15.0%"}},{"$f":"Input!$B$28","v":{"v":0.15,"d":"15.0%"}}]
["Buffer lead",{"$f":"Input!$B$29","v":{"v":0.1,"d":"10.0%"}},{"$f":"Input!$B$29","v":{"v":0.1,"d":"10.0%"}},{"$f":"Input!$B$29","v":{"v":0.1,"d":"10.0%"}}]
["Buffer budget",{"$f":"Input!$B$30","v":{"v":0.1,"d":"10.0%"}},{"$f":"Input!$B$30","v":{"v":0.1,"d":"10.0%"}},{"$f":"Input!$B$30","v":{"v":0.1,"d":"10.0%"}}]
["Max appuntamenti / mese",{"$f":"Input!$B$26","v":18},{"$f":"Input!$B$26","v":18},{"$f":"Input!$B$26","v":18}]
["Max proposte / mese",{"$f":"Input!$B$27","v":6},{"$f":"Input!$B$27","v":6},{"$f":"Input!$B$27","v":6}]
[]
["Lead necessari con buffer",{"$f":"IFERROR(B18*(1+B37),\"\")","v":{"v":3655.4414153204543,"d":"3655.4"}},{"$f":"IFERROR(C18*(1+C37),\"\")","v":{"v":2244.8979591836737,"d":"2244.9"}},{"$f":"IFERROR(D18*(1+D37),\"\")","v":{"v":1476.0568483167085,"d":"1476.1"}}]
["Lead paid necessari",{"$f":"IFERROR(B42*(1-B36),\"\")","v":{"v":3107.125203022386,"d":"3107.1"}},{"$f":"IFERROR(C42*(1-C36),\"\")","v":{"v":1908.1632653061226,"d":"1908.2"}},{"$f":"IFERROR(D42*(1-D36),\"\")","v":{"v":1254.6483210692022,"d":"1254.6"}}]
["Appuntamenti target / mese",{"$f":"IFERROR(B19/B15,\"\")","v":{"v":28.246592754748956,"d":"28.2"}},{"$f":"IFERROR(C19/C15,\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IFERROR(D19/D15,\"\")","v":{"v":15.431503414220131,"d":"15.4"}}]
["Proposte target / mese",{"$f":"IFERROR(B20/B15,\"\")","v":{"v":8.403361344537815,"d":"8.4"}},{"$f":"IFERROR(C20/C15,\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IFERROR(D20/D15,\"\")","v":{"v":6.211180124223603,"d":"6.2"}}]
["Budget totale con buffer (€)",{"$f":"IFERROR(B43*B11*(1+B38),\"\")","v":149359.5085092861},{"$f":"IFERROR(C43*C11*(1+C38),\"\")","v":79761.22448979593},{"$f":"IFERROR(D43*D11*(1+D38),\"\")","v":47199.869838623395}]
["Budget richiesto / mese con buffer (€)",{"$f":"IFERROR(B46/B15,\"\")","v":12446.625709107175},{"$f":"IFERROR(C46/C15,\"\")","v":6646.768707482995},{"$f":"IFERROR(D46/D15,\"\")","v":3933.3224865519496}]
["Lead paid / mese",{"$f":"IFERROR(B43/B15,\"\")","v":{"v":258.9271002518655,"d":"258.9"}},{"$f":"IFERROR(C43/C15,\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IFERROR(D43/D15,\"\")","v":{"v":104.55402675576686,"d":"104.6"}}]
["Lead totali / mese sostenibili con budget attuale",{"$f":"IF(B36>=1,\"\",IFERROR((B16/B11)/(1-B36),\"\"))","v":{"v":174.98990442859068,"d":"175.0"}},{"$f":"IF(C36>=1,\"\",IFERROR((C16/C11)/(1-C36),\"\"))","v":{"v":201.23839009287926,"d":"201.2"}},{"$f":"IF(D36>=1,\"\",IFERROR((D16/D11)/(1-D36),\"\"))","v":{"v":223.59821121431025,"d":"223.6"}}]
["Vendite / mese sostenibili",{"$f":"IFERROR(B49*B10,\"\")","v":{"v":1.2637963386727689,"d":"1.3"}},{"$f":"IFERROR(C49*C10,\"\")","v":{"v":2.3665634674922598,"d":"2.4"}},{"$f":"IFERROR(D49*D10,\"\")","v":{"v":3.999163570691433,"d":"4.0"}}]
["Mesi stimati con mix canali e buffer",{"$f":"IFERROR(B13/B50,\"\")","v":{"v":18.990401590500454,"d":"19.0"}},{"$f":"IFERROR(C13/C50,\"\")","v":{"v":10.141287284144429,"d":"10.1"}},{"$f":"IFERROR(D13/D50,\"\")","v":{"v":6.001254906372968,"d":"6.0"}}]
["Gap budget / mese con buffer (€)",{"$f":"B47-B16","v":5946.625709107175},{"$f":"C47-C16","v":146.7687074829946},{"$f":"D47-D16","v":-2566.6775134480504}]
["Gap capacità appuntamenti / mese",{"$f":"B44-B39","v":{"v":10.246592754748956,"d":"10.2"}},{"$f":"C44-C39","v":{"v":2.408163265306122,"d":"2.4"}},{"$f":"D44-D39","v":{"v":-2.5684965857798687,"d":"-2.6"}}]
["Gap capacità proposte / mese",{"$f":"B45-B40","v":{"v":2.4033613445378155,"d":"2.4"}},{"$f":"C45-C40","v":{"v":1.1428571428571423,"d":"1.1"}},{"$f":"D45-D40","v":{"v":0.21118012422360266,"d":"0.2"}}]
["Incidenza marketing su ricavi",{"$f":"IFERROR(B46/B21,\"\")","v":{"v":0.014817411558460922,"d":"1.5%"}},{"$f":"IFERROR(C46/C21,\"\")","v":{"v":0.007912819889860707,"d":"0.8%"}},{"$f":"IFERROR(D46/D21,\"\")","v":{"v":0.004682526769704702,"d":"0.5%"}}]
["Collo di bottiglia funnel",{"$f":"IF(MIN(B7:B9)=B7,\"Lead → appuntamento\",IF(MIN(B7:B9)=B8,\"Appuntamento → proposta\",\"Proposta → vendita\"))","v":"Lead → appuntamento"},{"$f":"IF(MIN(C7:C9)=C7,\"Lead → appuntamento\",IF(MIN(C7:C9)=C8,\"Appuntamento → proposta\",\"Proposta → vendita\"))","v":"Lead → appuntamento"},{"$f":"IF(MIN(D7:D9)=D7,\"Lead → appuntamento\",IF(MIN(D7:D9)=D8,\"Appuntamento → proposta\",\"Proposta → vendita\"))","v":"Lead → appuntamento"}]
["Priorità operativa",{"$f":"IF(B53>0,\"Rafforza gestione appuntamenti\",IF(B54>0,\"Rafforza qualità proposte / closing\",IF(B52>0,\"Aumenta budget o riduci CPL\",\"Ottimizza il collo di bottiglia: \"&B56)))","v":"Rafforza gestione appuntamenti"},{"$f":"IF(C53>0,\"Rafforza gestione appuntamenti\",IF(C54>0,\"Rafforza qualità proposte / closing\",IF(C52>0,\"Aumenta budget o riduci CPL\",\"Ottimizza il collo di bottiglia: \"&C56)))","v":"Rafforza gestione appuntamenti"},{"$f":"IF(D53>0,\"Rafforza gestione appuntamenti\",IF(D54>0,\"Rafforza qualità proposte / closing\",IF(D52>0,\"Aumenta budget o riduci CPL\",\"Ottimizza il collo di bottiglia: \"&D56)))","v":"Rafforza qualità proposte / closing"}]
["Stato operativo evoluto",{"$f":"IF(OR(B51=\"\",B47=\"\"),\"Verifica input\",IF(AND(B51<=B15,B53<=0,B54<=0),\"In linea e sostenibile\",IF(OR(B53>0,B54>0),\"Target raggiungibile ma team da potenziare\",\"Budget o conversioni da rafforzare\")))","v":"Target raggiungibile ma team da potenziare"},{"$f":"IF(OR(C51=\"\",C47=\"\"),\"Verifica input\",IF(AND(C51<=C15,C53<=0,C54<=0),\"In linea e sostenibile\",IF(OR(C53>0,C54>0),\"Target raggiungibile ma team da potenziare\",\"Budget o conversioni da rafforzare\")))","v":"Target raggiungibile ma team da potenziare"},{"$f":"IF(OR(D51=\"\",D47=\"\"),\"Verifica input\",IF(AND(D51<=D15,D53<=0,D54<=0),\"In linea e sostenibile\",IF(OR(D53>0,D54>0),\"Target raggiungibile ma team da potenziare\",\"Budget o conversioni da rafforzare\")))","v":"Target raggiungibile ma team da potenziare"}]

{"sheet":"Dashboard","index":3,"n_rows":31,"n_cols":9,"rows_kept":31,"merged":[[0,0,0,8],[13,5,13,6],[14,5,14,6],[15,5,15,6],[30,1,32,8]]}
["Dashboard sintetica"]
[null,"Seleziona scenario","Realistico"]
[]
[null,"Progetto",{"$f":"Input!B5","v":"Residenze Aurora"},null,"Area",{"$f":"Input!B6","v":"Milano"},null,"Tipologia",{"$f":"Input!B7","v":"Nuova costruzione"}]
[]
[null,"Unità da vendere",null,null,"Lead necessari (buffer)",null,null,"Budget totale con buffer"]
[null,{"$f":"INDEX(Scenari!$B$13:$D$13,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":24},null,null,{"$f":"INDEX(Scenari!$B$42:$D$42,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":2244.8979591836737,"d":"2244.9"}},null,null,{"$f":"INDEX(Scenari!$B$46:$D$46,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":79761.22448979593}]
[]
[]
[null,"Appuntamenti / mese",null,null,"Proposte / mese",null,null,"Mesi stimati"]
[null,{"$f":"INDEX(Scenari!$B$44:$D$44,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":20.408163265306122,"d":"20.4"}},null,null,{"$f":"INDEX(Scenari!$B$45:$D$45,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":7.142857142857142,"d":"7.1"}},null,null,{"$f":"INDEX(Scenari!$B$51:$D$51,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":10.141287284144429,"d":"10.1"}}]
[]
[]
[null,"Budget mensile attuale",{"$f":"INDEX(Scenari!$B$16:$D$16,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":6500},null,"Stato operativo",{"$f":"INDEX(Scenari!$B$58:$D$58,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":"Target raggiungibile ma team da potenziare"},null,"Max appunt./mese",{"$f":"INDEX(Scenari!$B$39:$D$39,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":18}]
[null,"Gap budget / mese",{"$f":"INDEX(Scenari!$B$52:$D$52,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":146.7687074829946},null,"Collo di bottiglia",{"$f":"INDEX(Scenari!$B$56:$D$56,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":"Lead → appuntamento"},null,"Gap appunt./mese",{"$f":"INDEX(Scenari!$B$53:$D$53,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":2.408163265306122,"d":"2.4"}}]
[null,"Lead organici / referral",{"$f":"INDEX(Scenari!$B$36:$D$36,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":0.15,"d":"15.0%"}},null,"Priorità operativa",{"$f":"INDEX(Scenari!$B$57:$D$57,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":"Rafforza gestione appuntamenti"},null,"Max proposte/mese",{"$f":"INDEX(Scenari!$B$40:$D$40,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":6}]
[null,"Incidenza marketing",{"$f":"INDEX(Scenari!$B$55:$D$55,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":0.007912819889860707,"d":"0.8%"}},null,"Conv. complessiva",{"$f":"INDEX(Scenari!$B$10:$D$10,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":0.01176,"d":"1.18%"}},null,"Gap proposte/mese",{"$f":"INDEX(Scenari!$B$54:$D$54,1,MATCH($C$2,Scenari!$B$3:$D$3,0))","v":{"v":1.1428571428571423,"d":"1.1"}}]
[]
[]
[null,"Confronto scenari"]
[null,"Prudente","Realistico","Aggressivo"]
["Budget totale con buffer",{"$f":"Scenari!B46","v":149359.5085092861},{"$f":"Scenari!C46","v":79761.22448979593},{"$f":"Scenari!D46","v":47199.869838623395}]
["Mesi stimati",{"$f":"Scenari!B51","v":{"v":18.990401590500454,"d":"19.0"}},{"$f":"Scenari!C51","v":{"v":10.141287284144429,"d":"10.1"}},{"$f":"Scenari!D51","v":{"v":6.001254906372968,"d":"6.0"}}]
["Budget/mese richiesto",{"$f":"Scenari!B47","v":12446.625709107175},{"$f":"Scenari!C47","v":6646.768707482995},{"$f":"Scenari!D47","v":3933.3224865519496}]
["Gap budget/mese",{"$f":"Scenari!B52","v":5946.625709107175},{"$f":"Scenari!C52","v":146.7687074829946},{"$f":"Scenari!D52","v":-2566.6775134480504}]
["Gap appunt./mese",{"$f":"Scenari!B53","v":{"v":10.246592754748956,"d":"10.2"}},{"$f":"Scenari!C53","v":{"v":2.408163265306122,"d":"2.4"}},{"$f":"Scenari!D53","v":{"v":-2.5684965857798687,"d":"-2.6"}}]
["Gap proposte/mese",{"$f":"Scenari!B54","v":{"v":2.4033613445378155,"d":"2.4"}},{"$f":"Scenari!C54","v":{"v":1.1428571428571423,"d":"1.1"}},{"$f":"Scenari!D54","v":{"v":0.21118012422360266,"d":"0.2"}}]
[]
[]
[null,"Lettura strategica"]
[null,{"$f":"IF(F14=\"In linea e sostenibile\",\"Il progetto è coerente con obiettivo, budget e capacità commerciale. La priorità è mantenere tracciamento, qualità creativa e velocità di risposta.\",IF(F14=\"Target raggiungibile ma team da potenziare\",\"Il mercato può assorbire il progetto, ma il team rischia colli di bottiglia operativi. Serve rafforzare appuntamenti, proposte o closing.\",\"Il progetto richiede un intervento su budget, CPL o conversioni. La leva principale è: \"&F16&\".\"))","v":"Il mercato può assorbire il progetto, ma il team rischia colli di bottiglia operativi. Serve rafforzare appuntamenti, proposte o closing."}]

{"sheet":"Piano mensile","index":4,"n_rows":34,"n_cols":9,"rows_kept":34,"merged":[[0,0,0,8],[3,0,3,8],[32,7,32,8],[33,7,33,8]]}
["Piano mensile operativo"]
["Scenario attivo",{"$f":"Dashboard!C2","v":"Realistico"},null,"Progetto",{"$f":"Input!B5","v":"Residenze Aurora"}]
[]
["Distribuzione lineare di base: usa questo foglio per tradurre lo scenario in target operativi mensili e verificare subito budget e capacità."]
[]
["Mese","Vendite target","Vendite cumulative","Lead totali","Lead paid","Appuntamenti","Proposte","Budget richiesto","Verifica operativa"]
[1,{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B7=\"\",\"\",SUM($B$7:B7))","v":{"v":2,"d":"2.0"}},{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A7<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B7=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[2,{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B8=\"\",\"\",SUM($B$7:B8))","v":{"v":4,"d":"4.0"}},{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A8<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B8=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[3,{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B9=\"\",\"\",SUM($B$7:B9))","v":{"v":6,"d":"6.0"}},{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A9<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B9=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[4,{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B10=\"\",\"\",SUM($B$7:B10))","v":{"v":8,"d":"8.0"}},{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A10<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B10=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[5,{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B11=\"\",\"\",SUM($B$7:B11))","v":{"v":10,"d":"10.0"}},{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A11<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B11=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[6,{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B12=\"\",\"\",SUM($B$7:B12))","v":{"v":12,"d":"12.0"}},{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A12<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B12=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[7,{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B13=\"\",\"\",SUM($B$7:B13))","v":{"v":14,"d":"14.0"}},{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A13<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B13=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[8,{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B14=\"\",\"\",SUM($B$7:B14))","v":{"v":16,"d":"16.0"}},{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A14<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B14=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[9,{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B15=\"\",\"\",SUM($B$7:B15))","v":{"v":18,"d":"18.0"}},{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A15<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B15=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[10,{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B16=\"\",\"\",SUM($B$7:B16))","v":{"v":20,"d":"20.0"}},{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A16<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B16=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[11,{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B17=\"\",\"\",SUM($B$7:B17))","v":{"v":22,"d":"22.0"}},{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A17<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B17=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[12,{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":2,"d":"2.0"}},{"$f":"IF(B18=\"\",\"\",SUM($B$7:B18))","v":{"v":24,"d":"24.0"}},{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":187.0748299319728,"d":"187.1"}},{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":159.0136054421769,"d":"159.0"}},{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":20.408163265306122,"d":"20.4"}},{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":{"v":7.142857142857142,"d":"7.1"}},{"$f":"IF($A18<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":6646.768707482995},{"$f":"IF(B18=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":"Rafforzare appuntamenti"}]
[13,{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B19=\"\",\"\",SUM($B$7:B19))","v":null},{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A19<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B19=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[14,{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B20=\"\",\"\",SUM($B$7:B20))","v":null},{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A20<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B20=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[15,{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B21=\"\",\"\",SUM($B$7:B21))","v":null},{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A21<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B21=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[16,{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B22=\"\",\"\",SUM($B$7:B22))","v":null},{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A22<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B22=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[17,{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B23=\"\",\"\",SUM($B$7:B23))","v":null},{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A23<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B23=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[18,{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B24=\"\",\"\",SUM($B$7:B24))","v":null},{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A24<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B24=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[19,{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B25=\"\",\"\",SUM($B$7:B25))","v":null},{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A25<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B25=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[20,{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B26=\"\",\"\",SUM($B$7:B26))","v":null},{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A26<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B26=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[21,{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B27=\"\",\"\",SUM($B$7:B27))","v":null},{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A27<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B27=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[22,{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B28=\"\",\"\",SUM($B$7:B28))","v":null},{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A28<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B28=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[23,{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B29=\"\",\"\",SUM($B$7:B29))","v":null},{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A29<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B29=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[24,{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$13:$D$13,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B30=\"\",\"\",SUM($B$7:B30))","v":null},{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$42:$D$42,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$43:$D$43,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF($A30<=INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"\")","v":null},{"$f":"IF(B30=\"\",\"\",IF(INDEX(Scenari!$B$19:$D$19,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare appuntamenti\",IF(INDEX(Scenari!$B$20:$D$20,1,MATCH($B$2,Scenari!$B$3:$D$3,0))/INDEX(Scenari!$B$15:$D$15,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$40:$D$40,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare proposte\",IF(INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))>INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0)),\"Rafforzare budget / CPL\",\"In linea\"))))","v":null}]
[]
["Sintesi"]
["Budget mensile attuale",{"$f":"INDEX(Scenari!$B$16:$D$16,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":6500},null,"Budget richiesto/mese",{"$f":"INDEX(Scenari!$B$47:$D$47,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":6646.768707482995},null,"Stato",{"$f":"INDEX(Scenari!$B$58:$D$58,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":"Target raggiungibile ma team da potenziare"}]
["Max appunt./mese",{"$f":"INDEX(Scenari!$B$39:$D$39,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":18},null,"Appunt./mese richiesti",{"$f":"INDEX(Scenari!$B$44:$D$44,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":{"v":20.408163265306122,"d":"20.4"}},null,"Priorità",{"$f":"INDEX(Scenari!$B$57:$D$57,1,MATCH($B$2,Scenari!$B$3:$D$3,0))","v":"Rafforza gestione appuntamenti"}]