tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713110d1610555436-combining-vlookup-with-function-to-determine-if-a-date-falls-between-two-dates-excel-data-cleaned
Sheet: Account Assignments

Account # | Employee Assignment | Assignment Start Date | Assignment Stop Date
81730 | A | 2011-12-12 00:00:00 | 2015-07-20 00:00:00
102324 | A | 2012-02-01 00:00:00 | 2015-07-20 00:00:00
133425 | A | 2011-06-10 00:00:00 | 2015-01-05 00:00:00
37084 | A | 2011-06-10 00:00:00 | 2015-01-15 00:00:00
2711325 | A | 2013-02-08 00:00:00 | 2015-03-27 00:00:00
35788 | A | 2011-06-10 00:00:00 | 2015-04-08 00:00:00
70403 | A | 2011-06-10 00:00:00 | 2015-04-08 00:00:00
2716022 | A | 2012-10-13 00:00:00 | 2015-04-08 00:00:00
2854299 | A | 2011-06-10 00:00:00 | 2015-04-08 00:00:00
81730 | B | 2020-10-07 00:00:00 | 2020-10-15 00:00:00
102324 | B | 2020-10-07 00:00:00 | 2020-10-15 00:00:00
41221 | C | 2006-07-27 00:00:00 | 2020-07-23 00:00:00
3082340 | E | 2018-08-28 00:00:00 | 2018-09-17 00:00:00
41221 | E | 2018-08-28 00:00:00 | 2019-03-27 00:00:00
50916 | E | 2018-08-28 00:00:00 | 2019-05-14 00:00:00
90092 | E | 2020-03-12 00:00:00 | 2020-03-29 00:00:00
3082339 | E | 2018-08-28 00:00:00 | 2020-03-29 00:00:00
3082340 | E | 2018-09-17 00:00:00 | 2020-03-29 00:00:00
3173029 | E | 2018-08-28 00:00:00 | 2020-03-29 00:00:00
5224 | E | 2018-08-28 00:00:00 | 2020-06-02 00:00:00
81730 | F | 2020-03-12 00:00:00 | 2020-10-07 00:00:00
102324 | F | 2020-03-12 00:00:00 | 2020-10-07 00:00:00
3173029 | H | 2020-07-22 00:00:00 | 2020-10-07 00:00:00
81730 | R | 2015-07-20 00:00:00 | 2016-07-27 00:00:00
102324 | R | 2015-07-20 00:00:00 | 2018-03-13 00:00:00
5224 | R | 2016-10-12 00:00:00 | 2018-06-30 00:00:00
41221 | R | 2016-10-12 00:00:00 | 2018-06-30 00:00:00
50916 | R | 2011-12-13 00:00:00 | 2018-06-30 00:00:00
3082339 | R | 2017-07-11 00:00:00 | 2018-06-30 00:00:00
3082340 | R | 2017-07-11 00:00:00 | 2018-06-30 00:00:00
3173029 | R | 2016-06-22 00:00:00 | 2018-06-30 00:00:00
28120 | R | 2011-12-29 00:00:00 | 2014-09-12 00:00:00
5224 | S | 2010-12-08 00:00:00 | 2016-10-06 00:00:00
41221 | S | 2010-12-08 00:00:00 | 2016-10-06 00:00:00
90092 | S | 2010-12-08 00:00:00 | 2016-10-06 00:00:00
25639 | S | 2010-09-21 00:00:00 | 2015-01-27 00:00:00
25658 | S | 2010-12-08 00:00:00 | 2015-02-09 00:00:00
3290431 | S | 2020-01-05 00:00:00
81730 | SE | 2016-07-27 00:00:00 | 2020-03-12 00:00:00
90092 | SE | 2016-10-12 00:00:00 | 2020-03-12 00:00:00
102324 | SE | 2018-03-13 00:00:00 | 2020-03-12 00:00:00
3173029 | T | 2020-03-29 00:00:00 | 2020-07-01 00:00:00
41221 | T | 2019-03-27 00:00:00 | 2020-07-22 00:00:00
50916 | T | 2019-05-14 00:00:00 | 2020-07-22 00:00:00
3173029 | T | 2020-07-01 00:00:00 | 2020-07-22 00:00:00
Spreadsheet: bdbf610e-7c6c-463e-a24d-b15b8782321e
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
FLP | Test | FLP | [NAME], Amniotic Fluid | [NAME], AF | Thin-Layer Chromatography (TLC) with [NAME] by Densitometry  Includes lecithin/sphingomyelin (L/S) ratio, and phosphatidylglycerol (PG), semiquantitative on amniotic fluid. | Varies: Var |  |  | 10 | mL | Container/Tube: Amniotic fluid container [NAME]: 10 mL Collection Instructions:  1. Centrifuge at 1,000 rpm or 200 x G for 10 minutes, separate supernatant, and send both supernatant and sediment in separate plastic vials.  2. Label specimens sediment and supernatant. Additional Information: Include estimate of duration of pregnancy (in weeks). Forms: 1.	1. 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. 2.	2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 3 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK - refreeze Lipemia	NA Icterus	NA Other	NA | Lecithin/ Sphingomyelin Ratio	    Phosphatidylglycerol	    Interpretation <2.5	Absent	Immature > or =2.5	Absent	Indeterminate <2.5	Trace	Indeterminate > or =2.5	Trace	Mature Any ratio	Present	Mature All results will be called back. | Monday through Friday; 2 p.m.  Saturday and Sunday; 11 a.m. Weekdays: Sample del | 1 day | 2 days |  | Profile |  |  |  |  | Rochester
FLP | [NAME] | AMNIOTIC | Amniotic Fld |  |  |  | Frozen | 14 days
FLP | Result | 8929 | [NAME], AF | [NAME], AF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47226-6 | Fetal lung maturity:Imp:Pt:Amnio fld:Nom:
FLP | Result | 2405 | L/S Ratio | L/S Ratio | Alphanumeric |  |  |  |  | ratio |  |  |  |  |  |  |  |  |  | 14976-5 | Lecithin/Sphingomyelin:Ratio:Pt:Amnio fld:Qn:
FLP | Result | 2407 | Phospglycerol | Phospglycerol | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2785-4 | Phosphatidylglycerol:ACnc:Pt:Amnio fld:[NAME]:
FLP | Result | 2408 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47226-6 | Fetal lung maturity:Imp:Pt:Amnio fld:Nom:
Spreadsheet: 780670d1652672758-show-top-n-from-excel-data-table-using-slicers-slicers-sample-book
Sheet: Dashboard

 |  |  |  |  |  |  | Want to show Top N?
 | Total |  |  |  |  |  | For example, assuming all slicers are selected, it would look like this:
 |  |  |  |  |  |  | Oregon | 5303.49 |  |  | 5303.49 |  |  | 5303.49 |  |  | 5303.49
 |  |  |  |  |  |  | Oregon | 2139.14 |  | Oregon | 2139.14 |  | Oregon | 2139.14 |  | Oregon | 2139.14
 |  |  |  |  |  |  | California | 1262.2 |  | California | 1262.2 |  | California | 1262.2 |  | California | 1262.2
 |  |  |  |  |  |  | Arizona | 909.77 |  | Arizona | 909.77 |  | Arizona | 909.77 |  | Arizona | 909.77
 |  |  |  |  |  |  | Arizona | 787.99 |  | Arizona | 787.99 |  | Arizona | 787.99 |  | Arizona | 787.99
 |  |  |  |  |  |  | Arizona | 639.61 |  | Arizona | 639.61 |  | Arizona | 639.61 |  | Arizona | 639.61
 |  |  |  |  |  |  | Colorado | 562.93 |  | Colorado | 562.93 |  | Colorado | 562.93 |  | Colorado | 562.93
 |  |  |  |  |  |  | California | -228.91 |  | California | -228.91 |  | California | -228.91 |  | California | -228.91
 |  |  |  |  |  |  | Oregon | -565.8 |  | Oregon | -565.8 |  | Oregon | -565.8 |  | Oregon | -565.8
 |  |  |  |  |  |  | California | -808.65 |  | California | -808.65 |  | California | -808.65 |  | California | -808.65
