м˸

ιά¿Ǥ

2017ǯ08

Ȣ󥺹ά˴ѸҤ䤷

ϡѸҤˤĤƤǤ⡼

Ρ㤨ϲŴλߤξܺ٤ˤϡ

ϲŴܺ

Ƚ񤤤Ƥޤɡͷˤ

ϲŴʤɤμϤ˿͵ι⤤ߤ֤ȴѸҤ¿줷ޤ

ȤʤäƤޤñ˼ϤˤŹ򤪤Ƥ͵Ϥޤ顢ɤΤȤ͵夲Фޤ͡

ǡξϡϤ˷Ƥߤˡ͵ΡĤƤޤʲɽΤ褦ʤΤǤ

̾
͵μǿ͵10åפ
͵ޥ˥奢ǿ͵30åפ
͵ǿ͵50åפ

ˡϤޤư˥塼饢ƥ¤Τμ¤⤷ޤ

ܤƤ᤯λߤСʲβΤ褦ˤοʬ͵åפޤ

͵ޥ˥奢

ʤʡִѸ֡פʤˤϡѸҤ50ͤΤ褦Ǥ51ͰʾˤˤϡִѸ֡פǥåʤФʤޤ

ޤȤޤȡѸҤ䤹ˤϡ
  • ϲŴʤɤϡ̤λߡʤŹˤܤ
  • Ǥʤϡܤߤ᤯λߤ˿͵Υ꡼
  • ǤϡѸҤξ¤50ͤޤ
  • ѸҤ51ͰʾˤˤʡִѸ֡פɬ
ͤˤʤޤ鹬Ǥ

Ȣ󥺹ά˥饭ϼ

Ūϼ˴ؤƤϡޤƽ񤳤ȻפäƤΤǤܤ˼Ǥ֥饭ϡפμ˴ؤƽ񤭹ߤȻפޤ

Ρ֥饭ϡפĩ魯ݤˤϡʲΤ褦ʻ򵤤ˤȤʤȻפޤ
  • ĩϡ3ǤϤʤ4ˤʤäƤ
  • ĮŤǤ롢˳
  • ˤϡǽ˼ư䵡Ƥȳڤ⡩
  • ʳˡĤۤɿݥȤФߤƤᤤ⡩
ǤϡɤäƤޤ͡

Ρ֥饭ϡפǤˤϥ֤4δ֤ˡ褦ȤƤ֥饭ϡפ˻ߤƤơݥȤ3ĤʤФʤޤ󡣲βΰֺΥݥȤǤ

ݥ

οݥȤޤ᤿ΤˡָݥȡפȤƤ̾ĤƤޤΡָݥȡפ̾ˤϤʤʤФʤǤ͡

̾פȽ񤭤ޤΤϡ̾露ʤ֤ʤФ䤹ʤ뤫ǤɬФǤϤʤΤǤʤ㤤ޤ

ϡ˹ԤĮΡߺ긢פ򳫺ŤˤϤʤФ䤹ʤޤ

꤬ļ¤ϤĮߺ긢פϡ֥饭ϡפĩǤ3ǤϤޤŽʤΤǤġ4ˤʤȽ褦ˤʤޤ

줬־˽񤭤ޤĩϥ4ˤʤäƤפȤΤͳǤ

3ܤΡֺǽ˼ư䵡Ƥȳڤ⡩פȤΤϡư䵡ϿݥȤФʤǤ

ư䵡ܺ

ɤΡָݥȡפФϡߤξܺٲ̤αü򥹥磻פɽޤΤü俿ȥ磻פƤʤǤ͡Ĥथ

ϤȤ⤫¾οʥݥȤФߤǤϡܵҥݥȤФǽΤդɬפǤ

ԥܺ

ͤˤʤޤ鹬Ǥ

Ȣ󥺹άȢ󥺹άȹޤʣ

  • ϼΥȤɲäޤ
  • 󥯥٥ȤΥȤɲäޤ
