["WAIT LIST"] BFL SC Pre-Order Information (Monarch orders too!)

[midnight]

Date Paid - 08/16/2012
Order Number - 5422
Trade-In (Y/N) - N
Qty SC Jalapeno -0
Qty SC Single -2
Qty SC Mini Rig -0
User Midnight

[1714118071]

1714118071

[1714118071]

1714118071

[1714118071]

1714118071

[1714118071]

1714118071

[UnderGod]

Date Paid - 09/13/2012
Order Number - 7978
Trade-In (Y/N) - N
Qty SC Jalapeno -1
Qty SC Single -0
Qty SC Mini Rig -0
User UnderGod (Belgium!)

[DiCE1904]

Date Paid - 09/02/2012
Trade-In (Y/N) - N
Qty SC Jalapeno -2
Qty SC Single -0
Qty SC Mini Rig -0
User DiCE1904

[420session]

08/31/2012  6933  N 1 0 0 - - 420session

[Gyrsur]

please delete! never paid!   

07/27/2012    4069    Y    0    1    0    -    -    Gyrsur

[firefop]

8/8/2012, 4527, Y, 0, 1, 0, -, -, firefop

[ChipGeek]

8/8/2012, 4527, Y, 0, 1, 0, -, -, firefop

Really?  I ordered the same day and my order number is more than 200 different that that.  Odd...  Perhaps the numbers are not as sequential as I thought?  Please check your order number.

Edit: Or order date.

[squall1066]

please delete! never paid!   

07/27/2012    4069    Y    0    1    0    -    -    Gyrsur

sorted, No problem.

[michaelmclees]

8/8/2012, 4527, Y, 0, 1, 0, -, -, firefop

Really?  I ordered the same day and my order number is more than 200 different that that.  Odd...  Perhaps the numbers are not as sequential as I thought?  Please check your order number.

Edit: Or order date.

I don't think they've ever been sequential.  If I placed 2 orders back to back, I wouldn't be surprised if they were 10-50 apart.

[InfiniTcell]

Date 09/01/2012
order number 6973
Trade In: yes
Qty: 1
SC single

[Subo1977]

08/02/2012    4272    N    1    0    0    -    -    Subo1978
09/19/2012    8639    N    0    1    0    -    -    Subo1978

[Azrael_PT]

09/19/2012    8658    N    2    0    0    -    -    iztrojan

It´s a friend of my. User is Newbie so he can´t post yet.

[SgtMoth]

09/19/2012    8685    N    1    0    0    -    -    SgtMoth

[SLok]

08/03/2012    43xx    N    4    0    0    -    -    SLok
08/05/2012    45xx    N    2    0    0    -    -    SLok

[laSeek]

09/21/2012    8779    N    1    0    0   -   -   laSeek

[LiteBit]

Date Paid - 08/21/2012
Order Number - 5912
Trade-In (Y/N) - N
Qty SC Jalapeno -0
Qty SC Single -2
Qty SC Mini Rig -0
User sexystick

[Akido]

09/19/2012    8729    N    0    1    0    -    -    Akido

[pyromaniac]

Date Paid - 09/21/2012
Order Number -  8852
Trade-In (Y/N) - N
Qty SC Jalapeno -3
Qty SC Single -0
Qty SC Mini Rig -0

[Bogart]

Here's some code I whipped up to run some numbers on the data.  Sorry it's not pretty (perl sometimes isn't).

#!/usr/bin/perl -w

use strict;

my $JALAPENO_PRICE = 149;
my $SINGLE_PRICE = 1299;
my $MINIRIG_PRICE = 28900;
my $SINGLE_TRADE_PRICE = ( $SINGLE_PRICE / 2 );
my $MINIRIG_TRADE_PRICE = ( $MINIRIG_PRICE / 2);

my ( $jalapeno_total, $single_total, $minirig_total, $single_trade_total, $minirig_trade_total );
my $lowest_order_number = 65535;
my $highest_order_number = 0;

while ( <> ) {
   s/-/0/g;
   my ( $date, $order_number, $trade_in, $jalapeno_qty, $single_qty, $minirig_qty ) = split ( /\s+/ );

   if ( $order_number > 0 ) {
      if ( $order_number < $lowest_order_number )  { $lowest_order_number  = $order_number; }
      if ( $order_number > $highest_order_number ) { $highest_order_number = $order_number; }
   }

   $jalapeno_total += $jalapeno_qty;
   if ( $trade_in =~ /y/i ) {
      $single_trade_total += $single_qty;
      $minirig_trade_total += $minirig_qty;
   } else {
      $single_total += $single_qty;
      $minirig_total += $minirig_qty;
   }
}

print "Product\t\t\t\tQty\tDollar value\n";
print "Jalapenos:\t\t\t$jalapeno_total\t\$" . ( $jalapeno_total * $JALAPENO_PRICE ) . "\n";
print "Singles:\t\t\t$single_total\t\$" . ( $single_total * $SINGLE_PRICE ) . "\n";
print "Single trade-ins:\t\t$single_trade_total\t\$" . ( $single_trade_total * $SINGLE_TRADE_PRICE ) . "\n";
print "Mini Rigs:\t\t\t$minirig_total\t\$" . ( $minirig_total * $MINIRIG_PRICE ) . "\n";
print "Mini Rig trade-ins:\t\t$minirig_trade_total\t\$" . ( $minirig_trade_total * $MINIRIG_TRADE_PRICE ) . "\n";

my $total_qty = ( $jalapeno_total + $single_total + $single_trade_total + $minirig_total + $minirig_trade_total );
my $total_value = ( ( $jalapeno_total * $JALAPENO_PRICE ) + ( $single_total * $SINGLE_PRICE ) + ( $single_trade_total * $SINGLE_TRADE_PRICE ) + ( $minirig_total * $MINIRIG_PRICE ) + ( $minirig_trade_total * $MINIRIG_TRADE_PRICE ) );
my $average_value = ( $total_value / $total_qty );

print "Documented total orders:\t$total_qty\t\$$total_value\n";
print "Value of average item ordered:\t\t\$$average_value\n";

my $inferred_total_qty = ( $highest_order_number - $lowest_order_number ) + 1;
my $inferred_total_value = ( $inferred_total_qty * $average_value );

print "Inferred total orders:\t\t$inferred_total_qty\t\$$inferred_total_value\n";

When I run it on the data today I get this output:



Product                        Qty  Dollar value
Jalapenos:                     208  $30992
Singles:                       108  $140292
Single trade-ins:              118  $76641
Mini Rigs:                     6    $173400
Mini Rig trade-ins:            15   $216750
Documented total orders:       455  $638075
Value of average item ordered:      $1402.36263736264
Inferred total orders:         7029 $9857206.97802198

[smartlight]

Brilliant