{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Summary","x","Coverage Analysis","CA Data-Validation","Effort","Visit Cost","Fees-Invoiceables","QQBR"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":27,"comments":1,"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":"Summary","index":0,"n_rows":67,"n_cols":14,"rows_kept":67,"cut":false,"hidden":false,"merged":[[27,13,39,13],[52,13,130,13],[6,13,11,13],[13,13,15,13],[17,13,25,13],[41,13,49,13],[66,0,73,0],[8,1,8,11],[9,0,9,1],[9,2,9,5],[9,6,9,7],[9,8,9,11],[10,0,10,1],[10,2,10,5],[10,6,10,7],[10,8,10,11],[14,0,14,2],[14,3,14,5],[14,6,14,7],[14,9,14,11],[15,0,15,11],[13,0,13,2],[13,3,13,5],[13,8,13,11],[0,0,0,11],[1,0,1,11],[2,0,2,11],[3,0,3,11],[7,0,7,11],[5,10,5,11],[6,10,6,11],[5,3,5,5],[6,3,6,5],[5,7,5,8],[6,7,6,8],[5,0,5,2],[6,0,6,2],[16,0,16,11],[11,0,11,1],[11,2,11,5],[11,6,11,7],[11,8,11,11],[12,0,12,2],[12,3,12,5],[12,6,12,7],[12,8,12,11],[13,6,13,7],[20,0,20,1],[20,2,20,3],[20,4,20,5],[20,7,20,8],[21,0,21,1],[21,2,21,3],[21,4,21,5],[21,7,21,8],[17,0,17,1],[17,2,17,3],[17,4,17,5],[17,7,17,8],[18,0,18,1],[18,2,18,3],[18,4,18,5],[18,7,18,8],[19,0,19,1],[19,4,19,5],[19,2,19,3],[19,7,19,8],[24,0,24,1],[24,2,24,3],[24,4,24,5],[24,7,24,8],[26,0,26,1],[26,2,26,3],[26,4,26,5],[26,7,26,8],[22,0,22,1],[22,2,22,3],[22,4,22,5],[22,7,22,8],[23,0,23,1],[23,2,23,3],[23,4,23,5],[23,7,23,8],[25,4,25,5],[25,2,25,3],[25,0,25,1],[25,7,25,8],[34,6,34,8],[34,9,34,10],[27,0,27,6],[27,7,27,8],[28,0,29,11],[30,0,30,5],[30,6,30,8],[31,0,31,5],[31,6,31,8],[32,9,32,10],[35,9,35,10],[36,0,36,5],[37,7,37,9],[38,7,38,9],[39,7,39,9],[40,0,40,5],[4,3,4,5],[4,0,4,2],[56,6,62,6],[56,1,62,5],[56,0,62,0],[51,0,55,11],[56,7,62,11],[41,0,41,5],[41,6,41,11],[42,0,42,5],[42,6,42,11],[43,0,44,11],[45,0,50,11],[32,0,32,5],[33,0,33,5],[33,6,33,8],[33,9,33,10],[34,0,34,5]]}
["The University of Texas Health Science Center at Houston"]
["Clinical Trials Detailed Budget Worksheet "]
["THIS FILE IS FOR INTERNAL USE ONLY. CONTACT CRF@uth.tmc.edu WITH ANY COMMENTS OR QUESTIONS"]
["Version  08/19/2026"]
[]
["Date:",null,null,null,null,null,"Coverage Analysis Complete By:",null,null,"Complexity",null,null,null,"Study Information"]
["Budget Complete By:",null,null,null,null,null,"Email",null,null,"Est. Project Period (include all yrs):","MM/DD/YYYY - MM/DD/YYYY",null,null,"•  Personnel are automatically populated from the Summary tab, across all sheets.  Please add additional personnel on the Summary tab.\n•  Complete all Yellow cells  \nStep 1: Complete the Project Information\nStep 2: Complete the salary amount for the personnel that will work on the project.  If multiple staff are on the project, use the highest salary among the staff.\nStep 3: The Fringe Rate is a tiered calculation."]
["PROJECT INFORMATION:  Enter the information below."]
["Project Title:","title"]
["Principal Investigator:",null,"PI",null,null,null,"Department:",null,"SPA"]
["Sponsor:",null,"Spon",null,null,null,"CRO:",null,"CRO"]
["CPHS Study Number:",null,"IRB num",null,null,null,"Primary Coordinator Name:",null,"NAME"]
["Pre-screen (Est # of Charts)",null,null,"1",null,null,"IDE #:",null,"IDE num",null,null,null,null,"Screening and Enrollment"]
["Screen Fail (Est. # of Participants)",null,null,1,null,null,"ClinicalTrials.gov # / NCT #:",null,"NCT number",null,null,null,null,"Example:  We will need to review about 250 charts (pre-screen) to identify and consent 25 (screen) that meet enrollment criteria to enroll 10 (target enrollment) participants\nTarget Enrollment:  Enter the number of participants to be enrolled/completed at UTHealth Houston.\nScreen (Est. # of participants):  enter the number of participants expected to consent and complete the screening visit(s). (Include estimated screen fails.)  \nPre-Screen (Est # of charts/records):  Enter the estimated number of charts or other records to be reviewed to identify participants for potential study enrollment.  \n"]
["TARGET ENROLLMENT:",null,null,1,null,null,"IDC RATE: ",null,0.3,"Non-negotiable for all industry sponsors."]
["PERSONNEL COSTS:  These are required for the UTH internal budget, but are not always included in the sponsor's budget;  personnel costs are included in effort-based costs below; the PI's effort must be at least 2%."]
["SALARIES:  Enter salary (REG + LONG + AUG) for the PI and others.  Or, for staff, choose a salary from the range for that position."]
["Position",null,"Name",null,"Salary (Inc Comp for all)",null,"% Effort","Request",null,"Fringe Rate","Fringe $","Total",null,"Personnel\n• Effort is a calculation based on the information provided on the \"Effort\" tab.  This field is not editable and will populate from providing the information on the effort tab.\n• The costs section will calculate after the \"Effort\" tab is complete.\n• PI / PI Oversight:  PI effort (per effort tab × hourly rate) primarily covers study start-up and visits, and includes oversight of all study activities: ensuring informed consent, IRB approval, and participant safety; strict adherence to the protocol with complete, audit-ready records; supervision, training, and credentialing of qualified staff; proper drug handling per protocol; accurate and reliable data collection; and timely reporting to sponsors and regulatory bodies with clear team communication.\n• Coordinator/ Coordinator Admin:  Maintain and organize subject files; update PI and/or sponsor on enrollment progress; communicate with collaborating researchers and the PI (e.g., Co-Is, Radiology, MHH, CRU); conduct pre-screening by reviewing EMR and clinic schedules to identify eligible Participants; perform study-related phone calls with subjects; and prepare/submit protocol amendments to the IRB.\n• Industry Studies: Prepare and maintain the regulatory binder (including IRB approvals, monitoring reports, IND reports, etc.); maintain the delegation of authority log; and respond to sponsor database queries."]
["PI",null,{"$f":"C10","v":"PI"},null,null,null,{"$f":"$D$15*Effort!AL20 + VALUE(Effort!W60)","v":1.4423076923076924E-3},{"$f":"SUM(E19*G19)","v":0},null,{"$f":"IF($E19<40000,x!C3, IF(AND($E19>39999,$E19<70000), x!$C$4, IF(AND($E19>69999,$E19<150000), x!$C$5, IF(AND($E19>149999,$E19<230000), x!$C$6, IF(AND($E19>229999,$E19<500000), x!$C$7, IF($E19>499999, x!$C$11))))))*1","v":0.55000000000000004},{"$f":"SUM(H19*J19)","v":0},{"$f":"SUM(H19+K19)","v":0}]
["PI Oversight",null,{"$f":"C10","v":"PI"},null,{"$f":"E19","v":0},null,0.02,0,null,{"$f":"IF($E20<40000,x!C4, IF(AND($E20>39999,$E20<70000), x!$C$4, IF(AND($E20>69999,$E20<150000), x!$C$5, IF(AND($E20>149999,$E20<230000), x!$C$6, IF(AND($E20>229999,$E20<500000), x!$C$7, IF($E20>499999, x!$C$11))))))*1","v":0.46},0,0]
["Coordinator",null,{"$f":"I12","v":"NAME"},null,null,null,{"$f":"$D$15*Effort!AL21 + VALUE(Effort!W61)","v":1.4423076923076924E-3},0,null,{"$f":"IF($E21<40000,x!C5, IF(AND($E21>39999,$E21<70000), x!$C$4, IF(AND($E21>69999,$E21<150000), x!$C$5, IF(AND($E21>149999,$E21<230000), x!$C$6, IF(AND($E21>229999,$E21<500000), x!$C$7, IF($E21>499999, x!$C$11))))))*1","v":0.35},0,0]
["Coordinator Admin",null,{"$f":"I12","v":"NAME"},null,{"$f":"E21","v":0},null,{"$f":"MIN(ROUNDUP(D15/10,0)*0.05,1)","v":0.05},0,null,{"$f":"IF($E22<40000,x!C6, IF(AND($E22>39999,$E22<70000), x!$C$4, IF(AND($E22>69999,$E22<150000), x!$C$5, IF(AND($E22>149999,$E22<230000), x!$C$6, IF(AND($E22>229999,$E22<500000), x!$C$7, IF($E22>499999, x!$C$11))))))*1","v":0.28999999999999998},0,0]
["Financial Management",null,null,null,null,null,{"$f":"$D$15*Effort!AL23 + VALUE(Effort!W63)","v":0},0,null,{"$f":"IF($E23<40000,x!C7, IF(AND($E23>39999,$E23<70000), x!$C$4, IF(AND($E23>69999,$E23<150000), x!$C$5, IF(AND($E23>149999,$E23<230000), x!$C$6, IF(AND($E23>229999,$E23<500000), x!$C$7, IF($E23>499999, x!$C$11))))))*1","v":0.25},0,0]
[null,null,null,null,null,null,{"$f":"$D$15*Effort!AL24 + VALUE(Effort!W64)","v":0},0,null,{"$f":"IF($E24<40000,x!C8, IF(AND($E24>39999,$E24<70000), x!$C$4, IF(AND($E24>69999,$E24<150000), x!$C$5, IF(AND($E24>149999,$E24<230000), x!$C$6, IF(AND($E24>229999,$E24<500000), x!$C$7, IF($E24>499999, x!$C$11))))))*1","v":0.23},0,0]
[null,null,null,null,null,null,{"$f":"$D$15*Effort!AL25 + VALUE(Effort!W65)","v":0},0,null,{"$f":"IF($E25<40000,x!C9, IF(AND($E25>39999,$E25<70000), x!$C$4, IF(AND($E25>69999,$E25<150000), x!$C$5, IF(AND($E25>149999,$E25<230000), x!$C$6, IF(AND($E25>229999,$E25<500000), x!$C$7, IF($E25>499999, x!$C$11))))))*1","v":0.2},0,0]
[null,null,null,null,null,null,{"$f":"$D$15*Effort!AL26 + VALUE(Effort!W66)","v":0},0,null,{"$f":"IF($E26<40000,x!C10, IF(AND($E26>39999,$E26<70000), x!$C$4, IF(AND($E26>69999,$E26<150000), x!$C$5, IF(AND($E26>149999,$E26<230000), x!$C$6, IF(AND($E26>229999,$E26<500000), x!$C$7, IF($E26>499999, x!$C$11))))))*1","v":0.16},0,0]
[null,null,null,null,null,null,{"$f":"$D$15*Effort!AL27 + VALUE(Effort!W67)","v":0},0,null,{"$f":"IF($E27<40000,x!C11, IF(AND($E27>39999,$E27<70000), x!$C$4, IF(AND($E27>69999,$E27<150000), x!$C$5, IF(AND($E27>149999,$E27<230000), x!$C$6, IF(AND($E27>229999,$E27<500000), x!$C$7, IF($E27>499999, x!$C$11))))))*1","v":0.13},0,0]
["Start of Study/Project Personnel Costs (Inc Startup Effort)",null,null,null,null,null,null,{"$f":"SUM(H19:H27)","v":0},null,null,{"$f":"SUM(K19:K27)","v":0},{"$f":"SUM(L19:L27)","v":0},null,"Clinical Study Costs Summary Notes:\t\n•  No data entry is required. \n•  Subtotal Startup pulls from \"Startup & Inv.\" tab cell D18\n•  Subtotal Invoiceable pulls from \"Startup & Inv.\" tab cell D44\n•  Total Direct Cost is a sum of Startup Costs and Invoiceable Costs \n•  Subtotal Effort Based Per Patient Costs is a sum of (estimated #hrs x hourly salary rates)\n•  Subtotal Expensed Based Per Patient Costs is a sum of totals on row 38 of the \"Cost-Expenses\" tab.\n•  Total Direct Per Patient Costs is (Effort+Expense Based per patient costs)*(number of expected Participants)\n•  Total Indirect Cost is (L30+L34)* Indirect Cost Rate\n•  Total Direct Costs for R&A is a sum of Startup Costs and Total Direct Per Patient Costs. This total should be used on your R&A form. \n•  Total Indirect Costs for R&A is Total Direct Costs for R&A * Indirect Cost Rate\n•  Total Costs for R&A is a sum of Total Direct Costs for R&A and Total Indirect Costs for R&A\n•  Total Anticipated Study Costs is a sum of (L30+L33+L34)\nStep 4:   •  Enter the amount funded by the sponsor.   \n•  Study Revenue will be a positive number and show as green; Study Deficit will be a negative number and show as red          "]
["Clinical Study Costs Summary"]
[]
["Subtotal Startup Costs (Excluding: Start up Effort+ IDC)",null,null,null,null,null,null,null,null,null,null,{"$f":"'Fees-Invoiceables'!D19","v":{"$error":"#VALUE!"}}]
["Subtotal Invoiceable Costs (Excluding IDC) not included in total",null,null,null,null,null,{"$f":"'Fees-Invoiceables'!D44","v":0}]
["Subtotal Effort  Costs for 1 patient  (excluding IDC)",null,null,null,null,null,null,null,null,{"$f":"L28/D15","v":0}]
["Subtotal Expense Costs for 1 patient (excluding IDC)",null,null,null,null,null,null,null,null,{"$f":"SUM('Visit Cost'!C77:CD77)","v":0}]
["Study/Project Direct Expenses  (excluding IDC and personnel expenses)",null,null,null,null,null,null,null,null,null,null,{"$f":"J34*D15","v":0}]
["Sub Total Direct Costs  Personnel + Expenses+ Startup",null,null,null,null,null,null,null,null,null,null,{"$f":"L35+L31+L28","v":{"$error":"#VALUE!"}}]
["Total Indirect Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"L36*I15","v":{"$error":"#VALUE!"}}]
["START Proposal: Total Direct Costs  (Enter into START) ",null,null,null,null,null,null,{"$f":"H40/(1+I15)","v":0}]
["START Proposal: Total Indirect Costs   (auto populates in START)",null,null,null,null,null,null,{"$f":"H40-H38","v":0}]
["START Proposal: Total Costs  (auto populates in START)",null,null,null,null,null,null,{"$f":"G42","v":0}]
["Total Anticipated Internal Study Costs",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L36:L37)","v":{"$error":"#VALUE!"}}]
["Total Anticipated Revenue",null,null,null,null,null,null,null,null,null,null,null,null,"•  Note for Principal Investigator: The  final copy of  this budget/CA is attached to the proposal record in START.  By signing the START proposal record you are certifying that  the   coverage analysis internal budget (CAIB) tool attached  accurately reflects the billing   determinations and anticipated costs to conduct the study. Per institutional policy (HOOP 214) The PI is responsible for assigning staff to ensure the charges are billed in accordance with the coverage analysis.\n•  Please note, salary recharge is based on the information provided in this table.\n•  SPA will combine SC per visit and SC administrative effort when calculating salary expenses. \n        o  Example: Start up invoicables and Close out invoicables are certain to be invoiced/paid.\n        o  Some contracts are set up to include many items that are certain to be invoiced/paid as invoicables. Each contract is unique.\t"]
["Study Balance or Deficit",null,null,null,null,null,{"$f":"G42-L41","v":{"$error":"#VALUE!"}}]
["COMMENTS:"]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"•  Total anticipated revenue L42 should consist of all costs paid for by the Sponsor. These include, all fees, pass through costs and reimbursements. In addition, it should also include per patient revenue. (Sponsor/Grant Revenue + Expected Billable Clinical Revenue =TAR)\n•  STUDY TEAM you should leave relevant notes in the “Comments” section to help expedite Proposal record budget review.  "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"COMPLETING COVERAGE ANALYSIS TAB\n\t\nAdding Rows and Columns:\t\t\n\tUsing the Macro keys at the top will add rows and columns to the end of each section.\n\t\t\t\t\t\nEntering Protocol Activities:\t\t\n\tYou can find activities utilizing the drop down menus or by directly typing into the Procedures/Activities Column\n\tA location must be selected for every item listed.\n\tA CPT code must be listed for every item that is not identified as a \"non-billable\"\n\tA justification must be provided for each item marked as Standard of Care (SOC)\n\t\t\t\t\t\nSelecting Coverage Type:\t\t\n\tA non-billable item is one that will not appear in the GE Centricity billing system.\n\tNB-Cost for Research is a non-billable item that will still be invoiced on a per-patient basis to the research account (e.g. Department set room charge)\n\tRES identifies a billable procedure that will appear in the GE Centricity billing system that needs to be charged to the research account.\n\tSOC identifies a standard of care procedure that will be billed to the patient/patient's insurance.\n\t\t\t\t\t\nCOMPLETING EFFORT TAB\n\t\t\t\t\t\nAdding Personnel:\t\t\t\n\tPersonnel are automatically populated from the Summary tab.  Please add additional personnel on the Summary tab.\n\t\t\t\t\t\nInputting Time and Effort:\t\t\n\tIn the upper table input the total estimated time that the individual is expected to devote for a single patient at each visit.  \n\tThe lower table automatically calculates the hourly rate for each individual based on the information from the Summary Tab.\n\t\t\t\t\t\nCOMPLETING COST-EXPENSES TAB\n\t\t\t\t\t\nUpdate Table:\t\t\t\t\n\tThe table does not automatically update.  If changes are made to the coverage analysis tab, then you will need to click on the Update Table Macro.\n\t\t\t\t\t\nAdding Pricing:\t\t\t\t\n\tFor each item marked as RES or NB-Cost for Research, the cell will unlock and turn yellow.  \n\tInput the unit price for each.  Remember that some procedures are split into a technical fee from MHHS and professional fee from UTP.\n\tEach column will automatically subtotal and calculate the IDC for the entire visit.\n\t\t\t\t\t\nCOMPLETING START UP AND INVOICEABLES TAB\n\t\t\t\t\t\nStartup Time and Effort:\t\t\t\n\tScroll down to Rows 54-60.\t\n\tThe personnel will automatically pull from the summary tab  Add additional personnel on the Summary tab first.\n\tFor each startup activity listed, provide the total amount of time each individual is expected to spend on that activity in the available yellow box.\n\tTo the right, total effort will be calculated based on a standard 40 hour work week during a single calendar year.\n\t\t\t\t\t\nOther Startup Costs:\t\t\t\n\tScroll up to the top of the tab.\t\n\tFor each other additional startup costs (not effort based) provide a brief description in the Start Up Costs column.\n\tFor each item provide the price prior to IDC.  (do not put what you are charging the sponsor, but the actual cost that will hit the account before IDC).\n\tFor IRB costs select the appropriate review cost and delete the one that is not needed.\n\tAll IDC costs will automatically calculate.\n\tTotal Startups and IDC will automatically calculate at the bottom of the table.\n\t\t\t\t\t\nInvoiceable Costs:\t\t\t\n\tProvide a brief description of the invoiceable in the Invoiceable Procedure column.\n\tProvide the price that will be paid from the research account in the Unit Price column (do not put what you are charging the sponsor, but the actual cost of the item)\n\tUnder Quantity put the maximum number you are allowed to invoice for per the sponsor, if this is unlimited you can estimate how many you may see during the life of the trial.\t\t\t\t\t\n\t\t\t\t\t\nCOMPLETING QQBR TAB\n\t\t\t\t\t\nYOU ONLY NEED TO COMPLETE THE SECTIONS THAT APPLY TO YOUR STUDY\n\t\t\t\t\t\nFor device studies answer the questions in the top section.\nFor drug/biologic/behavioral studies answer the questions in the bottom section.\nOnce all questions have been answered have the PI sign the certification at the bottom of the page."]
[]
[]
[]
["PI Signature: ",null,null,null,null,null,"Date: "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null," For Industry initiated studies  you will enter I35 under M&O in START  (IDC and Grand total will auto populate/calculate in START.) See CT  guidance document for more details "]
[]
[]
[]
[]
[]
[]
[]
["\t"]