ޡĮܡʡˤƤĤĿĴ٤Ƥޤ

ľȤϻפޤ󤬡ġ¤褦ȡ

|Ȣ󥺹ά
https://script.google.com/macros/s/AKfycbwV0gBUXUzn6ApsdK2RmObx9vtc1hN43eeC5xyZkBCAsiCkviE/exec

Ȣ󥺹ά
https://docs.google.com/spreadsheets/d/1nJ0ET9nWVi7-6wT_emZTcnUDlcZFLUIQemk9xUnqLYU

Ȣ󥺹ά˽֥󥭥кǯǯԡ

Ȣ άפν֥󥭥кǡΡǯǯԡפֺǸˤäƤޤɡľ˴ؤƤϼޤġȤꤢǤλιͤ񤤤Ƥߤޤ

ǯǯԤȤʤȿˡͤޤɡѤ٤٤Ƹ̤⤽˻פ¤٤Ƥߤޤ
  • Ʊλߤϲơξ徺ޤ
  • ɬפֻߤ򸺤餹
  • 糹Ȥ
  • ͤ䤹
  • ͤε⤯
  • ĮָܥեƥХפ¹Ԥơʲʤ夲
  • Ǿʲʤ夲
  • ǹ۾ʤλߤο͵夲
  • ʤäơʲʤ夲
ʤϡ㤨Фηλξʲʤ夬ޤݥȤȤޤǸμʤȤ⤷ޤ

ܤֻߤγǧǤ˥塼ΰ־α¦λȾΡʾơ3ڡܤǯפˤʤޤ顢̺¤ӽ뤳Ȥֻ߽˸뤳Ȥޤ͡Ĺ

ơĿŪˤ糹Ǥ䤬糹ȤΤȤΤ⤢ޤ

Ȣ󥺹ά˽֥󥭥кʺǹϲԡǽ񤤤糹ˤ륯졼ײˤȡ2夬äƤϤޤķߥ˥塼ǸͤȤϤ㤤ޤ

졼ײʴ͡
졼ײ糹

ͤεͿ⤬ʬ˹⤯ʤȡʤ㤨˵äƤޤ礬ޤġ

٥1Υե꡼ε10ǡ50ǹȤͤȡפˤ糹ȤǤޤΤϴǤäȤ⡢ƼȥեϤȤʤĮ꤫θȾ˾ʤȡŸ˾ľˤϼʤäȤϻפޤ

֥󥭥󥰤ǯǯפϡ1/20ȤƲûޤΤǡ20,0001,000ptˤʤ뤫Ȼפޤ

ͤˤʤޤ鹬Ǥ

Ȣ󥺹άȢ󥺹άȸƤߤޤ

ˡ

ǡĤΤ褦ʻ򤷤ƤΤǤ¾Ϥ줿ǡȤ碌ĺƤڡʤΤǡ뤫̯ʵޤġ

Ƚ񤤤Ȣ󥺤 google spreadsheet ΤǤκäʬƤߤ褦ʤȡġ

|Ȣ󥺹ά
https://script.google.com/macros/s/AKfycbwV0gBUXUzn6ApsdK2RmObx9vtc1hN43eeC5xyZkBCAsiCkviE/exec

Ȣ󥺹ά
https://docs.google.com/spreadsheets/d/1nJ0ET9nWVi7-6wT_emZTcnUDlcZFLUIQemk9xUnqLYU

ޤľܹΥȤȡʤȤƤޤɡˤ򸡺Τޤ󤬡礸ˤǤ䤻Ȼפޤ

ǤλߤľܹǤʤˤϲɽޤ󡣤λʤʤϤޤѥʤǤʣˡ

ʤᤳ㥷Ȥ³ޤ

Ȣ󥺹ά˽֥󥭥кʽ̱ιǽԡ

