{"text_format":"3","workbook":"xlsx","n_sheets":8,"sheets":["Instructions","Input","Collections","Patients","Races","Accrual Count","Export","Definitions"],"not_rendered":{"images":3,"macros":1,"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":28,"n_cols":5,"rows_kept":28,"merged":[[0,1,0,4],[18,1,18,4],[21,1,21,4],[24,1,24,4],[27,1,27,4]]}
[null,"CTRP Accruals Spreadsheet"]
[]
[]
[]
[null,"Revision","Purpose","Date","Author"]
[null,"1.0","Initial draft","2012-09-23","Patrick McConnell"]
[null,"1.1","Changed language","2012-10-10","Patrick McConnell"]
[null,"1.2","Changed language","2012-10-17","Patrick McConnell"]
[null,"1.3","Multi-study support","2012-11-30","Patrick McConnell"]
[null,"1.4","Fixed bugs reported by QA","2012-12-26","Patrick McConnell"]
[null,"1.5","Added country codes to fix PO-8965 reported by QA","2015-10-19","Reshma Koganti"]
[null,"1.6","Added Cut-Off Date","2017-09-07","Praneeth Polavarapu"]
[null,"1.7","Removed validation for the subject disease code","2017-09-11","Praneeth Polavarapu"]
[null,"1.8","Fix for export complete trials","2018-02-08","Praneeth Polavarapu"]
[null,"1.9","Changed race \"Native Hawaiian or other Pacific Islander\" to \"Native Hawaiian or Other Pacific Islander\"","2018-11-29","Reshma Koganti"]
[null,"2.0","Added instructions to Input page. Adjusted input page layout.","2019-08-09","Li Wang"]
[]
[null,"Purpose"]
[null,"The purpose of this Workbook is to provide an mechanism to capture accruals data to be imported into the CTRP accruals application using the Batch Import functionality.  This is an alternative to entering data directly into the CTRP Accruals application using the website, generating a batch upload file directly, or using the CTRP accruals APIs.  The ultimate goal of using this Workbook is to export data for import into CTRP Accruals using the Batch Import function on the CTRP Accruals website.  Use of that website is outside the scope of these instructions"]
[]
[null,"Entering Data"]
[null,"Data can be entered either through the Input Worksheet or directly into the Collections, Patients, Races, and Accrual Count Worksheets.  The Input Worksheet requires that you first enter study details into the first section and then click either the Complete Trials button or Abbreviated Trials button to view the rest of the fields that are available.  Then, click the Add Subject, Add Partial Subject or  Add Summary button respectively.  If the data is valid and entered correctly, it will be moved into the correct worksheet.  If you enter data into the Collections, Patients, Races, and Accrual Count Worksheets manually, you must insure that identifiers are correctly maintained across the spreadsheets and that the data is appropriately formatted.  You can click the field names on the Input Worksheet to view the definition of the field."]
[]
[null,"Exporting Data"]
[null,"Data is exported to a CSV file by navigating to the Export Worksheet and clicking the Export button.  You will be prompted for a file name, and any existing file will be overwritten.  You can only export data for Complete Trials and Abbreviated trials separately by clicking the appropriate Export button.  The study identifier is appended to the file name, and a different file is created for each study.  Clicking the Clear All Data button will erase data from the Collections, Patients, Races, and Accrual Count worksheets. "]
[]
[null,"Note"]
[null,"The Accrual Batch File Tool supports  SDC, ICD-9, ICD-10, and ICD-O-3 patient disease codes. For ICD-O-3 code system, both disease code and disease site are required. Please add them into the Subject Disease Code field. Delimited by semicolon"]

{"sheet":"Input","index":1,"n_rows":182,"n_cols":15,"rows_kept":182,"merged":[[1,1,1,6],[7,4,7,6],[8,4,20,6],[21,4,23,6],[26,6,27,6],[29,1,54,6],[55,1,57,6],[59,4,59,6],[60,4,72,6],[73,4,75,6]]}
[]
[null,"Study Details"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!A1)","v":"*Study Id"},null,{"$f":"Collections!B1","v":"Change Code"}]
[]
[]
[null,null,"Add Accrual",{"$nulls":5},{"$f":"E3","v":"Change Code"},{"$f":"C11","v":"*Study Subject Country"},{"$f":"C13","v":"*Study Subject Gender"},{"$f":"C14","v":"*Study Subject Ethnicity"},{"$f":"C15","v":"Study Subject method of payment"},{"$f":"C20","v":"*Race"},"*Subject Disease Code"]
[{"$nulls":8},1,"AF","Female","Hispanic or Latino","Managed Care","American Indian or Alaska Native","SDC"]
[{"$nulls":3},"Complete Trial Details","Instructions",{"$nulls":3},2,"AL","Male","Not Hispanic or Latino","Medicare","Asian","ICD-9"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!B1)","v":"*Study Subject ID"},null,"  Subject Birth Date Format: MM/YYYY\nThe subject's age reported in CTRP cannot be greater than 125 years.\n\n  Subject Registration Date Format: MM/DD/YYYY\n\n  Subject Disease Code: For ICD-O-3 disease code system, please add both disease code and  disease site to this field.   Delimited by a semicolon. For example: 8543/3;C50.4\n \n  ZIP code is required for US, US territories and outlying islands that use the US Postal Codes. \n\n Zip code must be a five-digit or a nine-digit (DDDDD-DDDD) value.",{"$nulls":4},"DZ","Unknown","Not Reported","Medicaid","White","ICD-10"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!C1)","v":"*Study Subject Zip Code"},{"$nulls":6},"AS","Undifferentiated","Unknown","Medicaid and Medicare","Black or African American","ICD-O-3"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!D1)","v":"*Study Subject Country"},{"$nulls":6},"AD","Unspecified",null,"Medicare and Private Insurance","Not Reported"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!E1)","v":"*Study Subject Birth Date"},{"$nulls":6},"AO",null,null,"Military or Veterans Sponsored, NOS","Unknown"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!F1)","v":"*Study Subject Gender"},{"$nulls":6},"AI",null,null,"Military Sponsored (Including CHAMPUS & TriCare)","Native Hawaiian or Other Pacific Islander"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!G1)","v":"*Study Subject Ethnicity"},{"$nulls":6},"AQ",null,null,"No Means of Payment (No Insurance)"]
[null,null,{"$f":"Patients!H1","v":"Study Subject method of payment"},{"$nulls":6},"AG",null,null,"Other"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!I1)","v":"*Registration Date"},{"$nulls":6},"AR",null,null,"Private Insurance"]
[null,null,{"$f":"Patients!J1","v":"Registering Group Identifier"},{"$nulls":6},"AM",null,null,"Self-Pay (No Insurance)"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!K1)","v":"*Study Site Identifier"},{"$nulls":6},"AW",null,null,"State Supplemental Health Insurance"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!L1)","v":"*Subject Disease Code"},{"$nulls":6},"AU",null,null,"Unknown"]
[null,null,{"$f":"CONCATENATE(\"*\",Races!C1)","v":"*Race"},{"$nulls":6},"AT",null,null,"Veterans Sponsored"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"AZ"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"BS"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"BH"]
[{"$nulls":9},"BD"]
[{"$nulls":9},"BB"]
[{"$nulls":3},"Abbreviated Trial Details",{"$nulls":5},"BY"]
[null,null,{"$f":"CONCATENATE(\"*\",'Accrual Count'!B1)","v":"*Study Site Identifier"},{"$nulls":6},"BE"]
[null,null,{"$f":"CONCATENATE(\"*\",'Accrual Count'!C1)","v":"*Study Site Accrual Count"},{"$nulls":6},"BZ"]
[null,null,"Cut-Off Date",null,"Cut-Off Date Format: mm/dd/yyyy",{"$nulls":4},"BJ"]
[null,"\nInstructions:\nAccrual batch file submissions for Abbreviated/Imported trials should contain cumulative accrual data.  CTRP expects all the accrual data on the Abbreviated/Imported trial to be submitted with each batch accrual submission.  With each new batch file submitted, the previous accrual data in CTRP will be overwritten. \n \nFor example:  Below represents summary accrual (“Cut-off Date” represented for when accrual changed) for 2 Participating Sites on an Abbreviated/Imported trial. \n\n \n\n\n\n\n\n\n\n\n\n\n\nNote:  Please ensure that your CTRP Abbreviated/Imported accrual batch file contains all cumulative accrual data for each participating site to date before uploading to CTRP.  Failure to include cumulative accrual data on Abbreviated/Imported trials will result in erasing previously submitted accrual information.  Therefore, if only the latest count is submitted, the previous records of this trial will be over-written and no longer available in the CTRP database.  For additional details, please reference:  ",{"$nulls":7},"BM"]
[{"$nulls":9},"BT"]
[{"$nulls":9},"BO"]
[{"$nulls":9},"BA"]
[{"$nulls":9},"BW"]
[{"$nulls":9},"BV"]
[{"$nulls":9},"BR"]
[{"$nulls":9},"IO"]
[{"$nulls":9},"BN"]
[{"$nulls":9},"BG"]
[{"$nulls":9},"BF"]
[{"$nulls":9},"BI"]
[{"$nulls":9},"KH"]
[{"$nulls":9},"CM"]
[{"$nulls":9},"CA"]
[{"$nulls":9},"CV"]
[{"$nulls":9},"KY"]
[{"$nulls":9},"CF"]
[{"$nulls":9},"TD"]
[{"$nulls":9},"CL"]
[{"$nulls":9},"CN"]
[{"$nulls":9},"CX"]
[{"$nulls":9},"CC"]
[{"$nulls":9},"CO"]
[{"$nulls":9},"KM"]
[{"$nulls":9},"CG"]
[null,"https://wiki.nci.nih.gov/display/CTRP/2018-12-04+User+Call+Meeting+Minutes?preview=/388041646/388041645/2018-12-04_CTRP_DT4_User%20Call.pdf.",{"$nulls":7},"CD"]
[{"$nulls":9},"CK"]
[{"$nulls":9},"CR"]
[{"$nulls":9},"CI"]
[{"$nulls":3},"Complete Trial Details","Instructions",{"$nulls":4},"GY"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!B1)","v":"*Study Subject ID"},null,"  Patient’s Date of Birth Format: MM/YYYY\n\n  Subject Registration Date Format: MM/DD/YYYY\n\n  Subject Disease Code: For ICD-O-3 disease code system, please add both disease code and disease site to this field. Delimited by a semicolon. For example: 8543/3;C50.4\n\n Zip code must be a five-digit or a nine-digit (DDDDD-DDDD) value.",{"$nulls":4},"KP"]
[null,null,{"$f":"Patients!C1","v":"Study Subject Zip Code"},{"$nulls":6},"KR"]
[null,null,{"$f":"Patients!D1","v":"Study Subject Country"},{"$nulls":6},"KW"]
[null,null,{"$f":"Patients!E1","v":"Study Subject Birth Date"},{"$nulls":6},"KG"]
[null,null,{"$f":"Patients!F1","v":"Study Subject Gender"},{"$nulls":6},"LA"]
[null,null,{"$f":"Patients!G1","v":"Study Subject Ethnicity"},{"$nulls":6},"LV"]
[null,null,{"$f":"Patients!H1","v":"Study Subject method of payment"},{"$nulls":6},"LB"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!I1)","v":"*Registration Date"},{"$nulls":6},"LS"]
[null,null,{"$f":"Patients!J1","v":"Registering Group Identifier"},{"$nulls":6},"LR"]
[null,null,{"$f":"CONCATENATE(\"*\",Patients!K1)","v":"*Study Site Identifier"},{"$nulls":6},"LY"]
[null,null,{"$f":"Patients!L1","v":"Subject Disease Code"},{"$nulls":6},"LI"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"LT"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"LU"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"MX"]
[null,null,{"$f":"Races!C1","v":"Race"},{"$nulls":6},"FM"]
[{"$nulls":9},"MD"]
[{"$nulls":9},"MC"]
[{"$nulls":9},"MN"]
[{"$nulls":9},"MS"]
[{"$nulls":9},"MA"]
[{"$nulls":9},"MZ"]
[{"$nulls":9},"MM"]
[{"$nulls":9},"NA"]
[{"$nulls":9},"NR"]
[{"$nulls":9},"NP"]
[{"$nulls":9},"NL"]
[{"$nulls":9},"AN"]
[{"$nulls":9},"NC"]
[{"$nulls":9},"NZ"]
[{"$nulls":9},"NI"]
[{"$nulls":9},"NE"]
[{"$nulls":9},"NG"]
[{"$nulls":9},"NU"]
[{"$nulls":9},"NF"]
[{"$nulls":9},"MP"]
[{"$nulls":9},"NO"]
[{"$nulls":9},"OM"]
[{"$nulls":9},"PK"]
[{"$nulls":9},"PW"]
[{"$nulls":9},"PA"]
[{"$nulls":9},"PG"]
[{"$nulls":9},"PY"]
[{"$nulls":9},"PE"]
[{"$nulls":9},"PH"]
[{"$nulls":9},"PN"]
[{"$nulls":9},"PL"]
[{"$nulls":9},"PT"]
[{"$nulls":9},"PR"]
[{"$nulls":9},"QA"]
[{"$nulls":9},"RE"]
[{"$nulls":9},"RO"]
[{"$nulls":9},"RU"]
[{"$nulls":9},"RW"]
[{"$nulls":9},"KN"]
[{"$nulls":9},"LC"]
[{"$nulls":9},"VC"]
[{"$nulls":9},"WS"]
[{"$nulls":9},"SM"]
[{"$nulls":9},"ST"]
[{"$nulls":9},"SA"]
[{"$nulls":9},"SN"]
[{"$nulls":9},"SC"]
[{"$nulls":9},"SL"]
[{"$nulls":9},"SG"]
[{"$nulls":9},"SK"]
[{"$nulls":9},"SI"]
[{"$nulls":9},"SB"]
[{"$nulls":9},"SO"]
[{"$nulls":9},"ZA"]
[{"$nulls":9},"GS"]
[{"$nulls":9},"ES"]
[{"$nulls":9},"LK"]
[{"$nulls":9},"SH"]
[{"$nulls":9},"PM"]
[{"$nulls":9},"SD"]
[{"$nulls":9},"SR"]
[{"$nulls":9},"SJ"]
[{"$nulls":9},"SZ"]
[{"$nulls":9},"SE"]
[{"$nulls":9},"CH"]
[{"$nulls":9},"SY"]
[{"$nulls":9},"TW"]
[{"$nulls":9},"TJ"]
[{"$nulls":9},"TZ"]
[{"$nulls":9},"TH"]
[{"$nulls":9},"TG"]
[{"$nulls":9},"TK"]
[{"$nulls":9},"TO"]
[{"$nulls":9},"TT"]
[{"$nulls":9},"TN"]
[{"$nulls":9},"TR"]
[{"$nulls":9},"TM"]
[{"$nulls":9},"TC"]
[{"$nulls":9},"TV"]
[{"$nulls":9},"UG"]
[{"$nulls":9},"UA"]
[{"$nulls":9},"AE"]
[{"$nulls":9},"GB"]
[{"$nulls":9},"US"]
[{"$nulls":9},"UM"]
[{"$nulls":9},"UY"]
[{"$nulls":9},"UZ"]
[{"$nulls":9},"VU"]
[{"$nulls":9},"VE"]
[{"$nulls":9},"VN"]
[{"$nulls":9},"VG"]
[{"$nulls":9},"VI"]
[{"$nulls":9},"AX"]
[{"$nulls":9},"BL"]
[{"$nulls":9},"GG"]
[{"$nulls":9},"IM"]
[{"$nulls":9},"JE"]
[{"$nulls":9},"ME"]
[{"$nulls":9},"MF"]
[{"$nulls":9},"PS"]
[{"$nulls":9},"RS"]
[{"$nulls":9},"TL"]
[{"$nulls":9},"WF"]
[{"$nulls":9},"EH"]
[{"$nulls":9},"YE"]
[{"$nulls":9},"ZM"]
[{"$nulls":9},"ZW"]

