Track your stash, green bean log - Green Beans - Coffee Forum


Coffee Forum

Please login or register.

Bezzera

Author Topic: Track your stash, green bean log  (Read 6754 times)

cosmic_couple22

  • Senior Barista
  • ****
  • Posts: 456
  • wanna be roaster
Track your stash, green bean log
« on: 29/07/2013, 11:32 PM »
Not sure if this is any use to anybody, did up a bean log for myself in excel.

[attachurl=1]

(hope this upload works)

Can record up to 20 different beans up to 25kg. (have a 100kg log if you need that much)

Just generate the info in to the  sheets - Bean 1, Bean 2 etc. etc. Name will show up in the front index sheet for ease of locating a bean type by sheet no. Couple of graphs for quick refrence and because I could  ;D.

Left a couple of fake entries as a demo, just click in the fields on the bean sheet and hit backspace to clear the entries.

If you can use it good, if you can offer improvments great.

Chester


Apprentice Coffee Roaster

Koffee Kosmo

  • Old Coffee Fella
  • ******
  • Posts: 4458
  • Gender: Male
  • Espresso Yourself
    • koffeekosmo.com
Track your stash, green bean log
« Reply #1 on: 29/07/2013, 11:52 PM »
Not sure if this is any use to anybody, did up a bean log for myself in excel.

[attachurl=1]

(hope this upload works)

Can record up to 20 different beans up to 25kg. (have a 100kg log if you need that much)

Just generate the info in to the  sheets - Bean 1, Bean 2 etc. etc. Name will show up in the front index sheet for ease of locating a bean type by sheet no. Couple of graphs for quick refrence and because I could  ;D.

Left a couple of fake entries as a demo, just click in the fields on the bean sheet and hit backspace to clear the entries.

If you can use it good, if you can offer improvments great.

Chester

Very good Chester
I have an app on the iPad that I can use it on  :thumb:

KK
Bezzera Strega Lever: Mazzer Robur conical grinder Pullman Barista Tamper Convex:  Designer of the KKTO Home Roaster:

Blog - http://koffeekosmo.blogspot.com

Lacehim

  • Old Coffee Fella
  • ******
  • Posts: 2090
  • Gender: Male
  • NS Oscar|BSG|KKTO
Track your stash, green bean log
« Reply #2 on: 30/07/2013, 09:53 AM »
What app is that KK?

Koffee Kosmo

  • Old Coffee Fella
  • ******
  • Posts: 4458
  • Gender: Male
  • Espresso Yourself
    • koffeekosmo.com
Track your stash, green bean log
« Reply #3 on: 30/07/2013, 10:26 AM »
What app is that KK?

Both 1) Smart Office - and 2) Document and Documents 2
Bezzera Strega Lever: Mazzer Robur conical grinder Pullman Barista Tamper Convex:  Designer of the KKTO Home Roaster:

Blog - http://koffeekosmo.blogspot.com

Ol Grumpy

  • Senior Barista
  • ****
  • Posts: 419
  • Gender: Male
  • Neeeed Goooood Coffeeeeee!
Track your stash, green bean log
« Reply #4 on: 04/08/2013, 11:16 AM »
I'd recommend you try the native iPad 'Numbers'
It's very good. I have several highly formatted multi-page Excel sheets I use in 'Numbers' I'm no expert by any means but I use these sheets for quotes so there's many financial calculations and links across sheets which all seem to work fine in 'Numbers'
The let down for me was the links between 'Excel' and 'Word' which do not function on the iPad.... Yet?
But for purely excel sheets I'd really recommend 'Numbers' or create a 'Numbers' sheet from scratch... It's really easy...

I'd made the assumption that I needed another app to read and use excel sheets, then discovered by accident you can open and save excel sheets right in numbers... So easy!
FZ-RR 700 Baby Roaster, Presso, Bellman Steamer
HC Rossa + PG, Pharos + Vd Mods, Otto Induction Plate
OE Slapshot System

Kelsey

  • Global Moderator
  • Old Coffee Fella
  • *****
  • Posts: 1973
  • Gender: Male
  • Third wave. Heh.
Track your stash, green bean log
« Reply #5 on: 04/08/2013, 12:01 PM »
Numbers, both on OSX and iOS is one heck of a spreadsheet package. Love it.
LONDINIUM I, Compak E10.

Full disclosure: I have commercial arrangements with Bezzera (AU) and Londinium Espresso. I am not required to market them on this forum & any opinions expressed are my own.

Ol Grumpy

  • Senior Barista
  • ****
  • Posts: 419
  • Gender: Male
  • Neeeed Goooood Coffeeeeee!
Track your stash, green bean log
« Reply #6 on: 04/08/2013, 04:30 PM »
Actually, I had also purchased the app 'Templates for Numbers'....
For a couple of dollars there are some really great templates for all manner of applications and feature lots of graphic elements which are easily customised...

I got the same app for 'Pages' as well and I will say I was very impressed with the offerings.... Well and truly worth the few dollars they charge...
FZ-RR 700 Baby Roaster, Presso, Bellman Steamer
HC Rossa + PG, Pharos + Vd Mods, Otto Induction Plate
OE Slapshot System

cosmic_couple22

  • Senior Barista
  • ****
  • Posts: 456
  • wanna be roaster
Track your stash, green bean log
« Reply #7 on: 11/08/2013, 11:31 AM »
Anybody got some feedback as to whether this is handy or what you would like as an improvement.

Chester
Apprentice Coffee Roaster

Koffee Kosmo

  • Old Coffee Fella
  • ******
  • Posts: 4458
  • Gender: Male
  • Espresso Yourself
    • koffeekosmo.com
Track your stash, green bean log
« Reply #8 on: 11/08/2013, 11:36 AM »
Anybody got some feedback as to whether this is handy or what you would like as an improvement.

Chester

Sorry I haven't had time to enter my stash
Bezzera Strega Lever: Mazzer Robur conical grinder Pullman Barista Tamper Convex:  Designer of the KKTO Home Roaster:

Blog - http://koffeekosmo.blogspot.com

Coffee Curators

 

Related Topics

  Subject / Started by Replies Last post
2 Replies
3882 Views
Last post 06/04/2008, 01:03 PM
by askthe coffeeguy
49 Replies
24381 Views
Last post 28/09/2017, 06:10 PM
by Lwowiak
16 Replies
10455 Views
Last post 01/11/2011, 10:44 PM
by Brett H
5 Replies
3787 Views
Last post 03/06/2013, 05:13 PM
by Lacehim
16 Replies
7190 Views
Last post 31/07/2014, 05:45 PM
by derrilex

SMF spam blocked by CleanTalk