tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 882472d1730862571-filter-vstack-multiple-tables-and-criteria-my-step-by-step-time-sheet-so-i-can-filter-_r2
Sheet: Sheet1

Student name: (first name, last name) | [NAME] |  | October24 | September24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tablenames
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-07-01 00:00:00
 | Trainer Name | Student name: (first name, last name) | What action have you taken? | Session date: | How was the training conducted? | Travel time costs (if any) | Travel mileage (if any) | What was training subject 1? (select from drop down list) | Training subject 1 - how much time () did you train on this today? (select from drop down list) | What was training subject 2? (select from drop down list) | Training subject 2 (if appropriate) - how much time (hours) did you train on this today? | What was training subject 3? (select from drop down list) | Training subject 3 (if appropriate) - how much time (hours) did you train on this today? | Ad-hoc fee - If you completed approved training or a service that is not on the list or is ad-hoc briefly summarise here. Include as much detail as is needed. | Rate | Count | Value | TORF Ref # |  |  | 2024-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-01 00:00:00
Spreadsheet: 34140d1231269540-formula-result-value-different-than-that-displayed-in-cell-template_nf_2009
Sheet: Summary

Volume History-
 | Total | Daily Average | Weekly Average | High | Low | Monday | Tuesday | Wednesday | Thursday | Friday
2008-12-01 00:00:00
2009-01-01 00:00:00
2009-02-01 00:00:00
2009-03-01 00:00:00
2009-04-05 00:00:00
2009-05-01 00:00:00
2009-06-07 00:00:00
2009-07-01 00:00:00
2009-08-01 00:00:00
2009-09-01 00:00:00
2009-10-01 00:00:00
2009-11-01 00:00:00
2009-12-01 00:00:00
Month
 | 2008-12-01 00:00:00 | 2008-12-02 00:00:00 | 2008-12-03 00:00:00 | 2008-12-04 00:00:00 | 2008-12-05 00:00:00 | 2008-12-08 00:00:00 | 2008-12-09 00:00:00 | 2008-12-10 00:00:00 | 2008-12-11 00:00:00 | 2008-12-12 00:00:00 | 2008-12-15 00:00:00 | 2008-12-16 00:00:00 | 2008-12-17 00:00:00 | 2008-12-18 00:00:00 | 2008-12-19 00:00:00 | 2008-12-22 00:00:00 | 2008-12-23 00:00:00 | 2008-12-24 00:00:00 | 2008-12-25 00:00:00 | 2008-12-26 00:00:00 | 2008-12-29 00:00:00 | 2008-12-30 00:00:00 | 2008-12-31 00:00:00
2008-12-01 00:00:00 | 93 | 92 | 65 | 112 | 86 | 90 | 91 | 73 | 91 | 77 | 103 | 93 | 93 | 102 | 83 | 105 | 127 | 76 | 113 | 81 | 113 | 101 | 68
 | 2009-01-01 00:00:00
2009-01-01 00:00:00 | Closed | 77 | 69 | 71 | 85 | 81 | 94 | 87 | 76 | 78 | 67 | 101 | 74 | 83 | Closed | 71 | 75 | 91 | 60 | 96 | 72 | 86
 | 2009-02-02 00:00:00
2009-02-01 00:00:00 | 70 | 85 | 76 | 86 | 81 | 76 | 39 | 60 | 90 | 92 | 73 | 82 | 85 | 95 | 38 | 44 | 80 | 85 | 88 | 86
 | 2009-03-02 00:00:00
2009-03-01 00:00:00 | 86 | 81 | 86 | 78 | 87 | 88 | 78 | 122 | 94 | 71 | 73 | 80 | 77 | 70 | 63 | 50 | 47 | 64 | 48 | 69 | 73 | 80
 | 2009-04-01 00:00:00
2009-04-01 00:00:00 | 71 | 81 | 101 | 79 | 101 | 81 | 90 | 67 | 76 | 68 | 92 | 100 | 80 | 60 | 85 | 95 | 115 | 73 | 78 | 95 | 76 | 93
 | 2009-05-01 00:00:00
2009-05-01 00:00:00 | 70 | 53 | 91 | 100 | 115 | 104 | 73 | 81 | 69 | 89 | 80 | 64 | 82 | 73 | 81 | 64 | 68 | Closed | 75 | 99 | 84
 | 2009-06-01 00:00:00
2009-06-01 00:00:00 | 72 | 62 | 78 | 86 | 60 | 75 | 57 | 95 | 31 | 67 | 67 | 71 | 87 | 90 | 96 | 83 | 63 | 66 | 58 | 54 | 81 | Closed
 | 2009-07-01 00:00:00
2009-07-01 00:00:00 | 81 | 73 | 85 | Closed | 79 | 80 | 107 | 79 | 63 | 77 | 79 | 78 | 74 | 68 | 88 | 75 | 87 | 60 | 70 | 76 | 78 | 86 | 60
 | 2009-08-03 00:00:00
2009-08-01 00:00:00 | 76 | 81 | 85 | 82 | 73 | 65 | 82 | 73 | 89 | 68 | 83 | 96 | 67 | 91 | 86 | 83 | 80 | 82 | 107 | 88 | 94
 | 2009-09-01 00:00:00
2009-09-01 00:00:00 | Closed | 80 | 98 | 78 | 70 | 96 | 90 | 95 | 95 | 90 | 89 | 103 | 103 | 83 | 98 | 100 | 89 | 112 | 116 | 100 | 89 | 97
 | 2009-10-01 00:00:00
2009-10-01 00:00:00 | 93 | 92 | 65 | 112 | 86 | 90 | 91 | 73 | 91 | 77 | 103 | 93 | 93 | 102 | 83 | 105 | 127 | 76 | 113 | 81 | 113 | 101
 | 2009-11-02 00:00:00
2009-11-01 00:00:00 | 93 | 92 | 65 | 112 | 86 | 90 | 91 | 73 | 91 | 77 | 103 | 93 | 93 | 102 | 83 | 105 | 127 | 76 | 113 | 81 | 113
 | 2009-12-01 00:00:00
2009-12-01 00:00:00 | 93 | 92 | 65 | 112 | 86 | 90 | 91 | 73 | 91 | 77 | 103 | 93 | 93 | 102 | 83 | 105 | 127 | 76 | 113 | 81 | 113 | 101 | 68
Spreadsheet: mary_fischer__25613__32H
Sheet: E2.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER CURRENT ASSETS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-2
 |  | 12-31-00 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Dues advances (Remapped to 20025000) |  | 1008 |  | -1008
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total Current Assets | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 195
Asset/Expense Accts:  DR/(CR)
Spreadsheet: 117122d1312465203-selecting-data-from-one-table-to-another-between-dates-tracker
Sheet: Sheet4

 |  |  | FROM | TO | EMPLOYEE | START DATE | END DATE | OTHER MILEAGE | [NAME] | WHAT WE ARE CHARGED
 |  |  | JACKSONVILLE,FL | BOCA RATON, FL | DAVE | 2010-12-30 00:00:00 | 2011-01-03 00:00:00 | 450 | 444 | 900
 |  |  | JACKSONVILLE,FL | CONYERS,GA | BILL | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 632 | 656 | 400
 |  |  | JACKSONVILLE,FL | NEW ORLEANS,LA | [NAME] | 2011-01-03 00:00:00 | 2011-01-04 00:00:00 | 300 | 340 | 300
 |  |  | JACKSONVILLE,FL | [NAME],TN | DAVE | 2011-01-04 00:00:00 | 2011-01-06 00:00:00 | 800 | 773 | 650
 |  |  | JACKSONVILLE,FL | MACON,GA | BILL | 2011-01-15 00:00:00 | 2011-01-16 00:00:00 | 235 | 271 | 325
 |  |  | JACKSONVILLE,FL | NORCROSS,GA | BILL | 2011-02-01 00:00:00 | 2011-02-02 00:00:00 | 568 | 608 | 425
Spreadsheet: 845443d1696958429-calculating-total-sum-of-item-within-a-date-range-hotel
Sheet: Prices

 |  | Room No.
 | Date | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
Monday | 2024-01-01 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Tuesday | 2024-01-02 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Wednesday | 2024-01-03 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Thursday | 2024-01-04 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 88
Friday | 2024-01-05 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Saturday | 2024-01-06 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Sunday | 2024-01-07 00:00:00 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 60 | 60 | 65
Spreadsheet: 758342d1638824813-formula-to-add-closed-when-all-actions-are-competed-audit-tracker-2021
Sheet: Sheet1

Audit | Audit Number | Lead Auditor | Due | Auditee | Date Completed | NCR's raised | Department | Closed |  |  | Audit Number | NCR Ref | Action Owner | Department | Action target Date | Completed | Repeat NCR | Closed | On time
HR | SHA-MEG-1234 | [NAME] | 2022-01-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-1 | [NAME] | Mod 1 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | Yes
QUALITY | SHA-MEG-1235 | [NAME] | 2021-12-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-2 | [NAME] | Mod 1 | 2021-04-01 00:00:00 | 2021-06-01 00:00:00 | No
ENGINEERING | SHA-MEG-1236 | [NAME] | 2021-12-01 00:00:00 | [NAME] |  |  |  |  |  |  | SHA-MEG-1237 | NCR-3 | [NAME] | [NAME] | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | Yes
MANUFACTURING | SHA-MEG-1237 | shrek | 2021-03-01 00:00:00 | [NAME] | 2021-03-01 00:00:00 | 3 | MANU |  |  |  | SHA-MEG-1239 | NCR-4 | [NAME] | [NAME] | 2021-09-01 00:00:00 | 2021-09-02 00:00:00 | No
MANAGEMENT | SHA-MEG-1238 | [NAME] | 2021-04-01 00:00:00 | [NAME] | 2021-05-01 00:00:00 | 0 | SLC |  |  |  | SHA-MEG-1239 | NCR-5 | [NAME] | Mod 1 | 2021-09-01 00:00:00 | 2021-09-01 00:00:00 | Yes
BUSSINESS REVIEW | SHA-MEG-1239 | [NAME] | 2021-08-01 00:00:00 | [NAME] | 2021-08-01 00:00:00 | 2 | SLC |  |  |  | SHA-MEG-1240 | NCR-6 | [NAME] | Mod 1 | 2022-01-01 00:00:00 |  | No
HS | SHA-MEG-1240 | [NAME] | 2021-11-01 00:00:00 | Doe | 2021-12-01 00:00:00 | 1 | HSE
INSPECTION | SHA-MEG-1241 | [NAME] | 2022-03-01 00:00:00 | Will
RELEASE | SHA-MEG-1242 | [NAME] | 2022-04-02 00:00:00 | Huge
RCCA | SHA-MEG-1243 | [NAME] | 2022-05-03 00:00:00 | [NAME]
Spreadsheet: 05f80a87-1d8f-4476-bc2c-2abf5e8ef7f6
Sheet: Mt. Carmel&Shamokin

 |  |  | 2014 Mt. Carmel F.E. & Shamokin Mobile Pantry Delivery Calendar
 | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | 31
 | April |  |  |  |  |  |  |  | May |  |  |  |  |  |  |  | June
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  | 1 | 2 | 3 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 |  | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 27 | 28 | 29 | 30 |  |  |  |  | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | 29 | 30
 | July |  |  |  |  |  |  |  | August |  |  |  |  |  |  |  | September
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  | 1 | 2 | 3 | 4 | 5 |  |  |  |  |  |  | 1 | 2 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 6 | 7 | 8 | 9 | 10 | 11 | 12 |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 13 | 14 | 15 | 16 | 17 | 18 | 19 |  | 10 | 11 | 12 | 13 | 14 | 15 | 16 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 20 | 21 | 22 | 23 | 24 | 25 | 26 |  | 17 | 18 | 19 | 20 | 21 | 22 | 23 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 27 | 28 | 29 | 30 | 31 |  |  |  | 24 | 25 | 26 | 27 | 28 | 29 | 30 |  | 28 | 29 | 30
 |  |  |  |  |  |  |  |  | 31
 | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  |  |  | 1 | 2 | 3 | 4 |  |  |  |  |  |  |  | 1 |  |  | 1 | 2 | 3 | 4 | 5 | 6
 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |  | 9 | 10 | 11 | 12 | 13 | 14 | 15 |  | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |  | 16 | 17 | 18 | 19 | 20 | 21 | 22 |  | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 26 | 27 | 28 | 29 | 30 | 31 |  |  | 23 | 24 | 25 | 26 | 27 | 28 | 29 |  | 28 | 29 | 30 | 31
 |  |  |  |  |  |  |  |  | 30
 |  | 1ST & 3RD Tuesdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  | Holidays, Food Bank is Closed |  |  |  |  |  |  |  | Delivery dates to your area
Spreadsheet: 88647d1288441213-retrieve-row-data-useindexmatch
Sheet: Sheet1

 | serial no. | [NAME] | data2 | data3 | data4
 | 1 | asd | asd | asd | asdf
 | 2 | sef | asdf | dfgdgf | xxxx
 | 3 | dasdf | dsfd | sadfs | sdfsdf
 | 4 | dsfds | dsfsad | sdfsa | ssf
 | 5 | gfdg | dgfsd | [NAME] | were
Spreadsheet: 865870d1712841673-help-with-line-graph-example-2-1-
Sheet: Sheet1

 |  | Department | 2024-01-23 00:00:00 | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00
 |  | A-End 1st | 3 | 5 | 5 | 4 | 4 | 6 | 5 | 3 | 5 | 7 |  | Select: | B-End 2nd
 |  | A-End 2nd | 4 | 4 | 5 | 6 | 5 | 5 | 8 | 2 | 5 | 0 |  |  |  |  |  | 2024-02-23 00:00:00 | 2024-03-23 00:00:00 | 2024-04-23 00:00:00 | 2024-05-23 00:00:00 | 2024-06-23 00:00:00 | 2024-07-23 00:00:00 | 2024-08-23 00:00:00 | 2024-09-23 00:00:00 | 2024-10-23 00:00:00
 |  | A-End 3rd | 5 | 3 | 5 | 7 | 6 | 3 | 6 | 2 | 6 | 8
 |  | B-End 1st | 6 | 2 | 6 | 8 | 7 | 2 | 8 | 7 | 2 | 7
 |  | B-End 2nd | 7 | 1 | 4 | 9 | 8 | 1 | 7 | 1 | 4 | 9
 |  | B-End 3rd | 8 | 2 | 5 | 0 | 9 | 4 | 4 | 4 | 4 | 4
 |  | Tubing 1st | 9 | 3 | 3 | 1 | 9 | 8 | 2 | 5 | 0 | 4
 |  | Tubing 2nd | 0 | 4 | 4 | 2 | 8 | 4 | 7 | 1 | 4 | 9
 |  | [NAME] | 6 | 7 | 10 | 3 | 7 | 4 | 5 | 3 | 5 | 7
Spreadsheet: darrell_schoolcraft__7735__imball0203
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13 |  | -666
2 | 12 |  | -3300
3 |  |  | -3941
4 |  |  | -3861
5 |  |  | -3809
6 |  |  | -3887
7 |  |  | -3882
8 |  |  | -1118
9
10 | 1
11 | 678
12
13 | 1010
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 178356.43
2002-03-19 00:00:00
CBS Volume
 |  |  | -355979
Spreadsheet: 113296d1309259356-summing-columns-meeting-two-conditions-sample-sheet-1
Sheet: Sheet1

 |  |  | Item | Qnty |  | Item | Qnty |  |  | Month Total of each group
 |  |  |  | Store 1 | Store 2 |  | Store 1 | Store 2 |  | Regular | Frequent | Isolated |  | Item | Group |  | Regular | Frequent | Isolated
 |  | KL | A | 25 | 13 |  |  |  |  |  |  |  |  | A | Regular |  |  |  | C
 |  |  | C | 40 | 27 | G |  | 20 |  |  |  |  |  | B | Regular |  | A
 |  |  |  |  |  | D | 45 |  |  |  |  |  |  | H | Regular |  |  | D | E
 | Jan | XYZ | B | 17 |  |  |  |  |  | 55 | 65 | 67 |  | J | Regular |  | B | F
 |  | KL | D | 35 |  | B | 50 | 30 |  |  |  |  |  | D | Frequent |  |  | G
 |  |  | A | 15 | 19 | F | 28 |  |  |  |  |  |  | F | Frequent |  | H
 |  |  |  |  |  |  |  |  |  |  |  |  |  | G | Frequent |  | J | K
 |  |  | E |  | 38 | G | 21 | 36 |  |  |  |  |  | K | Frequent
 | Feb | XYZ |  |  |  |  |  |  |  | 114 | 120 | 38 |  | C | Isolated
 |  | KL |  |  |  |  |  |  |  |  |  |  |  | E | Isolated
 |  |  |  |  |  |  |  |  |  |  |  |  |  | The figures in green would be the result of the required formula. They are the total quantity of the items of each group for each month.
 | Mar | XYZ
 |  | KL
 | Apr | XYZ
 |  | KL
 | May | XYZ
 |  | KL
 | June | XYZ |  |  |  |  |  |  |  |  |  |  |  | Columns B,C,R,S & T are semilar to those in the actual spreadsheet, and they are shown here just in case they have to be referanced in building the required formula
Spreadsheet: 830901d1685225856-most-frequent-value-based-on-criteria-most-frequent-value-based-on-criteria
Sheet: Sheet1

Client Number | Client Name | [NAME] | Amount | Sales Month
 | Client 1 | [NAME] | 12 | February |  | If [NAME] is empty, then exclude from calculation.
 | Client 2 | [NAME] | 45 | February |  | Also, if [NAME] is empty or includes the text "Unknown", then exclude from calculation.
 | Client 3 | Mark | 27 | May
 | Client 4 | Suzanne | 87 | April |  |  | [NAME] | Which Sales Person appears most frequently overall?
 | Client 5 | [NAME] | 19 | March
 | Client 6 | Suzanne | 52 | March |  |  | [NAME] | Which Sales Person appears most frequently in May?
 | Client 7 |  | 24 | January
 | Client 8 | Suzanne | 67 | April
 | Client 9 | Alfred | 42 | May |  | Expected results: |  | Suzanne overall
 | Client 10 | Mark | 52 | May |  |  |  | Mark in May
 | Client 11 | Unknown YEL | 57 | May
 | Client 12 |  | 93 | January
 | Client 13 | Mark | 12 | May
 | Client 14 | [NAME] | 42 | February
 | Client 15 | Becky | 36 | May
 | Client 16 | Becky | 91 | March
 | Client 17 | Suzanne | 33 | April
 | Client 18 | Mark | 18 | May
 | Client 19 | Suzanne | 36 | March
 | Client 20 | [NAME] | 43 | February
 |  | Unknown PTT
 |  | RES Unknown
 |  | PLF Unknown
 |  | Unknown GRF
Spreadsheet: darrell_schoolcraft__7622__imball0201
Sheet: EPFS

 | El Paso/TW Eddy Rec |  |  | 27677
 | 78093
Day | Measured | Scheduled
1 | 30077 | 30013
2 | 30198 | 30013
3 | 30012 | 30013
4 | 28849 | 30013
5 | 29803 | 32012
6 | 29404 | 32012
7 | 29513 | 32012
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 85004
2002-01-07 00:00:00
CBS Volume
 |  |  | 54582
Spreadsheet: 58224d1258506190-calculate-user-training-results-advice-campus-reporting-template
Sheet: NSW

Salary No | Planner | Practice Manager | State | Attempt 1 |  |  |  |  |  |  | Attempt 2 |  |  |  |  |  |  | Attempt 3
 |  |  |  | AML Client Identification & Verification |  | Financial Planning FSG |  | Client Profile Book |  | Status | AML Client Identification & Verification |  | Financial Planning FSG |  | Client Profile Book |  | Status | AML Client Identification & Verification |  | Financial Planning FSG |  | Client Profile Book |  | Status | Consequnce Management
 |  |  |  | [NAME] | Result | [NAME] | Result | [NAME] | Result |  | [NAME] | Result | [NAME] | Result | [NAME] | Result |  | [NAME] | Result | [NAME] | Result | [NAME] | Result
M005611 | AKAMO  Alfred | [NAME] | NSW |  | Fail |  | Fail |  | Fail | Assesment Fail |  | Fail |  | Fail |  | Fail | Assesment Fail |  | Fail |  | Fail |  | Fail | Assesment Fail
 |  |  |  |  | Fail |  | Fail |  | Fail | Assesment Fail |  | Fail |  | Fail |  | Fail | Assesment Fail |  | Fail |  | Fail |  | Fail | Assesment Fail
Spreadsheet: 542074d1507706459-return-total-amount-values-based-on-multiple-criteria-reporting
Sheet: MASTERFILE

 |  | 2017-01-02 00:00:00
 | Cash Inflows
 | Pre Construction
 | Construction
 | Cash Ouflows
 | NET CASH FLOW
Spreadsheet: 735389d1622940127-array-frequency-in-excel-ctrl-shift-enter-not-working-ece102_week3_activity1_data
Sheet: Example3

Student | Test score (points) |  |  | Statistics |  |  | Frequency
1 | 80
2 | 90 |  |  | Mean |  |  | Score | Condition | Frequency
3 | 75 |  |  | Standard deviation
4 | 80 |  |  | Min |  |  | 50 | value<50
5 | 84 |  |  | [NAME] |  |  | 60 | 50 ≤value< 60
6 | 55 |  |  | median |  |  | 70 | 60 ≤ value < 70
7 | 64 |  |  | number |  |  | 80 | 70 ≤ value < 80
8 | 48 |  |  |  |  |  | 90 | 80 ≤ value< 90
9 | 42 |  |  |  |  |  |  | 90 ≤ value
10 | 100 |  |  |  |  |  |  | Number
11 | 81
12 | 82
13 | 82
14 | 91
15 | 61
16 | 45
17 | 66
18 | 78
19 | 75
20 | 85
21 | 89
22 | 35
23 | 99
24 | 90
25 | 67
26 | 80
27 | 73
28 | 97
29 | 49
30 | 76
31 | 87
32 | 84
33 | 86
34 | 56
35 | 100
36 | 72
37 | 79
38 | 83
39 | 62
40 | 78
41 | 39
42 | 99
Spreadsheet: john_griffith__15991__Forwards Detail_AIG 
Sheet: positions

Sum of Quantity | Pub Code
Period | IF-TRANSCO/Z6 | NGI/CHI. GATE | NX1 | NX3 | NXB2 | Grand Total
2001-12-01 00:00:00 | 0 | 0 | 732500 |  | -855623.4552 | -123123.4552
2002-01-01 00:00:00 | 0 |  | 3776000 |  | -3301446.3684 | 474553.6316
2002-02-01 00:00:00 | 0 |  | 2968000 | -58323.1393 | -2825673.845899999 | 84003.01480000094
2002-03-01 00:00:00 | 0 |  | 1576000 | -58800.1307 | -1580928.5807 | -63728.71140000015
2002-04-01 00:00:00 |  |  | 2575000 | -162452.0128 | -2635335.6361 | -222787.6489000004
2002-05-01 00:00:00 |  |  | 1593500 |  | -1600427.652600001 | -6927.652600000612
2002-06-01 00:00:00 |  |  | 1575000 |  | -1539544.6133 | 35455.38670000015
2002-07-01 00:00:00 |  |  | 1593500 |  | -1475258.3537 | 118241.6462999997
2002-08-01 00:00:00 |  |  | 1593500 | -287740.8073 | -1432694.3546 | -126935.1618999997
2002-09-01 00:00:00 |  |  | 1575000 |  | -1418479.4916 | 156520.5084000002
2002-10-01 00:00:00 |  |  | 1593500 |  | -1398992.3904 | 194507.6096000001
2002-11-01 00:00:00 |  |  | 650000 | -324891.166 | -1102565.7032 | -777456.8692000001
2002-12-01 00:00:00 |  |  | 671000 |  | -541949.9909000002 | 129050.0090999998
2003-01-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-02-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-03-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-04-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-05-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-06-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-07-01 00:00:00 |  |  | 120000 |  |  | 120000
2003-08-01 00:00:00 |  |  | 120000 |  |  | 120000
Grand Total | 0 | 0 | 23432500 | -892207.2560999999 | -21708920.4366 | 831372.3072999999
Spreadsheet: 787988d1658211908-excel-counting-and-removing-duplicates-count-test
Sheet: Results

 | Results |  | Total
 | Unit | Count |  |  | Total count excluding duplicate
 |  | 2
 | 01-02 | 1
 | 01-03 | 0
 | 01-05 | 1
 | 02-01 | 0
 | 02-02 | 0
 | 02-03 | 2
 | 02-05 | 0
 | 03-01 | 1
 | 03-02 | 5
 | 03-03 | 0
 | 03-05 | 0
 | 04-01 | 1
 | 04-02 | 0
 | 04-03 | 2
 | 04-05 | 1
 | 05-01 | 3
 | 05-02 | 1
 | 05-03 | 0
 | 05-04 | 0
 | 05-05 | 0
 | 05-06 | 1
 | 01-08 | 3
 | 01-09 | 0
 | 01-10 | 0
 | 01-11 | 2
 | 02-08 | 2
 | 02-09 | 2
 | 02-10 | 0
 | 02-11 | 0
 | 03-08 | 3
 | 03-09 | 0
 | 03-10 | 0
 | 03-11 | 0
 | 04-08 | 0
 | 04-09 | 2
 | 04-10 | 0
 | 04-11 | 0
 | 05-07 | 2
 | 05-08 | 0
 | 05-09 | 0
 | 05-10 | 0
 | 05-11 | 4
 | 05-12 | 0
 | 01-13 | 5
 | 01-15 | 0
 | 01-16 | 0
 | 01-18 | 0
 | 02-13 | 2
 | 02-15 | 4
 | 02-16 | 0
 | 02-18 | 0
 | 03-13 | 1
 | 03-15 | 2
 | 03-16 | 2
 | 03-18 | 0
 | 04-13 | 3
 | 04-15 | 2
 | 04-16 | 0
 | 04-18 | 1
 | 05-13 | 0
 | 05-14 | 0
 | 05-15 | 2
 | 05-16 | 0
 | 05-17 | 0
 | 05-18 | 2
 | 01-20 | 0
 | 01-21 | 2
 | 01-22 | 2
 | 01-23 | 4
 | 02-20 | 2
 | 02-21 | 1
 | 02-22 | 1
 | 02-23 | 0
 | 03-20 | 0
 | 03-21 | 0
 | 03-22 | 0
 | 03-23 | 0
 | 04-20 | 0
 | 04-21 | 0
 | 04-22 | 0
 | 04-23 | 2
 | 05-19 | 3
 | 05-20 | 1
 | 05-21 | 0
 | 05-22 | 1
 | 05-23 | 0
 | 05-24 | 0
 | 01-26 | 3
 | 01-28 | 3
 | 01-30 | 0
 | 02-26 | 0
 | 02-28 | 3
 | 02-30 | 1
 | 03-26 | 0
 | 03-28 | 0
 | 03-30 | 0
 | 04-26 | 0
 | 04-28 | 1
 | 04-30 | 0
 | 05-25 | 0
 | 05-26 | 0
 | 05-27 | 2
 | 05-28 | 1
 | 05-29 | 4
 | 05-30 | 0
 | 01-31 | 0
 | 01-33 | 6
 | 01-35 | 1
 | 02-31 | 0
 | 02-33 | 5
 | 02-35 | 1
 | 03-31 | 0
 | 03-33 | 0
 | 03-35 | 2
 | 04-31 | 1
 | 04-33 | 0
 | 04-35 | 0
 | 05-31 | 0
 | 05-32 | 0
 | 05-33 | 0
 | 05-34 | 3
 | 05-35 | 2
 | 05-36 | 0
 | 01-37 | 0
 | 01-38 | 0
 | 01-39 | 4
 | 01-42 | 2
 | 02-37 | 2
 | 02-38 | 0
 | 02-39 | 0
 | 02-42 | 0
 | 03-37 | 0
 | 03-38 | 0
 | 03-39 | 0
 | 03-42 | 1
 | 04-37 | 2
 | 04-38 | 5
 | 04-39 | 3
 | 04-42 | 0
 | 05-37 | 1
 | 05-38 | 0
 | 05-39 | 0
 | 05-40 | 0
 | 05-41 | 1
 | 05-42 | 0
 | 01-43 | 2
 | 01-45 | 4
 | 01-46 | 5
 | 01-48 | 3
 | 02-43 | 1
 | 02-45 | 0
 | 02-46 | 2
 | 02-48 | 0
 | 03-43 | 0
 | 03-45 | 1
 | 03-46 | 0
 | 03-48 | 0
 | 04-43 | 0
 | 04-45 | 0
 | 04-46 | 2
 | 04-48 | 1
 | 05-43 | 1
 | 05-44 | 0
 | 05-45 | 3
 | 05-46 | 2
 | 05-47 | 2
 | 05-48 | 0
 | 01-50 | 2
 | 01-52 | 0
 | 01-54 | 0
 | 02-50 | 3
 | 02-52 | 2
 | 02-54 | 0
 | 03-50 | 0
 | 03-52 | 0
 | 03-54 | 0
 | 04-50 | 0
 | 04-52 | 1
 | 04-54 | 0
 | 05-49 | 0
 | 05-50 | 0
 | 05-51 | 0
 | 05-52 | 2
 | 05-53 | 0
 | 05-54 | 0
 | 0 | 0
Spreadsheet: 177601d1346355656-how-to-populate-workbook-pages-from-microsoft-query-copy-of-total-misses-for-period-6
Sheet: 9-027

 |  |  |  |  |  |  |  | 9-027
 |  |  |  |  |  |  |  | TOTAL MISSES FOR THIS PAY PERIOD
CHPUB | CHACT# | CHDIST | CHRTE | CHTIME | CHTTYP | CHTRCD | UNNBR | PREDIR | STREET | SUFFIX | PSTDIR | SUNTYP | SUNNBR | POZIP5 | CHSTAT | CHSMM | CHSDD | CHSYY