Statistical & Clinical Analysis
Tokyo Guidelines 2018: acute cholangitis criteria and grading
Explore TG18 diagnostic and severity patterns using fictional, pre-assessed flags and counts, without automatic treatment instructions.
Three diagnostic domains
The Tokyo Guidelines 2018 (TG18) describe domains for systemic inflammation (A), cholestasis (B) and imaging evidence (C). In the guideline’s pattern, A plus either B or C is a suspected diagnosis; A plus B plus C is a definite diagnosis. This example accepts already-assessed flags and cannot verify the underlying findings.
Not meeting the pattern does not exclude acute cholangitis: the guideline discusses limitations, including presentations without systemic inflammatory findings or readily available imaging. Suspected acute biliary infection warrants prompt professional assessment rather than reliance on a worksheet.
Check the diagnostic pattern
Set each pre-assessed domain to numeric 0 or 1. Blank is unknown, not absent. The output describes the pattern only and is not an independently confirmed diagnosis.
=IF(COUNT(B2:B4)<>3,"Enter three assessed flags",IF(OR(AND(B2<>0,B2<>1),AND(B3<>0,B3<>1),AND(B4<>0,B4<>1)),"Flags must be 0 or 1",IF(AND(B2=1,B3=1,B4=1),"Definite-pattern criteria",IF(AND(B2=1,OR(B3=1,B4=1)),"Suspected-pattern criteria","Pattern not met; does not exclude disease"))))Explore the separate severity criteria
The TG18 table describes Grade III when at least one of six specified organ dysfunction criteria is present; without those, Grade II requires at least two of five specified findings; otherwise Grade I applies at initial assessment. The spreadsheet accepts counts that have already been assessed against the original definitions. A count alone cannot verify which criteria were present.
The guideline’s Grade II factors include specific white-cell count thresholds, fever, age, bilirubin and low albumin; Grade III criteria define organ dysfunction in detail, including particular cardiovascular support thresholds. Review the original table rather than substituting generic signs. Severity and clinical status may change and require reassessment.
=IF(OR(E2="Enter three assessed flags",E2="Flags must be 0 or 1"),E2,IF(E2="Pattern not met; does not exclude disease","No grading in this example",IF(COUNT(B5:B6)<>2,"Enter both assessed counts",IF(OR(B5<0,B5>6,B5<>INT(B5),B6<0,B6>5,B6<>INT(B6)),"Counts out of range",IF(B5>=1,"Grade III pattern",IF(B6>=2,"Grade II pattern","Grade I pattern"))))))Treatment is a clinical decision
TG18 describes initial care and biliary drainage according to severity and the patient’s condition. This example deliberately does not choose a procedure, give a fixed drainage deadline or replace urgent professional care.
Try the example
Use the original values or change them to test your understanding.