tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 108050d1305149862-auto-populating-excel-calendar-ts1019273743
Sheet: JAN

 | January 2011
 | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  |  |  |  |  |  |  |  |  |  |  |  | 1 | New Year's Day
 | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8
 | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15
 | 16 |  | 17 | [NAME], Jr | 18 |  | 19 |  | 20 |  | 21 |  | 22
 |  |  |  | Day
 | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29
 | 30 |  | 31
Spreadsheet: 72652d1273341216-search-multiple-worksheets-acme-schedules
Sheet: TRACKING 

WORK CATEGORY CODES: |  |  |  |  | DIVISION/ [NAME]:
W – WORK           SA – SPECIAL ASSIGNMENT    SL – SICK LEAVE
DO – DAY OFF        HW – HOLIDAY WORKED        AV – ADVANCE |  |  |  |  | STORE 1811
AL – ANNUAL LEAVE   WT – WORK/TRAVEL
 |  | PERIOD COVERED |  |  | SHIFT:
 |  |  |  |  | TRACKING SECTION
 | NAME | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THRUSDAY | FRIDAY | SATURDAY
1 | B. LEER |  |  |  |  |  |  |  | B. LEER | B. LEER | B. LEER | B. LEER | B. LEER | B. LEER | B. LEER
2 | R. CAFÉ |  |  |  |  |  |  |  | R. CAFÉ | R. CAFÉ | R. CAFÉ | R. CAFÉ | R. CAFÉ | R. CAFÉ | R. CAFÉ
3 | R. RABDWELL |  |  |  |  |  |  |  | R. RABDWELL | R. RABDWELL | R. RABDWELL | R. RABDWELL | R. RABDWELL | R. RABDWELL | R. RABDWELL
4 | P. BRAND |  |  |  |  |  |  |  | P. BRAND | P. BRAND | P. BRAND | P. BRAND | P. BRAND | P. BRAND | P. BRAND
5 | B. LORRELL | SA 60/3A 8A-7P |  |  |  |  |  |  | B. LORRELL | B. LORRELL | B. LORRELL | B. LORRELL | B. LORRELL | B. LORRELL | B. LORRELL
6 | J. DEMAYO |  |  |  |  |  |  |  | J. DEMAYO | J. DEMAYO | J. DEMAYO | J. DEMAYO | J. DEMAYO | J. DEMAYO | J. DEMAYO
7 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
8 | M. HANSTEEL |  |  |  |  |  |  |  | M. HANSTEEL | M. HANSTEEL | M. HANSTEEL | M. HANSTEEL | M. HANSTEEL | M. HANSTEEL | M. HANSTEEL
9 | E. GUARD |  |  |  |  |  |  |  | E. GUARD | E. GUARD | E. GUARD | E. GUARD | E. GUARD | E. GUARD | E. GUARD
10 | B. ROLD |  |  | SA 60/3A 8A-7P |  |  |  |  | B. ROLD | B. ROLD | B. ROLD | B. ROLD | B. ROLD | B. ROLD | B. ROLD
11 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
12 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
13 | C. MARIEACH |  |  |  |  |  |  |  | C. MARIEACH | C. MARIEACH | C. MARIEACH | C. MARIEACH | C. MARIEACH | C. MARIEACH | C. MARIEACH
14 | M. MIT |  |  |  |  |  |  |  | M. MIT | M. MIT | M. MIT | M. MIT | M. MIT | M. MIT | M. MIT
15 | K. TACKLE |  |  |  |  |  |  |  | K. TACKLE | K. TACKLE | K. TACKLE | K. TACKLE | K. TACKLE | K. TACKLE | K. TACKLE
16 | D. PICELI |  |  |  |  |  | SA 60/3A 8A-7P |  | D. PICELI | D. PICELI | D. PICELI | D. PICELI | D. PICELI | D. PICELI | D. PICELI
17 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
18 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
19 | [NAME] |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
20 | [NAME] |  |  |  |  | SA 60/3A 8A-7P |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
21 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
22 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
23 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
24 |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TOTAL SOT:
 | CITIES
 | SHIFT:
 | TEMPS:
