tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677691d1589472693-search-multiple-columns-return-corresponding-value-search
Sheet: Sheet1

Tens | Color | Code | Hundreds | Color | Code | Thousand | Color | Code
10 | Red | 1R | 100 | Red-Yellow | 1RW | 1000 | Red-Green-Blue | 1RGB
20 | Blue | 2B | 200 | Blue-Red | 2BR | 2000 | Blue-Red-Green | 2BRG
30 | Green | 3G | 300 | Green-Indigo | 3GI | 3000 | Green-Indigo-Purple | 3GIP
40 | Orange | 4O | 400 | Orange-Blue | 4OB | 4000 | Orange-Blue-Red | 4OBR
50 | Purple | 5P | 500 | Purple-Orange | 5PO | 5000 | Purple-Orange-Yellow | 5POY
 | Search | 300
 | Return
 | Search | 4000
 | Return
 | Search | 20
 | Return
Spreadsheet: 148520d1333453393-rearrange-tables-rearrange-table_try4_jpr73
Sheet: PT

 |  |  |  |  |  |  |  |  |  |  |  | Rearrange tables
Type | Year | Valeur |  | Valeur | Type
A | 2007 | 19.1 |  | Year | A | B | C | D
 | 2008 | 16.1 |  | 2007 | 19.1 | 0.22 | 7.8 | 0.54
 | 2009 | 12.4 |  | 2008 | 16.1 | 0.07 | 7.7 | 0.35
 | 2010 | 13 |  | 2009 | 12.4 | 0.05 | 4.6 | 0.27
B | 2007 | 0.22 |  | 2010 | 13 | 1.22 | 5.1 | 0.23
 | 2008 | 0.07
 | 2009 | 0.05
 | 2010 | 1.22
C | 2007 | 7.8
 | 2008 | 7.7
 | 2009 | 4.6
 | 2010 | 5.1
D | 2007 | 0.54
 | 2008 | 0.35
 | 2009 | 0.27
 | 2010 | 0.23
