tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72486d1273168056-link-from-tab-to-tab-tab-to-tab-link
Sheet: Summary

Eq # | Description | Year | Make | Model | VIN | UNIT MAKE | UNIT MODEL | UNIT SN | LOW | HIGH | NBV 3/31/10 | Prof/Loss at Low | Prof/Loss at High
2109 | TRUCK PULLER TENSIONER | 1988 | INTERNATIONAL | 1954 | 1HTLDZZN5JH584972 | TSE | 2501 |  | 2500 | 3500 | 5345.06 | -2845.06 | -1845.06
2122 | TRAILER  TENSIONER DIST | 1986 | SHERMAN REILLY | UNKNOWN | 123WM1513F1T16020 |  |  |  | 1500 | 2000 | 1821.81 | -321.81 | 178.19
2129 | PULLER TENSIONER DIST 3400# | 1987 | SHERMAN REILLY | PT-2766-BV-T | 123WM1315H1T06577 |  |  |  | 2000 | 3000 | 4053.4 | -2053.4 | -1053.4
2134 | TRAILER  TENSIONER DIST | 1964 | PENGO | UNKNOWN | NCX335259 |  |  |  | 400 | 700 | 300.75 | 99.25 | 399.25
2139 | PULLER TENSIONER DIST 3400# | 1987 | SHERMAN REILLY | PT-2766-BV-T | 123WM1317H1T06578 |  |  |  | 2000 | 3000 | 5211.16 | -3211.16 | -2211.16
2168 | TRAILER  TENSIONER DIST | 1966 | PENGO | UNKNOWN | SCHD50825 |  |  |  | 2500 | 2000 | 238.41 | 2261.59 | 1761.59
2210 | SHERMAN & REILLY WIRE PULLER | 1990 | SHERMAN & REILL | P-5048 | 123WM1715L1T18005 |  |  |  | 5000 | 6000 | 11857.7 | -6857.7 | -5857.7
2212 | SHERMAN & REILLY DRUM PULLER | 1990 | SHERMAN & REILL | PLW-100-4 | 123WM1621L1T05021 |  |  |  | 2500 | 3500 | 6905.2 | -4405.2 | -3405.2
2277 | TRAILER  1 DRUM PULLER 6000# | 1986 | LA WOODS | SD6000 | 6189433697LAW11031D |  |  |  | 2000 | 3000 | 8712.31 | -6712.31 | -5712.31
2278 | TRAILER  1 DRUM PULLER 4000# | 1990 | SHERMAN REILLY | P-4072-T | 123WM1715H1T10011 |  |  |  | 2000 | 3000 | 12907.63 | -10907.63 | -9907.63
2280 | TRAILER  TENSIONER DIST 3000# | 1990 | LA WOODS | TR-BWT-3-31RC | 6002 |  |  |  | 4000 | 6000 | 2800 | 1200 | 3200
2349 | TRL WIRE 3 REEL 96"DIA X 60" | 1994 | HOOPER | 6T MODIFIED | 1H9FB242P10470354 |  |  |  | 800 | 1200 | 778.99 | 21.01 | 421.01
Spreadsheet: 744705d1629386253-how-to-tally-points-based-on-persons-name-sumifs
Sheet: Sheet1

Column1 | Player | Points | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13
 | [NAME] | 1
 | [NAME] | 2
 | [NAME] | 3
 | [NAME] | 4
 | [NAME] | 5
 | Elgin Baylor | 6
 | [NAME] | 7
 | [NAME] | 8
 | Manute Bol | 9
 | [NAME] | 10
 | [NAME] | 11
 | [NAME] | 12
 | Wilt Chamberlain | 13
 | [NAME] | 14
 | [NAME] | 15
 | [NAME] | 16
 | [NAME] | 17
 | [NAME] | 18
 | Wilt Chamberlain | 19
 | [NAME] | 20
 | [NAME] | 21
 | [NAME] | 22
 | [NAME] | 23
 | [NAME] | 24
 | Wilt Chamberlain | 25
 |  |  | Player | Total Points
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Elgin Baylor
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Manute Bol
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | Wilt Chamberlain
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
Spreadsheet: 714491d1611244670-can-not-use-array-formulas-need-to-pull-a-list-and-cross-check-on-multiple-criteria-example
Sheet: Main Street

