tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 23055d1212440518-vlookup-ranges-pricing-comparison-online
Sheet: Comparison

Customer ID | PN | Qty | Discount Code | Code,PN,Qty | SAP Pricing
JJBDIFEU | 005-031 | 200 | E41 | E41005-031200 | #N/A
JJBDIFEU | 005-031 | 200 | E41 | E41005-031200 | #N/A
REINHARDTEU | 005-031 | 2000 | E47 | E47005-0312000 | #N/A
HYDRA | 005-041 | 25 | E41 | E41005-04125 | #N/A
COVER | 005-041 | 100 | E47 | E47005-041100 | 0.8505000000000001 | VLOOKUP(E6,'SAP Trial'!$A$1:$B$90,2,0)
COVER | 005-041 | 120 | E47 | E47005-041120 | #N/A
KREMLINEU | 005-041 | 2500 | E47 | E47005-0412500 | #N/A
KREMLINEU | 005-041 | 2500 | E47 | E47005-0412500 | #N/A
KREMLINEU | 005-041 | 2500 | E47 | E47005-0412500 | #N/A
KREMLINEU | 005-041 | 2500 | E47 | E47005-0412500 | #N/A
KREMLINEU | 005-041 | 2500 | E47 | E47005-0412500 | #N/A
PRODOTTIEU | 005-041 | 40 | E48 | E48005-04140 | #N/A
RICHAL | 005-042 | 20 | E47 | E47005-04220 | #N/A
REINSPEU | 005-061 | 100 | E41 | E41005-061100 | 1.9845 | VLOOKUP(E15,'SAP Trial'!$A$1:$B$90,2,0)
BUSING | 005-061 | 200 | E41 | E41005-061200 | #N/A
Spreadsheet: 807531d1669934271-sum-of-values-into-merged-cells-sum-of-values-into-merged-cells
Sheet: Sheet1

 | Given | [NAME] display | Mark start | Indices begin | Preferrable display
 | 319.5000000000001 |  |  |  | 319.5000000000001
 | 319.5000000000001 |  |  |  | 319.5000000000001
 | 319.5000000000001 |  |  |  | 319.5000000000001
 | 319.5000000000001 |  |  |  | 319.5000000000001
 | 213.0000000000001 |  |  |  | 528
 | 157.5
 | 157.5
 | 121.5 |  |  |  | 364.5
 | 121.5
 | 121.5
 | 121.5 |  |  |  | 445.5
 | 81.00000000000001
 | 121.5
 | 121.5
 | 121.5 |  |  |  | 459
 | 121.5
 | 81.00000000000001
 | 135
 | 135 |  |  |  | 360
 | 135
 | 90.00000000000001
 | 144 |  |  |  | 288
 | 144
 | 144 |  |  |  | 384
 | 144
 | 96.00000000000001
 |  |  | zzz
Spreadsheet: 0616ff8c-b453-423e-ab2b-99468ee090df
Sheet: README

2000 and 2010 Census Totals by Race and Ethnicity for the Municipalities in the CMAP Region
SOURCES
American Factfinder, Census 2000 Summary File 1 (SF 1)
2010 Census Redistricting Data (Public Law 94-171) Summary File
 | Source table from each dataset: HISPANIC OR LATINO, AND NOT HISPANIC OR LATINO BY RACE
 | Table P4 in 2000 Summary File 1, and Table P2 in 2010 Redistricting table
 | 2000 | 2010
 | P004001 | P0020001 | Total population: Total
 | P004002 | P0020002 | Total population:  Hispanic or Latino
 | P004003 | P0020003 | Total population:  Not Hispanic or Latino
 | P004004 | P0020004 | Total population:  Not Hispanic or Latino; Population of one race
 | P004005 | P0020005 | Total population:  Not Hispanic or Latino; Population of one race; White alone
 | P004006 | P0020006 | Total population:  Not Hispanic or Latino; Population of one race; Black or African American alone
 | P004007 | P0020007 | Total population:  Not Hispanic or Latino; Population of one race; American Indian and [NAME] alone
 | P004008 | P0020008 | Total population:  Not Hispanic or Latino; Population of one race; Asian alone
 | P004009 | P0020009 | Total population:  Not Hispanic or Latino; Population of one race; Native Hawaiian and Other Pacific Islander alone
 | P004010 | P0020010 | Total population:  Not Hispanic or Latino; Population of one race; Some other race alone
 | P004011 | P0020011 | Total population:  Not Hispanic or Latino; Population of two or more races
