tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2125__JanCohCHOICE-ENA
Sheet: Jan 6

 | CES/NPC COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2001-01-06 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 795 |  | 795 |  | 67694 |  |  |  |  |  | 29 | 1 | *
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 2 | *
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 3553 |  | 3553 |  | 67694 |  |  |  |  |  | 29 | 3 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 7000 |  | 7000 |  | 68918 | 0 |  |  |  |  | 28 | 4 | * |  |  | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 5 | * |  |  | 15
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 285 |  | 285 |  | 67694 |  |  |  |  |  | 31 | 6 | * |  |  | 22
 |  |  |  |  |  |  |  |  | 2400 |  | 2400 |  | 68915 | 0 |  |  |  |  | 29 | 7 | * |  |  | 15
 |  |  |  |  |  |  |  |  | 500 |  | 500 |  | 69148 | 0 |  |  |  |  | 30 | 8 | * |  |  | 14
 |  |  |  |  |  |  |  |  | 1600 |  | 1600 |  | 69693 | 0 |  |  |  |  | 29 | 9 | * |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 15 | * |  |  | 16
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 9620 |  | 9620 |  | 67694 |  |  |  |  |  | 28 | 35 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 85 |  | 85 |  | 68917 | 0 |  |  |  |  | 28 | 39 | * |  |  | 17
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69149 | 0 |  |  |  |  |  |  |  |  |  | 17
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 1780 |  | 1780 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1039 |  | 1039 |  | 67694 |  |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.9
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 11199 |  | 11199 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 3474 |  | 3474 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 2604 |  | 2604 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 4760 |  | 4760 |  | 67694
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1711 |  | 1711 |  | 67694
 |  |  |  |  |  |  |  |  | 200 |  | 200 |  | 69708 | 0
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 38 |  | 38 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 3 |  | 3 |  | 69708 | 0
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  | 27835 | Pull from ENA Pool to NPC Pool
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] from/(Sell to) ENA
Spreadsheet: 850952d1701254888-extracting-data-onto-new-sheet-test1-17-aligw
Sheet: Group 2

 | Name | Capacity | Total No. | [NAME].
AA | AA's | 10 | 5 | 50
AB | AB's | 11 | 3 | 33
BA | BA's | 13 | 4 | 52
BB | BB'S | 14 | 2 | 28
 |  | Totals | 14 | 163
Spreadsheet: 177684d1346397893-conditionally-format-external-data-0a1fcf-ext-data
Sheet: Sheet1

Table from external source
Club | Pld | Pts |  | Club | Pld | Pts
Chelsea | 3 | 9 |  | Chelsea | 3 | 9
Swansea | 2 | 6 |  | Swansea | 2 | 6
Everton | 2 | 6 | Man Utd | Everton | 2 | 6
West Brom | 2 | 4 |  | West Brom | 2 | 4
Man City | 2 | 4 |  | Man City | 2 | 4
Fulham | 2 | 3 |  | Fulham | 2 | 3
Man Utd | 2 | 3 | Conditionally format this | Man Utd | 2 | 3
[NAME] | 2 | 3 | to look like this | [NAME] | 2 | 3
Newcastle | 2 | 3 |  | Newcastle | 2 | 3
West Ham | 2 | 3 |  | West Ham | 2 | 3
Stoke | 2 | 2 |  | Stoke | 2 | 2
Arsenal | 2 | 2 |  | Arsenal | 2 | 2
Sunderland | 1 | 1 |  | Sunderland | 1 | 1
Tottenham | 2 | 1 |  | Tottenham | 2 | 1
Reading | 2 | 1 |  | Reading | 2 | 1
Liverpool | 2 | 1 |  | Liverpool | 2 | 1
[NAME] | 2 | 1 |  | [NAME] | 2 | 1
QPR | 2 | 1 |  | QPR | 2 | 1
Southampton | 2 | 0 |  | Southampton | 2 | 0
[NAME] | 2 | 0 |  | [NAME] | 2 | 0
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 12299 | 10388 | -556
2 | 11706 | 10732 | -472
3 | 11910 | 10841 | -486
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-06-30 00:00:00 |  |  |  |  | 545087.14
2001-07-03 00:00:00
Spreadsheet: 294f220b-5f2d-4a3e-ab96-8535de080120
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
MAESL
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 51576d1251222355-data-validation-from-table-non-vb-dynamic-data-validation
Sheet: Sales

Department: | SALES
Project 1
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Project 2
Title
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
 | <-- | [NAME]
