{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["DATA","Recap","Sheet3"],"not_rendered":{"macros":1},"read":"whole","date_system":"1900"}

{"sheet":"DATA","index":0,"n_rows":6,"n_cols":18,"rows_kept":6,"merged":[[0,0,1,0],[0,2,1,2],[0,3,1,3],[0,4,1,4],[0,5,1,5],[0,6,1,6],[0,7,1,7],[0,8,1,8],[0,9,1,9],[0,10,1,10],[0,11,1,11]]}
["No.",null,"No. row","DDS REF.NO.","Transport ","Invoice ","Reminder Date","Ref. no.","PM Name ","Quot. No.","ETD","ETA","Month ","2015-01-01",null,null,"PM","Email "]
[{"$nulls":16},"TE","test@test.com"]
[null,{"$f":"IF(A3=\"x\",ROW(),\"\")","v":""},{"$f":"IF(A3=\"x\",+\"JAN\"&ROW(),\"\")","v":""},"LG16550102",{"$f":"MID(D3,1,1)","v":"L"},{"$f":"IF(A3=\"x\",\"TO DO \",\"OK\")","v":"OK"},{"$f":"IF(F3=\"OK\",\"\",IF(E3=\"O\",K3+40,IF(E3=\"A\",K3+10,IF(E3=\"L\",EOMONTH($N$1,0)+DAY(15),IF(E3=\"P\",EOMONTH($N$1,3),\"\")))))","v":""},"test11",null,"test1",{"$nulls":6},"TE2","test2@test2.com"]
["x",4,"JAN4","AES2652356","A","TO DO ","2015-01-20","test12","Te2","test2","2015-01-10","2015-01-14"]
["x",5,"JAN5","OEFS235625","O","TO DO ","2015-03-08","test13","Te","test3","2015-01-27","2015-03-30"]
["x",6,"JAN6","AES2563548","A","TO DO ",{"$f":"IF(F6=\"OK\",\"\",IF(E6=\"O\",K6+40,IF(E6=\"A\",K6+10,IF(E6=\"L\",EOMONTH($N$1,0)+DAY(15),IF(E6=\"P\",EOMONTH($N$1,3),\"\")))))","v":"2015-02-09"},"test14","Te","test4","2015-01-30","2015-02-04"]

