tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 874cc1fe-7abc-4044-a3e9-05c7a4a0b51f
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
FCYNS | Test | FCYNS | Thiocyanate, Serum | Thiocyanate, S | Spectrophotometry (SPEC) |  |  |  |  |  | Submit only 1 of the following specimens:  Serum Draw blood in a plain, red-top tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of serum refrigerated in a plastic vial.  [NAME] blood in a green-top (sodium heparin) tube(s). ([NAME] tube is not acceptable.) Spin down and send 2 mL of sodium heparin plasma refrigerated in a plastic vial.  Note: Submission of the minimum volume results in an elevated reporting limit and inability to repeat analysis. | 0.12 mL | Hemolysis:	NA Thawing:	Cold OK; Warm OK Lipemia:	NA Icterus:	NA Other:	NA | Units:    mg/dL   Toxic thiocyanate concentrations: Greater than 10 mg/dL   Test Performed by:  Medtox Laboratories, Inc.                                402 West County Road D                                [NAME], MN 55112 | Monday through Sunday | 1 day | 3 - 5 days | 1 | 84430 |  |  |  |  | Medtox Laboratories, Inc
FCYNS | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FCYNS | Result | FCYNS | Thiocyanate, S | Thiocyanate, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 58994d1259316218-changing-a-set-set-of-cells-by-a-date-cell-date-changes
Sheet: Sheet 1

 |  |  |  |  |  | no of cells used from
 |  |  |  |  | number of cells on sheet  2 is placed here in cell F4
 |  |  |  |  |  |  |  | 1 | 2009-09-11 00:00:00
 |  |  |  |  |  |  |  | 2 | 2009-09-18 00:00:00
 |  |  |  |  |  |  |  | 3 | 2009-09-25 00:00:00
 |  |  |  |  |  |  |  | 4 | 2009-10-02 00:00:00
 |  |  |  |  |  |  |  | 5 | 2009-10-09 00:00:00
 |  |  |  |  |  |  |  | 6 | 2009-10-16 00:00:00
 |  |  |  |  |  |  |  | 7 | 2009-10-23 00:00:00
 |  |  |  |  |  |  |  | 8 | 2009-10-30 00:00:00
 |  |  |  |  |  |  |  | 9 | 2009-11-06 00:00:00
 |  |  |  |  |  |  |  | 10 | 2009-11-13 00:00:00
 |  |  |  |  |  |  |  | carnival | 2009-11-14 00:00:00
 |  |  |  |  |  |  |  | 11 | 2009-11-20 00:00:00
 |  |  |  |  |  |  |  | Gala | 2009-11-22 00:00:00
 |  |  |  |  |  |  |  | 12 | 2009-11-27 00:00:00
 |  |  |  |  |  |  |  | 13 | 2009-12-04 00:00:00
 |  |  |  |  |  |  |  | zone | 2009-12-11 00:00:00
 |  |  |  |  |  |  |  | 14 | 2009-12-18 00:00:00
 |  |  |  |  |  |  |  | 16 | 2010-01-15 00:00:00
 |  |  |  |  |  |  |  | 17 | 2010-01-22 00:00:00
 |  |  |  |  |  |  |  | 18 | 2010-01-29 00:00:00
 |  |  |  |  |  |  |  | 19 | 2010-02-05 00:00:00
 |  |  |  |  |  |  |  | 20 | 2010-02-12 00:00:00
 |  |  |  |  |  |  |  | regional | 2010-02-19 00:00:00
 |  |  |  |  |  |  |  | 21 | 2010-02-26 00:00:00
 |  |  |  |  |  |  |  | 22 | 2010-03-05 00:00:00
 |  |  |  |  |  |  |  | 23 | 2010-03-12 00:00:00
 |  |  |  |  |  |  |  | 24 | 2010-03-19 00:00:00
 |  |  |  |  |  |  |  | 25 | 2010-03-26 00:00:00
Spreadsheet: 0a8a0f8c-686e-4fb5-98dd-5c48b5964031
Sheet: DATOS VISITANTE

Código: R-SEG-021 Fecha: Nov de 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Versión: 1.0 |  |  | Código: R-SEG-021 Fecha: Nov de 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Versión: 1.0
Controlado |  |  |  | INFORMACION DE VISITANTES A CAMPOS RUBIALES, PIRIRI y QUIFA |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Página 1 de 1 |  |  | Controlado |  |  |  |  |  | INFORMACION DE VISITANTES A CAMPOS RUBIALES, PIRIRI y QUIFA |  |  |  |  |  |  |  |  | Página 2 de 2
Primer Nombre | Segundo Nombre | Primer Apellido | Segundo Apellido | [NAME] Identificación | Numero Identificación | [NAME] | Fecha de Nacimiento       DD - MM - YYYY | Direccion [NAME] | Departamento | Municipio | Vereda | Pais | Sexo | Tipo de Sangre | [NAME] | Nivel Educativo | Telefono fijo | [NAME] | Cargo | [NAME] trabajo | Teléfono Personal | [NAME] | [NAME] | EPS | ARP | [NAME] | Tétanos | Empresa Contratista | [NAME] | Numero del Contrato | [NAME] | [NAME] | Campo o Bloque | Área | Grupo | [NAME] | [NAME] | Conducirá en Campo | Fecha expedición Permiso de Conducción en campo
Spreadsheet: 675619d1588371608-conditional-drop-down-auto-fill-option-is-this-possible-competitor-autofill-eba-2
Sheet: Market Share by Competitor

 |  | Market Share by Competitor
 |  |  |  |  |  | [NAME] is Autofill from Source Data Tab
 |  | Service Area
 |  | Competitor | Est Sales | Share
TOP
Competitor |  | PHC |  |  |  |  |  |  |  |  |  |  |  | Competitors
 |  |  |  |  |  | Hydraulic IND | Pneumatic | Fluid Connectors
#1 |  | DEF Company
#2
#3 |  |  |  |  |  | ABC Company | 123 Connect | ABC Company | 123 Connect
#4 |  |  |  |  |  | DEF Company | 456 Fluid | DEF Company | 456 Fluid
 |  |  |  |  |  | HIJ Inc. | 789 Tools | HIJ Inc. | 789 Tools
 |  |  |  |  |  | [NAME] | 0 Mfg. | [NAME] | 0 Mfg.
 |  |  |  |  |  | NOP Express |  | NOP Express
 |  |  |  |  |  | QRS Inc. |  | QRS Inc.
 |  |  |  |  |  | TUV Organization |  | TUV Organization
 |  |  |  |  |  | WXY LLC |  | WXY LLC
 |  |  |  |  |  | Z Corporation |  | Z Corporation
 |  | OTHER
 |  | TOTAL
Spreadsheet: 725795d1616867387-list-combinations-that-equal-over-10-excel-help-over-10-combos
Sheet: Sheet1

number | v | h |  |  |  |  |  | Example |  |  |  |  | 0.1
982 | -0.103388572841949 | -0.1222112292851845 |  |  |  |  |  | 925h | 926v
983 | -0.1003610108303251 | -0.08862815884476516 |  |  |  |  |  | 925h | 928v
924 | -0.1242986525292691 | -0.09255577645239665 |  |  |  |  |  | 925h | [NAME]
925 | -0.1141618497109826 | 0.149132947976879
926 | -0.03741392501912766 | -0.156847742922724
927 | -0.08144519289650953 | -0.1515003061849356
928 | 0.01385542168674703 | -0.1566265060240966
929 | -0.09638019098378858 | -0.1157672662669332
934 | -0.07464528069093157 | -0.1689080814312152
935 | -0.07020714583622945 | -0.1567009592659537
936 | 0.01448511983144596 | -0.1708454042665264
Spreadsheet: 89330d1289123749-removing-duplicate-get-last-updated-row-book1
Sheet: Sheet1

Unit | Data | [NAME] |  |  | Unit | Data | [NAME]
1 | 10 | abc |  |  | 1 | 40 | d
1 | 20 | asdf |  |  | 2 | 20 | d
1 | 30 | asdf |  |  | 3 | 40 | df
1 | 40 | d |  |  | 4 | 50 | yu
2 | 10 | a |  |  | 5 | 60 | ut
2 | 30 | asdf |  |  | 6 | 50 | [NAME]
2 | 20 | d
3 | 30 | gh
3 | 40 | df
4 | 70 | er
4 | 60 | tr
4 | 50 | yu
5 | 50 | we
5 | 60 | ut
6 | 70 | [NAME]
6 | 10 | tyr
6 | 30 | [NAME]
6 | 50 | [NAME]
Spreadsheet: eric_saibi__9976__111501R
Sheet: Riverside 01

