Find more Web Development Remote Jobs posted recently Worldwide

Required Microsoft Excel freelancer for Microsoft Project expert needed to create Cashflow Report template using Custom Fields job

Posted at - Oct 28, 2019

Toogit Instant Connect Enabled


I will share a copy of the MS Project file that is currently in use with selected freelancer, which has several Custom Fields.

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.


Please let me know if there are any clarifications needed

About the recuiterMember since May 20, 2018 Navin Kumar
from Podkarpackie, Poland

Skills & Expertise Required

Microsoft Excel 

Candidate shortlisted and hiredHiring open till - Aug 23, 2020

Work from Anywhere
40 hrs / week
Fixed Type
Remote Job
$41.76
Cost

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions


Apply on more work from home jobs posted in Web Development category.