tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2591__K-MartNoms
Sheet: Jan00

K-Mart - Group 4387
LDC:   NICOR
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 31775
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
Super K-Mart | 922
K-Mart Store # 3066 | 394
K-Mart Store # 3105 | 360
K-Mart Store # 3233 - 8-20-19-9513 | 355
K-Mart Store # 3233 - 8-20-01-9514 | 148
K-Mart Store # 3328 | 294
K-Mart Store # 3473 | 158
K-Mart Store # 3474 | 674
K-Mart Store # 3515 | 589
K-Mart Store # 3559 | 353
K-Mart Store # 3599 | 348
K-Mart Store # 3619 | 267
K-Mart Store # 3631 | 63
K-Mart Store # 3751 | 266
K-Mart Store # 3914 | 264
K-Mart Store # 4031 | 406
K-Mart Store # 4095 | 290
K-Mart Store # 4100 | 632
K-Mart Store # 4227 | 616
K-Mart Store # 4228 | 495
K-Mart Store # 4381 | 600
K-Mart Store # 4384 | 400
K-Mart Store # 4386 | 489
K-Mart Store # 4423 | 677
K-Mart Store # 4459 | 258
K-Mart Store # 4464 | 414
K-Mart Store # 4821 | 771
K-Mart Store # 4822 | 454
K-Mart Store # 4924 | 794
K-Mart Store # 7073 | 284
K-Mart Store # 7275 | 408
K-Mart Store # 7289 | 378
K-Mart Store # 7305 | 291
K-Mart Store # 7399 | 228
K-Mart Store # 7416 | 785
K-Mart Store # 7473 | 207
K-Mart Store # 7490 | 351
K-Mart Store # 7525 | 587
K-Mart Store # 8289 | 3681
K-Mart Store # 9218 | 158
K-Mart Store # 9163 | 397
Total(s)
K-Mart - Group 4468
LDC:   NICOR
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 2790
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
K-Mart Store # 3343 | 495
K-Mart Store # 4214 | 296
K-Mart Store # 4802 | 131
K-Mart Store # 4823 | 78
K-Mart Store # 4938 | 6
K-Mart Store # 4938 | 698
K-Mart Store # 7789 | 23
K-Mart Store # 9343 | 55
K-Mart Store # 9358 | 136
K-Mart Store # 9361 | 107
Total(s)
K-Mart - Group 4546
LDC:   NICOR
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 775
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
K-Mart Store # 9362 | 134
K-Mart Store # 9366 | 103
K-Mart Store # 9368 | 74
K-Mart Store # 9373 | 199
Total(s)
K-Mart - Group 4567
LDC:   NICOR
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 465
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
K-Mart Store # 9939 | 62
K-Mart Store # 9360 | 187
K-Mart Store # 9377 | 78
K-Mart Store # 9378 | 94
Total(s)
K-Mart - Group 00672
LDC:   Peoples Gas
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 3100
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
K-Mart Store # 3367 | 990
K-Mart Store # 3371 | 290
K-Mart Store # 3594 | 500
K-Mart Store # 4235 | 410
K-Mart Store # 4722 | 270
K-Mart Store # 4729 | 200
Total(s)
K-Mart - Group 20087
LDC:   North Shore Gas
Delivery Month | 2000-01-01 00:00:00
Total Dths Delivered | 2480
Price per Dth | 2.72
Total Cost
 |  |  | % of Total
Facility/Building | MDCQ |  | MDCQ |  | Dths
K-Mart Store # 3032 | 480
K-Mart Store # 7084 | 420
K-Mart Store # 7913 | 1180
Total(s)
Spreadsheet: 752390d1634739604-averageif-function-question-average
Sheet: TABLE A

A | 3 | 21/22
A | 5 | 21/22
A | 7 | 21/22
A | 8 | 21/22
A | 3 | 21/22
B | 2 | 2021
B | 3 | 2021
B | 4 | 2021
B | 5 | 2021
B | 6 | 2021
B | 7 | 2021
C | 5 | 21/22
C | 5 | 21/22
C | 7 | 21/22
C | 2 | 21/22
C | 2 | 21/22
Spreadsheet: 93634d1293286784-weighing-point-clusters-weighing-clusters
Sheet: Sheet2

