tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: GERMANY

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: kate_symes__18427__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | 2000-12-22 00:00:00 |  | 474.38 | 3200 | 290.77 | 1408 | 484.27 | 1335 | 300 | 25
 | 2000-12-21 00:00:00 |  | 476.11 | 3600 | 290.77 | 1408 | 500 | 1175 | 450 | 600
 | 2000-12-20 00:00:00 |  | 465.71 | 2800 | 375 | 200 | 529.93 | 2100 | 550 | 200
 | 2000-12-19 00:00:00 |  | 450 | 2400 | 346.89 | 1608 | 477.03 | 1720 | 210 | 697
 | 2000-12-18 00:00:00 |  | 377 | 2000 | 325 | 400 | 593.64 | 3048 | 423.21 | 1126
 | 2000-12-17 00:00:00 |  |  |  |  |  |  |  | 551.77 | 2065 |  | 325 | 600
 | 2000-12-16 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 587.5 | 1400 | 537.5 | 1200
 | 2000-12-15 00:00:00 |  | 306.88 | 3200 | 255.53 | 1808 | 571.38 | 3975 | 517.59 | 3375
 | 2000-12-14 00:00:00 |  | 484.61 | 5200 | 256.22 | 1608 | 654.11 | 730 | 437.04 | 1340
 | 2000-12-13 00:00:00 |  | 688.24 | 6800 | 500 | 200 | 454.83 | 6475 | 350 | 100
 | 2000-12-12 00:00:00 |  | 818.75 | 3200 | 300 | 200 | 800 | 0 | 600 | 0
 | 2000-12-11 00:00:00 |  | 3200 | 2800 | 1187.5 | 400 | 597.15 | 1192 | 561.22 | 245
 | 2000-12-10 00:00:00 |  |  |  |  |  |  |  | 740.4 | 5823 |  | 1187.5 | 1200
 | 2000-12-09 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 450 | 450 | 487.5 | 0
 | 2000-12-08 00:00:00 |  | 714.44 | 3600 | 400 | 200 | 325 | 630 | 487.5 | 0
 | 2000-12-07 00:00:00 |  | 679.17 | 2400 | 412.5 | 400 | 505.96 | 235 | 320.47 | 265
 | 2000-12-06 00:00:00 |  | 357.3 | 9600 | 275 | 800 | 342 | 858 | 237.5 | 200
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 785693d1656554712-index-match-for-multiple-values-in-array-data
Sheet: Desired Report Example (2)

EmplID | Name | Effdt | EffSeq | Status | [NAME] | Position Title | Manager [NAME] | Manager [NAME]
 |  |  | 1 | Active
