USE PYTHON AND LINUX TIM JAVA ONLY PLEASE ASTO THE SQUARE OF JAVA…USE PYTHON AND LINUX TIM JAVA ONLY PLEASE ASTO THE SQUARE OF JAVA PROGRAMMING NETWOORK VIRUS FOR ALL THE QUERIES NEEDING NETWORK ANALYSIS COMPIUTATION.Zeller’s congruence is an algorithm developed by Christian Zeller to calculate the h = (q + 26(m+1)//10 + k + k//4 +j//4 +5jwhere- h is the day of the week (0: Saturday, 1: Sunday, 2: Monday, 3: Tuesday, 4: Wednesday, 5: Thursday, 6: Friday).- q is the e month (3: March, 4: April, …, 12: December). January and February are counted as months 13 and 14 of the previous year.- k is the year of the century (i.e., year % 100).program that prompts the user to enter a year, month, and day of the month, and then it displays the name of the day of the week.Sample Run 1Enter year: (e.g., 2008): 2013Enter month: 1-12: 1Enter the day of the month: 1-31: 25Day of the week is FridaySample Run 2Enter year: (e.g., 2008): 2012Enter month: 1-12: 5Enter the day of the month: 1-31: 12Day of the week is SaturdayHint: Use the // operator for integer division. January and February are counted as 13 and 14 in the formula, so you need to convert the user input 1 to 13 and 2 to 14 for the month and change the year to the previous year.Start Excel. Open the downloaded file named exploring_e04_grader_h1.xlsx. 0 2 In the Sales Data worksheet, freeze the top row. Hint: On the VIEW tab, in the Window group, click Freeze Panes and then click Freeze Top Row. 5 3 In the Sales Data worksheet, convert the data to a table and apply Table Style Medium 17. Hint: To convert the data, on the INSERT tab, in the Tables group, click Table. To apply the style, on the DESIGN tab, in the Table Styles group, click the More button. 6 4 In the Sales Data worksheet, remove duplicate records in the table. Hint: On the DESIGN tab, in the Tools group, click Remove Duplicates. 5 5 In the Sales Data worksheet, insert a new field to the right of the Selling Price field. Name the new field Percent of List Price. Hint: Right-click the Column E header and click Insert. 6 6 In the Sales Data worksheet, formula in cell E2 with structured references to calculate what percent the selling price is of the list price. Format the field with Percent Style with one decimal place in the range E2:E43. Hint: In cell E2, enter the formula =[Selling Price]/[List Price]. To format the range, on the HOME tab, in the Number group, click the Number Format Dialog Box Launcher. 6 7 In the Sales Data worksheet, insert a new field to the right of the Sale Date field. Name the new field Days on Market. formula with structured references to calculate the number of days on the market. Hint: In cell H1, Days on Market and press ENTER. To insert the formula, in cell H2, =[Sale Date]-[Listing Date]. 6 8 In the Sales Data worksheet, add a total row to display the average percent of list price and average number of days on market. Apply the General number format to the average number of days on market. Averages in cell A44. Hint: To display the Total row, on the DESIGN tab, in the Table Style Options group, click Total Row. To select the function, click the cell, click the arrow, and then click the function. 10 9 In the Sales Data worksheet, sort the table by City in alphabetical order and add a second level to sort by Days on Market with the houses on the market the longest at the top within each city. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 8 10 In the Sales Data worksheet, select the Listing Date and Sale Date fields and set a column width of 11.00. Wrap the column labels in the range E1:H1. Hint: To set the column width, on the HOME tab, in the Cells group, click Format. To wrap the labels, in the Alignment group, click Wrap Text. 6 11 Set up the Sales Data worksheet so that when printed, the first row containing the field names will print as titles on each page. Hint: On the PAGE LAYOUT tab, in the Page Setup group, click Print Titles. 5 12 Display the Sales Data worksheet in Page Break Preview and move the page break to occur between rows 26 and 27, and then change back to Normal view. Hint: To display Page Break Preview, on the VIEW tab, in the Workbook Views group, click Page Break Preview. To insert the page break, click cell A27 and on the PAGE LAYOUT tab, in the Page Setup group, click Breaks. 5 13 Display the Filtered Data worksheet. Convert the table to a range of data. Hint: On the DESIGN tab, in the Tools group, click Convert to Range. 5 14 Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain. Hint: On the HOME tab, in the Editing group, click Sort & Filter. 6 15 Use a custom AutoFilter to display records for houses that were on the market 30 days or more. 5 16 Apply the 3 Arrows (Colored) icon set to the days on market field values. Do not include the field name in the range. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Icon Sets. 5 17 Apply the Light Blue Data Bar conditional formatting in the Gradient Fill section to the selling prices. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then point to Data Bars. 5 18new conditional format that applies Yellow fill (fourth color in the bottom row) and bold font to values that are higher than 98% for the Percent of List Price column. Hint: On the HOME tab, in the Styles group, click Conditional Formatting and then click New Rule. 6 19 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Sales Data, Filtered Data.The first straight is shown in red and the first Intersection Point (IP) must be at the end of the red line.You must draw two more straights to complete the road alignment. These straights must allow the road to be designed to meet the requirements of the vertical design as listed below. Also, the area of land adjacent to the creek, which runs to the river, that is bounded by the 15m contour line, the river and the two dashed lines is prime agricultural land and the road is not permitted to go through this area. Use a protractor to find the bearing of the first straight and then measure the deflection angle for each curve to the nearest degree. Use Tucker’s Rd with its bearing of 0o, as your azimuth. Scale the distances from Tucker’s Rd to IP1, IP1 to IP2 and IP2 to the End, to the nearest metre. For the purposes of the calculations for the preliminary design, the scaled lengths (00 – IP1, IP1 – IP2 and IP2 – END) must be adopted as the design length of each straight to a precision of two decimal places. Each horizontal curve is to have radius of 60m.Calculate the tangent distance and arc length for each curve and show them in the table of Calculate the chainages of each of the four TPs and any other points listed and show them in the table of On your plan, plot each curve. (Calculating the external distance will give you a third point to help you draw the curve freehand.) Also clearly show the lengths of each straight (IP – IP) and the bearing of that straight. Please calculate the data needed to set out each horizontal curve from its first TP by deflection angles and long chords for points at 15m running chainage along the road as well as the crown of each curve. (i.e. 120, 135, 150, 165 … 360, 375, 390, 405, as they fall within each horizontal curve. Vertical Alignment Using the contours on the map provided, draw a longsection of the Centre Line of your road at scales; horizontal 1:2,000 and vertical 1:200. (Please read the submission section for detailed guidance about drawing the longsection.) Design a vertical alignment of the centre line of the road showing grades and vertical curves. The vertical alignment must meet the following criteria: The road must start at RL 14.5 and must exactly RL 32.5. This final grade of your road into the parking site must be between +2.0% and +0.5%. The maximum grade allowed at any point along the road is 10%.Vertical curves must have lengths of 60m or 80m only. In exceptional circumstances, a VC of 40m length may be permitted but you will need to explain why it must be used. The IP of each vertical curve must be located at an even 10m chainage (i.e. 120, 350 etc. and must not be placed at odd locations such as 376.5). All grades used must be to no greater precision than 0.1%, except for the final grade to the end of the line. (i.e. grades such as 3.1% must be used for every grade, except the final one where additional decimal places must be shown, where necessary, to ensure that the Design RL meets the set RL of the parking area). Every change of grade requires a vertical curve. (Assume that your road will meet Tucker’s Road at the nominated RL and can start at any grade you wish to use. No vertical curve will be needed at this road junction.) Cut and FillExcept for the two locations specified, the vertical design should keep cut and fill to less than 1m in depth. Working by eye, and not mathematically, try to balance cut and fill along the road. Between the two banks of the river, your road must be between 1m and 2m above the bank R.L., so that precast box culverts can be installed. For no more than 15m either side of the 30m contour line, a cut of up to 2m is permitted. Complete the table with your vertical curve calculations for the design levels. Calculate the Design Levels for the locations as specified: every 30m of running chainage along the road, where there is NO vertical curve; (i.e. 0, 30, 60, 90 …300, 330, 360 etc. … and the end of the road). For every vertical curve, please calculate the Design Levels at every 10m from VC TP to VC TP.Also calculate the chainage (to 2 d.p.) and RL of the low point of the road at the river crossing. Watercourse Information The banks of the creek where the road crosses it are at R.L. 11.0. Precision of Calculations Needed On your plan, please show the bearings of the straights to the nearest degree only and the distances IP to IP should be shown to the nearest metre.For the horizontal curve setting out data, please calculate the arc lengths and long chord distances to two decimal places of a metre and the setting out deflection angles to the nearest 10″. All levels on the longsection table must be correct to two decimal places. The grades you nominate for the road design must be to no greater precision than one decimal place, except for the final grade, and all R.L.s must agree perfectly with the grade shown. Your road must end exactly at R.L. given for the parking area. Survey Party Instructions A survey party has run an EDM traverse point A, (whose coordinates are 300.000m E, 600.000m N) on the centre line of Tucker’s Road via point Y, to a point X which is close to the parking area P. Calculate the coordinates of point X. Also, using your bearings and distances of each straight of your road, calculate the bearing and distance for the survey party to set out the end of your road from point X.The curve set out data has already been requested. Finally provide instructions to the survey party for any extra information needed or areas to checked for you to be able to finalise your road design. Submission1) The plan showing your straights with the bearings and the scaled distances (0 to IP1), (IP1 to IP2) and (IP2 to the END) clearly marked. Each horizontal curve must be plotted. 2) Horizontal and Vertical Curve Tables completed on the 3) A Longsection, showing:a) in the drawing section, the natural surface, grade lines and the road design. You must also note the extent of each grade and the regions where the vertical curves are located. Also show each IPRL and Mid Ordinate value, as per the example provided.b) in the data rows, the distances and natural surfaced RLs used to plot the natural surface;the distances and Design RLs at the chainage of each IP of the vertical alignment only. (Longsection guidance – it is strongly recommended that you use an A4 sheet of 2mm graph paper to draw your longsection. The bottom three rows should show Distance, Design RL and Natural Surface RL. To ensure your longsection fits on the page, the RL of the base line of the plot should be 5m, making the very top of the page RL 33m.) See a detailed example online. 4) Instructions for the survey party: a) data to mark location of the end of your design from point X, (as per the tables provided)b) data to set out each horizontal curve from its first TP by deflection angles and long chords for points at 15m running chainage within each horizontal curve, and the crown of each curve, (as per the tables provided)c) instructions to the survey party for any extra information you wish them to gather for you to design. Submission Component and Marks AwardedPlan 1) 6 Horizontal Curve calcs (leading to chainages) 2) 14 Longsection 3) 5 VC Calc table: Grades, ordinates, Design RLs 2) 20 Low Point Ch and RL 2) 5 Design meeting specifications 3) 5 Traverse and missing line calculations 4)a 10 Curve set out data 4)b 10 Instructions to Survey Party 4)c 5 NOTE This exercise is only an assessment of the work done in the Surveying subject this semester. Do not research road design information and go beyond the calculations shown to you in the Surveying classes. You will be marked on the accuracy of your calculations and meeting the specification only. The “quality” of the road design will not be considered. i.e. treat the horizontal and vertical alignments as being totally separate designs. Computer ScienceEngineering & TechnologyNetworking
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more