tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101707d1299780210-wildcards-in-concatenate-help-putting-it-together-sample
Sheet: Sheet1

Date | Store Number | Transaction Code | Charge Code | Units
2009-01-05 00:00:00 | 44.95 | 6484097 | 647550 | 3
2009-01-05 00:00:00 | 44.95 | 6484097 | 647550 | 1
2009-02-24 00:00:00 | 44.95 | 6302618 | 644444 | 4
2009-02-26 00:00:00 | 44.95 | 9090957 | 644444 | 3
2009-02-26 00:00:00 | 44.95 | 9090957 | 644444 | 3
2009-02-26 00:00:00 | 44.95 | 9090957 | 644444 | 1
2009-02-26 00:00:00 | 44.95 | 9090957 | 647550 | 3
2009-03-17 00:00:00 | 44.95 | 3360842 | 647550 | 4
2009-03-17 00:00:00 | 44.95 | 3360842 | 644444 | 3
2009-03-19 00:00:00 | 44.95 | 9035999 | 644444 | 7
2009-03-26 00:00:00 | 44.95 | 8667763 | 644444 | 4
2009-04-15 00:00:00 | 44.95 | 3007781 | 644444 | 7
2009-08-25 00:00:00 | 44.95 | 9276926 | 647550 | 1
2009-08-25 00:00:00 | 44.95 | 9276926 | 647550 | 6
2009-08-25 00:00:00 | 44.95 | 9276926 | 644444 | 3
2009-08-31 00:00:00 | 44.95 | 3003503 | 644444 | 6
2009-08-31 00:00:00 | 44.95 | 3003503 | 644444 | 9
2009-09-29 00:00:00 | 44.95 | 1839656 | 644444 | 1
2009-09-29 00:00:00 | 44.95 | 1839656 | 647550 | 8
2010-02-10 00:00:00 | 44.95 | 9581440 | 647550 | 3
2010-02-10 00:00:00 | 44.95 | 9581440 | 647550 | 3
2010-02-10 00:00:00 | 44.95 | 9581440 | 647550 | 6
2010-03-03 00:00:00 | 44.95 | 3334328 | 647550 | 9
2010-03-17 00:00:00 | 44.95 | 8574722 | 647550 | 3
2009-01-05 00:00:00 | 45.01 | 6484109 | 644444 | 3
2009-01-05 00:00:00 | 45.01 | 6484109 | 644444 | 3
2009-02-24 00:00:00 | 45.01 | 6302630 | 644444 | 3
2009-02-26 00:00:00 | 45.01 | 9090969 | 644444 | 9
2009-02-26 00:00:00 | 45.01 | 9090969 | 647550 | 1
2009-02-26 00:00:00 | 45.01 | 9090969 | 647550 | 3
2009-02-26 00:00:00 | 45.01 | 9090969 | 647550 | 4
2009-03-17 00:00:00 | 45.01 | 3360854 | 647550 | 3
2009-03-17 00:00:00 | 45.01 | 3360854 | 647550 | 3
2009-03-19 00:00:00 | 45.01 | 9036011 | 644444 | 1
2009-03-26 00:00:00 | 45.01 | 8667775 | 644444 | 3
2009-04-15 00:00:00 | 45.01 | 3007793 | 644444 | 9
2009-08-25 00:00:00 | 45.01 | 9276938 | 644444 | 1
2009-08-25 00:00:00 | 45.01 | 9276938 | 647550 | 3
2009-08-25 00:00:00 | 45.01 | 9276938 | 647550 | 8
2009-08-31 00:00:00 | 45.01 | 3003515 | 647550 | 3
2009-08-31 00:00:00 | 45.01 | 3003515 | 647550 | 3
2009-09-29 00:00:00 | 45.01 | 1839668 | 644444 | 1
2009-09-29 00:00:00 | 45.01 | 1839668 | 644444 | 3
2010-02-10 00:00:00 | 45.01 | 9581452 | 644444 | 3
2010-02-10 00:00:00 | 45.01 | 9581452 | 644444 | 3
2010-02-10 00:00:00 | 45.01 | 9581452 | 647550 | 1
2010-03-03 00:00:00 | 45.01 | 3334340 | 647550 | 3
2010-03-17 00:00:00 | 45.01 | 8574734 | 647550 | 3
Spreadsheet: 874876d1721386207-array-with-a-delayed-sequence-array-count-revised
Sheet: Logistics (2)

 |  | ANSWER PROVIDED BY windknife |  |  |  |  |  |  |  | REQUIRED separate array from the generated from the answer without checking [NAME]:H31
 |  | 0 |  | 4 | 7 | 2 | 5 |  |  | 0 | 1 | 0 | 7 | 2 | 0
 |  |  | 1 | 4 | 7 | 2 | 5 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 1 | 4 | 7 | 2 | 5 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 1 | 4 | 7 | 2 | 5 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 1 | 5 | 7 | 2 | 6 |  |  |  | 0 | 5 | 0 | 0 | 6
 |  |  | 1 | 5 | 7 | 2 | 6 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 1 | 5 | 7 | 2 | 6 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 5 | 8 | 3 | 6 |  |  |  | 2 | 0 | 8 | 3 | 0
 |  |  | 2 | 5 | 8 | 3 | 6 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 5 | 8 | 3 | 6 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 5 | 8 | 3 | 6 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 6 | 8 | 3 | 7 |  |  |  | 0 | 6 | 0 | 0 | 7
 |  |  | 2 | 6 | 8 | 3 | 7 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 2 | 6 | 8 | 3 | 7 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 6 | 1 | 4 | 7 |  |  |  | 3 | 0 | 1 | 4 | 0
 |  |  | 3 | 6 | 1 | 4 | 7 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 6 | 1 | 4 | 7 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 6 | 1 | 4 | 7 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 0 | 1 | 4 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 0 | 1 | 4 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 3 | 0 | 1 | 4 | 0 |  |  |  | 0 | 0 | 0 | 4 | 0
 |  |  | 4 | 0 | 0 | 5 | 0 |  |  |  | 4 | 0 | 0 | 5 | 0
 |  |  | 4 | 0 | 0 | 5 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  |  | 4 | 0 | 0 | 5 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0
 |  | Formual in D6 to check against range>> | 4 | 3 | 3 | 4 | 3
