- No installations, no bloatware, no updates; this works in any modern browser, including Google Chrome, Firefox, Edge and Safari.
不需要安裝，不需要外掛，不用升級，適用於最新版本的各種瀏覽器。 - It allows you to easily change boring progress percentage numbers into interesting, funny image progress bars, which can add fun to your work and enhance the competitive enthusiasm of your users.
讓您輕鬆地將無聊的進度百分比數字，改成有趣的圖像方式呈現，為您增添工作中的樂趣，也能提升使用對象的競爭熱情。 - Write simple spreadsheet formulas into cells and apply them to other spreadsheets at any time. No programming knowledge is required.
用簡易的試算表公式寫入儲存格中，讓您隨時可以套用到其他的試算表，完全不需要程式基礎就能使用。
👉 English version[Make a Copy][View Files] 👉 中文版本[建立副本][瀏覽檔案]
👉 English version 👉 中文版本
Welcome to my website Gas Station, there may be some tools, programs, or even inspiration that can help you. We are more than happy to accept your sponsorship if you wish.❤️
歡迎參觀我的網站 Gas Station，裡頭也許會有一些能幫助您的工具、程式，甚至是提供您創意的靈感。如果您願意的話，也非常樂意接受您的打賞。❤️
Copyright (c) 2025 Chang, Chia-Cheng 張家誠
Please be sure to use the "Make a copy" method to copy the file to your cloud drive. The file can be renamed at will.
The program will access files in your cloud drive when it is executed, so please authorize the use of your cloud drive when you execute it for the first time.
To execute this program, you need 1 designated sheet and 2 corresponding fields, as shown in the figure below:
- Specify a sheet "Attend investigation" (custom name) and create a sheet with this name in the spreadsheet.
- Assume that the reply collection unit is "Class" (custom name), so the "rightmost column" in the "Attend investigation" sheet is named "class".
- The progress of each class's collection has a "Percentage" (custom name), so there needs to be a column named "Percentage" in the "Attend investigation" sheet.
After confirming that the necessary settings have been completed, try the example immediately. Display mode "icon" and try the progress bar direction left and right. Just use the "Create progress bar" in the "Advanced function" menu, and One-click completion.
The first cell = if (1/10 <= percentage, if ((2/10) > percentage, reference cloumn O to display the icon, ""), ""), the second cell = if (2/10 < percentage, if((3/10)>percentage, reference column O to display the icon,""),""),...and so on.
Mode A: Prepare a picture file and let each class be the progress bar picture to add fun to the competition. With following picture to explain the points:
- In the "Setup" sheet, select "Continuous Picture" in the "Display Mode" field and select "Yes" in the "All groups use one CP" field.
- Use cutting software or website to cut the image into 10 equal parts and put them into the "OnlyOne" folder. Please name the image file with numbers 1 to 10.
- Use the "Make Bars" in the "Advanced" menu to complete it with one click. (Due to security, your authorization will be requested when you reference the image file for the first time. It can only be displayed normally after authorization is granted)
- The image will be automatically scaled according to the cell size. Please adjust the cell column width or row height to achieve the best stitching effect.
- The image file cannot be directly placed in the storage cell, so first use the IMAGE function to import it into the storage cell (column O:X), and then use the formula to bring it into the progress bar (column E:N).
Mode B-1: Prepare 3 pictures and let each class use the progress to piece together their own pictures to see who can complete their own first, adding to the fun of progress competition. With following picture to explain the points:
- In the "Setup" sheet, select "Continuous Picture" in the "Display Mode" field and select "No" in the "All groups use one CP" field.
- Use cutting software or website to cut the 3 images into 10 equal parts, and put them into the folders of respective classes. Please name the files in each folder with numbers 1 to 10.
- According to the length and width of the continuous picture, provide an appropriate storage cell size (column width 50, row height 100), and use the "Make bars" in the "Advanced" menu to complete it with one click.
- In order to make the overall layout simple and clean, we will hide the O:X column in this example.
The picture of the Three Graces is taken from the "[Art Learnings](https://artlearnings.com/" website.
The picture of the Titanic is taken from the "wikipedia" website.
Mode B-2: Prepare 1 picture, cut it into 3 pieces, and then cut each picture into 10 equal parts, and put them into the folders of 3 classes respectively, adding to the fun of progress competition. With following picture to explain the points:
- In the "Setup" sheet, select "Continuous Picture" in the "Display Mode" field and select "No" in the "All groups use one CP" field.
- Use cutting software or website to cut the 3 images into 10 equal parts, and put them into the folders of respective classes. Please name the files in each folder with numbers 1 to 10.
- According to the length and width of the continuous picture, provide an appropriate storage cell size (column width 63, row height 33), and use the "Make bars" in the "Advanced" menu to complete it with one click.
- The first cell = if (1/10 < percentage, reference column O to display the first picture, ""), the second cell = if (2/10 < percentage, reference column P to display the second picture, ""), ...and so on.
- In order to make the overall layout simple and clean, we will hide the O:X column in this example.
I hope you can keep it, but you can input "I'm sorry to Chang Chia Cheng" 🤣 to remove the ads.
請務必使用「建立副本」的方式將檔案複製到您的雲端硬碟中，檔案可以任意重新命名。
程式執行時會取用您雲端硬碟中的檔案，所以第1次執行時請先授權允許使用您的雲端硬碟。
執行這個程式，您需要1個指定的工作表以及2個對應的欄位，配合下圖分點說明：
- 指定1個工作表「回條繳交」(自訂名稱)，並以此名稱在試算表中建立工作表。
- 假設回條回收單位為「班級」(自訂名稱)，所以在「回條繳交」工作表中需要有一個『必須在最右邊的欄位』，名稱為「班級」。
- 每個班級回收的進度有一個「完成百分比」(自訂名稱)，所以在「回條繳交」工作表中需要有一個欄位名稱為「完成百分比」。
確認完成必要的設定之後，立刻以範例試玩看看，顯示模式「圖示」，進度條方向左、右各試一次，只要使用選單「進階功能」中的「製作進度條」，一鍵就能完成。
第1格=if(1/10<=百分比,if((2/10)>百分比,引用O欄顯示圖示,""),"")，第2格=if(2/10<百分比,if((3/10)>百分比,引用O欄顯示圖示,""),"")，...以此類推。
第1種方式：準備1個圖檔，讓每個班級用進度來拼接，增添進度競爭的樂趣，配合下圖分點說明：
- 在設定工作表的「顯示模式」選擇為「連續圖」，「共用一張連續圖」選擇為「是」。
- 利用切割軟體或網站將圖檔切成10等分後放入「OnlyOne」的資料夾中，圖檔的檔案名稱請依序用數字1至10來命名。
- 使用選單「進階功能」中的「製作進度條」，一鍵就能完成。(因為安全性考量，第1次引用圖檔時會要求您的授權，允許授權後才能正常顯示)。
- 圖檔會受到儲存格大小影響而自動縮放，請調整儲存格的欄寬或列高來取得最好的拼接效果。
- 圖檔不能直接放進在儲存格中，所以先用IMAGE函式在後面引入儲存格裡(O:X欄)，再用公式帶入進度條之中(E:N欄)。
第2種方式：準備3張圖檔，讓每個班級用進度來各自拼接，看看誰能先完成自己的連環圖，增添進度競爭的樂趣，配合下圖分點說明：
- 在設定工作表的「顯示模式」選擇為「連續圖」，「共用一張連續圖」選擇為「否」。
- 利用切割軟體或網站將3張圖檔切成10等分後，分別放入各自的資料夾，每個資料夾中的檔案名稱請依序用數字1至10來命名。
- 配合連續圖的長寬，提供適當的儲存格大小(欄寬50，列高100)後，使用選單「進階功能」中的「製作進度條」，一鍵就能完成。
- 為了讓整體版面在顯示上單純與乾淨，這次的範例我們將O:X欄隱藏。
第3種方式：準備1張圖檔切割給每個班級用，全部的班級一起拼揭連續圖，增添進度競爭的樂趣，配合下圖分點說明：
- 在設定工作表的「顯示模式」選擇為「連續圖」，「共用一張連續圖」選擇為「否」。
- 利用切割軟體或網站將1張圖檔切成每個班級10等分後，分別放入各自的資料夾，每個資料夾中的檔案名稱請依序用數字1至10來命名。
- 配合連續圖的長寬，提供適當的儲存格大小(欄寬84，列高44)後，使用選單「進階功能」中的「製作進度條」，一鍵就能完成。
- 第1格=if(1/10<百分比,引用O欄顯示第1張圖,"")，第2格=if(2/10<百分比,引用P欄顯示第2張圖,"")，...以此類推。
- 為了讓整體版面在顯示上單純與乾淨，可以將O:X欄隱藏。
希望您能保留，如果不得已要移除，請在設定工作表的「移除廣告」欄位中輸入「張家誠，我金拍謝！」 🤣
