General > General Technical Chat
FOSS EE calculator for Android and PC
RoGeorge:
Searching for a visual style, does this arrangement makes sense at a glance look, without explanations?
SiliconWizard:
--- Quote from: Nominal Animal on December 14, 2023, 12:32:51 am ---
--- Quote from: CatalinaWOW on December 13, 2023, 11:19:33 pm ---Nominal, you have described exactly why I got out of programming for a living.
--- End quote ---
All I can say is that I couldn't do programming for a living for any of the existing software companies either. They don't make a profit by solving actual problems, which is what I do and want to do.
--- End quote ---
They create the problems. That's a different kind of business. ;D
CatalinaWOW:
--- Quote from: RoGeorge on December 16, 2023, 05:48:12 pm ---Searching for a visual style, does this arrangement makes sense at a glance look, without explanations?
--- End quote ---
It would work for me, but doesn't check all the OP's boxes.
RoGeorge:
True that, trying to keep the spreadsheets free of macros or programming. At least the exponent powers is always a multiple of 3, though it looks cluttered. AFAIK spreadsheets can not display SI unit multiples/submultiples+letter, and cannot take input letters mixed with numbers either.
Looks a little better without grid, but still, having many rows for results is confusing, and it's easy to read by mistake a result from a row that is not affected by the last input changes.
The .ods is the LibreOffice format, but I've attached an .xls version, too, yet I don't use Excel. Just out of curiosity, does it opens correctly in Microsoft office, with math formulas and all?
EPAIII:
I don't know what spreadsheet was used for the example above. But I have created some SIMPLE calculators using Excel. Nothing as complicated as the OP wants, but they were made to allow untrained personnel to get correct results in calculations they needed to use each day. I can say several things about Excel.
1. Excel CAN display numbers in almost any format that you can define. If the format is not already included in Excel, you can create it. Want numbers separated into fields of two digits that are separated by exclamation points instead of commas; it can do that. Want the numbers yellow if negative and purple if positive; Excel can do that. Want units added to the number; Excel can do that. You can even invent any suffix and Excel can do it. If you can define it Excel can probably do it.
2. Excel can take any type of input you wish: anything you can type on the keyboard. Numbers, letters, combinations of both, punctuation, symbols, Greek letters, other languages, etc. all can be used. You just treat the field as a string of characters and take it apart. I have used such techniques to allow drill sizes to be entered in English or metric units, in number and letter drill sizes using a table look-up, decimal and fractional notation, and any units attached.
3. Appearance: Almost any appearance can be attained. Cells can have any background color and the outline is completely under your control, also including the color and weather there is an outline or not. Cells can be combined to create wider or taller regions or allow for more or larger text. Excel can even import images so you can have the exact appearance of a HP or TI calculator. Or the man in the Moon. I am staying away from macros, but there are also things like Command Buttons, Drop Down Lists, Check Boxes, Option Buttons, and more.
4. SI unit multiples/submultiples+letter? I am not 100% sure what you mean by that, but I would be willing to bet Excel can do it. I just typed 123456.789 in a cell of an Excel spreadsheet. It looked like that. Then I formatted that cell for Scientific notation and it looked like 1.23E+05. Another change to special format that I had created some time ago and it showed as 123.5E+3. I could format it to display "Even" if the number is odd and "Odd" if the number is even. Almost complete freedom to format the display any way I want.
And, there is conditional formatting which allows different formats to be defined for different types of numbers, like positive and negative or different colors for different conditions. And the condition does not even need to refer to the number; it can come from anywhere on the sheet or on other sheets in the workbook or even from a completely different workbook (Excel file).
None of the above requires macros. With macros you really can do anything.
--- Quote from: RoGeorge on December 17, 2023, 09:35:07 am ---True that, trying to keep the spreadsheets free of macros or programming. At least the exponent powers is always a multiple of 3, though it looks cluttered. AFAIK spreadsheets can not display SI unit multiples/submultiples+letter, and cannot take input letters mixed with numbers either.
Looks a little better without grid, but still, having many rows for results is confusing, and it's easy to read by mistake a result from a row that is not affected by the last input changes.
The .ods is the LibreOffice format, but I've attached an .xls version, too, yet I don't use Excel. Just out of curiosity, does it opens correctly in Microsoft office, with math formulas and all?
--- End quote ---
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version