Hi
Referring to Post #14 just above
These lines
Set rngY = ws.Range("B2:B15" & lr)
Set rngX = ws.Range("C2:G15" & lr)
Should be
Set rngY = ws.Range("B2:B" & lr)
Set rngX = ws.Range("C2:G" & lr)
and
RegOutput = Application.WorksheetFunction.LinEst(rngY...
G'Day All
I have found another setting and tweaked that, so not sure if have to log out/in to enable it
If it doesn't show up, I dont have God mode access to go further into the setup
So maybe a Question for Chandoo
BigJohn
This is something I've wanted for ever, and for some reason your post inspired me to tackle it.
What I did using step by step below works a treat as shown here !
The Excel file is attached!
What did I do
I used QGis a GIS Package
I setup a new project using a GDA94 Spheroid
I...
In the original post the data was discrete and it was quite permissible for events to overlap
In the original post the locations of the shapes represented times and movements
You could loop through the shapes and adjust them, but you'll need some logic to define how far?
Then you loose the...
Thankyou VLetm
Cross Posting is generally considered poor form, as people don't follow up and close of solutions on all forums.
This can cause people to both waste time, and miss great solutions
I am sure the OP will not do that here ?
I think your formula in column F is incorrect
F2 should be : =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2
then copy it down
G2: can then become: =SUMPRODUCT(($D$2:D2)*($A$2:A2=A2))/E2
copy it down
Please check those manually
Startdate and days are named formula
They will need to be defined on the other pc
also Table 4 must have the same name
Also the usercontrols have custom names, so check those exist
It is really not clear what result you want?
Can you expand the description
If you just want to do a lookup, on sheet: Form II, type the following anywhere
=INDEX(AFC[Component Details],MATCH(G6&L6,AFC[Concatenate],0))