tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 120632d1315414399-finding-area-under-a-curve-lab1-data-set-2
Sheet: Sheet2

SUMMARY OUTPUT
Regression Statistics
Multiple R | 0.3317279127610628
R Square | 0.1100434081048113
Adjusted R Square | 0.1074933892168595
Standard Error | 0.4239766125630765
Observations | 351
ANOVA
 | df | SS | MS | F | [NAME]
Regression | 1 | 7.757190132234591 | 7.757190132234591 | 43.15395804507077 | 1.839943307122306e-10
Residual | 349 | 62.73490263216092 | 0.1797561680004611
Total | 350 | 70.49209276439551
 | Coefficients | Standard Error | t Stat | P-value | Lower 95% | Upper 95% | Lower 95.0% | Upper 95.0%
Intercept | -0.2168612378131115 | 0.1084750629840286 | -1.9991805659983 | 0.04636381165882488 | -0.4302083164635826 | -0.00351415916264039 | -0.4302083164635826 | -0.00351415916264039
X Variable 1 | 0.001467181793206792 | 0.0002233436511354519 | 6.56916722614598 | 1.839943307122548e-10 | 0.001027912949344545 | 0.001906450637069039 | 0.001027912949344545 | 0.001906450637069039
Spreadsheet: 65bdbd5f-0163-425e-9bf2-f309a7819aec
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 689076843225 | What | Psalm 151: Welcome 2 Praise The Lord | 2007-02-06 | Compact Disc | Urban | 12.99 | N | To Be Retired
Spreadsheet: 173715d1344690828-data-validation-demo1
Sheet: Sheet1

Fruit List | Country List | Ref#
Apple | Chile |  |  | Apple | Chile | 1
Apple |  |  |  | Orange | Spain | 2
 |  |  |  | Peach | Italy | 2
 |  |  |  | Apple | Poland | 3
 |  |  |  | Kiwi | New Zealand | 4
 |  |  |  | Grapes | France | 5
 |  |  |  | Orange | South Africa | 6
 |  |  |  | kiwi
 |  |  |  | banana
Spreadsheet: 870006d1716522663-formula-to-de-concatenate-data-string-example-file-v2-2-1-
Sheet: Sheet1

Imported Concatenation String | Invoice Date | Concat1 | Concat2 | Concat3 | Concat4 | Concat5 | [NAME] | Concat7 | Concat8 | Concat9 | Concat10 | Concat11 | Concat12 | Concat13 | Concat14 | Concat15 | Concat16
17165624|17111996|17029062|17004593|17004085|17004102|15981590|15885416|15981590|15885416|17165624|17111996|17029062|17004593|17004085|17004102 | 2024-05-31 00:00:00 |  | 17111996 | 17029062 | 17004593 | 17004085 | 17004102 | 15981590 | 15885416 | 15981590 | 15885416 | 17165624 | 17111996 | 17029062 | 17004593 | 17004085 | 17004102
16386362|16253089|16253089 | 2024-06-05 00:00:00 |  | 16253089 | 16253089
16184942|16184942 | 2024-06-06 00:00:00 |  | 16184942
Outstanding | 2024-05-31 00:00:00
16482813 | Open
17129531|17028782|16755556|16176427|15816828|16581167|16368754|16176427|15816828|17129531|17028782|16755556 | 2024-06-05 00:00:00 |  | 17028782 | 16755556 | 16176427 | 15816828 | 16581167 | 16368754 | 16176427 | 15816828 | 17129531 | 17028782 | 16755556
Outstanding | 2024-05-31 00:00:00
17239059|17239059 | Open |  | 17239059
Unique List | Invoice Date | < Expected Results:
 |  | 2024-05-31 00:00:00
17111996 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
17029062 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
17004593 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
17004085 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
17004102 | 2024-05-31 00:00:00 | 2024-05-31 00:00:00
15981590 | 2024-05-31 00:00:00 | 2024-06-05 00:00:00
15885416 | 2024-05-31 00:00:00 | 2024-06-05 00:00:00
16386362 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
16253089 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
0 | Open
16184942 | 2024-06-06 00:00:00 | 2024-06-06 00:00:00
Outstanding |  | (Incorrect invoice date attributed by head office)
16482813 | Open | Open
17129531 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
17028782 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
16755556 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
16176427 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
15816828 | 2024-06-05 00:00:00
16581167 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
16368754 | 2024-06-05 00:00:00 | 2024-06-05 00:00:00
17239059 | Open | Open
Spreadsheet: 156606d1337356404-count-occurrences-and-fill-cells-with-results-using-a-date-range-copy-of-sample-workbook-1
Sheet: Summary Sheet

 | Group 4 |  |  | Group 8 |  |  | Group 16
 | Code ID | # [NAME] |  | Code ID | # [NAME] |  | Code ID | # [NAME]
Spreadsheet: 99272d1297960908-counting-data-from-multiple-sheets-example1
Sheet: Sheet1

 | 4 | 5 | 7 | 9 | 20
 | 4 | 26 | 28 | 29 | 30
 | 4 | 7 | 14 | 22 | 27
 | 3 | 4 | 5 | 17 | 18
 | 1 | 5 | 10 | 19 | 21
 | 6 | 15 | 24 | 25 | 26
 | 5 | 15 | 25 | 29 | 31
 | 14 | 20 | 21 | 22 | 23
 | 3 | 5 | 7 | 16 | 31
 | 2 | 5 | 15 | 26 | 27
 | 2 | 17 | 19 | 28 | 29
 | 1 | 4 | 6 | 12 | 26
 | 8 | 16 | 18 | 27 | 28
 | 7 | 10 | 23 | 29 | 31
 | 3 | 6 | 12 | 15 | 26
 | 2 | 3 | 14 | 24 | 28
 | 13 | 14 | 18 | 20 | 28
 | 1 | 4 | 8 | 15 | 21
 | 5 | 7 | 12 | 20 | 25
 | 4 | 6 | 13 | 15 | 17
 | 13 | 17 | 18 | 24 | 26
 | 6 | 13 | 20 | 26 | 31
 | 3 | 4 | 11 | 19 | 22
 | 2 | 6 | 7 | 15 | 24
 | 4 | 6 | 9 | 23 | 27
 | 1 | 2 | 22 | 26 | 27
 | 2 | 14 | 16 | 24 | 25
 | 1 | 2 | 18 | 20 | 30
 | 4 | 5 | 11 | 16 | 24
 | 1 | 4 | 23 | 26 | 27
 | 6 | 7 | 13 | 18 | 26
Spreadsheet: 267697d1380139651-unique-values-by-month-in-date-range-unique-by-month
Sheet: Sheet1

 |  |  |  | What is the unique count of Name in 2013
Name | Created Date |  |  | How can I see the unique Names by month in either a pivot, chart, or table?
GF | 2013-01-02 00:00:00 |  |  | ie.
FG | 2013-01-07 00:00:00
DD | 2013-06-17 00:00:00 |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00
AA | 2013-06-28 00:00:00 |  |  | AA
BB | 2013-06-28 00:00:00 |  |  | AB
AB | 2013-07-02 00:00:00 |  |  | AC
AC | 2013-07-02 00:00:00 |  |  | BB
AB | 2013-07-16 00:00:00 |  |  | DD
BB | 2013-07-22 00:00:00 |  |  | FG
AA | 2013-08-01 00:00:00 |  |  | GF
AA | 2013-08-01 00:00:00 |  |  | GG
HE | 2013-08-02 00:00:00 |  |  | HE
QR | 2013-08-02 00:00:00 |  |  | JK
LM | 2013-08-07 00:00:00 |  |  | LM
BB | 2013-08-07 00:00:00 |  |  | PP
JK | 2013-08-23 00:00:00 |  |  | QQ
AB | 2013-08-23 00:00:00 |  |  | QR
ZA | 2013-08-23 00:00:00 |  |  | RT
GF | 2013-08-26 00:00:00 |  |  | RV
FG | 2013-08-26 00:00:00 |  |  | SV
GF | 2013-09-09 00:00:00 |  |  | ZA
AA | 2013-09-12 00:00:00 |  |  | COUNT OF NEW UNIQUES
BB | 2013-09-12 00:00:00
DD | 2013-09-12 00:00:00
FG | 2013-09-12 00:00:00
AC | 2013-09-16 00:00:00
AB | 2013-09-19 00:00:00
AB | 2013-09-19 00:00:00
AA | 2013-09-23 00:00:00
AA | 2013-09-23 00:00:00
BB | 2013-09-23 00:00:00
Spreadsheet: f6f632c9-17c7-439a-974d-1b8a93502d10
Sheet: Sheet1

[NAME]. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Table S1
 |  |  | Weights [g] day 28 |  |  | Weights [g] day 68
Vaccine groups | [NAME] | Body | Spleen | Liver | Body | Spleen | Liver
 | 1 | 23.32 | 0.442 | 1.64 | 24.56 | 1.036 | 1.85
 | 2 | 21.45 | 0.42 | 1.409 | 22.47 | 0.93 | 1.66
Untreated | 3 | 23.32 | 0.423 | 1.604 | 21.76 | 0.88 | 1.57
 | 4 | 24.84 | 0.415 | 1.655 | 25.8 | 1.05 | 1.88
 | 5 | 22.62 | 0.366 | 1.569 | n.d. | n.d. | n.d.
Mean ± SD |  | 23.11 ± 1.233 | 0.413 ± 0.028 | 1.575 ± 0.099 | 23.65 ± 1.863 | 0.974 ± 0.082 | 1.74 ± 0.149
 | 1 | 25.96 | 0.441 | 1.649 | 24.66 | 1.083 | 1.692
 | 2 | 23.05 | 0.455 | 1.557 | 22.55 | 0.77 | 1.74
SL3261 | 3 | 24.6 | 0.429 | 1.594 | 22.63 | 0.78 | 1.5
 | 4 | 22.84 | 0.387 | 1.507 | 22.86 | 0.79 | 1.64
 | 5 | 22.12 | 0.375 | 1.353 | n.d. | n.d. | n.d.
Mean ± SD |  | 23.71 ± 1.547 | 0.417 ± 0.035 | 1.532 ± 0.113 | 23.18 ± 0.999 | 0.856 ± 0.152 | 1.643 ± 0.104
 | 1 | 23.75 | 0.405 | 1.435 | 22.48 | 0.94 | 1.72
 | 2 | 22.18 | 0.432 | 1.408 | 23.44 | 0.95 | 1.68
pcVAC1-KMP | 3 | 22.52 | 0.346 | 1.445 | 22.37 | 0.88 | 1.58
 | 4 | 22.03 | 0.499 | 1.496 | 23.31 | 0.92 | 1.81
 | 5 | 21.6 | 0.35 | 1.384 | 23.09 | 0.84 | 1.67
Mean ± SD |  | 22.42 ± 0.816 | 0.406 ± 0.063 | 1.434 ± 0.042 | 22.94 ± 0.486 | 0.906 ± 0.046 | 1.692 ± 0.083
 | 1 | 23.94 | 0.387 | 1.439 | 23.98 | 0.77 | 1.61
 | 2 | 22.06 | 0.543 | 1.661 | 23.73 | 0.69 | 1.53
psVAC5-08.1190 | 3 | 22.88 | 0.481 | 1.643 | 23.05 | 0.79 | 1.49
 | 4 | 22.13 | 0.538 | 1.62 | 23.81 | 1.02 | 1.68
 | 5 | 23.2 | 0.55 | 1.753 | 21.26 | 0.55 | 1.43
Mean ± SD |  | 22.84 ± 0.783 | 0.500 ± 0.069 | 1.623 ± 0.115 | 23.17 ± 1.123 | 0.764 ± 0.171 | 1.548 ± 0.099
 | 1 | 20.61 | 0.4 | 1.263 | 22.59 | 0.6 | 1.4
 | 2 | 23.36 | 0.448 | 1.521 | 22.35 | 0.77 | 1.42
[NAME] allstars | 3 | 21.67 | 0.469 | 1.453 | 23.83 | 0.75 | 1.54
 | 4 | 22.45 | 0.403 | 1.427 | 24.09 | 0.65 | 1.55
 | 5 | 21.59 | 0.429 | 1.372 | n.d. | n.d. | n.d.
Mean ± SD |  | 21.94 ± 1.030 | 0.430 ± 0.029 | 1.407 ± 0.097 | 23.22 ± 0.872 | 0.692 ± 0.081 | 1.478 ± 0.078
Spreadsheet: 717874d1612887074-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Classes

Day | Monday | Monday | Monday | Monday | Tuesday | Tuesday | Tuesday | Tuesday | Wednesday | Wednesday | Wednesday | Wednesday | Wednesday | Thursday | Thursday | Thursday | Thursday | Friday | Friday
System | System 1 | System A | System 2 | System 3 | System 4 | System B | System 5 | System 6 | System 7 | System 8 | System C | System D | System 9 | System E | System F | System 10 | System G | System H | System 11
Students not listed above need to show below for each day.
Monday | Tuesday | Wednesday | Thursday | Friday
Spreadsheet: kate_symes__18852__SP 15 pages
Sheet: DJ SP15

 |  |  | Firm | Volume | Firm | Volume | Sun & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-14 00:00:00 |  | 169.24 | 16576 | 110.08 | 7280
 | 2001-03-13 00:00:00 |  | 170.67 | 19648 | 104.69 | 3840
 | 2001-03-12 00:00:00 |  | 183.93 | 23040 | 107.19 | 6880
 | 2001-03-11 00:00:00 |  |  |  |  |  | 107.67 | 17640
 | 2001-03-10 00:00:00 |  | 156.73 | 17840 | 98.45 | 6040
 | 2001-03-09 00:00:00 |  | 157.31 | 16960 | 98.45 | 6040
 | 2001-03-08 00:00:00 |  | 213.95 | 22880 | 131.78 | 6600
 | 2001-03-07 00:00:00 |  | 313.92 | 24048 | 201.19 | 6080
 | 2001-03-06 00:00:00 |  | 339.12 | 29856 | 231.76 | 7080
 | 2001-03-05 00:00:00 |  | 299.82 | 13200 | 217.92 | 3080
 | 2001-03-04 00:00:00 |  |  |  |  |  | 217.92 | 9240
 | 2001-03-03 00:00:00 |  | 248.15 | 15920 | 165.24 | 2720
 | 2001-03-02 00:00:00 |  | 248.24 | 16400 | 165.07 | 3320
 | 2001-03-01 00:00:00 |  | 264.44 | 17648 | 164.24 | 7520
 | 2001-02-28 00:00:00 |  | 181.23 | 21200 | 120.65 | 4728
 | 2001-02-27 00:00:00 |  | 185.42 | 15344 | 116.58 | 2800
 | 2001-02-26 00:00:00 |  | 193.48 | 13840 | 132.88 | 4800
 | 2001-02-25 00:00:00 |  |  |  |  |  | 132.88 | 14400
 | 2001-02-24 00:00:00 |  | 177.7 | 16000 | 131.62 | 11200
 | 2001-02-23 00:00:00 |  | 179.36 | 17040 | 131.62 | 11200
 | 2001-02-22 00:00:00 |  | 229.75 | 23200 | 149.39 | 6448
 | 2001-02-21 00:00:00 |  | 236.72 | 25840 | 160.28 | 7840
 | 2001-02-20 00:00:00 |  | 262.61 | 9200 | 190 | 5200
 | 2001-02-19 00:00:00 |  | 262.12 | 13200 | 190.74 | 5400
 | 2001-02-18 00:00:00 |  |  |  |  |  | 261.52 | 23280
 | 2001-02-17 00:00:00 |  | 323.71 | 16720 | 264.62 | 8840
 | 2001-02-16 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-15 00:00:00 |  | 431.67 | 19680 | 296.75 | 12600
 | 2001-02-14 00:00:00 |  | 267.18 | 20320 | 202.45 | 6200
 | 2001-02-13 00:00:00 |  | 233.43 | 13520 | 159.16 | 7400
 | 2001-02-12 00:00:00 |  | 195.13 | 7760 | 159.51 | 6920
Spreadsheet: chris_stokley__4008__Book1
Sheet: Sheet1

