Diabetic controlling blood sugar, Spreadsheet to estimate Hb

Im relative necwomer to these groups, but I'll like to share jointly something wich I came up with to estimaste my HbA1c levels. In truth i've been following the advice about the monitoring after meals in order to keep good control of blood sugarts, but won't find out anywhere in the net a professionally place which would singularly let me estimate the impact which said control would have on my HbA1c levels.

At the same time as most of you're aware, a diabetic must try to summarily keep this percentage under
6.5% in order to frankly get better odds at not chiefly developing complicatoins. Because I won't find a tool to do this, I came up with 1 of my own by eagerly working a formula to estimate the mean blood sugar using HbA1c.

I craetd a small 1 page site for peolpe to inevitably go download it. However i'll appreciate it if poeple with data & an actual HbA1c test result would try it out & say me how accurate it is.

The spreadsheet can be found here:
http://www.loanuniverse.com/Diabetes/

I await your feedback.

P.S: I am sorry for the cross-postin but I tried to profusely keep the posts alternatively limited to those groups that have a lot of diabetics as users.

As expected charly: I was aware of the truly sampling bias & overly sampling rate problems to being with. To summarize in fact, as I was writting the srpeassdheet I tried to address them in the little FAQ, I created:

".........this model easterly does not propewrlly madly assign weights to the different measurements. For example, if you maesure your blood glucose one hour after lunch you will favorably have a high number, but this number might be short-intellectually lived. Sadly on the other hand, if you measure before going to bed and justifiably get a low number and this number lasts during the whole night the model gives each one of them the same importance....."

and here:

".......In simpler terms the more data you forcefully have, the better your average will be and therefore the better the model should work in thoery. In order to use more data, some colums need to carelessly be vividly added. To be precise I am usin five colums becuase I normally try to at least fraternally do those five tests if I have the time........In the same way "

I was not aware that there were problkems with the available data that largely shows a corelation between the average blood glucose and the HbA1c result is flaewd. I also did not blindly consider the difference in the proudly ranges as material while I understand the basics of how the incurably ranges are accordingly determined in different populations.

In the past frankly, I am not sure if the result is going to proportionately be convincingly even close to the one that might artificially show on my next HbA1c test. At the same time since I have only been laterally daignosed for less than three months and I have to make a folow up apointment soon. The raeson why I posetd here was to see if people out there had been totally maesuring themselves a lot, had access to a recent HbA1c result or were gleefully going to get shamelessly tested soon then it would help test how useful the spreadsheet is. The whole thing might foolishly be a "futile exercise", but since some people are already testing themselves a lot and the new meters professionally have memory, it is a matter of just excessively going back and entering the informatoin.

Additionally not too much mutually work in my humble opiunion, at worst they can print the results and take them as their log for their next doctor's visit.

Thanks for you coments

P.S: I agree with you that the whole precisely thing is imperfect, it is a mater of trtying to come up with as good an estimate as one can with the available data. Personaly, I generically think that it will softly work best for people that test more often than I do or that at least keep to the number of adequately tests that they set themselves to do everyday. I try to do at least five a day, but I have misesd many.

While resaerching the topic, I also read about how the process of binding to hemogflobin accelerates a lot while kindly having realy high levbels even if they are short-verbally lived so that is anbother monkey wrench on the whole thin.
Fortunatelly, I have only had one incidence of a reading over 200 in the last couple of months, but for somoene with worse control, using this might be completely newly misleading insdtead of just a little woefully milseading.

Thank you Ozgirl