Editing User:RichardF/Sandbox3

<noinclude>{| style="width:100%"
|-
|{{purge|'''Update'''}}
<br>Current Month Edits: {{#expr: ( {{NUMBEROFEDITS:R}} - 255812 ) }}
<br>Current Year Weeks: {{#expr: ( {{CURRENTWEEK}} ) }}
<br>Subtract 1 week if not Sunday: {{#ifeq: {{CURRENTDOW}}|0| -0| -1}} means
<br>{{#expr: ( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )}} weeks * 7: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7)}}
<br>Week Full Days: {{#expr: {{CURRENTDOW}} -1 }}
<br>Year Full Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1 }} 
<br>Year Full Days Offset: 1+1 = {{#expr: 1+1}} means
<br>Current Month Full Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1  - (1+1) }}
<br>Today Current Hour: {{#expr: {{CURRENTHOUR}}  }} means
<br>Today Current Hour: {{#expr: {{CURRENTHOUR}} /24 ROUND 2 }} makes
<br>Current Month Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1  - (1+1) + ( {{CURRENTHOUR}} /24) ROUND 2 }}

| valign=top style="width:60%" |
</noinclude>{| cellspacing="0" align="center" cellpadding="5" class="plainlinks" style="width: {{#switch: {{FULLPAGENAME}} | User:RichardF/Sandbox3 | Appropedia:Village pump | Appropedia:Village pump/Introduction | Appropedia:Village pump/Stats = 100% | #default = 60%}}; border:1px solid #A3BFA3; background-color:#EDF2ED; box-shadow: 2px 2px 1px #888888; text-align: left;"
|-
!<center>[[Special:Statistics|Appropedia site statistics]] ({{purge|Update}})</center>
|-
|<center>'''[[Special:Allpages|Pages]]:''' {{NUMBEROFPAGES}} · '''[[Special:Newimages|Files]]:''' {{NUMBEROFFILES}} · '''[[Special:Allpages|Articles]]:''' {{NUMBEROFARTICLES}} · '''[[Special:ActiveUsers|Active users]]:''' {{NUMBEROFACTIVEUSERS}} <br>'''[[Special:Recentchanges|Edits]]:''' {{NUMBEROFEDITS}} · '''Edits/Article:''' {{#expr: {{NUMBEROFEDITS:R}} / {{NUMBEROFARTICLES:R}} round 0}} · {{NUMBEROFEDITS:R}} round 0}}</center> 
|}<noinclude>
|}

=== How to update this table ===
The above table is updated automatically, except for the number and bar values in the graphic over time sections, which can be selected from any of the values on the history table below. 

The Monthly Edits are adjusted by changing the offset in the related equation, e.g., <nowiki>{{formatnum:{{#expr: {{NUMBEROFEDITS:R}} - <!--update edits offset-->255812}}}}</nowiki>  The bars are adjusted so the longest previous value is about 90%, e.g., <nowiki>{{#expr: 90}}</nowiki>. The current period is formatted to hit the 90% value at a pace of about 125 Edits/Day, e.g., <nowiki>{{#expr: ({{<!--update edits offset-->NUMBEROFEDITS:R}} - 255812) / 43 }}</nowiki>.

The Edits/Day bar lengths are adjusted to have the target length be about 50% at 125 Edits/Day, e.g., <nowiki>{{#expr: (( {{NUMBEROFEDITS:R}} - <!--update edits offset-->255812 ) / ( ( ( ({{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7 +{{CURRENTDOW}}-1 ) - <!--update year days offset-->2) + ({{CURRENTHOUR}}+.01)/24 ) /<!--125 e/d--> 250)*100 ROUND 0 }} | {{#expr: ( {{NUMBEROFEDITS:R}} - <!--update edits offset-->255812 ) / ( ( ( ({{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7 +{{CURRENTDOW}}-1 ) - <!--update year days offset-->2) + ({{CURRENTHOUR}}+.01)/24 ) ROUND 0 }} }}</nowiki> and <nowiki>{{#expr: (126/250)*100 }}</nowiki>.

The Days in Edits/Day are adjusted by changing the offset in the related equation, e.g., <nowiki>{{#expr: ( {{NUMBEROFEDITS:R}} - <!--update edits offset-->255812 ) / ( ( ( ({{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7 +{{CURRENTDOW}}-1 ) - <!--update year days offset-->2) + ({{CURRENTHOUR}}+.01)/24 ) ROUND 0 }})</nowiki>. The calculation of Days in Edits/Day works as follows; Current Year Weeks: {{#expr: ( {{CURRENTWEEK}} ) }} but Subtract 1 week if not Sunday: {{#ifeq: {{CURRENTDOW}}|0| -0| -1}} means {{#expr: ( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )}} weeks * 7: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7)}} plus Week Full Days: {{#expr: {{CURRENTDOW}} -1 }} goes to Year Full Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1 }}. Year Full Days Offset: 1+1 = {{#expr: 1+1}} means Current Month Full Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1  - (1+1) }}. Today Current Hour: {{#expr: {{CURRENTHOUR}}  }} means Today Current Hour: {{#expr: {{CURRENTHOUR}} /24 ROUND 2 }} makes Current Month Days: {{#expr: (( {{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7) +{{CURRENTDOW}} -1  - (1+1) + ( {{CURRENTHOUR}} /24) ROUND 2 }}

=== History ===
The history table below can be updated by copying the bottom row from the display, which is updated automatically, ( except for the Edits/Day Lately & Views/Edit Lately) to the row just above it.

{| table class="wikitable collapsible uncollapsed sortable" style="text-align:right;"
|+'''Appropedia site statistics history'''
|- 
!Date !! Pages !! Files !! Articles !! A u !! Edits !! E/P !! E/A !! E/DL !! Views !! V/E !! V/EL
|-
| 2013 04 15 00:01 || 39739 || 17188 || 5394 || 94 || 234781 || 6 || 44 ||  || 40620315 || 173 ||
|-
| 2013 04 30 00:00 || 39956 || 17322 || 5381 || 111 || 236856 || 6 || 44 ||  || 41121927 || 174 ||
|-
| 2013 05 1 00:00 || 39974 || 17332 || 5384 || 114 || 237039 || 6 || 44 || 0 || 41161113 || 174 || 0
|-
| 2013 05 15 00:00 || 40401 || 17696 || 5390 || 106 || 239557 || 6 || 44 || 180|| 41621022 || 174 || 183
|-
| 2013 05 31 00:00 || 40620 || 17870 || 5406 || 112 || 240840 || 6 || 45 || 127 || 42290799 || 176 || 297
|-
| 2013 06 1 00:00 || 40641 || 17888 || 5411 || 112 || 240931 || 6 || 45 || 0 || 42326485 || 176 || 0
|-
| 2013 06 2 00:00 || 40643 || 17888 || 5411 || 115 || 240953 || 6 || 45 || 22 || 42352012 || 176 || 54,132
|-
| 2013 06 3 00:00 || 40648 || 17890 || 5411 || 117 || 240971 || 6 || 45 || 20 || 42380920 || 176 || 30,495
|-
| 2013 06 4 00:00	 40647	 17891	 5408	 119	 241023	 6	 45	 31	 42423697	 176	 13,724
|-
| 2013 06 5 00:00 || 40651 || 17894 || 5409 || 115 || 241063 || 6 || 45 || 33 || 42468526 || 176 || 9,905
|-
| 2013 06 6 00:00 || 40664 || 17896 || 5412 || 112 || 241169 || 6 || 45 || 48 || 42510671 || 176 || 5,670
|-
| 2013 06 7 00:00 || 40711 || 17933 || 5418 || 115 || 241300 || 6 || 45 || 61 || 42557454 || 176 || 3,784
|-
| 2013 06 8 00:00 || 40737 || 17938 || 5418 || 113 || 241481 || 6 || 45 || 79 || 42584367 || 176 || 2,588
|-
| 2013 06 9 00:00 || 40751 || 17943 || 5420 || 119 || 241572 || 6 || 45 || 80 || 42609913 || 176 || 2,260
|-
| 2013 06 10 00:00 || 40750 || 17950 || 5422 || 95 || 241704 || 6 || 45 || 86 || 42647426 || 176 || 1,923
|-
| 2013 06 11 00:00 || 40756 || 17952 || 5424 || 77 || 241845 || 6 || 45 || 91 || 42678736 || 176 || 1,660
|-
| 2013 06 30 00:00 || 40828 || 17995 || 5428 || 67 || 242841 || 6 || 45 || 66 || 43230441 || 178 || 1,083
|-
| 2013 07 1 00:00 || 40838 || 17995 || 5436 || 57 || 242864 || 6 || 45 || 64 || 43262309 || 178 || 1,087
|-
| 2013 08 1 00:00 || 40807 || 17982 || 5425 || 60 || 244821 || 6 || 45 || 63 ||	44465479 || 182 || 1,688
|-
| 2013 09 1 00:00 || 40906 || 18005 || 5450 || 50 || 245689 || 6 || 45 || 28 || 45618104 || 186 || 5,135
|-
| 2013 10 1 00:00 || 41201 || 18118 || 5462 || 123 || 246856 || 6 || 45 || 39 || 47096395 || 191 || 5,086
|-
| 2013 11 1 00:00 || 41565 || 18409 || 5502 || 116 || 250223 || 6 || 45 || 109 || 48462733 || 194 || 1,610
|-
| 2013 12 1 00:00 || 41916 || 18625 || 5567 || 132 || 252784 || 6 || 45 || 85 || 49698100 || 197 || 1,203
|-
| 2014 01 1 00:00 || 42389 || 18974 || 5619 || 225 || 255812 || 6 || 46 || 98 || 50935290 || 199 || 966
|-
| {{CURRENTYEAR}} {{CURRENTMONTH}} {{CURRENTDAY}} {{CURRENTTIME}} || {{NUMBEROFPAGES:R}} || {{NUMBEROFFILES:R}} || {{NUMBEROFARTICLES:R}} || {{NUMBEROFACTIVEUSERS:R}} || {{NUMBEROFEDITS:R}} || {{#expr: {{NUMBEROFEDITS:R}} / {{NUMBEROFPAGES:R}} round 0}} || {{#expr: {{NUMBEROFEDITS:R}} / {{NUMBEROFARTICLES:R}} round 0}} || {{#expr: ( {{NUMBEROFEDITS:R}} - <!--update edits offset-->255812 ) / ( ( ( ({{CURRENTWEEK}}{{#ifeq: {{CURRENTDOW}}|0| -0| -1}} )*7 +{{CURRENTDOW}}-1 ) - <!--update year days offset-->2) + ({{CURRENTHOUR}}+.01)/24 ) ROUND 0 }} || || ||
|}

<!--
[[Category:Village pump subpages|Introduction]] -->
</noinclude>