tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 386223d1427695779-formula-to-capture-data-from-one-sheet-to-another-in-same-manner-by-ignoring-blank-cells-need-help
Sheet: Working

Sr # | Dat Header | As per ur formula | what I want
 |  |  | if I enter formula
1 | A |  | A
 | asdf |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
2 | B |  | B
 | asdf |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
3 | C |  | C
 | asdf |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
 |  |  | formula should ignore blank cells
4 | DT12 |  | DT12
Spreadsheet: 122797d1317152429-creating-a-sorted-spreadsheet-using-data-from-2-separate-sheets-copy-of-copy-of-test-data-1
Sheet: Sheet2

DISPLAY_ORDER | INDENT_LEVEL | DISPLAY_TEXT | DISPLAY_NUMBER
0 | 0 | Store | [PHONE]
1 | 1 | Deli | [PHONE]
2 | 2 | Bakery | [PHONE]
3 | 3 | Pharmacy | [PHONE]
Spreadsheet: 845441d1696958058-pivot-with-multiple-tabs-as-range-forecasts-and-orders-10102023
Sheet: NER

Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI |  | Order Date | PO | Description | Item Code | Qty
NERD ORIGINAL 12/12Z CN | 09452
NERD ZERO CAL 12/12Z CN | 09453
Product Name | Item Code | Total Sales | Average Sales per Day | GV On Floor Inv | GV On Floor DOI | DOI in 2 Weeks | DOI in 3 Weeks | DOI in 4 Weeks | GV In Orders | GV On Floor After Order | GV New DOI | GV New Order in [NAME] | In Cases | GV Ending DOI
NERD ORIGINAL 12/12Z CN | 09452
NERD ZERO CAL 12/12Z CN | 09453
Spreadsheet: john_griffith__15874__11_12_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 90 | 100 | 70.8 | 78.7 | 1.01 | 2001-11-12 11:52:00
 | CL F2 | 21.5 | 265 | 275 | 52.4 | 54.3 | 0.72 | 2001-11-12 11:52:00
 | CL G2 | 21.5 | 365 | 380 | 50.8 | 52.9 | 0.7 | 2001-11-12 11:52:00
 | CL H2 | 21.5 | 430 | 450 | 50 | 52.4 | 0.69 | 2001-11-12 11:52:00
 | CL J2 | 21.5 | 475 | 490 | 48.5 | 50 | 0.67 | 2001-11-12 11:52:00
 | CL K2 | 21.5 | 505 | 525 | 46 | 47.8 | 0.63 | 2001-11-12 11:52:00
 | CL M2 | 21.5 | 535 | 550 | 45 | 46.2 | 0.62 | 2001-11-12 11:52:00
 | CL N2 | 21.5 | 550 | 570 | 42.8 | 44.4 | 0.59 | 2001-11-12 11:52:00
 | CL Q2 | 21.5 | 560 | 580 | 41 | 42.5 | 0.56 | 2001-11-12 11:52:00
 | CL U2 | 21.5 | 560 | 580 | 39 | 40.4 | 0.54 | 2001-11-12 11:52:00
 | [NAME] | 21.5 | 565 | 585 | 37.3 | 38.7 | 0.51 | 2001-11-12 11:52:00
 | CL X2 | 21.5 | 565 | 590 | 35.8 | 37.4 | 0.49 | 2001-11-12 11:52:00
 | [NAME] | 21.5 | 565 | 590 | 34.5 | 36.1 | 0.48 | 2001-11-12 11:52:00
 | CL M3 | 21.5 | 560 | 580 | 28.8 | 29.8 | 0.4 | 2001-11-12 11:52:00
 | CL Z3 | 21.5 | 560 | 580 | 25.5 | 26.5 | 0.35 | 2001-11-12 11:52:00
Spreadsheet: 648069d1572869940-highlight-the-latest-date-in-column-b-each-time-the-content-of-column-a-changes-jc_2
Sheet: Sheet1

Serial No | Date of Payment
413313 | 2018-05-14 00:00:00
417651 | 2019-09-18 00:00:00
419145 | 2014-12-01 00:00:00
419704 | 2019-05-14 00:00:00
419704 | 2019-07-02 00:00:00
422740 | 2014-12-15 00:00:00
422740 | 2015-12-15 00:00:00
422740 | 2016-09-26 00:00:00
422740 | 2016-11-16 00:00:00
422740 | 2016-12-15 00:00:00
422740 | 2017-07-01 00:00:00
422740 | 2017-12-15 00:00:00
422740 | 2018-09-01 00:00:00
422740 | 2018-12-15 00:00:00
423026 | 2019-03-13 00:00:00
424684 | 2018-11-26 00:00:00
424684 | 2018-12-10 00:00:00
424684 | 2019-04-08 00:00:00
431276 | 2019-05-14 00:00:00
434870 | 2019-04-14 00:00:00
Spreadsheet: 788636d1658593682-sumifs-or-countifs-on-multiple-rows-and-columns-holiday-planner-for-testing-mrbenn-
Sheet: Team Annual Leave

 | Deductions |  |  | Leave
Name | SICK LEAVE | OTHER | OVERTIME | PLANNED ANNUAL LEAVE | UNPLANNED ANNUAL LEAVE | TOTAL ANNUAL LEAVE BOOKED/TAKEN | ANNUAL LEAVE LEFT | ANNUAL LEAVE ENTITLEMENT
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 |  |  |  |  |  |  |  | 23
 | Holiday
 | Unplanned Holiday
 | 1/2 Holiday
 | Sick
 | 1/2 Sick
 | Other - Unpaid give details
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 1/2 Bank Holiday
 | Bank Holiday
Spreadsheet: 187199d1350376945-how-to-search-for-a-month-in-a-worksheet-that-has-all-the-months-in-0a1_fot_1verjaarsdae-test1
Sheet: Whole Month

8 | <<<Choose Month |  |  |  |  |  |  |  |  |  |  | 1
Datum Verjaar | Ouderdom | Naam | Van | Tel# | Address | Address 2 | Address 3 | Address 4 | [NAME] | E-pos
 |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  | 5
 |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  | 11
 |  |  |  |  |  |  |  |  |  |  |  | 12
Spreadsheet: 674124d1587669626-sum-of-products-meeting-criteria-on-multiple-rows-matching-other-criteria-w-o-helper-col-needhelp
Sheet: Sheet1

Value | Completed | Excluded | % | Sums
100 | 50
100 | 52
100 | 100 | x
100 | 0
100 | 40
100 | 90
EXCLD_COL = C2:C7 |  |  | Result:
Spreadsheet: e3103565-9042-4324-90f1-56a00b006051
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
8550 | 51375 | [NAME] | Walsh B1 | USA | 4 | 00:14:26 | 00:02:38 | 00:32:36 | 00:01:04 | 00:22:14 | 1 | 01:13:01
Spreadsheet: phillip_m_love__30140__200005_OA
Sheet: SITHE-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:   ECTR (EGM)
REGION: SITHE
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: 187302d1350401343-count-user-input-per-row-basis-and-verify-100-test
Sheet: Test

Activities |  |  |  |  |  | Count of each Row should not be greater than 100
Run | Walk | Cycle | Weights | Swim | Tennis
80 | 10 | 0 | 0 | 0 | 0 |  |  | Row 1
100 | 0 | 0 | 0 | 0 | 0 |  |  | Row 2
50 | 50 | 0 | 0 | 0 | 0 |  |  | Row 3 |  |  | range | 0
50 | 50 | 0 | 0 | 0 | 0 |  |  | Row 4 |  |  |  | 10
100 | 0 | 0 | 0 | 0 | 0 |  |  | Row 5 |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  | 50
 |  |  |  |  |  |  |  |  |  |  |  | 60
 |  |  |  |  |  |  |  |  |  |  |  | 70
 |  |  |  |  |  |  |  |  |  |  |  | 80
 |  |  |  |  |  |  |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  | 100
Spreadsheet: 752bf41c-bbae-4ca2-ba88-f3700b5bc18d
Sheet: Manager Order Form

