HNG DN S DNG PHN MM LP GI D THU GI XY DNG

Tc gi: ThS. Nguyn Th Anh, admin www.giaxaydung.vn Vin Kinh t xy dng, B Xy dng Ks. Bi Vn Thnh, Ks. Phan ng Dng v cc ng nghip ti Cng ty CP Gi Xy Dng Hng dn ny c th cha y mong bn c thng cm. Chng ti cng rt mong mun nhn c cc kin ng gp xy dng hon thin hn. Mi gp sa i, b sung xin ghi trc tip vo hng dn v gi v a ch theanh@giaxaydung.com Xin chn thnh cm n.

MC LCMC LC ............................................................................................................................. 2 I. GII THIU V PHN MM ....................................................................................... 3 II. CC U IM CA PHN MM D THU GXD .................................................. 3 III. MT S QUY C.................................................................................................... 5 IV. CI T PHN MM ............................................................................................... 5 1. B ci phn mm........................................................................................................ 5 2. Ci t phn mm....................................................................................................... 5 V. KHI NG V LM QUEN VI PM D THU GXD .......................................... 7 1. Khi ng phn mm ................................................................................................. 7 2. Lm quen vi phn mm D thu GXD.................................................................... 11 3. Tm hiu thanh cng c v menu ca phn mm D thu GXD ................................ 12 VI. BT U LM H S D THU MI................................................................. 16 1. To file D thu GXD mi....................................................................................... 16 2. Lu file d thu vo cng...................................................................................... 16 3. M file d thu ang lm d..................................................................................... 16 4. Cc thng tin ban u ............................................................................................... 17 5. i tn cng trnh, h s nhn cng, my, nh mc chi ph chung, thu nhp chu thu tnh trc ..................................................................................................................... 18 6. Np c s d liu cho phn mm.............................................................................. 19 VII. S DNG PHN MM D THU LP GI D THU................................ 21 1. Tnh n gi chi tit khi bng khi lng mi thu c m hiu cng vic............. 21 2. Lp gi d thu khi cha bit m hiu cng vic....................................................... 22 3. Tnh ton o bc khi lng..................................................................................... 31 VIII. NH DNG, DN TRANG, NH S TRANG, IN H S D THU............ 34 1. nh s trang ........................................................................................................... 34 2. In h s d thu........................................................................................................ 36 IX. MT S TIN CH................................................................................................... 36 1. Chuyn xi mng t PC30 v PC40 hoc ngc li.................................................... 36 2. Sp xp bng vt liu................................................................................................ 38 3. Bng gi ca my ....................................................................................................... 40 4. B gi ca my........................................................................................................... 40 X. LM VIC VI C S D LIU NH MC, N GI, GVT, GCM.................. 42 1. B sung file c s d liu ......................................................................................... 42 2. M file c s d liu sa i, b sung.................................................................. 42 3. B sung thm d liu................................................................................................ 44

I. GII THIU V PHN MM Phn mm D thu GXD do ThS. Nguyn Th Anh, P.Gim c Trung tm thng tin Vin Kinh t xy dng B Xy dng, admin www.giaxaydung.vn v cc ng nghip, nhn vin cng ty CP Gi Xy Dng nghin cu, xy dng v pht trin. Bn cnh s say m nghin cu v tm huyt vi ngh nghip, phn mm D thu GXD l sn phm kt tinh ca: + Cc kin thc chuyn mn su c c ca tc gi khi tham gia cng tc nghin cu son tho cc vn bn quy phm php lut v u t xy dng cng trnh. + Kin thc v kinh nghim v c s d liu nh mc, n gi, gi ca my, bng lng nhn cng, tnh gi vt liu n hin trng; + Kin thc v kinh nghim t vn u t xy dng cng trnh ca hng trm cng trnh, d n ln nh; + Kin thc v kinh nghim c kt t vic tham gia ging dy hng nghn hc vin lp d ton d thu, thanh quyt ton; + Kin thc, kinh nghim c kt t cc bi vit h tr, gii p chuyn mn trn din n www.giaxaydung.vn...; + Kt hp vi s tr gip, gp hon thin v chuyn mn ca rt nhiu ng nghip, chuyn gia t nhiu cc n v Ch u t, T vn, Nh thu xy dng v c quan qun l trn t nc Vit Nam; + Phn mm D thu GXD c cc nhn vin cng ty CP Gi Xy Dng lp trnh, hon thin cng vi cc chuyn gia lp trnh rt gii v cc cng ty gia cng phn mm c uy tn ti Vit Nam thng qua cc hp ng gia cng phn mm. II. CC U IM CA PHN MM D THU GXD 1. B ci gn nh: Gi, nhn v lu tr d dng qua mng Internet, qua email, tit kim khng gian lu tr (USB, cng). 2. File sn phm cng gn nh: Do c nghin cu ti u d liu, nn file rt nh. H s lm ra cng gi i (cho bn chm thu, cho i tc), sao chp hay lu tr u d dng. 3. Tng thch vi: WinXP, Win Vista, Win7 - Office 2003, 2007 v 2010. 4. Ci t nhanh v d dng: Thi gian ci t thng khng qu 10 giy. 5. Chy trc tip trn Excel (2003, 2007, 2010). S dng kt hp c tt c cc tnh nng mnh m ca Excel: hm Vlookup, Index, Sum, If, Sumif v cc chc nng nh Autofilter, Sort, Copy, Paste nn nng sut lao ng cao, em li u th v thi gian hon thin v np h s thu. Ngi s dng bit Excel khng mt nhiu cng hc s dng phn mm. 6. Tc x l d liu nhanh, phn mm chy nh nhng, n nh: Do phn mm c lp trnh bng ngn ng bc thp C++ (gn st ngn ng my) nn tc x l nhanh, kt hp vi VBA + Macro4 trong Excel. 7. File sn phm h s thu chnh l file Excel. Khng phi kt xut sang Excel nh phn mm khc. Gi file sang my tnh ca Ch u t, T vn chm thu

