tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 330515d1404772135-summing-across-multiple-sheets-by-specific-name-vlookup-june_template-trivia-scorecard
Sheet: Week5

TEAM NAME: | 1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL |  |  |  | Cumulative
Danites | 2 | 5 | 5 | 5 | 5 | 5 | 5 |  |  |  |  | Stepdads | 160 | 49.5
Stepdads | 6 | 2 | 2 | 2 | 2 | 2 | 2 |  |  |  |  | [NAME] | 117.5 | 42
 |  |  |  |  |  |  |  |  |  |  |  | The Wolves | 86.75
 |  |  |  |  |  |  |  |  |  |  |  | The Three Woods | 17
 |  |  |  |  |  |  |  |  |  |  |  | Team Team | 43
 |  |  |  |  |  |  |  |  |  |  |  | Rowdy's Raiders | 26
 |  |  |  |  |  |  |  |  |  |  |  | Naughty Neighbor | 5.5
Spreadsheet: 823137d1679736207-lookup-multiple-values-from-a-table-cmms-ans
Sheet: Drill Drop Downs

 | TblEquipCat | Column1 |  |  | TblServiceSizes |  |  | TblComponentLife |  | TblDrillNumbers
 | [NAME] |  |  |  | 250 |  |  | Carousel
 | [NAME] |  |  |  | 500 |  |  | Compressor
 | Light Vehicle |  |  |  | 750 |  |  | [NAME]
 | [NAME] |  |  |  | 1000 |  |  | Engine
 | [NAME] |  |  |  | 1250 |  |  | [NAME]
 | Water Truck |  |  |  | 1500 |  |  | Final Drive - CS
 |  |  |  |  | 1750 |  |  | Final Drive - OCS
 |  |  |  |  | 2000 |  |  | Final Drive Motor - CS
 |  |  |  |  |  |  |  | Final Drive Motor - OCS
 |  |  |  |  |  |  |  | Func Box
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Pump - Auxillary
 |  |  |  |  |  |  |  | Pump - Charge
 |  |  |  |  |  |  |  | Pump - Feed
 |  |  |  |  |  |  |  | Pump - Rotation
 |  |  |  |  |  |  |  | Ropes - Hoist
 |  |  |  |  |  |  |  | Ropes - Pulldown
 |  |  |  |  |  |  |  | Rotary Head
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 82007d1282079392-matching-rows-in-excel-and-finding-out-duplicate-rows-contacts_records-2-
Sheet: All_Records

Company Name | First Name | Last Name | Job Title | Address 1 | Phone | Website
Big Design | [NAME] | Love | Sales Manager | 11 NY, USA123 | 123-000-000
Green llc | Stephen | Gills | Director | 123, Texas, USA | 543-333-233 | www.bigdesign.com
Green llc | [NAME] | McKay | CEO | 34B, London, UK | 432-455-354 | www.bigdesign.com
Angry [NAME] | [NAME] | Tilds | Technician | 333, NYC , USA | 111-111-111 | www.angryfox.com
TP21 Company | [NAME] | Mott |  |  | 101-101-909
 | [NAME] | Mobile |  | 33, NY
ABC LLC | [NAME] | Soll | President | Garden Town, LA, USA | 542-123-123 | www.abc.com
 | Ramon | Hobbs | Secretary | 123, AB, USA | 123-101-100
ABC LLC | [NAME] | Fard | Technician | Town, UK | 453-989-876 | www.abc.com
ABC LLC | [NAME] | Higg | Director | 818 Melbourne, Australia | 456-678-876 | www.abc.com
 | [NAME] | Folder | Sales
Future Ltd | [NAME] | Tilds | Assistant | 12, NY, USA | 233-111-111 | www.futureltd.com
 | [NAME] | [NAME] | Production |  | 345-345-444
 | [NAME] | Bond |  | VP | 165-827-272
Future Ltd | Beny | Hard | Vice Executive | 33, UK | 101-000-000
Future Ltd | [NAME] | Farris |  | 34, New Zeland | 103-340-009 | www.futureltd.com
 | [NAME] |  |  |  | 102-090-292
Spreadsheet: 151518d1334950397-what-formula-can-i-use-to-count-number-of-items-by-date-and-another-criterion-example
Sheet: Sheet1

 | January | February
