tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683290d1592596740-time-card-calculation-time_card2c-revised
Sheet: Regular Employee 

Employee: |  |  |  |  |  |  |  |  |  |  | Year | 2020 |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONS |  | OVERTIME OPTIONS
Employee Number: |  |  |  |  |  |  |  |  |  |  | Month |  |  |  |  |  |  | Su | M | [NAME] | W | Th | F | Sa | YES | DAILY | YES
Cost Center: |  |  |  | DEPT. # |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO | AFTER | 8 | HRS
SUPERVISOR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BREAK TIME | WEEKLY | YES
WEEK STARTING: | 2020-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | AFTER | 40 | HRS
WEEK ENDING: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
Day of Week | Time In | Time In 2 | [NAME] (minutes) | Time Out | Time Out 2 | Total Hours hide | Total Hours | Regular Hours hide | Regular Hours | Overtime | Overtime |  |  |  |  |  |  |  |  |  |  |  |  |  | 45
 |  | hidden |  |  | hidden |  |  |  |  | Hours hide | Hours |  |  |  |  |  |  |  |  |  |  |  |  |  | 60
 | 0714 |  | 30 | 1530
 | 0729 |  | 30 | 1530
 | 0700 |  | 30 | 1538 |  |  |  |  |  |  |  |  | Rules
 | 0655 |  | 30 | 1530 |  |  |  |  |  |  |  |  | 1. Worker is given a 15 min. increment leeway, see examples on date 6/1 & 6/2 which is right.
 | 0659 |  | 30 | 1530 |  |  |  |  |  |  |  |  | 2. If a worker clocks out <8 minutes later a 15 minute overtime is not counted but if it hits 8 mins then a 15 min overtime is counted.
 |  |  |  |  |  |  |  |  |  |  |  |  | The correct examples are on dates 6/3,(your formula) and also on 6/8 (w/c  has a different formula).
 |  |  |  |  |  |  |  |  |  |  |  |  | 3. If a worker clocks in 8 mins early a 15 minute overtime is applied, if less than 8 it defaults to 0 mins. See example on date 6/9.
 |  |  |  | Total  Hrs. |  |  |  |  |  |  |  |  | The correct example is on date 6/9 w/c has a different formula on G19
 | 0700 |  | 30 | 1538 |  |  |  |  |  |  |  |  | Discrepancies:
 | 0652 |  | 30 | 1530 |  |  |  |  |  |  |  |  | 1. See date 6/4, Worker clocks in 5 min early but it's not suppose to get a 15 min. overtime.
 |  |  |  |  |  |  |  |  |  |  |  |  | 2. See date 6/5, worker clocks in 1 min early but it should not get a 15 min. overtime.
 |  |  |  | Total  Hrs.
TOTAL HOURS WORKED: |  |  |  | Total  Hrs.
Spreadsheet: 776173d1649547926-formula-to-rank-supplier-scores-with-duplicate-values-rank-using-countif-and-column
Sheet: Sheet1

 | Data Table |  |  |  |  |  |  |  |  |  |  |  | Desired Output:
 |  | Supplier 1 | Supplier 2 | Supplier 3 | Supplier 4 | Supplier 5 | Supplier 6 | Supplier 7 | Supplier 8 | Supplier 9 | Supplier 10 |  | Supplier | Score
 | Score 1 | 60 | 71 | 7 | 73 | 50 | 23 | 92 | 27 | 3 | 48 |  | Supplier 3 | 308
 | Score 2 | 88 | 15 | 78 | 58 | 7 | 55 | 32 | 48 | 80 | 20 |  | Supplier 1 | 281
 | Score 3 | 64 | 6 | 71 | 43 | 82 | 33 | 68 | 17 | 65 | 70 |  | Supplier 4 | 281
 | Score 4 | 68 | 78 | 57 | 57 | 72 | 19 | 7 | 60 | 31 | 62 |  | Supplier 7 | 281
 | Score 5 | 1 | 84 | 95 | 50 | 25 | 14 | 82 | 23 | 34 | 51 |  | Supplier 2 | 254
 | Total |  |  |  |  |  |  |  |  |  |  |  | Supplier 10 | 251
 | Rank |  |  |  |  |  |  |  |  |  |  |  | Supplier 5 | 236
 |  |  |  |  |  |  |  |  |  |  |  |  | Supplier 9 | 213
 |  |  |  |  |  |  |  |  |  |  |  |  | Supplier 8 | 175
 |  |  |  |  |  |  |  |  |  |  |  |  | Supplier 6 | 144
