tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 186924d1350300000-data-validation-searching-problem-in-and-out-details
Sheet: Receiving

RS | Date | Customer Name | Qty | Container # | Pallets | Pro Date | [NAME] | RCR #
833 | 2012-10-13 00:00:00 | CUTTLE FISH 1/2-OCEAN | 54 | 55765 AJM | 2 |  | 2013-10-08 00:00:00
833 | 2012-10-13 00:00:00 | CUTTLE FISH 3UP-OCEAN | 121 | 55765 AJM | 3 |  | 2012-10-06 00:00:00
830 | 2012-10-14 00:00:00 | RIB FISH H/L 5/7-10KG-OCEAN | 149 | 55765 AJM | 3 |  | 2013-10-09 00:00:00
830 | 2012-10-14 00:00:00 | RIB FISH H/L 1000UP-10KG-OCEAN | 62 | 55765 AJM | 1 |  | 2013-10-09 00:00:00
830 | 2012-10-14 00:00:00 | RIB FISH H/L 7/10-10KG-OCEAN | 165 | 55765 AJM | 3 |  | 2013-10-09 00:00:00
834 | 2012-10-14 00:00:00 | CUTTLE FISH 2/3 - OCEAN | 64 | 55765 AJM | 2 | 2012-10-04 00:00:00 | 2013-10-03 00:00:00
834 | 2012-10-14 00:00:00 | CUTTLE FISH 1/2-OCEAN | 111 | 55765 AJM | 3 | 2012-10-04 00:00:00 | 2013-10-03 00:00:00
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: OOC Admin

 | Office of the Chair Administration
 | 2002 Plan
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  |  |  |  | Per HC | New HC | Adj Comp |  | 2002
 |  | YTD Actual |  | Annualized | Plan |  |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation
 | Special Pays | 0 |  |  | 0 |  |  |  | Compensation | 0
 | Analyst & Assoicate | 0 |  |  | 0
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense |  |  |  |  |  |  |  | Other
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services | 0 |  |  |  |  |  |  | Total
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions |  |  |  | 0
ENARENT | Rent |  |  |  |  |  |  |  | [NAME] | 55000 | 3
ENATECH | Technology |  |  |  |  |  |  |  | COO | 250000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | CEO | 250000 | 0
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 5 |  |  |  | Other Expense Calculation
 | A&A Headcount |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667
 | Other Expenses | 243106037
Spreadsheet: 707891d1607525718-how-to-assign-a-country-to-a-specific-area-dashboard-aligw
Sheet: BRAZIL

Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  lowest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Top 5  highest price | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Antenna cable | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | [NAME] | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Charger | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Recheargable battery | AB | MedEL | Cochlear | OM | Custom label
Country | Category of item | Brands | Name of item | Reference N of the item | End user price in local currency after VAT | GNI per capita | Bundled | End user price in EUR after VAT |  | Full swim kit | AB | MedEL | Cochlear | OM | Custom label
Spreadsheet: 9bc999bf-94bc-4de1-8e6f-e5e549416f20
Sheet: Sheet1

Date | Sport | Opponent | Time_Results
09/04/2011 | Football | [NAME] | W, 34-13
09/10/2011 | Football | Norfolk State | W, 55-12
[NAME] | Football | at Maryland | W, 37-31
09/24/2011 | Football | LSU | L, 21-47
10/01/2011 | Football | Bowling Green (Homecoming) | W, 55-10
10/08/2011 | Football | Connecticut | W, 43-16
10/21/2011 | Football | at Syracuse | L, 23-49
10/29/2011 | Football | at Rutgers | W, 41-31
11/05/2011 | Football | Louisville | L, 35-38
11/12/2011 | Football | at Cincinnati | W, 24-21
11/25/2011 | Football | Pitt | W, 21-20
12/01/2011 | Football | at USF | W, 30-27
01/04/2012 | Football | vs. [NAME] | W, 70-33
Spreadsheet: 762932d1641910845-cond-formatting-first-monday-on-the-month-sddo-vacation-tracker-2023
Sheet: Feb

Formation /Training
Congés / Leaves | V
Congés fériés / GC holidays
Fin de semaine / Weekend
T:  Tentative | T
Compressed Day / Journée comprimée
Assignment / Left
Half Day / Demie Journée
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
February | Dates of Leave |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Vacation
Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | Replaced by:
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
(Vacant CS-03)
[NAME]
[NAME]
[NAME]
(Vacant team lead)
(Vacant CS-03)
Sameer [NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
FebruaryTotal
Spreadsheet: 166054d1341443011-difference-of-2-cells-need-to-show-zero-when-cells-in-columns-a-are-not-pupulated-testexcel
Sheet: Sheet1

Received/Pending | Issued | Days
2011-12-02 00:00:00 | 2010-06-02 00:00:00
 | 2010-06-04 00:00:00
2012-04-01 00:00:00 | 2011-03-23 00:00:00
2010-07-01 00:00:00 | 2009-09-21 00:00:00
 | 2011-01-01 00:00:00
2011-12-02 00:00:00 | 2010-11-01 00:00:00
 | 2010-09-05 00:00:00
2012-04-01 00:00:00 | 2011-06-04 00:00:00
2010-07-01 00:00:00 | 2009-08-03 00:00:00
 | 2012-02-01 00:00:00
2011-12-02 00:00:00 | 2010-06-02 00:00:00
2011-01-04 00:00:00 | 2010-06-04 00:00:00
 | 2011-03-23 00:00:00
2010-07-01 00:00:00 | 2009-09-21 00:00:00
 | 2011-01-01 00:00:00
2011-12-02 00:00:00 | 2010-11-01 00:00:00
 | 2010-09-05 00:00:00
2012-04-01 00:00:00 | 2011-06-04 00:00:00
2010-07-01 00:00:00 | 2009-08-03 00:00:00
 | 2012-02-01 00:00:00
Spreadsheet: 122739d1317124678-excel-2007-lookup-find-next-need-help-help
Sheet: CIS & Eastern Europe

projects/cost centers |  |  | land | region | employee | sales project hours
1401037 - Navoi Airport BHS | 1401037 | UZ | Uzbekistan | CIS | 3633 - Hu, J. | 3
1401038 - Manas Airport BHS | 1401038 | KG | Kyrgyzstan | CIS | 3953 - Kessels, M.C. | 23
1401038 - Manas Airport BHS | 1401038 | KG | Kyrgyzstan | CIS | 5126 - IJntema, R.E.C. | 1
1471027 - Tashkent Domestic Terminal | 1471027 | UZ | Uzbekistan | CIS | 3633 - Hu, J. | 37
1471027 - Tashkent Domestic Terminal | 1471027 | UZ | Uzbekistan | CIS | 3713 - Visser- Jans, K. | 2.5
1471027 - Tashkent Domestic Terminal | 1471027 | UZ | Uzbekistan | CIS | 4246 - Cappendijk, E. | 18
1471051 - BRS Belgrado AP | 1471051 | RS | Serbia and Montenegro | Eastern Europe | 5126 - IJntema, R.E.C. | 2
1471080 - Morava AP | 1471080 | RS | Serbia and Montenegro | Eastern Europe | 4448 - Hogeboom, M.B. | 9
1471093 - SAC Replacement T2 | 1471093 | CZ | Czech Republic | Eastern Europe | 988 - Platschorre, S. | 28
1471093 - SAC Replacement T2 | 1471093 | CZ | Czech Republic | Eastern Europe | 5126 - IJntema, R.E.C. | 1
1471094 - BRS Prague Airport | 1471094 | CZ | Czech Republic | Eastern Europe | 988 - Platschorre, S. | 32
1471094 - BRS Prague Airport | 1471094 | CZ | Czech Republic | Eastern Europe | 5126 - IJntema, R.E.C. | 2
1471101 - Bucharest coanda Phase3 | 1471101 | RO | Romania | Eastern Europe | 3446 - Wang, H. | 69.5
1471101 - Bucharest coanda Phase3 | 1471101 | RO | Romania | Eastern Europe | 3520 - Rooij, B.W. de | 72
1471101 - Bucharest coanda Phase3 | 1471101 | RO | Romania | Eastern Europe | 3713 - Visser- Jans, K. | 1.75
Spreadsheet: 25d7a505-4a20-4c7f-b998-2863d2cfce1b
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 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number, $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
1 . . . [NAME] ; |  |  | Original | A2413895X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: 780610d1652611794-infill-blank-rows-in-a-list-title-sample
Sheet: Sheet1

What I have | What I need | Result
Title 1 | Title 1
 | Title 1
 | Title 1
 | Title 1
Title 2 | Title 2
 | Title 2
 | Title 2
 | Title 2
 | Title 2
Title 3 | Title 3
Title 4 | Title 4
 | Title 4
 | Title 4
 | Title 4
 | Title 4
Title 5 | Title 5
Spreadsheet: 814076d1674142787-formula-to-add-numbers-in-a-table-based-on-date-criteria-loan-amortization-schedules
Sheet: #46

#46 Hitachi Capital America Corp - 2018 Chevrolet Silverado 2500 HD
Loan Amount: |  | 41606 |  | Number of Payments: | 60
Annual Interest Rate: |  | 0.0495 |  | Periodic Payment: | 784.2
Loan Date: |  | 2018-03-20 00:00:00 |  | 1st Payment Due: | 2018-04-20 00:00:00
Payment Frequency: |  | Monthly |  | Last Payment Due: | 2026-02-28 00:00:00
Total Interest Due: |  |  |  | Total All Payments:
Payment Schedule
Pmt # | Date | Payment | Principal | Interest | Balance | End of Month | Year | YTD Interest
1
2 | 2018-05-20 00:00:00
3 | 2018-06-20 00:00:00
4 | 2018-07-20 00:00:00
5 | 2018-08-20 00:00:00
6 | 2018-09-20 00:00:00
7 | 2018-10-20 00:00:00
8 | 2018-11-20 00:00:00
9 | 2018-12-20 00:00:00
10 | 2019-01-20 00:00:00
11 | 2019-02-20 00:00:00
12 | 2019-03-20 00:00:00
13 | 2019-04-20 00:00:00
14 | 2019-05-20 00:00:00
15 | 2019-06-20 00:00:00
16 | 2019-07-20 00:00:00
17 | 2019-08-20 00:00:00
18 | 2019-09-20 00:00:00
19 | 2019-10-20 00:00:00
20 | 2019-11-20 00:00:00
21 | 2019-12-20 00:00:00
22 | 2020-01-20 00:00:00
23 | 2020-02-20 00:00:00
24 | 2020-03-20 00:00:00
25 | 2020-04-20 00:00:00
26 | 2020-05-20 00:00:00
27 | 2020-06-20 00:00:00
28 | 2020-07-20 00:00:00
29 | 2020-08-20 00:00:00
30 | 2020-09-20 00:00:00
31 | 2020-10-20 00:00:00
32 | 2020-11-20 00:00:00
33 | 2020-12-20 00:00:00
34 | 2021-01-20 00:00:00
35 | 2021-02-20 00:00:00
36 | 2021-03-20 00:00:00
37 | 2021-04-20 00:00:00
38 | 2021-05-20 00:00:00
39 | 2021-06-20 00:00:00
40 | 2021-07-20 00:00:00
41 | 2021-08-20 00:00:00
42 | 2021-09-20 00:00:00
43 | 2021-10-20 00:00:00
44 | 2021-11-20 00:00:00
45 | 2021-12-20 00:00:00
46 | 2022-01-20 00:00:00
47 | 2022-02-20 00:00:00
48 | 2022-03-20 00:00:00
49 | 2022-04-20 00:00:00
50 | 2022-05-20 00:00:00
51 | 2022-06-20 00:00:00
52 | 2022-07-20 00:00:00
53 | 2022-08-20 00:00:00
54 | 2022-09-20 00:00:00
55 | 2022-10-20 00:00:00
56 | 2022-11-20 00:00:00
57 | 2022-12-20 00:00:00
58 | 2023-01-20 00:00:00
59 | 2023-02-20 00:00:00
60 | 2023-03-20 00:00:00
Spreadsheet: 45999d1244769235-print-save-to-pdf-formating-locations-change-office-of-land-and-fire-template
Sheet: Global

Business Areas | Metric Areas | Postion | Type | Status | Graph | Month | Existing Months
Program | Financial | 1 | Table | Red | Column | Jan
People | Service Delivery | 2 | Descriptive | Yellow | Line | Feb
Stakeholders | Reputation | 3 |  | Green | [NAME] | Mar
 |  | 4 |  |  | Pie | Apr
 |  |  |  |  | Bar | May
 |  |  |  |  |  | Jun
 |  |  |  |  |  | Jul
 |  |  |  |  |  | Aug
 |  |  |  |  |  | Sep
 |  |  |  |  |  | Oct
 |  |  |  |  |  | Nov
 |  |  |  |  |  | Dec
Spreadsheet: 104185d1301840715-keep-raw-of-maximum-value-keep-maximum-value
Sheet: Sheet1

shipper | Responsible | Value | MaxMatch | Keep/Delete
4 YOU CLOTHING LTD | Hossain, [NAME] | 1
786 GARMENTS & TEXTILES | [NAME], [NAME] | 1
A & A TROUSERS LTD | [NAME], [NAME] | 1
A G DRESSES LTD | Zahir, [NAME] | 1
A J SUPER GARMENTS LTD | [NAME], Binoy Krishna | 2
A K M KNITWEAR LTD | [NAME], [NAME] | 3
A M DESIGN LTD | [NAME], [NAME] | 2
A PLUS INDUSTRIES LTD | Barman, Nilmani | 1
A T S APPARELS LTD | [NAME], [NAME] | 2
A K M KNITWEAR LTD | Hossain, [NAME] | 1
A M DESIGN LTD | Barman, Nilmani | 1
A T S APPARELS LTD | Awal, [NAME] | 1
A T S APPARELS LTD | Zahir, [NAME] | 1
Spreadsheet: 136986d1326902402-rank-results-only-when-they-meet-certain-criteria-example-workbook
Sheet: Sheet1

INPUT
Products | Costs year | Product applicable to nr of orders
A | 10000 | 1 - 500
B | 11000 | 500 - 5000
C | 10500 | 500 - 5000
D | 13000 | 500 - 5000
E | 15500 | > 5001
F | 10000 | > 5001
Nr of orders | [calculated]
OUTPUT
if the nr of orders is more than 500, then rank the products (the lowest costs first), without product A.
So this is the expected outcome:
F
C
B
D
E
Same for if the nr of order is more than 5000: then only show E and F:
Expected outcome:
F
E
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: PHIL

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
3 | PHIL 101 | 1 | X | 1 | X | 1 | X | 1 | X | 1
1 | PHIL 103 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
3 | PHIL 105 | 1 | X | 1 | X | 1 | X | 1 | X | 1
3 | PHIL 105H | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 881811d1730010103-how-to-have-return-results-of-a-function-split-across-multiple-lines-jeff-12345-testfile-3-spill-365-aligw
Sheet: Misc Stats

Customer Agents
Client-1 | Client-2 | Client-3 | [NAME] | HidFAST | CSMI | Doble | Leemco | Ganesh Imports | AllenTech
AGT-2 | AGT-2 | AGT5
AGT-3 | AGT6
AGT-4
Spreadsheet: 647701d1572572579-vlookup-or-formula-to-return-a-number-related-to-a-word-that-is-typed-into-a-cell-tennispq11
Sheet: Tennis Data

Hard |  | Name | Age | Wins | Matches | Lost | Surface Win % | Best Surface | Best Surface Win % | Prize Money
[NAME] |  | [NAME] | 28 | 519 | 789 | 270 | 0.6552 | Clay | 0.6816 | 12741033
[NAME] |  | [NAME] | 28 | 453 | 726 | 273 | 0.6343 | Hard | 0.6343 | 16661749
Spreadsheet: 703683d1605112186-lookup-new-cell-content-listab
Sheet: Sheet1

What I have |  |  |  |  | What I want
[NAME] | ListB |  |  |  | [NAME] | ListB
Ax | Ax |  |  |  | Ax | Ax
Bx | Bx |  |  |  | Bx | Bx
Cx | Cx |  |  |  | Cx | Cx
Dx |  |  |  |  | Dx | Dx
Spreadsheet: 77386d1277865077-entering-either-dropdown-list-will-enter-the-correct-value-in-the-other-matchvlookups
Sheet: Tags

Birds
[NAME] | Scientific Name | Common drop down | Scientific drop down
Australian King Parrot | Alisterus scapularis
Australian Pelican | Pelecanus conspicillatus
Australian Raven | Corvus coronoides | Scientific name | Common name
Australian Wood Duck | Chenonetta jubata
Australian Magpie | [NAME] tibicen
Bar-tailed Godwit | Limosa lapponica
Black Swan | Cygnus atratus
Black-eared Cuckoo | Chrysococcyx osculans
Black-shouldered Kite | Elanus axillaris
[NAME] Stone-curlew | Burhinus grallarius
Cape [NAME] | Cereopsis novaehollandiae
Channel-billed Cuckoo | Scythrops novaehollandiae
[NAME] | Anas castanea
[NAME] | Turdus merula
[NAME] | Acridotheres tristis
[NAME] | Sturnus vulgaris
Crested Pigeon | Ocyphaps lophotes
[NAME] | Platycercus elegans
Dusky Moorhen | Gallinula tenebrosa
Eastern Spinebill | Acanthorhynchus tenuirostris
Eastern [NAME] | Eopsaltria australis
Eurasian Coot | [NAME] atra
Fan-tailed Cuckoo | Cacomantis flabelliformis
Flame [NAME] | Petroica phoenicea
[NAME] | Cacatua roseicapilla
[NAME] | Callocephalon fimbriatum
[NAME] | Pachycephala pectoralis
Great Cormorant | Phalacrocorax carbo
[NAME] | [NAME] torquatus
Grey fantail | Rhipidura fuliginosa
Grey Teal | Anas gracilis
[NAME]'s Bronze-Cuckoo | [NAME] basalis
House Sparrow | Passer domesticus
Laughing Kookaburra | [NAME] novaeguineae
Little Pied Cormorant | Phalacrocorax melanoleucos
Little Wattlebird | Anthochaera chrysoptera
Magpie-lark | Grallina cyanoleuca
Masked Lapwing | Vanellus miles
[NAME] | Biziura lobata
New Holland Honeyeater | Phylidonyris novaehollandiae
Noisy Miner | [NAME] melanocephala
Pacific Black Duck | Anas superciliosa
[NAME] | Cuculus pallidus
Pied Cormorant | Phalacrocorax varius
Pied [NAME] | Strepera graculina
Pigeon | Columba livia
[NAME] | Porphyrio porphyrio
[NAME] | Merops ornatus
Rainbow Lorikeet | Trichoglossus haematodus
Red Wattlebird | Anthochaera carunculata
Red-browed Finch | Neochmia temporalis
Rufous Whistler | Pachycephala rufiventris
Seagull | Larus novaehollandiae
Shining Bronze-cuckoo | [NAME] lucidus
Silvereye | Zosterops lateralis
Spotted Pardalote | Pardalotus punctatus
Spotted Turtle-Dove | Streptopelia chinensis
Straw-necked Ibis | Threskiornis spinicollis
Sulphur-crested Cockatoo | Cacatua galerita
[NAME] | Malurus cyaneus
[NAME] | Menura novaehollandiae
Wedge-tailed Eagle | [NAME] audax
Welcome Swallow | Hirundo neoxena
[NAME] | Rhipidura leucophrys
Yellow-faced Honeyeater | Lichenostomus chrysops
Yellow-tailed Black-Cockatoo | Calyptorhynchus funereus
Spreadsheet: phillip_m_love__30637__storage 9912&0001
Sheet: 9912

 |  |  |  | Storage Reconciliation - 9912
Facility | 9912 GL |  | 0001 GL |  | 0002 GL |  | 0003 GL |  | 0004 GL |  | Total
 | Volume | $ | Volume | $ | Volume | $ | Volume | $ | Volume | $ | Volume | $
[NAME] |  |  | -5850267 |  |  | 0 | -10228 | -23641.3 | -3832
Centana Co 016 | -63000 | -136177.83 |  |  |  | 0 |  | 0 |  | 0
CILCO  Co 016 |  |  | -518976 | -2337060 |  |  | 14060 | 63312.18
Enron Gas Mktg. Liquidations |  |  |  |  |  |  |  |  |  | 2311
Total
* Inventory profit of $(847,572) added ti 0004 GL column
Spreadsheet: 776523d1649772499-detecting-duplicate-and-assigning-unique-id-test-d
Sheet: Expected Result

 | SN | Data | ID
 | 65 | 2022-03-10 00:00:00 | 65
 | 65 | 2022-03-10 00:00:00 | 65 |  |  | 65
 | 65 | 2022-03-10 00:00:00 | 65 |  |  | 65
 | 36 | 2022-03-12 00:00:00 | 36 |  |  | 36
 | 65 | 2022-03-30 00:00:00 | 65-D1 |  |  | 65-D1
 | 65 | 2022-03-30 00:00:00 | 65-D1 |  |  | 65-D1
 | 49 | 2022-04-02 00:00:00 | 49 |  |  | 49
 | 49 | 2022-04-04 00:00:00 | 49-D1 |  |  | 49-D1
 | 65 | 2022-04-09 00:00:00 | 65-D2 |  |  | 65-D2
Spreadsheet: 734850d1622547491-need-to-get-quarter-wise-value-specific-cost-example123
Sheet: Sheet1

Service PO | PO Validity Start | PO Validity End | PO value (USD) | PO Month | AMJ'21 | JAS'21 | OND'21 | [NAME]
93455444 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 | 2879.3289
454444343 | 2020-02-06 00:00:00 | 2020-02-06 00:00:00 | 9671.56800364959
44444444 | 2020-07-01 00:00:00 | 2020-12-31 00:00:00 | 13781.98807401486
55454545 | 2020-08-26 00:00:00 | 2020-08-26 00:00:00 | 11855
345555444 | 2020-10-01 00:00:00 | 2020-12-31 00:00:00 | 5200.467203540903
77666666 | 2019-08-13 00:00:00 | 2019-08-13 00:00:00 | 31814.2872
23434343 | 2019-08-11 00:00:00 | 2019-08-11 00:00:00 | 32615.72508760061
Spreadsheet: 723359d1615649956-conditional-formatting-and-color-cells-with-formula-testnameamount-5-
Sheet: Blad1

project | datum | nr vlist | nr defensie | vertrek | tijd | aankomst | aantal | wie NL | wie D | inkoop NL | inkoop D | verkoop NL | verkoop D
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 | nl |  |  |  |  |  |  | uren inkoop |  |  | km inkoop
5154 | 2021-03-18 00:00:00 | 20404500 | 17NLD102 | Loheide | 22:00:00 | de lutte | 1 |  | nl |  |  |  |  |  | [NAME] |  |  | km verkoop
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | ik | ics |  |  |  |  |  | [NAME] |  |  | [NAME]
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 | nl | ics
5155 | 2021-03-18 00:00:00 | 20404757 | 18NLD104 | amersfoort | 20:00:00 | Loheide | 2 |  | ics |  |  |  |  |  | Inkoop NL |  |  | Inkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verkoop D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast |  |  |  |  |  | [NAME] |  |  | Verschil D
5156 | 2021-03-18 00:00:00 | 20404797 | 18NLD103 | Loheide | 22:30:00 | de lutte | 1 |  | ast
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal inkoop |  |  | proj nl in
5157 | 2021-03-18 00:00:00 | 20404793 | 17NLD105 | Loheide | 22:45:00 | de lutte | 1 |  | nl |  |  |  |  |  | Totaal verkoop |  |  | proj nl ver
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  | totaal [NAME] |  |  | [NAME] in
5158 | 2021-03-18 00:00:00 | 20404798 | 17NLD107 | Loheide | 23:30:00 | de lutte | 1 |  | nl |  |  |  |  |  |  |  |  | [NAME] ver
5159 | 2021-03-19 00:00:00 | 20404799 | 17NLD108 | Loheide | 00:00:00 | darp | 2 | rene | rene
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | projrct [NAME] |  | project [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | search code | aantal beg | inkoop NL | inkoop D | verkoop NL | verkoop D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5155
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | per begeleider
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | customer | amount
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | nl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ik
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | willem
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hilco
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ast
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ics
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | rene