tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 796820d1663579861-amending-a-formula-to-change-the-result-from-highest-to-lowest-ramsey-marvo-aligw
Sheet:  Master

 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  | Stroke Index |  |  |  |  |  |  |  | HANDICAPPING ALTERATIONS
1 | PLAYER | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  |  | PAR | PTS | Playing H'Cap |  |  |  | HANDICAP | NEW |  |  | 36 | Winners | Other |  | H'cap |  | catagory
1 |  | S/I |  | 17 |  | 5 |  | 9 |  | 15 |  | 3 |  | 1 |  | 7 |  | 13 |  | 11 |  | 8 |  | 12 |  | 16 |  | 2 |  | 10 |  | 4 |  | 18 |  | 14 |  | 6 | GROSS | NETT | 3 |  | S/I 1 | S/I 2 | S/I 3 | POST | CHANGE | HANDICAP |  |  |  | Cuts | Cuts | Increase | Change
0 | ADAMS (Brian)
0 | ADAMS ([NAME])
1 | BATTERBEE ([NAME])
0 | BAXTER (Nick)
1 | BENNETT ([NAME])
0 | BROMLEY ([NAME])
0 | CURT ([NAME])
1 | CURT (Sean)
0 | DERBYSHIRE ([NAME])
1 | DONNELLY ([NAME])
0 | DOWNER ([NAME])
1 | [NAME] ([NAME])
0 | GELLMAN ([NAME])
0 | GIBOIN ([NAME])
1 | GROUT ([NAME])
0 | [NAME] (Stuart)
1 | [NAME])
1 | [NAME] ([NAME])
1 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
1 | KOLEK ([NAME])
1 | KOLEK ([NAME])
1 | LEECH ([NAME])
1 | LEECH ([NAME])
1 | LEONARD ([NAME])
1 | LEONARD ([NAME])
1 | [NAME] ([NAME])
1 | LOOM (Scott)
1 | MARVESLEY ([NAME])
0 | MCGILLIVRAY ([NAME])
0 | MCINTYRE ([NAME])
0 | MCKENZIE ([NAME])
0 | MEMOLI ([NAME])
1 | MITCHELL ([NAME])
1 | MOSS ([NAME])
1 | MUNTING ([NAME])
0 | NOONS (Martin)
0 | [NAME] ([NAME])
0 | [NAME] ([NAME])
0 | PYM ([NAME])
0 | SMITH ([NAME])
1 | SMITH ([NAME])
0 | TAYLOR ([NAME])
1 | VANN (Martin)
0 | ANDREWS ([NAME])
0 | ATKINS (Allen)
0 | BUCKLE (Eugene)
0 | BURNETT ([NAME])
0 | CLARKE ([NAME])
0 | CRONIN ([NAME])
0 | [NAME] ([NAME])
0 | FAWCETT ([NAME])
0 | HAMMOND ([NAME])
0 | KING ([NAME])
0 | [NAME] (Trevor)
0 | MCDONALD ([NAME])
0 | PRESTON ([NAME])
0 | SPENCER ([NAME])
1 | THORPE ([NAME])
1 | VALENTINE ([NAME])
0 | WARREN (Derek)
0 | WEEKS ([NAME])
1 | WILLS (Stuart)
0 | WOODFORD ([NAME])
 | Number of Players
 | SKINS
 | 1
 |  | HOLE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18 | Total |  |  |  |  |  |  |  |  |  |  |  | Total Cuts
 |  | PAR |  | 4 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4 |  | 4 |  | 4 |  | 5 |  | 3 |  | 4 |  | 4 |  | 5 |  | 4 |  | 4 |  | 3 |  | 5 |  | 4
 |  | S/I |  | 16 |  | 4 |  | 18 |  | 14 |  | 10 |  | 8 |  | 2 |  | 12 |  | 6 |  | 7 |  | 15 |  | 13 |  | 5 |  | 9 |  | 1 |  | 17 |  | 11 |  | 3 | GROSS
 | Average Score
 | PARS
 | BIRDIES
 | Total Score
Spreadsheet: 844565d1696342494-hi-i-need-a-few-things-adding-or-changing-on-this-fishing-results-workbook-please-golborne-results-2024
Sheet: 3

Name | lbs | oz | Oz (total) | Points
 | 99999999
 | 435
 | 35
 | 66
 | 43
 | 466
 | 26
Spreadsheet: 679702d1590592516-copy-date-if-total-in-adjacant-column-is-more-than-or-equal-to-18-date-if-total-is-more-than-or-equal-to-18
Sheet: Sheet1

1
Property Address | Date of Lease | Lease Cost PWPR | No of Rooms
PROPERTY 01 | 2021-01-01 00:00:00 | 30 | 5
PROPERTY 02 |  | 30 | 5
PROPERTY 03 |  | 30 | 6
PROPERTY 04 |  | 30 | 6
PROPERTY 05 |  | 30 | 7
PROPERTY 06 |  | 30 | 7
Spreadsheet: 127055d1320153184-divide-cell-to-worksheets-then-add-for-check-n-balance-raiders-ledger
Sheet: Player

Fall 2010
Date | Description | Check # | Credit | Debit | Balance
Spreadsheet: 549313d1511586567-graph-showing-additional-dates-book1
Sheet: Data

 | Date |  |  |  |  |  | Chill | Produce | chill avg | produce avg
Sunday | 2017-10-29 00:00:00 |  |  |  |  |  | 200 | 200 | 214.0565217391305 | 146.4588888888889
Monday | 2017-10-30 00:00:00 |  |  |  |  |  | 200 | 200 | 193.0569444444445 | 127.3636363636363
Tuesday | 2017-10-31 00:00:00 |  |  |  |  |  | 200 | 200 | 194.6692592592593 | 127.2945
Wednesday | 2017-11-01 00:00:00 |  |  |  |  |  | 200 | 200 | 199.4237142857142 | 134.7491666666667
Thursday | 2017-11-02 00:00:00 |  |  |  |  |  | 200 | 200 | 198.6107692307692 | 140.6282608695652
Friday | 2017-11-03 00:00:00 |  |  |  |  |  | 200 | 200 | 189.7194736842105 | 160.6038235294118
Spreadsheet: michelle_lokay__26563__imbalsumm0012
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 401509 | 366092
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 312601 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 384540 | 387604
500293 | 218532 | 267836
500302 |  | 3498
500303 | 131438 | 108723
500305 | 571942 | 588391
500307 | 14878 | 24321
500313 |  | 1388
500314
500655 | 41952
500657 | 103586 | 71799
INDEX
2000-11-30 00:00:00 |  |  | -122087.9
2000-12-11 00:00:00
Spreadsheet: 264248d1378828552-extracting-and-sorting-data-from-source-worksheet-excel-2003-index-match-tutorial-for-tailz
Sheet: Tutorial 1

 | Let's Rank and Sort!
 | Date | Name | Desc | rank |  |  | Match |  |  | Date | Name | Desc
 | 2013-03-18 00:00:00 | frodo | hobbit
 | 2013-04-12 00:00:00 | [NAME] | brit
 | 2013-02-21 00:00:00 | unicorn | awesome
 | 2013-03-18 00:00:00 | daffodil-11 | president
 | 2013-01-12 00:00:00 | batman | hero
Spreadsheet: 4ad85775-9916-4d65-835d-9152fc6cac1c
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 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
 |  |  |  |  |  | DRAFT 7/19/12
 |  |  |  |  | COURSE SCHEDULE*
 |  |  |  |  | FIN 357 H, FALL 2012
CLASS | DATE |  | CHAPTER | Event Due |  | ASSIGNMENT/TOPIC TO BE COVERED IN CLASS
1 | 2012-08-30 00:00:00 | TH | 1 |  | Course Introduction and Overview
2 | 2012-09-04 00:00:00 | T | 2 |  | Financial Institutions and Indirect Financing |  |  |  | (Sections 1-3 and 5)
3 | 2012-09-06 00:00:00 | TH | 7 |  | Risk and Return
4 | 2012-09-11 00:00:00 | T | 7 |  | Risk and Return continued
5 | 2012-09-13 00:00:00 | TH | 8 | HW1 | Bond Valuation and the Sturcture of Interest Rates
6 | 2012-09-18 00:00:00 | T | 8 | Quiz 1 | Bond Valuation and the Sturcture of Interest Rates
7 | 2012-09-20 00:00:00 | TH | 9 |  | Stock Valuation and Chapter 2 Section 5
8 | 2012-09-25 00:00:00 | T | 9 |  | Stock Valuation and Chapter 2 Section 5
9 | 2012-09-27 00:00:00 | TH | 10 | HW2 | Fundamentals of Capital Budgeting
10 | 2012-10-02 00:00:00 | T |  | Exam I | Optional review |  | Exam I,  6:00-8:30 pm, Location TBA
11 | 2012-10-04 00:00:00 | TH | 11 |  | Cash Flows and Capital Budgeting
12 | 2012-10-09 00:00:00 | T | 11 | Pos. Paper | Cash Flows and Capital Budgeting
13 | 2012-10-11 00:00:00 | TH | 12 |  | Evaluating Project Economics and Capital Rationing
14 | 2012-10-16 00:00:00 | T | 12 |  | Evaluating Project Economics and Capital Rationing
15 | 2012-10-18 00:00:00 | TH | 13 | HW 3 | Cost of Capital
16 | 2012-10-23 00:00:00 | T | 13 | Quiz 2 | Cost of Capital
17 | 2012-10-25 00:00:00 | TH | 15 | HW 4 | How Firms Raise Capital
18 | 2012-10-30 00:00:00 | T |  | Exam II | Optional review |  | Exam II, 6:00-8:30 pm, Location TBA
19 | 2012-11-01 00:00:00 | TH | 4 |  | FTTC Tour: [NAME] and Factset overview/ ratio analysis
20 | 2012-11-06 00:00:00 | T | 16 |  | Capital Sturcture Policy
21 | 2012-11-08 00:00:00 | TH | 16 |  | Capital Sturcture Policy
22 | 2012-11-13 00:00:00 | T | 18 | HW 5 | Dell Corporate Treasurer
23 | 2012-11-15 00:00:00 | TH | 18 | Com.Proj | Business Formation,Valuation, and Financial Planning
24 | 2012-11-20 00:00:00 | T |  |  | Business Formation,Valuation, and Financial Planning
 | 2012-11-22 00:00:00 | TH |  |  | Happy Thanksgiving
25 | 2012-11-27 00:00:00 | T | 17 | HW 6 | Dividend Policy
26 | 2012-11-29 00:00:00 | TH |  | Quiz 3 | Case Analysis and Excel Modeling
27 | 2012-12-04 00:00:00 | T | 20 |  | Options and Corporate Finance: Basic Concepts
28 | 2012-12-06 00:00:00 | TH |  | Exam III | Optional review |  | Exam III, 6:00-8:30 pm, Location TBA
 | * I reserve the right to make adjustments to the lecture schedule to best serve the interest of the class.
 |  |  | [NAME] and exam dates will not change.
Spreadsheet: 231380d1367027685-excel-advanced-filtering-on-multiple-sheets-kjdeutinlab30
Sheet: Population

2009 Pop |  | STATE | CAPITAL
>10,000,000
<1,000,000
 |  |  |  | STATE | AREA | 2009 POP | TREE | [NAME] | BIRD | CAPITAL
 |  |  |  | Alaska | 663267 | 698473 | [NAME] | Forget-me-not | [NAME] | Juneau
 |  |  |  | California | 163695 | 36961664 | California Redwood | Golden poppy | California Valley Quail | Sacramento
 |  |  |  | Delaware | 2489 | 885122 | American Holly | Peach blossom | Blue Hen Chicken | Dover
 |  |  |  | Florida | 65755 | 18537969 | Cabbage Palmetto | Orange blossom | Mockingbird | Tallahassee
 |  |  |  | Illinois | 57914 | 12910409 | [NAME] | Native violet | Cardinal | Springfield
 |  |  |  | Montana | 147042 | 974989 | Ponderosa Pine | Bitterroot | Western Meadowlark | Helena
 |  |  |  | New York | 54556 | 19541453 | Sugar Maple | Rose | Bluebird | Albany
 |  |  |  | North Dakota | 70700 | 646844 | American Elm | Wild prairie rose | Western Meadowlark | Bismarck
 |  |  |  | Ohio | 44825 | 11542645 | Ohio [NAME] | Scarlet carnation | Cardinal | Columbus
 |  |  |  | Pennsylvania | 46056 | 12604767 | Eastern Hemlock | Mountain laurel | [NAME] | Harrisburg
 |  |  |  | South Dakota | 77353 | 812383 | White Spruce | Pasque flower | Ring-necked Pheasant | [NAME]
 |  |  |  | Texas | 268580 | 24782302 | Pecan | Texas Blue Bonnet | Mockingbird | [NAME]
 |  |  |  | Vermont | 9615 | 621760 | Sugar Maple | Red clover | Hermit Thrush | Montpelier
 |  |  |  | Wyoming | 97813 | 544270 | Cottonwood | Indian paint brush | Western Meadowlark | [NAME]
Spreadsheet: 790238d1659609060-cut-and-paste-until-no-more-valud-test_pieces_revised
Sheet: Sheet1

KEYCODE | NAME | PIECE1 | PIECE2 | PIECE3 | PIECE4 | PIECE5 | PIECE6 | PIECE7 | PIECE8
M25150-1-001 | [NAME] | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-002 | [NAME] | [NAME] | P07
M25150-1-003 | [NAME] | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-004 | BERGSTROM LANA | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-005 | REDRUP JEN | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-006 | [NAME] ROY | [NAME] | P11
M25150-1-007 | [NAME] | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-008 | MOORES NOAH | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-009 | BROWN ERIN | L01 | P01 | P02 | P03 | P04 | P05 | P06
M25150-1-010 | MACDONALD SHERRI | L01 | P01 | P02 | P03 | P04 | P05 | P06
What I am trying to do:
M25150-1-001 | [NAME] | L01
M25150-1-001 | [NAME] | P01
M25150-1-001 | [NAME] | P02
M25150-1-001 | [NAME] | P03
M25150-1-001 | [NAME] | P04
M25150-1-001 | [NAME] | P05
M25150-1-001 | [NAME] | P06
M25150-1-002 | [NAME] | [NAME]
M25150-1-002 | [NAME] | P07
M25150-1-003 | [NAME] | L01
M25150-1-003 | [NAME] | P01
M25150-1-003 | [NAME] | P02
M25150-1-003 | [NAME] | P03
M25150-1-003 | [NAME] | P04
M25150-1-003 | [NAME] | P05
M25150-1-003 | [NAME] | P06
… | … | …
Spreadsheet: 59048d1259410430-counting-and-averaging-information-708920_sam_d
Sheet: PT

 |  |  | Data
Years | Raised | Company | Count of Raised | Count of Closed | Average of Less 14 | Average of Days
2009 | Nov | A | 4 | 2 | 0.5 | 14.5
 |  | B | 4 | 3 | 1 | 10.66666666666667
 |  | C | 4 | 1 | 1 | 9
Grand Total |  |  | 12 | 6 | 0.8333333333333334 | 11.66666666666667
Spreadsheet: 753652d1635608149-finding-and-matching-values-then-returning-sum-inventory
Sheet: Tab 1

[NAME] | PRODUCT NAME | VARIATION NAME | INITIAL INVENTORY | CURRENT STOCK COUNT
2022-06-01 00:00:00 | Smooth [NAME] | Burnt Red | 82
2022-06-01 00:00:00 | Smooth [NAME] | [NAME] | 51
2022-06-01 00:00:00 | Smooth [NAME] | [NAME] | 22
2022-04-01 00:00:00 | Leg Cream |  | 15
2022-05-01 00:00:00 | Mini Handbag Paris | Black | 5
2022-05-01 00:00:00 | Mini Handbag Paris | Maroon | 8
2022-05-01 00:00:00 | Mini Handbag Paris | [NAME] | 4
2023-01-01 00:00:00 | [NAME] | [NAME] | 15
2023-01-01 00:00:00 | [NAME] | Blush | 7
2023-01-01 00:00:00 | [NAME] | Powder | 20
Spreadsheet: vkaminski__40900__CASH_GasMat_0400MyCopy
Sheet: TOC

 | GASOCIDENTE DO MATO GROSSO LTDA (GASMAT)
 | ENRON INTERNATIONAL
 | *** DRAFT COPY ***
 | Table Of Contents
 |  | Page #
 | Assumptions | 1
 | Cash Flow | 2
 | Project / Partner Returns | 3
 | Enron Book Income | 4
 | Political Risk / DSCR Calculations | 5
 | Trapped Cash / Partner Loans / Capital Budget | 6
 | Turnkey Components & Construction Taxes | 7
 | Drawdown Schedule | 8
 | Interest During Construction | 9
 | Debt Amortization | 10
 | Sudam Tax Credits | 11
 | Cash & Book Taxes, INE Calculation | 12
 | Depreciation | 13
 | Project Financial Statements | 14
 | Reference Sheets | 15-19
 | [NAME] Revenues
Spreadsheet: 493665d1481819614-conditional-formatting-with-a-index-match-array-formula-copy_v1
Sheet: ExecView

SITE | AVAILABLE _T1 | AVAILABLE_T2 | ORDER_T1 | [NAME] | AVAILABLE_T3 | Order_T3 | Man.
SITE1 |  |  |  |  |  |  | HDS
SITE2 |  |  |  |  |  |  | HDS
SITE3 |  |  |  |  |  |  | HDS
SITE1 |  |  |  |  |  |  | HP
SITE2 |  |  |  |  |  |  | HP
SITE3 |  |  |  |  |  |  | HP
SITE1 |  |  |  |  |  |  | Cloudian
SITE2 |  |  |  |  |  |  | Cloudian
SITE3 |  |  |  |  |  |  | Cloudian
SITE1 |  |  |  |  |  |  | SwiftStack
SITE2 |  |  |  |  |  |  | SwiftStack
SITE3 |  |  |  |  |  |  | SwiftStack
SITE1 |  |  |  |  |  |  | HCP
SITE2 |  |  |  |  |  |  | HCP
SITE3 |  |  |  |  |  |  | HCP
Spreadsheet: 61595d1262537005-sum-formatting-problem-example1
Sheet: 130051

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130051
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOG NO:
PIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return Date:
SIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept Date:
F/A: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days:
IRP: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RON's:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous  Log Closed:
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  |  |  | ZULU
LEG | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N/V | HOLD |  | OUT | IN | TOTAL |  | HOURS |  | RATE | $ |  | T.O. | LDG
1 | 2009-11-15 00:00:00 | P | MG | VNY | TAPA | 15:32:00 | 21:08:00 | 06:47:00 |  |  | 05:30:00 | D | N | 0 |  | 29500 | 7700 |  |  |  |  | 0
2 | 2009-11-16 00:00:00 | P | SV | TAPA | LAX |  | 05:19:00 | 07:52:00 |  |  | 00:00:00 | D | P | 0 |  | 29500 | 4000 |  |  |  |  | 0
3 | 2009-11-16 00:00:00 | P | SV |  | VNY |  | 14:03:00 | 00:07:00 |  |  | 00:00:00 | D | V | 0 |  |  | 3000 |  |  |  |  | 0
4 |  |  |  | 0 | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
5 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
6 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
7 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
8 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
9 |  |  |  |  | 0 | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
 | PST | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total |  |  | Closed
 | DST | 7:00:00
 | Today |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add - Fwd from previous [NAME]. Log only |  |  |  |  |  | 0
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add
 | ACTT Forwarded
 | Total this Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Total
 | Totals to Date
Spreadsheet: 153330d1335875553-calculation-of-text-and-numbers-claims
Sheet: MD

Policy | CLAIMS |  |  |  | TOTAL CLAIMS |  | DEDUCTIBLE/ | Claims Recorded At Nil
Year | Paid |  | Oustanding |  |  |  | EXCESS
 | No. | Amount | No. | Amount | No. | Amount | APPLICABLE
2006/2007 | 0 | 5000 | 0 | Nil
2007/2008 | 0 | Nil | 0 | Nil
2008/2009 | 0 | Nil | 0 | Nil
2009/2010 | 0 | Nil | 0 | Nil
2010/2011 |  | Not Insured
TOTALS
Spreadsheet: 7a121400-37d8-4a94-a4ec-3cf48cfc2d1e
Sheet: Sheet1

Criteria | # [NAME] | [NAME]. EPP | Rural/ agricultural – high poverty, low med. inc. | Rural/agricultural – low ADM, low poverty, low to mod. med. inc. | Rural/Small Town – mod. to high med. inc. | Urban – low med. inc., high poverty | Major Urban – very high poverty | Urban/ Suburban – high med. inc.
Continuous Improvement, Excellent & Effective | 143 | 8283.041958041958 | 59 | 40 | 18 | 14 | 1 | 11
Excellent & Effective | 116 | 8115.431034482759 | 38 | 39 | 18 | 12 | 0 | 9
Excellent & Effective - 80% of indicators met | 68 | 7994.705882352941 | 12 | 29 | 13 | 5 | 0 | 9
Excellent & Effective - Met AYP | 36 | 8137.305555555556 | 9 | 15 | 4 | 4 | 0 | 4
Excellent & Effective - Performance Index Score [NAME] 95 | 66 | 8008.878787878788 | 11 | 28 | 13 | 5 | 0 | 9
Excellent & Effective - Positive value added score | 73 | 8146.54794520548 | 25 | 21 | 14 | 6 | 0 | 7
Spreadsheet: 180144d1347488903-create-an-automatically-sorting-ranking-list-rank-dip11-oeldere2-
Sheet: Sheet1

 |  | score 2 |  | score 2
 | score 1 | Score2 |  |  |  | solution 1 |  |  |  |  | Label | Score2 | helpcel |  |  | DESIRED OUTPUT
Holly | 6.000023 | 15 |  |  |  | Holly | 15.000008 |  |  |  | [NAME] | 20 | 20.000003 |  |  | Holly | 6 | 15
[NAME] | 10.000018 | 20 |  |  |  | [NAME] | 20.000003 |  |  |  | [NAME] | 35 | 35.000004 |  |  | [NAME] | 10 | 20
Lina | 10.00002 | 35 |  |  |  | [NAME] | 27.500006 |  |  |  | Lina | 35 | 35.000005 |  |  | Lina | 10 | 35
[NAME] | 17.500021 | 27.5 |  |  |  | [NAME] | 35.000004 |  |  |  | [NAME] | 27.5 | 27.500006 |  |  | [NAME] | 17.5 | 27.5
[NAME] | 17.500025 | 39 |  |  |  | Lina | 35.000005 |  |  |  | [NAME] | 55 | 55.000007 |  |  | [NAME] | 17.5 | 39
[NAME] | 20.000024 | 45 |  |  |  | [NAME] | 39.00001 |  |  |  | Holly | 15 | 15.000008 |  |  | [NAME] | 20 | 45
[NAME] | 24.000019 | 35 |  |  |  | [NAME] | 45.000009 |  |  |  | [NAME] | 45 | 45.000009 |  |  | [NAME] | 24 | 35
[NAME] | 45.000022 | 55 |  |  |  | [NAME] | 55.000007 |  |  |  | [NAME] | 39 | 39.00001 |  |  | [NAME] | 45 | 55
 |  |  |  |  |  |  |  |  |  |  |  | Score1
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 10.000018
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 24 | 24.000019
 |  |  |  |  |  |  |  |  |  |  | Lina | 10 | 10.00002
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 17.5 | 17.500021
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 45 | 45.000022
 |  |  |  |  |  |  |  |  |  |  | Holly | 6 | 6.000023
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 20 | 20.000024
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 17.5 | 17.500025
Spreadsheet: 691488d1597724984-return-value-if-two-or-three-matches-meet-the-criteria-example-datasheet
Sheet: Trade Analysis

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Ticket | Open Date | Close Date | Symbol | Action | Units/Lots | SL | TP | Open Price | Close Price | Commission | Swap | Pips | Profit | Gain | Signal | Magic Number | Duration (DD:HH:MM:SS)
10383769 | 2020-07-20 10:15:00 | 2020-07-20 11:20:00 | EURUSD | Buy | 1 | 1.13484 | 1.15484 | 1.1449 | 1.14521 | -7 | 0 | 3.1 | 24 | 0 | 5mTrend | 11117 | 00:01:05:29
10463192 | 2020-07-20 13:35:00 | 2020-07-20 16:00:00 | EURUSD | Buy | 16.29 | 1.13602 | 1.15602 | 1.14602 | 1.14189 | -114.03 | 0 | -41.3 | -6841.8 | -0.83 | 15mTrend | 11119 | 00:02:24:03
10463194 | 2020-07-20 13:35:00 | 2020-07-20 16:00:00 | EURUSD | Buy | 1 | 1.13602 | 1.15602 | 1.14602 | 1.14184 | -7 | 0 | -41.8 | -425 | -0.08 | 15mTrend | 11119 | 00:02:24:03
11001415 | 2020-07-21 16:18:00 | 2020-07-21 16:46:00 | EURUSD | Sell | 1 | 1.14458 | 1.14108 | 1.1431 | 1.14458 | -7 | 0 | -14.8 | -155 | -0.02 | ManualTrade | 11150 | 00:00:27:48
11005728 | 2020-07-21 16:25:00 | 2020-07-21 16:52:00 | EURUSD | Sell | 1 | 1.14487 | 1.14137 | 1.14338 | 1.14487 | -7 | 0 | -14.9 | -156 | -0.02 | ManualTrade | 11150 | 00:00:27:11
11012964 | 2020-07-21 16:39:00 | 2020-07-21 16:54:00 | EURUSD | Sell | 1 | 1.14581 | 1.14231 | 1.14431 | 1.14552 | -7 | 0 | -12.1 | -128 | -0.02 | ManualTrade | 11150 | 00:00:15:13
11032908 | 2020-07-21 17:08:00 | 2020-07-21 17:15:00 | EURUSD | Buy | 1 | 1.14389 | 1.14739 | 1.14537 | 1.14638 | -7 | 0 | 10.1 | 94 | 0.01 | ManualTrade | 11149 | 00:00:06:53
11041764 | 2020-07-21 17:20:00 | 2020-07-21 17:29:00 | EURUSD | Sell | 1 | 1.14912 | 1.14562 | 1.1476 | 1.147 | -7 | 0 | 6 | 53 | 0.01 | ManualTrade | 11150 | 00:00:08:24
Spreadsheet: 738754d1625227887-index-aggregate-formula-help-example-data-1-
Sheet: Feb2021

2021-02-01 00:00:00
Number | Category | Member [NAME] | Species | Points
 | Open ExC | Person B | Feb aaa | 1
 | Open ExC | Person B | Feb bbb | 3
 | Open ExCat | Person C | Feb ccc | 2
 | Open MinC | Person C | Feb ddd | 0
 | Open ExCat | Person B | Feb eee | 0
 | Open MinC | Person A | Feb fff | 4
Spreadsheet: 132656d1323877037-count-unique-using-frequency-countif-and-sumif-question
Sheet: Sheet1

Customer | [NAME] | Amount |  | Customer | Customer ID | Amount
A | 1 | 1000 |  | A
A | 1 | 2000
A | 2 | 1000
A | 2 | 1000
A | 3 | 2000
A | 4 | 3000
A | 2 | 4000
A | 5 | 5000
B | 6 | 1000
B | 6 | 2000
B | 7 | 1000
B | 7 | 1000
B | 8 | 2000
B | 9 | 3000
B | 7 | 4000
B | 10 | 5000
Spreadsheet: 135842d1326271884-knocking-off-of-opposite-balances-within-a-number-set-minmaxupload10012012_zbor
Sheet: Sheet1

Category | A | B | C |  | A1 | B1 | C1 |  | zbor | [NAME] | Check | Answer
Min val cal | 200 | -50 | 300 |  | no | yes | no |  | -50 | -50 | 0 | -50
Min val cal | 10 | -300 | -50 |  | yes | no | no |  | 10 | 10 | 0 | -50
Min val cal | 200 | -300 | -50 |  | no | no | yes |  | -50 | -50 | 0 | -50
Min val cal | 200 | -20 | 10 |  | no | no | yes |  | 10 | 10 | 0 | 10
Min val cal | 30 | 20 | 10 |  | no | no | yes |  | 10 | 10 | 0 | 10
Min val cal | -30 | -20 | -10 |  | no | no | yes |  | -10 | -10 | 0 | -10
Min val cal | 0 | 50 | 100 |  | yes | no | no |  | 0 | 0 | 0
[NAME] | 200 | -300 | -50 |  | no | yes | no |  | -300 | -300 | 0 | -300
[NAME] | 200 | -20 | 10 |  | yes | no | no |  | 200 | 200 | 0 | 200
[NAME] | 30 | 20 | 10 |  | yes | no | no |  | 30 | 30 | 0 | 30
[NAME] | -30 | -20 | -10 |  | yes | no | no |  | -30 | -30 | 0 | 30
[NAME] | -30 | -20 | -10 |  | yes | no | no
Spreadsheet: 130242d1322138940-sheet-sum-based-on-cell-reference-new-problem2
Sheet: Sheet1

 |  |  |  |  |  | $A$1
 |  | Sales by Product |  |  | 1:5
 |  |  |  |  |  | Sales (Excl ES) £000s
 | Product Group | Spacer Type | TGH / ANN | Textured ? | Georgian ? | 2011-08-01 00:00:00 | 2011-09-01 00:00:00 | 2011-10-01 00:00:00 | 2011-11-01 00:00:00 | 2011-12-01 00:00:00 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | FY12
 | EnergiKare | Aluminium | Toughened | No Textured | No Georgian
Spreadsheet: 74310d1274858734-excel-2007-excel-cell-counting-in-2003-excel-problem
Sheet: Sheet1

Qty | Part 1 | Part 2 | Part 3
2 | A | B | B
3 | C | A | B
5 | A | A | A
7 | B | C | C
Total no of A |  | 20
Total no of B |  | 14
Total no of C |  | 17
Spreadsheet: 273077d1382607116-auto-completion-of-master-sheet-from-multiple-pages-coding
Sheet: Master Sheet

 | Promoter | Ticket Type | Rate | Quantity | Amount
 | Party Hard Drivers | Enchanted Magnum Pass | 9000
 |  | Enchanted Odyessy Pass | 4250
 |  | Enchanted Disciple Pass | 3750
 |  | Enchanted Early Bird Pass | 3500
 | White Knight | Enchanted Magnum Pass | 9000
 |  | Enchanted Odyessy Pass | 4250
 |  | Enchanted Disciple Pass | 3750
 |  | Enchanted Early Bird Pass | 3500
 | Elements Inc. | Enchanted Magnum Pass | 9000
 |  | Enchanted Odyessy Pass | 4250
 |  | Enchanted Disciple Pass | 3750
 |  | Enchanted Early Bird Pass | 3500
Spreadsheet: 851948d1702058457-search-letters-and-numbers-to-see-if-exist-in-another-column-by-at-least-7-characters-match-columns
Sheet: Blad 1

Tabell 1
Pass1 | Pass2
A847295016 | E280475631 | Match
E203847561 | A590827346 | Match
A509283746 | E650143728 | Match
E615204837 | A214365879 | Match
A123456789 | A421390786 | Match
[NAME] | [NAME] | Match
A432109876 | E345890176 | Match
E876543210 | A870925461 | Match
A765432109 | E879563421 | Match