Spreadsheet: kate_symes__18885__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-03-20 00:00:00 |  | 399.53 | 5120 | 308.69 | 560
 | 2001-03-19 00:00:00 |  | 458.18 | 14320 | 290 | 200 | 410.04 | 1220 | 293.22 | 885
 | 2001-03-18 00:00:00 |  |  |  |  |  |  |  | 256.06 | 3083 |  | 310 | 1200
 | 2001-03-17 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 357.5 | 360 | 276.3 | 270
 | 2001-03-16 00:00:00 |  | 244.64 | 5600 | 200.19 | 1040 | 394.78 | 335 | 330 | 360
 | 2001-03-15 00:00:00 |  | 216.79 | 7600 | 168.33 | 1200 | 254.45 | 627 | 261.36 | 550
 | 2001-03-14 00:00:00 |  | 213.33 | 7200 | 178.33 | 600 | 246.45 | 900 | 222.58 | 1035
 | 2001-03-13 00:00:00 |  | 217.05 | 8800 | 174.4 | 1000 | 234.06 | 1946 | 237.07 | 870
 | 2001-03-12 00:00:00 |  | 270 | 6800 | 205 | 200 | 237.03 | 3775 | 219.92 | 1945
 | 2001-03-11 00:00:00 |  |  |  |  |  |  |  | 239.18 | 2715 |  | 205 | 600
 | 2001-03-10 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 294.74 | 950 | 265.54 | 925
 | 2001-03-09 00:00:00 |  | 228.93 | 5600 | 165 | 600 | 366.94 | 1070 | 296.17 | 1600
 | 2001-03-08 00:00:00 |  | 276.67 | 6000 | 200 | 200 | 346.11 | 3730 | 314.25 | 2395
 | 2001-03-07 00:00:00 |  | 340.26 | 7600 | 263.33 | 600 | 350.64 | 3925 | 325.92 | 1567
 | 2001-03-06 00:00:00 |  | 338.57 | 2800 | 269.58 | 960 | 357.4 | 2896 | 344.21 | 1295
 | 2001-03-05 00:00:00 |  | 327 | 2000 | 306.25 | 800 | 344.21 | 4538 | 365.1 | 1235
 | 2001-03-04 00:00:00 |  |  |  |  |  |  |  | 330 | 1125 |  | 306.25 | 2400
 | 2001-03-03 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 350 | 75 | 350 | 600
 | 2001-03-02 00:00:00 |  | 298.33 | 4800 | 223.97 | 584 | 365 | 200 | 350 | 285
 | 2001-03-01 00:00:00 |  | 292.12 | 6800 | 280 | 200 | 429.4 | 1762 | 326.61 | 930
 | 2001-02-28 00:00:00 |  | 200.76 | 5152 | 183.49 | 1328 | 338.36 | 10459 | 285.21 | 1523
 | 2001-02-27 00:00:00 |  | 202.25 | 2912 | 135 | 200 | 275.53 | 4475 | 267.2 | 795
 | 2001-02-26 00:00:00 |  | 248.21 | 5600 | 195 | 240 | 258.41 | 5480 | 226.05 | 950
 | 2001-02-25 00:00:00 |  |  |  |  |  |  |  | 181.6 | 2500 |  | 200 | 360
 | 2001-02-24 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 214.05 | 4252 | 232.89 | 760
 | 2001-02-23 00:00:00 |  | 196.43 | 2800 | 140 | 200 | 296.91 | 1345 | 300 | 400
 | 2001-02-22 00:00:00 |  | 261 | 4000 | 200 | 200 | 233.22 | 2500 | 222.69 | 1730
 | 2001-02-21 00:00:00 |  | 283.75 | 4800 | 240 | 200 | 425 | 1050 | 372 | 750
 | 2001-02-20 00:00:00 |  | 326.82 | 4400 | 300 | 600 | 324.71 | 8650 | 350.06 | 1975
 | 2001-02-19 00:00:00 |  | 326.15 | 5200 | 300 | 600 | 382.2 | 4390 | 356.1 | 1540
 | 2001-02-18 00:00:00 |  |  |  |  |  |  |  | 399.12 | 4290 |  | 320 | 600
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 887937d1738250550-scan-function-not-behaving-as-expected-scan-to-count-sections
Sheet: Sheet1

 | Section 1 |  |  | Section 2 |  |  | Section 3 |  |  |  |  |  |  |  |  | Expected values
 | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 |  |  |  | Column1 |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  | Column2
 |  |  |  |  |  |  |  |  |  |  |  | Column3
 |  |  |  |  |  |  |  |  |  |  | Section 2 | Column4 |  | #[NAME]! |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | Column5
 |  |  |  |  |  |  |  |  |  |  |  | Column6
 |  |  |  |  |  |  |  |  |  |  | Section 3 | Column7 |  | #[NAME]! |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | Column8
Spreadsheet: 708309d1607714681-count-until-criteria-from-right-to-left-test
Sheet: Sheet45

Result | Data 1 | Data 2 | Data 3 | Data 4 | Data 5 | Data 6 - Starting Point | Data 6
2 | 0 | 100 | 100 | 0 | 100 | 0 | 100
3 | 100 | 0 | 100 | 100 | 0 | 0 | 100
1 | 0 | 100 | 0 | 0 | 0 | 100 | 100
6 | 100 | 0 | 0 | 0 | 0 | 0 | 100
WRONG Result
 | 100 | 0 | 100 | 100 | 0 | 0 | 100
=COUNT(G8:INDEX(B8:G8,MATCH(TRUE,B8:G8>0,0)))
Spreadsheet: 043b820a-db5f-4161-8b19-d1b12d8c4399
Sheet: VCUVandy

Team | Tournament | PPB
Stevenson | NIU Huskie Bowl | 27.07
[NAME] A | VCU Winter | 26.99
[NAME] | VCU Winter | 26.06
Auburn A | NIU Huskie Bowl | 25.48
Loyola A | NIU Huskie Bowl | 24.77
Detroit Catholic Central | NIU Huskie Bowl | 24.35
[NAME] | Bergen BOAT | 24.33
IMSA A | NIU Huskie Bowl | 24.14
St. Anselm's | VCU Winter | 23.75
GDS | VCU Winter | 23.74
Proviso North | NIU Huskie Bowl | 23.09
Yaphe Academy A | VCU Winter | 23.06
[NAME] A | Bergen BOAT | 22.92
Hunter A | Bergen BOAT | 22.86
Lisle A | NIU Huskie Bowl | 22.64
St. Ignatius | NIU Huskie Bowl | 22.59
LASA B | [NAME] | 22.25
St. Joe A | Bergen BOAT | 21.78
New Trier | NIU Huskie Bowl | 21.56
Bellaire A | [NAME] | 21.4
Auburn B | NIU Huskie Bowl | 20.51
Seven Lakes A | [NAME] | 20.12
New Kent | VCU Winter | 18.65
Bellaire B | [NAME] | 18.31
Cave Spring A | VCU Winter | 18.21
Clover Hill A | VCU Winter | 18.17
St. Joe B | Bergen BOAT | 17.98
[NAME] | VCU Winter | 17.72
Keith Country Day A | NIU Huskie Bowl | 17.16
[NAME] | Bergen BOAT | 17.13
Kealing A | [NAME] | 17.11
[NAME] | VCU Winter | 16.97
Kealing B | [NAME] | 16.42
Yaphe Academy B | VCU Winter | 16.24
Kings Park A | Bergen BOAT | 15.59
Collegiate | VCU Winter | 15.36
Seven Lakes B | [NAME] | 14.62
St. Christopher's | VCU Winter | 14.6
[NAME] A | Bergen BOAT | 14.08
[NAME] | Bergen BOAT | 13.1
Clover Hill B | VCU Winter | 12.22
BCA | Bergen BOAT | 11.13
Cave Spring B | VCU Winter | 10.93
[NAME] | Bergen BOAT | 10.5
Monticello | VCU Winter | 10.2
[NAME] | NIU Huskie Bowl | 9.13
Kings Park B | Bergen BOAT | 9.04
Village | [NAME] | 7.5
Kealing C | [NAME] | 6.29
Yes SE A | [NAME] | 6
Yes SE B | [NAME] | 3
Spreadsheet: 90171d1289932314-excel-2007-sumproduct-is-including-blanks-book1
Sheet: Sheet1

Visa |  | 2010-07-04 00:00:00
Consumer |  | 2010-07-05 00:00:00
Car |  | 2010-07-06 00:00:00
Car |  | 2010-07-07 00:00:00
Car |  | 2010-07-08 00:00:00
Consumer | Loan |  | 2010-07-04 00:00:00 | Sunday
Visa | Card |  | 2010-07-05 00:00:00 | Monday
Master | Card |  | 2010-07-06 00:00:00 | Tuesday
Premium | Card |  | 2010-07-07 00:00:00 | Wednesday
Second Salary | Overdraft |  | 2010-07-08 00:00:00 | Thursday
Car | Loan
Spreadsheet: 744807d1629460808-display-only-filtered-values-from-sheet-1-to-sheet-2-text-and-numbers-book1
Sheet: Sheet2

 | Paradise | 2 | A2 | 2020-11-07 00:00:00 | 2020-11-08 00:00:00 | 60.75 | 0 | 60.75 | 42.84 | 0 | 4.23 | -4.23
 | Paradise | 2 | A1 | 2020-12-31 00:00:00 | 2021-01-02 00:00:00 | 71.29 | 71.29 | 0 | 60 | 11.29 | 0 | 0
 | Paradise | 2 | A2 | 2021-03-27 00:00:00 | 2021-04-05 00:00:00 | 733.32 | 0 | 733.32 | 633.32 | 0 | 100 | -100
Spreadsheet: 112935d1308898860-consolidating-data-on-summary-sheet-based-on-unique-id-issues-action-plans-example
Sheet: Action_Plans

Issue ID | Name | Description | Latest comments | Owner | Due Date | Status
IN1 | Action 1 | Do this | Currently being performed | [NAME] | 2011-06-30 00:00:00 | Open
IN2 | Action 1 | Do that | Not started | [NAME] | 2011-06-28 00:00:00 | Open
IN1 | Action Z | dgegrfer | Not started | [NAME] | 2011-06-30 00:00:00 | Open
Spreadsheet: 714528d1611256691-help-computing-a-running-total-between-2-sheets-book6-1-
Sheet: 01.25

 |  |  |  |  |  |  |  |  | Starting Liquid |  | 200000
 |  |  |  |  |  |  |  |  |  | 2020-01-25 00:00:00 |  | 2020-01-26 00:00:00 |  | 2020-01-27 00:00:00 |  | 2020-01-28 00:00:00 |  | 2020-01-29 00:00:00 |  | 2020-01-30 00:00:00 |  | 2020-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | C | D | C | D | C | D
 |  |  |  |  |  |  |  | Job 1 |  | 4
 |  |  |  |  |  |  |  | Job 2 |  | 8 | 4
 |  |  |  |  |  |  |  | Job 3 |  |  | 8 | 12
 |  |  |  |  |  |  |  | Job 4 |  |  |  | 2 | 3 | 14
 |  |  |  |  |  |  |  | Job 5 |  |  |  |  |  |  | 13 | 13
 |  |  |  |  |  |  |  | Job 6 |  |  |  |  |  |  |  |  | 14 | 14 | 4
 |  |  |  |  |  |  |  | Job 7 |  |  |  |  |  |  |  |  |  |  | 9 | 13 | 13 | 13 | 13
 |  |  |  |  |  |  |  |  |  | 18210 | 14056 | 24566 | 5223 | 24373 | 12768 | 12768 | 17267 | 17267 | 18780 | 20000 | 20000 | 20000 | 20000
 |  |  |  |  |  |  |  |  |  | 2020-01-25 00:00:00 |  | 2020-01-26 00:00:00 |  | 2020-01-27 00:00:00 |  | 2020-01-28 00:00:00 |  | 2020-01-29 00:00:00 |  | 2020-01-30 00:00:00 |  | 2020-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  | A | B | A | B | A | B | A | B | C | D | C | D | C | D
 |  |  |  |  |  |  |  | Job 1 |  | 14 | 14 | 14 | 14 | 14 | 4
 |  |  |  |  |  |  |  | Job 2 |  |  |  |  |  |  | 10 | 14 | 14 | 14 | 14 | 14 | 11
 |  |  |  |  |  |  |  | Job 3 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  |  | Job 4 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  | Job 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 25969 | 25969 | 25969 | 25969 | 25969 | 22804 | 21539 | 21539 | 21539 | 21539 | 21539 | 20805 | 25187 | 25364
Rows 9-19 represent production line 1
Rows 21-29 represent production line 2
Row 19 is the total amount of liquid used for that day - example, 32,266 used on production line 1 on Monday
Row 29 is the same, but for production line 2
Row 7 represents the running total of where we will be at the end of each day - based off of the usages in rows 19+29
Cell C5 will be manually entered on Monday morning
My goal is to have a running count that incorporates incoming loads of liquid, based off of the schedule on the next sheet
Cell L1 (the old [NAME]) should be MONDAY'S starting point. Cell K3 should equal (Cell L1) + ([NAME] on 1/25) - (usage in K15+K25)
Then, cell M3 should equal (cell K3)+(incoming loads on 1/26) - (usage in M15+M25)
Spreadsheet: 870415d1716931412-how-to-return-data-into-email-text-using-index-function-auto-send-sample
Sheet: test sheet SF invoice

Invoices | Line | Order | delivery # | Material Number | Material Name | Tank Number | Qty Invoiced | uom | Invoice Date | Due Date | Status
902693049 | 10 | 7823680 | 88962270 | 7162564 |  | ~ | 6 | PL | May-18-24 | Jul-9-24 | Open
902679976 | 10 | 7818777 | 88952327 | 7154773 | SPECTRUS NX1100 NQ N2 AND PR VA |  | 4 | BBD | May-9-24 | Jun-30-24 | Open
902676814 | 10 | 7792706 |  | 7058973 | FERRIC CHLRIDE-40% LQCMD T TANK TRUCK | 100886 | 24100 | LB | May-7-24 | Jun-28-24 | Open
902675738 | 10 | 7807002 | 88951952 | 7007979 | KLARAID CDP2737 [NAME] | 2022161452 | 3566 | GAL | May-7-24 | Jun-28-24 | Open
902669371 | 10 | 7802159 |  | 7013275 | BIOPLUS BA3972 T TANK TRUCK | 2024162999 | 38841.526 | LB | May-3-24 | Jun-24-24 | Open
902672998 | 10 | 7803735 | 88946856 | 7006817 | METCLEAR MR2435 K CUSTOM BULK | 112192 | 1990 | GAL | May-3-24 | Jun-24-24 | Open
902666410 | 10 | 7813868 | 88948742 | 7133839 | FOAMTROL AF2290 N2 BULK BIN DIS | ~ | 6 | BBD | May-1-24 | Jun-22-24 | Open
Spreadsheet: 061b9c9e-c4db-4cb9-b0e6-1e33f91679ec
Sheet: Corporate VC Deal Stages

