Insulin chart help

[fbeans]

Is it possible for excel to make an insulin chart that can be changed so I don't have to keep cutting and pasting or completely re-doing the chart in MS word. So I start the chart out as <100=0
101-104=1
105-108=2
109-112=3
113-116=4

It continues on like this for 20 entries per column with 8 columns... I just cant seem to get the programming right. I need to be able to change the start number <100=0 and then have it calculate the ratio, currently 1-3 and and then start the units, =1. I'll check back in a couple of hours.

[MrShorty]

It is unclear to me exactly what you want to do. You have also posted this in the VBA forum, though it is unclear to me if VBA is needed in this case, or if it is merely preferred.

As with any programming problem (whether spreadsheet only or VBA+spreadsheet), the first thing is to identify the input variables. Then describe the relationships between the input variables and other quantities used to calculate the intermediate and final values. Once the final values are calculated, arrange the data in the spreadsheet so it will be easy to chart. Then create and format the chart.

With that outline in place, where are you having trouble automating?

[fbeans]

I don't have any formal excel training and self taught by watching others. Anyway the picture shows what I currently have. I made that chart in ms word and each time I have to adjust my insulin to carb ratio I have to manually change each number. Can excel do this for me just by changing only the first two rows, hit enter and fill out the rest of the rows and columns....?Insulin chart.jpg

[MrShorty]

Excel can do this. It is just a matter of defining the relationship(s) between the first two entries and the rest of the table. It is not clear to me what that relationship should be, though I assume that you know it since you create these tables routinely. Guessing, perhaps something like:

Please Login or Register  to view this content.

Rather than a table that goes across rows, this will create a list that goes down these 3 columns. But this can be converted into the format you have above, or left as a list, depending on other requirements. Left in a list like this, then this will be good candidate for a lookup table that can be used with Excel's lookup functions.

[fbeans]

Ok, thanks.........and it's abundantly clear that I have no idea what I'm doing. I'm not even going to attempt to complete this and just stick to doing it manually with ms word. Sorry I wasted your time.