tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 466378d1466162509-i-would-just-like-to-add-two-more-players-sport_tournament_16_teams
Sheet: GroupB

GROUP B
 |  |  |  |  |  |  | Table |  |  |  |  |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS | rank
Team name | Bonus/penalty points
team1 |  |  |  |  |  |  |  | GP | W | D | L | GF | GA | [NAME] | PTS
team2
team3
team4
[NAME]
[NAME]
team7
team8
team9
team10
team11
team12
team13
team14
team15
team16
ROUND 1
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
 |  |  | :
ROUND 2
ROUND 3
ROUND 4
Spreadsheet: 492476d1481115053-spreadsheet-to-automatically-list-weather-extreme-dates-december-2016
Sheet: Notes

[NAME] temp |  | Assigned to previous day (09-09) |  |  |  |  |  | [NAME] at OT |  | Either mean vector wind direction or direction at 09
Min temp |  | Assigned to current day (09-09)
Rain |  | Assigned to previous day (09-09)
Mean wind/ [NAME] mean/ [NAME] gust |  | 00-24
When recording obs at 09/00
For the day starting at 09/00, DO NOT use the min/[NAME] temp shown as this is for the day ending at 09/00 - instead use the min/[NAME] shown for the 0910/0010 reading.
When confirming extremes
Export data to cover time period |  |  |  |  |  |  |  |  |  | Things to do
Open text file and copy in to Excel
Create [NAME]/min/ tot formula |  |  |  |  |  |  |  |  |  | Adjust wind speed - only mean or [NAME] mean not gust?
Check formula is looking at correct cells
Find extreme against time occurred
 |  |  |  |  |  |  |  |  |  | Met Office Standard Mean does not show until 09-09 obs mean is reported.
Spreadsheet: 681664d1591692961-calculate-overlapping-date-range-and-amount-of-fte-k001_example-dates-fte-table-rw001-
Sheet: Sheet1

 | name | start | end | amount of fte | contract fte
 | Tess | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 | 0.5 | 0.9
 | Mark | 2020-06-01 00:00:00 | 2020-12-31 00:00:00 | 1 | 1
 | Tess | 2020-07-01 00:00:00 | 2020-07-30 00:00:00 | 0.3 | 0.9
 | [NAME] | 2020-08-01 00:00:00 | 2021-01-01 00:00:00 | 0.8 | 1
 | Mark | 2020-05-01 00:00:00 | 2020-10-05 00:00:00 | 0.9 | 1
 | [NAME] | 2020-01-01 00:00:00 | 2020-06-26 00:00:00 | 0.9 | 1
 | [NAME] | 2020-01-01 00:00:00 | 2020-06-26 00:00:00 | 0.1 | 1
 | [NAME] | 2020-06-29 00:00:00 | 2020-07-31 00:00:00 | 0.5 | 1
 | [NAME] | 2020-06-29 00:00:00 | 2020-07-31 00:00:00 | 0.5 | 1
 | [NAME] | 2020-08-01 00:00:00 | 2021-12-31 00:00:00 | 0.5 | 1
 | [NAME] | 2020-08-01 00:00:00 | 2022-07-15 00:00:00 | 0.5 | 1
 | Mark | 2021-01-01 00:00:00 | 2022-07-15 00:00:00 | 0.1 | 1
Spreadsheet: 787367d1657743812-determining-age-but-have-the-cell-show-as-blank-if-no-birthdate-ages
Sheet: Sheet1

BirthDate | AGE
1944-12-12 00:00:00
1941-12-12 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
1956-06-12 00:00:00
1944-05-19 00:00:00
1900-10-10 00:00:00
1950-01-04 00:00:00
1929-07-03 00:00:00
1939-05-10 00:00:00
1947-04-11 00:00:00
1943-10-08 00:00:00
1950-04-08 00:00:00
1948-03-10 00:00:00
1943-10-18 00:00:00
1928-06-07 00:00:00
1900-01-01 00:00:00
1900-01-01 00:00:00
1954-05-07 00:00:00
1900-01-01 00:00:00
1930-09-25 00:00:00
1947-08-27 00:00:00
1951-08-22 00:00:00
1955-03-08 00:00:00
1957-05-12 00:00:00
1936-05-26 00:00:00
Spreadsheet: 270161d1381407025-display-values-that-are-missing-from-a-spreadsheet-modified-floorplan
Sheet: Floorplan Test

A
 |  | 137 | 509 | Q26 | 501 | 516 | 32 | 123 | 500
 |  | 35 | Q112 | 1 | 546 | 173 | 103 | 167 | Jb177
 |  | 216 | Q49 | JB936 | 545 | 112 | 192 | 514 | Jb938
B |  |  |  | 81 |  | 135 | 141 |  | 115
 |  | 156 | 190 | 70 | 211 | 86 | 87 | [NAME] | 175
 |  | 538 | 548 | 531 | 78 | 7 | 199 | 191 | 518
 |  | 54 | 117 | 519 | 218 | 97 | 525 | 249 | 210
C |  | 43 | 29 | Q120 | 2 |  | 72 |  | 226
 |  | 240 | Q115 | 187 | 66 | 158 | 530 | 208 | 67
 |  | JB742 | 200 | 68 | 82 | 146 | 143 | 522 | 228
 |  | 34 | 246 | 26 | 185 | 184 | 170 | 177 | 101
D |  |  | 553 | 121 | 64 | 44 |  | 40 | 541
 |  | 25 | 193 | 110 | 178 | 142 | 39 | [NAME] | 229
 |  | 57 | Q48 | 58 | 126 | 195 | 521 | 23 | 69
 |  | Q73 | 102 | 37 | 508 | 159 | 165 | 109 | 30
E |  |  | 234 | 14 | 75 | 62 | 16 | 243 | 221
 |  | 28 | JB957 | 118 | 145 | 172 | JB889 | 552 | 65
 |  | 152 | 213 | 547 | 61 | 206 | 59 | 50 | 22
 |  | 144 | 512 | 48 | 85 | 147 | 128 | 46 | 503
F |  | 140 | 119 | 247 | 550 | 139 | 183 | 108 | 549
 |  | 202 | 31 | 524 | 155 | 124 | 544 | 186 | 507
 |  | 114 | 179 | [NAME] | 227 | 107 | 506 | 63 | 24
 |  | 250 | 169 | 245 | 168 | 19 | 53 | 104 | 160
G |  | 150 | 223 | Q86 | 90 | 27 | 21 | 182 | 523
 |  | [NAME] | [NAME] | Q020 | 181 | 154 | 151 | 127 | 215
 |  | Q012 | Q84 | Q015 | 116 | 217 | 222 | Q85 | 105
 |  | [NAME] | Q017 | 94 | 45 | 203 | 180 | 83 | 241
H |  | [NAME] | Q004 | 533 | PILLAR | 100 |  |  | 239
 |  | 515 | 122 | 9 |  | 98 |  |  | 148
 |  | 18 | 220 | 13 |  | 73 |  |  | 113
 |  | 20 | 504 | 91 |  | 4 |  |  | jb223
I |  | 536 | 198 | 138 | 3 | 502
 |  | 197 | 77 | 99 | 196 | 204
 |  | JB762 | 225 | 528 | 163 | 111
 |  | Q113 | 529 | 510 | 6 | 188
J |  | 136 | 207 | 235 | 212 | 17
 |  | 120 | 84 | 33 | 540 | 47
 |  | 238 | 38 | 55 | 174 | 219
 |  | 542 | 12 | 236 | 237 | 513
K |  | 153 | 551 | 132 | 41
 |  | 176 | 10 | 532 | 244
 |  | 224 | 543 | 242 | 92
 | 230 | 539 | 171 | 526 | 248
L |  | 80 | 93 | 205 | 106
 |  | 71 | 42 | 76 | 74
 |  | 505 | 149 | 231 | 161
 | 166 | 214 | 527 | 201 | 194
Spreadsheet: 13941694-3a40-4ebe-b212-4352ac55d169
Sheet: Sheet1

