tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 793058d1661278344-ccollect-the-correct-tax-with-deductibles-from-sheet-tax-based-on-year-in-c8-bank-application
Sheet: Boliglån

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lånetid |  | Ulik lånebeløp
 | Månedlige betalinger | 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 |  | 2500000 |  | 2022
 | Boliglån |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | 3000000 |  | 2023
 | År | 25 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3500000 |  | 2024
 | Betalingsperioder |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4000000 |  | 2025
 | Boligrente |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500000
 | Betaling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5000000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5500000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6000000
 | Utvikling | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025 | 2025
 | Månedlige betalinger | Januar | Februar | Mars | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December | January | February | March | April | May | June | July | August | September | October | November | December
 | Boliglån
 | Boligrente
 | MND bet. Bolig
 | Rente
 | Avdrag
 | År | MND bet. Bolig
 | 2023
 | 2024
 | 2025
 | År | Totalt betalte renter
 | 2023
 | 2024
 | 2025
Spreadsheet: 77208d1277732708-formula-calculation-based-on-yes-no-list-quote_analyser2
Sheet: Comparison

Sector | Week Commencing | # of Jobs Quoted | Jobs Quoted Value | Average Value/Job | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate
Building | 2010-06-28 00:00:00
Landscaping
Building | 2010-07-05 00:00:00
Landscaping
Building | 2010-07-12 00:00:00
Landscaping
Building | 2010-07-19 00:00:00
Landscaping
Building | 2010-07-26 00:00:00
Landscaping
Building | 2010-08-02 00:00:00
Landscaping
Building | 2010-08-09 00:00:00
Landscaping
Building | 2010-08-16 00:00:00
Landscaping
Building | 2010-08-23 00:00:00
Landscaping
Building | 2010-08-30 00:00:00
Landscaping
Building | 2010-09-06 00:00:00
Landscaping
Building | 2010-09-13 00:00:00
Landscaping
Building | 2010-09-20 00:00:00
Landscaping
Building | 2010-09-27 00:00:00
Landscaping
Building | 2010-10-04 00:00:00
Landscaping
Building | 2010-10-11 00:00:00
Landscaping
Building | 2010-10-18 00:00:00
Landscaping
Building | 2010-10-25 00:00:00
Landscaping
Building | 2010-11-01 00:00:00
Landscaping
Spreadsheet: 870258d1716803720-suitable-formula-for-matching-the-work-counter-code-for-each-name-for-each-date-roster-trial
Sheet: Roster-May Trial

Counter | Staff no. | Name | Tel no. | 2024-05-01 00:00:00
1 | PWHK124 | [NAME] | 1111111 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | OFF | GAP-A | OW A | GAP-A | OWA | GAP-A | GAP-A | OFF | OFF | GAP-A | BT | BT | BT | BT | OFF
2 | PWHK152 | Dennis | 2222222 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | GAP-A | CCP-A | GAP-A | GAP-A | CCP-A | OFF | SL | OFF | GAP-A | GAP-A | CCP-A | GAP-A | OFF | GAP-A | GAP-A | GAP-A
3 | PWHK153 | Carol | 333333 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | GAP-A | GAP-A | GAP-A | GAP-A | SL | OFF | GAP-A | OFF | GAP-B | GAP-B | GAP-B | GAP-B | OFF | GAP-A | GAP-A | GAP-A
4 | PWHK154 | Emma | 444444 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | CCP-A | CCP-A | SH | SH | SH | SH | OFF | SH | SH | SH | SH | OFF | CCP-B | OFF | CCP-A | CCP-A | CCP-A
5 | PWHK147 | [NAME] | 5555555 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | PAP-B | PAP-B | SH | CCP-A | SH | OWHK-A | OFF | PAP-B | SH | PAP-B | PAP-B | PAP-B | SMP-B | OFF | OWHK-A | PAP-B | PAP-B
6 | PWHK148 | [NAME] | 6666666 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | OFF | OFF | SMP-B | SH | AL | AL | OWHK-A | OWHK-A | OWHK-A | OFF | OWHK-C | OWHK-C | OWHK-A | OWHK-A | OFF | OWHK-A | OWHK-C
7 | PWHK149 | [NAME] | 7777777 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | SMP-B | SMP-B | OWHK-A | SMP-B | SMP-B | SMP-B | OFF | SMP-B | SMP-B | SMP-B | SMP-B | SH | SH | OFF | SMP-B | SMP-B | SMP-B
 | 1299 | [NAME] | 9999999 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A |  |  |  | GAP-A |  |  |  |  |  | GAP-A | GAP-A
 | 1370 | Tsely | 8888888 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | OWHK-C |  |  |  | OWHK-C |  |  |  |  |  |  |  | OWHK-C |  | OWHK-A | OWHK-A | OWHK-C
 | 1274 | [NAME] | 12121212 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GAP-A | GAP-A
Spreadsheet: 119043d1314165582-lookup-function-question-index-match-offset
Sheet: Sheet1

 | 2011-05-01 00:00:00 |  | 2011-06-01 00:00:00 |  | 2011-07-01 00:00:00 |  | 2011-08-01 00:00:00 |  | 2011-09-01 00:00:00 |  |  | 2011-09-01 00:00:00
 | Fcst | Act | Fcst | Act | Fcst | Act | Fcst | Act | Fcst | Act |  | Fcst | Act
A | 5 | 4 | 3 | 4 | 2 | 3 | 8 | 7 | 7 |  |  | 7 | 0
B | 4 | 4 | 2 | 3 | 4 | 5 | 6 | 7 | 5 |  |  | 5 | 0
C | 3 | 5 | 1 | 1 | 6 | 6 | 4 | 5 | 9 |  |  | 9 | 0
Spreadsheet: 59651d1260237735-league-spreadsheet-709588-league-spreadsheet
Sheet: Schedule

Schedule
 |  |  |  |  |  |  |  | On the setup Sheet, specify how many pairings happen each week
week | team no | team name | vs | team no | team name |  |  | E.g. 20 teams per week would be 10 pairings
1 | 4 | green |  | 1 | Blue |  |  | Then, create that many lines per week
1 | 5 | purple |  | 2 | red_team |  |  | and enter the team numbers in the yellow cells
1 | 6 | orange |  | 3 | yellow |  |  | leave no blank lines.
2 | 1 | Blue |  | 4 | green |  |  | use formatting to separate weeks by color
2 | 2 | red_team |  | 5 | purple
2 | 3 | yellow |  | 6 | orange |  |  | The purple cells have formulas and must be copied down
3 | 2 | red_team |  | 5 | purple
3 | 3 | yellow |  | 6 | orange |  |  | There should always be the same number of pairings per week
3 | 4 | green |  | 1 | Blue
4 | 3 | yellow |  | 6 | orange |  |  | The number of pairings per week must be the same as the number
4 | 4 | green |  | 2 | red_team |  |  | entered on the Setup Sheet.
4 | 5 | purple |  | 3 | yellow
 |  |  |  |  |  |  |  | color key
 |  |  |  |  |  |  |  | data entry
 |  |  |  |  |  |  |  | calculated
Spreadsheet: 12db4f50-fc17-40e3-b629-b41b149a9a70
Sheet: safe harbor worksheet

Reading
 | A |  | B |  | C |  | D |  | E
 | Enter your Reading Met Standard Here |  | Subtract column A from 100 |  | Multiply column B by .1 |  | Round column C up |  | Add column D to Column A
Example | 76 |  | 24 |  | 2.4 |  | 3 |  | 79
All Students
African American
Hispanic
White
Economically Disadvantaged
Special Education
LEP
Math
 | A |  | B |  | C |  | D |  | E
 | Enter your Math Met Standard Here |  | Subtract column A from 100 |  | Multiply column B by .1 |  | Round column C up |  | Add column D to Column A
Example | 76 |  | 24 |  | 2.4 |  | 3 |  | 79
All Students
African American
Hispanic
White
Economically Disadvantaged
Special Education
LEP
Spreadsheet: 865449d1712524721-identify-dates-that-are-close-to-each-other-for-each-player-example2
Sheet: Sheet1

Name | Game 1 start date | Game 1 end date | Game 2 start date | Game 2 end date | Do I need to check?
[NAME] | 2023-03-06 00:00:00 | 2023-03-15 00:00:00 | 2023-03-07 00:00:00 | 2023-03-16 00:00:00 | Yes
[NAME] | 2023-04-27 00:00:00 | 2023-04-28 00:00:00 | 2023-05-05 00:00:00 | 2023-05-10 00:00:00 | Yes
[NAME] | 2023-03-06 00:00:00 | 2023-03-15 00:00:00 | 2023-04-28 00:00:00 | 2023-08-31 00:00:00
[NAME] | 2023-03-08 00:00:00 | 2023-08-14 00:00:00 | 2024-02-04 00:00:00 | 2024-02-06 00:00:00
[NAME] | 2023-09-06 00:00:00 | 2023-11-01 00:00:00 | 2024-02-18 00:00:00 | 2024-03-25 00:00:00 | No
Spreadsheet: 119818d1314772515-set-up-table-lab-1-bar-graph
Sheet: Sheet3

Reaction Time (cm) | Male | Female
 | 16.33 | 16.66
 | 5.88 | 16.66
 | 0.0125 | 18.33
 | 28.66 | 20
 | 25.33 | 12
 | 20.33 | 24.66
 | 21.4 | 26.66
 | 13.5 | 21.66
 | 17.9 | 20.33
 | 9.66 | 16.4
 |  | 9.66
 |  | 14.66
 |  | 12
Spreadsheet: 774176d1648269100-pulling-3-columns-of-data-in-order-to-rank-them-dynamically-example
Sheet: Sheet1

Team | Score | Rank
Team 1 | 10 | 6 |  | 1
Team 2 | 20 | 3 |  | 2
Team 3 | 60 | 1 |  | 3
Team 4 | 30 | 2 |  | 4
Team 5 | 20 | 3 |  | 5
Team 6 | 15 | 5 |  | 6
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: WilsonWeb

WilsonWeb
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 price | Price per search
Art Abstracts
Sessions | 14 | 7 | 83 | 143 | 182 | 79 | 39 | 197 | 99 | 107 | 27 | 18
Searches | 42 | 19 | 290 | 592 | 872 | 319 | 169 | 1086 | 364 | 397 | 90 | 40 |  | 4977
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Applied Science & Technology Abstracts
Sessions | 29 | 13 | 34 | 62 | 129 | 34 | 28 | 48 | 75 | 92 | 29 | 44
Searches | 126 | 35 | 108 | 156 | 548 | 152 | 130 | 158 | 257 | 243 | 70 | 205 |  | 5562
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Biological & Agricultural Index Plus
Sessions | 22 | 12 | 45 | 67 | 57 | 22 | 68 | 70 | 74 | 80 | 22 | 21
Searches | 145 | 25 | 129 | 202 | 211 | 108 | 248 | 206 | 272 | 287 | 64 | 103 |  | 3291.75
Turnaways | 0 | 0 | 20 | 0 | 0 | 0 | 53 | 0 | 6 | 0 | 0 | 0
Readers Guide Retrospective
Sessions | 45 | 1 | 16 | 57 | 23 | 12 | 10 | 30 | 38 | 41 | 8 | 11
Searches | 146 | 1 | 30 | 238 | 89 | 56 | 28 | 76 | 152 | 165 | 35 | 34 |  | 326
Turnaways | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 791152d1660177013-rag-rating-for-dates-in-different-cells-outreach-case-management-template-eba
Sheet: Sheet1

Caseload Management
Severity | Reference # | Contact Name | [NAME] | Date of last ROO contact | Service Promise met? | Exploration of Need Completed? | Safeguarding/Risk | Case review date | Next contact date/time | Contact number | Case Officer/Area | Other agencies/referrals | Notes
 |  |  |  | 09/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 03/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 04/08/2022
 |  |  |  | 04/08/2022
 |  |  |  | 08/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 05/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 01/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
 |  |  |  | 09/08/2022
Spreadsheet: 878060d1725019927-pull-names-from-several-sheets-into-total-sheet-only-if-criteria-is-met-drewber-providernames-updated-365-aligw
Sheet: Sheet3

REF? | ID | PATIENT | DATE | PROVIDER
 | A234 | BUNNY, B |  | BANNER, B
X | N3456 | FUDD, E |  | WAYNE, B
 | J165 | DUCK, D |  | KENT, C
Z | RT6514 | LE PEW, P | 2024-04-19 00:00:00 | STARK, T
Y | E566 | COYOTE, W | 2024-03-23 00:00:00 | KYLE, S
X | [NAME] | PIG, P |  | FRED, B
 | [NAME] | GONZALEZ, S | 2024-02-12 00:00:00 | [NAME], D
X | X5558 | RUNNER, R |  | STARK, T
 | X5559 | LEGHORN, F |  | [NAME], D
Z | X5560 | SAM, Y |  | CLOONEY, G
Y | X5561 | DEVIL, T |  | ALBA, J
Spreadsheet: 837892d1690484173-data-validation-custom-formula-help-1964-data-validation-part-nos
Sheet: Sheet1

Part No |  |  |  |  |  |  |  | Part Nos
1795 |  |  |  |  |  |  |  | 1316
1870 |  |  |  |  |  |  |  | 1795
 |  |  |  |  |  |  |  | 1820
 |  |  |  |  |  |  |  | 1870
 |  |  |  |  |  |  |  | 1891
 |  |  |  |  |  |  |  | 2733
 |  |  |  |  |  |  |  | 2761
 |  |  |  |  |  |  |  | 3217
 |  |  |  |  |  |  |  | 3659
 |  |  |  |  |  |  |  | 3701
 |  |  |  |  |  |  |  | 4043
 |  |  |  |  |  |  |  | 4387
 |  |  |  |  |  |  |  | 4771
 |  |  |  |  |  |  |  | 5877
 |  |  |  |  |  |  |  | 6072
 |  |  |  |  |  |  |  | 6315
 |  |  |  |  |  |  |  | 6352
 |  |  |  |  |  |  |  | 6644
 |  |  |  |  |  |  |  | 6831
 |  |  |  |  |  |  |  | 6989
 |  |  |  |  |  |  |  | 7483
 |  |  |  |  |  |  |  | 7925
 |  |  |  |  |  |  |  | 8208
 |  |  |  |  |  |  |  | 8274
 |  |  |  |  |  |  |  | 8589
 |  |  |  |  |  |  |  | 9246
 |  |  |  |  |  |  |  | 9308
Spreadsheet: 133107d1324189119-find-and-copy-top-3-values-in-range-book2
Sheet: Sheet1

[NAME] | 1
[NAME] | 2
[NAME] | 3
[NAME] | 4
Julie | 5
[NAME] | 6
[NAME] | 7
[NAME] | 8
Will | 10
[NAME] | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | find and copy top 3 numbers in range
Spreadsheet: 8e1c7a4f-55c9-4e56-b478-6f39fb836a7b
Sheet: Sheet1

analytica 2012 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (16 Entries):
 | 1 Applications 1.7 Special applications
No. | Company | Country | City | [NAME] | Hall/Booth
1 | ABB Automation GmbH Sales FTIR-NIR | Germany | Frankfurt am Main | 60488 | A2.108
2 | analyticon instruments gmbh | Germany | Rosbach | 61191 | A2.439
3 | ELEMENTAR Analysensysteme GmbH | Germany | Hanau | 63452 | A2.315/414
4 | Helmut Fischer GmbH Institut für Elektronik und [NAME] | Germany | Sindelfingen | 71069 | A1.204
5 | Innov-X Systems Europe B.V. | Netherlands | s&#39;-Hertogenbosch | 5222 AX | A2.534
6 | LECO Instrumente GmbH | Germany | Mönchengladbach | 41199 | A1.324
7 | LEONI Fiber Optics GmbH | Germany | Neuhaus-Schierschnitz | 96524 | A2.234
8 | LLA Instruments GmbH | Germany | Berlin | 12489 | A2.435
9 | L.U.M. GmbH | Germany | Berlin | 12489 | A1.526
10 | Munktell & Filtrak GmbH | Germany | Bärenstein | 09471 | A1.321
11 | PANalytical GmbH | Germany | Kassel | 34123 | A2.227
12 | [NAME] | Germany | Waiblingen | 71301 | A3.552
13 | Shimadzu Deutschland GmbH | Germany | Duisburg | 47269 | [NAME]
14 | [NAME] | United Kingdom | St. [NAME], [NAME] | BR5 4HE | A1.538B
15 | Thass Thermal Analysis & Surface Solutions GmbH | Germany | Friedberg | 61169 | A1.227
16 | Unity Scientific GmbH | Germany | [NAME] | 40549 | A1.406
Spreadsheet: 0573e495-84c1-4d0e-b025-2cd05b9abca2
Sheet: 6-Annual Financial Report

 |  |  |  |  |  |  | Date
Agency
 |  |  |  | Revision
 |  |  |  | Budget Submission #:
 |  |  | Year 1 |  |  |  | Year 2 |  |  |  | Year 3
 |  | PROGRAM CATEGORIES | [NAME] | Match Budget | Actual [NAME] | Actual Math Expenditures | [NAME] | Match Budget | Actual [NAME] | Actual [NAME] | [NAME] | Match Budget | Actual [NAME] | Actual [NAME]
 | Support Program
 |  | Purchased Professional & Technical Services (0300)
 |  | Other Purchased Services (0500)
 |  | Subtotal Support Program
 |  | Total Budget
 |  | Typed Name of Person Preparing Report                 Date |  |  |  | Signature of School District Authorized Representative*
 |  | *Check with your school district budget office for the signature of the school district authorized representative.
Spreadsheet: 791392d1660320300-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: Jan

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
5000 | Income |  | 175 | Fuel |  |  |  |  | 40000 |  |  |  |  | Payments
 |  |  | 300 | Cell
 |  |  | 250 | Cable
Spreadsheet: 45944d1244723678-summing-up-opposite-numbers-in-a-column-based-on-criteria-book1_jun11
Sheet: Sheet1

Acct # | Amount | Reconciled Amt
123 | 400
123 | -400
234 | 800
579 | 200 | 200
457 | 900 | 900
579 | -100 | -100
705 | 1255 | 1255
234 | -800
457 | 985 | 985
579 | 300 | 300
990 | 600 | 600
457 | -800 | -800
900 | 700
457 | 300 | 300
900 | -700
123 | 400 | 400
123 | 315 | 315
Spreadsheet: 687046d1594925601-countifs-for-unique-data-book1v2
Sheet: Sheet1

 |  |  |  |  | Example 1
 | Client | Date | Won/Lost |  |  |  | Total Distinct Clients | New Unique Clients |  |  | Comment
 | [NAME] | 2020-04-15 00:00:00 | Won |  | 2020-05-01 00:00:00 | To End of April |  |  |  |  | 3 clients, all unique
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of May |  |  |  |  | 8 deals but [NAME] and [NAME] each had 2 deals so 6 DISTINCT. From April, [NAME] and [NAME] are new
 | [NAME] | 2020-04-30 00:00:00 | Won |  |  | To End of June |  |  |  |  | 7 discint clients, [NAME] was new
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-10 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-05-30 00:00:00 | Won
 | [NAME] | 2020-06-10 00:00:00 | Won |  |  |  | To the extend helpful, these were my formulas
 | [NAME] | 2020-06-15 00:00:00 | Won |  |  |  | Array for total distinct | Arrow for unique
 | [NAME] | 2020-06-30 00:00:00 | Won |  |  |  |  |  |  |  | 7 distinct, only unique clients are [NAME] and [NAME]
 | [NAME] | 2020-06-30 00:00:00 | Won
 | [NAME] | 2020-06-30 00:00:00 | Lost
 |  |  |  |  | Example 2
 |  |  |  |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-05-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-06-01 00:00:00
 |  |  |  |  | 2020-04-01 00:00:00 | 2020-07-01 00:00:00 |  |  |  |  | Should be 6 distinct clients since we didn't win [NAME]
 |  |  | This is really final product |  | From Date | To Date | Total Distinct Clients (Won) | New Unique Clients (Won)
 |  |  |  |  | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 |  |  |  |  | Question I'm trying to answer is how many clients did we do business with in a given month and how many of them have we never done business with before? Here, it's 4 clients we've done business with ([NAME], [NAME], [NAME], [NAME]) but [NAME] is a repeat client
 |  |  |  |  | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 |  | 0 |  |  | same thing here, should only be 3 distinct clients because we lost the trade with [NAME]. No unique clients from start
Spreadsheet: 775088d1648819445-look-values-in-two-column-and-extract-a-value-by-rows-meeting-if-condition-chking
Sheet: Sheet1

ID | ID2 | Fin ID | expected RESULT
12641966 | 12641966
 | 12658447
12636556 | 12636556
12645418
12658447 | 12658448 |  | 12658448
 | 12641967
 | 12636378
 | 12651444
12646762 | 12646762
 | 12662694
12662508 | 12662508
12664227 | 12664227
12662168 | 12662168
12662694 | 12662695 |  | 12662695
 | 12662509
12593473 | 12593473
12657528 | 12657528
 | 12649503
 | 12651914
 | 12653114
12651914 | 12651915 |  | 12651915
 | 12651825
 | 12664229
 | 12662511
Spreadsheet: 771613d1646756978-how-will-index-match-work-with-name-range-over-12-sheets-or-with-a-vba-test-greatinfoteam-
Sheet: AllMonthsTable

Style No. | Unit Price | Name
WTB181693 | 51 | JanTable
WTB371652 | 59.1 | JanTable
WTB371652 | 59.1 | JanTable
WTC181281 | 213 | JanTable
WTC181275 | 41.75 | JanTable
WTC181304 | 64.6 | JanTable
WTC181275 | 41.75 | JanTable
[NAME] | 38.5 | JanTable
WTB371647 | 64 | JanTable
WTC181313 | 87.5 | JanTable
WTC181313 | 87.5 | JanTable
WTC181313 | 87.5 | JanTable
WTB181693 | 51 | JanTable
WTC181281 | 213 | JanTable
WTC181304 | 64.6 | JanTable
[NAME] | 38.5 | JanTable
WTC181260 | 50.5 | JanTable
WTC181260 | 50.5 | JanTable
WTC181297 | 32.5 | JanTable
WTC181297 | 32.5 | JanTable
WTE181121 | 88.9 | JanTable
WTE181121 | 88.9 | JanTable
WTB181678 | 40 | JanTable
WTB181678 | 40 | JanTable
WTE181103 | 302 | FebTable
WTE181103 | 302 | FebTable
WTB181657 | 18 | FebTable
WTB181657 | 18 | FebTable
WTB181658 | 16 | FebTable
WTE181123 | 57 | FebTable
WTC181314 | 47.2 | FebTable
WTC181314 | 47.2 | FebTable
WTC181245 | 20.25 | FebTable
WTC181245 | 20.25 | FebTable
WTB181659 | 43.5 | FebTable
WTB181659 | 43.5 | FebTable
WTB181602 | 31.2 | FebTable
WTB181602 | 31.2 | FebTable
WTC181292 | 39 | FebTable
WTC181292 | 39 | FebTable
WTC181311 | 41 | FebTable
WTC181311 | 41 | FebTable
WTC181287 | 46.2 | FebTable
WTC181287 | 46.2 | FebTable
WTB181715 | 165 | FebTable
WTB181715 | 165 | FebTable
WTB181723 | 58.4 | FebTable
WTB181723 | 58.4 | FebTable
[NAME] | 85.6 | FebTable
[NAME] | 85.6 | FebTable
Spreadsheet: 24e11c5d-4d1e-45de-8cc6-2e34257ac42a
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
 | 8731.0 Building Approvals, Australia
 | TABLE 37. Value of Building Approved - Australian Capital Territory
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
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A420494A | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420503T | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420515A | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | A421178T | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  Australian Capital Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422865L | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 781438d1653324420-help-needed-create-a-schedule-for-20-agents-that-complies-with-the-staffing-requirement-book1
Sheet: Requirement

Stafing Requirement
Interval | Mon | Tue | Wed | Thu | Fri | Sat | Sun |  |  |  | 10:00-19:00
08:00 | 10 | 8 | 10 | 13 | 10 | 7 | 5
08:30 | 12 | 11 | 10 | 12 | 12 | 9 | 6
09:00 | 11 | 10 | 10 | 12 | 13 | 9 | 6 |  |  |  | 09:00-18:00
09:30 | 13 | 12 | 11 | 13 | 12 | 9 | 8
10:00 | 14 | 12 | 11 | 14 | 12 | 10 | 8
10:30 | 14 | 13 | 13 | 13 | 13 | 11 | 9
11:00 | 15 | 16 | 13 | 14 | 14 | 12 | 8
11:30 | 15 | 15 | 13 | 14 | 15 | 13 | 9
12:00 | 16 | 14 | 15 | 14 | 15 | 12 | 8
12:30 | 16 | 15 | 15 | 13 | 15 | 12 | 10
13:00 | 16 | 15 | 14 | 13 | 14 | 13 | 10
13:30 | 15 | 16 | 15 | 14 | 16 | 13 | 10
14:00 | 15 | 15 | 15 | 13 | 15 | 12 | 9
14:30 | 15 | 15 | 15 | 14 | 15 | 11 | 9
15:00 | 17 | 15 | 15 | 15 | 16 | 11 | 9
15:30 | 18 | 16 | 16 | 15 | 15 | 11 | 9
16:00 | 15 | 14 | 16 | 14 | 16 | 11 | 9
16:30 | 18 | 15 | 15 | 14 | 14 | 11 | 8
17:00 | 17 | 17 | 16 | 13 | 16 | 11 | 9
17:30 | 16 | 15 | 15 | 14 | 15 | 11 | 9
18:00 | 16 | 14 | 14 | 13 | 15 | 9 | 9
18:30 | 15 | 13 | 14 | 12 | 13 | 9 | 8
19:00 | 14 | 13 | 14 | 11 | 13 | 9 | 7
19:30 | 13 | 13 | 13 | 11 | 11 | 8 | 8
20:00 | 11 | 11 | 12 | 11 | 10 | 11 | 11
20:30 | 11 | 10 | 9 | 11 | 9 | 10 | 10
21:00 | 9 | 8 | 8 | 9 | 8 | 8 | 8
21:30 | 8 | 6 | 7 | 7 | 6 | 7 | 7