Ȣ άפν֥󥭥кȤꤢκǸϡ̱ιǽԤǤ;Ϥޤǯǯספ񤤤ƤߤȤϻפޤġ

ιܤpt򤢤ˤϡʲΤ褦ˡ뤫Ȼפޤ
  • ̱󥯤夲ơơξ¤䤹
  • ơ礭ʿž
  • ߤ1ܤƤȤΡơܡʥѤ
  • ư->ƥ¤ǡơ夲륢ƥ¤ƻѤ
ΣĤϤƻʺȤǤĥơ5äƤä1ptǤ顣

äʬˤȻפޤ3ܤΡ1ܤƤȤΥơܡʥפˤĤƤޤ͡

ĮǡʪʤɤȤηʪäˡϤνͤΥơ徺ȤΤǤʪΥ٥륢å׻ϡƥष㤨ʤΤǤȤϰ㤤ޤ

㤨С򲰤ʤ餳Τ褦ϰϤǡʤ⤦⤷ޤ󤬡ġˡ

1ܥܡʥ

ơ٤夬ޤĥǥ𤬤Τ46ͤ˱ƶФƤޤ͡

1ܥܡʥ

֥󥭥󥰤ǽ̱ιǽϤϡ1/5ȤƲûޤΤǡ45,0009,000ptˤʤ뤫ȡˤޤ󥯣νͤϣơMAXʿ90餤ʤΤ905100=45,000Ǥ礦İͤҤȤθ̤̣ǤptȤƤ礭ʤȻפޤ

ͤˤʤޤ鹬Ǥ

ʤʤᤳ㹶ά˥ڥܡʥ㤨ѡƥڡޤʣ

  • ĥĴַ֤ꤰץ2937ؤ򤷤ޤ
Ĺ餯Ver1.0.8ǤѹбƤޤǤۤбޤ٤ʤäƤߤޤġ

˾ǡδְ㤨ʤɡޤ饳ˤǤ⤪ͤޤ

ڥܡʥ㤨ѡƥ | ʤᤳ㥷
https://script.google.com/macros/s/AKfycbxAwIQnydtDyKqQSK5REUxe7TyAmAerxwOGMjdgTmhOrnayrmCI/exec

ʤᤳ㥷
https://docs.google.com/spreadsheets/d/18t4ZMxGtReUYzQ-oiYr9h1rn9dIo4XJMEneaIxnuZDc/edit?usp=sharing

ʤʤᤳ㹶ά˽ǡĥĴַ֤ꤰץڥܡʥ館ѡƥ

ˡʤʤᤳ㹶ά˥ĥĴַ֤ꤰץڥܡʥ館ѡƥ񤭹ǤޤVer.1.0.8ǤѹбƤޤǤߤޤġ

ơVer.1.0.8ʹбΥĥĴַ֤ꤰץڥܡʥ館ѡƥǤ

ǤˤάȡʲΤ褦ˤʤ뤫Ȼפޤ

  • ֤Ȥ501ɤ
  • ֤Ȥ452ɤʥ­+5
  • 501ɤʥ빬+5
  • Ф䤵651ɤʥ­+10
  • ֤Ȥ35Ф䤵55ʥ륹ޡϤФ䤵+20
  • 빬1ɤ
  • ­3ɤ
  • 빬Ƚ­1ɤ
  • ιפ֤Ȥ160ʥƬ+20

⤬ѹƤФ餯ϡǸΡ֥빬Ƚ­1ɤפʤᤳ餺˥ڥΩʤäΤǤ֥ߥ󥯤ʤᤳפ򤦤ʤᤳפΥ23˹դȤΩ褦ˤʤޤ

ȤϤߥ󥯤ϥ53ǤΤǤƤơ򤦤⡢26ϥơ­ʤ褦ǡ35ˤʤäơ

򥦥ʤᤳ,̤ʤᤳ,̤ʤᤳ

37ǡ

򥦥ʤᤳ,̤ʤᤳ,̤ʤᤳ
򥦥ʤᤳ,ͤʤᤳ,̤ʤᤳ

