{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Instructions","Schema","Variables","Subvariables","Categories","Automation script","Dataset List"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":18,"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":"Instructions","index":0,"n_rows":45,"n_cols":6,"rows_kept":45,"cut":false,"hidden":false,"merged":[[44,0,44,5],[43,0,43,5],[20,0,20,5],[22,0,22,5],[21,0,21,5],[32,0,32,5],[28,0,28,5],[27,0,27,5],[25,0,25,5],[30,0,30,5],[31,0,31,5]]}
[null,null,null,null,null,"Variable Editor"]
[]
["Enter Crunch username:"]
["Enter Crunch password:"]
[]
["OR"]
["Enter API key:"]
["THEN"]
[]
["Choose dataset:"]
["OR"]
["Enter dataset ID:"]
["THEN"]
[]
[null,null,null,null,null,true]
[null,null,null,null,null,false]
[]
["What is Crunch Automation?"]
[]
["How does it work?"]
["1. Enter a dataset ID."]
["2. Enter your API access token. If you don't have one then enter your username and password and click the \"Get access token\" button."]
["3. Click \"Get dataset schema\"."]
["4. Make bulk schema changes in the Variables and Subvariables worksheets. With each change, a new automation script is generated."]
["5. Click \"Run automation script\" or copy/paste the following Crunch Automation script into the online script editor to run."]
["6. Click \"Get dataset schema\" again to download your latest schema changes."]
[]
["How do I revert a changed cell back to its original value?"]
["Select the cell and type ctrl-Q."]
[]
["What changes can I make to a dataset?"]
["Change variable alias (RENAME). Schema change - available on the 1st script that runs."]
["Change variable data type to text, numeric, or datetime (REPLACE CONVERT). Schema change - available on the 1st script that runs."]
["Organize variables into folders in sorted order (ORGANIZE)."]
["Change variable titles, descriptions, and notes (CHANGE)."]
["Change subvariable labels (CHANGE)."]
["Change category numeric values (SET NUMERIC VALUE)."]
["Change category date values (SET DATES)."]
["Change category names (LABEL CATEGORIES)."]
["Change if category is missing (SET MISSING)."]
["Reorder categories (REORDER CATEGORIES)."]
["Combine categories (CREATE CATEGORICAL RECODE)"]
["Create category subtotals (SUBTOTAL)."]
["Create new categorical and numeric arrays in Array Builder (CREATE CATEGORICAL ARRAY, CREATE NUMERIC ARRAY)."]
["Create new multiple dichotomies in Array Builder (CREATE MULTIPLE DICHOTOMY)."]

{"sheet":"Schema","index":1,"n_rows":2,"n_cols":3,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Variable Details",null,"Convert"]
["Alias","Data Type","Datetime mask"]

{"sheet":"Variables","index":2,"n_rows":3,"n_cols":14,"rows_kept":3,"cut":false,"hidden":false,"merged":[[0,0,1,6],[0,7,0,13],[1,7,1,11],[1,13,2,13]]}
["Variable Details",null,null,null,null,null,null,"Array Builder"]
[null,null,null,null,null,null,null,"New Variable Details",null,null,null,null,"Subvariable","Dichotomize"]
["Alias","Data Type","Folder","Order","Title","Description","Notes","Alias","Folder","Title","Description","Notes","Label"]

{"sheet":"Subvariables","index":3,"n_rows":2,"n_cols":7,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,3,0,4],[0,0,0,2],[0,5,0,6]]}
["Variable Details",null,null,"Subvariable Details",null,"Add"]
["Alias","Title","Data Type","Alias","Label","Subtotal","Share of Total"]

{"sheet":"Categories","index":4,"n_rows":2,"n_cols":11,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,2,0,6],[0,7,0,10],[0,0,0,1]]}
["Variable",null,"Category Details",null,null,null,null,"Add"]
["Alias","Data Type","Code","Name","Order","Missing","Value","Subtotal","Combine","Multiple Dichotomy 1","Multiple Dichotomy 2"]

{"sheet":"Automation script","index":5,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Crunch Automation Script"]
["After editing the variables, subvariables, and categories, click the button or copy/paste the following Crunch Automation script into the online script editor to run."]
[]
[]
[]
[]
[]
["Script Result"]

{"sheet":"Dataset List","index":6,"n_rows":1,"n_cols":5,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Folder","Dataset","ID","Rows","Variables"]