software

This is a difficult one to explain, so I will provide an example:

a1
b2
c3
d10
e
f
g
h
i
j2
k5

Rows a through c contain a value for a given period, while row d contains a
lump sum for all future periods. Row j is the average of rows a through c
(which I am using as an estimate of future periodic values), while row k is
row d divided by the average calculated in row j (the number of periods
necessary until the lump sum is reached). What I am trying to do is then
repeat the average calculated in row j in rows e through i the number of
times shown in row k (thereby giving me 8 periodic values as opposed to 3
periodic values and one lump sum). Any ideas on how to do this?

Thanks so much for the help.
Not sure, but perhaps this plunge
might start the ball rolling here lt;ggt; ..

Assuming the example data is in A1:B11,
where you probably have
in B10: =AVERAGE(B1:B3)
in B11: =B4/B10
(I'm just reading it straight from your post)

Then, perhaps just put in B5: =$B$10,
and copy B5 down to B9

Is that it ?
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Damienquot; gt; wrote in message
...
gt; This is a difficult one to explain, so I will provide an example:
gt;
gt; a 1
gt; b 2
gt; c 3
gt; d 10
gt; e
gt; f
gt; g
gt; h
gt; i
gt; j 2
gt; k 5
gt;
gt; Rows a through c contain a value for a given period, while row d contains
a
gt; lump sum for all future periods. Row j is the average of rows a through c
gt; (which I am using as an estimate of future periodic values), while row k
is
gt; row d divided by the average calculated in row j (the number of periods
gt; necessary until the lump sum is reached). What I am trying to do is then
gt; repeat the average calculated in row j in rows e through i the number of
gt; times shown in row k (thereby giving me 8 periodic values as opposed to 3
gt; periodic values and one lump sum). Any ideas on how to do this?
gt;
gt; Thanks so much for the help.
gt;
gt;
That would do it in this case, but my problem is that I'm trying to automate
the process. I'm using a Bloomberg feed that would automatically fill in data
for five years and then one lump sum for all future years. Those values will
always be different, so I will always have a different average and number of
times that the average divides into the lump sum...

I suspect that there isn't a simple function to do this - perhaps I'll play
around with VBA and see if I can work something out.

Thanks for the response though. Take it easy.

quot;Maxquot; wrote:

gt; Not sure, but perhaps this plunge
gt; might start the ball rolling here lt;ggt; ..
gt;
gt; Assuming the example data is in A1:B11,
gt; where you probably have
gt; in B10: =AVERAGE(B1:B3)
gt; in B11: =B4/B10
gt; (I'm just reading it straight from your post)
gt;
gt; Then, perhaps just put in B5: =$B$10,
gt; and copy B5 down to B9
gt;
gt; Is that it ?
gt; --
gt; Max
gt; Singapore
gt; savefile.com/projects/236895
gt; xdemechanik
gt; ---
gt; quot;Damienquot; gt; wrote in message
gt; ...
gt; gt; This is a difficult one to explain, so I will provide an example:
gt; gt;
gt; gt; a 1
gt; gt; b 2
gt; gt; c 3
gt; gt; d 10
gt; gt; e
gt; gt; f
gt; gt; g
gt; gt; h
gt; gt; i
gt; gt; j 2
gt; gt; k 5
gt; gt;
gt; gt; Rows a through c contain a value for a given period, while row d contains
gt; a
gt; gt; lump sum for all future periods. Row j is the average of rows a through c
gt; gt; (which I am using as an estimate of future periodic values), while row k
gt; is
gt; gt; row d divided by the average calculated in row j (the number of periods
gt; gt; necessary until the lump sum is reached). What I am trying to do is then
gt; gt; repeat the average calculated in row j in rows e through i the number of
gt; gt; times shown in row k (thereby giving me 8 periodic values as opposed to 3
gt; gt; periodic values and one lump sum). Any ideas on how to do this?
gt; gt;
gt; gt; Thanks so much for the help.
gt; gt;
gt; gt;
gt;
gt;
gt;

Thanks for the clarification !

gt; .. That would do it in this case,
gt; but my problem is that I'm trying to automate the process.

Yes, of course, that would be the usual inference lt;ggt;

Just to move it along a little further here ..

quot;.. Bloomberg feed ...quot;
This may well be second nature to you,
but probably not to a lot of us

Perhaps you could either* paste some representative data of how the feed
actually appears in the sheet in plain text in your reply (showing some
variations). Tell us how we can quot;identifyquot; which cell in the col will
contain the lump sum, how to identify when one feed ends and the other
begins, etc, etc (the variation patterns)

*Alternatively, upload a small sample file
and paste the *link* to it in your reply

Some free filehosts that could be used to upload your sample:
www.flypicture.com/
cjoint.com/index.php
www.savefile.com/index.php

For cjoint.com (it's in French), just click quot;Browsequot; button, navigate to
your folder gt; select the sample file gt; Open, then click the button centred
in the page below (labelled quot;Creer le lien Cjointquot;) and it'll
generate the link. Then copy amp; paste the generated link as part and parcel
of your response here.

Kindly note that no attachments
should be posted *directly* to the newsgroup

I'm not saying I'd ultimately have a further (formula) suggestion to offer
(it may be beyond me), but, if you deepen your clarification further here as
suggested above, it'll be visible to the many other regular responders out
there, some of whom may well have something to offer you.

Either way, kindly post a closure response here to let us know whether
you're keen to pursue this further. Cheers.
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---
quot;Damienquot; gt; wrote in message
...
gt; That would do it in this case, but my problem is that I'm trying to
automate
gt; the process. I'm using a Bloomberg feed that would automatically fill in
data
gt; for five years and then one lump sum for all future years. Those values
will
gt; always be different, so I will always have a different average and number
of
gt; times that the average divides into the lump sum...
gt;
gt; I suspect that there isn't a simple function to do this - perhaps I'll
play
gt; around with VBA and see if I can work something out.
gt;
gt; Thanks for the response though. Take it easy.