tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 249217d1373465207-formatting-with-traffic-lights-iconesformata-o
Sheet: Plan1

 |  |  |  |  |  | Formatting
 | Green | (30...) | 0.3 | 20 | 5 |  | <-- It should be yellow
 | Yellow | (20-29) | 0.2 | 85 | 80
 | Red | (0-19) | 0 | 61 | 55
 |  |  |  | 82 | 75
 |  |  |  | 86 | 73
 |  |  |  | 90 | 82
 |  |  |  | 73 | 69
 |  |  |  | 69 | 57
 |  |  |  | 92 | 72
 |  |  |  | 76 | 69
 |  |  |  | 96 | 87
 |  |  |  | 68 | 52
 |  |  |  | 101 | 94
 |  |  |  | 92 | 75
 |  |  |  | 79 | 75
 |  |  |  | 97 | 83
 |  |  |  | 57 | 46
 |  |  |  | 102 | 85
 |  |  |  | 70 | 65
 |  |  |  | 78 | 66
 |  |  |  | 71 | 63
 |  |  |  | 73 | 67
 |  |  |  | 90 | 69
 |  |  |  | 39 | 27
 |  |  |  | 62 | 50
 |  |  |  | 79 | 62
 |  |  |  | 61 | 45
 |  |  |  | 84 | 64
Spreadsheet: 0106454e-a4fb-4227-acd0-a51126af46fe
Sheet: Country

Country | Titles | Percentage
France | 64
Germany | 45
Italy | 34
Spain | 31
Russia | 27
Sweden | 24
Argentina | 18
Japan | 18
Norway | 16
Israel | 14
China | 12
Poland | 12
South Korea | 12
Quebec | 11
Turkey | 11
Denmark | 10
Indonesia | 9
Netherlands | 9
Brazil | 8
Austria | 7
Finland | 7
Iceland | 6
Iran, Islamic Republic of | 6
Mexico | 6
Switzerland | 6
Algeria | 5
Chile | 5
Greece | 5
Hungary | 4
Iraq | 4
Portugal | 4
Romania | 4
Belgium | 3
Bulgaria | 3
Cuba | 3
Czech Republic | 3
Egypt | 3
India | 3
Lebanon | 3
Morocco | 3
Peru | 3
Various | 3
Estonia | 2
Ireland | 2
Lithuania | 2
Puerto Rico | 2
Syrian Arab Republic | 2
Taiwan | 2
Ukraine | 2
Viet Nam (Vietnam) | 2
Albania | 1
Armenia | 1
Azerbaijan | 1
Belarus | 1
Cameroon | 1
Colombia | 1
Congo | 1
Costa Rica | 1
Croatia | 1
Dominican Republic | 1
Ecuador | 1
Guatemala | 1
Haiti | 1
Latvia | 1
Mozambique | 1
Oman | 1
Pakistan | 1
Saudi Arabia | 1
Serbia and Montenegro | 1
Slovenia | 1
South Africa | 1
Togo | 1
Venezuela | 1
Wales | 1
Spreadsheet: 741696d1627282861-exclude-certain-text-from-results-using-formula-top-10-forum-book-2-
Sheet: Poor or Dead

Species | Poor/Dead Count | Species Count | Percentage of Species |  |  | Top 10 Poor or Dead Condition
Betula nigra | 53 | 11 | 0.3636363636363636 |  | Top | Poor or Dead | Count
Carpinus caroliniana | 16 | 30 | 0.1333333333333333 |  | 1 |  |  |  |  | 53 |  |  | 53
Chionanthus virginicus | 16 | 23 | 0.1304347826086956 |  | 2 | Chionanthus virginicus |  |  | Chionanthus virginicus | 16 |  | Chionanthus virginicus | 16
Ilex cornuta | 1 | 152 | 0.006578947368421052 |  | 3 | Ilex x attenuata 'East Palatka' |  |  | Ilex x attenuata 'East Palatka' | 11 |  | Ilex x attenuata 'East Palatka' | 11
Ilex opaca | 2 | 7 | 0.2857142857142857 |  | 4 | Lagerstroemia indica |  |  | Lagerstroemia indica | 10 |  | Lagerstroemia indica | 10
Ilex vomitoria | 3 | 24 | 0.125 |  | 5 | Ligustrum japonicum |  |  | Ligustrum japonicum | 10 |  | Ligustrum japonicum | 10
Ilex x attenuata 'East Palatka' | 11 | 40 | 0.05 |  | 6 | Liriodendron tulipifera |  |  | Liriodendron tulipifera | 9 |  | Liriodendron tulipifera | 9
Lagerstroemia indica | 10 | 732 | 0.01639344262295082 |  | 7 | [NAME] shumardii |  |  | [NAME] shumardii | 9 |  | [NAME] shumardii | 9
Ligustrum japonicum | 10 | 33 | 0.0303030303030303 |  | 8 | Taxodium ascendens |  |  | Taxodium ascendens | 7 |  | Taxodium ascendens | 7
Ligustrum lucidum | 1 | 2 | 0.5 |  | 9 | Prunus cerasifera '[NAME] |  |  | Prunus cerasifera '[NAME] | 6 |  | Prunus cerasifera '[NAME] | 6
Liriodendron tulipifera | 9 | 60 | 0.15 |  | 10 | Quercus virginiana |  |  | Quercus virginiana | 5 |  | Quercus virginiana | 5
Magnolia grandiflora '[NAME] Brown Beauty' | 1 | 16 | 0.0625
Magnolia virginiana | 4 | 34 | 0.1176470588235294
Morella cerifera | 3 | 11 | 0.2727272727272727
Morus alba | 2 | 2 | 1 |  |  | Exclude from List using the formula and not helper column
Osmanthus fragrans | 3 | 29 | 0.103448275862069 |  |  | Carpinus caroliniana
Pinus palustris | 1 | 48 | 0.02083333333333333 |  |  | Ulmus parvifolia
Pinus taeda | 1 | 53 | 0.01886792452830189 |  |  | [NAME] shumardii
Prunus cerasifera '[NAME] | 6 | 35 | 0.1428571428571428
Prunus x '[NAME] | 2 | 5 | 0.4 |  |  | and return the next qualifying result.
Quercus michauxii | 4 | 9 | 0.4444444444444444
Quercus nigra | 2 | 8 | 0.25
[NAME] shumardii | 9 | 41 | 0.2195121951219512
Quercus virginiana | 5 | 141 | 0.03546099290780142
Sabal palmetto | 1 | 27 | 0.03703703703703703
Salix babylonica | 1 | 1 | 1
Taxodium ascendens | 7 | 65 | 0.1076923076923077
Taxodium distichum | 1 | 5 | 0.2
Ulmus parvifolia | 12 | 84 | 0.1428571428571428
Spreadsheet: 752103d1634581190-automatically-copying-data-from-a-main-tab-to-another-ip-video-service-ticket-template
Sheet: GENERAL INFO

JOB NUMBER | SITE NAME |  | VMS |  | CAMERA MODEL | FIRMWARE | TOTAL
"Enter info here" | "Enter info here" |  | "VMS Name & Version" |  | "Enter info here" | "Enter info here" | "Enter info here"
ADDRESS |  |  | CCTV & CALLUP WORKSTATIONS |  | "Enter info here" | "Enter info here" | "Enter info here"
"Enter info here" |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
TEAMVIEWER INFO |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
"ID/Password" |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)" |  | "Enter info here" | "Enter info here" | "Enter info here"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)" |  | RECORD RTSP SYNTAX
 |  |  | "WS Name (IP address)" |  | "Enter info here"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)" |  | LIVE RTSP SYNTAX
 |  |  | "WS Name (IP address)" |  | "Enter info here"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)"
 |  |  | "WS Name (IP address)"
Spreadsheet: 584108d1532974866-count-unique-values-with-criteria-and-blanks-and-an-average-of-maximum-consecutive-values-inique-values
Sheet: Sheet1

Consecutive | Serial | Time | shift | Composite | Unique | Run | MAX |  | Total | Night | Day
 | 80717 | 12:59:00 |  |  |  |  |  | Average consecutive change |  |  |  |  | 12:00:00
 | 100415 | 09:04:00 |  |  |  |  |  | Unique values
 | 071213G | 03:34:00
 | 071213G | 03:51:00
 | 071213G | 04:10:00
 | 071213G | 04:25:00
 | 071213G | 04:42:00
 | 071213G | 05:00:00
 | 071213G | 05:16:00
 | 071213G | 05:18:00
 | 071213G | 10:52:00
 | 071213G | 11:28:00
 | 071213G | 11:50:00
 | 100902G | 00:43:00
 | 100902G | 00:59:00
 | 100902G | 01:22:00
 | 100902G | 01:38:00
 | 100902G | 01:55:00
 | 100902G | 02:12:00
 | 100902G | 10:19:00
 | 100902G | 10:41:00
 | 100902G | 10:59:00
 | 100902G | 11:26:00
 | 100902G | 11:44:00
 | 100902G | 12:07:00
 | 100902G | 12:27:00
 | 100904G | 12:28:00
 | 100904G | 12:50:00
 | 100912G | 05:48:00
 | 100912G | 06:31:00
 | 100912G | 06:52:00
 | 100912G | 07:10:00
 | 100912G | 07:25:00
 | 100912G | 07:42:00
 | 100917G | 03:10:00
 | 100917G | 03:26:00
 | 100917G | 03:30:00
 | 100917G | 03:50:00
 | 100917G | 03:54:00
 | 100917G | 04:11:00
 | 100917G | 04:14:00
 | 100917G | 04:33:00
 | 100917G | 04:39:00
 | 100917G | 04:56:00
 | 100917G | 05:13:00
 | 100917G | 08:10:00
 | 100917G | 08:36:00
 | 100917G | 08:55:00
 | 100917G | 09:13:00
 | 100917G | 09:29:00
 | 100917G | 09:49:00
 | 100917G | 16:04:00
 | 100917G | 16:19:00
 | 100917G | 16:34:00
 | 100917G | 16:56:00
 | 100917G | 17:34:00
 | 100917G | 17:59:00
 | 100917G | 18:35:00
 | 120911G | 02:39:00
 | 120911G | 02:57:00
 | 120911G | 19:04:00
 | 120911G | 19:33:00
 | 120911G | 20:00:00
 | 120911G | 20:38:00
 | 120911G | 20:57:00
 | 120911G | 21:16:00
 | 120911G | 21:35:00
 | 120911G | 21:57:00
 | 120913G | 05:55:00
 | 120913G | 06:42:00
 | 120913G | 06:57:00
 | 120913G | 07:11:00
 | 120913G | 07:28:00
 | 120913G | 07:46:00
 | 120913G | 08:13:00
 | 120913G | 08:30:00
 | 120916G | 00:18:00
 | 120916G | 00:53:00
 | 120916G | 01:10:00
 | 120916G | 01:35:00
 | 120916G | 02:07:00
 | 120916G | 13:28:00
 | 120916G | 13:48:00
 | 120916G | 14:06:00
 | 120916G | 14:25:00
 | 120916G | 14:45:00
 | 120916G | 15:01:00
 | 120916G | 15:17:00
 | 120916G | 15:35:00
 | 120916G | 22:03:00
 | 120916G | 22:19:00
 | 120916G | 22:35:00
 | 120916G | 22:42:00
 | 120916G | 22:56:00
 | 120916G | 23:02:00
 | 120916G | 23:19:00
 | 120916G | 23:25:00
 | 120916G | 23:46:00
 | 120916G | 23:59:00
Spreadsheet: benjamin_rogers__944__PJMPosMgr
Sheet: EOL LINKS

Product ID | Bid price | Offer Price |  | Actual time stamp | Description | 14 | Enter number of products |  | Min | [NAME] | Power Row | Gas Row
30187 | 34.65 | 35.15 | 988116575035 | 2001-08-31 13:02:31 | Q-4 01 |  | Next Day HeatRate |  | 9731 | 9731 | 5 | 6
30188 | 38.25 | 39.25 | 988040938678 | 2001-08-31 12:49:51 | FG-02 |  | [NAME] |  | 8739 | 8739 | 3 | 6
30190 | 33.65 | 34.65 |  | 2001-08-31 12:50:12 | HJ-02
30192 | 35.4 | 36.4 |  | 2001-08-31 12:49:59 | K-02
30193 | 43.2 | 44.2 |  | 2001-08-31 12:50:00 | M-02
30194 | 56.75 | 58.25 | 988117645653 | 2001-08-31 13:03:27 | NQ-02 |  | Prompt Month HeatRate |  | 9134 | 9354 | 2 | 4
30195 | 34.35 | 35.35 |  | 2001-08-31 12:50:10 | U-02
30196 | 34.15 | 35.15 |  | 2001-08-31 13:03:24 | Q4-02 |  | JUNE4-8 |  | 8739 | 8739
32930 | 38.75 | 39.75 | 988054237081 | 2001-08-31 10:07:31 | CAL-02 |  | 29-31 |  | 8739 | 8739
49613 | 2.29 | 2.305 | 988117673560 | 2001-08-29 14:20:40 | Sep Naty |  | 2001-06-01 00:00:00
49615 | 2.4 | 2.41 | 988117189925 | 2001-08-31 14:58:21 | [NAME]
49617 | 2.73 | 2.7425 | 988116717414 | 2001-08-31 14:58:21 | Nov Naty
35353 | 3.065 | 3.075 | 988117635766 | 2001-08-31 14:42:28 | Nov-Mar 01
48724 | 3.19 | 3.205 | 988117122150 | 2001-08-31 12:53:44 | [NAME]
54674 | 3.6 | 3.61 |  | 2001-08-20 13:11:48 | Apr-Oct Naty
51173 | 29 | 30 |  | 2001-05-29 09:45:21 | [NAME]
32218 | 43 | 44 |  | 2001-08-20 08:39:05 | Q-4 01 G
32219 | 50.5 | 51.5 |  | 2001-08-20 08:40:36 | FG-02 G
32224 | 52.5 | 54 |  | 2001-05-23 15:54:03 | [NAME]
32226 | 31.75 | 32.75 |  | 2001-05-23 15:54:03 | Q4-02 G
3751 | 31.75 | 32.75 |  | 2001-05-23 15:54:03 | [NAME]
26117 | 31.75 | 32.75 |  | 2001-05-23 15:54:03 | [NAME]
48506 | 31.75 | 32.75 |  | 2001-05-23 15:54:03 | Cin K-02
26116 | 31.75 | 32.75 |  | 2001-05-23 15:54:03 | Cin M-02
Spreadsheet: 794679d1662209072-dynamic-array-formula-to-indicate-which-rows-are-visible-and-which-are-not-2022-09-03-oeldere2-marbleking-test_visibility_of_rows
Sheet: Sheet1

Helper | Data
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
Spreadsheet: 3e070bc7-f86e-4d77-8b7b-b43e8c81f414
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
CYSPR | Test | CYSPR | Cyclosporine, Blood | Cyclosporine, B | High-Performance Liquid Chromatography-Tandem Mass Spectrometry (HPLC-MS/MS) | EDTA (lavender-top) tube: EDTA |  |  | 5 | mL | Container/Tube: Lavender top (EDTA) [NAME]: 3 mL Collection Instructions:  1. Draw specimen immediately before a scheduled dose. 2. Do not centrifuge.  3. Send specimen in original tube. Additional Information:  1. Therapeutic range applies to trough specimens drawn immediately prior to a.m. dose. 2. For specimens sent ambient, sirolimus analysis cannot be performed; if both are ordered, only cyclosporine result will be released. If sirolimus analysis is desired, specimen must be sent refrigerated or frozen. | 1 mL | Hemolysis	Mild OK; Gross OK Thawing	Cold OK; Warm reject Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | 100-400 ng/mL | Monday through Sunday; 1 p.m. | Same day/1 day | 1 day | 1 | 80158 |  |  |  |  | Rochester
CYSPR | [NAME] | WBEDTA | [NAME] EDTA |  |  |  | Refrigerated | 14 days
CYSPR | Result | 35143 | Cyclosporine, B | Cyclosporine, B | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 3520-4 | Cyclosporine:MCnc:Pt:[NAME]:Qn:
Spreadsheet: b5b222a9-08e4-48ed-b72b-09aea9fd9213
Sheet: Sheet1

