Products

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'
                    ]
                },
            ]
        }
    ]
}