Cov txheej txheem:
- Kauj Ruam 1: Kaum plaub daim qhia hnub hli
- Kauj Ruam 2: Tsim Kab Ntawv Headers rau Koj Daim Ntawv Qhia Excel
- Kauj Ruam 3: Tsim Cov Npe Hnub Xyoo Tshiab
- Kauj Ruam 4: Zaub Hnub ntawm Lub Limtiam
- Kauj Ruam 5: Qhia Hnub Zej Zog ntawm Lub Limtiam
- Kauj Ruam 6: Txiav txim seb Puas Yog Xyoo Muab Yog Xyoo Leap
- Kauj Ruam 7: Muab Lub Xyoo
- Kauj Ruam 8: Luam Txhua Cov Qauv
- Kauj Ruam 9: Hloov Cov Qauv rau Qhov Muaj Peev Xwm
- Kauj Ruam 10: Txheeb Hom Hom Xyoo Ua Ke
- Kauj Ruam 11: Txheeb Xyoo Raws Li Hom Xyoo
- Kauj Ruam 12: Nrhiav Daim Ntawv Teev Npe
Video: Siv Vintage Calendars: 12 Kauj Ruam
2024 Tus sau: John Day | [email protected]. Kawg hloov kho: 2024-01-30 09:31
Tsuas muaj 14 daim ntawv qhia hnub tshwj xeeb; cov lus qhia no yuav qhia koj yuav siv Excel li cas los ua cov npe ntawm daim ntawv qhia hnub xyoo, yog li koj tuaj yeem tso saib koj daim ntawv qhia hnub nyoog uas raug rau lub xyoo tam sim no. Koj tseem tuaj yeem siv cov txheej txheem no los tso saib daim ntawv qhia hnub nyoog yav tom ntej es tsis yog daim ntawv qhia hnub qub. Cov lus qhia tso tawm ntawm no ua haujlwm nrog ib qho tam sim no ntawm Excel, txawm hais tias cov lus qhia yuav ua raws siv Excel 2007. Cov lus qhia no tseem yuav qhia qee lub sijhawm txuag Excel cov lus qhia.
Kauj Ruam 1: Kaum plaub daim qhia hnub hli
Muaj kaum plaub yam qauv ua tau rau daim qhia hnub hli; cov npe hauv qab no qhia tag nrho cov xwm txheej uas tuaj yeem ua tau. Hom 1: Xyoo pib rau hnub Sunday, tab sis nws tsis yog xyoo leapType 2: Xyoo pib rau hnub Sunday, thiab nws yog xyoo leapType 3: Xyoo pib rau hnub Monday, tab sis nws tsis yog xyoo leapType 4: Xyoo pib rau hnub Monday, thiab nws yog xyoo leapType 5: Xyoo pib rau hnub Tuesday, tab sis nws tsis yog xyoo leapType 6: Xyoo pib rau hnub Tuesday, thiab nws yog xyoo leapType 7: Xyoo pib rau hnub Wednesday, tab sis nws tsis yog xyoo leapType 8: Xyoo pib rau hnub Wednesday, thiab nws yog xyoo leapType 9: Xyoo pib rau hnub Thursday, tab sis nws tsis yog xyoo leapType 10: Xyoo pib rau hnub Thursday, thiab nws yog xyoo leap Hom 11: Xyoo pib rau hnub Friday, tab sis nws tsis yog xyoo leapType 12: Xyoo pib rau hnub Friday, thiab nws yog xyoo leapType 13: Xyoo pib rau hnub Saturday, tab sis nws tsis yog xyoo leapType 14: Xyoo pib rau hnub Saturday, thiab nws yog xyoo leap
Kauj Ruam 2: Tsim Kab Ntawv Headers rau Koj Daim Ntawv Qhia Excel
Hauv koj daim ntawv Excel, sau cov cell raws li hauv qab no: Cell A1: StartCell B1: DOWCell C1: Hnub (Hnub = 1) Cell D1: Leap? Cell E1: TypeCell F1: Xyoo
Kauj Ruam 3: Tsim Cov Npe Hnub Xyoo Tshiab
Hauv cell A2, sau hnub tim 1/1/1901. Excel muaj kab uas tsis raug xav tias 1900 yog xyoo leap, yog li tsis txhob pib ua ntej xyoo 1901. Txoj cai rau xyoo leap yog qhov yooj yim: Xyoo yuav tsum tau faib sib npaug los ntawm 4, tshwj tsis yog lub xyoo xaus hauv 00 qhov xwm txheej twg xyoo kuj yuav tsum sib npaug sib npaug ntawm 400. Yog li, 1900 tsis yog xyoo dhau mus, tab sis 2000 yog nyob hauv cell A3, sau hnub tim 1/1/1902. Tuav koj sab laug nas, thiab xaiv cov cell A2 thiab A3. Koj yuav pom tias nyob rau sab qis-sab xis ntawm kev xaiv muaj lub thawv dub me me; tuav koj tus nas khawm sab laug, xaiv lub thawv dub me me thiab rub qis (thaum koj tus nas hovering hla qhov chaw raug, nws yuav tig mus rau 'kos npe ntxiv'). Thaum koj rub qis, koj yuav pom tias hnub tim yuav tshwm. Luag nqes mus txog thaum koj mus txog rau 1/1/2036 thiab tso lub khawm nas sab laug. Tias yog thaum kuv tuaj yeem so haujlwm, muab kev lag luam tam sim no!
Kauj Ruam 4: Zaub Hnub ntawm Lub Limtiam
Hauv cell B2, nkag mus = A2. Qhov no yuav qhia 1/1/1901. Tom qab ntawd nrog tus cursor tseem nyob hauv cell B2 xaiv Hom Ntawv, Format Cells, xaiv Custom, thiab hauv Hom: teb sau dddd. Qhov no tsim cov txheej txheem tus lej rau hnub uas qhia hnub ntev ntawm lub lim tiam.
Kauj Ruam 5: Qhia Hnub Zej Zog ntawm Lub Limtiam
Hauv cell C2, sau cov mis = WEEKDAY (A2) thiab nias nkag mus. WEEKDAY ua haujlwm rov qab tus lej rau hnub ntawm lub lim tiam. Los ntawm kev nkag mus rau txoj haujlwm no, Hnub Sunday = 1, Hnub Monday = 2, thiab lwm yam. Txij li 1/1/1901 yog hnub Tuesday, qhov sib npaug rov qab los 3.
Kauj Ruam 6: Txiav txim seb Puas Yog Xyoo Muab Yog Xyoo Leap
Hauv xov tooj ntawm tes D2, peb tab tom yuav nkag mus rau cov qauv sib luag kom paub tseeb tias lub xyoo yog xyoo dhau los lossis tsis yog. Txij li qhov sib npaug yog qhov ncaj ncees, kuv yuav qhia nws hauv qab no thiab tom qab ntawd piav qhia nws ua li cas nws ua. Nov yog qhov sib npaug (nkag mus raws nraim raws li qhia hauv cell D2): = YOG (LOS YOG (MOD (YEAR (A2), 400) = 0, THIAB (MOD (YEAR (A2), 4) = 0, MOD (YEAR (A2), A2)), 100) 0)), "Leap", "") MOD luv luv rau cov qauv, uas yog cov lej sib faib uas tuaj yeem faib tau yam tsis muaj qhov seem ntawm qhov sib txawv ntawm ob qho ntxiv. Piv txwv li, 2 yog tus qauv ntawm 5 thiab 9. Qhov LOS YOG hauv qhov kev ntsuas zauv rau peb yam xwm txheej, ob qho ntawm (THIAB) yuav tsum tshwm sim ua ke: Xyoo nyob hauv xov tooj ntawm tes A2, thaum faib los ntawm 400, yog tus lej tag nrho (piv txwv li seem = 0) Nov yog THIAB (ob qho xwm txheej hauv qab no yuav tsum tshwm sim): Xyoo hauv cell A2, thaum faib los ntawm 4, yog tus lej tag nrho (piv txwv li qhov seem = 0) Xyoo hauv cell A2, thaum faib los ntawm 100, yog tsis yog tus lej tag nrho (piv txwv li seem 0) Yog tias thawj ntawm peb qhov xwm txheej tau ntsib LOS YOG ob qho ntawm ob qhov xwm txheej tom ntej tau ntsib, tom qab ntawv cov mis rov qab lo lus Leap. Txwv tsis pub, cov txiaj ntsig tau tshwm sim hauv qhov khoob (uas yog ""). Thaum koj nias nkag mus, koj yuav tsis pom dab tsi vim tias xyoo 1901 tsis yog xyoo leap.
Kauj Ruam 7: Muab Lub Xyoo
Hla hla cell E2 (peb yuav sau qhov ntawd tom qab). Hauv cell F2, nkag mus rau qhov sib npaug = YEAR (A2). Qhov no yuav rub tsuas yog xyoo tawm ntawm hnub tim. Thaum koj nias nkag mus rau ntawm tes yuav tsum hais 1901.
Kauj Ruam 8: Luam Txhua Cov Qauv
Highlight cells B2 mus txog F2. Koj yuav pom tias nyob rau sab qis-sab xis ntawm kev xaiv muaj lub thawv dub me me; tuav koj tus nas khawm sab laug, xaiv lub thawv dub me me thiab luag nqis (thaum koj tus nas hoverer hla qhov chaw raug, nws yuav tig mus rau 'kos npe ntxiv'). Thaum koj rub qis, koj yuav pom tias hnub yuav tshwm. Luag nqes mus txog thaum koj mus txog 1/1/2036 thiab tso lub pob nas sab laug. Thaum koj tso tus nas khawm, txhua tus qauv uas koj tau sau yuav raug theej rau hauv qab ntawm daim ntawv nthuav qhia. Koj pom qee xyoo sau tias Leap. Cov ntawd yog cov leap xyoo.
Kauj Ruam 9: Hloov Cov Qauv rau Qhov Muaj Peev Xwm
Hauv cov kauj ruam no, peb yuav hloov tag nrho peb cov qauv rau qhov muaj nuj nqis. Qhov koj tus cursor mus rau cell A2. Tuav tus yuam sij ua haujlwm, coj mus rhaub qhov kawg ces coj mus rau xub xub. Tsis txhob tso tus yuam sij ua haujlwm. Tam sim no koj yuav tsum muaj tag nrho cov hnub (nqes mus rau 1/1/2036) tseem ceeb. Thaum tseem tseem tuav tus yuam sij Hloov, nias lub xub xub tsib zaug. Tam sim no koj yuav tsum muaj cov hlwb A2 txog F137 tau hais tseg. Txoj cai-nas hauv thaj chaw tseem ceeb. Tus ciam teb yuav tsum hloov mus rau txoj kab dotted. Xaiv Luam los ntawm cov ntawv qhia luv. Tom qab ntawd, txoj cai nas dua, tab sis lub sijhawm no xaiv Muab Tshwj Xeeb, nyem rau ntawm qhov tseem ceeb xov tooj cua khawm, thiab xaiv OK. Txheeb xyuas txhua lub xovtooj uas muaj tus qauv (zoo li C2 lossis F2); cov mis yuav tsum tau hloov los ntawm cov txiaj ntsig cov txiaj ntsig.
Kauj Ruam 10: Txheeb Hom Hom Xyoo Ua Ke
Txav koj tus cursor mus rau cell A2. Xaiv Sort & Filter, tom qab ntawd xaiv Custom Sort. Sort by the Day (Sun = 1) thiab Leap? kab. Nyem OK. Koj cov ntaub ntawv yuav raug txheeb kom txhua yam ntawm Hom 1 (lub lim tiam pib rau hnub Sunday, tsis yog xyoo leap) yog ua ke, thiab lwm yam.
Kauj Ruam 11: Txheeb Xyoo Raws Li Hom Xyoo
Txav koj tus cursor mus rau cell E2. Nkag mus rau tus lej rau hom daim ntawv qhia hnub los ntawm Kauj Ruam 1 mus txog txhua hnub hauv daim ntawv teev npe. Cov npe tau rov ua dua hauv qab no ib yam nkaus. Hom 1: Xyoo pib rau hnub Sunday, tab sis nws tsis yog xyoo leapType 2: Xyoo pib hnub Sunday, thiab nws yog xyoo leapType 3: Xyoo pib rau hnub Monday, tab sis nws tsis yog xyoo leapType 4: Xyoo pib hnub Monday, thiab nws yog xyoo leapType 5: Xyoo pib rau hnub Tuesday, tab sis nws tsis yog xyoo leapType 6: Xyoo pib rau hnub Tuesday, thiab nws yog xyoo leapType 7: Xyoo pib rau hnub Wednesday, tab sis nws tsis yog xyoo leapType 8: Xyoo pib hnub Wednesday, thiab nws yog xyoo leapType 9: Xyoo pib rau hnub Thursday, tab sis nws tsis yog xyoo leapType 10: Xyoo pib rau hnub Thursday, thiab nws yog xyoo leap Hom 11: Xyoo pib rau hnub Friday, tab sis nws tsis yog xyoo leapType 12: Xyoo pib rau hnub Friday, thiab nws yog xyoo leapType 13: Xyoo pib rau hnub Saturday, tab sis nws tsis yog xyoo leapType 14: Xyoo pib rau hnub Saturday, thiab nws yog xyoo leap
Kauj Ruam 12: Nrhiav Daim Ntawv Teev Npe
Txhawm rau nrhiav lub xyoo tshwj xeeb, nias CTRL F ntawm koj cov keyboard, thiab tshawb rau xyoo. Piv txwv li, 2009 yog daim ntawv qhia hnub nyoog 5. Qhov ntawd txhais tau tias koj tuaj yeem siv daim ntawv qhia hnub nyoog los ntawm ib xyoos twg ntawm tib hom (1903, 1914, 1925, 1931, 1942, 1953, 1959, 1970, 1981, 1987, 1998, 2009, 2015, lossis 2026) thiab nws yuav zoo ib yam rau xyoo no daim ntawv qhia hnub. Qhov txawv txaus, qhov no yog lub xyoo yug tseem ceeb rau kuv, thiab xyoo no daim ntawv qhia hnub zoo ib yam rau xyoo uas kuv tau yug los. Kuv tso nws li kev tawm dag zog rau tus tub ntxhais kawm txhawm rau txiav txim siab tias kuv muaj hnub nyoog li cas. Txaus siab rau!
Pom zoo:
Cov Khoom Siv Teeb Meem Siv Chaw Taws Teeb Siv Arduino: 7 Kauj Ruam
Cov Khoom Siv Teeb Meem Siv Khoom Siv Hluav Taws Xob Siv Arduino: Tam sim no, Cov Tsim, Cov tsim tawm tau nyiam Arduino rau kev txhim kho sai ntawm cov qauv ntawm cov phiaj xwm. Arduino yog lub platform siv hluav taws xob qhib raws qhov yooj yim-rau-siv-kho vajtse thiab software. Arduino muaj zej zog cov neeg siv zoo heev. Hauv qhov no
Saib Xyuas Kev Siv Sijhawm Siv Raspberry Pi thiab AIS328DQTR Siv Python: 6 Cov Kauj Ruam
Saib Xyuas Kev Siv Sijhawm Siv Raspberry Pi thiab AIS328DQTR Siv Python: Kev nrawm yog qhov kawg, Kuv xav raws li qee txoj cai ntawm Physics.- Terry Riley Tus cheetah siv qhov nrawm nrawm thiab hloov pauv sai thaum caum. Tus tsiaj nrawm tshaj plaws nyob ntawm ntug hiav txwv ib zaug hauv ib lub sijhawm siv nws qhov nrawm tshaj plaws kom ntes tau cov tsiaj txhu. Qhov
Txawb Xov Tooj Siv Yooj Yim Siv STM32F407 Cov Khoom Siv Tshawb Pom thiab GSM A6 Module: 14 Cov Kauj Ruam (nrog Duab)
Kev Siv Xov Tooj Ntawm Lub Xov Tooj Siv STM32F407 Cov Khoom Siv Tshawb Pom thiab GSM A6 Module: Koj puas tau xav tsim qhov kev ua kom txias txias? Yog tias yog, ua li cas txog kev tsim ib qho ntawm cov neeg nyiam tshaj plaws thiab txhua tus nyiam cov khoom siv xws li Lub Xov Tooj Txawb !!!. Hauv Cov Lus Qhia no, Kuv yuav qhia koj yuav tsim lub xov tooj txawb yooj yim siv STM li cas
Tsis Siv Neeg Kev Hla Hla Kev Siv Hluav Taws Xob Siv Arduino Raws Kev Nkag Nkag Platform: 9 Cov Kauj Ruam
Tsis Siv Neeg Kev Hla Hla Kev Siv Hluav Taws Xob Siv Arduino Raws Kev Nkag Siab Platform: Christmas tsuas yog ib lub lim tiam xwb! Txhua leej txhua tus tibneeg hu tauj coob nrog kev ua koob tsheej thiab tau txais khoom plig, uas, los ntawm txoj kev, tau txais txhua qhov nyuaj dua kom tau nrog qhov tsis muaj peev xwm nyob ib puag ncig peb. Yuav ua li cas mus los ntawm khoom plig qub thiab ntxiv qhov kov ntawm DIY rau
Arduino Neeg Hlau Nrog Kev Nyob, Kev Qhia thiab Qib Kev Sib Hloov (Sab Hnub Poob, Sab Hnub Poob, Sab Qaum Teb, Sab Qab Teb) Tswj los ntawm Lub Suab Siv Bluetooth Module thiab Kev Siv Tus Neeg Siv Hluav Taws Xob: 6 Kauj Ruam
Arduino Neeg Hlau Nrog Kev Nyob, Kev Qhia thiab Qib Kev Sib Hloov (Sab Hnub Poob, Sab Hnub Poob, Sab Qaum Teb, Sab Qab Teb) Tswj los ntawm Lub Suab Siv Bluetooth Module thiab Kev Siv Tus Neeg Siv Hluav Taws Xob: Cov lus qhia no piav qhia yuav ua li cas thiaj tsim tau Arduino Robot uas tuaj yeem txav mus raws qhov xav tau (Forward, Backward) , Sab laug, Txoj Cai, Sab Hnub Poob, Sab Hnub Poob, Sab Qaum Teb, Sab Qab Teb) xav tau Kev nrug deb hauv Centimeters siv lub suab hais kom ua. Neeg hlau kuj tseem tuaj yeem txav tau tus kheej