How to calculate release dates for prisoners?

[icecoldza]

I need a spreadsheet calculation where if a prisoner is sentenced today for a period of eg... 5 years 6 months it must give me the release date based on full sentence, 1/2 sentence 1/3,1/4 & 1/6 of his sentence period.

The 1/2 (Prisoner do only 1/2 of that sent.)
The 1/3 (Prisoner do only 1/3 of that sent.) ect.

Another problem is that sometimes the sentence is eg. 50 days or 6 months or 5 years 3 months ect.

Any help?

Thanks

 

[fairwinds]

Hi,

This seems to me the most fair way to do it:

F4: =DATE(YEAR($A4)+$B4,MONTH($A4)+$C4,DAY($A4)+$D4)
drag down

G4: =$A4+($F4-$A4)/G$3
drag right / down

Book1
	A	B	C	D	E	F	G	H	I	J
1		Prisontime				Releasedate
2	sentencedate	Years	Months	Days		1/1	1/2	1/3	1/4	1/6
3							2	3	4	6
4	10-okt-02	2	5			10-mar-05	25-dec-03	31-jul-03	18-maj-03	6-mar-03
5	10-okt-02			60		9-dec-02	9-nov-02	30-okt-02	25-okt-02	20-okt-02
6	10-okt-02	1				10-okt-03	10-apr-03	8-feb-03	9-jan-03	9-dec-02
7	10-okt-02	1	6	10		20-apr-04	16-jul-03	14-apr-03	26-feb-03	11-jan-03
8	10-okt-02		5	10		20-mar-03	29-dec-02	2-dec-02	19-nov-02	5-nov-02
9	10-okt-02		6			10-apr-03	9-jan-03	9-dec-02	24-nov-02	9-nov-02
Sheet6

 

[icecoldza]

Thanks. Working great.

 

[Legacy 21301]

Hmm ....

Let's say George gets sentenced on 28 Feb 2005 for 2 years 5 months (like Fairwind's first example).

He would be released on 28 Jul 2007 (using Fairwind's formula).

However, if Albert were to be sentenced one day later on 1 Mar 2005 he would be released on 1 Aug 2007 - which is four days later.

This does not seem too fair to Albert. He would have to serve 3 days longer than George just because he happened to be sentenced one day later.

The original question needs to be clarified.
How do the Courts calculate release dates?
I suspect that there is probably no standard Court procedure for such calculations, since the anomalies that arise as a result of the variable number of days in each year and each month are difficult(impossible?) to avoid.

 

[Legacy 21301]

Are Fairwind's formulas actually being used to calculate prisoner release dates in real life?

What about a sentence of 11 months from 31 March 2004?
The release date would be calculated as 3 March 2005.
That can't be right, can it?

I think a fairer formula in F4 would be :-

=EDATE(A4,B4*12+C4)+D4

 

[fairwinds]

Well Ponsy.

We simply do not know do we?

I think the fairest way would be to decide how many days a month mean and how many days a year mean, and then just add the days.

But really what we think is fair does not matter. I am sure some one with insight in the legal system in whatever contry is aplicable could put us on the right track.

 

[Legacy 21301]

I doubt that there is any country where a sentence of 11 months (say) can mean 11 months and three days - although the OP seems happy enough with it (I bet he's not a prisoner).

 

[fairwinds]

Stop whining, I've heard of contries where they never let you out.

Your suggestion is not fair either if you check it out.

 

[Legacy 21301]

Your suggestion is not fair either if you check it out.

An example please.

 

[jdavis9]

A years term is defined as calendar year, civil year - the year according to Gregorian calendar.

Meaning a year is from a date of sentence to the next years same date.

365 or 366 on leap years.

The same goes for a months. In one month out the same day next month.

So what you really need to do is determine the total number of days sentenced then you can do you calcs.