tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mike_carson__27655__BrokerQuote(SouthEast)
Sheet: Sheet1

Broker | Prebon
Date | 2002-01-22 00:00:00
Time | 12.00PM |  |  |  | Please time stamp the quote sheet before sending back
ONPEAK |  |  |  |  |  |  |  | [NAME]
PRICE | SOUTHEAST |  |  |  |  |  |  | PRICE | SOUTHEAST
 | SOCO |  | Entergy |  |  |  |  |  | SOCO |  | Entergy
 | Bid | Offer | Bid | Offer |  |  |  |  | Bid | Offer | Bid | Offer
Dailies |  |  |  |  |  |  |  | Dailies
Next Week |  |  |  |  |  |  |  | Next Week
[NAME] |  |  | 18 | 19 |  |  |  | [NAME]
2002-02-02 00:00:00 |  |  | 18.55 | 18.65 |  |  |  | 2002-02-02 00:00:00
M/A 02 | 21.65 | 22.4 | 19.1 | 19.35 |  |  |  | M/A 02
2002-05-01 00:00:00 | 25 | 25.5 | 22 | 23 |  |  |  | 2002-05-01 00:00:00
2002-06-01 00:00:00 | 29.85 | 30.5 | 26.25 | 26.75 |  |  |  | 2002-06-01 00:00:00
Sum 02 | 38.75 | 39.25 | 33.8 | 34 |  |  |  | Sum 02
2002-09-01 00:00:00 | 23 | 23.4 | 21.25 | 21.5 |  |  |  | 2002-09-01 00:00:00
Q4 02 | 22.6 | 23 | 21.2 | 21.4 |  |  |  | Q4 02
Bal CAL-02 |  |  | 23.25 | 23.75 |  |  |  | CAL-02
W 03 |  |  | 23.75 | 24.5 |  |  |  | W 03
M/A 03 |  |  | 22.25 | 22.75 |  |  |  | M/A 03
2003-05-01 00:00:00 |  |  | 24.25 | 25 |  |  |  | 2003-05-01 00:00:00
2003-06-01 00:00:00 |  |  | 28.25 | 29.5 |  |  |  | 2003-06-01 00:00:00
Sum 03 |  |  | 34.25 | 35 |  |  |  | Sum 03
2003-09-01 00:00:00 |  |  |  |  |  |  |  | 2003-09-01 00:00:00
Q4 03 |  |  |  |  |  |  |  | Q4 03
CAL-03 |  |  | 26.25 | 26.7 |  |  |  | CAL-03
[NAME] |  |  |  |  |  |  |  | [NAME]
Cal-05 | 30.5 | 31.25 |  |  |  |  |  | Cal-05
Cal-06 |  |  |  |  |  |  |  | Cal-06
Cal-07-10 |  |  |  |  |  |  |  | Cal-04-06 | 21.5 | 22.5
Spreadsheet: 685998d1594307395-help-if-4-is-the-4th-character-replace-it-with-example-3-
Sheet: ATT

 | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | 19th | 20th | 21st | 22nd
0
1
2
3
4 |  |  |  | SALE DE | DELIVERY
5 |  |  |  | SALE AT | PICKUP
6 |  |  |  |  | EXPRESS
7
8
9
Spreadsheet: 60771d1261333944-how-to-compare-two-columns-and-enter-3rd-value-if-matched-example
Sheet: Sheet1

trial 1 | accuracy |  | trial 2 | accuracy
5 | 1 |  | 2
6 | 0 |  | 4
9 | 0 |  | 4
7 | 1 |  | 1
4 | 1 |  | 3
1 | 1 |  | 5
2 | 1 |  | 8
3 | 0 |  | 3
8 | 0 |  | 10
10 | 1 |  | 6
 |  |  | 6
 |  |  | 9
 |  |  | 2
 |  |  | 7
 |  |  | 5
 |  |  | 9
 |  |  | 8
 |  |  | 10
 |  |  | 1
Spreadsheet: darrell_schoolcraft__7303__imball0201
Sheet: Lonestar

 | 57245 |  | 500154
 | [NAME] |  | Pecos Del
Day | Measured | Scheduled | Measured | Scheduled
1 | -14 |  | -54985 | -54900
2 |  |  | -45523 | -45012
3 | -19469 | -20000 | -31996 | -29900
4 | -10157 | -10000 | -65915 | -65318
5 | -29699 | -29869 | -63672 | -63430
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  | 9686
2002-01-05 00:00:00
CBS $
 |  |  | 19943.24
