Replies

When I started in Water & Wastewater Business the Lab work sheets, Chemical Dosages, Plant Meter Readings, Hourly and Daily Storage Tank Data Sheets had ALL been created in ExCell and they were just printing out pages with empty Cells too be filled in by hand and calculated with a handheld calculator and then written in the Cell on the Printed Page. Some of the Tests took 1 hour just to Calculate after doing multiple tests required to use results in the Calculation.

I asked why this was not a Realtime Spreadsheet and was told “That’s the way we’ve always done it.”

Well I worked the Graveyard Shift so while doing My Job I spent about a month creating the Formulas to crunch the numbers instantly when entering the Lab Test Results so the Answer was in the Cell on the Computer. Then at the end of the month the Reports that had to go to the State Water Commission would have already grabbed the Data from each of the other Spreadsheets and completed the Final Reports to be Printed out for Hardcopy to file away and then I would E-Mail the Final Report to the Commission. All in about 1 hour as opposed to several days and then Mailing it in just before the deadline.

I ended up making that happen at 4 different Water & Wastewater Plants over the 10 years I was in the Business.

Most of My Coworkers had at least 4 years of College and some even had what I call an EFd or an Elmer Fudd (PHd, Book smart but no Street smarts) or a B.S. plus years and/or decades in Water & Wastewater Treatment. While little old Me dropped out of High school when I got My Drivers license at 16. (I did finally see a use for all that fancy Math stuff, when I was 40.)

Now I make Spreadsheets for entertainment. Isn’t Life strange ?

As someone who HATED MATH, while in High School, never got close to working with fractions, and no classroom training for computer use, my daughter while going to a very big name local college, would alway's hit me up to help her with her math.

I seen a Qutro-Pro Spread Sheet, (think Excel Spread Sheet) couldn't figure out how to use it.

I happened to notice that in WordPerfect on the tool bar you could insert "Cell's." I took a look to see if you could format the cell content to be only numerical, and if there was any example's. Need less to say, I was able to set up a "One-Page," "Two-Page" up to "Four Page" (never needed more than four pages) Estimates, for my Autobody Business. Just type in the cost of the part's, my self designed estimates would tally cost's both for labor separately, part's, taxes, and give a grand total.

I think what I'm trying to say is, I was "Code-ing" before I even knew that their was such a thing as "Code-ing."

I now only have my Welding Business, and do my receipts / estimate's in Wordperfect, Form(s) that I designed, and again as I type information in, the forms automatically update / add (Sales) Taxes to the total. Write a good formula once, just rinse and repeat.

Maybe now @ 65 yr's old I should go to Law school, I only have ten year's Appellate Experience.