tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b2d1ba6d-3340-41f3-af01-4d1ed72fde2a
Sheet: SEG1

 | ADVANCED MICRO DEVICES, INC.
 | SELECTED CORPORATE DATA
 | (Millions except headcount)
 |  |  | Quarter Ended |  |  |  |  |  |  |  |  |  | Year Ended
 |  |  |  | Dec. 25, |  |  | Sept. 25, |  |  | Dec. 26, |  |  |  | Dec. 25, |  |  | Dec. 26,
 | Segment and Category Information |  |  | 2010 |  |  | 2010 |  |  | 2009 |  |  |  | 2010 |  |  | 2009
 | [NAME] (1)
 |  | Net revenue |  | 1219 |  |  | 1226 |  |  | 1220 |  |  |  | 4817 |  |  | 4170
 |  | Operating income (loss) |  | 91 |  |  | 164 |  |  | 161 |  |  |  | 529 |  |  | 142
 | Graphics (2)
 |  | Net revenue |  | 424 |  |  | 390 |  |  | 421 |  |  |  | 1663 |  |  | 1167
 |  | Operating income (loss) |  | 68 |  |  | 1 |  |  | 50 |  |  |  | 149 |  |  | 35
 | All Other (3)
 |  | Net revenue |  | 6 |  |  | 2 |  |  | 5 |  |  |  | 14 |  |  | 66
 |  | Operating income (loss) |  | 254 |  |  | -37 |  |  | 1182 |  |  |  | 170 |  |  | 968
 | Subtotal (excludes Foundry segment and Intersegment Eliminations)
 |  | Net revenue |  | 1649 |  |  | 1618 |  |  | 1646 |  |  |  | 6494 |  |  | 5403
 |  | Operating income (loss) |  | 413 |  |  | 128 |  |  | 1393 |  |  |  | 848 |  |  | 1145
 | Foundry (4)
 |  | Net revenue |  | 0 |  |  | 0 |  |  | 309 |  |  |  | 0 |  |  | 1101
 |  | Operating income (loss) |  | 0 |  |  | 0 |  |  | -99 |  |  |  | 0 |  |  | -433
 | Intersegment Eliminations (5)
 |  | Net revenue |  | 0 |  |  | 0 |  |  | -309 |  |  |  | 0 |  |  | -1101
 |  | Operating income (loss) |  | 0 |  |  | 0 |  |  | -6 |  |  |  | 0 |  |  | -48
 | Total AMD
 |  | Net revenue |  | 1649 |  |  | 1618 |  |  | 1646 |  |  |  | 6494 |  |  | 5403
 |  | Operating income (loss) |  | 413 |  |  | 128 |  |  | 1288 |  |  |  | 848 |  |  | 664
 | Other Data
 | Depreciation and amortization
 | (excluding amortization of acquired intangible assets) |  |  | 78 |  |  | 79 |  |  | 266 |  |  |  | 322 |  |  | 1058
 | Capital additions |  |  | 38 |  |  | 31 |  |  | 173 |  |  |  | 148 |  |  | 466
 | Headcount (excludes Foundry segment) |  |  | 11068 |  |  | 11021 |  |  | 10352 |  |  |  | 11068 |  |  | 10352
 | AMD non-GAAP comparison*
 |  | Depreciation and amortization
 |  | (excluding amortization of acquired intangible assets) |  | 78 |  |  | 79 |  |  | 95 |  |  |  | 322 |  |  | 398
 |  | Capital additions |  | 38 |  |  | 31 |  |  | 37 |  |  |  | 148 |  |  | 88
 |  | Adjusted EBITDA (6) |  | 241 |  |  | 245 |  |  | 282 |  |  |  | 1031 |  |  | 527
 |  | Cash, cash equivalents and marketable securities (7) |  | 1789 |  |  | 1726 |  |  | 1772 |  |  |  | 1789 |  |  | 1772
 |  | Adjusted free cash flow (8) |  | 11 |  |  | 91 |  |  | N/A |  |  |  | 355 |  |  | N/A
 |  | Total assets (7) |  | 4964 |  |  | 4595 |  |  | 4846 |  |  |  | 4964 |  |  | 4846
 |  | Long-term debt and capital lease obligations (7) |  | 2192 |  |  | 2188 |  |  | 2607 |  |  |  | 2192 |  |  | 2607
 | * 2009 periods exclude Foundry segment and Intersegment Eliminations
 | See footnotes on the next page