0.45 |  |  |  | 33
0.73 |  |  |  | 18
0.55 |  |  |  | 22
0.14 |  |  |  | 20
0.74 |  |  |  | 16
0.25 |  |  |  | 17
0.24 |  |  |  | 21
0.18 |  |  |  | 12
0.15 |  |  |  | 32
0.77 |  |  |  | 32
0.53 |  |  |  | 18
0.72 |  |  |  | 35
0.93 |  |  |  | 37
0.09 |  |  |  | 22
0.62 |  |  |  | 33
0.61 |  |  |  | 25
0.19 |  |  |  | 22
0.52 |  |  |  | 25
0.94 |  |  |  | 19
0.87 |  |  |  | 18
0.79 |  |  |  | 38
0.68 |  |  |  | 12
0.34 |  |  |  | 33
0.58 |  |  |  | 17
0.83 |  |  |  | 28
0.36 |  |  |  | 35
0.94 |  |  |  | 33
0.24 |  |  |  | 33
0.43 |  |  |  | 29
0.73 |  |  |  | 38
Spreadsheet: 111226d1307645767-last-12-entries-last-12-entries-post-21
Sheet: Calculation

 |  | Date | 2010-07-02 00:00:00
 | 13222050 | 8747488 | 210 | 0 | 0 | 2696647 | 504000 | 504741 | 1200 | 10 | 540450 | 4054 | 20450 | 1760389 | 1063530
Date | Net Asset | Investment Income |  |  |  | Expenses |  |  |  |  |  |  |  | Unrealized Gain/Loss | Realized Gain/Loss
2010-06-30 00:00:00 | 1000000 | 1472168 | 210 | 0 | 0 | 743327 | 0 | 504540 | 1200 | 10 | 540450 | 4054 | 20450 | 109705 | 0
2010-07-01 00:00:00 | 10000000 | 2837985 | 0 | 0 | 0 | 974004 | 154000 | 201 | 0 | 0 | 0 | 0 | 0 | 1052967 | 545400
2010-07-02 00:00:00 | 2222050 | 4437335 | 0 | 0 | 0 | 979316 | 350000 | 0 | 0 | 0 | 0 | 0 | 0 | 597717 | 518130
2010-07-03 00:00:00 | 205044560 | 5127171 | 0 | 0 | 0 | 991460 | 50000 | 0 | 0 | 0 | 0 | 0 | 0 | 748375 | 492223.5
2010-07-04 00:00:00 | 2005460000 | 6612000 | 0 | 0 | 0 | 997000 | 100000 | 5000 | 0 | 0 | 0 | 0 | 0 | 673537.5 | 467612.325
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1900-01-01 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: vkaminski__40914__LJM Simulation1
Sheet: Assumptions and Methodology

Goals of the model:
to model the terminal values of the raptor structures
to study the implication of cross-guarantees among raptors on LJM
Methodology:
Estimate drift and volatility terms from a two year history of daily stock prices by using market data on self or comparables
Use portfolio approach to reduce the size of the covariance matrix (Portfolio definition included in the raptor sheets)
Simulate to obtain the distribution of the terminal values of the raptors
Calculate the impact on LJM
The assets in the vehicles are aggregated in the following portfolios
ENE Stock (ENE)
Total Public Exposure of Raptor 1 (PUBR1)
Total Private Exposure except Merlin Put of Raptor 1 (PRIVR1)
Merlin Put in Raptor 1 (MERL)
Total Brazilian Exposure (CEG+Gaspart+Riogas+Other) in Raptor 2 (BRASR2)
TNPC Stock (TNPC)
Data:
The following inputs are needed for the simulation
The drift parameters for portfolio returns
The covariance matrix of portfolio returns
The LIBOR curve
The sources of data for the valuation are as follows
The raptor spreadsheets (obtained from [NAME]) provided information on the assets and liabilities of raptor vehicles (raptor1h, raptor2b, raptor3b, and raptor4.xls)
RAC ([NAME]) provided the spreadsheet, Raptor [NAME], for data on market values of Raptor 1 private exposure and Raptor 2 Brazilian exposure.
[NAME] spreadsheets provided more up-to-date figures on the raptors.
Assumptions/Questions/Notes
The drifts for assets are beta based except for privates in R1 (set to 10%)
Riskfree Rate = 6%, Market Return = 16%, Betas calculated using last two years' data, unless not available.
Volatilities are historical (haircut down to 100% for NPW) and historical correlations (using last two years' data if available)
Privates are marked to the market for strike prices, publics and Brazilians have definite prices
Private exposure debt added directly to equity and convertibility of Venoco is ignored
Brazilian exposure uses RAC numbers except for the category "Others" where notional is used due to the inavailability of RAC figures
Has there been a collar placed on R4?  If so, what are the terms?
We need to clean up the values of the privates and merlin, exclude bankrupt assets.  Whose values should we use?  RAC or [NAME]'s.  Presently cell values closely approximate [NAME]'s values.
What are the most recent values of the notes in the raptors, debt and equity in Hawaiian?
Spreadsheet: 728413d1618435864-ifs-formula-that-allows-whole-and-decimals-rea-point-tracker-test
Sheet: Sunday

Sunday | 2021-04-11 00:00:00 | Day Shift |  |  |  |  |  | Swing Shift
Last Name | First Name | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Today's Score | REA Bucks | Weekly Average | Weekly REA Bucks
 |  | 4 | 4 | 2 | 4 |  |  | 2 | 2 | 3 | 2
Spreadsheet: 819184d1677273460-can-the-filter-function-add-specific-cells-table-example-etaf-v3
Sheet: Sheet1

Table |  |  |  |  |  |  |  | Desired results
Customer | PO | Ship from | Date | Qty sold | Account Name | Value |  | Customer | PO | Ship from | Date | Qty sold | Freight
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | Material | 9000 |  | JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 18000 | 6000
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 6 | Pallet | 60
JB&Stuff | 123456 | Dallas | 2023-01-01 00:00:00 | 1 | Freight | 6000 |  | Current results
nonamesrus | 654321 | Chicago | 2023-01-01 00:00:00 | 40000 | Material | 20000 |  |  | 123456 | Dallas | 2023-01-01 00:00:00 | 18000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 25000 | Material | 10000 |  | JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000
makerofstuff | 123123 | Fresno | 2023-01-08 00:00:00 | 1 | Freight 2 | 800
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 14000 | Material | 9000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 26000 | Material | 12000
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 15 | Pallet | 150
JB&Stuff | 456789 | Dallas | 2023-02-02 00:00:00 | 1 | Freight 2 | 10000
 |  |  |  |  | What I need: =FILTER(FILTER(J16:P25,(O16:O25="material")*(N16:N25<20000)),{1,1,1,1,1,0,0}) This condenses my list to entries under 20,000 in column E. I need to add up E where B is the same then list totals under 20,000
Spreadsheet: 751994d1634497158-needing-help-with-matching-ir-rollup-exp
Sheet: 31 Serviceable

NIIN | Nomenclature | U of I | Batch | QTY | Unit Price | Total Price | Location | Date
014957907 | [NAME] | EA | A | 1 | 10.79 |  | Lane 3 Box A | 2021-03-10 00:00:00
[PHONE] | O Ring | EA | A | 1 | 0.32 |  | Lane 3 Box A | 2021-03-10 00:00:00
014957897 | [NAME] | EA | A | 1 | 65.57 |  | Lane 3 Box A | 2021-03-10 00:00:00
001675175 | O Ring | EA | A | 1 | 0.2 |  | Lane 3 Box A | 2021-03-10 00:00:00
012342618 | Gasket | EA | A | 1 | 17.46 |  | Lane 3 Box A | 2021-03-10 00:00:00
013984589 | [NAME] | EA | A | 3 | 8.58 |  | Lane 3 Box A | 2021-03-10 00:00:00
012050041 | [NAME] | EA | A | 1 | 0.25 |  | Lane 3 Box A | 2021-03-10 00:00:00
015074023 | O Ring | EA | A | 1 | 3.75 |  | Lane 3 Box A | 2021-03-10 00:00:00
012730500 | Light Indicator | EA | A | 13 | 16.99 |  | Lane 3 Box A | 2021-03-10 00:00:00
011688707 | Gasket | EA | A | 4 | 4.2 |  | Lane 3 Box A | 2021-03-10 00:00:00
Spreadsheet: 123213d1317407799-help-functions-sample-if
Sheet: Pivot

 | Average of Position | Column Labels
 | Row Labels | SEP | OCT
 | Dining - Specific to property |  |  | Change
 | the cigar bar | 6.7 | 6.3
 |  |  |  |  | in the changes it shows 0 with the arrow right where is should have been 1 and the arrow up
 |  |  |  |  | here what I really want with my formula:
 |  |  |  | - | the lower values against last month should show number plus the arrow up
 |  |  |  | - | the higher values against last month should show number plus the arrow down
 |  |  |  | - | no data means NR
 |  |  |  | - | 0 data should show "Stable"
 |  |  |  | - | the same data against last month and current month should also show stable
Spreadsheet: 850564d1700926155-automatically-expand-formula-when-adding-coumns-book1
Sheet: Sheet1

WEEK1 | WEEK2 | DIFF
1 | 2
4 | 6
6 | 9
8 | 15
5 | 9
2 | 3
5 | 6
Spreadsheet: 162342d1339803036-excel-2007-how-to-return-different-values-in-a-range-according-to-date-without-repeating-the-same-mjc-registro-interactivo
Sheet: ESTSR

[NAME]
HOJA DE NOTAS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-01 00:00:00
ESCUELA : |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-09-01 00:00:00
GRUPO: |  | 2ndo R |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-01 00:00:00
MAESTRO: |  | [NAME] |  |  |  |  |  | Firma del padre o encargado |  |  |  |  |  |  | _____________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-01 00:00:00
CLASE DE: |  | Ingles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-01 00:00:00
HORA: |  |  |  |  |  |  |  | Entregado en la libreta en la fecha: |  |  |  |  |  |  |  | ________________________________ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-01-01 00:00:00
AÑO: |  | 2012-2013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-02-01 00:00:00
Número del estudiante |  |  | 1 |  | [NAME]: | 2012-08-01 00:00:00 |  |  | Nombre del Estudiante: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-03-01 00:00:00
Puntos Total de Trabajo |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-04-01 00:00:00
[NAME] obtenida |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2013-05-01 00:00:00
Puntos Total de Exam o Proyectos
[NAME] obtenida
Spreadsheet: 766783d1644054661-log-book-weekly-accumulation-logbook
Sheet: Summary

Week Beginning | Current Week |  |  |  | Year-To Date |  |  |  | Total Cumulative  Hours
 | CC | CR | CPD | Supervision | CC | CR | CPD | Supervision
2022-01-17 00:00:00
Spreadsheet: 1476973d-4060-4a75-bcdf-e6e386a156ad
Sheet: Sheet1

CALCULATION FOR CITY OF FLAGSTAFF CONTRACTING TAX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
FILL IN BLOCKED CELLS ONLY. USE TAB KEY TO MOVE TO NEXT CELL.
PLEASE COMPLETE THE FOLLOWING INFORMATION FROM THE BLANK RETURN MAILED TO YOU BY THE CITY:
TAXPAYER NAME |  |  | TAX RATE | 0.08446
MAILING ADDRESS
CITY, ST ZIP
CITY LICENSE NO.
REPORT PERIOD
[NAME] IF NOT RECEIVED BY
BUSINESS DESCRIPTION LINE 1
BUSINESS DESCRIPTION LINE 2
BUS. CLASS LINE 1
BUS. CLASS LINE 2
SFX LINE 1
SFX LINE 2
PLEASE COMPLETE THE FOLLOWING INFORMATION FROM YOUR INCOME RECORDS:
GROSS CONTRACTING INCOME LINE 1
GROSS CONTRACTING INCOME LINE 2
DOES THIS INCOME INCLUDE TAX?
SUBCONTRACTING DEDUCTION LINE 1
SUBCONTRACTING DEDUCTION LINE 2
OUT-OF-CITY DEDUCTION LINE 1
OUT-OF-CITY DEDUCTION LINE 2
STATE LAND DEDUCTION LINE 1
STATE LAND DEDUCTION LINE 2
INCOME SUBJECT TO CITY TAX: 1500 | 0
INCOME SUBJECT TO CITY TAX: 1600 | 0
TAX AMOUNT YOU OWE | 0
ENTER AMOUNT OF CHECK
IN CITY JOBS SUBJECT TO CITY TPT - 1 | 0
IN CITY JOBS SUBJECT TO STATE TPT - 1 | 0
IN CITY JOBS SUBJECT TO CITY TPT - 2 | 0
IN CITY JOBS SUBJECT TO STATE TPT - 2 | 0
TAX FACTOR FOR 8.446% TAX RATE | 0.05204195
TAX FACTOR 6.725% | 0.04188174
CITY TAX RATE | 0.01721
CITY TAX ON LAND LINE 1 | 0
COMMON BASE LINE 1 | 0
CITY TAX ON LAND LINE 2 | 0
COMMON BASE LINE 2 | 0
DEDUCTIONS | SUBCONTRACTOR | OUT-OF-CITY | LAND | TAX COLLECTED | STD 35%
DEDUCTIONS CODE | # 7 | # 9 | # 8 | # 11 | # 6
LINE 1 |  |  |  | 0
LINE 2 |  |  |  | 0
PRINTING INSTRUCTIONS:
1. GO TO WORKSHEET TAB 'TPT Return Front Page' AND PRESS PRINT ICON ON THE TOOLBAR.
2. GO TO WORKSHEET TAB 'TPT Return Back Page' AND PRESS PRINT ICON ON THE TOOLBAR.
3. PRINT THIS WORKSHEET FOR YOUR RECORDS BY PRESSING THE PRINT ICON ON THE TOOLBAR.
OTHER INSTRUCTIONS:
1. SIGN AND DATE THE TAX RETURN.
2. MAIL TAX RETURN WITH REMITTANCE TO THE CITY OF FLAGSTAFF, [NAME] 22518, FLAGSTAFF AZ 86002-2518.
Spreadsheet: 804391d1668037293-formula-for-printing-all-sheets-xcvbtr10
Sheet: 22

 |  | [NAME])  YA MSHIRIKA T.A.G HERMON REVIVAL CHURCH |  |  |  |  |  |  |  |  | MWAKA
 |  | JINA KAMILI | WEEKS | JAN | FEB | [NAME] | APRIL | MAY | [NAME] | JULY | AUGU | SEPT | OKT | NOV | DEC | JUMLA
 |  | HT18 | 1
 |  |  | 2
 |  |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | JUMLA
