tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 93895d1293658320-formula-for-sport-rankings-cagrapplerrankings2010
Sheet: 103

Ranking | First Name | Last Name | School | Section | Grade
1 | Micah | [NAME] | Central Union | SD | 10 | 2010 CIF 3rd
2 | Mason | Pengilly | Porterville | CS | 9
3 | [NAME] | Locsin | Live Oak | CC | 9 | reno 1
4 | [NAME] | [NAME] | Gilroy | CC | 11 | reno 2
5 | Adrian | Campasano | Central | CS | 12 | zink 1
6 | Gion | Peralta | Vacaville | SJ | 9 | reno 4
7 | Jaxon | Fitzgerald | Foothill | NS | 10 | reno 8
8 | Emilio | Saavedra | Pitman | SJ | 9 | pin pena
9 | [NAME] | Mai | North Torrance | SS | 11 | 2010 CIF t-12
10 | [NAME] | Pena | Selma | CS | 10 | zink 2
11 | Julian | Gaytan | Clovis | CS | 9 | zink 3
12 | Christian | Root | [NAME] | SS | 10 | reno t-12
13 | Tyler | Moore | [NAME] | CS | 9
 | [NAME] | [NAME] | Rancho [NAME] | SD | 12
 | George | Torres | [NAME] | SS | 11
 | Arturo | Carmona | Brawley | SD | 11
Spreadsheet: 218770d1362574693-dynamic-drop-down-listing-test-worksheet
Sheet: KIT LOC OVERVIEW

 |  | KIT | [NAME] |  |  | DURBAN | EWMS | GALLE | SUEZ | 21N - SEA PATROL
 |  | KIT001 | DURBAN
 |  | KIT002 | DURBAN
 |  | KIT003 | EWMS
 |  | KIT004 | 21N - SEA PATROL
 |  | KIT005
 |  | KIT006 | GALLE
 |  | [NAME] | DURBAN
 |  | KIT008 | DURBAN
 |  | KIT009 | EWMS
 |  | KIT010 | DURBAN
 |  | KIT011
 |  | KIT012
 |  | KIT013
 |  | KIT014
 |  | KIT015
 |  | KIT016
 |  | KIT017
 |  | KIT018
 |  | KIT019 | SUEZ
Spreadsheet: 803704d1667630350-sumproduct-indirect-reference-workbook-copy-1-copy
Sheet: Sheet2

Enter Sheet name in cell "B2" â |  |  | MATCH MULTIPLE CRITERIA TO GET AN OUTPUT
 | 2022 |  | Inclusion criteria |  |  |  |  |  |  | Filters
 |  |  | SBP |  | DBP |  | SBP |  | Past history | Age |  | HbA1C |  | Age |  | Past history
 |  |  | [NAME] | Min | [NAME] | Min | [NAME] | Min | Text only | [NAME] | Min | [NAME] | Min | [NAME] | Min | Text only | Result
Spreadsheet: chris_germany__2036__AppalPay200204
Sheet: Gatherco0001