Spreadsheet: e5160049-9599-4d17-adfe-6b63b49a5c16
Sheet: MF level 4

Molecular function GO term | Number of proteins
cation binding | 6151
purine nucleotide binding | 3643
ribonucleotide binding | 3634
DNA binding | 2892
transferase activity, transferring phosphorus-containing groups | 2463
receptor activity | 2063
enzyme binding | 2011
hydrolase activity, acting on acid anhydrides | 1747
receptor binding | 1675
identical protein binding | 1617
protein dimerization activity | 1485
hydrolase activity, acting on ester bonds | 1441
substrate-specific transmembrane transporter activity | 1422
cytoskeletal protein binding | 1385
RNA binding | 1308
GTPase regulator activity | 1205
protein domain specific binding | 1081
peptidase activity | 1000
passive transmembrane transporter activity | 735
protein complex binding | 707
transcription factor binding | 691
ligase activity, forming carbon-nitrogen bonds | 668
active transmembrane transporter activity | 648
GTPase activator activity | 611
transcription coactivator activity | 493
phospholipid binding | 478
protein C-terminus binding | 439
transferase activity, transferring glycosyl groups | 422
transferase activity, transferring one-carbon groups | 411
[NAME] | 405
transferase activity, transferring acyl groups | 388
coenzyme binding | 315
transcription corepressor activity | 307
polysaccharide binding | 270
sugar binding | 263
oxidoreductase activity, acting on paired donors, with incorporation or reduction of molecular oxygen | 253
hydrolase activity, acting on acid anhydrides, catalyzing transmembrane movement of substances | 253
Spreadsheet: 722226d1615125057-increasing-decrease-a-cells-value-by-a-specific-rate-based-on-another-cells-value-attach
Sheet: Sheet1

 | Cheese Type | Cost Per Kilo in Euros (€) | Cost Per Kilo in Pounds (£) | Average monthly sales | Sales Price | Sales Margin/Profit |  | Exchange Rate (from Euros € to Pounds £) | 0.7
 | [NAME] | 28 |  | 900 |  |  |  | Sales Margin | 0.4
 | Emmental | 32 |  | 850
 | Gruyere | 35 |  | 875 |  |  |  | Note:
 | Edam | 29 |  | 825 |  |  |  | Sales Price = Cost per Kilo * 1.4
 | Gouda | 31 |  | 700 |  |  |  | or
 |  |  |  |  |  |  |  | Sales Price = Cost per Kilo + Sales Margin (which is just 0.4% of Cost)
Spreadsheet: 870921d1717409015-targets-vs-act-test-177-aligw
Sheet: Sheet1

 | REV STREAM | 2023 Q1 | 2023 Q2 | 2023 Q3 | 2023 Q4 | 2023 ACT | 2023 TARGET | OPEN. ORDER | Q1 ACT 2024 | Q2 ACT 2024 | Q3 ACT 2024 | Q4 ACT 2024 | Q1 TARGET | [NAME] | [NAME] | [NAME] | 2024 TARGET | ACT VS TGT
PROPERTIES |  |  |  |  |  |  |  |  | 0.25 | 0.25 | 0.15 | 0.35 | 0.25 | 0.25 | 0.15 | 0.35
XY | ONG | 36419.69 | 20445.29 | 17640.29 | 7508.53 |  | 50000 | 0 | 10000 | 15000 | 10000 | 10000 |  |  |  |  | 70000
Spreadsheet: 782745d1654231145-sumifs-function-showing-0-data-copy-for-forum
Sheet: Data

Year | Location | Task | Date Completed | Team Leader | Numbers | Number Full-time Staff | Number Casual | Number SWP | Number PLS | Total Hours2
 | Shed 1 | Task | 2020-01-28 00:00:00 | jj | 20000 | 2 | 0 | 6 | 0 | 60.25
 | Shed 1 | Task | 2020-01-29 00:00:00 | jj | 20000 | 3 | 0 | 6 | 0 | 66.5
 | Shed 1 | Task | 2020-01-30 00:00:00 | Bg | 10734 | 2 | 0 | 3 | 0 | 37.25
 | Shed 5 | Task | 24/02/2020 | Jj | 15000 | 2 | 0 | 4 | 1 | 53.75
 | Shed 5 | Task | 25/02/2020 | Jj | 15000 | 2 | 0 | 4 | 1 | 49
 | Shed 5 | Task | 26/02/2020 | Jj | 15000 | 2 | 0 | 4 | 1 | 52.5
 | Shed 5 | Task | 27/02/2020 | Jj | 5000 | 1 | 0 | 2 | 0 | 23.25
 | Shed 5 | Task | 28/02/2020 | mf | 10920 | 2 | 2 | 1 | 3 | 82.5
 | Shed 4 | Task | 16/03/2020 | jj | 36000 | 5 | 1 | 8 | 1 | 113.75
 | Shed 4 | Task | 17/03/2020 | Hs | 10000 | 1 | 0 | 2 | 1 | 31.75
 | Shed 4 | Task | 18/03/2020 | Hs | 10000 | 1 | 1 | 2 | 0 | 29.5
 | Shed 4 | Task | 19/03/2020 | Hs | 5000 | 1 | 0 | 1 | 0 | 15.25
 | Shed 2 | Task | 2020-04-21 00:00:00 | mf | 11000 | 3 | 0 | 3 | 0 | 41.75
 | Shed 2 | Task | 2020-04-22 00:00:00 | mf | 20000 | 4 | 5 | 0 | 0 | 70.75
 | Shed 2 | Task | 2020-04-23 00:00:00 | mf | 19740 | 4 | 1 | 5 | 0 | 74.5
 | Shed 3 | Task | 2020-05-11 00:00:00 | Hs | 14000 | 1 | 0 | 5 | 0 | 44.75
 | Shed 3 | Task | 2020-05-12 00:00:00 | mf | 15000 | 2 | 0 | 5 | 0 | 47.5
 | Shed 3 | Task | 2020-05-13 00:00:00 | mf | 16000 | 2 | 0 | 5 | 0 | 47.75
 | Shed 3 | Task | 2020-05-14 00:00:00 | mf | 16000 | 2 | 0 | 5 | 0 | 50.75
 | Shed 1 | Task | 2020-06-01 00:00:00 | jj | 20000 | 5 | 0 | 4 | 0 | 63.75
 | Shed 1 | Task | 2020-06-02 00:00:00 | jj | 20000 | 5 | 0 | 4 | 0 | 61.5
 | Shed 1 | Task | 2020-06-03 00:00:00 | Hs | 10000 | 4 | 1 | 0 | 0 | 35.5
Spreadsheet: 802964d1667182983-weighted-raffle-members-1-1-
Sheet: Member

Name | did thing | did other thing | Raffle Eligibility | Tickets | % Weight | Helper
1 | True | True |  | 1
2 | False | False |  | 1
3 | True | True |  | 2
4 | True | True |  | 2
5 | False | False |  | 0
6 | True | True |  | 2
7 | True | True |  | 2 |  |  | Total Tickets:
8 | True | True |  | 0 |  |  | Random Number:
9 | True | True |  | 0 |  |  | Winner:
10 | True | True |  | 1
11 | False | False |  | 0
12 | True | True |  | 2
13 | True | True |  | 2
14 | True | True |  | 0
15 | True | True |  | 0
16 | False | False |  | 0
17 | True | True |  | 2
18 | True | True |  | 1
19 | True | True |  | 0
20 | False | False |  | 1
21 | False | False |  | 0
22 | True | True |  | 2
23 | False | False |  | 2
Spreadsheet: 183001d1348676973-how-to-make-decimal-places-automatic-inspection-report-formatting-project-master-copy
Sheet: Sheet1

 |  |  | Customer Part No: |  |  |  |  | Trueline Part No:
 |  |  | Customer: |  |  |  |  | Part/Print Revision:
 |  |  | Trueline Job No: |  |  |  |  | Date:
 |  |  | Inspector :
 | Rev
Crit. Dim | ID No. | Dimension Target | Tolerance  -/+ | Upper Spec Limit | Lower Spec Limit | Unit | Measuring Device | Device ID | Piece    1 | Piece    2 | Piece    1. | Piece 2.
 |  | 1 |  |  |  | [NAME] |  |  | 1 | 2 | 3 | 4
 |  | 1 |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  | 1 |  |  |  |  |  |  | 1 | 2 | 3 | 4
 |  | 1 |  |  |  |  |  |  | 1 | 2 | 3 | 4
