Gave Apple Feedback on the drop down menu timing out when trying to add a filter to a table in Apple Numbers.

#Apple #Numbers #AppleNumbers #macOS

@libreoffice I spent the weekend converting my Apple Pages, Numbers, and KeyNote files to LibreOffice. Two things stood out: 1) Libre doesn’t handle KeyNote lines very well, lengths and orientations were all wrong; 2) Libre doesn’t like to bring in custom fonts during the conversion of Pages.

Both can be worked around.

Libre has come a long way since I last used it many years ago. I feel like I can use it regularly now. Great job!!!

#applepages #AppleNumbers
#applekeynote
#LibreOffice
#opendocumentformat

Why is Microsoft Excel—at over 2.5 GB in size—four times the size of Apple Numbers? How is Excel bigger than the monolithic LibreOffice app*?

*To be fair, LibreOffice is Apple Silicon-only while the others are Universal binaries (Intel + Apple Silicon), but still, it’s less than half the size.

#MicrosoftExcel #AppleNumbers #LibreOffice #SoftwareBloat

NEW VIDEO:

Use Apple Numbers and Apple Shortcuts to Manage your finances - Update 2.5

https://youtu.be/iuvR-SqPZb8

#applenumbers #budgeting #financeplanner #appleshortcuts

Had 3 wins over the last week.

1) Finally fully translated my Log Transaction shortcut into the corresponding languages my Apple Numbers Finance Tracker supports. Just testing a few more things and then will release update 2.1 for it.

#AppleShortcut #Shortcuts #Numbers #AppleNumbers

NEW VIDEO:

Update 2.0 to Apple Numbers Personal Finance Dashboard Out Now!
https://youtu.be/LgBZ8AYdCuU

#PersonalFinances #AppleNumbers #BudgetPlanner

Spreadsheets!!!
Filled in my #dasher tracking sheet today and added a chart!

This one shows most of the stores I've got orders from since I started tracking that more closely in March. (there is a 'long tail' of <5 orders on the right that is not included in the picture.)

No big surprises for me in here. McDs and Dairy Queen are the 'bread and butter' locations. Other good performers pop up as the number of orders declines including NoodleBox, Boston Pizza, and Walmart.

Little Valley and Panago are good ones on the less frequent side.

7-11 is frequent, but pay is terrible.

“Walmart SFS" is their package delivery vs. grocery. It's an anomaly. It does not allow tips, and the orders are generally 5-10 packages at a time per offer which is why it has the most orders, but the very little cash.

I'm also always considering these numbers geographically... as in, where is the best place to stage myself for the most pay. There is a 'north' and 'south' side of town and It's not a clear choice.

#PortAlberni #DasherLife #DoorDash #Uber #GigWork #Charts #Data #Spreadsheet #AppleNumbers

Today I Learned that the `=COUNTIF` function in Excel can use "?" as a placeholder for a single character… I had written `=COUNTIF(named_range,"x")+COUNTIF(named_range,"?")` because some of the cells could be an "x" or a question mark, and getting double counting… changed it to `=COUNTIF(named_range,"?")` and worked like a charm… If one of the cells in the range is empty, or has more than one character, it does not count it! And it is also case insensitive.

Just checked in LibreOffice Calc, and Apple Numbers, and it also works there!

#TIL #TodayILearned #Excel #MicrosoftExcel #LibreOfficeCalc #AppleNumbers #COUNTIF #Spreadsheets #SpreadsheetFormulas