tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Eskom- Collection  -CSL Support

Time Notified : Eskom Shipping to collect ( 14 day Eskom Process )
Eskom Station -  Notification to Delivery report
Notification to Delivery  (Status) : |  |  |  |  |  |  |  | Eskom Station -   Notification to Delivery  (Status) :
CSL | Power Station | Region | Shipment Status | Delivery Note | Eskom Customer PO | Eskom Notified - Collection:    ( No of days taken) - Networkdays | Eskom Station - Delivery to station ( No of days taken) -  Networkdays | Late | Grand Total
[NAME] | Matimba | Germany | Eskom : Awaiting PO Req | 80603671 | 4502958077 | 51 | 51 | 1 | 1
[NAME] | Matimba | Germany | Eskom : Awaiting PO Req | 80603695 | 4502920677 | 51 | 51 | 1 | 1
[NAME] | Matimba | Germany | Eskom : Awaiting PO Req | 80604138 | 4502960393 | 51 | 51 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104875 | 4502961153 | 23 | 23 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104863 | 4502945192 | 23 | 23 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104835 | 4502966872 | 21 | 21 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104836 | 4502866836 | 21 | 21 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104833 | 4502965647 | 18 | 18 | 1 | 1
[NAME] | Koeberg | France | Eskom : Await Transport PO | PKL 104306 | 4502935372 | 15 | 15 | 1 | 1
Riaan | [NAME] | UK | Eskom : Awaiting PO Req | 80603536 | 4502967528 | 52 | 52 | 1 | 1
Grand Total |  |  |  |  |  |  |  | 10 | 10
Spreadsheet: 216805d1361893286-transfer-data-between-worksheets-using-multiple-criteria-testworkbook
Sheet: sheet 1

 |  | Data Source |  |  |  | Compliance Test |  |  |  |  | Contact
Number | DoC | abc | JS | CORD A | CORD B | A | CORD | WA | DS | Location | Name | Phone | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Match_row
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This entire row should be blank, returning no value in any of the cells from sheet 2.  I believe the problem lies with the functional argument in column O of sheet 2 but I can't find it.
Spreadsheet: 48f5f9c3-d0a0-44e4-946b-ad8cbad0da0c
Sheet: Sheet1

To determine the amount for private vehicle mileage reimbursement, please fill in the yellow highlighted fields.  Personal reimbursement will be at the Hertz Full Size rate or the Employee Car/Minivan rate, whichever is less.  If no FHSU Motor Pool vehicle or Hertz vehicle is available, $0.56 per mile will be the reimbursement rate.  The traveler is not required to use Hertz as the rental company. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
[NAME]'s Name:
PR #:
PO #:
Check Applicable:
 | Pretrip Estimate
 | Complete prior to submitting a PR. Form to be retained by department.
 | Actual Expense
 | Complete after traveler returns. Form to be sent to Accounts Payable along with travel receipts.
Number of Days Vehicle is Required:
Total Miles Driven:
KDOT mileage chart: |  |  |  |  |  | http://kdotapp2.ksdot.org/mileagebetweencities/
Return Travel Date: |  |  |  |  |  |  |  |  | Travel Date must be 07/01/14 or later
Reimbursement Calculation
Employee Car/Minivan when [NAME] is available ($0.22 plus estimated fuel per mile) |  |  |  |  | Employee Car/Minivan when [NAME] and [NAME] NOT available ($0.56 per mile) |  |  |  | Hertz Full Size  rate including the Cost of Fuel |  |  |  |  |  | Department may reduce the rate or limit the amount to be reimbursed.
 |  |  |  |  | 0
Vehicle Data
Current Cost of Fuel per Gallon |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per gallon
Estimated Miles per Gallon for Rental Full Size |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | miles/gallon
Employee Car/Minivan Rate when Motor [NAME] is available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per mile
Employee Car/Minivan Rate when [NAME] and Hertz Vehicle NOT available |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.56 | per mile
Hertz Full Size Rate (Unlimited Miles) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.5 | per day
Gas price updated as of |  |  |  |  |  | 2014-10-30 00:00:00
Hertz Contract 37354  Awarded 11-01-12
Comments:
Spreadsheet: 2cfe0bbb-e463-4e25-954d-3270e7465879
Sheet: Sheet1

