{"id":1445,"date":"2023-12-10T16:29:58","date_gmt":"2023-12-10T14:29:58","guid":{"rendered":"https:\/\/gestsociety.com\/?post_type=tesserakb&#038;p=1445"},"modified":"2026-06-10T11:41:40","modified_gmt":"2026-06-10T08:41:40","slug":"tuotantotyokalut-taulukko","status":"publish","type":"tesserakb","link":"https:\/\/gestsociety.com\/en\/knowledgebase\/tuotantotyokalut-taulukko\/","title":{"rendered":"Production tools: Production or spreadsheet tool"},"content":{"rendered":"<h1 class=\"wp-block-heading\"><strong>Table tool<\/strong><\/h1>\r\n<p><span style=\"font-weight: 400;\">The Production tool can be used to compile all event-related information in a table format. Venues and performers can be added to the table. It is useful for coordinating event area construction or stage schedules, for example.<\/span><\/p>\r\n<p><span style=\"font-weight: 400;\">The idea is to build, for example, construction, stage or area maintenance schedules, schedules, etc. in a table format and distribute them to essential people, from catering to the band&#039;s tour manager and from subcontractors to the stage manager.<\/span><\/p>\r\n<p><span style=\"font-weight: 400;\">Create a new collection by pressing collection at the end of the line with a <strong>+<\/strong> button. Name the template and select from the drop-down menu <strong>Production schedule collection template (Production).<\/strong><\/span><\/p>\r\n<p><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone wp-image-1454\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.35.00.png\" alt=\"\" width=\"376\" height=\"311\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.35.00.png 420w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.35.00-300x248.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.35.00-15x12.png 15w\" sizes=\"(max-width: 376px) 100vw, 376px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\">Edit the fields on the form. The fields are filled with information for each area\/stage\/program and act as headers. The information is not filled in externally, but the producer adds the necessary information to the fields.<\/span><\/p>\r\n<p><img decoding=\"async\" class=\"alignnone wp-image-1455\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.37.39.png\" alt=\"\" width=\"775\" height=\"487\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.37.39.png 979w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.37.39-300x188.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.37.39-768x482.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-11.37.39-18x12.png 18w\" sizes=\"(max-width: 775px) 100vw, 775px\" \/><\/p>\r\n\r\n\r\n\r\n<h2 class=\"wp-block-heading\"><strong>Creating a new Production template<\/strong><\/h2>\r\n<p><span style=\"font-weight: 400;\">A new spreadsheet template is created in the collection view by right-clicking <strong>Add new<\/strong>.<\/span><\/p>\r\n<ul>\r\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Write the name of the base (area, stage, program).\u00a0<\/span><\/li>\r\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Set the production date. If you want, you can also set a time when the event doors will open to the public.<\/span><\/li>\r\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Finally, you can supplement and follow-up on the additional information with information relevant to production, such as contact information.<\/span><\/li>\r\n<\/ul>\r\n<p><img decoding=\"async\" class=\"wp-image-909\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_23.png\" alt=\"\" width=\"488\" height=\"513\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_23.png 802w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_23-285x300.png 285w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_23-768x807.png 768w\" sizes=\"(max-width: 488px) 100vw, 488px\" \/><\/p>\r\n<h3><strong>Adding and editing table data<\/strong><\/h3>\r\n<p><span style=\"font-weight: 400;\">The page opens blank. The spreadsheet template has headings for each individual column. By default, the headings are related to the stage schedule, but all headings can be edited and changed to suit your needs.<\/span><\/p>\r\n<p><span style=\"font-weight: 400;\">You can add a new row to the schedule template by clicking on the + sign on the left edge.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-912\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24-1024x415.png\" alt=\"\" width=\"834\" height=\"338\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24-1024x415.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24-300x122.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24-768x311.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24-1536x623.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_24.png 1853w\" sizes=\"(max-width: 834px) 100vw, 834px\" \/><\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<p class=\"wp-block-paragraph\"><strong>When you want to complete the table data, click on the cell in the desired column.<\/strong><\/p>\r\n<p><span style=\"font-weight: 400;\">After that, you can complete the information one by one. In addition to text, you can add links and files stored in GEST to the information, such as catering or technical raiders. You can add a file by clicking on the image of the chain and selecting a file uploaded to GEST. You can also enter schedule-related information in the cell, such as duration, time or interval. You can also change the text and background identification color to your liking.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1512\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125317.png\" alt=\"\" width=\"522\" height=\"623\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125317.png 743w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125317-251x300.png 251w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125317-10x12.png 10w\" sizes=\"(max-width: 522px) 100vw, 522px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\"><strong>The first column is different from the others:<\/strong> The first column can contain information about the performer or venue. Click on one of the cells in the first column. Select from <strong>Select a collection group<\/strong> mixed <strong>Collections<\/strong> the collection you want and the person\/organization\/place under it. When linking to information from other collections, do not enter anything in the &quot;Name&quot; field. Finally, press <strong>Save<\/strong>.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-911\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_25.png\" alt=\"\" width=\"524\" height=\"658\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_25.png 669w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_25-239x300.png 239w\" sizes=\"(max-width: 524px) 100vw, 524px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\">Once all rows and columns have been completed, it is easy to see the whole table at a glance. The finished table might look like this:<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1513\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923.png\" alt=\"\" width=\"891\" height=\"355\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923.png 1835w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923-300x120.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923-1024x408.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923-768x306.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923-1536x613.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-125923-18x7.png 18w\" sizes=\"(max-width: 891px) 100vw, 891px\" \/><\/p>\r\n<p>\r\n\r\n\r\n\r\n<\/p>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<h3><strong>Sharing a table<\/strong><\/h3>\r\n<ul>\r\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You can print the production schedule using the Print button.<\/span><\/li>\r\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">You can share production schedule information by creating a link and emailing it to the people you want.\u00a0<\/span><\/li>\r\n<\/ul>\r\n<h5><strong>Sharing a spreadsheet from the Print button<\/strong><\/h5>\r\n<p class=\"wp-block-paragraph\">Press <strong>Print<\/strong>-button.<\/p>\r\n<p>GEST creates from table <strong>page<\/strong>, which includes all the data in the table, including links and files. The page can also be <strong>print to PDF version<\/strong> through your own browser.<\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-910\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26-1024x411.png\" alt=\"\" width=\"940\" height=\"377\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26-1024x411.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26-300x120.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26-768x308.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26-1536x616.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2022\/04\/Tietojen-yhdistaminen_26.png 1830w\" sizes=\"(max-width: 940px) 100vw, 940px\" \/><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone  wp-image-1515\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031.png\" alt=\"\" width=\"936\" height=\"438\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031.png 1895w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031-300x140.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031-1024x479.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031-768x359.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031-1536x719.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Nayttokuva-2026-06-08-131031-18x8.png 18w\" sizes=\"(max-width: 936px) 100vw, 936px\" \/><\/p>\r\n<h5><strong>Sharing a spreadsheet with a link <\/strong><\/h5>\r\n<p><span style=\"font-weight: 400;\">Press the Share button.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-1335\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.00.35-300x199.png\" alt=\"\" width=\"300\" height=\"199\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.00.35-300x199.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.00.35-18x12.png 18w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.00.35.png 374w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\">After this, a blue dot will appear next to each row and column in the table. By clicking on the rows and columns you want, you can deselect them.<\/span><\/p>\r\n<p><span style=\"font-weight: 400;\">The options with a blue dot are information that you pass on. For example, for catering, essential information could be a schedule, catering raider, baker&#039;s number, etc.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1336\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-1024x658.png\" alt=\"\" width=\"737\" height=\"474\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-1024x658.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-300x193.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-768x494.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-1536x987.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06-18x12.png 18w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.02.06.png 1606w\" sizes=\"(max-width: 737px) 100vw, 737px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\">If you want, you can record the table name <strong>Share name<\/strong> -towards.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1456\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-13.09.10.png\" alt=\"\" width=\"754\" height=\"105\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-13.09.10.png 926w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-13.09.10-300x42.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-13.09.10-768x107.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2025-07-28-at-13.09.10-18x3.png 18w\" sizes=\"(max-width: 754px) 100vw, 754px\" \/><\/p>\r\n<p><span style=\"font-weight: 400;\">Once you have selected the data you want and named the table, press <strong>Make a share link<\/strong>. <\/span><span style=\"font-weight: 400;\">The function creates a link that you can send to relevant people, e.g. by email.<\/span><\/p>\r\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-1337\" src=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-1024x403.png\" alt=\"\" width=\"681\" height=\"268\" srcset=\"https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-1024x403.png 1024w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-300x118.png 300w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-768x302.png 768w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-1536x604.png 1536w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36-18x7.png 18w, https:\/\/gestsociety.com\/wp-content\/uploads\/2023\/12\/Screenshot-2024-07-29-at-16.05.36.png 1572w\" sizes=\"(max-width: 681px) 100vw, 681px\" \/><\/p>","protected":false},"excerpt":{"rendered":"<p>The spreadsheet tool allows you to compile event production-related information into a single spreadsheet. The tool is suitable for planning and coordinating construction, demolition, stage, area and logistics schedules, as well as schedules. The spreadsheet can also include information from Venue and Group\/Band collections.<\/p>\n<p>This section walks you through creating a production schedule, adding and editing data, and sharing the table with different stakeholders via a link or printout.<\/p>","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"tessera_post_format_link":""},"tesserakbcats":[130],"tesserakbtags":[156,177,157],"class_list":["post-1445","tesserakb","type-tesserakb","status-publish","format-standard","hentry","tesserakbcats-tuotantotyokalut","tesserakbtags-kokoelmat","tesserakbtags-production","tesserakbtags-tuotantoaikataulu"],"_links":{"self":[{"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/tesserakb\/1445","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/tesserakb"}],"about":[{"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/types\/tesserakb"}],"author":[{"embeddable":true,"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/comments?post=1445"}],"wp:attachment":[{"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/media?parent=1445"}],"wp:term":[{"taxonomy":"tesserakbcats","embeddable":true,"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/tesserakbcats?post=1445"},{"taxonomy":"tesserakbtags","embeddable":true,"href":"https:\/\/gestsociety.com\/en\/wp-json\/wp\/v2\/tesserakbtags?post=1445"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}