tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: edafd7e3-b230-4c6d-ba26-d95550470ffb
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42317364 | 2014-07-15 23:16:49 | ALLIES | 1 | 6 | 4 | 1605036 | Översten | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42317637 | 2014-07-15 23:29:42 | AXIS | 1 | 6 | 5 | 1605036 | Översten | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
42332448 | 2014-07-17 01:15:37 | AXIS | 1 | 4 | 0 | 1009110 | HO-SA-KAI | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
42332520 | 2014-07-17 01:28:52 | ALLIES | 0 | 0 | 4 | 1009110 | HO-SA-KAI | 6149 | western | 1944-08-07 | 1944-08-11 | Counter-attack on Mortain | Contre-attaque de Mortain
42332654 | 2014-07-17 01:54:35 | ALLIES | 0 | 4 | 7 | 1009110 | HO-SA-KAI | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42332867 | 2014-07-17 02:09:06 | AXIS | 0 | 2 | 7 | 1009110 | HO-SA-KAI | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42341757 | 2014-07-17 20:19:22 | ALLIES | 1 | 6 | 2 | 787691 | TMuscle | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
42341856 | 2014-07-17 20:37:31 | AXIS | 0 | 5 | 6 | 787691 | TMuscle | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
42352819 | 2014-07-18 17:45:13 | ALLIES | 1 | 6 | 2 | 1594696 | Hodor37 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42352932 | 2014-07-18 18:03:20 | AXIS | 1 | 6 | 3 | 1594696 | Hodor37 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42354204 | 2014-07-18 20:15:42 | ALLIES | 0 | 3 | 5 | 1600928 | davidahlbinprof1 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42354463 | 2014-07-18 20:43:16 | AXIS | 1 | 5 | 2 | 1600928 | davidahlbinprof1 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 26558f9e-fde5-4111-ad5b-c2394c4f0305
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
39356193 | 2014-01-05 21:30:39 | ALLIES | 0 | 4 | 6 | 1351059 | misterfunny | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
39356572 | 2014-01-05 21:44:09 | AXIS | 1 | 6 | 5 | 1351059 | misterfunny | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
39356892 | 2014-01-05 21:58:57 | AXIS | 1 | 7 | 4 | 1451547 | Gruumshie | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40833583 | 2014-04-04 05:06:09 | ALLIES | 1 | 5 | 2 | 508770 | StriderII | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40833782 | 2014-04-04 05:33:47 | AXIS | 0 | 3 | 5 | 508770 | StriderII | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
40834048 | 2014-04-04 06:07:36 | AXIS | 0 | 5 | 6 | 508770 | StriderII | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
40834262 | 2014-04-04 06:30:12 | ALLIES | 1 | 6 | 1 | 508770 | StriderII | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
Spreadsheet: 490670d1479995462-check-if-amount-is-different-for-same-product-example
Sheet: Sheet1

Fruit | Amount
Apple | 0.69
Apple | 0.69
Apple | 0.69
Orange | 0.85
[NAME] | 0.26
[NAME] | 0.26
[NAME] | 0.3
[NAME] | 0.26
Lime | 0.18
Lime | 0.18
Lime | 0.09
Grapes | 1.25
Spreadsheet: 473910d1470490901-ocean-tides-calculator-tide-test-1-
Sheet: Tide Calculation

A Day of Tides
Location: |  |  | Input Tide data
Latitude Longitude:
 |  | Date | Military Time | Tide (High or Low) | Tide level (ft)
 |  | 2016-08-05 00:00:00 | 05:44:00 | Low | 0.01
 |  | 2016-08-05 00:00:00 | 11:30:00 | High | 2.52
 |  | 2016-08-05 00:00:00 | 18:02:00 | Low | -0.03
 |  | 2016-08-05 00:00:00 | 23:53:00 | High | 2.55
 |  | Mean High Tide
 |  | Mean Low Tide
 |  | Mean Tide Level
Current Date and Time
High Tide Table |  |  |  | Low Tide Table
Spreadsheet: 61595d1262537005-sum-formatting-problem-example1
Sheet: 130054

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 130054
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOG NO:
PIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Return Date:
SIC: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dept Date:
F/A: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days: | 0
IRP: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RON's:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous  Log Closed:
[NAME] |  |  |  |  |  |  | CLA TIME |  |  |  | CURRENCY |  |  |  |  | FUEL |  |  |  | PER DIEM |  |  |  |  | ZULU
LEG | DATE | B/P/C | PF | FROM | TO |  | T.O. | FLIGHT | LDG |  | NIGHT | D/N | P/N/V | HOLD |  | OUT | IN | TOTAL |  | HOURS |  | RATE | $ |  | T.O. | LDG
1 | 2009-12-03 00:00:00 | C | SV | VNY | TEB | 15:32:00 | 09:09:00 | 04:30:00 |  |  | 00:00:00 | D | N | 0 |  | 26200 | 10700 |  |  |  |  | 2.25
2 | 2009-12-06 00:00:00 | C | MG |  | VNY |  | 13:55:00 | 05:48:00 |  |  | 00:00:00 | N | P | 0 |  | 23600 | 4250 |  |  |  |  | 2.25
3 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
4 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
5 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
6 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
7 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
8 |  |  |  |  | 0 |  | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
9 |  |  |  |  | 0 | 3 | 00:00:00 | 00:00:00 |  |  | 00:00:00 |  |  |  |  |  | 0 |  |  |  |  | 0
 | PST | 8:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Closed
 | DST | 7:00:00
 | Today |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add - Fwd from previous [NAME]. Log only |  |  |  |  |  | 0
 |  |  |  |  | HOURS |  |  | CYCLES |  |  |  |  |  |  |  |  |  |  |  | Per Diem Add |  | 0
 | ACTT Forwarded
 | Total this Log |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adjusted Total
 | Totals to Date
Spreadsheet: 142602d1329925479-search-2-columns-return-data-in-different-row-formula
Sheet: Sheet1

Hi - needing some help with a formula - I have several columns taken from sage data. I have in one column employees hours and another employees name, as you can see sometimes employees name appears more than once. what I am needing is in another row is employee name who was working on the job to appear and all their hours beside their name. Would be greatful for your help
A | B | C | D
hours | rate | cost | employee
13.5 | 8 | 108 | SMITH
0.5 | 6.85 | 3.43 | JONES
0.5 | 6.85 | 3.43 | JONES
1.5 | 6.75 | 10.13 | SMITH
1 | 6.75 | 6.75 | SMITH
17 |  | 131.74
employee | total hours
SMITH | 16
JONES | 1
Spreadsheet: 58823d1259083472-excel-2007-how-to-add-items-to-a-dropdown-list-dynamically-by-typing-in-the-dropdown-list-cell-tanf_-_requirement_gathering_template_-final-
Sheet: Budget

 |  | DATA Gathering Template
Program | Temporary Assistance - Family Assistance and Safety Net
Function Name | Eligibility Determination
Activity Name | Budget
Activity Description / Purpose | One of the steps in the eligibility process is a determination of financial eligibility. The worker uses data gathered at the eligibility interview to calculate financial eligibility
 |  |  | Activity Predecessor | Activity [NAME] | Activity Input | Activity Output | Activity Successors
Steps | Tasks A task is any action that is being performed to complete a step | What unit does this? (SU) | Who does this? (W) | Applications used / System Interfaces / Tools Is there an automated system supporting the activity? | What happens before this? (P) | What causes the activity to happen (T) | Additional Information that is needed (I) | Is anything produced? (O) | What happens next ? (S) | V | Comments |  |  |  | Questions | Workarounds | Constraints/ Issues | Opportunities | Policy Considerations | Best Practices | Follow-Up | Comments
Calculate budget offline
Input individual (income) and case-related data on a budget input screen.
Store budget
Write the pay line if eligible
Deny the benefit
Authorize budget
Pass case for review
Accounting | Case Closure
Add Program/Person | Case Management (Undercare)
AFIS | Caseload Management
Agency Conference | Client Services/Benefits Delivery
Application Registration | Eligibility Determination
Authorization | Fair-Hearings & Appeals
[NAME] | Intake
Budget | Referrals
Case Assignment | Screening
Case Closure | Verification
Case Review
[NAME]
CBIC
Change
Clearance
Data Entry
DV-D-A Screen
Emergency Benefits
Expedited
Hearings
Interview
Investigation
Managed Care
Mass Changes
Monitor Activities
Notice
[NAME]
Plan Review
Pre-Screening
Reactivation
Reception
Records Management
Recoupment-Supplemental
Re-Determination-Renewal-Recert
Referral
Sanctions
Service Plan
Verify
Vouchers
Withdraw Application
Other
Spreadsheet: 102000d1300066143-index-match-to-reformat-data-tracker
Sheet: Final Format

Date | Last Name | First Name | Quantity | Hours | AVG.
2011-03-01 00:00:00 | Olive | Annabel | 240 | 8 | 30
2011-03-01 00:00:00 | [NAME] | Asher | 195 | 5 | 39
2011-03-01 00:00:00 | [NAME] | Atticus | 266 | 8 | 33.25
2011-03-01 00:00:00 | Otis | August | 197 | 8 | 24.625
2011-03-01 00:00:00 | [NAME] | Butch | 275 | 7.5 | 36.66666666666666
2011-03-01 00:00:00 | Piper | Clementine | 241 | 8 | 30.125
2011-03-01 00:00:00 | Ray | Dashiell | 285 | 7.5 | 38
2011-03-01 00:00:00 | Roman | [NAME] | 257 | 7.75 | 33.16129032258065
2011-03-01 00:00:00 | Romy | [NAME] |  | 8
2011-03-01 00:00:00 | Roscoe | Dixie | 180 | 8 | 22.5
2011-03-01 00:00:00 | Ruby | Duke | 257 | 7.75 | 33.16129032258065
2011-03-01 00:00:00 | Rufus | [NAME] | 235 | 8 | 29.375
2011-03-01 00:00:00 | Sadie | Ella | 250 | 8 | 31.25
2011-03-01 00:00:00 | [NAME] | Josiah | 155 | 4 | 38.75
2011-03-01 00:00:00 | Stellan | [NAME] | 258 | 7.5 | 34.4
2011-03-01 00:00:00 | [NAME] | Silas | 195 | 7.5 | 26
2011-03-01 00:00:00 | Talullah | Stella | 264 | 7.5 | 35.2
2011-03-01 00:00:00 | [NAME] | Violet | 251 | 7.5 | 33.46666666666667
2011-03-02 00:00:00 | Olive | Annabel | 231 | 7 | 33
2011-03-02 00:00:00 | [NAME] | Asher | 151 | 3.75 | 40.26666666666667
2011-03-02 00:00:00 | [NAME] | Atticus | 231 | 7 | 33
2011-03-02 00:00:00 | Otis | August | 191 | 7 | 27.28571428571428
2011-03-02 00:00:00 | [NAME] | Butch | 221 | 6.5 | 34
2011-03-02 00:00:00 | Piper | Clementine | 222 | 7 | 31.71428571428572
2011-03-02 00:00:00 | Ray | Dashiell | 231 | 7 | 33
2011-03-02 00:00:00 | Roman | [NAME] | 225 | 6.5 | 34.61538461538461
2011-03-02 00:00:00 | Romy | [NAME] | 241 | 7 | 34.42857142857143
2011-03-02 00:00:00 | Roscoe | Dixie | 161 | 7 | 23
2011-03-02 00:00:00 | Ruby | Duke | 226 | 7 | 32.28571428571428
2011-03-02 00:00:00 | Rufus | [NAME] | 229 | 7 | 32.71428571428572
2011-03-02 00:00:00 | Sadie | Ella | 245 | 7 | 35
2011-03-02 00:00:00 | [NAME] | Josiah | 289 | 7 | 41.28571428571428
2011-03-02 00:00:00 | Stellan | [NAME] | 213 | 5.5 | 38.72727272727273
2011-03-02 00:00:00 | [NAME] | Silas | 189 | 5.5 | 34.36363636363637
2011-03-02 00:00:00 | Talullah | Stella | 200 | 5 | 40
2011-03-02 00:00:00 | [NAME] | Violet | 241 | 7.25 | 33.24137931034483
Spreadsheet: 119291d1314301201-excel-2007-how-do-i-total-cell-values-using-different-values-supplierreport
Sheet: Report

January |  |  |  |  |  | July
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
February |  |  |  |  |  | August
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
March |  |  |  |  |  | September
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
April |  |  |  |  |  | October
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
May |  |  |  |  |  | November
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
June |  |  |  |  |  | December
Supplier | Air | Road | Sea | Grand Total |  | Supplier | Air | Road | Sea | Grand Total
ABC |  |  |  |  |  | ABC
BCD |  |  |  |  |  | BCD
CDE |  |  |  |  |  | CDE
DEF |  |  |  |  |  | DEF
Grand Total |  |  |  |  |  | Grand Total
Spreadsheet: 0859c929-8208-4e2b-bb39-36ddf98b5e06
Sheet: Sheet1

Table 4 -- U.S. monthly average farm prices and marketings by class | 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
 |  |  | Long-grain |  |  |  |  |  |  |  |  | Medium/Short Grain
 |  | 2011/12 |  |  |  | 2010/11 |  |  |  | 2011/12 |  |  |  | 2010/11
Month | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt |  | $/cwt |  | 1,000 cwt
August | 12.4 |  | 9343 |  | 10.3 |  | 8570 |  | 19 |  | 2041 |  | 17.1 |  | 2121
September | 13.7 |  | 10310 |  | 9.98 |  | 12764 |  | 17.8 |  | 2197 |  | 16.9 |  | 2331
October | 14.1 |  | 8694 |  | 10.1 |  | 14295 |  | 15.9 |  | 2760 |  | 18.8 |  | 2836
November | 13.9 |  | 7196 |  | 10.6 |  | 12773 |  | 15.7 |  | 3732 |  | 18.9 |  | 4156
December | 13.8 |  | 9938 |  | 11.3 |  | 13085 |  | 15.2 |  | 4239 |  | 19.5 |  | 6052
January | 13.6 |  | 9482 |  | 11.8 |  | 15722 |  | 15.2 |  | 4940 |  | 19.6 |  | 6084
February | 13.2 |  | 9917 |  | 12 |  | 11726 |  | 15.3 |  | 3270 |  | 18.8 |  | 3121
March | 13.2 | 1/ |  |  | 11.6 |  | 12537 |  | 16 | 1/ |  |  | 18.5 |  | 3307
April |  |  |  |  | 11.2 |  | 9562 |  |  |  |  |  | 18.6 |  | 3165
May |  |  |  |  | 10.9 |  | 11211 |  |  |  |  |  | 19 |  | 3016
June |  |  |  |  | 11 |  | 9573 |  |  |  |  |  | 18.4 |  | 1744
July |  |  |  |  | 11.4 |  | 9866 |  |  |  |  |  | 19 |  | 2503
Average to date 2/ | 13.4875 |  |  |  |  |  |  |  | 16.2625
Season-average farm price | 13.3 | 3/ |  |  | 11 |  |  |  | 15.7 | 3/ |  |  | 18.8
Average marketings |  |  | 9268.57142857143 |  |  |  | 11807 |  |  |  | 3311.285714285714 |  |  |  | 3369.666666666667
Total volume marketed |  |  | 64880 |  |  |  | 141684 |  |  |  | 23179 |  |  |  | 40436
N/A = Not available.  1/  Mid-month only.  2/ Simple average. 3/ Forecast.
Source: Monthly cash price and marketings, Agricultural Prices, National Agricultural Statistics Service, USDA.
Last updated April 10, 2012.
Spreadsheet: 538737d1505811268-adding-row-content-from-sheet-to-sheet-example
Sheet: Ops

 |  |  |  |  | Operation Department
 |  |  |  |  | 2017-09-19 00:00:00
 | Session # | 8
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes
 | 1 | Testing of AV |  |  |  |  |  |  |  | Pending Approval
 | 2 | Creation of layout |  |  |  |  |  |  |  | In Progres
 | Session # | 9
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 10
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 11
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 12
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 13
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 14
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
 | Session # | 15
 | 1 | Operation Department |  |  |  |  |  | Date from | Date Due | Status | Notes | 0
 |  |  |  |  |  |  |  |  |  | Pending Approval
Spreadsheet: 841520d1693703009-update-the-values-in-a-column-based-on-matching-data-in-other-columns-intended-result
Sheet: Sheet1

TIME | DC
1030 | 9
1031 | 9
1032 | 9
1033 | 9
1034 | 9
1035 | 9
1036 | 9
1037 | 9
1038 | 9
1039 | 9
1040 | 9
Spreadsheet: 775150d1648841483-help-with-transpose-and-frequency-formula-excel-example
Sheet: Example

Filter by Rep email address | Cadence
 | Monthly | Weekly | Daily | Never / Rarely
Assist warehouse with lost/mis-directed shipments - Cadence | 6 | 2 | 1 | 2
Assist warehouse with product identifcation - Cadence | 6 | 5 | 2 | 3
Calling customers for pickup orders - Cadence | 6 | 2 | 2 | 0
Collections / Chasing Payments - Cadence | 1 | 5 | 5 | 2
Contacting Purchasing for missing order confirmation in JDE - Cadence | 4 | 3 | 5 | 2
Correcting JDE or warehouse generated errors (kits, ship confirm, ) - Cadence | 5 | 5 | 5 | 2
Costing from vendor - Cadence | 2 | 1 | 5 | 2
Credit card orders - Cadence | 1 | 2 | 5 | 2
Credits/RGA/Debits - Cadence | 4 | 2 | 5 | 2
Drop Ship Orders - Cadence | 6 | 2 | 5 | 2
Expediting- internal departments (warehouse, shop) - Cadence | 8 | 5 | 5 | 2
Expediting- with vendor - Cadence | 3 | 2 | 5 | 2
Export Docs - Cadence | 2 | 6 | 5 | 2
Freight Quotes & Freight Charges on Orders - Cadence | 5 | 6 | 5 | 2
Generate customer UPS pick-up & waybills - Cadence | 6 | 8 | 5 | 2
Incorrect JDE information - parts needing corrections/duplicates - Cadence | 7 | 8 | 5 | 2
New Vendor Set Up - Cadence | 8 | 2 | 5 | 2
Non divisional Calls from customers - Cadence | 5 | 1 | 5 | 2
Release M1/C1 Holds - Cadence | 5 | 0 | 5 | 2
Reseller Quote Follow Ups - Cadence | 3 | 6 | 5 | 2
Re-send Packing Slips - Cadence | 3 | 5 | 5 | 2
Send tracking information - Cadence | 2 | 3 | 5 | 2
Sending invoices to customers - Cadence |  | 8 | 5 | 2
Sorting out billing issues/advising correct amounts - Cadence | 5 | 7 | 5 | 2
Vendor Purchase order Corrections - Cadence | 6 | 1 | 5 | 2
Spreadsheet: 814320d1674278072-create-a-total-by-dropdown-pick-dropdown-example
Sheet: Sheet1

Date | Vendor | Paid |  |  | Vendor A
2023-01-01 00:00:00 | Vendor A | 10 |  |  | Vendor B
2023-01-02 00:00:00 | Vendor B | 30 |  |  | Vendor C
2023-01-02 00:00:00 | Vendor C | 15 |  |  | Vendor E
2023-01-05 00:00:00 | Vendor A | 20 |  |  | Vendor F
 |  |  |  |  | Vendor G
 |  |  |  |  | Vendor H
 |  |  |  |  | Vendor I
 |  |  |  |  | Vendor J
 |  |  |  |  | Vendor K
Spreadsheet: 227473d1365711784-30-day-pick-by-name-score-card
Sheet: Name Look-up

SOURCE | STAFF MEMBER'S AVERAGES |  |  |  |  |  |  |  | STAFF MEMBER'S COUNTS
Score Card | Staff ID | [NAME] | Call Coaching | Phone Consult | MCOT Quality | Phone Recording Review | [NAME] | [NAME] | Call Coaching | Phone Consult | MCOT Quality | Phone Recording Review | [NAME] | 1:1 Sup | Group Supv
 |  |  |  |  |  |  | Review |  |  |  |  |  | Review
Last Name
bibbins | 42695
30 days | N/A | 0 | 1.533333333333333 | 3.4 |  | 2.1 | 1.733333333333333 | 0 | 3 | 1 |  | 1 | 3 | 2 | 1
30 day AVG | N/A | 4.6 | 2.458333333333333 | 3.332987910219389 | 3.053333333333333 | 2.286363636363636 | 2.918939393939394 | 1 | 1.75 | 12.29166666666667 | 1.9 | 2.290909090909091 | 2.545454545454545 | 2.5 | 1
60 days | N/A | 0 | 1.533333333333333 | 3 |  | 2.1 | 1.733333333333333 | 0 | 3 | 4 |  | 1 | 3 | 3 | 1
60 day AVG | N/A | 3.289285714285714 | 2.188888888888889 | 3.355266366979113 | 3.118269230769231 | 2.50266106442577 | 2.985869565217391 | 12 | 2 | 20.04 | 3.092307692307692 | 2.541176470588236 | 3.565217391304348 | 2.8 | 1.782608695652174
90 days | N/A | 0 | 1.533333333333333 | 3 |  | 2.1 | 1.733333333333333 | 0 | 3 | 5 |  | 1 | 3 | 3 | 1
90 day AVG | N/A | 3.289285714285714 | 2.188888888888889 | 3.332315071484481 | 3.090952380952381 | 2.429131652661065 | 2.985869565217391 | 12 | 2 | 21.96 | 3.514285714285715 | 2.71764705882353 | 3.565217391304348 | 2.85 | 1.782608695652174
120 days | N/A | 0 | 1.533333333333333 | 3 |  | 2.1 | 1.733333333333333 | 0 | 3 | 5 |  | 1 | 3 | 3 | 1
120 day AVG | N/A | 3.289285714285714 | 2.188888888888889 | 3.326985909770074 | 3.119052083333334 | 2.422661064425771 | 2.985869565217391 | 12 | 2 | 23.88 | 3.3875 | 2.776470588235294 | 3.565217391304348 | 3 | 1.782608695652174
365 days | N/A | 0 | 1.533333333333333 | 2.742857142857143 | 2.4 | 2.132 | 2.365217391304347 | 0 | 3 | 14 | 2 | 35 | 23 | 9 | 8
365 days AVG | N/A | 3.289285714285714 | 1.891666666666667 | 3.207769844957435 | 2.936302339901478 | 2.286095271524499 | 2.854026876657574 | 12 | 2 | 48.44 | 7.76 | 12.8 | 18.25 | 7.52 | 4.652173913043478
Overall | N/A | 0 | 1.533333333333333 | 2.773333333333333 | 2.4 | 2.133846153846155 | 2.388461538461538 | 0 | 3 | 15 | 2 | 39 | 26 | 9 | 8
Overall AVG | N/A | 3.289285714285714 | 1.891666666666667 | 3.15041331395809 | 2.967049178857124 | 2.288497864226434 | 2.899897670039763 | 12 | 2 | 88.41666666666667 | 9.043478260869565 | 16.20833333333333 | 38.70833333333334 | 10.16 | 11.08333333333333
Spreadsheet: 122745d1317128597-date-count-by-month-with-multiple-criteria-multiple-date-ranges
Sheet: Sheet1

 |  |  |  | I need a formula that counts the dates by month based on the Status.  For example I need the Count of January dates with a Status of 50 and all the January Dates with a status of 60 and so forth.  Thanks
 | Date | Status
 | 2011-01-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 60
 | 2011-04-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 50
 | 2011-01-01 00:00:00 | 300
 | 2011-06-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 60
 | 2011-06-01 00:00:00 | 50
 | 2011-06-01 00:00:00 | 60
 | 2011-01-01 00:00:00 | 300
 | 2011-01-01 00:00:00 | 300
 | 2011-04-01 00:00:00 | 300
Spreadsheet: 888090d1738465181-sumproduct-formulae-issue-sample-sumproduct
Sheet: SUMPRODUCT-INDEX-MATCH

 |  |  |  |  |  |  |  |  |  | 2025-01-31 00:00:00 | [NAME] this month-end date to update the results
 |  |  |  | wants with formula | wants with formula |  | wants with formula | wants with formula | wants with formula
 |  | S.No. | Name | Opening | [NAME] | Total Balance | Cash | Batch | Payment | Net Balance
 |  | 1 | a
 |  |  | b
 |  |  | c
 |  |  | d
 |  |  | e
 |  |  | TOTAL
 |  |  |  | Expected Results for [NAME]:
 |  |  |  | 0 | 5000 | 5000 |  |  |  | 5000
 |  |  |  | 228920 | 15000 | 243920 | 5000 | 175000 |  | 63920
 |  |  |  | 219200 | 0 | 219200 | 25000 | 150000 |  | 44200
 |  |  |  | 3025 | 0 | 3025 |  |  |  | 3025
 |  |  |  | 3090 | 0 | 3090 | 2000 |  |  | 1090