tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 140784d1328889387-retrieve-multiple-cells-with-identical-cell-next-to-it-examplesearch
Sheet: Sheet1

6 | Transaction 2 | 34 | Start | 2012-01-31 00:00:00 | 10:20:44 | 0
6 | Transaction 2 | 35 | Party Size | 2012-01-31 00:00:00 | 10:20:47 | 2
6 | Transaction 2 | 36 | Pax Type(D/I) | 2012-01-31 00:00:00 | 10:20:53 | 0 |  | International
6 | Transaction 2 | 39 | Location | 2012-01-31 00:00:00 | 10:21:24 | 0 |  |  | [NAME]
8 | Transaction 2 | 54 | NOTES | 2012-01-31 00:00:00 | 10:24:58 | 0
10 | Transaction 2 | 68 | END | 2012-01-31 00:00:00 | 10:31:07 | 0
11 | Transaction 2 | 69 | Start | 2012-01-31 00:00:00 | 10:31:45 | 0
11 | Transaction 2 | 70 | Location | 2012-01-31 00:00:00 | 10:31:46 | 0 |  |  | [NAME]
11 | Transaction 2 | 71 | Pax Type(D/I) | 2012-01-31 00:00:00 | 10:31:50 | 0 |  | International
11 | Transaction 2 | 72 | # OF BAGS | 2012-01-31 00:00:00 | 10:31:53 | 1
11 | Transaction 2 | 73 | [NAME]/not) | 2012-01-31 00:00:00 | 10:31:55 | 0 | Paid at kiosk
11 | Transaction 2 | 74 | Party Size | 2012-01-31 00:00:00 | 10:31:58 | 1
12 | Transaction 2 | 81 | END | 2012-01-31 00:00:00 | 10:33:45 | 0
14 | Transaction 2 | 89 | Start | 2012-01-31 00:00:00 | 10:41:51 | 0
14 | Transaction 2 | 91 | Location | 2012-01-31 00:00:00 | 10:41:57 | 0 |  |  | Sky Priority ([NAME])
14 | Transaction 2 | 92 | Party Size | 2012-01-31 00:00:00 | 10:42:00 | 2
14 | Transaction 2 | 93 | # OF BAGS | 2012-01-31 00:00:00 | 10:42:02 | 1
14 | Transaction 2 | 94 | [NAME]/not) | 2012-01-31 00:00:00 | 10:42:05 | 0 | Prepaid/No fee
14 | Transaction 2 | 96 | Pax Type(D/I) | 2012-01-31 00:00:00 | 10:42:16 | 0 |  | Domestic
15 | Transaction 2 | 103 | END | 2012-01-31 00:00:00 | 10:43:37 | 0
17 | Transaction 2 | 111 | Start | 2012-01-31 00:00:00 | 10:44:35 | 0
17 | Transaction 2 | 112 | Location | 2012-01-31 00:00:00 | 10:44:37 | 0 |  |  | Sky Priority (Kiosk)
17 | Transaction 2 | 113 | Pax Type(D/I) | 2012-01-31 00:00:00 | 10:44:40 | 0 |  | Domestic
17 | Transaction 2 | 114 | # OF BAGS | 2012-01-31 00:00:00 | 10:44:45 | 1
17 | Transaction 2 | 115 | [NAME]/not) | 2012-01-31 00:00:00 | 10:44:48 | 0 | Prepaid/No fee
17 | Transaction 2 | 116 | Party Size | 2012-01-31 00:00:00 | 10:44:51 | 1
19 | Transaction 2 | 127 | END | 2012-01-31 00:00:00 | 10:46:03 | 0
22 | Transaction 2 | 143 | Start | 2012-01-31 00:00:00 | 10:48:40 | 0
22 | Transaction 2 | 144 | Pax Type(D/I) | 2012-01-31 00:00:00 | 10:48:45 | 0 |  | Domestic
22 | Transaction 2 | 145 | Location | 2012-01-31 00:00:00 | 10:48:51 | 0 |  |  | Sky Priority (Kiosk)
24 | Transaction 2 | 160 | END | 2012-01-31 00:00:00 | 10:51:31 | 0
Spreadsheet: darrell_schoolcraft__7844__Griffith1001
Sheet: DETM-Receipts

 | Citizens Arizona Gas |  |  | Customer: | Duke Energy Trading & Marketing
 | Scheduled Receipts
 |  |  |  | Month Of:  August-01 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Transwestern Lateral |  |  |  |  |  |  |  |  |  |  |  |  |  |  | El Paso Lateral
 |  |  |  |  |  |  |  |  |  |  |  |  | Daily | Month |  |  |  |  |  |  |  |  |  |  |  |  |  | Daily | Month |  | Daily | Month
 |  |  |  |  |  |  |  |  |  |  |  |  | Total | To-Date |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | To-Date |  | Total | To-Date
Day | Agr. # | Dth | Arg. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Dth | Dth |  | Agr. # | Dth | Arg. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Agr. # | Dth | Dth | Dth |  | Dth | Dth
1 | 20248 | 40000 | 26372 | 25000 |  |  | 26758 | 15000 | 27708 | 10000
 | 26372 | 13089 | 26520 | 15078 | 26758 | 13158 | 27708 | 5250 | 27568 | 10000
 | 26372 | 20000 | 26520 | 19975 | 26758 | 15000 | 27708 | 10000 | 27568 | 10000
 | 27708 | 10000 | 27568 | 15000 | 26372 | 25000 | 26520 | 20000 | 27293 | 5000 | 26758 | 5000
 | 26372 | 15000 | 26520 | 20000 | 26758 | 10000 | 27708 | 10000 | 27568 | 15000
 | 26372 | 24999 | 26520 | 20000 | 26758 | 10000 | 27708 | 10000 | 27568 | 15000
 | 26372 | 24954 | 26520 | 19982 | 27708 | 10000 | 27568 | 15000
 | 27708 | 5000 | 26758 | 10000 | 26372 | 12500 | 26520 | 4375
 | 26372 | 25000 | 26520 | 20000 | 26758 | 5000 | 27708 | 10000 | 27568 | 15000
Total
Spreadsheet: 877936d1724860384-search-for-partial-matches-in-a-list-nunez100-example-v3-tms
Sheet: Sheet1 (Nunez)

 |  |  |  | Sample edited to cause issue identified
Result |  |  |  | Input Data |  | TMS
[NAME] |  |  |  | BANK GIRO CREDIT REF Parson
Nikita Smith |  |  |  | Transfer fia faster payment to Smith 465 |  | Nikita Smith
[NAME] |  |  |  | BANK GIRO CREDIT REF Henry 143 |  | [NAME]
Nikita Smith |  |  |  | BANK GIRO CREDIT REF Smith |  | Nikita Smith
[NAME] |  |  |  | Transfer via faster payment to [NAME] |  | [NAME]
[NAME] |  |  |  | BANK GIRO CREDIT REF [NAME] |  | *** check ***
Jacinta [NAME] |  |  |  | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME]
[NAME] |  |  |  | BANK GIRO CREDIT REF Maguire 463 |  | [NAME]
[NAME] |  |  |  | Direct Debit Payment to Perry 453 |  | [NAME] |  |  | Return Values | Search Term
[NAME] |  |  |  | BANK GIRO CREDIT REF Howie 309654 |  | [NAME]
[NAME] |  |  |  | BANK GIRO CREDIT REF Howie 309654 |  | [NAME] |  |  | [NAME] | Parson
[NAME] |  |  |  | Direct Debit Payment to Parson |  | [NAME] |  |  | Nikita Smith | Smith
[NAME] |  |  |  | BANK GIRO CREDIT REF Maguire 463 |  | [NAME] |  |  | [NAME] | [NAME]
[NAME] |  |  |  | Transfer via faster payment to [NAME] |  | [NAME] |  |  | [NAME] | [NAME]
Jacinta [NAME] |  |  |  | BANK GIRO CREDIT REF Uppham 29 |  | Jacinta [NAME] |  |  | Jacinta [NAME] | [NAME]
[NAME] |  |  |  | Direct Debit Payment to Maguire 463 |  | [NAME] |  |  | [NAME] | [NAME]
[NAME] |  |  |  | BANK GIRO CREDIT REF [NAME] |  | [NAME] |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | [NAME] | Maguire
 |  |  |  |  |  | Original formula:
 |  |  |  |  |  | Nikita Smith
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Nikita Smith
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME],[NAME]
 |  |  |  |  |  | Jacinta [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Jacinta [NAME]
 |  |  |  |  |  | [NAME]
 |  |  |  |  |  | [NAME]
Spreadsheet: 105012d1302509687-compare-spreadsheets-test1
Sheet: test

no. | carrier name | cost doc no. | cost pos. | shipment no. | credit note no. | ference no | type of cost | planned pickup date | invoice date | source country | source post code | source city | destination country | destination post code | destination city | real weight | chargeable weight | rate | cost net | tax | tax (%) | cost gross | currency
101438 | test1 | 14757 | 2 | 15822 | 3000011183 | 83280301/[PHONE]/[PHONE]/[PHONE] | rate | 2011-03-07 00:00:00 | 2011-03-31 00:00:00 | GB | M41 7SW | [NAME] | GB | B11 1RH | SPARKBROOK | 2030.78 | 2031 | 2.44 | 49.55 | 0 | 0 | 49.55 | GBP
101438 | test2 | 14757 | 3 | 15822 | 3000011183 | 83278532 | rate | 2011-03-07 00:00:00 | 2011-03-31 00:00:00 | GB | M41 7SW | [NAME] | GB | BT5 6QP | BELFAST | 34 | 40.001 | 39.83 | 39.83 | 0 | 0 | 39.83 | GBP
101438 | test3 | 14757 | 4 | 15822 | 3000011183 | 83279697/[PHONE]/[PHONE] | rate | 2011-03-07 00:00:00 | 2011-03-31 00:00:00 | GB | M41 7SW | [NAME] | GB | KT12 2SD | WALTON ON THAMES | 33 | 33 | 16.14 | 16.14 | 0 | 0 | 16.14 | GBP
Spreadsheet: 488181d1478543291-complex-formula-based-on-wbs-formula-gantt-chart-template-2
Sheet: Template

 |  |  |  |  |  | 1900-01-01 00:00:00 |  | 0
 | [NAME]
 |  |  |  | Today's Date:
 |  |  |  | [NAME] Start Date: | 2017-01-01 00:00:00
 |  |  |  | Time Period: | Monthly
 |  | [NAME]: |  | Duration:
 |  | Current Month/Week/Day
 |  | In-Process Task Duration
 |  | Completed Task Duration
Level | WBS | [NAME] | Lead | Contact | Start Date | Due Date | Duration | % Complete
 |  | Category
 |  | Sub-Category
 |  | Task |  |  | 2017-03-14 00:00:00 | 2017-03-14 00:00:00 |  | 1
 |  | Task |  |  | 2017-04-01 00:00:00 | 2017-04-01 00:00:00 |  | 0.5
 |  | Sub-Category
 |  | Task |  |  | 2016-02-20 00:00:00 | 2017-02-26 00:00:00 |  | 0
 |  | Task |  |  | 2017-03-14 00:00:00 | 2017-03-14 00:00:00 |  | 1
 |  | Sub-Category
 |  | Task |  |  | 2017-02-27 00:00:00 | 2017-02-27 00:00:00 |  | 0
 |  | Task |  |  | 2017-03-14 00:00:00 | 2017-03-14 00:00:00 |  | 0.05
 |  | Sub-Category
 |  | Task |  |  | 2017-03-15 00:00:00 | 2017-03-15 00:00:00 |  | 0
 |  | Sub-Category
 |  | Task |  |  | 2017-01-01 00:00:00 | 2017-01-31 00:00:00 |  | 1
 |  | Task |  |  | 2017-02-01 00:00:00 | 2017-02-28 00:00:00 |  | 1
 |  | Task |  |  | 2017-03-01 00:00:00 | 2017-03-31 00:00:00 |  | 1
Spreadsheet: 34400d1231636857-excel-search-marcus-czerny-losas-93
Sheet: Caso 5b

1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.84 | 0.8 | 0.76 | 0.74 | 0.72 | 0.71 | 0.7 | 0.7 | 0.69 | 0.69 | 0.69 | 0.68 | 0.68 | 0.68 | 0.68
0.61 | 0.58 | 0.55 | 0.53 | 0.51 | 0.5 | 0.49 | 0.48 | 0.47 | 0.47 | 0.46 | 0.46 | 0.46 | 0.46 | 0.46
1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
59.5 | 54.7 | 50.7 | 47.5 | 44.9 | 42.9 | 41.3 | 40.1 | 39.2 | 38.4 | 37.8 | 37.7 | 37.7 | 37.6 | 37.5
44.1 | 45.9 | 48.1 | 50.7 | 53.7 | 57.1 | 61 | 65.4 | 70.4 | 76.1 | 82.5 | 89.5 | 97 | 143 | 202
18.3 | 17.5 | 16.9 | 16.5 | 16.2 | 16 | 15.8 | 15.7 | 15.7 | 15.7 | 15.8 | 15.9 | 16.1 | 16.7 | 17.6
16.2 | 16.2 | 16.3 | 16.4 | 16.6 | 16.9 | 17.3 | 17.7 | 18.1 | 18.6 | 19 | 19.5 | 20 | 22.1 | 24.6
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 794734d1662277252-sumifs-function-with-latest-dates-as-one-of-the-criteria-sample-format
Sheet: Sheet1

Category | Sub Category | Date Sold | Amount
Apples | Green | 2022-08-15 00:00:00 | 30
Capsicum | Yellow | 2022-08-10 00:00:00 | 50
Grapes | Green | 2022-07-17 00:00:00 | 60
Grapes | Black | 2022-07-15 00:00:00 | 70
Capsicum | Yellow | 2022-08-05 00:00:00 | 50
Capsicum | Green | 2022-08-03 00:00:00 | 45
Apples | Green | 2022-08-31 00:00:00 | 40
Grapes | Black | 2022-07-05 00:00:00 | 70
Apples | Red | 2022-08-15 00:00:00 | 50
Spreadsheet: 1e5d31ae-cc49-4c1e-b478-062f2fc1a72f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5585 | 39810 | Cedric | [NAME] | FRA | 483 | 00:39:08 | 00:00:57 | 01:03:47 | 00:00:48 | 00:22:03 | 1 | 02:06:43
5585 | 29433 | Fabrizio | Vignali | ITA | 484 | 00:40:11 | 00:00:32 | 01:08:38 | 00:00:28 | 00:21:27 | 2 | 02:11:13
5585 | 40000 | [NAME] | [NAME] | GBR | 0 | 01:11:59 | 00:02:18 | 01:31:48 | 00:01:35 | 00:36:44 | 3 | 03:24:22
Spreadsheet: joe_parks__14513__P&L_JUN01
Sheet: WAHA_swap

 | IF
 | 5.31 |  |  |  |  |  |  |  |  |  |  | NET Postion
 |  | GDA | 3.77 | 3.975 | 3.52 | 3.62 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL P&L
2000-12-01 00:00:00 |  |  | -20000
2000-12-02 00:00:00 |  |  | -20000
2000-12-03 00:00:00 |  |  | -20000
2000-12-04 00:00:00 |  |  | -20000
2000-12-05 00:00:00 |  |  | -20000 | -10000
2000-12-06 00:00:00 |  |  | -20000 | -10000
2000-12-07 00:00:00 |  |  | -20000 | -10000
2000-12-08 00:00:00 |  |  | -20000 | -10000 | 15000
2000-12-09 00:00:00 |  |  | -20000 | -10000 | 15000
2000-12-10 00:00:00 |  |  | -20000 | -10000 | 15000
2000-12-11 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-12 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-13 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-14 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-15 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-16 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-17 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-18 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-19 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-20 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-21 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-22 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-23 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-24 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-25 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-26 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-27 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-28 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-29 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-30 00:00:00 |  |  | -20000 | -10000 | 15000 | 10000
2000-12-31 00:00:00
Spreadsheet: 48a3ae96-dff1-4a25-9e8b-a8f509a2cef6
Sheet: Sheet1

Release: Annual Estimates of the Population for the U.S. and States, and for Puerto Rico | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=118
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2013-12-06 1:16 PM CST
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population for the U.S. and States, and for | 2004-12-22 00:00:00 | Current
Puerto Rico
Link:
http://www.census.gov/popest/ | 2004-12-22 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2004-12-22 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2004-12-22 00:00:00
2005-12-22 00:00:00
2006-12-22 00:00:00
2007-12-27 00:00:00
2008-12-19 00:00:00
2009-12-22 00:00:00
2011-02-02 00:00:00
2011-12-21 00:00:00
2012-12-20 00:00:00
Spreadsheet: a6e0d62d-961b-48a4-8e60-a76f1900b5c9
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44516777 | 2014-12-20 01:44:14 | AXIS | 0 | 5 | 7 | 1024315 | dangie | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44516994 | 2014-12-20 02:01:24 | ALLIES | 0 | 3 | 7 | 1024315 | dangie | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
44518153 | 2014-12-20 04:17:37 | AXIS | 0 | 1 | 6 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44518300 | 2014-12-20 04:33:19 | ALLIES | 1 | 6 | 2 | 1024315 | dangie | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 80001d1280248202-date-calculations-book1
Sheet: Dashboard

Region | # of days since last visited | Avg# days between reports |  |  |  |  |  | Most recent visit | Date of Previous visit
All | 0 |  |  |  |  |  |  | 2010-07-27 00:00:00 | 2010-07-20 10:38:05
1
2
3
4
5
6
7
8
9
10
11
510
511
588
Spreadsheet: 54974d1255015357-excel-2007-vlookup-and-filters-test1
Sheet: End

Machine ID | Model | Cash In | Notes | Cash Out | Profit | Number Of Plays | Up Time Hours | Days Running | Cab Type | 10p Hopper | £1 Hopper | IOU | Refill | Dial In Date | End Date
GW017510 | AWP | 993.4 | 190 | 1075.8 | 107.6 | 2567 | 33 | 4 | Evolution | 34.9 | 197 | 0 | 0 | 2009-10-08 08:02:27 | 2009-10-08 00:00:00
GW017510 | AWP | 993.4 | 190 | 1075.8 | 107.6 | 2567 | 34 | 3 | Evolution | 34.9 | 197 | 0 | 0 | 2009-10-08 08:02:13 | 2009-10-07 00:00:00
GW017510 | AWP | 820.2 | 120 | 868.9 | 71.3 | 1804 | 21 | 2 | Evolution | 34.5 | 233 | 0 | 0 | 2009-10-08 08:02:03 | 2009-10-06 00:00:00
GW017510 | AWP | 277.9 | 20 | 242.7 | 55.2 | 581 | 7 | 1 | Evolution | 34.6 | 317 | 0 | 0 | 2009-10-07 08:10:50 | 2009-10-05 00:00:00
GW017510 | AWP | 0 | 0 | 0 | 0 | 0 | 0 | 1 | Evolution | 35 | 350 | 0 | 0 | 2009-10-07 08:10:42 | 2009-09-28 00:00:00
GW017510 | AWP | 0 | 0 | 0 | 0 | 0 | 1 | 12 | Infiniti | 0 |  | 0 | 0 | 2009-10-06 05:18:11 | 2009-09-26 00:00:00
GW017510 | AWP | 0 | 0 | 0 | 0 | 0 | 1 | 1 | Infiniti | 0 |  | 0 | 0 | 2009-09-28 13:55:29 | 2009-09-15 00:00:00
GW017510 | AWP | 0 | 0 | 0 | 0 | 0 | 1 | 1 | Infiniti | 0 |  | 0 | 0 | 2009-09-28 13:55:53 | 2009-09-14 00:00:00
GW017510 | AWP | 60 | 0 | 0 | 60 | 60 | 1 | 9 | Infiniti | 0 |  | 0 | 0 | 2009-09-28 14:03:28 | 2009-09-02 00:00:00
GW017510 | AWP | 9.5 | 0 | 0 | 9.5 | 19 | 7 | 10 | Infiniti | 0 |  | 0 | 0 | 2009-10-06 05:18:03 | 2009-08-26 00:00:00
GW017510 | AWP | 236.3 | 145 | 225.2 | 156.1 | 437 | 35 | 358 | Infiniti | 26 |  | 4 | 0 | 2009-10-05 12:17:04 | 2009-07-23 00:00:00
GW017510 | AWP | 236.3 | 145 | 225.2 | 156.1 | 437 | 35 | 358 | Infiniti | 26 |  | 4 | 0 | 2009-10-05 12:16:58 | 2009-07-23 00:00:00
GW017510 | AWP | 179.6 | 120 | 168.5 | 131.1 | 380 | 18 | 357 | Infiniti | 26 |  | 4 | 0 | 2009-10-05 12:16:43 | 2009-07-22 00:00:00
GW017510 | AWP | 62.1 | 40 | 51 | 51.1 | 122 | 17 | 356 | Infiniti | 25 |  | 2 | 0 | 2009-09-28 14:05:10 | 2009-07-21 00:00:00
GW017510 | AWP | 2874.5 | 1345 | 2923 | 1296.5 | 5668 | 2514 | 1533 | Infiniti | 25 |  | 10 | 0 | 2009-09-28 13:55:39 | 2009-07-14 00:00:00
Spreadsheet: 788120d1658292285-average-data-for-each-month-in-each-year-dates-not-specified-example-average-ans
Sheet: Sheet1

Date | Produced (kwh) |  |  | Sum of Product |  |  |  |  | Average per month
2014-05-16 00:00:00 | 8.41 |  |  | Month | 2014 | 2015 | 2016 |  | Month | 2014 | 2015 | 2016
 | 18.15 |  | MIN | 1 |  |  |  | MAX | 1 |  |  |  |  | I wish to calculate the avrage per month into this table
 | 16.97 |  |  | 2 |  |  |  |  | 2 |  |  |  |  | Its similar to the first table which provides me with the total number of readings per month per year (to the left)
 | 14.16 |  |  | 3 |  |  |  |  | 3
 | 17.48 |  |  | 4 |  |  |  |  | 4
 | 17.64 |  |  | 5 |  |  |  |  | 5
 | 17.57 |  |  | 6 |  |  |  |  | 6
 | 17.52 |  |  | 7 |  |  |  |  | 7
 | 18.39 |  |  | 8 |  |  |  |  | 8
 | 17.96 |  |  | 9 |  |  |  |  | 9
 | 17.54 |  |  | 10 |  |  |  |  | 10
 | 12.61 |  |  | 11 |  |  |  |  | 11
 | 18.75 |  |  | 12 |  |  |  |  | 12
 | 16.79
 | 17.36 | Average | Min | [NAME]
 | 14.22
 | 14.82
 | 16.48
 | 17.49
 | 16.04
 | 17.11
 | 16.97
 | 16.7
 | 17.5
 | 17.69
 | 17.59
 | 17.27
 | 16.8
 | 16.3
 | 13.07
 | 16.67
 | 17.32
 | 15.41
 | 17.08
 | 9.84
 | 16.3
 | 16.61
 | 16.58
 | 17.36
 | 16.95
 | 17.62
 | 16.99
 | 16.72
 | 16.26
 | 16.96 | Average | Min | [NAME]
 | 17.31
 | 17.23
 | 16.3
 | 16.49
 | 15.76
 | 17.2
 | 17.36
 | 17.16
 | 16.98
 | 16.51
 | 16.7
 | 17.68
 | 16.74
 | 16.72
 | 16.73
 | 16.71
 | 17.02
 | 17.11
 | 17.89
 | 17.35
 | 17.32
 | 17.68
 | 17.96
 | 17.55
 | 17.31
 | 17.92
 | 17.63
 | 17.56
 | 17.96
 | 17.84
 | 17.71
 | 17.63
 | 17.51
 | 18.09
 | 18.41
 | 19.06
 | 19.34
 | 19.35
 | 17.56
 | 19.19
 | 19.5
 | 19.84
 | 19.94
 | 19.73
 | 20.72
 | 20.33
 | 20.28
 | 20.15
 | 20.86
 | 20.5
 | 20.08
 | 19.87
 | 20.56
 | 21.24
 | 20.91
 | 20.28
 | 20.38
 | 21.1
 | 20.81
 | 21.1
 | 20.93
 | 21.25
 | 21.49
 | 19.72
 | 20.7
 | 19.78
 | 21.29
Spreadsheet: 773973d1648139520-amortization-calculation-help-value-based-on-year-upw
Sheet: Loan Calc

Adjustable Rate Mortgage (ARM) Calculator
 |  |  |  |  | Amortization Schedule |  |  |  |  |  |  |  |  | [42]
 | Loan Information |  |  |  | No. | Payment Date | Interest Rate | Payment Due | Extra Payment | Interest | Principal | Balance | Total Interest | Total Principal |  | Year | Average % Rate | Extra Payment | Interest | Principal | Balance
 |  | Loan amount | 596000 |  |  |  |  |  | 100
 |  | Term (years) | 30
 |  | Starting interest rate | 0.029009
 |  | First payment date | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 500
 |  | Starting monthly payment
 | Rate Adjustments
 |  | Rate | As Of …
 | [NAME]
 | New Rates | 0.03 | 2020-06-01 00:00:00
 |  | 0.02 | 2020-09-01 00:00:00
 |  | 0.04 | 2021-01-01 00:00:00 | {42}
 |  | 0.03 | 2021-06-01 00:00:00 |  |  |  |  |  | 100
 |  | 0.03 | 2022-04-01 00:00:00
 |  | 0.02 | 2022-08-01 00:00:00
 | Summary
 |  | Est. [NAME] monthly payment |  |  |  |  |  |  | 150
 |  | Total payments
 |  | Total interest
 |  | Internal Rate of Return
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 15000
 |  |  |  |  |  |  |  |  | 100
 |  |  |  |  |  |  |  |  | 100
 |  |  |  | -
Spreadsheet: 675735d1588443673-use-data-in-multiple-cells-to-return-result-example
Sheet: Jul - Inv

 | Month | 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AM
 | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PM
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Day
Child's Name | Parent's Name | Address
 |  |  | 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
Spreadsheet: 149299d1333818985-how-to-populate-cells-next-to-a-list-selection-meal-chart-example
Sheet: Foods

Measurement |  | Food | Protein (grams) | Carbs (grams) | Fat (grams) | Calories
100g | 100 | Baked Skinless [NAME] | 31.02 | 0 | 3.57 | 165
100g | 100 | White [NAME] | 2.69 | 28.17 | 0.28 | 130
1 scoop (31g) | 31 | Zero Carb Isopure | 25 | 0 | 0.5
1 scoop (56g) | 56 | [NAME] | 0 | 52 | 0 | 224
1 scoop (32g) | 32 | Optimum Casein | 24 | 3 | 1
1 cap | 1 | NOW Omega 3 | 0 | 0 | 1 | 10
1 scoop (16g) | 16 | BSN Cellmass | 0 | 7 | 0 | 30
1 scoop (22.5g) | 22.5 | BSN No Xplode | 0 | 6 | 0 | 25
12oz | 12 | Heinekin | 1.5 | 11.5 | 0 | 150
1 bar | 1 | Nature Valley Oats 'n Honey Granola Bar | 2 | 14.5 | 3 | 95
100g | 100 | [NAME] | 1.03 | 23.43 | 0.48 | 92
100g | 100 | Hard Boiled Egg | 12.58 | 1.12 | 10.61 | 155
100g | 100 | Peanuts | 25 | 17.85 | 50 | 607.14
1 scoop (12g) | 12 | NanoGreens | 2 | 8 | 1.5 | 50
1 scoop (12g) | 12 | NanoRed | 0.5 | 11 | 0 | 45
100g (50oz) | 50 | Country Time Lemonade | 0.1 | 98.1 | 1.2 | 354
100g | 100 | Progresso [NAME] | 2.5 | 8.33 | 3.75 | 75
100g | 100 | Home Made Mashed Potatoes | 1.88 | 16.71 | 4.23 | 106
100g | 100 | New Food | 1.88 | 16.71 | 4.23 | 106