tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 053b94c3-41bf-4088-9957-1c5c0bdc0bfd
Sheet: Sheet1

UNIVERSITY OF ILLINOIS | 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
INVOICE VOUCHER AND TRAVEL/PROGRAM ADVANCE FORM
Chicago/Springfield/Urbana-Champaign
NOTE:  All payments to non-employee Foreign Nationals must be submitted to PAYROLL using the Foreign National Payment Form.
Name: |  |  |  | Dept. Name & M/C |  |  |  | Encumbrance # |  |  |  |  | UPAY Use Only
Banner Vendor Number: |  |  |  | Dept. Contact: |  |  |  | Final Payment? |  |  |  |  | Banner Document #
Remittance Address (insert on lines below): |  |  |  | Phone: |  |  |  | Payment Due Date: |  |  |  |  | Address Sequence:
 |  |  |  | Travel/Program Advance? |  |  |  | Invoice/Service Date: |  |  |  |  | Address Code:
 |  |  |  | Amount of Advance: |  |  |  | Vendor Reference: |  |  |  |  | Check Print Location:
 |  |  |  | Date of Departure? |  |  |  | Special Handling: |  |  |  |  | 1099? | Yes | No
 |  |  |  | Date of Return? |  |  |  | # to call for check pickup |  |  |  |  | Encl? | Yes | No
 |  |  |  | Purpose of Trip? |  |  |  |  |  |  |  |  | OBFS Approval:
[NAME]? |  |  | Form Link | Advance Signature/Date:
[NAME] OF ARTICLES OR SERVICES RENDERED (attach supporting documentation) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AMOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total |  | 0
"I certify that the goods or services specified on this voucher were for the use of this agency and that the expenditure for such goods or services was authorized and lawfully incurred, that such goods or services meet all the required standards set forth in the purchase agreement or contract to which this voucher relates; and that the amount shown on this voucher is correct and approved for payment.  If applicable, the reporting requirements of section 5.1 of 'An Act to create the Bureau of the Budget and to define its powers and duties and to make an appropriation,' approved April 16, 1969, as amended, have been met." |  |  |  |  |  |  | FOAPAL ( * = [NAME]; For Travel Advance, complete Chart code on last line)
 |  |  |  |  |  |  | Chart* | Index | Fund* | Orgn* | Acct* | Program* | Activity | Location | Amount
 |  |  |  |  |  |  | FOP TITLE:
 |  |  |  |  |  |  | FOP TITLE:
 |  |  |  |  |  |  | FOP TITLE:
Dept. Authorized Signature: |  |  |  |  | Date:
 |  |  |  |  |  |  | FOP TITLE: |  | Travel Advance (*Complete Chart Code below)
Additional Approval: |  |  |  |  | Date: |  |  |  | 200450 |  | 53080 |  |  |  | 0
Payment of interest may be available if the State fails to comply with the State Prompt Payment Act, (Ill. Rev. Stat. 1991, [NAME]. 127, Par. 132.400) (30 ILCS 540/0.01).
No
Program Advance
Foreign Travel
7 Day Domestic
Group Travel
Student Travel
Yes
No
No Special Handling Required
11  Do Not Mail--Urbana
12  Enclosure--Urbana
21  Do Not Mail--Chicago
22  Enclosure--Chicago
41  Do Not Mail--Springfield
42  Enclosure--Springfield
Spreadsheet: 151312d1334860944-unique-visits-based-on-criteria-unique-visits1
Sheet: Sheet1

