weekly calculation

Large dataset with varying Start and End Dates. The Week Numbers need to fall in financial year (01/04/2023 - 31/03/2023). 01/04/2023 needs to be Week 1, 10/04/2023 is Week 2 and so forth with possible carry over into the new year. Using the Start and End Date, allocate the weekly cost to the...

Hey Experts, I'm sure you'll nail this super quick but basically, I'm trying to forecast what's needed by week to achieve a set goal. I'm wanting my team to input their forecast then the future week's volumes will change to then deliver the monthly targets for the remainder of the year So from...

I would like to modify solution EMT1075. I want to provide weekly allocation amounts rather than monthly. Appreciate any help Here is link to file <tbody> Allocate Hours Across Workdays...

Hi, i need to present a weekly report which would sum the results of validated values in several excel files (excel 2010). It is not the same files every week, however all files are in exactly the same format. The report needs to sum the number of approved, rejected and revised values in the...

I have created a timesheet that shows overtime options. I will try to make a copy (can we upload a copy of our file?) I have created checkbox for daily and weekly overtime options. If Daily (True), OT is calculated over 12 hours, if Weekly (True, OT is also calculated over 48 hours per week)...