{"text_format":"3","workbook":"xlsb","n_sheets":4,"sheets":["Macros","Model Diagnostic Tool","User's guide","MapSummary"],"not_rendered":{"images":1,"macros":1,"external_links":1,"defined_names":17},"read":"whole","date_system":"1900","formulas":"cached_only","passed_over":{"ids":[37,38,1024],"n":636}}

{"sheet":"Macros","index":0,"n_rows":36,"n_cols":4,"rows_kept":36,"flags":["formulas_cached_only"]}
[]
[]
[null,null,"ATTENTION ! MACROS DESACTIVEES !"]
[]
[{"$nulls":3},"Ce fichier a été ouvert sans l'activation des macros nécessaires à son bon fonctionnement."]
[{"$nulls":3},"Si à l'ouverture de ce fichier aucun message ne vous a invités à choisir entre l'activation ou non des macros,"]
[{"$nulls":3},"le niveau de sécurité doit être ajusté à 'Moyen'. Pour cela, aller dans le menu 'Outils' puis sélectionner 'Macros'"]
[{"$nulls":3},"et cliquer sur 'Sécurité…'. Dans la fenêtre qui apparaît, cliquer sur le niveau de sécurité 'Moyen' puis fermer ce "]
[{"$nulls":3},"fichier avant de l'ouvrir de nouveau (en acceptant les macros)."]
[]
[null,null,"Résumé de la procédure :"]
[null,null,{"v":0,"d":"0."},"Si vous avez cliqué sur 'Désactiver les macros' à l'ouverture du classeur, ouvrir de nouveau le "]
[{"$nulls":3},"classeur en les acceptant. Sinon :"]
[null,null,{"v":1,"d":"1."},"Aller dans Outils\\Macros\\Sécurité"]
[null,null,{"v":2,"d":"2."},"Passer l'option de sécurité à 'Moyen'"]
[null,null,{"v":3,"d":"3."},"Fermer Excel sans enregistrer ce classeur "]
[null,null,{"v":4,"d":"4."},"Ouvrir le classeur en acceptant les macros, cette feuille disparaît alors."]
[]
[]
[]
[null,null,"BEWARE! MACROS ARE NOT ACTIVATED!"]
[]
[{"$nulls":3},"This file has been opened with disabled macros which are necessary to the model."]
[{"$nulls":3},"When opening this file, if no message box appears to select whether you want to enable or not the macros, the"]
[{"$nulls":3},"security level of Excel has to be adjusted to 'Medium'. To enable the macros, select the 'Tools' menu option "]
[{"$nulls":3},"and then select 'Macro' and 'Security…'. In the resulting 'Security' dialog box, set the security level to Medium "]
[{"$nulls":3},"by clicking the 'Medium' radio button. Close the file. Open it again and click the 'Enable' button when prompted"]
[{"$nulls":3},"to allow for the unsigned macro to run."]
[]
[null,null,"Summary of the procedure:"]
[null,null,{"v":0,"d":"0."},"If you selected Disable when prompted by the macro warning dialog when opening the file, open it again and select "]
[{"$nulls":3},"Enable' when prompted to allow the use of the macros. Otherwise:"]
[null,null,{"v":1,"d":"1."},"Go to the Tools\\Macros\\Security… menu"]
[null,null,{"v":2,"d":"2."},"In the 'Security' dialog box, click on 'Medium' and then on 'OK'"]
[null,null,{"v":3,"d":"3."},"Close Excel without saving this file"]
[null,null,{"v":4,"d":"4."},"Open the file again enabling the macros. This worksheet will not be visible anymore."]

{"sheet":"Model Diagnostic Tool","index":1,"n_rows":43,"n_cols":10,"rows_kept":43,"hidden":true,"merged":[[36,1,36,9],[42,1,42,9]],"flags":["formulas_cached_only"]}
[]
[]
[]
[]
[]
[]
[null,"Modelling & Project Finance"]
[null,"Model Diagnostic Tool"]
{"$rows_empty":18}
[null,"Vincent Fallas",{"$nulls":4},"Antoine Gaffuri"]
[null,"Partner - Modelling and Project Finance",{"$nulls":4},"Director - Modelling and Project Finance"]
[null,"vfallas@deloitte.fr",{"$nulls":4},"agaffuri@deloitte.fr"]
[]
[]
[{"$nulls":9},"Version : 0.5"]
[]
[]
[null,"IMPORTANT NOTICE"]
[]
[null,"This tool (the 'Tool’) has been prepared by Deloitte Finance (\"Deloitte\") and is the property of Deloitte. The Tool is distributed as a freeware.\nDeloitte expressly disclaims any responsibility to the potential user. Neither Deloitte nor Deloitte Touche Tohmatsu or all other member firms of the Deloitte Touche Tohmatsu organisation and their affiliates, their partners, principals, members, owners, directors, staff and agents and in all cases any predecessor, successor or assignee shall be liable for losses, damages, costs or expenses arising from or in any way connected with your use of the Tool."]
[]
[]
[]
[null,"AVERTISSEMENT"]
[]
[null,"Cet outil (l' 'Outil') a été préparé par Deloitte Finance et est donc la propriété de Deloitte Finance. Cependant, l'usage de l'Outil est autorisé de manière gratuite et illimitée pour votre usage personnel et sous votre responsabilité.\nNi Deloitte, ni Deloitte Touche Tohmatsu ou tout autre cabinet membre de l'organisation Deloitte Touche Tohmatsu, ne pourront être tenus responsables de l'usage qu'il pourrait être fait de l'Outil."]