{"sheet":"x","index":1,"n_rows":44,"n_cols":7,"rows_kept":44,"cut":false,"hidden":true,"merged":[[0,0,0,2],[0,4,0,6]]}
["FY27 Benefit Tiers",null,null,null,"FY27 Benefit Tiers - Students"]
["min ","max","rate",null,"min ","max","rate"]
[0,39999,0.55000000000000004,null,0,4999,0.09]
[40000,69999,0.46,null,5000,14999,0.51]
[70000,149999,0.35,null,15000,29999,0.53]
[150000,199999,0.28999999999999998,null,30000,"+",0.34]
[200000,299999,0.25]
[300000,349999,0.23]
[350000,499999,0.2]
[500000,599999,0.16]
[600000,"+",0.13]
[]
[]
[]
[]
[]
["Project Staff"]
["PI"]
["Staff"]
["Study Coordinator"]
[" "]
[]
["Administrative fee"]
["    Low intensity (0-4 hours)",300]
["    Moderate intensity (5-9 hours)",675]
["    High intensity (10+ hours)",1100]
[]
["Protocol submission fee"]
["    Low intensity (0-8 hours)",650]
["    Moderate intensity (8-20 hours)",1300]
["    High intensity (20+ hours)",2600]
[]
["Research vs. SOC"]
["Research"]
["SOC"]
[]
["Study Type"]
["Device"]
["Drug"]
["HUD"]
[]
["YES/NO"]
["Yes"]
["No"]

