{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Intro","Non-inferiority (Proportion)","Non-inferiority (Quantitative)","Non-inferiority (Odds Ratio)","Non-inferiority (Risk ratio)","Non-inferiority (Hazard Ratio)","Equivalence (Proportion)","Equivalence (Quantitative)","Equivalence (Odds Ratio)","Equivalence (Risk Ratio)","Equivalence (Hazard Ratio)"],"not_rendered":{"charts":20,"images":1,"macros":1,"external_links":0,"defined_names":0,"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":"Intro","index":0,"n_rows":24,"n_cols":13,"rows_kept":24,"cut":false,"hidden":false,"merged":[[19,6,19,9],[23,6,23,9],[15,12,15,15],[17,12,17,15],[19,12,19,15],[23,12,23,15],[21,6,21,9],[21,12,21,15],[11,6,11,15],[13,6,13,9],[13,12,13,15],[15,6,15,9],[17,6,17,9]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Choose your calculator"]
[]
[null,null,null,null,null,null,"Non-inferiority calculator",null,null,null,null,null,"Equivalence calculator"]
[]
[null,null,null,null,null,null,"Qualitative outcome (Proportions)",null,null,null,null,null,"Qualitative outcome (Proportions)"]
[]
[null,null,null,null,null,null,"Quantitative outcome (Numerical)",null,null,null,null,null,"Quantitative outcome (Numerical)"]
[]
[null,null,null,null,null,null,"Odds Ratio",null,null,null,null,null,"Odds Ratio"]
[]
[null,null,null,null,null,null,"Risk Ratio",null,null,null,null,null,"Risk Ratio"]
[]
[null,null,null,null,null,null,"Hazard Ratio (Time to event)",null,null,null,null,null,"Hazard Ratio (Time to event)"]

{"sheet":"Non-inferiority (Proportion)","index":1,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[20,0,20,1],[20,4,20,5],[12,0,12,2],[14,0,14,6],[15,0,15,1],[15,3,16,3],[15,4,15,5],[16,0,16,1],[16,4,16,5],[12,3,12,6],[38,0,38,1],[38,2,38,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,4,36,6],[36,0,36,3],[11,0,11,6],[37,4,37,6],[37,0,37,3],[27,4,27,6],[28,4,28,6],[28,0,28,3],[27,0,27,3],[23,0,24,0],[23,3,24,3],[23,4,24,6],[23,1,24,2],[26,0,26,6],[18,0,18,6],[19,0,19,1],[19,3,20,3],[19,4,19,5]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The margin that is acceptable to be lower than the classic treatment (= New treatment - classic ttt) [The value should be in NEGATIVE]"]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Event proportion",null,null,"OR","Number of events"]
["N",null,null,null,"N"]
[]
["New Treatment"]
["Event proportion",null,null,"OR","Number of events"]
["N",null,null,null,"N"]
[]
[]
["Mean diff",{"$f":"IFERROR(IF(AND(C16>0,(C20>0)),C20-C16,((G20/G21)-(G16/G17))),\" \")","v":" "},null,"Sed",{"$f":"IFERROR(IF(AND(C16>0,(C20>0),C17>0,C21>0),SQRT(((C20*(1-C20))/C21)+((C16*(1-C16))/C17)),SQRT((((G20/G21)*(1-(G20/G21)))/G21)+(((G16/G17)*(1-(G16/G17))/G17)))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.96*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.96*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(D13)),OR(ISBLANK(G16),ISBLANK(G17),ISBLANK(G20),ISBLANK(G21),ISBLANK(D13))),\" \",IF(AND(A29<0,E29<0),\"Significantly inferior\",IF(AND(A29>0,E29>0),\"Significantly superior\",IF(AND(A29<0,E29>0,A29<D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A29<0,E29>0,A29>D13),\"Non inferior\",)))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.65*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.65*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(D13)),OR(ISBLANK(G16),ISBLANK(G17),ISBLANK(G20),ISBLANK(G21),ISBLANK(D13))),\" \",IF(AND(A38<0,E38<0),\"Significantly inferior\",IF(AND(A38>0,E38>0),\"Significantly superior\",IF(AND(A38<0,E38>0,A38<D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A38<0,E38>0,A38>D13),\"Non inferior\")))))","v":" "}]

