An unexpectedly shortened week with a power outage that caused school to be cancelled on Monday. Despite this setback our students were hard at work in the shop. This week we will focus on Senior Asiya Khalif ’27. Asiya works on a variety of projects in the shop and is one of our water jet experts.
Asiya’s latest blog post:
Hello!
This week was surely a whirlwind. On Monday we started off fantastically with school being cancelled 10-20ish minutes before it even started due to a power outage! Thus, while I refreshed my memory on some code on that day, not much else got done.
Tuesday is where the magic happened, however. Tuesday was he day before our amazing club fair event at MHS. I’m a senior leader for Library Advisory Board, but also a co-president of the Eco League which meant it was crunch time.
Not many people know what my responsibilities are for Eco League, and may wonder why I spend a lot of time on it during Robotics. Basically, for the Commuter Challenge, people do an initial form and a weekly form. The first form needs to have the distance of the 1-3 places you go often in an eco friendly way, while the second one says how many times to traveled to each of those places that week. These two forms connect to a spreadsheet where I need a collumn to summarize how many miles you traveled that week.
Ex) if you have Commute A, B, and C, and you commuted to A 3 times, B 4 times, and C 5 times then you have to do (A*3)+(4*B)+(C*5).
This seems simple enough, but these are on Google Spreadsheets, A, B, and C are in a completely different tab, and I need to use ARRAY FORMULA or something of the sort to make it automatically work for each row. After that, I then need to make a column of all total miles that respondent has done (which means I need to use some sort of SUMIF) to make sure I get all of their smaller total values ONLY if they are from the same email address, and make sure this happens automatically for all of the rows.
THEN, it is time to turn that total amount of miles into latitude and longitude of how far along the specific route is from Medford to Detroit. This needs to be on such a precise line with specific checkpoints that may need to be added or rearranged. This means, I go into App Scripts and start coding that into the Google Spreadsheet. Only after, can I save all of this as a gpx file and upload it into the map software I am currently using.
Other things I have done this week include slightly helping with the Eco League poster but the code still needs work so I wasn’t involved in much else. Anyways, today I will be cutting anywhere from 10 to 100,000 circles on the Waterjet, which is certainly one of my favorite activities.
Keep Beguiling!
See more of Asiya’s work at this link.
MVTHS Engineering 