tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 810477d1671798836-auto-formulas-from-one-sheet-to-another-formula-help
Sheet: Dec Summary

 |  |  |  |  |  |  |  | F |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | F
 |  |  |  |  |  |  |  | Donnerstag | Freitag | Samstag | Sonntag | Montag | Dienstag | Mittwoch | Donnerstag | Freitag | Samstag | Sonntag | Montag | Dienstag | Mittwoch | Donnerstag | Freitag | Samstag | Sonntag | Montag | Dienstag | Mittwoch | Donnerstag | Freitag | Samstag | Sonntag | Montag | Dienstag | Mittwoch | Donnerstag | Freitag | Samstag
 | Nr | Name | Vorname | Reiter |  |  |  | 2022-12-01 00:00:00 | 2022-12-02 00:00:00 | 2022-12-03 00:00:00 | 2022-12-04 00:00:00 | 2022-12-05 00:00:00 | 2022-12-06 00:00:00 | 2022-12-07 00:00:00 | 2022-12-08 00:00:00 | 2022-12-09 00:00:00 | 2022-12-10 00:00:00 | 2022-12-11 00:00:00 | 2022-12-12 00:00:00 | 2022-12-13 00:00:00 | 2022-12-14 00:00:00 | 2022-12-15 00:00:00 | 2022-12-16 00:00:00 | 2022-12-17 00:00:00 | 2022-12-18 00:00:00 | 2022-12-19 00:00:00 | 2022-12-20 00:00:00 | 2022-12-21 00:00:00 | 2022-12-22 00:00:00 | 2022-12-23 00:00:00 | 2022-12-24 00:00:00 | 2022-12-25 00:00:00 | 2022-12-26 00:00:00 | 2022-12-27 00:00:00 | 2022-12-28 00:00:00 | 2022-12-29 00:00:00 | 2022-12-30 00:00:00 | 2022-12-31 00:00:00
1 | 1 |  |  | 1'!A1 |  |  | Reg. Zimmer | 10 | 10 | 10 | 10 |  | 4
1 |  |  |  |  |  |  | Suite | 3 | 3 | 3 | 3 |  | 4
 |  |  |  |  | Zimmer |  | [NAME] | 4 | 4 | 4 | 4 |  | 4
 |  |  |  |  |  |  | [NAME]. Zimmer | 6 | 6
 |  |  |  |  |  |  | [NAME] | 1 | 1
1 |  |  |  |  |  |  | RPM Dom Suite | 5 | 5 | 5 | 5 |  | 4
1 |  |  |  |  |  |  | Total
1
 |  |  |  |  |  |  | Reg. Zimmer
 |  |  |  |  |  |  | Suit
 |  |  |  |  | Stunden |  | Dom Suit
 |  |  |  |  |  |  | [NAME]. Zimmer
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | RPM Dom Suite
 |  |  |  |  |  |  | Total
1 |  |  |  |  | Abwesenheit |  | Krank
1 |  |  |  |  |  |  | [NAME]
1 |  |  |  |  |  |  | Unentschuldigt
1 |  |  |  |  |  |  | Total
1
1 | 2 |  |  | 2'!A1 |  |  | Reg. Zimmer
1 |  |  |  |  |  |  | Suit
 |  |  |  |  | Zimmer |  | [NAME]
 |  |  |  |  |  |  | [NAME]. Zimmer
 |  |  |  |  |  |  | [NAME]
1 |  |  |  |  |  |  | RPM Dom Suite
1 |  |  |  |  |  |  | Total
1
 |  |  |  |  |  |  | Reg. Zimmer
 |  |  |  |  |  |  | Suit
 |  |  |  |  | Stunden |  | Dom Suit
 |  |  |  |  |  |  | [NAME]. Zimmer
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | RPM Dom Suite
 |  |  |  |  |  |  | Total