{"sheet":"Coverage Analysis","index":2,"n_rows":72,"n_cols":39,"rows_kept":72,"cut":false,"hidden":false,"merged":[[1,2,1,3],[1,0,1,1],[2,0,2,1],[4,0,4,1],[5,0,5,1],[3,0,3,1]]}
[]
[{"$f":"Summary!A9","v":"Project Title:"},null,{"$f":"Summary!B9","v":"title"}]
[{"$f":"Summary!A10","v":"Principal Investigator:"},null,{"$f":"Summary!C10","v":"PI"}]
[{"$f":"Summary!A11","v":"Sponsor:"},null,{"$f":"Summary!C11","v":"Spon"}]
[{"$f":"Summary!A12","v":"CPHS Study Number:"},null,{"$f":"Summary!C12","v":"IRB num"}]
[{"$f":"Summary!A13","v":"Pre-screen (Est # of Charts)"},null,{"$f":"Summary!D13","v":"1"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Version Date:",{"$f":"LastSavedTimeStamp()","v":"2026-08-19T10:45:01"}]
[]
["Category ","Procedures/ Activities","Location ","CPT Code","CDM Code","V1","V2","V3","V4","V5","V6","V7","V8","V9","V10","V11","V12","V13","V14","V15","V16","V17","V18","V19","V20","V21","V22","V23","V24","V25","V26","V27","V28","V29","V30","V31","V32","V33","Justifications "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["NOT LISTED IN PROTOCOL SCHEDULE "]
[]
[null,"CRF Data Entry",null,{"$f":"IF(ISNA(VLOOKUP(B69,'CA Data-Validation'!$A$121:$B$489,2,FALSE)),\"\",VLOOKUP(B69,'CA Data-Validation'!$A$121:$B$489,2,FALSE))","v":""}]
[null,"Chart set up",null,{"$f":"IF(ISNA(VLOOKUP(B70,'CA Data-Validation'!$A$121:$B$489,2,FALSE)),\"\",VLOOKUP(B70,'CA Data-Validation'!$A$121:$B$489,2,FALSE))","v":""}]
[null,"Schedule next visit",null,{"$f":"IF(ISNA(VLOOKUP(B71,'CA Data-Validation'!$A$121:$B$489,2,FALSE)),\"\",VLOOKUP(B71,'CA Data-Validation'!$A$121:$B$489,2,FALSE))","v":""}]
[null,"Describe Study drug",null,{"$f":"IF(ISNA(VLOOKUP(B72,'CA Data-Validation'!$A$121:$B$489,2,FALSE)),\"\",VLOOKUP(B72,'CA Data-Validation'!$A$121:$B$489,2,FALSE))","v":""}]

{"sheet":"CA Data-Validation","index":3,"n_rows":489,"n_cols":21,"rows_kept":489,"cut":false,"hidden":true,"merged":[]}
["Patient Payment","Visits","Labs        ","Anesthesiology","XRay Imaging","Tissue ","Ultrasound ","CT","MRI MRA","Nuclear Radiology","EKG ECHO","Pulmonary","Pharmacy","Parking","Cardiac","OR","Biopsy","Fluoroscopy","PET","Neurophysiology","Other"]
["Patient Payment","Clinic Visit_Est. Patient Level 1","Albumin Serum","Anes Endotracheal Tube","Abdomen Acute Series Complete","Research Handling Fee- blocks","US Abdomen Complete","Creatinine Blood Non OPID-*only use with Contrast for CT","Creatinine Blood Non OPID-*only use with Contrast for MRI","Bone Density DXA Axial Skelet","Cable ECG 12 V Lead","6 min walk","New Study Set-Up / Administrative Fee (Inpatient Study)","CRU Parking ","Angio Coronary w/o Heart Cath","Cable ECG 12 V Lead","EKG Hourly Monitor Charge","Fluoro Local  NDL Biopsy/ Aspiration","CT Thorax W/O Contrast","13 or more Nerve Conduct","Other"]
[null,"Clinic Visit_New Patient Level 2","Alk Phosphatase","Anes srvs General 1st 30 min","Abdomen AP View","Research Unstained Slides","US Abdomen Limited","OPID CT Omnipaque 300ML 10-*only use with CT and Angio Contrast","IV START PAK-*only use with Contrast for MRI","Bone Scan Three Phase Study","ECG 12/15 Lead","Alprazolam 1 MG Tab","New Study Set-Up / Administrative Fee  (Outpatient Study)",null,"Blood O2 Saturation only","Cardiac Output Measurement","Conscious Sedation> 5 years old, first 30 min",null,"PET Brain Imaging Met Eval"]
[null,"Clinic Visit_New Patient Level 3","Alpha -fetoprotein","Anes srvs General add 15 mins","Ankle 2 Views Bilateral",null,"US Brain Scan","Iodixanol 320MG/ML INJ(200ML)- *only use with CT and Angio Contrast","Electrode MRI ECG Quatrade-*only use with Contrast for MRI","Bone Scan Tomogram Spect","12 Lead ECG CPT (Tracing & Interpretation only)","Blood Gas","Annual Refrig Storage Fee",null,"Cath Lab Treatment Room","Cath 8F Cardiac Output","Skin biopsy + add  Lesion",null,"PET CT Tumor Image Skull MIDTH"]
[null,"Clinic Visit_ Est. Patient Level 4","ALT (SGPT)","Desflurane Per case","Ankle 2 Views Unilateral",null,"US Chest","Injection Kit Dual Syringe-*only use with Contrast for CT","Monitor Non-Invasive","Bone Scan Whole Body","ECG Rhythym Strip","Blood O2 Saturation","Annual Study Maintenance Fee",null,"DSA Analysis Coronary","Drape Intraop Probe SM T TIP","Oxygen ",null,"PET CT Tumor Imaging LTD area"]
[null,"Clinic Visit_ Est. Patient Level 5","Amplified Probe(MSRA)","Invasive Pressure Monitor","Ankle Complete 3+V Uni",null,"US Duplex Abd/Pel/Scrot/Kid","CT Abdomen w/Contrast","MRI Kit-*only use with Contrast for MRI","Bone Scan Whole Body","Echo 2D M Mode Comp w/Color Fl","Bronchoscopy w/Biopsy","Miscellaneous IDS FEE 15 min",null,"DSA Analysis LV Gram","Dressing Bio Patch","Biopsy Tray",null,"PET CT Tumor Imaging Whole BD"]
[null,"Room Charge","AST (SGOT)","Kit Transd 3 ml 12 in 72 in TB","Bone Density DXA Axial Skelet",null,"US Duplex Ext Veins Bilat","CT Abdomen w/out Contrast","GADOBENATE 1ML VL(7935MG/15ML)-*(contrast x 15 (qty 15= qty is equal to 1ML VL (7935MG/15ML) per 150 lb patient)  only use with Contrast for MRI","Bone Scan, Multiple Area","Echo 2D M Mode Complete","Bronchoscopy w/Bronchial Lavag","Patient Randomization",null,"Injection Venous Bypass Grafts","Injection IV Push 1st drug","Universal Precautions",null,"PET Myocard Imag Metabolic Eval"]
[null,"Venipuncture","Basic Metabolic Panel","Oximeter P/Day","Bone Survey Complete",null,"US Pelvis Complete","CT Abodomen w/out - w/Contrast","MRA Abdomen w/Contrast","Brain Scan Spect","Echo 2D M Mode Limited","Bronchoscopy w/Brushing","Per Dose RX Dispensing Fee",null,"Left & Right Heart Cath","Kit Perc Intro 8.5 FR","Pulse Oximeter",null,"PET Myocard Imag Metabolic Eval"]
[null,null,"Beta-Natriuretic Peptide (BNP)",null,"Both Knees standing anteroposterior",null,"US Retroperitoneal Limited","CT Angio Abdomen","MRA Abdomen w/out Contrast","Cardiac Scan Gated Multi(MUGA)","Echo Doppler Complete","Cardiac Output Measurement","Storage Of Used Study Medication",null,"Procedure Prep","Minor Proc Recovery  1 st hour","Biopsy Lung perc",null,"PET Tumor Image Skull Midthigh"]
[null,null,"Bicarbonate(CO2)",null,"Chest AP w/Fluoro",null,"US Scrotum & Contents","CT Angio Aorta w/Fem Runoff","MRA Abdoment w/out - w/Contrast","Cold Pyrophosphate per dose","Echo Doppler Limited","D5W 500 ml Bag","Study Annual Documentation Fee",null,"S&I Abdominal Aortagram","Minor Proc Recovery  add 30 minutes ","Skin biopsy Single Lesion",null,"PET Tumor Imaging"]
[null,null,"Bilirubin Direct",null,"Chest AP w/Lordotic",null,"US Transpl Kidney w/ Dop","CT Angio Chest w/o - w/Contrast","MRA Chest w/Contrast","Lung Perfusion Scan","Echo Follow-Up Congenital","Diffusion Capacity (DLCO)",null,null,"S&I Arterial /Vent/Angio ( Pedi)","Oxi Adult Sensor","Kit Bone Biopsy",null,"PET Tumor Imaging Limited area"]
[null,null,"Bilirubin Total",null,"Chest 2 view AP & Lateral",null,"US Transpl Kidney w/out Dop","CT Angio Extr Lower w/Contrast Uni","MRA Chest w/out - w/Contrast","TC-99M Sulfur Colloid Per Dose","Echo Follow-Up/Limited","Fentanyl 100 MCG/2 ml Vl",null,null,"S&I Cor/Pulm/Aort Angio","Pack Line Linen","Pressure bag vital signs",null,"PET Tumor Imaging Whole Body"]
[null,null,"Blood Culture",null,"Chest AP Single View",null,"US Transrectal","CT Angio Extr Lower w/o - w/Bi","MRA Head w/Contrast",null,"Echo w/Contrast","Injection  Internal Mammary",null,null,null,"Phase 2 PACU Ea Add 30 min-Rout","IV Catheter #18-24"]
[null,null,"BUN",null,"Knee 1 or 2 views",null,"US Transvaginal","CT Angio Extr Upper w/Contrast Bi","MRA Head w/out - w/Contrast",null,"Holter Analysis","Injection Pulmonary",null,null,null,"Preoperative Assessment","Conscious Sedation> 5 years old, each add 15 mins"]
[null,null,"Calcium Ionized",null,"Knee 3 views",null,null,"CT Angio Extr Upper w/Contrast Uni","MRA Head w/out Contrast",null,"Holter Placement 24 Hour","Midazolam 1 MG vl (2mg/2ml)",null,null,null,"Pressure Infuse disposable","Monitors electrodes"]
[null,null,"Calcium, Total",null,"Knee complete 4 views",null,null,"CT Angio Head w/out - w/Contrast","MRA Neck w/Contrast",null,"Stress Echo","NACL 0.9%  100 ML Bag",null,null,null,"Procedure Prep","Kit Bone Biopsy 11 ga"]
[null,null,"CBC  w/platelets no diff",null,"Pelvis 1-2 Views",null,null,"CT Angio Neck w/out - w/Contrast","MRA Neck w/out - w/Contrast",null,"Transesophageal Echo","NACL 0.9% 500 ML IV",null,null,null,"Safeset 60/SS/MAC Mon -kit","Non Invasive blood pressure monitor"]
[null,null,"CBC diff, w/platelets, automated",null,"Spine Cervical 1V",null,null,"CT Angio Pelvis w/out - w/Contrast","MRA Neck w/out Contrast",null,null,"Nitroglycerin 0.6 Mg Tab",null,null,null,"Tray Custom Adult Cardiac","Post Procedure recovery room + 30 mins"]
[null,null,"CD4 count or T cell Absolute",null,"Spine Cervical 2-3V",null,null,"CT Cervical Spine w/Contrast","MRA Neck w/out Contrast",null,null,"O2 Uptake and CO2 Output",null,null,null,null,"Post Procedure recovery room first hour"]
[null,null,"Chloride",null,null,null,null,"CT Cervical Spine w/out - w/Contrast","MRA Pelvis w/ or w/out Contrast",null,null,"Plenty Lung Volumes Airwy Rest"]
[null,null,"Cholesterol",null,null,null,null,"CT Cervical Spine w/out Contrast","MRA Pelvis w/Contrast",null,null,"Prednisone 5 MG tab(20 mg)"]
[null,null,"Complement AG EA Component",null,null,null,null,"CT Chest w/Contrast","MRA Pelvis w/out Contrast",null,null,"Propofol 200 MG/20ml VL"]
[null,null,"Comprehensive metabolic panel",null,null,null,null,"CT Chest w/out - w/Contrast","MRI Abdomen w/Contrast",null,null,"Pulmonary Stress Test Complex"]
[null,null,"C-Peptide",null,null,null,null,"CT Chest w/out Contrast","MRI Abdomen w/out - w/Contrast",null,null,"Pulse Oximeter Multiple Determ"]
[null,null,"CPK Total",null,null,null,null,"CT Head or Brain w/Contrast","MRI Abdomen w/out Contrast",null,null,"Spirometry"]
[null,null,"C-Reactive Protein",null,null,null,null,"CT Head or Brain w/out - w/Contrast","MRI Brain w/Contrast",null,null,"Versed Per 1 MG"]
[null,null,"C-Reactive Protein High Sens",null,null,null,null,"CT Head or Brain w/out Contrast","MRI Brain w/out - w/Contrast",null,null,"Vital Capacity Total"]
[null,null,"Creatinine",null,null,null,null,"CT L-Spine w/Contrast","MRI Brain w/out Contrast"]
[null,null,"DAT (COOMBS Direct)",null,null,null,null,"CT L-Spine w/out - w/Contrast","MRI Cardiac Function Complete"]
[null,null,"DNA Antibody Double Strand",null,null,null,null,"CT L-Spine w/out Contrast","MRI Chest w/Contrast"]
[null,null,"Electrolyte Panel",null,null,null,null,"CT Pelvis w/Contrast","MRI Chest w/out - w/Contrast"]
[null,null,"ESR (sedimentation rate)",null,null,null,null,"CT Pelvis w/out - w/Contrast","MRI Chest w/out Contrast"]
[null,null,"Estradiol",null,null,null,null,"CT Pelvis w/out Contrast","MRI C-Spine w/Contrast"]
[null,null,"F IX inhibitor and F IX C level",null,null,null,null,"CT T-Spine w/Contrast","MRI C-Spine w/out - w/Contrast"]
[null,null,"Factor VIII Assay (Test code: 26-00140)",null,null,null,null,"CT T-Spine w/out - w/Contrast","MRI C-Spine w/out Contrast"]
[null,null,"Factor VIII Inhibitor Assay: Human (Test code: 26-00310)",null,null,null,null,"CT T-Spine w/out Contrast","MRI L-Spine w/Contrast"]
[null,null,"Factor VIII Inhibitor Assay: Porcine (Test code: 26-00320)",null,null,null,null,null,"MRI L-Spine w/out - w/Contrast"]
[null,null,"Factor VIII Inhibitor Screen (Test code: 26-00290)",null,null,null,null,null,"MRI L-Spine w/out Contrast"]
[null,null,"Fibrin Split Product",null,null,null,null,null,"MRI Pelvis w/ Contrast"]
[null,null,"Fibrinogen Activity",null,null,null,null,null,"MRI Pelvis w/out  contrast"]
[null,null,"FSH-Follicle Stimulating Hormone",null,null,null,null,null,"MRI Pelvis w/out-w contrast"]
[null,null,"Gammaglobulin IGA,IGD,IGG,IGM",null,null,null,null,null,"MRI T-Spine w/Contrast"]
[null,null,"GGTP",null,null,null,null,null,"MRI T-Spine w/out - w/Contrast"]
[null,null,"Glucose Blood",null,null,null,null,null,"MRI T-Spine w/out Contrast"]
[null,null,"HbA1C/glycosylated hemoglobin"]
[null,null,"HCG Pregnancy Test Urine"]
[null,null,"HCG Qualitative Serum"]
[null,null,"Hematocrit"]
[null,null,"Hemoglobin"]
[null,null,"Hepatic Function Panel"]
[null,null,"Hepatitis A Antibody ( HAAb)"]
[null,null,"Hepatitis B Core Antibody (HBcAB)"]
[null,null,"Hepatitis B surface antibody ( HBsAB)"]
[null,null,"Hepatitis C antibody"]
[null,null,"HIV Antibody Confirmatory"]
[null,null,"HLA B 27"]
[null,null,"HTLV-1"]
[null,null,"HTLV-II"]
[null,null,"Inorganic Phosphorus"]
[null,null,"Insulin Total"]
[null,null,"LDH"]
[null,null,"LDH Isoenzymes"]
[null,null,"Lipid Panel"]
[null,null,"Luteinizing Hormone"]
[null,null,"Magnesium"]
[null,null,"Nicotine"]
[null,null,"Phosphorus Inorganic"]
[null,null,"Platelet Count"]
[null,null,"Potassium-serum"]
[null,null,"Protein C Functional"]
[null,null,"Protein S Free"]
[null,null,"Protein Total Urine"]
[null,null,"Protime (PT)"]
[null,null,"PTT"]
[null,null,"Quantiferon"]
[null,null,"Renal Function Panel"]
[null,null,"Sodium"]
[null,null,"Somatomedin (IGF -1) insulin growth factor"]
[null,null,"Syphilis Test Qualitative"]
[null,null,"T B Screening"]
[null,null,"Total Protein"]
[null,null,"Triglyceride"]
[null,null,"TSH"]
[null,null,"Uric Acid"]
[null,null,"Urinalysis - Automated w Micro"]
[null,null,"Urinalysis - Automated w/out Micro"]
[null,null,"Urine Culture and Sensitivity Test"]
[]
["Category"]
["Patient Payment",null,"Central Lab"]
["Visits",null,"CRU"]
["Labs        ",null,"MHHS ",null,"Yes","Research"]
["Anesthesiology",null,"UTP Clinic",null,"No","NB"]
["XRay Imaging",null,"Other",null,null,"SOC"]
["Tissue ",null,"MHHS Clinic",null,null,"NB- Costs for Research"]
["Ultrasound ",null,null,null,null,"X"]
["CT"]
["MRI MRA"]
["Nuclear Radiology"]
["EKG ECHO"]
["Pulmonary"]
["Pharmacy"]
["Parking"]
["Cardiac"]
["OR"]
["Biopsy"]
["Fluoroscopy"]
["PET"]
["Neurophysiology"]
["Other"]
[]
[]
[]
[]
[]
[]
[]
[]
["Service Description/Procedures","CPT","CDM"]
["E&M Services"]
["Clinic Visit_New Patient Level 1",99201]
["Clinic Visit_New Patient Level 2",99202]
["Clinic Visit_New Patient Level 3",99203]
["Clinic Visit_New Patient Level 4",99204]
["Clinic Visit_New Patient Level 5",99205]
["Clinic Visit_Est. Patient Level 1",99211]
["Clinic Visit_ Est. Patient Level 2",99212]
["Clinic Visit_ Est. Patient Level 3",99213]
["Clinic Visit_ Est. Patient Level 4",99214]
["Clinic Visit_ Est. Patient Level 5",99215]
["Venipuncture",36415]
["Labs        "]
["Comprehensive metabolic panel",80053,60400965]
["Albumin Serum",82040,60401969]
["Alk Phosphatase",84075,60400164]
["BUN",84520,60403252]
["Creatinine",82565,60400911]
["Calcium, Total",82310,60400490]
["Glucose Blood",82947,60442014]
["Total Protein",84155,60340587]
["AST (SGOT)",84450,60403163]
["ALT (SGPT)",84460,60403198]
["Bilirubin Total",82247,60400407]
["Sodium",84295,60402892]
["Potassium-serum",84132,60402388]
["Chloride",82435,60400733]
["Bicarbonate(CO2)",82374,60434086]
["Alpha -fetoprotein",82105]
["Amplified Probe(MSRA)",87641,60508137]
["Basic Metabolic Panel",80047,60400959]
["Beta-Natriuretic Peptide (BNP)",83880,60402938]
["Bilirubin Direct",82248,60400377]
["Blood Culture",87040,60503044]
["CBC  w/platelets no diff",85027,60301360]
["CBC diff, w/platelets, automated",85025,60301395]
["Hemoglobin",85018,60307671]
["Hematocrit",85014,60307662]
["Platelet Count",85049,60300887]
["Calcium Ionized",82330,60402051]
["CD4 count or T cell Absolute",86361,60433879]
["Cholesterol",82465,60400768]
["Complement AG EA Component",86160,60442048]
["CPK Total",82550,60400881]
["C-Reactive Protein",86140,60409206]
["C-Reactive Protein High Sens",86141,60409207]
["C-Peptide",84681,60401528]
["DAT (COOMBS Direct)",86880,60101213]
["DNA Antibody Double Strand",86225,60601304]
["Electrolyte Panel",80051,60400963]
["ESR (sedimentation rate)",85651,60301303]
["Estradiol",82670,60401504]
["F IX inhibitor and F IX C level",85250,60307830]
["Factor VIII Assay (Test code: 26-00140)",85240,60302626]
["Factor VIII Inhibitor Assay: Human (Test code: 26-00310)",85335,60307830]
["Factor VIII Inhibitor Assay: Porcine (Test code: 26-00320)",85335,60307830]
["Factor VIII Inhibitor Screen (Test code: 26-00290)",85335,60307830]
["Fibrin Split Product",82784,60301727]
["Fibrinogen Activity",85384,60300461]
["FSH-Follicle Stimulating Hormone",83001,60401506]
["Gammaglobulin IGA,IGD,IGG,IGM",82784,60408084]
["GGTP",82977,60407908]
["HbA1C/glycosylated hemoglobin",83036,60402997]
["HCG Qualitative Serum",84702,60404127]
["HCG Pregnancy Test Urine",84703,60700435]
["Hepatic Function Panel",80076,60400968]
["Hepatitis B Core Antibody (HBcAB)",86704,60403096]
["Hepatitis B surface antibody ( HBsAB)",86706,60407341]
["Hepatitis A Antibody ( HAAb)",86708]
["Hepatitis C antibody",86803,60403173]
["HIV Antibody Confirmatory",86701,60601320]
["HTLV-1",86687]
["HTLV-II",86688]
["HLA B 27",86812,60309579]
["Inorganic Phosphorus",84100,60402329]
["Insulin Total",83525,60401512]
["LDH",83615,60401810]
["LDH Isoenzymes",83625,60405654]
["Lipid Panel",80061,60408785]
["Luteinizing Hormone",83002,60401508]
["Magnesium",83735,60402116]
["Nicotine",80302,60401070]
["Phosphorus Inorganic",84100,60402329]
["Protein C Functional",85303,60307523]
["Protein S Free",85306,60307531]
["Protein Total Urine",84155,60400302]
["Protime (PT)",85610,60300941]
["PTT",85730,60300852]
["Quantiferon",86480,3481116]
["Renal Function Panel",80069,60400976]
["Somatomedin (IGF -1) insulin growth factor",84305,60434275]
["Syphilis Test Qualitative",86780,60601429]
["TSH",84443,60408041]
["Triglyceride",84478,60403945]
["T B Screening",86580,66181184]
["Uric Acid",84550,60403287]
["Urinalysis - Automated w Micro",81001,60701032]
["Urinalysis - Automated w/out Micro",81000,60701423]
["Urine Culture and Sensitivity Test",87088,60508283]
["Research Handling Fee- blocks",99000,60299999]
["Research Unstained Slides",99000,60299997]
["Anesthesiology"]
["Oximeter P/Day",94760,67341120]
["Kit Transd 3 ml 12 in 72 in TB",86480,67300144]
["Desflurane Per case","anesthesia drug",67301630]
["Anes Endotracheal Tube","varies per dept",67300211]
["Anes srvs General 1st 30 min","varies per dept",67341126]
["Anes srvs General add 15 mins","varies per dept",67300076]
["Invasive Pressure Monitor",93610,67300838]
["Diagnostic Imaging "]
["X-ray Abdomen Acute Series Complete",74022,65140901]
["X-ray Abdomen AP & Oblique Views",74000,65105054]
["X-ray Ankle Complete 3+Views Uni",73630,65100282]
["X-ray Ankle 2 Views Bilateral",73620,65100254]
["X-ray Ankle 2 Views Unilateral",73620,65105046]
["Bone Density DXA Axial Skelet",77080,65120103]
["Bone Survey Complete",77075,65111535]
["Chest AP Single View",71010,65100649]
["X-ray Chest AP w/Fluoro",71023,65100703]
["X-ray Chest AP w/Lordotic",71021,65106795]
["Chest 2 View AP & Lateral",71020,65100673]
["MRA Neck w/out Contrast",70547,65104200]
["X-ray Knee 1 or 2 views",73560]
["X-ray Knee 3 views",73562]
["X-ray Knee complete 4 views or more",73564]
["X-ray Both Knees standing anteroposterior",73565]
["X-ray Pelvis 1-2 Views",72170,65107457]
["X-ray Spine Cervical 1View",72020,65120412]
["X-ray Spine Cervical 2-3 Views",72040,65120025]
["Ultrasound "]
["US Abdomen Complete",76700,65600080]
["US Abdomen Limited (single organ, quadrant, follow-up)",76705,65600356]
["US Brain Scan",76506,65600420]
["US Chest",76604,65602082]
["US Duplex Abd/Pel/Scrot/Kid",93975,65600865]
["US Duplex Ext Veins Bilat",93970,65602211]
["US Pelvis Complete",76856,65600250]
["US Retroperitoneal Limited",76775,65601406]
["US Scrotum & Contents",76870,65600064]
["US Transrectal",76872,65600129]
["US Transvaginal",76830,65600471]
["US Transpl Kidney w/ Dop",76776,65601408]
["US Transpl Kidney w/out Dop",76775]
["Computed Tomography  (yellow highlights are all associated charges for all CT with contrast)"]
["Injection Kit Dual Syringe-*only use with Contrast for CT",null,65700124]
["Creatinine Blood Non OPID-*only use with Contrast for CT",null,65700035]
["OPID CT Omnipaque 300ML 10-*only use with CT and Angio Contrast",null,65709992]
["Iodixanol 320MG/ML INJ(200ML)- *only use with CT and Angio Contrast",null,66185004]
["CT Abdomen w/Contrast",74160,65700697]
["CT Abdomen w/out Contrast",74150,65700360]
["CT Abodomen w/out - w/Contrast",74170,65700580]
["CT Angio Abdomen",74175,65701332]
["CT Angio Aorta w/Fem Runoff",75635,65701336]
["CT Angio Chest w/o - w/Contrast",71275,65701328]
["CT Angio Extr Lower w/Contrast Uni",73706,65701340]
["CT Angio Extr Lower w/o - w/Bi","73706-50",65702254]
["CT Angio Extr Upper w/Contrast Bi","73206-50",65702246]
["CT Angio Extr Upper w/Contrast Uni",73206,65701338]
["CT Angio Head w/out - w/Contrast",70496,65701326]
["CT Angio Neck w/out - w/Contrast",70498,65701330]
["CT Angio Pelvis w/out - w/Contrast",72191,65701334]
["CT Cervical Spine w/Contrast",72126,65700816]
["CT Cervical Spine w/out Contrast",72125,65700115]
["CT Cervical Spine w/out - w/Contrast",72127,65701342]
["CT Chest w/Contrast",71260,65700506]
["CT Chest w/out Contrast",71250,65700514]
["CT Chest w/out - w/Contrast",71270,65700586]
["CT Head or Brain w/Contrast",70460,65700018]
["CT Head or Brain w/out Contrast",70450,65700026]
["CT Head or Brain w/out - w/Contrast",70470,65700344]
["CT Pelvis w/Contrast",72193,65700387]
["CT Pelvis w/out Contrast",72192,65700336]
["CT Pelvis w/out - w/Contrast",72194,65700592]
["CT T-Spine w/out Contrast",72128,65702028]
["CT T-Spine w/Contrast",72129,65700820]
["CT T-Spine w/out - w/Contrast",72130,65701346]
["CT L-Spine w/out Contrast",72131,65700116]
["CT L-Spine w/Contrast",72132,65700822]
["CT L-Spine w/out - w/Contrast",72133,65701344]
["Magnetic Resonance Imaging (Yellow highlights are all associated charges for all MRA/MRI with contrast)"]
["MRI Kit-*only use with Contrast for MRI",null,65802180]
["Creatinine Blood Non OPID-*only use with Contrast for MRI",null,65800035]
["IV START PAK-*only use with Contrast for MRI",null,59060947]
["Electrode MRI ECG Quatrade-*only use with Contrast for MRI",null,65803330]
["GADOBENATE 1ML VL(7935MG/15ML)-*(contrast x 15 (qty 15= qty is equal to 1ML VL (7935MG/15ML) per 150 lb patient)  only use with Contrast for MRI",null,66001125]
["Monitor Non-Invasive",null,65803038]
["MRA Abdomen w/Contrast",74185,65802500]
["MRA Abdomen w/out Contrast",74185,65802502]
["MRA Abdoment w/out - w/Contrast",74185,65802504]
["MRA Chest w/Contrast",71555,65802518]
["MRA Chest w/out - w/Contrast",71555,65802522]
["MRA Head w/Contrast",70545,65800723]
["MRA Head w/out Contrast",70544,65801000]
["MRA Head w/out - w/Contrast",70546,65800725]
["MRA Neck w/Contrast",70548,65800719]
["MRA Neck w/out Contrast",70547,65800612]
["MRA Neck w/out - w/Contrast",70549,65800721]
["MRA Pelvis w/ or w/out Contrast",72198,65800904]
["MRA Pelvis w/Contrast",72198,65800900]
["MRA Pelvis w/out Contrast",72198,65800902]
["MRI Abdomen w/Contrast",74182,65801012]
["MRI Abdomen w/out Contrast",74181,65802040]
["MRI Abdomen w/out - w/Contrast",74183,65800110]
["MRI Brain w/Contrast",70552,65801485]
["MRI Brain w/out Contrast",70551,65800063]
["MRI Brain w/out - w/Contrast",70553,65801469]
["MRI Cardiac Function Complete",75561,65803006]
["MRI Chest w/Contrast",71551,65800071]
["MRI Chest w/out Contrast",71550,65801038]
["MRI Chest w/out - w/Contrast",71552,65800077]
["MRI C-Spine w/out Contrast",72141,65800012]
["MRI C-Spine w/Contrast",72142,65801004]
["MRI C-Spine w/out - w/Contrast",72156,65801388]
["MRI T-Spine w/out Contrast",72146,65800160]
["MRI T-Spine w/Contrast",72147,65801006]
["MRI L-Spine w/out - w/Contrast",72157,65801434]
["MRI L-Spine w/out Contrast",72148,65800179]
["MRI L-Spine w/Contrast",72149,65803032]
["MRI T-Spine w/out - w/Contrast",72158,65801418]
["MRI Pelvis w/out  contrast",72195,65800083]
["MRI Pelvis w/ Contrast",72196,65803034]
["MRI Pelvis w/out-w contrast",72197,65802046]
["Nuclear Medicine "]
["Cold Pyrophosphate per dose","A9560",65900149]
["TC-99M Sulfur Colloid Per Dose","A9541",65903022]
["Bone Density DXA Axial Skelet",77080,65905000]
["Bone Scan Three Phase Study",78315,65900769]
["Bone Scan Tomogram Spect",78320,65902052]
["Bone Scan Whole Body",78306,65900041]
["Bone Scan Whole Body",78306,65900044]
["Bone Scan, Multiple Area",78305,65904762]
["Brain Scan Spect",78607,65902036]
["Lung Perfusion Scan",78597,65905076]
["Cardiac Scan Gated Multi(MUGA)",78473,65900173]
["Non-Invasive Cardiology "]
["ECG Rhythym Strip",93005,62000139]
["ECG 12/15 Lead",93010,62000236]
["12 Lead ECG CPT (Tracing & Interpretation only)",93018]
["Cable ECG 12 V Lead",93000,51074310]
["Echo Doppler Complete",93306,62000112]
["Echo Doppler Limited",93307,62000510]
["Echo Follow-Up Congenital",93308,62001366]
["Echo Follow-Up/Limited",93304,62001369]
["Echo w/Contrast",93306,62001312]
["Echo 2D M Mode Complete",93307,62000163]
["Echo 2D M Mode Limited",93308,62000147]
["Echo 2D M Mode Comp w/Color Fl",93325,62003306]
["Stress Echo",93350,62000351]
["Transesophageal Echo",93318,62001089]
["Holter Placement 24 Hour",93224,68009323]
["Holter Analysis",96226,62000260]
["Pulmonary (Yellow highlights are all associated charges for a standard PFT)"]
["Blood Gas with O2 saturation",82805,68009540]
["Blood Gas with 2 or more analytics ph, pC02, p02, CO2, HCO3",82803]
["Bronchoscopy w/Biopsy",31625,64002706]
["Bronchoscopy w/Bronchial Lavag",31624,64002704]
["Bronchoscopy w/Brushing",31623,64002702]
["Spirometry",94010,64000438]
["Plethysmography Lung Volumes Airwy Rest",94726,64004726]
["Diffusion Capacity (DLCO) add on code for codes 94010, 94060, 94070, 94375, 94726-94728",94729,64004729]
["Vital Capacity Total",94150,64000942]
["O2 Uptake and CO2 Output",94681,64000124]
["Pulmonary Stress Test Complex",94621,64000110]
["Pulse Oximeter Multiple Determ",94761,41102116]
["Blood O2 Saturation",82805,64200038]
["Cardiac Output Measurement",93461,64200143]
["Injection  Internal Mammary",19030,64217398]
["6 min walk",94620]
["IDS Pharmacy"]
["New Study Set-Up / Administrative Fee  (Outpatient Study)","Start-up",66300618]
["New Study Set-Up / Administrative Fee (Inpatient Study)","Start-up",66300620]
["Annual Study Maintenance Fee","Invoice",66300746]
["Annual Refrig Storage Fee","Invoice",66300610]
["Miscellaneous IDS FEE 15 min","Invoice",66301030]
["Study Annual Documentation Fee","Invoice",66300611]
["Patient Randomization","Per patient",66300612]
["Per Dose RX Dispensing Fee","Per-patient",66300616]
["Storage Of Used Study Medication","Per-patient/ invoice",66300604]
["Parking"]
["CRU Parking ",null,40201272]
["Cardiac Invasive Lab"]
["Blood O2 Saturation only",null,64200038]
["Cath Lab Treatment Room",null,64202097]
["Procedure Prep",null,64200577]
["S&I Abdominal Aortagram",null,64200488]
["DSA Analysis LV Gram",null,64200518]
["DSA Analysis Coronary",null,64200526]
["S&I Cor/Pulm/Aort Angio",null,64217342]
["S&I Arterial /Vent/Angio ( Pedi)",null,64217349]
["Injection Venous Bypass Grafts",null,64201301]
["Angio Coronary w/o Heart Cath",null,64211184]
["Left & Right Heart Cath",null,64202049]
["Respiratory Therapy"]
["Blood Gases",null,68009540]
["Day Surgery"]
["Preoperative Assessment",null,51601386]
["Operating Room (Supplies)"]
["Cable ECG 12 V Lead",null,51074310]
["Cardiac Output Measurement",null,64200143]
["Drape Intraop Probe SM T TIP",null,51001240]
["Procedure Prep",null,64200577]
["Safeset 60/SS/MAC Mon -kit",null,59070570]
["Pack Line Linen",null,59071380]
["Cath 8F Cardiac Output",null,59070390]
["Pressure Infuse disposable",null,59009729]
["Tray Custom Adult Cardiac",null,59071626]
["Dressing Bio Patch",null,59020631]
["Kit Perc Intro 8.5 FR",null,59000685]
["Oxi Adult Sensor",null,59002100]
["3 Jones MED/SURG"]
["Room Charge",null,41200110]
["NACL 0.9% IRRG 1000 ml",null,59209809]
["Day Surgery"]
["Injection IV Push 1st drug",null,51600786]
["Phase 2 PACU Ea Add 30 min-Rout",null,51605276]
["Anesthesiology"]
["Drugs"]
["Alprazolam 1 MG Tab",null,66028062]
["Fentanyl 100 MCG/2 ml Vl",null,66142426]
["Propofol 200 MG/20ml VL",null,66130517]
["Prednisone 5 MG tab(20 mg)",null,66006015]
["NACL 0.9% 500 ML IV",null,66500594]
["NACL 0.9%  100 ML Bag",null,66500552]
["D5W 500 ml Bag",null,66500128]
["Midazolam 1 MG vl (2mg/2ml)",null,66004904]
["Nitroglycerin 0.6 Mg Tab",null,66191378]
["Versed Per 1 MG",null,65109084]
["Vascular Radiology"]
["IV Catheter #18-24",null,65509839]
["EKG Hourly Monitor Charge",null,65503618]
["Conscious Sedation> 5 years old, first 30 min",null,65501144]
["Conscious Sedation> 5 years old, each add 15 mins",null,65502145]
["Kit Bone Biopsy",null,65505200]
["Kit Bone Biopsy 11 ga",null,65501358]
["Monitors electrodes",null,65500086]
["Non Invasive blood pressure monitor",null,65503638]
["Universal Precautions",null,65509836]
["Oxygen ",null,65501174]
["Pressure bag vital signs",null,65504322]
["Post Procedure recovery room first hour",null,65503648]
["Post Procedure recovery room + 30 mins",null,65503650]
["Biopsy Lung perc",null,65502531]
["Skin biopsy Single Lesion",null,65500392]
["Skin biopsy + add  Lesion",null,65500394]
["Biopsy Tray",null,65500132]
["Pulse Oximeter",null,65501171]
["Diagnostic Radiology"]
["Fluoro Local  NDL Biopsy/ Aspiration",null,65102194]
["Nuclear Radiology"]
["PET Tumor Imaging",null,65950811]
["PET CT Tumor Image Skull MIDTH",null,65952815]
["CT Chest w/con",null,65751260]
["PET CT Tumor Imaging Whole BD",null,65951816]
["PET Brain Imaging Met Eval",null,65950608]
["PET Tumor Imaging Whole Body",null,65952813]
["PET Myocard Imag Metabolic Eval",null,65950514]
["CT Thorax W/O Contrast",null,77700006]
["PET Tumor Imaging Limited area",null,65950811]
["PET Tumor Image Skull Midthigh",null,65951812]
["PET CT Tumor Imaging LTD area",null,65951814]
["PET Myocard Imag Metabolic Eval",null,65950516]
["Neurophysiology"]
["13 or more Nerve Conduct",null,63000017]
["Reference Lab"]
["TB Cell Immunity Response S/O",null,60861998]
["Medical ICU-2WC"]
["Room Charge- ICU Adult Level 1",null,46200201]
["Recovery Room"]
["Minor Proc Recovery  1 st hour",null,52000258]
["Minor Proc Recovery  add 30 minutes ",null,52000261]

{"sheet":"Effort","index":4,"n_rows":85,"n_cols":38,"rows_kept":85,"cut":false,"hidden":false,"merged":[[83,0,83,4],[81,1,81,4],[84,0,84,4],[77,1,77,4],[78,1,78,4],[79,1,79,4],[80,1,80,4],[82,1,82,4],[72,0,72,1],[73,0,74,0],[73,1,74,4],[75,1,75,4],[76,1,76,4],[67,0,67,4],[68,0,68,1],[69,0,69,1],[70,0,70,1],[71,0,71,1],[65,1,65,4],[65,22,65,23],[64,1,64,4],[64,22,64,23],[66,1,66,4],[66,22,66,23],[57,0,58,0],[57,1,58,4],[62,1,62,4],[62,22,62,23],[63,1,63,4],[63,22,63,23],[61,22,61,23],[57,22,58,23],[59,1,59,4],[59,22,59,23],[60,1,60,4],[60,22,60,23],[61,1,61,4],[55,5,57,6],[95,0,95,1],[2,0,2,1],[3,0,3,1],[0,0,0,1],[1,0,1,1],[37,0,37,1],[5,0,6,1],[10,0,10,1],[14,0,14,1],[12,0,12,1],[24,0,24,1],[23,0,23,1],[44,0,44,3],[38,2,38,3],[40,0,40,1],[40,2,40,3],[36,0,36,1],[36,2,36,3],[27,0,27,3],[33,0,34,1],[33,2,34,3],[35,0,35,1],[35,2,35,3],[25,2,25,3],[41,0,41,1],[41,2,41,3],[38,0,38,1],[42,0,42,1],[42,2,42,3],[43,0,43,3],[39,0,39,1],[24,37,24,38],[17,37,18,38],[19,37,19,38],[20,37,20,38],[21,37,21,38],[22,37,22,38],[23,37,23,38],[25,37,25,38],[26,37,26,38],[7,0,7,1],[7,2,7,3],[9,0,9,1],[9,2,9,3],[37,2,37,3],[17,2,18,3],[17,0,18,1],[19,0,19,1],[19,2,19,3],[20,0,20,1],[20,2,20,3],[21,2,21,3],[22,2,22,3],[24,2,24,3],[8,0,8,1],[8,2,8,3],[26,2,26,3],[25,0,25,1],[26,0,26,1],[14,4,14,5],[15,4,15,5],[10,2,10,3],[11,0,11,1],[11,2,11,3],[13,0,13,1],[23,2,23,3],[39,2,39,3],[12,2,12,3],[14,2,14,3],[21,0,21,1],[22,0,22,1],[15,0,15,1],[15,2,15,3],[8,4,8,5],[13,2,13,3],[5,2,6,3],[12,4,12,5],[5,4,6,5],[7,4,7,5],[9,4,9,5],[10,4,10,5],[11,4,11,5],[13,4,13,5]]}
[{"$f":"Summary!A9","v":"Project Title:"},null,{"$f":"Summary!B9","v":"title"}]
[{"$f":"Summary!A10","v":"Principal Investigator:"},null,{"$f":"Summary!C10","v":"PI"}]
[{"$f":"Summary!A11","v":"Sponsor:"},null,{"$f":"Summary!C11","v":"Spon"}]
[{"$f":"Summary!A12","v":"CPHS Study Number:"},null,{"$f":"Summary!C12","v":"IRB num"}]
[]
["Position ",null,"Name ",null,"Hourly Rate"]
[]
[{"$f":"Summary!A19","v":"PI"},null,{"$f":"IF(Summary!C19=0,\"\",Summary!C19)","v":"PI"},null,{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Summary!A20","v":"PI Oversight"},null,{"$f":"IF(Summary!C20=0,\"\",Summary!C20)","v":"PI"},null,{"$f":"((Summary!$E$20+ (Summary!$E$20*Summary!$J$20))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Summary!A21","v":"Coordinator"},null,{"$f":"IF(Summary!C21=0,\"\",Summary!C21)","v":"NAME"},null,{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Summary!A22","v":"Coordinator Admin"},null,{"$f":"IF(Summary!C22=0,\"\",Summary!C22)","v":"NAME"},null,{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}},null,"Note-- Effort  per person for each visit should include visit preparation and visit administration time and effort too."]
[{"$f":"Summary!A23","v":"Financial Management"},null,{"$f":"IF(Summary!C23=0,\"\",Summary!C23)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}},null,"Example- Chart set up, scheduling next visit, escorting participant for imaging, data entry into CRF, etc."]
[{"$f":"Summary!A24","v":0},null,{"$f":"IF(Summary!C24=0,\"\",Summary!C24)","v":""},null,{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}}]
[{"$f":"Summary!A25","v":0},null,{"$f":"IF(Summary!C25=0,\"\",Summary!C25)","v":""},null,{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}},null,"Financial Management - Minimum .5 per visit for invoicing and/or payment reconciliation & 3 hours for last visit  for study reconciliation. (In some cases this is also the study coordinator. However the time spent for financial management is separate from and in addition to the time and effort spent during study visits therefore needs to be captured separately. "]
[{"$f":"Summary!A26","v":0},null,{"$f":"IF(Summary!C26=0,\"\",Summary!C26)","v":""},null,{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}},null,"Regulatory Management- Minimum .25 per visit and 3 hours for last study visit to capture continuing reviews, and amendment processing  . (In many cases the study coordinator also manages regulatory. However the time spent managing regulatory documents (SAE, Reg Binder, IND report management, IRB submissions) is separate from and in addition to the time and effort spent during study visits therefore needs to be captured separately.  "]
[{"$f":"Summary!A27","v":0},null,{"$f":"IF(Summary!C27=0,\"\",Summary!C27)","v":""},null,{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*#REF!","v":{"$error":"#REF!"}}]
[]
["Position ",null,"Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effort %"]
[null,null,null,null,{"$f":"'Coverage Analysis'!F8","v":"V1"},{"$f":"'Coverage Analysis'!G8","v":"V2"},{"$f":"'Coverage Analysis'!H8","v":"V3"},{"$f":"'Coverage Analysis'!I8","v":"V4"},{"$f":"'Coverage Analysis'!J8","v":"V5"},{"$f":"'Coverage Analysis'!K8","v":"V6"},{"$f":"'Coverage Analysis'!L8","v":"V7"},{"$f":"'Coverage Analysis'!M8","v":"V8"},{"$f":"'Coverage Analysis'!N8","v":"V9"},{"$f":"'Coverage Analysis'!O8","v":"V10"},{"$f":"'Coverage Analysis'!P8","v":"V11"},{"$f":"'Coverage Analysis'!Q8","v":"V12"},{"$f":"'Coverage Analysis'!R8","v":"V13"},{"$f":"'Coverage Analysis'!S8","v":"V14"},{"$f":"'Coverage Analysis'!T8","v":"V15"},{"$f":"'Coverage Analysis'!U8","v":"V16"},{"$f":"'Coverage Analysis'!V8","v":"V17"},{"$f":"'Coverage Analysis'!W8","v":"V18"},{"$f":"'Coverage Analysis'!X8","v":"V19"},{"$f":"'Coverage Analysis'!Y8","v":"V20"},{"$f":"'Coverage Analysis'!Z8","v":"V21"},{"$f":"'Coverage Analysis'!AA8","v":"V22"},{"$f":"'Coverage Analysis'!AB8","v":"V23"},{"$f":"'Coverage Analysis'!AC8","v":"V24"},{"$f":"'Coverage Analysis'!AD8","v":"V25"},{"$f":"'Coverage Analysis'!AE8","v":"V26"},{"$f":"'Coverage Analysis'!AF8","v":"V27"},{"$f":"'Coverage Analysis'!AG8","v":"V28"},{"$f":"'Coverage Analysis'!AH8","v":"V29"},{"$f":"'Coverage Analysis'!AI8","v":"V30"},{"$f":"'Coverage Analysis'!AJ8","v":"V31"},{"$f":"'Coverage Analysis'!AK8","v":"V32"},{"$f":"'Coverage Analysis'!AL8","v":"V33"}]
[{"$f":"Summary!A19","v":"PI"},null,{"$f":"IF(Summary!C19=0,\"\",Summary!C19)","v":"PI"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E20:AK20) /2080","v":0}]
[{"$f":"Summary!A21","v":"Coordinator"},null,{"$f":"IF(Summary!C21=0,\"\",Summary!C21)","v":"NAME"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"Summary!A22","v":"Coordinator Admin"},null,{"$f":"IF(Summary!C22=0,\"\",Summary!C22)","v":"NAME"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"Summary!A23","v":"Financial Management"},null,{"$f":"IF(Summary!C23=0,\"\",Summary!C23)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"Summary!A24","v":0},null,{"$f":"IF(Summary!C24=0,\"\",Summary!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(E24:AK24) /2080","v":0}]
[{"$f":"Summary!A25","v":0},null,{"$f":"IF(Summary!C25=0,\"\",Summary!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"Summary!A26","v":0},null,{"$f":"IF(Summary!C26=0,\"\",Summary!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"Summary!A27","v":0},null,{"$f":"IF(Summary!C27=0,\"\",Summary!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Number of Staff Hours:  ",null,null,null,{"$f":"SUM(E20:E27)","v":0},{"$f":"SUM(F20:F27)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[null,null,null,null,"*Review visits on the Coverage Analysis tab to assses time and effort for  each visit per study team member"]
[]
[]
[{"$f":"Effort!A18","v":"Position "},null,{"$f":"Effort!C18","v":"Name "}]
[null,null,null,null,{"$f":"'Coverage Analysis'!F8","v":"V1"},{"$f":"'Coverage Analysis'!G8","v":"V2"},{"$f":"'Coverage Analysis'!H8","v":"V3"},{"$f":"'Coverage Analysis'!I8","v":"V4"},{"$f":"'Coverage Analysis'!J8","v":"V5"},{"$f":"'Coverage Analysis'!K8","v":"V6"},{"$f":"'Coverage Analysis'!L8","v":"V7"},{"$f":"'Coverage Analysis'!M8","v":"V8"},{"$f":"'Coverage Analysis'!N8","v":"V9"},{"$f":"'Coverage Analysis'!O8","v":"V10"},{"$f":"'Coverage Analysis'!P8","v":"V11"},{"$f":"'Coverage Analysis'!Q8","v":"V12"},{"$f":"'Coverage Analysis'!R8","v":"V13"},{"$f":"'Coverage Analysis'!S8","v":"V14"},{"$f":"'Coverage Analysis'!T8","v":"V15"},{"$f":"'Coverage Analysis'!U8","v":"V16"},{"$f":"'Coverage Analysis'!V8","v":"V17"},{"$f":"'Coverage Analysis'!W8","v":"V18"},{"$f":"'Coverage Analysis'!X8","v":"V19"},{"$f":"'Coverage Analysis'!Y8","v":"V20"},{"$f":"'Coverage Analysis'!Z8","v":"V21"},{"$f":"'Coverage Analysis'!AA8","v":"V22"},{"$f":"'Coverage Analysis'!AB8","v":"V23"},{"$f":"'Coverage Analysis'!AC8","v":"V24"},{"$f":"'Coverage Analysis'!AD8","v":"V25"},{"$f":"'Coverage Analysis'!AE8","v":"V26"},{"$f":"'Coverage Analysis'!AF8","v":"V27"},{"$f":"'Coverage Analysis'!AG8","v":"V28"},{"$f":"'Coverage Analysis'!AH8","v":"V29"},{"$f":"'Coverage Analysis'!AI8","v":"V30"},{"$f":"'Coverage Analysis'!AJ8","v":"V31"},{"$f":"'Coverage Analysis'!AK8","v":"V32"},{"$f":"'Coverage Analysis'!AL8","v":"V33"}]
[{"$f":"Effort!A20","v":"PI"},null,{"$f":"IF(Summary!C19=0,\"\",Summary!C19)","v":"PI"},null,{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*E20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*F20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*G20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*H20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*I20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*J20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*K20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*L20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*M20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*N20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*O20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*P20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*Q20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*R20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*S20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*T20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*U20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*V20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*W20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*X20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*Y20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*Z20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AA20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AB20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AC20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AD20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AE20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AF20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AG20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AH20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AI20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AJ20","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*AK20","v":0}]
[{"$f":"Effort!A21","v":"Coordinator"},null,{"$f":"IF(Summary!C21=0,\"\",Summary!C21)","v":"NAME"},null,{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*E21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*F21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*G21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*H21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*I21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*J21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*K21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*L21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*M21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*N21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*O21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*P21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*Q21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*R21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*S21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*T21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*U21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*V21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*W21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*X21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*Y21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*Z21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AA21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AB21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AC21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AD21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AE21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AF21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AG21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AH21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AI21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AJ21","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*AK21","v":0}]
[{"$f":"Effort!A22","v":"Coordinator Admin"},null,{"$f":"IF(Summary!C22=0,\"\",Summary!C22)","v":"NAME"},null,{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*E22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*F22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*G22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*H22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*I22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*J22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*K22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*L22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*M22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*N22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*O22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*P22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*Q22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*R22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*S22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*T22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*U22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*V22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*W22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*X22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*Y22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*Z22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AA22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AB22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AC22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AD22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AE22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AF22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AG22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AH22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AI22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AJ22","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*AK22","v":0}]
[{"$f":"Effort!A23","v":"Financial Management"},null,{"$f":"IF(Summary!C23=0,\"\",Summary!C23)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*E23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*W23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*X23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Y23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Z23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AA23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AB23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AC23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AD23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AE23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AF23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AG23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AH23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AI23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AJ23","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AK23","v":0}]
[{"$f":"Effort!A24","v":0},null,{"$f":"IF(Summary!C24=0,\"\",Summary!C24)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*E24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*W24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*X24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Y24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Z24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AA24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AB24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AC24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AD24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AE24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AF24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AG24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AH24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AI24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AJ24","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AK24","v":0}]
[{"$f":"Effort!A25","v":0},null,{"$f":"IF(Summary!C25=0,\"\",Summary!C25)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*E25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*W25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*X25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Y25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Z25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AA25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AB25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AC25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AD25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AE25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AF25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AG25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AH25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AI25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AJ25","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AK25","v":0}]
[{"$f":"Effort!A26","v":0},null,{"$f":"IF(Summary!C26=0,\"\",Summary!C26)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*E26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*W26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*X26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Y26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Z26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AA26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AB26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AC26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AD26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AE26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AF26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AG26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AH26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AI26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AJ26","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AK26","v":0}]
[{"$f":"Effort!A27","v":0},null,{"$f":"IF(Summary!C27=0,\"\",Summary!C27)","v":""},null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*E27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*W27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*X27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Y27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Z27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AA27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AB27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AC27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AD27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AE27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AF27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AG27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AH27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AI27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AJ27","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*AK27","v":0}]
["Total Effort Cost per Visit",null,null,null,{"$f":"SUM(E36:E43)","v":0},{"$f":"SUM(F36:F43)","v":0},0,0,0,0,0,{"$f":"SUM(L36:L43)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(Z36:Z43)","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(AK36:AK43)","v":0}]
["Total Effort Cost per Visit plus IDC ",null,null,null,{"$f":"E44*1.3","v":0},{"$f":"F44*1.3","v":0},0,0,0,0,0,{"$f":"L44*1.3","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"Z44*1.3","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"AK44*1.3","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Start up time and effort"]
[null,null,null,null,null,"Below two items are not start-up effort (Will be reflected in Summary Tab Effort)"]
[]
["Position ","Name ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Effort %"]
[null,null,null,null,null,"Chart Review/Prescreen (Time per patient elegibility review)","Screen Failure Visit  (Time per Patient visit)","Protocol Review","Feasibility Assessment","Internal logistics /operational preparation","Complete Regulatory Documents","Coverage Analysis","Budget and Contract Negotiations","Prepare Source Documents and Study Files ","Submission of paperwork to IRB (Includes ICF preparation)","Protocol specific training and Protocol  in-service with study team and collaborators if applicable","CRF system training","Investigator meeting","Site Initiation Visit (include Site Feasibility Visit if applicable)","CRU coordination and Communication","MHH Protocol Submission  (Submission, submission follow up communications )","Study drug Coordination (Coordination and communication with MHH IDS  or communication and coordination for departmental storage.)"]
[{"$f":"Summary!A19","v":"PI"},{"$f":"IF(Summary!C19=0,\"\", Summary!C19)","v":"PI"},null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H60:V60)/2080+($F60*Summary!D13)/2080+(Effort!G60*Summary!D14)/2080","v":1.4423076923076924E-3}]
[{"$f":"Summary!A21","v":"Coordinator"},{"$f":"IF(ISBLANK(Summary!C21), \"\", Summary!C21)","v":"NAME"},null,null,null,null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H61:V61)/2080+($F61*Summary!D13)/2080+(Effort!G61*Summary!D14)/2080","v":1.4423076923076924E-3}]
[{"$f":"Summary!A22","v":"Coordinator Admin"},{"$f":"IF(ISBLANK(Summary!C22), \"\", Summary!C22)","v":"NAME"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H62:V62)/2080+($F62*Summary!D13)/2080+(Effort!G62*Summary!D14)/2080","v":0}]
[{"$f":"Summary!A23","v":"Financial Management"},{"$f":"IF(ISBLANK(Summary!C23), \"\", Summary!C23)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H63:V63)/2080+($F63*Summary!D13)/2080+(Effort!G63*Summary!D14)/2080","v":0}]
[{"$f":"Summary!A24","v":0},{"$f":"IF(ISBLANK(Summary!C24), \"\", Summary!C24)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H64:V64)/2080+($F64*Summary!D13)/2080+(Effort!G64*Summary!D14)/2080","v":0}]
[{"$f":"Summary!A25","v":0},{"$f":"IF(ISBLANK(Summary!C25), \"\", Summary!C25)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H65:V65)/2080+($F65*Summary!D13)/2080+(Effort!G65*Summary!D14)/2080","v":0}]
[{"$f":"Summary!A26","v":0},{"$f":"IF(ISBLANK(Summary!C26), \"\", Summary!C26)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H66:V66)/2080+($F66*Summary!D13)/2080+(Effort!G66*Summary!D14)/2080","v":0}]
[{"$f":"Summary!A27","v":0},{"$f":"IF(ISBLANK(Summary!C27), \"\", Summary!C27)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(H67:V67)/2080+($F67*Summary!$D13)/2080+(Effort!G67*Summary!$D14)/2080","v":0}]
["Total Number of Staff Hours:  ",null,null,null,null,{"$f":"SUM(F60:F67)","v":0},0,6,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
["Position","Name"]
[null,null,null,null,null,"PRESCREEN","Screening / Chart Reviews","Protocol Review","Feasibility Assessment","Internal logistics /operational preparation","Complete Regulatory Documents","Coverage Analysis","Budget Negotiations","Coordination of SPA Contract review and financial account set up","Submission of paperwork to IRB (Includes ICF preparation)","Protocol specific training and Protocol  in-service with study team and collaborators if applicable","CRF system training","Investigator meeting","Site Initiation Visit (include Site Feasibility Visit if applicable)","CRU coordination and Communication","MHH Protocol Submission  (Submission, submission follow up communications )","Study drug Coordination (Coordination and communication with MHH IDS  or communication and coordination for departmental storage.)","TOTALS"]
[{"$f":"Summary!A19","v":"PI"},{"$f":"B60","v":"PI"},null,null,null,{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*F60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*G60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*H60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*I60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*J60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*K60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*L60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*M60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*N60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*O60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*P60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*Q60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*R60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*S60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*T60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*U60","v":0},{"$f":"((Summary!$E$19+ (Summary!$E$19*Summary!$J$19))/2080)*V60","v":0},{"$f":"SUM(H76:V76)","v":0}]
[{"$f":"Summary!A21","v":"Coordinator"},"NAME",null,null,null,{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*F61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*G61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*H61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*I61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*J61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*K61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*L61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*M61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*N61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*O61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*P61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*Q61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*R61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*S61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*T61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*U61","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*V61","v":0},0]
[{"$f":"Summary!A22","v":"Coordinator Admin"},"NAME",null,null,null,{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*F62","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*G62","v":0},{"$f":"((Summary!$E$22+ (Summary!$E$22*Summary!$J$22))/2080)*H62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*I62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*J62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*K62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*L62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*M62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*N62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*O62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*P62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*Q62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*R62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*S62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*T62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*U62","v":0},{"$f":"((Summary!$E$21+ (Summary!$E$21*Summary!$J$21))/2080)*V62","v":0},0]
[{"$f":"Summary!A23","v":"Financial Management"},"",null,null,null,{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*F63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*G63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*H63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*I63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*J63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*K63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*L63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*M63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*N63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*O63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*P63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*Q63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*R63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*S63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*T63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*U63","v":0},{"$f":"((Summary!$E$23+ (Summary!$E$23*Summary!$J$23))/2080)*V63","v":0},0]
[{"$f":"Summary!A24","v":0},"",null,null,null,{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*F64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*G64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*H64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*I64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*J64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*K64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*L64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*M64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*N64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*O64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*P64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*Q64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*R64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*S64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*T64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*U64","v":0},{"$f":"((Summary!$E$24+ (Summary!$E$24*Summary!$J$24))/2080)*V64","v":0},0]
[{"$f":"Summary!A25","v":0},"",null,null,null,{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*F66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*G66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*H66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*I66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*J66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*K66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*L66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*M66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*N66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*O66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*P66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*Q66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*R66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*S66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*T66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*U66","v":0},{"$f":"((Summary!$E$25+ (Summary!$E$25*Summary!$J$25))/2080)*V65","v":0},0]
[{"$f":"Summary!A26","v":0},"",null,null,null,{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*F66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*G66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*H66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*I66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*J66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*K66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*L66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*M66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*N66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*O66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*P66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*Q66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*R66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*S66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*T66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*U66","v":0},{"$f":"((Summary!$E$26+ (Summary!$E$26*Summary!$J$26))/2080)*V66","v":0},0]
[{"$f":"Summary!A27","v":0},"",null,null,null,{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*F67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*G67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*H67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*I67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*J67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*K67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*L67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*M67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*N67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*O67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*P67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*Q67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*R67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*S67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*T67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*U67","v":0},{"$f":"((Summary!$E$27+ (Summary!$E$27*Summary!$J$27))/2080)*V67","v":0},0]
["Total Effort Study Start up",null,null,null,null,{"$f":"SUM(F76:F83)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,"Total"]
["Total Effort Cost Study Start up plus IDC ",null,null,null,null,{"$f":"F84*(1+Summary!I15)","v":0},{"$f":"G84*(1+Summary!I15)","v":0},{"$f":"H84*(1+Summary!I15)","v":0},{"$f":"I84*(1+Summary!I15)","v":0},{"$f":"J84*(1+Summary!I15)","v":0},{"$f":"K84*(1+Summary!I15)","v":0},{"$f":"L84*(1+Summary!I15)","v":0},{"$f":"M84*(1+Summary!I15)","v":0},{"$f":"N84*(1+Summary!I15)","v":0},{"$f":"O84*(1+Summary!I15)","v":0},{"$f":"P84*(1+Summary!I15)","v":0},{"$f":"Q84*(1+Summary!I15)","v":0},{"$f":"R84*(1+Summary!I15)","v":0},{"$f":"S84*(1+Summary!I15)","v":0},{"$f":"T84*(1+Summary!I15)","v":0},{"$f":"U84*(1+Summary!I15)","v":0},{"$f":"V84*(1+Summary!I15)","v":0},0,"Total with IDC"]

{"sheet":"Visit Cost","index":5,"n_rows":84,"n_cols":35,"rows_kept":84,"cut":false,"hidden":false,"merged":[[4,0,4,1],[1,0,1,1],[2,0,2,1],[3,0,3,1]]}
[]
[{"$f":"Summary!A10","v":"Principal Investigator:"},null,{"$f":"Summary!C10","v":"PI"}]
[{"$f":"Summary!A11","v":"Sponsor:"},null,{"$f":"Summary!C11","v":"Spon"}]
[{"$f":"Summary!A12","v":"CPHS Study Number:"},null,{"$f":"Summary!C12","v":"IRB num"}]
[{"$f":"Summary!A13","v":"Pre-screen (Est # of Charts)"},null,{"$f":"Summary!D13","v":"1"}]
[]
[]
[]
[]
[]
[null,"Clinical Cost"]
[null,"Procedures/Activities",{"$f":"'Coverage Analysis'!F8","v":"V1"},{"$f":"'Coverage Analysis'!G8","v":"V2"},{"$f":"'Coverage Analysis'!H8","v":"V3"},{"$f":"'Coverage Analysis'!I8","v":"V4"},{"$f":"'Coverage Analysis'!J8","v":"V5"},{"$f":"'Coverage Analysis'!K8","v":"V6"},{"$f":"'Coverage Analysis'!L8","v":"V7"},{"$f":"'Coverage Analysis'!M8","v":"V8"},{"$f":"'Coverage Analysis'!N8","v":"V9"},{"$f":"'Coverage Analysis'!O8","v":"V10"},{"$f":"'Coverage Analysis'!P8","v":"V11"},{"$f":"'Coverage Analysis'!Q8","v":"V12"},{"$f":"'Coverage Analysis'!R8","v":"V13"},{"$f":"'Coverage Analysis'!S8","v":"V14"},{"$f":"'Coverage Analysis'!T8","v":"V15"},{"$f":"'Coverage Analysis'!U8","v":"V16"},{"$f":"'Coverage Analysis'!V8","v":"V17"},{"$f":"'Coverage Analysis'!W8","v":"V18"},{"$f":"'Coverage Analysis'!X8","v":"V19"},{"$f":"'Coverage Analysis'!Y8","v":"V20"},{"$f":"'Coverage Analysis'!Z8","v":"V21"},{"$f":"'Coverage Analysis'!AA8","v":"V22"},{"$f":"'Coverage Analysis'!AB8","v":"V23"},{"$f":"'Coverage Analysis'!AC8","v":"V24"},{"$f":"'Coverage Analysis'!AD8","v":"V25"},{"$f":"'Coverage Analysis'!AE8","v":"V26"},{"$f":"'Coverage Analysis'!AF8","v":"V27"},{"$f":"'Coverage Analysis'!AG8","v":"V28"},{"$f":"'Coverage Analysis'!AH8","v":"V29"},{"$f":"'Coverage Analysis'!AI8","v":"V30"},{"$f":"'Coverage Analysis'!AJ8","v":"V31"},{"$f":"'Coverage Analysis'!AK8","v":"V32"},{"$f":"'Coverage Analysis'!AL8","v":"V33"}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B9),\"\",'Coverage Analysis'!B9)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B10),\"\",'Coverage Analysis'!B10)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B11),\"\",'Coverage Analysis'!B11)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B12),\"\",'Coverage Analysis'!B12)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B13),\"\",'Coverage Analysis'!B13)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B14),\"\",'Coverage Analysis'!B14)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B15),\"\",'Coverage Analysis'!B15)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B16),\"\",'Coverage Analysis'!B16)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B17),\"\",'Coverage Analysis'!B17)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B18),\"\",'Coverage Analysis'!B18)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B19),\"\",'Coverage Analysis'!B19)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B20),\"\",'Coverage Analysis'!B20)","v":""},"SOC","SOC","SOC","SOC","SOC","SOC","SOC"]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B21),\"\",'Coverage Analysis'!B21)","v":""},"SOC","SOC","SOC","SOC","SOC","SOC","SOC"]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B22),\"\",'Coverage Analysis'!B22)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B23),\"\",'Coverage Analysis'!B23)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B24),\"\",'Coverage Analysis'!B24)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B25),\"\",'Coverage Analysis'!B25)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B26),\"\",'Coverage Analysis'!B26)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B27),\"\",'Coverage Analysis'!B27)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B28),\"\",'Coverage Analysis'!B28)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B29),\"\",'Coverage Analysis'!B29)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B30),\"\",'Coverage Analysis'!B30)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B31),\"\",'Coverage Analysis'!B31)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B32),\"\",'Coverage Analysis'!B32)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B33),\"\",'Coverage Analysis'!B33)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B34),\"\",'Coverage Analysis'!B34)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B35),\"\",'Coverage Analysis'!B35)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B36),\"\",'Coverage Analysis'!B36)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B37),\"\",'Coverage Analysis'!B37)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B38),\"\",'Coverage Analysis'!B38)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B39),\"\",'Coverage Analysis'!B39)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B40),\"\",'Coverage Analysis'!B40)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B41),\"\",'Coverage Analysis'!B41)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B42),\"\",'Coverage Analysis'!B42)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B43),\"\",'Coverage Analysis'!B43)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B44),\"\",'Coverage Analysis'!B44)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B45),\"\",'Coverage Analysis'!B45)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B46),\"\",'Coverage Analysis'!B46)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B47),\"\",'Coverage Analysis'!B47)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B48),\"\",'Coverage Analysis'!B48)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B49),\"\",'Coverage Analysis'!B49)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B50),\"\",'Coverage Analysis'!B50)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B51),\"\",'Coverage Analysis'!B51)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B52),\"\",'Coverage Analysis'!B52)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B53),\"\",'Coverage Analysis'!B53)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B54),\"\",'Coverage Analysis'!B54)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B55),\"\",'Coverage Analysis'!B55)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B56),\"\",'Coverage Analysis'!B56)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B57),\"\",'Coverage Analysis'!B57)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B58),\"\",'Coverage Analysis'!B58)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B59),\"\",'Coverage Analysis'!B59)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B60),\"\",'Coverage Analysis'!B60)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B61),\"\",'Coverage Analysis'!B61)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B62),\"\",'Coverage Analysis'!B62)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B63),\"\",'Coverage Analysis'!B63)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B64),\"\",'Coverage Analysis'!B64)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B65),\"\",'Coverage Analysis'!B65)","v":""}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B66),\"\",'Coverage Analysis'!B66)","v":""}]
[null,"NOT LISTED IN PROTOCOL SCHEDULE "]
[]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B69),,'Coverage Analysis'!B69)","v":"CRF Data Entry"}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B70),\"\",'Coverage Analysis'!B70)","v":"Chart set up"}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B71),\"\",'Coverage Analysis'!B71)","v":"Schedule next visit"}]
[null,{"$f":"IF(ISBLANK('Coverage Analysis'!B72),\"\",'Coverage Analysis'!B72)","v":"Describe Study drug"}]
[null,"Subtotal",{"$f":"SUBTOTAL(9,C13:C76)","v":0},{"$f":"SUBTOTAL(9,D13:D76)","v":0},0,0,0,0,0,{"$f":"SUBTOTAL(9,J13:J76)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUBTOTAL(9,AF13:AF76)","v":0},0,0,{"$f":"SUBTOTAL(9,AI13:AI76)","v":0}]
[null,"IDC",{"$f":"C77*(Summary!$I$15)","v":0},{"$f":"D77*(Summary!$I$15)","v":0},{"$f":"E77*(Summary!$I$15)","v":0},{"$f":"F77*(Summary!$I$15)","v":0},{"$f":"G77*(Summary!$I$15)","v":0},{"$f":"H77*(Summary!$I$15)","v":0},{"$f":"I77*(Summary!$I$15)","v":0},{"$f":"J77*(Summary!$I$15)","v":0},{"$f":"K77*(Summary!$I$15)","v":0},{"$f":"L77*(Summary!$I$15)","v":0},{"$f":"M77*(Summary!$I$15)","v":0},{"$f":"N77*(Summary!$I$15)","v":0},{"$f":"O77*(Summary!$I$15)","v":0},{"$f":"P77*(Summary!$I$15)","v":0},{"$f":"Q77*(Summary!$I$15)","v":0},{"$f":"R77*(Summary!$I$15)","v":0},{"$f":"S77*(Summary!$I$15)","v":0},{"$f":"T77*(Summary!$I$15)","v":0},{"$f":"U77*(Summary!$I$15)","v":0},{"$f":"V77*(Summary!$I$15)","v":0},{"$f":"W77*(Summary!$I$15)","v":0},{"$f":"X77*(Summary!$I$15)","v":0},{"$f":"Y77*(Summary!$I$15)","v":0},{"$f":"Z77*(Summary!$I$15)","v":0},{"$f":"AA77*(Summary!$I$15)","v":0},{"$f":"AB77*(Summary!$I$15)","v":0},{"$f":"AC77*(Summary!$I$15)","v":0},{"$f":"AD77*(Summary!$I$15)","v":0},{"$f":"AE77*(Summary!$I$15)","v":0},{"$f":"AF77*(Summary!$I$15)","v":0},{"$f":"AG77*(Summary!$I$15)","v":0},{"$f":"AH77*(Summary!$I$15)","v":0},{"$f":"AI77*(Summary!$I$15)","v":0}]
[null,"Grand Total",{"$f":"C77+C78","v":0},{"$f":"D77+D78","v":0},0,0,0,0,0,{"$f":"J77+J78","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,{"$f":"AF77+AF78","v":0},0,0,0]
[]
[null,null,null,null,"*Enter the costs   for the items highlighed green above"]
[]
[null,null,"All clinical services and procedures performed for research purposes will be charged to the Finanical account set up for this study."]
[null,null," Most often  a discounted rate for services and procedures performed for research purposes is provided. Communicate with apprpopriate billing staff to identify the exact dollar amount that will be charged."]

{"sheet":"Fees-Invoiceables","index":6,"n_rows":44,"n_cols":11,"rows_kept":44,"cut":false,"hidden":false,"merged":[[10,0,10,2],[43,0,43,2],[16,0,16,2],[17,0,17,2],[14,0,14,2],[15,0,15,2],[13,0,13,2],[11,0,11,2],[12,0,12,2],[9,0,9,2],[0,0,0,1],[0,2,0,11],[1,0,1,1],[1,2,1,11],[2,0,2,1],[2,2,2,11],[4,0,4,2],[5,0,5,2],[6,0,6,2],[7,0,7,2],[8,0,8,2]]}
[{"$f":"Summary!A9","v":"Project Title:"},null,{"$f":"Summary!B9","v":"title"}]
[{"$f":"Summary!A10","v":"Principal Investigator:"},null,{"$f":"Summary!C10","v":"PI"}]
[{"$f":"Summary!A12","v":"CPHS Study Number:"},null,{"$f":"Summary!C12","v":"IRB num"}]
[]
["Start Up Costs",null,null,"Total ","Total W IDC"]
["Start Up Effort",null,null,{"$f":"IF(Effort!W84=0,\"\",Effort!W84)","v":""},{"$f":"IF(Effort!W85=0,\"\",Effort!W85)","v":""}]
["IRB Review Fee - Local or Permission to Rely",null,null,2000,{"$f":"IF(D7=0, \"\",D7*1.3)","v":2600},null,null,null,null,"Coverage Analysis Fees -  for  Industry  and Departmentally Sponsored studies (inclusive of IDC)"]
["Coverage Analysis Fee",null,null,{"$f":"E8/1.3","v":{"$error":"#VALUE!"}},{"$f":"IF(Summary!K6='Fees-Invoiceables'!J8,'Fees-Invoiceables'!K8,IF(Summary!K6='Fees-Invoiceables'!J9,'Fees-Invoiceables'!K9,IF(Summary!K6='Fees-Invoiceables'!J10,'Fees-Invoiceables'!K10,\"\")))","v":""},null,null,null,null,"Low",2069]
["Investigational Pharmacy Setup Fee (Delete if N/A)",null,null,null,null,null,null,null,null,"Medium",3448]
["MHH Adminsitrative Start up Fee (Delete if N/A)",null,null,null,{"$f":"IF(D10=0, \"\",D10*1.3)","v":""},null,null,null,null,"High",4285]
["Radiology Dept Setup Fee (Delete if N/A)",null,null,null,"",null,null,null,null,"Complex",4820]
["CRU Start up Fee (Delete if N/A)",null,null,null,""]
["Lab set up Fee (Delete if N/A)",null,null,null,""]
[null,null,null,null,"",null,null,null,null," Effective 01/01/24  IRB fee is $2600  (inclusive of IDC)  regardless of whether or not the study is requesting full board review or requesting permission to rely on outside IRB"]
[null,null,null,null,""]
[null,null,null,null,""]
[null,null,null,null,""]
["Total Start up Cost ",null,null,{"$f":"SUM(D6:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E7:E17)","v":2600}]
[null,null,null,{"$f":"SUM(D7:D17)","v":{"$error":"#VALUE!"}},{"$f":"SUM(E7:E17)","v":2600}]
["Invoiceable Procedures","Unit cost ","Quantity","Total ","Total W IDC"]
[null,null,null,{"$f":"B21*C21","v":0},{"$f":"D21*1.3","v":0}]
[null,null,null,{"$f":"B22*C22","v":0},{"$f":"D22*1.3","v":0}]
[null,null,null,{"$f":"B23*C23","v":0},{"$f":"D23*1.3","v":0}]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,1,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
[null,null,null,0,0]
["Total Invoiceable Costs ",null,null,{"$f":"SUM(D21:D43)","v":0},{"$f":"SUM(E21:E43)","v":0}]

{"sheet":"QQBR","index":7,"n_rows":45,"n_cols":14,"rows_kept":45,"cut":false,"hidden":false,"merged":[[16,0,16,11],[10,7,10,11],[7,0,7,11],[8,0,8,11],[2,8,2,11],[3,2,3,5],[3,6,3,7],[3,8,3,11],[4,6,4,7],[4,8,4,11],[3,0,3,1],[4,0,4,1],[2,0,2,1],[2,2,2,5],[2,6,2,7],[11,0,11,6],[11,7,11,11],[12,0,12,6],[12,7,12,11],[9,0,10,6],[9,7,9,11],[13,0,13,6],[13,7,13,11],[15,0,15,11],[14,0,14,6],[14,7,14,11],[18,0,18,11],[20,0,20,6],[20,7,20,11],[17,0,17,6],[17,7,17,11],[19,0,19,11],[21,0,21,6],[21,7,21,11],[22,0,22,6],[22,7,22,11],[23,0,23,6],[23,7,23,11],[1,1,1,11],[4,2,4,5],[5,0,5,2],[5,3,5,5],[5,6,5,7],[5,8,5,11],[32,0,32,9],[33,0,33,9],[24,0,24,11],[26,0,26,9],[27,0,27,9],[28,0,28,9],[14,13,20,19],[6,0,6,2],[6,3,6,5],[45,0,50,9],[34,0,34,9],[35,0,35,9],[36,0,36,9],[37,0,37,9],[38,0,38,9],[39,0,39,9],[40,0,40,9],[41,0,41,9],[44,0,44,9],[29,0,29,9],[30,0,30,9],[31,0,31,9]]}
[]
["Project Title:",{"$f":"Summary!B9","v":"title"}]
["Principal Investigator:",null,{"$f":"Summary!C10","v":"PI"},null,null,null,"Department:",null,{"$f":"Summary!I10","v":"SPA"}]
["Sponsor/CRO:",null,{"$f":"Summary!C11","v":"Spon"},null,null,null,"Project Period:",null,{"$f":"Summary!I11","v":"CRO"}]
["CPHS Study Number:",null,{"$f":"Summary!C12","v":"IRB num"},null,null,null,"Coordinator:",null,{"$f":"Summary!I12","v":"NAME"}]
["ClinicalTrials.gov # / NCT #:",null,null,{"$f":"Summary!D13","v":"1"},null,null,"IDE #:",null,{"$f":"Summary!I13","v":"IDE num"}]
["Coverage Analysis Version Date:",null,null,{"$f":"'Coverage Analysis'!AM6","v":"2026-08-19T10:45:01"}]
[]
["Device Studies"]
["What type of device is being studied?"]
[]
["Is the investigational product provided for free by sponsor?"]
["If IDE, has the device “packet” been sent to CMS for approval?"]
["Has it been approved by CMS for billing?"]
["Has the MHH device checklist been completed?",null,null,null,null,null,null,null,null,null,null,null,null,"A DEEMED study is one that meets one of the following criteria:\n\n1. Trials funded by NIH, CDC, AHRQ, CMS, DOD or VA.\n2. Trials supported by centers or cooperative groups that are funded by the NIH, CDC, AHRQ, CMS, DOD or VA.\n3. Trials conducted under an investigational new drug application (IND) reviewed by the FDA.\n4. Drug trials that  are exempt from having an IND under 21 CFR 312.2(b)(1)."]
[]
["Drug/Biologic/Behavioral Studies"]
["Is the investigational product provided for free by sponsor?"]
[]
["Conditions for Qualifying Clinical Trial"]
["The subject or purpose of the trial is the evaluation of an item or service that falls within a Medicare benefit category (e.g., physicians' service, durable medical equipment, or diagnostic test) and is not statutorily excluded from coverage (e.g., cosmetic surgery, hearing aids)."]
["The trial has therapeutic intent (i.e., the trial is not designed exclusively to test toxicity or disease path physiology)."]
["For a trial of a therapeutic intervention, the trial must enroll patients with diagnosed disease rather than healthy volunteers."]
["The trial is considered to be a DEEMED study."]
["Please submit the completed form along with the completed Coverage Analysis to crf@uth.edu.   "]
[]
["Federal Requirements (As Applicable to Medicare and Other Third Party Payers):"]
["1) The billing provider must include in the beneficiary's medical record the following information: trial name, sponsor, and sponsor-assigned protocol number. This information does not need to be submitted with the claim but must be provided if requested for medical review."]
["2) The billing provider must report a National Clinical Trial (NCT) number on claims for items and services provided in clinical trials that are qualified for coverage. Services that are dictated in the clinical trial protocol, including routine care for the condition in the clinical trial, must be submitted with an NCT identifier number on a Medicare claim related to the clinical trial. Only items dictated in the research protocol are required to have the NCT identifier."]
["3) The clinical trial number is assigned by the National Library of Medicine website (http://clincialtrials.gov) when a new study is registered in the NLM Clinical Trials Database."]
["4) Claims also should include the following identifiers when being submitted to Medicare: a) Condition Code 30 (qualified clinical trial) b) ICD-10 code z00.6 (clinical research participant) as a secondary diagnosis c) Modifier Q0 (investigational item) or Q1 (routine services)"]
[]
["UTHealth Clinical Research Billing Policy"]
["1)  It is the responsibility of the PI to ensure that the clinical research billing of his or her studies is in compliance with all laws and regulations and adhere to university policy. The PI, his or her research staff, department administrators, and the CRF Team must work together to ensure the components of accurate billing are in place. Please refer to the Coverage Analysis Procedure and the Clinical Research Billing Procedure."]
["2)  The PI and study staff must prepare and submit a coverage analysis"]
["3)  The coverage analysis should be consistent with the study protocol and informed consent and should accurately and appropriately allocate the costs associated with the performance of the clinical study to the responsible payer. "]
["4)  The study budget should reflect all charges listed in the coverage analysis as sponsored paid research. "]
["5)  The PI and study staff must ensure that there is an outlined plan to identify research patients prior to providing services. "]
["6)  The PI and study staff must ensure that the services for study subjects enrolled in the clinical research project are billed in accordance with the coverage analysis and that the bills are based on actual services rendered and consistent with the informed consent. "]
["7)  After services are provided, study staff must coordinate with the appropriate personnel to ensure that proper billing information is provided. "]
["8)  Each department and clinic must follow clinical research billing procedures specific to its unit or practice in order to ensure that clinical research billing is conducted appropriately and accurately. "]
["9)  Study staff must conduct periodic reconciliation of clinical research billing charges."]
[]
["CERTIFICATION: "]
["I certify that I have read and understand the UTHealth Clinical Research Billing Policy and will comply with all applicable laws and UTHealth rules and policies governing clinical research billing.  I certify to the best of my ability that the coverage analysis dated above is correct."]