Creating Spreadsheet - Figuring Cost Of Favorite Recipes
Nov 3, 2013
I want to create a spreadsheet for figuring the cost of some of my favorite recipes. Right now I have a table of basic ingredients (milk, sugar, etc) along with cost of same.
What I want to do is be able to set up a recipe that calls for "3 eggs, 1 sugar, 1 milk" and automatically figure the cost for me.
Ideally, I'd like this to be a "building block" spreadsheet - where I can have a recipe for "roux" (1 flour, 1 butter), and then a recipe for "broth" (1 chicken, 3 water), and then a recipe for "gravy" (1 roux, 2 broth) - where the spreadsheet is smart enough to do the math for me - and if the price of chicken goes up, I can change that in my basic list and it will carry down. And obviously, I want to be able to add ingredients and recipes easily.
View 3 Replies
ADVERTISEMENT
Apr 25, 2006
List Price $46.98 (e2)
Net Cost $19.53 (e3)
How do I enter a calculation that will show me my discount percentage from my supplier? (e4)
I then need to be able to drag the formula to the end of the sheet. Discount percentages will be different for each product, but the List Price and Net Costs are present, so the calculation needs to take these differences into consideration so that I get the correct discount percentage for each item.
View 9 Replies
View Related
Feb 11, 2009
some of your favorite Methods/Properties exposed by the Range Object. How's bout some that you just can't live without?
Have an tricks for example that you can do with XLS03 that for example couldn't do with XLS2K or perhaps XLS07 that you couldn't do with XLS03?
View 9 Replies
View Related
May 25, 2009
Let`s assume that I have numerous "Serial Number" in "Sheet1" : http://i40.tinypic.com/2iqbspt.jpg
Now I want to create some cards in "Sheet2" that each card have a serial number that related serial number there is in "Sheet1" : http://i43.tinypic.com/34fz690.jpg. Need easy solution for doing it while when I drag one card to copying it then related serial number in sheet1 would be appear in required field. I mean first card has first serial number of sheet1 and second card has second serial number of sheet 1 ; but I want to doing it quickly with dragging.
View 4 Replies
View Related
Aug 25, 2007
I have a list of 10 of my favorite/lucky numbers that I want to play in the lottery. The lottery picks 5 numbers total. I need a way to show me all the possible combinations of my 10 numbers picked in a 5 number draw (hope that makes sense). There are no repeat combinations- for example- I DO NOT WANT 1-2-3-4-5 and 5-4-3-2-1 to come up as separate combinations- so each of my favorite #s needs to be used only once in each combination, and each set used once.
I have searched this board for 2 hours now- read tons of other posts, but not finding a real solution. The output will be a list of all the possible combinations (no repeats, and no permutations) using my 10 favorite numbers. Another example-
1-2-3-4-5
1-2-3-4-6
1-2-3-4-7
1-2-3-4-8
1-2-3-4-9
1-2-3-5-6
1-2-3-5-7
and so on.
How do I create this? I realize the resulting table will be quite a large number of combinations- but we're going to have fun with it and pick a few at random.
View 9 Replies
View Related
Jul 7, 2008
Store A sells something for 100
Store B sells the same item for 125
Store B is 25% higher than A
how would a formula be written to show that?
Store B / Store A = 1.25 How do I get it to 25%
View 9 Replies
View Related
Jun 18, 2006
This is what I have
Rate Hours =basePay plus 6% plus 7.1% total
$50.00 10 $500.00 $530.00 $567.63 $567.63
What i want to have is one cell that I can Total everything.
I want my spread sheet to display just rate, hours total
I am having troule making the formula to display everything in the total cell
View 4 Replies
View Related
Jan 3, 2009
I need some help, I know very little about macros but is it possible to create folders/directories to a certain path using the text in an excel spreadsheet cell? For example, if cell a2 has a street address and cell b2 has a city, can it automatically create a directory in the path of my choice using that data? If yes, can it go down the the rows and create directories until it is done?
Please help as I have hundreds of directories to create.
View 6 Replies
View Related
Feb 21, 2010
I am trying to create CSV files from Excel spreadsheet for each tab. But when I convert these CSV files, text in cell is limiting to 255 characters, in otherwords it is getting truncated after 255characters. I am using Excel 2003 version.
And also when convereted these windows CSV files to UNIX csv files using the command "DOS2UNIX", some charaters becoming special characters. For exmaple, I have the actual text as "If AEENDTC ne '' then do; " and is becoming "If AEENDTC ne æÆ then do; " Do you have any idea why it is doing this.
View 14 Replies
View Related
May 14, 2008
Need constructing a formula and im not too sure which function to use.
Im also not sure if its even possible or im missing a required column to help make it possible.
(arrival Time)---(c1)--(c2)--(served by)---(time served)---(exit time)
-------A---------B-----C--------D----------E----------------F
1----9.00am-----0-----0--------1----------2mins-----------9.02am
2----9.01am-----1-----0--------2----------15mins----------9.16am
3----9.05am-----0-----1--------1----------2mins-----------9.07am
4----9.06am-----1-----1--------?----------xmins-----------x.xxam
Column A = Arrival time
Column B = Number of customers in Counter #1 as of arrival time
Column C = Number of customers in Counter #2 as of arrival time
Column D = to be Served By Counter:
Column E = Mins being served before exiting the counter/que
Column F = exit time
rows = customers entering a que.............
View 9 Replies
View Related
Apr 17, 2014
sample worksheet Antligen.xls
I have a spreadsheet that I need to add new rows everytime I have a new client. I a formula in the N column and a formula in the F column that I would like to automatically insert itself into the new rows.
The problem is this: I have arranged my table so that I can look at clients alphabetically, and according to other date... BUT now it wont let me insert a new row when I have a new client!!!
Is there anyway of keeping it so that I can insert a new row into my table, but preserve all of the formulas that I want automatically put into both the F and N column?
Attached is the sample spreadsheet.
View 1 Replies
View Related
Apr 5, 2013
I think I'm just missing something obvious here but I want to calculate commission based on £1 Plus 10% of Hammer Price. That bit's easy but I need it to ignore the hammer price if blank. In other words if I leave the hammer price empty, at the moment the sheet adds £1 to the commission cell.
In Summary:-
F3 is Hammer Price
K3 is Commission (=(F3*.1)+1)
K3 should NOT state £1 if F3 is empty
View 6 Replies
View Related
Sep 17, 2013
Currently I'm working on functionality in my staff holiday spreadsheet and I've come up with this amazing idea for a calendar overview for month by month.Now the sheets I currently have is summary and jan to dec.
I plan on adding the sheets Jan (Cal) to Dec (Cal) now this is when my idea gets nifty - The calendar view will import the information from the month table and will show it on the calendar.
For example X has 1 holiday in July for the 20th - this will show up on the calendar as "x on holiday", I'm still working with spreadsheets so I'm not sure if excel is powerful enough to do this - but is this actually possible?
View 2 Replies
View Related
Nov 5, 2013
Is there a way to make a simple text analyser that will return the number of times each word is used in a sentence or paragraph within a cell?
I use excel to write short paragraphs to upload onto social network sites and I would like a formula or program that tells me how many times each word has been used over a number of cells, to avoid repetition. Is there a way to do this?
View 3 Replies
View Related
Dec 23, 2010
I have set up a spreadsheet but need to add a tick box, I just need to tick it once the item has been completed.
View 6 Replies
View Related
Jul 3, 2014
I received some time stamped data in this format: 06.08.06.000000000 PM.
convert to HH:MM:SS ?
View 7 Replies
View Related
Aug 3, 2009
I Need figuring an AVERAGE from 4361 cells... looking to get a blended rate on pricing.
I am not even sure if excel can avg that many cells.
View 4 Replies
View Related
Aug 2, 2012
I am a personal loans officer and have created a worksheet to input a range of information about an application. The information is personal details and details about the loan. The data I input runs down Column D [with line breaks to seperate the answers into categories] with the question beside it in Column C.
I do this for every new application as I use it for reporting on my loans as well as mail merge to produce documents for the loan.
Currently I am doing one per loan but would like to have a button at the bottom of the page that once clicked, it will push the data onto another worksheet so that all my loans for that month are on the one spreadsheet. The data will be pushed onto a row, not a column, but it will also need to find the next available row to put the data on.
Once the button is clicked, the first worksheet will clear ready for the next loan to input and the data will transfer to the 2nd spreadsheet. And, if possible, on the first sheet will be a drop down list of all the current loans so I can recall any application details to the first sheet if needed to update details. So if the 'loan number inputed' already exists, it wont create a new line on the 2nd spreadsheet, but will know just to update the fields.
View 7 Replies
View Related
Feb 9, 2014
create an excel spreadsheet, where i can enter all my products name, unit price etc. so when i am doing an invoice for the customer, if i just type the product name price will show up automatically.
View 4 Replies
View Related
Dec 12, 2011
In MS Excel 2011 for Macintosh can I assign a macro to an object, such that if the user clicks the object it runs the macro? That is creating a button on the spreadsheet that will execute a macro.
View 2 Replies
View Related
Nov 11, 2013
I am creating a spread sheet with a large amount of data.
In column a I have a list of managers, in B I have a list of employees and C, I have a list of activities that have been recorded throughout the day.
What I want to do is create a list (on a new sheet) so in column A that would bring back all the managers. Then in column B, bring back the employee that is tied to the manager from column A and finally in column C, bring back the activity that is tied to the employee.
I know how I can do this by doing list validation with INDIRECT, but with the large amount of data that I have this would take forever in a day.
Is there an easier and quicker way to do this?
View 1 Replies
View Related
Mar 16, 2007
I have two spreadsheets. I need to be able to match information from detailed spreadsheet for specific information from a lookup spreadsheet.
The detailed sheet (call it Purchases) has information about what was purchased during a month.
Columns: ...
View 9 Replies
View Related
Mar 15, 2007
In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001
On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?
View 5 Replies
View Related
Jun 9, 2014
sample pic.png
I have two spreadsheets of data I export regularly from an outside source. I want to consolidate the data from these two sheets into one large sheet with all the data in a more concise form bringing in only the data related to certain parts I am conducting analysis on. I have a list of these parts already. My first thought on how to do this would be to use the list in an entry for an input box and have that list be the index for a for loop in which i searched for a part code, copied the entire corresponding row, and pasted it back into the master sheet. I have gone through and tried to do this but I am running into problems because sometimes I have multiple rows of data that correspond to a single part number. I have attached a template of the way that the data should look in the master file with the multiple rows of details that correspond to just one part entry.
View 1 Replies
View Related
Jul 11, 2013
Here's the spreadsheet I am talking about : [URL]
So as you can see each row = one day divided in 2 cycles of 12 hours : every 12 hours the cat gets a new injection of insulin (the columns "U" being the number of units of insulin the cat receives)
Now I want to turn this sheet into two different curves that would look like these : [URL]
As you can see the first graph shows data based on days (x) and insulin dose (y), while the second curves shows data based on days (x), and blood glucose values (y). This is basically the only way we could clearly see how the cat's disease is evolving over a long period of time.
If he had just started to take all these values from his cat I guess it would be simple to do, but since he already has a lot of data entered in his spreadsheet, I was wondering if I could use this data (and not write each number in a new document), to make things a little more simple and to avoid mistakes.
View 9 Replies
View Related
Mar 10, 2014
I am creating a spreadsheet utilizing the National Vulnerability Database (NVD) from NIST.
I am successfully able to import the xml files and have the xsd mapped fine.
My problem is within each xml files for each records(1000s of records) there are sub pieces to certain record parts. I.e. software versions (that will be different per piece of software) however they will always fall under prod vendor
"
"
Excel creates a new row for each of these.
How can I make it only create the 1 row and comma seperate those?
View 1 Replies
View Related
Dec 3, 2013
I am trying to attempt to create a payroll spreadsheet with certain aspects and with multiple worksheets. so what im trying to accomplish is this
1/ on my main worksheet would have the payroll template there would be 2 columns (1) would be "routes" (2) would be the dollar value of that route.
2/ i want to be able to pick from a drop down list in colume (1) which will have various routes such as A,
B, C, D, E etc
3/ once i have selected a route in colum (1) i want to have the dollar value that is associated to that route to show up in column (2)
ex/ route A worth $1
route B worth $2
create a dropdown list but thats about it, i have not been able to link any values together.
View 11 Replies
View Related
Jan 11, 2014
I am trying to build a complex equation that has multiple parameters filled by several choices from several different dropdown menus.
For instance:
I'm building a set of 5 dropdown menus, that each lead to filling certain boxes with a number created from a formula. I've provided a small sample to explain what I'm trying to do.
My problem is, I'm unsure of how to make it so certain drop down menus affect the information inside of the next. Like, I want to have someone select "Oscar" under the characters, and have the "Lances" list come up in the Weapons column menu. I don't want the Weapons menu to be selectable in any way unless a "Character" has been selected.
View 4 Replies
View Related
Oct 25, 2007
I'm trying to make a worksheet where I can calculate the cost of a mobile postpaid subscription. It is charged per minute and the cost differs depending on which of the 2 available networks the customer is calling to. The first 20 minutes are free, not depending on network.
Edit:
Charges to network A is 1,79,- per minute after the first 20 minutes are spent.
Charges to network B is 2,29,- per minute after the first 20 minutes are spent.
To sum up:
1. The customer makes a call.
2. If there there are available free minutes, these should be spent first.
3. The customer is charged per minute, depending on network called.
View 14 Replies
View Related
Apr 17, 2009
Problem - billing spreadsheet for prisoner fee.
1 - 8 hrs = $55
9 - 24 hrs = $55 + $65 or $120
Anything over 24 hrs - $65 for each additional (24 hrs) ($185)
So if you were locked up for 6 hrs it is $55. If you were locked up for 18 hrs it is $120. If you were locked up for 28 hrs it is $185. And if you were locked up for 49 hrs it is $250. Cell F5 contains number of hours locked up - I would like cell I5 to calculate the cost of the stay. I am proud of myself for figuring out the date and time subtraction - but this part has me stumped.
View 5 Replies
View Related
