Closed samgdotson closed 4 years ago
Copied from Slack reply Thanks and last thing just for my clarification: are you looking for TOTAL amount of cars using that fuel type within the fleet, or the amount of models that use that fuel types. For instance, if there were 8 Fords and 3 Dodges using one of the fuel type, are you looking for 11 vehicles or 2 vehicle types.
I see, 11 vehicles would be the answer I'm looking for. Thanks for checking!
Before I go ahead and submit a request to the Office of Campus Emergency Management for access to information on approximate miles driven by each vehicle of the fleet, there was not a separate excel sheet that contained this information, correct? I see the purchase records and the fuel numbers, but I do not see anything about miles traveled.
Yes, I believe that is correct. If that data is available it would be exact miles driven per vehicle. I encourage you to pursue this data, but don't get hung up on waiting for a response -- an approximate answer is fine (by using average mpg and total gallons consumed).
In that case should I just look up the average mpg for the different vehicles? Because I initially assumed we would get that statistic by using the exact mileage traveled by each vehicle.
Edit: Many of the vehicles used multiple types of fuel over the course of the year so getting an accurate gas mileage would be very difficult.
*Also edited for grammar
Hi Folks, @robfairh should be tightly involved in this discussion. I think he has already asked for and received much of this information from Facilities. We should not be repeatedly asking facilities services for the same data for the same project (there are humans behind the request form). @robfairh can you please coordinate with @samgdotson and @datw0258 ?
For clarification, do you still want me to look at the things listed in the initial issue, or just finding GGE equivalents for the technologies you listed and their corresponding $/GGE?
I'll edit the issue to reflect our earlier conversation. I think @katyhuff is right, we should be concerned with gallon-gasoline-equivalent for now (the phrase "your mileage may vary" applies here in the literal sense..).
I am emailing you an update of where I am so you can let me know if I've misinterpreted some of the checkpoints so far. If there is a better/preferred way of sending files to you (ipynb in this case) in the future, please let me know!
Excellent, I just took a look at the files and it seems like you're going the right direction. Regarding the sending of files, this is precisely what GitHub is designed to do! Here's the outline for using GitHub:
git clone git@github.com:datw0258/2020-dotson-optimal-sizing
(I recommend setting up ssh keys) git checkout -b IssueName
git add FileName
then ``git commit -m "descriptive message"Before I make a pull request, I just wanted to confirm I am doing this right as I am not completely confident with GitHub yet (it says something like "These branches can be automatically merged").
1) I forked the repository and made a new branch "UIUC-Transportation-Demand" 2) Added a folder called "UIUC-Transportation-Demand" containing the notebook and csv's 3) I open a pull request, and submit it
Looks good to me. Just don't press "merge" before a review. Minor comments: capital letters are annoying. Try to use lowercase (indeed, ideally snake case) for folder names, branch names, filenames, etc.
On Thu, May 28, 2020 at 12:54 PM datw0258 notifications@github.com wrote:
Before I make a pull request, I just wanted to confirm I am doing this right as I am not completely confident with GitHub yet (it says something like "These branches can be automatically merged").
- I forked the repository and made a new branch "UIUC-Transportation-Demand"
- Added a folder called "UIUC-Transportation-Demand" containing the notebook and csv's
- I open a pull request, and submit it
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/arfc/2020-dotson-optimal-sizing/issues/41#issuecomment-635502232, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADAFK74JIS5IPAWAQHLFRDRT2QORANCNFSM4NKQCSHA .
Okay sounds good. Do I have to assign someone (Sam) to the Pull Request, or will it automatically add him?
It's best to assign someone. It will not automatically add anyone, though it may "suggest" someone.
On Thu, May 28, 2020 at 1:51 PM datw0258 notifications@github.com wrote:
Okay sounds good. Do I have to assign someone (Sam) to the Pull Request, or will it automatically add him?
— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/arfc/2020-dotson-optimal-sizing/issues/41#issuecomment-635531233, or unsubscribe https://github.com/notifications/unsubscribe-auth/AADAFK2PLSM2WOHRQIJOHXLRT2XCNANCNFSM4NKQCSHA .
closed by #42
This issue can be closed when a document or jupyter notebook has been created to answer the following questions (with detailed steps on how to replicate the answers):
[ ] Determine the total fuel demand in gallons of gasoline equivalent for each technology type.
[ ] What is the CO2 equivalent per gallon-gasoline-equivalent. Note: It's important that this an equivalent because emissions might consist of more than just CO2. E.g. 1 ton of CH4 released might be the same as 3 tons of CO2. So report 3 tons of CO2eq.
[ ] Determine the cost of each type of fuel
[ ] Determine conversion rates for each type of fuel (e.g. 1 kWh(e) = 10 gallons-gasoline)
[ ] Document to replicate answers and sources cited.
Vehicles should be sorted by fuel type (E85, Diesel, Unleaded, Lithium-ion, H2 fuel-cell).
edit1: for clarity
edit 2: updates goal