tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0df290f8-9aa0-43e3-a53e-a47950d9f639
Sheet: A

Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both spring and J-term.
 | AOK Designation | CAR Designation | Comment
American Studies
AMST 309 | Arts & Literature-Literature |  | cross-listed with COMM 309
AMST 350 | Arts & Literature-Literature
AMST 351 | Arts & Literature-Literature
AMST 355 | Arts & Literature-Arts
AMST 356 | Arts & Literature-Literature
AMST 357 | Arts & Literature-Literature
AMST 358 | Arts & Literature-Literature
Arabic
ARAB 211-212 | Foreign Language
Archaeology
ARCH 221 | Natural & Math Sciences w/Lab | Experiential-Travel* | * when course travels-the course does not travel for all offerings
ARCH 450 |  | Experiential-Field Study; Capstone | cross-listed with CLAS 450
ARCH 495 |  | Capstone
[NAME]
ARTH 201 | Arts & Literature-Arts
ARTH 202 | Arts & Literature-Arts
ARTH 210 | Arts & Literature-Arts |  | cross-listed with CLAS 210
 | OR [NAME] (as HIST 101) | Non-Western
ARTH 211 | Arts & Literature-Arts | Non-Western | cross-listed with CLAS 211
ARTH 212 | Arts & Literature-Arts |  | cross-listed with CLAS 212
ARTH 213 | Arts & Literature-Arts |  | cross-listed with CLAS 213
ARTH 214 | Arts & Literature-Arts |  | cross-listed with CLAS 214
ARTH 215 | Arts & Literature-Arts
ARTH 216 | Arts & Literature-Arts
ARTH 217 | Arts & Literature-Arts |  | cross-listed with CLAS 217
ARTH 218 | Arts & Literature-Arts | Experiential-Travel* | cross-listed with CLAS 218;* when course travels-the course does not travel for all offerings
ARTH 219 | Arts & Literature-Arts
ARTH 222 | Arts & Literature-Arts | Experiential-Travel
ARTH 223 | Arts & Literature-Arts
ARTH 224 | Arts & Literature-Arts
ARTH 225 | Arts & Literature-Arts
ARTH 226 | Arts & Literature-Arts
ARTH 227 | Arts & Literature-Arts | Non-Western
ARTH 228 | Arts & Literature-Arts | Non-Western
ARTH 235 | Arts & Literature-Arts | Non-Western
ARTH 240 | Arts & Literature-Arts
ARTH 305 | Arts & Literature-Arts
ARTH 381 |  | Experiential-Research
ARTH 381 |  | Non-Western | FALL 2012(Coptic Art in Egypt)
ARTH 382 |  | Experiential-Research
ARTH 422 |  | Experiential-Research; Capstone
ARTH 450 |  | Capstone
Arts Management
AMGT 441 |  | Experiential-Internship; Capstone
Astronomy
ASTR 101 | Natural & Mathematical Sciences-Nat Sci w Lab
ASTR 231 | Natural & Mathematical Sciences-Nat Sci w/out Lab
ASTR 232 | Natural & Mathematical Sciences-Nat Sci w/out Lab
Asian Studies
ASTU 230 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 230
ASTU 231 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 231
ASTU 232 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 232
ASTU 233 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 233
ASTU 290 |  | Non-Western | cross-listed with HIST 290
ASTU 292 | Arts & Literature-Arts | Non-Western | cross-listed with FILM 292
ASTU 390 |  | Non-Western
ASTU 401 |  | Capstone
ASTU 450 |  | Experiential-Internship
ASTU 481 |  | Experiential-Research
ASTU 482 |  | Experiential-Research
Spreadsheet: joe_parks__14512__TEXAS_P&L_JUN01
Sheet: NYMEX_juL1