{"sheet":"User's guide","index":2,"n_rows":91,"n_cols":16,"rows_kept":91,"hidden":true,"flags":["formulas_cached_only"]}
[]
[{"$nulls":8},"USER'S GUIDE"]
[]
[null,"Purpose of the Model Diagnostic Tool"]
[]
[null,null,"What does the Model Diagnostic Tool do ?"]
[{"$nulls":3},"The Model Diagnostic Tool creates a map of the file (the \"Model to be mapped\") to check the consistency of formulae."]
[{"$nulls":3},"It highlights inconsistencies to the user."]
[]
[null,null,"What does the Model Diagnostic Tool NOT do ?"]
[{"$nulls":3},"The Model Diagnostic Tool does not check reasonableness and completeness of formulae included in the file."]
[]
[]
[null,"Quick guide: How to use the Model Diagnostic Tool?"]
[]
[null,null,"Creating the Map"]
[]
[null,null,1,"Open the Model to be mapped (if you made any modifications, save it but keep it open)"]
[null,null,2,"Make sure that sheets to be mapped are not protected. The Tool will only run through unprotected sheets."]
[null,null,3,"Click on the \"Launch Model Diagnostic\" button. Click on \"Yes\" and select the Model to be mapped."]
[]
[null,null,"Map overview"]
[]
[null,null,"•","A new file, the Map, will be created and opened, named as follows: \"Map of\" + name of the Model to be mapped."]
[null,null,"•","The first sheet, called \"MapSummary\", gives an overview of the Model to be mapped."]
[null,null,"•","MapSummary includes the number of unique formulae, i.e. formulae that are not copied from cells above or on the left."]
[null,null,"•","Other sheets of the Map will be the same as in the Model to be mapped."]
[null,null,"•","For each cell in the sheets to be mapped, the Map will include a symbol and a colored background (see example thereafter)."]
[]
[null,null,"Reading the Map"]
[]
[null,null,"=","This cell is unique (i.e. it was not copied from cells above or on the left)."]
[null,null,">","This formula is a copy of the cell on the left."]
[null,null,"v","This formula is a copy of the cell above."]
[null,null,"+","This formula is a copy of the cell above and on the left (which means, it is consistent with the cells nearby)."]
[null,null,"@","This cell is made of text."]
[null,null,"#","This cell is made of a hard number."]
[]
[null,null,"Navigating through the Map"]
[]
[null,null,"•","Move the mouse over a cell to see the content of the corresponding cell in the Model to be mapped (as a comment)."]
[null,null,"•","Double-click on a cell to go to the corresponding cell in the Model to be mapped."]
[]
[]
[null,"Example"]
[]
[null,null,"Spreadsheet extract of the Model to be mapped"]
[]
[]
[{"$nulls":5},"A","B ","C","D","E","F","I","J","K","L","M"]
[{"$nulls":4},1,"Inputs"]
[{"$nulls":4},2,"Sales - Year 1",100]
[{"$nulls":4},3,"Yearly increase in sales",{"v":0.1,"d":"10%"}]
[{"$nulls":4},4,"COGS as % of sales",{"v":0.5,"d":"50%"}]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7,"Calculations"]
[{"$nulls":4},8,"Date",null,2017,2018,2019,2020,2021,2022,2023,2024,2025]
[{"$nulls":4},9,"Year",null,1,2,3,4,5,6,7,8,9]
[{"$nulls":4},10]
[{"$nulls":4},11,"Revenues",null,100,{"v":110.00000000000001,"d":"110"},{"v":121.00000000000001,"d":"121"},{"v":133.10000000000005,"d":"133"},{"v":146.41000000000005,"d":"146"},{"v":161.05100000000004,"d":"161"},{"v":177.1561000000001,"d":"177"},{"v":194.87171000000012,"d":"195"},{"v":214.3588810000001,"d":"214"}]
[{"$nulls":4},12,"COGS",null,50,{"v":55.00000000000001,"d":"55"},{"v":60.50000000000001,"d":"61"},{"v":66.55000000000003,"d":"67"},{"v":73.20500000000003,"d":"73"},{"v":80.52550000000002,"d":"81"},{"v":88.57805000000005,"d":"89"},{"v":97.43585500000006,"d":"97"},{"v":107.17944050000006,"d":"107"}]
[{"$nulls":4},13,"EBITDA",null,150,{"v":165.00000000000003,"d":"165"},{"v":181.50000000000003,"d":"182"},{"v":199.6500000000001,"d":"200"},{"v":219.61500000000007,"d":"220"},{"v":241.57650000000007,"d":"242"},{"v":265.7341500000001,"d":"266"},{"v":292.3075650000002,"d":"292"},{"v":321.53832150000017,"d":"322"}]
[]
[]
[null,null,"Corresponding Map"]
[]
[]
[{"$nulls":5},"A","B ","C","D","E","F","I","J","K","L","M"]
[{"$nulls":4},1,"@"]
[{"$nulls":4},2,"@","#"]
[{"$nulls":4},3,"@","#"]
[{"$nulls":4},4,"@","#"]
[{"$nulls":4},5]
[{"$nulls":4},6]
[{"$nulls":4},7,"@"]
[{"$nulls":4},8,"@",null,"#","#","#","#","#","#","#","#","#"]
[{"$nulls":4},9,"@",null,"#","#","#","#","#","#","#","#","#"]
[{"$nulls":4},10]
[{"$nulls":4},11,"@",null,"=",">",">",">",">",">",">",">",">"]
[{"$nulls":4},12,"@",null,"=",">",">","#","=",">",">",">",">"]
[{"$nulls":4},13,"@",null,"=",">",">",">",">",">",">",">",">"]
[]
[]
[{"$nulls":3},"Interpretation :"]
[{"$nulls":3},"•","Row titles, in column A, appear as text (in green) on the Map."]
[{"$nulls":3},"•","Input cells, in column B and in rows 8-9, appear as hard numbers (in red) on the Map."]
[{"$nulls":3},"•","Cells C11, C12 and C13 appear as unique cells (in yellow) on the Map : they are the first formulae of their rows."]
[{"$nulls":3},"•","Cells D11 to M13 appear as cells that were copied and pasted from the left."]
[{"$nulls":3},"•","However, within this range, cell F12 appears to be a hard number (which is not easily noticeable in the spreadsheet extract above)."]
[{"$nulls":3},"➤"," This seems inconsistent with the rest of the cells. There is a potential error that deserves to be checked."]

{"sheet":"MapSummary","index":3,"n_rows":16,"n_cols":8,"rows_kept":16,"hidden":true,"flags":["formulas_cached_only"]}
[]
[null,"Vincent Fallas",{"$nulls":3},"Antoine Gaffuri"]
[null,"Partner - Modelling and Project Finance",{"$nulls":3},"Director - Modelling and Project Finance"]
[null,"vfallas@deloitte.fr",{"$nulls":3},"agaffuri@deloitte.fr"]
[]
["Mapping of: 'tbd.xls?'"]
["Located in: 'C:\\tbd'"]
["Deloitte Mapping Tool ran on 5 January 2017 at 15:21:28"]
["Tool version: 'Deloitte - Model Diagnostic Tool.xlsb'"]
[]
["Worksheets","=",">","v","+","Total","@","#"]
[]
[]
["Total",0,0,0,0,0,0,0]
[]
["As a % of total formulae",0,0,0,0,0]