Spreadsheets Are Useful

Since I started sending my companions on crew missions in order to gain higher affection with them, I’ve been accumulating large amounts of materials. I’m keeping a good chunk of them for crafting purposes, but I have far more than needed so I started dumping a lot of them onto the GTN.

There are several materials that are nearly impossible to sell because the prices fluctuate too much. It’s like no one can agree on a fixed price, so there are some who price it obscenely high and then those who price the items ridiculously low.

For the most part I have been trying to cater to preferred and f2p players. I place 50 or lower quantities of something under a million credits so they can afford to buy them, while also pricing it high enough to make a profit. There are some materials I do sell in bigger bulk for those who are subscribed. Those listings always take longer to sell and need to be relisted until they’re bought.

There have been a couple times I’ve tried selling something and keep relisting over and over again before I finally give up because it’s clear that people either don’t need that particular material or it’s not the right time. Which is where spreadsheets comes in handy. I have a terrible memory when it comes to what sells and what doesn’t so I’ve been putting together a spreadsheet to help me remember. I write down the item, how much it sold for, and how many I sold. It has really helped me a lot because now all I have to do is pull up the spreadsheet whenever I want to put something on the GTN.

It’s been awhile since the last time I made a spreadsheet and this is my first time making one for a game. Over the years I’ve written my fair share of notes for games, either on a notepad or word doc, though never a spreadsheet. So this has been an interesting experience. I doubt this will be my last time now that I know how useful they are.


4 thoughts on “Spreadsheets Are Useful

  1. I never thought of cataloging the items that don’t sell much in GTN. I usually post them for a max of 3 days and then after that, I simply dump them to any NPC for credits, I only do this for the loot items, I do keep track of the ones that I craft and sell most in GTN though.

    Liked by 1 person

  2. I first started keeping a spreadsheet for SWTOR a couple of years ago, but it was for gear, to keep track of which characters had which item level in which slot, so that I could send spare drops over to the right one. Since extra gear for alts is much easier to come by now I fortunately don’t need that one anymore, but I also have another one for quest progress. So when someone asks if anyone wants to kill the Gree event world bosses for example, I can prioritise a character that has the quest for them. I find it impossible to keep track of who needs what across twenty different alts otherwise, haha.

    Liked by 1 person

    1. Having a spreadsheet on your alts progress sounds like a good idea. I am starting to forget how far my alts have progressed in their respective stories, especially which ones have finished Alliance Alerts. I might have to steal your idea. 🙂


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.