MS Project Download
: :
?

[86]

[28]

[60]

[63]

[128]

[26]

[53]

[4]

[37]

MS Project . [4]

Microsoft Project [3]

MS Project Server [36]

Microsoft Project [5]


24.04.2009
e aa 1

ea coeca paoa poeax MS Project epe Oee op Excel

Bap ao, aoee a poeccoa Microsoft Project (MVP)

PM Consulting Services, cpaeec apep Microsoft ypae poea (Microsoft EPM PAC)

Ocae cae cpeca yy pecae a ecao oepe 12 a

Oa oe opaa oya c cooae Microsoft Project Oex op Microsoft Excel

aoe peee ooc o e a cepcoe ooee. Ha poc eo papaoa, .. pe poex cpoex epe coyc c e, o oyaoa oe Microsoft Project Server e ooa opaoa eoe epee. oo oapy, o cxoe peoa aa opypoa o ce oa, e oyaoa oe - e aoece c oe epcoao, a oe opae ey eeepa.

ooae pe aoe a ep acoo epeaoe peoae MS Project a coooe apaeoe peapoae ooo poea. pe ooae acaa a oecee opaoo eoacoc p coeco peapoa ooo ax poee. Hapep, o o o oeap o aae, e oe e cooc pao. ae cpeca MS Project Server e coepa cpec coeco pao papae ocya p coeco peapoa ooo poea.

Tae ooae xoe e cpeca oya o oey poe a, oope oy paoa e ocooo oe epe, o ce epe epoy oy.

Oee op Excel
Oee op Excel aya a cpeco oya apoa, paoaeo Microsoft Project,
co cya, peoca aoe aece ae, a ae peocae oeo pyoocy

ooae, ee oo oe ax Excel ea x coxpa   peoa cpeca opa, ya oee e e pae.

Ka e pyo oaac o epex, e ceap, ocae e, p opaa ec-poecco, yaae e opae oe ocao opoa epe.

Ha oao Cae Microsoft 2009 xoe ocye pax cxe ocpoe ec-poecco ocya c cepa y pee pe oy, o eo ae peee xopoo oc a poy pay ypae poea.

Cy aeo pee poca: cea oe opae e cpeca Microsoft Project Server, a epe ceae Oee op Microsoft Excel.

Ceap opayeaec cey:

1) apo pyae MS Project Excel opy apoca c a epeae y, oeceoy a aoe cooecyx opaox ooo c a o ay aecoy coe.

2) Oeceoe o oyae opy Excel. opa oa e yao oo: co cpyypo pao, ao c cpy opoa oy peapoa opaox ooo. ooae poco o e ae o aoo aeco opa, oope peyec, ocae opy opao apoy.

3) apo apyae opy Excel opao MS Project. op ax oe pocxo aoaec, a pacoaae a op pa apy ax, c yeo opaoo eoacoc.

Heoooc pee cyecyx cce epa c Excel ceap "Oex op"

Ca poc peee o pe ye ocye a pe cpeca epa MS Project MS Excel. Ho cceoae pa cpo paoapoao ac, .. epaoe pee , o o o e peaae ceap cooa Excel, a oyaooo cpeca c opa aoe ax. o copee pee oea c aa ax epe opa Excel, a e cpeco aoe op oe ooaee.

Cyecye epaoe pee e ceye opae, oope ea x paec ecoe yo ceap pee:

  •  Oaeoe peoae Oeo ope Excel o yaoe oopaee Cpyypo eoo Pao (epapx pao, WBS). e epapxecoo pecae pao ooae poco e coco o ya o ae, ocoeo ec yec oooc oaox aa aa a pax ypox.
  • ooae e oe e ae eopeecy oooc cop ae poee p apye  op. K coae oo oe cpeca epa c Excel e oepa. He oooc ap opeeee opaoe oo o peapoa. p apye op oe aoaec pacoaac op, o ao e oc p ope cocoa opa. o opoc opaoo eoacoc pee op.
  •  opa oa e ay c pea cpye o aoe. Excel a cpeco aoe op oe yoe e, o e peyec oyee oo, o ye ee ao, o oo opa Excel oa e a opaa opa aoee, a e a ccea aa popaco.
  • oa oepac oooc cooa opy Excel, ec ae epyc pyx Excel. Ho o ee oee ao, peoaac ceaa ooea oa opao cya, oa ooae ee ae oo o cyap aaa MS Project. poco op ax a cyape aa apa .. o MS Project apee, .. o cee o.

