要記得按讚喔!! Please like! 好東西又來了,這次是餐桌的位置安排,一兩桌還好,手動用ppt 畫一畫就好,但是,如果5-10張桌要排位置,或者排好要調位置,若還是用老方法來做,那可能會很花時間,相當苦惱。為了解決這種問題,所以特別寫這篇供大家參考。
This article provides great solutions for table seats arrangement via merged printing function in word. Enclosed please find the merger word file and database file in text form.
筆者以往常常要安排、列印餐桌牌及座位圖,為了解決前述惱人的問題,所以用WORD做了一個合併列印的檔案,希望這篇文章能夠幫助您。桌牌列印可以參考2021年3月12日所po的fb文,也感謝大家的支持,觸及人數超過4.7k,互動人數超過1k。
使用本餐桌座位安排合併列印功能,可以省掉很多安排列印的時間。您只要依照資料庫檔案格式輸入資料即可。Word的合併列印資料庫可以用記事本去做。本系統的資料庫格式如下:
姓名
xxA長
b處長
c處長
d處長
e幹事
f會長
名單可以把處理完桌牌後的檔案拿來再利用,只留姓名跟職稱。如果名單是表格的話,可以複製,然後貼在記事本中,就可把表格除去,這樣格式就會符合資料庫的需求。
有了資料庫以後,接下來就是點出合併列印的母檔word 檔,這個母檔建議跟資料庫檔放在一起,比較好認,母檔如後附件的”圓桌排位”.docx,打開後 選 “是",然後 “確定” x3,就可以開啟合併列印的母檔。開啟檔案後,點選 ”郵件” 再點 “預覽結果” 再按 預覽結果右邊上面的向右鍵,如果10人一桌,想看下一頁的排位,就在右鍵空格中輸入11,就可以看到第二桌的排位。如果第三桌只要排9人或8人,那就在資料庫第21-30列間,放一列或兩列空格在記事本的資料庫中,如下圖:
特殊人數的桌位排法,把這些資料放在資料庫的最前面會比較好辨識,因為如果放在資料庫的中間或者尾端,還要數很久才會數正確。螢幕上看到的排位圖可以立刻轉存成pdf檔,或者印出。Word 母檔中的桌子圖案及字體顏色等,都可以自行修改。第一次用時,要選擇資料庫檔案的目錄位置。
謝謝您的使用。
#圓桌排位
#名牌製作
#桌牌快速製作
#合併列印
#Word合併列印
範例檔案:
1.圓桌排位.docx
https://drive.google.com/file/d/1LR1uJA2OXqfLHbksZOjfmsu0lxtqVwxQ/view?usp=sharing
2.資料庫: 資料庫名字.txt
https://drive.google.com/file/d/12NwCpVJTPz7zU1amRJPuB-54LgpYAqQT/view?usp=sharing
同時也有1部Youtube影片,追蹤數超過11萬的網紅Lukas Engström,也在其Youtube影片中提到,Today we are talking about how Taiwan went from "Garbage Island" to recycling paradise! Taipei City Garbage truck tracking: http://www.dep-in.gov.tai...
f table pdf 在 Lukas Engström Youtube 的精選貼文
Today we are talking about how Taiwan went from "Garbage Island" to recycling paradise!
Taipei City Garbage truck tracking: http://www.dep-in.gov.taipei/epb/iframe/trash.aspx
Taipei City Recycling truck time table: https://www-ws.gov.taipei/Download.ashx?u=LzAwMS9VcGxvYWQvMzYzL3JlbGZpbGUvNDExNDMvNzUzNDQ1NC9hYzA3OGJhNS03YTNmLTRiNGEtOGJlYy00YmZmYjlhODdhNGEucGRm&n=6LOH5rqQ5Zue5pS25YiG6aGe5LiA6Ka96KGo5ZyW5paH5pG66aCBLeiLseaWh%2beJiC5wZGY%3d&icon=..pdf
New Taipei City Recycling truck time table: https://crd-rubbish.epd.ntpc.gov.tw/dispPageBox/Ntpcepd/NtpCp.aspx?ddsPageID=SEARCHC&
Do you want to see MORE videos like this one? Please consider supporting me on Patreon as all my income will go directly back into the channel and cover either future travels or other resources: https://www.patreon.com/LukasEngstrom
Please follow me on:
Facebook: www.facebook.com/LukasTaiwan
Instagram: www.instagram.com/LukasEngstrom
Business inquiries:
中文/English
創作者經紀人/Contact person: - Maggie
Line ID: @redi
Email: contact@lukasengstrom.com
All music from Epidemic Sound: http://share.epidemicsound.com/DlqDP
The following is the gear I’m using when making my videos. I’m part of Amazon Services LLC Associates Program which means that I will get a small commission if you purchase anything via my links. Any commission I’ll be getting will go straight back into buying new gear for my future videos, so any sort of support is highly appreciated!
MAIN GEAR:
Insta360:
https://www.insta360.com/sal/onex_real_estate_kit?insrc=INR0P5F
Camera: Canon EOS R: https://amzn.to/2CAybbh
Lens: Canon RF 24-70mm F2.8 L IS USM: https://amzn.to/34RDy1V
Insta360 One X: https://amzn.to/2KfwBjd
Tripod: JOBY GorillaPod 5K Kit: https://amzn.to/36VxMhy
Microphone: RØDE VideoMic Pro+: https://amzn.to/2Tg9mbx
Drone: DJI Mavic 2 Zoom: https://amzn.to/2Sak4CX
Mavic 2 Fly More Kit: https://amzn.to/2TlpLLT
Gimbal: DJI Ronin-S Handheld 3-Axis: https://amzn.to/2NG4L20
2x SanDisk Extreme Pro Memory Card (128GB): https://amzn.to/2Oi0CQX
Bag: Lowepro ProTactic BP 450 AW II:https://amzn.to/2NDbCsN
BACK-UP GEAR:
Camera: Canon M50: https://amzn.to/2Tf998r
Lens: Canon EF 24mm f/1.4L II USM: https://amzn.to/2O0a62Y
Lens: Canon EF 50mm f/1.8 STM https://amzn.to/2O5DJA0
Lens: Canon EF-S 10-18mm f/4.5-5.6 IS STM: https://amzn.to/2X88oR7
Canon EOS M Mount Adapter: https://amzn.to/2O1jH9I
Canon EF-EOS R Mount Adapter: https://amzn.to/2NDak0V
JOBY Gorillapod 3K: https://amzn.to/2S3GQfR
OTHER GEAR:
ADATA SD600Q SSD (240GB): https://amzn.to/2Wp28Tf
ADATA D8000L LED Power Bank: https://amzn.to/34MrlLY
Transcend ESD240C Portable SSD (480GB): https://amzn.to/2X5L7xW
Transcend ESD350C Portable SSD (480GB): https://amzn.to/32LBzeg
Transcend StoreJet 25MC HDD (1TB): https://amzn.to/2KekmUd
Transcend 128GB microSD: https://amzn.to/2tCkOmw
MacBook Pro 15” - TouchBar: https://amzn.to/2p7rSsy
Asus VP28UQG 28" 4K/UHD monitor: https://amzn.to/2CE5eeI
Special thanks to STC for helping me out with filters:
STC website:https://stcoptics.com/en/
STC Facebook:https://www.facebook.com/STCOptics/
CPL:https://stcoptics.com/en/shvcpl/
VND:https://stcoptics.com/en/vnd/
ICELAVA:https://stcoptics.com/en/icelava/
E-shop:https://shop.stcoptics.com/ Thank you: https://vectorflags.com/taiwan/tw-heart-01
Garbage PNG for thumbnail: a href='https://pngtree.com/so/hand-vector' hand-vector png from pngtree.com /a
f table pdf 在 How to read an F table in statistics - YouTube 的美食出口停車場
You can find the online F - Table at http://www.statisticshowto.com/tables/ f - table / ... <看更多>