Template talk:UnitedStatesSentencingGuidelines

Law Template‑class

	Law portal This template is within the scope of WikiProject Law, an attempt at providing a comprehensive, standardised, pan-jurisdictional and up-to-date resource for the legal field and the subjects encompassed by it.LawWikipedia:WikiProject LawTemplate:WikiProject Lawlaw articles
Template	This template does not require a rating on Wikipedia's content assessment scale.

United States Template‑class

	United States portal This template is within the scope of WikiProject United States, a collaborative effort to improve the coverage of topics relating to the United States of America on Wikipedia. If you would like to participate, please visit the project page, where you can join the ongoing discussions. Template Usage Articles Requested! Become a Member Project Talk Alerts United StatesWikipedia:WikiProject United StatesTemplate:WikiProject United StatesUnited States articles
Template	This template does not require a rating on Wikipedia's content assessment scale.

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}}})}}]}}{{#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]