Spreadsheet: 076396ac-8084-416a-9bc7-62c0b1f05af8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Office of School Finance
SF-6
School-Age Attachment Two
To be used only for those students with EMIS status codes 19 or 1B and
who were NOT included on the SF-14H Form
To be filed by educating district (3323.14 [NAME]) for school year 2012-2013
A. |  |  |  |  |  |  |  |  | IRN
 | Educating District - City, Exempted Village or Local
B. |  |  |  |  |  |  |  |  | IRN
 | Resident District - City, Exempted Village or Local
 |  |  |  |  | Disability |  | EMIS Status |  | Dates of
SSID |  |  |  | Grade | Condition |  | Code |  | Enrollment |  | *Total
Number |  |  |  |  | From |  | From |  |  |  | Days
 |  |  |  |  | Section I C |  | Section I D |  | From | To | Enrolled
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
* A full membership school year is 180 days.
Spreadsheet: 97325d1296542234-joining-columns-of-different-lengths-from-different-sheets-concatenate_sheets
Sheet: Output

123
234
345
456
567
678
12
23
34
1234
2345
3456
4567
5678
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 39591d1237891541-making-a-cell-red-if-another-cell-is-red-excelforum-example
Sheet: Sheet1

 |  | % who said yes
 |  | Country 1 | Country 2 | Country 3
 | q1 | 33 | 52 | 2
 | q2 | 44 | 2 | 1
 | q3 | 22 | 23 | 12
 | q4 | 13 | 54 | 1
 | q5 | 55 | 45 | 11
 | q6 | 92 | 34 | 32
 | q7 | 87 | 27 | 45
 | q8 | 66 | 18 | 22
 | Red means that the base for that question was <50 respondents. There is no data file that has those base numbers now.
 | There is a separate tab (a reporting dashboard) with a pulldown menu with all the countries. I select a country in that pulldown menu, and the correct column's data from here shows up.
 | And in that reporting dashboard, I need to make red the same numbers that are red here.
Spreadsheet: 702725d1604504189-link-to-goto-cell-in-another-sheet-based-on-matching-cell-values-links
Sheet: Past_Dues

CUST ID | Name | TOTAL | 1 - 30 | 31 - 60 | 61 - 90 | OVER 90 | link
13475 | ABC Store | 108 | 0 | 108 | 0 | 0 | link
13688 | Discount Store | 429 | 5.39 | 28.5 | 18.11 | 377 | link
13337 | [NAME] | 412.91 | 5.91 | 0 | 0 | 407 | link
Spreadsheet: 73188d1273835967-extracting-cell-reference-from-a-formula-another-cell-cell-reference
Sheet: Sheet1

Standard Deviation | 120.3133524500825 | 111.5850074557011 | 188.3788514315412 | 288.5225824013704 | 393.9160831389797 | 501.5349988895204 | 610.2426319824672 | 719.5219573516233 | 829.1469633169851 | 938.9965861966107
Average | 287.85 | 293.45 | 297.65 | 300.35 | 304.25 | 308.62 | 312.59 | 316.5599999999999 | 320.5299999999999 | 324.5
End Address | $B$16 | $C$16 | $D$16 | $E$16 | $F$16 | $G$16 | $H$16 | $I$16 | $J$16 | $K$16
Start Address | $B$7 | $C$7 | $[NAME] | $E$7 | $F$7 | $G$7 | $[NAME] | $I$7 | $J$7 | $K$7
Sr No. | Value 1 | Value 2 | Value 3 | Value 4 | Value 5 | Value 6 | Value 7 | Value 8 | Value 9 | Value 10
7 | 100 | 156 | 198 | 225 | 264 | 307.7 | 347.4 | 387.1 | 426.8 | 466.5
8 | 156 | 198 | 240 | 282 | 324 | 366 | 408 | 450 | 492 | 534
9 | 198 | 225 | 252 | 279 | 306 | 333 | 360 | 387 | 414 | 441
10 | 225 | 264 | 303 | 342 | 381 | 420 | 459 | 498 | 537 | 576
11 | 264 | 307.7 | 351.4 | 395.1 | 438.8 | 482.5 | 526.2 | 569.9 | 613.6 | 657.3
12 | 307.7 | 347.4 | 387.1 | 426.8 | 466.5 | 506.2 | 545.9 | 585.6 | 625.3 | 665
13 | 347.4 | 387.1 | 426.8 | 466.5 | 506.2 | 545.9 | 585.6 | 625.3 | 665 | 704.7
14 | 387.1 | 426.8 | 466.5 | 506.2 | 545.9 | 585.6 | 625.3 | 665 | 704.7 | 744.4
15 | 426.8 | 466.5 | 506.2 | 545.9 | 585.6 | 625.3 | 665 | 704.7 | 744.4 | 784.1
16 | 466.5 | 156 | -154.5 | -465 | -775.5 | -1086 | -1396.5 | -1707 | -2017.5 | -2328
Average | 287.85 | 293.45 | 297.65 | 300.35 | 304.25 | 308.62 | 312.59 | 316.5599999999999 | 320.5299999999999 | 324.5
Standard Deviation | 120.3133524500825 | 111.5850074557011 | 188.3788514315412 | 288.5225824013704 | 393.9160831389797 | 501.5349988895204 | 610.2426319824672 | 719.5219573516233 | 829.1469633169851 | 938.9965861966107
Spreadsheet: 272082d1382196191-help-please-help-to-make-a-formula-to-get-me-the-next-event-date-sample-attached-sample
Sheet: Sheet1

Today
Name/ Date | 2013-10-01 00:00:00 | 2013-10-02 00:00:00 | 2013-10-03 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-07 00:00:00 | 2013-10-08 00:00:00 | 2013-10-09 00:00:00 | 2013-10-10 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-14 00:00:00 | 2013-10-15 00:00:00
Mido | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | Day | RDO
Jamy | Night | Night | Night | Night | Night | Night | Night | Off | Off | Off | Off | Off | Off | Off | Off
Micheal | Day | Day | Day | Day | Day | Day | RDO | Night | Night | Night | Night | Night | Night | Night | Night
[NAME] | Off | Off | Off | Off | Off | Off | Off | Off | Off | Off | TRF | Day | Day | Day | Day
Spreadsheet: 85952d1285941402-lookup-with-multiple-criteria-sample
Sheet: DOR R12

Operating Margin Variances
DOR Needed (Unfavorable Month and YTD Budget Variance of More than -3%)
2010-08-31 00:00:00
 |  |  |  |  | CURRENT |  | CURRENT
 | UNIT | UNIT |  |  | YTD |  | MONTH |  |  |  | 2010-07-31 00:00:00 |  |  | 2010-06-30 00:00:00 |  |  | 2010-05-31 00:00:00 |  |  | 2010-04-30 00:00:00 |  |  | 2010-03-31 00:00:00 |  |  | 2010-02-28 00:00:00 |  |  | 2010-01-31 00:00:00 |  |  | 2009-12-31 00:00:00 |  |  | 2009-11-30 00:00:00 |  |  | 2009-10-31 00:00:00 |  |  | 2009-09-30 00:00:00
COST CENTER DESCRIPTION | NUMBER | STATUS | VP | DIRECTOR | BUDGET | % | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting | BUDGET | % | Meeting
Department 1 | 12261 | Open | Smith, [NAME] | [NAME], [NAME] | 7611813 | -0.0745776334757567 | 550009 | -0.1055135244142023 | 2010-09-01 00:00:00
Department 2 | 12310 | Open | Doe, [NAME] | Count, [NAME] | 2510162 | -0.3894485694548798 | 117194 | -0.3823051948051948 | 2010-09-16 00:00:00
Department 3 | 12320 | Open | [NAME], [NAME] | [NAME], [NAME] | 4939925 | -0.3526320743735988 | 350634 | -0.3777425211229363 | Not Met
Department 4 | 12373 | Open | Smith, [NAME] | Count, [NAME] | 7658305 | -0.2349051128154337 | 366904 | -0.4711545252622217 | Not Met
 |  |  |  |  |  |  |  |  |  | I need to be able to pull in the information across the spreadsheet from
 |  |  |  |  |  |  |  |  |  | data entered in on the data sheet which will be hidden in the original
 |  |  |  |  |  |  |  |  |  | spreadsheet.  Consequently, it needs to examine 2 criteria.
 |  |  |  |  |  |  |  |  |  | It needs to look at the date and the cost center to pull in the
 |  |  |  |  |  |  |  |  |  | appropriate amount.  I have tried different variations of the
 |  |  |  |  |  |  |  |  |  | two formulas in cell K8 and L9 to no avail.
Spreadsheet: 88675d1288506724-nested-if-statement-ot-form
Sheet: Sheet2

Employee list
Name | Employee  Number | Flat rate -  meal allowance | Pay class
 |  |  | Level | Step
[NAME] | 1234 | 5 | 5 | 1
[NAME] | 5678 | 5 | 4 | 5
[NAME] | 1112 | 5 | 3 | 2
[NAME] | 1213 | 5 | 5 | 2
[NAME]
Level | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 20 | 25 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65
2 | 30 | 35 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75
3 | 40 | 45 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85
4 | 50 | 55 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95
5 | 60 | 65 | 70 | 75 | 80 | 85 | 90 | 95 | 100 | 105
Date Hired
Name | Employee  Number | Date Hired
[NAME] | 1234 | 2005-03-01 00:00:00
[NAME] | 5678 | 2001-06-16 00:00:00
[NAME] | 1112 | 2000-12-31 00:00:00
[NAME] | 1213 | 2005-03-15 00:00:00
Holidays
2010-10-11 00:00:00
2010-10-25 00:00:00
2010-11-01 00:00:00
2010-11-29 00:00:00
2010-12-25 00:00:00
2010-12-27 00:00:00
Spreadsheet: phillip_m_love__30549__newBLANKBOOKREQUEST
Sheet: Sheet1

From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Requestor:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC
Access List | Administrator* |  |  |  |  |  |  |  |  |  |  |  | Hierarchy
trohaue |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP
 |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS
 |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA
 |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
 |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
 |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
 |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
Spreadsheet: 75110d1275640593-percentage-calculation-from-cumulative-totals-book2
Sheet: Sheet1

Daily Saving | Daily Target | Accumulative Saving | Accumulative Target | Performance Against Target
219.81 | 760 | 219.81 | 760
51.52 | 760 | 271.33 | 1520
118.6 | 760 | 389.9299999999999 | 2280
1574.91 | 760 | 1964.84 | 3040
2173.8 | 760 | 4138.64 | 3800
Spreadsheet: 02f56ded-c5b4-4c7a-9d04-e7700f19b13f
Sheet: Pro forma Summary

Pro Forma Summary
Project Name: |  |  | Date:
Number of Units:
[NAME]: |  | % of Total Sq. Foot
Residential:
Common Areas:
Commercial/Other:
Total Square Footage:
Total Residential Project Cost:
 | Total in Dollars | Percent of Total Project Costs | Total Cost Per Unit | Total Cost Per Sq. Foot
Acquisition Costs:
Construction Costs:
Development Costs:
Total Project Costs :
Construction:
 |  | Percent of Construction | Per Unit | Per Sq. Foot
Builder General Conditions
Builder Overhead
Builder Profit
Total Builder GC/O/P
Construction Contingency
Architect's Fee
Development Cost:
 |  | Percent of Development | Per Unit | Per Sq. Foot
Development Contingency
 | Total in Dollars | Percent of Total Project Costs
5 % Max for Acquisition:
[NAME]:
15% [NAME]:
Developer Fee:
Consultant Fee
Minimum Required Non-Profit Share of Developer Fee: (If Applicable)
Total Developer Fee
Total Deferred Fee
Total Cash Developer Fee:
Operating Income & Expense:
Income: |  | Percent of EGI | Per Unit | Per Sq. Foot
EGI without OAHTC
EGI with OAHTC
Cash Flow without OAHTC
Cash Flow with OAHTC
Expenses:
Total Op Expenses/Unit
Less property tax
Less resident services
Net Op Exp/Unit
 |  | Percent EGI w/o OAHTC | Percent EGI w OAHTC
On Site [NAME]
Off Site [NAME]
Total [NAME]
Repairs/Unit
Maintenance/Unit
Total Repairs and Maint/Unit
Replacement Reserve
LIHTC:
 |  |  | Per Unit | Per Sq. Foot
Total Qualified Basis:
Total Amount Of Credit Requested:
Total Amount of Credit Allowable:
Net Tax Credit Investor Proceeds:
 | Uses Page | Tax Credit Calc Page | Difference
LIHTC Ineligible Costs
OAHTC:
 |  | Annual Per Unit | Per Unit | Per Sq. Foot
