tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730089d1619541186-sum-row-with-different-criterias-sum-with-monthly
Sheet: Sheet1

 |  |  |  | WEST LONDON ALLIANCE
District | Week Ending | 2020-10-30 00:00:00 | 2020-11-06 00:00:00 | 2020-11-13 00:00:00 | 2020-11-20 00:00:00 | 2020-11-27 00:00:00 | 2020-12-04 00:00:00 | 2020-12-11 00:00:00 | 2020-12-18 00:00:00 | 2020-12-25 00:00:00 | 2021-01-01 00:00:00 | 2021-01-08 00:00:00 | 2021-01-15 00:00:00 | 2021-01-22 00:00:00 | 2021-01-29 00:00:00 | 2021-02-05 00:00:00 | 2021-02-12 00:00:00 | 2021-02-19 00:00:00
West | XCCFV B | 17 | 107 | 103 | 51 | 26 | 18 | 31 | 26 | 26 | 107 | 103 | 51 | 26 | 18 | 31 | 107 | 103
North | Barnet | 7 | 17 | 12 | 22 | 15 | 8 | 2 | 11 | 20 | 17 | 12 | 22 | 15 | 8 | 2 | 17 | 12
West | Ealing | 26 | 87 | 64 | 66 | 41 | 37 | 45 | 36 | 27 | 87 | 64 | 66 | 41 | 37 | 45 | 87 | 64
West | Fulham | 41 | 66 | 24 | 14 | 15 | 22 | 10 | 14 | 18 | 66 | 24 | 14 | 15 | 22 | 10 | 66 | 24
West | Harlesden | 8 | 50 | 37 | 37 | 64 | 51 | 4 | 15 | 26 | 50 | 37 | 37 | 64 | 51 | 4 | 50 | 37
West | [NAME] | 47 | 74 | 71 | 60 | 56 | 48 | 13 | 9 | 5 | 74 | 71 | 60 | 56 | 48 | 13 | 74 | 71
West | [NAME] | 35 | 48 | 91 | 71 | 51 | 43 | 9 | 10 | 11 | 48 | 91 | 71 | 51 | 43 | 9 | 48 | 91
North | Hendon | 18 | 20 | 36 | 42 | 43 | 28 | 23 | 13 | 3 | 20 | 36 | 42 | 43 | 28 | 23 | 20 | 36
West | Hounslow | 48 | 71 | 60 | 40 | 51 | 48 | 57 | 34 | 11 | 71 | 60 | 40 | 51 | 48 | 57 | 71 | 60
West | [NAME] | 3 | 48 | 105 | 57 | 40 | 41 | 5 | 13 | 21 | 48 | 105 | 57 | 40 | 41 | 5 | 48 | 105
West | Uxbridge | 45 | 37 | 65 | 62 | 35 | 24 | 14 | 7 | 0 | 37 | 65 | 62 | 35 | 24 | 14 | 37 | 65
West | Wembley | 44 | 90 | 86 | 112 | 90 | 91 | 56 | 70 | 84 | 90 | 86 | 112 | 90 | 91 | 56 | 90 | 86
 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00
Barnet
Spreadsheet: 673341d1587320175-show-value-if-between-multiple-date-ranges-example-signups
Sheet: Signups per day

 | Date
Client | 2020-01-01 00:00:00
1 | Show signs ups per day if between start and end of sign up period
Spreadsheet: 216916d1361919729-problem-with-functional-argument-testworkbook
Sheet: sheet 1

 |  | Data Source |  |  |  | Compliance Test |  |  |  |  | Contact
