Samples

Frequency Interference
Mortgage Rates

Frequency Interference

Below are screen shots of the "Intermod Calculator" -- a spreadsheet developed for Sound Engineers who use this spreadsheet to determine whether or not they can expect frequency interference between frequencies with which they will be working. The Intermod Calculator is an excel macro based spreadsheet for calculating 2nd and 3rd order harmonics (including “Triple Beat" 3rd order harmonics) of radio frequencies specifically for RF microphones, IFB's and Intercom. It calculates up to 200 frequencies and tests them against each other, highlighting any intermods.. Please note that the spreadsheet works on both PC's and Mac's!

This spreadsheet uses three tests for calculating intermod. The first test first test checks to see if any two frequencies are within the user defined tolerance by running all frequencies input through the equation A-B where A is the first frequency and B is the second. The second test checks all frequencies using formulas 2A+B, 2A-B, 2B+A, & 2B-A -- the result is then tested against all the other frequencies in the list checking to see if it is within the user defined tolerance. The third test checks all frequencies using formulas A + B - C, A + C - B, C + B – A where A is frequency 1, B is frequency 2 and C is frequency 3 - like the prior tests, the result is then tested against all the other frequencies. Any hits from the three equations are listed by cell location and highlighted for easy reference.

To purchase the Intermod Calculator, first click on this link to download the spreadsheet. Next, simply use Paypal.com to send $25.99 to robert@bizsolution4u.com. As soon as payment is received, you will be sent the password needed to unlock the spreadsheet. Please allow up to 2 business days to receive the password. If needed sooner than 2 days, you may call 408-930-1342 to expedite.

Figure-3. Before "Test" button is clicked

Figure-4. After "Test" button is clicked

Top

Mortgage Rates

This script takes a mortgage banker's rate sheet and does the following:

Converts the rate numbers into a format which loan agents are familiar with seeing

Converts the raw data into a presentable format(tabular, important text/data highlighted)

The code also accounts for new columns and/or rows being added to the raw data -- all you have to do is click the "Setup" button which executes the code which in turn results in the new rows and columns being formatted as desired. To inquire about having Bizsolution4u create a similar spreadsheet customized for you, please contact us.

Click here to download the spreadsheet and run the macro for yourself!

Please note the following in order to ensure the macro successfully runs:

If using MS Internet Explorer, it is recommended you save the file to your desktop (you can then open the file from your desktop and run the macro)

The "Analysis Toolpak" add-in must be loaded in MS Excel in order for the macro to run successfully. Follow the simple installation steps below to do this:

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.
If necessary, follow the instructions in the setup program.

Figure-1. Raw data

Figure-2. Processed data

Top