Copy of Reworked Avalon ASICs Group Buy #1

	A	B	C	D	E	F	G	H	I	J	K	M	N	O
1	r						Disclaimer: There might be errors in this spreadsheet, so contact me (John K.) if there's anything wrong with it. I give no gurantees to the accurancy of this spreadsheet. Spreadsheet credits go to nebiz. Thanks again! Tips for him go to: 1GqCpSUwhHhCjo5VeC8ZiKCP1Yy9TogHDi
2	Escrow Address+ contract:	https://bitcointalk.org/index.php?topic=177994.msg1889287#msg1889287										Total Chips:	10000
3	CHECK YOUR BALANCE - PM JOHN IF YOU HAVE PAID MORE THAN THE AMOUNT SHOWN - UNCLAIMED AMOUNTS WILL BE IGNORED AND DECIDED LATER	Current Total:	802.26477833			Fee multiplier:	1.025	(from total with fees divided by 782.1)	Terms:			Order Cost (Avalon):	782.1000	this includes shipping to US
4		BTC Goal: (escrow & shipping)	801.6525	Blockchain Amt.:	813.65708211	Avalon Shipping:	0.035		OP Gas/time:	7.821	1%	Chip Cost (Base Cost):	12.78608874
5		Current Overpayments:	0.15852			Chips Per BTC (no fees or shipping):	12.8205128205128	(raw calc, 10000/780)	JohnK Escrow fee:	11.7315	1.5%		(fees not added to this estimate!)
6		Total Tips:	0.14409528			Total Overpay:	0.33761528
7		Current Total w/ Overpayments+Tips:	802.6023936	Discrepancies (unaccounted BTC):	0.035		10,000.00	100.00%	100.00%	100.0043777%	-0.035121044435527
8		Username	BTC Paid:	BTC Pledged (removed once paid)	amount overpaid (overpayments for complete payments only)	Pledge + Fees + Shipping	Chips Getting Realistically Round DOWN (value derived from PAID):	(note that this is paid/fees-shipping divided by chips per btc)	note the value for "chips getting realistically" is derived from column C, BTC paid, unless none have been paid, then it is derived from column D
9	1	sveetsnelda	60.797				760.00	Chip Calculator :	128	<- input TOTAL Chips you want
10	2	Immuzikation	51.285				641.03		10.2686	<-TOTAL BTC you pay
11	3	xxx? *bought from Rallye	47.3654				592.00
12	4	Bicknellski	43.208				540.00	Total Tips:	0.14409528
13	5	alle.sello (41.035 on blockchain?)	41.609				520.00	Tips to JohnK:	BTC
14	6	someone42	40.01				500.00	alexuk	0.01
15	7	ryepdx	38.411		0.01625		480.00	conv3rsion	0.0351
16	8	Egon	26.4185				330.00	Rallye	0.05274528
17	9	dserrano5	25.619		0.035		320.00	stannum	0.00565
18	10	Kushedout	24.02				300.00	ashleysly	0.0056
19	11	atcsecure	20.998851				262.21
20	12	aceat64	20.822				260.00	Total:	0.10909528
21	13	freeworm	20.535				256.41	Tips to nebiz:	BTC
22	14	spinner	20.535				256.41	darkjed	0.035
23	15	RagingAzn628	17				212.20
24	16	purplesquid	15.6162365				194.89
25	17	spanishfry	15.4194		0.01025		192.43
26	18	flowdab	15.41				192.31
27	19	tromacca' not real nick	15				187.18
28	20	CoinHoarder	14.3461				179.00
29	21	Vycid	10.285				128.21
30	22	AmpEater	10.035				125.08	Direct tip to John:
31	23	hardlock	9.9895				124.51	Shibaji	0.03
32	24	tw00	9.25				115.26
33	25	alexuk	8.86				110.38
34	26	shibaji	8.03				100.00	Direct tip to nebiz:
35	27	bassclef	7.63				95.00	Shibaji	0.015
36	28	wrenchmonkey	6.83077137				85.00
37	29	mutex	6.51095				81.00
38	30	magixx	6				74.61
39	31	JahPowerBit	5.6381				70.08
40	32	Todamont	5.6315				70.00
41	33	pierrejo	5.6095				69.72
42	34	dancrn	5.5				68.36
43	35	Wesly	5.16				64.10
44	36	Cray-1	5.16				64.10
45	37	xbaby	5.16				64.10
46	38	GodFader	5.1		0.03505		63.35
47	39	Hiroaki	5				62.10
48	40	davecoin	4.832		0.06197		60.00
49	41	mrno12	4.832				60.00
50	42	RayJay	4.3663				54.18
51	43	erschiessen	4.135				51.28
52	44	darkjed	4.0325				50.00
53	45	2weiX	4.0325				50.00
54	46	ragmondo	4				49.59
55	47	scotjam	3.269				40.45
56	48	Enigma81	3.233				40.00
57	49	SteveB	3.233				40.00
58	50	Barklad	3.233				40.00
59	51	DPoS	3.11				38.46
60	52	BitHav	3				37.09
61	53	redphlegm	2.78653944				34.42
62	54	volosator	2.6734				33.00
63	55	nabworth	2.5975				32.05
64	56	hugoooo	2.5934				32.00
65	57	fmerli	2.434				30.01
66	58	shep80	2.4335				30.00
67	59	tastycat	2.1488				26.44
68	60	goodney	2.1137				26.00
69	61	conv3rsion	2.1137				26.00
70	62	Doomsby	2.1137				26.00
71	63	ZeroPAiN	2.1137				26.00
72	64	vedmaka	2.09528002				25.77
73	65	salt	2.0338				25.00
74	66	perseus	1.634				20.00
75	67	bigbeninlondon	1.634				20.00
76	68	eghoff	1.6				19.57
77	69	nebiz	1.23425				15.00
78	70	TRiMBY	1.23425				15.00
79	71	456191	1.1				13.32
80	72	dgarrett	1.08				13.07
81	73	salfter	1.0744				13.00
82	74	stannum	1.07435				13.00
83	75	sun	1.06				12.82
84	76	samurai1200	1.06				12.82
85	77	AndyRossy	1.06	CONFIRMED SOLD	CONFIRMED SOLD	CONFIRMED SOLD	12.82
86	78	jordan314	1.06				12.82
87	79	ashleysly	0.9944				12.00
88		ecliptic					572.00
89		darkjed					10.00
90		flyG					32.00
91		Lailoken					12.82
92		ragingazn628					225.00
93
94
95
96
97
98
99
100