tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 58450d1258676358-pulling-multiple-and-varied-of-rows-from-one-sheet-into-another-incentive-payment-report4
Sheet: Data

Div | Sales person | Sold to cust | Name | Ext Sales $ | OCTOBER INCENTIVE SALES BASE | Sales terr | Cust type | Curr code | Cust type 2
31 | 221 | S018 | AAA | 23164.8 | 23164.8 | 32 | L | CD | Dealer
31 | 221 | S023 | BBB | 212 | 212 | 32 | L | CD | Dealer
31 | 221 | S029 | CCC | 4156757.3 | 4156757.3 | 32 | L | CD | Dealer
31 | 221 | S114 | DDD | 324647.7 | 324647.7 | 32 | L | CD | Dealer
31 | 343 | 100550 | EFG | 3467 | 3467 | 32 | L | CD | Dealer
31 | 980 | 100900 | EAS | 5467676 | 5467676 | 32 | K | CD | Retail
31 | 582 | 105700 | TEA | 5704.56 | 5704.56 | 32 | S | CD | Dealer
31 | 456 | 110100 | HTY | 396.25 | 396.25 | 32 | K | CD | Retail
31 | 584 | 110600 | HJUT | 959.2 | 959.2 | 32 | K | CD | Retail
31 | 996 | 170700 | FGH | 14647 | 14647 | 32 | K | CD | Retail
31 | 114 | 176601 | RT5 | 41677 | 41677 | 32 | S | CD | Dealer
31 | 333 | 178900 | MGH | 19016.99 | 19016.99 | 32 | S | CD | Dealer
31 | 894 | A07084 | SDTR | 13038.37 | 13038.37 | 33 | K | CD | Retail
31 | 841 | A07185 | ASER | 14689.49 | 14689.49 | 34 | K | CD | Retail
31 | 848 | A07221 | SDFG | 19023.16 | 19023.16 | 35 | K | CD | Retail
31 | 867 | A07244 | FTW | 1093.98 | 1093.98 | 36 | K | CD | Retail
31 | 845 | A07286 | NFK | 2658.24 | 2658.24 | 37 | K | CD | Retail
31 | 892 | 110200 | KGK | -500 | -500 | 38 | K | CD | Retail
31 | 847 | 123200 | UIOY | 10314.96 | 10314.96 | 39 | 5 | CD | Retail
31 | 868 | 131000 | SDFF | 88031.09 | 88031.09 | 40 | 5 | CD | Retail
31 | 849 | 135005 | NMVB | 889.2 | 889.2 | 41 | 4 | CD | Dealer
31 | 881 | 135043 | QWER | 11199.95 | 11199.95 | 42 | 4 | CD | Dealer
31 | 869 | 145500 | YUI | 46144.48 | 46144.48 | 43 | H | CD | Dealer
31 | 842 | 45879 | ASLDK | 464767.8 | 464767.8 | 44 | K | CD | Retail
31 | 893 | 365689 | KASDI | 45475670 | 45475670 | 45 | L | CD | Dealer
31 | 843 | 464548 | AJDF | 167721.8 | 167721.8 | 46 | S | CD | Dealer
Spreadsheet: 175778d1345645642-how-to-update-a-summary-table-for-different-data-subsets-sample-report
Sheet: required report format

 |  | 2012 Survey Score | Previous Survey Score | Movement from previous survey
 | Survey Q1 | 0.5
 | Survey Q2 | 0.625
 | Survey Q3 | 0.40625
 | Survey Q4 | 0.75
 | Survey Q5 | 0.40625
 | Survey Q6 | 0.40625
 | Survey Q7 | 0.5
 | Survey Q8 | 0.75
 | Overall Scale Score | 0.54296875
Spreadsheet: 872738d1719148560-tracking-financial-achievement-logic-and-formula-are-needed-stretch-goal_suppliers_w_comments-1-
Sheet: Excel Forum

