Recent Posts - DAFNE Online

Mar 2, 2014

HelenP 218 posts

Topic: Questions for HCPs / adjusting insulin for an operation

Just a warning. I was admitted to a medical ward (blood infection) and allowed to run my own insuliin/pump. But after a couple of days of BGs being well under 10, when I had a shower and left the pump on the bed (usual practice) a nurse confiscated it. Took quite some time to get it back. The Dr thought she was doing the right thing and although the pump was written on the original admission notes the administration of the insulin was left to me and not listed on my medications. Conscientious nurse decided that as they were not administering insulin I could not have my pump!

Be aware be very awareâ€¦they are out to get you!!!!!

Additionally I have had five ops and not run into any problems with any of them. I really think you are the expert and if you are told something that you know is nonsense do what you can to challenge it. Best of luck. Helen

Mar 2, 2014

MicheleW 2 posts

Topic: General Discussion / BG drop

At 19.20 (2.5hours after a meal) my BG reading was 7.7 but an hour later it was 2.7 and I hadn't done any exercise in that hour. Any ideas why it dropped so rapidly please?

Feb 28, 2014

yogababe 4 posts

Topic: Questions for HCPs / adjusting insulin for an operation

Hi SueA
Thanks for you reply. Reassuring to know that I'm not the only one confused by the nonsense pre-assessment advice they dish out. I might write to the hospital about it so they can change their stupid handouts.

I think I will stick to my plan then. especially as it worked for you. Did they allow you home the same day or did they make you stay over? Six years ago (pre DAFNE) when I had another operation, they totally panicked and made me stay in for three days until I discharged myself. I feel more confident now and unless there is a real medical need I want to be back home in my bed, not put onto a ward of incontinent, rambling old biddies as I was last time. Not at all conducive to a healthy recovery!!

Will post up how it goes in case it can benefit anyone else

Feb 28, 2014

SueA 9 posts

Topic: Questions for HCPs / adjusting insulin for an operation

Hi yogabebe
I had a minor operation last year that required a full anaesthetic,I was a day patient. Like you I was not filled with confidence after the pre-op assessment.
The experience on the day was much better and I was looked after well, everyone was aware of the diabetes. I did as you have suggested and took my BI as usual with no quick acting as I wasn't eating. Because I am overcautious I did a trial run of fasting a couple before to check my BI, as I was worried about having a hypo on the day and then having to eat and so not being able to have the op. On the day of the op my blood sugars were high before and after.
all the best for the op

Feb 28, 2014

Vickyp 137 posts

Topic: Carbohydrate Counting / reliable metre readings

Thanks for asking Brian, tests were very weird, didn't have hypo during tests...had one almost everydat afterwards for a week or so!! Saw endo on Wednesday and he says that the tests show I am still making insulin, although cpeptide on low end of range, and I don't have antibodies against the insulin...so he thinks the hypos are due to my natural insulin as they occur when i have the pump switched off
Finally the diagnosis is Secondary Diabetes. I am a rare case and hesis using me as a case study to discuss wuth other doctors as they haven't seen anything like it before!

Feb 27, 2014

youone 102 posts

Topic: Carbohydrate Counting / reliable metre readings

Vickyp said:
Yeah I received letter today, but had already phoned Abbott who are sending me 6 boxes of strips. When I tested my strips with control solution they were fine, however my diabetes nurse has told me to go back to optium meter until strips arrive, to be on safe side, and manually put bs into PDM.

That's good news, the information seems to be freely available on the PP sites Facebook etc.
Sorry to be forgetful ,how did your tests go?
Hopefully very well
Brian

Feb 27, 2014

yogababe 4 posts

Topic: Questions for HCPs / adjusting insulin for an operation

Ha ha - quick phone call to my endo. There speaks someone from Australia not the UK. Best I can get is the number for the diabetes nurse at the hospital where I will be having my operation - and that was only after I kicked up a fuss and said I wanted some sensible advice from someone who has knowledge of the condition.
But basically I think I will stick to my original plan of not changing my background insulin (because the operation will definitely send my sugars high) and not taking any quick acting insulin because I won't be eating.

Good tip about the spare insulin - will hide some about my person. I also hate it when you get some hamfisted nurse testing your blood sugars - as I test myself at least four times a day I'm fairly confident I can a) do it myself and b) do it less painfully!

Thanks for the response!

Feb 27, 2014

Vickyp 137 posts

Topic: Carbohydrate Counting / reliable metre readings

Yeah I received letter today, but had already phoned Abbott who are sending me 6 boxes of strips. When I tested my strips with control solution they were fine, however my diabetes nurse has told me to go back to optium meter until strips arrive, to be on safe side, and manually put bs into PDM.

Feb 27, 2014

SueA 9 posts

Topic: General Discussion / Tresiba

Dear Joza
So sorry to hear of your troubles. Sad

I asked about doses as I have just started using it and have to go back to Dafne basics to get the dose right. I have since read that people tend to need less compared to say Lantus. I have done some internet research and it would seem that Tresiba has been approved for use in England and Wales for use with type 1 and type 2 diabetics, but not in Scotland. It seems to help those who experience hypos at night. I found this information on the Diabetes UK website. The consultant who prescribed it for me is an NHS consultant and it was dispensed in the hospital. I have a lot of confidence in this consultant. So I am not sure why you were told that it has not yet been passed for type 1 diabetics.
Before I was referred to a consultant I contacted Diabetes UK as I was being given conflicting information by My GP, I have since changed GPs, Diabetes Uk were really helpful and easy to talk to. I am in my 50's and find it easier to talk than write especially if I am feeling a bit muddled and there are a number of things to consider. Hope things start getting better soon SueA

Feb 27, 2014

joza 4 posts

Topic: General Discussion / Tresiba

Dear SueA,
Not too sure if you meant to contact me or Brian. Anyway, I use 4 units less than Levemire, but think I might have to adjust the Humalog because since being on Tresiba most of my readings are high. Can't imagine what is going on. Last week I spoke to my NHS consultant and asked about Tresiba. He said it had not been passed for Type 1 only Type 2 on multiple injections. Didn't make sense to me, but there was to be a review in June. Tonight I will increase Tresiba by 1 unit to see if it helps. I seem to have got myself into a bit of a mess and might have to go back to London and see the Endocronologist who prescribed it for me. Hhhmmm. Good luck anyway, I am sure it will work wonders for you. Joza

Feb 27, 2014

youone 102 posts

Topic: Carbohydrate Counting / reliable metre readings

Vickyp said:
Thanks youone, hopefully they will figure out what's going on!

I was tweeted on the 20/02/14 that an issue had been raised by Abbott regarding the omnipod meter and test strips
The link is here
thebloodsugarwhisperer.WordPress.com/2014/02/20/omnipod-freestyle-users-test
IWas in touch with my support team today who have sent me a confirmation letter from Abbott which I'll post up when I'm next to a PC

Feb 27, 2014

SueA 9 posts

Topic: General Discussion / Tresiba

I have just, this week, been switched to Tresiba by my consultant. Brian could I ask how do the doses compare to your old BI? Hope that makes sense Thanks SueA

Feb 26, 2014

Rafa 99 posts

Topic: General Discussion / Differing hBa1c results

Warwick said:
Excellent Rafa. Well done. That is a huge improvement and a great step towards avoiding the long term complications.

Many thanks. Gave me a great boost. Just have to keep working at it now. After DAFNE i will certainly never go back to how i treated diabetes before.

Feb 26, 2014

Garry 328 posts

Topic: General Discussion / Possible cure for newly diagnosed type 1s

Antitrypsin.
Another word added to the clutter in my aging brain.
I'll have to ask my youngest son of his thoughts.
Not much good for us old f*rts though.
Thanks again Warwick. You come up with some good info.
Regards
Garry

Feb 26, 2014

Garry 328 posts

Topic: General Discussion / mihaelas

Welcome to the forum mihaela Smile

Anything we can try to help you with?
The data you provide shows an unusual BI scheme. Are you working shifts?
Must admit I try to check ketones every time I'm above a BG of 15.0...but the DAFNE recommendation is:
if consistently over 13.0 mmol/l and check every time >17.0.
Let us know your needs and the great body of support in here can try and assist.
Regards
Garry

Feb 25, 2014

Warwick 423 posts

Topic: General Discussion / Possible cure for newly diagnosed type 1s

http://www.jewishworldreview.com/0214/Type_1_diabetes_cure.php3#.Uw0rBoV0azH

The article mentions a possible (although expensive) cure for type 1 diabetes, although it only seems to be effective for T1s who have been diagnosed for less than 6 months.

Feb 25, 2014

Warwick 423 posts

Topic: Questions for HCPs / adjusting insulin for an operation

Hey Yogababe,

If it was me, I'd be going with what I thought was best rather than some nurse who has much less understanding of how my BGs respond to stress, insulin etc.

