tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kate_symes__19007__Palo
Sheet: DJ Palo Verde 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-04-03 00:00:00 |  | 232.48 | 34768 | 101.7 | 8424
 | 2001-04-02 00:00:00 |  | 234.1 | 20032 | 134.92 | 8456 | 151.72 | 5836 | 152.21 | 1055
 | 2001-04-01 00:00:00 |  | 150 | 800 | 130 | 0 | 169.97 | 4993 | 179.55 | 3133 |  | 136.89 | 20112
 | 2001-03-31 00:00:00 |  | 155.24 | 26800 | 79.32 | 5000 | 203.27 | 4434 | 161.69 | 2164
 | 2001-03-30 00:00:00 |  | 155.24 | 26800 | 78.68 | 5600 | 166.55 | 6883 | 125.76 | 3604
 | 2001-03-29 00:00:00 |  | 149.29 | 27472 | 74.97 | 7680 | 151.01 | 3119 | 106.73 | 2737
 | 2001-03-28 00:00:00 |  | 117.91 | 28384 | 64.05 | 8795 | 135.59 | 5365 | 79.21 | 2138
 | 2001-03-27 00:00:00 |  | 107.14 | 26352 | 54.09 | 6800 | 138.05 | 5768 | 73.14 | 3889
 | 2001-03-26 00:00:00 |  | 280.53 | 20768 | 160.99 | 5520 | 115.17 | 3547 | 66.57 | 2059
 | 2001-03-25 00:00:00 |  | 200 | 0 | 135 | 200 | 80.99 | 1643 | 75.59 | 545 |  | 162.46 | 16560
 | 2001-03-24 00:00:00 |  | 233.04 | 14608 | 130.51 | 4880 | 130 | 6097 | 179.92 | 3350
 | 2001-03-23 00:00:00 |  | 233.24 | 14448 | 130.51 | 4880 | 324.97 | 6129 | 242.2 | 3200
 | 2001-03-22 00:00:00 |  | 281.29 | 18448 | 160.38 | 5360 | 385.71 | 8040 | 282.16 | 2915
 | 2001-03-21 00:00:00 |  | 460.02 | 24848 | 198.73 | 8120 | 350.98 | 4786 | 253.67 | 1853
 | 2001-03-20 00:00:00 |  | 377.03 | 18384 | 176.12 | 5120 | 390.83 | 2452 | 357.57 | 1668
 | 2001-03-19 00:00:00 |  | 297.33 | 24848 | 176.6 | 9000 | 258.33 | 3388 | 199.67 | 2448
 | 2001-03-18 00:00:00 |  | 220 | 0 | 185 | 0 | 170.47 | 4949 | 156.95 | 2582 |  | 178.66 | 28200
 | 2001-03-17 00:00:00 |  | 195.41 | 17152 | 121.88 | 8832 | 191.77 | 10872 | 180.55 | 1883
 | 2001-03-16 00:00:00 |  | 195.98 | 16352 | 121.88 | 8832 | 219.02 | 5921 | 173.76 | 3142
 | 2001-03-15 00:00:00 |  | 180.19 | 17472 | 98.04 | 5160 | 188.69 | 6005 | 136.45 | 3320
 | 2001-03-14 00:00:00 |  | 162.56 | 17184 | 81.84 | 6960 | 194.59 | 4065 | 117.41 | 1400
 | 2001-03-13 00:00:00 |  | 157.46 | 17840 | 69.39 | 7288 | 171.29 | 4137 | 134.75 | 1330
 | 2001-03-12 00:00:00 |  | 166.55 | 12544 | 91.58 | 6920 | 186.95 | 2928 | 114.77 | 1215
 | 2001-03-11 00:00:00 |  | 163 | 3200 | 90 | 1600 | 104.25 | 1435 | 110.05 | 945 |  | 93.34 | 17760
 | 2001-03-10 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 109.79 | 3007 | 124.99 | 2735
 | 2001-03-09 00:00:00 |  | 148.73 | 18400 | 66.56 | 5864 | 175.73 | 6415 | 122.41 | 1756
 | 2001-03-08 00:00:00 |  | 185.11 | 22848 | 92.66 | 8640 | 191.53 | 4219 | 145.14 | 1004
 | 2001-03-07 00:00:00 |  | 300.27 | 25616 | 169.6 | 6824 | 225.26 | 4337 | 151.01 | 1201
 | 2001-03-06 00:00:00 |  | 309.17 | 20320 | 175.44 | 6728 | 215.32 | 7762 | 192.69 | 3047
 | 2001-03-05 00:00:00 |  | 276.65 | 9792 | 162.76 | 4656 | 215.88 | 4042 | 160.99 | 832
 | 2001-03-04 00:00:00 |  | 240 | 800 | 165 | 0 | 168.1 | 2613 | 141.45 | 365 |  | 163.88 | 14568
