tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 167824d1342110932-excel-2007-vlookup-help-2012-bud-help_v2
Sheet: Apr

Monthly [NAME]
 | [NAME] | Date Due | Date Paid | Amount Due | Amount Paid | Status | Comment
 | Mortgage | 2012-04-01 00:00:00 | 2012-03-25 00:00:00 | 875.48 | 875.48
 | Tundra | 2012-04-15 00:00:00 | 2012-04-05 00:00:00 | 343.92 | 343.92
 | Cruze |  |  | 240.38
 | Verizon Wireless | 2012-04-23 00:00:00 | 2012-04-19 00:00:00 | 167.54 | 167.54
 | RZMC | 2012-04-18 00:00:00 | 2012-04-13 00:00:00 | 24.88 | 24.88
 | Capital One | 2012-04-18 00:00:00 | 2012-04-05 00:00:00 | 30 | 153.83
 | Household Bank
 | Insurance | 2012-04-15 00:00:00 | 2012-04-05 00:00:00 | 68.74 | 68.74
 | RG&E | 2012-04-13 00:00:00 | 2012-04-19 00:00:00 | 202.95 | 202.95
 | Time Warner | 2012-04-16 00:00:00 | 2012-04-19 00:00:00 | 121.32 | 121.32
 | ACS |  | 2012-04-16 00:00:00 | 157 | 157
 | AES |  | 2012-04-16 00:00:00 | 139 | 139
 | Sallie Mae | 2012-04-07 00:00:00 | 2012-04-05 00:00:00 | 213.47 | 213.47
 | 1st Financial |  | 2012-04-16 00:00:00 | 35 | 35
 | Waste Management | 2012-04-05 00:00:00 | 2012-04-05 00:00:00 | 92.19 | 92.19
 | Water Authority
 | Wells Fargo - Furniture | 2012-04-11 00:00:00 | 2012-04-05 00:00:00 | 40 | 40
 | Doe | 2012-04-21 00:00:00 | 2012-04-19 00:00:00 | 301.32 | 301.32
 | [NAME] |  | 2012-04-05 00:00:00 | 175
 | [NAME]
 | Paychecks
 |  | Pay Date | Amount
 |  | 2012-04-06 00:00:00 | 1540.13
 |  | 2012-04-20 00:00:00 | 1233.56
 |  | 2012-04-27 00:00:00
 | Total Bills for month:
 | Total Payments for month:
 | Total Income for the month
Spreadsheet: 00bf7faf-6a0d-47b6-96c4-d0b359789e32
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
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 2. HOUSING AND PERSONAL FINANCE COMMITMENTS By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Housing Finance - Banks ; |  |  | Original | A2437051V | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Housing Finance - Permanent building societies ; |  |  | Original | A2437052W | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Housing Finance - Wholesale lenders n.e.c. ; |  |  | Original | A2437053X | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Housing Finance - Other lenders ; |  |  | Original | A2437054A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Housing Finance - Total ; |  |  | Original | A2437055C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Personal Finance - Banks ; |  |  | Original | A2437046A | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Personal Finance - Credit co-operatives ; |  |  | Original | A2437047C | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Personal Finance - Finance companies ; |  |  | Original | A2437048F | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Personal Finance - Other lenders ; |  |  | Original | A2437049J | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
Personal Finance - Total ; |  |  | Original | A2437050T | 1985-01-01 00:00:00 | 2010-10-01 00:00:00 | 310 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: michelle_lokay__26611__Jan01pnr
Sheet: Summary

Transwestern Pipeline Company
Park n Ride Service
Actual Billing Summary
Billing Month | Buyer | Purchase Order # | Contract | POI | Dekatherm | Rate/Dth | Imputed Rate | Rate_Type Daily/Total | Invoice Amount | Remaining Balance
2001-01-01 00:00:00 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.3883 |  | Daily
 |  |  |  |  |  | 0.1 |  | Daily
 | TOTALS
Spreadsheet: 775551d1649174502-dependent-drop-down-list-without-named-ranges-example-excel-spreadsheet
Sheet: Request Form

 |  | Project Name
 |  | Documentation Number Request Form (DNRF)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rev 0
 |  |  | Project Document Number |  |  |  |  |  | [NAME] to fill in |  |  |  |  |  | Drawing Title Originator to fill in |  | Comments / Reason for Cancellation Originator to fill in | Scope Information |  | Planned Issue Dates
 |  | Originator to fill in |  |  |  |  | DC to fill in
 |  | Request Type | Project # | Location | Discipline | [NAME] | Doc. Sequence (xxxxx) | Sheet No. (Dwgs Only) (xx) |  |  |  |  |  |  |  |  |  | WBS Code (CTR Number) | ROC | Plan Date 1 | Plan Date 2 | Plan Date 3
 |  | New | 123456 | AAA111 | _0 | 00 | 0001 |  |  |  |  |  |  |  | TEST TITLE
 |  | New | 123456 | BBB222 | _0 | 01 | 0001
 |  | Change | 123456 | CCC333 | _2 | 02 | 0001
 |  | Cancellation | 123456 | DDD444 | _3 | 03 | 0001
 |  |  | Company Name:
 |  |  | Requestor/Originator:
 |  |  | Date Requested:
 |  |  | Do not Delete
 |  |  | 0000
 |  |  | 0010
 |  |  | 0020
 |  |  | 0030
 |  |  | 0040
 |  |  | 0050
 |  |  | 0060
 |  |  | 0100
 |  |  | 0110
 |  |  | 0171
 |  |  | 1000
 |  |  | 1100
 |  |  | 1110
 |  |  | 1120
 |  |  | 1200
 |  |  | 1210
 |  |  | 1220
 |  |  | 1230
 |  |  | 1290
 |  |  | 1295
 |  |  | 1300
 |  |  | 1400
 |  |  | 1500
 |  |  | 1600
 |  |  | 1710
 |  |  | 1711
 |  |  | 1810
 |  |  | 1820
 |  |  | 1830
Spreadsheet: 875222d1721806840-schools-angling-league-scoresheet-schools-league-1-2024-punte
Sheet: Hoerskole

Angler | Zone | Team | Fish | Weight | Angling Points | Zone Points
[NAME] | C | [NAME] [NAME] | 11 | 27.9
[NAME] | A | [NAME] [NAME] | 17 | 24.685
Jakobus Beukes | C | [NAME] [NAME] | 8 | 21.9
NJ de Wet | A | [NAME] [NAME] | 12 | 16.98
Dewalt du Plessis | D | BENNIES - BEN VILJOEN | 8 | 34.51
[NAME] | B | BENNIES - BEN VILJOEN | 9 | 16.905
Japie Oberholzer | D | BENNIES - BEN VILJOEN | 6 | 13.19
Ruben Language | B | BENNIES - BEN VILJOEN | 5 | 16.075
[NAME] | A | HANS STRYDOM 1 | 18 | 47.02
[NAME] | C | HANS STRYDOM 1 | 11 | 23.3
Lohan du Plooy | A | HANS STRYDOM 1 | 13 | 25.05
[NAME] | C | HANS STRYDOM 1 | 2 | 2.57
[NAME] | B | [NAME] | 7 | 21.75
[NAME] | D | [NAME] | 2 | 10.96
[NAME] | D | [NAME] | 3 | 6.05
[NAME] | B | [NAME] | 2 | 4.88
Fredrick Botes | B | HPP HENGELSPAN 1 | 16 | 37.9
[NAME] | D | HPP HENGELSPAN 1 | 17 | 37.68
Du Preez Coetzee | B | HPP HENGELSPAN 1 | 10 | 27.885
Anru [NAME] | D | HPP HENGELSPAN 1 | 12 | 29.58
[NAME] | C | HPP HENGELSPAN 2 | 7 | 18.8
JG Lubbe | C | HPP HENGELSPAN 2 | 4 | 6.3
Ruben Hugo | A | HPP HENGELSPAN 2 | 9 | 26.9
[NAME] | A | HPP HENGELSPAN 2 | 10 | 19.505
[NAME] [NAME] | B | HPP HENGELSPAN 3 | 20 | 51.6
[NAME] | B | HPP HENGELSPAN 3 | 3 | 9.79
Dillon Breedt | D | HPP HENGELSPAN 3 | 0 | 0
[NAME] | D | HPP HENGELSPAN 3 | 0 | 0
[NAME] | C | HPP HENGELSPAN 4 | 1 | 2.3
[NAME] | A | HPP HENGELSPAN 4 | 0 | 0
[NAME] | A | HPP HENGELSPAN 4 | 0 | 0
AJ [NAME] | C | HPP HENGELSPAN 4 | 0 | 0
[NAME] | B | HPP HENGELSPAN 5 | 3 | 10.075
[NAME] | B | HPP HENGELSPAN 5 | 2 | 2.68
[NAME] | D | HPP HENGELSPAN 5 | 0 | 0
[NAME] | A | PHS LEDGENTS - HS PIETERSBURG | 25 | 89.14
Juaden Durant | A | PHS LEDGENTS - HS PIETERSBURG | 29 | 62.57
[NAME] | D | PHS LEDGENTS - HS PIETERSBURG | 0 | 0
[NAME] | C | PHS LEDGENTS - HS PIETERSBURG | 0 | 0
[NAME] | C | PHS LEDGENTS - HS PIETERSBURG | 0 | 0
[NAME] | C | TOMMY TIERE - TOM NAUDE | 17 | 36.8
[NAME] | A | TOMMY TIERE - TOM NAUDE | 17 | 24.01
[NAME] | A | TOMMY TIERE - TOM NAUDE | 11 | 27.72
[NAME] | C | TOMMY TIERE - TOM NAUDE | 7 | 18.5
Lugeon  Langhenhoven | D | TOMMYNATORS - TOM NAUDE | 17 | 40.55
[NAME] | D | TOMMYNATORS - TOM NAUDE | 14 | 31.22
[NAME] | B | TOMMYNATORS - TOM NAUDE | 9 | 14.54
[NAME] | B | TOMMYNATORS - TOM NAUDE | 9 | 11.4
 |  |  | Average
Spreadsheet: 834976d1688208341-rank-function-streamline-process-rank-function
Sheet: Sheet1

 | Existing Data Set (Sample)
 | Q1 | Q2 | Q3 | Q4
2020 | -7156 | 9419 | 6490 | 5116
2021 | 4216 | 2137 | -8701 | 6490
2022 | -4731 | -8062 | 9946 | 1421
2023 | 5158 | 1396
Spreadsheet: 720182d1614061266-guidance-on-how-i-can-automate-the-on-time-where-it-follows-certain-conditions-test
Sheet: Scenario 2

Time (Normal Room) | ON/OFF Time |  | Time | Duration(min) | Normal Room
00:00:00 | 1 |  | 1900-01-12 00:00:00 | 0 | 1 |  | [NAME] ==> User can type "1" or "0"
 | 0 |  | 1900-01-12 00:10:00 | 10 | 1 |  | Green Cells ==> User can insert how many minutes (Range:10,20,30,40,50 only)
 | 1 |  | 1900-01-12 00:20:00 | 20 | 1
 | 1 |  | 1900-01-12 00:30:00 | 30 | 0 |  | Since 12Am is ON, so the 12:00-12:50am follows the Green cells values
 | 1 |  | 1900-01-12 00:40:00 | 40 | 0 |  | Since 1AM is OFF, so that hour is all OFF
 |  |  | 1900-01-12 00:50:00 | 50 | 0 |  | Since 3-5AM is ON, then 2:00-5:50AM operate on Green Cells Values
 |  |  | 1900-01-12 01:00:00 | 60 | 0
 |  |  | 1900-01-12 01:10:00 | 70 | 0
 |  |  | 1900-01-12 01:20:00 | 80 | 0
 |  |  | 1900-01-12 01:30:00 | 90 | 0
 |  |  | 1900-01-12 01:40:00 | 100 | 0
 |  |  | 1900-01-12 01:50:00 | 110 | 0
 |  |  | 1900-01-12 02:00:00 | 120 | 1
 |  |  | 1900-01-12 02:10:00 | 130 | 1
 |  |  | 1900-01-12 02:20:00 | 140 | 1
 |  |  | 1900-01-12 02:30:00 | 150 | 0
 |  |  | 1900-01-12 02:40:00 | 160 | 0
 |  |  | 1900-01-12 02:50:00 | 170 | 0
 |  |  | 1900-01-12 03:00:00 | 180 | 1
 |  |  | 1900-01-12 03:10:00 | 190 | 1
 |  |  | 1900-01-12 03:20:00 | 200 | 1
 |  |  | 1900-01-12 03:30:00 | 210 | 0
 |  |  | 1900-01-12 03:40:00 | 220 | 0
 |  |  | 1900-01-12 03:50:00 | 230 | 0
 |  |  | 1900-01-12 04:00:00 | 240 | 1
 |  |  | 1900-01-12 04:10:00 | 250 | 1
Normal Room |  |  | 1900-01-12 04:20:00 | 260 | 1
ON time (min) | 30 |  | 1900-01-12 04:30:00 | 270 | 0
OFF time (min) | 30 |  | 1900-01-12 04:40:00 | 280 | 0
 |  |  | 1900-01-12 04:50:00 | 290 | 0
 |  |  | 1900-01-12 05:00:00 | 300
 |  |  | 1900-01-12 05:10:00 | 310
 |  |  | 1900-01-12 05:20:00 | 320
 |  |  | 1900-01-12 05:30:00 | 330
 |  |  | 1900-01-12 05:40:00 | 340
 |  |  | 1900-01-12 05:50:00 | 350
 |  |  | 1900-01-12 06:00:00 | 360
 |  |  | 1900-01-12 06:10:00 | 370
 |  |  | 1900-01-12 06:20:00 | 380
 |  |  | 1900-01-12 06:30:00 | 390
 |  |  | 1900-01-12 06:40:00 | 400
 |  |  | 1900-01-12 06:50:00 | 410
 |  |  | 1900-01-12 07:00:00 | 420
 |  |  | 1900-01-12 07:10:00 | 430
 |  |  | 1900-01-12 07:20:00 | 440
 |  |  | 1900-01-12 07:30:00 | 450
 |  |  | 1900-01-12 07:40:00 | 460
 |  |  | 1900-01-12 07:50:00 | 470
 |  |  | 1900-01-12 08:00:00 | 480
 |  |  | 1900-01-12 08:10:00 | 490
 |  |  | 1900-01-12 08:20:00 | 500
 |  |  | 1900-01-12 08:30:00 | 510
 |  |  | 1900-01-12 08:40:00 | 520
 |  |  | 1900-01-12 08:50:00 | 530
 |  |  | 1900-01-12 09:00:00 | 540
 |  |  | 1900-01-12 09:10:00 | 550
 |  |  | 1900-01-12 09:20:00 | 560
Spreadsheet: 701044d1603478879-data-from-one-form-to-another-example-1-1-sumproductandif
Sheet: Sheet1

 |  | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 |  | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
101 | Oregon | Apple | Orange | Apple |  |  | Apple |  |  | Apple | Apple |  |  | Apple
102 | Washington | Grape |  | Grape |  |  | Grape | Grape |  |  | Grape |  | Grape |  | Grape |  | 4
103 | Alaska | Peach |  |  | Peach | Grape | Peach | Peach | Peach |  |  | Peach | Peach |  | Peach
104 | Hawaii | Melon | Apple |  | Melon |  |  | Melon |  |  | Melon |  | Melon | Melon
105 | California | Berries |  | Berries | Berries |  | Berries | Berries | Berries |  |  | Berries | Berries | Berries | Berries
106 | Idaho | Orange |  |  | Orange |  |  |  |  | Orange |  |  |  |  | Orange
107 | Nevada | [NAME] | Berries |  | Apple | Melon | [NAME] |  |  |  | [NAME] | [NAME]
 | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2020-11-08 00:00:00 | 2020-11-09 00:00:00 | 2020-11-10 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 | 2020-11-13 00:00:00 | 2020-11-14 00:00:00 | 2020-11-15 00:00:00 | 2020-11-16 00:00:00 | 2020-11-17 00:00:00 | 2020-11-18 00:00:00 | 2020-11-19 00:00:00 | 2020-11-20 00:00:00 | 2020-11-21 00:00:00
Apple
Grape
Peach
Melon
Berries
Orange
[NAME]
Spreadsheet: 328398d1403886940-solver-error-in-maximizing-a-correlation-coefficient-y-index-index-correlations-excelforum
Sheet: Correlations

Corr. Table
MISERY Correlation |  | EoDB: [NAME] | EoDB: int | EoDB: inf | EoDB: un | EoDB: gdp | DtF: [NAME] | DtF: int | DtF: inf | DtF: un | DtF: gdp | [NAME].: [NAME] | [NAME].: int | [NAME].: inf | [NAME].: un | [NAME].: gdp | Soc. P.: [NAME] | Soc. P.: int | Soc. P.: inf | Soc. P.: un | Soc. P.: gdp | Cato: [NAME] | Cato: int | Cato: inf | Cato: un | Cato: gdp | [NAME].: [NAME] | [NAME].: int | [NAME].: inf | [NAME].: un | [NAME].: gdp | [NAME]: [NAME] | [NAME]: int | [NAME]: inf | [NAME]: un | [NAME]: gdp
Interest Rate | 1
Inflation Rate | 1
Unemployment | 1
GDP growth | 1
MISERY Correlations
EoDB
DtF
Heri.
Soc. P.
Cato
[NAME].
S. IMD
Spreadsheet: 805033d1668498564-how-to-collect-frequent-word-s-mentioned-from-survey-s666-pq-how-to-collect-frequent-word-s-mentioned-from-survey
Sheet: Sheet1

Column1 |  |  |  |  |  | Column1.2 | Count
Mr A: i like to have orange juice with so many ice cubes |  |  |  |  |  | juice | 3
Mr B: mango juice would be sufficient for me. |  |  |  |  |  | orange | 2
Mr C: Orange Juice is what i need everyday. |  |  |  |  |  | i | 2
 |  |  |  |  |  | sufficient | 1
 |  |  |  |  |  | for | 1
 |  |  |  |  |  | would | 1
 |  |  |  |  |  | be | 1
 |  |  |  |  |  | me. | 1
 |  |  |  |  |  | need | 1
 |  |  |  |  |  | what | 1
 |  |  |  |  |  | is | 1
 |  |  |  |  |  | everyday. | 1
 |  |  |  |  |  | have | 1
 |  |  |  |  |  | with | 1
 |  |  |  |  |  | like | 1
 |  |  |  |  |  | to | 1
 |  |  |  |  |  | so | 1
 |  |  |  |  |  | cubes | 1
 |  |  |  |  |  | mango | 1
 |  |  |  |  |  | many | 1
 |  |  |  |  |  | ice | 1
Spreadsheet: c45907c5-5485-4584-8735-5f1913495b8a
Sheet: Sheet1

Referenties Theaters en Voorstellingen | Unnamed: 1
Theaters
Ahoy | [NAME]
Chasse Theater | [NAME]
Theater Hotel | [NAME]
Theater aan de Parade | [NAME]
[NAME] | [NAME]
Theater 't Speelhuis | Helmond
Theater Castellum | Alphen aan de Rijn
Schouwburg de Lawei | Drachten
Spant! | Bussum
Stadsschouwburg de Harmonie | Leeuwarden
Theater de Uitstek | Zwijndrecht
Stadsschouwburg de Maagd | Bergen op Zoom
Schouwburg het Park | Hoorn
De Koornbeurs | Franeker
[NAME] | Utrecht
[NAME] | Den Helder
The Harbour Theater | Zeewolde
De Tamboer | Hoogeveen
[NAME] | Alkmaar
[NAME] | [NAME]
[NAME] schouwburg | [NAME]
Theater de Lockhorst | Sliedrecht
Theater Concordia | [NAME]
Isala Theater | Capelle ad Ijsel
Theaterkerk Wadway | Wadway
[NAME] | Gouda
Theater de Nobelaer | Etten-Leur
Festige Theater | Amsterdam
[NAME] | Amsterdam
Thalia Theater | Ijmuiden
It [NAME] | Eernewoude
De Reehorst | Ede
Theater de twee Hondjes | Hellevoetsluis
Voorstellingen
Big Black and Beautifull XL
[NAME] en Pim
Respect
Love Me just a little bit more
Hold tight It's 60's night
Hold tight It's 70's night
Hold tight It's 80's night
Discomania
Jeans 19    2008 - 2009
Jeans 19: Back in town
[NAME]
[NAME] of the 80's
Re-play in concert
Soul Brothers
The Soul of Motown II
[NAME]  het [NAME]… in concert
[NAME]
Frans Bauer
Is Ook Schitterend
Route 66
Fame
Abba Mania
[NAME]
[NAME]
Bubbling Brown Sugar
[NAME]
[NAME]
Doe Maar
Diep Triest
one night of Queen
[NAME]
Chipz
Motel West Coast
Girls Wanna Have Fun
Rowen heze
Saterdaynight At The Movies
SpangaS
Motownhead & The soultrip express
Soul of Motown
Soulsisters
[NAME]
The Beatles
Soul Celebration
[NAME] band
The Royal Dutch Disco
Spreadsheet: 192578d1352462449-forecast-function-cogs
Sheet: Sheet1

Cost By Nature - Totals (USD) |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
Data |  | 10 | 11 | 12 | 13 | 14 | 15 | 10 | 10 | 10 | 10 |  |  | 115
Manufacturing |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | 100
Editorial |  | 10 | 11 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | 101
Royalty |  | 10 | 12 | 10 | 10 | 10 | 10 | 10 | 11 | 12 | 10 |  |  | 105
Distribution |  | 10 | 13 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | 103
Other Customer Related |  | 10 | 10 | 10 | 10 | 11 | 12 | 10 | 10 | 10 | 10 |  |  | 103
Other Revenue Related |  | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 10 |  |  | 100
[NAME] |  | 70 | 77 | 72 | 73 | 75 | 77 | 70 | 71 | 72 | 70 | 0 | 0 | 727
Spreadsheet: 696749d1600960141-nested-if-function-orderboek-en-salesplanning-question-excel-forum
Sheet: Voorblad

 | 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
Recurring signed cont
Services signed cont
Recurring oral agreement
Recurring offer sent
Recurring Client interested
Services oral agreement
Services offer sent | 0 | 0 | 0
Services Client interested
Services GAP |  | 0
Recurring GAP
Totaal
Recurring budget | 84.61043536111112 | 85.03619127020202 | 85.42619127020203 | 86.34527460353534 | 88.67860793686869 | 94.67860793686869 | 99.8571793654401 | 100.746941270202 | 100.746941270202 | 116.897041270202 | 116.897041270202 | 116.897041270202 | 1176.817494095238
Services budget | 124.4843473389356 | 136.6880973389356 | 135.1240973389355 | 132.6552640056022 | 139.9052640056022 | 122.6705140056022 | 125.9705140056022 | 122.8605140056022 | 122.8605140056022 | 125.3096806722689 | 125.3096806722689 | 125.3096806722689
Total budget
rvc sheet rec |  |  |  | #[NAME]! | #[NAME]! | 81.59012333333334 | 85.44429000000001 | 85.44429000000001 | 86.34429 | 85.21679 | 91.36262333333333 | 93.44595666666667
deze sheet rec
rvc sheet services |  |  |  | #[NAME]! | #[NAME]! | 119.4848 | 137.3997377666666 | 132.586767 | 142.2117085333333 | 134.1542418666666 | 134.1542418666666 | 140
deze sheet services
capaciteitscorrectie | 0 | 0 | 0 |  |  | 0
Budget recurring
Total
Services Gap
Capaciteit
Recurring estimate
Recurring budget
Services estimate
Services budget
Recurring estimate vs budget
Services estimate vs budget
Spreadsheet: 743965d1628843978-highlight-date-range-on-calendar-399
Sheet: Non Hire

 |  |  | 3099      NON HIRE RECORD
Storage Start Date | Storage End Date | No. of Days | Comments
2019-12-10 00:00:00 | 2020-02-16 00:00:00 |  | Refurb prior to hire
2020-05-28 00:00:00 | 2020-06-11 00:00:00 |  | Check over & HF
2020-08-10 00:00:00 | 2020-09-21 00:00:00 |  | CT change, oil top up, new return roller, grease top up, shaft
2020-11-17 00:00:00 | 2020-11-24 00:00:00 |  | Not on hire
2020-12-04 00:00:00 | 2020-12-08 00:00:00 |  | Not on hire - back fr Rec Lives
2021-01-28 00:00:00 | 2021-03-24 00:00:00 |  | Not on hire back from TW
2021-08-18 00:00:00 |  |  | Not on hire back from Suez, [NAME]
Spreadsheet: 691665cb-c5e2-4ca2-a6ad-20e944935a72
Sheet: Sheet1

OPERATING/PROGRAMMATIC | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Legislative Fiscal Note |  |  |  |  |  |  | Ordinance Number
Ordinance Title (in Brief)
 | Accepting grant and authorizing contracts with various agencies from the HUD
 | 2008 Supportive Housing Program $715,853
Does this Legislation Estimate New or Additional Revenues to the City? |  |  |  |  |  |  |  | No |  | X | Yes
 | If yes, please identify in  which Fund these revenues will be deposited (e.g. General, Sales Tax) |  |  |  |  |  |  |  |  |  | General Fund
 | and provide the following revenue information:
 | Revenue Detail |  |  |  | FY2008-09 |  |  | FY2009-10
 | General Fund |  |  |  |  |  |  | 5417
 | Special Revenue
 | Enterprise
 |  |  | Total: | $ | 0 |  | $ | 5417
 | (Please detail type of revenue (fees, grants, tax) and change that will occur as a result of this legislation.  Provide multi-year
 | estimates if known, or if grant revenue please identify source of funds (federal or state) and duration of grant support)
 | The City will receive an additional $5,417 for leasing costs which will be contracted to two non profits, i.e.
 | reStart and United Services Community Action Agency.
Does this Legislation increase appropriations in the current budget? |  |  |  |  |  |  |  | No |  | X | Yes
 | If Yes, please complete the following budget information:
 | Expense Detail |  |  |  | FY2008-09 |  |  | FY2009-10
 | General Fund |  |  |  | 0 |  |  | 5417
 | Special Revenue
 | Enterprise/Other
 |  |  | Total: | $ | 0 |  | $ | 5417
 | Please detail the extent to which these increased appropriations will be of a permanent nature (e.g. number of
 | additional staff, facilities, long-term contracts)
 | Appropriation will increase by the above. The general fund will not be impacted as the funds will be
 | reimbursed to the City.
Does this Legislation expand the scope of current city services? |  |  |  |  |  |  | x | No |  |  | Yes
 | (Please detail estimate number of people to be served, who is delivering services currently to that population, service
 | performance expectations, and if grant supported, provisions for support if grant support ends.
Is this legislation the result of a federal or state legislative mandate? |  |  |  |  |  |  | x | No |  |  | Yes
 | (If yes, please detail the purpose and source for that mandate).
Reviewed by:
 | 0ffice of Management and Budget |  |  | OMB Approval Date
Spreadsheet: 848063d1698861367-how-can-i-pick-up-unique-values-in-sumif-test_order_date
Sheet: Sheet1

 |  |  |  |  | Calculated report |  |  |  | How I want it
Order Month | Order No | [NAME] | Delivered |  | Month | Ordered | Delivered |  |  | Ordered | Delivered
Jan | 1 | 10 | 7 |  | Jan |  |  |  | Jan | 30 | 27
Jan | 2 | 20 | 20 |  | Feb |  |  |  | Feb | 0 | 3
Feb | 1 | 10 | 3
 | NB The order number appears twice in column B
 | I only want to count the relevant ordsref qty once in col G
Spreadsheet: 673696d1587491878-look-up-a-list-of-client-purchases-with-dates-2020-04-21-oeldere-re-arange-data-673683d1587488440-look-up
Sheet: Sheet1

 | Book 1 | Book 2 | Book 3 | Book 4 | Book 5 | Book 6 | Book 7 | Book 8 | Book 9 | Book 10 | Book 11 | Book 12
Client A |  | 2017-05-05 00:00:00 |  |  | 2018-06-01 00:00:00 | 2018-08-08 00:00:00 |  |  | 2019-09-25 00:00:00
Client B | 2016-02-01 00:00:00 |  | 2017-08-22 00:00:00 |  |  |  | 2019-10-09 00:00:00
Client C |  |  |  | 2016-02-22 00:00:00 |  |  |  |  |  |  | 2019-03-02 00:00:00 | 2020-01-05 00:00:00
Client D |  | 2015-11-10 00:00:00 |  |  |  | 2018-04-08 00:00:00 |  |  | 2019-01-27 00:00:00 | 2020-03-12 00:00:00
Client E |  |  |  |  |  |  |  |  |  |  | 2018-08-12 00:00:00 | 2018-09-22 00:00:00
 |  |  |  | Client D | Book 2 | 2015-11-10 00:00:00
 |  |  |  |  | Book 6 | 2018-04-08 00:00:00
 |  |  |  |  | Book 9 | 2019-01-27 00:00:00
 |  |  |  |  | Book 10 | 2020-03-12 00:00:00
 |  | Look up a list of client purchases with dates
 |  | Hi all, this is my first time on this site so please excuse any ignorance on my part.
 |  | I am looking to list out client purchases with the purchase date.
 |  | I have added a sheet showing:
 |  | Row 1 - B1:M1 being the product reference.
 |  | Column A - A2:A6 being the client names
 |  | Cell range B2:M6 being the dates of each purchase.
 |  | What I am looking to do, as per the example shown in cells E8:G11, is to enter a client name and have a formula list out in a column the product name and the date of purchase in the next column.
 |  | I would really appreciate it if someone could show me the formula to achieve this please.
 |  | Thanking you in anticipation.
Spreadsheet: 106238d1303409224-excel-2007-data-entry-spreadsheet-h-and-s-doc-reference-numbers
Sheet: LOOKUPS

REF |  | MONTH |  | YEAR |  | DEPT |  | CATEGORY
0 |  | 1 |  | 9 |  | ECD |  | PO
1 |  | 2 |  | 10 |  | AU |  | PR
2 |  | 3 |  | 11 |  | SO |  | RA
 |  | 4 |  | 12 |  |  |  | SWP
 |  | 5 |  | 13 |  |  |  | IN
 |  | 6 |  | 14 |  |  |  | SA
 |  | 7 |  |  |  |  |  | SI
 |  | 8 |  |  |  |  |  | CP
 |  | 9
 |  | 10
 |  | 11
 |  | 12