PREPARED BY |  |  |  |  | SIGNATURE
BRAD PITT |  |  |  |  | [NAME]
Spreadsheet: 879101d1726563731-auto-highlighting-and-extracting-in-other-table-the-not-mathing-numbers-book100
Sheet: Sheet1

DATA |  |  |  |  |  |  |  |  |  |  | HIGHLIGHT THE NUMBERS |  |  |  |  |  |  |  |  |  |  |  | RESULT HERE NOT MATCHING NUMBERS
 | Table A |  |  |  |  |  | Table B |  |  |  |  | Table A |  |  |  |  |  | Table B |  |  |  |  |  | Table A |  |  |  | Table B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Not Maching Numbers against B |  |  |  | Not Maching Numbers against A
Reference | D | C |  |  |  | Reference | C | D |  |  | Reference | D | C |  |  |  | Reference | C | D |  |  |  | Reference | D | C |  | Reference | C | D
NJv : 2323 | 5000 | 0 |  |  |  | BPmt : 1066 | 0 | 5000 |  |  | NJv : 2323 | 5000 | 0 |  |  |  | BPmt : 1066 | 0 | 5000 |  |  |  | NJv : 2596 | 0 | 4348 |  | NJv : 999 | 33 | 0
BPmt : 2838 | 19550 | 0 |  |  |  | NJv : 999 | 0 | 19550 |  |  | BPmt : 2838 | 19550 | 0 |  |  |  | NJv : 999 | 0 | 19550 |  |  |  | NJv : 2596 | 0 | 652 |  | BPmt : 1302 | 8889 | 0
NJv : 2596 | 0 | 4348 |  |  |  | NJv : 999 | 33 | 0 |  |  | NJv : 2596 | 0 | 4348 |  |  |  | NJv : 999 | 33
NJv : 2596 | 0 | 652 |  |  |  | BPmt : 1302 | 8889 | 0 |  |  | NJv : 2596 | 0 | 652 |  |  |  | BPmt : 1302 | 8889
BPmt : 3139 | 0 | 17000 |  |  |  | NJv : 1265 | 17000 | 0 |  |  | BPmt : 3139 | 0 | 17000 |  |  |  | NJv : 1265 | 17000
NJv : 2779 | 0 | 2550 |  |  |  | NJv : 1265 | 2550 | 0 |  |  | NJv : 2779 | 0 | 2550 |  |  |  | NJv : 1265 | 2550
NJv : 2779 | 20000 | 0 |  |  |  | BPmt : 1533 | 0 | 20000 |  |  | NJv : 2779 | 20000 | 0 |  |  |  | BPmt : 1533 | 0 | 20000
BPmt : 3450 | 0 | 18000 |  |  |  | NJv : 1443 | 18000 | 0 |  |  | BPmt : 3450 | 0 | 18000 |  |  |  | NJv : 1443 | 18000
NJv : 3003 | 0 | 2550 |  |  |  | NJv : 1443 | 2550 | 0 |  |  | NJv : 3003 | 0 | 2550 |  |  |  | NJv : 1443 | 2550
NJv : 3003 | 14000 | 0 |  |  |  | BPmt : 1781 | 0 | 14000 |  |  | NJv : 3003 | 14000 | 0 |  |  |  | BPmt : 1781 | 0 | 14000 |  |  |  | NJv : 2596 | 0 | 652 |  | BPmt : 1302 | 8889 | 0
BPmt : 3606 | 0 | 17000 |  |  |  | NJv : 1615 | 17000 | 0 |  |  | BPmt : 3606 | 0 | 17000 |  |  |  | NJv : 1615 | 17000
NJv : 3218 | 0 | 2400 |  |  |  | NJv : 1615 | 2400 | 0 |  |  | NJv : 3218 | 0 | 2400 |  |  |  | NJv : 1615 | 2400
NJv : 3218 | 15000 | 0 |  |  |  | BPmt : 1922 | 0 | 15000 |  |  | NJv : 3218 | 15000 | 0 |  |  |  | BPmt : 1922 | 0 | 15000
Spreadsheet: john_forney__15504__200107
Sheet: Hourly SE

Hourly SE
 |  | Deal Number | Total
Static Scheduling | Reliant Energy HL&P | 503490
 | Texas New Mexico Power | 492266
 | [NAME]
 | [NAME]
Unplanned Losses | American Electric Power Services Corp | 566689
 | [NAME] | 566690
 | [NAME] | 566691
 | Bryan Texas Utilities | 492270
 | City of Denton Municipal Utilities
 | City of Garland | 492271
 | City Public Services | 566692
 | Farmer's Electric Cooperative
 | Grayson-Collin Electric Cooperative
 | Greenville Electric Utility System
 | Lower Colorado River Authority | 566693
 | Magic Valley Electric Cooperative
 | Public Utilities Board of Brownsville
 | Reliant Energy HL&P | 566695
 | Rio Grande Electric Cooperative
 | South Texas Electric Cooperative | 492275
 | Southwest Electric Service Company
 | Texas Municipal Power | 566696
 | Texas New Mexico Power | 492277
 | Tex-La Electric Cooperative
 | TXU Electric Services | 566697
password for Totals sheet = ercot
 | Counterparty Name |  | TOTAL MW |  | TOTAL DOLLAR
 | American Electric Power Services Corp | WTUC | -0.290317493179385 |  | -13.5955682055906
 | American Electric Power Services Corp | CPLC | -1.358094221116819 |  | -63.59955237490065
 | [NAME] | AENX | -1.251667649000585 |  | -58.61559600269737
 | [NAME] | BEPCTMPP | 1.877210641359102 |  | 87.90977433484674
 | Bryan Texas Utilities | BRYN | -0.02947847444494077 |  | -1.380476958256576
 | City of Denton Municipal Utilities | CODX | 0 |  | 0
 | City of Garland | COGX | 0.01483719947082507 |  | 0.6948260512187379
 | City Public Services | CPST | -1.763504873078823 |  | -82.58493320628125
 | Farmer's Electric Cooperative | FECX | 0.0004102900750830837 |  | 0.01921388421614081
 | Grayson-Collin Electric Cooperative | GCEC | 0 |  | 0
 | Greenville Electric Utiliy System | GEUS | 0 |  | 0
 | Lower Colorado River Authority | LCRA | -0.8506392662428561 |  | -39.83543683815295
 | Magic Valley Electric Cooperative | MVEC | 0.001881960420925615 |  | 0.08813220651194653
 | Public Utilities Board of Brownsville | PUBX | 0 |  | 0
 | Reliant Energy HL&P | REIT | -4.45714813772012 |  | -208.7282472894332
 | Rio Grande Elerctic Cooperative | RGEC | 0 |  | 0
 | South Texas Electric Cooperative | STEC | -0.167846602440176 |  | -7.860256392273439
 | South Texas Electric Cooperative | SMEC | -0.02658142906857432 |  | -1.244808323281335
 | South Texas Electric Cooperative | MECX | -0.1026965403634323 |  | -4.809278985219536
 | Southwest Electric Service Company | SESC | 0 |  | 0
 | Texas Municipal Power | TMPA | -0.09593999510390921 |  | -4.49286997071607
 | TXU Electric Services | TUET | -3.352392263374075 |  | -156.9925296938079
 | Texas New Mexico Power | TNMP | 0.4385332153265282 |  | 20.53651047374131
 | Tex-La Electric Cooperative | TXLA | 0 |  | 0
 | TXU Electric Services | TNMPTUET | 0.001641160300332335 |  | 0.07685553686456324
 | TXU Electric Services | COCS | 0.002142813218824173 |  | 0.100347943037536
 | TXU Electric Services | TVEC | 0 |  | 0
 |  | TOTAL | -11.40964966496207 |  | -534.3138938101739
