tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 91718d1291387723-charting-help-percentage-budget-used-vs-time-of-year-chart-example
Sheet: Chart I Want

 |  |  |  |  |  |  |  |  | Obligated Budget by Division and PAC
 |  | Percentage of budget Obligated |  | 100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Legend:
 |  |  |  | 90 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Budget
 |  |  |  | 80 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | EXPENSE
 |  |  |  | 70 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPEN_ENC
 |  |  |  | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OPEN_PRE
 |  |  |  | 50
 |  |  |  | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentage of year consumed
 |  |  |  | 30
 | - |  | - | 20 | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
 |  |  |  | 10
 |  |  |  | 0
 |  |  |  |  |  | 510-11009 |  |  |  | 510-11100 |  |  |  | 510-20000 |  |  |  | 510-87085 |  |  |  | 511-11002 |  |  |  | 513-11900 |  |  |  | 513-22100
Spreadsheet: 848688d1699361966-match-one-item-with-another-based-on-criteria-product-date-and-amount-outflows-association-with-inflows
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | OUTPUT
 | Product | Amount | Date |  |  |  | Product | Outflows | Relative Date | Residual amount
 | A | 10 | 2023-01-01 00:00:00 |  |  |  | A | -8
 | B | 10 | 2003-02-01 00:00:00 |  |  |  | A | -2
 | A | 5 | 2023-02-01 00:00:00 |  |  |  | A | -5
 | A | 2 | 2023-03-01 00:00:00
 | B | -5 | 2003-06-01 00:00:00
 | B | -5 | 2003-07-01 00:00:00
 | C | 10 | 2023-09-01 00:00:00
 | A | -8 | 2023-01-02 00:00:00
 | A | -2 | 2023-01-03 00:00:00
 | A | -5 | 2023-02-02 00:00:00
 | A | -5 | 2023-02-15 00:00:00
Spreadsheet: 749782d1633005606-create-4-week-average-sumif-office-365-formula-help-4-week-average
Sheet: DATA

 | Units WK1 | Units WK2 | Units WK3 | Units WK4 | Units WK5 | Units WK6 | Units WK7 | Units WK8 | Units WK9 | Units WK10 | Units WK11 | Units WK12 | Units WK13 | Units WK14 | Units WK15 | Units WK16 | Units WK17 | Units WK18 | Units WK19 | Units WK20
Item 1 | 1 | 1 | 2 | 0 | 1 | 1 | 1 | 2 | 0 | 1 | 1 | 1 | 2 | 0 | 1
Item 2 | 2 | 1 | 2 | 1 | 0 | 2 | 1 | 2 | 1 | 0 | 2 | 1 | 2 | 1 | 0
Item 3 | 3 | 1 | 2 | 0 | 2 | 3 | 1 | 2 | 0 | 2 | 3 | 1 | 2 | 0 | 2
Item 4 | 1 | 1 | 2 | 1 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 1 | 2 | 1 | 0
Item 5 | 2 | 1 | 2 | 0 | 1 | 2 | 1 | 2 | 0 | 1 | 2 | 1 | 2 | 0 | 1
Item 6 | 3 | 1 | 2 | 1 | 0 | 3 | 1 | 2 | 1 | 0 | 3 | 1 | 2 | 1 | 0
Item 7 | 1 | 1 | 2 | 0 | 2 | 1 | 1 | 2 | 0 | 2 | 1 | 1 | 2 | 0 | 2
Item 8 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1
Item 9 | 3 | 1 | 2 | 0 | 0 | 3 | 1 | 2 | 0 | 0 | 3 | 1 | 2 | 0 | 0
Item 10 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2
Item 11 | 2 | 1 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 0
Item 12 | 3 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 1 | 1 | 3 | 1 | 2 | 1 | 1
Item 13 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 2 | 0 | 0
Item 14 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 2 | 2 | 1 | 2 | 1 | 2
Item 15 | 3 | 1 | 2 | 0 | 1 | 3 | 1 | 2 | 0 | 1 | 3 | 1 | 2 | 0 | 1
Item 16 | 1 | 1 | 2 | 1 | 0 | 1 | 1 | 2 | 1 | 0 | 1 | 1 | 2 | 1 | 0
Item 17 | 2 | 1 | 2 | 0 | 2 | 2 | 1 | 2 | 0 | 2 | 2 | 1 | 2 | 0 | 2
Item 18 | 3 | 1 | 2 | 1 | 0 | 3 | 1 | 2 | 1 | 0 | 3 | 1 | 2 | 1 | 0
Item 19 | 1 | 1 | 2 | 0 | 1 | 1 | 1 | 2 | 0 | 1 | 1 | 1 | 2 | 0 | 1
Item 20 | 2 | 1 | 2 | 1 | 0 | 2 | 1 | 2 | 1 | 0 | 2 | 1 | 2 | 1 | 0
Item 21 | 3 | 1 | 2 | 0 | 2 | 3 | 1 | 2 | 0 | 2 | 3 | 1 | 2 | 0 | 2
Item 22 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2 | 1 | 1
Item 23 | 2 | 1 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 2 | 1 | 2 | 0 | 0
Item 24 | 3 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 1 | 2 | 3 | 1 | 2 | 1 | 2
Item 25 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 2 | 0 | 0 | 1 | 1 | 2 | 0 | 0
Spreadsheet: 456666d1460987356-reff-error-ref-error
Sheet: Sheet1

 | apple | lemon | berry | banana | orange
dog | 1 | 5 | 9 | 13 | 17
cat | 2 | 6 | 10 | 14 | 18
[NAME] | 20 | 7 | 11 | 15 | 19
horse | 4 | 8 | 12 | 16 | 20
Spreadsheet: 817125d1676012701-span-time-calculation-example-31-ans
Sheet: Sheet2

Start | Man-Hours Span | Target | Skip Days | Day Start | Day End | Hrs | FORMULA
2023-03-01 06:00:00 | 170 | 2023-03-13 06:00:00 | 2023-03-03 00:00:00 | 06:00:00 | 23:00:00 | 17
2023-03-01 06:00:00 | 165 |  | 2023-03-08 00:00:00
2023-03-01 06:30:00 | 172
2023-03-01 09:00:00 | 174
2023-03-01 12:00:00 | 183 | 2023-03-14 08:00:00
Spreadsheet: 115844d1311333339-excel-2007-find-cell-reference-and-copy-to-new-sheet-excel_1-1-
Sheet: Sheet2

NAME 1 | Select Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hide Q column
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: formula in column A&Q is array formula and should be confirmed throgh Ctrl+Shift+Enter
Spreadsheet: 688798d1595958773-issue-while-consolidating-multiple-excel-sheet-daily-work-control-and-time-sheet
Sheet: 02072020

 |  |  |  |  |  |  | DAILY WORK CONTROL & TIME SHEET
SN. | Sl no | NAME | DESIGNATION | Working Time |  | Time allocation
 |  |  |  |  |  | JO/20/179 |  | JO/20/144 |  | [NAME] |  | JO/20/120-B |  | JO/20/134 |  | JO/20/186 |  | JO/20/190 |  | JO/20/149 |  | [NAME] |  | [NAME] |  | ADMIN WORK |  | Maintainance / Other works
 |  |  |  | In | Out | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT | HRS | OT
1 | 1 | MATHEW | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 3 | 3.3
2 | 2 | KESHVAN | MACHINIST
3 | 3 | SIVADAS RAMANKUTTY | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 3.3
4 | 4 | SHAMIM  ANSARI | MACHINIST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
5 | 5 | RAGESH | WELDER |  |  | 8 | 6
6 | 6 | MUKUNDAKSHAN | WELDER |  |  |  |  | 8 | 3
7 | 7 | SATIYAR AJAM ABBASI | WELDER |  |  |  |  |  |  |  |  |  |  | 8 | 4
8 | 8 | UPENDRA KUMAR RAM | WELDER
9 | 9 | MARTIN | NDT
22 | 10 | SAMUEL | NDT |  |  |  |  |  | 2 | 4 |  |  |  |  |  |  |  | 4
10 | 11 | FELIX LUCAZINHO | SAND BLASTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
11 | 12 | DIPAK GOVINDA SALUNKE | SAND BLASTER |  |  |  | 5 | 4 |  |  |  | 4
12 | 13 | SATHYAPALAN | SAND BLASTER
13 | 14 | RAJEEV | FABRICATOR |  |  |  | 5 |  |  |  |  |  |  | 8 | 4
16 | 15 | [NAME] | FABRICATOR
17 | 16 | FLORENCIO | FABRICATOR |  |  |  |  | 8
14 | 17 | [NAME] | FITTER |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 |  | 1 | 2.3
 | 18 | SAMBHU | FITTER |  |  |  |  |  |  |  |  | 8
