jaywelliott
New Member
- Joined
- Dec 1, 2015
- Messages
- 1
Situation and reason for using solver:
I am using Excel to unravel what combination of credit card charges sum to a certain total found in QuickBooks.
My issue is I have the statements but no notation from the person that posted the combination of charges as to which ones they used to sum to a total posted to say "meals & entertainment".
I have used solver to find a solution and have a screen shot below of the initial set up:
(note, the URL producing website sourced back to my solver example with innappropriate pictures. If someone knows of a image upload site that produces clean URL pages that are safe viewing please let me know).
When I click solve with the parameters you see above, it does not select the charges I know are related to meals.
Question is: why is it not finding this combination? Second, how do I get it to find that combination?
Because there were only a few charges on this card I could easily see that solver did not pick the correct combination.
When I've got a larger sample of charges, I'd like to know it is accurately picking the correct combination.
Here's the result. Highlighted charges per the statement are definitely restaurants. Solver has found another combination that matches my desired total.
(note, the URL producing website sourced back to my solver example with innappropriate pictures. If someone knows of a image upload site that produces clean URL pages that are safe viewing please let me know).
I know of one way to unravel this and that is to try summing a different total of charges to get an answer, then removing those from the values, and rerunning until I actually get to an answer I know is correct. (So I'm testing an easier to find sum for say, travel, then testing everything less travel to find repairs, then everything less travel and repairs to find meals and so on.)
This is the example source for where I found how to use solver for my problem: http://www.k2e.com/tech-update/tips/147-using-excel-to-identify-entries-that-add-to-a-specific-value
Any thoughts on this would be greatly appreciated.
Jay
I am using Excel to unravel what combination of credit card charges sum to a certain total found in QuickBooks.
My issue is I have the statements but no notation from the person that posted the combination of charges as to which ones they used to sum to a total posted to say "meals & entertainment".
I have used solver to find a solution and have a screen shot below of the initial set up:
(note, the URL producing website sourced back to my solver example with innappropriate pictures. If someone knows of a image upload site that produces clean URL pages that are safe viewing please let me know).
When I click solve with the parameters you see above, it does not select the charges I know are related to meals.
Question is: why is it not finding this combination? Second, how do I get it to find that combination?
Because there were only a few charges on this card I could easily see that solver did not pick the correct combination.
When I've got a larger sample of charges, I'd like to know it is accurately picking the correct combination.
Here's the result. Highlighted charges per the statement are definitely restaurants. Solver has found another combination that matches my desired total.
(note, the URL producing website sourced back to my solver example with innappropriate pictures. If someone knows of a image upload site that produces clean URL pages that are safe viewing please let me know).
I know of one way to unravel this and that is to try summing a different total of charges to get an answer, then removing those from the values, and rerunning until I actually get to an answer I know is correct. (So I'm testing an easier to find sum for say, travel, then testing everything less travel to find repairs, then everything less travel and repairs to find meals and so on.)
This is the example source for where I found how to use solver for my problem: http://www.k2e.com/tech-update/tips/147-using-excel-to-identify-entries-that-add-to-a-specific-value
Any thoughts on this would be greatly appreciated.
Jay
Last edited:
