{"id":88461,"date":"2020-05-25T09:00:00","date_gmt":"2020-05-25T00:00:00","guid":{"rendered":"https:\/\/support.questetra.com\/developer-blog\/modeling-tips-excel\/"},"modified":"2026-04-14T14:40:17","modified_gmt":"2026-04-14T05:40:17","slug":"modeling-tips-excel","status":"publish","type":"post","link":"https:\/\/support.questetra.com\/en\/developer-blog\/modeling-tips-excel\/","title":{"rendered":"Tips to Make Modeling a Little Easier (Data Editing Permissions)"},"content":{"rendered":"\n
\"\"<\/figure>\n\n\n\n
<\/div>\n\n\n\n

Hi there!
On this page I’d like to introduce some tips to make modeling a little easier.<\/p>\n\n\n\n

If there are many Tasks (called Human Tasks) or Data Items it is quite difficult to set the data editing permissions.\nIf you set them on the properties screen of an individual Task or on the edit screen of each Data Item, that might cause an oversight and some problems with the overall consistency.\n<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n

One of the methods for dealing with this is; BPM Suite has a feature to bulk update data editing permissions with a single TSV file (in the upper right menu). Since it’s a TSV file, you can edit it in Excel and upload it.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n
\"\"<\/figure><\/div>\n\n\n\n

When you open a TSV file in Excel, a list of numbers is shown like in the following picture. However, the list looks complicated, so it is necessary to edit it.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

So, if you make changes you can distinguish each number with colors in Excel.<\/p>\n\n\n\n

\"\"<\/figure><\/div>\n\n\n\n

In the above picture, I use Conditional Formatting, one of the features in Excel. Also, you can download a colored Excel file from the link below.
*There are 200 color Columns and 100 color Rows in the file. You can also copy and paste to expand the range.
\nhttps:\/\/drive.google.com\/file\/d\/1CQdvKiKohhgYAp6wUva1h5RZjFAV-J5y\/view?usp=sharing\n<\/a><\/p>\n\n\n\n

You just open the downloaded TSV file in Excel and paste it into this colored file. You can create a TSV file to upload by saving it in the “Text (Tab Delimited) File” format.<\/p>\n\n\n\n

You can also upload TSV files by changing the order of the Tasks. If you shift the Tasks in the upstream to the left and shift the ones in the downstream to the right, you can perform an edit considering the consistency between Tasks.<\/p>\n\n\n\n

I hope this is helpful to you.<\/p>\n","protected":false},"excerpt":{"rendered":"

I will introduce some tips to make data editing permissions of many Tasks and Data Items a little easier.<\/p>\n","protected":false},"author":9,"featured_media":88027,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_coblocks_attr":"","_coblocks_dimensions":"","_coblocks_responsive_height":"","_coblocks_accordion_ie_support":"","_uag_custom_page_level_css":"","advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"jetpack_seo_schema_type":"","_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_wpcom_ai_launchpad_first_post":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_wpas_customize_per_network":false,"jetpack_post_was_ever_published":false},"categories":[296],"tags":[],"faq_section":[],"class_list":["post-88461","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-developer-blog"],"jetpack_publicize_connections":[],"uagb_featured_image_src":{"full":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1200%2C675&ssl=1",1200,675,false],"thumbnail":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=440%2C440&ssl=1",440,440,true],"medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=560%2C315&ssl=1",560,315,true],"medium_large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=768%2C432&ssl=1",768,432,true],"large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1024%2C576&ssl=1",1024,576,true],"1536x1536":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1200%2C675&ssl=1",1200,675,true],"2048x2048":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-portrait-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=900%2C675&ssl=1",900,675,true],"newspack-article-block-square-large":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=1200%2C675&ssl=1",1200,675,true],"newspack-article-block-landscape-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=800%2C600&ssl=1",800,600,true],"newspack-article-block-portrait-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=600%2C675&ssl=1",600,675,true],"newspack-article-block-square-medium":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=800%2C675&ssl=1",800,675,true],"newspack-article-block-landscape-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=600%2C450&ssl=1",600,450,true],"newspack-article-block-portrait-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=450%2C600&ssl=1",450,600,true],"newspack-article-block-square-intermediate":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=600%2C600&ssl=1",600,600,true],"newspack-article-block-landscape-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=400%2C300&ssl=1",400,300,true],"newspack-article-block-portrait-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=300%2C400&ssl=1",300,400,true],"newspack-article-block-square-small":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=400%2C400&ssl=1",400,400,true],"newspack-article-block-landscape-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=200%2C150&ssl=1",200,150,true],"newspack-article-block-portrait-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=150%2C200&ssl=1",150,200,true],"newspack-article-block-square-tiny":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?resize=200%2C200&ssl=1",200,200,true],"newspack-article-block-uncropped":["https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1200%2C675&ssl=1",1200,675,true]},"uagb_author_info":{"display_name":"Tsuyoshi Kusaka","author_link":"https:\/\/support.questetra.com\/en\/author\/kusaka0211\/"},"uagb_comment_info":0,"uagb_excerpt":"I will introduce some tips to make data editing permissions of many Tasks and Data Items a little easier.","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p9DiIh-n0N","jetpack-related-posts":[{"id":76611,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/facebook-questetra\/","url_meta":{"origin":88461,"position":0},"title":"Setting up Collaboration between Facebook and Questetra","author":"Tsuyoshi Kusaka","date":"2019-05-24","format":false,"excerpt":"Summary of how to collaborate Questetra BPM Suite with Facebook","rel":"","context":"In "Questetra Developers Blog"","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/facebook-questetra.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/facebook-questetra.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/facebook-questetra.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/facebook-questetra.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/05\/facebook-questetra.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":79781,"url":"https:\/\/support.questetra.com\/en\/data-items\/table-type\/","url_meta":{"origin":88461,"position":1},"title":"Table-Type","author":"Peter Glover","date":"2021-01-22","format":false,"excerpt":"Displays a table that can use the String, Numeric, Select or Date formats.","rel":"","context":"In "Data Items"","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/09\/Table.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":78460,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/choices-google-sheets\/","url_meta":{"origin":88461,"position":2},"title":"Utilize Customer Data on Google Sheets as Choices","author":"Hirotaka NISHI","date":"2020-04-23","format":false,"excerpt":"Get the Customer List stored in Google Sheet via API, and save\/use it as the Options Master.","rel":"","context":"In "Questetra Developers Blog"","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/07\/google-sheet-choice-master-featured-image.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":80860,"url":"https:\/\/support.questetra.com\/en\/data-items\/title\/","url_meta":{"origin":88461,"position":3},"title":"Title","author":"Peter Glover","date":"2019-11-05","format":false,"excerpt":"Displays a text field for entering a string and stores the entered string as the subject of the process.","rel":"","context":"In "Data Items"","block_context":{"text":"Data Items","link":"https:\/\/support.questetra.com\/en\/category\/data-items\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Title.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Title.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Title.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Title.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/10\/Title.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":99135,"url":"https:\/\/support.questetra.com\/en\/versions\/version-1230\/","url_meta":{"origin":88461,"position":4},"title":"v12.3 2021-01-17 Added Auto-step that Cooperates with kintone","author":"Hirotaka NISHI","date":"2020-12-28","format":false,"excerpt":"An auto-step that can be used as the standard in the workflow platform of Advanced or higher is added. Also, Apps in which \"Rhino\" is used in the Script Task results a setting error","rel":"","context":"In "Version Info"","block_context":{"text":"Version Info","link":"https:\/\/support.questetra.com\/en\/category\/versions\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/12\/version-1230-fi-en.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]},{"id":75378,"url":"https:\/\/support.questetra.com\/en\/developer-blog\/onedrive-questetra\/","url_meta":{"origin":88461,"position":5},"title":"How to Output Files from Cloud-based Workflow Questetra to OneDrive","author":"Tsuyoshi Kusaka","date":"2019-03-06","format":false,"excerpt":"Summary of connection settings (file output) for Questetra BPM Suite to OneDrive","rel":"","context":"In "Questetra Developers Blog"","block_context":{"text":"Questetra Developers Blog","link":"https:\/\/support.questetra.com\/en\/category\/developer-blog\/"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/onedrive-questetra-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/onedrive-questetra-1200x675-1.png?fit=1200%2C675&ssl=1&resize=350%2C200 1x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/onedrive-questetra-1200x675-1.png?fit=1200%2C675&ssl=1&resize=525%2C300 1.5x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/onedrive-questetra-1200x675-1.png?fit=1200%2C675&ssl=1&resize=700%2C400 2x, https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2019\/03\/onedrive-questetra-1200x675-1.png?fit=1200%2C675&ssl=1&resize=1050%2C600 3x"},"classes":[]}],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/support.questetra.com\/wp-content\/uploads\/2020\/05\/Tips-eyecatch.png?fit=1200%2C675&ssl=1","_links":{"self":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88461","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/users\/9"}],"replies":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/comments?post=88461"}],"version-history":[{"count":8,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88461\/revisions"}],"predecessor-version":[{"id":91407,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/posts\/88461\/revisions\/91407"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media\/88027"}],"wp:attachment":[{"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/media?parent=88461"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/categories?post=88461"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/tags?post=88461"},{"taxonomy":"faq_section","embeddable":true,"href":"https:\/\/support.questetra.com\/en\/wp-json\/wp\/v2\/faq_section?post=88461"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}