Formula to convert daily BG to HbA1c ?

[miahara]

Does anyone have the formula that will allow me to calculate HbA1c from my running average of regular tests using mmol/mol?
I keep a spreadsheet that calculates my running average and would like to include that calculation just to see how my current situation compares with my last HbA1c test.
I have used the on-line calculator from DCUK but would like to have my own one that does the job every time I enter a blood test result.

Dave

 

[Jaylee]

Hi Dave,

The Diaconnect app for logging BGs & carbs (& insulin doses if you do that sort of thing?) will calculate an A1c for you too. Along with average daily carbs & such like...

Hope this helps..

 

[miahara]

Hi Dave,

The Diaconnect app for logging BGs & carbs (& insulin doses if you do that sort of thing?) will calculate an A1c for you too. Along with average daily carbs & such like...

Hope this helps..

Many thanks Jaylee, but I don't use a phone or ipad (well I do but very seldom). What I'm looking for is the formula so I can add it to the Excel spreadsheet I use to calculate running averages pre and post meals and my overall running average and also produces a graph of my progress.

Dave

 

[TimWJ]

Try this thread. http://www.diabetes.co.uk/forum/threads/conversion-formula.20432

 

[CapnGrumpy]

The formula that NightScout uses refers to the formula in this article: https://www.ncbi.nlm.nih.gov/pubmed/18540046

((average glucose in mmol/l x18) + 46.7)/28.7

I found it to match my last HcA1c exactly, but it does get a bs value every 5 minutes.

 

[miahara]

Many thanks @CapnGrumpy !

 

[MLT121]

Hi Miahara, does that formula work as I to want to use it in an excel workbook. Also I am on Glicazade like you plus Metformin

mlt121

 

[HSSS]

This one https://www.diabetes.co.uk/hba1c-to-blood-sugar-level-converter.html

remember gigo. It’s only as good as the number and timing of the bgl readings

 

[Struma]

This one is pretty neat. Simple, no waiting, easily used.

https://www.hba1cnet.com/hba1c-calculator/

Edit: This formula goes both ways. I find it easy to follow.

https://www.glucosetracker.net/blog/how-to-calculate-your-a1c/