Problems 1. Set up the solution to the problem stated in the book, but solve for values of tension in cable B ranging from 500 N to 3000 N in increments of 500 N. Create a table of results and plot the angle vs tension in cable B. Assume that the cables are attached to the weights rather than a passing through loops attached to the weights. Show the force balance equations you use for answering the questions, - noting that the vertical AND horizontal forces acting on each weight must EACH sum to zero. Check your logic using your previous solution with a different angle.
Problem 2. You will need to read problem 8 to get the formulae needed for problem. The volume of the cone section uses a different equation than the volume of the cylindrical section. The challenge is to create a formula that includes the logic to calculate the correct volume at any height - in either the conical or cylindrical section. This will include an "if" function to determine if the height is above or below the top of the cone section. The radius of the tank varies with height in the cone section but is fixed in the cylindrical section. Your solution MUST produce correct results if you change the height or diameter of the cone - without needing to change any other cells. Thus your if function should compare the current height to the height of the cone section (in a data cell, not typed into the formula) and provide the necessary volume formula.Use a conical section diameter of 3 meters and a total height of 12 meters rather than the values in the book. Your solution should be set up to allow changing these easily.
Problem 3. Set up the problem so you can easily vary the temperature and the volume per mole. Consider the use of a spinner or a scroll bar to change one of these. Your solution should automatically adjust when the inputs are changed.
Problem 4. Using text manipulation functions, create a table which fills in the data about a student's schedule.