HomeRoast Digest


Topic: Coffee "Stash" inventory and Roast record software...? (8 msgs / 302 lines)
1) From: Coffeenut
This is a multi-part message in MIME format.
Seems I recall we had a member here who had shared a really neat inventory
tool a few years ago that was created in Microsoft Access.  I don't recall
his name, but is he still around and producing that tool?
Rick

2) From: miKe mcKoffee
DJ Garcia wrote it, link and download etc. still active.http://improbablystructuredlayers.net/CoffeeRoastingDB/CRDBHome.htm 
Kona Konnaisseur miKe mcKoffee
URL to Rosto mods, FrankenFormer, some recipes etc:http://mdmint.home.comcast.net/coffee/Rosto_mod.htmUltimately the quest for Koffee Nirvana is a solitary path. To know I must
first not know. And in knowing know I know not. Each Personal enlightenment
found exploring the many divergent foot steps of Those who have gone before.
Sweet Maria's List - Searchable Archiveshttp://themeyers.org/HomeRoast/	From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Coffeenut
	Sent: Tuesday, January 30, 2007 1:56 PM
	To: homeroast
	Subject: +Coffee "Stash" inventory and Roast record software...?
	
	Seems I recall we had a member here who had shared a really neat
inventory tool a few years ago that was created in Microsoft Access.  I
don't recall his name, but is he still around and producing that tool?
	Rick

3) From: Justin Marquez
On 1/30/07, Coffeenut  wrote:
<Snip>
IMHO (and of course, they never ARE...) - If you need an Access
Database to manage the "stash" and you aren't running a coffee shop,
you need to start going to them danged ol' 12-step Caffeine-aholic
Meetings.
Safe Journeys and Sweet Music
Justin Marquez (CYPRESS, TX)

4) From: Coffeenut
Mike,
That's it!  Thanks for finding and sharing it.  I've already downloaded it
and will play with it some this evening.
Justin,
I like this kind of stuff...it feeds my need.
Rick

5) From: Les
I have found a simple Exel sheet meets my needs.  I was doing the random
thing for the past three years.  I can't believe how unbalanced my stash
is.  I like variety.  However now that I know what I have, I can feel good
about buying some coffees and good about letting some others slip by if the
stash is too big in that area.  I thought I had another 5 pounder of Bugisu,
but I am down to 3 pounds.  That is dangerous for my stash.  Kona was down
too.  Ethiopia and Brazil are over represented!  Kenya and Centrals are just
right and I have missed some great Mexican coffees, but I need to sacrifice
somewhere.  The end result.  I ordered 3 coffees today and I feel good about
it.  I let 3 coffees pass because I have a nice supply of those.  So, for me
an inventory gives me peace of mind again.  I was getting frazzled about all
the great coffees coming, now I have a tool to evaluate my wants and needs.
If having a spread sheet gives me peace of mind, that is a good thing.
Les
On 1/30/07, Coffeenut  wrote:
<Snip>

6) From: Coffeenut
Les,
I agree and have been using an Excel spreadsheet for inventory/order
management control too.  Once you have your stash into the spreadsheet it's
also easy to chart it and get a quick visual of levels.  I don't do much
record keeping of my roasts anymore.  A newbie might find DJ's program
useful especially if you had it running on a handheld device that could be
used while roasting.
Rick
From: homeroast-admin
[mailto:homeroast-admin] On Behalf Of Les
Sent: Tuesday, January 30, 2007 6:51 PM
To: homeroast
Subject: Re: +Coffee "Stash" inventory and Roast record software...?
I have found a simple Exel sheet meets my needs.  I was doing the random
thing for the past three years.  I can't believe how unbalanced my stash is.
I like variety.  However now that I know what I have, I can feel good about
buying some coffees and good about letting some others slip by if the stash
is too big in that area.  I thought I had another 5 pounder of Bugisu, but I
am down to 3 pounds.  That is dangerous for my stash.  Kona was down too.
Ethiopia and Brazil are over represented!  Kenya and Centrals are just right
and I have missed some great Mexican coffees, but I need to sacrifice
somewhere.  The end result.  I ordered 3 coffees today and I feel good about
it.  I let 3 coffees pass because I have a nice supply of those.  So, for me
an inventory gives me peace of mind again.  I was getting frazzled about all
the great coffees coming, now I have a tool to evaluate my wants and needs.
If having a spread sheet gives me peace of mind, that is a good thing. 
 