Spreadsheet: 268385d1380613588-if-drop-down-menu-equals-one-of-5-lists-on-a-certain-day-of-the-week-then-example-attendance
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  |  |  |  | DOR WK
 |  |  | STATUS | RETURN |  |  |  |  | STATUS | RETURN
MGMT |  |  |  |  |  | CS
 |  | 2114 |  |  |  | HAR |  | 2375
 |  | 2166 |  |  |  | JOK |  | 2302
HR |  |  |  |  |  | MCB |  | 2112
 |  | 5401 |  |  |  | MCA |  | 8783
 |  |  |  |  |  | MEJ |  | 2397
SA |  |  |  |  |  | MIL |  | 4481
MOB |  | 8706 |  |  |  | MUJ |  | 8724
HNG |  | 2325 |  |  |  | UNOCCUPIED |  | 8723
KOK |  | 2175 |  |  |  | UNOCCUPIED |  | 4433
 |  |  |  |  |  | UNOCCUPIED |  | 8729
[NAME]
ALK |  | 2350 |  |  |  | AG
BAF |  | 5488 |  |  |  | DEA |  | 2312
BAD |  | 2356
COB |  | 8744 |  |  |  | AM
EIM |  | 2344 |  |  |  |  |  | 2124
FRC |  | 5477
HEN |  | 4490 |  |  |  | ACR
KIV |  | 2164 |  |  |  |  |  | 5470
KLS |  | 2301 |  |  |  |  |  | 2369
LAM |  | 2358
LIM |  | 8739 |  |  |  | HA
LOC |  | 8770 |  |  |  |  |  | 8769
MAC |  | 2126 |  |  |  |  |  | 8743
MCC |  | 2160
MIK |  | 2173 |  |  |  | RA
NOC |  | 2184 |  |  |  |  |  | 2104
SMM |  | 5474 |  |  |  |  | 8743 | 2176
SCS |  | 5448 |  |  |  |  |  | 2108
 |  | 5449
