Northeast Ohio Bulk Grain Order

[ohiobrewman]

Email sent

Email on its way

 

[rrittenhouse]

Caaaaaaannnn we do it? I hope we can because I WANT TO BREW!

 

[logdrum]

Sorry everybody... Got busy over here.

We need to get this Pallet to 42 Bags to get them to Place the Order. That's why I keep saying 42. I am a Free Member so the Inbox thing isn't going to work.
I really don't want to blow $25.00 right now...lol

Also going to update here and the Main Post with Email Addy.
On thread we will try to keep track of where we are Bag wise and then we can go from there.

So for Price List Email me over at:
[email protected]

2 questions:

What's the bag count up to?
How long are you going to keep this open?

Thanks-definately interested in 4 maybe 5 sacks.

-df

 

[Hugh_Jass]

OP:

A while back, a HBT user shared this spreadsheet. It really made a bulk grain buy I organized fairly simple.

https://spreadsheets.google.com/ccc?key=tvphrtAON4ZEHGo1s9yFELg#gid=0

Let me know if you have trouble viewing it.

 

[ohiobrewman]

2 questions:

What's the bag count up to?
How long are you going to keep this open?

Thanks-definately interested in 4 maybe 5 sacks.

-df

If we can get this together now, I would like to get this order in by Wednesday.
4-5 would be great, That would put us closer to the 42 goal.

We were at 21, 4-5 would put us at 25-26.

We have a few not sure if there going in or not.
So we will need to fugure out positive sure's,
Then when we get to the 42 I will collect money and Order and figure out if I can get it delivered here or a Business.

 

[logdrum]

If for some reason this doesn't fill up, I'm still interested in any future buy.

-d

 

[Julohan]

I will go in for 2 bags of US 2-Row and 1 bag of Marris Otter.

 

[ohiobrewman]

OP:

A while back, a HBT user shared this spreadsheet. It really made a bulk grain buy I organized fairly simple.

https://spreadsheets.google.com/ccc?key=tvphrtAON4ZEHGo1s9yFELg#gid=0

Let me know if you have trouble viewing it.

Thank you, Will try it out
Had to request Permission for some reason?

 

[ohiobrewman]

I will go in for 2 bags of US 2-Row and 1 bag of Marris Otter.

Theres GW or Canadian Malting 2-Row.
MO is Bairds or Fawcetts, Please be specific...

 

[Hugh_Jass]

Thank you, Will try it out
Had to request Permission for some reason?

It's set for private.

You should be able to view it now. Let me know if you're still having trouble.

 

[ohiobrewman]

It's set for private.

You should be able to view it now. Let me know if you're still having trouble.

Nice thank you Hugh
This will help us out Big time, Us Ohioians sticking together... Take that Ted Strikland...LMAO

 

[Hugh_Jass]

It has some pretty useful features. It calculates for partial bags and you can add the cost of supplies like bags to divide whole sacks. It also calculates each individual's shipping charges. Everyone can add their own order and see their amount due. It also allows for different brands of various grains, i.e. Maris Otter or Vienna.

I know it really helped keep everything organized.

good luck

 

[ohiobrewman]

It has some pretty useful features. It calculates for partial bags and you can add the cost of supplies like bags to divide whole sacks. It also calculates each individual's shipping charges. Everyone can add their own order and see their amount due. It also allows for different brands of various grains, i.e. Maris Otter or Vienna.

I know it really helped keep everything organized.

good luck

Awesome
Adding in the grain and stuff now
How do I change the price per pound of grain.. Keeps giving me an error...

 

[Hugh_Jass]

Awesome
Adding in the grain and stuff now
How do I change the price per pound of grain.. Keeps giving me an error...

enter the price of the whole bag.
Price per bag is entered on row 30, column F-T

 

[Hugh_Jass]

Oh and remember some bags are really 25 kg, so this means to calculate the price per pound there's a correction factor. NCM will charge for 55.12 lb sacks. Ask me how I know.

 

[ohiobrewman]

Oh and remember some bags are really 25 kg, so this means to calculate the price per pound there's a correction factor. NCM will charge for 55.12 lb sacks. Ask me how I know.

Awesome Hugh,

Thank you big time

 

[Hugh_Jass]

I should add, I placed an ad on Craig's List telling about the grain buy. I think I picked up a couple of buyers that way. There was a truck in the area, so we weren't concerned with filling pallets, It was the more the merrier. I think we ended up with ~90 sacks. Because of the amount of buyers, we could divide sacks of C-60, Roasted Barley, and other grains not necessarily needed in 55# quantities and also DME for extract brewers and those who use it for starters.

 

[ohiobrewman]

I should add, I placed an ad on Craig's List telling about the grain buy. I think I picked up a couple of buyers that way. There was a truck in the area, so we weren't concerned with filling pallets, It was the more the merrier. I think we ended up with ~90 sacks. Because of the amount of buyers, we could divide sacks of C-60, Roasted Barley, and other grains not necessarily needed in 55# quantities and also DME for extract brewers and those who use it for starters.

