{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Data Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":23,"n_cols":4,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Instructions for Use"]
[]
["This spreadsheet calculates a score for PCOQ data, as described in the user manual."]
["Scoring is simple, and you do not have to use the spreadsheet if you would prefer to follow the user manual to calculate the score manually."]
["To use this spreadsheet, complete the following steps:"]
[]
["1. Ensure you have your PCOQ data ready, with a unique patient identifier on the leftmost column followed by the 24 PCOQ items, followed by any other data you have collected."]
["2. Check that PCOQ data has been entered using only the numbers 1 - 6, as shown on the PCOQ form. There should be no text or zero values."]
["3. In The \"Data Sheet\", rename columns Z onwards with any additional data fields you have collected along with the PCOQ. You can include as many or as little columns as you like."]
["4. Copy or enter your PCOQ data into the sheet \"Data Sheet\", from row three onwards. You can include up to 3000 rows. Please contact the PCOQ owner named on the user guide if you need more than this."]
["5. Click on this scoring button -------->"]
[]
["A new sheet will be added called \"Scored Data\". This will contain the four PCOQ scores in the four leftmost columns, followed by the PCOQ data recoded as described in the user guide. The raw PCOQ data, and all other data will be to the right of this."]
[]
[]
[]
[null,null,"Raw score","New Score"]
[null,null,1,5]
[null,null,2,4]
[null,null,3,3]
[null,null,4,2]
[null,null,5,1]
[null,null,6,5]

{"sheet":"Data Sheet","index":1,"n_rows":2,"n_cols":29,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Enter or copy PCOQ data here. Do not rename the columns",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Enter or copy any other data you want to analyse here. You can rename the columns."]
["Patient ID","q1","q2","q3","q4","q5","q6","q7","q8","q9","q10","q11","q12","q13","q14","q15","q16","q17","q18","q19","q20","q21","q22","q23","q24","DataField1","DataField2","DataField3","…"]