Spreadsheet: sara_shackleton__36804__SAP WORKORDERS(CC105657)
Sheet: PU-CG Mapping

Cost Category | Property Unit | Description |  | WBS Element
Leasehold Improvement Project
 |  | Build Out
MATL | 08608 | Material |  | .01.01
DLAB | 08608 | Labor |  | .01.02
OTHR | 08608 | Other |  | .01.03
 |  | Office Furniture/Equipment
MATL | 56800 | Material |  | .02.01
DLAB | 56800 | Labor |  | .02.02
OTHR | 56800 | Other |  | .02.03
 |  | Communications Equipment
MATL | 12000 or 12005 | Material |  | .03.01
DLAB | 12000 or 12005 | Labor |  | .03.02
OTHR | 12000 or 12005 | Other |  | .03.03
 |  | Computer Equipment
MATL | 14000 | Computer Hardware |  | .04.01.01
MATL | 99902 | Computer Software |  | .04.01.02
DLAB | 14000 or 99902 | Labor |  | .04.02
OTHR | 14000 or 99902 | Other |  | .04.03
 |  | Other Expenses
OTHR or TRVL | 99902 | Travel |  | .05.01
OTHR | 99902 | Meals |  | .05.02
OTHR | 99902 | Other |  | .05.03
IT Project
 |  | Design Phase
SVCS | 99902 | Professional Consultant |  | .21.01
SVCS | 99902 | Other Contractor |  | .21.02
DLAB | 99902 | Enron IT |  | .21.03
OTHR | 99902 | Group Meals & Entertainment |  | .21.05.01
OTHR | 99902 | Client Meals & Entertainment |  | .21.05.02
OTHR | 99902 | Overtime Working Meals |  | .21.05.03
OTHR | 99902 | Other Expenditures |  | .21.05.04
 |  | Development Phase
SVCS | 99902 | Professional Consultant |  | .22.01
SVCS | 99902 | Other Contractor |  | .22.02
DLAB | 99902 | Enron IT |  | .22.03
OTHR | 99902 | Group Meals & Entertainment |  | .22.05.01
OTHR | 99902 | Client Meals & Entertainment |  | .22.05.02
OTHR | 99902 | Overtime Working Meals |  | .22.05.03
OTHR | 99902 | Other Expendatures |  | .22.05.04
 |  | Training & Conversion Phase
SVCS | 99902 | Professional Consultant |  | .23.01
SVCS | 99902 | Other Contractor |  | .23.02
DLAB | 99902 | Enron IT |  | .23.03
OTHR | 99902 | Group Meals & Entertainment |  | .23.05.01
OTHR | 99902 | Client Meals & Entertainment |  | .23.05.02
OTHR | 99902 | Overtime Working Meals |  | .23.05.03
OTHR | 99902 | Other Expendatures |  | .23.05.04
 |  | Materials
 |  | Hardware
MATL | 14000 | Computer |  | .24.01.01
MATL | 14000 | Printer |  | .24.01.02
MATL | 14000 | Monitor |  | .24.01.03
MATL | 14000 | Server |  | .24.01.04
MATL | 14000 | Cables |  | .24.01.05
MATL | 14000 | Other |  | .24.01.06
 |  | Software
