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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Amethine on Fri May 31, 2019 9:49 pm

CALCULATOR UPDATE

Updated Calculator to version 1.3.5

The following has been fixed:
    V 1.3.5
  • Fixed the calculator not properly adding in skills for second and third jobs.
    (Thanks to Saphamira for letting me know about this one)
  • Tweaked how the calculator displays the current month, now you don't have to have the first cell of the first job filled in to see the current month.


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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Makatza on Mon Apr 13, 2020 1:18 am

Gaea's guzzler needs to be added or we can use Lonely Inn

Also is there anyway to change the tabs for multiple characters with jobs to all stay in the same database? in Openoffice.

My usual ways of changing the name aren't working.
User avatar
Makatza
Novice
Novice
 
Posts: 11
Joined: Sun Jun 15, 2014 11:46 pm

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

Postby Amethine on Fri May 01, 2020 6:22 pm

Makatza wrote:Gaea's guzzler needs to be added or we can use Lonely Inn

Also is there anyway to change the tabs for multiple characters with jobs to all stay in the same database? in Openoffice.

My usual ways of changing the name aren't working.


Missed Gaea's Guzzler, I'll add it now!

If you mean you want to have multiple characters on the one spreadsheet I'm afraid that's not currently possible. The idea behind this spreadsheet is to save a different version for each character. So Amethine.xlsx, Felicia.xlsx etc. and have them all be separate like that.

What is your usual way of changing the name? Are you unable to alter the contents of cell C2?
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Amethine on Fri May 01, 2020 6:36 pm

CALCULATOR UPDATE

Updated Calculator to version 1.4

The following has been changed:
    V 1.4
  • Fixed the post creation formula's messing up occasionally in the 2nd and 3rd jobs.
  • Added Gaea's Guzzler to the employer list.
    (Thanks to Makatza for letting me know about this one)
  • Added the version number to the sheet itself.


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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Joshua_Jericho on Fri May 01, 2020 7:49 pm

Sorry Cookiecat, I would have mentioned this sooner if I saw you were doing a new version..

Couple of typos in the skills - we currently have Naigation and Relifious Ceremony..! :P

JJ
Since I can't figure out how to change display name...player of Catiline, Umber and Saphamira! Often around on IRC GMT evenings and weekends.
Joshua_Jericho
Expert
Expert
 
Posts: 176
Joined: Mon Jun 07, 2010 10:37 pm

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

Postby Amethine on Fri May 01, 2020 9:53 pm

Joshua_Jericho wrote:Sorry Cookiecat, I would have mentioned this sooner if I saw you were doing a new version..

Couple of typos in the skills - we currently have Naigation and Relifious Ceremony..! :P

JJ


Ah bugger! There's always something isn't there? I'll make a 1.4.1 version soon once I get back.
Amethine Tawariell is the main catgirl.
Felicia`Delacroix is the naughty catgirl.
All the catgirl's just wanna have fun!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Amethine on Fri May 01, 2020 11:44 pm

CALCULATOR UPDATE

Updated Calculator to version 1.4.1

The following has been changed:
    V 1.4.1
  • Fixed some typos in the skills list.
    (Thanks to Joshua_Jericho 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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
Joined: Fri Apr 20, 2018 5:40 pm

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

Postby Amethine on Sat May 02, 2020 10:53 am

CALCULATOR UPDATE

Updated Calculator to version 1.4.2, last one for now I promise!

The following has been changed:
    V 1.4.2
  • Managers and Assistant Managers now show correct number of hours to be calculated at normal pay if worked for more than 4 hours that month.

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!

If you like this wax-seal, I could make one for your too. PM or hit me up in IRC if you're interested :)
Thank you Abby for drawing the amazing pic I'm using as the avatar!
User avatar
Amethine
Predominate
Predominate
 
Posts: 253
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