-
Notifications
You must be signed in to change notification settings - Fork 0
/
runFacilitySupplyCurves.ts
219 lines (190 loc) · 7.26 KB
/
runFacilitySupplyCurves.ts
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
import dotenv from 'dotenv';
import fs from 'fs';
import _fetch from 'isomorphic-fetch';
import knex from 'knex';
import OSRM from '@project-osrm/osrm';
import pg from 'pg';
import { RequestByDistanceParams } from 'models/types';
import { processClustersByDistance } from './processDistance';
// Run all supply curves for a given facility and treatment (one per system)
const PG_DECIMAL_OID = 1700;
pg.types.setTypeParser(PG_DECIMAL_OID, parseFloat);
dotenv.config();
console.log('connecting to db', process.env.DB_HOST);
// https://knexjs.org/
const db = knex({
client: 'pg',
debug: false,
connection: {
host: process.env.DB_HOST,
user: process.env.DB_USER,
password: process.env.DB_PASS,
database: process.env.DB_NAME,
port: Number(process.env.DB_PORT),
},
});
console.log('connected to db. connecting to osrm...');
const osrm = new (OSRM as any)({
path: process.env.OSRM || './data/california-latest.osrm',
mmap_memory: false,
});
console.log('connected to osrm');
const run = async () => {
const facilityLat = process.env.FACILITY_LAT
? parseFloat(process.env.FACILITY_LAT)
: 39.710361488650186;
const facilityLng = process.env.FACILITY_LNG
? parseFloat(process.env.FACILITY_LNG)
: -120.21618958848077;
const facilityName = process.env.FACILITY_NAME || 'DefaultFacility';
const bandsInMiles = [0, 10, 20, 30, 40, 50, 60, 70, 80, 90, 100];
const treatments = [1, 2, 3, 4, 5, 6, 7, 8, 9, 10];
const systems = [
'Ground-Based Mech WT',
'Ground-Based Manual WT',
'Ground-Based Manual Log',
'Ground-Based CTL',
'Cable Manual WT/Log',
'Cable Manual WT',
'Cable Manual Log',
'Cable CTL',
'Helicopter Manual Log',
'Helicopter CTL',
];
// nested loop over all systems and treatments
for (const treatmentId of treatments) {
for (const harvestSystem of systems) {
console.log(`running for facility ${facilityName} at (${facilityLat}, ${facilityLng})`);
console.log(`processing ${treatmentId}: ${harvestSystem}`);
if (harvestSystem === 'Ground-Based CTL') {
console.log('skipping Ground-Based CTL because of move-in performance issues');
continue;
}
// determine csv file name and only run if file does not already exist
let fileName = `${facilityName}_${treatmentId}_${harvestSystem}`;
// replace non-alphanumeric characters with underscores
fileName = fileName.replace(/[^a-z0-9]/gi, '_');
const fileWithDirectory = (process.env.CSV_DIR || './data/results/') + fileName + '.csv';
// continue if filename is present on disk
if (fs.existsSync(fileWithDirectory)) {
console.log(
`skipping ${treatmentId}-${harvestSystem} because file already exists for this facility`
);
continue;
}
const allResults = [];
// keep running totals across all bands
let runningTotalDryFeedstock = 0;
let runningTotalCost = 0;
// TODO: get rid of cash flow stuff and any other stuff that we don't need
const params: RequestByDistanceParams = {
facilityLat: facilityLat,
facilityLng: facilityLng,
system: harvestSystem,
treatmentid: treatmentId,
dieselFuelPrice: 2.24,
firstYear: 2016,
year: 2016,
minRadiusInMeters: 0,
maxRadiusInMeters: 0,
teaModel: 'GPO',
annualGeneration: 186150000,
moistureContent: 50,
cashFlow: {
Year: 3,
EquityRecovery: 5307860.705204948,
EquityInterest: 4878958.389822159,
EquityPrincipalPaid: 428902.3153827889,
EquityPrincipalRemaining: 32097486.950098272,
DebtRecovery: 7997857.199581821,
DebtInterest: 4674582.338474968,
DebtPrincipalPaid: 3323274.861106853,
DebtPrincipalRemaining: 90168371.9083925,
NonFuelExpenses: 6046157.799999999,
DebtReserve: 0,
Depreciation: 6644731.9140524315,
IncomeCapacity: 4150000,
InterestOnDebtReserve: 399892.85997909104,
TaxesWoCredit: 1342913.2763062133,
TaxCredit: 1746453.5293499993,
Taxes: 162218.89510713916,
EnergyRevenueRequired: 23242211.267465867,
BiomassFuelCost: 8278009.527551053,
LcfsCreditRevenue: 0,
},
costOfEquity: 15,
generalInflation: 2.1,
carbonCreditPrice: 196,
energyEconomyRatio: 1,
includeCarbonCredit: false,
wageFaller: 35.13, // CA FallBuckWage May 2020
wageOther: 22.07, // CA AllOthersWage May 2020
laborBenefits: 35, // Assume a nationwide average of 35% for benefits and other payroll costs
ppiCurrent: 284.7, // Oct 2021
residueRecovFracWT: 80, // FRCS default 80%
residueRecovFracCTL: 50, // FRCS default 50%
wageTruckDriver: 24.71, // Hourly mean wage for tractor-trailer truck drivers May 2020
driverBenefits: 67,
oilCost: 0.35,
};
for (let i = 1; i < bandsInMiles.length; i++) {
const milesToMeters = 1609.34;
const minBandInMeters = bandsInMiles[i - 1] * milesToMeters;
const maxBandInMeters = bandsInMiles[i] * milesToMeters;
// params just for this run
const runParams = {
...params,
minRadiusInMeters: minBandInMeters,
maxRadiusInMeters: maxBandInMeters,
};
const distanceResult = await processClustersByDistance(
db,
osrm,
minBandInMeters,
maxBandInMeters,
runParams,
runParams.year
);
console.log(
`distance: ${runParams.minRadiusInMeters} -> ${runParams.maxRadiusInMeters}, band ${
bandsInMiles[i - 1]
}, # of clusters: ${distanceResult.clusterNumbers.length}`
);
const totalCostPerDryTon =
(distanceResult.totalHarvestCost +
distanceResult.totalTransportationCost +
distanceResult.totalMoveInCost) /
distanceResult.totalDryFeedstock;
const totalCost = totalCostPerDryTon * distanceResult.totalDryFeedstock;
runningTotalCost += totalCost || 0;
runningTotalDryFeedstock += distanceResult.totalDryFeedstock || 0;
const importantData = {
system: params.system,
treatment: params.treatmentid,
teaModel: params.teaModel,
band: bandsInMiles[i],
totalDryFeedstock: distanceResult.totalDryFeedstock || 0,
totalCost: totalCost || 0,
totalCostPerDryTon: totalCostPerDryTon || 0,
runningTotalDryFeedstock,
runningTotalCost,
};
allResults.push(importantData);
}
let fileContents =
'system,treatment,teaModel,band,totalDryFeedstock,totalCost,totalCostPerDryTon,runningTotalDryFeedstock,runningTotalCost\n';
allResults.forEach((result) => {
fileContents += `${result.system},${result.treatment},${result.teaModel},${result.band},${result.totalDryFeedstock},${result.totalCost},${result.totalCostPerDryTon},${result.runningTotalDryFeedstock},${result.runningTotalCost}\n`;
});
fs.writeFileSync(fileWithDirectory, fileContents);
}
}
};
run()
.then(() => {
console.log('done processing all bands, treatments and systems');
process.exit();
})
.catch((err) => {
console.log(err);
});