tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 809253d1670992074-attendance-tracker-pto-tracker-ex
Sheet: Emp. list

 | NAME
1 | Employee 1
2 | Employee 2
3 | Employee 3
4 | Employee 4
5 | Employee 5
6 | Employee 6
7 | Employee 7
8 | Employee 8
9 | Employee 9
10 | Employee 10
11 | Employee 11
12 | Employee 12
13 | Employee 13
14 | Employee 14
15 | Employee 15
16 | Employee 16
17 | Employee 17
18 | Employee 18
19 | Employee 19
20 | Employee 20
21 | Employee 21
22 | Employee 22
23 | Employee 23
24 | Employee 24
25 | Employee 25
26 | Employee 26
27 | Employee 27
28 | Employee 28
29 | Employee 29
30 | Employee 30
31 | Employee 31
32 | Employee 32
33 | Employee 33
34 | Employee 34
35 | Employee 35
36 | Employee 36
37 | Employee 37
38 | Employee 38
39 | Employee 39
40 | Employee 40
41 | Employee 41
42 | Employee 42
43 | Employee 43
44 | Employee 44
45 | Employee 45
46 | Employee 46
47 | Employee 47
48 | Employee 48
49 | Employee 49
50 | Employee 50
51 | Employee 51
52 | Employee 52
53 | Employee 53
54 | Employee 54
55 | Employee 55
56 | Employee 56
57 | Employee 57
58 | Employee 58
59 | Employee 59
60 | Employee 60
61 | Employee 61
62 | Employee 62
63 | Employee 63
64 | Employee 64
65 | Employee 65
66 | Employee 66
67 | Employee 67
68 | Employee 68
69 | Employee 69
70 | Employee 70
71 | Employee 71
72 | Employee 72
73 | Employee 73
74 | Employee 74
75 | Employee 75
76 | Employee 76
77 | Employee 77
78 | Employee 78
79 | Employee 79
80 | Employee 80
81 | Employee 81
82 | Employee 82
83 | Employee 83
84 | Employee 84
85 | Employee 85
Spreadsheet: 145151d1331318433-automatic-sorting-sortingbycatagories
Sheet: Office Expense Input

 |  |  | Office Expense
 |  |  |  | Date |  | Description |  | Amount
 |  |  |  |  | Meals | Pizza |  | 300
 |  |  |  |  | Meals | Italian |  | 500
 |  |  |  |  | Office | Chairs |  | 1000
 |  |  |  |  | Office | Painting |  | 200
 |  |  |  |  | Groceries | Red Bull |  | 500
 |  |  |  |  | Groceries | Powerbars |  | 90
Spreadsheet: jeff_dasovich__14257__Strategy Master
Sheet: Investigators

Investigators
Steffes/Dasovich
Target |  |  |  | Contact |  | Enron |  | Status
FERC |  |  |  |  |  | Hartsoe
California AG |  |  |  |  |  | Steffes
CPUC |  |  |  |  |  | [NAME]
California EOB |  |  |  |  |  | [NAME]
Messages
Action Items |  |  |  |  |  | Status
 | Identify who is running the investigation
 | Internal Investigation of EPMI West Actions (Summer 2000)
 | Manage the downside of investigations
Spreadsheet: 262421d1378141889-choosing-one-of-the-duplicate-customer-info-testworkbook_unsort_optimize_customer_-ijulian-_
Sheet: Sales

Salesman | CUSTOMER | CHANGE DATE | SOLD DATE | CONTRACT | STATUS | NET VOLUME | helper [NAME] | helper column2
[NAME] | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527 | 2013-03-09 00:00:00 | 2013-03-09 00:00:00 | 16684645 | GOOD | 10196
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-03-20 00:00:00 | 2013-03-20 00:00:00 | 16687558 | GOOD | 13760
VIOLETTA | Abalos, Heather Oro 9-178537891 | 2013-05-08 00:00:00 | 2013-03-20 00:00:00 | 16687558 | CANCEL | -13760
SHARON | Abantao, [NAME] 9-178524376 | 2013-03-30 00:00:00 | 2013-03-30 00:00:00 | 16690348 | PENDING | 20499
MARILYN | Abshire, Kimberly D 9-175949879 | 2012-11-18 00:00:00 | 2012-11-18 00:00:00 | 16659635 | GOOD | 9770
STEVE | Academia, [NAME] | 2013-08-04 00:00:00 | 2013-08-04 00:00:00 | 16870401 | GOOD | 14420
STEVE | Academia, [NAME] | 2013-08-10 00:00:00 | 2013-08-04 00:00:00 | 16870401 | CANCEL | -14420
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-19 00:00:00 | 2013-01-19 00:00:00 | 16673452 | PENDING | 7000
RUBEN | Acosta, Josafath 9-177958678 | 2013-01-28 00:00:00 | 2013-01-19 00:00:00 | 16673452 | CANCEL | -7000
WILLIAM | Adams, Jr, [NAME] 9-178588989 | 2013-03-17 00:00:00 | 2013-03-17 00:00:00 | 16686589 | GOOD | 14420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-04 00:00:00 | 2013-05-04 00:00:00 | 16701220 | PENDING | 2420
VERONICA | Adams, Lannia Alvanie 9-178968403 | 2013-05-14 00:00:00 | 2013-05-04 00:00:00 | 16701220 | CANCEL | -2420
[NAME] | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527 | 2013-03-09 00:00:00 | 2013-03-09 00:00:00 | 16684645 | CANCEL | -10196
SHARON | Abantao, [NAME] 9-178524376 | 2013-03-30 00:00:00 | 2013-03-30 00:00:00 | 16690348 | CANCEL | -20499
Spreadsheet: 692673d1598494945-max-value-on-cell-from-the-list-h1-h8-maxifs-with-errors
Sheet: Sheet1

 |  |  |  | To | T' (A) | T (A) | T∞
 |  |  | 1 | 30 | 20
 |  |  | 2 | 27 | 20
 |  |  | 1 | 63 | 20
 |  |  | 0 | 51 | 20
 |  |  | 0
 |  |  | 5 | 37 | 20
 |  |  | 1 | 42 | 20
Spreadsheet: 713465d1610726873-index-and-match-or-vlookup-based-off-of-multiple-criteria-manager-list
Sheet: Sheet1

Name | Title | Department Code | Bonus Amount | In role 6 Months? |  |  | Name | Title | Department Code
 | Manager | 307490
 | Manager | 342441 |  |  |  |  | [NAME] | Manager | 306228
 | Manager | 345321 |  |  |  |  | [NAME] | Manager | 331186
 | Manager | 331383 |  |  |  |  | [NAME] | Manager | 354028
 | Manager | 336421 |  |  |  |  | [NAME] | Manager | 303465
 | Manager | 351927 |  |  |  |  | Dina Simoes | Manager | 330462
 | Manager | 338416 |  |  |  |  | [NAME] | Manager | 336668
 | Manager | 338424
 | Manager | 349843
 | Manager | 356946 |  |  |  |  | [NAME] | Manager | 357114
 | Manager | 338120 |  |  |  |  | [NAME] | Manager | 307490
 | Manager | 303453 |  |  |  |  | [NAME] | Manager | 331383
 | Manager | 331381 |  |  |  |  | [NAME] | Manager | 336421
 | Manager | 348873 |  |  |  |  | [NAME] | Manager | 342441
 | Manager | 351596 |  |  |  |  | [NAME] | Manager | 345321
 | Manager | 343348 |  |  |  |  | [NAME] | Manager | 338120
 | Manager | 338123 |  |  |  |  | [NAME] | Manager | 338416
 | Manager | 303462 |  |  |  |  | [NAME] | Manager | 351927
 | Manager | 339861 |  |  |  |  | [NAME] | Manager | 356946
 | Manager | 336667 |  |  |  |  | [NAME] | Manager | 303462
 | Manager | 336668 |  |  |  |  | Sandra Assis | MUL | 303462
 | Manager | 306228 |  |  |  |  | ARTJOLA BARDHOSHI | Manager | 336667
 | Manager | 331185
 | Manager | 331186 |  |  |  |  | [NAME] | Manager | 338123
 | Manager | 352767 |  |  |  |  | [NAME] | Manager | 339861
 | Manager | 354028 |  |  |  |  | Stephanie Rasun | Manager | 337678
 | Manager | 303465 |  |  |  |  | [NAME] | Manager | 343363
 | Manager | 357114 |  |  |  |  | [NAME] | Manager | 303453
 | Manager | 330462 |  |  |  |  | [NAME] | Manager | 331381
 | Manager | 337680 |  |  |  |  | [NAME] | Manager | 348873
 | Manager | 310018 |  |  |  |  | [NAME] | Manager | 351596
 | Manager | 337678
 | Manager | 343363
 | Manager | 340437
Spreadsheet: 48138d1247320165-help-for-a-school-for-children-with-learning-difficulties-691078
Sheet: Sheet1

Pupil | Code | Score | Grade
Fred | l5c | 40 | Grade E
 |  |  |  |  |  |  | Code | Score
 |  |  |  | 0 | [NAME] |  | L1A | 11
 |  |  |  | 40 | Grade E |  | L1B | 13
 |  |  |  | 50 | Grade D |  | L1C | 15
 |  |  |  | 60 | [NAME] |  | L2A | 17
 |  |  |  | 70 | [NAME] |  | L2B | 19
 |  |  |  | 80 | Grade A |  | L2C | 21
 |  |  |  |  |  |  | [NAME] | 23
 |  |  |  |  |  |  | L3B | 25
 |  |  |  |  |  |  | L3C | 27
 |  |  |  |  |  |  | L4A | 29
 |  |  |  |  |  |  | L4B | 31
 |  |  |  |  |  |  | [NAME] | 33
 |  |  |  |  |  |  | L5A | 35
 |  |  |  |  |  |  | L5B | 37
 |  |  |  |  |  |  | L5C | 40
 |  |  |  |  |  |  | L6A | 41
 |  |  |  |  |  |  | L6B | 43
 |  |  |  |  |  |  | L6C | 45
Spreadsheet: 55182d1255353070-how-to-automatically-alter-formula-when-filters-are-applied-malchemist-2
Sheet: 31934

Date of Order | Date of Order | Year Of Order | Month Of Order | Item No. | Description | Quantity | [NAME] value £ | Order Number | Contract
20080520 | 2008-05-20 | 2008 | 5 | 371675 | Powder-actuated tool DX 460 MX 72 | 1 | 0 | 107250 | 31934
Spreadsheet: 226577d1365444606-excel-solver-problem-ive-never-used-it-acres-oeldere2-
Sheet: Blad1

 | acres | bulls/cows | acres | total
 | 0.75
1000 |  | 30 | 2
 |  | 1 | 2
 |  |  |  |  |  | [NAME]
 | hi All - I have a problem and think I would like to experience using solver to help me solve this:
 | given 1000 acres of land, and that 75% of its is pasturable - I want to maximize the numbers of cows that can be on it.
 | There can be a max of 1 cow per 2 acres
 | And we need 1 bull per 3 acres
 | The ratio of bulls to cows is 1 bull per 30 cows
 | how many cows and how many bulls can we have in total for the 750 acres?
 | Thank you!
Spreadsheet: 721217d1614592713-extract-entire-row-when-condition-is-met-and-create-a-funnel-between-the-tabs-classeur
Sheet: Screening Database

Internal ID | City | Region | Potential? |  | Internal ID | City | Region | Potential? | Analysed? |  | Internal ID | City | Region | Potential? | Analysed? | Make offer?
245-01 | GVA | GE | Yes |  |  | GVA | GE | Yes | yes |  |  | GVA | GE | Yes | yes | yes
245-02 | LSN | VD | Yes |  | 245-02 | LSN | VD | Yes | yes |  | 245-02 | LSN | VD | Yes | yes | yes
245-03 | FBG | FR | Yes |  | 245-03 | FBG | FR | Yes | no |  | 246-08 | WZT | ZH | Yes | yes | no
245-04 | GVZ | FR | No |  | 246-06 | ZUG | ZG | Yes | no |  | 247-02 | ZUY | ZH | yes | yes | yes
245-05 | ZRC | ZH | no |  | 246-08 | WZT | ZH | Yes | yes
246-06 | ZUG | ZG | Yes |  | 247-01 | TGE | TG | Yes | no
246-07 | AGH | TG | No |  | 247-02 | ZUY | ZH | yes | yes
246-08 | WZT | ZH | Yes
247-01 | TGE | TG | Yes
247-02 | ZUY | ZH | yes
247-03 | KJH | WX | No
Spreadsheet: 99095d1297858298-sumproduct-with-2-conditions-test
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Name | Amount
 |  | [NAME] for excel 2003 |  |  |  |  |  |  | Yes | 7867 | 900
 |  | Total No | Total Amount |  |  |  |  |  | No | 10 | 200
Digits only | Yes | 0 | 0 |  |  |  |  |  | Yes | 10 | 900
Digits only | No | 0 | 0 |  |  |  |  |  | No | T100 | 700
 |  |  |  |  |  |  |  |  | Yes | T200 | 739
Text & Digits | Yes | 1 | 1439
Text & Digits | No | 1 | 1439
Spreadsheet: 451159d1458062217-understanding-a-calendar-excel-template-community-event-planner1
Sheet: ADMIN

 | MONTH | NUMBER
 | JANUARY | 1
 | FEBRUARY | 2
 | [NAME] | 3
 | APRIL | 4
 | MAY | 5
 | [NAME] | 6
 | JULY | 7
 | AUGUST | 8
 | SEPTEMBER | 9
 | OCTOBER | 10
 | NOVEMBER | 11
 | DECEMBER | 12
Spreadsheet: 07139649-9eaa-46fd-a7f6-a99c63f2f2ef
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | EMERGENCY GENERATOR BASELINE MAINTENANCE | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Date: |  |  |  |  | Manufacturer & Model No.
Site Name: |  |  |  |  | Serial No:
Inspection performed by:
Ö [NAME] |  |  | Readings |  | Ö [NAME] |  |  | Readings
 | Replacement of Parts: |  |  |  |  | Perform Engine Running Operational Check:
 | All Radiator, Fuel and [NAME] |  |  |  |  | Check Engine Oil Pressure Gauge Reading (psi)
 | Belts and Spark Plugs |  |  |  |  | Check Engine Coolant Temperature Gauge Reading (F)
 | Defective Wiring and Ignition Parts
 | Oil and Air Filter |  |  |  |  | [NAME]:
 | Crankcase Oil and [NAME] |  |  |  |  | Generator Operation (No Load)
 | Radiator Coolant |  |  |  |  |  | Frequency (Hz)
 | Lubrication as Required |  |  |  |  |  | Voltage (Volts)
 | Visual Inspection Checks: |  |  |  |  | Perform Auto Transfer Switch Operational Check:
 | [NAME] (If Applicable) |  |  |  |  | [NAME] under Load
 | Check Battery Voltages |  |  |  |  | Generator Operation (Under Load)
 |  | Stationary Voltage |  |  |  |  | Frequency (Hz)
 |  | Cranking Voltage |  |  |  |  | Voltage (Volts)
 |  | Running Voltage |  |  |  |  | Current (Amps)
 | Battery Charger Operation |  |  |  |  | Check Operation from Transfer Switch
 | Clean & Tighten Baterry Terminals |  |  |  |  |  | Frequency (Hz)
 | Crankcase Oil Level |  |  |  |  |  | Voltage (Volts)
 | Check and Clean Crankcase Breather |  |  |  |  |  | Current (Amps)
 | Check and Clean Radiator |  |  |  |  | Check Unit in Automatic & Breaker Closed
 |  | Coolant Level: |  |  |  | Check Setting on Exerciser Clock
 |  | Coolant Condition |  |  |  |  | Day
 |  | Leaks: |  |  |  |  | Time
 | Belts, Check Condition and Tension |  |  |  |  |  | Duration
 | Hoses, Check Condition and [NAME] |  |  |  |  | Record the Following Information
 | Block Heater Operation |  |  |  |  |  | TDES Engine Start (Sec)
 | Air Filter Condition and Duct Connection |  |  |  |  |  | TDNE Normal to Emergency (Sec)
 | Check Dip Drain on Exhaust |  |  |  |  |  | TDEN Emergency to Normal (Min)
 | Inspect Exhaust Flex Connectors, Hangers & Supports |  |  |  |  |  | TDEC Engine Cool-Down (Min)
 | Check Engine Electrical Connections |  |  |  |  |  | TDOE Off to Emergency (Sec)
 |  |  |  |  |  |  | DTON Off to Normal (Sec)
 | Perform Engine Running Operational Check:
 | Check for Leaks: Indicate Results
 | Fuel |  |  |  |  | Return All Systems to Normal Operation:
 | Oil |  |  |  |  | Record Run Time Hour [NAME]
 | Coolant |  |  |  |  | Return All Systems to Normal Operation:
 | Exhaust |  |  |  |  | Record Follow-up Actions Required
 |  |  |  |  |  | Record and File Report on All Items Listed Above
Comments and Recommendations
REPLACEMENT OF FLUIDS AND FILTERS:
VISUAL INSPECTIONS CHECK:
PERFORM ENGINE RUNNING OPERATIONAL CHECKS:
[NAME]:
PERFORM AUTOMATIC TRANSFER SWITCH OPERATIONAL CHECK:
RETURN ALL SYSTEMS TO NORMAL OPERATION:
OTHER OBSERVATION:
Spreadsheet: 841755d1693924951-rent-projection-with-different-escalation-patterns-rent-projection
Sheet: Working Sheet

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2024-12-31 00:00:00
 |  |  | As per Current Contract |  |  |  |  |  |  |  |  |  |  |  | Monthly Rent after escalation |  |  |  |  |  |  |  |  | Unit to be budgeted? | 2021 Rent |  |  |  |  |  |  |  |  |  |  |  |  | 2022 Rent |  |  |  |  |  |  |  |  |  |  |  |  | 2023 Rent
No | Unit Code | Unit Type | Start date | End date | Rent/SQM | Monthly Rent | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | Escalation | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | Company | Revised GLA |  | 2021-01-31 00:00:00 | 2021-02-28 00:00:00 | 2021-03-31 00:00:00 | 2021-04-30 00:00:00 | 2021-05-31 00:00:00 | 2021-06-30 00:00:00 | 2021-07-31 00:00:00 | 2021-08-31 00:00:00 | 2021-09-30 00:00:00 | 2021-10-31 00:00:00 | 2021-11-30 00:00:00 | 2021-12-31 00:00:00 |  | 2022-01-31 00:00:00 | 2022-02-28 00:00:00 | 2022-03-31 00:00:00 | 2022-04-30 00:00:00 | 2022-05-31 00:00:00 | 2022-06-30 00:00:00 | 2022-07-31 00:00:00 | 2022-08-31 00:00:00 | 2022-09-30 00:00:00 | 2022-10-31 00:00:00 | 2022-11-30 00:00:00 | 2022-12-31 00:00:00 |  | 2023-01-31 00:00:00 | 2023-02-28 00:00:00 | 2023-03-31 00:00:00 | 2023-04-30 00:00:00 | 2023-05-31 00:00:00 | 2023-06-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00
1 | GF 01 | Retail | 2020-11-04 00:00:00 | 2036-01-03 00:00:00 | 125 |  |  |  |  |  | 0.05 | 0.05 | 0.05 | 5% Every Year, upon completion of 5 Years |  |  |  |  |  |  |  | A | 1883.76
 | GF 02 | Retail | 2021-03-15 00:00:00 | 2024-12-09 00:00:00 | 135 |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 5% Every Year, upon completion of 2 Years |  |  |  |  |  |  |  | B | 271.76
 | GF 04 | 0 | 2021-03-15 00:00:00 | 2024-12-09 00:00:00 | 135 |  |  |  | 0.05 | 0.05 | 0.05 | 0.05 | 0.05 | 5% Every Year, upon completion of 2 Years |  |  |  |  |  |  |  | Company | 74.86
 | GF 03 | Retail | 2021-11-15 00:00:00 | 2026-11-14 00:00:00 | 100 |  |  |  | 0.03 |  | 0.03 |  | 0.03 | 3% Every 2 Years |  |  |  |  |  |  |  | D | 95.09
 | 601 | Office | 2022-01-01 00:00:00 | 2026-12-31 00:00:00 | 110 |  |  |  | 0.02 | 0.02 | 0.02 | 0.02 | 0.02 | 2% yearly |  |  |  |  |  |  |  | E | 472.14
Spreadsheet: michelle_lokay__26697__imball0111rev
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5910 | 5780 |  |  | 550 | 1165 | 1645 | 1559
2 | 5759 | 5781 |  |  | 1249 | 1165 | 1634 | 1559
3 | 5689 | 5781 |  |  | 1174 | 1165 | 1633 | 1559
4 | 5751 | 5781 |  |  | 848 | 1165 | 1617 | 1559
5 | 5810 | 5781 |  |  | 1049 | 1165 | 1601 | 1559
6 | 5693 | 5781 |  |  | 1089 | 1165 | 1594 | 1559
7 | 5609 | 5781 |  |  | 983 | 1165 | 1557 | 1559
8 | 5623 | 5781 |  |  | 1114 | 1165 | 1547 | 1559
9 | 5495 | 5781 |  |  | 1139 | 1165 | 1521 | 1559
10 | 5518 | 5781 |  |  | 910 | 1165 | 1545 | 1559
11 | 5516 | 5781 |  |  | 711 | 1165 | 1564 | 1559
12 | 5623 | 5781 |  |  | 1054 | 1165 | 1558 | 1559
13 | 5688 | 5781 |  |  | 1212 | 1165 | 1538 | 1559
14 | 5416 | 5749 |  |  | 1125 | 1165 | 1551 | 1559
15 | 5410 | 5781 |  |  | 981 | 1165 | 1536 | 1559
16 | 6340 | 5781 |  |  | 1052 | 1165 | 1535 | 1559
17 | 6133 | 5781 |  |  | 1051 | 1165 | 1534 | 1559
18 | 6080 | 5781 |  |  | 1012 | 1165 | 1523 | 1559
19 | 6673 | 5781 |  |  | 988 | 1165 | 1514 | 1559
20 | 6427 | 5781 |  |  | 947 | 1165 | 1521 | 1559
21 | 5752 | 5781 |  |  | 1094 | 1165 | 1502 | 1559
22 | 5561 | 5780 |  |  | 1103 | 1165 | 1494 | 1559
23 | 5238 | 5780 |  |  | 1025 | 1165 | 1495 | 1559
24 | 6252 | 5781 |  |  | 998 | 1165 | 1491 | 1559 |  |  | 377
25 | 5740 | 5781 |  |  | 990 | 1165 | 1482 | 1559 |  |  | 725
26 | 5570 | 5781 |  |  | 1012 | 1165 | 1398 | 1559
27 | 6212 | 5781 |  |  | 933 | 1165 | 1381 | 1559
28 | 6500 | 5781 |  |  | 1044 | 1165 | 1343 | 1559
29 | 6435 | 5781 |  |  | 885 | 1165 | 1515 | 1559
30 | 2803 | 5781 |  |  | 1054 | 1165 | 523 | 1559
31
2001-10-31 00:00:00 |  |  |  |  |  |  |  |  | 407482.55
2001-11-30 00:00:00
CBS Volume
 |  |  | 166508
Spreadsheet: 846329d1697570197-conditional-formatting-question-sample-for-excel-forum
Sheet: Sample

ColumnA | ColumnB | ColumnC | ColumnD | ColumnE | ColumnF | ColumnG | ColumnH | ColumnI | ColumnJ | ColumnK | ColumnL | ColumnM | ColumnN | Column O | ColumnP | ColumnQ
 |  |  |  |  |  |  |  |  |  | XXXX3132985 |  |  |  |  |  | XXXX3132985
 |  |  |  |  |  |  |  |  |  | XXXX2284840 |  |  |  |  |  | XXXX2284840
 |  |  |  |  |  |  |  |  |  | XXXX2284840 |  |  |  |  |  | XXXX8084222
 |  |  |  |  |  |  |  |  |  | XXXX8678741 |  |  |  |  |  | XXXX2325019
 |  |  |  |  |  |  |  |  |  | XXXX8678741 |  |  |  |  |  | XXXX2325019
 |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | XXXX5120956 |  |  |  |  |  | XXXX2510357
 |  |  |  |  |  |  |  |  |  | XXXX3896250 |  |  |  |  |  | XXXX3896250
 |  |  |  |  |  |  |  |  |  | XXXX5609888 |  |  |  |  |  | XXXX5609888
Spreadsheet: 234417d1368097122-combined-data-from-2-sheet-to-1-sheet-test-file
Sheet: 3

For the month | Customer Name | Invoice No. | Committed effluent | Effluent Received | Total COD | Total Tanker | Total [NAME] | High TDS tanker | Effluent charges | [NAME] | Tanker charges | Analysis charges | Extra tratment charges | High TDS charges |  |  | A | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B | 15
2012-07-01 00:00:00 | B | Auto | 15 |  |  | 1 | 1 | 1 | =D12*total days of month |  |  |  | solved this later on.. | solved this later on.. |  |  | C | 20
This come from sheet 1 | This come from sheet 1 |  |  |  | This come from sheet 1 and sheet 2 combine | Count of Row | Count of Row but not include "empty" refer sheet 2 with blue color row | because of |  |  |  |  |  |  |  |  | D | 25
 |  |  |  |  |  |  |  |  | =+'2'!F12 |  |  |  |  |  |  |  | E | 30
 |  |  |  |  |  |  |  | above than 2500
