C8:I2 is a matrix, not a vector .... ????
There are "nodes", "points", "instruments", etc.
I've built a trial spreadsheet but don't understand what the values in rows 2-8 represent. Measurements over time? or?......
(1) I am unable to replicate your results even just for the base case (equal weights for nodes and instruments). It appears that my original formulae have been retained, therefore it would be very helpful to see what caused the difference. Would you be able to share how you set the solver up?The first case used I11:I15 as the variable cells.
I am looking at variant 3, i.e. any one instrument retains the same weight across nodes (as this is a necessary condition), but each node may be assigned a different weighting.Correct.
Where exactly are the node weights specified? I do noticed you have a row (64) ‘Node Weight’, but these numbers are in the order of magnitude of millions? (for weighted least squares, my understanding is that the weights are specified in the format of 1/(y^2).They are specified in Row 64. This really has nothing to do with least squares, it's just a scaling that goes along with each node. Then these node weights are also "variables" in the Solver and are given a wide range (actually the same range as the other variables just because I didn't know any better).
Title | # Comments | Views | Activity |
---|---|---|---|
Prevent user inserting rows manually | 28 | 46 | |
Relative link_location when pasting a =HYPERLINK() formula to a different cell in Excel | 7 | 18 | |
Index/Match with Multiple Criteria | 2 | 15 | |
#value when i have 3 or more values | 3 | 0 |
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
20 Experts available now in Live!