This is my first Pallet Order.. So I'm a bit confused on a few things yet.
Will they pull it off the Truck for us and then we divide it?
Or does it have to go to a Business....

Brand new and nervous with that side of it.

 

[Hugh_Jass]

You'll need a place of delivery, residential or commercial. I'm not sure if there's an additional charge for residential or things like a lift gate.

The truck driver will pull up to the address designated on the Bill of Lading, open the doors and from there it's your responsibility. It would help to have the delivery take place somewhere that has a loading dock, but it's not absolutely necessary. I'd make sure those who are participating in the buy are there to help unload the truck and take their grains home with them. Many hands make light work. And, the last thing you want is a few hundred # of grain in the middle of your living room.

If having the grain buy participants attend isn't possible because of work commitments, make sure you have enough help. You'll need one guy to bring the sacks to the back of the truck and a few to sort the grains. When we did ours, we divided the grains by the participants names. They were ready to go and didn't have to me moved more than once.

 

[ohiobrewman]

You'll need a place of delivery, residential or commercial. I'm not sure if there's an additional charge for residential or things like a lift gate.

The truck driver will pull up to the address designated on the Bill of Lading, open the doors and from there it's your responsibility. It would help to have the delivery take place somewhere that has a loading dock, but it's not absolutely necessary. I'd make sure those who are participating in the buy are there to help unload the truck and take their grains home with them. Many hands make light work. And, the last thing you want is a few hundred # of grain in the middle of your living room.

If having the grain buy participants attend isn't possible because of work commitments, make sure you have enough help. You'll need one guy to bring the sacks to the back of the truck and a few to sort the grains. When we did ours, we divided the grains by the participants names. They were ready to go and didn't have to me moved more than once.

Cool...
That's the way we want this.. Organized.
Especially me with 10 Bags to deal with...lol

 

[ohiobrewman]

Your PM box is full.

I'm out in Canfield off of 224,

how do prices look on 2-row, marris, and belgian pilsner if they carry it?

PM me back.

Doing it from Spreadsheet by Homebrewtalk User-names. Belgian Pils on End..
https://spreadsheets.google.com/ccc?key=tvphrtAON4ZEHGo1s9yFELg&authkey=CMjqg3U#

 

[Julohan]

Theres GW or Canadian Malting 2-Row.
MO is Bairds or Fawcetts, Please be specific...

I will buy the 2 GW(Great Western Malting?) Premium 2-row malt and 1 Fawcett Maris Otter.

 

[ohiobrewman]

I will buy the 2 GW(Great Western Malting?) Premium 2-row malt and 1 Fawcett Maris Otter.

Gotcha...
Getting it filled up folks, Lets keep her going, All the way to 42

https://spreadsheets.google.com/ccc?key=tvphrtAON4ZEHGo1s9yFELg&authkey=CMjqg3U#

 

[rrittenhouse]

Bad News - http://www.examiner.com/social-medi...ait-for-their-refunds-due-to-processing-error

I was going to pay for the grain out of my taxes (which are never late!). Turbo Tax had to resort to sending out paper checks to those affected. I won't be able to participate in the grain buy now until I get my taxes. They are saying this could be around the end of Feb.

 

[ohiobrewman]

Bad News - http://www.examiner.com/social-medi...ait-for-their-refunds-due-to-processing-error

I was going to pay for the grain out of my taxes (which are never late!). Turbo Tax had to resort to sending out paper checks to those affected. I won't be able to participate in the grain buy now until I get my taxes. They are saying this could be around the end of Feb.

Wait and see where we are at with this... It may take us awhile yet anyways.
So I will keep you in there as backup.

 

[rrittenhouse]

Good. I still want in on it but I can't pull funds from anywhere else right now to cover it. They say it will only be a week later.. this will affect me bringing back grain to the Columbus area for anyone as well if I can't do it. Ill keep you updated.

 

[IrregularPulse]

I too am out if Rittenhouse is out. If he's in I'm in for a MO and a Vienna

 

[ohiobrewman]

Sure hope it works out with you guys.
That would put us at $4.96 a bag shipping with you guys in..

https://spreadsheets.google.com/ccc?key=tvphrtAON4ZEHGo1s9yFELg&authkey=CMjqg3U#

 

[rrittenhouse]

It SAYS Feb 15th....we shall see.

 

[Hugh_Jass]

ohiobrewman,

Why not offer it to SAAZ

http://hbd.org/saaz/

and to Wooster

Wayne County Brew Club/ WCBC
2741 Tuckahoe Road
Wooster, OH 44691 USA
330 264-2635
[email protected]


I know some guys from the Wooster club. I bet they'd recognize the spreadsheet.

I think after the order for any one grain hits the 1000# mark, the price is discounted further.

I bet if you involve the homebrew clubs around you, you'd fill 2 pallets easy.

JM2C