# turnover

1. ### Monthly Weekly Daily Target Turnover

Hi, I have the yearly turnover target for a company and would like to calculate the monthly, weekly and daily targets to meet the yearly. I want to be able to put the actual daily revenue and automatically recalculate the next day target and the next month target. For example if my yearly...
2. ### Employee turnover calc

I am trying to find Employee turnover by Year/Company I have and employee table and I have created a Calendar table The employee table has the following columns ID Hire Date Term Date Company Active Status I would like to createa dashboard to show by Company turnover % by Year (2018 &...
3. ### Excel formulas OFFSET with COUNTA

Hi all, It drives me crazy but I don't understand why it does not work. Excel gives me always #VALUE! Those formulas should automatically add the new values in the chart created where in the column A there is ''MONTH'' and in the column B ''TURNOVER'' Here is the formula for the turnover...
4. ### Executing an increase on a basket based on turnover

Hi, I need some help please, I work with a basket of products that fall under different groupings (a,b,c) I want to execute a price increase on my turnover and of x percent but I want to make group "A" increase by a certain percentage only and then be able to calculate the increase on the rest...
5. ### SUMPRODUCTS with OR

Dear I have a question to you. Im using SUMPRODUCT for some querry and its perfectli works if at criteria Im using onlu one paramiter for one comumn. But now I want to use two parameters for one of columns. Simple example below Month Turnover ……. Jan 1 Feb 2 March 3...
6. ### Pivot Table & Calculated Fields?

Hi everyone, Apologies if my question has been posted or solved before, however I could not find so here I go. I have a series of HR headcount data, which contains various columns of 1's and 0's. I am trying to figure out turnover or attrition, but I would like to calculate this within a...
7. ### Indirect summation

Hello, all. I can't find this question referenced in the forum before. I have a sheet where Column 'A' always remains the same each year I use it. But I always add columns between column 'A' and 'C' each year, like this: Year 1 <tbody> 2017 2016 Turnover </tbody> Year 2 <tbody>...
8. ### Vlookup

Hi, Hopefully somebody can help me with this as it is puzzling me. I am trying to auto add the total annual sales for a group of products as follows: Tab "Customer Analysis" - cell F8 = total annual turnover of a group of products, I have one tab with a product group (Data) and one tab with...
9. ### 12 month moving average

I need help calculating a 12 month rolling average for employee turnover for the month of January. After I get the turnover, then I need to display this in a graph or sort. I'm lost. I know how to do the rolling average for each the turnover and the headcount, then calculate Jan turnover, BUT...
10. ### Employee Turnover

I am trying to calculate turnover for contract to hire employees, Over the course of the last 6 months we have: 937 total number of employees hired 283 separations 307 were hired after their contract 347 still work for us Is our turnover percentage seperations(283)/total employees(937) *100?
11. ### Inventory Days on hand date build up

I'm working on metrics for our inventory Days on hand. Let's say I have a table with weekly inventory information, a table with weekly sales information and a calender date table. I need everything is linked together by an Item table and the date table. To calculate my days on hand I need...

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...