You sound like you have a good idea of how to dose yourself beforehand. It sounds like they want you to avoid hypos during the operation, so I suggest that you dose so that it is near impossible to have a hypo during the operation, but in a way that that you won't be too high after the operation. If you are fasting before the operation, then you would only need to worry about your BI, in which case dropping it by a unit or two should avoid any hypos.

I'd also recommend giving spare insulin and spare meter to whoever is going to be your first visitor as a backup. There have been horror stories on these forums of insulin being confiscated by medical staff because they thought that they knew better than we do how to dose us. If you know you have some spare insulin available, then you won't need to worry about that happening.

It could be worth having a quick chat to your endo too as they will have lots of experience in answering this question. Perhaps you could have a quick phone call to them?

Feb 25, 2014

Warwick 423 posts

Topic: General Discussion / Differing hBa1c results

Excellent Rafa. Well done. That is a huge improvement and a great step towards avoiding the long term complications.

Feb 25, 2014

David Rimmer 7 posts

Topic: DAFNE Online Mobile / Android App time picker

Thanks Peter,
I'm with you, I also don't find things difficult to use if I don't use them. Razz

I tend to use the app differently to you, I generally put in all my entries once a day and use it for review and to look for trends.
This is not a big issue, I just thought I'd put it up there in case someone is thinking of updating the look and feel of the app.

Feb 25, 2014

David Rimmer 7 posts

Topic: Site Development / CSV export

This is not necessarily a hard fix. The current dafne stats and graphs must have these readings separated to do the calculations.
I would hope that they are already held separately in the database. It would be bad database design to hold figures to be used in calculations in text fields with special characters.
If they are held in separate fields, it should be easy to add them to the export.

Feb 25, 2014

yogababe 4 posts

Topic: Questions for HCPs / adjusting insulin for an operation

