TLI Worklog Calculator! Auto-generate your work logs.

Useful items for all visitors - virus warnings, firewalls, IRC scripts etc

Moderators: Ehlanna, Twerlinger

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Sat Feb 02, 2019 7:13 am

CALCULATOR UPDATE

Updated Calculator to version 1.2

The following has been fixed:
  • The "total mhl earned" cells would show 50mhl per master rank skill, even if no work was done for that month. This has now been fixed and will display 0mhl if no times are placed in the first "!time on start" column.

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Tue Feb 12, 2019 3:33 pm

CALCULATOR UPDATE

Updated Calculator to version 1.3

The following has been changed:
  • Fixed an error that would award more mhl to Assistant Managers and Managers.
  • Added protection to the sheet, so that only cells you're supposed to be able to select or change can be selected or changed. This is to help prevent errors caused by accidental deletion of "formula" cells. There's a lot of them.

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Fri Mar 01, 2019 6:56 pm

CALCULATOR UPDATE

Updated Calculator to version 1.3.1

The following has been fixed or added
  • Sometimes calculator wouldn't award Master rank skills properly in the forum output cell, this has been fixed.
  • Added calculator version number to forum output cell.

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Tue Mar 12, 2019 11:47 am

CALCULATOR UPDATE

Updated Calculator to version 1.3.2

The following has been fixed:
  • There was some issues with how the end times were being displayed in the forum output. This has now been fixed.
  • There was a slight issue with the secondary and tertiary trackers in that they sometimes used the wrong base mhl/hr. This has now been fixed to properly use 20mhl/hr unless SS, REB, IG or ISA is selected.

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Sun Apr 28, 2019 11:11 pm

CALCULATOR UPDATE

Updated Calculator to version 1.3.3

The following has been fixed:
    V 1.3.3
  • There was an issue with the calculator not reading the correct month, this has now been fixed.
  • Added a cell to display the current month of the worklog to make troubleshooting easier.
(Thanks to Saphamira for letting me know about this one)

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Re: TLI Worklog Calculator! Auto-generate your work logs.

Postby Amethine on Wed May 01, 2019 5:03 am

CALCULATOR UPDATE

Updated Calculator to version 1.3.4

The following has been added:
  • Added Dethsiris as a place of employment.

The title post has been updated with the new calculator version ready for downloading. If you copy over the times from the old sheet, please right-click and paste as values, as pasting normally tends to keep the formatting and that'll make things look ugly.

If there are any problems lemme know!

-Amethine
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!
Image

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
User avatar
Amethine
Expert
Expert
 
Posts: 154
Joined: Fri Apr 20, 2018 5:40 pm

Previous

Return to Public Service

Who is online

Users browsing this forum: No registered users and 1 guest


cron