Re: Relative Research Costs DB V1.2
 

Nice tool, thanks!

Is there anyway I can sort the results according to cost of RP?

Re: Relative Research Costs DB V1.2
 

Not in this version yet. I expect his next version will just have one header row, like Dom3 DB, and at that point it will be sortable.

Re: Relative Research Costs DB V1.2
 

Unfortunately the data can't really be sorted at the moment, as I ran out of time while trying to work out how best to do it. You can sort the data manually by unprotecting the sheet (there's no password), locking all the cells, selecting all bar the top two rows, and then sorting by the header (Nation, Unit etc.).

My next task will be to arrange the data so that it can be sorted properly without any fuss. Although between now and then I will need to brush up on my MS Excel skills, since they've decayed severely over the years due to non-use. I don't use Excel (or any like programs) on any sort of regular basis, and haven't had to produce anything to 'presentable' levels since my uni days over 10 years ago. Hate it when I lose skills I used to have :mad:

Hope to have some time to work on it next Saturday (the only day that I even have a chance of having free). Please keep the comments and suggestion coming in. They have all been absorbed and warmly appreciated so far :)

Re: Relative Research Costs DB V1.2
 

You can sort the data. Just "HIDE" the top 3 rows, highlight the entire chart, click on "data", "sort" and choose the column you want to sort by.