What function would one use to vertically look up data in a big data spreadsheet if both data sets have a matching component?
Vlookup. This formula find a portion of the data that one is looking for by matching it to that piece of data in the other sheet. It may then output a separate column. Hlookup is similar, but is oriented for horizontal searching.
How would you set up the following LP problem? A company sells two types of chairs, stained and unstained. The stained chairs require 4 units of wood and the unstained require 2. The stained chairs also require an extra hour of preparation where the unstained need only 1. Stained are sold for $50 and unstained $33.The company has 500 units of wood availiable and 1200 hrs to work on the chairs. Set up the problem
Stained = x1, Unstained = x2 Objective Function: 50x1 + 33x2 Decision Variables: Amount of stained to make, Amount of Unstained to Make Constraints: x1 * 4 + x2 * 2 <= 500 units Wood Constraint x1 * 2 + x2 <= 1200 hrs Time Constraint x1, x2 >= 0 Can not make negative chairs
How would you reverse a String?
An efficient way to reverse a String is to do so recursively. I would make a class using string.length() and string.substring() to continually narrow the string and the base case, or the way the code would stop performing the reverse, would be when the length of the string equals 1. At each occurrence of the class an empty string would have the new letter from the end of the old string concatenated to it. Also if the length equals one the string is already reversed technically.