CAI |  |  |  |  |  | SYSTEMS
DEC |  | 2338 |  |  |  |  |  | 2387
KAK |  | 2141 |  |  |  |  |  | 5425
KEK |  | 8222
LEC |  | 2326
MIB |  | 2107
MIA |  | 2131
MUJ | 5458 | 5454
OFS |  | 5499
POR |  | 2337
VAA |  | 2317
VAL |  | 2169
WGA | 5458 | 5458
Spreadsheet: darrell_schoolcraft__7802__imbalsumm0108
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 26125 | 26316 | 9809 | 8750
2 | 25579 | 26140 | 9577 | 8750 |  |  |  | 176
3 | 25083 | 26316 | 9649 | 8750
4 | 24738 | 26069 | 9083 | 8668
5 | 24635 | 26316 | 9400 | 8750
6 | 24092 | 26316 | 9085 | 8750
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 150097
2001-08-06 00:00:00
CBS Volume
 |  |  | -60022
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 129310d1321544727-index-function-with-match-for-values-greater-than-0-excel-example-for-help
Sheet: Sheet1

 |  |  |  |  | 2011-12-09 00:00:00 | 2011-12-16 00:00:00 | 2011-12-23 00:00:00 | 2011-12-30 00:00:00 | 2012-01-06 00:00:00 | 2012-01-13 00:00:00 | 2012-01-20 00:00:00 | 2012-01-27 00:00:00 | 2012-02-03 00:00:00 | 2012-02-10 00:00:00 | 2012-02-17 00:00:00 | 2012-02-24 00:00:00
Unique ID | [NAME] | Client | Resource Pool | Start Date | December Week 1 | December Week 2 | December Week 3 | December Week 4 | January Week 1 | January Week 2 | January Week 3 | January Week 4 | February Week 1 | February Week 2 | February Week 3 | February Week 4
1 | Description A | Client Q | Pool 1 |  |  |  |  |  | 1 | 1 | 1 | 1
2 | Description B | Client W | Pool 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
3 | Description C | Client E | Pool 2 |  |  |  |  | 1 | 1 | 1 | 1 | 1
4 | Description D | Client R | Pool 2 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
5 | Description E | Client T | Pool 1 |  | 1 | 1 | 1 | 1
TOTAL: |  |  |  |  | 1 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 0 | 1 | 1 | 1
Spreadsheet: 613721d1551518298-copy-visible-date-and-paste-into-visible-cells-only-visible
Sheet: loans

Employee Name | Mortgage Amount
[NAME] | 1851500
[NAME] | 33188650
[NAME] | 2730000
[NAME] | 2548560
[NAME] | 4336060
[NAME] | 4859800
Freddie | 6285900
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 700669d1603285896-furmula-to-reduce-3-columns-to-2-test26
Sheet: Sheet1

 |  |  |  | 0.4 | 0.6 |  | 0.48 | 0.52 |  | 0.42 | 0.58
 |  |  | GEN | TAP | LAB | GEN | TAP | LAB | GEN | TAP | LAB |  |  | TAP | LAB | TAP | LAB | TAP | LAB
 |  |  | 100 | 167 | 210 | 68 | 120 | 198 | 97 | 180 | 213
 |  |  | 104 | 173 | 200 | 79 | 128 | 204 | 111 | 200 | 220
 |  |  |  | Nos in Row 5 are the fraction of GEN to be added to TAP and LAB
 |  |  |  | so a table with columns grouped in threes becomes a table with columns grouped in twos
 |  |  |  | I have achieved this by entering formulas by hand but there are over 100 groups so I would like a formula inO8 which could be copied across.
Spreadsheet: 866500d1713432520-a-formula-to-select-the-highest-cell-in-a-column-that-then-shows-the-entire-row-walks
Sheet: Kieran

 | # | Date | Name | Distance in        Miles | Total Elevation in Feet | Total Time HH:MM | Moving Time HH:MM | Stoped Time HH:MM | Avarage Speed MPH | Average Moving Speed MPH
 |  |  | 2017
 | 1 | 2017-10-08 00:00:00 | Buckland Dinham Walk | 7.5 | 650 |  | 03:34:00 | 02:14:00
 |  |  | 2018
 |  |  | 2019
 |  | 2019-02-17 00:00:00 | Chew Valley Lake - Blagdon Lake - Ubley - Compton Martin Circular | 8.4 | 1246 |  | 03:47:00 | 00:52:00
 |  | 2019-02-24 00:00:00 | Dolebury Warren - Mendip Lodge Woods | 6.1 | 1246 |  | 03:47:00 | 00:52:00
 |  | 2019-03-03 00:00:00 | Timsbury-Camerton-Circular | 11.3 | 1862 |  | 05:47:00 | 02:03:00
 |  | 2019-09-01 00:00:00 | Axbridge Reservoir - Crook Peak | 10.2 | 1781 |  | 04:24:00 | 00:46:00
 |  | 2019-09-20 00:00:00 | [NAME] | 8 | 3025 |  | 05:01:00 | 02:02:00
 |  | 2019-10-22 00:00:00 | Brean Down | 3.4 | 380 |  | 01:25:00 | 00:52:00
 |  |  | 2020
 |  |  | 2021
 |  |  | 2022
 |  |  | 2023
Spreadsheet: 39151d1237348909-excel-2007-how-to-graph-functions-of-known-functions-hcyl30000
Sheet: Sheet1

 |  |  | V=L(D^2)((2acos(1-2h/D))-sin(2acos(1-2h/D)))/8
Inches | Volume
0 | 0 |  |  | Total Volume | Gal. | [NAME]
1 | 36 |  |  |  | 30000 | 4010.41662583
2 | 101 |  |  |  | In. | Ft.
3 | 186 |  |  | Diameter | 126 | 10.5
4 | 285 |  |  | Length | 564 | 47
5 | 397
6 | 521 |  |  | Height (ft) | 6
7 | 655
8 | 798 |  |  | Calculated Volume | [NAME] | Gal.
9 | 950
10 | 1110
11 | 1277
12 | 1451
13 | 1632
14 | 1820
15 | 2013 |  | 3rd Order Polynomial Best Fit Calculation of Coulmns A and B
16 | 2212
17 | 2416 |  |  | Height (In) | 72
18 | 2625
19 | 2839 |  |  | Calculated Volume | [NAME] | Gal.
20 | 3058
21 | 3282
22 | 3510
23 | 3742
24 | 3977
25 | 4217
26 | 4460
27 | 4707
28 | 4957
29 | 5210
30 | 5467
31 | 5726
32 | 5988
33 | 6253
34 | 6521
35 | 6791
36 | 7063
37 | 7338
38 | 7614
39 | 7893
40 | 8174
41 | 8457
42 | 8741
43 | 9028
44 | 9316
45 | 9605
46 | 9896
47 | 10188
48 | 10481
49 | 10776
50 | 11072
51 | 11368
52 | 11666
53 | 11964
54 | 12264
55 | 12564
56 | 12865
57 | 13165
58 | 13467
59 | 13769
60 | 14071
61 | 14374
62 | 14676
63 | 14979
64 | 15282
65 | 15584
66 | 15887
67 | 16189
68 | 16491
69 | 16793
70 | 17094
71 | 17394
72 | 17694
73 | 17993
74 | 18292
75 | 18590
76 | 18886
77 | 19182
78 | 19477
79 | 19770
80 | 20062
81 | 20353
82 | 20642
83 | 20930
84 | 21216
85 | 21501
86 | 21784
87 | 22065
88 | 22344
89 | 22620
90 | 22895
91 | 23167
92 | 23437
93 | 23705
94 | 23970
95 | 24232
96 | 24491
97 | 24748
98 | 25001
99 | 25251
100 | 25498
101 | 25741
102 | 25981
103 | 26216
104 | 26448
105 | 26676
106 | 26899
107 | 27118
108 | 27333
109 | 27542
110 | 27746
111 | 27945
112 | 28138
113 | 28326
114 | 28507
115 | 28681
116 | 28848
117 | 29008
118 | 29160
119 | 29303
120 | 29437
121 | 29561
122 | 29673
123 | 29772
124 | 29857
125 | 29922
126 | 29958
Spreadsheet: 0307b4df-f7a2-4664-819f-ad908c8f236e
Sheet: Cost Responsibility

Cost Responsibility Detail Sheet
Indicate with an "x" whether the cost will be paid by the FSMC, the School Food Authority (SFA), or
the cost does not apply to the prospective contract.
 | Areas of Responsibility |  |  | FSMC |  | SFA |  | N/A
Food
 | Food Purchases
 | USDA Handling & Processing Charges
 | Processing and Payment of Invoices
Non-Food
Labor | FSMC Employees
 |  | Salary/Wages
 |  | Fringe Benefits & Insurance
 |  | Retirement
 |  | Payroll Taxes
 |  | Workers Compensation
 |  | Unemployment Compensation
 |  | Preparation & Processing of Payroll
 | SFA Employees
 |  | Wages
 |  | Fringe Benefits & Insurance
 |  | Retirement
 |  | Payroll Taxes
 |  | Workers Compensation
 |  | Unemployment Compensation
 |  | Preparation & Processing of Payroll
