Quinton Swan BSME

1       Introduction Stadler relies primarily on experience and intuition when making capacity decisions. Although this strategy has proved historically successful for the company, there isn’t a concise feedback loop to validate and improve the predictions. It is difficult to communicate expectations across the project phases with regard to predetermined budgets. Managers with limited understanding of the overall workflow are at risk of understaffing their departments at critical phases. This in turn leads to missed payment milestones, and management is pressured to add emergency personnel to make up for lost time. Although coined for a separate industry, Brooks’ Law takes shape, and that is “adding manpower to a late software project makes it later”. Brooks’ Law describes a scenario where total productivity declines due to resources being diverted to onboard potential contributors. Broadly speaking, strained capacity increases the total cost by means of d...

Overview Project CalTrain was a combined effort between Stadler US (STAUS) and Stadler Altenrhein (STAR). The train was designed, modeled, and analyzed by the STAR engineering team. The STAUS engineering team was responsible for supporting production in manufacturing the train. Support included coordinating with suppliers in the form of first article inspections, providing solutions for non-conforming goods, and maintaining an ISO 10007 compliant change control system. STAR maintained an independent change control system in the form of an Excel spreadsheet maintained by a responsible change engineer. However, this spreadsheet covered only the phases between the request (engineering change request or ECR) and the solution (engineering change notice or ECN). The CalTrain contract required a robust change system covering initial request to final physical installation of products. The final deliverable was to be complete documentation of which products were affected by changes across t...

 Automate redline function(BU_####### string) //Retrieve Redlines open http://elstr.stadlerrail.ch/change#number=BU_####### Navigate page and select attachment.pdf Download attachment.pdf to /workfolder //Fill out Change Management Form using url class <change details> store class."alpha main-title" as string Title store class."cd-assignment" as string Zuordnung store class."cd-type" as string Typ store "Technik" as string Abteilung Open Antrag.docx from /systemfolder Write variables as text Save Antrag.docx as Antrag.pdf in /workfolder //Update Antrag Open AE_Antraege_CalTrain.xlsm Row_count(sheet) as lngRow Select Cell(lngRow+1,1) Fill(Title,Zuordnung,Typ,Abteilung) store lngRow+1 as int lfdno //Combine into single PDF EITHER Open Adobe X Pro function combine pdf For each *.pdf in /workfolder select .pdf ok combine OR Open Antrag.docx insert pagebreak insert object -> attachment.pdf Save product as ...