tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 827061d1682454248-pull-data-from-one-sheet-to-another-from-last-data-entered-in-a-column-and-the-12-24-above-ak-sample3-netspy-
Sheet: COVER-12

 | ANIMAL KINGDOM |  |  |  |  |  | unlock 1111 |  |  |  |  |  |  | combo | Cover
Well No. | 12H | 13H | 14H | 15H | Total |  |  |  |  |  |  |  |  | combo
Start Date: |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Online/Hrs |  |  |  |  |  |  |  |  |  |  |  |  |  | combo
Choke |  |  |  |  |  |  |  |  |  |  |  |  |  | lt f
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | lt p
Casing PSI |  |  |  |  |  |  | Copy and paste table into email body |  |  |  |  |  |  | fork
Surface Csg |  |  |  |  |  |  |  |  |  |  |  |  |  | lift
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | trash
Water / Day |  |  |  |  |  | Clear | enter water totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | ft
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | ft
Oil / Day |  |  |  |  |  |  | enter oil totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
[NAME] to sales |  |  |  |  |  |  |  |  |  |  |  |  |  | plug C
Gas / Day |  |  |  |  |  |  | enter gas totals in this row.  the row above where 0 is will calculate bbl per hour |  |  |  |  |  |  | plug C
Inj / Day | off | off | off |  |  |  |  |  |  |  |  |  |  | st
 |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Yesterday Lact |  |  |  |  |  |  |  |  |  |  |  |  |  | st
Notes: |  |  |  |  |  |  | gfhghcghghgvhvgvgvhgvhvghvgvgh
 | PM
 | 12H | 13H | 14H | 15H
GAS
WATER
OIL
 | AM |  |  |  |  |  | lact total
 | 12H | 13H | 14H | 15H |  |  | 0430 | 24 b4 |  |  |  |  | IF(g28-h28<0,0,g28-h28)
GAS |  |  |  |  |  | 750 |  | 118029
WATER |  |  |  |  |  | 760
OIL |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  | 0
Spreadsheet: 810883d1672149362-excell-cell-data-to-the-column-split-cells
Sheet: Sheet1

[NAME], Y1=3912463.269 |  | 520136.964 | 3912463.269
A2 X2=520134.004, Y2=3912459.874 |  | 520134.004 | 3912459.874
A10 X10=520131.852, Y10=3912457.465 |  | 520131.852 | 3912457.465
A9 X9=520131.852, Y9=3912457.466 |  | 520131.852 | 3912457.466
[NAME], Y101=3912457.467 |  | 520131.852 | 3912457.467
A78 X78=520131.852, Y78=3912457.468 |  | 520131.852 | 3912457.468
Spreadsheet: 813346d1673688824-formula-to-grouping-data-grouping-data-etaf
Sheet: Sheet1

 |  | abc | Amount
 |  | 1 a | 3000 |  |  |  | abc | Amount | Sum of Amount
 |  | 1 a | 2000 |  |  |  | 1 a | 2000 | 2000
 |  | 2 a | 4000 |  |  |  |  | 3000 | 3000
 |  | 2 a | 5000 |  |  |  | 1 a Total |  | 5000
 |  | 2 a | 6000 |  |  |  | 2 a | 4000 | 4000
 |  | 3 a | 7000 |  |  |  |  | 5000 | 5000
 |  | 3 a | 8000 |  |  |  |  | 6000 | 6000
 |  | 3 a | 9000 |  |  |  | 2 a Total |  | 15000
 |  | 3 a | 10000 |  |  |  | 3 a | 7000 | 7000
 |  | 3 a | 9000 |  |  |  |  | 8000 | 8000
 |  |  |  |  |  |  |  | 9000 | 18000
 |  |  |  |  |  |  |  | 10000 | 10000
 |  |  |  |  |  |  | 3 a Total |  | 43000
 |  |  |  |  |  |  | Grand Total |  | 63000
