DIYbanter - View Single Post

pyotr filipivich

on Mon, 01 Mar 2021 21:25:05 -0500 typed in
rec.woodworking the following:
On Sun, 28 Feb 2021 20:32:34 -0800, pyotr filipivich
wrote:

on Sun, 28 Feb 2021 23:14:43 -0500 typed in
rec.woodworking the following:
On Sun, 28 Feb 2021 21:21:14 -0500, Bill wrote:

wrote:

Technology is often better than "GET OFF MY LAWN!". ;-)

I know what you mean, but I ENJOY "Get Off Of My Lawn!!!" : )

My dad used to keep a ledger of every purchase he made for his
house/garden (even packs of seeds!) Me, I use an Excel spreadsheet!
: )
Besides of keeping track of model numbers, dates, and phone numbers,
there's a "nostalgia factor" to having the spreadsheet. Like, we
planted that tree in 20XX...

Besides my schematic entry tool, Excel is my most important tool. I'm
too cheap to buy it for home. There is a freeware (or used to be
anyway) spreadsheet but I hated the UI and it was too hard to remember
both.

Open Office - Calc. I've been using it for years. Main issue is
to remember that in Calc, the separator is a semi-colon, not a comma
as in Excel.

The shortcuts are all different, colors, formatting, and
equations/references, IIRC. It's a RPITA to be multilingual. Maybe
after I retire I can forget Excel, finally!

Which separators? Import text? They can be changed during import
with Excel.

In formulas and the like e.g. =Left(A2,3) in Excel becomes
=Left(A2;3) in Calc.
It can be a real PITA when you can't see the itty bitty font on
the screen, and somewhere in the long
=CONCATENATE(Raw.X4;IF(ISNUMBER(OxC.L4);;CONCATENA TE(CHAR(10);"††
";OxC.L4));IF(ISNUMBER(StA.L4);;CONCATENATE(CHAR(1 0);"†
";StA.L4));IF(ISNUMBER(AJH.L4);;CONCATENATE(CHAR(1 0);"{A}
";AJH.L4));IF(ISNUMBER(PDH.L4);;CONCATENATE(CHAR(1 0);"[P]
";PDH.L4));IF(ISNUMBER(SCA.L4);;CONCATENATE(CHAR(1 0);"SCA
";SCA.L4));IF(ISNUMBER('SCA-RF'.H4);;CONCATENATE(CHAR(10);"SCArf
";'SCA-RF'.H4));IF(ISNUMBER(SqD.L4);;CONCATENATE(CHAR(10) ;"";SqD.L4));IF(ISNUMBER(RE.G4);;CONCATENATE(CHAR( 10);RE.G4))
;IF(ISNUMBER(RFE.K4);;CONCATENATE(CHAR(10);RFE.K4) ) )
is where I typed a comma, not a semi-colon.

For grinds and giggles, that last reference is the another sheet RFE,
cell K4 which has this formula:
=IF(ISNA( OFFSET(RFE.$B$3;MATCH(MONTH(Raw.H4)*100+DAY(Raw.H4 );
RFE.$A$3:RFE.$A$54;0)-1;0));0;OFFSET(RFE.$B$3;MATCH(MONTH(Raw.H4)*100+DA Y(Raw.H4);
RFE.$A$3:RFE.$A$54;0)-1;0))
the result of which is 0 (zero)

yes, proably more than you care to know, but I'm some what proud
of it. And no, I didn't start out with this level of complexity, but
worked up to it.
--
pyotr filipivich
This Week's Panel: Us & Them - Eliminating Them.
Next Month's Panel: Having eliminated the old Them(tm)
Selecting who insufficiently Us(tm) to serve as the new Them(tm)