Start Making a Breast Icon

You will learn to start making a 32x32 pixel breast icon in Microsoft Excel, using modifiable trigonometric formulas and variables so that your breast curve comes out just the way you think it should be. October is Breast Cancer Awareness Month, and these icons may help get the message across.

Steps

  • Become familiar with a basic image to be created:

Preparation

  1. Open a new Excel workbook and prepare 2 worksheets:
    • Either click on the green "X" icon, or double-click on Excel in the Microsoft Office folder in your Applications folder by opening a Finder window, in order to start Excel;
    • Using the File menu or the icon, Open a new workbook;
    • Save the workbook as "Breast Icons" into a logical folder, such as "wikiHow Articles" or "MS XL Imagery";
    • Create via the + button at the bottom or access the second worksheet tab and double-click edit-name it "Saves" -- this will be used to Paste Values and Charts to which you wish to keep and remember, while still having the top worksheet tab for doing the main work on -- if you were to copy and paste, the formula results would change with varying inputs on the top worksheet from the Defined Named Variables, which are global;
    • Double-click on the first leftmost worksheet tab and edit-name it "Formulas" (w/o quotes).
  2. Set Preferences:
    • Be mindful that these settings will affect your future XL work;
    • General - Set Show this number of recent documents to 15; set Sheets in new workbook to 3; this editor works with Body Font, in a font size of 12; set your preferred file path/ location;
    • View - Check Show formula bar by default; check Indicators only, and comments on hover for Comments; show All for objects; Show row and column headings, Show outline symbols, Show zero values, Show horizontal scroll bar, Show vertical scroll bar, Show sheet tabs;
    • Edit - Check all; Display 0 number of decimal places; set Interpret as 21st century for two-digit years before 30; Uncheck Automatically convert date system;
    • AutoCorrect - Check all
    • Chart - In Chart Screen Tips, check Show chart names on hover, and check Show data marker values on hover; leave the rest unchecked;
    • Calculation - Automatically checked; Limit iteration to 100 Maximum iterations with a maximum change of 0.0001, unless goal seeking, then .000 000 000 000 01 (w/o spaces); check Save external link values;
    • Error checking - Check all and this editor uses dark green or red to flag errors;
    • Save - Check all; set to 5 minutes;
    • Compatibility - check Check documents for compatibility
    • Ribbon - All checked, except Hide group titles is unchecked.

The Tutorial

  1. Enter the Column Headers:
    • Enter to cell A1, A;
    • Enter to cell B1, B;
    • Enter to cell C1, C_C;
    • Enter to cell D1, D;
    • Enter to cell E1, Var; (for Variable)
    • Enter to cell F1, t_t;
    • Enter to cell G1, ADJ_X;
    • Enter to cell H1, ADJ_Y;
    • Enter to cell I1, Formula X;
    • Enter to cell Ji, Formula Y.
  2. Define the Named Variables:
    • Select columns A:H and do menu item Insert Name Create Name Top Row, OK. Then go to cell E2 and Insert Name Define Name Var (to cell $E$2 only, not the entire column).
  3. Enter the formulas:
    • Enter to cell A2, 3.
    • Enter to cell B2, 1.
    • Enter to cell C2, 3.
    • Enter to cell D2, .15 and Format Cell Number Number decimal places 2.
    • Enter to cell A3, =A2.
    • Enter to cell B3, =B2.
    • Enter to cell C3, =C2.
    • Enter to cell D3, =D2.
    • Edit Go To Cell Range A3:D22 and do menu item Edit Fill Down.
    • Enter to cell E2, 190.
    • Enter to cell F2, 0.
    • Enter to cell F3 the formula, =2*PI()/VAR.
    • Enter to cell F4 the formula, =2*PI()/VAR+F3.
    • Edit Go To Cell Range F4:F22 and do menu item Edit Fill Down.
    • Enter to cell G2, -0.2;
    • Enter to cell H2, -.005; ADJ_X and ADJ_Y move the entire curve left-right / up-down with respect to the central point of plot area fadial fill, which is from the center of the areola or nipple area. However, the box that the chart appear in may also be stretched, to gain other or similar effects.
    • Enter to cell I2 the formula, =(D*(A-B)*COS(t_t)+COS(C_C*((A-B)*t_t/B)))+ADJ_X. This is an offshoot of the Rose Formula it's believed at present.
    • Enter to cell J2 the formula, =(D*(A-B)*SIN(t_t)-SIN(C_C*((A-B)*t_t/B)))+ADJ_Y. Likewise.

Chart the Basic Curve

  1. Select cell range I22:J22 and do Insert Chart or select Chart from the Ribbon, All, Scatter, Smoothed Line Scatter.
  2. Delete the Horizontal Lines, both Axes and the Legend using the Chart Layout sub-menu. # Resize the chart to be about 5.33 width and 5.18 height. This is the Basic Breast Curve.

Additional Formatting

  1. Use Line width (thinner), Shadow (very little in these examples), Glow (substituted for shadow), Radial Centered Gradients with 4-6 markers of distinct colors, etc. to achieve some of the effects seen here (by order of development):









Convert to 32 x 32 pixel size ICON file

  1. Do it this way on the Mac platform:
    • Create the Excel chart. Do a Copy and Paste Picture of it to your Saves Page, along with any variables info you wish to retain that you'd changed from its normal status, especially including the ADJ_X and ADJ_Y information which cannot only place the curve but also distort it.
    • Use the Media Box tool to draw a perfect square around the part of the image you wish to keep as an icon.
    • Use the Grab tool to grab a screen selection just inside the edges of the media tools box.
    • Copy it to the Clipboard and Open Preview.
    • In Preview, under File, select New from Clipboard.
    • Under Tools, select Adjust Size, and set the square to 32 x 32.
    • Export the file to your ICONS folder, or New Icons sub-folder.
    • You may choose to revert the changes to the original Preview doc, and keep it unshrunken, upon Close and Quit from Preview.
    • For you, here is the small actual file of icons and the larger, more visible version.



  2. Lastly, view the sort of message you can make by working on such icons of tenderness and loves for our mothers, sisters and daughters,

Related Articles

References

  • The image of the pink ribbon was found at http://uncyclopedia.wikia.com/wiki/File:Pink_ribbon.png in Google Images. It was grabbed and its background was subtracted by MS Excel's Layout Background tool. On the webpage appeared the note, "Permission is granted to copy, distribute, modify, huff and/or misuse this document under the terms of the GNU Free Documentation License. Or not. You decide." Feb. 5, 2015, 1 P.M.
Retrieved from "https://kipkis.com/index.php?title=Start_Making_a_Breast_Icon&oldid=327720"