{"text_format":"3","workbook":"xlsx","n_sheets":4,"sheets":["Sommaire","Identification","Répartition","Justification"],"not_rendered":{"images":1,"defined_names":4},"read":"whole","date_system":"1900"}

{"sheet":"Sommaire","index":0,"n_rows":100,"n_cols":3,"rows_kept":100,"merged":[[2,0,2,2],[3,1,3,2],[4,1,4,2],[5,0,5,2],[6,0,7,0],[6,1,7,1],[18,0,18,2],[19,0,19,1],[20,0,20,1],[22,0,22,1],[24,0,24,1],[26,0,26,1],[28,0,28,1],[30,0,30,1]]}
[null,null,"BUDGET DE PARTICIPATION"]
[null,null,"Sommaire"]
[]
["Numéro de dossier :",{"$f":"Identification!B4","v":"R-4169-2021 Phase 2"}]
["Nom de l'intervenant :",{"$f":"Identification!B5","v":"Option consommateurs"}]
["HONORAIRES "]
["Type de ressources","Heures de préparation et d'audience","Honoraires"]
[null,null,"(incl. TPS/TVQ admissibles)"]
["Avocat",{"$f":"Répartition!B25+Répartition!C25+Répartition!D25","v":{"v":64,"d":"64.0 "}},{"$f":"Répartition!B30+Répartition!C30+Répartition!D30","v":{"v":19200,"d":"19,200.00 $"}}]
[]
["Analyste",{"$f":"Répartition!E25+Répartition!F25+Répartition!G25+Répartition!H25","v":{"v":89,"d":"89.0 "}},{"$f":"Répartition!E30+Répartition!F30+Répartition!G30+Répartition!H30","v":{"v":21360,"d":"21,360.00 $"}}]
[]
["Témoin expert",{"$f":"Répartition!I25+Répartition!J25","v":{"v":0,"d":"0.0 "}},{"$f":"Répartition!I30+Répartition!J30","v":0}]
[]
["Coordonnateur",{"$f":"Répartition!K25+Répartition!L25","v":{"v":0,"d":"0.0 "}},{"$f":"Répartition!K30+Répartition!L30","v":0}]
[]
["TOTAL / TEMPS ET HONORAIRES ",{"$f":"B9+B11+B13+B15","v":{"v":153,"d":"153.0 "}},{"$f":"C9+C11+C13+C15","v":{"v":40560,"d":"40,560.00 $"}}]
[]
["DÉPENSES"]
["Type de dépenses ",null,"Dépenses\n(incl. TPS/TVQ admissibles)"]
["Allocation forfaitaire (3% du total des honoraires)",null,{"$f":"ROUND(0.03*C17,2)","v":{"v":1216.8,"d":"1,216.80 $"}}]
[]
["Dépenses d'hébergement et de transport (si déplacement de plus de 100 km)",null,0]
[]
["Dépenses de traduction et de sténographie",null,0]
[]
["TOTAL DES DÉPENSES",null,{"$f":"C21+C23+C25","v":{"v":1216.8,"d":"1,216.80 $"}}]
[]
["SÉANCES DE TRAVAIL",null,0]
[]
["TOTAL DU BUDGET DE PARTICIPATION",null,{"$f":"C17+C27+C29","v":{"v":41776.8,"d":"41,776.80 $"}}]
{"$rows_empty":68}
["Signature",null,"Date"]

{"sheet":"Identification","index":1,"n_rows":27,"n_cols":5,"rows_kept":27,"merged":[[2,0,2,4],[3,1,3,4],[4,1,4,4],[5,0,5,2],[6,0,6,2],[7,0,7,2],[7,3,7,4],[8,0,8,4],[19,1,20,1],[19,2,20,2],[22,1,23,1],[25,0,25,4],[26,0,26,4]]}
[{"$nulls":4},"BUDGET DE PARTICIPATION"]
[{"$nulls":4},"Identification des personnes"]
["Les cases complétées à la présente page sont reportées automatiquement à la page répartition lorsque requis."]
["Numéro de dossier :","R-4169-2021 Phase 2"]
["Nom de l'intervenant :","Option consommateurs"]
["S'agit-il d'un regroupement? (oui/non)",null,null,"Non"]
["Taxes remboursées par le gouvernement? (0%, 50%, 100%)",null,null,{"v":0.5,"d":"50%"}]
["Membre responsable du paiement des factures :",null,null,"N/A"]
["IDENTIFICATION DES PERSONNES"]
["Nom des avocats","Expérience1","Interne/externe2","Taux horaire $","Adresse du lieu habituel de travail"]
["Éric David","15+","Externe",300,"485 rue McGill, bureau 500, Montréal (Québec), H2Y 2H4"]
[]
[]
["Nom des analystes","Expérience1","Interne/externe2","Taux horaire $","Adresse du lieu habituel de travail"]
["Roger Higgin","15+","Externe",240,"15, Malabar Place, Toronto (ON) M3B 1A4"]
[]
[]
[]
["Nom des témoins experts","Expérience1","Interne/externe2","Taux horaire $","Adresse du lieu habituel de travail"]
[null,"n/a","n/a"]
[]
["Nom des coordonnateurs","Expérience1","Interne/externe2","Taux horaire $","Adresse du lieu habituel de travail"]
[null,"n/a"]
[]
[]
["1   Correspond au nombre d'années d'exercice du droit ou de la profession complétées au début du dossier."]
["2   Une ressource est interne si elle est à l'emploi de l'intervenant."]

