Excel Worksheet Development
Budget: $30 – $250 AUD
I'm seeking an experienced freelancer to construct a comprehensive Excel worksheet. This worksheet will be used to calculate and compare around 10,000 individual assets with different inservice (depreciation start dates).
The assets i specifically am looking at are called SUBbase assets and used in Road construction. We currently have asset lives of around 150 years but wish to compare this life with a variety of years 200/250/300/350 and 400years. Possible different years so needs to be able to amend lives and compare against original. I am looking at having something design that can give comparisons against the original live (which ive highlighted in yellow). The file attached has a large amount of data alot of which isnt necessary The columns in yellow are what you will require.
So i may need worksheet which i can show all assets with the original columns + columns showing the depreciation effect for 200/250/300/350/400. But have ability to amend years if necessary. The worksheet attached is at 30th june 2023. I need to show the variances for each asset and the potential saving for extending the asset life.
The assets i specifically am looking at are called SUBbase assets and used in Road construction. We currently have asset lives of around 150 years but wish to compare this life with a variety of years 200/250/300/350 and 400years. Possible different years so needs to be able to amend lives and compare against original. I am looking at having something design that can give comparisons against the original live (which ive highlighted in yellow). The file attached has a large amount of data alot of which isnt necessary The columns in yellow are what you will require.
So i may need worksheet which i can show all assets with the original columns + columns showing the depreciation effect for 200/250/300/350/400. But have ability to amend years if necessary. The worksheet attached is at 30th june 2023. I need to show the variances for each asset and the potential saving for extending the asset life.