Activity | Sub-object
1000 | 195
FY 2020 |  |  |  | Cross Check
Date | Vendor | Invoice | Amt | Posted Amount
2019-10-10 00:00:00 | Smith Farm | 4 | 800 |  | Manually entered
2019-10-10 00:00:00 | Tractor Supply Co | 4 | 800
2019-10-10 00:00:00 | Tractor Supply Co | 5 | 600
2019-10-10 00:00:00 | Tractor Supply Co | 10 | 700
2019-10-10 00:00:00 | Tractor Supply Co | 12 | 800
2019-10-10 00:00:00 | Tractor Supply Co | 13 | 50
 |  |  |  |  | Continue to pull data so it is not manually entered
Spreadsheet: 327173d1403482107-functions-use-for-various-conditioning-book1-3
Sheet: Sheet3

 |  |  |  |  |  |  |  |  |  |  |  | Peak Season
Fruits | Occurrence | Time taken to sell (by hour) | Date Sold | Good sales (Yes/No) | Normal Sales (Yes/No) | Count number of good sales | Count number of normal sales | % of good sales | % of normal sales |  |  | Public Holidays | 2/3 days prior
Apple |  | 2 | 2014-01-01 00:00:00 |  |  |  |  |  |  |  |  | 2014-01-01 00:00:00
Apple |  | 1 | 2014-01-07 00:00:00 |  |  |  |  |  |  |  |  | 2014-01-18 00:00:00
Apple |  | 0.5 | 2014-01-14 00:00:00 |  |  |  |  |  |  |  |  | 2014-05-01 00:00:00
[NAME] |  | 2.5 | 2014-01-21 00:00:00 |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00
[NAME] |  | 2 | 2014-01-28 00:00:00 |  |  |  |  |  |  |  |  | 2015-01-18 00:00:00
Blueberry |  | 1 | 2014-02-04 00:00:00 |  |  |  |  |  |  |  |  | 2015-05-01 00:00:00
Durian |  | 29 | 2014-02-12 00:00:00 |  |  |  |  |  |  |  |  | 2014-05-31 00:00:00
Durian |  | 5 | 2014-02-18 00:00:00 |  |  |  |  |  |  |  |  | 2015-05-31 00:00:00
Grapefruit |  | 6 | 2014-05-01 00:00:00
Kiwi |  | 3 | 2014-02-28 00:00:00
Kiwi |  | 28 | 2014-03-03 00:00:00 |  |  |  |  |  |  | Definition of Good Sales:
Mango |  | 2 | 2014-03-07 00:00:00 |  |  |  |  |  |  | 1) Sell within 4 hours or less
Mango |  | 5 | 2014-03-15 00:00:00 |  |  |  |  |  |  | 2) < 2 same type of fruits sold off
Mango |  | 25 | 2014-03-22 00:00:00 |  |  |  |  |  |  | 3) Sold of during peak season
Mango |  | 4 | 2014-03-27 00:00:00 |  |  |  |  |  |  | (Peak season: 2 calendar days before or on public holiday, or 3 days before 31st May)
Mangosteen |  | 30 | 2014-04-04 00:00:00 |  |  |  |  |  |  | Public holiday date for example: 1 Jan 14, 18 Apr 14, 1 May 14
Orange |  | 4 | 2014-04-16 00:00:00
Orange |  | 1 | 2014-04-20 00:00:00 |  |  |  |  |  |  | Definition of Normal Sales:
Papaya |  | 8 | 2014-04-26 00:00:00 |  |  |  |  |  |  | 1) Sold off the next day
Papaya |  | 13 | 2014-05-01 00:00:00 |  |  |  |  |  |  | 2) >2 same type of fruits sold off
Papaya |  | 25 | 2014-05-08 00:00:00 |  |  |  |  |  |  | 3) Sold off during non-peak season
Starfruit |  | 3.5 | 2014-05-13 00:00:00
[NAME] |  | 3 | 2014-05-20 00:00:00
Watermelon |  | 2 | 2014-05-24 00:00:00
Watermelon |  | 2 | 2014-05-27 00:00:00
Wintermelon |  | 0.5 | 2014-05-31 00:00:00
Spreadsheet: 77561d1278003936-vlookup-example
Sheet: Sheet2

 | 1 | 2 | 3 | 4
A | Data | Data | Data | Data
B | Data | Data | Data | Data
C | Data | Data | Data | Data
D | Data | Data | Data | Data
Spreadsheet: chris_germany__1831__DecCohCHOICE-ENA
Sheet: Dec 5

 | COH CHOICE NOMINATIONS TO ACTUALS
 | FOR GAS DAY |  |  |  |  |  |  |  | 2000-12-05 00:00:00
 |  | MA | NOM ID |  | FT |  | AT |  | FORECASTED |  | ACTUALS |  | CONTRACT # | % Storage | Over | Sto | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FT DROP |  | AT DROP
 | COH 3-15 | 22-15 | 3342 |  |  |  |  |  | 1644 |  | 1558 |  | 67694 |  |  |  |  |  | 30 | 1 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | 2 | 21
 | COH 5-2 | 23N-02 | 3343 |  |  |  |  |  | 6754 |  | 7076 |  | 67694 |  |  |  |  |  | 31 | 3 | 19
 |  |  |  |  |  |  |  |  | 5000 |  | 5000 |  | 68918 | 0 |  |  |  |  | 29 | 4 | 19
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | 5 | 22
 | COH 5-7 | 23N-07 | 3344 |  |  |  |  |  | 2648 |  | 2776 |  | 67694 |  |  |  |  |  | 32 | 6 | 20
 |  |  |  |  |  |  |  |  | 1535 |  | 1535 |  | 68915 | 0 |  |  |  |  | 31 | 7 | 20
 |  |  |  |  |  |  |  |  | 1540 |  | 1540 |  | 69693 | 0 |  |  |  |  | 32 | 8 | 23
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 9 | 22
 | COH 7-1 | 23-01 | 3788 |  |  |  |  |  | 19644 |  | 18991 |  | 67694 |  |  |  |  |  | 32 | 15 | 28
 |  |  |  |  |  |  |  |  | 673 |  | 673 |  | 69149 | 0 |  |  |  |  | 30 | 35 | 22
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68915 | 0 |  |  |  |  | 29 | 39 | 19
 |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 68918 | 0
 | COH 7-3 | 23-03 | 3789 |  |  |  |  |  | 2352 |  | 2252 |  | 67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 | COH 7-4 | 23-04 | 3345 |  |  |  |  |  | 1683 |  | 1761 |  | 67694 | 1 |  |  |  |  | Storage
 |  |  |  |  |  |  |  |  | 1915 |  | 1915 |  | 68916 | 0 |  |  |  |  | #67694
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | COH 7-5 | 23-05 | 2777 |  |  |  |  |  | 17266 |  | 17266 |  | 67694
 | COH 7-6 | 23-06 | 3346 |  |  |  |  |  | 2765 |  | 2765 |  | 67694
 | COH 7-8 | 23-08 | 3790 |  |  |  |  |  | 4839 |  | 4839 |  | 67694
 | COH 7-9 | 23-09 | 3791 |  |  |  |  |  | 6334 |  | 6190 |  | 67694 | 1
 | COH 8-35 | 24-35 | 3348 |  |  |  |  |  | 1211 |  | 1289 |  | 67694 | 1
 |  |  |  |  |  |  |  |  | 1000 |  | 1000 |  | 69823 | 0
 | COH 8-39 | 24-39 | 3792 |  |  |  |  |  | 52 |  | 53 |  | 67694 | 1
 |  |  |  |  |  |  |  | x | 1.Nom to COH |  | 1. Email to COH |  |  |  |  |  |  | FOM
 |  |  |  |  |  |  |  | x | 2.Email to ENA |  | 2. Email to ENA |  |  |  |  |  |  | Buy/(Sell) NPC (from/to) ENA
Spreadsheet: 850864d1701183070-shading-weekend-cloumns-meeting-rooms-aligw
Sheet: August 2024

 | 2024-08-01 00:00:00 | 2024-08-02 00:00:00 | 2024-08-03 00:00:00 | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
 | 2024-08-01 00:00:00 | 2024-08-02 00:00:00 | 2024-08-03 00:00:00 | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
BIG BOARDROOM: 0800-0900
BIG BOARDROOM: 0900-1000
BIG BOARDROOM: 1000-1100
BIG BOARDROOM: 1100-1200
BIG BOARDROOM: 1200-1300
BIG BOARDROOM: 1300-1400
BIG BOARDROOM: 1400-1500
BIG BOARDROOM: 1500-1600
BIG BOARDROOM: 1600-1700
SMALL BOARDROOM: 0800-0900
SMALL BOARDROOM: 0900-1000
SMALL BOARDROOM: 1000-1100
SMALL BOARDROOM: 1100-1200
SMALL BOARDROOM: 1200-1300
SMALL BOARDROOM: 1300-1400
SMALL BOARDROOM: 1400-1500
SMALL BOARDROOM: 1500-1600
SMALL BOARDROOM: 1600-1700
Spreadsheet: 695536d1600268960-dynamic-table-creation-template_111
Sheet: Waiting

 | Package Unique number |  | Written here
 | A33 |  | 2020-07-23 00:00:00
 | A34 |  | 2019-01-01 00:00:00
 | [NAME] |  | 2020-09-01 00:00:00
 | A36 |  | 2020-05-02 00:00:00
 | A37 |  | 2021-05-15 00:00:00
 | A38 |  | 2020-12-04 00:00:00
 | A39 |  | 2027-12-09 00:00:00
 | A40 |  | 2021-10-09 00:00:00
 | A41 |  | 2022-10-08 00:00:00
Spreadsheet: 715269d1611648856-calculate-of-sales-volume-specific-products-in-grouped-order-value-sample
Sheet: Sheet1

Order Number | Item value | X Product | Does order contain > 60% of X
B | 26472.92 | Not x product
B | 37736.05 | X Product
B | 8117.72 | Not x product
B | 20022.09 | Not x product
B | 26734.18 | Not x product
B | 5372.26 | Not x product
B | 3069.95 | X Product
B | 3068.02 | X Product
A | -4260.55 | Not x product
A | 4260.55 | Not x product
A | -4111.06 | Not x product
A | 4111.05 | Not x product
A | -8332.02 | X Product
A | 8332.01 | X Product
A | -7094.02 | Not x product
A | 7094.02 | Not x product
C | 10000 | X Product
C | 50000 | X Product
C | 200 | Not x product
Spreadsheet: 67602d1268177220-excel-2007-function-to-calculate-new-wage-lw-wages
Sheet: Wages-Tables

Full-Time Employees | Column1 | Column2 | Column3 | Column4 | Column5
Years of Service | % Increase |  | Hourly Wage | Bonus Amount
0 | 0 |  | 0 | 0
1 | 0.01 |  | 8.4 | 250
2 | 0.015 |  | 9.75 | 300
4 | 0.02 |  | 10.75 | 350
6 | 0.03
7 | 0.03
9 | 0.04
10 | 0.045
Part-Time Employees | Column1 | Column2 | Column3 | Column4 | Column5
Years of Service | % Increase |  | Hourly Wage | Bonus Amount
0 | 0 |  | 0 | 0
1 | 0.0075 |  | 8.4 | 100
2 | 0.01 |  | 9.75 | 150
4 | 0.015 |  | 10.75 | 200
6 | 0.02
8 | 0.025
9 | 0.03
10 | 0.035
Spreadsheet: 77718d1278150883-collate-and-index-info-example2-adeassessor2
Sheet: Main

Entry | Unit 1 Criteria 1 | Unit 1 Criteria 2 | Unit 1 Criteria 3 | Unit 1 Criteria 4 | Unit 1 Criteria 5 | Unit 1 Criteria TRIM | Unit 2 Criteria 1 | Unit 2 Criteria 2 | Unit 2 Criteria 3 | Unit 2 Criteria 4 | Unit 2 Criteria 5 | Unit 2 Criteria TRIM
Entry 1 | 1 |  | 3 |  | 5 |  |  | 2 | 3 | 4
Entry 2 |  |  |  |  |  |  | 1 | 2
Entry 3 |  |  |  | 4 | 5 |  |  |  |  |  | 5
Spreadsheet: 773893d1648108799-scroll-bar-min-or-max-dependent-of-funcion-if-scroll-bar-min-and-max-dependent-on-function-if
Sheet: Arkusz1

 |  |  |  |  |  | MIN AND MAX OF SCROLL BAR
 |  |  |  |  |  | MIN |  | MAX
 |  |  |  |  |  | 0
 |  |  |  | 10 |  |  |  |  | 10 | VALUE
 | LOCATION OF THE VILLAGE |  |  |  |  | POSSIBILITY OF GROWING FOOD
 | 0 |  |  |  |  | 0
 | 1 |  |  |  |  | 1
 | 2 |  |  |  |  | 2
 | 3 |  |  |  |  | 3
 | 4 |  |  |  |  | 4
 | 5 |  |  |  |  | 5
 | 6 |  |  |  |  | 6
 | 7 |  |  |  |  | 7
 | 8 |  |  |  |  | 8
 | 9 |  |  |  |  | 9
 | 10 |  |  |  |  | 10
Spreadsheet: d8ad91c1-dd18-4342-95f8-f784baf1fc4c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Manufacturing and Trade Inventories and Sales
 |  | Total Business: U.S. Total
 |  | Not Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: May 24, 2013 (10:39 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 478951 | 496844 | 542833 | 533768 | 537400 | 565571 | 526185 | 539853 | 560404 | 566565 | 545760 | 588251
1993 | 501102 | 519670 | 577660 | 562473 | 568082 | 592053 | 541464 | 571965 | 587292 | 587643 | 582479 | 614452
1994 | 523199 | 548442 | 622218 | 589743 | 606190 | 634298 | 570382 | 637290 | 638550 | 637472 | 636597 | 673861
1995 | 583576 | 602657 | 671889 | 629789 | 665344 | 688373 | 610456 | 678050 | 677370 | 678823 | 671241 | 698702
1996 | 608890 | 640408 | 687749 | 676459 | 705128 | 701473 | 661060 | 704489 | 703818 | 724199 | 700035 | 729369
1997 | 648926 | 670542 | 733003 | 714436 | 728181 | 746888 | 699833 | 728842 | 755266 | 760523 | 718354 | 776515
1998 | 665199 | 691649 | 766470 | 739466 | 743025 | 776742 | 710372 | 738979 | 765522 | 769652 | 740557 | 801061
1999 | 674466 | 713828 | 808436 | 767844 | 782025 | 823830 | 752260 | 807053 | 819724 | 808320 | 808879 | 867469
2000 | 736418 | 788463 | 877235 | 805781 | 857443 | 885803 | 785590 | 859519 | 857579 | 850389 | 832885 | 869308
2001 | 770110 | 774654 | 861033 | 802270 | 859277 | 847646 | 778234 | 849939 | 794709 | 840886 | 806618 | 832542
2002 | 744711 | 745321 | 829075 | 820170 | 854248 | 837920 | 809151 | 860714 | 829838 | 859538 | 823211 | 864906
2003 | 782471 | 774731 | 868509 | 836005 | 860247 | 870319 | 843175 | 867699 | 877776 | 900003 | 841268 | 927979
2004 | 806150 | 828380 | 959786 | 911274 | 920925 | 955593 | 899006 | 950246 | 949020 | 950680 | 947147 | 1020734
2005 | 875798 | 891693 | 1029518 | 983002 | 1006883 | 1044724 | 967413 | 1058374 | 1041734 | 1035275 | 1022223 | 1088983
2006 | 963217 | 957622 | 1112133 | 1028670 | 1115829 | 1127666 | 1036006 | 1135668 | 1066130 | 1076915 | 1057795 | 1116195
2007 | 1001054 | 989337 | 1143809 | 1093379 | 1176712 | 1164348 | 1101350 | 1185441 | 1115028 | 1184072 | 1158772 | 1179697
2008 | 1097451 | 1097181 | 1184809 | 1194579 | 1242290 | 1255415 | 1222940 | 1210968 | 1168124 | 1140141 | 989332 | 1043046
2009 | 896302 | 881035 | 973875 | 950173 | 964523 | 1012461 | 980535 | 1001727 | 997996 | 1017653 | 989920 | 1080143
2010 | 940113 | 937191 | 1107190 | 1077000 | 1073586 | 1106551 | 1062074 | 1104156 | 1094739 | 1099871 | 1103224 | 1184811
2011 | 1050136 | 1046997 | 1247467 | 1186307 | 1215491 | 1243648 | 1167390 | 1258679 | 1219014 | 1213057 | 1204623 | 1270026
2012 | 1138666 | 1173635 | 1306460 | 1242543 | 1303928 | 1260660 | 1210662 | 1298921 | 1230148 | 1289594 | 1258025 | 1290310
Spreadsheet: 680619d1591113100-loan-payment-holiday-examples-test
Sheet: Loan Calculator

 | Simple Loan Calculator |  |  | https://www.halifax.co.uk/mortgages/existing-customers/payment-holidays/#otheroptions[/url].
 | Enter values
 | Loan amount |  |  | 50000
 | Annual interest rate |  |  | 0.075
 | Loan period in years |  |  | 1
 | Start date of loan |  |  | 2020-01-01 00:00:00
 | Monthly payment
 | Number of payments
 | Total interest
 | Total cost of loan
 | No. | Payment Date | Beginning Balance | Payment | Principal | Interest | Ending Balance
Spreadsheet: 829894d1684513288-delete-duplicates-based-on-multiple-criteria-historical-data-sample
Sheet: Sheet1

Total | Invoice Business Unit | Project Number
0 | Department A | Customer 1234 |  |  | Department A | Customer 1234
0 | Department A | Customer 1234 |  | 0 | Department B | Customer 1234
0 | Department A | Customer 1234 |  | 0 | Department B | Customer 2345
0 | Department B | Customer 1234 |  | 89 | Department B | Customer 2345
0 | Department A | Customer 1234 |  | 89 | Department C | Customer 0812
0 | Department B | Customer 2345 |  | 0 | Department D | Customer 0812
89 | Department B | Customer 2345 |  | 0 | Department C | Customer 0812
89 | Department C | Customer 0812
0 | Department D | Customer 0812
0 | Department C | Customer 0812
0 | Department D | Customer 0812
7
Spreadsheet: vkaminski__40907__raptor2c
Sheet: Amort

[NAME] to Talon Amortization Table
 | Inputs
Principle | 50000000
Annual Interest Rate | 0.07
Term (in months)
Payments Per Year | 2
Payment | 0
 | Period | Beginning Balance | Payment | Principle | Interest | Ending Balance | Cum. Interest
2000-06-29 00:00:00 | 0 |  | 0 |  | 0
2000-12-29 00:00:00
2001-06-29 00:00:00
2001-12-29 00:00:00
2002-06-29 00:00:00
2002-12-29 00:00:00
2003-06-29 00:00:00
2003-12-29 00:00:00
2004-06-29 00:00:00
2004-12-29 00:00:00
2005-06-29 00:00:00
 |  |  |  | Period
Principle Received | 0 |  |  | Date
Interest Received |  |  |  | Next Interest
Total Cash Received |  |  |  | Next Date
Time Outstanding
Interest Receivable:
Interest Income
[NAME] to Harrier Interest Calculation
 | Inputs
Principle | 400000000
Annual Interest Rate | 0.07
Payments Per Year | 2
 | Period | Beginning Balance | Increase (+) Decrease (-) | Principle | Interest | Ending Balance | Cum. Interest
2000-06-29 00:00:00 | 0 |  | 0 | 0 | 0
2000-12-29 00:00:00 |  |  |  | 0
2001-06-29 00:00:00 |  |  | 0 | 0
2001-12-29 00:00:00 |  |  | 0 | 0
2002-06-29 00:00:00 |  |  | 0 | 0
2002-12-29 00:00:00 |  |  | 0 | 0
2003-06-29 00:00:00 |  |  | 0 | 0
2003-12-29 00:00:00 |  |  | 0 | 0
2004-06-29 00:00:00 |  |  | 0 | 0
2004-12-29 00:00:00 |  |  | 0 | 0
2005-06-29 00:00:00 |  |  | 0 | 0
 |  |  |  | Period
 |  |  |  | Date
Interest to Note |  |  |  | Next Interest
Total |  |  |  | Next Date
Time Outstanding
Interest Payable:
Interest Expense
Notes:
 | increase to loan is settlement of Put option
 | addl. interest on Settlement
 | Total
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 | 97399 | 104103
500232 |  |  |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 | 90386 | 66695 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 | 104839 | 112850
500293 | 45567 | 61288
500302 |  | 1011
500303 | 18605 | 33363
500305 | 96464 | 135906
500307 | 13467 | 14983
500313 |  | 315
500314
500655 | 49184
500657 | 16511 | 18000
INDEX
2001-06-30 00:00:00 |  |  | -27031.85
2001-07-03 00:00:00
Spreadsheet: 840001d1692354865-producing-a-table-from-data-on-another-sheet-within-a-specific-time-frame-test2
Sheet: Dashboard

This Weeks Workload
Job Number | Status | Project Name | Current LBE | Finish | DLA | Estimating Status
10001 | Live Tender | X2 | 1000000 | 2023-07-27 00:00:00 | 2023-08-16 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X3 | 1000000 | 2023-07-28 00:00:00 | 2023-08-17 00:00:00 | DLA Achieved and Issued
10001 | Live Tender | X4 | 1000000 | 2023-07-28 00:00:00 | 2023-08-15 00:00:00 | DLA Achieved and Issued
Spreadsheet: 86247d1286274589-indirect-validation-rule-error-validation-lookup
Sheet: Sheet1

 | OWN | CUSTOMER | VALUE
 | 10000
 | Full time Comprehensive only
 | Own | Customer
5000 | 5000 | 7500 | 0.98
7500 | 5000 | 10000 | 1
10000 | 5000 | 12500 | 1.06
12500 | 5000 | 15000 | 1.1
15000 | 5000 | 20000 | 1.19
20000 | 5000 | 25000 | 1.27
25000 | 5000 | 30000 | 1.37
30000 | 7500 | 7500 | 1
 | 7500 | 10000 | 1.04
 | 7500 | 12500 | 1.08
 | 7500 | 15000 | 1.13
 | 7500 | 20000 | 1.23
 | 7500 | 25000 | 1.3
 | 7500 | 30000 | 1.4
 | 10000 | 10000 | 1.08
 | 10000 | 12500 | 1.1
 | 10000 | 15000 | 1.15
 | 10000 | 20000 | 1.25
 | 10000 | 25000 | 1.33
 | 10000 | 30000 | 1.42
 | 12500 | 12500 | 1.12
 | 12500 | 15000 | 1.17
 | 12500 | 20000 | 1.27
 | 12500 | 25000 | 1.35
 | 12500 | 30000 | 1.45
 | 15000 | 15000 | 1.2
 | 15000 | 20000 | 1.3
 | 15000 | 25000 | 1.37
 | 15000 | 30000 | 1.48
 | 20000 | 20000 | 1.35
 | 20000 | 25000 | 1.4
 | 20000 | 30000 | 1.51
 | 25000 | 25000 | 1.45
 | 25000 | 30000 | 1.54
 | 30000 | 30000 | 1.6
Spreadsheet: 802904d1667137115-making-sets-of-many-parts-making-sets
Sheet: Blad1

artnr | Availability | [NAME] |  | info | info | Part A | qty | Part b | qty | Part C | qty | Part D | qty | Part E | qty | Part F | qty
READY A | 2 | txt |  | txt | txt | 1234 | 2 | 2345 | 35 | 3456 | 34 | 4567 | 6 | 6789 | 9 | 9987 | 26
 | In this case i build have 2 sets that exists
 | in stock |  |  |  |  | Divided: | 1 |  | 3 |  | 1 |  | 3 |  | 3 |  | 3
 | Present nr of sets
 | that contains items in colour
 | in columns G to R
 | Example of how many set i can build
 | 4 |  | If following exist to the right: |  |  |  | 8 |  | 12 |  | 34 |  | 67 |  | 123 |  | 56
 | 7 |  | If following exist to the right: |  |  |  | 7 |  | 999 |  | 234 |  | 876 |  | 123 |  | 345
Spreadsheet: 765564d1643387453-insert-a-column-of-cells-based-on-a-simple-number-insert-a-block-of-cells-002
Sheet: Sheet1

F1 |  |  | D1 | E1 | F1 | [NAME]
F2 |  |  | D2 | E2 | F2 | G2
F3 |  |  | D3 |  | F3 | G3
F4 |  |  |  |  | F4 | G4
F5 |  |  |  |  | F5
[NAME]
G2
G3
G4
E1
E2
[NAME]
G2
G3
G4
D1
D2
D3
[NAME]
G2
G3
G4
F1
F2
F3
F4
F5
Spreadsheet: darrell_schoolcraft__7309__imball0201
Sheet: WTGmktg

 | /------------------------------------------  contract 22100  --------------------------------------------------------\
 | 10811 |  | 13234 |  | 16540 |  | 500648
 | Follet |  | Oasis Dairy Farms |  | WTG/TW Winker |  | Sum WTG New Mex
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -173 | -170 |  |  | -1576 | -1050
2 | -214 | -170 |  |  | -1603 | -1050
3 | -199 | -170 |  |  | -1406 | -1050
4 | -152 | -170 |  |  | -1400 | -1050
5 | -147 | -170 |  |  | -1303 | -1050
6 | -164 | -170 |  |  | -1240 | -1050
7 | -174 | -170 |  |  | -1112 | -1050
8 | -164 | -170 |  |  | -876 | -1050
9 | -143 | -170 |  |  | -729 | -1050
10 | -143 | -170 |  |  | -1037 | -1050
11 | -144 | -170 |  |  | -1043 | -1050
12 |  | -170 |  |  | -1049 | -1050
13 | -144 | -170 |  |  | -916 | -1050
14 | -144 | -170 |  |  | -1099 | -1050
15 | -157 | -170 |  |  | -824 | -1050
16 | -159 | -170 |  |  | -772 | -1050
17 | -158 | -170 |  |  | -851 | -1050
18 | -191 | -170 |  |  | -950 | -1050
19 | -166 | -170 |  |  | -1033 | -1050
20 | -155 | -170 |  |  | -1036 | -1050
21 | -159 | -170 |  |  | -864 | -1050
22 | -148 | -170 |  |  | -668 | -1050
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | -35540.33
2002-01-22 00:00:00
CBS Volume
 |  |  | -3434