tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 40388d1238693006-transposing-grades-grades-sample
Sheet: Sheet2

 |  | 1
2008-2009 | Grades | Student A
 | AVG (with lowest grade dropped) | 86.33333333333333
 | FINAL AVG | 87.63333333333333
Date | Grade | B
2008-08-12 00:00:00 | Assignment 1 | 100 | 100 |  |  |  |  | 1
2008-08-13 00:00:00 | Assignment 2 | 100 | 100 |  |  |  |  | 2
2008-08-14 00:00:00 | Assignment 3 | 100 | 100 |  |  |  |  | 3
2008-08-15 00:00:00 | Assignment 4 | 100 | 100 |  |  |  |  | 4
2008-08-15 00:00:00 | Assignment 5 | - | - |  |  |  |  | 5
2008-08-18 00:00:00 | Assignment 6 | 100 | 100 |  |  |  |  | 6
2008-08-19 00:00:00 | Assignment 7 | 100 | 100 |  |  |  |  | 7
2008-08-20 00:00:00 | Assignment 8 | 100 | 100 |  |  |  |  | 8
2008-08-21 00:00:00 | Assignment 9 | 100 | 100 |  |  |  |  | 9
2008-08-22 00:00:00 | Assignment 10 | 100 | 100 |  |  |  |  | 10
2008-08-25 00:00:00 | Assignment 11 | 70 | 70 |  |  |  |  | 11
2008-08-26 00:00:00 | Assignment 12 | 100 | 100 |  |  |  |  | 12
2008-08-27 00:00:00 | Assignment 13 | 100 | 100 |  |  |  |  | 13
2008-08-27 00:00:00 | Assignment 14 | 38 | 38 |  |  |  |  | 14
2008-08-28 00:00:00 | Assignment 15 | 90 | 90 |  |  |  |  | 15
2008-08-28 00:00:00 | Assignment 16 | 39 | 39 |  |  |  |  | 16
2008-08-29 00:00:00 | Assignment 17 | 83 | 83 |  |  |  |  | 17
2008-09-02 00:00:00 | Assignment 18 | 80 | 80 |  |  |  |  | 18
2008-09-03 00:00:00 | Assignment 19 | 100 | 100 |  |  |  |  | 19
2008-09-03 00:00:00 | Assignment 20 | 70 | 70 |  |  |  |  | 20
2008-09-04 00:00:00 | Assignment 21 | 80 | 80 |  |  |  |  | 21
2008-09-05 00:00:00 | Assignment 22 | 70 | 70 |  |  |  |  | 22
2008-09-08 00:00:00 | Assignment 23 | 100 | 100 |  |  |  |  | 23
2008-09-10 00:00:00 | Assignment 24 | 80 | 80 |  |  |  |  | 24
2008-09-12 00:00:00 | Assignment 25 | 95 | 95 |  |  |  |  | 25
2008-09-15 00:00:00 | Assignment 26 | 70 | 70 |  |  |  |  | 26
2008-09-16 00:00:00 | Assignment 27 | 90 | 90 |  |  |  |  | 27
2008-09-17 00:00:00 | Assignment 28 | 70 | 70 |  |  |  |  | 28
2008-09-18 00:00:00 | Assignment 29 | 70 | 70 |  |  |  |  | 29
2008-09-19 00:00:00 | Assignment 30 | 95 | 95 |  |  |  |  | 30
2008-09-22 00:00:00 | Assignment 31 | 70 | 70 |  |  |  |  | 31
2008-09-23 00:00:00 | Assignment 32 | 70 | 70 |  |  |  |  | 32
2008-09-24 00:00:00 | Assignment 33 | 89 | 89 |  |  |  |  | 33
2008-09-25 00:00:00 | Assignment 34 | 92 | 92 |  |  |  |  | 34
2008-09-26 00:00:00 | Assignment 35 | 90 | 90 |  |  |  |  | 35
2008-10-01 00:00:00 | Assignment 36 | 87 | 87 |  |  |  |  | 36
2008-10-02 00:00:00 | Assignment 37 | 75 | 75 |  |  |  |  | 37
2008-10-03 00:00:00 | Assignment 38 | 100 | 100 |  |  |  |  | 38
2008-10-06 00:00:00 | Assignment 39 | 80 | 80 |  |  |  |  | 39
2008-10-07 00:00:00 | Assignment 40 | 67 | 67 |  |  |  |  | 40
2008-10-08 00:00:00 | 9 Weeks Test | 95 | 95 |  |  |  |  | 41
Spreadsheet: 107140d1304356787-formula-for-balance-a-stack-rank-attainment-example
Sheet: Report Legend