Spreadsheet: 183948d1349100436-need-help-with-conditional-formatting-problem-please-help-tf-performance-2-latest-q3
Sheet: Sheet14

Ops # | Month | Date | Year | Client | Buyer | Cargo Type | Nominated Cargo Quantity (MT) | Support Craft | Invoiced Ammount ($) | Commenced Fendering | Completed Fendering | Total Fendering Time | Mooring Master
998 | July |  | 2012 | Addax |  | PMS | 4000 |  | 8901.39 | 16:42:00 | 17:34:00 | 00:52:00 | Briseimo Benedict
Spreadsheet: jeff_dasovich__14065__m010501
Sheet: Costs assumed

 |  | SCE  10 year Generation Mix with QF's at $81.13
 |  |  |  |  |  |  | Total
 |  | Nuclear | Coal | Hydro | Total Gen | QFs | Resources
 | Mix | 0.3143761244792401 | 0.1788691947317992 | 0.07336463608922013 | 0.5670798568684643 | 0.4329201431315362 | 1
 | Cost | 48.72 | 23 | 34 | 38.71651568318014 | 81.129447854405
 |  |  | Mix |  | Rate |  | Gen Cost
 | DWR |  | 0.363 |  | 3.7
 | Retained Generation
 | QF
 | Subtotal SCE |  |  |  | 4.9
 | Total
 |  | SCE  10 year Generation Mix with QF's at $120.00
 |  |  |  |  |  |  | Total
 |  | Nuclear | Coal | Hydro | Total Gen | QFs | Resources
 | Mix | 0.3143761244792401 | 0.1788691947317992 | 0.07336463608922013 | 0.5670798568684643 | 0.4329201431315362 | 1
 | Cost | 48.72 | 23 | 34 | 38.71651568318014 | 120
 |  |  | Mix |  | Rate |  | Gen Cost
 | DWR |  | 0.363 |  | 3.7
 | Retained Generation
 | QF
 | Subtotal SCE |  |  |  | 4.9
 | Total
Spreadsheet: 683442d1592739206-google-sheets-merge-dynamic-ranges-automatically-skipping-rows-without-a-visible-data-merge
Sheet: Sheet1

RANGE1 |  |  | RANGE2 |  |  | COMBINED RANGE1+RANGE2
MEAL NAME 1 | 51 |  | MEAL NAME 102 | 75
MEAL NAME 2 |  |  | MEAL NAME 103
MEAL NAME 3 |  |  | MEAL NAME 104 |  |  | MEAL NAME 1 | 51
MEAL NAME 4 |  |  | MEAL NAME 105 |  |  | MEAL NAME 2 | 52
MEAL NAME 5 |  |  | MEAL NAME 106 |  |  | MEAL NAME 3 | 53
MEAL NAME 6 |  |  | MEAL NAME 107 |  |  | MEAL NAME 4 | 54
MEAL NAME 7 |  |  | MEAL NAME 108 |  |  | MEAL NAME 5 | 55
MEAL NAME 8 |  |  | MEAL NAME 109 |  |  | MEAL NAME 6 | 56
MEAL NAME 9 |  |  | MEAL NAME 110 |  |  | MEAL NAME 7 | 57
MEAL NAME 10 |  |  | MEAL NAME 111 |  |  | MEAL NAME 8 | 58
MEAL NAME 11 |  |  | MEAL NAME 112 |  |  | MEAL NAME 9 | 59
MEAL NAME 12 |  |  | MEAL NAME 113 |  |  | MEAL NAME 10 | 60
 |  |  |  |  |  | MEAL NAME 11 | 61
 |  |  |  |  |  | MEAL NAME 10 | 62
 |  |  |  |  |  | MEAL NAME 102 | 75
 |  |  |  |  |  | MEAL NAME 103 | 76
 |  |  |  |  |  | MEAL NAME 104 | 77
 |  |  |  |  |  | MEAL NAME 105 | 78
 |  |  |  |  |  | MEAL NAME 106 | 79
 |  |  |  |  |  | MEAL NAME 107 | 80
 |  |  |  |  |  | MEAL NAME 108 | 81
 |  |  |  |  |  | MEAL NAME 109 | 82
 |  |  |  |  |  | MEAL NAME 110 | 83
 |  |  |  |  |  | MEAL NAME 111 | 84
 |  |  |  |  |  | MEAL NAME 112 | 85
 |  |  |  |  |  | MEAL NAME 113 | 86
Spreadsheet: 128632d1321124144-if-test-doesnt-work-to-match-data-any-ideas-800948-if-test-example1
Sheet: Sheet3

Enter Scan Here: | 7057000002 | <----- This is where the sanned number will be entered
Item # | Reorder At | SKU# | Qty on hand | Item | Unit Count | Unit Price | Unit Cost | Total Cost
Resulting Data | Will Then | Be entered | into | These | Cells. When | This Line | Has been | Populated,
The next scan will | Then populate | This row | And | So | On
 |  |  |  |  |  |  |  |  | <--- example output for scanned number.
=INDEX(Sheet1!A:A,MATCH(Sheet3!$C9,Sheet1!$C:$C,0))
drag across >> | =INDEX(Sheet1!B:B,MATCH(Sheet3!$C9,Sheet1!$C:$C,0))
 |  | =B4
 |  |  | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(D9)-2,FALSE)
 |  |  | drag across >> | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(E9)-2,FALSE)
 |  |  | drag across >> |  | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(F9)-2,FALSE)
 |  |  | drag across >> |  |  | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(G9)-2,FALSE)
 |  |  | drag across >> |  |  |  | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(H9)-2,FALSE)
 |  |  | drag across >> |  |  |  |  | =VLOOKUP($C9,Sheet1!$C:$I,COLUMN(I9)-2,FALSE)
Spreadsheet: 4b942e4f-b7f1-4334-8f01-f88ee5466fdf
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7612 | 22738 | Rafael | López Ordoñez | ESP | 71 | 00:20:10 | 00:01:00 | 00:47:31 | 00:00:00 | 00:00:00 | 1 | [NAME]
7612 | 64221 | Gerard | Ah-Fook | USA | 72 | 00:18:22 | 00:01:12 | 00:33:57 | 00:00:00 | 00:00:00 | DQ | 00:00:00
Spreadsheet: 835624d1688686922-conditional-formatting-highlight-cells-based-on-time-kayz0220-monthly-timesheet
Sheet: Participant Timesheet

Month:
Name:
Date | Time In | Time Out | Total Hours | Days Billed | $ [NAME]
1 | 07:00:00 | 09:00:00 |  | 1
 | 07:00:00 | 09:30:00 |  | 1
 | 07:00:00 | 10:00:00 |  | 1
 | 07:00:00 | 10:30:00 |  | 1
 | 07:00:00 | 11:00:00 |  | 1
 | 07:00:00 | 11:01:00 |  | 1
 | 07:00:00 | 12:00:00 |  | 1
 | 07:00:00 | 12:30:00 |  | 1
 | 07:00:00 | 13:00:00 |  | 1
 | 07:00:00 | 13:30:00 |  | 1
 | 07:00:00 | 14:00:00 |  | 1
Example: | 10:00:00 | 17:15:00 |  | 1
Nevada State Medicaid per diem daily rate
$57.20 per day
*Over four (4) hours, shall pay the full rate |  |  | 57.2
*Four (4) hours or less, shall pay 1/2 the daily rate |  |  | 28.6
 |  |  |  | Total Days | Invoice Amount
Spreadsheet: 490701d1480006236-random-color-conditional-formating-political-parties
Sheet: List1

 | Political parties | Result
 | abc | 20
 | bbc | 15
 | cdc | 10
 | efc | 8
 | gds | 7
 | lds | 5
 | uts | 6
 | [NAME] | 8
 | wul | 9
 | mat | 10
 | std | 2
Spreadsheet: 855271d1704899110-excel-calendar-display-to-do-item-across-calendar-dates-test-calendar-v1
Sheet: May

 |  |  | MAY
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 |  | 5
5
3
2
Spreadsheet: 114734d1310470065-total-from-multiple-spreadsheets-music2011sales
Sheet: TOTALS

[NAME] | Album Title | # Sold EUR | # [NAME] | # Sold CAN | # [NAME] | TOTAL # [NAME] |  | MONTH | Songs | Albums
[NAME] | Ringtone | 1072 | 3 | 0 | 9 | 1084 |  | JANUARY | 10 | 0
Touching Things Is Fun (the Winky Song) | Touching The Winky | 77 | 4 | 1 | 28 | 110 |  | FEBRUARY | 15 | 1
Funt | Touching The Winky | 6 | 0 | 0 | 3 | 9 |  | [NAME] | 241 | 1
Boobs | Touching The Winky | 3 | 3 | 1 | 0 | 7 |  | APRIL | 407 | 1
Titty Titty Gash Gash | Touching The Winky | 6 | 0 | 0 | 0 | 6 |  | MAY | 173 | 0
Penguins | Touching The Winky | 4 | 0 | 0 | 0 | 4 |  | [NAME] | 210 | 0
Robots | The Triple Coiler | 0 | 4 | 0 | 0 | 4 |  | JULY | 185 | 1
It's a Penis | Touching The Winky | 2 | 1 | 0 | 0 | 3 |  | AUGUST | 0 | 0
Willies from Mars | Touching The Winky | 3 | 0 | 0 | 0 | 3 |  | SEPTEMBER | 0 | 0
Found Some Poo | The Triple Coiler | 2 | 0 | 0 | 0 | 2 |  | OCTOBER | 0 | 0
Funt (Ringtone) | Ringtone | 1 | 0 | 0 | 0 | 1 |  | NOVEMBER | 0 | 0
Heads Shoulders Knees and Toes | The Triple Coiler | 0 | 1 | 0 | 0 | 1 |  | DECEMBER | 0 | 0
Meat | Touching The Winky | 1 | 0 | 0 | 0 | 1
Midgets On Your Moon | Touching The Winky | 1 | 0 | 0 | 0 | 1 |  | TOTALS | 1241 | 4
Shapes (Animation Remix) | Touching The Winky | 0 | 0 | 0 | 1 | 1
The Nature Song | The Triple Coiler | 0 | 1 | 0 | 0 | 1
Vegetables | Touching The Winky | 0 | 1 | 0 | 0 | 1
Addicted to Cheese | Touching The Winky | 0 | 0 | 0 | 0 | 0
Beak | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Dairy | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Everybody Love Their Fruit | Touching The Winky | 0 | 0 | 0 | 0 | 0
Funt (remix) | Touching The Winky | 0 | 0 | 0 | 0 | 0
Furtive Bear | The Triple Coiler | 0 | 0 | 0 | 0 | 0
[NAME] | The Triple Coiler | 0 | 0 | 0 | 0 | 0
I Killed My Girlfriend | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Moustache | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Pit | Touching The Winky | 0 | 0 | 0 | 0 | 0
Pretty Fishy | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Shapes | Touching The Winky | 0 | 0 | 0 | 0 | 0
Touching Things Is Goth | Touching The Winky | 0 | 0 | 0 | 0 | 0
Up The Bum | The Triple Coiler | 0 | 0 | 0 | 0 | 0
Spreadsheet: 800395d1665650761-combine-data-in-2-rows-into-1-single-row-data1
Sheet: Formulate here

 |  |  | Team Names |  | Team Score |  | Team Odds
Date | Time | Playoff - Y/N | Team 1 | Team 2 | Team 1 | Team 2 | Team 1 | Team 2
2022-01-28 00:00:00 | 16:40:00 | Y | [NAME] | [NAME] | 171 | 92 | 1.45 | 2.82
Spreadsheet: daren_farmer__6617__Cilco
Sheet: Jan for cilco

 |  |  |  | CILCO CONTACTS:
CILCO STORAGE |  |  |  | [NAME]
 |  |  |  | PH: (309) 677-5166
BEG. BALANCE |  | 1536188 |  | VONDA SECKLER
 |  |  |  | PH:  (309) 677-5164
NOM. | REC | DEL. |  | FAX: (309) 677-5506
EFF. DATE | VOLUME | VOLUME | STORAGE BAL.
1997-01-01 00:00:00 | 28144 | 27300
 | 28144 | 27300
 | 28144 | 27300
 | 28144 | 27300 |  |  | Average nom to get storage to = 0
 | 28144 | 27300
 | 10310 | 10000 |  |  | 25155
 | 10310 | 10000
 | 10310 | 10000
 | 28867 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 28866 | 28000
 | 20619 | 20000
Spreadsheet: 85516d1285618141-using-weekly-data-to-convert-to-monthly-quote-analyzer
Sheet: 20-09-10

Job # | Quote Value | Sector | Description | Job Won | Sectors | Job Won |  | Building |  |  |  |  |  | Landscaping
1 | 2820 | Building | 41 Brookfiels Avenue, Poynton | No | Building | Yes
2 | 7520 | Building | 191 Outward Road, [NAME] | No | Landscaping | No
Spreadsheet: 678928d1590129385-formula-that-results-in-data-input-moving-down-a-column-based-on-another-column-cell-data-moving-down-cell-calculations
Sheet: Sheet1

Col.1 | Col.2 | Col.3
2 | #3 | #3
3 | #9 | #3
4 | #10 | #9
1 | #11 | #9
 |  | #9
 |  | #10
 |  | #10
 |  | #10
 |  | #10
 |  | #11
Spreadsheet: 36a96fcb-04a7-49f3-b44c-5b462983f691
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
2013 Area N Spring Select
Team Application - One per team representing your Region
Region Number:
Team Name: |  |  |  |  | Division |  |  | B | G
 |  |  |  |  |  |  |  | Circle one
Coach Name: |  |  |  |  | Home # |  |  | Cell # |  |  | [NAME]
Coach Full Address: |  |  |  |  |  |  |  |  |  | State / Zip Code
Coach [NAME]: |  |  |  |  |  | AYSO ID #: |  |  |  |  | Safe Haven Date ___________________
Asst. Coach Name: |  |  |  |  | Home # |  |  | Cell # |  |  | [NAME]
Asst. Coach Full Address: |  |  |  |  |  |  |  |  |  | State / Zip Code
[NAME]. Level: |  |  |  |  |  | AYSO ID # |  |  |  |  | Safe Haven Date ___________________
Team Manager Name |  |  |  |  | Home # |  |  | Cell# |  |  | [NAME]
Team Mgr Full Address: |  |  |  |  |  |  |  |  |  | State / Zip Code
Team Mgr. Cert. Level |  |  |  |  |  | AYSO ID # |  |  |  |  | Safe Haven Date ___________________
Attached eAYSO team roster (Signed by RC) |  |  |  |  |  | Yes |  | No
 |  |  |  |  |  | (Circle One)
Attached Team T-Shirt Order |  |  |  |  |  | Yes |  | No
 |  |  |  |  |  | (Circle One)
Spreadsheet: 687102d1594966727-calculate-total-in-range-that-are-before-specific-time-sample-from-actual
Sheet: TGDR Revised

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1200 | 1400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1300 | 1500
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1400 | 1600
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1500 | 1700
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1600 | 1800
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1700
 |  |  |  |  |  |  |  |  | Time Opened | Time Closed | Hours   Open |  |  |  |  |  | 1800
 |  |  |  |  |  |  |  | B1 | 1700 | 0100 | 8 |  |  |  |  |  | 1900
 |  |  |  |  |  |  |  | B2 |  | 0100 | 8 |  |  |  |  |  | 2000
 |  |  |  |  |  |  |  | B3 |  | 0056 | 8 |  |  |  |  |  | 2100
 |  |  |  |  |  |  |  | S1 |  | 0015 | 7.25 |  |  |  |  |  | 2200
 |  |  |  |  |  |  |  | T1 |  | 0115 | 8.25 |  |  |  |  |  | 2300
 |  |  |  |  |  |  |  | P1 |  | 0040 | 7.75 |  |  |  |  |  | 2400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0100
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0300
Time | Slots Open
1700 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
 | 6
 | 4
Total
Spreadsheet: 473852d1470433359-too-much-repetitive-data-jwheeler
Sheet: Sheet2

Office number | office name | office address | office city | office state | office [NAME] | Corp | contact title | contact | contact phone | contact email | Management | contact title | contact | contact phone | contact email | Sales | contact title | contact | contact phone | contact email | Service | contact title | contact | contact phone | contact email
Spreadsheet: 887642d1737910837-filter-filter-spill-365-aligw
Sheet: DadosA

Nº | ITENS | DATA | RESP | JAN | FEV | MAR | ABR | MAI | JUN
1 | A | 2025-01-01 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
2 | B | 2025-01-02 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
3 | B | 2025-01-03 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
4 | B | 2025-01-04 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
5 | B | 2025-01-05 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
6 | A | 2025-01-06 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
7 | A | 2025-01-07 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
8 | A | 2025-01-08 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
9 | B | 2025-01-09 00:00:00 | João | 1 | 2 | 3 | 4 | 5 | 6
Spreadsheet: 77019d1277465690-average-function-caclulate-the-average-time-spent-help
Sheet: Sheet1

Who Solved | Calculated MTTF
[NAME] | 1900-07-03 15:40:39
[NAME] | 1900-07-03 16:40:39
[NAME] | 1900-07-03 17:40:39
[NAME] | 1900-07-03 18:40:39
[NAME] | 1900-07-03 19:40:39
[NAME] | 1900-07-03 20:40:39
[NAME] | 1900-07-03 21:40:39
[NAME] | 1900-07-03 22:40:39
[NAME] | 1900-07-03 23:40:39
 |  | I am tring to get the avergaes per using the Calculated MTTF column
Spreadsheet: 185445d1349713434-delivery-schedule-in-excel-len
Sheet: Sheet1

CUST-ID | NAME | ADDRESS 1 | ADDRESS 2 | CITY | STATE | ZIP | Orders | Delivery Date | Delivered
JOEPIZ | [NAME] PIZZA | 123 MAIN ST. | SUITE 1 | NEW YORK | NY | 10001 | Cake | 2012-10-11 00:00:00 | Yes
MIKPIZ | MIKE'S PIZZA | 123 COVERED LANE | PO BOX 123 | NEW YORK | NY | 10002 | Shovel | 2012-10-09 00:00:00
[NAME] | [NAME]'S DELI | 424 HEATHER LANE |  | BRONX | NY | 10101 | Comb | 2012-10-10 00:00:00
TOMPIZ | TOMMY'S | 28-32 34TH STREET |  | BROOKLYN | NY | 10221
Spreadsheet: 727397d1617882361-sumif-not-correct-using-but-using-is-correct-explain-me-weird-sumif-version-2-
Sheet: A as Number

Customer Code | Qty |  | Sum of Qty with Customer Code other than:
501 | 6
500 | 2
502 | 3 |  | 0501
501 | 4
Using SUMPRODUCT | Using SUMIF
[NAME] | [NAME] |  | sum Qty
formula in A10 | formula in B10 |  | formula in D10
I am know correct answer for sumif |  |  |  | my question is why is sumif not Correct using sign <> like in B10
 |  |  |  | but if using "=" like in D10 is correct
 | formula in B16
Spreadsheet: 545357d1509430834-need-to-append-in-front-of-each-cell-but-it-shoudent-be-visible-problem-example
Sheet: Sheet2

ABCDEF
asdas
ewrwer
sdf
werwer
sdgsdgsd
ABCDEF
asdas
ewrwer
sdf
werwer
sdgsdgsd
ABCDEF
asdas
ewrwer
sdf
werwer
sdgsdgsd
ABCDEF
asdas
ewrwer
sdf
werwer
sdgsdgsd
ABCDEF
asdas