"N/A" denotes that the municipality was incorporated after the 2000 Census, so no data are available
Created at CMAP 15 February 2011
Spreadsheet: 827804d1683037384-copying-formula-from-one-spreadsheet-to-another-without-source-reference-example-header-extraction-mikmak-
Sheet: Contents

Page Name | Content 1 | Content 2 | Content 3 | Content 4 | Content 5 | Content 6
AA
AB
AC
AD
AE
Spreadsheet: 09440955-2e1e-43f1-af33-6e0addd9885e
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
MONOS | Test | MONOS | Infectious Mononucleosis, Rapid Test, Serum | Infectious Mono Test, S | Agglutination | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.1 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | Negative (reported as positive or negative) | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 86308 |  |  |  |  | Rochester
MONOS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
MONOS | Result | MONOS | Infectious Mono Test, S | Infectious Mono Test, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31418-7 | Heterophile Ab:ACnc:Pt:Ser:Ord:
Spreadsheet: 167939d1342163187-sumproduct-with-date-restrictions-my-test
Sheet: Trips

States | Year | Quarter
CA | 2009 | 1
CA, OR | 2010 | 2
NV | 2011 | 3
AZ, CA | 2012 | 4
NV, OR | 2010 | 4
WA | 2012 | 1
NE | 2011 | 2
KS, NE | 2009 | 4
CO, KS, NE | 2009 | 3
WY, UT | 2010 | 1
SD | 2011 | 2
NE | 2009 | 4
KS | 2012 | 3
OK | 2012 | 1
TX, OK | 2011 | 3
NM, AZ | 2009 | 4
NM | 2012 | 2
NV | 2011 | 3
UT, CO | 2011 | 4
Spreadsheet: 811851d1672836557-identify-last-entry-and-display-data-staff-work-allocations-2023-v2-autoclave-added
Sheet: 2023

 |  |  | WRAPPING (R) |  | Wrapping (%) |  | AUTOCLAVE (A) |  | AUTOCLAVE (%) |  | BOOKING ON (B) | BOOKING ON (%) |  | WASH EMPTY (E) | WASH EMPTY (%) |  | PORTERING (P) | PORTERING (%) |  | WASH (W) | WASH (%) |  | JANUARY
SURNAME | FIRST NAME |  |  | Last Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 2023-01-02 00:00:00 |  | 2023-01-03 00:00:00 |  | 2023-01-04 00:00:00 |  | 2023-01-05 00:00:00 |  | 2023-01-06 00:00:00 |  | 2023-01-07 00:00:00 |  | 2023-01-08 00:00:00 |  | 2023-01-09 00:00:00 |  | 2023-01-10 00:00:00
aaaa | aaaaa
aaaaa | aaaaa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  | a |  | b |  | w |  | e |  |  | r |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r |  |  |  |  |  | r
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | r
Spreadsheet: 817277d1676088069-special-lookup-based-on-several-conditions-factors-llc-example
Sheet: newprices

 |  |  |  |  |  | Ship % | 0.1
 |  |  |  |  |  | Green, White, Weatherwood, Cedar, [NAME], Blue, [NAME], Gray, Black, Turquoise, [NAME], Ivory, [NAME], Lime Green, Red | Orange, Pink, Purple, Yellow | [NAME], Rustic Nutmeg, Rustic Gray
# |  | Gliders | Standard | Premium | Rustic | Special Price | Up Prem | Up Rust | [NAME] | Rust +
340 |  | 4' Fanback | 445 | 473 | 508
342 |  | 5' Fanback Console Glider | 595 | 630 | 692
404 |  | 4' [NAME] | 454 | 481 | 519
504 |  | 5' [NAME] | 505 | 534 | 576
642 |  | 5' Easy Console Glider | 661 | 699 | 754
400 |  | 4' West Chester | 385 | 409 | 439
406 |  | 4' Curve-Back | 414 | 438 | 471
Spreadsheet: 69504d1270035917-conditonal-greater-than-formula-sweep_example
Sheet: Sheet1

 |  |  |  |  |  |  | Actual Result |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name |  | Name
