Hi All,
I work in the electricity industry and wish to graph the following comparisons in the most efficient graphs as possible. We do job for power stations in maintaining their equipments and this work is made up of four parts:
1. Work pack review ( where the plan is organised before the work delivery)
2. Switching ( This includes switching out and in the circuit before and after the work is delivered.
3. Planned Maintenance ( The actual maintenance work on the equipment)
4. OMGS (Other material, goods and services i.e miscellaneous overheads supplied by third parties).
Prior to the work being delivered we provide quotations to the customer that this work will going to cost you this much. Recently our estimates and final costs have had large variances and therefore I am required to work on presenting startegies on producing accurate quotes and cost cutting techniques. In the regard I have the following data which needs graphical representation, ideally line graphs. I need to compare 2012 work against 2013 work where we had cosniderable improvements in costing and estimations. Ideally three graphs one for 2012, one for 2013 and comparing both 2012 and 2013. There are two things in the data one is hours required to do the job and second is cost. Can you also please advise the process for the chart as well just in case i need to alter any figures.
The datafile is in the form of excel file. Please visit the following link:
https://skydrive.live.com/redir?resid=B223BA41D3B06570!279&authkey=!AFfqkoASdfjvPJ4
Please feel free to ask any questions.
Many Thanks
Franklin
I work in the electricity industry and wish to graph the following comparisons in the most efficient graphs as possible. We do job for power stations in maintaining their equipments and this work is made up of four parts:
1. Work pack review ( where the plan is organised before the work delivery)
2. Switching ( This includes switching out and in the circuit before and after the work is delivered.
3. Planned Maintenance ( The actual maintenance work on the equipment)
4. OMGS (Other material, goods and services i.e miscellaneous overheads supplied by third parties).
Prior to the work being delivered we provide quotations to the customer that this work will going to cost you this much. Recently our estimates and final costs have had large variances and therefore I am required to work on presenting startegies on producing accurate quotes and cost cutting techniques. In the regard I have the following data which needs graphical representation, ideally line graphs. I need to compare 2012 work against 2013 work where we had cosniderable improvements in costing and estimations. Ideally three graphs one for 2012, one for 2013 and comparing both 2012 and 2013. There are two things in the data one is hours required to do the job and second is cost. Can you also please advise the process for the chart as well just in case i need to alter any figures.
The datafile is in the form of excel file. Please visit the following link:
https://skydrive.live.com/redir?resid=B223BA41D3B06570!279&authkey=!AFfqkoASdfjvPJ4
Please feel free to ask any questions.
Many Thanks
Franklin
