allocation

  1. H

    Excel transpose

    Hi Sir I have mentioned below table: <tbody> ORDER_NO Reason For Rejection 4532599 Allocation Stock Mismatch Packing Surplus (blank) 4535662 (blank) 4535724 Unavailability of Stock 4535729 Allocation Stock Unavailability of Stock (blank) 4535738...
  2. L

    Multiple IF and AND Statement - Need Help!

    Hi - I was wondering if one of the Excel guru can correct the below formula for me? Formula it self is simple but even after the false part of the if statement I need the formula to continue to the next if statement so that next criteria can be matched. If there is a better way to do the...
  3. K

    Help using a macro to iterate through a range of rows

    Hi, I am trying to loop through the following macro to work through a range of rows. My goal is to end up with a sheet (Allocation per Employee) populated with the employee department and name and an allocation of time across projects. The Scratch sheet contains a number of formulas that...
  4. K

    Weekly Allocation of Amount

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

    Exccute Javascript in IE

    Hi, I want to click on button on a webpage which doesn't contains button tag. I think it is associated with javascript code execution. Below is the Html Code of complete webpage. <!DOCTYPE html> <html> <head> ****** http-equiv="Content-Type" content="text/html; charset=utf-8" /> ******...
  6. K

    Formula Needed for Bonus Allocation

    I am trying to figure out a way to create a sheet for calculating bonus allocations from a sheet of data used to allocate payroll. Here is what the payroll sheet looks like: <strike></strike>And the formulas I need would produce a list of employee ids and their entity allocation like this: I...
  7. D

    Allocation based on individual unrelated scores

    I work in a university study abroad office and have been left with the wreckage of my predecessor, so I'm trying to establish new procedures and methods for processing scholarship applications to make them as objective as possible. I have no idea how to begin with this problem, though I think...
  8. B

    Revenue Recognition

    Hi I am trying to build a revenue recognition formula within Excel. It's for a services company which can only consume service revenue at $40,000 per month. So for a deal of $100,000 the revenue would be recognized as $40k in month 1, $40k in month 2 and then $20k in month 3. So the inputs we...
  9. G

    [EASY, SUM=array] Took too long to find this solution and I know it sucks please help

    Gosh I want to be more efficient and I am trying. I had no idea how to turn the sum of the row(s) into a boolean statement. Otherwise I'd of used sum_product. My next trick would then be to add this to an aggregate function in order to evaluate order quantities that can filled up to available...
  10. R

    Accountant Needing Help Allocating Expenses Across Multiple Columns

    I am trying to allocate expenses across multiple columns (with the push of a button using macros) and divide the total expense by the amount of trucks that the expense is allocated to. We have a fleet of 11 trucks and will have an expense item that needs to be separated between a certain number...
  11. K

    VBA Nested Loop for Cost Allocation

    Good day all. I'm using Excel 2007 and am working on my first attempt at a Loop. I've spent alot of time looking at other posts. I believe I understand the individual concepts but can't seem to put it all together. It's time to ask for assistance. This is an allocation loop. Rows 5-7...
  12. G

    Randomly allocate members to groups in Excel

    I have a list of 34 names which I need to randomly assign to one of 8 teams. This will run on a monthly basis and as such, I need each month for a new team to be generated and no person repeated in a group they have been in the previous months (see below). I have been using the formula...
  13. A

    Value Allocation/ Distribution across multiple variables

    Hello, New to the forums, but I couldn't find a solution anywhere so I was hoping someone would see this and may know a trick. I have an issue where I need to assign "lots" to different orders (varying in amounts) to fulfill an overall order balance. For example: Overall Order quantity= 3000...
  14. L

    Investment Model Allocation based upon Percentage and Dollar Amounts

    Hi, I am working on a project in which I need to create an investment allocation spreadsheet. The idea is that there can be anywhere from 2 to 6 investment accounts, each with varying dollar amounts. Each account is then then defined as either a "taxable" or "tax deferred" account. From there...
  15. M

    Stock Allocation against Order

    Hi Excel Experts, I hope this is acheviable, Let say i have a list of stock which is run off a system this would show the usual - Product code - Description - Qty - Use by Date Then i have an order form. This would be what i input my order in, from the information i put in the order...
  16. S

    Use VBA to Solve Stocking Problem

    Hello - I have a simple sheet with columns holding product, gross_margin, and rank. The rank is calculated using the Excel Rank formula. In a fourth column named ShelfLocation, I want to start allocating where the product will go on the shelf - low, middle or high. All of the products are...
  17. S

    Excel Allocaton problem

    Hi I am trying to solve a allocation problem and need help understanding how to proceed. Problem Definition: I have a fund of USD 1000 (this fund will change as needed and will be a user input) I also have 4 categories for stocks in my portfolio (a,b,c,d) where a>b>c>d respectively. I will be...
  18. K

    Cost Allocation/Amortisation

    Hi All, Need help in cost allocation over a period of time. Data is as follows I have a cost incurred on a monthly basis like Dec-09 - $3000 Jan-10 - $2500 Feb-10 - $4000 Each of these costs need to be amortised over a period of 3 months Dec-09 will need to have $1000 Jan-09 will need...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top