LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Code for sigma of product involving exponential - help

Hi all,

Could any guru help me with the following problem.



The formula I want to implement is :

f(n) = k1 x Sigma [w(i) x exp(-n-i)/tau1] where i goes from 1 to n-1.

n are my days that are arranged in a column C.

w(i) are rows in column C and the formula f (n) needs to go into rows of colmumn E.

Some more specifics of the problem with an image of my spreadsheet was described here : https://stackoverflow.com/questions/...27055#50027055


Appreciate any help implementing an elegant code, thanks.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Product Code Sanjo Setting up and Configuration of Excel 1 February 11th 10 05:02 AM
Product Code and Product Description setup Nastyashman Excel Worksheet Functions 4 July 6th 09 05:48 PM
Vlookup code product and to copy commentary with photo of the product in vba [email protected] Excel Programming 0 October 2nd 06 03:54 AM
ROBBYN - RE -Code Refinement involving blank cell(s) COULD NOT POST FOLLOWUP ross Excel Programming 1 June 2nd 04 01:21 AM
Code Refinement involving blank cell(s) Robbyn Excel Programming 1 June 1st 04 01:16 AM


All times are GMT +1. The time now is 11:02 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"