{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["> AI LIST <","••Calendar","••AI List Support","> HELP <","<Add Your Sheets Here>"],"not_rendered":{"charts":0,"images":26,"macros":1,"external_links":0,"defined_names":68,"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":"> AI LIST <","index":0,"n_rows":113,"n_cols":23,"rows_kept":113,"cut":false,"hidden":false,"merged":[[39,1,39,14],[31,1,31,14],[1,1,1,14],[28,1,28,3],[6,1,6,14],[4,1,4,14],[20,1,20,14],[22,1,22,13],[23,1,23,13],[24,1,24,13],[25,1,25,13],[26,1,26,13],[29,1,29,14]]}
[]
[null,"◢ Open"]
[null,null,"☐",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C3=\"☑\",\"[9],Closed\",IF(COUNTA(E3:O3)=0,\"[0],New (since last sort)\",\"[1],Open\"))","v":"[0],New (since last sort)"},{"$f":"IF($C3=\"☑\",\"[9],Closed\",IF(COUNTA($E3:$O3)=0,\"[0],New (since last sort)\",IF(K3=\"\",\"[8],None\",IF(K3<TODAY(),\"[1],Past Due\",IF(K3=TODAY(),\"[2],Due Today\",IF(K3<TODAY()+7,\"[3],Due Within 1 Week\",IF(K3<TODAY()+30,\"[4],Due Within 1 Month\",\"[5],Due Beyond 1 Month\")))))))","v":"[0],New (since last sort)"},{"$f":"IF($C3=\"☑\",\"[9],Closed\",IF(COUNTA($E3:$O3)=0,\"[0],New (since last sort)\",IF(N3=\"\",\"[8],None\",IF(N3>=TODAY(),\"[1],Created Today\",IF(N3>TODAY()-7,\"[2],Created Within 1 Week\",IF(N3>TODAY()-30,\"[3],Created Within 1 Month\",IF(N3>TODAY()+90,\"[4],Created Within 3 Months\",\"[5],Created Over 3 Months Ago\")))))))","v":"[0],New (since last sort)"},{"$f":"IF($C3=\"☑\",\"[9],Closed\",IF(COUNTA($E3:$O3)=0,\"[0],New (since last sort)\",IF(O3=\"\",\"[8],None\",IF(O3>=TODAY(),\"[1],Updated Today\",IF(O3>TODAY()-7,\"[2],Updated Within 1 Week\",IF(O3>TODAY()-30,\"[3],Updated Within 1 Month\",IF(O3>TODAY()+90,\"[4],Updated Within 3 Months\",\"[5],Updated Over 3 Months Ago\")))))))","v":"[0],New (since last sort)"},{"$f":"AND($C3<>\"☑\",$K3>0,$K3<TODAY())","v":false}]
[]
[null,"◢ New (since last sort)"]
[]
[null,"◢ Closed"]
["Default Column widths",3,4,4,15,15,30,60,13,10,16,15,26,16,16]
[null,"◢","☐"," ▾"]
[null,"▶","☑"," ▴"]
[{"$f":"\"Detail Range Key (Column Names Row,Detail Row Start,Detail Column Start):\"&ROW(AIDetailRangeKey)&\",\"&ROW(B29)+1&\",\"&COLUMN(B29)","v":"Detail Range Key (Column Names Row,Detail Row Start,Detail Column Start):11,30,2"},"AICollapseCol","AIClosedCol","AINumCol","AICategoryCol","AISubcategoryCol","AIActionCol","AIDescCol","AIRespCol","AIPriorityCol","AIDueCol","AIStatusCol","AICommentCol","AICreatedCol","AIUpdatedCol","AIUniqueIDCol","AILastSyncCol","AIFullFileNameAtSyncCol","AINewOpenClosedCol","AIDueGroupCol","AICreatedGroupCol","AIUpdatedGroupCol"]
[null,null,null,{"$f":"IF(AITitle<>\" \",IF(ISERROR(SEARCH(\"AI List\",AITitle)),\"AI List:  \",\"\") & AITitle,IF(ISERROR(SEARCH(\"AI List\",AIFilename)),\"AI List:  \",\"\") & AIFilename) & AIFileNameEndText","v":"AI List:  TSMAD Actions "},null,null,null,null,null,null,null," "," "," "," "]
[]
[null,{"$f":"\"Last Updated:  \" & IF(MAX($O:$O)<1000,\"\",TEXT(MAX($O:$O),AIDateFormat)) & \"                    Open:  \" & COUNTIF($S:$S,\"[1],Open\") & IF(AIHiddenVisibility,\"\",\"*\") & \"                    Past Due:  \" &COUNTIF($W:$W,TRUE)","v":"Last Updated:  Mon 5/19/2014                    Open:  36                    Past Due:  1"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(AIUserVersion=\"CUser\",AIUserVersion=\"RecentCUser\"),\"\",IF(AICustomMode >= 2,\"*Customized Version*\",IF(AICustomMode = 1, \"(Customized Version)\", \"(Free Version)\")))","v":"(Free Version)"}]
[]
[null,null,"Enter custom details about this AI List"]
[]
[null,null,null,null,"asdg"]
[]
[]
[null,"Interested in customizing this AI List, or automating your other Excel files?\nExcel Automation Help specializes in custom software automation within Excel.  Contact us at:\n                                                              \nwww.ExcelAutomationHelp.com  | +1 315-805-HELP  |  Help@ExcelAutomationHelp.com"]
[]
[null,"◄GRAPHICAL NOTICE►  Our periodic auto-check discovered that some graphical features have been removed from this file by an older version of Excel.  To restore these features, open an Excel 2007 version file in Excel 2007 and use 'Import AI List' to bring over this file's data to the Excel 2007 version."]
[null,"◄AUTOMATION DISABLED►  You must “Enable Macros” for this automated file to function.  In some cases, you may be prompted to enable macros while opening this file, or along the top of this opened excel sheet.  Refer to the 'More Help' section within the excel sheet labeled > HELP < for detailed instructions on how to permanently enable macros, and avoid this issue."]
[null,"◄EXCEL 2003 FILE NEEDED►  This version of the AI List file was optimized for newer Excel, and possibly broken when not properly converted to Excel 2003.  Ask the original file user to SaveAs the original file to an Excel 2003 ‘.xls’ (not ‘.xlsm’) file, from their Excel 2007 or newer application, before it is used in Excel 2003."]
[null,"◄BROKEN BY EXCEL 2003►  This version of the AI List file was incorrectly converted by Excel 2003.  This can be corrected by asking the original file user to SaveAs the original file to an Excel 2003 ‘.xls’ (not ‘.xlsm’) file, from their Excel 2007 or newer application."]
[null,"RESTRICTED PERFORMANCE:  Our periodic auto-check discovered that this version of the AI List file was optimized for Excel 2003 and older.  If you do not need Excel 2003 users to be in this file, ask the original file user for the “Excel 2007 or newer” version, then use its 'Import AI List' feature."]
[]
[null,"AI#",null,null,"Category ▾","Subcategory","Subject","Action","Person","Priority","Due","Status","Comment","Created","Updated","Unique ID","Last Sync","FullFIleName At Sync","New Open Closed","Due Group","Created Group","Updated Group","Past Due"]
[null,"◢ New (since last sort)"]
[null,null,"☐",39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(C31=\"☑\",\"[9],Closed\",IF(COUNTA(E31:O31)=0,\"[0],New (since last sort)\",\"[1],Open\"))","v":"[0],New (since last sort)"},{"$f":"IF($C31=\"☑\",\"[9],Closed\",IF(COUNTA($E31:$O31)=0,\"[0],New (since last sort)\",IF(K31=\"\",\"[8],None\",IF(K31<TODAY(),\"[1],Past Due\",IF(K31=TODAY(),\"[2],Due Today\",IF(K31<TODAY()+7,\"[3],Due Within 1 Week\",IF(K31<TODAY()+30,\"[4],Due Within 1 Month\",\"[5],Due Beyond 1 Month\")))))))","v":"[0],New (since last sort)"},{"$f":"IF($C31=\"☑\",\"[9],Closed\",IF(COUNTA($E31:$O31)=0,\"[0],New (since last sort)\",IF(N31=\"\",\"[8],None\",IF(N31>=TODAY(),\"[1],Created Today\",IF(N31>TODAY()-7,\"[2],Created Within 1 Week\",IF(N31>TODAY()-30,\"[3],Created Within 1 Month\",IF(N31>TODAY()+90,\"[4],Created Within 3 Months\",\"[5],Created Over 3 Months Ago\")))))))","v":"[0],New (since last sort)"},{"$f":"IF($C31=\"☑\",\"[9],Closed\",IF(COUNTA($E31:$O31)=0,\"[0],New (since last sort)\",IF(O31=\"\",\"[8],None\",IF(O31>=TODAY(),\"[1],Updated Today\",IF(O31>TODAY()-7,\"[2],Updated Within 1 Week\",IF(O31>TODAY()-30,\"[3],Updated Within 1 Month\",IF(O31>TODAY()+90,\"[4],Updated Within 3 Months\",\"[5],Updated Over 3 Months Ago\")))))))","v":"[0],New (since last sort)"},{"$f":"AND($C31<>\"☑\",$K31>0,$K31<TODAY())","v":false}]
[null,"◢ TSMAD27"]
[null,null,"☐",1,"TSMAD27",null,"4.1.1","TSMAD to take into consideration the comments reported in paper HSSC5-INF2 (Appendix to Annex A), for inclusion in the next edition of the Use of the Object Catalogue (S-57, Appendix B.1, Annex A).  It was decided to develop a peper on this for HSSC6","RF/JW",null,null,null,null,null,"2014-05-16T16:02:22","5/29/2012-12:40:00 AM-11142",null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",2,"TSMAD27",null,"4.1.1","TSMAD chair to include an additional item in the TSMAD work plan to review the S-100 Master Plan annually.  Needs to be completed and will be reviewed annually at HSSC.","BG",null,null,null,null,null,"2014-05-16T16:04:36",null,null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",3,"TSMAD27",null,"4.1.1","Provide a paper and recommendations on what S-58 checks should be included as part of S-101 – for TSMAD 29. ","RF/JP",1,null,null,null,null,"2014-05-16T16:04:45","5/29/2012-12:40:59 AM-121989",null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",4,"TSMAD27",null,"4.5.2A","Remodel the concept for inshore and offshore (structures on the land and on the sea). ","RF/JW",1,null,null,null,null,"2014-05-16T16:05:41","5/29/2012-12:41:00 AM-817727","2012-11-14T11:09:26","T:\\AI List\\AI List v3.63 (...Limited Release Beta)\\AI List - BLANK TEMPLATE v3.62a.xlsm","[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",5,"TSMAD27",null,"4.5.2A","Amend the UOC for coastline references dock area. ","JW",null,null,null,null,null,"2014-05-16T16:06:12","7/10/2012-4:07:28 PM-106369",null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",6,"TSMAD27",null,"4.8.1B","Revise paragraph 1 of the UOC section 6.3.2 to make it consistent with the proposed amendment to the UOC section 6.2.1 that are proposed in paper TSMAD27-4.8.1. ","JW",null,null,null,null,null,"2014-05-16T16:07:05",null,null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",7,"TSMAD27",null,"4.8.1B","Produce an Encoding Bulletin providing guidance on “areas to be avoided” as proposed in paper TSMAD27-4.8.1B.","JW",null,"2014-01-02",null,null,null,"2014-05-16T16:07:58","5/29/2012-12:41:07 AM-563217",null,null,"[1],Open","[1],Past Due","[8],None","[2],Updated Within 1 Week",true]
[null,"◢ TSMAD28/DIPWG6"]
[null,null,"☐",8,"TSMAD28/DIPWG6",null,"6.5A","Include HDF5 as an enceding format in S-100 (It is included in S-102 and may also be used by the SCWG)","BG",null,null,null,null,null,"2014-05-16T16:09:01",null,null,null,"[1],Open","[8],None","[8],None","[2],Updated Within 1 Week",false]
[null,null,"☐",9,"TSMAD28/DIPWG6",null,"8.2B","Review and act upon the comments received for the review of the S-52, Ed 6.1 & PresLib Ed. 4.0 drafts, and when updated, endorse the drafts and submit to HSSC6 for consideration.","CH/TM",null,null,null,null,null,"2014-05-19T12:52:47",null,null,null,"[1],Open","[8],None","[8],None","[1],Updated Today",false]
[null,null,"☐",10,"TSMAD28/DIPWG6",null,"8.2B","Make sure that “must” is used for all mandatory statements in the S-52 Ed 6.1.0 draft document.","CH/TM",null,null,null,null,null,"2014-05-19T12:52:39",null,null,null,"[1],Open","[8],None","[8],None","[1],Updated Today",false]
[null,null,"☐",11,"TSMAD28/DIPWG6",null,"8.2B","Forward all changes to definitions, that have resulted from the work on S-52 Ed 6.1.1, to the HDWG for review and inclusion in S-32.  CH ","CH/TM",null,null,null,null,"2014-05-19T12:50:00","2014-05-19T12:52:33","5/19/2014-12:50:00 PM-644488",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",13,"TSMAD28/DIPWG6",null,"8.2B","Include a test in 6-64 for \"text that can extend beyond a boundary\", and remove the reference in S-64","TM",null,null,null,null,"2014-05-19T12:51:05","2014-05-19T12:52:24","5/19/2014-12:51:05 PM-509109",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",15,"TSMAD28/DIPWG6",null,"8.2B","Develop an encoding bulleting to provide Guidance on how to encode a date tht includes a leap year sequence","JW",null,null,null,null,"2014-05-19T12:53:27","2014-05-19T12:54:04","5/19/2014-12:53:27 PM-783452",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",16,"TSMAD28/DIPWG6",null,"9.1A","Consolidate those sections of S-52 that should be included in S-101 (as a result of meeting discussions), and send them out to TSMAD/DIPWG members for formal review and comment.    ","JP",null,null,null,null,"2014-05-19T12:54:53","2014-05-19T12:55:08","5/19/2014-12:54:53 PM-691798",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",17,"TSMAD28/DIPWG6",null,"9.2A","Assist SPAWAR in specifying any portrayal elements specified in S-52 PL 4.0 (display category, priority, etc.) that could not be determined.","CH",null,null,null,null,"2014-05-19T12:55:10","2014-05-19T12:55:57","5/19/2014-12:55:10 PM-428126",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",18,"TSMAD28/DIPWG6",null,"9.2A","Provide guidance to SPAWAR regarding portrayal for hulks.","CH",null,null,null,null,"2014-05-19T12:56:02","2014-05-19T12:56:16","5/19/2014-12:56:02 PM-272548",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",19,"TSMAD28/DIPWG6",null,"9.2A","Provide DIPWG with “finalized” implementation for lights and other recently changed features and attributes.","JP",null,null,null,null,"2014-05-19T12:56:19","2014-05-19T12:56:35","5/19/2014-12:56:20 PM-266564",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",20,"TSMAD28/DIPWG6",null,"9.2A","CARIS to get back to CH concerning the level of effort required to fully convert all of the required S-52 CSPs into XSLT Templates.","HA",null,null,null,null,"2014-05-19T12:56:38","2014-05-19T12:56:54","5/19/2014-12:56:38 PM-640168",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",21,"TSMAD28/DIPWG6",null,"10.2A","Include the revised S-101 Value Added Roadmap on the IHO website. ","IHB",null,null,null,null,"2014-05-19T12:57:00","2014-05-19T12:57:14","5/19/2014-12:57:00 PM-639900",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",22,"TSMAD28/DIPWG6",null,"10.2A","Update Figure 2 of the S-101 Value Added Roadmap document to illustrate how ECDIS will use S-57 and S-101 ENC data.","JP",null,null,null,null,"2014-05-19T12:57:17","2014-05-19T12:57:30","5/19/2014-12:57:17 PM-716571",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",23,"TSMAD28/DIPWG6",null,"10.3A","Investigate whether a Content Management System could be used to generate/manage the content of the DCEG and other associated documents.  (JP)","JP",null,null,null,null,"2014-05-19T12:57:36","2014-05-19T12:57:55","5/19/2014-12:57:36 PM-946457",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",24,"TSMAD28/DIPWG6",null,"10.5A","Develop S-101 symbology for virtual AIS aids","DIPWG",null,null,null,null,"2014-05-19T12:57:58","2014-05-19T12:58:13","5/19/2014-12:57:58 PM-814601",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",25,"TSMAD28/DIPWG6",null,"10.6A","The DCEG is to ensure that LOKBSN and DOCARE are included as group 1 features.","JW",null,null,null,null,"2014-05-19T12:58:20","2014-05-19T12:58:35","5/19/2014-12:58:20 PM-724267",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",26,"TSMAD28/DIPWG6",null,"10.7A","Remove aggregations from the list of feature usetype enumerations list for S-100 and S-101. ","BG/JP",null,null,null,null,"2014-05-19T12:58:38","2014-05-19T12:58:52","5/19/2014-12:58:38 PM-890472",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",27,"TSMAD28/DIPWG6",null,"11.6A","The S-100 sub WG to take into consideration the proposals in paper 11.6A for action in S-100. Include examples of the use of aggregationa and associations.","S100subwg",null,null,null,null,"2014-05-19T12:58:57","2014-05-19T12:59:13","5/19/2014-12:58:57 PM-393748",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",28,"TSMAD28/DIPWG6",null,"11.7A","Develop and submit a proposal for a registry based procedure for the allocation of S-100 product specification identifiers for presentation to the HSSC6 meeting for endorsement.","SM",null,null,null,null,"2014-05-19T12:59:19","2014-05-19T12:59:31","5/19/2014-12:59:19 PM-815744",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",29,"TSMAD28/DIPWG6",null,"12.5A","Investigate (together with DPSWG) how to address cyber security issues for S-10n data products and services – with a view to providing guidance in S-100 for the use in dependent product specifications. (See associated TSMAD 26 Action)","DPSWG",null,null,null,null,"2014-05-19T14:39:35","2014-05-19T14:39:47","5/19/2014-2:39:35 PM-941786",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",30,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","DIPWG to submit a proposal to TSMAD-DCEG regarding recommendations for structuring of restricted areas that will facilitate the portrayal of the various types of restricted areas.  The recommendation will take into consideration a related paper previously submitted by Jeff Wootten ","DIPWG",null,null,null,null,"2014-05-19T14:39:59","2014-05-19T14:40:14","5/19/2014-2:39:59 PM-825073",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",31,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","Investigate possibility of using IHB resources to build True Type and or SVG fonts to support display of soundings and depth contour labels.","AP",null,null,null,null,"2014-05-19T14:40:23","2014-05-19T14:40:33","5/19/2014-2:40:23 PM-78470",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",32,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","Provide guidance to AP regarding which characters will need to be converted to True Type fonts","CH",null,null,null,null,"2014-05-19T14:40:47","2014-05-19T14:40:54","5/19/2014-2:40:47 PM-546001",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",33,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","Convert RGB values in the S-100nPortrayal Register to sRGB values.","HB/BG",null,null,null,null,"2014-05-19T14:41:02","2014-05-19T14:41:17","5/19/2014-2:41:02 PM-647743",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",34,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","Encoding Bulletin for and ammendment to the UOC relating to holes in data coverage","JW/RF",null,null,null,null,"2014-05-19T14:41:22","2014-05-19T14:41:39","5/19/2014-2:41:22 PM-267018",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",35,"TSMAD28/DIPWG6",null,"Portrayal Breakout Session","Coordinate the completion of S-64 based on the comments made during the meeting.","TM",null,null,null,null,"2014-05-19T14:41:45","2014-05-19T14:41:52","5/19/2014-2:41:45 PM-323194",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",36,"TSMAD28/DIPWG6",null,null,"Update the draft edition of S-58 Edition 5.0","RF",null,null,null,null,"2014-05-19T14:42:00","2014-05-19T14:42:45","5/19/2014-2:42:00 PM-350160",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",37,"TSMAD28/DIPWG6",null,"S-58 (paper 12.7A)","Consult with the IHB concerning the inclusion of the changes identified in 12.7A","BG",null,null,null,null,"2014-05-19T14:42:26","2014-05-19T14:42:40","5/19/2014-2:42:26 PM-870274",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,null,"☐",38,"TSMAD28/DIPWG6",null,"S-58 (paper 12.7A)","Formulate revised text in 12.7A and circulate to the WG","S-58subwg",null,null,null,null,"2014-05-19T14:42:59","2014-05-19T14:43:12","5/19/2014-2:42:59 PM-944394",null,null,"[1],Open","[8],None","[1],Created Today","[1],Updated Today",false]
[null,{"$f":"\"AI List (Action Item List) \" & IF(AI2003Version,\"Excel 2003 Version:  \",\"\") & AIVersionNumAsText","v":"AI List (Action Item List) v4.10"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'> HELP <'!B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[]
[null,"Data Validation default lists (highlighted indicates default items which remain when rebuilding drop downs)"]
[]
[null,null,null,null,"Category","Subcategory",null,"Resp","Email","Priority",null,"Status"]
[null,null,null,null,null,"<Enter any value>"]
[null,null,null,null,"<Enter any value> ",null,null,"AP",null,1,null,"100% Complete"]
[null,null,null,null,"Basic User Tips",null,null,"BG",null,2,null,"25% Complete"]
[null,null,null,null,"More User Tips",null,null,"BG/JP",null,3,null,"50% Complete"]
[null,null,null,null,"TSMAD27",null,null,"CH",null,"Cancel",null,"75% Complete"]
[null,null,null,null,"TSMAD28/DIPWG6",null,null,"CH/TM",null,"Done",null,"Cancel"]
[null,null,null,null,null,null,null,"DIPWG",null,"Hold",null,"Hidden"]
[null,null,null,null,null,null,null,"DPSWG",null,"Low",null,"Hold"]
[null,null,null,null,null,null,null,"HA",null,"Review",null,"Review"]
[null,null,null,null,null,null,null,"HB/BG"]
[null,null,null,null,null,null,null,"IHB"]
[null,null,null,null,null,null,null,"JP"]
[null,null,null,null,null,null,null,"JW"]
[null,null,null,null,null,null,null,"JW/RF"]
[null,null,null,null,null,null,null,"RF"]
[null,null,null,null,null,null,null,"RF/JP"]
[null,null,null,null,null,null,null,"RF/JW"]
[null,null,null,null,null,null,null,"S100subwg"]
[null,null,null,null,null,null,null,"S-58subwg"]
[null,null,null,null,null,null,null,"SM"]
[null,null,null,null,null,null,null,"TM"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Filter"]
[]
[null,"Show Only These Values (= all)"]
[]
[]
[null,"Hide These Values (Exclusions) (<> all)"]

{"sheet":"••Calendar","index":1,"n_rows":16,"n_cols":96,"rows_kept":16,"cut":false,"hidden":true,"merged":[[5,81,5,87],[5,89,5,95],[5,33,5,39],[5,41,5,47],[5,49,5,55],[5,57,5,63],[5,65,5,71],[5,73,5,79],[5,25,5,31],[1,8,1,14],[2,8,2,14],[5,1,5,7],[5,9,5,15],[5,17,5,23]]}
[]
[null,null,null,null,null,null,null,"Default Start Date:",{"$f":"DATE(YEAR(TODAY()),MONTH(TODAY())-1,1)","v":"2014-04-01"}]
[null,null,null,null,null,null,null,"Month Offset:",0]
[]
[]
[null,{"$f":"DATE(YEAR(I2),MONTH(I2)+I3,1)","v":"2014-04-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(B6),MONTH(B6)+1,DAY(B6))","v":"2014-05-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(J6),MONTH(J6)+1,DAY(J6))","v":"2014-06-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(R6),MONTH(R6)+1,DAY(R6))","v":"2014-07-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(Z6),MONTH(Z6)+1,DAY(Z6))","v":"2014-08-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AH6),MONTH(AH6)+1,DAY(AH6))","v":"2014-09-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AP6),MONTH(AP6)+1,DAY(AP6))","v":"2014-10-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(AX6),MONTH(AX6)+1,DAY(AX6))","v":"2014-11-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(BF6),MONTH(BF6)+1,DAY(BF6))","v":"2014-12-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(BN6),MONTH(BN6)+1,DAY(BN6))","v":"2015-01-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(BV6),MONTH(BV6)+1,DAY(BV6))","v":"2015-02-01"},null,null,null,null,null,null,null,{"$f":"DATE(YEAR(CD6),MONTH(CD6)+1,DAY(CD6))","v":"2015-03-01"}]
[null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S",null,"S","M","T","W","T","F","S"]
[null,{"$f":"IF(WEEKDAY(B6)=1,B6,IF(B6<TODAY(),\"\",\" \"))","v":""},{"$f":"IF(WEEKDAY(B6)=2,B6,IF(ISNUMBER(B8),B8+1,IF(B6<TODAY(),\"\",\" \")))","v":""},{"$f":"IF(WEEKDAY(B6)=3,B6,IF(ISNUMBER(C8),C8+1,IF(B6<TODAY(),\"\",\" \")))","v":"2014-04-01"},{"$f":"IF(WEEKDAY(B6)=4,B6,IF(ISNUMBER(D8),D8+1,IF(B6<TODAY(),\"\",\" \")))","v":"2014-04-02"},{"$f":"IF(WEEKDAY(B6)=5,B6,IF(ISNUMBER(E8),E8+1,IF(B6<TODAY(),\"\",\" \")))","v":"2014-04-03"},{"$f":"IF(WEEKDAY(B6)=6,B6,IF(ISNUMBER(F8),F8+1,IF(B6<TODAY(),\"\",\" \")))","v":"2014-04-04"},{"$f":"IF(WEEKDAY(B6)=7,B6,IF(ISNUMBER(G8),G8+1,IF(B6<TODAY(),\"\",\" \")))","v":"2014-04-05"},null,{"$f":"IF(WEEKDAY(J6)=1,J6,IF(J6<TODAY(),\"\",\" \"))","v":""},{"$f":"IF(WEEKDAY(J6)=2,J6,IF(ISNUMBER(J8),J8+1,IF(J6<TODAY(),\"\",\" \")))","v":""},{"$f":"IF(WEEKDAY(J6)=3,J6,IF(ISNUMBER(K8),K8+1,IF(J6<TODAY(),\"\",\" \")))","v":""},{"$f":"IF(WEEKDAY(J6)=4,J6,IF(ISNUMBER(L8),L8+1,IF(J6<TODAY(),\"\",\" \")))","v":""},{"$f":"IF(WEEKDAY(J6)=5,J6,IF(ISNUMBER(M8),M8+1,IF(J6<TODAY(),\"\",\" \")))","v":"2014-05-01"},{"$f":"IF(WEEKDAY(J6)=6,J6,IF(ISNUMBER(N8),N8+1,IF(J6<TODAY(),\"\",\" \")))","v":"2014-05-02"},{"$f":"IF(WEEKDAY(J6)=7,J6,IF(ISNUMBER(O8),O8+1,IF(J6<TODAY(),\"\",\" \")))","v":"2014-05-03"},null,{"$f":"IF(WEEKDAY(R6)=1,R6,IF(R6<TODAY(),\"\",\" \"))","v":"2014-06-01"},{"$f":"IF(WEEKDAY(R6)=2,R6,IF(ISNUMBER(R8),R8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-02"},{"$f":"IF(WEEKDAY(R6)=3,R6,IF(ISNUMBER(S8),S8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-03"},{"$f":"IF(WEEKDAY(R6)=4,R6,IF(ISNUMBER(T8),T8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-04"},{"$f":"IF(WEEKDAY(R6)=5,R6,IF(ISNUMBER(U8),U8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-05"},{"$f":"IF(WEEKDAY(R6)=6,R6,IF(ISNUMBER(V8),V8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-06"},{"$f":"IF(WEEKDAY(R6)=7,R6,IF(ISNUMBER(W8),W8+1,IF(R6<TODAY(),\"\",\" \")))","v":"2014-06-07"},null,{"$f":"IF(WEEKDAY(Z6)=1,Z6,IF(Z6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(Z6)=2,Z6,IF(ISNUMBER(Z8),Z8+1,IF(Z6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(Z6)=3,Z6,IF(ISNUMBER(AA8),AA8+1,IF(Z6<TODAY(),\"\",\" \")))","v":"2014-07-01"},{"$f":"IF(WEEKDAY(Z6)=4,Z6,IF(ISNUMBER(AB8),AB8+1,IF(Z6<TODAY(),\"\",\" \")))","v":"2014-07-02"},{"$f":"IF(WEEKDAY(Z6)=5,Z6,IF(ISNUMBER(AC8),AC8+1,IF(Z6<TODAY(),\"\",\" \")))","v":"2014-07-03"},{"$f":"IF(WEEKDAY(Z6)=6,Z6,IF(ISNUMBER(AD8),AD8+1,IF(Z6<TODAY(),\"\",\" \")))","v":"2014-07-04"},{"$f":"IF(WEEKDAY(Z6)=7,Z6,IF(ISNUMBER(AE8),AE8+1,IF(Z6<TODAY(),\"\",\" \")))","v":"2014-07-05"},null,{"$f":"IF(WEEKDAY(AH6)=1,AH6,IF(AH6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(AH6)=2,AH6,IF(ISNUMBER(AH8),AH8+1,IF(AH6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AH6)=3,AH6,IF(ISNUMBER(AI8),AI8+1,IF(AH6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AH6)=4,AH6,IF(ISNUMBER(AJ8),AJ8+1,IF(AH6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AH6)=5,AH6,IF(ISNUMBER(AK8),AK8+1,IF(AH6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AH6)=6,AH6,IF(ISNUMBER(AL8),AL8+1,IF(AH6<TODAY(),\"\",\" \")))","v":"2014-08-01"},{"$f":"IF(WEEKDAY(AH6)=7,AH6,IF(ISNUMBER(AM8),AM8+1,IF(AH6<TODAY(),\"\",\" \")))","v":"2014-08-02"},null,{"$f":"IF(WEEKDAY(AP6)=1,AP6,IF(AP6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(AP6)=2,AP6,IF(ISNUMBER(AP8),AP8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-01"},{"$f":"IF(WEEKDAY(AP6)=3,AP6,IF(ISNUMBER(AQ8),AQ8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-02"},{"$f":"IF(WEEKDAY(AP6)=4,AP6,IF(ISNUMBER(AR8),AR8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-03"},{"$f":"IF(WEEKDAY(AP6)=5,AP6,IF(ISNUMBER(AS8),AS8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-04"},{"$f":"IF(WEEKDAY(AP6)=6,AP6,IF(ISNUMBER(AT8),AT8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-05"},{"$f":"IF(WEEKDAY(AP6)=7,AP6,IF(ISNUMBER(AU8),AU8+1,IF(AP6<TODAY(),\"\",\" \")))","v":"2014-09-06"},null,{"$f":"IF(WEEKDAY(AX6)=1,AX6,IF(AX6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(AX6)=2,AX6,IF(ISNUMBER(AX8),AX8+1,IF(AX6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AX6)=3,AX6,IF(ISNUMBER(AY8),AY8+1,IF(AX6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(AX6)=4,AX6,IF(ISNUMBER(AZ8),AZ8+1,IF(AX6<TODAY(),\"\",\" \")))","v":"2014-10-01"},{"$f":"IF(WEEKDAY(AX6)=5,AX6,IF(ISNUMBER(BA8),BA8+1,IF(AX6<TODAY(),\"\",\" \")))","v":"2014-10-02"},{"$f":"IF(WEEKDAY(AX6)=6,AX6,IF(ISNUMBER(BB8),BB8+1,IF(AX6<TODAY(),\"\",\" \")))","v":"2014-10-03"},{"$f":"IF(WEEKDAY(AX6)=7,AX6,IF(ISNUMBER(BC8),BC8+1,IF(AX6<TODAY(),\"\",\" \")))","v":"2014-10-04"},null,{"$f":"IF(WEEKDAY(BF6)=1,BF6,IF(BF6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(BF6)=2,BF6,IF(ISNUMBER(BF8),BF8+1,IF(BF6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BF6)=3,BF6,IF(ISNUMBER(BG8),BG8+1,IF(BF6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BF6)=4,BF6,IF(ISNUMBER(BH8),BH8+1,IF(BF6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BF6)=5,BF6,IF(ISNUMBER(BI8),BI8+1,IF(BF6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BF6)=6,BF6,IF(ISNUMBER(BJ8),BJ8+1,IF(BF6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BF6)=7,BF6,IF(ISNUMBER(BK8),BK8+1,IF(BF6<TODAY(),\"\",\" \")))","v":"2014-11-01"},null,{"$f":"IF(WEEKDAY(BN6)=1,BN6,IF(BN6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(BN6)=2,BN6,IF(ISNUMBER(BN8),BN8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-01"},{"$f":"IF(WEEKDAY(BN6)=3,BN6,IF(ISNUMBER(BO8),BO8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-02"},{"$f":"IF(WEEKDAY(BN6)=4,BN6,IF(ISNUMBER(BP8),BP8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-03"},{"$f":"IF(WEEKDAY(BN6)=5,BN6,IF(ISNUMBER(BQ8),BQ8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-04"},{"$f":"IF(WEEKDAY(BN6)=6,BN6,IF(ISNUMBER(BR8),BR8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-05"},{"$f":"IF(WEEKDAY(BN6)=7,BN6,IF(ISNUMBER(BS8),BS8+1,IF(BN6<TODAY(),\"\",\" \")))","v":"2014-12-06"},null,{"$f":"IF(WEEKDAY(BV6)=1,BV6,IF(BV6<TODAY(),\"\",\" \"))","v":" "},{"$f":"IF(WEEKDAY(BV6)=2,BV6,IF(ISNUMBER(BV8),BV8+1,IF(BV6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BV6)=3,BV6,IF(ISNUMBER(BW8),BW8+1,IF(BV6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BV6)=4,BV6,IF(ISNUMBER(BX8),BX8+1,IF(BV6<TODAY(),\"\",\" \")))","v":" "},{"$f":"IF(WEEKDAY(BV6)=5,BV6,IF(ISNUMBER(BY8),BY8+1,IF(BV6<TODAY(),\"\",\" \")))","v":"2015-01-01"},{"$f":"IF(WEEKDAY(BV6)=6,BV6,IF(ISNUMBER(BZ8),BZ8+1,IF(BV6<TODAY(),\"\",\" \")))","v":"2015-01-02"},{"$f":"IF(WEEKDAY(BV6)=7,BV6,IF(ISNUMBER(CA8),CA8+1,IF(BV6<TODAY(),\"\",\" \")))","v":"2015-01-03"},null,{"$f":"IF(WEEKDAY(CD6)=1,CD6,IF(CD6<TODAY(),\"\",\" \"))","v":"2015-02-01"},{"$f":"IF(WEEKDAY(CD6)=2,CD6,IF(ISNUMBER(CD8),CD8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-02"},{"$f":"IF(WEEKDAY(CD6)=3,CD6,IF(ISNUMBER(CE8),CE8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-03"},{"$f":"IF(WEEKDAY(CD6)=4,CD6,IF(ISNUMBER(CF8),CF8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-04"},{"$f":"IF(WEEKDAY(CD6)=5,CD6,IF(ISNUMBER(CG8),CG8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-05"},{"$f":"IF(WEEKDAY(CD6)=6,CD6,IF(ISNUMBER(CH8),CH8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-06"},{"$f":"IF(WEEKDAY(CD6)=7,CD6,IF(ISNUMBER(CI8),CI8+1,IF(CD6<TODAY(),\"\",\" \")))","v":"2015-02-07"},null,{"$f":"IF(WEEKDAY(CL6)=1,CL6,IF(CL6<TODAY(),\"\",\" \"))","v":"2015-03-01"},{"$f":"IF(WEEKDAY(CL6)=2,CL6,IF(ISNUMBER(CL8),CL8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-02"},{"$f":"IF(WEEKDAY(CL6)=3,CL6,IF(ISNUMBER(CM8),CM8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-03"},{"$f":"IF(WEEKDAY(CL6)=4,CL6,IF(ISNUMBER(CN8),CN8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-04"},{"$f":"IF(WEEKDAY(CL6)=5,CL6,IF(ISNUMBER(CO8),CO8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-05"},{"$f":"IF(WEEKDAY(CL6)=6,CL6,IF(ISNUMBER(CP8),CP8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-06"},{"$f":"IF(WEEKDAY(CL6)=7,CL6,IF(ISNUMBER(CQ8),CQ8+1,IF(CL6<TODAY(),\"\",\" \")))","v":"2015-03-07"}]
[null,{"$f":"IF(ISNUMBER(H8),IF(MONTH(H8)=MONTH(H8+1),H8+1,IF(H8<TODAY(),\"\",\" \")),H8)","v":"2014-04-06"},{"$f":"IF(ISNUMBER(B9),IF(MONTH(B9)=MONTH(B9+1),B9+1,IF(B9<TODAY(),\"\",\" \")),B9)","v":"2014-04-07"},"2014-04-08","2014-04-09","2014-04-10","2014-04-11","2014-04-12",null,{"$f":"IF(ISNUMBER(P8),IF(MONTH(P8)=MONTH(P8+1),P8+1,IF(P8<TODAY(),\"\",\" \")),P8)","v":"2014-05-04"},{"$f":"IF(ISNUMBER(J9),IF(MONTH(J9)=MONTH(J9+1),J9+1,IF(J9<TODAY(),\"\",\" \")),J9)","v":"2014-05-05"},"2014-05-06","2014-05-07","2014-05-08","2014-05-09","2014-05-10",null,{"$f":"IF(ISNUMBER(X8),IF(MONTH(X8)=MONTH(X8+1),X8+1,IF(X8<TODAY(),\"\",\" \")),X8)","v":"2014-06-08"},{"$f":"IF(ISNUMBER(R9),IF(MONTH(R9)=MONTH(R9+1),R9+1,IF(R9<TODAY(),\"\",\" \")),R9)","v":"2014-06-09"},"2014-06-10","2014-06-11","2014-06-12","2014-06-13","2014-06-14",null,{"$f":"IF(ISNUMBER(AF8),IF(MONTH(AF8)=MONTH(AF8+1),AF8+1,IF(AF8<TODAY(),\"\",\" \")),AF8)","v":"2014-07-06"},{"$f":"IF(ISNUMBER(Z9),IF(MONTH(Z9)=MONTH(Z9+1),Z9+1,IF(Z9<TODAY(),\"\",\" \")),Z9)","v":"2014-07-07"},"2014-07-08","2014-07-09","2014-07-10","2014-07-11","2014-07-12",null,{"$f":"IF(ISNUMBER(AN8),IF(MONTH(AN8)=MONTH(AN8+1),AN8+1,IF(AN8<TODAY(),\"\",\" \")),AN8)","v":"2014-08-03"},{"$f":"IF(ISNUMBER(AH9),IF(MONTH(AH9)=MONTH(AH9+1),AH9+1,IF(AH9<TODAY(),\"\",\" \")),AH9)","v":"2014-08-04"},"2014-08-05","2014-08-06","2014-08-07","2014-08-08","2014-08-09",null,{"$f":"IF(ISNUMBER(AV8),IF(MONTH(AV8)=MONTH(AV8+1),AV8+1,IF(AV8<TODAY(),\"\",\" \")),AV8)","v":"2014-09-07"},{"$f":"IF(ISNUMBER(AP9),IF(MONTH(AP9)=MONTH(AP9+1),AP9+1,IF(AP9<TODAY(),\"\",\" \")),AP9)","v":"2014-09-08"},"2014-09-09","2014-09-10","2014-09-11","2014-09-12","2014-09-13",null,{"$f":"IF(ISNUMBER(BD8),IF(MONTH(BD8)=MONTH(BD8+1),BD8+1,IF(BD8<TODAY(),\"\",\" \")),BD8)","v":"2014-10-05"},{"$f":"IF(ISNUMBER(AX9),IF(MONTH(AX9)=MONTH(AX9+1),AX9+1,IF(AX9<TODAY(),\"\",\" \")),AX9)","v":"2014-10-06"},"2014-10-07","2014-10-08","2014-10-09","2014-10-10","2014-10-11",null,{"$f":"IF(ISNUMBER(BL8),IF(MONTH(BL8)=MONTH(BL8+1),BL8+1,IF(BL8<TODAY(),\"\",\" \")),BL8)","v":"2014-11-02"},{"$f":"IF(ISNUMBER(BF9),IF(MONTH(BF9)=MONTH(BF9+1),BF9+1,IF(BF9<TODAY(),\"\",\" \")),BF9)","v":"2014-11-03"},"2014-11-04","2014-11-05","2014-11-06","2014-11-07","2014-11-08",null,{"$f":"IF(ISNUMBER(BT8),IF(MONTH(BT8)=MONTH(BT8+1),BT8+1,IF(BT8<TODAY(),\"\",\" \")),BT8)","v":"2014-12-07"},{"$f":"IF(ISNUMBER(BN9),IF(MONTH(BN9)=MONTH(BN9+1),BN9+1,IF(BN9<TODAY(),\"\",\" \")),BN9)","v":"2014-12-08"},"2014-12-09","2014-12-10","2014-12-11","2014-12-12","2014-12-13",null,{"$f":"IF(ISNUMBER(CB8),IF(MONTH(CB8)=MONTH(CB8+1),CB8+1,IF(CB8<TODAY(),\"\",\" \")),CB8)","v":"2015-01-04"},{"$f":"IF(ISNUMBER(BV9),IF(MONTH(BV9)=MONTH(BV9+1),BV9+1,IF(BV9<TODAY(),\"\",\" \")),BV9)","v":"2015-01-05"},"2015-01-06","2015-01-07","2015-01-08","2015-01-09","2015-01-10",null,{"$f":"IF(ISNUMBER(CJ8),IF(MONTH(CJ8)=MONTH(CJ8+1),CJ8+1,IF(CJ8<TODAY(),\"\",\" \")),CJ8)","v":"2015-02-08"},{"$f":"IF(ISNUMBER(CD9),IF(MONTH(CD9)=MONTH(CD9+1),CD9+1,IF(CD9<TODAY(),\"\",\" \")),CD9)","v":"2015-02-09"},"2015-02-10","2015-02-11","2015-02-12","2015-02-13","2015-02-14",null,{"$f":"IF(ISNUMBER(CR8),IF(MONTH(CR8)=MONTH(CR8+1),CR8+1,IF(CR8<TODAY(),\"\",\" \")),CR8)","v":"2015-03-08"},{"$f":"IF(ISNUMBER(CL9),IF(MONTH(CL9)=MONTH(CL9+1),CL9+1,IF(CL9<TODAY(),\"\",\" \")),CL9)","v":"2015-03-09"},"2015-03-10","2015-03-11","2015-03-12","2015-03-13","2015-03-14"]
[null,{"$f":"IF(ISNUMBER(H9),IF(MONTH(H9)=MONTH(H9+1),H9+1,IF(H9<TODAY(),\"\",\" \")),H9)","v":"2014-04-13"},"2014-04-14","2014-04-15","2014-04-16","2014-04-17","2014-04-18","2014-04-19",null,{"$f":"IF(ISNUMBER(P9),IF(MONTH(P9)=MONTH(P9+1),P9+1,IF(P9<TODAY(),\"\",\" \")),P9)","v":"2014-05-11"},"2014-05-12","2014-05-13","2014-05-14","2014-05-15","2014-05-16","2014-05-17",null,{"$f":"IF(ISNUMBER(X9),IF(MONTH(X9)=MONTH(X9+1),X9+1,IF(X9<TODAY(),\"\",\" \")),X9)","v":"2014-06-15"},"2014-06-16","2014-06-17","2014-06-18","2014-06-19","2014-06-20","2014-06-21",null,{"$f":"IF(ISNUMBER(AF9),IF(MONTH(AF9)=MONTH(AF9+1),AF9+1,IF(AF9<TODAY(),\"\",\" \")),AF9)","v":"2014-07-13"},"2014-07-14","2014-07-15","2014-07-16","2014-07-17","2014-07-18","2014-07-19",null,{"$f":"IF(ISNUMBER(AN9),IF(MONTH(AN9)=MONTH(AN9+1),AN9+1,IF(AN9<TODAY(),\"\",\" \")),AN9)","v":"2014-08-10"},"2014-08-11","2014-08-12","2014-08-13","2014-08-14","2014-08-15","2014-08-16",null,{"$f":"IF(ISNUMBER(AV9),IF(MONTH(AV9)=MONTH(AV9+1),AV9+1,IF(AV9<TODAY(),\"\",\" \")),AV9)","v":"2014-09-14"},"2014-09-15","2014-09-16","2014-09-17","2014-09-18","2014-09-19","2014-09-20",null,{"$f":"IF(ISNUMBER(BD9),IF(MONTH(BD9)=MONTH(BD9+1),BD9+1,IF(BD9<TODAY(),\"\",\" \")),BD9)","v":"2014-10-12"},"2014-10-13","2014-10-14","2014-10-15","2014-10-16","2014-10-17","2014-10-18",null,{"$f":"IF(ISNUMBER(BL9),IF(MONTH(BL9)=MONTH(BL9+1),BL9+1,IF(BL9<TODAY(),\"\",\" \")),BL9)","v":"2014-11-09"},"2014-11-10","2014-11-11","2014-11-12","2014-11-13","2014-11-14","2014-11-15",null,{"$f":"IF(ISNUMBER(BT9),IF(MONTH(BT9)=MONTH(BT9+1),BT9+1,IF(BT9<TODAY(),\"\",\" \")),BT9)","v":"2014-12-14"},"2014-12-15","2014-12-16","2014-12-17","2014-12-18","2014-12-19","2014-12-20",null,{"$f":"IF(ISNUMBER(CB9),IF(MONTH(CB9)=MONTH(CB9+1),CB9+1,IF(CB9<TODAY(),\"\",\" \")),CB9)","v":"2015-01-11"},"2015-01-12","2015-01-13","2015-01-14","2015-01-15","2015-01-16","2015-01-17",null,{"$f":"IF(ISNUMBER(CJ9),IF(MONTH(CJ9)=MONTH(CJ9+1),CJ9+1,IF(CJ9<TODAY(),\"\",\" \")),CJ9)","v":"2015-02-15"},"2015-02-16","2015-02-17","2015-02-18","2015-02-19","2015-02-20","2015-02-21",null,{"$f":"IF(ISNUMBER(CR9),IF(MONTH(CR9)=MONTH(CR9+1),CR9+1,IF(CR9<TODAY(),\"\",\" \")),CR9)","v":"2015-03-15"},"2015-03-16","2015-03-17","2015-03-18","2015-03-19","2015-03-20","2015-03-21"]
[null,{"$f":"IF(ISNUMBER(H10),IF(MONTH(H10)=MONTH(H10+1),H10+1,IF(H10<TODAY(),\"\",\" \")),H10)","v":"2014-04-20"},"2014-04-21","2014-04-22","2014-04-23","2014-04-24","2014-04-25","2014-04-26",null,{"$f":"IF(ISNUMBER(P10),IF(MONTH(P10)=MONTH(P10+1),P10+1,IF(P10<TODAY(),\"\",\" \")),P10)","v":"2014-05-18"},"2014-05-19","2014-05-20","2014-05-21","2014-05-22","2014-05-23","2014-05-24",null,{"$f":"IF(ISNUMBER(X10),IF(MONTH(X10)=MONTH(X10+1),X10+1,IF(X10<TODAY(),\"\",\" \")),X10)","v":"2014-06-22"},"2014-06-23","2014-06-24","2014-06-25","2014-06-26","2014-06-27","2014-06-28",null,{"$f":"IF(ISNUMBER(AF10),IF(MONTH(AF10)=MONTH(AF10+1),AF10+1,IF(AF10<TODAY(),\"\",\" \")),AF10)","v":"2014-07-20"},"2014-07-21","2014-07-22","2014-07-23","2014-07-24","2014-07-25","2014-07-26",null,{"$f":"IF(ISNUMBER(AN10),IF(MONTH(AN10)=MONTH(AN10+1),AN10+1,IF(AN10<TODAY(),\"\",\" \")),AN10)","v":"2014-08-17"},"2014-08-18","2014-08-19","2014-08-20","2014-08-21","2014-08-22","2014-08-23",null,{"$f":"IF(ISNUMBER(AV10),IF(MONTH(AV10)=MONTH(AV10+1),AV10+1,IF(AV10<TODAY(),\"\",\" \")),AV10)","v":"2014-09-21"},"2014-09-22","2014-09-23","2014-09-24","2014-09-25","2014-09-26","2014-09-27",null,{"$f":"IF(ISNUMBER(BD10),IF(MONTH(BD10)=MONTH(BD10+1),BD10+1,IF(BD10<TODAY(),\"\",\" \")),BD10)","v":"2014-10-19"},"2014-10-20","2014-10-21","2014-10-22","2014-10-23","2014-10-24","2014-10-25",null,{"$f":"IF(ISNUMBER(BL10),IF(MONTH(BL10)=MONTH(BL10+1),BL10+1,IF(BL10<TODAY(),\"\",\" \")),BL10)","v":"2014-11-16"},"2014-11-17","2014-11-18","2014-11-19","2014-11-20","2014-11-21","2014-11-22",null,{"$f":"IF(ISNUMBER(BT10),IF(MONTH(BT10)=MONTH(BT10+1),BT10+1,IF(BT10<TODAY(),\"\",\" \")),BT10)","v":"2014-12-21"},"2014-12-22","2014-12-23","2014-12-24","2014-12-25","2014-12-26","2014-12-27",null,{"$f":"IF(ISNUMBER(CB10),IF(MONTH(CB10)=MONTH(CB10+1),CB10+1,IF(CB10<TODAY(),\"\",\" \")),CB10)","v":"2015-01-18"},"2015-01-19","2015-01-20","2015-01-21","2015-01-22","2015-01-23","2015-01-24",null,{"$f":"IF(ISNUMBER(CJ10),IF(MONTH(CJ10)=MONTH(CJ10+1),CJ10+1,IF(CJ10<TODAY(),\"\",\" \")),CJ10)","v":"2015-02-22"},"2015-02-23","2015-02-24","2015-02-25","2015-02-26","2015-02-27","2015-02-28",null,{"$f":"IF(ISNUMBER(CR10),IF(MONTH(CR10)=MONTH(CR10+1),CR10+1,IF(CR10<TODAY(),\"\",\" \")),CR10)","v":"2015-03-22"},"2015-03-23","2015-03-24","2015-03-25","2015-03-26","2015-03-27","2015-03-28"]
[null,{"$f":"IF(ISNUMBER(H11),IF(MONTH(H11)=MONTH(H11+1),H11+1,IF(H11<TODAY(),\"\",\" \")),H11)","v":"2014-04-27"},"2014-04-28","2014-04-29","2014-04-30","","","",null,{"$f":"IF(ISNUMBER(P11),IF(MONTH(P11)=MONTH(P11+1),P11+1,IF(P11<TODAY(),\"\",\" \")),P11)","v":"2014-05-25"},"2014-05-26","2014-05-27","2014-05-28","2014-05-29","2014-05-30","2014-05-31",null,{"$f":"IF(ISNUMBER(X11),IF(MONTH(X11)=MONTH(X11+1),X11+1,IF(X11<TODAY(),\"\",\" \")),X11)","v":"2014-06-29"},"2014-06-30"," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(AF11),IF(MONTH(AF11)=MONTH(AF11+1),AF11+1,IF(AF11<TODAY(),\"\",\" \")),AF11)","v":"2014-07-27"},"2014-07-28","2014-07-29","2014-07-30","2014-07-31"," "," ",null,{"$f":"IF(ISNUMBER(AN11),IF(MONTH(AN11)=MONTH(AN11+1),AN11+1,IF(AN11<TODAY(),\"\",\" \")),AN11)","v":"2014-08-24"},"2014-08-25","2014-08-26","2014-08-27","2014-08-28","2014-08-29","2014-08-30",null,{"$f":"IF(ISNUMBER(AV11),IF(MONTH(AV11)=MONTH(AV11+1),AV11+1,IF(AV11<TODAY(),\"\",\" \")),AV11)","v":"2014-09-28"},"2014-09-29","2014-09-30"," "," "," "," ",null,{"$f":"IF(ISNUMBER(BD11),IF(MONTH(BD11)=MONTH(BD11+1),BD11+1,IF(BD11<TODAY(),\"\",\" \")),BD11)","v":"2014-10-26"},"2014-10-27","2014-10-28","2014-10-29","2014-10-30","2014-10-31"," ",null,{"$f":"IF(ISNUMBER(BL11),IF(MONTH(BL11)=MONTH(BL11+1),BL11+1,IF(BL11<TODAY(),\"\",\" \")),BL11)","v":"2014-11-23"},"2014-11-24","2014-11-25","2014-11-26","2014-11-27","2014-11-28","2014-11-29",null,{"$f":"IF(ISNUMBER(BT11),IF(MONTH(BT11)=MONTH(BT11+1),BT11+1,IF(BT11<TODAY(),\"\",\" \")),BT11)","v":"2014-12-28"},"2014-12-29","2014-12-30","2014-12-31"," "," "," ",null,{"$f":"IF(ISNUMBER(CB11),IF(MONTH(CB11)=MONTH(CB11+1),CB11+1,IF(CB11<TODAY(),\"\",\" \")),CB11)","v":"2015-01-25"},"2015-01-26","2015-01-27","2015-01-28","2015-01-29","2015-01-30","2015-01-31",null,{"$f":"IF(ISNUMBER(CJ11),IF(MONTH(CJ11)=MONTH(CJ11+1),CJ11+1,IF(CJ11<TODAY(),\"\",\" \")),CJ11)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(CR11),IF(MONTH(CR11)=MONTH(CR11+1),CR11+1,IF(CR11<TODAY(),\"\",\" \")),CR11)","v":"2015-03-29"},"2015-03-30","2015-03-31"," "," "," "," "]
[null,{"$f":"IF(ISNUMBER(H12),IF(MONTH(H12)=MONTH(H12+1),H12+1,IF(H12<TODAY(),\"\",\" \")),H12)","v":""},"","","","","","",null,{"$f":"IF(ISNUMBER(P12),IF(MONTH(P12)=MONTH(P12+1),P12+1,IF(P12<TODAY(),\"\",\" \")),P12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(X12),IF(MONTH(X12)=MONTH(X12+1),X12+1,IF(X12<TODAY(),\"\",\" \")),X12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(AF12),IF(MONTH(AF12)=MONTH(AF12+1),AF12+1,IF(AF12<TODAY(),\"\",\" \")),AF12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(AN12),IF(MONTH(AN12)=MONTH(AN12+1),AN12+1,IF(AN12<TODAY(),\"\",\" \")),AN12)","v":"2014-08-31"}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(AV12),IF(MONTH(AV12)=MONTH(AV12+1),AV12+1,IF(AV12<TODAY(),\"\",\" \")),AV12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(BD12),IF(MONTH(BD12)=MONTH(BD12+1),BD12+1,IF(BD12<TODAY(),\"\",\" \")),BD12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(BL12),IF(MONTH(BL12)=MONTH(BL12+1),BL12+1,IF(BL12<TODAY(),\"\",\" \")),BL12)","v":"2014-11-30"}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(BT12),IF(MONTH(BT12)=MONTH(BT12+1),BT12+1,IF(BT12<TODAY(),\"\",\" \")),BT12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(CB12),IF(MONTH(CB12)=MONTH(CB12+1),CB12+1,IF(CB12<TODAY(),\"\",\" \")),CB12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(CJ12),IF(MONTH(CJ12)=MONTH(CJ12+1),CJ12+1,IF(CJ12<TODAY(),\"\",\" \")),CJ12)","v":" "}," "," "," "," "," "," ",null,{"$f":"IF(ISNUMBER(CR12),IF(MONTH(CR12)=MONTH(CR12+1),CR12+1,IF(CR12<TODAY(),\"\",\" \")),CR12)","v":" "}," "," "," "," "," "," "]
[]
[]
[null,{"$f":"'> HELP <'!B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]

{"sheet":"••AI List Support","index":2,"n_rows":22,"n_cols":3,"rows_kept":22,"cut":false,"hidden":true,"merged":[]}
["Action Item"]
[null,"Unique ID","2/24/2014-6:13:11 PM-432666"]
[null,"Close with 'X':"]
[null,"AI#:",11]
[null,"Category:","Acat"]
[null,"Subcategory:","www"]
[null,"Subject:","Testsub 4"]
[null,"Action:","test act"]
[null,"Person:","Mat"]
[null,"Priority:",3]
[null,"Due:","14/2/26"]
[null,"Status:","Done"]
[null,"Comment:","Com EM2"]
[null,"Last Sync","2014-02-24T18:30:12"]
[{"$f":"SUBSTITUTE('> HELP <'!B29,\"Submit Automation Requests to \",\"\")","v":"Standard Content © 2014 Excel Automation Help  |  Help@ExcelAutomationHelp.com"}]
[]
[]
["Registration"]
[]
[null,"App/Version",{"$f":"'> AI LIST <'!$B$70","v":"AI List (Action Item List) v4.10"}]
[]
[{"$f":"SUBSTITUTE('> HELP <'!B29,\"Submit Automation Requests to \",\"\")","v":"Standard Content © 2014 Excel Automation Help  |  Help@ExcelAutomationHelp.com"}]

{"sheet":"> HELP <","index":3,"n_rows":97,"n_cols":6,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,1,96,2],[46,1,46,2],[47,1,47,2],[95,1,95,2],[15,1,15,2],[16,1,16,2],[28,1,28,2],[29,1,29,2],[68,1,68,2],[64,1,64,2],[65,1,65,2],[31,1,31,2],[49,1,49,2],[4,4,4,5],[4,1,4,2],[18,1,18,2],[67,1,67,2],[19,1,20,2]]}
[]
[]
[]
[]
[null,"► AI List (Action Item List) HELP ◄",null,null,"► Common Keyboard Shortcuts ◄"]
[null,"User Tips:",{"$f":"'> AI LIST <'!B70","v":"AI List (Action Item List) v4.10"},null,"Press When Using AI List:"]
[null,"► Left Click","• Green Button Top Menu - Click for full screen mode, spell check, email integration, & more…",null,"Alt+F1 • ","Green Button Top Menu"]
[null,null,"• Column Names - Click on header column names to sort.",null,"Shift+F10 •","Right Click Mouse Menu"]
[null,"► Right Click","• Cell - Right click on any cell to close, move, delete, email row, etc…",null,"Ctrl+z (y) •","Undo (Redo)"]
[null,null,"• Header - Right click on header column names to change column width, show, or hide.",null,"Alt+Enter •","Next line (within a cell)"]
[null,"► Dbl. Click","• Groups - Double click on sorted group row names, to hide or show.",null,"Navigation and Search:"]
[null,null,"• Due Date - Double click on due date fields to pop up date selection calendar.",null,"Arrows •","Browse Cells"]
[null,null,"• Check Box - Double click on each row's checkbox (on left) to close or re-open row.",null,"Ctrl+Arrows •","Jump Cells within Group"]
[null,null,null,null,"Ctrl+Home (End) •","Goto First (Last) Row"]
[null,null,null,null,"Ctrl+f •","Find (Search)"]
[null,{"$f":"B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[null,{"$f":"B30","v":"Copyright applies to all company standard content, visual style, and standard programming code.  Unlawful to duplicate/modify standards without consent."}]
[]
[null,"► Custom Excel Automation Help ◄"]
[null,"For help using this spreadsheet, making functional changes or additions, or our assistance in creating your own custom excel automated solution, please contact our team at any of the below"]
[]
[null,"►","www.JTFAutomation.com"]
[null,"►","+1 832-800-4JTF     (4583)"]
[null,"►","Help@JTFAutomation.com"]
[null,"►","www.ExcelAutomationHelp.com"]
[null,"►","+1 315-805-HELP     (4357)"]
[null,"►","Help@ExcelAutomationHelp.com"]
[]
[null,{"$f":"IF(OR(AIUserVersion=\"CUser\",AIUserVersion=\"RecentCUser\"),\"Standard Content © 2014\",IF(AIUserVersion=\"ExcelAutomationHelp\",\"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com\",\"Standard Content © 2014 JTF Automation  |  Submit Automation Requests to Help@JTFAutomation.com\"))","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[null,"Copyright applies to all company standard content, visual style, and standard programming code.  Unlawful to duplicate/modify standards without consent."]
[]
[null,"► Enable Macros HELP ◄"]
[null,"To Enable Macros in Excel 2007 or newer follow these instructions:"]
[null,"1)","Click the round Office menu button or the File tab in the far top left corner of Excel"]
[null,"2)","Click Excel Options button on the very bottom"]
[null,"3)","Click Trust Center on the far left"]
[null,"4)","Click Trust Center Settings... on the bottom right"]
[null,"5)","Click Macro Settings on the far left"]
[null,"6)","Select the Enable all macros option to never need these steps again (the most popular choice)"]
[]
[null,"To Enable Macros in Excel 2003 or older follow these instructions:"]
[null,"1)","Click the Tools drop down menu"]
[null,"2)","Click Macro line"]
[null,"3)","Click Security... line"]
[null,"4)","Select Low on the Security Level tab to never need these steps again (the most popular choice)"]
[]
[null,{"$f":"B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[null,{"$f":"B30","v":"Copyright applies to all company standard content, visual style, and standard programming code.  Unlawful to duplicate/modify standards without consent."}]
[]
[null,"► User Tips ◄"]
[null,"Basic User Tips:"]
[null,"1)","Sort by Column Header Names:  Click \"AI#\", \"Category\", \"Priority\", or any other column header name to automatically sort and group by that field"]
[null,"2)","Close Check Box:  Double click the empty check box (small square) on the far left of each row, to close the row"]
[null,"3)","Green Button:  Click it (at the very top left of the window) to access more features and options"]
[null,"4)","\"Import Data\" to Pull In Old List, or \"Reset AI List\" to Start Fresh:  Find them within the Green Button Top Menu, to continue using data from an older AI List file, or to clear this file"]
[null,"5)","Automatically Add New Rows:  Type into the last blank row in the top 'New' group, and another new blank row will automatically be added for you"]
[]
[null,"More User Tips:"]
[null,"6)","Group Closed Items:  Click a column header name to sort by it, and all the closed items will automatically group at the bottom of the list"]
[null,"7)","Double Click \"Due\" for Calendar:  Double click a row's \"Due\" column cell, to open the popup calendar and pick a specific due date to assign"]
[null,"8)","Home (& Other) Top Tabs:  Find along the top of the window, and use to gain screen space and see other useful information (like a full year calendar)"]
[null,"9)","Right Click Cells & Headers:  Right click cells to show or hide rows based on values, or right click column header names to  show or hide full columns"]
[null,"10)","Double Click Gray Group:  Double click any gray group name to collapse or expand group rows (e.g. \"More User Tips\" group above AI # 7)"]
[]
[null,{"$f":"B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[null,{"$f":"B30","v":"Copyright applies to all company standard content, visual style, and standard programming code.  Unlawful to duplicate/modify standards without consent."}]
[]
[null,"► Terms & Conditions ◄"]
[null,"Terms and Conditions of Access and Usage of This File:                                   (End User License Agreement)"]
[null,"•","You:  All of these terms and conditions of access and usage apply to all users, viewers, keepers, copiers, receivers, and distributors of this file.  (hereafter defined as 'you')"]
[]
[null,"•",{"$f":"\"The Company:  The sole authorized creators and owners of this file are \" & IF(OR(AIUserVersion=\"CUser\",AIUserVersion=\"RecentCUser\",AIUserVersion=\"ExcelAutomationHelp\"),\"Excel Automation Help\",\"JTF Automation\") & \", its parent company, and any sub-division thereof.  (hereafter defined as the 'Company')\"","v":"The Company:  The sole authorized creators and owners of this file are Excel Automation Help, its parent company, and any sub-division thereof.  (hereafter defined as the 'Company')"}]
[]
[null,"•","Terms of Usage:  All copies of this file must be immediately and permanently destroyed, and the Company informed, if you do not agree to all of these terms and conditions.  By storing, distributing, copying, or otherwise using the file, you agree to be bound by these terms of usage.  These terms represents the entire agreement concerning this program between you and the Company, and it supersedes any other proposal, representation, or understanding between all parties."]
[]
[null,"•","Maintenance of Copyright Notices and Logo:  You must not remove, hide, or alter any copyright notices, logos, sheets, or the Company identification on any and all copies of this file.  Only the Company's authorized and certified users may do so.  The Company reserves the right to revoke any previously given authorization, at any time."]
[]
[null,"•","Distribution:  You may distribute copies of the file to third parties so long as creation and ownership of this product is not implied as by anyone other than the Company, no money is exchanged directly or indirectly from it's distribution or usage, no portion of the file is removed or hidden or modified, and ALL of it's terms of usage are honored by all parties."]
[]
[null,"•","Prohibition on Reverse Engineering, Decompilation, and Disassembly:  You may not reverse engineer, decompile, mimic, create derivative works, remove or crack passwords, or disassemble the file, including its sheets, formulas, formatting, and automated controls programming or VBA code."]
[]
[null,"•","Rental:  You may not rent, lease, or exchange money for this file, or any derivative of it."]
[]
[null,"•","Compliance with Applicable Laws:  You must comply with all applicable laws regarding use, storage, or distribution of this file."]
[]
[null,"•","Modification and Termination:  Without notice the Company may modify these terms, and may choose to terminate usage of the file by any or all other parties.  In such event, you must destroy all copies of the file in your possession."]
[]
[null,"•","Copyright:  All title, including but not limited to copyrights, in and to the file and any copies thereof are owned by the Company.  All rights reserved."]
[]
[null,"•","No Warranties:  The Company expressly disclaims any warranty for the file. The file is provided 'As Is' without any express or implied warranty of any kind, including but not limited to any warranties of merchantability, noninfringement, or fitness of a particular purpose.  The Company does not warrant or assume responsibility for the accuracy or completeness of any information, text, graphics, links or other items contained within the file.  The Company makes no warranties respecting any harm that may be caused by the use or transmission of this file.  The Company further expressly disclaims any warranty or representation to users or to any third party."]
[]
[null,"•","End User Confirmation:  End user to confirm all materials provided/used within this file are free use materials or methods, and they accept all liability for their usage. (including copyright, licensing, confidentiality, etc)  End user to confirm final accuracy/functionality of the full file. (only basic limited iterative testing was included) "]
[]
[null,"•","Limitation of Liability:  In no event shall the Company be liable for any damages (including, without limitation, lost profits, business interruption, or lost information) rising out of any use of or inability to use the file, even if the Company has been advised of the possibility of such damages.  In no event will the Company be liable for loss of data or for indirect, special, incidental, consequential (including lost profit), or other damages based in contract, tort or otherwise.  The Company shall have no liability with respect to the content of the file or any part thereof, including but not limited to errors or omissions contained therein, libel, infringements of rights of publicity, privacy, trademark rights, business interruption, personal injury, loss of privacy, moral rights or the disclosure of confidential information done by any parties."]
[]
[null,{"$f":"B29","v":"Standard Content © 2014 Excel Automation Help  |  Submit Automation Requests to Help@ExcelAutomationHelp.com"}]
[null,{"$f":"B30","v":"Copyright applies to all company standard content, visual style, and standard programming code.  Unlawful to duplicate/modify standards without consent."}]

{"sheet":"<Add Your Sheets Here>","index":4,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[]
[null,"You may create additional sheets or copy in sheets from other files.  You may not copy or move the original AI List included sheets to other files."]