データ管理

[投稿日時]2011.2.20 23:52 [コメント数]374件

(2011年2月20日 作成)

現在実施している企画『真・ゴールド神への道』では、プレイ日毎に様々な計算をする必要があります。日々投稿している記事中にもありますが

  • プレイ時間と企画開始からの経過時間
  • 所持金や預金額の増減、およびその合計値
  • 企画開始から増加した金額、その内モンスターから入手した合計額
  • その日プレイした中で敵から入手した金額と単位時間当たりの平均額
  • 物品購入で使用した額と売却した額の合計

等が主なものとしてあります。当初はその都度電卓を使用して計算していましたが、だんだん管理するデータ量が増え、数字も大きくなってきてきたので手間がかかるようになりました(こういうデータものは、計算ミスが一番怖い)。そこで、企画途中より『データ管理の効率化』と『計算の手間を省く』ことを目的として、表計算ソフトを導入して管理を行っています。ちなみに利用しているソフトは『OpenOffice.org Calc』です。

これは、『真ゴールド神への道』で利用しているシートです。セルの背景が黄色い箇所(“前日~”以外の箇所)に現在の数値を入力、及び『購入品一覧』『売却品一覧(画像では切れていますが)』にその日に購入・売却したアイテムの販売価格(売却価格)と数量を入力することで、関連する項目の数値が自動計算される仕組みです。

これは、『Wi-Fiショッピング』で利用しているシートです。上の『真・ゴールド神への道』で利用しているシートとは独立して管理(『Wi-Fiショッピング』と『真・ゴールド神への道』では開始時期が違うのと、『真・ゴールド神への道』では、Wi-Fiショッピング以外で使用した金額も対象であるためにデータ共有が出来ないため)しています。

これは、現在は記事執筆に特に関わってはいませんが、日々の平均入手額と合計額を管理するシートです。このシートのみグラフを使用し、日々の平均額の変動と合計額の上昇スピードを視覚的に分かるようにしています。なお、このシートの対象データは、ゴールデンスライム狩りを本格的に開始した2011年1月4日以降となっています

