• Folks, if you've recently upgraded or renewed your annual club membership but it's still not active, please reach out to the BOD or a moderator. The PayPal system has a slight bug which it doesn't allow it to activate the account on it's own.

NJ Reefers Group Buy @ Keys Critters

K

katlongo

Phyl-- On the spreadsheet, on SOME of the people you're adding the pre-shipping subtotal in with the separate subtotals for Keys and Reeftopia - double adding it. Looks like you should just have to go in and change the sum formula for everyone.
 
Phyl

Phyl

Officer Emeritus
Officer Emeritus
Got it, Kat. That's just what it was. It was adding the range and I inserted those two rows to split the orders between keys and reeftopia. Ooops. All better now. And I've updated your inverts to reflect the move to the reeftopia ceriths.

All you funny people can stop goofing on me now! :D Errors? What errors?! Those numbers all look right to me! The club should make a buck here too, right?!
 
RichT

RichT

Officer Emeritus
Officer Emeritus
Please adjust my order;

From

Ceriths .25"                                     $0.18   50   $9.00
Ceriths-Large 1.25" (Reeftopia)       $0.75      $0.00
Ricordia single green (Reeftopia)     $7.00      $0.00
Nassarius Price per 12 (Reeftopia)   $10.00      $0.00
Peppermint Shrimp (Reeftopia)         $4.00      $0.00
BLH (Reeftopia)                                 $0.22      $0.00
Astrea                                              $0.20   25   $5.00
Stars                                                $2.00   3   $6.00
Emeralds                                         $1.50   6   $9.00
Scarlets (ReefTopia)                        $2.00   6   $12.00
Cucumers                                        $2.50      $0.00
BEFORE SHIPPING TOTAL                                  $41.00

To:
      
Ceriths .25"                                  $0.18 -    $0.00
Ceriths-Large 1.25" (Reeftopia)    $0.75 12 $9.00
Ricordia single green (Reeftopia)    $7.00 -    $0.00
Nassarius Price per 12 (Reeftopia)    $10.00 1 $10.00
Peppermint Shrimp (Reeftopia)    $4.00 4 $16.00
BLH (Reeftopia)                                     $0.22 25 $5.50
Astrea                                                     $0.20 25 $5.00
Stars                                                     $2.00 3 $6.00
Emeralds                                     $1.50 4 $6.00
Scarlets (ReefTopia)                     $2.00 6 $12.00
Cucumers                                     $2.50 -    $0.00
BEFORE SHIPPING TOTAL                         $69.50

Thanks again,
 
B

Brian

Officer Emeritus
Officer Emeritus
Okay.. Last time I will adjust my order

From This:

ReefDrumz   Central     
Ceriths .25"   $0.18   100   $18.00
Ceriths-Large 1.25" (Reeftopia)   $0.50      $0.00
Ricordia single green (Reeftopia)   $7.00      $0.00
Nassarius Price per 12 (Reeftopia)   $10.00      $0.00
Peppermint Shrimp (Reeftopia)   $4.00      $0.00
BLH (Reeftopia)   $0.22      $0.00
Astrea   $0.20   50   $10.00
Stars   $2.00      $0.00
Emeralds   $1.50   1   $1.50
Scarlets (ReefTopia)   $2.00   3   $6.00
Cucumers   $2.50      $0.00
BEFORE SHIPPING TOTAL         $35.50
Keys Total         $29.50
Reeftopia Total         $6.00
SHIPPING         $3.86
SUBTOTAL         $39.36

To This:

ReefDrumz   Central     
**Ceriths .25"   $0.18   50   $9.00 **
**Ceriths-Large 1.25" (Reeftopia)   $0.50 (50) $25.00**
Ricordia single green (Reeftopia)   $7.00      $0.00
**Nassarius Price per 12 (Reeftopia)   $10.00 (36) 30.00**             
(Peppermint Shrimp (Reeftopia)   $4.00      $0.00
BLH (Reeftopia)   $0.22      $0.00
Astrea   $0.20   50   $10.00
Stars   $2.00      $0.00
**Emeralds   $1.50   2   $3.00 **
Scarlets (ReefTopia)   $2.00   3   $6.00
Cucumers   $2.50      $0.00
BEFORE SHIPPING TOTAL         $83.00**
Keys Total         $22.00**
Reeftopia Total         $61.00**
SHIPPING         $ ?
SUBTOTAL         $ ?

The asterisk denotes the changes I have made.
 
Phyl

Phyl

Officer Emeritus
Officer Emeritus
Brian, Your total for the larger ceriths was wrong. The spreadsheet calculation was 25 for 50 (50*.50)

Rich, The price for the ceriths was wrong on your line so they're .50 not .75. I've fixed it for those it was wrong for.

Whew!
 
D

doswari

I'd like to add a few items.

doswari (Central)   Central     
Ceriths .25"   $0.18   50   $9.00
Ceriths-Large 1.25" (Reeftopia)   $0.50      $0.00
Ricordia single green (Reeftopia)   $7.00      $0.00
Nassarius Price per 12 (Reeftopia)   $10.00      $0.00
Peppermint Shrimp (Reeftopia)   $4.00      $0.00 to 2 for $8.00
BLH (Reeftopia)   $0.22   50   $11.00
Astrea   $0.20   25   $5.00
Stars   $2.00      $0.00
Emeralds   $1.50      $0.00  to 2 for $3.00
Scarlets (ReefTopia)   $2.00      $0.00
Cucumers   $2.50      $0.00 to 2 for $5.00


Thanks for all the hard work you're doing in keeping up with this group buy.
 
B

Brian

Officer Emeritus
Officer Emeritus
Phyl said:
Brian, Your total for the larger ceriths was wrong. The spreadsheet calculation was 25 for 50 (50*.50)

Great Math I have there... ::)