Spreadsheet: 91832d1291506174-auto-range-from-user-input-book1
Sheet: Sheet1

 |  |  |  |  | CITY1
 |  | CITY: | CITY1 |  | CITY2
 |  |  |  |  |  |  |  |  |  |  |  | CITY 1 |  |  |  |  |  |  |  |  | CITY 1
 |  | MIN | 1 | 2 | 5 | 10 | 20 | 50 | 100 |  |  |  |  |  |  |  |  |  |  |  | CITY 2
 |  | 5 | 86.3 | 111 | 142 | 161 | 188 | 224 | 253 |  |  | 86.3 | 111 | 142 | 161 | 188 | 224 | 253 |  |  | 0
 |  | 6 | 80 | 103 | 132 | 150 | 175 | 209 | 236 |  |  | 80 | 103 | 132 | 150 | 175 | 209 | 236 |  |  | 0
 |  | 10 | 65.6 | 84.6 | 107 | 121 | 141 | 168 | 189 |  |  | 65.6 | 84.6 | 107 | 121 | 141 | 168 | 189 |  |  | 0
 |  | 20 | 48.9 | 62.7 | 78.2 | 87.9 | 101 | 120 | 134 |  |  | 48.9 | 62.7 | 78.2 | 87.9 | 101 | 120 | 134 |  |  | 0
 |  | 30 | 39.8 | 51 | 63.2 | 70.8 | 81.3 | 95.7 | 107 |  |  | 39.8 | 51 | 63.2 | 70.8 | 81.3 | 95.7 | 107
 |  | 60 | 26.3 | 33.6 | 41.5 | 46.3 | 53.1 | 62.3 | 69.6 |  |  | 26.3 | 33.6 | 41.5 | 46.3 | 53.1 | 62.3 | 69.6
 |  | 120 | 16.3 | 20.8 | 25.6 | 28.6 | 32.7 | 38.4 | 42.8 |  |  | 16.3 | 20.8 | 25.6 | 28.6 | 32.7 | 38.4 | 42.8
 |  | 180 | 12.1 | 15.4 | 19 | 21.1 | 24.2 | 28.4 | 31.7 |  |  | 12.1 | 15.4 | 19 | 21.1 | 24.2 | 28.4 | 31.7
 |  | 360 | 7.1 | 9.07 | 11.2 | 12.5 | 14.4 | 16.9 | 18.9 |  |  | 7.1 | 9.07 | 11.2 | 12.5 | 14.4 | 16.9 | 18.9
 |  | 720 | 4.17 | 5.36 | 6.7 | 7.54 | 8.7 | 10.3 | 11.6 |  |  | 4.17 | 5.36 | 6.7 | 7.54 | 8.7 | 10.3 | 11.6
 |  | 1440 | 2.44 | 3.17 | 4.08 | 4.66 | 5.45 | 6.55 | 7.44 |  |  | 2.44 | 3.17 | 4.08 | 4.66 | 5.45 | 6.55 | 7.44
 |  | 2880 | 1.37 | 1.82 | 2.44 | 2.86 | 3.42 | 4.21 | 4.86 |  |  | 1.37 | 1.82 | 2.44 | 2.86 | 3.42 | 4.21 | 4.86
 |  | 4320 | 0.939 | 1.26 | 1.74 | 2.06 | 2.49 | 3.11 | 3.63 |  |  | 0.939 | 1.26 | 1.74 | 2.06 | 2.49 | 3.11 | 3.63
 |  |  |  |  |  |  |  |  |  |  |  | CITY 2
 |  | Wanting to have the ability for a user to add additional cities and data, then for it to be automatically made into
 |  | a range then added to the drop list to fill out the table….Possible? |  |  |  |  |  |  |  |  |  | 92.6 | 119 | 150 | 168 | 194 | 230 | 258
 |  |  |  |  |  |  |  |  |  |  |  | 86 | 111 | 139 | 157 | 181 | 214 | 240
 |  | Auto range from user input? |  |  |  |  |  |  |  |  |  | 70.6 | 90.6 | 113 | 127 | 147 | 173 | 194
 |  |  |  |  |  |  |  |  |  |  |  | 52.8 | 67.5 | 83.6 | 93.3 | 107 | 125 | 140
 |  |  |  |  |  |  |  |  |  |  |  | 43.2 | 55.1 | 67.9 | 75.6 | 86.3 | 101 | 112
 |  |  |  |  |  |  |  |  |  |  |  | 28.6 | 36.4 | 44.7 | 49.7 | 56.7 | 66.2 | 73.5
 |  |  |  |  |  |  |  |  |  |  |  | 17.5 | 22.3 | 27.5 | 30.6 | 35 | 41 | 45.6
 |  |  |  |  |  |  |  |  |  |  |  | 12.8 | 16.3 | 20.2 | 22.6 | 25.9 | 30.4 | 33.9
 |  |  |  |  |  |  |  |  |  |  |  | 7.35 | 9.43 | 11.8 | 13.3 | 15.3 | 18.1 | 20.3
 |  |  |  |  |  |  |  |  |  |  |  | 4.3 | 5.54 | 7.04 | 7.96 | 9.23 | 11 | 12.3
 |  |  |  |  |  |  |  |  |  |  |  | 2.6 | 3.37 | 4.32 | 4.91 | 5.73 | 6.85 | 7.74
 |  |  |  |  |  |  |  |  |  |  |  | 1.56 | 2.04 | 2.64 | 3.02 | 3.54 | 4.26 | 4.84
 |  |  |  |  |  |  |  |  |  |  |  | 1.11 | 1.44 | 1.89 | 2.18 | 2.55 | 3.08 | 3.51
Spreadsheet: 64708d1265512457-time-sheet-calculations-time-sheets-100-v2
Sheet: incidental

id | Total Incidental | 2010-01-01 00:00:00 | 2010-01-02 00:00:00 | 2010-01-03 00:00:00 | Dates are fixed as the entire year…. |  |  |  | 2010-12-31 00:00:00
101
102
103
104
105
106
107
108
ID's are fixed all employees are listed
 |  | Orginal formula without the IF wrap around it
 |  | INDEX(input!$A$1:$G$12,MATCH(incidental!$A2&"Incidental",input!$A$1:$A$12,0),MATCH(incidental!C$1,input!$A$1:$G$1,0))
Spreadsheet: 843656d1695446225-make-pivot-table-for-data-test-1-
Sheet: Source

RAT | region | Carriers |  |  | No  of sites |  |  |  |  |  | RAT |  |  |  | region | Carriers
2G/3G/4G/5G | X | L18F1/L18F2/L8F1 |  |  | Row Labels | Count of RAT |  | These will replace after remove L21and [NAME] |  |  | 2G | 3G | 4G | 5G | X | 3CC
2G/4G | Y | L18F1/L18F2/L8F1 |  |  | 2G/3G/4G | 8 |  | L18F1/L18F2/L8F1 | 3 CC |  | 2G | 4G |  |  | Y | 3CC
3G Only | Z | L18F1/L18F2/L8F1 |  |  | 2G/3G/4G/5G | 34 |  | L18F1/L8F1 | 2 CC |  | 3G Only |  |  |  | Z | 3CC
2G/3G/4G/5G | F | L18F1/L8F1 |  |  | 2G/4G | 5 |  | L8F1 | 1 CC |  | 2G | 3G | 4G | 5G | F | 2CC
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1 |  |  | 3G Only | 3 |  |  |  |  | 2G | 3G | 4G | 5G | Z | 3CC
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1 |  |  | 3G/4G | 1 |  |  |  |  | 2G | 3G | 4G | 5G | Z | 3CC
2G/3G/4G | Z | L18F1/L18F2 |  |  | 3G/4G/5G | 8
2G/3G/4G/5G | G | L18F1/L18F2/L8F1 |  |  | Grand Total | 59
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
2G/3G/4G/5G | Z | L18F1/L8F1/L23F1 |  |  |  |  |  |  | Row Labels | Count of  Carriers
2G/3G/4G | H | L8F1 |  |  | No  of sites in each region |  |  |  | A | 10
2G/3G/4G/5G | Z | L18F1 |  |  | Row Labels | Count of RAT |  |  | B | 1
2G/3G/4G/5G | Z | L18F1/L8F1 |  |  | A | 1 |  |  | C | 15
2G/3G/4G/5G | Z | L18F1/L8F1 |  |  | B | 1 |  |  | D | 1
2G/3G/4G/5G | Z | L8F1 |  |  | C | 1 |  |  | E | 1
2G/3G/4G | Z | L8F1/L9F1 |  |  | D | 1 |  |  | F | 2
3G/4G/5G | Z | L8F1 |  |  | E | 1 |  |  | G | 1
2G/4G | Z | L9F1 |  |  | F | 2 |  |  | H | 8
3G Only | D | L18F1/L18F2/L8F1/L23F1/L23F2 |  |  | G | 1 |  |  | R | 1
2G/3G/4G/5G | Z | L8F1 |  |  | H | 1 |  |  | X | 5
2G/3G/4G | Z | L18F1/L8F1 |  |  | R | 1 |  |  | Y | 1
2G/4G | Z | L9F1 |  |  | X | 1 |  |  | Z
3G Only | Z | L18F1/L8F1 |  |  | Y | 1
2G/3G/4G/5G | A | L8F1 |  |  | Z | 47
2G/3G/4G/5G | Z | L18F1/L8F1 |  |  | Grand Total | 59
2G/3G/4G/5G | C | L8F1
2G/4G | Z | L8F1
2G/3G/4G | Z | L8F1
2G/3G/4G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1/L23F1/L23F2
3G/4G/5G | B | L18F1/L18F2/L8F1
2G/3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G/5G | F | L18F1/L18F2/L8F1/L23F1
2G/3G/4G/5G | Z | L18F1/L8F1
2G/4G | Z | L9F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L8F1/L23F1/L23F2
2G/3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L18F1/L8F1/L23F1
3G/4G/5G | Z | L8F1
2G/3G/4G/5G | Z | L18F1
2G/3G/4G/5G | Z | L18F1/L8F1
2G/3G/4G | Z | L18F1/L18F2
2G/3G/4G/5G | Z | L8F1
2G/3G/4G | Z | L18F1/L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
3G/4G/5G | E | L18F1/L18F2/L8F1
3G/4G | Z | L8F1
3G/4G/5G | Z | L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
2G/3G/4G/5G | Z | L18F1/L18F2/L8F1
2G/3G/4G/5G | R | L18F1/L18F2/L8F1
3G/4G/5G | Z | L18F1/L8F1
3G/4G/5G | Z | L8F1
Spreadsheet: tracy_geaccone__40580__Plan_Distribution1
Sheet: Sheet1

