വڱʼ Excel ښѣጪࡰᄊऄၹ
ǏᄺдⳂᷛǐ 1ˊњ㾷ߎ㒇ቫԡⱘ㘠䋷ǃᴀ⌕ǃḌㅫӏࡵ᳝݇ㅵ⧚㾘ᅮ˗ 2ˊ❳ⶹӕϮӮ䅵ߎ㒇ቫԡⱘᎹᇍ䈵ǃݙᆍǃᑣᮍ⊩˗ 3ˊ㛑䖤⫼ Excel Ꮉˈḍ㒣⌢Ϯࡵ䆄ད⦄䞥䫊㸠ᄬℒ᮹䆄䋺˗ 4ˊ㛑䖤⫼ Excel Ꮉˈᇍ⦄䞥䫊㸠ᄬℒ䖯㸠⏙ᶹˈᑊᇍ⏙ᶹ㒧ᵰ䖯㸠Ⳍᑨ䋺ࡵ໘⧚ˈ Ӯ㓪ࠊ䌘䞥᮹㸼ǃ䫊㸠ᄬℒԭ乱䇗㡖㸼DŽ Ǐ䞡⚍䲒⚍ǐ 1ˊᣝ✻ߎ㒇ҎਬᅵḌৢⱘ⦄䞥ᬊǃҬℒ䆄䋺߁䆕䫊㸠Ҭℒ߁䆕ˈ䗤᮹䗤ヨᣝ乎ᑣⱏ䆄 ড⦄䞥ޣবࡼᚙމˈ䖯㸠᮹ᐌ⦄䞥᮹䆄䋺ⱘ໘⧚˗ 2ˊᣝ✻䫊㸠ᄬℒⱘᬊǃҬℒ䆄䋺߁䆕䗤᮹䗤ヨ乎ᑣⱏ䆄ˈҹ䆄ᔩᔶᓣড䫊㸠ᬊᬃঞ㒧 ᄬᚙމˈ䖯㸠᳝݇䫊㸠ᄬℒ᮹䆄䋺ⱘㅵ⧚˗ 3ˊḍ⦄䞥᮹䆄䋺ˈ㓪ࠊ䌘䞥᮹㸼˗ 4ˊḍ䫊㸠ᄬℒ᮹䆄䋺ˈ㓪ࠊ䫊㸠ᄬℒԭ乱䇗㡖㸼DŽ ߎ㒇ᎹᰃӕϮӮ䅵Ḍㅫ໘⧚ⱘḌᖗᎹˈᰃӕϮӮ䅵໘⧚ⱘ䞡㽕⦃㡖DŽ ߎ㒇Ꮉᰃ⬅ϧҎᣝ✻݀ৌ㉏䋶ࡵㅵ⧚ࠊᑺˈ㸨ད䋶ࡵ䚼ቫԡᎹݙᆍⱘ⸔ Ϟˈࡲ⧚ᴀऩԡⱘ⦄䞥ᬊҬǃ䫊㸠ᄬℒᬊҬঞ᳝݇ⱘ䋺ࡵ໘⧚ˈമᣕ↣Ⲭ⚍⦄䞥ˈঞᯊḌᇍ ⦄䞥᮹䆄䋺ˈخࠄ᮹⏙᳜㒧ˈ䱣ᯊᥠᦵ䫊㸠᠋༈ԭ乱ˈ⽕ℶㅒথぎ༈ᬃ⼼ˈཹֱㅵ⦄䞥ǃ ᳝Ӌ䆕ࠌǃ䋶ࡵॄゴঞ᳝݇⼼ㄝᎹⱘᘏ⿄DŽ ߎ㒇ቫⱘᎹ⌕བ 3-1 ᠔⼎DŽ 3-1 ߎ㒇Ꮉ⌕ 䫔ଂ ᑨҬℒ ᑨҬℒ ᘏ䋺 ⦄䞥ㅵ⧚ ݊Ҫ㋏㒳 ᑨᬊ⼼ 㚠кǃ䌈⦄ㄝ ᑨᬊ⼼ 䞛䌁থ⼼ ݊ҪᑨҬऩ ᅵḌ ᬊℒऩ 䇗ޣ 䇗∛ ໘⧚ 䋺ࡵ ໘⧚ ߁ᕕ ݇㘨 Ḍ䫔 䫔ଂথ⼼ ᑨᬊऩ ݊Ҫ ᅶ᠋ ㅵ⧚ ড়ৠ ㅵ⧚ ֵ⫼ࠊ 䫔ଂথ⼼ 䫔ଂ䅶ऩ ݇㘨 䇗⬅Ѣ᮹ᐌߎ㒇⍝ঞⱘ᭄ᴖ㐕ˈᛇདഄㅵ⧚᭄ˈৃҹ䗮䖛ᔎⱘ㸼Ḑ᭄໘⧚ 䕃ӊ Excel Ꮉᴹᅲ⦄DŽ ᴀഫⱘЏ㽕ݙᆍህᰃҟ㒡߽⫼ Excel Ꮉˈᅠ៤ߎ㒇ቫԡⱘಯϾൟᎹݙᆍࣙᣀ˖㛑 䖯㸠⦄䞥᮹䆄䋺ⱘㅵ⧚ǃ䌘䞥᮹㸼ⱘ໘⧚ǃ䫊㸠ᄬℒ᮹䆄䋺ㅵ⧚ҹঞ㓪ࠊԭ乱䇗㡖㸼˗ᄺ дᥠᦵ Excel Ё݀ᓣǃߑ᭄ঞ݊ҪᎹⱘՓ⫼ᮍ⊩ˈޚ⹂催ᬜഄᅠ៤ߎ㒇ቫԡⳌ݇џࡵDŽ ᴀഫⱘ䆒䅵ᗱ䏃ᰃ˖佪ܜˈḍᅲ䰙㒣⌢Ϯࡵ㓪䕥⦄䞥᮹䆄䋺ⱘ᭄˗݊ˈ߯ᓎ䌘 䞥᮹㸼˗✊ৢˈḍ䫊㸠ᬊᬃঞ㒧ᄬᚙމ㓪䕥䫊㸠ᄬℒ᮹䆄䋺ⱘ᭄˗᳔ৢˈḌᶹ䫊㸠ᄬℒ ᮹䆄䋺䫊㸠ᦤկⱘᇍ䋺ऩˈ߯ᓎ䫊㸠ᄬℒԭ乱䇗㡖㸼DŽ Ǐᚙ๗ǐ ᶤ݀ৌ 2013 ᑈ 12 ᳜ 1 ᮹ᑧᄬ⦄䞥᮹䆄䋺䫊㸠ᄬℒ᮹䆄䋺ⱘ᳜߱ԭ乱ߚ߿Ў 2500 ܗ 168900ܗDŽ 2014ᑈ 1 ᳜থ⫳Ϣᑧᄬ⦄䞥᳝݇ⱘϮࡵབϟ˖ ˄1˅1 ᳜ 3 ᮹ˈᬊࠄ䫔ଂଚકⱘ㧹Ϯℒ 35000 ܗDŽ ˄2˅1 ᳜ 3 ᮹ˈϮࡵਬᓴᶤ䫔䗮䆃䌍 300 ܗDŽ ˄3˅1 ᳜ 3 ᮹ˈ䗔䖬կᑨଚ A ⱘଚકֱ䆕䞥 20000 ܗDŽ ˄4˅1 ᳜ 3 ᮹ˈᬊࠄ䌞䫔ℒ 25000 ܗDŽ ˄5˅1 ᳜ 3 ᮹ˈҢ䫊㸠ᦤপ⦄䞥 50000 ܗˈ⫼ѢথᬒᎹ䌘DŽ ˄6˅1 ᳜ 3 ᮹ˈথᬒᎹ䌘 50000 ܗDŽ ˄7˅1 ᳜ 3 ᮹ˈᇚᑧᄬ⦄䞥 40000 ܗᄬܹ䫊㸠DŽ ˄8˅1 ᳜ 3 ᮹ˈᬊࠄᴢᶤϾҎ䖬ℒ 500 ܗDŽ ˄9˅1 ᳜ 4 ᮹ˈϮࡵਬ⥟ᶤ䫔Ꮒᮙ䌍 1200 ܗDŽ ˄10˅1 ᳜ 4 ᮹ˈᬊࠄ䫔ଂଚકⱘ㧹Ϯℒ 20000 ܗDŽ ˄11˅1 ᳜ 4 ᮹ˈ䍉ᘏ׳ℒ 5000 ܗDŽ 2014ᑈ 1 ᳜থ⫳Ϣ䫊㸠ᄬℒ᳝݇ⱘϮࡵབϟ˖ ˄1˅1 ᳜ 3 ᮹ˈҢ䫊㸠ᦤপ⦄䞥 50000 ܗ˄⦄䞥ᬃ⼼ 9558#˅ˈ⫼ѢথᬒᎹ䌘DŽ ˄2˅1 ᳜ 3 ᮹ˈᇚᑧᄬ⦄䞥 40000 ܗᄬܹ䫊㸠DŽ ˄3˅1 ᳜ 6 ᮹ˈᬊࠄ䫊㸠䕀ᴹⱘ䌘䞥∛ߦ㸹ܙ߁䆕ˈ䞥乱 200000 ܗˈЎ䌁䋻ऩԡ⬉∛ᴹ ⱘ䋻ℒDŽ ˄4˅1 ᳜ 7 ᮹ˈഄկ䋻ऩԡ⬉∛ଚકঞؐℒ 81900 ܗDŽ ˄5˅1 ᳜ 10 ᮹ˈ䌁ф䫊㸠䕀䋺ᬃ⼼ㄝ㒧ㅫ߁䆕ˈᬃҬ 200 ܗDŽ ˄6˅1 ᳜ 15 ᮹ˈᓔߎ䕀䋺ᬃ⼼˄6370#˅ˈᇚ 46200 ܗ䕀䋺⫼Ѣ㸹㔈ℒDŽ ˄7˅1 ᳜ 20 ᮹ˈᓔߎ⦄䞥ᬃ⼼˄9559#˅ϔᓴˈᦤপ⦄䞥 5000 ܗ⫼DŽ ˄8˅1 ᳜ 21 ᮹ˈᢳࠄഄ䞛䌁⡍䫊㸠⬇䇋ㅒথ䫊㸠∛⼼ 100000 ܗˈ䫊㸠㒭Ϣㅒথ˄䫊 㸠∛⼼ 743#˅ᑊᬊপܼ乱ֱ䆕䞥DŽ ˄9˅1 ᳜ 23 ᮹ˈ⫳ѻ㒣㧹䳔㽕䫊㸠䌋ℒ 500000 ܗˈḍ׳ℒড়ৠˈ䫊㸠ᇚℒ乍ߦ 䕀ࠄ䋺DŽ ˄10˅1 ᳜ 28 ᮹ˈᬊࠄ䫊㸠⡍⾡ྨᠬᬊℒⱘҬℒ䗮ⶹ˄7543#˅ঞ⬉ֵᬊ䌍ऩˈᬃҬ⬉ 䆱䌍 5340 ܗDŽ
˄11˅1 ᳜ 31 ᮹ˈᬊࠄ䌁䋻ऩԡㅒথⱘ䕀䋺ᬃ⼼˄9824#˅ϔᓴˈ䞥乱 46800 ܗDŽ ˄12˅1 ᳜ 31 ᮹ˈㅒথ䕀䋺ᬃ⼼˄6371#˅ˈ䞥乱 7800 ܗˈ⫼Ѣ䌁фࡲ݀⫼કDŽ 2014ᑈ 2 ᳜ 3 ᮹ᬊࠄЁᎹଚ䫊㸠থᴹⱘ 1 ᳜ӑ䫊㸠ᇍ䋺ऩˈབ㸼 3-1 ᠔⼎DŽ 㸼 3-1 ЁᎹଚ䫊㸠ᇍ䋺ऩ ᅶ᠋ৡ⿄˖ 2014ᑈ 1 ᳜ ᳜ ᮹ ᨬ㽕 ׳ᮍ 䌋ᮍ ԭ乱 1 3 Ϟ᳜㒧䕀 168900.00 1 3 ⦄ᬃ 9558# 50000.00 118900.00 1 3 ⦄㔈 40000.00 158900.00 1 6 ∛ߦ 200000.00 358900.00 1 7 ⬉∛ 81900.00 440800.00 1 10 㒧ㅫ߁䆕 200.00 440600.00 1 16 䕀ᬃ 6370# 46200.00 394400.00 1 20 ⦄ᬃ 9559# 5000.00 394400.00 1 21 䫊∛ 6743# 100000.00 289400.00 1 22 䌋ℒ 500000.00 789400.00 1 27 ⡍ྨ 7543# 5340.00 784060.00 1 31 ∛ߦ䖯䋺 6040.00 790100.00 1 31 ⡍ྨ 8742# 15200.00 774900.00 1 31 ᳜ԭ乱 774900.00
ᮊᄬʷ ဘெᝮ᠍ኮေ
Ўњࡴᔎ䋻Ꮥ䌘䞥ⱘㅵ⧚ˈऩԡᖙ乏ᣝ✻Ӯ䅵⊩㾘ⱘ㾘ᅮˈ⬅ߎ㒇ҎਬḍᅵḌৢⱘ ⦄䞥ᬊǃҬℒ䆄䋺߁䆕䫊㸠Ҭℒ߁䆕ˈ䗤᮹䗤ヨᣝ乎ᑣⱏ䆄ড⦄䞥ޣবࡼᚙމˈ䆒㕂 ⦄䞥᮹䆄䋺DŽ ↣ヨϮࡵথ⫳ৢˈ䳔㽕䅵ㅫԭ乱˗↣᮹ᬊҬℒ䗤ヨⱏ䆄ᅠ↩ৢˈᑨߚ߿䅵ㅫ⦄䞥ᬊܹ ⦄䞥ᬃߎⱘড়䅵᭄ঞ䋺䴶ԭ乱ˈᑊϢᑧᄬ⦄䞥ᅲᄬ᭄ⳌḌᇍˈҹℸẔᶹ↣᮹⦄䞥ᬊᬃ㒧ᄬ ⱘᚙމˈ᳔㒜ᔶ៤⦄䞥᮹䆄䋺㈓DŽ ͊Ҭ 1 ဘெᝮ᠍ፇᄊᝠ Ўњㅔ࣪䆄䋺㓁ˈḌㅫⲥⴷ⦄䞥↣ⱘᬊܹǃᬃߎ㒧ᄬᚙމˈֱ䆕⦄䞥᮹䆄䋺ⱘ ᅝܼᅠᭈˈᴀ乍Ⳃ䞛⫼ϝᷣᓣ⦄䞥᮹䆄䋺䆒׳ᮍǃ䌋ᮍԭ乱ϝϾᴀ䞥乱ᷣⳂˈᇚ㒣⌢Ϯ ࡵЁϢ⦄䞥᳝݇ⱘᬊܹ䞥乱ݭ׳ᮍˈᇚ⦄䞥ᬃߎⱘ䞥乱ݭ䌋ᮍˈ䆹⦄䞥᮹䆄䋺ⱘ㸼༈Ḑᓣ བ 3-2 ᠔⼎DŽ 3-2 ⦄䞥᮹䆄䋺㸼༈Ḑᓣ 䆹⦄䞥᮹䆄䋺ԧⱏ䆄ᮍ⊩བϟ˖
˄1˅᮹ᳳᷣ˖㋏ᣛ䆄䋺߁䆕ⱘ᮹ᳳˈᑨϢ⦄䞥ᅲ䰙ᬊҬ᮹ᳳϔ㟈DŽ ˄2˅߁䆕ᷣ˖㋏ᣛⱏ䆄ܹ䋺ⱘᬊҬℒ߁䆕ⱘ㓪োˈҹ֓Ѣᶹ䋺ḌᇍDŽ ˄3˅㉏߿ᷣ˖⫼Ѣњ㾷㒣⌢Ϯࡵ⍝ঞ⦄䞥᠔ሲⱘ⾡㉏DŽ ˄4˅ᨬ㽕ᷣ˖ᨬ㽕䇈ᯢⱏ䆄ܹ䋺ⱘ㒣⌢Ϯࡵⱘݙᆍˈ᭛ᄫ㽕ㅔ㒗ˈԚ㽕㛑䇈ᯢ䯂乬DŽ ˄5˅׳䌋ԭ乱ᷣ˖㋏ᣛ↣ヨϮࡵথ⫳ᯊ⦄䞥ᅲ䰙ᬊҬⱘ䞥乱ˈ↣ⱘ㒧ԭᚙމDŽᘏПˈ ϔᴵ䆄ᔩডϔヨ㒣⌢Ϯࡵⱘথ⫳DŽ ᅠ៤⦄䞥᮹䆄䋺ⱘ㒧ᵘ䆒䅵DŽ ͊Ҭ 2 ဘெᝮ᠍ܫေ ḍᚙ๗ᦣ䗄 2014 ᑈ 1 ᳜থ⫳Ϣᑧᄬ⦄䞥᳝݇ⱘϮࡵᚙމˈᇍ⦄䞥᮹䆄䋺ⱘ᭄䖯㸠ᔩ ܹˈབ 3-3 ᠔⼎DŽ 3-3 ⦄䞥᮹䆄䋺Ꮉ㸼 Ўњᦤ催䕧᭄ܹⱘᬜ⥛ˈৃҹᇍϔѯऩܗḐ䆒㕂᳝ᬜᗻˈՓ⫼ Excel Ё᭄᳝ᬜᗻ䆒㕂 Ꮉᴹᅲ⦄ˈ՟བ˖⦄䞥᮹䆄䋺Ā㉏߿ā䖭ϔ߫ˈᇚᐌ㾕⦄䞥⾡㉏㔫߫ˈᑊ䖯㸠䗝ᢽˈԧ᪡ ᮍ⊩བϟ˖ ˄1˅ᠧᓔഫᎹ㈓ĀExcel ߎ㒇ቫⱘᑨ⫼āˈᮄᓎᎹ㸼Ā⦄䞥㉏߿ᅮНāDŽ ˄2˅ A ߫䕧ܹབ 3-4 ᠔⼎ⱘ᭛ᄫDŽ ˄3˅䖨ಲᎹ㸼Ā⦄䞥᮹䆄䋺āˈ䗝ᢽĀ㉏߿ā᠔ⱘ E ߫ˈऩߏĀ᭄ā䗝乍वⱘĀ᭄ Ꮉā㒘ЁĀ᭄᳝ᬜᗻāੑҸˈᠧᓔĀ᭄᳝ᬜᗻāᇍ䆱Ḛ䆒㕂᭄᳝ᬜᗻˈབ 3-5 ᠔⼎DŽ 3-4 ⦄䞥᮹䆄䋺㉏߿߫㸼 3-5 Ā᭄᳝ᬜᗻāᇍ䆱Ḛ䆒㕂 ˄4˅䗝ᢽऩܗḐ E6ˈ E6 ऩܗḐⱘে䴶֓Ӯߎ⦄ϔϾϟᢝㆁ༈ˈऩߏϟᢝㆁ༈ˈ֓ৃ 䗝ᢽⳌᑨⱘ㉏߿ˈབ 3-6 ᠔⼎DŽ 3-6 ϟᢝḚ䗝ᢽ䕧ܹ 㒭Ā㉏߿ā߫䆒㕂њ᭄᳝ᬜᗻҹৢˈৃҹⳕএᠧᄫⱘ咏⚺ˈৠᯊг䙓ܡњᔩܹ䫭䇃ˈ 䰆ℶњ⫼᠋䕧ܹ᮴ᬜ᭄ˈ䖯㗠ᦤ催њ᭄䕧ܹⱘᬜ⥛DŽৠ ḋˈ៥Ӏгৃҹ㒭䫊㸠ᄬℒ᮹䆄䋺ⱘĀ㉏߿ā߫䆒㕂᳝ᬜᗻ Ẕᶹ˖ Ꮉ㸼Ā䫊㸠ᄬℒ㉏߿ᅮНāⱘ A ߫䕧ܹབ 3-7 ᠔ ⼎᭛ᄫDŽ Ўњさߎ݇䬂ݙᆍⱘᰒ⼎ˈৃҹ㒭⡍ᅮऩܗḐ䆒㕂䝦Ⳃ ⱘḐᓣˈҹ֓⫼᠋ᶹ䯙ˈ՟བ˖⦄䞥᮹䆄䋺ЁĀᨬ㽕āЎᳳ ߱ԭ乱ǃᴀ᮹ড়䅵ǃᴀ᳜㌃䅵ⱘⳌ݇䆄ᔩˈՓ⫼ Excel Ёᴵӊ ḐᓣᎹᴹᅲ⦄ˈԧ᪡ᮍ⊩བϟ˖ ˄1˅Ā⦄䞥᮹䆄䋺āᎹ㸼Ё䗝ᢽ㽕䆒㕂Ḑᓣⱘऩܗ Ḑऎඳ B5:I70ˈĀᓔྟā䗝乍वϞⱘĀḋᓣā㒘ЁˈऩߏĀᴵӊḐᓣāϟᮍⱘㆁ༈ˈᠻ㸠 Āᮄᓎ㾘߭…āੑҸˈᠧᓔĀᮄᓎḐᓣ㾘߭āᇍ䆱Ḛˈབ 3-8 ᠔⼎DŽ ˄2˅Ā䗝ᢽ㾘߭㉏ൟāḚЁ䗝ᢽĀՓ⫼݀ᓣ⹂ᅮ㽕䆒㕂ḐᓣⱘऩܗḐāˈᑊ㓪䕥㾘߭ 䇈ᯢˈᔧ F ߫⒵䎇Āᳳ߱ԭ乱āǃĀᴀ᮹ড়䅵āǃĀᴀ᳜㌃䅵āӏԩϔ⾡ᴵӊᯊˈ䕧ܹᴵӊ݀ᓣˈ བ 3-9 ᠔⼎DŽ 3-7 䫊㸠ᄬℒ㉏߿߫㸼
3-8 ĀᮄᓎḐᓣ㾘߭āᇍ䆱Ḛ 3-9 ᴵӊ݀ᓣᇍ䆱Ḛ ˄3˅ऩߏǏḐᓣ…ǐᣝ䪂ˈᠧᓔǏ䆒㕂ऩܗḐḐᓣǐᇍ䆱ḚˈᇚǏᄫԧǐ䆒㕂Ў㑶㡆ࡴ ㉫ˈབ 3-10 ᠔⼎DŽ 3-10 ᴵӊऩܗḐᄫԧ䆒㕂 ˄4˅䗝ᢽǏ䖍Ḛǐ䗝乍वˈ䆒㕂㒓ᴵḋᓣЎĀ㒚ᅲ㒓āˈ䆒㕂㒓ᴵ买㡆ЎĀ㑶㡆āˈ✊ৢ 䗝ᢽĀϟ䖍Ḛāˈབ 3-11 ᠔⼎DŽ
3-11 ᴵӊऩܗḐ䖍Ḛ䆒㕂 ˄5˅ऩߏǏ⹂ᅮǐᣝ䪂ˈ݇䯁ǏᮄᓎḐᓣ㾘߭ǐᇍ䆱Ḛˈ䗔ߎᴵӊḐᓣⱘ䆒㕂ˈབ 3-12 ᠔⼎DŽ 3-12 ĀᮄᓎḐᓣ㾘߭āᇍ䆱Ḛ 䆒㕂њϞ䗄ᴵӊḐᓣҹৢˈᔧĀᨬ㽕āᷣे F ߫䕧ܹĀᳳ߱ԭ乱āǃĀᴀ᮹ড়䅵ā㗙 Āᴀ᳜㌃䅵āᄫḋⱘᯊˈᄫԧ买㡆㞾ࡼ䆒㕂៤䝦Ⳃⱘ㑶㡆ˈᑊϨ䆹㸠ϟ䖍Ḛгব៤㑶㡆ˈ㗠 䕧ܹ݊Ҫᄫḋᯊֱ߭ᣕॳᴹⱘ买㡆ˈབ 3-13 ᠔⼎DŽ
3-13 䆒㕂њᴵӊḐᓣҹৢⱘ⦄䞥᮹䆄䋺⦄䞥᮹䆄䋺Ꮉ㸼Ёˈ↣ヨϮࡵথ⫳ৢˈᑨᇚϞⱘԭ乱ࡴϞᴀⱘ׳ᮍ䞥乱ˈޣএ 䌋ᮍ䞥乱ˈᕫࠄᴀⱘԭ乱ˈℸˈĀԭ乱āϔ߫ⱘ᭄䅵ㅫ䞛⫼݀ᓣˈԧℹ偸བϟ˖ ˄1˅䕧ܹᳳ߱ԭ乱ᴀ᳜থ⫳ⱘϔヨ㒣⌢ϮࡵˈऩܗḐ I6 䕧ܹ݀ᓣ I6=I5+G6-H6ˈ ᣝಲ䔺䬂㞾ࡼ䅵ㅫߎԭ乱ˈབ 3-14 ᠔⼎DŽ 3-14 䕧ܹ䅵ㅫԭ乱ⱘ݀ᓣ ˄2˅݊ԭ㒣⌢Ϯࡵⱘԭ乱ˈৃҹ䞛⫼䗝পऩܗḐ I6ˈᢪࡼ฿ܙᶘ ˄ԡѢ䗝ᅮऎඳে ϟ㾦ⱘᇣ咥ᮍഫˈ⫼哴ᷛᣛ฿ܙᶘᯊˈ哴ᷛᣛ䩜বЎ咥कᄫ˅ˈ฿ܙҹϟऩܗḐऎඳ I7:I70DŽ ˄3˅ؐᕫ⊼ᛣⱘᰃˈ↣㸠ⱘԭ乱䛑ᰒ⼎ߎᴹˈϡᰃᕜ㕢㾖ˈ៥Ӏ䳔㽕ⱘᰃ䕧ܹњ䞥乱ⱘ㸠 ᠡᰒ⼎ԭ乱ˈ৺߭ᰒ⼎ぎⱑDŽձ䕧ܹᚙ๗䌘᭭Ё 1 ᳜ 3 ᮹থ⫳ⱘ⦄䞥ϮࡵˈᡞऩܗḐ I6 ⱘ݀ᓣ ᬍ៤=IF(AND(G6="",H6=""),"",I5+G6-H6)ˈݡᡞ݀ᓣ䞡ᮄ฿ܙˈᕫࠄབ 3-15 ᠔⼎ⱘ㒧ᵰDŽ 3-15 ᬍ݀ᓣৢ 2014 ᑈ 1 ᳜ 3 ᮹㧹Ϯ㒜њⱘ⦄䞥᮹䆄䋺 ↣᮹㧹Ϯ㒜њˈ䳔㽕䅵ㅫᔧ᮹ⱘড়䅵᭄ᴀ᳜ⱘ㌃䅵᭄ˈ䆺㒚ℹ偸བϟ˖ ˄1˅ऩܗḐ F14 䕧ܹĀᴀ᮹ড়䅵āˈऩܗḐ G14 䕧ܹ=SUM(G6:G13)ˈᑊᇚ݀ᓣࠊ ࠄऩܗḐ H14ˈᔶ៤׳䌋ᮍᴀ᮹ড়䅵ⱘ㒧ᵰˈབ 3-16 ᠔⼎DŽ 3-16 䅵ㅫ 2014 ᑈ 1 ᳜ 3 ᮹ᴀ᮹ড়䅵
˄2˅ऩܗḐ F15 䕧ܹĀᴀ᳜㌃䅵āˈऩܗḐ G15 䕧ܹ=SUM(G6:G13)ˈᑊᇚ݀ᓣࠊ ࠄऩܗḐ H15ˈᔶ៤׳䌋ᮍᴀ᳜㌃䅵ⱘ㒧ᵰˈЎ 1 ᳜ 3 ᮹Ўᔧ᳜ⱘϔϾᎹ᮹ˈ᠔ҹᴀ᮹ ড়䅵ᴀ᳜㌃䅵ⱘ᭄ؐⳌৠˈབ 3-17 ᠔⼎DŽ 3-17 䅵ㅫ 2014 ᑈ 1 ᳜ 3 ᮹ᴀ᳜㌃䅵 ˄3˅བ 3-16ǃ 3-17 ᠔⼎ˈᴀ᮹ড়䅵ǃᴀ᳜㌃䅵᠔㸠ⱘԭ乱ᰒ✊ᰃ䫭䇃ⱘˈ䫭䇃ॳ ᰃᅗӀⱘ݀ᓣߚ߿ᰃĀ=IF(AND(G14="",H14=""),"",I13+G14-H14)āĀ=IF(AND(G15="", H15=""),"",I14+G15-H15)āˈг䖯㸠њⳌᑨⱘ䅵ㅫˈ㗠ᅲ䰙ϞᅗӀⱘؐᑨ䆹ㄝѢऩܗḐ I13 ⱘ ؐˈℸᇚऩܗḐ I6 ⱘ݀ᓣᬍ៤Ā=IF(AND(G6="",H6=""),"",IF(OR(F6={"ᴀ᮹ড়䅵","ᴀ᳜㌃ 䅵","ᴀᑈ㌃䅵"}),I5,I5+G6-H6))āᑊ฿ܙࠄऩܗḐऎඳ I7:I70 㗠䖒ࠄℷ⹂䅵ㅫԭ乱ⱘⳂⱘˈབ 3-18 ᠔⼎DŽ 3-18 ᬍ݀ᓣৢⱘ⦄䞥᮹䆄䋺 ˄4˅ϟᴹձ䕧ܹᚙ๗䌘᭭Ё 1 ᳜ 4 ᮹থ⫳ⱘ⦄䞥Ϯࡵˈᔶ៤བ 3-19 ᠔⼎ⱘ⦄䞥᮹ 䆄䋺DŽ ˄5˅ऩܗḐ F19 Ё䕧ܹĀᴀ᮹ড়䅵āˈऩܗḐ G19 䕧ܹ=SUM(G16:G18)ˈᑊᇚ݀ᓣ ࠊࠄऩܗḐ H19ˈᔶ៤׳䌋ᮍᴀ᮹ড়䅵ⱘ㒧ᵰ˗ऩܗḐ F20 䕧ܹĀᴀ᳜㌃䅵āˈऩܗ G20 䕧ܹ=G15+G19˄े 3 ᮹ⱘᴀ᳜㌃䅵+4 ᮹ⱘᴀ᮹ড়䅵˅ˈᑊᇚ݀ᓣࠊࠄऩܗḐ H20ˈᔶ៤ᴀ ᳜㌃䅵ⱘ㒧ᵰˈབ 3-20 ᠔⼎DŽ
3-19 㟇 2014 ᑈ 1 ᳜ 4 ᮹ⱘ⦄䞥᮹䆄䋺 3-20 䅵ㅫ 1 ᳜ 4 ᮹ᔧ᮹ড়䅵ᔧ᳜㌃䅵
ᮊᄬ̄ ᠫெઑ᛫ܫေ
䌘䞥᮹㸼ᰃӕϮㅵ⧚䚼䮼Ўњঞᯊᥠᦵњ㾷䌘䞥ⱘ⌕ࡼᚙމ㗠㽕∖ߎ㒇Ҏਬ↣᮹ᦤ կⱘ㸼DŽᴀ乍Ⳃ⦄䞥᮹䆄䋺ⱘ⸔Ϟ㓪ࠊ䌘䞥᮹㸼ˈϡҙЎӕϮ⦄䞥ⱘㅵ⧚ᦤկњᮍ֓ˈ 㗠ϨЎㅵ⧚㗙ঞᯊњ㾷ᥠᦵᴀӕϮⱘ䌘䞥⢊މড়⧚䖤⫼䌘䞥ᦤկњখ㗗᭄DŽϟ䴶ҟ㒡䌘 䞥᮹㸼ⱘ㓪ࠊᮍ⊩DŽ ͊Ҭ 1 ᠫெઑ᛫ፇᄊᝠ ᠧᓔഫᎹ㈓ĀExcel ߎ㒇ቫⱘᑨ⫼āˈᮄᓎĀ䌘䞥᮹㸼āᎹ㸼ˈ Excel Ϟ䆒䅵 ⱘ䌘䞥᮹㸼ˈḐᓣབ 3-21 ᠔⼎DŽ 3-21 䌘䞥᮹㸼Ḑᓣ ᇍѢ䌘䞥᮹㸼Ḑᓣ㗠㿔ˈ᳝ҹϟݙᆍ䳔㽕⊼ᛣ˖ ˄1˅䗝ᢽऩܗḐ B4:F4ˈǏᓔྟǐ䗝乍वˈ䗝ᢽǏᇍ唤ᮍᓣǐᎹ㒘ЁǏড়ᑊৢሙЁǐ ੑҸˈড়ᑊऩܗḐˈড়ᑊৢⱘऩܗḐ B4 Ё䕧ܹĀ2014-1-3āˈᑊǏᓔྟǐ䗝乍वˈ䗝ᢽǏऩ ܗḐǐᎹ㒘ЁǏḐᓣǐੑҸˈᠧᓔǏ䆒㕂ऩܗḐḐᓣǐᇍ䆱Ḛˈᇚ㸼༈ऩܗḐ B4 ᭄ᄫߚ㉏ 䆒㕂ЎĀ㞾ᅮНāЁĀ"᮹""ᳳ"!:yyyy"ᑈ"m"᳜"d"᮹"āˈ བ 3-22 ᠔⼎DŽ 3-22 䆒㕂ऩܗḐḐᓣ ˄2˅䌘䞥᮹㸼Ё᭄ᴹ⑤Ѣ⦄䞥᮹䆄䋺ˈ䆄ᔩ↣䌘䞥⌕ⱘᚙމˈℸˈ㸼ऎඳ᭄ ḐᓣЎӮ䅵ϧ⫼ˈֱ⬭ϸԡᇣ᭄DŽ䗝ᢽऎඳ D7:G20ˈǏᓔྟǐ䗝乍वˈ䗝ᢽǏऩܗḐǐ Ꮉ㒘ЁǏḐᓣǐੑҸˈᠧᓔǏ䆒㕂ऩܗḐḐᓣǐᇍ䆱ḚˈĀ᭄ᄫā䗝乍ⱘĀߚ㉏ā䗝ḚЁ 䗝ᢽĀӮ䅵ϧ⫼āˈབ 3-24 ᠔⼎DŽ
3-23 䆒㕂ऩܗḐḐᓣ ˄3˅݊ԭ㸼Ḑ᭛ᄫǃ䖍Ḛǃ㒓ᴵ买㡆ǃϾ߿ऩܗḐ฿ܙᑩ㒍ˈഛখ✻ 3-21ˈᅠ៤䌘䞥 ᮹㸼ⱘḐᓣ䆒䅵DŽ ͊Ҭ 2 ᠫெઑ᛫ᄊᒭүᝠካ ៥Ӏৃҹ߽⫼ Excel ݀ᓣߑ᭄ⱘ᪡ˈᇚ⦄䞥᮹䆄䋺ⱘ᭄ᓩ⫼䖛ᴹˈᅠ៤䌘䞥᮹㸼 ᭄ⱘ㞾ࡼ⫳៤ˈԧ᪡ℹ偸བϟ˖ ˄1˅䗝ᢽऩܗḐ D7ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((⦄䞥᮹䆄䋺!$B$6:$B$70=MONTH(䌘 䞥 ᮹ 㸼 !$B$4))*( ⦄ 䞥 ᮹ 䆄 䋺 !$C$6:$C$70=DAY( 䌘 䞥 ᮹ 㸼 !$B$4))*( ⦄ 䞥 ᮹ 䆄 䋺!$E$6:$E$70=䌘䞥᮹㸼!C7)*⦄䞥᮹䆄䋺!$G$6:$G$70)āDŽ ݀ᓣⱘНЎ˖ᔧ⦄䞥᮹䆄䋺ऩܗḐऎඳ B6:B70 ⱘؐЎ䌘䞥᮹㸼ऩܗḐ B4 ⱘ᳜ӑؐˈ ᔧ⦄䞥᮹䆄䋺ऩܗḐऎඳ C6:C70 ⱘؐЎ䌘䞥᮹㸼ऩܗḐ B4 ⱘ᮹ᳳؐˈᑊᔧ⦄䞥᮹䆄䋺 ऩܗḐऎඳ E6:E70 ⱘؐЎ䌘䞥᮹㸼ऩܗḐ C7 䌘䞥乍Ⳃⱘؐᯊˈᴀ᮹䌘䞥ᬊܹ乍Ⳃᇍᑨⱘ 䞥乱ህㄝѢ⦄䞥᮹䆄䋺Ё׳ᮍऩܗḐ G6:G70 ⱘ∛ᘏ᭄DŽᑨ⡍߿⊼ᛣ݀ᓣЁⱘ㒱ᇍᓩ⫼Ⳍᇍ ᓩ⫼DŽ ˄2˅䗝ᢽऩܗḐ D7ˈ฿ܙ݀ᓣࠄऩܗḐऎඳ D8:D11ˈབ 3-24 ᠔⼎DŽ ˄3˅䗝ᢽऩܗḐ D12ˈ䕧ܹ݀ᓣĀ=SUM(D7:D11)āˈ฿ܙ݀ᓣࠄऩܗḐऎඳ E12:F12DŽ ˄4˅䗝ᢽऩܗḐ D13ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((⦄䞥᮹䆄䋺!$B$6:$B$70=MONTH(䌘 䞥 ᮹ 㸼 !$B$4))*( ⦄ 䞥 ᮹ 䆄 䋺 !$C$6:$C$70=DAY( 䌘 䞥 ᮹ 㸼 !$B$4))*( ⦄ 䞥 ᮹ 䆄 䋺!$E$6:$E$70=䌘䞥᮹㸼!C13)*⦄䞥᮹䆄䋺!$H$6:$H$70)āDŽ ˄5˅䗝ᢽऩܗḐ D13ˈ฿ܙ݀ᓣࠄऩܗḐऎඳ D14:D17DŽ ˄6˅䗝ᢽऩܗḐ D18ˈ䕧ܹ݀ᓣĀ=SUM(D13:D17)āˈ฿ܙ݀ᓣࠄऩܗḐऎඳ E18:F18DŽ བ 3-25 ᠔⼎DŽ
3-24 2014 ᑈ 1 ᳜ 3 ᮹Ā㧹Ϯℒāᴀ᮹ᬊܹ䞥乱 3-25 2014 ᑈ 1 ᳜ 3 ᮹Ā䌍⫼䫔āᴀ᮹ᬃߎ䞥乱 ˄7˅ᴀ᳜㌃䅵䞥乱া㽕ᡞᴀ᮹݀ᓣЁᇍ᮹ᳳⱘĀ=āᴵӊᬍ៤Ā<=ā˗ᴀᑈ㌃䅵䞥乱া㽕 ᡞᴀ᮹݀ᓣЁᇍ᳜ӑⱘĀ=āᴵӊᬍ៤Ā<āˈᑊࡴϞᴀ᳜㌃䅵ˈेৃ∖ᕫDŽԧ݀ᓣᑨ⫼Ў˖ 䗝ᢽऩܗḐ E7ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((⦄䞥᮹䆄䋺!$B$6:$B$70=MONTH(䌘䞥᮹ 㸼!$B$4))*(⦄䞥᮹䆄䋺!$C$6:$C$70<=DAY(䌘䞥᮹㸼!$B$4))*(⦄䞥᮹䆄䋺!$E$6:$E$70=䌘 䞥᮹㸼!C7)*⦄䞥᮹䆄䋺!$G$6:$G$70)ā˗䗝ᢽऩܗḐ F7ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((⦄ 䞥 ᮹ 䆄 䋺 !$B$6:$B$70<MONTH( 䌘 䞥 ᮹ 㸼 !$B$4))*(⦄ 䞥᮹ 䆄 䋺 !$E$6:$E$70= 䌘䞥᮹ 㸼!C7)*⦄䞥᮹䆄䋺!$G$6:$G$70)+E7āDŽ ˄8˅䗝ᢽऩܗḐ D20ˈ䕧ܹ݀ᓣĀ=⦄䞥᮹䆄䋺!I5+䌘䞥᮹㸼!F12-䌘䞥᮹㸼!F18āDŽ
˄9˅䗝ᢽऩܗḐ D19ˈ䕧ܹ݀ᓣĀ=D20-D12+D18āDŽ ˄10˅䌘䞥᮹㸼ⱘ᭄䗮䖛 Excel ݀ᓣߑ᭄ⱘՓ⫼ˈ㞾ࡼ⫳៤ˈᔶ៤ 2014 ᑈ 1 ᳜ 3 ᮹ⱘ㸼ˈབ 3-26 ᠔⼎DŽ 3-26 2014 ᑈ 1 ᳜ 3 ᮹ⱘ䌘䞥᮹㸼 ˄11˅䗝ᢽऩܗḐ B4ˈ䕧ܹᮄⱘ᮹ᳳĀ2014-1-4āˈ㞾ࡼ⫳៤ 1 ᳜ 4 ᮹ⱘ䌘䞥᮹㸼ˈབ 3-27 ᠔⼎DŽ 3-27 2014 ᑈ 1 ᳜ 4 ᮹ⱘ䌘䞥᮹㸼
ᮊᄬʼ ᩐᛡߛ൜ெᝮ᠍ኮေ
䫊㸠ᄬℒ᮹䆄䋺ᰃ⫼ᴹḌㅫⲥⴷ䫊㸠ᄬℒ↣᮹ⱘᬊܹǃᬃߎ㒧ԭᚙމⱘ䋺㈓DŽ䫊 㸠ᄬℒ᮹䆄䋺ᑨᣝӕϮ䫊㸠ᓔゟⱘ䋺᠋Ꮥ⾡ߚ߿䆒㕂ˈ↣Ͼ䫊㸠䋺᠋䆒㕂ϔᴀ᮹䆄䋺DŽ ⬅ߎ㒇ҎਬḍϢ䫊㸠ᄬℒᬊҬϮࡵ᳝݇ⱘ䆄䋺߁䆕ˈᣝᯊ䯈ܜৢ乎ᑣ䗤᮹䗤ヨ䖯㸠ⱏ䆄DŽ ḍ䫊㸠ᄬℒᬊℒ߁䆕᳝݇ⱘ⦄䞥Ҭℒ߁䆕˄ᑧᄬ⦄䞥ᄬܹ䫊㸠ⱘϮࡵ˅ⱏ䆄䫊㸠ᄬℒ ᬊܹᷣˈḍ䫊㸠ᄬℒҬℒ߁䆕ⱏ䆄݊ᬃߎᷣˈ↣᮹㒧ߎᄬℒԭ乱ˈ᳔㒜ᔶ៤䫊㸠ᄬℒ᮹ 䆄䋺㈓DŽ ͊Ҭ 1 ᩐᛡߛ൜ெᝮ᠍ፇᄊᝠ 䫊㸠ᄬℒ᮹䆄䋺䞛⫼䅶ᴀᓣˈ䋺义Ḑᓣгϔ㠀䞛⫼ϝᷣᓣˈ䆒׳ᮍǃ䌋ᮍԭ乱ϝϾ ᴀ䞥乱ᷣⳂˈᇚ㒣⌢ϮࡵЁϢ䫊㸠ᄬℒ᳝݇ⱘᬊܹ䞥乱ݭ׳ᮍˈᇚ䫊㸠ᄬℒᬃߎⱘ䞥乱ݭ 䌋ᮍˈḐᓣϢ⦄䞥᮹䆄䋺ᴀⳌৠˈᴀ乍Ⳃ䫊㸠ᄬℒ᮹䆄䋺ⱘ㸼༈Ḑᓣབ 3-28 ᠔⼎DŽ 3-28 䫊㸠ᄬℒ᮹䆄䋺㸼༈Ḑᓣ 䆹䫊㸠ᄬℒ᮹䆄䋺ԧⱏ䆄ᮍ⊩བϟ˖ ˄1˅᮹ᳳᷣ˖㋏ᣛ䆄䋺߁䆕ⱘ᮹ᳳˈᑨϢ䫊㸠ᄬℒᅲ䰙ᬊҬ᮹ᳳϔ㟈DŽ ˄2˅߁䆕ᷣ˖㋏ᣛⱏ䆄ܹ䋺ⱘᬊҬℒ߁䆕ⱘ㓪োˈҹ֓Ѣᶹ䋺ḌᇍDŽ ˄3˅㉏߿ᷣ˖⫼Ѣњ㾷㒣⌢Ϯࡵ⍝ঞ䫊㸠ᄬℒ᠔ሲⱘ⾡㉏DŽ ˄4˅ᨬ㽕ᷣ˖ᨬ㽕䇈ᯢⱏ䆄ܹ䋺ⱘ㒣⌢Ϯࡵⱘݙᆍˈ᭛ᄫ㽕ㅔ㒗ˈԚ㽕㛑䇈ᯢ䯂乬DŽ ˄5˅׳䌋ԭ乱ᷣ˖㋏ᣛ↣ヨϮࡵথ⫳ᯊ䫊㸠ᄬℒᅲ䰙ᬊҬⱘ䞥乱ˈ↣ⱘ㒧ԭᚙމDŽᘏ Пˈϔᴵ䆄ᔩডϔヨ㒣⌢Ϯࡵⱘথ⫳DŽ ᅠ៤䫊㸠ᄬℒ᮹䆄䋺ⱘ㒧ᵘ䆒䅵DŽ ͊Ҭ 2 ᩐᛡߛ൜ெᝮ᠍ܫေ ḍᚙ๗ᦣ䗄 2014 ᑈ 1 ᳜থ⫳Ϣ䫊㸠ᄬℒ᳝݇ⱘϮࡵᚙމˈᇍ䫊㸠ᄬℒ᮹䆄䋺ⱘ᭄䖯 㸠ᔩܹˈབ 3-29 ᠔⼎DŽ 3-29 䫊㸠ᄬℒ᮹䆄䋺Ꮉ㸼 Ўњㅔ᭄࣪໘⧚ˈ䆹Ꮉ㸼ЁĀ㉏߿āǃĀ㒧ㅫᮍᓣāϸ߫ˈे E ߫ǃF ߫ˈৃ䖯㸠᭄ ᳝ᬜᗻⱘ䆒㕂ˈ䙓ܡ䞡ᔩܹˈᦤ催䕧ܹⱘޚ⹂ᗻDŽ 䫊㸠ᄬℒ㉏߿߫㸼㾕 3-7 ᠔⼎ˈ㒧ㅫᮍᓣ߫㸼㾕 3-31 ᠔⼎DŽ 䆹Ꮉ㸼ЁĀԭ乱ā߫ˈे K ߫ˈখ✻乍ⳂϔЁӏࡵ 2 䅵ㅫ⦄䞥 ᮹䆄䋺ⱘԭ乱݀ᓣᴹ䆒䅵DŽ 䆹Ꮉ㸼Ё⫼݀ᓣ䅵ㅫ䫊㸠ᄬℒᴀ᮹ড়䅵ᴀ᳜㌃䅵ˈᑊ䆒㕂 ⳌᑨⱘᴵӊḐᓣˈԧᮍ⊩ℹ偸乍Ⳃϔӏࡵ 2 Ё᳝㉏Ԑⱘ䆺㒚 ҟ㒡ˈৃখ✻䆒䅵DŽ ᳔ৢᇍѢ 2014 ᑈ 1 ᳜থ⫳ⱘϢ䫊㸠ᄬℒ᳝݇ⱘ㒣⌢Ϯࡵⱏ䆄᮹ 䆄䋺ˈᑊخࠄ᮹⏙᳜㒧ˈ㒧ᵰབ 3-31 ᠔⼎DŽ 3-31 2014 ᑈ 1 ᳜䫊㸠ᄬℒ᮹䆄䋺 3-30 㒧ㅫᮍᓣ߫㸼
ᮊᄬپ ᎄ҄ᮩូᓬ᛫
ᅲ䰙ᎹЁˈ฿ࠊ߁䆕ǃ䆄䋺ǃ䖛䋺ǃㅫ䋺ǃ㒧䋺䅵ㅫǃ䋺㈓䆄ᔩᯊ䲒ܡӮߎ⦄䫭䆄ǃ ⓣ䆄ⱘᚙމˈЎњֱ䆕䋺㈓᠔ᦤկⱘӮ䅵䌘᭭ℷ⹂ǃⳳᅲǃৃ䴴ˈӮ䅵Ҏਬⱏ䆄䋺㈓ᯊˈϔ ᅮ㽕᳝催ᑺⱘ䋷ӏᖗˈߛϡৃ偀㰢ˈ㒧䋺ࠡৢˈ䖬ᑨᅮᳳخདᇍ䋺Ꮉˈخࠄ䋺䆕Ⳍヺǃ䋺 䋺Ⳍヺˈ䋺ᅲⳌヺˈЎ㓪ࠊӮ䅵㸼ᦤկⳳᅲৃ䴴ⱘ᭄䌘᭭DŽ ᴀ乍Ⳃҹ㓪ࠊ䫊㸠ᄬℒԭ乱䇗㡖㸼Ў՟ˈᇚ乍ⳂϝЁᦤկⱘ䫊㸠ᄬℒ᮹䆄䋺ⱘ䋺䴶ԭ乱 Ϣ䫊㸠䗕ᴹⱘᇍ䋺ऩᅮᳳḌᇍˈ䖯㸠䋶ѻ⏙ᶹˈথ⦄ᴀӕϮ䫊㸠ᄬℒ᮹䆄䋺Ϣ䫊㸠ᇍ䋺ऩ䋺Ⳃ ᰃ৺ϔ㟈ˈ֓Ѣঞᯊᶹᯢℷˈᑊ⹂ᅮӕϮ䫊㸠ᄬℒᅲ᭄᳝DŽ ϟ䴶ҟ㒡䫊㸠ᄬℒԭ乱䇗㡖㸼ⱘ㓪ࠊᮍ⊩DŽ ͊Ҭ 1 ᩐᛡࠫ᠍ 䫊㸠䗕ᴹⱘ 2014 ᑈ 1 ᳜ᇍ䋺ऩབ 3-32 ᠔⼎DŽ 3-32 䫊㸠ᇍ䋺ऩ ᣝ✻ 3-32 ᠔⼎Ḑᓣˈձᔩܹ䫊㸠ᇍ䋺ऩˈBǃCǃDǃEǃFǃG ݁߫ߚ߿ᇍᑨĀ᳜āǃ Ā᮹āǃĀᨬ㽕āǃĀ׳ᮍāǃĀ䌋ᮍāǃĀԭ乱āˈ 5 㸠ЎϞ᳜㒧ԭˈ 6 㸠ᓔྟЎϮࡵথ⫳ⱘ ݙᆍDŽ 䫊㸠ᇍ䋺Ꮉᗱ䏃Ў˖ձҢ䫊㸠ᄬℒ᮹䆄䋺䇏প׳ᮍ㗙䌋ᮍⱘ䞥乱ˈݡࠄ䫊㸠ᇍ䋺 ऩᶹᡒ䌋ᮍ㗙׳ᮍ䞥乱ⳌㄝⱘϮࡵDŽབᵰᡒࠄˈ߭ߚ߿䫊㸠ᄬℒ᮹䆄䋺ⱘ L ߫䫊㸠ᇍ 䋺ऩⱘ H ߫ᠧĀĜāˈ䆺㒚ℹ偸བϟ˖ ˄1˅ഫᎹ㈓ĀExcel ߎ㒇ቫⱘᑨ⫼āЁᠧᓔĀ䫊㸠ᄬℒ᮹䆄䋺āᎹ㸼DŽ ˄2˅ᇚПࠡ᮹⏙᳜㒧䆄ᔩˈेᴀ᮹ড়䅵ǃᴀ᳜㌃䅵᠔㸠ߴ䰸ˈ⊼ᛣֱᣕ᭄ⱘᅠᭈᗻˈ 䫊㸠ᄬℒ᮹䆄䋺བ 3-33 ᠔⼎DŽ 3-33 প⍜᮹⏙᳜㒧ৢⱘ䫊㸠ᄬℒ᮹䆄䋺
˄3˅䆹Ꮉ㸼Ёˈᮄᓎᔶᣝ䪂 ˈ䗝ᢽǏ㾚ǐ䗝乍वᎹ㒘ЁǏᅣǐˈᠻ㸠Ǐᶹ
ⳟᅣǐੑҸˈᠧᓔǏᅣǐᇍ䆱Ḛˈ߯ᓎĀᇍ䋺āᅣˈབ 3-34 ᠔⼎DŽ
3-34 ߯ᓎᅣ
˄4˅ऩߏĀ߯ᓎāᣝ䪂ৢˈᔍߎĀMicrosoft Visual Basic for Applicationsāにষˈᑊᇚᇍ 䋺ⱘᅣҷⷕ䕧ܹࠄഫ 1 Ёˈབ 3-35 ᠔⼎DŽ
ᇍ䋺ᅣҷⷕབϟ˖
Sub ᇍ䋺()
Dim LineNo1 As Integer '䫊㸠ᄬℒ᮹䆄䋺߱ྟ㸠ো LineNo1 = 5
Dim sheet1 As Worksheet
Set sheet1 = Worksheets("䫊㸠ᄬℒ᮹䆄䋺") Dim sheet2 As Worksheet
Set sheet2 = Worksheets("䫊㸠ᇍ䋺ऩ") sheet1.Columns("l:l").ClearContents sheet2.Columns("h:h").ClearContents
Do While sheet1.Cells(LineNo1, 11).Value <> "" 'ԭ乱᭄ϡЎぎ jf = sheet1.Cells(LineNo1, 9).Value '׳ᮍ䞥乱
df = sheet1.Cells(LineNo1, 10).Value '䌋ᮍ䞥乱
lineno2 = 6 '䫊㸠ᇍ䋺ऩ߱ྟ㸠ো If jf <> "" Then
Do While sheet2.Cells(lineno2, 6).Value <> "" Or sheet2.Cells(lineno2, 5).Value <> "" '׳ᮍ䌋ᮍ䞥乱ϡЎぎ
If jf * 1 = sheet2.Cells(lineno2, 6).Value * 1 And sheet2.Cells(lineno2, 8).Value <> "Ĝ" Then 'བᵰ䞥乱ⳌㄝˈᑊϨ䖬≵᳝ᇍ䖛䋺 sheet1.Cells(LineNo1, 12).Value = "Ĝ" sheet2.Cells(lineno2, 8).Value = "Ĝ" Exit Do End If lineno2 = lineno2 + 1 Loop Else
Do While sheet2.Cells(lineno2, 5).Value <> "" Or sheet2.Cells(lineno2, 6).Value <> "" '׳ᮍ㗙䌋ᮍ䞥乱ϡЎぎ
If df * 1 = sheet2.Cells(lineno2, 5).Value * 1 And sheet2.Cells(lineno2, 8).Value <> "Ĝ" Then 'བᵰ䞥乱ⳌㄝᑊϨ䖬≵᳝ᇍ䖛䋺 sheet1.Cells(LineNo1, 12).Value = "Ĝ" sheet2.Cells(lineno2, 8).Value = "Ĝ" Exit Do End If lineno2 = lineno2 + 1 Loop End If LineNo1 = LineNo1 + 1 Loop End Sub
˄5˅䗝ᢽᔶᣝ䪂 ˈǏ㾚ǐ䗝乍वᎹ㒘Ǐᅣǐˈᠻ㸠ǏᶹⳟᅣǐੑҸˈᠧᓔ Ǐᅣǐᇍ䆱ḚˈᑊऩߏĀᠻ㸠āᣝ䪂ˈབ 3-36 ᠔⼎DŽ 3-36 ᠻ㸠ᅣ ˄6˅ᠻ㸠ᅣҹৢˈᎹ㸼Ā䫊㸠ᄬℒ᮹䆄䋺āǃĀ䫊㸠ᇍ䋺ऩāབ 3-37ǃ 3-38 ᠔⼎DŽ 3-37 ᇍ䋺ৢⱘ䫊㸠ᄬℒ᮹䆄䋺 3-38 ᇍ䋺ৢⱘ䫊㸠ᇍ䋺ऩ
͊Ҭ 2 ၷੇᩐᛡߛ൜ᮩូᓬ᛫ Ўњথ⦄ᴀӕϮ䫊㸠ᄬℒ᮹䆄䋺Ϣ䫊㸠ᇍ䋺ऩ䋺Ⳃᰃ৺ϔ㟈ˈᑊ⹂ᅮӕϮ䫊㸠ᄬℒᅲ᳝ ᭄ˈϟ䴶⫳៤䫊㸠ᄬℒԭ乱䇗㡖㸼ˈ䆺㒚ℹ偸བϟ˖ ˄1˅ᣝ 3-39 ᠔⼎Ḑᓣ䆒䅵䫊㸠ᄬℒԭ乱䇗㡖㸼DŽ 3-39 䫊㸠ᄬℒԭ乱䇗㡖㸼Ḑᓣ ˄2˅䗝ᢽऩܗḐ C3ˈ䕧ܹ݀ᓣĀ=䫊㸠ᄬℒ᮹䆄䋺!K4+SUM(䫊㸠ᄬℒ᮹䆄䋺!I:I)-SUM(䫊 㸠ᄬℒ᮹䆄䋺!J:J)āDŽ ˄3˅䗝ᢽऩܗḐ E3ˈ䕧ܹ݀ᓣĀ=䫊㸠ᇍ䋺ऩ!G5-SUM(䫊㸠ᇍ䋺ऩ!E:E)+SUM(䫊㸠ᇍ 䋺ऩ!F:F)āDŽ ˄4˅䗝ᢽऩܗḐ C4ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((䫊㸠ᇍ䋺ऩ!H6:H18<>"Ĝ")*䫊㸠ᇍ 䋺ऩ!F6:F18)ā. ˄5˅䗝ᢽऩܗḐ E4ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((䫊㸠ᄬℒ᮹䆄䋺!L5:L16<>"Ĝ")*䫊 㸠ᄬℒ᮹䆄䋺!I5:I16)āDŽ ˄6˅䗝ᢽऩܗḐ C7ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((䫊㸠ᇍ䋺ऩ!H6:H18<>"Ĝ")*䫊㸠ᇍ 䋺ऩ!E6:E18)āDŽ ˄7˅䗝ᢽऩܗḐ E7ˈ䕧ܹ݀ᓣĀ=SUMPRODUCT((䫊㸠ᄬℒ᮹䆄䋺!L5:L16<>"Ĝ")*䫊 㸠ᄬℒ᮹䆄䋺!J5:J16)āDŽ ˄8˅䗝ᢽऩܗḐ C10ˈ䕧ܹ݀ᓣĀ=C3+C4+C5+C6-C7-C8-C9āDŽ ˄9˅䗝ᢽऩܗḐ E10ˈ䕧ܹ݀ᓣĀ=E3+E4+E5+E6-E7-E8-E9āDŽ ᳔ৢᅠ៤䫊㸠ᄬℒԭ乱䇗㡖㸼བ 3-40 ᠔⼎ˈ䇗㡖ৢⱘԭ乱Ⳍㄝˈ㢹ϡⳌㄝ䳔خ䖯ϔℹ ໘⧚DŽ 3-40 ⫳៤ⱘ䫊㸠ᄬℒԭ乱䇗㡖㸼
ᢧሩⶹ䆚 1ĕۆ OR() ď1Đഊੜd ၽୣϵᆦᄯēఉۥྡྷّϵ০ހᄔน TRUEēއֲݍ TRUEĢఉۥྡྷّϵԅ০ހᄔ น FALSEēއֲݍ FALSEd ď2Đဴ֥d OR(logical1, [logical2], ...) OR ۆဴ֥ပຏॹϵďϵġนЀᆴcಹߑcֺ֥c೫cۆݧڶёඔ٢ ԅᄔĐġ
logical1, logical2, ... logical1 ಾΡ༓ԅē܊ޟԅ০ހᄔಾࢶ༪ԅdუ໔ಾ 1 Ӿ 255 ّ༓ྑ ࠩЉೋԅඨߑēЉೋࠒڴࢶྻน TRUE ݧ FALSEd ď3Đᅟ࿉ಹົd ϵΡ༖ટޙസน০ހᄔďఢ TRUE ݧ FALSEĐēݧრนͧۃ০ހᄔԅᆦďᆦġဈဟ ߙोࢶಓюտّࠒڴݧࢶճၽۤॹᄯ૦ॹԅྡྷᆦϵࠩၮസԅӦّ٤dᆦ့٫ဈྡྷ ّ٤ĢᆦШ२ಾဈᆴϵԅྡྷᆦШ२Đݧဈd ఢڴᆦݧဈϵᄯͧۃำ·ݧࣂ͂Ӧ၍ٌē႕უ໔ᄔߜ΄܍d ఢڴᄗՇԅ့ᄯϢͧۃ০ހᄔēۆ OR ֲݍӐᄔ #VALUE!d ࢶྻರဈ OR ᆦ٤ིࣿᆦᄯಾͧۃඋՇԅᄔdྑదᆦ٤ēை̟ Ctrl+Shift+Enterᆦۦߏd 2ĕۆ AND() ď1Đഊੜd
ൎပϵԅޙസࠒڴน TRUE ನēֲݍ TRUEĢᄚྑပྡྷّϵԅޙസࠒڴน FALSEē އֲݍ FALSEd
ANDۆԅྡྷᄵШߎဈාಾࣴӖဈဟᄓ০ހིԅୣۆԅ໒ဈdैఢēIF ۆ ဈဟᄓ০ހིēၽིԅޙസࠒڴน TRUE ನֲݍྡྷّᄔēၽིԅޙസࠒڴน FALSE ನֲݍখྡྷّᄔdඹڶߜ AND ۆဈᆴ IF ۆԅ logical_test ϵēࢶྻིտ ّϢලԅඨߑē֗Ϣࠧࠧಾྡྷّඨߑd
ď2Đဴ֥d
AND(logical1,[logical2],…) AND ۆဴ֥ပຏॹϵġ
logical1 Ρ༓dྑིԅԛྡྷّඨߑēୣޙസࠒڴࢶྻน TRUE ݧ FALSEd
logical2, ... ࢶ༪dྑིԅୣඨߑēୣޙസࠒڴࢶྻน TRUE ݧ FALSEēᆫտࢶͧ ۃ 255 ّඨߑd
ď3Đᅟ࿉ಹົd
ϵԅޙസࠒڴΡ༖ಾ০ހᄔďఢ TRUE ݧ FALSEĐēݧრϵΡ༖ಾͧۃ০ހᄔԅᆦd ఢڴᆦݧဈϵᄯͧۃำ·ݧࣂ͂Ӧ၍ٌē႕უ໔ᄔߜ΄܍d
3ĕۆ IF() ď1Đഊੜd ఢڴᄗՇඨߑԅޙസࠒڴน TRUEēIF ۆߜֲݍ੶ّᄔĢఢڴ؞ඨߑԅޙസࠒڴน FALSEē႕ֲݍখྡྷّᄔdैఢēఢڴ A1 Ӗဟ 10ē٤=IF(A1>10,"Ӗဟ 10","ϢӖဟ 10") ߜ ֲݍqӖဟ 10rēఢڴ A1 ໌ဟԉဟ 10ē႕ֲݍqϢӖဟ 10rd ď2Đဴ֥d
IF(logical_test, [value_if_true], [value_if_false]) IF ۆဴ֥ပຏॹϵġ
logical_test Ρ༓dޙസࠒڴࢶટน TRUE ݧ FALSE ԅఉ࿉ᄔݧζӒdैఢēA10=100 ಾྡྷّ০ހζӒĢఢڴӦ၍ٌ A10 ᄯԅᄔԉဟ 100ēζӒԅޙസࠒڴน TRUEĢ႕ น FALSEdҮϵࢶರဈఉۥΑࠀၮസd
value_if_true ࢶ༪dlogical_test ϵԅޙസࠒڴน TRUE ನൎྑֲݍԅᄔdैఢēఢڴ Үϵԅᄔนำ·ᆓґ“၇സઝ”ēωய logical_test ϵԅޙസࠒڴน TRUEē႕ IF ۆ ֲݍำ·q၇സઝrdఢڴ logical_test ԅޙസࠒڴน TRUEēωயಘ value_if_true ϵďއ logical_test ϵ܊ٕࠧྡྷّՙۜĐēIF ۆߜֲݍ 0ďঌĐdయྑມವӦҭ TRUEēைճ value_if_trueϵರဈ০ހᄔ TRUEd
value_if_false ࢶ༪dlogical_test ϵԅޙസࠒڴน FALSE ನൎྑֲݍԅᄔdैఢēఢڴ Үϵԅᄔนำ·ᆓґqбѻ၇സrēωய logical_test ϵԅޙസࠒڴน FALSEē႕ IF ۆ ֲݍำ·qбѻ၇സrdఢڴ logical_test ԅޙസࠒڴน FALSEēωயಘ value_if_false ϵ ďއ value_if_true ϵ܊ਠပՙۜĐē႕ IF ۆֲݍ০ހᄔ FALSEdఢڴ logical_test ԅޙ സࠒڴน FALSEēωயಘ value_if_false ϵԅᄔďއēၽ IF ۆᄯēvalue_if_true ϵ܊ ਠပՙۜĐē႕ IF ۆֲݍᄔ 0ďঌĐd ď3Đᅟ࿉ಹົd ᆫտࢶྻರဈ 64 ّ IF ۆᆴน value_if_true ۤ value_if_false ϵࠩஓඊēྻٲႏٗ ື࠰ԅЉೋďைϵၧವै 3ēუಾஓඊ IF ۆԅྡྷّವैdĐݧრēయྑЉೋտّඨߑēைࢩ ৎರဈLOOKUPcVLOOKUPcHLOOKUPݧCHOOSEۆďைϵၧವै 4ēუಾ LOOKUP ۆԅྡྷّವैĐd ఢڴ IF ԅఉ࿉ϵนᆦē႕ၽᄓ IF ဴࡳನēߜޙസᆦԅਤྡྷّ၍ഭd Excelܮඔ٢ॴୣྡྷ໔ۆēࢶರဈუ໔ۆٔඨߑࣿדdैఢēయྑޙസ੶ Ӧ၍့ٌઝ੶ّำ·ᆓґݧᆓѻຣԅұēࢶರဈ COUNTIFݧCOUNTIFSٝᆴζۆ dయྑޙസݮဟ੶့ઝྡྷّำ·ᆓґݧྡྷّᄔԅᆙۤēࢶರဈSUMIFݧSUMIFSٝᆴ ζۆd 4ĕۆ MONTH() ď1Đഊੜd ֲݍྻ༝ॹۜζವԅఐᄯԅၥךdၥךಾࠚဟ 1ďྡྷၥĐӾ 12ďಥ֝ၥĐᄍԅჼd ď2Đဴ֥d MONTH(serial_number) MONTH ۆဴ֥ပຏॹϵġ serial_number Ρ༓dྑАდԅઊྡྷၥԅఐdರဈ DATE ۆదఐēݧრߜఐ
ᆴนୣ٤ݧۆԅࠒڴదdैఢēರဈۆ DATE(2008,5,23) ద 2008 ભ 5 ၥ 23 ఐdఢڴఐྻำ·దē႕ݖѻຣูඕd
ď3Đᅟ࿉ಹົd
Microsoft ExcelࢶߜఐӉ҅นࢶဈဟޙസԅ༝ॹd੯ఊெࣣຏē1900 ભ 1 ၥ 1 ఐԅ༝ ॹۜಾ 1ē֗ 2008 ભ 1 ၥ 1 ఐԅ༝ॹۜಾ 39448ēუಾ࿙น 1900 ભ 1 ၥ 1 ఐပ 39448 ඟd Microsoft Excel for the Macintosh ರဈখෳྡྷّ੯ఊఐຂහd
Ϣৢඔ٢ԅఐᄔྻۥᄵٌມವēYEARcMONTH ۤ DAY ۆֲݍԅᄔ՛ಾ Gregorian ᄔdैఢēఢڴඔ٢ఐԅມವٌಾݍॅďݍॅġྨഎइ߽ڳޥ/ԙರဈԅॅdĐē႕ YEARc MONTH ۤ DAY ۆֲݍԅᄔߜಾူԉޮԅ Gregorian ఐອڑ॓ԅᄔd
5ĕۆ DAY() ď1Đഊੜd
ֲݍྻ༝ॹۜζವԅ੶ఐԅඟēဈჼ 1 Ӿ 31 ζವd ď2Đဴ֥d DAY(serial_number) DAYۆဴ֥ပຏॹϵġ serial_number Ρ༓dྑАდԅઊྡྷඟԅఐdರဈ DATE ۆదఐēݧრߜఐ ᆴนୣ٤ݧۆԅࠒڴదdैఢēರဈۆ DATE(2008,5,23) ద 2008 ભ 5 ၥ 23 ఐd ఢڴఐྻำ·దē႕ݖѻຣูඕd ď3Đᅟ࿉ಹົd Microsoft ExcelࢶߜఐӉ҅นࢶဈဟޙസԅ༝ॹd੯ఊெࣣຏē1900 ભ 1 ၥ 1 ఐԅ༝ ॹۜಾ 1ē֗ 2008 ભ 1 ၥ 1 ఐԅ༝ॹۜಾ 39448ēუಾ࿙น 1900 ભ 1 ၥ 1 ఐပ 39448 ඟd Microsoft Excel for the Macintosh ರဈখෳྡྷّ੯ఊఐຂහdϢৢඔ٢ԅఐᄔྻۥᄵٌມವēYEARcMONTH ۤ DAY ۆֲݍԅᄔ՛ಾ Gregorian ᄔdैఢēఢڴඔ٢ఐԅມವٌಾݍॅē႕ YEARcMONTH ۤ DAY ۆֲݍԅᄔߜಾ ူԉޮԅ Gregorian ఐອڑ॓ԅᄔd 6ĕۆ SUMPRODUCT() ď1Đഊੜd ၽٓՇԅދᆦᆦᄯēߜᆦճԅ၍ഭອѐēωֲݍѐݲᄍۤd ď2Đဴ֥d SUMPRODUCT(array1,[array2],[array3],…) SUMPRODUCT ۆဴ֥ပຏॹϵġ array1 Ρ༓dୣອ၍ഭ༓ྑࠩອѐωௐۤԅԛྡྷّᆦϵd array2, array3,... ࢶ༪d2 Ӿ 255 ّᆦϵēୣອ၍ഭ༓ྑࠩອѐωௐۤd ď3Đᅟ࿉ಹົd ᆦϵΡ༖ပອලԅปē႕ēۆ SUMPRODUCT ߜֲݍӐᄔ #VALUE!d ߑ᭄ SUMPRODUCT ᇚ䴲᭄ؐൟⱘ᭄㒘ܗ㋴Ў 0 ໘⧚DŽ 7ĕࢇճဈ ࢇճဈಾᄗဈӦ၍ٌԅࢇճыdैఢēఢڴ٤ߜӦ၍ٌ A1 ѐྻӦ၍ٌ A2 (=A1*A2)ׂӾ A4 ᄯēຣၽߜ٤؏ᄥӾখྡྷӦ၍ٌᄯē႕ Excel ߜԸჼ٤ᄯԅ०ّဈd
ఢڴϢฌუᄵဈ֟ಓ؟έē༖ၽဈԅqۜrۤqॹۜrަ౨ਥ၍ۜ($)ēუྂ ಾӦ၍ٌԅࢇճဈdA4 ᄯద٤ఢຏġ=$A$1*$A$2d ؏ᄥ A4 ᄯԅ٤ӾఉۥྡྷّӦ၍ٌୣᄔ՛Ϣݖ؟έ d 8ĕອճဈ ອճဈಾᄗອճဟͧۃ٤ԅӦ၍ٌԅອճสᄢdैఢēӦ၍ٌ B2 ͧۃ٤ ĤA1Ģ ExcelߜၽӦ၍ٌ B2 ౨ੋྡྷّӦ၍ٌۤᆰੋྡྷّӦ၍ٌ҉ԅӦ၍ٌᄯАდᄔd ၽ؏ᄥͧۃອճဈԅ٤ನēExcel ߜᆑՎԸჼ؏ᄥ٤ᄯԅဈēྻάဈອճဟӲ ٤สᄢԅୣӦ၍ٌdैఢēӦ၍ٌ B2 ᄯۃပ٤=A1ēA1 ಾ B2 ᆰ౨ֺԅӦ၍ٌē Վ A2 ԅඡѩσߜୣ؏ᄥᄠӦ၍ٌ B3 ನēୣᄯԅ٤ྸ࠼؟น=A2ēއӦ၍ٌ B3 ᆰ౨ֺ Ӧ၍ٌ҉ԅӦ၍ٌd 9ĕ܁ ܁ࢶဈဟᆑՎᄓఉԅྡྷົݧྡྷᆦЀᆴdఢڴઽྑၽ Microsoft Excel ᄯᄷ؏ᄓտّ ఉē႕ࢶྻৃᄥྡྷّ܁ࣿᆑՎᄓუ໔ఉd܁ಾࢶၮఉ࿉ұԅྡྷّЀᆴݧྡྷᆦЀᆴd җߙ܁ಾৃᄥ೪γԤݬЀᆴۤߏݬЀᆴdၽҗߙྡྷّ܁܊ēࢶྻΩހ܁ēճୣٝᆴֺࠩ ாฑٗ؟d ެಁઽਤّၥ՛ྑนϭᅖڕҗߙྡྷךͱζēωฌߜပဧࣛԅࢺܜыಁᄢน ܃ౄۤަҹٌdઽࢶྻҗߙωၮྡྷّ܁ēཁമߜუ໔ٌέٗဈӾ༪ᄯԅӦ၍ٌd 10ĕΑࠀၮസ ΑࠀၮസࢶྻΑࠀ०ّᄔēωСಓ০ހᄔēއయඨߑອē႕Сಓ০ހყᄔ TRUEĢ యඨߑϢē႕Сಓ০ހެᄔ FALSEdΑࠀၮസԅۃ࿌ރವैߎζ 3-2d 㸼 3-2 ↨䕗䖤ㅫヺ ↨䕗䖤ㅫヺ Н ⼎՟ =˄ㄝো˅ ㄝѢ A1=B1 <˄ᇣѢো˅ ᇣѢ A1<B1 >˄Ѣো˅ Ѣ A1>B1 >=˄ѢㄝѢো˅ ѢㄝѢ A1>=B1 <=˄ᇣѢㄝѢো˅ ᇣѢㄝѢ A1<=B1 <>˄ϡㄝো˅ ϡㄝѢ A1<>B1
˸ ᮥ
1ˊᣝӮ䅵⊩ᕟ⊩㾘㾘ᅮˈߎ㒇Ҏਬ䳔ᇚ᮹ᐌϢᑧᄬ⦄䞥䫊㸠ᄬℒ᳝݇ⱘϮࡵ䖯㸠ᭈ⧚ˈ ḍ䆄䋺߁䆕ˈⱏ䆄⦄䞥᮹䆄䋺䫊㸠ᄬℒ᮹䆄䋺DŽ ߃߃݀ৌ 2014 ᑈ 1 ᳜ 1 ᮹ᑧᄬ⦄䞥᮹䆄䋺䫊㸠ᄬℒ᮹䆄䋺ⱘ᳜߱ԭ乱ߚ߿Ў 1500 ܗ 890000 ܗˈ12 ᳜ӑᑧᄬ⦄䞥䫊㸠ᄬℒᬊҬϮࡵঞ㒣ᅵḌ᮴䇃ⱘ䆄䋺߁䆕˄ㅔ࣪Ḑᓣˈ㾕 㸼 3-3˅བϟ˖ ˄1˅1 ᳜ 1 ᮹ˈㅒথ⦄䞥ᬃ⼼ˈҢ䫊㸠ᦤপ⦄䞥 3000 ܗ⫼ˈᬃ⼼োⷕЎ 20093471DŽ ˄2˅1 ᳜ 8 ᮹ˈҢ亲㖨݀ৌ䌁ܹ⬆ᴤ᭭ 1000 गܟˈ↣गܟ 12.30 ܗˈӋℒ 12300 ܗˈ ؐ乱 2091 ܗDŽᴤ᭭Ꮖ偠ᬊܹᑧˈᓔߎϔᓴ䕀䋺ᬃ⼼ᬃҬ䋻ℒˈᬃ⼼োⷕЎ 20094783DŽ ˄3˅1 ᳜ 10 ᮹ˈҹᑧᄬ⦄䞥䌁фࡲ݀⫼ A4 㒌ᠧᄨᴎˈ䞥乱݅䅵 1120 ܗˈ⬅䋶ࡵ⾥ ࡲ݀ᅸⳈ乚⫼DŽ ˄4˅1 ᳜ 10 ᮹ˈկᑨ⾥ᓴढ乘׳Ꮒᮙ䌍 2000 ܗˈҹᑧᄬ⦄䞥ᬃҬDŽ ˄5˅1 ᳜ 17 ᮹ˈ⍋⊇݀ৌ䫔ଂ A ѻક 40 ݀᭸ˈ↣݀᭸ଂӋ 1000 ܗˈӋℒ 40000 ܗˈ ؐ乱 6800 ܗDŽᇍᮍҹ䕀䋺ᬃ⼼ᬃҬ䋻ℒˈᬃ⼼োⷕЎ 20092375DŽ ˄6˅1 ᳜ 18 ᮹ˈҹ⦄䞥䌁фࡲ݀⫼ક 320 ܗˈⳈѸҬࡲ݀ᅸՓ⫼DŽ ˄7˅1 ᳜ 20 ᮹ˈ㔫ᰧ䰇䫔Ꮒᮙ䌍ᑊѸಲ⦄䞥 500 ܗˈ㒧⏙ℒDŽ ˄8˅1 ᳜ 22 ᮹ˈ䫔ଂ㒭啭ⱒ䋻ὐ⬆ѻક 50 ӊˈ↣ӊଂӋ 200 ܗˈӋℒ 10000 ܗˈ ؐ乱 1700 ܗDŽℒ乍ᬊࠄᄬܹᄬℒ᠋DŽ ˄9˅1 ᳜ 26 ᮹ˈㅒথ䕀䋺ᬃ⼼থᬒ㘠ᎹᎹ䌘 340000 ܗDŽ ˄10˅1 ᳜ 30 ᮹ˈㅒথ䕀䋺ᬃ⼼ᬃҬᴀ᳜⬉䆱䌍 2500 ܗDŽ 㸼 3-3 䆄䋺߁䆕˄ㅔ࣪ᓣ˅ 2014 ᑈ 䋺᠋ৡ⿄ ᳜ ᮹ ߁䆕ো᭄ ᨬ㽕 ᘏ䋺䋺᠋ ᯢ㒚䋺᠋ ׳ᮍ䞥乱 䌋ᮍ䞥乱 ᑧᄬ⦄䞥 3000 1 1 Ҭ 1 ᦤপ⦄䞥 䫊㸠ᄬℒ 3000 ॳᴤ᭭ ⬆ᴤ᭭ 12300 ᑨѸ䌍 ᑨѸؐ 2091 1 8 Ҭ 2 䌁фᴤ᭭ᔧेҬℒ 䫊㸠ᄬℒ 14391 ㅵ⧚䌍⫼ ݀ৌ㒣䌍 1120 1 10 Ҭ 3 䌁фࡲ݀⫼ક ᑧᄬ⦄䞥 1120 ݊Ҫᑨᬊℒ ᓴढ 2000 1 10 Ҭ 4 䞛䌁ਬ乘׳Ꮒᮙ䌍 ᑧᄬ⦄䞥 2000 䫊㸠ᄬℒ 46800 Џ㧹Ϯࡵᬊܹ Aѻક 40000 1 17 ᬊ 1 䫔ଂѻકᔧेᬊℒ ᑨѸ䌍 ᑨѸؐ 6800㓁㸼 2014 ᑈ 䋺᠋ৡ⿄ ᳜ ᮹ ߁䆕ো᭄ ᨬ㽕 ᘏ䋺䋺᠋ ᯢ㒚䋺᠋ ׳ᮍ䞥乱 䌋ᮍ䞥乱 ㅵ⧚䌍⫼ ݀ৌ㒣䌍 320 1 18 Ҭ 5 䌁фࡲ݀⫼ક ᑧᄬ⦄䞥 320 ᑧᄬ⦄䞥 500 1 20 ᬊ 2 ᬊಲ䫔Ꮒᮙ䌍ԭℒ ݊Ҫᑨᬊℒ 㔫ᰧ䰇 500 䫊㸠ᄬℒ 11700 Џ㧹Ϯࡵᬊܹ ⬆ѻક 10000 1 22 ᬊ 3 䫔ଂѻકᑊᬊℒ ᑨѸ䌍 ᑨѸؐ 1700 ᑨҬ㘠Ꮉ㭾䝀 Ꮉ䌘 340000 1 26 Ҭ 6 থᬒ㘠ᎹᎹ䌘 䫊㸠ᄬℒ 340000 ㅵ⧚䌍⫼ ݀ৌ㒣䌍 2500 1 30 Ҭ 7 ᬃҬ⬉䆱䌍 䫊㸠ᄬℒ 2500 㽕∖˖˄1˅߽⫼ Excel Ꮉˈᅠ៤⦄䞥᮹䆄䋺䫊㸠ᄬℒ᮹䆄䋺ⱘ㓪䕥Ꮉˈ䋺㈓Ḑᓣঞ 㒚㡖᭄໘⧚খ✻乍Ⳃϔ乍ⳂϝⳌ݇ݙᆍDŽ ˄2˅ḍᬭᄺᅝᥦˈৃ䇒ූϞ䖯㸠гৃ䇒䖯㸠ˈҙ⬅Ͼԧ䖯㸠ˈৃϡ߫ߎᎹℹ 偸ˈᅠ៤ৢˈᬭᏜᅝᥦ䗖ᔧ㾘ⱘᄺ⫳䇒ූϞ∛ᅲ䆁៤ᵰˈᑊ䖯㸠⚍䆘DŽ 2ˊḍϞ䗄⦄䞥᮹䆄䋺ˈ㓪ࠊ↣᮹ⱘ⦄䞥᮹㸼ˈḐᓣݙᆍখⳟ乍ⳂѠⳌᑨ໘⧚DŽ 㽕∖˖䆹⦄䞥᮹㸼ড 2014 ᑈ 1 ᳜ 31 ᮹ⱘᚙމDŽ 3ˊϟ䴶ᰃढଚ݀ৌ 2014 ᑈ 1 ᳜ 31 ᮹㒣䗤ヨḌᇍⱘ䫊㸠ᇍ䋺ऩ˄㾕㸼 3-4˅䫊㸠ᄬℒ ᮹䆄䋺˄㾕㸼 3-5˅DŽ 㸼 3-4 䫊㸠ᇍ䋺ऩ ᅶ᠋ৡ⿄˖ढଚ݀ৌ ߎ䋺᮹ᳳ˖2014 ᑈ 1 ᳜ 31 ᮹ ᳜ ᮹ ᨬ㽕 ׳ᮍ 䌋ᮍ ԭ乱 1 1 Ϟ᳜㒧ᄬ 311388 1 2 Ѹᄬ⦄䞥 5000 316388 1 26 ҷҬ∈⬉䌍 4520 311868 1 28 ٓ䖬䋻ℒ 7200 304668 1 30 ҷᬊ䋻ℒ 7046 311714 㸼 3-5 䫊㸠ᄬℒ᮹䆄䋺 2014 ᑈ ᳜ ᮹ ᨬ㽕 ׳ᮍ 䌋ᮍ ԭ乱 1 1 ᳳ߱ԭ乱 311388 1 2 Ѹᄬ⦄䞥 5000 316388
㓁㸼 2014 ᑈ ᳜ ᮹ ᨬ㽕 ׳ᮍ 䌋ᮍ ԭ乱 1 22 䌁ܹ䆒 127480 188908 1 26 䫔ଂѻક 32620 221528 1 28 ٓ䖬䋻ℒ 7200 214328 1 31 ᴀ᳜ড়䅵 32620 139526 214328 㽕∖˖˄1˅ḍḌᇍৢⱘ䫊㸠ᇍ䋺ऩ䫊㸠ᄬℒ᮹䆄䋺ˈᶹᡒ䖒䋺乍DŽ ˄2˅ḍᇍ䋺㒧ᵰˈ㓪ࠊ䫊㸠ᄬℒԭ乱䇗㡖㸼ˈᑊҹ߸ᮁϟϔℹⱘᎹDŽ