Challenge #183: Roman Numeral Math

A solution to last week's challenge can be found here.

This week's challenge was shared by @LordNeilLord and @JReid from an original post by @AnandKumar1. Thanks to all of you for sharing this challenge!

This challenge includes two inputs: 1) An equation written in Roman numerals and 2) a look-up table of certain Roman numerals. Solve the equation and return the answer as an integer.

Update: Start file updated on 10/1/2019

challenge_183_start_file.yxmd

challenge_183_solution.yxmd

Developer

Parse

Join

Preparation

Advanced

Data Analysis

Transform

Difficult

Accepted answers

All comments

AnandKumar1

Feels good when your question comes in weekly challenge. Lets see how many different solutions will come 🙂

LordNeilLord

I've been waiting for this one to come up 🙂

Martyn

I get a different result - could be me - but you might want to check it.

Spoiler

challenge_183_completed.yxmd

ZenonH

I got a different answer, but I was a little confused about how the order of operations should have been handled given how the formula was given.
[1]*[3]/([5]+[7]-[9]) vs ([1]*[3]/[5])+[7]-[9] (both were far off from the provided answer, which was close to just [1]*[3] less ~300 or so

Spoiler

Looks like The provided solution took ((1732*79)/9 )+(1-7)/9 and took the /9 off the first set of brackets after converting -6/9 --> -54.
136828-54=136744. off by ~1

challenge_183_ZHSOL.yxmd

David-Carnes

I don't know how the "solution" was generated but it sure didn't follow PEMDAS rules. Anywho, another lunch break given over to another weekly challenge. I think I need to clean up and publish my macro within my organization.

Spoiler

Edit: Once I had the formula with the correct Hindu-Arabic numerals I thought I needed a macro. But then I learned from @Martyn that the Dynamic Replace tool will do what I needed. And this is why one should always review other's solutions.

David-Carnes_183.yxzp

viveknshah

Spoiler

Struggled a bit with evaluating the expression only to realise the wonder called Dynamic Replace. My answer matches to what almighty Google thinks so I'd like to believe I am on the right track even though the solution result seems to be way off from my answer.

challenge_183_shvive.yxmd

RolandSchubert

Finally, I understand why I've learned latin ... but I've got a different result.

Spoiler

I splitted the roman numeral to single characters, translated the characters, applied roman numeral logic (small number before a larger number => subtract, else add) and created a formula string.

I handed the formula string to a macro

Calculation result is different

challenge_183_solution_rsc.yxzp

ZenonH

After seeing you can interpret strings as formulas in @Martyn 's solution I went in and modified the end of my workflow to incorporate what I learned from him.

Spoiler

challenge_183_ZHSOL.yxmd

Kenda

Spoiler

Mine isn't dynamic enough to pick up if the order of operations is in the incorrect order, but does the job here.
Also getting 15,197

KBchallenge_183.yxmd

pasccout

Here is my solution but I can't figure out how you got to that result without respecting math order of calculations PEDMAS?

challenge_183_my_solution.yxzp

TonyA

I would have had this done an hour ago, but I was trying to figure out why I was getting the "wrong" answer.

Spoiler

Didn't know about Dynamic Replace so I used a macro, but I did learn something new today. Thanks, Martyn!!

challenge_183_TonyA.yxzp

hbraunius

My solution here.

challenge_183_solution_hb.yxmd

JORGE4900

I took this challenge to practice some REGEX to separate the fields.

Parse: (.*?)\+\s(\*?)\s(.*?)\+\s(\/?)\s(.*?)\+\s{2}(\+?)\s(.*?)\+\s(\-?)\s(.*)\+

Spoiler

challenge_183_Jorge_Solution.yxmd

benakesh

Installed custom functions to try fromRoman() . More details here : https://community.alteryx.com/t5/Engine-Works-Blog/An-Overview-of-the-Alteryx-Abacus-Add-In/ba-p/398982

This is a good example for 'find and replace' and 'dynamic replace'.

challenge_183_bh.yxmd

Bdonahue

I too got a weird number doing things in the correct order of operations.

Spoiler

Maybe the romans did a different order of operations? I took each value, the equation into words vs. operators. Joined by record position to each other so we'd know the function to be performed on the following line. I used a batch macro to convert to standard numbers by dividing each symbol into rows, determining via multi-row if it was a "subtractor" or an addition value and then summed the values up. I then put this into an sort by Order of operations and position ranking so * and / came first then by relative position followed by +/- and relative position left to right. I ran this through an iterative macro and took the final output as the value.
Screen Shot 2019-09-30 at 12.09.30 PM.png

Screen Shot 2019-09-30 at 12.09.30 PM.png

Screen Shot 2019-09-30 at 12.09.40 PM.png

Screen Shot 2019-09-30 at 12.09.51 PM.png

challenge_183_BD.yxzp

T_Willins

Without additional information, I am going to say the PEMDAS answer is correct, which is what I tie to.

Spoiler

challenge_183_solution.yxzp

cgoodman

Spoiler

Like others I didn't get the supplied answer as I followed the order of operations (being a Brit I know it as BODMAS (Brackets, Orders, Division, Multiplication, Addition, Subtraction)) and got 15,197 which is similar to others.

Originally approached it by summing the numeric value of the roman numerals but this doesn't work as IX is 9 and not 11 (if you sum them), so built in some logic to add in hierarchy to the roman numerals.

Challenge 183.PNG

I also ended up with a long multi-row formula to do the maths bit 😕

challenge_183_solution.yxmd

nivi_s

Spoiler

I had no idea how to convert a field into a formula until I saw Martyn's solution with the Dynamic Replace, so thanks!

Challenge #183 solved!

challenge_183_solved_NS.yxmd

philipmannering

Good challenge. First time I've use the dynamic replace - essentially as an 'eval' function. Solution attached.

Spoiler

workflow

Challenge 183 - Roman Numeral Math.yxmd

lmorrell

Fun challenge - tried to keep things simple until I... Didn't. Opted for a batch macro instead of dynamic replace - so I'm keen to take a look at everyone else's answers and familiarise myself with a new tool!

Spoiler

and the batch macro

challenge_183_LM.yxzp

patrick_digan

Spoiler

I went for the find and replace route:
Annotation 2019-09-30 215711.jpg

challenge_183_start_file.yxmd

LordNeilLord

Thanks to @PhilipMannering for showing me dynamic replace!

Spoiler

challenge_183_LNL.yxmd

wdavis

Solution attached, I did get an answer of 15197, slightly higher than the example. I couldn't work out what would cause this difference...

Challenge 183.yxmd

afv2688

Spoiler

I used a batch macro to insert the calculation directly to a formula tool. Thats the only thing the macro does.

Nice one 🙂

floor.yxmc

challenge_183_end_file.yxmd

RichoBsJ

Hi! Here my solution 🙂

Spoiler

As many of the other challengers, I got a different result...

challenge_183_richobsj.yxmd

Hannah_Lissaman

This was fun! Got the same answer as everyone else (i.e. not the one in the solution box), but I think the methodology is correct

Spoiler

challenge_183_Solution.yxzp

mmontgomery

Got a different answer as well. Love the use of dynamic replace

Spoiler

challenge_183_start_fileMM.yxmd

Niklas

My solution. As others have pointed out the solution seems to be incorrect.

I got:

Spoiler

15197.11111

challenge_183_NE.yxmd

Niklas

For those who chose not use a macro or dynamic replace, I recommend that you check that you pass this one:

MDCCXXXII * LXXIX / IX + I * VII = 15210.111

Order of operands matter. @patrick_digan fancy the challenge?

kneri3

Spoiler

Roman Numersl Weekly challenge.yxmd

JordyMicheal

Spoiler

Tokenize, Find and Replace, Split apart, reassemble

challenge_183_start_file.yxzp

jmt214

Spoiler

Here's my solution. Relied heavily on multi-row formula tools, but it should pickup the operators regardless of what the equation is. That was really important to me so the workflow could be applied to any roman numeral equation you throw at it, although I had similar questions others have had about the order of operations.

challenge_183_start_file.yxmd

ddiesel

My solution:

Spoiler

challenge_183_end_file_ddiesel.yxzp

laeorn

Spoiler

It reads every number and assigns it a value, 1 that are before V or X will be -1.

Operators are assigned a value 0. a running number column is created to group them, with an operator increasing the number by 1. The first number will have the group 0

sum the numbers up and concat their operators by their group numbers, join them together, have a running multirow formula to perform the operators accordingly

Had to get some inspiration from the solutions on how to manage the negative 1.

Nonetheless, got to the solution!

Created it to take on any form of roman numerals expressions, just need to modify number of columns in the regEx tool should the number of characters exceeds 1000.

LLchallenge_183_start_file.yxmd

Greg_Murray

Solution Attached

challenge_183_solution GM.yxmd

rmassambane

Nice use of Dynamic Replace!

challenge_183.yxmd

atcodedog05

Fun weekly challenge 🙂

Spoiler

challenge_183_atcodedog05_Solution.yxmd

bmcclelland46

Had a time configuring the dynamic replace. Also took some time to wrangle the Roman Numerals but hopefully it was in a manner that was at least dynamic if the expression changed.

Spoiler

challenge_183_solution.yxmd

mattnason1

Very tough for me.

challenge_183_start_file_mn.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703