tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 130314d1322179984-vlookup-help-example-workbook
Sheet: CMTS NCP Index

 |  | 1 | 2 | 3 | 4 | 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 | 32
 | Service Groups | [NAME] | Primary Locator (Slice ID) | GEO & Sec Loc | [NAME] | MTC / STC | CMTS | CMTS IP Address | CMTS Card Information | CMTS Card Information | CMTS Card Information | CMTS Card Information | Headend | Modulation Scheme | Channel Width | DHCP Server IP | Service Group ID | [NAME] | Slot | Modulation Scheme | Channel Width | RF Gateway IP Address | Service Type | Network Element | Spa Interface ID #1 | Spa Interface ID #2 | Spa Interface ID #3 | Spa Interface ID #4 | QAM Frequency #1 | QAM Frequency #2 | QAM Frequency #3 | QAM Frequency #4 | [NAME]
 | 66 | [NAME] | 19 | NE - NK01 | 1234 Any Street | Northeast | NESTCMTK01 | 172.28.2.45 | C6/0/9 Upstream0 | C6/0/9 Upstream1 | C6/0/9 Upstream2 | C6/0/9 Upstream3 | 91 | 64 QAM | 3.2 MHz | 172.28.1.200 | 66 | NESTRFGC01 | 6/0 | 256 QAM | 6 MHz | 172.28.20.13 | DOCSIS | No Network Element | Modular-Cable6/1/1:10 | Modular-Cable6/1/1:11 | Modular-Cable6/1/1:12 | Modular-Cable6/1/1:13 | 855 MHz | 843 MHz | 849 MHz | 861 MHz | Not a Split Node
ALIACMTK01
CENTCMTK01
NESTCMTK01
SESTCMTK01
Spreadsheet: 600703d1543920358-return-value-of-column-and-row-that-has-exact-and-changing-name-example
Sheet: Sheet2

 | Name, Surname | Category | Years | Return value
 | 1 | 5 | 20
 | 2 | 3 | 15
 | 3 | 4 | 23
 | 4 | 7 | 14
 | 5 | 8 | 11
 | 6 | 13 | 5
 | 7 | 2 | 4
 | 8 | 2 | 20
 | 9 | 6 | 2
 | 10 | 4 | 1
Spreadsheet: 33911d1230827174-merging-rows-with-similar-information-addresses3
Sheet: Sheet2

[NAME] | Bloggs | 1Main Street | #N/A | [NAME] |  | #N/A |  |  | 100000 | 3
[NAME] | Bloggs | 1Main Street | 2 | Joe && Jane | [NAME] and [NAME] | 2 | [NAME] and [NAME] | [NAME] and [NAME] | 3 | 4
[NAME] | Cloggs | 2Main Street | #N/A | [NAME] | [NAME] | #N/A | [NAME] | [NAME] | 4 | 7
[NAME] | Floggs | 3Main Street | #N/A | [NAME] |  | #N/A |  |  | 100000 | 9
[NAME] | Floggs | 3Main Street | 5 | Jim && Joanne |  | 5 |  |  | 100000 | 12
[NAME] | Floggs | 3Main Street | 5 | Jim, Joanne && James | [NAME], [NAME] and [NAME] | 5 | [NAME], [NAME] and [NAME] | [NAME], [NAME] and [NAME] | 7 | 100000
[NAME] | Jones | 4Main Street | #N/A | [NAME] | [NAME] | #N/A | [NAME] |  | 100000 | 100000
[NAME] | Smith | 4Main Street | #N/A | [NAME] | [NAME] | 8 | [NAME] and [NAME] | [NAME] and [NAME] | 9 | 100000
[NAME] | [NAME] | 5Main Street | #N/A | [NAME] |  | #N/A |  |  | 100000 | 100000
[NAME] | [NAME] | 5Main Street | 10 | Jeff && Janet | [NAME] and [NAME] | 10 | [NAME] and [NAME] |  | 100000 | 100000
[NAME] | Murphy | 5Main Street | #N/A | [NAME] | [NAME] | 10 | [NAME] and [NAME] and [NAME] | [NAME] and [NAME] and [NAME] | 12 | 100000
Spreadsheet: 12bf1985-ceef-44dc-b430-17db67bb01c4
Sheet: EPA Clinical Benefits