khng ci D thu GXD vn dng Excel m xem, in n, sa cha, copy, cut v paste d liu d dng. 8. Kt xut bng tnh gi vt liu d thu t ng. 9. Tch hp bng lng nhn cng v bng gi ca my: cc loi nhn cng, my v thit b thi cng theo cc nh mc hin hnh. 10. Tnh nng b gi ca my (b nhin liu, b tin lng) mnh m, c o. C s d liu gi ca my cc a phng: B d liu ny do Cng ty CP Gi Xy Dng nghin cu, xy dng kt hp vi hng dn phng php b gi ca my. 11. Cc d liu tnh ton c kt ni ch yu bng a ch trc tip (hn ch dng hm Vlookup) nn tin cho vic kim tra. 12. In n h s thu p, chun v nhanh. Ngi s dng lm xong h s thu hu nh ch cn bm lnh in l xong. Nu mun chnh sa th thao tc bng cng c ca Excel rt d dng. 13. B d liu chun xc v c cp nht thng xuyn, download d dng, d liu - thng tin mi lc mi ni: Giaxaydung.vn c nhiu kinh nghim v lu tr v truyn ti d liu (qua din n v th vin). D ngi vn phng, bn ch u t, vn phng nh thu, cng trng hay qun c ph bn u c th download d dng file CSDL v chy phn mm. 14. Ngi lp gi d thu d dng qun l d liu u thu ni b ca mnh: File c s d liu m (khng kha hay m ha), d liu nh mc, n gi, gi vt t, gi ca my, ph lc va, t in vt t lu tr dng .csv c th m bng Excel chnh sa, thm bt d dng. 15. Tra cu nh mc, n gi theo t kha rt d dng, trc quan, n gin: G trc tip m hiu, g t c trong tn cng tc, g gi tra m hiu. 16. Kh nng ty bin, chnh sa giao din d dng: Bn ch vic m file template DuthauGXD.xlt ra v nh dng mu sc, font ch, ba, logo, thuyt minh theo form IZO ca cng ty mnh sau lu li. iu ny cho c cng ng tham gia to theme mu D thu v chia s. 17. C s d liu v file h s c Font ch dng bng m Unicode: Khng cn kh khn do trao i gia cng ty, chi nhnh, vn phng Min Bc dng bng m TCVN3 vi b phn Min Nam dng bng m VNI. 18. D liu - thng tin mi lc mi ni: Giaxaydung.vn c nhiu kinh nghim v lu tr v truyn ti d liu (qua din n v th vin). D ngi vn phng, bn ch u t, vn phng nh thu, cng trng hay qun c ph bn u c th download d dng file CSDL v chy. 19. Chun xc v chuyn mn, thut ton: Tc gi tham gia vo cng tc nghin cu, son tho cc vn bn qun l nh nc v lp v qun l chi ph, tham gia ging dy cc lp KSG, d ton, d thu; tham gia nghin cu sa i, b sung cc tp nh mc d ton XDCT, tham gia lm nhiu b n gi a phng; tham gia chm thu nhiu gi thu; tham gia u thu nhiu cng trnh khi lm cn doanh nghip thi cng c s gp hon thin ca cc ng nghip lm h s thu.

20. Cc lp hc lp d ton, lp h s d thu, nh gi xy dng v cc phn mm chuyn ngnh rt bi bn, chuyn nghip. 21. S h tr chia s kinh nghim, d liu, thng tin ca c cng ng ngi lm ngh trn din n www.giaxaydung.vn. 22. V rt nhiu u im, tnh nng hay na i bn khm ph. III. MT S QUY C Quy c 1: cho ngn gn, nu ni kch tc l nhn chut tri mt ln, khi no nhn chut phi th s ni r l kch chut phi, kch p c ngha l nhn chut tri hai ln lin tip. Quy c 2: Phn mm lp gi d thu Gi Xy Dng (gi tt l D thu GXD) mc nh ci t ti th mc Du thau GXD ca C. Quy c 3: ch rng bn cn thc hin ln lt cc thao tc kch chut hoc chn th s dng du /. V d: M C, ri vo th mc Du thau GXD v kch p vo tp tin (file) DuthauGXD.exe th s c vit nh sau: C: / Du thau GXD / DuthauGXD.exe. IV. CI T PHN MM 1. B ci phn mm ci phn mm D thu GXD bn cn c file ci t. File ci t c cung cp bi Cng ty Gi Xy Dng, bn c th nhn file ci t bng mt trong cc cch sau: - Truy cp website www.giaxaydung.vn tm n mc phn mm D thu GXD ti b ci v my tnh ca bn. - File ci t c trong a CD c cung cp cho cc hc vin lp hc nghip v do Cng ty Gi Xy Dng t chc. - Lin h Cng ty C phn Gi Xy Dng c hng dn v gi file ci t (T/Fax: 04.35682482 / 04.35682483 hoc email phanmem@giaxaydung.vn). 2. Ci t phn mm Khi ti c b ci v my tnh bn thc hin ci t theo cc bc sau: Bc 1: Kch p vo SetupDuthauGXD.exe, bn s gp hp thoi nh hnh 1. Bc 2: Bm vo nt i tip s n mn hnh chn th mc ci t nh hnh 2.

Hnh 1

Hnh 2

Bn chn Ti chp nhn tha thun ny v bm vo nt i tip, khi s gp mn hnh nh hnh 3:

Hnh 3 Mc nh phn mm s ci vo th mc Du thau GXD C. Nu khng mun ci , bn c th ch nh v tr ci t bt k, khi kch vo nt Duyt ch n v tr bn mun ci. Tuy nhin, theo tc gi bn nn ci theo ng dn mc nh s tt hn. Bc 3: tin s dng bn chn To biu tng desktop ri kch nt i tip s chuyn sang hnh 5.

Hnh 4

Hnh 5

Bc 4: Cc thng tin hon tt, gi kch vo Ci t. Nu i bn hy bm vo nt Lui li sa li thng tin. Sau vi giy bn s thy thng bo ci t thnh cng nh hnh 6. Nu bc ny bn nguyn du tch Thc thi D thu GXD v kch Hon tt th phn mm s chy.

Hnh 6 Bc 5: Kch vo nt Hon tt kt thc vic ci t, phn mm D thu GXD s khi ng ln u tin. V. KHI NG V LM QUEN VI PM D THU GXD 1. Khi ng phn mm C th khi ng lp gi d thu Gi Xy Dng theo mt trong cc cch sau: - Cch 1: Kch p chut vo biu tng phn mm trn mn hnh Desktop nh hnh 7.Hnh 7

Hnh 7 - Cch 2: Kch chut vo file DuthauGXD.exe trong th mc ci t nh hnh 8.

Hnh 8

-

Cch 3: Kch vo nt Start ca Windows v tm n mc D thu GXD v kch vo n khi ng phn mm. Nh hnh 9 (Windows 7).

Hnh 9

1.1. Nhp kho mm cho phn mm Kho mm l mt dy s c sinh ra t m hiu cng ca my tnh c ci t. Kho mm ny s c Cng ty Gi Xy Dng cung cp cho ngi s dng. Ln u tin chy phn mm, s xut hin thng bo nh hnh 10.

Hnh 10