Owner Name |  | AEP - Public Service Company of Oklahoma
Station Name |  | Riverside Power Station
Unit Name |  | Riverside 01
NERC Region |  | SPP
State |  | OK
Fuel Type |  | Natural Gas / Fuel Oil
Capacity |  | 472 MW
Start Date |  | 2001-11-30 00:00:00
End Date |  | 2001-12-13 00:00:00
Prv. Start Date |  | 2001-11-15 00:00:00
Prv. End Date |  | 2001-11-28 00:00:00
Comments |  | Boiler / Valve Work
SIC |  | 4911
Plant ID |  | 1009107
Unit ID |  | 1007284
Outage ID |  | 1175
Spreadsheet: 141497d1329301189-formula-needed-for-counting-text-example-3
Sheet: Sheet1

Language | Answer
Slovak | Yes
Polish | Yes |  |  | Count of Language | Answer
Polish | No |  |  | Language | No | Yes | Grand Total
Hungarian | Yes |  |  | Czech | 1 | 4 | 5
Slovak | Yes |  |  | Hungarian |  | 2 | 2
Portuguese | Yes |  |  | Lithuanian | 1 | 4 | 5
Slovak | Yes |  |  | Polish | 2 | 13 | 15
Czech | Yes |  |  | Portuguese |  | 1 | 1
Spanish | No |  |  | Slovak |  | 4 | 4
Czech | Yes |  |  | Spanish | 1 | 1 | 2
Czech | Yes |  |  | Turkish |  | 1 | 1
Polish | Yes |  |  | Grand Total | 5 | 30 | 35
Polish | Yes
Polish | Yes
Slovak | Yes
Polish | Yes
Czech | No
Czech | Yes
Hungarian | Yes
Polish | Yes
Polish | Yes
Lithuanian | Yes
Polish | No
Turkish | Yes
Spanish | Yes
Polish | Yes
Lithuanian | Yes
Polish | Yes
Polish | Yes
Lithuanian | No
Polish | Yes
Polish | Yes
Lithuanian | Yes
Polish | Yes
Lithuanian | Yes
Spreadsheet: 770236d1645909782-sumifs-on-multiple-rows-and-columns-multiple-creteria-v1
Sheet: Data

 |  | Local Currency | Local Currency | US Dollar | US Dollar
Entity |  | Locked Forecast | Prior Month Forecast | Locked Forecast | Prior Month Forecast
Australia | Jan 22 | 1741941.205200051 | 1553267.54 | 1245417.969187299 | 1114659.9832079
Australia | Jan 22 | 790551 | 934487.6400000001 | 565212.2000743559 | 670609.5056296
Australia | Jan 22 | 255378.4955762368 | 299741.53 | 182585.3630404648 | 215101.3139671
Australia | Jan 22 | 127869.7648350515 | 145991.71 | 91421.74395505153 | 104766.9592174
Spreadsheet: 685978d1594302307-automatic-change-billing-format-in-excel-bill-format
Sheet: STST002

SUN JEWELLERY
#20/1 NEW STREET, NAGA
TEL: [PHONE]
CUSTOMER DETAILS: |  |  |  |  |  |  |  | Date : |  | ESTIMATE BILL FORMATE WITHOUT OLD PURCHASE
Mr/Mrs. Iqbal M |  |  |  |  |  |  |  | Est No: | STST002
Contact : [PHONE] |  |  |  |  |  |  |  | Gold Per Grm : | 4680
India |  |  |  |  |  |  |  | Silver Per Grm : | 54
ESTIMATE
S.No. | [NAME] | PCS | PURITY | RATE | GRS.WT | NET.WT | WASTAGE | HALL MARK | AMOUNT
1 | Earing | 1 | 916 |  | 1.1 |  | 0.08 | 250
 |  |  |  |  |  |  |  | Total
OLD PURCHASE |  | PCS
S.No. | [NAME] |  | PURITY | RATE | GRS.WT | NET.WT |  | AMOUNT
1
2
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Less Purchase
 |  |  |  |  |  |  |  | Discount
 |  |  |  |  |  |  |  | Net Amount
 |  |  |  |  |  |  |  | Less Discount | 59.84
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  | Cash Received | 6000
 |  |  |  |  |  |  |  | [NAME] | 250
 |  |  |  |  |  |  |  | Net Amount
Spreadsheet: 493895d1481932176-filtering-combined-items-within-a-given-set-of-rows-in-pivot-table-copy-of-sample-workbook-2
Sheet: Pivot Table (Before)

