{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["README","Calendar","Analysis","Data","Lists","Languages","Calculation"],"not_rendered":{"charts":2,"images":1,"macros":1,"defined_names":32,"pivot_tables":2},"read":"whole","date_system":"1900"}

{"sheet":"README","index":0,"n_rows":15,"n_cols":2,"rows_kept":15}
["Steps to prepare the Meeting Calendar tool"]
["1) create the list of Coordination Hubs in the tab","Coordination Hubs List"]
[]
["2) fill the meeting data in the tab: ","Data"]
["2.1) please read instructions on the data tab"]
["2.2Please notice that this automatic calendar shows a maximum of 6 meetings per day"]
[]
["3) in Calendar tab choose:","Calendar"]
["3.1) fill the date cell with the first day of the month for wich you are preparing the calendar. E.G. 01/01/2021 for the month of Jan/2021"]
["3.2 Choose the Ccoordination hub for which you wish to generate the calendar"]
["3.3 choose the language of the calendar"]
["3.4 print the calendar to PDF"]
[]
["If your country has a HumanitarianResponse.Info page, we recommend that you take look at this link and consider using the online Events Calendar"]
["https://humanitarian.atlassian.net/wiki/spaces/imtoolbox/pages/221839449/Events+calendar"]

{"sheet":"Calendar","index":1,"n_rows":61,"n_cols":12,"rows_kept":61,"merged":[[0,1,1,1],[1,4,2,10],[4,4,4,10],[19,4,19,10],[20,4,20,10],[21,4,22,10],[25,6,25,7],[25,8,25,9],[26,6,26,7],[26,8,26,9],[27,6,27,7],[27,8,27,9],[28,6,28,7],[28,8,28,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,6,34,7],[34,8,34,9],[35,6,35,7],[35,8,35,9],[36,6,36,7],[36,8,36,9],[37,6,37,7],[37,8,37,9],[38,6,38,7],[38,8,38,9],[39,6,39,7],[39,8,39,9],[40,6,40,7],[40,8,40,9],[41,6,41,7],[41,8,41,9],[42,6,42,7],[42,8,42,9],[43,6,43,7],[43,8,43,9],[44,6,44,7],[44,8,44,9],[45,6,45,7],[45,8,45,9],[46,6,46,7],[46,8,46,9],[47,6,47,7],[47,8,47,9],[48,6,48,7],[48,8,48,9],[49,6,49,7],[49,8,49,9],[50,6,50,7],[50,8,50,9],[51,6,51,7],[51,8,51,9],[52,6,52,7],[52,8,52,9],[53,6,53,7],[53,8,53,9],[54,6,54,7],[54,8,54,9],[56,4,56,10],[60,7,60,8]]}
[]
[{"$nulls":4},{"$f":"INDEX(Translation[Text],MATCH(\"T1_\" & Sel_Lang,Translation[Code],0)) &\" - \"& Sel_Office","v":"Meeting schedule - office1"}]
[null,"2021-01-01"]
[]
[null,"office1",null,null,{"$f":"INDEX(Translation[Text],MATCH(\"MO_\" & Sel_Lang&\"_\"&MONTH(Calendar_Sel_Month),Translation[Code],0))","v":"January"}]
[]
[null,"English",null,null,{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_7\",Translation[Code],0))","v":"Sunday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_1\",Translation[Code],0))","v":"Monday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_2\",Translation[Code],0))","v":"Tuesday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_3\",Translation[Code],0))","v":"Wednesday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_4\",Translation[Code],0))","v":"Thursday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_5\",Translation[Code],0))","v":"Friday"},{"$f":"INDEX(Translation[Text],MATCH(\"WE_\" & Sel_Lang&\"_6\",Translation[Code],0))","v":"Saturday"}]
[]
[null,"Add/Edit Events",null,null,{"$f":"COLUMNS($E9:E9)+(ROWS(E9:E$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2020-12-27"},{"$f":"COLUMNS($E9:F9)+(ROWS(F9:F$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2020-12-28"},{"$f":"COLUMNS($E9:G9)+(ROWS(G9:G$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2020-12-29"},{"$f":"COLUMNS($E9:H9)+(ROWS(H9:H$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2020-12-30"},{"$f":"COLUMNS($E9:I9)+(ROWS(I9:I$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2020-12-31"},{"$f":"COLUMNS($E9:J9)+(ROWS(J9:J$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-01"},{"$f":"COLUMNS($E9:K9)+(ROWS(K9:K$9)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-02"}]
[{"$nulls":4},{"$f":"INDEX(Calcul_Meetings,MATCH(E9,Calcul_Dates,0))","v":""},"","","","","",""]
[{"$nulls":4},{"$f":"COLUMNS($E11:E11)+(ROWS(E$9:E11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-03"},{"$f":"COLUMNS($E11:F11)+(ROWS(F$9:F11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-04"},{"$f":"COLUMNS($E11:G11)+(ROWS(G$9:G11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-05"},{"$f":"COLUMNS($E11:H11)+(ROWS(H$9:H11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-06"},{"$f":"COLUMNS($E11:I11)+(ROWS(I$9:I11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-07"},{"$f":"COLUMNS($E11:J11)+(ROWS(J$9:J11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-08"},{"$f":"COLUMNS($E11:K11)+(ROWS(K$9:K11)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-09"}]
[null,"This automatic calendar shows maximum 6 meetings per day",null,null,{"$f":"INDEX(Calcul_Meetings,MATCH(E11,Calcul_Dates,0))","v":""},{"$f":"INDEX(Calcul_Meetings,MATCH(F11,Calcul_Dates,0))","v":"09:00 Sample Meeting 3\n\n\n\n\n\n"},{"$f":"INDEX(Calcul_Meetings,MATCH(G11,Calcul_Dates,0))","v":"09:00 Sample Meeting 4\n\n\n\n\n\n"},{"$f":"INDEX(Calcul_Meetings,MATCH(H11,Calcul_Dates,0))","v":""},{"$f":"INDEX(Calcul_Meetings,MATCH(I11,Calcul_Dates,0))","v":""},{"$f":"INDEX(Calcul_Meetings,MATCH(J11,Calcul_Dates,0))","v":"09:00 Sample Meeting 7\n\n\n\n\n\n"},""]
[{"$nulls":4},{"$f":"COLUMNS($E13:E13)+(ROWS(E$9:E13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-10"},{"$f":"COLUMNS($E13:F13)+(ROWS(F$9:F13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-11"},{"$f":"COLUMNS($E13:G13)+(ROWS(G$9:G13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-12"},{"$f":"COLUMNS($E13:H13)+(ROWS(H$9:H13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-13"},{"$f":"COLUMNS($E13:I13)+(ROWS(I$9:I13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-14"},{"$f":"COLUMNS($E13:J13)+(ROWS(J$9:J13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-15"},{"$f":"COLUMNS($E13:K13)+(ROWS(K$9:K13)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-16"}]
[{"$nulls":4},{"$f":"INDEX(Calcul_Meetings,MATCH(E13,Calcul_Dates,0))","v":"09:30 Sample Meeting 9\n\n\n\n\n\n"},"","09:00 Sample Meeting 11\n\n\n\n\n\n","09:00 Sample Meeting 12\n\n\n\n\n\n","10:00 Sample Meeting 3\n\n\n\n\n\n","09:00 Sample Meeting 14\n\n\n\n\n\n","10:00 Sample Meeting 15\n\n\n\n\n\n"]
[{"$nulls":4},{"$f":"COLUMNS($E15:E15)+(ROWS(E$9:E15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-17"},{"$f":"COLUMNS($E15:F15)+(ROWS(F$9:F15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-18"},{"$f":"COLUMNS($E15:G15)+(ROWS(G$9:G15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-19"},{"$f":"COLUMNS($E15:H15)+(ROWS(H$9:H15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-20"},{"$f":"COLUMNS($E15:I15)+(ROWS(I$9:I15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-21"},{"$f":"COLUMNS($E15:J15)+(ROWS(J$9:J15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-22"},{"$f":"COLUMNS($E15:K15)+(ROWS(K$9:K15)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-23"}]
[{"$nulls":4},{"$f":"INDEX(Calcul_Meetings,MATCH(E15,Calcul_Dates,0))","v":"10:00 Sample Meeting 6\n\n\n\n\n\n"},"10:00 Sample Meeting 17\n\n\n\n\n\n","14:30 Sample Meeting 18\n\n\n\n\n\n","15:30 Sample Meeting 19\n\n\n\n\n\n","","",""]
[{"$nulls":4},{"$f":"COLUMNS($E17:E17)+(ROWS(E$9:E17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-24"},{"$f":"COLUMNS($E17:F17)+(ROWS(F$9:F17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-25"},{"$f":"COLUMNS($E17:G17)+(ROWS(G$9:G17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-26"},{"$f":"COLUMNS($E17:H17)+(ROWS(H$9:H17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-27"},{"$f":"COLUMNS($E17:I17)+(ROWS(I$9:I17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-28"},{"$f":"COLUMNS($E17:J17)+(ROWS(J$9:J17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-29"},{"$f":"COLUMNS($E17:K17)+(ROWS(K$9:K17)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-30"}]
[{"$nulls":4},{"$f":"INDEX(Calcul_Meetings,MATCH(E17,Calcul_Dates,0))","v":""},"","","","","",""]
[{"$nulls":4},{"$f":"COLUMNS($E19:E19)+(ROWS(E$9:E19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-01-31"},{"$f":"COLUMNS($E19:F19)+(ROWS(F$9:F19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-01"},{"$f":"COLUMNS($E19:G19)+(ROWS(G$9:G19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-02"},{"$f":"COLUMNS($E19:H19)+(ROWS(H$9:H19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-03"},{"$f":"COLUMNS($E19:I19)+(ROWS(I$9:I19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-04"},{"$f":"COLUMNS($E19:J19)+(ROWS(J$9:J19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-05"},{"$f":"COLUMNS($E19:K19)+(ROWS(K$9:K19)-1)/2*7-Calcul_wkDayFirst+Calcul_FirstDate","v":"2021-02-06"}]
[{"$nulls":4},{"$f":"INDEX(Translation[Text],MATCH(\"T6_\" & Sel_Lang,Translation[Code],0))","v":"This schedule is a compilation of the meetings shared with OCHA. Please contact the focal point if you need more information. "}]
[]
[{"$nulls":4},{"$f":"INDEX(Translation[Text],MATCH(\"T2_\"&Sel_Lang,Translation[Code],0))&\" - \"&Sel_Office","v":"Place of the meeting and contact person - office1"}]
[]
[]
[{"$nulls":4},{"$f":"INDEX(Translation[Text],MATCH(\"T3_\" & Sel_Lang,Translation[Code],0))","v":"Meeting"},{"$f":"INDEX(Translation[Text],MATCH(\"T4_\" & Sel_Lang,Translation[Code],0))","v":"Location"},{"$f":"INDEX(Translation[Text],MATCH(\"T9_\" & Sel_Lang,Translation[Code],0))","v":"Focal point"},null,{"$f":"INDEX(Translation[Text],MATCH(\"T5_\" & Sel_Lang,Translation[Code],0))","v":"Email"},null,{"$f":"INDEX(Translation[Text],MATCH(\"T8_\" & Sel_Lang,Translation[Code],0))","v":"Phone"}]
[{"$nulls":3},1,{"$f":"INDEX(Calculation!$D$60:$H$89,D26,1)","v":"Sample Meeting 3"},{"$f":"INDEX(Calculation!$D$60:$H$89,D26,2)","v":"Sample location 3"},{"$f":"INDEX(Calculation!$D$60:$H$89,D26,3)","v":"Name 2"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D26,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D26,5)","v":"555-555-555"}]
[{"$nulls":3},2,{"$f":"INDEX(Calculation!$D$60:$H$89,D27,1)","v":"Sample Meeting 4"},{"$f":"INDEX(Calculation!$D$60:$H$89,D27,2)","v":"Sample location 4"},{"$f":"INDEX(Calculation!$D$60:$H$89,D27,3)","v":"Name 3"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D27,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D27,5)","v":"555-555-555"}]
[{"$nulls":3},3,{"$f":"INDEX(Calculation!$D$60:$H$89,D28,1)","v":"Sample Meeting 7"},{"$f":"INDEX(Calculation!$D$60:$H$89,D28,2)","v":"Sample location 7"},{"$f":"INDEX(Calculation!$D$60:$H$89,D28,3)","v":"Name 6"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D28,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D28,5)","v":"555-555-555"},4]
[{"$nulls":3},4,{"$f":"INDEX(Calculation!$D$60:$H$89,D29,1)","v":"Sample Meeting 9"},{"$f":"INDEX(Calculation!$D$60:$H$89,D29,2)","v":"Sample location 9"},{"$f":"INDEX(Calculation!$D$60:$H$89,D29,3)","v":"Name 8"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D29,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D29,5)","v":"555-555-555"}]
[{"$nulls":3},5,{"$f":"INDEX(Calculation!$D$60:$H$89,D30,1)","v":"Sample Meeting 11"},{"$f":"INDEX(Calculation!$D$60:$H$89,D30,2)","v":"Sample location 4"},{"$f":"INDEX(Calculation!$D$60:$H$89,D30,3)","v":"Name 10"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D30,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D30,5)","v":"555-555-555"}]
[{"$nulls":3},6,{"$f":"INDEX(Calculation!$D$60:$H$89,D31,1)","v":"Sample Meeting 12"},{"$f":"INDEX(Calculation!$D$60:$H$89,D31,2)","v":"Sample location 12"},{"$f":"INDEX(Calculation!$D$60:$H$89,D31,3)","v":"Name 1"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D31,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D31,5)","v":"555-555-555"}]
[{"$nulls":3},7,{"$f":"INDEX(Calculation!$D$60:$H$89,D32,1)","v":"Sample Meeting 3"},{"$f":"INDEX(Calculation!$D$60:$H$89,D32,2)","v":"Sample location 13"},{"$f":"INDEX(Calculation!$D$60:$H$89,D32,3)","v":"Name 2"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D32,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D32,5)","v":"555-555-555"}]
[{"$nulls":3},8,{"$f":"INDEX(Calculation!$D$60:$H$89,D33,1)","v":"Sample Meeting 14"},{"$f":"INDEX(Calculation!$D$60:$H$89,D33,2)","v":"Sample location 1"},{"$f":"INDEX(Calculation!$D$60:$H$89,D33,3)","v":"Name 13"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D33,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D33,5)","v":"555-555-555"}]
[{"$nulls":3},9,{"$f":"INDEX(Calculation!$D$60:$H$89,D34,1)","v":"Sample Meeting 15"},{"$f":"INDEX(Calculation!$D$60:$H$89,D34,2)","v":"Sample location 15"},{"$f":"INDEX(Calculation!$D$60:$H$89,D34,3)","v":"Name 14"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D34,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D34,5)","v":"555-555-555"}]
[{"$nulls":3},10,{"$f":"INDEX(Calculation!$D$60:$H$89,D35,1)","v":"Sample Meeting 6"},{"$f":"INDEX(Calculation!$D$60:$H$89,D35,2)","v":"Sample location 2"},{"$f":"INDEX(Calculation!$D$60:$H$89,D35,3)","v":"Name 15"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D35,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D35,5)","v":"555-555-555"}]
[{"$nulls":3},11,{"$f":"INDEX(Calculation!$D$60:$H$89,D36,1)","v":"Sample Meeting 17"},{"$f":"INDEX(Calculation!$D$60:$H$89,D36,2)","v":"Sample location 17"},{"$f":"INDEX(Calculation!$D$60:$H$89,D36,3)","v":"Name 16"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D36,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D36,5)","v":"555-555-555"}]
[{"$nulls":3},12,{"$f":"INDEX(Calculation!$D$60:$H$89,D37,1)","v":"Sample Meeting 18"},{"$f":"INDEX(Calculation!$D$60:$H$89,D37,2)","v":"Sample location 18"},{"$f":"INDEX(Calculation!$D$60:$H$89,D37,3)","v":"Name 17"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D37,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D37,5)","v":"555-555-555"}]
[{"$nulls":3},13,{"$f":"INDEX(Calculation!$D$60:$H$89,D38,1)","v":"Sample Meeting 19"},{"$f":"INDEX(Calculation!$D$60:$H$89,D38,2)","v":"Sample location 19"},{"$f":"INDEX(Calculation!$D$60:$H$89,D38,3)","v":"Name 18"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D38,4)","v":"email1@email.com"},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D38,5)","v":"555-555-555"}]
[{"$nulls":3},14,{"$f":"INDEX(Calculation!$D$60:$H$89,D39,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D39,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D39,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D39,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D39,5)","v":""}]
[{"$nulls":3},15,{"$f":"INDEX(Calculation!$D$60:$H$89,D40,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D40,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D40,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D40,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D40,5)","v":""}]
[{"$nulls":3},16,{"$f":"INDEX(Calculation!$D$60:$H$89,D41,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D41,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D41,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D41,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D41,5)","v":""}]
[{"$nulls":3},17,{"$f":"INDEX(Calculation!$D$60:$H$89,D42,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D42,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D42,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D42,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D42,5)","v":""}]
[{"$nulls":3},18,{"$f":"INDEX(Calculation!$D$60:$H$89,D43,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D43,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D43,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D43,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D43,5)","v":""}]
[{"$nulls":3},19,{"$f":"INDEX(Calculation!$D$60:$H$89,D44,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D44,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D44,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D44,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D44,5)","v":""}]
[{"$nulls":3},20,{"$f":"INDEX(Calculation!$D$60:$H$89,D45,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D45,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D45,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D45,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D45,5)","v":""}]
[{"$nulls":3},21,{"$f":"INDEX(Calculation!$D$60:$H$89,D46,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D46,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D46,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D46,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D46,5)","v":""}]
[{"$nulls":3},22,{"$f":"INDEX(Calculation!$D$60:$H$89,D47,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D47,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D47,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D47,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D47,5)","v":""}]
[{"$nulls":3},23,{"$f":"INDEX(Calculation!$D$60:$H$89,D48,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D48,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D48,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D48,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D48,5)","v":""}]
[{"$nulls":3},24,{"$f":"INDEX(Calculation!$D$60:$H$89,D49,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D49,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D49,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D49,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D49,5)","v":""}]
[{"$nulls":3},25,{"$f":"INDEX(Calculation!$D$60:$H$89,D50,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D50,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D50,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D50,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D50,5)","v":""}]
[{"$nulls":3},26,{"$f":"INDEX(Calculation!$D$60:$H$89,D51,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D51,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D51,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D51,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D51,5)","v":""}]
[{"$nulls":3},27,{"$f":"INDEX(Calculation!$D$60:$H$89,D52,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D52,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D52,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D52,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D52,5)","v":""}]
[{"$nulls":3},28,{"$f":"INDEX(Calculation!$D$60:$H$89,D53,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D53,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D53,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D53,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D53,5)","v":""}]
[{"$nulls":3},29,{"$f":"INDEX(Calculation!$D$60:$H$89,D54,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D54,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D54,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D54,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D54,5)","v":""}]
[{"$nulls":3},30,{"$f":"INDEX(Calculation!$D$60:$H$89,D55,1)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D55,2)","v":""},{"$f":"INDEX(Calculation!$D$60:$H$89,D55,3)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D55,4)","v":""},null,{"$f":"INDEX(Calculation!$D$60:$H$89,D55,5)","v":""}]
[{"$nulls":3},25]
[{"$nulls":4},{"$f":"INDEX(Translation[Text],MATCH(\"T6_\" & Sel_Lang,Translation[Code],0))","v":"This schedule is a compilation of the meetings shared with OCHA. Please contact the focal point if you need more information. "}]
[]
[]
[]
[{"$nulls":7},{"$f":"INDEX(Translation[Text],MATCH(\"T7_\" & Sel_Lang,Translation[Code],0))","v":"Please send your input to:"},null,"[to be filled]"]

{"sheet":"Analysis","index":2,"n_rows":28,"n_cols":7,"rows_kept":28,"hidden":true}
[]
[]
["Meeting description","Count of Meeting description",null,null,"Years","Months","Count of Meeting description"]
["ISC",47,null,null,"2016","mai",20]
["Plateforme Nationale",46,{"$nulls":3},"juin",19]
["Education",44,{"$nulls":3},"juil",23]
["VBG",42,{"$nulls":3},"août",28]
["Abris/NFI",37,{"$nulls":3},"sept",31]
["Sec Alimentaire",33,{"$nulls":3},"oct",31]
["Protection Enfance",30,{"$nulls":3},"nov",31]
["Santé",29,null,null,"2017","janv",34]
["Protection",24,{"$nulls":3},"févr",18]
["HCT",21,{"$nulls":3},"mars",4]
["Nutrition",18,{"$nulls":3},"avr",26]
["Choléra",15,{"$nulls":3},"mai",24]
["EHA",15,{"$nulls":3},"juin",17]
["Relèvement précoce/Solutions durables",10,{"$nulls":3},"juil",23]
["UNCT",9,{"$nulls":3},"août",17]
["CCCM",8,{"$nulls":3},"sept",14]
["Transfert monétaire",6,{"$nulls":3},"oct",21]
["IMWG",6,{"$nulls":3},"nov",15]
["WASH",6,{"$nulls":3},"déc",17]
["Logistique",5,null,null,"2018","janv",17]
["Cash Transfer",5,{"$nulls":3},"févr",14]
[{"$nulls":5},"mars",15]
[{"$nulls":5},"avr",17]
[{"$nulls":5},"mai",23]
[{"$nulls":5},"juin",4]

{"sheet":"Data","index":3,"n_rows":24,"n_cols":21,"rows_kept":24,"merged":[[1,0,1,3],[1,4,1,15],[2,1,2,3],[2,5,3,5],[8,20,9,20],[10,20,11,20],[12,20,13,20]]}
[{"$nulls":8},"Clst Education+C:I"]
["Calendar View",{"$nulls":3},"Do not change the format of this sheet"]
[null,"Add/Edit Offices",{"$nulls":3},"Max 20 characters"]
[]
[{"$nulls":3},"Date","Hour","Meeting description","Office","Meeting Location","Contact Name","Contact email","Contact Phone","IsSelected","locationUnique","Location","LocationCount","ID","Concatenate","Year","Month",null,"INSTRUCTIONS"]
[{"$nulls":3},"2021-01-02","09:00:00","Sample Meeting 1","office3","Sample location 1","Name 1","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 1office3Sample location 1Name 1email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M6, $M6)>1,0,1)*L6","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D6,INDIRECT(\"$G$6:G\" & ROW()),G6)&\"/\"&D6&Tbl_Meetings[[#This Row],[Office]]","v":"1/44198office3"},{"$f":"TEXT(E6,\"HH:MM\") & \" \" & F6","v":"09:00 Sample Meeting 1"},{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"Do not leave empty rows or cells"]
[{"$nulls":3},"2021-01-03","09:00:00","Sample Meeting 2","office3","Sample location 2","Name 1","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 2office3Sample location 2Name 1email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M7, $M7)>1,0,1)*L7","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D7,INDIRECT(\"$G$6:G\" & ROW()),G7)&\"/\"&D7&Tbl_Meetings[[#This Row],[Office]]","v":"1/44199office3"},"09:00 Sample Meeting 2",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"Do not add or remove columns"]
[{"$nulls":3},"2021-01-04","09:00:00","Sample Meeting 3","office1","Sample location 3","Name 2","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 3office1Sample location 3Name 2email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M8, $M8)>1,0,1)*L8","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":1},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D8,INDIRECT(\"$G$6:G\" & ROW()),G8)&\"/\"&D8&Tbl_Meetings[[#This Row],[Office]]","v":"1/44200office1"},"09:00 Sample Meeting 3",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"Meeting description no longer than 20 characters"]
[{"$nulls":3},"2021-01-05","09:00:00","Sample Meeting 4","office1","Sample location 4","Name 3","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 4office1Sample location 4Name 3email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M9, $M9)>1,0,1)*L9","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":2},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D9,INDIRECT(\"$G$6:G\" & ROW()),G9)&\"/\"&D9&Tbl_Meetings[[#This Row],[Office]]","v":"1/44201office1"},"09:00 Sample Meeting 4",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"To remove an entry, select the cell, click right and select delete>delete row in the table"]
[{"$nulls":3},"2021-01-06","11:00:00","Sample Meeting 5","office2","Sample location 5","Name 4","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 5office2Sample location 5Name 4email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M10, $M10)>1,0,1)*L10","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D10,INDIRECT(\"$G$6:G\" & ROW()),G10)&\"/\"&D10&Tbl_Meetings[[#This Row],[Office]]","v":"1/44202office2"},"11:00 Sample Meeting 5",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-07","14:30:00","Sample Meeting 6","office3","Sample location 6","Name 5","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 6office3Sample location 6Name 5email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M11, $M11)>1,0,1)*L11","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D11,INDIRECT(\"$G$6:G\" & ROW()),G11)&\"/\"&D11&Tbl_Meetings[[#This Row],[Office]]","v":"1/44203office3"},"14:30 Sample Meeting 6",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"Make sure all the records are included in the table"]
[{"$nulls":3},"2021-01-08","09:00:00","Sample Meeting 7","office1","Sample location 7","Name 6","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 7office1Sample location 7Name 6email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M12, $M12)>1,0,1)*L12","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":3},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D12,INDIRECT(\"$G$6:G\" & ROW()),G12)&\"/\"&D12&Tbl_Meetings[[#This Row],[Office]]","v":"1/44204office1"},"09:00 Sample Meeting 7",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-09","09:00:00","Sample Meeting 8","office2","Sample location 8","Name 7","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 8office2Sample location 8Name 7email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M13, $M13)>1,0,1)*L13","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D13,INDIRECT(\"$G$6:G\" & ROW()),G13)&\"/\"&D13&Tbl_Meetings[[#This Row],[Office]]","v":"1/44205office2"},"09:00 Sample Meeting 8",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1},null,"Please notice that this automatic calendar shows a maximum of 6 meetings per day"]
[{"$nulls":3},"2021-01-10","09:30:00","Sample Meeting 9","office1","Sample location 9","Name 8","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 9office1Sample location 9Name 8email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M14, $M14)>1,0,1)*L14","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":4},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D14,INDIRECT(\"$G$6:G\" & ROW()),G14)&\"/\"&D14&Tbl_Meetings[[#This Row],[Office]]","v":"1/44206office1"},"09:30 Sample Meeting 9",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-11","08:15:00","Sample Meeting 1","office2","Sample location 10","Name 9","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":0},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 1office2Sample location 10Name 9email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M15, $M15)>1,0,1)*L15","v":0},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":""},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D15,INDIRECT(\"$G$6:G\" & ROW()),G15)&\"/\"&D15&Tbl_Meetings[[#This Row],[Office]]","v":"1/44207office2"},"08:15 Sample Meeting 1",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-12","09:00:00","Sample Meeting 11","office1","Sample location 4","Name 10","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 11office1Sample location 4Name 10email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M16, $M16)>1,0,1)*L16","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":5},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D16,INDIRECT(\"$G$6:G\" & ROW()),G16)&\"/\"&D16&Tbl_Meetings[[#This Row],[Office]]","v":"1/44208office1"},"09:00 Sample Meeting 11",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-13","09:00:00","Sample Meeting 12","office1","Sample location 12","Name 1","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 12office1Sample location 12Name 1email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M17, $M17)>1,0,1)*L17","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":6},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D17,INDIRECT(\"$G$6:G\" & ROW()),G17)&\"/\"&D17&Tbl_Meetings[[#This Row],[Office]]","v":"1/44209office1"},"09:00 Sample Meeting 12",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-14","10:00:00","Sample Meeting 3","office1","Sample location 13","Name 2","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 3office1Sample location 13Name 2email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M18, $M18)>1,0,1)*L18","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":7},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D18,INDIRECT(\"$G$6:G\" & ROW()),G18)&\"/\"&D18&Tbl_Meetings[[#This Row],[Office]]","v":"1/44210office1"},"10:00 Sample Meeting 3",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-15","09:00:00","Sample Meeting 14","office1","Sample location 1","Name 13","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 14office1Sample location 1Name 13email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M19, $M19)>1,0,1)*L19","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":8},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D19,INDIRECT(\"$G$6:G\" & ROW()),G19)&\"/\"&D19&Tbl_Meetings[[#This Row],[Office]]","v":"1/44211office1"},"09:00 Sample Meeting 14",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-16","10:00:00","Sample Meeting 15","office1","Sample location 15","Name 14","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 15office1Sample location 15Name 14email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M20, $M20)>1,0,1)*L20","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":9},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D20,INDIRECT(\"$G$6:G\" & ROW()),G20)&\"/\"&D20&Tbl_Meetings[[#This Row],[Office]]","v":"1/44212office1"},"10:00 Sample Meeting 15",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-17","10:00:00","Sample Meeting 6","office1","Sample location 2","Name 15","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 6office1Sample location 2Name 15email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M21, $M21)>1,0,1)*L21","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":10},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D21,INDIRECT(\"$G$6:G\" & ROW()),G21)&\"/\"&D21&Tbl_Meetings[[#This Row],[Office]]","v":"1/44213office1"},"10:00 Sample Meeting 6",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-18","10:00:00","Sample Meeting 17","office1","Sample location 17","Name 16","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 17office1Sample location 17Name 16email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M22, $M22)>1,0,1)*L22","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":11},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D22,INDIRECT(\"$G$6:G\" & ROW()),G22)&\"/\"&D22&Tbl_Meetings[[#This Row],[Office]]","v":"1/44214office1"},"10:00 Sample Meeting 17",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-19","14:30:00","Sample Meeting 18","office1","Sample location 18","Name 17","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 18office1Sample location 18Name 17email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M23, $M23)>1,0,1)*L23","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":12},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D23,INDIRECT(\"$G$6:G\" & ROW()),G23)&\"/\"&D23&Tbl_Meetings[[#This Row],[Office]]","v":"1/44215office1"},"14:30 Sample Meeting 18",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]
[{"$nulls":3},"2021-01-20","15:30:00","Sample Meeting 19","office1","Sample location 19","Name 18","email1@email.com","555-555-555",{"$f":"--(AND(Tbl_Meetings[[#This Row],[Office]]=Sel_Office,MONTH(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Month,YEAR(Tbl_Meetings[[#This Row],[Date]])=Calcul_NB_Year))","v":1},{"$f":"_xlfn.CONCAT(Tbl_Meetings[[#This Row],[Meeting description]],Tbl_Meetings[[#This Row],[Office]],Tbl_Meetings[[#This Row],[Meeting Location]],Tbl_Meetings[[#This Row],[Contact Name]],Tbl_Meetings[[#This Row],[Contact email]],Tbl_Meetings[[#This Row],[Contact Phone]])","v":"Sample Meeting 19office1Sample location 19Name 18email1@email.com555-555-555"},{"$f":"IF(COUNTIF($M$6:$M24, $M24)>1,0,1)*L24","v":1},{"$f":"IF(Tbl_Meetings[[#This Row],[Location]]=0,\"\",SUM(INDIRECT(\"$n$4:n\" & ROW())))","v":13},{"$f":"COUNTIFS(INDIRECT(\"$D$6:D\" & ROW()),D24,INDIRECT(\"$G$6:G\" & ROW()),G24)&\"/\"&D24&Tbl_Meetings[[#This Row],[Office]]","v":"1/44216office1"},"15:30 Sample Meeting 19",{"$f":"YEAR(Tbl_Meetings[[#This Row],[Date]])","v":2021},{"$f":"MONTH(Tbl_Meetings[[#This Row],[Date]])","v":1}]

