allocation

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

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

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

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

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!

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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