Extraction of Nutrition Data from Excel to JSON Format

Extracting specified nutrition data from an Excel Spreadsheet "McCance & Widdowson's Composition of Foods Integrated Dataset (CoF IDS)" Deliverable produces a specified JSON file format for use in our nutritional analysis software. See full project details for precise requirements and format). The ideal candidate has knowledge of nutrition science / organic chemistry, with acute attention to detail and correctness. ## Deliverables Convert data from "McCance & Widdowson's Composition of Foods Integrated Dataset (CoF IDS)" Attached file '[login to view URL]' contains documentation and excel spreadsheet. Original source for further reference: [login to view URL]://[login to view URL] To a specified JSON file format for use in nutritional analysis software The deliverable is a JSON file containing an array of 'foods'. Each food has the following attributes: * source -- UKCoF:ID, where ID is the CoF food identifier (ex: "UKCoF:12-346") * name -- The food name * category -- As mapped by table on p3. of [login to view URL] * nutrients -- an array of the nutrient values in this food, expressed as amount per 100g of the food { "foods": [ { "source": "UKCoF:12-346", "name": "Cheese, cheddar, English", "category": "Milk Products and Eggs", "nutrients": [ { "amount": 0.41299999, "id": 410 }, { "amount": 0.074000001, "id": 415 }, { "amount": 0.079999998, "id": 406 } ] } ] Nutrients should be assigned an 'id' from the attached table. Nutrients in CoF not present in this table do not need to be provided. Correctness is of extreme importance! Please email for clarification for any mappings you are unsure about, and document any assumptions made in conversion. nutrientId name unit ---------- ---------------------------------- ------- 203 Protein g 204 Fat g 205 Carbs g 207 Ash g 208 Energy kcal 209 Starch g 210 Sucrose g 211 Glucose g 212 Fructose g 213 Lactose g 214 Maltose g 221 Alcohol g 255 Water g 262 Caffeine mg 263 Theobromine mg 269 Sugars g 287 Galactose g 291 Fiber g 301 Calcium mg 303 Iron mg 304 Magnesium mg 305 Phosphorus mg 306 Potassium mg 307 Sodium mg 309 Zinc mg 312 Copper mg 313 Fluoride ?g 315 Manganese mg 317 Selenium ?g 318 Vitamin A IU 319 Retinol ?g 320 Retinol Activity Equivalent mcg 321 Beta-carotene ?g 322 Alpha-carotene ?g 323 Vitamin E mg 324 Vitamin D IU 325 Vitamin D2 (ergocalciferol) ?g 326 Vitamin D3 (cholecalciferol) ?g 328 Vitamin D (D2 + D3) ?g 334 Beta-cryptoxanthin ?g 337 Lycopene ?g 338 Lutein+Zeaxanthin ?g 341 Beta Tocopherol mg 342 Gamma Tocopherol mg 343 Delta Tocopherol mg 401 Vitamin C mg 404 B1 (Thiamine) mg 405 B2 (Riboflavin) mg 406 B3 (Niacin) mg 410 B5 (Pantothenic Acid) mg 415 B6 (Pyridoxine) mg 417 Folate ?g 418 B12 (Cobalamin) ?g 421 Choline mg 430 Vitamin K ?g 431 Folic acid ?g 454 Betaine mg 501 Tryptophan g 502 Threonine g 503 Isoleucine g 504 Leucine g 505 Lysine g 506 Methionine g 507 Cystine g 508 Phenylalanine g 509 Tyrosine g 510 Valine g 511 Arginine g 512 Histidine g 513 Alanine g 514 Aspartic acid g 515 Glutamic acid g 516 Glycine g 517 Proline g 518 Serine g 521 Hydroxyproline g 601 Cholesterol mg 605 Trans-Fats g 606 Saturated Fat g 636 Phytosterol mg 638 Stigmasterol mg 639 Campesterol mg 641 Beta-sitosterol mg 645 Monounsaturated Fat g 646 Polyunsaturated Fat g 10001 Omega-3 g 10002 Omega-6 g 10003 Chromium ?g 10004 Biotin ?g 10005 Iodine mg