Joe Ross' Guide to Solving the WSJ Meta with Excel

What is a Muggle? What is the KAS scale? This is a place to learn about the Muggles community and some of the terminology we use.
Inca
Posts: 143
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: 231
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: 231
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: 231
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: 231
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: 145
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!

User avatar
Joe Ross
Posts: 231
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.

Post Reply