Table 10--U.S. oilseed meal prices | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Marketing | Soybean | Cottonseed | Sunflowerseed | Peanut | Canola | Linseed
year | meal 2 | meal 3 | meal 4 | meal 5 | meal 6 | meal 7
 | $/Short ton
2001/02 | 167.72 | 136.16 | 87.27 | 112.32 | 143.33 | 121.29
2002/03 | 181.58 | 146.12 | 105 | 128.35 | 144.06 | 122.91
2003/04 | 256.05 | 183.47 | 111.14 | 177.56 | 188.45 | 159.25
2004/05 | 182.9 | 124.04 | 85.5 | 118.34 | 139.75 | 115.55
2005/06 | 174.1658333333333 | 144.2716666666667 | 77.46400000000001 | 106.9781818181818 | 140.5183333333333 | 115.53
2006/07 | 205.44 | 150.36 | 104.88 | 100 | 173.5 | 133.01
2007/08 | 335.94 | 253.81 | 172.81 |  | 251.32 | 228.81
2008/09 | 331.17 | 255.23 | 152.46 |  | 248.82 | 220.89
2009/10 | 311.27 | 220.9 | 151.04 |  | 224.92 | 209.23
2010/11 | 345.52 | 273.84 | 219.72 |  | 263.63 | 240.65
2011/12 | 393.53 | 275.13 | 246.75 |  | 307.59 | 265.68
2012/131 | 430-460 | 320-350 | 240-270 |  | 310-340 | 275-305
2011/12
October | 301.45 | 255.63 | 232.5 |  | 238.7 | 243.75
November | 290.37 | 240.5 | 224 |  | 235.2 | 239
December | 281.65 | 220.63 | 225.63 |  |  | 221.25
January | 310.65 | 213 | 223.5 |  | 253.98 | 209
February | 330.37 | 190 | 191.88 |  | 257.63 | 193.75
March | 365.95 | 225 | 191.88 |  | 277.83 | 216.25
April | 394.29 | 240.63 | 211.25 |  | 313.38 | 256.25
May | 415.17 | 270 | 230.5 |  | 333.69 | 279
June | 422.59 | 294.38 | 226.88 |  | 335.26 | 287.5
July | 515.82 | 350.5 | 300.5 |  | 378.86 | 343
August | 564.69 | 407.5 | 348.13 |  | 388.13 | 358.75
September | 529.37 | 393.75 | 354.38 |  | 370.79 | 340.63
2012/13
October | 488.46 | 343 | 287 |  | 354.49 | 334
November | 465.64 | 376.88 | 269.38 |  | 334.46 | 297.5
December1 | 459.4 | 345 | 266.67 |  | 349.55 | 335.83
1 Preliminary.  2 High-protein Decatur, IL.  3 41-percent Memphis.  4 34-percent North Dakota-Minnesota.
5 50-percent Southeast mills.  6 36-percent Pacific Northwest. 7 34-percent Minneapolis.
NA= Not available.
Source: USDA, Agricultural Marketing Service, Monthly Feedstuff Prices.
Last update: | 2013-01-15 11:19:09.050000
Spreadsheet: 881837d1730055520-worksheet-with-month-drop-down-sheet-changes-based-on-month-help-bills-jot
Sheet: June

Monthly Bills Jot
From [NAME] | mortgage | 397.5
 | bills | 268.3
 | pot | 550
 | receipts | 64.74
 | owed | 85.83
Back to jack | credit | 0
Mine | To Bills | 0
 | Credit Card ex
 | Receipts | 0
 | To Pot | 0 |  |  |  |  |  | 420 | receipts |  |  | 100.57
 | Pay credits |  |  |  |  |  |  | 65.83 | holiday savings
 | Santander
 |  |  |  |  |  |  |  | 500 next month
£50 in pot | + | 0
minus |  | 0
 |  | 0
50 to add to bills from jack
Spreadsheet: 536583d1504595545-excel-template-for-monthly-work-recording-pay-by-day-v3
Sheet: Daily Run sheet

Date | Driver | Status | Helper | Status
2017-08-01 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-01 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-02 00:00:00 | [NAME] | Sick | [NAME] | Normal
2017-08-02 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-03 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-03 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-04 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-04 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-05 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-05 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-05 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-06 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-06 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-06 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-07 00:00:00 | [NAME] | Holiday | [NAME] | Normal
2017-08-07 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-08 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-08 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-09 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-09 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-10 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-10 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-11 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-11 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-12 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-12 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-13 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-13 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-14 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-14 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-15 00:00:00 | [NAME] | Normal | [NAME] | Normal
2017-08-15 00:00:00 | [NAME] | Normal | [NAME] | Normal
Spreadsheet: 784408d1655724199-data-extracting-sorting-and-organizing-drgkt-v1
Sheet: Sheet1

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
BEGIN:VCARD | N:Smoe;Joe;Dave;Mr.;Sr. | FN:Mr. [NAME], Sr. | TEL;CELL:+[PHONE] | TEL;WORK;FAX:(201) 555-2222 | TEL;HOME;FAX:555 3333 | TEL;PAGER:[PHONE] | END:VCARD
BEGIN:VCARD | N:Doe;Jane;Marie;; | FN:Ms. [NAME] Doe\, | NICKNAME:MAYJO | TEL;CELL:+[PHONE] | TEL;HOME:(201) 555 6666 | TEL;WORK:[PHONE] | TEL;VOICE:5558888 | TEL;WORK;FAX:555-9999 | TEL;HOME;FAX:[PHONE] | TEL;PAGER:+[PHONE] | TEL;CUSTOM:666 1111 | TEL;PREF:6662222 | TEL;ANOTHERCUSTOM:[PHONE] | TEL;CELL-2:16664444 | [NAME] | ORG:MICROSOFT | TITLE:CEO | END:VCARD
Spreadsheet: 3621fda4-a3d9-455d-b718-267110c1da9a
Sheet: Table 1.8

Monthly Statistical Bulletin
1.8 Jobseekers receiving allowances
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Newstart Allowance and Youth Allowance (other) recipients (a) – '000
July | 427.537 | 338.799 | 314.636 | 339.267 | 411.513
August | 399.572 | 319.562 | 303.978 | 330.774 | 393.998
September | 387.861 | 310.168 | 299.463 | 330.406 | 384.521
October | 375.957 | 302.88 | 297.779 | 332.902 | 383.962
November | 366.179 | 297.995 | 296.112 | 335.427
December | 377.862 | 318.512 | 317.239 | 349.782
January | 389.037 | 336.31 | 335.704 | 404.566
February | 380.181 | 340.795 | 339.475 | 405.688
March | 364.938 | 324.928 | 332.933 | 385.105
April | 354.598 | 319.681 | 332.39 | 394.889
May | 346.173 | 317.719 | 330.686 | 400.5
June | 340.825 | 315.567 | 332.022 | 406.759
Annual average | 375.8933333333333 | 320.243 | 319.3680833333333 | 368.0054166666667
Annual change – per cent
July | 45.47963291264151 | -20.75563050683333 | -7.131957296213966 | .. | 21.29473246734872
August | 38.74461354695113 | -20.02392560039242 | -4.876674948836221 | .. | 19.11395696155078
September | 36.66509281053122 | -20.03114517829841 | -3.451355394495881 | .. | 16.37833453387651
October | 32.08992980163163 | -19.43759525690438 | -1.684165346011621 | .. | 15.33784717424347
November | 27.07577093122521 | -18.6204014976282 | -0.6318897968086651 | ..
December | 19.05139983742604 | -15.70679242686484 | -0.3996709700105567 | ..
January | 10.76764070280935 | -13.55320959188971 | -0.1801908953049254 | ..
February | 3.33111367805938 | -10.3598023046917 | -0.3873296263149381 | ..
March | -1.430712925574304 | -10.96350612980835 | 2.463622710261964 | ..
April | -6.473563994492824 | -9.846925250565437 | 3.975525602084579 | ..
May | -11.60193765688561 | -8.219589627151743 | 4.081279369505753 | ..
June | -15.95110330745632 | -7.410841340864074 | 5.214423561399 | ..
Annual average | 12.16550300063209 | -14.80482051645856 | -0.2732039940503461 | 15.22924045060859
(a) Includes jobseekers receiving Youth Allowance (other).
Source: Department of Social Services, Labour market and related payments: |  |  |  |  |  |  |  | Update
a monthly profile | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx | http://www.deewr.gov.au/Employment/LMI/Pages/LMRP.aspx |  |  | 18th December 2013
Spreadsheet: sara_shackleton__36483__New England Power Company
Sheet: Master