StationID | Seq | STATION NAME | MLI | Type | Adjustment Description | From Date | To Date | PSIG | NET MCF | BTU | NET DTH | Bus_Period | Prod_Period | PRODUCER_NAME |  | InReg
705940 | 1 | SMALLY YANNAYON | GCO01 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 48 | 29 | 1018 | 29 | 200205 | 200204 | FLORENCE SMALLEY HOCHBERG
706480 | 1 | WALTERS - BURKHART | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | WILMA BURKHART
716865 | 1 | FOX & WELLS | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | FOX, WALTER/[NAME]
720186 | 1 | JONSU - THOMAS | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | [NAME]
722642 | 1 | K.C. PROD./J.R.K. SUPPLY | GCO03 | C |  | 2002-04-05 00:00:00 | 2002-05-01 00:00:00 | 59 | 15 | 886 | 13 | 200205 | 200204 | R.A. MILLER ENERGY
722796 | 1 | PARKSIDE - RICKETTS STAHL | GCO01 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | [NAME], INC.
722989 | 1 | BENATTY CORP. | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | NUTTCO OIL & GAS
727158 | 1 | BENATTY MAXWELL | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | [NAME]
727920 | 1 | ROYAL - MILLER #1 | GCO03 | C |  | 2002-04-05 00:00:00 | 2002-05-05 00:00:00 | 0 | 0 | 1032 | 0 | 200205 | 200204 | SIEGLINDE MILLER
730163 | 1 | -THE NIEB WELLS | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | NOBLE PETROLEUM
730539 | 1 | MFC-A.N. WOGAN | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | LEW BATES
731230 | 1 | WM/DECATUR WESTVACO | GCO03 | C |  | 2002-03-30 00:00:00 | 2002-04-30 00:00:00 | 33 | 51 | 1412 | 72 | 200205 | 200204 | WM OIL & GAS INC.
731303 | 1 | ENNEY-BALES/CLARK, ET AL | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | RANDELL OIL CO.
732211 | 1 | VIKING-BATTIG #1 | GCO01 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | EVERFLOW EASTERN INC.
733817 | 1 | GEORGETOWN WELL NO 3 | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | GEORGETOWN OIL CO.
734237 | 1 | H & R OIL AND GAS | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | H & R OIL & GAS
736139 | 1 | CONSOLIDATED COAL | GCO03 | C |  | 2002-04-01 00:00:00 | 2002-05-01 00:00:00 | 0 | 0 | 1000 | 0 | 200205 | 200204 | GEORGETOWN OIL CO.
705940 | 1 | SMALLY YANNAYON | GCO01 | A |  | 2002-01-31 00:00:00 | 2002-02-28 00:00:00 | 0 | 6 | 1018 | 6 | 200204 | 200202 | FLORENCE SMALLEY HOCHBERG, AGENT
Spreadsheet: 713934d1611013944-if-date-matches-one-of-the-dates-in-the-row-use-the-data-in-the-corresponding-column-sample
Sheet: Analysis

Delay Date Input | 2021-01-18 00:00:00 |  | 12
Date | List of equipment | Shift Change | Handover | Pre Start | Refuelling | Crib | Positioning | Unplanned maintenace | Planned maintenance | Total | Availability | Utilisation | Comments
2021-01-18 00:00:00 | A |  |  |  |  |  |  |  |  | 0 | =IF(B1=Input!B2:AE2,IF(Input!B3>0*(Input!B3-SUM(Analysis!C4:I4))/Analysis!$D$1,0),"")
2021-01-18 00:00:00 | B |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | C |  |  | 0.5 |  | 0.5 |  | 4 |  | 5
2021-01-18 00:00:00 | D |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | E |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | F |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | G |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | H |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | I |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | J |  |  |  |  |  |  |  |  | 0
2021-01-18 00:00:00 | K |  |  |  |  |  |  |  |  | 0
Spreadsheet: 4df1ee3d-5f50-4587-96ee-41f95e3c6c05
Sheet: SS4

 |  | ACTUALIZACIÓN DE DATOS: (Solo en caso de haber seleccionado este campo en la sección 1A  del campo de avisos)
TIPO DE MODIFICACIÓN |  |  |  |  |  |  |  |  |  |  | DICE |  |  |  |  |  |  |  |  |  |  | DEBE DE DECIR
REPRESENTANTE LEGAL
PERSONA AUTORIZADA
OTROS (DOMICILIO FISCAL, TELÉFONO,  FAX , CORREO ELECTRÓNICO)
 | SUSPENSIÓN DE ACTIVIDADES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REINICIO DE ACTIVIDADES |  |  |  |  |  |  |  |  | BAJA DEFINITIVA DEL ESTABLECIMIENTO
DE |  |  |  |  |  |  |  | A |  |  |  |  |  |  |  |  | FECHA
 | DÍA |  | MES |  | AÑO |  |  |  | DÍA |  | MES |  | AÑO |  |  |  |  |  | DÍA |  | MES |  | AÑO
 |  | MODIFICACIÓN DE: (solo en caso de haber seleccionado este campo en la sección 1B del campo de solicitudes)