March GOALS                            based on Stack Rank metrics | TR | PCS | 7 DAY | SPCA | AHT
LNG | 0.88 | 4.8 | 0.2 | 0.09 | 695
Weight | TR | PCS | 7 DAY | SPCA | AHT
LNG | 0.25 | 0.15 | 0.2 | 0.2 | 0.2
Spreadsheet: 747173d1631268799-index-match-with-if-book2-copy
Sheet: Main Sheet

Ref | Location | Use | Comments
1 | Leeds | Retail | Disposal
2 | [NAME] | Office | Acquisition
3 | Leeds | Industrial | Acquisition
4 | London | Hotel | Disposal
Spreadsheet: 35216d1232747034-percentage-question-weekly-qc-sheet
Sheet: QC Weekly

 | Weekly QC Sheet |  |  |  |  |  |  |  | McLaughlin Communications
 |  |  |  |  |  |  |  |  | Scranton Pa.
 | Week Of: |  | 2008-12-29 00:00:00 |  | Thru |  | 2009-01-04 00:00:00
Technician |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Job Comp % | Number of Jobs QC'd | Total Jobs QC'd % | Pass | Fail | QC Failure %
1 |  |  |  | 10 | 5 | 5 | 0.5
2 |  |  |  | 1 | 1 | 0 | 0
3 |  |  |  |  |  | 0 | #N/A
4 |  |  |  |  |  | 0 | #N/A
5 |  |  |  |  |  | 0 | #N/A
6 |  |  |  |  |  | 0 | #N/A
7 |  |  |  |  |  | 0 | #N/A
8 |  |  |  |  |  | 0 | #N/A
9 |  |  |  |  |  | 0 | #N/A
10 |  |  |  |  |  | 0 | #N/A
11 |  |  |  |  |  | 0 | #N/A
12 |  |  |  |  |  | 0 | #N/A
13 |  |  |  |  |  | 0 | #N/A
14 |  |  |  |  |  | 0 | #N/A
15 |  |  |  |  |  | 0 | #N/A
16 |  |  |  |  |  | 0 | #N/A
17 |  |  |  |  |  | 0 | #N/A
18 |  |  |  |  |  | 0 | #N/A
19 |  |  |  |  |  | 0 | #N/A
20 |  |  |  |  |  | 0 | #N/A
21 |  |  |  |  |  | 0 | #N/A
22 |  |  |  |  |  | 0 | #N/A
23 |  |  |  |  |  | 0 | #N/A
24 |  |  |  |  |  | 0 | #N/A
25 |  |  |  |  |  | 0 | #N/A
Spreadsheet: 587188d1534883500-finding-unique-not-duplicates-values-using-index-and-multiple-criteria-mock-calcs
Sheet: Captain America (2)

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Biweekly Time Sheet
 | Please Input Job # for each week in Red Boxes to calculate hours and LOA: |  |  |  |  |  |  |  |  | Pay period start date:
 |  |  |  |  |  |  |  |  |  | Pay period end date:
 | Employee: |  | Captain America
 | WEEK 1 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 | WEEK 2 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total | Total | Total
 |  | 2018-08-20 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 26-Aug-18
 | Job # | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | REG | OT | Hours
 |  |  |  |  |  |  |  | 8
 | LOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total LOA
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Totals
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET Hours
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NET LOA
Spreadsheet: 83948d1283970020-excel-2007-largest-3-numbers-for-category-744939_dhuvar
Sheet: Sheet1

City | SalesPerson | Amount |  | City | a |  | All Cities
a | D | 28
c | W | 74
d | S | 95
t | F | 92 |  | SalesPerson | F |  | SalesPerson | D
d | S | 24 |  |  |  |  | City | d
a | W | 70
t | F | 6
c | D | 100
g | S | 47
n | S | 57
j | F | 41
d | W | 39
s | F | 4
t | F | 4
g | D | 40
n | S | 66
a | D | 36
d | F | 61
Spreadsheet: 217217d1362003506-seeking-a-summary-table-using-only-formulas-deceptor
Sheet: Sheet1

48" | 22 | 48"
48" | 22 | 45"
48" | 22
45" | 20.6
45" | 20.6
45" | 20.6
0" | 0
0" | 0
0" | 0
Spreadsheet: 485493d1476903911-how-to-best-organise-data-in-pivot-table-hr-dashboard-2
Sheet: Calculations

Year | Employee | Year | Department | Year |  | Year |  | Year | Location | [NAME] | Employee Count | Year | Base Salary
2000 |  | 2000 |  | 2000 |  | 2000 |  | 2000 |  | <$30,000 |  |  | <30000
2001 |  | 2001 |  | 2001 |  | 2001 |  | 2001 |  | $30,000-$40,000 |  |  | <40000
2002 |  | 2002 |  | 2002 |  | 2002 |  | 2002 |  | $40,000-$50,000 |  |  | <50000
2003 |  | 2003 |  | 2003 |  | 2003 |  | 2003 |  | $50,000-$60,000 |  |  | <60000
2004 |  | 2004 |  | 2004 |  | 2004 |  | 2004 |  | $60,000-$70,000 |  |  | <70000
2005 |  | 2005 |  | 2005 |  | 2005 |  | 2005 |  | $70,000-$80,000 |  |  | <80000
2006 |  | 2006 |  | 2006 |  | 2006 |  | 2006 |  | $80,000-$90,000 |  |  | <90000
2007 |  | 2007 |  | 2007 |  | 2007 |  | 2007 |  | $90,000-$100,000 |  |  | <100000
2008 |  | 2008 |  | 2008 |  | 2008 |  | 2008 |  | >$100,000 |  |  | <200000
Department | Salary | Bonus | Overtime | Commission | Total | Number of Employees | Average Salary | Total Sick Days | Average Sick Days | Year | Department
Accounting |  |  |  |  |  |  |  |  |  |  | Accounting
Administration |  |  |  |  |  |  |  |  |  |  | Administration
Customer Support |  |  |  |  |  |  |  |  |  |  | Customer Support
Finance |  |  |  |  |  |  |  |  |  |  | Finance
Human Resources |  |  |  |  |  |  |  |  |  |  | Human Resources
IT |  |  |  |  |  |  |  |  |  |  | IT
Marketing |  |  |  |  |  |  |  |  |  |  | Marketing
R&D |  |  |  |  |  |  |  |  |  |  | R&D
Sales |  |  |  |  |  |  |  |  |  |  | Sales
Location | Salary | Bonus | Overtime | Commission | Total | Number of Employees | Average Salary | Total Sick Days | Average Sick Days | Year | Location
Boston |  |  |  |  |  |  |  |  |  |  | Boston
Miami |  |  |  |  |  |  |  |  |  |  | Miami
Los Angeles |  |  |  |  |  |  |  |  |  |  | Los Angeles
Chicago |  |  |  |  |  |  |  |  |  |  | Chicago
New York |  |  |  |  |  |  |  |  |  |  | New York
Employee Information
Name |  | 0 | 2000
Hire Date |  | 1 | 2001
Location |  | 2 | 2002
Termination Date |  | 4 | 2003
Employment Type |  | 5 | 2004
Year |  | 6 | 2005
Base Salary |  | 7 | 2006
Bonus |  | 8 | 2007
Overtime |  | 9 | 2008
Commission |  | 10
Total Compensation |  | 11
Department |  | 12
PTO Days |  | 13
Sick Days |  | 14
Performance Score |  | 15
Spreadsheet: 866034d1712959952-adding-year-to-date-data-based-on-selected-month-test-file
Sheet: Sheet1