A
B
C
D
ITEM | DATE
A | 2012-01-27 01:30:00
D | 2012-02-01 05:31:00
D | 2012-01-02 21:19:00
C | 2012-01-14 04:00:00
D | 2012-02-20 03:12:00
B | 2012-01-11 15:28:00
B | 2012-01-19 06:50:00
A | 2012-02-22 18:30:00
Spreadsheet: 836301d1689252077-if-and-countif-function-not-producing-correct-result-s-if_countif_help
Sheet: List 1

ID | Full Name | Gender | Race | Ethnicity | Status
ID 01 | Employee 1 | Female | Black/African American | Not Hispanic or Latino | A
ID 02 | Employee 2 | Female | White | (blank) | I
ID 03 | Employee 3 | Female | White | (blank) | A
ID 04 | Employee 4 | Male | Black/African American | (blank) | A
ID 05 | Employee 5 | Male | White | (blank) | I
ID 06 | Employee 6 | Female | Other | Not Hispanic or Latino | A
ID 07 | Employee 7 | Male | White | Not Hispanic or Latino | A
ID 08 | Employee 8 | Male | White | (blank) | A
ID 09 | Employee 9 | Male | Other | Hispanic | A
ID 10 | Employee 10 | Male | Black/African American | Not Hispanic or Latino | I
ID 11 | Employee 11 | Male | Black/African American | Not Hispanic or Latino | A
ID 12 | Employee 12 | Male | White | (blank) | A
ID 13 | Employee 13 | Male | White | (blank) | A
ID 14 | Employee 14 | Male | Black/African American | (blank) | A
ID 15 | Employee 15 | Male | White | (blank) | I
ID 16 | Employee 16 | Male | Black/African American | (blank) | A
ID 17 | Employee 17 | Male | White | (blank) | A
ID 18 | Employee 18 | Male | Black/African American | Not Hispanic or Latino | I
ID 19 | Employee 19 | Male | White | Not Hispanic or Latino | A
ID 20 | Employee 20 | Female | Black/African American | (blank) | A
ID 21 | Employee 21 | Female | White | Not Hispanic or Latino | A
ID 22 | Employee 22 | Female | Black/African American | (blank) | A
ID 23 | Employee 23 | Female | Black/African American | Not Hispanic or Latino | I
ID 24 | Employee 24 | Female | Black/African American | (blank) | A
ID 25 | Employee 25 | Male | White | (blank) | A
Spreadsheet: 267357d1380052350-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: NEW YORK-31

 | COUNTY | CODE
 | Albany | 1
 | Allegany
 | Bronx
 | Broome
 | Cattaraugus
 | Cayuga
 | [NAME]
 | Chemung
 | Chenango
 | [NAME]
 | Columbia
 | Cortland
 | Delaware
 | Dutchess
 | Erie
 | Essex
 | Franklin
 | Fulton
 | [NAME]
 | Greene
 | [NAME]
 | Herkimer
 | [NAME]
 | Kings
 | Lewis
 | [NAME]
 | [NAME]
 | Monroe
 | Montgomery
 | Nassau
 | New York
 | [NAME]
 | Oneida
 | Onondaga
 | Ontario
 | Orange
 | Orleans
 | Oswego
 | Otsego
 | Putnam
 | Queens
 | Rensselaer
 | Richmond
 | Rockland
 | St. Lawrence
 | Saratoga
 | Schenectady
 | Schoharie
 | Schuyler
 | Seneca
 | Steuben
 | Suffolk
 | [NAME]
 | Tioga
 | Tompkins
 | [NAME]
 | [NAME]
 | Washington
 | Wayne
 | Westchester
 | Wyoming
 | Yates
Spreadsheet: 5caba5fc-a633-4c9a-8d40-aa9a4a5c0a6d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Piedmont [NAME] Troops serving Fauquier and Culpeper Counties (9-27-2011) | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Troop | # | Location | [NAME] | Home # | Committee Chair | Home # | Meeting Location | Day
 |  |  |  | Fauquier County Boy Scout Troops
