Template:SpotSearch DC/sandbox

== USAGE ==
 * Use this template to represent spot and search DCs. All parameters are optional.
 * spf Highest failed spot check
 * sps Lowest successful spot check
 * sef Highest failed search check
 * ses Lowest successful search check

CODING
Search: {{#iferror:{{#expr:{{{sef|}}}{{{ses|}}}}}|{{#ifeq:{{uc:{{{sef|}}}}}|N/A|N/A|{{#ifeq:{{uc:{{{ses|}}}}}|N/A|N/A|{{Red|Non-Numerical Inputs!}}}}}}|{{#if:{{{sef|}}}{{{ses|}}}|{{#iferror:{{#expr:{{{sef|}}}*{{{ses|}}}}}|{{#if:{{{sef|}}}|{{#expr:{{{sef}}}+1}}|?}}–{{#if:{{{ses|}}}|{{{ses}}}|?}}|{{#ifexpr:{{{sef}}}+1={{{ses}}}|{{{ses}}}|{{#ifexpr:{{{sef}}}>={{{ses}}}|{{Red|Inconsistent Observations!}}|{{#expr:{{{sef}}}+1}}–{{{ses}}}}}}}}}|?}}}} }}
 * {{Center|Spot: {{#iferror:{{#expr:{{{spf|}}}{{{sps|}}}}}|{{#ifeq:{{uc:{{{spf|}}}}}|N/A|N/A|{{#ifeq:{{uc:{{{sps|}}}}}|N/A|N/A|{{Red|Non-Numerical Inputs!}}}}}}|{{#if:{{{spf|}}}{{{sps|}}}|{{#iferror:{{#expr:{{{spf|}}}*{{{sps|}}}}}|{{#if:{{{spf|}}}|{{#expr:{{{spf}}}+1}}|?}}–{{#if:{{{sps|}}}|{{{sps}}}|?}}|{{#ifexpr:{{{spf}}}+1={{{sps}}}|{{{sps}}}|{{#ifexpr:{{{spf}}}>={{{sps}}}|{{Red|Inconsistent Observations!}}|{{#if:{{{spf|}}}|{{#expr:{{{spf}}}+1}}–{{{sps}}}}}}}}}|?}}}}
 * {{Center|Spot: {{#iferror:{{#expr:{{{spf|}}}{{{sps|}}}}}|{{#ifeq:{{uc:{{{spf|}}}}}|N/A|N/A|{{#ifeq:{{uc:{{{sps|}}}}}|N/A|N/A|{{Red|Non-Numerical Inputs!}}}}}}|{{#if:{{{spf|}}}{{{sps|}}}|{{#iferror:{{#expr:{{{spf|}}}*{{{sps|}}}}}|{{#if:{{{spf|}}}|{{#expr:{{{spf}}}+1}}|?}}–{{#if:{{{sps|}}}|{{{sps}}}|?}}|{{#ifexpr:{{{spf}}}+1={{{sps}}}|{{{sps}}}|{{#ifexpr:{{{spf}}}>={{{sps}}}|{{Red|Inconsistent Observations!}}|{{#if:{{{spf|}}}|{{#expr:{{{spf}}}+1}}–{{{sps}}}}}}}}}|?}}}}