Public
Edited
Oct 22, 2024
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
Ind_Biomass = 1
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
Generate_Work_Done('Grid',['Solar','Wind','Hydro','Geothermal','Nuclear','Coal','Petroleum','Biomass'])
Insert cell
function calculate_Work_Done(sector,type){
return Math.round(Inits[0][sector][type+'_Usage']*Efficiencies[0][sector][type]/100*Growth_Data[0][sector][type+'_Adoption']*100000)/100000
}
Insert cell
function Generate_Work_Done(sector,ls){
let obj =[]
for (let i = 0; i < ls.length; i++) {
obj.push([ls[i],calculate_Work_Done(sector,ls[i])])
}
if (sector != 'Grid')
obj.push(['Grid',calculate_Grid_Req(sector,ls)])
return Object.fromEntries(obj)
}
Insert cell
function calculate_Grid_Req(sector,ls) {
let grid = Inits[0][sector]['Energy_Usage']*(Efficiencies[0][sector]['Grid'])/100
for (let i = 0; i < ls.length; i++) {
grid -= calculate_Work_Done(sector,ls[i])
}
return Math.round(grid*100000)/100000
}
Insert cell
function get_VRE_byPercentage(params){
//** what is negative net generation
// pull historical data
// net gen(wind)/avg(net gen(wind)) & net gen(solar)/avg(net gen(solar)) = % avg(wind/Solar)
// target % * avg solar + (1-target %) * avg wind
}
Insert cell
function get_Nat_Gas(params) {
//#Total Demand = get CONSUPTION by grid in all sectors *1000/3.41/8760*1000 (convert to GW)
//#Demand less Baseload convert Baseload [Hydro,Geothermal,nuclear,Coal,Biomass,Petroleum] work done to GW generated *1000/3.41/8760*1000
// seasonal vre = (1-seasonal used energy)*(work done solar + work done wind) * 1000/3.41*1000 (convert Quad to GWh)
// daily vre = (seasonal used evergy - daily used evergy)*(work done solar + work done wind) * 1000/3.41*1000 (convert Quad to GWh)
# curtailment = (seasonalVRE + DailyVRE - (LDES+SDES*365) )/10e6*3.41(convertingGWh to Quads)
# used VRE = wind_work + solar_work - curtailment
// Amount of natural gas generation needed is (total demand less baseload power(converted back to Quads)) less used VRE
}
Insert cell
//(((100+Home_Oil)/100)**(_year-2021))*Inits[0]['Residential']['Petroleum_Usage']
Growth_Data[0]['Transit']['Air_Growth']*Growth_Data[0]['Transit']['Aircraft_Biofuel']/100 +
Growth_Data[0]['Transit']['Sea_Growth']*Growth_Data[0]['Transit']['Shipping_Biofuel']/100 +
((Inits[0]['Transit']['Biomass_Usage']*Efficiencies[0]['Transit']['Biomass']/100)/(Inits[0]['Transit']['Land_Transit_Work']-(Inits[0]['Transit']['Grid_Usage']*Efficiencies[0]['Transit']['Grid']/100)-(Inits[0]['Transit']['Natural_Gas_Usage']*Efficiencies[0]['Transit']['Natural_Gas']/100)))*(Growth_Data[0]['Transit']['Land_Growth']-Work_Done_By_Year[0]['Transit']['Natural_Gas']-Work_Done_By_Year[0]['Transit']['Grid'])
Insert cell
calculate_Work_Done('Commercial','Natural_Gas')
Insert cell
function calculate_Transit_Biomass(gas,grid) { return Growth_Data[0]['Transit']['Air_Growth']*Growth_Data[0]['Transit']['Aircraft_Biofuel']/100 +
Growth_Data[0]['Transit']['Sea_Growth'] * Growth_Data[0]['Transit']['Shipping_Biofuel']/100 +
((Inits[0]['Transit']['Biomass_Usage'] * Efficiencies[0]['Transit']['Biomass']/100)/
(Inits[0]['Transit']['Land_Transit_Work'] - (Inits[0]['Transit']['Grid_Usage'] * Efficiencies[0]['Transit']['Grid']/100) -
(Inits[0]['Transit']['Natural_Gas_Usage'] * Efficiencies[0]['Transit']['Natural_Gas']/100))) *
(Growth_Data[0]['Transit']['Land_Growth']-gas-grid)}
Insert cell
function calculate_Transit_Petroleum(bio,gas,grid) {
return Growth_Data[0]['Transit']['Land_Growth'] +
Growth_Data[0]['Transit']['Air_Growth'] +
Growth_Data[0]['Transit']['Sea_Growth'] +
-bio-gas-grid}


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