Troop | 10 | Warrenton | [NAME] | (540) 349-2819 | [NAME] | (540) 347-5460 | St. James Episcopal Church | Tue
Troop | 92 | Warrenton | [NAME] | [PHONE] | [NAME] | [PHONE] | Warrenton Presbyterian Church | Wed
Troop | 161 | Warrenton | [NAME] | [PHONE] | [NAME] | [PHONE] | Bethel United Methodist Church | Mon
Troop | 175 | Warrenton | [NAME] | (540) 439-8926 | [NAME] | [PHONE] | Warrenton United Methodist Church | Mon
Troop | 180 | Warrenton | [NAME] | [PHONE] | [NAME] | (540) 937-5960 | Our Savior Lutheran Church | Mon
Troop | 600 | Warrenton | Rik Janowitz | [PHONE] | [NAME] | (540) 270-1192 | [NAME]. [NAME]. | Mon
Troop | 957 | Warrenton | [NAME] | [PHONE] | [NAME] | [PHONE] | St. John's Catholic Church | Mon
Troop | 1171 | Warrenton | [NAME] | (703) 330-2574 | [NAME] | [PHONE] | [NAME]. [NAME]. Company 1 | Thu
Troop | 1475 | Warrenton | [NAME] | [PHONE] | [NAME] | [PHONE] | LDS Church Warrenton Ward 1 | Wed
Troop | 1476 | Warrenton | [NAME] | [PHONE] | [NAME] | [PHONE] | LDS Church Warrenton Ward 2 | Tue
Troop | 2020 | Warrenton | [NAME] | (540) 351-0398 | [NAME] | (540) 347-5474 | Boys and Girls Club | Wed
Troop | 911 | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | Fireside Church-Vint Hill | Mon
Troop | 177 | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | Marshall Ruritan Club | Mon
Troop | 1177 | Midland | [NAME] | (540) 347-0546 | [NAME] | (540) 349-8837 | Midland United Methodist Church | Mon
Troop | 1187 | Morrisville | [NAME] | (540) 428-1916 | [NAME] | [PHONE] | Morrisville United Methodist Church | Mon
Troop | 1930 | Bealeton | [NAME] | (540) 439-3998 | [NAME] | [PHONE] | Bealeton VFW Post | Tue
 |  |  |  | Culpeper County Boy Scout Troops
Troop | 196 | Culpeper | [NAME] | [PHONE] | [NAME] | [PHONE] | St. Lukes Lutheran Church | Mon
Troop | 198 | Culpeper | [NAME] | (540) 423-1786 | [NAME] | [PHONE] | Culpeper United Methodist Church | Mon
Troop | 225 | Culpeper | [NAME] | (540) 923-4026 | [NAME] | (540) 972-4838 | LDS Church Culpeper | Thu
Troop | 525 | Culpeper | [NAME] | [PHONE] | [NAME] | [PHONE] | LDS Church Culpeper | Thu
Troop | 550 | Rixeyville | [NAME] | [PHONE] | [NAME] | [PHONE] | [NAME] | Wed
Troop | 1202 | [NAME] | [NAME] | [PHONE] | [NAME] | [PHONE] | [NAME] | Tue
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: EAST-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 112784842 | 259383408.3438704
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 35399361 | 83539570
4 |  | Option Premiums | 0 | -496
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 148184203 | 342922482.3438704
 | Purchases:
6 |  | 3rd Party / Inter Enron | -113041005 | -251061724
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -35716476 | -87339489
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 126324 | 294758
 | Total Purchases: |  | -148631157 | -338106455
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | -50195 | -134108
14 |  | Cash Out | 343047 | 752294
15 |  | Cash In | -411686 | -904101
16 |  | Synthetic Storage | -177265 | -380601
 | Total Imbalances: |  | -296099 | -666516
 | Storage:
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 17716 | 37912
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 17716 | 37912
 | Total Storage: |  | 17716 | 37912
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 785337 | 1738072.868244035
 |  |  | 0 | 0
23 | Fuel: |  | -126324 | -294758
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -528962
25 |  | Demand | 0 | -474120
 | Total Transport Expense: |  | 0 | -1003082
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | -82527
 | Total Transport Revenue: |  | 0 | -82527
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 42944
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 42944
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | 5194257.056399999
31 |  | Prior Month Book Balance | 0 | -15409479.0863
 |  | Total MTM Income | 0 | -10215222.0299
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 6568205
34 |  | Originations | 0 | 111621
35 |  | Broker Fees | 0 | -10489
36 |  | Asset Group Demand Charges | 0 | -36809
37 |  | [NAME] | 0 | 24523.945
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 51367
 |  | TOTAL INTRA-MTH
