• State Suggested Answer
  • Replies 7 replies
  • Answers 1 answer
  • Subscribers 432 subscribers
  • Views 4807 views
  • Users 0 members are here
Options
Related

Analyzing multiple projects at once

Paola

Hello, I have to compile a monthly report of my last 2 years of work (words translated, words proofread by month). My work is done 90% in Studio, so it would be awesome if I could use it for this task.

Usually, I just select multiple projects in the Project page and I get the total wordcount. However, every time that an Update is installed (about every 3 months) I lose all the projects in the Project page.

So, what I'd like to do is to load all of my Studio projects (*.sdlproj) I did in 2016 and in 2017. I tried to simply drag and drop the many *.sdlproj files but the application crashed. Is there a tool to do this?

Thank you in advance!
Rate translation
×
Suggest better translation
×
Moderator UI
×
  • Get AI Suggestion
Parents Reply Children
  • 0 in reply to Simon Cole

    @Simon Cole (SimonCole) I simply count the number of folder-projects for a Client in the last two years. Besides, I also put the date in my folder in the YYYY_MM_DD format, so I simply sort the folder by name, select all the folders from 2015_ to 2017_ and in the status bar it says '665 folders selected'.

    E.g. Client X is an agency specialized in Videogames, I do 98% Videogame-related projects for this client. 90% of projects are done in Studio, whereas some are done directly in Word (small updates)

    My folder structure is Client X > 2015_01_01 - project12345 I select 2015_ to 2017_ and I know how many project I did for Client X in the last 2 yrs.

    What I did was apply two filters to my Client X folder: look for .sdlproj and that contains 2015_ or 2016_ or 2017_ in the folder name, so I have about 600 .sdlproj files for Client X in the last 2 yrs (projects done in Studio) of 665 projects (all projects for Client X).

     

    >> As a separate question, if you don't have such a list, how do you know how much to invoice every month?

    l am using an accounting software called Billings Pro which is very popular among Mac freelancers. When a client commissions a job, I create a project and insert the relevant word count. At the end of the month I invoice the client (some clients want an invoice per project - bummer!). When I receive the payment I add it to Billings Pro.

     

    However... There is one client whose POs just read a weighted word count, so that it reads 1.111,43 words  - New words weight 100%, fuzzy weights less, reps weights 50%. It is very practical to file these POs in my accounting systems.

    Whereas other clients' POs are made of 6 lines (New words / 95-99% matches / 85-95% matches / ...) and so it would take too much time to enter 6 tasks for each project. I just insert a translation task 1 x total.

     

    With Billings Pro I can generate reports, but they are of course financial reports, such as how much I have invoiced per month by Client, etc. It is possible to create custom-made report but you need programming skills  I don't have, so I am stuck with their standard reports (which are fine for my usual needs).