Spreadsheet: 733837d1621852679-filtering-with-merged-cells-whilst-displaying-all-data-210524_db_dummy-database
Sheet: PVT

 |  |  |  |  |  |  |  |  |  |  | Values
Video name | Category | Country | Language | Subtitles | Industry | Function | Use Case | Description | Link | Notes | Sum of # | Sum of Video quality out of 5
[NAME] | Lets dance | Finland | English | Danish | Legal Services | Communication | Internal Communication | [NAME] joined the sales staff at Dunder [NAME] after spending time at the Stamford Branch before it was closed due to downsizing. [NAME] had a short stint as manager of [NAME] but for most of the series he acts as a salesman who also makes some mistakes in understanding sales and markets. This also can provide teaching moments which are captured in some of the videos. The best example of this is when he sells his used car at a price well below equilibrium to Dwight. | (blank) | (blank) | 9 | 5
 |  |  |  | Dutch | Consulting | Training | Training | (blank) | (blank) | (blank) |  | 5
 |  |  |  | English | Consulting | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Finnish | Consulting | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | German | Consulting | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Norwegian | Consulting | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Swedish | Consulting | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
[NAME] | Multiple oranges | Finland | Finnish | Danish | Municipality | Education | External Communication | [NAME] is one of the lead accountants in The Office who has a tremendous affection for cats and tends to be a bit judgmental. Her no nonsense approach to how things should be done in the office appeals to Dwight. In one of the clips, she informs [NAME] he has met his commission cap which discourages [NAME] from pursuing additional sales. | (blank) | (blank) | 8 | 5
 |  |  |  | Dutch | Municipality | Training | Instructions | (blank) | (blank) | (blank) |  | 5
 |  |  |  | English | Municipality | (blank) | Screen Recording | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Finnish | Municipality | (blank) | Training | (blank) | (blank) | (blank) |  | 5
 |  |  |  | German | Municipality | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Norwegian | Municipality | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  | Swedish | Municipality | (blank) | (blank) | (blank) | (blank) | (blank) |  | 5
Dwight | Multiple oranges | Denmark | English | English | Municipality | Communication | Citizen Communication | Dwight is unofficially the assistant (to the) regional manager at Dunder Mifflin. Dwight is extremely passionate about paper and is constantly trying to impress [NAME]. [NAME] is also the leading salesman in the Scranton office. While Dwight displays many characteristics which lack social graces, he has a very good understanding of many economic concepts. In several of the clips on this site, he has a better understanding of arbitrage opportunities and gains from trade than most of the other characters on the program. | (blank) | (blank) | 2 | 4
 |  |  |  | Finnish | Municipality | Training | Citizen Services | (blank) | (blank) | (blank) |  | 4
 |  |  |  | (blank) | Municipality | (blank) | Recruitment | (blank) | (blank) | (blank) |  | 4
 |  |  |  |  |  |  | Training | (blank) | (blank) | (blank) |  | 4
[NAME] | Sensational | Finland | Finnish | English | Education | Communication | Student Communication | [NAME] is also in sales and is considered to be one of the "heroes" of the show because of his laid back attitude and ability to get along with people. During the course of the series, [NAME] and subsequently becomes quite motivated to succeed as a paper salesman. There are many instances in The Office where [NAME] spends very little time attempting to increase his paper sales instead spending considerable time trying to win the affections of Pam. [NAME] also spends an inordinate amount of time playing tricks on [NAME] or entertaining his co-workers which he primarily does to entertain [NAME]. | (blank) | (blank) | 3 | 3
 |  |  |  | Finnish | Education | Training | External Communication | (blank) | (blank) | (blank) |  | 3
 |  |  |  | (blank) | Education | Marketing | Internal Communication | (blank) | (blank) | (blank) |  | 3
 |  |  |  |  |  | (blank) | Training | (blank) | (blank) | (blank) |  | 3