1 |  |  |  |  | Abwesenheit |  | Krank
1 |  |  |  |  |  |  | [NAME]
1 |  |  |  |  |  |  | Unentschuldigt
1 |  |  |  |  |  |  | Total
1
1
1 | 3 |  |  | 3'!A1 |  |  | Reg. Zimmer
1 |  |  |  |  |  |  | Suit
1 |  |  |  |  | Zimmer |  | [NAME]
1 |  |  |  |  |  |  | [NAME]. Zimmer
1 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | RPM Dom Suite
 |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | Reg. Zimmer
 |  |  |  |  |  |  | Suit
 |  |  |  |  | Stunden |  | Dom Suit
 |  |  |  |  |  |  | [NAME]. Zimmer
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | RPM Dom Suite
 |  |  |  |  |  |  | Total
 |  |  |  |  | Abwesenheit |  | Krank
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Unentschuldigt
 |  |  |  |  |  |  | Total
Spreadsheet: 270246d1381422454-dropdown-with-time-format-and-text-schedule-10-12-to-10-18-13-test
Sheet: Sheet3

 |  | 0
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | Dominick | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | Tiffany | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 | [NAME] | 7.25
 |  | Total
Spreadsheet: 132855d1323980878-would-like-to-automatically-fill-out-a-job-ticket-using-excel-data-paint-20example-1-
Sheet: Paint Sheet

PART NUMBER | PO # | UNIT | QTY | PART DESCRIPTION
PD10.2067P | 123456 | EA | 5 | UPPER IGUS BRACKET
POWDER COAT: |  | COMPLETED |  | COMPLETED BY                            DATE
COATED PARTS |  |  |  | _______________________               ___________
STORES: | QTY | COMPLETED |  | COMPLETED BY                            DATE
PLACED PARTS ON SHELF ___________ |  |  |  | _______________________               ___________
LOCATION __________________________ |  | JOB # FOR SMTEMP AREA ONLY ___________________________
MRP: |  | COMPLETED |  | COMPLETED BY                            DATE
RECEIVED PARTS/UPDATE MRP |  |  |  | _______________________               ___________
Spreadsheet: 57912d1258125695-removing-gaps-from-data-extraction-707162
Sheet: Sheet1

 |  |  |  |  |  |  |  | Filter your data and then press button
 |  |  |  |  |  |  |  | to transfer records to sheet2
Name | Claim | Claim_Amount | Settlement_Amount | Etc
a | 2009-11-01 00:00:00 | 1 | 2 | 1
b | 2009-11-01 00:00:00 | 2 | 3 | 2
c | 2009-11-02 00:00:00 | 3 | 2 | 3
d | 2009-11-01 00:00:00 | 4 | 1 | 2
e | 2009-11-03 00:00:00 | 5 | 2 | 3
Spreadsheet: 55603d1255703967-help-with-h-vlookup-example
Sheet: Example

 | Table 1
 |  | Member | Member | Member | Member | Member | Member | Member | Member | Member
 | Group1 | User1 |  |  |  |  | [NAME] |  | User8 | [NAME] | Y
 | Group2 |  | User2 | User3 |  | [NAME]
 | Group3 |  | User2
 | Group4 |  | User2 |  |  | [NAME] |  | User7
 | Group5 |  |  |  |  |  |  | User7 |  | [NAME]
 | Group6 |  |  |  | User4 | [NAME] |  |  |  | [NAME]
 | Group7 |  |  |  | User4
 | Group8 | User1 |  | User3 |  |  | [NAME] |  | User8
 | Group9 | User1 |  | User3 |  | [NAME] | [NAME] | User7 | User8
 | Group10 | User1 | User2 | User3 | User4 | [NAME] | [NAME] | User7 | User8
 | Table 2
 |  | Group1 | Group2 | Group3 | Group4 | Group5 | Group6 | Group7 | Group8 | Group9 | Group10
 | User1 | User1 | #N/A
 | User2 | #N/A | User2
 | User3 | #N/A | User3
 | User4 | #N/A | #N/A
 | [NAME] | #N/A | [NAME]
 | [NAME] | [NAME] | #N/A
 | User7 | #N/A | #N/A
 | User8 | User8 | #N/A
 | [NAME] | [NAME] | #N/A
Spreadsheet: 77419d1277903003-excel-2007-vlookup-multiple-conditions-vlookup-multiple-conditions-index-formula
Sheet: Sheet1

Product | Price | Month |  |  | Lookup product | Lookup price | Lookup month
Product 1 |  | January |  |  | Product 1 | 3.08516859513 | January
Product 2 |  | January |  |  | Product 2 | 237.36439302507 | January
Product 3 |  | January |  |  | Product 3 | 488.205857895 | January
Product 4 |  | January |  |  | Product 4 | 1450.37427185835 | January
Product 1 |  | February |  |  | Product 5 | 90.9585 | January
Product 2 |  | February |  |  | Product 6 | 56.07234644562001 | January
Product 3 |  | February |  |  | Product 7 | 63.075 | January
Product 4 |  | February |  |  | Product 8 | 1.71825 | January
Product 1 |  | March |  |  | Product 9 | 12.6836734413 | January
Product 2 |  | March |  |  | Product 10 | 1062.32046093873 | January
Product 3 |  | March |  |  | Product 1 | 54.21767355 | February
Product 4 |  | March |  |  | Product 2 | 73.14764790954001 | February
 |  |  |  |  | Product 3 | 291.276 | February
 |  |  |  |  | Product 4 | 316.06439010453 | February
 |  |  |  |  | Product 5 | 227.9052 | February
 |  |  |  |  | Product 6 | 90.14042265443999 | February
 |  |  |  |  | Product 7 | 479.37484239912 | February
 |  |  |  |  | Product 8 | 1926.7045984464 | February
 |  |  |  |  | Product 9 | 203.23009555434 | February
 |  |  |  |  | Product 10 | 257.684873787 | February
 |  |  |  |  | Product 1 | 617.2614063040501 | March
 |  |  |  |  | Product 2 | 5.881562355 | March
 |  |  |  |  | Product 3 | 1988.73357197715 | March
 |  |  |  |  | Product 4 | 23.8815 | March
 |  |  |  |  | Product 5 | 105.722404176 | March
 |  |  |  |  | Product 6 | 617.66181264456 | March
 |  |  |  |  | Product 7 | 1.607360931 | March
 |  |  |  |  | Product 8 | 241.59480919434 | March
 |  |  |  |  | Product 9 | 101.14703602911 | March
 |  |  |  |  | Product 10 | 46.082809455 | March
 |  |  |  |  | Product 1 | 6.70708984986 | April
 |  |  |  |  | Product 2 | 563.4083548385 | April
 |  |  |  |  | Product 3 | 36.54262246095001 | April
 |  |  |  |  | Product 4 | 2.7593403981 | April
 |  |  |  |  | Product 5 | 130.45247533725 | April
 |  |  |  |  | Product 6 | 3047.2647118596 | April
 |  |  |  |  | Product 7 | 605.2809160308 | April
 |  |  |  |  | Product 8 | 1841.732002755 | April
 |  |  |  |  | Product 9 | 203.6626535061 | April
 |  |  |  |  | Product 10 | 148.801600314 | April
 |  |  |  |  | Product 1 | 91.53630458699999 | May
 |  |  |  |  | Product 2 | 5110.33210464255 | May
 |  |  |  |  | Product 3 | 37.2732121098 | May
 |  |  |  |  | Product 4 | 4140.50754428865 | May
 |  |  |  |  | Product 5 | 64.22861198556001 | May
 |  |  |  |  | Product 6 | 3143.5619777085 | May
 |  |  |  |  | Product 7 | 1904.0981463072 | May
 |  |  |  |  | Product 8 | 7.730894819999999 | May
 |  |  |  |  | Product 9 | 26.1 | May
 |  |  |  |  | Product 10 | 984.1145865904 | May
Spreadsheet: 1f772b6c-6384-4c25-8c20-63488222f223
Sheet: Sheet1

COUNTY SUMMARY/BALLOTS CAST | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Republican |  |  | Democratic
 | Regular | Absentee | Total | Regular | Absentee | Total
Belknap County | 9082 | 393 | 9475 | 2817 | 107 | 2924
Carroll County | 8782 | 668 | 9450 | 2024 | 89 | 2113
Cheshire County | 7501 | 266 | 7767 | 5017 | 181 | 5198
Coos County | 3809 | 180 | 3989 | 2244 | 65 | 2309
Grafton County | 9880 | 427 | 10307 | 4334 | 260 | 4594
Hillsborough County | 41610 | 1517 | 43127 | 18994 | 907 | 19901
Merrimack County | 19751 | 706 | 20457 | 9092 | 276 | 9368
Rockingham County | 33902 | 1328 | 35230 | 13109 | 566 | 13675
Strafford County | 10975 | 330 | 11305 | 7082 | 191 | 7273
Sullivan County | 4688 | 157 | 4845 | 2565 | 45 | 2610
Totals | 149980 | 5972 | 155952 | 67278 | 2687 | 69965
Figures updated 9/18/02
Spreadsheet: 237499d1369233329-how-do-i-tie-a-column-to-a-pivot-table-z_examplefile
Sheet: Sheet7

Calculated Field
[NAME] | Field | [NAME]
1 | PC% | ='PC Passes'/'PC Calls'
2 | Comp | ='C Passes'/'C Calls'
3 | [NAME] | =EmailPass/EmailElig
4 | Cell | =CellPass/CellElig
5 | RecAsk | ='Rec Ask'/'Rec Elig'
6 | %$ | =(paidhours*Money)/(paidhours*ABSPaidHourGoal)
7 | rec | =Recur/Transac
8 | Avail | =TotNet/Totavail
9 | Unact | =Unacc/Totavail
10 | wrp | =Wrap/Logged
11 | ht | ='Total Time'/'IB Calls'
12 | Uncont | =Uncon/Totavail
Calculated Item
[NAME] | Item | [NAME]
Note: | When a cell is updated by more than one formula,
 | the value is set by the formula with the last solve order.
 | To change the solve order for multiple calculated items or fields,
 | on the Options tab, in the [NAME] group, click [NAME], and then click [NAME].
Spreadsheet: 69e0a931-b70a-4958-b048-109b112c0362
Sheet: Sheet1

BASE YEAR ADJUSTMENT (B-9) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | WISCONSIN DEPARTMENT OF ADMINISTRATION | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | DATE: | Unnamed: 9
DEPT  __ __ __ | ___________________________________________ |  |  |  | PE  __  __ | _______________________________________________
PROG      __ __ | ___________________________________________ |  |  |  | NA  __ __ | _______________________________________________
SP            __ __ | ___________________________________________
1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  | Revised
Expenditure Items | Adjusted Base |  |  |  |  |  |  |  | Adjusted Base
01  Perm. Pos. Sal.
02  Turnover
03  Proj. Pos. Sal.
04  LTE Salaries
05  Fringe Benefits
06  Supplies & Serv.
07  Perm. Property
08  Unallotted Res.
09  Aids
10  Local Assistance
11  One-Time Fin.
12
13
14
15
16
17  TOTAL COST
18  Proj. Pos.
19  Class. Pos.
20  Unclass. Pos.
Spreadsheet: 695554d1600275976-search-for-key-word-in-a-cell-rtn-a-different-cells-data-depending-on-which-word-matched-example-1-
Sheet: Data

Date | Ref | Ref2 | Ref3 | Location | Description | Ref4 | Cost | Treatment | [NAME] should return
2014-12-31 00:00:00 | NL |  | [NAME] | South | [NAME] 27192 | A | 46422 | (search for any key words from "Key" tab, return column B from "Key" tab)
2014-12-31 00:00:00 | NL |  | [NAME] | North | New floor 175562 | B | 12667 | (search for any key words from "Key" tab, return column B from "Key" tab)
2014-12-31 00:00:00 | NL |  | [NAME] | South | Meeting mgmt | C | 12345 | (search for any key words from "Key" tab, return column B from "Key" tab)
2014-12-31 00:00:00 | NL |  | [NAME] | South | Replace floor | D | 56789 | (search for any key words from "Key" tab, return column B from "Key" tab)
2014-12-31 00:00:00 | NL |  | [NAME] | North | Flooring upgrade | E | 1011 | (search for any key words from "Key" tab, return column B from "Key" tab)
Spreadsheet: 39435e63-02df-4c68-b7ce-5ccde3a6ccc4
Sheet: Sheet1

BUDGET ADJUSTMENT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
Brief Title |  | Approval Deadline |  |  | Reason
Transfer of Bond Funds
Details |  |  |  |  | Department, Program, or Accounts Affected
Reason for Adjustment |  |  |  |  | Sponsor
 |  |  |  |  | Parks and Public Works
 |  |  |  |  | From/Transferor(s) or Fund Title(s)
 |  |  |  |  | 3390-707227 Truman Streetscape
 |  |  |  |  | To/Transferee(s) or [NAME])
 |  |  |  |  | 3390-898042 [NAME]
 |  |  |  |  | Policy / Program Impact
 |  |  |  |  | Policy or Program | No | Yes
 |  |  |  |  | Emphasis Change
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Council Committee Actions
 |  |  |  |  | Do Pass |  | Hold
 |  |  |  |  | Do Pass (as amended) |  | w/o Recommendation
 |  |  |  |  | Committee Sub. |  | Do Not Pass
 |  |  |  |  | Fact Sheet prepared by: |  | Date
 |  |  |  |  | [NAME] |  | 2005-04-27 00:00:00
 |  |  |  |  | Fact Sheet reviewed by: |  | Date
 |  |  |  |  | Budget Office |  | 2005-04-27 00:00:00
 |  |  |  |  | Reference Numbers
Spreadsheet: 784690d1655908220-date-in-cell-in-odd-format-mon-jun-20-10-41-45-gmt-2022-excel-forum-v2
Sheet: Reopened

THIS SHEET AUTOPOPULATES WITH DATA SHOWING REOPENED DEFECTS FROM THE OCTANE REPORT - PLEASE DO NOT EDIT
Today's Date | (ENTER DATE HERE)
ID | Assigned to | Name | Phase | Priority | Severity | Opened | Days open
 | Erden | 'Duplicate invoice check - [NAME] number ZCODA filed -add "OTCD" suffix' | 'Re-opened' | Urgent | Critical | Wed May 11 15:42:02 GMT 2022
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: phillip_m_love__30529__Bkrqs836
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | Book Request #836
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | [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
FT-I-C-MID-CAD | FT-I-C-MID-CAD |  |  | X | [G | CENTRAL |  |  |  | X |  |  | NG/MMBTU/USD | [NAME] | MTM |  | 2001-07-25 00:00:00
FT-I-C-MID-CAD | FT-I-C-MID-CAD |  |  | X | [G | CENTRAL |  |  |  |  |  | X | NG/MMBTU/USD | [NAME] | MTM |  | 2001-07-25 00:00:00
(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.***
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
Access List | Administrator*
PLOVE | PHILLIP LOVE |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | JB
bmills | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | JB
jdoan | jad doan |  |  |  |  |  |  |  |  |  |  |  | Master booklist |  | Y | JB
[NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | JB
cames | [NAME] ames |  |  |  |  |  |  |  |  |  |  |  | Sent to TAGG/ERMS |  | Y | JB
bjones | brad jones |  |  |  |  |  |  |  |  |  |  |  | Active/Inactive Book List
shawkins | stephanie hawkins
ebrady | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | Any questions, please contact :
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52465)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x52526)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x57197)
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | (x31462)
Spreadsheet: 481428d1474464716-allocating-payment-across-a-series-of-invoices-payment-sample
Sheet: Remittance 

Payment to allocate | 3560
SUPPLIER STATEMENT |  |  |  | Payment to
Invoice Number | Invoice Date | Amount |  | Allocate
1001 | 2016-02-01 00:00:00 | 1000
1002 | 2016-02-15 00:00:00 | 500
1003 | 2016-03-18 00:00:00 | 2000
1004 | 2016-03-19 00:00:00 | 1500
1005 | 2016-06-04 00:00:00 | 400
1006 | 2016-06-05 00:00:00 | 3600
1007 | 2016-07-20 00:00:00 | 1200
1008 | 2016-07-29 00:00:00 | 800
1009 | 2016-08-03 00:00:00 | 900
1010 | 2016-08-16 00:00:00 | 1900
1011 | 2016-08-22 00:00:00 | 200
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 154063 | 164544 |  | -3485 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 160904 | 166793 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 157686 | 163447 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 171436 | 177056 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 164393 | 173525 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 194251 | 204098 |  | -11515 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 176742 | 186936 |  | -9247 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 180290 | 187288 |  | -8170 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 174507 | 182225 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 177777 | 182890 |  | -6970 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14
15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 | 2002-02-28 00:00:00
 | 2002-03-10 00:00:00
 | CBS Dollars
 |  |  |  | -493766
Spreadsheet: mary_fischer__25615__32L
Sheet: E21.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032L
COMPANY NAME   Jovinole Associates
LEASE EXPENSE & FUTURE LEASE COMMITMENTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
+++++INCLUDE all rentals (building, equipment, etc.) regardless of whether it is charged to "rent expense".
+++++EXCLUDE rent allocations from Corporate or other subsidiaries.
Lease Description |  |  |  | Year to Date |  |  |  |  |  | FUTURE LEASE COMMITMENT ( net of sublease , if applicable) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Residual
Property Leased, Term, Lessor |  | *(C) |  | Gross |  | Less: |  | Net Rental |  | 1 Year Ended |  |  |  |  |  |  |  |  |  | 5 Years Ended |  |  |  |  |  | Total Remaining |  | Total |  | Value
*Indicate Capital (C) or Operating (O) Lease |  | or (O) |  | Rentals |  | Subrentals |  | Expense |  | 12-31-2002 |  | 12-31-2003 |  | 12-31-2004 |  | 12-31-2005 |  | 12-31-2006 |  | 12-31-2011 |  | 12-31-2016 |  | 12-31-2021 |  | after 12-31-2021 |  | Commitment |  | Guarantee
Individually list leases w/ an annual rent expense over $1 million.
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Other Leases under $1million per year |  |  |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-21
Spreadsheet: 37740d1235754811-complicated-sumif-formula-accounts
Sheet: Sheet1

 | CURRENT NON INT BEAR |  |  |  | CURRENT INT.BEARING |  |  |  | CALL/NOTICE DEPOSITS
 | GBP | EUR | USD | Others | GBP | EUR | USD | Others | GBP | EUR | USD | Others
2007-01-01 00:00:00
2007-02-01 00:00:00
2007-03-01 00:00:00
2007-04-01 00:00:00
2007-05-01 00:00:00
2007-06-01 00:00:00
2007-07-01 00:00:00
2007-08-01 00:00:00
2007-09-01 00:00:00
2007-10-01 00:00:00
2007-11-01 00:00:00
2007-12-01 00:00:00
Spreadsheet: 542392d1507832469-classroom-problem-sums-of-rows-with-overlapping-timeslots-excel-problem
Sheet: Manual Entries

Start Time | End Time |  | School A | School B | School C | School D |  | Totals: | How Many Time Slots Overlap? | How Many Classes Overlap?
13:00:00 | 14:00:00 |  | 5 | 10 | 5 | 2
13:30:00 | 14:30:00 |  | 1 | 2 | 9 | 4
14:15:00 | 15:00:00 |  | 3 | 6 | 0 | 7
14:30:00 | 16:30:00 |  | 4 | 2 | 5 | 7
14:31:00 | 16:31:00 |  | 5 | 4 | 2 | 8
16:00:00 | 18:00:00 |  | 0 | 8 | 5 | 0
17:00:00 | 18:15:00 |  | 0 | 22 | 0 | 0
18:10:00 | 19:00:00 |  | 5 | 4 | 12 | 2
18:50:00 | 20:50:00 |  | 10 | 7 | 0 | 3