Spreadsheet: 77377d1277856395-excel-2007-conditional-formatting-book1-5-
Sheet: Sheet1

Current date
MKT INITIALS | OS, SP, MS | RECEIVED | INDEX /TIERED | HEDGE # | EFFECTIVE DATE
JLK | OS | 2009-07-31 00:00:00 | INDEX |  | 2009-09-01 00:00:00
JLK | OS | 2009-10-29 00:00:00 | INDEX |  | 2009-11-01 00:00:00
JLK | OS | 2009-11-18 00:00:00 | INDEX |  | 2009-12-01 00:00:00
JLK | OS | 2009-07-31 00:00:00 | INDEX |  | 2009-10-01 00:00:00
JLK | OS | 2010-03-01 00:00:00 | TIERED | 4341 | 2010-05-01 00:00:00
JLK | OS | 2010-01-12 00:00:00 | INDEX |  | 2010-04-01 00:00:00
JLK | OS | 2010-01-12 00:00:00 | INDEX |  | 2010-04-01 00:00:00
JLK | OS | 2009-09-10 00:00:00 | TIERED | 4178 | 2009-10-01 00:00:00
JLK | OS | 2009-09-10 00:00:00 | INDEX |  | 2009-11-01 00:00:00
JLK | OS | 2010-01-12 00:00:00 | INDEX |  | 2010-02-01 00:00:00
JLK | OS | 2010-04-13 00:00:00 | INDEX |  | 2010-05-01 00:00:00
JLK | OS | 2008-12-08 00:00:00 | TIERED | 3659 3663 | 2009-04-01 00:00:00
JLK | OS | 2008-12-08 00:00:00 | TIERED | 2799 | 2009-04-01 00:00:00
JLK | OS | 2010-03-02 00:00:00 | TIERED | 4347 | 2010-04-01 00:00:00
JLK | OS | 2009-08-26 00:00:00 | TIERED | 4153 | 2009-11-01 00:00:00
JLK | OS | 2009-06-05 00:00:00 | INDEX |  | 2009-07-01 00:00:00
JLK | OS | 2010-04-13 00:00:00 | INDEX | NA | 2010-06-01 00:00:00
JLK |  | 2010-05-26 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-06-21 00:00:00 | TIERED | 301788 | 2010-07-01 00:00:00
JLK |  | 2010-06-21 00:00:00 | TIERED | 301791 | 2010-07-01 00:00:00
JLK |  | 2010-05-26 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-05-26 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-05-26 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-05-26 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-05-22 00:00:00 | INDEX |  | 2010-07-01 00:00:00
JLK |  | 2010-05-27 00:00:00 | INDEX |  | 2010-08-01 00:00:00
JLK |  | 2010-05-27 00:00:00 | INDEX |  | 2010-08-01 00:00:00
JLK |  | 2010-05-25 00:00:00 | INDEX |  | 2010-08-01 00:00:00
JLK |  | 2010-05-21 00:00:00 | INDEX |  | 2011-01-01 00:00:00
Spreadsheet: 599002d1542816451-looking-for-dashboard-dashboard_cd
Sheet: Dashboard

Employee in WD | Name | Exists in WD? | Exists in AD? | Status
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West - Orig

 | West Gas - Orig
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp |  | ADJUSTED
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002 |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  | 1087020 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates |  |  |  |  |  | 0 |  |  |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  | 217404 | Other
ENAEMPEX | Employee Expense |  |  |  |  |  | 78000 |  |  |  |  |  | 65000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  | 300000 | Total |  |  |  |  | 250000
ENAOUTSV | Outside Services |  |  |  |  |  | 0 |  |  |  |  |  | 0
ENASUPP | Supplies Expense |  |  |  |  |  | 19029.6
ENAMKTEX | Marketing |  |  |  |  |  | 0 | Intern | 33000 |  |  |  | 0
ENACONTR | Charitable Contributions |  |  |  |  |  | 0 | [NAME] | 48400 | 0 |  |  | 0
ENARENT | Rent |  |  |  |  |  | 120000 | Staff | 49500 | 0 |  |  | 100000
ENATECH | Technology |  |  |  |  |  | 36000 | Specialist | 57750 | 0 |  |  | 30000
ENATRANS | Transportation |  |  |  |  |  | 1.2 | Sr. Specialist | 71500 | 1 |  |  | 1
ENAOTHEX | Other Expenses |  |  |  |  |  | 12000 | Analyst | 60500 | 0 |  |  | 10000
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 0 |  |  | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 1
 |  |  |  |  |  |  |  | Director | 143000
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 780360d1652425371-formula-reliant-on-number-value-to-populate-different-cells-fmr-formulas
Sheet: Sheet1

