{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Study info"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Study info","index":0,"n_rows":41,"n_cols":27,"rows_kept":41,"cut":false,"hidden":false,"merged":[[35,0,36,2],[18,1,26,3],[7,13,7,15],[8,13,8,15],[24,4,41,4],[0,4,19,4],[23,5,23,10],[40,8,40,9],[11,5,11,6],[2,8,2,10],[3,8,3,10],[4,8,4,10],[5,8,5,10],[34,0,34,2],[33,0,33,2],[0,0,17,0],[5,1,5,3],[0,1,0,3],[0,13,0,16],[2,13,2,15],[3,13,3,15],[4,13,4,15],[5,13,5,16],[10,8,10,10],[11,8,11,10],[12,8,12,10],[0,8,0,11],[15,8,15,10],[16,8,16,10],[8,8,8,11],[0,5,0,6]]}
["Step 1","Basic Study Info",null,null,"Step 2","Random Prompts",null,null,"Bursting",null,null,null,null,"Weekly Survey",null,null,null,null,null,null,null,null,null,null,null,"Random Promtps",true]
[null,"Number of participants",null,null,null,"Basic info",null,null,{"$f":"IF($AA$6=TRUE,\"Basic info\",\"\")","v":""},null,null,null,null,"Basic info",null,null,null,null,null,null,null,null,null,null,null,"Interval Prompts",true]
[null,"Number of days",null,null,null,{"$f":"IF($AA$1=TRUE,\"Number of random EMA prompts per day\",\"\")","v":"Number of random EMA prompts per day"},null,null,{"$f":"IF($AA$6=TRUE,\"Number of days per week with bursting\",\"\")","v":""},null,null,null,null,{"$f":"IF($AA$4=TRUE,\"Payment per week\",\"\")","v":"Payment per week"},null,null,null,null,null,null,null,null,null,null,null,"Wearable",true]
[null,null,null,null,null,{"$f":"IF($AA$1=TRUE,\"Compensation per prompt\",\"\")","v":"Compensation per prompt"},null,null,{"$f":"IF($AA$6=TRUE,\"Number of periods on burst days\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly surveys",true]
[null,null,null,null,null,null,null,null,{"$f":"IF($AA$6=TRUE,\"Number of prompts per burst\",\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Follow-ups",true]
[null,"Study options",null,null,null,"Bonuses",null,null,{"$f":"IF($AA$6=TRUE,\"Compensation per prompt\",\"\")","v":""},null,null,null,null,"Follow-up surveys",null,null,null,null,null,null,null,null,null,null,null,"Bursting",false]
[null,null,null,null,null,{"$f":"IF($AA$1=TRUE,\"Reinforcement Schedule\",\"\")","v":"Reinforcement Schedule"},null,null,null,null,null,null,null,"Basic info"]
[null,null,null,null,null,{"$f":"IF($AA$1=TRUE,\"Bonus amount\",\"\")","v":"Bonus amount"},null,null,null,null,null,null,null,{"$f":"IF(AA5=TRUE,\"Number of follow-up surveys\",\"\")","v":"Number of follow-up surveys"}]
[null,null,null,null,null,{"$f":"IF($AA$1=TRUE,\"# of responses per day for bonus\",\"\")","v":"# of responses per day for bonus"},null,null,"Wearable Monitor",null,null,null,null,{"$f":"IF(AA5=TRUE,\"Compensation per survey\",\"\")","v":"Compensation per survey"},null,null,null,null,null,null,null,null,null,null,null,"Daily"]
[null,null,null,null,null,{"$f":"IF($AA$1=TRUE,IF(G7=\"Weekly\",\"# days per week to get bonus\",\"\"),\"\")","v":""},null,null,{"$f":"IF($AA$3=TRUE,\"Basic info\",\"\")","v":"Basic info"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Weekly"]
[null,null,null,null,null,null,null,null,{"$f":"IF($AA$3=TRUE,\"Compensation per day\",\"\")","v":"Compensation per day"}]
[null,null,null,null,null,"Interval Prompts",null,null,{"$f":"IF($AA$3=TRUE,\"Minimum hours per day to get paid?\",\"\")","v":"Minimum hours per day to get paid?"}]
[null,null,null,null,null,"Basic info",null,null,{"$f":"IF($AA$3=TRUE,IF(L12=\"Yes\",\"Minimum hours per day\",\"\"),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[null,null,null,null,null,{"$f":"IF($AA$2=TRUE,\"Number of interval prompts per day\",\"\")","v":"Number of interval prompts per day"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[null,null,null,null,null,{"$f":"IF($AA$2=TRUE,\"Compensation per prompt\",\"\")","v":"Compensation per prompt"},null,null,{"$f":"IF($AA$3=TRUE,\"Bonuses (Weekly)\",\"\")","v":"Bonuses (Weekly)"},null,null,null,{"$f":"IF($AA$3=TRUE,\"<- Select yes or no here\",\"\")","v":"<- Select yes or no here"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($AA$3=TRUE,\"Payment\",\"\")","v":"Payment"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($AA$3=TRUE,\"Minimum hours per day, enter 0 for none\",\"\")","v":"Minimum hours per day, enter 0 for none"}]
[null,null,null,null,null,null,null,null,{"$f":"IF($AA$3=TRUE,\"Minimum days per week\",\"\")","v":"Minimum days per week"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Completing \",G9,\"+ assessments/day\")","v":"Completing + assessments/day"}]
[null,"Instructions: Step 1: Enter the basic study info and select the study options. Rolling your mouse over each option will give you more detials. Step 2: Enter the required information. If a section is blank, it is because you did not select that option in step 1. Step 3: Review compensation schedule. You can copy and paste this section into an IRB, grant, etc. and remove any blank rows (which reflect options you did not select). ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Completing \",G9,\"+ assessments \",G10,\"+ days/week\")","v":"Completing + assessments + days/week"}]
[]
[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":"CONCATENATE(\"Wearing wearable monitor for \",L13,\" hours per day\")","v":"Wearing wearable monitor for  hours per day"}]
[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":"CONCATENATE(\"Wearing monitor for \",L17,\" hrs/day, \",L18,\"days/wk\")","v":"Wearing monitor for  hrs/day, days/wk"}]
[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":"CONCATENATE(\"Wearing monitor for \",L18,\" days/wk\")","v":"Wearing monitor for  days/wk"}]
[null,null,null,null,null,"Study Payment"]
[null,null,null,null,"Step 3","Item","Compensation","Frequency","Weekly $ per participant","Total $ per participant","TOTAL FOR STUDY"]
[null,null,null,null,null,{"$f":"IF(AA1=TRUE,\"Completing each EMA prompt\",\"\")","v":"Completing each EMA prompt"},{"$f":"IF(AA1=TRUE,G4,\"\")","v":0},{"$f":"IF(AA1=TRUE,CONCATENATE(G3,\"x/day\"),\"\")","v":"x/day"},{"$f":"IF(AA1=TRUE,G26*G3*(7),\"\")","v":0},{"$f":"IF(AA1=TRUE,I26*($C$3/7),\"\")","v":0},{"$f":"IF(AA1=TRUE,J26*$C$2,\"\")","v":0}]
[null,null,null,null,null,{"$f":"IF(AA2=TRUE,\"Completing each interval prompt\",\"\")","v":"Completing each interval prompt"},{"$f":"IF(AA2=TRUE,G15,\"\")","v":0},{"$f":"IF(AA2=TRUE,CONCATENATE(G14,\"x/day\"),\"\")","v":"x/day"},{"$f":"IF(AA2=TRUE,G27*G15*G14*($C$3/7),\"\")","v":0},{"$f":"IF(AA2=TRUE,I27*($C$3/7),\"\")","v":0},{"$f":"IF(AA2=TRUE,J27*$C$2,\"\")","v":0}]
[null,null,null,null,null,{"$f":"IF(AA6=TRUE,\"Completing each burst survey\",\"\")","v":""},{"$f":"IF(AA6=TRUE,L6,\"\")","v":""},{"$f":"IF(AA6=FALSE,\"\",CONCATENATE(L5*L4,\"x/day, \",L3,\"x/week\"))","v":""},{"$f":"IF(AA6=TRUE,L6*L5*L4*L3,\"\")","v":""},{"$f":"IF(AA6=TRUE,I28*(C3/4),\"\")","v":""},{"$f":"IF(AA6=TRUE,J28*$C$2,\"\")","v":""}]
[null,null,null,null,null,{"$f":"IF(AA3=TRUE,IF(L12=\"Yes\",Z21,\"Wearing wearable monitor\"),\"\")","v":"Wearing wearable monitor"},{"$f":"IF(AA3=TRUE,L11,\"\")","v":0},{"$f":"IF(AA3=TRUE,\"1x/day\",\"\")","v":"1x/day"},{"$f":"IF(AA3=TRUE,G29*7,\"\")","v":0},{"$f":"IF(AA3=TRUE,I29*(C3/7),\"\")","v":0},{"$f":"IF(AA3=TRUE,J29*$C$2,\"\")","v":0}]
[null,null,null,null,null,{"$f":"IF(AA4=TRUE,\"Completing weekly survey\",\"\")","v":"Completing weekly survey"},{"$f":"IF(F30=\"\",\"\",Q3)","v":0},{"$f":"IF(F30=\"\",\"\",\"1x/week\")","v":"1x/week"},{"$f":"IF(F30=\"\",\"\",G30)","v":0},{"$f":"IF(G30=\"\",\"\",I30*(C3/7))","v":0},{"$f":"IF(AA4=TRUE,J30*$C$2,\"\")","v":0}]
[null,null,null,null,null,{"$f":"IF(AA5=FALSE,\"\",\"Completing follow-up surveys\")","v":"Completing follow-up surveys"},{"$f":"IF(F31=\"\",\"\",Q9)","v":0},{"$f":"IF(F31=\"\",\"\",CONCATENATE(Q8,\"x/study\"))","v":"x/study"},{"$f":"IF(F31=\"\",\"\",\"N/A\")","v":"N/A"},{"$f":"IF(F31=\"\",\"\",G31*Q8)","v":0},{"$f":"IF(AA5=TRUE,J31*$C$2,\"\")","v":0}]
[null,null,null,null,null,null,null,null,null,"SUBTOTAL",{"$f":"SUM(K26:K31)","v":0}]
[]
["Last update: 12/18/2018",null,null,null,null,"Bonuses"]
["Questions?  Email evan.kleiman@rutgers.edu",null,null,null,null,{"$f":"IF(AA1=FALSE,\"\",IF(G7=\"Weekly\",Z19,Z18))","v":"Completing + assessments/day"},{"$f":"IF(AA1=FALSE,\"\",G8)","v":0},{"$f":"IF(AA1=FALSE,\"\",IF(G7=\"Weekly\",\"1x/week\",\"1x/day\"))","v":"1x/day"},{"$f":"IF(AA1=FALSE,\"\",IF(G7=\"Weekly\",G8,G8*7))","v":0},{"$f":"IF(AA1=FALSE,\"\",I35*(C3/7))","v":0},{"$f":"IF(AA1=FALSE,\"\",J35*$C$2)","v":0}]
["The latest version can always be found at https://kleimanlab.org/emapaycalc/",null,null,null,null,{"$f":"IF(AA3=TRUE,IF(L15=\"No\",\"\",IF(L17=0,Z23,Z22)),\"\")","v":"Wearing monitor for  days/wk"},{"$f":"IF(AA3=FALSE,\"\",IF(L15=\"Yes\",L16,\"\"))","v":""},{"$f":"IF(G36=\"\",\"\",\"1x/week\")","v":""},{"$f":"IF(G36=\"\",\"\",L16)","v":""},{"$f":"IF(G36=\"\",\"\",I36*(C3/7))","v":""},{"$f":"IF(G36=\"\",\"\",J36*C2)","v":""}]
[null,null,null,null,null,null,null,null,null,"SUBTOTAL",{"$f":"SUM(K35:K36)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,"TOTAL",{"$f":"K32+K37","v":0}]
[]
[null,null,null,null,null,null,null,null,"Total per participant:",null,{"$f":"SUM(J26:J38)","v":0}]