从累积的数据集创建图表。

在我们指导您找到解决方案之前，我们需要更多信息。我们不是医生，因此我们不了解胰岛素及其在体内的使用方法。


储存胰岛素的表的结构是什么信息？


你正在使用的半衰期公式是什么？


是否有一点胰岛素会降低这么多特定的胰岛素注射液不会以任何明显的方式影响体内胰岛素的含量吗？


胰岛素水平及其半衰期是在全球范围内还是在每次注射中计算基础？或者这是不是因为半衰期公式的特点？


您如何解释胰岛素使用中的咳嗽？特别是在用餐时间之前，期间或之后。


这张图表应该是什么样的？


定期进行胰岛素水平测量而不是依赖投影是不是更安全？


是否没有预先存在的计算器可以用来解释所有这些以及其他问题我可能没有预料到？

We will need a lot more information before we can being to guide you to a solution. We are not doctors so there are many things we do not know about insulin and how it is used within the body.

What is the structure of the table(s) that store the insulin information?

What is the half life formula you are using?

Is there a point after which a shot of insulin becomes degraded so much that a particular shot of insulin no longer affects the amount of insulin within the body in any appreciable manner?

Is insulin level and its half life calculated on a global level or on a per shot basis? Or does this not matter because of the characteristics of the half life formula?

How do you account for flucutations in insulin usage? Especially around the time of a meal, either before, during, or after.

What is this chart supposed to look like?

Would it not be safer to take regular insulin level measurements rather than relying on a projection?

Are there no pre-existing calculators that you can use that will have accounted for all this plus other questions that I may not have foreseen?

Jetson：

我知道我想帮助你，我肯定很多其他人在这里这样的数据库对许多人来说真的很有帮助;然而，这里有一个责任问题必须清理：


必须非常，非常清楚... 这里没有人可以提供任何医疗以任何方式提供建议或指导，我们也不能保证所开发的内容能满足您或您儿子的医疗需求。 使用所提供的任何信息需要您自担风险，并且您应该确保查看您与经过培训的医疗专业人员获得的任何结果，该专业人员了解您和您儿子的情况。医疗需求 - 除了对返回结果的普通老式常识审查之外。


我的一位教授是糖尿病患者，并且有一张图表，他过去常常策划这个基于时间，血糖结果和胰岛素剂量的信息...您可以咨询您的医生。这张图表真的是老派的东西。不幸的是，我的教授在十多年前去世了，所以我无法联系他作为图表的名称。我不认为Access也可以制作这样的XYZ图表。

Jetson:
I know that I for one would like to help you with this, along with I''m sure many others here. Such a database could be really helpful for many people; however, there is a liability issue here that has to be cleared up:

It must be made very, very clear… no one here can provide any medical advice or guidance in any manner whatsoever nor can we, nor will we, provide any guarantee that what is developed will meet your or your son’s medical needs. The use of any information provided is at your own risk and you should make sure to review any of the results you are obtaining with a trained medical professional that is knowledgeable about you and your son’s medical needs – in addition to just plain old common sense review of the returned results.

One of my professors was diabetic and there was a chart that he used to ''plot'' this information based on time, blood sugar results, and insulin dosage... you might check with your doctor. This chart would be really old-school stuff. Unfortunately, my prof passed away over a decade ago so I can''t contact him for the name of the chart. I don''t think Access can make such an XYZ chart either.

感谢您的回复。首先，我理解并感谢您关注的不是医生，可能造成的伤害和医疗责任，所以让我明确一下范围和目标。


Back Ground

我将从一些I型糖尿病背景开始。它是一种自身免疫性疾病，会破坏胰腺中的胰岛素分泌细胞。为了让血液进入细胞，身体需要胰岛素。监测血糖水平为血糖（BG），单位为mg / dl。有很多事情会影响人们BG超出范围，但就我们的目的而言，我们只是说，注射胰岛素的食物中的碳水化合物和脂肪是最大的因素。因此，我的儿子吃饭，睡觉等，胰岛素输送和衰减由泵用户输入计算和管理，测试是在他的血糖在白天和夜晚上升和下降时完成的。多达一个人想要的，这些都不是简单地插入数字并观察它的工作原理。但结果中的所有这些数据都可用于开采和改善血糖管理。


