tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 749780d1633002585-sum-the-cells-till-sub-total-cell-appears-goodboy-subtotal-aligw
Sheet: Sheet1

10 | 286.85
55 | 417.35
6 | 253.95
Subtotal
18 | 7365.15
11 | 6050.65
3.25 | 9793.75
11 | 804.25
2 | 4827.4
65 | 1063.45
80 | 181
Subtotal
45 | 234.9
45 | 90.8
90 | 53.25
50 | 62.25
25.5 | 408.25
8.2 | 2455.1
71 | 4484.65
200 | 93.05
Subtotal
10.2 | 3008.8
Subtotal
3 | 668.95
2330 | 154.9
1200 | 142.3
80 | 144.6
22 | 928.5
35 | 935.6
94 | 163.65
30 | 319.75
Subtotal
6 | 132
550 | 92.75
500 | 154.45
114 | 61.45
220 | 131.45
Subtotal
550 | 16.35
500 | 20.85
9.6 | 941.95
16000 | 0.4
7 | 2007.1
1.6 | 1239.6
0.35 | 1698.45
Subtotal
50 | 45.05
120 | 219.35
100 | 951
50 | 108.65
50 | 362.3
4 | 5540.55
5 | 2965.6
3 | 1023.05
Subtotal
12 | 104.35
8 | 1411.15
15 | 1042.1
12 | 138.7
4 | 453.4
2 | 573.8
4 | 1604.1
Subtotal
20 | 52.9
30 | 408.55
20 | 513.75
4 | 532.35
4 | 399.15
12 | 81.5
12 | 166.35
2000 | 9.7
Subtotal
15 | 434.2
10 | 715.05
10 | 594.75
43 | 2453.55
55 | 811.15
25 | 466.3
40 | 564.8
Subtotal
10 | 14275.75
190 | 474.15
20 | 104.6
350 | 6.65
225 | 13.35
20 | 117.75
15 | 333
15 | 510.5
40 | 323
312 | 605.05
25 | 609.5
30 | 479.5
20 | 691.35
80 | 88.15
12 | 1160.9
Subtotal
25 | 911.35
15 | 1651.9
6 | 911.35
60 | 551.8
Subtotal
Spreadsheet: 144500d1331003446-excel-2007-finding-top-scores-with-criteria-math-results
Sheet: Sheet1

Grade | Score | G8 Rank | Final Scores | Final Rank
8 | 89
8 | 88
8 | 87
8 | 86
6 | 85
7 | 84
6 | 83
7 | 82
6 | 81
7 | 80
7 | 79
6 | 78
7 | 77
6 | 76
7 | 75
8 | 99
Spreadsheet: 227932d1365892555-made-a-simple-template-but-not-working-example
Sheet: Sheet1

Date | Value
2012-01-31 00:00:00 | 21
2012-02-29 00:00:00 | 28
2012-03-31 00:00:00 | 25
2012-04-30 00:00:00 | 24
2012-05-31 00:00:00 | 32
2012-06-30 00:00:00 | 27
2012-07-31 00:00:00 | 23
2012-08-31 00:00:00 | 18
2012-09-30 00:00:00 | 25
2012-10-31 00:00:00 | 24
2012-11-30 00:00:00 | 23
2012-12-31 00:00:00 | 27
Spreadsheet: 97629d1296753401-cross-sheet-calc-that-would-omit-0-possible-solution-but-am-getting-a-ref-error-2011trending
Sheet: 0112

01/12/11  Performance Data
 |  | 1st Work |  |  |  | QC |  |  | Total Points Earned | Unavailability |  | Actual Processing  Hours | Avg pts per hour
 |  | SURNOT SURNOTACKL MNBENMMIG SURDTHCERT | SURBENCSMG SURFRM SURVALDOD SURCUSFLUP SURSPLIGO SRSPNIGO SURBENSPLT RAIDPS RAIDNP/TAIDIN-IA FAID/FAIDWF IAID/FAIDCO SURINQ | SURBENRSCH SURBENUPDT RAIDPB RAIDAR | SURBENLEGL SURPAYLNPO | MNTBENMMIG SURSPLIGO SURSPNIGO SURBENSPLT RAIDPS FAID | SURBENRSCH (PASS) SURBENUPDT (PASS/FAIL) RAIDPB RAIDAR | SURBENRSCH (FAIL)
 |  |  |  |  |  |  |  |  |  | # of Hrs | Reason?
Team Members | Flint |  | 6 | 7 |  |  |  |  | 74 |  |  | 5 | 14.8
 | Dustin |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Sharron | 2 | 16 | 4 |  |  |  |  | 84 |  |  | 8.25 | 10.18181818181818
 | Roxy |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | [NAME] |  |  |  |  |  | 13 | 3 | 128 |  |  | 7.75 | 16.51612903225806
 | Ana |  | 6 | 18 |  |  |  |  | 162 |  |  | 8.25 | 19.63636363636364
 |  |  |  |  |  |  |  |  | 0
 | [NAME] | 2 | 37 | 7 |  |  |  |  | 171 | 0.5 | CISS | 8.5 | 20.11764705882353
 | Petra |  |  |  |  | 3 | 9 | 8 | 142 |  |  | 11.75 | 12.08510638297872
 | Regina |  |  |  |  |  |  |  | 0.01 |  | out of office | 0.01 | 1
 | Noy | 4 |  | 5 |  | 2 | 6 | 3 | 124 | 1.5 | SWT | 7.75 | 16
 | [NAME] |  |  |  |  | 11 | 7 |  | 78 |  |  | 7.25 | 10.75862068965517
 | [NAME] | 8 | 19 |  |  |  |  |  | 73 |  | SME | 3.5 | 20.85714285714286
 | Michelle |  |  |  |  |  |  |  | 0.01 |  | SME | 0.01 | 1
 | Keisha |  |  |  |  |  |  |  | 0.01 |  | no data | 0.01 | 1
 | [NAME] |  | 15 | 3 |  |  |  |  | 69 |  |  | 8.75 | 7.885714285714286
TEAM TOTALS | Pts Earned: | 2 | 3 | 8 | 12 | 2 | 8 | 8 |  |  |  |  | 145.9528278390402
 | TASK VOLUME: | 16 | 99 | 44 | 0 | 16 | 35 | 14 | 1105 | 2 |  | 76.80000000000001 | 14.38802083333333
 | Pts Earned: | 32 | 297 | 352 | 0 | 32 | 280 | 112
 |  |  |  |  |  |  |  | Average PTS | 69.065625 |  | Total Task Volume |  | 224
 | MID-DAY PPH  no data
Spreadsheet: 255d1d53-7ccd-4a35-bf07-699b18e73cc7
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 12 | 15 | 50 | 71 | 123 | 102 | 86 | 15 | 474
Cross-Currency Fixed-Fixed | 0 | 0 | 2 | 1 | 2 | 9 | 1 | 0 | 15
Cross-Currency Fixed-Float | 0 | 11 | 45 | 47 | 50 | 32 | 0 | 0 | 185
TOTAL | 12 | 26 | 97 | 119 | 175 | 143 | 87 | 15 | 674
Spreadsheet: 115099d1310727216-highlighting-cells-project-tracker-document
Sheet: Tracker

Facilities capital projects 2011 |  |  |  |  |  |  |  |  |  |  |  |  |  | Role
 |  |  |  | Project | - | ?? |  |  |  | Team members - | 1 | ?? | - | ??
 |  |  |  | Project Manager | - | ?? |  |  |  |  | 2 | ?? | - | ??
 |  |  |  | Project sponsor | - | ?? |  |  |  |  | 3 | ?? | - | ??
Preliminaries |  |  |  | Sponsor assigned |  | Project manager identified |  | Project team identified |  |  |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Design |  |  |  | Need for project defined |  | Discuss project need with stakeholders |  | Design ideas (drawings) |  | Stakeholder design approval |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Charter & contract |  |  |  | Create project charter |  | Project charter approved |  | Create management of change document |  | Management of change approved |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Costing |  |  |  | Send drawings out to tender |  | Create budget tracker |  | tenders approved by stakeholders |  | Approve succesful tenders |  | Raise RFA |  | RFA approval |  | Complete?
 |  |  | Target
 |  |  | Actual
Health & safety |  |  |  | Aquire contractor risk assessments |  | Aquire contractor method statments |  | CTT job specific risk assesment |  | Submit all H&S information to on site H&S |  | On site H&S approval |  | Assign individual contractor work permits |  | Complete?
 |  |  | Target
 |  |  | Actual
Management |  |  |  | Raise orders |  | Orders approved |  | Project start date |  | Commencement of schedule of works |  | Continuous on site management |  | Project completion |  | Complete?
 |  |  | Target
 |  |  | Actual
Sign off |  |  |  | Snagging list compiled |  | Snagging works completed |  | Completion certificate handed over |  | Receive orders |  | Subit invoices to accounts |  | Ensure Ariba 3 way match |  | Complete?
 |  |  | Target
 |  |  | Actual
Sustain |  |  |  | Update facilities documentation |  | Learn lessons |  | Close off project |  |  |  |  |  |  |  | Complete?
 |  |  | Target
 |  |  | Actual
Completion |  |  |  | Target completion date |  | Actual complation date
 |  |  | Target
 |  |  | Actual
Spreadsheet: 887887d1738221662-how-to-split-a-given-quantity-into-cases-and-units-book1
Sheet: Sheet1

 |  | Code | Description | Units per Case | Order in Case | Case | Units
 |  | 1010E | UHT 2 LTR FF | 6 | 2 | 2
 |  | 1011E | UHT 1 LTR FF | 12 | 1.5 | 1 | 6
 |  | 1011EP | UHT 1 LTR FF | 12 | 3 | 3
 |  | 1011MO | UHT 1 LTR FF MULTI | 12 | 4 | 4
 |  | 1012E | SKIMMED MILK | 12 | 1 | 1
 |  | 1020E | UHT 500ML | 18 | 1 | 1
 |  | 1051M | UHT 200ML FF | 24 | 1.25 | 1 | 6
 |  | 1055E | UHT 125ML | 24 | 1.25 | 1 | 6
 |  | 1070NE | GOLD MILK | 6 | 3 | 2
 |  | 1209E | UHT 2 LTR LF | 6 | 0.5 |  | 3
 |  | 1210MO | UHT 1 LTR LF | 12 | 1 | 1
Spreadsheet: 691882d1597932724-how-to-count-rank-by-category-average
Sheet: Sheet1

 |  |  | category |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ranking |  | expected result ranking
 |  |  | 1 M | 84 | B | 70 | B | 80 | B | 50 | D | 10 | F | 65 | C | 90 | A | TH | TH | 60 | C |  |  |  |  | 2
 |  |  | 1 M | 84 | B | 70 | B | 84 | B | 70 | B | 84 | B | 70 | B | TH | TH | TH | TH | TH | TH |  |  |  |  | 1
 |  |  | 1 C | 84 | B | 70 | B | 84 | B | 70 | B | 80 | B | 50 | D | 10 | F | 65 | C | 90 | A |  |  |  |  | 1
Spreadsheet: 834832d1688113314-how-can-i-exclude-counting-calc-when-using-the-function-countif-questions-for-count-if-function
Sheet: Output

Total Access
Total Pending
 | 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 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84 | 85 | 86 | 87 | 88 | 89 | 90 | 91 | 92 | 93 | 94 | 95 | 96 | 97 | 98 | 99 | 100 | 101 | 102 | 103 | 104 | 105 | 106 | 107 | 108 | 109 | 110 | 111 | 112 | 113 | 114 | 115 | 116 | 117 | 118 | 119 | 120 | 121 | 122 | 123 | 124 | 125 | 126 | 127 | 128 | 129 | 130 | 131 | 132 | 133 | 134 | 135 | 136 | 137 | 138 | 139 | 140 | 141 | 142 | 143 | 144 | 145 | 146 | 147 | 148 | 149 | 150 | 151 | 152 | 153 | 154 | 155 | 156 | 157 | 158 | 159 | 160 | 161 | 162 | 163 | 164 | 165 | 166 | 167 | 168 | 169 | 170 | 171 | 172 | 173 | 174 | 175 | 176 | 177 | 178 | 179 | 180 | 181 | 182 | 183 | 184 | 185 | 186 | 187 | 188 | 189 | 190 | 191 | 192 | 193 | 194 | 195 | 196 | 197 | 198 | 199 | 200 | 201 | 202 | 203 | 204 | 205 | 206 | 207 | 208 | 209 | 210 | 211 | 212 | 213 | 214 | 215 | 216 | 217 | 218 | 219 | 220 | 221 | 222 | 223 | 224 | 225 | 226 | 227 | 228 | 229 | 230 | 231 | 232 | 233 | 234 | 235 | 236 | 237 | 238 | 239 | 240 | 241
Access Status |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
Access | 1
Access | 2
Access | 3
Access | 4
Access | 5
Access | 6
Access | 7
Access | 8
Access | 9
Access | 10
Access | 11
Access | 12
Access | 13
Access | 14
Access | 15
Access | 16
Access | 17
Access | 18
Access | 19
Access | 20
Access | 21
Access | 22
Access | 23
Access | 24
Access | 25
Access | 26
Access | 27
Access | 28
Access | 29
Access | 30
Access | 31
Access | 32
Access | 33
Access | 34
Access | 35
Access | 36
Access | 37
Access | 38
Access | 39
Access | 40
Access | 41
Access | 42
Access | 43
Access | 44
Access | 45
Access | 46
Access | 47
Access | 48
Access | 49
Access | 50
Access | 51
Access | 52
Access | 53
Access | 54
Access | 55
Access | 56
Access | 57
Access | 58
Access | 59
Access | 60
Access | 61
Access | 62
Access | 63
Access | 64
Access | 65
Access | 66
Access | 67
Access | 68
Access | 69
Access | 70
Pending | 1
Pending | 2
Pending | 3
Pending | 4
Pending | 5
Pending | 6
Pending | 7
Pending | 8
Pending | 9
Pending | 10
Pending | 11
Pending | 12
Pending | 13
Pending | 14
Pending | 15
Pending | 16
Pending | 17
Pending | 18
Pending | 19
Pending | 20
Pending | 21
Pending | 22
Pending | 23
Pending | 24
Pending | 25
Pending | 26
Pending | 27
Pending | 28
Pending | 29
Pending | 30
Pending | 31
Pending | 32
Pending | 33
Pending | 34
Pending | 35
Pending | 36
Pending | 37
Pending | 38
Pending | 39
Pending | 40
Pending | 41
Pending | 42
Pending | 43
Pending | 44
Pending | 45
Pending | 46
Pending | 47
Pending | 48
Pending | 49
Pending | 50
Spreadsheet: 44368d1242954722-dates-and-groups-dates-and-groups
Sheet: Sheet1

[NAME] j | 1965-10-12 00:00:00 | Green | list1 | list2 | [NAME] j | [NAME] j
[NAME] | 1956-02-03 00:00:00 | Blue | Green | October |  | [NAME]
[NAME] | 1963-05-14 00:00:00 | Red |  |  |  | Smashin' Pumpkins
U Chaves | 1955-04-14 00:00:00 | Green |  |  |  | Maroon 5 |  | Source of list 2
M Saakashvili | 1980-05-25 00:00:00 | Blue |  |  |  | The Cranberries |  | January
[NAME] | 1984-06-23 00:00:00 | Red |  |  |  | Diturbed |  | February
V Medvedev | 1960-05-20 00:00:00 | Green |  |  |  | #N/A |  | March
[NAME] | 1963-10-01 00:00:00 | Green |  |  | [NAME] | #N/A |  | April
Ahmadinejat | 1948-08-11 00:00:00 | Red |  |  |  | #N/A |  | May
Smashin' Pumpkins | 2000-10-01 00:00:00 | Green |  |  | Smashin' Pumpkins | #N/A |  | June
Radiohead | 1989-07-12 00:00:00 | Red |  |  |  | #N/A |  | July
Linkin Park | 1963-10-14 00:00:00 | Red |  |  |  | #N/A |  | August
HIM | 1955-12-14 00:00:00 | Green |  |  |  | #N/A |  | September
Seether | 1980-05-25 00:00:00 | Blue |  |  |  | #N/A |  | October
Nickleback | 1984-11-23 00:00:00 | Blue |  |  |  | #N/A |  | November
ACDC | 1960-05-20 00:00:00 | Green |  |  |  | #N/A |  | December
Foo Fighters | 1963-01-01 00:00:00 | Green |  |  |  | #N/A
Ill Nino | 1948-08-11 00:00:00 | Red |  |  |  | #N/A
Edguy | 1965-12-12 00:00:00 | Green |  |  |  | #N/A
Doro | 1956-02-03 00:00:00 | Blue |  |  |  | #N/A
[NAME] | 1963-05-14 00:00:00 | Red |  |  |  | #N/A
Maroon 5 | 1955-10-14 00:00:00 | Green |  |  | Maroon 5 | #N/A
[NAME] | 1980-05-25 00:00:00 | Blue |  |  |  | #N/A
Stratovarius | 1984-06-23 00:00:00 | Red |  |  |  | #N/A
The Rolling Stones | 1960-05-20 00:00:00 | Green |  |  |  | #N/A
The Cranberries | 1963-10-01 00:00:00 | Green |  |  | The Cranberries | #N/A
Red Hot Chili Peppers -Snow | 1948-08-11 00:00:00 | Red |  |  |  | #N/A
U2 | 2000-01-01 00:00:00 | Green |  |  |  | #N/A
Garbage | 1989-07-12 00:00:00 | Red |  |  |  | #N/A
Diturbed | 1963-10-14 00:00:00 | Green |  |  | Diturbed | #N/A
Forgotten | 1955-12-14 00:00:00 | Green
Spreadsheet: 35787d1233443381-if-function-test
Sheet: Sheet1

lastname | firstname | Hire/Term Date | active | fulltime | permanent
SMITH | [NAME] | 2008-06-21 00:00:00 | 1 | 0 | 0
SMITH | [NAME] | 2008-07-06 00:00:00 | 0 | 1 | 1
SMITH | [NAME] | 2008-12-29 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2004-08-06 00:00:00 | 1 | 0 | 0
DOE | [NAME] | 2004-10-30 00:00:00 | 0 | 1 | 1
DOE | [NAME] | 2005-07-05 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2007-01-14 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2007-06-15 00:00:00 | 1 | 0 | 0
DOE | [NAME] | 2007-06-25 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2007-10-15 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2003-05-23 00:00:00 | 1 | 0 | 0
DOE | [NAME] | 2003-08-12 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2006-04-22 00:00:00 | 1 | 0 | 0
DOE | [NAME] | 2006-09-11 00:00:00 | 0 | 0 | 0
DOE | [NAME] | 2007-08-10 00:00:00 | 1 | 0 | 0
DOE | [NAME] | 2008-02-24 00:00:00 | 0 | 0 | 0
SMITH | [NAME] | 2007-07-06 00:00:00 | 1 | 0 | 0
SMITH | [NAME] | 2007-09-20 00:00:00 | 0 | 0 | 0
Spreadsheet: 835173d1688383087-linking-two-excel-tabs-using-common-columns-01-expensestravel-index-test
Sheet: Month

No. | Month | Month1 |  |  |  |  | Date | Month | Year
1 | 01Jan | Jan |  |  |  |  | 2003-11-04 00:00:00 | 11Nov | 2003 | 11Nov 2003
2 | 02Feb | Feb |  |  |  |  | 2003-12-04 00:00:00 | 12Dec | 2003 | 12Dec 2003
3 | 03Mar | Mar |  |  |  |  | 2003-04-04 00:00:00 | 04Apr | 2003 | 04Apr 2003
4 | 04Apr | Apr |  |  |  |  | 2003-11-15 00:00:00 | 11Nov | 2003 | 11Nov 2003
5 | 05May | May |  |  |  |  | 2003-11-14 00:00:00 | 11Nov | 2003 | 11Nov 2003
6 | 06Jun | Jun |  |  |  |  | 2003-11-14 00:00:00 | 11Nov | 2003 | 11Nov 2003
7 | 07Jul | Jul |  |  |  |  | 2003-03-13 00:00:00 | 03Mar | 2003 | 03Mar 2003
8 | 08Aug | Aug |  |  |  |  | 2003-11-15 00:00:00 | 11Nov | 2003 | 11Nov 2003
9 | 09Sep | Sep |  |  |  |  | 2004-11-06 00:00:00 | 11Nov | 2004 | 11Nov 2004
10 | 10Oct | Oct
11 | 11Nov | Nov
12 | 12Dec | Dec
0 | $$$ | $$$
 | blank | blank
CONCATENATE(VLOOKUP(MONTH(A120)-1,Month!A$1:C$13,3,TRUE),"-",YEAR(A120),"-","Rent to Sheriff")
2011-01-01 00:00:00 | 1 | Dec
Maint for Dec  1899
CONCATENATE("Maint for"," ",IF(MONTH(A3262)<>1,VLOOKUP(MONTH(A3262)-1,Month!A$1:C$13,3,TRUE),VLOOKUP(12,Month!A$1:C$13,3,TRUE))," ",IF(MONTH(A3262)<>1,YEAR(A3262),YEAR(A3262)-1))
Spreadsheet: 587136d1534862021-excel-formula-for-countifs-test
Sheet: Sheet2

DATE for COPQ | QTY of RMAs | QTY of RMA Parts
2015-01-01 00:00:00 | 0
2015-02-01 00:00:00
2015-03-01 00:00:00
2015-04-01 00:00:00
2015-05-01 00:00:00
2015-06-01 00:00:00
2015-07-01 00:00:00
2015-08-01 00:00:00
2015-09-01 00:00:00
2015-10-01 00:00:00
2015-11-01 00:00:00
2015-12-01 00:00:00
2016-01-01 00:00:00
2016-02-01 00:00:00
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
2017-01-01 00:00:00
2017-02-01 00:00:00
2017-03-01 00:00:00
2017-04-01 00:00:00
2017-05-01 00:00:00
2017-06-01 00:00:00
2017-07-01 00:00:00
2017-08-01 00:00:00
2017-09-01 00:00:00
2017-10-01 00:00:00
2017-11-01 00:00:00
2017-12-01 00:00:00
2018-01-01 00:00:00
2018-02-01 00:00:00
2018-03-01 00:00:00
2018-04-01 00:00:00
2018-05-01 00:00:00
2018-06-01 00:00:00
2018-07-01 00:00:00
2018-08-01 00:00:00
2018-09-01 00:00:00
2018-10-01 00:00:00
2018-11-01 00:00:00
2018-12-01 00:00:00
2019-01-01 00:00:00
2019-02-01 00:00:00
2019-03-01 00:00:00
2019-04-01 00:00:00
2019-05-01 00:00:00
2019-06-01 00:00:00
2019-07-01 00:00:00
2019-08-01 00:00:00
2019-09-01 00:00:00
2019-10-01 00:00:00
2019-11-01 00:00:00
2019-12-01 00:00:00
2020-01-01 00:00:00
2020-02-01 00:00:00
2020-03-01 00:00:00
2020-04-01 00:00:00
2020-05-01 00:00:00
2020-06-01 00:00:00
2020-07-01 00:00:00
2020-08-01 00:00:00
2020-09-01 00:00:00
2020-10-01 00:00:00
2020-11-01 00:00:00
2020-12-01 00:00:00
Spreadsheet: 799129d1664949857-formula-to-create-number-series-book3-hd
Sheet: Sheet1

 |  |  | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 2 | 2
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 4 | 4
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 8 | 8
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 16 | 16
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 32 | 32
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
 |  |  | 64 | 64
Spreadsheet: 115848d1311334667-using-wildcards-to-search-a-list-data-extraction
Sheet: Sheet1

Doc# | Date | Bldg | List - Prob | List - Solv
ASP-1131-01 | 2011-05-11 00:00:00 | ASP | 416 | 416
35D-1172-01 | 2011-06-21 00:00:00 | 5-135D | One | 412
02-1172-01 | 2011-06-21 00:00:00 | 2 | Two | Two
42-1173-01 | 2011-06-22 00:00:00 | 42 | Forty-Two | Forty-Two
35-1104-01 | 2011-04-14 00:00:00 | 5-135 | 412 | 412
42F-1180-01 | 2011-06-29 00:00:00 | 42F | Two | Forty-Two
1 | One
2 | Two
42 | Forty-Two
5-135 | 412
5-136 | 412
5-155 | 410
ASP | 416
Spreadsheet: 453922d1459518982-attendance-point-tracker-attendance-tracker
Sheet: Spherion Terms

Agent | TL | SM | Status | DOH | DOT | Tenure
Purley, [NAME] | [NAME] | [NAME] | TERM | 2006-12-04 00:00:00 | 2007-02-01 00:00:00
[NAME], [NAME] | Kumbalek (TB4) | [NAME] | TERM | 2007-01-15 00:00:00 | 2007-02-01 00:00:00
[NAME], [NAME] | Perea | [NAME] | TERM | 2007-01-15 00:00:00 | 2007-02-01 00:00:00
Haynes, [NAME] | [NAME] | [NAME] | TERM | 2006-12-04 00:00:00 | 2007-02-09 00:00:00
Kruse, [NAME] | [NAME] (TB2) | [NAME] | TERM | 2007-01-29 00:00:00 | 2007-02-15 00:00:00
[NAME], [NAME] | [NAME] (TB2) | [NAME] | TERM | 2007-01-29 00:00:00 | 2007-02-15 00:00:00
Tantillo, Johanna | [NAME] (TB2) | [NAME] | TERM | 2007-02-19 00:00:00 | 2007-02-28 00:00:00
[NAME], Danielle | Baumgardner | [NAME] | TERM | 2007-01-15 00:00:00 | 2007-02-27 00:00:00
Spreadsheet: 856618d1705814882-match-and-extract-lambda-map-filter-extract_3
Sheet: L3

 |  |  |  |  | Match |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<< Extract >> | <<< Extract >> |  |  | <<< Extract >>
 |  |  |  |  | B-1/2/3 | fsf | vfsdfs | gdsf | dfgsd | fas | sfasdf | afs | asdfeas | fasdf | asdf | asdf | dasf | asdf | asdf |  |  |  |  |  |  | x | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-2/5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x
 |  |  |  |  | x
 |  |  |  |  | S-1
 |  |  |  |  | ab
Spreadsheet: 100070d1298541399-3d-cell-referencing-help-bracknell-start
Sheet: Wokingham

 |  |  |  |  |  |  |  |  |  |  |  |  | commission | 0.005 |  | Wcommission
Wokingham |  |  |  |  |  |  |  |  |  |  |  |  | Australia sales | 70000 |  | WAussales
 |  |  |  |  |  |  |  |  |  |  |  |  | Australia bonus | 150 |  | WAusbonus
 |  | Europe | Australia | Asia | America | Africa | Agent total |  |  |  |  |  | Individual bonus | 100 |  | WIndbonus
 | Name#1
 | Name#2
 | [NAME]
 | Name#4
 | Name#5
 | Total for each region | 0 | 0 | 0 | 0 | 0 | 0
 |  | Commission |  |  | Australia Bonus |  |  | Individual Target | Individual Bonus |  | Agent total with bonuses + commission
 | Name#1 | 0 |  | Name#1 | 0 |  | Name#1 | 200000 | 0 |  | 0
 | Name#2 | 0 |  | Name#2 | 0 |  | Name#2 | 300000 | 0 |  | 0
 | [NAME] | 0 |  | [NAME] | 0 |  | [NAME] | 200000 | 0 |  | 0
 | Name#4 | 0 |  | Name#4 | 0 |  | Name#4 | 300000 | 0 |  | 0
 | Name#5 | 0 |  | Name#5 | 0 |  | Name#5 | 200000 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  | Total for all agents | 0
 | min | 0
 | [NAME] | 0
 | average | #N/A
Spreadsheet: 756138d1637302958-can-i-dynamically-reference-the-same-cell-across-multiple-worksheets-in-if-and-textjoin-therapists-availability2-copy
Sheet: Person2

Person2 | Monday | Tuesday | Wednesday | Thursday | Friday
07:30:00 | Weekly |  | Weekly | Filled | Weekly
08:15:00 | Weekly |  | Filled | Filled | Filled
09:00:00 | Filled |  | Weekly | Filled | Filled
09:45:00 | Weekly |  | unavailable | unavailable | unavailable
10:30:00 | Filled |  | unavailable | unavailable | unavailable
11:15:00 | Filled |  | Filled | Weekly | Weekly
12:00:00 | unavailable |  | unavailable | unavailable | unavailable
01:00:00 | Filled |  | Filled | Filled | Weekly
01:45:00 | Weekly |  | Filled | e/o week | e/o week
02:30:00 | Filled |  | Filled | Filled | Filled
03:15:00 | e/o week |  | e/o week | Filled | Filled
04:00:00 | Filled |  | Filled | Filled | e/o week
04:45:00 | Filled |  | Filled | Filled | Filled
05:30:00 | Filled |  | Filled | Weekly | Weekly
Person2 (w)
Person2 (e/o)
Spreadsheet: 112696d1308741388-cell-is-less-than-now-error-transfercalculator-help
Sheet: Sheet1

 | 2011-06-22 12:12:22 |  |  |  |  |  |  |  |  | Current Time | Currentdate
 | 2011-06-22 12:12:22 |  |  |  |  |  |  |  |  | 2011-06-22 12:12:22 | 2011-06-22 12:12:22
 | Start Depot | End Depot | Transfer Time (Days) | Delivery Date | A&B |  |  |  | Ordering Depot | Default Depot | HELPERCELL | Cut off | D B4 Cut | D After Cut | Route | Depot List
 | WINNALL (2) | SOUTHAM (3) | 2 | 2011-06-24 12:12:22 | WINNALL (2) SOUTHAM (3) |  |  |  | WINNALL (2) | SOUTHAM (3) | WINNALL (2) SOUTHAM (3) | 16:30:00 | 1 | 2 | WIN > SOU | WINNALL (2)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SOUTHAM (3)
Spreadsheet: 80156d1280360135-trying-to-make-a-cell-display-results-from-other-sample
Sheet: Stock control

OPEN STOCK | CITRINE | EMERALD | CLEAR | ROSE | AQUAMARIE | LIGHT SIAM | LIGHT ROSE | SAPPHIRE | LIGHT SAPPIRE |  |  |  | STOCK BOUGHT
1440 | 2mm | 2mm | 2mm | 2mm | 2mm | 1.8mm | 2mm | 2mm | 2mm
 |  |  |  |  |  |  |  |  |  |  |  |  | DATE | CITRINE | DATE | EMERALD | DATE | CLEAR | DATE | ROSE | DATE | AQUAMARIE | DATE | LIGHT SIAM | DATE | LIGHT ROSE | DATE | SAPPHIRE | DATE | LIGHT SAPPIRE
CRYSTAL LEVELS | #N/A |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 2mm |  | 2mm |  | 2mm |  | 2mm |  | 2mm |  | 1.8mm |  | 2mm |  | 2mm |  | 2mm
CASE STYLE |  |  |  |  |  |  |  |  |  | AMOUNT |  |  |  | 4
& DESIGN
 | -6 |  |  |  |  |  |  |  |  | 1