MATL | 99902 | [NAME] |  | .24.02.01
MATL | 99902 | Other |  | .24.02.02
Expense Project
OTHR |  | Other |  | .01
TRVL |  | Travel |  | .01
ENTR |  | Entertainment |  | .01
OFSP |  | Office Supplies |  | .01
DLAB |  | Labor |  | .01
SVCS |  | Services |  | .01
LEGL |  | Legal |  | .01
COSU |  | Consulting |  | .01
ENGR |  | Engineering |  | .01
OEXP |  | Other |  | .01
Spreadsheet: 10688e21-50c7-42b3-9f2f-b7d2c537a667
Sheet: A

 | COURSES IN RED ARE GENERAL EDUCATION COURSES FOR FALL 2012 |  | PURPLE J-TERM        GREEN BOTH FALL & J-TERM
American Studies | AOK designation | CAR designation | comment
AMST 309 | Arts & Literature-Literature |  | cross-listed with COMM 309 formerly AMST 310
AMST 350 | Arts & Literature-Literature
AMST 351 | Arts & Literature-Literature
AMST 355 | Arts & Literature-Arts
AMST 356 | Arts & Literature-Literature
AMST 357 | Arts & Literature-Literature
AMST 358 | Arts & Literature-Literature
Arabic
Arab 211-212 | Foreign Language
[NAME] | AOK designation | CAR designation | comment
ARTH 201 | Arts & Literature-Arts
ARTH 202 | Arts & Literature-Arts
ARTH 210 | Civilizations-History |  | counts as HIST101, cross-listed with CLAS 210
 | OR Arts & Literature-Arts | Non-Western
ARTH 211 | Arts & Literature-Arts | Non-Western | cross-listed with CLAS 211
 |  | Experiential-Travel | Travel J-term 2007
ARTH 212 | Arts & Literature-Arts |  | cross-listed with CLAS 212
ARTH 213 | Arts & Literature-Arts |  | cross-listed with CLAS 213
ARTH 214 | Arts & Literature-Arts |  | cross-listed with CLAS 214
ARTH 215 | Arts & Literature-Arts
ARTH 216 | Arts & Literature-Arts
ARTH 217 | Arts & Literature-Arts |  | cross-listed with CLAS 217
ARTH 218 | Arts & Literature-Arts | Experiential-Travel | cross-listed with CLAS 218; travel J-Term 2009
ARTH 219 | Arts & Literature-Arts
ARTH 221 | Arts & Literature-Arts
ARTH 222 | Arts & Literature-Arts | Experiential-Travel | Travel J-term 2007
ARTH 223 | Arts & Literature-Arts
ARTH 224 | Arts & Literature-Arts
ARTH 225 | Arts & Literature-Arts
ARTH 226 | Arts & Literature-Arts
ARTH 227 | Arts & Literature-Arts | Non-Western
ARTH 228 | Arts & Literature-Arts | Non-Western
ARTH 235 | Arts & Literature-Arts | Non-Western
ARTH 240 | Arts & Literature-Arts
ARTH 305 | Arts & Literature-Arts
ARTH 381 |  | Experiential-Research
ARTH 382 |  | Experiential-Research
ARTH 422 |  | Experiential-Research
Arts Management | AOK designation | CAR designation | comment
AMGT 441 |  | Experiential-Internship
Astronomy | AOK designation | CAR designation | comment
ASTR 101 | Natural & Mathematical Sciences-Nat Sci w Lab
ASTR 231 | Natural & Mathematical Sciences-Nat Sci w Lab |  | does not count as Lab
ASTR 232 | Natural & Mathematical Sciences-Nat Sci w Lab |  | does not count as Lab
Asian Studies | AOK designation | CAR designation | comment
ASTU 230 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 230
ASTU 231 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 231
ASTU 232 | Arts & Literature-Literature | Non-Western | cross-listed with FLET 232
ASTU 290 |  | Non-Western | cross-listed with HIST 290
ASTU 292 | Arts & Literature-Arts | Non-Western | cross-listed with FILM 292
ASTU 381 | Arts & Literature-Literature | Non-Western | Spring 2009 ([NAME])
ASTU 390 |  | Non-Western
ASTU 401 |  | Capstone
ASTU 450 |  | Experiential-Internship
ASTU 481 |  | Experiential-Research
ASTU 482 |  | Experiential-Research
Spreadsheet: 46ff0b08-2a85-49b6-892f-824d59c1cf95
Sheet: gender graph

back to tables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column Labels
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Values | Female | Male | Unknown | Grand Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY07-08# | 4386 | 2148 | 42 | 6576
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY08-09# | 4993 | 2478 | 81 | 7552
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY09-10# | 4584 | 2459 | 75 | 7118
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY10-11# | 4149 | 2288 | 73 | 6510
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AY11-12# | 3814 | 2246 | 60 | 6120
Spreadsheet: richard_ring__31583__Wind Meter for 12 01
Sheet: Wind Unit 1

[NAME] | TA_START | SumOfINTERVAL
GARNET1UNIT1 | 2001-12-01 00:01:00 | 0.3360000000000001
GARNET1UNIT1 | 2001-12-02 00:01:00 | 6.81
GARNET1UNIT1 | 2001-12-03 00:01:00 | 0
GARNET1UNIT1 | 2001-12-04 00:01:00 | 76.42800000000001
GARNET1UNIT1 | 2001-12-05 00:01:00 | 5.072999999999999
GARNET1UNIT1 | 2001-12-07 00:01:00 | 30.12100000000001
GARNET1UNIT1 | 2001-12-08 00:01:00 | 2.885999999999999
GARNET1UNIT1 | 2001-12-09 00:01:00 | 32.90900000000001
GARNET1UNIT1 | 2001-12-10 00:01:00 | 98.13999999999994
GARNET1UNIT1 | 2001-12-11 00:01:00 | 15.896
GARNET1UNIT1 | 2001-12-12 00:01:00 | 0
GARNET1UNIT1 | 2001-12-13 00:01:00 | 0
GARNET1UNIT1 | 2001-12-14 00:01:00 | 0
GARNET1UNIT1 | 2001-12-15 00:01:00 | 0
GARNET1UNIT1 | 2001-12-16 00:01:00 | 0
GARNET1UNIT1 | 2001-12-17 00:01:00 | 0
GARNET1UNIT1 | 2001-12-18 00:01:00 | 0
GARNET1UNIT1 | 2001-12-19 00:01:00 | 0
GARNET1UNIT1 | 2001-12-20 00:01:00 | 0
GARNET1UNIT1 | 2001-12-21 00:01:00 | 0
GARNET1UNIT1 | 2001-12-22 00:01:00 | 0
GARNET1UNIT1 | 2001-12-23 00:01:00 | 0
GARNET1UNIT1 | 2001-12-24 00:01:00 | 0
GARNET1UNIT1 | 2001-12-25 00:01:00 | 0
GARNET1UNIT1 | 2001-12-26 00:01:00 | 0
Total
Spreadsheet: jim_schwieger__14304__Bronco Playoff Schedule
Sheet: Sheet1

Bronco Maroon [NAME]
#1 Braves-Labay 8
WLY#5 @ 8:00pm | #1 Braves-Labay
#8 Marlins-Bleyl 6 |  | #1 Braves-Labay
 | Friday 5/18
 | BC#2 @ 8:00pm
#5 Cardinals-Hamilton
5/16 Wednesday | #5 Cardinals-Hamilton
BC#2 @ 8:00pm
#4 A's-Hamilton |  | Tuesday 5/22
 |  | WLY#5 @ 7:00pm
Game #1217
#3 Reds-Cook
5/16 Wednesday | #3 Reds-Cook
WLY#5 @ 6:00pm
#6 Dodgers-Truitt
 | Friday 5/18
 | BC#2 @ 6:00pm | #2 Angels-Arnold
#7 Astros-Campbell
5/16 Wednesday | #2 Angels-Arnold
BC#2 @ 6:00pm
#2 Angels-Arnold
Spreadsheet: 808867d1670719949-filter-function-how-to-condense-the-include-argument-unique-list-but-must-be-in-other-2-lists
Sheet: Sheet1

All Items | Tree | All Items | <- Drop-Down Box | Count of unique | Your Answer Below |  | Helper1 | Helper2
[NAME] | Plant
Bowl | Tree | Plant | Bowl |  | Bus |  | Bowl | Plant
Bus | Cat | Tree | Bus |  | Cat |  | Bus | Cat
Cat | Plant | Cat | Cat |  | Chair |  | Cat | Rabbit
Chair | Rabbit | Plant | Chair |  | Jacket |  | Chair | Jacket
Honey | Jacket | Rabbit | Honey |  | Key |  | Honey | Bus
Jacket | Bus | Jacket | Jacket |  | Orange |  | Jacket | Orange
Key | Plant | Bus | Key |  | Pants |  | Key | Chair
Orange | Orange | Plant | Orange |  | Plant |  | Orange | Key
Pants | Rabbit | Orange | Pants |  | Rabbit |  | Pants | Pants
Plant | Cat | Rabbit | Plant |  | Table |  | Plant | Table
Rabbit | Chair | Cat | Rabbit |  | Tree |  | Rabbit
Table | Orange | Chair | Table |  |  |  | Table
Tree | Orange | Orange | Tree |  |  |  | Tree
 | Key | Orange
 | Orange | Key
 | Pants | Orange
 | Chair | Pants
 | Rabbit | Chair
 | Rabbit | Rabbit
 | Cat | Rabbit
 | Rabbit | Cat
 | Table | Rabbit
 | Key | Table
 |  | Key
Spreadsheet: 857090d1706167594-group-array-items-monthly-based-on-start-and-finish-dates-group-array-based-on-start-and-finish-dates-excelforum-2501242
Sheet: Sheet1

Area | Process | Start | Finish
Area 1 | Production | 2023-01-01 00:00:00 | 2023-11-02 00:00:00
Area 1 | Assembly
Area 1 | Dispatch
Area 1 | Delivery
Area 2 | Production
Area 2 | Assembly
Area 2 | Dispatch
Area 2 | Delivery
 |  | Area 1 | Area 2
 | 2023-01-01 00:00:00 | Production
 | 2023-02-01 00:00:00 | Production
 | 2023-03-01 00:00:00 | Production
 | 2023-04-01 00:00:00 | Production
 | 2023-05-01 00:00:00 | Production
 | 2023-06-01 00:00:00 | Production
 | 2023-07-01 00:00:00 | Production
 | 2023-08-01 00:00:00 | Production
 | 2023-09-01 00:00:00 | Production
 | 2023-10-01 00:00:00 | Production
 | 2023-11-01 00:00:00 | Production
 |  | Assembly
 | 2023-12-01 00:00:00 | Assembly
 | 2024-01-01 00:00:00 | Dispatch
 | 2024-02-01 00:00:00 | Delivery
 | 45352 | Delivery
 | 45383 |  | Production
 | 45413 |  | Assembly
 | 45444 |  | Assembly
 | 45474 |  | Dispatch
 | 45505 |  | Delivery
 | 45536 |  | Delivery
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 | Area 1 | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production
 | Area 1 |  |  |  |  |  |  |  |  |  |  | Assembly | Assembly
 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch
 | Area 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Delivery | Delivery
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Assembly | Assembly
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dispatch
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Delivery | Delivery
 |  | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00
 | Area 1 | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production | Production Assembly | Assembly | Dispatch | Delivery | Delivery
 | Area 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Production | Assembly | Assembly | Dispatch | Delivery | Delivery
Spreadsheet: 185744d1349814857-extract-data-from-column-to-make-new-columns-book7
Sheet: Sheet1

ADULT-L | Adult | L
ADULT-M | Adult | M
ADULT-S | Adult | S
ADULTLG | Adult | LG
ADULTMED | Adult | MED
10.0M | 10.0 | M
2.5M | 2.5 | M
Spreadsheet: 249f24c7-362a-4e6a-a1c1-6db97da1d55b
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-05-13 11:23:54.070000
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.149 | 101.024 | 100.899 | 100.524
4.625 | 100.301 | 100.176 | 100.051 | 99.676 |  | Note: | Refer To Price [NAME]
4.5 | 99.829 | 99.704 | 99.579 | 99.204 |  |  | For all Price Adjs
4.375 | 99.22 | 99.095 | 98.97
 |  |  |  |  |  | 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.25 | 101.875 | 101.75 | 101.625 | 101.25
