I did want to make this into a python project, however, it does seem slightly silly to; spend all the time producing a nice looking GUI, writing all the code, spending hours debugging and end up with a project that I need to recompile every time I want to make a change or add something. In its current format, I can drag and drop photos, and schematic diagrams into it, I can add and edit it at will, and it does everything I wanted my python program to do.
As its an Excel file, its also far easier to share! Sometimes I think Excel is supremely under appreciated and utilised!
Another advantage of building this calculator in Excel, was it gave me a reason to explore some boolean operations, and have a go at adding buttons with Visual Studio code.
So, its entirely unfinished but here is a github repo with 2 versions of my Master Electronics Calculator: (Link can also be found on downloads page)
https://github.com/PanGalacticTech/Master-Electronics-Calculator-2021.git
One version has macros enabled, but I know not everyone is able to enable them so there is also a version without the macro functions. Its not quite as up to date at the moment, but I will update it periodically when I make major changes to the other one.
I have tried to make it clear which boxes should be typed in, and which boxes display results, in general on the newer sheets you should ONLY TYPE IN GREY BOXES.
Some sheets look fantastic and I have spent time making them look like I wanted my python GUI to look, these ones mostly have the tabs highlighted with colour, others I haven’t got around to yet, but will do at some point.
Of course, there may be mistakes, its very much a work in progress, however I think eventually this could be a fantastic engineering resource, with all the information needed to design simple circuits from the ground up. Let me know if you spot any mistakes and I will correct them.
Some screenshots are below to give an idea of its contents. Hopefully someone will find this as useful as I do.
Available Functions:
- Capacitor Value Conversion Table
- Ohms Law Calculator
- RF Wavelength & 1/4 Wave Ground plane & Clove Leaf Antenna Calculators
- Voltage Divider Calculator
- LED Current Limiting Resistor Calculator
- LiPo Battery Management Tool
- Op Amp Gain Calculator (Inverting and Non-Inverting)
- Op Amp Standard IC Package Pinout Diagrams
- Simple BJT Transistor Amplifier Calculator
- Filter Calculators (Low Pass & High Pass)
- Logic Gate Planner & Truth Tables
- 40XX Series IC Pinout Diagrams
- 555 Timer Calculators (Monostable & Improved Astable Vibrator) inc Circuit Diagrams for Bistable (Flip-Flop) & 50% Duty Cycle Astable Oscillator
- ICL7660S Charge Pump Circuit Diagrams & Calculator (Positive Voltage Doubling & Combined Negative Voltage Converter and Positive Doubler)
- Stress Strain (Mechanical Engineering)
- Shear Stress (Mechanical Engineering)
- Modal Music Cheat Sheet (Music Theory)
- Sample Risk Assessment Form
& Many More
*Disclaimer, this spreadsheet is a work in progress, I offer no guarantee of the accuracy of any information or calculations contained within. If you have any suggestions or corrections feel free to leave a comment and I will correct things.
Screenshots:
Let me know if there are any calculations you would like to see added and I will do my best to include them.