Hi,
AS a part of my daily work I pick workitems from different team members from a consolidation sheet that will have their daily production.
As per my sampling I will have to take two workitems per employee every day. How can I do that by using Excel macros?
AS of now I'm using a macro which will pull every nth row from which Im getting the sampling as per the percentage I select, but going forward, I would be needing fixed number of rows from each employee
Example of how the consolidation sheet looks like:
Name
Date
Workitem #
Employee1
11/3/2009
W001234-04Nov09
Employee1
11/3/2009
W001544-04Nov09
Employee1
11/3/2009
W005234-04Nov09
Employee1
11/3/2009
W001624-04Nov09
Employee2
11/3/2009
W00134-04Nov09
Employee2
11/3/2009
W00544-04Nov09
Employee2
11/3/2009
W012234-04Nov09
Employee2
11/3/2009
W023624-04Nov09
Note: This lost goes on to 50 employees, and the count of Workitems worked will not be the same for all.
Any help on this is truly appreciated..!!
Many Thanks!
Swaroop
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
Hi Everyone,
Is there a formula in Excel that can easily find the "normal approximation to the binomial distribution"?
I currently have the formula =BINOMDIST(5,10,0.01,FALSE) to get the binomial distribution.
Any help would be appreciated.
Hi I was just wondering you there is a way of doing an advanced sampling using the analysis tool pack.
I have 60 males, 30 females and I want to take a random sample of 30% of the males and 50% of the females.
Is this possible? Anyone have any ideas?
Thanks,
Charmed (as usual)
Hi,
I have no clue how to randomly select a random sample using excel , I looked at the youtube but the videos were too fast and I couldnt follow them.
Thanks
I had requested file earlier and Martin Wilson graciously helped me out with my problem. I have another issue in the same file.
In the attached excel file, I have raw data which needs to be randomly sampled.
1979-2008
Here in the excel I am computing averages. What I need to do is incorporate a formula if a cell is selected.
1: Treat the cell selected as T7. Move up 7 years and select cell as T1 and incorporate the following formula --> (T7/T1)^(1/7)-1 which will give me the compounded annual growth rate. Example: if the random cell selected is August 2000 (H23 in Excel Sheet1) then the formula will be such (H23/H17)^(1/7)-1 . this also means that the cells above 1985 cannot be randomly selected as the simulation will move up....
Additionally on Sheet 2, I want the data to move up and select seven 12 month periods i.e. if Random cell is May 2000(in excel sheet 2 - H23) then the seventh period should be June 1993 (in excel sheet 2 - I17). the simulation should average all the cells in between, rows and columns.
I have been trying and trying but can't seem to get it to work. Please help Thanks
Rahul
I am trying to do something like:
Code:
dim my_array(x, y) as variant
but I do not see a way to work around this.
Currently I have a solution which is to simply declare the array with constant values way larger than the array will ever need to be. This seems to be inefficient. Is there a better way to declare an array in which I cannot predict it's dimensions?
Hi everyone
I've got a PivotTable which counts information that is split down into years and categories. I'd like to work out the proportion of the categories for each year and am unable to do this.
I've edited the field and changed the 'Show data as:' to '% of total'. However, this shows the splits as a proportion of all the data. What I'd ideally like is a '% of sub-total', but such a thing doesn't seem to exist.
Does anyone know how I can do this? I'm running Excel2000.
Any help much appreciated, kind regards
Nick
Hey everyone,
I am trying to paste a logo into a protected worksheet, and make it a certain height (the width is not important, but it needs to be to scale). The problem i have is that the logo will change (i am making a template), and the size each client logo is different. I have managed to get the picture pasted in using this code (which i found on some other help site):
Sub Insert_Pict()
Dim Pict
Dim ImgFileFormat As String
Dim PictCell As Range
Dim Ans As Integer
ActiveSheet.Unprotect
ImgFileFormat = "Image Files (*.bmp),others, tif (*.tif),*.tif, jpg (*.jpg),*.jpg"
GetPict:
Pict = Application.GetOpenFilename(ImgFileFormat)
If Pict = False Then End
Ans = MsgBox("Open : " & Pict, vbYesNo, "Insert Picture")
If Ans = vbNo Then GoTo GetPict
GetCell:
Set PictCell = Application.InputBox("B3", Type:=8)
If PictCell.Count > 1 Then MsgBox "Select ONE cell only": GoTo GetCell
PictCell.Select
ActiveSheet.Pictures.Insert(Pict).Select
ActiveSheet.Protect
End Sub
My problem is i can only find code to scale the height and width of the logo using ScaleHeight and ScaleWidth, which is not what i want. I want to set the height of the logo, and keep the proportations.
Can somebody help?
Maybe you guys could take a break from giving free technical school
answers to lazy partiers and try this fun problem. I dreamed part of
it last nicht.
How do I transpose an array of words and numbers into an array of
different proportions?
The proportions of the arrays can be anything, including n x 1 and 1 x
n.
The size of the array can be anything that fits on a worksheet and can
be located anywhere on the worksheet.
Ex:
Array of the present (4x5)
ab 12 de 1.55 ghe
ef 34 nu 3.65 unt
gh 56 mc 2.45 wen
kl 78 vm 1.35 rep
After a re-arrange (7x3)
ab 12 de 1.55 ghe ef 34
nu 3.65 unt gh 56 mc 2.45
wen kl 78 vm 1.35 rep
I am uncomfortable with VBA so don't use VBA.
I don't want to copy/paste because I want the second array to update
immediately when I change the values in the first array.
Also another reason I don't want to use VBA is I would necessitate to
run it after every update.
Thank you and have a good evening,
Manfred Straub
(originally from east Zurich)
