Versions Compared

Old Version 4

changes.mady.by.user Former user

Saved on

compared with

New Version 5

changes.mady.by.user Former user

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

This report shows a calendar style view into suppliers' worked and non-worked days such as weekends and holidays for periods of up to 2 monthsthe ratings of the supplier workers.

Table of Contents

Report content

The report creates a line per internal and/or external supplier. There is one column per calendar day and the day is highlighted if not worked (holidays, weekends...).

Internal suppliers are listed only if attributed services and having an active login. External suppliers are only listed if having an active login.

The indication of total worked days and total hours in the period is taken from the details supplied in the planning pages of a supplier or workersupplier  user (worker) and the average of the ratings associated with  him/her.

Template

Screenshot of default template:

...

The end date selected when creating the report. The date is adjusted to the time zone you have configured.
Placeholder nameDescription
<#StartDate>The start date selected when creating the report. The date is adjusted to the time zone you have configured.
<#EndDate>
<#GeneratedDate>The date when the report was generated.
  
Date columnsThe Excel shows one column per day. The following placeholders are used for the titles of these columns.
<#DTY0>...<#DTY61>

The year of the calendar day. For example 2017, 2018, etc. "DTY0" is the title of the first day in the date range. "DTY1" the second, and so on.

<#DTM0>...<#DTM61>The month of the calendar day. For example 7, 11, etc. "DTM0" is the title of the first day in the date range. "DTM1" the second, and so on.
<#DTDM0>...<#DTDM61>

The day and month abbreviation of the calendar day.

For example "20 Feb", "24 Dec" etc. "DTDM0" is the title of the first day in the date range. "DTDM1" the second, and so on.
<#DAY0>...<#DAY61>The day name of the calendar day. For example "Monday", "Tuesday" etc. "DAY0" is the title of the first day in the date range. "DAY1" the second, and so on.

 

Data rows and placeholders

Each row in the report corresponds to a job document. In other words, all information of a specific invoice will be contained in one single rowsupplier user and the average of his/her) ratings.

The placeholders of the row must be placed within the Excel table range named "___Lines___" (3 leading and trailing underscore characters).  Click here for more details on table ranges.

...

Boolean true/false. True if the company is an external supplier. False if it is the platformThe client company The timezone code of the companyThe timezone offset in minutes from UTC. For example: 60, 120, -360..TZOffset>The city
Placeholder nameDescription
Company detailsThe supplier's companySupplier DetailsDetails concerning the supplier .
<#Lines.IsExternal>SupplierCompanyName>Supplier's company (of internal workers).name
<#Lines.Id>The unique company ID (number).<#Lines.Company>SupplierUserName>Supplier user name.
<#Lines.Type>The project status title.
<#Lines.CountryCode>A three letter ISO country code.
<#Lines.Country>Country name.
<#Lines.TZ>SupplierUserEmail>Supplier user Email.
RatingsThe average of ratings for this supplier.
<#Lines.TZMin>Overall>Average ratings for "Overall" rating question.
<#Lines.The timezone offset in easy readable form. For example: UTC+1, UTC-10....
<#Lines.AccountingCode>The company accounting code
<#Lines.City>Quality> Average ratings for "Quality" rating question.
<#Lines.Efficiency>Average ratings for "Efficiency" rating question.
<#Lines.Code>The company code (a free text field that can be supplied in the company details page).
<#Lines.ContactEmail>The company contact email.
<#Lines.ContactPhone>The company contact phone.
<#Lines.State>The company state if supplied.
<#Lines.Zip>The company zip code if supplied.
<#Lines.CCF1> ... <#Lines.CCF20>Company custom fields 1 to 20. Each of your custom fields has a numeric ID. Finding Custom Field ID
  
Person detailsFilled in if the line refers to an internal worker. For external suppliers all person fields are empty.
<#Lines.PersonId>The unique internal ID of the person.
<#Lines.PersonFirstName>Person first name.
<#Lines.PersonLastName>Person last name.
<#Lines.PersonCode>Person code as supplied in the person details page.
<#Lines.PersonRole>The person's role in the company.
<#Lines.PersonEmail>Person email address.
<#Lines.PersonPhone>Person phone.
<#Lines.PersonTitle>Person title such as Mr. or Mrs.
<#Lines.PCF1> ... <#Lines.PCF20>Person custom fields 1 to 20. Each of your custom fields has a numeric ID. Finding Custom Field ID 
  
Date columnsPer each calendar date, a column is added to Excel. The columns are numbered 0 for the first date and up to 61 for the last date

<#Lines.EVT0>

<#Lines.EVT1>

...

<#Lines.EVT61>

Column Lines.EVT0 corresponds to the first date in the selected date range. Column #1 to the second date, up to column #61 to the last date. This allows to display up to 2 months.

The content of each cell is:

  • Empty: The day is worked
  • W: Stands for a regular non-worked week day of a supplier. This typically denotes the weekends.
  • C: The supplier office (company) is closed or the supplier is simply unavailable.
    • P: The worker is not available.Reliability>    		 Average ratings for "Reliability" rating question.
    <#Lines.Difficulty> Average ratings for "Difficulty" rating question.
    <#Lines.Teamwork>Average ratings for "Teamwork" rating question.
    <#Lines.Friendliness>Average ratings for "Friendliness" rating question.
    <#Lines.Challenge>Average ratings for "Challenge" rating question.
    <#Lines.PretranslationQuality>Average ratings for "PretranslationQuality" rating question.
    <#Lines.SourceTextQuality>Average ratings for "SourceTextQuality" rating question.
    <#Lines.TranslationQuality>Average ratings for "TranslationQuality" rating question.
    <#Lines.Communication>Average ratings for "Communication" rating question.
    <#Lines.InstructionsRespect>Average ratings for "InstructionsRespect" rating question.
    <#Lines.LinguisticAnalysis>Average ratings for "LinguisticAnalysis" rating question.
    <#Lines.Recruitment>Average ratings for "Recruitment" rating question.