tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 836916d1689714857-gantt-chart-show-all-subtasks-under-a-master-task-on-the-same-row-planner-5-day
Sheet: Settings

Date | Day | Name Of Holiday
2022-05-30 00:00:00 |  | Memorial Day
2022-07-04 00:00:00 |  | Independence Day
2022-09-05 00:00:00 |  | Labor Day
2022-11-24 00:00:00 |  | Thanksgiving Day
2022-11-25 00:00:00 |  | Day AfterThanksgiving
2022-12-26 00:00:00 |  | Christmas
2023-01-02 00:00:00 |  | New Year's
2023-05-29 00:00:00 |  | Memorial Day
2023-07-04 00:00:00 |  | Independence Day
2023-09-04 00:00:00 |  | Labor Day
2023-11-23 00:00:00 |  | Thanksgiving Day
2023-11-24 00:00:00 |  | Day AfterThanksgiving
2023-12-25 00:00:00 |  | Christmas
2024-01-01 00:00:00 |  | New Year's
2024-05-27 00:00:00 |  | Memorial Day
2024-07-04 00:00:00 |  | Independence Day
2024-09-02 00:00:00 |  | Labor Day
2024-11-28 00:00:00 |  | Thanksgiving Day
2024-11-29 00:00:00 |  | Day AfterThanksgiving
2024-12-25 00:00:00 |  | Christmas
2025-01-01 00:00:00 |  | New Year's
2025-05-26 00:00:00 |  | Memorial Day
2025-07-04 00:00:00 |  | Independence Day
2025-09-01 00:00:00 |  | Labor Day
2025-11-27 00:00:00 |  | Thanksgiving Day
2025-11-28 00:00:00 |  | Day AfterThanksgiving
2025-12-25 00:00:00 |  | Christmas
2026-01-01 00:00:00 |  | New Year's
2026-05-25 00:00:00 |  | Memorial Day
2026-07-03 00:00:00 |  | Independence Day
2026-09-07 00:00:00 |  | Labor Day
2026-11-26 00:00:00 |  | Thanksgiving Day
2026-11-27 00:00:00 |  | Day AfterThanksgiving
2026-12-25 00:00:00 |  | Christmas
2027-01-01 00:00:00 |  | New Year's
2027-05-31 00:00:00 |  | Memorial Day
2027-07-05 00:00:00 |  | Independence Day
2027-09-06 00:00:00 |  | Labor Day
2027-11-25 00:00:00 |  | Thanksgiving Day
2027-11-26 00:00:00 |  | Day AfterThanksgiving
2027-12-24 00:00:00 |  | Christmas
2027-12-31 00:00:00 |  | New Year's
2028-05-29 00:00:00 |  | Memorial Day
2028-07-04 00:00:00 |  | Independence Day
2028-09-04 00:00:00 |  | Labor Day
2028-11-23 00:00:00 |  | Thanksgiving Day
2028-11-24 00:00:00 |  | Day AfterThanksgiving
2028-12-25 00:00:00 |  | Christmas
2029-01-01 00:00:00 |  | New Year's
Spreadsheet: 776297d1649680998-divide-a-sheet-evenly-into-3-4-sheets-ptls
Sheet: Sheet1

104077060 | 2019-05-01 00:00:00
51449570 | 2019-05-01 00:00:00
105665840 | 2019-05-02 00:00:00
106554875 | 2019-05-02 00:00:00
182785770 | 2019-05-03 00:00:00
103366841 | 2019-05-03 00:00:00
128488026 | 2019-05-04 00:00:00
187468816 | 2019-05-04 00:00:00
166064538 | 2019-05-05 00:00:00
183107090 | 2019-05-05 00:00:00
155719723 | 2019-05-06 00:00:00
121656013 | 2019-05-06 00:00:00
183297010 | 2019-05-07 00:00:00
168275023 | 2019-05-07 00:00:00
181674044 | 2019-05-08 00:00:00
157643928 | 2019-05-08 00:00:00
172714049 | 2019-05-09 00:00:00
170590847 | 2019-05-09 00:00:00
185191737 | 2019-05-10 00:00:00
176565963 | 2019-05-10 00:00:00
109000433 | 2019-05-11 00:00:00
155772469 | 2019-05-11 00:00:00
158457524 | 2019-05-12 00:00:00
164792999 | 2019-05-12 00:00:00
102495065 | 2019-05-13 00:00:00
142049708 | 2019-05-13 00:00:00
166135053 | 2019-05-14 00:00:00
178132224 | 2019-05-14 00:00:00
188280836 | 2019-05-15 00:00:00
155639924 | 2019-05-15 00:00:00
111969294 | 2019-05-16 00:00:00
116909534 | 2019-05-16 00:00:00
198847106 | 2019-05-17 00:00:00
137124910 | 2019-05-17 00:00:00
173567476 | 2019-05-18 00:00:00
177313372 | 2019-05-18 00:00:00
190959911 | 2019-05-19 00:00:00
194244485 | 2019-05-19 00:00:00
150925549 | 2019-05-20 00:00:00
120943015 | 2019-05-20 00:00:00
143418442 | 2019-05-21 00:00:00
124203684 | 2019-05-21 00:00:00
164964257 | 2019-05-22 00:00:00
144288180 | 2019-05-22 00:00:00
154170448 | 2019-05-23 00:00:00
127209183 | 2019-05-23 00:00:00
196379805 | 2019-05-24 00:00:00
187814357 | 2019-05-24 00:00:00
134723239 | 2019-05-25 00:00:00
189635814 | 2019-05-25 00:00:00
121282278 | 2019-05-26 00:00:00
169708905 | 2019-05-26 00:00:00
115746360 | 2019-05-27 00:00:00
123705541 | 2019-05-27 00:00:00
120195456 | 2019-05-28 00:00:00
133464597 | 2019-05-28 00:00:00
119089215 | 2019-05-29 00:00:00
181805546 | 2019-05-29 00:00:00
153518911 | 2019-05-30 00:00:00
147119694 | 2019-05-30 00:00:00
163023586 | 2019-05-31 00:00:00
168023089 | 2019-05-31 00:00:00
Spreadsheet: 213330d1360443107-probability-of-more-than-once-in-a-column-sport-nwa1039-oeldere2-
Sheet: Sheet1

Player ID | Game | Age
2938 | tennis | 37 |  | Aantal van Game | Kolomlabels
3493 | running | 16 |  | Rijlabels | rugby | running | soccer | tennis | Endtotaal
2938 | soccer | 37 |  | 145 |  | 1 |  |  | 1
400 | soccer | 8 |  | 231 | 1 |  |  | 1 | 2
231 | tennis | 25 |  | 302 |  |  | 1 |  | 1
532 | tennis | 61 |  | 400 |  |  | 1 |  | 1
145 | running | 30 |  | 425 |  |  |  | 1 | 1
425 | tennis | 30 |  | 532 |  |  |  | 1 | 1
231 | rugby | 25 |  | 2938 |  |  | 1 | 1 | 2
302 | soccer | 21 |  | 3493 |  | 1 |  |  | 1
 |  |  |  | Endtotaal | 1 | 2 | 3 | 4 | 10
 |  |  |  | Rijlabels | Aantal van Game
 |  |  |  | 0-9 | 1
 |  |  |  | 400 | 1
 |  |  |  | 10-19 | 1
 |  |  |  | 3493 | 1
 |  |  |  | 20-29 | 3
 |  |  |  | 231 | 2
 |  |  |  | 302 | 1
 |  |  |  | 30-39 | 4
 |  |  |  | 145 | 1
 |  |  |  | 425 | 1
 |  |  |  | 2938 | 2
 |  |  |  | 60-70 | 1
 |  |  |  | 532 | 1
 |  |  |  | Eindtotaal | 10
Spreadsheet: 158635d1338323433-excel-2007-display-mutliple-cells-based-on-one-criteria-test1
Sheet: Sheet1

 | Project Name | Project Date | Data | Category
 | Project A | X | text | Blue
 | Project B | X | text | Green
 | Project C | X | text | Blue
 | Project D | X | text | Red
 | Project E | X | text | Red
 | Project F | X | text | White
 | Project G | X | text | Blue
 | Project H | X | text | Green
 | Project I | X | text | Blue
Spreadsheet: phillip_m_love__30142__9912_OA
Sheet: TX-HPLR-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  HPLR
 |  |  | 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 | 3119128 | 7105606.139999986
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | -0.7000000001862645
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 3119128 | 7105605.439999986
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -7432860 | -16558084.74000001
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 0 | -1
 | Total Purchases: |  | -7432860 | -16558085.74000001
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | -2986570 | -6821596.329999998
12 |  | Purchases | 7195082 | 16024487.2
 | Total Intra CTS Sales / Purchases |  | 4208512 | 9202890.870000005
 |  |  | 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.7399999983608723
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0.7399999983608723
 | Total Storage: |  | 0 | 0.7399999983608723
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | 105220 | 215437.4183860086
 |  |  | 0 | 0
23 | Fuel: |  | 5 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 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 | 108884.2227
31 |  | Prior Month Book Balance | 0 | -888567
 |  | Total MTM Income | 0 | -779682.7773
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 779682.7773
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
Spreadsheet: 699663d1602694987-vlookup-via-dropdown-from-second-sheet-sampledata2a
Sheet: Sheet2

 | Course Name | Duration | Cost | Deposit |  |  | Payment Terms | Monthly Payment Period |  | Weekly Payment Period
 | Example 1 | 12 Months | 2000 | 100 | Weekly |  | Weekly | 2 Months | 2 | 4 Weeks | 4
 | Example 2 | 13 Months | 3000 | 100 | Monthly |  | Monthly | 3 Months | 3 | 6 Weeks | 6
 | Example 3 | 14 Months | 4000 | 100 | Monthly |  |  | 4 Months | 4 | 8 Weeks | 8
 | Example 4 | 15 Months | 5000 | 100 | Monthly |  |  | 5 Months | 5 | 10 Weeks | 10
 | Example 5 | 16 Months | 6000 | 100 | Monthly |  |  | 6 Months | 6 | 12 Weeks | 12
 | Example 6 | 17 Months | 7000 | 100 | Monthly |  |  | 7 Months | 7 | 14 Weeks | 14
 | Example 7 | 18 Months | 5000 | 100 | Monthly |  |  | 8 Months | 8 | 16 Weeks | 16
 | Example 8 | 19 Months | 9000 | 100 | Monthly |  |  | 9 Months | 9 | 18 Weeks | 18
 | Example 9 | 20 Months | 1000 | 100 | Monthly |  |  | 10 Weeks | 10 | 20 Weeks | 20
 | Example 10 | 21 Months | 2500 | 500 | Monthly |  |  | 11 weeks | 11
 | Example 11 | 22 Months | 3500 | 100 | Monthly |  |  | 12 Months | 12
 | Example 12 | 23 Months | 4750 | 100 | Monthly
Spreadsheet: 83131d1283182983-lookup-and-if-dispatchers_sheet
Sheet: Driver Shifts

ID | Driver | Start Date & Time | Finish Date & Time | Igonre this
22 | [NAME] | 2010-08-30 12:40:44
21 | [NAME] | 2010-08-29 16:45:00 |  | 2010-08-30 01:30:00
20 | [NAME] | 2010-08-29 16:45:00 |  | 2010-08-30 01:30:00
19 | Big John | 2010-08-29 13:00:00 |  | 2010-08-29 16:45:00
18 | [NAME] | 2010-08-29 13:00:00 |  | 2010-08-29 16:45:00
17 | [NAME] | 2010-08-28 17:58:38 |  | 2010-08-29 02:00:00
16 | [NAME] | 2010-08-28 17:48:22 |  | 2010-08-29 02:00:00
15 | [NAME] | 2010-08-28 16:48:55 |  | 2010-08-29 02:00:00
14 | [NAME] | 2010-08-28 13:00:00 |  | 2010-08-28 16:48:49
13 | Big John | 2010-08-28 13:00:00 |  | 2010-08-28 17:47:57
11 | Sean | 2010-08-27 18:00:00 |  | 2010-08-28 00:18:21
10 | [NAME] | 2010-08-27 18:00:00 |  | 2010-08-28 02:00:00
9 | [NAME] | 2010-08-27 16:40:00 |  | 2010-08-28 02:00:00
1 | Big John | 2010-08-26 16:45:00 |  | 2010-08-26 23:30:00
Spreadsheet: 861539d1709411330-tracking-last-30-days-blood-readings
Sheet: Mar24

2024-03-01 00:00:00
date | day | time | Sys | [NAME] | Pul | Sugar
2024-03-01 00:00:00 |  | 11:30:00 | 124 | 71 | 63 | 162
2024-03-02 00:00:00 |  | 10:32:00 | 126 | 79 | 65 | 191
2024-03-03 00:00:00
2024-03-04 00:00:00
2024-03-05 00:00:00
2024-03-06 00:00:00
2024-03-07 00:00:00
2024-03-08 00:00:00
2024-03-09 00:00:00
2024-03-10 00:00:00
2024-03-11 00:00:00
2024-03-12 00:00:00
2024-03-13 00:00:00
2024-03-14 00:00:00
2024-03-15 00:00:00
2024-03-16 00:00:00
2024-03-17 00:00:00
2024-03-18 00:00:00
2024-03-19 00:00:00
2024-03-20 00:00:00
2024-03-21 00:00:00
2024-03-22 00:00:00
2024-03-23 00:00:00
2024-03-24 00:00:00
2024-03-25 00:00:00
2024-03-26 00:00:00
2024-03-27 00:00:00
2024-03-28 00:00:00
2024-03-29 00:00:00
2024-01-30 00:00:00
2024-01-31 00:00:00
Spreadsheet: 82817d1282830992-automatically-inserting-data-into-cells-based-data-entered-in-other-cells-overtime
Sheet: August

Overtime for August Week 1
 |  |  |  |  |  |  | Week Ending |  | 2010-08-22 00:00:00
Predicted Overtime | Name | Date | Hours | Reason | [NAME] | Overtime Rate (1.5) | Cost | Actual Overtime | Name | Actual | Hours | Reason | [NAME] | Overtime Rate (1.5x) | Cost
 | Worker C |  |  |  | 0 | 0 | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTAL | 0 |  |  |  |  |  |  | TOTAL | 0
Overtime for August Week 2
 |  |  |  |  |  |  | Week Ending |  | 2010-08-15 00:00:00
Predicted Overtime | Name | Date | Hours | Reason | [NAME] | Overtime Rate (1.5) | Cost | Actual Overtime | Name | Actual | Hours | Reason | [NAME] | Overtime Rate (1.5x) | Cost
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTAL | 0 |  |  |  |  |  |  | TOTAL | 0
Overtime for August Week 3
 |  |  |  |  |  |  | Week Ending |  | 2010-08-22 00:00:00
Predicted Overtime | Name | Date | Hours | Reason | [NAME] | Overtime Rate (1.5) | Cost | Actual Overtime | Name | Actual | Hours | Reason | [NAME] | Overtime Rate (1.5x) | Cost
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTAL | 0 |  |  |  |  |  |  | TOTAL | 0
Overtime for August Week 4
 |  |  |  |  |  |  | Week Ending |  | 2010-08-29 00:00:00
Predicted Overtime | Name | Date | Hours | Reason | [NAME] | Overtime Rate (1.5) | Cost | Actual Overtime | Name | Actual | Hours | Reason | [NAME] | Overtime Rate (1.5x) | Cost
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  | TOTAL | 0 |  |  |  |  |  |  | TOTAL | 0
Spreadsheet: 550284d1512201081-comparing-3-values-example
Sheet: Sheet1

 | [NAME] | 122 |  | [NAME] | 178 |  | [NAME] | 199 |  | [NAME]
 | [NAME] | 190 |  | [NAME] | 200 |  | [NAME] | 120 |  | [NAME]
 | [NAME] | 187 |  | [NAME] | 160 |  | [NAME] | 162 |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
 | [NAME] |  |  | [NAME] |  |  | [NAME]
Spreadsheet: 886148d1736183624-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms
Sheet: Sheet1

Number of Stops | Road Name | Stops effected | Closure Type
 | data from 'stops list'  tab column E | data to 'text join' from 'stops list' column C | data from 'stop list' column H
 | EDGWARE WAY | 15758, 16105, 14702 | Publicity Only, Publicity & Hood
1 | EDGWAREBURY LANE (N AND S OF A41) | 15760 | Publicity Only
1 | GLOUCESTER PLACE | 29797 | Publicity & Hood
1 | STATION ROAD | 25118 | Publicity Only
EXAMPLE OF OUTCOME
Number of Stops | Road Name | Stops effected | Closure Type
1 | station road | 25118 | Publicity only
1 | edgwarebury lane | 15760 | Publicity only
1 | gloucester place | 29797 | publicity & hood
2 | [NAME] | 15758, 14702 | Publicity only
1 | [NAME] | 16105 | publicity & hood
Spreadsheet: 806371d1669262759-searching-for-an-exact-numeric-match-with-a-formula-filter-example-forum
Sheet: Sheet1

 | ID | Result |  |  |  | ID | Value
 | 5.1 |  |  |  |  | 5.1 | banana
 | 5.2 |  |  |  |  | 5.11 | apple
 | 5.3 |  |  |  |  | 15.1 | [NAME]
 | 5.4 |  |  |  |  | 10.6 5.1 | avocado
 |  |  |  |  |  | 4.9 5.2 13.3 | orange
 | [NAME] used: | =TEXTJOIN(CHAR(10),TRUE,FILTER(H4:H8,ISNUMBER(SEARCH(B4,G4:G8)),""))
 |  | The result above (C4) should only return (banana, avocado), ideally in a new line
Spreadsheet: 125030d1318835909-values-based-on-three-criterias-copy-of-different-teams
Sheet: Overall Details

Name | Department | Status | Date | help 1 | help 2
Name 1 | Team 1 | In
Name 2 | Team 1 | In
Name 3 | Team 1 | In
Name 4 | Team 2 | Out | 2011-10-25 00:00:00
Name 5 | Team 2 | In
Name 6 | Team 3 | In
Name 7 | Team 1 | In
Name 8 | Team 3 | Out | 2011-09-11 00:00:00
Name 9 | Team 2 | Out | 2011-09-15 00:00:00
Name 10 | Team 1 | In
Spreadsheet: 887473d1737706131-help-to-get-all-name-in-a-30-range-from-a-specific-position-test_file
Sheet: Sheet1

NAME | POSITION | +30 POSITION | -30 POSITION | NAME | POSITION | +30 POSITION | -30 POSITION
Jeffo | 29 |  |  | Kiruss | 28 |  |  | Jeffo | Matilda Baudart | Fauldes | grishnackh |  | all the name from "A" between 0 to 58 position from "B"
Matilda Baudart | 39 |  |  | XPloit3d | 39 |  |  | Jeffo | Matilda Baudart | Fauldes | grishnackh |  | all the name from "A" between 6 to 69 position from "B"
Fauldes | 49 |  |  | gameover | 70 |  |  | Fauldes | grishnackh | Dragon | Dragonel | [NAME] | [NAME] | pumnal | FlorinXtreme | Scrat | -utzy- | all the name from "A" between 40 to 100 position from "B"
grishnackh | 55 |  |  | saragoza | 89
Dragon | 79 |  |  | Call me V | 106
Dragonel | 84 |  |  | [NAME] | 106
[NAME] | 89 |  |  | Lau05 | 108
[NAME] | 89 |  |  | Kungfu Panda | 108
pumnal | 89 |  |  | pupaza din tei | 109
FlorinXtreme | 89 |  |  | Moloch | 113
Scrat | 93 |  |  | Vladimirus | 113
-utzy- | 97 |  |  | --2Pac- | 115
Griffith | 103 |  |  | Hanno | 117
Wanderer | 109 |  |  | bebeto | 118
Hijacker | 109 |  |  | FIREBLADE | 121
Titan | 118 |  |  | Coman | 124
[NAME] | 124 |  |  | Morbius | 125
g_gabe | 126 |  |  | Hanibal | 126
neluxtremex | 129 |  |  | SCORPIO | 127
QuintusTatianus | 129 |  |  | Chaos | 129
Caius | 131 |  |  | cRiTiK | 130
dorina | 138 |  |  | ARESS | 135
Killa_B | 143 |  |  | WILLIAM | 138
Alexis | 144 |  |  | Sorin Nst | 139 |  |  | Wanderer | Hijacker | Titan | [NAME] | g_gabe | neluxtremex | QuintusTatianus | Caius | dorina | Killa_B | Alexis | ibladuc | Twisting Nether | Nelutu | Tinichea | Beowolf | [NAME] | Leviatan
ibladuc | 149 |  |  | -Tyga- | 139
Twisting Nether | 149 |  |  | [NAME] | 144
Nelutu | 149 |  |  | ASOKA | 145
Tinichea | 152 |  |  | [NAME] | 149
Beowolf | 158 |  |  | [NAME] | 155
[NAME] | 162 |  |  | papyy | 166
Leviatan | 169 |  |  | MariusZep | 166
Nicolson | 182 |  |  | MariusZ | 185
Bul-kathos | 184 |  |  | immortalgod | 186
Malko | 197 |  |  | exrhema | 188
unuluitat | 217 |  |  | Sethi I | 200
THE PREDATOR | 223 |  |  | PITBULL | 202
GRAVE | 254 |  |  | Unstoppable | 203
D4NG3R | 258 |  |  | UnDeCiM ^v^ | 216
Philcore | 278 |  |  | Neamtul | 231
B P M | 288 |  |  | [NAME] | 269
Dragonfable | 290 |  |  | NOtOriOus | 330
Silent Strike | 324 |  |  | Zeuss | 344
 |  |  |  | Gannicus | 346
Spreadsheet: 328143d1403795047-referencing-cell-based-on-user-input-that-corresponds-to-a-vlookup-examples
Sheet: data source

 |  | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct | nov | dec
 | branch 1 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 | branch 2 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 210 | 211 | 212
Spreadsheet: 790698d1659955932-splitting-date-range-to-row-ef1588_employee-leave
Sheet: Sheet4

A System Leave Data |  |  |  |  |  | B System Leave Data
id | nama | leave type | start | end |  | id | nama | leave type | start | end | Check System B Leave to System A
12345 | [NAME] | annual leave | 2022-07-01 00:00:00 | 2022-07-03 00:00:00 |  | 12345 | [NAME] | annual leave | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 | Available in system A
123456 | [NAME] | annual leave | 2022-07-01 00:00:00 | 2022-07-01 00:00:00 |  | 12345 | [NAME] | annual leave | 2022-07-02 00:00:00 | 2022-07-02 00:00:00 | Available in system A
123456 | [NAME] | annual leave | 2022-07-02 00:00:00 | 2022-07-02 00:00:00 |  | 12345 | [NAME] | annual leave | 2022-07-03 00:00:00 | 2022-07-03 00:00:00 | Available in system A
123456 | [NAME] | annual leave | 2022-07-03 00:00:00 | 2022-07-03 00:00:00 |  | 123456 | [NAME] | annual leave | 2022-07-01 00:00:00 | 2022-07-04 00:00:00 | Available in system A
123456 | [NAME] | annual leave | 2022-07-04 00:00:00 | 2022-07-04 00:00:00
Spreadsheet: 583187d1532313498-dropdown-dropdown
Sheet: Sheet1

name | price
qwe | 123 |  |  | name | price
rtg | 345 |  |  | opuy
yui | 432
[NAME] | 567
hgrt | 765
bgf | 78
opuy | 345
vgtr | 987
gfrt | 345
gfdet | 134
swer | 585
mhgy | 432
djsg | 234
mndgdy | 654
ndgsr | 234
[NAME] | 6756
hdf | 345
[NAME] | 876
pouij | 321
mdhbdt | 987
Spreadsheet: 181129d1347937202-generate-data-where-there-having-same-attribute-urgent-example1
Sheet: Sheet2

 | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6
a | formula |  |  |  |  |  |  |  | a |  |  |  | 1
b |  |  |  |  |  |  |  |  | b |  | 2 | 1
c |  |  |  |  |  |  |  | >> | c | 1
d |  |  |  |  |  |  |  |  | d |  |  |  |  |  | 1
e |  |  |  |  |  |  |  |  | e |  | 2
Spreadsheet: phillip_allen__28811__Westgate Proforma-Phillip Allen
Sheet: Unit Summary

PRICE & COST SUMMARY BY PLAN
Unit Type | Unit Description | Unit [NAME] | Unit Cost | Cost Per S.F. | Qty. | % | Total Cost | Price Per S.F. | Price Per Unit | Total Sales |  | Total ACSF | Total Cvrd
TWO STORY DUPLEXES
A | 3B 2.5B |  |  |  | 12 |  |  | 111
B | 3B 2.5B |  |  |  | 12 |  |  | 107
C | 3 B+Loft 2.5B |  |  |  | 18 |  |  | 105
D | 3B 2.5B |  |  |  | 12 |  |  | 110
ONE STORY DUPLEXES
E | 2B+Study 2B |  |  |  | 18 |  |  | 100
F | 2B 2B |  |  |  | 12 |  |  | 105
G | 2B 2B |  |  |  | 12 |  |  | 105
TOTALS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 4
Spreadsheet: 846551d1697717633-lookup-formula-help-to-extract-multiple-values-based-on-one-reference-lookup_samrat
Sheet: Production Consumption

[NAME] | Date | Product Code | Product Name | Customer Name | RM Code | RM Name | Standard Qty (in %) | [NAME] (in Kg) | Standard Qty (in Kg) | Actual Consumption in Batch (in Kg)
27666 |  | 123 | N.C SANDING SEALER | x | RTU TH. | a | 50 | 1000 |  | 600
27666 |  | 123 | N.C SANDING SEALER | x | KS-017 | b | 1 | 1000 |  | 10
27666 |  | 123 | N.C SANDING SEALER | x | KAS-041 | c | 5.5 | 1000 |  | 55
27666 |  | 123 | N.C SANDING SEALER | x | KM-23 | d | 2 | 1000 |  | 20
27666 |  | 123 | N.C SANDING SEALER | x | KR4-014 | e | 5 | 1000 |  | 50
27666 |  | 123 | N.C SANDING SEALER | x | KR3-014 | f | 6 | 1000 |  | 60
27666 |  | 123 | N.C SANDING SEALER | x | [NAME] | g | 18 | 1000 |  | 180
27666 |  | 123 | N.C SANDING SEALER | x | PA-52 | h | 0.1 | 1000 |  | 1
27666 |  | 123 | N.C SANDING SEALER | x | EA | i | 8.5 | 1000 |  | 85
27666 |  | 123 | N.C SANDING SEALER | x | BA | j | 5 | 1000 |  | 50
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | RTU THINNER | k | 25 | 1000 |  | 250
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | BA | l | 4 | 1000 |  | 40
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | EA | m | 37 | 1000 |  | 370
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | NBA | n | 1 | 1000 |  | 10
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | BC | o | 1 | 1000 |  | 10
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | DAA | p | 1.5 | 1000 |  | 15
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | MALIK | q | 1.5 | 1000 |  | 15
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | UK-100 | r | 0.4 | 1000 |  | 4
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | KR4-014 | s | 5 | 1000 |  | 50
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | KR3-014 | t | 5 | 1000 |  | 50
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | KR-32F | u | 18 | 1000 |  | 180
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | KP-988 | v | 0.2 | 1000 |  | 2
27662 |  | 124 | N.C LACQUER 10% GLOSS | y | KP-0002 | w | 0.2 | 1000 |  | 2