tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 138574d1327738910-excel-2007-how-to-create-a-repeat-set-of-sequence-number-index-where-values-appear-in-a-row-excelforum_example-repeatindex
Sheet: Existing

1
1 |  |  |  |  |  | first name | last name | Title 3 | Title 4 | Title 5 | Title 6 | Title 7 | Title 8 | Title 9 | Title 10 | Title 11 | Title 12 | Title 13 | Title 14 | Title 15
1
1 |  |  |  |  |  | [NAME] | rock | ghi | jkl | mno | pqr | stuv | wxy | z | 123 | 456 | 789 | 12 | 345 | 678
1 | Title 16 | 1234 | Title 22 | a | Title 29 | h
1 | Title 17 | 5678 | Title 23 | b | Title 30 | i
1 | Title 18 | 9012 | Title 24 | c | Title 31 | j
1 | Title 19 | 3456 | Title 25 | d | Title 32 | k
1 | Title 20 | 7890 | Title 26 | e | Title 33 | l
1 | Title 21 | abc | Title 27 | f | Title 34 | m
1 |  |  | Title 28 | g | Title 35 | n
1 |  |  |  |  | Title 36 | o
1 |  |  |  |  | Title 37 | p
1 |  |  |  |  | Title 38 | q
2 |  |  |  |  |  | silver | tamiah | ghi | jkl | mno | pqr | stuv | wxy | z | 123 | 456 | 789 | 12 | 345 | 678
2 | Title 16 | 1234 | Title 22 | a | Title 29 | h
2 | Title 17 | 5678 | Title 23 | b | Title 30 | i
2 | Title 18 | 9012 | Title 24 | c | Title 31 | j
2 | Title 19 | 3456 | Title 25 | d | Title 32 | k
2 | Title 20 | 7890 | Title 26 | e | Title 33 | l
2 | Title 21 | abc | Title 27 | f | Title 34 | m
2 |  |  | Title 28 | g | Title 35 | n
2 |  |  |  |  | Title 36 | o
2 |  |  |  |  | Title 37 | p
3 |  |  |  |  |  | [NAME] | ryan | ghi | jkl | mno | pqr | stuv | wxy | z | 123 | 456 | 789 | 12 | 345 | 678
3 | Title 16 | 1234 | Title 22 | a | Title 29 | h
3 | Title 17 | 5678 | Title 23 | b | Title 30 | i
3 | Title 18 | 9012 | Title 24 | c | Title 31 | j
3 | Title 19 | 3456 | Title 25 | d | Title 32 | k
3 | Title 20 | 7890 | Title 26 | e | Title 33 | l
3 | Title 21 | abc | Title 27 | f | Title 34 | m
3 |  |  | Title 28 | g | Title 35 | n
3 |  |  |  |  | Title 36 | o
3 |  |  |  |  | Title 37 | p
3 |  |  |  |  | Title 38 | q
4 |  |  |  |  |  | abc | def | ghi | jkl | mno | pqr | stuv | wxy | z | 123 | 456 | 789 | 12 | 345 | 678
4 | Title 16 | 1234 | Title 22 | a | Title 29 | h
4 | Title 17 | 5678 | Title 23 | b | Title 30 | i
4 | Title 18 | 9012 | Title 24 | c | Title 31 | j
4 | Title 19 | 3456 | Title 25 | d | Title 32 | k
4 | Title 20 | 7890 | Title 26 | e | Title 33 | l
4 | Title 21 | abc | Title 27 | f | Title 34 | m
4 |  |  | Title 28 | g | Title 35 | n
4 |  |  |  |  | Title 36 | o
4 |  |  |  |  | Title 37 | p
4 |  |  |  |  | Title 38 | q
5 |  |  |  |  |  | abc | def | ghi | jkl | mno | pqr | stuv | wxy | z | 123 | 456 | 789 | 12 | 345 | 678
5 | Title 16 | 1234 | Title 22 | a | Title 29 | h
5 | Title 17 | 5678 | Title 23 | b | Title 30 | i
5 | Title 18 | 9012 | Title 24 | c | Title 31 | j
5 | Title 19 | 3456 | Title 25 | d | Title 32 | k
5 | Title 20 | 7890 | Title 26 | e | Title 33 | l
5 | Title 21 | abc | Title 27 | f | Title 34 | m
5 |  |  | Title 28 | g | Title 35 | n
5 |  |  |  |  | Title 36 | o
5 |  |  |  |  | Title 37 | p
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: ARKANSAS-3

 | COUNTY | CODE
 | Arkansas | 1
 | [NAME] | 3
 | Baxter | 5
 | [NAME] | 7
 | Boone | 9
 | Bradley | 11
 | [NAME] | 13
 | Carroll | 15
 | Chicot | 17
 | [NAME] | 19
 | Clay | 21
 | Cleburne | 23
 | Cleveland | 25
 | Columbia | 27
 | Conway | 29
 | Craighead | 31
 | Crawford | 33
 | [NAME] | 35
 | Cross | 37
 | Dallas | 39
 | Desha | 41
 | [NAME] | 43
 | Faulkner | 45
 | Franklin | 47
 | Fulton | 49
 | Garland | 51
 | Grant | 53
 | Greene | 55
 | Hempstead | 57
 | Hot Spring | 59
 | [NAME] | 61
 | Independence | 63
 | Izard | 65
 | [NAME] | 67
 | [NAME] | 69
 | [NAME] | 71
 | Lafayette | 73
 | [NAME] | 75
 | [NAME] | 77
 | Lincoln | 79
 | Little River | 81
 | Logan | 83
 | Lonoke | 85
 | [NAME] | 87
 | Marion | 89
 | [NAME] | 91
 | Mississippi | 93
 | Monroe | 95
 | Montgomery | 97
 | Nevada | 99
 | Newton | 101
 | Ouachita | 103
 | [NAME] | 105
 | Phillips | 107
 | Pike | 109
 | [NAME] | 111
 | Polk | 113
 | Pope | 115
 | Prairie | 117
 | Pulaski | 119
 | Randolph | 121
 | St. Francis | 123
 | Saline | 125
 | Scott | 127
 | Searcy | 129
 | [NAME] | 131
 | Sevier | 133
 | Sharp | 135
 | Stone | 137
 | Union | 139
 | [NAME] | 141
 | Washington | 143
 | White | 145
 | Woodruff | 147
 | Yell | 149
