In this exercise we will format our table to improve readability and highlight important data. This will build off of the Google sheet of movie data we created in the last exercise.
Review Last Exercise
Open your spreadsheet from the last exercise and review we accomplished.
Continue to use your spreadsheet for this exercise. If you missed the last exercise and need to jump into this one, use this link below and make a copy of the template spreadsheet. 🔗Spreadsheet 2 Exercise
Basic Formatting
Select the column names at the top of the spreadsheet, cells A1:I1. Format names with a blue background and white bold text.
Select the paint can icon and choose a dark blue color for the background.
Select the text icon ("A") and choose white for the text.
Select the Bold icon ("B") to emphasize the text
Select the budget, revenue, and profit columns and format as currency by selecting the $ icon. Then round to the nearest dollar by reducing the decimal places. Find the button below in the toolbar and click it 2 times to remove the cents from the dollar amount.
Decrease the decimals in the vote averages you generated from last week. Select the values of All Movies Vote Average and All Drama Vote Average. Round the values to the nearest decimal point (see 2. above).
Conditional Formatting
Select profit column. Let's color-code this column so that any movies that lost money are highlighted in red and any movies that made at least $1 billion are highlighted in green.
Select Format > Conditional Formatting in the top menu bar.
For movies that made at least $1 billion dollars, change the format rules in the side panel as shown below. Select Done when you are finished.
Click on +Add another Rule in the side panel. For movies that lost $, change the format rules as shown below. Select Done when you are finished.
Which movie has the highest profit? Lowest?
✔️Individual Deliverable: Submit a Shareable Link to Your Spreadsheet
Precision and Repeatability / Grabbing and Releasing Objects
Demo
Initializing the Set Up (Basic)
Add a Home Point: Add a Point Node and set the point position for our home point. Center it at a high level above the working surface.
Move Towards and Grab the Test Object
Move to Position Above Object: Add a Point Node above the object such that the gripper is positioned to drop downward to grab the object.
Move into a "Grabbing" Position: Add another Point Node or a Move Node that brings the gripper down into a position for grabbing the object.
Grab the Object: Add a Grip Node to grip the object.
Evaluate Precision: Evaluate how well the gripping motion worked. Does it produce a firm grip on the object? Did the grip action cause the object to move or shift unnecessarily? Refine the flow if needed.
Move the Object to the Destination and Release It
Move object up: Add a Point Node or a Move Node that brings the object up to clear any constraints (like a containing box).
Move Object to Point Above Destination: Add another Point Node or a Move Node that moves the object above the destination, clear of any obstacles etc.
Move into a "Releasing" Position: Add another Point Node or a Move Node that brings the gripper down into a position for releasing the object.
Release the Object: Add a Release Node to release the object.
Evaluate Precision: Evaluate how well the release motion worked. Does it position the object accurately? Did the release action cause the object to move or shift unnecessarily? Refine the flow if needed.
Loop Back to Home Point
Loop to the Home Point: Use a Goto Node to return the flow to our home point.
Challenge
In groups discuss how you will program a flow to grab and move an object similar to the demo.
Program the cobot flow, step-run the flow, and run the flow from the start.
Discuss questions and possible adaptions to techniques. How easy would it be to adapt your flow to work with different starting and ending positions?
