![]() You may download the Sample File – Solver usage in daily life. Then Solver came to my mind! See the demonstration below: To be honest, it would be far more complicating… i.e. Standing in front of the machine, it took me quite a while to figure out the solution.Īfter I got home, I decided to solve the problem in Excel! First, I think of formula. Obviously, the question was: How many stamps of what values should I buy, so as to minimize the total amount to be paid while ensuring enough postal fare? I don’t remember the four options, let say HKD1.7, HKD2.2, HKD3.0, HKD3.7. Then I went to the self-service stamp vending machine to buy the stamps… Wait, there were only four options available. Therefore I went to weigh my small parcels and see how much fare was required for each parcel. There was a super long queue and I was not patient enough to wait. Solver is just for fun to me until one day I went to post office… Nevertheless, I have never encountered a situation that I needed Solver in my work life, so far (probably due to my job nature). I learned Solver in my MBA study a decade ago. I think Solver is not a common tool to most users, regardless of years of experience of using Excel. □ Have you ever heard of Solver in Excel? This post is intended to give you an example of using Solver in Excel to solve a causal problem in daily life – buying postal stamps.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |