tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 18010a96-33ef-430a-adbc-98739765a187
Sheet: Sheet1

Deposit Check List | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | 1- Separate all bills according to denomination. |  |  |  |  |  | Account Name:
 | 2- "Face" all bills (turn them all with picture up and facing the same direction). |  |  |  |  |  | GSHOM Troop #
 | 3- Separate checks and put in order from smallest to largest. |  |  |  |  |  | Account Number:
 | 4- Endorse all checks.
 | 5- Count each in #1 and #3 above and total. |  |  |  |  |  | DEPOSIT TOTAL: | 0
 | 6- Add all denomination totals for Deposit Total.
 | 7- [NAME] out deposit ticket. Attach extra sheet if numerous checks.
 | 8- Have deposit ready according to denomination when you walk into bank. |  |  |  |  |  | Deposited By:
 | Do not go through the drive thru - large deposits need to be made in the lobby. |  |  |  |  |  | Deposit Slip Code:
 | CHECKS |  |  |  |  |  | BILLS
 | Check Number | Date | Name | Amount |  |  | Denomination | Total
 |  |  |  | 0 |  |  | One's | 0
 |  |  |  | 0 |  |  | Two's | 0
 |  |  |  | 0 |  |  | Five's | 0
 |  |  |  | 0 |  |  | Ten's | 0
 |  |  |  | 0 |  |  | Twenty's | 0
 |  |  |  | 0 |  |  | Fifty's | 0
 |  |  |  | 0 |  |  | One-Hundred's | 0
 |  |  |  | 0 |  |  | Bills Total | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | CHECKS TOTAL: |  |  | 0
Spreadsheet: 12af89da-1c9d-4731-baae-21b483e286f8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
 | Werbeaufwendungen - Inhaltsverzeichnis
 | Quelle: Nielsen Media Research
 | BAU-WIRTSCHAFT
 | DIENSTLEISTUNGEN
 | ENERGIE
 | ERNAEHRUNG
 | FINANZEN
 | GESUNDHEIT + PHARMAZIE
 | GETRAENKE
 | [NAME]
 | HAUS-,LAND-,FORST-,JAGD-WIRT.
 | HAUS- + GARTENAUSSTATTUNG
 | KOERPERPFLEGE
 | KRAFTFAHRZEUG-MARKT
 | [NAME]
 | REINIGUNG
 | [NAME]
 | TELEKOMMUNIKATION
 | TEXTILIEN + BEKLEIDUNG
 | TOURISTIK + GASTRONOMIE
 | UNTERHALTUNGSELEKTRONIK
 | VERKEHRS-MITTEL + -EINRICHTUNG
Spreadsheet: chris_germany__1683__200004strg
Sheet: Strg Rules

Deal Id
Month | 2000-05-01 00:00:00
 |  | Pipe | Zone | MeterCode
 |  | CGAS |  |  | Sum
 |  | APPALACHIA |  | Sum |  | 6050607
 | Date | STOI - CGAS STORAGE | Sum
 | 1 | 79864
 | 2
 | 3 | 99830
 | 4 | 99830
 | 5 | 68188
 | 6 | 98096
 | 7 | 82040
 | 8 | 84486
 | 9 | 72
 | 10 | 20400
 | 11
 | 12 | 48000
 | 13 | 20400
 | 14
 | 15
 | 16 | 22900
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
 | Sum
less than 20% to 10% |  |  |  | 0.65
less than 10% to 0% |  |  |  | 0.5
If 103% of MDWQ is exceeded a penalty of $10.00 per dkt for all quantitites withdrawn in excess
of 103% of its MDWQ will be assessed.
Minimum and [NAME] net withdrawal for November thru March
 |  | Min % |  |  | [NAME]