Spreadsheet: 745680d1630103554-pulling-data-validation-dropdown-options-from-another-sheet-not-dependent-dropdown-data-validation-help-v5-082521
Sheet: Data Worksheet

Cars | Shoes | Movies | Movie Studios | Fruits | Minerals | Animals
Ford | Nike | [NAME] | Disney | Grape | Gold | Dog
Kia | [NAME] | Frozen | Universal | [NAME] | Silver | Cat
Chevy | Dockers | Avengers | Marvel | Orange | Platinum
Audi |  | LOTR |  |  | [NAME] | Horse
 |  |  |  |  |  | Hippo
Key: | Found on the "Valid Values by Field" tab |  |  |  |  |  |  |  | Fruits | Cars | Shoes | Movie Studios | Movies | Minerals
 | Not Found on the "Valid Values by Field" tab
 | Blank Cell
Data Validation Formula Starting on [NAME] (in Cell I2 currently): | =INDEX('Valid Values by Field'!$A$2:$BC$100000,MATCH(A2,INDEX('Valid Values by Field'!$A$2:$BC$100000,,MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0)),0),MATCH(A$1,'Valid Values by Field'!$A$1:$BC$1,0))
Background: | This tool matches-up the column names (in any order, regardless if the same column appears on the "Valid Values by Field" sheet.
 | If the same column appears on both sheets, the data is validated (green indicates the data is under the same column heading on the Valid Values sheet).
Goal: | Add data validation to each cell, to allow the user to choose one of the Valid options from a dropdown.
 | Example: under Cars, Audi is not on the Valid Values list for Cars, so I need a dropdown to allow the user to select Ford, Kia, or Chevy.
 | (I'd like to avoid named ranges, if possible)
 | I've already added placeholder data validations to each cell; I just need the magic formula!
 | I've spent hours trying to get this to work, but no luck. I have included the Conditioonal Formatting formula I used in cell C19 for reference. I have a feeling the solution is a variation on the Conditional Formatting formula. I've tried CHOOSE(), but I could not get that to work, either....
Spreadsheet: 100463d1298833498-add-letters-to-numbers-in-column-b-copy-of-book1_sem-1-
Sheet: SHEET2

01 02 17 18 25 | A |  | A | 1 | 2 | 17 | 18 | 25 | 3 | 15 | 16 | 19 | 4 | 13 | 14 | 20 | 5 | 11 | 12 | 21 | 6 | 9 | 10 | 22 | 7 | 8 | 23 | 24
01 03 15 16 19 | A |  | B | 2 | 3 | 12 | 14 | 22 | 4 | 5 | 15 | 23 | 6 | 7 | 13 | 19 | 8 | 9 | 16 | 21 | 10 | 11 | 20 | 24
01 04 13 14 20 | A |  | C | 3 | 4 | 8 | 10 | 18 | 5 | 6 | 17 | 24 | 7 | 20 | 21 | 25 | 9 | 11 | 13 | 23
01 05 11 12 21 | A |  | D | 4 | 6 | 11 | 16 | 25 | 7 | 9 | 12 | 17 | 19 | 21 | 22 | 24
01 06 09 10 22 | A |  | E | 5 | 7 | 10 | 14 | 16 | 8 | 13 | 22 | 25 | 9 | 18 | 19 | 20
01 07 08 23 24 | A |  | F | 6 | 8 | 12 | 15 | 20 | 14 | 18 | 21 | 23
02 03 12 14 22 | B
02 04 05 15 23 | B
02 06 07 13 19 | B
02 08 09 16 21 | B
02 10 11 20 24 | B
03 04 08 10 18 | C
03 05 06 17 24 | C
03 07 20 21 25 | C
03 09 11 13 23 | C
04 06 11 16 25 | D
04 07 09 12 17 | D
04 19 21 22 24 | D
05 07 10 14 16 | E
05 08 13 22 25 | E
05 09 18 19 20 | E
06 08 12 15 20 | F
06 14 18 21 23 | F
07 11 15 18 22 | G
08 11 14 17 19 | H
09 14 15 24 25 | I
10 12 19 23 25 | G
10 13 15 17 21 | J
12 13 16 18 24 | H
16 17 20 22 23 | I
Spreadsheet: 404fe6d4-fdfe-49bf-bc2a-c12483e81f07
Sheet: Sheet1

Figure 1C | Unnamed: 1 | Unnamed: 2
Time on blue food | unmanipulated vs E.faecalis | media vs E. faecalis
10 min | p = 0.0347 | p = 0.6696
15 min | p < 0.0001 | p = 0.0002
20 min | p = 0.0027 | p = 0.0001
25 min | p = 0.3207 | p = 0.0336
30 min | p = 0.2370 | p = 0.3922
35 min | p = 1.0 | p = 0.8433
Spreadsheet: 844712d1696421257-how-to-find-the-right-exponential-function-book1
Sheet: Sheet1

Profit first month | 36158.04146794774
Profit Last year | 10000000
Grow pro month | 0.06
Month | Profit
2
3
4
5
6
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
Spreadsheet: 593216d1539040602-combine-append-two-excel-tables-into-one-apended-list
Sheet: Combine

 |  | COMBINED LISTS / INDEX & MATCH (I7) / SPINNER (K5) / NESTED IF (I5)
 |  | COMBINED DATA |  |  |  |  | ITEM |  |  | 1
 |  | Item | Quantity | Cost | Total |  | Total
 |  | Hat | 5 | 10 | 50
 |  | Shirt | 2 | 50 | 100
 |  | Trousers | 2 | 10 | 20
 |  | Shoes | 5 | 100 | 500
 |  | Scarf | 5 | 19 | 95
 |  | Jacket | 2 | 150 | 300
 |  | Tie | 2 | 20 | 40
 |  | Gloves | 10 | 2 | 20
Spreadsheet: 676023d1588610476-countif-between-hrs-and-day-us-details-copy
Sheet: Analysis

DAY | SERVICE HRS. |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 | 09:00 - 10:00 | 10:00 - 11:00 | 11:00 - 12:00 | 12:00 - 13:00 | 13:00 - 14:00 | 14:00 - 15:00 | 15:00 - 16:00 | 16:00 - 17:00 | 17:00 - 18:00 | 18:00 - 19:00 | 19:00 - 20:00 | 20:00 - 21:00 | 21:00 - 22:00
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
TOTAL
FROM: | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00
TO: | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00
Spreadsheet: 849529d1699973485-combine-3-sheets-data-into-1-final-sheet-book1-2-1-2-
Sheet: Win Report DBLS

Name | Score | Category
 |  |  |  |  | Column C is irrelevant
 |  |  |  |  | for HOA
Spreadsheet: mary_hain__25844__4th qtr 2000 GENCO FERC
Sheet: Brownsville Operations

SCC-L1, L.L.C. (Brownsville)
FERC Filing
Fourth Quarter 2000
Generation Sales:
Organization Name | Transaction Type | Firm/Interruptable | Volume (MW) | Min Price | [NAME] | Point Name
Enron Power Marketing Inc. | S | F | -3596 | 51 | 62 | ENSE-Brownsville-ENSE
Total Generation Sales
Spreadsheet: 127632d1320434352-convert-norwegian-currency-formatting-to-us-uk-no-template-copy-excel-help
Sheet: ABC Customer

Kunde
Kampanje:
Periode:
Kontakperson kunde:
[NAME] reklamebyrå:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | jan |  |  |  | feb |  |  |  | mars |  |  |  |  | april |  |  |  | mai |  |  |  | juni |  |  |  |  | [NAME] |  |  |  | aug |  |  |  |  | sept |  |  |  | okt |  |  |  | nov |  |  |  |  | des
Mediehus | Nettsted | Plassering | Type kjøp | Key Account | Traffic | Format | KB | [NAME] | Prov | Prov | Ant | Est visninger | Brutto | [NAME] | [NAME] (kr) | Netto | 1 | 2 | 3 | 4 | 5 | 6 | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
SUM
Spreadsheet: tracy_geaccone__40285__EMNNG01CE
Sheet: IntDeduct

PRINT: PRINT
 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
DIRECT INTEREST EXPENSE
Carrying Charges - Reverse Auction 1 | Linked
- Reverse Auction 2 | Linked
- Reverse Auction 3 | Linked
- GSR R.A. | Linked
- Stranded 858 | Linked
- Rate Case | Linked
Carlton Resolution | Linked
Discount Issue |  | 1 | 2 | 3 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1
AFUDC - Debt (SAP Change 7/00 Forward) | Link D.T. | -1 | -3 | -2 | -4 | -11 | -48 | -20 | -8 | -9 | -10 | -4 | -6
[NAME] (ASCC) Fees |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Other (2&3/01-KS Ad Valorem Issue) |  | 1 | -23 |  | 2 | 1 | 1 | -1 |  |  | 0 | 0 | 0
Misc. Item 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL DIRECT INTEREST
INTERCOMPANY INTEREST EXPENSE / (INCOME)
Intercompany Interest Expense / (Income) |  |  |  | -4363 | -1463 | -1288 | -1198 | -1195 | -1334 | -1271 | -1288 | -1190 | -1196
Long Term Debt (Pre 1/1/98) - Interest Expense |  |  |  |  | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031 | 2031
- Debt Expense Amortization |  | 27 | 29 | 26 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27 | 27
Long Term Debt (Post 1/1/98) - Interest Expense |  | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843 | 844 | 844 | 844 | 843
- Debt Expense Amortization |  | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 11 | 10 | 11 | 11
- Interest Expense Differential |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL INTERCOMPANY INTEREST EXPENSE/(INCOME)
AFUDC
AFUDC - Equity (6/01 Prior Yr. Adj. $133K) |  | -3 | -13 | -8 | -13 | -41 | -175 | -75 | -30 | -33 | -34 | -14 | -23
Other |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL AFUDC
OTHER DEDUCTIONS
Reacquired Debt - Amortized Loss | Link D.T.
- Amortized (Gain) | Link D.T.
Donations
Reserve Issues - Cooper (Parts Sale) Deferred Gain | Link D.T.
- Miscellaneous 1 | Link D.T.
- Miscellaneous 2 | Link D.T.
Other Deductions (Misc. Item 1)
Litigation Settlements - Misc. Item 1    "Commercial Function"
- Misc. Item 2                                "Commercial Function"
- Misc. Item 3                                "Commercial Function"
Other                                                 "Commercial Function"
Hyperion Entry / Reversal |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
TOTAL OTHER DEDUCTIONS
TOTAL INTEREST & OTHER DEDUCTIONS
Spreadsheet: 270202d1381413620-what-lookup-function-should-i-use-tracker-9999-rows
Sheet: 6080

 | Reference | 6080
 | Title | Example 2
 | Notes
 | Funding received
 | Name | Amount Received | Date Received
 | Total amount received
Spreadsheet: 771722d1646815669-if-statement-to-collect-data-per-day-without-overriding-if
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Raised | Item | open | cost
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-12 00:00:00 | 1 | y | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-01 00:00:00 | 2 | n | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-02 00:00:00 | 3 | y | 18
 |  | open | Cost |  |  |  |  |  |  |  |  |  |  |  | 2022-02-02 00:00:00 | 4 | n | 27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-01-18 00:00:00 | 5 | y | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-05 00:00:00 | 6 | n | 62
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2022-03-09 00:00:00 | 7 | y | 18
Spreadsheet: 672061d1586707059-calculating-percentage-work-completed-based-on-timestamp-project-percentage
Sheet: Reference

State | Percentage
[NAME] | 0
Assigned | 0
Work in progress | 0.1
Pending Approval | 0.8
Finalize & Save Invoice | 0.05
Pre-Work | 0.15
Closed [NAME] | 0.2
Cancelled | 0
[NAME] | 0.15
PW Work In Progress | 0.25
PW SAP Issue | 0.15
PW Waiting for Pre- Approval (Client or Manager) | 0.45
PW Pending Approval | 0.8
PW Waiting for Line of Business | 0.15
PW Missing information | 0.15
[NAME] Global/SAP Issue | 0.15
PW WFC will follow-up with biller | 0.15
PW Follow up with Requestor | 0.15
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Nov'10

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2010-11-30 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 |  |  |  |  |  |  | 0 | 0
 |  | Stock 2 |  |  |  |  |  |  | 0 | 0
 |  | Stock 3 |  |  |  |  |  |  | 0 | 0
 |  | Stock 4 |  |  |  |  |  |  | 0 | 0
 |  | Stock 5 |  |  |  |  |  |  | 0 | 0
 |  | Stock 6 |  |  |  |  |  |  | 0 | 0
 |  | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 89423d1289229332-lookup-from-fixed-rows-and-dynamic-columns-sample
Sheet: 1

USER NAME | ID | CALLS | TIMECLOCK | AGENTTIME | WAIT | TALK | [NAME] | PAUSE | LOGIN | Comf | Coach | CALLB
Agent1 | 4024 | 293 | 00:00:00 | 08:00:00 | 04:00:00 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent2 | 4121 | 185 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent3 | 4094 | 325 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent4 | 4159 | 247 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent5 | 4148 | 299 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent6 | 4104 | 302 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent7 | 4139 | 291 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent8 | 4157 | 207 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent9 | 4125 | 243 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent10 | 4107 | 253 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent11 | 4141 | 232 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent12 | 4097 | 208 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent13 | 4068 | 160 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent14 | 4017 | 138 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent15 | 4164 | 168 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent16 | 4103 | 307 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent17 | 4146 | 281 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent18 | 4156 | 200 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent19 | 4078 | 353 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Agent20 | 4061 | 272 | 00:00:00 | 08:01:51 | 04:26:03 | 02:00:00 | 00:20:00 | 00:50:00 | 00:00:20 | 00:20:00 | 00:00:00 | 00:00:53
Spreadsheet: 797424d1663868932-error-in-vlookup-function-why-vlookup
Sheet: Sheet1

 |  |  |  | 1 | one
 |  |  |  | 2 | two
 |  |  |  | 3 | three
 |  |  |  | 4 | four
 |  |  |  | 5 | five
 |  |  |  | 2
 |  |  |  | 3
 |  |  |  | 4
 |  |  |  | 1
 |  |  |  | 5
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Dec16-Dec22p

Pavilion
 | 2012-12-16 00:00:00 |  |  | Thru | 2012-12-22 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2012-12-16 00:00:00 | 2012-12-17 00:00:00 | 2012-12-18 00:00:00 | 2012-12-19 00:00:00 | 2012-12-20 00:00:00 | 2012-12-21 00:00:00 | 2012-12-22 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: andy_zipper__170__DYNEGY-ICE VOL Apr16
Sheet: DD-EGL

Dynegy Direct
Enron Global Liquids
UOM | Deals | Volume
Natural Gas Liquids
Enron Trader | Period (Mo) | Total Volume | Activity Type | Customer | Major Commodity | User Name | Dynegy User Name | Minor Commodity | Priority Of Service | Deal Type | Location | Pricing Mechanism | Settlement Type | Term | Term Start Date | Term End Date | Delivery Time | Transportation Description | Transaction Date | Transaction Time | Buy/Sell | Volume | Price | Deal Number
Spreadsheet: 890053d1741192267-return-same-value-based-on-2-different-searches-master-project-list-test
Sheet: Search

 | Search your job name below
Searcy by Job Name: | [NAME] | q | Job Number: |  | Status:
Delete job name above to search for job number instead
Search by Job Number: | 7102128 | q | Job Name: |  | Status:
Address:
01 - PROJECT EXECUTIVE
02 - SR. PROJECT MANAGER
03 - PROJECT MANAGER
04 - ASST. PROJECT MANAGER
05 - MECH SUPERINTENDENT
06 - ELECTRICAL SUPERINTENDENT
07 - SR PROJECT ENGINEER
08 - PROJECT ENGINEER
11 - SR. PROJECT ACCT
12 - PROJECT ACCT
13 - ASST PROJECT ACCT
14 - FPA TEAM LEAD
15 - PROJECT ADMIN
Spreadsheet: 671824d1586551586-index-indirect-match-sample
Sheet: Sheet2

Pair | Column 1 | Column 2 | PTP Edit Rationale | CCMI
 | 70010 | 36406 | Standards of medical practice | 1
 | 70010 | 76001 | Standards of medical practice | 1
 | 70010 | 96374 | Standards of medical practice | 1
 | 70010 | 36410 | Standards of medical practice | 1
 | 70010 | 76000 | Standards of medical practice | 1
 | 70010 | 96377 | Standards of medical practice | 1
 | 70010 | 96375 | Standards of medical practice | 1
Spreadsheet: 59579d1260190082-performance-indicator-quality-scoring-example
Sheet: User

Efficiency % (target 100%) | Audit Quality % (Target 98%) | BAU Quality%  (Target 98%) | Number of Service Failures | Training Audits % Quality  (Target 98%) | Benchmart Met (Failures Counted) | Compliments Received | Awards Received | Instances of Lateness | Core Standards Met | Financial Losses | Data Breaches | Suggestions Made | Compliance Failures | PERFORMANCE INDICATOR
102 | 67 | 98 | 1 | 58 | 3 | 10 | 3 | 2 | 3 | 100 | 3 | 2 | 1
Spreadsheet: 456205d1460678933-help-adapting-an-index-formula-customer-db-and-invoices
Sheet: Invoice

Address: | BLANK | [NAME]: | BLANK
Postcode: | BLANK
Invoice # | 1
Customer Name |  | Phone:
Company |  | Mobile:
Address: |  | [NAME]:
Postcode:
Date | Description | Quantity | Unit Price | Total
 |  | Total
Spreadsheet: 552655d1513700433-how-do-i-set-up-an-automatic-value-entry-calculation-update-system-expenses
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Date | ([NAME])
 |  |  |  |  |  |  |  | Categories
 |  |  |  |  |  |  |  | Clothing |  |  |  |  | summary | Soma de Value
 |  |  |  |  |  |  |  | Electricity |  |  |  |  | Clothing | 180.45
 |  |  |  |  |  |  |  | Gas |  |  |  |  | Electricity | 98.72
 |  |  |  |  |  |  |  | Groceries |  |  |  |  | Groceries | 28.27
 |  |  |  |  |  |  |  | Wather |  |  |  |  | Wather | 20.58
Expenses |  |  |  |  |  |  |  | Upkeep |  |  |  |  | Gas
Date | Category | Value |  |  |  |  |  | Other |  |  |  |  | Total Geral | 328.0199999999999
2017-11-17 00:00:00 | Groceries | 5.91
 | Groceries | 10.36
 | Clothing | 180.45
 | Wather | 20.58
 | Electricity | 98.72
2017-12-21 00:00:00 | Groceries | 12
2017-12-22 00:00:00 | Gas