EMP NAME | Week count | PAY PERIOD | DATE | DESCR | Sum of HOURS | Sum of AMT | Sum of All Breaks | Sum of ADJ HOURS | Sum of Average Pay | Sum of Paid
[NAME] | 3 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 64 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 3 | 07/01/12-07/07/12 | 2012-07-03 00:00:00 | Hourly | 9 | 64 | 1.33 | 7.67 | 9.34419817470665 | 10.64
[NAME] | 3 | 07/01/12-07/07/12 | 2012-07-05 00:00:00 | Hourly | 2 | 10.08 | 0 | 2 | 0 | 0
[NAME] | 3 | 07/01/12-07/07/12 Total |  |  | 19 | 138.08 | 1.66 | 17.34 | 17.6883963494133 | 13.28
[NAME] 2 | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] 2 | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 76.6 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Piece Rate | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 71.28 | 0.33 | 7.67 | 8.34419817470665 | 0
[NAME] | 2 | 07/01/12-07/07/12 | 2012-07-02 00:00:00 | Hourly | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
[NAME] | 2 | 07/01/12-07/07/12 Total |  |  | 8 | 73.24 | 0.33 | 7.67 | 8.34419817470665 | 2.64
Spreadsheet: 94095d1293932745-formula-for-sport-rankings-wrestlingleage
Sheet: 112

Weight | Ranking | First Name | Last Name | School | Section | Grade
112 | 1 | Victor | Lopez | Calexico | SD | 10 | reno 1
112 | 2 | Vincent | [NAME] | Frontier | CS | 10 | 2010 CIF 6
112 | 3 | Ian | Nickell | Bakersfield | CS | 12 | 2010 CIF 7
112 | 4 | Garrett | Fortado | Oakdale | SJ | 11 | 2010 CIF 8
112 | 5 | [NAME] | Rodriguez | Clovis West | CS | 11 | reno 7
112 | 6 | Hugo | [NAME] | Alhambra | SS | 12 | 2010 CIF t12
112 | 7 | [NAME] | Rodriguez | Righetti | SS | 11 | zink 1
112 | 8 | Arnulfo | Olea | Exeter | CS | 10
112 | 9 | Kasey | Klaus | Vacaville | SJ | 11 | reno t12
112 | 10 | Kioni | Villalobos | Santa Fe | SS | 11 | reno t12
112 | 11 | [NAME] | Navarro | [NAME] | CS | 11 | zink 2
112 | 12 | [NAME] | Knoblauch | Clovis West | CS | 9 | zink 3
Spreadsheet: 735493d1623034630-extract-unique-values-from-a-range-book2
Sheet: Sheet1

1 | 2 | 3 |  | a | b | c | d | e | f | g
a | 3 | c
d | e | 4
5 | a | b
e | f | d
2 | 4 | b
d | a | f
Spreadsheet: 157841d1337886905-color-cells-rgb-colors-error-1004-colorme
Sheet: Sheet2

255 | 255 | 255
255 | 45 | 50
60 | 54 | 17
8 | 57 | 54
11 | 188 | 200
154 | 74 | 78
77 | 87 | 95
54 | 87 | 77
Spreadsheet: 865289d1712326272-add-drop-down-list-to-show-entire-rows-based-on-the-cell-color-in-column-c-test_probe-builds-workbook-2024
Sheet: If user selects green

 | Names highlighted Violet are [NAME] for VAST XT Assemblies. |  |  |  |  |  | Names highlighted Green are [NAME] for VAST XTR Assemblies.
Pos | Axis Tip | Name | Pcs | Order Number | Thread Type | DK | L | ML | MLE | DS | DSE | DG | B | W0 | W1 | [NAME] | Weight (grams) | F
 |  | Combo10 (SP)
1 | 1, 4 | Stylus | 2 | [PHONE]-050 | M5 | 2 | 50 | 40 |  | 1.5 |  | 11 |  | 0 | 0 | 0 | 6.4
A |  | Adapter plate rotatable M5 | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  |  |  |  |  | 158
B |  | REACH CFX 1 Extension | 1 | [PHONE]-300 | M5 |  | 100 |  |  |  |  | 11 |  | 180 |  |  | 12.25
C |  | Cube | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  | 15 |  |  |  | 8
D |  | REACH CFX 1 Extension | 2 | [PHONE]-300 | M5 |  | 60 |  |  |  |  | 11 |  |  |  |  | 9.38
 |  | Combo11 (SP)
