Template:EstimateCostDetails: Difference between revisions
From Vision
No edit summary |
mNo edit summary |
||
| Line 70: | Line 70: | ||
{{#vardefine:CostIMP|1}} | {{#vardefine:CostIMP|1}} | ||
}} | }} | ||
<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> | ||
| Line 83: | Line 81: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Requirements</td> | <td bgcolor="silver">Requirements</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{EREQ| | {{#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 90: | Line 88: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Change Request Evaluation</td> | <td bgcolor="silver">Change Request Evaluation</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{EEST| | {{#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 97: | Line 95: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Functional Specification</td> | <td bgcolor="silver">Functional Specification</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{EFS| | {{#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 104: | Line 102: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Technical Specification</td> | <td bgcolor="silver">Technical Specification</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{ETS| | {{#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 112: | Line 110: | ||
<td bgcolor="silver">Development</td> | <td bgcolor="silver">Development</td> | ||
<td align="center">{{#number_format: {{{DEV|0}}} |2 }}</td> | <td align="center">{{#number_format: {{{DEV|0}}} |2 }}</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{EDEV| | {{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center">{{#number_format: {{{EDEV|{{{DEV}}}}}} |2 }}</td>|}} | ||
<td bgcolor="silver" align="center">{{#var:CostDEV}}</td> | <td bgcolor="silver" align="center">{{#var:CostDEV}}</td> | ||
<td align="right">£{{#number_format: {{#expr: {{{DEV|0}}}*{{#var:CostDEV}} }} |2 }}</td> | <td align="right">£{{#number_format: {{#expr: {{{DEV|0}}}*{{#var:CostDEV}} }} |2 }}</td> | ||
| Line 118: | Line 116: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Testing and Release</td> | <td bgcolor="silver">Testing and Release</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{ESTT| | {{#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 125: | Line 123: | ||
<tr> | <tr> | ||
<td bgcolor="silver">Implementation</td> | <td bgcolor="silver">Implementation</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td align="center">{{#number_format: {{{EIMP| | {{#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> </td></tr> | <tr><td colspan={{#ifeq:{{{FSEST}}}|Y|5|4}}> </td></tr> | ||
<tr> | <tr> | ||
<td bgcolor="silver">'''TOTAL'''</td> | <td bgcolor="silver">'''TOTAL'''</td> | ||
{{#ifeq:{{{FSEST}}}|Y|<td bgcolor="silver" align="center"></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"> </td> | <td bgcolor="silver"> </td> | ||
Revision as of 12:58, 7 June 2011
Include this template as follows:
{{EstimateCostDetails
|REQ=Requirements Days
|EST=Estimation Days
|FS=Functional Specification Days
|TS=Technical Specification Days
|DEV=Development Days
|ST=Testing and Release Days
|IMP=Implementation Days
|Client=The client code. Without this, all charges will default to 0
|Year=The year's charges to use. If not supplied, the current year will be used.
}}
Note: If on a separate page Ensure that you include the relevant Category tag at the bottom of the page.
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)
| Cost Details | |||
| Activity | No. of Days | Rate per Day (£) | Cost (£ Exc. VAT) |
| Requirements | 0.00 | 1 | £0.00 |
| Change Request Evaluation | 0.00 | 1 | £0.00 |
| Functional Specification | 0.00 | 1 | £0.00 |
| Technical Specification | 0.00 | 1 | £0.00 |
| Development | 0.00 | 1 | £0.00 |
| Testing and Release | 0.00 | 1 | £0.00 |
| Implementation | 0.00 | 1 | £0.00 |
| TOTAL | 0.00 | £0.00 | |
| Estimate excludes training, release to live and go live support. |