tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: 2nd 2003075

2nd Floor |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Sprite | 0.56
Coke | 0.56
Dr. [NAME] | 0.56
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
Broth, [NAME] | 0.1
Pudding-Vanilla | 0.27
Diet Vanilla Pudding | 0.35
[NAME] | 0.28
[NAME] | 1.13
Applesauce | 0.32
Juice Orange | 0.23
Juice Apple | 0.23
Juice Cranberry | 0.23
Honey | 0.07
Jam/Jelly ea | 0.06
[NAME] | 0.02
Mayo | 0.06
Mustard | 0.02
[NAME] | 0.16
Ranch Dressing | 0.4
Salt/Pepper | 0.02
Ice Cream-Vanilla | 0.41
Ice Cream- Diet-Vanilla | 0.43
Diet Popsicles | 0.25
Popcicles | 0.2
Milk, Whole | 0.25
2% Milk | 0.25
[NAME] | 25
Boxed Sandwiches | 2.5
[NAME] | 1.47
Coffee, [NAME]. cs.
Coffee Decaf | 37.84
Creamer, non dairy box | 0.03
Tea Bags | 0.03
hot chocolate | 0.5
Sugar | 0.02
Sweetner-Equal | 0.03
Sweetner-Splenda | 0.03
Sweetner-Sweet N Low | 0.02
Cups | 0.03
[NAME] | 10
Plastic Ware (fork,spoon knife) | 0.03
Plastic Wrap | 15
Straws | 1.75
vital | 3.05
Refrigerator Thermometer (reg.)
Monthly Coffee
Monthly Total
Spreadsheet: john_zufferli__16695__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Hedgeable Volume | Current Gas Hedges |  | AECO Basis Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (contracts/day) | (contracts/day) | % Hedged | (contracts/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25 |  |  | 11 |  | 11
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03 |  |  | 10.5 |  | 5
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9 |  |  | 9 |  | 5
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06 |  |  | 9 |  | 5
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5 |  |  | 9 |  | 4
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02 |  |  | 9 |  | 4
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09 |  |  | 9 |  | 4
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1 |  |  | 9 |  | 4
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14 |  |  | 9 |  | 4
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11 |  |  | 1 |  | 0
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08 |  |  | 1 |  | 0
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04 |  |  | 1 |  | 0
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03 |  |  | 1 |  | 0
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7 |  |  | 1 |  | 0
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7 |  |  | 0 |  | 0
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 722186d1615105309-countifs-equivalent-where-one-range-is-multiple-columns-crosstab-sandbox-1-count
Sheet: Sheet1

Selected | Gender | Ans1 | Ans2 | Ans3 | Ans4 |  |  | COUNT |  |  | CRITERIA
1 | M | 1 |  |  |  |  |  |  |  |  | ANS2 | F
1 | F | 1 | 2 | 3
1 | M | 1
1 | F | 1
0 | F | 1 | 3
1 | M | 2
1 | F | 2
0 | F | 2 | 3
1 | F | 2
0 | M | 2
1 | M | 1
1 | F | 1
1 | F | 1 | 2
1 | M | 1 | 2
0 | F | 1
1 | F | 4
1 | M | 1 | 3 | 4 | 5
1 | M | 1 | 3
1 | F | 1
Spreadsheet: 836596d1689515039-vba-auto-update-a-weekly-schedule-weeksched-2-
Sheet: Sheet1

 |  | Weely schedule
2023-07-17 14:00:00 | Client 1
2023-07-13 08:00:00 | Client 2
2023-07-20 11:30:00 | Client 3
2023-07-14 15:00:00 | Client 4
This should auto update to 07/20 08:00am when the current date (in A2) passes the date in cell A5
This should auto update to 07/21 3pm when the current date (in A2) passes the date in cell A7
Once the date in Column A passes the date in cell A2, I'm having to manually change the dates to 7 days later. For instance, the date in cell A5 needs to change to 07/20/2023 8:00am automatically.
Same for cell A7, this needs to update automatically to 07/21/2023 3pm instead having to manually change it.
Spreadsheet: 8e077aa3-b798-498d-b287-fac78be3ff21
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
[NAME] | Test | [NAME] | [NAME], Serum | [NAME], S | Nephelometry | Serum Gel Tube: SGT Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.5 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | 75-175 mg/dL | Monday through Saturday; 3 p.m. | Same day/1 day | 2 days | 1 | 86160 |  |  |  |  | Rochester
[NAME] | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
[NAME] | Result | [NAME] | [NAME], S | [NAME], S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 4485-9 | [NAME]:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 752235d1634659752-vlookup-stops-working-after-several-rows-po-workbook
Sheet: 1st CO  #

Project Name
Owner Direct Purchase Summary Log
PO # | VENDOR | CONTRACTOR | 2016-10-01 00:00:00 | TOTAL INVOICED | nontx | nontax | nontax | NON TAXABLE | TAXABLE AMT | TAXES | TOTAL CO
 |  | subtotals
 |  | Total Previously Invoiced | 0 |  |  |  |  |  | TOTAL CHANGE ORDER AMOUNT | -351520.54
Spreadsheet: 199729d1355311283-find-cell-refrence-book2
Sheet: Sheet1

 |  |  | serial 1 | serial 2 | serial 3
 |  | box-4 | OK4KCU | OK4KI0 | OK4LLS
 |  | box-4 | OK60ZD | OK62AP | OK62QU
 |  | box-4 | OK6TA5 | OK6TBP | OK6TFW
 |  | box-4 | OK7V0T | OK7WC4 | OK7WL1
 |  | box-4 | FOC | OK4827 | OK483E
 |  | box-4 | OKIA9L | OKIAEC | OKIAI9
 |  |  | OK7V0T | D6 | how do write cell ref D6 by applying excel formula
 |  |  | OK6TBP | E5
 |  |  | OK4LLS
Spreadsheet: 854939d1704705989-why-is-my-sum-if-not-working-stats-by-player-played
Sheet: Sheet1

 |  |  |  |  |  |  | OPPO | WIN | LOSS
2023-07-01 00:00:00 | 345 | 457 | doc |  |  |  | doc |  |  |  | 1 | 2 | 0.5
2023-07-01 00:00:00 | 288 | 522 | [NAME] |  |  |  | [NAME] |  |  |  | 0 | 0 | -1
2023-07-01 00:00:00 | 462 | 368 | hamisi |  |  |  | hamisi |  |  |  | 1 | 0 | 1
2023-07-01 00:00:00 | 438 | 432 | mich |  |  |  | mich |  |  |  | 1 | 0 | 1
2023-07-01 00:00:00 | 400 | 350 | bye |  |  |  | bye | 1 |  |  | 1 | 0 | 1
2023-07-01 00:00:00 | 426 | 407 | zomb |  |  |  | zomb | 1 |  |  | 1 | 0 | 1
2023-07-01 00:00:00 | 383 | 505 | toy |  |  |  | toy |  |  |  | 0 | 0 | -1
2023-07-01 00:00:00 | 224 | 549 | toy
2023-07-01 00:00:00 | 401 | 386 | doc
2023-07-01 00:00:00 | 254 | 602 | doc
Spreadsheet: 835716d1688747161-extract-list-of-months-between-two-condition-copy-of-001369
Sheet: one Year completed Staff

Employee ID | 001369 more than 1 year
Case : 1 | In current month employee making leave for future date
ESS Till date Leave days | 39
formula
Leave application | Submitting leave in Feb
Leave from | 2023-10-01 00:00:00
Leave Too | 2023-11-16 00:00:00
Applied Leave Days | 47
Future month
 | 31
 | 31
 | 28
Total
ESS leave allowance
Final Eligible leave
Spreadsheet: 875727d1722342355-using-formula-to-calculate-weighted-average-by-getting-numbers-from-multiple-sheets-weighted-average-revised-samyraj-
Sheet: Consolidated

 |  | Month |  | 2024-06-01 00:00:00 | 30 | days |  |  |  |  | Month |  | 2024-06-01 00:00:00 | 30 | 30 | 30 | 30
 |  |  |  |  |  |  |  | Division A PL |  |  |  |  |  | DIV A | DIV B | DIV C | Consolidated
 |  | Clients (Funded) |  |  |  |  |  | Division B PL |  |  | Clients (Funded) |  |  | 24 | 27 | 28
 |  | Weekly Avg Fees Achieved (Funded) |  |  |  | Weighted Average |  | Division C PL |  |  | Weekly Avg Fees Achieved (Funded) |  |  | 450 | 375 | 550
 |  | Clients non Funded |  |  |  |  |  |  |  |  | Clients non Funded |  |  | 17 | 15 | 22
 |  | Weekly Avg Fees Achieved (Private) |  |  |  | Weighted Average |  |  |  |  | Weekly Avg Fees Achieved (Private) |  |  | 900 | 850 | 750
 |  | Total Clients |  |  |  |  |  |  |  |  | Total Clients |  |  | 41
 |  | Fee Billed - Funded |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  | Fee Billed - non Funded |  |  |  |  |  |  |  |  | Fee Billed - non Funded
 |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - Funded
 |  |  |  |  |  |  |  |  |  |  | Fee Billed - non Funded
Spreadsheet: 467772d1466915387-nearest-date-for-multiple-criteria-sample-sales-data
Sheet: Sheet1

Data 1
Date | Party Name | Product | Vch No | Rate | Qty | Amt
2012-04-02 00:00:00 | ABC | A | 2 | 24 | 300
2012-04-03 00:00:00 | ABC | B | 3 | 25 | 200
2012-04-04 00:00:00 | ABC | C | 4 | 26 | 400
2012-04-05 00:00:00 | ABC | D | 5 | 27 | 500
Data 2
Date | Party Name | Product | Vch No | Rate | Qty | Amt
2012-04-01 00:00:00 | XYZ | A | 1 | 26 | 200
2012-04-06 00:00:00 | PQR | C | 10 | 28 | 300
2012-04-06 00:00:00 | POE | C | 10 | 28 | 300
2012-04-06 00:00:00 | RTY | D | 11 | 29 | 600
2012-04-06 00:00:00 | DFG | E | 13 | 30 | 500
 |  |  |  |  |  |  |  | Expected Result for Data 1 from Data 2
Data 1 |  |  |  |  |  |  |  | Nearest Date Trasaction with Same product
Date | Party Name | Product | Vch No | Rate | Qty | Amt |  | Date | Party Name | Product | Vch No | Rate | Qty | Amt
2012-04-02 00:00:00 | ABC | A | 2 | 24 | 300 |  |  | 2012-04-01 00:00:00 | XYZ | A | 1 | 26 | 200
2012-04-03 00:00:00 | ABC | B | 3 | 25 | 200 |  |  | 2012-04-01 00:00:00 | XYZ | A | 1 | 26 | 200
2012-04-05 00:00:00 | ABC | C | 4 | 26 | 400 |  |  | 2012-04-06 00:00:00 | PQR | C | 10 | 28 | 300 |  | All entries for product C
 |  |  |  |  |  |  |  | 2012-04-06 00:00:00 | POE | C | 10 | 28 | 300 |  | All entries for product C
2012-04-07 00:00:00 | ABC | D | 5 | 27 | 500 |  |  | 2012-04-06 00:00:00 | RTY | D | 11 | 29 | 600
Spreadsheet: kate_symes__18244__DJ Index 3-29
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-03-29 00:00:00
Flow Date: | 2001-03-29 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4452 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 187.5 | 1600
 | Firm Trades Purchases | 185 | 1200
[NAME] | Firm Trades Sales | 112.8977272727273 | 1408
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 187.8 | 4000
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 133.75 | 1600
 | Firm Trades Purchases | 125 | 400
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 149.8070967741936 | 12400
 | Firm Trades Purchases | 151 | 3200
[NAME] | Firm Trades Sales | 78.08333333333333 | 1800
 | Firm Trades Purchases | #[NAME]! | 0
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 145 | 400
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 105 | 400
 | Firm Trades Purchases | #[NAME]! | 0
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 175.0122249388753 | 6544
 | Firm Trades Purchases | 172.1052631578947 | 1520
[NAME] | Firm Trades Sales | 92.02090592334494 | 2296
 | Firm Trades Purchases | 90.5 | 800
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 164.25 | 1600
 | Firm Trades Purchases | 165.8 | 800
[NAME] | Firm Trades Sales | 90.71428571428571 | 1400
 | Firm Trades Purchases | 87.5 | 400
Spreadsheet: 735389d1622940127-array-frequency-in-excel-ctrl-shift-enter-not-working-ece102_week3_activity1_data
Sheet: Example2

Gas Prices by State ($) |  |  | Statistics |  |  | Frequency
State | Price per gallon
Alabama | 3.139 |  | Mean |  |  | Price | Condition | Frequency
Alaska | 3.891 |  | Standard deviation
Arizona | 3.263 |  | Min |  |  | 3.25 | value<3.25
California | 3.694 |  | [NAME] |  |  | 3.5 | 3.25 ≤value<3.50
Colorado | 3.467 |  | median |  |  | 3.75 | 3.50 ≤ value < 3.75
Florida | 3.312 |  | number |  |  | 4 | 3.75 ≤ value < 4.00
Georgia | 3.311 |  |  |  |  |  | 4.00 [NAME] value
Hawaii | 4.206 |  |  |  |  |  | Number
Idaho | 3.597
Iowa | 3.22
Louisiana | 3.143
Montana | 3.511
Nebraska | 3.287
Nevada | 3.495
New Mexico | 3.186
New York | 3.609
Oregon | 3.682
Utah | 3.441
Washington | 3.685
Wyoming | 3.49
Spreadsheet: 11c89d6b-5e48-417a-b586-2d6d111b505d
Sheet: R

Course color corresponds with term of offering.  RED for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Religious Studies
RELS 112 | Civilizations-Philosophy & Religious Studies
RELS 205 | Civilizations-Philosophy & Religious Studies
RELS 210 | Civilizations-Philosophy & Religious Studies
RELS 211 | Civilizations-Philosophy & Religious Studies
RELS 212 | Civilizations-Philosophy & Religious Studies
RELS 215 | Civilizations-Philosophy & Religious Studies
RELS 217 | Civilizations-Philosophy & Religious Studies
RELS 221 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 222 | Civilizations-Philosophy & Religious Studies
RELS 223 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 225 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 227 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 228 | Civilizations-Philosophy & Religious Studies
RELS 229 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 230 | Civilizations-Philosophy & Religious Studies
RELS 231 | Civilizations-Philosophy & Religious Studies
RELS 235 | Civilizations-Philosophy & Religious Studies
RELS 237 | Civilizations-Philosophy & Religious Studies
RELS 240 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 243 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 245 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 246 | Civilizations-Philosophy & Religious Studies | Experiential-Travel
RELS 247 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2012
RELS 248 | Civilizations-Philosophy & Religious Studies | Experiential-Travel; Non-Western
RELS 251 | Civilizations-Philosophy & Religious Studies
RELS 260 | Civilizations-Philosophy & Religious Studies | Non-Western
RELS 262 | Civilizations-Philosophy & Religious Studies
RELS 271 | Civilizations-Philosophy & Religious Studies
RELS 273 | Civilizations-Philosophy & Religious Studies
RELS 274 | Civilizations-Philosophy & Religious Studies
RELS 275 | Civilizations-Philosophy & Religious Studies
RELS 311 | Civilizations-Philosophy & Religious Studies
RELS 312 | Civilizations-Philosophy & Religious Studies
RELS 323 | Civilizations-Philosophy & Religious Studies
RELS 335 | Civilizations-Philosophy & Religious Studies
RELS 336 | Civilizations-Philosophy & Religious Studies
RELS 343 | Civilizations-Philosophy & Religious Studies
RELS 352 | Civilizations-Philosophy & Religious Studies
RELS 375 | Civilizations-Philosophy & Religious Studies
RELS 381 | Civilizations-Philosophy & Religious Studies | Experiential-Travel | J-Term 2014 (Early Christianity)
RELS 384 | Civilizations-Philosophy & Religious Studies
RELS 401 |  | Capstone
RELS 487-488 |  | Experiential-Research
RELS 491-492 |  | Experiential-Research
RELS 496-498 |  | Experiential-Research
Spreadsheet: 166489d1341600190-formula-problem-vlookup-combined-with-if-statement-excel-spreadheet-if-statement-with-vloolup
Sheet: Need Biller

Invoice Creation Date | Invoice Date | Source | Invoice Number | [NAME] | Open Lines | Sold To Customer | Customer PO | Amount | Delivered Date | Comments | Contract Type | Payment Type | CC Date Charged | Difference | Tracking Number | Waybill Number | Collector | Billing Specialist | Inside Salesrep
Spreadsheet: 711658d1609838305-match-row-and-column-and-return-value-example
Sheet: Oversikt 03-2020

 |  | Mars | SLA | VMS | HMS | AMS | SUM |  |  | Bokføring 03-2020
 | 2020 | [NAME] hittill i år | 9735757.44843137 | 5344796.695754001 | 1928557.837061986 | 375000 | 17384111.98124736 |  |  | Beskrivelse |  |  | Beløp | D | K | Area | Product
 |  | Balanseført (fakturert)i januar & feb | 4564198.223073 | 3687637.303616 | 734666.3432439998 | 375000 | 9361501.869933 |  |  | Periodisering SLA 03-2020 |  |  |  | 1531 | 3911 | 110 | 95
 |  | [NAME] mars | 5171559.225358371 | 1657159.392138001 | 1193891.493817986 | 0 | 8022610.111314357 |  |  | Periodisering VMS 03-2020 |  |  |  | 3911 | 1531 | 110 | 80
 |  |  |  |  |  |  |  |  |  | Periodisering HMS 03-2020 |  |  |  | 3911 | 1531 | 110 | 45
 |  | Inntektsføring | SLA | VMS | HMS | AMS | SUM
 |  | Inntektsføres hittill i år | 6192082.016815645 | 1851840.229252079 | 1356141.358785276 | 93324.72490455872 | 9493388.329757558
 |  | Inntektsført jan/feb | 3552850.590898568 | 501003.2577109124 | 666018.1637111851 | 61475.40983606558 | 4781347.422156732
 |  | Inntektsføres mars | 2639231.425917077 | 1350836.971541166 | 690123.1950740907 | 31849.31506849315 | 4712040.907600828
 |  |  |  |  |  | [NAME] (+)/Inntektsføres (-) | 3310569.20371353
 |  |  | Siste oppdatering feb kons.
 |  | February
 |  |  | Actual | Periodisering | Etter per.
 |  | Broadcast Facility & Metro Solutions
 |  | Media & Production Networks
 |  | Management & Orchestration
 |  | Support & Services
 |  | Bokført i balansen: | IB
 |  | 1531 - Fakturert, ikke opptj. inntekt | 01-2020 | 02-2020 | 03-2020 | 04-2020 | 05-2020 | 06-2020 | 07-2020 | 08-2020 | 09-2020 | 10-2020 | 11-2020 | 12-2020 | SUM
 |  | IB mnd | 21225955.35
 |  | [NAME] i mnd | 3964420.95037 | 5397080.919562999 | 8022610.111314357
 |  | Inntektsført | 2585821.529979078 | 2195525.892177653 | 4712040.907600828
 |  |  |  |  | (ikke bokført ennå) | Foreløpige tall hvis vi ikke hadde fakturert noe mer i 2020
 |  | Inntektene i mars reduseres med
Spreadsheet: joe_parks__14561__Tenaska IV Est Imbalance0202
Sheet: Sheet1

Tenaska IV Cleburne Plant
TXU Lone Star Pipeline
February 2002
Estimated Usages*
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
RECEIVED | 31680 | 31680 | 31680 | 31680 | 0 | 0 | 0 | 30972 | 0 | 0
DELIVERED | 28026.993 | 24504 | 3152 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 1106 | 1541 | 0 | 0 | 0 | 0
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28
RECEIVED | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DELIVERED | 0 | 0 | 0 | 0 | 265 | 0 | 0 | 82
DAILY IMBALANCE
MONTHLY IMBALANCE
ACCUM IMBALANCE
*These numbers are based on estimates and are subject to change
Spreadsheet: 46543d1245371606-conditional-formatting-test-ns-closeout-file-storage-t-and-i-risk-mitigation
Sheet: T&I Checklist

 | In order to act proactivley & seek T&I allowance check in a timely fashion (reducing closeout duration), please start updating below checklist at least a month prior to project's ODD. -Please refer to the inserted zip file that houses examples of below checklist-
 | T&I Allowance Reimbursement Checklist
 | To be completed by: |  |  | [Name]
 |  |  | Start Date: | [Date]
 | Deadline: |  |  | [Date]
 | Project Name:
 | Project #:
 | ODD:
 | Checklist items | Is item required?2 | % complete (If Required)2 | Date Completed | Notes
1 | Written request for payment | Yes | 1
2 | Certificate of Occupancy | Yes | 0.5
3 | Final Unconditional [NAME] from General Contractor | Yes | 0.25
4 | Paid receipts/invoices showing Physical Improvements made to the premises. | Yes | 0
5 | Written representation that [NAME] has opened for business | Yes | 0
6 | Final Unconditional [NAME] from Subcontractors | N/A | N/A
7 | Payment of first month’s rent and security deposit | No | N/A
8 | HVAC Maintenance Agreement (Typically from JLL Engineers since this service is In-house) | No | N/A
9 | Certificate of Insurance | No | N/A
10 | Utility Deposit | Yes | 0.5
11 | Local Government Impact Fees | Yes | 1
12 | [NAME] (Taxpayer Identification Number) | Yes | 0.25
13 | Copy of As-Built Plans complying with ADA | Yes | 0.25
14 | Is there a clause in lease that states (TI Allowance section of lease shall be deemed terminated if we fail to request reimbursement within a certain amount of days)? | Yes | 0
15 | (This line is left up to PjM to add a checklist list item that isn't recorded above) | N/A | N/A
Spreadsheet: 04ee76f2-efdb-4fc8-a540-8bde2dc353f7
Sheet: 4.2(AS) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(AS): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2010-11
 | Major Group | AS - American Indian Studies
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2010 (October 15, 2010)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 31 | 39 | 0 | 0
 |  | Part Time | 23 | 46 | 3 | 2
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students graduating with degrees who earned a GPA of 3.0 or above, and the number who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured employment after graduation.
 |  |  |  |  | July 1, 2010- June 30, 2011
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
Diploma |  |  | na | na | na | na
Certificate |  |  | na | na | na | na
Associate Degree |  |  | 7 | 20 | 0 | 1
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 2 | 12 | 0 | 1
Bachelor's Degree |  |  | 4 | 6 | 1 | 0
 | [NAME]. graduates admitted to graduate school |  | 0 | 0 | 0 | 0
 | [NAME]. graduated with a GPA of 3.0 or above |  | 2 | 3 | 1 | 0
Master's Degree |  |  | na | na | na | na
Employed after graduation |  |  | m | m | m | m
Notes:
na = not offered; m = not tracked;
Spreadsheet: 180690d1347703758-lookup-specific-text-above-our-cell-looking
Sheet: Sheet2

desc | value 1 | value 2 | value
a | 1 | 2 | 3
a | 2 | 4 | 6
a | 3 | 6 | 9
a | 4 | 8 | 12
a | 5 | 10 | 15
a | 6 | 12 | 18
b | 6 | 12 | 18 | if [NAME] look at A8 and found out that is not a..then it will search above the colum A8 to find latest "a", in this case is A7 so it will use same value as B7
b | 6 | 12 | 18
a | 7 | 14 | 21 | if B10 look at A10 and found out that it is "a", then it will search above the column A10 to find latest "a", in this case is A7, then when it found..it will sum B7 value with 1
 |  |  |  | bottom line : both using same princip..looking for "a", if find there is an "a" then lookup latest "a" in that column and SUM the value,
 |  |  |  | if not find "a" then lookup latest "a" but using the same value as the latest "a"