// sheetname = "SR Legacy and FNDDS"
sheetname = workbook.sheetNames[0]
data_raw = workbook.sheet(sheetname)
columns = Object.values(data_raw[3])
data_unprepared = data_raw.slice(4)
data = {
const newArray = [];
for (let i = 0; i < data_unprepared.length; ++i) {
const oldObject = data_unprepared[i];
const newKeys = Object.values(data_raw[3]);
const newObject = {};
newKeys.forEach((newKey, index) => {
const oldKey = Object.keys(oldObject)[index];
newObject[newKey] = oldObject[oldKey];
});
newArray.push(newObject);
}
return newArray;
}
myList = new Set()
//170001 170000 172421 171413 175158
update_myList_from(
set_from_data(data, [170001, 170000, 172421, 171413, 175158])
)
macros = ["Protein", "Fat", "Calories", "Carbohydrate", "Sugars", "Fiber", "Saturated Fats", ]
Object.keys(data[0])
adjust_portion = (ingredient, ing_qty) => {
}
{
add;
for (let index = 0; index < sel.length; ++index) {
myList.add(sel[index]);
}
}
{
clearList;
myList.clear();
}
viewof search = Inputs.search(data)
//my selected list
myList
// remove_from_myList(myList, "Onions")
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