{"sheet":"Lists","index":4,"n_rows":6,"n_cols":3,"rows_kept":6}
["Coordination Hubs",null,"Add/Edit Events"]
["office1"]
["office2"]
["office3"]
["office4"]
["office5"]

{"sheet":"Languages","index":5,"n_rows":123,"n_cols":2,"rows_kept":123,"hidden":true}
["DO NOT CHANGE THE LIST"]
["Languages"]
["English"]
["French"]
["Português"]
["Español"]
[]
[]
[]
["DO NOT CHANGE THE LIST"]
["Code","Text"]
["T1_French","Calendrier des réunions"]
["T1_English","Meeting schedule"]
["T1_Español","Calendario de reuniones"]
["T1_Português","Calendário de reuniões"]
["MO_English_1","January"]
["MO_English_2","February"]
["MO_English_3","March"]
["MO_English_4","April"]
["MO_English_5","May"]
["MO_English_6","June"]
["MO_English_7","July"]
["MO_English_8","August"]
["MO_English_9","September"]
["MO_English_10","October"]
["MO_English_11","November"]
["MO_English_12","December"]
["MO_French_1","Janvier"]
["MO_French_2","Février"]
["MO_French_3","Mars"]
["MO_French_4","Avril"]
["MO_French_5","Mai"]
["MO_French_6","Juin"]
["MO_French_7","Juillet"]
["MO_French_8","Août"]
["MO_French_9","Septembre"]
["MO_French_10","Octobre"]
["MO_French_11","Novembre"]
["MO_French_12","Décembre"]
["MO_Español_1","Enero"]
["MO_Español_2","Febrero"]
["MO_Español_3","Marzo"]
["MO_Español_4","Abril"]
["MO_Español_5","Mayo"]
["MO_Español_6","Junio"]
["MO_Español_7","Julio"]
["MO_Español_8","Agosto"]
["MO_Español_9","Septembre"]
["MO_Español_10","Octubre"]
["MO_Español_11","Noviembre"]
["MO_Español_12","Diciembre"]
["MO_Português_1","Janeiro"]
["MO_Português_2","Fevereiro"]
["MO_Português_3","Março"]
["MO_Português_4","Abril"]
["MO_Português_5","Maio"]
["MO_Português_6","Junho"]
["MO_Português_7","Julho"]
["MO_Português_8","Agosto"]
["MO_Português_9","Setembro"]
["MO_Português_10","Outubro"]
["MO_Português_11","Novembro"]
["MO_Português_12","Dezembro"]
["WE_French_1","Dimanche"]
["WE_French_2","Lundi"]
["WE_French_3","Mardi"]
["WE_French_4","Mercredi"]
["WE_French_5","Jeudi"]
["WE_French_6","Vendredi"]
["WE_French_7","Samedi"]
["WE_English_1","Monday"]
["WE_English_2","Tuesday"]
["WE_English_3","Wednesday"]
["WE_English_4","Thursday"]
["WE_English_5","Friday"]
["WE_English_6","Saturday"]
["WE_English_7","Sunday"]
["WE_Español_1","Lunes"]
["WE_Español_2","Martes"]
["WE_Español_3","Miercoles"]
["WE_Español_4","Jueves"]
["WE_Español_5","Viernes"]
["WE_Español_6","Sábado"]
["WE_Español_7","Domingo"]
["WE_Português_1","Segunda-feira"]
["WE_Português_2","Terça-feira"]
["WE_Português_3","Quarta-feira"]
["WE_Português_4","Quinta-feira"]
["WE_Português_5","Sexta-feira"]
["WE_Português_6","Sábado"]
["WE_Português_7","Domingo"]
["T2_French","Lieu de la réunion et personne de contact"]
["T3_French","Point focal"]
["T9_French","Réunion"]
["T4_French","Lieu"]
["T5_French","Courrier électronique"]
["T8_French","Téléphone"]
["T6_French","Ce calendrier est une compilation des réunions communiquées à OCHA. Nous vous remercions de contacter le Coordonnateur du Secteur si vous avez besoin des informations supplementaires"]
["T7_French","Merci d'envoyer les infos de vos réunions a: "]
["T2_English","Place of the meeting and contact person"]
["T3_English","Meeting"]
["T9_English","Focal point"]
["T4_English","Location"]
["T5_English","Email"]
["T8_English","Phone"]
["T6_English","This schedule is a compilation of the meetings shared with OCHA. Please contact the focal point if you need more information. "]
["T7_English","Please send your input to:"]
["T2_Español","Sitio de la réunion y persona de contacto"]
["T3_Español","Reunión"]
["T9_Español","Persona de contacto"]
["T4_Español","Ubicación"]
["T5_Español","Correo electrónico"]
["T8_Español","Teléfono"]
["T6_Español","Este calendario es una compilacion de los datos recibidos por OCHA. Para más informaciones, por favor contactar a la persona de contacto"]
["T7_Español","Por favor envíe sus contribuciones a: "]
["T2_Português","Local da reunião e Contatos"]
["T3_Português","Reunião"]
["T9_Português","Contato"]
["T4_Português","Local"]
["T5_Português","Email"]
["T8_Português","Telefone"]
["T6_Português","Este calendário é uma compilação dos dados recebidos pelo OCHA. Para mais informações, por favor contatar a persona de contato"]
["T7_Português","Favor enviar suas contribuições a: "]

