tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 711948d1609997107-looking-for-a-formula-to-sum-based-on-criteria-sample-program
Sheet: Savings Account

 |  | Balance of funds in Account:
January Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance |  |  |  |  | 2021-01-01 00:00:00 | 2021-07-01 00:00:00
2021-01-01 00:00:00 |  |  | Home Escrow Account |  |  |  |  |  | 475 |  |  |  |  | 2021-02-01 00:00:00 | 2021-08-01 00:00:00
 |  |  | Auto Insurance Account |  |  |  |  |  | 1483 |  |  |  |  | 2021-03-01 00:00:00 | 2021-09-01 00:00:00
 |  |  | Lawn Maintenance Account |  |  |  |  |  | 1000 |  |  |  |  | 2021-04-01 00:00:00 | 2021-10-01 00:00:00
 |  |  | Sports Ticket Account |  |  |  |  |  | 1000 |  |  |  |  | 2021-05-01 00:00:00 | 2021-11-01 00:00:00
 |  |  | Pet Fund Account |  |  |  |  |  | 60 |  |  |  |  | 2021-06-01 00:00:00 | 2021-12-01 00:00:00
 |  |  | Miscellaneous Savings Account | 1200 |  |  |  |  | 1200
February Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance
2021-02-01 00:00:00 |  |  | Home Escrow Account
 |  |  | Auto Insurance Account
 |  |  | Lawn Maintenance Account
 |  |  | Sports Ticket Account
 |  |  | Pet Fund Account
 |  |  | Miscellaneous Savings Account |  |  |  |  |  | 1200
March Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance
2021-03-01 00:00:00 |  |  | Home Escrow Account
 |  |  | Auto Insurance Account
 |  |  | Lawn Maintenance Account
 |  |  | Sports Ticket Account
 |  |  | Pet Fund Account
 |  |  | Miscellaneous Savings Account |  |  |  |  |  | 1200
April Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance
2021-04-01 00:00:00 |  |  | Home Escrow Account
 |  |  | Auto Insurance Account
 |  |  | Lawn Maintenance Account
 |  |  | Sports Ticket Account
 |  |  | Pet Fund Account
 |  |  | Miscellaneous Savings Account |  |  |  |  |  | 1200
May Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance
2021-05-01 00:00:00 |  |  | Home Escrow Account
 |  |  | Auto Insurance Account
 |  |  | Lawn Maintenance Account
 |  |  | Sports Ticket Account
 |  |  | Pet Fund Account
 |  |  | Miscellaneous Savings Account |  |  |  |  |  | 1200
June Deposits & Expenses
Date |  |  |  | Deposit |  | Expense |  |  | Balance
2021-06-01 00:00:00 |  |  | Home Escrow Account
 |  |  | Auto Insurance Account
 |  |  | Lawn Maintenance Account
 |  |  | Sports Ticket Account
 |  |  | Pet Fund Account
 |  |  | Miscellaneous Savings Account |  |  |  |  |  | 1200
Spreadsheet: 194766d1353326988-vlookup-to-add-new-data-to-a-template-00__fotis_book3-6-
Sheet: Price List

Contractor Price List
Part Number | Product Description | Price
Spreadsheet: 157383d1337712660-ranking-and-displaying-unique-data-multiple-criteria-large-to-small-frequency-category-fruits
Sheet: Sheet1

 |  |  | Qty Total | Qty Rejected | Name | Defect | Salvagable? | Cost |  |  |  |  | Fruits | Qty Total | Qty Rejected |  | Top Fruit Defects: |  | Amount |  | Amount |  | Amount
 |  |  | 33 | 1 | Plums | Insects | S |  |  |  |  |  |  |  |  |  |  | Premature | 12
 |  |  | 44 | 2 | Apples | Bruised |  |  |  |  |  |  |  |  |  |  |  | Taste | 8
 |  |  | 97 | 3 | Oranges | Insects | S |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 55 | 4 | Oranges | Deformity | S |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  | 22 | 5 | Apples | Insects | S |  |  |  |  |  |  |  |  |  |  | Discolored | 0
 |  |  | 14 | 6 | Peaches | Discolored | S |  |  |  |  |  |  |  |  |  |  | Insects | 0
 |  |  | 51 | 7 | Apples | Taste | S
 |  |  | 656 | 8 | Apricots | Taste
 |  |  | 76 | 9 | Plums | Insects | S
 |  |  | 86 | 10 | Bananas | Insects | S
 |  |  | 66 | 11 | Bananas | Bruised | S
 |  |  | 77 | 12 | Apricots | Premature