I think I fixed it.
Click to expand...
 
Phyl

Phyl

Officer Emeritus
Officer Emeritus
Got all changes through *here* and posted those to the totals on page 9.

Thanks gang.
 
M

momof6kids

NJRC Member
Last change for me too. ; ) Put me down for pick up in Woodbridge. Thanks

Momof6kids
Ceriths .25" $0.18 75 $13.50
Ceriths-Large 1.25" (Reeftopia) $0.50 $0.00
Ricordia single green (Reeftopia) $7.00 $0.00
Nassarius Price per 12 (Reeftopia) $10.00 $0.00
Peppermint Shrimp (Reeftopia) $4.00 3 $12.00
BLH (Reeftopia) $0.22 75 $16.50
Astrea $0.20 60 $12.00
Stars $2.00 4 $8.00
Emeralds $1.50 5 $7.50
Scarlets (ReefTopia) $2.00 1 $2.00
Cucumers $2.50 $0.00
BEFORE SHIPPING TOTAL $71.50
Keys Total $41.00
Reeftopia Total $30.50
SHIPPING $4.25
SUBTOTAL $75.75
 
J

JasonR

Phyl said:
I think the idea is to place it Friday the 2nd for delivery Tuesday the 6th. We'll see how that plan goes. Since the inverts dry ship I think delivering for the Christmas Party is not really very practical (not to mention I've already got my hands full that day).

Yes, we're planning on ordering from both Keys Critters and Reeftopia.

Marc As soon as I know what day the order will be shipped I'll let you know.

Thanks All!
Click to expand...

Great I dont think I can get my system to cycle in a week
OH WELL

Jason
 
D

dflint

I WOULD LIKE TO CHANGE MY ORDER SLIGHTLY

Changes are Bolded

Dflint (Woodbridge) Central

Ceriths .25" $0.18 60 $10.80
Ceriths-Large 1.25" (Reeftopia) $0.50 $0.00
Ricordia single green (Reeftopia) $7.00 x 1 $7.00
Nassarius Price per 12 (Reeftopia) $10.00 $0.00
Peppermint Shrimp (Reeftopia) $4.00 x3 $12.00
BLH (Reeftopia) $0.22 0 $0.00
Astrea $0.20 30 $6.00
Stars $2.00 $0.00
Emeralds $1.50 4 $6.00
Scarlets (ReefTopia) $2.00 $0.00
Cucumers $2.50 1 $2.50

Thanx!
 
J

jer1198

alright, time to put in my order

pickup south/central

ceriths (large)  12 @ .50 = 6.00

ceriths (small) 50 @ .18 = 9.00

pep shrimp       3 @ 4.00 = 12.00

turbo/astrea    50 @ .20 =  10.00

BLH (reeftopia) 50 @ .22 = 11.00

emerald crab     4 @ 1.50 = 6.00

scarlets            6 @ 2.00 = 12.00

stars                2 @ 2.00 = 4.00
       
 
malulu

malulu

NJRC Member
Please help... latest info...

Malulu (Central)

Ceriths              $0.18       20        $3.60 
Ceriths-Large    $0.50       30      $15.00
BLH                   $0.22     120      $26.40
Astrea               $0.20       70      $14.00
Stars                 $2.00         5      $10.00
Emeralds           $1.50       10      $15.00
Scarlets             $2.00       10      $20.00
Cucumers          $2.50         5      $12.50
Nassarius        $10.00      (12)     $10.00

Pre-Shipping   $126.50

thanks a lots...
 
Phyl

Phyl

Officer Emeritus
Officer Emeritus
Whitesquall... I haven't heard back from Reeftopia yet. I'm not envisioning a drop in the peppermint pricing though!

Page 9 has been updated with new totals. Thanks!
 
You must log in or register to reply here.
Top