#1
|
|||
|
|||
Excel Reports from Project with Custom Fields
I have attached a copy of the MS Project file that is currently in use, which has several Custom Fields.
I know what I want to get out of this, but just don't know how to do it, and would really appreciate any assistance you can give. TASK #1 - Create one new Custom Date Field. Title will be "Indicative Materials Bill Date". The date should be automatically calculated as one-month before the "Estimated Start" date. TASK #2 - Adjust calculation in "Client Item Rate" to ensure that no error is created if the "Item Qty" field is completed or not. TASK #4 - Create one new Custom Cost Field. Title will be "Indicative Labour Value". The value should be calculated as 50% of the "Client Item Total". TASK #3 - Create cashflow forecast as an Excel xlsx export, showing month by month. This should use the "Estimated Start" and "Estimated Finish" dates. - The cashflow forecast will be the "Indicative Materials Value" in the Indicative Materials Bill Date (see Task #1), plus the sum("Client Item Rate"-"Indicative Labour Value") in the current month. Hoping you may be able to assist!! Many thanks |
Tags |
custom fields, project 2016, reports |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reports created in Project 2016 not viewable in Project 2010 | Murali Narayanan | Project | 0 | 05-23-2019 03:59 PM |
Project Reports Overview Milestone Filter | ebilbrough | Project | 2 | 12-17-2015 03:07 PM |
Two identical reports - merge fields into one of them | cyndor | Excel | 3 | 06-21-2012 06:24 PM |
Visual Reports (custom) | Quinton | Project | 3 | 03-29-2012 08:03 AM |
running reports out of ms project | nmanus | Office | 0 | 09-09-2009 12:47 PM |