{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Raine Study In-kind Calculator","Other measures"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":2,"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":"Raine Study In-kind Calculator","index":0,"n_rows":49,"n_cols":8,"rows_kept":49,"cut":false,"hidden":false,"merged":[[48,2,48,6],[4,2,5,2],[4,4,5,4],[4,7,5,7],[4,5,5,6],[4,3,5,3],[42,2,42,7],[15,2,15,7]]}
[]
[]
[]
[]
[null,null,"In-kind Calculator","Enter number of Participants (to pre-fill): \n\nOr enter in column \"Quantity\" individually",1000,"TOTAL IN-KIND AMOUNT:","TOTAL IN-KIND AMOUNT:",{"$f":"H49","v":1392600}]
[null,null,null,null,"Rate per Unit","Quantity (eg No of people, No of attendees, equipment space)","Number of  visits ","Total in kind input"]
[null,null,"Core Activity / Measure","Additional details","Rate per Unit","Quantity (participants, items)","Number of  visits ","Totals"]
[null,null,"RECRUITMENT, CONSENT, PARTICIPANT MANAGEMENT, END OF APPT",null,116.00999999999999,{"$f":"$E$5","v":1000},1,{"$f":"F8*E8*G8","v":116009.99999999999}]
[null,null,"QUESTIONNAIRE incl Medical & Food Frequency ",null,36,1000,1,36000]
[null,null,"ANTHROPOMETRIC","Height, Weight, Waist, Hips ",14.399999999999999,1000,1,14399.999999999998]
[null,null,"BLOOD PRESSURES","6x",27.75,1000,1,27750]
[null,null,"BODY COMPOSITION SCAN whole body","eg DEXA",125.5,1000,1,125500]
[null,null,"ACTVITY MONITORING","eg actigraphy",62.28,1000,1,62280]
[null,null,"COGNITIVE ASSESSMENT - Generation 2 (~33yo)",null,27.75,1000,1,27750]
[null,null,"COGNITIVE ASSESSMENT - Generation 1 (~60 yo)",null,80,1000,1,{"$f":"F15*E15*G15","v":80000}]
[null,null,"BLOOD & URINE"]
[null,null,"Blood sample phlebotomy & processing","This option must be selected if any blood results are selected",91.12,1000,1,{"$f":"F17*E17*G17","v":91120}]
[null,null,"Full Blood Count ",null,28.82,1000,1,{"$f":"F18*E18*G18","v":28820}]
[null,null,"Insulin ",null,51.85,1000,1,51850]
[null,null,"Glucose ",null,16.489999999999998,1000,1,16490]
[null,null,"HbA1c",null,45.05,1000,1,45050]
[null,null,"Cholesterol; HDL; Triglycerides, Calc-LDL",null,38.590000000000003,1000,1,38590]
[null,null,"Lipoprotein A ",null,66,1000,1,66000]
[null,null,"Calcium ",null,19.809999999999999,1000,1,19810]
[null,null,"hs-CRP ",null,16.489999999999998,1000,1,16490]
[null,null,"Uric Acid ",null,19.809999999999999,1000,1,19810]
[null,null,"eGFR ",null,30.09,1000,1,30090]
[null,null,"Alanine aminotransferase ALT ","Liver function panel / proteins",16.489999999999998,1000,1,16490]
[null,null,"Alkaline phosphatase ALP ","Liver function panel / proteins",16.489999999999998,1000,1,16490]
[null,null,"Aspartate aminotransferase AST ","Liver function panel / proteins",16.489999999999998,1000,1,16490]
[null,null,"Gamma-glutamyl transpeptidase GGT ","Liver function panel / proteins",16.489999999999998,1000,1,16490]
[null,null," Albumin ALB ","Liver function panel / proteins",16.489999999999998,1000,1,16490]
[null,null,"Total Bilirubin BIL","Liver function panel / proteins",11.65,1000,1,11650]
[null,null,"Total Proteins, Calc-Globulins ","Liver function panel / proteins",95.97,1000,1,95970]
[null,null,"Iron, Ferritin, Transferrin, Transferrin Saturation %","Iron studies",55.34,1000,1,55340]
[null,null,"FTSH, FT4, FT3, ","Thyroid funciton test",50,1000,1,50000]
[null,null,"TPO","Thyroid funciton test",80.67,1000,1,80670]
[null,null,"Fatty Acids: Red Blood Cell pellets / EDTA ","Fatty Acids",60,1000,1,60000]
[]
[null,null,"Urine sample collection","This option must be selected if urineresults are selected",10,1000,1,{"$f":"F40*E40*G40","v":10000}]
[null,null,"Sodium, Potassium, Creatinine, Bicarbonate, Urea","Spot Urine sample: U+E Electrolytes, Urea, Creatinine",23.21,1000,1,23210]
[]
[null,null,"EQUIPMENT"]
[null,null,"Blood Pressure machine","1 per 1000 pts",2000,1,null,{"$f":"F44*E44","v":2000}]
[null,null,"Anthropometric equipment & supplies","1 per 1000 pts",4500,1,null,{"$f":"F45*E45","v":4500}]
[null,null,"COGNITIVE ASSESSMENT Gen 1 ","1x per generation",1500,{"$f":"IF(H13>0,1,IF(H13<1,0))","v":1},null,{"$f":"F46*E46","v":1500}]
[null,null,"COGNITIVE ASSESSMENT Gen 2 ","1x per generation",1500,{"$f":"IF(H14>0,1,IF(H14<1,0))","v":1},null,{"$f":"F47*E47","v":1500}]
[]
[null,null,"TOTAL IN-KIND AMOUNT:",null,null,null,null,{"$f":"SUM(H8:H47)","v":1392600}]

