DDH Software, LLC Making a big world smaller


Author:Thomas St. Clair [Send Author Email]

August 17, 2015
Description:SHOPPER is a handy means to organize and calculate costs in real time while shopping. I have tried several other programs for these purposes but this one hits the mark for me. After using it and refining it over a couple years I decided to make it available to other Handbase users. The primary data in the download is Winco Foods data, I left it there so you can see the results and different views. To change the Tax percentage used in calculations, choose DB Properties / Fields / Tax [Calculated] Field – Hit the “Configure” button and change the value 0.088 to reflect your states sales tax percent, ensure you don’t change parenthesis or function operators in the field or it won’t correctly calculate.
Has Data:Yes
Has Forms:No
Filters:DEFAULT View – Just add or search for items and check the “GET” checkbox for whatever item you intend to buy, this is also where you choose the store, add a quantity for the item, identify if it is taxed. The current Tax calculation is based upon an 8.8% tax as used in Washington State for non-food items, so here if an item is taxable, the checkbox enables a tax to be applied to the item and Receipt S/Be totals. GET View – Choose this view to filter items with GET checked so your focus as you shop is only on what remains on the predetermined list of items. Check and update the item price and quantity as you shop before checking the GOT checkbox. In the GET View, you simply check the GOT checkbox and it will disappear from the GET list, only items you have in your basket should be checked as GOT. GOT View – If you forget to confirm a quantity or price and have checked the “GOT” box, this is where you would correct the entry prior to check out. Look at the last item total at any time and you can see what it will cost at the register for what you have in the cart, provided you have the correct price, quantity and tax checkbox checked if applicable. Looking at the “Receipt S/Be” field of the bottom item in the GOT view will be what you pay provided your items are correctly priced and the Tax Calculated field has the correct tax percentage for your state. CLEAN UP View – This is a view used to uncheck the GET, GOT, QTY, and Price (if need be) so you can work toward the next trip. I always clear the price of an item as the prices change constantly, however without a quantity for an item, there is no consequence to the “Receipt S/Be” or tax fields for items containing a price. TAX View – This simply hides all items that are not taxed so you can quickly see if an item you know should be taxed is not configured to be taxed. I checked 3 items that are taxed in Washington as GET / GOT, look at the data in Default View and you will see TAX applied to those items. Note that items Taxed checkbox can be checked but no tax is calculated until there is a check in the GET checkbox.
Sorting:This databases Sort order is currently Product – Forward, if changed to a different field or Reverse, R-Total and RT TAX will appear different, simply because they calculate to sort order based upon the prior record, this has no bearing on the calculations, just the amount shown for running total fields when the sort order is changed.
Reports:There are no reports or printing required, this is a use as you shop program you personalize and keep up to date for the stores you utilize.
Comments:The Notes field is for item specific notes regarding individual items, brand, color, size, things of that nature. I use it when my wife knows a product she had added to a list, but her description of where I find it in the store sounds less than definitive. The R/T Field is the Item Totals sum for every item selected as GET without Tax applied. The Receipt S/Be Field is the R/T Field combined with Tax for all items with the GET CheckBox Checked (Provided the TAX checkbox is appropriately checked where applicable and the TAX amount reflects your states Tax Percentage. For items sold by the pound or gallon etc., simply enter the appropriate amount by unit of measure into the QTY field. I.E. > I checked Bananas as a GET / GOT for 2.5 pounds, resulting in item total of $1.40. I use a Sony Clie and use this database every time I shop, you can change the Aisle for items in your store and sort by isle for easy picking as you shop. Use of this database has made my trips to the store much more efficient and productive.
Version:HanDBase v.4.x Enhanced or greater
File:shopper.pdb          Downloads: This Month 65 / Total* 1552
Note:MAC Users will need to enter the filename shopper.pdb when saving this file.
* since October 1, 2000.

Other Titles from Thomas St. Clair

02/09/2004 MeetingAgenda.pdb [Automobiles]
This is a database to arrange agendas for meetings. The layout allows you to capture ideas as you work and categorize the agenda content based on meeting type, priority, category. When you have the content established within the database, just export to Microsoft Word and the AGENDA will materialize as a table, you can format and make changes from there. Remember that any changes made in word should be copied back into the database for history and so it is current. Word allows a detailed spell check and font and structure manipulation.

09/30/2006 Docs2HR [Business Tools]
A simple database to track forms submitted for various reasons within an organization. Managers and Supervisors have typically seen how easily important documents get mis-placed, mis-filed, lost or tossed. This database simply records the form type, date of submission, relevent associated parties, and brief description for why the form was submitted. It has been a crucial piece of evidence in many past conflicting stories about whether or not a given form was ever submitted, when it was submitted, who it was submitted to, who by, etc. etc. etc.