Biopowered - vegetable oil and biodiesel forum

General => Wiki and forum discussion => Topic started by: K.H on November 02, 2011, 10:19:13 PM

Title: Oil usage form
Post by: K.H on November 02, 2011, 10:19:13 PM

Just remembered i did a basic oil usage form on Chugs website
http://www.biofuel-uk.net/OIL-USE-FORM.doc
Would it be of use on here?

Title: Re: Oil usage form
Post by: Tony on November 03, 2011, 10:16:42 AM

Poooosibly.

I keep a spreadsheet... this whole rolling 12 months thing is a right pain though, as you can't just consider 1st Jan 2011 to end Dec 2011 but all the other 12 month combinations.

Title: Re: Oil usage form
Post by: Keef on November 03, 2011, 04:03:45 PM

I use Vince's (hifly) excel spreadsheet which I find really useful because it calculates the maximum you are allowed to produce the following month based on the figures you have given it to date.
Otherwise it's quite time consuming calculating it manually.

It would also be quite easy to adapt it to your individual requirements if you have a basic understanding of excel.

Title: Re: Oil usage form
Post by: Julian on November 03, 2011, 05:09:31 PM

fred1 has offered us his version, sounds similar to Vince's, see this thread ... http://www.biopowered.co.uk/forum/index.php?topic=232.0

Title: Re: Oil usage form
Post by: Keef on November 03, 2011, 05:38:24 PM

Maybe a side by side comparison of all the forms available to us and publish the best one?

(Edit to say) I've just been over the original vod thread and now realise that fred1 has upgraded the original hifly version. Unfortunately I can't download it so I'm unable to pass comment.

Seems like we now have four forms? Keith's, tttonyyy's, Vince's, and Fred1's.

Title: Re: Oil usage form
Post by: Tony on November 04, 2011, 10:12:55 AM

Nah just three, mine is but a simple spreadsheet :)

Title: Re: Oil usage form
Post by: Julian on November 08, 2011, 10:37:14 PM

I've now got fred1's spread sheet.

Tony, will it compromise security if we you allow .xls files to be up loaded, so comparisons can be made with Vince's?

Title: Re: Oil usage form
Post by: Tony on November 09, 2011, 12:25:15 PM

Not a problem - I've enabled XLS uploads.  The security issue with XLS lies safely away from the server, at the user's end :)

Title: Re: Oil usage form
Post by: Julian on November 10, 2011, 08:37:20 PM

Just up-loaded a copy of fred1's spread sheet here http://www.biopowered.co.uk/w/images/2/20/Oil_limit_2500_check7.xls 

Keith (the inky one) can you do the same with Vince's or make the comparison and let us know the merits of each?

Title: Re: Oil usage form
Post by: Keef on November 12, 2011, 12:03:39 AM

Here is vince's version although tbh, there's no contest.  Fred1 clearly knows his way around excel.

http://www.biopowered.co.uk/w/images/9/95/2500_limit_check.xls

Title: Re: Oil usage form
Post by: Tony on November 14, 2011, 09:13:52 AM

Yes that's not bad at all :)

Title: Re: Oil usage form
Post by: Julian on November 20, 2011, 01:43:25 AM

Quote from: max.print on November 12, 2011, 12:03:39 AM

Here is vince's version although tbh, there's no contest.  Fred1 clearly knows his way around excel.

http://www.biopowered.co.uk/w/images/9/95/2500_limit_check.xls

I don't think there's much in it they both seem to work in a similar fashion.  Fred's seems a bit more involved and will need his figures removing.

So should we go with Fred's and the one keith flagged up?