Jump to content

9th International Mathtrade


ECplus3

Recommended Posts

I'm not sure yet if I want to regroup...

But if so - how?

 

Well first E&CPlus3 will have to sort the spreadsheet and make sure the ID numbers are assigned correctly. Once that is done, instructions will be posted. If you want to have a look at examples from the last trade, go here.

 

:)

 

Looks like he already has it sorted. ID numbers are on the left.

Edited by scificollector
Link to comment

The coin submission phase is closed!

 

We ended up with 35 participants and 976 coins for trade!

 

Now the Regroup Phase begins. If you are interested in regrouping coins to make an extra special package in the hopes of landing that one must-have coin, then follow the instructions below. When you are satisfied with the way your coins stand, please let me know via email or a post to this thread. Remember, regrouping is optional. If you simply want to trade your coins off one by one as they are now listed, all you need to do is send an email to the address below saying that you are done regrouping. If everyone finishes with the regrouping early, we can move on to the Want List Phase early.

 

Please contact me if you have any questions. The Regroup Phase will be open until January 20th, 9:00 PM EST (next Sunday).

 

Regrouping Instructions:

 

The Regroup Phase gives all participants the chance to create sets of two or more of their coins. You can do this to make an offer more attractive to others (and therefore to have a potentially higher chance to get a specifically wanted coin). Remember -- if you decide to group two or more coins together, these will only be traded as a complete set (or not at all).

 

To regroup your offers, please send an email to:

 

mathtrade9@gmail.com

 

containing the line numbers and the coin descriptions of all coins for each coin set you want to create. Also mention your geocaching.com nickname -- just as an extra measure of insurance to keep me from making mistakes.

 

-------------------------------------------

Example:

 

Let's say I have seen some must-have coins that I, well, must have. Unfortunately, I feel that the coins I am offering -- on their own -- won't seal the deal. So I decide to combine some of my coins into sets. I'll fire off an email with the required info:

 

Regrouping for E&Cplus3:

 

Group1

ID 160 DNA Geocoin gold

ID 161 DNA Geocoin silver

ID 162 DNA Geocoin copper

ID 165 DNA Geocoin antique silver

 

Group2

ID 177 Tennessee Micro 2008 nickel

ID 178 Tennessee Micro 2008 gold

 

-------------------------------------------

 

Please use the ID's as listed on the USE THIS COIN SHEET worksheet in the Mathtrade9 document.

Make sure you only use the numbers in the column titled "REFER TO THIS COLUMN ONLY!"

 

Please let me know if you have any questions about this process. You can post your questions here, or email them.

Edited by E&Cplus3
Link to comment

Hi, I'm wondering how fix the reference numbers are.

Three days ago I regrouped my coins with the IDs 201 and 202. The excelfile was sorted by Geocaching Nick Name.

Now I find the same coins with the IDs 486 and 487. The excel file is sorted by Coin Name now.

Anyone else you sent the wrong IDs?

Link to comment

Hi, I'm wondering how fix the reference numbers are.

Three days ago I regrouped my coins with the IDs 201 and 202. The excelfile was sorted by Geocaching Nick Name.

Now I find the same coins with the IDs 486 and 487. The excel file is sorted by Coin Name now.

Anyone else you sent the wrong IDs?

 

Yes, someone totally messed up the sort. It needs to be fixed.

Link to comment

Hi, I'm wondering how fix the reference numbers are.

Three days ago I regrouped my coins with the IDs 201 and 202. The excelfile was sorted by Geocaching Nick Name.

Now I find the same coins with the IDs 486 and 487. The excel file is sorted by Coin Name now.

Anyone else you sent the wrong IDs?

 

Yes, someone totally messed up the sort. It needs to be fixed.

 

i sent an email about grouping and mine are not grouped at all, nor are they next to each other. am i looking at the right document - the same as the first sheet?

Edited by RedShoesGirl
Link to comment

i had begun to sort out some of the coins i was interested in over the last weekend. i had written down coin numbers and names of coins i was thinking of grouping...those numbers no longer match.

 

ILYK

 

edited to add, did anyone else do this, and if so, do your numbers match?

Edited by drneal
Link to comment

i had begun to sort out some of the coins i was interested in over the last weekend. i had written down coin numbers and names of coins i was thinking of grouping...those numbers no longer match.

 

ILYK

 

edited to add, did anyone else do this, and if so, do your numbers match?

 

the numbers didn't match early on. i wrote down traders' names and coin name in order to keep track.

Link to comment

i had begun to sort out some of the coins i was interested in over the last weekend. i had written down coin numbers and names of coins i was thinking of grouping...those numbers no longer match.

 

ILYK

 

edited to add, did anyone else do this, and if so, do your numbers match?

 

I think the initial coin sort/assigning IDs happened on Monday of this week so the numbers wouldn't match up to last weekend. I usually just look at the coins I'm interested in and who is offering them and go back after the regroup phase to get the final IDs. Less chance of the IDs being offset and getting the wrong coins.

Link to comment

i had begun to sort out some of the coins i was interested in over the last weekend. i had written down coin numbers and names of coins i was thinking of grouping...those numbers no longer match.

 

