1. J

    Allocation with VBA until limit value is reached

    Hello everyone, I'm scratching my head with a problem that seems to have a simple resolution but which I can't find; so I'm in need for your help. In a warehouse, I have several Buffer Areas to store boxes that will be shipped to several Destinations (see green table). Each Buffer Area has its...
  2. C

    Prepaid expenses amortization [automated]

    Good morning all! I need your help/ assistance. I am working on automated prepaid expenses allocation among of all month the service run through. To be specific, it is related to software products we manually expense at the end of the month. Ideally services run from the beginning of the...
  3. D

    Break Down Forecast Allocations Help? Formula help

    My ask is Please use the attached excel file as your total event sales forecast for Q3 and Q4. The ask is simply to break these forecasts out into Northern, Southern, Western. Feel free to set up the data/table however you feel makes sense, whether in a data set that we can pivot or table So i...
  4. C

    Choice allocation with preference and priorities

    Hi all, I am looking for a way to do something similar to others on this forum around allocating choices to a number of work experience placements. I have anywhere between 60-100 students each year who rank five placement preferences from over 50 placements (who have between 1 and 3 spaces)...
  5. C

    Equally Random Distribution

    Using the image below, is it possible to assign a Program Randomly to each employee, but where the Count and units are balanced to the best ability? Thank You!
  6. A

    How to allocate amount based on Payment Start Date and End Date thru VBA

    Hi, I'm using a formula to allocate the amount evenly based on the frequency of payment, due to numerous projects it is quite difficult to change the reference for each project, how we can achieve the same through VBA. The results are in column G to J.
  7. S

    Workload Allocation with skills matrix

    Hi, I'm currently creating a macro for allocation base on worker's skills matrix set.(determined by Y or N). So if the member is Y, worker is eligible to work with case and can assign the case. Should be allocated randomly but evenly distributed. Can someone help me how to do this on VBA macro...
  8. F

    Corrupt/Damaged File Won't Open

    One of my regular (almost daily) excel (.xls) files will not open today. I get this message: "Sorry, we couldn't find D:\Daves Data\....blah.xls. Is it possible it was moved, renamed or deleted? When I ran CHKDSK the result for the file in question says that "first allocation unit is not valid...
  9. T

    How do I redistribute sales fairly if I want to increase the growth percentage?

    I am working on a sales forecast for 2020. The forecast has 92 locations and I have sales by week by site for Period 1 2019 and a forecast of sales by week for Period 1 2020. Period 1 2019 Sales Total: $11,586,579 Period 1 2020 Sales Forecast: $11,57,090 Dollar Change in sales 2019 to 2020...
  10. T

    For without Next

    Hello, I have a custom tab from UI Editor. I keep getting 'For without Next' error and it highlights the End Sub. Have no idea why. Please help! Sub DC_Split(Optional ByVal Control As IRibbonControl) Application.Calculation = xlCalculationManual Application.EnableEvents = False...
  11. D

    How do you query in excel? What would be the best program to complete this in?

    I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price inc. GST Allocated to Date report...
  12. D

    Problem with opening multiple instances of file on a network

    I have been creating several spreadsheets at work and there is a problem with opening more than 1 instance of them at the same time on a network. I have one spreadsheet called "quoting tool" that generates quotes. When quotes are finalised they are sent to separate spreadsheets called allocation...
  13. M

    Allocation Tool

    Hi. I'm a an excel novice so apologies in advance. I need to create an allocation tool which distributes work evenly amongst teams. We receive a different amount of queries to get through everyday so would need to amend the daily allocation. Each of the teams have different targets which vary...
  14. J

    Break down a total quantity into columns

    Hello All! Got a query which I hope someone can help with.. I have a spreadsheet that I need to create for work due to a new process. Essentially what I need help on is a formula which automatically breaks down the allocation (column B) into packs (columns D-M). Below is a shortened version of...
  15. C

    Allocation based on priority tier

    I'm working to create an allocation model to quickly determine whether or not an order can be supported when compared to the available inventory. For example, I have 3 customers, each in their own tier (1,2,3). Tier 1 customers will have priority and first dibs at the available inventory, then...
  16. S

    Hourly allocation based on Start, end date and allocation %

    Hey There, I need help with excel allocation formulas. I attached a sample spreadsheet. I will need two formula options. So, here is what I need: For an employee, I will enter three parameters - Start Date, End Date, and allocations ( as a percentage). Based on these inputs, I want to...
  17. X

    Allocation based on percentages

    Hi Guys , Having a bit of an issue allocating overhead costs. In order to get my allocations i have been dividing my sales by my overhead to come up with my percentage of allocation. is there an excel formula that would convert that percentage to a figure? in other words if my allocation is 3%...
  18. C

    Investment rebalancing every year for a basic stock/bond allocation

    Hi guys, I've run into a mental roadblock trying to figure this out. I thought it was simple, but it was not as simple as I thought. In the table below, I can easily calculate the return of the portfolio and break it down into equity and fixed income allocation. However, through time, this...
  19. M

    "Conditional Formatting"

    Hello everyone, I have a table(Below) and would like to assign a conditional formatting to the items under the allocation section, provided that the Investment section items should also have the same color or different doesn't really matter. I did the allocation section by clicking in...
  20. J

    Sum Range based on multiple criteria

    I cannot seem to figure this one out... tried sumifs, sumproduct, index/match. Here's what I'm trying to do: Sum data in an array that matches 3 different criteria coming from both columns and rows. Maybe it's best to illustrate. Here's a simplified version: <tbody> Company Allocation 2013...

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