Spreadsheet: 718863d1613397714-solved-sort-and-rearrange-if-1-number-is-higher-in-certain-rows-excel-forum1
Sheet: Sheet1

My data |  |  |  |  | Needed Results
259 | 170 | 8 |  |  | 259 | 170 | 8
169 | 257 | 6 |  |  | 257 | 169 | 6
258 | 169 | 7 |  |  | 258 | 169 | 7
169 | 260 | 7 |  |  | 260 | 169 | 7
259 | 169 | 8 |  |  | 259 | 169 | 8
259 | 170 | 6 |  |  | 259 | 170 | 6
259 | 169 | 6 |  |  | 259 | 169 | 6
247 | 170 | 8 |  |  | 247 | 170 | 8
258 | 170 | 7 |  |  | 258 | 170 | 7
258 | 169 | 7 |  |  | 258 | 169 | 7
257 | 169 | 8 |  |  | 257 | 169 | 8
258 | 168 | 8 |  |  | 258 | 168 | 8
258 | 167 | 7 |  |  | 258 | 167 | 7
257 | 170 | 7 |  |  | 257 | 170 | 7
259 | 166 | 7 |  |  | 259 | 166 | 7
170 | 260 | 7 |  |  | 260 | 170 | 7
259 | 169 | 6 |  |  | 259 | 169 | 6
Spreadsheet: 606038d1547470872-converting-spreadsheets-from-inches-to-centimeters-xlf20190114-exceltrial_legmeasurementtest_as
Sheet: MeasurementsCm

Excel Trial_Leg Measurement Test-This uses Tables
filename: | ExcelTrial_LegMeasurementTest.xlsx |  |  |  |  |  | Last Update: |  |  |  |  |  | This page is in Cm!
 | Measurements marks from floor to: Above Ankle bone=5". Lower Calf=8". Middle Calf=11.5". [NAME]".
 | Measurement marks from front of big toe to: Foot Front=4.5". Below Ankle Bone=5.5".
 |  |  |  |  |  |  |  |  |  |  |  |  | NOTE:  I have 'Protected' the sheet to hide the little green triangles on the #N/A cells.  You could turn them off using 'Options' instead. - Aardigspook
 | NOTE!  This is a Table. MUST enter date 1st on line, to get table to work.
 | To Chart dynamically, ALL selected columns must start at same row.
 |  |  |  |  |  |  |  | ***LEFT*** |  |  |  |  |  |  |  |  |  |  |  |  | *** RIGHT ***
 |  | Foot Front |  | Ankle |  |  |  |  |  |  |  |  |  | Calf |  |  |  |  |  |  | Front Foot |  |  | Ankle |  |  |  |  |  | Calf
 |  |  |  |  | Below Bone |  |  | Above Bone |  |  | Lower |  |  | Middle |  |  | Upper |  |  |  |  |  |  | Below Bone |  |  | Above Bone |  |  | Lower |  |  | Middle |  |  | Upper |  |  |  |  | Summary - Left Leg Measurements |  |  | Summary - Right Leg Measurements
Date | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | xxxxxxx | Date | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Tst | After Tst | AM | Before Bio | After Tst | AM | Comments | Date | Before Tst | After Tst | AM | Before Tst | After Tst | AM
1/9/1900 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12 | Column13 | Column14 | Column15 | Column16 | Column17 | Column18 | Column19 | Column20 | Column21 | Column22 | Column23 | Column24 | Column25 | Column26 | Column27 | Column28 | Column29 | Column30 | Column31 | Column32 | Column33 | Column34 | Column35 | Column36 | Column37 | Column38 | [NAME] | Column40 | Column212 | Column393 | Column3933 | Column3932 | Column394 | Column392 | Column41
Spreadsheet: 112755d1308768015-need-help-with-sliding-scale-compensation-formula-marginal-bonus
Sheet: Sheet1

Company Revenue | 1250000
Revenue is greater than | But less than or equal to | Bonus % for this bracket | Bonus for this bracket
0 | 500000 | 0.03
 | 1000000 | 0.05
 | 1500000 | 0.07
 |  | Total bonus
Spreadsheet: 731062d1620147069-consolidate-multiple-columns-to-one-using-formulas-samplecal
Sheet: Sheet1

 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  | [NAME]
Test 1 | 2021-07-01 00:00:00 | 5
Test 2 | 2021-07-04 00:00:00 | 4
Test 3 | 2021-07-10 00:00:00 | 6
Test 4 | 2021-07-12 00:00:00 | 8
Test 5 | 2021-07-15 00:00:00 | 2
Test 6 | 2021-07-20 00:00:00 | 6
Test 7 | 2021-07-25 00:00:00 | 3
Test 8 | 2021-07-31 00:00:00 | 10
Spreadsheet: 784920d1656011567-need-to-summarize-data-by-date-and-multiple-criteria-sample-data-1-my-solution
Sheet: Output

SAMPLE OUTPUT - DOES NOT INCLUDE ALL DATA FROM INPUT
Date | Company | City | State | Amount
2022-05-09 00:00:00 | ABC Inc | Colorado Springs | CO
2022-05-18 00:00:00 | ABC Inc | Colorado Springs | CO
2022-05-24 00:00:00 | ABC Inc | Colorado Springs | CO
2022-05-27 00:00:00 | ABC Inc | Colorado Springs | CO
2022-05-11 00:00:00 | ABC Inc | Arvada | CO
2022-05-17 00:00:00 | ABC Inc | Arvada | CO
2022-05-16 00:00:00 | ABC Inc | Avon | CO
2022-05-27 00:00:00 | ABC Inc | Boulder | CO
2022-05-19 00:00:00 | ABC Inc | Carbondale | CO
2022-05-24 00:00:00 | ABC Inc | Casper | WY
Spreadsheet: 830038d1684660651-help-with-if-calculation-formula-deemed-selling-price
Sheet: Sheet1

 | Kindly ask for help with excel formula to produce the desirwd solution below. The current formular on row 9 is working but if cell [NAME] is blank it is not working.
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price
 | Desired Solution
 |  | Passenger motor [NAME] | Machinery | Curent YR | Asset 1 | Asset 2 | Asset 3
 | Cost | 15000 | 40000 | 15000
 | [NAME] | 10000 |  | 20000
 | Actual selling price | 9000 | 40000 | 9000
 | [NAME] selling price |  | 40000
Spreadsheet: 677248d1589264640-color-third-cell-if-cell-1-is-filled-and-cell-2-is-not-formatting
Sheet: Ark1

What I would like to achieve: |  |  |  | Fluff13 |  |  | [NAME] |  |  |  | Inspired by the input, this is now what I want:
fsdfds | sdfdsf |  |  | fsdfds | sdfdsf |  | fsdfds | sdfdsf |  |  | fsdfds | sdfdsf
dfsfsd | fdsfssdf |  |  | dfsfsd | fdsfssdf |  | dfsfsd | fdsfssdf |  |  | dfsfsd | fdsfssdf
fnsdnf | fkdsnf |  |  | fnsdnf | fkdsnf |  | fnsdnf | fkdsnf |  |  | fnsdnf | fkdsnf
fsds |  |  |  | fsds |  |  | fsds |  |  |  | fsds
fsfs |  |  |  | fsfs |  |  | fsfs |  |  |  | fsfs
fsfsfsd | fdsf |  |  | fsfsfsd | fdsf |  | fsfsfsd | fdsf |  |  | fsfsfsd | fdsf
 |  |  |  |  |  |  |  |  |  |  | BUT, it should only color red if there
 |  |  |  |  |  |  |  |  |  |  | is something filled in the first row (row L)
Spreadsheet: 120ff2b0-49be-445a-a4f7-5453ab35c86e
Sheet: Sheet1

LOS ANGELES MISSION COLLEGE | 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 | Unnamed: 19
STUDENT WORKER WEEKLY TIME REPORT
For Week Ending |  |  |  |  |  | 2007-03-12 00:00:00
Empl. No. | Class Code |  | Sunday |  | Monday |  | Tuesday |  | Weds. |  | Thurs. |  | Friday |  | Saturday |  | Empl. | My signature below certifies
Employee Name |  |  | In / Out |  | In / Out |  | In / Out |  | In / Out |  | In / Out |  | In / Out |  | In / Out |  | Wkly. | that I have worked per the
 |  |  | Day Total |  | Day Total |  | Day Total |  | Day Total |  | Day Total |  | Day Total |  | Day Total |  | Total | hours listed. (Student signs)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
"I certify that the student(s) named herewith have worked the number of hours
listed and the work has been performed in a satisfactory manner."
[NAME]'s signature (Required) |  |  |  |  |  | Date |  |  |  |  |  | Admin. Signature (Optional) |  |  |  |  |  |  | Date
Program Name (Required)
Spreadsheet: ba1d0a5c-1087-40e2-a185-467251a63a9b
Sheet: Sheet1

I 2  The Taking of Private Property for Public Use (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Downloaded at 5/20/2013 11:13:42 AM
Precincts Reporting: 567/567 - Total Ballots Cast: 220479
2006 General Election - OFFICIAL RESULTS
Precinct | Yes | No | TOTALS
Precinct 2537 | 136 | 44 | 180
Precinct 2538 | 101 | 36 | 137
Precinct 2539 | 126 | 60 | 186
Precinct 2541 | 119 | 40 | 159
Precinct 2546 | 130 | 49 | 179
Precinct 2548 | 294 | 142 | 436
Precinct 2549 | 106 | 32 | 138
Precinct 2551 | 393 | 201 | 594
Precinct 2552 | 513 | 243 | 756
Precinct 2553 | 329 | 158 | 487
Precinct 2554 | 388 | 202 | 590
Precinct 2637 | 57 | 14 | 71
Precinct 2638 | 58 | 17 | 75
Precinct 2642 | 75 | 29 | 104
Precinct 2643 | 81 | 27 | 108
Precinct 2645 | 258 | 108 | 366
Precinct 2647 | 297 | 97 | 394
Precinct 2648 | 69 | 17 | 86
TOTAL | 3530 | 1516 | 5046
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 211919d1359989487-sort-function-results-sort-values
Sheet: Sheet1

5-20 |  |  |  | 5-20 | 2 | 5 | 20 |  | 5 | 20
5-22 |  |  |  | 5-22 | 2 | 5 | 22 |  | 5 | 22
5-24 |  |  |  | 5-24 | 2 | 5 | 24 |  | 5 | 24
4-18 | y | 19-12-2012 |  | 4-18 | 2 | 4 | 18 |  | 4 | 18
4-34 | y | 19-12-2012 |  | 4-34 | 2 | 4 | 34 |  | 4 | 34
5-30 | y | 19-12-2012 |  | 5-30 | 2 | 5 | 30 |  | 5 | 30
5-46 | y | 19-12-2012 |  | 5-46 | 2 | 5 | 46 |  | 5 | 46
5-35 | y | 19-12-2012 |  | 5-35 | 2 | 5 | 35 |  | 5 | 35
5-8 | y | 19-12-2012 |  | 5-8 | 2 | 5 | 8 |  | 5 | 8
5-16 | y | 19-12-2012 |  | 5-16 | 2 | 5 | 16 |  | 5 | 16
5-38 | y | 19-12-2012 |  | 5-38 | 2 | 5 | 38 |  | 5 | 38
5-18 | y | 19-12-2012 |  | 5-18 | 2 | 5 | 18 |  | 5 | 18
5-12 | y | 19-12-2012 |  | 5-12 | 2 | 5 | 12 |  | 5 | 12
5-40 | y | 19-12-2012 |  | 5-40 | 2 | 5 | 40 |  | 5 | 40
5-10 | y | 19-12-2012 |  | 5-10 | 2 | 5 | 10 |  | 5 | 10
5-14 | y | 19-12-2012 |  | 5-14 | 2 | 5 | 14 |  | 5 | 14
5-2 | y | 19-12-2012 |  | 5-2 | 2 | 5 | 2 |  | 5 | 2
4-2 | y | 19-12-2012 |  | 4-2 | 2 | 4 | 2 |  | 4 | 2
5-6 | y | 19-12-2012 |  | 5-6 | 2 | 5 | 6 |  | 5 | 6
5-34 | y | 19-12-2012 |  | 5-34 | 2 | 5 | 34 |  | 5 | 34
4-6 | y | 19-12-2012 |  | 4-6 | 2 | 4 | 6 |  | 4 | 6
4-46 | y | 19-12-2012 |  | 4-46 | 2 | 4 | 46 |  | 4 | 46
Spreadsheet: 853491d1703344298-bond-portfolio-automation-bondportfolio_automated3
Sheet: Example2

 | Transactions
 | Side | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date | PRICE
 | B | 2019-03-22 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | 300000 | 2019-03-24 00:00:00 | 85
 | B | 2019-05-31 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 300000 | 2019-06-02 00:00:00 | 100
 | S | 2019-09-06 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2019-09-08 00:00:00 | 111
 | S | 2019-10-18 00:00:00 | Bond | US900123CT57 | TURKEY 7.625 2029 | USD | 2029-04-26 00:00:00 | 7.625 | 2 | -300000 | 2019-10-20 00:00:00 | 92
 | B | 2020-03-01 00:00:00 | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89
 | B | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 400000 | 2020-03-11 00:00:00 | 108
 | B | 2020-03-09 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 400000 | 2020-03-11 00:00:00 | 85
 | B | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 500000 | 2020-03-11 00:00:00 | 92
 | S | 2020-03-12 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -300000 | 2020-03-14 00:00:00 | 95
 | S | 2020-03-12 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | -200000 | 2020-03-14 00:00:00 | 93
 | B | 2020-03-31 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 300000 | 2020-04-02 00:00:00 | 88
 | S | 2020-04-03 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | -200000 | 2020-04-05 00:00:00 | 94
 | Portfolio
 | X | Date | Type | ISIN | Ticker | Ccy | Maturity | Cpn% | CpnFqcy | Notional ($) | Date | PRICE
 |  | 2020-03-01 00:00:00 | Bond | US900123AY60 | TURKEY 6.875 2036 | USD | 2036-03-17 00:00:00 | 6.875 | 2 | 200000 | 2020-03-03 00:00:00 | 89
 |  | 2020-03-09 00:00:00 | Bond | XS1953057491 | EGYPT 8.7 2049 | USD | 2049-03-01 00:00:00 | 8.7 | 2 | 100000 | 2020-03-11 00:00:00 | 108
 |  | 2020-03-09 00:00:00 | Bond | XS1750114396 | OMAN 6.75 2048 | USD | 2048-01-17 00:00:00 | 6.75 | 2 | 800000 | 2020-03-11 00:00:00 | 92
 |  | 2020-03-12 00:00:00 | Bond | XS1910828182 | NIGERIA 9.248 2049 | USD | 2049-01-21 00:00:00 | 9.248 | 2 | 200000 | 2020-03-14 00:00:00 | 93
Spreadsheet: 121b66e9-db4f-4a3c-aeee-2152db8d79f2
Sheet: 1

 | Dec 28 | Jan 4 | Jan 11 | Jan 18 | Jan 25
Total Interest Rate* | 373145478 | 370621611 | 380218108 | 385395440 | 386073161
Cleared** | 170352573 | 169515426 | 175639239 | 178792699 | 178792699
Uncleared | 202792905 | 201106184 | 204578869 | 206602742 | 207280462
Total Cross-Currency | 16648654 | 16574252 | 16747192 | 17016046 | 16743138
Cleared | N/A*** | N/A | N/A | N/A | N/A
Uncleared | 16648654 | 16574252 | 16747192 | 17016046 | 16743138
Total Credit | 20639476 | 20564465 | 20885424 | 20946955 | 21141040
Cleared | 2551950 | 2576102 | 2606053 | 2624288 | 2665557
Uncleared | 18087527 | 17988362 | 18279372 | 18322667 | 18475483
Total Equity | 5166993 | N/A | N/A | N/A | N/A
Cleared | 0 | 0 | 0 | 0 | 0
Uncleared | 5166993 | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 418691601 | 410851328 | 420941724 | 426449441 | 427048339
Weekly snapshot, estimated gross notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 83719d1283766807-sumproduct-based-on-salespersons-and-dates-salessum
Sheet: Sheet1

[NAME] | Dates | Amount
KDIR | 2010-07-06 00:00:00 | 1540
KDIR | 2010-09-06 00:00:00 | 2541
KDIR | 2010-08-22 00:00:00 | 44
KDIR | 2010-08-26 00:00:00 | 899
KDIR | 2010-08-29 00:00:00 | 140
ROOB | 2010-09-26 00:00:00 | 2222
ROOB | 2010-07-06 00:00:00 | 1358 |  | ROOB
ROOB | 2010-08-16 00:00:00 | 1908 |  | KDIR
ROOB | 2010-08-31 00:00:00 | 1542
ROOB | 2010-08-04 00:00:00 | 1564
Spreadsheet: 809765d1671289842-determine-shift-start-and-end-based-on-data-in-a-table-excelhelp
Sheet: Sheet1

 | Agent | 2:30 | 3:00 | 3:30 | 4:00 | 4:30 | 5:00 | 5:30 | 6:00 | 6:30 | 7:00 | 7:30 | 8:00 | 8:30 | 9:00 | 9:30 | 10:00 | 10:30 | 11:00 | 11:30 | 12:00 | 12:30 | 13:00 | 13:30 | 14:00 | 14:30 | Shift Start | Shift End
 | [NAME] |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | [NAME] |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | [NAME] |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | [NAME] |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | [NAME] |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | [NAME] |  |  |  |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
Spreadsheet: 845125d1696657030-multpile-vllookup-and-data-validation-headache-hotel
Sheet: Clients

Name | First name | [NAME] | Phone | Direct ou Booking | Room No. | [NAME] | Depart Date | Duration | Price per day | Price per stay | No. Adults | No. Children | Cleaning? | Towels? | Tax Rate | Total Tax | Total Price | Deposit 1 | Payment Method | Deposit 2 | Payment Method | Total to be Paid
Doe | [NAME] |  |  | Direct | 12 | 2024-01-01 00:00:00 | 2024-01-10 00:00:00 |  |  |  | 2 | 1 | 30 | 0 | 1 |  |  | 118 | BACS
Doe | [NAME] |  |  | Booking | 1 | 2024-01-01 00:00:00 | 2024-01-07 00:00:00 |  |  |  | 2 | 1 | 0 | 0 | 1 |  |  | 118 | BACS
Spreadsheet: 868622d1715308195-count-visible-values-that-meet-a-criteria-count-visible
Sheet: ball

 |  |  |  |  |  |  |  |  |  | Sheet |  | Count
 |  |  |  |  |  |  |  |  | Yes in Yellow Range is Hidden | ball |  |  |  | Count of instances of Yes in Yellow Range
 |  |  |  |  |  |  |  |  | Yes in Yellow Range is not Hidden | ball |  |  |  | Count of instances of Yes in Yellow Range
 |  |  |  |  |  |  |  |  | Yes in Yellow Range is Hidden | bat |  |  |  | Count of instances of Yes in Yellow Range
 |  |  |  |  |  |  |  |  | Yes in Yellow Range is not Hidden | bat |  |  |  | Count of instances of Yes in Yellow Range
 |  |  |  |  |  |  |  |  | When Yes is filitered out of the List the red Counts should be 0
 | Response
 | a
 | f
 | h
 | y
 | j
 | l
 | e
 | Yes
 | f
 | Yes
 | y
 | n
 | k
 | x
 | d
 | d
 | d
 | g
 | h
Spreadsheet: 0fbb5491-0f0d-473e-bc64-9649f1a308e8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 | Copyright©  Savaprojekt
 |  | 5.4.3  POPIS MATERIALA IN DEL |  |  |  |  | 5.4.3 |  | 5.4 | 3
 |  | 5.4.3.R  REKAPITULACIJA |  |  |  |  | 5.4.3.R |  | 5.4 | 3.R
 |  | STROJNE INŠTALACIJE IN STROJNA OPREMA
 | 5.4.3.1  OGREVANJE |  |  |  |  |  |  | 1
 | 5.4.3.2  POHLAJEVANJE |  |  |  |  |  |  | 1
 | 5.4.3.3  PREZRAČEVANJE |  |  |  |  |  |  | 1
 | 5.4.3.4  VODOVOD - OBJEKT |  |  |  |  |  |  | 1
 | 5.4.3.5  PLIN - OBJEKT |  |  |  |  |  |  | 1
 | 5.4.3.6  VODOVOD - ZUNANJI RAZVOD |  |  |  |  |  |  | 1
 | 5.4.3.7  PLIN - ZUNANJI RAZVOD |  |  |  |  |  |  | 1
 | SKUPAJ (€):
 | 20% DDV (€):
 | SKUPAJ Z 20% DDV (€):
Spreadsheet: 696106d1600630172-section-wise-summarize-the-data-into-one-sheet-from-other-work-sheets-summarize-the-data-into-one-sheet-from-multiple-work-sheets-mohammad-munawar-
Sheet: PQ Table

Name | Section | Number | Under Section | Qty | Man Power | Machinery
Table01.09.20 | Section-A | 1212 | Fiiling | 10 | 22 | 22
Table01.09.20 | Section-A | 1315 | Excavation | 12 | 11 | 41
Table01.09.20 | Section-B | 2510 | Trimming | 15 | 25 | 20
Table01.09.20 | Section-B | 2456 | Laying | 14 | 21 | 21
Table01.09.20 | Section-C | 2141 | Cutting | 12 | 14.5 | 41
Table01.09.20 | Section-C | 1236 | Snags | 14 | 15 | 30
Table02.09.20 | Section-A | 1212 | Fiiling | 6 | 10 | 6
Table02.09.20 | Section-A | 3152 | Flooring | 25 | 10 | 14
Table02.09.20 | Section-B | 2510 | Trimming | 14 | 11 | 14
Table02.09.20 | Section-B | 3451 | Concreting | 12 | 21 | 10
Table02.09.20 | Section-C | 2141 | Cutting | 10 | 12.5 | 41
Table02.09.20 | Section-C | 3524 | Demolition | 11 | 8 | 30
Table03.09.20 | Section-A | 1212 | Fiiling | 10 | 22 | 22
Table03.09.20 | Section-A | 1315 | Excavation | 12 | 11 | 41
Table03.09.20 | Section-B | 2510 | Trimming | 15 | 25 | 20
Table03.09.20 | Section-B | 2456 | Laying | 14 | 21 | 21
Table03.09.20 | Section-C | 2141 | Cutting | 12 | 14.5 | 41
Table03.09.20 | Section-C | 1236 | Snags | 14 | 15 | 30
Table04.09.20 | Section-A | 1212 | Fiiling | 6 | 10 | 6
Table04.09.20 | Section-A | 3152 | Flooring | 25 | 10 | 14
Table04.09.20 | Section-B | 2510 | Trimming | 14 | 11 | 14
Table04.09.20 | Section-B | 3451 | Concreting | 12 | 21 | 10
Table04.09.20 | Section-C | 2510 | Trimming | 10 | 12.5 | 41
Table04.09.20 | Section-C | 3524 | Demolition | 11 | 8 | 30
Spreadsheet: 76761d1277248403-index-match-errors-question
Sheet: Sheet2

 |  |  |  | [NAME] |  |  |  |  |  | 2010-06-02 00:00:00 |  |  |  |  | Break | Lunch
 |  |  |  |  |  |  |  | Time In | Time Out
Agent Name: |  |  | [NAME], [NAME] |  |  |  | Shift | 1:00pm |  | Weekend | Sat. |  |  |  | 15 | 30
# of Records |  | 16
 |  | Time off | Start Shift |  |  | Break | Break | Total |  |  | Lunch | Lunch | Total |  | Break | Break | Total |  | End Shift
DATE | DAY | Reason | Login | Tardy | Notes | Logout | Login | Break | Tardy | Notes | Logout | Login | Lunch | Tardy | Logout | Login | Break | Tardy | Logout
2010-06-01 00:00:00 | Tue |  |  |  |  |  |  | 00:00:00 |  |  |  |  | 00:00:00 |  |  |  | 00:00:00
2010-06-02 00:00:00 | Wed |  |  |  |  |  |  | 00:00:00 |  |  |  |  | 00:00:00 |  |  |  | 00:00:00
2010-06-03 00:00:00 | Thu |  |  |  |  |  |  | 00:00:00 |  |  |  |  | 00:00:00 |  |  |  | 00:00:00
Spreadsheet: 682792d1592332632-combining-3-array-formulas-to-one-sample
Sheet: HO

 | Name | Date order Received | [NAME] | Disc £ ea | Balance | Paid | Product | Age | Notes/ Special Reqs | Status | Collection Date | Collection Time
 | pete |  | 12 |  |  |  | 6f |  |  |  | 2020-06-23 00:00:00 | 14:00:00
 | [NAME] |  | 1 |  |  |  | 5f |  |  |  | 2020-06-21 00:00:00 | 08:00:00
 | [NAME] |  | 4 |  |  |  | 14f |  |  |  | 2020-06-23 00:00:00 | 07:00:00