Number | DoC | abc | JS | CORD A | CORD B | A | CORD | WA | DS | Location | Name | Phone | [NAME] | Match_#
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This entire row should be blank, returning no value in any of the cells from sheet 2.  I believe the problem lies with the functional argument in column O of sheet 2 but I can't find it.
Spreadsheet: 859254d1707719962-conference-room-calendar-sample
Sheet: Sheet1

 |  |  |  | Scheduler
 |  |  |  | Room No. | Date | Time From | Time To | Requested By | Remarks ( FOR)
 |  |  |  | R1 | 2024-02-06 00:00:00 | 12:30:00 | 13:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 09:00:00 | 14:00:00 | JCKL | MEETING
 |  |  |  | R2 | 2024-02-06 00:00:00 | 14:00:00 | 14:30:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 10:00:00 | 14:00:00 | JCKL | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 08:00:00 | 12:00:00 | RSPM | MEETING
 |  |  |  | R1 | 2024-02-06 00:00:00 | 13:00:00 | 14:00:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 09:30:00 | 10:00:00 | RYR | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 07:30:00 | 11:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 08:00:00 | 12:00:00 | CVSP | MEETING
 |  |  |  | R1 | 2024-02-07 00:00:00 | 07:00:00 | 08:00:00 | CVSP | MEETING
 |  |  |  |  |  |  |  |  |  | Calendar
 |  |  |  |  |  |  |  |  |  | 2024-02-06 00:00:00 | 2024-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  | • R1 08:00AM to 12:00PM - RSPM MEETING | • R1 07:30AM to 11:00AM - CVSP MEETING
 |  |  |  |  |  |  |  |  |  | • R1 09:00AM to 02:00PM - JCKL MEETING | • R1 08:00AM to 12:00PM - CVSP MEETING
 |  |  |  |  |  |  |  |  |  | • R1 10:00AM to 02:00PM - JCKL MEETING | • R1 09:30AM to 10:00AM - RYR MEETING
 |  |  |  |  |  |  |  |  |  | • R1 12:30PM to 01:00PM - CVSP MEETING
 |  |  |  |  |  |  |  |  |  | • R2 02:00PM to 02:30PM - RYR MEETING
Spreadsheet: 476106d1471617617-fil-an-excel-sheet-automatically-test-for-pete
Sheet: Test 1

Test 1 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | total 2016/2019 | VAR 2016/2019 | VAR 2015/2019 | CAGR 2016/2019
Total Sales projection
PAM | 1
Market Share
Sales projection %
Organic sales W/o:      - Delta P      - Growth initiatives      - New offers | 1
Growth assumptions |  | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01 | 0.01
Organic Value
Organic sales including:      - Delta P
Delta P % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Delta P Value
Organic sales including:      - Delta P      - Growth initiatives
Growth initiatives %
Growth initiatives Value
Organic sales including:      - Delta P      - Growth initiatives      - New offers
New Offers %
New Offers Value
AAA | 0 | 0 | 1 | 2 | 3
AA | 0 | 0 | 2 | 3 | 4
Total initiatives
111 | 0 | 0.46 | 5.5 | 7.02 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78 | 7.78
11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1 | 0 | 0 | 0 | 2.98 | 8.07 | 0 | 0 | 0 | 0 | 0 | 0
Total New Products
Spreadsheet: 274545d1383146822-compare-two-colums-and-list-differences-in-a-seperate-column-server-compare
Sheet: Sheet1

server list 1 | server list 2 | servers in list 1 but not in list 2
a | a | h
b | b | i
c | c
d | d
e | e
f | f
g | g
h
i
Spreadsheet: 12312ba1-a151-44c4-99ec-eecadfdfd95e
Sheet: Residential

Home Value |  | 300000
 |  | 2012  UNINCORPORATED DEKALB TAXES
Taxing | Gross | Standard | Net | Millage | Tax | HOST | Net Tax
Authority | Assess | Exemption | Assess |  |  | Credit | Due
County Operations |  | 10000 |  | 0.01043
Hospital |  | 10000 |  | 0.00094
Fire |  | 10000 |  | 0.00325
Police |  | 10000 |  | 0.00379
STD-Unincorporated |  | 10000
County Bonds |  | 0 |  | 0.0007 |  | 0
Parks Bonds |  | 0 |  | 0.00172 |  | 0
Total County
School Operations |  | 12500 |  | 0.02398 |  | 0
State Taxes |  | 2000 |  | 0.0002 |  | 0
Stormwater & Streetlights |  |  |  |  |  |  | 98
Total Taxes
 |  | 2012 COUNTY & DECATUR TAXES
