{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Feuille 1 ","LOCATION"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Feuille 1 ","index":0,"n_rows":201,"n_cols":10,"rows_kept":201,"cut":false,"hidden":false,"merged":[]}
["N°","Description du problème","Zone","Date","Compte","Importance","Solutioned by","Resolve date","Statut","Composants / Note"]
[1,"AC190",{"$f":"IF(B2>0,VLOOKUP(\"*\"&$B2,LOCATION!B:C,2,0),\"\")","v":27},{"$f":"IF(ISNUMBER(SEARCH(\"\",B2)),NOW(),\"\")","v":"2018-08-30T17:11:04.970"},{"$f":"COUNTIF(B:B,B2)","v":2},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B2)),getEnviron(\"username\"),\"\")","v":"Toriix"},{"$f":"IF(ISNUMBER(SEARCH(\"\",B2)),NOW(),\"\")","v":"2018-08-30T17:11:04.970"}]
[2,"AC190",{"$f":"IF(B3>0,VLOOKUP(\"*\"&$B3,LOCATION!B:C,2,0),\"\")","v":27},{"$f":"IF(ISNUMBER(SEARCH(\"\",B3)),NOW(),\"\")","v":"2018-08-30T17:11:04.970"},2,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B3)),getEnviron(\"username\"),\"\")","v":"Toriix"},"2018-08-30T17:11:04.970"]
[3,"AC010",{"$f":"IF(B4>0,VLOOKUP(\"*\"&$B4,LOCATION!B:C,2,0),\"\")","v":18},"2018-08-30T17:11:04.970",1,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B4)),getEnviron(\"username\"),\"\")","v":"Toriix"},"2018-08-30T17:11:04.970"]
[4,"AD020",{"$f":"IF(B5>0,VLOOKUP(\"*\"&$B5,LOCATION!B:C,2,0),\"\")","v":18},"2018-08-30T17:11:04.970",1,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B5)),getEnviron(\"username\"),\"\")","v":"Toriix"},"2018-08-30T17:11:04.970"]
[5,null,{"$f":"IF(B6>0,VLOOKUP(\"*\"&$B6,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B6)),getEnviron(\"username\"),\"\")","v":""},""]
[6,null,{"$f":"IF(B7>0,VLOOKUP(\"*\"&$B7,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B7)),getEnviron(\"username\"),\"\")","v":""},""]
[7,null,{"$f":"IF(B8>0,VLOOKUP(\"*\"&$B8,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B8)),getEnviron(\"username\"),\"\")","v":""},""]
[8,null,{"$f":"IF(B9>0,VLOOKUP(\"*\"&$B9,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B9)),getEnviron(\"username\"),\"\")","v":""},""]
[9,null,{"$f":"IF(B10>0,VLOOKUP(\"*\"&$B10,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B10)),getEnviron(\"username\"),\"\")","v":""},""]
[10,null,{"$f":"IF(B11>0,VLOOKUP(\"*\"&$B11,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B11)),getEnviron(\"username\"),\"\")","v":""},""]
[11,null,{"$f":"IF(B12>0,VLOOKUP(\"*\"&$B12,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B12)),getEnviron(\"username\"),\"\")","v":""},""]
[12,null,{"$f":"IF(B13>0,VLOOKUP(\"*\"&$B13,LOCATION!B:C,2,0),\"\")","v":""},"",{"$f":"COUNTIF(B:B,B13)","v":0},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B13)),getEnviron(\"username\"),\"\")","v":""},""]
[13,null,{"$f":"IF(B14>0,VLOOKUP(\"*\"&$B14,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B14)),getEnviron(\"username\"),\"\")","v":""},""]
[14,null,{"$f":"IF(B15>0,VLOOKUP(\"*\"&$B15,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B15)),getEnviron(\"username\"),\"\")","v":""},""]
[15,null,{"$f":"IF(B16>0,VLOOKUP(\"*\"&$B16,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B16)),getEnviron(\"username\"),\"\")","v":""},""]
[16,null,{"$f":"IF(B17>0,VLOOKUP(\"*\"&$B17,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B17)),getEnviron(\"username\"),\"\")","v":""},""]
[17,null,{"$f":"IF(B18>0,VLOOKUP(\"*\"&$B18,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B18)),getEnviron(\"username\"),\"\")","v":""},""]
[18,null,{"$f":"IF(B19>0,VLOOKUP(\"*\"&$B19,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B19)),getEnviron(\"username\"),\"\")","v":""},""]
[19,null,{"$f":"IF(B20>0,VLOOKUP(\"*\"&$B20,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B20)),getEnviron(\"username\"),\"\")","v":""},""]
[20,null,{"$f":"IF(B21>0,VLOOKUP(\"*\"&$B21,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B21)),getEnviron(\"username\"),\"\")","v":""},""]
[21,null,{"$f":"IF(B22>0,VLOOKUP(\"*\"&$B22,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B22)),getEnviron(\"username\"),\"\")","v":""},""]
[22,null,{"$f":"IF(B23>0,VLOOKUP(\"*\"&$B23,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B23)),getEnviron(\"username\"),\"\")","v":""},""]
[23,null,{"$f":"IF(B24>0,VLOOKUP(\"*\"&$B24,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B24)),getEnviron(\"username\"),\"\")","v":""},""]
[24,null,{"$f":"IF(B25>0,VLOOKUP(\"*\"&$B25,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B25)),getEnviron(\"username\"),\"\")","v":""},""]
[25,null,{"$f":"IF(B26>0,VLOOKUP(\"*\"&$B26,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B26)),getEnviron(\"username\"),\"\")","v":""},""]
[26,null,{"$f":"IF(B27>0,VLOOKUP(\"*\"&$B27,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B27)),getEnviron(\"username\"),\"\")","v":""},""]
[27,null,{"$f":"IF(B28>0,VLOOKUP(\"*\"&$B28,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B28)),getEnviron(\"username\"),\"\")","v":""},""]
[28,null,{"$f":"IF(B29>0,VLOOKUP(\"*\"&$B29,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B29)),getEnviron(\"username\"),\"\")","v":""},""]
[29,null,{"$f":"IF(B30>0,VLOOKUP(\"*\"&$B30,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B30)),getEnviron(\"username\"),\"\")","v":""},""]
[30,null,{"$f":"IF(B31>0,VLOOKUP(\"*\"&$B31,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B31)),getEnviron(\"username\"),\"\")","v":""},""]
[31,null,{"$f":"IF(B32>0,VLOOKUP(\"*\"&$B32,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B32)),getEnviron(\"username\"),\"\")","v":""},""]
[32,null,{"$f":"IF(B33>0,VLOOKUP(\"*\"&$B33,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B33)),getEnviron(\"username\"),\"\")","v":""},""]
[33,null,{"$f":"IF(B34>0,VLOOKUP(\"*\"&$B34,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B34)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B34)),NOW(),\"\")","v":""}]
[34,null,{"$f":"IF(B35>0,VLOOKUP(\"*\"&$B35,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B35)),getEnviron(\"username\"),\"\")","v":""},""]
[35,null,{"$f":"IF(B36>0,VLOOKUP(\"*\"&$B36,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B36)),getEnviron(\"username\"),\"\")","v":""},""]
[36,null,{"$f":"IF(B37>0,VLOOKUP(\"*\"&$B37,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B37)),getEnviron(\"username\"),\"\")","v":""},""]
[37,null,{"$f":"IF(B38>0,VLOOKUP(\"*\"&$B38,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B38)),getEnviron(\"username\"),\"\")","v":""},""]
[38,null,{"$f":"IF(B39>0,VLOOKUP(\"*\"&$B39,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B39)),getEnviron(\"username\"),\"\")","v":""},""]
[39,null,{"$f":"IF(B40>0,VLOOKUP(\"*\"&$B40,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B40)),getEnviron(\"username\"),\"\")","v":""},""]
[40,null,{"$f":"IF(B41>0,VLOOKUP(\"*\"&$B41,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B41)),getEnviron(\"username\"),\"\")","v":""},""]
[41,null,{"$f":"IF(B42>0,VLOOKUP(\"*\"&$B42,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B42)),getEnviron(\"username\"),\"\")","v":""},""]
[42,null,{"$f":"IF(B43>0,VLOOKUP(\"*\"&$B43,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B43)),getEnviron(\"username\"),\"\")","v":""},""]
[43,null,{"$f":"IF(B44>0,VLOOKUP(\"*\"&$B44,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B44)),getEnviron(\"username\"),\"\")","v":""},""]
[44,null,{"$f":"IF(B45>0,VLOOKUP(\"*\"&$B45,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B45)),getEnviron(\"username\"),\"\")","v":""},""]
[45,null,{"$f":"IF(B46>0,VLOOKUP(\"*\"&$B46,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B46)),getEnviron(\"username\"),\"\")","v":""},""]
[46,null,{"$f":"IF(B47>0,VLOOKUP(\"*\"&$B47,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B47)),getEnviron(\"username\"),\"\")","v":""},""]
[47,null,{"$f":"IF(B48>0,VLOOKUP(\"*\"&$B48,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B48)),getEnviron(\"username\"),\"\")","v":""},""]
[48,null,{"$f":"IF(B49>0,VLOOKUP(\"*\"&$B49,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B49)),getEnviron(\"username\"),\"\")","v":""},""]
[49,null,{"$f":"IF(B50>0,VLOOKUP(\"*\"&$B50,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B50)),getEnviron(\"username\"),\"\")","v":""},""]
[50,null,{"$f":"IF(B51>0,VLOOKUP(\"*\"&$B51,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B51)),getEnviron(\"username\"),\"\")","v":""},""]
[51,null,{"$f":"IF(B52>0,VLOOKUP(\"*\"&$B52,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B52)),getEnviron(\"username\"),\"\")","v":""},""]
[52,null,{"$f":"IF(B53>0,VLOOKUP(\"*\"&$B53,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B53)),getEnviron(\"username\"),\"\")","v":""},""]
[53,null,{"$f":"IF(B54>0,VLOOKUP(\"*\"&$B54,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B54)),getEnviron(\"username\"),\"\")","v":""},""]
[54,null,{"$f":"IF(B55>0,VLOOKUP(\"*\"&$B55,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B55)),getEnviron(\"username\"),\"\")","v":""},""]
[55,null,{"$f":"IF(B56>0,VLOOKUP(\"*\"&$B56,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B56)),getEnviron(\"username\"),\"\")","v":""},""]
[56,null,{"$f":"IF(B57>0,VLOOKUP(\"*\"&$B57,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B57)),getEnviron(\"username\"),\"\")","v":""},""]
[57,null,{"$f":"IF(B58>0,VLOOKUP(\"*\"&$B58,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B58)),getEnviron(\"username\"),\"\")","v":""},""]
[58,null,{"$f":"IF(B59>0,VLOOKUP(\"*\"&$B59,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B59)),getEnviron(\"username\"),\"\")","v":""},""]
[59,null,{"$f":"IF(B60>0,VLOOKUP(\"*\"&$B60,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B60)),getEnviron(\"username\"),\"\")","v":""},""]
[60,null,{"$f":"IF(B61>0,VLOOKUP(\"*\"&$B61,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B61)),getEnviron(\"username\"),\"\")","v":""},""]
[61,null,{"$f":"IF(B62>0,VLOOKUP(\"*\"&$B62,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B62)),getEnviron(\"username\"),\"\")","v":""},""]
[62,null,{"$f":"IF(B63>0,VLOOKUP(\"*\"&$B63,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B63)),getEnviron(\"username\"),\"\")","v":""},""]
[63,null,{"$f":"IF(B64>0,VLOOKUP(\"*\"&$B64,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B64)),getEnviron(\"username\"),\"\")","v":""},""]
[64,null,{"$f":"IF(B65>0,VLOOKUP(\"*\"&$B65,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B65)),getEnviron(\"username\"),\"\")","v":""},""]
[65,null,{"$f":"IF(B66>0,VLOOKUP(\"*\"&$B66,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B66)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B66)),NOW(),\"\")","v":""}]
[66,null,{"$f":"IF(B67>0,VLOOKUP(\"*\"&$B67,LOCATION!B:C,2,0),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B67)),NOW(),\"\")","v":""},{"$f":"COUNTIF(B:B,B67)","v":0},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B67)),getEnviron(\"username\"),\"\")","v":""},""]
[67,null,{"$f":"IF(B68>0,VLOOKUP(\"*\"&$B68,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B68)),getEnviron(\"username\"),\"\")","v":""},""]
[68,null,{"$f":"IF(B69>0,VLOOKUP(\"*\"&$B69,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B69)),getEnviron(\"username\"),\"\")","v":""},""]
[69,null,{"$f":"IF(B70>0,VLOOKUP(\"*\"&$B70,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B70)),getEnviron(\"username\"),\"\")","v":""},""]
[70,null,{"$f":"IF(B71>0,VLOOKUP(\"*\"&$B71,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B71)),getEnviron(\"username\"),\"\")","v":""},""]
[71,null,{"$f":"IF(B72>0,VLOOKUP(\"*\"&$B72,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B72)),getEnviron(\"username\"),\"\")","v":""},""]
[72,null,{"$f":"IF(B73>0,VLOOKUP(\"*\"&$B73,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B73)),getEnviron(\"username\"),\"\")","v":""},""]
[73,null,{"$f":"IF(B74>0,VLOOKUP(\"*\"&$B74,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B74)),getEnviron(\"username\"),\"\")","v":""},""]
[74,null,{"$f":"IF(B75>0,VLOOKUP(\"*\"&$B75,LOCATION!B:C,2,0),\"\")","v":""},"",{"$f":"COUNTIF(B:B,B75)","v":0},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B75)),getEnviron(\"username\"),\"\")","v":""},""]
[75,null,{"$f":"IF(B76>0,VLOOKUP(\"*\"&$B76,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B76)),getEnviron(\"username\"),\"\")","v":""},""]
[76,null,{"$f":"IF(B77>0,VLOOKUP(\"*\"&$B77,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B77)),getEnviron(\"username\"),\"\")","v":""},""]
[77,null,{"$f":"IF(B78>0,VLOOKUP(\"*\"&$B78,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B78)),getEnviron(\"username\"),\"\")","v":""},""]
[78,null,{"$f":"IF(B79>0,VLOOKUP(\"*\"&$B79,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B79)),getEnviron(\"username\"),\"\")","v":""},""]
[79,null,{"$f":"IF(B80>0,VLOOKUP(\"*\"&$B80,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B80)),getEnviron(\"username\"),\"\")","v":""},""]
[80,null,{"$f":"IF(B81>0,VLOOKUP(\"*\"&$B81,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B81)),getEnviron(\"username\"),\"\")","v":""},""]
[81,null,{"$f":"IF(B82>0,VLOOKUP(\"*\"&$B82,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B82)),getEnviron(\"username\"),\"\")","v":""},""]
[82,null,{"$f":"IF(B83>0,VLOOKUP(\"*\"&$B83,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B83)),getEnviron(\"username\"),\"\")","v":""},""]
[83,null,{"$f":"IF(B84>0,VLOOKUP(\"*\"&$B84,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B84)),getEnviron(\"username\"),\"\")","v":""},""]
[84,null,{"$f":"IF(B85>0,VLOOKUP(\"*\"&$B85,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B85)),getEnviron(\"username\"),\"\")","v":""},""]
[85,null,{"$f":"IF(B86>0,VLOOKUP(\"*\"&$B86,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B86)),getEnviron(\"username\"),\"\")","v":""},""]
[86,null,{"$f":"IF(B87>0,VLOOKUP(\"*\"&$B87,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B87)),getEnviron(\"username\"),\"\")","v":""},""]
[87,null,{"$f":"IF(B88>0,VLOOKUP(\"*\"&$B88,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B88)),getEnviron(\"username\"),\"\")","v":""},""]
[88,null,{"$f":"IF(B89>0,VLOOKUP(\"*\"&$B89,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B89)),getEnviron(\"username\"),\"\")","v":""},""]
[89,null,{"$f":"IF(B90>0,VLOOKUP(\"*\"&$B90,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B90)),getEnviron(\"username\"),\"\")","v":""},""]
[90,null,{"$f":"IF(B91>0,VLOOKUP(\"*\"&$B91,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B91)),getEnviron(\"username\"),\"\")","v":""},""]
[91,null,{"$f":"IF(B92>0,VLOOKUP(\"*\"&$B92,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B92)),getEnviron(\"username\"),\"\")","v":""},""]
[92,null,{"$f":"IF(B93>0,VLOOKUP(\"*\"&$B93,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B93)),getEnviron(\"username\"),\"\")","v":""},""]
[93,null,{"$f":"IF(B94>0,VLOOKUP(\"*\"&$B94,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B94)),getEnviron(\"username\"),\"\")","v":""},""]
[94,null,{"$f":"IF(B95>0,VLOOKUP(\"*\"&$B95,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B95)),getEnviron(\"username\"),\"\")","v":""},""]
[95,null,{"$f":"IF(B96>0,VLOOKUP(\"*\"&$B96,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B96)),getEnviron(\"username\"),\"\")","v":""},""]
[96,null,{"$f":"IF(B97>0,VLOOKUP(\"*\"&$B97,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B97)),getEnviron(\"username\"),\"\")","v":""},""]
[97,null,{"$f":"IF(B98>0,VLOOKUP(\"*\"&$B98,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B98)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B98)),NOW(),\"\")","v":""}]
[98,null,{"$f":"IF(B99>0,VLOOKUP(\"*\"&$B99,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B99)),getEnviron(\"username\"),\"\")","v":""},""]
[99,null,{"$f":"IF(B100>0,VLOOKUP(\"*\"&$B100,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B100)),getEnviron(\"username\"),\"\")","v":""},""]
[100,null,{"$f":"IF(B101>0,VLOOKUP(\"*\"&$B101,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B101)),getEnviron(\"username\"),\"\")","v":""},""]
[101,null,{"$f":"IF(B102>0,VLOOKUP(\"*\"&$B102,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B102)),getEnviron(\"username\"),\"\")","v":""},""]
[102,null,{"$f":"IF(B103>0,VLOOKUP(\"*\"&$B103,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B103)),getEnviron(\"username\"),\"\")","v":""},""]
[103,null,{"$f":"IF(B104>0,VLOOKUP(\"*\"&$B104,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B104)),getEnviron(\"username\"),\"\")","v":""},""]
[104,null,{"$f":"IF(B105>0,VLOOKUP(\"*\"&$B105,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B105)),getEnviron(\"username\"),\"\")","v":""},""]
[105,null,{"$f":"IF(B106>0,VLOOKUP(\"*\"&$B106,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B106)),getEnviron(\"username\"),\"\")","v":""},""]
[106,null,{"$f":"IF(B107>0,VLOOKUP(\"*\"&$B107,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B107)),getEnviron(\"username\"),\"\")","v":""},""]
[107,null,{"$f":"IF(B108>0,VLOOKUP(\"*\"&$B108,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B108)),getEnviron(\"username\"),\"\")","v":""},""]
[108,null,{"$f":"IF(B109>0,VLOOKUP(\"*\"&$B109,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B109)),getEnviron(\"username\"),\"\")","v":""},""]
[109,null,{"$f":"IF(B110>0,VLOOKUP(\"*\"&$B110,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B110)),getEnviron(\"username\"),\"\")","v":""},""]
[110,null,{"$f":"IF(B111>0,VLOOKUP(\"*\"&$B111,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B111)),getEnviron(\"username\"),\"\")","v":""},""]
[111,null,{"$f":"IF(B112>0,VLOOKUP(\"*\"&$B112,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B112)),getEnviron(\"username\"),\"\")","v":""},""]
[112,null,{"$f":"IF(B113>0,VLOOKUP(\"*\"&$B113,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B113)),getEnviron(\"username\"),\"\")","v":""},""]
[113,null,{"$f":"IF(B114>0,VLOOKUP(\"*\"&$B114,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B114)),getEnviron(\"username\"),\"\")","v":""},""]
[114,null,{"$f":"IF(B115>0,VLOOKUP(\"*\"&$B115,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B115)),getEnviron(\"username\"),\"\")","v":""},""]
[115,null,{"$f":"IF(B116>0,VLOOKUP(\"*\"&$B116,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B116)),getEnviron(\"username\"),\"\")","v":""},""]
[116,null,{"$f":"IF(B117>0,VLOOKUP(\"*\"&$B117,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B117)),getEnviron(\"username\"),\"\")","v":""},""]
[117,null,{"$f":"IF(B118>0,VLOOKUP(\"*\"&$B118,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B118)),getEnviron(\"username\"),\"\")","v":""},""]
[118,null,{"$f":"IF(B119>0,VLOOKUP(\"*\"&$B119,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B119)),getEnviron(\"username\"),\"\")","v":""},""]
[119,null,{"$f":"IF(B120>0,VLOOKUP(\"*\"&$B120,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B120)),getEnviron(\"username\"),\"\")","v":""},""]
[120,null,{"$f":"IF(B121>0,VLOOKUP(\"*\"&$B121,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B121)),getEnviron(\"username\"),\"\")","v":""},""]
[121,null,{"$f":"IF(B122>0,VLOOKUP(\"*\"&$B122,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B122)),getEnviron(\"username\"),\"\")","v":""},""]
[122,null,{"$f":"IF(B123>0,VLOOKUP(\"*\"&$B123,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B123)),getEnviron(\"username\"),\"\")","v":""},""]
[123,null,{"$f":"IF(B124>0,VLOOKUP(\"*\"&$B124,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B124)),getEnviron(\"username\"),\"\")","v":""},""]
[124,null,{"$f":"IF(B125>0,VLOOKUP(\"*\"&$B125,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B125)),getEnviron(\"username\"),\"\")","v":""},""]
[125,null,{"$f":"IF(B126>0,VLOOKUP(\"*\"&$B126,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B126)),getEnviron(\"username\"),\"\")","v":""},""]
[126,null,{"$f":"IF(B127>0,VLOOKUP(\"*\"&$B127,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B127)),getEnviron(\"username\"),\"\")","v":""},""]
[127,null,{"$f":"IF(B128>0,VLOOKUP(\"*\"&$B128,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B128)),getEnviron(\"username\"),\"\")","v":""},""]
[128,null,{"$f":"IF(B129>0,VLOOKUP(\"*\"&$B129,LOCATION!B:C,2,0),\"\")","v":""},"",{"$f":"COUNTIF(B:B,B129)","v":0},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B129)),getEnviron(\"username\"),\"\")","v":""},""]
[129,null,{"$f":"IF(B130>0,VLOOKUP(\"*\"&$B130,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B130)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B130)),NOW(),\"\")","v":""}]
[130,null,{"$f":"IF(B131>0,VLOOKUP(\"*\"&$B131,LOCATION!B:C,2,0),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B131)),NOW(),\"\")","v":""},0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B131)),getEnviron(\"username\"),\"\")","v":""},""]
[131,null,{"$f":"IF(B132>0,VLOOKUP(\"*\"&$B132,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B132)),getEnviron(\"username\"),\"\")","v":""},""]
[132,null,{"$f":"IF(B133>0,VLOOKUP(\"*\"&$B133,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B133)),getEnviron(\"username\"),\"\")","v":""},""]
[133,null,{"$f":"IF(B134>0,VLOOKUP(\"*\"&$B134,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B134)),getEnviron(\"username\"),\"\")","v":""},""]
[134,null,{"$f":"IF(B135>0,VLOOKUP(\"*\"&$B135,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B135)),getEnviron(\"username\"),\"\")","v":""},""]
[135,null,{"$f":"IF(B136>0,VLOOKUP(\"*\"&$B136,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B136)),getEnviron(\"username\"),\"\")","v":""},""]
[136,null,{"$f":"IF(B137>0,VLOOKUP(\"*\"&$B137,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B137)),getEnviron(\"username\"),\"\")","v":""},""]
[137,null,{"$f":"IF(B138>0,VLOOKUP(\"*\"&$B138,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B138)),getEnviron(\"username\"),\"\")","v":""},""]
[138,null,{"$f":"IF(B139>0,VLOOKUP(\"*\"&$B139,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B139)),getEnviron(\"username\"),\"\")","v":""},""]
[139,null,{"$f":"IF(B140>0,VLOOKUP(\"*\"&$B140,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B140)),getEnviron(\"username\"),\"\")","v":""},""]
[140,null,{"$f":"IF(B141>0,VLOOKUP(\"*\"&$B141,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B141)),getEnviron(\"username\"),\"\")","v":""},""]
[141,null,{"$f":"IF(B142>0,VLOOKUP(\"*\"&$B142,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B142)),getEnviron(\"username\"),\"\")","v":""},""]
[142,null,{"$f":"IF(B143>0,VLOOKUP(\"*\"&$B143,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B143)),getEnviron(\"username\"),\"\")","v":""},""]
[143,null,{"$f":"IF(B144>0,VLOOKUP(\"*\"&$B144,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B144)),getEnviron(\"username\"),\"\")","v":""},""]
[144,null,{"$f":"IF(B145>0,VLOOKUP(\"*\"&$B145,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B145)),getEnviron(\"username\"),\"\")","v":""},""]
[145,null,{"$f":"IF(B146>0,VLOOKUP(\"*\"&$B146,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B146)),getEnviron(\"username\"),\"\")","v":""},""]
[146,null,{"$f":"IF(B147>0,VLOOKUP(\"*\"&$B147,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B147)),getEnviron(\"username\"),\"\")","v":""},""]
[147,null,{"$f":"IF(B148>0,VLOOKUP(\"*\"&$B148,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B148)),getEnviron(\"username\"),\"\")","v":""},""]
[148,null,{"$f":"IF(B149>0,VLOOKUP(\"*\"&$B149,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B149)),getEnviron(\"username\"),\"\")","v":""},""]
[149,null,{"$f":"IF(B150>0,VLOOKUP(\"*\"&$B150,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B150)),getEnviron(\"username\"),\"\")","v":""},""]
[150,null,{"$f":"IF(B151>0,VLOOKUP(\"*\"&$B151,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B151)),getEnviron(\"username\"),\"\")","v":""},""]
[151,null,{"$f":"IF(B152>0,VLOOKUP(\"*\"&$B152,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B152)),getEnviron(\"username\"),\"\")","v":""},""]
[152,null,{"$f":"IF(B153>0,VLOOKUP(\"*\"&$B153,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B153)),getEnviron(\"username\"),\"\")","v":""},""]
[153,null,{"$f":"IF(B154>0,VLOOKUP(\"*\"&$B154,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B154)),getEnviron(\"username\"),\"\")","v":""},""]
[154,null,{"$f":"IF(B155>0,VLOOKUP(\"*\"&$B155,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B155)),getEnviron(\"username\"),\"\")","v":""},""]
[155,null,{"$f":"IF(B156>0,VLOOKUP(\"*\"&$B156,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B156)),getEnviron(\"username\"),\"\")","v":""},""]
[156,null,{"$f":"IF(B157>0,VLOOKUP(\"*\"&$B157,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B157)),getEnviron(\"username\"),\"\")","v":""},""]
[157,null,{"$f":"IF(B158>0,VLOOKUP(\"*\"&$B158,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B158)),getEnviron(\"username\"),\"\")","v":""},""]
[158,null,{"$f":"IF(B159>0,VLOOKUP(\"*\"&$B159,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B159)),getEnviron(\"username\"),\"\")","v":""},""]
[159,null,{"$f":"IF(B160>0,VLOOKUP(\"*\"&$B160,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B160)),getEnviron(\"username\"),\"\")","v":""},""]
[160,null,{"$f":"IF(B161>0,VLOOKUP(\"*\"&$B161,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B161)),getEnviron(\"username\"),\"\")","v":""},""]
[161,null,{"$f":"IF(B162>0,VLOOKUP(\"*\"&$B162,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B162)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B162)),NOW(),\"\")","v":""}]
[162,null,{"$f":"IF(B163>0,VLOOKUP(\"*\"&$B163,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B163)),getEnviron(\"username\"),\"\")","v":""},""]
[163,null,{"$f":"IF(B164>0,VLOOKUP(\"*\"&$B164,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B164)),getEnviron(\"username\"),\"\")","v":""},""]
[164,null,{"$f":"IF(B165>0,VLOOKUP(\"*\"&$B165,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B165)),getEnviron(\"username\"),\"\")","v":""},""]
[165,null,{"$f":"IF(B166>0,VLOOKUP(\"*\"&$B166,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B166)),getEnviron(\"username\"),\"\")","v":""},""]
[166,null,{"$f":"IF(B167>0,VLOOKUP(\"*\"&$B167,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B167)),getEnviron(\"username\"),\"\")","v":""},""]
[167,null,{"$f":"IF(B168>0,VLOOKUP(\"*\"&$B168,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B168)),getEnviron(\"username\"),\"\")","v":""},""]
[168,null,{"$f":"IF(B169>0,VLOOKUP(\"*\"&$B169,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B169)),getEnviron(\"username\"),\"\")","v":""},""]
[169,null,{"$f":"IF(B170>0,VLOOKUP(\"*\"&$B170,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B170)),getEnviron(\"username\"),\"\")","v":""},""]
[170,null,{"$f":"IF(B171>0,VLOOKUP(\"*\"&$B171,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B171)),getEnviron(\"username\"),\"\")","v":""},""]
[171,null,{"$f":"IF(B172>0,VLOOKUP(\"*\"&$B172,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B172)),getEnviron(\"username\"),\"\")","v":""},""]
[172,null,{"$f":"IF(B173>0,VLOOKUP(\"*\"&$B173,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B173)),getEnviron(\"username\"),\"\")","v":""},""]
[173,null,{"$f":"IF(B174>0,VLOOKUP(\"*\"&$B174,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B174)),getEnviron(\"username\"),\"\")","v":""},""]
[174,null,{"$f":"IF(B175>0,VLOOKUP(\"*\"&$B175,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B175)),getEnviron(\"username\"),\"\")","v":""},""]
[175,null,{"$f":"IF(B176>0,VLOOKUP(\"*\"&$B176,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B176)),getEnviron(\"username\"),\"\")","v":""},""]
[176,null,{"$f":"IF(B177>0,VLOOKUP(\"*\"&$B177,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B177)),getEnviron(\"username\"),\"\")","v":""},""]
[177,null,{"$f":"IF(B178>0,VLOOKUP(\"*\"&$B178,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B178)),getEnviron(\"username\"),\"\")","v":""},""]
[178,null,{"$f":"IF(B179>0,VLOOKUP(\"*\"&$B179,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B179)),getEnviron(\"username\"),\"\")","v":""},""]
[179,null,{"$f":"IF(B180>0,VLOOKUP(\"*\"&$B180,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B180)),getEnviron(\"username\"),\"\")","v":""},""]
[180,null,{"$f":"IF(B181>0,VLOOKUP(\"*\"&$B181,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B181)),getEnviron(\"username\"),\"\")","v":""},""]
[181,null,{"$f":"IF(B182>0,VLOOKUP(\"*\"&$B182,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B182)),getEnviron(\"username\"),\"\")","v":""},""]
[182,null,{"$f":"IF(B183>0,VLOOKUP(\"*\"&$B183,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B183)),getEnviron(\"username\"),\"\")","v":""},""]
[183,null,{"$f":"IF(B184>0,VLOOKUP(\"*\"&$B184,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B184)),getEnviron(\"username\"),\"\")","v":""},""]
[184,null,{"$f":"IF(B185>0,VLOOKUP(\"*\"&$B185,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B185)),getEnviron(\"username\"),\"\")","v":""},""]
[185,null,{"$f":"IF(B186>0,VLOOKUP(\"*\"&$B186,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B186)),getEnviron(\"username\"),\"\")","v":""},""]
[186,null,{"$f":"IF(B187>0,VLOOKUP(\"*\"&$B187,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B187)),getEnviron(\"username\"),\"\")","v":""},""]
[187,null,{"$f":"IF(B188>0,VLOOKUP(\"*\"&$B188,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B188)),getEnviron(\"username\"),\"\")","v":""},""]
[188,null,{"$f":"IF(B189>0,VLOOKUP(\"*\"&$B189,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B189)),getEnviron(\"username\"),\"\")","v":""},""]
[189,null,{"$f":"IF(B190>0,VLOOKUP(\"*\"&$B190,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B190)),getEnviron(\"username\"),\"\")","v":""},""]
[190,null,{"$f":"IF(B191>0,VLOOKUP(\"*\"&$B191,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B191)),getEnviron(\"username\"),\"\")","v":""},""]
[191,null,{"$f":"IF(B192>0,VLOOKUP(\"*\"&$B192,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B192)),getEnviron(\"username\"),\"\")","v":""},""]
[192,null,{"$f":"IF(B193>0,VLOOKUP(\"*\"&$B193,LOCATION!B:C,2,0),\"\")","v":""},"",{"$f":"COUNTIF(B:B,B193)","v":0},null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B193)),getEnviron(\"username\"),\"\")","v":""},""]
[193,null,{"$f":"IF(B194>0,VLOOKUP(\"*\"&$B194,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B194)),getEnviron(\"username\"),\"\")","v":""},""]
[194,null,{"$f":"IF(B195>0,VLOOKUP(\"*\"&$B195,LOCATION!B:C,2,0),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B195)),NOW(),\"\")","v":""},0,null,{"$f":"IF(ISNUMBER(SEARCH(\"\",B195)),getEnviron(\"username\"),\"\")","v":""},{"$f":"IF(ISNUMBER(SEARCH(\"\",B195)),NOW(),\"\")","v":""}]
[195,null,{"$f":"IF(B196>0,VLOOKUP(\"*\"&$B196,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]
[196,null,{"$f":"IF(B197>0,VLOOKUP(\"*\"&$B197,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]
[197,null,{"$f":"IF(B198>0,VLOOKUP(\"*\"&$B198,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]
[198,null,{"$f":"IF(B199>0,VLOOKUP(\"*\"&$B199,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]
[199,null,{"$f":"IF(B200>0,VLOOKUP(\"*\"&$B200,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]
[200,null,{"$f":"IF(B201>0,VLOOKUP(\"*\"&$B201,LOCATION!B:C,2,0),\"\")","v":""},"",0,null,"",""]

{"sheet":"LOCATION","index":1,"n_rows":69,"n_cols":3,"rows_kept":69,"cut":false,"hidden":false,"merged":[]}
[null,"Toutes location","Section"]
[null,"AA010",1]
[null,"AA030",2]
[null,"AA050",3]
[null,"AA070",4]
[null,"AA090",5]
[null,"AA110",6]
[null,"AA130",7]
[null,"AA150",8]
[null,"AA170",9]
[null,"AA190",10]
[null,"AA210",11]
[null,"AA230",12]
[null,"AA250",13]
[null,"AA270",14]
[null,"AA290",15]
[null,"AA310",16]
[null,"AA330",17]
[null,"AB020",1]
[null,"AB040",2]
[null,"AB060",3]
[null,"AB080",4]
[null,"AB100",5]
[null,"AB120",6]
[null,"AB140",7]
[null,"AB160",8]
[null,"AB180",9]
[null,"AB200",10]
[null,"AB220",11]
[null,"AB240",12]
[null,"AB260",13]
[null,"AB280",14]
[null,"AB300",15]
[null,"AB320",16]
[null,"AB340",17]
[null,"AC010",18]
[null,"AC030",19]
[null,"AC050",20]
[null,"AC070",21]
[null,"AC090",22]
[null,"AC110",23]
[null,"AC130",24]
[null,"AC150",25]
[null,"AC170",26]
[null,"AC190",27]
[null,"AC210",28]
[null,"AC230",29]
[null,"AC250",30]
[null,"AC270",31]
[null,"AC290",32]
[null,"AC310",33]
[null,"AC330",34]
[null,"AD020",18]
[null,"AD040",19]
[null,"AD060",20]
[null,"AD080",21]
[null,"AD100",22]
[null,"AD120",23]
[null,"AD140",24]
[null,"AD160",25]
[null,"AD180",26]
[null,"AD200",27]
[null,"AD220",28]
[null,"AD240",29]
[null,"AD260",30]
[null,"AD280",31]
[null,"AD300",32]
[null,"AD320",33]
[null,"AD340",34]