15 | 19 | RAJASEKAR | HELPER |  |  |  |  |  |  |  |  |  |  |  |  | 8
19 | 20 | FRANCIS JOSEPH | HELPER |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  |  | 2.5
24 | 21 | SONU  CHAUHAN  HARDEV | HELPER |  |  |  |  |  |  |  |  | 8
25 | 22 | SIMHACHALAM | HELPER
18 | 23 | [NAME] MALIK | VALVE TECHNICIAN |  |  |  |  | 3 |  | 4 |  |  |  |  |  | 1 |  |  | 2.5
20 | 24 | SIVA | TECHNICIAN |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 2.5
21 | 25 | SURENDRA NISHAD | PAINTER |  |  |  |  |  |  |  |  | 8
23 | 26 | RAVI | GRINDER |  |  |  |  |  |  | 8
 | 27 | HEMRAJ | GRINDER
26 | 28 | AJMER SINGH GURBAX SINGH | HEAVY [NAME]
27 | 29 | ABDUR RASHID | HEAVY [NAME] |  |  | 2 |  | 2 |  | 4
28 | 30 | BALJIT SINGH | HEAVY [NAME]
34 | 31
35
COMMENTS :
Prepared by: |  |  |  |  |  |  |  |  |  |  |  | Approved by:
Name: |  |  |  |  |  |  |  |  |  |  |  | Name:
Sign: |  |  |  |  |  |  |  |  |  |  |  | Sign:
Date: |  |  |  |  |  |  |  |  |  |  |  | Date:
Iss.No./Date: 02/01.06.2013
Rev.No/Rev.Date:02/23.06.2020
Spreadsheet: 73424658-7a7c-4bbd-a799-874c25f1ee5d
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259004 | 16450 | [NAME] | Herberger | GER |  | 00:26:51 | 00:02:00 | 00:36:41 | 00:01:27 | 00:15:17 | 1 | [NAME]
259004 | 25445 | [NAME] | [NAME] | GER |  | 00:26:49 | 00:01:34 | 00:38:13 | 00:01:57 | 00:16:00 | 2 | 01:24:33
259004 | 44567 | [NAME] | Young | GBR |  | 00:32:32 | 00:02:15 | 00:44:47 | 00:02:01 | 00:18:49 | 3 | 01:40:21
Spreadsheet: 851797d1701933499-need-help-with-adding-multiple-leaves-for-an-employee-employee-attendance-record-2023
Sheet: Employee Leave Tracker

 | Employee leave tracker
 | Employee name | Start date | End date | Type of leave | Days
 | [NAME] |  |  | Sick leave
 | ABDULNABI |  |  | Sick leave
 | ABINASH | 2023-10-24 00:00:00 | 2023-10-25 00:00:00 | Sick leave
 | ARJUN NEPALI
 | BISHOK
 | C.SENTHIL
 | FAROOQ
 | GOURAKHA BAHADUR RAI |  |  | Vacation
 | HARI NARAYAN
 | HARI NATH KANWAR
 | HARIS FAJRI
 | IMRAN [NAME]
 | JIWAN BHAIYA
 | MAHADEV PARIYAR |  |  | Other
 | MD KHUSHAL |  |  | Other
 | MOHAMAD SALMAN
 | MOHAMMAD FIROZ |  |  | Sick leave
 | MUHAMMED SINAN |  |  | Other
 | N.AYYAPPAN
 | N.SELVAM
 | NIYASUDEEN
 | [NAME]
 | PURNA DANGI |  |  | Vacation
 | RAHUL C.M
 | RAHUL P
 | RAM GURUNG
 | ROSHAN RAI |  |  | Sick leave
 | SAIDUL HAQUE
 | SAILALO |  |  | Vacation
 | THOUFEEQ BASHEER
 | VINOD KUMAR
 | YADAV GAJUREL
 | ABINASH | 2023-10-27 00:00:00 | 2023-10-27 00:00:00 | Bereavement
 | ABINASH | 2023-10-31 00:00:00 | 2023-10-31 00:00:00 | Other
Spreadsheet: 202164d1356372351-automatic-copy-cell-to-another-sheet-if-populated-rehospitalization-tracking-1-
Sheet: Summary

 |  | Meeting Attendance | Follow-up appointment was made/kept per standard | SBAR used per standard | Follow-up phone call made per standard | Audit Tool Used | Hospital Re-admission was deemed Avoidable | If avoidable, did non-compliance with standards contribute?
November 2012
December 2012
January 2013
February 2013
March 2013
April 2013
May 2013
June 2013
July 2013
August 2013
September 2013
October 2013
November 2013
December 2013
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -84738 | -85300 |  |  |  |  |  |  |  | San Juan
2 | -84260 | -85300 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -85534 | -85300 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 |  |  |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 |  |  |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 |  |  |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 |  |  |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 |  |  |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | -2220
2002-03-03 00:00:00
CBS Volume
 |  |  | 94419
Spreadsheet: 28e91f30-af78-46f0-ae4a-130d2b2a110e
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
FVAG | Test | FVAG | Fungal Culture, Vaginal | Fungal Culture, Vaginal | Plated to Inhibitory Mold Agar | Culture transport swab: CUTS |  |  |  |  | [NAME] should arrive within 24 hours of collection.   Container/Tube: Culture transport swab (non-charcoal) [NAME] Secretions Collection Instructions: 1. Before collecting specimen, wipe away any excessive amount of secretion and discharge. 2. Obtain secretions from the mucosal membrane of the vaginal vault with a sterile swab. 3. If smear and culture are requested or both a bacterial culture and fungal culture are requested, collect a second swab to maximize test sensitivity. Additional Information: Specimen source is required. Forms: If not ordering electronically, submit a Microbiology Request Form (Supply T244) with the specimen. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	Viral transport media (including but not limited to M4, M5, BD viral transport media, thioglycolate broth) or specimen >7 days from collection | Negative If positive, yeast will be identified. | Monday through Sunday; Varies | 7 days/Positive cultures reported when detected. Negative 7 days | 8 days | 1 | 87102 |  |  |  |  | Rochester
FVAG | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
FVAG | Order Question | Q00M0025 | [NAME] |  | Plain Text
FVAG | Result | FVAG | Fungal Culture, Vaginal | Fungal Culture, Vaginal | Alphanumeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 851473d1701705765-convert-time-to-number-and-subract-from-target-book1
Sheet: Sheet1

 |  |  |  | Target | 00:36:00
 |  |  |  | 39m 37s
 |  |  |  | 37m  2s
 |  |  |  | 41m 15s
 |  |  |  | 36m 15s
 |  |  |  | 40m 29s
 |  |  |  | 36m 33s
 |  |  |  | 36m 56s
 |  |  |  | 54m 33s
 |  |  |  | 45m 14s
 |  |  |  | 3h 44m 7s
 |  |  |  | 38m 46s
 |  |  |  | 37m 16s
 |  |  |  | 36m 17s
 |  |  |  | 37m 52s
 |  |  |  | 1h  0m 41s
 |  |  |  | 38m  7s
 |  |  |  | 48m 31s
 |  |  |  | 45m 48s
 |  |  |  | 41m 52s
 |  |  |  | 38m  1s
 |  |  |  | 37m 16s
 |  |  |  | 38m  1s
 |  |  |  | 37m 16s
 |  |  |  | 45m  6s
 |  |  |  | 38m 48s
 |  |  |  | 37m 36s
 |  |  |  | 37m 15s
 |  |  |  | 38m 28s
 |  |  |  | 42m 53s
 |  |  |  | 42m 35s
 |  |  |  | 41m 32s
 |  |  |  | 37m 38s
 |  |  |  | 36m 49s
 |  |  |  | 36m 28s
 |  |  |  | 43m  5s
 |  |  |  | 37m 30s
 |  |  |  | 37m  8s
 |  |  |  | 36m 55s
 |  |  |  | 36m  2s
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 31

कार्यक्रम PROGRAM |  |  | ऋण कौिल सिंर्धयन (क्षेका/अिंका के  ऋण प्रबिंधक) CREDIT UPSKILLING (CREDIT MANAGERS OF RO/CO) | PROG CODE
 |  |  |  | IT 1750