1 | 1, 4 | Stylus | 2 | [PHONE]-064 | M5 | 3 | 64 | 64 |  | 2 |  | 11 |  | 0 | 0 | 0 | 8
A |  | Adapter plate rotatable M5 | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  |  |  |  |  | 158
B |  | Extension | 1 | [PHONE]-000 | M5 |  | 100 |  |  |  |  | 11 |  | 180 |  |  | 12.25
C |  | Cube | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  | 15 |  |  |  | 24
D |  | REACH CFX 1 Extension | 1 | [PHONE]-300 | M5 |  | 60 |  |  |  |  | 11 |  |  |  |  | 9.38
E |  | Extension | 1 | [PHONE]-000 | M5 |  | 60 |  |  |  |  | 11 |  |  |  |  | 14
 |  | Combo12 (SP)
1 | 1, 4 | Shouldered stylus | 2 | [PHONE]-030 | M5 | 1 | 30 | 19 | 10 | 2 | 0.8 | 11 |  | 0 | 0 | 0 | 7
A |  | Adapter plate rotatable M5 | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  |  |  |  |  | 158
B |  | REACH CFX 1 Extension | 1 | [PHONE]-300 | M5 |  | 100 |  |  |  |  | 11 |  | 180 |  |  | 12.25
C |  | Cube | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  | 15 |  |  |  | 8
D |  | REACH CFX 1 Extension | 2 | [PHONE]-300 | M5 |  | 60 |  |  |  |  | 11 |  |  |  |  | 9.38
 |  | Combo15 (SP)
1 | 3 | Stylus | 1 | [PHONE]-418 | M3 | 1 | 5 | 5 |  | 0.8 |  | 5 | 9 | 0 | 0 | 0 | 0.8
A |  | Adapter plate rotatable M5 | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  |  |  |  |  | 158
B |  | Adapter M5/M3 | 1 | [PHONE]-000 | M5/M3 |  | 10 |  |  |  |  | 11 |  | 0 |  |  | 5
C |  | REACH CFX 1 Extension | 1 | [PHONE]-300 | M5 |  | 100 |  |  |  |  | 11 |  |  |  |  | 2.04
D |  | Clamping screw | 1 | [PHONE]-004 | M3 |  | 8 | 5 |  |  |  | 3.5 |  |  |  |  | 0.5
 |  | Combo17 (SP)
1 | 4 | Stylus | 2 | [PHONE]-070 | M5 | 3 | 70 | 60 |  | 2 |  | 11 |  |  |  |  | 9.5
A |  | Adapter plate rotatable M5 | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  |  |  |  |  | 158
B |  | REACH CFX 1 Extension | 1 | [PHONE]-300 | M5 |  | 100 |  |  |  |  | 11 |  | 180 |  |  | 12.25
C |  | Cube | 1 | [PHONE]-000 | M5 |  |  |  |  |  |  |  | 15 |  |  |  | 8
D |  | REACH CFX 1 Extension | 2 | [PHONE]-300 | M5 |  | 120 |  |  |  |  | 11 |  |  |  |  | 13.68
Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: #11. 26 May 2017

Paychecks Dated 26 May 2017 |  | A | check | B | C | D | E |  | F |  | G | Total Job Hours | Total Hours-Per Job |  |  |  |  | [NAME]-first week |  |  |  |  |  | [NAME]-second week
 |  | Total Hours | Total Hours | Regular Hours | Overtime Hours | Total Hours | Total Hours |  | Overtime Hours |  | Overtime Hours |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
# |  |  |  |  |  | Week #1 | Week #2 |  | Week #1 |  | Week #2 |  | 1 | 2 | 3 | 4 | 5 | 2017-05-08 00:00:00 | 2017-05-09 00:00:00 | 2017-05-10 00:00:00 | 2017-05-11 00:00:00 | 2017-05-11 00:00:00 | 2017-05-12 00:00:00 | 2017-05-15 00:00:00 | 2017-05-17 00:00:00 | 2017-05-18 00:00:00 | 2017-05-19 00:00:00
Job |  |  |  |  |  |  |  | > | 40 | > | 40
1 | customer #1 name |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  | X | X |  |  |  |  |  |  | X | X
2 | customer #2 name |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  | X | X |  | X
3 | customer #3 name |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | X
4 | customer #4 name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  |  |  | X
5 | Shop,  Non-Billable |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  |  |  |  |  | X
Employee
1 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25 | 9 |  |  |  |  |  |  | 9.25 | 10.25
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9.25 | 9 |  | 10.25
 | name of employee #1
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
 | name of employee #1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | Hours-Regular
 | Hours-Overtime |  |  |  |  |  |  |  |  |  |  |  | 0
