Critter Mom
Member Since 2014
First, how are you deciding who is going to get access to this to enter information? The right information for doing these calculations (regardless if the spreadsheet is doing them) can sometimes be hard to come by and a lot of people don't understand what that information is - and sometimes don't even realize it's not the correct information. Every company is different and may present it in different ways. I'm sorry, but from my experience, having someone just go down the page entering numbers and letting the spreadsheet do the rest is an over-simplication -- I've seen far too many people post information, thinking they're doing the right thing, and it's not.
I'm not trying to be discouraging - just saying to be careful if people are going to be counting on this information.
I agree. Editors need to understand the data on nutrition sites in order to enter the correct values upon which to base calculations (myself included). I also think that it would be a good idea for some sort of peer review/accuracy checking (numbers) to be part of maintaining the list. (We all get tired and then out come the howlers!) Indeed, I don't think a spreadsheet like this should even be released to editors until all calculation formulae are thoroughly checked to be correct, and I think that editorial access should only be granted to people who can correctly interpret manufacturer analyses (with a cast iron "If in doubt, leave it out" rule. Better no information than wrong information. I don't know how 'typo' inaccuracies might be caught. There really should be some proofing process in place. If this goes ahead, it would be wise to have a disclaimer (the list is for convenience but double-check manufacturer/label data and consult your vet). Even if the data at time of inclusion is 100% accurate, recipes change.
The little I've gleaned about CRF is that protein, calcium and phosphorus percentages are all important, but I find the way calcium and phosphorus information is presented on websites can be confusing much of the time. That section of the proposed list needs input: I don't have the knowledge.there's far more to it than just worrying about phosphorus levels - I ran a CRF group for a few years and people want to know protein, phosphorus, calcium, even sodium, magnesium, etc. (In fact, only worrying about phosphorus is an over-simplification of treating a CRF cat.)
Another suggestion - I know it's not final - put the information people want to see to the left and leave the raw data off to the right. I'd just be leary leaving the raw data as the first thing you see - people could confuse that. If someone is truly looking for just carbs as a % of calories (and they know it's the colored section) that might be OK. But you also have a percent of carbs that's actually a percent of weight. Will people get that? A lot of people assume if it says "as fed," that's what they want. (It's not labeled as % of weight, and even if it was, a lot of people wouldn't get it, especially math-phobes.)
My preference would be to have data entry on a separate tab altogether and have Google Sheets generate the "reader-friendly" version, similar to the way that the World mmol/L BG spreadsheet automatically presents the information in the mg/dL units familiar to US forum members in a sheet on a separate tab. The main bugbear with this approach is that editors would need to be a little more spreadsheet-savvy to do routine sorting of the list and making sure that they don't knock the formulae out of sync (something that makes me wriggle - a mistake there could turn the sheet to nonsense.).
I'm also a bit leary of putting those labels on the carb levels. Someone is going to take that as advice and that is not a good idea, especially as a catch-all for any cat in any situation. Are you really saying any food above 16% carbs is appropriate in any emergency situation??
I agree that guidelines - if included at all - should be worded with extreme care. Bearing in mind that the spreadsheet is very much a mock-up, I just threw that out as an idea which may or may not be useful. As it is, I've asked on this thread about what ranges FDMB uses to categorise foods as low, medium or high carb. I'm still waiting for an answer to that question. (As a precaution, I've just edited the spreadsheet headers to remove the 'demo' values and text so that if anyone stumbles across this thread there won't be any content in the mock-up that a casual reader might actually take away and use. Grateful for the heads-up!)
ETA:
I've just put "Discussion Draft" banner headings on all the sheets in the file, plus a caveat to browsers that the data's not valid.
Last edited:




...But it seemed a bit too good to be true, so I looked up the label data on the manufacturer's website and sure enough, it's slightly different to the data on the Zooplus website. It's still not bad though at 10.8% calories from carbs.