I'm scheduled for a shoulder operation which will require a full anaesthetic. I went for my pre-assessment appointment today and was really annoyed at the ignorant and nonsensical information I was given regarding adjusting my insulin for the operation. The nurse clearly had no real understanding or type 1 diabetes and wasn't listening to what I was saying. I'm on a twice daily Levemir injection and then novorapid when I eat according to the carb count of those meals. I was given a printed sheet that made no sense what so ever and the nurse just picked a random sentence off it that didn't correspond to my insulin regime (which I don't think is that unusual for a type 1 diabetic) and wrote on my form "halve usual dose of novorapid". I have no confidence in this information as it sounds utter nonsense.

Am I correct in assuming that I should continue my basal injections as normal and then when I can eat after the op, give myself my normal dose of novorapid? I anticipate my sugars will run high after the operation so will probably have to make some corrections with either my basal or fast acting insulin - or both. What would you recommend?

Feb 25, 2014

mihaela 7 posts

Topic: General Discussion / mihaelas

weight 59 kg
height 168 cm

Feb 25, 2014

marke 681 posts

Topic: Site Development / CSV export

Hi, Phil is correct I'm not sure it would be simple to process the field as part of the export because of the 'free form' entry of the data. However as you say manipulation in excel is possible. One tip that will stop excel 'interpreting' the file is to rename it so it ends in '.txt' rather than '.csv', why ? well as Phil noticed excel tries to be clever because it thinks it understands csv files, if you rename the file as a txt file and then open it in excel you can then tell it to interpret the file data as csv, however it also allows you to define what is in each field i.e tell it the QA is a text field NOT a date field or a value field. Once you have the QA field as text there are a number of text manipulation functions that allow you to split the data assuming you have been consistent in using no spaces between the '-' and '+' or have always used spaces between them. I will have a think about the best formulas to use in excel and post them here if I can come up with something that works Smile

Feb 25, 2014

Rafa 99 posts

Topic: General Discussion / Differing hBa1c results

I had my first clinic appointment this morning since doing DAFNE last July and my HB1AC is down from 84 to 55.

Feb 24, 2014

Phil Maskell 194 posts

Topic: Site Development / CSV export

Doubt this is any easy fix in the export as I'm guessing due to the nature of corrections QA/BI/CP will just be text/String/VARCHAR in the system.

It would need a bit of parsing / regex to extract the correction, but as you could type anything what would you parse on? I know the norm is to put 12+1 or 12-1, but what if someone put 12 - 1 or hit a typo and put 12=1 (- and = are next to each other, = and + same key).

I'm guessing a whiz with excel might have more joy?

EDIT: Just done a quite export of my results to check what I said wasn't rubbish, excel trys to be too clever which doesn't help, I had a QA of 4-1, it had this as 04-Jan which confused me for a bit!

Phil

Mar 2, 2014 HelenP 218 posts	Topic: Questions for HCPs / adjusting insulin for an operation Just a warning. I was admitted to a medical ward (blood infection) and allowed to run my own insuliin/pump. But after a couple of days of BGs being well under 10, when I had a shower and left the pump on the bed (usual practice) a nurse confiscated it. Took quite some time to get it back. The Dr thought she was doing the right thing and although the pump was written on the original admission notes the administration of the insulin was left to me and not listed on my medications. Conscientious nurse decided that as they were not administering insulin I could not have my pump! Be aware be very awareâ€¦they are out to get you!!!!! Additionally I have had five ops and not run into any problems with any of them. I really think you are the expert and if you are told something that you know is nonsense do what you can to challenge it. Best of luck. Helen

Mar 2, 2014 MicheleW 2 posts	Topic: General Discussion / BG drop At 19.20 (2.5hours after a meal) my BG reading was 7.7 but an hour later it was 2.7 and I hadn't done any exercise in that hour. Any ideas why it dropped so rapidly please?

Feb 28, 2014 yogababe 4 posts	Topic: Questions for HCPs / adjusting insulin for an operation Hi SueA Thanks for you reply. Reassuring to know that I'm not the only one confused by the nonsense pre-assessment advice they dish out. I might write to the hospital about it so they can change their stupid handouts. I think I will stick to my plan then. especially as it worked for you. Did they allow you home the same day or did they make you stay over? Six years ago (pre DAFNE) when I had another operation, they totally panicked and made me stay in for three days until I discharged myself. I feel more confident now and unless there is a real medical need I want to be back home in my bed, not put onto a ward of incontinent, rambling old biddies as I was last time. Not at all conducive to a healthy recovery!! Will post up how it goes in case it can benefit anyone else

Feb 28, 2014 SueA 9 posts	Topic: Questions for HCPs / adjusting insulin for an operation Hi yogabebe I had a minor operation last year that required a full anaesthetic,I was a day patient. Like you I was not filled with confidence after the pre-op assessment. The experience on the day was much better and I was looked after well, everyone was aware of the diabetes. I did as you have suggested and took my BI as usual with no quick acting as I wasn't eating. Because I am overcautious I did a trial run of fasting a couple before to check my BI, as I was worried about having a hypo on the day and then having to eat and so not being able to have the op. On the day of the op my blood sugars were high before and after. all the best for the op

Feb 28, 2014 Vickyp 137 posts	Topic: Carbohydrate Counting / reliable metre readings Thanks for asking Brian, tests were very weird, didn't have hypo during tests...had one almost everydat afterwards for a week or so!! Saw endo on Wednesday and he says that the tests show I am still making insulin, although cpeptide on low end of range, and I don't have antibodies against the insulin...so he thinks the hypos are due to my natural insulin as they occur when i have the pump switched off Finally the diagnosis is Secondary Diabetes. I am a rare case and hesis using me as a case study to discuss wuth other doctors as they haven't seen anything like it before!

Feb 27, 2014 youone 102 posts	Topic: Carbohydrate Counting / reliable metre readings Vickyp said: Yeah I received letter today, but had already phoned Abbott who are sending me 6 boxes of strips. When I tested my strips with control solution they were fine, however my diabetes nurse has told me to go back to optium meter until strips arrive, to be on safe side, and manually put bs into PDM. That's good news, the information seems to be freely available on the PP sites Facebook etc. Sorry to be forgetful ,how did your tests go? Hopefully very well Brian

Feb 27, 2014 yogababe 4 posts	Topic: Questions for HCPs / adjusting insulin for an operation Ha ha - quick phone call to my endo. There speaks someone from Australia not the UK. Best I can get is the number for the diabetes nurse at the hospital where I will be having my operation - and that was only after I kicked up a fuss and said I wanted some sensible advice from someone who has knowledge of the condition. But basically I think I will stick to my original plan of not changing my background insulin (because the operation will definitely send my sugars high) and not taking any quick acting insulin because I won't be eating. Good tip about the spare insulin - will hide some about my person. I also hate it when you get some hamfisted nurse testing your blood sugars - as I test myself at least four times a day I'm fairly confident I can a) do it myself and b) do it less painfully! Thanks for the response!

