tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 231978d1367284412-looking-to-try-to-group-data-together-before-i-pull-my-hair-out-sample-workbook
Sheet: Sheet1

Clip ID | File Name | 24 | 25 | 30 | 50 | 60 |  | 24 | 25 | 30 | 50 | 60
1111 | Project A 1-1-24.mov
1112 | Project A 1-1-25.mov
1113 | Project A 1-1-30.mov
1114 | Project A 1-1-50.mov
1115 | Project A 1-1-60.mov
1116 | Project A 1-2-25.mov
1117 | Project A 1-2-50.mov
1118 | Job A 1-1-24.mov
1119 | Job A 1-1-25.mov
1120 | Job A 1-1-30.mov
1121 | Job A 1-2-25.mov
1122 | Job A 1-2-30.mov
1123 | Job A 1-2-60.mov
 | Above is what I have at the moment
 | Below is what I want to achieve
Clip ID | File Name | 24 | 25 | 30 | 50 | 60
1111 | Project A 1-1-24.mov | 1111 | 1112 | 1113 | 1114 | 1115
1112 | Project A 1-1-25.mov | 1111 | 1112 | 1113 | 1114 | 1115
1113 | Project A 1-1-30.mov | 1111 | 1112 | 1113 | 1114 | 1115
1114 | Project A 1-1-50.mov | 1111 | 1112 | 1113 | 1114 | 1115
1115 | Project A 1-1-60.mov | 1111 | 1112 | 1113 | 1114 | 1115
1116 | Project A 1-2-25.mov |  | 1116 |  | 1117
1117 | Project A 1-2-50.mov |  | 1116 |  | 1117
1118 | Job A 1-1-24.mov | 1118 | 1119 | 1120
1119 | Job A 1-1-25.mov | 1118 | 1119 | 1120
1120 | Job A 1-1-30.mov | 1118 | 1119 | 1120
1121 | Job A 1-2-25.mov |  | 1121 | 1122 |  | 1123
1122 | Job A 1-2-30.mov |  | 1121 | 1122 |  | 1123
1123 | Job A 1-2-60.mov |  | 1121 | 1122 |  | 1123
Spreadsheet: 91754d1291407157-sumif-help-example
Sheet: A

 |  | Trn |  |  | Finalize
Account No. | Supplier's Name | [NAME] | Document | Amount | Mo/Da/Yr | EmplID | Employee Name
------------- | ------------------------ | --- | -------- | ---------------- | -------- | ------ | ------------------------------
[PHONE] | Hotel               Holi | TCD | 1 | 123 | 2010-11-30 00:00:00 | 30793 | Employee A
[PHONE] | Hotel               Holi | TCD | 1 | 20.91 | 2010-11-30 00:00:00 | 30793 | Employee B
[PHONE] | Hotel               Holi | TCD | 1 | 123 | 2010-11-30 00:00:00 | 30793 | Employee C
[PHONE] | Hotel               Holi | TCD | 1 | 20.91 | 2010-11-30 00:00:00 | 30793 | Employee D
Spreadsheet: 59624d1260217146-excel-2007-checking-a-range-of-dates-with-if-or-select-case-example1
Sheet: TA2009-06

FLEXIBLE SCHEDULE CERTIFICATION FORM
NAME: |  |  |  |  |  |  |  |  |  |  |  | Established Hours:
 |  |  |  |  |  |  |  |  |  |  |  | M |  |  | M:
ORG: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  |  |  |  |  |  |  |  |  |  |  | W |  |  | W:
PP Ending: |  |  |  |  |  |  |  |  |  |  |  | T: |  |  | T:
 |  | PP | 09-06 |  |  |  |  |  |  |  |  | F: |  |  | F:
 |  | Working Hours |  | Time in Duty Status |  |  |  | *Telework Hours |  | Credit Hours |  |  | [NAME]