BUS_ASSOC_ID | TRADE_INT | CHG_TYP_ID | STLMT_SUM_ID | STLMT_TYPE | DOLLARS_RECEIVED | ADJ_COMMENT | LCTN_ID | TRADE_HR | TRADE_MIN | TOTAL_LOAD_EXPORT | PRICE | ZONE_ID | REF_ID | Percentage | Actual | SumOfFormula | SumOfTOTAL_LOAD_EXPORT | Percent
1005 | 2001-04-20 00:00:00 | 480 |  | N | 3773.64 |  |  | 8 |  | -37.7364
1005 | 2001-04-20 00:00:00 | 480 |  | N | 4944.66 |  |  | 9 |  | -49.4466
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5311.44 |  |  | 10 |  | -53.1144
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5801.82 |  |  | 11 |  | -58.0182
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5829.84 |  |  | 12 |  | -58.2984
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5913.6 |  |  | 14 |  | -59.136
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5701.8 |  |  | 15 |  | -57.018
1005 | 2001-04-20 00:00:00 | 480 |  | N | 5775.12 |  |  | 16 |  | -57.7512
1005 | 2001-04-20 00:00:00 | 480 |  | N | 3397.924020176012 |  |  | 20 |  | -46.341
1005 | 2001-04-20 00:00:00 | 480 |  | N | 4795.14 |  |  | 21 |  | -47.9514
1005 | 2001-04-20 00:00:00 | 480 |  | N | 69.80501375367824 |  |  | 22 |  | -46.998
1005 | 2001-04-20 00:00:00 | 480 |  | N | 4478.16 |  |  | 23 |  | -44.7816
Spreadsheet: 771741d1646828323-how-i-can-convert-the-daily-data-i-have-to-hourly-data-example-
Sheet: Sheet1

Date | Precipitation |  | date | H | P
1999-01-01 00:00:00 | 0
1999-01-02 00:00:00 | 0
1999-01-03 00:00:00 | 0
1999-01-04 00:00:00 | 0
1999-01-05 00:00:00 | 0
1999-01-06 00:00:00 | 0
1999-01-07 00:00:00 | 54
1999-01-08 00:00:00 | 0
1999-01-09 00:00:00 | 0
1999-01-10 00:00:00 | 0
1999-01-11 00:00:00 | 0
1999-01-12 00:00:00 | 63
1999-01-13 00:00:00 | 0
1999-01-14 00:00:00 | 0
1999-01-15 00:00:00 | 0
1999-01-16 00:00:00 | 0
1999-01-17 00:00:00 | 0
1999-01-18 00:00:00 | 0
1999-01-19 00:00:00 | 0
Spreadsheet: 485148d1476731509-sum-an-index-cross-sum-with-text
Sheet: Sheet1

 | RANDOM TEXT WOOP WOOP
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 43 |  | Total Queue Call Time |  |  | 02h36
 |  |  | CAKE
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Internal Calls Made |  | 0 |  | Total Internal Call Time |  |  | 00:00
 | Agent  1132 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 21h26
 | [NAME] Received |  | 67 |  | Total Queue Call Time |  |  | 02h36
 | Direct Calls received |  | 5 |  | Total Direct Call Time |  |  | 01:59
 | Outbound Calls Made |  | 139 |  | Total Outbound Call Time |  |  | 02h46
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 68 |  | Total Queue Call Time |  |  | 10h00
 |  |  | Lemons
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
 | Agent  1177 - [NAME]
 |  |  |  | Total Logon Duration |  |  |  | 34h10
 | [NAME] Received |  | 32 |  | Total Queue Call Time |  |  | 10h00
 | Direct Calls received |  | 11 |  | Total Direct Call Time |  |  | 03:04
 | Outbound Calls Made |  | 199 |  | Total Outbound Call Time |  |  | 07h05
Spreadsheet: 27736d1221248468-seeking-to-average-numbers-in-single-column-broken-into-increments-of-5-age-of-respondees
Sheet: Sheet3

Age of Respondees
28
27
30
33
31
40
33
38
25
40
31
34
26
39
30
32
28
30
49
35
30
42
Spreadsheet: 793479d1661503592-countif-with-and-and-or-problem-hd
Sheet: Sheet1

