Author Topic: Digital root software  (Read 7527 times)

0 Members and 1 Guest are viewing this topic.

Gremlinique

  • Guest
Digital root software
« on: August 18, 2010, 20:37:19 »
Hi

Is there any software for digital roots on Mac. I know Alfa Val for PC but haven't found any on Mac.

Otherwise, i've used www.bigstory.homelinux.org to do it on-line but the site seems closed, (not functional).

Thanks

HoundGPS

  • Guest
Re: Digital root software
« Reply #1 on: October 21, 2010, 10:18:23 »
I know this is old, but maybe what I say might help other ppl too, so its for the greater cause.

Getting a single digital root, by itself, is too simple to actually use a software and I will always advocate knowing how to do it yourself on paper before using third-party solutions. But depending on the situation, like when you are trying to solve a puzzle consisting of many numbers, and you would like to check if their digital root has any meaning, a little extensive endeavor for what could prove to only be just a hunch, so you may save time and effort by using something as simple as an excel spreadsheet ;)

I know not everyone has the luxury of being able to buy Excel, but openoffice.org offers a free alternative (and I believe they have a port for Mac OS-X users). Basically, any spreadsheet program that has the MOD() function will do the trick (MOD stands for Modulo, a well known operator and/or function to programmers... may be less known to the common mortal though).

As a very basic example, lets say you put the number you wanna get the digital root for in the A1 field and get its digital root to appear in the B1 field, edit the B1 field and put the following string: =IF(MOD(A1; 9)=0;9;MOD(A1; 9))

Explanation of the above formula (for those who really want to know):
The MOD function will give you the REST of a the division of A1 by 9. (i.e. 12 divided by 9 would be 3 because you can fit 9 only once in 12 and 12-9 = 3).
If you calculate the digital root of 12 manually... you get 1+2 = 3.
The MOD function will return the right digital root for all numbers except... a number divisible by 9 since the rest would be 0 (i.e. 9 fits once into 9 therefore there is 0 rest for this division).
This is where the IF comes in. IF the result of MOD(A1; 9) is 0, than its digital root is 9. Take 18 for example. 18 divided by 9 has 0 rest since the result is 2 (9x2=18). But the digital root of 18 is 1+8=9.


Now once that is done, youll be able to do this for many numbers by entering all your numbers in the A column (A1, A2, A3, A4 etc..) and just drag and extend the B1 field to the last number in the A column (if you last number is located in A4, then drag and extend the B1 field to B4).

This will prove useful for any number ABOVE 0. When dealing with negative numbers, depending on how the MOD function was implemented in the spreadsheet, it may or may not give the right answer, so the best way to handle it is to treat it as if it was a positive number.
« Last Edit: October 21, 2010, 10:50:53 by HoundGPS »

kirok

  • Administrator
  • Big Time Cacher
  • *****
  • Posts: 691
  • "To boldly find what no cacher has logged before!"
    • Binthair Challenge
Re: Digital root software
« Reply #2 on: October 21, 2010, 16:34:06 »
I use an excel spreadsheet for minor puzzle things like digital root as well, but I don't use the MOD function for one simple reason.  Most of the time, caches need the digital root of a WORD, not a number.  The site Gremlinique refered to did both.  Still an easy function to write for any programmer (like myself), but for the average Joe to do with paper and pencil is time consuming.  Once you've learned how to do it, building or having a tool on hand is much simpler. 

The answer the original question of the post, (which I'm sure Gremlinique already found by now) can be found in this thread:

http://canadascapitalcachers.ca/forum/index.php?topic=130.0

HoundGPS

  • Guest
Re: Digital root software
« Reply #3 on: October 22, 2010, 09:01:04 »
I use an excel spreadsheet for minor puzzle things like digital root as well, but I don't use the MOD function for one simple reason.  Most of the time, caches need the digital root of a WORD, not a number.  The site Gremlinique refered to did both.  Still an easy function to write for any programmer (like myself), but for the average Joe to do with paper and pencil is time consuming.  Once you've learned how to do it, building or having a tool on hand is much simpler. 

The answer the original question of the post, (which I'm sure Gremlinique already found by now) can be found in this thread:

http://canadascapitalcachers.ca/forum/index.php?topic=130.0


Makes sense really. I haven't been geocaching for very long so your experience is a factor here. I’ve only solved 37 puzzles so far, working on my 38th.. none of which required me to get a word's digital root yet... but I hear its coming ;) I should get my function ready then.

Thanks for the heads up :)

narcissa

  • Guest
Re: Digital root software
« Reply #4 on: October 23, 2010, 12:21:37 »
The old site is back up, just so you know.