{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["1-AIDE","2-Estimation - Analyse","3-FORMULAIRE","SHQ-PML (usage exclusif SHQ)"],"not_rendered":{"charts":0,"images":11,"macros":1,"external_links":0,"defined_names":23,"comments":1,"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":"1-AIDE","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"2-Estimation - Analyse","index":1,"n_rows":695,"n_cols":37,"rows_kept":695,"cut":false,"hidden":false,"merged":[[622,1,623,1],[642,0,642,1],[646,0,646,1],[647,0,647,1],[649,0,649,1],[654,0,654,1],[656,0,656,1],[625,0,625,1],[630,0,630,1],[631,0,631,1],[633,0,633,1],[638,0,638,1],[639,0,639,1],[640,0,640,1],[641,0,641,1],[651,0,652,0],[651,1,652,1],[28,15,28,17],[29,15,29,17],[32,25,34,25],[32,26,34,26],[32,27,34,27],[601,32,604,32],[613,2,613,3],[28,22,28,33],[601,22,604,22],[537,1,537,2],[520,1,520,2],[495,1,496,3],[500,1,500,3],[518,1,518,3],[532,1,532,3],[538,1,538,3],[546,1,546,3],[554,1,554,3],[504,1,504,2],[505,1,505,2],[506,1,506,2],[507,1,507,2],[29,22,31,23],[29,24,31,27],[29,28,31,31],[29,32,31,33],[601,34,602,34],[601,33,602,33],[603,34,604,34],[601,24,604,24],[601,26,604,26],[601,28,604,28],[622,34,623,34],[622,32,623,32],[627,34,628,34],[627,32,628,32],[635,34,636,34],[627,15,628,15],[609,15,610,15],[622,15,623,15],[32,24,34,24],[635,17,636,17],[32,22,34,22],[32,23,34,23],[651,34,652,34],[32,29,34,29],[32,30,34,30],[32,31,34,31],[32,32,34,32],[32,33,34,33],[32,34,34,34],[4,11,4,13],[5,11,5,13],[16,15,16,17],[17,15,17,17],[18,15,18,17],[19,15,19,17],[20,15,20,17],[21,15,21,17],[22,15,22,17],[23,15,23,17],[24,15,24,17],[10,15,10,17],[4,15,4,17],[5,15,5,17],[11,15,11,17],[12,15,12,17],[15,15,15,17],[4,23,4,34],[601,30,604,30],[29,3,29,6],[31,17,34,17],[4,19,8,19],[31,11,31,15],[603,6,604,6],[588,1,588,3],[597,1,597,3],[381,1,381,2],[391,1,391,2],[371,1,371,2],[372,1,372,2],[281,1,281,2],[282,1,282,2],[283,1,283,2],[293,1,293,2],[32,28,34,28],[27,24,27,31],[7,11,8,17],[502,1,502,2],[503,1,503,2],[514,1,514,2],[29,34,31,34],[4,3,4,4],[302,1,302,2],[317,1,317,2],[51,1,51,2],[50,1,50,2],[62,1,62,2],[63,1,63,2],[76,1,76,2],[72,1,72,2],[71,1,71,2],[80,1,80,2],[74,1,74,2],[137,1,137,2],[138,1,138,2],[139,1,139,2],[151,1,151,2],[5,3,5,4],[68,1,68,2],[69,1,69,2],[294,1,294,2],[84,1,84,2],[200,1,200,2],[88,1,88,2],[186,1,186,2],[511,1,511,2],[512,1,512,2],[498,1,498,2],[499,1,499,2],[342,1,342,2],[445,1,445,2],[380,1,380,2],[396,1,396,2],[393,1,393,3],[473,1,473,2],[472,1,472,2],[394,1,394,2],[395,1,395,2],[418,1,418,2],[414,1,414,2],[404,1,404,2],[415,1,415,2],[398,1,398,2],[399,1,399,2],[400,1,400,3],[401,1,401,2],[373,1,373,3],[432,1,432,3],[437,1,437,3],[39,1,39,2],[40,1,40,2],[13,15,13,17],[14,15,14,17],[164,1,164,2],[165,1,165,2],[232,1,232,2],[118,1,118,2],[124,1,124,2],[122,1,122,2],[101,1,101,2],[94,1,94,2],[33,15,34,15],[201,1,201,2],[210,1,210,2],[211,1,211,2],[112,1,112,2],[86,1,86,2],[89,1,89,2],[82,1,82,2],[83,1,83,2],[25,15,25,17],[26,15,26,17],[27,15,27,17],[87,1,87,2],[95,1,95,2],[96,1,96,2],[92,1,92,2],[93,1,93,2],[97,1,97,2],[105,1,105,2],[103,1,103,3],[98,1,98,2],[100,1,100,2],[467,1,467,3],[462,1,462,3],[422,1,422,2],[102,1,102,2],[119,1,119,2],[106,1,106,2],[107,1,107,2],[387,1,387,2],[364,1,364,2],[397,1,397,2],[384,1,384,2],[385,1,385,2],[392,1,392,2],[374,1,374,2],[463,1,463,2],[184,1,184,3],[323,1,323,2],[292,1,292,2],[194,1,194,3],[203,1,203,3],[108,1,108,2],[109,1,109,2],[115,1,115,3],[113,1,113,2],[213,1,213,3],[310,1,310,3],[297,1,297,2],[460,1,460,2],[365,1,365,2],[316,1,316,2],[311,1,311,2],[312,1,312,2],[313,1,313,2],[326,1,326,2],[333,1,333,3],[301,1,301,2],[360,1,360,3],[366,1,366,2],[315,1,315,2],[288,1,288,2],[289,1,289,2],[290,1,290,2],[299,1,299,2],[291,1,291,3],[361,1,361,2],[362,1,362,2],[335,1,335,2],[386,1,386,2],[495,0,496,0],[426,1,426,2],[435,1,435,2],[552,1,552,2],[161,0,162,0],[161,1,162,3],[229,0,230,0],[229,1,230,3],[377,0,378,0],[377,1,378,3],[388,0,389,0],[388,1,389,3],[179,1,179,2],[180,1,180,2],[183,1,183,2],[195,1,195,2],[196,1,196,2],[197,1,197,2],[188,1,188,2],[190,1,190,2],[193,1,193,2],[318,1,318,2],[189,1,189,2],[322,1,322,2],[405,0,406,0],[492,1,492,3],[603,15,604,15],[517,1,517,2],[508,1,508,2],[509,1,509,2],[510,1,510,2],[513,1,513,2],[417,1,417,2],[408,1,408,2],[409,1,409,2],[489,1,489,2],[490,1,490,2],[515,1,515,2],[516,1,516,2],[529,1,529,2],[600,1,600,2],[579,1,579,2],[556,1,556,2],[557,1,557,2],[558,1,558,2],[459,1,459,3],[559,1,559,2],[561,1,561,2],[454,1,454,2],[429,1,429,2],[428,1,428,2],[441,1,441,2],[375,1,375,2],[376,1,376,2],[423,1,423,2],[424,1,424,2],[451,1,451,2],[452,1,452,2],[453,1,453,2],[440,1,440,2],[521,1,521,2],[474,1,474,2],[412,1,412,2],[346,1,346,2],[349,1,349,2],[350,1,350,2],[353,1,353,2],[351,1,351,3],[370,1,370,2],[382,1,382,3],[416,1,416,2],[471,1,471,3],[436,1,436,2],[438,1,438,2],[367,1,367,2],[368,1,368,2],[410,1,410,3],[420,1,420,3],[419,1,419,2],[413,1,413,2],[363,1,363,2],[458,1,458,2],[383,1,383,2],[405,1,406,3],[36,0,37,0],[36,1,37,4],[41,1,41,3],[53,1,53,3],[70,1,70,3],[79,1,79,3],[90,1,90,3],[43,1,43,2],[44,1,44,2],[45,1,45,2],[57,1,57,2],[58,1,58,2],[59,1,59,2],[46,1,46,2],[47,1,47,2],[48,1,48,2],[52,1,52,2],[75,1,75,2],[61,1,61,2],[42,1,42,2],[54,1,54,2],[81,1,81,2],[65,0,66,0],[65,1,66,3],[73,1,73,2],[456,1,456,2],[587,1,587,2],[571,1,571,2],[572,1,572,2],[573,1,573,2],[574,1,574,2],[575,1,575,2],[576,1,576,2],[581,1,581,2],[582,1,582,2],[167,1,167,2],[175,1,175,3],[158,1,158,2],[154,1,154,2],[155,1,155,2],[166,1,166,3],[577,1,577,2],[578,1,578,2],[303,1,303,2],[369,1,369,3],[348,1,348,2],[461,1,461,2],[457,1,457,2],[49,1,49,2],[85,1,85,2],[135,1,135,2],[136,1,136,2],[126,1,126,2],[127,1,127,2],[130,1,130,2],[153,1,153,2],[146,1,146,2],[147,1,147,2],[148,1,148,2],[150,1,150,2],[123,1,123,2],[134,1,134,2],[55,1,55,2],[56,1,56,2],[60,1,60,2],[64,1,64,2],[133,1,133,2],[140,1,140,2],[141,1,141,2],[144,1,144,2],[77,1,77,2],[78,1,78,2],[159,1,159,2],[152,1,152,3],[125,1,125,2],[121,1,121,2],[160,1,160,2],[120,1,120,2],[116,1,116,2],[110,1,110,2],[111,1,111,2],[114,1,114,2],[149,1,149,2],[156,1,156,2],[157,1,157,2],[131,1,131,3],[145,1,145,3],[128,1,128,2],[129,1,129,2],[142,1,142,2],[143,1,143,2],[207,1,207,2],[208,1,208,2],[198,1,198,2],[199,1,199,2],[204,1,204,2],[168,1,168,2],[170,1,170,2],[174,1,174,2],[202,1,202,2],[169,1,169,2],[171,1,171,2],[176,1,176,2],[178,1,178,2],[177,1,177,2],[206,1,206,2],[172,1,172,2],[173,1,173,2],[181,1,181,2],[191,1,191,2],[192,1,192,2],[205,1,205,2],[187,1,187,2],[182,1,182,2],[185,1,185,2],[209,1,209,2],[212,1,212,2],[239,1,239,2],[240,1,240,2],[236,1,236,2],[237,1,237,2],[238,1,238,2],[221,1,221,2],[223,1,223,2],[224,1,224,2],[225,1,225,2],[226,1,226,2],[228,1,228,2],[235,1,235,2],[217,1,217,2],[218,1,218,2],[214,1,214,2],[215,1,215,2],[222,1,222,3],[234,1,234,3],[216,1,216,2],[233,1,233,2],[219,1,219,2],[220,1,220,2],[243,1,243,2],[244,1,244,2],[247,1,247,2],[246,1,246,2],[241,1,241,2],[227,1,227,2],[242,1,242,3],[251,1,251,2],[253,1,253,2],[248,1,248,2],[252,1,252,3],[245,1,245,3],[249,1,249,2],[250,1,250,2],[258,1,258,2],[259,1,259,2],[266,1,266,2],[255,1,255,2],[263,1,263,2],[262,1,262,2],[256,1,256,2],[257,1,257,2],[260,1,260,2],[475,1,475,2],[443,1,443,3],[449,1,449,3],[254,1,254,2],[264,1,264,2],[265,1,265,2],[359,1,359,2],[320,1,320,3],[354,1,354,2],[352,1,352,2],[355,1,355,2],[356,1,356,2],[279,1,279,2],[280,1,280,2],[261,1,261,3],[307,1,307,2],[327,1,327,3],[357,1,357,2],[358,1,358,2],[314,1,314,2],[339,1,339,2],[341,1,341,2],[343,1,343,2],[340,1,340,3],[468,1,468,2],[469,1,469,2],[309,1,309,2],[305,1,305,2],[306,1,306,2],[427,1,427,3],[334,1,334,2],[347,1,347,3],[336,1,336,2],[338,1,338,2],[337,1,337,3],[431,1,431,2],[455,1,455,2],[434,1,434,2],[433,1,433,2],[446,1,446,2],[447,1,447,2],[448,1,448,2],[439,1,439,2],[430,1,430,2],[444,1,444,2],[344,1,344,2],[345,1,345,2],[442,1,442,2],[267,1,267,3],[268,1,268,2],[269,1,269,2],[274,1,274,3],[270,1,270,2],[275,1,275,2],[276,1,276,2],[277,1,277,2],[278,1,278,2],[271,1,271,2],[272,1,272,2],[273,1,273,2],[531,1,531,2],[284,1,284,3],[287,1,287,2],[328,1,328,2],[321,1,321,2],[330,1,330,2],[331,1,331,2],[332,1,332,2],[324,1,324,2],[325,1,325,2],[329,1,329,2],[285,1,285,2],[286,1,286,2],[319,1,319,2],[482,1,482,3],[304,1,304,3],[295,1,295,2],[296,1,296,2],[300,1,300,2],[308,1,308,2],[298,1,298,2],[476,1,476,3],[425,1,425,2],[450,1,450,2],[551,1,551,2],[564,1,564,2],[592,1,592,2],[593,1,593,2],[547,1,547,2],[548,1,548,2],[549,1,549,2],[550,1,550,2],[584,1,584,2],[563,1,563,2],[565,1,565,2],[555,1,555,2],[631,2,631,3],[609,2,610,3],[615,2,615,3],[622,2,623,3],[617,2,618,3],[617,4,618,4],[614,2,614,3],[523,1,523,2],[524,1,524,2],[527,1,527,2],[526,1,526,2],[533,1,533,2],[534,1,534,2],[535,1,535,2],[536,1,536,2],[525,1,525,2],[543,1,543,2],[544,1,544,2],[530,1,530,2],[542,1,542,2],[528,1,528,2],[560,1,560,2],[569,1,569,3],[595,1,595,2],[635,6,636,6],[630,2,630,3],[491,1,491,2],[477,1,477,2],[478,1,478,2],[479,1,479,2],[480,1,480,2],[485,1,485,2],[635,0,636,0],[635,1,636,1],[609,0,610,0],[609,1,610,1],[622,0,623,0],[627,0,628,0],[627,1,628,1],[583,1,583,2],[580,1,580,3],[566,1,566,2],[567,1,567,2],[562,1,562,2],[540,1,540,2],[541,1,541,2],[625,2,625,3],[627,2,628,3],[33,11,33,13],[603,2,604,3],[603,13,604,13],[609,13,610,13],[622,13,623,13],[627,13,628,13],[603,12,604,12],[609,12,610,12],[622,12,623,12],[627,12,628,12],[603,11,604,11],[609,11,610,11],[622,11,623,11],[627,11,628,11],[487,1,487,2],[488,1,488,2],[484,1,484,2],[33,1,33,4],[34,1,34,2],[494,1,494,2],[522,1,522,2],[627,4,628,4],[622,4,623,4],[609,4,610,4],[658,2,658,4],[633,2,633,4],[635,2,636,4],[638,2,638,3],[639,2,639,3],[640,2,640,3],[642,2,642,3],[644,2,644,3],[646,2,646,3],[647,2,647,3],[649,2,649,4],[641,2,641,3],[651,2,652,4],[654,2,654,4],[4,18,8,18],[603,4,604,4],[545,1,545,2],[539,1,539,2],[656,2,656,4],[585,1,585,2],[586,1,586,2],[594,1,594,2],[589,1,589,2],[553,1,553,2],[590,1,590,2],[570,1,570,2],[606,2,606,3],[607,2,607,3],[493,1,493,2],[483,1,483,2],[486,1,486,2],[466,1,466,2],[464,1,464,2],[465,1,465,2],[470,1,470,2],[481,1,481,2],[617,11,618,11],[617,12,618,12],[617,13,618,13],[617,15,618,15],[617,32,618,32],[617,34,618,34],[620,2,620,3],[591,1,591,2],[568,1,568,2],[599,1,599,2],[598,1,598,2],[596,1,596,2],[609,34,610,34],[609,32,610,32],[603,0,604,1],[606,0,606,1],[607,0,607,1],[612,0,612,1],[613,0,613,1],[614,0,614,1],[615,0,615,1],[620,0,620,1],[612,2,612,3],[617,0,618,1],[619,0,619,1]]}
[2026,"PROJET SPÉCIAL  ","- Estimation des coûts / Analyse du projet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SHQ …",null,null,null,null,"Se placer au niveau d'affichage # 3 (en haut à gauche)  pour l'analyse",null,null,null,null,null,null,null,null,null,null,null,"...Masqué / Afficher"]
[]
["  1 ; Remplir les cases en blanc uniquement. 2 ; Ouvrir les sections avec l'icone \"+\" (à gauche) où se placer au niveau d'affichage # 3 (en haut à gauche) pour compléter."]
[]
[1,"Projet ","# Ei","Nom du Ei: ?",null,null,"Phase analysée",null,null,null,null,"Date d'estimation ou mise à jour :",null,null,null,"20XX-XX-XX",null,null,"FILTRE","FILTRE copie PDF (Décoch. \"VIDE\")",null,null,3," Analyse / Commentaires"]
["CS :","CS ?","?","Dossier BSI (module projet) : ?",null,null,"? de ?",null,null,null,null,"Date de fin d'entente SCHL:",null,null,null,"20XX-XX-XX"]
[]
["Nbre log.","Nbre de bâtiments touchés par les travaux","IVP","Valeur municipale (bâtiment)","VAR BSI",null,"$ Travaux ttc (phase)",null,null,null,null,"N. b : Le montant des $ travaux (section 1) de la phase  inclut les frais, les taxes et les hon. prof. Le total doit être égal à l'estimation du Projet ttc (section 2) de la phase. Le déficit d'entretien projeté (DEP) détermine l'IVP."]
[{"$f":"SUM(A12:A29)","v":0},"?",{"$f":"IF(A9>0,M30/E9*100,\"\")","v":""},{"$f":"SUM(D12:D29)","v":0},{"$f":"SUM(E12:E29)","v":0},null,{"$f":"SUM(G12:G28)","v":0}]
[]
[null,"Adresse des travaux (ou no. d'immeuble)",null,null,null,null,"incl. frais, hon. prof., taxes",null,null,null,null,"Moy./Log.","DEP",null,null,"Notes",null,null,null,{"$f":"IF(L11=\"\",\"VIDE\",\"X\")","v":"X"}]
[null,null,{"$f":"M12/E12","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"IF(A12>0,G12/A12,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(L12=\"\",\"VIDE\",\"X\")","v":"VIDE"}]
[null,null,{"$f":"M13/E13","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,{"$f":"IF(A13>0,G13/A13,\"\")","v":""},null,null,null,null,null,null,null,{"$f":"IF(L13=\"\",\"VIDE\",\"X\")","v":"VIDE"}]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE"]
[null,null,{"$error":"#DIV/0!"},null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,"VIDE",null,null,null,null,"Ajustement du PML"]
[null,null,null,null,"Validation % Estim. :",null,{"$f":"IF(SUM(G11:G28)>0,$G$9/$G$659,\"\")","v":""},null,null,null,null,"Moy. Approx.",null,null,null,null,null,null,null,"X",null,null,"Indiquer un % du montant dans les cases en blanc"]
[null,null,null,"Si Pourcentage ≠ 100 % :  Erreur entre total \"$ Projet\" versus \"$ Coûts par bâtiments\" :",null,null,null,null,null,null,null,{"$f":"IF(A9>0,(G9/A9),\"\")","v":""},{"$f":"IF(SUM(M12:M28)>0,SUM(M12:M29),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(SUM(L12:L30)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"Impact                 (Phase analysée)",null,"Mise aux normes (Projet)",null,null,null,"Dépréciations                           (valeur marchande) ",null,null,null,"Scénario                 coupure de travaux (travaux conservés)",null,"Commentaires généraux"]
[null,": Nombre total de logements du Ei ",null,null,"Indice d'état : ",null,{"$f":"IF($C$9<>\"\",\nIF(AND($C$9>=0,$C$9<5.001),\"A\",IF(AND($C$9>5,$C$9<10.001),\"B\",IF(AND($C$9>10,$C$9<15.001),\"C\",IF(AND($C$9>15,$C$9<30.001),\"D\",IF(AND($C$9>=30.001),\"E\"))))),\"\")","v":""},null,null,null,null,"Moy./Log.(total)","DEP (Total) ",null,null,null,null,null,null,{"$f":"IF(L31>0,\"X\",\"VIDE\")","v":"X"}]
[null,null,null,null,null,null,null,null,null,null,null,"Suivi de projet",null,null,null,null,null,"Cochez travaux \"Urgent\" (1 an max. (phase analysée)) selon CS."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urgence       (Moyen terme)","%","Phase analysée","%","Projet total","%","Phase analysée","%","Projet total","%","Phase analysée ($ conservé)","%","Commentaires"]
[2,"Ventilation détaillée des coûts (avant frais et taxes)",null,null,null,null,"Phase analysée",null,null,null,null,"Autres phases\n($ projetés / mise à jour (Indiquer # et année))",null,null,null,"TOTAL PROJET"]
["Code","Nom du composant",null,"Description","Coût unitaire",null,{"$f":"G6","v":"? de ?"},null,null,null,null,"? (année)","? (année)","? (année)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E40:E65)+SUM(L40:N65)>0,\"X\",\"VIDE\")","v":"VIDE"}]
["A","INFRASTRUCTURE",null,null,null,null,{"$f":"IF(SUM(E40:E65)>0,G38/$E$604,\"\")","v":""},{"$f":"G37","v":""},null,null,null,{"$f":"IF(SUM(L40:L65)>0,L38/L604,\"\")","v":""},{"$f":"IF(SUM(M40:M65)>0,M38/M604,\"\")","v":""},{"$f":"IF(SUM(N40:N65)>0,N38/N604,\"\")","v":""},null,{"$f":"IF(SUM(G38)+SUM(L38:N38)>0,P38/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E40:E65)+SUM(L40:N65)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W40:W65)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y40:Y65)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA40:AA65)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC40:AC65)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE40:AE65)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG40:AG65)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E40:E65)>0,SUM(E40:E65),\"\")","v":""},null,{"$f":"G38","v":""},null,null,{"$f":"IF(SUM(L40:L65)>0,SUM(L40:L65),\"\")","v":""},{"$f":"IF(SUM(M40:M65)>0,SUM(M40:M65),\"\")","v":""},{"$f":"IF(SUM(N40:N65)>0,SUM(N40:N65),\"\")","v":""},null,{"$f":"IF(SUM(G38)+SUM(L38:N38)>0,SUM(E40:E65)+SUM(L40:N65),\"\")","v":""},null,{"$f":"IF(COUNTA(R40:R65)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E40:E65)+SUM(L40:N65)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X38>0,E38*X38,\"\")","v":""},null,{"$f":"IF(Z38>0,E38*Z38,\"\")","v":""},null,{"$f":"IF(AB38>0,SUM(L38:N38)*AB38,\"\")","v":""},null,{"$f":"IF(AD38>0,E38*AD38,\"\")","v":""},null,{"$f":"IF(AF38>0,SUM(P38)*AF38,\"\")","v":""},null,{"$f":"IF(AH38>0,SUM(E38)*AH38,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E40:E65)+SUM(L40:N65)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E40)>0,SUM(E40),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E40:N40)>0,E40+SUM(L40:N40),\"\")","v":""},null,null,null,{"$f":"IF(E40+SUM(L40:N40)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X40>0,E40*X40,\"\")","v":""},null,{"$f":"IF(Z40>0,E40*Z40,\"\")","v":""},null,{"$f":"IF(AB40>0,SUM(L40:N40)+E40*AB40,\"\")","v":""},null,{"$f":"IF(AD40>0,E40*AD40,\"\")","v":""},null,{"$f":"IF(AF40>0,SUM(P40)*AF40,\"\")","v":""},null,{"$f":"IF(AH40>0,SUM(E40)*AH40,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E41)>0,SUM(E41),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E41:N41)>0,E41+SUM(L41:N41),\"\")","v":""},null,null,null,{"$f":"IF(E41+SUM(L41:N41)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X41>0,E41*X41,\"\")","v":""},null,{"$f":"IF(Z41>0,E41*Z41,\"\")","v":""},null,"",null,{"$f":"IF(AD41>0,E41*AD41,\"\")","v":""},null,{"$f":"IF(AF41>0,SUM(P41)*AF41,\"\")","v":""},null,{"$f":"IF(AH41>0,SUM(E41)*AH41,\"\")","v":""}]
["A 1011","FONDATIONS ET DALLES INFÉRIEURES",null,null,null,null,{"$f":"IF(SUM(E43:E53)>0,SUM(E43:E53),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E43:E53)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 1011","Fondations et dalles inférieures\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB43>0,SUM(L43:N43)+E43*AB43,\"\")","v":""},null,"",null,"",null,""]
["A 101101","Murs de fondation et empattement\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB44>0,SUM(L44:N44)+E44*AB44,\"\")","v":""},null,"",null,"",null,""]
["A 101102","Pilastres aux murs de fondation\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 101103","Revêtement et finition extérieurs sur murs de fondations",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 101104","Système de drainage des fondations\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 101105","Pieux, micropieux, radiers\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 101106","Dalles sur sol\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 101107","Fosses d'ascenseurs\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 2021","CONSTRUCTION EN SOUS-SOL (vide sanitaire)",null,null,null,null,{"$f":"IF(SUM(E55:E65)>0,SUM(E55:E65),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E55:E65)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 2021","Construction en sous-sol (vide sanitaire)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202101","Plancher de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202102","Plafond de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202103","Coupe-feu de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202104","Protection contre l'humidité de sous-sol et de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202105","Isolation de murs de sous-sol et de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202106","Trappe d'accès de vide sanitaire\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["A 202107","Grille de ventilation de vide sanitaire",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B","SUPERSTRUCTURE ET ENVELOPPE",null,null,null,null,{"$f":"IF(SUM(E69:E161)>0,G67/$E$604,\"\")","v":""},{"$f":"G66","v":""},null,null,null,{"$f":"IF(SUM(L69:L161)>0,L67/L604,\"\")","v":""},{"$f":"IF(SUM(M69:M161)>0,M67/M604,\"\")","v":""},{"$f":"IF(SUM(N69:N161)>0,N67/N604,\"\")","v":""},null,{"$f":"IF(SUM(G67)+SUM(L67:N67)>0,P67/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E69:E161)+SUM(L69:N161)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W69:W161)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y69:Y161)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA69:AA161)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC69:AC161)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE69:AE161)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG69:AG161)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E69:E161)>0,SUM(E69:E161),\"\")","v":""},null,{"$f":"G67","v":""},null,null,{"$f":"IF(SUM(L69:L161)>0,SUM(L69:L161),\"\")","v":""},{"$f":"IF(SUM(M69:M161)>0,SUM(M69:M161),\"\")","v":""},"",null,{"$f":"IF(SUM(G67)+SUM(L67:N67)>0,SUM(E69:E161)+SUM(L69:N161),\"\")","v":""},null,{"$f":"IF(COUNTA(R69:R161)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E69:E161)+SUM(L69:N161)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E69:E161)+SUM(L69:N161)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E69)>0,SUM(E69),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E69:N69)>0,E69+SUM(L69:N69),\"\")","v":""},null,null,null,{"$f":"IF(E69+SUM(L69:N69)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E70)>0,SUM(E70),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E70:N70)>0,E70+SUM(L70:N70),\"\")","v":""},null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 1011","PLANCHERS ET MURS STRUCTURAUX",null,null,null,null,{"$f":"IF(SUM(E72:E79)>0,SUM(E72:E79),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E72:E79)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 1011","Planchers et murs structuraux",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101101","Planchers des bâtiments",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101102","Faux-planchers au sous-sol et au rez-de-chaussée",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101103","Murs mitoyens",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101104","Murs porteurs intérieurs et extérieurs, poutres et colonnes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 1012","BALCONS, PALIERS, ESCALIERS, RAMPES ET ÉCHELLES EXTÉRIEURES",null,null,null,null,{"$f":"IF(SUM(E81:E90)>0,SUM(E81:E90),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E81:E90)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 1012","Balcons, paliers, escaliers, rampes et échelles extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101201","Structure des balcons, paliers et escaliers extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101202","Planchers des balcons, rampes et marches d'escaliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101203","Balustrades et mains courantes extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101204","Peinture des balcons, paliers et escaliers extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101205","Échelles d'issues intégrées",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 101206","Paliers de services intégrés {eau, combustible, etc.}",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 2011","ENVELOPPE EXTÉRIEURE",null,null,null,null,{"$f":"IF(SUM(E92:E103)>0,SUM(E92:E103),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E92:E103)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201101","Parement (moulures et solins inclus)","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201102","Linteaux libres des ouvertures extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201103","Allèges non intégrées aux ouvertures extérieures\n",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201104","Isolation, pare-vapeur, pare-air du bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201105","Étanchéité interne {solin souple, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201106","Persiennes et grillages extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201108","Joints et calfeutrage au parement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201109","Peinture et teinture au parement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 201110","Second parement (moulures et solins inclus)","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 2021","FENÊTRES",null,null,null,null,{"$f":"IF(SUM(E105:E115)>0,SUM(E105:E115),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E105:E115)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 2021","Fenêtres","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X105>0,E105*X105,\"\")","v":""},null,{"$f":"IF(Z105>0,E105*Z105,\"\")","v":""},null,"",null,{"$f":"IF(AD105>0,E105*AD105,\"\")","v":""},null,{"$f":"IF(AF105>0,SUM(P105)*AF105,\"\")","v":""},null,{"$f":"IF(AH105>0,SUM(E105)*AH105,\"\")","v":""}]
["B 202101","Cadres et allèges intégrés",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 202102","Parties ouvrantes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 202103","Parties de verre fixe",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB108>0,SUM(L108:N108)+E108*AB108,\"\")","v":""},null,"",null,"",null,""]
["B 202104","Moustiquaires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 202105","Quincaillerie de fenêtres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 202108","Calfeutrage au périmètre des fenêtres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 202109","Peinture et teinture des fenêtres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 2031","PORTES EXTÉRIEURES",null,null,null,null,{"$f":"IF(SUM(E117:E131)>0,SUM(E117:E131),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E117:E131)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203101","Cadres de portes extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203102","Portes","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203103","Contre-portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203104","Quincaillerie de portes extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203105","Ferme-portes extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203106","Seuils de portes extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203107","Coupe-froid de portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203108","Calfeutrage au périmètre des portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203109","Peinture et teinture des portes extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203110","Vitrage de portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203111","Moustiquaires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 203112","Portes-fenêtres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 3011","COUVERTURE",null,null,null,null,{"$f":"IF(SUM(E133:E145)>0,SUM(E133:E145),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E133:E145)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 3011","Couverture","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,{"$f":"IF(E133+SUM(L133:N133)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301101","Membrane de toit",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E134:N134)>0,E134+SUM(L134:N134),\"\")","v":""},null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301102","Solinage de toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301103","Structure de toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301104","Ventilateurs de toit (à gravité, statiques et mobiles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301105","Circulation sur le toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301106","Avant-toit et soffites d'avant-toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301107","Gouttières et descentes pluviales",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301108","Câbles chauffants et protection au toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 301109","Marquises",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 3021","OUVERTURES DE TOIT",null,null,null,null,{"$f":"IF(SUM(E147:E152)>0,SUM(E147:E152),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E147:E152)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 302101","Lanterneaux",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 302102","Ouvertures et sorties mécaniques au toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 302103","Trappe d'accès au toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 3091","COMPOSANTS DES COMBLES (entretoit)",null,null,null,null,{"$f":"IF(SUM(E154:E161)>0,SUM(E154:E161),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E154:E161)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 309101","Trappe d'accès à l'entretoit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 309102","Circulation dans l'entretoit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 309103","Isolation et pare-vapeur à l'entretoit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 309104","Coupe-feu dans l'entretoit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["B 309105","Ventilateurs muraux d'entretoit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C","AMÉNAGEMENT INTÉRIEUR (aire commune)",null,null,null,null,{"$f":"IF(SUM(E165:E229)>0,G163/$E$604,\"\")","v":""},{"$f":"G162","v":""},null,null,null,{"$f":"IF(SUM(L165:L229)>0,L163/L604,\"\")","v":""},{"$f":"IF(SUM(M165:M229)>0,M163/M604,\"\")","v":""},{"$f":"IF(SUM(N165:N229)>0,N163/N604,\"\")","v":""},null,{"$f":"IF(SUM(G163)+SUM(L163:N163)>0,P163/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E165:E229)+SUM(L165:N229)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W165:W229)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y165:Y229)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA165:AA229)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC165:AC229)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE165:AE229)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG165:AG229)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E165:E229)>0,SUM(E165:E229),\"\")","v":""},null,{"$f":"G163","v":""},null,null,{"$f":"IF(SUM(L165:L229)>0,SUM(L165:L229),\"\")","v":""},{"$f":"IF(SUM(M165:M229)>0,SUM(M165:M229),\"\")","v":""},{"$f":"IF(SUM(N165:N229)>0,SUM(N165:N229),\"\")","v":""},null,{"$f":"IF(SUM(G163)+SUM(L163:N163)>0,SUM(E165:E229)+SUM(L165:N229),\"\")","v":""},null,{"$f":"IF(COUNTA(R165:R229)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E165:E229)+SUM(L165:N229)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E165:E229)+SUM(L165:N229)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E165)>0,SUM(E165),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E165:N165)>0,E165+SUM(L165:N165),\"\")","v":""},null,null,null,{"$f":"IF(E165+SUM(L165:N165)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E166)>0,SUM(E166),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 1011","CLOISONS",null,null,null,null,{"$f":"IF(SUM(E168:E175)>0,SUM(E168:E175),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E168:E175)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 1011","Cloisons",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 101101","Cloisonnements coupe-feu",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X169>0,E169*X169,\"\")","v":""},null,{"$f":"IF(Z169>0,E169*Z169,\"\")","v":""},null,"",null,{"$f":"IF(AD169>0,E169*AD169,\"\")","v":""},null,{"$f":"IF(AF169>0,SUM(P169)*AF169,\"\")","v":""},null,{"$f":"IF(AH169>0,SUM(E169)*AH169,\"\")","v":""}]
["C 101102","Autres cloisonnements",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 101103","Balustrades intérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 101104","Trappes d'accès dans les cloisonnements coupe-feu",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB172>0,SUM(L172:N172)+E172*AB172,\"\")","v":""},null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 1021","PORTES INTÉRIEURES",null,null,null,null,{"$f":"IF(SUM(E177:E184)>0,SUM(E177:E184),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E177:E184)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 102101","Portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 102102","Quincaillerie de portes intérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 102103","Ferme-portes intérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 102104","Cadres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 102110","Vitrage de porte",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 1031","ACCESSOIRES INTÉGRÉS",null,null,null,null,{"$f":"IF(SUM(E186:E194)>0,SUM(E186:E194),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E186:E194)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103101","Cloisons démontables et grillages",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103102","Accessoires des locaux communautaires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103103","Cases postales et boîtes aux lettres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103104","Mains courantes des corridors",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103105","Signalisation et identification de pièces",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 103106","Plans d'évacuation du bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 2011","ESCALIERS",null,null,null,null,{"$f":"IF(SUM(E196:E203)>0,SUM(E196:E203),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E196:E203)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 201101","Construction des marches et paliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 201102","Mains courantes et balustrades",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 201103","Revêtement des marches, contremarches et paliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 201104","Revêtement des mains courantes et balustrades",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 201105","Nez de marche et paliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 3011","PEINTURE DES MURS, PLAFONDS, ESCALIERS ET AUTRES FINIS INTÉRIEURS",null,null,null,null,{"$f":"IF(SUM(E205:E213)>0,SUM(E205:E213),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E205:E213)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301101","Peinture des murs et plafonds",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301102","Autres finitions des murs et plafonds",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301103","Plafonds suspendus",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301104","Peinture des marches, contre-marches et paliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301105","Peinture des mains courantes et balustrades",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 301106","Peinture et teinture de portes et cadres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 3021","FINITIONS DE PLANCHERS",null,null,null,null,{"$f":"IF(SUM(E215:E222)>0,SUM(E215:E222),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E215:E222)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302101","Couvre-sols souples et tapis",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302102","Céramique, pierre, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302103","Finition de planchers en bois",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302104","Finition de planchers en béton",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302105","Grilles gratte-pieds et tapis-brosse",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 3022","AIRES DE STATIONNEMENT INTÉRIEUR (garage)",null,null,null,null,{"$f":"IF(SUM(E224:E229)>0,SUM(E224:E229),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E224:E229)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302201","Revêtements de plancher des garages",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302202","Bordures, butoirs et dos-d'âne intérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302203","Glissières de sécurité et commande d'accès intérieure",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302204","Lignes de peinture et marquage intérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["C 302205","Signalisation intérieure",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E229:N229)>0,E229+SUM(L229:N229),\"\")","v":""},null,null,null,{"$f":"IF(E229+SUM(L229:N229)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D","SERVICES (aire commune)",null,null,null,null,{"$f":"IF(SUM(E233:E377)>0,G231/$E$604,\"\")","v":""},{"$f":"G230","v":""},null,null,null,{"$f":"IF(SUM(L233:L377)>0,L231/L604,\"\")","v":""},{"$f":"IF(SUM(M233:M377)>0,M231/M604,\"\")","v":""},{"$f":"IF(SUM(N233:N377)>0,N231/N604,\"\")","v":""},null,{"$f":"IF(SUM(G231)+SUM(L231:N231)>0,P231/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E233:E377)+SUM(L233:N377)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W233:W377)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y233:Y377)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA233:AA377)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC233:AC377)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE233:AE377)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG233:AG377)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E233:E377)>0,SUM(E233:E377),\"\")","v":""},null,{"$f":"G231","v":""},null,null,{"$f":"IF(SUM(L233:L377)>0,SUM(L233:L377),\"\")","v":""},{"$f":"IF(SUM(M233:M377)>0,SUM(M233:M377),\"\")","v":""},{"$f":"IF(SUM(N233:N377)>0,SUM(N233:N377),\"\")","v":""},null,{"$f":"IF(SUM(G231)+SUM(L231:N231)>0,SUM(E233:E377)+SUM(L233:N377),\"\")","v":""},null,{"$f":"IF(COUNTA(R233:R377)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E233:E377)+SUM(L233:N377)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E233:E377)+SUM(L233:N377)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E233)>0,SUM(E233),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E233:N233)>0,E233+SUM(L233:N233),\"\")","v":""},null,null,null,{"$f":"IF(E233+SUM(L233:N233)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X233>0,E233*X233,\"\")","v":""},null,{"$f":"IF(Z233>0,E233*Z233,\"\")","v":""},null,"",null,{"$f":"IF(AD233>0,E233*AD233,\"\")","v":""},null,{"$f":"IF(AF233>0,SUM(P233)*AF233,\"\")","v":""},null,{"$f":"IF(AH233>0,SUM(E233)*AH233,\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E234)>0,SUM(E234),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 1011","ASCENSEURS, PLATES-FORMES, ETC.",null,null,null,null,{"$f":"IF(SUM(E236:E242)>0,SUM(E236:E242),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E236:E242)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 1011","Ascenseurs, plates-formes, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB236>0,SUM(L236:N236)+E236*AB236,\"\")","v":""},null,"",null,"",null,""]
["D 101101","Cabines d'ascenseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 101102","Commandes d'ascenseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 101103","Système de communication en cabine",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 101104","Mécanique d'ascenseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 101105","Cylindres d'ascenseurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 1091","VIDE-ORDURES ET VIDOIRS",null,null,null,null,{"$f":"IF(SUM(E244:E245)>0,SUM(E244:E245),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E244:E245)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 109101","Trappe d'accès au vide-ordures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2011","APPAREILS DE PLOMBERIE (aire commune)",null,null,null,null,{"$f":"IF(SUM(E247:E252)>0,SUM(E247:E252),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E247:E252)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 201101","Appareils sanitaires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 201102","Appareils d'entretien",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 201103","Appareils thérapeutiques",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2021","RÉSEAU D'EAU DOMESTIQUE",null,null,null,null,{"$f":"IF(SUM(E254:E261)>0,SUM(E254:E261),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E254:E261)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2021","Réseau d'eau domestique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202101","Équipement de pompage de surpression et panneau contrôle",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202102","Tuyauterie de distribution d'eau froide",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202103","Tuyauterie de distribution d'eau chaude domestique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202104","Système de traitement d'eau",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2022","CHAUFFE-EAU DOMESTIQUE (aire commune)",null,null,null,null,{"$f":"IF(SUM(E263:E267)>0,SUM(E263:E267),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E263:E267)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2022","Chauffe-eau domestique ",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202201","Unité de chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202202","Unité de préchauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 202203","Unité de réserve d'eau",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2031","RÉSEAU SANITAIRE ET PLUVIAL",null,null,null,null,{"$f":"IF(SUM(E269:E274)>0,SUM(E269:E274),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E269:E274)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 2031","Réseau sanitaire et pluvial",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 203101","Réseau de drainage sanitaire et évents",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 203102","Fosses intérieures et pompes submersibles",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 203103","Drains et puisards de planchers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 203104","Réseau de drainage pluvial de toit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3011","SOURCE D'ÉNERGIE AUTRE QU'ÉLECTRIQUE",null,null,null,null,{"$f":"IF(SUM(E276:E284)>0,SUM(E276:E284),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E276:E284)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301101","Approvisionnement en huile de chauffage et réservoirs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301102","Approvisionnement en gaz naturel et réseau intérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301103","Approvisionnement en gaz propane et réservoirs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301104","Approvisionnement en charbon",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301105","Approvisionnement en vapeur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301106","Approvisionnement en eau chaude",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301107","Système d'énergie solaire",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 301108","Système d'énergie éolienne",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3021","SYSTÈME CENTRAL DE CHAUFFAGE (eau chaude, air chaud)",null,null,null,null,{"$f":"IF(SUM(E286:E291)>0,SUM(E286:E291),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E286:E291)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 302101","Chaudière pour chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 302102","Cheminées, conduits de fumée et évents",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 302103","Boîtier de relais (système de contrôle)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 302104","Pare-feu (base et autres)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 302105","Chapeau de cheminée",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3041","DISTRIBUTION DE CVCA",null,null,null,null,{"$f":"IF(SUM(E293:E304)>0,SUM(E293:E304),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E293:E304)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3041","Distribution de CVCA",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304101","Système d'alimentation et de distribution d'air",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304102","Système d'évacuation d'air (sans échangeur)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304103","Système d'apport d'air de combustion des locaux de mécanique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304104","Système de pressurisation et de désenfumage",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E297:N297)>0,E297+SUM(L297:N297),\"\")","v":""},null,null,null,{"$f":"IF(E297+SUM(L297:N297)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X297>0,E297*X297,\"\")","v":""},null,{"$f":"IF(Z297>0,E297*Z297,\"\")","v":""},null,"",null,{"$f":"IF(AD297>0,E297*AD297,\"\")","v":""},null,{"$f":"IF(AF297>0,SUM(P297)*AF297,\"\")","v":""},null,{"$f":"IF(AH297>0,SUM(E297)*AH297,\"\")","v":""}]
["D 304105","Système de détection de monoxyde de carbone",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304106","Système de hottes commerciales",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304107","Régulation et instrumentation (ventilation)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB300>0,SUM(L300:N300)+E300*AB300,\"\")","v":""},null,"",null,"",null,""]
["D 304108","Système d'apport d'air frais des locaux de mécanique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3042","RÉSEAU DE CHAUFFAGE (eau chaude, air chaud)",null,null,null,null,{"$f":"IF(SUM(E306:E310)>0,SUM(E306:E310),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E306:E310)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304201","Système de distribution de chauffage à l'eau chaude",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304202","Radiateurs, aérotherme de chauffage à l'eau chaude",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304203","Réseau de gaines",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 304204","Grilles",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 3051","UNITÉ CVCA AUTONOME OU MONOBLOC (chauffage, ventilation )",null,null,null,null,{"$f":"IF(SUM(E312:E320)>0,SUM(E312:E320),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E312:E320)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305101","Chauffage par plinthes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305102","Aérotherme",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305103","Chauffage radiant",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305104","Ventilateur {sans conduits)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305105","Unité de chauffage-ventilation (type hôtel)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 305106","Climatiseur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 4011","GICLEURS",null,null,null,null,{"$f":"IF(SUM(E322:E327)>0,SUM(E322:E327),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E322:E327)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 401101","Équipement de pompage de surpression, gicleurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 401102","Réseau de gicleurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 401103","Panneau de commande, gicleurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 4021","CANALISATIONS ET ROBINETS D'INCENDIE",null,null,null,null,{"$f":"IF(SUM(E329:E333)>0,SUM(E329:E333),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E329:E333)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 402101","Canalisation d'alimentation en eau (intérieure)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 402102","Équipement de pompage (incendie)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 402103","Cabinets et boyaux d'incendie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 402104","Bornes-fontaines",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 4031","ACCESSOIRES DE PROTECTION INCENDIE",null,null,null,null,{"$f":"IF(SUM(E335:E337)>0,SUM(E335:E337),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E335:E337)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 403101","Extincteurs portatifs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 403102","Cabinets d'extincteurs portatifs ou supports",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 4091","SYSTÈME D'EXTINCTION POUR HOTTES COMMERCIALES",null,null,null,null,{"$f":"IF(SUM(E339:E340)>0,SUM(E339:E340),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E339:E340)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 4091","Système d'extinction pour hottes commerciales",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5011","ENTRÉE ÉLECTRIQUE ET DISTRIBUTION",null,null,null,null,{"$f":"IF(SUM(E342:E347)>0,SUM(E342:E347),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E342:E347)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 501101","Entrée électrique, distribution et délesteur de charge",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 501102","Transformateurs (intérieurs et extérieurs)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 501103","Compteurs individuels et communs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5021","ÉCLAIRAGE ET DISTRIBUTION SECONDAIRE",null,null,null,null,{"$f":"IF(SUM(E349:E351)>0,SUM(E349:E351),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E349:E351)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 502101","Câblage et dispositif de filerie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 502102","Appareils d'éclairage du bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5031","SYSTÈME DE DÉTECTION ET D'ALARME INCENDIE",null,null,null,null,{"$f":"IF(SUM(E353:E360)>0,SUM(E353:E360),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E353:E360)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5031","Système de détection et d'alarme incendie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503101","Réseau de détection, supervision",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503102","Stations manuelles d'alarme-incendie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503103","Avertisseurs sonores et visuels",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503104","Système de communication d'urgence des pompiers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5032","SYSTÈME DE COMMUNICATION ET AUTRES (INTÉRIEUR ET EXTÉRIEUR)",null,null,null,null,{"$f":"IF(SUM(E362:E369)>0,SUM(E362:E369),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E362:E369)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(X361>0,E361*X361,\"\")","v":""},null,{"$f":"IF(Z361>0,E361*Z361,\"\")","v":""},null,"",null,{"$f":"IF(AD361>0,E361*AD361,\"\")","v":""},null,{"$f":"IF(AF361>0,SUM(P361)*AF361,\"\")","v":""},null,{"$f":"IF(AH361>0,SUM(E361)*AH361,\"\")","v":""}]
["D 503201","Interphone et système d'appels visiteurs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E362:N362)>0,E362+SUM(L362:N362),\"\")","v":""},null,null,null,{"$f":"IF(E362+SUM(L362:N362)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503202","Distribution téléphonique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503203","Distribution du signal de télévision",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB364>0,SUM(L364:N364)+E364*AB364,\"\")","v":""},null,"",null,"",null,""]
["D 503204","Système de caméras de visiteurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503205","Système d'alarme intrusion",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503206","Système d'appels de soutien médical",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 503207","Antennes de réception (télé, communication, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5091","INDICATEURS DE SORTIE, ÉCLAIRAGE D'URGENCE SUR BATTERIES",null,null,null,null,{"$f":"IF(SUM(E371:E373)>0,SUM(E371:E373),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E371:E373)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 509101","Indicateurs de sortie d'urgence",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 509102","Éclairage d'urgence sur batteries",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 5092","GÉNÉRATRICE D'URGENCE",null,null,null,null,{"$f":"IF(SUM(E375:E377)>0,SUM(E375:E377),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E375:E377)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 509201","Génératrice",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["D 509202","Réservoir de combustible",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["E","ÉQUIPEMENTS ET AMEUBLEMENTS (aire commune)",null,null,null,null,{"$f":"IF(SUM(E381:E388)>0,G379/$E$604,\"\")","v":""},{"$f":"G378","v":""},null,null,null,{"$f":"IF(SUM(L381:L388)>0,L379/L604,\"\")","v":""},{"$f":"IF(SUM(M381:M388)>0,M379/M604,\"\")","v":""},{"$f":"IF(SUM(N381:N388)>0,N379/N604,\"\")","v":""},null,{"$f":"IF(SUM(G379)+SUM(L379:N379)>0,P379/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E381:E388)+SUM(L381:N388)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W381:W388)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y381:Y388)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA381:AA388)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC381:AC388)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE381:AE388)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG381:AG388)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E381:E388)>0,SUM(E381:E388),\"\")","v":""},null,{"$f":"G379","v":""},null,null,{"$f":"IF(SUM(L381:L388)>0,SUM(L381:L388),\"\")","v":""},{"$f":"IF(SUM(M381:M388)>0,SUM(M381:M388),\"\")","v":""},{"$f":"IF(SUM(N381:N388)>0,SUM(N381:N388),\"\")","v":""},null,{"$f":"IF(SUM(G379)+SUM(L379:N379)>0,SUM(E381:E388)+SUM(L381:N388),\"\")","v":""},null,{"$f":"IF(COUNTA(R381:R388)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E381:E388)+SUM(L381:N388)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E381:E388)+SUM(L381:N388)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E381)>0,SUM(E381),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E381:N381)>0,E381+SUM(L381:N381),\"\")","v":""},null,null,null,{"$f":"IF(E381+SUM(L381:N381)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E382)>0,SUM(E382),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["E 10","ÉQUIPEMENTS",null,null,null,null,{"$f":"IF(SUM(E384:E388)>0,SUM(E384:E388),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E384:E388)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["E 1011","Équipement de buanderie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["E 1091","Équipement de services alimentaires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["E 1092","Équipement d'entretien et autres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["E 2011","Ameublement et décoration (fixes et mobiles)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F","CONSTRUCTION SPÉCIALE ET DÉMOLITION",null,null,null,null,{"$f":"IF(SUM(E392:E405)>0,G390/$E$604,\"\")","v":""},{"$f":"G389","v":""},null,null,null,{"$f":"IF(SUM(L392:L405)>0,L390/L604,\"\")","v":""},{"$f":"IF(SUM(M392:M405)>0,M390/M604,\"\")","v":""},{"$f":"IF(SUM(N392:N405)>0,N390/N604,\"\")","v":""},null,{"$f":"IF(SUM(G390)+SUM(L390:N390)>0,P390/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E392:E405)+SUM(L392:N405)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W392:W405)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y392:Y405)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA392:AA405)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC392:AC405)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE392:AE405)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG392:AG405)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E392:E405)>0,SUM(E392:E405),\"\")","v":""},null,{"$f":"G390","v":""},null,null,{"$f":"IF(SUM(L392:L405)>0,SUM(L392:L405),\"\")","v":""},{"$f":"IF(SUM(M392:M405)>0,SUM(M392:M405),\"\")","v":""},{"$f":"IF(SUM(N392:N405)>0,SUM(N392:N405),\"\")","v":""},null,{"$f":"IF(SUM(G390)+SUM(L390:N390)>0,SUM(E392:E405)+SUM(L392:N405),\"\")","v":""},null,{"$f":"IF(COUNTA(R392:R405)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E392:E405)+SUM(L392:N405)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E392:E405)+SUM(L392:N405)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E392)>0,SUM(E392),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E392:N392)>0,E392+SUM(L392:N392),\"\")","v":""},null,null,null,{"$f":"IF(E392+SUM(L392:N392)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E393)>0,SUM(E393),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F10","CONSTRUCTION SPÉCIALE",null,null,null,null,{"$f":"IF(SUM(E395:E400)>0,SUM(E395:E400),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E395:E400)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 1010","Structure spéciale",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 1020","Sous-ensembles intégrés",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 1030","Système spécial de construction",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 1040","Installation spéciale",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 1050","Instrumentation et régulation spéciale",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F20","DÉMOLITION SÉLECTIVE DU BÂTIMENT",null,null,null,null,{"$f":"IF(SUM(E402:E405)>0,SUM(E402:E405),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E402:E405)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 2010","Démantèlement d'éléments de bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["F 2020","Élimination de produits dangereux (amiante, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q","AMÉNAGEMENT DU SITE",null,null,null,null,{"$f":"IF(SUM(E409:E495)>0,G407/$E$604,\"\")","v":""},{"$f":"G406","v":""},null,null,null,{"$f":"IF(SUM(L409:L495)>0,L407/L604,\"\")","v":""},{"$f":"IF(SUM(M409:M495)>0,M407/M604,\"\")","v":""},{"$f":"IF(SUM(N409:N495)>0,N407/N604,\"\")","v":""},null,{"$f":"IF(SUM(G407)+SUM(L407:N407)>0,P407/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E409:E495)+SUM(L409:N495)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W409:W495)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y409:Y495)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA409:AA495)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC409:AC495)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE409:AE495)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG409:AG495)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E409:E495)>0,SUM(E409:E495),\"\")","v":""},null,{"$f":"G407","v":""},null,null,{"$f":"IF(SUM(L409:L495)>0,SUM(L409:L495),\"\")","v":""},{"$f":"IF(SUM(M409:M495)>0,SUM(M409:M495),\"\")","v":""},"",null,{"$f":"IF(SUM(G407)+SUM(L407:N407)>0,SUM(E409:E495)+SUM(L409:N495),\"\")","v":""},null,{"$f":"IF(COUNTA(R409:R495)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E409:E495)+SUM(L409:N495)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E409:E495)+SUM(L409:N495)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E409)>0,SUM(E409),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E409:N409)>0,E409+SUM(L409:N409),\"\")","v":""},null,null,null,{"$f":"IF(E409+SUM(L409:N409)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E410)>0,SUM(E410),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2021","AIRES DE STATIONNEMENT ET ACCÈS",null,null,null,null,{"$f":"IF(SUM(E412:E420)>0,SUM(E412:E420),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E412:E420)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 2021","Aires de stationnement et accès","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 202101","Revêtements et infrastructure",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 202102","Bordures, butoirs et dos-d'âne",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 202103","Glissières de sécurité et commandes d'accès",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 202104","Lignes de peinture et marquage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 202105","Signalisation",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2031","AIRES DE CIRCULATION PIÉTONNIÈRE",null,null,null,null,{"$f":"IF(SUM(E422:E427)>0,SUM(E422:E427),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E422:E427)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 2031","Aires de circulation piétonnière","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 203101","Revêtements et bordures des surfaces piétonnières",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 203102","Infrastructure des surfaces piétonnières",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X424>0,E424*X424,\"\")","v":""},null,{"$f":"IF(Z424>0,E424*Z424,\"\")","v":""},null,"",null,{"$f":"IF(AD424>0,E424*AD424,\"\")","v":""},null,{"$f":"IF(AF424>0,SUM(P424)*AF424,\"\")","v":""},null,{"$f":"IF(AH424>0,SUM(E424)*AH424,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB427>0,SUM(L427:N427)+E427*AB427,\"\")","v":""},null,"",null,"",null,""]
["G/Q 2032","ESCALIERS ET RAMPES EXTÉRIEURS",null,null,null,null,{"$f":"IF(SUM(E429:E432)>0,SUM(E429:E432),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E429:E432)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 203201","Marches et revêtements des escaliers et rampes extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 203202","Balustrade et mains courantes des escaliers et rampes ext.",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 203203","Infrastructure des escaliers et rampes extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2041","TERRASSES ET DALLES EXTÉRIEURES",null,null,null,null,{"$f":"IF(SUM(E434:E437)>0,SUM(E434:E437),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E434:E437)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 2041","Terrasses et dalles extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204101","Revêtements des terrasses extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204102","Infrastructure des terrasses extérieures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2042","MURS DE SOUTÈNEMENT, TALUS EN PIERRE, ETC.",null,null,null,null,{"$f":"IF(SUM(E439:E443)>0,SUM(E439:E443),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E439:E443)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204201","Construction des murs de soutènement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204202","Infrastructure des murs de soutènement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204203","Garde-corps aux murs de soutènement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204204","Margelles, murets, etc.",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2043","REMISES ET AUTRES CONSTRUCTIONS",null,null,null,null,{"$f":"IF(SUM(E445:E449)>0,SUM(E445:E449),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E445:E449)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204301","Remises pour locataires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204302","Remises pour entretien",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204303","Conteneurs à déchets {construction)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204304","Ajouts au bâtiment",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 2044","AUTRES AMÉNAGEMENTS DU SITE ET AMÉNAGEMENT PAYSAGER",null,null,null,null,{"$f":"IF(SUM(E451:E459)>0,SUM(E451:E459),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E451:E459)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204401","Murets décoratifs et boîtes à fleurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204402","Écrans, clôtures et barrières",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204403","Surfaces gazonnées",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204404","Arbres, arbustes et plates-bandes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204405","Peinture métaux ouvrés, équipements méc. et élect.",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204406","Peinture, teinture et traitement clôtures",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204407","Peinture et traitement du béton, dallage, asphalte",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 204408","Décontamination du site",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 3011","ALIMENTATION MUNICIPALE EN EAU",null,null,null,null,{"$f":"IF(SUM(E461:E462)>0,SUM(E461:E462),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E461:E462)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 3011","Alimentation municipale en eau",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 3012","ALIMENTATION EN EAU (puits artésien)",null,null,null,null,{"$f":"IF(SUM(E464:E467)>0,SUM(E464:E467),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E464:E467)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 3012","Alimentation en eau (puits artésien)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 301201","Canalisation d'alimentation en eau potable et valves",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 301202","Puits artésien ou de surface",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 3021","ÉGOUT SANITAIRE MUNICIPAL",null,null,null,null,{"$f":"IF(SUM(E469:E471)>0,SUM(E469:E471),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E469:E471)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 302101","Réseau d'égout ou combiné",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 302102","Regards de nettoyage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 3022","ÉGOUT SANITAIRE (TRAITEMENT)",null,null,null,null,{"$f":"IF(SUM(E473:E476)>0,SUM(E473:E476),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E473:E476)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 302201","Unité d'absorption des eaux usées",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E473:N473)>0,E473+SUM(L473:N473),\"\")","v":""},null,null,null,{"$f":"IF(E473+SUM(L473:N473)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 302202","Unité de traitement (fosse ou autonome)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 302203","Réseau de canalisation",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 3031","ÉGOUT PLUVIAL",null,null,null,null,{"$f":"IF(SUM(E478:E482)>0,SUM(E478:E482),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E478:E482)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 303101","Réseau d'égout pluvial, regards, réducteurs de débit",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 303102","Puisards de drainage du site",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 303103","Caniveau de drainage d'entrée de garage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 303104","Bassins de captation et fossés",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 4011","DISTRIBUTION ÉLECTRIQUE ET ÉCLAIRAGE",null,null,null,null,{"$f":"IF(SUM(E484:E492)>0,SUM(E484:E492),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E484:E492)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 401101","Réseau d'alimentation et de distribution électrique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 401102","Réseau de conduits pour système de communication",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 401103","Prises chauffe-moteurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 401104","Appareils d'éclairage muraux des aménagements",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 401105","Poteaux, lampadaires, canalisation de l'éclairage extérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X488>0,E488*X488,\"\")","v":""},null,{"$f":"IF(Z488>0,E488*Z488,\"\")","v":""},null,"",null,{"$f":"IF(AD488>0,E488*AD488,\"\")","v":""},null,{"$f":"IF(AF488>0,SUM(P488)*AF488,\"\")","v":""},null,{"$f":"IF(AH488>0,SUM(E488)*AH488,\"\")","v":""}]
["G 401106","Contrôle de l'éclairage extérieur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,{"$f":"IF(AB491>0,SUM(L491:N491)+E491*AB491,\"\")","v":""},null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["G/Q 9011","TUNNELS DE SERVICE ET POUR PIÉTONS",null,null,null,null,{"$f":"IF(SUM(E494:E495)>0,SUM(E494:E495),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E494:E495)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["G 9011","Tunnels de service et pour piétons",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H","LOGEMENT",null,null,null,null,{"$f":"IF(SUM(E499:E601)>0,G497/$E$604,\"\")","v":""},{"$f":"G496","v":""},null,null,null,{"$f":"IF(SUM(L499:L601)>0,L497/L604,\"\")","v":""},{"$f":"IF(SUM(M499:M601)>0,M497/M604,\"\")","v":""},{"$f":"IF(SUM(N499:N601)>0,N497/N604,\"\")","v":""},null,{"$f":"IF(SUM(G497)+SUM(L497:N497)>0,P497/P$604,\"\")","v":""},null,null,null,{"$f":"IF(SUM(E499:E601)+SUM(L499:N601)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,{"$f":"IF(SUM(W499:W601)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(Y499:Y601)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AA499:AA601)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AC499:AC601)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AE499:AE601)>0,\"X\",\"\")","v":""},null,{"$f":"IF(SUM(AG499:AG601)>0,\"X\",\"\")","v":""}]
[null,null,null,null,null,null,{"$f":"IF(SUM(E499:E601)>0,SUM(E499:E601),\"\")","v":""},null,{"$f":"G497","v":""},null,null,{"$f":"IF(SUM(L499:L601)>0,SUM(L499:L601),\"\")","v":""},{"$f":"IF(SUM(M499:M601)>0,SUM(M499:M601),\"\")","v":""},"",null,{"$f":"IF(SUM(G497)+SUM(L497:N497)>0,SUM(E499:E601)+SUM(L499:N601),\"\")","v":""},null,{"$f":"IF(COUNTA(R499:R601)>0,\"x\",\"\")","v":""},null,{"$f":"IF(SUM(E499:E601)+SUM(L499:N601)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E499:E601)+SUM(L499:N601)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E499)>0,SUM(E499),\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E499:N499)>0,E499+SUM(L499:N499),\"\")","v":""},null,null,null,{"$f":"IF(E499+SUM(L499:N499)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,{"$f":"IF(SUM(E500)>0,SUM(E500),\"\")","v":""},null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1011","SALLE DE BAIN (RÉFECTION)",null,null,null,null,{"$f":"IF(SUM(E502:E518)>0,SUM(E502:E518),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E502:E518)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1011","Salle de bain (réfection)","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101101","Alcôve du bain (finition murs, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101102","Lavabo",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101103","Toilette",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101104","Ventilation, conduits et commandes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101105","Éclairage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101106","Accessoires (pharmacie, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101107","Bain",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101108","Robinetterie de bain",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101109","Robinetterie de lavabo",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101110","Vanité de lavabo",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101111","Plancher",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101112","Chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 101113","Drain, siphon",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1021","CUISINE (RÉFECTION)",null,null,null,null,{"$f":"IF(SUM(E520:E532)>0,SUM(E520:E532),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E520:E532)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1021","Cuisine (réfection)","Âge:  ?? ans",null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102101","Armoires",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102102","Évier",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102103","Hotte de cuisinière et conduits",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102104","Comptoir",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102105","Drain, siphon",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102106","Cuisinière",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102107","Réfrigérateur",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102108","Appareil d'éclairage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 102109","Robinetterie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1031","PORTES INTÉRIEURES DU LOGEMENT",null,null,null,null,{"$f":"IF(SUM(E534:E538)>0,SUM(E534:E538),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E534:E538)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 103101","Portes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 103102","Quincaillerie",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 103103","Cadres",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 103104","Portes et cadres (garde-robes)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1041","FINIS DE PLANCHERS DU LOGEMENT",null,null,null,null,{"$f":"IF(SUM(E540:E546)>0,SUM(E540:E546),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E540:E546)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 104101","Finis de planchers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 104102","Finis des marches, contre-marches et paliers",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 104103","Finis des rampes pour personnes handicapées",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 104104","Nez de marche et palier",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1051","PLOMBERIE",null,null,null,null,{"$f":"IF(SUM(E548:E554)>0,SUM(E548:E554),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E548:E554)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 105101","Distribution d'eau domestique du logement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 105102","Valve d'arrêt d'eau",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 105103","Réseau des eaux usées du logement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 105104","Chauffe-eau",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X552>0,E552*X552,\"\")","v":""},null,{"$f":"IF(Z552>0,E552*Z552,\"\")","v":""},null,"",null,{"$f":"IF(AD552>0,E552*AD552,\"\")","v":""},null,{"$f":"IF(AF552>0,SUM(P552)*AF552,\"\")","v":""},null,{"$f":"IF(AH552>0,SUM(E552)*AH552,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1061","ÉLECTRICITÉ (DISTRIBUTION ET COMMUNICATION)",null,null,null,null,{"$f":"IF(SUM(E556:E569)>0,SUM(E556:E569),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E556:E569)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,{"$f":"IF(AB555>0,SUM(L555:N555)+E555*AB555,\"\")","v":""},null,"",null,"",null,""]
["H 1061","Électricité (distribution et communication)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106101","Panneau de distribution du logement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106102","Appareils d'éclairage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106103","Prises électriques",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106104","Prise du chauffage d'urgence",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106105","Avertisseurs de fumée autonomes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106106","Distribution télécommunication (télévision, téléphone, etc.)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106107","Interrupteurs",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E563:N563)>0,E563+SUM(L563:N563),\"\")","v":""},null,null,null,{"$f":"IF(E563+SUM(L563:N563)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106108","Distribution électrique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106109","Chauffage électrique",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 106110","Détecteurs thermiques reliés au système d'alarme",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1071","AUTRES COMPOSANTS DU LOGEMENT",null,null,null,null,{"$f":"IF(SUM(E571:E580)>0,SUM(E571:E580),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E571:E580)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1071","Autres composants du logement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107101","Autres armoires et comptoirs du logement",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107102","Tablettes, pôles, fixations et autres boiseries",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107103","Mains courantes et balustrades",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107104","Construction des escaliers, paliers et rampes",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107105","Sécheuse et conduits ",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107106","Échangeur d'air et conduits",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1072","MURS",null,null,null,null,{"$f":"IF(SUM(E582:E588)>0,SUM(E582:E588),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E582:E588)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107201","Peinture",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107203","Murs extérieurs",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107204","Cloisonnements coupe-feu",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107205","Autres cloisonnements (construction et revêtements)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1073","PLAFONDS",null,null,null,null,{"$f":"IF(SUM(E590:E597)>0,SUM(E590:E597),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E590:E597)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107301","Peinture",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107303","Plafonds aux toits",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107304","Plafonds coupe-feu",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107305","Autres plafonds",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107306","Plafonds suspendus (construction et revêtements)",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 1074","SYSTÈME DE CHAUFFAGE (EAU CHAUDE, AIR PULSÉ)",null,null,null,null,{"$f":"IF(SUM(E599:E601)>0,SUM(E599:E601),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(E599:E601)>0,\"X\",\"VIDE\")","v":"VIDE"},null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107401","Système (chaudière, cheminée, contrôle}",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
["H 107302","Système de distribution de chauffage",null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"VIDE",null,null,{"$f":"IF(X601>0,E601*X601,\"\")","v":0},1,{"$f":"IF(Z601>0,E601*Z601,\"\")","v":""},null,{"$f":"IF(AB601>0,SUM(L601:N601)+E601*AB601,\"\")","v":""},null,{"$f":"IF(AD601>0,E601*AD601,\"\")","v":""},null,{"$f":"IF(AF601>0,SUM(P601)*AF601,\"\")","v":""},null,{"$f":"IF(AH601>0,SUM(E601)*AH601,\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urgence (phase analysée)","%","M. aux N. (phase analysée)","%","M. aux N. projet total","%","Dépréciation (phase analysée)","%","Dépréciation projet total  ","%",{"$f":"SUM(AG37:AG601)","v":0},"%","COUPURES de TRAVAUX (phase analysée)"]
[null,null,null,null,{"$f":"SUM(I37:I497)","v":0},null,"Check Formules",null,null,null,null,{"$f":"SUM(H37:H497)","v":0}]
["Justifications",null,"SOUS-TOTAL - 1 :   ",null,{"$f":"SUM(E40:E601)","v":0},null,"%",null,null,null,null,{"$f":"SUM(L38,L67,L163,L231,L379,L390,L407,L497)","v":0},{"$f":"SUM(M38,M67,M163,M231,M379,M390,M407,M497)","v":0},{"$f":"SUM(N38,N67,N163,N231,N379,N390,N407,N497)","v":0},null,{"$f":"IF(E604+SUM(L604:N605)>0,SUM(P38,P67,P163,P231,P379,P390,P407,P497),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"SOUS-TOTAL - 1 (moins $ coupures )  "]
[]
[]
[null,null,"Exigences générales (condition de chantier, ect.)",null,{"$f":"IF(G607>0,(E604*G607),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E607,L607,M607,N607)","v":0},null,null,null,null,null,null,{"$f":"SUM(W40:W601)","v":0},null,{"$f":"SUM(Y40:Y601)","v":0},null,{"$f":"SUM(AA40:AA601)","v":0},null,{"$f":"SUM(AC40:AC601)","v":0},null,{"$f":"SUM(AE40:AE601)","v":0},null,{"$f":"IF(AH607>0,(AG602*AH607),\"\")","v":""},{"$f":"G607","v":0},"Exigences générales (condition de chantier, ect.)"]
[null,null,"Autres (protection, équipement) Préciser ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E608,L608,M608,N608)","v":0},null,null,null,null,null,null,{"$f":"$W$607/$E$604","v":{"$error":"#DIV/0!"}},null,{"$f":"Y607/E604","v":{"$error":"#DIV/0!"}},null,{"$f":"AA607/P604","v":{"$error":"#VALUE!"}},null,{"$f":"AC607/E604","v":{"$error":"#DIV/0!"}},null,{"$f":"AE607/P604","v":{"$error":"#VALUE!"}},null,null,null,"Autres (protection, équipement) "]
[]
[null,null,"SOUS-TOTAL - 2 :",null,{"$f":"SUM(E604:E608)","v":0},null,null,null,null,null,null,{"$f":"SUM(L604:L608)","v":0},{"$f":"SUM(M604:M608)","v":0},{"$f":"SUM(N604:N608)","v":0},null,{"$f":"IF(E610+SUM(L610:N611)>0,SUM(P604:P608),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG602:AG608)","v":0},null,"SOUS-TOTAL - 2 "]
[]
[]
[null,null,"Contingence d’estimation ",null,{"$f":"IF(G613>0,(E610*G613),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E613,L613,M613,N613)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH613>0,(AG610*AH613),\"\")","v":""},{"$f":"G613","v":0},"Contingence d’estimation "]
[null,null,"Contingence de design ",null,{"$f":"IF(G614>0,(E610*G614),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E614,L614,M614,N614)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH614>0,(AG610*AH614),\"\")","v":""},{"$f":"G614","v":0},"Contingence de design "]
[null,null,"Contingence de chantier",null,{"$f":"IF(G615>0,(E610*G615),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E615,L615,M615,N615)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH615>0,(AG610*AH615),\"\")","v":""},{"$f":"G615","v":0},"Contingence de chantier"]
[null,null,"Autres (bâtiment occupé, etc.) Préciser  ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E616,L616,M616,N616)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres (bâtiment occupé, etc.) "]
[]
["Pondération régionale - Choix",null,"SOUS-TOTAL - 3 :",null,{"$f":"SUM(E610:E616)","v":0},null,null,null,null,null,null,{"$f":"SUM(L610:L616)","v":0},{"$f":"SUM(M610:M616)","v":0},{"$f":"SUM(N610:N616)","v":0},null,{"$f":"IF(E618+SUM(L618:N619)>0,SUM(P610:P616),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG610:AG616)","v":0},null,"SOUS-TOTAL - 3"]
[null,null,null,null,null,null,"TAUX"]
["Attention de ne pas dédoubler les coûts si le taux est déjà inclus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Taux"]
["N / A : Déjà inclus dans \"Coût unitaire\"",null,"Pondération régionale (si non-inclus)",null,{"$f":"IF(G621>0,((E618*G621)-E618),\"\")","v":0},null,{"$f":"VLOOKUP($A$621,X666:AG695,10,FALSE)","v":1},null,null,null,null,null,null,null,null,{"$f":"SUM(E621,L621,M621,N621)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH621>0,(AG618*AH621),\"\")","v":0},{"$f":"G621","v":1},"Pondération régionale "]
[]
[null,null,"SOUS-TOTAL - 4 : ",null,{"$f":"SUM(E618:E621)","v":0},null,null,null,null,null,null,{"$f":"SUM(L618:L621)","v":0},{"$f":"SUM(M618:M621)","v":0},{"$f":"SUM(N618:N621)","v":0},null,{"$f":"IF(E623+SUM(L623:N624)>0,SUM(P618:P621),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG618:AG621)","v":0},null,"SOUS-TOTAL - 4 "]
[]
[]
[null,null,"Administration / Profit (entrepreneur)",null,{"$f":"IF(G626>0,(E623*G626),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E626,L626,M626,N626)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AH626>0,(AG623*AH626),\"\")","v":""},{"$f":"G626","v":0},"Administration / Profit (entrepreneur)"]
[]
[null,null,"SOUS-TOTAL - 5 :",null,{"$f":"SUM(E623:E626)","v":0},null,null,null,null,null,null,{"$f":"SUM(L623:L626)","v":0},{"$f":"SUM(M623:M626)","v":0},{"$f":"SUM(N623:N626)","v":0},null,{"$f":"IF(E628+SUM(L628:N629)>0,SUM(P623:P626),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG623:AG626)","v":0},null,"SOUS-TOTAL - 5"]
[]
[]
[null,null,"Taxe TPS",null,{"$f":"$E$628*0.05","v":0},null,null,null,null,null,null,{"$f":"$L$628*0.05","v":0},{"$f":"$M$628*0.05","v":0},{"$f":"$N$628*0.05","v":0},null,{"$f":"SUM(E631,L631,M631,N631)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AG628*0.05","v":0},null,"Taxe TPS"]
[null,null,"Taxe TVQ",null,{"$f":"$E$628*0.09975","v":0},null,null,null,null,null,null,{"$f":"$L$628*0.09975","v":0},{"$f":"$M$628*0.09975","v":0},{"$f":"$N$628*0.09975","v":0},null,{"$f":"SUM(E632,L632,M632,N632)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$AG628*0.09975","v":0},null,"Taxe TVQ"]
[]
["Justifications",null,"TOTAL Travaux (ttc) : ",null,null,null,{"$f":"SUM(E628:E632)","v":0},null,null,null,null,{"$f":"SUM(L628:L632)","v":0},{"$f":"SUM(M628:M632)","v":0},{"$f":"SUM(N628:N632)","v":0},null,{"$f":"SUM(P628:P632)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG628:AG632)","v":0},null,"TOTAL Travaux (ttc) "]
[]
[null,null,"Honoraires professionnels",null,null,null,"%",null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"%","Honoraires professionnels"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inclus"]
[]
[null,null,"Honoraires professionnels architecture",null,null,null,{"$f":"IF(E639>0,E639/$G$634,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(E639+SUM(L639:N639)>0,E639+SUM(L639:N639),\"\")","v":""},null,{"$f":"IF(E639>0,P639/$P$634,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E639>0,(AH639*E639),\"\")","v":""},null,"Honoraires professionnels architecture"]
[null,null,"Honoraires professionnels structure",null,null,null,{"$f":"IF(E640>0,E640/$G$634,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(E640+SUM(L640:N640)>0,E640+SUM(L640:N640),\"\")","v":""},null,{"$f":"IF(E640>0,P640/$P$634,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E640>0,(AH640*E640),\"\")","v":""},null,"Honoraires professionnels structure"]
[null,null,"Honoraires professionnels mécanique",null,null,null,{"$f":"IF(E641>0,E641/$G$634,\"\")","v":""},null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Honoraires professionnels mécanique"]
[null,null,"Honoraires professionnels civil",null,null,null,{"$f":"IF(E642>0,E642/$G$634,\"\")","v":""},null,null,null,null,null,null,null,null,{"$f":"IF(E642+SUM(L642:N642)>0,E642+SUM(L642:N642),\"\")","v":""},null,{"$f":"IF(E642>0,P642/$P$634,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(E642>0,(AH642*E642),\"\")","v":""},null,"Honoraires professionnels civil"]
[null,null,"Surveillance de chantier",null,null,null,{"$f":"IF(E643>0,E643/$G$634,\"\")","v":""},null,null,null,null,null,null,null,null,"",null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Surveillance de chantier"]
[]
[null,null,"TOTAL Honoraires professionnels",null,{"$f":"SUM(E639:E643)","v":0},null,{"$f":"IF(E645>0,E645/$G$634,\"\")","v":""},null,null,null,null,{"$f":"SUM(L639:L643)","v":0},{"$f":"SUM(M639:M643)","v":0},{"$f":"SUM(N639:N643)","v":0},null,{"$f":"SUM(P639:P643)","v":0},null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG639:AG643)","v":0},null,"TOTAL Honoraires professionnels"]
[]
[null,null,"Taxe TPS",null,{"$f":"$E$645*0.05","v":0},null,null,null,null,null,null,{"$f":"$L$645*0.05","v":0},{"$f":"$M$645*0.05","v":0},{"$f":"$N$645*0.05","v":0},null,{"$f":"$P$645*0.05","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG645*0.05","v":0},null,"Taxe TPS"]
[null,null,"Taxe TVQ",null,{"$f":"$E$645*0.09975","v":0},null,null,null,null,null,null,{"$f":"$L$645*0.09975","v":0},{"$f":"$M$645*0.09975","v":0},{"$f":"$N$645*0.09975","v":0},null,{"$f":"$P$645*0.09975","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AG645*0.09975","v":0},null,"Taxe TVQ"]
[]
["Justifications",null,"TOTAL Honoraires professionnels (ttc) :",null,null,null,{"$f":"SUM(E645:E648)","v":0},null,null,null,null,{"$f":"SUM(L645:L648)","v":0},{"$f":"SUM(M645:M648)","v":0},{"$f":"SUM(N645:N648)","v":0},null,{"$f":"SUM(P645:P648)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AG645:AG648)","v":0},null,"TOTAL Honoraires professionnels (ttc)"]
[]
[null,null,"Autres frais",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres frais"]
[]
[]
[null,null,"Relogement des locataires ",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G655+SUM(L655:N655)>0,G655+SUM(L655:N655),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Relocalisation des locataires "]
[]
[null,null,"Autres frais Préciser",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G657+SUM(L657:N657)>0,G657+SUM(L657:N657),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Autres frais "]
[]
[null,null,"PROJET (ttc) :",null,null,null,{"$f":"$G$634+$G$650+SUM(G655:G657)","v":0},null,null,null,null,{"$f":"L634+L650+SUM(L655:L657)","v":0},{"$f":"M634+M650+SUM(M655:M657)","v":0},0,null,{"$f":"P634+P650+SUM(P655:P657)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AG602>0,SUM(AG634+AG650+SUM(AG655:AG657)),\"\")","v":""},null,"PROJET Coupé (ttc)"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Facteurs de pondération régionaux (FR) - janvier 2023"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"RÉGION ADMINISTRATIVE",null,null,null,null,null,null,null,null,"FACTEUR"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N / A : Déjà inclus dans \"Coût unitaire\"",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-Bas-Saint-Laurent",null,null,null,null,null,null,null,null,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1-Bas-Saint-Laurent (secteurs de Matane et de la vallée de la Matapédia)",null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2-Saguenay‒Lac-Saint-Jean",null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3-Capitale-Nationale",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Mauricie",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Mauricie (secteur de La Tuque)",null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4-Mauricie (secteur de la Haute-Mauricie)",null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5-Estrie",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6-Montréal",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7-Outaouais",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7-Outaouais (secteurs de Maniwaki et de la Haute-Gatineau)",null,null,null,null,null,null,null,null,1.1000000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8-Abitibi-Témiscamingue",null,null,null,null,null,null,null,null,1.1499999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord",null,null,null,null,null,null,null,null,1.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord (secteur de Tadoussac à Forestville)",null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord (secteur de Baie-Comeau)",null,null,null,null,null,null,null,null,1.35]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord (secteur de Havre-St-Pierre)",null,null,null,null,null,null,null,null,1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord (Fermont)",null,null,null,null,null,null,null,null,1.85]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9-Côte-Nord (sans accès routier)",null,null,null,null,null,null,null,null,3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-Nord-du-Québec",null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10-Nord-du-Québec (Nunavik)",null,null,null,null,null,null,null,null,4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Gaspésie‒Îles-de-la-Madeleine",null,null,null,null,null,null,null,null,1.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Gaspésie‒Îles-de-la-Madeleine (secteur de Gaspé)",null,null,null,null,null,null,null,null,1.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11-Gaspésie‒Îles-de-la-Madeleine (Îles-de-la-Madeleine)",null,null,null,null,null,null,null,null,1.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12-Chaudière-Appalaches",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13-Laval",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14-Lanaudière",null,null,null,null,null,null,null,null,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15-Laurentides",null,null,null,null,null,null,null,null,1.05]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16-Montérégie",null,null,null,null,null,null,null,null,1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17-Centre-du-Québec",null,null,null,null,null,null,null,null,1]

{"sheet":"3-FORMULAIRE","index":2,"n_rows":50,"n_cols":16,"rows_kept":50,"cut":false,"hidden":false,"merged":[[40,11,40,15],[41,11,41,15],[42,11,42,15],[43,11,43,15],[44,11,44,15],[42,2,42,3],[42,4,42,8],[42,9,42,10],[41,2,41,3],[41,4,41,8],[41,9,41,10],[44,2,44,3],[44,4,44,8],[44,9,44,10],[40,2,40,3],[40,4,40,8],[40,9,40,10],[43,2,43,3],[43,4,43,8],[43,9,43,10],[38,11,38,15],[39,11,39,15],[39,2,39,3],[39,4,39,8],[39,9,39,10],[38,2,38,3],[30,9,30,10],[31,9,31,10],[32,9,32,10],[38,4,38,8],[38,9,38,10],[30,11,30,15],[31,11,31,15],[32,11,32,15],[33,11,33,15],[34,11,34,15],[35,11,35,15],[36,11,36,15],[37,11,37,15],[37,2,37,3],[30,4,30,8],[33,4,33,8],[34,4,34,8],[35,4,35,8],[36,4,36,8],[37,4,37,8],[36,9,36,10],[32,4,32,8],[32,2,32,3],[30,2,30,3],[31,2,31,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[36,2,36,3],[16,1,16,5],[16,6,16,7],[16,8,16,10],[16,11,16,15],[14,8,14,9],[14,6,14,7],[15,12,15,14],[17,1,17,5],[17,6,17,7],[17,8,17,10],[17,11,17,15],[13,8,13,15],[13,6,13,7],[5,13,5,15],[6,13,6,15],[10,1,10,5],[10,6,10,9],[10,10,10,15],[6,1,6,12],[37,9,37,10],[33,9,33,10],[34,9,34,10],[35,9,35,10],[15,1,15,7],[18,1,18,15],[19,1,19,15],[21,2,21,6],[11,1,11,15],[12,2,12,15],[13,1,13,3],[13,4,13,5],[14,1,14,3],[14,4,14,5],[20,1,20,15],[27,1,27,15],[2,2,2,15],[3,1,3,15],[4,1,4,15],[5,1,5,11],[7,1,7,9],[7,10,7,15],[8,1,8,9],[8,11,8,13],[9,1,9,4],[29,9,29,10],[22,1,22,5],[22,6,22,7],[22,8,22,10],[22,11,22,15],[23,1,23,5],[23,6,23,7],[23,8,23,10],[23,11,23,15],[26,1,26,15],[28,1,28,15],[25,1,25,15],[24,1,24,15],[29,11,29,15],[47,1,47,7],[47,8,47,12],[47,13,47,15],[45,1,45,15],[46,2,46,15],[50,3,50,6],[50,8,50,10],[50,13,50,15],[48,1,48,7],[48,8,48,12],[48,13,48,15]]}
[null,"FORMULAIRE – PROJET SPÉCIAL",null,null,null,null,null,null,{"$f":"'2-Estimation - Analyse'!A1","v":2026}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Description du projet"]
[null,1,"Coordonnées de l'organisme"]
[null,"Nom de l’organisme (OH, coop ou OSBL) "]
[]
[null,"Adresse (numéro, rue, municipalité) ",null,null,null,null,null,null,null,null,null,null,null,"Code postal "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"     "]
[null,"Nom du gestionnaire de projet ",null,null,null,null,null,null,null,null,"La gestion de projet est assurée par : "]
[null,null,null,null,null,null,null,null,null,null,null," centre de services",null,null,null," organisme"]
[null,"No de téléphone ",null,null,null,null,"Adresse courriel "]
[null,null,null,null,null,null,"     "]
[]
[null,2,"Renseignements sur le projet global (toutes les phases)"]
[null,"No du Ei",null,null,"Année de construction",null,"Type de bâtiment                          (multilogement, jumelé, etc.)",null,"Type de clientèle"]
[null,{"$f":"'2-Estimation - Analyse'!C6","v":"?"},null,null,"?",null,"?",null,"    Personnes âgées",null,null,"   Familles  ",null,"   Personnes seules "]
[null,"S’agit-il d’un projet qui s’échelonne sur plusieurs années ?     ",null,null,null,null,null,null,"            Oui ",null,null,"   Non","Nbre de phase :",null,null,"X phase(s)"]
[null,"Nombre d’immeubles touchés par les travaux (toutes les phases)",null,null,null,null,"Nombre total de logements dans l’ensemble immobilier",null,"Nombre de logements touchés par les travaux (toutes les phases)",null,null,"Coût «Projet (ttc)» (phase en cours + phases antérieures actualisées)"]
[null,"?",null,null,null,null,"?",null,"?",null,null,"?"]
[null,"PROJET GLOBAL : Description sommaire des travaux et des raisons qui justifient le projet dans son ensemble (toutes les phases)"]
[null,"RÉSUMÉ DU PROJET EN QUELQUES PHRASES"]
[]
[null,3,"Renseignement sur la phase : Année",null,null,null,null,{"$f":"'2-Estimation - Analyse'!A1","v":2026}]
[null,"Nombre d’immeubles touchés par les travaux (phase)",null,null,null,null,"Nombre de logements touchés par les travaux (phase)",null,"Type de bâtiment                          (multilogement, jumelé, etc.)",null,null,"Phase demandée "]
[null,{"$f":"'2-Estimation - Analyse'!B9","v":"?"},null,null,null,null,{"$f":"'2-Estimation - Analyse'!A9","v":0},null,"?",null,null,{"$f":"'2-Estimation - Analyse'!G6","v":"? de ?"}]
[null,"ADRESSE(S) DES TRAVAUX : De la phase demandée"]
[]
[null,"PHASE DEMANDÉE : Description sommaire des travaux et des raisons qui justifient la phase"]
[null,"RÉSUMÉ DE LA PHASE EN QUELQUES PHRASES"]
[null,"PORTRAIT GÉNÉRAL DE LA PHASE DEMANDÉE "]
[null,"Pourcentage des travaux avant frais, taxes et honaires professionnels (selon l'estimation)",null,null,null,null,null,null,null,"Total",null,"Notes"]
[null,"A",{"$f":"'2-Estimation - Analyse'!G37","v":""},null,"INFRASTRUCTURE",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G38","v":""}]
[null,"B",{"$f":"'2-Estimation - Analyse'!G66","v":""},null,"SUPERSTRUCTURE ET ENVELOPPE",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G67","v":""}]
[null,"C",{"$f":"'2-Estimation - Analyse'!G162","v":""},null,"AMÉNAGEMENT INTÉRIEUR (aire commune)",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G163","v":""}]
[null,"D",{"$f":"'2-Estimation - Analyse'!G230","v":""},null,"SERVICES (aire commune)",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G231","v":""}]
[null,"E",{"$f":"'2-Estimation - Analyse'!G378","v":""},null,"ÉQUIPEMENTS ET AMEUBLEMENTS (aire commune)",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G379","v":""}]
[null,"F",{"$f":"'2-Estimation - Analyse'!G389","v":""},null,"CONSTRUCTION SPÉCIALE ET DÉMOLITION",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G390","v":""}]
[null,"G",{"$f":"'2-Estimation - Analyse'!G406","v":""},null,"AMÉNAGEMENT DU SITE",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G407","v":""}]
[null,"H",{"$f":"'2-Estimation - Analyse'!G496","v":""},null,"LOGEMENT",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G497","v":""}]
[]
[null,null,{"$f":"'2-Estimation - Analyse'!G392","v":""},null,"TOTAL Travaux (ttc) y compris frais et taxes : ",null,null,null,null,{"$f":"IF('2-Estimation - Analyse'!G634>0,'2-Estimation - Analyse'!G634,\"\")","v":""}]
[null,null,{"$f":"'2-Estimation - Analyse'!G409","v":""},null,"TOTAL Honoraires professionnels (ttc) :",null,null,null,null,{"$f":"IF('2-Estimation - Analyse'!G650>0,'2-Estimation - Analyse'!G650,\"\")","v":""}]
[null,null,{"$f":"'2-Estimation - Analyse'!G410","v":""},null,"Autres frais (relogement de locataires, etc.) :",null,null,null,null,{"$f":"IF(SUM('2-Estimation - Analyse'!G655:G657)>0,SUM('2-Estimation - Analyse'!G655:G657),\"\")","v":""}]
[]
[null,null,{"$f":"'2-Estimation - Analyse'!G499","v":""},null," Montant total demandé pour la présente phase – PROJET (ttc) :",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G659","v":0}]
[null,null,null,null,"Coût par logement :",null,null,null,null,{"$f":"J44/G24","v":{"$error":"#DIV/0!"}}]
[]
[null,4,"Responsable de l’organisme"]
[null,"Nom de la personne responsable de l’organisme\n(lettres moulées)",null,null,null,null,null,null,"Signature",null,null,null,null,"Date (aaaa-mm-jj)"]
[]
[null,"N.B. : Voir l'onglet 1–AIDE pour les documents à inclure dans la demande"]

{"sheet":"SHQ-PML (usage exclusif SHQ)","index":3,"n_rows":89,"n_cols":17,"rows_kept":89,"cut":false,"hidden":false,"merged":[[86,10,86,11],[79,0,79,3],[79,5,79,6],[85,8,85,12],[75,0,75,3],[75,5,75,6],[76,0,76,3],[76,5,76,6],[78,0,78,3],[78,5,78,6],[70,5,70,6],[72,0,72,3],[73,0,73,3],[73,5,73,6],[74,0,74,3],[74,5,74,6],[67,0,67,3],[67,5,67,6],[68,0,68,3],[68,5,68,6],[69,0,69,3],[69,5,69,6],[64,0,64,3],[64,5,64,6],[65,0,65,3],[65,5,65,6],[66,0,66,3],[66,5,66,6],[59,0,59,3],[60,5,60,6],[61,0,61,3],[61,5,61,6],[62,5,62,6],[63,0,63,3],[53,5,53,6],[54,5,54,6],[55,5,55,6],[56,5,56,6],[57,5,57,6],[58,5,58,6],[47,5,47,6],[48,5,48,6],[49,0,49,3],[50,5,50,6],[51,5,51,6],[52,5,52,6],[41,0,41,3],[42,5,42,6],[43,0,43,3],[44,5,44,6],[45,5,45,6],[46,5,46,6],[37,0,37,3],[37,5,37,6],[38,0,38,3],[38,5,38,6],[39,0,39,3],[39,5,39,6],[35,5,35,6],[35,10,35,11],[36,5,36,8],[36,10,36,12],[31,0,31,3],[31,5,31,6],[33,0,33,3],[33,5,33,6],[34,0,34,3],[34,5,34,6],[28,0,28,3],[28,5,28,6],[29,0,29,3],[29,5,29,6],[30,0,30,3],[30,5,30,6],[25,0,25,3],[25,5,25,6],[26,0,26,3],[26,5,26,6],[27,0,27,3],[27,5,27,6],[21,0,21,3],[21,5,21,6],[22,0,22,3],[22,5,22,6],[23,0,23,3],[23,5,23,6],[16,5,16,8],[16,10,16,12],[17,5,17,6],[18,0,18,3],[18,5,18,6],[20,0,20,3],[20,5,20,6],[19,0,19,3],[19,5,19,6],[19,10,19,11],[12,16,14,16],[14,3,14,5],[14,8,14,12],[15,5,15,6],[7,0,7,12],[8,0,8,12],[9,0,9,12],[10,1,10,12],[12,0,12,1],[12,3,12,5],[12,8,12,12],[0,0,0,2],[4,0,4,1],[4,2,4,7],[4,8,4,10],[4,11,4,12],[5,0,5,12],[6,0,6,12],[1,0,1,12],[2,1,2,12],[3,2,3,3],[3,4,3,7],[3,8,3,10],[3,11,3,12]]}
[{"$f":"'2-Estimation - Analyse'!A1:B1","v":2026},null,null,"- Calcul PML du projet"]
[]
[1,"Renseignements sur l’immeuble"]
["Nº d'ensemble immobilier",{"$f":"'2-Estimation - Analyse'!C6","v":"?"},"Date de fin d'entente",null,{"$f":"'2-Estimation - Analyse'!P6","v":"20XX-XX-XX"},null,null,null,"Nb. de logement touchés (phase demandée)",null,null,{"$f":"'2-Estimation - Analyse'!A9","v":0}]
["Adresse (ou no. d'immeuble) : ",null,{"$f":"'2-Estimation - Analyse'!D5","v":"Nom du Ei: ?"},null,null,null,null,null,"Phase demandée",null,null,{"$f":"'2-Estimation - Analyse'!G6","v":"? de ?"}]
[]
[" "]
[" "]
[" "]
[]
[2,"Analyse des données de la formule PML (par logement)"]
["           "]
["Travaux prévus",null,"+","Valeur marchande",null,null,"≤",null,"PML (par logement)",null,null,null,null,null,null,null,"Commentaires"]
[]
["PML =","VAR BSI ","+","Coûts de mise aux normes",null,null,"+",null,"Coûts de relocalisation"]
[]
[null,null,null,null,null,"Phase demandée (VAR BSI)",null,null,null,null,"Projet Global (toutes les phases)"]
[]
["Travaux prévues",null,null,null,null,"/ Immeuble",null,null,"/ Logement",null,"/ Immeuble",null,"/ Logement"]
["Nb. de logement touchés (phase demandée)",null,null,null,null,null,null,null,{"$f":"'2-Estimation - Analyse'!A9","v":0},null,null,null,null,null,null,null,"Indiquer le N.B. de logement"]
["Coût total estimé (taxes, hon. prof. inclus)",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G659","v":0},null,null,{"$f":"$F$21/$L$4","v":{"$error":"#DIV/0!"}},null,{"$f":"'2-Estimation - Analyse'!P659","v":0},null,{"$f":"$K$21/$M$20","v":{"$error":"#DIV/0!"}}]
["Coût total estimé (sans taxes)",null,null,null,null,{"$f":"$F$21/1.14975","v":0},null,null,{"$f":"$F$22/$L$4","v":{"$error":"#DIV/0!"}},null,{"$f":"$K$21/1.14975","v":0},null,{"$f":"$K$22/$M$20","v":{"$error":"#DIV/0!"}}]
["Coût du projet",null,null,null,"A",{"$f":"$F$22","v":0},null,null,null,null,{"$f":"$K$22","v":0}]
["Coût du projet / logement",null,null,null,"B",null,null,null,{"$f":"$I$22","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$M$22","v":{"$error":"#DIV/0!"}}]
[]
["Valeur marchande",null,null,null,null,"/ Immeuble",null,null,"/ Logement",null,"/ Immeuble",null,"/ Logement"]
["Valeur foncière du bâtiment sans le terrain",null,null,null,null,{"$f":"'2-Estimation - Analyse'!D9","v":0},null,null,{"$f":"$F$27/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$27/$M$20","v":{"$error":"#DIV/0!"}},null,null,null,"Indiquer la valeur municipale total"]
["Décontamination de l'immeuble (amiante, moisissures ou autre)",null,null,null,null,null,null,null,{"$f":"$F$28/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$28/$M$20","v":{"$error":"#DIV/0!"}}]
["Stabilisation des fondations",null,null,null,null,null,null,null,{"$f":"$F$29/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$29/$M$20","v":{"$error":"#DIV/0!"}}]
["Décontamination de sols",null,null,null,null,null,null,null,{"$f":"$F$30/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$30/$M$20","v":{"$error":"#DIV/0!"}}]
["Valeur marchande ajustée",null,null,null,"C",{"$f":"$F$27-SUM(F28:G30)","v":0},null,null,null,null,{"$f":"$K$27-SUM(K28:K30)","v":0}]
["Valeur marchande / logement touché",null,null,null,"D",null,null,null,{"$f":"$F$31/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$31/$M$20","v":{"$error":"#DIV/0!"}}]
[]
["Coût du projet + valeur marchande ",null,null,null,"E",{"$f":"$F$23+$F$31","v":0},null,null,"(A+C)",null,{"$f":"$K$23+$K$31","v":0},null,"(A+C)"]
["(Coût du projet + valeur marchande) / logement",null,null,null,"F","(B+D)",null,null,{"$f":"$I$24+$I$32","v":{"$error":"#DIV/0!"}},null,"(B+D)",null,{"$f":"$M$24+$M$32","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,"VAR BSI",null,null,null,null,"VAR BSI"]
["Calcul de la VAR ",null,null,null,null,"/ Immeuble",null,null,"/ Logement",null,"/ Immeuble",null,"/ Logement"]
["VAR",null,null,null,"G",{"$f":"'2-Estimation - Analyse'!E9","v":0},null,null,null,null,null,null,null,null,null,null,"Indiquer la VAR BSI"]
["VAR / logement",null,null,null,"H",null,null,null,{"$f":"$F$39/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$39/$M$20","v":{"$error":"#DIV/0!"}}]
[]
["Coûts de mise aux normes contemporaines",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrer les mises aux normes"]
[null,null,null,"Mise aux normes liées à la santé et sécurité",null,null,null,null,{"$f":"F43/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"K43/$M$20","v":{"$error":"#DIV/0!"}}]
["Mise aux normes CVCA"]
[null,null,null,"Mise aux normes du système de ventilation",null,null,null,null,{"$f":"F45/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"K45/$M$20","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Mise aux normes du système électrique",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes du système de plomberie",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes de la chaufferie",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Autre mise aux normes CVCA",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Mise aux normes des infrastructures"]
[null,null,null,"Mise aux normes du vide sanitaire",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes des ascenseurs",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes des réserves et locaux techniques",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes escaliers d'issues",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes de locaux communautaires",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes de la rampe handicapée",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes de la chute à déchets",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Mise aux normes des garde-corps",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Autre mise aux normes des infrastructures",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Mise aux normes systèmes"]
[null,null,null,"Mise aux normes de la protection et alarme-incendie",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Mise aux normes de la sécurité d'accès",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
[null,null,null,"Autre mise aux normes systèmes",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Mise aux normes en efficacité énergétique"]
["Mise aux normes de l'étanchéité et isolation",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Conformité au minimum réglementaire",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Surcoûts liés à la bonification de l’efficacité énergétique",null,null,null,null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Autre mise aux normes en efficacité énergétique",null,null,"Modernisation métaux ouvrés",null,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"}]
["Coûts de mise aux normes totaux",null,null,null,"I",{"$f":"SUM(F43:F68)","v":0},null,null,null,null,{"$f":"SUM(K43:K68)","v":0}]
["Coûts de mise aux normes / logement touché",null,null,null,"J",null,null,null,{"$f":"SUM(I43:I68)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(M43:M68)","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,"% VAR",null,null,{"$f":"I70/$I$40","v":{"$error":"#DIV/0!"}},null,"% VAR",null,{"$f":"M70/$M$40","v":{"$error":"#DIV/0!"}}]
[]
["Coûts de relogement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Entrer les frais encourus "]
["Frais de déménagement et dédommagement",null,null,null,null,{"$f":"'2-Estimation - Analyse'!G655","v":0},null,null,{"$f":"$F$74/$L$4","v":{"$error":"#DIV/0!"}},null,{"$f":"'2-Estimation - Analyse'!P655","v":""},null,{"$f":"$K$74/$M$20","v":{"$error":"#VALUE!"}}]
["Perte de revenus",null,null,null,null,null,null,null,{"$f":"$F$75/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$75/$M$20","v":{"$error":"#DIV/0!"}}]
["Coûts de relogement totaux",null,null,null,"K",{"$f":"SUM(F74:F75)","v":0},null,null,null,null,{"$f":"SUM(K74:K75)","v":0}]
["Coûts de relogement / logement touché",null,null,null,"L",null,null,null,{"$f":"SUM(I74:I75)","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"SUM(M74:M75)","v":{"$error":"#VALUE!"}}]
[]
["Prix maximum de logement (PML)",null,null,null,"M",{"$f":"$F$39+$F$69+$F$76","v":0},null,null,"(G+I+K)",null,{"$f":"$K$39+$K$69+$K$76","v":0},null,"(G+I+K)"]
["Prix maximum de logement (PML) / logement",null,null,null,"N",null,null,null,{"$f":"$F$79/$L$4","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$K$79/$M$20","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"Évaluation du projet en fonction du PML"]
[null,null,null,"Coût du projet + valeur marchande  / logement","O",null,null,null,{"$f":"$I$35","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$M$35","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Prix maximum de logement (PML) / logement","P",null,null,null,{"$f":"$I$80","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"$M$80","v":{"$error":"#DIV/0!"}}]
[null,null,null," "]
[null,null,null,null,null,null,null,null,"RAM +VM /logement  ≤  PML /logement"]
["DET - 2022-05-16",null,null,null,null,null,null,null,{"$f":" IFERROR($I$83/$I$84, 0)","v":0},null,"PML %",null,{"$f":" IFERROR($M$83/$M$84, 0)","v":0}]
[null,null,null,null,null,null,null,null," ",null,null,null," "]
[null,null,null,null,null,null,null,null,{"$f":"(I24+I27)/I40","v":{"$error":"#DIV/0!"}},null,"Avant mises aux normes, dépréciations valeur marchande et relocalisation.",null,{"$f":"(M24+M27)/M40","v":{"$error":"#DIV/0!"}}]