范围：

数据库将存储与相关营养成分一起食用的常见食物（由用户输入）;膳食营养量将根据用户定义的膳食，推注时间，类型，数量等计算;血糖测试结果，标准和临时基础，泵设置将手动输入或可能从泵或仪表输出的ASCII文件中读取。


目标：

目前常见的做法是记录碳水化合物和推注量。我们的做法是保留典型膳食和推注类型和数量的记录。我的目的只是创建一个我已经能够查看结果的数据的图形显示。我希望数据的图形表示包括估计的活性胰岛素量的曲线。我也希望能够查找类似的饭菜。基于碳水化合物和脂肪总量或比率。我特别不打算进行任何类型的推荐推注。基于之前类似膳食的结果或让DB计算任何用户输入。


我的问题/问题：

我觉得我已经非常接近数学和基本访问表的东西，因为我做了一些Access DB应用程序。问题是我总是使用宏而不是代码，至少没有太多代码。这个项目将要求我使用代码创建一个填写图表所涵盖时间的记录集。这是我不知道的部分。如何创建和使用该记录集以供图表引用 - 以及已存储的其他数据。


现在 - 提出您的问题（重新订购）>

问：你使用的半衰期公式是什么？

答：根据胰岛素制造商，半衰期为81分钟。然而，美国国立卫生研究院也表示Onset在10-20分钟内，峰值在40-50分钟，行动持续时间（DOA）为3-5小时。 DOA也是用户控制的泵设置。它被设定为4小时。

稍后计算。


问：有没有一点胰岛素会降解那么特定的胰岛素注射剂不会以任何明显的方式影响体内胰岛素的含量吗？

答：是的，这可以像基于半衰期的计算寿命一样简单和数量或DOA时间。


问：胰岛素水平及其半衰期是在全球水平还是每次注射的基础上计算的？或者这是不是因为半衰期公式的特点？

答：我正计划在全球范围内


问：怎么做你是否考虑了胰岛素用量的波动？特别是在用餐时间之前，期间或之后。

A：我的计划是使用从0到40的直线计算每次正常推注的胰岛素上升和下降推注后几分钟。使用初始推注和衰减速率，半衰期为81分钟，估计40分钟峰值为40分钟时的胰岛素量。仅基于衰变计算t> 40的胰岛素量。将计算推注有效结束时间。我可能会采用基础量和临时基础量，虽然它们将以不同方式存储，但在推注总和程序中，它们将被计算为额外的小推注量。也许以15分钟为增量给出小时费率的四分之一。


我认为进行推注计算的一种方法是选择活动时间落在图表内的推注记录。然后从最早的有效推注开始时间开始（即使开始在图表窗口之前）并且在图表的结尾或最近的推注结束时间结束时创建每次推注的推注贡献的矩阵。然后将数组分成若干分钟增量（列）以累积推注量。然后该图表将从这个阵列开始工作


问：这个图表看起来是什么样的？

A：基于开始和结束时间它将显示计算活性推注胰岛素（正常和组合）与推注点的标记，显示计算的基础，碳水化合物摄入量。


问：采取常规胰岛素水平测量而不是更安全依靠预测？

答：不可能进行胰岛素水平测量。我唯一的输出可以这么说就是血糖水平。


问：是否没有预先存在的计算器可以解决所有这些以及我可能没有预料到的其他问题？

答：不是我找到的。我发现的一切都是一些基本的图形，它将绘制血糖测试，并注意推注，但没有显示胰岛素量。此外，我没有找到包含膳食信息的糖尿病管理软件。您可以找到有营养和减肥问题的人用餐软件或存储基本数据的糖尿病软件，有一些BG绘图，但没有胰岛素计算。


再次感谢，


Jetson

Thanks for the replies. First off, I understand and appreciate your concerns regarding not being a doctor, and the potential for harm and for medical liability so let me be clear what is the scope and objective.