2 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 7.5 |  |  |  |  |  |  | 8.5 | 8
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 |  |  | 9.5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 | name of employee #2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7.5
 | Hours-Regular
 | Hours-Overtime
 | Subtotal-A
 | subtotal-B+C |  |  |  |  | check |  |  |  |  |  |  | check
 | Subtotal-Hours Per Job
 | Subtotal-detail |  |  |  |  |  |  |  |  |  |  |  | less: shop
 |  |  |  |  |  |  |  |  |  |  |  |  | hours without shop
Sales
 | n/a
Employee-Office/Overhead |  | regular | overtime | total
8 | Juro | 65
 |  | 0
 |  | Regular | Overtime | Total
 | Cost of Goods Sold
 | Overhead
 | Total
 |  | regular | Overtime | Total
 | grand total hours
 | check
Spreadsheet: 78852d1279142752-lookup-or-match-index-archery-example3
Sheet: Sheet1

 |  |  | Rounds
Bow | Category |  | York | [NAME] | Bristol | There are a further 56 rounds
Recurve | ladies |  | 10000 | 10000 | 10000 |  |  |  |  | 900 | 1st class
Recurve | ladies | GMB | 1080 | 1165 | 10000 |  |  |  |  | 883 | 2nd class
Recurve | ladies | MB | 977 | 1091 | 10000 |  |  |  |  | 476 | Unclassified
Recurve | ladies | [NAME] | 786 | 952 | 10000
Recurve | ladies | 1st Class | 511 | 723 | 911
Recurve | ladies | 2nd Class | 308 | 508 | 725 |  | Bow | Category | Round | Score | Classification
Recurve | ladies | 3rd Class | 142 | 280 | 473
Recurve | ladies | Unclassified |  |  |  |  | Recurve | gents | [NAME] | 884 | 1st Class | 1st Class
Recurve | gents |  | 10000 | 10000 | 10000
Recurve | gents | GMB | 1146 | 10000 | 10000
Recurve | gents | MB | 1065 | 10000 | 10000
Recurve | gents | [NAME] | 913 | 10000 | 10000 |  | remarks: | all "empty looking" cells in col A and B (for example A4:A9, B4:B9) are filled with the appropriate values like "[NAME]", "ladies" etc..
Recurve | gents | 1st Class | 698 | 884 | 10000 |  |  | all "empty looking" cells in col D, E and F above the highest number (for example F3:F6) are filled with an arbitrary high number (10000 in the example)
Recurve | gents | 2nd Class | 511 | 723 | 911
Recurve | gents | 3rd Class | 283 | 477 | 695
Recurve | gents | Unclassified
Recurve | U18 |  | 10000 | 10000 | 10000
Recurve | U18 | JMB | 1015 | 1118 | 10000
Recurve | U18 | JBowman | 839 | 992 | 10000
Recurve | U18 | 1st Class | 511 | 723 | 911
Recurve | U18 | 2nd Class | 283 | 477 | 695
Recurve | U18 | 3rd Class | 89 | 192 | 353
Recurve | U18 | Unclassified
 | There are a further 37 categories below this where bow and category vary
Archery classifications explained.
Every time you shoot one of the 59 rounds (which vary in the numbers of arrows, distance, and target size) in addition to a handicap score you earn a classification. They Range from Grand Master Bowman (GMB) to unclassified. You need to achieve or exceed a particular score to get the respective classification.  Some rounds are less demanding and the higher classification cannot be earned by shooting them.  There are 40 Categories of archer depending on age, gender and bow type with varying ‘thresholds’ for the awards.
In the table for example looking at the recurve gents ‘Hereford Round’ |  |  |  |  |  |  | Score | Clasification
 |  |  |  |  |  |  | 900 | 1st class
 |  |  |  |  |  |  | 883 | 2nd class
 |  |  |  |  |  |  | 476 | Unclassified
Spreadsheet: 68478d1269010073-sorting-multiple-ranges-on-one-sheet-example
Sheet: Sheet1

 |  |  |  |  |  |  | Corona Energy
