tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 55548d1255649891-sorting-columns-of-different-lengths-tidal
Sheet: Sheet1

time | time | tidal height |  |  | time | time | tidal height
01:15:00 | 01:15:00 | 1.342 |  |  | 01:15:00 | 01:15:00 | 1.342
01:15:02 | 01:16:00 | 1.221 |  |  | 01:15:02 | 01:15:00 | 1.342
01:15:04 | 01:17:00 | 1.115 |  |  | 01:15:04 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:06 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:08 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:10 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:12 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:14 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:16 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:18 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:20 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:22 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:24 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:26 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:28 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:30 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:32 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:34 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:36 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:38 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:40 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:42 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:44 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:46 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:48 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:50 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:52 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:54 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:56 | 01:15:00 | 1.342
 |  |  |  |  | 01:15:58 | 01:15:00 | 1.342
 |  |  |  |  | 01:16:00 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:02 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:04 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:06 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:08 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:10 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:12 | 01:16:00 | 1.221
 |  |  |  |  | 01:16:14 | 01:16:00 | 1.221
Spreadsheet: 707885d1607525196-how-to-assign-a-country-to-a-specific-area-dashboard
Sheet: PORTUGAL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: c22a8d10-9198-43f8-9b26-46e7d2380ab1
Sheet: Misc. Work Cars

Contract/ Type | Description | Numbers | Renumbers | Renumbers | Renumbers | Building | Notes | Status
Vacuum
none | Rubbish Collection Car | 43 | 5002 | 20145 |  | 1918 ACF | R&NRCD 113
none | Signal Supply Car | 44 | 5003 | 20170 |  | 1927 Diff Car | R&NRCD 114 | Coney Island Yard
R-3 | Supply Car | 51 |  | 20169 |  | 1932 Magor | R&NRCD 128
 | IRT Supply Car | 53 |  | 20127 | 30127 | 1906 Pressed Steel |  | Shore Line Trolley Museum
R-3 | [NAME] | 56 |  | 20128 | 30128 | 1932 Magor
 | [NAME] | V285A-V285C | 285A-285C | 20500A-20050C
 | Pump car |  | 5001 | 20136 | 30136
 | BMT Birney Rail Grinder |  | 5004
 | Trailer Rail Handling Car | S-102 |  | 20149 |  | 1956 NYCT
 | Supply Car A
 | Supply Car D
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: DataBase

Name | Day | Week day | IN/OUT | Hours |  |  |  | Name | Total Hours
SCOTT | 2021-11-01 00:00:00 |  | IN | 6 |  |  |  | [NAME]
[NAME] |  |  | IN | 6 |  |  |  | Scott
SCOTT |  |  | IN | 5.5 |  |  |  | Adam
[NAME] |  |  | IN | 6
ADAM |  |  | IN | 6
[NAME] |  |  | IN | 5.5
ADAM |  |  | IN | 6
[NAME] |  |  | IN | 6
SCOTT |  |  | IN | 5.5
[NAME] |  |  | IN | 6
SCOTT |  |  | IN | 6
Spreadsheet: 814793d1674593989-find-values-in-different-worksheets-pasta1
Sheet: Planilha1

 |  | 2023-05-01 00:00:00 | 2023-05-02 00:00:00 | 2023-05-03 00:00:00 | 2023-05-04 00:00:00 | 2023-05-05 00:00:00
 | Planilha2 | 115 | 116 | 117 | 118 | 119
 | Planilha3 | 15 | 16 | 17 | 18 | 19
 | Planilha4
 | Planilha5
 | Planilha6
 | Planilha7
 | Planilha8 | I need to find these values ​​in the corresponding worksheets
 | Planilha9
 | Planilha10
 | TMS
 | JT
Spreadsheet: 808492d1670497507-combine-2-sheets-grade-6
Sheet: WANAFUNZI 5 BORA NA 5 DUNI

HALMASHAURI YA WILAYA [NAME]
MATOKEO YA MTIHANI WA KUMALIZA MUHULA WA PILI  DARASA LA V  NOVEMBA,2022
E. WANAFUNZI 5 BORA
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
[NAME] DUNI
NA | JINA | JINSI 1=MV 2= MS | SHULE | KATA | MASOMO |  |  |  |  |  |  |  |  |  |  |  |  |  | JUMLA | WASTANI | DARAJA
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: andy_zipper__714__Asian Options
Sheet: Asian Stip Example

 | Asian on Multiple Underlyings
 | Function: ASTRIP, ASTRIP2m
 | EffDt | 1997-02-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OUTPUTS
 |  |  |  | INPUTS |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4
 | Premium | Avg. Start Date | Avg. End Date | Fwd Price | Ann.Vol | Time to Avg. Start | Time to Avg. End | # [NAME] Prices | Set Days | Strike | Ann.IntRt | Correlation | Avg. Price to Date | Time to [NAME] | Call/Put (1/0) | Month | Price | Delta | Gamma | Vega | Rho
 |  | 1997-01-01 00:00:00 | 1997-01-31 00:00:00 | 32.5 | 0.7538 |  |  |  |  | 40 | 0.045 | 0.25 | 32.5 |  | 0 | 1
 |  | 1997-02-01 00:00:00 | 1997-02-28 00:00:00 | 32.5 | 0.6817 |  |  |  |  |  |  |  |  |  |  | 2
 |  | 1997-03-01 00:00:00 | 1997-03-31 00:00:00 | 24.75 | 0.5275 |  |  |  |  |  |  |  |  |  |  | 3
 |  | 1997-04-01 00:00:00 | 1997-04-30 00:00:00 | 21.5 | 0.4521 |  |  |  |  |  |  |  |  |  |  | 4
 |  | 1997-05-01 00:00:00 | 1997-05-31 00:00:00 | 21.5 | 0.4725 |  |  |  |  |  |  |  |  |  |  | 5
 |  | 1997-06-01 00:00:00 | 1997-06-30 00:00:00 | 24.4 | 0.5251 |  |  |  |  |  |  |  |  |  |  | 6
 |  | 1997-07-01 00:00:00 | 1997-07-31 00:00:00 | 32 | 0.5996 |  |  |  |  |  |  |  |  |  |  | 7
 |  | 1997-08-01 00:00:00 | 1997-08-31 00:00:00 | 32 | 0.5765 |  |  |  |  |  |  |  |  |  |  | 8
 |  | 1997-09-01 00:00:00 | 1997-09-30 00:00:00 | 23.1 | 0.464 |  |  |  |  |  |  |  |  |  |  | 9
 |  | 1997-10-01 00:00:00 | 1997-10-31 00:00:00 | 21.3 | 0.3848 |  |  |  |  |  |  |  |  |  |  | 10
 |  | 1997-11-01 00:00:00 | 1997-11-30 00:00:00 | 22.4 | 0.3997 |  |  |  |  |  |  |  |  |  |  | 11
 |  | 1997-12-01 00:00:00 | 1997-12-31 00:00:00 | 26.35 | 0.4499 |  |  |  |  |  |  |  |  |  |  | 12
Description:
 | Here we find the premium and risk parameters for an Asian option where averaging is over multiple underlyings.  The averaging
periods needn't be continuous.  For example, averaging could be over the last 3 days of NYMEX for 6 months.  However, the averaging
periods must not overlap (I.e., the samples from the first underlying must all be determined before the price samples from the second
underlying begin, and so on.), and the strip of underlyings must be supplied in chronological order in which they contribute to the average |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xASTRIP2m
price.
 | The number of price samples taken from each underlying is explicitly specified by the user and, once defined, will never change
over the life of the option.
 | The input parameter "Set Days" tells the valuation routine the number of price points which have already been determined.
 | The correlation to be specified by the user is taken to be the correlation between all pairs of strip underlyings.
Spreadsheet: 491346d1480431450-months-since-last-purchase-and-reseller-count-months-since-purchase-and-reseller-count
Sheet: Months_since_purchase

