[Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED!

[nebiz]

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.

[shibaji]

New spreadsheet up: credits go to nebiz!

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

Awesome! Thanks a ton nebiz!

[Rallye]

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

[John (John K.)]

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

[nebiz]

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.

[nebiz]

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

[John (John K.)]

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

[John (John K.)]

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. 

[eghoff]

Okay, i sent 1.535 BTC, what i made out to be equal to 20 chips.
https://blockchain.info/tx/51c90be029e374136d5578b61fd3bf36adaa78a4a8cd9fd1be63805d2637fc23
EDIT: After realizing i made a mistake, i sent the remaining 0.065 BTC
https://blockchain.info/tx/e552284b556108ccd6b040eb6969830f11d417e566c2533486cfbe74ada67ba6

[nebiz]

Okay, i sent 1.535 BTC, would i made out to be equal to 20 chips.
https://blockchain.info/tx/51c90be029e374136d5578b61fd3bf36adaa78a4a8cd9fd1be63805d2637fc23
EDIT: After realizing i made a mistake, i sent the remaining 0.065 BTC
https://blockchain.info/tx/e552284b556108ccd6b040eb6969830f11d417e566c2533486cfbe74ada67ba6

Parentheses error fixed   The BTC are now proportionate to the chips allocated!

[2weiX]

interested in ~30 chips, hereby pledging.
requesting PM if things get serious enough to require payment.

[Bicknellski]

I paid and topped up to get exactly 320 Chips.

New: Bicknellski   25.619          319.79

Old:   Bicknellski   24.96       25.6190            320

Just want to make sure I get the 320. JohnK check your decimal places some probably got chopped off and caused a lower rounding error.

[Bicknellski]

interested in ~30 chips, hereby pledging.
requesting PM if things get serious enough to require payment.

It is serious now. First come first serve make a payment or miss out.

If necessary to move this forward I can pay for another 160 chips just let me know when you only need 12.48 + fees and I can pop it in.

And silly question... are there any TAX or IMPORT duties on these 10K chips? Didn't notice that on the OP.

[dserrano5]

I paid and topped up to get exactly 320 Chips.

New: Bicknellski   25.619          319.79

Old:   Bicknellski   24.96       25.6190            320

Just want to make sure I get the 320. JohnK check your decimal places some probably got chopped off and caused a lower rounding error.

I'm exactly in the same situation.

[2weiX]

I has a confused with the spreadsheet.
for 50 chips, how much pay?

[John (John K.)]

I paid and topped up to get exactly 320 Chips.

New: Bicknellski   25.619          319.79

Old:   Bicknellski   24.96       25.6190            320

Just want to make sure I get the 320. JohnK check your decimal places some probably got chopped off and caused a lower rounding error.

I'm exactly in the same situation.

Yeah, the math is faulty here if I'm not wrong. ((320/10000)*(780)*(1.025))+0.035 = 25.619
I'll rework the spreadsheet and see.

[John (John K.)]

I has a confused with the spreadsheet.
for 50 chips, how much pay?

It should be 4.0325 according to the formula above, but I'm not 100% sure yet. Just send the coins as that'll be accounted for anyhow - the amount of chips might vary for the moment. There might be a rounding error in the spreadsheet now. (drat Avalon for doing a 780BTC/10k chips)

[2weiX]

hiya,

Code:

3.95 BTC paid to 1At75rKd6e8b7S7AAPzZ5V3kAzhkGYhnpU
for 50 chips

signed by 1Dg4FcY37q8yboCebww5xYVGFXrg8FLEo4:

Code:

G6o4f3XPN3aI1C0CriknAT/a4EaUAOR2lYqMbfqCzUvIvayF/mt1fitK6A8QKJeJ6Grpm+ASnwJuqg9UJvBN0e0=

[John (John K.)]

hiya,

Code:

3.95 BTC paid to 1At75rKd6e8b7S7AAPzZ5V3kAzhkGYhnpU
for 50 chips

signed by 1Dg4FcY37q8yboCebww5xYVGFXrg8FLEo4:

Code:

G6o4f3XPN3aI1C0CriknAT/a4EaUAOR2lYqMbfqCzUvIvayF/mt1fitK6A8QKJeJ6Grpm+ASnwJuqg9UJvBN0e0=

Hey, for 50 chips you'll need 4.0325 BTC. I've reworked the spreadsheet again and ran some tests - it should be 100% correct now hopefully.

[John (John K.)]

I've added a chip calculator to the side - copy the sheet and input the amount of chips you want. The exact amount will be shown. (including the 0.035 shipping cost per person, of course)