Miscellaneous/Additional Items
 | Cleaning/Janitorial Supplies
 | Paper/Disposable Supplies
 | Tickets/Tokens/I.D. System
 | Silverware/Glassware
 |  | Initial Inventory
 |  | Replacement During Operation
Telephone
 | Local
 | Long Distance
Uniforms
Linens
Laundry
 | Areas of Responsibility |  |  | FSMC |  | SFA |  | N/A
Trash Removal
 | From Kitchen
 | From Dining Area
 | From Premises
Pest Control
Equipment Replacement and Repair
 | Non-expendable
 | Expendable
Products and Public Liability
Insurance
Equipment Rental (explain)
Car/Truck Rental (explain)
Vehicle Maintenance
Storage Costs
Courier Services
Non-FSMC Employee Recruitment
Sales Tax
Other Taxes and Materials
Printing
Promotional Materials
Other (cannot include overhead expenses incurred by FSMC)
Cleaning Responsibilties
 | Preparation Areas
 | Serving Areas
 | Kitchen Floors
 | Dining Room Floors
 | Hoods, Duct Work
 | Routine Cleaning of Tables and Chairs
 | [NAME]
 | Light Fixtures
 | Windows
 | Grease Traps
 | Restrooms
Spreadsheet: 831414d1685621917-work-day-schedule-for-any-given-year-jsso-list-2023-r1
Sheet: Sheet1

JSSO Weekly Schedule for THW |  |  |  |  |  |  |  |  |  |  | 2023
Name | Date
[NAME]
BANDA
BELL
BELL-DREITZLER
BROUSSARD
BRYANT
COMEAUX
CORTELLESE
[NAME]
EVERETT
FONTENETTE
HAMPTON
HARDY
INCE
KASOWSKI
[NAME]
MOLNAR
NEMEC
NUTT
ODOM
O'NEAL
PAVLOCK
PETTAWAY
SANDERSON
SLAUGHTER
TAYLOR
TRAVELBEE
TRUJILLO
TULLOS
VALVANEDA
VELASQUEZ
WATT
WEBB
WHATLEY
[NAME]
YAPLE
Spreadsheet: 0478c1d9-8971-42cb-9381-88acdb976c25
Sheet: HIDE

Yes
No
 |  | List the lodge, section and national OA events at which the chapter will be represented. | Previous Year's Attendance | This Year's Goal | This Year's Actual Attendance
Lodge Events | 1.
 | 2.
 | 3.
 | 4.
 | 5.
Section Events | 1.
 | 2.
National Events | 1.
 | 2.
This year: | 2014
Last year: | 2013
Year before last: | 2012
Spreadsheet: 760965d1640572346-conditional-formatting-rag-icon-changes-based-on-responses-conditional-formatting
Sheet: Sheet1