{"sheet":"Other measures","index":1,"n_rows":37,"n_cols":8,"rows_kept":37,"cut":false,"hidden":false,"merged":[[4,7,5,7],[36,2,36,6],[4,2,5,2],[4,3,5,3],[4,4,5,4],[4,5,5,6]]}
[]
[]
[]
[]
[null,null,"Researcher A","Enter Participant Number here: \nOr enter in column Quantity individually",0,"Total Amount for In-kind plus other","TOTAL IN-KIND AMOUNT:",{"$f":"'Raine Study In-kind Calculator'!H49+H37","v":1392600}]
[null,null,null,null,"Rate per Unit","Quantity (eg No of people, No of attendees, equipment space)","Number of  visits ","Total in kind input"]
[null,null,"Activity / Measure","Additional details","Rate per Unit","Quantity (participants, items)","Number of  visits ","Totals"]
[null,null,"Other activity / measure",null,0,{"$f":"$E$5","v":0},1,{"$f":"F8*E8*G8","v":0}]
[null,null,"Other activity / measure",null,0,{"$f":"$E$5","v":0},1,0]
[null,null,"Other activity / measure",null,0,0,1,0]
[null,null,"Other activity / measure",null,0,0,1,0]
[null,null,"Other activity / measure",null,0,0,1,0]
[null,null,"Other activity / measure",null,0,0,1,0]
[null,null,"Other activity / measure",null,0,0,1,0]
[null,null,null,null,0,0,1,{"$f":"F15*E15*G15","v":0}]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,null,null,0,0,1,0]
[null,null,"EQUIPMENT"]
[null,null,"EQUIPMENT 1",null,null,1,null,{"$f":"F32*E32","v":0}]
[null,null,"EQUIPMENT 2",null,null,1,null,{"$f":"F33*E33","v":0}]
[null,null,"EQUIPMENT 3",null,null,1,null,{"$f":"F34*E34","v":0}]
[null,null,"EQUIPMENT 4",null,null,1,null,{"$f":"F35*E35","v":0}]
[]
[null,null,"Total Cost of Other Measures",null,null,null,null,{"$f":"SUM(H8:H35)","v":0}]