Annual Passthrough:
Actual Passthrough:
Over/Under:
Snapshot:
Construction Costs/Sq Ft:
Development Costs % of Project Costs:
Total Builder GC/O&P %:
Construction Contigency %:
Architect Fee %:
Development Contingency %:
Total Developer Fee %:
Total Cash Developers Fee %:
Cash Flow without OAHTC %:
Cash Flow with OAHTC %:
Net Op Exp/Unit:
Total [NAME]:
Total Repairs and Maint/Unit:
Replacement Reserve:
Spreadsheet: 05cf8c49-6577-463f-92a3-232cc56cae15
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Housing Finance - Banks ; |  |  | Original | A2437051V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Housing Finance - Permanent building societies ; |  |  | Original | A2437052W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Housing Finance - Wholesale lenders n.e.c. ; |  |  | Original | A2437053X | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Housing Finance - Other lenders ; |  |  | Original | A2437054A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Housing Finance - Total ; |  |  | Original | A2437055C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Banks ; |  |  | Original | A2437046A | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Credit co-operatives ; |  |  | Original | A2437047C | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Finance companies ; |  |  | Original | A2437048F | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Other lenders ; |  |  | Original | A2437049J | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2437050T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 12 Jan 2012

Daily Morning Staff |  |  |  |  | Thursday
 | 07:30-14:30 |  | 2012-01-11 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | 07:00:00 | 14:30:00 | EFS
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | 07:30:00 | 14:30:00 | [NAME]
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: gerald_nemec__11487__Netback calculation - Crescndo
Sheet: Badger Wash - Entrada

 | CURRENT PRICING CALCULATIONS
 | Field Name: | [NAME]
 | Production Zone: | Entrada
 | Company: | Crescendo Energy
 | CALCULATED FROM INLET SIDE
 | Flow Rate |  | 8 | MMSCFD |  |  |  |  | MMSCFD
 | BTU Content |  | 0.628 | MMBTU/MSCF |  |  |  | 1.09 | MMBTU/MSCF
 | Flow Rate |  |  | MMBTU/D |  |  |  |  | MMBTU/D
 | Sales Price |  | 3.25 | /MMBTU |  |  |  |  | MMBTU
 | Processing Fee |  | 0.62 | /MSCF (INLET) |  |  |  |  | /MSCF (OUTLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | Gathering Fee |  | 0.085 | /MSCF (INLET) |  |  |  |  | /MSCF (INLET)
 |  |  |  | /MMBTU (INLET) |  |  |  |  | /MMBTU (INLET)
 | FL&U and Plant Shrink |  |  | MMSCFD
 | (includes gathering/processing) |  |  | MMBTU/DAY
 | Adjusted Sale Price |  |  | /MSCF
 | Fuel Gas Adjustment |  |  | /MSCF
 |  |  |  |  |  | Gathering FL&U |  |  | 0.005
 | Net Back to Producer |  |  | /MSCF |  | Plant Shrink |  |  | 0.02
 |  |  |  |  |  | Plant Fuel Gas |  |  | 0.1
 |  |  |  |  |  | Total FL&U and Plant Shrink
 | Revenue per Day |  |  | /DAY
Spreadsheet: 737401d1624395207-help-with-index-and-match-functions-that-act-dynamically-example
Sheet: Pricing Links

Global Physicians Fee Schedule: CMS
https://www.cms.gov/medicare/physician-fee-schedule/search?Y=1&T=0&HT=0&CT=0&H1=74263&M=5
Modifier: Selected National Pricing Amounts using Global or Physicians Professional Service where 26/TC do not apply.
MAC Option: National Payment Amount
Notes: Downloaded all codes within the 10000-98999 ranges, and then A001 through Z9999 for HCPCS Codes.
Needed to use multiple ranges as the site limits to 500 results for each range. Combined into one Excel spreadsheet.
Seasonal Influenza Pricing: CMS
https://www.cms.gov/Medicare/Medicare-Fee-for-Service-Part-B-Drugs/McrPartBDrugAvgSalesPrice/VaccinesPricing
Used the 8/1/2020-7/31/2021 prices
2021 Clinical Diagnostic Laboratory Fee Schedule: CMS
[NAME]
Most recent file is through Q2 of 2021
Medicare Part B Drug Payment Allowance Limit: CMS
https://www.cms.gov/medicare/medicare-part-b-drug-average-sales-price/2021-asp-drug-pricing-files
Most recent file was from January 2021
HEDIS Value Set Directory from NCQA:
Used to identify which CPT/HCPCS, ICD9/ICD10 codes are used for measure calculation.
Must manually download a free copy through NCQA:
https://store.ncqa.org/my-2020-quality-rating-system-qrs-hedis-value-set-directory.html
Well Child Visits: Oregon Department of Health OHP Fee for Service Fee Schedule
https://www.oregon.gov/oha/hsd/ohp/pages/fee-schedule.aspx