ETS OPERATIONS-PHIL LOWRY
2001 PLAN
SUMMARY
( $ In Thousands)
Do not include allocated costs from ETS
Date Updated: January 2, 2001
 | Company 0179 NNG |  |  |  |  |  |  |  | Company  0060 TW |  |  |  |  |  |  |  | Company 0062/0536 FGT |  |  |  |  |  |  |  | Company 0142 NBPL |  |  |  |  |  |  |  | Company 0584 HPL |  |  |  |  |  |  |  | 2001 Plan
O&M PLAN |  |  | Project |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  | Project |  |  |  |  |  |  |  | Project
 |  |  | Specific |  | Overhead |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Specific |  | Overhead |  |  |  |  |  | Specific |  | Overhead
 | Gross |  | Capital |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net |  | Gross |  | Capital |  | Capital |  | Net
Department | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M |  | O & M
Field Operations |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 974.5 |  |  |  |  | 10053.1
VP | 7.798 |  | 0 |  | 0 |  |  |  | 0 |  | 0 |  | 0 |  |  |  | 133.2 |  | 0 |  | 38.147 |  |  |  | 0 |  | 0 |  | 0 |  |  |  | 74 |  | 0 |  | 0
Reallocate |  |  |  |  |  |  |  |  | 1131.1
Support Services
Ops Admn Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3679.2 |  | 104.9
Technical Services |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2072.9
Mechanical Services
Engineering & Const
Facility Planning
Materials Management |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 214.6
Safety Specialist
WGR
Overhaul Amortization
Other (Mgt fee, Accting)
IT
HPL/FGT
KN Reimbursements
Remediation | 400 |  |  |  |  |  |  |  | 900
[NAME]
PCB Testing - SoCal |  |  |  |  |  |  |  |  | 463
PCB Testing - PG&E |  |  |  |  |  |  |  |  | 1000
Financial Planning - Houston |  |  |  |  | 25.1 |  |  |  |  |  |  |  | 15.6 |  |  |  |  |  |  |  | 15.6 |  |  |  |  |  |  |  | 6.3
Total  O&M - Revised
Total  O&M - Orig. |  |  | 5499.1 |  | 5093.5 |  |  |  | 27454 |  | 1114.6 |  | 1535.9 |  |  |  | 32659.3 |  | 1843.5 |  | 2547.1 |  |  |  | 16019.8 |  | 104.9 |  |  |  |  |  | 13083.2 |  |  |  | 93.2
Variance from Orig
Spreadsheet: 859818d1708068133-compare-text-input
Sheet: RawData

Status | Text | SR Detail | Result | Remark
Not Started | ComplaintServiceDataER Mobile | Need Supportxxx | Y
Not Started | ComplaintServiceIR (Inter Roaming)ER Mobile | Support | N
Not Started | ComplaintServiceIR (Inter Roaming)ER Mobile | xxxxNeed supportxxx | Y
Not Started | ComplaintServiceDataER Mobile | Support | N
Not Started | ComplaintServiceSMSER Mobile | xxxxNeedSupportxxx | N
Not Started | ComplaintServiceIR (Inter Roaming)ER Mobile | xxxxNeedsupportxxx | Y
Spreadsheet: 843146d1695091028-formula-to-return-list-base-on-count-extra-row-in-formula
Sheet: Sheet1

 | Staff | Month |  |  | Staff | Month
 | JR | [NAME]
 | Jojo | Feb'23 |  |  | Jojo | [NAME]
 | [NAME] | Mar'23 |  |  | [NAME] | [NAME]
 | [NAME] |  |  |  | [NAME] | [NAME]
 | Holland |  |  |  | Holland | [NAME]
 | Beckham |  |  |  | Beckham | [NAME]
 |  |  |  |  | JR | Feb'23
 |  |  |  |  | Jojo | Feb'23
 |  |  |  |  | [NAME] | Feb'23
 |  |  |  |  | [NAME] | Feb'23
 |  |  |  |  | Holland | Feb'23
 |  |  |  |  | Beckham | Feb'23
 |  |  |  |  | JR | Mar'23
 |  |  |  |  | Jojo | Mar'23
 |  |  |  |  | [NAME] | Mar'23
 |  |  |  |  | [NAME] | Mar'23
 |  |  |  |  | Holland | Mar'23
 |  |  |  |  | Beckham | Mar'23
 |  |  |  |  |  |  | <---- how to get rid of this in my formula
Spreadsheet: 59731d1260304019-excel-2007-percentage-constants-while-dragging-cells
Sheet: Sheet1

1 | 1 | 2 | 3 | 4 | 5 | 6 |  | [NAME] over to the right, then down a few rows, then look over the cells to see how the range referred to is changed for each |  | 1
10 | 11
20 |  | 22
30 |  |  | 33
40 |  |  |  | 44
50 |  |  |  |  | 55
60 |  |  |  |  |  | 66
Drag each of B13 and B14 over to the right, and check the different outcomes for each dependant upon the $ location.
 |  |  |  |  |  |  |  | [NAME] to the right, this is one way to manually transpose from rows to columns with a formula reference
 | 1 |  |  |  |  |  |  |  |  | 1
 | 1
Spreadsheet: 49135d1248384783-copy-row-from-multiple-worksheets-based-on-column-value-in-to-summary-tab-sales-unpaid-solver
Sheet: June

Date | Company | Details | Invoice No. | Net Amount | VAT | Total | Paper Reference | Date Invoice Sent | Date Papment Received
2009-01-01 00:00:00 | SOI | Web Site Work | 23 | 200 | 43 | 243 | J1 | 2009-05-03 00:00:00 | 2009-05-17 00:00:00
2009-01-01 00:00:00 | KPMG | Accounting Work | 24 | 50 | 10.75 | 60.75 | J2 | F | Unpaid
2009-01-01 00:00:00 | SOI | Web Site Work | 25 | 200 | 43 | 243 | J1 | 2009-05-03 00:00:00 | 2009-05-17 00:00:00
2009-01-01 00:00:00 | KPMG | Accounting Work | 26 | 50 | 10.75 | 60.75 | J2 | G | Unpaid
Spreadsheet: 796925d1663630134-function-or-and-date-compare
Sheet: Sheet1

contact date | opp create date | have two column since 2020 onward
2020-05-26 00:00:00 | -
- | -
- | -
2020-07-27 00:00:00 | -
- | -
- | -
2018-09-10 00:00:00 | -
2020-02-03 00:00:00 | -
2022-01-12 00:00:00 | 2022-02-16 00:00:00
2020-01-15 00:00:00 | -
- | -
2019-08-13 00:00:00 | 2018-08-13 00:00:00
- | 2021-08-24 00:00:00
- | 2018-09-10 00:00:00
Spreadsheet: 770219d1645897113-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Total Members per Age Group

Starting Age | Ending Age | Total Members
13 | 19
20 | 29 |  |  | THIS NEEDS TO BE A UNIQUE COUNT OF MEMBERS BETWEEN THE AGE GROUPS
30 | 39
40 | 49 |  |  | THERE ARE TWO UNIQUE MEMBERS FOR 13-19
50 | 59
60 | 69 |  |  | THERE IS ONE UNIQUE MEMBER FOR 20-29
70 | 79
80 | 89
90 | 99999
Spreadsheet: 114340d1310090974-nested-ifs-or-array-logic_example
Sheet: Desc

Code | Description
100 | Thing 1
101 | Thing 2
102 | Thing 3
103 | Thing 4
104 | Thing 5
105 | Thing 6
106 | Thing 7
107 | Thing 8
108 | Thing 9
109 | Thing 10
110 | Thing 11
111 | Thing 12
200 | Thing 13
201 | Thing 14
202 | Thing 15
203 | Thing 16
204 | Thing 17
205 | Thing 18
206 | Thing 19
207 | Thing 20
208 | Thing 21
209 | Thing 22
210 | Thing 23
211 | Thing 24
Spreadsheet: 57517d1257743153-combine-multiple-sheet-data01
Sheet: RPP0124260

type | : | RPP0124260 | date | : | 2009-02-08 00:00:00
code | packet | des | vb | tax | deliv | price | qty | ttl
C | BEG700 | GLOS (x2) | 67 | 0 | 0 | 160 | 1 | 160
F | BFG700 | GLOS (x2) | 50 | 0 | 0 | 120 | 1 | 120
Total |  |  |  |  |  |  | 2 | 280
Spreadsheet: 676837d1589013351-time-stamp-overlap-between-two-columns-and-identify-such-rows-with-yes-date-and-time-overlap-between-two-rows
Sheet: Sheet1

