Template:MRFSidebar: Difference between revisions

Latest revision as of 01:07, 25 April 2022

Error: no local variable "site" has been set.
Error: no local variable "operator" has been set.
[[File:Mrf{{{id}}}.png\|400px\|center\|Site Location]] See Qualifying MRF → page for a larger UK Wide map.

Data	2020
Tonnage Summary
EA Tonnage IN	Expression error: Unexpected round operator.
EA Tonnage OUT	Expression error: Unexpected round operator.
Qualifying IN	Expression error: Unexpected < operator.
Qualifying OUT	Expression error: Unexpected < operator.

@@ Line 7: / Line 7: @@
 |Operator|{{#external_value:operator}}
 |-
-|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,totin=(inq1+inq2+inq3+inq4)}}
+|colspan="2"|[[File:Mrf{{{id}}}.png|400px|center|Site Location]]
+See [[Qualifying Material Recovery Facilities|Qualifying MRF →]] page for a larger UK Wide map.
+|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=inq1=inq1,inq2=inq2,inq3=inq3,inq4=inq4,totin=(inq1+inq2+inq3+inq4)}}{{#vardefine:qualin|{{#external_value:totin}}}}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=outq1=outq1,outq2=outq2,outq3=outq3,outq4=outq4,totout=(outq1+outq2+outq3+outq4)}}{{#vardefine:qualout|{{#external_value:totout}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_in|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eain|{{#external_value:opt}}}}{{#clear_external_data:}}{{#get_db_data: db=engy|from=ea_ew_out|where=epr='{{{EPR}}}'|data=opt=sum(tin)}}{{#vardefine:eaout|{{#external_value:opt}}}}<small>
 {|class="wikitable"
-|colspan="2"|'''Tonnage IN'''
+|colspan="2"|'''Tonnage Summary'''
 |-
-!Period !! 2020
+!Data !! 2020
 |-
-|Quarter 1 || {{formatnum:{{#external_value:inq1}}}}
+|EA Tonnage IN||style="text-align:right;"| {{formatnum: {{#expr: {{#var:eain}} round 2 }} }}
 |-
-|Quarter 2 || {{formatnum:{{#external_value:inq2}}}}
+|EA Tonnage OUT ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:eaout}} round 2}} }}
 |-
-|Quarter 3 || {{formatnum:{{#external_value:inq3}}}}
+|Qualifying IN ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:qualin}} round 2 }} }}
 |-
-|Quarter 4 || {{formatnum:{{#external_value:inq4}}}}
+|Qualifying OUT ||style="text-align:right;"| {{formatnum: {{#expr: {{#var:qualout}} round 2 }} }}
 |-
-|Total || {{formatnum:{{#external_value:totin}}}}
+|}</small>
-|-
-|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'|data=outq1=outq1,outq2=outq2,outq3=outq3,outq4=outq4,totout=(outq1+outq2+outq3+outq4)}}
-{|class="wikitable"
-|colspan="2"|'''Tonnage OUT'''
-|-
-!Period !! 2020
-|-
-|Quarter 1 || {{formatnum:{{#external_value:outq1}}}}
-|-
-|Quarter 2 || {{formatnum:{{#external_value:outq2}}}}
-|-
-|Quarter 3 || {{formatnum:{{#external_value:outq3}}}}
-|-
-|Quarter 4 || {{formatnum:{{#external_value:outq4}}}}
-|-
-|Total || {{formatnum:{{#external_value:totout}}}}
-|-
-|}{{#clear_external_data:}}{{#get_db_data:db=engy|from=mrfstats2020|where=epr='{{{EPR}}}'
-|data=glass=round(((glasskg/sampletotkg)*(inq1+inq2+inq3+inq4)),2),metal=((metalkg/sampletotkg)*(inq1+inq2+inq3+inq4)),paper=((paperkg/sampletotkg)*(inq1+inq2+inq3+inq4)),plastic=round(((plastickg/sampletotkg)*(inq1+inq2+inq3+inq4)),2)}}
-{|class='wikitable'
-|colspan="2"|'Material IN'
-|-
-!Material||2020
-|-
-|Glass IN || {{formatnum: {{#external_value:glass}}}}
-|-
-|Metal IN ||{{formatnum: {{#expr: {{#external_value:metal}} round 2}}}}
-|-
-|Paper IN ||{{formatnum: {{#expr: {{#external_value:paper}} round 2}}}}
-|-
-|Plastic IN ||{{formatnum: {{#expr: {{#external_value:plastic}} round 2}}}}
-|}
 </div>