Month | Reseller | Product | Qty |  | Reseller | Months since last purchase | Criteria
2016-05-01 00:00:00 | Customer 1 | Product 2 | 10 |  | Customer 1
2016-05-01 00:00:00 | Customer 1 | Product 2 | 30 |  | Customer 2
2016-05-01 00:00:00 | Customer 2 | Product 1 | 2 |  | Customer 3
2016-05-01 00:00:00 | Customer 3 | Product 1 | 4 |  | Customer 4
2016-06-02 00:00:00 | Customer 2 | Product 1 | 54 |  | Customer 5
2016-06-02 00:00:00 | Customer 2 | Product 4 | 1 |  | Customer 6
2016-06-02 00:00:00 | Customer 4 | Product 3 | 23
2016-06-02 00:00:00 | Customer 5 | Product 1 | 15
2016-06-02 00:00:00 | Customer 5 | Product 2 | 3
2016-06-02 00:00:00 | Customer 5 | Product 6 | 3
2016-07-03 00:00:00 | Customer 1 | Product 1 | 20
2016-07-03 00:00:00 | Customer 4 | Product 1 | 10
2016-07-03 00:00:00 | Customer 4 | Product 3 | 5
2016-07-03 00:00:00 | Customer 6 | Product 1 | 7
2016-08-04 00:00:00 | Customer 2 | Product 1 | 81
2016-08-04 00:00:00 | Customer 3 | Product 5 | 10
2016-09-05 00:00:00 | Customer 1 | Product 3 | 20
2016-09-05 00:00:00 | Customer 1 | Product 6 | 3
2016-09-05 00:00:00 | Customer 1 | product 6 | 7
2016-09-05 00:00:00 | Customer 4 | Product 2 | 1
2016-09-05 00:00:00 | Customer 4 | Product 3 | 8
2016-09-05 00:00:00 | Customer 6 | Product 1 | 11
2016-09-05 00:00:00 | Customer 6 | Product 4 | 17
2016-09-05 00:00:00 | Customer 6 | Product 4 | 10
2016-10-06 00:00:00 | Customer 2 | Product 2 | 15
2016-10-06 00:00:00 | Customer 2 | Product 3 | 20
2016-10-06 00:00:00 | Customer 3 | Product 1 | 61
2016-10-06 00:00:00 | Customer 5 | Product 1 | 2
2016-10-06 00:00:00 | Customer 5 | Product 2 | 5
Spreadsheet: 40223d1238534117-pesrsonal-stats-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | averages
 |  |  | aht | call wrk | call hld | unaval | adherance | asat |  |  | lowest asat | aht | call wrk | call hld | unaval | adherance
 | 2009-03-31 00:00:00 | a | 298 | 22 | 36 | 1.38 | 95.42 | 25.93 | 2009-02-03 00:00:00 | Red
 | 2009-03-31 00:00:00 | a | 285 | 26 | 52 | 1.05 | 94.03 | 25.93 | 2009-03-03 00:00:00 | Russ
 | 2009-03-31 00:00:00 | a | 298 | 23 | 38 | 10.51 | 95.97 | 25.93 | 2009-04-03 00:00:00 | [NAME]
 | 2009-03-31 00:00:00 | a | 301 | 30 | 25 | 2.94 | 86.39 | 25.93 | 2009-08-03 00:00:00 | [NAME]
 | 2009-03-31 00:00:00 | a | 291 | 13 | 45 | 1.09 | 93.75 | 25.93 | 90/03/09 | [NAME]
 | 2009-03-31 00:00:00 | a | 315 | 28 | 56 | 1.74 | 97.22 | 25.93 | 2009-10-03 00:00:00 | [NAME]
 | 2009-03-31 00:00:00 | a | 254 | 10 | 21 | 0.98 | 95.56 | 21.05 | 14/03/09 | [NAME]
 | 2009-03-31 00:00:00 | a | 300 | 20 | 35 | 1.06 | 96.25 | 21.05 | 15/03/09 | [NAME]
 | 2009-03-31 00:00:00 | a | 293 | 16 | 39 | 1.16 | 96.25 | 21.05 | 16/03/09 | sapna
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | jud
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME] | 21.05
Spreadsheet: cf3a8e2f-dbd6-473f-a9f8-e8871c5d2225
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
7172 | 5790 | [NAME] | [NAME] | GBR | 4 | 00:07:39 | 00:00:25 | [NAME] | 00:00:46 | 00:08:53 | 1 | 00:30:20
7172 | 5959 | Ran | Alterman | ISR | 5 | 00:07:40 | [NAME] | 00:13:16 | 00:00:43 | 00:08:37 | 2 | 00:30:41
7172 | 5836 | Leandro | Barbosa | BRA | 2 | 00:08:13 | 00:00:33 | 00:13:18 | 00:00:54 | 00:09:54 | 3 | 00:32:51
7172 | 11016 | Martin | Papista | CRO | 3 | 00:08:52 | 00:00:31 | 00:14:54 | 00:01:00 | 00:10:37 | 4 | 00:35:51
Spreadsheet: 840663d1692893875-detect-and-remove-outliers-from-dataset-exposure-spudster656
Sheet: EcoliMN

ps_n
0.7 | std
1 | mean |  |  | 0.8457709306622481
0.8 | Min |  |  | 0.2416488373320711
1 | [NAME] |  |  | 0.8457709306622481
0.1 |  |  |  | -1.872778489323549
 | [NAME] | 2.58
Spreadsheet: 133799d1324638672-how-do-i-limit-the-sum-of-a-range-to-not-exceed-11-appliedtosaspinall
Sheet: Sheet1

 |  | Player | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Total
 |  | Player 1 | 1 | 2 | 3 | 0 | 2 | 0 | Bust(4) | 1 | Bust(3) | 2 | 11
 |  | Player 2 | 0 | 1 | 0 | 1 | 2 | 0 | 2 | 3 | 2 | [NAME]) | 11
 |  | Player 3 | 0 | 1 | 0 | 1 | 2 | 0 | 2 | 3 | Bust(3) | 0 | 9
 |  | Player 4 |  |  |  |  |  |  |  |  |  |  | 0
 |  | Player 5 |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 873769d1720337202-how-to-find-total-of-working-hours-from-a-single-cell-2024
Sheet: ΠΡΟΣΩΠΙΚΟ

 |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ
 |  | YAKIMIDI OLESSYA |  |  | SULTANOVA ZULFIΙA
 | 2 | [NAME] ΡΑΦΑΕΛΑ |  | 2 | YAKIMIDI OLESSYA
 | 3 | KROSHKINA MARIA |  | 3 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 4 | ΒΛΑΧΟΥ ΠΑΝΑΓΙΩΤΑ |  | 4 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 5 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 6 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 7 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | 8 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 9 | ΚΟΝΙΣΣΗ ΙΟΥΛΙΑΝΗ
Spreadsheet: 167794d1342105043-excel-2007-vlookup-help-2012-bud-help
Sheet: Jun

Monthly [NAME]
 | [NAME] |  |  | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage |  |  | 2012-06-01 00:00:00 | 2012-06-01 00:00:00 | 875.48 | 875.48
 | Tundra |  |  | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 343.92 | 343.92
 | Cruze |  |  | 2012-06-05 00:00:00 | 2012-06-05 00:00:00 | 242.3 | 242.3
 | Verizon Wireless |  |  | 2012-06-23 00:00:00 |  | 167.42 | 167.42
 | RZMC |  |  | 2012-06-18 00:00:00 | 2012-06-17 00:00:00 | 25 | 25
 | Capital One |  |  | 2012-06-18 00:00:00 | 2012-06-21 00:00:00 | 25 | 32.38
 | Household Bank
 | Insurance |  |  | 2012-06-15 00:00:00 | 2012-06-15 00:00:00 | 68.74 | 68.74
 | RG&E |  |  | 2012-06-13 00:00:00 | 2012-06-26 00:00:00 | 130.6 | 130.6
 | Time Warner |  |  | 2012-06-16 00:00:00 |  | 121.32 | 121.32
 | ACS |  |  | 2012-06-14 00:00:00 | 2012-06-21 00:00:00 | 156.29 | 156.29
 | AES |  |  | 2012-06-30 00:00:00 |  | 138.86
 | Sallie Mae |  |  | 2012-06-07 00:00:00 | 2012-06-09 00:00:00 | 213.47 | 213.47
 | 1st Financial |  |  | 2012-06-21 00:00:00 | 2012-06-21 00:00:00 | 35 | 35
 | Waste Management
 | Water Authority |  |  |  |  |  |  |  | paid late
 | Wells Fargo - Furniture |  |  | 2012-06-16 00:00:00 | 2012-06-17 00:00:00 | 30.14 | 40
 | Doe |  |  | 2012-06-21 00:00:00 | 2012-06-21 00:00:00 | 301.32 | 301.32
 | [NAME]
 | Paychecks
 |  |  |  | Pay Date | Amount
 |  |  |  | 2012-06-01 00:00:00 | 1152.16
 |  |  |  | 2012-06-08 00:00:00 | 524.67
 |  |  |  | 2012-06-15 00:00:00 | 1152.15
 |  |  |  | 2012-06-22 00:00:00 | 450.84
 |  |  |  | 2012-06-29 00:00:00
 |  |  |  |  |  |  |  |  |  | 32
 | Total Bills for month:
 | Total Payments for month:
 | Total Income for the month
Spreadsheet: 156803d1337472998-auto-update-for-monthly-balance-countif-for-andyl3
Sheet: Jan

Jan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | P | H
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 50 | 50 | 50 | Initial Balance
[NAME] | E | H | P | H | E | P | P | H | H | H | E | E | H | P | P | P | E | E | H | H | P | P | H | H | E | E | E | P | P | H | H |  |  |  | Need formulas to "Auto update the balance"
[NAME] | P | P | P | P | P | H | H | H | E | E | H | H | H | P | P | P | E | E | E | E | H | H | E | E | E | E | E | H | H | P | P |  |  |  | Need formulas to "Auto update the balance"
[NAME] | E | E | E | E | H | H | H | H | H | H | P | P | P | P | H | H | H | H | E | E | Vacation |  |  |  |  |  |  |  |  |  |  |  |  |  | Need formulas to "Auto update the balance"
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Original Data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E | P | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | 40 | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | 40 | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | 46 | 40
Spreadsheet: 50389d1249814893-copying-column-based-on-value-of-row-1-694951_jebadiah
Sheet: Sheet1

0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25
6045 | 1056 | 4141 | 6820 | 819 | 3019 | 8480 | 608 | 3653 | 5847 | 5992 | 6374 | 5776 | 431 | 7246 | 1787 | 6719 | 6487 | 2592 | 2791 | 8379 | 3718 | 3987 | 9128 | 7838 | 800
7774 | 153 | 7618 | 6941 | 8241 | 8446 | 9917 | 1693 | 2394 | 9893 | 2735 | 4422 | 5666 | 4089 | 9602 | 5988 | 6007 | 5302 | 8420 | 4476 | 9979 | 2857 | 5848 | 3180 | 201 | 3476
2822 | 877 | 7176 | 2132 | 2712 | 635 | 165 | 8785 | 2092 | 4453 | 965 | 6904 | 5778 | 8529 | 7899 | 7546 | 676 | 7477 | 5133 | 4003 | 7570 | 1061 | 6058 | 5864 | 157 | 9720
1568 | 6098 | 7437 | 3105 | 3349 | 6831 | 1665 | 8004 | 6380 | 2774 | 2326 | 4912 | 2485 | 1270 | 7752 | 9359 | 6539 | 2911 | 635 | 2540 | 4650 | 865 | 654 | 3853 | 6748 | 8256
6642 | 9287 | 6478 | 3360 | 8237 | 1106 | 8872 | 9109 | 5337 | 9312 | 9551 | 7238 | 3676 | 4342 | 1723 | 3590 | 2782 | 236 | 6268 | 9077 | 2242 | 624 | 3275 | 6242 | 8804 | 6434
8709 | 5807 | 2233 | 3431 | 4565 | 2015 | 1555 | 8578 | 9178 | 4191 | 4334 | 1929 | 8978 | 1788 | 3962 | 5628 | 9622 | 9967 | 52 | 9013 | 3135 | 6802 | 6999 | 5530 | 9920 | 4214
6465 | 9623 | 213 | 2479 | 2040 | 8704 | 1992 | 4430 | 2480 | 2244 | 4136 | 3185 | 1327 | 8834 | 3105 | 7966 | 7839 | 7028 | 2366 | 326 | 2602 | 380 | 7856 | 8791 | 6759 | 9390
9745 | 9770 | 4236 | 923 | 8931 | 9849 | 6144 | 8259 | 4250 | 6920 | 5646 | 5323 | 519 | 6753 | 7246 | 6673 | 129 | 1203 | 1193 | 5563 | 4014 | 4778 | 2813 | 6843 | 2785 | 2436
3074 | 242 | 2441 | 8543 | 5921 | 3008 | 9189 | 4886 | 3522 | 8524 | 4831 | 7527 | 1462 | 6984 | 229 | 1632 | 333 | 9642 | 549 | 9527 | 3938 | 6558 | 9750 | 3999 | 8546 | 8951
Spreadsheet: 741735d1627305880-formula-that-only-takes-into-account-date-but-has-a-capped-value-excel-help-260721
Sheet: excel help 260721

 |  |  |  |  | 2022-01-31 00:00:00
NEW | 20 | No. of sites |  | No. of Sites in month
 | 0 | Averarge NR |  | NR Revenue
 | 393.75 | Average RR |  | RR Revenue
 | 48 | Contract length (months)
 |  |  |  |  | 2022-01-31 00:00:00
 |  |  |  | FORMULA should give this result
 |  |  |  |  | 2022-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 216500d1361793529-converting-data-from-a-grid-into-a-list-copy-of-grid-to-list-data-conversion1
Sheet: Planning Sheet

week 1
 | 2012-01-02 00:00:00
A | RESTUARANT |  | CAFE |  | TAKEAWAY
B |  | SERVICE STATION |  | BOOKIES
C | OFFICE 1 |  | OFFICE 2 |  | FORECOURT
D |  | FORECOURT |  | TAKEAWAY
week 2
A |  | OFFICE 3 |  | BOOKIES
B | TAKEAWAY |  | FORECOURT |  | RESTUARANT
C |  | GYM |  | SHOP
D | OFFICE 4 |  | WAREHOUSE |  | LEISURE CENTRE
Would like it to show:
Engineer | Date | site | Engineer | Date | Site
A | 2012-01-02 00:00:00 | RESTUARANT
A | 2012-01-04 00:00:00 | CAFE | A
A | 2012-01-06 00:00:00 | TAKEAWAY
A | 2012-01-10 00:00:00 | OFFICE 3 | A
A | 2012-01-06 00:00:00 | BOOKIES
B | 2012-01-03 00:00:00 | SERVICE STATION
B | 2012-01-05 00:00:00 | BOOKIES | A
B | 2012-01-07 00:00:00 | TAKEAWAY | A
B | 2012-01-11 00:00:00 | FORECOURT | A
B | 2012-01-13 00:00:00 | RESTUARANT | A
C | 2012-01-02 00:00:00 | OFFICE 1
C | 2012-01-04 00:00:00 | OFFICE 2
C | 2012-01-06 00:00:00 | FORECOURT | Engineer | Date | Site
C | 2012-01-10 00:00:00 | GYM | A | 2012-01-02 00:00:00 | RESTUARANT
C | 2012-01-06 00:00:00 | SHOP | A | 2012-01-03 00:00:00
D | 2012-01-03 00:00:00 | FORECOURT | A | 2012-01-04 00:00:00 | CAFE
D | 2012-01-05 00:00:00 | TAKEAWAY | A | 2012-01-05 00:00:00
D | 2012-01-07 00:00:00 | OFFICE 4 | A | 2012-01-06 00:00:00 | TAKEAWAY
D | 2012-01-11 00:00:00 | WAREHOUSE | A | 2012-01-09 00:00:00
D | 2012-01-13 00:00:00 | LEISURE CENTRE | A | 2012-01-10 00:00:00 | OFFICE 3
 |  |  | A | 2012-01-11 00:00:00
 |  |  | A | 2012-01-12 00:00:00 | BOOKIES
 |  |  | A | 2012-01-13 00:00:00
Spreadsheet: 1bc52e83-8346-4bc7-95d8-fabfc7f3cb70
Sheet: Maths Teachers Age

NZ Senior Secondary Mathematics Teachers 2004
Age Distribution
 | Frequency | Percent | Cumulative Frequency | [NAME] |  |  | Frequency
20 | 1 | 0.032 | 1 | 0.032 |  | 20-24 | 85
21 | 3 | 0.096 | 4 | 0.128 |  | 25-29 | 221
22 | 14 | 0.448 | 18 | 0.576 |  | 30-34 | 326
23 | 30 | 0.96 | 48 | 1.536 |  | 35-39 | 308
24 | 37 | 1.184 | 85 | 2.72 |  | 40-44 | 489
25 | 29 | 0.928 | 114 | 3.648 |  | 45-49 | 600
26 | 41 | 1.312 | 155 | 4.96 |  | 50-54 | 535
27 | 47 | 1.504 | 202 | 6.464 |  | 55-59 | 363
28 | 53 | 1.696 | 255 | 8.16 |  | 60-64 | 166
29 | 51 | 1.632 | 306 | 9.792 |  | 65+ | 32
30 | 59 | 1.888 | 365 | 11.68
31 | 78 | 2.496 | 443 | 14.176 |  |  | 3125
32 | 62 | 1.984 | 505 | 16.16
33 | 56 | 1.792 | 561 | 17.952
34 | 71 | 2.272 | 632 | 20.224
35 | 61 | 1.952 | 693 | 22.17599999999999
36 | 59 | 1.888 | 752 | 24.064
37 | 55 | 1.76 | 807 | 25.824
38 | 60 | 1.92 | 867 | 27.744
39 | 73 | 2.336 | 940 | 30.08
40 | 98 | 3.136 | 1038 | 33.216
41 | 102 | 3.264 | 1140 | 36.48
42 | 107 | 3.424 | 1247 | 39.904
43 | 78 | 2.496 | 1325 | 42.40000000000001
44 | 104 | 3.328 | 1429 | 45.72800000000001
45 | 124 | 3.968 | 1553 | 49.69600000000001
46 | 140 | 4.48 | 1693 | 54.17600000000001
47 | 108 | 3.456 | 1801 | 57.63200000000001
48 | 114 | 3.648 | 1915 | 61.28000000000002
49 | 114 | 3.648 | 2029 | 64.92800000000001
50 | 118 | 3.776 | 2147 | 68.70400000000001
51 | 111 | 3.552 | 2258 | 72.25600000000001
52 | 109 | 3.488 | 2367 | 75.74400000000001
53 | 104 | 3.328 | 2471 | 79.07200000000002
54 | 93 | 2.976 | 2564 | 82.04800000000002
55 | 83 | 2.656 | 2647 | 84.70400000000002
56 | 89 | 2.848 | 2736 | 87.55200000000002
57 | 78 | 2.496 | 2814 | 90.04800000000002
58 | 64 | 2.048 | 2878 | 92.09600000000002
59 | 49 | 1.568 | 2927 | 93.66400000000002
60 | 53 | 1.696 | 2980 | 95.36000000000001
61 | 35 | 1.12 | 3015 | 96.48000000000002
62 | 30 | 0.96 | 3045 | 97.44000000000001
63 | 31 | 0.992 | 3076 | 98.43200000000002
64 | 17 | 0.544 | 3093 | 98.97600000000001
65 | 32 | 1.024 | 3125 | 100
 | 3125