Month |  | of SCQ |  |  | of SCQ
November |  | none |  |  | 0.4
December |  | none |  |  | 0.4
January |  | none |  |  | 0.4
February |  | 0.1 |  |  | 0.3
March |  | 0.1 |  |  | 0.2
If monthly net withdrawal exceeds applicable limits a penalty of $5.00 per dkt for all quantities
withdrawn in excess of such limits will be assessed.
INVENTORY: |  | no more than x% in SCQ in storage
April 1st |  | 0.25
February 1st |  | 0.65
June 30th |  | 0.6
August 31st |  | 0.85
Spreadsheet: 846746d1697894840-problem-using-sumproduct-and-match-to-rank-golf-teams-scores-if-the-scores-are-drawn-scoresheettest
Sheet: Scores

Date | Team | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | TotPoints | Rank18 | Match18 | Team18 | Bk9Rank | MatchBk9 | TeamBk9 | Position
2023-11-06 00:00:00 | Divots'R'Us | 7 | 8 | 9 | 6 | 7 | 8 | 9 | 5 | 7 |  | 9 | 8 | 9 | 9 | 8 | 9 | 9 | 7 | 8 |  |  |  |  |  |  |  |  | 4
2023-11-06 00:00:00 | Oliver's Army | 8 | 8 | 8 | 7 | 8 | 7 | 8 | 9 | 8 |  | 6 | 7 | 6 | 8 | 6 | 9 | 6 | 7 | 6 |  |  |  |  |  |  |  |  | 3
2023-11-06 00:00:00 | The 49ers | 7 | 8 | 9 | 6 | 9 | 8 | 7 | 4 | 8 |  | 8 | 8 | 7 | 8 | 9 | 8 | 8 | 7 | 7 |  |  |  |  |  |  |  |  | 5
2023-11-06 00:00:00 | The Blue Villains | 7 | 8 | 9 | 6 | 7 | 8 | 9 | 5 | 7 |  | 8 | 8 | 9 | 8 | 7 | 6 | 9 | 8 | 7 |  |  |  |  |  |  |  |  | 1
2023-11-06 00:00:00 | The Fab Four | 9 | 8 | 9 | 9 | 8 | 9 | 9 | 7 | 8 |  | 9 | 8 | 9 | 9 | 8 | 9 | 9 | 7 | 8 |  |  |  |  |  |  |  |  | 6
2023-11-06 00:00:00 | The Longshots | 9 | 8 | 9 | 9 | 8 | 9 | 9 | 7 | 8 |  | 7 | 9 | 8 | 7 | 8 | 6 | 7 | 8 | 7 |  |  |  |  |  |  |  |  | 2
Spreadsheet: 539864d1506412103-sum-using-multipul-vookup-mz-sales-budget-plan-2018-working
Sheet: 62600

AM Layyah | Plan FY | Actual YTD | [NAME] | 4Q OL | [NAME] | [NAME]
[PHONE] STAFF MEETINGS,ENTT | 17000 | 0
[PHONE] PRINTING/STATIONERY | 4000 | 3210
[PHONE] BOOKS PERIODICALS | 2000 | 0
[PHONE] OFF FURN/EQP M&R | 4000 | 0
[PHONE] COMPUTER MAINT | 0 | 5000
[PHONE] REPRODUCTION CHG | 2000 | 442
[PHONE] POSTAGE CHG | 8000 | 8011
[PHONE] TELEPHONES CHG | 28000 | 6513
[PHONE] INTERNET USAG CHG | 12000 | 11940
[PHONE] RECOV FOR PVT.TEL | 0 | -4378
[PHONE] LOCAL-BUSS TRAVEL | 89000 | 32944
[PHONE] REGIS & TAXES | 4000 | 6514
[PHONE] POL & SERVICES | 156000 | 266951.24
[PHONE] REP  PARTS & ACCESS | 8000 | 6820
[PHONE] PRIVATR MILEAGE | -13000 | -26192
[PHONE] OTH-VEH-TRAV EXP | 0 | 0
[PHONE] OTHERS-GR/PR EXP. | 7000 | 2900
[PHONE] BUS. MEETING & ENT. | 20000 | 19110
[PHONE] INSURANCE EXPENSE | 0 | 560.42
[PHONE] INSURANCE EXPENSE MA | 0 | 744
[PHONE] TAXES STAMPS & LICS | 0 | 5280
Spreadsheet: 069a8ebe-84f9-4184-8f9b-f95b9db445e2
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | Name_____________________________ | ID#______________________
 | BA Anthropology
 |  | HR | GR | SM
Area of Concentration Requirements | Core Requirements:
 | Anth 2023 Foundations of Linguistics | _____ | _____ | _____
 | Anth 2033 Human Development | _____ | _____ | _____
 | Anth 2043 Patterns in Culture:  Cultural Anthro | _____ | _____ | _____
1.        You must have a minimum GPA of 2.2 | [NAME] Cultures Before History:  Archaeology | _____ | _____ | _____
in your area of concentration and a minimum of
2.0 TU GPA in order to graduate. | Electives:  12 hours required, including at least 3 hours in archaeology/physical anthropology
 | and 3 hours in cultural anthropology/linguistics.
2.        No Pass/D/F or CLEP credit may be
applied toward your Area of Concentration. | Archaeology/Physical Anthropology Area:  Anth 2114, Anth 2233, Anth 3133, Anth 4033, Anth 4043,
 | Anth 4113, Anth 4223, Anth 4503, Anth 4513.
3.    Courses applied to meet Core and General
Curriculum requirements cannot also apply in | Cultural Anthropology/Linguistics Area:  Anth 1063, Anth 3103, Anth 3123, Anth 3163, Anth 3173,
your Area of Concentration. | Anth 3443, Anth 4013, Anth 4083, Anth 4213, Anth 4403, Anth 4633, Anth 4863, Anth 4053.
 | ___________________________________ | _____ | _____ | _____
4.   Two thirds of the course work in your | ___________________________________ | _____ | _____ | _____
Major [NAME] must be at the 3000 or 4000 level. | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
5.     Subjects in your Minor Field must be
selected in conjunction with your [NAME] | Research Methods:  3 hours required | _____ | _____ | _____
 | Anth 4053 Archaeological Analysis   OR | _____ | _____ | _____
6.  No more than 55 hours may be earned in the | Anth 4063 Qualitative Methods in Anth  Research | _____ | _____ | _____
Area of Concentration, and no more than 39 of
these may be earned in the major subject. | Theory:  3 hours required
These totals may be exceeded only by the | Anth 4763 History of Anthropological Theory | _____ | _____ | _____
number of hours beyond the 124 required for
graduation. | [NAME] Senior Seminar
 | Senior Project:  3 hourse required
 | Anth 4973, Research Seminar in Anthropology | _____ | _____ | _____
[NAME]:  __________________________
 | Minor - 12-15 hours with 6 hours 3000-4000 level.
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
 | ___________________________________ | _____ | _____ | _____
Spreadsheet: 24100d1214222403-help-to-sum-too-long-demo
Sheet: Sheet1

Cost |  |  |  | July
Cost | 24 | 25 | 26 | 27 | 28 | 29 | 30
1655
234 | 14 | 3 |  |  |  | 44
1700 | 3 | 14 | 1 |  |  |  | 33
1700 |  |  |  | 45 | 3 | 4 | 23
158 |  | 6 | 6 |  |  |  | 1
1700 |  |  | 18 |  |  | 1
1700 |  | 2 |  |  |  |  | 1
1735 |  |  |  | 16
Spreadsheet: 886762d1736866558-pulling-a-list-of-values-based-on-two-conditions-spesifikasyon
Sheet: Sheet1