ȤѡƥСǾ˥ڥܡʥ㤦ǽʤ褦ǤʤȤ߹碌ϡΥ󥯤ޤǤΤ줾ΤʤᤳƺäƤˤʤäƤޤȡ嵭Ͻ㤦Ȥ߹碌ϽƤޤ

ڥܡʥ㤨ѡƥ | ʤᤳ㥷
https://script.google.com/macros/s/AKfycbxAwIQnydtDyKqQSK5REUxe7TyAmAerxwOGMjdgTmhOrnayrmCI/exec

ͤˤʤޤ顣
³ɤ

Ȣ󥺹ά˽֥󥭥к۹ԡ

۹

Ȣ άפ³Ƥϡ۹פΤäǤ³ġ

ιܤpt򤢤ˤϡʲΤ褦ˡ뤫Ȼפޤ
  • ̱󥯤夲ơۤξ¤䤹
  • ΤȤž
  • ĮΡкѥߥåȡפԤ
кѥߥåȡפϡե˲٤̤ȤΤǤ͡ĮԤȡۤƶƤʽνؤ⤪ޤ̤ϤꤽǤ

ǤĤޤǤƤʤʤۤʤͤޤġ㤨СޥåȤ̾ؤ˻ϡĤĮäƤޤΤޥå⾯ʤǤ͡

ϲ񤷤䤹פȤơΤȤפä⤷ޤɤ餽Ǥʤޤ

Ρͷפˤȥơֶ١פϡǤ٤ʤɤ˱ƶȤʤäƤޤ⤷餳줬⤤ϲ񤷤䤹Τ⤷ޤ

ɤΤȤĮкѥߥåȡ׻ʳϡեϷ줷̤ʤΤǤ餽ʳΤǤϥХȤ˳ƤȻפޤХȤƤΤϤʤ˸ʤޤΤǡˤˤǤϲ񤹤ˤʤäƤޤΤʤȡ

Ĥޤꡢ٤夬ʤ褦ˤФĤȻפΤǤǤޤ꤬

٤äƾ˾夬䤹ޤ

ǡФƤϡեߥ쥹ʤ

٤ߤ򤪤

Ǥб褽ʵϤƤΤǤ㤨СϤ⤤1ǤȤʤʤäƤʤƷϲ񤷤ƤȤΤ⤢äƤޤʤǤ͡थ

ȡȤꤢޤȤޤȡ
  • ̱󥯤夲ơۤξ¤䤹
  • ΤȤž
  • ĮΡкѥߥåȡפԤ
  • ơ٤夬ʤ褦ˡ٤򲼤ߤ֤롩
Ǥ礦

֥󥭥󥰤۹פϡ1/10ȤƲûޤΤǡ10,0001,000ptˤʤ뤫ȡǽβϡۤMAXˤʤä10ͤͤĮʤΤǡ줯餤ptˤʤäƤޤ

ͤˤʤޤ鹬Ǥ

ʤʤᤳ㹶ά˥ڥܡʥ㤨ѡƥڡޤʣ

  • ۥƻ֤ʤץ68ꥹȤɽƤʤΤޤ
ޤƤꥹȤɽƤޤǤʤġ

˾ǡδְ㤨ʤɡޤ饳ˤǤ⤪ͤޤ

ڥܡʥ㤨ѡƥ | ʤᤳ㥷
https://script.google.com/macros/s/AKfycbxAwIQnydtDyKqQSK5REUxe7TyAmAerxwOGMjdgTmhOrnayrmCI/exec

ʤᤳ㥷
https://docs.google.com/spreadsheets/d/18t4ZMxGtReUYzQ-oiYr9h1rn9dIo4XJMEneaIxnuZDc/edit?usp=sharing
ˬԿ
  • ߷ס

Recent Comments
Recent TrackBacks
  • 饤֥ɥ֥