374 件のコメントがあります



  1. adidas ultra boost

    I must show my appreciation to this writer just for bailing me out of this condition. Right after scouting throughout the search engines and coming across solutions which were not powerful, I thought my life was over. Living without the presence of approaches to the issues you have sorted out by means of your main write-up is a crucial case, as well as the ones that would have adversely damaged my career if I hadn’t noticed your blog post. Your own capability and kindness in maneuvering a lot of stuff was very useful. I don’t know what I would’ve done if I hadn’t discovered such a solution like this. I am able to at this point look forward to my future. Thanks for your time very much for this professional and result oriented help. I will not be reluctant to propose the sites to anybody who wants and needs guidance about this subject matter.



  2. converse shoes

    I am just writing to make you understand of the outstanding discovery my wife’s girl obtained using your site. She picked up so many pieces, most notably how it is like to have an ideal coaching mood to let many more really easily fully understand specified very confusing subject areas. You truly surpassed our expectations. I appreciate you for offering such productive, healthy, educational and as well as cool guidance on that topic to Sandra.



  3. cheap oakley sunglasses

    Thank you so much for giving everyone such a pleasant chance to discover important secrets from this web site. It really is very superb and as well , stuffed with a good time for me personally and my office fellow workers to search your site no less than thrice every week to read through the newest guides you have. And indeed, I am certainly fulfilled with your terrific tactics you give. Selected 1 facts in this article are in reality the most beneficial we’ve ever had.



  4. michael kors outlet online

    Needed to draft you that tiny word to say thanks over again for those remarkable information you have contributed on this site. This is simply seriously open-handed with you to allow freely all many individuals could have made available for an ebook to help make some dough for their own end, especially given that you might well have done it in the event you decided. Those tips as well worked like the fantastic way to recognize that other people have the same fervor like my own to grasp a great deal more with reference to this matter. I am sure there are millions of more enjoyable opportunities in the future for individuals who see your website.



  5. Brianpat

    o http://cialisxtl.com/index.html female cialis



  6. derrick rose shoes

    My husband and i got really satisfied when Ervin could round up his studies from your ideas he got through the site. It is now and again perplexing to simply be giving for free guidelines that other people might have been selling. We really consider we’ve got the website owner to thank for this. All the explanations you made, the straightforward website navigation, the relationships you can help to instill – it’s got everything remarkable, and it is letting our son and the family reckon that this issue is fun, and that’s seriously important. Many thanks for everything!



  7. golden goose sneakers

    I simply wanted to send a brief comment to say thanks to you for some of the fabulous guidelines you are giving at this website. My rather long internet research has at the end been honored with incredibly good knowledge to go over with my friends. I ‘d declare that we visitors are rather lucky to dwell in a perfect place with very many marvellous individuals with beneficial basics. I feel very happy to have seen your entire website page and look forward to really more brilliant minutes reading here. Thanks a lot once more for everything.



  8. NMD R1 Runner PK Purple Blue

    I have to show some thanks to this writer just for bailing me out of this type of incident. Right after looking out throughout the world-wide-web and finding basics which are not beneficial, I thought my entire life was over. Living minus the solutions to the problems you’ve solved through your good post is a critical case, and the kind that would have badly damaged my career if I had not discovered your web page. Your own knowledge and kindness in controlling all areas was useful. I am not sure what I would’ve done if I had not come across such a stuff like this. I can at this moment look ahead to my future. Thanks a lot so much for this high quality and effective help. I won’t hesitate to endorse the blog to anybody who requires counselling on this subject matter.



  9. adidas ultra boost

    I would like to point out my affection for your kindness for men and women that must have assistance with this particular issue. Your real commitment to getting the solution across was amazingly powerful and have in most cases made ladies much like me to achieve their objectives. This warm and friendly useful information entails a whole lot a person like me and even further to my mates. Thanks a ton; from all of us.



  10. adidas nmd

    I enjoy you because of every one of your work on this blog. My daughter delights in going through investigations and it’s simple to grasp why. Most people learn all concerning the lively method you produce very important thoughts via this web blog and inspire contribution from visitors on that article plus our own girl has always been starting to learn a lot of things. Take pleasure in the rest of the new year. You are always doing a really good job.



  11. adidas ultra

    Thanks so much for giving everyone an exceptionally brilliant opportunity to read from this website. It’s always so awesome and also packed with a great time for me and my office peers to search your website really thrice in one week to see the newest things you have got. Not to mention, I’m so usually happy concerning the perfect strategies served by you. Selected 2 ideas in this posting are in reality the finest I’ve ever had.



  12. ray ban sunglasses

    I together with my pals were studying the excellent strategies found on your web page while quickly came up with an awful suspicion I never expressed respect to the web blog owner for those strategies. Those young men are already for that reason stimulated to study them and have now extremely been using them. Appreciation for getting quite considerate and then for using varieties of high-quality things most people are really desirous to understand about. My personal honest regret for not expressing gratitude to sooner.



  13. adidas nmd r1

    My husband and i have been absolutely fortunate when Jordan could carry out his research because of the precious recommendations he had when using the web pages. It is now and again perplexing to just continually be making a gift of tricks some other people might have been selling. And we remember we need the blog owner to be grateful to because of that. Most of the explanations you have made, the straightforward blog navigation, the relationships your site aid to engender – it’s all terrific, and it is helping our son and our family feel that that article is amusing, and that’s really essential. Many thanks for everything!



  14. kate spade handbags

    I have to show my respect for your kindness in support of those people who really want guidance on this one situation. Your special dedication to passing the solution all around appears to be definitely practical and has all the time permitted associates much like me to arrive at their ambitions. Your warm and helpful information denotes a lot to me and substantially more to my office workers. With thanks; from all of us.



  15. rayban sunglasses

    I simply needed to thank you so much once again. I do not know the things that I would’ve gone through in the absence of the actual pointers shared by you over that area of interest. It actually was a real challenging matter for me personally, however , spending time with the very expert style you treated the issue made me to leap over gladness. Extremely grateful for the guidance and pray you know what an amazing job that you are accomplishing training other individuals all through your blog. More than likely you’ve never met all of us.



  16. Brianpat

    e http://cialisxtl.com/index.html cialis coupons



  17. nike flyknit racer

    Thank you a lot for providing individuals with an extraordinarily special possiblity to read critical reviews from this web site. It is often very enjoyable and packed with amusement for me and my office colleagues to search your web site at least three times weekly to study the newest issues you have got. And of course, I’m usually satisfied for the dazzling creative concepts you give. Some two points on this page are unequivocally the simplest we have all had.



  18. yeezy boost 350

    I needed to write you one very small observation so as to thank you yet again on your pretty pointers you’ve shared in this case. It was simply remarkably open-handed of people like you to deliver unhampered precisely what a few people could possibly have made available as an ebook in making some bucks for themselves, especially since you could possibly have done it if you desired. These tricks in addition worked as the fantastic way to know that the rest have the same fervor really like mine to learn a lot more on the subject of this condition. I think there are lots of more pleasant periods ahead for people who scan through your blog post.



  19. nike running shoes

    I wanted to write you a tiny observation to help say thank you the moment again about the pleasing pointers you’ve featured on this page. This is really pretty open-handed with you to allow openly just what a lot of folks could have marketed for an electronic book to get some dough for themselves, particularly considering that you might have done it if you ever decided. Those basics additionally worked like a great way to be sure that other people have similar passion just like my personal own to learn a lot more in respect of this matter. I know there are lots of more pleasurable situations in the future for folks who find out your site.



  20. air max 270

    My wife and i ended up being absolutely glad Michael managed to finish off his survey through your ideas he received through your web pages. It is now and again perplexing to simply find yourself giving freely tactics others might have been selling. And we all see we have the website owner to be grateful to for this. The most important illustrations you’ve made, the simple blog navigation, the relationships you assist to promote – it is all excellent, and it’s aiding our son and the family consider that this topic is fun, which is certainly exceedingly essential. Thank you for everything!



  21. nike lebron soldier 11

    Thank you a lot for providing individuals with an extraordinarily nice chance to read articles and blog posts from this site. It is always so awesome plus full of a good time for me personally and my office friends to visit the blog nearly 3 times a week to read through the newest issues you will have. And lastly, I am also usually satisfied with the terrific techniques you serve. Selected 4 ideas in this post are surely the very best we have all ever had.



  22. Kennethshing

    wh0cd221265 abilify



  23. dior sunglasses

    My spouse and i got glad that Michael managed to deal with his researching through your precious recommendations he grabbed while using the web page. It’s not at all simplistic to just always be giving freely tips that many the rest might have been making money from. We do know we need you to appreciate for that. The main illustrations you have made, the easy web site navigation, the relationships your site assist to foster – it is mostly extraordinary, and it’s letting our son in addition to our family reckon that this topic is cool, and that’s particularly serious. Thanks for the whole lot!



  24. yeezy boost 350 v2

    Thank you so much for giving everyone an extremely pleasant chance to read in detail from this web site. It can be very pleasurable and as well , full of fun for me and my office peers to search the blog at the very least thrice a week to read the latest items you will have. Of course, I am at all times amazed considering the dazzling thoughts you serve. Some 4 points in this post are really the finest I’ve ever had.

コメント作成

 
%d人のブロガーが「いいね」をつけました。