tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698868d1602207894-looping-through-data-and-evaluate-with-dates-and-logic-samp1a
Sheet: report1602174991843

id |  | Available Date | Created Date |  |  | Type of Change | Count: | Count1 | Count2
1139582 |  | 2019-03-25 00:00:00 | 2019-03-26 00:00:00 |  |  | A | 2 | 2 | 0
1139582 |  | 2019-03-25 00:00:00 | 2019-03-26 00:00:00 |  |  | B | 2 | 2 | 0
1139583 |  | 2019-03-24 00:00:00 | 2019-04-01 00:00:00 |  |  | C | 2 | 2 | 0
1139583 |  | 2019-03-24 00:00:00 | 2019-04-01 00:00:00 |  |  | C | 2 | 2 | 0
1139621 |  | 2019-01-31 00:00:00 | 2019-02-13 00:00:00 |  |  | A | 2 | 2 | 0
1139621 |  | 2019-01-31 00:00:00 | 2019-02-13 00:00:00 |  |  | A | 2 | 2 | 0
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B | 2 | 0 | 0
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B | 2 | 0 | 0
1139621 |  | 2019-01-31 00:00:00 | 2019-01-29 00:00:00 |  |  | B | 2 | 0 | 0
1139631 |  | 2019-03-11 00:00:00 | 2019-03-11 00:00:00 |  |  | E | 0 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-02-06 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-29 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-31 00:00:00 |  |  | F | 1 | 0 | 0
1139736 |  | 2019-02-05 00:00:00 | 2019-01-31 00:00:00 |  |  | F | 1 | 0 | 0
1139855 |  | 2019-01-29 00:00:00 | 2019-02-22 00:00:00 |  |  | A | 3 | 2 | 1
1139855 |  | 2019-01-29 00:00:00 | 2019-03-06 00:00:00 |  |  | B | 3 | 2 | 1
1139855 |  | 2019-01-29 00:00:00 | 2019-03-06 00:00:00 |  |  | D | 3 | 2 | 1
1139855 |  | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 |  |  | D | 3 | 2 | 1
1139855 |  | 2019-01-29 00:00:00 | 2019-01-29 00:00:00 |  |  | D | 3 | 2 | 1
1140017 |  | 2019-02-13 00:00:00 | 2019-02-22 00:00:00 |  |  | D | 3 | 0 | 3
1140017 |  | 2019-02-13 00:00:00 | 2019-03-15 00:00:00 |  |  | D | 3 | 0 | 3
1140017 |  | 2019-02-13 00:00:00 | 2019-03-07 00:00:00 |  |  | D | 3 | 0 | 3
Spreadsheet: 00c44e93-e2fd-4a89-84f9-a325683ae3fb
Sheet: Q9 BILL

BILL |  |  | month | net worth |  | intrinsic
n | 180 |  | 0
P | 833216.6398906799 |  | 1
X | 10000 |  | 2
F |  |  | 3
rate | 0.01 |  | 4
(1 + rate)^n |  |  | 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
Spreadsheet: phillip_m_love__30635__adjustments in 0500 PL
Sheet: Retex 0001

Retex Inc.
Contract: various | 2000-01-01 00:00:00
 | CPR estimate | Actual Payment | [NAME] | UA 4 RATE
[NAME] | 577124
VALUE | 1268478.27
NET RATE |  |  |  | 2.158
Volume Variance:
 |  | =D8 (Volume Variance) * (B12-E12) CPR Price less UA 4 Rate
Rate Variance:
 |  | =(B8+D8) Actual [NAME] * (C12-B12) Actual Price less CPR Price
 | TOTAL IMPACT TO INCOME:
 |  | =Volume [NAME]
 |  | Check Figure = ((D10/D8) less E12 UA 4 Rate) * D8
CHECK FIGURE |  | ($1,526,969)/(446,480) LESS $1.947 (UA4 RATE) BY (446,480MMBTU)
Note:
$(60,498.28) credit does not appear to be denver
Does not look to be a problem similar to December - Deal 133309 does not cause that big of a variance, we need to
look at this deal because there could be a true up needed
Spreadsheet: 164580d1340812679-calculating-time-with-vlookup-new-kitchen-schedule
Sheet: Employee names

Production Kitchen |  |  | Toscana |  |  | Banquets
First | Last |  | First | Last |  | First | Last
[NAME] | Reffitt |  | [NAME] | Martin |  | [NAME] | Moore
Maria | [NAME] |  | Heather | Aders |  | [NAME] | [NAME]
Dustin | Fields |  | Sami | Atari |  | [NAME] | Black
Viveros | Gerardo |  | Ruben | Barrientos |  | [NAME] | [NAME]
Concepcion | Palafox |  | Brandi | Benda |  | [NAME] | Davenport
Eduardo | [NAME] |  | Lindsey | Cox |  | Rosemary | Head
Jeremy | Rayburn |  | Tyler | Dunk |  | [NAME] | Hiestand
[NAME] | Robertshaw |  | [NAME] | [NAME] |  | Paulina | Moraga
[NAME] | Sadler |  | [NAME] | Glaze |  | [NAME] | Sankari
Erick | [NAME] |  | [NAME] | [NAME] |  | [NAME] | Schultz
[NAME] | [NAME] |  | [NAME] | Lindley |  | Renesa | Scruggs
 |  |  | Haley | McPeake |  | [NAME] | Weisel
 |  |  | Dillon | Myers |  | Christian | Zachrich
 |  |  | Joaquin | Orozco
 |  |  | [NAME] | Penrod
 |  |  | Khiler | Slaybaugh
 |  |  | [NAME] | Whisler
Spreadsheet: geir_solberg__11251__5_16act
Sheet: EPEData

 | 37123.96041666667
 | NEWMAN 1 ,ECON, 48  , 68  , 39  , 83  , 20  ,1
 | NEWMAN 2 ,MANL, 37  , 77  , 37  , 82  ,  0  ,1
 | NEWMAN 3 ,ECON, 95  , 95  , 35  ,103  ,  0  ,1
 | NEWMN/GT1,MANL, 26  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,MANL, 25  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,UNAV,  0  ,100  , 61  ,107  ,  0  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,214  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 230 ,  360,  147, 388 ,  20 ,
 | COPPER   ,ECON, 35  , 69  , 15  , 69  , 36  ,1
 | RIOGRAN 6,MANL, 45  , 40  , 28  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 41  , 32  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,UNAV,  0  , 90  , 36  ,151  ,  0  ,1
 | RIOGRANDE,,  86 ,   72,   58,  97 ,   0 ,
 | PALOVERDE,MANL,574  ,574  ,574  ,600  ,  0  ,1
 | FOURCRNRS,MANL,104  ,104  ,104  ,104  ,  0  ,1
 | LAMBDA, 46.96,  694,  695,  166,    7,    0,22532,0
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 8729e23b-c19a-40b2-a897-e8a55dae20b9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7192 | 16392 | [NAME] | [NAME] | RSA | 6 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | [NAME]
7192 | 6131 | [NAME] | De Villiers | RSA | 1 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 01:57:56
7192 | 5669 | [NAME] | Eksteen | RSA | 2 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 01:58:56
7192 | 6137 | Erhard | Wolfaardt | RSA | 3 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | [NAME]
7192 | 15981 | Mehdi | Essadiq | MAR | 5 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:00:15
7192 | 10966 | [NAME] | Felgate | ZIM | 4 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 6 | [NAME]
7192 | 33941 | Travis | Johnston | RSA | 10 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 7 | 02:04:45
7192 | 30426 | [NAME] | Norton | RSA | 9 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
7192 | 12816 | Wikus | Weber | RSA | 7 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 490381d1479839855-find-then-fill-book2
Sheet: Sheet1

 | What I have |  |  |  | What I need
Tag_# | Ht_tall_woody | sp_tall_woody | Ht_tall_herb | sp_tall_herb | Ht_tall_woody | sp_tall_woody | Ht_tall_herb | sp_tall_herb
1 | 75 | ROMU |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  | 144.9 | SOAL6 | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
1 |  |  |  |  | 75 | ROMU | 144.9 | SOAL6
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  | 133.2 | EUPE | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 | 42.5 | AGPA |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
2 |  |  |  |  | 42.5 | AGPA | 133.2 | EUPE
3
3
3
3
3
3
3
3
3
3
3
3
3
3
3
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 | 24.5 | ANOD |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  | 37.8 | CEFO | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
4 |  |  |  |  | 24.5 | ANOD | 37.8 | CEFO
Spreadsheet: 216240d1361654816-identify-duplicates-and-non-duplicates-within-an-array-match-identifying-duplicate-values-within-a-range-bb-
Sheet: Sheet1

 |  |  | DUPLICATES "Y" VALUES WITHIN A RANGE