[NAME]. | Time | Is your Investment Paper delayed? Yes/No | Is the delivery of the relevant BPC to Delayed (Yes/No)
Green |  | No | No
Amber |  | Yes | No
Amber |  | No | Yes |  | Unlikely
Red |  | Yes | Yes
[NAME]. | Cost | Do you anticipate there to be any risk to the spend planned to 31/03/22 (RY21/22 in the ABP? | Do you need to forecast spend in the next RY ( RY 2022/23) to complete the project? | Is it factored into the latest ABP Forecast?
Red |  | Yes | Yes | No
Red |  | No | Yes | No
Amber |  | Yes | Yes | Yes
Amber |  | Yes | No | N/A
Green |  | No | No | N/A
Green |  | No | Yes | Yes
[NAME]. | Scope | Has the current scope of the project changed from original BPC? | If yes, is this something which the [NAME] are aware of/has there been engagement with Franchise Management on this?
Green |  | No | - | If a no then blank out this cell
Red |  | Yes | No
Amber |  | Yes | Yes
Spreadsheet: 770561d1646151408-function-to-retrieve-values-on-second-tab-from-tables-on-the-first-tab-vlookup-question
Sheet: Stats

 |  | GOAL / NO GOAL | Home | Away | Total
 |  | Clean sheets | 54% | 8% | 31%
 |  | Won-to-nil | 46% | 8% | 27%
 |  | Scored in both halves | 31% | 46% | 38%
 |  | Both teams scored | 38% | 77% | 58%
 |  | Failed to score | 15% | 15% | 15%
 |  | Lost-to-nil | 8% | 15% | 12%
 |  | Conceded in both halves | 8% | 46% | 27%
 |  | GOAL / NO GOAL | Home | Away | Total
 |  | Clean sheets | 23% | 25% | 24%
 |  | Won-to-nil | 0% | 17% | 8%
 |  | Scored in both halves | 8% | 17% | 12%
 |  | Both teams scored | 54% | 50% | 52%
 |  | Failed to score | 46% | 33% | 40%
 |  | Lost-to-nil | 23% | 25% | 24%
 |  | Conceded in both halves | 15% | 58% | 36%
 |  | GOAL / NO GOAL | Home | Away | Total
 |  | Clean sheets | 23% | 54% | 38%
 |  | Won-to-nil | 23% | 23% | 23%
 |  | Scored in both halves | 15% | 8% | 12%
 |  | Both teams scored | 54% | 23% | 38%
 |  | Failed to score | 23% | 54% | 38%
 |  | Lost-to-nil | 23% | 23% | 23%
 |  | Conceded in both halves | 15% | 15% | 15%
Spreadsheet: 130977d1322675956-if-match-and-somewhere-close-to-excelforum-help-sheet
Sheet: Sheet1

Creator SSN | Owner [NAME] | Projected Opportunity Amount | Contract Number | Contract Amount $
1 | Last Name 1 | 123456
2 | Last Name 2 | 50 | 010456011
3 | Last Name 3 | 27 | 010456012
4 | Last Name 4 | 11155522
5 | Last Name 5 | 4595 | 010456014
6 | Last Name 6 | 34564 | 010456015
7 | Last Name 7 | 15444851
8 | Last Name 8 | 12154 | 010456017
9 | Last Name 9 | 1 | 010456018
10 | Last Name 10 | 23564 | 010456019
11 | Last Name 11 | 7454 | 010456020
12 | Last Name 12 | 986532 | 010456021
13 | Last Name 13 | 124 | 010456022
14 | Last Name 14 | 3544 | 010456023
15 | Last Name 15 | 575416 | 010456024
16 | Last Name 16 | 21246 | 010456025
17 | Last Name 17 | 54 | 010456026
Spreadsheet: 114079d1309944361-sumif-index-and-match-function-summary
Sheet: Summary

 |  |  |  |  |  |  | Creditcard
 |  |  |  |  |  |  | LOC
 |  |  |  |  |  |  | RM
 |  |  |  |  |  |  | Team
Team | RM | Creditcard | LOC
Team 1 | apple | 5 | 0 |  |  | I renamed your other file as Source.xls, and the relevant sheet as DataA, just to make
Team 1 | [NAME] | 4 | 0 |  |  | writing the formulae shorter.
Team 1 | [NAME] | 0 | 0
Team 2 | apple | 10 | 0 |  |  | I then created named ranges in this workbook as shown above.
Team 2 | [NAME] | 0 | 55 |  |  | These are dynamic ranges, so they will adjust as you add more data within rows 12 and 98 of the source sheet.
 |  |  |  |  |  | You can create named ranges in the same way for other products, and produce results for them as well.
Spreadsheet: mary_fischer__25442__roi_version_2
Sheet: Value Workbook Overview

 | Workbook Objective: Calculate the business value that [NAME] asset management solutions can deliver.
 | Workbook Components:
 | 1) Value Area Map that categorizes and displays the business areas where DSTM delivers value
 | 2) Value Summary page that rolls up and displays the total business value delivered
 | 3) Financials Worksheets that show how the delivered business value will impact the Financial Statements
 | Income Statement
 | Balance Sheet and Cash Flow Improvements
 | Key Financial Ratios
 | 4) Surveys that will be used to collect company data in each of the Value Areas
 | General Company Financial Information
 | MRO Supply Chain
 | Workforce Management
 | I/T
 | Capital Asset Investment
 | Asset Productivity
 | Operating Risk
 | 5) Value Calculators that take the collected data, make a judgment about the size of the value opportunity (High, [NAME], Low), and apply industry benchmarks to estimate the value delivered
 | MRO Supply Chain
 | Workforce Management
 | I/T
 | Capital Asset Investment
 | Asset Productivity
 | Operating Risk
