Template talk:United States Sentencing Guidelines

The making of this template

I'm not sure anyone will need to know this, but the OpenOffice Calc formulae used in the making of this template were:

• =IF(ISNUMBER(E1),E1,IF(ISNUMBER(MID(E1,2,1)),LEFT(E1,2),LEFT(E1,1)))
• =IF(G1<>"",G1,IF(ISNUMBER(MID(E1,2,1)),RIGHT(E1,LEN(E1)-3),RIGHT(E1,LEN(E1)-2)))
• =IF(LEFT(H1,1)=" ",RIGHT(H1,LEN(H1)-1),H1)
• =IF(RIGHT(I1,1)=" ",LEFT(I1,LEN(I1)-1),I1)
• Main formula:
  • For this template: ="-->{{#ifeq: {{{1}}}|"&B1&C1&D1&"."&F1&"|[[U.S.S.G.]] [http://www.ussc.gov/Guidelines/2011_Guidelines/Manual_HTML/"&B1&LOWER(C1)&D1&"_"&F1&".htm §"&B1&C1&D1&"."&F1&"{{#if: {{{2|}}}|({{{2}}})}}{{#if: {{{3|}}}|({{{3}}})}}{{#if: {{{4|}}}|({{{4}}})}}{{#if: {{{5|}}}|({{{5}}})}}{{#if: {{{6|}}}|({{{6}}})}}{{#if: {{{7|}}}|({{{7}}})}}{{#if: {{{8|}}}|({{{8}}})}}]}}<!--"
  • For Template:ussgref: ="-->{{#ifeq: {{{1}}}|1B1.1|{{cite web|url=http://www.ussc.gov/Guidelines/2011_Guidelines/Manual_HTML/1b1_1.htm|publisher=[[U.S. Sentencing Commission]]|date=2011|work=[[U.S. Sentencing Guidelines]]|title=U.S.S.G. §1B1.1{{#if: {{{2|}}}|({{{2}}})}}{{#if: {{{3|}}}|({{{3}}})}}{{#if: {{{4|}}}|({{{4}}})}}{{#if: {{{5|}}}|({{{5}}})}}{{#if: {{{6|}}}|({{{6}}})}}{{#if: {{{7|}}}|({{{7}}})}}{{#if: {{{8|}}}|({{{8}}})}} — Application Instructions}}}}<!--"

I couldn't get it any better than this. See history. Leucosticte (talk) 23:31, 2 July 2012 (UTC)