Total Venture Capital and Corporate Venture Capital by Deal Stage
01/01/2012-06/30/2013
Company Stage as of Investment Round | Total # Deals | Average $M Per Deal | Total $M Invested in that Stage by All VC Types | # Deals with CVC Participation | Avg. CVC investment in Those Rounds Participated In | $ CVC Investment | % of CVC Investment $ | % of Deals with CVC Involvement | CVC % of $ In Stage Category
Seed | 376 |  | 1087.57 | 36 |  | 72.15
Early Stage | 2590 |  | 12124.61 | 382 |  | 1035.07
Expansion | 1418 |  | 13583.97 | 260 |  | 1376.15
Later Stage | 1227 |  | 12880.91 | 212 |  | 1165.87
Source:  PricewaterhouseCoopers/National Venture Capital Association MoneyTree™ Report, Data:  Thomson Reuters
Spreadsheet: eric_saibi__9804__091901R
Sheet: San Juan 03

Owner Name |  | Public Service Co. of NM
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 03
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2001-08-11 00:00:00
End Date |  | 2001-09-19 00:00:00
Prv. Start Date |  | 2001-08-11 00:00:00
Prv. End Date |  | 2001-09-08 00:00:00
Comments |  | Reheater/Turb.  Is in the process of firing up the boiler, will be on line tonight.
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007771
Outage ID |  | 16884
Spreadsheet: 483e7ade-9bf2-4604-90d8-96a1133b007c
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
 | 5671.0 Lending Finance, Australia
 | TABLE 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($000)
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
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 759717d1639676764-creating-random-numbers-excluding-some-numbers-creating-random-numbers-excluding-some-numbers-2
Sheet: Sheet1

Status | Row No | Excluded Nos | [NAME] | Random minus exclusions
X | 1
0 | 2
0 | 3
X | 4
0 | 5
0 | 6
0 | 7
0 | 8
0 | 9
0 | 10
0 | 11
0 | 12
0 | 13
X | 14
0 | 15
0 | 16
Spreadsheet: 760301d1640129807-display-names-of-individuals-trained-small-sample-copy-tms
Sheet: Schedule By Day

Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
[NAME] | Suzy | Suzy | Suzy | [NAME] | [NAME] | [NAME]
Dale | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | Dale |  |  |  | Dale | Dale
Goal: This is the schedule by day. What I want the spreadsheet to do is on the next worksheet (Run_Taxi) pull data from the training list and only display the individuals by day that are Run/Taxi and then the same for the confined space. This is a very small sample of what I am trying to do, but if I can get the overall formula or steered in the right direction, then I can make the overall live spreadsheet do what I want it to do.
Spreadsheet: 106270d1303429686-lookup-function-that-produces-a-image-example
Sheet: Sheet2

Search | Result |  |  | Values that can be looked up
PE84-P |  |  |  | LOUR1-P
 |  |  |  | PE84-P
 |  |  |  | INC37-P
 |  |  |  | CK83-P
 |  |  |  | POLO233-P
 |  |  |  | POLO232-P
 |  |  |  | CLA40-P
 |  |  |  | POLO231-P
 |  |  |  | POLO234-P
 |  |  |  | TH54-P
 |  |  |  | TB19-P
 |  |  |  | TB22-P
 |  |  |  | KC36-P
 |  |  |  | KC37-P
 |  |  |  | ALF159-P
 |  |  |  | KC38-P
 |  |  |  | PE85-P
 |  |  |  | PE86-P
 |  |  |  | PE87-P
 |  |  |  | TB20-P
 |  |  |  | TB21-P
 |  |  |  | PE88-P
 |  |  |  | TH55-P
 |  |  |  | ALF160-P
 |  |  |  | ET4-P
 |  |  |  | CK84-P
 |  |  |  | CK82-P
 |  |  |  | ED188-P
 |  |  |  | [NAME]
Spreadsheet: 327527d1403605652-count-and-sum-in-filtered-data-count
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Correct Answer: (Count) |  | 4 | 4 | 1
 |  |  |  |  |  |  |  |  |  |  |  | COUNT
 |  |  |  |  |  |  |  |  |  |  |  | SUM
