tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 99462d1298068983-help-using-lookup-for-multiple-positions-in-fantasy-baseball-draft-bb-dft2
Sheet: C

Column1 | First name | Last Name | Team | Owner |  | Position | My Team
1 | [NAME] | Mauer, | MIN |  |  | C
2 | Buster | Posey, | SF |  |  | 1B
3 | [NAME] | McCann, | ATL |  |  | 2B
4 | Victor | Martinez, | DET |  |  | 3B
5 | Bengie | Molina |  |  |  | SS
6 | [NAME] | Santana, | CLE |  |  | OF
7 | Miguel | Montero, | AZ |  |  | OF
8 | [NAME] | Lopez, | HOU |  |  | OF
9 | Geovany | Soto, | CHI-N |  |  | Util
10 | Kurt | Suzuki, | OAK |  |  | Util
11 | [NAME] | Napoli, | TEX |  |  | BN
12 | [NAME] | Wieters, | BAL |  |  | BN
13 | Jorge | Posada, | NY-A |  |  | BN
14 | [NAME] | Pierzynski, | CHI-A |  |  | BN
15 | [NAME] | Iannetta, | COL |  |  | SP
16 | [NAME] | [NAME], | FLA |  |  | SP
17 | [NAME] | Jaso, | TB |  |  | SP
18 | [NAME] | [NAME], | PIT |  |  | SP
19 | Miguel | Olivo, | SEA |  |  | RP
20 | Yadier | Molina, | STL |  |  | RP
21 | [NAME] | Ruiz, | PHI |  |  | P
22 | [NAME] | Montero, | NY-A
23 | [NAME] | [NAME], | DET
24 | [NAME] | Rodriguez, | WAS
25 | [NAME] | Martin, | NY-A
26 | J.P. | Arencibia, | TOR
27 | Ramon | Hernandez, | CIN
28 | [NAME] | Lucroy, | MIL
29 | Wilson | Ramos, | WAS
30 | [NAME] | Kendall, | KC
31 | [NAME] | Thole, | NY-N
32 | Nick | Hundley, | SD
33 | Kelly | Shoppach, | TB
34 | [NAME] | [NAME], | HOU
35 | [NAME] | Hanigan, | CIN
36 | Ronny | Paulino, | NY-N
37 | Yorvit | Torrealba, | TEX
38 | Tyler | Flowers, | CHI-A
39 | Ramon | [NAME], | CHI-A
40 | [NAME] | Teagarden, | TEX
41 | Rod | Barajas, | LA
42 | Hank | Conger, | ANA
43 | Francisco | Cervelli, | NY-A
44 | J. | Saltalamacchia, | BOS
45 | [NAME] | Snyder, | PIT
46 | [NAME] | Varitek, | BOS
47 | Adam | Moore, | SEA
48 | [NAME] | Mesoraco, | CIN
49 | Travis | d'Arnaud, | TOR
50 | Wilin | Rosario, | COL
Spreadsheet: 13ae0926-5ad9-4f65-98b4-23dab1e60afa
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6202.0 Labour Force, Australia
 | Table 20. Aggregate monthly hours worked by State - Trend and Seasonally adjusted
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Trend | A3591553W | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Trend | A3591554X | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Trend | A3591555A | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Trend | A3591556C | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Trend | A3591557F | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Trend | A3591558J | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NORTHERN TERRITORY ; |  |  | Trend | A3591559K | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  AUSTRALIAN CAPITAL TERRITORY ; |  |  | Trend | A3591560V | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  NEW SOUTH WALES ; |  |  | Seasonally Adjusted | A3591544V | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  VICTORIA ; |  |  | Seasonally Adjusted | A3591545W | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  [NAME] ; |  |  | Seasonally Adjusted | A3591546X | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  SOUTH AUSTRALIA ; |  |  | Seasonally Adjusted | A3591547A | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  WESTERN AUSTRALIA ; |  |  | Seasonally Adjusted | A3591548C | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
Aggregate Monthly Hours Worked ;  TASMANIA ; |  |  | Seasonally Adjusted | A3591549F | 1978-07-01 00:00:00 | 2011-05-01 00:00:00 | 395 | 000 Hours | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 267992d1380337544-dropdown-list-within-dropdown-list-cascading-dropdown-lookups-database
Sheet: Sheet1

