Guide to Solving the WSJ Meta with Excel/Spreadsheets

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

#61

Post by Inca »

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
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#62

Post by Joe Ross »

Inca wrote: Mon Nov 04, 2019 8:34 am How do you put the circles around the letters?
Ovals.gif
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#63

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#64

Post by Joe Ross »

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
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#65

Post by Joe Ross »

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!
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#66

Post by Joe Ross »

20191115 Out of the Elements WSJ Crossword Contest blank spreadsheet.
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
KayW
Moderator
Posts: 3123
Joined: Wed Apr 10, 2019 12:10 am
Location: Chicago

#67

Post by KayW »

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!
Contest Crosswords Combating Cancer (CCCC) is a bundle of 16 metapuzzles created to help raise money for cancer-related charities. It is available at CrosswordsForCancer.com.
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#68

Post by Joe Ross »

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.
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#69

Post by Joe Ross »

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
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#70

Post by Joe Ross »

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.
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#71

Post by Joe Ross »

20191129 Leftovers WSJ Crossword Contest blank spreadsheet.

Apologies for the late post!
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#72

Post by Joe Ross »

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.
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#73

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#74

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#75

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#76

Post by Joe Ross »

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

20191220 Counting Calories JPR.gif
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
MajordomoTom
Posts: 1399
Joined: Sat Nov 02, 2019 12:09 am
Location: St. Louis, MO

#77

Post by MajordomoTom »

:)
"Lots of planets have a North", the Ninth Doctor.
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#78

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#79

Post by Joe Ross »

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
Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
User avatar
Joe Ross
Moderator
Posts: 4996
Joined: Fri Apr 12, 2019 4:46 am
Location: Cincinnati

#80

Post by Joe Ross »

Whole blood, platelets, or plasma: Donate 4 in 2024

PLATELET 𝗱𝗼𝗻𝗼𝗿𝘀 𝗮𝗿𝗲 𝗿𝗮𝗿𝗲.
𝗧𝗵𝗲 𝗻𝗲𝗲𝗱 𝗶𝘀 ENORMOUS 𝗳𝗼𝗿 𝗰𝗮𝗿𝗲:
𝟰𝟬% 𝗽𝗲𝗱𝗶𝗮𝘁𝗿𝗶𝗰,
𝟯𝟬% 𝗲𝗮𝗰𝗵, 𝘁𝗵𝗲 𝘁𝗮𝗰𝘁𝗶𝗰,
𝗳𝗼𝗿 𝗰𝗮𝗻𝗰𝗲𝗿 & 𝘁𝗿𝗮𝘂𝗺𝗮. 𝗣𝗟𝗘𝗔𝗦𝗘 𝗦𝗛𝗔𝗥𝗘!
Post Reply