Items For Sale
Arrange the purchasing and selling of items.
TOPIC | [HUB] Community Gem Exchange
1 2 3 4 5 6 7 ... 21 22
[center][url=https://docs.google.com/spreadsheets/d/1_PFTgG37qySXC9V4ka9yEFkfaE88RqGKA_ohzSelHG0/edit#gid=0]Gem Exchange Spreadsheet[/url] [columns][center][color=transparent]texttext[/color][img]https://s33.postimg.cc/rc12gcvzj/Pearl-gem.jpg[/img][nextcol][color=transparent]texttext[/color][nextcol][font=timesnewroman][size=4][color=55809e]Do you need to buy or sell some gems? Are you tired of having to hunt through pages on the forums just to find a buyer or a seller? Ever wonder if there's a better price out there? Why not try the Gem Exchange?[/columns] [columns][color=transparent]texttexttexttext[nextcol][font=timesnewroman][size=7][size=4][color=transparent]texttext[color=55809e]The[/size][/size] [size=7][size=5][color=55809e]Gem Exchange[nextcol][color=transparent]texttexttexttext[img]https://s33.postimg.cc/qheiud65b/13399.png[/img][/columns] [font=timesnewroman][size=4][size=3][color=55809e][b]Welcome to the gem exchange![/b] The Gem Exchange was created with the purpose of bringing gem buyers and sellers together in one place in order to make gem sales easier. Even if you don't want to get rid of your own thread, simply list yourself here for even more exposure. Don't forget to bookmark us for future reference and remember to check the news for any updates we may make to the Gem Exchange. We go into this with the hope that this thread and it's accompanying spreadsheet will be of great use to everyone in the community! [b]NOTE:[/b] I'll give 1,000 treasure to anyone per bump, provided it's been an hour since the last bump. Stopping in to check the exchange? Give it a bump and get some treasure while you're here. Deleting old bumps is appreciated. ----- [center][font=timesnewroman][size=4][size=5][color=55809e][u]Table of Contents[/u][/size] [columns][color=transparent]texttexttexttexttexttexttexttext[nextcol][size=4][list] [*][size=4][url=http://www1.flightrising.com/forums/ibaz/2472335/1#post_33978267]News and Updates[/url] [*][size=4][url=http://www1.flightrising.com/forums/ibaz/2472335/1#post_33978268]Rules of the Exchange[/url] [*][size=4][url=http://www1.flightrising.com/forums/ibaz/2472335/1#post_33981335]Using the Spreadsheet[/url] [/columns] ----- [center][font=timesnewroman][size=4][size=5][color=55809e][u]Exchange Staff[/u][/size] [columns][color=transparent]texttextte[img]http://www1.flightrising.com/rendern/portraits/132718/13271756p.png[/img][color=transparent]texttext[nextcol][font=timesnewroman][color=55809e][size=5] - [b]Exchange Subervisor[/b] - @vihuff[/size][size=4] [i]If you have any suggestions for us or any questions about the exchange, please don't hesitate ask. If there are any problems with the spreadsheet, please notify me right away.[/i][/size] [size=5]- [b]Spreadsheet Master[/b] - Chrisondra[/size][size=4] [i]It's all thanks to lovely Chrisondra that we have this wonderful spreadsheet as they were the one who helped me get it coded up and functioning. Thank you so much! (Please don't ping them.)[/i]
Gem Exchange Spreadsheet
texttextPearl-gem.jpg
texttext Do you need to buy or sell some gems? Are you tired of having to hunt through pages on the forums just to find a buyer or a seller? Ever wonder if there's a better price out there? Why not try the Gem Exchange?
texttexttexttext texttextThe
Gem Exchange
texttexttexttext13399.png

Welcome to the gem exchange! The Gem Exchange was created with the purpose of bringing gem buyers and sellers together in one place in order to make gem sales easier. Even if you don't want to get rid of your own thread, simply list yourself here for even more exposure. Don't forget to bookmark us for future reference and remember to check the news for any updates we may make to the Gem Exchange. We go into this with the hope that this thread and it's accompanying spreadsheet will be of great use to everyone in the community!

NOTE: I'll give 1,000 treasure to anyone per bump, provided it's been an hour since the last bump. Stopping in to check the exchange? Give it a bump and get some treasure while you're here. Deleting old bumps is appreciated.


Table of Contents
texttexttexttexttexttexttexttext

Exchange Staff
texttextte13271756p.pngtexttext - Exchange Subervisor - @vihuff
If you have any suggestions for us or any questions about the exchange, please don't hesitate ask. If there are any problems with the spreadsheet, please notify me right away.


- Spreadsheet Master - Chrisondra
It's all thanks to lovely Chrisondra that we have this wonderful spreadsheet as they were the one who helped me get it coded up and functioning. Thank you so much! (Please don't ping them.)
rsz_pearl-gem.jpg
Join The Gem Exchange!
Quest for all Food!
News and Updates