Industry: | Firm Name: | Contact Numbers | Industry | Company - Interior Design | Company - Architecture | website | Address | Contact Numbers | Contact Names | Notes | Street | City | Postal Code
Architecture | THE ANGEL GROUP |  | InteriorDesign | THE ANGEL GROUP | CAMROST FELCORP. | www.angel-developments.com |  | [PHONE]
 |  |  | Architecture | ASPEN RIDGE HOMES | CANDEREL STONERIDGE EQUITY GROUP | www.aspenridgehomes.com |  | [PHONE] |  |  | 29 Floral Parkway | Toronto
 |  |  |  | ALIT DEVELOPMENTS | CD CAPITAL DEVELOPMENT | www.alit.ca |  | [PHONE] |  |  | 4116 Bathurst St. | Toronto
 |  |  |  | BAZIS INC DEVELOPMENTS | CENTRECOURT DEVELOPMENTS | www.bazis.ca |  | [PHONE] |  |  | 30 [NAME] | Vaughn
 |  |  |  | BLUESCAPE CONSTRUCTION MANAGEMENT INC. | CITYSCAPE DEVELOPMENT CORP. | http://www.bluescape.ca/ |  | [PHONE] |  |  | 468 Queen St. BOX 12 Suite 212 | Toronto | M5A 1T7
 |  |  |  | CADILLAC FAIRVIEW CORP. LTD | CITYZEN DEVELOPMENT GROUP | www.cadillacfairview.com |  | [PHONE] |  |  | 20 Queen St. W. 5th Floor | Toronto | M5H 3R4
 |  |  |  |  | CONCERT PROPERTIES | http://camrost.com/ |  | [PHONE] |  |  | 250 Davisville Ave. Suite 401 | Toronto | M4S 1H2
 |  |  |  |  | CONCORD | http://canderelresidential.com/ |  | [PHONE] |  |  | 717 Bay St. | Toronto
 |  |  |  |  | CONTEXT | www.cdcp.com |  | [PHONE] |  |  | 45 St. Clair W. Unit 1202 | Toronto
 |  |  |  |  |  | http://www.centrecourtdevelopments.com/ |  | [PHONE] |  |  | 208 Adelaide St. W. Unit 300 | Toronto
 |  |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  | http://cityzen.typepad.com/ |  | [PHONE] |  |  | 56 Esplanade Suite 301 | Toronto
 |  |  |  |  |  | www.concertproperties.com |  | [PHONE] |  |  | 55 University Avenue, Suite 1601, PO Box 66 | Toronto
 |  |  |  |  |  |  |  | [PHONE]
 |  |  |  |  |  | www.context.ca |  | [PHONE] |  |  | 229 Yonge St. Suite 500 | Toronto
Spreadsheet: df853c50-84c6-453f-a0a9-f35651a92dc4
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
FOGT | Test | FOGT | [NAME], IgE | [NAME], 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
FOGT | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FOGT | Result | FOGT | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6726-4
Spreadsheet: 745702d1630126611-3-unique-random-lists-3-random-players-final-
Sheet: working

 |  | https://www.excelforum.com/excel-formulas-and-functions/1355682-3-unique-random-lists.html
Explanation: Swap postion
Player | Match-1 | Match-2 | Match-3
1 | swap A | Swap A | Swap A
2 | swap A | swap B | swap B
3 | swap B | Swap A | Swap C
4 | swap B | swap B | Swap D
5 | swap C | Swap C | Swap A
6 | swap C | Swap D | swap B
7 | swap D | Swap C | Swap C
8 | swap D | Swap D | Swap D
Spreadsheet: 80400d1280594865-time-sheet-testworkbook1
Sheet: Sheet1

Date / Time In | Date / Time Out | Total Hours | 8 Hours | 12 Hours | Over 12 | Total
2010-07-30 14:00:00 | 2010-07-31 01:00:00 | 10.99999999988358 | 100 | 62.49999999636202 |  | 162.499999996362
2010-07-31 06:30:00 | 2010-07-31 16:30:00 | 9.999999999941792 | 100 | 31.24999999818101 |  | 131.249999998181
2010-08-01 14:00:00 | 2010-08-02 06:00:00 | 15.99999999994179 | 100 | 218.749999998181 |  | #N/A
Spreadsheet: 712516d1610274699-looking-for-support-to-display-corresponding-values-based-on-a-specific-cell-value-worksheet
Sheet: Sheet3