School |  |  |  | Faculties |  | Divisions and Institutes
School of Life and Medical Sciences |  | Vice-Provost Health Professor Sir [NAME] |  | Faculty Of Brain Sciences  [NAME]: Professor [NAME]      [NAME] Manager: Geoff Dunk |  | UCL Ear Institute |  | Planning and Performance Unit Director:  [NAME] |  | SLMS Finance Director: Arun Mistry |  | Research Support Centre Director:  [NAME]
 |  |  |  |  |  | UCL Institute of Neurology
 |  |  |  |  |  | UCL Institute of Ophthalmology
 |  |  |  |  |  | UCL Division of Psychology and Language Sciences
 |  |  |  |  |  | UCL Mental Health Sciences Unit
 |  |  |  | Faculty of Life Sciences   Dean:  Professor [NAME]    Faculty Manager:  [NAME] |  | UCL Division of Biosciences
 |  |  |  |  |  | [NAME] Unit
 |  |  |  |  |  | Laboratory for Molecular Cell Biology
 |  |  |  |  |  | UCL School of Pharmacy
 |  |  |  | Faculty of Medical Sciences  Dean:  Professor [NAME]    Faculty Manager: Edna Murphy |  | UCL Medical School
 |  |  |  |  |  | UCL Cancer Institute
 |  |  |  |  |  | UCL Eastman Dental Institute
 |  |  |  |  |  | UCL Division of Infection and Immunity
 |  |  |  |  |  | UCL Division of Medicine
 |  |  |  |  |  | Wolfson Institute of Biomedical Research at UCL
 |  |  |  |  |  | UCL Division of Surgery and Interventional Science
 |  |  |  | Faculty of Population Health Sciences  Dean:  Professor [NAME]  Faculty Manager:  [NAME] |  | UCL Institute of Child Health
 |  |  |  |  |  | UCL Institute of Epidemiology and Health Care
 |  |  |  |  |  | UCL Institute for Women's Health
 |  |  |  |  |  | Institute of Cardiovascular Sciences
Spreadsheet: 752582d1634837978-sum-values-of-a-date-range-1-year-back-todays-date-fmla-hours-used-sample
Sheet: Sheet1

2021-10-21 00:00:00 | 10 |  |  | Total FMLA hours used(1 year prior to today)
 | 10 |  |  | Total FMLA hours used(6 months prior to today)
 | 10 |  |  | Total FMLA hours used(1 month prior to today)
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
 | 10
