I have total spend as of $26,000 as of May, 2006. How do I annualize the
total spend based on this information?
I need to find the Top 100 Vendor Spend.
In my query, I've selected sum and decending order for the YTD Spend field. What do I need to do please, that will produce only one vendor name with a grand total for that vendor? Ex: there may be 10 line items for GE . . . I need to show one line item for GE with a grand total . . . similiar to a pivot table in excel. I tried a pivot in Access, but it showed separate line items instead of a grand total for the vendor.
Thank you.
I have a 12 month-financials tab. I want to be able to type in "1" for January, "2" for Feb, in a cell to pring me the CUMULATIVE SPEND?
Any ideas
Instead of having to pull up the calculator off the start menu then transfer
that data to excel, it would be great if we could have a way to calculate
within the cell we want the data.
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/office/comm...el.programming
Hi guys, I in need of some Excel expert help.
The last time I used Excel at any level was during my high school days and I'm now embarrisingly lame at it.
Basically I am developing a spreadsheet for another staff member so they can tally the amount of time a student spends working out of college hours (on break etc)
I just need a way of inputing say 1.5hours or 01:30:00 into a cell and then a total cell which will tally that up....BUT then return said input cell back to 0 so the next time the tally is updated another amount of time can be enterered, again updating the total. i.e. the student spends another hour working so 1 or 1:00:00 is entered, resulting in a total of 2.5 or 02:30:00,
I hope that makes sense
I've taken a screen shot to try and clarify.
Sorry for just barging in and flooding you with questions by the way, I did search but didn't quite find what I was looking for
Thanks in advance.
Ben.
Say I have $10,000 saved up and it earns 8% interest per year. If I want to spend it evenly over 10 years, how much should I take out each year (bearing in mind that the remaining balance each year will add 8% interest)?
In Excel, I can do this using a recursive set of formulas, but I think one of Excel's preset formulas should do it.
-OR- Is there a mathematical formula to calculate it...
Calculate X=The amount I should withdraw each year, whe
A=Initial Lump Sum Amount
R=Annual Interest Rate
N=Number of Years to consume the amount evenly
(assume I take the annual amount out at the start of each year and that interest is paid at the end of each year on the remaining balance)
Thanks!!!
Phil
This is hopefully a simple problem - I haven't been able to find a solution on any forums though:
I have 'table 1' with column headers:
A1 NAME - B1 ITEM - C1 PRICE - D1 DATE
In 'table 2' I have headers:
F1 NAME - G1 BUDGET - H1 SPEND - I1 REMAINING
In column F I want to create a list each of the names that appear in 'table 1' column A, and in column H, a list of their sum total spends calculated from each of their transactions in 'table 1 column C'.
Is there a formula for doing this that will save me from sorting and manually adding the amounts against each employee?
Many Thanks
Good Afternoon,
I'm looking for a Project Mangement Spend Plan Template... something that shows planned vs. expended amounts. Does anyone have any examples/templates?
Thanks,
LBF
Hi,
I have some spend details set up in a spreadsheet that has the following columns
Department, Month, Order Total.
Data is like "Logistics", "1st May 2010", "50.31"
There are over 200 Department Names and I need to construct a table which shows the Department name in a list of rows and Monthly spend in columns with the total to the right hand side of course.
Any one have any ideas?