VEHICLE DETAILS |  |  |  |  |  |  | EMPLOYEE DETAILS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee | Advance | Diesel
Sl# | Month | Date | Description | Amount | Remarks |  | Sl# | Month | Date | Description | Amount |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vehicle | Govt.fee | Fines
1 |  | 2020-01-01 00:00:00 | Petrol | 500 | Car |  | 1 |  | 2020-01-01 00:00:00 | Salary | 8500 |  |  | Head | Vehicle |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insurance | Govt.fee
 |  | 2020-01-15 00:00:00 | Diesel | 1200 | Van |  |  |  | 2020-02-02 00:00:00 | Govt.fee | 8500 |  |  | Description | Petrol |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medical | Maintenance
 |  | 2020-01-22 00:00:00 | Spares | 600 | Car |  |  |  | 2020-02-15 00:00:00 | Govt.fee | 250 |  |  | [NAME] in Detail |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miscellaneous | Miscellaneous
 |  | 2020-01-23 00:00:00 | Service | 6200 | Car |  |  |  | 2020-02-17 00:00:00 | Govt.fee | 8500 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total |  |  |  |  | Salary | Petrol
 |  | 2020-02-02 00:00:00 | Govt.fee | 250 | Van |  |  |  | 2020-03-21 00:00:00 | Insurance | 1200 |  |  | Amount Spent |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Service
 |  | 2020-02-11 00:00:00 | Diesel | 1500 | Bus |  |  |  | 2020-04-01 00:00:00 | Salary | 8500 |  |  | Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Spares
 |  | 2020-02-11 00:00:00 | Diesel | 1800 | Van |  |  |  | 2020-04-10 00:00:00 | Govt.fee | 680 |  |  | Remarks
 |  | 2020-02-13 00:00:00 | Diesel | 420 | Two Wheeler |  |  |  | 2020-04-24 00:00:00 | Medical | 530
 |  | 2020-02-16 00:00:00 | Service | 4200 | Van |  |  |  | 2020-05-03 00:00:00 | Salary | 9500
 |  | 2020-02-19 00:00:00 | Petrol | 650 | Two Wheeler |  |  |  | 2020-05-11 00:00:00 | Medical | 726
 |  | 2020-03-06 00:00:00 | Diesel | 2500 | Van |  |  |  | 2020-06-01 00:00:00 | Salary | 9500
 |  | 2020-03-10 00:00:00 | Spares | 120 | Two Wheeler |  |  |  | 2020-06-08 00:00:00 | Insurance | 1200
 |  | 2020-03-14 00:00:00 | Service | 1300 | Car |  |  |  | 2020-06-15 00:00:00 | Miscellaneous | 253
 |  | 2020-04-02 00:00:00 | Petrol | 400 | Car |  |  |  | 2020-07-01 00:00:00 | Salary | 9500
 |  | 2020-04-04 00:00:00 | Petrol | 800 | Car |  |  |  | 2020-07-09 00:00:00 | Medical | 675
 |  | 2020-04-13 00:00:00 | Diesel | 1800 | Bus |  |  |  | 2020-07-25 00:00:00 | Advance | 3500
 |  | 2020-04-16 00:00:00 | Diesel | 1800 | Van |  |  |  | 2020-07-31 00:00:00 | Insurance | 1150
 |  | 2020-03-21 00:00:00 | Spares | 60 | Two Wheeler |  |  |  | 2020-08-01 00:00:00 | Salary | 9500
 |  | 2020-05-18 00:00:00 | Service | 1000 | Two Wheeler |  |  |  | 2020-08-06 00:00:00 | Govt.fee | 680
 |  | 2020-05-31 00:00:00 | Petrol | 800 | Car |  |  |  | 2020-08-20 00:00:00 | Advance | 1500
 |  | 2020-06-01 00:00:00 | Diesel | 2300 | Bus
 |  | 2020-06-20 00:00:00 | Spares | 800 | Bus
 |  | 2020-06-25 00:00:00 | Service | 600 | Two Wheeler
Spreadsheet: a9c1a54f-c7c6-4e5f-92e9-ec2d4dd18435
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
SFLA | Test | SFLA | Influenza Virus A Antibodies, IgG and IgM (Separate Determinations), Serum | Influenza Virus A Ab, IgG, IgM, S | Immunofluorescence | Serum Gel Tube: SGT |  |  | 0.25 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.25 mL Additional Information:  1. Incidence of influenza virus infections is seasonal in the United States and usually occurs only from November to March. 2. Indicate influenza virus A | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 | Monday through Friday; 9 a.m. | 1 day | 3 days | 2 | 86710 |  |  |  |  | Rochester
SFLA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
SFLA | Result | 5731 | Influenza Virus A Ab, IgG | Influenza Virus A Ab, IgG | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43837-4 | Influenza virus A Ab.IgG:ACnc:Pt:Ser:Ord:
SFLA | Result | 5732 | Influenza Virus A Ab, IgM | Influenza Virus A Ab, IgM | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43838-2 | Influenza virus A Ab.IgM:ACnc:Pt:Ser:Ord:
Spreadsheet: 5c0093de-da30-44d7-94ce-59b4cc68b67c
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
GAL3 | Test | GAL3 | Galectin-3, Serum | Galectin-3, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum, [NAME] |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL | 0.2 mL | Hemolysis	Mild reject; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | < 18 years: Not established > or =18 years: < or =22.1 ng/mL | Wednesday, Saturday; 9 a.m | 1 day | 4 days | 1 | 82777 |  |  |  |  | Rochester
GAL3 | [NAME] | SRED | Serum Red |  |  |  | Frozen | 365 days
GAL3 | Result | 86202 | Galectin-3, S | Galectin-3, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 62419-7 | Galectin 3:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 849585d1700018542-dependent-drop-down-lists-containing-unique-values-book3-eba
Sheet: Sheet2