Name | Address | City | State | ZIP | Phone | County
Lowe's Home Centers, Inc. (Lowes) | 124 CHARLES BLACKBURN DRIVE | Mountain Home | AR | 72653 | (870)492-1000 | BAXTER
Lowe's Home Centers, Inc. (Lowes) | 4330 EAST MCCAIN BOULEVARD | NORTH LITTLE ROCK | AR | 72117 | (501)955-2219 | PULASKI
Lowe's Home Centers, Inc. (Lowes) | 300 CORNER STONE BLVD. | HOT SPRINGS | AR | 71913 | (501)525-2233 | GARLAND
Lowe's Home Centers, Inc. (Lowes) | 1325 HWY. 64 WEST | CONWAY | AR | 72032 | (501)513-3300 | FAULKNER
Lowe's Home Centers, Inc. (Lowes) | 2301 T.P. WHITE DRIVE | JACKSONVILLE | AR | 72076 | (501)241-1500 | PULASKI
Lowe's Home Centers, Inc. (Lowes) | 2330 NORTH REYNOLDS ROAD | BRYANT | AR | 72022 | (501)213-2000 | SALINE
Lowe's Home Centers, Inc. (Lowes) | 3701 EAST RACE AVENUE | SEARCY | AR | 72143 | (501)203-1000 | WHITE
Lowe's Home Centers, Inc. (Lowes) | 300 NORTH 46TH ST. | ROGERS | AR | 72756 | (479)936-9700 | BENTON
Lowe's Home Centers, Inc. (Lowes) | 3011 PARKWAY EAST | RUSSELLVILLE | AR | 72802-2004 | (479)890-3018 | [NAME]
Lowe's Home Centers, Inc. (Lowes) | 4233 WEST SUNSET AVE | SPRINGDALE | AR | 72762 | (479)717-4000 | WASHINGTON
Lowe's Home Centers, Inc. (Lowes) | 1100 N.W. LOWES AVENUE | BENTONVILLE | AR | 72712 | (479)657-7500 | BENTON
Lowe's Home Centers, Inc. (Lowes) | 1050 ZION ROAD | FAYETTEVILLE | AR | 72703 | (479)587-9000 | WASHINGTON
Lowe's Home Centers, Inc. (Lowes) | 3499 HIGHWAY 412 E | SILOAM SPRINGS | AR | 72761 | (479)549-9923 | BENTON
Lowe's Home Centers, Inc. (Lowes) | 2120 FAYETTEVILLE ROAD | [NAME] | AR | 72956 | (479)494-4470 | CRAWFORD
Lowe's Home Centers, Inc. (Lowes) | 8001 ROGERS AVE. | Fort Smith | AR | 72903 | (479)452-6000 | SEBASTIAN
Lowe's Home Centers, Inc. (Lowes) | 3231 [NAME]. | FAYETTEVILLE | AR | 72704 | (479)387-3007 | WASHINGTON
[NAME], Inc | 7620 [NAME] | North Little Rock | AR | 72117
Home Depot | 4325 E McCain Blvd | Little Rock | AR | 72117
Lafferty's Home Center | 5025 West Park Blvd. | Texarkana | TX | 75503
Lowes | 4330 East McCain Blvd | Little Rock | AR | 72117
Metro Appliance & More | 8800 Maumelle Blvd | Little Rock | AR | 72113
Sears | 301 Fairview | [NAME] | AR | 71635
SEARS | 301 FAIRVIEW | CROSSETT | AR | 71635
TUCKERS APPLIANCE | 5260 WEST SUNSET AVE | RINGDALE | AR | 72762
Spreadsheet: 230270d1366727518-populating-data-from-another-sheet-using-a-drop-down-list-basicvlookup
Sheet: Data

Item | Data1 | Data2 | Data3 | Data4 | Data5 | Data6 | Data7 | Data8 | Data9 | Data10 | Data11
A | 644 | 785 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333 | 333
B | 618 | 343 | 905 | 905 | 905 | 905 | 905 | 905 | 905 | 905 | 905
C | 894 | 89 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210 | 210
D
E
F
G
H
Spreadsheet: phillip_m_love__30683__onsys forms 0003
Sheet: Pennzoil

Pennzoil
Contract: N58941.1 | 2000-03-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 0 | 0
VALUE | 0 | 11697
NET RATE |  |  |  | 2.54
Volume Variance:
 | 0 | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 | -11697 | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
Liquidation no flow - goes with [NAME]
Spreadsheet: 732452d1620967450-trying-to-populate-cells-in-a-specific-order-on-a-sheet-with-data-from-an-unsorted-sheet-book-1
Sheet: S-W Jr's

Summit-Wasatch Cnty Team Total Points: |  |  |  |  |  |  | Summit-Wasatch Jrs RANK:
S-W | Test Review Ends at 1:30 pm
Test |  |  |  |  |  | Showmanship
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Horsemanship |  |  |  |  |  | Bareback Equitation on the Rail
Rank | [NAME] | Score | Points |  |  | Rank | [NAME] | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Barrels |  |  |  |  |  | Poles
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Time | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Event Top 5 Total Points:
Keyhole |  |  |  |  |  | Portfolio
Rank | [NAME] | Time | Ribbon | Points |  | Rank | [NAME] | Score | Ribbon | Points
1 |  |  |  |  |  | 1
2 |  |  |  |  |  | 2
3 |  |  |  |  |  | 3
4 |  |  |  |  |  | 4
5 |  |  |  |  |  | 5
6 |  |  |  |  |  | 6
7 |  |  |  |  |  | 7
8 |  |  |  |  |  | 8
 | Event Top 5 Total Points: |  |  |  |  |  | Bonus Top 5 Total Points:
 | Summit-Wasatch County Team Total Points: |  |  |  |  |  | Maximum event points possible is 75                                           Maximum team points possible is 600
Spreadsheet: 92061d1291736105-how-do-i-copy-a-value-to-from-one-sheet-to-another-by-looking-up-values-in-3-columns-registration-workbook
Sheet: Collectives

For all new rows, copy the formulas from the row above.  To hide blanks, choose the Registration_Num filter, and de-select Blanks. |  | Enter Date in Format MM/DD/YYYY | For Phone Number: Enter area code and 7 digit phone number without spaces or dashes |  | For all new rows, copy the formulas from the row above | Enter Date in Format MM/DD/YYYY | Enter any relevant notes (include date and your initials).
 |  |  | Public Education Program Information
Registration_Num | Registrant_Name | Date_Prog_In_Place | Educ_Phone | Educ_Web | E-document_Link | Date_of_Last_Update | Notes
 |  | 2011-01-01 00:00:00 | 8455551234 | www.abccollectiveweb.com |  | 2010-12-06 00:00:00
 |  | 2011-01-01 00:00:00 | 5555558888 | www.websitehere.com |  | 2010-12-06 00:00:00
Spreadsheet: 466608d1466327757-look-up-data-from-two-sheets-and-give-a-result-on-a-third-sheet-service-plan-quotes-vs-car-sales-prc
Sheet: Results