Performance dashboard - Actual vs. Budget |  |  |  |  |  |  |  |  |  |  |  |  | February
 | January |  |  | February |  |  | March |  |  | April |  |  | May |  |  | June
 | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget | % | Actual | Budget |  | Actual | Budget | % | Actual | Budget | %
Sales
A | 3 | 5 |  | 8 | 7 |  | 7 | 8 |  |  | 9 |  |  | 10 |  |  | 11
B | 4 | 6 |  | 6 | 8 |  | 6 | 4 |  |  | 4 |  |  | 5 |  |  | 6
C | 7 | 3 |  | 7 | 5 |  | 13 | 16 |  |  | 18 |  |  | 20 |  |  | 23
D | 4 | 4 |  | 6 | 6 |  | 12 | 8 |  |  | 9 |  |  | 10 |  |  | 11
E | 2 | 7 |  | 3 | 4 |  | 17 | 16 |  |  | 18 |  |  | 20 |  |  | 23
Total
Spreadsheet: 07385571-d0e8-40fd-8187-22bc798610a3
Sheet: OCI

(Currency - in Thousands of New Turkish Lira ("TL") unless otherwise indicated)
 |  | Current Period |  | Prior Period
 |  | (Reviewed) | (Not reviewed) | (Reviewed) | (Not reviewed)
 |  | 1 January 2011 - | 1 April 2011 - | 1 January 2010 - | 1 April 2010 -
 |  | 30 June 2011 | 30 June 2011 | 30 June 2010 | 30 June 2010
 | Notes
Profit for the period |  | 1032455 | 461166 | 1066981 | 563293
Other comprehensive income:
Profit /(loss)  from derivative financial instruments transferred to consolidated income statement | 14 | 17076 | 4201 | 59695 | 28843
Change in fair value of  derivative financial instruments | 14 | -5634 | -5207 | -20679 | -10027
Change in fair value of net investment hedge for the subsidiary on abroad |  | -34559 | -22821 | - | -
Change in currency translation differences |  | 25748 | 15369 | -401 | -357
Actuarial loss arising from employee benefits |  | -19889 | -19889 | - | -
Deferred tax effect of actuarial gain / (loss) |  | 4071 | 4071 | - | -
Other comprehensive income/(loss) (after tax) |  | -13187 | -24276 | 38615 | 18459
Total comprehensive income |  | 1019268 | 436890 | 1105596 | 581752
Distribution of total comprehensive income:
Attributable to equity holders of the parent |  | 1099421 | 481639 | 1178622 | 615974
Minority interest |  | -80153 | -44749 | -73026 | -34222
Spreadsheet: 582188d1531769772-multiple-lookup-results-multiple-look-ups_result-to-one-column
Sheet: Sheet1

Name | Country | [NAME]
[NAME] | DE | [NAME]
[NAME] | GB | [NAME]
Kerry | DE | DE ES
Kerry | ES | DE ES
Wilma | GB | GB PL FR ES
Wilma | PL | GB PL FR ES
Wilma | FR | GB PL FR ES
Wilma | ES | GB PL FR ES
[NAME] | GB | GB PL
[NAME] | PL | GB PL
Spreadsheet: 0cf394c6-02ae-42cc-b4f5-b9d630bafea8
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
FRFMD | Test | FRFMD | Rufinamide (Banzel) | Rufinamide (Banzel) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Plain, Red-Top Tube: Red |  |  | 2 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:	ug/mL  Expected plasma concentrations in patients taking recommended daily dosages: 	Up to 60.0 ug/mL  Test Performed by:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
FRFMD | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FRFMD | Result | [NAME] | Rufinamide | Rufinamide | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 866288d1713257472-correction-in-formula-required-correct-formula
Sheet: Sheet1

 |  | OPG BALANCE | CURRENT BALANCE | DIFFERENCE | DIFF IN PERCENTAGE
 |  | 4133 | 3285 | -848
 |  | 44165 | 39598 | -4567
 |  | 26217 | 27072 | 855
 |  | 19978 | 22458 | 2480
 |  | 0 | 0 | 0 |  | dear sir / Madam I want 0 in this field
 |  |  |  |  |  | please correct the formula for 0  (Zero) percentage  required in column "F8"