Taxing | Gross | Standard | Net | Millage | Tax | HOST | Net Tax
Authority | Assess | Exemption | Assess |  |  | Credit | Due
County Operations |  | 10000 |  | 0.01043
Hospital |  | 10000 |  | 0.00094
STD-Decatur |  | 10000
County Bonds |  | 0 |  | 0.0007 |  | 0
Parks Bonds |  | 0 |  | 0.00172 |  | 0
Total County
Decatur |  | 20000 |  | 0.01158 |  | 0
[NAME] |  | 0 |  | 0.00142 |  | 0
School Operations |  | 0 |  | 0.0209 |  | 0
State Taxes |  | 2000 |  | 0.0002 |  | 0
Stormwater |  |  |  |  |  |  | 75
Total Taxes
Spreadsheet: 481786d1474643593-how-to-write-a-macros-to-compare-to-columns-and-match-amounts-but-this-is-a-bit-more-tricky-ap-ar-balancing-test
Sheet: Sheet4

-120451.83 |  | -120451.83
-52242 |  | -52242
-39825.71 |  | -39825.71
-27377.87 |  | -27375.83 | -2.039999999997235 | CAD REBATE  SIP1013076 OFF VARIANCE
-24541.83 |  | -24541.83 | 0
-24519.96 |  | -24519.96 | 0
-24264.9 |  | -24264.9 | 0
-24213.42 |  | -24213.42 | 0
-23523.75 |  | -23523.75 | 0
-23478.48 |  | -23478.48 | 0
-21082.18 |  | -21082.18 | 0
-17157 |  | -17157 | 0
-10712.17 |  | -10712.17 | 0
-10350 |  | -10350 | 0
-10148.45 |  | -10148.45 | 0
-9459.66 |  | -9459.66 | 0
-7495.08 |  | -7495.08 | 0
-2000 | -2600 | -7325 | 2725 | not applied
-7100 |  | -7100 | 0
-5822.19 |  | -5822.19 | 0
-5625.39 |  | -5625.39 | 0
-1331.27 | -4082.93 | -5414.2 | 0
-4268.72 |  | -4268.72 | 0
 |  |  | 0
-4054.28 |  | -4054.28 | 0
-3680 |  | -3680 | 0
-3477 |  | -3477 | 0
-3122.96 |  | -3122.96 | 0
 |  | -3065 | 3065 | not applied
-3063 |  | -3063 | 0
-2774.01 |  | -2774.01 | 0
 |  | -2731 | 2731
-2720.64 |  | -2720.64 | 0
-2660.52 |  | -2660.52 | 0
-2636.09 |  | -2636.09 | 0
 |  |  | 0
-2585.69 |  | -2585.49 | -0.2000000000002728
-2584.84 |  | -2584.84 | 0
-2308 |  | -2308 | 0
-2080 |  | -2080 | 0
-2000 |  | -2000 | 0
-2000 |  | -2000 | 0
-2000 |  | -2000 | 0
-2000 |  | -2000 | 0
-2000 |  | -2000 | 0
 |  |  | 0
-1959.98 |  | -1959.98 | 0
-1883 |  | -1883 | 0
-1691.78 |  | -1691.78 | 0
-1672.63 |  | -1672.63 | 0
-1669 |  | -1669 | 0
-1600 |  |  | -1600
-1500 |  | -1500 | 0
-1466.37 |  | -1466.37 | 0
-1408 |  | -1408 | 0
-1387.44 |  | -1387.44 | 0
-1367 |  | -1367 | 0
-1351 |  | -1351 | 0
 |  | -1315.86 | 1315.86
-1250.22 |  | -1250.22 | 0
-1238.98 |  | -1238.98 | 0
-1125 |  |  | -1125
 |  | -1000 | 1000
-941.71 |  | -941.71 | 0
-922.72 |  | -922.72 | 0
-909.23 |  | -909.23 | 0
-864.08 |  | -864.08 | 0
-826 |  | -826 | 0
-803 |  | -803 | 0
 |  | -651.41 | 651.41
-640.42 |  | -640.42 | 0
-606.01 |  | -606.01 | 0 |  | 0
-579 |  | -579 | 0
-551.16 |  | -551.16 | 0
-500 |  | -500 | 0
-500 |  | -500 | 0
-387.5 |  | -387.5 | 0
-350.03 |  | -350.03 | 0
-317.2 |  | -317.2 | 0
-203.44 |  | -203.44 | 0
-200 |  | -200 | 0
-144 |  | -144 | 0
Spreadsheet: 199121d1355095284-excel-populating-a-calendar-excel-20help-20upload-207-20dec-202012-1-
Sheet: Inputs

 | Product | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  | [NAME] 3
 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 2 | 2 | 2 | 2 | 2 | 2 |  | 3 | 3 | 3 | 3 | 3 | 3 |  | 4 | 4 | 4 | 4 | 4 | 4
 |  | Volume | SMS Order | SMS M.facture | SMS Ship | SMS [NAME] | SMS Test/Sell |  | Volume | Bulk 1 Order | Bulk 1 M.facture | Bulk 1 Ship | Bulk 1 Arrival | Bulk 1 Sell |  | Volume | Bulk 2 Order | Bulk 2 Mfacture | Bulk 2 Ship | Bulk 2 Arrival | Bulk 2 Sell |  | Bulk 3 Volume | Bulk 3 Order | Bulk 3 Mfacture | Bulk 3 Ship | Bulks 3 Arrival | Bulk 3 Sell
 | Product 1 | 100 | 2012-12-10 00:00:00 | 2012-12-15 00:00:00 | 2013-01-05 00:00:00 | 2013-01-25 00:00:00 | 2013-02-04 00:00:00 |  | 10000 | 2013-03-10 00:00:00 | 2013-03-14 00:00:00 | 2013-03-21 00:00:00 | 2013-04-05 00:00:00 | 2013-04-10 00:00:00
 | Product 2 | 120 |  |  |  |  |  |  | 4000
 | Product 3 | 300 |  |  |  |  |  |  | 4500
 | Product 4 | 100 |  |  |  |  |  |  | 14000
 | Product 5 | 50 |  |  |  |  |  |  | 3800
 | Product 6 | 80 |  |  |  |  |  |  | 8000
 | Product 7 | 30 |  |  |  |  |  |  | 9000
 | Product 8
 | Product 9
 | Product 10
 | Product 11
 | Product 12
 | Product 13
 | Product 14
 | Product 15
 | Product 16
 | Product 17
 | Product 18
 | Product 19
 | Product 20
 | Product 21
 | Product 22
 | Product 23
 | Product 24
 | Product 25
 | Product 26
 | Product 27
 | Product 28
 | Product 29
 | Product 30
 | Product 31
 | Product 32
 | Product 33
 | Product 34
 | Product 35
 | Product 36
 | Product 37
 | Product 38
 | Product 39
 | Product 40
 | Product 41
 | Product 42
 | Product 43
 | Product 44
 | Product 45
 | Product 46
 | Product 47
 | Product 48
 | Product 49
 | Product 50
Spreadsheet: 134216d1325095643-nested-if-statement-lender-pricing-worksheet
Sheet: Pricing Matrix

 |  | Variable Rate Pricing Matrix
 |  | Risk Rating | 1 |  |  | 2 |  |  | 3 |  |  | 4 |  |  | 5 |  |  | 6
 |  | [NAME] | Index | Rate | Floor | Index | Rate | Floor | Index | Rate | Floor | Index | Rate | Floor | Index | Rate | Floor | Index | Rate | Floor
 |  | 0-50M | 0.0025 |  | 0.04 | 0.0075 |  | 0.0425 | 0.0125 |  | 0.045 | 0.0175 |  | 0.05 | 0.03 |  | 0.05 | 0.0375 |  | 0.05
 |  | 51M-150M | 0.0025 |  | 0.04 | 0.0075 |  | 0.0425 | 0.01 |  | 0.045 | 0.015 |  | 0.0475 | 0.02 |  | 0.0475 | 0.0275 |  | 0.05
 |  | 151M-500M | 0.0025 |  | 0.04 | 0.005 |  | 0.0425 | 0.0075 |  | 0.045 | 0.0125 |  | 0.045 | 0.015 |  | 0.045 | 0.025 |  | 0.05
 |  | 501M-1,000M | 0 |  | 0.04 | 0.005 |  | 0.04 | 0.005 |  | 0.045 | 0.0075 |  | 0.045 | 0.015 |  | 0.045 | 0.025 |  | 0.05
 |  | 1,001M-2,500M | 0 |  | 0.04 | 0.0025 |  | 0.04 | 0.005 |  | 0.0425 | 0.005 |  | 0.045 | 0.0075 |  | 0.045 | 0.02 |  | 0.05
 |  | 2,501M+ | 0 |  | 0.04 | 0 |  | 0.04 | 0.0025 |  | 0.0425 | 0.00375 |  | 0.0425 | 0.005 |  | 0.045 | 0.015 |  | 0.05
 |  | WSJP= | 0.0325
Spreadsheet: 82667d1282694727-drop-down-list-returning-values-samplevlookup
Sheet: Sheet1

 |  |  |  | GEAR BOX
 |  |  |  | STEAM TURBINE |  | GEAR BOX | MODEL # | SERIAL# | GEAR TYPE | HOUSING MAT. | [NAME] | GEAR SERVICE FACTOR | GEAR RATED POWER | RATED INPUT SPEED | RATED OUTPUT SPEED
 |  |  |  | RECIPROCATING COMPRESSOR |  | STEAM TURBINE | MODEL # | SERIAL# | TYPE: | NUMBER OF STAGES | INLET STEAM PRES. | INLET STEAM TEMP. | EXHAUST PRES. | ROTN. FROM GOV. END | RATED SPEED | TRIP SPEED / RPM | INLET FLG SIZE/RATE | OUTLET FLG.SIZE/RATE
 |  |  |  | PUMP
 |  |  |  | FANS
 |  |  |  | CENTRIFUGAL COMPRESSOR |  | RECIPROCATING COMPRESSOR
 |  |  |  | BLOWER |  | PUMP
GEAR BOX | MODEL # |  |  |  |  | FANS
 | SERIAL# |  |  |  |  | CENTRIFUGAL COMPRESSOR
 | GEAR TYPE |  |  |  |  | BLOWER
 | HOUSING MAT.
 | [NAME]
 | GEAR SERVICE FACTOR
 | GEAR RATED POWER
 | RATED INPUT SPEED
 | RATED OUTPUT SPEED
Spreadsheet: 847263d1698273727-adjusting-a-unique-let-formula-to-add-an-additional-column-value-unique-values-test-04
Sheet: Sheet1

DATE | SHIFT | NAME | Number | Column5 | Column6 | Column7 | Column72 | Column722 | Column73 | Column74 | Column8 | Column1 | Column2 | Column4 | Column3 | AMOUNT |  | NAME | NUMBER | TRANS | TOTAL
 |  | JOE | 123 |  |  |  |  |  |  |  |  |  |  |  |  | 10 |  |  | 123 | 4 | 120
 |  | JOE | 123 |  |  |  |  |  |  |  |  |  |  |  |  | 15 |  | SUE | 456 | 2 | 90
 |  | SUE | 456 |  |  |  |  |  |  |  |  |  |  |  |  | 30 |  | MARK | 789 | 1 | 5
 |  | MARK | 789 |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | LISA | 12 | 1 | 20
 |  | LISA | 12 |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  | SUE | 456 |  |  |  |  |  |  |  |  |  |  |  |  | 60
 |  | JOE | 123 |  |  |  |  |  |  |  |  |  |  |  |  | 80
 |  | JOE | 123 |  |  |  |  |  |  |  |  |  |  |  |  | 15
Spreadsheet: 889794d1740712237-gantt-chart-mulitple-tasks-in-single-row-krackers-gantt-chart1
Sheet: Schedule

 |  |  | 2025-02-27 00:00:00
 | TASK | PROGRESS | START3 | END3 | [NAME] in Days (Start to Start) | DAYS
Do not delete this row. This row is hidden to preserve a formula that is used to highlight the curren day within the project schedule.
 | Some Repetitive Event 1 | 0 | 2025-03-01 00:00:00 |  | 15
 | Another repetitive event | 0 | 2025-02-17 00:00:00 | 2025-02-18 00:00:00 | 30
 | A one-time task | 0.2 | 2025-02-24 00:00:00 | 2025-03-24 00:00:00
Spreadsheet: eric_saibi__9839__100401R
Sheet: San Juan 04