{"sheet":"Calculation","index":6,"n_rows":89,"n_cols":11,"rows_kept":89,"hidden":true}
[]
["First",{"$f":"EOMONTH(Calendar_Sel_Month,-1)+1","v":"2021-01-01"},null,"Calculate Agenda"]
["Weekday of First",{"$f":"WEEKDAY(B2)","v":6}]
["Year",{"$f":"YEAR(B2)","v":2021}]
["Month",{"$f":"MONTH(B2)","v":1}]
["Nb Data",{"$f":"COUNTA(Data_Date_Col)-1","v":19}]
["Nb of days",{"$f":"DAY(DATE(YEAR(Calendar_Sel_Month),MONTH(Calendar_Sel_Month)+1,0))","v":31}]
[{"$nulls":4},{"$f":"$C10>=1","v":false}]
["Calendar Box","Calcul_Date","Number of events","Meetings","Meeting 1","Meeting 2","Meeting 3","Meeting 4","Meeting 5","Meeting 6","Meeting 7"]
[1,{"$f":"(ROWS(B$10:B10))-$B$3+$B$2","v":"2020-12-27"},{"$f":"COUNTIFS(OFFSET(Data_Date_Start,1,0,Calcul_NB_Data),B10,OFFSET(Data_Date_Start,1,3,Calcul_NB_Data),Sel_Office)","v":0},{"$f":"IF(OR(C10=0,MONTH(B10)<>MONTH(Calcul_FirstDate)),\"\", E10&CHAR(10)&F10&CHAR(10)&G10&CHAR(10)&H10&CHAR(10)&I10&CHAR(10)&J10&CHAR(10)&K10)","v":""},{"$f":"IF($C10<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C10<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K10) & \"/\" & $B10&Sel_Office,Data_ID_rng,0)))","v":""}]
[2,{"$f":"(ROWS(B$10:B11))-$B$3+$B$2","v":"2020-12-28"},0,"",{"$f":"IF($C11<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C11<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K11) & \"/\" & $B11&Sel_Office,Data_ID_rng,0)))","v":""}]
[3,{"$f":"(ROWS(B$10:B12))-$B$3+$B$2","v":"2020-12-29"},0,"",{"$f":"IF($C12<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C12<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K12) & \"/\" & $B12&Sel_Office,Data_ID_rng,0)))","v":""}]
[4,{"$f":"(ROWS(B$10:B13))-$B$3+$B$2","v":"2020-12-30"},0,"",{"$f":"IF($C13<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C13<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K13) & \"/\" & $B13&Sel_Office,Data_ID_rng,0)))","v":""}]
[5,{"$f":"(ROWS(B$10:B14))-$B$3+$B$2","v":"2020-12-31"},0,"",{"$f":"IF($C14<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C14<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K14) & \"/\" & $B14&Sel_Office,Data_ID_rng,0)))","v":""}]
[6,{"$f":"(ROWS(B$10:B15))-$B$3+$B$2","v":"2021-01-01"},0,"",{"$f":"IF($C15<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C15<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K15) & \"/\" & $B15&Sel_Office,Data_ID_rng,0)))","v":""}]
[7,{"$f":"(ROWS(B$10:B16))-$B$3+$B$2","v":"2021-01-02"},0,"",{"$f":"IF($C16<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C16<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K16) & \"/\" & $B16&Sel_Office,Data_ID_rng,0)))","v":""}]
[8,{"$f":"(ROWS(B$10:B17))-$B$3+$B$2","v":"2021-01-03"},0,"",{"$f":"IF($C17<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C17<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K17) & \"/\" & $B17&Sel_Office,Data_ID_rng,0)))","v":""}]
[9,{"$f":"(ROWS(B$10:B18))-$B$3+$B$2","v":"2021-01-04"},1,"09:00 Sample Meeting 3\n\n\n\n\n\n",{"$f":"IF($C18<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 3"},{"$f":"IF($C18<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C18<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C18<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C18<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C18<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C18<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K18) & \"/\" & $B18&Sel_Office,Data_ID_rng,0)))","v":""}]
[10,{"$f":"(ROWS(B$10:B19))-$B$3+$B$2","v":"2021-01-05"},1,"09:00 Sample Meeting 4\n\n\n\n\n\n",{"$f":"IF($C19<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 4"},{"$f":"IF($C19<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C19<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C19<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C19<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C19<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C19<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K19) & \"/\" & $B19&Sel_Office,Data_ID_rng,0)))","v":""}]
[11,{"$f":"(ROWS(B$10:B20))-$B$3+$B$2","v":"2021-01-06"},0,"",{"$f":"IF($C20<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C20<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K20) & \"/\" & $B20&Sel_Office,Data_ID_rng,0)))","v":""}]
[12,{"$f":"(ROWS(B$10:B21))-$B$3+$B$2","v":"2021-01-07"},0,"",{"$f":"IF($C21<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C21<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K21) & \"/\" & $B21&Sel_Office,Data_ID_rng,0)))","v":""}]
[13,{"$f":"(ROWS(B$10:B22))-$B$3+$B$2","v":"2021-01-08"},1,"09:00 Sample Meeting 7\n\n\n\n\n\n",{"$f":"IF($C22<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 7"},{"$f":"IF($C22<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C22<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C22<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C22<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C22<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C22<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K22) & \"/\" & $B22&Sel_Office,Data_ID_rng,0)))","v":""}]
[14,{"$f":"(ROWS(B$10:B23))-$B$3+$B$2","v":"2021-01-09"},0,"",{"$f":"IF($C23<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C23<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K23) & \"/\" & $B23&Sel_Office,Data_ID_rng,0)))","v":""}]
[15,{"$f":"(ROWS(B$10:B24))-$B$3+$B$2","v":"2021-01-10"},1,"09:30 Sample Meeting 9\n\n\n\n\n\n",{"$f":"IF($C24<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":"09:30 Sample Meeting 9"},{"$f":"IF($C24<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C24<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C24<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C24<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C24<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C24<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K24) & \"/\" & $B24&Sel_Office,Data_ID_rng,0)))","v":""}]
[16,{"$f":"(ROWS(B$10:B25))-$B$3+$B$2","v":"2021-01-11"},0,"",{"$f":"IF($C25<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C25<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K25) & \"/\" & $B25&Sel_Office,Data_ID_rng,0)))","v":""}]
[17,{"$f":"(ROWS(B$10:B26))-$B$3+$B$2","v":"2021-01-12"},1,"09:00 Sample Meeting 11\n\n\n\n\n\n",{"$f":"IF($C26<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 11"},{"$f":"IF($C26<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C26<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C26<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C26<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C26<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C26<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K26) & \"/\" & $B26&Sel_Office,Data_ID_rng,0)))","v":""}]
[18,{"$f":"(ROWS(B$10:B27))-$B$3+$B$2","v":"2021-01-13"},1,"09:00 Sample Meeting 12\n\n\n\n\n\n",{"$f":"IF($C27<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 12"},{"$f":"IF($C27<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C27<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C27<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C27<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C27<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C27<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K27) & \"/\" & $B27&Sel_Office,Data_ID_rng,0)))","v":""}]
[19,{"$f":"(ROWS(B$10:B28))-$B$3+$B$2","v":"2021-01-14"},1,"10:00 Sample Meeting 3\n\n\n\n\n\n",{"$f":"IF($C28<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":"10:00 Sample Meeting 3"},{"$f":"IF($C28<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C28<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C28<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C28<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C28<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C28<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K28) & \"/\" & $B28&Sel_Office,Data_ID_rng,0)))","v":""}]
[20,{"$f":"(ROWS(B$10:B29))-$B$3+$B$2","v":"2021-01-15"},1,"09:00 Sample Meeting 14\n\n\n\n\n\n",{"$f":"IF($C29<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":"09:00 Sample Meeting 14"},{"$f":"IF($C29<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C29<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C29<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C29<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C29<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C29<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K29) & \"/\" & $B29&Sel_Office,Data_ID_rng,0)))","v":""}]
[21,{"$f":"(ROWS(B$10:B30))-$B$3+$B$2","v":"2021-01-16"},1,"10:00 Sample Meeting 15\n\n\n\n\n\n",{"$f":"IF($C30<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":"10:00 Sample Meeting 15"},{"$f":"IF($C30<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C30<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C30<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C30<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C30<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C30<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K30) & \"/\" & $B30&Sel_Office,Data_ID_rng,0)))","v":""}]
[22,{"$f":"(ROWS(B$10:B31))-$B$3+$B$2","v":"2021-01-17"},1,"10:00 Sample Meeting 6\n\n\n\n\n\n",{"$f":"IF($C31<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":"10:00 Sample Meeting 6"},{"$f":"IF($C31<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C31<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C31<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C31<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C31<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C31<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K31) & \"/\" & $B31&Sel_Office,Data_ID_rng,0)))","v":""}]
[23,{"$f":"(ROWS(B$10:B32))-$B$3+$B$2","v":"2021-01-18"},1,"10:00 Sample Meeting 17\n\n\n\n\n\n",{"$f":"IF($C32<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":"10:00 Sample Meeting 17"},{"$f":"IF($C32<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C32<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C32<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C32<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C32<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C32<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K32) & \"/\" & $B32&Sel_Office,Data_ID_rng,0)))","v":""}]
[24,{"$f":"(ROWS(B$10:B33))-$B$3+$B$2","v":"2021-01-19"},1,{"$f":"IF(OR(C33=0,MONTH(B33)<>MONTH(Calcul_FirstDate)),\"\", E33&CHAR(10)&F33&CHAR(10)&G33&CHAR(10)&H33&CHAR(10)&I33&CHAR(10)&J33&CHAR(10)&K33)","v":"14:30 Sample Meeting 18\n\n\n\n\n\n"},{"$f":"IF($C33<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":"14:30 Sample Meeting 18"},{"$f":"IF($C33<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C33<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C33<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C33<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C33<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C33<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K33) & \"/\" & $B33&Sel_Office,Data_ID_rng,0)))","v":""}]
[25,{"$f":"(ROWS(B$10:B34))-$B$3+$B$2","v":"2021-01-20"},1,"15:30 Sample Meeting 19\n\n\n\n\n\n",{"$f":"IF($C34<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":"15:30 Sample Meeting 19"},{"$f":"IF($C34<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C34<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C34<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C34<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C34<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C34<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K34) & \"/\" & $B34&Sel_Office,Data_ID_rng,0)))","v":""}]
[26,{"$f":"(ROWS(B$10:B35))-$B$3+$B$2","v":"2021-01-21"},0,"",{"$f":"IF($C35<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C35<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K35) & \"/\" & $B35&Sel_Office,Data_ID_rng,0)))","v":""}]
[27,{"$f":"(ROWS(B$10:B36))-$B$3+$B$2","v":"2021-01-22"},0,"",{"$f":"IF($C36<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C36<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K36) & \"/\" & $B36&Sel_Office,Data_ID_rng,0)))","v":""}]
[28,{"$f":"(ROWS(B$10:B37))-$B$3+$B$2","v":"2021-01-23"},0,"",{"$f":"IF($C37<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C37<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K37) & \"/\" & $B37&Sel_Office,Data_ID_rng,0)))","v":""}]
[29,{"$f":"(ROWS(B$10:B38))-$B$3+$B$2","v":"2021-01-24"},0,"",{"$f":"IF($C38<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C38<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K38) & \"/\" & $B38&Sel_Office,Data_ID_rng,0)))","v":""}]
[30,{"$f":"(ROWS(B$10:B39))-$B$3+$B$2","v":"2021-01-25"},0,"",{"$f":"IF($C39<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C39<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K39) & \"/\" & $B39&Sel_Office,Data_ID_rng,0)))","v":""}]
[31,{"$f":"(ROWS(B$10:B40))-$B$3+$B$2","v":"2021-01-26"},0,"",{"$f":"IF($C40<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C40<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K40) & \"/\" & $B40&Sel_Office,Data_ID_rng,0)))","v":""}]
[32,{"$f":"(ROWS(B$10:B41))-$B$3+$B$2","v":"2021-01-27"},0,"",{"$f":"IF($C41<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C41<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K41) & \"/\" & $B41&Sel_Office,Data_ID_rng,0)))","v":""}]
[33,{"$f":"(ROWS(B$10:B42))-$B$3+$B$2","v":"2021-01-28"},0,"",{"$f":"IF($C42<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C42<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K42) & \"/\" & $B42&Sel_Office,Data_ID_rng,0)))","v":""}]
[34,{"$f":"(ROWS(B$10:B43))-$B$3+$B$2","v":"2021-01-29"},0,"",{"$f":"IF($C43<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C43<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K43) & \"/\" & $B43&Sel_Office,Data_ID_rng,0)))","v":""}]
[35,{"$f":"(ROWS(B$10:B44))-$B$3+$B$2","v":"2021-01-30"},0,"",{"$f":"IF($C44<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C44<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K44) & \"/\" & $B44&Sel_Office,Data_ID_rng,0)))","v":""}]
[36,{"$f":"(ROWS(B$10:B45))-$B$3+$B$2","v":"2021-01-31"},0,"",{"$f":"IF($C45<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C45<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K45) & \"/\" & $B45&Sel_Office,Data_ID_rng,0)))","v":""}]
[37,{"$f":"(ROWS(B$10:B46))-$B$3+$B$2","v":"2021-02-01"},0,"",{"$f":"IF($C46<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C46<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K46) & \"/\" & $B46&Sel_Office,Data_ID_rng,0)))","v":""}]
[38,{"$f":"(ROWS(B$10:B47))-$B$3+$B$2","v":"2021-02-02"},0,"",{"$f":"IF($C47<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C47<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K47) & \"/\" & $B47&Sel_Office,Data_ID_rng,0)))","v":""}]
[39,{"$f":"(ROWS(B$10:B48))-$B$3+$B$2","v":"2021-02-03"},0,"",{"$f":"IF($C48<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C48<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K48) & \"/\" & $B48&Sel_Office,Data_ID_rng,0)))","v":""}]
[40,{"$f":"(ROWS(B$10:B49))-$B$3+$B$2","v":"2021-02-04"},0,"",{"$f":"IF($C49<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C49<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K49) & \"/\" & $B49&Sel_Office,Data_ID_rng,0)))","v":""}]
[41,{"$f":"(ROWS(B$10:B50))-$B$3+$B$2","v":"2021-02-05"},0,"",{"$f":"IF($C50<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C50<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K50) & \"/\" & $B50&Sel_Office,Data_ID_rng,0)))","v":""}]
[42,{"$f":"(ROWS(B$10:B51))-$B$3+$B$2","v":"2021-02-06"},0,"",{"$f":"IF($C51<1,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:E51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<2,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:F51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<3,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:G51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<4,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:H51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<5,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:I51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<6,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:J51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""},{"$f":"IF($C51<7,\"\",INDEX(Data_Concatenate_rng,MATCH(COLUMNS($E$10:K51) & \"/\" & $B51&Sel_Office,Data_ID_rng,0)))","v":""}]
[]
[]
[]
[]
[{"$nulls":3},"Calculate Location",null,{"$f":"COLUMNS($C60:C60)","v":1}]
[]
[]
["Locations","Row in Locations","Office","Meeting Name","Meeting Location","Contact Name","Contact email","Contact Phone"]
[1,{"$f":"MATCH(A60,Tbl_Meetings[LocationCount],0)","v":3},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,4))","v":"office1"},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,3))","v":"Sample Meeting 3"},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,5))","v":"Sample location 3"},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,6))","v":"Name 2"},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B60),\"\",INDEX(Tbl_Meetings[],$B60,8))","v":"555-555-555"}]
[2,{"$f":"MATCH(A61,Tbl_Meetings[LocationCount],0)","v":4},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,4))","v":"office1"},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,3))","v":"Sample Meeting 4"},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,5))","v":"Sample location 4"},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,6))","v":"Name 3"},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B61),\"\",INDEX(Tbl_Meetings[],$B61,8))","v":"555-555-555"}]
[3,{"$f":"MATCH(A62,Tbl_Meetings[LocationCount],0)","v":7},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,4))","v":"office1"},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,3))","v":"Sample Meeting 7"},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,5))","v":"Sample location 7"},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,6))","v":"Name 6"},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B62),\"\",INDEX(Tbl_Meetings[],$B62,8))","v":"555-555-555"}]
[4,{"$f":"MATCH(A63,Tbl_Meetings[LocationCount],0)","v":9},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,4))","v":"office1"},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,3))","v":"Sample Meeting 9"},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,5))","v":"Sample location 9"},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,6))","v":"Name 8"},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B63),\"\",INDEX(Tbl_Meetings[],$B63,8))","v":"555-555-555"}]
[5,{"$f":"MATCH(A64,Tbl_Meetings[LocationCount],0)","v":11},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,4))","v":"office1"},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,3))","v":"Sample Meeting 11"},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,5))","v":"Sample location 4"},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,6))","v":"Name 10"},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B64),\"\",INDEX(Tbl_Meetings[],$B64,8))","v":"555-555-555"}]
[6,{"$f":"MATCH(A65,Tbl_Meetings[LocationCount],0)","v":12},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,4))","v":"office1"},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,3))","v":"Sample Meeting 12"},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,5))","v":"Sample location 12"},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,6))","v":"Name 1"},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B65),\"\",INDEX(Tbl_Meetings[],$B65,8))","v":"555-555-555"}]
[7,{"$f":"MATCH(A66,Tbl_Meetings[LocationCount],0)","v":13},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,4))","v":"office1"},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,3))","v":"Sample Meeting 3"},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,5))","v":"Sample location 13"},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,6))","v":"Name 2"},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B66),\"\",INDEX(Tbl_Meetings[],$B66,8))","v":"555-555-555"}]
[8,{"$f":"MATCH(A67,Tbl_Meetings[LocationCount],0)","v":14},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,4))","v":"office1"},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,3))","v":"Sample Meeting 14"},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,5))","v":"Sample location 1"},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,6))","v":"Name 13"},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B67),\"\",INDEX(Tbl_Meetings[],$B67,8))","v":"555-555-555"}]
[9,{"$f":"MATCH(A68,Tbl_Meetings[LocationCount],0)","v":15},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,4))","v":"office1"},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,3))","v":"Sample Meeting 15"},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,5))","v":"Sample location 15"},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,6))","v":"Name 14"},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B68),\"\",INDEX(Tbl_Meetings[],$B68,8))","v":"555-555-555"}]
[10,{"$f":"MATCH(A69,Tbl_Meetings[LocationCount],0)","v":16},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,4))","v":"office1"},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,3))","v":"Sample Meeting 6"},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,5))","v":"Sample location 2"},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,6))","v":"Name 15"},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B69),\"\",INDEX(Tbl_Meetings[],$B69,8))","v":"555-555-555"}]
[11,{"$f":"MATCH(A70,Tbl_Meetings[LocationCount],0)","v":17},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,4))","v":"office1"},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,3))","v":"Sample Meeting 17"},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,5))","v":"Sample location 17"},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,6))","v":"Name 16"},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B70),\"\",INDEX(Tbl_Meetings[],$B70,8))","v":"555-555-555"}]
[12,{"$f":"MATCH(A71,Tbl_Meetings[LocationCount],0)","v":18},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,4))","v":"office1"},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,3))","v":"Sample Meeting 18"},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,5))","v":"Sample location 18"},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,6))","v":"Name 17"},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B71),\"\",INDEX(Tbl_Meetings[],$B71,8))","v":"555-555-555"}]
[13,{"$f":"MATCH(A72,Tbl_Meetings[LocationCount],0)","v":19},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,4))","v":"office1"},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,3))","v":"Sample Meeting 19"},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,5))","v":"Sample location 19"},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,6))","v":"Name 18"},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,7))","v":"email1@email.com"},{"$f":"IF(ISERROR($B72),\"\",INDEX(Tbl_Meetings[],$B72,8))","v":"555-555-555"}]
[14,{"$f":"MATCH(A73,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,4))","v":""},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,3))","v":""},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,5))","v":""},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,6))","v":""},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,7))","v":""},{"$f":"IF(ISERROR($B73),\"\",INDEX(Tbl_Meetings[],$B73,8))","v":""}]
[15,{"$f":"MATCH(A74,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,4))","v":""},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,3))","v":""},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,5))","v":""},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,6))","v":""},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,7))","v":""},{"$f":"IF(ISERROR($B74),\"\",INDEX(Tbl_Meetings[],$B74,8))","v":""}]
[16,{"$f":"MATCH(A75,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,4))","v":""},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,3))","v":""},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,5))","v":""},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,6))","v":""},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,7))","v":""},{"$f":"IF(ISERROR($B75),\"\",INDEX(Tbl_Meetings[],$B75,8))","v":""}]
[17,{"$f":"MATCH(A76,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,4))","v":""},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,3))","v":""},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,5))","v":""},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,6))","v":""},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,7))","v":""},{"$f":"IF(ISERROR($B76),\"\",INDEX(Tbl_Meetings[],$B76,8))","v":""}]
[18,{"$f":"MATCH(A77,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,4))","v":""},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,3))","v":""},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,5))","v":""},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,6))","v":""},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,7))","v":""},{"$f":"IF(ISERROR($B77),\"\",INDEX(Tbl_Meetings[],$B77,8))","v":""}]
[19,{"$f":"MATCH(A78,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,4))","v":""},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,3))","v":""},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,5))","v":""},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,6))","v":""},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,7))","v":""},{"$f":"IF(ISERROR($B78),\"\",INDEX(Tbl_Meetings[],$B78,8))","v":""}]
[20,{"$f":"MATCH(A79,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,4))","v":""},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,3))","v":""},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,5))","v":""},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,6))","v":""},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,7))","v":""},{"$f":"IF(ISERROR($B79),\"\",INDEX(Tbl_Meetings[],$B79,8))","v":""}]
[21,{"$f":"MATCH(A80,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,4))","v":""},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,3))","v":""},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,5))","v":""},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,6))","v":""},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,7))","v":""},{"$f":"IF(ISERROR($B80),\"\",INDEX(Tbl_Meetings[],$B80,8))","v":""}]
[22,{"$f":"MATCH(A81,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,4))","v":""},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,3))","v":""},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,5))","v":""},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,6))","v":""},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,7))","v":""},{"$f":"IF(ISERROR($B81),\"\",INDEX(Tbl_Meetings[],$B81,8))","v":""}]
[23,{"$f":"MATCH(A82,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,4))","v":""},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,3))","v":""},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,5))","v":""},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,6))","v":""},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,7))","v":""},{"$f":"IF(ISERROR($B82),\"\",INDEX(Tbl_Meetings[],$B82,8))","v":""}]
[24,{"$f":"MATCH(A83,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,4))","v":""},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,3))","v":""},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,5))","v":""},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,6))","v":""},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,7))","v":""},{"$f":"IF(ISERROR($B83),\"\",INDEX(Tbl_Meetings[],$B83,8))","v":""}]
[25,{"$f":"MATCH(A84,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,4))","v":""},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,3))","v":""},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,5))","v":""},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,6))","v":""},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,7))","v":""},{"$f":"IF(ISERROR($B84),\"\",INDEX(Tbl_Meetings[],$B84,8))","v":""}]
[26,{"$f":"MATCH(A85,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,4))","v":""},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,3))","v":""},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,5))","v":""},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,6))","v":""},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,7))","v":""},{"$f":"IF(ISERROR($B85),\"\",INDEX(Tbl_Meetings[],$B85,8))","v":""}]
[27,{"$f":"MATCH(A86,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,4))","v":""},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,3))","v":""},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,5))","v":""},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,6))","v":""},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,7))","v":""},{"$f":"IF(ISERROR($B86),\"\",INDEX(Tbl_Meetings[],$B86,8))","v":""}]
[28,{"$f":"MATCH(A87,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,4))","v":""},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,3))","v":""},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,5))","v":""},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,6))","v":""},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,7))","v":""},{"$f":"IF(ISERROR($B87),\"\",INDEX(Tbl_Meetings[],$B87,8))","v":""}]
[null,{"$f":"MATCH(A88,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,4))","v":""},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,3))","v":""},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,5))","v":""},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,6))","v":""},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,7))","v":""},{"$f":"IF(ISERROR($B88),\"\",INDEX(Tbl_Meetings[],$B88,8))","v":""}]
[null,{"$f":"MATCH(A89,Tbl_Meetings[LocationCount],0)","v":{"$error":"#N/A"}},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,4))","v":""},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,3))","v":""},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,5))","v":""},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,6))","v":""},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,7))","v":""},{"$f":"IF(ISERROR($B89),\"\",INDEX(Tbl_Meetings[],$B89,8))","v":""}]