tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: rick_buy__32746__Daily Treas By BU Q3
Sheet: Q3 to Date

 | Net Cash Source / (Use)
 | Current Day and Month to Date
 | 3rd Quarter 2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-08-23 00:00:00
 |  |  |  |  | Total |  |  | MTD |  |  |  |  |  | Most
 |  |  |  |  | Q3 to Date |  | Sept | August | July |  |  |  |  | Current Day
 | Enron Transportation Services
 | Portland General Electric
 | Total Distribution
 | Enron North America
 | Enron South America
 | Total Americas
 | Europe
 | Global Markets
 | Industrial Markets
 | Networks
 | Other
 | Total Traditional Wholesale
 | Global Assets
 | EGEP
 | Other Wholesale (EE&CC)
 | Total Wholesale
 | Enron Energy Services
 | Enron Broadband Services
 | Corp
 | Other
 | Total Enron*
 | ONLY includes cash movement monitored from Houston.
 | Does NOT include Canada, London or any other banking center.
 | Certain items such as payroll that is paid by Corp on behalf of a business unit has NOT been allocated to the business units
Spreadsheet: 476956d1472079654-problems-displaying-negative-numbers-for-a-flexitime-spread-sheet-flexi-sheet-100-
Sheet: Sheet1

Week commencing | 2016-08-01 00:00:00 |  | Normal Hours Per Day |  |  |  |  | Normal Hours Per Week: | 1 day, 13:00:00 | 1 day, 13:00:00 | Normal Lunch Break
 |  |  | Number of Working Days |  |  | 5 |  | Hours Carried Forward: | 00:00:00 | 00:00:00
Date | AM Start | AM End | PM Start | PM End | Lunch Total | Credit | Debit | Total Hours | Credit/Debit on the day | C/D Running Total | Comments
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 |  |  |  | Days Worked |  |  | Total Hours Worked
Date | AM Start | AM End | PM Start | PM End | Lunch Total | Credit | Debit | Total Hours | Credit/Debit on the day | C/D Running Total | Comments
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 |  |  |  | Days Worked |  |  | Total Hours Worked
Date | AM Start | AM End | PM Start | PM End | Lunch Total | Credit | Debit | Total Hours | Credit/Debit on the day | C/D Running Total | Comments
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 |  |  |  | Days Worked |  |  | Total Hours Worked
Date | AM Start | AM End | PM Start | PM End | Lunch Total | Credit | Debit | Total Hours | Credit/Debit on the day | C/D Running Total | Comments
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 |  |  |  | Days Worked |  |  | Total Hours Worked
Date | AM Start | AM End | PM Start | PM End | Lunch Total | Credit | Debit | Total Hours | Credit/Debit on the day | C/D Running Total | Comments
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 | 0:00:00 | 0:00:00 | 0:00:00 | 0:00:00 |  | 0:00:00 | 0:00:00
 |  |  |  | Days Worked |  |  | Total Hours Worked |  |  | Balance Carried Forward
 |  |  |  | Total Days Worked Over The Month |  |  | Total Hours Worked Over The Month |  |  | Days Left to Work Over The Month
Spreadsheet: 0d457ef2-667c-4016-adb6-bd1774eca341
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FFTLI | Test | FFTLI | Trypsin-Like Immunoreactivity | Trypsin-Like Immunoreactivity | Quantitative Radioimmunoassay | EDTA (lavender-top) tube: EDTA OR Green-Top Tube (Sodium Heparin): GrnNaHp OR Serum Gel Tube: SGT OR |  |  | 1 | mL | Serum   Draw blood in a plain, red-top tube(s). (Serum gel tube is acceptable.) Spin down within 2 hours of collection, pour off and send 1 mL of serum frozen in a plastic vial.    Plasma   Draw blood in a lavender top (EDTA) or pink top (K2EDTA) tube. Spin down within 2 hours of collection, pour off and send 1 mL EDTA plasma frozen in a plastic vial. | 0.3 mL | Hemolysis:	Mild reject; Gross reject Thawing:	Warm reject; Cold reject Lipemia:	Mild reject; Gross reject Icterus:	NA Other:	NA | Reference Range:      10.0-57.0 ng/mL   Expected Cathodic Trypsinogen Concentration Values for the Varied Disease States:      10.0 - 57.0 ng/mL . . . . . . . . .  [NAME]      46.0 ng/mL or less . . . . . . . .  [NAME]      92.0 - 850.0 ng/mL . . . . . . . .  [NAME]      1.4 ng/mL or less . . . . . . . . .  Total Pancreatectomy   Results should be correlated with clinical presentation and other  diagnostic data for the diagnosis of pancreatitis.    Test Performed by:  ARUP Laboratories                               500 [NAME]                                Salt Lake City,  UT 84108 | Tuesday, Friday | 1 - 5 days | 3 - 11 days | 1 | 83519 |  |  |  |  | ARUP Laboratories
FFTLI | [NAME] | VARIES | Varies |  |  |  | Frozen | 90 days
FFTLI | Result | Z2656 | Trypsin-Like Immunoreactivity | Trypsin-Like Immunoreactivity | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 880489d1728293785-required-formula-to-re-arrange-rows-sample_sheet
Sheet: Expected Result