Timestamps - 10/22/18
You have been heard. In addition to the online status column, a timestamp column has been added as well. Now, whenever a user changes their online status, the time and date of the change will be recorded.



Online Status - 10/15/18
An Online/Offline column has been added for your convenience. This is a manual column that you change yourself. Everyone was set to online when the columns were created.

The average gem ratio has also been updated. Before, it would pull from the entirety of the buyers and sellers lists but as there are many outliers and many more buyers than there are sellers on the sheet at any given time, this was skewing the ratio. It has been changed so that it only takes the top ten from both sheets to calculate the ratio, which gives a much better number.

Please ignore the timestamp columns as those have no effect currently.



Back and Forth - 6/3/18
A link to the main thread has been added to the spreadsheet. Now users can easily move from one to the other.
News and Updates

Timestamps - 10/22/18
You have been heard. In addition to the online status column, a timestamp column has been added as well. Now, whenever a user changes their online status, the time and date of the change will be recorded.



Online Status - 10/15/18
An Online/Offline column has been added for your convenience. This is a manual column that you change yourself. Everyone was set to online when the columns were created.

The average gem ratio has also been updated. Before, it would pull from the entirety of the buyers and sellers lists but as there are many outliers and many more buyers than there are sellers on the sheet at any given time, this was skewing the ratio. It has been changed so that it only takes the top ten from both sheets to calculate the ratio, which gives a much better number.

Please ignore the timestamp columns as those have no effect currently.



Back and Forth - 6/3/18
A link to the main thread has been added to the spreadsheet. Now users can easily move from one to the other.
rsz_pearl-gem.jpg
Join The Gem Exchange!
Quest for all Food!
Rules of the Exchange

Respect the Users
Please respect your fellow users. We don't want to see negative attitudes or people harassing others for any reason. This means that if you have been denied a sale, please don't continue to bother the buyer/seller, no one is obligated to complete a sale. Don't harass people over prices, they can set them at whatever they choose.

Respect the Tools
This would be the thread and the spreadsheet. Please do not ping people who have asked not to be pinged, do not spam the thread and keep all posts on topic and respectful. Please do not alter any information within the spreadsheet but your own. A lot of work went into it and we'd hate for it to be misused.

Trade Wisely
The Gem Exchange is not responsible for any trades gone wrong. We are only here to make buying and selling gems easier. We recommend that all sales be done through a 2-way crossroads in order to ensure safe trading. If you choose otherwise, you do so at your own risk.

Wise trading also includes fluctuating prices. If you happen to buy or sell gems to/from someone at a certain price but a better price becomes available, do not harass someone saying a sale was unfair or demand a refund. The sale was completed and you agreed to it.


Use it to its Fullest Potential
The exchange is here for your benefit, so please use it! As there is no gem selling/buying Auction House function, we hope that this will make your lives easier. Using the exchange gets rid of the need for keeping tons of threads that users have to upkeep, bump, close/delete, and constantly dig for. And instead, gathers everyone in one place for smoother trading.
Rules of the Exchange

Respect the Users
Please respect your fellow users. We don't want to see negative attitudes or people harassing others for any reason. This means that if you have been denied a sale, please don't continue to bother the buyer/seller, no one is obligated to complete a sale. Don't harass people over prices, they can set them at whatever they choose.

Respect the Tools
This would be the thread and the spreadsheet. Please do not ping people who have asked not to be pinged, do not spam the thread and keep all posts on topic and respectful. Please do not alter any information within the spreadsheet but your own. A lot of work went into it and we'd hate for it to be misused.

Trade Wisely
The Gem Exchange is not responsible for any trades gone wrong. We are only here to make buying and selling gems easier. We recommend that all sales be done through a 2-way crossroads in order to ensure safe trading. If you choose otherwise, you do so at your own risk.

Wise trading also includes fluctuating prices. If you happen to buy or sell gems to/from someone at a certain price but a better price becomes available, do not harass someone saying a sale was unfair or demand a refund. The sale was completed and you agreed to it.


Use it to its Fullest Potential
The exchange is here for your benefit, so please use it! As there is no gem selling/buying Auction House function, we hope that this will make your lives easier. Using the exchange gets rid of the need for keeping tons of threads that users have to upkeep, bump, close/delete, and constantly dig for. And instead, gathers everyone in one place for smoother trading.
rsz_pearl-gem.jpg
Join The Gem Exchange!
Quest for all Food!
Using the Spreadsheet

Spreadsheet!

The spreadsheet has been optimized and streamlined to require very little effort on anyone's part in order to use and upkeep, so everyone is able to use it!*

*That is unless something needs to be fixed. If that's the case, please contact vihuff

