{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuil1","liste déroulante"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Feuil1","index":0,"n_rows":89,"n_cols":16,"rows_kept":89,"cut":false,"hidden":false,"merged":[[99,0,99,1],[98,0,98,3],[103,0,103,7],[100,0,102,7],[104,0,104,3],[104,4,104,5],[104,6,104,7],[105,0,105,1],[105,2,105,3],[105,4,109,5],[105,6,109,7],[106,0,109,1],[106,2,109,3],[59,4,59,7],[60,4,60,7],[61,4,61,7],[62,4,62,7],[63,4,63,7],[64,4,64,7],[65,4,65,7],[97,0,97,3],[97,4,97,7],[93,0,96,1],[93,2,96,3],[92,4,96,5],[92,6,96,7],[90,0,90,7],[91,0,91,3],[91,4,91,5],[91,6,91,7],[66,4,66,7],[66,1,66,3],[67,4,67,7],[68,4,68,7],[69,4,69,7],[79,4,79,7],[80,4,80,7],[65,1,65,3],[55,1,55,3],[56,1,56,3],[92,0,92,1],[92,2,92,3],[62,1,62,3],[58,1,58,3],[59,1,59,3],[60,1,60,3],[61,1,61,3],[70,1,70,3],[73,1,73,3],[76,1,76,3],[79,1,79,3],[82,1,82,3],[68,1,68,3],[69,1,69,3],[80,1,80,3],[81,1,81,3],[28,1,28,3],[45,0,46,7],[48,1,48,3],[48,4,48,7],[33,0,34,7],[67,1,67,3],[49,4,49,7],[50,4,50,7],[51,4,51,7],[52,4,52,7],[53,4,53,7],[54,4,54,7],[63,1,63,3],[49,1,49,3],[50,1,50,3],[51,1,51,3],[58,4,58,7],[64,1,64,3],[53,1,53,3],[54,1,54,3],[55,4,55,7],[56,4,56,7],[57,4,57,7],[57,1,57,3],[1,1,3,6],[17,4,18,5],[17,6,18,7],[20,1,21,2],[7,1,7,3],[9,1,9,3],[13,1,13,3],[19,5,19,7],[5,0,5,3],[11,0,11,3],[10,4,10,7],[17,0,18,3],[8,4,8,7],[21,5,22,7],[15,1,15,3],[16,1,16,3],[52,1,52,3],[24,1,24,2],[35,1,35,7],[73,4,73,7],[74,1,74,3],[74,4,74,7],[75,1,75,3],[75,4,75,7],[70,4,70,7],[71,1,71,3],[71,4,71,7],[72,1,72,3],[72,4,72,7],[36,1,36,7],[38,0,38,7],[40,0,40,7],[26,4,26,7],[27,4,27,7],[28,4,28,7],[30,0,30,7],[31,0,31,1],[31,2,31,3],[26,1,26,3],[27,1,27,3],[81,4,81,7],[76,4,76,7],[77,1,77,3],[77,4,77,7],[78,1,78,3],[78,4,78,7],[88,1,88,3],[88,4,88,7],[85,1,85,3],[85,4,85,7],[86,1,86,3],[86,4,86,7],[87,1,87,3],[87,4,87,7],[82,4,82,7],[83,1,83,3],[83,4,83,7],[84,1,84,3],[84,4,84,7]]}
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"+B21","v":"lot01"}]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"OPERATION:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lot01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lot02"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"lot03"]
[null,null,null,null,"Adresse:"]
["Nom:"]
[]
["Adresse:"]
[]
[]
[]
["Lot n°:",null,null,null,"Entreprise :",{"$f":"VLOOKUP(B21,'liste déroulante'!A:F,4,FALSE)","v":"NOM1"}]
[null,"lot01"]
[null,null,null,null,"Adresse:",{"$f":"VLOOKUP(B21,'liste déroulante'!A:F,5,FALSE)","v":"ADRESSE1"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["N°","lieux",null,null,"pb"]
[{"$f":"(SUBTOTAL(3,$B50:B$50))","v":1},{"$f":"VLOOKUP($B$21,'liste déroulante'!2:2,2,FALSE)","v":"SDB"},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!2:2,3,FALSE)","v":"carrelage a reprendre"}]
[{"$f":"(SUBTOTAL(3,$B$50:B51))","v":2},{"$f":"VLOOKUP($B$21,'liste déroulante'!3:3,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!3:3,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B52))","v":3},{"$f":"VLOOKUP($B$21,'liste déroulante'!4:4,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!4:4,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B53))","v":4},{"$f":"VLOOKUP($B$21,'liste déroulante'!5:5,2,FALSE)","v":"SDB"},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!5:5,3,FALSE)","v":"lign new"}]
[{"$f":"(SUBTOTAL(3,$B$50:B54))","v":5},{"$f":"VLOOKUP($B$21,'liste déroulante'!6:6,2,FALSE)","v":"CHAMBRE"},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!6:6,3,FALSE)","v":"poser papier peint"}]
[{"$f":"(SUBTOTAL(3,$B$50:B55))","v":6},{"$f":"VLOOKUP($B$21,'liste déroulante'!7:7,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!7:7,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B56))","v":7},{"$f":"VLOOKUP($B$21,'liste déroulante'!8:8,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!8:8,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B57))","v":8},{"$f":"VLOOKUP($B$21,'liste déroulante'!9:9,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!9:9,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B58))","v":9},{"$f":"VLOOKUP($B$21,'liste déroulante'!10:10,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!10:10,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B59))","v":10},{"$f":"VLOOKUP($B$21,'liste déroulante'!11:11,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!11:11,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B60))","v":11},{"$f":"VLOOKUP($B$21,'liste déroulante'!12:12,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!12:12,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B61))","v":12},{"$f":"VLOOKUP($B$21,'liste déroulante'!13:13,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!13:13,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B62))","v":13},{"$f":"VLOOKUP($B$21,'liste déroulante'!14:14,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!14:14,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B63))","v":14},{"$f":"VLOOKUP($B$21,'liste déroulante'!15:15,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!15:15,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B64))","v":15},{"$f":"VLOOKUP($B$21,'liste déroulante'!16:16,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!16:16,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B65))","v":16},{"$f":"VLOOKUP($B$21,'liste déroulante'!17:17,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!17:17,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B66))","v":17},{"$f":"VLOOKUP($B$21,'liste déroulante'!18:18,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!18:18,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B67))","v":18},{"$f":"VLOOKUP($B$21,'liste déroulante'!19:19,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!19:19,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B68))","v":19},{"$f":"VLOOKUP($B$21,'liste déroulante'!20:20,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!20:20,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B69))","v":20},{"$f":"VLOOKUP($B$21,'liste déroulante'!21:21,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!21:21,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B70))","v":21},{"$f":"VLOOKUP($B$21,'liste déroulante'!22:22,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!22:22,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B71))","v":22},{"$f":"VLOOKUP($B$21,'liste déroulante'!23:23,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!23:23,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B72))","v":23},{"$f":"VLOOKUP($B$21,'liste déroulante'!24:24,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!24:24,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B73))","v":24},{"$f":"VLOOKUP($B$21,'liste déroulante'!25:25,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!25:25,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B74))","v":25},{"$f":"VLOOKUP($B$21,'liste déroulante'!26:26,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!26:26,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B75))","v":26},{"$f":"VLOOKUP($B$21,'liste déroulante'!27:27,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!27:27,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B76))","v":27},{"$f":"VLOOKUP($B$21,'liste déroulante'!28:28,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!28:28,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B77))","v":28},{"$f":"VLOOKUP($B$21,'liste déroulante'!29:29,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!29:29,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B78))","v":29},{"$f":"VLOOKUP($B$21,'liste déroulante'!30:30,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!30:30,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B79))","v":30},{"$f":"VLOOKUP($B$21,'liste déroulante'!31:31,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!31:31,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B80))","v":31},{"$f":"VLOOKUP($B$21,'liste déroulante'!32:32,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!32:32,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B81))","v":32},{"$f":"VLOOKUP($B$21,'liste déroulante'!33:33,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!33:33,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B82))","v":33},{"$f":"VLOOKUP($B$21,'liste déroulante'!34:34,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!34:34,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B83))","v":34},{"$f":"VLOOKUP($B$21,'liste déroulante'!35:35,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!35:35,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B84))","v":35},{"$f":"VLOOKUP($B$21,'liste déroulante'!36:36,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!36:36,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B85))","v":36},{"$f":"VLOOKUP($B$21,'liste déroulante'!37:37,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!37:37,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B86))","v":37},{"$f":"VLOOKUP($B$21,'liste déroulante'!38:38,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!38:38,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B87))","v":38},{"$f":"VLOOKUP($B$21,'liste déroulante'!39:39,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!39:39,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B88))","v":39},{"$f":"VLOOKUP($B$21,'liste déroulante'!40:40,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!40:40,3,FALSE)","v":{"$error":"#N/A"}}]
[{"$f":"(SUBTOTAL(3,$B$50:B89))","v":40},{"$f":"VLOOKUP($B$21,'liste déroulante'!41:41,2,FALSE)","v":{"$error":"#N/A"}},null,null,{"$f":"VLOOKUP($B$21,'liste déroulante'!41:41,3,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"liste déroulante","index":1,"n_rows":7,"n_cols":15,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Désignation","LIEUX","PB","qui","Adresse","Contact",null,null,null,"SDB",null,"lots"]
["lot01","SDB","carrelage a reprendre",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 1"},null,null,null,"SALON",null,"lot01","NOM1","ADRESSE1","CONTATC 1"]
["lot02","WC","sol à laver",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM2"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE2"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 2"},null,null,null,"CHAMBRE",null,"lot02","NOM2","ADRESSE2","CONTATC 2"]
["lot03","JARDIN","tailler les haies",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM3"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE3"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 3"},null,null,null,"WC",null,"lot03","NOM3","ADRESSE3","CONTATC 3"]
["lot01","SDB","lign new",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 1"},null,null,null,"SDJ"]
["lot01","CHAMBRE","poser papier peint",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE1"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 1"},null,null,null,"JARDIN"]
["lot03","SDB","joints",{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,2,FALSE)","v":"NOM3"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,3,FALSE)","v":"ADRESSE3"},{"$f":"VLOOKUP(donnees[[#This Row],[Désignation]],$L$2:$O$4,4,FALSE)","v":"CONTATC 3"},null,null,null,"GARAGE"]