ILYK

 

edited to add, did anyone else do this, and if so, do your numbers match?

 

I think the initial coin sort/assigning IDs happened on Monday of this week so the numbers wouldn't match up to last weekend. I usually just look at the coins I'm interested in and who is offering them and go back after the regroup phase to get the final IDs. Less chance of the IDs being offset and getting the wrong coins.

 

okfine !

 

ILYK
Link to comment

Sorry everyone! I've been very busy at work and haven't been following the thread or the email account. I had no idea that the spreadsheet had suffered some problems. Thanks scificollector for getting things fixed!!

 

I have now entered all the regrouping instructions that I received and reordered the list accordingly.

 

Instructions for submitting wish lists will be posted soon.

Link to comment

It's time to start explaining the trickiest part of this whole mathtrade thing: The Want List Phase.

 

Everyone now has a list of coins they are offering -- some grouped, some not. And most likely everyone has had a look through the whole list to see what they would like to get. How do we get there? By creating the Want Lists!

 

The general idea for a Want List is to define which of your own coins can be traded against which offered coins.

 

The following syntax is used:

 

own_coin_ID : wanted_ID_1 wanted_ID_2 .. wanted_ID_n

 

The colon (':') is used as a separator between the 'own_coin_ID' and the chosen wanted coins. The list of wanted coins is delimited by a space (' ').

 

As you can see, you have to specify a single 'own_coin_ID' and a list of possible IDs of all coins that you would accept as a trade for this coin. You are free to choose from all other coins when creating your lists. Furthermore, you are not limited to a single coin -- you can append all coins (via their respective coin IDs) that you are accepting as a trade. Theoretically, you could append the IDs of ALL the coins in this trade to your list.

 

The appearance of the IDs of the wanted coins is of importance, as it represents the order of preference in the list. In the first position is the 'most wanted' trade, and in the last position would be the 'least acceptable' trade.

 

If there is only one coin that you would trade your coin for, then there will only be one 'wanted_ID' in your list. If there are NO coins that you find acceptable as a trade for your coin, just leave the want list blank.

 

Okay, enough theory. Let's see it in action!

 

Looking at the list, I own the coins with the IDs 146 to 178-- or 33 coins. If I had grouped some of those coins, my Want List would have been a few lines shorter (each group -- regardless of the number of coins it contains -- will only have one line in the Want List)

 

So, let's say that I consider my MOGA 2009 coin (ID 172) to be the primo coin that I have offered. Looking through the list I find a few coins that I would like, but some really stand out: the Delft coins (67, 68, 69), Some Earth Turtle coins (378, 563, 783, etc) and the Greenman (642). Of those, I would favour the Delft Blau over the Turtles, followed by the Greenman. So my entry for the MOGA (theoretically) would look like:

 

172 : 67 68 69 378 563 783 642

 

I don't have any sets this year, but if I did, I would only have one entry in my Want List for the whole set. When listing a set, you only have to enter a single ID number and ignore the letters. If I had combined the DNA coins my set would have been labelled as 161A, 161B, 161C, etc. My want list for the set would look like:

 

161 : 67 68 69 378 563 783 642

 

Looking through the rest of the coins, there are only 8 that I would like to add to my collection. However, I still have 31 listings left to account for! If I list the IDs for only those 8 coins for each of my remaining coins, this will mean at best that 8 of my coins trade! But, for the sake of this exercise, that is what I'll do. The coins I want have the IDs 734 through 741, and that's the order of priority as well:

 

146 : 734 735 736 737 738 739 740 741
147 : 734 735 736 737 738 739 740 741
148 : 734 735 736 737 738 739 740 741
.
.
.
178 : 734 735 736 737 738 739 740 741

 

There! All done! Except for one thing. For some reason, I decide not to trade my Atlantis coin (ID 160). Maybe I can't part with it; maybe I've already traded it for a coin outside of the mathtrade. To show that it is unavailable, I either don't list it, or I list it with an empty line for the wanted coins:

 

160 : 

 

NOW my want list is done! For the convenience of my host, I will add my nick in parentheses in front of each line, and the whole list ends up looking like:

 