4.125 | 101.31 | 101.185 | 101.06 | 100.685
4 | 100.985 | 100.86 | 100.735 | 100.36
3.875 | 100.555 | 100.43 | 100.305 | 99.93
3.75 | 100.011 | 99.886 | 99.761
 |  |  |  |  |  | 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-05-27 11:23:54.070000
30 DAY | 2011-06-11 11:23:54.070000
45 DAY | 2011-06-26 11:23:54.070000
60 DAY | 2011-07-11 11:23:54.070000
90 DAY | 2011-08-10 11:23:54.070000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: Check

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - COMPREHENSIVE VARIANCE INTEGRITY CHECK
COMPANY:  ALL
REGION: ALL
PRODUCTION MONTH: 0004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | August
Regions | Consolidated Flash | DPR vs. Consol. [NAME] | DPR | Adj. To NGPL | Revised NGPL | Actuals | [NAME]
Central
Sithe
Aruba
Northeast | 0 |  | 0 |  | 0 | 0
East-EGM
East-MKT East
East-LRC
FT-East
Texas-EGM
Texas-HPLR
Texas-HPLC
FT-SouthTexas
West
Denver
FT - Denver
Storage
Ontario
FT-Ontario
BUG
Total Per Indiv. Tabs
Per TOTAL Tab
 |  |  |  |  |  |  | 0
Spreadsheet: 191172d1351956125-loan-repayment-formula-loan_repay
Sheet: Loan Repay

Grace Period | 6
 | [NAME]
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Principal | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150
 | Six Month Grace Period (this is what I need the table to look like if the right formula is used)
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Principal | 0 | 0 | 0 | 0 | 0 | 0 | 40 | 50 | 60 | 70 | 80 | 90 | 100 | 110 | 120 | 130 | 140 | 150
 | Six Month Grace Period (this is my attempt- please fix formula in yellow cell)
Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18
Principal
Spreadsheet: 146557d1332252348-how-to-create-a-rule-depending-on-date-periods-pt-hotel-rent-charge-variable-day-dollar
Sheet: Sheet1

Date | Room | Name | DayOfWeek | Price
 | 1 | [NAME] |  |  |  |  |  |  |  | Lookup Table showing Price for Room depending on day of week
 | 2 | Fred |  |  |  |  |  |  |  | Room\DOW | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 3 | [NAME] |  |  |  | Pivot Table showing Charge |  |  |  | 1 | 108 | 121 | 121 | 121 | 95 | 124 | 82
 | 4 | [NAME] |  |  |  |  |  |  |  | 2 | 99 | 93 | 86 | 127 | 111 | 101 | 138
 | 5 | [NAME] |  |  |  | Row Labels | Sum of Price |  |  | 3 | 117 | 104 | 103 | 119 | 110 | 83 | 124
 | 6 | Betty |  |  |  | Betty | 448 |  |  | 4 | 112 | 107 | 121 | 131 | 119 | 123 | 139
 | 7 | Marv |  |  |  | [NAME] | 423 |  |  | 5 | 107 | 81 | 112 | 92 | 81 | 86 | 106
 | 8 | Tyler |  |  |  | [NAME] | 410 |  |  | 6 | 105 | 106 | 118 | 131 | 134 | 84 | 85
 | 9 | Jeanne |  |  |  | Fred | 422 |  |  | 7 | 90 | 96 | 86 | 90 | 136 | 134 | 103
 | 10 | [NAME] |  |  |  | [NAME] | 418 |  |  | 8 | 118 | 96 | 122 | 104 | 133 | 103 | 122
 | 1 | [NAME] |  |  |  | Jeanne | 414 |  |  | 9 | 114 | 135 | 120 | 94 | 123 | 140 | 115
 | 2 | Betty |  |  |  | Marv | 431 |  |  | 10 | 92 | 89 | 122 | 80 | 118 | 87 | 129
 | 3 | Marv |  |  |  | [NAME] | 431
 | 4 | Tyler |  |  |  | [NAME] | 467
 | 5 | Jeanne |  |  |  | Tyler | 480
 | 6 | [NAME] |  |  |  | Grand Total | 4344
 | 7 | [NAME]
 | 8 | Fred
 | 9 | [NAME]
 | 10 | [NAME]
 | 1 | [NAME]
 | 2 | Betty
 | 3 | Marv
 | 4 | Tyler
 | 5 | Jeanne
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | Fred
 | 9 | [NAME]
 | 10 | [NAME]
 | 1 | [NAME]
 | 2 | Betty
 | 3 | Marv
 | 4 | Tyler
 | 5 | Jeanne
 | 6 | [NAME]
 | 7 | [NAME]
 | 8 | Fred
 | 9 | [NAME]
 | 10 | [NAME]