Y | 0
Y | 1
Y | 2
N | -
Y | 0
N | -
Y | 1
Y | 2
Y | 3
N | 4
N | 5
Y | 6
N | 7
Y | 8
Y | 9
Y | 10
Y | 1
N | 2
N | 3
Y | 4
N | 5
N | 6
N | 7
N | 8
N | 9
N | 10
N | 1
N | 2
N | 3
Y | 4
Y | 5
Y | 6
Y | 7
Y | 8
Y | 9
N | 10
N | 11
Y | 12
N | 13
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: BOA DGS40 RMS

RTA 3051  2012
 | % Passing Sieve |  |  |  |  |  |  | % Passing | Passing Specification |  | Deviation | % Retained | [NAME] |  | Deviation
Sieve mm | Brown 40mm R/B | Oversize 20/14 | cd | Pit Fines | * | * | * | Blend Result | Lower | Upper | Passing | Blend Result | Lower | Upper | Retained
26.5 | 98 | 85 | 100 | 100 | 100 | 100 | 100 | 93.2 | 75 | 95 | 0
19 | 91 | 58 | 100 | 100 | 100 | 99 | 100 | 79.6 | 64 | 90 | 0 | 13.60000000000001
13.2 | 79 | 27 | 100 | 100 | 100 | 89 | 90 | 62.4 | 70 | 90 | -7.600000000000001 | 17.2 | 6 | 18 | 0
9.5 | 68 | 4 | 100 | 100 | 100 | 75 | 72 | 48.8 | 42 | 78 | 0 | 13.6 | 7 | 17 | 0
6.7 | 55 | 1 | 100 | 100 | 100 | 59 | 57 | 42.4 | 34.66666666666666 | 68.66666666666667 |  |  | 10 | 21
4.75 | 43 | 0 | 97 | 100 | 84 | 45 | 46 | 36.9 | 27 | 64 | 0 | 11.9 | 13 | 25 | -1.100000000000001
2.36 | 22 | 0 | 60 | 100 | 17 | 26 | 30 | 24.8 | 20 | 50 | 0 | 12.1 | 7 | 19 | 0
0.425 | 8 | 0 | 16 | 65 | 9 | 8 | 8 | 11.3 | 10 | 23 | 0 | 13.5 | 14 | 30 | -0.5
0.075 | 5 | 0 | 7 | 35 | 2 | 3 | 4 | 6.2 | 4 | 12 | 0 | 5.100000000000001 | 6 | 13 | -0.8999999999999995
0.0135 | 4 | 0 | 1 | 17 | 0.1 | 1 | 2 | 3.4 | 2 | 7 | 0 | 2.8 | 3 | 8 | -0.1999999999999997
PI | 2 |  |  |  |  |  |  | 0.5663716814159292
Ratio | 40 | 40 | 10 | 10 | 0 | 0 | 0 | 100
Spreadsheet: 142037d1329594135-auto-populate-data-from-sheet-1-to-specific-places-in-multiple-other-worksheets-2012-fantasy-golf
Sheet: Colonial

 |  | WEEK 8 Crowne Plaza Invitational at Colonial
 |  | Total Earnings |  |  |  | Rankings Through Week 7 | Total
 | [NAME] | 0 |  | 2 |  | [NAME]
 | [NAME] | 5000 |  | 1 |  | [NAME]
 | [NAME] | 0 |  | 3 |  | [NAME]
 |  | 0 |  | 4 |  | 0
 |  | 0 |  | 5 |  | 0
 |  | 0 |  | 6 |  | 0
 |  | 0 |  | 7 |  | 0
 |  | 0 |  | 8 |  | 0
 |  | 0 |  | 9 |  | 0
 |  | 0 |  | 10 |  | 0
 |  | 0 |  | 11 |  | 0
 |  | 0 |  | 12 |  | 0
 |  | 0 |  | 13 |  | 0
 |  | Colonial |  | YTD
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 5000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 | Total | 0 |  | 0
Spreadsheet: 680496d1591048204-lean-formula-burn
Sheet: Sheet1

 |  | No burn period
 |  |  |  | Period
 | Item | Duration | Period Burn | 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
 | A | 20 |  | 0.05 | 0.1 | 0.15 | 0.2 | 0.25 |  |  | 0.3 |  | 0.35 | 0.4 | 0.45 |  |  | 0.5 | 0.55 |  |  |  |  |  | 0.6 | 0.65 |  |  |  | 0.7 | 0.75 | 0.8 |  | 0.85 | 0.9 | 0.95 | 1
 | B | 15
 | C | 4
 | D | 28
 | E | 31
 | F | 8
 | G | 37
 | H | 27
 | I | 24
 | J | 17
 | K | 25
Spreadsheet: 885293d1734771247-convert-a-mmult-to-byrow-lambda-playedbefore-countpairs-lambda-function-step-by-step-
Sheet: Search

 | From | To
Count |  |  |  | Sort by | Order
 |  |  |  | Count
Player 1 | Blandford
Player 2
Player 1 | Player 2 | Count
 | Allgeier | 0
Blandford | Byrd | 0
Blandford | Dietz | 0
Blandford | Fackler | 0
Blandford | Graven | 0
Blandford | Hagan | 0
Blandford | [NAME] | 0
Blandford | [NAME] | 0
Blandford | [NAME] | 0
Blandford | [NAME] | 0
Blandford | Vogt | 0
Blandford | Wachtel | 0
Blandford | Wick | 0
Blandford | [NAME] | 1
Blandford | [NAME] | 1
Blandford | Barnes | 1
Blandford | Dolwick | 1
Blandford | Epley | 1
Blandford | [NAME] | 1
Blandford | Jacobs | 1
Blandford | Jarvi | 1
Blandford | [NAME] | 1
Blandford | [NAME] | 1
Blandford | [NAME] | 1
Blandford | Nalley | 1
Blandford | Pottinger | 1
Blandford | Prentice | 1
Blandford | [NAME] | 1
Blandford | Usher | 1
Blandford | Walsh | 1
Blandford | Wigley | 1
Blandford | Yaden | 1
Blandford | Abell | 2
Blandford | Byrnes | 2
Blandford | Dieruf | 2
Blandford | [NAME] | 2
Blandford | Garrett | 2
Blandford | Hennessey | 2
Blandford | Hermann | 2
Blandford | Kokinda | 2
Blandford | McFarland | 2
Blandford | Morehead | 2
Blandford | Nunn | 2
Blandford | Scales | 2
Blandford | Thompson | 2
Blandford | Wasson | 2
Blandford | Woock | 2
Blandford | Cataldo | 3
Blandford | Clem | 3
Blandford | Open | 3
Blandford | Pribble | 3
Blandford | Ruffra | 3
Blandford | O'Neil | 4
Blandford | [NAME] | 4
Spreadsheet: 0c5c6a70-588b-4c86-900c-663948206e03
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
 | 8731.0 Building Approvals, Australia
 | TABLE 35. Value of Building Approved - Tasmania
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Tasmania ;  Total residential building ;  New ; |  |  | Original | A420335T | 1970-07-01 00:00:00 | 2009-04-01 00:00:00 | 466 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420344V | 1973-07-01 00:00:00 | 2009-04-01 00:00:00 | 430 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420356C | 1973-07-01 00:00:00 | 2009-04-01 00:00:00 | 430 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421038R | 1970-07-01 00:00:00 | 2009-04-01 00:00:00 | 466 | $'000 | FLOW | Month | 1
Value of Approval ;  Tasmania ;  Total building ;  Total (Type of work) ; |  |  | Original | A422668A | 1973-07-01 00:00:00 | 2009-04-01 00:00:00 | 430 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 86586d1286531470-start-to-end-date-macro-sampledata
Sheet: Sheet1

