Template:EstimateCostDetails: Difference between revisions

From Vision
No edit summary
m (1 revision)
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
<noinclude>
<noinclude>
Include this template as follows:
Usage:
<pre>
 
{{EstimateCostDetails
<nowiki>
|REQ=Requirements Days
{{EstimateCostDetails</nowiki><br />
|EST=Estimation Days
|Client=Client for estimate rates. Required if an estimate section is to be produced.<br />
|FS=Functional Specification Days
|Year=Year for estimate rates. Required if an estimate section is to be produced.<br />
|TS=Technical Specification Days
|REQ=Requirements Time. Defaults to zero.<br />
|DEV=Development Days
|EST=Estimate Time. Defaults to zero.<br />
|ST=Testing and Release Days
|FS=Functional Specification Time. Defaults to zero.<br />
|IMP=Implementation Days
|TS=Technical Specification Time. Defaults to zero.<br />
|Client=The client code. Without this, all charges will default to 0
|DEV=Development Time. Defaults to zero.<br />
|Year=The year's charges to use. If not supplied, the current year will be used.
|ST=Testing Time. Defaults to zero.<br />
|IMP=Implementation Time. Defaults to zero.<br />
|FSEST=Y if this estimate is for production in a functional specification. Omit if no separate estimate and functional specification sections are required. If the values in the estimate differ from the functional specification, use the fields EREQ, EEST, EFS, ETS, EDEV, ESTT, EIMP to identify the Estimate values. If these are omitted, the Functional Specification values in fields REQ, EST, FS, TS, DEV, ST, IMP will be used.<br />
|EREQ=Estimate Requirements Time. Defaults to the value specified in REQ if omitted.<br />
|EEST=Estimate Estimate Time. Defaults to the value specified in EST if omitted.<br />
|EFS=Estimate Functional Specification Time. Defaults to the value specified in FS if omitted.<br />
|ETS=Estimate Technical Specification Time. Defaults to the value specified in TS if omitted.<br />
|EDEV=Estimate Development Time. Defaults to the value specified in DEV if omitted.<br />
|ESTT=Estimate Testing Time. Defaults to the value specified in ST if omitted.<br />
|EIMP=Estimate Implementation Time. Defaults to the value specified in IMP if omitted.<br />
}}
}}
</pre>
</nowiki>
 
 
 
{{note}} If on a separate page Ensure that you include the relevant Category tag at the bottom of the page.
{{note}} If on a separate page Ensure that you include the relevant Category tag at the bottom of the page.


Line 21: Line 33:


</noinclude>
</noinclude>
{{#ifeq:{{{Year}}}|2012|
{{#ifeq:{{{Client}}}|EXL|
    {{#vardefine:CostREQ|525}}
    {{#vardefine:CostEST|525}}
    {{#vardefine:CostFS|525}}
    {{#vardefine:CostTS|525}}
    {{#vardefine:CostDEV|500}}
    {{#vardefine:CostST|500}}
    {{#vardefine:CostIMP|500}}
|
{{#ifeq:{{{Client}}}|DHL|
    {{#vardefine:CostREQ|525}}
    {{#vardefine:CostEST|525}}
    {{#vardefine:CostFS|525}}
    {{#vardefine:CostTS|525}}
    {{#vardefine:CostDEV|500}}
    {{#vardefine:CostST|500}}
    {{#vardefine:CostIMP|500}}
|
{{#ifeq:{{{Client}}}|CERT|
    {{#vardefine:CostREQ|600}}
    {{#vardefine:CostEST|600}}
    {{#vardefine:CostFS|600}}
    {{#vardefine:CostTS|600}}
    {{#vardefine:CostDEV|600}}
    {{#vardefine:CostST|600}}
    {{#vardefine:CostIMP|600}}
|
{{#ifeq:{{{Client}}}|PACE|
    {{#vardefine:CostREQ|600}}
    {{#vardefine:CostEST|600}}
    {{#vardefine:CostFS|600}}
    {{#vardefine:CostTS|600}}
    {{#vardefine:CostDEV|600}}
    {{#vardefine:CostST|600}}
    {{#vardefine:CostIMP|600}}
|
{{#ifeq:{{{Client}}}|PROD|
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
|
<!-- Default charges for 2012 for no client -->
    {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
}}
}}
}}
}}
}}
|
<!-- Default charges for no matching year -->
    {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
}}
{{#ifeq:{{{Year}}}|2011|
{{#ifeq:{{{Year}}}|2011|
{{#ifeq:{{{Client}}}|EXL|
{{#ifeq:{{{Client}}}|EXL|
Line 48: Line 126:
     {{#vardefine:CostST|600}}
     {{#vardefine:CostST|600}}
     {{#vardefine:CostIMP|600}}
     {{#vardefine:CostIMP|600}}
|
{{#ifeq:{{{Client}}}|PACE|
    {{#vardefine:CostREQ|600}}
    {{#vardefine:CostEST|600}}
    {{#vardefine:CostFS|600}}
    {{#vardefine:CostTS|600}}
    {{#vardefine:CostDEV|600}}
    {{#vardefine:CostST|600}}
    {{#vardefine:CostIMP|600}}
|
{{#ifeq:{{{Client}}}|PROD|
    {{#vardefine:CostREQ|0}}
    {{#vardefine:CostEST|0}}
    {{#vardefine:CostFS|0}}
    {{#vardefine:CostTS|0}}
    {{#vardefine:CostDEV|0}}
    {{#vardefine:CostST|0}}
    {{#vardefine:CostIMP|0}}
|
|
<!-- Default charges for 2011 for no client -->
<!-- Default charges for 2011 for no client -->
    {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
     {{#vardefine:CostREQ|0}}
     {{#vardefine:CostREQ|0}}
     {{#vardefine:CostEST|0}}
     {{#vardefine:CostEST|0}}
Line 57: Line 154:
     {{#vardefine:CostST|0}}
     {{#vardefine:CostST|0}}
     {{#vardefine:CostIMP|0}}
     {{#vardefine:CostIMP|0}}
}}
}}
}}
}}
}}
}}
Line 62: Line 161:
|
|
<!-- Default charges for no matching year -->
<!-- Default charges for no matching year -->
     {{#vardefine:CostREQ|1}}
     {{#vardefine:Message|Unknown costs for client/year ({{{Client|No client}}}/{{{Year|No year}}})}}
    {{#vardefine:CostEST|1}}
    {{#vardefine:CostFS|1}}
    {{#vardefine:CostTS|1}}
    {{#vardefine:CostDEV|1}}
    {{#vardefine:CostST|1}}
    {{#vardefine:CostIMP|1}}
}}
}}
{{#if: {{#var:Message}} |{{warning|{{#var:Message}}}} | }}
<table border="1px" width="100%">
<table border="1px" width="100%">
<tr><td bgcolor="silver" colspan=4>'''Cost Details'''</td></tr>
<tr><td bgcolor="silver" colspan={{#ifeq:{{{FSEST}}}|Y|5|4}}>'''Cost Details'''</td></tr>
<tr>
<tr>
<td bgcolor="silver">'''Activity'''</td>
<td bgcolor="silver">'''Activity'''</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">'''Estimate<br />No. of Days'''</td>|}}
<td bgcolor="silver" align="center">'''No. of Days'''</td>
<td bgcolor="silver" align="center">'''No. of Days'''</td>
<td bgcolor="silver" align="center">'''Rate per Day (£)'''</td>
<td bgcolor="silver" align="center">'''Rate per Day (£)'''</td>
Line 80: Line 175:
<tr>
<tr>
<td bgcolor="silver">Requirements</td>
<td bgcolor="silver">Requirements</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EREQ|{{{REQ}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{REQ|0}}} |2 }}</td>
<td align="center">{{#number_format: {{{REQ|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostREQ}}</td>
<td bgcolor="silver" align="center">{{#var:CostREQ}}</td>
Line 86: Line 182:
<tr>
<tr>
<td bgcolor="silver">Change Request Evaluation</td>
<td bgcolor="silver">Change Request Evaluation</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EEST|{{{EST}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{EST|0}}} |2 }}</td>
<td align="center">{{#number_format: {{{EST|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostEST}}</td>
<td bgcolor="silver" align="center">{{#var:CostEST}}</td>
Line 92: Line 189:
<tr>
<tr>
<td bgcolor="silver">Functional Specification</td>
<td bgcolor="silver">Functional Specification</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EFS|{{{FS}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{FS|0}}} |2}}</td>
<td align="center">{{#number_format: {{{FS|0}}} |2}}</td>
<td bgcolor="silver" align="center">{{#var:CostFS}}</td>
<td bgcolor="silver" align="center">{{#var:CostFS}}</td>
Line 98: Line 196:
<tr>
<tr>
<td bgcolor="silver">Technical Specification</td>
<td bgcolor="silver">Technical Specification</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{ETS|{{{TS}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{TS|0}}}|2 }}</td>
<td align="center">{{#number_format: {{{TS|0}}}|2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostTS}}</td>
<td bgcolor="silver" align="center">{{#var:CostTS}}</td>
Line 104: Line 203:
<tr>
<tr>
<td bgcolor="silver">Development</td>
<td bgcolor="silver">Development</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EDEV|{{{DEV}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{DEV|0}}} |2 }}</td>
<td align="center">{{#number_format: {{{DEV|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostDEV}}</td>
<td bgcolor="silver" align="center">{{#var:CostDEV}}</td>
Line 110: Line 210:
<tr>
<tr>
<td bgcolor="silver">Testing and Release</td>
<td bgcolor="silver">Testing and Release</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{ESTT|{{{ST}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{ST|0}}} |2 }}</td>
<td align="center">{{#number_format: {{{ST|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostST}}</td>
<td bgcolor="silver" align="center">{{#var:CostST}}</td>
Line 116: Line 217:
<tr>
<tr>
<td bgcolor="silver">Implementation</td>
<td bgcolor="silver">Implementation</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EIMP|{{{IMP}}}}}} |2 }}</td>|}}
<td align="center">{{#number_format: {{{IMP|0}}} |2 }}</td>
<td align="center">{{#number_format: {{{IMP|0}}} |2 }}</td>
<td bgcolor="silver" align="center">{{#var:CostIMP}}</td>
<td bgcolor="silver" align="center">{{#var:CostIMP}}</td>
<td align="right">£{{#number_format: {{#expr: {{{IMP|0}}}*{{#var:CostIMP}} }}|2 }}</td>
<td align="right">£{{#number_format: {{#expr: {{{IMP|0}}}*{{#var:CostIMP}} }}|2 }}</td>
</tr>
</tr>
<tr><td colspan=4>&nbsp;</td></tr>
<tr><td colspan={{#ifeq:{{{FSEST}}}|Y|5|4}}>&nbsp;</td></tr>
<tr>
<tr>
<td bgcolor="silver">'''TOTAL'''</td>
<td bgcolor="silver">'''TOTAL'''</td>
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{#expr: {{{EREQ|{{{REQ}}}}}}+{{{EEST|{{{EST}}}}}}+{{{EFS|{{{FS}}}}}}+{{{ETS|{{{TS}}}}}}+{{{EDEV|{{{DEV}}}}}}+{{{ESTT|{{{ST}}}}}}+{{{EIMP|{{{IMP}}}}}} }} |2 }}</td>|}}
<td align="center">{{#number_format: {{#expr: {{{REQ|0}}}+{{{EST|0}}}+{{{FS|0}}}+{{{TS|0}}}+{{{DEV|0}}}+{{{ST|0}}}+{{{IMP|0}}} }} |2 }}</td>
<td align="center">{{#number_format: {{#expr: {{{REQ|0}}}+{{{EST|0}}}+{{{FS|0}}}+{{{TS|0}}}+{{{DEV|0}}}+{{{ST|0}}}+{{{IMP|0}}} }} |2 }}</td>
<td bgcolor="silver">&nbsp;</td>
<td bgcolor="silver">&nbsp;</td>

Latest revision as of 12:20, 23 December 2011

Usage:

{{EstimateCostDetails
|Client=Client for estimate rates. Required if an estimate section is to be produced.
|Year=Year for estimate rates. Required if an estimate section is to be produced.
|REQ=Requirements Time. Defaults to zero.
|EST=Estimate Time. Defaults to zero.
|FS=Functional Specification Time. Defaults to zero.
|TS=Technical Specification Time. Defaults to zero.
|DEV=Development Time. Defaults to zero.
|ST=Testing Time. Defaults to zero.
|IMP=Implementation Time. Defaults to zero.
|FSEST=Y if this estimate is for production in a functional specification. Omit if no separate estimate and functional specification sections are required. If the values in the estimate differ from the functional specification, use the fields EREQ, EEST, EFS, ETS, EDEV, ESTT, EIMP to identify the Estimate values. If these are omitted, the Functional Specification values in fields REQ, EST, FS, TS, DEV, ST, IMP will be used.
|EREQ=Estimate Requirements Time. Defaults to the value specified in REQ if omitted.
|EEST=Estimate Estimate Time. Defaults to the value specified in EST if omitted.
|EFS=Estimate Functional Specification Time. Defaults to the value specified in FS if omitted.
|ETS=Estimate Technical Specification Time. Defaults to the value specified in TS if omitted.
|EDEV=Estimate Development Time. Defaults to the value specified in DEV if omitted.
|ESTT=Estimate Testing Time. Defaults to the value specified in ST if omitted.
|EIMP=Estimate Implementation Time. Defaults to the value specified in IMP if omitted.
}} </nowiki>


Note Note: If on a separate page Ensure that you include the relevant Category tag at the bottom of the page.

Note Note: Costs should be numeric. If one is not included, it will default to zero (0).

Note: This page should be kept up-to-date with the latest cost changes for all clients, otherwise the costs will default to zero (0)




Warning Warning: Unknown costs for client/year (No client/No year)
Cost Details
Activity No. of Days Rate per Day (£) Cost (£ Exc. VAT)
Requirements 0.00 £First argument to "number_format" must be a number.
Change Request Evaluation 0.00 £First argument to "number_format" must be a number.
Functional Specification 0.00 £First argument to "number_format" must be a number.
Technical Specification 0.00 £First argument to "number_format" must be a number.
Development 0.00 £First argument to "number_format" must be a number.
Testing and Release 0.00 £First argument to "number_format" must be a number.
Implementation 0.00 £First argument to "number_format" must be a number.
 
TOTAL 0.00   £First argument to "number_format" must be a number.
Estimate excludes training, release to live and go live support.