FY13 FRINGE BENEFIT WORKSHEET - EPA with Clinical Benefits
Name:
FTE: |  | Enter a value between .50 and 1.00
Hired Prior to 7/1/96? | No | Select Yes or No
State or Optional Retirement? | State | Select State, Optional, or Not Applicable
Health Insurance? | Family | Select a value from Chart A
Life, [NAME], Supp Health, Dental - Dependents? | Ee and Dep | Select a value from Chart B
 |  |  |  |  |  |  |  | Chart A
Description | Object Code | Factor | [NAME] | Annual | Monthly | % Salary |  | Health Ins Reimb | Mthly Rate
 |  |  |  |  |  |  |  | Ee Only
Salary | 11XX, 13XX |  |  | 0 |  |  |  | Ee and Child
 |  |  |  |  |  |  |  | Ee and Spouse
BASIC BENEFITS |  |  |  |  |  |  |  | Family
 |  |  |  |  |  |  |  | Chart B
Social Security1 | 1812 |  |  |  |  |  |  | Supp Health | Mthly Rate
 |  |  |  |  |  |  |  | Ee Only
Medicare | 1813 |  |  |  |  |  |  | Ee and Dep
 |  |  |  |  |  |  |  | Chart C
State Retirement2 | 1822 |  |  |  |  |  |  | Dental Ins | Mthly Rate
 |  |  |  |  |  |  |  | Ee Only
Optional State Retirement3 | 187X |  |  |  |  |  |  | Ee and Dep
Health Insurance | 1832
Unemployment, workers compensation, etc . | 1892
Transit Tax | 3914
Communication Technologies Core Fee | 3225
Total Basic Benefits
CLINICAL BENEFITS
Health Insurance Reimbursement | 1802 | See Chart A
Professional Liability Insurance | 1803 | Enter Amount
Supplemental Retirement4 | 1804
Life Insurance5 | 1801
 |  | + Depend. [NAME].
Accidental Death & Dismemberment5 | 1801
 |  | + Depend. [NAME].
Disability | 1805
Supplemental Health | 1808 | See Chart B
Dental Insurance | 1808 | See Chart D
Total Clinical Benefits
TOTAL ALL BENEFITS
TOTAL COMPENSATION
NOTES:
1) Social Security:  CY2013 [NAME] maximum is $113,700
2) State and Optional Retirement:  $375,000 salary [NAME] if employed PRIOR to 07/01/96, $250,000 [NAME] if employed AFTER 07/01/96
3) Supplemental Retirement:  No salary [NAME] if employed PRIOR to 07/01/96, $250,000 [NAME] if employed AFTER 07/01/96
4) Life Insurance and AD&D:  Maximum salary is $250,000
5) Long Term Disability:  Maximum salary is $300,000
Spreadsheet: 760159d1640025858-vlookup-for-a-formula-result-test-bracket
Sheet: Bracket

 | Round 10 | Round 9 | Round 7 | Round 6 | Round 4 | Round 2 | Round 1 | Round 3 | Round 5 | Round 8 | Round 11
 |  |  |  |  |  |  | Game 1
 |  |  |  |  |  | Game 9 |  | Game 13
 |  |  |  |  | Game 17 |  | Game 2
 |  |  |  |  |  |  |  |  | Game 21
 |  |  |  |  | Loser of 16
 |  |  |  | Game 23 |  |  | Game 3
 |  |  |  |  |  | Game 10 |  | Game 14
 |  |  | Game 25 |  | Game 18 |  | Game 4
 |  |  |  |  |  |  |  |  |  | Game 27
 |  |  |  |  | Loser of 15
 |  |  |  |  |  |  | Game 5
 |  |  | Loser of 22 |  |  | Game 11 |  | Game 15
 |  | Game 29 |  |  | Game 19 |  | Game 6
 |  |  |  |  |  |  |  |  | Game 22 |  |  | Tournament Winner
 |  |  |  |  | Loser of 14
 |  |  |  | Game 24 |  |  | Game 7
 | Game 57 |  |  |  |  | Game 12 |  | Game 16
Winner of [NAME] |  |  |  |  |  |  |  |  |  |  | Winner of Losers bracket
 |  |  | Game 26 |  | Game 20 |  | Game 8
 |  |  |  |  | Loser of 15
 |  |  | Loser of 21
 | Loser of 27
Spreadsheet: 831645d1685796198-left-and-right-with-multiple-criterias-left-right
Sheet: Sheet1

 |  |  | When combined together
Colunm with Daa | IF(LEFT(A3,3)="008",RIGHT(A3,LEN(A3)-2)) | IF(RIGHT(A3,2)="-1",LEFT(A3,LEN(A3)-2)) | IF(LEFT(H2,3)="008",RIGHT(H2,LEN(H2)-2)),IF(RIGHT(H2,2)="-1",LEFT(H2,LEN(H2)-2))
[PHONE]
[PHONE]
[PHONE]
[PHONE]
[PHONE]
00577649-1
00577650-1
00577651-1
00577652-1
Spreadsheet: 83445534-72e4-4dbe-95ea-f93fd8bc1244
Sheet: Type of SEN and SEN status

 | DCSF:School Age Children with Special Educational Needs 2008 - 2009: an analysis
 | SA+ / Stmt Primary Total |  | SA+ / Stmt Sec Total |  | Special School Total |  | Total by %
 | 20.08 | 2009 by % | 2008 by % | 2009 by % | 2008 by % | 2009 by % | 2008 | 2009
Specific Learning Difficulty | 10.6 | 10.3 | 16.9 | 16.6 | 1 | 1 | 11.8 | 11.6
Moderate Learning Difficulty | 27.2 | 26.3 | 26.2 | 25.2 | 22.9 | 22.3 | 26.2 | 25.3
Severe Learning Difficulty | 1.7 | 1.6 | 1.1 | 1 | 23.7 | 23.6 | 4.4 | 4.3
Profound & Multiple Learning Difficulty | 0.4 | 0.4 | 0.1 | 0.1 | 8.4 | 8.5 | 1.4 | 1.4
Behaviour, Emotional & Social Difficulties | 18.6 | 18.5 | 30.6 | 30.6 | 14.9 | 14.7 | 22.7 | 22.8
Speech, Language and Communications Needs | 23.8 | 25.2 | 6.9 | 7.4 | 4.3 | 4.6 | 14.6 | 15.4
Hearing Impairment | 2.1 | 2.1 | 2.4 | 2.4 | 1.8 | 1.8 | 2.2 | 2.7
Visual Impairment | 1.2 | 1.3 | 1.3 | 1.5 | 1 | 0.9 | 1.2 | 1.2
Multi- Sensory Impairment | 0.2 | 0.2 | 0.1 | 0.1 | 0.2 | 0.2 | 0.1 | 0.1
Physical Disability | 4 | 4 | 3.4 | 3.3 | 5 | 4.6 | 3.9 | 3.8
Autistic Spectrum Disorder | 6.2 | 6.2 | 5.4 | 5.9 | 16 | 17.2 | 7.2 | 7.5
Other Difficulty/Disability | 3.9 | 3.9 | 5.6 | 6.1 | 0.7 | 0.6 | 4.1 | 4.4
 | % = % of all children SA+ and statements |  |  |  | Source: School Census Jan 2009
Spreadsheet: 198490d1354799164-problem-with-copying-vlookup-shytot-2
Sheet: Sheet1

 |  | ab |  |  |  |  |  |  |  | Result needs to be
 |  |  |  |  |  | 2012-01-01 00:00:00 |  |  |  | 21
 |  |  |  |  |  | 2012-01-02 00:00:00 |  |  |  | 22
 |  |  |  |  |  | 2012-01-03 00:00:00 |  |  |  | 23
 |  |  |  |  |  | 2012-01-04 00:00:00 |  |  |  | 24
 |  |  |  |  |  | 2012-01-05 00:00:00 |  |  |  | 25
 |  |  |  |  |  | 2012-01-06 00:00:00 |  |  |  | 26
 |  |  |  |  |  | 2012-01-07 00:00:00 |  |  | etc | 27
 |  |  |  |  |  | 2012-01-08 00:00:00 |  |  |  | 28
 |  |  |  |  |  | 2012-01-09 00:00:00 |  |  |  | 29
 |  |  |  |  |  | 2012-01-10 00:00:00 |  |  |  | 30
 |  |  |  |  |  | 2012-01-11 00:00:00 |  |  |  | 31
 |  |  |  |  |  | 2012-01-12 00:00:00 |  |  |  | 32
 |  |  |  |  |  | 2012-01-13 00:00:00 |  |  |  | 33
 |  |  |  |  |  | 2012-01-14 00:00:00 |  |  |  | 34
 |  |  |  |  |  | 2012-01-15 00:00:00 |  |  |  | 35
 |  |  |  |  |  | 2012-01-16 00:00:00 |  |  |  | 36
 |  |  |  |  |  | 2012-01-17 00:00:00 |  |  |  | 37
 |  |  |  |  |  | 2012-01-18 00:00:00 |  |  |  | 38
 |  |  |  |  |  | 2012-01-19 00:00:00 |  |  |  | 39
 |  |  |  |  |  | 2012-01-20 00:00:00 |  |  |  | 40
 |  |  |  |  |  | 2012-01-21 00:00:00 |  |  |  | 41
 |  |  |  |  |  | 2012-01-22 00:00:00 |  |  |  | 42
 |  |  |  |  |  | 2012-01-23 00:00:00 |  |  |  | 43
 |  |  |  |  |  | 2012-01-24 00:00:00 |  |  |  | 44
 |  |  |  |  |  | 2012-01-25 00:00:00 |  |  |  | 45
 |  |  |  |  |  | 2012-01-26 00:00:00 |  |  |  | 46
 |  |  |  |  |  | 2012-01-27 00:00:00 |  |  |  | 47
 |  |  |  |  |  | 2012-01-28 00:00:00 |  |  |  | 48
 |  |  |  |  |  | 2012-01-29 00:00:00 |  |  |  | 49
 |  |  |  |  |  | 2012-01-30 00:00:00 |  |  |  | 50
 |  |  |  |  |  | 2012-01-31 00:00:00 |  |  |  | 51
 |  |  |  |  |  | 2012-02-01 00:00:00 |  |  |  | 52
 |  |  |  |  |  | 2012-02-02 00:00:00 |  |  |  | 53
 |  |  |  |  |  | 2012-02-03 00:00:00 |  |  |  | 54
 |  |  |  |  |  | 2012-02-04 00:00:00 |  |  |  | 55
 |  |  |  |  |  | 2012-02-05 00:00:00 |  |  |  | 56
 |  |  |  |  |  | 2012-02-06 00:00:00 |  |  |  | 57
Spreadsheet: 880177d1727795944-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-example-1-4
Sheet: Sheet1

Range# (A) | Start Date (B) | End Date (C) | Expected count (D) | Current Duration (F) |  | Windknife |  | Dynamic range
1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2
2 | 2024-06-04 00:00:00 | 2024-06-10 00:00:00 | 8 |  |  | 8
3 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00 | 15 |  |  | 15
4 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 17 |  |  | 19
5 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 23 |  |  | 25
6 | 2024-07-28 00:00:00 | 2024-08-05 00:00:00 | 26 |  |  | 26
7 | 2024-08-20 00:00:00 | 2024-08-23 00:00:00 |  |  |  | 13
8 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 |  |  |  | 13
9 | 2024-08-23 00:00:00 | 2024-08-28 00:00:00 |  |  |  | 16
10 | 2024-09-20 00:00:00 | 2024-09-23 00:00:00 |  |  |  | 8
11 | 2024-09-22 00:00:00 | 2024-09-24 00:00:00 |  |  |  | 8
12 | 2024-07-01 00:00:00 | 2024-07-03 00:00:00 |  |  |  | 15
Spreadsheet: 165515d1341253999-excel-2007-help-setting-up-inventory-management-revised-test-inventory
Sheet: SCANNED COUNT

BARCODE | COUNT | [NAME] in this column needs dragging down to your required number of rows.
123456789022 | 2
123456789023 | 5
123456789024 | 4
123456789025 | 3
123456789026 | 2
123456789027 | 1
123456789028 | 44
123456789001 | 54
123456789002 | 2
123456789003 | 1
123456789004 | 1
123456789005 | 1
123456789006 | 1
123456789007 | 1
123456789008 | 1
123456789009 | 1
123456789010 | 1
123456789011 | 1
Spreadsheet: scott_neal__37823__Load and Value Comparison
Sheet: Sheet1

Quantity Analysis (Bcf/yr)
 | Type | Old |  | New | Delta
 | Firm | 26.5 |  | 27.5
 | Interruptible | 0 |  | 1.8
 | Total
Note: | Load analysis will be forwarded to [NAME] for review
Value Analysis ($[NAME])
 | Type | Year 1 |  | Cumulative | Year 2 | Cumulative
 | Firm | -0.467 |  |  | 0.176
 | Interruptible | -0.314 |  |  | -0.317
 | Industrial | -0.778 |  |  | -0.778
 | Transco FS | -0.698 |  |  | -0.698
 | Total