Spreadsheet: holden_salisbury__12292__Deals_Jan
Sheet: Jan 08-14

CounterParty | P.O.D. | MW | Delivery Pattern | Term | $ | Tariff | Currently Delivering? | Enpower Deal #
Nevada Power | Mead 230 | 50 | HLH | thru 4/6/02 | 150 |  | YES | 528030
Nevada Power | Palo Verde | 50 | HLH | thru 4/6/02 | 88.5 |  | YES | 559065
Nevada Power | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 515363
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 101 |  | YES | 498108
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 136 |  | YES | 548872
Sierra Pacific | Palo Verde | 25 | HLH | thru 4/6/02 | 147 |  | YES | 514866
El Paso Electric | Palo Verde | 50 | HLH | thru 4/6/02 | 121 |  | YES | 502431
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 69 |  | YES | 399966
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 70 |  | YES | 501436
CRC | Palo Verde | 25 | HLH | thru 4/6/02 | 110 |  | YES | 618755
Nevada Power | Palo Verde | 25 | LLH | thru 4/6/02 | 70 |  | YES | 503214
Nevada Power | Palo Verde | 50 | LLH | thru 4/6/02 | 88.5 |  | YES | 559065
WALC | Pinnacle Peak | 25 | RTC | thru 4/6/02 | 45 |  | YES | 705583
 |  |  |  | BOM $ Requirement |  | Market Price | 1 Week $ Requirement
