Microsoft Office Forums Excel Reports from Project with Custom Fields

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-22-2019, 05:11 AM
mspwizardlol mspwizardlol is offline Excel Reports from Project with Custom Fields Windows 10 Excel Reports from Project with Custom Fields Office 2016
Novice
Excel Reports from Project with Custom Fields
 
Join Date: Jul 2019
Posts: 1
mspwizardlol is on a distinguished road
Default 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
Attached Files
File Type: mpp 5-B Ventro Project Template v3 (Copy me).mpp (480.5 KB, 0 views)
Reply With Quote
Reply

Tags
custom fields, project 2016, reports

Thread Tools
Display Modes


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
Excel Reports from Project with Custom Fields Project Reports Overview Milestone Filter ebilbrough Project 2 12-17-2015 03:07 PM
Excel Reports from Project with Custom Fields Two identical reports - merge fields into one of them cyndor Excel 3 06-21-2012 06:24 PM
Excel Reports from Project with Custom Fields 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


All times are GMT -7. The time now is 12:59 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft