tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 266288d1379572279-conditional-formatting-cell-colors-for-the-7-days-of-the-week-book1
Sheet: Sheet1

 |  | 3RD SHIFT
# | # | SENIORITY LIST 9/15/13 | SENIORITY HRS
[NAME] | 3RD | NAME | AS OF 7/20/13 | RDO'S | F/S
2 | 1 | WITHROW | 59356.2 | F/S | S/S
3 | 2 | AKINES | 58544 | F/S | T/F
5 | 3 | SMILEY | 55335.9 | S/S | S/M
15 | 4 | CLARK | 51515.8 | S/S | M/T
23 | 5 | GRAHAM | 51177 | T/W | T/W
24 | 6 | JORAE | 50886 | F/S | W/T
25 | 7 | FOX | 50880 | F/S
27 | 8 | RIES | 50794.8 | S/S
30 | 9 | LOWDEN | 50080 | S/S
35 | 10 | NICIPOREK | 49440 | F/S
39 | 11 | LOVETTE | 44320.7 | S/S
40 | 12 | IRVIN | 44320 | T/W
43 | 13 | [NAME] | 43256 | T/F
46 | 14 | CAVANAUGH,G | 41968 | S/M
47 | 15 | COLBY | 40021.5 | S/S
49 | 16 | BARGESSER | 39216.2 | T/F
51 | 17 | DENT | 39040 | F/S
54 | 18 | SMITH,B | 38480 | T/F
67 | 19 | MARTIN | 36080 | T/F
69 | 20 | [NAME] | 36080 | T/F
72 | 21 | MODLIN | 36072 | T/F
73 | 22 | FREY | 36057.5 | S/M | MANDO LIST
81 | 23 | RUDD | 33040 | W/T
85 | 24 | CAVANAUGH,R | 33039.3 | S/M
86 | 25 | [NAME] | 33039.3 | S/M
92 | 26 | BAXTER | 31957.9 | S/M
97 | 27 | MCDANIEL | 31760 | S/M
98 | 28 | MORAN | 31760 | W/T
99 | 29 | BERRY | 31733.5 | T/W
101 | 30 | SPRUNGER | 31440 | M/T
102 | 31 | SMITH,C | 31439.4 | W/T
106 | 32 | [NAME] | 30724.4 | M/T
114 | 33 | SIBSON | 27920 | M/T
116 | 34 | WITHAM | 27760 | W/T
120 | 35 | GERHARDSTEIN | 26480 | W/T
124 | 36 | BALDWIN | 25059.9 | W/T
129 | 37 | ALDRIDGE | 22559.8 | M/T
132 | 38 | RIES,D | 22236.8 | M/T
136 | 39 | ROBERTSON | 17672 | T/W
138 | 40 | COMPTON | 15509.5 | M/T
148 | 41 | HOLLENBAUGH | 5600 | T/W
149 | 42 | BOLTON | 5600 | T/W
 | 43 | VACANT | N/A | N/A
 | 44 | VACANT | N/A | N/A
 | 45 | VACANT | N/A | N/A
 | 46 | VACANT | N/A | N/A
 | 47 | VACANT | N/A | N/A
 | 48 | VACANT | N/A | N/A
Spreadsheet: 330068d1404503613-problem-with-indirect-when-i-try-to-link-data-to-multiple-worksheets-indirect-statements-nc
Sheet: Final driver sheet - indirect

 |  |  |  |  |  | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
Visitor Roaming
 | Driver from factory
 | Driver from factory (2)
Spreadsheet: 119409d1314372968-what-is-the-current-balance-transactions
Sheet: Transactions