Upper sheet will be shown as under after making formulas and data
For the month | Customer Name | Invoice No. | Committed effluent | Effluent Received | Total COD | Total Tanker | Total [NAME] | High TDS tanker | Effluent charges | [NAME] | Tanker charges | Analysis charges | Extra tratment charges | High TDS charges
2012-07-01 00:00:00 | B |  | 15 |  |  | 1 | 1 | 1 |  |  |  |  | 0
2012-07-01 00:00:00 | D |  | 25 |  |  | 1 | 1 | 0 |  |  |  |  | 0
Spreadsheet: 148649d1333492156-error-in-spreadsheet-while-trying-to-find-averages-hourly-prod-rate
Sheet: Sheet1

I do not have the original file so I am making this up from the top of my head,  Apologies for the crude sheet |  |  |  |  |  |  |  |  | I would usually have a formula to work out the length of time for the shift minus breaks on the left.
shift a | start | 06:00:00 |  | break 1 | break 2 | break 3
 | finish | 14:15:00 |  | 20 | 30 | 15 |  | 7.1
shift b | start | 14:15:00 |  | 20 | 30 | 15 |  | 7.1
 | finish | 22:30:00
shift c | start | 22:30:00 |  | 20 | 30 | 15 |  | 7.1
 | finish | 06:30:00
[NAME] | 47 |  | [NAME] | 47 |  | [NAME] | 47
Units produced | 299 |  | Units produced | 299 |  | Units produced | 299
hours worked |  |  | hours worked |  |  | hours worked
Shift Average |  |  | Shift Average |  |  | Shift Average
 | Daily Average
Spreadsheet: b33b510c-5a34-4573-887e-fd91ab4d2ecb
Sheet: Sheet1

The Boat Brokerage | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Western American Sales - Year to Date
 | Sailboats |  |  | Power Boats |  |  | High Performance
Region | < 20 Ft | 20 - 30 Ft | > 30 Ft | Fishing | Sport | Cruisers | Bowriders | Racing | Total
Alaska | 16820 | 26777 | 42334 | 23133 | 73006 | 101207 | 63151 | 234616 | 581044
British Columbia | 321838 | 225928 | 531174 | 311734 | 535316 | 1307950 | 547473 | 212294 | 3993707
Washington State | 125359 | 532256 | 848872 | 247654 | 346093 | 1104712 | 360997 | 165810 | 3731753
Oregon | 29886 | 37329 | 47569 | 47566 | 65815 | 146014 | 45423 | 292792 | 712394
California | 913773 | 1813208 | 2537414 | 3453589 | 3320656 | 3806515 | 2459212 | 3435901 | 21740268
Hawaii | 235157 | 454924 | 970081 | 226275 | 682838 | 759254 | 278727 | 211522 | 3818778
Mexico | 6579 | 12246 | 0 | 3251 | 56250 | 57295 | 28754 | 0 | 164375
Total Sales | 1649412 | 3102668 | 4977444 | 4313202 | 5079974 | 7282947 | 3783737 | 4552935 | 34742319
Spreadsheet: 812502d1673191778-number-of-days-passed-in-given-month-formula-daya-passed-in-month
Sheet: Sheet1

Dates | Day
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00 |  | Column A dates formatted for [NAME]  ->> "Mmm"
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
Spreadsheet: 103703d1301434122-insert-row-insert-rows
Sheet: Sheet1

175X105SELK | 1 | <put 1 here
175X105SELK | 1 | <put this formula =IF(A2=A1,B1,B1+1) in here
20X14KMWA70 | 2 | select b2 and use the fill handle to drag the formula down  to
20X14KMWA70 | 2 | v
225X13KM210 | 3 | v
225X13KM210 | 3 | v
24X16 FD755 | 4 | v
24X16 FD755 | 4 | v
25X14SELLICK | 5 | v
25X14SELLICK | 5 | v
25X14SELLICK | 5 | v
25X14SELLICK | 5 | v
25X14SELLICK | 5 | here
 | 1 | number down from here until it = last number ie b13 (5)
 | 2
 | 3
 | 4
 | 5
 | now select colums a and b and sort by column b