POWER MASTER AGREEMENT INFORMATION SHEET
 |  | LEGAL CONTACT: | [NAME], 36389 or [NAME], 31794
DATE: |  | EPMI CONTACT: | [NAME], (978) 449-9936
COUNTERPARTY: | New England Power Company | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
 |  | S&P RATING: | A+ (long-term credit rating)
ENTITY TYPE: | Electric Utility | MOODY'S RATING: | Aa1 (senior unsecured)
 |  | FITCH RATING:
TYPE OF AGREEMENT:
Bilateral (Purch & Sale) | X | Power Marketing
Unilateral - EPMI Purch only |  | Industrial Producer - EPMI Purch only
Unilateral - EPMI Sale only |  | SO2 Allowances
Transaction Specific
TRANSACTION TENOR LIMITS | open
COVER PROVISIONS
(Failure to Deliver/Receive) | X
STANDARD TRIGGER EVENTS
Non-Payment | X
Representations | X
Other Covenants | X
Bankruptcy | X
TERMS SPECIFIC TO: | COUNTERPARTY | EPMI
COLLATERAL THRESHOLD | 20000000 | 20000000
Applies to [NAME] to Market only
Applies to MTM and [NAME] | X | X
Collateral Multiple | 250000 | 250000
COLLATERAL THRESHOLD TYPE
In a form acceptable...
Cash | X | X
US Treasuries
Letter of Credit | X | X
ADDITIONAL TRIGGER EVENTS
Cross Default 3rd Party Debt: |  | Enron Corp.
-Counterparty | 100000000
-Guarantor |  | 100000000
Material Adverse Change:
-Counterparty | X
-Guarantor |  | X
Non-Specific
-Bilateral
-Unilateral
Debt Ratings Change
-Below S&P or Moody's | BBB-/Baa3 | BBB-/Baa3 | to apply to S&P/Moody's
-Type of debt | Long-Term Credit Rating/Senior Unsecured | Senior Unsecured/Senior Unsecured
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net Worth
-Fixed Charge Coverage
-Interest Coverage
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
Ownership Change
-Less than 51% owned by:
COLLATERAL TYPE
In a form and amount acceptable
to non-defaulting party | X | X
Other
GUARANTOR BREACH
GUARANTOR (RATING) |  | Enron Corp. (BBB+/Baa1)
$ LIMIT |  | 20000000
Incorporation State: |  | OR
FINANCIAL STATEMENTS
-Counterparty | X
-Guarantor |  | X
-Parent |  | X
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | 3-0554
Spreadsheet: 216597d1361819256-if-and-vlookup-problem-level-3-tracking-for-anita-protected
Sheet: Unit 1M

 |  | P1 | P2 | P3 | P4 | P5 | P6 | M1 | M2 | M3 | D1 | D2 | Final Grade | Final Points Value
X | Completed
A | Amendments
Spreadsheet: 688989d1596051935-using-min-max-and-countif-on-ranges-populated-by-formulas-tracer-example-minifs-with-data-and-formulas-change-from-text-to-number
Sheet: Report

Lot Code | Date of Production | Time of Production | No. of Totes | No. of Cartons | Month of Production | BBE/Month
7201D
7201A
7190A
7200A
7200B
Spreadsheet: 600804d1543957445-index-match-column-and-row-vertical-horizontal-match-equal-or-greater-team-score-results
Sheet: Sheet1

