tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 79295d1279568647-average-of-pivot-table-values-refreshable-example2
Sheet: Sheet1

Count of Transaction # | Column Labels
Row Labels | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | Grand Total | % of Weekly Total
March | 4324 | 5775 | 5617 | 5652 | 3380 |  |  |  |  |  |  |  |  |  | 24748
Sunday |  | 368 | 320 | 367 | 381 |  |  |  |  |  |  |  |  |  | 1436
Monday | 224 | 1193 | 1293 | 1260 | 1106 |  |  |  |  |  |  |  |  |  | 5076
Tuesday | 970 | 1079 | 931 | 1008 | 898 |  |  |  |  |  |  |  |  |  | 4886
Wednesday | 1077 | 982 | 1027 | 930 | 995 |  |  |  |  |  |  |  |  |  | 5011
Thursday | 1241 | 1044 | 860 | 845 |  |  |  |  |  |  |  |  |  |  | 3990
Friday | 522 | 860 | 891 | 965 |  |  |  |  |  |  |  |  |  |  | 3238
Saturday | 290 | 249 | 295 | 277 |  |  |  |  |  |  |  |  |  |  | 1111
April |  |  |  |  | 2107 | 5700 | 5885 | 5875 | 5460 |  |  |  |  |  | 25027
Sunday |  |  |  |  |  | 335 | 461 | 344 | 388 |  |  |  |  |  | 1528
Monday |  |  |  |  |  | 1054 | 1259 | 1194 | 1166 |  |  |  |  |  | 4673
Tuesday |  |  |  |  |  | 1027 | 1098 | 842 | 1133 |  |  |  |  |  | 4100
Wednesday |  |  |  |  |  | 1013 | 1018 | 1226 | 880 |  |  |  |  |  | 4137
Thursday |  |  |  |  | 979 | 1182 | 978 | 1067 | 915 |  |  |  |  |  | 5121
Friday |  |  |  |  | 847 | 807 | 817 | 941 | 978 |  |  |  |  |  | 4390
Saturday |  |  |  |  | 281 | 282 | 254 | 261 |  |  |  |  |  |  | 1078
May |  |  |  |  |  |  |  |  | 274 | 5871 | 6018 | 5572 | 5895 | 707 | 24337
Sunday |  |  |  |  |  |  |  |  |  | 389 | 320 | 364 | 313 | 311 | 1697
Monday |  |  |  |  |  |  |  |  |  | 1186 | 1217 | 1081 | 1311 | 396 | 5191
Tuesday |  |  |  |  |  |  |  |  |  | 1081 | 1097 | 924 | 1112 |  | 4214
Wednesday |  |  |  |  |  |  |  |  |  | 986 | 1120 | 1033 | 1020 |  | 4159
Thursday |  |  |  |  |  |  |  |  |  | 1021 | 1029 | 984 | 1033 |  | 4067
Friday |  |  |  |  |  |  |  |  |  | 876 | 956 | 869 | 848 |  | 3549
Saturday |  |  |  |  |  |  |  |  | 274 | 332 | 279 | 317 | 258 |  | 1460
Grand Total | 4324 | 5775 | 5617 | 5652 | 5487 | 5700 | 5885 | 5875 | 5734 | 5871 | 6018 | 5572 | 5895 | 707 | 74112
 | Day | Rx's | %
 | Sunday
 | Monday
 | Tuesday
 | Wednesday
 | Thursday
 | Friday
 | Saturday
Spreadsheet: 678519d1589931578-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example
Sheet: 28 April 20 - 2 May 20

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 27/04/2020 - 02/05/2020
Dameon | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Dameon | ❌
[NAME] | AWAY | AWAY | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | AWAY | AWAY | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
Harley | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Harley | ✓
[NAME] | AWAY | AWAY | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ❌
Nathan | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Nathan | ✓
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | N/A
[NAME] | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | [NAME] | ✓
Tyson | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Tyson | ✓
Will | AWAY | ✓ | ✓ | ✓ | ✓ |  |  |  |  | Will | ✓
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | AWAY | ✓ | ✓ | *** | ✓ |  |  |  |  |  | ✓
 | AWAY | [NAME] | ✓ | ✓ | X |  |  |  |  |  | ❌
Edge Protection [NAME] |  |  | 17/04/2020 - 02/05/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 27/04/2020 - 02/05/2020
Laminex |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
Wilson |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Canterbury Linen Services |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | Nathan | ✓
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | ✓
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | ✓
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ✓
 |  |  |  |  |  |  |  |  |  |  | ✓
