Joe Ross' Guide to Solving the WSJ Meta with Excel

This is a place to learn about the Muggles community and some of the terminology we use. It also contains suggested strategies for solving meta crosswords, as well as a repository of all past WSJ crossword contests and solutions.
Post Reply
juliet
Posts: 116
Joined: Sun Jul 14, 2019 11:11 pm

Re: Joe Ross' Guide to Solving the WSJ Meta with Excel

#121

Post by juliet » Sat Apr 11, 2020 12:48 am

Many thanks, Joe! With extra time on my hands it seems like this is a good time to get more tech savvy.


User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#123

Post by Joe Ross » Thu Apr 23, 2020 4:02 pm

Link to 20200424 WSJCC Capitalized Letters Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 4 additional grids, below Row 30, to highlight & mark-up.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#124

Post by Joe Ross » Thu Apr 30, 2020 4:08 pm

Link to 20200501 WSJCC King Me! Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 4 additional grids, below Row 30, to highlight & mark-up.

Inca
Posts: 267
Joined: Tue Apr 09, 2019 10:55 pm

#125

Post by Inca » Fri May 01, 2020 9:44 am

Joe Ross wrote:
Thu Apr 30, 2020 4:08 pm
Link to 20200501 WSJCC King Me! Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 4 additional grids, below Row 30, to highlight & mark-up.
Just saw this update (not sure where I was last week) and it definitely is less frustrating than when I used to forget to navigate with the arrow keys and just instinctively used to click on the grid...which of course took me right out of the grid. BUT, I had gotten used to it and I liked retaining the numbers. Is it just I who loses the numbers as I enter the solution in the grid?

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#126

Post by Joe Ross » Fri May 01, 2020 9:52 am

Inca wrote:
Fri May 01, 2020 9:44 am
I had gotten used to it and I liked retaining the numbers. Is it just I who loses the numbers as I enter the solution in the grid?
Inca,

Thank you for the feedback. I've updated this week's form by adding a picture of the grid — with numbers — for reference.

This picture can be easily sized and moved around while solving. I was doing this for myself, the past few weeks, and should have thought to add it to each week's form.

Please download this week's, again, from the same link, above.

Inca
Posts: 267
Joined: Tue Apr 09, 2019 10:55 pm

#127

Post by Inca » Fri May 01, 2020 10:14 am

Joe Ross wrote:
Fri May 01, 2020 9:52 am
Inca wrote:
Fri May 01, 2020 9:44 am
I had gotten used to it and I liked retaining the numbers. Is it just I who loses the numbers as I enter the solution in the grid?
Inca,

Thank you for the feedback. I've updated this week's form by adding a picture of the grid — with numbers — for reference.

This picture can be easily sized and moved around while solving. I was doing this for myself, the past few weeks, and should have thought to add it to each week's form.

Please download this week's, again, from the same link, above.
Great. Thanks.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#128

Post by Joe Ross » Thu May 07, 2020 4:10 pm

Link to 20200508 WSJCC Build Your Brand Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 4 additional grids, below Row 30, to highlight & mark-up.

— A blank numbered grid is copied for reference, however you may keep the Clue #s in the cells, along with answer letters.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#129

Post by Joe Ross » Mon May 11, 2020 10:07 am

As a way of showing recent changes, you will find a screencap of Al Sisti's first meta puzzle in Excel form, below.

Inspired by Spotter, I have "opened" the grid within the clues to direct editing. Previously, you would have to click on a cell to right of the grid/clues, then use keyboard arrows to move left to the grid. Then, to edit, you'd have to use menu browsing to highlight, change fonts & borders, etc. Now, a right-click brings up pop-up editing choices. THANK YOU, SPOTTER!

Also, I found myself copying & pasting grids in order to try fresh approaches, or to edit a previous approach, without losing the first. Below the grid/clues, you will find multiple grids which are generated when the top grid is filled-in. In the example, below, only two extra grids are shown. For this particular puzzle, there are a total of 12 grids, including the top grid. I think that the WSJCC will have 20, going forward. Overkill? maybe, but you might find that they are handy.

You can see how the cells in the grids, below, are automatically generated when the top grid's cells are entered - WE CAN NOW CLICK ON THE CELLS TO EDIT. After completing the top grid, the lower grids will be correct.

EXPLORE! ALL FEEDBACK & SUGGESTIONS ARE WELCOME.

20200508 Al Sisti Take 5 eg.gif

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#130

Post by Joe Ross » Thu May 14, 2020 4:39 pm

Link to 20200515 WSJCC At Odds Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 19 additional grids, below Row 30, to highlight & mark-up.

— A blank numbered grid is copied for reference, however you may keep the Clue #s in the cells, along with answer letters.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#131

Post by Joe Ross » Mon May 18, 2020 12:01 am

BICKER
20200515 WSJCC At Odds JPR.gif

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#132

Post by Joe Ross » Thu May 21, 2020 4:12 pm

Link to 20200522 WSJCC At Odds Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates 19 additional grids, below Row 45, to highlight & mark-up.

— The Grid Answer numbers are protected. You should not be able to select nor change them.


Please post here or PM with questions, concerns, or comments!
Last edited by Joe Ross on Thu Jun 04, 2020 4:11 pm, edited 1 time in total.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#133

Post by Joe Ross » Thu May 28, 2020 6:00 pm

Link to 20200529 WSJCC Sound Off Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates several additional grids, below, to highlight & mark-up.

— The Grid Answer numbers are protected. You should not be able to select nor change them.

— This is the form all future Excel spreadsheets will take.


Please post here or PM with questions, concerns, or comments!

(Apologies for late posting! I was hitting some golfs.)
Last edited by Joe Ross on Thu Jun 04, 2020 4:11 pm, edited 1 time in total.

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#134

Post by Joe Ross » Thu Jun 04, 2020 4:10 pm

Link to 20200606 WSJCC Executive Search Excel Blank

NOTE changes to the blank spreadsheet:

— The grid can be highlighted directly (not under a transparent image).

— Filling in the grid creates several additional grids, below, to highlight & mark-up.

— The Grid Answer numbers are protected. You should not be able to select nor change them.

— This is the form all future Excel spreadsheets will take.


Please post here or PM with questions, concerns, or comments!

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#135

Post by Joe Ross » Mon Jun 08, 2020 12:06 am

20200605 WSJCC Executive Search JPR.gif

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#136

Post by Joe Ross » Thu Jun 11, 2020 4:08 pm

Link to 20200613 WSJCC Head Count Excel Blank

Please post here or PM with questions, concerns, or comments!

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#137

Post by Joe Ross » Thu Jun 18, 2020 4:07 pm

Link to 20200619 WSJCC Two's Company Excel Blank

Please post here or PM with questions, concerns, or comments!

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#138

Post by Joe Ross » Thu Jun 25, 2020 4:09 pm

Link to 20200627 WSJCC One-Word Answers Excel Blank

Please post here or PM with questions, concerns, or comments!

User avatar
Joe Ross
Posts: 795
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#139

Post by Joe Ross » Thu Jul 02, 2020 4:13 pm

Last edited by Joe Ross on Thu Jul 09, 2020 4:09 pm, edited 1 time in total.


Post Reply