Credit to tuan_anhbm from giaiphapexcel.com
Với ý đồ thiết lập 1 file Excel để dùng cho việc điều tiến độ thi công trong xây dựng.
Tôi đã tham khảo trước 1 số giải pháp điều tiến độ …, nhìn chung còn 1 số vấn đề cần phải xem xét như: Tính linh hoạt, tùy biến chưa cao: Không thể cho phép 1 công việc thi công gián đoạn mà phải liên tục với 1 lượng nhân công bất biến; Nhiều công thức đặt “nằm vùng” sẵn trong các ô dữ liệu mà ko sử dụng đến làm nặng file; Khó chèn dòng, chèn cột; Biểu đồ nhân công chưa hoàn hảo lắm, chưa có giải pháp để có thể điều chỉnh biểu đồ cho “đẹp” hơn theo ý người sử dụng nên sau khi điều xong biểu đồ thường bị “nhảy cà tưng” v.v…
Ý tưởng của mình là kết hợp các hàm cùng với sự hỗ trợ cúa vài module VBA để giải quyết vấn đề theo cách riêng đồng thời khắc phục các vấn đề nêu trên.
Hôm nay đã hoàn thành về cơ bản, mình post lên luôn để anh em nào quan tâm thì download về dùng thử và cho ý kiến mình hoàn thiện tiếp…——–Vì trong file có sử dụng macro nên nếu khi mở file mà có thông báo: ‘Security warning’ thì chọn ‘Enable macro’.
Tiếp theo: Trên ‘Tool bar’, bạn chọn ‘Tools’ > Macro > Security > chọn ‘Low’ > OK. Sau đó thoát và mở lại là OK.
1- Bổ sung chọn tên công việc từ listbox;2- Tự cảnh báo khi dữ liệu không hợp lý;3- Tự gán đơn vị công việc và định mức hao phí nhân công ngay sau khi chọn tên công việc;4- Sửa lại KL tính số nhân công thực tế (cột G, bảng TienDo).5- Hiệu chỉnh biểu đồ cho đẹp…
……Vài cải tiến nhỏ nữa:6- Trước đây danh sách công việc trong list (cột B, bảng tiến độ, sheet TienDo) là “list chết”, nghĩa là sẽ không thay đổi khi có sự mở rộng thêm danh sách công việc (mở rộng dữ liệu nguồn) trong bảng “TenCongViec”. Giờ đây cải tiến thành “list động”, nghĩa là nếu mở rộng (hay thu nhỏ) danh sách công việc trong bảng “TenCongViec” thì danh sách công việc trong bảng tiến độ sẽ tự động thay đổi theo.7- Nút “Xóa toàn bộ…” hiện diện trên bảng tính nhưng không có trên bản in.
DOWNLOAD
I don’t think the title of your article matches the content lol. Just kidding, mainly because I had some doubts after reading the article.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Can you be more specific about the content of your article? After reading it, I still have some doubts. Hope you can help me.
Thanks for sharing. I read many of your blog posts, cool, your blog is very good.
Thank you, your article surprised me, there is such an excellent point of view. Thank you for sharing, I learned a lot.
Your article helped me a lot, is there any more related content? Thanks!
how to treat heartworms with ivermectin: IverCare Pharmacy – IverCare Pharmacy
Mandiribet: Mandiribet – Live casino Mandiribet
jollibet login: jollibet app – Online gambling platform Jollibet
https://swertewin.life/# Swerte99 slots
Nha cai uy tin Vi?t Nam: GK88 – GK88
Bonus new member 100% Mandiribet Slot jackpot terbesar Indonesia Judi online deposit pulsa
Judi online deposit pulsa: Mandiribet login – Situs judi online terpercaya Indonesia
jollibet casino: Online casino Jollibet Philippines – jollibet app
Jackpot togel hari ini: Abutogel – Situs togel online terpercaya
Bandar togel resmi Indonesia: Link alternatif Abutogel – Situs togel online terpercaya
Online casino Jollibet Philippines Jollibet online sabong jollibet app
Link vao GK88 m?i nh?t: Rut ti?n nhanh GK88 – Dang ky GK88
Abutogel login: Bandar togel resmi Indonesia – Abutogel login
https://1winphili.company/# Online gambling platform Jollibet
Swerte99 casino walang deposit bonus para sa Pinoy: Swerte99 slots – Swerte99 bonus
Jiliko login: Jiliko casino walang deposit bonus para sa Pinoy – Jiliko slots
Swerte99 bonus Swerte99 slots Swerte99 slots
Link vao GK88 m?i nh?t: Link vao GK88 m?i nh?t – Link vao GK88 m?i nh?t
Beta138: Bandar bola resmi – Bonus new member 100% Beta138
Jiliko login: Jiliko bonus – Jiliko casino walang deposit bonus para sa Pinoy
jollibet Online casino Jollibet Philippines Jollibet online sabong
Kazino bonuslar? 2025 Az?rbaycan: Qeydiyyat bonusu Pinco casino – Pinco r?smi sayt
Link alternatif Beta138: Slot gacor Beta138 – Bandar bola resmi
Abutogel login: Link alternatif Abutogel – Bandar togel resmi Indonesia
https://gkwinviet.company/# Link vao GK88 m?i nh?t
Slot jackpot terbesar Indonesia: Live casino Mandiribet – Slot jackpot terbesar Indonesia
Bandar bola resmi Situs judi resmi berlisensi Promo slot gacor hari ini
Online gambling platform Jollibet: Online gambling platform Jollibet – Online betting Philippines
jollibet casino: jollibet – Online casino Jollibet Philippines
Khuy?n mai GK88: Rut ti?n nhanh GK88 – Nha cai uy tin Vi?t Nam
Link alternatif Mandiribet: Bonus new member 100% Mandiribet – Live casino Mandiribet
Bonus new member 100% Mandiribet Situs judi online terpercaya Indonesia Bonus new member 100% Mandiribet
Slot game d?i thu?ng: Khuy?n mai GK88 – Slot game d?i thu?ng
https://betawinindo.top/# Bonus new member 100% Beta138
Dang ky GK88: Tro choi n? hu GK88 – Ca cu?c tr?c tuy?n GK88
jollibet login: jollibet app – Online betting Philippines
Jiliko app: Jiliko login – maglaro ng Jiliko online sa Pilipinas
Situs togel online terpercaya Situs togel online terpercaya Bandar togel resmi Indonesia
Jiliko casino: Jiliko casino – jilwin
Bonus new member 100% Beta138: Situs judi resmi berlisensi – Promo slot gacor hari ini
Online casino Jollibet Philippines: Online casino Jollibet Philippines – jollibet casino
Swerte99 online gaming Pilipinas Swerte99 bonus Swerte99 casino walang deposit bonus para sa Pinoy
https://mandiwinindo.site/# Situs judi online terpercaya Indonesia
Swerte99 slots: Swerte99 bonus – Swerte99
Swerte99 app: Swerte99 login – Swerte99 slots
Ca cu?c tr?c tuy?n GK88: Tro choi n? hu GK88 – Casino online GK88
Login Beta138 Beta138 Link alternatif Beta138
Online casino Jollibet Philippines: jollibet login – Online gambling platform Jollibet
Indian Meds One: Indian Meds One – Indian Meds One
Mexican Pharmacy Hub: medication from mexico pharmacy – Mexican Pharmacy Hub
http://indianmedsone.com/# Indian Meds One
mirtazapine online pharmacy online medicine to buy MediDirect USA
xenical dubai pharmacy: MediDirect USA – MediDirect USA
indian pharmacy: Indian Meds One – indian pharmacy
Mexican Pharmacy Hub: mexico pharmacies prescription drugs – medicine in mexico pharmacies
indianpharmacy com: Online medicine order – Indian Meds One
best online pharmacy india: Indian Meds One – Online medicine order
Indian Meds One: indian pharmacy online – Indian Meds One
percocet online pharmacy no prescription Confido MediDirect USA
MediDirect USA: MediDirect USA – MediDirect USA
https://mexicanpharmacyhub.shop/# Mexican Pharmacy Hub
MediDirect USA: online pharmacy legal – MediDirect USA
MediDirect USA: buy synthroid online pharmacy – asda pharmacy fluconazole
Mexican Pharmacy Hub Mexican Pharmacy Hub order azithromycin mexico
Indian Meds One: pharmacy website india – Indian Meds One
Indian Meds One: Indian Meds One – Indian Meds One
boots pharmacy xenical: MediDirect USA – MediDirect USA
community pharmacy audit methotrexate: MediDirect USA – MediDirect USA
http://mexicanpharmacyhub.com/# Mexican Pharmacy Hub
MediDirect USA MediDirect USA MediDirect USA
zithromax pharmacy price: online viagra pharmacy – MediDirect USA
Indian Meds One: Indian Meds One – Indian Meds One
Indian Meds One: indian pharmacy online – Indian Meds One
online pharmacy india: Online medicine order – Indian Meds One
propranolol online pharmacy: the drug store pharmacy – MediDirect USA
Mexican Pharmacy Hub Mexican Pharmacy Hub Mexican Pharmacy Hub
Indian Meds One: top online pharmacy india – india pharmacy mail order
http://medidirectusa.com/# MediDirect USA
trusted mexican pharmacy: zithromax mexican pharmacy – Mexican Pharmacy Hub
buying prescription drugs in mexico online: mexico pharmacies prescription drugs – purple pharmacy mexico price list
adderall online pharmacy: viagra online us pharmacy – MediDirect USA
cheap mexican pharmacy Mexican Pharmacy Hub Mexican Pharmacy Hub
united pharmacy finpecia: pharmacy error methotrexate – us pharmacy viagra prices
diazepam online pharmacy: women’s international pharmacy – escrow pharmacy online
Online medicine home delivery: Indian Meds One – Indian Meds One
п»їmexican pharmacy get viagra without prescription from mexico cheap mexican pharmacy
https://indianmedsone.shop/# Indian Meds One
online pharmacy tegretol xr: MediDirect USA – australia online pharmacy free shipping
pharmacy stuff store: MediDirect USA – MediDirect USA
Indian Meds One: mail order pharmacy india – Indian Meds One
giant pharmacy store hours: MediDirect USA – MediDirect USA
SildenaPeak: SildenaPeak – 3 viagra pills
cialis indien bezahlung mit paypal: Tadalify – Tadalify
Tadalify cialis w/dapoxetine Tadalify
cost of cialis for daily use: Tadalify – Tadalify
http://tadalify.com/# where to get generic cialis without prescription
tadalafil cheapest price: paypal cialis payment – Tadalify
Tadalify: tadalafil tablets erectafil 20 – Tadalify
cheap cialis by post Tadalify Tadalify
SildenaPeak: SildenaPeak – SildenaPeak
special sales on cialis: when does tadalafil go generic – Tadalify
Compare Kamagra with branded alternatives Affordable sildenafil citrate tablets for men Affordable sildenafil citrate tablets for men
Fast-acting ED solution with discreet packaging: Fast-acting ED solution with discreet packaging – Affordable sildenafil citrate tablets for men
SildenaPeak: buy female viagra online cheap – SildenaPeak
https://tadalify.shop/# what is the difference between cialis and tadalafil?
KamaMeds: Kamagra oral jelly USA availability – Compare Kamagra with branded alternatives
buy sildenafil online australia: generic viagra online australia – SildenaPeak
Men’s sexual health solutions online KamaMeds Kamagra reviews from US customers
viagra buy uk online: cheap viagra canada free shipping – SildenaPeak
Non-prescription ED tablets discreetly shipped: Compare Kamagra with branded alternatives – KamaMeds
viagra by pfizer: SildenaPeak – SildenaPeak
SildenaPeak: SildenaPeak – where can i get viagra for women
Tadalify oryginal cialis Tadalify
https://sildenapeak.shop/# SildenaPeak
Tadalify: Tadalify – Tadalify
Tadalify: Tadalify – cialis superactive
SildenaPeak: viagra generic australia – viagra professional canada
sildenafil india buy SildenaPeak SildenaPeak
Tadalify: cialis pill – cialis information
on line viagra: order viagra united states – sildenafil uk best price
Men’s sexual health solutions online: KamaMeds – ED treatment without doctor visits
https://sildenapeak.com/# australia viagra cost
sildenafil generic over the counter: sildenafil tablets uk – SildenaPeak
buy online viagra capsules buy viagra uk paypal SildenaPeak
Kamagra reviews from US customers: ED treatment without doctor visits – KamaMeds
SildenaPeak: viagra 100mg india price – cheap viagra for sale canada
ED treatment without doctor visits: Fast-acting ED solution with discreet packaging – Affordable sildenafil citrate tablets for men
viagra over the counter cost: SildenaPeak – buy sildenafil online cheap
ED treatment without doctor visits Online sources for Kamagra in the United States Sildenafil oral jelly fast absorption effect
http://tadalify.com/# buy cialis online overnight delivery
sildenafil 30 mg: buy viagra cheap – SildenaPeak
Tadalify: canadian pharmacy tadalafil 20mg – Tadalify
Compare Kamagra with branded alternatives: KamaMeds – Kamagra oral jelly USA availability
Men’s sexual health solutions online Kamagra reviews from US customers Fast-acting ED solution with discreet packaging
does cialis lower your blood pressure: tadalafil generic cialis 20mg – Tadalify
SildenaPeak: SildenaPeak – SildenaPeak
Non-prescription ED tablets discreetly shipped: Fast-acting ED solution with discreet packaging – Kamagra reviews from US customers
https://tadalify.com/# Tadalify
KamaMeds: Kamagra reviews from US customers – Fast-acting ED solution with discreet packaging
Fast-acting ED solution with discreet packaging Online sources for Kamagra in the United States Compare Kamagra with branded alternatives
order generic cialis: Tadalify – Tadalify
best viagra in usa: cheap viagra india – SildenaPeak
KamaMeds: Safe access to generic ED medication – Fast-acting ED solution with discreet packaging
when does tadalafil go generic buy cialis/canada Tadalify
SildenaPeak: SildenaPeak – SildenaPeak
viagra soft tabs: SildenaPeak – where can i buy cheap viagra
https://kamameds.com/# Non-prescription ED tablets discreetly shipped
KamaMeds: Compare Kamagra with branded alternatives – ED treatment without doctor visits
cialis alternative: active ingredient in cialis – Tadalify
cialis side effects forum: Tadalify – Tadalify
buy tadalafil no prescription: cialis generics – buy cialis in toronto
SildenaPeak: SildenaPeak – cheap sildenafil tablets uk
Compare Kamagra with branded alternatives Compare Kamagra with branded alternatives ED treatment without doctor visits
cialis indications: buy cialis without doctor prescription – cialis free trial offer
SildenaPeak: viagra substitutes – SildenaPeak
Tadalify: cialis interactions – what does a cialis pill look like
Tadalify Tadalify buy cialis with american express
Sildenafil oral jelly fast absorption effect: Men’s sexual health solutions online – Online sources for Kamagra in the United States
https://sildenapeak.shop/# SildenaPeak
where to get clomid without insurance: FertiCare Online – FertiCare Online
SteroidCare Pharmacy prednisone 30 SteroidCare Pharmacy
ivermectin pour on for cats: cost of stromectol – IverGrove
SteroidCare Pharmacy: generic prednisone 10mg – SteroidCare Pharmacy
compare prednisone prices: SteroidCare Pharmacy – SteroidCare Pharmacy
CardioMeds Express: lasix generic – lasix generic
IverGrove: stromectol order – IverGrove
ivermectin dosage cats oral IverGrove ivermectin equine
prednisone for sale without a prescription: SteroidCare Pharmacy – buy prednisone canada
where can i buy cheap clomid without a prescription: buying clomid tablets – where buy clomid pills
india ivermectin: IverGrove – IverGrove
where can i buy cheap clomid without insurance: can i buy clomid no prescription – FertiCare Online
CardioMeds Express: buy lasix online – lasix for sale
buy furosemide online: CardioMeds Express – furosemide 40mg
https://trustedmedsdirect.com/# TrustedMeds Direct
IverGrove: ivermectin for head lice – ivermectin resistance
FertiCare Online: FertiCare Online – FertiCare Online
ivermectin covid 19 mayo clinic: IverGrove – ivermectin study
CardioMeds Express: lasix uses – CardioMeds Express
order amoxicillin uk: over the counter amoxicillin canada – amoxicillin 500mg price in canada
how to buy cheap clomid price: clomid online – FertiCare Online
http://steroidcarepharmacy.com/# prednisone 5093
SteroidCare Pharmacy SteroidCare Pharmacy SteroidCare Pharmacy
FertiCare Online: where to buy generic clomid without dr prescription – FertiCare Online
amoxicillin script: TrustedMeds Direct – cost of amoxicillin prescription
can i purchase clomid without prescription: buying generic clomid without prescription – can i purchase clomid tablets
prednisone 20mg prescription cost SteroidCare Pharmacy prednisone 10 mg brand name
CardioMeds Express: CardioMeds Express – lasix 40mg
viagra generico recensioni: acquistare viagra generico online – esiste il viagra generico in farmacia
farmacia online: ForzaIntima – п»їFarmacia online migliore
viagra pfizer 25mg prezzo viagra generico recensioni viagra online spedizione gratuita
viagra generico recensioni: consegna discreta viagra in Italia – viagra online in 2 giorni
Farmacie online sicure: soluzioni rapide per la potenza maschile – Farmacie on line spedizione gratuita
http://potenzafacile.com/# viagra originale in 24 ore contrassegno
Farmacie online sicure: kamagra originale e generico online – migliori farmacie online 2024
farmacie online affidabili cialis online Italia farmacia online senza ricetta
migliori farmacie online 2024: consegna rapida e riservata kamagra – migliori farmacie online 2024
acquisto farmaci con ricetta: kamagra oral jelly spedizione discreta – п»їFarmacia online migliore
Farmacia online piГ№ conveniente: acquisto discreto di medicinali in Italia – Farmacia online piГ№ conveniente
viagra 50 mg prezzo in farmacia viagra generico a basso costo viagra naturale
farmacie online sicure: PilloleSubito – farmacie online affidabili
https://forzaintima.shop/# kamagra online Italia
farmaci senza ricetta elenco: farmacie online autorizzate elenco – Farmacie online sicure
top farmacia online soluzioni rapide per la potenza maschile Farmacie online sicure
top farmacia online: kamagra oral jelly spedizione discreta – acquistare farmaci senza ricetta
esiste il viagra generico in farmacia: sildenafil senza ricetta – pillole per erezioni fortissime
miglior sito per comprare viagra online: pillole per erezione immediata – farmacia senza ricetta recensioni
farmacie online autorizzate elenco acquisto discreto di medicinali in Italia farmacie online sicure
Farmacia online piГ№ conveniente: kamagra online Italia – acquisto farmaci con ricetta
http://pillolesubito.com/# top farmacia online
MapleMeds Direct: ambien online pharmacy review – MapleMeds Direct
reputable indian pharmacies: reputable indian pharmacies – BharatMeds Direct
BharatMeds Direct BharatMeds Direct BharatMeds Direct
india pharmacy mail order: indian pharmacy – top online pharmacy india
mexican pharmacies online: MapleMeds Direct – metronidazole uk pharmacy
http://bordermedsexpress.com/# BorderMeds Express
kaiser permanente online pharmacy: baclofen river pharmacy – target pharmacy lipitor price
gabapentin mexican pharmacy: BorderMeds Express – BorderMeds Express
MapleMeds Direct MapleMeds Direct generic cialis pharmacy
MapleMeds Direct: MapleMeds Direct – legit online pharmacy provigil
ritalin online pharmacy reviews: MapleMeds Direct – MapleMeds Direct
finasteride mexico pharmacy: order kamagra from mexican pharmacy – best mexican pharmacy online
BharatMeds Direct reputable indian online pharmacy pharmacy website india
http://bordermedsexpress.com/# buying from online mexican pharmacy
modafinil online pharmacy: online pharmacy viagra prescription – ultram us pharmacy
BharatMeds Direct: best india pharmacy – buy prescription drugs from india
india online pharmacy: best india pharmacy – BharatMeds Direct
viagra pharmacy uk giant pharmacy mebendazole boots pharmacy
BorderMeds Express: mexico pharmacies prescription drugs – BorderMeds Express
indian pharmacy: Online medicine home delivery – best online pharmacy india