{"sheet":"Non-inferiority (Quantitative)","index":2,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,0,16,1],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,1],[18,0,18,6],[19,0,19,1],[20,0,20,1],[19,2,19,3],[20,2,20,3],[36,4,36,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[27,0,27,3],[27,4,27,6],[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[15,6,16,6],[19,6,20,6],[19,4,20,5],[15,4,16,5],[15,2,15,3],[16,2,16,3],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The margin that is acceptable to be lower than the classic treatment (= New treatment - classic ttt) [The value should be in NEGATIVE]"]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Mean",null,null,null,"N"]
["Standard deviation"]
[]
["New Treatment"]
["Mean",null,null,null,"N"]
["Standard deviation"]
[]
[]
["Mean diff",{"$f":"IF(OR(ISBLANK(C16),ISBLANK(C20)),\" \",C20-C16)","v":" "},null,"Sed",{"$f":"IFERROR(SQRT(((C17^2)/G16)+((C21^2)/G20)),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.96*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.96*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(OR(ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(D13),ISBLANK(G16),ISBLANK(G20)),\" \",IF(AND(A29<0,E29<0),\"Significantly inferior\",IF(AND(A29>0,E29>0),\"Significantly superior\",IF(AND(A29<0,E29>0,A29<D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A29<0,E29>0,A29>D13),\"Non inferior\",)))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.65*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.65*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(D13)),OR(ISBLANK(G16),ISBLANK(G17),ISBLANK(G20),ISBLANK(G21),ISBLANK(D13))),\" \",IF(AND(A38<0,E38<0),\"Significantly inferior\",IF(AND(A38>0,E38>0),\"Significantly superior\",IF(AND(A38<0,E38>0,A38<D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A38<0,E38>0,A38>D13),\"Non inferior\")))))","v":" "}]

{"sheet":"Non-inferiority (Odds Ratio)","index":3,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[15,4,15,6],[15,0,15,3],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[27,0,27,3],[27,4,27,6],[18,0,18,6],[19,0,19,3],[20,0,20,3],[19,4,19,6],[20,4,20,6],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[16,0,16,3],[16,4,16,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Number of events"]
["N"]
[]
["New Treatment"]
["Number of events"]
["N"]
[]
[]
["Odds Ratio",{"$f":"IFERROR((E20*(E17-E16))/(E16*(E21-E20)),\" \")","v":" "},null,"Se(log(or))",{"$f":"IFERROR(SQRT((1/E16)+(1/(E17-E16))+(1/E20)+(1/(E21-E20))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29<1,E29<1),\"Significantly inferior\",IF(AND(A29>1,E29>1),\"Significantly superior\",IF(AND(E20>E16,A29<1,E29>1,E29>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(E20>E16,A29<1,E29>1,E29<D13),\"Non inferior\",IF(AND(E16>E20,A29<1,E29>1,A29>D13),\"Non inferior\",IF(AND(E16>E20,A29<1,E29>1,A29>D13),\"not non-inferior (bypassed NIF limit)\")))))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38<1,E38<1),\"Significantly inferior\",IF(AND(A38>1,E38>1),\"Significantly superior\",IF(AND(E20>E16,A38<1,E38>1,E38>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(E20>E16,A38<1,E38>1,E38<D13),\"Non inferior\",IF(AND(E16>E20,A38<1,E38>1,A38>D13),\"Non inferior\",IF(AND(E16>E20,A38<1,E38>1,A38>D13),\"not non-inferior (bypassed NIF limit)\")))))))","v":" "}]

{"sheet":"Non-inferiority (Risk ratio)","index":4,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6],[27,0,27,3],[27,4,27,6],[16,0,16,3],[16,4,16,6],[18,0,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[20,4,20,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,3],[15,4,15,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Number of events"]
["N"]
[]
["New Treatment"]
["Number of events"]
["N"]
[]
[]
["Risk Ratio",{"$f":"IFERROR(((E20/E21)/(E16/E17)),\" \")","v":" "},null,"Se(log(RR))",{"$f":"IFERROR(SQRT((1/E16)+(1/(E20))-(1/E17)-(1/(E21))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29<1,E29<1),\"Significantly inferior\",IF(AND(A29>1,E29>1),\"Significantly superior\",IF(AND(E20>E16,A29<1,E29>1,E29>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(E20>E16,A29<1,E29>1,E29<D13),\"Non inferior\",IF(AND(E16>E20,A29<1,E29>1,A29>D13),\"Non inferior\",IF(AND(E16>E20,A29<1,E29>1,A29>D13),\"not non-inferior (bypassed NIF limit)\")))))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38<1,E38<1),\"Significantly inferior\",IF(AND(A38>1,E38>1),\"Significantly superior\",IF(AND(E20>E16,A38<1,E38>1,E38>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(E20>E16,A38<1,E38>1,E38<D13),\"Non inferior\",IF(AND(E16>E20,A38<1,E38>1,A38>D13),\"Non inferior\",IF(AND(E16>E20,A38<1,E38>1,A38>D13),\"not non-inferior (bypassed NIF limit)\")))))))","v":" "}]

{"sheet":"Non-inferiority (Hazard Ratio)","index":5,"n_rows":39,"n_cols":5,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,3],[15,4,15,6],[27,0,27,3],[27,4,27,6],[16,0,16,3],[16,4,16,6],[18,0,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[20,4,20,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["The new treatment will probably increase the hazard compared to the classic treatment. Thus, the non-inferiority margin would be more than 1"]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Median survival"]
["Number of events"]
[]
["New Treatment"]
["Median survival"]
["Number of events"]
[]
[]
["Hazard Ratio",{"$f":"IF(OR(ISBLANK(E16),ISBLANK(E20)),\" \",(E16/E20))","v":" "},null,"Se(log(HR))",{"$f":"IFERROR(SQRT((1/E17)+(1/E21)),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29<1,E29<1),\"Significantly inferior\",IF(AND(A29>1,E29>1),\"Significantly superior\",IF(AND(A29<1,E29>1,E29>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A29<1,E29>1,E29<D13),\"Non inferior\",)))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38<1,E38<1),\"Significantly inferior\",IF(AND(A38>1,E38>1),\"Significantly superior\",IF(AND(A38<1,E38>1,E38>D13),\"not non-inferior (bypassed NIF limit)\",IF(AND(A38<1,E38>1,E38<D13),\"Non inferior\")))))","v":" "}]

{"sheet":"Equivalence (Proportion)","index":6,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,1],[15,3,16,3],[15,4,15,5],[16,0,16,1],[16,4,16,5],[27,0,27,3],[27,4,27,6],[18,0,18,6],[19,0,19,1],[19,3,20,3],[19,4,19,5],[20,0,20,1],[20,4,20,5],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"-1*D13","v":0}]
[]
[]
[]
[]
[]
[]
["Equivalence limit"]
[]
["Classic Treatment"]
["Event proportion",null,null,"OR","Number of events"]
["N",null,null,null,"N"]
[]
["New Treatment"]
["Event proportion",null,null,"OR","Number of events"]
["N",null,null,null,"N"]
[]
[]
["Mean diff",{"$f":"IFERROR(IF(AND(C16>0,(C20>0)),C20-C16,((G20/G21)-(G16/G17))),\" \")","v":" "},null,"Sed",{"$f":"IFERROR(IF(AND(C16>0,(C20>0),C17>0,C21>0),SQRT(((C20*(1-C20))/C21)+((C16*(1-C16))/C17)),SQRT((((G20/G21)*(1-(G20/G21)))/G21)+(((G16/G17)*(1-(G16/G17))/G17)))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.96*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.96*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29>MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A29>MIN(D13,J6),E29<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.65*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.65*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38>MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A38>MIN(D13,J6),E38<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]

{"sheet":"Equivalence (Quantitative)","index":7,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[16,0,16,1],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,1],[18,0,18,6],[19,0,19,1],[20,0,20,1],[19,2,19,3],[20,2,20,3],[36,4,36,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[27,0,27,3],[27,4,27,6],[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[15,6,16,6],[15,4,16,5],[15,2,15,3],[16,2,16,3],[19,4,20,5],[19,6,20,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"-1*D13","v":0}]
[]
[]
[]
[]
[]
[]
["Equivalence limit"]
[]
["Classic Treatment"]
["Mean",null,null,null,"N"]
["Standard deviation"]
[]
["New Treatment"]
["Mean",null,null,null,"N"]
["Standard deviation"]
[]
[]
["Mean diff",{"$f":"IF(OR(ISBLANK(C16),ISBLANK(C20)),\" \",C20-C16)","v":" "},null,"Sed",{"$f":"IFERROR(SQRT(((C17^2)/G16)+((C21^2)/G20)),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.96*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.96*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(G16),ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(G20),ISBLANK(D13))),\" \",IF(AND(A29>MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A29>MIN(D13,J6),E29<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(B24-(1.65*E24),\" \")","v":" "},null,null,null,{"$f":"IFERROR(B24+(1.65*E24),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(G16),ISBLANK(C16),ISBLANK(C17),ISBLANK(C20),ISBLANK(C21),ISBLANK(G20),ISBLANK(D13))),\" \",IF(AND(A38>MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A38>MIN(D13,J6),E38<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]

{"sheet":"Equivalence (Odds Ratio)","index":8,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6],[27,0,27,3],[27,4,27,6],[16,0,16,3],[16,4,16,6],[18,0,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[20,4,20,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,3],[15,4,15,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"1/D13","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Equivalence limit"]
[]
["Classic Treatment"]
["Number of events"]
["N"]
[]
["New Treatment"]
["Number of events"]
["N"]
[]
[]
["Odds Ratio",{"$f":"IFERROR((E20*(E17-E16))/(E16*(E21-E20)),\" \")","v":" "},null,"Se(log(or))",{"$f":"IFERROR(SQRT((1/E16)+(1/(E17-E16))+(1/E20)+(1/(E21-E20))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29>MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A29>MIN(D13,J6),E29<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38>MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A38>MIN(D13,J6),E38<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]

{"sheet":"Equivalence (Risk Ratio)","index":9,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6],[27,0,27,3],[27,4,27,6],[16,0,16,3],[16,4,16,6],[18,0,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[20,4,20,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,3],[15,4,15,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"1/D13","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Equivalence limit"]
[]
["Classic Treatment"]
["Number of events"]
["N"]
[]
["New Treatment"]
["Number of events"]
["N"]
[]
[]
["Risk Ratio",{"$f":"IFERROR(((E20/E21)/(E16/E17)),\" \")","v":" "},null,"Se(log(RR))",{"$f":"IFERROR(SQRT((1/E16)+(1/(E20))-(1/E17)-(1/(E21))),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29>MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A29>MIN(D13,J6),E29<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38>MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A38>MIN(D13,J6),E38<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]

{"sheet":"Equivalence (Hazard Ratio)","index":10,"n_rows":39,"n_cols":10,"rows_kept":39,"cut":false,"hidden":false,"merged":[[37,0,37,3],[37,4,37,6],[38,0,38,1],[38,2,38,6],[28,0,28,3],[28,4,28,6],[29,0,29,1],[29,2,29,6],[35,0,35,6],[36,0,36,3],[36,4,36,6],[27,0,27,3],[27,4,27,6],[16,0,16,3],[16,4,16,6],[18,0,18,6],[19,0,19,3],[19,4,19,6],[20,0,20,3],[20,4,20,6],[23,0,24,0],[23,1,24,2],[23,3,24,3],[23,4,24,6],[26,0,26,6],[11,0,11,6],[12,0,12,2],[12,3,12,6],[14,0,14,6],[15,0,15,3],[15,4,15,6]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"1/D13","v":{"$error":"#DIV/0!"}}]
[]
[]
[]
[]
[]
[]
["Non-inferiority Margin"]
[]
["Classic Treatment"]
["Median survival"]
["Number of events"]
[]
["New Treatment"]
["Median survival"]
["Number of events"]
[]
[]
["Hazard Ratio",{"$f":"IF(OR(ISBLANK(E16),ISBLANK(E20)),\" \",(E16/E20))","v":" "},null,"Se(log(HR))",{"$f":"IFERROR(SQRT((1/E17)+(1/E21)),\" \")","v":" "}]
[]
[]
["Bilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.96*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.96*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A29>MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A29<MIN(D13,J6),E29>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A29>MIN(D13,J6),E29<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]
[]
[]
[]
[]
[]
["Unilateral 95% CI"]
["Lower bound",null,null,null,"Upper bound"]
[{"$f":"IFERROR(EXP(LN(B24)-(1.65*E24)),\" \")","v":" "},null,null,null,{"$f":"IFERROR(EXP(LN(B24)+(1.65*E24)),\" \")","v":" "}]
["Decision",null,{"$f":"IF(AND(OR(ISBLANK(E16),ISBLANK(E17),ISBLANK(E20),ISBLANK(E21),ISBLANK(D13))),\" \",IF(AND(A38>MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed upper equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38<MAX(D13,J6)),\"NOT equivalent (bypassed lower equivalence limit)\",IF(AND(A38<MIN(D13,J6),E38>MAX(D13,J6)),\"NOT equivalent (bypassed both equivalence limits)\",IF(AND(A38>MIN(D13,J6),E38<MAX(D13,J6)),\"Equivalent\")))))","v":" "}]