Rendering | Patient | Date
Physician 1 | [NAME] | 2011-01-01 00:00:00
Physician 1 | [NAME] | 2011-01-02 00:00:00
Physician 2 | [NAME] | 2011-01-03 00:00:00
Physician 2 | [NAME] | 2011-01-04 00:00:00
Physician 3 | Toni Low | 2011-01-05 00:00:00
Physician 4 | [NAME] | 2011-01-06 00:00:00
Physician 1 | [NAME] | 2011-01-07 00:00:00
Physician 1 | [NAME] | 2011-01-08 00:00:00
Physician 2 | [NAME] | 2011-01-09 00:00:00
Physician 1 | [NAME] | 2011-01-10 00:00:00
Physician 4 | [NAME] | 2011-01-11 00:00:00
Physician 3 | [NAME] | 2011-01-12 00:00:00
Physician 3 | Fred So | 2011-01-13 00:00:00
Physician 3 | Toni Low | 2011-01-14 00:00:00
Physician 3 | [NAME] | 2011-01-15 00:00:00
 | [NAME]
Physician 1 | 1
Physician 2 | 3
Physician 3 | 3
Physician 4 | 2
Spreadsheet: 84712d1284720172-if-function-buyer-worksheet-2
Sheet: Week of 9-6 thru 9-10

Buyer: |  | [NAME]
Week of 9/6/2010 - 9/10/2010 |  |  |  |  |  |  |  |  |  | Offers |  |  |  | Disposition |  |  | Outcome
# | Call Date | Appt. Date | Street | City | Zip | [NAME] | [NAME] | ARV | Repairs | Cash | Option | MLS | Notes | Contract | Dead | Follow-Up | Cancelled | No-Show | Re-scheduled
1 | 2010-08-15 00:00:00 | 2010-08-24 00:00:00 | 15 Morgan Blvd | Arden | 28704 | [NAME] | [NAME] was motivated to sell wants to get rolling and then there was some sort thekr alfj asdfj skadlfjsldfsdklfj    fksdflsa;djf sdklf sdkfas | 125 | 20 |  |  |  |  | 1 |  | 1
2 | 2010-08-20 00:00:00 | 2010-08-24 00:00:00 | 3 Quail Point | Asheville | 28806 | [NAME] |  | 125 | 15 | 55 | 75 | 125 |  |  |  |  |  |  | 1
3 | 2010-08-22 00:00:00 | 2010-08-25 00:00:00 | 15 Cross Street | Asheville | 28805 | [NAME] |  |  |  |  |  |  |  |  |  | 1 |  | 1
 | Appointments this week |  | % Appts. Attended
 | Cancelled |  | % Offers Made
 | No-Shows
 | Rescheduled
 | Actual Appointments Attended
Spreadsheet: 72701a51-ea26-4423-b855-1727f5a449cf
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Political Science
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 123722d1317825722-counting-multiple-items-in-a-cell-samplecount
Sheet: Sheet1

 | [NAME], | item2, | item3, | item4, | [NAME], | item6, | [NAME], | item8, | item9, | item10, | item11, | item12,
[NAME], [NAME], item6,
item2, [NAME], item8, item12,
[NAME],
item2,
item3,
item4,
[NAME],
item6,
[NAME],
item8,
item9,
item10,
item11,
item12,
Spreadsheet: c0411f51-2ca5-4596-912e-10261f338f2a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | SR - Abrechnungsformular / Formulaire de décompte pour arbitre
 | Anlass/ événement :
 |  |  |  |  |  |  |  | A = Anlass/compétition
 | Datum/ date : |  |  |  |  |  |  | K = Kurs/cours
 |  |  |  |  |  |  |  | LK = Lizenzkontrolle/contrôle des licences
 | Name/nom | Vorname/prénom | Pauschale | Reisespesen |  |  | Total | A/K/LK | Konto-Nr. | Bank / Post
 |  |  | bis 4 Std     50.-   bis 7 Std     75.-   ab  7 Std  100.- | Km | Km x 0.60 | SBB |  |  |  |  | Visum
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
 |  |  | Datum/ date
 |  |  | Unterschrift/ signature OSR
Spreadsheet: stacey_white__38997__West Daily Prices0928-01
Sheet: Off Peak Detail