(E&Cplus3) 146 : 734 735 736 737 738 739 740 741
(E&Cplus3) 147 : 734 735 736 737 738 739 740 741
(E&Cplus3) 148 : 734 735 736 737 738 739 740 741
(E&Cplus3) 149 : 734 735 736 737 738 739 740 741
(E&Cplus3) 150 : 734 735 736 737 738 739 740 741
(E&Cplus3) 151 : 734 735 736 737 738 739 740 741
(E&Cplus3) 152 : 734 735 736 737 738 739 740 741
(E&Cplus3) 153 : 734 735 736 737 738 739 740 741
(E&Cplus3) 154 : 734 735 736 737 738 739 740 741
(E&Cplus3) 155 : 734 735 736 737 738 739 740 741
(E&Cplus3) 156 : 734 735 736 737 738 739 740 741
(E&Cplus3) 157 : 734 735 736 737 738 739 740 741
(E&Cplus3) 158 : 734 735 736 737 738 739 740 741
(E&Cplus3) 159 : 734 735 736 737 738 739 740 741
(E&Cplus3) 160 : 
(E&Cplus3) 161 : 67 68 69 378 563 783 642
(E&Cplus3) 162 : 734 735 736 737 738 739 740 741
(E&Cplus3) 163 : 734 735 736 737 738 739 740 741
(E&Cplus3) 164 : 734 735 736 737 738 739 740 741
(E&Cplus3) 165 : 734 735 736 737 738 739 740 741
(E&Cplus3) 166 : 734 735 736 737 738 739 740 741
(E&Cplus3) 167 : 734 735 736 737 738 739 740 741
(E&Cplus3) 168 : 734 735 736 737 738 739 740 741
(E&Cplus3) 169 : 734 735 736 737 738 739 740 741
(E&Cplus3) 170 : 734 735 736 737 738 739 740 741
(E&Cplus3) 171 : 734 735 736 737 738 739 740 741
(E&Cplus3) 172 : 67 68 69 378 563 783 642
(E&Cplus3) 173 : 734 735 736 737 738 739 740 741
(E&Cplus3) 174 : 734 735 736 737 738 739 740 741
(E&Cplus3) 175 : 734 735 736 737 738 739 740 741
(E&Cplus3) 176 : 734 735 736 737 738 739 740 741
(E&Cplus3) 177 : 734 735 736 737 738 739 740 741
(E&Cplus3) 178 : 734 735 736 737 738 739 740 741

 

Now I can send this list in an email to:

 

mathtrade9@gmail.com

 

There is one issue that I haven't discussed yet: How to prevent receiving the same coin more than once.

 

But I'll leave that for another post. I'll let y'all absorb the info in this post first.

Link to comment

Okay, here's Part II of the Want List tutorial...

 

Q. What if several people have listed a coin I really want. If I include all the IDs in my want lists, is it possible to get more than one?

 

A. Using the method I described above, yes this is a possibility.

 

Say I have listed coinID 161 and coinID 172 up for trade. I would like to get two of the following coins for them:

 

"Omni Animalia Germany" (IDs 551 627 694)

"Trees and Men" (IDs 307 788)

 

So I could make the following want list:

 

161 : 551 627 694 307 788
172 : 551 627 694 307 788

 

However, by doing it this way I would 'risk' receiving coin 551 for coin 161 and coin 627 for coin 172. I'd end up with two of the same "Animalia" coins instead of getting two different coins.

 

You can avoid this very easily by defining variables.

 

You define a coin group to make sure you only get at most 1 coin from that group. Pick a name for your group and stick a percent sign ('%') in front of it to indicate that it is a variable. Then add a colon (':') and a space-delimited list of coin IDs. In the example above, my coin variables would look like this:

 

%Animalia : 551 627 694
%TreesMen : 307 788

 

Now I simply include these names in my want list, instead of the actual coin numbers. My list would then change to look like this:

 

161 : %Animalia %TreesMen 
172 : %Animalia %TreesMen 

 

This way, if coin 161 gets traded for one of the coins from the %Animalia group, this will prevent coin 172 from being traded for another coin from that same group.

 

Your variables must be defined at the top of the want list that you send to me, and every line must start with your nickname in parentheses.

 

(E&Cplus3) %Animalia : 551 627 694
(E&Cplus3) %TreesMen : 307 788
(E&Cplus3) 161 : %Animalia %TreesMen 
(E&Cplus3) 172 : %Animalia %TreesMen 

 

But wait! There's more! You can nest your variables. This means that you can take a variable that you have already defined and use it within another variable. Why would you do this?

 

Say you have a coin that you would like to trade for the Animalia Germany coin, and only for that coin. But there are a few of them in the list (IDs 551 627 694). There are some other coins that you would like trade for ANY Animalia coin, including the Germany, and there are a LOT of them (IDs 369 371 777 780 693 419)

 

Well, you already have the Germany coins defined, so now you need to create a variable for the whole group:

 

(E&Cplus3) %AnimaliaGermany : 551 627 694
(E&Cplus3) %AnimaliaAll : %AnimaliaGermany 369 371 777 780 693 419
(E&Cplus3) %TreesMen : 307 788
(E&Cplus3) 161 : %AnimaliaGermany %TreesMen 
(E&Cplus3) 172 : %AnimaliaGermany %TreesMen
(E&Cplus3) 173 : %AnimaliaAll %TreesMen
(E&Cplus3) 174 : %AnimaliaAll %TreesMen

 

Notice how the second variable definition uses the variable defined earlier. In my want lists, coin 161 uses the %AnimaliaGermany variable, and coin 173 uses the variable for all Animalia coins.

 

Just a few notes about precedence: the coins listed within a variable all have equal weight! So, in the %AnimaliaAll variable, coin 551 has the same weight as coin 419. However, when using variables in your want lists, the normal precedence rules apply (ie. %AnimaliaGermany trumps %TreesMen).

 

That's it! Please don't hesitate to ask for clarification if I haven't explained things well enough.

Link to comment

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
×
×
  • Create New...