Notes: | (1) The Firm Year 1 value decreased due to an increase in market area storage encumbrance
 | and a decrease in Winter/Summer spreads
 | (2) The Firm Year 2 value increased because the increased market area storage encumbrance
 | was more than offset in an increase in Winter/Summer spreads
 | (3) Interruptible load is estimated to be approximately 5,000 Dth/d at a relatively high load factor
 | and priced at the current GPA Tier pricing
 | (4) The Industrial decrease is offset ($ for $) by the credit that VNG will realize from its releases
 | (5) Year 3 values are not available at this time and will be provided as needed
Margin Sharing and AGLES/VNG Impact ($[NAME])
 | Type | AGLES Share % |  | AGLES Value Impact Year 1 | AGLES/VNG Net Impact Year 1 | Cumulative AGLES/VNG Net Impact Year 1 |  | AGLES Value Impact Year 2 | AGLES/VNG Net Impact Year 2 | Cumulative AGLES/VNG Net Impact Year 2
 | Firm | 0.7
 | Interruptible | 0.7
 | Industrial | 1 |  |  | 0 |  |  |  | 0
 | Transco FS | 1
 | Total
Spreadsheet: 824642d1680728108-formula-to-compare-two-dates-does-not-work-testforum
Sheet: Sheet1

 | Employee | Employee 1 |  | Date Assigned | From (Date Assigned) |  | To (Date of Task End)
 |  | Employee 2
 |  | All
 | Matter # | Task Description | Assigned Date | In Progress Date | "Waiting 4 Someone Else" Date | Deadline | Compliant?
 | 1234 | djfsnfasn | 2023-03-10 00:00:00 | 2023-03-12 00:00:00 | 2023-03-14 00:00:00 | 2023-03-13 00:00:00
 | 6667 | fhdfhdh | 2023-03-10 00:00:00 | 2023-03-11 00:00:00 | 2023-03-11 00:00:00 | 2023-03-11 00:00:00
Spreadsheet: 390807d1429770501-need-help-converting-values-into-dates-am-despirate-customer_sandy
Sheet: Customer detail info

Address code | Creation date | Creation month | Change from prospect date | 1st Order date | 1st Invoice date | creation date copy | change from prospect date copy | 1st order copy | 1st invoice date copy
OMCO IAS | 2011-03-04 00:00:00 |  |  | 19/04/11 | 26/04/11
AEROSTAR BAC | 2014-06-23 00:00:00
AXX BRA | 2014-01-17 00:00:00 |  |  | 10/04/14 | 18/04/14
AXOTECH BRA | 2014-02-12 00:00:00 |  |  | 12/02/14 | 14/02/14
IPO SOF | 2014-04-29 00:00:00
SELW ODO | 2014-04-29 00:00:00
FLEX  SAS | 2014-04-29 00:00:00
OSL ROM | 2015-03-18 00:00:00 |  | 23/03/2015 | 23/03/15 | 10/04/15
Spreadsheet: 271149d1381846007-finance-count-if-meet-criteria-example1
Sheet: Jan 13

 | Location |  |  |  |  |  |  |  |  |  |  |  |  | Donation
691594 | Chesterfield | 2013-08-29 00:00:00 | 2013-09-10 00:00:00 |  | 2013-09-10 00:00:00 | E-600 |  |  |  |  |  |  |  | 20
692372 | Matlock | 2013-08-30 00:00:00 | 2013-09-14 00:00:00 |  | 2013-09-16 00:00:00 | E-509 |  |  |  |  |  |  |  | 10
691788 | [NAME] | 2013-09-02 00:00:00 | 2013-11-12 00:00:00 |  |  | E-532
692373 | Long Eaton | 2013-09-02 00:00:00 | 2013-09-06 00:00:00 |  | 2013-09-06 00:00:00 | E-032 |  |  |  |  |  |  |  | 10
740179 | Ripley | 2013-09-02 00:00:00 | 2013-10-21 00:00:00 |  |  | [NAME] |  |  |  |  |  |  |  | 35
740309 | [NAME] | 2013-09-04 00:00:00 | 2013-11-04 00:00:00 |  |  | E-538 |  |  |  |  |  |  |  | 10
691598 | Matlock | 2013-09-05 00:00:00 | 2013-09-12 00:00:00 |  | 2013-09-12 00:00:00 | E-273
691599 | Chesterfield | 2013-09-05 00:00:00 | 2013-09-19 00:00:00 |  | 2013-09-18 00:00:00 | E-253 |  |  |  |  |  |  |  | 10
691600 | [NAME] | 2013-09-05 00:00:00 | 2013-09-26 00:00:00 |  |  | E-108 |  |  |  |  |  |  |  | 30
692376 | Chesterfield | 2013-09-05 00:00:00 | 2013-09-12 00:00:00 |  | 2013-09-17 00:00:00 | E-470 |  |  |  |  |  |  |  | 10
Spreadsheet: 877916d1724851734-index-and-match-function-not-working-help-aop-per-tech
Sheet: Apr