Spreadsheet: 221258d1363447655-if-and-vlookup-help-cost-sample
Sheet: Liquor

[NAME] | Barcode | GG Item # | Sigel Item # | [NAME] (ounces) | Cost
 |  |  |  | 1 | 2
1800 Rep | [PHONE] | 3546 | 02331930 | 33.8 | 0.8124260355029587
[NAME] | [PHONE] | 3706 | 02001030 | 33.8 | 0.7349112426035503
[NAME] | 835229002401 | 18871 | 02001330 | 33.8 | 0.7420118343195267
Absolute Citron | [PHONE] | 3686 | 02310920 | 33.8 | 0.7420118343195267
Absolute Mango | 835229001435 | 35143 | 02003330 | 33.8 | 0.7127218934911244
Absolute Peppar | 835229004405 |  |  | 33.8 | 0.7349112426035503
Absolute Rasberry | 835229008403 | 25515 | 02001830 | 33.8 | 0.7349112426035503
Absolute Vanilla | 835229006409 | 23580 |  | 33.8 | 0.7349112426035503
[NAME] | [PHONE] | 2878 | 02506230 | 33.8 | 0.4340236686390533
[NAME] 151 | [PHONE] |  |  | 33.8 | 0
Spreadsheet: 764972d1643105382-cumulative-sum-that-resets-based-on-a-criteria-example-ans
Sheet: eXAMPLE

Subject | Stage | Trial | Stimulus | Corr_Loc [1=L,2=R] | Response [1=Corr] | Correct | Block | IncStimRewOppTrial | IncStimRewSameTrial | StimRewOppTrial | CUMSUM |  | FORMULA
1 | 5 | 1 | 2 | 2 | 0
1 | 5 | 2 | 1 | 1 | 0
1 | 5 | 3 | 1 | 1 | 1
1 | 7 | 31 | 2 | 1 | 0 |  |  |  |  |  | 1 | <-- START
1 | 7 | 32 | 2 | 1 | 1 |  |  |  |  |  | 2
1 | 7 | 33 | 2 | 1 | 0 |  |  |  |  |  | 3
1 | 7 | 34 | 1 | 1 | 1
1 | 7 | 35 | 2 | 1 | 0 |  |  |  |  |  | 4
1 | 9 | 39 | 2 | 1 | 0 |  |  |  |  |  | 5
1 | 9 | 39 | 2 | 1 | 0 |  |  |  |  |  | 6
1 | 9 | 39 | 2 | 1 | 0 |  |  |  |  |  | 7
2 | 8 | 22 | 2 | 2 | 1 |  |  |  |  |  |  | <-- RESET
2 | 8 | 23 | 2 | 2 | 1
2 | 8 | 24 | 1 | 2 | 0 |  |  |  |  |  | 1
2 | 8 | 25 | 1 | 2 | 0 |  |  |  |  |  | 2
2 | 8 | 26 | 2 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  | Columns H and K are not used.
Spreadsheet: 36748d1234671641-using-2-variables-to-return-multiple-items-from-multiple-sheets-2-variables-no-array
Sheet: Summary (2)

 | Product | G | Select from Drop Down |  |  |  |  | (delete these comments)
 | Supply Less Than | 10
 |  |  |  |  |  |  |  | In this version, we are still listing all
 | Store | Store Location | Supply | Available in Whse |  |  |  | stores in the list in order, but are then
 | 1 | East St | OK | More than 10 |  |  |  | using conditional formats
 | 2 | 6th Ave | 14.58142501880557 | 6 |  |  |  | to make the store # and location fields
 | 3 | Stafford | 11.91435650361798 | 7 |  |  |  | go completely blank if they are OK.
 | 4 | Manhattan | 20.78042457238807 | 1
 | 5 | Ridgewood | 43.60657644043524 | 1 |  |  |  | Don't make changes to C2 or C3 on
 | 6 | Location6 | OK | More than 10 |  |  |  | this page, they're not connected. Make
 | 7 | [NAME] | OK | More than 10 |  |  |  | changes on the the other SUMMARY
 | 8 | Location8 | OK | More than 10 |  |  |  | page and they affect this sheet, too.
 | 9 | Location9 | OK | More than 10
 | 10 | Location10 | OK | More than 10
 | 11 | Location11 | OK | More than 10
 | 12 | Location12 | OK | More than 10
 | 13 | Location13 | OK | More than 10
 | 14 | Location14 | OK | More than 10
 | 15 | Location15 | OK | More than 10
 | 16 | Location16 | OK | More than 10
 | 17 | Location17 | OK | More than 10
 | 18 | Location18 | OK | More than 10
 | 19 | Location19 | OK | More than 10
 | 20 | Location20 | OK | More than 10
 | 21 | Location21 | OK | More than 10
 | 22 | [NAME] | OK | More than 10
 | 23 | Location23 | OK | More than 10
 | 24 | Location24 | OK | More than 10
 | 25 | Location25 | OK | More than 10