Month: | 4 | 12 | 24 | 36 | 48 | 60 | 72
Team 1 | 0 | 1 | 1 | 2 | 2 | 2 | 4
Team 2 | 1 | 4 | 6 | 8 | 10 | 12 | 12
Team 3 | 2 | 2 | 2 | 4 | 4 | 6 | 6
Team 4 | 0 | 0 | 0 | 1 | 3 | 3 | 4
Team 5 | 0 | 0 | 4 | 4 | 4 | 8 | 8
Examples of desired results:
 |  |  |  |  |  | Name: | Team 2
Name: | Team 1 |  | Name: | Team 3 |  | Month: | 5
Month: | 4 |  | Month: | 49 |  | Result:
Result: | 0 |  | Result: | 6 |  | Desired result: | 4
Name: | Team 2 |  | Name: | Team 2
Month: | 15 |  | Month: | 48
Result: | 6 |  | Result: | 10
Name: | Team 4 |  | Name: | Team 5
Month: | 47 |  | Month: | 13
Result: | 3 |  | Result: | 4
Name: | Team 5 |  | Name: | Team 2
Month: | 60 |  | Month: | 49
Result: | 8 |  | Result: | 12
Spreadsheet: 536a5b24-6672-45e4-a9d2-3eb4667d0f45
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2873 | 6956 | Adelaide | Cappellini | ITA | 128 | 00:13:18 | 00:00:44 | 00:40:28 | 00:01:22 | 00:30:06 | 1 | 01:25:58
2873 | 15578 | [NAME] | Kerr | USA | 129 | 00:15:07 | 00:01:04 | 00:41:40 | 00:02:09 | 00:32:50 | 2 | 01:32:50
Spreadsheet: 132909d1324027811-looking-for-a-value-and-returning-its-position-example
Sheet: Sheet1

 | 1 | 2 | 3 | 4 |  |  | Y | 4;1
1 | P | J | R | Y |  |  | M | 2;4
2 | T | K | F | H |  |  | N | 4;3
3 | G | L | V | N
4 | Q | M | G | Z
Spreadsheet: 31365d1227186098-finding-values-in-rows-column-and-liner-interpolation-between-them-example
Sheet: Sheet1

A | 1
B | 1.25
A/B | 1 | 1.5 | 2
1 | 0.2342 | 0.2786 | 0.3078
1.5 | 0.1438 | 0.183 | 0.2098
2 | 0.0939 | 0.1279 | 0.1457
3 | 0.0473 | 0.0672 | 0.0823
 | 1 | 1.5
1 | 0.2342 | 0.2786 |  | 1 | 0.2564
1.5 | 0.1438 | 0.183 |  | 1.5 | 0.1634 |  | 0.2564
Spreadsheet: 145249d1331430019-array-of-checked-entries-datavalidation
Sheet: Sheet1

 | Have | Eligible | String
 | True | True | Item # 1 |  | 1
 | True | True | Item # 2 |  | 2
 | False | False | Item # 3 |  | 3
 | True | True | Item # 4 |  | 4
 | True | False | Item # 5 |  | 5 |  |  | Item # 1
 | True | True | Item # 6 |  | 6
 | False | False | Item # 7 |  | 7
 | True | True | Item # 8 |  | 8
 | True | True | Item # 9 |  | 9
 | True | True | Item # 10 |  | 10
Spreadsheet: 679569d1590502333-concatenate-multiple-rows-into-one-cell-across-multiple-columns-seedcalendar_help-flexyourdata-
Sheet: DesiredResult

Taxon | Jan | Feb | Mar | Apr | May | June | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] paniculata |  |  |  |  |  | Fl, M | Fl, M | Fl, M
Asclepias meadii |  |  |  |  | Fl | Fl, Im | Im | Im, M | Im, M | Im, M
Boltonia decurrens |  |  |  |  |  |  |  | Fl, M | Fl, M | M
Callirhoe bushii |  |  |  |  | Fl | Fl | Fl | Fl
Crataegus latebrosa
Delphinium newtonianum |  |  |  |  |  | Fl
Delphinium treleasei |  |  |  |  | Fl | Fl
Dirca decipiens |  |  | Fl | Fl, Im | Fl, Im, M | Im, M
Echinacea paradoxa |  |  |  |  | Fl | Fl |  | M | M
Spreadsheet: 92288d1291904151-average-random-cells-no-array-bypassing-cells-with-zeros-example-2010-2011
Sheet: Performance

