Creating a 'Group' column in the Transactions sheet

Spreadsheets Microsoft Excel
8

Are you maybe working on something for the 2022 Excel Builder Challenge @brettlapierre ?

You said the #MagicWords…

“Power Query”

It’s like hearing “Power Glove”, but oh so much more powerful than that over-hyped (over-promised), under-performing (under delivered) piece. Rather than #PowerQuery and #PowerBI both of which I feel are MEGA UNDER-HYPED and OVER-DELIVERED on!

RE: Licensing
I had the same concern. Might be okay though?

I thought 365 was required for Tiller, but I guess not.

I am actually #curious what Microsoft Money will be like, but I don’t have a personal/family subscription to try it. Do you?

Looks like Microsoft limits Power Query by what type of connector you want.
Makes sense, get people hooked, then get them on the SQL Server in the Cloud w/ 32 processors, terabytes of memory, and 32xWhatever licenses :wink: !

Connector Name
Excel workbook

Office 2016
Home & Student
Home & Business Standard
Professional Office 2016
Professional Plus
Standalone Office 2019
Home & Student
Home & Business Standard
Professional Office 2019
Professional Plus
Standalone Microsoft 365
Home
Personal
Business
Business Premium Microsoft 365
Apps for Enterprise

Checkout my GH repo, I went somewhere like you.
Dirty WIP right now, but curious what you think.

My next steps were going to be an AutoCat… join forces? I’ll be open sourcing this whole thing as long as it is cool with the Tiller Contest Rules.

You ever play with Power BI?

Checkout my other GH repo where I got deep into that for a month trying to analyze my Son’s Grade 7 progress, while the school used a poopy very-limited data, very-common-sadly, website powered by Moodle. I went down many paths but wound up discovering the Moodle REST API Docs Online and the rest is history git log as they say… :smirk:

  1. New Tiller Community category structure - #16 by GregSweats
  2. GitHub - trxn8r/trxn8r: Transactionator - The Trippy T-Rex Bulk CSV Importer/Transformer/Deduplicator; for the TillerHQ.com 2022 MS Excel Challenge; Better than my resume for Tiller Sr. Engineering Job 😱
  3. https://www.youtube.com/watch?v=YHlK748eKaQ
  4. GitHub - Savvy-Student-Stats/powerbi-moodle-data-source: Using the Moodle web service, we extract Course and Grade info to feed into Power BI for pretty reports and AI insights! #ProofOfConcept #WIP