tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 884473d1733659694-find-results-to-given-reached-value-choose-numbers-equal-above-given-number
Sheet: Blad1

 |  |  |  | How many "TIMES" equal or above |  |  | 11 |  |  |  | "TIMES" | 15 |  |  | "TIMES" | 12 |  |  | "TIMES" | 3
ITEM | TIMES | QTY
A1234 | 10 | 10 |  |  |  |  | 12 | 200 |  |  | F1234 | 26 | 40 |  | D1234 | 12 | 200 |  | F1234 | 26 | 40
B1234 | 2 | 30 |  |  |  | F1234 | 26 | 40 |  |  |  |  |  |  |  |  |  |  | D1234 | 12 | 200
C1234 | 6 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A1234 | 10 | 10
D1234 | 12 | 200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C1234 | 6 | 60
E1234 | 5 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E1234 | 5 | 50
F1234 | 26 | 40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | G1234 | 3 | 30
G1234 | 3 | 30
H1234 | 1 | 456
I1234 | 2 | 1000 |  | Value to be choosen for each time you change the number in like (H11) and example in (M15)
 |  |  |  | I am presenting three scenarios to give examples of the result
 |  |  |  | Find rows that are equal or above choosen number of times
Spreadsheet: 1ad326e2-b2e5-4d72-b697-b88549a81766
Sheet: Serials Unit Stats 2007-2008

TECHNICAL SERVICES DEPARTMENT
Serials Unit Statistics 2008/2009
COLLECTION METRICS
 | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | YTD
Serial volumes withdrawn | 0 | 7 | 0 | 0 | 0 | 0 | 30 | 0 | 8 | 67 | 0 | 0
Mform pieces withdrawn | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Serial volumes added (total)
Subscriptions | 45 | 98 | 42 | 60 | 60 | 36 | 90 | 48 | 44 | 20 | 57 | 26
Binding | 150 | 75 | 183 | 357 | 84 | 74 | 330 | 171 | 393 | 238 | 219 | 140
Gifts | 0 | 45 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Mform pieces added (total) |  |  |  |  |  |  |  |  |  | 8 | 10 | 6
Film | 14 | 139 | 10 | 10 | 27 | 0 | 9 | 3 | 14 | 8 | 10 | 6
Fiche | 0 | 40 | 0 | 0 | 355 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PRODUCTIVITY METRICS
[NAME] processed | 1486 | 1432 | 1339 | 1294 | 944 |  |  | 1067 | 1391 | 1123 | 1208 | 1160
[NAME] temp bound | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] mended (in-house) | 54 | 40 | 15 | 4 | 0 | 1 | 12 | 4 | 14 | 5 | 1 | 6
Claims sent | 75 | 46 | 56 | 128 | 53 | 0 | 5 | 80 | 35 | 53 | 19 | 7
Pieces checked in | 892 | 919 | 960 | 1014 | 877 | 383 | 1325 | 1442 | 655 | 623 | 591 | 515
[NAME] returned from bindery (total) | 155 | 171 | 243 | 619 | 162 |  |  |  | 369
Journals and other materials | 150 | 133 | 183 | 357 | 84 | 74 | 352 | 171 | 293 | 238 | 219 | 140
Repairs | 5 | 4 | 25 | 203 | 65 | 38 | 17 | 38 | 51 | 27 | 53 | 71
Non-Library | 0 | 34 | 35 | 59 | 13 | 0 | 258 | 27 | 25 | 0 | 7 | 76
Spreadsheet: 882883d1731356842-need-help-with-moving-data-from-col-to-col-and-rows-excel-example-for-component-list
Sheet: Sheet1

ITEM NAME | ITEM TYPE | ITEM ID
APPLE | CRISP | CRSP
 | HONEY | HNEY
 | MICHIGAN | MICH
 | GRANNY | GRAN
BANANA | [NAME] | SWET
 | RIPE | RIPE
 | ORGANIC | ORGA
TOMATO | RIPE | RIPE
 | SPOILED | SPOL |  | NEED COL A FROM THIS WORKSHEET PUT IN A SECOND WORKSHEET WITH 1 ROW BETWEEN EACH
BREAD | WHITE | WHIT |  | I NEED EACH ITEM TYPE IN COLUMN B OF THIS WORKSHEET PLACE IN THE SECOND WORKSHEET IN A ROW NEXT TO THE ITEM NAME
 | RYE | RYEB |  | I NEED EACH ITEM ID FROM COL C OF THIS WORKSHEET PLACED IN THE SECOND WORKSHEET IN A ROW RIGHT BELOW THE ITEM TYPE IT CORRESPONDS TO
 | PUMPERNICKLE | PUMP |  | THIS IS HOW I NEED THE SECOND WORKSHEET TO LOOK
 | FRESH | FRES |  | APPLE | CRISP | HONEY | MICHIGAN | GRANNY
 | BANANA | BANA |  |  | CRIS | HNEY | MICH | GRAN
 | CINNAMON | CINN |  | BANANA | [NAME] | RIPE | ORGANIC
 | SOURDOUGH | SOUR |  |  | SWET | WHIT | ORGA
 | BAKED | BAKE |  | TOMATO | RIPE | SPOILED
 | OAT | OATB |  |  | RIPE | SPOL
 | PUDDING | PUDD |  | BREAD | WHITE | RYE | PUMPERNICKLE | FRESH | BANANA | CINNAMON | SOURDOUGH | BAKED | OAT | PUDDING | 12 GRAIN | 7 GRAIN
 | 12 GRAIN | 12GR |  |  | WHITE | RYEB | PUMP | FRES | BANA | CINN | SOUR | BAKE | OATB | PUDD | 12GR | 07GR
 | 7 GRAIN | 07GR
Spreadsheet: 134769d1325625041-how-to-increase-table-size-based-on-quanity-of-an-item-increment-by-values
Sheet: Sheet1

things | number of things | helper
chocolate bars | 5 | 1
candy | 3 | 6
jelly | 8 | 9
nuts | 10 | 17
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
 |  | 27
Spreadsheet: 191169d1351954740-swapping-colums-and-rows-transpose
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 6
 |  | Wk 1 | Wk 2 | Wk 3 | Wk 4 | Wk 5 | Wk 6 |  | 2 | 1 | Wk 1 | Site A | 15
1 | Site A | 15 | 4 | 5 | 6 | 45 | 77 |  | 3 | 1 | Wk 2 | Site A | 4
2 | Site B | 8 | 9 | 10 | 11 | 12 | 13 |  | 4 | 1 | Wk 3 | Site A | 5
3 | Site C | 8 | 9 | 10 | 11 | 12 | 13 |  | 5 | 1 | Wk 4 | Site A | 6
4 | Site D | 8 | 9 | 10 | 11 | 12 | 13 |  | 6 | 1 | Wk 5 | Site A | 45
5 | Site E | 10 | 20 | 30 | 40 | 50 | 60 |  | 7 | 1 | Wk 6 | Site A | 77
 |  |  |  |  |  |  |  |  | 2 | 2 | Wk 1 | Site B | 8
 |  |  |  |  |  |  |  |  | 3 | 2 | Wk 2 | Site B | 9
 |  |  |  |  |  |  |  |  | 4 | 2 | Wk 3 | Site B | 10
 |  |  |  |  |  |  |  |  | 5 | 2 | Wk 4 | Site B | 11
 | Wk1 | Site A | 3 |  |  |  |  |  | 6 | 2 | Wk 5 | Site B | 12
 | Wk2 | Site A | 4 |  |  |  |  |  | 7 | 2 | Wk 6 | Site B | 13
 | Wk3 | Site A | 5 |  |  |  |  |  | 2 | 3 | Wk 1 | Site C | 8
 | Wk4 | Site A | 6 |  |  |  |  |  | 3 | 3 | Wk 2 | Site C | 9
 | Wk5 | Site A | 7 |  |  |  |  |  | 4 | 3 | Wk 3 | Site C | 10
 | Wk6 | Site A | 8 |  |  |  |  |  | 5 | 3 | Wk 4 | Site C | 11
 | Wk 1 | Site B | 8 |  |  |  |  |  | 6 | 3 | Wk 5 | Site C | 12
 | Wk 2 | Site B | 9 |  |  |  |  |  | 7 | 3 | Wk 6 | Site C | 13
 | Wk 3 | Site B | 10 |  |  |  |  |  | 2 | 4 | Wk 1 | Site D | 8
 | Wk 4 | Site B | 11 |  |  |  |  |  | 3 | 4 | Wk 2 | Site D | 9
 | Wk 5 | Site B | 12 |  |  |  |  |  | 4 | 4 | Wk 3 | Site D | 10
 | Wk 6 | Site B | 13 |  |  |  |  |  | 5 | 4 | Wk 4 | Site D | 11
 |  |  |  |  |  |  |  |  | 6 | 4 | Wk 5 | Site D | 12
 |  |  |  |  |  |  |  |  | 7 | 4 | Wk 6 | Site D | 13
 |  |  |  |  |  |  |  |  | 2 | 5 | Wk 1 | Site E | 10
 |  |  |  |  |  |  |  |  | 3 | 5 | Wk 2 | Site E | 20
 |  |  |  |  |  |  |  |  | 4 | 5 | Wk 3 | Site E | 30
 |  |  |  |  |  |  |  |  | 5 | 5 | Wk 4 | Site E | 40
 |  |  |  |  |  |  |  |  | 6 | 5 | Wk 5 | Site E | 50
 |  |  |  |  |  |  |  |  | 7 | 5 | Wk 6 | Site E | 60