Report Date
Off-Peak Prices
 |  |  | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 |  |  |  |  | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00 | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 2002-06-01 00:00:00 | 2002-07-01 00:00:00 | 2002-08-01 00:00:00 | 2002-09-01 00:00:00 | 2002-10-01 00:00:00 | 2002-11-01 00:00:00 | 2002-12-01 00:00:00 | 2003-01-01 00:00:00 | 2003-02-01 00:00:00 | 2003-03-01 00:00:00 | 2003-04-01 00:00:00 | 2003-05-01 00:00:00 | 2003-06-01 00:00:00 | 2003-07-01 00:00:00 | 2003-08-01 00:00:00 | 2003-09-01 00:00:00 | 2003-10-01 00:00:00 | 2003-11-01 00:00:00 | 2003-12-01 00:00:00 | 2004-01-01 00:00:00 | 2004-02-01 00:00:00 | 2004-03-01 00:00:00 | 2004-04-01 00:00:00 | 2004-05-01 00:00:00 | 2004-06-01 00:00:00 | 2004-07-01 00:00:00 | 2004-08-01 00:00:00 | 2004-09-01 00:00:00 | 2004-10-01 00:00:00 | 2004-11-01 00:00:00 | 2004-12-01 00:00:00 | 2005-01-01 00:00:00 | 2005-02-01 00:00:00 | 2005-03-01 00:00:00 | 2005-04-01 00:00:00 | 2005-05-01 00:00:00 | 2005-06-01 00:00:00 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | 2007-07-01 00:00:00 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
5x8 [NAME] |  | Oct-Dec 01 |  |  |  | 2001 Total |  |  |  |  |  |  |  |  |  |  |  |  | 2002 | 2003 | 2004-2010 | > 2011 | Total Off-Peak
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | NEPOOL
ALBERTA
ALBERTA | NYPP
Sat 2x16
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | NEPOOL
ALBERTA
ALBERTA | NYPP
Sun 2x16
MID-COLUMBIA | TenMinSpin
COB | OpRes
NP15
ZP26
SP15 | NEPOOLU
Palo Verde | NEPOOLU
Mead | 53
ALBERTA
ALBERTA | 53.5
Spreadsheet: 157267d1337689104-how-to-create-an-equation-to-calculate-results-for-a-judging-contest-tabulation
Sheet: Sheet1

Contestants Placing (given) | Official Placing (given) | Cuts (given) | Desired Calculated Score
1234 | 3124 | 2-1-6 | 45
3412 | 4321 | 3-7-5 | 42
2341 | 4123 | 2-5-4 | 18
 | Links that may be helpful to understand what I am asking:
 | http://animalscience.tamu.edu/images/pdf/beef/beef-livestock-judging.pdf
 | [NAME]
PREFERRED [NAME]
 | Official Placings | Cuts
Class #1, Hol. Fall Calves
Class #2, [NAME] yrlg
etc
 | Class #1 |  | Class #2
 | Holstein Fall Calves |  | Jersey Summer yrlg
Contestant Names | Contestant Placing | Score | Contestant Placing | Score | etc.
[NAME]
Freddie Jones
[NAME]
ETC
Spreadsheet: 718892d1613407330-rank-select-conditional-format-test-chart
Sheet: Test Chart

#1 | #2
7 | 7
5 | 5
5 | 4
4 | 1 | result
#1 | #2
8 | 8
6 | 6
4 | 3
6 | 6 | result
 |  | 10
#1 | #2
4 | 2
6 | 6
4 | 3
5 | 4 | result
 |  | 7
#1 | #2
5 | 5
6 | 6
6 | 5
4 | 3 | result
 |  | 9
#1 | #2
5 | 5
4 | 3
7 | 6
5 | 4 | result
 |  | 8
Spreadsheet: 480691d1474029337-formula-for-see-data-excel-formula
Sheet: Data