NÚMERO DE DOCUMENTO A MODIFICAR:
DICE / CONDICIÓN AUTORIZADA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEBE DECIR / CONDICIÓN SOLICITADA
SI EL ESPACIO ES INSUFICIENTE PODRÁ AMPLIAR EL CAMPO.
DECLARO BAJO PROTESTA DECIR VERDAD QUE CUMPLO CON LOS REQUISITOS Y NORMATIVIDAD APLICABLE, SIN QUE ME EXIMAN DE QUE LA AUTORIDAD SANITARIA VERIFIQUE SU CUMPLIMIENTO, ESTO SIN PERJUICIO DE LAS SANCIONES EN QUE PUEDO INCURRIR POR  FALSEDAD DE DECLARACIONES DADAS A UNA AUTORIDAD. Y ACEPTO QUE LA NOTIFICACIÓN DE ESTE TRÁMITE SE REALICE A TRAVÉS DEL CENTRO INTEGRAL DE SERVICIOS U OFICINAS EN LOS ESTADOS CORRESPONDIENTES AL SISTEMA FEDERAL SANITARIO. (Artículo 35 fracción II de la Ley Federal de Procedimiento Administrativo)
LOS DATOS O ANEXOS PUEDEN CONTENER INFORMACIÓN CONFIDENCIAL, ¿ESTA DE ACUERDO EN HACERLOS PUBLICOS? |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SI |  |  | NO
NOMBRE Y FIRMA DEL PROPIETARIO, O REPRESENTANTE LEGAL  O RESPONSABLE SANITARIO O DE OPERACIÓN
PARA CUALQUIER ACLARACIÓN, DUDA Y/O COMENTARIO CON RESPECTO A ESTE TRÁMITE, SÍRVASE LLAMAR AL SISTEMA DE ATENCIÓN TELEFÓNICA A LA CIUDADANÍA (SACTEL) A LOS TELÉFONOS 2000-2000 EN EL D.F. Y ÁREA METROPOLITANA, DEL INTERIOR DE LA REPÚBLICA SIN COSTO PARA EL USUARIO AL [PHONE] O DESDE ESTADOS UNIDOS Y CANADÁ AL [PHONE], O A LOS TELÉFONOS DE LA COFEPRIS EN EL D.F. DE CUALQUIER PARTE DEL PAÍS MARQUE SIN COSTO EL [PHONE] Y EN CASO DE REQUERIR EL NÚMERO DE INGRESO Y/O SEGUIMIENTO DE SU TRÁMITE ENVIADO AL ÁREA DE TRAMITACIÓN FORÁNEA MARQUE SIN COSTO AL [PHONE].
Spreadsheet: 877886d1724829834-date-formula-world-rating-082824
Sheet: Sheet1

 | Rank | Name | Country | Rating | Games | Last Played
 | 1 | [NAME] | New Zealand | 2133 | 4123 | 2024-05-11 | 2024-11-05 00:00:00
 | 2 | [NAME] | Australia | 2109 | 1531 | 2024-06-08
 | 3 | Brett Smitheram | England | 2064 | 594 | 2024-05-06
 | 4 | [NAME] | United States | 2055 | 149 | 2024-07-24
 | 5 | [NAME] | Canada | 2048 | 1127 | 2024-07-07
 | 6 | [NAME] | Nigeria | 2046 | 711 | 2024-08-25
 | 7 | [NAME] | Singapore | 2045 | 1760 | 2024-08-03
 | 8 | Jesse Day | United States | 2037 | 866 | 2024-07-31
 | 9 | [NAME] | Nigeria | 2035 | 264 | 2024-07-19
 | 10 | [NAME] | United States | 2024 | 737 | 2024-07-25
Spreadsheet: 864765d1711891977-separating-data-into-different-columns-book1-283-aligw
Sheet: Sheet1

Software Name | Software Name | Version |  | Software Name | Version
[NAME] Agent [NAME] | [NAME] Agent Windows | 5.4.0.10
Microsoft Defender for Endpoint 10.8735.26020.1014 | Microsoft Defender for Endpoint | 10.8735.26020.1014 |  | Microsoft Defender for Endpoint | 10.8735.26020.1014
chrome web store payments Chrome-Plugin 1.0.0.6 | chrome web store payments Chrome-Plugin | 1.0.0.6 |  | chrome web store payments Chrome-Plugin | 1.0.0.6
Microsoft Edge Update 1.3.185.21 | Microsoft Edge Update | 1.3.185.21 |  | Microsoft Edge Update | 1.3.185.21
Microsoft Edge 122.0.2365.92 | Microsoft Edge | 122.0.2365.92 |  | Microsoft Edge | 122.0.2365.92
Microsoft Edge WebView2 Runtime 122.0.2365.92 | Microsoft Edge WebView2 Runtime | 122.0.2365.92 |  | Microsoft Edge WebView2 Runtime | 122.0.2365.92
Cisco Systems Umbrella Roaming Client 3.0.466.0 | Cisco Systems Umbrella Roaming Client | 3.0.466.0 |  | Cisco Systems Umbrella Roaming Client | 3.0.466.0
Igor Pavlov 7-Zip 23.01 64-Bit | Igor Pavlov 7-Zip | 23.01 64-Bit |  | Igor Pavlov 7-Zip 23.01 | 64-Bit
Microsoft.People 2021.2202.33.0 | Microsoft.People | 2021.2202.33.0 |  | Microsoft.People | 2021.2202.33.0
Microsoft.WindowsCamera 2022.2312.3.0 | Microsoft.WindowsCamera | 2022.2312.3.0 |  | Microsoft.WindowsCamera | 2022.2312.3.0
Microsoft.549981C3F5F10 4.2308.1005.0 | Microsoft.549981C3F5F10 | 4.2308.1005.0 |  | Microsoft.549981C3F5F10 | 4.2308.1005.0
Spreadsheet: 52253d1251968985-multiple-formulae-in-a-cell-an-algorithm-example-spreadsheet
Sheet: Sheet1

Ta | 24.4 | This is the other parameter and will vary in the Y axis (I.e. Columns)
RH | 49.6 | This is one parameter and will vary in the X axis (I.e. Rows)
Stage 1 | 1.516427451494184 |  | Example sheet would look like:
Stage 2 | 13.18175714853656 |  |  |  | RH
Stage 3 | 1514.52604824698 |  |  |  | -10 | -5 | …
Stage 4 | 0.009438239943284792 |  | Ta | 1 | FinalVal | FinalVal | FinalVal
Final Value | 9.349992470876751 |  |  | 2 | FinalVal | FinalVal | FinalVal
 |  |  |  | 3 | FinalVal | FinalVal | FinalVal
 |  |  |  | … | FinalVal | FinalVal | FinalVal
Spreadsheet: 1cac3159-375a-420e-a7f2-4f3108700c10
Sheet: Non-Hourly Rate Service Pricing

SIN(s) Proposed | Service Proposed (e.g. Labor Category or Job Title/Task) | Minimum Education / Certification Level | Minimum Years of Experience (cannot be a range) | Contractor or Customer Site | Domestic or Overseas | Commercial Price List (CPL) OR Market Prices | Unit of Issue (e.g. Day, Task, Sq Ft) | Most Favored Commercial Customer (MFC)* | Discount Offered to Commercial MFC (%) | Commercial MFC Price | Most Favored Federal Agency (MFC) ** | Most Favored Federal Agency (MFC) Price ** | Discount Offered to GSA (off CPL or Market Prices) (%) | Price Offered to GSA (Excluding IFF) | Price Offered to GSA (including IFF)
123-2 | Disposal Services | None | 0 | Customer Site | Overseas Only | 100 | Task | All Commercial Customers | 0 |  | N/A | N/A | 0.05
* Note:  GSA includes federal prime contractors as commercial customers.   ** Most Favored Federal Agency is sales directly to a Federal Agency as a prime contractor.  If no sales exist to Federal Agencies for the offered services, write “N/A.”
Spreadsheet: 853272d1703157507-retrieving-and-moving-transferring-data-excel-problem
Sheet: Sheet1

 | What function or command do I need to use to return results derived from averages, using the table to get the exact or nearest match and then return the value(s) from column E to a different sheet within the same workbook?
 |  |  |  |  |  | Overall Count Results
 |  |  |  |  | 9 | 49 | 39 | 45 | 55 | 46 | 25
 |  |  |  |  | 8 | 44 | 47 | 42 | 47 | 50 | 40
 |  |  |  |  | 7 | 30 | 44 | 43 | 59 | 49 | 62
 |  |  |  |  | 6 | 57 | 49 | 49 | 47 | 44 | 46
 |  |  |  |  | 5 | 40 | 50 | 44 | 43 | 49 | 40
 |  |  |  |  | 4 | 46 | 40 | 44 | 43 | 50 | 60
 |  |  |  |  | 3 | 42 | 49 | 37 | 59 | 36 | 44
 |  |  |  |  | 2 | 49 | 43 | 50 | 41 | 37 | 49
 |  |  |  |  | 1 | 50 | 55 | 50 | 47 | 51 | 52
 |  |  |  |  | 0 | 40 | 44 | 56 | 45 | 48 | 42
 |  | AVERAGES % |  |  |  | 44.7 | 46 | 46 | 48.6 | 46 | 46
 | E.G. | Column F Avg. is 45, closest match (F9) 46, which returns required result from E9 =4.
 |  | Column I Avg is 49, 3 closest matches returning 3 results, I5, I7 and I12.
 |  | Complete returned matches would hopefully be as follows in a different sheet:-
 |  | 4 | 8 | 9 | 8,6,1 | 9 | 6
 |  |  |  |  | OR
 |  | 4 | 8 | 9 | 8 | 9 | 6
 |  | 4 | 8 | 9 | 6 | 9 | 6
 |  | 4 | 8 | 9 | 1 | 9 | 6
Spreadsheet: 36515d1234382093-comparing-multiple-cells-matching-multiple-columns
Sheet: Sheet1

List 1 |  |  |  |  |  | List 2
Color | Size | Shape |  |  |  | Color | Size | Shape
R | S | Circle |  |  |  | B | M | Triangle
R | S | Triangle |  |  |  | B | M | Square
R | S | Square |  |  |  | B | L | Circle
R | M | Circle |  |  |  | R | M | Square
R | M | Triangle |  |  |  | R | L | Circle
R | M | Square |  |  |  | G | M | Circle
R | L | Circle |  |  |  | G | M | Triangle
R | L | Triangle |  |  |  | Y | M | Square
R | L | Square |  |  |  | Y | M | Triangle
B | S | Circle |  |  |  | Y | M | Circle
B | S | Triangle
B | S | Square
B | M | Circle
B | M | Triangle
B | M | Square
B | L | Circle
B | L | Triangle
B | L | Square
G | S | Circle
G | S | Triangle
G | S | Square
G | M | Circle
G | M | Triangle
G | M | Square
G | L | Circle
G | L | Triangle
G | L | Square
Spreadsheet: 880308d1727939342-help-with-percentile-function-task
Sheet: Sheet1

Name | Value | Grade (1-4) |  |  |  | Percentile | Grade
[NAME] | 9.4 |  |  |  |  | 0.15 | 1
[NAME] | 0 |  |  |  |  | 0.5 | 2
[NAME] | 6.1 |  |  |  |  | 0.85 | 3
[NAME] | 0 |  |  |  |  | 1 | 4
[NAME] | 5.6
[NAME] | 8.8
[NAME] | 3.2
[NAME] | 1.7
If the value in B column is 0, then the grade should be 1, for all the other values the grade should be based on percentile (the range of values for calculating percentile should include only the values which are greater than 0).
Spreadsheet: 67492d1268108640-excel-2007-function-to-calculate-new-wage-lw-wages
Sheet: Wages-Tables

Full-Time Employees | Column1 | Column2 | Column3 | Column4 | Column5
Years of Service | % Increase |  | Hourly Wage | Bonus Amount
1 | 0.01 |  | 8.4 | 250
2 | 0.015 |  | 9.75 | 300
4 | 0.02 |  | 10.75 | 350
6 | 0.03
7 | 0.03
9 | 0.04
10 | 0.045
Part-Time Employees | Column1 | Column2 | Column3 | Column4 | Column5
Years of Service | % Increase |  | Hourly Wage | Bonus Amount
1 | 0.0075 |  | 8.4 | 100
2 | 0.01 |  | 9.75 | 150
4 | 0.015 |  | 10.75 | 200
6 | 0.02
8 | 0.025
9 | 0.03
10 | 0.035
Spreadsheet: 0b405207-99c7-4a3a-bc47-07e0b78c73c5
Sheet: 11b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Cross-Currency Basis | 73 | 23 | 47 | 119 | 14 | 38 |  | 335
Cross-Currency Fixed-Fixed | 18 | 2 | 4 | 57 | 5 | 4 |  | 97
Cross-Currency Fixed-Float | 13 | 0 | 1 | 36 | 0 | 4 |  | 429
TOTAL
Spreadsheet: 176862d1346130141-nested-if-function-example
Sheet: Sheet1