Work | [NAME]. | Ph. | Work Bal. | State-1 | State-2 | State-3 | [NAME] | State-5 | State-6 |  |  |  |  |  | Values
3515 | D1 | 1 |  | 2.86 | 1.11 | 50.245 | 88.1 | 0 | 0 |  |  | Work | [NAME]. | Ph. | Sum of Work Bal. | Sum of State-1 | Sum of State-2 | Sum of State-3 | Sum of State-4 | Sum of State-5 | Sum of State-6
3515 | D1 | 2 |  | 30.826 | 0 | 0 | 0 | 0 | 0 |  |  | 4075 | A1 | 1 | 0 | 0 | 0 | 0 |  | 0 | 0
3515 | D1 | 3 |  | 0 | 4.8811 | 20.1808 | 19.80799 | 0 | 9.624 |  |  |  |  | 2 | 60.256 | 0 | 20.1 | 40.156 | 0 | 0 | 0
3515 | D1 | 4 |  | 0 | 0 | 0 | 0 |  | 0 |  |  |  |  | 3 | 8.15 | 0 | 0 | 0 | 8.15 | 0 | 0
3515 | D1 | 5 |  | 209.9943800000002 | 2.1 | 0 | 0 | 4.692 | 0 |  |  |  | A1 Total |  | 68.406 | 0 | 20.1 | 40.156 | 8.15 | 0 | 0
3515 | D1 | 6 |  | 0 | 0 | 5.63 | 0 | 0 | 1.626 |  |  |  | B1 | 1 | 15.38 | 6.23 | 0 | 0 | 0 | 9.15 | 0
4075 | A1 | 1 |  | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  | 2 | 18.39 | 0 | 8.14 | 0 | 8.15 | 0 | 2.1
4075 | A1 | 2 |  | 0 | 20.1 | 40.156 | 0 | 0 | 0 |  |  |  | B1 Total |  | 33.77 | 6.23 | 8.14 | 0 | 8.15 | 9.15 | 2.1
4075 | A1 | 3 |  | 0 | 0 | 0 | 8.15 | 0 | 0 |  |  | 4075 Total |  |  | 102.176 | 6.23 | 28.24 | 40.156 | 16.3 | 9.15 | 2.1
4075 | B1 | 1 |  | 6.23 | 0 | 0 | 0 | 9.15 | 0
4075 | B1 | 2 |  | 0 | 8.14 | 0 | 8.15 | 0 | 2.1
Spreadsheet: 1b93b277-220a-4430-8638-28f97db83c64
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7672 | 12494 | Neville | Muir | RSA | 0 | 00:40:06 | 00:00:00 | 02:24:58 | 00:00:00 | 01:09:15 | 1 | 04:14:20
Spreadsheet: 97599d1296734621-pivot-table-see-the-filters-that-calculated-cell-contents-762870_cookie365
Sheet: Sheet1

f1 | f2 | f3 | f4
a | x | 1
b | y | 2 |  |  |  | Sum of f3+f4 | Column Labels
c | x | 3 |  |  |  | Row Labels | x
a | x | 4 |  |  |  | a | 55
b | y | 5 |  |  |  | Grand Total | 55
c | x | 6
Spreadsheet: 77600d1278030182-reshuffle-group-combinations-without-repitition-16tm_10wks
Sheet: 16 team 10wks

Week | 1
2 | 15
3 | 14
4 | 13
5 | 12
6 | 11
7 | 10
8 | 9
Bye | 1
Week | 2
3 | 1
4 | 15
5 | 14
6 | 13
7 | 12
8 | 11
9 | 10
Bye | 2
Week | 3
4 | 2
5 | 1
6 | 15
7 | 14
8 | 13
9 | 12
10 | 11
Bye | 3
Week | 4
5 | 3
6 | 2
7 | 1
8 | 15
9 | 14
10 | 13
11 | 12
Bye | 4
Week | 5
6 | 4
7 | 3
8 | 2
9 | 1
10 | 15
11 | 14
12 | 13
Bye | 5
Week | 6
7 | 5
8 | 4
9 | 3
10 | 2
11 | 1
12 | 15
13 | 14
Bye | 6
Week | 7
8 | 6
9 | 5
10 | 4
11 | 3
12 | 2
13 | 1
14 | 15
Bye | 7
Week | 8
9 | 7
10 | 6
11 | 5
12 | 4
13 | 3
14 | 2
15 | 1
Bye | 8
Week | 9
10 | 8
11 | 7
12 | 6
13 | 5
14 | 4
15 | 3
1 | 2
Bye | 9
Week | 10
11 | 9
12 | 8
13 | 7
14 | 6
15 | 5
1 | 4
2 | 3
Bye | 10