Bn dng chut nh du dy s trn thng bo (V d trong Hnh 10 l dy s CB874-30FCB-87430-FCB51-B62FB) v gi dy s trn ti a ch daotao@giaxaydung.com to m kho kch hot phn mm, hoc bn lin h Cng ty Gi Xy Dng s in thoi 04.35682482 c m s dng. Sau bm OK v tm thi ng chng trnh li. Cng ty Gi Xy Dng s cn c vo dy s bn gi to m kha kch hot phn mm v gi li cho bn (qua email, qua th hoc cc phng tin khc). Khi c nhn c m kho do Cng ty Gi Xy Dng cung cp th bn khi ng li phn mm v nhp m kho kch hot vo. V d: Trong hnh 11, ngi s dng c cung cp m kch hot l EA63F-C861D-851FB-830B8-41EA6:

Hnh 11 Sau khi nhp m kho kch hot v bm OK, nu thnh cng phn mm s khi ng Excel v tch hp thanh cng c bin tri mn hnh v menu nh sau:

Gi gip bn tra cu n gi

Ch : - Phn mm s kim tra thi gian h thng. Bn cn kim tra thi gian h thng khi ci t (a v ng thi gian thc bn ci phn mm vo ngy 09/02/2011 th thi gian trong my tnh phi ng nh vy), sau mi nhp m nu khng phn mm s khng chy. - C th khi nhp key phn mm s khng nhn. Bn cn ci t thm mt s th vin cho Windows. Bn tm file vcredist_x86.exe c trong th mc cha b ci i cng a CD v m file ra ci t vo my ri mi nhp key. Bn cng c th download file t ng dn sau: http://download.microsoft.com/download/d/d/9/dd9a82d0-52ef-40db-8dab795376989c03/vcredist_x86.exe - Nu vn khng nhn key nhp vo, bn cn g b bn Excel ang dng v ci mt bn khc. Mt s hc vin tp H Ch Minh khi dng Excel 2007 ci khng c, h ci li Excel 2010 v nhp c key kch hot phn mm. - Trng hp khi ng c thng bo l D thu GXD ang chy, nhng khng chy c. y l do my tnh b trc trc hoc phn mm b tt bt thng. Bn vo th mc ci phn mm (thng l C:/Du thau GXD) v xa file Open.ini i, sau chy li phn mm bnh thng. - C trng hp nhp key phn mm khng nhn, yu cu nhp li key. Bn cn g b phn mm, khi ng li my tnh v ci t li phn mm, sau nhp li key kch hot. - Cng c th bn gi m kch hot sai nn Cng ty Gi Xy Dng to kha cho bn sai, hy copy li m v gi li cho Cng ty cp li key.

1.2. Thit lp kho cng cho phn mm Khi chn gii php kho cng, bn s c cung cp b phn mm i cng kho cng (tng t nh thit b lu tr USB) c dng nh trong hnh sau:

Trong trng hp bn la chn gii php kho cng, th bn khng cn s dng kho mm nh trn, bn ch vic cm kho cng vo cng USB ca my tnh, nhp m kho c cung cp cng kho cng vo c th s dng phn mm. Phn mm c c ch t ng kim tra, khi pht hin c kho cng cm vo my tnh l chy. u im: Ch cn mua mt kho cng, ci t phn mm nhiu my tnh, khi my no cn dng D thu GXD c th rt kho cng cm vo my chy. V d: Mt ngi c 3 my tnh (my tnh c quan, my tnh nh v laptop) ch cn mua mt kho cng v ci phn mm c 3 my tnh khi cn dng my no th cm kho cng vo my . cng trng, sang bn A, sang t vn, i cng tc, i du lch bn c th mang theo laptop, kt ni Internet truy cp giaxaydung.vn hoc ln email (bn c th lu tr b ci nh gn ca phn mm trn email) ly b ci xung, ci t v cm kha cng s dng phn mm lm vic. Nhc im: - Kho cng d b tht lc, n trm. - Kho cng c th qun trong ti qun/o v cho vo my git v b hng v t. - Phi mang theo kha cng bn mnh. 2. Lm quen vi phn mm D thu GXD D thu GXD tch hp vo Excel, phn mm D thu GXD hot ng c trong my phi c ci Excel (tt nht l Excel 2003, cng c th l Excel 2007, 2010). Khi khi ng D thu GXD s kch hot phn mm Excel sau thm mt thanh cng c v 4 menu (D thu GXD, Tin ch, Tr gip v D liu) vo mn hnh lm vic ca Excel. Nu s dng Excel 2003, sau khi khi ng mn hnh c dng nh sau:

- Thanh cng c v menu ca phn mm tch hp trong Excel. - Tt c mi thnh phn cn li l ca Excel. Phn mm D thu GXD b sung mt s cng c chuyn dng lp gi d thu vo Excel. - Bn vn c th tn dng tt c mi cng c sn c vi tnh nng mnh m ca Excel kt hp vi cng c b sung nng cao hiu sut cng vic lp gi d thu.

Ch 1: Nu s dng Excel 2007 hoc 2010, th mn hnh c th khng nh trn. Bn cn phi kch vo menu Add-in ca Excel th mi thy cc nt lnh v menu ca phn mm. Ch 2: File gi d thu to ra t phn mm l file Excel (c ui .xls nn bn khng phi xut sang Excel). Chnh n l Excel ri, sau khi ng phn mm, bn c th m file bng Excel chnh sa, in n. 3. Tm hiu thanh cng c v menu ca phn mm D thu GXD 3.1. Thanh cng c Thanh cng c cha cc nt lnh thng dng trong phn mm. Cc lnh ny cng t trong cc menu ca chng trnh cng vi rt nhiu lnh, cng c khc.

1 2 3 4 5 6 7

1. M file d thu: Nt ny dng m file d thu lm hoc ang lm d dang lm tip. Khng dng nt Open ca Excel. 2. Ghi file d thu: Lu file d thu vo a. Kch vo nt Save ca Excel cng cho kt qu tng t. 3. To file d thu mi: To mt file h s lp gi d thu mi. 4. La chn CSDL: Ch ng dn ti file c s d liu n gi, gi vt t, nh mc, gi ca my, t in vt t, ph lc va. 5. Sp xp vt t d thu: Sp xp vt t (VL, NC, MTC) theo vn Anphabel d nhp gi, d tra cu. 6. nh li STT bng GCT: nh li m n gi. VD: DG1, DG2 hoc CT1, CT2 hoc Dg1, Dg2 7. Chi ph vn chuyn vt t d thu: Hin bng tnh gi vt liu ti hin trng

3.2. Cc menu ca phn mm 3.2.1. Menu D thu GXD

Tn lnh To file d thu mi... M file d thu...

Phm tt Ctrl+M Ctrl+O

ngha khi kch vo lnh To mt file h s lp gi d thu mi Nt ny dng m file d thu lm hoc ang lm d dang lm tip Nhp cc thng tin tn cng trnh, hng mc, ch u t

