>> Well let's put it this way. If you wanted to calculate the geometric 
>> mean (assuming there isn't already a function for that), in VBA you'd 
>> have to write an explicit FOR loop (with initialisation, update, 
>> etc.), whereas in Haskell you'd just keep a "map" call... It's a 1-liner.
>>
> 
> Meaning that you have pre-done function/call for it in Haskell (no, it 
> doesn't have to be self-made, it just is implemented earlier, usually 
> since someone has needed it).

The point being that it is *possible* to define the "map" function in 
Haskell, whereas such a function cannot be defined in VBA. :-P

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message

Invisible wrote:
> in VBA you'd have to write an explicit FOR loop 

Not in Excel. What are you smoking? :-)

-- 
   Darren New / San Diego, CA, USA (PST)
     "That's pretty. Where's that?"
          "It's the Age of Channelwood."
     "We should go there on vacation some time."

Post a reply to this message

Orchid XP v7 wrote:
> 
> The point being that it is *possible* to define the "map" function in 
> Haskell, whereas such a function cannot be defined in VBA. :-P
> 

Umm.. I'm not getting this - why is it impossible to define in VBA?

-- 
Eero "Aero" Ahonen
    http://www.zbxt.net
       aer### [at] removethiszbxtnetinvalid

Post a reply to this message

>> The point being that it is *possible* to define the "map" function in 
>> Haskell, whereas such a function cannot be defined in VBA. :-P
>>
> 
> Umm.. I'm not getting this - why is it impossible to define in VBA?

Because in VBA, you can't pass functions as arguments to functions.

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message

Orchid XP v7 wrote:
>>> The point being that it is *possible* to define the "map" function in 
>>> Haskell, whereas such a function cannot be defined in VBA. :-P
>>>
>>
>> Umm.. I'm not getting this - why is it impossible to define in VBA?
> 
> Because in VBA, you can't pass functions as arguments to functions.

Oh, right. I bet there's *some* way to get the equivalent of function 
pointers, but I don't know VBA well enough offhand...

Actually, you can. It just takes more work. You have to do it the way 
you'd do in (say) java, and make a com object with the functionaltiy you 
need. Perhaps overkill, yes.

-- 
   Darren New / San Diego, CA, USA (PST)
     "That's pretty. Where's that?"
          "It's the Age of Channelwood."
     "We should go there on vacation some time."

Post a reply to this message

"scott" <sco### [at] laptopcom> wrote:
> http://www.gamasutra.com/view/feature/3563/microsoft_excel_revolutionary_3d_.php
>
> While this may be pushing it a bit far, Excel is actually useful for doing a
> lot more than most people realise...

My goodness, the robot is cool, but how did they get all those moving blue
lights in the background?!



(jk-- for a sec I thought the Intel ad on that web page *was* the image.

Post a reply to this message

Orchid XP v7 wrote:
> 
> Because in VBA, you can't pass functions as arguments to functions.
> 

I wouldn't be so sure, especially after reading Darren post. PITA for 
sure and the kind of work no sane person would do, but I wouldn't say 
impossible.

I might check at work some day, if I'll remember and if I'll have time.

-- 
Eero "Aero" Ahonen
    http://www.zbxt.net
       aer### [at] removethiszbxtnetinvalid

Post a reply to this message

>> in VBA you'd have to write an explicit FOR loop 
> 
> Not in Excel. What are you smoking? :-)

Really? Care to explain that one?

-- 
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*

Post a reply to this message

>>> in VBA you'd have to write an explicit FOR loop 
>> 
>> Not in Excel. What are you smoking? :-)
> 
> Really? Care to explain that one?

Off the top of my head:

=product(range)^(1/count(range))

...unless there is some geometric mean function, I didn't search for one.

Post a reply to this message

And lo on Wed, 12 Mar 2008 10:47:34 -0000, scott <sco### [at] laptopcom> did 
 

spake, saying:

>>>> in VBA you'd have to write an explicit FOR loop
>>>  Not in Excel. What are you smoking? :-)
>>  Really? Care to explain that one?
>
> Off the top of my head:
>
> =product(range)^(1/count(range))
>
> ...unless there is some geometric mean function, I didn't search for o
ne.

=geomean(range) which does exactly the same as your function.

-- 

Phil Cook

--
I once tried to be apathetic, but I just couldn't be bothered
http://flipc.blogspot.com

Post a reply to this message