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.
Inca
Posts: 251
Joined: Tue Apr 09, 2019 10:55 pm

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

#61

Post by Inca » Mon Nov 04, 2019 8:34 am

Joe Ross wrote:
Mon Nov 04, 2019 12:38 am


20191101 BACKDROPS Excel .gif
How do you put the circles around the letters? I'm pretty sure I know, but easier to just ask.

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

#62

Post by Joe Ross » Mon Nov 04, 2019 9:25 am

Inca wrote:
Mon Nov 04, 2019 8:34 am
How do you put the circles around the letters?
Ovals.gif


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

#64

Post by Joe Ross » Mon Nov 11, 2019 12:32 am

Publication of solution of November 9, 2019's That's A Plus may be delayed due to Veterans Day. Will edit this post with spreadsheet when posted by WSJ, not that many will need it.

Edit:

Solved meta while filling the grid (see the right side). Some may find filling the spreadsheet easier than the WSJ online form. I usually fill the online form, then the spreadsheet. Repeating the grid can help.

This had an exception for the 'in clue order' "rule", with the grid letters of the meta answer arranged clockwise.

2019 Thats A Plus WSJ CC Solve JR.gif

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

#65

Post by Joe Ross » Mon Nov 11, 2019 7:13 am

DrTom wrote:
Fri Nov 08, 2019 12:33 am
That's A Plus, Post #75:

Oh, by the way, trying out the Excel crossword grid...

...moving around with the keys will take some getting used to because I keep selecting the darn grid and then moving it when I try to move the cursor.

I may just go back to my PDF method since I have the full Acrobat. I will say it did make highlighting easy.
Moving "the cursor" using the keyboard arrows is a must & takes practice. Click to the right, off of the PDF form, to reconnect to the spreadsheet.

DrTom: Can you detail, here, how to set up Adobe Acrobat for solving? I've not figured how to do it. Muggles may prefer that method.

Thank you!

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

#66

Post by Joe Ross » Thu Nov 14, 2019 4:07 pm

20191115 Out of the Elements WSJ Crossword Contest blank spreadsheet.

User avatar
KayW
Posts: 303
Joined: Wed Apr 10, 2019 12:10 am
Location: Chicago

#67

Post by KayW » Thu Nov 14, 2019 5:06 pm

Joe you really are spoiling us. The blank template you provided makes this so easy to do for myself. But any time I try to solve before the print edition comes out, the first thing I do is check to see if you've already provided the current week's workbook. And indeed you did! Vielen Dank!
A kestrel (??? - I think) on our balcony in 2018

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

#68

Post by Joe Ross » Thu Nov 14, 2019 6:16 pm

KayW wrote:
Thu Nov 14, 2019 5:06 pm
Joe you really are spoiling us. The blank template you provided makes this so easy to do for myself. But any time I try to solve before the print edition comes out, the first thing I do is check to see if you've already provided the current week's workbook. And indeed you did! Vielen Dank!
Sie sind willkommen, nette Dame.

I had it posted by 4:07, which included me signing off, remembering a small error, signing back on, & correcting it. It's easy to do.

Look for the MMMM & MGWCC blanks in the near future.

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

#69

Post by Joe Ross » Thu Nov 21, 2019 4:09 pm

Link to 20191122 WSJ CC - Part Two

"PART TWO" - November 22, 2019

The answer to this week’s contest crossword is CERTAIN PARTS OF THE BODY.

good luck with the grid and the contest

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

#70

Post by Joe Ross » Mon Nov 25, 2019 3:48 am

My solution for "PART TWO" - November 22, 2019 can be found HERE.

I knew the correct meta answer - 100% - and submitted it before knowing the justification of one of its letters. After I thought I had found the proper instance of the letter within the grid, I hadn't. The correct answer must be submitted, not its justification, thankfully.
,......
In order to learn, some muggles have requested hints, post-deadline, of various levels. To avoid showing the meta answers where they can't be 'unseen', I will post links. If you can't view a linked solution, please post here or send a private message.

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

#71

Post by Joe Ross » Fri Nov 29, 2019 7:26 am

20191129 Leftovers WSJ Crossword Contest blank spreadsheet.

Apologies for the late post!

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

#72

Post by Joe Ross » Thu Dec 05, 2019 4:06 pm

Link to 20191217 WSJ CC - Two Part Harmony spreadsheet

I think that this was posted on WSJ by mistake, today. See next post for Friday Crossword Contest.
Last edited by Joe Ross on Thu Dec 05, 2019 4:13 pm, edited 1 time in total.




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

#76

Post by Joe Ross » Mon Dec 23, 2019 12:00 am

Solution:. Counting Calories WSJ Crossword Contest 12/20/2019

20191220 Counting Calories JPR.gif

User avatar
MajordomoTom
Posts: 559
Joined: Sat Nov 02, 2019 12:09 am
Location: St. Louis, MO

#77

Post by MajordomoTom » Mon Dec 23, 2019 12:05 am

:)
"Lots of planets have a North", the Ninth Doctor.


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

#79

Post by Joe Ross » Mon Dec 30, 2019 9:08 am

Inca and DrTom mentioned that the spreadsheet aided them in solving, this week. It would be great to see their efforts, here.

My efforts with the spreadsheet, this week, were all over the place, leading to frustration. I solved using a simple text list, since I was not editing the spreadsheet at the time the Part One AHA! smacked me in the face.

20191227 RItNY JPR.gif

EDIT: The text list follows in countdown order. The numbers of letters in theme words were fewer generally as the list descended, which indicated Step Two to me immediately.

COUNTS DOWN 10
KATE HUDSON 9
ICE SKATING 8
SAMPRAS 7
HEXAMETER 6
ISLAM 5
SWEAR 4
FAKE 3
TEA 2
ROPE 1


Post Reply