Service Request | Incident | Enhancement | [NAME]
Number | Number | Number | Number
Short description | Short description | Short description | Short description
Opened Date | Opened Date | Opened Date | Opened Date
Assigned to | Assigned to | Assigned to | Assigned to
Assignment group | Assignment group | Assignment group | Assignment group
Spreadsheet: 0c66425c-2a05-4f60-8d79-f1970cc1a1ce
Sheet: Sheet1

Library web server <http://www.library.uri.edu/> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Statistics
1999-2000
DIRECTORY | 1999-07-01 00:00:00 | 1999-08-01 00:00:00 | 1999-09-01 00:00:00 | 1999-10-01 00:00:00 | 1999-11-01 00:00:00 | 1999-12-01 00:00:00 | 2000-01-01 00:00:00 | 2000-02-01 00:00:00 | 2000-03-01 00:00:00 | 2000-04-01 00:00:00 | 2000-05-01 00:00:00 | 2000-06-01 00:00:00 | ANNUAL TOTAL
Total requests* | 40591 | 30097 |  |  |  |  | 21529
Total page requests* | 39418 | 28970
Total visits* | 11323 | 13130
Total visitors* | 4314 | 4384
Average time per visit (seconds) | 247.63 | 253.51
Busiest day of week | [NAME] | [NAME]
Peak hours | 6am-8am | 9am-5pm
Average response delay | 82.81 | 36.39
Most popular URL
Second most popular URL
Third most popular URL
In Fall of 1999, the library web was moved to the main URI web site at http://www.uri.edu/library.
For a significant amount of time, statistics were no longer available.
Spreadsheet: 289440d1389584201-how-to-do-cartesian-join-that-is-based-on-the-selected-cell-value-bk1
Sheet: TBL3

B | C | VALUE
a | a1 | 100
 | a2 | 110
 | a3 | 120
 | a4 | 130
b | a1 | 100
 | a2 | 110
 | a4 | 130
 | a6 | 150
c | a1 | 100
 | b2 | 200
 | b3 | 210
d | d21 | 555
e | e23 | 888
Spreadsheet: 694733d1599765935-summarising-data-example-sales-sheet
Sheet: Worksheet