Week 34 | Odds H/D/A
Game 1 |  |  |  | Hibs | v | Celtic |  |  |  |  |  |  | 1 | 1 | 1 | 2 |  |  | 1 | 3 |  |  | 1 | 1 |  |  |  |  |  |  | 2 | 1 | 0 | 1 | 1 | 2 | 1 | 1 | 0 | 2
Game 2 |  |  |  | Man Utd | v | Chelsea |  |  | 1 | 2 |  |  | 1 | 2 | 2 | 1 | 1 | 0 | 2 | 0 |  |  | 2 | 1 |  |  | 0 | 0 |  |  | 1 | 0 |  |  | 2 | 1 | 1 | 2 | 2 | 1
Game 3 |  |  |  | Birmingham | v | Liverpool |  |  | 1 | 1 |  |  |  |  | 1 | 2 | 1 | 1 |  |  |  |  |  |  |  |  | 1 | 0 | 0 | 3 | 1 | 1 |  |  | 1 | 2 | 2 | 2
Game 4 |  |  |  | Porstmouth | v | [NAME] |  |  | 1 | 2 |  |  |  |  |  |  | 1 | 0 |  |  |  |  |  |  | 1 | 1 |  |  |  |  |  |  | 0 | 1
Game 5 |  |  |  | Sunderland | v | Spurs |  |  |  |  |  |  | 0 | 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 0 | 3 | 1 | 3 |  |  | 1 | 1
Game 6 |  |  |  | Burnley | v | Man City |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 3 |  |  | 0 | 2 | 1 | 2 |  |  | 0 | 2 |  |  |  |  |  |  |  |  | 0 | 2
 |  |  |  | Points for Week |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 59265d1259762294-random-cell-selct-highlighting-seattest
Sheet: Sheet 1

0.4574842296809889 | S
0.09597220891653624 | K
0.6598035454906348 | D
0.4356709596151924 | P | S
0.4556561192865729 | C |  | Ctrl + z
0.4728596300910841 | F
0.02818296392868946 | L
0.8035456391665958 | E
0.8301593037299395 | I
0.8556592445300644 | R
0.5864879036607369 | M
0.7923139999092561 | H
0.9379485232275782 | O
0.5693213255323666 | G
0.5689676764633538 | Q
0.7316317009939066 | N
0.09480010633560854 | B
0.9863997961985991 | A
0.9576755999279334 | J
Spreadsheet: 817338d1676143110-cant-see-formula-that-find-whether-two-droplist-selections-are-in-range-find-product-match
Sheet: Sheet1

