tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 728151d1618337561-formula-to-select-match-column-sample-data
Sheet: Data

 | Bonus Periods, Mgr's & Payments by Store
# | Store | 2021-13 |  | 2021-12 |  | 2021-11 |  | 2021-10 |  | 2021-09 |  | 2021-08 |  | 2021-07 |  | 2021-06 |  | 2021-05 |  | 2021-04 |  | 2021-03 |  | 2021-02 |  | 2021-01 |  |  | 2020-13 |  | 2020-12 |  | 2020-11 |  | 2020-10 |  | 2020-09 |  | 2020-08 |  | 2020-07 |  | 2020-06 |  | 2020-05 |  | 2020-04 |  | 2020-03 |  | 2020-02 |  | 2020-01
204 | Old Town |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Wyatt - GM | 1265 | 204,Wyatt - GM | 890 | 204,Wyatt - GM | 462 |  | 204,Wyatt - GM | 125 | 204,Wyatt - GM | 782 | 204,Wyatt - GM | 5734 | 204,Wyatt - GM | 465 | 726 | 654 | 204,Wyatt - GM | 345 |  |  |  |  |  |  |  |  |  |  |  | 132 | 204,Homer - GM | 82
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Sally | 558 | 204,Sally | 207 | 204,Sally | 231 |  | 204,Sally | 458 | 204,Sally | 73 | 204,Sally | 455 | 204,Sally | 354 | 204,Sally | 352 | 204,Sally | 422 |  |  |  |  |  |  |  |  |  |  | 204,Sally | 413 | 204,Sally | 458
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Judy | 558 | 204,Judy | 207 | 204,Judy | 231 |  | 204,Judy | 874 | 204,Judy | 5 | 204,Judy | 78 | 204,Judy | 25 | 204,Judy | 85 | 204,Judy | 23 |  |  |  |  |  |  |  |  |  |  | 204,Lenny | 4 | 204,Billy | 85
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Bob | 223 | 204,Bob | 83 | 204,Bob | 92 |  | 204,Bob | 875 | 204,Bob | 4 | 204,Bob | 78 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 204,Judy | 85 | 204,Lenny | 45
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
206 | New Town |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Lou | 1596 | 206,Lou | 1253 | 206,Lou | 1256
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Agnes | 658 | 206,Agnes | 376 | 206,Agnes | 378
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 206,Lucy | 0 | 206,Lucy | 151 | 206,Lucy | 151
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 0 |  | 0
 | deliver manager payment by time period
 | Active Managers
 | 204,Wyatt - GM
 | 204,Homer - GM
 | 204,Sally
 | 204,Judy
 | 204,Lenny
 | 204,Billy
 | 204,Bob
 | 206,Lou
 | 206,Agnes
 | 206,Lucy
 | 208,Olivia
 | 208,Harry
 | 208,Hermione
 | 210,Jerry - GM
Spreadsheet: 840474d1692767908-filtering-by-multiple-values-across-different-columns-extended-example
Sheet: Sheet1

Status | IsPlanned | IsPlanned | IsPlanned | Story Points
Resolved | scheduled | X | X | 1
Resolved | X | X | scheduled | 2
Resolved | X | unscheduled |  | 3
Resolved | unscheduled | X | X | 4
Resolved | unscheduled | X | X | 5
Other | scheulded |  |  | 6
 | Output
 | Tickets Completed | scheduled | unscheduled
 | 5 | 2 | 3
 | Story point completed
 | 15 | 3 | 12
How many tickets in total were  completed(status = "Resolved"), and how many of those were scheduled  & unscheduled work.
How many total story points were completed(status = "Resolved"), and how many of those were scheduled & unscheduled
Spreadsheet: 743510d1628568000-vlookup-2-conditions-dau-etaf
Sheet: Login

Date | User
2021-08-07 00:00:00 | [NAME]
2021-08-06 00:00:00 | [NAME]
2021-08-05 00:00:00 | [NAME]
2021-08-04 00:00:00 | [NAME] Nadeem
2021-08-02 00:00:00 | [NAME]
2021-08-02 00:00:00 | Rahmat
2021-08-01 00:00:00 | [NAME]
2021-07-30 00:00:00 | [NAME]
2021-07-30 00:00:00 | [NAME]
2021-07-29 00:00:00 | [NAME]
2021-07-28 00:00:00 | [NAME]
Spreadsheet: 858641d1707252273-create-spread-per-workweek-based-on-dataset-with-start-and-finish-dates-weekly-table-based-on-dates-excelforum
Sheet: Sheet1

Activity A | 2024-02-05 00:00:00 | 2024-02-12 00:00:00 |  | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00 | 2024-02-05 00:00:00 | 2024-02-12 00:00:00 | 2024-02-19 00:00:00
Activity B | 2024-01-29 00:00:00 | 2024-02-07 00:00:00 |  |  |  |  | Activity A | Activity A
Activity C | 2024-01-18 00:00:00 | 2024-02-20 00:00:00 |  |  |  | Activity B | Activity B
Activity D | 2024-01-31 00:00:00 | 2024-02-10 00:00:00 |  | Activity C | Activity C | Activity C | Activity C | Activity C | Activity C
 |  |  |  |  |  | Activity D | Activity D
Spreadsheet: cfb55d7c-d2b2-479e-a6b5-ad12e0e418dc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 |  | Enter your unequalized nearfield measurements in column C, this will create a blue plot
 |  | Enter your unequalized farfield (listening position) measurements in column F, this will create a magenta plot
 |  | Enter your equalized farfield (listening postion) measurements in column H, this will create a green plot
 |  | FREQ | Nearfield | RS Corrections | Farfield | RS Corrections | Farfield /EQ | RS Corrections
 |  | 16 | 70 | 81.5 | 75 | 86.5 | 80 | 91.5
 |  | 18 | 70 | 78 | 75 | 83 | 80 | 88
 |  | 20 | 70 | 77.5 | 75 | 82.5 | 80 | 87.5
 |  | 22 | 70 | 76.5 | 75 | 81.5 | 80 | 86.5
 |  | 25 | 70 | 75 | 75 | 80 | 80 | 85
 |  | 28 | 70 | 74 | 75 | 79 | 80 | 84
 |  | 31.5 | 70 | 73 | 75 | 78 | 80 | 83
 |  | 36 | 70 | 72.5 | 75 | 77.5 | 80 | 82.5
 |  | 40 | 70 | 72.5 | 75 | 77.5 | 80 | 82.5
 |  | 45 | 70 | 72 | 75 | 77 | 80 | 82
 |  | 50 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 56 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 63 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 71 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 80 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 89 | 70 | 71.5 | 75 | 76.5 | 80 | 81.5
 |  | 100 | 70 | 72 | 75 | 77 | 80 | 82
 |  | 111 | 70 | 71 | 75 | 76 | 80 | 81
 |  | 125 | 70 | 70.5 | 75 | 75.5 | 80 | 80.5
 |  | 142.5 | 70 | 70.5 | 75 | 75.5 | 80 | 80.5
 |  | 160 | 70 | 69.5 | 75 | 74.5 | 80 | 79.5
 |  |  | Measurements without EQ |  |  |  | Measurements with EQ
Spreadsheet: 73521d1274191136-choose-a-value-in-the-dropdown-and-make-formula-lookup-in-the-relevant-table-kpi-trial
Sheet: IDs