Ranger BOYS Team Order Form- REQUIRED ITEMS
 | Team Name |  |  |  |  |  |  |  |  |  |  | BOYS
 | Manager
 | Contact Number
 | Contact Email
Instructions:  [NAME] the shaded areas from the individual form and paste it on the yellow box.  Do this for each player, then email the completed form to [EMAIL]
[NAME] | Youth
 | Adult
White Jersey | Youth
 | Adult
[NAME] | Youth
 | Adult
White Short | Youth
 | Adult
 | Royal Sock
 | White Sock
Royal Jacket | Youth
 | Adult
Pant | Youth
 | Adult
Backpack | Royal
Select | [NAME]
[NAME] | Size 5
Spreadsheet: 94517d1294316140-to-send-email-from-excel-avoiding-outlook-copy-of-salary
Sheet: Sheet

EMPNAME | SNO | LOCATION_NAME | [NAME] | [NAME] | GRADE_NAME | DEPARTMENT_NAME | COSTCENT_NAME | REGION | BANK_NAME | ACCOUNTNO | PFNO | PANNO | DOB | DOJ | CTC | VARIABLE PAY | N_YEAR | [NAME] | WRKDAYS | BASIC | HRA | CONVEYANCE | LTA | SPL_ALLO | CCA | ADD_PAY | INCENTIVE | REF_REWARD | MED_TAX | MED_REIMB | RELO_ALL | DATA_ENTAL | DRIV_REIMB | BONUS | GROSS_EARN | PF | VPF | PT | INCOMETAX | ESI | PER_LOAN | CAR_LOAN | TWO_WHLOAN | PL_LOAN | FESTIV_LON | FESTV_LON1 | MOBIL_DEDU | MISC_DED | LWF | IDCARD_DED | SAL_ADV | GROSS_DED | NET_PAY
SATHISH KUMAR R | 0243 | CHENNAI | [NAME] | ADDITIONAL SALES OFFICER | EM1 | SALES | 0015-MINT | CHENNAI-NORTH | HDFC | 04921140014598 | TN/53112/0235 |  | 1973-05-02 00:00:00 | 2008-07-28 00:00:00 | 140976 | 0 | 2010 | 0 | 30 | 6500 | 3250 | 609 | 0 | 0 | 0 | 0 | 5796 | 0 | 0 | 609 | 0 | 0 | 0 | 0 | 16764 | 780 | 0 | 180 | 0 | 294 | 0 | 0 | 0 | 529 | 0 | 0 | 398 | 0 | 0 | 0 | 0 | 2181 | 14583
SAMSUDHEEN S | 0245 | CHENNAI | [NAME] | ADDITIONAL SENIOR SALES OFFICER | EM2 | SALES | 0013-ROYAPURAM | CHENNAI-NORTH | HDFC | 04921140014606 | TN/53112/0237 |  | 1983-06-20 00:00:00 | 2008-07-28 00:00:00 | 156516 | 0 | 2010 | 0 | 30 | 6500 | 3250 | 800 | 0 | 463 | 0 | 0 | 5174 | 0 | 0 | 1250 | 0 | 0 | 0 | 0 | 17437 | 780 | 0 | 180 | 0 | 306 | 0 | 0 | 0 | 1433 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2699 | 14738
ADHINARAYAN L | 0250 | CHENNAI | [NAME] | SR RELATIONSHIP OFFICER | EM2 | SALES | 0025-PURASAIVAKKAM | CHENNAI-CENTRAL | HDFC | 01411140020453 | TN/53112/0242 |  | 1980-10-03 00:00:00 | 2008-08-01 00:00:00 | 169572 | 0 | 2010 | 0 | 30 | 6500 | 3250 | 800 | 0 | 1551 | 0 | 0 | 5678 | 0 | 0 | 1250 | 0 | 0 | 0 | 0 | 19029 | 780 | 0 | 180 | 0 | 334 | 0 | 0 | 0 | 687 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1981 | 17048
SURESH R | 0251 | CHENNAI | [NAME] | RELATIONSHIP OFFICER | EM1 | SALES | 0007-VILLIVAKKAM | CHENNAI-NORTH | HDFC | 04921140014520 | TN/53112/0243 |  | 1984-04-08 00:00:00 | 2008-08-01 00:00:00 | 134136 | 0 | 2010 | 0 | 30 | 6300 | 3150 | 486 | 0 | 0 | 0 | 0 | 3739 | 0 | 0 | 486 | 0 | 0 | 0 | 0 | 14161 | 756 | 0 | 180 | 0 | 248 | 0 | 0 | 0 | 841 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2025 | 12136
GAJENDRAN N | 0255 | [NAME] | [NAME] | SATELLITE BRANCH MANAGER | EM2 Plus | SALES | 0105-SRI RANGAM | [NAME] | HDFC | 04921140014797 | TN/53112/0247 |  | 1978-04-03 00:00:00 | 2008-08-04 00:00:00 | 170472 | 0 | 2010 | 0 | 30 | 6500 | 3250 | 800 | 0 | 1626 | 0 | 0 | 3125 | 0 | 0 | 1250 | 0 | 0 | 0 | 0 | 16551 | 780 | 0 | 180 | 0 | 290 | 0 | 0 | 0 | 0 | 444 | 0 | 0 | 0 | 0 | 0 | 0 | 1694 | 14857
NEELAMEGAKANNAN N | 0257 | [NAME] | [NAME] | BRANCH MANAGER | EM3 | SALES | 0103-ARIYAMANGALAM | [NAME] | HDFC | 04921140014694 | TN/53112/0249 | AJAPN8159N | 1981-06-12 00:00:00 | 2008-08-04 00:00:00 | 274512 | 0 | 2010 | 0 | 30 | 8800 | 4400 | 800 | 0 | 6570 | 0 | 0 | 7930 | 0 | 0 | 1250 | 0 | 0 | 0 | 0 | 29750 | 1056 | 0 | 180 | 1589 | 521 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3346 | 26404
Spreadsheet: 46959d1245870396-combine-several-spreadsheets-into-one-vendor-documents-register-p01-20090622
Sheet: TTE

