{"text_format":"3","workbook":"xls","n_sheets":1,"sheets":["PAF Partitioning Demo Table"],"not_rendered":{"external_links":1,"comments":28},"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"PAF Partitioning Demo Table","index":0,"n_rows":81,"n_cols":10,"rows_kept":81,"merged":[[0,0,0,9],[1,0,1,9],[2,0,2,9],[3,0,3,9],[4,0,4,9],[5,0,5,9],[7,1,7,5],[7,6,7,7],[8,1,8,5],[8,6,8,7],[10,1,10,5],[10,6,10,7],[11,1,11,5],[11,6,11,7],[12,1,12,5],[12,6,12,7],[14,1,14,5],[14,6,14,7],[15,1,15,5],[15,6,15,7],[16,1,16,5],[16,6,16,7],[19,0,19,9],[30,0,30,9],[31,1,31,5],[32,1,32,5],[33,1,33,5],[34,1,34,5],[35,1,35,5],[38,0,38,9]],"flags":["formulas_cached_only"]}
["SAMPLE PARTITIONED PAF CALCULATION TABLE"]
["Instructions: Labels and counts must be entered into YELLOW HIGHLIGHTED cells.  All other cells"]
["are calculated based on this information.  To avoid accidental errors, these calculated cells are"]
["locked.  Additional information is provided in comments (flagged by red triangles in the upper-right "]
["corner of cells).   Colored arrows highlight connections between calculated values and the summary"]
["table."]
[]
[null,"Label for those who have the Negative Outcome",{"$nulls":4},"MMR"]
[null,"Label for those without the Negative Outcome",{"$nulls":4},"Not MMR"]
[]
[null,"Label for the First Risk Factor",{"$nulls":4},"Risk Factor A"]
[null,"Label for those who have the First Risk Factor",{"$nulls":4},"A"]
[null,"Label for those who do not have the First Risk Factor",{"$nulls":4},"Not A"]
[]
[null,"Label for the Second Risk Factor",{"$nulls":4},"Risk Factor B"]
[null,"Label for those who have the First Risk Factor",{"$nulls":4},"B"]
[null,"Label for those who do not have the First Risk Factor",{"$nulls":4},"Not B"]
[]
[]
["ORIGINAL UNADJUSTED RAW DATA"]
[]
[null,"Risk Factor A","Risk Factor B","MMR","Not MMR","Total","pe","p","RR","Stratified PAF"]
[null,"A","B",15,485,500,{"v":0.15384615384615385,"d":"0.154"},{"v":0.03,"d":"0.030"},{"v":3,"d":"3.000"},{"v":0.15384615384615385,"d":"15.38%"}]
[null,"A","Not B",20,980,1000,{"v":0.3076923076923077,"d":"0.308"},{"v":0.02,"d":"0.020"},{"v":2,"d":"2.000"},{"v":0.15384615384615385,"d":"15.38%"}]
[null,"Not A","B",20,730,750,{"v":0.23076923076923078,"d":"0.231"},{"v":0.02666666666666667,"d":"0.027"},{"v":2.666666666666667,"d":"2.667"},{"v":0.19230769230769235,"d":"19.23%"}]
[null,"Not A","Not B",10,990,1000,{"v":0.3076923076923077,"d":"0.308"},{"v":0.01,"d":"0.010"}]
[null,null,"Total",65,3185,3250,{"v":1,"d":"1.000"},null,null,{"v":0.5,"d":"50.00%"}]
[{"$nulls":8},"PAFAGG"]
[]
[]
["Summary of Interaction Effect"]
[null,"RR(Risk Factor B | Risk Factor A) = ",{"$nulls":4},{"v":0.7777777777777778,"d":"0.778"}]
[null,"E(RR) for group with both risk factors:",{"$nulls":4},{"v":3.666666666666667,"d":"3.667"}]
[null,"E(N) for group with both risk factors if no interaction:",{"$nulls":4},{"v":18.333333333333336,"d":"18.333"}]
[null,"Difference between E(N) and observed N:",{"$nulls":4},{"v":3.3333333333333357,"d":"3.333"}]
[null,"Difference adjusted for confounding between risk factors:",{"$nulls":4},{"v":4.285714285714288,"d":"4.286"}]
[]
[]
["Summary Table of Sequential PAFs"]
[{"$nulls":3},"PAF for Risk Factor A",{"v":0.14285714285714288,"d":"14.29%"}]
[{"$nulls":3},"PAF for Risk Factor B",{"v":0.29120879120879123,"d":"29.12%"}]
[{"$nulls":3},"PAF for the Intaction",{"v":0.06593406593406598,"d":"6.59%"},"  ……. or ……. 4.286 cases"]
[{"$nulls":3},"TOTAL",{"v":0.5,"d":"50.00%"}]
[]
[]
[]
[null,"Unadjusted PAF for Risk Factor A"]
[null,"Risk Factor A","MMR","Not MMR","Total","pe","p","RR","PAF"]
[null,"A",35,1465,1500,{"v":0.46153846153846156,"d":"0.462"},{"v":0.023333333333333334,"d":"0.023"},{"v":1.3611111111111112,"d":"1.361"},{"v":0.14285714285714288,"d":"14.29%"}]
[null,"Not A",30,1720,1750,{"v":0.5384615384615384,"d":"0.538"},{"v":0.017142857142857144,"d":"0.017"}]
[null,"Total",65,3185,3250]
[]
[]
[]
[]
[]
[null,"Predicting B based upon level of A"]
[{"$nulls":3},"B","Not B","Total","p","RR"]
[null,null,"A",500,1000,1500,{"v":0.3333333333333333,"d":"0.333"},{"v":0.7777777777777778,"d":"0.778"}]
[null,null,"Not A",750,1000,1750,{"v":0.42857142857142855,"d":"0.429"}]
[null,null,"Total",1250,2000,3250]
[]
[]
[]
[null,"Remove effect of Risk Factor A status on Risk Factor B"]
[null,"Risk Factor A","Risk Factor B","MMR","Not MMR","Total"]
[null,"A","B",{"v":19.285714285714285,"d":"19.286"},{"v":623.5714285714286,"d":"623.571"},{"v":642.8571428571429,"d":"642.857"}]
[null,"A","Not B",{"v":17.142857142857142,"d":"17.143"},{"v":840,"d":"840.000"},{"v":857.1428571428571,"d":"857.143"}]
[null,"Not A","B",20,730,750]
[null,"Not A","Not B",10,990,1000]
[null,null,"Total",{"v":66.42857142857143,"d":"66.429"},{"v":3183.5714285714284,"d":"3183.571"},{"v":3250,"d":"3250.000"}]
[]
[]
[]
[null,"Risk Factor B adjusted for Risk Factor A"]
[null,null,"Risk Factor B","MMR","Not MMR","Total","p"]
[null,null,"B",{"v":39.285714285714285,"d":"39.286"},{"v":1353.5714285714284,"d":"1353.571"},{"v":1392.8571428571427,"d":"1392.857"},{"v":0.02820512820512821,"d":"0.028"}]
[null,null,"Not B",{"v":27.142857142857142,"d":"27.143"},{"v":1830,"d":"1830.000"},{"v":1857.142857142857,"d":"1857.143"},{"v":0.014615384615384615,"d":"0.015"}]
[null,null,"Total",{"v":66.42857142857143,"d":"66.429"},{"v":3183.5714285714284,"d":"3183.571"},3250]
[]
[null,null,"Adjusted PAF",{"v":0.29120879120879123,"d":"29.12%"}]