Owner Name |  | New Mexico Public Service Company
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2001-10-02 00:00:00
End Date |  | 2001-10-04 00:00:00
Prv. Start Date |  | 2001-10-02 00:00:00
Prv. End Date |  | 2001-10-05 00:00:00
Comments |  | Unit was back online early in the morning.
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007773
Outage ID |  | 18570
Spreadsheet: 73817d1274380703-free-space-free-space-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Shelving unit A
Please Pick a shelf unit | Available Shelves |  |  | Step 2 |  |  |  |  |  |  |  |  | Shelving unit B
 |  |  |  | if you click on the unavailable button a list from sheet2 with cells that are only coloured should appear and then you can pick which cell(shelf) in b3 you want to reuse again.press the reuse button and it becomes available again and uncoloured.and disappears from unavailable list and back to shelving unit list |  |  |  |  |  |  |  |  | Shelving unit C
 | B4 04K |  |  |  |  |  |  |  |  |  |  |  | Shelving unit D
 | B5 10B (1/2 SHELF) |  |  |  |  |  |  |  |  |  |  |  | Shelving unit E
 | B6 05 (FULL SHELF) |  |  |  |  |  |  |  |  |  |  |  | Shelving unit F
 | B6 04N1 |  |  |  |  |  |  |  |  |  |  |  | Shelving unit G
 | B7 09 (FULL SHELF)
 | B7 08E
 | B7 05A |  |  | example if [NAME] (a3) shelf a2 04v) is coloured.it should appear in unavailable shelves button press list starting in sheet1 b5.you select it in b3 and press reuse its then uncoloured from sheet2 a3 and when you press shelving unit A button its there again
 | B7 05C
 | B7 04A
 | B7 04B
 | B7 04C | I was hoping for a better solution than vlookup to use in shelving unit buttons.i was hoping to poulate column B starting at b5 with all cells that are not coloured.
 | B7 04D
 | B7 04F |  |  | Step 3
 | B11 04A
 | B11 04B
 | B12 03 (1/2 SHELF) | Step 1
 | B12 02 (FULL SHELF)
 | B12 01 (FULL SHELF)
Spreadsheet: 148211d1333257085-i-need-help-with-volume-cuts-sheet-test-acc-cost-work-book
Sheet: Vol cuts

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | total
2" W/ TRACK
2" W/ TRACK
STD W TRACK
STD W TRACK
CEILING TRACK
CEILING TRACK
W/O TRACK
W/O TRACK
ADJ/F TRACK
ADJ/F TRACK
F/ P BUT
F/ P BUT
HD L/LOCK
HD L/LOCK
HD/HD LOCK
HD/HD LOCK
F/C/M RAIN/G
F/C/M RAIN/G
STARTER
STARTER
1X2.5 AGL
1X2.5 AGL
1X4 AGL
1X4 AGL
EA/ AGL
EA/ AGL
Spreadsheet: 848232d1698998197-formula-to-determine-if-a-text-ar-to-be-added-sample2-6-aligw
Sheet: Sheet1

 |  |  | S/No | Date | CAR Number | Expected Result | [NAME] | Changes using Table 2 |  | S/No | Imp Date | CAR Number1 |  | Imp Date | CAR Number1 | CAR Number2
 |  |  | 1 | 2023-12-12 00:00:00 | 7 | 07 AR |  |  |  | 1 | 2023-11-03 00:00:00 | 9 |  | 2023-11-03 00:00:00 | 9 | T9
 |  |  | 2 | 2023-10-02 00:00:00 | T7 | 07 |  |  |  | 2 | 2023-11-03 00:00:00 | T9 |  | 2023-11-03 00:00:00 | 7 | T7
 |  |  | 3 | 2023-10-15 00:00:00 | 7 | 07 |  |  |  | 3 | 2023-11-03 00:00:00 | 7 |  | 2023-12-12 00:00:00 | 10 | T10
 |  |  | 4 | 2023-11-03 00:00:00 | 7 | 07 AR |  |  |  | 4 | 2023-11-03 00:00:00 | T7 |  | 2023-12-10 00:00:00 | 23 | T23
 |  |  | 5 | 2023-11-03 00:00:00 | T7 | 07 AR |  |  |  | 5 | 2023-12-12 00:00:00 | 10
 |  |  | 6 | 2023-10-07 00:00:00 | 9 | 09 |  |  |  | 6 | 2023-12-12 00:00:00 | T10
 |  |  | 7 | 2023-10-04 00:00:00 | T9 | 09 |  |  |  | 7 | 2023-12-10 00:00:00 | 23
 |  |  | 8 | 2023-11-05 00:00:00 | T10 | 10 |  |  |  | 8 | 2023-12-10 00:00:00 | T23
 |  |  | 9 | 2023-12-01 00:00:00 | T7 | 07 AR
 |  |  | 10 | 2023-12-12 00:00:00 | 9 | 09 AR
 |  |  | 11 | 2023-11-03 00:00:00 | 23 | 23
 |  |  | 12 | 2024-01-01 00:00:00 | 23 | 23 AR
 |  |  | 13 | 2023-12-13 00:00:00 | 10 | 10 AR
 |  |  | 14 | 2023-12-14 00:00:00 | T10 | 10 AR
 |  |  | 15 | 2023-11-03 00:00:00 | T10 | 10
 |  |  | 16 | 2023-12-04 00:00:00 | 5 | 05
