Forum Discussion
abztahar
Jul 02, 2019Copper Contributor
Variable assumption based fromula
Hi, First time on here, maybe some one can help? I would appreciate some review/feedback and help on the attached images (can send file if necessary) which fails to compute change in salaried em...
Twifoo
Jul 02, 2019Silver Contributor
To enable testing of your formulas, and possible suggestion for improvement, please attach your sample file.
- TwifooJul 02, 2019Silver ContributorIn which particular cells of your monthly forecast sheet are you struggling? Please describe the specific results you want to achieve. Perhaps, you can manually enter your desired results, attach your sample file again, then I will analyze which formulas would return those results.
- abztaharJul 02, 2019Copper Contributor
As you can see in assumption boxes; all these variables should perfectly flow into forecast; for example if salaried employee starts in Oct instead then then the forecast should compute its first payment . from Nov & the Direct cost payable also reduces from Nov linking back to the number of jobs that employee can do per week Twifoo