Spreadsheet: 114096d1309952209-return-maximum-value-with-conditions-example
Sheet: Sheet1

A | B
0.71 | 1
0.26 | 0
1.11 | 0
1.11 | 1 |  |  | Min | 0.71
7.63 | 1 |  |  | [NAME] | 7.63
0.19 | 0
0.16 | 0
3 | 1
0.17 | 0
8 | 0
0.17 | 0
0.17 | 0
1.24 | 1
1.68 | 2
2.54 | 2
1.01 | 2
1.65 | 2
2.11 | 2
1.01 | 2
1.85 | 2
2.45 | 2
Spreadsheet: 920c8bb2-36a8-4b45-979f-5b58d324997b
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
DRD4O | Test | DRD4O | Dopamine Receptor [NAME] (DRD4), Saliva | [NAME], Saliva | Polymerase Chain Reaction (PCR) Followed by Sizing Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen after a single extraction. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions: 		 1. Fill tube to line.			 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 8 a.m. | 1 day | 10 days | 1 | 81479 |  |  |  |  | Rochester
DRD4O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
DRD4O | Result | 32982 | 48 BP Repeat Genotype | 48 BP Repeat Genotype | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
DRD4O | Result | 32983 | Reviewed by | Reviewed by | Numeric
DRD4O | Result | 32984 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
Spreadsheet: 878329d1725400406-random-pairing-without-duplication-based-on-criteria-random-pairing
Sheet: Sheet1

Name | Business Function | Business Function Preference 1 | Business Function Preference 2 | Business Function Preference 3 | Business Function Preference 4 | Paired 1 Name | Paired 2 Name | Meet at Home
A | Customer Service | No Preference |  |  |  | L | A | Yes
B | Customer Service | Customer Service | Towing | Road |  | M | N/A | Yes
C | Customer Service | No Preference |  |  |  | N | N/A | No
D | Customer Service | No Preference |  |  |  | O | N/A | No Preference
E | Customer Service | No Preference |  |  |  | P | N/A | Yes
F | Towing | No Preference |  |  |  | Q | C | No
G | Towing | Customer Service | Towing | Road | Billing | R | D | Yes
H | Towing | Billing |  |  |  | S | N/A | No Preference
I | Towing | No Preference |  |  |  | N/A | N/A | No Preference
J | Towing | Towing |  |  |  | N/A | N/A | No
K | Towing | No Preference |  |  |  | N/A | N/A | Yes
L | Road | Road | Towing |  |  | N/A | N/A | No
M | Road | Road | Customer Service |  |  | N/A | N/A | Yes
N | Road | No Preference |  |  |  | N/A | N/A | No Preference
O | Road | No Preference |  |  |  | N/A | N/A | Yes
P | Road | No Preference |  |  |  | N/A | N/A | No Preference
Q | Road | Billing | Towing | Customer Service |  | N/A | N/A | Yes
R | Billing | No Preference |  |  |  | N/A | N/A | No Preference
S | Billing | No Preference |  |  |  | N/A | N/A | Yes
 |  |  |  |  |  |  |  | No
Need
Random Pairing without Duplication
Criteria
Match with a Name in the preferred Business Function, if there is a preference
Match with a Name based 'Meet at Home' Preference
Not previously paired with the individual
Spreadsheet: 868395d1715149997-if-and-nested-help-excel-forum-help-_etaf2
Sheet: Stock Calculations

AA Catering Disposables Ltd  |  Prepared by:  AA Catering Disposables Limited |  |  |  |  |  |  |  |  |  |  |  |  | No Further Action
Inventory Quantities as at 31/05/2024 |  |  |  |  |  |  |  |  |  |  |  |  | Under Review
 |  |  |  |  |  |  |  |  |  |  |  |  | Complete
 |  |  |  |  |  |  | Sales |  | Purchase
Code & Description |  | Unit | Barcode | Balance | Unposted | On Hand | Orders | Available | Orders | Website Category | Description | Supplier | Actual Status | [NAME] | Min Order Calc | Min Qty | PCM | 3 Month | Min | [NAME] | Order | Comments | Expected Del Date
Inventory Category : 001 - Aluminuim Foil Containers
2472 |  | 1000 | M0402002 | 14 | 0 | 14 | 0 | 14 | 0 |  |  |  |  |  |  |  |  |  | 13 | 16
2618 |  | 2300 | M0204001 | 15 | 0 | 24 | 0 | 24 | 0 |  |  |  |  |  |  |  |  |  | 13 | 16
2650 |  | 1200 | T18-1114 | 16 | 0 | 3.00000000000001 | 0 | 3.00000000000001 | 0 |  |  |  |  |  |  |  |  |  | 13 | 16
2662 |  | 700 | T18-1114 | 3 | 0 | 3 | 0 | 3 | 0
2820 |  | 250 | B2002001 | 11 | -1 | 9.99999999999998 | 0 | 9.99999999999998 | 0
2824 |  | 200 | B1909001 | 35 | 0 | 35 | 0 | 35 | 0
3050 |  | 2000 | B1805001 | 25 | 0 | 25 | 0 | 25 | 0
3208 |  | 1000 | B1712999 | 34 | 0 | 34 | 0 | 34 | 0
3234 |  | 1000 | B2403001 | 6.00000000000004 | 0 | 6.00000000000004 | 0 | 6.00000000000004 | 0
3242 |  | 500 | B1614999 | 9 | 0 | 9 | 0 | 9 | 0
Spreadsheet: 875946d1722566897-formula-to-calculated-balance-general-ledger
Sheet: Sheet1

 | CV. X
 | GENERAL JOURNAL
 | JANUARY 31, 2024 |  |  |  |  |  | No Account | 111
 |  |  |  |  |  |  | Account
 | Date | Description | Ref | Debit | Credit |  | Date | Description | Ref | Debit | Credit | Balance
 | 2024-01-01 00:00:00 | Cash | 111 | 27500000 |  |  | 2024-01-01 00:00:00 | Cash | 111 | 27500000
 | 2024-01-01 00:00:00 | Accounts Receivable | 112 |  | 27500000 |  | 2024-01-01 00:00:00 | Accounts Receivable | 112 |  | 27500000
 | 2024-01-01 00:00:00 | Utility Expense | 512 | 4000000 |  |  | 2024-01-01 00:00:00 | Utility Expense | 512 | 4000000
 | 2024-01-01 00:00:00 | Cash | 111 |  | 4000000 |  | 2024-01-01 00:00:00 | Cash | 111 |  | 4000000
 | 2024-01-01 00:00:00 | Cash | 111 | 30200000 |  |  | 2024-01-01 00:00:00 | Cash | 111 | 30200000
 | 2024-01-01 00:00:00 | Service Revenue | 411 |  | 30200000 |  | 2024-01-01 00:00:00 | Service Revenue | 411 |  | 30200000
 | 2024-01-01 00:00:00 | Cash | 111 | 25400000 |  |  | 2024-01-01 00:00:00 | Cash | 111 | 25400000
 | 2024-01-01 00:00:00 | Accounts Receivable | 112 |  | 25400000 |  | 2024-01-01 00:00:00 | Accounts Receivable | 112 |  | 25400000
 | TOTAL
 |  |  |  |  |  |  | *I need formula on balance how to make the balance calculated automated based on account name.
 |  |  |  |  |  |  | Lets say that if I only make "Cash" appear, the balance will also calculated automated on the table.
 |  |  |  |  |  |  | Also I want the formula to be used for all account name. Thank you.
Spreadsheet: 85407d1285504829-excel-2008-multiple-entries-in-one-day-to-be-as-one-example
Sheet: Sheet1

Current data example
Individual | Date of transaction | Amount claimed
a | 2010-01-04 00:00:00 | 20
a | 2010-01-04 00:00:00 | 15
a | 2010-10-05 00:00:00 | 10
b | 2010-11-07 00:00:00 | 12
c | 20/6/2010 | 5
c | 21/6/2010 | 7
c | 21/6/2010 | 3
Desired Data outpot
Individual | Date of transaction | Amount claimed | Name | total visites/month | total claimed amount
a | 2010-01-04 00:00:00 | 20 | a | 2 | 24
a | 2010-01-04 00:00:00 | 15 | b | 1 | 12
a | 2010-10-05 00:00:00 | 10 | c | 3 | 15
b | 2010-11-07 00:00:00 | 12
c | 20/6/2010 | 5
c | 21/6/2010 | 7
c | 22/6/2010 | 3
Spreadsheet: kimberly_watson__20634__tw_priority_rate
Sheet: 200011-200012

Transwestern Pipeline Company
Contracts Under the Global Settlement
Priority Rates (Reservation and Demand Surcharges)
11/2999-10/2001
Contract | Shipper | Receipt to Delivery | Reservation | Shared Cost | TCR II No. 1 | TCR II No. 2 | Total | GRI Demand | Total |  | Commodity | ACA | GRI
Number | Name | Area | Rate | Surcharge | Surcharge | Surcharge | Surcharges | Surcharge | Rate |  | Rate | Surcharge | Surcharge
8255 | Southern California Gas Company | East of Thoreau to California (W. of Thoreau) | 0.3232 |  | 0.0051 | 0.0007 |  | 0.0066 |  |  | 0.0238 | 0.0022 | 0.0072
20834 | Citizens Utilities Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
20835 | Conoco Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
21175 | Pacific Gas & Electric Company(Gas) | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
26677 | El Paso Energy Marketing Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
26371 | Duke Energy Trading and Marketing. LLC | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
25923 | Texaco Natural Gas Inc. | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
20715 | Southern California Gas Company | San Juan Lateral to Thoreau/San Juan Pt. | 0.1052 | - | - | - |  | - |  |  | 0.0011 | - | -
20747 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0369 | 0.005 | 0.0007 |  | 0.0066 |  |  | 0.0162 | 0.0022 | 0.0072
20748 | Conoco Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0369 | 0.005 | 0.0007 |  | 0.004 |  |  | 0.0162 | 0.0022 | 0.0072
21165 | Pacific Gas & Electric Company(Gas) | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.0052 | 0.0007 |  | 0.0066 |  |  | 0.0162 | 0.0022 | 0.0072
26678 | El Paso Energy Marketing Company | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.004 | 0.0005 |  | 0.0066 |  |  | 0.0162 | 0.0022 | 0.0072
26372 | Duke Energy Trading and Marketing. LLC | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.2606 | 0.0443 | 0.0051 | 0.0007 |  | 0.0066 |  |  | 0.0162 | 0.0022 | 0.0072
25924 | Texaco Natural Gas Inc. | Thoreau/San Juan Pt. to California (W. of Thoreau) | 0.266 | 0.0443 | 0.0053 | 0.0007 |  | - |  |  | 0.0162 | 0.0022 | -
20822 | Citizens Utilities Company | Thoreau/San Juan Pt. to East of California (W. of Thoreau) | 0.1681 | 0.0369 | 0.0025 | 0.0003 |  | 0.004 |  |  | 0.0162 | 0.0022 | 0.0072
NOTE --- | Per CBS Rate System, the termination date for the rates listed above are as follows:
 | Reservation | Recalculation eff every Nov 1st
 | SCS | 2001-10-31 00:00:00
 | TCR II No. 1 | 2005-10-31 00:00:00
 | TCR II No. 2 | 2006-10-31 00:00:00
 | GRI Demand | Recalculation eff every Jan 1st **
 | ** Calculation made every year to determine which contracts are High Load vs. Low Load
Spreadsheet: 121521d1316108257-ranking-system-sample-workbook
Sheet: Results

 |  | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10
 | Weeks
 | Correct Picks | 9 | 8 | 6 | 7 | 5 | 9 | 9 | 2 | 0 | 2
 | Tiebreaker Correct | Yes | No | No | Yes | Yes | Yes | No | No | No | No
 | Rankings
 | Problem
 | I need a formula that will start in cell C6 and continue thorugh L6 that will provide the participant's ranking within the group.
 | Scenario
 | > Name 1, Name 6 and Name 7 have the same number of correct guesses, therfore they are tied
 | > So if we look at the "Tiebreaker" row, Name 1 and Name 6 got it correct.
 | > Since they tied on both, they would both be ranked #1.
 | Final Results should be:
 |  | Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10
 | Weeks
 | Correct Picks | 9 | 8 | 6 | 7 | 5 | 9 | 9 | 2 | 0 | 2
 | Tiebreaker Correct | Yes | No | No | Yes | Yes | Yes | No | No | No | No
 | Rankings | 1 | 4 | 6 | 5 | 7 | 1 | 3 | 8 | 10 | 8