Ka e coo oaac, ce o - pece poe, oope pape eye cpeca epa c Excel e coco. Toee cape cpeca epa e oepa ooe oe Oeo op Microsoft Excel. ooy a poc papaoa ooe cpeco epa, oopoe yee eeppoa oppoa ae Oee op.


Kocpyop Oex op Excel Turbo Project ooe caoy coa opy yoo a
Opae ae, o Oee op Excel e ceay oy o opaoe ac a cyape aa (ooa "Cyape")

Paccop peee a pepax. Opac oooc ooo ypo. Tae oc coco ce cooc opaoo cce o ypae poea oee e 10 pa.

Excel-op apoca aoo opa

Cyecye oo ceape epe cce ypae poea, e aoa opa oppyec cpay eco . Ec poe oo pa a opoe, o ao ceap MS Project oepae. Bo ox cyax pa a opoe e poco, oao ceae cpeca a Turbo Project ypoa y aay.

Oao ec opayeaec apae o opaox ooo o poey, oa ae ax cpec oe oaac eocaoo.

Oo o ooaee aaaec "apoo" o papaaae cpyypy pao o poey MS Project. Heoopy aoy opa o oe a ca, a eoopo opae ae oo pye ooae. Hapep, cpoa cooc opx pao oe ae ooopo oe, ooy peyec peoca oooc ec poe ae. Ec o aae ae yo ocea oca coacoa, o ooae, oece a ae yo peoca oooc ec x opaoe oo, p o o e o e cooc pao.

opa apoca aoo opa

a cpeca ay oe oeo pao o oopeeoy aoe ooo poee e opaoa. Ka apa, ooae MS Project oo ac ea ceyee:

1) Oa "apoy" ae a oop o opa. p oopo oe opa pocxo o, poe oo aa cxea epe ocaoo pyoapaa. Haa c eoopoo oea ax "apo" ye e coco ocyec ao o. Too oe aex poeax ao oxo oe paoa.

2) oa o ae poe "o oepe", oa o ooae apae a poea epeae eo pyoy ooae oa eoxox ax. p ocoo ocye opa ao opo opaoa eca apyeo. Kpoe oo, caoc oe pa poea opaoo eoacoc, .. ooae, peapy oo MS Project, oe e ce ocae oo, o ce cooc yco opao. o ceap ae a e aae o poe cyao op ooae ax pyx ooax, MS Project e coep cpec papae ocya p peapoa ooo ax.

o aoo cya oo c oo ax Oex op Microsoft Excel. Paccop pep.

Ec apoy peyec apoc ae o coocx cpoax pao,  o o c oo ceaoo ocpyopa oe cpo coa yy oey opy. B ope yaac oo oope peyec ao. Tae ope oy pcycoa opaoe oo, oope e peapoa. Cpyypa op papaaaec ocpyope o pa, ae ee oo cooa oopo.

opa coxpaec opae Microsoft Excel epeaec copyy, aoey ae, epe aoy ay, epoy oy e epe copeee cpeca oyeooopoa a ae Microsoft SharePoint.

ooae opae opy o ae, aoea opa epeaec opao apoy.

opa opa  Excel
T Oeo op Excel aoaec pacoaec Turbo Project, ooy aoaec acpaac apaep apy.
apo oe a peapeo pocope poaapoa opy e opo apy oe

apo opae opy. Ccea aoaec pacoae op paa ee apy poe. apo oe e paa apy, ec ocae y.

ae op oaa poe.

Excel-op apoca aeco opa