i tn cng trnh/hng mc... La chn CSDL...

Ctrl+Shift+D

Ch ng dn ti file c s d liu n gi, gi vt t, nh mc, gi ca my, t in vt t, ph lc va nh li m n gi

nh s th t bng GCT

Ctrl+Shift+A

Tn lnh Chi ph vn chuyn vt liu d thu Sp xp theo th t sheet VL

Phm tt

ngha khi kch vo lnh Hin bng tnh gi vt liu ti hin trng Sp xp VL, NC, MTC theo vn Anphabel d nhp gi, d tra cu. Tra cng lc nhiu m hiu n gi trong sheet DMCV a vo sheet PT DGCT Tnh ton gi ca my cc my c trong PT DGCT Phn tch n gi kho st, vt liu va

Chn n gi vo bng phn tch n gi chi tit Kt xut bng gi ca my Cc ty chn

3.2.2. Menu Tin ch

Tn lnh Bng tnh Bu GCM TT06/ Bu GCM Tnh li ton b din gii

Phm tt

ngha khi kch vo lnh Chuyn i gia tnh b gi ca my theo Thng t 06/2010/TT-BXD v b gi ca my thng thng

Ctrl+E

Tnh ton li cc dng khi lng trong sheet TH GDT nu copy d liu t bn ngoi vo phn mm i n v tnh cho cng vic, ng thi i gi tr nh mc

i n v cho cng vic Chuyn i ph lc va Hin danh mc thp Hin / n din gii khi lng

Ctrl+F1

Chuyn i ph lc va Hin th danh mc thp

Alt+Down

Hin cc dng tnh khi lng hoc n i Hin / n phn tnh cc chi ph theo t l (chi ph ui) trong n gi

Hin / n cc dng chi ph trong bng GCT

3.2.3. Menu Tr gip (Help)

Tn lnh Hng dn s dng D thu GXD Hng dn lp gi d thu Hng dn o bc khi lng D thu GXD Online

ngha khi kch vo lnh

M file hng dn s dngM file l thuyt hng dn lp gi d thu M file l thuyt hng dn o bc khi lng

M trang phn trao i kinh nghim, gii quyt tnh hung v phn mm trn website giaxaydung.vn

Cc tnh hung s dng phn mm Th vin gi xy dng Gii thiu v chng trnh

M file cc tnh hung s dng phn mm

M th vin Gi Xy Dng www.giaxaydung.vn/thuvien Gii thiu v phn mm, tc gi, phin bn, logo

3.2.4. Menu D liu

Menu ny cha cc lnh cho php m cc file C s d liu v hin th cc d liu xem, tra cu, chnh sa

Tn lnh n gi xy dng Gi vt t xy dng Ph lc va T in vt t

ngha khi kch vo lnh

M file n gi (VD: DG Ha Noi.csv) M file Gi vt t (VD: GVT Ha Noi.csv) M file Ph lc va (VD: PLV.csv) M file n gi (VD: DG Ha Noi.csv)

Tn lnh nh mc Gi ca my

ngha khi kch vo lnh

M file nh mc (VD: DM1776.csv) M file Gi ca my (VD: GCM Ha Noi.csv)