Spreadsheet: 11bbe561-7d26-48d6-a62c-6ff5665706be
Sheet: Sheet1

Pine Ridge |  | [NAME] |  | Eagle Nest |  | LaCreek |  | Pass Creek |  | Wounded Knee
867-5893 |  | 455-2450 |  | 462-6274 |  | 685-6407 |  | 455-2757 |  | 867-5352
[NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] Head |  | [NAME]
A-G Loretta Red Feather |  | A-L Dora "Gina" Ferguson |  | A-Z [NAME] |  | A-Z Keely Clausen |  | A-Z Will Spotted Eagle |  | A-Z Vina White Hawk
H-P Bessie LeBeau |  | M-Z Annette Red Owl
Q-Z Chrysan Smallwood |  | SSS [NAME]
SSS Thalia Ellis |  | GED [NAME]
GED Cassie Big Crow
Rapid City |  | Cheyenne River |  | East Wakpamni |  | [NAME] |  | Oglala |  | Nursing
342-1513 |  | 964-8010 |  | 288-1834 |  | 867-5404 |  | 867-5780 |  | 867-5856
[NAME] |  | [NAME] |  | [NAME] |  | Janice Richards |  | [NAME] |  | [NAME]
[NAME] |  | [NAME] |  | A-Z Trina Lona Hill |  | A-Z Alva Good Crow |  | A-Z Tony Ten Fingers
A-E Leatrice Wilson |  | A-F Clint Knife
F-L Darelyn Runnels |  | G-M Sharana Iron Wing
M-R Madonna [NAME] |  | N-Z Sara Bad Warrior
S-Z Jackie Alcantar
Spreadsheet: 764604d1642814261-summary-tab-from-inconsistent-data-structure-and-location-sample
Sheet: SUV

SUV
[NAME] |  |  |  | Toyota |  |  | Honda |  |  | Lexus
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Information Section |  |  |  | "data" | "data" |  | "data" | "data" |  | "data" | "data"
Car Price |  |  |  | 45000 |  |  | 48000 |  |  | 49500
Price with Tax
Spreadsheet: 274806d1383227155-vlookup-between-workbooks-data-with-vlookup-moo
Sheet: Sheet1

2010-10-01 00:00:00 | 1057.197 | 69.47 | 89.264
2010-10-02 00:00:00 | 1117.905 | 79.521 | 128.992
2010-10-03 00:00:00 | 1059.862 | 63.09 | 101.369
2010-10-04 00:00:00 | 1001.974 | 63.68 | 92.563
2010-10-05 00:00:00 | 1008.651 | 64.465 | 93.604
2010-10-06 00:00:00 | 981.942 | 61.43 | 94.457
2010-10-07 00:00:00 | 981.86 | 67.774 | 99.831
2010-10-08 00:00:00 | 1018.09 | 78.544 | 97.243
2010-10-09 00:00:00 | 1030.171 | 81.227 | 91.699
Spreadsheet: 59805d1260362432-getting-averages-from-seperate-worksheets-2010
Sheet: August

 |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Monday |  | Tuesday
 |  | 2010-08-02 00:00:00 |  | 2010-08-03 00:00:00 |  | 2010-08-04 00:00:00 |  | 2010-08-05 00:00:00 |  | 2010-08-06 00:00:00 |  | 2010-08-07 00:00:00 |  | 2010-08-09 00:00:00 |  | 2010-08-10 00:00:00 |  | 2010-08-11 00:00:00 |  | 2010-08-12 00:00:00 |  | 2010-08-13 00:00:00 |  | 2010-08-14 00:00:00 |  | 2010-08-16 00:00:00 |  | 2010-08-17 00:00:00 |  | 2010-08-18 00:00:00 |  | 2010-08-19 00:00:00 |  | 2010-08-20 00:00:00 |  | 2010-08-21 00:00:00 |  | 2010-08-23 00:00:00 |  | 2010-08-24 00:00:00 |  | 2010-08-25 00:00:00 |  | 2010-08-26 00:00:00 |  | 2010-08-27 00:00:00 |  | 2010-08-28 00:00:00 |  | 2010-08-30 00:00:00 |  | 2010-08-31 00:00:00
Consultant Name | Team Leader | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved | Sales | Approved
Mpho | [NAME]
[NAME] | [NAME]
Glodean ([NAME]) | [NAME]
[NAME] | [NAME]
Lehlohonolo | [NAME]
Matshidiso | [NAME]
Rachel | [NAME]
Naledi G | [NAME]
Innocentia | [NAME]
Glyndine | [NAME]
Total |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultant | Total Sales | Monthly Target | [NAME] | Total Approved | QA Monthly Score | QA Rating
Mpho | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Glodean ([NAME]) | 0 |  | 0 | 0 |  | -
[NAME] | 0 |  | 0 | 0 |  | -
Lehlohonolo | 0 |  | 0 | 0 |  | -
Matshidiso | 0 |  | 0 | 0 |  | -
Rachel | 0 |  | 0 | 0 |  | -
Naledi G | 0 |  | 0 | 0 |  | -
Innocentia | 0 |  | 0 | 0 |  | -
Glyndine | 0 |  | 0 | 0 |  | -
Total | 0 | 0 | 0 | 0 | #N/A | #N/A
 |  | 0 | 0.8499 | D
 |  | 0.85 | 0.9 | C
 |  | 0.91 | 0.9499 | B
 |  | 0.95 | 1 | A
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E11.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER CURRENT LIABILITIES
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-11
 |  | 12-31-2000 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 INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Customer receipts/ [NAME] refunds |  | 0 |  | 147648
Vendor Invoices : Payables |  |  |  |  |  |  |  | -204689
Payables - To be handled in the third quarter |  |  |  |  |  |  |  | 410339.6
Salary & Wages reclass to be corrected in third quarter |  |  |  |  |  |  |  | 1833781.19
Cash Receipts to be reclassed in the third quarter |  |  |  |  |  |  |  | -2380
Rent allocations to be handled in the third quarter |  |  |  |  |  |  |  | -193985.53
Operating expenses to be handled in the third quarter |  |  |  |  |  |  |  | -104883.71
Total Other Current Liabilities
(must tie to Hyperion account 655) | * |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Income Accts:  DR/(CR)
Reverse signs from Hyperion
Spreadsheet: eric_saibi__9856__101101
Sheet: Indian River 04

Owner Name |  | NRG Energy Incorporated
Station Name |  | Indian River Power Station
Unit Name |  | Indian River 04
NERC Region |  | MAAC
State |  | DE
Fuel Type |  | Coal
Capacity |  | 442 MW
Start Date |  | 2001-10-05 00:00:00
End Date |  | 2001-11-05 00:00:00
Comments |  | Had vibrations, doing a turbine teardown to see what the problem is
SIC |  | 4931
Plant ID |  | 1515051
Unit ID |  | 1008236
Outage ID |  | 18639
Spreadsheet: michelle_lokay__26805__imbalsumm
Sheet: Conoco

 | Maljamar |  | Zia
Day | Measured | Scheduled | Measured | Scheduled
1 | 31583 | 31787 | 27178 | 25827
2 | 30117 | 29103 | 25574 | 22929
3 | 31678 | 30138 | 27326 | 22760
4 | 32547 | 32189 | 25899 | 25359
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2000-07-31 00:00:00 |  | 398192.92 |  | -387193.64
2000-08-04 00:00:00
Spreadsheet: 271081d1381815610-help-need-a-formula-to-calculate-due-date-but-exclude-weekends-if-due-date-falls-on-it-due-date-sample
Sheet: Docket Tracking

Docket # | *226633*
Date | Sub-job # | Due Date | Special Instructions | Comments
ENTER DATE | *01* | DUE DATE Should Exclude holidays on Stat Holiday Tab and if it falls on a weekend (Sat or Sun) move to the next Business day | CYCLE CHANGES ETC.
2013-10-13 00:00:00 | *02* | 2013-10-15 00:00:00 | DUE Date should go to 10/15/2013 as 10/13 is a weekend and 10/14 is a stat holiday
2013-10-14 00:00:00 | *03* | 2013-10-15 00:00:00 | DUE Date should go to 10/15/2013 as 10/14 is a stat holiday
2013-10-15 00:00:00 | *04* | 2013-10-15 00:00:00 | Due date is ok
 | *05*
 | *06*
 | *07*
 | 1
