Bitcoin Forum
June 24, 2024, 08:31:34 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Warning: One or more bitcointalk.org users have reported that they strongly believe that the creator of this topic is a scammer. (Login to see the detailed trust ratings.) While the bitcointalk.org administration does not verify such claims, you should proceed with extreme caution.
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 [23] 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 ... 108 »
  Print  
Author Topic: [Group Buy#1] Avalon ASICs CHIPS! Using JohnK as escrow! FINISHED!  (Read 150377 times)
nebiz
Member
**
Offline Offline

Activity: 87
Merit: 12



View Profile
April 25, 2013, 05:56:52 AM
 #441


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.

tips: 1KY4hsybyqpTdxy8nSXh3KUKRi8jeGH8Jx
shibaji
Full Member
***
Offline Offline

Activity: 308
Merit: 102



View Profile
April 25, 2013, 05:57:55 AM
 #442


Awesome! Thanks a ton nebiz!
Rallye
Member
**
Offline Offline

Activity: 94
Merit: 10


View Profile
April 25, 2013, 06:01:36 AM
 #443

Awesome!  btw, just sent 6.3 more btc, thanks again!
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 06:02:05 AM
 #444


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
Member
**
Offline Offline

Activity: 87
Merit: 12



View Profile
April 25, 2013, 06:03:29 AM
 #445


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.

tips: 1KY4hsybyqpTdxy8nSXh3KUKRi8jeGH8Jx
nebiz
Member
**
Offline Offline

Activity: 87
Merit: 12



View Profile
April 25, 2013, 06:11:29 AM
 #446


No problem! Shameless plug for tips: 1GqCpSUwhHhCjo5VeC8ZiKCP1Yy9TogHDi

tips: 1KY4hsybyqpTdxy8nSXh3KUKRi8jeGH8Jx
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 06:12:52 AM
 #447


No problem! Shameless plug for tips: 1GqCpSUwhHhCjo5VeC8ZiKCP1Yy9TogHDi
Added =D
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 06:19:32 AM
 #448


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
eghoff
Newbie
*
Offline Offline

Activity: 18
Merit: 0


View Profile
April 25, 2013, 06:30:16 AM
Last edit: April 25, 2013, 05:13:37 PM by eghoff
 #449

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
Member
**
Offline Offline

Activity: 87
Merit: 12



View Profile
April 25, 2013, 07:34:45 AM
 #450

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 Smiley  The BTC are now proportionate to the chips allocated!

tips: 1KY4hsybyqpTdxy8nSXh3KUKRi8jeGH8Jx
2weiX
Legendary
*
Offline Offline

Activity: 2058
Merit: 1005

this space intentionally left blank


View Profile
April 25, 2013, 09:47:14 AM
 #451

interested in ~30 chips, hereby pledging.
requesting PM if things get serious enough to require payment.
Bicknellski
Hero Member
*****
Offline Offline

Activity: 924
Merit: 1000



View Profile
April 25, 2013, 10:11:33 AM
 #452

I paid and topped up to get exactly 320 Chips.

Quote
New: Bicknellski   25.619          319.79
Quote
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.

Dogie trust abuse, spam, bullying, conspiracy posts & insults to forum members. Ask the mods or admins to move Dogie's spam or off topic stalking posts to the link above.
Bicknellski
Hero Member
*****
Offline Offline

Activity: 924
Merit: 1000



View Profile
April 25, 2013, 10:12:20 AM
Last edit: April 25, 2013, 10:27:39 AM by Bicknellski
 #453

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.

Dogie trust abuse, spam, bullying, conspiracy posts & insults to forum members. Ask the mods or admins to move Dogie's spam or off topic stalking posts to the link above.
dserrano5
Legendary
*
Offline Offline

Activity: 1974
Merit: 1029



View Profile
April 25, 2013, 10:29:25 AM
 #454

I paid and topped up to get exactly 320 Chips.

Quote
New: Bicknellski   25.619          319.79
Quote
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
Legendary
*
Offline Offline

Activity: 2058
Merit: 1005

this space intentionally left blank


View Profile
April 25, 2013, 11:15:35 AM
 #455

I has a confused with the spreadsheet.
for 50 chips, how much pay?
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 11:16:26 AM
 #456

I paid and topped up to get exactly 320 Chips.

Quote
New: Bicknellski   25.619          319.79
Quote
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.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 11:19:00 AM
 #457

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
Legendary
*
Offline Offline

Activity: 2058
Merit: 1005

this space intentionally left blank


View Profile
April 25, 2013, 11:21:02 AM
 #458

hiya,


Code:
3.95 BTC paid to 1At75rKd6e8b7S7AAPzZ5V3kAzhkGYhnpU
for 50 chips

signed by 1Dg4FcY37q8yboCebww5xYVGFXrg8FLEo4:
Code:
G6o4f3XPN3aI1C0CriknAT/a4EaUAOR2lYqMbfqCzUvIvayF/mt1fitK6A8QKJeJ6Grpm+ASnwJuqg9UJvBN0e0=
John (John K.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 11:42:37 AM
 #459

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.)
Global Troll-buster and
Legendary
*
Offline Offline

Activity: 1288
Merit: 1227


Away on an extended break


View Profile
April 25, 2013, 11:47:41 AM
 #460

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)
Pages: « 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 [23] 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 ... 108 »
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!