image: img/spreadsheet-templates-employee-training.jpg folder: human-resources-and-legal category: template
const config = {
tabs: true,
toolbar: true,
worksheets: [
{
worksheetName: 'Watched Course',
columns: [
{
type: 'record',
title: 'Employee',
worksheetId: 'employees',
width: '200px'
},
{
type: 'record',
title: 'Course',
worksheetId: 'courses',
width: '300px'
},
{
type: 'progressbar',
title: 'Progress',
}
],
data: [
[
'1',
'5',
'15'
],
[
'2',
'2',
'90'
],
[
'4',
'1',
'70'
],
[
'6',
'3',
'20'
],
[
'5',
'4',
'40'
],
[
'1',
'2',
'10'
],
[
'3',
'2',
'30'
],
]
},
{
worksheetName: 'Employee',
worksheetId: 'employees',
columns: [{
type: 'text',
title: 'Name',
width: '200px'
},
{
type: 'calendar',
title: 'Hiring date',
width: '200px'
},
{
type: 'dropdown',
title: 'Role',
width: '200px',
source: ['Seller', 'Supervisor', 'Manager', 'Digital Marketing'],
options: {
newOptions: true
}
},
],
data: [
{
id: 1,
data: [
'Loma Bechtelar',
'2015-02-12',
'Manager'
]
},
{
id: 2,
data: [
'Orion Runte',
'2017-05-21',
'Supervisor'
]
},
{
id: 3,
data: [
'Brendan Wuckert',
'2018-04-30',
'Seller'
]
},
{
id: 4,
data: [
'Deshawn Dach',
'2018-05-09',
'Seller'
]
},
{
id: 5,
data: [
'Duncan Morar',
'2018-07-01',
'Digital Marketing'
]
},
{
id: 6,
data: [
'Danika Price',
'2018-07-29',
'Seller'
]
},
]
},
{
worksheetName: 'Courses',
worksheetId: 'courses',
columns: [
{
type: 'text',
title: 'Name',
width: '200px'
},
{
type: 'notes',
title: 'Description',
width: '400px'
},
{
type: 'text',
title: 'Hours',
width: '100px'
}
],
data: [
{
id: 1,
data: [
'Customer Service',
'How to deal with customers, from the friendliest to the most difficult',
'6'
]
},
{
id: 2,
data: [
'People Management',
'Harness the full potential of each of your employees',
'9'
]
},
{
id: 3,
data: [
'Sales Techniques',
'Show your customers that they need your products',
'8'
]
},
{
id: 4,
data: [
'Social Media Marketing',
'Reach more people and make them much more interested',
'5'
]
},
{
id: 5,
data: [
'Interpersonal Relationships at Work',
'Learn to maintain a more comfortable working environment',
'11'
]
},
]
}
]
}