Spreadsheet: 890045d1741182041-if-cell-contains-a-certain-range-display-a-value-in-another-cell-book1
Sheet: Sheet1

 |  |  |  | LOW 1- 6 | 10
 |  |  |  | MEDIUM 8 - 12 | 17
 |  |  |  | HIGH 15 - 20 | 33
 |  |  |  | 25 | 100
 |  | Total risk matrix score | Percentage
 |  | 9
 |  | 16 | 33
 |  | 16 | 33
 |  | 12 | 17
 |  | 4 | 10
 |  | 16 | 33
 |  | 25 | 100
 |  | 6 | 10
 |  | 12 | 17
 |  | 9 | 17
 |  | 25 | 100
 |  | 8 | 17
 |  | 12 | 17
 |  | 6 | 10
 |  | 6 | 10
Spreadsheet: 208233d1358771472-splitting-multiple-entries-in-single-cell-into-multiple-columns-dummy-data
Sheet: Sheet1

Core 1A | Core 1B | Net Mgmt VLAN | Server [NAME] | Site | Site ID | Site Type | Parent [NAME]
10.0.1.1 | 10.0.1.2 | 10.0.2.0 | 10.0.3.0 | Wallington Avenenue (Cullercoats) | 1002 | Hightened | DC1
192.168.9.1 | 192.168.9.2 | 192.168.10.0 | 192.168.11.0 | Newcastle Road | 12 | Base | DC1
10.1.1.1 | 10.1.1.2 | 10.1.2.0 | 10.1.3.0 | Bracknell | 186 | Critical | DC3
Spreadsheet: scott_neal__38584__HM-ES SCOTT NEAL BOND 06072001
Sheet: Enter

(000) |  |  |  |  |  |  | [NAME]. | [NAME]. Call | Par | Pre-Re
Par | DTD | Settlement | Rating | Description | Coupon | Maturity | Call | Price | Call | Y=Yes | Price | SC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL SC
50 | 1998-10-01 00:00:00 | 2001-06-12 00:00:00 | AAA/ | WICHITA FALLS ISD PSF | 0.045 | 2012-02-01 00:00:00 | 2008-02-01 00:00:00 | 100 |  |  | 100
50 | 2001-05-15 00:00:00 | 2001-06-28 00:00:00 | AAA/AAA | [NAME] OF OB | 0.0465 | 2012-08-15 00:00:00 | 2011-08-15 00:00:00 | 100 |  |  | 101.204
25 | 1997-10-01 00:00:00 | 2001-06-12 00:00:00 | AAA/AAA | TX WTR DEV BRD | 0.05 | 2013-07-15 00:00:00 | 2007-07-15 00:00:00 | 101 | 2008-07-15 00:00:00 |  | 101.787
50 | 2001-05-15 00:00:00 | 2001-06-19 00:00:00 | AAA/AAA | ROUND ROCK TX TRAN | 0.0485 | 2014-08-15 00:00:00 | 2011-08-15 00:00:00 | 100 |  |  | 101.194
50 | 1998-11-01 00:00:00 | 2001-06-12 00:00:00 | AAA/AAA | HARRIS CO TX MUD#359 | 0.04375 | 2015-06-01 00:00:00 | 2007-06-01 00:00:00 | 100 |  |  | 94.732
25 | 1999-09-01 00:00:00 | 2001-06-12 00:00:00 | AAA/AAA | FLOWER MOUND TX W/S | 0.055 | 2015-09-01 00:00:00 | 2009-09-01 00:00:00 | 100 |  |  | 105.046
 |  | Settlement |  | Enter Account/Broker Name: |  | [NAME]:
 |  | 2001-06-12 00:00:00 |  | HM-ES SCOTT NEAL |  |  |  |  |  |  | SC=
Spreadsheet: 866882d1713800479-use-xmatch-and-xlookup-to-find-result-in-dynamic-range-xmatch1
Sheet: DATA2

