{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Participants","Assignments","11-21-2011 Master","11-22-2011 Master"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Participants","index":0,"n_rows":59,"n_cols":5,"rows_kept":59,"cut":false,"hidden":false,"merged":[[4,0,4,2]]}
["Instructions:","1) Add participant names in Table 1 and additional times if needed in Table 2."]
[null,"2) Do NOT modify cells in red because they are formula generated."]
[null,"3) Do NOT leave a name in the list if that person is not going to participate in the conference.  An Itinerary will be generated for every person in this list."]
[]
["Table 1",null,null,null,"Table 2"]
["First Name","Last Name","Full Name",null,"Time"]
[null,null,"All Participants",null,"07:00:00"]
["Harp","Biz",{"$f":"CONCATENATE(B8,\", \",A8)","v":"Biz, Harp"},null,"07:15:00"]
["Nick","Bosser","Bosser, Nick",null,"07:30:00"]
["Sherry","Boyle","Boyle, Sherry",null,"07:45:00"]
["Barbara","Butler","Butler, Barbara",null,"08:00:00"]
["Heimer","Dinger","Dinger, Heimer",null,"08:15:00"]
["Nancy","Drew","Drew, Nancy",null,"08:30:00"]
["Viktor","Frankl","Frankl, Viktor",null,"08:45:00"]
["Bill","Gould","Gould, Bill",null,"09:00:00"]
["Jingle","Mace","Mace, Jingle",null,"09:15:00"]
["Karen","Meyers","Meyers, Karen",null,"09:30:00"]
["Sam","Prather","Prather, Sam",null,"09:45:00"]
["Alexander","Romanov","Romanov, Alexander",null,"10:00:00"]
["Jerry","Seinfeld","Seinfeld, Jerry",null,"10:15:00"]
["John","Smith","Smith, John",null,"10:30:00"]
["Jessica","Staple","Staple, Jessica",null,"10:45:00"]
["Max","Steel","Steel, Max",null,"11:00:00"]
["Kate","Williams","Williams, Kate",null,"11:15:00"]
["Jacob","Wilson","Wilson, Jacob",null,"11:30:00"]
["John","Hancock",{"$f":"CONCATENATE(B26,\", \",A26)","v":"Hancock, John"},null,"11:45:00"]
["Johnathan","Meechen",{"$f":"CONCATENATE(B27,\", \",A27)","v":"Meechen, Johnathan"},null,"12:00:00"]
[null,null,null,null,"12:15:00"]
[null,null,null,null,"12:30:00"]
[null,null,null,null,"12:45:00"]
[null,null,null,null,"13:00:00"]
[null,null,null,null,"13:15:00"]
[null,null,null,null,"13:30:00"]
[null,null,null,null,"13:45:00"]
[null,null,null,null,"14:00:00"]
[null,null,null,null,"14:15:00"]
[null,null,null,null,"14:30:00"]
[null,null,null,null,"14:45:00"]
[null,null,null,null,"15:00:00"]
[null,null,null,null,"15:15:00"]
[null,null,null,null,"15:30:00"]
[null,null,null,null,"15:45:00"]
[null,null,null,null,"16:00:00"]
[null,null,null,null,"16:15:00"]
[null,null,null,null,"16:30:00"]
[null,null,null,null,"16:45:00"]
[null,null,null,null,"17:00:00"]
[null,null,null,null,"17:15:00"]
[null,null,null,null,"17:30:00"]
[null,null,null,null,"17:45:00"]
[null,null,null,null,"18:00:00"]
[null,null,null,null,"18:15:00"]
[null,null,null,null,"18:30:00"]
[null,null,null,null,"18:45:00"]
[null,null,null,null,"19:00:00"]
[null,null,null,null,"19:15:00"]
[null,null,null,null,"19:30:00"]
[null,null,null,null,"19:45:00"]
[null,null,null,null,"20:00:00"]

