[Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! - page 86.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: nebiz on April 25, 2013, 01:03:29 AM

Quote from: John (John K.) on April 25, 2013, 01:02:05 AM

Quote from: nebiz on April 25, 2013, 12:56:52 AM

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Thanks! One comment, please change the formula in column G, "Chips getting realistically", to the following:

=if(C9>0,$G$5*(C9-(C9*$G$3-C9))-$G$4,$G$5*(F9-(F9*$G$3-F9))-$G$4)

The third segment is changed to reflect the column "F" which has the shipping and fees included, since this formula subtracts shipping and fees.

Will this work for each row? I'm thinking no as it's different for each row - I'm hopeless with spreadsheets. =P

No worries, the if statement actually will capture if there is a paid value and use that, and if there is no paid value it will attempt to use the value in column F.

Column F will have a value if Column D has a pledge, and if there is no pledge AND there is no paid, then the value will either be zero or error, both of which are equivalent (and valid) for this.

I've replaced your equation but the value is still slightly off the value in the original spreadsheet. Huh

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: nebiz on April 25, 2013, 01:11:29 AM

Quote from: shibaji on April 25, 2013, 12:57:55 AM

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Awesome! Thanks a ton nebiz!

No problem! Shameless plug for tips: 1GqCpSUwhHhCjo5VeC8ZiKCP1Yy9TogHDi

Added =D

nebiz

member

Activity: 87

Merit: 12

Quote from: shibaji on April 25, 2013, 12:57:55 AM

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Awesome! Thanks a ton nebiz!

No problem! Shameless plug for tips: 1GqCpSUwhHhCjo5VeC8ZiKCP1Yy9TogHDi

nebiz

member

Activity: 87

Merit: 12

Quote from: John (John K.) on April 25, 2013, 01:02:05 AM

Quote from: nebiz on April 25, 2013, 12:56:52 AM

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Thanks! One comment, please change the formula in column G, "Chips getting realistically", to the following:

=if(C9>0,$G$5*(C9-(C9*$G$3-C9))-$G$4,$G$5*(F9-(F9*$G$3-F9))-$G$4)

The third segment is changed to reflect the column "F" which has the shipping and fees included, since this formula subtracts shipping and fees.

Will this work for each row? I'm thinking no as it's different for each row - I'm hopeless with spreadsheets. =P

No worries, the if statement actually will capture if there is a paid value and use that, and if there is no paid value it will attempt to use the value in column F.

Column F will have a value if Column D has a pledge, and if there is no pledge AND there is no paid, then the value will either be zero or error, both of which are equivalent (and valid) for this.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: nebiz on April 25, 2013, 12:56:52 AM

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Thanks! One comment, please change the formula in column G, "Chips getting realistically", to the following:

=if(C9>0,$G$5*(C9-(C9*$G$3-C9))-$G$4,$G$5*(F9-(F9*$G$3-F9))-$G$4)

The third segment is changed to reflect the column "F" which has the shipping and fees included, since this formula subtracts shipping and fees.

Will this work for each row? I'm thinking no as it's different for each row - I'm hopeless with spreadsheets. =P

Rallye

member

Activity: 94

Merit: 10

Awesome! btw, just sent 6.3 more btc, thanks again!

shibaji

full member

Activity: 308

Merit: 102

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Awesome! Thanks a ton nebiz!

nebiz

member

Activity: 87

Merit: 12

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

Thanks! One comment, please change the formula in column G, "Chips getting realistically", to the following:

=if(C9>0,$G$5*(C9-(C9*$G$3-C9))-$G$4,$G$5*(F9-(F9*$G$3-F9))-$G$4)

The third segment is changed to reflect the column "F" which has the shipping and fees included, since this formula subtracts shipping and fees.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: John (John K.) on April 25, 2013, 12:53:12 AM

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

PS: I'm still working out the amount of chips though.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

New spreadsheet up: credits go to nebiz!

https://docs.google.com/spreadsheet/ccc?key=0AiYcEqkgyjc_dGU0VzhHRGpOOUxudWkxdWpDN3RmbFE&usp=sharing

bassclef

hero member

Activity: 924

Merit: 1000

Quote from: John (John K.) on April 24, 2013, 11:20:30 PM

Quote from: ?? on ??

Looks like on the spreadsheet I am getting 99.9999 chips, and it says to round down. Should I send few more mBTC to clear that up ? 99 chips are hard to mount on board - even number is better - that's why I was trying to compute for 100 chips.

Nah, according to the OP 99.99999 is getting 100.

I hope 94.997 is close enough. I can send the .003 if needed Cool

edit: nevermind, new spreadsheet!

Also, thanks for making the process easy for everyone, John. I'm sure we all appreciate the time you're putting in here.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: Rallye on April 25, 2013, 12:26:38 AM

Quote from: John (John K.) on April 25, 2013, 12:17:18 AM

Quote from: Rallye on April 25, 2013, 12:14:39 AM

Quote from: John (John K.) on April 25, 2013, 12:10:22 AM

nebiz is currently helping us redo the messy spreadsheet we have now. Thanks again!

Awesome, thats good to hear. I'd love to send another 6 BTC before I go to bed tonight, but I just have no idea how much i need to save for other supplies. I mean looking at the BOM as it is, all I can gather is that its going to cost me about 8 dollars in materials per chip. which is obviously not true, but I can't really make any other estimates without either having some more information, or better understanding the information that is given. Does anyone have even a rough estimate of how much it will cost per chip at 500+ chips total?

You get 12.8205 chips per BTC if I'm not wrong, excluding the 2.5% fees and fixed 0.035 shipping fees. Play with the current spreadsheet to get an idea of how much you're getting.

sorry, what I mean is I am trying to figure out how much it is going to cost me in supplies per chip, eg. power supply, PCB's, resistors, capacitors, etc. I'm having trouble figuring this out using the current spreadsheet.

Not sure about that as we're only doing a group buy for purely chips currently. I expect OP to inform you the costs should you prefer to have him manufacture the boards from the chips though.

Rallye

member

Activity: 94

Merit: 10

If anyone can give me any kind of rough estimate within the next 10 minutes, I can put in another 6-10 bitcoins before I sleep.

Rallye

member

Activity: 94

Merit: 10

Quote from: John (John K.) on April 25, 2013, 12:17:18 AM

Quote from: Rallye on April 25, 2013, 12:14:39 AM

Quote from: John (John K.) on April 25, 2013, 12:10:22 AM

nebiz is currently helping us redo the messy spreadsheet we have now. Thanks again!

Awesome, thats good to hear. I'd love to send another 6 BTC before I go to bed tonight, but I just have no idea how much i need to save for other supplies. I mean looking at the BOM as it is, all I can gather is that its going to cost me about 8 dollars in materials per chip. which is obviously not true, but I can't really make any other estimates without either having some more information, or better understanding the information that is given. Does anyone have even a rough estimate of how much it will cost per chip at 500+ chips total?

You get 12.8205 chips per BTC if I'm not wrong, excluding the 2.5% fees and fixed 0.035 shipping fees. Play with the current spreadsheet to get an idea of how much you're getting.

sorry, what I mean is I am trying to figure out how much it is going to cost me in supplies per chip, eg. power supply, PCB's, resistors, capacitors, etc. I'm having trouble figuring this out using the current spreadsheet.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: Rallye on April 25, 2013, 12:14:39 AM

Quote from: John (John K.) on April 25, 2013, 12:10:22 AM

nebiz is currently helping us redo the messy spreadsheet we have now. Thanks again!

Awesome, thats good to hear. I'd love to send another 6 BTC before I go to bed tonight, but I just have no idea how much i need to save for other supplies. I mean looking at the BOM as it is, all I can gather is that its going to cost me about 8 dollars in materials per chip. which is obviously not true, but I can't really make any other estimates without either having some more information, or better understanding the information that is given. Does anyone have even a rough estimate of how much it will cost per chip at 500+ chips total?

You get 12.8205 chips per BTC if I'm not wrong, excluding the 2.5% fees and fixed 0.035 shipping fees. Play with the current spreadsheet to get an idea of how much you're getting.

Rallye

member

Activity: 94

Merit: 10

Quote from: John (John K.) on April 25, 2013, 12:10:22 AM

nebiz is currently helping us redo the messy spreadsheet we have now. Thanks again!

Awesome, thats good to hear. I'd love to send another 6 BTC before I go to bed tonight, but I just have no idea how much i need to save for other supplies. I mean looking at the BOM as it is, all I can gather is that its going to cost me about 8 dollars in materials per chip. which is obviously not true, but I can't really make any other estimates without either having some more information, or better understanding the information that is given. Does anyone have even a rough estimate of how much it will cost per chip at 500+ chips total?

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

nebiz is currently helping us redo the messy spreadsheet we have now. Thanks again!

Rallye

member

Activity: 94

Merit: 10

Hey I'm trying to figure out how much of my budget I have left to spend on chips. I'm looking at the DIY thread and reading the BOM document trying to figure out how much it will cost me to build these machines. The only thing I don't understand is how man of each part I will need per Avalon chip. and the numbers 1+, 10+, 100+ etc, means if I buy this many, they will cost this much each right?

Bicknellski

hero member

Activity: 924

Merit: 1000

I will be working on a similar "build" plan that Ragin's trying to do in the USA, for those in Indonesia, and I would be interested in working specifically with people in Jakarta if they are interested.

Let Ragin get more details first I think then he can post another thread for everyone like Burin/Alten and DIY post. Let's keep getting MORE BTC in... we want to BUY this week right? Focus on getting more people to pay is the key right now... the BUILD focus can be after we get the purchasing in the bag.

John (John K.)

legendary

Activity: 1288

Merit: 1227

Away on an extended break

Quote from: shibaji on April 24, 2013, 11:39:24 PM

Quote from: John (John K.) on April 24, 2013, 11:37:23 PM

Quote from: shibaji on April 24, 2013, 11:36:25 PM

@ ragingazn628 :

Please see if you can get the assembly done in US without back and forth with burnin's group - this will have significant advantage. I bought in your group with this hope (this is not a binding expectation, but a hope). Thanks!

There's discussion on this few pages back - OP stated he's in talks with local engineers to get this done though.

Ok, great - but this sort of discussion needs to be linked to OP - massively helps (a direct link to relevant post would do). Also the original post would benefit from some organized writing.

*pokes ragingazn628 about this* Wink

Topic: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED! - page 86. (Read 150608 times)