74536 | [NAME] | 2022-07-01 00:00:00 | 0 | Active | End Reduction of Teaching | Assistant Professor | Associate Librarian | [NAME]
94723 | [NAME] | 2019-07-01 00:00:00 | 1 | Active | Rehire | Assistant Professor | Associate Librarian | [NAME]
94723 | [NAME] | 2019-07-01 00:00:00 | 0 | Terminated | End of Contract | Assistant Professor | Associate Librarian | [NAME]
78243 | [NAME] | 2014-08-10 00:00:00 | 0 | Terminated | End of Contract | Financial/Staffing Assistant | Associate Director | not found
98125 | [NAME] | 2019-01-01 00:00:00 | 0 | Active | Date Adjustment | Associate Director |  | not found
28331 | [NAME] | 2015-05-01 00:00:00 | 0 | On Leave | Academic Salary Increase | Associate Librarian | Director | [NAME]
84536 | [NAME] | 2015-05-01 00:00:00 | 0 | Active | Academic Salary Increase | Associate Librarian | Director | [NAME]
63792 | Toby Flenderson | 2022-05-01 00:00:00 | 0 | On Leave | Academic Salary Increase | Lecturer | Associate Librarian | [NAME]
76933 | [NAME] | 2022-07-01 00:00:00 | 1 | Active | Step Increase | Office Assistant | Assistant Manager | not found
76933 | [NAME] | 2022-07-01 00:00:00 | 0 | Active | [NAME] | Office Assistant | Assistant Manager | not found
12345 | [NAME] | 2016-08-01 00:00:00 | 0 | Retired | End Reduction of Teaching | Financial Assistant | Manager | Holly Flax
29781 | [NAME] | 2013-07-01 00:00:00 | 1 | On Leave | Scale Increase | Research Associate | Manager | Holly Flax
29781 | [NAME] | 2013-07-01 00:00:00 | 0 | On Leave | Job Earnings Distribution | Research Associate | Manager | Holly Flax
10293 | [NAME] | 2021-07-01 00:00:00 | 1 | Active | Merit Increase | Project Manager | Director | [NAME]
10293 | [NAME] | 2021-07-01 00:00:00 | 0 | Active | Scale Increase | Project Manager | Director | [NAME]
29673 | [NAME] | 2012-01-01 00:00:00 | 0 | Active | Conversion Salary | Associate Professor | Associate Librarian | [NAME]
46385 | Holly Flax | 2022-07-01 00:00:00 | 0 | On Leave | [NAME] | Manager | Director | [NAME]
98765 | [NAME] | 2019-07-19 00:00:00 | 0 | Terminated | End of Contract | Business Analyst | Project Manager | [NAME]
11111 | [NAME] | 2019-05-01 00:00:00 | 0 | Terminated | End of Contract | Lecturer | Associate Librarian | [NAME]
56209 | [NAME] | 2022-07-01 00:00:00 | 1 | On Leave | Job Earnings Distribution | Assistant Professor | Associate Librarian | [NAME]
56209 | [NAME] | 2022-07-01 00:00:00 | 0 | On Leave | Academic Salary Increase | Assistant Professor | Associate Librarian | [NAME]
Spreadsheet: 143548d1330457411-returning-a-row-of-data-based-on-cell-reference-and-date-fuel-workook_reply
Sheet: Summary

RowRef | Date | Name | Registration | Start Reading | Finish Reading | Amount Taken | Reading Taken | Milage |  | Registration | GN56 LVH
 |  |  |  |  |  |  |  |  |  | Start Date: | 2012-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  | End Date: | 2012-02-13 00:00:00
 |  |  |  |  |  |  |  |  |  | ^ Data validation Reg & Dates
^ Helper column. Can be hidden. |  |  |  | ^ [NAME]:I30
 |  |  |  | * If using Excel 2007 or later, can be abbreviated with IFERROR function.
Spreadsheet: a8a86679-695a-4008-b5ad-abb4020cbcab
Sheet: Year 2011

Nature/Month | Case | Reported | Occurred | Location | Disposition
Classification | Number | Date/Time | Date/Time | General
November | November | Continued
Larceny | 2011-1802 | 11/9/11-3:15 pm | 11/6/11-11/7/11 | Hopkins Court | Open
Larceny | 2011-1820 | 11/11/11-7:12 pm | 11/10/11-11:15 pm - 11/11/11-1:00 am | Off Campus | Open
Larceny | 2011-1848 | 11/15/11-4:27 pm | 11/15/11 - 4:10 pm-4:15 pm | [NAME] | Open
[NAME] | 2011-1873 | 11/19/11-10:46 pm | 11/19/11-10:46 pm | Campion Towers | Judicial Review-Closed
Larceny | 2011-1894 | 11/22/11-7:42 pm | 11/22/11-4:14 pm-7:30 pm | [NAME] | Open
Larceny | 2011-1902 | 11/28/11-5:26 pm | 11/28/11 - 4:57 pm-5:20 pm | Fitness Center Lot | Open
Drug Law Violation | 2011-1906 | 11/29/11-10:00 am | 11/29/11 - 10:00 am | Newman Towers | Judicial Review-Closed
 | Total | 11
 | Case | Reported | Occurred | Location | Disposition