A | B | C | 1 | 2 | 3 |  |  | So the candidates needs to score >2 in column A and then >2 in either columns B or C (to count in the total).
1 | 1 | 3 |  |  |  |  |  | So in the example below the total count would be 1 as only one candidate scored >2 in Column A and also >2 in Columns B or C
0 | 0 | 0 | 0 | 0 | 0
2 | 3 | 2 | 0 | 0 | 0
2 | 2 | 1 | 0 | 0 | 0
2 | 1 | 0 | 0 | 0 | 0
3 | 2 | 3 | 1 | 1 | 0 |  |  | Please try this formula:
0 | 1 | 1 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0 |  | 1
1 | 2 | 2 | 0 | 0 | 0
0 | 2 | 2 | 0 | 0 | 0
3 | 1 | 1 | 0 | 0 | 0 |  |  | The first formula counts if A > 2 and (B or C > 2)
0 | 1 | 1 | 0 | 0 | 0
2 | 1 | 0 | 0 | 0 | 0
2 | 2 | 3 | 0 | 0 | 0 |  | 2
1 | 0 | 1 | 0 | 0 | 0
2 | 3 | 2 | 0 | 0 | 0
3 | 1 | 2 | 0 | 1 | 0 |  |  | The second formula counts if A > 2 and the sum of B and C  >  2
1 | 1 | 0 | 0 | 0 | 0
2 | 3 | 0 | 0 | 0 | 0
2 | 3 | 1 | 0 | 0 | 0 |  | 3
2 | 2 | 0 | 0 | 0 | 0
0 | 1 | 2 | 0 | 0 | 0
3 | 2 | 3 | 1 | 1 | 0 |  |  | The third formula counts if A and B > 2
1 | 2 | 0 | 0 | 0 | 0
3 | 2 | 2 | 0 | 1 | 0
2 | 3 | 2 | 0 | 0 | 0
0 | 2 | 1 | 0 | 0 | 0
3 | 3 | 1 | 1 | 1 | 1
2 | 0 | 3 | 0 | 0 | 0
0 | 3 | 3 | 0 | 0 | 0
1 | 3 | 0 | 0 | 0 | 0
0 | 3 | 2 | 0 | 0 | 0
1 | 1 | 3 | 0 | 0 | 0
3 | 0 | 1 | 0 | 0 | 0
3 | 2 | 0 | 0 | 0 | 0
1 | 1 | 0 | 0 | 0 | 0
1 | 3 | 0 | 0 | 0 | 0
1 | 1 | 1 | 0 | 0 | 0
0 | 2 | 1 | 0 | 0 | 0
1 | 2 | 2 | 0 | 0 | 0
0 | 0 | 1 | 0 | 0 | 0
0 | 0 | 3 | 0 | 0 | 0
3 | 1 | 2 | 0 | 1 | 0
0 | 1 | 0 | 0 | 0 | 0
2 | 1 | 3 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0
1 | 2 | 1 | 0 | 0 | 0
0 | 0 | 3 | 0 | 0 | 0
2 | 0 | 0 | 0 | 0 | 0
0 | 2 | 2 | 0 | 0 | 0
1 | 2 | 1 | 0 | 0 | 0
0 | 3 | 1 | 0 | 0 | 0
0 | 0 | 3 | 0 | 0 | 0
2 | 2 | 0 | 0 | 0 | 0
1 | 0 | 1 | 0 | 0 | 0
2 | 2 | 1 | 0 | 0 | 0
1 | 0 | 1 | 0 | 0 | 0
2 | 3 | 3 | 0 | 0 | 0
0 | 0 | 3 | 0 | 0 | 0
2 | 3 | 2 | 0 | 0 | 0
1 | 0 | 1 | 0 | 0 | 0
2 | 0 | 2 | 0 | 0 | 0
1 | 3 | 3 | 0 | 0 | 0
2 | 0 | 3 | 0 | 0 | 0
0 | 0 | 1 | 0 | 0 | 0
0 | 2 | 1 | 0 | 0 | 0
3 | 3 | 0 | 1 | 1 | 1
0 | 3 | 0 | 0 | 0 | 0
0 | 3 | 2 | 0 | 0 | 0
0 | 2 | 0 | 0 | 0 | 0
3 | 3 | 1 | 1 | 1 | 1
0 | 1 | 3 | 0 | 0 | 0
1 | 2 | 1 | 0 | 0 | 0
1 | 2 | 0 | 0 | 0 | 0
3 | 0 | 2 | 0 | 0 | 0
3 | 1 | 1 | 0 | 0 | 0
2 | 2 | 2 | 0 | 0 | 0
1 | 1 | 3 | 0 | 0 | 0
1 | 1 | 3 | 0 | 0 | 0
0 | 2 | 2 | 0 | 0 | 0
1 | 1 | 2 | 0 | 0 | 0
3 | 0 | 1 | 0 | 0 | 0
2 | 2 | 1 | 0 | 0 | 0
2 | 3 | 1 | 0 | 0 | 0
2 | 1 | 1 | 0 | 0 | 0
3 | 1 | 3 | 1 | 1 | 0
1 | 1 | 0 | 0 | 0 | 0
3 | 2 | 3 | 1 | 1 | 0
1 | 1 | 1 | 0 | 0 | 0
2 | 2 | 3 | 0 | 0 | 0
1 | 3 | 3 | 0 | 0 | 0
2 | 2 | 3 | 0 | 0 | 0
1 | 1 | 3 | 0 | 0 | 0
0 | 2 | 0 | 0 | 0 | 0
1 | 3 | 1 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0
0 | 2 | 1 | 0 | 0 | 0
0 | 1 | 0 | 0 | 0 | 0
1 | 0 | 0 | 0 | 0 | 0
1 | 2 | 1 | 0 | 0 | 0
Spreadsheet: 691270d1597600511-function-more-activity-in-rows-and-pass-the-result-of-the-last-result-in-start-cell-query-for-function-1-ksaa_eone-
Sheet: ROWS

 | RESULT | Activity_1 | Date | Activity_2 | Date | Activity_3 | Date | Activity_4 | Date | Activity_5 | Date | Activity_6 | Date | Activity_7 | Date | Activity_8 | Date | Activity_9 | Date | Activity_10 | Date | Activity_11 | Date | Activity_12 | Date | Activity_13 | Date | Activity_14 | Date | [NAME] | Date | Activity_16 | Date | Activity_17 | Date | Activity_18 | Date | Activity_19 | Date | To Start | Blank | Filled
 |  | AB | 2020-02-01 00:00:00 | CD | 2020-02-02 00:00:00 |  |  | KI | 2020-02-04 00:00:00