TECH | HOURS | AVG-PER DAY | OBJ RATE | % OF TOTAL HOURS | OBJECTIVE |  |  | Column1 | Column2
THOAI LE, | 471.48 |  |  |  |  |  |  | AOP $ | 1136735
[NAME], | 434.21 |  |  |  |  |  |  | ELR | 155.7
[NAME], | 408.15 |  |  |  |  |  |  | AOP HOURS | 8871
DIEGO MERCADO, | 399.5 |  |  |  |  |  |  | WORKING DAYS | 24
[NAME], | 378.04
ANZOR KHATAEV, | 341.22 |  |  |  |  |  |  | TOTAL HOURS | 7929.37
TRAVIS GREGORY, | 333.41
MASON SHAWN, | 328.45
[NAME], | 279.98
TYLER MUNGER, | 257.84
RYAN GUAGENTI, | 257.66
FLORES GUARDADO, | 244.82
[NAME], | 242.79
GIANCARLO PACHECO, | 241.35
SHANE GILLESPIE, | 234.36
[NAME], | 231.37
TYLER BIXLER, | 226.62
SIMON NELSON, | 217.96
[NAME], | 212.57
[NAME], | 199.81
CHASE FRY, | 196.3
[NAME], | 193.7
COELLO VALLEJO, | 190.1
SHAWN GROOVER, | 186.62
GUARDADO RODAS, | 177
[NAME], | 155.8
[NAME], | 154.15
GILBERTO GALENOCAMPOS, | 136.8
[NAME], | 123.14
[NAME], | 115.7
[NAME], | 112.1
[NAME], | 87.1
WYLIE ROWE, | 71.1
DONOVAN OCONNOR, | 62.6
[NAME], | 31.5
[NAME], | 22.7
[NAME], | 17.6
Spreadsheet: 874034d1720602929-vlookup-to-get-data-from-another-sheet-nljd20240624
Sheet: BE

Rijlabels | tot match | omschrijving | Som [NAME] 2021 | Som van verkocht 2022 | Som van verkocht 2023 | Som van verkocht 2024 | DSO [NAME] | verpakking | vervanger | agrc | [NAME] | kru | [NAME] | ole | sombr | stock cobe | stock vina | stat 4 maand |  | Weight
AH229639 |  |  |  |  |  |  |  | 4 | #N/A |  |  |  |  |  |  | #N/A | 4 | #N/A
32167 |  |  |  |  |  |  |  | 2 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
32169 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
AH229563 |  |  |  |  |  |  |  | 10 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
4003725 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
4420565 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
AH229470 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
50039135 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
50040405 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
811913900 |  |  |  |  |  |  |  | 1 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
03H1468 |  |  |  |  |  |  |  | 10 | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
03H1515 |  |  |  |  |  |  |  | 50 | #N/A | 0 | 0 | 190 | 0 | 412 | 0 | #N/A | #N/A | 1
03H1540 |  |  |  |  |  |  |  | 50 | #N/A | 0 | 0 | 0 | 0 | 39 | 0 | #N/A | #N/A | 0
03H1558 |  |  |  |  |  |  |  | 50 | #N/A | 0 | 0 | 0 | 0 | 26 | 0 | #N/A | #N/A | 0
03H1657 |  |  |  |  |  |  |  | 5 | #N/A | 0 | 3 | 0 | 0 | 0 | 0 | #N/A | 4 | 0
Eindtotaal | Eindtotaal |  | 69128.59499999999 | 60793.81599999999 | 81944.43149999999 | 46471.51125 | #N/A | #N/A | #N/A |  |  |  |  |  |  | #N/A | #N/A | #N/A
Spreadsheet: 840806d1692996240-sum-up-columns-based-on-specific-dates-test-34-ans
Sheet: Sheet1

