Jump to content

Template talk:United States Sentencing Guidelines

Page contents not supported in other languages.
From Wikipedia, the free encyclopedia

The making of this template

[edit]

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)[reply]

Retrieved from "https://en.wikipedia.org/w/index.php?title=Template_talk:United_States_Sentencing_Guidelines&oldid=1238105580"