turnover

  1. K

    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. O

    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. D

    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. S

    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. L

    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. T

    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. BenElliott

    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. A

    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. J

    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. U

    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. M

    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...

Some videos you may like

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...
Top