# allocation

1. ### 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...
2. ### 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...
3. ### [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...
4. ### 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...
5. ### 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...
6. ### 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...
7. ### 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...
8. ### 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...
9. ### 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...
10. ### 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...
11. ### 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...
12. ### 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...

### This Week's Hot Topics

• populate from drop list with multiple tables
Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
• Find list of words from sheet2 in sheet1 before a comma and extract text vba
Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
• Dynamic Formula entry - VBA code sought
Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...