Asset ID | Reg No | DriverKey | Date | Start Time | Stop Time | Overlap (Yes/No)
TM00246 | 1047BA | 8D00005A09038901 | 2020-05-03 | 00:04:08 | 20:15:49
PK01022 | 1091WA | 0E00001654BBD701 | 2020-05-03 | 13:34:50 | 14:36:42
PK00220 | 1103DK | 3800001B6CF1CB01 | 2020-05-03 | 17:10:19 | 17:21:36
[NAME] | 1113BK | EA00005A06065C01 | 2020-05-03 | 06:04:12 | 15:38:38
PM00055 | 1124MK | 8000005A09099C01 | 2020-05-03 | 04:00:00 | 04:00:00
TP00291 | 1139YM | BA000012C1322701 | 2020-05-03 | 06:13:21 | 06:13:34
TP00252 | 1144YM | C300005A0907C601 | 2020-05-03 | 03:59:23 | 18:05:34
TP00252 | 1144YM | 3000005A09043C01 | 2020-05-03 | 14:46:26 | 18:01:30
PK00188 | 1158DS | 8F00005A09039A01 | 2020-05-03 | 17:58:47 | 23:46:37
PK00188 | 1158DS | 5E00005A09037101 | 2020-05-03 | 16:53:50 | 17:21:27
PK00188 | 1158DS | 9900005A09075301 | 2020-05-03 | 09:37:42 | 15:22:25
PK00188 | 1158DS | 4500005A09022A01 | 2020-05-03 | 17:31:43 | 17:58:47
PK00188 | 1158DS | 1D00005A0903B501 | 2020-05-03 | 03:17:33 | 23:49:31
PK00188 | 1158DS | C100005A0903B101 | 2020-05-03 | 16:01:13 | 16:41:08
PK00188 | 1158DS | AE00005A09075201 | 2020-05-03 | 16:41:08 | 16:53:50
PK00188 | 1158DS | 4500005A09075701 | 2020-05-03 | [NAME] | [NAME]
PK00188 | 1158DS | 3700005A09082001 | 2020-05-03 | 02:17:28 | [NAME]
PK00188 | 1158DS | [NAME] | 2020-05-03 | 15:22:25 | 16:01:13
PK00630 | 1167YR | 2700005A03066401 | 2020-05-03 | 04:00:00 | 04:00:00
PK00689 | 1188YS | 890000165500D601 | 2020-05-03 | 04:00:00 | 04:00:00
PK00689 | 1188YS | C900001AA411E501 | 2020-05-03 | 09:11:40 | 09:31:03
PK00689 | 1188YS | 5A00001B6D5D7001 | 2020-05-03 | 13:34:00 | 13:38:47
PK00363 | 1193WK | C900001AA411E501 | 2020-05-03 | 15:04:17 | 15:12:07
PK00363 | 1193WK | 1E00001B6CE27501 | 2020-05-03 | 07:16:55 | 08:09:36
PK00363 | 1193WK | 140000164EC0D801 | 2020-05-03 | [NAME] | 07:16:55
PK00363 | 1193WK | 890000165500D601 | 2020-05-03 | 14:05:27 | 15:12:49
CR00044 | 1228B | BB00005A0908EE01 | 2020-05-03 | 22:49:55 | 23:59:59
CR00044 | 1228B | D700005A0308BD01 | 2020-05-03 | 12:50:56 | 16:04:44
FT00013 | 1232MH | 2F00005A09077301 | 2020-05-03 | 03:32:05 | 17:07:21
PM00399 | 1245WB | FA00005A0902C301 | 2020-05-03 | 05:57:50 | 20:18:08
TP00262 | 1250HA | EB00005A0901F501 | 2020-05-03 | 01:18:53 | 01:18:53
TP00262 | 1250HA | 4B00005A09025301 | 2020-05-03 | 01:18:53 | 05:27:42
TP00105 | 1255YB | 220000192A4E9D01 | 2020-05-03 | 08:23:35 | 10:44:27
TP00105 | 1255YB | 5A00001B6D5D7001 | 2020-05-03 | 08:23:15 | 16:06:29
TM00231 | 126AK | AA00005A0C022801 | 2020-05-03 | [NAME] | 16:26:29
TP00196 | 1313WB | 4B00005A09025301 | 2020-05-03 | 05:04:36 | 05:04:41
TP00196 | 1313WB | EB00005A0901F501 | 2020-05-03 | 19:45:25 | 19:54:32
TM00269 | 1320YR | 9800005A0905E401 | 2020-05-03 | 05:57:08 | 16:55:45
BS00089 | 1340DK | 8C00005A0908EF01 | 2020-05-03 | 07:26:32 | 07:26:40
BS00089 | 1340DK | FF00005A09071D01 | 2020-05-03 | 07:26:40 | 07:42:02
TM00187 | 1362MR | 8D00005A0901BB01 | 2020-05-03 | 00:00:00 | 23:59:59
Spreadsheet: 794685d1662215164-positions-of-numbers-within-a-range-within-range
Sheet: Within range

 |  |  | Numbers in ascending order
 | Position
 | 1 |  | 11 |  | In column D, there are numbers in ascending order
 | 2 |  | 13 |  | Their corresponding position counted from the first number are in column B.
 | 3 |  | 17
 | 4 |  | 31
 | 5 |  | 33
 | 6 |  | 38
 | 7 |  | 74
 | 8 |  | 79
 | 9 |  | 83
 | 10 |  | 96
 | 11 |  | 97
 | 12 |  | 115
 | Lower range |  | 20
 | Upper range |  | 90
 | [NAME] return position |  | 4 |  | We like a formula to return the position of the numbers that are within the yellow highlighted specific range
 |  |  | 5 |  | i.e., not lower than D27, and not higher than D28
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
Spreadsheet: 712173d1610096879-auto-filter-data-by-date-for-print-only-example
Sheet: Data