[NAME] | Multiple oranges | Finland | Finnish | Danish | Education | Education | Instructions | [NAME] is the third accountant in the office and he is less adept at accounting than one might expect. [NAME] was given his job by [NAME] despite being under qualified and that helps to explain why he occasionally becomes confused about fairly simple concepts. Again, [NAME]’s confusion and lack of understanding provides some teaching moments that are captured in some of the videos. | (blank) | (blank) | 7 | 4
 |  |  |  | Dutch | Education | Training | Screen Recording | (blank) | (blank) | (blank) |  | 4
 |  |  |  | English | Education | (blank) | Student Communication | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Finnish | Education | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
 |  |  |  | German | Education | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Norwegian | Education | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Swedish | Education | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
[NAME] | Multiple oranges | Denmark | Danish | Danish | (blank) | (blank) | (blank) | (blank) | (blank) | (blank) | 1 | 4
[NAME] | [NAME] | Sweden | English | English | Consulting | Communication | External Communication | [NAME] is the other lead accountant in the office. [NAME] is very practical and has a good ability to explain to [NAME] the type of basic economics and accounting that [NAME] should already be aware of. [NAME] and [NAME] frequently disagree about what is acceptable office behavior | (blank) | (blank) | 5 | 4
 |  |  |  | Finnish | Pharmaceutical | Training | Internal Communication | (blank) | (blank) | (blank) |  | 4
 |  |  |  | (blank) | Pharmaceutical | (blank) | Leadership Communication | (blank) | (blank) | (blank) |  | 4
 |  |  |  |  |  |  | Recruitment | (blank) | (blank) | (blank) |  | 4
Pam | Magnificient | Finland | English | English | Manufacturing | Aftersales | Customer Communication | Pam is the secretary at Dunder Mifflin and tries to keep [NAME] somewhat focused on work and being productive. Pam is unaware of [NAME]'s romantic interest in her during the early seasons of the show. Pam eventually becomes the office manager who demonstrates an understanding of budgets and cost constraints. | (blank) | (blank) | 4 | 5
 |  |  |  | Finnish | Manufacturing | Communication | External Communication | (blank) | (blank) | (blank) |  | 5
 |  |  |  | (blank) | Manufacturing | Marketing | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  |  |  | Sales | (blank) | (blank) | (blank) | (blank) |  | 5
 |  |  |  |  |  | Support | (blank) | (blank) | (blank) | (blank) |  | 5
[NAME] | Sensational | Finland | English | English | Food Industry | Communication | Internal Communication | [NAME] is a temporary employee in season one but eventually gets promoted to be [NAME]’s supervisor at Dunder [NAME]. It is later discovered that he was misleading [NAME] shareholders and is fired from his position. [NAME] later re-hires [NAME] as a temp. While [NAME] was still a temp (prior to his promotion) he has [NAME] speak to his MBA class where [NAME] displays an alarming lack of understanding of economics. | (blank) | (blank) | 6 | 4
 |  |  |  | Finnish | Food Industry | Training | [NAME] | (blank) | (blank) | (blank) |  | 4
 |  |  |  | (blank) | Food Industry | (blank) | Onboarding | (blank) | (blank) | (blank) |  | 4
 |  |  |  |  |  |  | Reach Employees | (blank) | (blank) | (blank) |  | 4
 |  |  |  |  |  |  | Training | (blank) | (blank) | (blank) |  | 4
Stanley | Insincere | Sweden | English | Danish | Energy | None | Instructions | Stanley is a fairly successful salesman who resents spending time in an office where he typically is not productive. Stanley tolerates [NAME]'s long and typically pointless conference room meetings by spending his time completing crossword puzzles. | (blank) | (blank) | 10 | 4
 |  |  |  | Dutch | Food Industry | (blank) | Internal Communication | (blank) | (blank) | (blank) |  | 4
 |  |  |  | English | Machinery | (blank) | Leadership Communication | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Finnish | Machinery | (blank) | Training | (blank) | (blank) | (blank) |  | 4
 |  |  |  | German | Machinery | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Norwegian | Machinery | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
 |  |  |  | Swedish | Machinery | (blank) | (blank) | (blank) | (blank) | (blank) |  | 4
Grand Total |  |  |  |  |  |  |  |  |  |  | 55 | 219