Spreadsheet: 472343d1469545866-find-a-name-in-a-list-instead-of-absolute-reference-test-file-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Last | Complete | Valid
[NAME] |  |  |  |  |  |  | J Smith | United J Smith
United J Smith |  |  |  |  |  |  | Duck | [NAME] Golden Duck
[NAME] 11-7 |  |  |  |  |  |  | Jordan | [NAME]
[NAME] |  |  |  |  |  |  | [NAME] | [NAME]
[NAME] Golden Duck |  |  |  |  |  |  | Zimmer | [NAME]
[NAME]
Spreadsheet: 686435d1594625462-find-and-returns-value-of-a-table-from-multiple-criteria-sample-3
Sheet: Sheet2

Generate Statement
For | Mark | <- Input of Customer to Generate Statement
Statement
Row Number | Date | Debit | Credit | Balance
Spreadsheet: 154946d1336619331-excel-2007-vacation-accruals-help-please-vlooktrueexample
Sheet: Sheet1

Days | Word |  |  | Days | Word | <<This is the Lookup Tabel
20 |  |  |  | 1 | Current
40 |  |  |  | 31 | Month Over
60 |  |  |  | 61 | Two Over
80 |  |  |  | 91 | Three Over
100 |  |  |  | 180 | Way Over
200 |  |  |  | 1000 | Not Close
500
1
5
31
91
Change any of the values in Col A and watch word change in Col B
Spreadsheet: 150632d1334629366-if-sheet1-cell-contains-specific-text-copy-text-from-different-sheet1-cell-to-sheet2-forum-example
Sheet: Sheet1

Priority | Group(s) | Name | Start Date | Finish Date | Resources
2 | PD | [NAME] | 2012-06-01 00:00:00 | 2012-10-15 00:00:00 | Academic
 | PD | ECE |  |  | Academic
1 | PD | ALT |  |  | [NAME]
 |  | EDL |  |  | [NAME]
1 |  | New |  |  | [NAME]
 |  | Carryover from 2011 |  |  | [NAME]
3 |  | Redev |  |  | Holly
 | LD | GED |  |  | [NAME]
 |  | Assets |  |  | Justin
1 | PD | Assessments |  |  | [NAME]
 | CQI | Mobile |  |  | Scott
2 |  | Usability |  |  | [NAME]
Spreadsheet: 222164d1363779561-data-auto-fill-from-sheet2-and-sheet3-to-sheet1-ef378a_select_records
Sheet: Sheet1

 | C.E.T.P. CHARGES BREAK UP
Customer Name : |  | Famy Care Ltd.
For the month of: |  | January | 2013
Sr. No. | Date | Manifest No. | Total Tanker | Total COD PPM | Total [NAME] | Total Tanker Rs. | Total Testing of Tanker Rs. | Total COD per Rs. |  | Match_row_Sh2 | Date | Match_row_Sh3
Spreadsheet: 542332d1507810246-formatting-latitude-and-longitude-numbers-s666vnumber-sandbox-sheet-latlong-diff
Sheet: Worksheet

 | latitude | longitude | Cleansed latitude | Cleansed longitude