{"sheet":"Collections","index":2,"n_rows":1,"n_cols":2,"rows_kept":1}
["Study Id","Change Code"]

{"sheet":"Patients","index":3,"n_rows":1,"n_cols":12,"rows_kept":1}
["Study Id","Study Subject ID","Study Subject Zip Code","Study Subject Country","Study Subject Birth Date","Study Subject Gender","Study Subject Ethnicity","Study Subject method of payment","Registration Date","Registering Group Identifier","Study Site Identifier","Subject Disease Code"]

{"sheet":"Races","index":4,"n_rows":1,"n_cols":3,"rows_kept":1}
["Study Id","Study Subject ID","Race"]

{"sheet":"Accrual Count","index":5,"n_rows":1,"n_cols":4,"rows_kept":1}
["Study Id","Study Site Identifier","Study Site Accrual Count","Cut-Off Date"]

{"sheet":"Export","index":6,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Definitions","index":7,"n_rows":17,"n_cols":5,"rows_kept":17,"merged":[[0,2,0,4]]}
[null,null,"Required/Conditional"]
["Data Element","Definition","Subject","Partial","Summary"]
["Study Id","This is the unique identifier assigned to the study.","R","R","R"]
["Change Code","Whether the data has not changed since the last report"]
["Study Subject ID","Unique identifier (PO ID) assigned to the institution accruing the patient to the study.","R","R"]
["Study Subject Zip Code","The string of characters used to identify the five-digit or 9-digit Zone Improvement Plan (ZIP) code that represents the geographic segment that is a subunit of the ZIPcode, assigned by the U.S. Postal Service to a geographic location to facilitate mail delivery. Zip Code is mandatory if the patient’s Country of Residence is the U.S, U.S. territories and outlying islands","C"]
["Study Subject Country","CTRP is using the International Standards Organization country codes. ","R"]
["Study Subject Birth Date (MM/YYYY)","The month and year on which the person was born\nNote: The subject's age reported in CTRP cannot be greater than 125 years.","R"]
["Study Subject Gender","Text designations that identify gender. Gender is described as the assemblage of properties that distinguish people on the basis of their societal roles.","R"]
["Study Subject Ethnicity","The text for reporting information about ethnicity based on the Office of Management and Budget (OMB) categories.","R"]
["Study Subject method of payment","Text term for an entity, organization, government, corporation, health plan sponsor, or any other financial agent who pays a healthcare provider for the healthcare service rendered to a person or reimburses the cost of the healthcare service."]
["Registration Date","Date the subject was registered for the study.","R","R"]
["Registering Group Identifier","Unique identifier (PO ID) assigned to the group that originally registered the patient for the study"]
["Study Site Identifier","Unique identifier (numeric or alphanumeric) assigned to the study site","R","R","R"]
["Subject Disease Code","Code that identifies a disease","R"]
["Study Subject Race","The text for reporting information about race based on the Office of Management and Budget (OMB) categories.","R"]
["Study Site Accrual Count","Numeric count of subjects accrued at a study site to date",null,null,"R"]