Spreadsheet: 263d5396-dc08-4295-b585-bc4bfbd3325a
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
GAST | Test | GAST | Gastrin, Serum | Gastrin, S | Automated Chemiluminescent Immunometric Assay | Serum Gel Tube: SGT |  |  | 1 | mL | Collection Container/Tube:  Preferred: Red top Acceptable: Serum gel Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Fasting (8 hours). 2. If multiple specimens are drawn, submit each vial under a separate order. 3. Label specimens with corresponding draw time. | 0.5 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold <24 hours OK-refreeze-note to lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Nonfasting specimens | <100 pg/mL There is no evidence that fasting serum gastrin levels differ between adults and children. Although 8-hour fasts are difficult or impossible to enforce in small children, serum gastrin levels after shorter fasting periods (3-8 hours) may be 50% to 60% higher than the 8-hour fasting value. | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 82941 |  |  |  |  | Rochester
GAST | [NAME] | SERUM | Serum |  |  |  | Frozen | 30 days
GAST | Result | GAST | Gastrin, S | Gastrin, S | Numeric |  |  |  |  | pg/mL |  |  |  |  |  |  |  |  |  | 2333-3
Spreadsheet: 85168d1285223209-divide-by-zero-errors-kitchen-replacement-programme-2010-11_revised_web_upload2
Sheet: Decent Homes Completions

 |  | Properties Instructed |  | Projected Spend
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs |  |  |  | Actual Property Completions |  | Actual Costs
 |  | Aug |  |  |  |  |  |  |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Sept
 |  | Oct |  |  |  |  |  |  |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Nov
 |  | Dec |  |  |  |  |  |  |  | Dec
 |  | Jan |  |  |  |  |  |  |  | Jan
 |  | Feb |  |  |  |  |  |  |  | Feb
 |  | Mar |  |  |  |  |  |  |  | Mar
 |  | Apr |  |  |  |  |  |  |  | Apr
 |  | May |  |  |  |  |  |  |  | May
 |  | Jun |  |  |  |  |  |  |  | Jun
 | Check |  |  |  |  |  |  |  | Check
 | Total |  |  |  |  |  |  |  | Total
 | [NAME] |  |  |  |  |  |  |  | [NAME]
 |  | All Properties |  | Projected Spend |  |  |  |  |  | Average Figures
 |  | Proposed Property Completions |  | Initial Costs |  | Final Costs
 |  |  |  |  |  |  |  |  |  | Initial Works Order Value
 |  | Aug
 |  | Sept |  |  |  |  |  |  |  | Variations
 |  | Oct
 |  | Nov |  |  |  |  |  |  |  | Final Works Order Value
 |  | Dec
 |  | Jan
 |  | Feb
 |  | Mar
 |  | Apr
 |  | May
 |  | Jun
 | Check
 | Total
 | [NAME]
 |  | Over All Totals
 |  | Initial Works Order Value
 |  | Variations
 |  | Final Works Order Value
 |  | Projected Over Spend Based on Initial W/O Costs
 |  | Projected Total Av.
 |  | Over Spend
 |  | Projected Over Spend Based on Final W/O costs
 |  | Projected Total Av.
 |  | Over Spend
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Valero Buy

Valero Mktg & Supply
Contract: various | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 56196
VALUE | 155081
NET RATE |  |  |  | 2.54
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
UA4 Variance
Spreadsheet: 686910d1594868477-how-to-differentiate-exactly-word-with-and-no-on-the-data-to-countif-iferror-and-vlook-match-data
Sheet: Sheet2

Stock | Last Price | REMARKS
KOSSAN | 12.7 | Enter
TOPGLOV | 22.1 | Hold
DUFU | 6.24 | Hold
DIALOG | 3.88 | Hold
SUPERMX* | 14.92 | Hold
MI* | 3.32 | Hold
HARTA | 15.74 | Enter
MAGNI* | 2.2 | Hold
HOMERIZ | 22.1 | Enter
GRANFLO | 6.24 | Enter
IRIS* | 3.88 | Enter
PRESTAR | 14.92 | Enter
Spreadsheet: 274576d1383152535-use-a-single-formula-to-calculate-the-product-of-the-top-10-cells-with-another-column-sample
Sheet: Sheet1