OPTION 1: Pivot Table
Customer | Vegetables |  | Customer | Vegetables: | Qty | Price
Customer 5 | Peas |  | Customer 1 | Carrots
Customer 2 | Green beans |  |  | Brussels sprouts
Customer 4 | Sweetcorn |  |  | [NAME]
Customer 5 | Potatoes |  |  | [NAME]
Customer 3 | [NAME] |  |  | [NAME]
Customer 1 | [NAME] |  |  | Mushrooms
Customer 1 | Mushrooms |  |  | Spinach
Customer 1 | [NAME] |  | Customer 1 Total
Customer 4 | Sweet potatoes |  | Customer 2 | Broccoli
Customer 3 | Carrots |  |  | Cabbage
Customer 3 | Brussels sprouts |  |  | Green beans
Customer 4 | [NAME] |  |  | [NAME]
Customer 3 | Sweetcorn |  |  | Mushrooms
Customer 5 | Broccoli |  |  | Onions
Customer 1 | Brussels sprouts |  |  | Sweetcorn
Customer 3 | Onions |  | Customer 2 Total
Customer 2 | Mushrooms |  | Customer 3 | Carrots
Customer 2 | Onions |  |  | Brussels sprouts
Customer 4 | Tomatoes |  |  | [NAME]
Customer 4 | [NAME] |  |  | Onions
Customer 1 | Spinach |  |  | Potatoes
Customer 5 | Carrots |  |  | Sweet potatoes
Customer 1 | [NAME] |  |  | Sweetcorn
Customer 1 | Carrots |  | Customer 3 Total
Customer 3 | Potatoes |  | Customer 4 | Tomatoes
Customer 2 | Cabbage |  |  | Brussels sprouts
Customer 5 | Cabbage |  |  | [NAME]
Customer 4 | [NAME] |  |  | [NAME]
Customer 2 | [NAME] |  |  | Sweet potatoes
Customer 2 | Sweetcorn |  |  | Sweetcorn
Customer 2 | Broccoli |  | Customer 4 Total
Customer 4 | Brussels sprouts |  | Customer 5 | Carrots
Customer 5 | Tomatoes |  |  | Peas
Customer 5 | [NAME] |  |  | Tomatoes
Customer 3 | Sweet potatoes |  |  | Broccoli
 |  |  |  | Cabbage
 |  |  |  | [NAME]
 |  |  |  | Potatoes
 |  |  | Customer 5 Total
 |  |  | Grand Total
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(MS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(MS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 20010-11
 | Major Group | MS - Master's
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 2 | 12 | 0 | 1
 |  | Part Time | 14 | 35 | 1 | 2
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | 5 | 8 | 0 | 1
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
We do not track graduates.
Spreadsheet: 682147d1591920819-how-to-split-up-text-and-format-into-dates-example-2-
Sheet: Approva Details

Employee | 1 | 2 | 3 | New
[NAME] | 2020-05-23 00:00:00 | - | 2020-05-29 00:00:00 | 5/23/2020 - 5/29/2020
[NAME] | 2020-05-30 00:00:00 | - | 2020-06-07 00:00:00 | 5/30/2020 - 6/7/2020
[NAME] | 2020-05-23 00:00:00 | - | 2020-05-29 00:00:00 | 5/23/2020 - 5/29/2020
[NAME] | 2020-05-23 00:00:00 | - | 2020-05-29 00:00:00 | 5/23/2020 - 5/29/2020
Spreadsheet: 154508d1336468318-excel-2007-getpivotfunction-getpivot1
Sheet: Sheet1

Week | Agent Name | Loan Processed |  |  |  |  |  |  | Sum of Loan Processed | Week
Wk 1 | A |  |  |  |  |  |  |  | Agent Name | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Grand Total
Wk 1 | B | 2 |  |  |  |  |  |  | A |  | 6 | 11 | 16 | 33
Wk 1 | C | 3 |  |  |  |  |  |  | B | 2 | 7 | 12 | 17 | 38
Wk 1 | D | 4 |  |  |  |  |  |  | C | 3 | 8 | 13 | 18 | 42
Wk 1 | E | 5 |  |  |  |  |  |  | D | 4 | 9 | 14 | 19 | 46
Wk 2 | A | 6 |  |  |  |  |  |  | E | 5 | 10 | 15 | 20 | 50
Wk 2 | B | 7 |  |  |  |  |  |  | Grand Total | 14 | 40 | 65 | 90 | 209
Wk 2 | C | 8
Wk 2 | D | 9
Wk 2 | E | 10
Wk 3 | A | 11
Wk 3 | B | 12
Wk 3 | C | 13
Wk 3 | D | 14 |  |  |  |  |  |  | Agent Name | Wk 1 | Wk 2 | Wk 3 | Wk 4
Wk 3 | E | 15 |  |  |  |  |  |  | A | 0 | 6 | 11 | 16
Wk 4 | A | 16 |  |  |  |  |  |  | B | 2 | 7 | 12 | 17
Wk 4 | B | 17 |  |  |  |  |  |  | C | 3 | 8 | 13 | 18
Wk 4 | C | 18 |  |  |  |  |  |  | D | 4 | 9 | 14 | 19
Wk 4 | D | 19 |  |  |  |  |  |  | E | 5 | 10 | 15 | 20
Wk 4 | E | 20
Spreadsheet: dana_davis__4589__Company-Profit Center Tracking
Sheet: Company Codes

ENRON PRINCIPAL INVESTMENTS
Company Tracking Sheet
Prior Company |  | New Company |  | Default Profit Center |  | Company Description
527 | = | 1639 |  | 11254 |  | EPI- Joint Energy Investments
914 | = | 1640 |  | 11255 |  | EPI- Enron Capital Management II Lp
915 | = | 1641 |  | 11320 |  | EPI- Enron Capital Management III Lp
1314 | = | 1642 |  | 11256 |  | EPI- ECTMI Trutta Holdings LP
1319 | = | 1643 |  |  |  | EPI- Accounting Entity of Enron Corp
272 | = | 1649 |  | 11257 |  | EPI- ECT Merchant Investments
01N2 | = | 1650 |  | 11258 |  | EPI- ECT Finance
046K | = | 1654 |  | 11259 |  | EPI- Sundance ECT US
957 | = | Transfer |  |  |  | Kenobe
961 | = | Transfer |  |  |  | OBI Investments
1091 | = | 1688 |  | 11260 |  | EPI- EBS Investments
1179 | = | 1691 |  | 11261 |  | EPI- EBS Europe Accounting Entity
1307 | = | 1689 |  | 11262 |  | EPI- EBS Ventures, L.L.C.
053X | = | 1690 |  | 11263 |  | EPI- Enron Communications Investments Group
086M | = | 1693 |  | 11264 |  | EPI- Enron Networks Investments
1500 | = | 1694 |  | 11265 |  | EPI- [NAME] (HPL)
489 | = | 1695 |  | 11266 |  | EPI- Accounting Entity of 489
58 | = | 1696 |  | 11267 |  | EPI- LOA, Inc
72 | = | 1697 |  | 11268 |  | EPI- Enron ACS, Inc
030S | = | 1698 |  | 11269 |  | EPI- ECT Europe Finance, Inc
1570 | = | 1699 |  | 11270 |  | EPI- EESO Merchant Investments
3 | = | 1700 |  | 11271 |  | EPI- ERAC Finance
1211 | = | 1649 |  | 11257 |  | EPI- ECT Merchant Investments
046U | = | Transfer
049V | = | 1704 |  |  |  | Copel
025Z | = | 1705 |  |  |  | Copel
025P | = | 1706 |  |  |  | Copel
 |  | 1687 |  |  |  | EPI- Cash Servicing Company
 |  | 1666 |  |  |  | EPI/ENA Velocity AES
 |  | 1667 |  |  |  | EPI/EBS Velocity AES
Spreadsheet: 878054d1725018238-need-help-with-data-formula-dummy_data2
Sheet: Sample

Name | Service1 | Service2 | Service3 | Account1 | Account2 | Account3 |  |  |  | X | we | rd | Y | Z | R
A | X | we | rd | xx | yy | zz |  |  | xx | A, C | A | A | C | C
B | Y | rd | X | zd | zf | zg |  |  | yy | A | A | A
C | Z | Y | X | cd | xx | ht |  |  | zz | A | A | A
D | we | R | rd | se | sr | st |  |  | zd | B |  | B | B
E | X | we | Rd | ht | hy | hu |  |  | zf | B |  | B | B
 |  |  |  |  |  |  |  |  | zg | B |  | B | B
 |  |  |  |  |  |  |  |  | cd | C |  |  | C | C
Accounts | X | Y | Z | R | J | we | rd |  | ht | C, E | E | E | C | C
xx | A, C |  | C |  |  | A | A |  | se |  | D | D |  |  | D
ht | C, E | C | C |  |  | E | E |  | sr |  | D | D |  |  | D
 |  |  |  |  |  |  |  |  | st |  | D | D |  |  | D
 |  |  |  |  |  |  |  |  | hy | E | E | E
 |  |  |  |  |  |  |  |  | hu | E | E | E
Spreadsheet: 717734d1612816945-trying-to-concatenate-multipe-cells-that-woudl-then-build-a-reference-to-a-named-cell-defnined-named-cell-name-being-called-by-concatenation-of-multiple-other-cells
Sheet: Plans

 | Sales Plan | Hurdle1 |  | Hurdle2 |  | Hurdle3 |  | Hurdle4 |  | Hurdle5
 | Name | Dollars | Rate
 | NBZ | 250000 | 0.1
 | STD
 | ENT
 | _
 | Text Concatenate
 | Cell C4 has a defined name of |  |  | NBZ_Hurdle1_Dollars |  | which is a comination of B4, C2, and [NAME] (B4&"_"&C2&"_"&C3)
 | What I want is to create a "query" on the Emplyee Tab that shows  =D11 that would pull the cell name in C4
Spreadsheet: 847554d1698417615-gather-information-across-multiple-sheets-where-the-info-may-be-in-different-cells-sample-workbook-2-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Order Detailed Analysis Report
 |  |  |  |  | Service Order |  |  |  |  |  |  | 15554878 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End On Date/ Time |  |  |  |  |  |  |  |  |  |  |  | 2023-10-02 18:01:00
 |  |  |  |  | Primary Technician |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL/ ST/ SRC
 |  |  |  |  | Service Location |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Address
 |  |  |  |  | Location Bill To |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Alternate SO Bill To
 |  |  | Service Agreement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Age Of Equipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Age Of Home
 |  |  | Reference Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lead Turnover
 |  |  | Quote Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Signature
 |  |  |  | Totals
 |  |  |  | Revenue |  |  | Discount |  |  |  |  |  |  |  |  | Sales Tax |  |  |  |  | Total |  |  |  |  | Prepaid Revenue |  |  |  |  |  |  | Inventory |  |  |  |  |  |  |  |  |  |  | Expenses |  |  |  |  |  | Net Revenue
 | Quoted Lines
 | Member Of |  |  |  |  |  |  |  |  | Type |  |  |  |  |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty |  |  |  |  |  | Price |  |  |  |  |  |  | Event
 | Performed Lines
 | Type |  |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty |  |  |  |  | Price |  |  |  |  |  |  |  | Event |  |  |  |  |  |  | PPEDate
 | Expense Lines
 | Type |  |  |  |  | Date |  |  |  |  |  |  |  |  | Description |  |  |  |  |  |  | Qty |  |  | Cost |  |  |  |  | Event |  |  |  |  |  |  |  | PO |  |  |  |  |  |  |  |  |  | Transferred |  |  |  | PPEDate
 | Purchase Orders
 | PO |  |  |  |  | Vendor |  |  |  |  |  |  |  |  |  |  | Name |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Event |  |  |  |  |  |  |  |  |  |  | Created On |  |  |  |  | Received On
 | Payments
 | Payment Method |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount |  |  | Number |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  | Provider
 | Service Order Notes
 |  |  | Dispatch Notes
 |  | Tech Office Notes
 |  |  |  | Equipment
 |  |  |  | Equipment Name |  |  |  | Age |  |  |  |  | Make |  |  |  |  |  | Model |  |  |  |  | Serial Number |  |  |  |  |  |  | Install |  |  |  |  |  |  |  |  |  | Warranty Name |  |  |  |  |  |  |  |  |  |  |  | Warranty End
 |  |  |  | Gas water heater |  |  |  | 0 |  |  |  |  | Rheem |  |  |  |  |  | XG40S09HE38U0 |  |  |  |  | Q142318066 |  |  |  |  |  |  | 2023-10-02 20:24:46.797000
Spreadsheet: errol_mclaughlin_jr__10906__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 11/16/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Castrol N.V. | YK1817.1 YK1818.1 YK1819.1 | F | NG | [NAME]
Giant Refining Company | YK0573.1/2 | P | NG | [NAME]
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
Cinergy Resources Inc. | YK0586.1 | F | NG | Cinergy Marketing & Trading, LLC
[NAME] | [NAME] | F | NG | [NAME], Inc.
[NAME] | YK0554.2 | F | NG | [NAME], Inc.
Duke Energy Marketing Limited Partnership | YK0592.1 YK0600.1 YK0613.1 | F | NG | Duke Energy Marketing Limited Partnership (w/ECC)
El Paso Gas Marketing Company | YK0024.1 | F | NG | El Paso Merchant Energy, LP
Mid-America Pipeline Company | YK0871.1 | F | NG | MidAmerican Energy Company