# Convert Excel macro to format useable in Apple Number

• État: Closed
• Prix: \$30
• Propositions reçues: 1
• Gagnant: AmolSS

## Résumé de concours

I had freelancer s create a macro on excel that performed a calculation of annual compound return based on the formala you'll see in the note from investopedia below:

"Among the alternatives, the geometric average (also known as the "compound average") does the best job of describing investment return reality. To illustrate, imagine that you have an investment that provides the following total returns over a three-year period:

Year 1: 15%
Year 2: -10%
Year 3: 5%

To calculate the compound average return, we first add 1 to each annual return, which gives us 1.15, 0.9, and 1.05, respectively. We then multiply those figures together and raise the product to the power of one-third to adjust for the fact that we have combined returns from three periods.

Numerically this gives us:

(1.15)*(0.9)*(1.05)^1/3 = 1.0281
Finally, to convert to a percentage, we subtract the 1, and multiply by 100. In doing so, we find that we earned 2.81% annually over the three-year period."

My request was to apply that formula to whatever cells in a spreadsheet that I selected; in other words, if I have a series of 95 cells with numerical data , and I selected a series of 3 consecutive cells, it would calc the resulting geometric return for those 3 cells only; if I selected a series of 7 different cells, it would give the answer for those 7, etc.

Unfortunately, I use Apple Numbers, not Excel, so the macro that was created for me won't work. I'm wondering if AppleScript or automator can be used to create the same result for an Apple Numbers spreadsheet? The excel spreadsheet with the macro is attached.

Winner

## Tableau de clarification publique

Aucun message pour l'instant.

## Comment commencez des concours

• Publiez votre concours Rapide et facile

• Obtenez des tonnes de propositions De partout dans le monde

• Attribuez la meilleure proposition Télécharger les fichiers - Facile !

ou rejoignez-nous maintenant !