DETAILING
Detailing - Eastern Region
2010 | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | Team Totals
2011 | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Rec. | Sub. | Comp. | Aver. Diff. | P Points | A Points | %
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep |  |  |  | 0 | 0
Oct
Nov
Dec
10-11
Detailing - Western/Central Region
2010 | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | [NAME] |  |  | Potential | Actual | Actual | Team Totals
2011 | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Sub. | Comp. | Aver. Diff. | Points | Points | % | Rec. | Sub. | Comp. | Aver. Diff. | P Points | A Points | %
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
10-11
ESTIMATING
Estimating - Eastern Region
2010 | [NAME] |  | Potential | Actual | Actual | [NAME] |  | Potential | Actual | Actual | [NAME] |  | Potential | Actual | Actual | [NAME] |  | Potential | Actual | Actual | Team Totals
2011 | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | P Points | A Points | %
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
10-11
Estimating - Western/Central Region
2010 | [NAME] |  | Potential | Actual | Actual |  |  | Potential | Actual | Actual | [NAME] |  | Potential | Actual | Actual | [NAME] |  | Potential | Actual | Actual | Team Totals
2011 | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | Points | Points | % | Sub. | Aver. Diff. | P Points | A Points | %
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
10-11
 |  | Yearly Combined Percentage
 |  |  | 2010-04-10 00:00:00 |  | 2010-05-10 00:00:00 |  | 2010-06-10 00:00:00 |  | 2010-07-10 00:00:00 |  | 2010-08-10 00:00:00 |  | 2010-09-10 00:00:00 |  | 2010-10-10 00:00:00 |  | 2010-11-10 00:00:00 |  | 2010-12-10 00:00:00 |  | 2011-01-10 00:00:00 |  | 2011-02-10 00:00:00 |  | 2011-03-10 00:00:00
Name |  |  | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est | [NAME] | Est
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: afee3c34-9374-45f6-bee3-f6c71a0b4ba7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | SWIM | T2 | RUN.1 | POSITION | TOTAL TIME
260990 | 75522 | [NAME] | [NAME] | ESP | 10008 | 00:00:00 | 00:00:00 | 00:16:07 | [NAME] | 00:20:00 | 1 | 00:37:54
260990 | 60935 | Jeremy | Winters | USA | 10009 | 00:00:00 | 00:00:00 | 00:21:18 | 00:02:44 | 00:20:34 | 2 | 00:44:36
260990 | 11536 | [NAME] | Rieb | FRA | 10010 | 00:00:00 | 00:00:00 | 00:21:36 | [NAME] | 00:23:21 | 3 | 00:48:29
260990 | 63776 | [NAME] | Dewalque | IRL | 10011 | 00:00:00 | 00:00:00 | 00:32:29 | 00:02:17 | 00:22:46 | 4 | 00:57:31
Spreadsheet: 268037d1380377636-confirm-if-time-has-captured-for-all-24-hours-in-particular-column-24-hours-calc
Sheet: Sheet1

 | 2013-10-01 00:00:00 | 2013-10-02 00:00:00
 |  |  |  | I have data in this format , I want to check if [NAME] to Cell B10 has incorporated all 24 hours , (likewise for all the columns)in case if some period is missing then it should mention the same [NAME]: 10 to 19 means 10:00 AM to 19:00 PM W means - do not consider any time
 | 10 to 19 | 10 to 19
 | 12 to 21 | 11 to  8
 | W | 12 to 21
 | 13 to 22 | 20 to 5
 | 7 to 16
 | 9 to 18 | 22 to 7
 | 22 to 7 | 7 to 16
 | 11 to  8 | 9 to 18
 | 20 to 5 | W
Missing Time | OK | 21 to 22