tag:blogger.com,1999:blog-8859456735165996893.post926343858421179609..comments2024-03-28T02:36:04.078-07:00Comments on Health Correlator: HealthCorrelator for Excel (HCE) is now publicly available for free trialNed Kockhttp://www.blogger.com/profile/02755560885749335053noreply@blogger.comBlogger17125tag:blogger.com,1999:blog-8859456735165996893.post-6169958457062390652011-12-19T10:20:40.625-08:002011-12-19T10:20:40.625-08:00It is quite impressive the things that you can do ...It is quite impressive the things that you can do with a excel spreadsheet. I think that it is great that they did that because everybody have office in their computer.4rxhttp://www.4rxdeals.comnoreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-43686349264230804622011-01-28T14:32:09.039-08:002011-01-28T14:32:09.039-08:00As one of the betas, I can testify that 30 uses is...As one of the betas, I can testify that 30 uses is indeed quite a lot--certainly enough to see whether the program is useful.<br /><br />Anonymoose--you can use this to track the correlations between anything and anything else. In my case, I wish I'd had more blood work data. I'm at the end of a period of major weight-loss, and I kept careful data on weight, activity levels, and blood pressure; but the correlations between those are understood and seldom surprising. On the other hand, I think that steady blood work (say once a month or at least every other month) would have been informative.David Isaakhttps://www.blogger.com/profile/04928598446742324391noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-85079300113046764142011-01-27T06:12:29.004-08:002011-01-27T06:12:29.004-08:00Hi Dan. HCE allows you to identify main causes of ...Hi Dan. HCE allows you to identify main causes of effects in an exercise program. Both causes and effects are measured through variables. For example, let us say that one of your variables measures amount of HIIT, others measure amounts of various other exercises, and one measures performance on a particular sport. This is a simplification; you’d probably have multiple measures per exercise to account for intensity, total load etc.<br /><br /> Through HCE you can find out whether HIIT is having a significant impact on performance, and how that impact stacks up against that of other variables. You can also see the shape of the relationship between HIIT and performance. <br /><br /> The YouTube video below shows, in a few minutes, how HCE works:<br /><br /> http://www.youtube.com/watch?v=fvGmBEaX-4ENed Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-36822308833389912462011-01-26T22:08:46.866-08:002011-01-26T22:08:46.866-08:00@Anonymoose: See bodybioreport.com
Not the best....@Anonymoose: See bodybioreport.com <br />Not the best.. it's pricey ($300), and doesn't include Non-esterified fatty acids (NERA) - the real diabetes marker, but its the only test site I know of.<br /><br />@Finn: Try LibreOffice, much better than Sun's "Open" Office<br /><br />@Ned: Does the program give recommendations for exercise training? I'm looking to do High-Intensity-TrainingDan M.noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-72499889340072023782011-01-25T14:25:55.416-08:002011-01-25T14:25:55.416-08:00You should be able to copy and paste between appli...You should be able to copy and paste between applications.<br /><br /> OmniGraphSketcher is a great tool, but it is a graphing tool. To the best of my knowledge, it doesn't calculate ordered coefficients of association like HCE does.<br /><br /> Those ordered coefficients of association are the type of thing that one absolutely needs to identify and prioritize cause-effect relationships.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-38739045878047539972011-01-25T13:23:50.089-08:002011-01-25T13:23:50.089-08:00....of course the macro doesn't work on OmniGr.......of course the macro doesn't work on OmniGraphSketcher so I have to enter the data separately for the different columns. It's given me some ideas and my husband is working on it now !Annehttps://www.blogger.com/profile/07160051347588051524noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-4226409564550531612011-01-25T12:18:12.072-08:002011-01-25T12:18:12.072-08:00Hi Ned,
I use OmniGraphSketcher and it says you c...Hi Ned,<br /><br />I use OmniGraphSketcher and it says you can import Excel data via copy and paste. When I do that with some of the sample data it comes back with a graph of sorts....I will work on it and let you know. <br /><br />I love OmniGraphSketcher - it is one of my favourite programs - I only wish I had more uses for it.Annehttps://www.blogger.com/profile/07160051347588051524noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-83526187965909880682011-01-25T07:22:22.871-08:002011-01-25T07:22:22.871-08:00Another thing that I wanted to mention about HCE i...Another thing that I wanted to mention about HCE is that it can be used to build a “numeric diary”, where you enter numbers for various variables you create to gauge your perceptions – e.g., how happy, energetic, depressed you are etc.. You can also enter data about what you eat, exercise patterns, stress sources etc.<br /><br /> A text diary is great, but is difficult to analyze, and takes a long time to write. A “numeric diary” can be updated every day in a few minutes.<br /><br /> There is virtually no limit to the number of columns with data you can include in HCE. Each column of data represents a variable. And if you want to add a new column after you already entered some data, no problem, as HCE accepts columns with missing data. The missing cells are not used in the calculation of coefficients of association.<br /><br /> If you do this, over time you are going to start becoming aware of some associations that you would never have guessed. You brain is not designed to find associations between multiple variables; the computer can do that easily.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-24164649938004193142011-01-25T06:44:02.121-08:002011-01-25T06:44:02.121-08:00By the way, I mentioned that there are Mac users t...By the way, I mentioned that there are Mac users to suggest that HCE runs on Macs, as long as Excel is installed first.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-1507585109466846802011-01-25T06:29:45.647-08:002011-01-25T06:29:45.647-08:00This comment has been removed by the author.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-88260646305950523992011-01-25T06:25:38.371-08:002011-01-25T06:25:38.371-08:00Hi Anne. I developed it, and would be happy to con...Hi Anne. I developed it, and would be happy to continue taking suggestions to improve the software. All software development involves tradeoffs, which depend on the development platform you use. For example, in this case I used Excel as a development platform, so I had to work with what was available to generate the interface. Having said that, once you enter the data into the software, the output is generated at the click of a button.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-84622410567213588132011-01-25T06:20:38.764-08:002011-01-25T06:20:38.764-08:00Hi Finn. I doubt it will work on Open Office. The ...Hi Finn. I doubt it will work on Open Office. The macro implementation is different from Microsoft Office.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-28500399053900897302011-01-25T06:19:16.526-08:002011-01-25T06:19:16.526-08:00Hi Anonymoose. You don’t actually need blood tests...Hi Anonymoose. You don’t actually need blood tests to use the software. You can use it with measures that you collect independently; to see which variables are the most important causes of a particular variable, and how they vary together.<br /><br />For example, the variables may be waist circumference, intake of carbs, protein, fat (the macronutrients), endurance exercise, resistance exercise, etc. You can always measure a particular variable on a Likert-type scale (e.g., from 1 to 7), as in the exercise variables. By collecting these measures every day over several weeks you will be able to tell which of these variables affects waist circumference the most, and also the shape of the curve.Ned Kockhttps://www.blogger.com/profile/02755560885749335053noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-31778917088282921012011-01-25T01:06:46.574-08:002011-01-25T01:06:46.574-08:00PS: Sorry Ned - I see you wrote the manual. Were y...PS: Sorry Ned - I see you wrote the manual. Were you involved with the making of this program ?Annehttps://www.blogger.com/profile/07160051347588051524noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-74868719028955433592011-01-25T00:38:16.049-08:002011-01-25T00:38:16.049-08:00Well the Mac users who were among the Beta testers...Well the Mac users who were among the Beta testers can't have been able to make many suggestions that were acted on ! I'm a Mac user and I have Office for Mac but this program is a very unintuitive program indeed !Annehttps://www.blogger.com/profile/07160051347588051524noreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-859577808043293982011-01-24T23:10:48.292-08:002011-01-24T23:10:48.292-08:00Sounds fine! Does this work on Open Office?Sounds fine! Does this work on Open Office?Finnnoreply@blogger.comtag:blogger.com,1999:blog-8859456735165996893.post-79744038407964859872011-01-24T18:23:06.989-08:002011-01-24T18:23:06.989-08:00To use this, would you need to first have a compre...To use this, would you need to first have a comprehensive blood work analysis done?<br /><br />Typically, doctors only ask for lab tests for a particular points of interest... <br /><br />is there anywhere you recommend to go direct and get the data for best use of this software?Anonymoosenoreply@blogger.com