« previous next »
Pages: [1]

Author Topic: Oil usage form  (Read 4508 times)

Offline K.H

  • Administrator
  • Oil baron
  • *******
  • Posts: 2353
  • Location: Tosser towers
Oil usage form
« 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?
Logged

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5108
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Oil usage form
« Reply #1 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.
Logged

Offline Keef

  • Administrator
  • Oil obsessive
  • *****
  • Posts: 552
    • Adur Cooking Oils
  • Location: Sussex
Re: Oil usage form
« Reply #2 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.
Logged

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6389
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Oil usage form
« Reply #3 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
Logged
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline Keef

  • Administrator
  • Oil obsessive
  • *****
  • Posts: 552
    • Adur Cooking Oils
  • Location: Sussex
Re: Oil usage form
« Reply #4 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.
« Last Edit: November 03, 2011, 09:03:36 PM by max.print »
Logged

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5108
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Oil usage form
« Reply #5 on: November 04, 2011, 10:12:55 AM »
Nah just three, mine is but a simple spreadsheet :)
Logged

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6389
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Oil usage form
« Reply #6 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?
Logged
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5108
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Oil usage form
« Reply #7 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 :)
Logged

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6389
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Oil usage form
« Reply #8 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?
Logged
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk

Offline Keef

  • Administrator
  • Oil obsessive
  • *****
  • Posts: 552
    • Adur Cooking Oils
  • Location: Sussex
Re: Oil usage form
« Reply #9 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
Logged

Offline Tony

  • Administrator
  • Oil baron
  • *******
  • Posts: 5108
  • Fo' shizzle, biodizzle
    • Southampton Waste Oil Collection
  • Location: Southampton
Re: Oil usage form
« Reply #10 on: November 14, 2011, 09:13:52 AM »
Yes that's not bad at all :)
Logged

Offline Julian

  • Administrator
  • Oil baron
  • *******
  • Posts: 6389
    • Used Cooking Oil Collection website
  • Location: East Surrey, UK.
Re: Oil usage form
« Reply #11 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?
Logged
Used Cooking Oil Collection website ... http://www.surreyusedcookingoilcollection.palmergroup.co.uk
Pages: [1]
« previous next »