Date |  | Arrive | [NAME] | Regular | Overtime | Comp | Holiday | Worked | Code | Earned | Used | Balance | Annual | Sick | Comp | LWOP | Other | Remarks
Previous Balance
S
M
T
W
T
F
S
S
M
T
W
T
F
S
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL PAYABLE HRS.
Totals
 | Employee Signature: |  |  |  |  |  |  |  |  |  | Supervisor Signature:
 |  |  |  |  |  |  |  |  |  |  |  | *Telework Indicator Codes
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | "Fixed" Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | C | 3 or more days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | F | 2 or fewer days per week at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | Code |  | “As Needed” Telework Agreement
 |  |  |  |  |  |  |  |  |  |  |  | I | Work performed at alternate work site
 |  |  |  |  |  |  |  |  |  |  |  | The Telework columns are to be left blank for those employees who did not work at an alternate worksite during the Pay Period.
MOST EMPLOYEES SHOULD HAVE NO BALANCE IN LWOP.
Spreadsheet: john_griffith__15800__10_22_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL X1 | EXP |  |  | 63.1 | 74 | 0.95 | 2001-10-16 14:40:00
 | CL Z1 | 22.5 | 240 | 250 | 53.4 | 55.6 | 0.77 | 2001-10-22 11:53:00
 | CL F2 | 22.5 | 352 | 365 | 51.8 | 53.7 | 0.75 | 2001-10-22 11:53:00
 | CL G2 | 22.5 | 430 | 440 | 49.9 | 51.1 | 0.71 | 2001-10-22 11:53:00
 | CL H2 | 22.5 | 465 | 480 | 46.9 | 48.4 | 0.67 | 2001-10-22 11:53:00
 | CL J2 | 22.5 | 485 | 505 | 43.8 | 45.6 | 0.63 | 2001-10-22 11:53:00
 | CL K2 | 22.5 | 515 | 530 | 42.2 | 43.4 | 0.61 | 2001-10-22 11:53:00
 | CL M2 | 22.5 | 520 | 545 | 39.6 | 41.5 | 0.57 | 2001-10-22 11:53:00
 | CL N2 | 22.5 | 540 | 550 | 38.4 | 39.1 | 0.55 | 2001-10-22 11:53:00
 | CL Q2 | 22.5 | 540 | 555 | 36.3 | 37.3 | 0.52 | 2001-10-22 11:53:00
 | CL U2 | 22.5 | 540 | 555 | 34.7 | 35.7 | 0.5 | 2001-10-22 11:53:00
 | [NAME] | 22.5 | 540 | 555 | 33 | 34 | 0.47 | 2001-10-22 11:53:00
 | [NAME] | 22 | 545 | 560 | 31.7 | 32.6 | 0.44 | 2001-10-22 11:53:00
 | CL M3 | 21.5 | 545 | 570 | 27.5 | 28.8 | 0.38 | 2001-10-22 11:53:00
 | CL Z3 | 21.5 | 545 | 570 | 24.6 | 25.7 | 0.34 | 2001-10-22 11:53:00
Spreadsheet: 890083d1741259714-do-sum-at-every-forth-row-data
Sheet: Sheet1

4
5
2
9 | 20
8
4
6
3 | 21
7
8
10
11 | 36
18
9
14
13 | 54
12
17
20
35 | 84
Spreadsheet: 200006d1355387315-pivot-count-values-greater-than-zero-pivot
Sheet: Pivot

Row Labels | Sum of Sales | Sum of Balance | CountBalance
ABC | 8811 | 37 | 4
BCD | 3772 | 115 | 5
CDE | 3245 | 149 | 4
Grand Total | 15828 | 301 | 13
Spreadsheet: 827937d1683128054-horizontal-table-that-need-to-be-converted-to-a-different-horizontal-table-okp-table-help
Sheet: Sheet1

County | Sub Tax Code ST | ST Description | State Tax Rate | Sub Tax Code CO | CO Description | County Tax Rate | [NAME] | Sub Tax Code CT | CO Description | City Tax Rate | A/R Sales Tax Payable Account
Adair, Stilwell | ST | State Tax Rate | 4.5 | CO | County Tax Rate | 1.75 |  | CT | City Tax Rate | 3.75 | 11500
Adair, West Siloam Springs | ST | State Tax Rate | 4.5 |  |  |  |  |  |  |  | 11500
Adair, West Siloam Springs | CO | County Tax Rate | 1.4 |  |  |  |  |  |  |  | 11500
Adair, West Siloam Springs | CT | City Tax Rate | 4.75 |  |  |  |  |  |  |  | 11500
Spreadsheet: 727176d1617743945-error-with-function-if-if-formula-doubt
Sheet: data2

 | Names
 | ANNAK
 | DORATAB
 | FLORENTYNA
 | HANNAHCA
 | JOANNAS
 | MARCIND
 | STEFVDH
 | BERNAC
 | DUYGUP
 | ERSANB
 | NEBIHK
 | NILAYTK
 | TARIKC
 | TUGBAT
 | HANNAHJ
 | KATERINAK
 | KLAUDIAK
 | LENKAP
 | MICHAELAP
 | JULIAB
 | NADEZHDAZ
 | ESTELLE
 | IELYZAVETA
 | MAGDALENAJ
 | MARIOG
 | VICTORB
 | VOLGAM
 | WERONIKAK
 | WOJCIECHK
 | CAROLINEM
 | CAROLINES
 | JAIMELEIGH
 | NARGIZAM
 | PAULAM
 | WENDYD
 | CDULAC
 | ELZBIETAP
 | JUSTYNAA
 | MARTYNAD
 | OLGAW
 | SYLVIEE
 | ALBERTPA
 | [NAME]
 | MONTSEP
 | ADRIANO
 | ANCAG
 | ARTURP
 | INGEH
 | PAMELAM
 | SUZANNER
Spreadsheet: 879129d1726579289-auto-number-generate-with-conditions-tps_srno_getdata1709-tpsdas-
Sheet: tbl_Data

Deno | Attribute | Value | Time | Rank
111 | [NAME] | 2024-01-01 00:00:00 |  |  |  |  | IF([@Attribute]="Receipt Dt",SUM([@Value],[@Deno]/10000),SUM([@Value],0.99))
111 | [NAME] | 2024-01-01 00:00:00
111 | Return Dt | 2024-01-01 00:00:00
111 | Return Dt | 2024-01-01 00:00:00
222 | [NAME] | 2024-01-01 00:00:00
222 | Return Dt | 2024-01-01 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
444 | [NAME] | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
444 | Return Dt | 2024-01-02 00:00:00
555 | [NAME] | 2024-01-02 00:00:00
555 | Return Dt | 2024-01-02 00:00:00
111 | [NAME] | 2024-01-04 00:00:00
222 | [NAME] | 2024-01-04 00:00:00
111 | Return Dt | 2024-01-05 00:00:00
Spreadsheet: 773224d1647710061-create-a-12-week-roster-12-hour-roster
Sheet: Sheet1

 | Week 1 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | Debbie
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | Scott
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | [NAME]
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | [NAME]
 | Week 2 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | [NAME]
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | Debbie
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | Scott
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | [NAME]
 | Week 3 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600 |  |  |  |  | [NAME]
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 |  |  | [NAME]
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600 | [NAME]
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800 | Debbie
 | 5 | 1800-0600 | 1800-0600 |  |  |  |  |  | Scott
 | Week 4 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800
 | 5 | 1800-0600 | 1800-0600
 | Week 5 | SAT | SUN | MON | TUE | WED | THU | FRI | STAFF
 | 1 | 0600-1800 | 0600-1800 | 1800-0600
 | 2 | 0600-1800 | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
 | 3 |  |  |  | 0600-1800 | 0600-1800 | 1800-0600 | 1800-0600
 | 4 |  |  |  |  |  | 0600-1800 | 0600-1800
 | 5 | 1800-0600 | 1800-0600
Spreadsheet: 702682d1604482489-vlookup-multiple-criteria-return-unique-values-sample
Sheet: Sheet2

Code | Country | Product | approval
X | Morocco | A | N/A
Y | Morocco | A | approved
Z | Morocco | A | N/A
P | Germany | B | approved
I | Israel | D | approved
L | Morocco | F | approved
K | Algeria | A | N/A
ZZ | Italy | F | N/A
W | Egypt | B | N/A
R | Senegal | G | N/A
U | Algeria | H | approved
P | Algeria | H | N/A
O | Morocco | H | N/A
T | Germany | B | N/A
Spreadsheet: 74363d1274891413-mpg-formula-using-reference-from-other-file-april-odometer-history
Sheet: ODOMETER HISTORY

FULLCRD | ODOM HIS
5443133 | 8888
5443135 | 0
5443138 | 490
5443139 | 478922
5443141 | 100991
5443147 | 12345
5443148 | 355995
5443149 | 924556
5443150 | 111570
5443152 | 330728
5443159 | 41004
5443161 | 231500
5443162 | 180997
5443163 | 125106
5443165 | 809149
5443168 | 144728
5443170 | 55208
5443172 | 0
5443173 | 157070
5443174 | 0
5443175 | 605444
5443196 | 209866
5443197 | 0
5443200 | 0
5443202 | 5033
5443206 | 14700
5443212 | 413301
5443213 | 270842
5443214 | 292630
5443215 | 166800
5443217 | 73297
5443218 | 270610
5443221 | 168000
5443222 | 108681
5443223 | 151312
5443240 | 839033
5443242 | 396100
5443243 | 300942
5443244 | 292509
5443245 | 599993
5443246 | 287741
5443247 | 929102
5443248 | 301152
5443249 | 159985
5443250 | 121604
5443251 | 386407
5443252 | 279800
5443253 | 295877
5443254 | 147310
5443255 | 282335
5443256 | 212902
5443257 | 353611
5443258 | 565680
5443259 | 242234
5443260 | 900000
5443261 | 333000
5443265 | 773879
5443266 | 298634
5443269 | 455858
5443270 | 197984
5443271 | 297353
5443292 | 533697
5443293 | 132500
5443482 | 240030
5443579 | 925666
5443582 | 579592
5443583 | 376296
5443584 | 427225
5443585 | 0
5443586 | 138691
5443587 | 162747
5443588 | 725828
5443766 | 244550
5443908 | 3
5797423 | 295067
5797604 | 273710
5798033 | 620013
5798786 | 169871
5799019 | 10
5799489 | 245607
5799682 | 313041
6086423 | 714
6086558 | 306472
6086559 | 301131
6086713 | 299359
6086789 | 221211
6342770 | 1
6570866 | 208864
6660110 | 6298
Spreadsheet: 64707d1265512199-excel-2007-if-formula-for-several-values-john_g
Sheet: Sheet1

Random Label | Multiplier #1 | Product |  |  |  | Multiplier #2 |  |  | Label Pick List
B | 89 | 178 |  |  |  | 2 |  |  | B
 |  |  |  |  |  | 3 |  |  | C
 |  |  |  |  |  | 7 |  |  | D
 |  |  |  |  |  | 11 |  |  | E
 |  |  |  |  |  | 13 |  |  | M
 |  | NOTE: The random label is B, the number to be multiplied is 89
 |  | B is number 1 in the pick list, so the corresponding multiplier is 2
 |  | 89 X 2 = 178
 |  | Press F9
Spreadsheet: 79259d1279551599-convert-data-from-columns-to-rows-sample
Sheet: Sheet1

How it currently looks
Customer | Product | type | address | city | state | zip | Fax#
[NAME]'s Plumbing | Pipe | prod1 | 123 West St | St. Louis | Mo | 61211 | [PHONE]
[NAME]'s Plumbing | Cable | prod2 | 124 West St | St. Louis | Mo | 61212 | [PHONE]
[NAME]'s Plumbing | [NAME] | prod3 | 125 West St | St. Louis | Mo | 61213 | [PHONE]
[NAME]'s Plumbing | Rope | prod4 | 126 West St | St. Louis | Mo | 61214 | [PHONE]
[NAME]'s Irrigation | [NAME] | prod1 | 127 West St | St. Louis | Mo | 61215 | [PHONE]
Joes's Mechanical | Cable | prod1 | 128 West St | St. Louis | Mo | 61216 | [PHONE]
Joes's Mechanical | Pipe | prod2 | 129 West St | St. Louis | Mo | 61217 | [PHONE]
Joes's Mechanical | [NAME] | prod3 | 130 West St | St. Louis | Mo | 61218 | [PHONE]
How I want it to look after conversion
Customer | Product | type | address | city | state | zip | Fax# | prod1 | prod2 | prod3 | prod4
[NAME]'s Plumbing | Pipe | prod1 | 123 West St | St. Louis | Mo | 61211 | [PHONE] | Pipe | Cable | [NAME] | Rope
[NAME]'s Plumbing | Cable | prod2 | 124 West St | St. Louis | Mo | 61212 | [PHONE]
[NAME]'s Plumbing | [NAME] | prod3 | 125 West St | St. Louis | Mo | 61213 | [PHONE]
[NAME]'s Plumbing | Rope | prod4 | 126 West St | St. Louis | Mo | 61214 | [PHONE]
[NAME]'s Irrigation | [NAME] | prod1 | 127 West St | St. Louis | Mo | 61215 | [PHONE] | [NAME]
Joes's Mechanical | Cable | prod1 | 128 West St | St. Louis | Mo | 61216 | [PHONE] | Cable | Pipe | [NAME]
Joes's Mechanical | Pipe | prod2 | 129 West St | St. Louis | Mo | 61217 | [PHONE]
Joes's Mechanical | [NAME] | prod3 | 130 West St | St. Louis | Mo | 61218 | [PHONE]
Final Spreadsheet
Customer | Product | type | address | city | state | zip | Fax# | prod1 | prod2 | prod3 | prod4
[NAME]'s Plumbing | Pipe | prod1 | 123 West St | St. Louis | Mo | 61211 | [PHONE] | Pipe | Cable | [NAME] | Rope
[NAME]'s Irrigation | [NAME] | prod1 | 127 West St | St. Louis | Mo | 61215 | [PHONE] | [NAME]
Joes's Mechanical | Cable | prod1 | 128 West St | St. Louis | Mo | 61216 | [PHONE] | Cable | Pipe | [NAME]
Spreadsheet: 873359d1719862517-two-formulas-test-copy
Sheet: Tab 1

Date | 1 | 2 | 3 | 4 | 5 | 6
Test Date 1 | 1 | 4 | 5 | 8 | 10 | 6
Test Date 2 | 3 | 2 | 3 | 4 | 5 | 45
Test Date 3 | 9 | 9 | 9 | 9 | 9 | 9
Test Date 4 | 3 | 7 | 15 | 27 | 35 | 40
Test Date 5 | 3 | 7 | 15 | 27 | 35 | 40
Spreadsheet: 700293d1603118638-totals-from-two-different-tabs-into-a-third-tab-of-the-same-workbook-ledger-example
Sheet: Checking Account

Due Date | Checking Account Activity | Debit/Credit | Ref #
January
2020-01-01 00:00:00 | Mortgage | -1000 | 1
2020-01-01 00:00:00 | Electric | -200 | 2
2020-01-05 00:00:00 | Gas | -75 | 3
2020-01-15 00:00:00 | Phone | -50 | 4
2020-01-17 00:00:00 | [NAME] | -8 | 8
2020-01-20 00:00:00 | Cable | -100 | 5
2020-01-21 00:00:00 | Dining Out | -50 | 6
February
2020-02-01 00:00:00 | Mortgage | -1200 | 1
2020-02-01 00:00:00 | Electric | -180 | 2
2020-02-05 00:00:00 | Gas | -75 | 3
2020-02-15 00:00:00 | Phone | -50 | 4
2020-02-16 00:00:00 | [NAME] | -8 | 8
2020-02-20 00:00:00 | Cable | -100 | 5
2020-02-27 00:00:00 | Dining Out |  | 6
March
2020-02-01 00:00:00 | Mortgage | -600 | 1
2020-02-01 00:00:00 | Electric | -150 | 2
2020-02-05 00:00:00 | Gas | -72 | 3
2020-02-15 00:00:00 | Phone | -45 | 4
2020-02-16 00:00:00 | [NAME] | -9 | 8
2020-02-20 00:00:00 | Cable | -96 | 5
2020-02-27 00:00:00 | Dining Out | -45 | 6
April
2020-02-01 00:00:00 | Mortgage | -600 | 1
2020-02-01 00:00:00 | Electric | -150 | 2
2020-02-05 00:00:00 | Gas | -72 | 3
2020-02-15 00:00:00 | Phone | -45 | 4
2020-02-16 00:00:00 | [NAME] | -9 | 8
2020-02-20 00:00:00 | Cable | -96 | 5
2020-02-27 00:00:00 | Dining Out | -45 | 6
Spreadsheet: 781329d1653232031-data-table-to-work-with-reference-to-pivot-table-pivot-table-and-data-table
Sheet: Sheet1

Source data |  |  |  |  | Pivot Table |  |  |  |  | Data table
CSO | bw backlog
H5806A14 | 50
H5806A199 | 10
[NAME]
H5806A24 | 30 |  |  | bw backlog | CSO | bw | CSO | 20.May | 21.May | 22.May | 23.May | 24.May
H5806A299 |  |  |  | 10 | H5806A199 | 10 |  | 5 |  | 5
H5815A11 | 20 |  |  | 20 | H5815A11 | 20 |  |  | 10 |  | 10
H5815A12 |  |  |  |  | H5856A117 | 20 |  | 5 | 5 | 5 | 5
[NAME] |  |  |  | 30 | H5806A24 | 30
H5856A117 | 20 |  |  | 50 | H5806A14 | 50 |  | 15 | 15 | 15
H5856A118 |  |  |  | 60 | H5856A153 | 60 |  | 12 | 12 | 12 | 12 | 12
H5856A153 | 60
 |  |  |  | Requirement:
 |  |  |  | My source data is huge and rows increases day by day.  For better visibility of only BALANCE rows, a pivot table is made and distributed into days.
 |  |  |  | Above Data table should change with reference to the Pivot Table (i.e. when the [NAME] table increases or decreases, data table also should change .
 |  |  |  | Is there a way out.
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 13a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 1129110 | 1129110
Asia | - | 20 | 20
Europe | - | 551061 | 551061
North America | - | 578029 | 578029
Other | - | - | -
Index | 2276704 | 5495524 | 7772228
Asia | - | 129568 | 129568
Europe | 902661 | 2569120 | 3471781
North America | 1354524 | 2513880 | 3868404
Other | 19519 | 282956 | 302475
Other | - | 518014 | 518014
Exotic | - | 53204 | 53204
Swaptions | - | 464534 | 464534
Total Return Swap | - | 276 | 276
TOTAL | 2276704 | 7142648 | 9419352
Spreadsheet: 723695d1615839806-take-multiple-data-points-from-a-row-by-searching-on-the-first-column-row_array_issuesumproduct
Sheet: Sheet1

 | Selected Date | 2021-03-10 00:00:00
 |  | Fred | [NAME] | Rebecca | [NAME] | An Ni | Juan | Olive | Vince
 | 2021-03-08 00:00:00 | 0 | 121 | 0 | 0 | 0 | 0 | 0 | 8
 | 2021-03-09 00:00:00 | 0 | 63 | 0 | 0 | 0 | 0 | 58 | 91
 | 2021-03-10 00:00:00 | 0 | 27 | 0 | 0 | 0 | 26 | 22 | 26
 | 2021-03-11 00:00:00 | 0 | 59 | 0 | 0 | 0 | 64 | 27 | 40
 | 2021-03-12 00:00:00 | 0 | 43 | 0 | 0 | 41 | 11 | 12 | 48
 | Ideal Outcome | Fred
 |  | [NAME]
 |  | Rebecca
 |  | [NAME]
 |  | An Ni
 |  | Juan
 |  | Olive
 |  | Vince
Spreadsheet: jeff_dasovich__14124__FIN group project2
Sheet: chart data

 |  | % win
Spreadsheet: 685798d1594205072-last-6-months-rolling-sum-2020-07-08-oeldere-willhh3-pbi-685717d1594152040-last-6-months-rolling-sum-rolling-sum
Sheet: Sheet1

Name | jan 2020 | feb 2020 | mrt 2020 | apr 2020 | mei 2020 | jun 2020 | jul 2020 | aug 2020 | sep 2020 | okt 2020 | nov 2020 | dec 2020 | Uses Last 6 Months | Uses Last 3 Months | YTD AVG Usese |  |  | Expected Values in N
[NAME] | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 2
Sue | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 5
[NAME] | 2 | 1 | 0 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 10
[NAME] | 3 | 0 | 35 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 39
Sara | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 0
[NAME] | 0 | 4 | 0 | 45 | 31 | 10 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 90
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 months from last full month (June)
Would like a formula that is rolling off Today (). |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Using EDATE
Start date is 6 months back to the most current full month.  For now that would be Jan to Jun. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End date
Sum if between the Start date (1/1/2020) and the end date (6/30/2020) (or would that be 7/1?) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start date
Been tinkering with:
=SUMIFS(B2:M2,B1:M1,"<="&R11,B1:M1,">="&R12)
Which just gets me zero
Tried every combination I could find.  No luck.  Looking for a roling 6 months (and 3)
Spreadsheet: 766739d1644027253-sumif-with-wildcard-drop-0-iec_03
Sheet: IC

1 | RU-AA11_x001C_
2 | RU-AA12_x001C_
3 | [NAME]_
4 | RU-AA22_x001C_
5 | RU-AA31_x001C_
6 | [NAME]_
7 | RU-AB11_x001C_
8 | [NAME]_
9 | RU-AB21_x001C_
10 | RU-AB22_x001C_
11 | RU-AB31_x001C_
12 | RU-AB32_x001C_
13 | RU-AC11_x001C_
14 | RU-AC12_x001C_
15 | RU-AC21_x001C_
16 | [NAME]_
17 | RU-AC31_x001C_
18 | RU-AC32_x001C_
19 | RU-ADM11_x001C_
20 | RU-ADM12_x001C_
21 | RU-ADM21_x001C_
22 | RU-ADM22_x001C_
23 | RU-ADM31_x001C_
24 | RU-ADM32_x001C_
25 | RU-ADM41_x001C_
26 | RU-ADM42_x001C_
27 | RU-AUD11_x001C_
28 | [NAME]_
29 | RU-AUD31_x001C_
30 | RU-CAF11_x001C_
31 | RU-T11_x001C_
32 | RU-T12_x001C_
33 | RU-T21_x001C_
34 | RU-T22_x001C_
35 | RU-T31_x001C_
36 | RU-T32_x001C_
37 | RU-T33_x001C_
38 | RU-T34_x001C_
39 | RU-T35_x001C_
40 | RU-T36_x001C_
41 | RU-T37_x001C_
Spreadsheet: 779659d1651946965-extract-path-names-from-list-of-full-pathnames-sample-szyfrow-
Sheet: Blad1

 | . | Pictures | Photos - 2 | PHOTOS DUMP | 44652 | IMG_3637.jpg
 | . | Pictures | Photos iPhone | Photos 2020-2021 | BPQC6806.jpg
 | . | Pictures | Image 6872.jpg
 | . | Library | Mail | V2 | xyz | [Gmail].mbox | All messages.mbox | abc | Data | 4 | 1 | Attachments | 14132 | 17 | image026.jpg
Spreadsheet: 175215d1345462308-rota-creation-job-type-vs-2-shift-work-schedule-example-of-rota
Sheet: w}20- Aug - week 2

 | Job type |  |  |  | Job Type
Monday 20 August
Holidays
Additional notes
AM | Person Responsible for Job
PM (starting at 1pm unless specified) |  |  |  |  |  | Person Responsible for Job
Tuesday 21 August
Holidays
Additional notes
AM
PM (starting at 1pm unless specified)
Wednesday 22 August
Holidays
Additional notes:
AM
PM (starting at 1pm unless specified)
Thursday 23 August
Holidays
Additional notes
AM
PM (starting at 1pm unless specified)
Friday 24 August
Holidays
Additional notes
AM
PM (starting at 1pm unless specified)
Spreadsheet: 696872d1601020700-sumproduct-with-indirect-mainsheet
Sheet: 3.CC

Particulars | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | FY-20 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | FY-21
Production Qty | 120
Production Cost
Material Cost
Fuel Cost
Power Cost | 25
Spreadsheet: 153753d1336045241-counting-the-number-of-peaks-in-a-column-of-data-book1_wirral-wizard
Sheet: Sheet1

Data | Helper | Peaks
100 | 2 | 100
94.96 |  | 101.17
101.17 | 4 | 110.03
110.03 | 5 | 110.5
110.5 | 6 | 111.01
107.46 |  | 111.33
106.88 |  | 119.95
111.01 | 9 | 122.04
111.33 | 10 | 124.18
119.95 | 11 | 130.86
122.04 | 12 | 134.89
124.18 | 13
130.86 | 14
123.98
119.87
126.36
126.87
126.44
128.54
128.21
117.48
109.96
118.36
112.93
115.44
123.76
129.2
134.89 | 29