S# | Name of Product | Quantity | Date | Buyers | Transit Co. | Delivery Agency | Short Note
1 | Groceries | 600 | 2021-01-01 00:00:00 | [NAME] | SSL Trans. | Speedex | Driver picked up goods at 9 in the morning and eta is expected 6 o'clock in Noon.
2 | Hardware | 500 | 2021-01-01 00:00:00 | [NAME] | ACO Trans. | Leopard | Cargo was loaded at afternoon, delivery is expected to be completed within 12 hours.
3 | Clothes | 200 | 2021-01-01 00:00:00 | [NAME] | PQ Trans. | TCS | [NAME] reached picked up goods from Seattle Warhouse and goods will be delivered early next morning.
4 | Woods | 150 | 2021-01-02 00:00:00 | Abruzzi | [NAME]. | Royal Mail | Woods have been loaded and transit will be started after noon.
5 | Electronics | 750 | 2021-01-02 00:00:00 | [NAME] | SSL Trans. | Maersk | Goods are on way and driver is suggested to be careful because items are breakable, delivery will be delayed upto 4 hours.
6 | Beverage | 1050 | 2021-01-02 00:00:00 | Morgan | PQ Trans. | Speedex | Cargo has been loaded, during late night Goods will be reached to it's destination.
7 | Groceries | 600 | 2021-01-02 00:00:00 | [NAME] | SSL Trans. | Speedex | Driver picked up goods at 9 in the morning and eta is expected 6 o'clock in Noon.
8 | Hardware | 500 | 2021-01-02 00:00:00 | [NAME] | ACO Trans. | Leopard | Cargo was loaded at afternoon, delivery is expected to be completed within 12 hours.
9 | Clothes | 200 | 2021-01-03 00:00:00 | [NAME] | PQ Trans. | TCS | [NAME] reached picked up goods from Seattle Warhouse and goods will be delivered early next morning.
10 | Woods | 150 | 2021-01-03 00:00:00 | Abruzzi | [NAME]. | Royal Mail | Woods have been loaded and transit will be started after noon.
11 | Electronics | 750 | 2021-01-03 00:00:00 | [NAME] | SSL Trans. | Maersk | Goods are on way and driver is suggested to be careful because items are breakable, delivery will be delayed upto 4 hours.
12 | Beverage | 1050 | 2021-01-03 00:00:00 | Morgan | PQ Trans. | Speedex | Cargo has been loaded, during late night Goods will be reached to it's destination.
Spreadsheet: 74117d1274717988-excel-2007-need-a-formula-to-search-specific-worksheet-sample
Sheet: 9