Spreadsheet: rick_buy__32874__Enron-Dynegy
Sheet: Prices

ENE / DYN prices
 | ENE | DYN |  | ENE price as % of | Bloomberg closing
 | closing | closing | Exchange | DYN exchange ratio | price of  ENE 6 5/8%
Date | price | price | ratio | adjusted price | 10/15/03 bonds
2001-10-22 00:00:00 |  |  |  |  | 1.0113
 |  |  |  |  | 0.9789
 |  |  |  |  | 0.9349
 |  |  |  |  | 0.9153
 |  |  |  |  | 0.8758
 |  |  |  |  | 0.8768
 |  |  |  |  | 0.8547
 |  |  |  |  | 0.8297
 |  |  |  |  | 0.6189
 |  |  |  |  | 0.6583
 |  |  |  |  | 0.7103
 |  |  |  |  | 0.7155
 |  |  |  |  | 0.7004
 |  |  |  |  | 0.7502
 |  |  |  |  | 0.8106
2001-11-12 00:00:00 | 9.24 | 44.31 | 0.2685 |  | 0.8108
 | 9.98 | 46.94 | 0.2685 |  | 0.8604
 | 10 | 46.2 | 0.2685 |  | 0.8499
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Carolyn Partridge

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 1612 Old [NAME], Windham, VT 05359 | State Representative | Yes |  | Windham
Spreadsheet: 9fd3dd05-a3c3-4b06-b886-fcdbc92f0782
Sheet: 4.2

Cuadro 4.2
[NAME]
Divorcios registrados, según [NAME], 2010
[NAME] | Divorcios
Total País
Distrito Nacional | 4026
Azua | 242
Baoruco | 62
Barahona | 251
Dajabón | 66
Duarte | 784
[NAME] | 20
El Seibo | 94
Espaillat | 444
[NAME] | 34
[NAME] | 200
[NAME] | 325
[NAME] | 1244
María [NAME] | 244
Monte Cristi | 139
Pedernales | 9
Peravia | 193
Puerto Plata | 446
[NAME] | 312
Samaná | 89
San Cristóbal | 284
San Juan | 112
[NAME] | 369
[NAME] | 208
Santiago | 3180
Santiago Rodríguez | 159
[NAME] | 310
[NAME] | 804
[NAME] | 121
Hato Mayor | 172
[NAME] | 503
Santo [NAME] | 2228
Nota: Elaborado con datos registrados en las Oficialías del Estado Civil.                  Junta Central Electoral
Fuente: Oficina Nacional de Estadística, (ONE)
Spreadsheet: 789412d1659088210-tools-book-out-and-returned-summary-sheet-for-stores-available-dropdown-only
Sheet: Tools Data Input Sheet

Tools Data Input Sheet
Product Code | Product Description | Category | Condition | Product Type | Unit of Measure | Unit Price | Status | Value |  |  |  | Dropdown - available
ID 001 | Impact [NAME] | Consumable | new | Paint | lt | 850.35 | Issued
JH 001 | [NAME] | Tools | used | Contact Adhesive | m | 14599.99 | Returned |  |  |  |  | DG 001
PG 001 | [NAME] | Material | Good | Primer | m² | 8500.5 | Lost |  |  |  |  | test1
DG 001 | Diesel Generator - MAC | Asset | To be Repared | Cement | m³ | 12499.99 |  |  |  |  |  | test2
PSD 001 | Philips [NAME] |  | bad | Water Proofing | [NAME] | 85.34 |  |  |  |  |  | test3
test1 |  |  | review | [NAME] | t
test2 |  |  | damaged | Timber | no
test3 |  |  |  | Roofing | unit
 |  |  |  | Building Material | ml
 |  |  |  | Aggregate | g
 |  |  |  | Flooring | mg
 |  |  |  | Ceiling Material
 |  |  |  | Adhesive Tape
 |  |  |  | Electrical
 |  |  |  | Plumbing
 |  |  |  | Scaffold
 |  |  |  | Electrical
 |  |  |  | Battery
 |  |  |  | Hand Tool
Spreadsheet: 879328d1726819526-how-to-convert-data-from-columns-to-rows-book1-2-
Sheet: result