Replacement Cost | Remaining Life | Backlog | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
100 | -1 | 100
150 | 0 |  | 150
300 | 2 |  |  |  | 300
80 | 4 |  |  |  |  |  | 80
20 | 8
Required Formula | --->
Spreadsheet: 289189d1389446316-extracting-data-from-the-spreadsheet-mainfile
Sheet: Rainbow

041820011 | Shot Fake | 6 | Rainbow | -
072020011 | [NAME] | 3 | Rainbow | -
100320001 | Shot Fake | 0 | Rainbow | -
081220001 | [NAME] | 2 | Rainbow | 0
021420021 | Shot Fake | 5 | Rainbow | -
072420011 | Shot Fake | 0 | Rainbow | 0
061920011 | Shot Fake | 0 | Rainbow | 0
041820011 | Shot Fake | 6 | Rainbow | -
072020011 | [NAME] | 3 | Rainbow | -
100320001 | Shot Fake | 0 | Rainbow | -
081220001 | [NAME] | 2 | Rainbow | 0
021420021 | Shot Fake | 5 | Rainbow | -
041820011 | Shot Fake | 6 | Rainbow | -
072020011 | [NAME] | 3 | Rainbow | -
100320001 | Shot Fake | 0 | Rainbow | -
081220001 | [NAME] | 2 | Rainbow | 0
021420021 | Shot Fake | 5 | Rainbow | -
Spreadsheet: 30976d1226671098-calculating-straight-time-and-overtime-time-form
Sheet: Sheet1

 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Straight Time Hours | Over Time Hours | Total    Hours
 | Start Time | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00 | 18:00:00
 | Stop Time | 06:00:00 | 06:00:00 | 06:00:00 | 06:00:00 | 06:00:00 | 06:00:00 | 06:00:00
 | S/T Hours |  |  |  |  |  |  |  | 0 | 0 | 0
 | O/T Hours
Spreadsheet: 337f69b3-d7e7-445a-92b9-b51a9ecd69cd
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HD1 | Test | HD1 | House Dust Panel | House Dust Panel | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top	 Acceptable: Serum gel [NAME]: 0.5 mL	 Additional Information: See Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
HD1 | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
HD1 | Result | HD1 | House Dust Panel | House Dust Panel | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 37987-5 | ([NAME] germanica+Dermatophagoides farinae+Dermatophagoides pteronyssinus+House dust [NAME]) Ab.IgE:ACnc:Pt:Ser:Qn:Multidisk
Spreadsheet: 93374d1292960610-help-with-dynamic-dependent-validation-lists-depdataval
Sheet: Raw Data

 | Subtrades
 | [NAME] | Paint Shop | [NAME]'s |  |  | [NAME]
Products | Wall Fixer | Red Paint | Plywood |  |  | Paint Shop
 | Duct Wrap | Blue Paint | Plywood 2/3 |  |  | [NAME]'s
 | Red Paint | Green Paint | Oakwood
 | Blue Paint | Orange Paint | Adhesive
Spreadsheet: 838446d1691011421-help-with-formula-maybe-sumifs-ret_eng
Sheet: Returns April - June

Order ID | SKU | Quantity
108 | ABC1 | 1
116 | [NAME] | 1
117 | [NAME] | 1
118 | [NAME] | 1
119 | [NAME] | 1
125 | ABC3 | 2
121 | [NAME] | 1
123 | ABC5 | 2
133 | ABC1 | 1
145 | [NAME] | 1
139 | [NAME] | 1
166 | [NAME] | 1
154 | [NAME] | 2
191 | ABC3 | 1
180 | [NAME] | 2
179 | ABC5 | 2
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Badih

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 50,000 to 60,000 | 0.1
 |  | [NAME] or 70000 | 0.12
 |  | [NAME] or 80000 | 0.15
 |  | [NAME] or 90000 | 0.18
 |  | Tier 5 - 90,001 or 100000 | 0.19
 |  | Tier 6 -100,001 and above | 0.2
Doctor Calculation
 |  | Gross Revenue
 |  | Doctor Revenue Dental Procedure | 53903.99000000001
 |  | Clinic Fees 5%
 |  | Dental Lab
 |  | OR Fee
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Doctor Revenue (Dental Items Oral) | 0
 |  | Amount to be Paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 96976d1296208439-prevent-cells-selction-of-conditionally-formatted-hidden-cells-new-invoice-template
