Page 1214 of 1220

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

Posted: Sat Jul 04, 2020 7:45 am
by Ziggy587
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!

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

Posted: Sat Jul 04, 2020 9:23 am
by Ziggy587
*** 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).

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

Posted: Sat Jul 04, 2020 11:47 am
by marurun
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.

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

Posted: Sat Jul 04, 2020 12:59 pm
by Ack
Ziggy587 wrote:*** FEEDBACK TOTALS UPDATED UP TO THIS POST ***


You're doing God's work, Zig!

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

Posted: Sat Jul 04, 2020 1:06 pm
by Ziggy587
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!

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

Posted: Wed Jul 08, 2020 6:15 pm
by Nemoide
+1 to Ziggy587 for another smooth transaction

And props for updating this thread! I never thought it would happen

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

Posted: Wed Jul 08, 2020 6:20 pm
by Ziggy587
+1 to Nemoide as well! Bought some more games from me, very easy to deal with. Thanks!

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

Posted: Thu Jul 09, 2020 8:03 pm
by o.pwuaioc
+1 Ziggy587


Got the games zippity ziggity quick.

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

Posted: Thu Jul 09, 2020 9:47 pm
by Ziggy587
+1 to o.pwuaioc for being an awesome buyer!

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

Posted: Fri Jul 10, 2020 4:26 pm
by Syndicate
...another +1 for Ziggy587, everything arrived on time and in great condition.