p cope aeco opa o oe poeo oe ox ax poeo oae cepea poea, caa c e, o o, peocaee oe, e oe axoc ocoo oao ce c "apoo". Hapep, oe peocae exaop co cpoeca, oe aoe op e y ac poee yacye opa copy.

B pe cyae oa opaoo eoacoc oa oe cpoa apeae ocy ype cepepa yae ooae. Hapep, ae ocy epe epe cepepy c pao a papea oe eoe cep o opaoo eoacoc.

Ocyc ocya oao ce, e axoc apo, cpay e eae eoo peee MS Project Server aoaa copa aeco opa.

aece ae

Oea opa Excel eo peae y poey. Moo coa opy c apoco ooo o aeco coco poea opa ee aoe o epoo oe. oyey opao o oe opy eo oppoa poe MS Project.

Boooc oa ax c ox ycpoc oyaopo

Turbo a HTC MAX 4G
Oea opa Excel ooe ao ae c ox ycpoc oyaopo

Bpya ax Excel ooe pe aay o oooc oa ax c ox ycpoc oyaopo. B poeax o ypae pacopo, e paoe a cpoex oaax aco eyoo ocoo oc c coo oyy. Koyaop o ypaee OC Windows Mobile - oee ooe ycpoco.

B coca Windows Mobile xo oa epc Microsoft Excel, o ooe paoa c Oe opa Excel. paa ceye yec, o, ooo, opeyec oepa o opa Excel, o oo o pocxo aoaec.

Te e eee, eo eec oooc peapoa poex ax c ox ycpoc. O o pae ooae MS Project e o ae ea.

ox poex cpoex poeo oooc cooa aao oyaop oe ax o coe e ec pxo, a aco o caoe oaoe cpeco.

poe epa c a Microsoft Excel
o pa aaec papea

Ceye oe, o aaa apy ax cyecyx ao Microsoft Excel oe oaac e ao pao, a aec a ep . Hapep, Excel oe paoa ea ccea epoa ypaeecoo apoa. Ka ccea aopoo aaa "a o ec?" Excel ocaec epeoe cpeco, ooy e yeo, o oco ooco e oc epox a.

Ec ca aay oc MS Project cyecy  a, oope papaaac Microsoft Excel, e ceye ac cea o, oac ca apy. Oe ooae Microsoft Excel a po ao pe a "epexoo c". eec y, o ec ooae Microsoft Excel paoa coeco, oo o oea a coa oe c Excel, ya opya opy cc a ye ae. o ooe aoy ooae ae e a o coey ea ae.

Hae cpeco oepae apyy ax MS Project epe e "epexooo ca". B o cyae apo oopao coae opy c apoco ax. ooae oopao acpaa a ope cc epe opy a ae cox ax Microsoft Excel.

aee MS Project oe paec o oe oo ae poee a ocoe ax cax ax Microsoft Excel. Ec apo apyae opy c "epexo co", o ccea aoaec pacoae, a pao ee oppoa ae poe.

Ceye oe, o pe cyae op ax caoc e ao poco aae, .. Excel ooae oy e ae ox aaecx papeax, a ccee ypae poea oe cooac oee yoa aaa. T pep: a epeec cooc pao Excel MS Project, ec Excel ae pecae papee ooopo c opa. Ec MS Project ae-o aa ocaoo co eapoa oe oaac a, o eoa apy ax Excel cae oec eooao.

Opaoa cyapx cpo
Opaoa apy ax pax aaecx papeax oepaec Oex opax Excel
epe ceay oy ac cyape aa

Paccop pep. peoo xoe aaa y opo ocpoy peepyapa e. ocea oe pao a yo x eapoa c ocaoo cee. Oao ay oey paoy oe o ecoo opo e op cpay eae pyy pao. Koeo coca oe ce coee oo paec cooc o oepa, o o oe ca aae epeao pyoeoc. ooy o ox poeax apa copa o "pa" pao, .e. a epxx ypox (cyapx aaax). 3ac ax a cyape aa MS Project apeea, ooy oee oac y.


