PulsedMedia
|
|
June 25, 2012, 06:58:32 AM |
|
missing from the list is that i received mine 5th of June. They were in customs for a ~week prior to that.
|
|
|
|
rjk
Sr. Member
Offline
Activity: 448
Merit: 250
1ngldh
|
|
June 25, 2012, 02:19:24 PM |
|
I wonder whether Excel can generate BBcode tables? Here is a little thing I made to read the HTML forum table, it's pretty cool: Those hash rates and power draws are based on total ordered, not total received.
|
|
|
|
tarrant_01 (OP)
|
|
June 25, 2012, 03:18:19 PM |
|
Yea it can with VB.
That's how I did the table initially. I put all the data in there and coded it to output the code to a cell then pasted it here. It was just easier to copy and paste then edit after that.
That table looks pretty nice.
|
1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
|
|
|
rjk
Sr. Member
Offline
Activity: 448
Merit: 250
1ngldh
|
|
June 25, 2012, 03:37:39 PM |
|
Yea it can with VB.
That's how I did the table initially. I put all the data in there and coded it to output the code to a cell then pasted it here. It was just easier to copy and paste then edit after that.
That table looks pretty nice.
Would you be so kind as to share that bit of VB with us/me? Or at least with those that want to maintain the SC threads.
|
|
|
|
freshzive
|
|
June 25, 2012, 05:14:06 PM |
|
My 4 shipped, looks like they'll arrive Wed Jun 27th.
|
|
|
|
tarrant_01 (OP)
|
|
June 25, 2012, 05:47:31 PM Last edit: June 25, 2012, 06:31:33 PM by tarrant_01 |
|
I just wrote this up. I am not sure how well it will work with other tables out there but this is set up for cells that aren't merged. It cycles through the specified start column and stops at the specified stop column and then goes down through the rows until it finds a cell in the first column that is blank. The output is placed on a new sheet in the first cell. There's no error handling for the input boxes so if you enter something out of range or just random characters, it won't work. Sub CreateBBTable() Dim startColumn As String, stopColumn As String, startRow As Integer Dim curCol As Integer, curRow As Integer Dim outputStr As String
Const sctr = "[center]" Const ectr = "[/center]" Const sright = "[right]" Const eright = "[/right]"
startColumn = InputBox("Enter the column to start at (A - Z)", "Start Column") stopColumn = InputBox("Enter the column to stop at (A - Z)", "Stop Column") startRow = InputBox("Enter the row to start at (1 and up)", "Start Row")
curRow = startRow
outputStr = "[table]" Do Until Range(startColumn & curRow) = "" outputStr = outputStr & "[tr]" curCol = Asc(startColumn) Do Until curCol > Asc(stopColumn) outputStr = outputStr & "[td]" Select Case Range(Chr(curCol) & curRow).HorizontalAlignment Case xlCenter outputStr = outputStr & sctr & Range(Chr(curCol) & curRow) & ectr Case xlRight outputStr = outputStr & sright & Range(Chr(curCol) & curRow) & eright Case Else outputStr = outputStr & Range(Chr(curCol) & curRow) End Select outputStr = outputStr & "[/td]" curCol = curCol + 1 Loop outputStr = outputStr & "[/tr]" & vbCrLf curRow = curRow + 1 Loop outputStr = outputStr & "[/table]"
Sheets.Add After:=Sheets(Sheets.count) Sheets(Sheets.count).Select Range("A1") = outputStr End Sub edit: Edited one of the declarations
|
1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
|
|
|
rjk
Sr. Member
Offline
Activity: 448
Merit: 250
1ngldh
|
|
June 25, 2012, 05:50:04 PM |
|
Sweet, that's handy. I'll be sending a tip over soon.
|
|
|
|
tarrant_01 (OP)
|
|
June 25, 2012, 05:55:53 PM Last edit: June 25, 2012, 06:30:11 PM by tarrant_01 |
|
Oh and it is coded to match the alignment of the cells on the excel sheet.
Thanks for the tip!
|
1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
|
|
|
nedbert9
Sr. Member
Offline
Activity: 252
Merit: 250
Inactive
|
|
June 25, 2012, 08:45:56 PM |
|
Sweet, that's handy. I'll be sending a tip over soon.
FYI, the SC thread is google spreadsheet with script. So, if you have any requests pls specify them on the SC thread.
|
|
|
|
farfie
Newbie
Offline
Activity: 63
Merit: 0
|
|
June 25, 2012, 09:13:15 PM |
|
Hey all, Jody has informed me that my singles have shipped today. Probably expect them around Wednesday via 2 tracking numbers.
|
|
|
|
CoinDiner
Newbie
Offline
Activity: 28
Merit: 0
|
|
June 25, 2012, 09:34:31 PM |
|
If I purchase a BFL Single now for 700 (shipping included ) am I right in understanding that when the ASICs come out , I can send them back the Single, pay the extra say 600 and I will be offered the ASIC?
|
|
|
|
LazyOtto
|
|
June 25, 2012, 09:45:07 PM |
|
If I purchase a BFL Single now for 700 (shipping included ) am I right in understanding that when the ASICs come out , I can send them back the Single, pay the extra say 600 and I will be offered the ASIC?
Close. It is another $700 (and then shipping on top). The exchange option expires in March 2013.
|
|
|
|
CoinDiner
Newbie
Offline
Activity: 28
Merit: 0
|
|
June 25, 2012, 09:57:35 PM |
|
Thanks for clearing that up for me
|
|
|
|
tarrant_01 (OP)
|
|
June 25, 2012, 10:14:07 PM |
|
$600 you mean?
|
1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
|
|
|
LazyOtto
|
|
June 25, 2012, 11:03:24 PM |
|
$600 you mean?
No. http://www.butterflylabs.com/bitforce-sc-release-notes/"What’s a typical trade in example? A customer can trade in his 832 MH/s Single and get $599 credit towards the purchase of a $1,299 SC Single. The end cost to upgrade to 40 GH/s would be $699." Plus shipping and all required taxes / fees.
|
|
|
|
tarrant_01 (OP)
|
|
June 25, 2012, 11:06:55 PM |
|
If I purchase a BFL Single now for 700 (shipping included ) am I right in understanding that when the ASICs come out , I can send them back the Single, pay the extra say 600 and I will be offered the ASIC?
He must be international. This is the 700 I was referring to. Sorry about that.
|
1P95gCUCw3Tjb7yyoYtW3ARZZQyTpFgk6H
|
|
|
LazyOtto
|
|
June 25, 2012, 11:17:29 PM |
|
Oh. No problem. I thought you were referring to the $700 I mentioned, not his initial outlay.
But there is another potential issue I've not seen discussed yet for overseas buyers. Many or most of them paid a VAT (or equivalent import duty, whatever) fee on the original $600 purchase. When/if they upgrade, I bet they will have to pay that fee on the new equipment valuation of $1399 when they receive it. In effect, having paid double on the first $600 worth of the new $1400 piece of equipment.
|
|
|
|
Unacceptable
Legendary
Offline
Activity: 2212
Merit: 1001
|
|
June 25, 2012, 11:18:37 PM |
|
But,he could go for 8 Jallies (28gh total) for his unit + $600 instead.But that would be foolish,unless that's all the cash/BTC you can come up with
|
"If you run into an asshole in the morning, you ran into an asshole. If you run into assholes all day long, you are the asshole." -Raylan Givens Got GOXXED ?? https://www.youtube.com/watch?v=9KiqRpPiJAU&feature=youtu.be"An ASIC being late is perfectly normal, predictable, and legal..."Hashfast & BFL slogan
|
|
|
LazyOtto
|
|
June 25, 2012, 11:20:54 PM |
|
Perhaps. As with all things BFL, we will know for sure when we see it actually happening.
|
|
|
|
Unacceptable
Legendary
Offline
Activity: 2212
Merit: 1001
|
|
June 25, 2012, 11:32:34 PM |
|
Perhaps. As with all things BFL, we will know for sure when we see it actually happening.
Oh its true,I ordered my Jallies Sunday & checked all my options.I would've gone for the 40gh model,but am short on cash & BTC. So instead I got 4 jallies coming (to keep pace with the diff increase coming upon release of Asics) & decided to keep my single until I have $700 to trade MY Single in for the 40gh one
|
"If you run into an asshole in the morning, you ran into an asshole. If you run into assholes all day long, you are the asshole." -Raylan Givens Got GOXXED ?? https://www.youtube.com/watch?v=9KiqRpPiJAU&feature=youtu.be"An ASIC being late is perfectly normal, predictable, and legal..."Hashfast & BFL slogan
|
|
|
|