HALO 5 REQS Checklist/stats on Excel Spreadsheet

Hey All

Being a bit of an Excel Geek I have put some of my spare time into creating a checklist of all the collectable REQS and linking them up with stats tables so you can see how your collection is coming along!

It’s a bit of a WIP but just wondered if anyone would be interested in anything of the sort!

NOV UPDATE:

Hi all updated file can be found here, includes stats on how many reqs you can get from each sort of pack and November additions.

Enjoy all, and spread the word :wink:

https://dl.dropboxusercontent.com/u/64163430/Halo.xlsm

DEC UPDATE:

Hi All,

The latest updated file is here, has been a real pain in the **** to do this one with a lot of REQs changing rarity levels for some reason (Bayonets apparently are worthy of legendary rarity…) so if you could share this and make this post more popular it would be much appreciated :slight_smile:

If I’ve made any errors please feel free to correct them yourself or let me know on here

LINK IS THE SAME AS PREVIOUSLY

https://dl.dropboxusercontent.com/u/64163430/Halo.xlsm

Enjoy

This is amazing! If you get a completed database of everything by type/rarity - can I has?

This is great, would love this so much

That will take forever to do. But the cool thing is that if its done right you can literally find anything and sort it in any way. All the way from the type of item (weapons, armors, etc.) down to a specific name.

One word…

Neat.

> 2533274867820483;2:
> If you get a completed database of everything by type/rarity - can I has?

If you ever did, I’d like to get a copy of that too. Would help me out to determine all the REQs I have and don’t have

I actually just created something similar to this! Here, I put it in a forum post of my own.
https://www.halowaypoint.com/en-us/forums/6e35355aecdf4fd0acdaee3cc4156fd4/topics/req-system-unlocking-everything/07f17492-8f78-4ad5-95f3-114ef857a7d4/posts?page=1

I would love something like that
I wanna know wich weapons are common, so i can stop buying bronze packs

It’s all been done, with a seperate list for Customization, Loadout and Power Weapons/Vehicles.

There maybe a couple of spelling errors etc, I don’t claim to be perfect!

Where would be the best place to host the file for you guys? I’ll try my public dropbox later :slight_smile:

And yes it splits everything out by rarity and then fills in tables in the front end
http://postimg.org/image/iwtnit6th/

> 2533274867300978;4:
> That will take forever to do. But the cool thing is that if its done right you can literally find anything and sort it in any way. All the way from the type of item (weapons, armors, etc.) down to a specific name.

Currently it’s sorted by rarity and type of REQ, but yes It did take ages copying all the names across!

When I post the file later tonight please feel free to make suggestions or improve upon it. I’m sure all sorts could be done with lookup tables, graphs etc…

The excel file is ready to go! Just check off your REQs and see the stats :slight_smile:

Obviously you’ll have to add more REQs manually when 343 release more content however haha

Spreadsheet can be downloaded here: https://dl.dropboxusercontent.com/u/64163430/Halo.xlsm

Sweet man you are awesome, but are you going to update it when new things come out, because as of the new community updates some new stuff is coming out in a few weeks.

> 2533274850488681;12:
> Sweet man you are awesome, but are you going to update it when new things come out, because as of the new community updates some new stuff is coming out in a few weeks.

Sure I will if enough people like it :slight_smile:

just letting you know a few of the ckeckboxes are misaligned having boxes by the rarity and not the last one of that strip

> 2533274850488681;14:
> just letting you know a few of the ckeckboxes are misaligned having boxes by the rarity and not the last one of that strip

Will have a look at that, think its only when they are minimised

might also be because I’m using open office instead of microsoft office

Sorry for all the posts, but yes that was the issue it was the program i was using

So just curious are you going to update this everytime there is a new update with reqs?

I have updated It.

Just thought this thread had died so didn’t bother uploading it haha.

Will put the link up when I get home this evening :slight_smile:

I’ll probably end up using this as well so it’d be awesome if you would continue to add as they do or if needed we can always help.