Spreadsheet: 105935d1303214237-extracting-items-via-a-logical-outcome-of-rorm-controls-excel-forum-question
Sheet: Sheet1

1
2
9
 |  |  | Item in
 |  |  | Use |  |  | ITEMS
 | 1 |  |  | Item1
 | 1 |  |  | Item2
 |  |  |  | Item3
 |  |  |  | Item4
 |  |  |  | Item5
 |  |  |  | Item6
 |  |  |  | Item7
 |  |  |  | Item8
 | 1 |  |  | Item9
 | 0 |  |  | Item10
 |  |  |  | Item11
 |  |  |  | Item12
 |  |  |  | Item13
 |  |  |  | Item14
 | 0 |  |  | Item15
Spreadsheet: 91733d1291397861-combine-totals-book1
Sheet: Sheet1

 | labpc1 | labpc2 | labpc3 | labpc4 | labpc5 | [NAME] | labpc7 | labpc8 | labpc9 | labpc10
user1 | 1
user2 |  |  |  | 1
user1 | 1
user3 |  | 1
user3 |  |  |  |  |  |  |  |  |  | 1
user2 |  |  |  |  |  | 1
user1 |  |  |  |  |  |  |  |  | 1
user4 |  |  | 1
user3 | 1
user1 |  | 1
user2 |  | 1
Spreadsheet: 684098d1593140949-dyamic-match-with-excel-dynamic-match-row-problem
Sheet: 1

 | 1. Quarterly Financial Statements
 | USD, FYE Sep-2023
 | BOP
 | EOP
 | Transaction date
 | (Income Statement)
 | Days
 | Off-hire days
 | Charter rate
 | Gross revenue
 | Brokers commission
 | Net revenue
 | Opex
 | Technical management fee
 | Commercial management fee
 | Administration costs
 | Sale commission
 | Total Expenses
 | EBITDA
 | Amortization of financing fees
 | Amortization of 1st dry-docking fees
 | Amortization of 2nd dry-docking fees
 | Amortization of 3rd dry-docking fees
 | Depreciation of vessel
 | Depreciation & amortization
 | EBIT
 | Super senior loan
 | Senior loan
 | Interest Expense
 | Gain/loss on sale of vessel
 | Profit before Tax
 | Income Tax
 | Profit after Tax
 | USD, FYE Sep-2023
 | BOP
 | EOP
 | (Cash Flow Statement)
 | Net income
 | Depreciation and amortization
 | (Gain)/loss on sale of vessel
 | Cash to liquidity reserves
 | Cash from operating activities
 | Payments to docking reserve
 | Payments from docking reserve
 | Top-up for DD costs shortfall
 | Sale of vessel
 | Dry-docking costs
 | Cash from investing activities
 | Mandatory payments - super senior loan
 | Mandatory payments - senior loan
 | Balloon repayment - super senior loan
 | Balloon repayment - senior loan
 | Cash after mandatory payments
 | Cash from liquidity reserves
 | Cash from dry-docking reserves
 | Cash borrowed from shipping pool
 | Cash returned to shipping pool
 | Cash loan to shipping pool
 | Cash returned from shipping pool
 | Post-other vessels drawndown/payment
 | Cash sweep for senior loan
 | Net change in cash
 | Beginning cash
 | Net change in cash
 | Ending cash