存储价值？ [英] Store the Value?
问题描述
我一直在阅读一些关于在表格中存储数据的主题以及如何将b $ b b通常是一个坏主意。有人可以给我一个关于如何做
以下的线索：
我正在跟踪我的程序的挣值。挣值为
帐户预算*％完成。因此，它计算了预算对任务完成了多少。很容易;但是接下来的一个月又来了
我还需要知道上个月的挣值是多少？b $ b用于图形目的。示例如下：
1月
任务％完成预算EarnedValue
A 20 100 20
跳到下个月
二月
任务％完成预算获奖值
A 40 100 40
出于图形目的，我需要将1月份的EarnedValue保持为20
，将2月保持为40.这是可能的。
任务的％完成更改，所以我不能再计算一月了。
这是存储价值的好时机吗？
感谢您的帮助。
基思
好吧，要么你必须存储挣值每月或％完成
每月
。如果预算发生变化，在某种程度上取决于（你知道预算不会上涨吗？）在这种情况下你也需要存储预算。
如果数据需要存储 - 就这样吧。我认为你对存储计算值的
感到困惑，这基本上是一种不好的做法。
我会在月度表中存储预算（仅当它改变时）否则
它可以存储在项目表中，并将％完成存储在
每月表中。你可以将获得的值作为计算得到的
未存储
HTH
Phil
turtle< ko **** @ vistacontrols.com>在消息中写道
news：11 ********************* @ f14g2000cwb.googlegro ups.com ... < blockquote class =post_quotes>我一直在阅读一些关于在表格中存储数据的主题以及它如何通常是一个坏主意。有人能给我一些关于如何进行以下操作的线索：
我正在跟踪我的程序的挣值。挣值用于预算*％完成预算。因此它计算了
经理说完任务的程度。预算。很容易;但是接下来的一个月来了，我仍然需要知道上个月的挣值是多少，以便进行图形化。示例如下：
1月
任务％完成预算EarnedValue
A 20 100 20
跳到下个月
2月
任务％完成预算EarnedValue
A 40 100 40
为了图形化，我需要将1月份的EarnedValue保持为20
，2月保持为40岁。这是可能的。
任务的％完成更改，所以我不能再计算一月了。
这是存储价值的好时机吗？
感谢您的帮助。
Keith
谢谢Phil，
我想我会尝试每月存储％完整表格。
如何做到这一点？我每个月都会有一张桌子吗？b
...以后似乎不是最好的选择。
我有点困惑关于它的外观。
你需要一个包含项目详细信息项目的表格
ProjectID - 自动编号，项目名称，预算等等等
你需要一个MontlyTable
DateID - 自动编号，ProjectID - 长，百分比完成 - 十进制
建立之间的关系2个表强制执行参照完整性
两个ProjectID之间
您需要一个基于项目的表单
您需要一个基于MonthlyTable的子表单。使用按ProjectID排序的查询
和日期。 LinkChildFields& LinkMasterFields将再次成为ProjectID
您还可以在此子表单上显示Budget * PercentCompleted和
总计。
By我写这篇回复的时候，我本来可以建一个数据库。
玩得开心
菲尔
turtle < KO **** @ vistacontrols.com>在消息中写道
news：11 ********************** @ c13g2000cwb.googlegr oups.com ...感谢Phil，
我想我会尝试每月存储％完整表格。
这是怎么做到的？我今年的每个月都会有一张桌子......以后似乎不是最好的选择。
我对这看起来有点困惑。
I have been reading a few topics on storing data in a table and how it
is usually a bad idea. Can someone give me a clue on how to do the
following:
I am tracking Earned Value for my programs. Earned Value takes into
account the budget * % complete. Therefore it calculates how much the
manager says is done on the task by the budget. Easy enough; but then
the next month comes and I still need to know what the Earned value was
for the previous month for graphing purposes. Example follow:
January
Task % Complete Budget EarnedValue
A 20 100 20
Skip to next month
February
Task % Complete Budget EarnedValue
A 40 100 40
For graphing purposes i need to keep the EarnedValue for January as 20
and February as 40. Is this possible. The %complete changes on the
task so I can''t calculate January anymore.
Is this a good time to store the value?
Thanks for your help.
Keith
Well, either you have to store the earned value each month or the % complete
each month. Depends to a certain extent if the budget changes, (have you
ever known a budget not go up) in which case you need to store that as well.
If data needs to be stored - so be it. I think you are getting confused with
storing calculated values, which by and large is a bad practice.
I would store in the monthly table the budget (only if it changes otherwise
it could be stored in the project table, and store the %complete in the
monthly table. You than can do the earned value as a calculation which is
not stored
HTH
Phil
"turtle" <ko****@vistacontrols.com> wrote in message
news:11*********************@f14g2000cwb.googlegro ups.com...I have been reading a few topics on storing data in a table and how it
is usually a bad idea. Can someone give me a clue on how to do the
following:
I am tracking Earned Value for my programs. Earned Value takes into
account the budget * % complete. Therefore it calculates how much the
manager says is done on the task by the budget. Easy enough; but then
the next month comes and I still need to know what the Earned value was
for the previous month for graphing purposes. Example follow:
January
Task % Complete Budget EarnedValue
A 20 100 20
Skip to next month
February
Task % Complete Budget EarnedValue
A 40 100 40
For graphing purposes i need to keep the EarnedValue for January as 20
and February as 40. Is this possible. The %complete changes on the
task so I can''t calculate January anymore.
Is this a good time to store the value?
Thanks for your help.
Keith
thanks Phil,
I think I am going to try to store the % complete table each month.
How is this to be done? Will I have a table for each month of the
year... doesn''t seem to be the best option for writing queries later.
I am a bit confused on how this will look.
You need a table with the Project details Projects
ProjectID - Autonumber, ProjectName, Budget etc etc etc
You need a MontlyTable
DateID - AutoNumber, ProjectID - Long, PercentComplete - Decimal
Set up a relationship between the 2 tables enforcing referential integrity
between the 2 ProjectIDs
You need a form based on Projects
You need a subform based on MonthlyTable. Use a query sorted by ProjectID
and date. The LinkChildFields & LinkMasterFields will again be the ProjectID
You can also display on this subform the Budget * PercentCompleted and the
total.
By the time I have written this reply , I could have built the database.
Have fun
Phil
"turtle" <ko****@vistacontrols.com> wrote in message
news:11**********************@c13g2000cwb.googlegr oups.com...thanks Phil,
I think I am going to try to store the % complete table each month.
How is this to be done? Will I have a table for each month of the
year... doesn''t seem to be the best option for writing queries later.
I am a bit confused on how this will look.
这篇关于存储价值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
