Post Your Non-Auction Goods Here
User avatar
Ziggy587
Next-Gen
 
Posts: 12793
Joined: Mon Jun 09, 2008 5:12 pm
Location: NY

Re: Transaction Feedback - Totals - Updated March 24, 2017

by Ziggy587 Sat Jul 04, 2020 7:45 am

SpoonyBard wrote:+1 to Ziggy587, shipped super quick and everything was really well packed! Thanks man!


+1 to SpoonyBard for the same transaction. Thanks so much, man. Hope you enjoy everything!
Image

My Sale Thread - I am selling around three quarters of my video game collection as well as some other odds and ends!
User avatar
Ziggy587
Next-Gen
 
Posts: 12793
Joined: Mon Jun 09, 2008 5:12 pm
Location: NY

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Ziggy587 Sat Jul 04, 2020 9:23 am

*** FEEDBACK TOTALS UPDATED UP TO THIS POST ***

It was over three years since the last update... That was long enough! But it's actually really easy to update it using Excel. To anyone who might update the first post in the future: Please keep the tabs!

First, I needed to get everything into their own columns in Excel. So I copy/pasted the entire list into one column, then used the "text to column" tool and separated by spaces. This got it most of the way there, but any username that had spaces in it got separated into columns. So I just manually went through to fix those. Now everything is in columns. When you copy and paste columns to text (like Notepad or this forum's reply edit field) it will input a tab in between each column. When you post the reply the forum will automatically convert the tabs to spaces, but the tabs will be preserved when you go to edit the post. This is important because when you copy it back to Excel with the tabs everything will go into the correct columns again, making it very easy to update.

For anyone that might update in the future, here's what I did: After getting everything into columns, I went through the posts since the last update and copy/pasted the usernames into the username column and whatever the associate count was. Then after I got them all, I sorted the usernames alphabetically. Then I created a rule for the username column to highlight duplicates in red. Then I just scrubbed the list manually for the duplicates. If you highlight the feedback count column, Excel will show the sum. I just quickly inputted the totals for whatever duplicates there were, then delete the duplicates. I know that there's a remove duplicate function in Excel, and I'm sure there's some slick way to use that and somehow total everything at the same time, but the way I did it was easy and quick enough. What really took long was the fact that the last update was over three years ago, but it still didn't take very long (maybe an hour).
Image

My Sale Thread - I am selling around three quarters of my video game collection as well as some other odds and ends!
User avatar
marurun
Moderator
 
Posts: 9960
Joined: Sat May 06, 2006 8:51 am
Location: Cleveland, OH

Re: Transaction Feedback - Totals - Updated July 4, 2020

by marurun Sat Jul 04, 2020 11:47 am

Wow, fantastic work! Thank you so much for updating these! I don’t trade much so it probably didn’t do me a lot of favors, but I bet some folks got a nice boost.
B/S/T thread
My Classic Games Collection
My Steam Profile
The PC Engine Software Bible Forum, with Shoutbox chat - the new Internet home for PC Engine fandom.
User avatar
Ack
Moderator
 
Posts: 21392
Joined: Tue Mar 18, 2008 4:26 pm
Location: Atlanta, GA

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Ack Sat Jul 04, 2020 12:59 pm

Ziggy587 wrote:*** FEEDBACK TOTALS UPDATED UP TO THIS POST ***


You're doing God's work, Zig!
Image
Image
I have a movie review website now: https://moviereviewsbyamook.com/
User avatar
Ziggy587
Next-Gen
 
Posts: 12793
Joined: Mon Jun 09, 2008 5:12 pm
Location: NY

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Ziggy587 Sat Jul 04, 2020 1:06 pm

I'm telling ya, it was actually rather easy using Excel. The only hard part was the fact that it was 26 pages to go through since the last update!
Image

My Sale Thread - I am selling around three quarters of my video game collection as well as some other odds and ends!
User avatar
Nemoide
Next-Gen
 
Posts: 2067
Joined: Sat Aug 27, 2011 6:37 pm
Location: Monster Island

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Nemoide Wed Jul 08, 2020 6:15 pm

+1 to Ziggy587 for another smooth transaction

And props for updating this thread! I never thought it would happen
Image
User avatar
Ziggy587
Next-Gen
 
Posts: 12793
Joined: Mon Jun 09, 2008 5:12 pm
Location: NY

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Ziggy587 Wed Jul 08, 2020 6:20 pm

+1 to Nemoide as well! Bought some more games from me, very easy to deal with. Thanks!
Image

My Sale Thread - I am selling around three quarters of my video game collection as well as some other odds and ends!
User avatar
o.pwuaioc
Next-Gen
 
Posts: 7748
Joined: Tue Mar 29, 2011 7:59 pm
Location: NYC

Re: Transaction Feedback - Totals - Updated July 4, 2020

by o.pwuaioc Thu Jul 09, 2020 8:03 pm

+1 Ziggy587


Got the games zippity ziggity quick.
User avatar
Ziggy587
Next-Gen
 
Posts: 12793
Joined: Mon Jun 09, 2008 5:12 pm
Location: NY

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Ziggy587 Thu Jul 09, 2020 9:47 pm

+1 to o.pwuaioc for being an awesome buyer!
Image

My Sale Thread - I am selling around three quarters of my video game collection as well as some other odds and ends!
User avatar
Syndicate
8-bit
 
Posts: 25
Joined: Mon May 25, 2020 10:37 pm
Location: NoVA

Re: Transaction Feedback - Totals - Updated July 4, 2020

by Syndicate Fri Jul 10, 2020 4:26 pm

...another +1 for Ziggy587, everything arrived on time and in great condition.
Return to Buy/Sell/Trade

Who is online

Users browsing this forum: No registered users and 7 guests