Total | Number | Date/Time | Date/Time | General
December
[NAME] | 2011-1927 | 12/3/11-12:33 pm | 12/3/11-12:33 pm | [NAME] | Judicial Review-Closed
Larceny | 2011-1969 | 12/8/11-8:48 pm | 12/8/11-12:10 am` | Newman Towers | Open
Assault (simple) | 2011-1972 | 12/9/11-12:15 am | 12/9/11-12:15 am | Campion Towers | Closed
Drug Law Violation | 2011-1974 | 12/9/11-12:38 am | 12/9/11-12:38 am | Flannery O'Connor Hall | Judicial Review-Closed
Drug Law Violation | 2011-1983 | 12/9/11-10:12 pm | 12/9/11-10:12 pm | Campion Towers | Judicial Review-Closed
Larceny | 2011-2010 | 12/13/11-4:50 p.m. | 12/12/11-3:pm-10:00 pm | Butler Hall | Open
Larceny | 2011-2053 | 12/19/11-3:08 pm | 12/19/11-2:30 pm-2:40 pm | Dechiaro Center | Open
Spreadsheet: 3159872c-1acd-443d-94e3-da5e8b6c9699
Sheet: Sheet1

Tax Commissioner - DEM (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/23/2013 8:38:26 AM
Precincts Reporting: 565/565 - Total Ballots Cast: 111325
2006 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 0201 | 167 | 167
Precinct 0202 | 47 | 47
Precinct 0203 | 38 | 38
Precinct 0204 | 19 | 19
TOTAL | 271 | 271
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 0bee23fb-7c13-422c-9e1b-9a155a1a78ac
Sheet: Sheet1

 | EAST TEXAS BAPTIST UNIVERSITY
 | Employee Evaluation
 | Employee |  |  |  |  |  |  | Evaluation Period:
 | Department |  |  |  |  |  |  | 5/1/13 to 5/1/14
 | Position
 | Supervisor
 | Indicate the level of competence in each objective below based on the following ratings.
 | 1- Poor | 2-Needs improvement  3-Meets expectations   4-Above average   5-Excellent
 | Evaluation of position responsibilities
 | Objectives from employee position guide.  No. of objectives. |  |  |  |  |  |  |  |  | Rating
 | Supervisor comments may be made on pages 2 and 3 concerning the above objectives.
 | EAST TEXAS BAPTIST UNIVERSITY
 | Employee Evaluation
 | Evaluation of performance
 | Employee remains on task and completes assignments as required.
 | Employee follows instructions and observes policies and procedures.
 | Employee works well with co-workers on the job.
 | Employee has the knowledge, skill, and abilities for successful job performance.
 | Employee is punctual for work, meetings, and appointments.
 | Summary
 | Evaluation of position responsibilities
 | Evaluation of performance
 | Employee's overall performance
 | If employee rating indicates "poor" or "needs improvement," specify actions needed in order
 | to improve job performance.  Additional space is provided on page 3.
 | The signatures below indicate that this Employee Evaluation has been reviewed by
 | both parties. |  | The employee's signature does not indicate agreement with the ratings
 | or comments.  Employee comments may be written in the bottom section of page 3.
 | Employee |  |  |  | Date
 | Supervisor |  |  |  | Date
 | EAST TEXAS BAPTIST UNIVERSITY
 | Employee Evaluation
 | Comments concerning evaluation of objectives from page 1 (continued from page 2).
 | Personal goals for next year.
 | Additional comments by employee or supervisor.
Spreadsheet: 163155d1340206946-auto-extract-problem-ef112_epdm-1-
Sheet: CR Sheet

90769615
90769616
90769617
90769618
90769619
90769620
90769621
90769622
90769623
90769624
90769625
90769626
90769627
90769628
90769629
90769630
90769631
90769632
90769633
90769634
90769635
90769636
90769637
90769638
90769639
90769640
90769641
90769642
90769643
90769644
90769646
90769647
90772999
90775452
90775453
90775454
90775455
90775456
90775457
90775458
90775459
90775460
90775461
90776800
90777043
90777044
90777045
90777046
90777048
90777052
90777053
90777054
90778921
Spreadsheet: 854120d1704100647-create-spread-for-actual-values-against-planned-plan-vs-actual-distribution-excelforum-windknife-1-
Sheet: Sheet1

Activity | Company | Month | Plan | Actual
Activity 1 | ABC | 2023-01-01 00:00:00 | 100 | 30 |  |  |  | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC | 2023-01-01 00:00:00 | 50 | 60 |  |  | 2023-01-01 00:00:00 | 350 | 130 | 200 | 20
Activity 1 | DEF | 2023-01-01 00:00:00 | 200 | 50 |  |  | 2023-02-01 00:00:00 | 50 | 0 | 50 | 0
Activity 1 | ABC | 2023-02-01 00:00:00 | 0 | 50 |  |  | 2023-03-01 00:00:00 | 0 | 0 | 0 | 0
Activity 1 | ABC | 2023-03-01 00:00:00 | 0 | 20
Activity 1 | DEF | 2023-02-01 00:00:00 | 0 | 150
Activity 2 | ABC | 2023-02-01 00:00:00 | 50 | 90
Plan/Actual |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
2023-01-01 00:00:00 | 350 | 140 | 200 | 20
2023-02-01 00:00:00 | 50 |  | 90
 |  |  |  |  |  |  | Plan | /Actual | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
 |  |  |  |  |  |  | 2023-01-01 00:00:00 | 350 | 140 | 200 | 20
[NAME] for January (350) |  |  |  |  |  |  | 2023-02-01 00:00:00 | 50 | 0 | 90 | 0
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 |  |  | 2023-03-01 00:00:00 | 0 | 0 | 0 | 0
Activity 1 | ABC | 30 | 50 | 20
Activity 2 | ABC | 60
Activity 1 | DEF | 50 | 150
[NAME] for February (50)
Activity | Company | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Activity 2 | ABC |  | 90
Spreadsheet: joe_parks__14883__TXULSP Avail Cap Elec Gen
Sheet: available capacity

 |  |  | Today's Date:
 | Lone Star Pipeline
Estimated Available Capacity on the TXU Lone Star Pipeline system
Gas Day runs from 9:00 a.m. to 9:00 a.m.
All volumes are expressed in [NAME]/d
The data below is TXU Lone Star Pipeline's best estimate of available capacity based on current operational data.  The available capacity listed
at the various [NAME])  is subject to the nomination process and the operational conditions existing at the time a nomination is confirmed.
The volumes listed below do not represent individual point capacity availability.   All transportation service will be performed subject to the terms
and conditions of your Transportation Agreement.
Please contact TXU Lone Star Pipeline's Transportation Administration Department before scheduling any imbalance makeup.  When
nominating imbalance makeup, please indicate what portion of your nomination is intended as imbalance makeup.  For more information, please
contact your TXU Lone Star Pipeline Transportation Administrator.
Please visit our web site at www.txulsp.com for nomination information and for a list of Major Interconnect Points on our system.
 | Receipt Area Capacity
 | Gas Day | Gas Day
 | 2002-03-12 00:00:00
From the Waha Area | 250000
East of Waha to | 100000
to the Maryneal Compressor
East of Maryneal Compressor | 50000
[NAME] | 100000
(Waller and Ft. Bend Counties)
Line V (30") | 50000
(Ennis to [NAME])
Lines L8A | 0
(Limestone and Freestone Cty)
Line P | 15000
([NAME] Area - for local consumption only)
[NAME] and O (East Texas) | 25,000*
 | * Carthage Plant OK for 25,000
Spreadsheet: 69ab06d9-a4dd-4c81-903e-5876d1b7071c
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
ALPA | Test | ALPA | Alprazolam, Serum | Alprazolam, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red |  |  | 3 | mL | Container/Tube: Red top [NAME]: 3 mL | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Serum gel tube | Therapeutic range: 5-25 ng/mL Some patients respond well to levels of 25-55 ng/mL. | Varies, batched 2 times per week | 1 day | 3 days | 1 | 82491 |  |  |  |  | New England
ALPA | [NAME] | SRED | Serum Red |  |  |  | Refrigerated
ALPA | Result | 11236 | Alprazolam, S | Alprazolam, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3312-6
Spreadsheet: 131031d1322697089-vlookup-copy-of-december
Sheet: 22

 |  |  |  | 2011-12-22 00:00:00
Newspaper | Price | Quantity | Total
Value | 0.88 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.22 |  | 0
Value3 | 1.22 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.04 |  | 0
Value10 | 1.04 |  | 0
Value11 | 1.04 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 753112d1635258395-vlookup-with-multiple-criteria-and-wildcard-recherchev-problem
Sheet: Feuil1

Date | Time | Description | No of trays
2021-06-07 00:00:00 | 12:00:16 | Verrines | 28 |  | Criteria
2021-06-07 00:00:00 | 12:05:16 | Verrines | 32 |  | 1 | DATE | 2021-06-08 00:00:00
2021-06-07 00:00:00 | 12:10:16 | Verrines | 4 |  | 2 | FORMAT | GN 1/3 | GN 1/3 SLOW
2021-06-07 00:00:00 | 12:15:16 | GN 1/3 SLOW | 0 |  | 3 | NO OF TRAYS | >0
2021-06-08 00:00:00 | 12:20:16 | GN 1/3 SLOW | 6
2021-06-08 00:00:00 | 12:25:16 | GN 1/3 QUICK | 0
2021-06-08 00:00:00 | 12:30:16 | GN 1/3 QUICK | 0 |  | Formula 1 | LAST TIME |  | does not work with * abbrevation
2021-06-09 00:00:00 | 12:30:37 | Print manual | 0 |  | Formula 2 | LAST TIME
2021-06-09 00:00:00 | 12:35:16 | GN 1/3 SLOW | 3
Spreadsheet: 824408d1680555656-help-to-write-macro-that-pulls-dates-from-sheet1-and-highlights-related-cells-in-sheet2-resource-tracker1
Sheet: Project Schedules

 |  | 2023-04-03 00:00:00
Jaguar | Adam
Lion | [NAME]
Elephant | [NAME]
Alligator | [NAME]
Spreadsheet: 147559d1332857724-remove-duplicate-and-its-original-rows-after_ammendments
Sheet: database

Date Published: 01/10/2011
PD | ENO | Status | Title | First Names | Initials | Surname | Suffix | Date of Attainment | Franchise Flag | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Address 6 | Address 7 | Flat | House | Sub Road | Road | Register Code | Clerical Error
RRG | 1 | E | MR | [NAME] |  | Smith |  |  |  | 3 Bott Road | Cillie | Bucks | BD22 4FC
RRG | 2 | E | MR | [NAME] |  | Jones |  |  |  | 3 Bott Road | Cillie | Bucks | BD22 4FC
RRG | 3 | E | MR | Julie |  | Davies |  |  |  | 4 Bott Road | Cillie | Bucks | BD22 4FC
RRG | 4 | M | MR | [NAME] | W | Tweens |  |  |  | 5 Bott Road | Cillie | Bucks | BD22 4FC
GEE | 1024 | A | MR | [NAME] |  | Tweek |  |  |  | 15 King Street | Cillie | Bucks | BD22 5TT
RRG | 789 | A | MR | Trevor |  | Digby |  |  |  | 23 Queen Street | Cillie | Bucks | BD22 2DD
RRG | 522 | A | MRS | [NAME] |  | Frends |  |  |  | 44 Frederick Road | Cillie | Bucks | BD22 4WW
Spreadsheet: 108520d1305578111-sumifs-help-test-file
Sheet: Savings

Month | Comparitor type | Value
2011-01-01 00:00:00 | No valid reference available | 0
2011-01-01 00:00:00 | No valid reference available | 100
2011-01-01 00:00:00 | Last Purchase | 0
2011-01-01 00:00:00 | Last Purchase | 100
2011-02-01 00:00:00 | Investment Dossier | 100
2011-02-01 00:00:00 | Investment Dossier | 100
2011-02-01 00:00:00 | Third Party Project Budget | 0
2011-02-01 00:00:00 | Third Party Project Budget | 250
2011-02-01 00:00:00 | Investment Dossier | 949840
2011-02-01 00:00:00 | Investment Dossier | 250
2011-02-01 00:00:00 | No valid reference available | 0
2011-02-01 00:00:00 | No valid reference available | 0
2011-02-01 00:00:00 | Third Party Project Budget | 0
2011-02-01 00:00:00 | Third Party Project Budget | 0
2011-02-01 00:00:00 | Investment Dossier | 0
2011-02-01 00:00:00 | Investment Dossier | 0
2011-03-01 00:00:00 | Third Party Project Budget | 0
2011-03-01 00:00:00 | Third Party Project Budget | 250
2011-03-01 00:00:00 | No valid reference available | 2648
2011-03-01 00:00:00 | NO COMPARATOR | 1000
2011-03-01 00:00:00 | No valid reference available | 0
2011-03-01 00:00:00 | No valid reference available | 123
2011-03-01 00:00:00 | No valid reference available | 0
2011-03-01 00:00:00 | No valid reference available | 123
2011-03-01 00:00:00 | No valid reference available | 0
2011-03-01 00:00:00 | NO COMPARATOR | 123
Spreadsheet: 857443d1706464252-need-to-extract-costs-from-excel-dataset-data
Sheet: Rate Card

 |  | Total Hus | 1-3 | 4-6 | 7-9 | 10-12 | 13-15 | 16+
MAINLAND |  |  | PLTS | PLTS | PLTS | PLTS | PLTS | PLTS
ML |  | (24 HR) | 48 | 47 | 46 | 45 | 44 | 43
G,EH,PA1-19,FK |  | (24 HR) | 50 | 49 | 48 | 47 | 46 | 45
KA,KY |  | (24 HR) | 54 | 53 | 52 | 51 | 50 | 49
PH1-9 |  | (24 HR) | 55 | 54 | 53 | 52 | 51 | 50
DD1-5, TD, DG |  | (24 HR) | 59 | 58 | 57 | 56 | 55 | 54
AB10-25 |  | (24 HR) | 87 | 86 | 85 | 84 | 83 | 82
AB26+ |  | (24-48 HR) | 91 | 88 | 85 | 82 | 79 | 76
IV1-20 |  | (24-48 HR) | 92 | 91 | 90 | 89 | 88 | 87
KW1-14 |  | (24-48 HR) | 102 | 101 | 100 | 99 | 98 | 97
Spreadsheet: 61595d1262537005-sum-formatting-problem-example1
Sheet: 130053

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130053
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOG NO:
PIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return Date:
SIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept Date:
F/A: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days: | 0
IRP: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RON's:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous  Log Closed:
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  |  |  | ZULU
LEG | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N/V | HOLD |  | OUT | IN | TOTAL |  | HOURS |  | RATE | $ |  | T.O. | LDG
1 | 2009-11-29 00:00:00 | C | MG | VNY | LGB | 15:32:00 | 10:35:00 | 00:24:00 |  |  | 00:00:00 | D | P | 0 |  | 15000 | 13500 |  |  |  |  | 2.25
2 | 2009-11-29 00:00:00 | C | SV |  | SAF |  | 12:25:00 | 01:52:00 |  |  | 00:00:00 | D | N | 1 |  | 16200 | 9300 |  |  |  |  | 2.25
3 | 2009-12-02 00:00:00 | C | MG |  | LGB |  | 14:13:00 | 01:40:00 |  |  | 00:00:00 | D | P | 0 |  |  | 4000 |  |  |  |  | 0
4 | 2009-12-02 00:00:00 | C | MG |  | VNY |  | 16:21:00 | 00:13:00 |  |  | 00:00:00 | D | V | 0 |  | 6500 | 5500 |  |  |  |  | 0
5 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
6 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
7 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
8 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
9 |  |  |  |  | 0 | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
 | PST | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed
 | DST | 7:00:00
 | Today |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add - Fwd from previous [NAME]. Log only |  |  |  |  |  | 0
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add |  | 0
 | ACTT Forwarded
 | Total this Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Total
 | Totals to Date