18 | Etiket Hatası (Ters, Kaymış, Yanlış) | [NAME] | Minor
19 | Barkod Etiket Hatası | [NAME] | Critical
20 | Eğri (Kafa, Boyun, Gövde) | Curve (Finis, Neck, Body) | Minor
21 | Göçük | [NAME] | Minor
22 | Şiş Gövde/ Geniş çap | Bulged sides | Major
23 | Dip Oturmazlığı | Rocker bottom | Major
24 | Kontaminasyon | Contamination | Critical
25 | [NAME] baskısı | Indistiınct serigraphy | Minor
26 | Menteşe kopması | Hinge break | Major
27 | Ezik | Crushed | Major
28 | Şekil dışı | Freaks | Critical
29 | [NAME] | Wounded mold | Major
30 | [NAME] | Lock failure | Major
31 | [NAME] | [NAME] isagreement | Major
32 | [NAME] | Mold sweating | Minor
Spreadsheet: 364246d1418306483-how-to-count-the-order-of-occurrence-of-duplicates-count-occurence-number
Sheet: Sheet1

 |  |  |  |  |  | 1
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 2
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 3
 |  |  |  |  |  | 4
 |  |  |  |  |  | 5
 |  |  |  |  |  | 6
 |  |  |  |  |  | 7
Spreadsheet: 782816d1654283950-vlookup-function-with-a-barcode-scanner-2022-06-03-oeldere-norm2204-scann-test-v3222
Sheet: donnée

Code barre interne | Code | Description Française 1 | Unité d'inventaire
1000 | - |  | UN
1001 | -- | APPT.: # 2 | UN
1002 | --- | APPT. # 3 | UN
1003 | ---- | APPT.: # 4 | UN
1003 | ----- | APPT.: # 5 | UN
1003 | ------ | APPT.: # 6 | UN
1003 | ------- | APPT.: # 7 | UN
1003 | -------- | APPT.: # 8 | UN
1003 | --------- | APPT.: # 9 | UN
1003 | ---------- | APPT.: # 10 | UN
1003 | ----------- | APPT.: # 11 | UN
1003 | ------------ | EDIFICE:  422, RUE TARDIF EST | UN
1003 | ------------- | [NAME]:  418, RUE TARDIF EST | UN
1003 | -------------- | APPT.:  # 12 | UN
1004 | 001-A | ÉLECTRICIEN | HR
1005 | 001-B | ÉLECTRICIEN- TAUX ET DEMI | HR
1006 | 001-C | ÉLECTRICIEN- TAUX DOUBLE | HR
12792 | 003-A | ÉLECTRICIEN TAUX CONTRACTEUR | HR
12793 | 003-B | TEMPS DEMI TAUX CONTRACTEUR | HR
12794 | 003-C | ÉLECTRICIEN TEMPS DOUBLE TAUX CONTRACTEUR | HR
1013 | 009-A | PLOMBIER | HRS
1014 | 009-B | PLOMBIER - TAUX ET DEMI | HRS
1015 | 009-C | PLOMBIER - TAUX DOUBLE | HRS
7940 | 01 | NETTOYAGE COUVERTURES | UN
1016 | 010-A | APPRENTI - PLOMBIER | HRS
1017 | 010-B | APPRENTI - PLOMBIER- TAUX ET DEMI | HRS
1018 | 010-C | APPRENTI - PLOMBIER- TAUX DOUBLE | HRS
1019 | 011 | PLOMBIER TAUX CONTRACTEUR | HRS
1021 | 011-B | PLOMBIER - TAUX ET DEMI TAUX CONTRACTEUR | HRS
1022 | 011-C | PLOMBIER- TAUX DOUBLE TAUX CONTRACTEUR | HRS
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 11b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis* | <100 | <100 | 124 | 394 | 518
FRA | 8031 | 4060 |  | 5332 | 17423
IRS- [NAME] | 12953 | 2897 | 2591 | 8138 | 26579
OIS | 1446 | 300 |  | 366 | 2112
VNS | <100 |  |  |  | <100
Zero Coupon | <100 | 104 |  | <100 | 104
TOTAL | 22430 | 7361 | 2715 | 14230 | 46736
Estimated swap transaction volumes, week ending January 18, by product type and supermajor currency (millions of USD), all participant types, cleared and uncleared.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Data Dictionary for supermajor currency descriptions.
***N/A indicates that data are not currently available.
Note: Transaction volumes currently include house and client trades by FCMs in the interest rate asset class.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 98216d1297214090-populating-a-list-lookup-list
Sheet: Data

 | 1-1 | 2-1 | 3-1 | 4-1 | 5-2 | 1-1 | 2-1 | 3-1 | 4-1 | 5-2 | 1-1 | 2-1 | 3-1 | 4-1 | 5-2 | 1-1 | 2-1 | 3-1 | 4-1 | 5-2
 | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 1-1
 | A | G | L | Q
 | 1 | 7 | 11 | 16
