tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 798335d1664431724-list-rows-with-unique-values-in-column-a-that-has-highest-values-in-column-b-_1
Sheet: Sheet2

Sample Data
Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 |  | Column1 | [NAME] | [NAME] | Table1.Column4 | Table1.Column5 | Table1.Column6 | [NAME] | [NAME] | Table1.Column9 | [NAME]
38203 | 1 | UND 1 | UND 2 | UND 3 | UND 4 | UND 5 | UND 6 | UND 7 | UND 8 |  | 38203 | 2 | UND 9 | UND 10 | UND 11 | UND 12 | UND 13 | UND 14 | UND 15 | UND 16
38203 | 2 | UND 9 | UND 10 | UND 11 | UND 12 | UND 13 | UND 14 | UND 15 | UND 16 |  | 42189 | 1 | UND 17 | UND 18 | UND 19 | UND 20 | UND 21 | UND 22 | UND 23 | UND 24
42189 | 1 | UND 17 | UND 18 | UND 19 | UND 20 | UND 21 | UND 22 | UND 23 | UND 24 |  | 43869 | 1 | UND 25 | UND 26 | UND 27 | UND 28 | UND 29 | UND 30 | UND 31 | UND 32
43869 | 1 | UND 25 | UND 26 | UND 27 | UND 28 | UND 29 | UND 30 | UND 31 | UND 32 |  | 45489 | 2 | UND 41 | UND 42 | UND 43 | UND 44 | UND 45 | UND 46 | UND 47 | UND 48
45489 | 1 | UND 33 | UND 34 | UND 35 | UND 36 | UND 37 | UND 38 | UND 39 | UND 40 |  | 45580 | 2 | UND 57 | UND 58 | UND 59 | UND 60 | UND 61 | UND 62 | UND 63 | UND 64
45489 | 2 | UND 41 | UND 42 | UND 43 | UND 44 | UND 45 | UND 46 | UND 47 | UND 48 |  | 45822 | 3 | UND 81 | UND 82 | UND 83 | UND 84 | UND 85 | UND 86 | UND 87 | UND 88
45580 | 1 | UND 49 | UND 50 | UND 51 | UND 52 | UND 53 | UND 54 | UND 55 | UND 56 |  | 46383 | 1 | UND 89 | UND 90 | UND 91 | UND 92 | UND 93 | UND 94 | UND 95 | UND 96
45580 | 2 | UND 57 | UND 58 | UND 59 | UND 60 | UND 61 | UND 62 | UND 63 | UND 64 |  | 46456 | 2 | UND 105 | UND 106 | UND 107 | UND 108 | UND 109 | UND 110 | UND 111 | UND 112
45822 | 1 | UND 65 | UND 66 | UND 67 | UND 68 | UND 69 | UND 70 | UND 71 | UND 72
45822 | 2 | UND 73 | UND 74 | UND 75 | UND 76 | UND 77 | UND 78 | UND 79 | UND 80
45822 | 3 | UND 81 | UND 82 | UND 83 | UND 84 | UND 85 | UND 86 | UND 87 | UND 88
46383 | 1 | UND 89 | UND 90 | UND 91 | UND 92 | UND 93 | UND 94 | UND 95 | UND 96
46456 | 1 | UND 97 | UND 98 | UND 99 | UND 100 | UND 101 | UND 102 | UND 103 | UND 104
46456 | 2 | UND 105 | UND 106 | UND 107 | UND 108 | UND 109 | UND 110 | UND 111 | UND 112
Expected Result
38203 | 2 | UND 9 | UND 10 | UND 11 | UND 12 | UND 13 | UND 14 | UND 15 | UND 16
42189 | 1 | UND 17 | UND 18 | UND 19 | UND 20 | UND 21 | UND 22 | UND 23 | UND 24
43869 | 1 | UND 25 | UND 26 | UND 27 | UND 28 | UND 29 | UND 30 | UND 31 | UND 32
45489 | 2 | UND 41 | UND 42 | UND 43 | UND 44 | UND 45 | UND 46 | UND 47 | UND 48
45580 | 2 | UND 57 | UND 58 | UND 59 | UND 60 | UND 61 | UND 62 | UND 63 | UND 64
45822 | 3 | UND 81 | UND 82 | UND 83 | UND 84 | UND 85 | UND 86 | UND 87 | UND 88
46383 | 1 | UND 89 | UND 90 | UND 91 | UND 92 | UND 93 | UND 94 | UND 95 | UND 96
46456 | 2 | UND 105 | UND 106 | UND 107 | UND 108 | UND 109 | UND 110 | UND 111 | UND 112
Spreadsheet: phillip_m_love__30144__200004_OA
Sheet: ONT_FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ALL
REGION:  ONTARIO
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 32520766 | 98714257.87
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 3012634 | 9318343
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 35533400 | 108032600.87
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -34733795 | -105084377
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -797157 | -2479970
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | 0
 | Total Purchases: |  | -35530952 | -107564347
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 0 | 0
12 |  | Purchases | 0 | 0
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 3925 | 12717
 |  |  | 0 | 0
23 | Fuel: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -5115.83
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -5115.83
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | -287595.4771017097
31 |  | Prior Month Book Balance | 0 | -115487
 |  | Total MTM Income | 0 | -403082.4771017097
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 74043
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 0
 |  | TOTAL INTRA-MTH
FT-Ontario
 |  | Current Month MTM | 0 | 446797
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: errol_mclaughlin_jr__10140__risk option review
Sheet: Sheet1

[NAME] Id | Time | Customer | Commodity Group | Product Type | Product | Buy Volume | Sell Volume | Option Delta | Units | Currency | Price | Ext User Id | Int User Id | Risk Book | Enron Entity | Bridge | Deal ID | Begin Date | End Date
132456 | 2001-01-04 18:17:11 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas FIN Swap | US Gas Daily     Nymex NL1               May01           USD/MM |  | 5330000 |  | MMBtu | United States Dollar | 5.37 | DKENNE | DKENNE | GD-CENTRAL | Enron North America Corp. | TAGG | Q28344.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132455 | 2001-01-04 18:17:11 | Beau Canada Exploration Ltd. | Natural Gas | US Gas FIN Call Option | US Gas Fin Opt   NYMEX        EC5.4      May01           USD/MM-L |  | 10000 |  | MMBtu/Lots | United States Dollar | 0.529 | ADM74235 | DKENNE | NG-Price | Enron North America Corp. | TAGG | Q28343.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132458 | 2001-01-04 18:17:16 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas FIN Swap | US Gas Daily     Nymex NL1               May01           USD/MM | 4437500 |  |  | MMBtu | United States Dollar | 5.34 | DKENNE | DKENNE | GD-CENTRAL | Enron North America Corp. | TAGG | Q28346.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132457 | 2001-01-04 18:17:16 | Beau Canada Exploration Ltd. | Natural Gas | US Gas FIN Put Option | US Gas Fin Opt   NYMEX        EP5.35     May01           USD/MM-L |  | 10000 |  | MMBtu/Lots | United States Dollar | 0.538 | ADM74235 | DKENNE | NG-Price | Enron North America Corp. | TAGG | Q28345.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132923 | 2001-01-05 09:05:07 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas FIN Swap | US Gas Daily     Nymex NL1               May01           USD/MM |  | 5000 |  | MMBtu | United States Dollar | 5.38 | DKENNE | DKENNE | NG-Price | Enron North America Corp. | TAGG |  | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132922 | 2001-01-05 09:05:07 | Frito-Lay, Inc. | Natural Gas | US Gas FIN Call Option | US Gas Fin Opt   NYMEX        EC5.35     May01           USD/MM-L |  | 10000 |  | MMBtu/Lots | United States Dollar | 0.548 | [NAME] | DKENNE | NG-Price | Enron North America Corp. | TAGG | Q28859.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132925 | 2001-01-05 09:05:17 | Natural Gas Price (Non-Affiliate) | Natural Gas | US Gas FIN Swap | US Gas Daily     Nymex NL1               May01           USD/MM | 5000 |  |  | MMBtu | United States Dollar | 5.35 | DKENNE | DKENNE | NG-Price | Enron North America Corp. | TAGG |  | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
132924 | 2001-01-05 09:05:17 | Frito-Lay, Inc. | Natural Gas | US Gas FIN Call Option | US Gas Fin Opt   NYMEX        EC5.35     May01           USD/MM-L | 10000 |  |  | MMBtu/Lots | United States Dollar | 0.519 | [NAME] | DKENNE | NG-Price | Enron North America Corp. | TAGG | Q28862.1 | 2001-05-01 00:00:00 | 2001-05-31 00:00:00
 | YELLOW IS SWAP THAT FAILED
 | THE OPTIONS BRIDGED SUCCESSFULLY
Spreadsheet: 467185d1466609201-data-capture-from-a-production-line-eol-data-capture-21-6-16
Sheet: Common Faults

Common faults | amount | cumulative amount | cumulative percentage
Bunk Cappings creased | 36
excess mastic | 20
Out of Stock OOS | 16
paint repairs | 12
excess mastic inside van | 9
Lino | 2
Damage by [NAME] | 1
sum
Spreadsheet: 860402d1708513394-name-split-and-data-on-dashboard-testbook
Sheet: Bylines

Site | Year | Month | Quarter | Byline | Count | Byline Type | External | Internal | Total |  |  | Site | Year | Month | Quarter | Byline | Count
Red | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  |  | site, year, month, quarter, should auto populate |  |  |  |  | 100 |  | The formula in column Q slows down when there's lots of data. It also correctly splits the names which have a , in between them along with the values. but I want the corresponding site name, year, month and quarter to display too.
Red | 2020 | Dec | Q4 | [NAME] | 90 | External |  |  |  |  |  |  |  |  |  | [NAME] | 90
Red | 2020 | Dec | Q1 | [NAME] | 80 | External |  |  |  |  |  |  |  |  |  | [NAME] | 80
Yellow | 2020 | Dec | Q1 | [NAME] | 70 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 70
Yellow | 2020 | Dec | Q1 | [NAME] | 60 | External |  |  |  |  |  |  |  |  |  | [NAME] | 60
Blue | 2020 | Dec | Q1 | [NAME] | 50 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 50
Yellow | 2020 | Dec | Q2 | Mark | 60 | External |  |  |  |  |  |  |  |  |  | Mark | 60
Green | 2020 | Dec | Q2 | [NAME] | 70 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 70
Blue | 2020 | Dec | Q4 | Mark | 81 | External |  |  |  |  |  |  |  |  |  | Mark | 81
Green | 2020 | Dec | Q4 | [NAME] | 91 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 91
Green | 2020 | Dec | Q4 | [NAME] | 100 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 100
Green | 2023 | Jan | Q1 | [NAME], [NAME] | 2 | Internal |  |  |  |  |  |  |  |  |  | [NAME] | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 2
Spreadsheet: 765520d1643372606-conditional-formatting-with-a-difference-sample
Sheet: Sheet1

Q1 2022
 |  | Volume
 |  | Renewed Value
 | 0.5 | 0.55 | 0.6 | 0.7 | Volume
0.6 | 250 | 300 | 500 | 600
0.7 | 300 | 500 | 600 | 750
0.8 | 500 | 600 | 750 | 850
0.9 | 600 | 750 | 850 | 1000
Value QTR
Renewal in QTR |  |  | Available | 4 | Volume
Business Name | Value renewed |  |  | 25000 | Value
abc corp | 10800
cde company | 6120
Spreadsheet: 242b8dc5-9769-4e0a-8410-7f38d3f6eba4
Sheet: Michigan

Michigan Pricing Spreadsheet
 | Product Category | Product Description | Unit of Issue | Unit Price
0001B | Gordon's Food Service-Grand Rapids
0001B(1)a | Oranges | Fresh Oranges 125-138 ct | CS | 20.25
0001B(1)b | Oranges | Second Proposed Orange Product
0001B(1)c | Oranges | Third Proposed Orange Product
0001B(2)a | Lettuce | First Proposed Lettuce Product
0002B | Gordon's Food Service-Brighton
0002B(1)a | Oranges | First Proposed Orange Product
0002B(2)a | Lettuce | First Proposed Lettuce Product
0003B | Sysco-Detroit
0003B(1)a | Grapes | First Proposed Grape Product
0003B(2)a | Oranges | First Proposed Orange Product
0003B(3)a | Strawberries | First Proposed [NAME]
0003B(4)a | Broccoli | First Proposed Broccoli Product
0003B(5)a | Carrots | First Proposed Carrot Product
0003B(6)a | Lettuce | First Proposed Lettuce Product
0004B | Sysco-Grand Rapids
0004B(1)a | Apples | First Proposed Apple Product
0004B(2)a | Blueberries | First Proposed Blueberry Product
0004B(3)a | Grapes | First Proposed Grape Product
0004B(4)a | Oranges | First Proposed Orange Product
0004B(5)a | Strawberries | First Proposed [NAME]
0004B(6)a | Broccoli | First Proposed Broccoli Product
0004B(7)a | Carrots | First Proposed Carrot Product
0004B(8)a | Lettuce | First Proposed Lettuce Product
Note:  Information has been included for line item 0001A(1)a  for informational purposes only to demonstrate the detail of information required.
Offerors should overwrite or delete the pre-loaded information as appropriate to their proposal, but the numbering convention should be followed.
Offerors may add or delete line items using the indicated numbering format accordint to the items proposed.
Spreadsheet: 780965d1652891321-getting-data-from-another-worksheet-data
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Worksheets
Month | Jan |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jan
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feb
 | Emp | Contacted | Yes | No | Maybe |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apr
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
Spreadsheet: 166463d1341591230-return-multiple-values-for-one-lookup-sample
Sheet: Sheet2

Interface Description | Interface Name | Interface Type | Operational Status | Port Speed | Device MACs | IP | DNS/NB Name
Vlan1 | Vl1 | propVirtual | Down | 1.0 Gbps
Vlan42 | Vl42 | propVirtual | Up | 1.0 Gbps
GigabitEthernet1/0/1 | Gi1/0/1 | ethernetCsmacd | Up | 100 Mbps | 0022.3333.ff45
GigabitEthernet1/0/1 | Gi1/0/1 | ethernetCsmacd | Up | 10 Mbps | 9999.7777.7766 | 192.252.111.1 | farm1.farm.com
GigabitEthernet1/0/1 | Gi1/0/1 | ethernetCsmacd | Up | 1.0 Gbps | 8b88.7906.7776 | 193.222.21.3 | fff.na.farm.com
GigabitEthernet1/0/2 | Gi1/0/2 | ethernetCsmacd | Up | 1.0 Gbps | 5554.7777.7777 | 207.155.55.5 | bbb.na.farm.com
Spreadsheet: 688141d1595584321-index-match-formula-not-working-properly-lims-manipulate
Sheet: Sheet1

date | lot no | grade | parameter | value | T/F | date | lot no | grade | MFI | S.EX | DENSITY | AO
2020-07-01 00:00:00 | H1901000 | B56003 | MFI | 0.33 | T |  |  |  |  |  |  |  | row no.1
2020-07-01 00:00:00 | H1901000 | B56003 | S.EX | 1.98 | F |  |  |  |  |  |  |  | row no.2
2020-07-01 00:00:00 | H1901000 | B56003 | DENSITY | 0.9336 | T
2020-07-01 00:00:00 | H1901000 | B56003 | AO | 200 | T
2020-07-02 00:00:00 | H1901001 | B56003 | MFI | 0.35 | T
2020-07-02 00:00:00 | H1901001 | B56003 | S.EX | 1.95 | T
2020-07-02 00:00:00 | H1901001 | B56003 | DENSITY | 0.9556 | T
2020-07-02 00:00:00 | H1901001 | B56003 | AO | 250 | F
2020-07-03 00:00:00 | H1901002 | B60003 | MFI | 0.31 | T
2020-07-03 00:00:00 | H1901002 | B60003 | S.EX | 1.88 | F
2020-07-03 00:00:00 | H1901002 | B60003 | DENSITY | 0.9569 | T
2020-07-03 00:00:00 | H1901002 | B60003 | AO | 230 | T
 | Original Database |  |  |  |  |  |  | Reorganised Data
Spreadsheet: 667469d1584291876-get-doc-no-in-annexure-a-sheet-from-fbr-data-sheet-doc-no-query
Sheet: Annexure A

Annexure A
Supplier NTN | [NAME] | Supplier revised | Site | Type | Doc. No | Doc. Date | Purchase Type | Value | GST | Report
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Registered | PI |  | 2019-11-02 00:00:00 | 0.17 | - | 2000 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 2020-04-02 00:00:00 | 0.17 | 1307997 | 222359 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 2020-05-02 00:00:00 | 0.17 | 1020421 | 173472 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 2020-12-02 00:00:00 | 0.17 | 1090049 | 185308 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 2020-12-02 00:00:00 | 0.17 | 1087680 | 185641 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 2020-12-02 00:00:00 | 0.17 | 1361660 | 231762 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 13/02/2020 | 0.17 | 1092109 | 185659 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 14/02/2020 | 0.17 | 1290590 | 219488 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 15/02/2020 | 0.17 | 1080470 | 183697 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 15/02/2020 | 0.17 | 1045038 | 177656 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 20/01/2020 | 0.17 | 204970 | 35090 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 22/01/2020 | 0.17 | 603580 | 102679 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 23/01/2020 | 0.17 | 1012490 | 172246 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 23/01/2020 | 0.17 | 1249184 | 212361 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 24/01/2020 | 0.17 | 990860 | 168604 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 24/01/2020 | 0.17 | 1224670 | 208264 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 25/01/2020 | 0.17 | 1220550 | 207529 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 25/01/2020 | 0.17 | 1005280 | 171020 | Annex-A
3795452-7 | AL-AZIZ PAPER MILLS (PVT) LTD. | Supplies | Un-Registered | PI |  | 30/01/2020 | 0.17 | 1249390 | 212449 | Annex-A
Spreadsheet: 841737d1693911311-sum-wage-amount-for-each-employee-based-on-month-04-15-2022-and-year-2022-sample56
Sheet: Sheet1

 |  |  |  | 2022 |  |  |  |  | 2023
Date | Employee # | Wage |  | Date | 001 | 002 | 003 |  | Date | 001 | 002 | 003
2022-04-02 00:00:00 | 001 | 909 |  | balandis | 2839 | 3018 | 3049 |  | balandis | 3749 | 3436 | 4668
2022-04-15 00:00:00 | 002 | 860 |  | birželis | 527 | 347 | 1026 |  | birželis | 4580 | 3516 | 3187
2022-04-17 00:00:00 | 003 | 893 |  | gegužė | 4457 | 4579 | 4075 |  | gegužė | 3492 | 3749 | 5339
2022-04-19 00:00:00 | 001 | 901 |  |  |  |  |  |  | [NAME] | 1266 | 3434 | 6276
2022-04-20 00:00:00 | 002 | 1093
2022-04-21 00:00:00 | 003 | 1047
2022-04-25 00:00:00 | 001 | 1029
2022-04-27 00:00:00 | 002 | 1065
2022-04-29 00:00:00 | 003 | 1109
2022-05-05 00:00:00 | 001 | 1205
2022-05-06 00:00:00 | 002 | 1224
2022-05-11 00:00:00 | 003 | 1582
2022-05-15 00:00:00 | 001 | 1651
2022-05-16 00:00:00 | 002 | 1654
2022-05-17 00:00:00 | 003 | 1622
2022-05-18 00:00:00 | 001 | 1601
2022-05-19 00:00:00 | 002 | 1701
2022-05-25 00:00:00 | 003 | 871
2022-06-02 00:00:00 | 001 | 261
2022-06-05 00:00:00 | 002 | 218
2022-06-07 00:00:00 | 003 | 276
2022-06-15 00:00:00 | 001 | 266
2022-06-16 00:00:00 | 002 | 129
2022-06-17 00:00:00 | 003 | 750
2023-04-03 00:00:00 | 001 | 1501
2023-04-16 00:00:00 | 002 | 1784
2023-04-17 00:00:00 | 003 | 1905
2023-04-21 00:00:00 | 001 | 2248
2023-04-26 00:00:00 | 002 | 1652
2023-04-27 00:00:00 | 003 | 2763
2023-05-01 00:00:00 | 001 | 1282
2023-05-02 00:00:00 | 002 | 1995
2023-05-07 00:00:00 | 003 | 3871
2023-05-12 00:00:00 | 001 | 390
2023-05-15 00:00:00 | 002 | 1754
2023-05-19 00:00:00 | 003 | 1468
2023-05-25 00:00:00 | 001 | 1820
2023-06-04 00:00:00 | 002 | 1002
2023-06-07 00:00:00 | 003 | 1763
2023-06-12 00:00:00 | 001 | 2834
2023-06-15 00:00:00 | 002 | 2514
2023-06-22 00:00:00 | 003 | 1424
2023-06-28 00:00:00 | 001 | 1746
2023-07-05 00:00:00 | 002 | 1992
2023-07-15 00:00:00 | 003 | 4514
2023-07-19 00:00:00 | 001 | 1266
2023-07-22 00:00:00 | 002 | 1442
2023-07-27 00:00:00 | 003 | 1762
Spreadsheet: 91e643f6-661f-4fa1-98f0-8a842d6cdf50
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 |  | SKUPNA REKAPITULACIJA STROŠKOV VSEH DEL
 |  |  | EUR | DDV
 | I. | GRADBENA DELA
 | II. | OBRTNIŠKA DELA
 | III. | ELEKTRIČNE INŠTALACIJE IN NAPRAVE
 | IV. | STROJNE INSTALACIJE IN NAPRAVE
 | V. | UREDITEV OKOLJA
 | VI. | KOMUNALNI PRIKLJUČKI
 | VII. | POŽARNO JAVLJANJE
 | VIII. | DRUGA IN NEPREDVIDENA DELA
 | X. | OPREMA
Spreadsheet: 839107d1691665933-formula-to-determine-if-the-data-is-in-the-1st-half-or-2nd-half-of-the-data-set-access-example-2-
Sheet: Part 1

F1 | F2 | Count # | Count Total | F3 |  |  |  |  |  |  | F1 | F2
2022-10-12 00:00:00 | Yellow |  |  |  |  |  | Yellow | 1st
2022-10-15 00:00:00 | Red |  |  |  |  | 2022-10-15 00:00:00 | Red | 1st
2022-10-17 00:00:00 | Blue |  |  |  |  | 2022-10-17 00:00:00 | Blue | 1st
2022-10-18 00:00:00 | Green |  |  |  |  | 2022-10-18 00:00:00 | Green | 1st
2022-10-20 00:00:00 | Blue |  |  |  |  | 2022-10-20 00:00:00 | Blue | 1st
2022-10-23 00:00:00 | Green |  |  |  |  | 2022-10-23 00:00:00 | Green | 1st
2022-10-26 00:00:00 | Red |  |  |  |  | 2022-10-26 00:00:00 | Red | 1st
2022-10-28 00:00:00 | Yellow |  |  |  |  | 2022-10-28 00:00:00 | Yellow | 1st
2022-10-30 00:00:00 | Green |  |  |  |  | 2022-10-30 00:00:00 | Green | 2nd
2022-11-01 00:00:00 | Blue |  |  |  |  | 2022-11-01 00:00:00 | Blue | 2nd
2022-11-03 00:00:00 | Red |  |  |  |  | 2022-11-03 00:00:00 | Red | 1st
2022-11-05 00:00:00 | Yellow |  |  |  |  | 2022-11-05 00:00:00 | Yellow | 2nd
2022-11-06 00:00:00 | Green |  |  |  |  | 2022-11-06 00:00:00 | Green | 2nd
2022-11-09 00:00:00 | Blue |  |  |  |  | 2022-11-09 00:00:00 | Blue | 2nd
2022-11-12 00:00:00 | Yellow |  |  |  |  | 2022-11-12 00:00:00 | Yellow | 2nd
2022-11-15 00:00:00 | Red |  |  |  |  | 2022-11-15 00:00:00 | Red | 2nd
2022-11-17 00:00:00 | Red |  |  |  |  | 2022-11-17 00:00:00 | Red | 2nd
2022-11-19 00:00:00 | Blue |  |  |  |  | 2022-11-19 00:00:00 | Blue | 2nd
2022-11-21 00:00:00 | Green |  |  |  |  | 2022-11-21 00:00:00 | Green | 2nd
2022-11-23 00:00:00 | Red |  |  |  |  | 2022-11-23 00:00:00 | Red | 2nd