Finally agreed contract with supplier, Price (MIKA) | initially forecasted price (AEK) - only [NAME] | initially forecasted price with a financial task (AEK) | Overall Change | Financial Task | Financial Task NOT achieved | Financial Task achieved | Financial Task OVERachieved
MIKA | AEK | AEK w/SG
1100 | 1000 |  |  | 100 |  |  |  | Product Category 1
1000 | 1000 |  |  | 100 |  |  |  | Product Category 2
950 | 1000 |  |  | 100 |  |  |  | Product Category 3
900 | 1000 |  |  | 100 |  |  |  | Product Category 4
850 | 1000 |  |  | 100 |  |  |  | Product Category 5
600 | 1000 |  |  | 100 |  |  |  | Product Category 6
500 | 800 |  |  | 50 |  |  |  | Product Category 7
550 | 600 |  |  | 70
1300 | 1000 |  |  | 0
numbers manually entered | numbers manually entered | calculated | calculated | numbers manually entered | For results in the column "F" (task not achieved):  - if  "E" = 0, -> result in ZERO (row 12) - if "D" is a negative number, then result in ZERO (example - row 9,10);   - if "D" is ZERO, "[NAME], result in ZERO (row7)   Otherwise, compare column "E" to column "D"):  - if "D" is a positive number and larger than "E" -> result in "E" (FT). in this example it is 100 (row 4) -  which means , the result in this column may equal [NAME]. column "E" itself).  - if "D" is a positive number and is smaller than "E" -> result in "A minus C"  (see row 6, row 11). - if "D" is a positive number and equals "E", result in ZERO (row 5).   please mind that there is no order (1->2->3 etc.) in fullfilling these criteria, so assumingly I cannot use IFS-function. | For column "G" (task ACHIEVED):   - if  "E" = 0, -> result in ZERO (row 12);   - if "B - A" = "E", -> result in "E" (row 7);  - if [NAME] and D>=E, result in ZERO (see row 4 and 5);  - if D>0 and D<E, result in "E-D" (see row 6 and row 11);   - if D is a negative number and "-D"<"B-A" (row 8, 9), then result in "E".  If no: XXXXX  pls note as a check: sum of G and H should equal to a difference "B" - "A". "G" cannot be higher than "E". Any overachievement should flow into "H".  pls note: sum of "F" und "G" cannot be higher than "E". (row 11)  please mind that there is no order (1->2->3 etc.) in fullfilling these criteria, so assumingly I cannot use IFS-function. | For column "H" (task  OVER-achieved) : - if  "E" = 0, -> result in ZERO.   - if  "D" >= 0, -> result in ZERO.  if  D < 0 and minus D<"B-A" then calculate "B-A" minus "G"
Spreadsheet: 599984d1543405223-formula-find-if-any-part-of-string-matches-an-array-of-words-excel-example
Sheet: Sheet1

Item | [NAME] | Expected result |  | [NAME]
1 legged dog | ?? | Yes |  | Dog
4 legged cat | ?? | Yes |  | Cat
[NAME] | ?? | Yes |  | Goat
cat 123 | ?? | Yes
dog | ?? | Yes
top dog 1 | ?? | Yes
560 dog | ?? | Yes
pop the dog | ?? | Yes
1 2 3 4 dog 6 7 | ?? | Yes
Goat 2 | ?? | Yes
68 goat | ?? | Yes
xxx | ?? | No
x | ?? | No
xxxx | ?? | No
sssss | ?? | No
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Gas Log