20698 | 20699 | 20703 |  |  |  |  |  |  |  | 20698 | 20699 | 20703
2 | 21 | 18
4 | 21 | 18
11 | 21 | 17
8 | 21 | 17 |  |  |  | 17
3 | 21 | 18
4 | 21 | 17
3 | 21 | 18
14 | 21 | 17
6 | 21 | 18
3 | 21 | 17
9 | 21 | 17
4 | 21 | 18
9 | 21 | 18
9 |  | 18
 |  | 17
 |  | 18
 |  | 17
 |  | 18
 |  | 18
 |  | 18
 |  | 18
 |  | 17
 |  | 17
 |  | 18
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Aquaholic

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-03-10 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-03-10 00:00:00
Spreadsheet: 57643d1257864726-index-matching-book1
Sheet: Sheet1

AFC Seeds
1
2
3
4
5
6
NFC Seeds
1
2
3
4
5
6
 |  |  |  |  |  | I'm trying to look up cell E19 -E22
NFC |  |  | AFC |  |  | and give me the team with the best |  |  | AFC
Eagles | 5-3 |  | Colts | 8-0 |  | record I cell J19. I can figure it
Redskins | 2-6 |  | [NAME] | 4-4 |  | out from there.
Giants | 5-4 |  | Texans | 5-4
Cowboys | 6-2 |  | Titans | 2-6
Packers | 5-3 |  | Bengals | 6-2
Vikings | 7-1 |  | Steelers | 6-2
Lions | 1-7 |  | [NAME] | 1-7
Bears | 4-4 |  | Ravens | 4-4
Cardinals | 5-3 |  | Patriots | 6-2
49ers | 3-5 |  | Bills | 3-5
[NAME] | 1-7 |  | Jets | 4-4
Seahawks | 3-5 |  | [NAME] | 3-5
Panthers | 3-5 |  | Raiders | 2-6
Saints | 8-0 |  | Broncos | 6-2
Falcons | 5-3 |  | Chargers | 5-3
Buccaneers | 0-8 |  | Chiefs | 1-7
Spreadsheet: 874731d1721262659-vlookup-without-exact-character-nates808-book1-tms
Sheet: Sheet3

 |  | https://www.ablebits.com/office-addins-blog/excel-find-replace-multiple-values/#:~:text=The%20easiest%20way%20to%20find,value%20with%20a%20new%20one.
List of replacements |  | =LAMBDA(text,old,new, IF(old<>"", [NAME], old, new), OFFSET(old, 1, 0), OFFSET(new, 1, 0)), text))
Street |  | =LAMBDA(text,old_chars,new_chars,  IF(old_chars<>"", ReplaceChars(SUBSTITUTE(text, LEFT(old_chars), LEFT(new_chars)), RIGHT(old_chars, LEN(old_chars)-1), RIGHT(new_chars, LEN(new_chars)-1)), text))
street
Starting from |  | Note: when calling the function, you only provide the first entry in the list, not the whole range.
Starting
St.
Road
Rd.
Place
place
Pl.
Old
Middle of
Loop
loop
Hwy
Ending of
Ending
End of
Drive
drive
Dr.
Circle
circle
Boulevard
boulevard
Beginning of
Beginning
Avenue
avenue
Ave.
Ave
Spreadsheet: 171504d1343755014-sorting-a-list-of-references-that-dynamically-change-example2
Sheet: MMI

 |  | WO# | Item | [NAME] | Qty Open | Order Created | Ship Date
Spreadsheet: 6365645d-b3d0-4ba2-a658-c7c814c49b90
Sheet: Operating

