EXCEL DATA STRUCTURE

%3CLINGO-SUB%20id%3D%22lingo-sub-1531414%22%20slang%3D%22en-US%22%3EEXCEL%20DATA%20STRUCTURE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531414%22%20slang%3D%22en-US%22%3E%3CP%3EAlright%2C%20so%20I'm%20trying%20to%20calculate%20a%20share%20of%20profits%20that%20goes%20to%20different%20employees%20during%20a%20week.%20At%20the%20end%20of%20my%20week%2C%20i%20have%20a%20spreadsheet%20that%20adds%20all%20the%20profit%20every%20one%20gets.%20I%20have%203%20employees%20that%20feeds%20on%20the%20same%20cut%2C%20I%20need%20to%20be%20able%20to%20enter%20their%20names%20on%20the%20day%20of%20the%20week%20on%20which%20they%20worked%20so%20that%20they%20get%20the%20cut%20and%20the%202%20others%20doesn't.%20Can%20anyone%20help%20me%20with%20that%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1531414%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1531421%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20DATA%20STRUCTURE%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1531421%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F732865%22%20target%3D%22_blank%22%3E%40FRANK_TRIES%3C%2FA%3E%26nbsp%3B%2C%20A%20sample%20file%20(with%20confidential%20info%20removed)%20would%20be%20helpful%20to%20answer%20your%20question(s).%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Alright, so I'm trying to calculate a share of profits that goes to different employees during a week. At the end of my week, i have a spreadsheet that adds all the profit every one gets. I have 3 employees that feeds on the same cut, I need to be able to enter their names on the day of the week on which they worked so that they get the cut and the 2 others doesn't. Can anyone help me with that? 

2 Replies
Highlighted

@FRANK_TRIES , A sample file (with confidential info removed) would be helpful to answer your question(s).

Highlighted

@FRANK_TRIES 

 

If we were sitting down together and trying to work this out, I'd have to ask a few more questions. I'm pretty sure anybody else would too. So bear with me/us. It will also help if you can post a copy of whatever workbook/spreadsheet you already have as a starter, so we don't have to create something from scratch that has no bearing on your reality.

 

That said, here are some questions:

  1. Does only one employee work each day, or are there some days when two of them, or even all three are present and working?
  2. Do the number of hours worked in any given day matter?
  3. Is it only the profits for each day they work that are shared with whoever worked that day, or are the profits for the week tallied first, and then shared based on hours/days worked by each of the three? (Asked another way, if somebody was present all day but no sales (therefore no profit) that day, do they get zero?)
  4. Is there a minimum or maximum applied or is it a straight percentage regardless?
  5. Does seniority matter in any way; length of service with you?
  6. Are there any other factors that you're taking for granted, but would be helpful for anybody wanting to help you out here? Like, for instance, do you take any withholding tax out (Federal or State)?

You get the idea....