तर्षर् समूह/SUBJECT GROUP |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | KNOWLEDGE ENRICHMENT AND UPSKILLING OF TRAINEES
लतक्षि समूह/TARGET GROUP |  |  | SCALE II & III (CREDIT MANAGERS OF VLB/ELB, MCB AND LCB)
अर्तध/DURATION |  |  | 5 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Entry Test, Industry Focus, Preferred Sectors, Performance highlights of our bank
 | II | Sourcing the Credit proposals, Credit Initiation, Credit Investigation, CRILC,  CIBIL,  Probe  42,  CEIB  reports,  [NAME],  Analysis  of Credit Information Report/Search Report of CERSAI / ROC, MCA 21, Credit facilities to SC/ST Beneficiaries & Aspect of TAT
 | III | Regulatory Guidelines, Overview of Credit Risk Management Policy, Credit Risk Rating, Delegation of Powers - various committees
 | IV | Analysis on financial statements, Ratio Analysis
Day 2 | I | Case study on Financial Statement Analysis
 | II | Interpretation of Fund Flows and cash Flow Statement along with Case Studies
 | III & IV | Working capital assessment methods with the help of Case Study
Day 3 | I & II | Term [NAME] and Case study
 | III | Non Fund Based Limits-Concept, Assessment & Appraisal
 | IV | Preparation of Office Note-Practical Aspects with the help of Case Studies
Day 4 | I | Inspection observations on credit, Ways and means to avoid remarks and improve quality of lending,
 | II | Legal Aspects and Documentation, EMT and SMT, Gaps in Documentation & Digital Lending (Online Application and Digital Documentation)
 | III & IV | Credit Monitoring & Recovery, Rehabilitation and Restructuring Mechanism
Day 5 | I | Group Discussion on Asset and Liability Products of the Bank; Bancassurance and Cross Selling, Data Analysis through DNA
 | II | Implementation of OL at Workplace; Prevention of Sexual Harassment at Workplace, Compliance Culture
 | III | Business Ethics and Value Systems Motivation & Effective Communication Skills
 | IV | Exit test, Valediction & Feedback
Spreadsheet: geir_solberg__11255__EPE_MAY_2001
Sheet: MAY(27)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
2001-05-27 00:00:00
HR ENDING | HR ENDING | Palo Verde | Palo Verde | Palo Verde | Palo Verde | Palo Verde | Palo Verde | 4 CORNERS | EDDY
Pacific | Mountain | SALE | SALE | SALE | SALE | SALE | BUY | SALE | BUY
Daylight | Standard | TO PSCO | TO EPMI | TO PSCO | TO EPMI | TO EPMI | FROM PSCO | TO ENRON | From ENRON
Time | Time | 61.75 | 110 | 61.75 | 110
 |  |  |  |  |  | THESE TWO DEALS BOOKOUT TOGETHER FOR THE MONTH |  | FOR THE MONTH! | FOR THE YEAR!
 |  | 4/1/01-4/30/01 | 5/14/01-5/31/01 | 4/1/01-4/30/01 | 5/14/01-5/31/01 | 5/1/01-5/31/01 | 5/1/01-5/31/01 | 5/1/01-5/31/01 | 5/1/01-5/31/01
 |  | WESCO TAG31314 | EPMI TAG#23231 | EPMI TAG#23234 | EPMI TAG#23217 | BOOKOUT | BOOKOUT | PSCO TAG#1014576 | SPS TAG # | TOTAL