Sheet: Pro-Forma Invoice

VAT INVOICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Invoice Date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME].
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Licence Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Commencing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Payment Method
[NAME] |  |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Unit Price |  |  |  | Qty |  | Total Cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Order Value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Promotional Discount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT @ 20.0%
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Payable
Payment Schedule
Installment Date |  |  |  |  |  |  |  |  | Net Amount |  |  |  |  |  |  |  |  | VAT |  |  |  |  |  |  | Total
Spreadsheet: 49355d1248709716-sum-numbers-from-a-table-totals10
Sheet: Sheet1

 |  | In the attached sample spreadsheet, I would like to know if there is a formula to
Details |  | calculate the total quantities in Column B for each Number in Column D.
 |  | I would like to create a seperate worksheet in this spreadsheet that would list each Number only once,
Company | Chevy | since there is more than one of each in Column D, and then the total of the Quanity for that Number.
Department Number |  |  |  |  |  | Invoice Date
Program Director | [NAME] |  |  |  |  | 2008-07-29 00:00:00
 |  |  |  |  |  | 6/22 - 7/19/2008
 | Quantity | Type of Hours |  | Item Description | Rate | Ext. Price
 | 36.55 | Alpha | 850691 | Franklin | 78 | 4340.64
 | 44.25 | Beta | 850691 | Franklin | 125 | 465
 | 80 | Alpha | 850691 | Franklin | 105 | 3125
 | 3 | Beta | 855216 | [NAME] | 75 | 4625.21
 | 18.4 | Alpha | 855663 | Tesla | 105 | 13658
 | 3.64 | Alpha | 855663 | Tesla | 150 | 3125
 | 87.2 | Beta | 812613 | Edison | 105 | 1549.52
 | 22 | Alpha | 855662 | Appleton | 105 | 13.675
 | 3.4 | Alpha | 856885 | [NAME] | 78 | 395.92
 | 7 | Alpha | 857032 | [NAME] | 78 | 9344
 | 42 | Alpha | 776237 | Crazy Horse | 78 | 2543.32
 |  |  |  |  |  | 43185.285
Company | Ford
Department Number
Program Director | [NAME] |  |  |  |  | Invoice Date
 |  |  |  |  |  | 2008-07-31 00:00:00
 | Quantity | Type of Hours |  | Item Description | Rate | 6/22 - 7/26/2008
 | 1.5 | Alpha | 854326 | Oneida | 60 | 465
Spreadsheet: 869413d1715978243-top-25-then-next-25-and-so-on-quartile-agents-calculation
Sheet: Sheet1

 |  | # | Agents | January | Quartile | February | Quartile | March | Quartile | April | Quartile
 |  | 1 | Emma | 10 |  | 90 |  | 89 |  | 100 |  |  | For each quartile I want to split the agent in 25% based on results
 |  | 2 | Olivia | 5 |  | 81 |  | 52 |  | 32 |  |  | I'm looking for the formula that will help me to dicide all agents by 25 % buckets
 |  | 3 | [NAME] | 8 |  | 4 |  | 17
 |  | 4 | Ava | 7 |  | 31 |  | 24 |  | 29
 |  | 5 | Sophia | 4 |  | 33
 |  | 6 | Emily | 9 |  | 44 |  | 27
 |  | 7 | [NAME] | 4 |  | 47 |  | 39 |  | 28
 |  | 8 | [NAME] | 8 |  | 12 |  | 58 |  | 37
 |  | 9 | [NAME] | 6 |  | 16
 |  | 10 | [NAME] | 7 |  | 14 |  | 24
 |  | 11 | Chloe | 11 |  | 30 |  | 39 |  | 44
 |  | 12 | Ella | 20 |  | 22 |  | 27 |  | 32
 |  | 13 | Lily | 25
 |  | 14 | Amelia | 7 |  | 25 |  | 59 |  | 67
 |  | 15 | Grace | 30
 |  | 16 | Charlotte | 50 |  | 27 |  | 47 |  | 48
 |  | 17 | [NAME] | 62 |  | 29 |  | 18 |  | 33
 |  | 18 | Avery | 42 |  | 44
 |  | 19 | [NAME] | 83 |  | 75 |  | 14 |  | 50
 |  | 20 | Samantha | 24 |  | 31 |  | 78 |  | 38
 |  | 21 | Alexis | 25 |  | 33 |  | 39 |  | 61
 |  | 22 | [NAME] | 91 |  | 78 |  | 55 |  | 64
 |  | 23 | Alyssa | 30 |  | 14 |  | 27 |  | 54
 |  | 24 | [NAME] | 80 |  | 67 |  | 40
 |  | 25 | Addison | 84
 |  | 26 | Sofia | 2 |  | 12 |  | 35 |  | 38
 |  | 27 | Hailey | 6 |  | 33 |  | 38 |  | 47
 |  | 28 | Zoe | 9 |  | 14 |  | 22 |  | 50
 |  | 29 | Anna | 12 |  | 60
 |  | 30 | Victoria | 51
 |  | 31 | Riley | 60 |  | 58 |  | 55 |  | 36
 |  | 32 | Harper | 40 |  | 33
 |  | 33 | Lauren | 43 |  | 48 |  | 50 |  | 38
 |  | 34 | Savannah | 15 |  | 27 |  | 33 |  | 60
 |  | 35 | [NAME] | 24 |  | 35 |  | 49 |  | 59
 |  | 36 | Ellie | 22 |  | 40 |  | 55 |  | 34
 |  | 37 | Kayla | 62 |  | 55 |  | 40 |  | 18
 |  | 38 | Sydney | 17 |  | 22 |  | 23
 |  | 39 | Layla | 19 |  | 21 |  | 47 |  | 27
 |  | 40 | Julia | 34 |  | 48 |  | 55 |  | 28