Spreadsheet: 112205d1308318250-simplify-a-complex-formula-sample1
Sheet: January

January Numbers as of 05/04/2011
Name | # | W1 | [NAME] | U1 | U2 | EMS | Com. | Total
name | 7 | 12345 | 67894
name | 10 | 4512.12 | 65483.3
name | 20 | 52156 | 12345
name | 13 | 45888 | 5495.12
name | 9 | 42513 | 2654.12
name | 23 | 23156 | 21654
name | 16 | 23548 | 12166
name | 8 | 32156 | 1245 |  |  | 5
name | 24 | 213
---------------------------------------------------------------------------------
name | 21 | 124 | 520 | 1245 | 5246 | 6842
name | 22 |  |  | 1111 | 1245 | 6548
 |  |  |  |  | W Total
 |  |  |  |  | U, EMS, & Com Total
 |  |  |  |  | TOTAL
Spreadsheet: 48386d1247603166-parts-bin-replenishment-sheet-inventory-position
Sheet: Sheet1

 |  |  |  |  |  |  | 6 | 2009-01-08 00:00:00
Part # | Current Period | Total Stocked | Usage/Day | Days til Fill | Refill Day | Refill Date
 |  |  |  |  |  |  | Start Date
Station 1 |  |  |  |  |  |  | 2009-01-01 00:00:00 | 2009-01-03 00:00:00 | 2009-01-05 00:00:00 | 2009-01-08 00:00:00
N | H6:$K$6 | 23500 | 4000 | 2 | 5 | 2009-01-10 00:00:00 | 6000 | 5000 | 5500 | 7000
P | H7:$K$7 | 11500 | 2000 | 2 | 5 | 2009-01-10 00:00:00 | 3000 | 3000 | 2000 | 3500
D | H8:$K$8 | 9650 | 1700 | 2 | 5 | 2009-01-10 00:00:00 | 2100 | 2500 | 2900 | 2150
Spreadsheet: 0f5d47a4-5346-43f8-9502-a7fd463c1dbf
Sheet: Sheet1

Lecture | Day | Date | Topic |  | MKT 382 Srinivasan
1 | Wednesday | 2011-01-19 00:00:00 | Lecture: Overview of Course/Marketing Metrics
2 | Monday | 2011-01-24 00:00:00 | Ikea  Invades America - 9-504-094
 | Wednesday | 2011-01-26 00:00:00 | Lecture: Market Management