Company | Customer Account | Customer | Rep | Rep Name | [NAME] | Total Value | Total Margin | [NAME] 2020 | [NAME] 2020
4 | C(0006 | Hotel America | N342 | [NAME] | 2020-07-28 00:00:00 | 462 | 183.2 | 462 | 0.4
4 | C(0006 | Hotel America | N342 | [NAME] | 2020-08-03 00:00:00 | 994 | 352.48 | 994 | 0.35
4 | LC0015 | Hotel UK | N342 | [NAME] | 2020-07-31 00:00:00 | 1612.5 | 768.75 | 1612.5 | 0.48
4 | LC0015 | Hotel UK | N342 | [NAME] | 2020-08-13 00:00:00 | 4523.18 | 1233.48 | 4523.18 | 0.27
4 | LC0016 | Hotel France | N342 | [NAME] | 2020-08-17 00:00:00 | 0 | -17.28 | 0 | 0
4 | LC0016 | Hotel France | N342 | [NAME] | 2020-08-14 00:00:00 | 15000 | 7698.5 | 15000 | 0.51
7 | AF0010 | Hotel Spain | N345 | [NAME] | 2020-08-28 00:00:00 | 329.01 | 73.03 | 329.01 | 0.22
7 | CF0010 | Hotel Germany | N345 | [NAME] | 2020-08-18 00:00:00 | 159.12 | 59.65 | 159.12 | 0.37
7 | DE0020 | Hotel Portugal | N343 | [NAME] | 2020-08-21 00:00:00 | 81.26 | 27.35 | 81.26 | 0.34
7 | DE0020 | Hotel Portugal | N343 | [NAME] | 2020-08-17 00:00:00 | 57.68 | 21.39 | 57.68 | 0.37
7 | DM0014 | Hotel Italy | N345 | [NAME] | 2020-07-07 00:00:00 | 4214.97 | 2405.97 | 4214.97 | 0.57
7 | DM0014 | Hotel Italy | N345 | [NAME] | 2020-08-14 00:00:00 | 2052.75 | 637.56 | 2052.75 | 0.31
7 | GI0018 | Hotel Ukraine | N343 | [NAME] | 2020-08-18 00:00:00 | 18 | 9.94 | 18 | 0.55
7 | GU0003 | Hotel Australia | N343 | [NAME] | 2020-08-07 00:00:00 | 215.28 | 46.88 | 215.28 | 0.22
7 | HJ0002 | Hotel Japan | N343 | [NAME] | 2020-08-17 00:00:00 | 60.58 | 13.24 | 60.58 | 0.22
7 | HJ0002 | Hotel Japan | N343 | [NAME] | 2020-08-07 00:00:00 | 32 | 7.31 | 32 | 0.23
7 | HJ0002 | Hotel Japan | N343 | [NAME] | 2020-08-24 00:00:00 | 25.98 | 19.43 | 25.98 | 0.75
7 | KS0011 | Hotel China | N344 | SARAH JONES | 2020-08-27 00:00:00 | 0 | -6.16 | 0 | 0
7 | LL0017 | Hotel Russia | N345 | [NAME] | 2020-08-06 00:00:00 | 0 | -0.01 | 0 | 0
7 | LL0017 | Hotel Russia | N345 | [NAME] | 2020-08-19 00:00:00 | 76.89 | 23.56 | 76.89 | 0.31
7 | M(0008 | Hotel Austria | N343 | [NAME] | 2020-08-26 00:00:00 | 129.9 | 63 | 129.9 | 0.48
7 | M(0008 | Hotel Austria | N343 | [NAME] | 2020-08-07 00:00:00 | 534.55 | 256.65 | 534.55 | 0.48
7 | ME0030 | Hotel Bulgaria` | N343 | [NAME] | 2020-08-20 00:00:00 | 117.5 | 25.2 | 117.5 | 0.21
7 | ME0030 | Hotel Bulgaria | N343 | [NAME] | 2020-08-10 00:00:00 | 721.88 | 143.44 | 721.88 | 0.2
7 | ME0030 | Hotel Bulgaria | N343 | [NAME] | 2020-08-26 00:00:00 | 135.72 | 27.36 | 135.72 | 0.2
7 | ME0030 | Hotel Bulgaria | N343 | [NAME] | 2020-08-19 00:00:00 | 1251.6 | 272.8 | 1251.6 | 0.22
7 | MS0020 | Hotel Hugary | N343 | [NAME] | 2020-08-17 00:00:00 | 95.76 | 41.77 | 95.76 | 0.44
7 | MS0020 | Hotel Hugary | N343 | [NAME] | 2020-08-12 00:00:00 | 128.08 | 88.49 | 128.08 | 0.69
7 | MS0020 | Hotel Hugary | N343 | [NAME] | 2020-08-10 00:00:00 | 92.13 | 46.65 | 92.13 | 0.51
7 | MU0014 | Hotel Estonia | N343 | [NAME] | 2020-08-17 00:00:00 | 46.32 | 21.01 | 46.32 | 0.45
7 | OL0013 | Hotel Finland | N345 | [NAME] | 2020-08-06 00:00:00 | 0 | -0.01 | 0 | 0
Spreadsheet: 330008d1404481396-hlookup-and-match-example1
Sheet: Sheet1

[NAME] |  |  |  |  | [NAME] |  |  |  | [NAME]
1953-04-02 00:00:00 | [NAME] |  |  | 1951-01-01 00:00:00 | Fred |  |  | 1957-01-01 00:00:00 | Alfred
1958-07-04 00:00:00 | [NAME] |  |  | 1953-04-02 00:00:00 | [NAME] |  |  | 1958-07-01 00:00:00 | [NAME]
1960-01-01 00:00:00 | [NAME] |  |  | 1957-02-03 00:00:00 | [NAME] |  |  | 1958-07-04 00:00:00 | [NAME]
1962-04-08 00:00:00 | [NAME] |  |  | 1962-04-08 00:00:00 | [NAME] |  |  | 1965-02-03 00:00:00 | [NAME]
Spreadsheet: 69706ec2-c695-4307-90b5-1f351fcedf38
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
08/23/2014 | Volleyball | Gold-Blue Scrimmage | 04:00 PM
08/29/2014 | Volleyball | BYU (Gold & Blue Player's Challenge) | 07:00 PM | L, 0-3
08/30/2014 | Volleyball | Toledo (Gold & Blue Player's Challenge) | 02:00 PM | W, 3-0
08/30/2014 | Volleyball | IUPUI (Gold & Blue Player's Challenge) | 07:00 PM | W, 3-0
09/01/2014 | Volleyball | at [NAME] | 06:00 PM | W, 3-0
09/05/2014 | Volleyball | vs. Gardner-Webb ([NAME]) | 01:00 PM | W, 3-0
09/05/2014 | Volleyball | at [NAME] (Niagara Invitational) | 06:00 PM | W, 3-0
09/06/2014 | Volleyball | vs. Providence ([NAME]) | 11:00 AM | W, 3-0
09/12/2014 | Volleyball | [NAME] (Mountaineer Invitational) | 12:00 PM | W, 3-1
09/12/2014 | Volleyball | [NAME] (Mountaineer Invitational) | 07:00 PM | W, 3-0
09/13/2014 | Volleyball | St. Francis (Mountaineer Invitational) | 12:00 PM | W, 3-1
09/13/2014 | Volleyball | Montana (Mountaineer Invitational) | 07:00 PM | W, 3-0
09/19/2014 | Volleyball | at Duke (ACC-Big 12 Challenge) | 06:30 PM | L, 1-3
09/20/2014 | Volleyball | at UNC (ACC-Big 12 Challenge) | 06:00 PM | L, 0-3
09/24/2014 | Volleyball | No. 2 Texas* | 07:00 PM | L, 2-3
09/27/2014 | Volleyball | at Texas Tech* | 04:00 PM | W, 3-1
10/01/2014 | Volleyball | at [NAME] | 06:00 PM | L, 0-3
10/04/2014 | Volleyball | at Iowa State* | 02:00 PM | L, 1-3
10/08/2014 | Volleyball | Oklahoma* | 06:30 PM | L, 1-3
10/11/2014 | Volleyball | TCU* | 04:00 PM | W, 3-2
10/15/2014 | Volleyball | Kansas* | 06:30 PM | L, 1-3
10/22/2014 | Volleyball | at Baylor* | 07:00 PM | W, 3-1
10/25/2014 | Volleyball | Kansas State* | 05:00 PM | L, 2-3
10/29/2014 | Volleyball | at TCU* | 07:30 PM | L, 1-3
11/01/2014 | Volleyball | at Oklahoma* | 08:00 PM | L, 0-3
11/08/2014 | Volleyball | Iowa State* | 04:00 PM | L, 0-3
11/12/2014 | Volleyball | at No.5 Texas* | 08:00 PM | L, 0-3
11/15/2014 | Volleyball | Texas Tech* | 03:30 PM | W, 3-0
11/22/2014 | Volleyball | Baylor* | 06:30 PM | W, 3-0
11/26/2014 | Volleyball | at Kansas* | 07:00 PM | L, 0-3
11/29/2014 | Volleyball | at Kansas State* | 09:00 PM | W, 3-2
Spreadsheet: 757337d1638197303-look-for-value-in-several-sheets-example
Sheet: pricelist

edi code | name | price
1122 | abc
2233 | bcd |  |  | in C column I want price. If it is an focus product i want the price from sheet focusproduct and then if it is an special product i want it to find price in sheet special product and finally get the rest prices from sheet all products.
3344 | feg
5566 | def
8877 | abc
9988 | bcd
3399 | cde
4565 | eee
4747 | [NAME]
4848 | uuh
Spreadsheet: 750993d1633770172-searching-for-a-figure-from-a-column-matching-a-name-order-of-merit-par3-2022
Sheet: Par 3

 |  | MEMBER | [NAME] |  |  | Clacton | The Shire | Harleyford | Cardrona | Cold Ashby | [NAME] | Ullesthorpe |  | Ramsey |  |  | TOTAL | WINS
No | No |  | Memorial | Pairs | ReUnion | Essex | [NAME] | Bucks | European | Northants | Beds | Weekender | Leics | Cambs | Masters | Last Chance
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
 | 9
9 | 10
10 | 11
11 | 12
12 | 13
13 | 14
14 | 15
15 | 16
16 | 17
17 | 18
18 | 19
19 | 20
20 | 21
21 | 22
22 | 23
23 | 24
24 | 25
25 | 26
26 | 27
27 | 28
28 | 29
29 | 30
30 | 31
31 | 32
32 | 33
33 | 34
34 | 35
35 | 36
36 | 37
37 | 38
38 | 39
39 | 40
40 | 41
41 | 42
42 | 43
43 | 44
44 | 45
45 | 46
46 | 47
47 | 48
48 | 49
49 | 50
50 | 51
Spreadsheet: 722530d1615306713-consolidate-but-calculate-the-difference-subtract-during-consolidate-dia-textbook
Sheet: Sheet1

Name | Sales |  |  |  |  | Unique Books | Difference first vs last
fred's journey | 12
jan's dogs | 14
[NAME]'s adventures | 15
mark's cookbook | 11
fred's journey | 18
[NAME] hams | 14
[NAME] ted talks | 22
julia's child | 25
[NAME]'s folly | 27
[NAME]'s adventures | 24
mark's cookbook | 28
[NAME]'s folly | 30
[NAME] hams | 33
Spreadsheet: 598828d1542730427-formula-containing-index-match-isnumber-and-search-with-a-few-ifs-thrown-in-not-working-data-checking
Sheet: StudentClass

Adno | Name | Year | Subject code | Subject | Class | Teacher | ClassKey
8541 | aaa | Year 8 | Tx | Textiles | 8x/Tx2
8544 | bbb | Year 8 | Ft | Food Technology | 8x/Ft1
8545 | [NAME] | Year 8 | Ft | Food Technology | 8x/Ft1
8546 | ddd | Year 8 | Tx | Textiles | 8y/Tx1
8547 | eee | Year 8 | Tx | Textiles | 8x/Tx1
8550 | [NAME] | Year 8 | Ft | Food Technology | 8y/Ft1
8557 | ggg | Year 8 | Te | Technology | 8y/Te1
8565 | hhh | Year 8 | Te | Technology | 8y/Te1
8855 | jjj | Year 8 | Te | Technology | 8x/Te1
Spreadsheet: 104885d1302301042-excel-2007-getting-data-from-another-sheet-page-771670-20-20excelforum-1-
Sheet: Redovisning1

Redovisning
Start | Slut | Event | Inkomst | Utgift | Kommentar | Summa | Saldo
 |  | Astraförsäljning
 |  | New Body
 |  | Disco
 |  | Summa
 |  | =Tabell12[[#Totals],[Totalt]]
 |  |  |  |  | =tblDisco[[#Totals],[Totalt]]
Spreadsheet: 076f350f-1da8-4606-8c91-5b0fdf787f45
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38660918 | 2013-11-22 21:08:26 | AXIS | 1 | 7 | 4 | 939846 | Tristan710 | 10431 | mediterranean | 1941-07-01 | 1941-07-03 | 1st Alamein
38661137 | 2013-11-22 21:29:44 | ALLIES | 0 | 4 | 7 | 939846 | Tristan710 | 10431 | mediterranean | 1941-07-01 | 1941-07-03 | 1st Alamein
38681281 | 2013-11-24 04:31:44 | AXIS | 0 | 5 | 7 | 631697 | JAParker | 8340 | western | 1944-12-16 |  | Battle of the Bulge
38681510 | 2013-11-24 05:04:36 | ALLIES | 1 | 7 | 5 | 631697 | JAParker | 8340 | western | 1944-12-16 |  | Battle of the Bulge
38760905 | 2013-11-29 20:13:13 | AXIS | 0 | 6 | 9 | 392838 | [NAME] | 10891 | pacific | 1943-11-20 | 1943-11-23 | [NAME] Island
Spreadsheet: 285523d1387683674-vlookup-question-i-think-file
Sheet: DATA

GPS_ACCURACY | COR_COORD_ID | DIG_COORD_ID | DUMP_COORD_ID | TIME_END
High | 12542427 | 12542428 | 12542429 | 2013-12-22 00:47:32
High | 12542424 | 12542425 | 12542426 | 2013-12-22 00:46:05
High | 12542421 | 12542422 | 12542423 | 2013-12-22 00:45:40
High | 12542418 | 12542419 | 12542420 | 2013-12-22 00:45:01
High | 12542415 | 12542416 | 12542417 | 2013-12-22 00:44:13
High | 12542412 | 12542413 | 12542414 | 2013-12-22 00:43:40
High | 12542409 | 12542410 | 12542411 | 2013-12-22 00:43:07
High | 12542406 | 12542407 | 12542408 | 2013-12-22 00:41:42
High | 12542403 | 12542404 | 12542405 | 2013-12-22 00:41:22
High | 12542400 | 12542401 | 12542402 | 2013-12-22 00:40:58
Spreadsheet: 35895d1233614477-advanced-subtraction-addition-problem-2-copy-worksheet
Sheet: Simple

Additional Payments
Debt | Initial | Jan | Feb | Mar | Apr | May | . | Jul | Aug | Sep | Oct | Nov | Dec
CC 01 | 5000
CC 02 | 7500
CC 03 | 10000
Car | 15000
School | 20000
 | Interest | Min Payment
CC 01 | 25 | 250 | <---        This payment stays on CC 01 until it reaches a zero balance, then moves to CC 02. When CC 02 reaches a zero balance it moves to CC 03 untill all 3 credit cards (CC) reach a zero balance then its removed.
CC 02 | 50
CC 03 | 75
Car | 100 | 350 | <- These payments remain with their debt until the debt reaches a zero balance.
School | 100 | 150
 | /\  This interest adds on to each month until the balance reaches zero for that debt.
 | CC 01
 | CC 02 |  | These should be the numbers for january if no additional payments have been made.
 | CC 03
 | Car
 | School
Spreadsheet: 04ccdaaf-8b06-41c3-a52b-189040dff6f6
Sheet: 4. Summary tables

 | Summary tables
 | PMTCT
 |  | Costs per HIV positive pregnant woman and her exposed infant | Eligible for ART (AZT/3TC/NVP)
 |  |  | Eligible for ART (AZT/3TC/LPV/r)
 |  |  | Not eligible for ART
 |  |  | Replacement feeding
 |  | Total costs per given target population | Laboratory costs
 |  |  | Drug costs
 |  |  | Health services
 |  |  | Replacement feeding
 |  |  | Total
 | Prevention of congenital syphilis
 |  | Costs per maternal syphilis case
 |  | Total costs per given target population | Laboratory costs
 |  |  | Drug costs
 |  |  | Total
 | Treatment for Paediatric HIV
 |  | Costs per HIV positive child | Access to PMTCT + exposure to NVP
 |  |  | Access to PMTCT + no exposure to NVP
 |  |  | No access to PMTCT
 |  | Total costs per given target population | Laboratory costs
 |  |  | Drug costs
 |  |  | Health services
 |  |  | Total
Spreadsheet: 176a711d-3e90-4161-b799-be5c039bf971
Sheet: Request Form

Common Final Exam Room Request Form
Revised 11/2014
Instructions
1.  [NAME] in today's date, your department and your name.
2.  Dept. Chair Approval: Have your department chair enter his/her name and date.
3.  [NAME] to [NAME] as an attachment ([EMAIL] or [EMAIL]).
Date:
Department:
Submitted By:
Dept. Chair Approval & Date:
It is the department's responsibility to make these arrangements.
COORS EVENTS CENTER WILL BE USED FOR THE FOLLOWING COMMON EXAMS
i.e., CHEM 1000, 2000
COMMON EXAM DATE, BEGIN/END TIME
i.e., 12/12/2014, 7:30-10:00am
COMMON EXAM CLASSES
i.e, APPM 1000, 2000, 3000, 4000
REQUESTED CLASSROOMS
i.e., MATH 100
MCOL W100
DUAN G1B30
Spreadsheet: 142606d1329926087-use-data-from-non-consecutive-rows-into-consecutive-rows-on-different-worksheet-calcs
Sheet: Sheet1

Year | Income | Value
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
Spreadsheet: 462447d1464050846-why-this-vlookup-is-not-working-vlookup
Sheet: Sheet1

VLOOKUP | Updated PC |  |  | Postal Code | Member | Qty
 | 760175 |  |  | 670236 | 1711 | 16
 | 760125 |  |  | 640458 | 1913 | 18
 | 750469 |  |  | 640518 | 1750 | 16
 | 791440 |  |  | 649848 | 1801 | 15
 | 550529 |  |  | 640977 | 1813 | 20
 | 530101 |  |  | 641989 | 1977 | 16
 | 530952 |  |  | 120118 | 1587 | 6
 | 824617 |  |  | 228192 | 1875 | 11
 | 510637 |  |  | 180008 | 1751 | 32
 | 524498 |  |  | 289850 | 1854 | 23
 | 522524 |  |  | 760175 | 1572 | 14
 | 521160 |  |  | 750469 | 1562 | 22
 | 460412 |  |  | 760125 | 1680 | 14
 | 460412 |  |  | 791440 | 1908 | 27
 | 49246 |  |  | 824617 | 1775 | 13
 | 90037 |  |  | 330022 | 1558 | 24
 | 180008 |  |  | 310470 | 1871 | 20
 | 228192 |  |  | 530101 | 1812 | 23
Spreadsheet: 683019d1592432838-dragging-vertical-formulas-referencing-horizontal-cells-vertical-formula-w-horizontal-reference
Sheet: BLSPLS Menu

 |  | abc | def | gfi | asdf | asdf
Status |  | Complete | Delayed | Complete | Complete | Complete
Target Audience | [NAME] (15-24 years old) | True | False | True | True | False
 | Gen Y/Millennials (25-39 years old) | True | True | True | True | True
 | [NAME] (40-55 years old ) | True | False | True | True | False
 | Boomers (56-79 years old ) | False | False | True | True | False
 | # of age cohorts selected
 | Do you need results broken out by separate age cohorts? [Yes/No] | No | No | No | No | No
 | Test Cell Sample Size (n=300 per sub-group breakout in each test cell) | 300
 | Control Cell Sample Size (n=150 in each control cell) | 200
 | TOTAL SAMPLE SIZE REQUIRED
 | Additional Screening for target audience (up to 2 criteria) | 1. MF16-28 (high school, mature/grad students) | 1. HHI: min $82K |  | 1. Interests: Shopping, Holiday Events, Gifting, Food & Entertainment | 1. Exclude category rejectors
 |  | 2. MF 45+ (parents of prospective students) *Definition of 'prospective students' TBD | 2. Single; [NAME], Outdoors
 | Desired Sub-group Analysis (interests, etc) | Students & Parents | In the market for a new car: XXXX | N/A | N/A | N/A
Spreadsheet: 94265d1294133827-automatic-number-and-date-sorting-formula-number_n_category_answer_done-sorting-output-donkey
Sheet: Alt

BA Number | Filtered | First Invoice |  | Invoice Date | Invoice Number | Invoice Amount | BA First Invoice Date | BA Total Amount | BA Total Rounddown Amount | BA Due Date | Days Left
801102 | BA Number |  |  | 2010-11-10 00:00:00 | INV20918 | 5000
801102 | 801102 |  |  | 2010-11-13 00:00:00 | INV20919 | 6390
801102 | 801103 |  |  | 2010-11-12 00:00:00 | INV20920 | 8432
801102 | 801104 |  |  | 2010-11-13 00:00:00 | INV20921 | 7582
801102 |  |  |  | 2010-11-09 00:00:00 | INV20922 | 8450
801102 |  |  |  | 2010-11-15 00:00:00 | INV20923 | 31242
801103 |  |  |  | 2010-11-12 00:00:00 | INV20924 | 3912
801103 |  |  |  | 2010-11-06 00:00:00 | INV20925 | 734
801103 |  |  |  | 2010-11-09 00:00:00 | INV20926 | 450
801103 |  |  |  | 2010-11-15 00:00:00 | INV20927 | 12
801104 |  |  |  | 2010-11-15 00:00:00 | INV20927 | 1699