Inputting Information
The forth page of the sheet titled "Input" is where you place your information
- Place your username in an empty row in the either the buy or sell section, or both if you're a flipper.
- Place how many gems you are looking to buy/sell in the quantity column.
- Place how much treasure you are looking to gain/spend per gem in the Price column. Ex: 850.
- Place any extras in the notes column. Ex: "No need to ping. Just send a CR." or "Closed for the night"

Boom! All done. Easy right? You can ignore the rank bit, that's just part of how the sheet works. Once you no longer have any gems to buy/sell please make your amount and price blank so that you fall to the bottom of the sheet.


What the Sheet Does
It actually does quite a bit despite how simple it looks!

- Each page, both Buying and Selling are auto sorted so that the best value is placed directly at the top and scale down from there. So users can hop right into the tabs, check the listings, and see exactly which users have the best values at the time. In the Buying gems tabs, users willing to pay more treasure per gem are higher on the list, and in the Selling Gems tabs, users willing to sell for less are higher. Cool right?

- To make things even more streamlined, the top ten sales on each page are also featured on the first page of the spreadsheet for easy viewing, so you don't have to keep page hopping every time.

- An added feature of the Gem Exchange spreadsheet is that it automatically calculates the current going rate for gems. This is featured right on the first page of the sheet. This not only helps people see what gems are currently worth for buying and selling purposes, but can also be of use to as a whole. With one quick glance, you can see what the current gem market looks like.

- The sheet also has an Online/offline status feature so users are able to tell who is around to exchange with. A timestamp will automatically track when the last time this was changed.
Using the Spreadsheet

Spreadsheet!

The spreadsheet has been optimized and streamlined to require very little effort on anyone's part in order to use and upkeep, so everyone is able to use it!*

*That is unless something needs to be fixed. If that's the case, please contact vihuff

Inputting Information
The forth page of the sheet titled "Input" is where you place your information
- Place your username in an empty row in the either the buy or sell section, or both if you're a flipper.
- Place how many gems you are looking to buy/sell in the quantity column.
- Place how much treasure you are looking to gain/spend per gem in the Price column. Ex: 850.
- Place any extras in the notes column. Ex: "No need to ping. Just send a CR." or "Closed for the night"

Boom! All done. Easy right? You can ignore the rank bit, that's just part of how the sheet works. Once you no longer have any gems to buy/sell please make your amount and price blank so that you fall to the bottom of the sheet.


What the Sheet Does
It actually does quite a bit despite how simple it looks!

- Each page, both Buying and Selling are auto sorted so that the best value is placed directly at the top and scale down from there. So users can hop right into the tabs, check the listings, and see exactly which users have the best values at the time. In the Buying gems tabs, users willing to pay more treasure per gem are higher on the list, and in the Selling Gems tabs, users willing to sell for less are higher. Cool right?

- To make things even more streamlined, the top ten sales on each page are also featured on the first page of the spreadsheet for easy viewing, so you don't have to keep page hopping every time.

- An added feature of the Gem Exchange spreadsheet is that it automatically calculates the current going rate for gems. This is featured right on the first page of the sheet. This not only helps people see what gems are currently worth for buying and selling purposes, but can also be of use to as a whole. With one quick glance, you can see what the current gem market looks like.

- The sheet also has an Online/offline status feature so users are able to tell who is around to exchange with. A timestamp will automatically track when the last time this was changed.
rsz_pearl-gem.jpg
Join The Gem Exchange!
Quest for all Food!
@vihuff
Hey! This is an awesome idea and I hope people get to using it, because I think it'll become very useful - but just so you know, currently if I try to type anything into the Input spreadsheet it says I don't have permission. I'm not sure what's up with that, but I figured you'd want to know.
@vihuff
Hey! This is an awesome idea and I hope people get to using it, because I think it'll become very useful - but just so you know, currently if I try to type anything into the Input spreadsheet it says I don't have permission. I'm not sure what's up with that, but I figured you'd want to know.
art by noodlestuff
QrtG9rA.png
I love this idea!
I love this idea!
tDeKDnH.pngRK2q3qt.pnguCZgS26.png
@vihuff

Nice spreadsheet! It's already gotten me most of my gems tonight. :) I'll definitely keep an eye on it in the future.
@vihuff

Nice spreadsheet! It's already gotten me most of my gems tonight. :) I'll definitely keep an eye on it in the future.
iWhIiEj.png
OK, trying this out. ^_^
OK, trying this out. ^_^
aZH7yM3.png
#ghost pinged Thanks for this, it will certainly help :D
#ghost pinged Thanks for this, it will certainly help :D
@vihuff Usually I sell gems rarely. I'll pass for now, but thanks for alerting me of this. :)
@vihuff Usually I sell gems rarely. I'll pass for now, but thanks for alerting me of this. :)
fcJxF3m.png
1 2 3 4 5 6 7 ... 21 22