Shift |  | Parameter |  | DS1 | NS1 | DS2 | NS2 | 8E | 8L
DayShift1 |  | H |  | DayShift1 name1 | NightShift1 name1 | DayShift2 name 1 | NighShift2 name1 | Earlies name1 | Lates name1
NightShift1 |  | S |  | [NAME] | NightShift1 [NAME] | DayShift2 name 2 | NighShift2 [NAME] | Earlies [NAME] | Lates name2
DayShift2 |  | O |  | DayShift1 name3 | NightShift1 name3 | DayShift2 name 3 | NighShift2 name3 | Earlies name3 | Lates name3
NighShift2 |  | U |  | DayShift1 name4 | NightShift1 name4 | DayShift2 name 4 | NighShift2 name4 | Earlies name4 | Lates name4
Early8 |  |  |  | [NAME] | NightShift1 name5 | DayShift2 name 5 | NighShift2 [NAME] | Earlies name5 | [NAME]
[NAME] |  |  |  | DayShift1 name6 | NightShift1 name6 | DayShift2 name 6 | NighShift2 name6
 |  |  |  | DayShift1 name7 | NightShift1 name7 | DayShift2 name 7 | NighShift2 name7
 |  |  |  | DayShift1 name8 | NightShift1 name8 | DayShift2 name 8 | NighShift2 name8
 |  |  |  | DayShift1 name9 | NightShift1 name9 | DayShift2 name 9 | NighShift2 name9
 |  |  |  | [NAME] | NightShift1 name10 | DayShift2 name 10 | NighShift2 [NAME]
 |  |  |  | DayShift1 name11 | NightShift1 name11 | DayShift2 name 11 | NighShift2 name11
 |  |  |  | DayShift1 name12 | NightShift1 name12 | DayShift2 name 12 | NighShift2 name12
 |  |  |  | DayShift1 name13 | NightShift1 name13 | DayShift2 name 13 | NighShift2 name13
 |  |  |  | DayShift1 name14 | NightShift1 name14 | DayShift2 name 14 | NighShift2 name14
 |  |  |  | DayShift1 name15 | NightShift1 name15 | DayShift2 name 15 | NighShift2 [NAME]
 |  |  |  | [NAME] | NightShift1 [NAME] | DayShift2 name 16 | NighShift2 [NAME]
 |  |  |  | DayShift1 name17 | NightShift1 name17 | DayShift2 name 17 | NighShift2 name17
 |  |  |  | DayShift1 name18 | NightShift1 name18 | DayShift2 name 18 | NighShift2 name18
 |  |  |  | DayShift1 name19 | NightShift1 name19 | DayShift2 name 19 | NighShift2 name19
 |  |  |  | DayShift1 name20 | NightShift1 name20 | DayShift2 name 20 | NighShift2 [NAME]
 |  |  |  | DayShift1 name21 | NightShift1 name21 | DayShift2 name 21 | NighShift2 [NAME]
 |  |  |  | DayShift1 name22 | NightShift1 name22 | DayShift2 name 22 | NighShift2 name22
 |  |  |  | DayShift1 name23 | NightShift1 name23 | DayShift2 name 23 | NighShift2 name23
 |  |  |  | DayShift1 name24 | NightShift1 name24 | DayShift2 name 24 | NighShift2 [NAME]
 |  |  |  | DayShift1 name25 | NightShift1 name25 | DayShift2 name 25 | NighShift2 name25
 |  |  |  | DayShift1 name26 | NightShift1 [NAME] | DayShift2 name 26 | NighShift2 [NAME]
 |  |  |  | DayShift1 name27 | NightShift1 name27 | DayShift2 name 27 | NighShift2 name27
 |  |  |  | DayShift1 name28 | NightShift1 name28 | DayShift2 name 28 | NighShift2 [NAME]
 |  |  |  | DayShift1 name29 | NightShift1 name29 | DayShift2 name 29 | NighShift2 name29
 |  |  |  | DayShift1 name30 | NightShift1 name30 | DayShift2 name 30 | NighShift2 name30
 |  |  |  | DayShift1 name31 | NightShift1 name31 | DayShift2 name 31 | NighShift2 name31
Spreadsheet: 844219d1695969611-display-unique-values-with-a-count-for-a-date-range-unique-values-test-01
Sheet: Sheet1

NAME | DATE |  | NAME | Count
JOE | 2023-08-01 00:00:00 |  | JOE | 3
JOE | 2023-09-02 00:00:00 |  | SUE | 1
SUE | 2023-09-04 00:00:00 |  | MARK | 2
MARK | 2023-09-06 00:00:00 |  | LISA | 2
LISA | 2023-09-15 00:00:00
SUE | 2023-09-16 00:00:00
JOE | 2023-09-18 00:00:00
JOE | 2023-09-20 00:00:00
MARK | 2023-08-01 00:00:00
LISA | 2023-08-02 00:00:00
JOE | 2023-07-03 00:00:00
Spreadsheet: 14633ee9-166c-4e2f-91c2-f65824e8e99f
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 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
Cuadro 3.23-10-7
[NAME]
[NAME] ingresos y egresos [NAME] región [NAME] por sub-región y provincia, según año, 1998-2007
(Valor en RD$)
[NAME] | Total del [NAME] | Saldo según Sub Región Cibao Central | Saldo según provincia Espaillat | Saldo según [NAME] | Saldo según provincia Puerto Plata | Saldo según provincia Santiago | Saldo según [NAME] | Saldo según Sub Región Cibao Oriental | Saldo según [NAME] | Saldo según provincia [NAME] Sánchez | Saldo según provincia Salcedo | Saldo según provincia Samaná | Saldo según provincia [NAME] | Saldo según provincia Sub Región Cibao Occidental | Saldo según provincia Dajabón | Saldo según provincia Monte Cristi | Saldo según provincia Santiago Rodríguez | Saldo según provincia [NAME]
1998 | 28771848 | 19190015 | 1302101 | 1610524 | 804681 | 15737818 | -265109 | 9178448 | 7701283 | 989619 | 293314 | 259675 | -65443 | 403385 | 111642 | 760304 | -59621 | -408940
1999 | -27167014 | -31803896 | -1573184 | -7542402 | 3898994 | -27868212 | 1280908 | 5019534 | 3858839 | 9856 | 280070 | 143029 | 727740 | -382652 | -144743 | -4546 | 382629 | -615992
2000 | 6043075 | -2856749 | -1500967 | -1484446 | 896974 | -872535 | 104225 | 3240991 | 1499095 | 2528555 | -2410707 | 1210862 | 413186 | 5658833 | 409075 | 450289 | 445300 | 4354169
2001 | 370369060 | 305256906 | 6273812 | 10334287 | 25852440 | 260296314 | 2500053 | 37091295 | 7981543 | 6448422 | 6265872 | -1247641 | 17643099 | 28020859 | 588202 | 17150161 | 534809 | 9747687
2002 | 13479557 | 3336745 | -2389500 | -1764804 | 4329547 | 3336301 | -174799 | 5704218 | 0 | 5924849 | -605277 | 0 | 384646 | 4438594 | 335106 | 195314 | -1667620 | 5575794
2003 | 216397225 | 198307069 | 27343984 | 64386005 | 5531542 | 101539593 | -494055 | 9469863 | 22362451 | 4003883 | -4911321 | … | -11985150 | 8620293 | -546966 | 4717932 | 2879529 | 1569798
2004 | 56210340 | 46807903 | 22267202 | 25845486 | -4114991 | 2948503 | -138297 | -301905 | 3930395 | 2816256 | -2004132 | 564888 | -5609312 | 9704342 | 4863779 | 1697832 | -2833149 | 5975880
2005 | 127169277 | 125147267 | 59349593 | 64398545 | -2665942 | 7613807 | -3548736 | 14140976 | 1635846 | 29715213 | 1880921 | -6922788 | -12168216 | -12118966 | -8288857 | -4378697 | 294099 | 254489
2006 | 94435005.06 | 64560404.09999999 | 956944.99 | 33370169.45 | 16280029 | 1207148.66 | 12746112 | 16608976.06 | 2428691 | 14061933 | -2183746 | -444964 | 2747062.06 | 13265624.9 | 3058073 | 5515228.32 | 5930476.82 | -1238153.24
2007P | 137446926741.56 | 84553711172.4 | 2769030827.08 | 30370574945.26 | 21476463727.73 | 22100738754.12 | 7836902918.209999 | 36050329966.06 | 18746009120 | 304196473.03 | 8236278.439999998 | 8163871621 | 8828016473.59 | 16842885603.1 | 1517460026.96 | 5906512788.96 | 1576747077 | 7842165710.18
(P): [NAME] preliminares
Fuentes: [NAME] y la Liga Municipal Dominicana
Spreadsheet: 94257d1294128389-lookup-specific-values-according-to-unique-reference-replace-if-necessary-exportkeyed
Sheet: ItemIngredients

Key | Item | Ingredient | LowerLimit | UpperLimit | LowerSecLimit | UpperSecLimit
 | 3462.01 | [NAME] | 5 | 10 | 0 | 0
 | DIV4212C | TITANIUM | 0 | 0 | 0.018 | 0.023
 | 122/152 | TITANIUM | 0 | 0 | 0.018 | 0.023
 | 3462.01 | TITANIUM | 0 | 0 | 15 | 20
Spreadsheet: 159705d1338823354-how-to-remove-the-duplicate-from-a-data-sheet-repetetion
Sheet: Sheet1

 | SN NO | SIS NO | NOUN | QTY | VALUE |  | C O O | HS CODE | [NAME]
 | 1 | PKD48N | BOLT | 1 | 492 | 8 | CA | 8302.49.60 | 10704750
 | 2 | QKD48N | PANE OUTER | 1 | 250 | 0 | MX | 8803.30.00 | 10432019
 | 3 | SKD48N | PANE OUTER | 1 | 250 | 0 | CA | 8803.30.00 | 10432019
 | 4 | TKD48N | PANE OUTER | 1 | 250 | 0 | MX | 8803.30.00 | 10432019
 | 5 | UKD48N | PANE OUTER | 1 | 250 | 0 | CA | 8803.30.00 | 10432019
 | 6 | [NAME] | PANE OUTER | 1 | 250 | 0 | MX | 8803.30.00 | 10432019
 | 7 | WKD48N | PANE OUTER | 1 | 250 | 0 | US | 8803.30.00 | 10432019
 | 8 | WKD47R | COVER AY | 1 | 513 | 0 | US | 8803.30.00 | 10150902
 | 9
 |  |  |  |  |  |  | CA, MX,US
Spreadsheet: 767293d1644397208-split-data-from-sheet-into-multiple-sheets-based-on-code-sample-file
Sheet: Entry

Sr. No | Code | Description | UOM | Stock | Rate | Value
1 | COMPMAIN | Computer | Nos | 12 | 36000
2 | PRINMAIN | Printer | Nos | 1 | 12000
3
Spreadsheet: 50653d1250129321-how-to-switch-or-rotate-charactor-ptest
Sheet: Sheet5

week/month | Case#1 |  | 1 | 2 | 3 | 4 | 5 | 6
Data-1 | AB |  | A | B
Data-2 | [NAME] |  | G | S | Y | K
Data-3 | REA |  | R | E | A
Switch Charactors
Spreadsheet: 127481d1320363033-add-extra-rows-in-time-series-copy-of-rexc
Sheet: Sheet1

1.1 | 1 | 4829 | 1 | 1 | 4829 | 1.1
1.2 | 2 | 7547328 | 1 | 2 | 7547328 | 1.2
1.3 | 3 | 690239 | 1 | 3 | 690239 | 1.3
1.4 | 4 | 34332 | 1 | 4 | 34332 | 1.4
1.6 | 6 | 654 | 1 | 5 | 0 | 1.5
1.7 | 7 | 158208 | 1 | 6 | 654 | 1.6
1.8 | 8 | 1202 | 1 | 7 | 158208 | 1.7
2.1 | 1 | 324029 | 2 | 8 | 1202 | 1.8
2.3 | 3 | 102319 | 2 | 1 | 324029 | 2.1
2.4 | 4 | 3439 | 2 | 2 | 0 | 2.2
2.5 | 5 | 4509 | 2 | 3 | 102319 | 2.3
2.6 | 6 | 79070 | 2 | 4 | 3439 | 2.4
2.8 | 8 | 1301 | 2 | 5 | 4509 | 2.5
 |  |  |  | 6 | 79070 | 2.6
 |  |  |  | 7 | 0 | 2.7
 |  |  |  | 8 | 1301 | 2.8
Spreadsheet: 668383d1584789057-extracting-a-list-of-unfulfilled-orders-for-the-week-example-3-index-and-dropdownlist-1-new-vesion-isna
Sheet: Shop Orders

Shop Orders for this week |  | Yellow |  | Fulfilled Orders
 |  | Green |  | 3
 |  | select  shop |  | 7
 |  | select  shop |  | 15
Week Start | 2020-03-16 00:00:00 | Week Finish
Spreadsheet: 737160d1624254922-multiple-date-ranges-averae-journey-duration-excel-sample
Sheet: Sheet1

journey_id | touchpoint_timestamp | touchpoint_position
0002d166a3adb33691df618167ea04e3ccde86fb | 2021-01-03 19:22:32 | 1
0002d166a3adb33691df618167ea04e3ccde86fb | 2021-01-11 17:54:25 | 2
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:55:23 | 3
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:55:09 | 2
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:59:50 | 6
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:48:50 | 1
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:55:45 | 4
000562195e100a0b221000842a7d887ce44758c7 | 2021-02-06 17:59:24 | 5
000e95162a043bd92ff3a2ac4da0b4fa171d1c30 | 2021-01-24 13:12:23 | 1
000e95162a043bd92ff3a2ac4da0b4fa171d1c30 | 2021-01-24 13:14:39 | 2
000e95162a043bd92ff3a2ac4da0b4fa171d1c30 | 2021-01-25 11:48:49 | 4
000e95162a043bd92ff3a2ac4da0b4fa171d1c30 | 2021-01-24 23:34:10 | 3
00118ae23bf84b028fed1b3217c1a955e5a83ce7 | 2021-03-05 14:11:17 | 2
00118ae23bf84b028fed1b3217c1a955e5a83ce7 | 2021-03-05 14:21:31 | 3
00118ae23bf84b028fed1b3217c1a955e5a83ce7 | 2021-03-05 14:11:17 | 1
00118ae23bf84b028fed1b3217c1a955e5a83ce7 | 2021-03-05 14:21:31 | 4
0014cdb0687bcee55db31eef0eeaf8c473e25d1e | 2021-03-17 14:42:58 | 1
002598bee91be877d4ad460846a77ec9051f7111 | 2021-01-11 13:37:39 | 3
002598bee91be877d4ad460846a77ec9051f7111 | 2021-01-11 13:36:13 | 2
002598bee91be877d4ad460846a77ec9051f7111 | 2021-01-11 13:32:27 | 1
0027c24e0ef4b5c505eb45b282adf2c02fab85f9 | 2021-01-26 14:03:21 | 3
0027c24e0ef4b5c505eb45b282adf2c02fab85f9 | 2021-01-25 21:05:48 | 1
0027c24e0ef4b5c505eb45b282adf2c02fab85f9 | 2021-01-26 14:04:39 | 4
0027c24e0ef4b5c505eb45b282adf2c02fab85f9 | 2021-01-25 21:15:26 | 2
0031a0e11c63a46e119b9b5c13e05ee0243e43e1 | 2021-01-04 14:16:22 | 1
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-12 08:05:19 | 8
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-12 08:10:08 | 11
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-08 12:16:55 | 4
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-08 10:36:34 | 3
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-18 18:57:27 | 13
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-18 20:21:11 | 15
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-18 18:27:15 | 12
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-11 06:53:02 | 6
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-18 20:01:17 | 14
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-08 10:33:30 | 2
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-08 14:57:10 | 5
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-12 08:03:55 | 7
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-12 08:05:49 | 9
003bf5114a4fa05e96013be6f2b47045160f1750 | 2021-01-12 08:08:17 | 10
Spreadsheet: 298149d1392723875-ranking-based-on-criteria-category-scores
Sheet: Sheet1

 |  | Category Scores |  |  |  |  |  |  | Scale
 | Name | A | B | C | D | TOTAL |  |  | 3 | Best
 | [NAME] | 10 | 12 | 9 | 11 |  |  |  | 2 | Average
 | Mark | 12 | 14 | 4 | 13 |  |  |  | 1 | Worst
 | [NAME] | 13 | 18 | 5 | 15
 | [NAME] | 15 | 15 | 12 | 6
 | [NAME] | 14 | 16 | 15 | 1
 | [NAME] | 9 | 18 | 8 | 5
 | [NAME] | 7 | 19 | 10 | 15
 | [NAME] | 12 | 20 | 16 | 12
 | [NAME] | 15 | 22 | 14 | 13
 | Tyler | 18 | 11 | 13 | 16
 | [NAME] | 21 | 10 | 12 | 22
 | [NAME] | 16 | 14 | 15 | 20
Spreadsheet: 108436d1305528144-date-and-percentage-with-if-function-date-and-percentage
Sheet: Sheet1

Focus | Actual | Status
2011-06-27 00:00:00 | 0.4
2011-05-20 00:00:00 |  |  |  | - If Focus is blank then it would show nothing in the Status
 |  |  |  | - If Actual is 100% or any date then it would show DONE the Status
 |  |  |  | - If Focus is smaller than today date then it would show OVERDUE in the Status
2011-06-27 00:00:00 |  |  |  | - If Focus minus today date is smaller than 8 then it would show TO FINISH IN 7 DAYS in the Status
2011-06-20 00:00:00
2011-05-26 00:00:00
2011-05-20 00:00:00
2011-05-25 00:00:00 | 0.7
2011-05-15 00:00:00 | 1
2011-05-21 00:00:00
2011-06-20 00:00:00
2011-05-17 00:00:00 | 2011-05-14 00:00:00
2011-06-27 00:00:00
2011-06-05 00:00:00
2011-05-04 00:00:00 | 2011-05-09 00:00:00
2011-04-30 00:00:00 | 1
2011-05-07 00:00:00 | 2011-05-07 00:00:00
Spreadsheet: 121737d1316371375-vlookup-verification-sample-vlookup-help-
Sheet: Store3

vwx | 12
yz1 | 12
a1 | 11
a2 | 10
a3 | 9
m12 | 8
b233 | 7
ac1 | 6
mp12 | 5
abc | 4
def | 3
ghi | 2
jkl | 1
Spreadsheet: 100099d1298556944-dropdown-used-to-fill-in-remainder-of-form-help-turbinedoc_testreport-1-1-
Sheet: Report

Work Order #: |  |  |  |  | Results
Customer: |  |  |  |  | Accept
Serial Number: |  |  |  |  | Reject Low power
Model: | C47M |  |  |  | Reject Smoke
Run Number: |  |  |  |  | Reject Vibes
 |  |  |  |  | Reject Air Leaks
[NAME] |  |  |  |  | Reject Oil Leaks
As Received |  |  |  |  | Reject Rub
Repair |  |  |  |  | Reject Other
[NAME]
C47M Performance
Setting |  | Cruise C | Cruise B | Cruise A | [NAME] | Takeoff | 2.5 Min
SPEC GPTOT |  |  | 1113 | 1181 | 1230 | 1268
PRED SHP @ SPEC MGT
[NAME] SHAFT PWR |  |  | 450 | 540 | 600 | 650
% DELTA FROM SPEC PWR
Predicted SFC
[NAME] SFC |  |  | 0.643 | 0.609 | 0.594 | 0.584
% DELTA FROM SPEC SFC
Spreadsheet: 221645d1363630721-what-formula-used-to-scale-the-same-code-a-value-on-different-days-scalare-valore
Sheet: Foglio1

Code | color | order | Hours
112233 | yellow | 120 | 155
100360 | red | 250 | 100
23444 | green | 132 | 200
112233 | red
100360 | green
23444 | yellow
Spreadsheet: 774234d1648320800-need-sum-based-on-duplicate-ids-sample-data-gk-v2
Sheet: Data

Year | Week | ID | agent name | completion status | Missed call | Accepted call | Declined call | Date | Time |  |  | Status as per ID
2022 | 10 |  |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:34:34 |  | In Que
2022 | 10 |  | AG | Agent missed | 1 | 0 | 0 | 2022-03-09 00:00:00 | 12:30:42 |  | Missed
2022 | 10 |  | G | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 3:06:16 |  | Completed
2022 | 10 | 1606441 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:24:58 |  | In Que
2022 | 10 | 1606443 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:25:19 |  | In Que
2022 | 10 | 1606443 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 0:28:05 |  | Completed
2022 | 10 | 1607267 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:17 |  | In Que
2022 | 10 | 1607267 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:42 |  | Answered by Other Agent
2022 | 10 | 1607267 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 18:08:39 |  | Missed by Other Agent
2022 | 10 | 1607469 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:03 |  | In Que
2022 | 10 | 1607469 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:27 |  | Answered by Other Agent
2022 | 10 | 1607469 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 22:12:43 |  | Missed by Other Agent
2022 | 10 | 1608130 |  | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:01:30 |  | In Que
2022 | 10 | 1608130 | TW | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:00 |  | In Que
2022 | 10 | 1608130 | RF | Agent missed | 1 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:31 |  | Answered by Other Agent
2022 | 10 | 1608130 | AC | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 13:02:34 |  | Missed by Other Agent
2022 | 10 | 1615725 |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 14:53:19 |  | In Que
2022 | 10 | 1615725 | O | Completed | 0 | 1 | 0 | 2022-03-13 00:00:00 | 14:53:52 |  | Completed
2022 | 10 | 1615725 | TW | Agent declined | 0 | 0 | 1 | 2022-03-13 00:00:00 | 14:53:45 |  | Declined
 |  |  |  | if both F and G are 1 then For G the status will be "Missed by other agent"
Notes:
1. If C is blank and F, G, H are 0 then the status should be "In Que"
2. If C is blank and either F, G, H is 1 then status should be as per column title, "Missed", Accepted/Completed", "Declined".
3. If C is not blank and same ID is getting repeated on the rows then we need to check if both F, G are 1,
 | if only F is 1 then status will be "Missed",
 | if only G is 1 then status will be "Completed",
 | if both F and G are 1 then For G the status will be "Missed by other agent" and For F the status will be "Answered by other agent"
4. Then I need to get the sum G as per status "Answered by other agent" to identify out of total missed calls how many were answered.
5. The criteria will be A, B and D in Data sheet to get the final results as mentioned in the Required sheet.
6. if H is 1 then status will be "Declined" even if under the same ID it was completed by other agent.