Search:

Type: Posts; User: benbulloch; Keyword(s):

Search: Search took 0.00 seconds.

  1. Re: cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

    I figured it out. Not the most elegant solution but it works. The "var col = s.getRange(4,1).getValue();" is just a MATCH function. I'd still prefer to have the row lookup without hardcoding the...
  2. cut/paste scripting - copy a range then paste to a destination range that matches to row/column address criteria - INDEX/MATCH but cut n paste

    I'm struggling with some simple copy/paste scripting in Excel/Sheets. I'm a complete scripting newbie. Advanced at Excel/Sheets.
    I have a "Today" data entry sheet. I have a "Program" sheet that...
  3. Re: Cost Distribution based on Bell Shaped Curve

    I've been screwing around with the exact question for quite some time and finally have a good normally-distributed s-curve generation formula for spreading project costs over a number of months. ...
  4. Replies
    17
    Views
    37,481

    Re: S Curve dilemma

    I've been screwing around with the exact question for quite some time and have a good normally-distributed s-curve generation formula for spreading project costs over a number of months. My question...
  5. Re: Financial Statement Modeling - Managing Circular References Using Iteration

    What do you define as "blowing up"? Does the model give you #VALUE errors? These are typical in my models with iteration that blow up. Files-> Options-> Formulas gives the the option of setting...
  6. non-normal (skewed) project cost distribution across months - gamma distribution? calculus?

    I have a real estate development project with hundreds of cost line items. One cost line is appended below.

    I want to distribute the cost for each item across time in a number of distribution...
  7. Re: output 1st, 2nd, 3rd ... non-zero value in a column (or row)

    I realized that I could just use:
    {=INDEX(D$127:D$184,SMALL(IF(D$128:D$184>0,ROW(D$128:D$184)-ROW(D$126)),ROWS(A$1:A1)),1)} (without the + row offset)

    With your original formulas, I was picking...
  8. Re: output 1st, 2nd, 3rd ... non-zero value in a column

    Most excellent Adam! I knew I was getting close. I had to tweak very slightly to:

    {=INDEX(D$127:D$184,SMALL(IF(D$128:D$184>0,ROW(D$128:D$184)-ROW(D$128)+2),ROWS(A$1:A1)),1)}

    and ...
  9. output 1st, 2nd, 3rd ... non-zero value in a column

    I am having difficulty outputting only the non-zero values (computed from a formula) from a column buried towards the bottom of a sheet. I can make an array formula work if the values are in f1:f100...
Results 1 to 9 of 9