![]() |
![]() |
![]() |
![]() |
Spreadsheets for check book registry, payroll systems, Pa. lottery games, and more. All our spreadsheets have a documentation and discussion text file with them to explain the macro's and help you modify and learn how they are put together. Contact us for more information. |
Here's our e-mail link: LdL_Enterprise
![]() |
We've entered the Pennsylvania lotteries in databases for years. The image shown is the Pa. CASH-5 game, input area. Currently we have the Pa. CASH-5 game since inception with about 1200 games entered, the Pa. SUPER-6 game since inception with about 77 games entered, the Pa. WILD-CARD lottery in its entirety, and the Pa. super-7 game in its entirety. All these sheets function basically the same in that they all have a macro for inserting a new set of numbers that were picked, a macro to make a report for the most frequently picked numbers in the last 25, 50, 75, 100, 200, and all games, a macro for inputting any range of games to sort for frequency numbers picked, a what-if check to see what a set of numbers would have been worth, an area for panoramic viewing the database, and a save macro that reverts formulas to numeric value to save disk space and, More info.. |
The image on the right shows the top of our check book register. A macro is used to insert a new row into the register and after entering the data, balance the book. We have a column for letter codes to group checks, a column for bank charges, one for timing (monthly,weekly,ect.), and a column for comments that allow us to query the register for all kinds of useful information. Also on the top of the sheet all the letter codes are present and a macro is made to keep a running tab of all the groups. For more information, click here |
![]() |
![]() |
This image is our home loan amortization sheet. We'll show you how to convert the formula to your loan amount and schedule. This sheet is handy for doing what-if's with in that you can enter any amount and see how it effects your loan in terms of length and interest paid. |
Our payroll spreadsheet started out as a way to check employers to be sure of a correct pay check and eventually grew into a system that I used for many years to do the payroll for a union shop. The sheet calculates all tax rates including the federal tax using a lookup table that is easily convertable to reflect the FEDS yearly changes in that it uses variables for the with-holding rate and the percentages relieving you from re-writing the formulas and merely changing the variables. The sheet has several look-up tables that are personal data, the pay scales, and the fed tax rate. The image shown is the printout that we used to FAX to the employer so they could make out the checks. The whole process of calculating the payroll took about 15 minutes with most of that time opening the spreadsheet, closing it, then opening DBASE, closing it, then opening a fax program to send the sheet to the shop, on a 33mz "386", before windows. We would then print out the calculation area (3 sheets wide) with all the data for the week, month, quarter, and year to date totals and deliver the hard copy to the employer. In the documentation we will explain how to modify this sheet to do even simple payroll needing only basic tax deductions. We've modified this sheet several times for different busineses with different needs. The example shown is extreme in that they needed many pay rates, a lot of union deductions, and had several employees both union and non-union. If you want to, or need to do your own payroll go here for more details |
![]() |
![]() |
This image is from a spreadsheet of five letter words from the "official" dictionary that was used in word building puzzles. The jist of these puzzles was to assign a numerical value to each letter of the alphabet and arrainge them in a crossword puzzle frame to accumulate the most points. A macro is used to assign the values to each letter, another macro calculates the word values,then another sorts the columns putting the words with the highest value on top of the column. This spreadsheet has five letter words and we have sheets with 2, 3, 4, 5, and 6 letter words that work the same. After winning some $ from the promoters they quit sending the puzzles to us, probably because we never bought there official word lists. Oh well ! If you need them, here they are. |
Here's our e-mail link: LdL_Enterprise
©LdL Enterprise 2001-066-24