spend

Hello! I have created this chart to track company travel for the year. I wanted the chart to be sortable so I could look at the number of trips a team, individual, etc. are taking each month and the costs associated. Where I am getting stuck is the monthly totals formula. I need the monthly...

I am wanting to show the top 10 suppliers by spend and show their respective percentages of total sales. Pivot table easily gives me Top 10 but the options for % don't give the opportunity to compare each of the suppliers spend amounts to total sales, as opposed to % of top 10 spend. any...

Hi all, Trying to figure out how to do this, even a long winded way if anyone has any ideas. <colgroup><col><col></colgroup><tbody> Company Spend Category ABC Gas ABC Electricity DEF Water ABC Electricity </tbody> I have something like the table above and the end goal is to calculate...

Hi guys, sorry for the poorly worded title. I have a unique problem which I am stuck with... Let me try to describe it here and in addition, attach a worked example. I am working with a quarterly model, however have a a criteria/tranche which is based on yearly/cumulative spend. Criteria...

0 <button class="js-vote-down-btn grid--cell s-btn s-btn__unset c-pointer" title="This question does not show any research effort; it is unclear or not useful" aria-pressed="false" aria-label="down vote" data-selected-classes="fc-theme-primary" style="margin: 2px; box-sizing: inherit; font...

I have data that shows visits of customers Their name, the date they visited and how much they spent. I need to create a visual of this information to show if customers vary from there usual pattern of visits per week. If they always attend on the same day and if their spend increases. Please help

I have a question on returning X customer's discount percentage Y, based on their Z spend amount.Ie: I have a list of 5000 customers, Various min and max spend and its corresponding discount. For customer John, i can locate John by index match among the list of customers. Then when at customer...

I am conducting a bid. I have 5 items I want to purchase at varying quantities and am receiving bids from 4 different vendors. I know how to calculate total min spend and show which vendor to utilize for each item. Say I want to only set up purchase agreements with only 2 vendors. How can I...

Hi all, I have tried many ways to do this and have given up. I have a few customers and I have the spend for each month and I was trying to get the text to highlight if the spend is less than the previous month (if that makes sense). I have typed how it should look (I have manually changed the...

I currently have a spreadsheet which tells me how many months build period we have, buy calculating how much capex we have, and over what time. Issue I have is, if people spend X amount one month, and then X amount in 4 months time, my report will pull me off 2 months, whereas it should be 5...

Hello, I have a report in excel that contains 5 columns consisting of supplier name, part number, part description, quantity and spend. Each part number has a specific quantity and spend associated with it. I would like to come up with a formula that looks at the part number column and...

Hello, I have a report in excel that contains 5 columns consisting of supplier name, part number, part description, quantity and spend. Each part number has a specific quantity and spend associated with it. I would like to come up with a formula that looks at the part number column and...

Scenario is let's say we have customer in row, quarters in columns and spend / headcount in values. Is it possible to only show one quarter headcount while showing 4 quarter spend in the same pivot table? https://imgur.com/VM7ScsE for reference (it is not in pivot table format but gives you...

This was difficult to describe in a single title. Our new accounting system produces a monthly spreadsheet. Column C contains the Client name but only once. Column H contains the monthly spend for multiple product types Example: CLIENT PRODUCT NetValue Client1 product 1...

Picture of excel sheet: https://imgur.com/X9y9Lkn Hi, I need help with an excel formula that will allow me to change the monthly spend percentage (column D) which spits out into column C based on total revenue in column A. Here is the tricky part that I can’t figure out. In the first row I can...

<tbody> A B C D E F 1 Allocated Budget Spend Forecast Spend Total Spend (inc. Forecast) Max Budget (Overspend) Budget RAG 2 £100 £50 £25 £75 £110 </tbody> Can anyone help correct my formula please? I basically want to work out a single formula to use in F2 for the following rules...

Hi There, I'm new here and have searched if this has already been discussed, but with no luck, so apologies in advance if this has already been resolved/explained on another thread. I have a data sheet with sales per customer ID over a year. On a pivot table I can easily calculate the average...

I want to be able to automatically enter the value of monthly construction costs following an s curve spend profile. I want the ability to simply enter the contract value and monthly term to create a spend profile that follows the s curve principle. Anybody cracked this?

Hello I'm hoping somebody can educate me around this puzzle. I've been trying to sort descending on a basic calculated field within a basic query. The ORDER BY clause refuses to work however (keeps prompting for parameter values to be entered) unless I use the field position indicator...why...

Hi everyone <o:p></o:p> <o:p></o:p> I would like to sum values which are in two columns – but only take values from column B if column C is empty. <o:p></o:p> <o:p></o:p> To provide some context, Column C is actual spend and Column B is forecast spend. When comparing against budget I want to SUM...