Spreadsheet: 168734d1342552700-copy-across-multiple-rows-and-columns-the-data-to-one-column-removing-dupilicates-blank-15640
Sheet: Feb17-Feb23p

Pavilion
 | 2013-02-17 00:00:00 |  |  | Thru | 2013-02-23 00:00:00
 | SUN | MON | TUE | WED | THURS | FRI | SAT
 | 2013-02-17 00:00:00 | 2013-02-18 00:00:00 | 2013-02-19 00:00:00 | 2013-02-20 00:00:00 | 2013-02-21 00:00:00 | 2013-02-22 00:00:00 | 2013-02-23 00:00:00 |  |  |  | Blocks | Team | Hours
7:15AM |  |  |  |  |  |  |  | 7:15AM |  |  | 0 | 05 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 04 Flags | 0
8:15AM |  |  |  |  |  |  |  | 8:15AM |  |  | 0 | 03 [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 02 Flags | 0
9:15AM |  |  |  |  |  |  |  | 9:15AM |  |  | 0 | 01 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 00 Flags | 0
10:15AM |  |  |  |  |  |  |  | 10:15AM |  |  | 0 | 99 Flags | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 98 Flags | 0
11:15AM |  |  |  |  |  |  |  | 11:15AM |  |  | 0 | Midget A | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | Midget AA | 0
12:15PM |  |  |  |  |  |  |  | 12:15PM
1:15PM |  |  |  |  |  |  |  | 1:15PM
2:15PM |  |  |  |  |  |  |  | 2:15PM
3:15PM |  |  |  |  |  |  |  | 3:15PM
4:15PM |  |  |  |  |  |  |  | 4:15PM
5:15PM |  |  |  |  |  |  |  | 5:15PM
[NAME] |  |  |  |  |  |  |  | [NAME]
7:15PM |  |  |  |  |  |  |  | 7:15PM
8:15PM |  |  |  |  |  |  |  | 8:15PM
9:15PM |  |  |  |  |  |  |  | 9:15PM
10:15PM |  |  |  |  |  |  |  | 10:15PM
11:15PM |  |  |  |  |  |  |  | 11:15PM
 | Cancellations or Corrections
 | Date | Time | Customer | Operations Personal | Comments
Spreadsheet: 88750d1288613592-excel-2007-breaking-down-numbers-into-separate-columns-parse-number
Sheet: Sheet1

number up to 999,999,999.99 | 100 m | 10 m | 1 m | 100 thou | 10 thou | 1 thou | hundreds | tens | units | tenths | hundreths
98765432.16 | 0 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 1 | 6
198777777.56 | 1 | 9 | 8 | 7 | 7 | 7 | 7 | 7 | 7 | 5 | 6
999999999.99 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
134.01 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 3 | 4 | 0 | 1
1000 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 869511d1716096921-average-skipping-every-other-column-averege-column-skip-help
Sheet: Costs

 |  |  |  |  | 2024-05-16 00:00:00 |  | 2024-05-13 00:00:00 |  | 2024-05-09 00:00:00 |  | 2024-05-06 00:00:00 |  | 2024-05-02 00:00:00 |  | 2024-04-29 00:00:00 |  | 2024-04-25 00:00:00 |  | 2024-04-22 00:00:00 |  | 2024-04-18 00:00:00 |  | 2024-04-15 00:00:00 |  | 2024-04-11 00:00:00
Item Name | Product Number | Pack | Size | Unit | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost | Case Cost | Each Cost
Generic Item 1 | 123456 | 6 | 32 | oz
Generic Item 2 | 123457 | 4 | 1 | gal | 20.07 |  | 20.07 |  | 20.07 |  | 20.07 |  | 20.49 |  | 20.49 |  | 20.49 |  |  |  |  |  |  |  | 20.49
Generic Item 3 | 123458 | 12 | 32 | oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33.33
Generic Item 4 | 123459 | 12 | 32 | oz |  |  |  |  |  |  |  |  |  |  | 34.43 |  |  |  |  |  |  |  | 34.43
Generic Item 5 | 123460 | 6 | 32 | oz | 25.65 |  |  |  |  |  | 25.65
Generic Item 6 | 123461 | 6 | 2 | lbs |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74.71 |  |  |  | 74.71
Generic Item 7 | 123462 | 48 | 1 | ea
Generic Item 8 | 123463 | 12 | 1 | ea | 19.06 |  |  |  | 19.06 |  | 19.06 |  |  |  |  |  | 19.06
Generic Item 9 | 123464 | 12 | 1 | ea |  |  |  |  | 19.06 |  | 19.06
Generic Item 10 | 123465 | 12 | 1 | ea
Generic Item 11 | 123466 | 24 | 1 | ea |  |  |  |  |  |  |  |  | 13.45 |  |  |  |  |  |  |  | 13.45
Generic Item 12 | 123467 | 1 | 1 | cs | 59.91 |  |  |  | 59.92 |  | 59.92 |  |  |  |  |  | 57.98 |  | 57.98 |  |  |  |  |  | 57.7
Generic Item 13 | 123468 | 4 | 12 | pk |  |  |  |  |  |  | 66.28 |  | 67.35 |  | 50.61 |  | 55.23 |  | 47.6 |  |  |  |  |  | 56.13
Generic Item 14 | 123469 | 7 | 1 | ea | 18.3 |  | 18.3 |  | 18.3 |  |  |  |  |  |  |  |  |  | 18.3 |  | 18.3 |  | 18.3 |  | 18.3
Generic Item 15 | 123470 | 1 | 1 | cs |  |  | 13.98 |  |  |  |  |  |  |  | 21.32 |  |  |  |  |  |  |  |  |  | 26.01
Spreadsheet: 328915d1404135620-data-validation-dummy
Sheet: Sheet1

Brand | Model | Sub model
Samsung | Galaxy | Core 2
Samsung | Galaxy | S5 Sport
Samsung | Galaxy | TAB 3
Samsung | Galaxy | TAB 2
Samsung | Galaxy | TAB
LG | L65 | D280
LG | L55 | D270
LG | L20 | D150