Date | Leo | [NAME] | [NAME]
2010-10-01 00:00:00 | Day Duties - Weekend | OFF | OFF
2010-10-02 00:00:00 | OFF | Day Duties - Weekend | OFF
2010-10-03 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
2010-10-04 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
2010-10-05 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
2010-10-06 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
2010-10-07 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
2010-10-08 00:00:00 | OFF | Day Duties - Weekend | OFF
2010-10-09 00:00:00 | OFF | OFF | Day Duties - Weekend
2010-10-10 00:00:00 | Regular Shift | Regular Shift | Day Duties - Weekday
2010-10-11 00:00:00 | Regular Shift | Regular Shift | Day Duties - Weekday
2010-10-12 00:00:00 | Regular Shift | Regular Shift | Day Duties - Weekday
2010-10-13 00:00:00 | Regular Shift | Regular Shift | Day Duties - Weekday
2010-10-14 00:00:00 | Regular Shift | Regular Shift | Day Duties - Weekday
2010-10-15 00:00:00 | OFF | OFF | Day Duties - Weekend
2010-10-16 00:00:00 | OFF | OFF | OFF
2010-10-17 00:00:00 | Regular Shift | Regular Shift | Regular Shift
2010-10-18 00:00:00 | Regular Shift | Regular Shift | Regular Shift
2010-10-19 00:00:00 | Regular Shift | Regular Shift | Regular Shift
2010-10-20 00:00:00 | Regular Shift | Regular Shift | Regular Shift
2010-10-21 00:00:00 | Regular Shift | Regular Shift | Regular Shift
2010-10-22 00:00:00 | OFF | OFF | OFF
2010-10-23 00:00:00 | Day Duties - Weekend | OFF | OFF
2010-10-24 00:00:00 | Day Duties - Weekday | Regular Shift | Regular Shift
2010-10-25 00:00:00 | Day Duties - Weekday | Regular Shift | Regular Shift
2010-10-26 00:00:00 | Day Duties - Weekday | Regular Shift | Regular Shift
2010-10-27 00:00:00 | Day Duties - Weekday | Regular Shift | Regular Shift
2010-10-28 00:00:00 | Day Duties - Weekday | Regular Shift | Regular Shift
2010-10-29 00:00:00 | Day Duties - Weekend | OFF | OFF
2010-10-30 00:00:00 | OFF | Day Duties - Weekend | OFF
2010-10-31 00:00:00 | Regular Shift | Day Duties - Weekday | Regular Shift
Macro results will be
StartDate | EndDate | StaffName | Shifts
2010-10-01 00:00:00 | 2010-10-01 00:00:00 | Leo | Day Duties - Weekend
2010-10-02 00:00:00 | 2010-10-02 00:00:00 | Leo | OFF
2010-10-03 00:00:00 | 2010-10-07 00:00:00 | Leo | Regular Shift
2010-10-08 00:00:00 | 2010-10-09 00:00:00 | Leo | OFF
2010-10-17 00:00:00 | 2010-10-21 00:00:00 | Leo | Regular Shift
2010-10-01 00:00:00 | 2010-10-01 00:00:00 | [NAME] | OFF
2010-10-02 00:00:00 | 2010-10-02 00:00:00 | [NAME] | Day Duties - Weekend
2010-10-03 00:00:00 | 2010-10-07 00:00:00 | [NAME] | Day Duties - Weekday
Spreadsheet: 96a13fac-3370-42c3-a49d-a59f415fdd95
Sheet: Aspect Ratios and Screen Sizes

Common Aspect Ratios
16x9 (1.78:1) |  |  |  |  | 2.35:1 |  |  |  |  | 1.85:1 |  |  |  |  | 2.40:1 |  |  |  |  | 4x3 (1.33:1)
[NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area
16 | 9 |  |  |  | 2.35 | 1 |  |  |  | 1.85 | 1 |  |  |  | 2.4 | 1 |  |  |  | 4 | 3
Constant Image Area Aspect Ratios |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Create Your Own
2.10:1 |  |  |  |  | 2.05:1 |  |  |  |  | 2.0:1 |  |  |  |  | ?
[NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area |  | [NAME] | Height | Diagonal | Area
2.1 | 1 |  |  |  | 2.05 | 1 |  |  |  | 2 | 1
Determine an Aspect [NAME]
Image Width
Image Height
Aspect [NAME]
Spreadsheet: 212810d1360253824-return-only-non-blank-list-of-ingredients-from-master-list-ingredients-populate
Sheet: Sheet1

 | MASTER INVENTORY LIST
 | INGREDIENTS | UNIT PRICE | RECEIPE 1 | RECEIPE 2 | RECEIPE 3 | RECEIPE 4 |  |  | SEARCH BY RECEIPE: | RECEIPE 3
 | ITEM 1 | 5 | 1 | 1 |  | 1
 | ITEM 2 | 4 |  | 4 | 1 | 2
 | ITEM 3 | 3 | 1 | 1 | 1 | 1 |  |  | REQUIRED RECEIPE INGREDIENTS
 | ITEM 4 | 2 | 2 |  | 2 | 1 |  |  | INGREDIENTS | QTY | UNIT PRICE | EXTENDED PRICE
 | ITEM 5 | 1 | 1 |  | 1 |  |  |  | ITEM 2 | 1 | 4
 |  |  |  |  |  |  |  |  | ITEM 3 | 1 | 3
 |  |  |  |  |  |  |  |  | ITEM 4 | 2 | 2
 |  |  |  |  |  |  |  |  | ITEM 5 | 1 | 1
 |  |  | AUTOMATICALLY POPULATE LIST OF INGREDIENTS
 |  |  | RETURNING ONLY NON-BLANK INGREDIENTS, BASED
 |  |  | SOLELY OFF THE SEARCH BOX RECEIPE INPUT