• 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
  • 0
    A few ideas...
    How about going back through your invoices for the last 2 years? If they list projects by reference, number of words, rate and total by project, you would get the total words quite easily.
    Or 'load' projects back into Studio by month/quarter to make a note of your figures, then remove from the Studio list and add the next month/quarter. Maybe in smaller groups it will work without crashing. Your invoices or other records should tell you which projects to load. Maybe you file them by year/month, etc.
  • 0 in reply to Simon Cole

    I cannot load more than one project at time. I have 665 projects with just one client in the last 2 years. What a missed chance for Studio!

    I'll have to make an estimate based on the invoiced amounts
  • 0 in reply to Paola
    Hi.
    Of course I do not know your admin systems, but how do you know there were 665 projects in 2 years with one customer? If you have a list (Excel file?), does it include word counts for each job? If so, here is your data, you don't need Studio. As a separate question, if you don't have such a list, how do you know how much to invoice every month?
    I agree with your idea to base it on invoiced amounts. A list of invoiced monthly totals, each divided by the rate per word, will give you the word counts - Excel strikes again!
  • 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).
Reply
  • 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).
Children
No Data