Spreadsheet: 9496bd46-5433-4d7b-a125-fbe87c45bc79
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
UNITED  NATIONS |  | [NAME]
ECONOMIC AND SOCIAL  COMMISSION |  | اللجنة الاقتصادية والاجتماعية
FOR WESTERN ASIA  ( ESCWA ) |  | لغربي أسيا  ( إسكوا )
ECONOMIC ANALYSIS DIVISION |  | دائرة التحليل الاقتصادي
BEIRUT - LEBANON |  | [NAME]
إســتـبـيـان النشرة 26 لدراسات [NAME]
QUESTIONNAIRE OF BULLETIN 26  OF THE NATIONAL ACCOUNTS STUDIES
KINGDOM  OF  BAHRAIN |  | مملكة البـحـريـن
Insert code of country in the next cell  ----> | 1
 |  |  |  |  |  | SERIAL | COUNTR_E | CURRENCY_E | CURRENCY_A | COUNTRY_A
 |  |  |  |  |  | 01 | KINGDOM  OF  BAHRAIN | Mn. Dinars | مليون دينار | مملكة البـحـريـن
 |  |  |  |  |  | 02 | ARAB REPUBLIC OF EGYPT | Mn. Pounds | مليون جنيه | [NAME] العربية
 |  |  |  |  |  | 03 | REPUBLIC OF IRAQ | Mn. Dinars | مليون دينار | [NAME]
 |  |  |  |  |  | 04 | HASHEMITE  KINGDOM  OF JORDAN | Mn. Dinars | مليون دينار | المملكة الأردنية الهاشمية
 |  |  |  |  |  | 05 | STATE  OF  KUWAIT | Mn. Dinars | مليون دينار | [NAME]
 |  |  |  |  |  | 06 | LEBANESE  REPUBLIC | Mn. Pounds | مليون ليرة | الجمهورية اللبنانية
 |  |  |  |  |  | 07 | SULTANATE  OF OMAN | Mn. Rials | مليون ريال | سلطنة عـمـان
 |  |  |  |  |  | 08 | PALESTINE | Mn. Dollars | مليون دولار | فلسطين
 |  |  |  |  |  | 09 | STATE  OF  QATAR | Mn. Rials | مليون ريال | دولــة قـطـر
 |  |  |  |  |  | 10 | KINGDOM  OF  SAUDI ARABIA | Mn. Rials | مليون ريال | المملكة العربية السعودية
 |  |  |  |  |  | 11 | SYRIAN  ARAB  REPUBLIC | Mn. Pounds | مليون ليرة | الجمهورية العربية السورية
 |  |  |  |  |  | 12 | UNITED  ARAB  EMIRATES | Mn. Dirhams | مليون درهم | الإمارات العربية المتحدة
 |  |  |  |  |  | 13 | REPUBLIC  OF YEMEN | Mn. Rials | مليون ريال | الجمهورية اليمنية
 |  |  |  |  |  | 14 | Country | Mn. Unit of National Currency | مليون وحدة عملة وطنية | الدولة
Spreadsheet: barry_tycholiz__888__Customer List-info needed
Sheet: IOU,LDC,Utilities

 | Customer | CP ID | [NAME]? Alternates? | CP ID
45 | Edison Mission Energy Company | See list | Edison Mission Energy
 |  |  | Edison Mission Energy Fuel
 |  |  | Edison Mission Marketing & Trading Inc.
 |  |  | Edison Mission Holdings Company
46 | Citizens Utilities Co., Arizona Gas Div. | See list | Citizens Utilities Co., Colorado Gas Div
 |  |  | Citizens Utilities Company
 |  |  | Citizens Utilities Santa Cruz
47 | El Paso Electric | See list | El Paso Electric Company
 |  |  | El Paso Electric Company Ancillary Services Exercised
 |  |  | El Paso Electric Company Supp.
48 | Pacific Gas and Electric Company, San Francisco, CA | See list | Pacific Gas & Electric (UEG Division)
 |  |  | Pacific Gas & Electric Company
 |  |  | PG&E Corporation
 |  |  | PG&E Energy Services
 |  |  | PG&E Hydrocarbons, L.P.
 |  |  | PG&E Power Services Company
49 | PacifiCorp | See list | Pacificorp
 |  |  | Pacificorp Electric Operations
 |  |  | Pacificorp Group Holdings Inc.
 |  |  | Pacificorp Holdings Inc.
 |  |  | Pacificorp Power Marketing, Inc.
 |  |  | Pacificorp Supp.
50 | UtiliCorp United Inc. West Plains | [NAME] | WestPlains Energy - Colorado DBA Utilicorp United Inc.
51 | Cascade Natural Gas Corp. | [NAME] | Cascade Natural Gas Co.? | 863
52 | Consumers Energy (AZ) | [NAME] | Consumers Energy Company? | 53436
53 | Greeley Gas Company, Denver, CO | [NAME] | Greeley Gas Company an Operating Division of Atmos Energy Corp.? | 88783
54 | K N Retail Division of K N Energy, Inc. | [NAME] | K N Energy, Inc.? | 246
55 | Long Beach Gas & Electric Dept. | [NAME] | Long Beach Gas Dept, City of? | 31934
56 | Powerex/BC Hydro | [NAME] | Powerex Corp.? | 51312
57 | Procter & Gamble-Oxnard | [NAME] | Proctor & Gamble Manufacturing? | 33439
58 | Raton Natural Gas Company | [NAME] | Raton Gas Company LLC? | 26227
59 | Salt River Project | [NAME] | Salt River Project Agricultural Improvement and Power District? | 2765
60 | Socal Edison | [NAME] | Southern California Edison Company? | 2890
Spreadsheet: 127055d1320153184-divide-cell-to-worksheets-then-add-for-check-n-balance-raiders-ledger
Sheet: Sydney