Spreadsheet: 131102d1322742298-index-match-ifand-and-max
Sheet: Sheet1

Month | Company | Ranking |  |  | Results |  |  |  |  |  |  | Helper column
2011-11-01 00:00:00 | YesMen | 1 |  |  | YesMen |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-11-01 00:00:00 | Plumbers Inc | 2 |  |  | Plumbers Inc |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-11-01 00:00:00 | Dell | 3 |  |  | Dell |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-11-01 00:00:00 | Water Co | 4 |  |  | Water Co |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-11-01 00:00:00 | Ice Digger | 5 |  |  | Ice Digger |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-10-01 00:00:00 | Water Co | 1 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-10-01 00:00:00 | Plumbers Inc | 2 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-10-01 00:00:00 | Ice Digger | 3 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-10-01 00:00:00 | Dell | 4 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-10-01 00:00:00 | YesMen | 5 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-09-01 00:00:00 | YesMen | 1 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-09-01 00:00:00 | Water Co | 2 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-09-01 00:00:00 | Ice Digger | 3 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-09-01 00:00:00 | Plumbers Inc | 4 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
2011-09-01 00:00:00 | Dell | 5 |  |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
Spreadsheet: 188838d1351005182-calculating-value-between-two-points-solar
Sheet: Yr End

2012 Report
Monthly Totals
 | Consumption / KW |  |  | Charges |  |  | Efficiency
 | Used | PG&E | Solar | Charges | Billed | Solar | Est | Actual
Jan | 693.39 | 326.01 | 367.38 | 84.8223987 | 46.29 | 38.53239869999999 | 302.307603686636 | 367.38
Feb | 784.43 | 236 | 548.43 | 100.7600335 | 35.17 | 65.5900335 | 449.3748609566185 | 548.43
Mar | 694.9399999999998 | 113 | 581.9399999999998 | 89.26504299999998 | 18.87 | 70.39504299999997 | 484.0021505376344 | 581.9399999999998
Apr | 724.7099999999999 | 121 | 603.7099999999999 | 93.0889995 | 20 | 73.0889995 | 300.5806451612903 | 603.7099999999999
May | 749.0400000000001 | 66 | 683.0400000000001 | 96.21418800000002 | 13.28 | 82.93418800000002 | 646.141935483871 | 683.0400000000001
Jun | 615.19 | 0 | 615.19 | 79.0211555 | -7.9 | 86.9211555 | 602.5032258064516 | 615.19
Jul | 1029.71 | 448 | 581.71 | 132.2662495 | 62.16 | 70.1062495 | 613.4516129032259 | 581.71
Aug | 2589.7 | 2010 | 579.7 | 563.03355582 | 376.99 | 186.04355582 | 631 | 579.7
Sep | 2004.66 | 1462 | 542.6600000000001 | #N/A | 207.53 | #N/A | 590.0967741935484 | 542.6600000000001
Oct | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Nov | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Dec | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Totals | 9885.77 | 4782.01 | 5103.759999999999 | #N/A | 772.39 | #N/A | 4619.458808729276 | 5103.759999999999
% Consumed |  | 0.483726609055238 | 0.5162733909447619 | [NAME] | #N/A | #N/A | 1.104839378663914 | Efficient