You don't need to be an 'investor' to invest in Singletrack: 6 days left: 95% of target - Find out more
Hey excel champs...
I'm trying to make a table showing a sliding scale of ownership, from year 0, to year 26..
Year 0 is a 20/80 split of ownershipand year 26 is a 50/50.
How do i create a sliding scale in teh in-between years...
I made one using a VERY complicated method, but with the wrong figures, and came up with teh following chart:
0 19.4 80.6
1 21.9 78.1
2 24.3 75.7
3 26.4 73.6
4 28.2 71.8
5 30.0 70.0
6 31.5 68.5
7 33.0 67.0
8 34.3 65.7
9 35.5 64.5
10 36.7 63.3
11 37.7 62.3
12 38.7 61.3
13 39.7 60.3
14 40.5 59.5
15 41.3 58.7
16 42.1 57.9
17 42.8 57.2
18 43.5 56.5
19 44.1 55.9
20 44.7 55.3
21 45.3 54.7
22 45.8 54.2
23 46.4 53.6
24 46.8 53.2
25 47.3 52.7
26 47.8 52.2
Is anone able to make a table starting at 20/80, and ending at 50/50 at all pleaes? or tell me how!!
Ta
DrP
do you want a straight line or some other method in between?
Assuming linear, and the numbers 0 to 26 are in column A1 to A27
then stick this formula in B1 and copy it down
=20+A1/26*30
and stick this in C1 and copy it down
=100-B1
basically year (i.e box) zero starts at 20, and increases linearly until box/year 26 = 50.
And the other is a decrease from 80 -> 50..linear
DrP
1.2
1 80 20
2 78.8 21.2
3 77.6 22.4
4 76.4 23.6
5 75.2 24.8
6 74 26
7 72.8 27.2
8 71.6 28.4
9 70.4 29.6
10 69.2 30.8
11 68 32
12 66.8 33.2
13 65.6 34.4
14 64.4 35.6
15 63.2 36.8
16 62 38
17 60.8 39.2
18 59.6 40.4
19 58.4 41.6
20 57.2 42.8
21 56 44
22 54.8 45.2
23 53.6 46.4
24 52.4 47.6
25 51.2 48.8
26 50 50
Cheers Ed..have whatsapped you...
DrP
oops, you were faster than me. I've edited my post above with the formula you need
The difference is 30 which you just need to divide by the 26 and add to the 20 or subtract from the 80. And you only need to calculate one side as leffeboy says as the other half is just 100-(the other calc)
Yes, the key to this fiendish puzzle is 30 divided by 25, aka 1.2
It's a good job he's not a doctor or something.
listen.. not ONCE in my job of ignoring people crying or telling them it/they should go away do I EVER use mafs.
Thanks all!!
DrP
Is this a scale of how many s**** you give depending upon the age of the person?
Yes, the key to this fiendish puzzle is 30 divided by 25, aka 1.2
depends if you start year 0 or 1. He started on 0 so I think it should be /26 ?
Yes it's 26 and must be because it starts at 0 (what sort of weirdo starts at 0?!?), I'm sad enough to have made my own spreadsheet just for fun to test (I'm not weird)
Linear interpolation, I suppose you GPs don’t need maths to stick a single digit up.
Here’s some homework
what sort of weirdo starts at 0?!?
oooo, that's going to bring the programmers out here
It's for a deed of trust! Equity share in the house were we to die/hate each other....
Starting at 0 for completion day...I.e TODAY!
WHOOP!
DrP
Woohoo! You got there in the end, Congrats!
(with the house, not the excel formula!)
When's the housewarming?