Task Report - Procurement Schedule exported to excel
- Created
- 1
- 3
Hi Guys
I am using ASTA 12.5.
I have a task report for a procurement schedule which exports to excel. What I need to do is adapt the report to what my company wants to see. The template came with the software, but I cannot work out how the dates are linked to the activities.
Prep Tender Docs Finish Date, Tender out Start date, Tender in Finish date, etc.. mobilisation duration & Free float, start on site Date
This is going to be in excel with one package/line with the columns representing the activites.
How do I make the table match the activities. Sorry if this is not clear, but I am really frustrated with this software. As a throwaway I would like to add a actual and forecast date for each!
Any thoughts
Andrew
1 reply
Oldest first- 0Mike Testro ·
Hi AndrewWith which software
Hi Andrew
With which software are you frustrated?
It seems that you have a vertical list from Asta that you want to change into a horizontal list in excell.
There is a feature in excell that will do this on one click - it ceratinly works in Lotus 123.
Alternatively you can set up a template on a single sheet where you add + cell address in a horizontal format that automatically links to the vertical data.
Best regards
Mike Testro
Log in or join to reply
ProjectControls.com is free to join. Members can post questions, reply, vote and follow discussions.
Existing members: your original username and password still work. Forgot password?