•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Daily Average from Continuous Monthly Totals
Our take
In today's fast-paced work environment, effective tracking of employee productivity is essential. To modernize your reporting, you need a dynamic approach to calculate daily averages from continuously updated monthly totals. This involves creating formulas that not only reflect current data but also adjust as new months are added. Additionally, calculating the percentage of denied and approved refunds requires precision to ensure accuracy. By streamlining these processes, you can enhance productivity insights and make informed decisions that drive performance forward.
Working with employee productivity and they are required to perform to specific requirements. I am looking to bring our reporting into this century.
I have monthly totals that update every month and I want a daily average to adjust as the months are added not by 12 months from day 1.
I'm actually in need for a couple different formulas. Percentage of denied and approved refunds and the daily average. Remember all totals will go up every month when those are added. I tried the percentage formula but was not getting the right number and 2 zeros were added and could not remove them with the decrease decimal option.
Any help or suggestions are welcome and appreciated.
[link] [comments]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Monthly tracking workbook I use to track employee sales metrics; Trying to find a way to make the process less labour intensiveTruly having a hard to describing my issue effectively but hoping someone can help. First time posting here and I'm by no means an expert with excel, so please be kind! I have a monthly workbook where I track each employees revenue and other metrics. Every 2 weeks for payroll, I provide a print out of these numbers, and the payroll sheet pulls data from multiple sheets in the workbook. For example, every workbook has a separate sheet for each day of the month, titled "1" through "31". I have pay period sheets, so I'll use one titled "04.02.26 - 04.15.26". Then I'll have the data for each employee pulled from multiple sheets. For example, I use the formula =SUM('2:15'!E3) to pull the sales data from each day of that period for the specific employee. This works quite well. However, when I create a new month's spreadsheet, I have to manually alter this formula for each employee and for each data point (more than just revenue, at least 6 different data points for 7 employees). Is there a way to automate this? For example, a cell or two where I'm able to enter the date range and all of the formulas update to that date range for the corresponding pages? I'm sorry of this post is confusing. Truly it's confusing even typing it! submitted by /u/Ok_Smile9222 [link] [comments]
- Get rid of rounding errorHello, got a problem with a spreadsheet at work. For an calculation I need to calculate the average Full time equivalent of staff. Sheet is set up like this this: Column A: Person ID Column B: duration of period in days Column C: full-time equivalent Column D: weighted full-time equivalent for period Column E: average Full time equivalent over year Column A to C are preset base data. Formulas are in column D and E Calculation is basically done, broken down the formula is: In column D: =ROUND([duration days]/365×[Full time eqivalent for period];4) In column E it is: =SUMIF([Person ID]; [Person ID]; [Weighted for period]) But because if the rounding it doesn't add up to 1, it gies to 0,9999, even if the full year average is 1. Any ideas, how to fix that? (Other than IF(0,9999; 1; do the math) 😂) Was thinking about something like " if all Full time equivalent for period (column C) for one person ID (column A) are 1,0000, then make the average over year 1,0000, if not make the calculation based on my current formula for column E" but I can't get the operators right for that. Thanks in advance fir any help😂 Edit: moving rounding to column E instead of D did the trick. Sometimes its the obvious stuff xD Thanks to all submitted by /u/AttemptSlow612 [link] [comments]
- Auto-Updating Formula to reflect YTD percentageHey Gang of Excel Gurus. Could not find the answer to this in search, probably because I don't know how to exactly describe the function I am looking for... So I have a sales spreadsheet similar to the sample one attached here. The question is how to create a formula to reflect a comparison sum that is a "rolling" total in column B (2025) so that I can compare as a Year to Date with Column C (2026). In my example, I have sales numbers for this year, thus far. i want to know the percentage of what it was for the same period last year. I want the percentage to update so that when I eventually enter a value in for April, the sum for Jan-Apr in 2025 will update and thereby reflect the updated percentage in a different cell. Therefore: As of today the YTD percentage is.... Is there a way to do this? To have a formula update somehow when new data is entered in a different cell, or set of cells? submitted by /u/loozrrtuba [link] [comments]
- Tracking totals over all sheets, but from different cellsHi, I'm trying to keep an automated running total on working hours for my project. I have one sheet per day, each with a cell that sums the total hours for that day (reads 40 in my screenshot), dating back to October. I've been tracking this manually with a rather bulky SUM function on a dedicated sheet, and it works just fine, but I'd like to try to automate the grand total to sum each day as it's created, rather than manually adding the cell each time I create a new sheet. The issue I'm running into is that the daily total doesn't land on the same cell every day; I am constantly adding & removing rows as people come & go from the project. There are also multiple cells that read total hours; one for the subcontractor sections, one for my own company's section, and the bottom one which sums the whole day - this is the one I'm trying to track. Is there a way to filter for this cells contents on each sheet based on the Daily Total cell in the bottom right perhaps, even though they're not in the same row? As an aside, I'm not allowed to change the layout to make this easier; this is a standard form at my company and the formatting needs to stay the same. https://preview.redd.it/3giox6bkvtng1.png?width=819&format=png&auto=webp&s=916dd43f9584d1ac3491770ac180ca0b445688d0 submitted by /u/Mental-Screen-1127 [link] [comments]
Tagged with
#Excel alternatives for data analysis#financial modeling with spreadsheets#rows.com#natural language processing for spreadsheets#AI formula generation techniques#generative AI for data analysis#Excel compatibility#formula generator#Excel alternatives#daily average#monthly totals#employee productivity#reporting#formulas#percentage#denied refunds#approved refunds#adjust#totals#update