|
|
|
|
|
|
| |
| |
|
|
|
|
| |
| |
|
|
"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
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>>>> 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.
Ah. In other words, "you don't need to code this because it's already
pre-defined".
Or, to put it another way, I picked a bad example. ;-)
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> Ah. In other words, "you don't need to code this because it's already
> pre-defined".
>
> Or, to put it another way, I picked a bad example. ;-)
Or, a lot of what you might want to do in a spreadsheet is pre-defined :-)
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
>> Or, to put it another way, I picked a bad example. ;-)
>
> Or, a lot of what you might want to do in a spreadsheet is pre-defined :-)
Or, I use a spreadsheet in a way that's very different to how normal
people use them.
(E.g., Excel doesn't provide a "convolution" function. And it would be
far too hard to implement one in VBA. Not because the algorithm is hard,
but because I'd have to figure out how to access the cells of the
spreadsheet...)
I tend to use Excel as a function plotter - and it's annoying that
things like an FFT are so hard to do.
--
http://blog.orphi.me.uk/
http://www.zazzle.com/MathematicalOrchid*
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
47d7d30f$1@news.povray.org...
> I tend to use Excel as a function plotter - and it's annoying that things
> like an FFT are so hard to do.
The built-in FFT in Excel doesn't work?
In any case, accessing cells with VBA is basic. Just start recording a macro
and put something in a cell to see how it's done.
G.
--
*****************************
http://www.oyonale.com
*****************************
- Graphic experiments
- POV-Ray, Cinema 4D and Poser computer images
- Posters
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |
| |
|
|
> Not because the algorithm is hard,
> but because I'd have to figure out how to access the cells of the
> spreadsheet...)
Oh my God.
Post a reply to this message
|
|
| |
| |
|
|
|
|
| |