Feb 27, 2014 Vickyp 137 posts	Topic: Carbohydrate Counting / reliable metre readings Yeah I received letter today, but had already phoned Abbott who are sending me 6 boxes of strips. When I tested my strips with control solution they were fine, however my diabetes nurse has told me to go back to optium meter until strips arrive, to be on safe side, and manually put bs into PDM.

Feb 27, 2014 SueA 9 posts	Topic: General Discussion / Tresiba Dear Joza So sorry to hear of your troubles. I asked about doses as I have just started using it and have to go back to Dafne basics to get the dose right. I have since read that people tend to need less compared to say Lantus. I have done some internet research and it would seem that Tresiba has been approved for use in England and Wales for use with type 1 and type 2 diabetics, but not in Scotland. It seems to help those who experience hypos at night. I found this information on the Diabetes UK website. The consultant who prescribed it for me is an NHS consultant and it was dispensed in the hospital. I have a lot of confidence in this consultant. So I am not sure why you were told that it has not yet been passed for type 1 diabetics. Before I was referred to a consultant I contacted Diabetes UK as I was being given conflicting information by My GP, I have since changed GPs, Diabetes Uk were really helpful and easy to talk to. I am in my 50's and find it easier to talk than write especially if I am feeling a bit muddled and there are a number of things to consider. Hope things start getting better soon SueA

Feb 27, 2014 joza 4 posts	Topic: General Discussion / Tresiba Dear SueA, Not too sure if you meant to contact me or Brian. Anyway, I use 4 units less than Levemire, but think I might have to adjust the Humalog because since being on Tresiba most of my readings are high. Can't imagine what is going on. Last week I spoke to my NHS consultant and asked about Tresiba. He said it had not been passed for Type 1 only Type 2 on multiple injections. Didn't make sense to me, but there was to be a review in June. Tonight I will increase Tresiba by 1 unit to see if it helps. I seem to have got myself into a bit of a mess and might have to go back to London and see the Endocronologist who prescribed it for me. Hhhmmm. Good luck anyway, I am sure it will work wonders for you. Joza

Feb 27, 2014 youone 102 posts	Topic: Carbohydrate Counting / reliable metre readings Vickyp said: Thanks youone, hopefully they will figure out what's going on! I was tweeted on the 20/02/14 that an issue had been raised by Abbott regarding the omnipod meter and test strips The link is here thebloodsugarwhisperer.WordPress.com/2014/02/20/omnipod-freestyle-users-test IWas in touch with my support team today who have sent me a confirmation letter from Abbott which I'll post up when I'm next to a PC

Feb 27, 2014 SueA 9 posts	Topic: General Discussion / Tresiba I have just, this week, been switched to Tresiba by my consultant. Brian could I ask how do the doses compare to your old BI? Hope that makes sense Thanks SueA

Feb 26, 2014 Rafa 99 posts	Topic: General Discussion / Differing hBa1c results Warwick said: Excellent Rafa. Well done. That is a huge improvement and a great step towards avoiding the long term complications. Many thanks. Gave me a great boost. Just have to keep working at it now. After DAFNE i will certainly never go back to how i treated diabetes before.

Feb 26, 2014 Garry 328 posts	Topic: General Discussion / Possible cure for newly diagnosed type 1s Antitrypsin. Another word added to the clutter in my aging brain. I'll have to ask my youngest son of his thoughts. Not much good for us old f*rts though. Thanks again Warwick. You come up with some good info. Regards Garry

Feb 26, 2014 Garry 328 posts	Topic: General Discussion / mihaelas Welcome to the forum mihaela Anything we can try to help you with? The data you provide shows an unusual BI scheme. Are you working shifts? Must admit I try to check ketones every time I'm above a BG of 15.0...but the DAFNE recommendation is: if consistently over 13.0 mmol/l and check every time >17.0. Let us know your needs and the great body of support in here can try and assist. Regards Garry

Feb 25, 2014 Warwick 423 posts	Topic: General Discussion / Possible cure for newly diagnosed type 1s http://www.jewishworldreview.com/0214/Type_1_diabetes_cure.php3#.Uw0rBoV0azH The article mentions a possible (although expensive) cure for type 1 diabetes, although it only seems to be effective for T1s who have been diagnosed for less than 6 months.

