{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["STUDY DETAILS","CTU ORDER FORM","DATA-DO NOT DELETE"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":11,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"STUDY DETAILS","index":0,"n_rows":18,"n_cols":1,"rows_kept":18,"cut":false,"hidden":false,"merged":[[23,0,23,9],[24,0,24,9],[18,0,18,9],[19,0,19,9],[20,0,20,9],[21,0,21,9],[22,0,22,9],[1,0,1,9],[13,0,13,1],[13,2,13,3],[14,0,14,1],[14,2,14,3],[10,0,10,1],[10,2,10,3],[11,0,11,1],[11,2,11,3],[12,0,12,1],[12,2,12,3],[7,0,7,1],[7,2,7,3],[8,0,8,1],[8,2,8,3],[9,0,9,1],[9,2,9,3],[4,0,4,1],[4,2,4,3],[5,0,5,1],[5,2,5,3],[6,0,6,1],[6,2,6,3]]}
["CLINICAL TRIALS UNIT (CTU) SERVICES ORDER FORM"]
["Instructions: To request CTU services, please complete this order form and upload along with your application in OnCore - Protocols Tab>PC Console>Documents/Info>Attachments>Updated>Add"]
["For assistance, contact ctu@sc-ctsi.org or 323-865-3056."]
[]
["Submission Date:"]
["OnCore Protocol Number:"]
["IRB Number (if available):"]
["PI Name (Last, First):"]
["PI Department:"]
["Study Type:"]
["Lab Only (Y/N):"]
["Arm/Segment/Cohort Name: "]
["Is this an amendment after study activation by CTO:"]
["Protocol Version Date:"]
["Laboratory Manual Version Date: "]
[]
[]
["Study Team Comments/Notes:"]

{"sheet":"CTU ORDER FORM","index":1,"n_rows":82,"n_cols":27,"rows_kept":82,"cut":false,"hidden":false,"merged":[[2,26,3,26],[2,11,2,12],[2,13,2,14],[2,15,2,16],[2,17,2,18],[2,23,2,24],[2,21,2,22],[2,19,2,20],[70,0,70,2],[29,0,29,1],[58,0,58,2],[12,0,12,1],[17,0,17,1],[22,0,22,1],[24,0,24,1],[39,0,39,1],[2,7,2,8],[2,9,2,10],[2,5,2,6],[2,3,2,4],[67,0,67,2]]}
[null,null,null,"PLEASE LIST THE SERVICES NEEDED PER VISIT FOR EACH PATIENT FOR YOUR STUDY",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hold"]
[{"$f":"MATCH(\"hold\",1:1,0)","v":26}]
[{"$f":"SUBSTITUTE(ADDRESS(1,A2,4),1,\"\")&\":\"&SUBSTITUTE(ADDRESS(1,A2,4),1,\"\")","v":"Z:Z"},{"$f":"SUBSTITUTE(ADDRESS(1,A2-2,4),1,\"\")&\":\"&SUBSTITUTE(ADDRESS(1,A2-1,4),1,\"\")","v":"X:Y"},null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,"VISIT NAME?",null,null,"TOTAL COST PER SERVICE"]
["A. COMMON CLINICAL PROCEDURES",null,"PRICE","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total","Qty/Freq","Total"]
["CTU-101","Vital signs",6,null,{"$f":"$C$5*D5","v":0},null,{"$f":"$C$5*F5","v":0},null,{"$f":"$C$5*H5","v":0},null,{"$f":"$C$5*J5","v":0},null,{"$f":"$C$5*L5","v":0},null,{"$f":"$C$5*N5","v":0},null,{"$f":"$C$5*P5","v":0},null,{"$f":"$C$5*R5","v":0},null,{"$f":"$C$5*T5","v":0},null,{"$f":"$C$5*V5","v":0},null,{"$f":"$C$5*X5","v":0},null,{"$f":"SUMPRODUCT(D5:Z5*MOD(COLUMN(D5:Z5)-COLUMN(E5)+1,2))","v":0}]
["CTU-102","Height/Weight/BSA",6,null,{"$f":"$C$6*D6","v":0},null,{"$f":"$C$6*F6","v":0},null,{"$f":"$C$6*H6","v":0},null,{"$f":"$C$6*J6","v":0},null,{"$f":"$C$6*L6","v":0},null,{"$f":"$C$6*N6","v":0},null,{"$f":"$C$6*P6","v":0},null,{"$f":"$C$6*R6","v":0},null,{"$f":"$C$6*T6","v":0},null,{"$f":"$C$6*V6","v":0},null,{"$f":"$C$6*X6","v":0},null,{"$f":"SUMPRODUCT(D6:Z6*MOD(COLUMN(D6:Z6)-COLUMN(E6)+1,2))","v":0}]
["CTU-103","Direct Venipuncture",12,null,{"$f":"$C$7*D7","v":0},null,{"$f":"$C$7*F7","v":0},null,{"$f":"$C$7*H7","v":0},null,{"$f":"$C$7*J7","v":0},null,{"$f":"$C$7*L7","v":0},null,{"$f":"$C$7*N7","v":0},null,{"$f":"$C$7*P7","v":0},null,{"$f":"$C$7*R7","v":0},null,{"$f":"$C$7*T7","v":0},null,{"$f":"$C$7*V7","v":0},null,{"$f":"$C$7*X7","v":0},null,0]
["CTU-104","Blood Draw by Intravenous (IV): First draw, includes IV placement time  and initial tube",36,null,{"$f":"$C$8*D8","v":0},null,{"$f":"$C$8*F8","v":0},null,{"$f":"$C$8*H8","v":0},null,{"$f":"$C$8*J8","v":0},null,{"$f":"$C$8*L8","v":0},null,{"$f":"$C$8*N8","v":0},null,{"$f":"$C$8*P8","v":0},null,{"$f":"$C$8*R8","v":0},null,{"$f":"$C$8*T8","v":0},null,{"$f":"$C$8*V8","v":0},null,{"$f":"$C$8*X8","v":0},null,0]
["CTU-105","Blood Draw by Intravenous (IV): Additional tubes",6,null,{"$f":"$C$9*D9","v":0},null,{"$f":"$C$9*F9","v":0},null,{"$f":"$C$9*H9","v":0},null,{"$f":"$C$9*J9","v":0},null,{"$f":"$C$9*L9","v":0},null,{"$f":"$C$9*N9","v":0},null,{"$f":"$C$9*P9","v":0},null,{"$f":"$C$9*R9","v":0},null,{"$f":"$C$9*T9","v":0},null,{"$f":"$C$9*V9","v":0},null,{"$f":"$C$9*X9","v":0},null,0]
["CTU-106","Blood glucose - finger stick",12,null,{"$f":"$C$10*D10","v":0},null,{"$f":"$C$10*F10","v":0},null,{"$f":"$C$10*H10","v":0},null,{"$f":"$C$10*J10","v":0},null,{"$f":"$C$10*L10","v":0},null,{"$f":"$C$10*N10","v":0},null,{"$f":"$C$10*P10","v":0},null,{"$f":"$C$10*R10","v":0},null,{"$f":"$C$10*T10","v":0},null,{"$f":"$C$10*V10","v":0},null,{"$f":"$C$10*X10","v":0},null,0]
["CTU-107","Urine pregnancy",24,null,{"$f":"$C$11*D11","v":0},null,{"$f":"$C$11*F11","v":0},null,{"$f":"$C$11*H11","v":0},null,{"$f":"$C$11*J11","v":0},null,{"$f":"$C$11*L11","v":0},null,{"$f":"$C$11*N11","v":0},null,{"$f":"$C$11*P11","v":0},null,{"$f":"$C$11*R11","v":0},null,{"$f":"$C$11*T11","v":0},null,{"$f":"$C$11*V11","v":0},null,{"$f":"$C$11*X11","v":0},null,0]
["CTU-108","Body fluid collections (urine, stool or sputum)",12,null,{"$f":"$C$12*D12","v":0},null,{"$f":"$C$12*F12","v":0},null,{"$f":"$C$12*H12","v":0},null,{"$f":"$C$12*J12","v":0},null,{"$f":"$C$12*L12","v":0},null,{"$f":"$C$12*N12","v":0},null,{"$f":"$C$12*P12","v":0},null,{"$f":"$C$12*R12","v":0},null,{"$f":"$C$12*T12","v":0},null,{"$f":"$C$12*V12","v":0},null,{"$f":"$C$12*X12","v":0},null,0]
["B. IND/INP/MEDICATION ADMINISTRATION"]
["CTU-201","Oral or Topical",12,null,{"$f":"$C$14*D14","v":0},null,{"$f":"$C$14*F14","v":0},null,{"$f":"$C$14*H14","v":0},null,{"$f":"$C$14*J14","v":0},null,{"$f":"$C$14*L14","v":0},null,{"$f":"$C$14*N14","v":0},null,{"$f":"$C$14*P14","v":0},null,{"$f":"$C$14*R14","v":0},null,{"$f":"$C$14*T14","v":0},null,{"$f":"$C$14*V14","v":0},null,{"$f":"$C$14*X14","v":0},null,{"$f":"SUMPRODUCT(D14:Z14*MOD(COLUMN(D14:Z14)-COLUMN(E14)+1,2))","v":0}]
["CTU-202","Intramuscular (IM) or Subcutaneous (SubQ) Injection",80,null,{"$f":"$C$15*D15","v":0},null,{"$f":"$C$15*F15","v":0},null,{"$f":"$C$15*H15","v":0},null,{"$f":"$C$15*J15","v":0},null,{"$f":"$C$15*L15","v":0},null,{"$f":"$C$15*N15","v":0},null,{"$f":"$C$15*P15","v":0},null,{"$f":"$C$15*R15","v":0},null,{"$f":"$C$15*T15","v":0},null,{"$f":"$C$15*V15","v":0},null,{"$f":"$C$15*X15","v":0},null,{"$f":"SUMPRODUCT(D15:Z15*MOD(COLUMN(D15:Z15)-COLUMN(E15)+1,2))","v":0}]
["CTU-203","Intravenous (IV) Infusion  - Includes IV access, initial set up, drug verification, & initial 60 Min infusion",230,null,{"$f":"$C$16*D16","v":0},null,{"$f":"$C$16*F16","v":0},null,{"$f":"$C$16*H16","v":0},null,{"$f":"$C$16*J16","v":0},null,{"$f":"$C$16*L16","v":0},null,{"$f":"$C$16*N16","v":0},null,{"$f":"$C$16*P16","v":0},null,{"$f":"$C$16*R16","v":0},null,{"$f":"$C$16*T16","v":0},null,{"$f":"$C$16*V16","v":0},null,{"$f":"$C$16*X16","v":0},null,{"$f":"SUMPRODUCT(D16:Z16*MOD(COLUMN(D16:Z16)-COLUMN(E16)+1,2))","v":0}]
["CTU-204","Intravenous (IV) Infusion  -  Additional Infusion Time Needed (30 Min Increments)",58,null,{"$f":"IFERROR(VLOOKUP(D17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(H17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(J17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(L17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(N17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(P17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(R17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(T17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(V17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(X17,'DATA-DO NOT DELETE'!$C$3:$I$22,7,0),0)","v":0},null,{"$f":"SUMPRODUCT(D17:Z17*MOD(COLUMN(D17:Z17)-COLUMN(E17)+1,2))","v":0}]
["C, HYDRATION"]
["CTU-301","Pre-Chemotherapy Hydration - Initial 60 Min",144,null,{"$f":"$C$19*D19","v":0},null,{"$f":"$C$19*F19","v":0},null,{"$f":"$C$19*H19","v":0},null,{"$f":"$C$19*J19","v":0},null,{"$f":"$C$19*L19","v":0},null,{"$f":"$C$19*N19","v":0},null,{"$f":"$C$19*P19","v":0},null,{"$f":"$C$19*R19","v":0},null,{"$f":"$C$19*T19","v":0},null,{"$f":"$C$19*V19","v":0},null,{"$f":"$C$19*X19","v":0},null,{"$f":"SUMPRODUCT(D19:Z19*MOD(COLUMN(D19:Z19)-COLUMN(E19)+1,2))","v":0}]
["CTU-302","Pre-Chemotherapy Hydration - Each Additional 30 Min",36,null,{"$f":"IFERROR(VLOOKUP(D20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(H20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(J20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(L20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(N20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(P20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(R20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(T20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(V20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(X20,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"SUMPRODUCT(D20:Z20*MOD(COLUMN(D20:Z20)-COLUMN(E20)+1,2))","v":0}]
["CTU-303","Post-Chemotherapy Hydration - Initial 60 Min",144,null,{"$f":"$C$21*D21","v":0},null,{"$f":"$C$21*F21","v":0},null,{"$f":"$C$21*H21","v":0},null,{"$f":"$C$21*J21","v":0},null,{"$f":"$C$21*L21","v":0},null,{"$f":"$C$21*N21","v":0},null,{"$f":"$C$21*P21","v":0},null,{"$f":"$C$21*R21","v":0},null,{"$f":"$C$21*T21","v":0},null,{"$f":"$C$21*V21","v":0},null,{"$f":"$C$21*X21","v":0},null,{"$f":"SUMPRODUCT(D21:Z21*MOD(COLUMN(D21:Z21)-COLUMN(E21)+1,2))","v":0}]
["CTU-304","Post-Chemotherapy Hydration - Each Additional 30 Min",36,null,{"$f":"IFERROR(VLOOKUP(D22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(H22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(J22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(L22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(N22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(P22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(R22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(T22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(V22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(X22,'DATA-DO NOT DELETE'!$C$3:$E$22,3,0),0)","v":0},null,{"$f":"SUMPRODUCT(D22:Z22*MOD(COLUMN(D22:Z22)-COLUMN(E22)+1,2))","v":0}]
["D,  OBSERVATION/EDUCATION (NO BLOOD DRAW)"]
["CTU-401","Patient Observation, Education and Training  (30 Min Increments)",54,null,{"$f":"IFERROR(VLOOKUP(D24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(F24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(H24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(J24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(L24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(N24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(P24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(R24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(T24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(V24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"IFERROR(VLOOKUP(X24,'DATA-DO NOT DELETE'!$C$3:$G$22,5,0),0)","v":0},null,{"$f":"SUMPRODUCT(D24:Z24*MOD(COLUMN(D24:Z24)-COLUMN(E24)+1,2))","v":0}]
["E. EKG & CARDIAC MONITORING"]
["CTU-501","Single EKG (12 lead): No interpretation \n",91.68,null,{"$f":"$C$26*D26","v":0},null,{"$f":"$C$26*F26","v":0},null,{"$f":"$C$26*H26","v":0},null,{"$f":"$C$26*J26","v":0},null,{"$f":"$C$26*L26","v":0},null,{"$f":"$C$26*N26","v":0},null,{"$f":"$C$26*P26","v":0},null,{"$f":"$C$26*R26","v":0},null,{"$f":"$C$26*T26","v":0},null,{"$f":"$C$26*V26","v":0},null,{"$f":"$C$26*X26","v":0},null,{"$f":"SUMPRODUCT(D26:Z26*MOD(COLUMN(D26:Z26)-COLUMN(E26)+1,2))","v":0}]
["CTU-502","Triplicate EKG (12 lead): Set of three EKGs, No interpretation ",275.04000000000002,null,{"$f":"$C$27*D27","v":0},null,{"$f":"$C$27*F27","v":0},null,{"$f":"$C$27*H27","v":0},null,{"$f":"$C$27*J27","v":0},null,{"$f":"$C$27*L27","v":0},null,{"$f":"$C$27*N27","v":0},null,{"$f":"$C$27*P27","v":0},null,{"$f":"$C$27*R27","v":0},null,{"$f":"$C$27*T27","v":0},null,{"$f":"$C$27*V27","v":0},null,{"$f":"$C$27*X27","v":0},null,{"$f":"SUMPRODUCT(D27:Z27*MOD(COLUMN(D27:Z27)-COLUMN(E27)+1,2))","v":0}]
["CTU-503","Cardiac Monitoring, No interpretation",144,null,{"$f":"$C$28*D28","v":0},null,{"$f":"$C$28*F28","v":0},null,{"$f":"$C$28*H28","v":0},null,{"$f":"$C$28*J28","v":0},null,{"$f":"$C$28*L28","v":0},null,{"$f":"$C$28*N28","v":0},null,{"$f":"$C$28*P28","v":0},null,{"$f":"$C$28*R28","v":0},null,{"$f":"$C$28*T28","v":0},null,{"$f":"$C$28*V28","v":0},null,{"$f":"$C$28*X28","v":0},null,{"$f":"SUMPRODUCT(D28:Z28*MOD(COLUMN(D28:Z28)-COLUMN(E28)+1,2))","v":0}]
["CTU-504","Holter Monitor (hook up, recording and disconnection)",72,null,{"$f":"$C$29*D29","v":0},null,{"$f":"$C$29*F29","v":0},null,{"$f":"$C$29*H29","v":0},null,{"$f":"$C$29*J29","v":0},null,{"$f":"$C$29*L29","v":0},null,{"$f":"$C$29*N29","v":0},null,{"$f":"$C$29*P29","v":0},null,{"$f":"$C$29*R29","v":0},null,{"$f":"$C$29*T29","v":0},null,{"$f":"$C$29*V29","v":0},null,{"$f":"$C$29*X29","v":0},null,{"$f":"SUMPRODUCT(D29:Z29*MOD(COLUMN(D29:Z29)-COLUMN(E29)+1,2))","v":0}]
["F. CTU BODY COMPOSITION SERVICES"]
["CTU-601","DEXA whole body composition, hip,  & spine (combined)",190,null,{"$f":"$C$31*D31","v":0},null,{"$f":"$C$31*F31","v":0},null,{"$f":"$C$31*H31","v":0},null,{"$f":"$C$31*J31","v":0},null,{"$f":"$C$31*L31","v":0},null,{"$f":"$C$31*N31","v":0},null,{"$f":"$C$31*P31","v":0},null,{"$f":"$C$31*R31","v":0},null,{"$f":"$C$31*T31","v":0},null,{"$f":"$C$31*V31","v":0},null,{"$f":"$C$31*X31","v":0},null,{"$f":"SUMPRODUCT(D31:Z31*MOD(COLUMN(D31:Z31)-COLUMN(E31)+1,2))","v":0}]
["CTU-602","DEXA whole body (composition)",150,null,{"$f":"$C$32*D32","v":0},null,{"$f":"$C$32*F32","v":0},null,{"$f":"$C$32*H32","v":0},null,{"$f":"$C$32*J32","v":0},null,{"$f":"$C$32*L32","v":0},null,{"$f":"$C$32*N32","v":0},null,{"$f":"$C$32*P32","v":0},null,{"$f":"$C$32*R32","v":0},null,{"$f":"$C$32*T32","v":0},null,{"$f":"$C$32*V32","v":0},null,{"$f":"$C$32*X32","v":0},null,0]
["CTU-603","DEXA bone density (spine)",75,null,{"$f":"$C$33*D33","v":0},null,{"$f":"$C$33*F33","v":0},null,{"$f":"$C$33*H33","v":0},null,{"$f":"$C$33*J33","v":0},null,{"$f":"$C$33*L33","v":0},null,{"$f":"$C$33*N33","v":0},null,{"$f":"$C$33*P33","v":0},null,{"$f":"$C$33*R33","v":0},null,{"$f":"$C$33*T33","v":0},null,{"$f":"$C$33*V33","v":0},null,{"$f":"$C$33*X33","v":0},null,0]
["CTU-604","DEXA bone density (hip)",75,null,{"$f":"$C$34*D34","v":0},null,{"$f":"$C$34*F34","v":0},null,{"$f":"$C$34*H34","v":0},null,{"$f":"$C$34*J34","v":0},null,{"$f":"$C$34*L34","v":0},null,{"$f":"$C$34*N34","v":0},null,{"$f":"$C$34*P34","v":0},null,{"$f":"$C$34*R34","v":0},null,{"$f":"$C$34*T34","v":0},null,{"$f":"$C$34*V34","v":0},null,{"$f":"$C$34*X34","v":0},null,0]
["CTU-605","DEXA Data Processing",40,null,{"$f":"$C$35*D35","v":0},null,{"$f":"$C$35*F35","v":0},null,{"$f":"$C$35*H35","v":0},null,{"$f":"$C$35*J35","v":0},null,{"$f":"$C$35*L35","v":0},null,{"$f":"$C$35*N35","v":0},null,{"$f":"$C$35*P35","v":0},null,{"$f":"$C$35*R35","v":0},null,{"$f":"$C$35*T35","v":0},null,{"$f":"$C$35*V35","v":0},null,{"$f":"$C$35*X35","v":0},null,0]
["CTU-606","DEXA Phantom scan for multisite study",40,null,{"$f":"$C$36*D36","v":0},null,{"$f":"$C$36*F36","v":0},null,{"$f":"$C$36*H36","v":0},null,{"$f":"$C$36*J36","v":0},null,{"$f":"$C$36*L36","v":0},null,{"$f":"$C$36*N36","v":0},null,{"$f":"$C$36*P36","v":0},null,{"$f":"$C$36*R36","v":0},null,{"$f":"$C$36*T36","v":0},null,{"$f":"$C$36*V36","v":0},null,{"$f":"$C$36*X36","v":0},null,0]
["CTU-606","Waist-hip circumference ",12,null,{"$f":"$C$37*D37","v":0},null,{"$f":"$C$37*F37","v":0},null,{"$f":"$C$37*H37","v":0},null,{"$f":"$C$37*J37","v":0},null,{"$f":"$C$37*L37","v":0},null,{"$f":"$C$37*N37","v":0},null,{"$f":"$C$37*P37","v":0},null,{"$f":"$C$37*R37","v":0},null,{"$f":"$C$37*T37","v":0},null,{"$f":"$C$37*V37","v":0},null,{"$f":"$C$37*X37","v":0},null,0]
["CTU-608","Skinfold measurement (per site)",20,null,{"$f":"$C$38*D38","v":0},null,{"$f":"$C$38*F38","v":0},null,{"$f":"$C$38*H38","v":0},null,{"$f":"$C$38*J38","v":0},null,{"$f":"$C$38*L38","v":0},null,{"$f":"$C$38*N38","v":0},null,{"$f":"$C$38*P38","v":0},null,{"$f":"$C$38*R38","v":0},null,{"$f":"$C$38*T38","v":0},null,{"$f":"$C$38*V38","v":0},null,{"$f":"$C$38*X38","v":0},null,0]
["CTU-609","Other: Please contact CTU",null,null,{"$f":"$C$39*D39","v":0},null,{"$f":"$C$39*F39","v":0},null,{"$f":"$C$39*H39","v":0},null,{"$f":"$C$39*J39","v":0},null,{"$f":"$C$39*L39","v":0},null,{"$f":"$C$39*N39","v":0},null,{"$f":"$C$39*P39","v":0},null,{"$f":"$C$39*R39","v":0},null,{"$f":"$C$39*T39","v":0},null,{"$f":"$C$39*V39","v":0},null,{"$f":"$C$39*X39","v":0},null,0]
["G. SAMPLE PROCESSING - TO BE COMPLETED BY CTU TEAM"]
["CTU-701","Processing: Blood, charge includes 3 aliquots/transfer tubes",15,null,{"$f":"$C$41*D41","v":0},null,{"$f":"$C$41*F41","v":0},null,{"$f":"$C$41*H41","v":0},null,{"$f":"$C$41*J41","v":0},null,{"$f":"$C$41*L41","v":0},null,{"$f":"$C$41*N41","v":0},null,{"$f":"$C$41*P41","v":0},null,{"$f":"$C$41*R41","v":0},null,{"$f":"$C$41*T41","v":0},null,{"$f":"$C$41*V41","v":0},null,{"$f":"$C$41*X41","v":0},null,{"$f":"SUMPRODUCT(D41:Z41*MOD(COLUMN(D41:Z41)-COLUMN(E41)+1,2))","v":0}]
["CTU-702","Additional Aliquots/transfer tubes needed ",1,null,{"$f":"$C$42*D42","v":0},null,{"$f":"$C$42*F42","v":0},null,{"$f":"$C$42*H42","v":0},null,{"$f":"$C$42*J42","v":0},null,{"$f":"$C$42*L42","v":0},null,{"$f":"$C$42*N42","v":0},null,{"$f":"$C$42*P42","v":0},null,{"$f":"$C$42*R42","v":0},null,{"$f":"$C$42*T42","v":0},null,{"$f":"$C$42*V42","v":0},null,{"$f":"$C$42*X42","v":0},null,0]
["CTU-703","Additional additives needed ",1,null,{"$f":"$C$43*D43","v":0},null,{"$f":"$C$43*F43","v":0},null,{"$f":"$C$43*H43","v":0},null,{"$f":"$C$43*J43","v":0},null,{"$f":"$C$43*L43","v":0},null,{"$f":"$C$43*N43","v":0},null,{"$f":"$C$43*P43","v":0},null,{"$f":"$C$43*R43","v":0},null,{"$f":"$C$43*T43","v":0},null,{"$f":"$C$43*V43","v":0},null,{"$f":"$C$43*X43","v":0},null,0]
["CTU-704","Extra centrifugation step",6,null,{"$f":"$C$44*D44","v":0},null,{"$f":"$C$44*F44","v":0},null,{"$f":"$C$44*H44","v":0},null,{"$f":"$C$44*J44","v":0},null,{"$f":"$C$44*L44","v":0},null,{"$f":"$C$44*N44","v":0},null,{"$f":"$C$44*P44","v":0},null,{"$f":"$C$44*R44","v":0},null,{"$f":"$C$44*T44","v":0},null,{"$f":"$C$44*V44","v":0},null,{"$f":"$C$44*X44","v":0},null,0]
["CTU-705","Whole Blood without processing (no centrifugation)",10,null,{"$f":"$C$45*D45","v":0},null,{"$f":"$C$45*F45","v":0},null,{"$f":"$C$45*H45","v":0},null,{"$f":"$C$45*J45","v":0},null,{"$f":"$C$45*L45","v":0},null,{"$f":"$C$45*N45","v":0},null,{"$f":"$C$45*P45","v":0},null,{"$f":"$C$45*R45","v":0},null,{"$f":"$C$45*T45","v":0},null,{"$f":"$C$45*V45","v":0},null,{"$f":"$C$45*X45","v":0},null,0]
["CTU-706","Processing: Urine or 24hr urine collection",15,null,{"$f":"$C$46*D46","v":0},null,{"$f":"$C$46*F46","v":0},null,{"$f":"$C$46*H46","v":0},null,{"$f":"$C$46*J46","v":0},null,{"$f":"$C$46*L46","v":0},null,{"$f":"$C$46*N46","v":0},null,{"$f":"$C$46*P46","v":0},null,{"$f":"$C$46*R46","v":0},null,{"$f":"$C$46*T46","v":0},null,{"$f":"$C$46*V46","v":0},null,{"$f":"$C$46*X46","v":0},null,0]
["CTU-707","Processing: Hair follicle",15,null,{"$f":"$C$47*D47","v":0},null,{"$f":"$C$47*F47","v":0},null,{"$f":"$C$47*H47","v":0},null,{"$f":"$C$47*J47","v":0},null,{"$f":"$C$47*L47","v":0},null,{"$f":"$C$47*N47","v":0},null,{"$f":"$C$47*P47","v":0},null,{"$f":"$C$47*R47","v":0},null,{"$f":"$C$47*T47","v":0},null,{"$f":"$C$47*V47","v":0},null,{"$f":"$C$47*X47","v":0},null,0]
["CTU-708","Processing: Stool",15,null,{"$f":"$C$48*D48","v":0},null,{"$f":"$C$48*F48","v":0},null,{"$f":"$C$48*H48","v":0},null,{"$f":"$C$48*J48","v":0},null,{"$f":"$C$48*L48","v":0},null,{"$f":"$C$48*N48","v":0},null,{"$f":"$C$48*P48","v":0},null,{"$f":"$C$48*R48","v":0},null,{"$f":"$C$48*T48","v":0},null,{"$f":"$C$48*V48","v":0},null,{"$f":"$C$48*X48","v":0},null,0]
["CTU-709","Processing : Saliva",15,null,{"$f":"$C$49*D49","v":0},null,{"$f":"$C$49*F49","v":0},null,{"$f":"$C$49*H49","v":0},null,{"$f":"$C$49*J49","v":0},null,{"$f":"$C$49*L49","v":0},null,{"$f":"$C$49*N49","v":0},null,{"$f":"$C$49*P49","v":0},null,{"$f":"$C$49*R49","v":0},null,{"$f":"$C$49*T49","v":0},null,{"$f":"$C$49*V49","v":0},null,{"$f":"$C$49*X49","v":0},null,0]
["CTU-710","Processing: Blood smear (slide x 2)",10,null,{"$f":"$C$50*D50","v":0},null,{"$f":"$C$50*F50","v":0},null,{"$f":"$C$50*H50","v":0},null,{"$f":"$C$50*J50","v":0},null,{"$f":"$C$50*L50","v":0},null,{"$f":"$C$50*N50","v":0},null,{"$f":"$C$50*P50","v":0},null,{"$f":"$C$50*R50","v":0},null,{"$f":"$C$50*T50","v":0},null,{"$f":"$C$50*V50","v":0},null,{"$f":"$C$50*X50","v":0},null,0]
["CTU-711","Processing: Buffy Coat From Whole Blood",25,null,{"$f":"$C$51*D51","v":0},null,{"$f":"$C$51*F51","v":0},null,{"$f":"$C$51*H51","v":0},null,{"$f":"$C$51*J51","v":0},null,{"$f":"$C$51*L51","v":0},null,{"$f":"$C$51*N51","v":0},null,{"$f":"$C$51*P51","v":0},null,{"$f":"$C$51*R51","v":0},null,{"$f":"$C$51*T51","v":0},null,{"$f":"$C$51*V51","v":0},null,{"$f":"$C$51*X51","v":0},null,0]
["CTU-712","Processing: WBC From Whole Blood",75,null,{"$f":"$C$52*D52","v":0},null,{"$f":"$C$52*F52","v":0},null,{"$f":"$C$52*H52","v":0},null,{"$f":"$C$52*J52","v":0},null,{"$f":"$C$52*L52","v":0},null,{"$f":"$C$52*N52","v":0},null,{"$f":"$C$52*P52","v":0},null,{"$f":"$C$52*R52","v":0},null,{"$f":"$C$52*T52","v":0},null,{"$f":"$C$52*V52","v":0},null,{"$f":"$C$52*X52","v":0},null,0]
["CTU-713","Processing: Serum/plasma ultrafiltrate",20,null,{"$f":"$C$53*D53","v":0},null,{"$f":"$C$53*F53","v":0},null,{"$f":"$C$53*H53","v":0},null,{"$f":"$C$53*J53","v":0},null,{"$f":"$C$53*L53","v":0},null,{"$f":"$C$53*N53","v":0},null,{"$f":"$C$53*P53","v":0},null,{"$f":"$C$53*R53","v":0},null,{"$f":"$C$53*T53","v":0},null,{"$f":"$C$53*V53","v":0},null,{"$f":"$C$53*X53","v":0},null,0]
["CTU-714","Processing: Quantiferon-Gold  (3 tube set)",25,null,{"$f":"$C$54*D54","v":0},null,{"$f":"$C$54*F54","v":0},null,{"$f":"$C$54*H54","v":0},null,{"$f":"$C$54*J54","v":0},null,{"$f":"$C$54*L54","v":0},null,{"$f":"$C$54*N54","v":0},null,{"$f":"$C$54*P54","v":0},null,{"$f":"$C$54*R54","v":0},null,{"$f":"$C$54*T54","v":0},null,{"$f":"$C$54*V54","v":0},null,{"$f":"$C$54*X54","v":0},null,0]
["CTU-715","Shipping & Handling - Total # of boxes per delivery location",15,null,{"$f":"$C$55*D55","v":0},null,{"$f":"$C$55*F55","v":0},null,{"$f":"$C$55*H55","v":0},null,{"$f":"$C$55*J55","v":0},null,{"$f":"$C$55*L55","v":0},null,{"$f":"$C$55*N55","v":0},null,{"$f":"$C$55*P55","v":0},null,{"$f":"$C$55*R55","v":0},null,{"$f":"$C$55*T55","v":0},null,{"$f":"$C$55*V55","v":0},null,{"$f":"$C$55*X55","v":0},null,0]
["CTU-716","Processing: Sputum",25,null,{"$f":"$C$56*D56","v":0},null,{"$f":"$C$56*F56","v":0},null,{"$f":"$C$56*H56","v":0},null,{"$f":"$C$56*J56","v":0},null,{"$f":"$C$56*L56","v":0},null,{"$f":"$C$56*N56","v":0},null,{"$f":"$C$56*P56","v":0},null,{"$f":"$C$56*R56","v":0},null,{"$f":"$C$56*T56","v":0},null,{"$f":"$C$56*V56","v":0},null,{"$f":"$C$56*X56","v":0},null,0]
["CTU-717","Other Processing: Please contact CTU",null,null,{"$f":"$C$57*D57","v":0},null,{"$f":"$C$57*F57","v":0},null,{"$f":"$C$57*H57","v":0},null,{"$f":"$C$57*J57","v":0},null,{"$f":"$C$57*L57","v":0},null,{"$f":"$C$57*N57","v":0},null,{"$f":"$C$57*P57","v":0},null,{"$f":"$C$57*R57","v":0},null,{"$f":"$C$57*T57","v":0},null,{"$f":"$C$57*V57","v":0},null,{"$f":"$C$57*X57","v":0},null,0]
[]
["TOTAL CTU COST PER PARTICIPANT",null,null,null,{"$f":"SUM(E5:E12,E14:E17,E19:E22,E24:E24,E26:E29,E41:E57,E31:E39)","v":0},null,{"$f":"SUM(G5:G12,G14:G17,G19:G22,G24:G24,G26:G29,G41:G57,G31:G39)","v":0},null,{"$f":"SUM(I5:I12,I14:I17,I19:I22,I24:I24,I26:I29,I41:I57,I31:I39)","v":0},null,{"$f":"SUM(K5:K12,K14:K17,K19:K22,K24:K24,K26:K29,K41:K57,K31:K39)","v":0},null,{"$f":"SUM(M5:M12,M14:M17,M19:M22,M24:M24,M26:M29,M41:M57,M31:M39)","v":0},null,{"$f":"SUM(O5:O12,O14:O17,O19:O22,O24:O24,O26:O29,O41:O57,O31:O39)","v":0},null,{"$f":"SUM(Q5:Q12,Q14:Q17,Q19:Q22,Q24:Q24,Q26:Q29,Q41:Q57,Q31:Q39)","v":0},null,{"$f":"SUM(S5:S12,S14:S17,S19:S22,S24:S24,S26:S29,S41:S57,S31:S39)","v":0},null,{"$f":"SUM(U5:U12,U14:U17,U19:U22,U24:U24,U26:U29,U41:U57,U31:U39)","v":0},null,{"$f":"SUM(W5:W12,W14:W17,W19:W22,W24:W24,W26:W29,W41:W57,W31:W39)","v":0},null,{"$f":"SUM(Y5:Y12,Y14:Y17,Y19:Y22,Y24:Y24,Y26:Y29,Y41:Y57,Y31:Y39)","v":0},null,{"$f":"SUM(AA5:AA12,AA14:AA17,AA19:AA22,AA24:AA24,AA26:AA29,AA41:AA57,AA31:AA39)","v":0}]
[]
["NORRIS HOSPITAL CHARGES  - These are hospital charges billed to the study and paid directly to Norris Hospital"]
["CTU-NOR-101","CTU Norris E&M Outpatient",30,{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, E59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, E59>0), 1, 0)","v":0},{"$f":"$C$62*D62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, G59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, G59>0), 1, 0)","v":0},{"$f":"$C$62*F62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, I59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, I59>0), 1, 0)","v":0},{"$f":"$C$62*H62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, K59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, K59>0), 1, 0)","v":0},{"$f":"$C$62*J62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, M59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, M59>0), 1, 0)","v":0},{"$f":"$C$62*L62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, O59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, O59>0), 1, 0)","v":0},{"$f":"$C$62*N62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, Q59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, Q59>0), 1, 0)","v":0},{"$f":"$C$62*P62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, S59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, S59>0), 1, 0)","v":0},{"$f":"$C$62*R62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, U59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, U59>0), 1, 0)","v":0},{"$f":"$C$62*T62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, W59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, W59>0), 1, 0)","v":0},{"$f":"$C$62*V62","v":0},{"$f":"IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$8, Y59>0), 0, 0)+IF(AND('STUDY DETAILS'!$C$11='DATA-DO NOT DELETE'!$L$9, Y59>0), 1, 0)","v":0},{"$f":"$C$62*X62","v":0},null,{"$f":"SUMPRODUCT(D62:Z62*MOD(COLUMN(D62:Z62)-COLUMN(E62)+1,2))","v":0}]
["CTU-NOR-102","CTU Norris Breakfast ",10,null,{"$f":"$C$63*D63","v":0},null,{"$f":"$C$63*F63","v":0},null,{"$f":"$C$63*H63","v":0},null,{"$f":"$C$63*J63","v":0},null,{"$f":"$C$63*L63","v":0},null,{"$f":"$C$63*N63","v":0},null,{"$f":"$C$63*P63","v":0},null,{"$f":"$C$63*R63","v":0},null,{"$f":"$C$63*T63","v":0},null,{"$f":"$C$63*V63","v":0},null,{"$f":"$C$63*X63","v":0},null,{"$f":"SUMPRODUCT(D63:Z63*MOD(COLUMN(D63:Z63)-COLUMN(E63)+1,2))","v":0}]
["CTU-NOR-103","CTU Norris Box Lunch",7.5,null,{"$f":"$C$64*D64","v":0},null,{"$f":"$C$64*F64","v":0},null,{"$f":"$C$64*H64","v":0},null,{"$f":"$C$64*J64","v":0},null,{"$f":"$C$64*L64","v":0},null,{"$f":"$C$64*N64","v":0},null,{"$f":"$C$64*P64","v":0},null,{"$f":"$C$64*R64","v":0},null,{"$f":"$C$64*T64","v":0},null,{"$f":"$C$64*V64","v":0},null,{"$f":"$C$64*X64","v":0},null,{"$f":"SUMPRODUCT(D64:Z64*MOD(COLUMN(D64:Z64)-COLUMN(E64)+1,2))","v":0}]
["CTU-NOR-104","CTU Norris Dinner",15,null,{"$f":"$C$66*D65","v":0},null,{"$f":"$C$66*F65","v":0},null,{"$f":"$C$66*H65","v":0},null,{"$f":"$C$66*J65","v":0},null,{"$f":"$C$66*L65","v":0},null,{"$f":"$C$66*N65","v":0},null,{"$f":"$C$66*P65","v":0},null,{"$f":"$C$66*R65","v":0},null,{"$f":"$C$66*T65","v":0},null,{"$f":"$C$66*V65","v":0},null,{"$f":"$C$66*X65","v":0},null,{"$f":"SUMPRODUCT(D65:Z65*MOD(COLUMN(D65:Z65)-COLUMN(E65)+1,2))","v":0}]
["CTU-NOR-105","CTU Norris Lunch",10,null,{"$f":"$C$66*D66","v":0},null,{"$f":"$C$66*F66","v":0},null,{"$f":"$C$66*H66","v":0},null,{"$f":"$C$66*J66","v":0},null,{"$f":"$C$66*L66","v":0},null,{"$f":"$C$66*N66","v":0},null,{"$f":"$C$66*P66","v":0},null,{"$f":"$C$66*R66","v":0},null,{"$f":"$C$66*T66","v":0},null,{"$f":"$C$66*V66","v":0},null,{"$f":"$C$66*X66","v":0},null,{"$f":"SUMPRODUCT(D66:Z66*MOD(COLUMN(D66:Z66)-COLUMN(E66)+1,2))","v":0}]
[]
["TOTAL NORRIS COST PER PARTICIPANT",null,null,null,{"$f":"SUM(E62:E66)","v":0},null,{"$f":"SUM(G62:G66)","v":0},null,{"$f":"SUM(I62:I66)","v":0},null,{"$f":"SUM(K62:K66)","v":0},null,{"$f":"SUM(M62:M66)","v":0},null,{"$f":"SUM(O62:O66)","v":0},null,{"$f":"SUM(Q62:Q66)","v":0},null,{"$f":"SUM(S62:S66)","v":0},null,{"$f":"SUM(U62:U66)","v":0},null,{"$f":"SUM(W62:W66)","v":0},null,{"$f":"SUM(Y62:Y66)","v":0},null,{"$f":"SUM(AA62:AA66)","v":0}]
[]
[]
["TOTAL CTU + NORRIS COST PER PARTICIPANT",null,null,null,{"$f":"E59+E68","v":0},null,{"$f":"G59+G68","v":0},null,{"$f":"I59+I68","v":0},null,{"$f":"K59+K68","v":0},null,{"$f":"M59+M68","v":0},null,{"$f":"O59+O68","v":0},null,{"$f":"Q59+Q68","v":0},null,{"$f":"S59+S68","v":0},null,{"$f":"U59+U68","v":0},null,{"$f":"W59+W68","v":0},null,{"$f":"Y59+Y68","v":0},null,{"$f":"AA59+AA68","v":0}]
[]
[]
[null,"START UP-FEE",null,{"$f":"IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K2, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L9,'STUDY DETAILS'!C13='DATA-DO NOT DELETE'!L13), 'DATA-DO NOT DELETE'!L2, 0)+IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K2, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L8,'STUDY DETAILS'!C13='DATA-DO NOT DELETE'!L13), 'DATA-DO NOT DELETE'!L4, 0)+IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K2, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L9,'STUDY DETAILS'!C13='DATA-DO NOT DELETE'!L12), 'DATA-DO NOT DELETE'!L5, 0)+IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K2, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L8,'STUDY DETAILS'!C13='DATA-DO NOT DELETE'!L12), 'DATA-DO NOT DELETE'!L5, 0)+IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K3, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L9), 'DATA-DO NOT DELETE'!L3, 0)+IF(AND('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K3, 'STUDY DETAILS'!C11='DATA-DO NOT DELETE'!L8), 'DATA-DO NOT DELETE'!L3, 0)","v":0}]
[]
[null,"Cost per Participant",null,{"$f":"AA71","v":0}]
[null,"Number of Participants",null,1]
[null,"TOTAL PARTICIPANT COSTS",null,{"$f":"D76*D77","v":0}]
[]
[null,"CTU NON-INDUSTRY SUBSIDY",null,{"$f":"IF('STUDY DETAILS'!C10='DATA-DO NOT DELETE'!K3,-AA59*0.25*D77,AA59*0)","v":0}]
[]
[null,"TOTAL STUDY COSTS",null,{"$f":"D78+D80","v":0}]

