{"text_format":"2","workbook":"xls","n_sheets":5,"sheets":["Guidelines","Skip Setup Guidelines","Current Custom Qsts","change_example CQsts (x-1-08)","Types"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":13,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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","formulas":"cached_only"}

{"sheet":"Guidelines","index":0,"n_rows":24,"n_cols":6,"rows_kept":24,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,"Questionnaire Management Guidelines"]
[]
[null,null,"Goals:"]
[null,null,"\u0098","One consolidated document to track all model and CQ changes throughout the life of the project"]
[null,null,"\u0098","Questionnaire always matches the live survey"]
[null,null,"\u0098","Easy and error-free way to submit CQ changes"]
[null,null,"\u0098","All changes tracked and reflected in one document (DOT will help)"]
[]
[null,null,"Basic rules:"]
[]
[null,null,1,"This questionnaire has to match the live survey "]
[null,null,2,"All changes to the live measure need to be tracked and archived in one document"]
[null,null,3,"All CQ change requests have to be submitted using this document"]
[]
[{"$nulls":4},"SRA: ","1) marks up changes and submits the entire document to DOT"]
[]
[{"$nulls":4},"DOT: ","1) archives change request on separate tab"]
[{"$nulls":5},"2) implements change(s)"]
[{"$nulls":5},"3) updates the document to reflect all implemented changes in the \"clean\" questionnaire - SRA can send to the client and use for future CQ changes"]
[]
[null,null,4,"DOT safeguards correct formats - your next CQ changes have to be submitted using one survey document with appropriate color-coding"]

{"sheet":"Skip Setup Guidelines","index":1,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":true,"merged":[[22,3,22,22],[15,5,15,20],[14,5,14,21],[13,5,13,21],[19,5,19,21],[20,5,20,21],[16,5,16,20],[34,3,34,21],[21,5,21,20],[33,3,33,21],[30,5,30,20],[26,5,26,21],[31,5,31,21],[25,5,25,21],[29,5,29,21],[28,5,28,21],[27,5,27,21]],"flags":["formulas_cached_only"]}
[]
[]
[]
[null,null,null,"Questionnaire Skip Set Up Guidelines"]
[]
[null,null,null,"Goals:"]
[null,null,null,"\u0098","Ensure all skip setup included in the questionnaire is consistent with skip logic rules"]
[null,null,null,"\u0098","Decrease down time due to skip corrections within submitted surveys"]
[]
[null,null,null,"Basic Skip Rules:"]
[]
[null,null,"\"Other Please Specify\" (OPS) Skip Rules:"]
[null,null,null,"Type 1 \"Other Please Specify\" Rules (Text box to the right of the answer choice \"Other, please specify:\") :"]
[null,null,null,1,null,"OPS questions must be set up as a radio-button or checkbox to have the text box appear next to the answer choice \"Other, please specify:\""]
[null,null,null,2,null,"The open ended text box for \"Other Please Specify\" has it's own question ID and needs full question text included in questionnaire.\n(This will be used by clients, SRAs, etc, in the portal and comment cluster to differentiate between OPS questions within a measure)"]
[null,null,null,3,null,"The open ended text box has a character limit of 100. No exceptions! if more characters are needed, please request a Type 5 group."]
[null,null,null,4,null,"In the special instructions column, indicate that this is a \"OPS Group\" for the PARENT and CHILD questions."]
[]
[null,null,null,"Type 5 \"Other Please Specify\" Rules (More than two questions within question group):"]
[null,null,null,1,null,"Open-ended boxes will not show up next to the answer choice \"Other\" in this type of skip logic. They will pop as separate questions that require additional question text. Please include full question text."]
[null,null,null,2,null,"Radio-button, checkbox or drop-down CQs can have an “other please specify” in this type of skip set up but the text box will pop as a separate question."]
[null,null,null,3,null,"In the special instructions column, indicate that this is a \"Skip Logic Group\" for the PARENT and CHILD questions."]
[null,null,null,"Please refer to the Current Custom Qsts tab for examples (OPS Type 1 and OPS Type 5 are marked in the comment boxes)"]
[]
[null,null,"General Skip Rules:"]
[null,null,null,1,null,"The parent question must come first, and child questions must immediately follow. Skip logic groups cannot be broken up by other questions that are not included within the skip."]
[null,null,null,2,null,"A CQ can only have one parent question; a single question CANNOT be triggered by different questions. "]
[null,null,null,3,null,"Answers within one question can be set up so that different answer combinations trigger different questions, through the use of \"answer groups\"."]
[null,null,null,4,null,"A question can only be a part of ONE group type i.e. skip logic, matrix, or multiple lists"]
[null,null,null,5,null,"Horizontal scale questions CANNOT be parent CQs, but they can be child CQs. NOTE: By changing a horizontal scale question to a dropdown they can become parent questions."]
[null,null,null,6,null,"Open End text questions cannot be a parent questions, but they can be child CQs."]
[null,null,null,7,null,"Multi-select questions can be used in skip logic."]
[]
[null,null,null,"As a general tip for SRAs: The more complex the skip logic, the more difficult it is to keep the tabs and labels concise in SPRs.\n It is important to know when to just use filters versus creating skip logic."]
[null,null,null,"Caution: Measures without enhanced/segmented reports might require intricate skip to gather necessary data for standard reports."]

{"sheet":"Current Custom Qsts","index":2,"n_rows":95,"n_cols":10,"rows_kept":95,"cut":false,"hidden":false,"merged":[[70,9,73,9],[74,2,83,2],[74,9,83,9],[56,2,59,2],[60,2,64,2],[60,9,64,9],[56,9,59,9],[66,9,69,9],[66,2,69,2],[30,9,41,9],[30,2,41,2],[42,2,47,2],[42,9,47,9],[49,9,54,9],[49,2,54,2],[11,2,13,2],[11,9,13,9],[14,9,16,9],[14,2,16,2],[7,9,10,9],[27,9,29,9],[27,2,29,2],[17,2,26,2],[17,5,26,5],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[5,0,5,8],[7,2,10,2]],"flags":["formulas_cached_only"]}
[{"$error":"#REF!"},null,null,"red & strike-through:  DELETE"]
[{"$error":"#REF!"},null,null,"underlined & italicized: RE-ORDER"]
[{"$error":"#REF!"},null,null,"pink: ADDITION"]
["Date: 11/18/2009",null,null,"blue + -->: REWORDING"]
[]
[{"$error":"#REF!"}]
["QID\n(Group ID)","Skip Logic Label","Question Text","Answer Choices \n(limited to 50 characters)","Skip to","Type (select from list)","Single or Multi","Required\nY/N","Special Instructions","CQ Label "]
[null,null,"Does your company use E-Verify?","Yes","A","Drop down,  select one","S","Y",null,"Use E-Verify"]
[null,null,null,"No","B"]
[null,null,null,"Don't know","A"]
[null,null,null,"I am not employed by or do not own a company"]
[null,"B","Is your company considering using E-Verify?","Yes ",null,"Drop down,  select one","S","N",null,"Consider using E-Verify"]
[null,null,null,"No"]
[null,null,null,"Don't know"]
[null,"A","Did, or will, you play any role in your company’s decision whether to use, or not use, E-Verify?","Yes ","D","Drop down,  select one","S","N",null,"Play role in using E-Verify"]
[null,null,null,"No"]
[null,null,null,"Don't know"]
[null,"B,D","How likely is your company to become a new E-Verify user as a result of visiting this site?","1=Very Unlikely",null,"Radio button,  scale, no don't know","S","N",null,"New user"]
[null,null,null,2]
[null,null,null,3]
[null,null,null,4]
[null,null,null,5]
[null,null,null,6]
[null,null,null,7]
[null,null,null,8]
[null,null,null,9]
[null,null,null,"10=Very Likely"]
[null,"A,B","Is your company mandated by federal, state or local law to participate in E-Verify?","Yes ",null,"Drop down,  select one","S","N",null,"Mandated"]
[null,null,null,"No"]
[null,null,null,"Don't know"]
[null,"A,B","Approximately how many people are employed at your company?","1 to 4 ",null,"Drop down,  select one","S","N",null,"Number of employees"]
[null,null,null,"5 to 9 "]
[null,null,null,"10 to 19 "]
[null,null,null,"20 to 49 "]
[null,null,null,"50 to 99 "]
[null,null,null,"100 to 249 "]
[null,null,null,"250 to 499"]
[null,null,null,"500 to 999 "]
[null,null,null,"1,000 to 2,499 "]
[null,null,null,"2,500 to 4,999 "]
[null,null,null,"5,000 to 9,999 "]
[null,null,null,"10,000 or more "]
[null,null,"For what reasons did you visit the E-Verify site today? (Check all that apply.)","Learn about E-Verify in general",null,"Checkbox,  one-up vertical","M","Y",null,"Reasons for visiting"]
[null,null,null,"Learn about E-Verify requirements for federal contractors"]
[null,null,null,"Sign up for a webinar"]
[null,null,null,"Learn how to contact E-Verify"]
[null,null,null,"Enroll in the E-Verify program"]
[null,null,null,"Other, please specify:","A"]
[null,"A","Other reasons for visiting  the E-Verify site today.",null,null,"Text area,  no char limit",null,"N",null,"Other reasons"]
[null,null,"What was the primary reason you visited the E-Verify site today?  (Check only one response.)","Learn about E-Verify in general",null,"Radio button,  one-up vertical","S","Y",null,"Primary reason"]
[null,null,null,"Learn about E-Verify requirements for federal contractors"]
[null,null,null,"Sign up for a webinar"]
[null,null,null,"Learn how to contact E-Verify"]
[null,null,null,"Enroll in the E-Verify program"]
[null,null,null,"Other, please specify:","A"]
[null,"A","Other primary reason for visiting the E-Verify site today.",null,null,"Text area,  no char limit",null,"N",null,"Other primary reasons"]
[null,null,"Were you able to find what you were looking for at the E-Verify site?","Yes",null,"Drop down,  select one","S","Y",null,"Find info"]
[null,null,null,"For the most part"]
[null,null,null,"Only partially"]
[null,null,null,"No"]
[null,null,"How frequently do you visit this E-Verify site?","First time",null,"Drop down,  select one","S","Y",null,"Frequency"]
[null,null,null,"Almost every day"]
[null,null,null,"Once or twice a week"]
[null,null,null,"Once or twice a month"]
[null,null,null,"Less than Once a month"]
[null,null,"What could be done to make this site more useful?",null,null,"Text area,  no char limit",null,"N",null,"Improvement"]
[null,null,"How easy was it for you to understand the information on this E-Verify site?","Very easy",null,"Radio button,  one-up vertical","S","Y",null,"Easy to understand"]
[null,null,null,"Somewhat easy"]
[null,null,null,"Somewhat difficult"]
[null,null,null,"Very difficult"]
[null,null,"How easy was it to find what you were looking for?","Very easy",null,"Radio button,  one-up vertical","S","Y",null,"Easy to find"]
[null,null,null,"Somewhat easy"]
[null,null,null,"Somewhat difficult"]
[null,null,null,"Very difficult"]
[null,null,"In which of the following ways would you like to get more information about E-Verify? (Check all that apply)","Facebook",null,"Checkbox,  one-up vertical","M","Y",null,"Format"]
[null,null,null,"Twitter"]
[null,null,null,"Blogs"]
[null,null,null,"YouTube videos"]
[null,null,null,"Wikis"]
[null,null,null,"Internet discussion boards"]
[null,null,null,"E-mail subscriber lists"]
[null,null,null,"Text messaging"]
[null,null,null,"Other, please specify:","A"]
[null,null,null,"None"]
[null,"A","Other format in which would like to get more info about E-Verify.",null,null,"Text area,  no char limit",null,"N",null,"Other format"]
[null,null,"Which of the following best describes your role?","I am a human resources professional seeking information for my employer",null,"Radio button,  one-up vertical","S","Y",null,"Role"]
[null,null,null,"I am an attorney or designated agent representing my employer or client"]
[null,null,null,"I am a business owner/company executive seeking information for my business"]
[null,null,null,"I am an employee seeking information because my employer uses or may use E-Verify"]
[null,null,null,"I represent an industry organization or advocacy group that follows E-Verify"]
[null,null,null,"I am a member of the news media seeking information for a story on E-Verify"]
[null,null,null,"I am doing policy research for a government legislator or agency"]
[null,null,null,"I am person who just happens to be interested in E-Verify"]
[null,null,null,"Other, please specify:","A"]
[null,"A","Other role coming to the site.",null,null,"Text area,  no char limit",null,"N",null,"Other role"]

{"sheet":"change_example CQsts (x-1-08)","index":3,"n_rows":77,"n_cols":10,"rows_kept":77,"cut":false,"hidden":true,"merged":[[3,1,3,2],[5,0,5,9]],"flags":["formulas_cached_only"]}
[{"$error":"#REF!"},null,null,"red & strike-through:  DELETE"]
[{"$error":"#REF!"},null,null,"underlined & italicized: RE-ORDER"]
[{"$error":"#REF!"},null,null,"pink: ADDITION"]
["Date:","2008-03-01",null,"blue + -->: REWORDING"]
[]
[{"$error":"#REF!"}]
["QID","Skip Logic Label","Question Text","Answer Choices \n(limited to 50 characters)","Skip to","Type (select from list)","Single or Multi","Required\nY/N","Special Instructions","CQ Label"]
["CQ0004444",null,"How frequently do you visit this site?","Daily",null,"Dropdown (Select-one)","Single","Y"]
[null,null,null,"Two to three times per week"]
[null,null,null,"About once a month"]
[null,null,null,"Every few months"]
[null,null,null,"Every 6 months or less often"]
[null,null,null,"This is my first time visiting this site"]
["CQ0004445",null,"Are you a registered user on this site?","I am registered\n",null,"Radio button,  one-up vertical","Single","Y","Randomize"]
[null,null,null,"I am not registered, and do not intend to","A",null,null,null,"OPS Group"]
[null,null,null,"I am not registered, but intend to register during my visit today"]
["CQ0004446","A","Please explain why you do not intend to register?  ",null,null,"Text area,  no char limit","Single","N","OPS Group"]
["CQ0004447",null,"What best describes your primary reason for visiting the site today?","Researching products for possible inclusion in a design","B","Radio button,  one-up vertical","Single","Y","Skip Logic Group"]
[null,null,null,"Gathering information on a product or manufacturer specified in a design","C"]
[null,null,null,"Other (please specify)","A"]
["CQ0004448","A","Other primary reason",null,null,"Text area,  no char limit","Single","N","Skip Logic Group"]
["CQ0004449","B","What type of information were you looking for when researching products for the possible inclusion in a design?  ","Spec",null,"Checkbox,  one-up vertical","Multi","Y","Skip Logic Group"]
[null,null,null,"3D models"]
[null,null,null,"Product application"]
[null,null,null,"Green information"]
[null,null,null,"Manufacturer's contacts"]
[null,null,null,"Cost"]
[null,null,null,"Other"]
["CQ0004450","C","What type of information were you looking for when researching products for the possible inclusion in a design?  ","CAD",null,"Checkbox,  one-up vertical","Multi","Y","Skip Logic Group"]
[null,null,null,"Spec"]
[null,null,null,"3D models"]
[null,null,null,"Green information"]
[null,null,null,"Product application"]
[null,null,null,"Manufacturer's contacts"]
[null,null,null,"Cost"]
[null,null,null,"Other"]
["CQ0004451",null,"How were you primarily seeking information on sweets.com?","Search by keyword feature",null,"Radio button,  one-up vertical","Single","Y","OPS Group"]
[null,null,null,"Browse by master format feature"]
[null,null,null,"Other (please specify)","A"]
["CQ0004452","A","Other reason seeking information",null,null,"Text field,  <100 char","Single","N","OPS Group"]
["CQ0004453",null,"Were you able to find what you were looking for today?","Yes",null,"Radio button,  one-up vertical","Single","Y","Skip Logic Group"]
[null,null,null,"No","A,B"]
[null,null,null,"Not sure","C,D"]
["CQ0004454","A","Why were you not able to find what you were looking for? ","I could not find the manufacturer I was looking for",null,"Radio button,  one-up vertical","Single","Y","Skip Logic Group"]
[null,null,null,"I could not find the product I was looking for"]
[null,null,null,"I haven’t completed my search on sweets.com yet"]
[null,null,null,"The search results did not appear relevant"]
[null,null,null,"Other"]
["CQ0004455","B","Since you could not find what you were looking for, what do you plan to do next? ","Continue looking for the information at this site",null,"Drop down,  select one","Single","Y","Skip Logic Group"]
[null,null,null,"Call Sweets.com customer service "]
[null,null,null,"E-mail Sweets.com customer service "]
[null,null,null,"Return to this site later and try again"]
[null,null,null,"Conduct a new internet search "]
[null,null,null,"Visit other building product sites","E"]
[null,null,null,"Other"]
["CQ0004458","E","What other site(s) do you plan to visit?  ",null,null,"Text area,  no char limit","Single","N","Skip Logic Group"]
["CQ0004456","C","Why were you not sure?","I haven’t completed my search on sweets.com yet",null,"Radio button,  one-up vertical","Single","Y","Skip Logic Group"]
[null,null,null,"I am not sure how to find the product I am looking for"]
[null,null,null,"Could not find the product I was looking for under the division it should be listed in"]
[null,null,null,"The search results did not appear relevant"]
[null,null,null,"Other"]
["CQ0004457","D","Since you were not sure, what do you plan to do next? ","Continue looking for the information at this site",null,"Drop down,  select one","Single","Y","Skip Logic Group"]
[null,null,null,"Call Sweets.com customer service "]
[null,null,null,"E-mail Sweets.com customer service "]
[null,null,null,"Return to this site later and try again"]
[null,null,null,"Conduct a new internet search "]
[null,null,null,"Visit other building product sites","F"]
[null,null,null,"Other"]
["CQ0004459","F","What other site(s) do you plan to visit?  ",null,null,"Text area,  no char limit","Single","N","Skip Logic Group"]
["CQ0004460",null,"What other sources do you use to search for construction product information?","Google",null,"Checkbox,  one-up vertical","Multi","Y"]
[null,null,null,"Other search engine (i.e.: Yahoo!, Teoma, Dogpile, etc.)"]
[null,null,null,"Reed First Source"]
[null,null,null,"4specs"]
[null,null,null,"Arcat"]
[null,null,null,"Manufacturers websites"]
[null,null,null,"Sweets catalog"]
[null,null,null,"Other"]

{"sheet":"Types","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":true,"merged":[],"flags":["formulas_cached_only"]}
["Types",null,"Instructions"]
["Text field,  <100 char",null,"Randomize"]
["Text area,  no char limit",null,"Shared"]
["Drop down,  select one",null,"OPS Group"]
["Radio button,  one-up vertical",null,"Matrix Group"]
["Radio button,  two-up vertical",null,"Rank Group"]
["Radio button,  three-up vertical",null,"Comparative Matrix Group"]
["Radio button,  scale, has don't know",null,"Skip Logic Group"]
["Radio button,  scale, no don't know",null,"Multiple Lists Group"]
["Checkbox,  one-up vertical",null,"Partitioned"]
["Checkbox,  two-up vertical"]
["Checkbox,  three-up vertical"]