Feb 25, 2014 Warwick 423 posts	Topic: Questions for HCPs / adjusting insulin for an operation Hey Yogababe, If it was me, I'd be going with what I thought was best rather than some nurse who has much less understanding of how my BGs respond to stress, insulin etc. You sound like you have a good idea of how to dose yourself beforehand. It sounds like they want you to avoid hypos during the operation, so I suggest that you dose so that it is near impossible to have a hypo during the operation, but in a way that that you won't be too high after the operation. If you are fasting before the operation, then you would only need to worry about your BI, in which case dropping it by a unit or two should avoid any hypos. I'd also recommend giving spare insulin and spare meter to whoever is going to be your first visitor as a backup. There have been horror stories on these forums of insulin being confiscated by medical staff because they thought that they knew better than we do how to dose us. If you know you have some spare insulin available, then you won't need to worry about that happening. It could be worth having a quick chat to your endo too as they will have lots of experience in answering this question. Perhaps you could have a quick phone call to them?

Feb 25, 2014 Warwick 423 posts	Topic: General Discussion / Differing hBa1c results Excellent Rafa. Well done. That is a huge improvement and a great step towards avoiding the long term complications.

Feb 25, 2014 David Rimmer 7 posts	Topic: DAFNE Online Mobile / Android App time picker Thanks Peter, I'm with you, I also don't find things difficult to use if I don't use them. I tend to use the app differently to you, I generally put in all my entries once a day and use it for review and to look for trends. This is not a big issue, I just thought I'd put it up there in case someone is thinking of updating the look and feel of the app.

Feb 25, 2014 David Rimmer 7 posts	Topic: Site Development / CSV export This is not necessarily a hard fix. The current dafne stats and graphs must have these readings separated to do the calculations. I would hope that they are already held separately in the database. It would be bad database design to hold figures to be used in calculations in text fields with special characters. If they are held in separate fields, it should be easy to add them to the export.

Feb 25, 2014 yogababe 4 posts	Topic: Questions for HCPs / adjusting insulin for an operation I'm scheduled for a shoulder operation which will require a full anaesthetic. I went for my pre-assessment appointment today and was really annoyed at the ignorant and nonsensical information I was given regarding adjusting my insulin for the operation. The nurse clearly had no real understanding or type 1 diabetes and wasn't listening to what I was saying. I'm on a twice daily Levemir injection and then novorapid when I eat according to the carb count of those meals. I was given a printed sheet that made no sense what so ever and the nurse just picked a random sentence off it that didn't correspond to my insulin regime (which I don't think is that unusual for a type 1 diabetic) and wrote on my form "halve usual dose of novorapid". I have no confidence in this information as it sounds utter nonsense. Am I correct in assuming that I should continue my basal injections as normal and then when I can eat after the op, give myself my normal dose of novorapid? I anticipate my sugars will run high after the operation so will probably have to make some corrections with either my basal or fast acting insulin - or both. What would you recommend?

Feb 25, 2014 mihaela 7 posts	Topic: General Discussion / mihaelas weight 59 kg height 168 cm

Feb 25, 2014 marke 681 posts	Topic: Site Development / CSV export Hi, Phil is correct I'm not sure it would be simple to process the field as part of the export because of the 'free form' entry of the data. However as you say manipulation in excel is possible. One tip that will stop excel 'interpreting' the file is to rename it so it ends in '.txt' rather than '.csv', why ? well as Phil noticed excel tries to be clever because it thinks it understands csv files, if you rename the file as a txt file and then open it in excel you can then tell it to interpret the file data as csv, however it also allows you to define what is in each field i.e tell it the QA is a text field NOT a date field or a value field. Once you have the QA field as text there are a number of text manipulation functions that allow you to split the data assuming you have been consistent in using no spaces between the '-' and '+' or have always used spaces between them. I will have a think about the best formulas to use in excel and post them here if I can come up with something that works

Feb 25, 2014 Rafa 99 posts	Topic: General Discussion / Differing hBa1c results I had my first clinic appointment this morning since doing DAFNE last July and my HB1AC is down from 84 to 55.

Feb 24, 2014 Phil Maskell 194 posts	Topic: Site Development / CSV export Doubt this is any easy fix in the export as I'm guessing due to the nature of corrections QA/BI/CP will just be text/String/VARCHAR in the system. It would need a bit of parsing / regex to extract the correction, but as you could type anything what would you parse on? I know the norm is to put 12+1 or 12-1, but what if someone put 12 - 1 or hit a typo and put 12=1 (- and = are next to each other, = and + same key). I'm guessing a whiz with excel might have more joy? EDIT: Just done a quite export of my results to check what I said wasn't rubbish, excel trys to be too clever which doesn't help, I had a QA of 4-1, it had this as 04-Jan which confused me for a bit! Phil