3aaa oo a "acpoae" ooe opaoa cya, oa oex op ae peocac acac a ypoe cyapx cpo.
94,41 py a ape e aca Oeo ope a aay "caaa1", popaa aoaec aa aay oo "acpoae" paeca py a e.

M pape ay poey. B ae ccee opa Excel oo yaa paa yea p ac ax a cyape aa. Hapep, cya apa o cyapo aae oe aoaec epeecea a cyccey aay a "acpoae". o peae poey ac a cyape cpo. e pee o poe o ox ceapx ypae poea poco eooo aec MS Project ae o ey. 

epa c 1C py copo ccea epe XML-opa Microsoft Excel

oco ooaee xo cooa eye opaoe cce epeoca x ax MS Project. ae ceo o ae o aeco coe poeo. Hapep ae o aecx apaax "1C:pep". poea aaec o, o yee cce oe paoopa, ooy yepcax cpec epa e cyecye, oao oo pe exoo peo cae cooc epaox pao.

M pa a opa Oex op Excel e poco opa Excel, a opa XML paee Excel. poeccoaa epaox peex ye oo o o a. opa XML ceao papaoa oe cpo oe o epa poe ey coo.

popac o 1C:pepe coe e papac oocx MS Project aoaec cpeca ao ae Oeo ope Excel epe opa XML.

Boooc epa MS Project c py ccea cyeceo ypocac.

epa c opa Excel epa poeo Microsoft Project Server

Tae a Oee op Excel coec c opao, p Microsoft Project Server py Excel (opao apy cpeca caoo Microsoft Project Server e peocaec). Heoope aepoe ye ae, o o yao oxo c opa Excel, oope oo coxpa epa poeo. o e cyao.

B oee coxpa oe pecaee Microsoft Project Server a opy Excel ae oppoa ee a cpeca opao MS Project. B o o op coa a cpeca popaa oeo e coe aoaec pacoa, ae ae xoe apy, apyaee oo ao ye yaa pyy.

Oao oooc cooa ep poeo a co Oex op Excel ooe coxpa oe ac, opaee a acpoy x pecae.

Eceoe peoae aoo ceap o ae pecae epa poeo oo c oo pao cxpoa. Hapep, o oe o CP. Caoe oaoe ec ooy "a eaop".

oooa oeo Microsoft Excel c coee peoa opaoo eoacoc

He ce ooae ye ooac MS Project, o ce ye cooa Microsoft Excel. Ec y Bac ec Microsoft Project Server, o oee a ye oeaoc e coxpa pecaee opae MS Excel epea ooae.

Ec y ac e epe Microsoft Project Server, o ae a eopoo caapo epc MS Project coee a cpeca coxpa oe e pacoo aa Microsoft Excel cp oo opoa cpo, oope ooae e oe e.

pocoa oye epe - Excel a ce

Ec B ee e ae, o cxea oea opae epe Oee op Excel o oo pa copaae peoa aa epcoaa eoxooy oye epe. Excel a ce, opaoa oyee MS Project co apa. oo cao o cee oyee cpay peyaa e ac, oa ooae e oya pay pao c cceo. Baee Excel oo y cex ocaooe pao c Oe opa.

Cooc pee 10 pa e, copoc epe o 10 pa e

Oee op Excel ooe eepo opao c cooc epe cce ypae poea. Bo ox cyax oo ooc e Microsoft Project Server. Ba e peyec paepa cepepy pacpyypy oya oo opoo popaoo oecee. 3apa a oooy epcoaa ae copaac a opo, aco ocaoo oye oo apoo.

ox oa Oee op Excel oo oc eo opaoo oya e oa acpooecx ceo a e oyee epcoaa.

Ocae cae cpeca yy pecae a ecao oepe 12 a

MicrosoftProject.ru.
"" .
, ,
.
, .

,
.
:

, , Ctrl+Enter. !

© 2003-2017, MicrosoftProject.Ru. .

E-mail: