Public
Edited
Jul 7, 2021
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
Insert cell
CBM = (l * h * w) / 1e6
Insert cell
Insert cell
Insert cell
V_t = CBM * q
Insert cell
Insert cell
Insert cell
M_t = m * q
Insert cell
Insert cell
Insert cell
M_v = (l * h * w * q) / 5000
Insert cell
Insert cell
Insert cell
Insert cell
s_cbm = {
let sd = d / 3;
return (sd * sd * sd) / 1e6;
}
Insert cell
d_class = [60, 80, 100, 120, 140, 160]
Insert cell
dw_class = ({
60: 2,
80: 5,
100: 10,
120: 15,
140: 20,
160: 25
})
Insert cell
dw = dw_class[d]
Insert cell
Insert cell
carton_count = s_cbm / CBM
Insert cell
Insert cell
Insert cell
db = FileAttachment("shipping.db").sqlite()
Insert cell
regions = db.query(`SELECT DISTINCT destination FROM takkyubin`)
Insert cell
region_list = regions.map((d) => d.destination)
Insert cell
rates = db.query(
`SELECT size, destination, "${region_from}" FROM takkyubin where size like $1 AND destination like $2`,
[`%${d}%`, `%${region_to}%`]
)
Insert cell
max_shipping_rate = parseInt(rates[0][region_from])
Insert cell
model_item_fee = per_order + per_item * q
Insert cell
model_weight_fee = per_order + M_t * per_kg
Insert cell

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.
Learn more