9.64828405858318 | 7
1.890639443784825 | 94
1.592434087844337 | 18
1.591489311361414 | 56
1.351786853595092 | 79
3.544512287445575 | 90
5.204204384567674 | 26
1.49302916027222 | 10
8.216157784795012 | 46
7.198193400729136 | 75
1.993008186043811 | 4
2.587418846141403 | 49
7.650128393411224 | 76
1.19084268995531 | 81
3.165233979186971 | 0
2.835122719014746 | 76
4.341707648824515 | 10
5.635804919176436 | 14
3.607414894640301 | 89
9.97820169671661 | 45
Spreadsheet: 158071d1337968615-error-of-n-a-when-summing-up-columns-using-index-and-match-for-multiple-worksheets-sales-report
Sheet: Mar

# |  |  |  |  |  | Existing | Existing | Existing | Existing | New | New | New | Referrals | New | Flights
 |  |  |  |  |  | Sales | Sales | Unique |  | Sales | Unique |  |  | Lines | Fund Amount
1 | SJUDGE | NE | 22 | SJUDGE |  | 26 | 5 | 5.2 | 52 | 5 | 10.4 | 1 | 2
2 | MBOT | NE | 55 | MBOT |  | 53 | 17 | 3.117647058823529 | 26 | 3 | 8.666666666666666 | 2 | 3 | 75725
3 | DCATE | NE | 66 | DCATE |  | 16 | 11 | 1.454545454545455 | 30 | 5 | 6 |  | 2
Spreadsheet: 71252d1271944576-excel-2007-graph-detail-not-showing-afr-new-version
Sheet: AFR Statistics