FT-East
 |  | Current Month MTM | 0 | 580000 | 0 | 0 |  |  | 0 | 0
 |  | Financial Liquidations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | Originations | 0 | 0 | 0 | 0 |  |  | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: ae0cd5ec-438d-4a7c-85e6-13b1c89cf724
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
MUG | Test | MUG | Mugwort, IgE | Mugwort, IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
MUG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MUG | Result | MUG | Mugwort, IgE | Mugwort, IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6183-8 | Artemisia [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 845161d1696683530-how-to-sort-summed-values-based-on-color-volunteer-report
Sheet: Sample

[NAME] | Q1 | Q2 | Q3 | Q4 | Other hours | Sum
[NAME] | 3 | 12 | 6 | 45
[NAME] | 7 |  | 22
Frederic | 11 |  |  | 30
Angelina | 8 | 8
[NAME] |  |  | 5 | 7
[NAME] |  |  | 75
Lily | 19 | 2 | 5
[NAME] |  |  |  |  | 5
Roseanne | 56 | 50 | 30
[NAME] | 40 | 40 | 40
Spreadsheet: f7f8ee31-a20d-4180-8880-62fd6fe1e6f8
Sheet: Sheet1

Table S2 The correlation in the contribution of structural evolution to gene expression divergence | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
among Drosophila and yeast species. For each type of structural evolution, we used the P-value from
[NAME], which was performed between genes with
[NAME]effects to gene expression divergence and the other genes,
to represent the degree of contribution of this type of structural evolution to gene expression divergence.
Pearson correlation coefficient/statistical significance (P-value)
 | [NAME] paradoxus pair | [NAME] bayanus pair | D. melanogaster-D. simulans pair | D. melanogaster-D. sechellia pair
[NAME] paradoxus pair | - | -0.12/0.49 | 0.29/0.003 | 0.30/0.01
[NAME] bayanus pair | - | - | -0.04/0.80 | -0.01/0.97
D. melanogaster-D. simulans pair | - | - | - | 0.90/1.33E-13
D. melanogaster-D. sechellia pair | - | - | - | -
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: last december sheet

2008-12-31 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 96732d1296049119-stuck-lookup-help-tcc-new-final-left
Sheet: wk19

Tuesday
06:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Name | Night
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points |  | 1
1 |  |  |  |  |  |  | 2
3 |  |  |  |  |  |  | 4
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
5 |  |  |  |  |  |  | 6
7 |  |  |  |  |  |  | 8
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
9 |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  | 12
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
13 |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  | 16
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
17 |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  | 20
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
21 |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  | 24
Wednesday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
25 |  |  |  |  |  |  | 26
27 |  |  |  |  |  |  | 28
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
29 |  |  |  |  |  |  | 30
31 |  |  |  |  |  |  | 32
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
33 |  |  |  |  |  |  | 34
35 |  |  |  |  |  |  | 36
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
37 |  |  |  |  |  |  | 38
39 |  |  |  |  |  |  | 40
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
41 |  |  |  |  |  |  | 42
43 |  |  |  |  |  |  | 44
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
45 |  |  |  |  |  |  | 46
47 |  |  |  |  |  |  | 48
Thursday
06:00:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
49 |  |  |  |  |  |  | 50
51 |  |  |  |  |  |  | 52
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
53 |  |  |  |  |  |  | 54
55 |  |  |  |  |  |  | 56
07:20:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
57 |  |  |  |  |  |  | 58
59 |  |  |  |  |  |  | 60
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
61 |  |  |  |  |  |  | 62
63 |  |  |  |  |  |  | 64
08:40:00
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
65 |  |  |  |  |  |  | 66
67 |  |  |  |  |  |  | 68
Rank | Player | Sets Won | Score |  | Sets Won | Player | Rank |  | MW | ML | GW | GL | GB | SB | Points
69 |  |  |  |  |  |  | 70
71 |  |  |  |  |  |  | 72
Spreadsheet: 704056d1605324959-how-do-i-get-division-colum-to-to-fill-with-a-formula-how-do-i-get-division-to-to-fill-with-a-formula
Sheet: Sheet1

ENTRY | Date&Time | Who | [NAME] | Division
1690 | 2020-11-11 06:16:44 | [NAME] | [EMAIL] |  |  |  | ANCC
1691 | 2020-11-11 06:35:03 | [NAME] | [EMAIL] |  |  |  | ANCC
1692 | 2020-11-11 07:12:01 | [NAME] | [EMAIL] |  |  |  | Plym-image360
1693 | 2020-11-11 07:18:55 | [NAME] | [EMAIL] |  |  |  | Plym-image360
1694 | 2020-11-11 07:19:23 | [NAME] | [EMAIL] |  |  |  | Plym-image360
1695 | 2020-11-11 07:35:30 | [NAME] | [EMAIL] |  |  |  | Plym-image360
1696 | 2020-11-11 07:38:15 | [NAME] | [EMAIL] |  |  |  | ANCC
1697 | 2020-11-11 07:41:35 | [NAME] | [EMAIL] |  |  |  | Troy-image360
1698 | 2020-11-11 07:44:16 | [NAME] | [EMAIL] |  |  |  | ANCC
1699 | 2020-11-11 07:54:43 | Therese [NAME] | [EMAIL] |  |  |  | ANCC |  | Tried using wild cards such as
1700 | 2020-11-11 08:16:20 | [NAME] | [EMAIL] |  |  |  | Troy-image360 |  | *allegra to populate ANCC
1701 | 2020-11-11 08:19:52 | Carly Correll | [EMAIL] |  |  |  | Troy-image360 |  | *360ply to populate [NAME]-image360
 |  |  |  |  |  |  |  |  | *360troy to populate Troy-image360
 |  |  |  |  | ANCC
 |  |  |  |  | Plym-image360
 |  |  |  |  | Troy-image360
Spreadsheet: 818681d1676996703-nested-xlookup-counta-example
Sheet: Sheet1

 |  | STAFF/HOURS
 |  | [NAME] | [NAME] | [NAME]
CLIENT | PROJECT TYPE
Apple | Long | 3 |  | 7
Microsoft | Short |  | 1
HP | Long |  | 1 | 5
Google | Short | 2
HP | Long | 1 |  | rotating out
 | Number of Short project | ? | ? | ?
 | Number of Long projects | ? | ? | ?
Spreadsheet: daren_farmer__6567__costmodel
Sheet: Sheet1

Texas Trader Support
RC 1497
Manager | 1 | ALOMOXX.01-T | [NAME]
 |  | ALOMOXX.02-T | Daily Trader Support
 |  | ALOPOXX.07 | Interface with Gas Control
 |  | APE1497.01 | Develop Employee Careers
 |  | APE1497.02 | Provide Mentoring
 |  | APE1497.03 | Feedback
Senior Specialist | 1 |  | Transaction Monitoring | 0.3751
 |  | ALOMOXX.02-T | Daily Trader Support | 0.251
 |  | ALOPOXX.07 | Interface with Gas Control | 0.1875
 |  | ALOPOXX.11 | Customer Service | 0.1275
 |  | ALOMOXX.17-T | End of month Cleanup | 0.06
Senior Specialist | 1 | ALOMOXX.02-T | Daily Trader Support | 0.5
 |  | ALOPOXX.07 | Interface with Gas Control | 0.1
 |  | ALOMOXX.04-T | Prepare Noms/Pathing | 0.1
 |  | ALOMOXX.05-T | Noms | 0.1
 |  | ALOMOXX.10-T | Renom Activity | 0.05
 |  | ALOMOXX.11-T | Pipeline Balancing | 0.03
 |  | ALOMOXX.13-T | Manage Imbalances | 0.02
 |  | ALOMOXX.17-T | End of month Cleanup | 0.03
 |  | AOA1497.13 | [NAME] | 0.05
 |  | AOA1497.15 | Preventive OA | 0.02
Spreadsheet: 75189d1275706011-show-hide-cells-summarysheet
Sheet: Sheet2

 |  |  | LOCAL ITEMS | SITEPLANNED | Material need | UOM | CURRENT STOCK at W/H | material need to brought | network Material Usage | Balance carried forward
 |  |  | Power cable (black) | 20 | 240 | Mtrs | 100 | 140 | 100 | 140
 |  |  | Power cable  (red) |  | 240 | Mtrs | 80 | 160 | 130 | 110
 |  |  | Grounding cable |  | 140 | Mtrs | 40 | 100 | 50 | 90
 |  |  | Jumper Cable 1/2" Din M-Din M of 3.0 M Length |  | 120 | Pcs | 40 | 80 | 40 | 80
 |  |  | Feeder Connector - DIN Female for 7/8" |  | 240 | Pcs | 32 | 208 | 150 | 90
 |  |  | [NAME] |  | 120 | Pcs | 50 | 70 | 70 | 50
 |  |  | 6 way Clamp for 7/8" Feeder Cable |  | 720 | Pcs | 450 | 270 | 320 | 400
 |  |  | [NAME] for 7/8" Feeder cable |  | 240 | Pcs | 120 | 120 | 100 | 140
 |  |  | Feeder Cable 7/8" |  | 7200 | Mtrs | 4500 | 2700 | 3000 | 4200
 |  |  | GSM Antenna 1800 Band, 66-68 HBW, 7-7.5 VBW , 17.5 - 18 Dbi gain with 0-10 electrical tilt |  | 60 | Pcs | 50 | 10 | 20 | 40
Spreadsheet: 292613d1390689565-recalculate-using-two-different-formulas-in-same-cell-conversion-1
Sheet: Matrix

Unit | [NAME] | cm | inches | feet | yards | meters | kilometers | miles
[NAME] | 1 | 0.1 | 0.03937007874015748 | 0.00328084 | 0.00109361 | 0.001 | 1e-06 | 6.21371e-07
cm | 10 | 1 | 0.3937007874015748 | 0.0328084 | 0.0109361 | 0.01 | 1e-05 | 6.21371e-06
inches | 25.4 | 2.54 | 1 | 0.08333333600000001 | 0.027777694 | 0.0254 | 2.54e-05 | 1.57828234e-05
feet | 304.7999902464003 | 30.47999902464003 | 11.99999961600001 | 1 | 0.3333323173333658 | 0.3047999902464003 | 0.0003047999902464003 | 0.000189393874739396
yards | 914.4027578387178 | 91.44027578387177 | 36.00010857632747 | 3.000009144027579 | 1 | 0.9144027578387177 | 0.0009144027578387177 | 0.0005681833560410019
meters | 1000 | 100 | 39.37007874015748 | 3.28084 | 1.09361 | 1 | 0.001 | 0.000621371
kilometers | 1000000 | 100000 | 39370.07874015748 | 3280.84 | 1093.61 | 1000 | 1 | 0.621371
miles | 1609344.497892563 | 160934.4497892563 | 63360.01960206942 | 5280.001802465837 | 1759.995236340286 | 1609.344497892563 | 1.609344497892563 | 1
Spreadsheet: 217030d1361972349-count-unique-text-values-using-criteria-unique_question
Sheet: Sheet2

 | Summary Table |  |  |  |  |  |  |  | Data Table
 | Reviewer | Audited Providers | Non-Compliant Claims | Audited Claims | % Non-Compliant Claims | Non-Compliant Amount | % Non-Compliant Amount |  | Reviewer | Date of Audit | Provider ID | Reimbursed Amount | Non-Compliant Amount
 | [NAME], [NAME] |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | A | 132 | 0
 | [NAME], [NAME] |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-06 00:00:00 | A | 144 | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | A | 84 | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | A | 60 | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | A | 204 | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | B | 132 | 132
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | C | 108 | 108
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | D | 12 | 0
 |  |  |  |  |  |  |  |  | [NAME], [NAME] | 2013-02-05 00:00:00 | E | 252 | 252
Spreadsheet: 598730d1542678683-lookup-multiple-values-in-the-same-column-i-think-this-is-what-im-looking-for-amazon-bookeeping-example
Sheet: Sheet2

 | Product Title | All Fees | Payments/Sale | Net Profit after all fees
 | Total