[NAME] | 51.5252891 | -0.3194179 | 51.52530662 | -0.3193723
Loc2 | 51.4937169 | -0.1922681 | 51.49370229 | -0.19223323
Loc3 | 51.4616404 | -0.11585 | 51.46162452 | -0.11573601
Loc4 | 55.9492892 | -3.2180392 | 55.94930497 | -3.21805529
Loc5 | 55.9492892 | -3.2180392 | 55.94929521 | -3.21800433
Loc6 | 51.4833781 | -0.1856391 | 51.48338395 | -0.18564044
Loc7 | 51.4868038 | -0.2814827 | 51.48681549 | -0.28146929
Loc8 | 51.493007 | -0.2361278 | 51.49276652 | -0.23609293
Loc9 | 51.48033 | -0.258152 | 51.492753 | -0.23610961
Loc10 | 51.429274 | -0.170543 | 51.42927985 | -0.17053629
Loc11 | 51.4926399 | -0.1935221 | 51.49264449 | -0.19355227
Loc12 | 51.591244 | -0.0063247 | 51.59122984 | -0.0063475
Loc13 | 51.5083203 | -0.2061731 | 51.50972759 | -0.20679805
Loc14 | 53.64127 | -1.7977349 | 53.64120481 | -1.79791997
Loc15 | 51.6495303 | -0.0513738 | 51.64954777 | -0.05144354
Loc16 | 51.424418 | -0.334577 | 51.424418 | -0.334577
Loc17 | 50.5556074 | -3.5041805 | 50.55599508 | -3.50322161
Loc18 | 51.540692 | -1.915547 | 51.54067865 | -1.91552018
Loc19 | 51.5064885 | -0.1462095 | 51.5064885 | -0.1462095
Loc20 | 51.4922815 | -0.1922825 | 51.49227065 | -0.19235492
[NAME] | 50.7125814 | -1.9746151 | 50.71255338 | -1.9745239
[NAME] | 53.117281 | -2.798331 | 53.10489659 | -2.77811787
Loc23 | 51.4157273 | -0.3790132 | 51.4157273 | -0.3790132
Loc24 | 51.4620218 | -0.2257446 | 51.46363272 | -0.2298913
Loc25 | 52.74713 | 0.4357897 | 52.74712351 | 0.43618398
Loc26 | 51.5306325 | -0.0935696 | 51.53058077 | -0.09363666
Spreadsheet: 74073d1274691191-only-displaying-rows-with-values-example
Sheet: Sheet1

 | All Data
 | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2009-10-12 00:00:00 |  | 2009-10-13 00:00:00 |  | 2009-10-14 00:00:00 |  | 2009-10-15 00:00:00 |  | 2009-10-16 00:00:00 |  | 2009-10-17 00:00:00 |  | 2009-10-18 00:00:00
 | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code
Stage 1 – RIBA A-C | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Stage 2 – RIBA D | 0 |  | 2 |  | 1 |  | 6 |  | 2.5 |  | 0 |  | 0
Stage 3 – RIBA EFG | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Stage 4 – RIBA H-L | 0 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Desired Result
 | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 | 2009-10-12 00:00:00 |  | 2009-10-13 00:00:00 |  | 2009-10-14 00:00:00 |  | 2009-10-15 00:00:00 |  | 2009-10-16 00:00:00 |  | 2009-10-17 00:00:00 |  | 2009-10-18 00:00:00
 | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code | Hours | Code
Stage 2 – RIBA D | 0 |  | 2 |  | 1 |  | 6 |  | 2.5 |  | 0 |  | 0
Stage 4 – RIBA H-L | 0 |  | 3 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 15eeee22-a2d2-49c5-a6e3-95cf22d74731
Sheet: Summary Eje Cafetero

PRESUPUESTO ENTIDADES EJECUTORAS
EJE CAFETERO
Nombre Entidad Ejecutora:
Detalle | Presupuesto  Total | Tope Presupuestal
[NAME]
Monitoreo y Evaluación
[NAME] y [NAME]
Total Rubros de Funcionamiento
[NAME]
Total Destinación Específica
PRESUPUESTO TOTAL
XXXXXX
REPRESENTANTE LEGAL