{"sheet":"Recap","index":1,"n_rows":36,"n_cols":22,"rows_kept":36}
[null,null,"Today ","2015-12-14",null,{"$f":"WEEKDAY(D1,11)","v":1},{"$nulls":14},"Te","test@test.com"]
[null,null,"Minimum ",{"$f":"MIN(F12:I166)","v":"2015-01-20"},null,"2015-12-06",{"$nulls":14},"TE2","test2@test2.com"]
[null,null,"Controle",{"$f":"IF(D2>D1,\"OK\",IF(F1=1,\"INVOICE\",\"OK\"))","v":"INVOICE"}]
[]
[null,"Dear, "]
[null,"Please find below the invoices to do for this week. "]
[null,"Remember to update the operation files to not receive this reminder."]
[null,"Have a Good Day. "]
[]
["Num row","ref numero ","PM","DD Number ","CCG Ref Number ","CCG Quote Number ","Invoice Date ","Rappel +3 jours","Rappel +6 jours","Rappel +9 jours","Mail "]
[]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A11,0),0)+A11=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A11),0),0)+A11)","v":4},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A11),0),0)+A11=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A11),0),0)+A11,DATA!$B$1:$C$92,2))","v":"JAN4"},{"$f":"+IF(B12=\"\",\"\",VLOOKUP($B12,DATA!$C$1:$AH$92,7,FALSE))","v":"Te2"},{"$f":"+IF(B12=\"\",\"\",VLOOKUP($B12,DATA!$C$1:$AH$92,2,FALSE))","v":"AES2652356"},{"$f":"+IF(B12=\"\",\"\",VLOOKUP($B12,DATA!$C$1:$AH$92,6,FALSE))","v":"test12"},{"$f":"+IF(B12=\"\",\"\",VLOOKUP($B12,DATA!$C$1:$AH$92,8,FALSE))","v":"test2"},{"$f":"+IF(B12=\"\",\"\",VLOOKUP($B12,DATA!$C$1:$AH$92,5,FALSE))","v":"2015-01-20"},{"$f":"+IF($G12=\"\",\"\",+G12+3)","v":"2015-01-23"},"2015-01-26",{"$f":"+IF($G12=\"\",\"\",+I12+3)","v":"2015-01-29"},{"$f":"IF(ISNA(VLOOKUP(C12,$U$1:$X$7,2,FALSE)),\"\",VLOOKUP(C12,$U$1:$X$7,2,FALSE))","v":"test2@test2.com"}]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A12,0),0)+A12=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A12),0),0)+A12)","v":5},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A12),0),0)+A12=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A12),0),0)+A12,DATA!$B$1:$C$92,2))","v":"JAN5"},{"$f":"+IF(B13=\"\",\"\",VLOOKUP($B13,DATA!$C$1:$AH$92,7,FALSE))","v":"Te"},{"$f":"+IF(B13=\"\",\"\",VLOOKUP($B13,DATA!$C$1:$AH$92,2,FALSE))","v":"OEFS235625"},{"$f":"+IF(B13=\"\",\"\",VLOOKUP($B13,DATA!$C$1:$AH$92,6,FALSE))","v":"test13"},{"$f":"+IF(B13=\"\",\"\",VLOOKUP($B13,DATA!$C$1:$AH$92,8,FALSE))","v":"test3"},{"$f":"+IF(B13=\"\",\"\",VLOOKUP($B13,DATA!$C$1:$AH$92,5,FALSE))","v":"2015-03-08"},"2015-03-11","2015-03-14",{"$f":"+IF($G13=\"\",\"\",+I13+3)","v":"2015-03-17"},{"$f":"IF(ISNA(VLOOKUP(C13,$U$1:$X$7,2,FALSE)),\"\",VLOOKUP(C13,$U$1:$X$7,2,FALSE))","v":"test@test.com"}]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A13,0),0)+A13=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A13),0),0)+A13)","v":6},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A13),0),0)+A13=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A13),0),0)+A13,DATA!$B$1:$C$92,2))","v":"JAN6"},{"$f":"+IF(B14=\"\",\"\",VLOOKUP($B14,DATA!$C$1:$AH$92,7,FALSE))","v":"Te"},{"$f":"+IF(B14=\"\",\"\",VLOOKUP($B14,DATA!$C$1:$AH$92,2,FALSE))","v":"AES2563548"},{"$f":"+IF(B14=\"\",\"\",VLOOKUP($B14,DATA!$C$1:$AH$92,6,FALSE))","v":"test14"},{"$f":"+IF(B14=\"\",\"\",VLOOKUP($B14,DATA!$C$1:$AH$92,8,FALSE))","v":"test4"},{"$f":"+IF(B14=\"\",\"\",VLOOKUP($B14,DATA!$C$1:$AH$92,5,FALSE))","v":"2015-02-09"},"2015-02-12","2015-02-15","2015-02-18","test@test.com"]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A14,0),0)+A14=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A14),0),0)+A14)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A14),0),0)+A14=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A14),0),0)+A14,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B15=\"\",\"\",VLOOKUP($B15,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B15=\"\",\"\",VLOOKUP($B15,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B15=\"\",\"\",VLOOKUP($B15,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B15=\"\",\"\",VLOOKUP($B15,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B15=\"\",\"\",VLOOKUP($B15,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A15,0),0)+A15=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A15),0),0)+A15)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A15),0),0)+A15=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A15),0),0)+A15,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B16=\"\",\"\",VLOOKUP($B16,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B16=\"\",\"\",VLOOKUP($B16,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B16=\"\",\"\",VLOOKUP($B16,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B16=\"\",\"\",VLOOKUP($B16,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B16=\"\",\"\",VLOOKUP($B16,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A16,0),0)+A16=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A16),0),0)+A16)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A16),0),0)+A16=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A16),0),0)+A16,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B17=\"\",\"\",VLOOKUP($B17,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B17=\"\",\"\",VLOOKUP($B17,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B17=\"\",\"\",VLOOKUP($B17,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B17=\"\",\"\",VLOOKUP($B17,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B17=\"\",\"\",VLOOKUP($B17,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A17,0),0)+A17=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A17),0),0)+A17)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A17),0),0)+A17=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A17),0),0)+A17,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B18=\"\",\"\",VLOOKUP($B18,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B18=\"\",\"\",VLOOKUP($B18,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B18=\"\",\"\",VLOOKUP($B18,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B18=\"\",\"\",VLOOKUP($B18,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B18=\"\",\"\",VLOOKUP($B18,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A18,0),0)+A18=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A18),0),0)+A18)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A18),0),0)+A18=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A18),0),0)+A18,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B19=\"\",\"\",VLOOKUP($B19,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B19=\"\",\"\",VLOOKUP($B19,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B19=\"\",\"\",VLOOKUP($B19,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B19=\"\",\"\",VLOOKUP($B19,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B19=\"\",\"\",VLOOKUP($B19,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A19,0),0)+A19=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A19),0),0)+A19)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A19),0),0)+A19=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A19),0),0)+A19,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B20=\"\",\"\",VLOOKUP($B20,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B20=\"\",\"\",VLOOKUP($B20,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B20=\"\",\"\",VLOOKUP($B20,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B20=\"\",\"\",VLOOKUP($B20,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B20=\"\",\"\",VLOOKUP($B20,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A20,0),0)+A20=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A20),0),0)+A20)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A20),0),0)+A20=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A20),0),0)+A20,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B21=\"\",\"\",VLOOKUP($B21,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B21=\"\",\"\",VLOOKUP($B21,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B21=\"\",\"\",VLOOKUP($B21,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B21=\"\",\"\",VLOOKUP($B21,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B21=\"\",\"\",VLOOKUP($B21,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A21,0),0)+A21=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A21),0),0)+A21)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A21),0),0)+A21=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A21),0),0)+A21,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B22=\"\",\"\",VLOOKUP($B22,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B22=\"\",\"\",VLOOKUP($B22,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B22=\"\",\"\",VLOOKUP($B22,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B22=\"\",\"\",VLOOKUP($B22,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B22=\"\",\"\",VLOOKUP($B22,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A22,0),0)+A22=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A22),0),0)+A22)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A22),0),0)+A22=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A22),0),0)+A22,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B23=\"\",\"\",VLOOKUP($B23,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B23=\"\",\"\",VLOOKUP($B23,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B23=\"\",\"\",VLOOKUP($B23,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B23=\"\",\"\",VLOOKUP($B23,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B23=\"\",\"\",VLOOKUP($B23,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A23,0),0)+A23=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A23),0),0)+A23)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A23),0),0)+A23=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A23),0),0)+A23,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B24=\"\",\"\",VLOOKUP($B24,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B24=\"\",\"\",VLOOKUP($B24,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B24=\"\",\"\",VLOOKUP($B24,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B24=\"\",\"\",VLOOKUP($B24,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B24=\"\",\"\",VLOOKUP($B24,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A24,0),0)+A24=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A24),0),0)+A24)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A24),0),0)+A24=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A24),0),0)+A24,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B25=\"\",\"\",VLOOKUP($B25,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B25=\"\",\"\",VLOOKUP($B25,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B25=\"\",\"\",VLOOKUP($B25,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B25=\"\",\"\",VLOOKUP($B25,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B25=\"\",\"\",VLOOKUP($B25,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A25,0),0)+A25=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A25),0),0)+A25)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A25),0),0)+A25=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A25),0),0)+A25,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B26=\"\",\"\",VLOOKUP($B26,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B26=\"\",\"\",VLOOKUP($B26,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B26=\"\",\"\",VLOOKUP($B26,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B26=\"\",\"\",VLOOKUP($B26,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B26=\"\",\"\",VLOOKUP($B26,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A26,0),0)+A26=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A26),0),0)+A26)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A26),0),0)+A26=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A26),0),0)+A26,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B27=\"\",\"\",VLOOKUP($B27,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B27=\"\",\"\",VLOOKUP($B27,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B27=\"\",\"\",VLOOKUP($B27,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B27=\"\",\"\",VLOOKUP($B27,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B27=\"\",\"\",VLOOKUP($B27,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A27,0),0)+A27=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A27),0),0)+A27)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A27),0),0)+A27=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A27),0),0)+A27,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B28=\"\",\"\",VLOOKUP($B28,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B28=\"\",\"\",VLOOKUP($B28,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B28=\"\",\"\",VLOOKUP($B28,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B28=\"\",\"\",VLOOKUP($B28,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B28=\"\",\"\",VLOOKUP($B28,DATA!$C$1:$AH$92,5,FALSE))","v":""},{"$f":"+IF($G28=\"\",\"\",+G28+3)","v":""},"","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A28,0),0)+A28=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A28),0),0)+A28)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A28),0),0)+A28=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A28),0),0)+A28,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B29=\"\",\"\",VLOOKUP($B29,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B29=\"\",\"\",VLOOKUP($B29,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B29=\"\",\"\",VLOOKUP($B29,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B29=\"\",\"\",VLOOKUP($B29,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B29=\"\",\"\",VLOOKUP($B29,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A29,0),0)+A29=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A29),0),0)+A29)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A29),0),0)+A29=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A29),0),0)+A29,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B30=\"\",\"\",VLOOKUP($B30,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B30=\"\",\"\",VLOOKUP($B30,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B30=\"\",\"\",VLOOKUP($B30,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B30=\"\",\"\",VLOOKUP($B30,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B30=\"\",\"\",VLOOKUP($B30,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A30,0),0)+A30=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A30),0),0)+A30)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A30),0),0)+A30=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A30),0),0)+A30,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B31=\"\",\"\",VLOOKUP($B31,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B31=\"\",\"\",VLOOKUP($B31,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B31=\"\",\"\",VLOOKUP($B31,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B31=\"\",\"\",VLOOKUP($B31,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B31=\"\",\"\",VLOOKUP($B31,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A31,0),0)+A31=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A31),0),0)+A31)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A31),0),0)+A31=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A31),0),0)+A31,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B32=\"\",\"\",VLOOKUP($B32,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B32=\"\",\"\",VLOOKUP($B32,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B32=\"\",\"\",VLOOKUP($B32,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B32=\"\",\"\",VLOOKUP($B32,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B32=\"\",\"\",VLOOKUP($B32,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A32,0),0)+A32=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A32),0),0)+A32)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A32),0),0)+A32=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A32),0),0)+A32,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B33=\"\",\"\",VLOOKUP($B33,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B33=\"\",\"\",VLOOKUP($B33,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B33=\"\",\"\",VLOOKUP($B33,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B33=\"\",\"\",VLOOKUP($B33,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B33=\"\",\"\",VLOOKUP($B33,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A33,0),0)+A33=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A33),0),0)+A33)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A33),0),0)+A33=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A33),0),0)+A33,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B34=\"\",\"\",VLOOKUP($B34,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B34=\"\",\"\",VLOOKUP($B34,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B34=\"\",\"\",VLOOKUP($B34,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B34=\"\",\"\",VLOOKUP($B34,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B34=\"\",\"\",VLOOKUP($B34,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$f":"IF(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,A34,0),0)+A34=\"\",\"\",MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A34),0),0)+A34)","v":{"$error":"#N/A"}},{"$f":"IF(ISNA(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A34),0),0)+A34=\"\"),\"\",VLOOKUP(MATCH(\"x\",OFFSET(DATA!A$1:'DATA'!A$74,SUM(A34),0),0)+A34,DATA!$B$1:$C$92,2))","v":""},{"$f":"+IF(B35=\"\",\"\",VLOOKUP($B35,DATA!$C$1:$AH$92,7,FALSE))","v":""},{"$f":"+IF(B35=\"\",\"\",VLOOKUP($B35,DATA!$C$1:$AH$92,2,FALSE))","v":""},{"$f":"+IF(B35=\"\",\"\",VLOOKUP($B35,DATA!$C$1:$AH$92,6,FALSE))","v":""},{"$f":"+IF(B35=\"\",\"\",VLOOKUP($B35,DATA!$C$1:$AH$92,8,FALSE))","v":""},{"$f":"+IF(B35=\"\",\"\",VLOOKUP($B35,DATA!$C$1:$AH$92,5,FALSE))","v":""},"","","",""]
[{"$nulls":10},""]

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0}