Google Spreadsheets ili ndi ntchito zingapo zamakono zomwe zingagwiritsidwe ntchito pazinthu za tsiku la ntchito.
Tsiku lililonse ntchito imagwira ntchito yosiyana kuti zotsatira zikhale zosiyana ndi ntchito imodzi. Chomwe mumagwiritsa ntchito, chotero chimadalira zotsatira zomwe mukufuna.
01 a 03
Ntchito WORKDAY.INTL
Google Spreadsheets WORKDAY.INTL Ntchito
Pankhani ya ntchito ya WORKDAY.INTL, imapeza tsiku loyamba kapena kutha kwa polojekiti kapena ntchito yopatsidwa masiku owerengeka a ntchito.
Masiku otchulidwa monga masiku otsiriza amachotsedwa kuchoka pa chiwerengerocho. Kuwonjezera pamenepo, masiku enieni, monga maholide ovomerezeka, akhoza kuchotsedwanso.
Momwe ntchito ya WORKDAY.INTL imasiyanirana ndi NTCHITO YA WORKDAY ndi kuti WORKDAY.INTL imakulolani kufotokozera masiku ndi angati omwe amawerengedwa masiku otsiriza a sabata osati kuchotsa masiku awiri pa sabata - Loweruka ndi Lamlungu - kuchokera pa masiku onse.
Ntchito ya ntchito ya WORKDAY.INTL ikuphatikizapo kuwerengera:
- Tsiku lomaliza la polojekiti yomwe ili ndi nambala yochuluka ya masiku ogwira ntchito patsiku loyamba loyamba
- tsiku loyamba la polojekiti yomwe ili ndi chiwerengero cha masiku ogwira ntchito tsiku lisanafike
- tsiku loyenera la invoice
- Tsiku loyenera kulandira katundu kapena zipangizo
Syntax ndi Ntchito Zogwira Ntchito za WORKD
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito ya WORKDAY ndi:
= WORKDAY.INTL (start_date, num_days, weekend, maholide)
kuyamba_date - (chofunika) tsiku loyamba la nthawi yosankhidwa
- tsiku lenileni loyambira likhoza kulowetsedwa pazitsutso izi kapena selo lofotokozera malo a deta ili mu tsamba lolemba likhoza kulowa mmalo mwake
Num_days - (yofunika) kutalika kwa polojekitiyi
- chifukwa cha mfundoyi, lowetsani chiwerengero chachikulu cha ntchito zomwe zachitika pulojekitiyo
- lowetsani nambala yeniyeni ya ntchito - monga 82 - kapena selo lofotokozera malo a deta iyi mu tsamba la ntchito
- kuti mupeze tsiku limene likuchitika mutangoyamba mtsutso_date, gwiritsani ntchito chiwerengero chotsimikizika cha masiku_masiku
- kupeza chaka chimene chimachitika pasanakhale_kutsutsana kwatsatanetsatane, gwiritsani ntchito chiwerengero chotsutsa kwa masiku angapo
mapeto a sabata - (zosankha) zikuwonetsera masiku ati a sabata omwe amawerengedwa kuti ndi masiku otsiriza komanso osapatula masiku awa masiku onse ogwira ntchito
- chifukwa chatsutsano, lowetsani nambala ya nambala yamapeto ya sabata kapena selo lotanthauzira selo pa deta iyi pa tsamba la ntchito
- ngati mfundoyi isalephereke, zosasintha 1 (Loweruka ndi Lamlungu) zimagwiritsidwa ntchito pamtunda wa mlungu
- onani mndandanda wathunthu wa ma nambala pa tsamba 3 la phunziroli
maholide - (zosankha) tsiku limodzi kapena zina zina zowonjezera zomwe sizichotsedwa masiku onse ogwira ntchito
- masiku a tchuthi angalowetsedwe ngati manambala a tsiku lachidule kapena mafotokozedwe a selo kumalo a zikhalidwe zamtundu wanu pa tsamba
- ngati mafotokozedwe a maselo akugwiritsidwa ntchito, malingaliro amtundu amayenera kulowetsedwa m'maselo pogwiritsa ntchito DATE , DATEVALUE kapena TO_DATE kuti asapewe zolakwika
Chitsanzo: Pezani Tsiku Lomaliza la Project ndi Ntchito WORKDAY.INTL
Monga momwe tawonera pa chithunzi pamwambapa, chitsanzo ichi chigwiritsa ntchito ntchito ya WORKDAY.INTL kupeza tsiku lomaliza la polojekiti yomwe imayamba pa July 9, 2012 ndipo imatha masiku 82 pambuyo pake.
Maholide awiri (September 3 ndi Oktoba 8) omwe amapezeka panthawiyi sadzakhala ngati gawo la masiku 82.
Kuti mupewe mavuto owerengera omwe angakhoze kuchitika ngati masiku amalowa mwachinsinsi monga malemba, ntchito ya DATE idzagwiritsidwa ntchito kulemba masiku omwe amagwiritsidwa ntchito ngati zifukwa. Onani gawo la zolakwika zamagulu pamapeto a phunziro ili kuti mudziwe zambiri.
Kulowa Deta
A1: Tsiku loyambira: A2: Chiwerengero cha masiku: A3: Tchuthi 1: A4: Tchuthi 2: A5: Tsiku lomaliza: B1: = DATE (2012,7,9) B2: 82 B3: = DATE (2012,9,3) ) B4: = DATE (2012,10,8)- Lowani deta zotsatirazi mu selo yoyenera:
Ngati masiku mu maselo b1, B3, ndi B4 sakuwoneka monga momwe asonyezedwera pamwambapa, fufuzani kuti muwonetse kuti maselowa amawongolera kuti asonyeze deta pogwiritsa ntchito mawonekedwe a tsiku lalifupi.
02 a 03
Kulowa ntchito ya WORKDAY.INTL
Kulowa ntchito ya WORKDAY.INTL
Ma spreadsheets a Google samagwiritsa ntchito ma bokosi a malingaliro kuti alowe mmaganizo a ntchito monga angapezeke mu Excel. M'malo mwake, ili ndi bokosi lopangira mothandizira lomwe limatuluka ngati dzina la ntchito likuyimikidwa mu selo.
- Dinani pa selo B6 kuti likhale selo yogwira ntchito - izi ndi zomwe zotsatira za ntchito ya WORKDAY.INTL iwonetsedwe
- Lembani chizindikiro chofanana (=) potsatira dzina la ntchito , tsiku loyamba
- Pamene mukuyimira, bokosi lopangira mothandizidwa limapezeka ndi maina ndi ma syntax a ntchito zomwe zimayamba ndi kalata W
- Pamene dzina lakuti WORKDAY.INTL likuwonekera m'bokosilo, dinani pa dzina ndi ndondomeko ya mouse kuti mulowetse dzina la ntchito ndi kutsegula makina ozungulira mu selo B6
Kulowa Magulu a Ntchito
Monga momwe tawonera mu chithunzi pamwambapa, zifukwa za ntchito ya WORKDAY.INTL imalowa pambuyo pa bolodi lozungulira lotseguka mu selo B6.
- Dinani pa selo B1 mu tsamba lothandizira kuti mulowetse mndandanda wa seloyi monga mtsutso_kuyamba
- Pambuyo powerenga selo, tanizani comma ( , ) kuti mukhale olekanitsa pakati pa zotsutsana
- Dinani pa selo B2 kuti mulowetse mndandanda wa seloyi monga nambala ya_nkhaniyi
- Pambuyo pa selo yowonjezera, yesani mtundu wina
- Dinani pa selo B3 kuti mulowetse selo ili ngati mkangano wa sabata
- Onetsetsani maselo B4 ndi B5 papepala kuti mulowetse maumboni awa monga kukangana kwa tchuthi
- Dinani pakiyi ya kulowani pa kibokosilo kuti mulowetse mzere womaliza " ) " mutatha kukangana komaliza ndikukwaniritsa ntchitoyi
- Tsiku la 11/29/2012 - tsiku lomalizira la polojekitiyi - liyenera kuwonedwa mu selo B6 la tsamba
- Mukasindikiza pa selo b5 ntchito yonse
= WORKDAY.INTL (B1, B2, B3, B4: B5) ikupezeka pa bar lamuzula pamwamba pa tsamba
The Math kumbuyo kwa Ntchito
Momwe Excel ikuwerengera tsikuli ndi:
- Tsiku limene liripo masiku asanu ndi atatu antchito pambuyo pa August 5, 2012, ndi November 27 (tsiku loyambali silinali ngati limodzi la masiku 82 ndi ntchito WORKDAY.INTL)
- Kuonjezerapo mpaka tsiku lino, masiku awiri a tchuthi adatchulidwa (August 19 ndi November 15) omwe sanawerengedwe ngati mbali ya mtsutso wa masiku 82
- Tsiku lomaliza la polojekitiyi ndilo Lachinayi, Novemba 29, 2012
WORKDAY.INTL Ntchito Yoposera Makhalidwe
Ngati deta ya zifukwa zosiyanasiyana za ntchitoyi sizinalembedwe molondola malingaliro olakwika otsatirawa akuwonekera mu selo kumene ntchito ya WORKDAY ilipo:
- #VALUE! : imawoneka mu selo yankho Ngati imodzi mwa mfundo za WORKDAY sizolondola (ngati tsikulo linalembedwera monga chitsanzo)
- #NUM !: ikuwoneka mu selo yankho ngati tsiku losavomerezeka limachokera kuwonjezera zowonjezera Start_date ndi Days
- Ngati masiku otsutsana sakulowa ngati nambala - monga masiku 83.25 - chiwerengerocho chidzaperekedwa ku chiwerengero cha nambala: masiku 83
03 a 03