In the Money Totals | Palo Verde | 200 | HLH |  |  | 27
 | Mead 230 | 25 | HLH |  |  | 28
 | Pinnacle Peak |  | HLH |  |  | 28.5
 | Total |  |  |  |  |  |  | Payable to AEP
 | Palo Verde | 75 | HLH |  |  | 26
 | Palo Verde | 75 | LLH |  |  | 17.5
 | Total |  |  |  |  |  |  | Payable to PNM
Spreadsheet: 30a050ac-e2ca-4d4a-b4f7-d79f3739e4af
Sheet: Sheet1

 | National School Lunch Program Estimated Reimbursement
 | Estimated Daily Participation | 200
 | # of Operating Days | 21 |  | 2010-2011 Rates
 |  |  |  | *Reimbursement Rates:
 | Free |  |  | Free: | 2.72
 | Reduced |  |  | Reduced: | 2.32
 | Paid |  |  | Paid: | 0.26
 |  |  |  |  | Daily Average Total
 |  |  |  |  | Monthly  Federal Reimbursement
 |  |  |  | **Liquor Tax | 0.17
 |  |  |  | ***Commodities | 0.2025
 | Total Estimated Reimbursement
 | Estimated Lunch Program Funding |  |  | INSTRUCTIONS: Enter the number of children you expect to participate in your lunch program each day in the box above entitled "Estimated Daily Participation." The spreadsheet will give you an estimated monthly reimbursement amount from the National School Lunch Program based on average percentages of eligible free, reduced and paid students.  Actual reimbursement will depend on current reimbursement rates and your actual percentages of eligible free, reduced-price and paid children and lunch participation.
 | Local Funding:
 | Paid: | 2
 | Reduced: | 0.4
 | Federal Funding:
 | State:
 | Commodities:
 | Total Program Funds/Month:
 | *Federal reimbursement and commodity rates change each year and become effective July 1st through June 30th.
 | **State reimbursement changes throughout the year based on state liquor tax funds.
 | **State reimbursement is only distributed to public institutions run under the aupice of the Board of Education participating in the National School Lunch Program.
 | ***Commodities are ordered by schools in lieu of cash. A dollar amount is assigned to schools based on projected and past number of meals served.
Spreadsheet: 178123d1346668860-find-max-alpha-grade-for-students-example
Sheet: Sheet1

Name | Grade 1 | [NAME] | [NAME] | [NAME] | highest
[NAME] | C | D | E | F
[NAME] | B |  | C
[NAME] | A* | D | E | G
Spreadsheet: 841876d1694008521-if-between-date-ranges-sample-book
Sheet: Sheet1

 | Out of Month | Requested Date | Calculated Date
 |  | 2023-09-01 00:00:00 | 2023-09-04 00:00:00
 |  | 2023-09-15 00:00:00 | 2023-09-16 00:00:00
 |  | 2023-09-25 00:00:00 | 2023-10-05 00:00:00
 |  | 2023-09-11 00:00:00 | 2023-10-01 00:00:00
 |  | 2023-10-12 00:00:00 | 2023-10-15 00:00:00
 |  | 2023-10-18 00:00:00 | 2023-10-20 00:00:00
 |  | 2023-09-21 00:00:00 | 2023-09-29 00:00:00
Spreadsheet: 262812d1378294806-lookup-multiple-rows-where-2-conditions-must-be-met-dgt1
Sheet: Output

ID |  | Team | A
 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 | 2013-07-18 00:00:00 | 2013-07-19 00:00:00 | 2013-07-20 00:00:00 | 2013-07-21 00:00:00 | 2013-07-22 00:00:00 | 2013-07-23 00:00:00 | 2013-07-24 00:00:00 | 2013-07-25 00:00:00 | 2013-07-26 00:00:00 | 2013-07-27 00:00:00 | 2013-07-28 00:00:00 | 2013-07-29 00:00:00 | 2013-07-30 00:00:00 | 2013-07-31 00:00:00 | 2013-08-01 00:00:00 | 2013-08-02 00:00:00 | 2013-08-03 00:00:00 | 2013-08-04 00:00:00 | 2013-08-05 00:00:00 | 2013-08-06 00:00:00 | 2013-08-07 00:00:00 | 2013-08-08 00:00:00 | 2013-08-09 00:00:00 | 2013-08-10 00:00:00 | 2013-08-11 00:00:00 | 2013-08-12 00:00:00 | 2013-08-13 00:00:00 | 2013-08-14 00:00:00 | 2013-08-15 00:00:00 | 2013-08-16 00:00:00 | 2013-08-17 00:00:00 | 2013-08-18 00:00:00 | 2013-08-19 00:00:00 | 2013-08-20 00:00:00 | 2013-08-21 00:00:00 | 2013-08-22 00:00:00 | 2013-08-23 00:00:00 | 2013-08-24 00:00:00 | 2013-08-25 00:00:00 | 2013-08-26 00:00:00 | 2013-08-27 00:00:00 | 2013-08-28 00:00:00 | 2013-08-29 00:00:00 | 2013-08-30 00:00:00 | 2013-08-31 00:00:00 | 2013-09-01 00:00:00 | 2013-09-02 00:00:00 | 2013-09-03 00:00:00 | 2013-09-04 00:00:00 | 2013-09-05 00:00:00 | 2013-09-06 00:00:00 | 2013-09-07 00:00:00 | 2013-09-08 00:00:00 | 2013-09-09 00:00:00 | 2013-09-10 00:00:00 | 2013-09-11 00:00:00 | 2013-09-12 00:00:00 | 2013-09-13 00:00:00 | 2013-09-14 00:00:00 | 2013-09-15 00:00:00 | 2013-09-16 00:00:00 | 2013-09-17 00:00:00 | 2013-09-18 00:00:00 | 2013-09-19 00:00:00 | 2013-09-20 00:00:00 | 2013-09-21 00:00:00 | 2013-09-22 00:00:00 | 2013-09-23 00:00:00 | 2013-09-24 00:00:00 | 2013-09-25 00:00:00 | 2013-09-26 00:00:00 | 2013-09-27 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-09-30 00:00:00 | Total
Spreadsheet: 471430d1469011299-designing-a-file-to-split-out-and-consolidate-each-month-monthly-template
Sheet: Template

2016-05-01 00:00:00
 |  |  |  |  | PM INPUT |  | FORM |  | FORM | FORM |  | FORM | FORM |  |  |  | FORM | FORM |  | FORM |  | FORM |  | FORM |  |  |  | PM INPUT | FORM | PM INPUT | FORM
UK Number | First Name | Surname | PM at 1st of Month | Capability at 1st of month (taken from hc file) | Primary Cost Centre (if applicable - not projects) | Aligned date (if in current month) | Potential working days in 1st month | Leaving date | Potential working days in last month | Day Rate | Days To Bill For | Day Charge | Phone | Laptop | Infastructure Total | Bank (taken from ann.hours) | Overtime Rate | Bank Charge | Has [NAME]? | Vehicle (depending on capability) | [NAME] (taken from hc file) | [NAME] | [NAME] (taken from bonus file) | Bonus Total Including Mark-up | Sickness/Unpaid Leave in month (taken from sickness file) | Sickness Reconcile Previous Month (final amount of sickness taken from sickness file) | Leave / Reconcile Total | PM Days Amendment | PM Days Amendment Total | PM Adhoc Allowance | GRAND TOTAL