Spreadsheet: 168860d1342612870-trying-to-excluding-the-2-highest-and-2-lowest-values-when-averaging-a-series-of-numbers-work-budget
Sheet: AVERAGE THURSDAY SALES

PREVIOUS 8 WEEKS OF THURSDAY
Spreadsheet: 109279d1306185136-comparing-grades-and-using-conditional-formatting-example
Sheet: Sheet1

Forename | Surname | Grade |  | Grade Values | Target | Target Values
asd | asd | A |  |  | A
dsa | dsa | A |  |  | #
wer | efwrgf | A |  |  | C
sdfgs | srgrf | B |  |  | A
awef | kuyuk | C |  |  | C
sdfr | fhtjkt | C |  |  | A
 |  |  |  |  |  |  |  | Lookup
 |  |  |  |  |  |  |  | # | 58
 |  |  |  |  |  |  |  | A | 52
 |  |  |  |  |  |  |  | B | 46
 |  |  |  |  |  |  |  | C | 40
 |  |  |  |  |  |  |  | D | 34
 |  |  |  |  |  |  |  | E | 28
 |  |  |  |  |  |  |  | F | 22
 |  |  |  |  |  |  |  | G | 16
 |  |  |  |  |  |  |  | U | 0
 |  |  |  |  |  |  |  |  | \
Spreadsheet: 864977d1712089910-help-extracting-values-from-cell-timeline-request-template-v3
Sheet: Digital

 |  | Totals |  |  |  |  |  |  |  |  |  |  |  | Links
 | Sq Ft |  |  |  | Total Print TIme |  | hrs |  | Upload of Art | 2024-05-14 00:00:00 |  |  |  | Large Job Gant Chart for KS.xlsx
 | [NAME] |  |  |  | Total Cutting Time |  | hrs |  | Proof Approvals | 2024-05-17 00:00:00 |  |  |  | PACE JOBS FOR MS.xlsx | MS List for Nathan
 |  |  |  |  | Total Pieces |  | pcs |  | Released to Production | 2024-05-20 00:00:00 |  |  |  | Timeline Requests (V3).xlsx | Timeline Sheet
 |  |  |  |  | Stores |  |  |  | Ship Date | 2024-06-11 00:00:00 |  |  |  | https://www.weprint.com/number-out-calculator.asp | ←#Up Calculator
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Scheduling Kansas.xlsx | ←Old Timelines
Press | SchedTime | Due Date | Job# | Line# | Master [NAME] | QTY | H | W | Material | Sides | PrintMode | Kitting | #OfKits | Notes | DateRecieved | SqFt | LinearFT | MatH | MatW | Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | NumUp | Sheets Needed
 |  |  |  |  |  | 100 | 20 | 20 | PAP- SO-  0040 - 48X96 20PT STYRENE | 1 | 4 Pass
 |  |  |  |  |  | 200 | 10 | 10 | PAP-  444451 - 48 X 96 15PT STYRENE | 1 | 4 Pass
 |  |  |  |  |  | 1000 | 20 | 20 | PAP-  412010 - 48X96 10PT STYRENE | 1 | 4 Pass
 |  |  |  |  |  | 300 | 15 | 25 | PAP-  442004 - 60X120 3MM SINTRA WHITE | 1 | 4 Pass
 |  |  |  |  |  | 1000 | 17 | 37 | PAP- SO-  1348 - GATORFOAM 3/16IN WBB 60X120 | 1 | 4 Pass
 |  |  |  |  |  | 500 | 10 | 10 | PAP- SO-  0013 - 50X99 .040 DEAD WHITE STYRENE | 1 | 4 Pass
 |  |  |  |  |  | 10 | 22 | 22 | PAP- SO-  1157 - 3MM ACM White 48X96 | 1 | 4 Pass
 |  |  |  |  |  | 1000 | 25 | 25 | PAP- SO-  1376 - FOAMCORE 1/2IN WHITE 60X120 | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheer Voile Fabric
Spreadsheet: 407027d1436850275-organizing-data-from-a-column-into-appropriate-columns-rain
Sheet: Output

Date | Sublocation | Student | Student # | Victim | Victim # | Teacher | Teacher # | IR #
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: West Power Admins

 | West Power Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  | % of |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  | Total Exp |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  |  | Compensation | 0 | 64
 | Special Pays |  |  |  |  | 0
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense |  |  |  |  | 12000
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  | 12000 |  |  |  | Total
ENAOUTSV | Outside Services |  |  |  |  | 48000
ENASUPP | Supplies Expense |  |  |  |  | 20736
ENAMKTEX | Marketing |  |  |  |  |  |  |  |  | [NAME] | 33600 | 1
ENACONTR | Charitable Contributions |  |  |  |  | 0 |  |  |  | [NAME] | 52800
ENARENT | Rent |  |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  | 6000 |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  | 0 |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  | 6000 |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 677322
 |  |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: d0773073-9e75-400f-9c70-3737ae13340c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
259739 | 75749 | [NAME] | Jaeger Ricalde | CHI |  | 00:45:15 | 00:00:55 | 03:44:00 | 00:01:20 | 01:47:24 | 1 | 06:18:54
259739 | 75747 | Julieta | Fliter | CHI |  | [NAME] | 00:01:58 | 03:59:05 | [NAME] | 02:13:14 | 2 | 07:01:00
Spreadsheet: 680360d1590979426-reconcile-text-based-data-corrections-sampleexcelproblem-may-31-2020
Sheet: Sheet1

Number | First Name | Last Name | [NAME]
1 | [NAME] | Adams | Cougars
2 | [NAME] | [NAME] | Rangers
3 | [NAME] | Coddington | Thunderbirds
4 | [NAME] | Demarest | Robots
5 | [NAME] | Earheart | Thunderbirds
6 | Fantasia | Fan | Lions
7 | [NAME] | Gall | Lions
8 | Hugh | [NAME] | Thunderbirds
9 | Ian | Innings | Rangers
10 | [NAME] | [NAME] | Cougars
11 | [NAME] | Kardashian | Rangers
12 | [NAME] | Leo | Rangers
13 | Moe | Moore | Thunderbirds
14 | [NAME] | Nimple | Robots
15 | [NAME] | [NAME] | Robots
16 | [NAME] | [NAME] | Robots
17 | Quinn | Smith | Lions
18 | Ricky | Smith | Rangers
19 | [NAME] | Smith | Thunderbirds
Spreadsheet: 300e332f-2654-4c63-916c-1a5c114aad06
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
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 36. Value of Building Approved - Northern Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A420418X | 1970-07-01 00:00:00 | 2011-04-01 00:00:00 | 490 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420430R | 1973-07-01 00:00:00 | 2011-04-01 00:00:00 | 454 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420442X | 1973-07-01 00:00:00 | 2011-04-01 00:00:00 | 454 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | [NAME] | 1970-07-01 00:00:00 | 2011-04-01 00:00:00 | 490 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422768K | 1973-07-01 00:00:00 | 2011-04-01 00:00:00 | 454 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 882120d1730377670-formula-producing-unexpected-duplicates-combined-sales-1-
Sheet: Combined

 |  |  |  |  |  |  |  |  |  |  | APAC
 |  |  |  |  |  |  |  | today date | today - 2 months | today + 3 months | geography
Potential Customer | Title
Spreadsheet: 747968d1631809800-formula-for-tiered-pricing-based-on-an-average-excel-example
Sheet: Sheet1

 | Total average  kilos | Trees | Price per Kilo Tier 1 | Tier 1 level (kgs) | Price per Kilo Tier 2 | [NAME] level (kgs) | Price per kilo [NAME]
 | 37 | 26 | 2.5 | 25 | 1.25 | 30 | 0.75
 | For every average kilo of walnuts harvested per tree, I have to pay $2.50 per kilo up to 0-25 kilos, $1.25 for 26-30 and .75 for every kilo over 30.
 | I am trying to write a formula that would calculate the total amount due.
 | In this example 26 trees were harvested for an average of 37 kilos per tree, my total cost would be:
 | [NAME] |  | Average Kilos per Tree | [NAME] | Total Price per Kilo
 | 0 | 25 | 25 | 2.5
 | 25 | 30 | 5 | 1.25
 | 30 | No cap | 7 | 0.75
 |  |  |  | Trees | 26
 |  |  |  | Total Amount Due
Spreadsheet: 854412d1704297080-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W3

IDs (Week 3 data(Week 13 since letter)) |  |  |  |  |  |  |  |  | IDs (Week 1 data (week 15 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date SMS Scheduled | SMS Status | Opted out? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 7463037074 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  | 1409665963 | 2024-08-15 00:00:00
Spreadsheet: 24831224-627d-466d-8f42-16ced77f8298
Sheet: at BRYC - Nov 4

SUNDAY, Nov 4, SCHEDULE
Home Club: | BRYC Elite |  | Locations: | Robinson High School
[NAME]: | Loudoun |  |  | [NAME] (U9/U10)
BRYC Elite wears All BLUE |  |  | http://brycsoccer.com/fielddirections/index_E.html
Loudoun will wear white jersey, black shorts, white socks
Robinson High School
17B | 10:45am | [NAME]
18G | 12:45am | [NAME]
18B | 2:45pm | [NAME]
16G | 4:45pm | [NAME]
Robinson High School |  |  |  |  |  | U13G-U15G games are re-scheduled
14B | 9:00am | Field Hockey - Bermuda |  |  |  | for Weds Nov 7 due to CASL.
13B | 10:30am | Field Hockey - Bermuda |  |  |  | Please see Nov 7 tab on this
17G | 12:00pm | Field Hockey - Bermuda |  |  |  | Excel sheet.
15B | 2:00pm | Field Hockey - Bermuda
16B | 3:45pm | Field Hockey - Bermuda
Robinson High School |  |  |  |  |  | U11G/U12G alternate date
11B | 9:00am | [NAME] 1A |  |  |  | will be announced.
12B | 8:00am | [NAME] 1B
[NAME]
10B-Black | 12:00pm | West Field 1 - Bermuda
9B-Red | 12:00pm | West Field 2 - Bermuda
10G-Red | 1:15pm | West Field 1 - Bermuda
9G-Black | 1:15pm | West Field 2 - Bermuda
10B-Red | 2:30pm | West Field 1 - Bermuda
9G-Red | 2:30pm | West Field 2 - Bermuda
10G-Black | 3:45pm | West Field 1 - Bermuda
9B-Black | 3:45pm | West Field 2 - Bermuda
Spreadsheet: 702115d1604086024-dragging-my-formula-wont-auto-update-cell-references-that-are-in-quotes-example
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2:49 PM
Transaction Journal |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-10-25 00:00:00
All Transactions
 | Trans # | Type | Date | Num | Name | Memo | Item | Item Description | Account | Class | Qty | Sales Price | Debit | Credit
 | 123495 | [NAME] | 2020-10-25 00:00:00 | 39328 | Our-Project Budget | [NAME] 998624: Estimate 95734: |  |  | 2 · Purchase Orders | 000 Install
 |  |  |  |  | ELECTRIC CO:998624 | Estimated Material Cost to Complete Project $ 173447.00, SECT 27000, $ 20,995.00 FOR SECT. 28000 | Est MATERIAL (Estimated Material Cost to Complete Project) | Estimated Material Cost to Complete Project | 4906 · BID/QUOTE ADJ-MATERIALS | 000 Install | 1 | 0 | 0
 |  |  |  |  | ELECTRIC CO:998624 | FIBER TESTING ESTIMATE | FIBER TESTING (FIBER TESTING ESTIMATE) | FIBER TESTING ESTIMATE | 1220 · CABLING INVENTORY | 000 Install | 1 | 600 | 600
 |  |  |  |  | ELECTRIC CO:998624 | ORTRONICS 48 PORT 2/8 25M V SPS, AMPHENOL | ORTR808004042 (ORTRONICS 48 PORT 2/8 25M V SPS, AMPHENOL) | ORTRONICS 48 PORT 2/8 25M V SPS, AMPHENOL | 1220 · CABLING INVENTORY | 000 Install | 18 | 166.75 | 3001.5
 |  |  |  |  | ELECTRIC CO:998624 | ALLENTEL DOUBLE GANG MTG BOXIVORY | ALLEAT45MB-09 (ALLENTEL DOUBLE GANG MTG BOXIVORY) | ALLENTEL DOUBLE GANG MTG BOXIVORY | 1220 · CABLING INVENTORY | 000 Install | 30 | 5.36 | 160.8
 |  |  |  |  | ELECTRIC CO:998624 | ALLENTRL SINGLE GANG MNTG BOX FOR AT 30 IVORY | ALLEAT30M-09 (ALLENTRL SINGLE GANG MNTG BOX FOR AT 30 IVORY) | ALLENTRL SINGLE GANG MNTG BOX FOR AT 30 IVORY | 1220 · CABLING INVENTORY | 000 Install | 25 | 2.98 | 74.5
Spreadsheet: 736591d1623758121-matrix-lookup-non-array-inout
Sheet: input

 |  |  |  |  |  |  |  |  |  |  |  | < [NAME]
 |  |  |  |  |  |  |  | Shrawan | % | Bhadra | % | < [NAME]
 | IT
 | PG |  |  |  |  |  |  |  | 1.02065970830209 | 121958 | 1.36820205364533
 | MB |  |  |  |  |  |  | 32 |  | 362
 | TC
 | OT
Match 1 > | Pshet |  |  |  |  |  |  | 127213.8 | 97.9758475685833 | 89402 | 73.0886200130804
 | PW |  |  |  |  |  |  | 2596.2 |  | 32556
 | DL
Spreadsheet: 0700e193-8b5a-47b1-b86b-b766ca8adaef
Sheet: MiddleCharter

 | Middle
 |  | Alcohol | Tobacco | Other Drugs | Distribution | Assaults | [NAME] | Handgun | Rifle | Other Firearm | Other Weapon | Totals
 | Charter
 | AMES
 | City Academy
 | [NAME]--North
 | [NAME]
 | Walden School of Liberal Arts |  |  | 1 |  | 1
 | Early Light Academy at Daybreak |  |  |  |  |  |  |  |  |  | 1
 | Charter School Total:
 | Grand Total: |  |  |  |  |  |  |  |  |  |  | 1733
Spreadsheet: 36481d1234364260-invoice-address-query-invoice-test
Sheet: ADDRESSES

NAMES | [NAME] | ADD2 | [NAME] | POSTCODE
Mr A | a1 | a2 | a3 | aa1 1aa
Mr B | b1 | b2 | b3 | bb1 1bb
Mrs C | c1 | c2 | c3 | [NAME] 1cc
Spreadsheet: 598778d1542718070-returning-a-sum-and-max-result-dependent-on-data-return-sum-and-max-result
Sheet: Sheet1

 | Date | Exercise | Weight ([NAME]) | Add. Weight ([NAME]) | Total Weight ([NAME]) | Set1 | Set2 | Set3 | Set4 | Set5 | Total Reps | Rest Period | Time | Notes
 |  | Press-Ups | 82 | 10 |  | 25 | 30 | 20 | 16 | 12
 |  | [NAME] | 82 | 10 |  | 10 | 8 | 6 | 16 | 12
 |  | Press-Ups | 82 | 10 |  | 22 | 31 | 21 | 16 | 12
 |  | Press-Ups | 82 | 10 |  | 25 | 27 | 20 | 16 | 12
Spreadsheet: 768330d1644928769-trying-to-look-up-and-filter-data-example
Sheet: KROK050

KROK050
Product | Component name | Result text
Spreadsheet: 773826d1648056725-conditional-formatting-for-date-values-between-1st-of-each-month-and-15th-16th-and-eom-condformattingdates
Sheet: Times

AM | PM
04:00:00 | 12:00:00
04:15:00 | 12:15:00
04:30:00 | 12:30:00
04:45:00 | 12:45:00
05:00:00 | 13:00:00
05:15:00 | 13:15:00
05:30:00 | 13:30:00
05:45:00 | 13:45:00
06:00:00 | 14:00:00
06:15:00 | 14:15:00
06:30:00 | 14:30:00
06:45:00 | 14:45:00
07:00:00 | 15:00:00
07:15:00 | 15:15:00
07:30:00 | 15:30:00
07:45:00 | 15:45:00
08:00:00 | 16:00:00
08:15:00 | 16:15:00
08:30:00 | 16:30:00
08:45:00 | 16:45:00
09:00:00 | 17:00:00
09:15:00 | 17:15:00
09:30:00 | 17:30:00
09:45:00 | 17:45:00
10:00:00 | 18:00:00
10:15:00 | 18:15:00
10:30:00 | 18:30:00
10:45:00 | 18:45:00
11:00:00 | 19:00:00
11:15:00 | 19:15:00
11:30:00 | 19:30:00
11:45:00 | 19:45:00
12:00:00 | 20:00:00
 | 20:15:00
 | 20:30:00
 | 20:45:00
 | 21:00:00
Spreadsheet: 0f05b788-4497-4e9e-a8d7-71ed8a579a37
Sheet: 5

 | Nov 2 | Nov 9 | Nov 16 | Nov 23 | Nov 30
Total Interest Rates* | 84500 | 84500 | 84500 | 84500 | 84500
Cleared** | N/A*** | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 3500 | 3500 | 3500 | 3500 | 3500
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equities | 25000 | 25000 | 25000 | 25000 | 25000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Commodities | 105000 | 105000 | 105000 | 105000 | 105000
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | 323000 | 323000 | 323000 | 323000 | 323000
Weekly total, estimated swap event volumes by asset class and cleared status (in number of events), all products, tenors, and participant types.
Estimates of weekly event volumes are derived from data published in the 2012 ISDA Operations Benchmarking Survey, which defines an "event" as a new trade, confirmable amendment, partial or full termination, increase, decrease, or novation.
*See Data Dictionary for asset class descriptions.
**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: 864166d1711458686-need-help-to-show-duplicate-values-and-count-it-with-or-without-specific-criteria-duplicate-values
Sheet: Sheet1

I need Help : | 1. what is the formula to show the duplicate values or text with specific length (ex : text with the length is 11)
 | 2. what is the formula to count the number of duplicate values or text with specifit length
 | 2. what is the formula to count the number of all duplicate values
Name 1 | Name 2 | Name 3 | Name 4 | Name 5 | Name 6 | Name 7 | Name 8 | Name 9 | Name 10 | Name 11 | [NAME] | Count Duplicate specific criteria | Count all duplicate Value (not blank)
MRTU2238220 | MRTU2200250 | MRTU9604228 | A | A | B | B |  |  |  |  |  |  | 2
MRTU2227884
MRTU9608579
MRTU2242282 | MRTU2185372 | MRTU2242282 | MRTU2200857 | MRTU2242282 | MRTU2200857 | HPCU2232947 | HPCU2231489 | HPCU2230435 | A | A | MRTU2242282,MRTU2200857 | 2 | 3
MRTU2056267 | MRTU2128808