We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #237: Wareki

AngelosPachis
15 - Aurora

My solution for challenge #237

 

Workflow 

Screenshot 2020-10-12 185614.jpg

 

Macro

 

Spoiler
Screenshot 2020-10-12 185415.jpg
ehughes
9 - Comet

Definitely learnt some things with this one

Spoiler
Img 237.png

Img 237 - macro.png

TonyA
Alteryx
Alteryx

Really enjoyed this one, having lived in Japan for several years. I made a couple of tweaks, including a validity test on the Wareki date to ensure it was valid. For example, S010131 would not be valid (Showa started in December of 1925), neither would H251231, since Heisei only lasted 20 years.

Spoiler
I also made some changes to the Era Definitions, changing the dates to date format and adding a column for start year. It didn't make sense to keep the original file and make the same changes to it every time the macros were called. I included the workflow to make the that created the modified data set in the package.

Main Workflow

2020-10-12_13-39-47.png
Wareki to Date Macro
2020-10-12_13-43-12.png
Date to Wareki Macro
2020-10-12_13-46-00.png

 

LHolmes
8 - Asteroid

Fun challenge. Great to work on some macros!

 

Spoiler
237 - Solution.PNG
237 - Macro.PNG
JethroChen
10 - Fireball
Spoiler
challenge_237_jc.PNG
Nanoq
5 - Atom

I have a feeling that i could optimize my macro more, but this does the trick

kelvinlaw
8 - Asteroid

Fun challenge!!  Here is my solution.

Spoiler
kelvinlaw_0-1602576031207.png
Here is the macro workflow:
kelvinlaw_2-1602576101449.png
Qiu
17 - Castor

Not sure its a Macro already.
Just list up all the dates.

Spoiler
en-237.PNGen-237-1.PNG
DaisukeTsuchiya
12 - Quasar

This macro is one which I need!

This conversion is troublesome for Japanese, too.

Spoiler
キャプチャ1.JPGキャプチャ2.JPG
skumar_31
8 - Asteroid

Cool Stuff 😎

Spoiler
ch237.PNG