tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 68474d1269008211-finding-closest-value-in-an-array-excel-formula
Sheet: Sheet1

ARRAY |  |  |  | Find closest to this value: |  |  |  |  | formula
19400 | 25000 | 30600 |  | 50000 |  |  |  |  | {=INDEX(C2:C25,MATCH(MIN(ABS(C2:C25-F2)),ABS(C2:C25-F2),0),)}
21400 | 27600 | 33800
23700 | 30500 | 37300
26200 | 33700 | 41200
28900 | 37200 | 45500
31900 | 41100 | 50300
35300 | 45400 | 55500
39000 | 50200 | 61400
43100 | 55500 | 67900
47600 | 61300 | 75000
52600 | 67700 | 82800
58100 | 74800 | 91500
64300 | 82700 | 101100
71400 | 91900 | 112400
79600 | 102400 | 125200
88700 | 114100 | 139500
98800 | 127100 | 155400
110100 | 141700 | 173300
122700 | 157900 | 193100
136700 | 175900 | 215100
152400 | 196100 | 239800
169800 | 218500 | 267200
191900 | 247000 | 302100
418800 | 539000 | 659200
Spreadsheet: 00388bfe-0f2f-4dd1-8fbf-e532b863cc96
Sheet: Sheet1

 | LCCC Prioritization Checklist for New Trials
 | PI Name: |  | Study Number: |  | Short Title:
 |  | Factor | Sub-Factors |  |  | Points Available | Calculated Points
 | Sponsor Type: | (please place an "x" beside the applicable entry) | LCCC IIT |  |  | X=6
 |  |  | Non-UNC IIT |  |  | X=3
 |  |  | Externally  Peer Reviewed |  |  | X=3
 |  |  | Cooperative Group |  |  | x=3
 |  |  | Industry * |  |  | x=1
 | Collaboration:
 | Phase II for UNC [NAME]? |  | LCCC IIT multicenter with community sites |  |  | Score of 2 for Yes, 0 for No
 | Inter Institutional Collaboration. |  | LCCC IIT multicenter with academic sites |  |  | Score of 1 for Yes, 0 for No
 | Provides Support for LCCC correlative research?                                                                                          Explain>> |  |  |  |  | Score of 2 for Yes, 0 for No
 | Collaboration outside of LCCC with in UNC?                                                                                                  Explain>> |  |  |  |  | Score of 1 for Yes, 0 for No
 | Involves named [NAME]?                                       (Indicate name:  ACCRU, Aptium, BTTC,SEP2C, TBCRC)>> |  |  |  |  | Score of 3 for Yes, 0 for No
 | Science
 | Phase I Trial |  |  |  |  | Score of 3 for Yes, 0 for No
 | Builds on Previous/Existing LCCC Research or continues prior phase trial completed here.                Explain>> |  |  |  |  | Score of 2 for Yes, 0 for No
 | Authorship Potential
 | UNC Authorship Potential: |  | Yes, UNC PI will be first author |  |  | Score of 3 for Yes, 0 for No
 |  |  | Yes, UNC PI will not be first author |  |  | Score of 1 for Yes, 0 for No
 |  |  | No Authorship Potential (respond No to both above)
 | PI is Study Chair  for Cooperative Group Trial |  |  |  |  | Score of 2 for Yes, 0 for No
 | Income & Clinical Potential
 | Compelling clinical need (i.e. drug with documented efficacy that is not yet commercially available).                                                                                                                Explain>> |  |  |  |  | Score of 1 for Yes, 0 for No
 | Expected accrual 5, 10 or greater. |  | Enter Target Accrual # |  |  | Score of 1 for >=5, 3 for >=10
 | Budget (Expected Revenue) |  | Projected Trial Income will exceed costs |  |  | Score of 3  for Yes, 0 for No
 | **to be provided to PI by Finance. Trials with insufficient funding will be reviewed by POEC. |  | ….If not, is trial projected to break even? (revenue = costs) |  |  | Score of 1 for Yes, 0 for No
 |  |  | Finance comment:
 | POEC Bonus | (added by POEC only)
 | * For Industry sponsored studies, budgets will be negotiated at  break even or  at a surplus when possible. If during negotiation it is determined that the study budget is not projected to break even  the PI will be consulted for direction and or advice. For prioritization purposes, all Industry studies will be scored as break even. |  |  |  |  | Total Points
 | Version 10-30-2014 |  |  |  | Minimum Score for CPO implentation = 4
 |  |  |  |  | POD Leader to Validate score at sign off.
Spreadsheet: 740228d1626249316-how-to-average-the-probability-severity-and-risk-of-a-group-of-data-how-to-average-the-probability-severity-and-risk-of-a-group-of-data-edit
Sheet: Risk Matrix

 | Probability | Severity |  |  |  |  |  |  |  | Risk Level | Definition | Total
 | Category | Catastrophic | Critical | Marginal (Major) | Marginal (MInor) | Negligible |  |  |  | A | Intolerable
 | Frequent | A | A | A | A | B |  | A01 |  | B | Undesirable
 | Improbable | B | C | D | D | D |  | A02 |  | C | Tolerable
 | Incredible | C | D | D | D | D |  | A03 |  | D | Broadly Acceptable
 | Occasional | A | A | B | C | D |  | A04
 | Probable | A | A | A | B | C |  | A05
 | Remote | A | B | C | D | D |  | A06
 |  |  |  |  |  |  |  | A07
 |  |  |  |  |  |  |  | A08
 |  |  |  |  |  |  |  | A09
 | Probability | Frequent | 1 |  |  |  |  | A10
 |  | Probable | 2 |  |  |  |  | A11
 |  | Occasional | 3 |  |  |  |  | A12
 |  | Remote | 4 |  |  |  |  | A13
 |  | Improbable | 5 |  |  |  |  | A14
 |  | Incredible | 6 |  |  |  |  | A15
 | Severity | Catastrophic | 1
 |  | Critical | 2
 |  | Marginal (Major) | 3
 |  | Marginal (MInor) | 4
 |  | Negligible | 5
Spreadsheet: 108388d1305441711-if-a-cell-in-a-column-in-any-worksheet-x-copy-entire-row-budget_update
Sheet: AMEX

Date | Location | Memo | Method | Amount
2011-05-12 00:00:00 | Ridleys |  | AMEX | 10
2011-05-12 00:00:00 | Ridleys |  | AMEX | 10
2011-05-01 00:00:00 | Conoco |  | AMEX | 10
2011-05-01 00:00:00 | Conoco |  | AMEX | 10
2011-05-14 00:00:00 | Amazon |  | AMEX | 99.99
2011-05-14 00:00:00 | Amazon |  | AMEX | 99.99
Spreadsheet: 585623d1533873472-my-excel-gives-me-wrong-calculation-book1
Sheet: Analysis (C)

 |  |  |  |  |  |  |  |  |  | Section 1 (Scale and Growth) Weighting
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | Growth Weighting |  |  |  |  |  |  | Connectivity Weighting |  |  |  |  |  |  |  |  |  | Policy [NAME]
 |  |  |  | Combined Weighted Score |  |  |  |  |  |  | Scale (Historical) |  |  |  |  |  |  |  |  |  | Growth (Forecast) |  |  |  |  |  |  | Connectivity |  |  |  |  |  |  |  |  |  | Policy support
 | Duplicated? | City Name | Ranking | Total Part 1 Score | Scale | Growth | Connectivity | Policy Support |  |  | Combined  Score | Retail sales | Income per capita | Population | Urbanization rate | Service Industry  as % of GDP | Industrial output | Freight Volume |  |  | Combined  Score | Retail sales | Income per capita | Population | Service Industry  as % of GDP | GDP |  | Combined  Score | National Transportation Hub | Road area | Number railways passing through | Presence of ports | Number of flights | Internet penetration | Future International Transportation Hub | Future National Transportation Hub |  | Combined  Score | National logistics hub | Regional logistics hub | Courier hub | E-commerce demonstration city | One Belt One Road city
 |  | Greater Shanghai
 |  | Greater Beijing
 |  | Changchun
 |  | Changsha
 |  | Changzhou
 |  | Chengdu
 |  | Chongqing
 |  | Dalian
 |  | Dongguan
 |  | [NAME]
 |  | Fuzhou
 |  | Guiyang
 |  | Haikou
 |  | Hangzhou
 |  | Harbin
 |  | Hefei
 |  | Hohhot
 |  | Jiaxing
 |  | Jilin
 |  | Jinan
 |  | Jinhua
 |  | Kunming
 |  | Lanzhou
 |  | Luoyang
 |  | Nanchang
 |  | Nanjing
 |  | Nanning
 |  | Nantong
 |  | Ningbo
 |  | Qingdao
 |  | Quanzhou
 |  | Shantou
 |  | Shaoxing
 |  | [NAME]
 |  | Shijiazhuang
 |  | Suzhou
 |  | Taiyuan
 |  | Tangshan
 |  | Tianjin
 |  | Urumqi
 |  | Weifang
 |  | Wenzhou
 |  | Wuhan
 |  | Wuxi
 |  | Xi'an
 |  | Xiamen
 |  | [NAME]
 |  | Xuzhou
 |  | Yantai
 |  | Zhengzhou
 |  | Zhongshan
 |  | Zhuhai
 |  | Huzhou
 |  | Huaian
 |  | Mianyang
 |  | Weihai
 |  | Wuhu
 |  | Xining
 |  | Yancheng
 |  | Yangzhou
 |  | Yichang
 |  | Yinchuan
 |  | [NAME]
 |  | Shanghai
 |  | Guangzhou
 |  | Beijing
 |  | Shenzhen
 |  | Langfang
Spreadsheet: 1b5d31ea-d51b-4b36-bea3-76cf9db095f3
Sheet: Sheet1

Unnamed: 0 | FORM I | 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
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Part I
 | INTERNATIONAL CIVIL AVIATION ORGANIZATION
 | AIR TRANSPORT REPORTING FORM
 | AIRPORT TRAFFIC
 | Contact person:
 | Organization: |  |  |  |  |  |  |  |  |  | State:
 | [NAME].: |  |  |  |  |  |  |  |  |  | Name of Airport:
 | Fax: |  |  |  |  |  |  |  |  |  | City name:
 | E-mail: |  |  |  |  |  |  |  |  |  | Calendar year:
 |  |  |  |  |  |  |  |  |  |  | Month:
 | Description |  |  | Aircraft Movements    Total | Passengers |  |  |  | Freight (tonnes) |  |  | Mail (tonnes)
 |  |  |  |  | Embarked | Disembarked | Total             (Col. c + d) | Direct       transit | Loaded | Unloaded | Total              (Col. [NAME]) | Loaded | Unloaded | Total                  (Col. j + k)
 |  |  |  |  |  |  | (c+d) | Transit |  |  |  |  |  | (c+d)
 | a |  |  | b | c | d | e | f | g | h | i | j | k | l
 | [NAME] air transport
 | 1. International scheduled……………………………………………………………
 | 2. International non-scheduled……………………………………………………
 | 3. Total international (1+2)…………………………………………………………….
 | 4. Domestic scheduled and non-scheduled……………………………….
 | 5. Total commercial air transport (1+2+4)…………………………………..
 | 6. All-freight/mail services1………………………………………………………………
 | 7. Air taxi and commercial business flights2………………………………………………………………
 | B. All other movements………………………………………………………………………..
 | Remarks (including a description of any unavoidable deviation(s) from the reporting instructions):
 | 1This traffic is to be included also under items 1 to 5 (see the reporting instructions). |  |  |  |  |  |  |  |  |  | Please use the additional sheets as required.
 | 2This traffic is to be included also under items 2 to 5 (see the reporting instructions).
Spreadsheet: 267327d1380045108-compare-data-across-worksheets-and-copy-data-if-match-file-export-load-list
Sheet: Carpet Pad Lookup

 | Quantity | [NAME] | Depth | Pad color | Qty | Pad color | Qty
 | 90 | 8 | 10 | Pink | 1
 | 160 | 8 | 20 | Green | 1
 | 240 | 8 | 30 | Black | 1
 | 100 | 10 | 10 | Red | 1
 | 180 | 10 | 20 | Green | 1
 | 200 | 10 | 20 | White | 1
 | 270 | 10 | 30 | Black | 1
 | 300 | 10 | 30 | Blue | 1
 | 400 | 10 | 40 | White | 2
 | 500 | 10 | 50 | White | 1 | Blue | 1
 | 600 | 10 | 60 | Blue | 2
 | 700 | 10 | 70 | Blue | 2 | Red | 1
 | 800 | 10 | 80 | Blue | 2 | White | 1
 | 900 | 10 | 90 | Blue | 3
 | 1000 | 10 | 100 | Blue | 2 | White | 2
 | 400 | 20 | 20 | White | 2
 | 600 | 20 | 30 | White | 3
 | 800 | 20 | 40 | White | 4
 | 1000 | 20 | 50 | White | 5
 | 1200 | 20 | 60 | White | 6
 | 1400 | 20 | 70 | Blue | 4 | Red | 2
 | 1600 | 20 | 80 | Blue | 4 | White | 2
 | 1800 | 20 | 90 | Blue | 6
 | 2000 | 20 | 100 | Blue | 4 | White | 4
 | 900 | 30 | 30 | Blue | 3
 | 1200 | 30 | 40 | Blue | 4
 | 1500 | 30 | 50 | Blue | 5
 | 1800 | 30 | 60 | Blue | 6
 | 2100 | 30 | 70 | Blue | 6 | Red | 3
 | 2400 | 30 | 80 | Blue | 6 | White | 3
 | 1600 | 40 | 40 | White | 8
 | 2000 | 40 | 50 | White | 10
 | 2400 | 40 | 60 | White | 12
 | 2500 | 50 | 50 | White | 5 | Blue | 5
 | 90 | 10 | 8 | Pink | 1
 | 160 | 20 | 8 | Green | 1
 | 240 | 30 | 8 | Black | 1
 | 180 | 20 | 10 | Green | 1
 | 200 | 20 | 10 | White | 1
 | 270 | 30 | 10 | Black | 1
 | 300 | 30 | 10 | Blue | 1
 | 400 | 40 | 10 | White | 2
 | 500 | 50 | 10 | White | 1 | Blue | 1
 | 600 | 60 | 10 | Blue | 2
 | 700 | 70 | 10 | Blue | 2 | Red | 1
 | 800 | 80 | 10 | Blue | 2 | White | 1
 | 900 | 90 | 10 | Blue | 3
 | 1000 | 100 | 10 | Blue | 2 | White | 2
 | 600 | 30 | 20 | White | 3
 | 800 | 40 | 20 | White | 4
 | 1000 | 50 | 20 | White | 5
 | 1200 | 60 | 20 | White | 6
 | 1400 | 70 | 20 | Blue | 4 | Red | 2
 | 1600 | 80 | 20 | Blue | 4 | White | 2
 | 1800 | 90 | 20 | Blue | 6
 | 2000 | 100 | 20 | Blue | 4 | White | 4
 | 1200 | 40 | 30 | Blue | 4
 | 1500 | 50 | 30 | Blue | 5
 | 1800 | 60 | 30 | Blue | 6
 | 2100 | 70 | 30 | Blue | 6 | Red | 3
 | 2400 | 80 | 30 | Blue | 6 | White | 3
 | 2000 | 50 | 40 | White | 10
 | 2400 | 60 | 40 | White | 12
Spreadsheet: 27816d1221502479-formatting-cells-width-changing-col-size
Sheet: Sheet1

test 1 |  |  | Option 1:  Adjust font to fit
Test 2 |  |  |  | Format Cells>Alignment>Shrink to Fit
test 3 |  |  |  | As you can see, there's some problems with this.
More of a test
More and more of a test
Three more tests
 |  |  | Option 2: Wrap Text
 |  |  |  | Format Cells>Alignment>Wrap Text
test 1
Test 2
test 3
More of a test
More and more of a test
Three more tests
 |  |  | Option 3: Remove Gridlines
 |  |  |  | See Sheet 2 as this applies to an entire worksheet
 |  |  | Option 4 | Use the Camera Tool
test 1 |  |  |  | The camera tool (view toolbars>customize>commands>tools>camera
Test 2 |  |  |  | drag to your toolbar and close customize window |  |  |  |  |  |  |  | More of a test
test 3 |  |  |  | place your entries in another column of the proper width (e.g. M) |  |  |  |  |  |  |  | More and more of a test
 |  |  |  | highlight them and click on the camera tool |  |  |  |  |  |  |  | Three more tests
 |  |  |  | Move the cursor to the row and column where you want your data to appear
 |  |  |  | To change your data, change it in column M
 |  |  |  | You can delete the line around it by right clicking on it and formatting it.
test 1 |  |  | Option 5: Center Across Selection
Test 2 |  |  |  | Format Cells>Alignment> Horizontal dropdown> Center Across Selection
test 3 |  |  |  | Value is still in Column A but looks like merged with B and C
More of a test
More and more of a test
Three more tests
 |  |  | Option 6: [NAME] (last resort)
test 1 |  |  |  | Merging cells often causes problems later when trying to format and manipulate your worksheet
Test 2
test 3
More of a test
More and more of a test
Three more tests
Spreadsheet: 774718d1648633901-counting-how-many-times-names-appear-when-theres-2-per-cell-and-comparing-other-info-sample-workbook
Sheet: Sheet1

TABLE 1
File | Path | Members | Size | Accessed
File1 | Pathforfile1 | Jude;Sam;Lucy | 105gb | 2022-05-01 00:00:00
File2 | Pathforfile2 | Jude;Lucy;Steve;Helen | 96gb | 2022-05-01 00:00:00
File3 | Pathforfile3 | Steve;Helen | 90gb | 2022-04-01 00:00:00
 | TABLE 2
 | Member | Number of files
 | [NAME]
 | [NAME]
 | [NAME]
 | Helen
 | TABLE 3
 | Member | Number of files over 100gb | Number of files 50-99gb | Number of files 1-49gb
 | [NAME] | 1 | 1 | 0
 | [NAME] | 1 | 0 | 0
 | [NAME] | 1 | 1 | 0
 | [NAME] | 0 | 2 | 0
 | Helen | 0 | 2 | 0
Spreadsheet: 862999d1710537890-dynamic-indirect-with-sequenz-in-adress-doesnt-work-help-came-dj
Sheet: evaluation

Data Area (Inputzone) |  |  |  |  | feel free to change things in the [NAME]
Column-name: | Day |  |  |  | runns dynamic
Colums: | 8 |  |  |  | problems dynamic
Rows: | 5 |  |  |  | runns dynamic
Index |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
evaluated area: |  | Werte!B1:B5 | Werte!C1:C5 | Werte!D1:D5 | Werte!E1:E5 | Werte!F1:F5 | Werte!G1:G5 | Werte!H1:H5
Test, wich data is in the Cells |  | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8
 |  | 19.97 | 20.02 | 20 | 20.02 | 20.04 | 20.01 | 19.99
 | 19.99 | 20 | 20 | 20.2 | 20 | 20.04 | 20.02 | 20.01
 | 19.96 | 20.04 | 19.97 | 20 | 20.01 | 20.03 | 19.98 | 20.03
 | 19.98 | 19.99 | 20.03 | 20.03 | 20.05 | 20.05 | 19.98 | 20.01
 | 20.02 | 20.03 | 20.04 | 20.04 | 19.99 | 20.04 | 20.01 | 20.02
 | I now, would have replaced the 'B8' reference in the funktion B12 with the funktion out of B8 in order to fill every column dynamicly, but it dont seem to work
Evaluation |  | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8
Summ of the Days |  | 100.03 | 100.06 | 100.27 | 100.07 | 100.2 | 100 | 100.06
Middle of the Days |  | 20.006 | 20.012 | 20.054 | 20.014 | 20.04 | 20 | 20.012
Maximum o. t. D. |  | 20.04 | 20.04 | 20.2 | 20.05 | 20.05 | 20.02 | 20.03
Minimum o. t. D. |  | 19.97 | 19.97 | 20 | 19.99 | 20.03 | 19.98 | 19.99
Spreadsheet: 842500d1694566602-cannot-figure-out-a-formula-for-a-weighted-average-with-na-as-an-option-test-file-dawalsh1184-
Sheet: Sheet1

 | Weight / Score | Proposed Weights | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | 0.3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
Q1 | 3 | 0.08 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Q2 | 0 | 0.055 |  |  |  |  |  |  | 0.12 |  |  |  |  |  |  |  |  |  |  |  |  | 0
Q3 | 3 | 0.065 |  |  |  |  |  |  | 0.07- (0.0367 (2/3 of 0.055) + 0.0333 (1/3 of the 0.1)) |  |  |  |  |  |  |  |  |  |  |  |  | NA
Q4 | NA | 0.1 |  |  |  |  |  |  | 0.055- (0.0217 (1/3 of 0.065) + 0.0333 (1/3 of the 0.1))
 | 0.25 |  |  | This should still equal 25%
Q5 | 3 | 0.05
Q6 | 3 | 0.05
Q7 | NA | 0.05
Q8 | 2 | 0.05
Q9 | 3 | 0.05
 | 0.3 |  |  | This should still equal 30%
Q10 | 3 | 0.03
Q11 | 3 | 0.02
Q12 | NA | 0.02
Q13 | 3 | 0.05
Q14 | 3 | 0.07
Q15 | 3 | 0.07
Q16 | 3 | 0.02
Q17 | 3 | 0.02
Spreadsheet: 61207d1262026999-index-match-formula-tied-to-cell-value-index-match
Sheet: Teams

Team | Nickname |  |  |  |  |  | Year
Arizona | Cardnials |  |  |  |  |  | 2008
Atlanta | Falcons |  |  |  |  |  | 2009
Baltimore | Ravens |  |  |  |  |  | 2010
Buffalo | Bills
Cleveland | [NAME]
Carolina | Panthers
Chicago | Bears
Cincinnatti | Bengals
Dallas | Cowboys
Denver | Broncos
Detroit | Lions
Green Bay | Packers
Houston | Texans
Indianapolis | Colts
Jacksonville | [NAME]
New York | Jets
Kansas City | Chiefs
Miami | [NAME]
New England | Patroits
New Orleans | Saints
New York | Giants
Philadelphia | Eagles
Pittsburgh | Steelers
Oakland | Raiders
St Louis | [NAME]
[NAME] | Chargers
Seattle | Seahawks
San Francisco | 49'ers
Tampa Bay | Buckaneers
Tennessee | Titans
Minnesota | Vikings
Washington | Redskins
Spreadsheet: 60563d1261075186-excel-2007-autofill-help-current-frieght-cc-test
Sheet: Delivered

 |  |  |  | Price Per Pound | 0.35
 |  | One Pallet |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 | 35 | 30 | 25 | 20 | 15 | 10 | 5
 |  | 25 | 12' x 16 GA Galv/ 125 |  |  | WI
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Two Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Three Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Four Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Five Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Six Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Seven Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Eight Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Nine Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  | Ten Pallets |  |  |  |  |  |  |  | Delivered Price Per BNDL
 |  | Quantity | Product | Weight | Price Per BNDL | State | Freight | Total |  | CURRENT | 40 |  | 30 | 25 | 20 | 15 | 10 | 5
 |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  | Difference
 |  |  |  |  |  |  |  |  |  | Savings
 |  |  |  |  |  |  |  |  |  | Extra BNDL
 |  |  |  | THIS SHOULD READ 51.60
 |  |  |  | IN THE WEIGHT COLUMN
 |  |  |  | NOT 54.20
Spreadsheet: darrell_schoolcraft__7299__imball0112
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 53056 | 52585
2 | 52799 | 52585
3 | 56198 | 57327
4 | 39345 | 38839
5 | 57736 | 57595
6 | 53279 | 52981
7 | 49516 | 48633
8 | 58091 | 56822
9 | 56234 | 59388
10 | 58416 | 59388
11 | 33275 | 41442
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 35912.71
2001-12-11 00:00:00
CBS Volume
 |  |  | 17122
Spreadsheet: 39451d1237607066-being-able-to-type-a-code-and-search-stats-test
Sheet: main page

Code | player | Innings | Dismissals | Not outs | 50's | 100's | Runs | Average
 | name | count all scores | count all dismissals | count all not outs. (not outs have the formula score/1 | all scores above 50 but less then 100 | all scores above 100 | sum of all scores | runs divided by dismissals
I want to be able to put in the players code then have all their stats show up above. I would like to view stats as all, last 12months, this or any calendar year
I then want to be able to see their current form here too. I want a drop down menu and be able to pick; All (every score made), last 12 months, this calendar year
and hopefully have the headings on the 3rd row in scores above the scores (the one with the team and what test it was) I would also like these form guides not to include the blank cells that have no scores in them
Spreadsheet: 521355d1496526168-index-multiple-tables-on-multiple-sheets-testing
Sheet: Team L

Case Number | Media Source | Status | ATT Team Leader | Case Owner | [NAME] | Case Summary
 |  |  |  |  | Testing
 |  |  |  |  | Testing 2
Top 3 Case Drivers
Outliers Resolve
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Outliers ORS
Please include Who:  What: Opportunity for promise behaviors 2 - 3 agents
Workflow Outliers *507100
Please include Who:  What: Opportunity for the workflow per mycst*507100 2 - 3 agents
Spreadsheet: 881804d1729992033-2025-player-of-the-year-formula-2025-poy-test
Sheet: POY

HOAKS RANKING | HOAKS Points | Club | Name | Rounds | Total $ | WPts | WINS | Points Delta | Total $ per round
 |  | H | Loiselle, John
 |  | H | [NAME], [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Barnett, [NAME]
 |  | H | King, [NAME]
 |  | H | Cleveland, [NAME]
 |  | H | Butters, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Haynes, Fred
 |  | H | Goss, [NAME]
 |  | H | Flowers, [NAME]
 |  | H | Smith, [NAME]
 |  | H | Staab, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Kindler, [NAME]
 |  | H | Barnard, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | [NAME], Jerry
 |  | H | Reese, Marvin
 |  | H | Blocker, Butch
 |  | H | Stehle, [NAME]
 |  | H | Niles, [NAME]
 |  | H | Hall, [NAME]
 |  | H | House, [NAME]
 |  | H | Smith, [NAME]
 |  | H | [NAME], Justin
 |  | H | [NAME], [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Campbell, [NAME]
 |  | H | Highsmith, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Calhoun, Lamar
 |  | H | Zimmerman, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Gafford, Jerry
 |  | H | [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Martin, [NAME]
 |  | H | McDonald, Todd
 |  | H | Newton, [NAME]
 |  | H | Harper, April
 |  | H | Hedgecoth, Burke
 |  | H | [NAME], [NAME]
 |  | H | Snow, [NAME]
 |  | H | Spence, Scott
 |  | H | Hockaday, [NAME]
 |  | H | [NAME], [NAME]
 |  | H | Madrey, Clyde
 |  | H | [NAME], [NAME]
 |  | H | Zimmerman, Lester
 |  | H | [NAME], [NAME]