PlaystationTrophies Got a news tip? tips@x360a.org
Username
Password
 

Go Back   XboxAchievements.com > Xbox 360 Retail Games > Shooter > Gears of War 3
Subscribe    Donate

Reply
 
Thread Tools Display Modes
Old 10-08-2011, 04:31 PM   #1
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Exclamation Seriously 3.0 Achievement Tracker - Version 2.0

Ok guys it's finally here...Version 2.0!
Here is a look at the new sheets!






You will quickly notice there has been several cosmetic changes to the sheet with several Conditional formatting instances.
  • There has been an addition of a status bar to the percentage columns...and when you get 100% for a medal you get a gold star (2010 format only for stars, sorry).
  • In the 'Til Next Medal' Column. Not only are you shown how many instances needed to a medal, you are given a color indication for the next medal.
  • A percentage is now displayed for completion toward a medal type. (i.e. versus, horde, beast, etc...)
  • I have eddited formulas so that if at anytime the values needed for any medal change all one has to do is simply corrections for that number.
  • The sheet is now generically protected...meaning just click 'unprotect sheet' and you can make edits as needed....But, I highly recommend leaving protection on so not to wonder off to a non-input cell.
  • Also I added a sheet that has a link to Nikke84's Onyx Medal Guide.
What really makes this sheet a Version 2.0 is the new addition of Signature pages...They are formatted to easily make a 'print screen' copy of, edit, and then upload...

The Signature Page...


You'll see in the above picture that it says "Celick's Seriously 3.0" ... But if you decide to use this Sig you will be able to use your gamertag, so it will be "Your Seriously 3.0". To give you guys some variety to display your progress, I created several sigs using different pictures representing Gears of War 3.
The 2010 Format has 20 usuable Sigs and the 2007 Format has 10 usuable Sigs.
(10 different pictures, with 2 different formats to display what medals have been earned for excel 2010)

Here are a couple of you choices...



(The below is a copy of the 'How To Use Sheet' page)

How to Use this Spreadsheet
It's as simple as entering what your current value for a given medal is.
Note that data entry cells have been colored to indicate so.

What the Spreadsheet tells you
A description for the required action of a medal has been added as a comment for each medal.

Upon entering your current value for a specific medal
You are given how many actions needed until your next medal and a color indicaiton of what that next medal is.
An indication of what medal you have unlocked.
A percentage completion for that particular medal.
A status bar for completion to 100% per medal, and upon reaching 100% you are awarded a gold star!

With this data, the spreadsheet then displays a weighted average for all 65 medals on the "Progress to Completion" tab. Also on this tab,
A status bar to 100% completion reflecting your current percentage complete.
The current level your character is at.
The number of Onyx medals you have completed out of the 65.

Your status on the medals "All Fathers", "Master-at-Arms", and "Rifleman" are automatically updated to reflect the completion of their counterpart medals.
A weighted average is also given to these medals based on current completion.

Sheet Protection
The sheets in this spreadsheet are under Generic Protection and can be unprotected by simply clicking "Unprotect Sheet" under the "Review" tab at the top. To reprotect the sheet simply click "Protect Sheet" and click 'OK' when the box pops up to place back in Generic Protection.
While protected, you can only enter data in cells that reflect your current medal values.
These values have to fall within the range for that particular medal or an error message will be given to you.
A drop down box for difficulty completion medals has been added so misspelled words would not be an issue.

Usable Signature:
I have added a new page which is a formated signiture that you can use in your SIG on 360a.com forums or other gaming forums. This is covered in more detail on the newly added Signature Page (Sig 1).

Good Luck on your way to Seriously 3.0!!,
Celick







Update:
10/08/11 - Made minor error correction pointed out by xCreed...Files updated
10/15/11 - Made spelling error corrections and updated some descriptions to reflect all weapon kill types for particular medals.
10/16/11 - Made minor error correction pointed out by Dan2102...Files updated
11/17/11 - Update to Version 2.0, correction made for minor error pointed out by flydog92, updates for Vengeful and Leader.
11/18/11 - Made Spelling error corrections pointed out by Keizaron and Modified sig data for a cleaner looking format.
12/24/11 - Made Spelling error correction pointed out by debje, added a 93-2003 formatted sheet, and added a Last Updated readout to the sigs.

Wanted to leave a link to CtrI Atl Deafet's thread since they did
upload theirs before me shortly after the games release.
CtrI Alt Defeat's Thread
http://www.xbox360achievements.org/forum/showthread.php?t=333803
__________________

Last edited by Celick; 12-24-2011 at 05:21 PM. Reason: Added an excel 97-2003 format
Celick is offline   Reply With Quote
Old 10-08-2011, 04:36 PM   #2
collin232
 
collin232's Avatar
 
Join Date: Mar 2009
Posts: 628

iremnantsx's Gamercard
If I have MS office 2007 should I download the one for 2003 or 2010?
__________________

Brohoof /)*(\
40000 GS reached 3/1/2014 Recon Battlefield 4 (Xbone)
collin232 is offline   Reply With Quote
Old 10-08-2011, 04:41 PM   #3
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by collin232 View Post
If I have MS office 2007 should I download the one for 2003 or 2010?
I would say 2003, but if one doesn't open the other should.
__________________
Celick is offline   Reply With Quote
Old 10-08-2011, 04:49 PM   #4
debje
 
Join Date: Sep 2008
Location: the Netherlands
Posts: 88

debje's Gamercard
hadnt seen the other one yet, but nice job.
debje is offline   Reply With Quote
Old 10-08-2011, 04:59 PM   #5
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by debje View Post
hadnt seen the other one yet, but nice job.
Thank you.
__________________
Celick is offline   Reply With Quote
Old 10-08-2011, 05:02 PM   #6
McGoogles
 
McGoogles's Avatar
 
Join Date: Jan 2010
Location: United States
Posts: 5,213

Ratify's Gamercard

Awards Showcase Staff Club - * Clueless *   Staff Club - Grifter Reborn   Arcade Crazy - Bronze   5,000 Posts   Over Achiever - Silver   Staff Club - DEG23   XBA Promoter   Submit - Silver
Total Awards: 8 (more» ...)
Very nice work; well organized, accurate, and colorful. I'm definitely going to use this and it'll help in the long run.

Also, have you read that the Onyx Vengeful medal will be reduced?
__________________
137/138 games completed (including DLC)
Completion percentage: 99.15%
Latest retail completion: Max Payne 3
Latest arcade completion: Motocross Madness




McGoogles is offline   Reply With Quote
Old 10-08-2011, 05:04 PM   #7
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by McGoogles View Post
Very nice work; well organized, accurate, and colorful. I'm definitely going to use this and it'll help in the long run.

Also, have you read that the Onyx Vengeful medal will be reduced?
Yes i have...I plan on updating the sheet and uploading after they have made the changes.

And Thanks
__________________
Celick is offline   Reply With Quote
Old 10-08-2011, 05:32 PM   #8
mdp 73
 
mdp 73's Avatar
 
Join Date: Jun 2007
Location: Canada
Posts: 110

mdp 73's Gamercard
Very nice and so easy to work with. Love the colouring.
mdp 73 is offline   Reply With Quote
Old 10-08-2011, 05:42 PM   #9
mjc0961
 
Join Date: Oct 2007
Location: USA (GMT -5)
Posts: 2,101

mjc0961's Gamercard

Awards Showcase 1,000 Posts   Submit - Gold   Arcade Crazy - Bronze
Total Awards: 3 (more» ...)
Looks cool, but is it possible to make a version that just works in Google Documents itself rather than downloading it? I'm stuck with Microsoft Works and it refuses to open either version due to the encrypting you did.
__________________


Quote:
Originally Posted by ViolentCabaret View Post
This guide continues to warm my heart and piss off my roommates. Thanks so much!
mjc0961 is offline   Reply With Quote
Old 10-08-2011, 06:06 PM   #10
xCreed
 
Join Date: Oct 2011
Posts: 1

x C IR EE ID's Gamercard
The only mistake I've found is Survivalist in the Campaign section is listed as 10 for bronze, but bronze is 20.

But other than that good job
xCreed is offline   Reply With Quote
Old 10-08-2011, 06:59 PM   #11
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by mjc0961 View Post
Looks cool, but is it possible to make a version that just works in Google Documents itself rather than downloading it? I'm stuck with Microsoft Works and it refuses to open either version due to the encrypting you did.
I'll see what i can do, have never done that before. But i will give it a try.
Edit...
Mjc, i tried doing what you asked but putting the sheet in a google friendly share causes the sheet to not work properly...Sorry I can't help.

Quote:
Originally Posted by xCreed
The only mistake I've found is Survivalist in the Campaign section is listed as 10 for bronze, but bronze is 20.

But other than that good job
I will fix that now and upload the correction...Thanks for pointing that out.
__________________

Last edited by Celick; 10-08-2011 at 07:27 PM.
Celick is offline   Reply With Quote
Old 10-08-2011, 07:11 PM   #12
gcwright90
 
Join Date: Aug 2009
Posts: 15
Wow, I literally just made an updated version for Control Alt Defeat's original spreadsheet that includes pretty much all of the features you put in. I have PM'ed him a version that has the cell medal coloring for completed medals, encryption in the spreadsheet to lock cells, correct formulas to calculate weird medals like difficulties and the three for gametypes/starting weapons which automatically update, and reformatting and corrections.

I wish I hadn't done so much work over the past couple of days to do all that now.

One suggestion: I understand putting different categories on different worksheets, but it really helps from a usability standpoint to put every medal on one worksheet so they can all be seen at the same time on the same screen. This can give the user a much better view of where they stand with just a single look.
gcwright90 is offline   Reply With Quote
Old 10-08-2011, 07:24 PM   #13
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
gcwright90, I understand what you mean about putting everything on one sheet. I was going to do that when creating this but it just became so over cluttered to me. Thats why i created the very first tab combining everything to show you your overall completion.
Another reason i divided them up was in hopes to keep everything viewable on the screen instead of having to scoll up/down and left/right.
__________________
Celick is offline   Reply With Quote
Old 10-08-2011, 07:46 PM   #14
hockbird 69
 
hockbird 69's Avatar
 
Join Date: Jun 2010
Posts: 220

xLoneWanderer77's Gamercard
Great sheet. Seeing your total completion just makes you want to work that much harder to get it to 100%
__________________


Moon Achievement Guide And Road Map Here
hockbird 69 is offline   Reply With Quote
Old 10-08-2011, 08:03 PM   #15
MediumMelanin
 
MediumMelanin's Avatar
 
Join Date: Sep 2008
Location: The United Kingdom of Great Britain and Northern Ireland
Posts: 3,530

A Small Breeze's Gamercard

Awards Showcase 2,500 Posts
Total Awards: 1 (more» ...)
This actual looks a bit better than "Ctrl Alt Defeats"...now which one should I check out? I guess I'll give yours a whirl.
__________________

pixels
MediumMelanin is offline   Reply With Quote
Old 10-08-2011, 08:33 PM   #16
IceBlox
 
IceBlox's Avatar
 
Join Date: Oct 2008
Location: Virginia
Posts: 479

IceBlox's Gamercard
nice job, looks really good
__________________
IceBlox is offline   Reply With Quote
Old 10-08-2011, 09:17 PM   #17
mjc0961
 
Join Date: Oct 2007
Location: USA (GMT -5)
Posts: 2,101

mjc0961's Gamercard

Awards Showcase 1,000 Posts   Submit - Gold   Arcade Crazy - Bronze
Total Awards: 3 (more» ...)
Quote:
Originally Posted by Celick View Post
I'll see what i can do, have never done that before. But i will give it a try.
Edit...
Mjc, i tried doing what you asked but putting the sheet in a google friendly share causes the sheet to not work properly...Sorry I can't help.
Rats.

Thanks for trying though.
__________________


Quote:
Originally Posted by ViolentCabaret View Post
This guide continues to warm my heart and piss off my roommates. Thanks so much!
mjc0961 is offline   Reply With Quote
Old 10-08-2011, 10:21 PM   #18
Nevander
 
Join Date: Nov 2007
Posts: 6,987

Awards Showcase Submit - Bronze   Referrals - Bronze   Road Map - Silver   Achievement Guide - Silver   5,000 Posts
Total Awards: 5 (more» ...)
Dude this spreadsheet is amazing, you've got my props.

How do you do some of the stuff in there? Like the encrypting and the drop down menus? It's crazy! I've never known you can do stuff like that, can you do things like that with 2002 (that's what I've got)? I know 2010 adds a lot of cool stuff. I plan on upgrading to Windows 7 and Office 2010 sometime, but I don't know when.

My school can sell me Office 2010 Pro for $104 bucks.
__________________
I have moved to PC gaming, so I
won't be on Xbox LIVE anymore.
Nevander is offline   Reply With Quote
Old 10-08-2011, 10:54 PM   #19
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by Nevander View Post
Dude this spreadsheet is amazing, you've got my props.

How do you do some of the stuff in there? Like the encrypting and the drop down menus? It's crazy! I've never known you can do stuff like that, can you do things like that with 2002 (that's what I've got)? I know 2010 adds a lot of cool stuff. I plan on upgrading to Windows 7 and Office 2010 sometime, but I don't know when.

My school can sell me Office 2010 Pro for $104 bucks.
Thanks man, i'm glad you like it...
And yes i believe you can do alot of what i've done in excel 2002. It's just in a completely differnt format of how to get to the tools. I've only really used 2007 and 2010 in things like this...but look for the option Data Validation. That's what i used in limiting the values and creating the drop boxes.
__________________
Celick is offline   Reply With Quote
Old 10-09-2011, 01:54 AM   #20
KingPastry
 
Join Date: Oct 2008
Posts: 111

KingDaynish's Gamercard
very nice little spreadsheet.. nice to have an actual number to correspond to your progress instead of so many medals out of 65
__________________
Looking to Boost:
Forza 2
Gears of War
Gears of War 3
Grand Theft Auto IV
Halo: ODST
James Bond 007: Quantom Of Solace

Let me know and i'll be happy to help you get what you need too

KingPastry is offline   Reply With Quote
Old 10-09-2011, 02:02 AM   #21
Ctrl Alt Defeat
 
Ctrl Alt Defeat's Avatar
 
Join Date: Jun 2011
Location: P2 on Midship
Posts: 383

CtrI Alt Defeat's Gamercard
Yours beats mine. =[
__________________
GT: CtrI Alt Defeat

Thanks to the man Slaughter for the godlike sig!
11.11.14. Halo 2.
Ctrl Alt Defeat is online now   Reply With Quote
Old 10-09-2011, 05:48 AM   #22
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by Ctrl Alt Defeat View Post
Yours beats mine. =[
Wasn't trying to out do anyone.
I had spent so much time on it, i just wanted to share it.
__________________
Celick is offline   Reply With Quote
Old 10-09-2011, 06:53 AM   #23
Ctrl Alt Defeat
 
Ctrl Alt Defeat's Avatar
 
Join Date: Jun 2011
Location: P2 on Midship
Posts: 383

CtrI Alt Defeat's Gamercard
Quote:
Originally Posted by Celick View Post
Wasn't trying to out do anyone.
I had spent so much time on it, i just wanted to share it.
Very understandable.

I spent a good bit on mine to, not enough obviously since there were a few errors.

But great minds think alike and we had the same idea.
__________________
GT: CtrI Alt Defeat

Thanks to the man Slaughter for the godlike sig!
11.11.14. Halo 2.
Ctrl Alt Defeat is online now   Reply With Quote
Old 10-09-2011, 01:41 PM   #24
xI WARFARE
 
xI WARFARE's Avatar
 
Join Date: Mar 2010
Location: S.E England
Posts: 879

John Rycroft's Gamercard
I'm fine with Crt alt Defeat's one.
__________________

SSFIV - From C to shining C achievement unlocked!
xI WARFARE is offline   Reply With Quote
Old 10-09-2011, 03:07 PM   #25
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by Ctrl Alt Defeat View Post
But great minds think alike and we had the same idea.
That they do

Quote:
Originally Posted by xI WARFARE
I'm fine with Crt alt Defeat's one.
It's your choice to use the one you want...that's one of the reasons why i added a link to CtrI Alt Defeat's thread in my OP.
__________________
Celick is offline   Reply With Quote
Old 10-09-2011, 03:55 PM   #26
Delta438
 
Delta438's Avatar
 
Join Date: Apr 2008
Location: Singapore
Posts: 534

Delta748's Gamercard
Quote:
Originally Posted by Ctrl Alt Defeat View Post
Very understandable.

I spent a good bit on mine to, not enough obviously since there were a few errors.

But great minds think alike and we had the same idea.
Obsession with Ariana Grande, I see.
__________________


Delta438 is offline   Reply With Quote
Old 10-09-2011, 07:28 PM   #27
Klister NL
 
Klister NL's Avatar
 
Join Date: Jan 2008
Location: Arnhem, Netherlands
Posts: 192

Klister NL's Gamercard
This looks alot better than the one I made myself!

Is there any way I could get my hands on the password that is protecting the sheet? I would like to make some minor adjustments for my personal preferences. I had put all the other stats like mutators, executions, character and weaponskins unlocks in mine and I'd like to merge that with this one to have one complete thing
__________________


Klister NL is offline   Reply With Quote
Old 10-09-2011, 08:37 PM   #28
xhunterrrr
 
xhunterrrr's Avatar
 
Join Date: Apr 2009
Location: Maine
Posts: 9,086

Hunter XBA's Gamercard

Awards Showcase XBA Representer   Road Map - Bronze   Achievement Guide - Bronze   5,000 Posts   x360a Representer
Total Awards: 5 (more» ...)
Very cool! Too bad I have to use Excel. It won't open properly in Numbers and I hate working in Excel. -.-
__________________
xhunterrrr is offline   Reply With Quote
Old 10-10-2011, 05:43 PM   #29
Celick
 
Join Date: Feb 2008
Posts: 226
Send a message via ICQ to Celick

Celick's Gamercard
Quote:
Originally Posted by xhunterrrr View Post
Very cool! Too bad I have to use Excel. It won't open properly in Numbers and I hate working in Excel. -.-
Thanks...Excel isn't so bad though. I made the sheet so there's no way you can mess it up. Just type in the number and save.
__________________
Celick is offline   Reply With Quote
Old 10-10-2011, 06:19 PM   #30
xhunterrrr
 
xhunterrrr's Avatar
 
Join Date: Apr 2009
Location: Maine
Posts: 9,086

Hunter XBA's Gamercard

Awards Showcase XBA Representer   Road Map - Bronze   Achievement Guide - Bronze   5,000 Posts   x360a Representer
Total Awards: 5 (more» ...)
Quote:
Originally Posted by Celick View Post
Thanks...Excel isn't so bad though. I made the sheet so there's no way you can mess it up. Just type in the number and save.
I much prefer Numbers since Microsoft Office is slow on Macs.
__________________
xhunterrrr is offline   Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off



All times are GMT. The time now is 07:10 AM.