POV-Ray : Newsgroups : povray.off-topic : Sums in a Spreadsheet : Re: Sums in a Spreadsheet Server Time
7 Sep 2024 13:22:58 EDT (-0400)
  Re: Sums in a Spreadsheet  
From: Tim Attwood
Date: 10 May 2008 03:46:13
Message: <482552c5$1@news.povray.org>
>> The original function is f(x) = M*R*(D^x), where M, R and D are 
>> constants.
>>
>> I'd be using the function g(A) = sum of f(x), where x=0..A

In open office the seriessum function comes close to what you want.
http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_SERIESSUM_function
I don't think spreadsheets have a way to pass a function as a
first class value though, you could write some basic macro but
that's what you want to avoid.


Post a reply to this message

Copyright 2003-2023 Persistence of Vision Raytracer Pty. Ltd.