Registration # | Plan Quoted? | [NAME]? | [NAME]
 |  |  |  |  | Sold (Yes/No) | Yes
 |  |  |  |  | RegistrationNumber | Quoted (Yes/No) | Sold | Group3
 |  |  |  |  | BC02CFC | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | DL11VMD | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | GU12JYW | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | GU13PYL | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | GU14HUA | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | GY16WWG | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | GY16WWH | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | R20BDB | Yes | Sold by: [NAME] | April Poston
 |  |  |  |  | SM64WTE | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | VK15HPC | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | YB15DWA | Yes | Sold by: [NAME] | [NAME]
 |  |  |  |  | YE14HSZ | Yes | Sold by: [NAME] | April Poston
Spreadsheet: 760414d1640193187-function-for-searching-the-upper-parent-in-a-company-structure-upper-parent
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | Entity: | Parent:
1 | Entity 1
2 |  | Entity 2
3 |  | Entity 3
4 |  |  | Entity 4
5 |  |  |  | Entity 5
6 |  |  |  |  | Entity 6
7 |  |  |  |  |  | Entity 7
8 |  |  |  |  |  |  | Entity 8
9 |  |  |  |  |  |  |  | Entity 9
10 |  |  |  |  |  | Entity 10
11 |  |  |  |  |  | Entity 11
12 |  |  |  |  |  |  | Entity 12
13 |  | Entity 13
14 |  |  | Entity 14
15 |  | Entity 15
16 |  |  | Entity 16
Spreadsheet: 549985d1512031004-abc-on-not-sorted-data-zeszyt2
Sheet: Arkusz1

 |  |  | units sold | rank | Units Sold/SUM
 |  |  | 1
 |  |  | 2
 |  |  | 4
 |  |  | 6
 |  |  | 3
 |  |  | 1
 |  |  | 5
 |  |  | 6
 |  |  | 12
 |  |  | 4
 |  |  | 9
Spreadsheet: vkaminski__40901__CASH_EPE_0400MyCopy
Sheet: Ref5

[NAME]
 |  |  |  |  |  |  |  | Person(s)
 |  | Current |  |  |  |  | Date Of | Responsible
Assumption Category | Assumption Description | Assumption |  |  |  | Assumption Reference | Reference | For Assumption | Comments
 |  |  |  |  |  | Financing Plan | 1999-08-19 00:00:00 | [NAME] | Awaiting Final Termsheets
 |  |  |  |  |  | Financing Plan | 1999-08-19 00:00:00 | [NAME] | Awaiting Final Termsheets
 |  |  |  |  |  | Financing Plan | 1999-08-19 00:00:00 | [NAME] | Awaiting Final Termsheets
 |  | Minimum | Average
 | Target DSCR |  |  |  |  | [NAME] | 1999-01-06 00:00:00 | [NAME] | Per Conversations With OPIC
 | Pre-Tax DSCR |  |  |  |  | Calculation
 | After-Tax DSCR |  |  |  |  | Calculation
 |  |  |  |  |  | [NAME] | 1999-08-17 00:00:00 | [NAME] | Need Documentation
 |  |  |  |  |  | [NAME] | 1999-05-10 00:00:00 | [NAME] | Need Documentation
 |  |  |  |  |  | [NAME] | 1999-05-10 00:00:00 | [NAME] | Need Documentation
 |  |  |  |  |  | Calculation |  |  | Estimated Requirement Until Financing
 |  |  |  |  |  | Shareholder's Agreement | 1998-07-28 00:00:00 | [NAME] | Schedule 1
 |  |  |  |  |  | Enron Cost Of Funds | 1999-02-26 00:00:00 | [NAME] | Memo From Jeff Sommers
 |  |  |  |  |  | Power Purchase Contract | 1997-11-25 00:00:00 | J. Bestard | Clause 7
 |  |  |  |  |  |  | ??? |  | Need Documentation
 |  |  |  |  |  |  | ??? |  | Need Documentation
 |  |  |  |  |  | Standard Assumption
 |  | Period | Amount | W/C Rate | W/C Fee
 |  |  |  |  |  | Standard Calculations
 |  |  |  |  |  | Standard Calculations
 |  |  |  |  |  | Standard Calculations
 |  |  |  |  |  | Standard Calculations