4 | Monday | 2011-01-31 00:00:00 | Classic Knitwear - Case (HBS 4217): Submission 1 |  | Grading
5 | Wednesday | 2011-02-02 00:00:00 | Lecture: Market Share Performance Metrics and Share Growth
6 | Monday | 2011-02-07 00:00:00 | Harrington Collection - Case (HBS 3258): Submission 2 |  | Attendance | 10
 | Wednesday | 2011-02-09 00:00:00 | Lecture: High Technology Marketing |  | CP | 20
 | Monday | 2011-02-14 00:00:00 | Lecture :New Product Management I |  | Midterm Exam | 20
 | Wednesday | 2011-02-16 00:00:00 | Synthes (9-502-008) |  | [NAME] | 25 |  | 3: 10, 10, 5 points each;
 | Monday | 2011-02-21 00:00:00 | Metrics Application to Marketing Current Events: I |  | Final Exam | 25
 | Wednesday | 2011-02-23 00:00:00 | Lecture: Pricing Metrics
 | Monday | 2011-02-28 00:00:00 | Metabical: (HBS 4183): Submission 3
 | Wednesday | 2011-03-02 00:00:00 | Midterm Exam Review
 | Monday | 2011-03-07 00:00:00 | Flexible class: Global
 | Wednesday | 2011-03-09 00:00:00 | Flexible class: Global
 | Monday | 2011-03-21 00:00:00 | Lecture: Advertising & Promotions Management
 | Wednesday | 2011-03-23 00:00:00 | Culinarian Cookware (HBS 4057): Submission 4
 | Monday | 2011-03-28 00:00:00 | Lecture: Emerging Markets: Strategies that Fit Emerging Markets (R0506C)
 | Wednesday | 2011-03-30 00:00:00 | Genicon: A Surgical Strike into Emerging Markets (910M41)
 | Monday | 2011-04-04 00:00:00 | Lecture: Customer Relationship Management: Mismanagement of Customer Loyalty: R0207F)
 | Wednesday | 2011-04-06 00:00:00 | Harrahs - Case (HBS: 9-502-211): Submission 5
 | Monday | 2011-04-11 00:00:00 | Lecture: BusinesstoBusinessMarketing: Building Loyalty in Business Markets (R0509H)
 | Wednesday | 2011-04-13 00:00:00 | Soren Chemical (HBS 4188): Submission 6
 | Monday | 2011-04-18 00:00:00 | Lecture: Social Media (9-510-095), ROI on Social Media (SMR 363)
 | Wednesday | 2011-04-20 00:00:00 | [NAME] (910M28)
 | Monday | 2011-04-25 00:00:00 | Marketing-Finance Interface I ((SSF Journal of Marketing 1998)
 | Wednesday | 2011-04-27 00:00:00 | Marketing-Finance Interface II
 | Monday | 2011-05-02 00:00:00 | United Breaks Guitars (9-510-057)
 | Wednesday | 2011-05-04 00:00:00 | Course Wrap-up
Spreadsheet: 747003d1631175700-formula-to-extract-text-from-sentence-formul
Sheet: Sheet1

List | ticket | hr | doc |  | My req | ticket | hr | doc
TICKET 156728 HR 324561 - implement the ticket | 156728 | 324561 |  |  |  | 156728 | 324561 | prod
subscription
text to see 12134
no data found
Doc file: DOC/prod.drvr, v no |  |  | prod
----------------------------
not going to school
[NAME]
doxt file
release ticket in version
doxt file
release ticket in version
TICKET 236728 HR 324561 - pending the ticket | 236728 | 324561 |  |  |  | 236728 | 324561 | empl
=============================
not going to school
Doc file: DOC/empl.drvr, v no |  |  | empl
TICKET 156728 HR 324561
doxt file
release ticket in version
doxt file
cccccc
TICKET 156728 HR 324561 - not getting any support on this ticket | 156728 | 324561 |  |  |  | 156728 | 324561 | dept
hey
are
you going
Doc file: DOC/dept.drvr, v no |  |  | dept
TICKET 156728 HR 324561- implement the ticket | 156728 | 324561 |  |  |  | 156728 | 324561 | vill
adfadj;s
dsalkadsjkf
fda;lkda
cdaa
[NAME]
Doc file: DOC/vill.drvr, v no |  |  | vill
dsalkadsjkf
fda;lkda
cdaa
[NAME]
Spreadsheet: 152cf769-a43f-4381-bc50-81b1d973e122
Sheet: Sheet1

CALS
Travel Expense Claim
Please complete fully and attach with documentation.  Items in yellow are requirements for processing.
Traveler Information
Traveler: |  |  |  |  | UI ID Number:
 |  |  |  |  | [NAME]:
Trip Authorization Number: |  |  |  |  | Phone:
Home work station
Trip Purpose, Destination, Dates
Destination: |  |  |  |  | Departure Date
 |  |  |  |  | Departure Time
Purpose: |  |  |  |  | Return Date
 |  |  |  |  | Return Time
Expenses Paid for By Department |  |  |  |  | Per Diem Record
Expense (Purchase Card) |  | Budget #: | Amount: |  | Budget #:
Airfare |  |  |  |  | Please mark an X for the meal/ full day if all 3 |  |  |  |  | Full
Lodging |  |  |  |  | Date of Meals |  | B | L | D | Day
Car Rental
Public Transportation
Registration
Gas for Car Rental
NOTE: These are expenses paid for by the department.
Expenses Paid for By [NAME]
Expense |  | Budget #: | Amount: |  | Spokane's GEG and CD'A: [NAME] 180 mi, Lewiston max 70 mi
Airfare |  |  |  |  | Personal Vehicle Miles
Lodging |  |  |  |  | Budget #
Car Rental |  |  |  |  | Destination
Public Transportation |  |  |  |  | Vicinity | (List on travel [NAME]) Total: (               )
Registration |  |  |  |  | Total Miles
Gas for Car Rental
Incidentals |  |  |  |  | Travel log
Parking |  |  |  |  |  | Destination |  | Odometer | [NAME] | Short Date
 |  |  |  |  | Start: |  |  |  | X
 |  |  |  |  | End:
NOTE: These are reimbursements to the traveler
 |  |  |  |  | Start: |  |  |  | X
 |  |  |  |  | End:
Trip Comments
 |  |  |  |  | Start: |  |  |  | X
 |  |  |  |  | End:
 |  |  |  |  | Start: |  |  |  | X
 |  |  |  |  | End:
 |  |  |  |  | Total Vicinity Miles
I certify that the above amounts are correct, that amounts claimed were incurred for University business purposes, and that no part
of the claim has been reimbursed to me or paid by the University or a third party.
Traveler Signature |  |  |  |  |  |  | Date
Spreadsheet: 728240d1618387659-index-match-formula-to-extract-specific-data-from-table-sample-file
Sheet: Sheet1

Initial table
Activity | 2021-04-01 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-06 00:00:00 |  |  | 2021-04-01 00:00:00
Activity 1 |  |  | 2 | 1 |  |  | 2021-04-02 00:00:00
Activity 2 |  | 2 |  | 3 |  |  | 2021-04-05 00:00:00
Activity 3 |  |  | 1 |  |  |  | 2021-04-06 00:00:00
Activity 4 |  | 2
Activity 5 |  |  | 1
Activity 6 | 5 |  |  | 2
Activity 7 |  |  |  | 1
Activity 8 |  | 2 | 3
Activity 9 |  | 2 |  | 1
Activity 10 | 3 |  | 1
Final table
Activity | 2021-04-02 00:00:00
Spreadsheet: phillip_allen__29528__IMPORTVOLUMES
Sheet: Data

 | MIDWEST |  |  | WEST |  |  | EAST |  |  |  | CANADA |  | Nova | Westcoast |  | Stanfield
 | NBPL |  | GRLK | PGT | PGT | NWPL | TENN | IROQ | EMPIRE |  | TCPL |  | Receipts | Receipts |  | Receipts
 | Monchy | Chicago Extension | Emerson | [NAME] | Malin | Sumas | [NAME] | Waddington | Chippawa |  | Empress |  |  |  |  | - into NWPL
 | 2180 | 663 | 1140 | 2620 | 1930 | 1640 |  | 865 | 463
1998-03-01 00:00:00 | 1519 | 0 | 1290 | 2449 | 1861 | 1039 | 800 | 809 | 99 |  | 6710 |  | 12454 | 2049
1998-04-01 00:00:00 | 1548 | 0 | 1207 | 2436 | 1750 | 984 | 717 | 823 | 77 |  | 6687 |  | 12538 | 2110 |  | -294
1998-05-01 00:00:00 | 1462 | 0 | 1173 | 2305 | 1782 | 834 | 778 | 823 | 106 |  | 6224 |  | 12192 | 1854 |  | -333
1998-06-01 00:00:00 | 1470 | 0 | 1283 | 2330 | 1840 | 886 | 857 | 844 | 116 |  | 6316 |  | 11991 | 1791 |  | -309
1998-07-01 00:00:00 | 1530 | 0 | 1517 | 2163 | 1789 | 925 | 815 | 855 | 77 |  | 6275 |  | 12302 | 1781 |  | -225
1998-08-01 00:00:00 | 1526 | 0 | 1004 | 2218 | 1760 | 1051 | 823 | 809 | 112 |  | 6272 |  | 12263 | 1804 |  | -231
1998-09-01 00:00:00 | 1499 | 0 | 1268 | 2366 | 1880 | 1259 | 861 | 856 | 159 |  | 6096 |  | 12324 | 1862 |  | -233
1998-10-01 00:00:00 | 1468 | 0 | 1334 | 2238 | 1798 | 1248 | 878 | 837 | 137 |  | 6386 |  | 12427 | 1916 |  | -190
1998-11-01 00:00:00 | 1462 | 0 | 1243 | 2331 | 1773 | 1129 | 838 | 838 | 175 |  | 7022 |  | 12518 | 1987 |  | -249
1998-12-01 00:00:00 | 1634 | 2 | 1302 | 2285 | 1800 | 1264 | 950 | 876 | 143 |  | 7022 |  | 12429 | 2060 |  | -372
1999-01-01 00:00:00 | 2089 | 520 | 1311 | 2263 | 1773 | 1359 | 964 | 854 | 153 |  | 7098 |  | 12328 | 1994 |  | -409
1999-02-01 00:00:00 | 2068 | 600 | 1174 | 2177 | 1655 | 1386 | 966 | 926 | 177 |  | 6773 |  | 12320 | 2013 |  | -298
1999-03-01 00:00:00 | 1998 | 653 | 1197 | 1973 | 1673 | 1205 | 975 | 981 | 174 |  | 6787 |  | 12595 | 2001 |  | -64
1999-04-01 00:00:00 | 2099 | 685 | 1285 | 1949 | 1806 | 1155 | 890 | 952 | 118 |  | 6656 |  | 12755 | 2150 |  | -67
1999-05-01 00:00:00 | 2102 | 649 | 1325 | 1832 | 1741 | 1142 | 963 | 967 | 107 |  | 6635 |  | 12479 | 1919 |  | -10
1999-06-01 00:00:00 | 2221 | 656 | 1358 | 1679 | 1726 | 965 | 953 | 977 | 105 |  | 6549 |  | 11916 | 1774 |  | 94
1999-07-01 00:00:00 | 2226 | 640 | 1360 | 1818 | 1758 | 1049 | 960 | 962 | 88 |  | 6574 |  | 12492 | 1838 |  | 3
1999-08-01 00:00:00 | 2194 | 661 | 1599 | 2147 | 1821 | 1066 | 997 | 907 | 104 |  | 6651 |  | 12399 | 1707 |  | -15
1999-09-01 00:00:00 | 2157 | 657 | 1488 | 2324 | 1826 | 1084 | 946 | 938 | 94 |  | 6792 |  | 12379 | 1819 |  | -56
1999-10-01 00:00:00 | 2065 | 656 | 1432 | 2342 | 1813 | 1148 | 978 | 917 | 97 |  | 6733 |  | 12385 | 1903 |  | -27
1999-11-01 00:00:00 | 2038 | 662 | 1379 | 2426 | 1780 | 1089 | 1052 | 1088 | 106 |  | 6872 |  | 12462 | 2006 |  | -219
1999-12-01 00:00:00 |  | 683 |  |  | 1763 |  |  |  |  |  | 7162 |  | 12345 | 2051 |  | -319
2000-01-01 00:00:00 |  |  |  |  | 1712 |  |  |  |  |  | 7136 |  | 12245 | 2037
2000-02-01 00:00:00 |  |  |  |  | 1780 |  |  |  |  |  | 6734 |  | 12275 | 2041
Spreadsheet: 714526d1611256028-how-to-get-monthly-headcount-sample-data_monthly-hc
Sheet: Desired Output

2020 | January | Total Active Headcount
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
Year | Month | Total Active Headcount
2021 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December