Sydney
Fall 2010
Date | Description | Check # | Credit | Debit | Balance
9/2011 | Field Rental - September
9/2011 | Tiffany - September
9/2011 | Insurance
Spreadsheet: darrell_schoolcraft__7827__imbalsumm0110
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 17642 | 18199 | 8769 | 9000
2 | 17694 | 18199 | 9575 | 9034
3 | 17678 | 17000 | 8857 | 8133
4 | 17399 | 17500 | 8555 | 8633
5 | 17391 | 16900 | 8425 | 8713 |  | 2500
6 | 17293 | 15537 | 8404 | 7954 | 9612 | 8215
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-09-30 00:00:00 |  |  |  |  |  |  |  |  | 57662
2001-10-06 00:00:00
CBS Volume
 |  |  | -98440
Spreadsheet: b8be3be5-0fb0-4cb0-a9a2-aaeae9b17737
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-10-29 09:28:46.640000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.5 | 102.375 | 102.25 | 101.875 |  | and are added to price quote
4.625 | 102.36 | 102.235 | 102.11 | 101.735
4.5 | 102.205 | 102.08 | 101.955 | 101.58 |  | Note: | Refer To Price [NAME]
4.375 | 101.665 | 101.54 | 101.415 | 101.04 |  |  | For all Price Adjs
4.25 | 101.147 | 101.022 | 100.897 | 100.272
4.125 | 100.379 | 100.254 | 100.129 | 99.504
4 | 99.42 | 99.295 | 99.17 | 98.545
3.875 | 98.404 | 98.279 | 98.154 | 97.529
3.75 | 97.529 | 97.404 | 97.279 | 96.654 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.75 | 102.5 | 102.375 | 102.25 | 101.875
3.625 | 102.365 | 102.24 | 102.115 | 101.74
3.5 | 101.85 | 101.725 | 101.6 | 101.225
3.375 | 101.097 | 100.972 | 100.847 | 100.472
3.25 | 100.374 | 100.249 | 100.124 | 99.499
3.125 | 99.781 | 99.656 | 99.531 | 98.906
3 | 99.031 | 98.906 | 98.781 | 98.156 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2013-11-12 09:28:46.640000
30 DAY | 2013-11-27 09:28:46.640000
45 DAY | 2013-12-12 09:28:46.640000
60 DAY | 2013-12-27 09:28:46.640000
90 DAY | 2014-01-26 09:28:46.640000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 842374d1694467266-if-and-return-value-based-on-2-sets-of-conditions-sample
Sheet: SPS Template

Account Manager | Rep | Agreement Date | Company | Maricopa | YCO | Yuma | MCO | SAN DIEGO | ORANGE | NEW/RENEW
 |  |  |  |  |  |  | I need a formula to pull all the $ from the first tab (2023 Spons Sales) into the blue table above
 |  |  |  | 0 | Yuma
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | ORANGE
 |  |  |  | 0 | ORANGE
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | SAN DIEGO
 |  |  |  | 0
 |  |  |  | 0 | Maricopa
 |  |  |  | 0 | ORANGE
 |  |  |  | 0 | SAN DIEGO
Spreadsheet: 02815568-bd64-4d30-b137-85c4e16172b9
Sheet: Sheet1