No. | P.O. No. | Submitted Date | Tansmittal No. | [NAME]) | Vendor Document No. | Document Title | Latest Version | Vendor | Status | Comments (Y,N) | Transmittal Returned By Eng.Dept | Status | Date | Transmittal Returned by Company | Status | Date | Remarks
1 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-PL-TTE-00001 | TT-P241-EFL-00-POS-001 | Project Overall Schedule | P00 | TTE | A | N
2 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-PG-TTE-00002 | TT-P241-EFL-00-PEP-001 | Project Execution Plan | P00 | TTE | A | N
3 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-QA-TTE-00003 | TT-P241-EFL-00-QAL-001 | Project Quality Plan | P00 | TTE | A | N
4 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-GA-TTE-00011 | TT-P241-EFL-75-EDS-001 | CCTV-Equipment Data Sheets | P00 | TTE | A | N
5 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-GA-TTE-00012 | TT-P241-EFL-76-EDS-001 | Intruder Detection System-Equipment Data Sheets | P00 | TTE | A | N
6 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-GA-TTE-00014 | TT-P241-EFL-60-EDS-001 | Telephone System-Equipment Data Sheets | P00 | TTE | A | N
7 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-GA-TTE-00017 | TT-P241-EFL-95-EDS-001 | UPS-Equipment Data Sheets | P00 | TTE | A | N
8 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-GA-TTE-00018 | TT-P241-EFL-30-EDS-001 | LAN-Equipment Data Sheets | P00 | TTE | A | N
9 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-EB-TTE-00019 | TT-P241-EFL-75-BOM-001 | CCTV-Bill of Material | P00 | TTE | A | N
10 | 3435-510-PO-0084A | 2008-12-31 00:00:00 | WIP-PCU-ENG-TN-0327 | 3435-510-T-EB-TTE-00020 | TT-P241-EFL-76-BOM-001 | Intruder Detection System-Bill of Material | P00 | TTE | A | N
Spreadsheet: sara_shackleton__36501__ENE MTM 0630 revised 2
Sheet: DWR 1304771

Current Date
Termination Date
Interest Payment Date
Quarter End Date
Lowest Date
EFFECTIVE JUNE 1 THIS WAS MOVED TO PHANTOM
Phantom Stock Hedge |  |  |  | Effective Date | 1999-12-16 00:00:00
Warburg Dillon Read - Ref # |  | 1304771 |  | Termination Date | 2000-12-18 00:00:00
 |  |  |  |  |  | Total |  |  |  | Total |  |  |  | Total |  |  |  | Total
 |  | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End |  | Quarter End | Quarter End | Quarter End
ENE |  | 1999-12-31 00:00:00 |  | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 | 2000-03-31 00:00:00 |  | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 | 2000-06-30 00:00:00 |  | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 | 2000-09-30 00:00:00 |  | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 | 2000-12-31 00:00:00 |  | Year 2000 |  | LTD
 | Market Price
Shares: | 280000
Opening price | 36.9128
Interest Payment Dates |  | 2000-03-16 00:00:00 |  | 2000-03-16 00:00:00 | 2000-06-18 00:00:00 |  |  | 2000-06-18 00:00:00 | 2000-09-17 00:00:00 |  |  | 2000-09-17 00:00:00 | 2000-12-18 00:00:00 |  |  | 2000-11-15 00:00:00
Equity Payment (Warburg pays if price goes up/Enron pays if price goes down)
 | Opening value
 | Closing Value
 | MTM
Interest Payment (Enron pays)
Expected quarterly dividend |  | 0.125
Spread |  | 0.008 |  | 0.008 | 0.008 |  |  | 0.008 | 0.008 |  |  | 0.008 | 0.008 |  |  | 0.008 | 0.008
Dividend rebate
Interest Rate |  | 0.0614 |  |  | 0.0609 |  |  |  | 0.0575 |  |  |  | 0.05625 |  |  |  | 0
Annual Day Count |  | 360 |  | 360 | 360 |  |  | 360 | 360 |  |  | 360 | 360 |  |  | 360 | 360
Beginning of period - Interest
End of period - Interest
Day Count - Interest
Beginning of period - Annual Factor
End of period - Annual Factor
Day Count for Annual Factor
Annual Factor
All in Rate
Payment
Net receipt/(payment)
Net receipt/(payment) on Interest Payment Date
Amount per Bank |  |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Difference
Spreadsheet: 0bc0c2c5-6e15-41b9-9da3-1c420673ebf0
Sheet: TEMPLATE-Figure 1 Amounts

Figure 1 |  |  |  |  |  | Figure 2
Arizona 2006-07 | Statewide |  | Maricopa County
Per-Pupil Revenue
District
Charter
Difference
Per-Pupil Revenue by Source | District | Charter | District | Charter
Federal
State
Local
Other
Indeterminate | 0 | 0 | 0 | 0
Total
Enrollment
District
 |  |  |  |  |  |  | District | Charter | Difference
Charter |  |  |  |  |  | Arizona
 |  |  |  |  |  | Maricopa County
Number of Charters |  |  |  |  |  | City B Name Here | 0 | 0 | 0
Total Revenue |  |  |  |  |  | City C Name Here | 0 | 0 | 0
District
Charter
Total
Percentage of Revenue by Source | District | Charter | District | Charter |  | Figure 4
Federal
State
Local
Other
Change in district school funding if subjected to charter funding structure
 |  |  |  |  |  |  | Federal | State | Local | Other | Indeterminate
 |  |  |  |  |  | Statewide District |  |  |  |  | 0
 |  |  |  |  |  | Statewide Charter |  |  |  |  | 0
 |  |  |  |  |  | Maricopa-District |  |  |  |  | 0
 |  |  |  |  |  | Maricopa-Charter |  |  |  |  | 0
 |  |  |  |  |  | City B District | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | City B Charter | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | City C District | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | City C Charter | 0 | 0 | 0 | 0 | 0
Spreadsheet: 669403d1585340184-dates-in-budget-financial-test-sample
Sheet: Sheet1

 |  | Start Date |  |  | Adjustment 1 |  |  | Adjustment 2 |  |  | Adjustment 3 |  |  | End
Name | Title | Date | Charge p.a. | Percentage | Date | Charge p..a | Percentage | Date | Charge p.a. | Percentage | Date | Charge p.a. | Percentage | Date
Contractor 1 | Title 1 | 2020-01-01 00:00:00 | 50000 | 1 | 2021-01-01 00:00:00 | 70000 | 1 |  |  |  |  |  |  | 2023-12-31 00:00:00
Contractor 2 | Title 2 | 2020-05-01 00:00:00 | 40000 | 0.7
Contractor 3 | Title 3 | 2021-03-01 00:00:00 | 35000 | 0.8 |  |  |  |  |  |  |  |  |  | 2024-12-01 00:00:00
Contractor 4 | Title 4 | 2022-05-01 00:00:00 | 50000 | 0.9 | 2023-06-01 00:00:00 | 60000 | 1 | 2024-12-01 00:00:00 | 70000 | 1
Contractor 5 | Title 5 | 2022-06-01 00:00:00 | 60000 | 1 | 2022-12-01 00:00:00 | 65000 | 1 | 2023-06-01 00:00:00 | 70000 | 1 | 2023-12-01 00:00:00 | 75000 | 1
 |  |  |  | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74 | 75 | 76 | 77 | 78 | 79 | 80 | 81 | 82 | 83 | 84
 |  |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00
Spreadsheet: 546454d1510061094-divide-a-value-over-several-cells-zudecke-bell-curve
Sheet: Sheet1

Total | 1000 |  | Week | Value
 |  |  | 1
Spreadsheet: andy_zipper__248__Global_Prod 6-5-01 EM
Sheet: Taken Down Prior to Exp

Global Products that were not made available on
and have not yet expired
Global Product Short Desc.
Credit Dflt Swap Enel SpA                5 Years         bpa/USDm
Credit Dflt Swap Iberdrola               5 Years         bpa/USDm
Credit Dflt Swap RWE AG                  5 Years         bpa/USDm
Credit Dflt Swap Vattenfall              5 Years         bpa/USDm
[NAME] ARA                 Jul-Sep02       EUR/mt
[NAME] ARA                 Oct-Dec02       EUR/mt
EUR Plastic Swap HDPE F ICIS Ger         Jul01-Jun02     DEM/kg
EUR Plastic Swap HDPE F ICIS Ger         Jul-Dec01       DEM/kg
EUR Plastic Swap LDPE F ICIS Ger         Jul01-Jun02     DEM/kg
EUR Plastic Swap LDPE F ICIS Ger         Jul-Dec01       DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Jul01-Jun02     DEM/kg
EUR Plastic Swap LLDPE ICIS Ger          Jul-Dec01       DEM/kg
EUR Plastic Swap PP Inj ICIS Ger         Jul01-Jun02     DEM/kg
EUR Plastic Swap PP Inj ICIS Ger         Jul-Dec01       DEM/kg
EUR Plastic Swap PS GP ICIS Ger          Jul01-Jun02     DEM/kg
EUR Plastic Swap PS GP ICIS Ger          Jul-Dec01       DEM/kg
For Curr Exch    Forward                 06Jun01         JPY/USD
For Curr Exch    Forward                 06Jun01         USD/EUR
For Curr Exch    Forward                 06Jun01         USD/GBP
For Curr LME     LME (Spot)              06Jun01         JPY/USD
For Curr LME     LME (Spot)              06Jun01         USD/EUR
For Curr LME     LME (Spot)              06Jun01         USD/GBP
SG Dubai Swap    Platts                  Q4 2001         USD/bl/m
SG E-W FO Diff   Platts                  01-30Jul01      USD/mt/m
[NAME]Jun01           USD/bbl
UK E-W FO Diff   Platts                  Oct-Dec01       USD/mt/m
US METH FOB Phy  Houston                 Jun01           USD/Gl-b