Names | Location | Grade | Level | Date |  |  | Month
Ajay | A Road | A | 1 | 2016-06-16 00:00:00
Atul | B Road | B | 1 | 2016-06-16 00:00:00
Dany | C Road | C | 1 | 2016-07-15 00:00:00
[NAME] | D Road | D | 1 | 2016-07-15 00:00:00
Ajay | A Road | D | 1 | 2016-08-10 00:00:00
Atul | B Road | B | 2 | 2016-08-10 00:00:00
Dany | C Road | C | 2 | 2016-09-20 00:00:00
[NAME] | D Road | D | 2 | 2016-09-20 00:00:00
Atul | B Road | B | 2 | 2016-09-20 00:00:00
Spreadsheet: 215031d1361231112-data-comparison-between-worksheets-of-very-different-sizes-test-suppress
Sheet: Sheet1

Test ID#1 | Test NM | Other | Other | Suppress?
1 | name |  |  | suppress
15 | name
38 | name |  |  | suppress
39 | name
51 | name
55 | name
73 | name
90 | name |  |  | suppress
94 | name
99 | name
Spreadsheet: 860730d1708716028-trying-to-combine-info-in-two-different-files-that-each-have-different-info-i-need-sample-file
Sheet: Device information

Serial Number | Equipment ID | First Name | Last Name | Patron ID | Computer Name | Last Action Date | Status
G754J39 | 1234567890 | Sue | Smith | 123456 | [NAME] 21 | 2024-02-23 00:00:00 | Checked Out
G84K69 | 2345678901 | [NAME] | [NAME] | 135790 | [NAME] 21 | 2020-01-02 00:00:00 | Checked Out
JL58SJ | 3456789012 | [NAME] | Jones | 246801 | [NAME] 21 | 2023-05-04 00:00:00 | Checked Out
P6K38S | 4567890123 | [NAME] | [NAME] | 121314 | [NAME] 21 | 2023-05-04 00:00:00 | Checked Out
KJ7J8R | 5678901234 | Wally | White | 151718 | [NAME] 21 | 2010-09-01 00:00:00 | Checked Out
[NAME] | 6789012345 | [NAME] | Wayne | 579544 | [NAME] 21 | 2024-02-23 00:00:00 | Checked Out
37FDRJ | 7890123456 | [NAME] | Kent | 123575 | [NAME] 21 | 2020-01-02 00:00:00 | Checked Out
86K2H | 8901234567 | [NAME] | [NAME] | 975684 | [NAME] 21 | 2023-05-04 00:00:00 | Checked Out
8LHJR | 9012345678 | [NAME] | Rogers | 136547 | [NAME] 21 | 2023-05-04 00:00:00 | Checked Out
NM74I | 9234567807 | Ororo | Munroe | 156975 | [NAME] 21 | 2010-09-01 00:00:00 | Checked Out
Spreadsheet: 55273d1255428075-a-formula-to-work-out-different-sums-in-one-column-sample-2-
Sheet: Sheet1 (2)

 |  |  |  |  |  |  |  |  |  |  | 155
 |  |  |  |  | 2009-02-01 00:00:00 |  | 5
 | Month | Cash | Credit | Sums |  | 2009-01-01 00:00:00 | ***The Figures in blue in the 'Sums' column, are the expected result of the required formula in column "E"
 | 2009-01-01 00:00:00 | 100 | 30 | 155 | ←Month Credit | 2009-02-01 00:00:00
 |  | 80 | 75 |  |  | 2009-03-01 00:00:00
 |  |  |  | 455 | ←Month Total | 2009-04-01 00:00:00
 |  | 120 | 50 | 455 | ←Progressive Total | 2009-05-01 00:00:00 | As an example,For March,"Month Credit" is equal to SUM(D18:D21), "Month Total" is SUM(C18:D21), Progressive Total is SUM(C10:D21), and so on for the rest of the months oh the year
 | 2009-02-01 00:00:00 |  |  | 105 | ←Month Credit | 2009-06-01 00:00:00
 |  | 95 | 65 |  |  | 2009-07-01 00:00:00
 |  | 95 |  | 385 | ←Month Total | 2009-08-01 00:00:00
 |  | 90 | 40 | 840 | ←Progressive Total | 2009-09-01 00:00:00
 | 2009-03-01 00:00:00 | 70 | 25 | 100 | ←Month Credit | 2009-10-01 00:00:00
 |  | 130 | 45 |  |  | 2009-11-01 00:00:00
 |  |  | 30 | 360 | ←Month Total | 2009-12-01 00:00:00 | Calculations to start from the chosen month [in cell 'F7' till the end of December, Cell '[NAME].This is impotant mainly for the progressive sum to be calculated from a particular month
 |  | 60 |  | 1200 | ←Progressive Total
 | 2009-04-01 00:00:00 | 100 | 12 | 12 | ←Month Credit
 |  |  |  | 112 | ←Month Total
 |  |  |  | 1312 | ←Progressive Total
 | 2009-05-01 00:00:00 | 40 | 70 | 150 | ←Month Credit
 |  |  |  |  |  |  | Or, If we ignore cell 'F7' altogether [i.e. no particular month to be selected], can we have one single formula to give us the sums in column E ,and save us the trouble of having to use 3 different formulas for each month {that is 36 formulas for the whol
 |  |  | 80 | 190 | ←Month Total
 |  |  |  | 1502 | ←Progressive Total
 | 2009-06-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-07-01 00:00:00 |  |  | 10 | ←Month Credit
 |  | 50
 |  |  |  | 60 | ←Month Total
 |  |  | 10 | 1562 | ←Progressive Total
 | 2009-08-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-09-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-10-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-11-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  | 0 | ←Month Total
 |  |  |  |  | ←Progressive Total
 | 2009-12-01 00:00:00 |  |  | 0 | ←Month Credit
 |  |  |  |  | ←Month Total
 |  |  |  |  | ←Progressive Total
Spreadsheet: 198163d1354679310-if-two-values-are-equal-index-to-return-name-that-match-on-cell-range-score-board-vlady
Sheet: Sheet4

A sort of summary
 |  |  |  |  |  |  | this will be in range F47 to F56
 |  |  |  |  |  | 10 |  | <---formula using index,small...array formula
 |  |  |  |  |  | 9
 |  |  |  |  |  | 9
 |  |  |  |  |  | 7
 |  |  |  |  |  | 7
 |  |  |  |  |  | 5
 |  |  |  |  |  | 5
 |  |  |  |  |  | 4.5
 |  |  |  |  |  | 4
 |  |  |  |  |  | 4
Spreadsheet: mary_fischer__25725__20Q MTM Summary
Sheet: Apr

Enron Energy Services
MTM Summary
Company 20Q
 |  |  |  | Beginning |  |  |  | Ending
Date |  | Account MSA/SAP |  | Balance |  | Change |  | Balance
4/00 |  | 2106-0000 Asset-C |  | 1277047002 |  |  |  | 115054129
4/00 |  | 3030-0000 Liab-C |  | -1247510983 |  |  |  | -81959033
4/00 |  | 2510-0200 Prudency |  | 12033165 |  |  |  | 0
4/00 |  | 2510-0300 Prudency |  | 0 |  |  |  | -5219756
4/00 |  | 2510-0000 Asset-NC |  | 196011309 |  |  |  | 138294843
4/00 |  | 3310-0000 Liab-NC |  | -155003635 |  |  |  | -34927736
4/00 |  | 2003-2500 Liquidation |  | 0 |  |  |  | 0
 |  |  |  |  |  | Ending
Date |  | Account |  |  |  | Balance
4/00 |  | 4200-0000 MTM Rev |  |  |  | -57338653
 |  | Difference
Spreadsheet: 870163d1716723649-is-there-a-way-to-simplify-this-formula-excel-help-with-formulas-
Sheet: List

Contracts |  | Reason for Days Lost
 |  | Down time reasons
Contract B |  | X
Contract C |  | WEATHER
Contract D |  | TRUCK BREAK DOWN
Contract E |  | AGENCY CREW ISSUE
Contract F |  | CONTRACT
Contract G |  | WORKSHOP
Contract H |  | UNIT BREAKDOWN
Contract I |  | AVALIBLE FOR CONTRACT
Contract j |  | VELOCITY CREW ISSUE
Contract K |  | SPARE ON CONTRACT
Contract L |  | CREW TRAVEL
Contract M |  | MATERIAL ISSUE
Contract N
Contract O
Contract P
Contract Q
0
Spreadsheet: 762131d1641403663-excel-formula-to-find-first-and-last-occurrence-based-on-date-and-time-sample-firstlast
Sheet: Sheet2

Provider Code | Member Code | Claim Source | Creation Date | Treatment Month | Gross/Charged Amount | Apperance Status
6212000032 | 761102 | E SERVICES | 2021-12-14 14:12:37 | 10 | 81
6212000032 | 761102 | WASEEL | 2021-12-20 15:01:30 | 10 | 81
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:31 | 10 | 24.7 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:19 | 10 | 30 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:29 | 10 | 30 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:03:50 | 10 | 33.15 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:02:57 | 10 | 62.45 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:32 | 10 | 100 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:00:28 | 10 | 154.7 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:01:24 | 10 | 198.15 | -
6212000032 | 1511256 | E SERVICES | 2021-12-14 14:12:21 | 10 | 206.1 | -
6212000032 | 1511256 | WASEEL | 2021-12-20 15:03:34 | 10 | 236.1 | -
6212000032 | 1533705 | E SERVICES | 2021-12-14 14:13:15 | 10 | 151.05 | First E SERVICES
6212000032 | 1533705 | WASEEL | 2021-12-20 15:04:13 | 10 | 151.05 | Second WASEEL
6212000032 | 1581525 | E SERVICES | 2021-12-14 14:12:24 | 10 | 68.15
6212000032 | 1581525 | E SERVICES | 2021-12-14 14:12:22 | 10 | 130
6212000032 | 1865302 | E SERVICES | 2021-12-14 14:10:57 | 10 | 84.15 | First E SERVICES
6212000032 | 1865302 | WASEEL | 2021-12-20 15:01:00 | 10 | 84.15 | Second WASEEL
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:36 | 10 | 60
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:34 | 10 | 112.4
6212000032 | 2284575 | E SERVICES | 2021-12-14 14:10:32 | 10 | 150
6212000032 | 1912266 | E SERVICES | 2021-12-20 15:02:46 | 10 | 105.2 | Second E SERVICES
6212000032 | 1912266 | WASEEL | 2021-12-14 14:10:57 | 10 | 105.2 | First WASEEL
Spreadsheet: 715475d1611726526-formula-to-get-the-first-date-of-transaction-sample-workbook
Sheet: Sheet1

Customer | Purchased Date |  |  | Expected Result:
A | 2019-07-19 00:00:00 |  |  | Customer | Date of First Purchased
A | 2020-02-12 00:00:00 |  |  | A | 2019-07-19 00:00:00
A | 2020-01-29 00:00:00 |  |  | B | 2018-04-25 00:00:00
A | 2020-06-28 00:00:00
A | 2020-10-21 00:00:00
A | 2020-08-26 00:00:00
A | 2020-07-02 00:00:00
A | 2020-05-31 00:00:00
A | 2020-06-26 00:00:00
A | 2020-03-11 00:00:00
A | 2020-10-28 00:00:00
A | 2020-04-24 00:00:00
A | 2020-04-24 00:00:00
B | 2020-04-25 00:00:00
B | 2018-04-25 00:00:00
B | 2019-04-25 00:00:00
Spreadsheet: monika_causholli__28124__RISIForecast_II
Sheet: Sheet1

 | SBSK | SBHK | NBSK | NBHK
 | Del to US | Del to US | Del to US | Del to US
 | US$[NAME] | US$[NAME] | US$[NAME] | US$[NAME]
2000:1 | 620 | 600 | 640 | 610
2000:2 | 660 | 640 | 680 | 650
2000:3 | 690 | 670 | 710 | 680
2000:4 | 687 | 667 | 710 | 677
2001:1 | 623 | 595 | 665 | 622
2001:2 | 487 | 453 | 560 | 495
2001:3 | 413 | 397 | 483 | 417
2001:4 | 430 | 415 | 480 | 430
2002:1 | 455 | 435 | 500 | 450
2002:2 | 474 | 455 | 520 | 470
2002:3 | 485 | 465 | 520 | 480
2002:4 | 500 | 475 | 535 | 490
2003:1 | 520 | 495 | 555 | 510
2003:2 | 555 | 530 | 585 | 545
2003:3 | 585 | 560 | 615 | 575
2003:4 | 610 | 585 | 640 | 600
2004:1 | 645 | 620 | 675 | 635
2004:2 | 680 | 650 | 710 | 665
2004:3 | 710 | 680 | 740 | 695
2004:4 | 725 | 700 | 760 | 715
2005:1 | 725 | 695 | 760 | 715
2005:2 | 700 | 665 | 740 | 690
2005:3 | 660 | 620 | 710 | 650
2005:4 | 620 | 575 | 680 | 605
2006:1 | 585 | 540 | 645 | 570
2006:2 | 545 | 495 | 600 | 525
2006:3 | 510 | 455 | 560 | 485
2006:4 | 475 | 425 | 520 | 450
Spreadsheet: 840896d1693139954-trying-to-conditionally-format-columns-based-on-dynamic-cell-values-whole-school-compass-export-template
Sheet: Scale

Scale |  | Level |  | [NAME]
A | Below | B |  |  | 12 months or more below the expected achievement level
B | Below | C |  |  | 6 months below the expected achievement level
C | Below | D |  |  | At the expected achievement level
D | Below | 0.5 |  |  | 6 months above the expected achievement level
0.5 | Half way through | Foundation |  |  | 12 months or more above the expected achievement level
F | At the end of | Foundation
F.5 | Half way through | 1
1 | At the end of | 1
1.5 | Half way through | 2
2 | At the end of | 2
2.5 | Half way through | 3
3 | At the end of | 3
3.5 | Half way through | 4
4 | At the end of | 4
4.5 | Half way through | 5
5 | At the end of | 5
5.5 | Half way through | 6
6 | At the end of | 6
6.5 | Half way through | 7
7 | At the end of | 7
7.5 | Half way through | 8
8 | At the end of | 8
8.5 | Half way through | 9
9 | At the end of | 9
9.5 | Half way through | 10
10 | At the end of | 10
Spreadsheet: 804075d1667872592-need-help-populating-columns-please-test1
Sheet: Sheet1

Invoice Name | Area | Department | T1 Manager | T2 Manager | T3 Manager |  | Invoice Name | Area | Department | T1 Manager | T2 Manager | T3 Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager |  |  |  |  | [NAME] | Sainsburys Depots | Zone Manager |  | [NAME]
DANIEL HUCKER | Sainsburys Depots | Zone Manager |  |  |  |  | [NAME] | Retail FM Field Operations | Zone Fabric Specialist | [NAME] | [NAME] | [NAME]
DANIEL HUCKER | Sainsburys Depots | Zone Manager |  |  |  |  | [NAME] | Retail FM Field Operations | Zone Fabric Specialist | [NAME] | [NAME] | [NAME]
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
DANIEL HUCKER | Sainsburys Depots | Zone Manager
SIMON REID | Retail FM Field Operations | Zone Fabric Specialist
SIMON REID | Retail FM Field Operations | Zone Fabric Specialist
SIMON REID | Retail FM Field Operations | Zone Fabric Specialist
SIMON REID | Retail FM Field Operations | Zone Fabric Specialist
[NAME] | Retail FM Field Operations | Zone Fabric Specialist
[NAME] | Retail FM Field Operations | Zone Fabric Specialist
[NAME] | Retail FM Field Operations | Zone Fabric Specialist
[NAME] | Retail FM Field Operations | Zone Fabric Specialist