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.
NEW VIDEO:
Use Apple Numbers and Apple Shortcuts to Manage your finances - Update 2.5
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.
NEW VIDEO:
Update 2.0 to Apple Numbers Personal Finance Dashboard Out Now!
https://youtu.be/LgBZ8AYdCuU
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
@Tita @JensKessler Moin, ich mache nach den Stunden handschriftlich/analog Notizen im Sitzplan (0–5 Punkte), die ich dann ab und an gesammelt in meine #applenumbers Tabellen übertrage. Bei KA nehm ich direkt die Tabellen und dann #texlatex, um individuelle Rückmeldebögen zu drucken.
Alle meine Tools sind hier verfügbar: https://github.com/tweh/lehrerwerkzeuge
Unexpected Advantage to Saving for Everything
NEW VIDEO:
Unexpected Advantage to Saving for Everything
https://youtu.be/PV-qu1F47lo
Cecelia
Rich Aesthetic
Chris Alemany🇺🇦🇨🇦🇪🇸
Dr. Juande Santander-Vela
Tobi Weh · NDS