Subscribe to RSS

Posts tagged as: Microsoft back to homepage

Renault R30 analysis Renault R30 analysisComments Off

There were high hopes of a remarkable racing car on January 31st when the Renault R30 was unveiled, with a front wing that resembles very much the 2009 version, even though Alonso had pinpointed that that was precisely one of the main problems of the 2009 car.

Nevertheless, next day the car that made its debut in the racetrack and the characteristics of the front wing of three stacked elements was totally different.  Specifically, it’s very similar to the one that McLaren has.

The changes made on the R30 are very deep and one has to pay much attention.  The rear wing is also new, with a drop in the middle where the sharp fin gives it the aerodynamic support.

The nose’s cone is absolutely different from the rest of the scuderias, contrary to the 2010 trend which is V shaped.  Even though it is still a bit bulky, it lacks the extra protuberance underneath, with the purpose of gaining more resistance.

The wings are a clear evolution and contrary to the other three cars previously launched by Renault, the R30 has huge sidepod air inlets that extend down to the vehicle’s floor.  Instead of rectangular air inlets (more conventional) they are bigger in the high part than in the low one.

There’s no doubt that the team is quite interested in the temperature, because over the engine’s cover are connected heat stickers.  The engine’s exhaust have been moved towards the back and more to the middle of the car.

Specifications

  • Chassis: Molded carbon fiber and aluminum honeycomb composite monocoque, manufactured by the Renault F1 Team and designed for maximum strength with minimum weight. RS27-2010 V8 engine installed as a fully-stressed member.
  • Front suspension: Carbon fiber top and bottom wishbones operate an inboard rocker via a pushrod system. This is connected to a torsion bar and damper units which are mounted inside the front of the monocoque. Aluminum uprights and OZ machined magnesium wheels.
  • Rear suspension: Carbon fiber top and bottom wishbones with pushrod operated torsion bars and transverse-mounted damper units mounted in the top of the gearbox casing. Aluminum uprights and OZ machined magnesium wheels.
  • Transmission: Seven-speed semi-automatic titanium gearbox with reverse gear. “Quickshift” system in operation to maximize speed of gearshifts.
  • Fuel system: Kevlar-reinforced rubber fuel cell by ATL.
  • Cooling system: Separate oil and water radiators located in the car’s sidepods and cooled using airflow from the car’s forward motion.
  • Electrical: MES-Microsoft Standard Electronic Control Unit.
  • Braking system: Carbon discs and pads (Hitco); calipers and master cylinders by AP Racing.
  • Cockpit: Removable driver’s seat made of anatomically formed carbon composite, with six-point harness seat belt by OMP Racing. Steering wheel integrates gear change and clutch paddles, front flap adjuster.

Car dimensions and weight

  • Front track: 1450 mm
  • Rear track: 1.400 mm
  • Overall length: 5050 mm (250 mm more than R29)
  • Overall height: 950 mm
  • Overall width: 1800 mm
  • Overall weight: 620 kg, with driver and cameras

Engine

  • Designation: Renault RS27-2010
  • Capacity: 2400 cc
  • Architecture: 90° V8
  • Weight: 95 kg
  • Max rpm: 18.000 rpm
  • ECU: McLaren Electronics Standard ECU
  • Fuel: TOTAL
  • Battery: Renault F1 Team

Navigating Through Formulas In Large And Complex Microsoft Excel Spreadsheets Navigating Through Formulas In Large And Complex Microsoft Excel SpreadsheetsComments Off

When Microsoft Excel is used to construct large and complex spreadsheets containing multiple worksheets, it can become extremely difficult for someone to navigate, let alone track or trace numbers through the spreadsheet with all of the values and formulas contained within it. This is because in a large spreadsheet like a financial model, there can often be hundreds if not thousands of different formula down and across each page including calculations which may contain several links to other sheets within the workbook. The difficulty experienced with navigating through the formulas of large and complex spreadsheets exists even when you were the one who designed and built the spreadsheet. Microsoft Excel does come with some basic functionality to help users navigate through a spreadsheets formulas. Some common methods are: – Utilising the ‘Go To’ window [ctrl + G] and typing in cell addresses – Entering edit mode [F2], thus outlining same sheet precedents in different colors – Using formula auditing to draw arrows to precedent or dependent cells and double clicking to move back and forth between same sheet references and the ‘Go To’ window to move back and forth between off-sheet references. This functionality and all of the inefficiency of double mouse clicks falls well short of the mark for many users who have large complex spreadsheets, such as a financial model with formulas that link to a number of cells or cells much further down/across the sheet or to cells on a variety of other worksheets, or even workbooks. The bottom line is that when it comes to formula navigation the existing functionality of Microsoft Excel is difficult to use, inefficient and lacking in functionality. The main problem is that when trying to check or understand a formula you must first take a look at the precedents cells or ranges, but then be able to quickly jump to the other precedent cells and finally back to the original formula you were originally looking at. Navigating to these precedents and then back again using Microsoft Excel’s existing functionality is time consuming to say the least as many have felt the frustration of editing, checking, de-bugging, enhancing or auditing a formula that you, or worse, someone else has created in their spreadsheet when multiple precedents and sheets are involved. This common complaint with Microsoft Excel is heard time and time again by engineers, accountants, management consultants, bankers and finance professionals who work with Excel spreadsheets on a daily basis. Many spreadsheet users including financial modellers (who seem to be leading the charge) are turning towards Excel Add-ins and software tools that plug into Microsoft Excel to help them navigate through formulas and complex spreadsheets more easily. Probably the most popular and widely used Excel add-in for this purpose is ‘Formula Navigator’. An add-in created by the company ‘Spreadsheet Guys’. They have developed a unique add-in utilising a re-sizeable floating window and hyperlink system to help Excel users understand a formula and efficiently jump to all of its precedent and dependent cells and ranges no matter whether they are on a different worksheet or a different open workbook. An additional history window added as part of the products 2nd release also allows the user to click back to any cell previously looked at (traced) using the tool, during the current open session. Whether the spreadsheet was designed by you or someone else, ‘Formula Navigator’ definitely fills a need and has already cured the frustration of many Excel spreadsheet users, helping them to more quickly understand the logic in a formula and links between sheets, thus helping to reduce spreadsheet errors, facilitate debugging and assist with spreadsheet auditing.


Get This Plugin

Contacts and information

Social networks

Most popular categories

T-CREA
© 2011 Fantasy Racings F1 All rights reserved.