Sign in to follow this  
Followers 0
freespace2dotcom

The Academagia Gradebook (Year 1)

170 posts in this topic

You wouldn't happen to still have the file would you? Unfortunately it's no longer up on the host site.

Share this post


Link to post
Share on other sites

Do you mind telling what was fixed so I can fix it in my adjusted sheet for LibreOffice?

Share this post


Link to post
Share on other sites

Nothing Major. Just something from here that was so minor that it wasn't worth posting about.

 

http://academagia.invisionzone.com/index.php?showtopic=2790&p=37340

Found a bug in the version I'm using:
In Music the player's pass or fail is according to the one of Alan and not the player.
Sorry if that was a problem of the port or is already fixed.

 

At least I think it's that. I've held on to 1.72 for so Long I don't remember. It's minor minor stuff that you shouldn't have to worry about.

Share this post


Link to post
Share on other sites

This is minor, but is there any reasoning behind the overall ranking system being in alphabetical order based off of the college?

 

As in, if an Avila student and a Vernin student are tied in final score, the Avila student gets the higher rank. I was just wondering if this was something you did based off personal sorting preference, of if this is something the game actually takes into account.

 

Great tool though. I like looking at how all the pieces work together.

Share this post


Link to post
Share on other sites

Grrr. Somebody found a bug that I am not likely capable of fixing. It's because of the way Excel sorts things.

 

To be quite honest, the exact way the game works is unknown to us, and this spreadsheet represents a 'Best Guess', Ties in practice shouldn't happen all that often. As future years come out, ties should become less common and this sort of thing should be less noticeable in the future.

 

It wouldn't surprise me too much if in setting that ties might not be formally recognized. There might be a need for a strict ranking, though this might just be my great hope. In any case, we're not going to see any changes in this sheet until the Team either tells us exactly how the game processes this info, or else Y2 is released and we can infer from that how certain calculations are done.

Share this post


Link to post
Share on other sites

Haha no worries. The only reason I pointed it out is because I am indignant at being placed #2 in the ranks due to being in Vernin ;)

 

But yeah, even game mechanics notwithstanding, it is hard thinking of how to handle ties. Ideally you'd be able to reference the respective class GPA rather than the Honors system, but I know that'd be a nightmare in itself to make a Boolean that accounts for all that. I am very curious now to see how Y2 will account for all this too! I would hope they take test scores into account rather than solely rely on Honors scores.

Share this post


Link to post
Share on other sites

I did want to make the numerical grade count in the calculations for the overall sheet, but due to the Curve in some classes, it would render the overall sheet more inaccurate than the current system. And the NIGHTMARE you mentioned indeed makes it not worth fooling with.

 

I'm not against tweaking the sheet to allow ties, but only when we have more information on how the game calculates things. Legate, that's your cue.... ;)

Share this post


Link to post
Share on other sites

I've just used the Grade-book on google sheets and found a little detail, in botany class I'm in second place yet the three students behind me either have a higher score or tie with me. It this because I only have Mid-term grades?

 

 

 

https://ibb.co/bvWbWQ

Share this post


Link to post
Share on other sites

Thank you for reporting that.

 

That was due to a weighting error on the player character's score. Basically I had failed to change the player's grade calcs from 20% in mids and 80% in finals, to 13% in mids and 87% in finals.

 

If you would have put in finals you'd have found that your ranking would have been lower than it should have been. :(

 

Thankfully, after scouring the page, I found the bug.

 

Here's V1.73 with the corrected calculations for botany.

 

http://s000.tinyupload.com/?file_id=82413846449222070933

Share this post


Link to post
Share on other sites

Thank you for reporting that.

 

That was due to a weighting error on the player character's score. Basically I had failed to change the player's grade calcs from 20% in mids and 80% in finals, to 13% in mids and 87% in finals.

 

If you would have put in finals you'd have found that your ranking would have been lower than it should have been. :(

 

Thankfully, after scouring the page, I found the bug.

 

Here's V1.73 with the corrected calculations for botany.

 

http://s000.tinyupload.com/?file_id=82413846449222070933

 

It works now, thanks!

Share this post


Link to post
Share on other sites

no problem, I feel kind of sheepish that that error managed to get overlooked for so long.

 

Well, It's fixed now. Have fun calculating your grades! :)

Share this post


Link to post
Share on other sites

Does this need updating due to the DLC 1?

Edited to say:

Does this need updating due to the DLC 17?

Share this post


Link to post
Share on other sites

I presume you meant DLC 17, in which case, no, nothing was changed that would necessitate an update. As far as I know.

Share this post


Link to post
Share on other sites

Unlike DLC 16 which added 4 new students, there is nothing in DLC 17 which upset the gradebook. If there was, I'd update it.

Share this post


Link to post
Share on other sites

A new development. Since the forums now allow for the attachment of files directly to the forums, I've replaced the download link on the opening post of this thread with a link hosted by the forum itself.

So with a little luck, we'll never have a case where the link goes dead due to inactivity again!

Share this post


Link to post
Share on other sites

And now no one can download it because no one (or at least I <_<) have permission to download files attached to posts. Progress :rolleyes:!

Share this post


Link to post
Share on other sites

I have to agree with Metis. I get this error when try to download:

Sorry, there is a problem

The page you are trying to access is not available for your account.

Error code: 2C171/1

Share this post


Link to post
Share on other sites

... Seriously?

Go figure.

Legaaaaaate, someone needs to yell at the forum people! ...Again!

Until then, I still have the old download link here, and will put it back on the main post temporarily.

http://s000.tinyupload.com/?file_id=82413846449222070933

 

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0