{"sheet":"Assignments","index":1,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Instructions:","1) Appointments must be a part of the table and must be in ordered by date.  Ordering by time is not important."]
[null,"2) The \"Generate Master\" button will remove any additional sheets after this one.  That includes previously generated master schedule sheets or user-created sheets."]
[]
[]
[]
[]
[]
[]
["Date","Start Time","End Time","Location","Official","Vert. Align","Attendee 1","Attendee 2","Attendee 3","Attendee 4","Attendee 5","Attendee 6","Attendee 7","Attendee 8","Attendee 9","Attendee 10"]
["2011-11-21","14:30:00","16:15:00","456 Wilbur","Green","Yes","Biz, Harp","Dinger, Heimer","Meyers, Karen","Romanov, Alexander","Seinfeld, Jerry"]
["2011-11-21","12:30:00","13:45:00","435 Heber","Brown","No","Frankl, Viktor","Staple, Jessica","Williams, Kate","Steel, Max","Butler, Barbara"]
["2011-11-21","10:45:00","11:15:00","234 Tanner","Pelosi","No","Butler, Barbara","Bosser, Nick","Gould, Bill","Wilson, Jacob","Drew, Nancy"]
["2011-11-22","18:00:00","19:45:00","123 Somewhere","Blue","No","Biz, Harp","Bosser, Nick","Boyle, Sherry","Butler, Barbara","Dinger, Heimer"]
["2011-11-22","14:45:00","15:45:00","Local","Apple","Yes","All Participants"]
["2011-11-22","08:45:00","09:45:00","321 Tanner","Red","No","Gould, Bill","Dinger, Heimer","Frankl, Viktor","Biz, Harp","Wilson, Jacob"]
["2011-11-22","07:45:00","08:00:00","ICA","Orange","Yes","Butler, Barbara","Drew, Nancy"]

{"sheet":"11-21-2011 Master","index":2,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[31,10,38,10],[31,12,38,12],[31,13,38,13],[23,7,28,7],[23,4,28,4],[16,4,18,4],[16,2,18,2],[16,8,18,8],[31,1,38,1],[31,5,38,5],[16,19,18,19],[16,6,18,6],[23,15,28,15],[23,18,28,18],[23,16,28,16]]}
[null,"Biz, Harp","Bosser, Nick","Boyle, Sherry","Butler, Barbara","Dinger, Heimer","Drew, Nancy","Frankl, Viktor","Gould, Bill","Mace, Jingle","Meyers, Karen","Prather, Sam","Romanov, Alexander","Seinfeld, Jerry","Smith, John","Staple, Jessica","Steel, Max",null,"Williams, Kate","Wilson, Jacob","Hancock, John","Meechen, Johnathan"]
["07:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:00:00"]
["07:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:15:00"]
["07:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:30:00"]
["07:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:45:00"]
["08:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:00:00"]
["08:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:15:00"]
["08:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:30:00"]
["08:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:45:00"]
["09:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:00:00"]
["09:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:15:00"]
["09:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:30:00"]
["09:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:45:00"]
["10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:00:00"]
["10:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:15:00"]
["10:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:30:00"]
["10:45:00",null,"10:45 AM Pelosi (Butler, Bosser, Gould, Wilson, Drew) 234 Tanner",null,"10:45 AM Pelosi (Butler, Bosser, Gould, Wilson, Drew) 234 Tanner",null,"10:45 AM Pelosi (Butler, Bosser, Gould, Wilson, Drew) 234 Tanner",null,"10:45 AM Pelosi (Butler, Bosser, Gould, Wilson, Drew) 234 Tanner",null,null,null,null,null,null,null,null,"10:45:00",null,"10:45 AM Pelosi (Butler, Bosser, Gould, Wilson, Drew) 234 Tanner"]
["11:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:00:00"]
["11:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:15:00"]
["11:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:30:00"]
["11:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:45:00"]
["12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:00:00"]
["12:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:15:00"]
["12:30:00",null,null,null,"12:30 PM Brown (Frankl, Staple, Williams, Steel, Butler) 435 Heber",null,null,"12:30 PM Brown (Frankl, Staple, Williams, Steel, Butler) 435 Heber",null,null,null,null,null,null,null,"12:30 PM Brown (Frankl, Staple, Williams, Steel, Butler) 435 Heber","12:30 PM Brown (Frankl, Staple, Williams, Steel, Butler) 435 Heber","12:30:00","12:30 PM Brown (Frankl, Staple, Williams, Steel, Butler) 435 Heber"]
["12:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:45:00"]
["13:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:00:00"]
["13:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:15:00"]
["13:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:30:00"]
["13:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:45:00"]
["14:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:00:00"]
["14:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:15:00"]
["14:30:00","02:30 PM Green (Biz, Dinger, Meyers, Romanov, Seinfeld) 456 Wilbur",null,null,null,"02:30 PM Green (Biz, Dinger, Meyers, Romanov, Seinfeld) 456 Wilbur",null,null,null,null,"02:30 PM Green (Biz, Dinger, Meyers, Romanov, Seinfeld) 456 Wilbur",null,"02:30 PM Green (Biz, Dinger, Meyers, Romanov, Seinfeld) 456 Wilbur","02:30 PM Green (Biz, Dinger, Meyers, Romanov, Seinfeld) 456 Wilbur",null,null,null,"14:30:00"]
["14:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:45:00"]
["15:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:00:00"]
["15:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:15:00"]
["15:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:30:00"]
["15:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:45:00"]
["16:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:00:00"]
["16:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:15:00"]
["16:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:30:00"]
["16:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:45:00"]
["17:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:00:00"]
["17:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:15:00"]
["17:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:30:00"]
["17:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:45:00"]
["18:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:00:00"]
["18:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:15:00"]
["18:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:30:00"]
["18:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:45:00"]
["19:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:00:00"]
["19:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:15:00"]
["19:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:30:00"]
["19:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:45:00"]
["20:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20:00:00"]