Spreadsheet: 842921d1694915340-formula-to-be-modify-sample-book_finish_placement
Sheet: Sheet1

 |  |  |  |  | Desired Result on yellow
 |  |  |  | Name | Place | What I'm trying to achieve;
 |  |  |  | [NAME] |  | [NAME] on F5 to be modify to look for values 3 or 4 on columns j12:j25, M12:M25, P12:P25, S12:S25, if value is 3, to retrieve value from k10 to column F, if value is 4, to retrieve value from  Q10
 |  |  |  | [NAME] |  |  |  |  |  | Place |  |  |  |  |  | Place
 |  |  |  | [NAME] |  |  |  |  | 3rd= | 17 |  |  |  |  | 4th= | 25
 |  |  |  | [NAME] |  |  |  | H1 |  |  | H2 |  |  | H3 |  |  | H4
 |  |  |  | [NAME] | 25 |  |  | [NAME] | 1 |  | [NAME] | 1 |  | [NAME] | 1 |  | Pablo Díaz | 1
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 2 |  | [NAME] | 4 |  | Hector Santamaría | 3 |  | [NAME] | 2
 |  |  |  | Esteban Chaves Morua |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 2 |  | [NAME] | 3
 |  |  |  | [NAME] | 25 |  |  | [NAME] | 4 |  | [NAME] | 3 |  | Moises Montalvo | 4 |  | [NAME] | 4
 |  |  |  | [NAME] | 25 |  |  | H5 | Plc. |  | H6 | [NAME] |  | H7 | [NAME] |  | H8 | [NAME]
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 3 |  | Ricardo Delgado | 2 |  | Esteban Chaves Morua | 2 |  | [NAME] | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 2 |  | [NAME] | 3 |  | Micha Cantor | 3 |  | Shane Kertesz | 1
 |  |  |  | [NAME] | 17 |  |  | [NAME] | 1 |  | [NAME] | 1 |  | [NAME] Orias | 1 |  | Lucas Madrid | 2
 |  |  |  | Giovanni Marín | 17 |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 4 |  | Mikel Kauffmann | 4
 |  |  |  | [NAME] |  |  |  | H9 | [NAME] |  | H10 | [NAME] |  | H11 | [NAME] |  | H12 | [NAME]
 |  |  |  | Hector Santamaría | 17 |  |  | Israel Barona | 1 |  | [NAME] | 3 |  | [NAME] | 1 |  | [NAME] | 1
 |  |  |  | Israel Barona |  |  |  | [NAME] | 3 |  | [NAME] | 2 |  | [NAME] | 3 |  | [NAME] | 2
 |  |  |  | [NAME] Orias |  |  |  | Ricardo Lucke | 2 |  | [NAME] | 1 |  | [NAME] | 4 |  | Giovanni Marín | 3
 |  |  |  | [NAME] |  |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 2 |  | [NAME] | 4
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME]
 |  |  |  | Lucas Madrid
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | Micha Cantor | 17
 |  |  |  | [NAME]
 |  |  |  | Mikel Kauffmann | 25
 |  |  |  | Moises Montalvo | 25
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 17
 |  |  |  | Pablo Díaz
 |  |  |  | [NAME] | 17
 |  |  |  | Ricardo Delgado
 |  |  |  | Ricardo Lucke
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 17
 |  |  |  | Shane Kertesz
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME]
 |  |  |  | [NAME] | 17
 |  |  |  | [NAME] | 25
 |  |  |  | [NAME] | 25
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Documen

Documentation
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90010673 | [NAME], BRIDGETTE S | Staff [NAME] | SPECJR-CS
90125132 | [NAME], [NAME] I | Spec SR Deal Compl | SPECSR-CS
90011512 | BALFOUR-FLANAGAN, CYNTHIA | Spec Sr Global Mgmt | SPECSR-CS
90011516 | BELL, JEAN A | Spec Deal Compl | SPEC-CS
90006405 | BOTELLO, ROSALINDA | [NAME] | ADM-CS
90011517 | BOWEN, [NAME] | [NAME] | SPECSR-CS
90011514 | CAMPOS, SYLVIA A | Spec Sr Global Mgmt | SPECSR-CS
90006404 | CASON, SHAREN A | Staff Deal Compl | SPECJR-CS
90143702 | DELAHOUSSAYE, [NAME] | Staff Deal Compl | SPECJR-CS
90138881 | DEMING, RICHARD | Staff Deal Compl | SPECJR-CS
90011425 | DENTON, RHONDA L | Spec Deal Compl | SPEC-CS
90005382 | DEWETT, LAURA C | Spec Trans Supt | SPEC-CS
90127634 | ELLEDGE, SUSAN | Spec Global Mgmt | SPEC-CS
90138631 | FISCHER, JASON | Spec SR Deal Compl | SPECSR-CS
90012469 | HARE, BILL D | Mgr Global Mgmt | MGR-CS
90011506 | HILLIARD, MARLENE | Spec Sr Global Mgmt | SPECSR-CS
90123500 | HUNDL, KIMBERLY D | Spec Deal Compl | SPEC-CS
90011522 | HUNTER, LARRY J | Spec Sr Business Analyst | SPECSR-CS
90011429 | INDELICATO, [NAME] | Spec Deal Compl | SPEC-CS
90123505 | METOYER, EVELYN D | Spec Deal Compl | SPEC-CS
90140971 | MULVANY, PATRICK | Staff Deal Compl | SPECJR-CS
90011428 | MURPHY, MELISSA A | Spec SR Deal Compl | SPECSR-CS
90125753 | MYERS, DONNIE | Specialist Sr Operational Analyst - Lead | SPECSR-CS
90005881 | NEUNER, DALE R | Mgr Trans Supt | MGR-CS
90134181 | NEVES, BRENNA | Spec IRM | SPEC-CS
90005383 | PIWETZ, STEPHANIE | Staff Deal Compl | SPECJR-CS
90011510 | RICHARDSON, STACEY L | Spec Sr Global Mgmt | SPECSR-CS
90011427 | THERIOT, KIM S | Dir Deal Compliance | DIR-CS
90123708 | THOMPSON, KERRI | Staff Deal Compl | SPECJR-CS
90104726 | WALLUMROD, ELLEN | Spec SR Deal Compl | SPECSR-CS
 |  | Employees
Spreadsheet: 552611d1513686812-need-formula-help-to-find-out-count-find-out-count
Sheet: Report

 |  |  |  |  |  |  | Year | Batch
 | Year | Product | No of Batch
 | 2015 | X1 | =? | Answer should be 2 |  |  | 2010 | X1
 |  |  |  |  |  |  | 2011 | X2
 |  |  |  |  |  |  | 2012 | X3
 |  |  |  |  |  |  | 2013 | X4
 |  |  |  |  |  |  | 2014 | X5
 | * I would like to find out howmany times 'C6' occurs in the table for 'B6' |  |  |  |  |  | 2015 | X6
 |  |  |  |  |  |  | 2016 | X7
 |  |  |  |  |  |  | 2017 | X8
 |  |  |  |  |  |  |  | X9
 |  |  |  |  |  |  |  | X10
Spreadsheet: andy_zipper__530__Broker & Exchange Detail 11-27-01 EM
Sheet: EXCHANGE DEAL SUMMARY

EnronOnline Exchange Detail for 11/27/2001
Completed Transactions:
TODAY
Date | 2001-11-27 00:00:00
Count
Exchange Party | Counterparty Name | Commodity | Total
Grand Total
No Activity
LTD
Date | (All)
Count
Exchange Party | Counterparty Name | Commodity | Total
True Quote LLC | PG&E Energy Trading - Power, L.P. | US East Power | 91
 |  | US West Power | 25
 | Tucson Electric Power Company | US West Power | 2
 | Cinergy Marketing & Trading, LLC | Natural Gas | 2
 | Conectiv Energy Supply, Inc. | US East Power | 11
 |  | Natural Gas | 1
 | Tractebel Energy Marketing, Inc. | US East Power | 1
 |  | Natural Gas | 15
 | CMS Marketing, Services and Trading Company | US East Power | 1
 |  | Natural Gas | 3
 | Calpine Energy Services, L.P. | US East Power | 4
 |  | US West Power | 2
 |  | Natural Gas | 9
 | CLECO Marketing and Trading, LLC | Natural Gas | 1
 | PG&E Energy Trading-Gas Corporation | Natural Gas | 131
 | Axia Energy, LP | Natural Gas | 3
 | Entergy-Koch Trading, LP | Natural Gas | 10
 | Conoco Inc. | Natural Gas | 13
 | Richardson Energy Marketing, Ltd. | Natural Gas | 1
True Quote LLC Total |  |  | 326
Grand Total |  |  | 326
Spreadsheet: 702566d1604416353-sum-x-and-y-axis-values-question
Sheet: Sheet1

 | Data I have now |  |  |  |  |  |  |  |  |  |  | Data I need to get (in two columns)
 |  | 0 | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08
 | 0 | 50 | 49.6 | 49.2 | 48.8 | 48.4 | 48.01 | 47.61 | 47.20999999999999 | 46.81
 | 0.1 | 46.02 | 45.62 | 45.22000000000001 | 44.83000000000001 | 44.43 | 44.04 | 43.64 | 43.25 | 42.86
 | 0.2 | 42.06999999999999 | 41.67999999999999 | 41.29000000000001 | 40.90000000000001 | 40.52 | 40.13 | 39.73999999999999 | 39.35999999999999 | 38.97000000000001
Spreadsheet: 112841d1308831647-counting-the-number-of-instances-copy-of-supplier
Sheet: Report

Supplier | No. of Order lines delivered | On time to 5 days early | 1 to 2 days late | 3 to 7 days late | Over 7 days late
AAL002 | 6 | 2 | 3 | 1
ALA001 | 1 |  |  | 1 |  |  |  |  | Supplier | Orders
ALD001 | 8 | 5 |  | 3 |  |  |  |  | A | 10
ALL001 | 3 | 1 | 1 | 1 |  |  |  |  | A | 20
ALN001 | 1 |  |  | 1 |  |  |  |  | B | 16
AMB002 | 1 |  |  |  | 1 |  |  |  | D | 15
AND002 | 35 | 10 | 15 | 0 | 10 |  |  |  | C | 20
APP002 | 1 | 1 |  |  |  |  |  |  | A | 13
ATL004 | 17 | 5 | 3 | 9 |  |  |  |  | C | 18
BAT001 | 1 | 1 |  |  |  |  |  |  | D | 15
BEL002 | 100 | 31 | 66 | 3 |  |  |  |  | B | 20
CCP001 | 1
CEN001 | 1
[NAME] | 5
CSM001 | 2 |  |  |  |  |  |  |  |  | Total
DIA001 | 2 |  |  |  |  |  |  |  | A
ECW001 | 43 |  |  |  |  |  |  |  | B
ELA001 | 4 |  |  |  |  |  |  |  | C
FEC001 | 4 |  |  |  |  |  |  |  | d
GDR001 | 1
GEM001 | 3
HAR006 | 1
HAY003 | 3
HER001 | 29
HIL001 | 4
HIW001 | 1
MET002 | 38
MET004 | 20
MET005 | 3
MID004 | 1
MMG002 | 8
MOR002 | 2
PAR001 | 1
PRE001 | 4
REF001 | 1
REL003 | 2
RIC001 | 5
RON001 | 3
RSC001 | 8
RYC001 | 5
SCH001 | 14
SEV001 | 2
SHA002 | 1
SSS002 | 1
STE001 | 18
TPS001 | 1
TUN001 | 1
TVH001 | 131
WHE001 | 16
Spreadsheet: 195521d1353535039-extract-find-and-concatenate-testing_result_for_forum-modified-by-tigeravatar-
Sheet: Test

Trigger Name List | Escalation Timestamp |  | Start Day & Time: | 2012-06-04 10:49:07
Account Number | 2012-06-04 04:32:35 |  | End Day & Time: | 2012-06-14 01:58:20
Account Number | 2012-06-01 02:44:47 |  | [NAME]: | Account Number
Account Number | 2012-06-04 04:03:23 |  | Count:
Account Number | 2012-06-04 04:44:52
Account Number; Social Security Number | 2012-06-04 02:21:05
Account Number; Social Security Number | 2012-06-04 04:42:34
OA1 - Outside Activities and Affiliations | 2012-06-04 10:49:07
Account Number | 2012-06-05 01:17:38
Account Number; GA1 - Guarantees and Assurances | 2012-06-07 04:16:04
EF1 - Email Faxes | 2012-06-04 01:58:20
UM1 - Unapproved Marketing / Restrictions on Marketing | 2012-06-20 04:18:14
Account Number | 2012-06-30 03:16:37
Spreadsheet: 103032d1300885030-extrapolation-formula-book1
Sheet: Sheet1

Nominal value | Ref value |  |  | Enter Value | 1000
5000000 | 25000 | 24999.98939008963 | 0.9999995756035852 | F1 Value = | 5.022731399118445
2000000 | 10000 | 10000.00939887708 | 1.000000939887708
1000000 | 5000 | 5000.016068472898 | 1.00000321369458
500000 | 2500 | 2500.019403270806 | 1.000007761308322
200000 | 1000 | 1000.021404149551 | 1.000021404149551
100000 | 500 | 500.0220711091326 | 1.000044142218265
50000 | 250 | 250.0224045889235 | 1.000089618355694
20000 | 100 | 100.0226046767979 | 1.000226046767979
10000 | 50 | 50.02267137275609 | 1.000453427455122
5000 | 25 | 25.02270472073518 | 1.000908188829407
2000 | 10 | 10.02272472952263 | 1.002272472952263
1000 | 5 | 5.022731399118445 | 1.004546279823689
500 | 2.5 | 2.522734733916353 | 1.009093893566541
200 | 1 | 1.022736734795098 | 1.022736734795098
100 | 0.5 | 0.5227374017546796 | 1.045474803509359
50 | 0.3 | 0.3180652350429835 | 1.060217450143278
20 | 0.25 | 0.2416428749595722 | 0.9665714998382888
10 | 0.2 | 0.1962886094664191 | 0.9814430473320956
5 | 0.16 | 0.1594469450535485 | 0.996543406584678
2 | 0.12 | 0.1211362134596494 | 1.009468445497079
1 | 0.1 | 0.0984 | 0.984
0.5 | 0.08 | 0.0799311760163716 | 0.999139700204645
0.2 | 0.06 | 0.06072590476254168 | 1.012098412709028
0.1 | 0.05 | 0.04932818071471684 | 0.9865636142943368
0.05 | 0.04 | 0.04006971031783962 | 1.001742757945991
0.02 | 0.03 | 0.03044205695316402 | 1.014735231772134
0.01 | 0.025 | 0.02472834768926587 | 0.9891339075706349
0.005 | 0.02 | 0.02008705194862547 | 1.004352597431273
0.002 | 0.02 | 0.02 | 1
0.001 | 0.02 | 0.02 | 1
Spreadsheet: 58989d1259299916-how-to-sum-data-dependent-on-value-in-column-a-summary
Sheet: Sheet1

Lot | Barley | Wheat |  | Lot | Barley | Wheat
1 | 50 | 75 |  | 1 | 195 | 154
2 | 47 | 24 |  | 2 | 132 | 59
3 | 65 | 35 |  | 3 | 1050 | 190
4 | 25 | 64 |  | 4 | 145 | 153
5 | 355 | 225 |  | 5 | 415 | 330
1 | 145 | 79 |  |  | 1937 | 886
2 | 85 | 35
3 | 985 | 155
4 | 120 | 89
5 | 60 | 105
 | 1937 | 886
Spreadsheet: 866949d1713863413-mathing-look-up-formula-help-data-sample-example
Sheet: incorrect data

379111000000 |  |  |  | [NAME] | CF96013 |  | 0 | 0 | 2013-06-20 00:00:00 | 2024-04-01 00:00:00 | PAUL SHARRY |  |  | Trail | 0 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0 | 0
379111000000 |  |  |  | [NAME] | CF96013 |  | 853.99 | 853.99 | 2010-02-24 00:00:00 | 2024-04-01 00:00:00 | HEATHER MULLIGAN |  |  | Trail | 0.15 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0.02 | 853.99
379111000000 |  |  |  | [NAME] | CF96013 |  | 0 | 0 | 2014-03-18 00:00:00 | 2024-04-01 00:00:00 | SUSAN MURRANT |  |  | Trail | 0 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0 | 0
379111000000 |  |  |  | [NAME] | CF96013 |  | 247749.41 | 247749.41 | 2014-06-20 00:00:00 | 2024-04-01 00:00:00 | LACHLAN PINDA |  |  | Trail | 42.08 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 4.21 | 247749.41
379111000000 |  |  |  | [NAME] | CF96013 |  | 0 | 0 | 2014-06-17 00:00:00 | 2024-04-01 00:00:00 | LYNETTE ENTWISTLE |  |  | Trail | 0 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0 | 0
379111000000 |  |  |  | [NAME] | CF96013 |  | 53725.19 | 53725.19 | 2015-08-11 00:00:00 | 2024-04-01 00:00:00 | JANETTE KIM |  |  | Trail | 9.13 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0.91 | 53725.19
379111000000 |  |  |  | [NAME] | CF96013 |  | 0 | 0 | 2015-08-18 00:00:00 | 2024-04-01 00:00:00 | JULIE FIESCHI |  |  | Trail | 0 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0 | 0
417511000000 |  |  |  | [NAME] | CF96013 |  | 0 | 0 | 2014-10-15 00:00:00 | 2024-04-01 00:00:00 | RYAN RIZK |  |  | Trail | 0 | Residential Mortgage - Retail |  | LINE OF CREDIT |  |  |  | Trail Rate 0.2000% |  | 0 | 0
Spreadsheet: 124969d1318775857-alphanumeric-sorting-sorting
Sheet: Sheet1

 |  |  | Progress | Level | Order |  |  |  |  |  |  | Lookup Table
 | Fred | m | 4 | F1 |  |  |  |  |  |  |  | 3 | 1
 | Barney | m | 5 | 1b |  |  |  |  |  |  |  | 3c | 2
 | Mark | m | 6 | 2 |  |  |  |  |  |  |  | 2a | 3
 | [NAME] | m | 4 | 3 |  |  |  |  |  |  |  | 2b | 4
 | Burt | m | 3 | 1c |  |  |  |  |  |  |  | 2c | 5
 | Dot | m | 6 | 4 |  |  |  |  |  |  |  | 1a | 6
 | Sharron | f | 8 | 9 |  |  |  |  |  |  |  | 1b | 7
 | Mikey | m | 8 | 7 |  |  |  |  |  |  |  | 1c | 8
 | [NAME] | m | 5 | 3c |  |  |  |  |  |  |  | F9 | 9
 | [NAME] | m | 5 | 3 |  |  |  |  |  |  |  | F8 | 10
 | [NAME] | m | 4 | 2a |  |  |  |  |  |  |  | F7 | 11
 | Conrad | m | 4 | 3 |  |  |  |  |  |  |  | F6 | 12
 | Betty | f | 7 | 1a |  |  |  |  |  |  |  | F5 | 13
 | [NAME] | f | 3 | F5 |  |  |  |  |  |  |  | F4 | 14
 | Sue | f | 3 | 2b |  |  |  |  |  |  |  | F3 | 15
 | [NAME] | f | 7 | F8 |  |  |  |  |  |  |  | F2 | 16
 | [NAME] | m | 4 | F6 |  |  |  |  |  |  |  | F1 | 17
 | [NAME] | m | 8 | 2c
 |  |  | I would like to sort the above data by column E, so that 3 is at the top and F1 at the bottom   eg, this order   3, 3c, 2a, 2b, 2c, 1a, 1b, 1c, F9, F8, F7, F6, F5, F4, F3, F2, F1  I have tried using If function but there is only 7 spaces...??
Spreadsheet: 86045d1286018962-compare-column-a-between-2-worksheets-and-sum-respective-columns-inventory1-1-
Sheet: 100

INHI_ItemNbr | INHI_CurrQty_1 | INHI_CurrQty_2 | INHI_CurrQty_3 | INHI_CurrQty_4 | INHI_CurrQty_5 | INHI_CurrQty_6 | INHI_CurrQty_7 | INHI_CurrQty_8 | INHI_CurrQty_9
005055 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
010350 | 66 | 79 | 69 | 0 | 15 | 64 | 65 | 110 | 48
010391 | 20 | 0 | 0 | 8 | 0 | 0 | 0 | 0 | 0
020140 | 3 | 3 | 12 | 7 | 4 | 5 | 1 | 14 | 4
020150 | 1 | 4 | 0 | 0 | 0 | 3 | 5 | 3 | 0
020200 | 1 | 2 | 23 | 0 | 1 | 0 | 1 | 3 | 24
020210 | 1 | 2 | 2 | 1 | 2 | 6 | 5 | 5 | 17
020220 | 4 | 9 | 6 | 6 | 6 | 0 | 1 | 5 | 4
020280 | 12 | 2 | 8 | 17 | 13 | 13 | 0 | 4 | 5
020300 | 16 | 18 | 3 | 3 | 1 | 4 | 15 | 0 | 0
020310 | 26 | 25 | 31 | 37 | 41 | 42 | 32 | 44 | 44
020320 | 19 | 13 | 40 | 9 | 45 | 38 | 48 | 13 | 97
020385 | 2 | 2 | 3 | 2 | 3 | 0 | 1 | 4 | 1
020630 | 2 | 0 | 5 | 0 | 5 | 1 | 3 | 10 | 0
020785 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
020930 | 6 | 8 | 9 | 11 | 6 | 10 | 6 | 4 | 14
020940 | 14 | 1 | 1 | 7 | 23 | 5 | 1 | 3 | 13
025020 | 6 | 4 | 7 | 5 | 10 | 8 | 5 | 12 | 8
025080 | 3 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 1
025140 | 5 | 0 | 15 | 4 | 1 | 0 | 0 | 3 | 1
025150 | 1 | 0 | 18 | 0 | 4 | 0 | 0 | 5 | 10
025170 | 7 | 0 | 15 | 0 | 9 | 1 | 1 | 2 | 0
025180 | 1 | 0 | 8 | 0 | 2 | 6 | 2 | 4 | 13
025190 | 8 | 14 | 29 | 7 | 6 | 8 | 11 | 14 | 18
025200 | 1 | 5 | 2 | 3 | 1 | 2 | 4 | 2 | 3
025210 | 7 | 7 | 5 | 5 | 8 | 9 | 8 | 11 | 10
025245 | 3 | 1 | 3 | 3 | 5 | 2 | 2 | 3 | 4
025290 | 1 | 3 | 2 | 1 | 1 | 1 | 1 | 4 | 0
025480 | 1 | 0 | 1 | 1 | 0 | 1 | 0 | 2 | 2
Spreadsheet: 856660d1705868891-soccer-tournament-results-i-need-formulas-to-calculate-statistics-schoolsoccertournament
Sheet: Munka2

Results of the school soccer tournament
Penalty points:
 | For red cards: | 1
 | For yellow cards: | 0.1
 | For missing a match: | 2
 | Number of teams:
 | Team Name | Played | Win | Draw | Loss | Goals scored | Goals conceded | Goal difference | Points | Missed a match | Yellow Cards | Red Cards | Penalty | Total Points | Lost Points | Precentage
 | [NAME] | 11 | 3 | 1 | 7 | 25 | 35 |  |  |  | 45 | 5
 | Botláb SE. | 10 | 3 | 0 | 8 | 21 | 45 |  |  |  | 6 | 5
 | Aranyláb | 11 | 11 | 0 | 0 | 43 | 9 |  |  |  | 5 | 1
 | Ezüstláb | 11 | 7 | 0 | 4 | 49 | 20 |  |  |  | 23 | 2
 | 1. FC. 11C. | 11 | 5 | 0 | 6 | 27 | 21 |  |  |  | 10 | 4
 | Rá-rá-hajrá | 10 | 2 | 0 | 9 | 16 | 46 |  |  |  | 14 | 6
 | Bírók réme | 5 | 0 | 0 | 11 | 5 | 96 |  |  |  | 1 | 11
 | HÓ SC. | 11 | 7 | 0 | 4 | 30 | 16 |  |  |  | 15 | 3
 | [NAME] | 11 | 8 | 1 | 2 | 55 | 24 |  |  |  | 12 | 2
 | Fit-ball fut-ball | 11 | 8 | 0 | 3 | 41 | 17 |  |  |  | 22 | 2
 | Utolsók | 11 | 6 | 1 | 4 | 29 | 17 |  |  |  | 14 | 3
 | 10 Á-szok | 11 | 4 | 1 | 6 | 35 | 30 |  |  |  | 45 | 5
Spreadsheet: e24db52b-3a00-4241-8656-32223d22ce1f
Sheet: Option 3

VENDOR NAME:
Description  Option 3: 100 [NAME] (Complete Red-Shaded Areas) | 3-Year Contract
 | Non-Recurring Charges | Monthly Recurring Charges July 1, 2013-June 30, 2014 | Monthly Recurring Charges July 1, 2014-June 30, 2015 | Monthly Recurring Charges July 1, 2015-June 30, 2016 | TOTAL  3 YEAR COSTS
CADM-Library System Administrative Office, 1601 Ritner Highway, Suite 100, Carlisle, PA 17013
1 Gbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
CADM-Library System Administrative Office, 1601 Ritner Highway, Suite 100, Carlisle, PA 17013
200 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
Cumberland County Court House, 1 Court House Square, Carlisle, PA 17013
100 Mbps Service to Internet
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
AME-Amelia [NAME], 114 North Baltimore Ave., Mt. Holly Springs, PA 17065
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
BOS-Bosler Memorial Library, 158 [NAME], Carlisle, PA 17013
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
FRE-Cleve J. Fredricksen Library, 100 N. 19th St., Camp Hill, PA 17011
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
EPB-East Pennsboro Branch Library, 98 S. Enola Drive, Enola PA 17025
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
JGR-[NAME], 9 Parsonage St., Newville, PA 17241
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
SIM-[NAME], 16 North Walnut St., Mechanicsburg, PA 17055
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
NCU-New Cumberland Public Library, 1 [NAME], New Cumberland, PA 17070
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
SHP-Shippensburg Public Library, 73 [NAME], Shippensburg, PA 17257
100 Mbps Service
Taxes, fees, surcharges: (Specify):
Other (Specify):
Subtotal
*TOTAL (without asterisked circuit)
TOTAL (including asterisked circuit)