tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 57934d1258143400-checkbox-testdataentry
Sheet: Sheet1

FIBER DATA ENTRY
Warning Exit Clean Window | Warning Exit Clean Window | Low [NAME]
Does Not Spray Cryo
DCD Out of Alingment | Does Not Spray Cryo | Bad Valve |  |  | Bad Valve
[NAME] |  | Electrical |  |  | Electrical
Slider Optics |  | Cloged Nozzle |  |  | Cloged Nozzle
Burned Proximal Tip Connector |  |  |  |  | Hitting DG Ring
Burned Distance Gauge | DCD Out of Alingment | Hitting DG Ring |  |  | [NAME]
[NAME] |  | [NAME] |  |  | Distal Tip
HP Does not Stay in Calport |  |  |  |  | Proximal Tip
[NAME] | [NAME] | Distal Tip |  |  | w/in scrambler1
Slider Does not Lock in Place |  | Proximal Tip |  |  | w/in scrambler2
F1.1 |  | w/in scrambler1 |  |  | w/in scrambler3
F10.1 |  | w/in scrambler2 |  |  | w/in slider
F10.4 |  | w/in scrambler3 |  |  | w/in proximal connector
F10.5 |  | w/in slider |  |  | Middle Section (NOT in scrambler)
F15.1 |  | w/in proximal connector |  |  | 1st lens 1st surface
[NAME] |  | Middle Section (NOT in scrambler) |  |  | 1st lens 2nd surface
 |  |  |  |  | 2nd lens 1st surface
 | Slider Optics | 1st lens 1st surface |  |  | 2nd lens 2nd surface
 |  | 1st lens 2nd surface |  |  | Pitting/Debris
 |  | 2nd lens 1st surface |  |  | Window
 |  | 2nd lens 2nd surface |  |  | Missing Lens
 |  | Pitting/Debris |  |  | Fiber Tip Blown
 |  | Window |  |  | Burned Fiber @ Base/Blacked Out
 |  | Missing Lens |  |  | Improperly Seated Lens
 |  |  |  |  | [NAME]
 | Burned Proximal Tip Connector | Fiber Tip Blown |  |  | [NAME]
 |  | Burned Fiber @ Base/Blacked Out |  |  | Electronic
 |  |  |  |  | Cracked Shell
 | Burned Distance Gauge | Improperly Seated Lens |  |  | Cracked Shell
 |  | [NAME] |  |  | Burned/Melting
 |  |  |  |  | Plunger Button
 | [NAME] | [NAME] |  |  | Electrical
 |  | Electronic |  |  | DCD Leak
 |  |  |  |  | Shell Cracked
 | HP Does not Stay in Calport | Cracked Shell |  |  | Plunger button(slider doesn't lock)
 |  |  |  |  | Bad Valve
 | [NAME] | Cracked Shell |  |  | Plunger Button
 |  | Burned/Melting |  |  | Electrical
 |  |  |  |  | Low [NAME]
 | Slider Does not Lock in Place | Plunger Button
 | F1.1 | Electrical
 |  | DCD Leak
 | F10.1 | Shell Cracked
 |  | Plunger button(slider doesn't lock)
 | F10.4 | Bad Valve
 | F10.5 | Plunger Button
 |  | Electrical
 | F15.1 | Low [NAME]
Spreadsheet: 33870d1230733440-merging-rows-with-similar-information-addresses1
Sheet: Sheet1

First Name | Surname | Address 1 | Address 2
[NAME] | Bloggs | 1 | Main Street
[NAME] | Bloggs | 1 | Main Street
[NAME] | Cloggs | 2 | Main Street
[NAME] | Floggs | 3 | Main Street
[NAME] | Floggs | 3 | Main Street
[NAME] | Floggs | 3 | Main Street
[NAME] | Jones | 4 | Main Street
[NAME] | Smith | 4 | Main Street
[NAME] | [NAME] | 5 | Main Street
[NAME] | [NAME] | 5 | Main Street
[NAME] | Murphy | 5 | Main Street
Desired Output
[NAME] and [NAME] |  | 1 | Main Street
[NAME] |  | 2 | Main Street
[NAME], [NAME] and [NAME] |  | 3 | Main Street
[NAME] and [NAME] |  | 4 | Main Street
[NAME], [NAME] and [NAME] |  | 5 | Main Street
Spreadsheet: sara_shackleton__36492__Worksheet
Sheet: Sheet1

Master Swap ISDA Worksheet
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER:
COUNTERPARTY: | President and [NAME] of Harvard | CONTACT: | [NAME]
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
Incorporation State |  | S&P Rating | AAA
STRUCTURE | COUNTERPARTY | ECC
GUARANTOR (RATING) |  | Enron Corp.
LIMIT $ MILLIONS |  | 15000000 | USD
Incorporation State
COLLATERAL  THRESHOLD
 | Matrix | Matrix | USD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Treasuries | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 1000000 | 1000000 | USD
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
 | The following applies to Harvard and Enron Corp.:
 | S&P/Moody's | Threshold
 | AAA/Aaa to AA/Aa2 | 10000000
 | AA-/A1 to BBB+/Baa1 | 7000000
 | BBB/Baa2 | 5000000
 | BBB-/Baa3 | 1000000
 | Below BBB-/Baa3 | 0
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100000000 |  | USD
-Guarantor ($[NAME]) |  | 100000000
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 673203d1587248989-look-up-rows-and-distribute-across-columns-pallet-pick-marc47555-
Sheet: Orders

 |  |  | Production Date: |  |  |  | ORDERS |  |  |  |  | Del / Depot Date:
 |  |  | 2020-04-15 00:00:00
 | Prod Code |  | AVO | BEL | BRI | DON | ENF | EXE | MOT | LUT | NAY | NFL | RUN | SOU | WED |  | Total Cases
 | 0007223 |  | 4 | 4 | 12 | 4 | 0 | 4 | 16 | 12 | 12 | 12 | 12 | 12 | 4
 | 5200589 |  | 4 | 4 | 4 | 4 | 0 | 0 | 12 | 8 | 4 | 4 | 8 | 4 | 4
 | 0007225 |  | 4 | 12 | 4 | 16 | 8 | 0 | 16 | 16 | 16 | 8 | 16 | 8 | 4
 | 5216848 |  | 4 | 8 | 0 | 4 | 8 | 4 | 0 | 8 | 8 | 4 | 8 | 8 | 4
 | 5201843 |  | 52 | 56 | 40 | 64 | 48 | 48 | 56 | 32 | 20 | 25 | 44 |  | 0
 | 5205162
 | 0009694 |  | 12 | 8 | 4 | 4 | 8 | 0 | 12 | 8 | 8 | 12 | 12 | 8 | 4
 | 5216843 |  | 4 | 8 | 0 | 8 | 4 | 0 | 12 | 8 | 12 | 8 | 8 | 8 | 8
 | 5210413 |  | 4 | 4 | 8 | 4 |  | 0 | 12 | 12 | 12 | 8 | 16 | 8 | 4
 | 5216837 |  |  |  |  |  |  | 0 | 20 |  |  |  |  | 24 | 28
 | 5209761
 | 5214026
 | 5214996 |  | 0 | 0 | 0 | 8 | 4 | 0 | 12 | 8 | 0 | 8 | 8 | 8 | 4
 | 5210292 |  | 12 | 24 | 8 | 16 | 8 | 0 | 4 | 8 | 8 | 12 | 16 | 12 | 0
 | 5202529
 | 5213881 |  | 8 | 8 | 8 | 8 | 4 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
 | 5214025
 | 5209314
 | 5212974
 | 5210354
 | 5202524
 |  | Wagon Number | 1 | 1 | 1 | 2 | 1 | 1 | 1 | 2 | 2 | 1 | 2 | 1 | 2
Spreadsheet: 808755d1670612979-2-formulas-subtract-from-specific-columns-formulatest
Sheet: Pivot

 |  |  | Values |  |  |  |  |  |  |  | Subtract | Subtract
Department | Name | Target | Sum of Jun-22 | Sum of Jul-22 | Sum of Aug-22 | Sum of Sep-22 | Sum of Oct-22 | Sum of Nov-22 | Sum of Dec-22 |  | Column J - Column I | Column J - Column C
DepC | Person19 | 68 | 2192 | 2159 | 2050 | 2045 | 2112 | 1918 | 1626
 | Person21 | 9 | 2286 | 2128 | 1511 | 1647 | 2214 | 2256 | 2058
 | Person23 | 4987 | 1765 | 2142 | 2496 | 1766 | 2157 | 1879 | 1905
 | Person25 | 9848 | 2170 | 2408 | 2237 | 2344 | 1551 | 1916 | 1657
 | Person27 | 18 | 2437 | 2420 | 2186 | 1667 | 2234 | 2481 | 1685
DepC Total |  |  | 10850 | 11257 | 10480 | 9469 | 10268 | 10450 | 8931
[NAME] | [NAME] | 897 | 2407 | 1544 | 2376 | 1922 | 2249 | 2150 | 1948
 | Person22 | 598 | 2426 | 1689 | 1919 | 1891 | 1987 | 1668 | 2439
 | Person24 | 98 | 2024 | 2071 | 1636 | 1807 | 2392 | 2248 | 2185
 | Person26 | 99 | 2191 | 2225 | 2405 | 2086 | 2185 | 1622 | 1861
 | Person28 | 9 | 1804 | 2200 | 1972 | 2002 | 1613 | 1867 | 1522
[NAME] |  |  | 10852 | 9729 | 10308 | 9708 | 10426 | 9555 | 9955
DeptA | Person1 | 1750 | 6164 | 5793 | 6272 | 5654 | 5459 | 5265 | 6027
 | Person11 | 1255 | 2467 | 1581 | 1947 | 2372 | 1592 | 2204 | 2112
 | [NAME] | 654 | 1967 | 2389 | 1995 | 2119 | 1590 | 2066 | 2346
 | Person15 | 651 | 1613 | 2298 | 2152 | 1625 | 1759 | 2371 | 2138
 | Person17 | 651 | 1725 | 2411 | 1882 | 2492 | 2172 | 2162 | 1564
 | Person7 | 2485 | 2002 | 2391 | 2004 | 1824 | 1886 | 2349 | 1605
 | Person9 | 251 | 2295 | 1894 | 2051 | 2088 | 1880 | 1692 | 1636
DeptA Total |  |  | 18233 | 18757 | 18303 | 18174 | 16338 | 18109 | 17428
DeptB | Person1 | 1750 | 1629 | 1953 | 1666 | 1899 | 2255 | 1861 | 1990
 | Person10 | 25455 | 2285 | 1564 | 2197 | 2056 | 1997 | 1625 | 1535
 | Person12 | 255 | 2121 | 2002 | 2342 | 1741 | 1964 | 1685 | 2350
 | Person14 | 654 | 2021 | 1689 | 2199 | 1777 | 2258 | 1909 | 2285
 | Person16 | 651 | 1870 | 2165 | 1753 | 1923 | 1874 | 2339 | 2112
 | Person18 | 651 | 2384 | 1679 | 2291 | 1584 | 1534 | 2400 | 2466
 | Person2 | 1300 | 1591 | 2052 | 1904 | 2213 | 2113 | 2179 | 1700
 | Person6 | 1250 | 1530 | 1778 | 1721 | 1893 | 1972 | 1582 | 2018
 | Person8 | 2552 | 1852 | 2131 | 2206 | 1781 | 2365 | 2085 | 2111
DeptB Total |  |  | 17283 | 17013 | 18279 | 16867 | 18332 | 17665 | 18567
Grand Total |  |  | 57218 | 56756 | 57370 | 54218 | 55364 | 55779 | 54881 |  |  |  | Here is my issue.
Spreadsheet: 867805d1714590000-index-match-with-if-and-and-function-for-multiple-criteria-conditional-formatting-formula-for-looking-up-level-against-month
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Start | 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
 |  |  |  |  |  |  |  |  |  |  | Finish | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | 2025-01-31 00:00:00 | 2025-02-28 00:00:00 | 2025-03-31 00:00:00 | 2025-04-30 00:00:00 | 2025-05-31 00:00:00 | 2025-06-30 00:00:00 | 2025-07-31 00:00:00 | 2025-08-31 00:00:00 | 2025-09-30 00:00:00
Name | LEVEL | START | FINISH | LEVEL | START | FINISH | LEVEL | START | FINISH |  | Name | 2024 - A4 | 2024 - A5 | 2024 - A6 | 2024 - A7 | 2024 - A8 | 2024 - A9 | 2024 - A10 | 2024 - A11 | 2024 - A12 | 2025 - A1 | 2025 - A2 | 2025 - A3 | 2025 - A4 | 2025 - A5 | 2025 - A6 | 2026 - A5 | 2026 - A6 | 2027 - A5
PROG1 | L1 | 2024-05-13 00:00:00 | 2024-06-01 00:00:00 | L3 | 2025-02-27 00:00:00 | 2025-06-07 00:00:00 | L5 | 2024-04-22 00:00:00 | 2025-02-27 00:00:00 |  | PROG1
PROG2 | [NAME] | 2024-11-11 00:00:00 | 2024-12-10 00:00:00 | L5 | 2025-02-27 00:00:00 | 2025-06-07 00:00:00 | L6 | 2025-06-22 00:00:00 | 2025-09-27 00:00:00 |  | PROG2
PROG3 | L1 | 2025-04-22 00:00:00 | 2025-02-27 00:00:00 | L2 | 2025-11-11 00:00:00 | 2025-12-10 00:00:00 | L3 | 2025-02-27 00:00:00 | 2025-06-07 00:00:00 |  | PROG3
L0 | 0
L1 | 1
L2 | 2
L3 | 3
[NAME] | 4
L5 | 5
L6 | 6
L7 | 7
Spreadsheet: louise_kitchen__22711__North America Plan 01-09 inc AA adj (2)
Sheet: Crude AA

 | Crude Analysts & Associates
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | % | 2002
 |  | YTD Actual |  | Forecast |  | of Total | Plan
ENACOMP | Compensation |  |  |  |  |  | 0 | Compensation | 0
 | Special Pays |  |  | 0 |  |  | 0
 | Analyst & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other |  |  |  |  | Crude | Hicks, [NAME] | DIRECTOR | US-GP LPG TRADING
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  |  |  |  |  | Crude | [NAME], [NAME] | MANAGER | US-GP LPG TRADING
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | Crude | South, Chad E | ASSOCIATE | US-GP PETROCHEMICALS TRADING
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | Intern | 33000
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 48400 | 0
ENARENT | Rent |  |  |  |  |  |  | Staff | 49500 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 57750 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 71500 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 60500 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  | 0 | Associate | 89100 | 1
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager | 110000 | 0
 |  |  |  |  |  |  |  | Director | 143000 | 0
 | Headcount |  |  |  |  |  |  | Sr. Director | 165000 | 0
 |  |  |  |  |  |  |  | VP | 198000 | 0
 | A&A Headcount |  |  |  |  |  |  | MD | 220000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  | 0.2
 |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 254512
 |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 687836d1595433002-extract-values-based-on-criteria-but-only-those-that-dont-appear-in-another-list-sample
Sheet: Sheet2

[NAME] | ENTRY
[NAME] | EXIT
[NAME] | ENTRY
Teo Tyson | EXIT
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | EXIT
[NAME] | EXIT
[NAME] | EXIT
[NAME] | EXIT
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | ENTRY
Lillie-Rose Cortez | ENTRY
Usaamah Collier | ENTRY
[NAME] | EXIT
[NAME] | ENTRY
Charlize Walls | EXIT
Kai Mcclure | EXIT
Amelia-Rose Parry | ENTRY
[NAME] | EXIT
[NAME] | ENTRY
[NAME] | EXIT
[NAME] | EXIT
[NAME] | ENTRY
Ebony Holland | ENTRY
[NAME] | ENTRY
[NAME] | EXIT
Issa Mccabe | EXIT
Caprice [NAME] | ENTRY
[NAME] | EXIT
[NAME] | EXIT
[NAME] | EXIT
[NAME] | ENTRY
Iestyn Daniels | ENTRY
[NAME] | ENTRY
[NAME] | ENTRY
Haya Espinoza | EXIT
[NAME] | EXIT
[NAME] | ENTRY
Paloma [NAME] | EXIT
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | ENTRY
[NAME] | EXIT
Kodi Quintana | EXIT
[NAME] | ENTRY
[NAME] | EXIT
Spreadsheet: 136929d1326893244-integrating-a-shift-schedule-and-time-sheets-if-i-had-hair-i-would-pull-it-out-sched-time-sheet-integration
Sheet: Site 2

Employee Number | Name |  |  |  |  |  |  |  | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Su | Mo | [NAME] | We | Th | Fr | Sa | Reg Hours | OT Hours | Unworked Stat Hours | Total Weekly Hours | Total Bi-Weekly Hours
Spreadsheet: 209509d1359125797-lookup-employee-number-and-see-duplicates-as-well-find-employee-with-duplicates
Sheet: Sheet1

Employee Number | Last | First | Division | [NAME] |  |  | [NAME] |  | 1
1 | Jones | [NAME] | A
2 | [NAME] | [NAME] | B |  |  |  |  |  | Last | First | Division | [NAME]
3 | Cho | [NAME] | C |  |  |  |  |  | Jones | [NAME] | A
4 | Chau | Bin | A |  |  |  |  |  | Jones | [NAME] | A
5 | Do | Greg | B |  |  |  |  |  | Jones | [NAME] | B | On Loan
1 | Jones | [NAME] | A
6 | Mund | [NAME] | C
7 | Stern | [NAME] | A
1 | Jones | [NAME] | B | On Loan
8 | Hein | [NAME] | C
9 | Caplan | [NAME] | A
10 | Fox | [NAME] | B
11 | Dell'abate | [NAME] | C
2 | [NAME] | MIke | A | On Loan
12 | [NAME] | Lupe | A
13 | [NAME] | [NAME] | B
2 | [NAME] | Mke | B
14 | Spider | [NAME] | C
15 | Man | Juan | A
16 | Keyes | [NAME] | B
3 | Cho | [NAME] | A | On Loan
17 | Fire | [NAME] | C
18 | Yomama | [NAME] | A
Spreadsheet: 828358d1683441181-finding-data-with-more-than-one-criteria-finding-data-inside-a-range-of-date
Sheet: Sheet1

NAME | EMP NUMBER | DATE FROM | DATE TO | [NAME]
[NAME] | 123456 | 2023-02-01 00:00:00 | 2023-02-28 00:00:00
[NAME] | 123457 | 2023-02-01 00:00:00 | 2023-02-28 00:00:00 | 0
[NAME] | 123456 | 2023-03-01 00:00:00 | 2023-03-31 00:00:00 | 10000
DATE FROM | DATE TO | EMP NUMBER | [NAME]
2023-01-20 00:00:00 | 2023-03-15 00:00:00 | 123456 | 10000
2023-03-16 00:00:00 | 2023-04-02 00:00:00 | 123456 | 15000
2023-04-03 00:00:00 | 2023-04-30 00:00:00 | 123456 | 20000
Spreadsheet: 82852d1282844424-random-pairs-golfmixedpairsteamselectoin
Sheet: Game Selector (2)

 | Generate selection
ID | Player |  |  | Team | Player 1 | Player 2
1 | [NAME]
2 | [NAME]
3 | [NAME]
4 | Kelly
5 | George
6 | Paige |  |  |  |  |  |  | Click in the yellow area to select teams
7 | [NAME]
8 | Nate |  |  |  |  |  |  | Put as many IDs and Names in Columns A & B as you need
9 | Betty
10 | Mathew |  |  |  |  |  |  | N.B. | Always end ID with an even number.
11 | Wilma |  |  |  |  |  |  |  | That will decide who gets a bye if needed.
12 | Mark
13 | [NAME]
14 | Anne
15 | Rory
16 | Kristen
17
18 | Britt
Spreadsheet: geir_solberg__11244__04-12
Sheet: Sheet2

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | SELL PRICE
2001-04-11 00:00:00 | 1 | 3 |  | SP15 | EES | 4 |  | 90 | Sold
2001-04-11 00:00:00 | 7 | 7 |  | SP15 | EES | 21 |  | 150 | Sold
2001-04-11 00:00:00 | 16 | 16 |  | SP15 | EES | 6 |  | 140 | Sold
2001-04-11 00:00:00 | 17 | 17 |  | SP15 | EES | 6 |  | 140 | Sold
2001-04-11 00:00:00 | 18 | 18 |  | SP15 | EES | 6 |  | 140 | Sold
Spreadsheet: 678095d1589714148-single-list-from-multiple-sheets-elenco
Sheet: RIEPILOO

 |  | Codice |  | SE.ERRORE(INDICE(INDIRETTO("'"&$N$4:$N$5&"'!D3:D100");AGGREGA(15;6;(RIF.RIGA($A$3:$A$99)-2)/(INDIRETTO("'"&$N$4:$N$5&"'!C3:C100")<>"");RIGHE($A$1:A1)));"")
 |  |  | [PHONE] |  |  |  |  |  |  |  |  |  | TRAVERSA
 |  |  | [PHONE] |  |  |  |  |  |  |  |  |  | PASSERELLE
 |  |  | [PHONE] |  |  |  |  |  |  |  |  |  | SCALE
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | [PHONE]
 |  |  | https://www.forumexcel.it/forum/threads/lista-riepilogativa.36218/
Spreadsheet: 882442d1730827652-loan-calculator-with-irregular-payments-loan-with-irregular-payments-schedule
Sheet: Sheet1 (2)

 |  | Note:  Column E should show the declining principle amount but how do I do that based on irregular payment dates?
 |  | Loan amount | 30000
 |  | Annual Interest Rate | 0.1215
 |  | Term of loan in years | 1.5
 |  | Payment date | Payments Made | Remaining Amount
 | 1 | 2023-10-20 00:00:00 | 1831.55
 | 2 | 2023-11-21 00:00:00 | 1831.55
 | 3 | 2023-12-25 00:00:00 | 1831.55
 | 4 | 2024-01-22 00:00:00 | 2124.7
 | 5 | 2024-02-22 00:00:00 | 1538.4
 | 6 | 2024-07-10 00:00:00 | 3663.1
 | 7 | 2024-07-11 00:00:00 | 3663.1
 | 8 | 2024-09-20 00:00:00 | 5494.65
 | 9 | 2024-11-05 00:00:00 | 1831.55
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
Spreadsheet: richard_shapiro__32176__rcr-budget-status-report
Sheet: Sheet1

Cost Center Owner | RCR Budget | [NAME] to Date | RCR Available to Date
Steffes | 1801200
Nord | 750000
[NAME] | 1140000
Kaufman | 398000
Ryall | 162350 | 26150
Migden | 471000 | 110000
[NAME] | 590000 | 25000
Montovano | 575000 | 187108.25
Dadson | 352000 | 134000
Charvel | 110000 | 0
Yoho | 265000 | 0
TOTAL
Spreadsheet: 113285d1309244489-excel-2007-pivot-tables-data
Sheet: Pendiente por ejercicios

 | State | ([NAME])
 |  | financial year
 |  | 2005 |  | 2006 |  | 2007 |  | 2008 |  | 2009 |  | 2010 |  | 2011
 | Location | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount | Nº outstanding bills | Outstanding amount
 | FUERTEVENTURA | 553143 | 27254729.77 | 541884 | 27575322.98000004 | 518018 | 27374352.55 | 541388 | 29460386.73999998 | 565347 | 31363530.91999999 | 600565 | 33821442.90999998 | 151963 | 8703450.27
 | GRAN CANARIA | 8168491 | 289008666.8699998 | 8397349 | 314060511.0000008 | 8794254 | 342972917.1600013 | 8986971 | 359697513.0000005 | 9459016 | 389489162.8899993 | 9883217 | 420266280.4200006 | 2486024 | 108096605.3000001
 | HIERRO | 16477 | 834637.8300000001 | 17215 | 909599.7500000001 | 16077 | 970714.2799999997 | 18275 | 1059646.48 | 20274 | 1204222.63 | 22022 | 1361516.739999999 | 5394 | 336418.8799999999
 | LA GOMERA | 73982 | 3765873.210000002 | 75722 | 4056890.88 | 78940 | 4345393.549999999 | 83538 | 4717741.86 | 81706 | 4867237.49 | 80899 | 5106371.369999997 | 20489 | 1320563.77
 | LA PALMA | 476443 | 25383444.99000001 | 514279 | 28902096.13 | 538162 | 31456556.66000001 | 576967 | 34495255.85999998 | 613443 | 37752461.60000002 | 635905 | 41006357.82999995 | 163041 | 10849869.78
 | LANZAROTE | 761351 | 32541151.17 | 780211 | 33892411.59000001 | 821554 | 36179540.91000002 | 824309 | 36892018.73999999 | 844295 | 38453574.47000001 | 879947 | 41213907.53000001 | 224413 | 10645411.14
 | TENERIFE | 4887149 | 222232238.7499999 | 5131661 | 243787597.6399999 | 5384229 | 266948206.8099993 | 5689886 | 291008620.4799989 | 5855875 | 312371430.4299994 | 5990716 | 333079183.519998 | 1530554 | 86801904.35999991
 | Totals | 14937036 | 601020742.5899997 | 15458321 | 653184429.9700007 | 16151234 | 710247681.9200008 | 16721334 | 757331183.1599994 | 17439956 | 815501620.4299988 | 18093271 | 875855060.3199985 | 4581878 | 226754223.5
Spreadsheet: darrell_schoolcraft__7291__saledocTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Sempra Energy
Deal Date: |  |  | 2001-09-25 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 10/01/01-10/31/01 |  |  | FAX Number:
Total Quantity |  |  | 155000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | El Paso Perm Gas Daily
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
10/01/01 | 10/31/01 | 155000 |  | 5000 |  | 5000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
Panhandle Pool |  |  | 58647 |  | 5000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
Theresa Branney [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 769154d1645354148-need-help-for-conditional-change-cash-forcast-summary
Sheet: DATA

Column1 | Column2 | Column3 | Column4 | Column5 | PLAN NAME | Column6 | Column7 | Column8 | Column9 | USAGE CHARGE | Column10 | AREA
 |  |  |  |  | NETFLIX/MONTH |  |  |  |  | 1000 |  | RIVERSIDE
 |  |  |  |  | GOOGLE SERVER/MONTH |  |  |  |  | 2000 |  | RIVERSIDE
 |  |  |  |  | DATA/3MONTH |  |  |  |  | 5000 |  | ROADSIDE
 |  |  |  |  | YAHOOSERVER/3MONTH |  |  |  |  | 10000 |  | JUNGLESIDE
 |  |  |  |  | LOCALSERVER/1 MONTH |  |  |  |  | 2000 |  | JUNGLESIDE
 |  |  |  |  | LOCALSERVER/1 MONTH |  |  |  |  | 2000 |  | ROADSIDE
 |  |  |  |  | YAHOOSERVER/3MONTH |  |  |  |  | 10000 |  | JUNGLESIDE
Spreadsheet: 16443759-30c5-47a1-bb31-1187b1bfbdec
Sheet: Sheet1

GIM South America Itinerary
 | Su, 17th | M, 18th | T, 19th | W, 20th | R, 21st | F, 22nd | Sa, 23rd
City | Chicago | São Paolo | São Paolo | São Paolo | São Paolo | São Paolo/Rio de Janeiro | Rio de Janeiro
Flights | D: ORD, 21:25 | A: GRU, 9:40
 | Su, 24th | M, 25th | T, 26th | W, 27th | R, 28th | F, 29th | Sa, 30th
City | Rio de Janeiro | Rio de Janeiro | Rio de Janeiro/Bogotá | [NAME] | [NAME] | [NAME] | Bogotá/Chicago
Flights |  |  | D: GIG, 8:40;  A: BOG, 13:10 |  |  |  | D: BOG, 7:50; A: ORD, 15:30