{"text_format":"2","workbook":"xls","n_sheets":6,"sheets":["Guidelines","Skip Setup Guidelines","Current Model Qsts","Current Custom Qsts","change_example CQsts (x-1-08)","Types"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":15,"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 Model Qsts","index":2,"n_rows":34,"n_cols":6,"rows_kept":34,"cut":false,"hidden":false,"merged":[[4,0,4,5],[3,1,3,2],[5,0,5,5]],"flags":["formulas_cached_only"]}
["Model Instance Name: "]
["AHRQ CAHPS"]
["MID:"]
["Date:","2009-06-25"]
["AHRQ CAHPS"]
["Model questions utilize the ACSI methodology to determine scores and impacts"]
[null,"ELEMENTS (drivers of satisfaction)",null,"CUSTOMER SATISFACTION",null,"FUTURE BEHAVIORS"]
[]
[null,"Content (1=Poor, 10=Excellent, Don't Know)",null,"Satisfaction (1=Poor, 10=Excellent)",null,"Likelihood to Return (1=Not Very Likely, 10=Very Likely)"]
[1,"Please rate the accuracy of information on this site.",21,"What is your overall satisfaction with this site?",24,"How likely are you to return to this site?"]
[2,"Please rate the quality of information on this site.",22,"How well does this site meet your expectations?",null,"Recommend (1=Not Very Likely, 10=Very Likely)"]
[3,"Please rate the freshness of content on this site.",23,"How does this site compare to your idea of an ideal website?",25,"How likely are you to recommend this site to someone else?"]
[null,"Functionality (1=Poor, 10=Excellent, Don't Know)",null,null,null,"Primary Resource (1=Not Very Likely, 10=Very Likely)"]
[4,"Please rate the usefulness of the features provided on this site.",null,null,26,"How likely are you to use this site as your primary resource?"]
[5,"Please rate the convenience of the features on this site."]
[6,"Please rate the variety of features on this site."]
[null,"Look and Feel (1=Poor, 10=Excellent, Don't Know)"]
[7,"Please rate the visual appeal of this site."]
[8,"Please rate the balance of graphics and text on this site."]
[9,"Please rate the readability of the pages on this site. "]
[null,"Navigation (1=Poor, 10=Excellent, Don't Know)"]
[10,"Please rate how well the site is organized."]
[11,"Please rate the options available for navigating this site."]
[12,"Please rate how well the site layout helps you find what you are looking for."]
[13,"Please rate the number of clicks to get where you want on this site."]
[null,"Search (1=Poor, 10=Excellent, Don't Know)"]
[14,"Please rate the relevance of search results on this site."]
[15,"Please rate the organization of search results on this site."]
[16,"Please rate how well the search results help you decide what to select. "]
[17,"Please rate how well the search feature helps you to narrow the results to find what you want."]
[null,"Site Performance (1=Poor, 10=Excellent, Don't Know)"]
[18,"Please rate how quickly pages load on this site."]
[19,"Please rate the consistency of speed from page to page on this site."]
[20,"Please rate the ability to load pages without getting error messages on this site."]

{"sheet":"Current Custom Qsts","index":3,"n_rows":65,"n_cols":10,"rows_kept":65,"cut":false,"hidden":false,"merged":[[62,2,63,2],[7,2,18,2],[21,2,22,2],[24,2,34,2],[35,2,48,2],[5,0,5,8],[0,0,0,2],[1,0,1,2],[2,0,2,2],[3,0,3,2],[50,2,56,2]],"flags":["formulas_cached_only"]}
["Model Instance Name: ",null,null,"red & strike-through:  DELETE"]
["AHRQ CAHPS",null,null,"underlined & italicized: RE-ORDER"]
["MID: ",null,null,"pink: ADDITION"]
["Date: 6/25/09",null,null,"blue + -->: REWORDING"]
[]
["AHRQ CAHPS CUSTOM QUESTION LIST"]
["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,"What is your primary purpose for visiting this site? To learn about:","CAHPS Survey Instrument",null,"Checkbox,  one-up vertical","M","Y"]
[null,null,null,"Download All or Part of Survey Kits"]
[null,null,null,"CAHPS Database--Get Information"]
[null,null,null,"CAHPS Database--Data Submission"]
[null,null,null,"CAHPS Database--Research Files"]
[null,null,null,"Quality Improvement--Get Information"]
[null,null,null,"Quality Improvement--CAHPS Improvement Guide"]
[null,null,null,"Reporting CAHPS Scores--Get Information"]
[null,null,null,"Reporting CAHPS Scores--Report Card Compendium"]
[null,null,null,"The CAHPS Connection Newsletter "]
[null,null,null,"News and Events"]
[null,null,null,"Other (Please Specify)","A"]
[null,"A","Other purpose for visiting",null,null,"Text area,  no char limit",null,"N"]
[null,null,"What is your main purpose for using information or products on this site?",null,null,"Text area,  no char limit",null,"N"]
[null,null,"Did you find the information you were looking for on the site?","Yes",null,"Radio button,  one-up vertical","S","Y"]
[null,null,null,"No (Please specify)","A"]
[null,"A","Information not found",null,null,"Text area,  no char limit",null,"N"]
[null,null,"How did you learn about this site?","AHRQ (Web Site, Newsletter, Event)",null,"Checkbox,  one-up vertical","M","Y"]
[null,null,null,"CAHPS User Network (Newsletter, E-mail, HelpLine, Event)"]
[null,null,null,"CAHPS Database (E-mail, HelpLine, Event)"]
[null,null,null,"Search Engine"]
[null,null,null,"Another Web Site"]
[null,null,null,"Publication"]
[null,null,null,"Colleague"]
[null,null,null,"Trade Association"]
[null,null,null,"Professional Organization"]
[null,null,null,"Meeting/Conference/Webcast"]
[null,null,null,"Other (Please Specify)"]
[null,null,"What type of organization do you represent?","Health Plan",null,"Radio button,  one-up vertical","S","Y"]
[null,null,null,"Clinician & Group Practice"]
[null,null,null,"Hospital"]
[null,null,null,"Nursing Home"]
[null,null,null,"Vendor/Consultant"]
[null,null,null,"State Government"]
[null,null,null,"Federal Government"]
[null,null,null,"Quality Improvement Organization"]
[null,null,null,"Researcher"]
[null,null,null,"Health Care Coalition"]
[null,null,null,"Health System"]
[null,null,null,"Consumer Group"]
[null,null,null,"Consumer"]
[null,null,null,"Other (Please Specify)","A"]
[null,"A","Other organization",null,null,"Text area,  no char limit",null,"N"]
[null,null,"How did you access this site?","From AHRQ Main Site",null,"Checkbox,  one-up vertical","M","Y"]
[null,null,null,"Web Search"]
[null,null,null,"Link from Another Site "]
[null,null,null,"Bookmarks or Favorites List"]
[null,null,null,"Typed in URL Address"]
[null,null,null,"Electronic Communication (Newsletter, E-mail, etc.)"]
[null,null,null,"Other (Please Specify)","A"]
[null,"A","Other access",null,null,"Text area,  no char limit",null,"N"]
[null,null,"Do you like the overall layout of the site?","Yes",null,"Radio button,  one-up vertical","S","Y"]
[null,null,null,"No (Please specify)","A"]
[null,"A","What do you not like about the overall layout of the site?",null,null,"Text area,  no char limit",null,"N"]
[null,null,"How could this Web site be improved? (Please be specific, i.e., navigation, future products, specific new topic content).",null,null,"Text area,  no char limit",null,"N"]
[null,null,"Did you encounter any technical difficulties while navigating the site?","Yes (Please specify)","A","Radio button,  one-up vertical","S","Y"]
[null,null,null,"No"]
[null,"A","What technical difficulties did you encounter while navigating?",null,null,"Text area,  no char limit",null,"N"]

{"sheet":"change_example CQsts (x-1-08)","index":4,"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"]}
["Model Instance Name: ",null,null,"red & strike-through:  DELETE"]
["AHRQ CAHPS",null,null,"underlined & italicized: RE-ORDER"]
["MID: ",null,null,"pink: ADDITION"]
["Date:","2008-03-01",null,"blue + -->: REWORDING"]
[]
["AHRQ CAHPS CUSTOM QUESTION LIST"]
["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":5,"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"]