10 Mucho Marvin (P 1)
Own: [NAME]
8/1 Blue, 'c' Black Ball, Black Sleeves, Blue Cuffs
MCMAHON C.J. (143 13-14-19 9%)
$5,000 [NAME] FTKOCT 2017 $30k
Sire : Mucho Macho Man (Macho Uno) $3,403
Dam: Noelle's Quay (Circular Quay)
[NAME]: Al Ulwelling & Bill Ulwelling (LA)
[NAME]: [NAME] (15 0-0-3 0%)
Prime Power: 108.3 (5th) Life: 60 7 -10 -10 $179,560 81
2024 2 0 - 0 - 1 $2,100 76
2023 13 1 - 3 - 2 $28,540 79
FG 7 0 - 0 - 2 $10,210 76
Fst (101) 46 6 - 8 -10 $161,070 81
Off (101) 7 0 - 2 - 0 $8,380 77
Dis (101) 13 1 - 2 - 2 $33,030 77
Trf (103) 7 1 - 0 - 0 $10,110 77
AW 0 0 - 0 - 0 $0
L 121
+2023-2024 366 28% 59% -0.23
JKYw/ P types 133 10% 42% -1.07
[NAME] L60 2 0% 0% -2.00
[NAME] 457 11% 37% -1.04
2023-2024 147 7% 31% -1.58
Claiming 127 13% 43% -0.32
+Sprints 701 29% 65% -0.45
Dirt starts 401 11% 38% -0.23
Sire Stats: AWD 7.1 16%Mud 382MudSts 1.18spi
Dam'sSire: AWD 6.7 14%Mud 433MudSts 0.83spi
Spreadsheet: 751771d1634309054-vlookup-count-if-or-other-option-to-summarize-data-in-a-table-like-format-example
Sheet: Sheet1

 | COLOR 1 | COLOR 2
COMPONENT A | 5269.241026655252 | 68.35639001141551
COMPONENT B | 7587.920319108322 | 98.43596792871637
COMPONENT F | 0 | 0
 | COLOR 3 | COLOR 7 | COLOR 4 | COLOR 5 | COLOR 6
COMPONENT A | 2691.594560422846 | 2864.576916495551 | 38.95044299946764 | 23.09776408852385 | 35.57661228990798
COMPONENT A | 2691.594560422846 | 2864.576916495551 | 38.95044299946764 | 23.09776408852385 | 35.57661228990798
COMPONENT F | 0 | 0 | 0 | 0 | 0
 | COLOR 3 | COLOR 4 | COLOR 5 | COLOR 6
COMPONENT C | 7518.615685492771 | 5740.66261033105 | 11.2876990391933 | 1102.217093099949
COMPONENT D | 9022.260056516361 | 6888.734992408675 | 13.54512059550989 | 1322.648964738711
COMPONENT F | 0 | 0 | 0 | 0
 | COLOR 4 | COLOR 2 | COLOR 3 | COLOR 5 | COLOR 1 | [NAME] | COLOR 6
COMPONENT C | 3995.817915464866 | 61.87025276192288 | 727.8885671296298 | 323.7294456018519 | 34.82715145230847 | 35.73060808599696 | 7.85015672564688
COMPONENT E | 4794.939637807584 | 74.2436551528412 | 873.4586550925926 | 388.4719432870369 | 41.79221688863521 | 42.87635538432267 | 9.420105831430746
COMPONENT F | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | COLOR 1 | COLOR 2 | COLOR 3 | COLOR 4 | COLOR 5 | COLOR 6 | COLOR 7
COMPONENT A
COMPONENT B |  |  | 0 |  |  | 0
COMPONENT C
COMPONENT D | 0 |  |  |  |  |  | 0
COMPONENT E
COMPONENT F | 0 |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 861159d1709121861-vertically-combining-data-from-multiple-columns-to-have-all-data-in-1-column-sku-list-example
Sheet: in 1 column

COMBINED
ID000001
ID000002
ID000003
ID000004
ID000005
ID000006
ID000007
ID000008
ID000009
ID000010
ID000011
ID000012
ID000013
ID000014
ID000015
ID000016
ID000017
ID000018
ID000025
ID000026
ID000027
Spreadsheet: 148990d1333640631-if-function-two-inputs-one-output-book1
Sheet: Sheet3

Name | Today
[NAME] | E
Sang-Moon Bae | E
[NAME] | -
[NAME] | 3
[NAME] | - |  |  |  | I would like the cell to have a "0" when there is a "-"
[NAME] | -
[NAME] | -
[NAME] | -