A highly customizable chart of categorical, circular, freeform, and scatter series types.Welcome to TrialDirector the most flexible and widelyused trial presentation technology available.Easily organize, annotate and customize your exhibits for.Once you start drawing freeform objects in PowerPoint 2007, you quickly realize it behaves very differently than it did in PowerPoint 2003.I dont understand.Surfaces. Freeform surface, or freeform surfacing, is used in CAD and other computer graphics software to describe the skin of a 3D geometric element.How to Avoid Getting Sick on a Cruise Ship.Cruise ships are considered to be notorious hotbeds for illness, especially the firing out both ends kind.If youd rather spend your trip soaking up sun and drinking Bahama Mamas than seeing your buffet dinner in reverse, follow these tips.Youre on your hands and knees praying to the porcelain god, and between each of your wretchedRead more Read.C3.jpg?7447' alt='Basic Freeform Drawing Software' title='Basic Freeform Drawing Software' />Despite the horror stories you hear about passengers being trapped on the S.S. Vomit, the odds are generally in your favor.Aimee Treffiletti, head of the CDCs Vessel Sanitation Program which inspects all cruise ships in U.S. waters, explained to the Los Angeles Times that acute gastrointestinal illness AGE is pretty infrequent, and the chance youll get sick is declining.In fact, Treffiletti says less than 0.AGE, so theres no need to fear.Much like wiping, washing our hands is something that all of us hopefully do, but dont really Read more Read.That said, sickness can still strike, and when it does, it will hit a cruise ship hard.Everyone is trapped in the same place, breathing the same air, touching the same surfaces, and eating the same meals.Heres what you can do to avoid an epidemic, and avoid spreading it to others Wash your hands often This should be a no brainer, but make sure you do it right.Do it after you use the bathroom, before eating, and anytime after youve been touching things in common areas, like railings or door handles.Carry around hand sanitizer When you cant wash your hands, hand sanitizer is the next best thing.Might even consider wiping down things in your cabin, like doorknobs, remotes, and phones.Do laundry and wear clean clothing This is basic hygiene, but it can save you from getting sick too.Norovirus and other gut wreckers can hang around on contaminated garments, so dont push your luck.Get plenty of sleep Youre going to encounter germs no matter what.Make sure your immune system is up for the fight.Drink lots of bottled water You need to stay hydrated to fight off bugs, but dont trust the tap water or ice anywhere.This is especially true when youre docked and wandering around another countrys port.Watch what you eat Dont eat food while youre on shore in developing countries, only eat food that is cooked thoroughly and served hot, dont consume unpasteurized items, and skip produce unless it has a removable skin.Dont share utensils, food, or drinks Avoid self serve foods if possible, but if not, use a napkin to hold tongs, spoons, and ladles.Also, dont take a bite or have a sip or someone elses food or drink.If theyre infected, thats it all it takes to spread disease.Use your own restroom When possible, Joanne Chen at Cond Nast Traveler suggests you skip the public restrooms and use your own instead.There are still germs in your restroom, but theyre yours and not from several hundred other people on the ship.Be honest If you start to show symptoms of any illness, let the ships medical team know so they can do whatever they can to prevent you spreading it.You might get quarantined, but you could save everyone else from suffering.If youre feeling sick before you get on the boat, think about changing your plans.The CDC suggests you make sure you and your family are up to date on routine vaccines before you leave as well.And check to see if where youre going requires additional vaccinations on their Travelers Health page.If youre not sure where to start, sit down with your doctor and go over your trip itinerary.Of course, not all sickness is caused by a nasty germ.If the motion of the ocean is your problem, fear not, weve got tips for that as well.On our first family road trip, I was excited to play navigator.Id look down at the map, look upRead more Read.Create Excel Freeform Shapes from Polygons.How to transfer polygon data into freeform shapes in Microsoft Excel If you are a regular reader or even subscribed to this blog, you will not be surprised to hear that I am working on a new challenge regarding maps in Microsoft Excel.We had a lot of articles already on how to create Choropleth Maps in Microsoft Excel.The new project is about using maps in Excel again, but with a different type of visualization.Since I am just starting out on this challenge, I cant provide more details yet.Having said that, for the preparation of the new project, I had to work with geographical polygon data.Now, whats thisA polygon is a plane figure that is bounded by a finite chain of straight line segments closing in a loop to form a closed chain or circuit.Wikipedia. In the context of geographical visualization, a polygon represents a region e.Such a polygon consists of a series of geographical points pairs of latitude and longitude in a defined order path.If you draw an outline through these points in the given order, you get a shape forming the boundary of this region.And this was my challenge transfer geographical polygon data into freeform shapes in Microsoft Excel.I am not sure, but I thought maybe some of you might be interested, so I decided to share my solution.Todays post first shows how to plot polygon data on standard Excel XY Scatter charts and then describes my solution to transfer the data into freeform shapes.As always, the article provides a link to download the Excel workbook for free.The Data. The underlying database is a simple, but huge Excel table with the polygon data of the borders of all countries in the world The table contains the ISO3 abbreviation, the country name, the polygon ID, the point order, the latitude and the longitude.As I said, simple, but huge more than 4.I created this polygon data from an ESRI Shapefile of a world map using Richard Leekes fantastic Shape.To. Tab utility more here Create Your Own Filled Maps in Tableau.Many thanks go again to Richard for his fabulous tools Tab.Geo. Hack and Shape.To. Tab. As you can see in the screenshot for the example of Aruba, the first and last point have identical latitude and longitude values the 1.Arubas boundaries.Plotting Polygons in an XY Scatter Chart.You can directly plot the polygons on an XY Scatter chart in Excel.No data preprocessing or even coding necessary.All you have to do is to adjust the minimum and maximum values of the two axes.Lets first try a smaller example than the world map.Here is the polygon of Austria plotted in an XY Scatter chart You can already recognize Austria, right Changing the chart type to an XY Scatter with smoothed or straight lines and no markers makes it even clearer A short distraction, if you dont mind I love watching The Big Bang Theory, but I simply cant see how Austria on a map looks like a Wiener What kind of Wiener are they eating Fun fact in Austria, Wiener are actually called Frankfurter.But I am digressing.Focus attenuation fits well, doesnt it. Cesare Pavese Il Compagno Download Youtube . Reading the last paragraph back, I noticed I am sounding like Sheldon already.So, back to the polygons and maps.Lets have a look at Germany.The simple XY scatter And the same data plotted on an XY Scatter with lines and no markers What is going on here Well, unlike Austria, Germany consists of more than one polygon 2.Since all data is plotted in one data series, Excel is also drawing lines between the start and end points of the different polygons.To avoid this, we would have to plot the data in 2.VBA. This becomes a real problem, if you have a lot of polygons in your data.The world map, for instance, consists of 3,7.Since the maximum number of data series in an Excel chart is 2.Excel Specifications and Limits, the option of having one data series per polygon is out of the picture.A VBA routine to delete all unwanted connection lines between the polygons is the only reasonable way to solve this issue.Having said that, with very large data sets like the world map, you may even go with a XY Scatter chart with markers only and no lines So much for plotting polygons on Excel charts.The Challenge. The problem I was facing in my project was different.I didnt want to plot polygons on an XY Scatter chart.I rather needed to transfer them into freeform shapes.A picture says a thousand words this is what I was after A map in Excel made of freeform shapes exactly like the ones we used in all the Choropleth Maps in Microsoft Excel posts automatically created from the raw polygon data table shown above.The Implementation.Before starting to code the VBA subs, we have to do a few enhancements on the worksheet add a unique identifier for every polygon ISO3 abbreviation followed by an underscore followed by the Polygon ID.A simple string concatenationadd two columns to transfer Latitude and Longitude into positive values in points on a worksheet.The formulas are very simple basic arithmetical operations based on maximum and minimum values of Latitude and Longitude and three parameters scale, top and left offsetNow on to the VBA code.The heart of the solution is the Shapes.Add. Polyline Method.Calling this method with an array of coordinate pairs that specifies the polyline drawings vertices creates a freeform shape of the closed polygon.This method makes the implementation a walk in the park The sub to create freeform shapes simply loops through the entire data table, transfers the X and Y points of each polygon to an array and calls the.Add. Polyline method with this array to insert the freeform shape.The VBA project is open, the code is commented and very slim 1.I think I do not have to go into the details here.If you are interested, download the workbook download link at the end of the post and have a look.If you have any questions, please feel free to leave me a comment.How to use the Tool.The workbook download link see below consists of only two worksheets one with the polygon data and a few simple calculations and an output sheet for the freeform shapes.On the data sheet, the first 6 columns of the table contain the polygon data.The next 3 columns create a unique ID for each polygon and transfer Latitude and Longitude into valid positions points on the output sheet using simple formulas see section above The VBA procedures can be started from an extra tab on the ribbon POLYGONS 2 SHAPES A click on one of the first three buttons on this tab starts the VBA routines Transfer the polygon data into freeform shapes on the output sheet.Delete all shapes on the output sheet.Create groups of shapes for each country if the country has more than one polygonClicking on the last icon is simply sending you to this blog.You see, I am desperately looking for options to increase the traffic here.If you want to use the tool for your own polygons, you simply have to clear the first 6 columns of the table on the data worksheet, copy in your own data, resize the table and finally click on the first icon of the POLYGONS 2 SHAPES tab.Thats it. A few seconds later you should have the freeform shapes on the output sheet.The Disadvantage Performance.The code isnt optimized for performance and it takes some time to transfer the polygon data into freeform shapes.The polygons of Europe without Russia and Greenland, for instance, consist of more than 5.Creating 4. 76 freeform shapes of 5.Not really fast, but sufficient for my purposes.The Download Link.Here is the Excel workbook with the polygon data of Europe without Russia and Greenland for free download Download Create Shapes from Polygons zipped Excel 2.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
November 2017
Categories |