Template Google Sheets Quan Ly Su Kien: Lap Ke Hoach Va Ngan Sach Event

To chuc mot su kien thanh cong doi hoi su phoi hop chat che cua hang chuc dau viec. Tu hoi nghi doanh nghiep, tiec cuoi, le khai truong den su kien team building, moi loai deu can mot he thong quan ly ro rang de khong bo sot bat ky chi tiet quan trong nao.

Template Google Sheets quan ly su kien nay giup ban lap ke hoach hoan chinh, theo doi ngan sach chat che va danh gia ket qua sau event, tat ca trong mot file duy nhat, mien phi va co the chia se voi toan team.

1. Tai Sao Google Sheets La Lua Chon Tot Cho Quan Ly Su Kien?

Su kien that bai thuong do nhung nguyen nhan co the phong tranh: quen dau viec quan trong, vuot ngan sach vi khong theo doi thoi gian thuc, thong tin phan tan, khong ro ai chiu trach nhiem, khong co timeline ro rang.

So sanh cong cu quan ly event

2. Cau Truc Template Quan Ly Su Kien

Tab 1: Event Overview (Tong Quan Su Kien)

• Ten su kien, mo ta ngan, ngay/gio/dia diem
• So luong khach du kien va muc tieu su kien
• Team organizer va phan cong vai tro
• Ngan sach tong va trang thai
• Countdown timer den ngay event va progress tong the

Tab 2: Budget (Ngan Sach)

• Ngan sach phan theo danh muc
• Chi phi uoc tinh vs chi phi thuc te
• So tien da thanh toan vs con no
• Canh bao vuot ngan sach tu dong

Tab 3: Master Checklist

• Danh sach dau viec day du phan theo giai doan
• Owner, deadline, status, ghi chu
• % hoan thanh tu dong

Tab 4-9: Timeline, Run of Show, Supplier, Guests, Communication, Post-Event

• Timeline/Gantt: cac moc quan trong theo truc thoi gian
• Run of Show: kich ban chi tiet tung phut ngay dien ra
• Supplier: hop dong, lien he, trang thai thanh toan, danh gia
• Guest List: RSVP, so do ban ngoi, check-in on-site
• Post-Event Review: NPS, feedback, lessons learned

3. Lap Ke Hoach Tong The Su Kien

Framework lap ke hoach 5W2H

4. Quan Ly Ngan Sach Event Chuyen Nghiep

Cau truc danh muc ngan sach

Cong thuc quan ly ngan sach

// Tong chi tieu thuc te
=SUM(D2:D20)
// Ngan sach con lai
=ngan_sach_tong - SUM(D2:D20)
// Canh bao vuot ngan sach
=IF(D2>C2, "Vuot ngan sach!", "Binh thuong")

5. Timeline Va Task Tracking

Giai doan lap ke hoach (event quy mo 100-300 nguoi)

6. Master Checklist Su Kien

Giai doan 1: Len ke hoach (3-6 thang truoc)

• Xac dinh muc tieu va KPI su kien
• Phe duyet ngan sach tong
• Chon va dat coc dia diem
• Xac dinh ban to chuc va phan cong vai tro

Giai doan 2: Chuan bi (1-2 thang truoc)

• Ky hop dong voi cac don vi cung cap chinh
• Gui invitation va theo doi RSVP
• Hoan thien program/agenda
• Brief speakers va MC

Tinh % hoan thanh checklist

// Dung checkbox o cot F
=COUNTIF(F2:F200, TRUE) / COUNTA(F2:F200) * 100
// So task qua han
=COUNTIFS(D2:D200, "<"&TODAY(), F2:F200, FALSE)

7. Quan Ly Don Vi Cung Cap (Supplier Management)

// Cau truc tab Don Vi Cung Cap:
// A: STT | B: Loai dich vu | C: Ten cong ty | D: Lien he
// E: SDT | F: Email | G: Gia thoa thuan | H: Da thanh toan
// I: Ngay TT cuoi | J: Hop dong? | K: Status | L: Rating sau event

// Tong con phai thanh toan
=SUMPRODUCT((G2:G50 - H2:H50) * (K2:K50 = "Confirmed"))

8. Danh Gia Sau Su Kien (Post-Event Review)

Tao Google Form danh gia sau event: tong the (1-10), tung phan (Dia diem, An uong, Noi dung, MC), dieu can cai thien, NPS (0-10).

// NPS Score
=COUNTIF(NPS!B:B, ">=9") / COUNT(NPS!B:B) * 100   // % Promoters
=COUNTIF(NPS!B:B, "<=6") / COUNT(NPS!B:B) * 100   // % Detractors
// NPS = %Promoters - %Detractors (-100 den +100)
=AVERAGE(Feedback!C:C)  // Rating dia diem

Lessons Learned

9. Template Theo Tung Loai Su Kien

Hoi nghi / Conference

• Speaker management: bio, slides, AV requirements
• Session scheduling voi parallel tracks

Tiec cuoi

• So do ban tiec (seating chart)
• Menu lua chon theo tung ban
• Wedding timeline chi tiet (tung phut)

Team Building

• Phan doi va tro choi, theo doi diem so cac team
• Safety checklist cho hoat dong outdoor

Le Khai Truong

• VIP guest protocol, kich ban cat bang
• Media list va press release

Ket Luan

Mot su kien thanh cong duoc xay dung tu hang nghin chi tiet nho duoc thuc hien dung thoi diem. Template Google Sheets quan ly su kien giup ban khong bo sot bat ky chi tiet nao, kiem soat ngan sach chat che va phoi hop team hieu qua.

Kham pha cac cong cu quan ly tai SheetStore.

Tai Nguyen Lien Quan

• Template Agile Sprint Board
• Template Dashboard Bao Cao
• Template Quan Ly Chi Tieu