Spreadsheet: 765752d1643566751-how-to-average-sales-data-based-on-a-matching-date-bh-performance-tracker-january-copy-22
Sheet: Deal Processing

TO BE PROCESSED |  |  |  |  |  |  |  | PROCESSED
Sales Rep | Year | Vehicle | Client | Business Manager | STATUS |  |  | Sales Rep | Year | Vehicle | Client | Business Manager
Spreadsheet: 842205d1694284456-transform-certain-columns-to-rows-based-on-the-values-sample_m
Sheet: Tested

Cat | Sub | Add | Add1 | Add2
Spreadsheet: 708096d1607614368-returning-value-in-one-sheet-based-on-data-and-time-criteria-in-another-result-based-on-data-and-time-match
Sheet: Result sheet

Date (DD/MM/YYYY) | 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
2020-10-15 00:00:00 | 10 | 15 | 6
2020-10-16 00:00:00 | [NAME] needed to check ensure that the correct value is extracted from the data sheet, to the result sheet.
2020-10-17 00:00:00
2020-10-18 00:00:00
2020-10-19 00:00:00
2020-10-20 00:00:00
2020-10-21 00:00:00
2020-10-22 00:00:00
2020-10-23 00:00:00
2020-10-24 00:00:00
2020-10-25 00:00:00
Spreadsheet: 847446d1698366144-possible-sumif-s-or-dynamic-range-question-sample-v2-thenoisydrum-
Sheet: User View

 |  |  |  |  |  | Brand A
 |  |  |  |  |  | Brand B
 |  |  |  |  |  | Brand C
 |  |  |  |  |  | Grand Total
 |  |  |  |  |  | Filtered Total
 |  |  |  | Hierarchy Account | Hierarchy Name | Customer Class | Jan-23 | Feb-23 | Mar-23 |  | Hierarchy Account | Hierarchy Name | Customer Class | Sum of Jan-23 | Sum of Feb-23 | Sum of Mar-23
 |  |  |  | 10001 | [NAME] | Direct | 50 | 45 | 60 |  | 10002 | [NAME] | Indirect | 120 | 150 | 180
 |  |  |  | 10002 | [NAME] | Indirect | 120 | 150 | 180 |  | Grand Total |  |  | 120 | 150 | 180
 |  |  |  | 10003 | [NAME] | Indirect | 35 | 35 | 30
 |  |  |  | 10004 | [NAME] | Direct | 400 | 380 | 350
 |  |  |  | 10005 | [NAME] | Direct | 70 | 80 | 90
 |  |  |  | Notes
 |  |  |  | 1. Example. The user filters on [NAME] and the dataset above will show just that particular customer
 |  |  |  | 2. In the data range above, H2:J4, there will be formulas that extract the brand values from tab "Hidden Data" (the user will not see this tab)
 |  |  |  | 3. I have manually typed in what the values would be but it is here that I am stuck - I need formulas to do this
 |  |  |  | 4. My manager wants only a single row for each customer with the totals visible, but the brand breakdown to be reflected in H2:J4
Spreadsheet: 4101fe4e-4d7e-49d7-87d2-4e059e47d1c7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: New Residential Construction
 |  | Housing Units Started: United States
 |  | Not Seasonally Adjusted Single-family Units [Thousands of Units]
 |  | Period: 2008 to 2012
 |  | Data Extracted on: June 18, 2013 (11:35 pm)
Period | Value
Jan-2008 | 48.5
Feb-2008 | 51.9
Mar-2008 | 61.5
Apr-2008 | 62.6
May-2008 | 66.1
Jun-2008 | 65.2
Jul-2008 | 59.9
Aug-2008 | 54.4
Sep-2008 | 48.7
Oct-2008 | 45.8
Nov-2008 | 31.3
Dec-2008 | 26.1
Jan-2009 | 22.7
Feb-2009 | 24.6
Mar-2009 | 31
Apr-2009 | 35
May-2009 | 39.5
Jun-2009 | 49.2
Jul-2009 | 49.3
Aug-2009 | 43.4
Sep-2009 | 45.6
Oct-2009 | 39.4
Nov-2009 | 35.2
Dec-2009 | 30.1
[NAME] | 31.7
[NAME] | 35.2
Mar-2010 | 47.4
Apr-2010 | 52.2
[NAME] | 44.5
[NAME] | 45.5
[NAME] | 40.7
Aug-2010 | 39.1
Sep-2010 | 39.2
Oct-2010 | 36
Nov-2010 | 33
Dec-2010 | 26.6
Jan-2011 | 26.6
Feb-2011 | 26.6
Mar-2011 | 36.3
Apr-2011 | 37.7
May-2011 | 40.9
Jun-2011 | 44.8
Jul-2011 | 41
Aug-2011 | 39.4
Sep-2011 | 37.3
Oct-2011 | 36.2
Nov-2011 | 32.7
Dec-2011 | 31
Jan-2012 | 33.1
Feb-2012 | 32.2
Mar-2012 | 40.2
Apr-2012 | 46.6
May-2012 | 50.1
Jun-2012 | 54.4
Jul-2012 | 49.4
Aug-2012 | 49.3
Sep-2012 | 51.4
Oct-2012 | 50.3
Nov-2012 | 40.1
Dec-2012 | 38.2
Spreadsheet: 831089d1685416630-identifying-most-common-occurrences-text-with-criteria-preppy_prince_example_30052023_v2
Sheet: Sheet1

DATA | NAME | HOURS | CONTRACT | TRAINING | SUMMARY | NAME | HOURS | CONTRACT
 | [NAME] | 4 | Full-time | N/A
 | [NAME] | 4 | Part-time | N/A
 | Emma | 3 | Full-time | Trainee
 | Sophie | 4 | Casual | Trainer
 | [NAME] | 2.75 | Casual | N/A
 | Julie | 4 | Casual | Trainer
 | Mark | 5 | Casual | Trainee
 | [NAME] | 3 | Casual | Trainee
 | [NAME] | 4 | Full-time | N/A
 | Mark | 3 | Casual | Trainee
 | [NAME] | 5 | Full-time | N/A
 | [NAME] | 4 | Casual | N/A
 | Sophie | 5 | Casual | Trainer
 | Sophie | 5 | Casual | Trainer
 | [NAME] | 3 | Casual | Trainee
 | [NAME] | 2.75 | Full-time | N/A
 | [NAME] | 2 | Part-time | N/A
 | [NAME] | 3 | Part-time | N/A
 | Sophie | 3 | Casual | Trainer
 | Mark | 4 | Casual | Trainee
 | [NAME] | 4 | Full-time | N/A
 | Sophie | 3 | Casual | Trainer
 | Emma | 5 | Full-time | Trainee
 | [NAME] | 3 | Full-time | N/A
 | Julie | 3.5 | Casual | Trainer
 | Sophie | 4 | Casual | Trainer
 | Julie | 4 | Casual | Trainer
 | Mark | 4 | Casual | Trainee
 | Emma | 3 | Full-time | Trainee
 | Sophie | 3 | Casual | Trainer
Spreadsheet: 327990d1403757103-index-match-retrieve-data-across-unique-sheets-with-unique-column-identifiers-budget-example
Sheet: Summary

 |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  |  |  |  |  |  |  |  | Mapping |  | Mapping
 |  |  |  | TITLE
 |  |  |  | Reconciliation Output
Mapping |  |  |  | By Project
Roll-up | Account |  | Unique identifier | General Operating Costs | Branch | Business | Project | Project | Fund Source |  | Budgeted Effective FTE |  | Total Approved Budget
TOTAL [NAME]: | 6572 |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
TOTAL [NAME]: | 6573 |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
TOTAL [NAME]: | 6574
TOTAL [NAME]: | 6575
TOTAL [NAME]: | 6576 |  |  | Discretionary Costs
TOTAL [NAME]: | 6577 |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
TOTAL [NAME]: | 6578 |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
TOTAL [NAME]: | 6579
TOTAL [NAME]: | 6580 |  |  | Total Project Cost
TOTAL [NAME]: | 6581 |  |  | [Project Name?] | 733C | 7553 | 23829 / 001
TOTAL [NAME]: | 6582 |  |  | [Project Name?] | 733C | 7553 | 23943 / 222
TOTAL [NAME]: | 6583 |  |  |  |  | 7553 Total