tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 813116d1673555559-latest-product-purchased-by-customer-sample-file
Sheet: Sheet1

id | created_at | user_email | first_name | last_name | product_id | product_name |  |  |  |  |  |  |  |  |  |  |  |  |  | coupon
916 | 2023-01-09 20:16:22 | [EMAIL] | [NAME] | person1 | 3846 | Individual 2022
915 | 2023-01-09 20:09:16 | [EMAIL] | MaryPat | person2 | 1246 | Couple 2
914 | 2023-01-05 04:18:50 | [EMAIL] | Rowena | person3 | 4151 | Individual 2023
913 | 2023-01-02 19:02:37 | [EMAIL] | Eva | person4 | 1246 | Couple 2
912 | 2022-12-30 12:57:43 | [EMAIL] | [NAME] | person5 | 4151 | Individual 2023
911 | 2022-12-22 22:13:58 | [EMAIL] | [NAME] | person6 | 4150 | Individual (Under 40) 2023
910 | 2022-12-19 20:12:01 | [EMAIL] | [NAME] | person7 | 4151 | Individual 2023
909 | 2022-12-19 10:26:38 | [EMAIL] | Roberta | person8 | 4151 | Individual 2023
908 | 2022-12-16 17:13:28 | [EMAIL] | [NAME] | person9 | 4148 | Couple 1 - 2023
907 | 2022-12-15 20:09:28 | [EMAIL] | Adele | person10 | 4150 | Individual (Under 40) 2023
906 | 2022-12-15 19:43:14 | [EMAIL] | Stephen | person11 | 4148 | Couple 1 - 2023
905 | 2022-12-14 20:52:36 | [EMAIL] | Connie | person12 | 4151 | Individual 2023
904 | 2022-12-14 19:01:49 | [EMAIL] | Charlotte | [NAME] | 4150 | Individual (Under 40) 2023
903 | 2022-12-14 13:47:33 | [EMAIL] | [NAME] | person14 | 4151 | Individual 2023
894 | 2022-12-12 19:19:14 | [EMAIL] | Denae | person15 | 1246 | Couple 2
899 | 2022-12-12 19:19:14 | [EMAIL] | [NAME] | person16 | 3419 | New Member-Individual
895 | 2022-12-12 19:19:14 | [EMAIL] | [NAME] | person17 | 3419 | New Member-Individual
897 | 2022-12-12 19:19:14 | [EMAIL] | [NAME] | person18 | 3419 | New Member-Individual
896 | 2022-12-12 19:19:14 | [EMAIL] | Charlotte | person19 | 3419 | New Member-Individual
903 | 2021-03-12 13:47:33 | [EMAIL] | [NAME] | person14 | 4151 | Individual 2021
910 | 2022-01-31 20:12:01 | [EMAIL] | [NAME] | person7 | 4151 | Individual 2022
 | 2022-02-28 00:00:00 | [EMAIL] | Eva | person4 | 1246 | Couple 2
Spreadsheet: 880561d1728356889-cell-value-not-recognised-tommungo-sample
Sheet: Sheet1

 | Track/Trail Details |  |  |  |  |  |  |  |  |  | Trail Grading |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Signage |  |  |  | Images
 | Track/Trail Name | TrackTrail Ngunnawal name/ proposal | District | Reserve/ Management Area | Type (Walking Track, shared-use) | Total length (return) in meters, or km to nearest 100m | Time in mins if under 1 hour or hours and closest 15 mins. | Surface | Detailed trail description (e.g. give some details about the trail experience) |  | Distance | Gradient ([NAME]) | Quality of path | Quality of markings | Experience required | Steps | Distance | Gradient ([NAME]) | Quality of path | Quality of markings | Experience required | Steps | AWTGS Grade | AWTG Description (Public) |  | Trailhead signage in place | Wayfinding Signage | Interpretive signage |  | Images link
 | Birrigai Time Trail |  | Tidbinbilla | TNR | Walking Track | 3km, | 1 hour, |  |  |  | Total distance of track must not exceed five km | The gradient is generally no steeper than 1:10 (or 10% or 5.7 degrees). (AS 2165.1) | Formed earthen track, few obstacles. Generally a modified surface, sections may be hardened. [NAME]: variable and less than 1200mm. Kept mostly clear of intrusions and obstacles. (AS 2165.1) | 1. Track head signage and route markers at intersections. | 2. Users need no previous experience and are expected to exercise normal care regarding their personal safety. Suitable for most ages and fitness levels. | Minimal use of steps.
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 1km, | 30 mins, |  |  |  | Total distance of track must not exceed ten km | The gradient is generally no steeper than 1:10 (or 10% or 5.7 degrees). (AS 2165.1)
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 3.1km, | 1
 | [NAME] |  | Tidbinbilla | TNR | Walking Track | 600 meters, | 25 mins, |  |  |  | Total distance of track must not exceed five km | Grades in accordance with the AS 1428 series. (AS2165.1) A ramp at 1:14 (7.14% slope or 4.1degrees) is the maximum slope suitable for a person in a wheelchair | Broad, hard surfaced track suitable for wheelchair use. [NAME]: 1200mm or more. [NAME] with minimal intrusions. (AS 2165.1) | 1. Track head signage and route markers at intersections. | 1. Users need no previous experience and are expected to exercise normal care regarding their personal safety. | Steps allowed only with alternate ramp access. (AS 2165.1)
 | Turkey Hill Trail |  | Tidbinbilla | TNR | Walking Track | 0.5 | 0.25
Spreadsheet: 374154d1422692496-w-l-record-between-dates-w-l-record-between-dates-re
Sheet: Sheet13

 |  |  | Season |  |  |  | W/L |  |  |  |  | Record |  |  | Start Year | End Year
 |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2011 | 2012
 |  |  | 2011 |  |  |  |  |  |  |  |  |  |  |  | 2012 | 2014
 |  |  | 2011
 |  |  | 2011
 |  |  | 2011
 |  |  | 2011 |  |  |  |  |  |  |  |  | 6 - 7 |  |  | 2011 | 2012
 |  |  | 2011 |  |  |  |  |  |  |  |  | 38 - 3 |  |  | 2012 | 2014
 |  |  | 2011
 |  |  | 2011
 |  |  | 2011 |  |  |  |  |  | Start year | Stop year | Win/Lose
 |  |  | 2011 |  |  |  |  |  | 2014 | 2014
 |  |  | 2011
 |  |  | 2011
 |  |  | 2012
 |  |  | 2012
 |  |  | 2012 |  |  |  |  |  |  | win | lose
 |  |  | 2012 |  |  |  |  |  | 2011
 |  |  | 2012 |  |  |  |  |  | 2012
 |  |  | 2012 |  |  |  |  |  | 2013
 |  |  | 2012 |  |  |  |  |  | 2014
 |  |  | 2012
 |  |  | 2012
 |  |  | 2012
 |  |  | 2012
 |  |  | 2012
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2013
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
 |  |  | 2014
Spreadsheet: 758800d1639071612-find-duplicate-values-with-non-matching-values-in-another-column-duplicateexample
Sheet: Sheet1

ID | Flag
12345 | green
12345 | red
23456 | red
45678 | green
56789 | red
56789 | red
67890 | red
67890 | green
78901 | green
78901 | green
89012 | green
90123 | green
54321 | red
65432 | red
76543 | green
87654 | red
87654 | green
98765 | red
98765 | red
13579 | green
13579 | green
13579 | green
24680 | red
24680 | red
24680 | red
14703 | green
25814 | green
36925 | green
47036 | green
58147 | green
Spreadsheet: 489141d1479128233-help-summing-values-from-several-worksheets-tabs-collector-summary-november-2016
Sheet: NOV 12 2016

 | $ List | Collector | Subroll $ | Roll $ | Rate $ | Combined | # Calls | RPC | RPC % Ratio | PTP | PTP % Ratio | Scored Call
1 |  | ESPERANZA ESCOBEDO | 24371 | 0 | 0 |  | 223 | 6 |  | 5
2 |  | [NAME] | 0 | 0 | 5578 |  | 112 | 5 |  | 4
3 |  | [NAME] | 9918 | 0 | 37411 |  | 233 | 7 |  | 5
4 |  | KRISTY WOODS | 0 | 0 | 0 |  | 155 | 3 |  | 1
5 |  | CRAIG VANTERPOOL | 49861 | 31201 | 10202 |  | 93 | 13 |  | 12
6 |  | RASHEED SHABAAZ | 42077 | 36924 | 0 |  | 136 | 5 |  | 4
7 |  | DANNY CANTU
8 |  | TOINETTE WEST | 51384 | 0 | 15976 |  | 160 | 5 |  | 5
9 |  | NINA HERNANDEZ | 47488 | 0 | 0 |  | 214 | 0 |  | 0 | 0
10 |  | [NAME] | 0 | 14955 | 0 |  | 149 | 7 |  | 6
11 |  | PHILIP PARSON | 0 | 0 | 47982 |  | 69 | 2 |  | 2
12 |  | MARIA ARISPE | 11796 | 8029 | 15319 |  | 116 | 20 |  | 12
13 |  | HANSON STRICKLING | 0 | 0 | 19125 |  | 127 | 1 |  | 1
14 |  | DEVANTE STRAIGHT | 0 | 0 | 0 |  | 257 | 2 |  | 0
15 |  | MARTINE PALLAI | 154678 | 0 | 27830 |  | 188 | 10 |  | 10
16 |  | PORSCHE CLARK | 7553 | 25417 | 9063 |  | 180 | 6 |  | 6
17 |  | COMFORT AKINOLA | 38742 | 0 | 56053 |  | 137 | 14 |  | 7
18 |  | SAMANTHA CASTILLO | 0 | 0 | 0 |  | 153 | 1 |  | 0
19 |  | LISA RODRIGUEZ | 0 | 38214 | 16214 |  | 245 | 11 |  | 11
20 |  | SHAUN COOPER | 18203 | 0 | 8630 |  | 391 | 22 |  | 14
21 |  | CONSUELA JAVIER | 0 | 20512 | 0 |  | 190 | 2 |  | 2
22 |  | QUEANA MAHONEY
 |  | AVERAGE:
 |  | MEETING NOTES
 |  | *** DANNY AND QUEANA OFF
 |  | **
 |  | **
Spreadsheet: 673097d1587154606-insert-line-chart-for-specific-column-in-each-sheet-and-calculate-velocity-of-each-line-parse2
Sheet: 434150

code | sal1 | mah | rooz | sath-ab | mahdoodeh | utmx | utmy | ostan | mahal | ellat-adam-andazeh-giri | [NAME] | l1-E1 | year | average for each year of column M
4104 | 1361 | 2 | 5 | 17.72 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 3 | 30 | 17.72 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 4 | 28 | 18.07 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 5 | 31 | 18.39 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 6 | 13 | 18.4 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 8 | 3 | 18.2 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1361 | 9 | 2 | 18.03 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 3 | 11 | 17.72 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 4 | 28 | 17.34 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 5 | 11 | 17.65 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 6 | 22 | 17.59 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 7 | 19 | 17.51 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 8 | 29 | 17.42 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
4104 | 1362 | 9 | 21 | 17.36 | اشته | 434150 | 3954960 | 31 | قشل |  | 1175.98
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1361 | 1157.904285714286
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1362 | 1158.467142857143
Spreadsheet: 29682d1224764793-if-statement-bonus-answer-25
Sheet: Sheet1

 | Name 1 | Name 2 | Name 3 | 0 | Name 4 | Name 2
 | Mon | Tue | Wed | Thu | Fri | Weekly | Daily | Daily Bonus | Weekly Bonus | Total
Name 1 | 15 | 5 | 14 | 1 | 12 | 47 | 20 | 10 | 0 | 30
Name 2 | 12 | 19 | 10 | 8 | 15 | 64 | 20 | 10 | 25 | 55
Name 3 | 5 | 8 | 18 | 13 | 5 | 49 | 10 | 10 | 0 | 20
Name 4 | 14 | 2 | 12 | 8 | 23 | 59 | 20 | 10 | 0 | 30
Name 5 | 13 | 17 | 3 | 12 | 8 | 53 | 10 | 0 | 0 | 10
Spreadsheet: 724964d1616465536-auto-populate-of-attempts-and-score-data-for-a-user-rough
Sheet: All Data

User ID | Name | Exam | SCORE | %
ABC | Name1 | IELTS | 5 | 0.83 | Passed
ABC | Name1 | IELTS | 4 | 0.67 | Failed
ABC | Name1 | IELTS | 3 | 0.79 | Failed
DEF | [NAME] | IELTS | 6 | 1 | Passed
DEF | [NAME] | IELTS | 3 | 0.67 | Failed
JIK | Name3 | IELTS | 5 | 0.83 | Passed
JIK | Name3 | IELTS | 4 | 0.76 | Failed
ARH | Name4 | CAT | 6 | 1 | Passed
DEF | [NAME] | CAT | 5 | 0.83 | Passed
JIK | Name3 | CAT | 6 | 1 | Passed
HJK | Name5 | CAT | 6 | 1 | Passed
ABC | Name1 | CAT | 6 | 1 | Passed
JIK | Name3 | CAT | 3 | 0.45 | Failed
HJK | Name5 | CAT | 3 | 0.67 | Failed
ABC | Name1 | CAT | 2 | 0.78 | Failed
Spreadsheet: 94725d1294451881-make-a-calendar-with-noted-birthdays-etc-my2011-11
Sheet: Weeks 1-2

2010-12-27 00:00:00 |  |  |  |  | Birthdays |  |  | Anniversaries
 |  |  |  |  | [NAME] | 1976-01-05 00:00:00 |  | Sam & Betty wed | 2004-01-07 00:00:00
 |  |  |  |  | [NAME] | 1996-01-07 00:00:00 |  | Mel & Ann wed | 1987-02-05 00:00:00
 |  |  |  |  | [NAME] | 1981-01-23 00:00:00 |  | Tom & Sis wed | 1978-05-12 00:00:00
 |  |  |  |  | [NAME] | 1966-02-15 00:00:00
 |  |  |  |  | These Birthdays and Anniversaries would actually
 |  |  |  |  | be on the "Dates" worksheet (see the tab below).
 |  |  |  |  |  |  |  | DATEDIF figured out [NAME]'s age.
 |  |  | [NAME] is 35
 |  |  |  |  | Shown here is only the first page for Weeks 1 and 2.
 |  |  |  |  | Of course, I'll make more worksheets for…
 |  |  |  |  | Weeks 3-4, Weeks 5-6, Weeks 7-8, etc…  for the year.
 |  |  |  |  | Sometimes, more than 1 event is on a certain date.
 |  |  |  |  | Sometimes even, more than 1 Birthday is on the same date.
 |  |  |  |  | I just want them all to go on lower lines.
 |  |  | [NAME] is 15
 |  |  | Sam & Betty wed: 7
This is 5 and 1/2 inches wide |  | This is 5 and 1/2 inches wide
So, that would be one page that is 11 inches (landscape mode).
Rows 1 thru 38 will total 8 and 1/2 inches high...  Printing 2 pages (2 weeks) on one standard sheet of paper.
For this discussion, we'll ignore the printer margin requirements.  I can figure that out later.
Spreadsheet: 0a660dfb-48a7-4a67-ae5e-61dbb4d1b530
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 6427.0 Producer Price Indexes, Australia
 | Table 30. Copper materials used in the manufacture of electrical equipment, index numbers and percentage changes
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Industrial Electric Motors ; |  |  | Original | A2314268J | 1983-09-01 00:00:00 | 2002-06-01 00:00:00 | 76 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Industrial Electric Motors ; |  |  | Original | A2314269K | 1983-12-01 00:00:00 | 2002-06-01 00:00:00 | 75 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Industrial Electric Motors ; |  |  | Original | A2314270V | 1984-09-01 00:00:00 | 2002-06-01 00:00:00 | 72 | Percent | PERCENT | Quarter | 3
Index Number ;  Distribution Transformers ; |  |  | Original | A2314289V | 1983-09-01 00:00:00 | 2012-03-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Distribution Transformers ; |  |  | Original | A2314290C | 1983-12-01 00:00:00 | 2012-03-01 00:00:00 | 114 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Distribution Transformers ; |  |  | Original | A2314291F | 1984-09-01 00:00:00 | 2012-03-01 00:00:00 | 111 | Percent | PERCENT | Quarter | 3
Index Number ;  Power Transformers ; |  |  | Original | A2314301X | 1983-09-01 00:00:00 | 2012-03-01 00:00:00 | 115 | Index Numbers | INDEX | Quarter | 3
Percentage change from previous quarter ;  Power Transformers ; |  |  | Original | A2314302A | 1983-12-01 00:00:00 | 2012-03-01 00:00:00 | 114 | Percent | PERCENT | Quarter | 3
Percentage change from corresponding quarter of previous year ;  Power Transformers ; |  |  | Original | A2314303C | 1984-09-01 00:00:00 | 2012-03-01 00:00:00 | 111 | Percent | PERCENT | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 545498d1509501599-min-and-max-and-street-addresses-s666-excel-address
Sheet: Sheet1

Street | thing1 | thing2 | thing3 | thing4
BRIAR BRANCH DR | 2331 | 2330 | 2399 | 2398 |  |  | BRIAR BRANCH DR | 2330 | 2399 |  |  |  | Street | Min | [NAME]
BRIARBROOK DR | 2201 | 2200 | 2299 | 2298 |  |  | BRIARBROOK DR | 1800 | 1899 |  |  |  | BRIAR BRANCH DR | 2330 | 2399
BRIARBROOK DR | 2301 | 2300 | 2399 | 2398 |  |  | BRIARPARK DR | 1800 | 3299 |  |  |  | BRIARBROOK DR | 1901 | 2699
BRIARBROOK DR | 2401 | 2400 | 2499 | 2498 |  |  |  |  |  |  |  |  | BRIARPARK DR | 1800 | 3299
BRIARBROOK DR | 2501 | 2500 | 2511 | 2548 |  |  |  | wrong example
BRIARBROOK DR | 2513 | 2550 | 2699 | 2698
BRIARBROOK DR | 2101 | 2101 | 2199 | 2199
BRIARBROOK DR | 2001 | 2001 | 2099 | 2099
BRIARBROOK DR | 1901 | 1901 | 1999 | 1999
BRIARPARK DR | 1801 | 1800 | 1899 | 1898
BRIARPARK DR | 1901 | 1900 | 1999 | 1998
BRIARPARK DR | 2101 | 2100 | 2199 | 2198
BRIARPARK DR | 2701 | 2900 | 2803 | 3250
BRIARPARK DR | 3183 | 3252 | 3299 | 3298
BRIARPARK DR | 3165 |  | 3181
BRIARPARK DR | 3153 |  | 3163
BRIARPARK DR | 3015 |  | 3151
BRIARPARK DR | 2923 |  | 3013
BRIARPARK DR | 2805 |  | 2921
BRIARPARK DR | 2679 |  | 2699
BRIARPARK DR | 2617 |  | 2677
BRIARPARK DR | 2601 |  | 2615
BRIARPARK DR | 2501 |  | 2599
BRIARPARK DR | 2401 |  | 2499
BRIARPARK DR | 2301 |  | 2399
BRIARPARK DR | 2201 |  | 2299
Spreadsheet: 88003d1287891285-match-dates-and-names-on-different-sheets-and-colour-cells-copy-of-test-date-1
Sheet: Calendar

 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00
Name
[NAME]
George
[NAME]
[NAME] |  | Comment
[NAME]
[NAME]
The conditional formatting rule is [NAME] is =B17=TRUE  starting in B3, copied across and down.
the hidden rows 15 to 22 have a table with the formulas and the True/False values
 | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | 2010-01-04 00:00:00 | 2010-01-05 00:00:00 | 2010-01-06 00:00:00 | 2010-01-07 00:00:00 | 2010-01-08 00:00:00 | 2010-01-09 00:00:00 | 2010-01-10 00:00:00 | 2010-01-11 00:00:00 | 2010-01-12 00:00:00 | 2010-01-13 00:00:00 | 2010-01-14 00:00:00 | 2010-01-15 00:00:00
Name
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
George | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 118813d1314025709-use-value-in-one-cell-to-paste-a-corresponding-row-estimate-details
Sheet: SLB

[NAME] | Dsg | Mass | Ds_i | Dn_i | Wt_i
SLB: Super-Light Beams |  | kg/m |  | in | lb/ft
* | SLB100x5.4 | 5.4 | SLB4x3.64 | 4 | 3.64
 | SLB100x5.1 | 5.1 | SLB4x3.45 | 4 | 3.45
 | SLB100x4.8 | 4.8 | SLB4x3.20 | 4 | 3.2
* | SLB75x5.6 | 5.6 | SLB3x3.75 | 3 | 3.75
 | SLB75x4.5 | 4.5 | SLB3x3.05 | 3 | 3.05
 | SLB75x4.3 | 4.3 | SLB3x2.90 | 3 | 2.9
 | SLB75x3.8 | 3.8 | SLB3x2.54 | 3 | 2.54
* | SLB55x6.4 | 6.4 | SLB2.25x4.30 | 2.25 | 4.3
Spreadsheet: 838282d1690893444-calculate-conditional-standard-deviations-in-a-running-list-of-values-dstdev-example-v2
Sheet: Sheet1

 |  |  |  |  |  |  | Manual Calculations
Player | Country | Runs | Date | [NAME] | SD (Runs) |  | Player | Country | Runs | Date | [NAME] | SD (Runs)
[NAME] | AUS | 31 | 2009-01-03 00:00:00
[NAME] | AUS | 47 | 2009-01-03 00:00:00
[NAME] | AUS | 0 | 2009-01-03 00:00:00
[NAME] | AUS | 30 | 2009-01-03 00:00:00
[NAME] | AUS | 138 | 2009-01-03 00:00:00
[NAME] | SA | 23 | 2009-01-03 00:00:00
GC Smith | SA | 30 | 2009-01-03 00:00:00
HM Amla | SA | 51 | 2009-01-03 00:00:00
[NAME] | SA | 37 | 2009-01-03 00:00:00
AB de Villiers | SA | 11 | 2009-01-03 00:00:00
[NAME] | AUS | 56 | 2009-01-10 00:00:00
[NAME] | AUS | 22 | 2009-01-10 00:00:00
[NAME] | AUS | 3 | 2009-01-10 00:00:00
[NAME] | AUS | 46 | 2009-01-10 00:00:00
[NAME] | AUS | 24 | 2009-01-10 00:00:00
[NAME] | SA | 94 | 2009-01-10 00:00:00
GC Smith | SA | 65 | 2009-01-10 00:00:00
HM Amla | SA | 24 | 2009-01-10 00:00:00
[NAME] | SA | 32 | 2009-01-10 00:00:00
AB de Villiers | SA | 28 | 2009-01-10 00:00:00
[NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 124 | 2009-01-17 00:00:00
[NAME] | AUS | 66 | 2009-01-17 00:00:00
[NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 35 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | Examples of what the formula would filter:
[NAME] | SA | 6 | 2009-01-17 00:00:00
GC Smith | SA | 85 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | AUS | Runs
HM Amla | SA | 40 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 31
[NAME] | SA | 30 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 56
AB de Villiers | SA | 21 | 2009-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2
[NAME] | AUS | 17 | 2009-01-24 00:00:00 |  |  |  | [NAME] | AUS | 2 | 2009-01-17 00:00:00
[NAME] | AUS | 65 | 2009-01-24 00:00:00
[NAME] | AUS | 47 | 2009-01-24 00:00:00
[NAME] | AUS | 33 | 2009-01-24 00:00:00
[NAME] | AUS | 68 | 2009-01-24 00:00:00
[NAME] | SA | 123 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  | [NAME] | AUS | Runs
GC Smith | SA | 4 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 31
HM Amla | SA | 39 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 56
[NAME] | SA | 95 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 2
AB de Villiers | SA | 14 | 2009-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | 17
[NAME] | AUS | 156 | 2009-01-31 00:00:00 |  |  |  | [NAME] | AUS | 156 | 2009-01-31 00:00:00
Spreadsheet: 484748d1476419244-sumproduct-with-other-sheets-and-criteria-sumproduct-with-criteria-bvj-v3
Sheet: Sheet2

 |  |  |  | M2 | DATE
 |  | Areas | Description | COSTs | Summary | M1 | M2 | M3 | TOTAL (m1 to m3) | M4 | M5 | M6 | TOTAL (m1 to m6) | M7 | M8 | M9 | M10 | M11 | M12 | Total M12
 |  | A1 | abadf | 99439 |  | 10 |  | 456 |  |  | 65423 |  |  |  | 45 |  | 435 |  | 435
 |  | A2 | sadad | 32432 |  | 5 | 24 |  |  |  | 54564 | 56 |  |  | 5956 |  |  | 8
 |  | A3 | dsafsfds | 3242 |  | 2 |  |  |  |  |  | 3 |  |  | 6 | 2 | 435 |  | 435
 |  | A4 | trhrth | 43556 |  | 20 | 234 | 34234 |  | 4 | 5 |  |  | 5 |  |  |  | 56
 |  | A5 | rth | 234234 |  | 304 |  |  |  |  |  | 4 |  |  | 4 | 5 | 889 |  | 435
 |  | A6 | [NAME] | 345345 |  | 405 |  |  |  | 53 |  | 4 |  |  | 5 |  | 345
 |  | A7 | [NAME] | 4353 |  | 435 | 3243 |  |  |  |  | 678 |  |  |  | 867 |  | 435
 |  | A8 | rth | 76786 |  | 45 |  |  |  | 768 | 67 | 7 |  |  |  |  |  |  | 435
 |  | A9 | hrth | 78876 |  |  |  |  |  |  | 234 |  |  |  | 7756454
 |  | A10 | rhrh | 76888 |  | 78 | 67 |  |  |  |  |  |  | 234 |  | 234
 |  | A11 | rhrtthr | 2343 |  | 67 |  |  |  | 34 |  |  |  |  | 234 |  | 435
 |  | A12 | rthrth | 34232 |  | 79 | 173 | 45 |  | 5856 |  | 738 |  |  | 358 | 56
Spreadsheet: 115070d1310702177-formula-for-auto-fill-test-1-
Sheet: List

AB | X
CA | Y
KY1 | X
KY2 | X
KY3 | X
KY4 | X
KY5 | X
KY6 | X
KY7 | X
[NAME] | X
KY9 | X
KY10 | Y
KY11 | Y
KY12 | Y
KY13 | Y
KY14 | Y
KY15 | Y
KY16 | Y
KY17 | Y
Spreadsheet: 294444d1391383282-looking-for-help-to-summarize-data-quick-summary
Sheet: Quick Summary

 |  | Enter Item Number Here
 |  | Newest to oldest item | SOH | On Order | Lead Time | Weight | Color
 |  | CAEXCH4RA31000 | 0 | 1 | 3 | 20 | Purple
 |  | CAEXCH4RA32000 | 0 | 4 | 2 | 33 | Lawn
 |  | CAEXCH4RA32000TSK | 76 | 0 | 7 | 22 | Pointed
 |  | CAEXCH4RE22000 | 0 | 5 | 8 | 12 | Melon
 |  | CAEXCH4RH12500 | 2 | 0 | 1 | 21 | Jam
 |  | CAEXCH4RJ13000 | 3 | 0 | 1 | 21 | Black
 |  | CAEXCH4RK22500 | 0 | 0 | 2 | 21 | Cream
 |  | CAEXCH4RL11500 | 55 | 2 | 4 | 33 | Color
 |  | CAEXCH4RR13000 | 0 | 7 | 5 | 254 | Red
 |  | CAEXCH4RR23000 | 0 | 4 | 5 | 123 | Green
Spreadsheet: 155316d1336758593-second-column-of-unique-drop-down-list-entires-not-recognizing-all-unique-entries-book1-modified-by-tigeravatar-
Sheet: Functions

airlinelist | destinationlist
Spreadsheet: 46020d1244799811-recurring-meetings-calender-recurring
Sheet: Calender

 |  | 2009-07-01 00:00:00
2009-06-28 00:00:00 |  | 2009-06-29 00:00:00 |  | 2009-06-30 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-07-02 00:00:00 |  | 2009-07-03 00:00:00 |  | 2009-07-04 00:00:00
2009-06-28 00:00:00 |  | 2009-06-29 00:00:00 |  | 2009-06-30 00:00:00 |  | 2009-07-01 00:00:00 |  | 2009-07-02 00:00:00 |  | 2009-07-03 00:00:00 | BPM | 2009-07-04 00:00:00
2009-07-05 00:00:00 |  | 2009-07-06 00:00:00 | MBU | 2009-07-07 00:00:00 |  | 2009-07-08 00:00:00 |  | 2009-07-09 00:00:00 |  | 2009-07-10 00:00:00 |  | 2009-07-11 00:00:00
2009-07-12 00:00:00 |  | 2009-07-13 00:00:00 | MBU | 2009-07-14 00:00:00 |  | 2009-07-15 00:00:00 |  | 2009-07-16 00:00:00 |  | 2009-07-17 00:00:00 |  | 2009-07-18 00:00:00
2009-07-19 00:00:00 |  | 2009-07-20 00:00:00 | MMM | 2009-07-21 00:00:00 |  | 2009-07-22 00:00:00 |  | 2009-07-23 00:00:00 |  | 2009-07-24 00:00:00 |  | 2009-07-25 00:00:00
2009-07-26 00:00:00 |  | 2009-07-27 00:00:00 | MMM | 2009-07-28 00:00:00 |  | 2009-07-29 00:00:00 |  | 2009-07-30 00:00:00 |  | 2009-07-31 00:00:00 | Fiscal Close | 2009-08-01 00:00:00