Program | SAPA |  | SINGAPORE_MALAYSIA |  | TRUNG HOA CỔ KÍNH |  | PHÁT LỘC |  | BỀN VỮNG |  | KIẾN TẠO TƯƠNG LAI
[NAME] name | Quantity | Revenue | Quantity | Revenue | Quantity | Revenue | Quantity | Revenue | Quantity | Revenue | Quantity | Revenue
[NAME] |  |  | 2 | 23280500 | 1 | 25600000 | 14 | 140510000 | 1 | 15768000 | 1 | 25966000
Lê Đình Thức |  |  | 3 | 44039000 | 1 | 8888000 | 3 | 41386500 | 1 | 49026000 | 1 | 24193000
Nguyễn Mạnh Cường | 2 | 9643000 | 4 | 22240000 | 5 | 32469000 | 7 | 92636000 | 3 | 87882000 | 1 | 54484000
Spreadsheet: 755105d1636662152-can-you-use-vlookup-to-return-value-if-conditions-are-met-timeline-2021_test-copy
Sheet: Summary

 |  |  |  |  | SUN | MON | TUE | WED | THU | FRI | SAT |  |  | <-------- | this row needs to be a rolling 7 days starting with one day before today
 |  |  |  | Activity | 2021-11-07 00:00:00 | 2021-11-08 00:00:00 | 2021-11-09 00:00:00 | 2021-11-10 00:00:00 | 2021-11-11 00:00:00 | 2021-11-12 00:00:00 | 2021-11-13 00:00:00 |  |  |  | So if today was 11/27, then the first day to show would be 11/26  and of course the weekday would need to reflect that correct day of the week as well
 |  | This needs to be any activity that has a count  greater than or equal to 1 in the 7 days that are being displayed here | ----> | COMMUNICATION | 1 |  |  | 1 |  |  |  |  |  | <-------- | This row needs to reflect the count shown for that day if there is one Since the raw data tab has a formula to calculate that number, this  summary needs to be just the value
 |  |  |  |  | FRI | SAT | SUN | MON | TUE | WED | THU
 |  |  |  | Activity | 2021-11-26 00:00:00 | 2021-11-27 00:00:00 | 2021-11-28 00:00:00 | 2021-11-29 00:00:00 | 2021-11-30 00:00:00 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00
 |  |  |  | BRIDGE DETAILS | 1 | 1
 |  |  |  | HOLIDAY SUPPORT |  |  | 1 | 1
 |  |  |  | OPPERATION HOURS |  |  |  |  |  | 1
Spreadsheet: 24645d1215292921-ordering-information-invoice-example
Sheet: Orders

Order | Name | Address | Quantity | Paper Size | Paper weight | Delivery info | Price | Telephone No
1 | Name1 | Address1 | 1 | A3 | 10 | No info | 10 | 118 118
2 | [NAME] | Address2 | 2 | A4 | 20 | No info | 20 | 119 118
3 | Name3 | Address3 | 3 | A5 | 30 | No info | 30 | 120 118
4 | Name4 | Address4 | 4 | A3 | 40 | No info | 40 | 121 118
5 | Name5 | Address5 | 5 | A4 | 50 | No info | 50 | 122 118
6 | Name6 | Address6 | 6 | A5 | 60 | No info | 60 | 123 118
7 | Name7 | Address7 | 7 | A3 | 70 | No info | 70 | 124 118
8 | Name8 | Address8 | 8 | A4 | 80 | No info | 80 | 125 118
9 | Name9 | Address9 | 9 | A5 | 90 | No info | 90 | 126 118
10 | Name10 | Address10 | 10 | A3 | 100 | No info | 100 | 127 118
11 | Name11 | Address11 | 11 | A4 | 110 | No info | 110 | 128 118
12 | Name12 | Address12 | 12 | A5 | 120 | No info | 120 | 129 118
13 | Name13 | Address13 | 13 | A3 | 130 | No info | 130 | 130 118
14 | Name14 | Address14 | 14 | A4 | 140 | No info | 140 | 131 118
15 | Name15 | Address15 | 15 | A5 | 150 | No info | 150 | 132 118
Spreadsheet: 787827d1658076358-provide-the-2nd-lastest-price-value-from-a-row-lookup-2nd-last-value-issue
Sheet: Comparison

 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4 |  |  |  |  |  | 70.63000000000001 |  |  |  |  |  | 74.02 |  |  |  |  |  | 60.92
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz |  |  |  |  |  | 21.45 |  |  |  |  |  | 38.44 |  |  |  |  |  | 24.66
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 22.85
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.3 |  | 20.76
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 17.44
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz |  |  |  |  |  | 18.05 |  |  |  |  |  |  |  |  |  |  |  | 17.44
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  |  |  |  |  |  |  |  |  |  |  |  | 18.04 |  | 22.44 |  |  | 22.16
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB
Spreadsheet: 875895d1722518426-help-with-overtime-formula-overtime-example-2
Sheet: Tue- Fri 9.15 hr-da 49 hr Wk

You must use the format HH:[NAME] (ie 09:00 or 17:00) when entering your time. It reformats the cell if you use any other way (ie 9 or 17 or 9.00 ect) this will change the calculations and the sheet won't be correct.
 |  | Enter start time: 24hr clock | Enter time work over lunch. ie 00:30 minuets worked | Enter finish time: 24hr clock | Hours in | Overtime. | Enter time taken back as hours:minutes | Final running total of overtime
Date | Day | Start | Lunch | Finish | Hours | Overtime | Time taken back | Total
2024-09-16 00:00:00 | Monday
2024-09-17 00:00:00 | Tuesday
2024-09-18 00:00:00 | Wednesday
2024-09-19 00:00:00 | Thursday |  |  |  |  |  |  |  |  | Tue- [NAME] 9.15 hr-day 49 hr Wk
2024-09-20 00:00:00 | Friday
2024-09-21 00:00:00 | Saturday
2024-09-22 00:00:00 | Sunday
2024-09-23 00:00:00 | Monday
2024-09-24 00:00:00 | Tuesday
2024-09-25 00:00:00 | Wednesday
2024-09-26 00:00:00 | Thursday
2024-09-27 00:00:00 | Friday
2024-09-28 00:00:00 | Saturday
2024-09-29 00:00:00 | Sunday
2024-09-30 00:00:00 | Monday
2024-10-01 00:00:00 | Tuesday
2024-10-02 00:00:00 | Wednesday
2024-10-03 00:00:00 | Thursday
2024-10-04 00:00:00 | Friday
2024-10-05 00:00:00 | Saturday
2024-10-06 00:00:00 | Sunday
Spreadsheet: 131851d1323357381-nested-if-or-and-matched-indexed-statements-copy-of-2012_eu22-jv-version-1
Sheet: Ams, Ber, Pra, Vie, Ven

Rooming allocation for Amsterdam, Berlin, Prague, Vienna, Venice
Type | # of Rms
Singles
Twins
Triples
Quads
5 bed
6 bed
Total Pax
fs | ms | Single | Twin |  | Triple |  | Quad |  | 5 |  | 6
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
Spreadsheet: 872897d1719340988-calculating-totals-based-on-another-cell-value-in-the-same-row-sample-2-
Sheet: SAMPLE

DISCOUNTING DEPOSITS 2025
DEPOSIT | NOA | REC | # | LAST NAME | FIRST NAME | SIN | YEAR | AMOUNT | BATCH TOTAL
D242501 | Feb1/25 | Feb5/25 | 1 | SMITH | [NAME] | 544508807 | 2022 | 11281 |  |  | SUMIF does not work because it puts the total in
[NAME] | Feb1/25 | Feb5/25 | 1 | BROWN | JACK | 387446003 |  | 7886 |  |  | every single cell in column J. It should only put in the
D242503 | Feb1/25 | Feb5/25 | 1 | MILLER | [NAME] | 865253547 |  | 2345 |  |  | total for that specific deposit number.
D242501 | Feb1/25 | Feb5/25 | 2 | [NAME] | [NAME] | 707692957 |  | 11093
D242501 | Feb1/25 | Feb5/25 | 3 | JONES | JORGE | 730523243 |  | 7332
[NAME] | Feb1/25 | Feb5/25 | 1 | DAVIS | [NAME] | 209479314 | 2019 | 1810
D242501 | Feb1/25 | Feb5/25 | 4 | [NAME] | JACQUIE | 492485412 |  | 2818
D242503 | Feb1/25 | Feb5/25 | 2 | WILSON | JOSEPHINE | 775809085 |  | 10256
D242503 | Feb1/25 | Feb5/25 | 3 | [NAME] | JOY | 505732889 |  | 6791
D242503 | Feb1/25 | Feb5/25 | 4 | TAYLOR | [NAME] | 823761590 |  | 13380
DEPOSIT | NOA | REC | # | LAST NAME | FIRST NAME | SIN | YEAR | AMOUNT | BATCH TOTAL | Sum
D242501 | Feb1/25 | Feb5/25 | 1 | SMITH | [NAME] | 544508807 | 2022 | 11281 | 32524 | 32524
D242501 | Feb1/25 | Feb5/25 | 2 | [NAME] | [NAME] | 707692957 |  | 11093 | 32524 | 32524
[NAME] | Feb1/25 | Feb5/25 | 1 | BROWN | JACK | 387446003 |  | 7886 | 32524 | 9696
D242503 | Feb1/25 | Feb5/25 | 1 | MILLER | [NAME] | 865253547 |  | 2345 | 32524 | 32772
D242501 | Feb1/25 | Feb5/25 | 3 | JONES | JORGE | 730523243 |  | 7332 | 32524 | 32524
[NAME] | Feb1/25 | Feb5/25 | 1 | DAVIS | [NAME] | 209479314 | 2019 | 1810 | 32524 | 9696
D242501 | Feb1/25 | Feb5/25 | 4 | [NAME] | JACQUIE | 492485412 |  | 2818 | 32524 | 32524
D242503 | Feb1/25 | Feb5/25 | 2 | WILSON | JOSEPHINE | 775809085 |  | 10256 | 32524 | 32772
D242503 | Feb1/25 | Feb5/25 | 3 | [NAME] | JOY | 505732889 |  | 6791 | 32524 | 32772
D242503 | Feb1/25 | Feb5/25 | 4 | TAYLOR | [NAME] | 823761590 |  | 13380 | 32524 | 32772
Spreadsheet: 792443d1660907536-sum-and-count-with-identifiers-research-output
Sheet: Sheet1

 | Output
 | Filters
 | Country | Germany
 | Sex | Male
 | Company1 | Company2 | >> Sum | Company 1 | Company 2 |  |  | >> Count | Company 1 | Company 2
 | Q19_11R1 | Q19_1R1 | Fastest |  |  |  |  | Fastest
 | Q19_11R2 | Q19_1R2 | Cheapest |  |  |  |  | Cheapest
 | Q19_11R3 | Q19_1R3 | Slowest |  |  |  |  | Slowest
 | Input (on different tab)
 |  | Sex | Country | Q19_11R1 | Q19_11R2 | Q19_11R3 | Q19_1R1 | Q19_1R2 | Q19_1R3
 | Survey 1 | Male | Germany | 4 | 2 | 1 | 4 | 4 | 4
 | Survey 2 | Female | Poland | 3 | 5 | 2 | 4 | 4 | 4
 | Survey 3 | Male | Germany | 1 | 5 | 3 | 4 | 3 | 4
 | Survey 4 | Male | Poland |  |  |  | 3 | 2 | 1
 | Survey 5 | Male | Poland | 1 | 5 | 3 | 4 | 3 | 4
Spreadsheet: 273115d1382618076-month-format-issue-convert-9-1-2013-into-sep-date-test
Sheet: Sheet1

date | so far so good | now wrong | attept 2 - wrong again | Why is it not giving me this?
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
2013-09-01 00:00:00 |  |  |  | Sep
formatted as date |  | formatted as date and single letter - came out as J | formatted using custom and mmm and came out as Jan
Spreadsheet: 796995d1663665704-check-column-wjth-al-least-2-conditions-welding-machines
Sheet: Final

 |  |  | Welding Equipment verification certificate |  |  |  |  |  |  |  |  |  |  |  | Welding machine code |  | SD-02
 | General Information |  |  |  |  |  |  |  |  |  |  |  |  |  | Verification |  | 1ª Verification
 | Welding Machine Code
 | Brand |  |  |  | Model |  |  |  | Serial Number
Reference
 | Reference |  | Brand |  | Model |  |  |  | Serial Number
Test results
 | Welding Process |  |  |  |  |  |  | Verification Date
 | Set values on welding machine |  |  |  |  |  | Reference equipment measurements
 | Amperage |  | Voltage |  | Wire feed Speed |  | Amperage |  | Voltage |  | Wire feed Speed
Spreadsheet: 120485f2-c956-4edd-bf63-2a92719c9b6d
Sheet: Detailed Revenue

The NASDAQ OMX Group, Inc.
Revenue Detail
(in millions)
(unaudited)
 |  |  |  | Three Months Ended
 |  |  |  | June 30, |  | March 31, |  | June 30,
 |  |  |  | 2011 |  | 2011 |  | 2010
MARKET SERVICES
Transaction Services
Cash Equity Trading Revenues:
 | U.S. cash equity trading |  |  | 387 |  | 365 |  | 498
 | Cost of revenues:
 | Transaction rebates |  |  | -258 |  | -242 |  | -336
 | Brokerage, clearance and exchange fees |  |  | -93 |  | -84 |  | -108
 | Total U.S. cash equity cost of revenues |  |  | -351 |  | -326 |  | -444
 | Net U.S. cash equity trading revenues |  |  | 36 |  | 39 |  | 54
European cash equity trading |  |  |  | 23 |  | 23 |  | 22
 | Total net cash equity trading revenues |  |  | 59 |  | 62 |  | 76
Derivative Trading and Clearing Revenues:
 | U.S. derivative trading and clearing |  |  | 115 |  | 124 |  | 92
 | Cost of revenues:
 | Transaction rebates |  |  | -64 |  | -67 |  | -48
 | Brokerage, clearance and exchange fees |  |  | -7 |  | -9 |  | -4
 | Total U.S. derivative trading and clearing cost of revenues |  |  | -71 |  | -76 |  | -52
 | Net U.S. derivative trading and clearing revenues |  |  | 44 |  | 48 |  | 40
 | European derivative trading and clearing |  |  | 31 |  | 32 |  | 29
 | Total net derivative trading and clearing revenues |  |  | 75 |  | 80 |  | 69
 | Access Services Revenues |  |  | 55 |  | 53 |  | 41
 | Total Transaction Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees |  |  | 189 |  | 195 |  | 186
 | Market Data Revenues:
 | Net U.S. tape plans |  |  | 30 |  | 27 |  | 30
 | U.S. market data products |  |  | 32 |  | 32 |  | 32
 | European market data products |  |  | 21 |  | 22 |  | 17
 | Total Market Data revenues |  |  | 83 |  | 81 |  | 79
 | Broker Services Revenues |  |  | 4 |  | 4 |  | 4
 | Other Market Services Revenues |  |  | 1 |  | 1 |  | 1
 | Total Market Services revenues less transaction
 | rebates, brokerage, clearance and exchange fees |  |  | 277 |  | 281 |  | 270
ISSUER SERVICES
Global Listing Services Revenues:
U.S. Operations: | Annual renewal |  |  | 29 |  | 29 |  | 28
 | Listing of additional shares |  |  | 10 |  | 10 |  | 10
 | Initial listing |  |  | 4 |  | 4 |  | 5
 | Total U.S. listing services |  |  | 43 |  | 43 |  | 43
 | European listing services |  |  | 14 |  | 13 |  | 12
 | Corporate Solutions |  |  | 23 |  | 22 |  | 19
 | Total Global Listing Services revenues |  |  | 80 |  | 78 |  | 74
 | Global Index Group Revenues |  |  | 13 |  | 13 |  | 12
 | Total Issuer Services revenues |  |  | 93 |  | 91 |  | 86
MARKET TECHNOLOGY
 | License, support and facility management |  |  | 30 |  | 28 |  | 24
 | Delivery project |  |  | 6 |  | 6 |  | 4
 | Change request, advisory and broker surveillance |  |  | 10 |  | 9 |  | 6
 | Total Market Technology revenues |  |  | 46 |  | 43 |  | 34
Total revenues less transaction rebates, brokerage,
clearance and exchange fees |  |  |  | 416 |  | 415 |  | 390
Spreadsheet: 453382d1459288632-if-function-with-multiple-options-theatre-tech-charge-sheet
Sheet: Day30

Event
Date
Service | Base Arrival | Base Departure | Break Beginning | Break End | [NAME] |  |  |  |  |  | Base Hours | Base Over 8 | Base Over 8 Gross
Base
Group Note
 | [NAME] | Performance end |  | Attendance |  |  |  |  |  |  | Hours | Performances
Performance
Performance
Performance
Performance
Dark Day
Staff | [NAME] | Departure | Break Beginning | Break End | Technician Name |  |  |  |  |  | Standard | OT. | Total Hours
Tech.
Tech.
Tech.
Tech.
Tech.
Tech.
Unscheduled Tech.
Custodian
Custodian
Extended Custodial
Special Equipment Daily | Qty.
Bubbles |  | Notes
Fog- Chemical
Fog- Dry Ice
Piano
Snow
Extra Spotlight
Stage Deck
Total Wireless Channels Used
Additional Rooms | [NAME] | Departure | Break Beginning | Break End |  |  |  |  |  |  | Min. | Over Min. | Total Hours
[NAME]
Comstock Room
Gym
Sierra Room
Tahoe Room
Base hours | Tech Hours
Base Over 8 | Tech Hours Over 8
Performances | Unscheduled Tech. |  | Wireless Channels
Dark Day | Custodial
Attendance | Custodial OT., ET.
Between 12am and 8am Adder