3 | 05:00:00
 | 03:00:00
 | 04:00:00 | 12:01:00 |  | 02:00:00 |  | IF A1+B1 <= 4, return $20 IF A1+B1 > 4 but <= 9, return $35 IF A1+B1 > 9 but <= 14, return $50 IF A1+B1 > 15, return $75 | IF 4<E3<8, return IS IF A1+B1 > 4 but <= 9, return $35 IF A1+B1 > 9 but <= 14, return $50 IF A1+B1 > 15, return $75 | 04:00:00 | 08:00:00 | 16:00:00 | 1900-01-24 00:00:00
 | 05:00:00 | 07:00:00 |  |  |  |  | IF(4<E3<8,Inderjeet,IF(AND(8<E3<16,Rajeev,IF(AND(16<E3<24,Shailendra,IF(AND(E3>24,Rajesh)))))))
 |  |  |  | 5 |  |  |  | 4 | 8 | 16 | 24
 |  |  |  |  |  | IF(4<(E4)<8,"IS"),IF(AND(8<(E4)<16,"RC"),IF(AND(16<(E4)<24,"SK"),IF(AND(24<(E4),"RP","NIL")))
 |  |  |  | http://spreadsheetpage.com/index.php/tip/alternatives_to_nested_if_functions/ |  | IF(A1=A2,IF(4<(E4)<8 ,"IS", "RC"),"never")
 |  |  |  |  |  |  | IF(E3<TIME(4,0,0),E3>TIME(8,0,0),"s",IF(E3>TIME(8,0,0),"r",IF(E3>TIME(4,0,0),"i",IF(E3>TIME(0,0,1),"p",""))))
Spreadsheet: 06e742fa-c933-4acb-8b82-34a80fe2b0cd
Sheet: Grade 3 Reading

2013 Minnesota Comprehensive Assessments-Series III (MCA-III)
[NAME]
Scale Score | Level | Percentile Rank
301 | D | 1
302 | D | 2
303 | D | 2
304 | D | 2
305 | D | 2
306 | D | 3
307 | D | 3
308 | D | 3
309 | D | 3
310 | D | 4
311 | D | 4
312 | D | 4
313 | D | 5
314 | D | 5
315 | D | 5
316 | D | 6
317 | D | 6
318 | D | 7
319 | D | 7
320 | D | 7
321 | D | 8
322 | D | 9
323 | D | 9
324 | D | 10
325 | D | 10
326 | D | 11
327 | D | 12
328 | D | 13
329 | D | 13
330 | D | 14
331 | D | 15
332 | D | 16
333 | D | 17
334 | D | 18
335 | D | 20
336 | D | 21
337 | D | 22
338 | D | 23
339 | D | 25
340 | P | 26
341 | P | 28
342 | P | 29
343 | P | 31
344 | P | 33
345 | P | 34
346 | P | 36
347 | P | 38
348 | P | 40
349 | P | 42
350 | M | 44
351 | M | 46
352 | M | 48
353 | M | 50
354 | M | 52
355 | M | 54
356 | M | 56
357 | M | 58
358 | M | 60
359 | M | 63
360 | M | 65
361 | M | 67
362 | M | 69
363 | M | 71
364 | M | 73
365 | M | 74
366 | M | 76
367 | M | 78
368 | M | 79
369 | M | 81
370 | M | 82
371 | M | 84
372 | M | 85
373 | M | 86
374 | E | 88
375 | E | 89
376 | E | 90
377 | E | 91
378 | E | 91
379 | E | 92
380 | E | 93
381 | E | 94
382 | E | 94
383 | E | 95
384 | E | 95
385 | E | 96
386 | E | 96
387 | E | 97
388 | E | 97
389 | E | 97
390 | E | 98
391 | E | 98
392 | E | 98
393 | E | 98
394 | E | 98
395 | E | 98
396 | E | 99
397 | E | 99
398 | E | 99
399 | E | 99
End of Worksheet
Spreadsheet: 807206d1669803762-creating-a-shipping-calculator-with-several-factors-kalk-frakt
Sheet: Sheet1

input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Shipping |  | [NAME]
 | Length | 1.2 | m | Input length |  |  |  |  |  |  |  |  |  |  |  |  | Base price | Weight (kg) | 32.5
 | Height | 1.2 | m | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Price range 0-20.5 | 0 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price range 21-50kg | 21 | 11
 | Area |  | m² | LxH |  |  |  |  |  |  |  |  |  |  |  |  | Price range 50-100kg | 50 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra cost, over 1.2m |  | 200
 | Weight |  | [NAME] | Area*5kg + 5kg
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight |  | [NAME]
 | Shipping cost |  | USD | Base price + weight of product * price range (Here it needs to lookup the price from the correct range, in this case 0-20.5kg price) + Lookup if the input height or length is above 1.2m ( If it is, add the additional cost) |  |  |  |  |  |  |  |  |  |  |  |  | std |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | area |  | 5
Spreadsheet: 490876d1480112035-transport-elements-according-the-surname-my-book
Sheet: Φύλλο3

SUPERVISOR ID | NAME & LASTNAME | AGE | GENGER | PHONE
1 | [NAME] | 25 | M | 55555
2 | [NAME] | 36 | F | 99999
3 | [NAME] | 30 | M | 22222
4 | [NAME] | 38 | M | 11111
This area (a part of the document) is what I have to document and printed for presentation. Here I want all to be automatically. if in the sheet 2 and in the first cell I have a surname, I need here to give all the information of names, which I will get from one sheet 1
Spreadsheet: 116307d1311739777-if-then-help-2011-day-ride-saddle-and-paddle-summary
Sheet: Saddle & Paddle 2011

SADDLE & PADDLE 2011
DATE | Party Name | # of Riders |  | $ Adults |  | $ Kids |  | Total Amt. | Pd Cash | Pd Charge | Bkd By | Chg By | ABO | YRC | pay ABO | pay YRC |  |  |  |  | How Heard | First Name | Last Name | Address | City | Sate | Zip | phone # | email | Notes
 |  | Adult | Child | ABO | YRC | ABO | YRC
 |  |  |  | 50 | 35 | 50 | 25
2011-05-31 00:00:00 | [NAME] | 2 | 1 |  |  |  |  |  |  | 320 | YRC | YRC |  |  |  |  |  |  |  |  | [NAME] |  | [NAME]
2011-06-03 00:00:00 | Jones | 4 | 1 |  |  |  |  |  | 415 |  | ABO | YRC
2011-06-04 00:00:00 | Smith | 3 | 2 |  |  |  |  |  | 405 |  | ABO | ABO
2011-06-05 00:00:00 | [NAME] | 1 | 4 |  |  |  |  |  | 300 | 85 | YRC | ABO
2011-06-06 00:00:00 | cassie | 1 | 1 |  |  |  |  |  | 160 |  | ABO | ABO
Spreadsheet: 139525d1328283718-if-statement-if-statement
Sheet: Sheet1

H | W | D
30 | 20 | 10
 |  |  | Item | H | W | D | Status
 |  |  | Box 1 | 26 | 15 | 8
 |  |  | [NAME] | 27 | 16 | 9
 |  |  | Box 3 | 28 | 17 | 9
 |  |  | [NAME] | 31 | 20 | 10
 |  |  | Box 5 | 30 | 19 | 10
 |  |  | Box 6 | 31 | 20 | 11
 |  |  | Box 7 | 32 | 21 | 12
 |  |  | Box 8 | 33 | 22 | 13
 |  |  | Box 9 | 34 | 23 | 10
 |  |  | Box 10 | 35 | 24 | 15
Spreadsheet: 87679d1287565845-if-two-conditions-are-met-only-then-look-for-example
Sheet: Fruit Mix

 |  | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday
 | OCTOBER | 2010-10-05 00:00:00 | 2010-10-06 00:00:00 | 2010-10-07 00:00:00 | 2010-10-08 00:00:00 | 2010-10-09 00:00:00 | 2010-10-10 00:00:00 | 2010-10-11 00:00:00
7:00am - 3:30pm | Area 1 | Apple | Apple | Pear | Pear | Apple | Apple | Apple
9:00am - 5:30pm | Area 1A | [NAME] | [NAME] | [NAME] | [NAME] |  |  | [NAME]
9:00am - 5:30pm | Area 1B | Fruit | [NAME] | Grape | Orange | Orange | Pear | Orange
6:30am - 3.00pm | Area 2 | Chocolate | Chocolate | Chocolate | Chocolate | [NAME] | Sunflower | [NAME]
10:00am - 6:30pm | Area 2A | Mandarin | Mango | Mango | Mango |  |  | Apple
11:00am - 7:30pm | Area 2B | Kiwi | Kiwi | Kiwi | Kiwi |  |  | kiwi
4.00pm - 12:30am | Area 3 & 4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
4.00pm - 12:30am | Area 3 & 4 | Grapes | Wine | Chocolate | Wine | Grapes | Grapes | Grapes
11:30am - 6:00pm | Area 5 |  |  |  |  | Cherries | Sun
6:00pm - 8:00pm | Area 6 |  |  |  | Grapes | Apple
8:30am - 5:30pm | Area 7 | cherries | cherries | cherries | cherries | Cherries | cherries | cherries
9:00am - 5:00pm | Garden | peacock | peacock | peacock | peacock | chestnut | chestnut | [NAME]
7:30am - 4:00pm | Piano | [NAME] | [NAME] | [NAME] | [NAME] |  |  | Kaiyan
9:00am - 5:30pm | Area 8 | Honey | Honey | Honey | Honey | Honey | Honey | Pear
(3 HOURS Mon - Fri) | Couch | Marshmellow | Marshmellow | Marshmellow | Marshmellow |  |  | Marshmellow
Spreadsheet: 490495d1479897185-if-function-is-not-reading-a-lookup-cell-correctly-example
Sheet: TEST 1

Class List
Full Name | Reg Group | EXPECTED GRADE | MYP |  | A | B | C | D | TOTAL OUT OF 32 | CURRENT GRADE | Progress |  |  |  |  | GRADING
[NAME] |  | N/A | N/A |  | 5 | 5 | 5 | 5
[NAME] |  | 5 | 5 |  | 4 | 5 | 3 | 3 |  |  |  |  |  |  |  | Level | from | to
Kelly |  | 5 | 6 |  | 6 | 6 | 6 | 6 |  |  |  |  |  |  |  | 1 | 0 | 5
[NAME] |  | 4 | 4 |  | 7 | 7 | 7 | 7 |  |  |  |  |  |  |  | 2 | 6 | 9
[NAME] |  | 6 | 6 |  | 8 | 8 | 8 | 8 |  |  |  |  |  |  |  | 3 | 10 | 14
[NAME] |  | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 15 | 18
[NAME] |  | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 19 | 23
Gavin |  | 6 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 24 | 27
[NAME] |  | 5 | 6 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 28 | 32
Penny |  | 4 | 6
[NAME] |  | 5 | 6
[NAME] |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  | If current grade is below expected grade return below in "L Column"
[NAME] |  | 4 | 6 |  |  |  |  |  |  |  |  |  |  | If current grade is above expected grade return above in "L Column"
 |  |  | 7 |  |  |  |  |  |  |  |  |  |  | If current grade is the same as expected, return on track im "L Column"
 |  |  | 6
 |  |  | 7
 |  |  | 6
 |  |  | 6
 |  |  | 7
 |  |  | 7
 |  |  | 6
 |  |  | 6
 |  |  | 7
 |  |  | 6