Make Your Microsoft Dynamics Investment Count & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.
Become a Premium Member and unlock a new, free course in leading technologies each month.
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
(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).
If you are experiencing a similar issue, please ask a related question
Title | # Comments | Views | Activity |
---|---|---|---|
Take Space out of Email | 11 | 42 | |
Track use of a script by logging username, date & time to an excel file. | 4 | 53 | |
VBA to trim leading and trailing spaces in all sheets of active workbook. | 2 | 18 | |
Zip Codes Excel Spreadsheet | 4 | 22 |
Join the community of 500,000 technology professionals and ask your questions.