Les
eJ8+IjEAAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQOQBgA4FgAAJgAAAAsAAgABAAAAAwAmAAAAAAALACsAAAAAAAMA
LgAAAAAAHgBwAAEAAAA4AAAAK0NvZmZlZSAiU3Rhc2giIGludmVudG9yeSBhbmQgUm9hc3QgcmVj
b3JkIHNvZnR3YXJlLi4uPwACAXEAAQAAABsAAAABx0TJvMymzjYngxdA+4deFp9VXdFuAACiP7AA
CwABDgAAAAACAQoOAQAAABgAAAAAAAAAT3kGbBzXMECkOugKfPHa5sKAAAADABQOAQAAAB4AKA4B
AAAAKwAAADAwMDAwMDA2AWdvdGNvZmZlZUBiZWxsc291dGgubmV0AUdvdGNvZmZlZQAAHgApDgEA
AAArAAAAMDAwMDAwMDYBZ290Y29mZmVlQGJlbGxzb3V0aC5uZXQBR290Y29mZmVlAAACAQkQAQAA
ACASAAAcEgAAqikAAExaRnVJcjwoBwAGAQELYG5nMTAyZjUAZAByY3AN0A4AMh0MYGMNRAE0ATFz
dHPiaAVwYmNoEDUJABDHZmgOsBDWYmkBQw2kM/IzEuZmZRNiAfcCpANjRwIAEMAKwHNldALRcChy
cTIAACoKoW5vLRYgIA3wF3E2E3AwNZwwNBfxAdAX4DR9B23fAoMAUAPUFc8W22IXsRggnxeCHMQY
oAcTAoMzNhofnxsvHDcX5ByiGKFhaANxjQKDMiJgFV4yMzgfVOIgB20gQ0UiFROQIq7nGBAjzyTV
eXIiFQ4QFW1cMTYaAScvA4JHCdFrvyIVHjEpTiKBKn8DglQIcM0iFTcCABKwZGkDNimYDjcv0S3v
A4IoSGVi+QlwdykiFSOxMA8xFCO/XzKGBxABoA6wM2Y5NG841x4xNb8DgkIHQHQOsCIUuxfgOA82
JcE5XzKzVgiQqHRuYQeBZTNlMyKB/x5sI5gHEyUnE4E/fibnQQX9KIYzKREebCooQQQryR4v9y2J
QQQvNzMv2ETdMWdBBL8y/COiSl81LExFNxszN/H/RN05F0EEOqoYIFEfPJdMRfk+PjU4P18jmSHD
JSZXAP9B/ybZWOUohVcARK8qKVjk/yvIVwBHfy2ZWOQvNlcASi//Sz9Y1TL7VwBNn06vZFY3Gp9X
AFEPOQlY5DqpNTlT73c8iWRlVg85Gg8iY2QLVF0e4GkzYQKRCOY7CW8w9XLPZQ4ANXP6dRF0z3XZ
/3PkdgJ0b3g/d/13f3Wvc///FDAz0H3KfuF+n3+pc+R/0r9+P4IPgc2BT39/g0Q5DyA/hpSH8YAT
h/ACghBQeWxVB5BoCeB0AABxAyFsDxLBBRABQAPwZGN0bJcKsYrQNyBwAQFhdTrAPQBgcwqwizAe
4IwybnVKbQIAYYvwdG8NUWrmdRBQBRBnaIwgBRAKAcuKYAoBaQGQcDADMAAgpmwQwB6xczEDMGEB
Mf+QQAvwJvAHQA21ikGOAI+0/49RkJMTJxPoCNAJwDQgkpMcbnCS6ZSEAzBzbmX+eB8wB7AFsADA
AnMW4I/x749RDWA0MDrQdhdQEEAfEJxtaRIAl3AJ8CBEi9Q0IFAKwGEJwIugaCDuRgIhlqQQYDEA
UBBgA2BOdwswjgABgHNXNCB0vGhCE5COAAqwl3BsDeD7NYCcFHKciA2Qm/YBgJ33ymKd93Kb8mNi
CrAqEP+f4h9goEMCYAuACZGhFIlwjHBlm/EE8GVsbIrh95vAm2GhcXOXwAAgOrGacf8zIJ0Qo9YJ
UKP0DLGkA4tg+aP0ZGek1qZQpdaPwKP0/nYDMIoviz+MT41fjm+Pf/+Qgq1xkZ2swQ20koQUIpCx
/5PssIeyBJW1mqCX7JZEWMH9AmBllqeRYZdora2u/Kog9wjQIlCVsWKqYAmAAiCXIb5IogGkwAuA
LAOW4za2D/+3H7gvuTeZ4KKQmwAJgLnP3zFQuv+8D5HluRlnAMADEKBfcXVvdLVYOMBvv4/XAFGu
vxnkDAGgoDm4+/eX+xBAueFzAiBBMRBAcuDRC1B5IEXDslOJcjkAf3HzFuALYMQwAjCJZKhwc+Zk
EFAHcGF4teBfcM1hbRFRawmAAQEwlrNy4HaxAlEge1W6MBcgdxmh/5azDtAFMM+S0KIMQNCxJvDv
rTOod6QAEDFhzvLRT9Jf/9Nv1H/Vhq0V1n/Vb9if2a9/2r/PBACQm7DPkd4jRJA05wHQN/DeMjQ3
dpA7Yd4y4TFQOTY4NCbw3sMTcH9vYA3w3rQtoGIg30UjoDH+M+CwAFDfc98QWcAtod9z8WIgNzQ5
L9DeMt8QGCD330ATkOSjNiow5bA1gOSj+WwQNjTjtRfB5TBvYebj9zkB5RDjBDfi0FDwJbHeMvlX
EDY5bBAOEOAjnJC14N/iIF9w4CMX4SOgNunFYhFvgFHkhCog5RA1E2GWs3h8bWwAgNDk7WOQEKxg
dHBwOi8vBPCJwADAc64umDAFABcwbwGALgWgFG0v79BmDrBlL3f5BbBkLwHQE3Dws+1wApGn7WM9
AAhwbjru9S3vd/ot8BE68FTykADAACABkNxnc3IACqG54XcO8FPC/fUzaOvBU9H0gaZgOQDlEL/2
o50g9xYqEOTx9qNi+EP2Z6uQxDByrMGsIB8QqTA/AzCpAZsAqTCkwQGAbmL+agBgCfCXcBFgAPAC
IMQh4wbQCYBzeXMCEgBQ+8j5rOFnZKBA25AJsQVwEWD3z2DMwgFAdgdANCDMoe1hv/zQEHCbAAtR
onAh0GybsN+V8gxAlHAFsJgheAmABaD/FMDMwdtil8ALgP8T7WEQMX//8e1hymAVcB8A/NAXIHir
zJGroHkJ8FyV8HAQcP/BIAuQFyCqIfqwqnD7oRTA+wlADpBiEKAEMapxonAUoLZyvYEHYW0QcA1h
XCHQfHJ6+4PDofbQC4GmUGj3BxP3AQjRdgmpCGGsQKzw7zFQ6DEKMQslOeCgCWP/8fsLswzkagUB
GZCbIPuBofLlIoB2PkB3a6FBe8AO4r+iYJDgFDH10fjAp2JlnuDfEEUUoMQgyjHLMHTQIKzw/whA
+uER16xgy3CrkKpwBDH/7YCsYKvRoRG9cB8QOsC+EP/tgJDRBlKhQahwEeAP0akw/7UwmxER0aER
wSCnAe2AMyD+aweBCEAb4BdhqaDQ0pXB/61Qq6CT8qzwonKQ0b7h8HAfooCYgc2AooCpkXBwde8Z
UKpCT9AXWWrOkPJwGvTf3jIpQMQg4eaV4HehEczx/weBXQAgEIPQ+nCrgvBw+hEXsrAA4NByd/4x
Zm10l/BwOsDKYCDoMDNm9RC/y5ARYMtwD9AV4O2Addyy75wSIQCJUPnxZK7z+eKs0n+V8Dtw+1ET
4MpgCEAQVG//0NA/QfniI/KT8kdg2yEjEv+p9CIQIvPlavyA+vLREdCR8+2Q+fBsdv+xqxHzQKtA
vylB9MDBICnCoUHMwTfIMX+rEEVQksDREpoAlgBZIC7/0FUpVVcgKeKRkSpPK18sb/8poFUQqxCY
gPugLj8vTzBffmzcYKsQrcAt/zLPM9Up3yy8e8AxnzaPM7ViTJDbsv83zymCX3A1XzovOz88TymR
/2IwPaIqLz8PQB84LYOwPa//Qz9ET0VfKZFpMEI/R99I7/9J9fXhpkDXkLAgrPCu86li/6hPqV+q
b6t/rI7cFMEPkH//kY+Sn5OvlL+JQMW/xs/H2icBAO2Q7FogTM0wLA3KCk7iIGB1SSCZcXNQ72Fg
oVDucAJhIPwwmJFT4Nf9oWHBy1B4onEgUlBy4Oue4ImzIAdhIAKRzMEHcL558ECmQCDxy3BukGeY
ID3MwSABwh0wUDBTgG8uyCAgTxlRIHkFoGIE/2eBIQBL0QzgZJFTgGbAELD/Y5sfgMEQxANjkGFg
zWBo8P8QwPxgZsFmQGzRafJhw2XgTWwRIMQA8zBrIA7gc/Z1tOHwUCCJkJfAzWAsoP9cL10/Xk9f
XGcQYVC5YW5P/29fcG9fTWo2ct9z73T/X03/+hC5YGWQKgCZwH3g8BCmQN4gzpDLEGLSbaFty0Ad
MOdSQJrQYcF5bQFBd394j6d5n19NZwFBIB3xYg7w32WQVCJkUKFBmLBKfm9/f/+Aj3YPdx+Ez4Xf
hu9f8mqw82OwGPFhbWKhB1BSAGsQ3cpBYxtwopDLQGltsGeE9yNAH4EHgG4SEX0ByhBOkP03QWQQ
sACQcpBt4PCBaQF/oEBmQVIAI0D8MI1iI0B3/5hQbdB9dP2hbj+Jv4rPXz69YHxSbPFgfE7UT5hj
UE//UV9Sb1N/VI/QwFZwk36u7d+4wK0RX03XgfMwdNBz8zD/jPHcAAzgyyDqAlew7fCcoG+lEcoQ
CAGOAFS/Qddxc02oEDHMMqU1ZkaasHDuSKY03cOm6lanv4ORjlA+QwCAB3CmNeUQC5E4ON+mq6ph
vxCmP2RQTBIhqT8zasEBEUhSrO9ykHhIXwKAnoGvxusAsFtX3lFoS6/H5oA1qBtMYWeBdPhJbkMZ
ca/vZFDLsA4Rl08Br8+nIkgLIXpSF6H/t2+0v6Zk9RHzMA/DzeCz0f27t3k9gfMw80HLIPXRvWR/
+YG9VQDhvVXbUaNx9YA3u+aQo2Joq6Atkb/hZ32Q9/bw5RC902jBIrPwmxFmAHv0wCCxZUaQFWHQ
0GFwLXfo8OmA5mA2wCDDEyJAaT3fsDfQcsRDGSBkUDFlbjDjgOCw9aA5+NDhEGN/5bHgsCHQ+NCV
wOcgHaBiE/UQgwBuM+RQIAEAIAkAAAO7yGAABiwAHMihyGAEyKEDAcgIAAXIoQsCyQLJ0kAMAlgA
8hPJUi4EARjI4/sCEAAHBckDvMojAQICIlOf/HD9MchgyvDIYEqhyGAAHEUSACbigjmwiJriAcqw
yTQtyDCZyUMCAcgwy5Sc/8kDDACQz2HJMUAAElR2aWYAarBODwCYUCGxbl/QlNKJzxTIMMnSCcoi
AoINyKEyCloAOcmQp8lB1TDIYCUXytAgz0AryHDIoR7MA/zKIayonpnTZ8ogybDIYPoCydJdyGD/
2NDPBdWgDsihJJ4DydDY4djBytBeGtpy/9iyyGDYFNL+yVDWttjSzvbzydDJUicB2NDPFtZSyGD/
LLKgT6Fflp+ZP0//m1+cb/+df56Pn59WRQbQVqAmcJSPn+FxBtDrEpX14c8gRh0w//Pg36/rL1hk
7L9xugsQZgDNfYMtCCCDQG5A5IB9sfguc3dkIfiRG3BuIAHAzY1QW2WgIMFvOvMf9C/99TFdiK/q
7+v/8Z9f1Gcw3CBCAGBXQG2wT22w7s//+a/w7/vvYDEj4/2/+W/6f/sAn1/UU0yR7r8Dz//fBg8Z
ZxBUddHAtwB5LCD+ShuAbWBlELHxDDCWEKtgiCA2Ol/gIFBNAj/vA08EXwn/4jlU9dAHfw9/Zwmf
Eb8o83htGdCOAG67F3IpUDKjUOdg5TBvHRCfZcBmAA2gHGBq8G5OGQG/TsD19/bv9RMXRSdgbylg
v8egDe8O/xAPFY8GiXUo0D8jsRLvHl8VDyCfZxBSZeg6ICuqkGZZ0GGwzQD9aHIiZJhhw9IwfaF8
JmrwSGZ0d+VwZS4p8D//Ij/gvyVf4t/j7+T/5g/nH//oL1UaKk8rXyxvLX8ujy+f7zCvMb8yz1Un
NjR/NY82n39hQWITZGCPgJHQTpA28G3/T0BhsGNAY3JkE2YAwpBqsM99Ua4wkkBuIFx+YUEpsP9q
sHKgYtJpEo0wtvD1QZFAf2LSZGJpEjowKNGRQGGSec9j0DbgROS8AG4nbJCR8N85UG3h8wHSEI+A
YldCkRD/kdB9UWhlRNU5UHygbSD00X3CkHlE4riQ9IBiMGDAbvdJwZFDYVBrTTKScE2TYhK/DDBI
s2RQfLA5IMEgb0Kh5mK6gWJQdXli0mrwGRG/ZlAm8n3SbFFPyG3QdJMS/1DEanBkEDbgY5CncWJQ
jnP/aRNK5WbCYlA9EGSRkTQpwf5hROSRQI7Qg2JB8kKhTTB5U3IgNYzgQnJlcW2hQn9XIG1BDDBQ
YE2ijUFyoHffVeFo8IywWHNE01SRUlUhf7cAkzD2IZIgZFNKpkTiS/9mYJAgRURaU2bwRPEXTxhd
c5GRZnF5LUfgWUBysX3+RUaRpED08Bv7KFNe7xhdv0MQxvAZ0WOPX/9hDEKNMP56kpAb+2JtR+Bt
kEzyR+DvjPDRwAcxkkAhXr9m32V/120fZ59hk0sHMHliXGJv/iC1UGERvBBRgWsRPMJGEO+DU1Gi
QfWDQHOSMlDTjSD7SDBZwE28MLvQTzFRJVmG+0SSWnJzxvA9AMLAkRFQ0v+ScPYgKeBbQ1EABzCR
0GvB/zrxROQpMXpxkdCMsFEm9cD/DAF1pU9uj0BLVUPRfKhHcf9RgJHwvACSIUHmkCCPoHnif8SA
QxCOcFjxVvGSMETiU/5vDPBck4GBkAAnyFlAQjB/REFHUUgwkRFY8faxQqFnXfWQbkToXCBStGZp
AXr/rLFP9Y5BVHN3JFEm9TGPsf8M8E0ygTdecYixeVBM4LwQ/wyAbBBEUimwB0BRhESYVGD/QhGP
skLBa7FXoUOkhM+F078M8E1zVSGBoE+zRpMuN6+/OL85zzrfO+88/+k4Mj6/9z/PQN+ToH6SL5M/
lE+VX/+Wb5d/M9c3kJk/mk+bXwIBCZyGfQCnkAMA3j+fTgAAAwACWQAAFgADAAlZAwAAAAsAAYAI
IAYAAAAAAMAAAAAAAABGAAAAAAOFAAAAAAAAAwADgAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAA
AAALAA+ACCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAAMAEIAIIAYAAAAAAMAAAAAAAABGAAAA
AAGFAAAAAAAAQAASgAggBgAAAAAAwAAAAAAAAEYAAAAAYIUAAAAI1ugpAAAACwAZgAggBgAAAAAA
wAAAAAAAAEYAAAAADoUAAAAAAAADAByACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAAsANIAI
IAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAHgBAgAggBgAAAAAAwAAAAAAAAEYAAAAAkYUAAAEA
AAAGAAAAMjE3NzkAAAADAFyAy6dxxqnRy0eMHsl4yMaflAEAAAAmAAAARQBtAG8AbgAgAFMAYwBh
AG4AbgBlAHIAIABCAHUAaQBsAGQAAAAAALieDQALAB8OAQAAAAIB+A8BAAAAEAAAAE95Bmwc1zBA
pDroCnzx2uYCAfoPAQAAABAAAABPeQZsHNcwQKQ66Ap88drmAwD+DwUAAAADAA00/T8FAAMADzT9
PwUAAgEUNAEAAAAQAAAATklUQfm/uAEAqgA32W4AAAIBfwABAAAAMQAAADAwMDAwMDAwNEY3OTA2
NkMxQ0Q3MzA0MEE0M0FFODBBN0NGMURBRTY0NEI0MjEwMAAAAAADAAYQOEuC/wMABxANBQAAAwAQ
EAAAAAADABEQAAAAAB4ACBABAAAAZQAAAExFUyxJQUdSRUVBTkRIQVZFQkVFTlVTSU5HQU5FWENF
TFNQUkVBRFNIRUVURk9SSU5WRU5UT1JZL09SREVSTUFOQUdFTUVOVENPTlRST0xUT09PTkNFWU9V
SEFWRVlPVVJTVEEAAAAAB/4=

7) From: Tom Fries
Les and Rick,
I am also using an Excel spreadsheet. I started it when I started 
roasting 4 years ago.  It is useful to determine how balanced the 
stash it. It is showing me that my Island greens are getting quite 
low.  At one point, the stash got up to 150 lbs. I have whittled that 
down to where I try to keep it around 50.  Currently it is at 65 lbs 
with 40 varieties. I am trying to trim the number of varieties too.
Tom
At 09:38 PM 1/30/2007, you wrote:
<Snip>

8) From: raymanowen
A heat gun is "a handheld device that could be used while roasting." -ro
On 1/30/07, Coffeenut  wrote:
<Snip>
-- 
"When the theme hits the bass, I dance the Jig!" - -Virgil Fox at the Mighty
Wichita (ex- NYC Paramount) WurliTzer- 1976


HomeRoast Digest