Site | MPR | Renewal Date | AQ | Current Rate | Total |  | p/kWh | Standing Charge | Total
Site 1 | 123456789 | 2010-05-01 00:00:00 | 884554 | 2.402 | 21246.98708 |  | 1.9994 |  | 17685.772676
Site 2 | 123456789 | 2010-05-01 00:00:00 | 769796 | 2.402 | 18490.49992 |  | 2.1237 |  | 16348.157652
Site 3 | 123456789 | 2010-05-01 00:00:00 | 896083 | 2.402 | 21523.91366 |  | 1.9994 |  | 17916.283502
Site 4 | 123456789 | 2010-05-01 00:00:00 | 688321 | 2.402 | 16533.47042 |  | 2.1237 |  | 14617.873077
Site 5 | 123456789 | 2010-05-01 00:00:00 | 798039 | 2.402 | 19168.89678 |  | 2.1237 |  | 16947.954243
Site 6 | 123456789 | 2010-05-22 00:00:00 | 42700 | 2.402 | 1025.654 |  | 1.574 | 1.42 | 1190.398
 |  |  |  | Total | 97989.42186 |  | Total |  | 84706.43915
 |  |  |  |  |  |  | Saving |  | -13282.98271
 |  |  |  |  |  |  | EON Energy
 |  |  |  |  |  |  | p/kWh | Standing Charge | Total
 |  |  |  |  |  |  | 1.916 | 226.08 | 19661.01464
 |  |  |  |  |  |  | 1.916 | 226.08 | 17462.25136
 |  |  |  |  |  |  | 1.916 | 226.08 | 19881.91028
 |  |  |  |  |  |  | 1.916 | 226.08 | 15901.19036
 |  |  |  |  |  |  | 1.916 | 226.08 | 18003.38724
 |  |  |  |  |  |  | 1.916 | 226.08 | 3531.092
 |  |  |  |  |  |  | Total |  | 94440.84588
 |  |  |  |  |  |  | Increase |  | -3548.575980000009
 |  |  |  |  |  |  | Total Gas & Power
 |  |  |  |  |  |  | p/kWh | Standing Charge | Total
 |  |  |  |  |  |  | 2.96 | 9.27 | 26216.6339
 |  |  |  |  |  |  | 2.96 | 9.27 | 22819.7971
 |  |  |  |  |  |  | 2.96 | 9.27 | 26557.8923
 |  |  |  |  |  |  | 2.96 | 9.27 | 20408.1371
 |  |  |  |  |  |  | 2.96 | 9.27 | 23655.7899
 |  |  |  |  |  |  | 2.96 | 9.27 | 1297.7555
 |  |  |  |  |  |  | Total |  | 120956.0058
 |  |  |  |  |  |  | Increase |  | 22966.58394000001
 |  |  |  |  |  |  | Regent Gas
 |  |  |  |  |  |  | p/kWh | Standing Charge | Total
 |  |  |  |  |  |  | 1.7706 | 5.47 | 17658.463124
 |  |  |  |  |  |  | 1.7706 | 5.47 | 15626.557976
 |  |  |  |  |  |  | 1.7706 | 5.47 | 17862.595598
 |  |  |  |  |  |  | 1.7706 | 5.47 | 14183.961626
 |  |  |  |  |  |  | 1.7706 | 5.47 | 16126.628534
 |  |  |  |  |  |  | 1.7706 | 5.47 | 2752.5962
 |  |  |  |  |  |  | Total |  | 84210.80305799999
 |  |  |  |  |  |  | Increase |  | -13778.61880200001
 |  |  |  |  |  |  | Hydro Gas
 |  |  |  |  |  |  | p/kWh | Standing Charge | Total
 |  |  |  |  |  |  | 1.855 | 278.27 | 19747.7167
 |  |  |  |  |  |  | 1.856 | 244.32 | 17219.25376
 |  |  |  |  |  |  | 1.81 | 229.85 | 18977.3023
 |  |  |  |  |  |  | 1.81 | 175.2 | 14561.0101
 |  |  |  |  |  |  | 1.856 | 256.07 | 17884.44384
 |  |  |  |  |  |  | 1.911 | 69.51 | 1650.117
 |  |  |  |  |  |  | Total |  | 90039.8437
 |  |  |  |  |  |  | Increase |  | -7949.578160000005