tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 694744d1599771464-summarising-data-example-sales-sheet
Sheet: Worksheet

Company | Customer Account | Customer | Rep | Rep Name | [NAME] | Total Value | Total Margin | [NAME] 2020 | [NAME] 2020 | First Order Date | In First 3 months?
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-15 00:00:00 | 994 | 352.48 | 994 | 0.35
4 | LC0015 | Hotel America | N342 | [NAME] | 2020-09-02 00:00:00 | 1612.5 | 768.75 | 1612.5 | 0.48
4 | LC0015 | Hotel America | N342 | [NAME] | 2020-09-20 00:00:00 | 4523.18 | 1233.48 | 4523.18 | 0.27
4 | LC0016 | Hotel America | N342 | [NAME] | 2020-10-08 00:00:00 | 0 | -17.28 | 0 | 0
4 | LC0016 | Hotel America | N342 | [NAME] | 2020-10-26 00:00:00 | 15000 | 7698.5 | 15000 | 0.51
7 | AF0010 | Hotel America | N342 | [NAME] | 2020-11-13 00:00:00 | 329.01 | 73.03 | 329.01 | 0.22
7 | CF0010 | Hotel America | N342 | [NAME] | 2020-12-01 00:00:00 | 159.12 | 59.65 | 159.12 | 0.37
7 | DE0020 | Hotel America | N342 | [NAME] | 2020-12-19 00:00:00 | 81.26 | 27.35 | 81.26 | 0.34
7 | DE0020 | Hotel America | N342 | [NAME] | 2021-01-06 00:00:00 | 57.68 | 21.39 | 57.68 | 0.37
7 | DM0014 | Hotel America | N342 | [NAME] | 2021-01-24 00:00:00 | 4214.97 | 2405.97 | 4214.97 | 0.57
7 | DM0014 | Hotel America | N342 | [NAME] | 2021-02-11 00:00:00 | 2052.75 | 637.56 | 2052.75 | 0.31
7 | GI0018 | Hotel America | N342 | [NAME] | 2021-03-01 00:00:00 | 18 | 9.94 | 18 | 0.55
7 | GU0003 | Hotel America | N342 | [NAME] | 2021-03-19 00:00:00 | 215.28 | 46.88 | 215.28 | 0.22
7 | HJ0002 | Hotel America | N342 | [NAME] | 2021-04-06 00:00:00 | 60.58 | 13.24 | 60.58 | 0.22
7 | HJ0002 | Hotel America | N342 | [NAME] | 2021-04-24 00:00:00 | 32 | 7.31 | 32 | 0.23
7 | HJ0002 | Hotel America | N342 | [NAME] | 2021-05-12 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: 821147d1678465566-formula-help-next-available-record-with-conditions-lhs-tool-revised
Sheet: In House Mod Use

 | 108
 |  |  |  | 2 Trucks sitting in the yard | 9 |  | 9 |  |  |  |  |  |  | Total Trays Needed at all times in-house
 | 108 |  |  |  |  |  |  |  |  |  |  |  |  | Total Mods needed at all time in-house
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Trailers needed at all time in-house
 |  |  |  |  |  |  |  |  |  |  |  | Takes 2.5 minutes to lift stack and move to slot 14 |  | Farms bein loaded simultaneously | 2
 |  |  |  |  |  |  |  |  |  |  |  | Takes 1.75 minutes to load truck |  | Number of Trailers needed for a farm | 5
 |  |  |  |  |  |  |  |  |  |  |  | Takes 2 minutes to pull skates back in |  | Number of trailers needed for simultaneous loading
 |  |  |  |  |  |  |  |  |  |  |  | Takes 1 minute to shut overhead door and lower roof on trailer
 |  |  |  |  |  |  |  |  |  |  |  | Takes 4 minutes to strap truck, unhook from wall and shut doors |  | Total trailers needed
 |  |  |  | Red dotted line ([NAME]) |  |  |  |  |  |  |  |  |  | Chain speed | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Avg. birds/mod
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Trays/Minute
 |  |  |  |  |  | 4 |  |  |  |  |  |  |  | Minutes/Stack
 |  |  |  |  |  | 5 |  |  |  |  |  |  |  | Minutes/Trailer
 |  |  |  |  |  | 6 |  |  |  |  |  |  |  | Minutes before skates are available
 |  |  |  |  |  | 7 |  |  |  |  |  |  |  | Minutes before next 2 trailers needs to be in the yard
 |  |  |  |  |  | 8
 |  |  |  |  |  | 9 |  |  |  |  |  |  |  | Longest yard time while running (Hours)
 |  |  |  |  |  | 10
 |  |  |  |  |  | 11
 |  |  |  |  |  | 12
 |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  | These are the stacks produced while loading truck
 |  |  |  | Cross-Over Lane
 |  |  |  | Destacker
 |  |  |  |  |  |  |  |  |  |  |  | Stacker (Takes 3.5 minutes to stack full stack at 140
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | Green Dotted Line (SIA Chamber)
 |  |  |  | 140 chainspeed it took 6 minutes and 30 seconds for a tray to pass through tunnel from start to finish, apprx. 2.5 trays per minute.
 |  |  |  |  |  |  |  |  |  |  |  | Blue dotted line (Wash Tunnel)
 |  |  |  |  |  |  |  |  |  |  |  | Wash tunnel takes 1 minute and 15 seconds for tray to pass through @ 140
 |  |  |  |  |  |  |  |  |  |  |  | Orange Dotted line (Hanging Pit)
Spreadsheet: 83c6653b-7205-42e5-ba04-64ca1f60ba7e
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
GENTT | Test | GENTT | Gentamicin, Trough, Serum | Gentamicin, Trough, S | Enzyme-Multiplied Immunoassay Technique (EMIT) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Collection Container/Tube: Red top Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions: 1. Draw specimen no more than 30 minutes before next scheduled dose.  2. Spin down within 2 hours of draw. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | <2.0 mcg/mL | Monday through Sunday; Varies | Same day/1 day | 2 days | 1 | 80170 |  |  |  |  | Rochester
GENTT | [NAME] | SRED | Serum Red |  |  |  | Frozen | 14 days
GENTT | Result | 6795 | Gentamicin, Trough, S | Gentamicin, Trough, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 3665-7
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-066,069

 |  |  |  |  |  |  |  | 9-066   9-069
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY
Spreadsheet: 821572d1678800168-additional-criteria-to-a-maxifs-formula-last-checked-example-workbook
Sheet: Last checked

 |  | Check 1 | Check 2 | Check 3 | Check 4
 | Name | Check 1 - latest completed | Check 2 - latest completed | Check 3 - latest completed | Check 4 - latest completed
 | [NAME]
 | [NAME]
 | [NAME]
Spreadsheet: michelle_lokay__26561__imbalsumm0012
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 21055 | 19223 | 10745 | 10000
2 | 21202 | 19584 | 10722 | 10000
3 | 17314 | 17788 | 10773 | 10000
4 | 27334 | 19584 | 10003 | 10000
5 | 30871 | 33371 | 10556 | 10500
6 | 31042 | 29250 | 9009 | 10500
7 | 31704 | 34250 | 9973 | 10500
8 | 31619 | 34219 | 9894 | 10000
9 | 31577 | 30678 | 11348 | 8750
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  |  |  |  |  |  |  | -532429.6
2000-12-09 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 757495d1638292424-get-results-from-large-data-in-excel-o365-tracking
Sheet: All Count

Target | Count |  | Total
Office365_MFA_Login-issue
Office365_MFA_Reset
Office365_MFA_Changings
Office365_MFA_Assistance
Office365_MFA_Problem
Office365_MFA_Configuration
Office365_SharePoint_Login-issue
Office365_SharePoint_TeamSite
Office365_SharePoint_Assistance
Office365_SharePoint_Problem
Office365_Teams_Login-issue
Office365_Teams_Calendar
Office365_Teams_Meeting
Office365_Teams_Audio
Office365_Teams_Mobile-Installation
Office365_Teams_Mobile-access
Office365_Teams_Assistance
Office365_Teams_Problem
Office365_OneDrive_Login-issue
Office365_OneDrive_FileExplorer
Office365_Update-issue
Office365_OneDrive_Share
Office365_OneDrive_Assistance
Office365_OneDrive_Problem
Office365_Outlook_Mobile
Office365_Outlook_Assistance
Office365_Outlook_Problem
Office365_InfoPath_Installation
Office365_InfoPath_Problem
Office365_OneNote_Assistance
Office365_OneNote_Problem
Office365_Powerpoint_Assistance
Office365_Powerpoint_Problem
Office365_Excel_Assistance
Office365_Excel_Problem
Office365_Word_Assistance
Office365_Word_Problem
Office365_Login-issue_BE
Office365_Login-issue_NL
Office365_Planner
Office365_Whiteboard
Office365_to-do
Office365_ AVC_Shared-link
Office365_Missing-upgrade
Office365_Edge
Office365_AIP_Assistance
Office365_Assistance
Office365_Problem
Office365_Support-Questions
Spreadsheet: 759592d1639603428-return-value-if-target-date-is-in-between-values-test
Sheet: Sheet1

 |  |  | Start Window: | 2021-11-29 00:00:00
 |  |  |  |  |  | WK 1 | WK 2 | WK 3 | WK 4 | WK 5 | WK 6 | WK 7 | WK 8 | WK 9 | WK 10 | WK 11 | WK 12 | WK 13 | WK 14 | WK 15 | WK 16 | WK 17 | WK 18 | WK 19 | WK 20 | WK 21 | WK 22 | WK 23 | WK 24 | WK 25 | WK 26 | WK 27 | WK 28
Task ID | Asset | Description | Duration | Start Date | End Date
1 | Tooling | Task 1 | 15 | 2021-12-12 00:00:00
2 | Robotics | Task 2 | 20
3 | FMS | Task 3 | 4
Spreadsheet: 1ea2336d-069a-4a70-945f-89507588e897
Sheet: Sheet1

ALPHA HOMEROOM LISTINGS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
STUDENT'S NAME BEGINS WITH | Through | STUDENT'S NAME ENDS WITH | ALPHA HOMEROOM BY ROOM NUMBER
[NAME], F. | thru | Adhikari, D | 104
Adhikari, H | thru | [NAME], I | 112
[NAME], N | thru | Almoteie, M | 114
Almoumineen, S | thru | Arzadon, S | 116
Arzate, J | thru | [NAME], B | 118
Barranco, A | thru | Berrios, A | 120
Berrios, K | thru | [NAME], J | 122
Bowie, K | thru | Brown, L | 124
Brown, M | thru | Canedo, F | 123
Canedo, S | thru | Caveny, C | 126
Cawl, S | thru | Cole, N | 127
Coleman, A | thru | Crosby, T | 128
Crotty, P | thru | [NAME], J | 131
[NAME], K | thru | Dheyauldeen, [NAME] | 135
Dheyauldeen, [NAME] | thru | Doski, P | 133
Dosky, H | thru | Emerson, A | 132
Emin, S | thru | Ferari, A | 134
Ferreira, K | thru | Fudge, K | 136
Funderburke, C | thru | [NAME], M | 138
[NAME], N | thru | [NAME], R | 139
Gillespie, C | thru | Gretton, S | 141
Griffin, M | thru | Hall, A | 253
If your name falls between two rooms, go to the first room
ALPHA HOMEROOM LISTINGS
STUDENT'S NAME BEGINS WITH | Through | STUDENT'S NAME ENDS WITH | ALPHA HOMEROOM BY ROOM NUMBER
Hall, H | thru | Hauter, O | 252
Hauter, S | thru | Hixson, J | 250
Ho, H | thru | Ibrahim, R | 251
Ibrahim, S | thru | Jimenez, M | 248
[NAME], D | thru | [NAME], H | 247
Kantack, J | thru | King, J | 246
King, O | thru | Langley, S | 245
Lara Berrios, O | thru | Llorens, F | 224
Llorens, L | thru | Lusk, C | 226
Lusk, K | thru | Marroquin, G | 228
Marroquin, J | thru | McBride, J | 227
McBroom, H | thru | Melina, S | 229
Mendez, J | thru | Mohamed, S | 230
Mohammed, B | thru | [NAME], D | 231
Morelos, A | thru | Munoz, A | 232
Munoz, Y | thru | [NAME], R | 222
Nguyen, S | thru | Orellana, K | 219
Orozco, E | thru | Palmer, M | 220
Palomino, J | thru | [NAME], T | 218
Paw, S | thru | Perkins, E | 216
[NAME], G | thru | Pyle, R | 210
[NAME], L | thru | Randle, D | 207
If your name falls between two rooms, go to the first room
ALPHA HOMEROOM LISTINGS
STUDENT'S NAME BEGINS WITH | Through | STUDENT'S NAME ENDS WITH | ALPHA HOMEROOM BY ROOM NUMBER
Randle, L | thru | Rico, S | 206
Riek, G | thru | Rodriguez, S | 205
Rodriguez, Y | thru | [NAME], F | 204
Said, M | thru | Sarki, A | 203
Sarki, B | thru | Shaw, C | 202
Shaw-Davis, D | thru | Singh, B | TA101
Singh, M | thru | Stallings, B | TA106
Stanley, J | thru | Sulaiman, N | TA112
[NAME], Y | thru | [NAME], K | TA114
[NAME], S | thru | Tling, N | TA212
Toe, T | thru | [NAME], A | [NAME]
Upshaw, C | thru | Vielhauer, C | TA214
Vilchiz-Sanc, L | thru | Weatherford, C | TA224
Weatherford, L | thru | Wills, N | TA227
Wilson, C | thru | Yousef-Zadeh, N | TA221
Yugusuk, K | thru | Zukanovic, L | TA220
If your name falls between two rooms, go to the first room
Spreadsheet: 827000d1682427084-vba-filter-got-issue-i-getting-value-approver-v1
Sheet: Reference

Designation |  |  | Limited |  |  | Please Select
Please select designation from this dropdown
Director |  |  | 3000
Senior Deputy Director |  |  | 10000
Senior Deputy Director, Procurement |  |  | 10000
Deputy CIO / Director, Platforms & Ops Management (For IT assets only) |  |  | 20000
Divisional Director, Finance and Procurement |  |  | 20000
Chief Procurement Officer |  |  | 20000
Director, Media Design for Learning |  |  | 20000
Director, Platforms & Ops Management |  |  | 20000
Deputy Secretary (Services) |  |  | 50000
Permanent Secretary |  |  | 100000
Senior Minister of State |  |  | 250000
Minister of State |  |  | 250000
Minister |  |  | Unlimited
Spreadsheet: 145427d1331577652-vlookup-example
Sheet: Sheet1

Search Context | Account |  |  | Keyword | Result Account
@travelersie OR "travelers insurance"~2 OR "travelers.com" OR TRV_insurance OR TRV_service OR asktravelers OR "Travelers auto insurance"~3 OR "travelers home"~2 OR "travelers claim"~2 | Trial - Digitas |  |  | travelers insurance
travelers ("insurance"~2 OR "cat burglar commercial") OR TRV_insurance OR travelersgroup NOT (travel OR airport OR hotel OR airlines OR trip OR medical OR international OR gamethread) | Trial - Digitas |  |  | bridgestone
@TRV_insurance OR @TRV_service OR "Travelers insurance"~10 OR travelers.com OR "cat burglar" | Trial - Digitas |  |  | AirTran
travelers ("insurance"~5 OR "umbrella"~2 OR "cat burglar" OR "dog") OR travelersgroup OR trv_insurance NOT (vacation OR trip OR travel OR travelers' OR international OR gamethread OR hotel OR airlines OR visit) | Trial - Digitas |  |  | my cosmetics
(bridgestone*) (tire OR tires) -cheap* -"buy online" -"call now" -"click here" -"toll free" -"list price" -"sale price" -"on sale" -"week of" | Trial - Michelin |  |  | cooper
(continental) (tire OR tires) -cheap* -"buy online" -"call now" -"click here" -"toll free" -"list price" -"sale price" -"on sale" -"week of" | Trial - Michelin
(cooper OR coopers) (tire OR tires) -cheap* -"buy online" -"call now" -"click here" -"toll free" -"list price" -"sale price" -"on sale" -"week of" | Trial - Michelin
SiteDomain:corvetteforum?com AND (tire OR tires) | Trial - Michelin
marykay | Trial - [NAME]
"my makeup" OR "apply makeup" OR "my cosmetics" OR "my skincare" | Trial - [NAME]
What I need to do is take the keyword and find it in the search context. Once it has been found in the search context(column A) I need it to take the value from column B(account) on the same row and put that on the same row as the keyword in result account. Essentially I am matching what client are search for which keywords. Let me know if you have any addition questions.
Spreadsheet: 130069d1322054018-special-counting-how-to-do-forum
Sheet: 1

text1 | 1 | 2 | 3 | 4 | 5 | 6
text2 | 3 | 4 | 5 | 6 | 7 | 8
text3 | 5 | 6 | 7 | 9 | 8 | 8
Spreadsheet: 871991d1718362313-combining-cells-over-sheets-and-keeping-conditional-formatting-example-sheet-8-aligw
Sheet: Sheet2

 | STAGE
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
A |  | [NAME] | [NAME] Craig | [NAME] | [NAME] | [NAME] | [NAME] Andrews | Darcy Spencer | [NAME] | [NAME]
B
C
D
E
F
G
H
J
K
L
M
Spreadsheet: 586327d1534322735-report-and-email-automation-button-report-aging-aug-2018
Sheet: Stockonhand

Item Code | Item Name | Item Description | Expired Date | First GR | Last GR | First GI | Last GI | PIC | Organization | Rack | Warehouse Code | [NAME] | Qty Good | [NAME] | Qty Quarantine
2014-00002718 | Pusher | None | 2019-12-31 00:00:00 | 2015-11-28 00:00:00 | 2017-12-29 00:00:00 | 2016-04-09 00:00:00 | 2018-08-02 00:00:00 | Ari | Sales |  | WH0 | Duri | 80 | 0 | 0
2017-158098 | Lighter | Lighter: Black, Thumbplate : Black, Bottom :Black, Finishing :Black Decoration: Full Wrapped Sticker DJEEP Soft Touch© , Option: 2 FWS options | 2017-12-31 00:00:00 | 2017-10-19 00:00:00 | 2017-10-19 00:00:00 |  |  | Ziko | Marketing |  | WH0 | Duri | 22 | 0 | 0
2015-[PHONE] | Cabinet | Cabinet Gen 2 | 2020-12-31 00:00:00 | 2017-08-14 00:00:00 | 2017-10-04 00:00:00 | 2017-10-05 00:00:00 | 2017-10-05 00:00:00 | [NAME] | Sales |  | WH0 | Duri | 1 | 1 | 0
2017-[PHONE] | Wedges size 36 | [NAME] | 2018-04-30 00:00:00 | 2017-06-06 00:00:00 | 2017-06-06 00:00:00 | 2017-09-22 00:00:00 | 2017-09-22 00:00:00 | Mc Yar | Marketing |  | WH0 | Duri | 8 | 0 | 0
2016-00000816 | Wedges size 38 | Full Black Color | 2019-02-10 00:00:00 | 2017-10-24 00:00:00 | 2017-11-09 00:00:00 | 2017-10-31 00:00:00 | 2017-10-31 00:00:00 | Mc Yar | Marketing |  | WH0 | Duri | 7 | 0 | 0
2017-[PHONE] | Pack Display Premium |  | 2017-12-31 00:00:00 | 2017-06-13 00:00:00 | 2017-06-13 00:00:00 |  |  | Mc Yar | Marketing |  | WH0 | Duri | 2 | 0 | 0
Spreadsheet: 804481d1668098416-extract-data-from-12-different-sheets-into-one-single-column-without-vba-and-powerquerry-test
Sheet: Style Detail

S.# | Style No. | Style No.
1
2
3
4
5
6
7
8
9
10
11
12
Spreadsheet: 219127d1362672012-help-with-a-formula-function-if-its-possible-admit-dc-2013
Sheet: 6

Admission and Discharges
2013
Date: | 2013-01-06 00:00:00
ADMISSIONS |  |  |  |  |  |  | DISCHARGES
Room # | Name | Time | From | Status | Telemetry Box # |  | Room # | Name | Time | To
302 | z | 10:20:00 | ED |  |  |  | 216 | a | 13:10:00
IC06 | x | 12:55:00 | ED |  |  |  | 218 | s | 13:20:00
209 | y | 13:45:00 | ED |  |  |  | 316 | d | 14:20:00
306 | b | 12:30:00 | ED |  |  |  | IC08 | f | 13:30:00
307 | a | 11:52:00 | ED |  |  |  | 336 | g | 14:20:00
315 | c | 13:10:00 | ED |  |  |  | 210 | h | 10:00:00
330 | d | 13:20:00 | ED |  |  |  | 302 | j | 17:00:00
205 | t | 14:20:00 | ED
215 | y | 13:30:00 | ED
335 | u | 14:20:00 | ED
206 | i | 10:00:00 | ED
333 | o | 17:00:00 | ED
 | How many admits: 0001-0200: | 0 | How many  From ED | How many inpt | Total # Admits |  |  | How many admits: 0001-0200: | 0 | Total #  Discharges
 | How many admits: 0201-0400: | 0 | 12 | 0 | 12 |  |  | How many admits: 0201-0400: | 0 | 7
 | How many admits: 0401-0600: | 0 | How many  From CDU | How many obs |  |  |  | How many admits: 0401-0600: | 0
 | How many admits: 0601-0800: | 0 | 0 | 0 |  |  |  | How many admits: 0601-0800: | 0
 | How many admits: 0801-1000: | 1 | How many from ASU |  |  |  |  | How many admits: 0801-1000: | 1
 | How many admits: 1001-1200: | 2 | 0 |  |  |  |  | How many admits: 1001-1200: | 0
 | How many admits: 1201-1400: | 6 | How many from OR |  |  |  |  | How many admits: 1201-1400: | 3
 | How many admits: 1401-1600: | 2 | 0 |  |  |  |  | How many admits: 1401-1600: | 2
 | How many admits: 1601-1800: | 1 | How many from CV |  |  |  |  | How many admits: 1601-1800: | 1
 | How many admits: 1801-2000: | 0 | 0 |  |  |  |  | How many admits: 1801-2000: | 0
 | How many admits: 2001-2200: | 0 | How many DA |  |  |  |  | How many admits: 2001-2200: | 0
 | How many admits: 2201-2400: | 0 | 0 |  |  |  |  | How many admits: 2201-2400: | 0
ROOM TRANSFERS |  |  |  |  |  |  | TELEMETRY - ON / OFF
Room # | Name | To Room # |  |  |  |  | Room# | Name | On/Off | Box #
 | Maloney
Spreadsheet: theresa_staab__39637__Enron Statement_1001
Sheet: Enron Fuel Sale

 |  | Supply Verification |  | [NAME] To: |  | Remit To:
 |  |  |  |  |  |  | Verification Date:
 |  | NET OUT SETTLEMENT |  | Crestone Gathering Services |  | Enron North America Corp. | 2001-11-16 00:00:00
 |  |  |  | 1400 16th Street
 |  |  |  | Suite 310 |  |  | Due Date:
 |  |  |  | Denver, CO  80202 |  |  | 2001-11-26 00:00:00
 |  |  |  |  |  |  | Payment Method:
 |  |  |  | Contact:  [NAME] |  | Contact:  [NAME] | Wire
 |  |  |  | Tel: (720) 946-3692 |  | Tel:  (303) 575-6465 | Terms:
Crestone Gathering Services, L.L.C. |  |  |  | Fax: (720) 946-3640 |  | Fax: (303) 534-0552
Delivery Period:
2001-10-01 00:00:00
 | Supply |  |  | Mmbtu | Price/MMBtu |  | Amount Due
 | Fuel / LUAF | [NAME] to Crestone Gathering Services |  | 17185.19712724316 | 1.7634 |  | 30304.37661418059
 |  |  |  |  |  | Sub Total: |  | 30304.37661418059
 | Imbalance Sale | Crestone Gathering Services Sale to ENA |  | 0 | 1.7634 |  | 0
 |  |  |  |  |  | Sub Total: |  | 0
 |  |  |  |  |  | TOTAL DUE: |  | 30304.37661418059
Spreadsheet: 2e07ff51-59d0-4da3-8b70-c5fd5526d29d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-08-01 09:36:10.770000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.768 | 101.643 | 101.518 | 101.143
4.625 | 101.175 | 101.05 | 100.925 | 100.55 |  | Note: | Refer To Price [NAME]
4.5 | 100.683 | 100.558 | 100.433 | 100.058 |  |  | For all Price Adjs
4.375 | 100.111 | 99.986 | 99.861
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.875 | 101.75 | 101.625 | 101.25
4 | 101.566 | 101.441 | 101.316 | 100.941
3.875 | 101.173 | 101.048 | 100.923 | 100.548
3.75 | 100.619 | 100.494 | 100.369 | 99.994
3.625 | 99.696 | 99.571 | 99.446
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-08-15 09:36:10.770000
30 DAY | 2011-08-30 09:36:10.770000
45 DAY | 2011-09-14 09:36:10.770000
60 DAY | 2011-09-29 09:36:10.770000
90 DAY | 2011-10-29 09:36:10.770000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.