PDT | MST | DIRECT BILL | DEAL#607955 | DIRECT BILL | DEAL#607955 | DIRECT BILL | DIRECT BILL | DIRECT BILL | DIRECT BILL
0100 | 0100 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0200 | 0200 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0300 | 0300 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0400 | 0400 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0500 | 0500 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0600 | 0600 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0700 | 0700 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0800 | 0800 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
0900 | 0900 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1000 | 1000 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1100 | 1100 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1200 | 1200 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1300 | 1300 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1400 | 1400 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1500 | 1500 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1600 | 1600 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1700 | 1700 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1800 | 1800 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
1900 | 1900 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
2000 | 2000 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
2100 | 2100 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
2200 | 2200 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
2300 | 2300 | 40 | 5 | 3 | 25 | 60 | -60 | 60 | -103
2400 | 2400 | 40 | 5 | 3 | 25 | 60 | -60 | 60
 | MST Total
 | PDT TOTAL
 |  | EPE(G)PV | EPE(G)PV | EPE(G)PV | EPE | EPE | PSCO | EPE@4C345 | SPS (G) @ EDDY TIE
 |  | EPMI | PSCO | PSCO | EPMI | EPMI | EPMI | EPE(T)4C345/4C345 | EPMI
 |  | PSCO | EPMI | EPMI | APS(T)PV/WW5 O#21253 | PSCO | EPE | PSCO | EPE (L) @ EDDY TIE
 |  | WESCO | GLENDALE | GLENDALE | WALC(T)WWD/PPK O#26034 |  |  | NEVP
 |  | ISO(T)PV/SP15 | GLENDALE(T)PVD/SYL | GLENDALE(T)PVD/SYL | WALC(T) PPK/MD2 O#26034 |  |  | TEP
 |  | WESCO(L)SP15 | GLENDALE(T)SYLMAR/AIRWAY | GLENDALE(T)SYLMAR/AIRWAY | EPMI |  |  | TEP(T)4C345/4C345
 |  |  | [NAME] | [NAME] | NEVP |  |  | TEP@4C
Spreadsheet: 749233d1632622331-sales-equation-canada-event-planner-template
Sheet: STORE LIST

309 | Edmonton
351 | Toronto Premium Outlet
352 | Vancouver
353 | Niagara On The Lake
354 | Cookstown
355 | Ottawa
356 | Montreal
361 | Calgary
362 | Winnipeg
364 | Vaughan Mills FOC
366 | [NAME]
365 | Tsawwassen Mills
Spreadsheet: 870536d1717045086-list-up-the-sheet1-to-sheet2-depend-on-condition-list-pump-use-2-3-
Sheet: WORKER 3

 | payee : | worker 3
no | location | customer | Status | quantity
1 | JOHOR | GAN | CONTINUE USE
2 | JOHOR | CHEW | CONTINUE USE
3 | MELAKA | [NAME] | CONTINUE USE | 7
5 | MELAKA | [NAME] | CONTINUE USE | 5
6 | MELAKA | TAI | DIRECT SELL
7 | MELAKA | YAU | CONTINUE USE | 3
Spreadsheet: 647870d1572693972-column-search-with-various-formats-of-names-office-problem
Sheet: Example Sheet

Target to search ( each of the cell below) - Date format DD/MM/YY | Search against this Coloumn | Record 1D | Date
Tanya, Surname_25/12/18 | Names 1
[NAME] | Names 2 Surname
Surname kenny_10/08/12 | Surname Name 3
Surname, Thomas_12/06/19 | Name_Surname4
[NAME] ven desol_12/04/18 | Tanya, Surname_25/12/18
[NAME] | [NAME] Jones|_10/11/13 | Surname Name 4
Vince_Surname_15/06/16 | Surname Name 5
[NAME] | Surname Name 6
 | Surname Name 6
Objective is to search each cell of the column A, which has the record with date after 5th March 12 and match with each of the cell of Column B and Print matched with row number of [NAME] shown in [NAME] | [NAME]
 | [NAME] ven desol_12/04/18
 | Surname kenny_10/08/12
 | [NAME]
 | [NAME] ven desol_12/04/18
 | [NAME] | [NAME] Jones|_10/11/13
 | Vince_Surname
Spreadsheet: 138491d1327681524-populate-table-from-other-sheets-based-on-drop-down-selection-fast-card-2012
Sheet: Summary

FAST Solutions 2012 Build Center Scorecard
 |  |  |  |  |  |  |  |  |  | January 2012