{"sheet":"Répartition","index":2,"n_rows":30,"n_cols":12,"rows_kept":30,"merged":[[6,1,6,3],[6,4,6,7],[6,8,6,9],[6,10,6,11],[9,1,9,3],[9,4,9,7],[9,8,9,9],[9,10,9,11]]}
[]
[{"$nulls":11},"BUDGET DE PARTICIPATION"]
[{"$nulls":11},"Répartition des heures "]
["Les cases complétées à la présente page sont reportées automatiquement sur la page sommaire "]
["Numéro de dossier :",{"$f":"Identification!B4","v":"R-4169-2021 Phase 2"}]
["Nom de l'intervenant :",{"$f":"Identification!B5","v":"Option consommateurs"}]
["Ressources","Avocats",null,null,"Analystes",{"$nulls":3},"Témoins experts",null,"Coordonnateurs"]
["Noms",{"$f":"Identification!A11","v":"Éric David"},{"$f":"Identification!A12","v":0},{"$f":"Identification!A13","v":0},{"$f":"Identification!A15","v":"Roger Higgin"},{"$f":"Identification!A16","v":0},{"$f":"Identification!A17","v":0},{"$f":"Identification!A18","v":0},{"$f":"Identification!A20","v":0},{"$f":"Identification!A21","v":0},{"$f":"Identification!A23","v":0},{"$f":"Identification!A24","v":0}]
["Taux horaire",{"$f":"Identification!D11","v":{"v":300,"d":"300 $"}},{"$f":"Identification!D12","v":0},{"$f":"Identification!D13","v":0},{"$f":"Identification!D15","v":{"v":240,"d":"240 $"}},{"$f":"Identification!D16","v":0},{"$f":"Identification!D17","v":0},{"$f":"Identification!D18","v":0},{"$f":"Identification!D20","v":0},{"$f":"Identification!D21","v":0},{"$f":"Identification!D23","v":0},{"$f":"Identification!D24","v":0}]
[null,"Heures prévues",null,null,"Heures prévues",{"$nulls":3},"Heures prévues",null,"Heures prévues"]
["Activités"]
["Étude de la preuve du demandeur",5,null,null,10]
["Demande d'intervention",2,null,null,2]
["Préparation des DDR",1,null,null,6]
["Étude des réponses aux DDR",1,null,null,4]
["Préparation de la preuve de l'intervenant",8,null,null,20]
["Étude des preuves des autres intervenants ",1,null,null,6]
["Préparation des réponses aux DDR",1,null,null,3]
["Préparation de l'audience",10,null,null,10]
["Participation plaidoirie",15,null,null,8]
["Participation à l'audience",15,null,null,15]
["Contingences",5,null,null,5]
[]
[]
["Total des heures prévues",{"$f":"SUM(B12:B24)","v":64},0,{"$f":"SUM(D12:D24)","v":0},89,0,0,0,0,0,{"$f":"SUM(K12:K24)","v":0},0]
["Total budget de participation (avant taxes) ",{"$f":"B25*B9","v":{"v":19200,"d":"19,200.00 $"}},0,0,{"v":21360,"d":"21,360.00 $"},0,0,0,0,0,0,0]
[]
["TPS / TVQ admissibles ?"]
[]
["Total budget de participation",{"$f":"B26+B28","v":{"v":19200,"d":"19,200.00 $"}},{"$f":"C26+C28","v":0},0,{"v":21360,"d":"21,360.00 $"},0,{"$f":"G26+G28","v":0},0,0,0,0,0]

{"sheet":"Justification","index":3,"n_rows":7,"n_cols":5,"rows_kept":7,"merged":[[2,0,2,4],[3,1,3,4],[4,1,4,4],[5,0,5,4],[6,0,6,4],[7,0,7,4],[8,0,8,4],[9,0,9,4],[10,0,10,4],[11,0,11,4],[12,0,12,4],[13,0,13,4],[14,0,14,4],[15,0,15,4],[16,0,16,4],[17,0,17,4],[18,0,18,4],[19,0,19,4],[20,0,20,4],[21,0,21,4],[22,0,22,4],[23,0,23,4],[24,0,24,4],[25,0,25,4],[26,0,26,4],[27,0,27,4],[28,0,28,4],[29,0,29,4],[30,0,30,4],[31,0,31,4],[32,0,32,4],[33,0,33,4],[34,0,34,4],[35,0,35,4],[36,0,36,4],[37,0,37,4],[38,0,38,4],[39,0,39,4]]}
[{"$nulls":4},"BUDGET DE PARTICIPATION"]
[{"$nulls":4},"Justification"]
[]
["Numéro de dossier :",{"$f":"Identification!B4","v":"R-4169-2021 Phase 2"}]
["Nom de l'intervenant :",{"$f":"Identification!B5","v":"Option consommateurs"}]
["Détailler la relation entre la partie du budget de participation et les enjeux que vous souhaitez aborder. "]
["Voir le formulaire Liste des sujets"]