VI. BT U LM H S D THU MI 1. To file D thu GXD mi Kch vo nt To file D thu mi (hoc t menu D thu GXD chn To file d thu mi. Khi s xut hin mu h s gi d thu trng nh hnh di.

Vi ngi lm quen v nhiu kinh nghim, c th bt tay vo tra cu n gi d thu lun. Tuy nhin, nu bn l ngi mi, hy bt u t bc chun b cc thng tin ban u. 2. Lu file d thu vo cng Phn mm cho php ghi d liu ca bng gi d thu thnh tng tp (file) c dng Excel (.xls). Cch 1: Bm vo nt 2. Ghi file d thu Cch 2: Kch vo nt File trn thanh lnh n, di chut v kch vo vo dng Save. Xut hin hp thoi Save ch v tr th mc lu tp D thu ri chn Save. Lu : Vi Excel 2003 bn lu bnh thng. Vi Excel 2007 hoc 2010 khi lu vo a bn chn ch Enable Macro khi c hi. Phi lm nh th, khi m file li mi khng b bo li. 3. M file d thu ang lm d Gi s bn ang lm d mt file d thu, sau bn lu vo a v hm sau mun m file ra lm tip. Bn lm nh sau:

Chon nt 1. M file d thu tm n file phn mm D thu GXD lu tr ri bm Open. Lu : ng dng nt Open ( ) ca Excel nu khng bn s khng tra cu hoc s dng cc lnh ca phn mm vi file m ra c. Bn dng nt Open th vn m file trong Excel chnh sa, in n c nhng s khng tra m hiu n gi, tnh khi lng bng phn mm c. 4. Cc thng tin ban u Chn sheet Ts nhp cc thng s ban u v cng trnh bn ang lp h s d thu. Bn hy nhp cc thng tin: - in tn cng trnh vo hp Cng trnh, tn hng mc vo mc Hng mc, tn ch u t vo mc Ch u t, a im xy dng cng trnh vo mc a im. - Ngi lp gi D thu nhp cc h s chi ph vo cc tng ng (phi t tra cu cc h s, nh mc t l ph hp vi iu kin ca cng trnh, nng lc nh thu, thi im lp gi d thu v cc hng dn iu chnh gi, quy nh ch chnh sch ca Nh nc hin hnh). - Ch tin lng: Cc d liu phn ny s phc v tnh bng lng nhn cng, tin lng th iu khin my. Cc cng thc c thit lp t ng, kch vo ct gi tr bn phi s hin th cc s hiu vn bn c lin quan. - Gi nhin liu, nng lng: Dng tnh bng gi ca my.

CC THNG S BAN U V CNG TRNHI. THNG TIN CHUNG 1 Tn cng trnh: TON NH VN PHNG CNG TY GI XY DNG 2 Hng mc: TNG HM + GARA T 3 Ch u t: CNG TY C PHN GI XY DNG 4 a im xy dng cng trnh: S 10, NGUYN NGC NI II. CC H S, NH MC T L 1 H s vt liu 2 H s nhn cng 3 H s my xy dng 4 nh mc chi ph trc tip khc (TT) 5 nh mc chi ph chung (C) 6 nh mc thu nhp chu thu tnh trc (TL) 7 Thu sut thu gi tr gia tng (TGTGT-XD) 8 T l chi ph XD nh tm ti hin trng v iu hnh thi cng 9 Chi ph kho st III. CH TIN LNG 1 Mc lng ti thiu chung (LTTC) 2 Mc lng ti thiu vng (LTTV) 3 Ph cp lu ng (20%LTTC) 4 Lng ph (12%LCB) 5 Chi ph khon trc tip (4%LCB) 6 Ph cp khng n nh sn xut (10%LCB) 7 Ph cp khu vc (0%LTTC) 7 Ph cp khu vc (0%LTTC)8 Ph cp thu ht (0%LCB) 9 Phc cp c hi (0%LTTC) 10 Ph cp c bit (0%LCB) 11 Ph cp lm ca m (0%LCB) IV. GI NHIN LIU, NNG LNG (TRC VAT) 1 Xng (ng/lt) 2 Du Diezel (ng/lt) 3 Ma dt (ng/lt) 4 Du ha (ng/lt) 5 Du DO (ng/lt) 6 in (ng/kw)

1,0 1,0 1,0 2,5% 6,5% 5,5% 10,0% 1,0% 5,0% 730.000 /thng 980.000 /thng 20% 12% 4% 10%

8.636 6.818 4.133

1.000

5. i tn cng trnh, h s nhn cng, my, nh mc chi ph chung, thu nhp chu thu tnh trc Bn thc hin lnh D thu GXD / i tn cng trnh / hng mc

Khi s hin ra hp thoi nh di y, bn nhp cc Thng tin chung v cc h s, nh mc t l ph hp vi cng trnh bn ang u thu vo phn H s. Sau bm vo nt Chp thun.

Nhp cc thng tin vo y

Lnh thay i thng tin ny c th thc hin vo bt k lc no (bt u, ang lm hoc kt thc lm h s d thu). 6. Np c s d liu cho phn mm 6.1. Tm hiu v cc tp c s d liu Phn mm s t ng tra cu cc d liu nh mc, n gi, vt t vo bng tnh. Nhng gi c d liu vo bng tnh ta phi bo cho phn mm bit s tra cu tp d liu no. Phn mm tra cu d liu trong cc tp d liu ny ri a vo bng phn mm D thu GXD tng t nh tra t mi trong t in v ghi ra v (quan trng l phi bit l s tra trong quyn t in no). Phn mm D thu GXD c cc d liu n gi, nh mc, Ph lc va, T in vt t, Gi ca my c lu trong cc tp (file) c phn m rng l .csv. Cc tp tin dng ny c th m bng phn mm Excel xem, chnh sa v lu li. - n gi c lu trong tp c tn bt u bng ch DG. V d: n gi H Ni c lu tr trong tp DGHN 2008.csv, n gi An Giang lu tr trong tp DG An

Giang.csv. Hin nay khi lp gi d thu khng s dng n gi a phng, m t tnh gi ly, nn ta ch s dng tp n gi ny ly m hiu v tn cng vic m thi. - Gi vt t gc (tng ng vi n gi ni trn) c lu trong cc tp file c dng GVT*.csv. V d: Gi vt t H Ni lu trong tp GVT Ha Noi 2008.csv. - Cc nh mc c lu trong cc tp c tn bt u vi ch DM. V d: nh mc phn mm D thu GXD phn xy dng c lu tr trong tp DM1776.csv, nh mc phn lp t c lu tr trong tp DM1777.csv. Hin gp c 3 nh mc phn xy dng, phn lp t, phn kho st vo tp DM1776+1777+1779.csv. - Ph lc va c lu trong tp PLV.csv. - T in vt t c lu trong tp TDVT.csv. - Gi ca my c lu trong tp GCM*.csv. V d: Gi ca my H Ni nm 2006 lu trong tp GCM Ha Noi 2006.csv. Mt iu rt tin li l: D liu phn mm D thu GXD s dng chung c cng vi D ton GXD, Thanh quyt ton GXD v cc phn mm Kinh t xy dng khc do cng ty GXD sn xut. 6.2. Np c s d liu vo phn mm Bm vo La chn CSDL hoc bm Phm tt: Ctrl + Shilf +D s c hp nh hnh di y:

chn d liu n gi, kch chn vo n gi trong mc DANH SCH C S D LIU, sau bm v La chn, ch ng dn ti file n gi trong cng np vo phn mm. V d: Ta lp gi d thu thi cng xy dng cng trnh H Ni th chn DGHN 2008.csv. Tng t ln lt chn d liu Gi vt t, nh mc, T in vt t, Ph lc va, Gi ca my. Sau khi chn xong cc tp d liu th bm Kt thc. Lu : + n gi, Gi vt t, Gi ca my chn theo tng tnh, thnh ph. + Mc nh mc, T in vt t, Ph lc va l d liu chung.

Sau khi lm quen vi phn mm, to bng tnh h s D thu mi v np c s d liu xong, ta sn sng bt u vi cng vic chnh: s dng phn mm D thu GXD lp gi d thu, h s d thu u thu cng trnh. VII. S DNG PHN MM D THU LP GI D THU Sau y chng ta cng thc hin vic lp gi d thu thng qua cc v d c th tm hiu cch iu khin phn mm D thu GXD. Sau khi bit cch lm v d ny, bn s ch ng vn dng vo cng vic c th ca mnh. 1. Tnh n gi chi tit khi bng khi lng mi thu c m hiu cng vic Thng thng khi mua h s mi thu, bn s ch nhn c bng khi lng vi tn cng vic, n v tnh v khi lng. Nhng v l do no bn xin c h s d ton, khi s bit c cc m hiu m n v T vn lp d ton cho Ch u t p, iu ny s gip bn thun li hn trong cng tc lp gi thu. Gi s bn c bng khi lng mi thu nh sau:MHKT CU TR P4 TN CNG VIC

VT m3 m3 m3 tn tn tn m2 m3

KL 0,2 144 21,16 0,09819 2,59088 14,36666 105 6,5

AK.41120 AF.33110 AF.33210 AF.65110 AF.65120 AF.65130 AF.87211 AF.11120

Va khng co ngt (vn dng m hiu) B tng b tr 30MPa Btng m m, m tr cu 30MPa Ct thp tr D nhp vo I9. Bn ch : Trong HSMT th ng BTLT 60cm 1 li thp c mi theo n v l m, trong khi n gi chng ta va tnh theo nh mc c n v l 100m. Chng ta phi i n v cho ging vi HSMT (phi lm ging y nh HSMT, sai khc d ch l hnh thc, bn cht vn ng nhng HS d thu c th b loi). Bc 3: Chn lnh Tin ch / i n v cho cng vic s hin th hp thoi, nhp vo nh sau:

Sau khi nhp h s i n v l 0,01 (t 100m v m) v n v mi l m, bm Chp thun, s c kt qu nh sau:

n y l xong cng vic tra m, tnh n gi chi tit. Gi tr 474.519 /m trong hnh trn c gi l n gi y lp 1m ng BTLT 60cm 1 li thp. Nu khng c thay i g na, nh thu s dng gi cho thu lp 35m ng BTLT.

Trng hp khng bit m hiu BB.11503 bn c th s dng chc nng tm kim. Phn mm c chc nng tm kim rt mnh m, chnh xc: Chng hn nh bn mun tm kim tn u vic nhng cha bit nh mc, vy lm th no? Khi bn sng vo mt trong ct M hiu n gi v g th vo t ng b tng ly tm:

n Enter, s thy hin th ln tt c cc u vic c t ng b tng ly tm nh ca s di y:

Kch chn dng c m hiu BB.11503 ri bm ng hoc kch p lun vo dng tra dng d liu vo bng d thu. Mo: Nu bn g BB.11503 hay BB,11503 th u tra c n gi (du chm (.) hay phy (,) u lm vic).

thu hp phm vi tm kim bn c th nhp vo t kho tm kim gn vi cng tc. Hp tm kim rt linh hot, m rng hay thu nh hy chut vo cnh hoc gc hp thoi ri ko ra ti kch thc nh mun. Cc ct bn trong cng c m rng gin n tu . Xem hnh trn v v tr cc mi tn mu . V d 1: bn ln lt th g b tng hay vn khun hay AB. hoc AB.11 vo cc ct D, ri n Enter hin bng tra cu n gi ri tm kim n gi cho ph hp. V d 2: D7 bn c th g: AF. hoc AF.8 hoc Vn khun hoc Vn khun cho cng tc b tng ti ch hoc vn khun g t kha cng chi tit v ph hp bn cng cng tm kim. Sau khi g t kha bn nhn Enter hin bng tra csv, cc cng vic c cha t kha tm kim c gii hn li. Bc 4: Chnh sa ni dung cng vic Sau khi chn c m hiu hoc cng vic ph hp th M hiu, tn cng tc, n v tnh v gi tr n gi vt liu, nhn cng, my thi cng s hin ra ti cc tng ng.

Sa cha tn cng vic hoc g li ton b ni dung mi vo y. n F2 v ch sa.

Sau khi tra n gi ca mt cng vic, ta s chuyn sang ni dung cng vic ( F7, trong hnh minh ho) thc hin sa cha ni dung cng vic cho ph hp. sa cha, thm bt ti v tr cn thit no ta nhn phm F2 ri di chuyn n v tr (hoc kch p vo v tr ).... Hoc bn c th g li ton b ni dung mi. Lp li cc bc nh trn cho tt c cc cng vic khc.

Bc 5: Tnh n gi tng hp Chng ta u thy rng mc d HSMT mi cng tc B tng M150 4x6 m mng vi khi lng 8,060 m v nh thu bt buc phi cho ng nh th, khng c sai tn cng vic v khi lng cng vic (nu sai c th s b nh trt thu, mi bn th no th cho bn ng nh th). T thc t kinh nghim ca mnh, nh thu bit rng thi cng c cng tc B tng M150 4x6 m mng th khng ch c b tng v cn phi lm vn khun. Nhng cng tc lm vn khun khng c mi. Do , nh thu phi tnh phn b c chi ph vn khun vo n gi 1 m b tng. n gi gm c chi ph vn khun v b tngtnh cho 1 m b tng l mt v d ca n gi tng hp. Thao tnh ton n gi tng hp ny trong phn mm D thu GXD nh sau:

G vo D28 m hiu AF.11210, sa tn cng vic thnh B tng M150 4x6 m mng trong F28. Gi vt liu, nhn cng, my thi cng ( ct I trong hnh di) ta tm gi thit phc v tnh ton. Vic tnh ton cc gi tr s gii thiu sau.

Tra tip m hiu AF.82111 trong D45 v sa tn cng vic thnh Vn khun cho b tng ti ch, vn khun kim loi. Gi vt liu, nhn cng, my thi cng ta tm gi thit cc gi tr nh trong hnh, nhp vo tnh ton.

Tnh n gi tng hp cho cng tc B tng M150 4x6 m mng nh sau: - Nhp TH1 vo A67 lm m hiu n gi cho cng tc. - Ln lt nhp tn cng vic v n v tnh ca cng tc vo F67 v G67. - Ti D68 g DG2 khi tn cng vic, n v tnh, n gi, cng thc tnh ton ct J s t hin ra dng 68. - G tip DG3 vo D69 (nu c nhiu hn cc cng vic chi tit th lp li cho n ht).

Cn c vo bn v trong h s mi thu, s xc nh c 1m3 b tng cn 0,804m2 vn khun. Tuy nhin, thy DG3 hin ang tnh vi n v tnh l 100m2. Nh vy phi thc hin i n v tnh. Chn li F45 l tn cng vic ca DG3, thc hin lnh Tin ch / i n v cho cng vic.

Khi s hin ra mt hp thoi, bn nhp cc gi tr vo cc tng ng (v i t 100m2 v m2 nn phi l h s 0,01).

Sau khi nhp s liu cho hp i n v tnh cho cng vic, bm Chp thun s c kt qu nh hnh sau:

Khi n gi TH1 cng c thay i tng ng nh hnh sau:

Gi nh du J68:J69 v bm Ctrl+J s c n gi TH1 l 813.486 /m3:

Thc hin ln lt nh trn cho tt c cc cng tc khc. Lu l 2 cng tc cng phi dng n gi tng hp v c cc m hiu n gi chi tit nh trong bng sau:

M hiu

Tn cng tc cn tnh n gi TH

MHT chi titAF.17210 AF.82111 DG1

Tn cng tc tnh Khi VT n gi chi tit lng B tng M150 2x4 thn h ga Vn khun thp BT h ga B tng M150 4x6 m mng Vn khun b tng tng m3 m2 1 8,333 2 2,353

B tng TH2 M150 2x4 thn h ga

B tng M150 4x6 TH3 mng h ga

DG2

Bn ln lt lp li cc cng vic tnh n gi nh trn vi bng s liu c cc m hiu n gi (MHG) nh sau:STT MHG HNG MC : CNG K THUT I. THN CNG ng ly tm 60cm ng BTLT 60cm 1 li thp B tng M150 4x6 m mng o t C3 mng CT bng nhn cng 10% o t C3 mng CT bng my 90% p t mng K95 bng m cc (tn dng t) H ga B tng M150 2x4 thn h ga B tng M150 4x6 mng h ga VT

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15

BB.11503 TH1 AB.11323 AB.25123 AB.65130 TH2 TH3 AB.11323 AB.25123 AB.65130

m m m m m m m m m m m m m tn tn

AK.98210 dm 4x6 m

AK.98210 dm 4x6 m o t C3 mng CT bng NC 10% o t C3 mng CT bng my 90% p t mng K95 bng m cc (tn dng t) Tm an AG.11413 B tng tm an 1x2 lp ghp AG.13221 Ct thp 6-10 tm an AI.11421 Lp t thp gc

16

AG.42131 Lp t tm an P < 250kg

tm

Bc 4: Chuyn sang sheet TH GDT thc hin tnh bng tng hp gi d thu Bn ln lt nhp cc m hiu n gi nh DG1, TH1, DG4, DG5, DG6 vo ct B trong sheet TH GDT. Sau nhp cc khi lng mi thu tng ng s c kt qu nh trong bng sau:

Nhp m hiu n gi v khi lng

Gi tr d thu ca bn chnh l s lm trn v c c Bng ch. Gi bn ch vic b sung s liu thc t v hiu chnh mt cht trong cc sheet Gia VLHT, VL, PLV, NC l c h s d thu nh . 3. Tnh ton o bc khi lng Trong sheet TH GDT bn cng c th tnh khi lng (tnh nng tng t nh nhp tnh khi lng ca D ton GXD). V d: Trong sheet TH GDT bn c 3 cng tc nh sau:

Nu ngi lp h s thu phi tnh ton khi lng t bn v, thc hin nh sau: Bn chn thm dng xung di cc cng tc, c th chn thm s dng ty . hnh di y chn thm mt dng vo dng 9, mt dng vo dng 11.

Chn thm dng vo y

Trong E9 nhp 12*4,5*0,3*2/100 ( y 12 l s lng dm; 4,5m l chiu di mi dm; 0,3m l chiu cao ca dm; 2m l tnh din tch vn khun cho 2 mt bn ca dm; do n v tnh l 100m2 nn ta phi chia (/) cho 100) ri nhn ENTER. Ti E11 nhp 12*20/1000 v E13 nhp 12*4,5*0,3*0,2 s c kt qu:

Nhp cng thc tnh ton ti y

Kt qu

Lu : Bn g php tnh theo t duy ton hc. Nhp cc kch thc, s o vi cc du cng (+), tr (-), nhn (*), chia (/) thc hin cc php tnh, sau nhn ENTER, chng trnh s t hin th kt qu. Th t php ton s thc hin nhn chia trc, cng tr sau, php tnh trong ngoc trc, php tnh ngoi ngoc sau, cc php tnh tng ng th tnh ton t tri sang phi. Mun lm php tnh ly tha bn s dng du s m ^ . VD: 2^2 = 4, 3^2 = 9, php tnh ly tha s c thc hin trc. Khng s dng phm cch khi nhp s liu tnh. Vi nhng c cha con s sau cng bn khng mun thc hin php tnh th hy g du hai chm (:) v du cch (khong trng to ra bng phm space) hoc l 2 du cch sau n. V d: tnh th tch b tng dm D1 di 3,5m, tit din 0,2x0,3 ta nhp php tnh nh sau: D1: (du cch) 3,5*0,2*0,3 khi phn mm s cho kt qu l 0,21m3. Nu khng c du cch th s 1 dm D1 s tham gia vo php tnh 1:3,5*0,2*0,3 lm kt qu sai lch i. Khi nhp ng v tnh ton ng th cc dng ch trong dng cng vic ny s c mu en, cho ra kt qu mu xanh. Nu n c mu ct m hiu n gi th l ta nhp sai m hiu hoc n gi ca a phng khng c m hiu nh bn bn nhp vo (hoc thiu du chm (.) ti v tr gia phn ch v phn s ca m n gi). Ring con s kt qu a ra s c mu xanh (cc s 0,324; 0,24; 3,24 trong hnh minh ho). C th c trng hp bn nhp khi lng vo nhng phn mm khng t tnh tng khi lng ln dng cng vic. Khi bn cn vo thit lp li cch hin th phn thp phn, ngn cch hng nghn trong Control Panel ca Windows Phn mm s li chy tt. Trng hp ni dung cng vic khng c trong n gi ta phi in TT hoc bt k k hiu no vo ct m hiu, trng hp ny ta phi in n gi vt liu, nhn cng, my thi cng cho cc cng vic ny. Lc ny ti ct m hiu n gi s c dng ch mu . Khi thc hin php tnh m khng ra kt qu ta phi xem li cc php tnh ton xem cc php tnh v cc du ton t ng cha (ch cc khong s dng phm cch phi c xo b). VIII. NH DNG, DN TRANG, NH S TRANG, IN H S D THU 1. nh s trang File d thu to t phn mm D thu GXD c trnh by p, sn sng in n ngay. Nhng i khi bn mun trnh by li cho p v theo ring ca bn. T menu File chn lnh Page Setup s hin th hp thoi nh sau:

Bn chn Paper size l A4 in h s vi giy kh A4. First page number: nh s cho trang u. V d: Bn c thuyt minh trong file Word, phn thuyt minh n trang 99, gi in phn h s thu va lp, bn g 100 vo thay ch Auto s in trang bn ang nh dng vi s trang 100. nh li s trang bn chn tab Header/Footer sau kch vo nt Custom Footer v thc hin nh s trang.

cn chnh li l bn kch vo tab Margins v chnh cc thng s cho ph hp.

Khi kch chn tab Sheet s hin th nh sau:

Bn c th chn Black and white in h s ch en trng. 2. In h s d thu Sau khi cn chnh xong, in ti liu ra hon thin h s thu ta lm nh sau: - nh dng, dn trang, n nh vng in l nhng tnh nng mnh m ca Excel. Bn thc hin in n bng chng trnh Excel. - Tin hnh in: Kch vo nt File trn thanh lnh n, di chut v kch vo vo dng Print hoc bn ch cn nhn t hp phm Ctrl+P. Ti bng Print c cc la chn: + Trong Print range, chn ALL (in ton b ti liu c la chn hin ti) hoc Page(s) (in theo trang). Khi in theo trang ta nh s ca trang bt u in vo From: v s ca trang kt thc vo To:. + Trong Copies, chn s bn cn in vo Number of copies. Sau khi la chn xong, nhn chut vo nt Preview c th xem ton b bng biu trc khi in. Nu xem xong khng c chnh sa g, nhn vo nt Ok in bng biu. Mo: nh s trang lin hon trong h s D ton GXD, bn sp xp cc sheet theo trnh t c in ra. Kch chn sheet u tin, gi phm Shift v kch chn sheet cui cng, ri bm lnh in. H s ca bn s c nh s trang lin tc nh trong Word vy. IX. MT S TIN CH 1. Chuyn xi mng t PC30 v PC40 hoc ngc li Mun chuyn XM t PC30 n PC40 hoc ngc li bn c 2 cch: Cch 1. i tng m va ty bn. trong sheet PT DGCT ct B v C b n.

Bc 1. Chn ct A v C, sau kch phi vo tiu ct A v C v chn unhide hin th ct B v C, bn s thy ct B l ct m va. Bc 2. Bn kch p vo c m va hoc chn v n F2 c th sa ni dung hoc g m va (ch cn g C) hin hp thoi cho php chn m va. Bc 3. Chn m va ph hp. Cch 2. Bn dng lnh Tin ch -> Chuyn i ph lc va Cch ny cho php i ton b cc m va t PC30 -> PC40 hoc ngc li.

Kch vo y

Sau khi chn lnh trn s xut hin hp thoi sau:

Sau khi bn chn chp thun th lnh chuyn i tng ng s c thc hin

Kt qu

Nu bn mun phn tch li ton b n gi chi tit th bm OK, khi s c kt qu nh sau:

Kt qu

2. Sp xp bng vt liu Bn chn bng VL sau bm lnh sp xp vt liu d thu ( ) s sp xp cc vt liu theo nhm Vt liu, Nhn cng, My v sp xp theo th t ABC, Trc khi sp xp:

Kch vo y

Sau khi bm lnh sp xp:

Vt liu c sp xp theo Alphabe. Cng thc kt ni trc tip.

Nhn cng My thi cng

3. Bng gi ca my Thc hin lnh D thu GXD / Kt xut bng gi ca my. Lnh ny s tnh bng gi ca my tt c cc my c s dng h s thu trong sheet MTC.

Nh trong bng trn c 5 loi my, sau khi bm lnh kt xut bng gi ca my th s c bng tnh gi ca my cho 5 loi nh sau:

Ngi lp gi d thu c th cn c m hiu my kt ni gi ca my vo bng phn tch n gi chi tit d dng (s dng hm Vlookup hoc kt ni trc tip). Lu : Trng hp tnh ton b sung cng vic trong bng Phn tch n gi chi tit th bn phi chy li lnh Kt xut bng gi ca my cp nht cc my mi. 4. B gi ca my Trong thc t, c th nh thu hay dng gi ca my ca a phng lp gi d thu. Vi gi ca my a phng cng b, Nh thu thng phi iu chnh gi ca my v thi im hin ti. Sau khi chn lnh Kt xut bng gi ca my th phn mm ng thi kt xut bng B gi ca my theo cch n gin nh sau:

Nu bn mun chuyn i B gi ca my theo hng dn ca Thng t 06/2010/TT-BXD ca B Xy dng th chn lnh Tin ch / B GCM theo TT06/ B GCM n gin

Kt qu s c bng b gi ca my chnh xc theo hng dn ca Thng t 06/2010/TT-BXD ca B Xy dng:

S d phi c hai cch b gi ca my (cch b n gin v cch b theo Thng t 06/2010/TT-BXD) l v khi b gi ca my i hi phi c cc s liu u vo, nhng cc bng cng b gi ca my ca cc a phng thi gian qua cng b khng s

liu. V vy, phn mm a c hai phng php, ngi s dng c th linh hot hn trong vic la chn phng php b ph hp vi cng trnh c th. Ngi s dng cng c th nhp s liu ca mnh vo lun bng tnh tnh ton. V d: Nguyn gi ti thi im iu chnh, tnh li cc ct chi ph nhin liu, chi ph tin lng X. LM VIC VI C S D LIU NH MC, N GI, GVT, GCM Nh thu c th c cc d liu ca ring mnh. Cc d liu ny thng c s dng i, s dng li trong cc h s thu u thu cc cng trnh khc nhau. khi phi lm i lm li nhiu ln, ngi lp h s thu c th b sung cc d liu ny vo CSDL ca phn mm v tra m hiu s dng li nhiu ln. D liu ca phn mm c lu trong cc file c ui .csv. Mt u im rt mnh ca phn mm D thu GXD l cc file d liu ny c th s dng Excel m, chnh sa, tnh ton, copy, paste 1. B sung file c s d liu C s d liu ca phn mm D thu GXD s dng chung cng phn mm D ton GXD, Quyt ton GXD Thun li thng sut t khu lp d ton, lp gi d thu, chm thu, xt thu v thanh quyt ton, kim tra, thanh tra sau ny. Mc nh c s d liu ci t cng phn mm ch gm d liu lm thu cho cc cng trnh trn a bn thnh ph H Ni v thnh ph H Ch Minh. lm thu cho cng trnh ti a phng khc bn cn c file .csv n gi, Gi vt t, Gi ca my ca a phng . Bn c th download d liu cn thit ti a ch sau: http://giaxaydung.vn/diendan/forums/468-trung-tam-tin-hoc-xay-dung-gxd.gxd hoc tm trong a CD cung cp phn mm hoc lin h Cng ty Gi Xy Dng c cung cp (T/Fax: 04.35682482/04.35682483) hoc gi th ti a ch email phanmem@giaxaydung.vn xin file d liu. 2. M file c s d liu sa i, b sung Vo th mc ci t nh hnh sau, kch p vo tn file s m ra trong Excel. V d: Mun sa i hay b sung d liu vo file n gi H Ni, bn kch p vo file DG HaNoi.csv, khi phn mm Excel s khi ng v m file DG HaNoi.csv.

File c s d liu c m ra v bn c th sa i, hiu chnh mt cch d dng. Thm ch thc hin cc thao tc tnh ton d liu ri lu li.

Khi bm nt lu file s hin th thng bo, file m bng Excel nhng lu d li di dng .csv s mt cc nh dng, cng thc. Bn hy chn Yes. Sau ng file li, m phn mm, np c s d liu s dng.

3. B sung thm d liu 3.1. Cc nh dng c s d liu ca phn mm Khi mun b sung d liu ca ring bn vo ch cn trnh by d liu theo cc ct nh cc dng sau trong Excel v lu li dng .csv hoc copy v cc file c s d liu hin c l s dng c. nh dng d liu nh mc (V d: DM1776.csv):mscv AA.11111 AA.11112 . MSVT V10001 V10002 V10003 TENVT Vt liu Actylen Axt hn Backer rod 25mm . DVT chai lt m ci ci msvt N1307 N1307 Klvt 0,95 1,42 lvt

nh dng d liu t in vt t (TDVT.csv):DVT chai Lt M LVT TLVT BH

nh dng d liu gi vt t (V d: DG HaNoi.csv):MVT V10001 V10002 V10003 V10004 V10005 TVT Vt liu Actylen Axt hn Backer rod 25mm Bn chu ti Bn m Gi gc 360000 6000 Thng 1 Thng 2 Thng 3

nh dng d liu n gi (V d: DG HaNoi.csv):MHDG TCV Pht rng bng th cng, pht rng loi 1, mt cy TC/100 m2: 0 cy Pht rng bng th cng, pht rng loi 1, mt cy TC/100 m2: