tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 139983d1328568444-excel-adds-time-to-date-which-causes-hlookup-to-fail-excel-help-1-120206-v2
Sheet: WORKSHEET 1

 | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End | Start | End
 |  |  |  |  |  | 2012-09-04 00:00:00
Cumulative
 | 50000
HIGH LEVEL TIMING
 | Days |  |  |  |  |  |  | Month | 2012-07-01 00:00:00
Time 1 | 28 |  |  |  |  |  |  | Qty per Month |  |  |  |  |  |  |  |  |  | 26880 |  | 53760 |  |  |  | 57322 | 57322 | 114644
Time 2 | 9 |  |  |  |  |  |  | Cumulative
Time 3 | 28
Time 4 | 2
Time 5 | 24 |  |  |  |  |  |  | Month | 2012-07-01 00:00:00
Time 6 | 7 |  |  |  |  |  |  | Qty by Month
Time 7 | 16 |  |  |  |  |  |  | Consumption | 0 | 0 | 63400 | 40600 | 49500 | 58000 | 66400 | 74700 | 84300 | 128600 | 114200 | 112100 | 115400 | 119100 | 122400 | 131500 | 134600 | 137400
Time 8 | 8 |  |  |  |  |  |  | Cumulative Inventory
Time 9 | 3
Time 10 | 28
Time 11 | 21
Time 12 | 14.81852272727273
Time 13 | 15
Time 14 | 7
Time 15 | 28
Spreadsheet: darrell_schoolcraft__7807__imbalsumm0108
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 7793 | 6031 |  |  | 1235 | 1150 | 1454 | 1283
2 | 7791 | 6031 |  |  | 1177 | 1150 | 1476 | 1283
3 | 5994 | 6031 |  |  | 1174 | 1150 | 1523 | 1283
4 | 7564 | 6031 |  |  | 1155 | 1150 | 1485 | 1283
5 | 7266 | 6031 |  |  | 1111 | 1150 | 1460 | 1283
6 | 7106 | 6031 |  |  | 1102 | 1150 | 1390 | 1283
7 | 6926 | 6031 |  |  | 1149 | 1150 | 1444 | 1283
8 | 6932 | 6031 |  |  | 1096 | 1150 | 1417 | 1283
9 | 6825 | 6031 |  |  | 1073 | 1150 | 1479 | 1283
10 | 7236 | 6031 |  |  | 1025 | 1150 | 1307 | 1283
11 | 7145 | 6031 |  |  | 1044 | 1150 | 1444 | 1283
12 | 7121 | 6031 |  |  | 1011 | 1150 | 1426 | 1283
13 | 7497 | 6031 |  |  | 1008 | 1150 | 1419 | 1283
14 | 5169 | 6031 |  |  | 956 | 1150 | 1409 | 1283
15 | 7298 | 6531 |  |  | 1098 | 1150 | 1394 | 1283
16 | 4507 | 6531 |  |  | 1042 | 1150 | 1404 | 1283
17 | 5627 | 6513 |  |  | 1034 | 1150 | 1409 | 1283
18 | 6389 | 6531 |  |  | 1004 | 1150 | 1399 | 1283
19 | 6016 | 6531 |  |  | 877 | 1150 | 1388 | 1283
20 | 7602 | 6531 |  |  | 1064 | 1150 | 1365 | 1283
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  |  |  |  |  |  |  | 372841.88
2001-08-20 00:00:00
CBS Volume
 |  |  | 146405
Spreadsheet: 59751d1260312797-excel-2007-how-to-sort-data-validation-menu-while-typing-characters-in-the-cell-for-the-menu-master_requirement_gathering_template_-final-
Sheet: Pre-Screening

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name
Activity Name
Activity Description / Purpose | Prescreening can include collection of basic information about the client/customer (possibly through an advocate) and their situation, identification of Emergency situations, and determining what actions (path) to take
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
 |  |  | Reception | New Application | Application | Screened Application | Application Registration
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Screen application for expedite or Working Families FS Initiative eligibility
Route application to worker for expedite
Message to customer to go home & wait for an appointment for normal applications
Date-stamp application in Oracle
WMS Inquiry
Make Appointment
Take Application to Examiner (expedite)
Spreadsheet: 34052d1231170765-generate-statement-with-cell-values-sample
Sheet: Sheet1

 |  |  | 0 | 0.3 | 0.15 | 0.1 | Total
 | Correct |  | 0 | 1000 | 2000 | 500 | 3500
 |  |  | Internal Transfers
 | Holdings |  | 1000 | 2000 |  | 500 | 3500
 | Total In / Out |  | 1000 | 1000 | 0 | 0
 |  |  | This blank row is necessary
0 | 0 |  | 0 | 0 | 0 | 0
0.3 | 0 |  | 0 | 0 | 0 | 0
0.15 | 2000 |  | 1000 | 1000 | 0 | 0
0.1 | 0 |  | 0 | 0 | 0 | 0
 |  |  | External Transfers
 | Holdings |  | 0 | 3000 | 500 | 0 | 3500
 | Total In / Out |  | 0 | 2000 | 0 | 0
 |  |  | This blank row is necessary
0 | 0 |  | 0 | 0 | 0 | 0
0.3 | 0 |  | 0 | 0 | 0 | 0
0.15 | 1500 |  | 0 | 1500 | 0 | 0
0.1 | 500 |  | 0 | 500 | 0 | 0
* I would like to code in such a way that it will automatically generate a statement for my internal transfer:
Internal transfer [1,000] from 0% to 15%
Internal transfer [1,000] from 30% to 15%
External transfer [1,500] from 30% to 15%
External transfer [500] from 30% to 10%
Those in red can it be dynmaic?  The statement change according to different values.
Spreadsheet: 830736d1685065640-organizing-text-from-random-cells-into-one-column-s666-pq-organizing-text-from-random-cells-into-one-column-the-same
Sheet: Sheet1

Company Name | Discount Profile | Column0 | Column1 | Column2 | Column3 | Column4
A PLUS GENERAL CONTRACTORS INC | CADP1A | YQQ01MLT | MSDAI07 | YGA05323 | YCA05323
ABSOLUTE AIRFLOW INC | AZSPEC | ZAL05MLT | VQQ02MLT | MSDAI09 | VGX90323 | VCX90323
ACTIVE AIR | CADP1A | YQQ01MLT | YGA05323 | YCA05323
ADRIAN J TORRES | CADP1A | [NAME] | MSDAI07 | YGA05323 | YCA05323
AIR CARE HEATING AND AIR COND | CADP1A | MSDAI09 | YGA05323 | YCA05323
ALL PHASE INC | CADP1A | MSDAI01 | YGA05323 | YCA05323
BASIC AIR INC | CADP1A | MSDAI05 | YGA03323 | [NAME]
BEST APPLIANCE & AIR INC | CADP1A | YQQ01MLT | MSDAI07 | YGA20323 | YCA20323
BREEZY AIR SERVICES | CADP1A | YQQ01MLT | MSDAI09 | YGA18323 | YCA18323
COMMAND AIR CORP | [NAME] | UQR01MLT | MSDAI05 | ZGL16MLT | ZCL15MLT | ZAL05MLT
COOL AIR REFRIGERATION | [NAME] | YQQ01MLT | MSDAI05 | YGA07323 | YCA07323
Company Name | Discount Profile | MS | UQ | VC | VG | VQ | YC | YG | YQ | ZA | ZC | ZG
A PLUS GENERAL CONTRACTORS INC | CADP1A | MSDAI07 |  |  |  |  | [NAME] | YGA05323 | YQQ01MLT
ABSOLUTE AIRFLOW INC | AZSPEC | MSDAI09 |  | VCX90323 | VGX90323 | VQQ02MLT |  |  |  | ZAL05MLT
ACTIVE AIR | CADP1A |  |  |  |  |  | [NAME] | YGA05323 | YQQ01MLT
ADRIAN J TORRES | CADP1A | MSDAI07 |  |  |  |  | [NAME] | YGA05323 | [NAME]
AIR CARE HEATING AND AIR COND | CADP1A | MSDAI09 |  |  |  |  | [NAME] | YGA05323
ALL PHASE INC | CADP1A | MSDAI01 |  |  |  |  | [NAME] | YGA05323
BASIC AIR INC | CADP1A | MSDAI05 |  |  |  |  | [NAME] | YGA03323
BEST APPLIANCE & AIR INC | CADP1A | MSDAI07 |  |  |  |  | [NAME] | [NAME] | YQQ01MLT
BREEZY AIR SERVICES | CADP1A | MSDAI09 |  |  |  |  | YCA18323 | YGA18323 | YQQ01MLT
COMMAND AIR CORP | [NAME] | MSDAI05 | UQR01MLT |  |  |  |  |  |  | ZAL05MLT | ZCL15MLT | ZGL16MLT
COOL AIR REFRIGERATION | [NAME] | MSDAI05 |  |  |  |  | YCA07323 | YGA07323 | YQQ01MLT
Spreadsheet: 160914d1339307524-how-to-create-a-graph-in-the-chart-ticket_report_eswar
Sheet: SprDates

Task_Name | Duration | Start_Date | Finish_Date | Predecessors | Capacity (Hrs)
Sprint 0 | 20 days | 2012-02-01 08:00:00 | 2012-02-28 17:00:00 |  | 272
Sprint 1 | 15 days? | 2012-02-29 08:00:00 | 2012-03-20 17:00:00 | 2 | 272
Sprint 2 | 10 days? | 2012-03-21 08:00:00 | 2012-04-03 17:00:00 | 6 | 272
Sprint 3 | 10 days | 2012-04-04 08:00:00 | 2012-04-17 17:00:00 | 13 | 272
Sprint 4 | 10 days | 2012-04-18 08:00:00 | 2012-05-01 17:00:00 | 17 | 272
Sprint 5 | 10 days | 2012-05-02 08:00:00 | 2012-05-15 17:00:00 | 18 | 292
Sprint 6 | 10 days | 2012-05-16 08:00:00 | 2012-05-29 17:00:00 | 19 | 324
Sprint 7 | 10 days | 2012-05-30 08:00:00 | 2012-06-12 17:00:00 | 20 | 660
Sprint 8 | 10 days | 2012-06-13 08:00:00 | 2012-06-26 17:00:00 | 21 | 720
Sprint 9 | 10 days | 2012-06-27 08:00:00 | 2012-07-10 17:00:00 | 22 | 720
Sprint 10 | 10 days | 2012-07-11 08:00:00 | 2012-07-24 17:00:00 | 23 | 720
Sprint 11 | 10 days | 2012-07-25 08:00:00 | 2012-08-07 17:00:00 | 24 | 660
Sprint 12 | 10 days | 2012-08-08 08:00:00 | 2012-08-21 17:00:00 | 25 | 660
Sprint 13 | 10 days | 2012-08-22 08:00:00 | 2012-09-04 17:00:00 | 26 | 660
Sprint 14 | 10 days | 2012-09-05 08:00:00 | 2012-09-18 17:00:00 | 27 | 454
Project Backlog |  | 0/0/00 | 0/0/00
Project Oversight |  | 0/0/00 | 0/0/00
phase11 |  | 0/0/00 | 0/0/00
 |  | 0/0/00 | 0/0/00
 |  | 0/0/00 | 0/0/00
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T63

الجدول 63 : أسباب الوفيات المسجلة في الإمارات العربية المتحدة
Table 63: Registered deaths by cause in United Arab Emirates
الإمارات العربية المتحدة | 2000 |  |  | 2005 |  |  | آخر سنة متوفرة
UNITED ARAB EMIRATES |  |  |  |  |  |  | latest available
سبب الوفاة (1) | مجموع | ذكور | اناث | مجموع | ذكور | اناث | مجموع | ذكور | اناث
Cause of death (1) | Total | Male | Female | Total | Male | Female | Total | Male | Female
1 | 41 | 25 | 16 | ... | ... | ... | ... | ... | ...
2 | 468 | 268 | 200 | ... | ... | ... | ... | ... | ...
3 | 158 | 86 | 72 | ... | ... | ... | ... | ... | ...
4 | 121 | 71 | 50 | ... | ... | ... | ... | ... | ...
5 | 4 | 3 | 1 | ... | ... | ... | ... | ... | ...
6 | 33 | 15 | 18 | ... | ... | ... | ... | ... | ...
7 | 1383 | 1000 | 383 | ... | ... | ... | ... | ... | ...
8 | 189 | 119 | 70 | ... | ... | ... | ... | ... | ...
9 | 111 | 85 | 26 | ... | ... | ... | ... | ... | ...
10 | 152 | 89 | 63 | ... | ... | ... | ... | ... | ...
11 | 1 | - | 1 | ... | ... | ... | ... | ... | ...
12 | - | - | - | ... | ... | ... | ... | ... | ...
13 | - | - | - | ... | ... | ... | ... | ... | ...
14 | 260 | 146 | 114 | ... | ... | ... | ... | ... | ...
15 | 133 | 76 | 57 | ... | ... | ... | ... | ... | ...
16 | 981 | 713 | 268 | ... | ... | ... | ... | ... | ...
17 | 809 | 709 | 100 | ... | ... | ... | ... | ... | ...
18 | 552 | 511 | 41 | ... | ... | ... | ... | ... | ...
المجموع       Total | 7396 | 3916 | 1480 | … | … | … | … | … | …
(1) Causes of death given in annex 1 |  |  |  |  |  |  |  |  | (1) اسباب الوفيات في الملحق رقم 1
Spreadsheet: 857329d1706351194-average-of-multiple-values-in-a-single-cell-with-without-text-and-or-full-stop-average-of-multiple-values-in-a-single-cell-expected-values
Sheet: Sheet1

 |  |  |  | EXPECTED VALUES
CASE 1 | 6,396 6,403 6,425 6,389 6,356 |  |  | 6.3938
 | N/A
CASE 2 | 6,550 (2fois) 6,565 6,560 6,556 7,268 ? 6,457 ? 84 % |  |  | 6.56 | if I add  7,268 ? 6,457 ? 84 %  I  don't want to consider them cause these values are not sure yet. If considered the result would be 6,66 and it would be false
CASE 3 | 6,945 (2fois) 6,921 (2fois) 6,862 sûr 6,940 7,077 |  |  | 6.95 | Here is ok if he consider the values followed by "(2fois)" (it means I had the same two times) or "sûr" that means that tha value is the right one
CASE 4 | ? Voir comm 7,629 7,625 7,634 7,639 7,666 6,839 ? 7,897 Stune |  |  | 7.64 | in this case I don't want to consider these two  6,839 ? 7,897 Stune  and ? Voir comm
Spreadsheet: 841863d1694000773-how-to-get-mutilple-search-results-using-index-and-match-formulas-shreenivas_automobiles_price_list-jacc
Sheet: Motul

Sr.No | Product_Name | Quantity | MRP | DLP | Combined_Name
1 | 3100 5w30 | 0.9L |  | 398
2 | 3100 10w30 | 0.9L |  | 379
3 | 3100 10w40 | 1L |  | 425
4 | 3100 10w30 | 1L |  | 422
5 | 5100 15w50 | 1L | 645 | 504
6 | 5100 15w50 | 1.5L |  | 735
7 | 3100 20w50 | 1L |  | 424
8 | Scooter 10w30 | 0.8L |  | 300
9 | 7100 20w50 | 1.5L |  | 940
10 | 7100 10w50 | 1.5L |  | 1011
11 | 300v 10w40 | 1L |  | 970
12 | 3000 15w50 | 2.5L |  | 790
13 | 300v 15w50 |  |  | 970
Spreadsheet: 760123d1640010489-highlight-rows-using-conditional-formatting-based-on-critirea-book25
Sheet: Sheet1

 |  |  |  |  |  | G | H
 |  | Branch | Number |  |  | Branch | Number
 |  | Branch 1 | 50 |  |  | Branch 1 | 50 | x
 |  | Branch 2 | 25 |  |  | Branch 2 | 25 | x
 |  | Branch 1 | 51 |  |  | Branch 1 | 51
 |  | Branch 1 | 50 |  |  | Branch 1 | 50 | x
 |  | Branch 2 | 26 |  |  | Branch 2 | 26
 |  | Branch 2 | 50 | x |  | Branch 2 | 50
 |  | Branch 2 | 25 |  |  | Branch 2 | 25 | x
 |  | Branch 1 | 25 | x |  | Branch 1 | 25 | o
Spreadsheet: 35359d1232976760-copying-hyperlinks-december-2008-excel-forum-daily-accts
Sheet: 8(a)

[NAME] по счетам группы компаний "Вагриус" |  |  |  |  |  |  | 8(a)
на начало дня 8 Декабря 2008 года
[NAME] компании | Без Нал. | Нал. | Сумма
[NAME] | 196000 | 0 | 196000 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 883.45 | 0 | 883.45 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 0 | 0 | 0 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 49000 | 0 | 49000 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 0 | 0 | 0 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Общий Итог: | 245883.45 | 0 | 245883.45 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
 |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
Фактические РАСХОДЫ по счетам группы компаний "Вагриус" |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
на конец дня 8 Декабря 2008 года |  |  |  |  |  | Вагриус минус | A170 | B182 | C182 | F182
[NAME] компании | Без Нал. | Нал. | Сумма |  |  | Плюс-минус | A186 | B198 | C198 | F198
[NAME] | 1045 | 0 | 1045 |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
Вагриус книги | 0 | 0 | 0 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус правда | 0 | 0 | 0 |  |  |  |  | B233 | C233 | F233
Вагриус минус | 15 | 0 | 15
Плюс-минус | 15 | 0 | 15
Издательство Вагриус | 0 | 0 | 0
Вагриус плюс-минус | 0 | 0 | 0
Общий Итог: | 1075 | 0 | 1075
Spreadsheet: f2c4e666-77b1-49fe-b6fe-5f14e3e22c42
Sheet: Sheet1

Percent of Women Who Did Not Smoke During the Last 3 Months of Pregnancy,  by County and Public Health District, Maine, 2006-2010 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  | Unweighted Number | Weighted Number | % | 95% CI
County
 | Androscoggin | 402 | 4608 | 79.3748 | 75.1 - 83.7
 | Aroostook | 224 | 2789 | 73.3433 | 67.5 - 79.2
 | Cumberland | 1032 | 12260 | 87.129 | 84.8 - 89.4
 | Franklin | 100 | 1205 | 80.1016 | 71.7 - 88.5
 | Hancock | 160 | 1944 | 82.8432 | 76.7 - 89.0
 | Kennebec | 405 | 4931 | 75.1278 | 70.8 - 79.5
 | Knox | 132 | 1727 | 81.3954 | 74.4 - 88.4
 | Lincoln | 97 | 1210 | 80.7781 | 72.7 - 88.8
 | Oxford | 184 | 2315 | 76.4158 | 70.2 - 82.7
 | [NAME] | 508 | 5779 | 79.0148 | 75.2 - 82.8
 | Piscataquis | 45 | 496.1532 | 69.9911 | 57.0 - 83.0
 | Sagadahoc | 145 | 1728 | 84.1865 | 77.9 - 90.5
 | Somerset | 156 | 1840 | 73.2869 | 66.3 - 80.3
 | [NAME] | 160 | 2054 | 80.4436 | 74.4 - 86.5
 | Washington | 96 | 1164 | 72.2901 | 63.3 - 81.3
 | York | 556 | 6515 | 86.3156 | 83.2 - 89.5
Public Health District
 | Aroostook | 224 | 2789 | 73.3433 | 67.5 - 79.2
 | Central | 561 | 6770 | 74.6186 | 70.9 - 78.3
 | Cumberland | 1032 | 12260 | 87.129 | 84.8 - 89.4
 | Downeast | 256 | 3108 | 78.5472 | 73.3 - 83.8
 | [NAME] | 534 | 6719 | 81.6841 | 78.3 - 85.1
 | Penquis | 553 | 6275 | 78.2175 | 74.6 - 81.9
 | Western | 686 | 8129 | 78.6134 | 75.4 - 81.9
 | York | 556 | 6515 | 86.3156 | 83.2 - 89.5
Data Source:  Pregnancy Risk Assessment Monitoring System. n=unweighted number of adults (numerator). N=weighted number of adults (weighted numerator). All %'s are weighted to be more representative of the general adult population of Maine and to adjust for non-response. 95% CI = 95% Confidence Interval. Use caution in interpreting percentages with an unweighted numerator or denominator less than 50.
Spreadsheet: 223171d1364085046-conditional-formatting-based-on-alternate-and-matching-values-footy-2013_2
Sheet: Sheet1

HOFFY'S 2013 FOOTY TIPPING CONTEST |  |  |  | WEEKLY POINTS
Position | Prize | Total | NAME | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23
1 | 750 | 22 | CHRIS P | 8 | 7 | 7
2 | 500 | 18 | CHERYL | 4 | 6 | 8
3 | 250 | 16 | AUNTY ROSE | 6 | 4 | 6
4 |  | 16 | CHERILEE | 7 | 5 | 4
5 |  | 15 | AUDREY | 5 | 3 | 7
6 |  | 15 | BELINDA H | 5 | 5 | 5
7 |  | 0
8 |  | 0
9 |  | 0
10 |  | 0
11 |  | 0
12 |  | 0
13 |  | 0
14 |  | 0
15 |  | 0
16 |  | 0
17 |  | 0
18 |  | 0
19 |  | 0
20 |  | 0
21 |  | 0
22 |  | 0
23 |  | 0
24 |  | 0
25 |  | 0
26 |  | 0
27 |  | 0
28 |  | 0
29 |  | 0
30 |  | 0
31 |  | 0
32 |  | 0
33 |  | 0
34 |  | 0
35 |  | 0
36 |  | 0
37 |  | 0
38 |  | 0
39 |  | 0
40 |  | 0
41 |  | 0
42 |  | 0
43 |  | 0
44 |  | 0
45 |  | 0
46 |  | 0
47 |  | 0
48 |  | 0
49 |  | 0
50 |  | 0
51 |  | 0
52 |  | 0
53 |  | 0
54 |  | 0
55 |  | 0
56 |  | 0
57 |  | 0
58 |  | 0
59 |  | 0
60 |  | 0
61 |  | 0
62 |  | 0
63 |  | 0
64 |  | 0
65 |  | 0
66 |  | 0
67 |  | 0
68 |  | 0
69 |  | 0
70 |  | 0
71 |  | 0
72 |  | 0
73 |  | 0
74 |  | 0
75 |  | 0
76 |  | 0
77 |  | 0
78 |  | 0
79 |  | 0
80 |  | 0
81 |  | 0
82 |  | 0
83 |  | 0
84 |  | 0
85 |  | 0
86 |  | 0
87 |  | 0
88 |  | 0
89 |  | 0
90 |  | 0
91 |  | 0
92 |  | 0
93 |  | 0
94 |  | 0
95 |  | 0
96 |  | 0
97 |  | 0
98 |  | 0
99 |  | 0
100 |  | 0
Spreadsheet: 104969d1302452255-transform-2-column-table-into-1-column-of-data-numbered-list-to-column
Sheet: Sheet1

Account | Entries | helper: finds new start row of each account |  | result
Microsoft | 9 | 1 |  | Microsoft
Nike | 4 | 10 |  | Microsoft
Adidas | 12 | 14 |  | Microsoft
[NAME] | 3 | 26 |  | Microsoft
Oakley | 2 | 29 |  | Microsoft
martin | 10 | 31 |  | Microsoft
 |  |  |  | Microsoft
 |  |  |  | Microsoft
 |  |  |  | Microsoft
 |  |  |  | Nike
 |  |  |  | Nike
 |  |  |  | Nike
 |  |  |  | Nike
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Oakley
 |  |  |  | Oakley
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
Spreadsheet: 771711d1646811594-qr-code-time-date-location-over-two-sheets-checks-in_sample
Sheet: Sheet1

NAME | PHONE USED | DATE | TIME | ADDRESS | SUBURB |  | QR LOCATION DATA
Alina | Android Phone | 2022-03-08 00:00:00 | 20:28:39 | ADDRESS OF SITE IS HERE | ALBION | CHECK IN | QR LOCATION DATA
Yogendra | Android Phone | 2022-03-08 00:00:00 | 20:28:42 | ADDRESS OF SITE IS HERE | ALBION | CHECK IN | QR LOCATION DATA
[NAME] | iPhone | 2022-03-08 00:00:00 | 15:11:11 | ADDRESS OF SITE IS HERE | [NAME] | CHECK IN | QR LOCATION DATA
[NAME] | iPhone | 2022-03-08 00:00:00 | 18:01:21 | ADDRESS OF SITE IS HERE | BLAIR | CHECK IN | QR LOCATION DATA
Alina | iPhone | 2022-03-08 00:00:00 | 18:53:00 | ADDRESS OF SITE IS HERE | CHERMSIDE | CHECK IN | QR LOCATION DATA
Yogendra | iPhone | 2022-03-08 00:00:00 | 18:53:02 | ADDRESS OF SITE IS HERE | CHERMSIDE | CHECK IN | QR LOCATION DATA
Mohamed | iPhone | 2022-03-08 00:00:00 | 21:23:19 | ADDRESS OF SITE IS HERE | Cleveland | CHECK IN | QR LOCATION DATA
Nicole | iPhone | 2022-03-08 00:00:00 | 08:10:00 | ADDRESS OF SITE IS HERE | Dawson | CHECK IN | QR LOCATION DATA
[NAME] | iPhone | 2022-03-08 00:00:00 | 17:18:25 | ADDRESS OF SITE IS HERE | [NAME] | CHECK IN | QR LOCATION DATA
Spreadsheet: 151675d1335055298-need-help-with-formula-for-calculating-fees-based-on-product-selected-from-list-fees-1-
Sheet: Products

Product | Version | Price
Core CAL | Non-specific
Desktop Optimization Pack for SA | Non-specific
Enterprise CAL | Non-specific
Enterprise Desktop | Non-specific
Enterprise Desktop w MDOP | Non-specific
Office Professional | Non-specific
Office Professional Plus | Non-specific
Professional Desktop | Non-specific | 309.88
Professional Desktop w MDOP | Non-specific
Win | Non-specific
[NAME] | Non-specific | 64
Spreadsheet: 883942d1732736846-power-query-consolidating-data-pq-merge-queries
Sheet: Sheet1

PRODUCT CODE | PRODUCT NAME | SALES | [NAME] | PROFIT |  |  | PRODUCT CODE | PRODUCT NAME |  | PRODUCT CODE | PRODUCT NAME | SALES | [NAME] | PROFIT |  | PRODUCT CODE | COUNTRY | MANAGER | DEPUTY | SALES | [NAME] | PROFIT
AAA | PRODUCT AAA | 100 | 80 | 20 |  |  | AAA | PRODUCT AAA |  | AAA | PRODUCT AAA | 100 | 80 |  |  | EEE | UK | [NAME] | [NAME] | 500 | 400 | 100
BBB | PRODUCT BBB | 200 | 160 | 40 |  |  | BBB | PRODUCT BBB |  | BBB | PRODUCT BBB |  | 160 |  |  | FFF | USA | [NAME] | [NAME] | 600 | 480 | 120
CCC | PRODUCT CCC | 300 | 240 | 60 |  |  | CCC | PRODUCT CCC |  | CCC | PRODUCT CCC |  | 240 |  |  | GGG | JAPAN | Ringo | [NAME] | 700 | 560 | 140
DDD | PRODUCT DDD | 400 | 320 | 80 |  |  | DDD | PRODUCT DDD |  | DDD | PRODUCT DDD |  | 320 |  |  | HHH | CHINA | George | [NAME] | 800 | 640 | 160
EEE | PRODUCT EEE |  |  |  |  |  | EEE | PRODUCT EEE
FFF | PRODUCT FFF |  |  |  |  |  | FFF | PRODUCT FFF
GGG | PRODUCT GGG |  |  |  |  |  | GGG | PRODUCT GGG
HHH | PRODUCT HHH |  |  |  |  |  | HHH | PRODUCT HHH
Spreadsheet: 59930d1260456692-multiple-sheet-sum-question-sum-example
Sheet: 2003

 | January | February | March | April | May | June | July | August | September | October | November | December
Employee 1
Employee 2
Employee 3
Employee 4
Employee 5 |  |  |  |  |  | 54
Employee 6
Employee 7
Employee 8
Employee 9 |  | 84
Employee 10
Spreadsheet: 869847d1716392696-find-the-time-period-a-customer-returns-test-customer-aligw-1-
Sheet: Sheet1

 |  |  |  | Customer |  | Date |  |  | formula | What it should be
 |  |  |  | 6 |  | 2024-03-20 00:00:00 |  | 0 - 1 month |  | 5
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  | 1- 3 month | 2 | 2
 |  |  |  | 11 |  | 2024-01-09 00:00:00 |  | 3 - 6 month | 0 | 0
 |  |  |  | 11 |  | 2024-01-23 00:00:00 |  | 6 - 12 month | 1 | 1
 |  |  |  | 11 |  | 2024-02-02 00:00:00 |  | 12 - 24 month | 0 | 0
 |  |  |  | 11 |  | 2024-04-03 00:00:00 |  | 24+ | 0 | 0
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 22 |  | 2024-03-03 00:00:00
 |  |  |  | 22 |  | 2024-05-11 00:00:00
 |  |  |  | 33 |  | 2024-06-22 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 55 |  | 2024-02-22 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 55 |  | 2024-10-09 00:00:00