Sorry to say: You're description shows huge deficiencies of excel solver abilities, and if I'm wrong on that you could simply say which one of the three solver classes you like to use. 2 more!
Relevante Fähigkeiten und Erfahrungen
inner systematics of data, solver class, variable solver settings/auto-adjustments (=VBA) or you don't need solver at all, because you go well with simple linear regression techniques
Vorgeschlagene Milestones
₹12333 INR - here: at first it is to declare, if it really is a solver problem!
₹3555 INR - if excel only without solver algorithms or one static linear solver settings only
Zusätzliche Dienstleistungen angeboten
₹3555 INR - Find the right method and tool to automate your problem.