Mag-Probe Spreadsheet

How Mag-Probe Spreadsheet Works – Short Version – Spreadsheet Included

How Mag-Probe Spreadsheet Works

Mag-Probe Spreadsheet

Helping America Raise Their Bottom Line

This Spreadsheet is simple and very easy to use.  Simply type your numbers into the Green Boxes of the Mag-Probe Spreadsheet.  For accuracy the 1st, 2nd and 4th green box numbers in the voltmeter column will automatically be duplicated in the red Mag-Probe column.  They will have to be the same number in order to get a correct downtime computation. The only numbers that will be different will be the “Time it Takes to Conduct the Same Test”  Please read the following 4 points before using the spreadsheet.

  1. Total Number of Facilities – You can enter the number of your facilities that make the same test.  The spreadsheet will then multiply the time it takes to make the test for a voltmeter and the time it takes when using a Mag-Probe by the number of tests made per week and convert it to the amount of money you are losing by not using Mag-Probes in all your facilities.
  2. Technicians Wage or Production Cost (per hour) – Here you will enter the technicians hourly wage (which will work for service oriented maintenance calls) or your production cost per hour for manufacturing plants, bottling plants, shipyards or anywhere solenoid valves, relays, or coils are used in the production process.  (Special Note: The dollar sign will appear automatically once you hit the enter key)
  3. Time It Takes To Conduct The Test (in minutes) – These are the only boxes that will have different entries (in these boxes you will be entering different times) you will enter the time it takes you to conduct a particular test using a Voltmeter and then enter the time it takes you to conduct the exact same test using a Bartol Mag-Probe in the Mag-Probe Column.  (Special Note: This entry must be entered in minutes)
  4. Lastly, is the Tests Conducted (per week) –  This will be how many tests you did with a voltmeter each week and now you are using a Mag-Probe instead to conduct the same test. This number should also be the same number so it will automatically be duplicated in the mag-Probe Column.  If you only conduct one of these tests per month or even 2 or 3 refer to the chart below.

.0625 = 1 Test Every Two Months

.25 = 1 Test Per Month

.50 = 2 Tests Per Month

.75 = 3 Tests Per Month

    1 = 4 Tests Per Month


(To Re-Enter Different Numbers Double Click the Green Boxes to Delete Old Ones)

(Numbers May Vary Depending on Required Testing Protocol)

Your Numbers Will Not Be Saved

If You Include Your Company Charge Number

We Will Ship the Mag-Probe To You Anywhere In the World

“Mag-Probe Bullet List”

 👁‍🗨 No calibration required

👁‍🗨 Works effectively from -80 to +160°F

👁‍🗨 Requires no direct electrical connection

👁‍🗨 Suitable for high risk explosive environments

👁‍🗨 Waterproof, not affected by corrosion or salt spray

👁‍🗨 Ability to check solenoid valves and relays while equipment is operating

👁‍🗨 Isolates problems as electrical or mechanical in seconds, without a schematic

👁‍🗨 Detects transient pulses and momentary loss of power as low as 10 milliseconds

👁‍🗨 Detects residual magnetism – Great for checking relays before installing on aircraft

👁‍🗨 Long life power source and low current LED lasts for at least 5000, 5-second operations

👁‍🗨 Variable Sensitivity – detect 1 gauss using ring magnet – 3 gauss without using ring magnet

👁‍🗨 Reduce Sensitivity by sliding on the white protective shield – Reduce detection of overlapping magnetic fields

👁‍🗨 Magnetic sensing instrument used to troubleshoot AC and DC powered solenoids, solenoid valves, relays and heat controllers

3-1/2″ long. Wt: 1 oz. (USA) High Sensitivity Model, for all Electrical Solenoids, Relays, Coils and Reed Relays


Mag-Probe Spreadsheet

Mag-Probe Interactive Downtime Spreadsheet

Again The profits generated by reduced troubleshooting time make the Mag-Probe the obvious choice for a CEO, President or Owner, of any service or manufacturing company.   Why?   Because typically the return on your Mag-Probe investment will be one test.   The Mag-Probe is guaranteed to conduct 5,000 five second operations. So after the first test, you can begin recovering your investment.  NOT BAD SINCE YOU WILL HAVE 4,999 MORE TESTS AVAILABLE


Blessings to HSI Sensing the Best of the Best

I would like to thank David Posey, Ryan Posey,  Travis Posey and all of the employees at HSI Sensing for continuously helping my company on this long journey to keep the Mag-Probe manufactured in the United States at the highest quality. It has been a blessing to have one of the highest quality driven and customer service oriented manufacturers in the world, HSI Sensing manufacture the Mag-Probe.


Mag-Probe Interactive Downtime Spreadsheetz


Join Bob Bartol on . . .


Your Name (required)

Your Email (required)


Your Message

About the Author
Bob Bartol has spent his whole life working with electronics in almost every capacity and spent many hours in Physics classes. He currently holds 4 U.S. patents and has been making a living off one of the patents "The Bartol Mag-Probe" for over twenty years. Bartol Research's Mag-Probe now has a global reach and is dramatically reducing trouble shooting downtime anywhere a solenoid valve. relay, or contactor is used. F111 Air Force Projects - European Flight Competition January 1968 Bob attended electronics school in the Air Force. Upon graduation he was assigned to a fighter wing in Germany. During his assignment he prepared seven aircraft for European competition. The fighter wings aircraft won the competition. Bob then returned to the United States and taught advanced radar for two years. Two years later, he returned to Europe. During this assignment, Air Force headquarters Europe selected Bob to open a Precision Measuring Equipment Laboratory (P.M.E.L) in England. It was the first of its kind in the Air Force. Upon his return to the United States, Air Force headquarters assigned Bob to Air Force research command in Florida. This was strictly a scientific assignment for research and development. After three years he moved from Eglin AFB in Florida to Edwards Air Force Base in California where he had direct contact with the National Bureau of Standards and supported research and development aircraft. During this assignment, he designed a modification for the TF X fighter (F-111). This modification made possible an additional 9800 flying hours per year. The F111 was the first swing wing aircraft in history. General Dynamics completed the modification prior to acceptance by the U.S. Air Force. Modification of F111 Aircraft General Dynamics March 1968 As a result of increasing this flying time Bob Received an award from Edwards Air Force Base for Increasing flying time of the F111 by 9,800 hours per year. The Award was Presented by Colonel Grumbles to TSGT Bob Bartol on June 17, 1968

Leave a Reply