Three Pill Sizes For A Specific Dosage
May 4, 2014
Vitamin B1 capsules come in three sizes - 100mg, 500mg and 1000mg
Our doctor prescribes dosages from 100mg up to 5000mg a day
I want to update our stock of tablets for each dosage level.
For example 600mg is 1 x 500mg capsule + 1 x 100mg capsule 0 1000mg capsules,
4900mg = 4 x 1000mg caps + 1 x 500mg + 4 x 100mg
We give out a kit which has in total 100 x 100mg capsules,60 x 500mg and 75 x 1000mg capsules
I want a set of formulas to calculate the nubers of each tablet at the daily dosage level between 100mg and 5000mg
Cell A1 = Daily dosage in mg
Cells A2 = number of 100mg capsules in that daily dosage - what is the formula ?
Cell a3 = number of 500mg capsules in that daily dosage - what is the formula ?
Cell a4 = number of 500mg capsules in that daily dosage - what is the formula ?
View 12 Replies
ADVERTISEMENT
Feb 21, 2014
I am building up a formatted invoice, line by line all of which is working well from the data point of view but no quite so well from the presentation point.
My text is all in Arial 12pt and I have the row height set to "Auto" and cell alignment to wrap text (at least one cell per row often has 3-4 lines of text so I need "text wrap" on)
My issue is that the printed output from a multi row invoice looks "crowded" and as this is the view the client gets to see (and hopefully pay ) the look is important. I tried to set the row heights to say .71cm but that causes the text wrap to stop working correctly.
I think I am trying to get some form of "inside top" and "inside bottom" adjustment / fill / padding (which is what I would do if I was using some form of documentation tool like Madcap Flare for example) but I cannot see how to do it in excel.
View 9 Replies
View Related
Jun 11, 2014
can buy stock glass in several standard sizes. Specifically:
12x16
16x20
20x24
22x28
24x30
24x36
26x32
32x40
36x48
40x60
I use these stock sizes - to cut custom sized pieces. Example - if I have a piece that calls for a 15x18 - I will take a 16x20 piece and cut it down. I have all different kinds of size combinations that come up and am looking for a way for Excel to calculate the most efficient stock size to start with. Trying to do so using a series of Vlookups and if then's - but seems to be overly complicated and not always accurate.
View 5 Replies
View Related
Apr 19, 2012
I have a report with graphs and slicers and I have a 22 inch monitor. All of the graphs and slicers fit on my screen size but when others open it everything doesn't fit because they have a smaller monitor. Is there a way to auto adjust the report to adjust to individual screen sizes. I want the data from A36-V36 to fit on the screen at the same time. Not sure if this is possible though.
View 5 Replies
View Related
Jul 31, 2007
I have 2 colums that represent the height and width of a paper edges. And now I would like to find a formula (somekind of an IF?) which would calculate automatically (taking account the values in these colums) which of these 2 measures make together ISO paper sizes A0 (84,1x118,9), A1 (59,4x84,1), A2 (42,0x59,4), A3 (29,7x42).
View 2 Replies
View Related
Mar 26, 2014
I have hundreds of column graphs, how do I quickly change the size of them to the exact same size of 8.1cm height and 26.4cm width.
View 1 Replies
View Related
Oct 24, 2007
using the ttest formula function
View 2 Replies
View Related
Jun 23, 2009
Sorry for the question. Normally I find answers to my excel questions by going through the help tab or by searching on Google. However, I don't even know what question to ask on this one!?!
Basically I have created a spreadsheet with several columns, but I have one column that lists the shirt size (YS, YM, YL, AS, AM, AL, XL, 2X, 3X) of each person. Is there a formula that I can create that will tabulate the number of sizes (i.e. AS=2, AM=7, etc.)?
In previous years I made a column for each size, and simply placed a "1" in the correct column, and had excel just add the 1's from each column. However, that takes more time and space. I was hoping to streamline it this time around.
View 6 Replies
View Related
Jun 10, 2014
I have a file with a lot of tables of different sizes. The table ranges have not been named. I would like to use a macro to insert 20 blank rows between each of them.
View 3 Replies
View Related
Jun 9, 2009
Is there a way for me to have combo boxes, labels, and command buttons to be moved to a set position rather then just moving by intervals? What I need this for is every time one of my worksheets opens it refreshes the data and does this via lookup formulas and a macro that searches for values and deletes the rows with the matching values, it also adds rows to the top after it is done deleting. This causes all my controls to move randomly and I need some code to reset them to their original sizes and positions after the code that adds and deletes rows is done running.
View 2 Replies
View Related
Dec 18, 2013
I am working with the attached sheet and it is made up of groups of rows that alternate with a 6 digit NAICS code (industry code) then an aggregation of those codes into a more general 3 digit NAICS. I need to have the row with the 3 digit NAICS code calculate a number that multiplies a column called "% of industry" by several columns of of numbers and then sums the result into a cell in that 3 digit NAICS row. Different groupings have different numbers of rows. I would like to know if there is a 1 cell formula that can achieve this and be easily copied down the sheet to the other 3 digit NAICS rows.
You can see in row 37 this formula being executed for a simple 2 row aggregation. But that would take forever to replicate down the sheet, especially for the larger aggregations.
An example for row 32 that achieves the desired result and could be easily copied down the sheet.
3 digit Table.xlsx
View 5 Replies
View Related
Oct 25, 2009
On attached Spreadsheet, we are using Vlookup to create Team pages for coaches. Works great for giving coaches a team sheet when they leave draft. I have been aasked if we can cultivate the info a little differently for ubiform screenning. Company wants a count of sizes by position, that is everyone in position 1 will get number 40. How many #40 AS, AL, AM do we need.
There are 157 teams. SO I need to loop throgh each team, pull each size for each position and put it on Size sheet. I was thinking a vllookup/countif or sumif combo would work but have not been able to come up with it.
View 2 Replies
View Related
Aug 27, 2013
I have a workbook that has multiple tabs with data already entered. I have also built a series of tables/forumlas to display summaries of the data. My desire is to be able to copy this table with all formulas/formatting/cell sizes to the various existing tabs.
View 3 Replies
View Related
Jan 16, 2014
I have a line that is commented out in the bottom - that is an example of what types of filters I want to do but dynamically. Users choose multiselection from a list box then it filters the sheet for them. It is pulling the data from the listboxes but when it is more than one item it is Putting the whole thing in as if I said text = "ABERTI", "AMALON", "BCASTE", "BGELLE", "CFRANC" - No I want to filter by each of these (it believes this is one long string)
Here is the code:
[Code]....
This code does not filter correctly.
View 2 Replies
View Related
May 8, 2012
I am using Excel 2010. I have a spreadsheet where column A is for Quarter, column B is for Employee, and columns C-R are for Codes (Code1; Code2; Code3; etc. through Code15). One line might have no values in the codes columns, another might have values in only Code1, another might have values in Code1 and Code2, and another might have values in all 15 columns.
A B C D E F --> R
1 Qtr Emp Code01 Code02 Code03 Code04 --> to Code15
2 2012.1 Liz CER02 INS12 WKH15
3 2012.2 Jim PIN55 WKH12 WKH19 WKH23
4 2012.2 Jon
5 2012.2 Jim WKH15 WKH23
6 2012.2 Jon PIN55 WKH15 WKH12 CER08
The worksheet is named "ALLAUDITS" and the named ranges are as follows:
Quarter: =offset(allaudits!$A$1,0,0,counta(allaudits!$A:$A),1)
Employee: =offset(allaudits!$B$1,0,0,counta(allaudits!$B:$B),1)
CodeData: =offset(allaudits!$C$1,0,0,counta(allaudits!$C:$C),15)
On another worksheet I need to be able to count how many times WKH15 appears in the CodeData range within a certain Quarter. I tried
=countifs(Quarter,"2012.2",CodeData,"WKH15")
But that didn't work, and from what I can tell in Excel support, it's because the ranges are different sizes. I have over 6500 rows, so I'm trying to avoid having to name all 15 columns and then do a sumproduct on all of them, such as
=sumproduct((Quarter="2012.2")*((Code1="WKH15")+(Code2="WKH15")+.......)))
Calculation would take forever.
I could just create a pivot table based on the "allaudits" worksheet, but I can't figure out how to get the actual codes as the row headers (instead of Code1, Code2, Code3, etc.).
View 3 Replies
View Related
Sep 24, 2008
I'm an excel novice. I am trying to create a chart that assigns a range of foot measurements to each shoe size, but the data I am working with has only one measurement for each shoe size. Example: The data I have says:
size 7 = 250mm
size 7.5 = 255 mm
size 8 = 260 mm
So I want to create a formula, so the chart reads something like:
size 7 = 247.5mm - 252.5mm
size 7.5 = 252.5mm - 257.5mm
size 8 = 257.5mm - 262.5mm
I'm using ms excel 2003 on windows vista
View 2 Replies
View Related
Mar 17, 2012
How to change these defaults...
It involved opening a new workbook and changing the number of worksheets in a new workbook, cell sizes, font, and font sizes... and then saving the workbook in one of the system folders under the name "workbook" to change the default workbook attributes, or "worksheet" to change default worksheet attributes.
View 3 Replies
View Related
Sep 15, 2012
i want to paste a worksheet with amended cell sizes and also some clipart pasted...to another workbook in same style(excel 2007). when i do that, it says 'data on clipboard may not be of same size.......' and paste in different size.
View 1 Replies
View Related
May 14, 2013
SIZE-help.xlsx
I need to show the sizes to shows from column A to show in column b.
View 4 Replies
View Related
Jan 30, 2014
I would like to have a Macro to go from the first tab called "Start" and end up with the second tab "End" automatically. BAsically I need to take the product on each line under Tab Start and reproduce it for sizes 35-41 always ending with "-(size)". Then this new Product with Size needs to be multiplied one below the other for as many times as I have pictures (number shown under column B of the tab Start). Next to this value in column B of tab End I'd like the same name listed again but with the number 1, then 2, then 3, etc. as needed and the extension .jpg.
View 4 Replies
View Related
Nov 9, 2006
Im trying to create a simple 3D Bubble Chart macro, and as most people who've never dealt with this before (i think), i've hit a wall with BubbleSizes. I've attached the file im trying to get to work. The VBA is quite simple but an error occurs at BubbleSizes. I've read that BubbleSizes takes a different reference style than xValues and such, but haven't had any luck trying to change that. For those who just want to see the code without getting the file:
Sub EmbeddedChartFromScratch()
Dim myChtObj As ChartObject
Dim rngChtData As Range
Dim rngChtXVal As Range
Dim iColumn As Long
' make sure a range is selected
If TypeName(Selection) <> "Range" Then Exit Sub
' define chart data
Set rngChtData = Selection
' add the chart
Set myChtObj = ActiveSheet.ChartObjects.Add _
(Left:=250, Width:=375, Top:=75, Height:=225)
With myChtObj.Chart................................
View 5 Replies
View Related
Apr 16, 2014
I would like to change the greater than number to the value in cell 'I11' in sheet 'Linear Programming Data' and the less than number to the value in cell 'I12' in sheet 'Linear Programming Data'. The code I am using was done by recording a macro since I don't know how to code in vba.
Code:
Sub Results2()
' Results2 Macro
' copy table filter power by greater than and less than
Sheets("Finalizing Results 2").Select
Cells.Select
[Code] .......
View 2 Replies
View Related
Nov 7, 2008
I have a protected template and unprotected source worksheets - - - what I would like to happen is for the macro to start and if the source worksheet cell B3 equals "Report Total" then stop - otherwise copy template worksheet then copy 6 specific cells from the source to paste values to specific cells on the newly created worksheet (B_ to C7, D_ to I7, E_ to C9, F_ to K9, A_ to C11, M_ to K11 and then K13=F13-30)
After that then start all over again unless the next row’s cell (B4, B5, B6, . . .) is "Report Total" then stop - - - the row count could be from one to a couple hundred.
Here is what I have so far but I know that with each copy the name will change and as it goes down the source file each row will change and I also need help with that.
Sheets("ee template").Copy After:=Sheets(3)
ActiveSheet.Unprotect
Selection.ClearContents
Range("I7").Select
Selection.ClearContents
Range("C7").Select
Sheets("source").Select
ActiveCell.Offset(0, -11).Range("A1").Select
View 9 Replies
View Related
Apr 21, 2006
I am trying to run a macro once a particular word shows up in the combo box. now in my chase i could try to use VBA code to run the macros such that once the arrow is used in the combobox to select a certain word a particular macro labled the same name as the word chosen would run.
View 5 Replies
View Related
Oct 9, 2009
Here is what i am trying to achieve. If the date 2/20/2010 is located at F53 & the cell next to it at H53 is populated with a number between 1 & 16, then i want the cell at J11 (42 rows further up) to auto populate with the number 1. When this occurs the cells beneath this, from J12 to J52 should also auto populate with the with consecutive numbers from 2 to 42. Would also like to see the cells with numbers 1 to 28, automatically format to orange & the cells containing numbers 29 to 42 automatically format to yellow. I plan to have this condition repeat several times later in the year, at dates that are to be decided. When these dates are decided i want to be able to enter a number from 1 to 16 & next to the date & all of the above automatically occurs.
View 14 Replies
View Related
Apr 4, 2013
Is there a way to format cells to where - when you type in a certain person's first name, it will insert something entirely different?
This has seemed to have happened on a computer at work.
In Excel, when I type in "Martha" then tab, or otherwise leave that cell, Martha changes to "Cool"
If I type in anyone elses name - it stays that name. But if I type in "Martha" .. it changes to "Cool" with the bullet and the word Cool.
View 6 Replies
View Related
Jul 1, 2014
Looking to have a macro call a subroutine every time it finds a cell meeting specific criteria.
Code in plain english would look like this:
For EACH cell in range A1:BZ500 meeting the following criteria:
Cell value is a date
AND
Cell's date is at least a week or more in the future
AND
Cell background (Fill) = RGB color code: (R:191 G:191 B:191)
DO the following:
Call repeatingsub
View 11 Replies
View Related
Apr 29, 2013
I have a worksheet that contains two basic columns of data, A and B. What I would like to do is based on the value in column A, I would like to copy the contents of column B to a textfile (preserving the basic line structure and hopefully without any extra characters like quotation marks attached). So for all the values in column A = 'Account', Id like to take all the corresponding values in Column E (for example) and save them to the same file, preferably where the filename itself as 'Account.xyz'. And I would like to do this for all unique values in Column A, that is do it for 'Account' and 'AccountPrivilege' etc. Note Column A is essentially presorted alphabetically already. There are actually 1000s of rows with hundreds of unique A values so Id like to find a way to automate this process.
A
B
1
Account
Company Information
2
Account
Company
[Code] ........
View 2 Replies
View Related
Mar 26, 2014
I got Excel for Mac 2011 installed. I have a table called 'Raw" that holds data from the beginning until the end of 2013 (in total ~7000 rows). I have columns for Category, Start and End time, and time period in Hours, Minutes, and Seconds:
Code:
A
B
C
D
E
F
Category
Start
End
Hours
Minutes
Seconds
Transportation
2013/01/01 01:00:00
2013/01/01 01:15:00
0:15:00
15:00
900
[Code] ...........
I'm trying to get an overview of how much time I've spent in January on Transportation. I would need to look at the Category entries for Transportation, then only use the ones which have the Start set to 2013/01, and then take the Hours/Minutes/Seconds, and summarise it in a new table called 'Data':
Code:
A
B
C
D
E
F
Month
Category
Occurrence
Hours
Minutes
Seconds
2013/01
Transportation
48
[Code] .......
I have figured out a way to count the occurrences for Transportation for January:
=COUNTIFS(Raw!B:B,">="&"2013/01/01 00:00:00"+0,Raw!B:B,"
View 1 Replies
View Related
Nov 30, 2007
So, this works perfectly by itself: {= SUM(IF(MONTH(I4:I17)=1,G4:G17,0))}
And this works perfectly by itself: {=SUM(IF(YEAR(I4:I17)=2007,G4:G17,0))}
But this doesn't work at all: {=SUM(IF(AND(MONTH(I4:I17)=1,YEAR(I4:I17)=2007),G4:G17,0))}
SUM by both a specific month, and a specific year from a single date field?
View 3 Replies
View Related