Spreadsheet: 870540d1717047640-how-to-transpose-columns-to-rows-until-a-value-changes-flip-and-summarize-resaved
Sheet: Sheet1

Fruit | Values | desired
apple | 10 | 1
apple | 20
banana | 30
banana | 40
banana | 50
banana | 60
banana | 70
banana | 80
banana | 90
banana | 100
orange | 110
orange | 120
orange | 130
orange | 140
Spreadsheet: 684077d1593127958-data-analysis-on-variance-reporting-wanted-maybe-pivot-tables-shifts-and-targets-taranakigirl-
Sheet: Pivot Table

Date | Shift Code | Actual Hours | Required Hours | Day of the week | [NAME] | % Variance
2020-06-01 00:00:00 | A | 63 | 44.49994 | Monday | -18.50006 | 0.293651746031746
 | N | 31.5 | 25.08335 | Monday | -6.416650000000001 | 0.2037031746031747
2020-06-02 00:00:00 | A | 53 | 44.62504 | Tuesday | -8.374960000000002 | 0.1580181132075472
2020-06-03 00:00:00 | N | 43.25 | 34.91672 | Wednesday | -8.333280000000002 | 0.1926769942196532
2020-06-04 00:00:00 | A | 57 | 40.25002 | Thursday | -16.74998 | 0.2938592982456141
 | N | 36 | 19.50001 | Thursday | -16.49999 | 0.4583330555555556
2020-06-05 00:00:00 | A | 49 | 41.22919 | Friday | -7.770809999999997 | 0.1585879591836734
 | N | 31 | 23.83335 | Friday | -7.166650000000001 | 0.2311822580645162
2020-06-08 00:00:00 | A | 78 | 63.41669 | Monday | -14.58331 | 0.1869655128205128
 | N | 46 | 40.00005 | Monday | -5.999949999999998 | 0.1304336956521739
2020-06-09 00:00:00 | A | 65 | 56.33339 | Tuesday | -8.666609999999999 | 0.1333324615384616
2020-06-10 00:00:00 | A | 70 | 56.00004 | Wednesday | -13.99996 | 0.1999994285714286
 | N | 47 | 37.00002 | Wednesday | -9.99998 | 0.2127655319148937
Spreadsheet: 140874d1328915577-automatically-add-totals-book1
Sheet: Sheet1

Date | Amount | Week Sum | Helper column
2012-02-06 00:00:00 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 22
Spreadsheet: 465911d1465938801-using-the-results-of-dropdown-lists-to-record-and-calculate-the-contents-of-another-cell-test
Sheet: Smith