Element | Total Machines Installed | Machines Not Installed > 60 Days | Profitability Per Machine Installed | [NAME]. Days Out on Installed Machines | Total Machines Signed, Not Installed | Product Templates Not Completed | Over All
Scorecard Value | 0.25 | 0.25 | 0.25 | 0.05 | 0.05 | 0.15 |  | D | November 2011 |  | 1
AHUB |  |  |  |  |  |  |  |  | December 2011 |  | 2
DHUB |  |  |  |  |  |  |  |  | January 2012 |  | 3
HHUB |  |  |  |  |  |  |  |  | February 2012 |  | 4
IHUB |  |  |  |  |  |  |  |  | March 2012 |  | 5
[NAME] |  |  |  |  |  |  |  |  | April 2012 |  | 6
MHUB |  |  |  |  |  |  |  |  | May 2012 |  | 7
NHUB |  |  |  |  |  |  |  |  | June 2012 |  | 8
OHUB |  |  |  |  |  |  |  |  | July 2012 |  | 9
SHUB |  |  |  |  |  |  |  |  | August 2012 |  | 10
UHUB |  |  |  |  |  |  |  |  | September 2012 |  | 11
VHUB |  |  |  |  |  |  |  |  | October 2012 |  | 12
WINO
Totals/Avgs
2011 Year-To-Date Rankings
AHUB |  |  |  |  |  |  |  |  | B | nov
DHUB |  |  |  |  |  |  |  |  | C | dec
HHUB |  |  |  |  |  |  |  |  | D | jan
IHUB |  |  |  |  |  |  |  |  | E | feb
[NAME] |  |  |  |  |  |  |  |  | F | [NAME]
MHUB |  |  |  |  |  |  |  |  | G | apr
NHUB |  |  |  |  |  |  |  |  | H | may
OHUB |  |  |  |  |  |  |  |  | I | jun
SHUB |  |  |  |  |  |  |  |  | J | jul
UHUB |  |  |  |  |  |  |  |  | K | aug
VHUB |  |  |  |  |  |  |  |  | L | sep
WINO |  |  |  |  |  |  |  |  | M | oct
Totals/Avgs
 | Packing List | Store Audit Completion | No Stock | Cost Per Mile | Cost Per Request | Cost Per Request Improvement
Spreadsheet: 799726d1665237360-nested-vlookup-help-108
Sheet: Sheet1

Collection | ProductClass | StockCode | AlternateKey1 | Description | LongDesc | Warehouse | QtyAvailable | QtyOnHand | QtyAllocated | Future Inbound | Stocked
A | MKT | SW929 | FF 48080-0000 | A Spectrum Indigo Fabric Swatc |  | IR | 0 | 0 | 0 | 0 | 0
A | MKT | SW929 | FF 48080-0000 | A Spectrum Indigo Fabric Swatc |  | RR | 0 | 0 | 0 | 0 | 0
Spectrum | RM | F929 | FF 48080-0000 | Spectrum Indigo | Grade A | RR | 431.319 | 431.319 | 0 | 1500 | 1931.319
Spectrum | RM | F9929 | FF 48080-0000 V77 | Spectrum Indigo/V77 | [NAME] | RR | 21.983 | 21.983 | 0 | 65.25 | 87.233
Spreadsheet: joe_parks__14622__POSTIONTRAX_NOV
Sheet: DEC_SWAP

 | SELL |  |  |  | BUY
BEGINNING | 103.25 | 2.852 |  |  |  |  |  |  |  |  | MTM
 | 31 | 2.82 |  |  | 62 | 2.815 |  |  |  |  | ROLLOFF VAULE
 |  |  |  |  | 62 | 2.81 |  |  |  |  | NEW DEALS
 | 15.5 | 2.79
 | 7.25 | 2.8 |  |  |  |  |  |  |  |  | TOTAL  P&L
 |  |  |  |  |  |  |  |  |  |  | POSTION
 |  |  |  |  |  |  |  |  |  |  | ROLL OFF
 |  |  |  |  |  |  |  |  |  |  | NET POSTION
 |  |  |  |  |  |  |  |  |  |  |  | 31
 |  |  |  |  |  |  |  |  |  |  |  | 2500
 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 7500
 |  |  |  |  |  |  |  |  |  |  |  | 10000
 |  |  |  |  |  |  |  |  |  |  |  | 12500
 |  |  |  |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  |  |  |  | 17500
 |  |  |  |  |  |  |  |  |  |  |  | 20000
 |  |  |  |  |  |  |  |  |  |  |  | 25000
 |  |  | <- Current MTM
 |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  | <- MTM PL w/o Real PL
 |  |  |  |  |  |  | <- MTM PL with Real PL
 |  |  |  |  |  |  | <- Total Pl