Equipment Code | WO Number | WO Description | WO Priority | WO Status | Odometer | Start Date | Finish date | Total Downtime |  |  | Start Date | Finish Date | Total downtime
VL1 |  | SAFETY INSPECTION | P3 | Not Shown |  | 2022-04-11 00:00:00 | 2022-04-11 00:00:00 | 0 |  |  | 2023-08-01 00:00:00 | 2023-08-24 00:00:00
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72294 | 2022-04-12 07:30:00 | 2022-04-12 08:30:00 | 0.9999999999417923 |  |  | 2022-04-01 00:00:00 | 2022-04-30 00:00:00
VL1 |  | HEADLIGHT (BULB) REPLACED | P1 | Completed | 72477 | 2022-04-18 07:20:00 | 2022-04-18 07:50:00 | 0.5000000000582077 |  |  | 2022-04-20 00:00:00 | 2022-05-23 00:00:00
VL1 |  | SAFETY INSPECTION | P3 | Completed | 72790 | 2022-04-26 07:45:00 | 2022-04-26 08:45:00 | 1.000000000116415
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73223 | 2022-05-09 08:01:00 | 2022-05-09 09:01:00 | 1.000000000116415
VL1 |  | SAFETY INSPECTION | P3 | Completed | 73641 | 2022-05-23 15:35:29 | 2022-05-23 16:35:54 | 1.006944444437977
VL1 |  | ACCIDENT DAMAGE | P1 | Waiting Parts |  | 2022-06-05 10:00:00 |  | 10708.77714444447
Spreadsheet: 865237d1712297009-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy
Sheet: Income Input

INCOME INPUT SCREEN
 | Enter Name for Applicant One |  |  |  |  |  |  | Enter Name for Applicant Two
 |  | Annual Income: |  | 80000 |  |  |  |  |  | Annual Income: |  | 150000
 |  | Income Tax: |  |  |  |  |  |  |  | Income Tax:
 |  | [NAME]: |  |  |  |  |  |  |  | [NAME]:
 |  | Medicare Levy %: |  | 0.02 |  |  |  |  |  | Medicare Levy %: |  | 0.02
 |  | Tax Payable: |  |  |  |  |  |  |  | Tax Payable:
2025 |  |  | The tax year from 1 July 2024 to 30 June 2025 |  |  |  |  |  |  |  |  |  |  |  | stage 3 tax cuts updated
2024-25 Tax Year |  |  |  | This is the latest 2024-25 tax schedule
 |  |  | Taxable income |  |  |  | Tax on this income
 |  |  | From | To |  |  |  |  |  |  |  |  | LITO | LMITO |  |  | Scratch Pad |  | Annual | Month | Week
 |  |  | 0 | 18200 |  |  | Nil |  |  | 0 | 0 |  |  |  |  |  | Income
 |  |  | 18201 | 45000 |  |  | 16c for each $1 over $18,200 |  |  | 0 | 0.16
 |  |  | 45001 | 135000 |  |  | $4,288 plus 30c for each $1 over $45,000 |  |  | 4288 | 0.3 |  |  |  |  |  | Tax + medicare
 |  |  | 135001 | 190000 |  |  | $31,288 plus 37c for each $1 over $135,000 |  |  | 31288 | 0.37 |  |  |  |  |  | Offsets & credits
 |  |  | 190001 | above ** |  |  | $51,638 plus 45c for each $1 over $190,000 |  |  | 51638 | 0.45 |  |  |  |  |  | TIDs/WH | 0
 |  |  |  |  |  |  |  | False |  | <<medicare tick condition |  |  |  |  |  |  | Franking | 0
 |  |  |  |  |  |  |  |  |  |  | Rounded A1>> |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Offsets | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other | 0