OPERATING/PROGRAMMATIC
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Housing Conditions Survey - UMKC CEI
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  | x | No |  |  | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax)
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY 2008-09 |  |  | FY 2009-10
 | General Fund |  |  |  |  |  |  | 0
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ |  |  | $
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | x | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY 2008-09 |  |  | FY 2009-10
 | General Fund |  |  |  |  |  |  | 100000
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ |  |  | $
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | It is a one-year contract.  Although it is hoped to become an annual contract, neither the ordinance, nor the contract commits additional future funding.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 7236b438-3b98-4877-9ea7-e2d4a982d450
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
CAVP | Test | CAVP | California Virus (La Crosse) IgG and IgM, Serum | Calif Virus (LaCrosse)IgG and IgM,S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | IgG: <1:10 IgM: <1:10 | Monday through Friday; 9 a.m. | Same day/1 day | 4 days |  | Profile |  |  |  |  | Rochester
CAVP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
CAVP | Result | 8764 | Calif (LaCrosse) [NAME], IgG, S | Calif (LaCrosse) [NAME], IgG, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29815-8
CAVP | Result | 87280 | Calif (LaCrosse) [NAME], IgM, S | Calif (LaCrosse) [NAME], IgM, S | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29853-9
Spreadsheet: 70670d1271372652-pivot-table-issue-column-will-not-copy-down-due-to-common-value-example
Sheet: Sheet1

Work Center | [NAME] | Start Date | Finish Date | Qty | Department | Color | Size
85 | X | 2010-04-15 00:00:00 | 2010-04-15 00:00:00 | 50 | Apple | Red | 1
85 | Y | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | 100 | [NAME] | Yellow | 2
85 | Z | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | 100 | Pear | Green | 3
85 | A | 2010-04-17 00:00:00 | 2010-04-17 00:00:00 | 25 | Peach | Orange | 4
85 | B | 2010-04-17 00:00:00 | 2010-04-18 00:00:00 | 50 | Tomato | Red | 8
 | CURRENT
 | Count of Color
 | Work Center | Start Date | Finish Date | [NAME] | Qty | Total
 | 85 | 2010-04-15 00:00:00 | 2010-04-15 00:00:00 | X | 50 | 1
 |  |  | 2010-04-16 00:00:00 | Y | 100 | 1
 |  | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | Z | 100 | 1
 |  | 2010-04-17 00:00:00 | 2010-04-17 00:00:00 | A | 25 | 1
 |  |  | 2010-04-18 00:00:00 | B | 50 | 1
 | Future
 | Work Center | Start Date | Finish Date | [NAME] | Qty | Total
 | 85 | 2010-04-15 00:00:00 | 2010-04-15 00:00:00 | X | 50 | 1
 | 85 | 2010-04-15 00:00:00 | 2010-04-16 00:00:00 | Y | 100 | 1
 | 85 | 2010-04-16 00:00:00 | 2010-04-17 00:00:00 | Z | 100 | 1
 | 85 | 2010-04-17 00:00:00 | 2010-04-17 00:00:00 | A | 25 | 1
 | 85 | 2010-04-15 00:00:00 | 2010-04-18 00:00:00 | B | 50 | 1
Spreadsheet: 19319bda-4255-495b-a001-f01ea985a9d0
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2011/12 | 2425.347 | 19740 | 149.325 | 22314.672 |  | 18310.522 | 4870 | 13440.522 | 1464.15 | 19774.672 | 2540
2012/131 | 2540 | 19820 | 195.645 | 22555.645 |  | 18686.428 | 4617 | 14069.428 | 2164.217 | 20850.645 | 1705
2013/142 | 1705 | 19435 | 250 | 21390 |  | 18550 | 5200 | 13350 | 1150 | 19700 | 1690
1 Estimated.  2 Forecast.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2013-12-12 09:37:26.760000
Spreadsheet: james_steffes__12778__ISO Schedule
Sheet: Sheet1

ISO Funding Activity and Requirements
 |  |  |  |  |  |  |  | Next
 |  |  |  | Last |  | Funded |  | Funding |  | Value of
ISO |  | Amount |  | Funding |  | Through |  | Decision |  | Book
California |  | 2838000 |  | 2001-12-03 00:00:00 |  | 2001-12-06 00:00:00 |  | 2001-12-05 00:00:00 |  | 250000000
ERCOT |  | 493640 |  | 2001-12-03 00:00:00 |  | 2001-12-14 00:00:00 |  | 2001-12-13 00:00:00 |  | 117000000
New York |  | 680000 |  | 2001-11-30 00:00:00 |  | 2001-12-09 00:00:00 |  | 2001-12-06 00:00:00 |  | 75000000