Date | Type of Expense | Type of Work | Reason | Cost | Reference | Date of Claim | Notes | Expenses Breakdown
2016-01-01 00:00:00 | Rail | Tests | Free Text | 62.5 | Free Text | 2016-01-01 00:00:00 | Free Text | Tests Work
2016-01-02 00:00:00 | Expenses | Tests | Free Text | 25 | Free Text | 2016-01-02 00:00:00 | Free Text | Visits Work
2016-01-03 00:00:00 | Hotel | Tests | Free Text | 198 | Free Text | 2016-01-03 00:00:00 | Free Text | Audits Work
2016-01-04 00:00:00 | Car Related | Visits | Free Text | 43 | Free Text | 2016-01-04 00:00:00 | Free Text | Training
2016-01-05 00:00:00 | Expenses | Visits | Free Text | 4.65 | Free Text | 2016-01-05 00:00:00 | Free Text | Total:
2016-01-06 00:00:00 | Rail | Audit | Free Text | 89.1 | Free Text | 2016-01-06 00:00:00 | Free Text | Rail (Tests)
2016-01-07 00:00:00 | Expenses | Audit | Free Text | 17.8 | Free Text | 2016-01-07 00:00:00 | Free Text | Rail (Visits)
2016-01-08 00:00:00 | Hotel | Audit | Free Text | 250 | Free Text | 2016-01-08 00:00:00 | Free Text | Rail (Audits)
2016-01-09 00:00:00 | Other Travel | Tests | Free Text | 345 | Free Text | 2016-01-09 00:00:00 | Free Text | Rail (Training)
2016-01-10 00:00:00 | Expenses | Tests | Free Text | 43.75 | Free Text | 2016-01-10 00:00:00 | Free Text | Rail (Total)
2016-01-11 00:00:00 | Hotel | Visits | Free Text | 657 | Free Text | 2016-01-11 00:00:00 | Free Text | Other Travel (Tests)
2016-01-12 00:00:00 | Car Related | Training | Free Text | 87.99 | Free Text | 2016-01-12 00:00:00 | Free Text | Other Travel (Visits)
2016-01-13 00:00:00 | Expenses | Training | Free Text | 5.67 | Free Text | 2016-01-13 00:00:00 | Free Text | Other Travel (Audits)
2016-01-14 00:00:00 | Hotel | Training | Free Text | 89 | Free Text | 2016-01-14 00:00:00 | Free Text | Other Travel (Training)
2016-01-15 00:00:00 | Rail | Visits | Free Text | 75.45 | Free Text | 2016-01-15 00:00:00 | Free Text | Other Travel (Total)
2016-01-16 00:00:00 | Hotel | Training | Free Text | 175 | Free Text | 2016-01-16 00:00:00 | Free Text | Car Related (Tests)
2016-01-17 00:00:00 | Rail | Training | Free Text | 56 | Free Text | 2016-01-17 00:00:00 | Free Text | Car Related (Visits)
2016-01-18 00:00:00 | Expenses | Visits | Free Text | 32 | Free Text | 2016-01-18 00:00:00 | Free Text | Car Related (Audits)
 |  |  |  |  |  |  |  | Car Related (Training)
 |  |  |  |  |  |  |  | Car Related (Total)
 |  |  |  |  |  |  |  | Expenses (Tests)
 |  |  |  |  |  |  |  | Expenses (Visits)
 |  |  |  |  |  |  |  | Expenses (Audits)
 |  |  |  |  |  |  |  | Expenses (Training)
 |  |  |  |  |  |  |  | Expenses (Total)
 |  |  |  |  |  |  |  | Hotel (Tests)
 |  |  |  |  |  |  |  | Hotel (Visits)
 |  |  |  |  |  |  |  | Hotel (Audits)
 |  |  |  |  |  |  |  | Hotel (Training)
 |  |  |  |  |  |  |  | Hotel (Total)
Spreadsheet: 831937d1686003138-calculating-production-and-down-time-book1
Sheet: Prod Time

 | Product 1 | Product 1 |  | Product 2 | Product 2 |  | Product 3 | Product 3 |  | Product 4 | Product 4
 | Run | Down |  | Run | Down |  | Run | Down |  | Run | Down
Begin | 07:00:00 | 09:30:00 |  | 04:20:00 | 12:20:00 |  | 13:10:00 | 13:35:00
End | 09:30:00 | 10:48:00 |  | 12:20:00 | 13:10:00 |  | 13:35:00 | 13:45:00
Begin | 10:48:00 | 14:21:00 |  |  |  |  | 13:45:00 | 18:20:00
End | 14:21:00 | 16:20:00 |  |  |  |  | 18:20:00 | 19:00:00
Begin
End
Begin
End
Begin
End
Begin
End
Begin
End
Begin
End
Begin
End