Account | Date | Num | Payee | Memo | Category | R | Debit (Leaving) | Credit (Entering) | Amounts for Report | Cleared Payment | Cleared Deposit | Account Balance | Cleared Balance | BALANCE
Checking | 2011-01-01 00:00:00 |  |  |  | [Balance] | R |  | 100
Summer Saver | 2011-01-01 00:00:00 |  |  |  | [Balance] | R |  | 10 |  |  |  |  |  |  |  | Checking
Visa | 2011-01-01 00:00:00 |  |  |  | [Balance] | R | 10 |  |  |  |  |  |  |  |  | Savings
Checking | 2011-01-01 00:00:00 | DEP | Direct Deposit from Employer |  | Wages & Tips | R |  | 20 |  |  |  |  |  |  |  | Summer Saver
Checking | 2011-01-10 00:00:00 | 2032 | Car Payment |  | Vehicle Payments | R | 1 |  |  |  |  |  |  |  |  | Visa
Visa | 2011-01-15 00:00:00 |  | Joe's Food Mart |  | Groceries | R | 1 |  |  |  |  |  |  |  |  | MC
Visa | 2011-01-18 00:00:00 |  | Fuel |  | Gas/Oil | R | 1 |  |  |  |  |  |  |  |  | AE
Checking | 2011-02-05 00:00:00 | DEP | Direct Deposit from Employer |  | Wages & Tips | R |  | 20 |  |  |  |  |  |  |  |  |  | latest balance for each acct
Checking | 2011-02-10 00:00:00 | 2033 | Target | Split | Clothing | c | 1
Checking | 2011-02-10 00:00:00 | 2033 | Target | Split | Groceries | c | 1
Checking | 2011-02-10 00:00:00 | 2033 | Target | Split | Personal Supplies | c | 1
Summer Saver | 2011-02-15 00:00:00 | TXFR | [From Checking] |  | [Transfer] | c |  | 10
Checking | 2011-02-15 00:00:00 | TXFR | [To Savings] | Split | Emergency Fund | c | 5
Checking | 2011-02-15 00:00:00 | TXFR | [To Savings] | Split | Retirement Fund | c | 2.5
Checking | 2011-02-15 00:00:00 | TXFR | [To Savings] | Split | Summer Saver | c | 2.5
Checking | 2011-02-15 00:00:00 | TXFR | To Visa |  | [Transfer] |  | 10
Visa | 2011-02-15 00:00:00 | TXFR | From Checking |  | [Transfer] |  |  | 10
Summer Saver | 2011-02-15 00:00:00 | TXFR | To Checking | Split | [Transfer] |  | 1
Checking | 2011-02-15 00:00:00 | TXFR | From Savings | Split | [Transfer] |  |  | 1
Spreadsheet: 715730d1611845102-help-reducing-the-amount-of-formulas-to-show-the-sum-attendance-sample-for-excel-help
Sheet: PTO TRACKER

 | Change the employee here | à | Employee
 |  |  | Jones, [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Start Date
 | Enter Jan 1 of what year you need for start date here | à | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End Date
 |  |  | 2021-01-01 00:00:00
 |  |  | End Date |  |  |  |  |  |  |  | PTO CARRY OVER |  |  |  |  | NEW SHORT NOTICE |  |  |  |  | NEW PTO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONTHLY SUMMARY | BALANCE of EACH | OVERALL BALANCE
 |  |  |  |  |  |  |  |  |  |  | TOTALS FOR THE YEAR
 |  |  |  |  |  | 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 | 26 | 27 | 28 | 29 | 30 | 31
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
 |  |  |  | PTO | Vacation - Scheduled
 |  |  |  | SN | Short Notice
Spreadsheet: 717672d1612797706-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Roster

Name | System
Test 1 | System 1
Test 2 | System 2
Test 3 | System 3
Test 4 | System 1
Test 5 | System 2
Test 6 | System 3
Test 7 | System 4
Test 8 | System 4
Test 9 | System 5
Test 10 | System 5
Spreadsheet: 815513d1675006630-need-to-sum-a-row-of-8-noncontiguous-numbers-and-then-select-the-highest-6-clasificacion-ans
Sheet: SEGUNDA

 |  | 1ª Prueba |  | 2ª Prueba |  | 3ª Prueba |  | 4ª Prueba |  | 5ª Prueba |  | 6ª Prueba |  | Total | Highest total of 4 numbers
 |  | 16/10 |  | 13/11 |  | 15/01 |  | 19/02 |  | 19/03 |  | 23/04
 | NOMBRE | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos | Puesto | Puntos
1 | ALVARO MARIN | 1 |  | 3 |  | 5 |  | 9 |  | 17 |  | 1
2 | ANTONIO JESUS RUIZ | 3 |  | 5 |  | 9 |  | 1 |  | 3 |  | 5
3 | ANTONIO J. LOPEZ DOMINGUEZ | 5 |  | 1 |  | 17 |  | 5 |  | 3 |  | 9
4 | ANTONIO JESUS JIMENEZ | 9 |  | 5 |  | 1 |  | 9 |  | 5 |  | 9
Spreadsheet: 97999d1297101189-multiple-rows-same-address-copy-of-address-sample
Sheet: Sheet3

Address | City | State | [NAME]
85 Stanley St | Cambridge | MA | 15151 | 3 | 1445 | [NAME] | [NAME] | [NAME]
69 West St | Charleston | MA | 14118 | 1 | 4615 | [NAME]
6 Pleasant St | Concord | MA | 15111 | 1 | 4145 | [NAME]
67 [NAME] | Concord | MA | 14434 | 2 | 5333 | [NAME] | Sandra Cans
40 Old Stow Rd | Hudson | MA | 15411 | 1 | 6267 | [NAME]
72 [NAME] | Lincoln | MA | 16378 | 1 | 5726 | [NAME]
98 Flemming Rd | Lincoln | MA | 16111 | 3 | 6334 | George & Martha Wilson | [NAME] | [NAME]
770 [NAME] #123 | Marlborough | MA | 15411 | 1 | 6280 | [NAME]
27 Connecticut Ave | Newton | MA | 15482 | 2 | 627 | [NAME] | [NAME]
3 Later Rd | Southborough | MA | 15346 | 1 | 1794 | [NAME]
241 Concord Ave | West Bridgewater | MA | 16139 | 4 | 1932 | Anders Larson | [NAME] | [NAME] | [NAME]
Spreadsheet: 810497d1671809633-looking-for-a-better-way-than-vlookup-when-same-value-is-shown-twice-2022-12-23-better-way-to-match-vendors-with-invoices-that-are-the-same-for-both-vendors
Sheet: Sheet1

DATA I am tracking |  |  |  |  |  |  | DATA from AP
Vendor | INV | Amt | Pmt Status
BURGER KING | 13936 | 3053.18 |  |  |  |  | BURGER KING | 13936 | 3053.18
BURGER KING | 13960 | 537.5 |  |  |  |  | BURGER KING | 13960 | 537.5
BURGER KING | 14191 | 7110.85 |  |  |  |  | BURGER KING | 14191 | 7110.85
BURGER KING | 14385 | 3598.58 |  |  |  |  | BURGER KING | 14385 | 3598.58
BURGER KING | 14459 | 1550 |  |  |  |  | BURGER KING | 14459 | 1550
BURGER KING | 15068 | 7830.05 |  |  |  |  | DQ | 15068 | 7830.05
BURGER KING | 15118 | 1905 |  |  |  |  | DQ | 15118 | 1905
BURGER KING | 15132 | 1942.04 |  |  |  |  | DQ | 15132 | 1942.04
BURGER KING | 15144 | 2038.75 |  |  |  |  | DQ | 15144 | 2038.75
BURGER KING | 15257 | 4301 |  |  |  |  | DQ | 15257 | 4301
BURGER KING | 15260 | 2965 |  |  |  |  | DQ | 15260 | 2965
BURGER KING | 15262 | 4839.03 |  |  |  |  | DQ | 15262 | 4839.03
TACO BELL | 15118 | 1905 |  |  |  |  | TACO BELL | 15118 | 1905
TACO BELL | 15132 | 1942.04 |  |  |  |  | TACO BELL | 15132 | 1942.04
TACO BELL | 15144 | 2038.75 |  |  |  |  | TACO BELL | 15144 | 2038.75
TACO BELL | 15257 | 4301 |  |  |  |  | TACO BELL | 15257 | 4301
TACO BELL | 15260 | 2965 |  |  |  |  | TACO BELL | 15260 | 2965
TACO BELL | 15262 | 4839.03 |  |  |  |  | SHONEYS | 15262 | 4839.03
TACO BELL | 15740 | 20107 |  |  |  |  | SHONEYS | 15740 | 20107
TACO BELL | 15743 | 12929 |  |  |  |  | SHONEYS | 15743 | 12929
TACO BELL | 15886 | 859.58 |  |  |  |  | SHONEYS | 15886 | 859.58
Spreadsheet: rick_buy__32744__0822_Violation
Sheet: Sheet1

 | To: |  | [NAME], [NAME] and [NAME]
 | Copy to: |  | Distribution
 | From: |  | Global Risk Management Operations
 | Date: |  | 2001-08-23 00:00:00
 | Re: |  | Limit Violations and Notifications for August 22, 2001
 |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  | Violation/
 |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  | ($MMs) |  |  |  |  |  | ($MMs) |  | ($MMs)
1 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 2 Mil Bbl WTI | Net Open Position | (3.59) Mil Bbl WTI | 28 |  | -3181 |  | -31623 |  |  | Due to the $3 September 2001 price increase since July 19, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
2 | Enron Global Markets |  | EOL 24/7 Crude Trading | B |  | 3 Mil Bbl WTI | Maturity Gap Risk | (3.59) Mil Bbl WTI | 20 |  | -3181 |  | -31623 |  |  | Due to the $3 September 2001 price increase since July 19, both internal and external counter-parties have consistently bought from the EOL Crude portfolio, causing EOL to be increasingly short.
3 | Enron Europe |  | European Natural Gas | B |  | 90 Bcf | Maturity Gap Risk | 91.6 Bcf | 4 |  | -11191 |  | 61276 |  |  | The UK and Continental Gas Books reported a Maturity Gap of 91.6 bcf, mostly concentrated in October 2001.  The traders expect to reduce the Maturity Gap Position to less than 90bcf through the normal course of trading over the next week.
4 | Enron Americas |  | Gas Trading | B |  | 200 Bcf | Maturity Gap Risk | (374) Bcf | 52 |  | -15971 |  | 649318 |  |  | The Maturity Gap Risk violation is driven by short fixed price positions in the three month period between March 2002 and May 2002. The Financial Desk is carrying the majority of those positions, (344) Bcf, between March 2002 and May 2002.
5 | Enron Americas |  | Gas Trading | B |  | 500 Bcf | Net Open Position | (506) Bcf | 18 |  | -15971 |  | 649318 |  |  | The Net Open Position violation is driven by Alberta Power Desk’s (247) Bcf short gas positions, the Financial Desk’s (106) Bcf short positions and the East Power Desk’s (70) Bcf short gas positions.
 | B= Business Unit Violation |  | C= Concentration Violation
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 785335d1656345640-sumif-or-similar-to-roll-up-most-current-data-from-other-sheets-test-workbook
Sheet: Summary

Date | Balance | Payment | Past Due | MOP | Terms | High Credit | Credit Limit | Balloon | Charge Off | 30 | 60 | 90 | #M | Utilization | % On-Time | Score 1 | Score 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #
2022-06-14 00:00:00
2022-06-16 00:00:00
Spreadsheet: 46547d1245384228-searching-and-matching-test
Sheet: Sheet1

Firm | Transaction | Level
ABC | 100 | 1
ABC | 200 | 1
ABC | 30 | 1
ABC | -20 | 1
ABC | -10 | 1
DEF | 200 | 1
DEF | 120 | 1
DEF | 20 | 2
DEF | -30 | FALSE
Spreadsheet: 867583d1714414429-difference-between-earliest-and-latest-column-with-data-present-when-there-are-nas-book1
Sheet: Sheet1

Program | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | Change
A | 5 | 6 | 7 | 8 | 9 | 10
B | NA | NA | 7 | NA | 9 | 10
C | NA | 6 | NA | NA | 9 | NA
Spreadsheet: 740436d1626342537-count-the-number-of-occurrences-in-a-table-plot-count
Sheet: Osma

Plot No |  |  |  | No 0f
 | Lymner | [NAME]
 | Cutler | [NAME]
 | Coppersmith M4(2) | [NAME]
 | Cobbler M4(2) | [NAME]
 | Mason | [NAME]
 | Baxter | [NAME]
 | Japonica SP | [NAME]
 | Blacksmith / Blacksmith | Semi
 | Thespian / Tailor | Semi
 | Joiner / Joiner | Semi
 | Single Garage | [NAME]
 | Double Garage | [NAME]
 | Tailor / Tailor | semi
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
Spreadsheet: 4ae48d90-c54c-43bd-bef8-23a269e4455c
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
FBARS | Test | FBARS | Barium, Serum | Barium, Serum | Inductively Coupled Plasma/Mass Spectrometry (ICP-MS) |  |  |  |  |  | Submit only 1 of the following specimens:   Plasma Draw blood in a EDTA metal-free royal blue-top tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL metal-free EDTA plasma refrigerated in a plastic vial.   Serum Draw blood in a metal-free royal blue-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL metal-free serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Units:  ng/mL  Reference range has not been established.  Test Performed by: Medtox Laboratories, Inc.                               402 W. County Road D                               St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc.
FBARS | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 14 days
FBARS | Result | Z3368 | Barium | Barium | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 0152e851-70b9-4427-b60a-8620d3ca2bc3
Sheet: Scen 1 Proforma

 | HR&A Advisors, Inc.
 | Inner Loop East Reconstruction Project
 | Real Estate Development Scenario 1 Residual Land Value Analysis
 | Program | Development SF | % of total Development Building SF | Units | Vacancy | Sale Price ($/sf) | Rental Rate ($/sf) | Opex as % of Rent | Opex ($/SF) | NOI ($/SF) | Total NOI |  | Development Costs (per SF) | Development Costs (Total) | Parking Costs | Land Costs | Total Development Costs | Stabilized Year Return
 |  |  |  |  | 0 | 200 | 0
 |  |  |  |  | 0.05 |  |  | 0.35
 |  |  |  |  | 0.05 |  | 15 | 0.1
 |  |  |  |  | 0.05 |  | 22 | 0.15
 | Land Value Calculation
 |  | Anticipated Return | Suportable Land Value | % of Development Program | Weighted Value | Total Land Value
 |  | 0.3 | 17.55
 |  | 0.075 | 24
 |  | 0.08 | 50.41
 |  | 0.085 | 42.25
Spreadsheet: 708554d1607929373-create-an-advanced-report-to-show-average-price-per-brand-sorted-by-country-cat-of-item-dashboard
Sheet: DENMARK

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 687678d1595346338-calculation-issue-calculation-isue2
Sheet: Sheet1

 |  |  | Packs | Cost | [NAME] | Total | Total
 |  |  |  | Per Pack [NAME], VAT | 0.23 | Per Pack Inc Vat
 | Calculated by formula |  | 8 | 4.15
 |  |  |  |  | Total to Pay
 | My problem is the cost of the individual Item multiplied by the number of items is not the same as if multiplied on paper
 |  |  |  |  |  | Full Price Per Pack | Total
 | Simple Calculation |  | 8 |  |  | 5.1
 |  |  |  |  |  | Error
Spreadsheet: 46682d1245608288-need-to-have-a-cell-show-an-addition-to-a-time-in-another-cell-break-schedule-sample
Sheet: Auto Break Sheet

Break Schedule
2009-06-21 00:00:00
Win. # | Cashier | Time-In |  | 40 min break |  | 20 min break |  | Time-Out
 |  | 07:00:00
 |  | 08:00:00
Spreadsheet: 03538936-ddba-4459-9634-48cbedc57eb7
Sheet: Part I

[NAME]:
Calculation of Excess Costs FY14
 |  | Elementary | Secondary
A. | FY13 Expenditures from state funds
 | FY13 Expenditures from local funds
 | FY13 Expenditures from federal funds
 | Total expenditure from all sources
B. | FY13 Capital outlay & debt service
 | Total expenditure less capital outlay and debt service
C. | FY13 Expenditures from IDEA Section 611 (3-21) funds
 | FY13 Expenditures from IDEA Section 619 (3-5) funds
 | FY13 Expenditures from ESEA Title I-A funds
 | FY13 Expenditures from ESEA Title III-A & B funds
 | FY13 [NAME] from state special education funds
 | FY13 [NAME] from local special education funds
 | FY13 [NAME] from state or local funds used for Title I-A
 | FY13 [NAME] from state or local funds for Title III-A & B
 | Subtotal: restricted program expenditures for schools
 | Total expenditures, minus capital outlay, debt service, and other federal, state & local funds
D. | 2012-2013 total ADM student enrollment (all students)
 | Percentage ADM student enrollment (all students)
 | Average annual per student expenditure
E. | Total December 1, 2013 Child Count of students with disabilities
 | Average annual per student expenditure
 | Total minimum amount the LEA must spend on the education of  students with disabilities from state and local funding sources, before using IDEA funds to offset the Excess Costs of special education
Spreadsheet: kenneth_lay__19471__1130_Violation
Sheet: Sheet1

 |  |  | To: |  | [NAME], [NAME] |  |  |  |  | Risk Policy Notification Requirements
 |  |  | Copy to: |  | Distribution |  |  |  |  |  |  |  | Skilling |  | Lay |  |  | Finance Committe Chairman
 |  |  |  |  |  |  |  |  |  | Daily Loss |  |  | 50% of VaR |  | 75% of VaR |  |  | Aggregate Loss > 100% Aggregate VaR Limit
 |  |  | From: |  | Global Risk Management Operations |  |  |  |  | Cumulative 5-day Loss |  |  | 75% of VaR |  | 100% of VaR
 |  |  |  |  |  |  |  |  |  | NOP, M/G, VaR |  |  | 105% of VaR |  | 110% of VaR |  |  | Aggregate VaR > 100% Aggregate VaR Limit
 |  |  | Date: |  | 2000-11-30 00:00:00
 |  |  | Re: |  | Limit Violations
 |  |  |  |  |  |  | Loss Notification or Limit Violation |  |  |  |  |  | P/L RESULTS
 |  |  |  |  |  |  |  |  |  | Violation/
 | Occurrence |  |  |  |  |  | VaR | NOP or M/G | Type | Notification | Number |  | QTD |  | YTD
 | Date |  | Business Unit |  | Commodity Group |  | Limit | Limit | Violation | Amount | YTD |  | P/L |  | P/L |  |  | Explanation
 |  |  |  |  |  |  | ($MMs) |  |  | ($MMs) |  |  | ($MMs) |  | ($MMs)
Lay Level Violations
1 | 2000-11-30 00:00:00 |  | Enron Energy Services |  | Gas & Power Trading |  | 7 | n/a | VaR | 7.776 | 5 |  | 52.418 |  | 320.56 |  |  | The VaR violation was primarily due to COB price increases in the West.
RAC COMMENTS:
 | Distribution: |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 487206d1477963133-layout-h-je-bj-lker-rev-
Sheet: Ark1

ANALYSIS
File Name |  |  |  |  |  | Ref |  |  |  |  | Acc. EC3 these are high beams when L is <3 * h
Building Part |  |  |  |  |  | Date
Subject | Cross-sectional Analysis |  |  |  |  | Ini
Cross section / Environmental Class |  |  |  | Section Forces And Reactions |  |  |  | Functional Requirements
t wall | 200 | [NAME] |  | R |  | kN |  | f_ctm |  | Mpa
L_1 + 2 | 500 | [NAME] |  | M_Ed |  | kN*m
L'Wall | 9100 | [NAME] |  | M_Ek |  | kN*m |  | 𝞂_ct1 |  | MPa
H | 3000 | [NAME] |  | M_Ec |  | kN*m |  | 𝞂_ct2 |  | MPa
3H |  | [NAME] |  | M_Eq |  | kN*m |  | 𝞂_s2 |  | MPa
c | 15 | [NAME] |  |  |  |  |  | E_c0k |  | MPa
d |  | [NAME] |  |  |  |  |  | E_cm |  | MPa
 |  |  |  |  |  |  |  | E_ceff |  | MPa
Parameter |  |  |  | Reinforcement |  |  |  |  |  | E/L
f_yk | 550 | Mpa |  | [NAME] |  | mm^2/m |  |  |  | E/L
f_ck | 35 | MPa |  | [NAME] | 200.96 | mm^2/m |  | A_c,eff |  | E/L
f_yd |  | Mpa |  | A_sL | 157 | mm^2 |  | P_p,eff |  | E/L
f_cd |  | MPa |  | S_Ed |  | [NAME] |  |  |  | E/L
v | 0.9 | E/L |  | S_Rd |  | [NAME] |  | c |  | E/L
v_m |  | E/L |  |  |  |  |  | k_1 | 0.8 | E/L
v_v |  | E/L |  | Press Zone Height |  |  |  | k_2 | 1 | E/L
 |  |  |  | x |  | [NAME] |  | k_3 |  | E/L
 |  |  |  |  |  |  |  | k_4 |  | E/L
Impact Class |  |  |  | Moment Capacity |  |  |  | S_rmax |  | E/L
K_FI | 1.1 |  |  | MRD1 |  | kN*m |  | W_k |  | [NAME]
 |  |  |  | MRD2 |  | kN*m
Payload Load Combination Factors |  |  |  | MRd |  | kN*m |  | Remuneration
𝝍_2 | 0.2 | nyttelast |  |  |  |  |  | UBJL |  | [NAME]
 |  |  |  |  |  |  |  | Netjern |  | [NAME]
Characteristic Values |  |  |  | Shear Capacity |  |  |  | L_sup |  | [NAME]
G | 54 | kN/m |  | 1 |  |  |  | B_1 |  | [NAME]
Q | 14.3 | kN/m |  | 3 |  |  |  | B_2 |  | [NAME]
S | 0 | kN/m |  |  |  |  |  | A_c1 |  | mm^2
V | 0 | kN/m |  |  |  |  |  | A_c0 |  | mm^2
 |  |  |  |  |  |  |  | c
Combinations |  |  |  |  |  |  |  | FRdu |  | kN
q_Rd |  | kN/m |  |  |  |  |  | l_b |  | [NAME]
q_Rk |  | kN/m |  |  |  |  |  | l_bd |  | [NAME]
q_Rc |  | kN/m |  |  |  |  |  | F_sRdL |  | kN
q_Rq |  | kN/m |  |  |  |  |  | F_Rd0 |  | kN
 |  |  |  |  |  |  |  | 𝞂_tryk |  | Mpa
 |  |  |  |  |  |  |  | 𝞂_Rd |  | MPa