Question: Solve the following problem/ Scenario below in a google excel sheet. I have a google excel sheet that is appending data from a google form.

Solve the following problem/ Scenario below in a google excel sheet.

I have a google excel sheet that is appending data from a google form. The data contains the laptop cart being requested(EX, laptop A, B, C D), the period that it is being used for(EX. Period 1, 2, 3,4), the date that the person is being the date(Ex. Monday to Friday)and the person's name request for the item(email). Note. Each person can select multiple items on the list

The second google sheet, it contains different table sheets for the corresponding laptop carts. I want to create a google excel sheet that appends the person's request information into the right laptop cart data sheet. For example, in excel sheet 1, a user request information from the google form to have access to laptop cart A period 1 and 2 on Monday. On the second excel sheet, I want to automate the process and add the person's name to the requested item on the table. (the person's name will appear on the laptop Cart A, Period 1 and 2 ).

Please make a google form sheet and the excel sheet to do the above.

The following is sheet 1

1 23 45 LO Timestamp A5/31/2022 9:40:18 Tuesday 5/31/2022 9:40:43 Monday 5/31/2022 9:41:29 Tuesday 5/31/2022 9:42:10 Monda The following is sheet 2 Period 12 34 56 78 Monday Tuesday Cart A Wednesday Thursday Friday

1 2 3 4 LO Timestamp A 5/31/2022 9:40:18 Tuesday 5/31/2022 9:40:43 Monday 5/31/2022 9:41:29 Tuesday 5/31/2022 9:42:10 Monday B Which Cart? BGH I C D What period? Period 5, Period 6 Period 7 Period 5 Period 3 E Email Address F F linalan1231@gmail.com F linalan1231@gmail.com F

Step by Step Solution

★★★★★

3.39 Rating (155 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock

In order to accomplish this task you will need to first create a Google Form to collect the information from users Which Cart What period and Email Address Once you have the form set up you can then l... View full answer

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Computer Network Questions!

Solve the following problem for x(t). * + 12x + 40x = 3 sin 5t x(0) = x (0) = 0

The following is the number of trips and the number of households by the number of persons per household and the level of household income in a given traffic zone. Persons/household. 1 2 3 5 or more...

Solve the following problem numerically from t = 0 to 3: dy/dx = - y + t2 y(0) = 1 Use the third-order RK method with a step size of 0.5.

The Doppler equation presented in the text is valid when the motion between the observer and the source occurs on a straight line, so that the source and observer are moving either directly toward or...

Document for Analysis: Weak E-Mail Message The following e-mail message suffers from a number of weaknesses discussed in this chapter. Your Task. Analyze the faults in the message. In teams or in a...

Credibility is a vital part of any start-ups persona. Whether a prospective customer in a for-profit context, or a prospective donor in a nonprofit context, its important that the company or...

(Pension Worksheet - Missing Amounts) Kramer Co. has prepared the following pension worksheet. Unfortunately, several entries in the worksheet are not decipherable. The company has asked your...

In this exercise, you learn how to create a list box that allows the user to select more than one item at a time. Open the Multi Solution.sln file contained in the VB2017\Chap05\Multi Solution...

Wally Los Gatos, owner of Wallys Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sells wallpaper and...

Ashkar Company ordered a machine on January 1, 2012, at an invoice price of $21,000. On the date of delivery, January 2, 2012, the company paid $6,000 on the machine, with the balance on credit at 10...

When we perform a partial F test, what are the complete and reduced models?

What are the different components of a time-series model? Discuss.

Evaluate the limit: lim x 6 x 2 - 3 x - 1 8 x - 6

a. Identify a health behavior (action) of yours that you would like to analyze this semester. The behavior can be a behavioral risk factor or a behavioral protective factor for disease or injury. b....

4. Use partial fractions to find the integral. Provide full details! (10] 1+r 2r - + - 2r dz.

The CSR addendum will include a brief discussion of the mission, vision, and values of the company; the impact of trends in corporate culture and social responsibility on business ideas; and the...

Discuss YUM from a strategic perspective, Information concerning recent changes in the firm is readily available online and should be accessed. Strategic issues should be discussed in "real-time."

Kathryne will be purchasing both glucose meters and testing strips for a medical office. The cost of a box of glucose test strips is $9.99 (x). Blood glucose meters have a direct cost of $24.99 (y)....

Given the equation 0.5x1 x2 = 9.5 1.02x1 2x2 = 18.8 (a) Solve graphically. (b) Compute the determinant. (c) On the basis of (a) and (b), what would you expect regarding the systems condition? (d)...

Integrate the following function both analytically and numerically. For the numerical evaluations use (a) Single application of, the trapezoidal rule; (b) Simpsons 1/3 rule; (c) Simpsons 3/8 rule;...

The divide and average methods, an old-time method for approximating the square root of any positive number ; can be formulated as x = x + a/x/2. Prove that this is equivalent to the Newton-Raphson...

=+b. SAS reports the following summary information for this data: The MEANS Procedure Analysis Variable:pressure Lower 95% Upper 95% CL for Mean CL for Mean Mean Std Error 36.1892782 39.0373884...

=+48. A more extensive tabulation of t critical values than what appears in this book shows that for the t distribution with 20 df, the areas to the right of the values .687, .860, and 1.064 are .25,...

=+b. Predict the mileage for a single Porsche Boxster in a way that conveys information about precision and reliability. How does the prediction compare to the estimate calculated in part (a)?