2025 |  |  | The tax year from 1 July 2024 to 30 June 2025 |  |  |  |  |  |  |  |  |  |  |  | stage 3 tax cuts updated |  | Subtotal
2024-25 Tax Year |  |  |  | This is the latest 2024-25 tax schedule
 |  |  | Taxable income |  |  |  | Tax on this income
 |  |  | From | To |  |  |  |  |  |  |  |  | LITO | LMITO |  |  | Income after tax
 |  |  | 0 | 18200 |  |  | Nil |  |  | 0 | 0
 |  |  | 18201 | 45000 |  |  | 16c for each $1 over $18,200 |  |  | 0 | 0.16
 |  |  | 45001 | 135000 |  |  | $4,288 plus 30c for each $1 over $45,000 |  |  | 4288 | 0.3
 |  |  | 135001 | 190000 |  |  | $31,288 plus 37c for each $1 over $135,000 |  |  | 31288 | 0.37
 |  |  | 190001 | above ** |  |  | $51,638 plus 45c for each $1 over $190,000 |  |  | 51638 | 0.45
 |  |  |  |  |  |  |  | True |  | <<medicare tick condition
 |  |  |  |  |  |  |  |  |  |  | Rounded A1>>
INCOME BREAK DOWN INCLUDING TAX OFFSETS
 |  |  |  | Annual |  | Monthly |  | F/Nightly |  | Weekly
 |  |  |  | Tax + Medicare |  |  |  | Adjusted Tax Payable
 |  |  |  | Deductions From INVs
 |  |  |  | Annual |  | Monthly |  | F/Nightly |  | Weekly
 |  |  |  | Tax + Medicare |  |  |  | Adjusted Tax Payable
 |  |  |  | Deductions From INVs
Spreadsheet: 297993d1392664635-quick-way-to-find-and-highlight-several-hundred-rows-of-data-and-add-data-to-new-column-realsamplelinkedcontracts
Sheet: Sheet1

CURRENT SPREADSHEET
Contract # | Linked Contract # | [NAME] | Data 1 | Data 2 | Data 3
12345 |  | ABC Contracting | xxxxx | yyyyy | zzzzz
8000 |  | Apostrophe Printing | xxxxx | yyyyy | zzzzz
11111 |  | [NAME] | xxxxx | yyyyy | zzzzz
33333 |  | GHI Restaurant Supply | xxxxx | yyyyy | zzzzz
9000 |  | Semicolon Music Supply | xxxxx | yyyyy | zzzzz
60606 |  | JKL Hospital | xxxxx | yyyyy | zzzzz
123123 |  | MNO and Sons Plumbing | xxxxx | yyyyy | zzzzz
70070 |  | PQR, Attorneys at Law | xxxxx | yyyyy | zzzzz
7000 |  | Comma Automotive Repair | xxxxx | yyyyy | zzzzz
1234567 |  | STU Airlines | xxxxx | yyyyy | zzzzz
777777 |  | VWX Telecomunications | xxxxx | yyyyy | zzzzz
3000 |  | Question Mark Fitness Center | xxxxx | yyyyy | zzzzz
10101 |  | YZ and Company | xxxxx | yyyyy | zzzzz
20002 |  | Exclamation Point Industries | xxxxx | yyyyy | zzzzz
WHAT I WANT SPREADSHEET TO LOOK LIKE
Contract # | Linked Contract # | [NAME] | Data 1 | Data 2 | Data 3
12345 | 67890 | ABC Contracting | xxxxx | yyyyy | zzzzz
8000 |  | Apostrophe Printing | xxxxx | yyyyy | zzzzz
11111 | 22222 | [NAME] | xxxxx | yyyyy | zzzzz
33333 | 44444, 55555 | GHI Restaurant Supply | xxxxx | yyyyy | zzzzz
9000 |  | Semicolon Music Supply | xxxxx | yyyyy | zzzzz
60606 | 70707 | JKL Hospital | xxxxx | yyyyy | zzzzz
123123 | 456456 | MNO and Sons Plumbing | xxxxx | yyyyy | zzzzz
70070 | 80080, 90090 | PQR, Attorneys at Law | xxxxx | yyyyy | zzzzz
7000 |  | Comma Automotive Repair | xxxxx | yyyyy | zzzzz
1234567 | 8989898 | STU Airlines | xxxxx | yyyyy | zzzzz
777777 | 888888, 999999 | VWX Telecomunications | xxxxx | yyyyy | zzzzz
3000 |  | Question Mark Fitness Center | xxxxx | yyyyy | zzzzz
10101 | 20202 | YZ and Company | xxxxx | yyyyy | zzzzz
20002 | 30003, 40004, 50005 | Exclamation Point Industries | xxxxx | yyyyy | zzzzz