Sells |  |  |  | Buys
106 | 3.81 |  |  | 31 | 3.76
46.5 | 3.79 |  |  | 31 | 3.76
23.25 | 3.925 |  |  | 38.75 | 3.705
31 | 4.065 |  |  | 15.5 | 3.695
15.5 | 4.05 |  |  | 38.75 | 3.905
31 | 3.98 |  |  | 31 | 3.81
31 | 3.985 |  |  | 31 | 3.895
31 | 3.86 |  |  | 23.25 | 3.925
31 | 3.95 |  |  | 23.25 | 3.82
 |  |  |  |  |  |  |  | *
 |  |  |  |  |  |  |  |  |  | <- Realized PL
 |  |  |  |  |  |  |  |  |  | <- MTM PL w/o Real PL |  | preserve realized
 |  |  |  |  |  |  |  |  |  | <- MTM PL with Real PL |  | breakeven
 |  | <- Current Nymex
 |  | <- Price Overide |  |  |  |  |  |  |  | <- Total Pl
Spreadsheet: 037d7608-4e9c-4f44-82eb-d1de906460b6
Sheet: Sheet1

NAME | NET EXPENSE RATIO | GROSS EXPENSE RATIO | PERFORMANCE | CUMULATIVE QTD | CUMULATIVE YTD | ANNUALIZED 1YR | ANNUALIZED 3YR | ANNUALIZED 5YR | ANNUALIZED 10YR | SINCE INCEPTION | INCEPTION DATE | PERF AS OF
International/Global
SSgA International Stock Selection Fund - Class A (SSILX)
Fund at NAV | 1.2% | 1.37% | Fund at NAV |  |  |  |  |  |  |  | [NAME]
Fund at POP | 1.2% | 1.37% | Fund at POP |  |  |  |  |  |  |  | [NAME]
[NAME] Index |  |  | [NAME] |  |  |  |  |  |  |  | 03/01/1995
SSgA Emerging Markets Fund - Class A (SSELX)
Fund at NAV | 1.37% | 1.37% | Fund at NAV |  |  |  |  |  |  |  | 03/01/1994
Fund at POP | 1.37% | 1.37% | Fund at POP |  |  |  |  |  |  |  | 03/01/1994
MSCI Emerging Markets Index |  |  | [NAME] |  |  |  |  |  |  |  | 03/01/1994
Fixed Income
SSgA High Yield Bond Fund - Class A (SSHGX)
Fund at NAV | 0.96% | 0.97% | Fund at NAV |  |  |  |  |  |  |  | 05/04/1998
Fund at POP | 0.96% | 0.97% | Fund at POP |  |  |  |  |  |  |  | 05/04/1998
Barclays U.S. High-Yield 2% Issuer Capped Bond Index |  |  | [NAME] |  |  |  |  |  |  |  | 01/01/1993
US Equity
SSgA Enhanced Small Cap Fund - Class A (SSESX)
Fund at NAV | 1.09% | 1.69% | Fund at NAV |  |  |  |  |  |  |  | 03/22/2005
Fund at POP | 1.09% | 1.69% | Fund at POP |  |  |  |  |  |  |  | 03/22/2005
Russell 2000 Index |  |  | [NAME] |  |  |  |  |  |  |  | 03/21/2005
SSgA Dynamic Small Cap Fund - Class A (SSSDX)
Fund at NAV | 1.32% | 2.36% | Fund at NAV |  |  |  |  |  |  |  | [NAME]
Fund at POP | 1.32% | 2.36% | Fund at POP |  |  |  |  |  |  |  | [NAME]
Russell 2000 Index |  |  | [NAME] |  |  |  |  |  |  |  | 01/01/2000
SSgA Clarion Real Estate Fund - Class A (SSRVX)
Fund at NAV | 1.2% | 1.59% | Fund at NAV |  |  |  |  |  |  |  | 04/29/1998
Fund at POP | 1.2% | 1.59% | Fund at POP |  |  |  |  |  |  |  | 04/29/1998
Dow Jones U.S. Select REIT Index |  |  | [NAME] |  |  |  |  |  |  |  | 04/30/1998
This material expires 20 days after the current quarter end
This analysis or any portion thereof may not be revised or changed in any way, reprinted, sold or redistributed without the written consent of SSgA.
Portfolio holdings, allocations and weightings are as of the date indicated, are subject to change and should not be considered a recommendation to buy individual securities. For most recent information visit www.ssgafunds.com.
Distributor: State Street Global Markets, LLC, member FINRA(http://www.finra.org), SIPC(http://www.sipc.org), a wholly owned subsidiary of State Street Corporation. References to State Street may include State Street Corporation and its affiliates. Certain State Street affiliates provide services and receive fees from the SSgA Funds.
Before investing, consider the funds’ investment objectives, risks, charges and expenses. To obtain a prospectus or summary prospectus, this contains this and other information, call [PHONE] or visit www.ssgafunds.com  Read it carefully.  IBG-6579
Spreadsheet: 79629d1279831333-sum-if-following-criteria-match-if-and-sum-solution
Sheet: Sheet1

Values | Rating |  |  |  | Ratings | Values
20178502.13426465 | N R |  |  |  | AAA | 10089251.06713232
10089251.06713232 | A+ |  |  |  | AA , AA- , AA+ | 25044625.53356616
15521924.71866512 | BBB+ |  |  |  | A- , A+ , A , A3 | 237743500.1940241
10089251.06713232 | A |  |  |  | BBB , BBB+ , BBB-  , Baa1 | 271146682.1885914
20000000 | A |  |  |  | BB+ /*- , BB+ | 15000000
20000000 | BBB |  |  |  | N R | 244729142.4136593
7760962.359332558 | N R
10089251.06713232 | BBB+ |  |  |  | sum | 803753201.3969733
5044625.533566162 | N R
7760962.359332558 | A+
5044625.533566162 | N R
10000000 | BBB
10089251.06713232 | BBB
10089251.06713232 | A3
25000000 | N R
15000000 | N R
20178502.13426465 | A+
15000000 | N R
25000000 | N R
10000000 | BBB
25000000 | BBB
25000000 | Baa1
25000000 | Baa1
20178502.13426465 | Baa1
20178502.13426465 | BBB
10089251.06713232 | Baa1
5000000 | BB+ /*-
5000000 | BB+ /*-
5000000 | N R
5000000 | AA-
5000000 | AA-
7760962.359332558 | N R
5000000 | A+
5000000 | BBB-
5000000 | A
5000000 | BB+
5000000 | BBB-
10000000 | A+
15000000 | N R
10000000 | A-
10000000 | A-
5000000 | A
10000000 | N R
19402405.89833139 | A-
10000000 | BBB-
7760962.359332558 | N R
10000000 | N R
10000000 | BBB-
10000000 | N R
10000000 | A-
10000000 | BBB-
10000000 | A
5044625.533566162 | AA+
10000000 | A
10089251.06713232 | N R
10089251.06713232 | AAA
25000000 | A+
5044625.533566162 | A+
10000000 | AA+
10089251.06713232 | N R
10089251.06713232 | A+
25000000 | A+
20000000 | N R
20000000 | N R
10000000 | BBB-
20000000 | BBB
1000000 | N R
803753201.3969733 | Sum
Spreadsheet: 68534d1269046676-excel-2007-manipulating-data-manipulating-data
Sheet: Sheet1

user1 | group1 | no. Users =
user2 | group2 | no. Groups =
user3 | [NAME]
user4 | group4 | lines
user5 | group5
[NAME] | [NAME]
user7 | group7
user8 | [NAME]
[NAME] | group9
user10 | [NAME]
user11 | group11
user12
user13
user14
user15
user16
user17
user18
user19
user20
Spreadsheet: 82107d1282146385-macro-to-move-rows-to-different-sheet-test
Sheet: Sheet1

Invoice | Salesman | Total | Customer
1 | [NAME] | 10 | Smith
2 | [NAME] | 5 | Barney
3 | [NAME] | 20 | [NAME]
4 | [NAME] | 30 | Master
5 | Nick | 40 | Bates
6 | [NAME] | 10 | [NAME]
Spreadsheet: 13269cce-2187-4da0-9f2b-d55626a3a471
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40155413 | 2014-02-21 01:35:01 | ALLIES | 1 | 10 | 8 | 1376400 | ytremart | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40293667 | 2014-03-01 08:05:02 | AXIS | 1 | 6 | 4 | 1524161 | player1524161 | 7364 | mediterranean | 1941-11-25 | 1941-11-25 | Dug in at [NAME] | Retranchés à [NAME]
40293984 | 2014-03-01 08:36:29 | AXIS | 0 | 5 | 10 | 780030 | keithdone | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40294232 | 2014-03-01 09:03:43 | ALLIES | 0 | 3 | 10 | 780030 | keithdone | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40294506 | 2014-03-01 09:44:51 | AXIS | 1 | 7 | 6 | 367955 | viper0807 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
40294820 | 2014-03-01 10:04:03 | ALLIES | 0 | 2 | 7 | 367955 | viper0807 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: 09a9aec3-6eff-4f72-aa54-76145fc45f7f
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 | Unnamed: 12 | Unnamed: 13
 | EXHIBIT B - CM@R GMP COST MODEL
 | Project Name: |  |  |  | Date:
 | Project Location:
 | CIP Project No:
 | Contract No:
 |  |  |  |  |  |  | Alternates
 | A.   Direct Costs: |  |  |  | Amount
 | A1   Labor and Burden |  |  |  | 0
 | A2   Equipment (Owned and Rented) |  |  |  | 0
 | A3   Material, Supplies, and Fees |  |  |  | 0
 | A4   Subcontracts |  |  |  | 0
 | A5   Allowances & Contingencies |  |  |  | 0
 | A. - Total of Direct Costs: |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | B.   General Conditions: |  | 0 |  | 0
 | Subtotal 1 (Cost Of The Work) |  |  |  | 0
 | C.   Contractor's Fee: |  | 0 |  | 0
 | Subtotal 2 |  |  |  | 0
 | D.   Bonds and Insurance Allowances:
 | D1   Bonds |  | 0 |  | 0
 | D2   Insurance |  | 0 |  | 0
 | D. - Bonds & Insurance Allowance Total: |  |  |  | 0
 | Subtotal 3 |  | 0 |  | 0
 | E.  Sales Tax
 | E1   Sales Tax |  | 0.0607 |  | 0
 | E2   Tax Credits |  |  |  | 0
 | E. - Sales Tax Total: |  |  |  | 0
 | F.  GMP Proposal: |  |  |  | 0
 | G.  Preconstruction Services: |  |  |  | 0
 | H.  Previous GMP's: |  |  |  | 0 |  | 0 | 0 | 0 | 0 | 0
 | I.  Total Project Cost |  |  |  | 0
 | NOTES:
 | 1.     Contractor to fill in highlighted areas only:
 | a.  Direct Costs (A) to be completed as the cost estimate is developed.
 | b.  Indirect Cost (B, C and D) percentages to be established during preconstruction phase negotiations.
 | 2.     [NAME] Used in Calculations:
 | Subtotal 1 = A + B
 | Contractor's Fee (C) = C Percentage x Subtotal 1
 | Subtotal 2 = C + Subtotal 1
 | Bond & Insurance Allowances = D Percentages x Subtotal 2
 | Subtotal 3 = D + Subtotal 2
 | Sales Tax (E1) = Subtotal 3 x 5.07%
 | GMP Proposal (F) = Subtotal 3 + E
 | Preconstruction Services (G) is [NAME]'s costs associated with that phase.
 | Previous GMP's (H) includes total cost of previous approved GMP's
 | Total Project Cost (I) = F + G + H
Spreadsheet: 782078d1653753819-unable-to-transfer-data-from-one-sheet-to-another-example
Sheet: Sheet1

product | date | turnover
A | 2022-05-12 00:00:00 | 22.5474829766537
A | 2022-05-11 00:00:00 | 21.3434152964248
A | 2022-05-10 00:00:00 | 18.96655909452317
A | 2022-05-09 00:00:00 | 22.00411644882023
A | 2022-05-06 00:00:00 | 27.16194309660344
B | 2022-05-12 00:00:00 | 20.77545702373316
B | 2022-05-11 00:00:00 | 20.43724239173395
B | 2022-05-10 00:00:00 | 24.90326270494036
B | 2022-05-09 00:00:00 | 21.88803655949078
B | 2022-05-06 00:00:00 | 21.19682254370452
C | 2022-05-12 00:00:00 | 25.01783668287245
C | 2022-05-11 00:00:00 | 26.55517868382404
C | 2022-05-10 00:00:00 | 34.94999261702023
C | 2022-05-09 00:00:00 | 38.74659033507324
C | 2022-05-06 00:00:00 | 25.69963932435811
D | 2022-05-12 00:00:00 | 17.4988825720447
D | 2022-05-11 00:00:00 | 22.99250148351945
D | 2022-05-10 00:00:00 | 20.6553869024333
D | 2022-05-09 00:00:00 | 34.89043445121951
D | 2022-05-06 00:00:00 | 19.74603740435663
E | 2022-05-12 00:00:00 | 30.04701337855662
E | 2022-05-11 00:00:00 | 24.25001484648732
E | 2022-05-10 00:00:00 | 26.7875939432904
E | 2022-05-09 00:00:00 | 30.32016956715752
E | 2022-05-06 00:00:00 | 29.88459752132783
Spreadsheet: 112405d1308566388-how-can-i-show-only-one-x-on-a-line-copy-of-business-diagnostics-for-excel-forum
Sheet: Sheet1

 |  |  | Completely dissatisfied | Dissatisfied | Very Poor | Poor | Ok | Neutral | Fair | Good | Fairly Good | Very Good | Excellent | Please add any comments |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completely dissatisfied |  |  |  |  | Neutral |  |  |  |  | Very Good
 |  |  | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -5 | -4 | -3 | -2 | -1 | 0 | 1 | 2 | 3 | 4 | 5
1 | Customer Service | Very Poor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2 | Value for money | Ok |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
3 | Marketing | Poor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
4 | Support |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
5 | Information |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
6 | Availabilty |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
7 | Finance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7
8 | Banking |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
9 | Property |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17
18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21
22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23
24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
Spreadsheet: cde96fc9-9318-46ea-b998-557548293855
Sheet: Sheet1

Summary of Market Prices for Pedigree Bulls from 2011 to 2013
Week Commencing 06/05/2013
Breed | Quality | €/Head
Aberdeen Angus | 1 | 3500
Aberdeen Angus | 2 | 2300
Aberdeen Angus | 3 | 1600
Aberdeen Angus | 4 | 1200
Aberdeen Angus | 5 | Beef value
Charolais | 1 | 5000
Charolais | 2 | 2950
Charolais | 3 | 2000
Charolais | 4 | 1500
Charolais | 5 | Beef value
[NAME] | 1 | 3400
[NAME] | 2 | 2250
[NAME] | 3 | 1600
[NAME] | 4 | 1200
[NAME] | 5 | Beef value
[NAME] | 1 | 4000
[NAME] | 2 | 2700
[NAME] | 3 | 2100
[NAME] | 4 | 1500
[NAME] | 5 | Beef value
Simmental | 1 | 5000
Simmental | 2 | 2700
Simmental | 3 | 1900
Simmental | 4 | 1400
Simmental | 5 | Beef value
Friesian | 1 | 4100
Friesian | 2 | 2600
Friesian | 3 | 1950
Friesian | 4 | Beef value
Friesian | 5 | Beef value
Note 1: The above price summaries are for bulls under 2 years of age.
When valuing older bulls a depreciation figure of approximately 20%
per year should be deducted from the value of the bull in the previous year
for each year greater than two years of age until beef value is reached
Note 2: Quality 1 bulls above refer to pedigree bulls that are suitable for elite pedigree
breeding while Quality 2 bulls are generally excellent quality bulls that are used for
pedigree breeding and for top class commercial use
Spreadsheet: 858380d1707098209-need-help-with-query-and-pivot-table-op-code-results-v1-fernturpin-
Sheet: Sheet2

Op Code | Induction |  |  |  |  |  |  |  | Op Code | Induction
Date Range | 2024-02-01 00:00:00 |  |  |  |  |  |  |  | Date | 2024-01-29 00:00:00
 |  | Part#1 | part#2 | part#3 | Part#4 | Part#5
Work Order # |  |  |  |  |  |  |  | Work Order # | Part#1 | Part#2 | Part#3 | Part#4 | Part#5 | Part#6 | Part#7 | Part#8 | Part#9 | Part#10 | Part#11
111512 |  | A64071 | 125487
111513 |  | A64071 | 125487
111514 |  | A64071
111515 |  | A64071
111516 |  | A64071
111517 |  | 125487
111518 |  | 125487
111519 |  | 125487
111520 |  | A64071 | 125487
111521 |  | A64071 | 125487
Spreadsheet: d89e0389-4460-4f8a-b3be-cd0271cb448d
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
FCPP | Test | FCPP | Chlamydia Pneumoniae PCR | Chlamydia Pneumonia PCR | DNA amplification by polymerase chain reaction (PCR) with gel-electrophoresis of PCR products. |  |  |  | 0.5 | mL | 0.5 mL serum, plasma, blood (pink top or purple top EDTA), fluids and other sources. Tissue with no fixative is also acceptable. Ship frozen. Note: Source required. | 0.5 mL | Hemolysis:	NA Thawing:	Cold reject; Warm reject Lipemia:	NA Icterus:	NA Other:	NA | TND - Target Not Detected (Negative) Positive - Virus Detected   This test employs PCR and agarose gel electrophoresis detection of a chlamydia pneumoniae-specific conserved genetic target. A positive result should be coupled with clinical indicators for diagnosis. A negative CHLPPCR result (TND) does not exclude chlamydia involvement in a disease process.   Test Performed by:	University of Colorado Hospital 			Clinical Laboratory 			12401 E 17th Ave 			Aurora, CO 80045 | Batched, varies | 1 - 7 days | 3 - 13 days | 1 | 87486 |  |  |  |  | University of Colorado Hospital Clinical Laboratory
FCPP | [NAME] | VARIES | Varies |  |  |  | Frozen | 180 days
FCPP | Order Question | Z2685 | Source |  | Plain Text
FCPP | Result | Z2685 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FCPP | Result | Z2686 | Chlamydia PCR | Chlamydia PCR | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 151129d1334789000-help-with-an-if-vlookup-formula-please-book1
Sheet: Sheet1

Group | Type | Item 1 | Item 2 |  |  | Item | Return
Group1 | Cost | 121212 | AAAA |  |  | AAAA | X
Group2 | Cost | 343434 | BBBB |  |  | BBBB | Y
Group3 | Cost | 565656 | CCCC |  |  | CCCC | Z
 | Expense | 787878 | DDDD |  |  | DDDD | A
I need a single cell formulae to do the below from the above example
If A5 had a value I'd like to return the corresponding value from C5
However:
If A5 was blank I'd like the formulae to lookup D5 (columns G and H) and return "A Expense" which is "Column H & Column B"
Note: The word I want returned will always be Expense. So value from H & "Expense" (if this simplifies / helps)
Spreadsheet: 811046d1672244747-help-with-returning-the-category-the-value-belongs-to-rather-than-the-value-itself-hd
Sheet: Sheet1

 |  | CC1 | CC2 | CC3 | CC4 | CC5
 | [NAME] |  | 3 |  |  |  |  | CC2
 | [NAME] |  |  | 4 |  |  | [NAME] | CC3
 | [NAME] |  | 2 |  |  |  | [NAME] | CC2
 | [NAME] |  |  |  | 5 |  | [NAME] | CC4
 | [NAME] | 1 |  |  |  |  | [NAME] | CC1
 |  |  |  |  |  |  |  | CC2
 |  |  |  |  |  |  | [NAME] | CC3
 |  |  |  |  |  |  | [NAME] | CC2
 |  |  |  |  |  |  | [NAME] | CC4
 |  |  |  |  |  |  | [NAME] | CC1
Spreadsheet: 220486d1363180098-extract-non-zero-value-data-sample
Sheet: MODEL HELEN

 |  | Model
 |  | Helen
 | Product Code | Unit Price
 | Door x 40 | 90
 | Door x 41 | 100
 | Door x 45 | 95
 | Door x 46 | 110
 | Door x 47 | 92
 | Door x 49 | 100
 | Door x 50 | 95
 | Door x 51 | 100
 | Door x 52 | 110
 | Door x 53 | 104
 | Door x 54 | 112
 | Door x 55 | 95
 | Door x 58 | 100
 | Door x 60 | 100
Spreadsheet: 53361d1253240726-calendar-and-buttons-3m-brookings
Sheet: PG USP

[NAME] USP
2845 Lbs./Tote
[NAME]
Lot # | CB244990409
Batch # | 999999-T
PO | USMMMFP906
Rel. | 10 | 2009-06-01 00:00:00
[NAME] USP
2845 Lbs./Tote
[NAME]
Lot # | CB244990409
Batch # | 999999-T
PO | USMMMFP906
Rel. | 10 | 2009-06-01 00:00:00
Spreadsheet: 698205d1601859716-return-sum-of-all-values-between-start-and-end-time-on-specific-day-appointment-impact-calculator-jayjack-
Sheet: Sheet1

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
Column | 2 | 3 | 4 | 5 | 6 | 7 | 8
00:00:00 | 0 | 5 | 3 | 7 | 7 | 2 | 5
01:00:00 | 0 | 3 | 0 | 4 | 2 | 0 | 3 |  | Day of Week (Start) | Tuesday
02:00:00 | 0 | 1 | 3 | 3 | 1 | 3 | 0 |  | Start Time | 08:00:00
03:00:00 | 0 | 2 | 4 | 4 | 2 | 1 | 0 |  | Day of Week (End | Friday
04:00:00 | 0 | 4 | 4 | 2 | 3 | 2 | 0 |  | End Time | 08:00:00
05:00:00 | 0 | 3 | 2 | 4 | 3 | 0 | 0
06:00:00 | 13 | 44 | 21 | 20 | 10 | 19 | 8 |  | No. of Calls
07:00:00 | 38 | 45 | 40 | 42 | 13 | 33 | 31
08:00:00 | 160 | 155 | 118 | 157 | 181 | 144 | 117
09:00:00 | 303 | 288 | 247 | 260 | 330 | 214 | 147
10:00:00 | 326 | 295 | 326 | 349 | 381 | 193 | 158
11:00:00 | 310 | 325 | 286 | 313 | 361 | 163 | 93
12:00:00 | 218 | 233 | 260 | 283 | 301 | 128 | 82
13:00:00 | 184 | 174 | 168 | 246 | 220 | 113 | 90
14:00:00 | 205 | 215 | 198 | 246 | 277 | 158 | 98
15:00:00 | 195 | 192 | 159 | 212 | 243 | 140 | 104
16:00:00 | 183 | 221 | 167 | 194 | 208 | 127 | 90
17:00:00 | 150 | 156 | 131 | 142 | 158 | 76 | 90
18:00:00 | 125 | 161 | 121 | 118 | 120 | 55 | 147
19:00:00 | 145 | 175 | 117 | 132 | 83 | 74 | 157
20:00:00 | 178 | 223 | 168 | 172 | 86 | 63 | 157
21:00:00 | 146 | 178 | 140 | 194 | 92 | 71 | 104
22:00:00 | 94 | 102 | 106 | 128 | 68 | 58 | 31
23:00:00 | 61 | 73 | 54 | 75 | 53 | 50 | 22
Spreadsheet: 65528d1266248789-help-with-vlookup-excel-forum
Sheet: DATA

sequence | budget_centre | exp_code | post_number | desc
00010 | ADRDS | 2IOP0 | 625496 | Vegtables
00020 | ADRDS | 2IOP0 | n/a | Estatee
00030 | ADRDS | 1PY08 | 3448344 | Broadlength
00040 | ADRDS | 1AC08 | 3455796 | Carvetobe
00050 | ADRDS | 71000 | 3825162 | Fam9ine
00060 | ADRDS | 72000 | 4629918 | [NAME]