{"sheet":"DATA-DO NOT DELETE","index":2,"n_rows":60,"n_cols":19,"rows_kept":60,"cut":false,"hidden":true,"merged":[]}
["Qty",null,"Frequency","Price",null,null,null,null,null,null,"Type of Study",null,null,"Frequency","Price",null,null,null,"Department Name"]
[1,1,0,0,0,0,null,null,null,null,"Industry",2350,null,0,0,0,null,null,"Anesthesiology"]
[2,2,30,36,{"$f":"ROUND(D3,0)","v":36},54,{"$f":"ROUND(F3,0)","v":54},58,{"$f":"ROUND(H3,0)","v":58},null,"Non-Industry",0,null,30,72,{"$f":"ROUND(O3,0)","v":72},null,null,"Biochemistry & Molecular Medicine"]
[3,3,60,{"$f":"$D$3*A3","v":72},{"$f":"ROUND(D4,0)","v":72},{"$f":"$F$3*A3","v":108},{"$f":"ROUND(F4,0)","v":108},{"$f":"$H$3*A3","v":116},{"$f":"ROUND(H4,0)","v":116},null,"Industry Lab Only",250,null,60,{"$f":"$O$3*A3","v":144},{"$f":"ROUND(O4,0)","v":144},null,null,"Cancer Center"]
[4,4,90,{"$f":"$D$3*A4","v":108},108,{"$f":"$F$3*A4","v":162},162,{"$f":"$H$3*A4","v":174},174,null,"Industry Amend",0,null,90,{"$f":"$O$3*A4","v":216},216,null,null,"Cardiothoracic Surgery"]
[5,5,120,144,144,{"$f":"$F$3*A5","v":216},216,{"$f":"$H$3*A5","v":232},232,null,null,null,null,120,{"$f":"$O$3*A5","v":288},288,null,null,"Cell & Neurobiology"]
[6,6,150,180,180,270,270,{"$f":"$H$3*A6","v":290},290,null,null,null,null,150,360,360,null,null,"Center for Genetic Epidemiology"]
[7,7,180,216,216,324,324,{"$f":"$H$3*A7","v":348},348,null,"Lab Only:","Yes",null,180,432,432,null,null,"Center for Stem Cell and Regenerative Medicine"]
[8,8,210,252,252,378,378,406,406,null,"Lab Only:","No",null,210,504,504,null,null,"Colorectal Surgery"]
[9,9,240,288,288,432,432,464,464,null,null,null,null,240,576,576,null,null,"Dentistry"]
[10,10,270,324,324,486,486,522,522,null,null,null,null,270,648,648,null,null,"Dermatology"]
[11,11,300,360,360,540,540,580,580,null,"Amendment","Yes",null,300,720,720,null,null,"Dornsife"]
[12,12,330,396,396,594,594,638,638,null,"Amendment","No",null,330,792,792,null,null,"Emergency Medicine"]
[13,13,360,432,432,648,648,696,696,null,null,null,null,360,864,864,null,null,"Emergency Medicine - Global Emergency Medicine"]
[14,14,390,468,468,702,702,754,754,null,null,null,null,390,936,936,null,null,"Emergency Medicine - Pediatric Emergency Medicine"]
[15,15,420,{"$f":"$D$3*A15","v":504},504,756,756,812,812,null,null,null,null,420,1008,1008,null,null,"Emergency Medicine - Toxicology"]
[16,16,450,540,540,810,810,870,870,null,null,null,null,450,1080,1080,null,null,"Family Medicine"]
[17,17,480,576,576,864,864,928,928,null,null,null,null,480,1152,1152,null,null,"Gerontology"]
[18,18,510,612,612,918,918,986,986,null,null,null,null,510,1224,1224,null,null,"Institute for Genetic Medicine"]
[19,19,540,648,648,972,972,1044,1044,null,null,null,null,540,1296,1296,null,null,"Integrative Anatomical Sciences"]
[20,20,570,684,684,1026,1026,1102,1102,null,null,null,null,570,1368,1368,null,null,"Medicine - Cardiovascular Medicine"]
[21,21,600,720,720,1080,1080,1160,1160,null,null,null,null,600,1440,1440,null,null,"Medicine - Endocrinology & Diabetes"]
[null,22,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Gastrointestinal and Liver Diseases"]
[null,23,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Geriatric, Hospital, Palliative and General Internal Medicine"]
[null,24,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Hematology"]
[null,25,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Infectious Diseases"]
[null,26,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Nephrology and Hypertension"]
[null,27,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Oncology"]
[null,28,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Pulmonary, Critical Care and Sleep Medicine"]
[null,29,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Medicine - Rheumatology"]
[null,30,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Molecular Microbiology and Immunology"]
[null,31,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neuroimaging and Informatics Insitute"]
[null,32,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neurological Surgery"]
[null,33,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Neurology"]
[null,34,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Obstetrics/Gynecology"]
[null,35,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Occupational Therapy"]
[null,36,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Ophthalmology"]
[null,37,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orthopaedics"]
[null,38,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Otolaryngology"]
[null,39,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pathology"]
[null,40,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pediatrics - CHLA"]
[null,41,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pediatrics - LAC"]
[null,42,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pediatrics - LAC - MCA"]
[null,43,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pharmacy"]
[null,44,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physical Therapy"]
[null,45,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Physiology and Biophysics"]
[null,46,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Bioinformatics"]
[null,47,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Biostatistics"]
[null,48,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Cancer Epidemiology & Genetics"]
[null,49,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Disease Prevention & Global Health"]
[null,50,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Environmental Health"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Preventive Medicine - Health Behavior Research"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Psychiatry"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiation Oncology"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Radiology"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Work"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Surgery"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Urology"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Zilkha Neurogenetic Institute"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Other"]