SKU # | [NAME] | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE | AMOUNT | CODE DATE |  | Total
12456 | Chicken | 3 | 2010-05-17 00:00:00 | 11 | 2010-05-18 00:00:00
Spreadsheet: 102684d1300663535-grid-reference-conversion-to-latitude-and-longitude-utmconversions1
Sheet: Datums

 | Datum | a | b | f | 1/f |  | LatZones | Letter | S Bdy | 100K E | Letter E | 100K E | 100K N | Letter N | 100K N
1 | WGS 84 | 6378137 | 6356752.3142 | 0.00335281066474748 | 298.257223563 |  | -90 | A | -90 | 1 | A | 1 | 0 | V | 0
2 | NAD 83 | 6378137 | 6356752.3142 | 0.00335281066474748 | 298.257223563 |  | -84 | C | -84 | 2 | B | 2 | 1 | A | 1
3 | GRS 80 | 6378137 | 6356752.3141 | 0.003352810687509523 | 298.2572215381486 |  | -72 | D | -72 | 3 | C | 3 | 2 | B | 2
4 | WGS 72 | 6378135 | 6356750.5 | 0.003352782592403579 | 298.2597208258318 |  | -64 | E | -64 | 4 | D | 4 | 3 | C | 3
5 | Australian 1965 | 6378160 | 6356774.7 | 0.003352894878773786 | 298.2497322927458 |  | -56 | F | -56 | 5 | E | 5 | 4 | D | 4
6 | Krasovsky 1940 | 6378245 | 6356863 | 0.003352332812552669 | 298.2997380974651 |  | -48 | G | -48 | 6 | F | 6 | 5 | E | 5
7 | North American 1927 | 6378206.4 | 6356583.8 | 0.003390075303928791 | 294.9786982138982 |  | -40 | H | -40 | 7 | G | 7 | 6 | F | 6
8 | International 1924 | 6378388 | 6356911.9 | 0.003367010598916157 | 296.9993620815749 |  | -32 | J | -32 | 8 | H | 8 | 7 | G | 7
9 | Hayford 1909 | 6378388 | 6356911.9 | 0.003367010598916157 | 296.9993620815749 |  | -24 | K | -24 | 9 | J | 9 | 8 | H | 8
10 | Clarke 1880 | 6378249.1 | 6356514.9 | 0.00340754957344003 | 293.4660166925959 |  | -16 | L | -16 | 10 | K | 10 | 9 | J | 9
11 | Clarke 1866 | 6378206.4 | 6356583.8 | 0.003390075303928791 | 294.9786982138982 |  | -8 | M | -8 | 11 | L | 11 | 10 | K | 10
12 | Airy 1830 | 6377563.4 | 6356256.9 | 0.003340852715003978 | 299.3247788233638 |  | 0 | N | 0 | 12 | M | 12 | 11 | L | 11
13 | Bessel 1841 | 6377397.2 | 6356079 | 0.00334277438450912 | 299.1527052002488 |  | 8 | P | 8 | 13 | N | 13 | 12 | M | 12
14 | Everest 1830 | 6377276.3 | 6356075.4 | 0.003324444324295537 | 300.8021499087382 |  | 16 | Q | 16 | 14 | P | 14 | 13 | N | 13
How to Use This Spreadsheet |  |  |  |  |  |  | 24 | R | 24 | 15 | Q | 15 | 14 | P | 14
 |  |  |  |  |  |  | 32 | S | 32 | 16 | R | 16 | 15 | Q | 15
 |  |  |  |  |  |  | 40 | T | 40 | 17 | S | 17 | 16 | R | 16
 |  |  |  |  |  |  | 48 | U | 48 | 18 | T | 18 | 17 | S | 17
 |  |  |  |  |  |  | 56 | V | 56 | 19 | U | 19 | 18 | T | 18
 |  |  |  |  |  |  | 64 | W | 64 | 20 | V | 20 | 19 | U | 19
 |  |  |  |  |  |  | 72 | X | 72 | 21 | W | 21 | 20 | V | 20
 |  |  |  |  |  |  | 84 | Z | 84 | 22 | X | 22
 |  |  |  |  |  |  |  |  |  | 23 | Y | 23
 |  |  |  |  |  |  |  |  |  | 24 | Z | 24