{"sheet":"11-22-2011 Master","index":3,"n_rows":54,"n_cols":22,"rows_kept":54,"cut":false,"hidden":false,"merged":[[45,1,52,1],[45,2,52,2],[45,3,52,3],[45,4,52,4],[45,5,52,5],[32,20,36,20],[32,21,36,21],[8,8,12,8],[8,5,12,5],[8,7,12,7],[32,12,36,12],[32,13,36,13],[32,14,36,14],[32,15,36,15],[32,16,36,16],[32,18,36,18],[32,6,36,6],[32,7,36,7],[32,8,36,8],[32,9,36,9],[32,10,36,10],[8,1,12,1],[8,19,12,19],[4,4,5,4],[4,6,5,6],[32,19,36,19],[32,11,36,11],[32,1,36,1],[32,2,36,2],[32,3,36,3],[32,4,36,4],[32,5,36,5]]}
[null,"Biz, Harp","Bosser, Nick","Boyle, Sherry","Butler, Barbara","Dinger, Heimer","Drew, Nancy","Frankl, Viktor","Gould, Bill","Mace, Jingle","Meyers, Karen","Prather, Sam","Romanov, Alexander","Seinfeld, Jerry","Smith, John","Staple, Jessica","Steel, Max",null,"Williams, Kate","Wilson, Jacob","Hancock, John","Meechen, Johnathan"]
["07:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:00:00"]
["07:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:15:00"]
["07:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:30:00"]
["07:45:00",null,null,null,"07:45 AM Orange (Butler, Drew) ICA",null,"07:45 AM Orange (Butler, Drew) ICA",null,null,null,null,null,null,null,null,null,null,"07:45:00"]
["08:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:00:00"]
["08:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:15:00"]
["08:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08:30:00"]
["08:45:00","08:45 AM Red (Gould, Dinger, Frankl, Biz, Wilson) 321 Tanner",null,null,null,"08:45 AM Red (Gould, Dinger, Frankl, Biz, Wilson) 321 Tanner",null,"08:45 AM Red (Gould, Dinger, Frankl, Biz, Wilson) 321 Tanner","08:45 AM Red (Gould, Dinger, Frankl, Biz, Wilson) 321 Tanner",null,null,null,null,null,null,null,null,"08:45:00",null,"08:45 AM Red (Gould, Dinger, Frankl, Biz, Wilson) 321 Tanner"]
["09:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:00:00"]
["09:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:15:00"]
["09:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:30:00"]
["09:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09:45:00"]
["10:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:00:00"]
["10:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:15:00"]
["10:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:30:00"]
["10:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10:45:00"]
["11:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:00:00"]
["11:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:15:00"]
["11:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:30:00"]
["11:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11:45:00"]
["12:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:00:00"]
["12:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:15:00"]
["12:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:30:00"]
["12:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12:45:00"]
["13:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:00:00"]
["13:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:15:00"]
["13:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:30:00"]
["13:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"13:45:00"]
["14:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:00:00"]
["14:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:15:00"]
["14:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14:30:00"]
["14:45:00","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","14:45:00","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local","02:45 PM Apple (All Participants) Local"]
["15:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:00:00"]
["15:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:15:00"]
["15:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:30:00"]
["15:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15:45:00"]
["16:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:00:00"]
["16:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:15:00"]
["16:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:30:00"]
["16:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16:45:00"]
["17:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:00:00"]
["17:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:15:00"]
["17:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:30:00"]
["17:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17:45:00"]
["18:00:00","06:00 PM Blue (Biz, Bosser, Boyle, Butler, Dinger) 123 Somewhere","06:00 PM Blue (Biz, Bosser, Boyle, Butler, Dinger) 123 Somewhere","06:00 PM Blue (Biz, Bosser, Boyle, Butler, Dinger) 123 Somewhere","06:00 PM Blue (Biz, Bosser, Boyle, Butler, Dinger) 123 Somewhere","06:00 PM Blue (Biz, Bosser, Boyle, Butler, Dinger) 123 Somewhere",null,null,null,null,null,null,null,null,null,null,null,"18:00:00"]
["18:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:15:00"]
["18:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:30:00"]
["18:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18:45:00"]
["19:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:00:00"]
["19:15:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:15:00"]
["19:30:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:30:00"]
["19:45:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19:45:00"]
["20:00:00",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"20:00:00"]