Accident frequency rate
 | 2007/2008 |  |  |  |  |  |  |  |  |  |  |  | 2008/2009 |  |  |  |  |  |  |  |  |  |  |  |  | 2009/2010 |  |  |  |  |  |  |  |  |  |  |  |  | 2010/2011
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 1
Target | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.19 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.18 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.175 | 0.112
Rolling AFR | 0.127 | 0.13 | 0.133 | 0.134 | 0.135 | 0.136 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.12 | 0.118 | 0.119 | 0.12 | 0.121 | 0.358 | 0.349 | 0.355 | 0.355 | 0.474 | 0.484 | 0.486 | 0.488 | 0.375 | 0.384 | 0.389 | 0.394 | 0.405 | 0.139
Fatality | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Major [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Minor RIDDOR | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Minor Accident | 1 | 3 | 0 | 0 | 1 | 4 | 1 | 0 | 3 | 2 | 6 | 0 | 0 | 1 | 2 | 2 | 0 | 1 | 0 | 1 | 3 | 0 | 2 | 1 | 4 | 3 | 1 | 2 | 3 | 1 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0
Spreadsheet: 117083d1312434780-using-and-to-check-2-conditions-usingand
Sheet: data

date | type | fuel
2011-06-21 00:00:00 | Blue Volvo | diesel
2011-06-21 00:00:00 | Red Citroen | electric
2011-06-23 00:00:00 | [NAME] | gasoline
2011-06-23 00:00:00 | [NAME] | diesel
2011-06-23 00:00:00 | Silver Toyota | electric
2011-06-23 00:00:00 | [NAME] | diesel
2011-06-28 00:00:00 | Blue Volvo | corn oil
2011-06-28 00:00:00 | Red Citroen | electric
2011-06-28 00:00:00 | [NAME] | gasoline
2011-06-28 00:00:00 | [NAME] | diesel
2011-07-02 00:00:00 | [NAME] | electric
2011-07-02 00:00:00 | Silver Toyota | electric
2011-07-02 00:00:00 | [NAME] | diesel
2011-07-02 00:00:00 | [NAME] | corn oil
2011-07-03 00:00:00 | [NAME] | diesel
2011-07-03 00:00:00 | Blue Volvo | gasoline
2011-07-12 00:00:00 | [NAME] | electric
2011-07-30 00:00:00 | Red Citroen | diesel
2011-08-02 00:00:00 | [NAME] | corn oil
2011-08-03 00:00:00 | Silver Toyota | gasoline
2011-08-05 00:00:00 | [NAME] | diesel
2011-08-09 00:00:00 | Blue Volvo | diesel
2011-08-10 00:00:00 | Red Citroen | gasoline
2011-08-11 00:00:00 | [NAME] | electric
2011-08-16 00:00:00 | [NAME] | diesel
2011-08-21 00:00:00 | [NAME] | gasoline
2011-08-22 00:00:00 | Silver Toyota | gasoline
2011-08-23 00:00:00 | [NAME] | corn oil
2011-08-29 00:00:00 | [NAME] | electric
2011-10-04 00:00:00 | [NAME] | electric
2011-10-10 00:00:00 | Blue Volvo | electric
2011-10-19 00:00:00 | [NAME] | corn oil
2011-10-21 00:00:00 | Red Citroen | diesel
Spreadsheet: 673602d1587464326-array-formula-with-multiple-match-criteria-to-count-exact-phrase-within-a-string-of-text-ldhall_book1
Sheet: Sheet1

Candidate No. | Venue | Exam | Weaknesses
Candidate 1 | Venue A | Exam 1 - Excel basics | 10c, 11, 12 |  | Exam 1 - Excel basics | 1a | 1b | 1c | 1d | 2a | 2b | 3 | 4a | 4b | 4c | 5a | 5b | 5c | 6a | 6b | 6c | 7a | 7b | 7c | 8 | 9a | 9b | 9c | 10a | 10b | 10c | 11 | 12
Candidate 2 | Venue B | Exam 1 - Excel basics | 3, 4c, 6c, 7b, 7c, 8, 9b, 9c, 10b, 10c, 11, 12 |  | Venue A
Candidate 3 | Venue B | Exam 3 - Advanced Excel | 3c, 5, 9bii, 10, 11, 13b |  | Venue B
Candidate 4 | Venue A | Exam 1 - Excel basics | 3, 6c, 10b, 10c, 12 |  | Venue C
Candidate 5 | Venue C | Exam 1 - Excel basics | 8
Candidate 6 | Venue C | Exam 2 - Excel intermediate | 4b, 12
Candidate 7 | Venue A | Exam 1 - Excel basics | 10c |  | Exam 2 - Excel intermediate | 1 | 2a | 2b | 3 | 4a | 4b | 5 | 6 | 7a | 7b | 7c | 8a | 8b | 8c | 9 | 10 | 11 | 12 | 13
Candidate 8 | Venue A | Exam 1 - Excel basics | 4c, 6b, 6c, 11, 12 |  | Venue A
Candidate 9 | Venue C | Exam 1 - Excel basics | 8, 10c, 11 |  | Venue B
Candidate 10 | Venue C | Exam 1 - Excel basics | 2a, 2b, 4c, 10b |  | Venue C
Candidate 11 | Venue B | Exam 1 - Excel basics | 11, 12
Candidate 12 | Venue C | Exam 3 - Advanced Excel | 8, 9bi, 12a, 13b
Candidate 13 | Venue C | Exam 1 - Excel basics | 11, 12 |  | Exam 3 - Advanced Excel | 1a | 1b | 2a | 2b | 3a | 3b | 3c | 4a | 4b | 5 | 6a | 6b | 7 | 8 | 9a | 9bi | 9bii | 10 | 11 | 12a | 12b | 13a | 13b
Candidate 14 | Venue C | Exam 2 - Excel intermediate | 10, 11 |  | Venue A
Candidate 15 | Venue B | Exam 1 - Excel basics | 3, 6c, 7b, 7c, 11, 12 |  | Venue B
Candidate 16 | Venue B | Exam 1 - Excel basics | 3, 4c, 6c, 7a, 7b, 7c, 10c |  | Venue C
Candidate 17 | Venue A | Exam 2 - Excel intermediate | 8b, 8c, 10, 11, 13
Candidate 18 | Venue C | Exam 3 - Advanced Excel | 9bi, 10, 11, 13b
Candidate 19 | Venue C | Exam 2 - Excel intermediate | 10, 11, 12, 13
Candidate 20 | Venue B | Exam 2 - Excel intermediate | 9, 10, 11, 12, 13