Back Ground
I''ll start with a bit of type I diabetes background. It''s an autoimmune disorder destroys the insulin secreting cells in the pancreas. In order to get blood sugar into the cells the body needs insuline. Blood sugar levels are monitored as blood glucose (BG) in mg/dl. There are many things that affect a persons BG beyond the scope but for our purposes let''s just say food carbohydrates and fat along insulin injections are the largest factors. So, my son eats, sleeps, etc. and the insulin delivery and decay is calculated and managed by the pump with user input and tests are done as his blood sugar rises and falls during the day and night. As much as one would like, none of this is simply a plug in the number and watch it work. But all of this data from the results is available to mine and improve blood sugar management.

Scope:
The DB will store common foods eaten with nutritional content that''s relative (input by user); nutrition amounts by meal will be calculated based on user defined meals, bolus times, types, amounts, etc.; blood sugar test results, standard and temp basals, pump settings will be manually entered or possibly read from an ASCII file output by the pump or meter.

Objective:
Current common practice is to keep records of carbs and bolus amounts. Our practice has been to keep records of typical meals and bolus types and amounts. My intent is simply to create a graphic display of data I already have to be able to look at results. I wanted that graphic representation of the data to include a curve of estimated active insulin amount. I also want to be able to look up "similar meals" based on carb and fat totals or ratios. I specifically do not plan on putting in any sort of "suggested bolus" based on previous results of similar meals or have the DB calculate any user inputs at all.

My Problem/Question:
I think I''m pretty close with the math and the basic access table stuff as I''ve done some Access DB applications. The issue is that I''ve always used macros and not code, at least not much code. This project will require me to use code to create a recordset of fill in the time that the chart covers. That is the part I don''t know about. How to create and use that recordset for the chart to reference - along with other data stored already.


Now - on to your questions (re-ordered)

Q:What is the half life formula you are using?
A:Per the Insulin manufacturer, the half life is 81 minutes. However, NIH also says Onset is in 10-20 minutes, peak is in 40-50 minutes and Duration of Action(DOA) is 3-5 hours. DOA is also a user controlled pump setting. It''s been set at 4 hours.
More later on the calculations.

Q:Is there a point after which a shot of insulin becomes degraded so much that a particular shot of insulin no longer affects the amount of insulin within the body in any appreciable manner?
A:Yes, this can be as simple as the the calculated life based on the half life and amount or the DOA time.

Q:Is insulin level and its half life calculated on a global level or on a per shot basis? Or does this not matter because of the characteristics of the half life formula?
A: I''m planning on a Global Level

Q:How do you account for fluctuations in insulin usage? Especially around the time of a meal, either before, during, or after.
A:My plan is to calculate the insulin rise and fall for each normal bolus using a straight line from 0 to peak at 40 minutes post bolus. The 40 minute peak will be estimated to be the amount of insulin at 40 minutes using the initial bolus and decay rate with half time of 81 minutes. Insulin amounts for t>40 will be calculated based on the decay alone. A bolus effective end time will be calculated. I will probably take basal amounts and temp basal amounts and although they will be stored differently, in the bolus summation procedure they will be calculated as additional small bolus amounts. Maybe one quarter the hourly rate given at 15 minute increments.

One way I thought to do the bolus calculations is to select bolus records whose active times fall within the chart. Then create a matrix of the bolus contribution of each bolus starting at the earliest active bolus start time (even if the start is before the chart window) and ending at the end of the chart or the end of the latest bolus end time. Then divide the array into a number of minute increment(columns) to accumulate bolus amounts. The chart will then work off of this array

Q:What is this chart supposed to look like?
A: Based on start and end times it will show calculated active bolus insulin (normal and combo) with markers at bolus points, show calculated basal, carb intakes.

Q:Would it not be safer to take regular insulin level measurements rather than relying on a projection?
A:It''s not possible to take insulin level measurements. My only "output" so to speak is blood sugar levels.

Q:Are there no pre-existing calculators that you can use that will have accounted for all this plus other questions that I may not have foreseen?
A:Not that I have found. Everything I have found is some basic graphing that will plot blood sugar tests, and note boluses but nothing that shows insulin amount. Also, I have found no diabetic management software that includes the meal information. You find meal software for people with nutrition and weight loss concerns or diabetes software that stores basic data, has some BG plotting, but no insulin calculations.

Thanks again,

Jetson