INDEX OF DATA FILES, FEDERAL FLEET REPORT FOR FY 2012 | Unnamed: 1
Each section of the Report focuses on a specific area: Inventory, Cost, Utilization, and Fuel Consumption,
with Section 1 providing an overall summary.
Unless otherwise marked, each table is a snapshot of end-of-year data for fiscal year 2012.
Tables with a "T" appended to the filename are 5-year trend tables.
The subjects of each section and the titles of each table are listed below:
Section 1: Overall Fleet Profile
Table 1 | Inventory, Cost, and Use Summary
Section 2: Inventory
Table 2-1 | [NAME]
Table 2-1T | Worldwide Inventory by Year
Table 2-2 | Vehicle Sources
Table 2-2T | Vehicle Sources by Year
Table 2-3 | Domestic and Foreign Inventory
Table 2-3T | Domestic and Foreign Inventory by Year
Table 2-4 | GSA Fleet Profile
Table 2-4T | GSA Fleet Profile by Year
Table 2-5 | Passenger Vehicles
Table 2-5T | Passenger Vehicles by Year
Table 2-6 | Trucks and Other Vehicles
Table 2-6T | Trucks and Other Vehicles by Year
Table 2-7 | Passenger Vehicles (Law Enforcement)
Table 2-7T | Passenger Vehicles (Law Enforcement) by Year
Table 2-8 | Trucks and Other Vehicles (Law Enforcement)
Table 2-8T | Trucks and Other Vehicles (Law Enforcement) by Year
Table 2-9 | GSA Vehicle Procurement
Table 2-10 | Average Age of Federally Owned Vehicles
Section 3: Cost
Table 3-1 | Worldwide Cost
Table 3-1T | Worldwide Cost by Year
Table 3-2 | Cost Breakdown by Category
Table 3-2T | Cost Breakdown by Category by Year
Table 3-3 | Cost Per Mile – Overall
Table 3-3T | Cost Per Mile – Overall by Year
Table 3-4 | Cost Per Mile – Agency Owned Vehicles
Table 3-4T | Cost Per Mile – Agency Owned Vehicles by Year
Table 3-5 | Cost Per Mile – GSA Fleet
Table 3-5T | Cost Per Mile – GSA Fleet by Year
Table 3-6 | Cost Per Mile – Commercially Leased Vehicles
Table 3-6T | Cost Per Mile – Commercially Leased Vehicles by Year
Table 3-7 | Domestic and Foreign Cost
Table 3-7T | Domestic and Foreign Cost by Year
Table 3-8 | Domestic and Foreign Cost Per Mile
Table 3-8T | Domestic and Foreign Cost Per Mile by Year
Section 4: Utilization
Table 4-1 | [NAME]
Table 4-1T | [NAME] by Year
Table 4-2 | Average Miles Per Vehicle
Table 4-2T | Average Miles Per Vehicle by Year
Table 4-3 | [NAME] – Domestic and Foreign
Table 4-3T | [NAME] – Domestic and Foreign by Year
Table 4-4 | [NAME] – Agency Owned Vehicles
Table 4-4T | [NAME] – Agency Owned Vehicles by Year
Table 4-5 | Miles – GSA Fleet
Table 4-5T | Miles – GSA Fleet by Year
Table 4-6 | [NAME] – Commercially Leased Vehicles
Table 4-6T | [NAME] – Commercially Leased Vehicles by Year
Section 5: Fuel Consumption
Table 5-1 | Worldwide Fuel Consumption
Table 5-1T | Worldwide Fuel Consumption by Year
Table 5-2 | Fuel Cost by Fuel Type
Table 5-2T | Fuel Cost by Fuel Type by Year
Table 5-3 | Vehicle Inventory by Fuel Type
Table 5-3T | Vehicle Inventory by Fuel Type by Year
Table 5-4 | Vehicle Acquisitions by Fuel Type
Table 5-4T | Vehicle Acquisitions by Fuel Type by Year
Spreadsheet: daren_farmer__6617__Cilco
Sheet: Feb 00

 | <Report Date
 |  |  |  | CILCO CONTACTS:
CILCO STORAGE |  |  |  | VONDA SECKLER
 |  |  |  | PH:  (309) 677-5164
BEG. BALANCE |  |  |  | FAX: (309) 677-5594
NOM. | REC | DEL.
EFF. DATE | VOLUME | VOLUME | STORAGE BAL.
2000-02-01 00:00:00 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
 | 14130 | 13500