Gas Logistics
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90011635 | ADAMS, JACQUELINE | Spec SR Logistics | SPECSR-CS
90011615 | ALLWEIN, ROBERT | Spec SR Logistics | SPECSR-CS
90011638 | [NAME], NATALIE L | Spec SR Logistics | SPECSR-CS
90011331 | BOETTCHER, AMANDA C | Spec SR Logistics | SPECSR-CS
90129025 | BRADY, KEVIN S | Spec Logistics | SPEC-CS
90143126 | [NAME], BONNIE | Analyst - Rotation 1 | ANL-C
90011636 | CHRISTIANSEN, SUZANNE D | Spec SR Logistics | SPECSR-CS
90012423 | DRISCOLL-ERNEST, MARDE L | Mgr Logistics | MGR-CS
90011631 | ESPEY, DARREN | Trading Associate- Rotation 2 | ASSOC-C
90011947 | FARMER, [NAME] | Mgr Logistics | MGR-CS
90011639 | GAY, RANDALL L | Associate - Rotation 1 | ASSOC-C
90011684 | GOODELL, SCOTT E | Spec Sr Trading Supt | SPECSR-CS
90141655 | GROENEWOLD, SHANNON | Spec Logistics | SPEC-CS
90011621 | HANKS, CLARISSA O | Spec SR Logistics | SPECSR-CS
90011617 | HOMCO, MEREDITH L | Spec SR Logistics | SPECSR-CS
90011627 | KINSEY, [NAME] | Mgr Logistics | MGR-CS
90012077 | LAMADRID, VICTOR | Mgr Logistics | MGR-CS
90009931 | [NAME], TAMMY | Mgr e-Commerce | MGR-C
90011629 | LENART, KIRK D | Spec SR Logistics | SPECSR-CS
90010353 | LOVING, WILLIAM S | Spec Logistics | SPEC-CS
90131073 | MENDEL, SHELLY D | Spec Logistics | SPEC-CS
90011634 | MUZZY, [NAME] T | Mgr Logistics | MGR-CS
90012512 | OLINGER, KIMBERLY S | Mgr Logistics | MGR-CS
90128185 | OLSEN, [NAME] T | Analyst - Rotation 2 | ANL-C
90139475 | ORDWAY, CHRISTOPHER R | Spec Logistics | SPEC-CS
90011626 | PENDERGRASS, CORA | Spec SR Logistics | SPECSR-CS
90011864 | PINION, [NAME] R | Spec SR Logistics | SPECSR-CS
90011542 | SANCHEZ, CHRISTINA | Spec SR Logistics | SPECSR-CS
90011628 | SCHRAB, [NAME] | Spec SR Logistics | SPECSR-CS
90011637 | SULLIVAN, PATRICIA E | Mgr Logistics | MGR-CS
90011298 | SUPERTY, [NAME] | Dir Logistics | DIR-CS
90011618 | VERSEN, VICTORIA L | Associate - Rotation 1 | ASSOC-C
 |  | Employees
Spreadsheet: 805072d1668522225-divide-as-whole-number-and-allocate-to-month-column-book1-1-
Sheet: Sheet1

Item | Start Date | Finish Date | Months | Qty | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00
1 | 2023-02-01 00:00:00 |  | 3 | 70 |  | 23 | 23 | 24 | 0 | 0
2 | 2023-01-01 00:00:00 |  | 2 | 23 | 11 | 12 | 0 | 0 | 0 | 0
3 | 2023-04-01 00:00:00 |  | 3 | 14 | 0 | 0 | 0 | 4 | 4 | 6
4 | 2023-02-01 00:00:00 |  | 4 | 37 | 0 | 9 | 9 | 9 | 10 | 0
Spreadsheet: 99720d1298310287-add-cells-in-excel-criteria-price-product-list
Sheet: PrSales08

Product | Cost | Selling Price | jan | feb | [NAME] | apr | may | jun | jul | aug | sept | oct | nov | dec
1 | 0.5 | 0.625 | 278 | 283 | 180 | 302 | 252 | 66 | 202 | 152 | 343 | 159 | 304 | 366
2 | 4.9 | 6.125 | 54 | 52 | 295 | 354 | 383 | 392 | 115 | 153 | 387 | 185 | 292 | 223
3 | 2.87992 | 3.5999 | 316 | 6 | 166 | 44 | 47 | 344 | 63 | 40 | 58 | 68 | 318 | 332
4 | 2.87992 | 3.5999 | 342 | 117 | 190 | 145 | 309 | 224 | 141 | 58 | 368 | 325 | 330 | 300
5 | 2.75 | 3.4375 | 248 | 168 | 228 | 199 | 269 | 45 | 388 | 217 | 103 | 62 | 335 | 307
6 | 1.36 | 1.7 | 310 | 111 | 250 | 5 | 191 | 80 | 340 | 179 | 118 | 258 | 314 | 355
7 | 2.4 | 3 | 139 | 54 | 377 | 227 | 399 | 247 | 131 | 71 | 12 | 125 | 216 | 309
8 | 2.08 | 2.6 | 397 | 262 | 125 | 267 | 336 | 219 | 87 | 116 | 68 | 226 | 25 | 177
9 | 2.09 | 2.6125 | 168 | 347 | 117 | 128 | 112 | 382 | 112 | 214 | 59 | 196 | 56 | 143
10 | 3.02 | 3.775 | 277 | 242 | 324 | 51 | 142 | 117 | 292 | 113 | 74 | 281 | 202 | 297
11 | 3.99992 | 4.9999 | 272 | 228 | 4 | 237 | 178 | 263 | 330 | 335 | 130 | 354 | 171 | 41
12 | 4.8 | 6 | 9 | 329 | 324 | 261 | 13 | 290 | 143 | 268 | 352 | 318 | 337 | 277
13 | 1.12 | 1.4 | 29 | 201 | 374 | 397 | 9 | 148 | 207 | 349 | 94 | 309 | 302 | 191
14 | 1.24 | 1.55 | 32 | 384 | 198 | 178 | 207 | 93 | 218 | 394 | 371 | 272 | 386 | 140
15 | 1.4 | 1.75 | 12 | 229 | 181 | 159 | 193 | 369 | 187 | 58 | 321 | 85 | 249 | 127
16 | 1.44 | 1.8 | 87 | 81 | 292 | 10 | 216 | 319 | 281 | 96 | 110 | 258 | 354 | 50
17 | 3.2 | 4 | 282 | 128 | 40 | 233 | 322 | 248 | 99 | 167 | 65 | 111 | 351 | 260
18 | 1.24 | 1.55 | 280 | 67 | 274 | 64 | 16 | 38 | 249 | 150 | 331 | 373 | 4 | 394
19 | 1.68 | 2.1 | 87 | 84 | 339 | 305 | 233 | 111 | 387 | 48 | 108 | 75 | 131 | 14
20 | 1.8 | 2.25 | 105 | 216 | 197 | 116 | 369 | 25 | 305 | 27 | 107 | 19 | 21 | 396
21 | 1.96 | 2.45 | 300 | 211 | 214 | 6 | 165 | 331 | 304 | 330 | 386 | 99 | 339 | 71
22 | 2.04 | 2.55 | 282 | 74 | 305 | 250 | 236 | 104 | 211 | 256 | 66 | 356 | 119 | 121
23 | 1.68 | 2.1 | 225 | 20 | 135 | 326 | 137 | 317 | 378 | 132 | 268 | 70 | 380 | 223
24 | 3.4 | 4.25 | 310 | 17 | 80 | 34 | 212 | 339 | 227 | 59 | 297 | 153 | 161 | 388
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Summary

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | Summary
 |  | Summary of Stocks (Average)
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  | 19 | 267582.535 |  |  | 9.5 | 125399.13
 |  |  | 19 | 267582.535 |  |  | 9.5 | 125399.13 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 | 38 | 226333.62 |  |  |  |  | 6.333333333333333 | 37722.27 | 13 | 2.052631578947369
 |  | Stock 2 | 18.5 | 193761.46 |  |  |  |  | 3.083333333333333 | 32293.57666666667 | 7.5 | 2.432432432432432
 |  | Stock 3 | 1 | 6741.83 |  |  |  |  | 0.1666666666666667 | 1123.638333333333 | 1 | 6
 |  | Stock 4 | 2 | 18637.195 |  |  |  |  | 0.3333333333333333 | 3106.199166666667 | 2 | 6
 |  | Stock 5 | 12 | 103773.035 |  |  |  |  | 2 | 17295.50583333333 | 0 | 0
 |  | Stock 6 | 7.5 | 10750 |  |  |  |  | 1.25 | 1791.666666666667 |  | #N/A
 |  | Totals | 79 | 559997.14 | 0 | 0 | 0 | 0 | 13.16666666666667 | 93332.85666666667 | 23.5 | 1.784810126582279
Spreadsheet: 545676d1509620843-count-and-sum-up-problem-for-all-items-book1-1-1-
Sheet: Sheet1

City | Project | Status | Amount
A | Project A | Open | 3419 |  |  |  |  | All | All
A | Project B | Closed | 5407 |  |  |  |  | A | Open
B | Project C | Progress | 2351 |  |  |  |  | B | Closed
A | Project D | Closed | 2185 |  |  |  |  |  | Progress
B | Project E | Open | 5501
 | City | A
 |  | Count | Sum
 | Open
 | Closed
 | Progress
Spreadsheet: 842588d1694616122-3-conditions-in-an-if-statement-using-the-and-or-or-function-help-needed-book1-multiple-conditons-
Sheet: Sheet1

 | Poprerty Lease | Lease State Date | Rent Review Period | Next Rent Review | and the Next Rent Review | [NAME] | Lease End Date |  | 2023-01-01 00:00:00 | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-10-01 00:00:00 | 2024-01-01 00:00:00 | 2024-04-01 00:00:00 | 2024-07-01 00:00:00 | 2024-10-01 00:00:00 | 2025-01-01 00:00:00 | 2025-04-01 00:00:00 | 2025-07-01 00:00:00 | 2025-10-01 00:00:00 | 2026-01-01 00:00:00 | 2026-04-01 00:00:00 | 2026-07-01 00:00:00 | 2026-10-01 00:00:00 | 2027-01-01 00:00:00 | 2027-04-01 00:00:00 | 2027-07-01 00:00:00 | 2027-10-01 00:00:00 | 2028-01-01 00:00:00 | 2028-04-01 00:00:00 | 2028-07-01 00:00:00 | 2028-10-01 00:00:00 | 2029-01-01 00:00:00 | 2029-04-01 00:00:00 | 2029-07-01 00:00:00 | 2029-10-01 00:00:00 | 2030-01-01 00:00:00 | 2030-04-01 00:00:00 | 2030-07-01 00:00:00 | 2030-10-01 00:00:00 | 2031-01-01 00:00:00 | 2031-04-01 00:00:00 | 2031-07-01 00:00:00 | 2031-10-01 00:00:00 | 2032-01-01 00:00:00 | 2032-04-01 00:00:00 | 2032-07-01 00:00:00 | 2032-10-01 00:00:00 | 2033-01-01 00:00:00 | 2033-04-01 00:00:00 | 2033-07-01 00:00:00 | 2033-10-01 00:00:00 | 2034-01-01 00:00:00 | 2034-04-01 00:00:00 | 2034-07-01 00:00:00 | 2034-10-01 00:00:00 | 2035-01-01 00:00:00 | 2035-04-01 00:00:00
 | Lease 1 | 2017-05-01 00:00:00 | 5 |  |  | 2030-05-01 00:00:00 | 2035-02-01 00:00:00 |  | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | RR | - | - | - | - | - | - | - | - | - | - | - | B | - | - | - | - | - | - | - | RR | - | - | - | - | - | - | - | - | - | - | E
 |  | 2017-12-01 00:00:00 | 5 | 2027-12-01 00:00:00 |  | 2028-12-01 00:00:00 | 2030-12-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RR |  |  |  | B |  |  |  |  |  |  |  | E
Spreadsheet: 07773a78-f4bb-456b-ac0b-bce7f841bde5
Sheet: Sheet1

#18284 Personnel Policies Projects, for [NAME] | Unnamed: 1
rev 12/10/03 ecb
Vendor | Vision Graphics
Responding | [NAME]
Personnel Policies & Procedures 150 sets (120 shts front/back) | 1992
price/set | 13.28
Comments | As spec'd on RFQ
Lead time | As requested
Personnel Policies & Procedures Revisions, 1,325 sets (58 shts front/back) | 4664
price/set | 3.52
Lead time | As requested
FOB point | CoFC Human Resources
Comments | As spec'd on RFQ
Spreadsheet: 104502d1302095976-if-statement-needed-mock-spreadsheet
Sheet: Mock

product | month | id number | subtotal
A | Sept | 157896 | 24
 | Oct | 157896 | 86
 | Nov | 157896 | 32
B | Oct | 245689 | 16
 | Nov | 245689 | 54
 | Dec | 245689 | 97
C | Sept | 784692 | 54
 | Nov | 784692 | 63
D | Dec | 786354 | 14
Spreadsheet: 126188d1319562452-excel-2007-combining-rows-into-one-book1
Sheet: Sheet1

1414684 | [NAME] | A | S | D | Sophia | Bournville | [NAME] | BOURNVILLE | Birmingham | B30 | CADBURY.COM
1414682 | [NAME] | A | S | D | Sophia | Bournville | [NAME] | BOURNVILLE | Birmingham | B30 | CADBURY.COM
1414685 | [NAME] | A | S | D | Sophia | Bournville | [NAME] | BOURNVILLE | Birmingham | B30 | CADBURY.COM
2299151 | [NAME] | B | L | E | [NAME] | Waterside | Riverside | UXBRIDGE | F | UB8 | cepsg.co.uk
2299157 | [NAME] | B | L | E | [NAME] | Waterside | Riverside | UXBRIDGE | F | UB8 | cepsg.co.uk
1212121 | [NAME] | B | L | E | [NAME] | Waterside | Riverside | UXBRIDGE | F | UB8 | cepsg.co.uk
5656565 | [NAME] | B | L | E | [NAME] | Waterside | Riverside | UXBRIDGE | F | UB8 | cepsg.co.uk
1425989 | [NAME] | C | O | C | Oakford | Westferry | [NAME] | LONDON | C | E14 | chevron.com
1425986 | [NAME] | C | O | C | Oakford | Westferry | [NAME] | LONDON | C | E14 | chevron.com
1425987 | [NAME] | C | O | C | Oakford | Westferry | [NAME] | LONDON | C | E14 | chevron.com
Spreadsheet: 118051d1313411229-extracting-data-from-multiple-sheets-in-to-one-example-packing-list
Sheet: 1179

 | CLOTHING PACKING LIST
 | I EUROPE LTD
 | CUSTOMER NAME: |  |  | [NAME]
 | ADDRESS
 | ORDER NO. |  |  | UCLAW11 - 1179
 | INVOICE NO
 | AGENT NAME |  |  | [NAME]
 | REPEAT CONF. |  |  | 2011-07-15 00:00:00
 | CUST.PO
 | NO. OF CARTON |  |  | 1
 | STYLE | NO | CRTN NO | COLOUR | XS | S | M | L | XL | XXL | TOTAL | BX TOTAL
 | UCLG | RAYS-701 | 13272 | Peacoat | 0 | 2 | 3 | 3 | 2 | 0 | 10 | 10
 |  |  |  |  |  |  |  |  |  |  |  | 10
Spreadsheet: 726754d1617422677-eomonth-nightmare-cashflow
Sheet: Cashflow sample

 |  | 1
Spreadsheet: 45327d1244089699-if-statement-simplification-ebay1
Sheet: PACKAGING

 |  |  | ITEM # | PRODUCT |  | QTY | UNIT | NET | TAX | SHIPPING |  | TOTAL | $/PER |  | SOURCE
 |  |  |  |  |  |  |  |  | 0.08 |  |  | I+J+K | M / G
 |  |  | FRE | 12.5 X 9.5 |  | 1 | Env | 0 | 0 | 4.8 |  | 4.8 | 4.8 |  | USPS
 |  |  | FRS | 5.5 X 5.75 X 1.75 |  | 1 | Box | 0 | 0 | 4.95 |  | 4.95 | 4.95 |  | USPS
 |  |  | FR1 | 12 X 3.5 X 13.75 |  | 1 | Box | 0 | 0 | 10.35 |  | 10.35 | 10.35 |  | USPS
 |  |  | FR2 | 11 X 8.5 X 5.5 |  | 1 | Box | 0 | 0 | 10.35 |  | 10.35 | 10.35 |  | USPS
 |  |  | FRL | 12 x 12 x 5.5 |  | 1 | Box | 0 | 0 | 13.95 |  | 13.95 | 13.95 |  | USPS
Spreadsheet: 185873d1349867531-looking-up-a-series-of-values-over-a-date-range-123
Sheet: X

Week beginning |  |  | Week Ending | 0.25 | 1 | 5 | 10 | 20 | 50 | 100 | 500 | 1000 | Week end total | Week end Petty cash spend | Prepared by
2012-10-07 00:00:00 |  |  | 2012-10-13 00:00:00 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 549043d1511429776-dynamic-cell-reference-creation-example
Sheet: Before

Lookup_Id | Lookup_Id2 | Lookup_Id3 | Lookup_Key | Lookup_Value | Lookup_Key3 | [NAME]
Apples | Bananas |  | 0 |  |  | Watermelons
Oranges | Bananas |  | 1 |  |  | Watermelons
Bananas | Apples |  | 2 |  |  | Peaches
Bananas | Oranges |  | 3 |  |  | Peaches
Spreadsheet: 835176d1688383814-skip-one-row-when-value-changes-in-another-column-sample
Sheet: Аркуш1

As is:
 | 1 |  |  | 0
 | 1 |  |  | 0
 | 2 |  |  | 0
 | 2 |  |  | 0
 | 2 |  |  | 0
 | 3 |  |  | 0
To be:
 | 1 |  |  | 0
 | 1 |  |  | 0
 | 2
 | 2 |  |  | 0
 | 2 |  |  | 0
 | 3 |  |  | 0
 |  |  |  | 0
Spreadsheet: 854984d1704730756-today-statement-francoiscj1_today-statement
Sheet: Blad1

2025-01-04 19:00:00 |  |  |  | Today Statement
2023-12-30 19:00:00 |  |  |  | [NAME]
2023-11-29 19:00:00 |  |  |  | 12-27-2023, 10:35 PM
2023-12-09 15:00:00
2023-12-08 15:00:00
2023-10-20 15:00:00 |  |  | 3 formula in A1
2023-10-20 15:00:00 |  |  | Rule type "Use a formula to determine which cells to format"
2024-01-05 19:00:00 |  |  |  | =INT(A1)=TODAY()
 |  |  |  | =AND(A1>TODAY()-30,ISNUMBER(A1))
2024-01-08 00:00:00 |  |  |  | =AND(A1<TODAY()-30,ISNUMBER(A1))
2024-01-20 15:00:00
 |  |  | In this example it Applies ONLY to cells A1-A15
Hello-This is No date |  |  | Date is actually a number so adding
 |  |  | ISNUMBER filters out text and empty cells
2024-01-13 00:00:00
2024-01-08 00:00:00
Spreadsheet: 487605d1478164170-settling-products-in-custom-form-receipt
Sheet: OUT

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 JAN
 | TOTAL OUT
 | FROM 1/1/2017 TO 15/1/2017
 | ID | SELLER | DOCUMENT NUMBER | - | -
 | 4 | 5 | 6
 | 1 | AB SELLER | O-1/7-1-2017 |  |  |  |  | 35 |  |  |  |  | 15
 | 2 | AB SELLER | O-2/8-1-2017 |  |  |  |  |  |  |  |  | 80
 | 3 | AB SELLER | O-3/11-1-2017 |  |  |  |  |  |  |  |  |  |  |  | 100
 | 4 | AB SELLER | O-4/13-1-2017 |  | 40
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 1 | KKESL
 | 2 | KKGDO
 | 3 | [NAME]
 | 4 | KKGKEM
 | TOTAL
Spreadsheet: 0dba847c-4ec8-4146-ba2c-e2274e903b36
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
 | (įstaigos pavadinimas) |  |  |  |  |  |  |  |  |  |  |  |  |  | (data)
 |  |  |  | BUHALTERINĖ PAŽYMA Nr.
 | Klaidingiems įrašams taisyti
 | Taisoma operacija |  |  |  |  |  |  | Taisytinas įrašas |  |  |  | Įrašas, taisantis sąskaitų koresp. |  |  |  | Suma (Lt)
 | registravi- mo vieta ir Nr. |  | data | trumpas turinys |  |  |  | [NAME]. Nr. |  | [NAME] sąsk.  Nr. |  | [NAME]. Nr. |  | [NAME] sąsk.  Nr.
 | 1 |  | 2 | 3 |  |  |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
 | Pažymą parengė
 | (pareigos, [NAME], pavardė, parašas)
 | [NAME] |  |  |  |  |  |  |  | Vyriausiasis finansininkas
 | ([NAME], pavardė, parašas) |  |  |  |  |  |  |  | ([NAME], pavardė, parašas)
Spreadsheet: 214023d1360775877-conditional-formatting-if-date-is-before-today-highlight-only-if-adjacent-cell-is-blank-cf-dates
Sheet: Sheet1

 |  |  | 2012-08-30 00:00:00 | 2012-08-22 00:00:00
 |  |  | 2013-04-06 00:00:00 | 2012-06-06 00:00:00
 |  |  | 2012-07-06 00:00:00 | 2012-07-09 00:00:00
 |  |  | 2012-06-29 00:00:00 | 2012-06-26 00:00:00
 |  |  | 2013-04-15 00:00:00
 |  |  | 2012-07-18 00:00:00
 |  |  | 2012-06-18 00:00:00 | 2012-06-18 00:00:00
 |  |  | 2012-06-27 00:00:00 | 2012-07-09 00:00:00
 |  |  | 2012-06-12 00:00:00 | 2012-11-15 00:00:00
 |  |  | 2013-05-31 00:00:00
 |  |  | 2012-05-03 00:00:00 | 2012-05-03 00:00:00
 |  |  | 2012-07-02 00:00:00 | 2012-07-23 00:00:00
Spreadsheet: 720749d1614275232-result-variations-based-on-the-choice-of-drop-down-menu-sedi
Sheet: Foglio2

 |  |  |  | AA
 | AA | BB
2021-01-01 00:00:00 | MI | TO
2021-01-02 00:00:00 | MI | TO
2021-01-03 00:00:00 | MI | TO
2021-01-04 00:00:00 | TO | MI
2021-01-05 00:00:00 | RM | MI
2021-01-06 00:00:00 | RM | RM
2021-01-07 00:00:00 | TO | MI
2021-01-08 00:00:00 | TO | RM
2021-01-09 00:00:00 | RM | RM
2021-01-10 00:00:00 | RM | RM
2021-01-11 00:00:00 | RM | RM
2021-01-12 00:00:00 | RM | MI
2021-01-13 00:00:00 | RM | MI
2021-01-14 00:00:00 | MI | MI
2021-01-15 00:00:00 | MI | MI
2021-01-16 00:00:00 | TO | TO
2021-01-17 00:00:00 | TO | RM
2021-01-18 00:00:00 | TO | MI
2021-01-19 00:00:00 | MI | MI
Spreadsheet: 00b1ceb6-866d-43a5-9f36-4fbf8b127fe4
Sheet: 9d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis* | 1044253 | 793266 | 970705 | 2600976 | 1533547 | 539978 | 216937 | 7699662
FRA | 15041517 | 9773981 | 5487872 | 5262414 | 113860 |  |  | 35679644
IRS- [NAME] | 6451242 | 6075049 | 5299761 | 21011979 | 32318150 | 26317157 | 13120469 | 110593807
OIS | 8966250 | 4667758 | 2910696 | 5443290 | 58614 |  |  | 22046608
VNS | 455 | 417 | <100 | <100 | 621 | 875 | 1026 | 3394
Zero Coupon | 61302 | 23861 | 16837 | 55480 | 38482 | 7260 | 31899 | 235121
TOTAL | 31565019 | 21334331 | 14685872 | 34374140 | 34063273 | 26865270 | 13370331 | 176258236
Estimated gross notional amount outstanding, December 7 weekly snapshot, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].