Spreadsheet: 599731d1543282637-retail-inventory-calculating-multiple-items-in-a-sale-copy-of-retail-inventory-23102018-markp2010-
Sheet: OandI

Order Number | Order Date | Order Type | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | Unit Price | Amount | Product | Year-Month
 |  |  | 10 |  |  |  |  |  |  |  |  |  | 5.99
 |  |  |  | 10 |  |  |  |  |  |  |  |  | 5.68
 |  |  |  |  | 10 |  |  |  |  |  |  |  | 5.09
 |  |  |  |  |  | 10 |  |  |  |  |  |  | 5.09
 |  |  |  |  |  |  | 10 |  |  |  |  |  | 5.23
 |  |  |  |  |  |  |  | 10 |  |  |  |  | 4.97
 |  |  |  |  |  |  |  |  | 10 |  |  |  | 5.3
 |  |  |  |  |  |  |  |  |  | 10 |  |  | 4.76
 |  |  |  |  |  |  |  |  |  |  | 10 |  | 4.49
 |  |  |  |  |  |  |  |  |  |  |  | 10 | 4.49
 |  |  | 1 | 1 | 2 |  |  |  |  |  |  |  | 50 | 50
 |  |  | 1 |  |  |  | 1 |  | 1 | 2 |  | 1 | 70 | 70
Sale 3 |  |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 40 | 40
Spreadsheet: 184465d1349276432-using-parameter-query-in-excel-2010-report-sample-query-using-parameter
Sheet: Sheet1

Raw Data:
Lob | Payto | PCP | Date | Visits
Medicare | X | Y | 2011-01-01 00:00:00 | 200
Medicaid | A | C | 2011-01-10 00:00:00 | 430
Chip | E | D | 2011-02-01 00:00:00 | 700
Medicare | X | Y | 2011-03-01 00:00:00 | 100
Medicaid | A | C | 2012-01-10 00:00:00 | 350
Chip | E | D | 2012-02-01 00:00:00 | 1000
Query:
Parameters: User Selection Options
Select Payto: | X |  | If no selection, then pull ALL [NAME]
Select PCP: | Y |  | If no selection, then pull ALL PCPs
Select LOB: | Medicare |  | If no selection, then pull ALL LOBs
Select Date: | All 2011 |  | If no selection, then pull ALL Dates
Data Result:
Lob | Payto | PCP | Date | Visits
Medicare | X | Y | 2011
Spreadsheet: 850333d1700688777-need-a-formula-to-highlight-if-2-criteria-are-met-sample58
Sheet: Sheet1

Paid | Amount | Transaction ID
Y | 552.87 | [NAME]
Y | 956.35 | a6zx4
N | 226.38 | xaz4
Y
Y
N | 157.52 | [NAME]
Y | 594.68 | ayx5a
Y
N | 916.84 | astx5
Y | 582.65 | [NAME]
N | 789.25 | ytsf5
Y
Y | 895.6 | syt5s
N | 748.56 | atx4
Spreadsheet: 477018d1472108647-instruction-for-timekeeping-file-timekeeping-file
Sheet: Pete

Name: | [NAME]
Mã nhân viên | 0123
Information requested & approved before working Overtime
 | Date | Work Description | working time |  | TOTALWORKING TIME | total ot | aprrove
 |  |  | From to
 | 1900-01-21 00:00:00 | Sunday
 | 1900-01-22 00:00:00 | Working | 3 | 20
 | 1900-01-23 00:00:00 | URGEN LEAVES
 | 1900-01-24 00:00:00 | Working | 5 | 18
 | 1900-01-25 00:00:00 | Compensation
 | 1900-01-26 00:00:00 | Annual leaves
 | 1900-01-27 00:00:00 | Working | 3 | 20 | 0
 |  | OVERTIME
 | 1900-01-28 00:00:00 | Sunday
 | 1900-01-29 00:00:00 | NO ODER |  |  | 0