tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 581550d1531374831-extract-data-to-another-data-sheet-production-report-new-copy
Sheet: DataBase

 |  |  |  |  |  |  |  |  | Production |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Damage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Machine Break Down |  |  |  |  |  |  |  |  | Production Delay |  |  |  |  |  |  | Lost Man Power Hrs |  |  |  |  |  |  |  | Transfer Tag #
 |  |  |  |  |  |  |  |  | Date | Assembly Line | Order # | Ø | Product Description | Time Duration |  | Total Prod. hrs. | Rest hrs. | Actual Prod. Hrs. | 36500 | Output / hr. | % | Remarks | Allocated | Print | Scrape | Cutting | Assembly |  |  |  |  |  |  |  |  |  |  | Assembly - Total | Assemby Damage % | Rusted, QC & Other | Upside Down | Total Rejects | % | Machine | Time Duration |  | Total BD. hrs. | Rest hrs. | Actual [NAME] | Loss Production | Reason for the B'down |  | Time Duration |  | Total Delay hrs. | Rest hrs. | Actual [NAME] | Loss Production | Reason for the [NAME] |  |  |  |  |  |  |  |  | Components |  |  | Body Blanks
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Start | Finish |  |  |  | Achieved Qty. |  |  |  |  |  |  |  | Notch | Rolling | Weld / Lock Seam | Powder | Beading / Inner Curling | Expand | Hammer | Neck-In | Flange | [NAME] | Seaming |  |  |  |  |  |  |  | Start | Finish |  |  |  |  |  |  | Start | Finish |  |  |  |  |  | Total | Present | Absence | Recruit | Resign | Late Present | Product Description | Loss Production | End | Ring | Lid
#N/A | 1 | #N/A | #N/A | 1 | #N/A | 1 | 1 | 1 | 2018-09-01 00:00:00 | General [NAME] 01 | 1234 | 111 | abche | 07:30:00 | 19:00:00 | 11.5 | 1.5 | 10 | 13500 | 1350 | 1 | * Order completed. | 10 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 99 | 0.007333333333333333 | 15 | 16 | 136 | 0.01007407407407407 |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 1012.5 |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759.375 |  | 64 | 60 | 5 | 1 | 2 | 2 |  | 12000
#N/A | 1 |  | #N/A | 1 |  | 2 | 1
#N/A | 1 |  | #N/A | 1 |  | 3 | 1 |  |  | General [NAME] 02 | 2345 | 222 | bcdef | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 6000 | 600 | 1.212121212121212 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759
#N/A | 1 |  | #N/A | 1 |  | 4 | 1
#N/A | 1 |  | #N/A | 1 |  | 5 | 1 |  |  | General [NAME] 03 | 3456 | 333 | cdefg | 07:30:00 | 19:00:00 | 11.5 | 1.5 | 10 | 3000 | 400 | 0.75 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0
#N/A |  |  | #N/A
#N/A | 1 | #N/A | #N/A | 1 | #N/A |  | 1 |  | 2018-09-02 00:00:00 | General [NAME] 01 | 4567 | 444 | defghi | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 6000 | 700 | 1.038961038961039 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
#N/A | 1 |  | #N/A | 1 |  |  | 1
#N/A | 1 |  | #N/A | 1 |  |  | 1 |  |  | General [NAME] 02 | 2345 | 222 | bcdef | 07:30:00 | 17:15:00 | 9.75 | 1.5 | 8.25 | 8000 | 850 | 1.140819964349376 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 08:15:00 | 09:15:00 | 1 | 0.25 | 0.75 | 759
Spreadsheet: 869566d1716182883-formula-to-populate-location-data-based-on-exported-data-and-a-seperate-data-table-formula-test-4-aligw
Sheet: Data Tables

Flight # | Line
80 | Tasmania
81 | New South Wales
82 | New South Wales
83 | Northern Territory
84 | Western Australia
85 | ACT
86 | South Australia
87 | Queensland
88 | Queensland
89 | Queensland
Spreadsheet: 159003d1338474648-conditional-formatting-example1-2-
Sheet: Sheet1

 | Valid for | 24 | 12 | 12 | 6 | 12 | 36 | 18 | 12 | 12
 | Staff Name | Course 1 | Course 2 | Course 3 | Course 4 | Course 5 | Course 6 | Course 7 | Course 8 | Course 9
 | Colleague 1 | 2005-03-24 00:00:00 | 2009-05-02 00:00:00 | 2011-01-10 00:00:00 |  |  |  | 2009-04-30 00:00:00 | 2010-10-19 00:00:00 | 2010-01-04 00:00:00
 | Colleague 2
 | Colleague 3
 | Colleague 4
 | Colleague 5
 | Colleague 6
 | Colleague 7
 | Colleague 8
 | Colleague 9
 | Colleague 10
 | Colleague 11 |  | 2010-11-02 00:00:00 | 2010-11-08 00:00:00 |  | 2011-06-01 00:00:00 |  | 2012-03-05 00:00:00 | 2010-10-25 00:00:00
 | Colleague 12
 | Colleague 13
 | Colleague 14
 | Colleague 15
 | Colleague 16
 | Colleague 17
 | Colleague 18
 | Colleague 19
Spreadsheet: 220484d1363179873-group-up-same-values-and-provide-total-sample-data1
Sheet: PROJECT BAY DETAIL

SALESMAN |  |  |  |  |  |  | Uprights |  | GREY
CUSTOMER/CONTACT |  |  |  |  |  | COLOURS | Bracing |  | GALV | GV
QUOTE/JOB NO |  |  |  |  |  |  | Beams |  | ORANGE
 | BAY TYPE A |  |  |  | BAY TYPE B |  |  |  | BAY TYPE C |  |  |  | BAY TYPE D |  |  |  | BAY TYPE E
 | Type |  |  |  | Type |  |  |  | Type |  |  |  | Type |  |  |  | Type
Frame Type/Height | 08 | 6000 |  |  | 08 | 5025 |  |  | 08 | 6000 |  |  | 08 | 5025
Frame Depth |  | 1100 |  |  |  | 1100 |  |  |  | 1100 |  |  |  | 1100
Bracing Pitch |  | 750 |  |  |  | 750 |  |  |  | 750 |  |  |  | 750
Spliced (Y/N)
Lower Section Type/Height
Upper Section Type/Height
Baseplate |  | STD |  |  |  | STD |  |  |  | STD |  |  |  | STD |  |  |  | STD
[NAME] |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE |  |  |  | SINGLE
Beam Type 1 - No. of Levels |  | 2 |  |  |  | 2 |  |  |  | 3 |  |  |  | 3
Beam Clear Entry |  | 2700 |  |  |  | 2700 |  |  |  | 2700 |  |  |  | 2700
Beam Type |  | C100S |  |  |  | C100S |  |  |  | C100S |  |  |  | C100S
[NAME] load (kgs) |  | 2500 |  |  |  | 2500 |  |  |  | 2500 |  |  |  | 2500
Beam Type 2 - No. of Levels
Beam Type
[NAME] (kgs)
No. of Pallets per bay
Number of row spacers | 600mm
Number of row spacers | 750mm
Number of row spacers
Number of row spacers
TOTAL NO. of Beam Levels
Spreadsheet: 807465d1669910743-help-with-formula-when-ref-a-data-table-in-a-different-column-help
Sheet: Sheet1

Data  A | Data B | doubler | input | location
 |  |  | 1 | A
 |  |  | 2 | B
 |  |  | 3 | C
 |  | X | 4 | D
 |  |  | 5 | E
 |  |  | 6 | F
 |  |  | 7 | G
 |  | X | 8 | H
 |  | X | 9 | I
 |  |  | 10 | J
 |  |  | 11 | K
 |  |  | 12 | L
Spreadsheet: 733582d1621630859-sort-arrange-linked-cells-which-have-forever-changing-values-scores
Sheet: Sheet1

Class 1 |  | Class 2 |  | Class 3 |  |  | Class 4 |  |  | Class 5
Test 1 | Test 2 | Test 1 | Test 2 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2
0.85 | 0.6 | 0.9 | 0.5 | 1 | 0.7 | 0.7 | 0.85 | 0.7 | 0.75 | 0.4 | 0.7
 |  |  | Class | Score
Spreadsheet: 735022d1622647234-merging-multiple-sheets-with-same-header-format-into-single-sheet-aggrigated-code-sheet
Sheet: 01 Groningen

Region | Disipline | Disiplinecode | Gemeente/Regionaal | Gebruiker
Groningen | MAX | 0400001 | Regionaal | Logistiek/Water (Noord)
Groningen | MAX | 0400002 | Regionaal | Logistiek/Water (West)
Groningen | MAX | 0400003 | Regionaal | Command Logistiek/Water) (Oost)
Groningen | FATE | 0402060 | Regionaal | Command Genees Fate
Groningen | FATE | 0402066 | Regionaal | [NAME] FATE
Groningen | FATE | 0402067 | Regionaal | FATE
Groningen | BERG | 0421101 | Dorkwerd | Platvoet
Groningen | BERG | 0421102 | Gemeente | Groningen
Groningen | BERG | 0421103 | Gemeente | Hurigariep
Groningen | BERG | 0421104 | Garnwerd | Reitdiep
Groningen | ZED | 0430112 | Regionaal | [NAME]
Spreadsheet: 154991d1336644020-how-to-populate-the-rows-with-top-five-records-rows-in-excel-2003-book2
Sheet: Sheet2

 | Clasiification | sub classification | category | value
 | orange | Navel | unsorted | 75 |  |  | Desired Outcome
 | orange | Navel | sort | 65 |  |  | Top 3 |  |  |  |  | Bottom 3
 | orange | Navel | High | 50 |  |  | Clasiification | sub classification | category | value
 | orange | Navel | dark | 45 |  |  | Orange | Navel | unsorted | 75
 | orange | Navel | Process | 42 |  |  |  |  | sort | 65
 | orange | Navel | Old | 36 |  |  |  |  | High | 50
 | orange | Navel | low | 34 |  |  |  | mandrin | unsorted | 80
 | orange | Navel | Light | 12 |  |  |  |  | High | 77
 | orange | mandrin | unsorted | 80 |  |  |  |  | sort | 70
 | orange | mandrin | High | 77 |  |  |  | Red | low | 81
 | orange | mandrin | sort | 70 |  |  |  |  | Process | 73
 | orange | mandrin | Old | 68 |  |  |  |  | unsorted | 45
 | orange | mandrin | Process | 47
 | orange | mandrin | dark | 44 |  |  | Apple | PinK Lady | Process | 78
 | orange | mandrin | low | 39 |  |  |  |  | dark | 71
 | orange | mandrin | Light | 36 |  |  |  |  | High | 70
 | orange | Red | low | 81 |  |  |  | Golden | Old | 79
 | orange | Red | Process | 73 |  |  |  |  | low | 74
 | orange | Red | unsorted | 45 |  |  |  |  | unsorted | 53
 | orange | Red | dark | 44
 | orange | Red | Light | 41
 | orange | Red | High | 38
 | orange | Red | Old | 32
 | orange | Red | sort | 30
 | Apple | PinK Lady | Process | 78
 | Apple | PinK Lady | dark | 71
 | Apple | PinK Lady | High | 70
 | Apple | PinK Lady | unsorted | 48
 | Apple | PinK Lady | Light | 44
 | Apple | PinK Lady | low | 42
 | Apple | PinK Lady | Old | 37
 | Apple | PinK Lady | sort | 35
 | Apple | Golden | Old | 79
 | Apple | Golden | low | 74
 | Apple | Golden | unsorted | 53
 | Apple | Golden | Light | 49
 | Apple | Golden | Process | 43
 | Apple | Golden | sort | 38
 | Apple | Golden | High | 34
 | Apple | Golden | dark | 32
Spreadsheet: 546382d1510018472-rmd-required-minimum-deduction-rmd-twr
Sheet: TWR

RMD factor | 27.4
RMD
 | Deposits + Withdrawals | End Bal | Acct Val Chng | TWR Bal | TWR | TWR [NAME]
Initial |  | 99500
Nov |  | 99997.5
Dec |  | 100497.49
Jan |  | 97313.76
Total Return
Total TWR
Spreadsheet: tracy_geaccone__40406__MID Fuels History
Sheet: Master Data

MID Fuel Percentages to MID 16A
 |  | 08/01/01 | 2000-06-01 00:00:00 | 1999-06-01 00:00:00 | 1999-03-01 00:00:00 | 1998-11-01 00:00:00 | 1998-06-01 00:00:00 | 1997-12-01 00:00:00 | 1997-06-01 00:00:00 | 1997-05-01 00:00:00 | 1997-04-04 00:00:00 | 1996-09-01 00:00:00 | 1996-01-01 00:00:00 | 1993-11-01 00:00:00
MID 8 | Mainline | 0.029 | 0.024 | 0.0203 | 0.0255 | 0.0223 | 0.0252 | 0.0295 | 0.0359 | 0.0172 | 0.0175 | 0.0175 | 0.0175 | 0.0175
 | Field | 0 | 0.0527 | 0.0553 | 0.0636 | 0.0636 | 0.0636 | 0.0556 | 0.0556 | 0.0425 | 0.046 | 0.046 | 0.046 | 0.046
 | Total
MID 10 | Mainline | 0.029 | 0.024 | 0.0203 | 0.0255 | 0.0217 | 0.0232 | 0.0238 | 0.0256 | 0.0291 | 0.03 | 0.03 | 0.03 | 0.03
 | Field | 0.0145 | 0.0178 | 0.0121 | 0.0103 | 0.0103 | 0.0103 | 0.0094 | 0.0094 | 0.023 | 0.025 | 0.025 | 0.025 | 0.025
0.3 | Total
MID 11 | Mainline | 0.029 | 0.024 | 0.0203 | 0.0255 | 0.0168 | 0.0183 | 0.0252 | 0.0256 | 0.0244 | 0.025 | 0.025 | 0.025 | 0.025
 | Field | 0.0236 | 0.0228 | 0.0278 | 0.026 | 0.026 | 0.026 | 0.0231 | 0.0231 | 0.0214 | 0.023 | 0.023 | 0.023 | 0.023
0.58 | Total
MID 12 | Mainline | 0.029 | 0.024 | 0.0203 | 0.0255 | 0.0102 | 0.0111 | 0.0193 | 0.0147 | 0.0244 | 0.025 | 0.025 | 0.025 | 0.025
 | Field | 0.0201 | 0.0183 | 0.0225 | 0.0208 | 0.0208 | 0.0208 | 0.0159 | 0.0159 | 0.0214 | 0.023 | 0.023 | 0.023 | 0.023
0.06 | Total
MID 13 | Mainline | 0.029 | 0.024 | 0.0203 | 0.0255 | 0.0102 | 0.0111 | 0.0158 | 0.0147 | 0.0172 | 0.0175 | 0.0175 | 0.0175 | 0.0175
 | Field | 0.0206 | 0.0211 | 0.0289 | 0.0346 | 0.0346 | 0.0346 | 0.0272 | 0.0272 | 0.0217 | 0.023 | 0.023 | 0.023 | 0.023
0.06 | Total
[NAME] | Mainline
[NAME] | Field
[NAME] | Total
Spreadsheet: f95d33a6-5910-4120-8fbf-ab2d797cbe2a
Sheet: Weekly Comparisons

 |  | Jan |  |  |  | Feb |  |  |  | Mar |  |  |  | Apr |  |  |  | May |  |  |  | Jun |  |  |  | Jul |  |  |  | Aug |  |  |  | Sep |  |  |  | Oct |  |  |  | Nov |  |  |  | Dec
Non-Shuttle |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME].
Current week bid/offer
Change from prior week
Change from prior year
Aggregate avg. bid this week
Aggregate avg. change from prior week
Aggregate avg. change over last 4 weeks
 |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose
Aggregate peak |  |  |  | Jan. 2014 |  |  |  | Feb. 2014 |  |  |  | Mar. 2014 |  |  |  | Apr. 2014 |  |  |  | May. 2014 |  |  |  | Jun. 2014 |  |  |  | Jul. 2014 |  |  |  | Aug. 2014 |  |  |  | Sep. 2014 |  |  |  | Oct. 2014 |  |  |  | Nov. 2014 |  |  |  | Dec. 2014
Change from peak
Shuttle |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME]. |  | BNSF | UP | [NAME].
Current week bid/offer
Change from prior week
Change from last year
Aggregate avg. bid this week
Aggregate avg. change from prior week
Aggregate avg. change over last 4 weeks
 |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose |  |  |  | Do not copy items in rose
Aggregate peak |  |  |  | Jan. 2014 |  |  |  | Feb. 2014 |  |  |  | Mar. 2014 |  |  |  | Apr. 2014 |  |  |  | May. 2014 |  |  |  | Jun. 2014 |  |  |  | Jul. 2014 |  |  |  | Aug. 2014 |  |  |  | Sep. 2014 |  |  |  | Oct. 2014 |  |  |  | Nov. 2014 |  |  |  | Dec. 2014
Change from peak
Spreadsheet: teb_lokey__39567__TWauditFinds2001openissues
Sheet: Sheet1

station ID | station name | audit finding | action | date found | date resolved
009780-01,02 | Rio Puerco | 1) oily orifice plates | condition is better; just a very thin film 9/25/01 | ongoing | open
 |  | 4) 6 valves could leak and pass unmetered gas | schedule down time and check (maybe in Oct/Nov) | 2001-08-07 00:00:00 | open
009702-01,02 | WMS Milagro | 3) possibility of bypass vlvs leaking | will blind off; scheduled for mid October | 2001-07-10 00:00:00 | open
010160-01,02 | Amoco LaPlata | 1) [NAME] orifice; using upstream static; calc wrong | notify Cessac to chk program software for error | 2001-08-01 00:00:00 | open
19080 | [NAME] | 1) oily liquid causing orifice plate issues as well as gas | Conoco will install coalescing filter/scrubber | ongoing | open
 |  | sampling problems | scheduled for mid Nov.
47044 | EOG Pronghorn | 1) dripping glycol on orifice plate | EOG to install scrubber | ongoing | open
91940/91941 | Atoka 2 chk sta | 1) dirty/oily plate problems | Eng. To review problem and make suggestions | ongoing | open
 |  | 2) pulsation issues at meter tube | work order submitted; no response | ongoing | open
000010-01-12 | [NAME] | 1) oily plates all tubes | filters changed on 9/19/01; have not chked plates since | ongoing | open
 |  | 2) run-switching valves, 4,5,6, all leak when closed | team/advisor will discuss/resolve | ongoing | open
009216 - 1,2,3 | PGE Topock | pos-shut-in-valves leak (dwn stream of regs) | team/advisor will discuss; next time down will grease/chk | ongoing | open
 |  | when station down, both leak mucho gas
094039-01 | El Paso Blanco | oily orifice plates - minimal SRE | San Juan - oil will go away when 010162 oil clears up | ongoing | open
094039-02 | El Paso Blanco | Ditto | Ditto | ongoing | open
094039-03 | El Paso Blanco | Ditto | Ditto | ongoing | open
010162-01 | [NAME] | oily plates | San Juan Team / continue to work w/ WFS/ marketing | ongoing | open
010162-02 | [NAME] | oily plates | Ditto | ongoing | open
Spreadsheet: 767081d1644276083-need-help-on-spreadsheet-do-i-need-to-use-vlookup-hlookup-index-match-2022-law-dogs-standings
Sheet: Standings

Mesquite Law Dogs Standings
Week 1
Divison One | W | L | PCT | GB | PF | PA
Sharks
Gator Dawgs
Mudcats
Wet Farts
Divison Two | W | L | PCT | GB | PF | PA
Thundermutts
Capo Crimini
Cajun Coonasses
King of Queens
Divison Three | W | L | PCT | GB | PF | PA
Muckdogs
[NAME]
Deadbirds
Pics Hitmen
BREAK | WIN | LOSS
-9999
-175.1 | 0 | 8
-125.1 | 1 | 7
-75.1 | 2 | 6
-10.1 | 3 | 5
0 | 4 | 4
10.1 | 5 | 3
75.1 | 6 | 2
125.1 | 7 | 1
175.1 | 8 | 0
Spreadsheet: john_griffith__15861__11_12_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 21.5 | 90 | 110 | 70.8 | 86.6 | 1.06 | 2001-11-12 10:13:00
 | CL F2 | 22 | 273 | 285 | 52.7 | 55 | 0.74 | 2001-11-12 10:13:00
 | CL G2 | 22 | 370 | 385 | 50.4 | 52.4 | 0.71 | 2001-11-12 10:13:00
 | CL H2 | 22 | 430 | 445 | 48.9 | 50.6 | 0.69 | 2001-11-12 10:13:00
 | CL J2 | 22 | 470 | 495 | 46.9 | 49.4 | 0.67 | 2001-11-12 10:13:00
 | CL K2 | 22 | 505 | 525 | 44.9 | 46.7 | 0.63 | 2001-11-12 10:13:00
 | CL M2 | 22 | 530 | 555 | 43.5 | 45.6 | 0.62 | 2001-11-12 10:13:00
 | CL N2 | 22 | 550 | 570 | 41.8 | 43.4 | 0.59 | 2001-11-12 10:13:00
 | CL Q2 | 22 | 555 | 575 | 39.7 | 41.1 | 0.56 | 2001-11-12 10:13:00
 | CL U2 | 22 | 560 | 580 | 38.1 | 39.5 | 0.54 | 2001-11-12 10:13:00
 | [NAME] | 22 | 565 | 585 | 36.5 | 37.8 | 0.51 | 2001-11-12 10:13:00
 | CL X2 | 22 | 565 | 585 | 34.9 | 36.2 | 0.49 | 2001-11-12 10:13:00
 | [NAME] | 21.5 | 560 | 590 | 34.2 | 36.1 | 0.48 | 2001-11-12 10:13:00
 | CL M3 | 21.5 | 560 | 580 | 28.8 | 29.8 | 0.4 | 2001-11-12 10:13:00
 | CL Z3 | 21.5 | 560 | 580 | 25.5 | 26.5 | 0.35 | 2001-11-12 10:13:00
Spreadsheet: 717111d1612481653-please-help-with-conditional-formatting-exampleyms
Sheet: Sheet1

 |  |  |  | 61 | 62 | 63 | 64 | 65 | 66 | 67 | 68 | 69 | 70 | 71 | 72 | 73 | 74
 |  |  |  | 01/02/2021 [NAME] : 12345 Contains Raw Cardboard | 2021-02-01 00:00:00 | 2021-02-02 00:00:00 | 2021-02-02 00:00:00 | 2021-02-04 00:00:00 | 2021-01-31 00:00:00 | 2021-02-02 00:00:00 | 2021-02-03 00:00:00 | 2021-02-03 00:00:00 | 2021-02-01 00:00:00 | 2021-02-01 00:00:00 | 2021-02-03 00:00:00 | 2019-01-20 00:00:00 | 2021-02-03 00:00:00
 |  |  |  | Red = A trailer that has been sitting for 3 or more days =R55<=TODAY()-3
 |  |  |  | Orange = A trailer that has been sitting for 2 days =R55=TODAY()-2
 |  |  |  | Green = A trailer that has been sitting for 1 day
Spreadsheet: 828900d1683789475-formula-to-read-multiple-points-rounds-formulae
Sheet: Results

 | Player | X totals | Round 1 | Round 2 | Round 4 |  | Formulae works when value is 1, but nor for anything higherr (such as 2, 3 3tc.
 |  |  |  |  |  |  | Require formulae which calculates all Yes with result  in column C
 | Player 01
 | Player 02
 | Player 03
 | Player 04
 | Player 05 |  |  |  |  |  | Outcome choulld be 3
 | Player 06
 | Player 07 |  |  |  |  |  | Outcome choulld be 4
 | Player 08
 | Player 09
 | Player 10 |  |  |  |  |  | Outcome choulld be 5
 | Totals
Spreadsheet: 694052d1599317674-how-to-apply-filter-formula-for-multiple-conditions-copy-of-processing-efficiency-akshay6s-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTR SENT | MTR RECEIVED | KGS SENT | KGS RECEIVED | [NAME] | REMARKS | WEEKS SENT | Display
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020-08-26 00:00:00
Spreadsheet: 275647d1383597840-how-can-i-dynamically-link-to-an-external-workbook-1-tracker
Sheet: Sheet1

 | [NAME] DOCUMENTS
 | # | Project Tracker | Tracker Location | File Name | Sheet Name | Cell ID
 | 1 |  | C:\Users\LDAoust\Desktop\Linked Docs\ | 2-TrackME.xlsx | Sheet1 | !B2
 | 2 |  | C:\Users\LDAoust\Desktop\Linked Docs\ | 3-TrackME.xlsx | Sheet1 | !B2
Spreadsheet: 203496d1357144763-random-number-generator-discluding-specific-numbers-tigeravatar-example-for-jvesuvius
Sheet: Results

188 Random Numbers
20
64
230
196
300
137
203
205
19
112
191
348
249
130
172
110
117
161
342
42
303
98
282
69
8
297
178
135
276
234
233
120
308
10
267
147
241
27
89
44
270
154
157
58
175
302
33
141
309
317
316
29
4
235
151
102
18
275
242
76
181
252
354
57
156
66
184
113
306
36
148
272
81
289
101
323
87
325
5
12
281
295
95
251
280
198
11
271
310
99
124
79
173
71
55
238
292
153
239
155
103
88
31
126
32
190
163
229
52
28
159
183
2
247
14
68
23
80
269
56
255
164
174
171
53
60
26
244
291
176
138
41
129
114
250
61
63
125
231
165
240
133
51
357
152
192
182
150
180
62
236
320
134
264
355
336
122
83
16
144
139
318
228
285
104
24
77
186
253
39
293
109
6
301
296
227
158
38
286
349
84
105
34
168
73
170
185
1
Spreadsheet: 850471d1700812592-count-days-between-latest-and-previous-data-match-sample2-8-aligw
Sheet: named ranges

RepairPM |  |  |  |  | REPAIRONLY
DE Preventative Maintenance High |  |  |  |  | DE Repair High
DE Preventative Maintenance Low |  |  |  |  | DE Repair High XX
DE Preventative Maintenance No Priority |  |  |  |  | DE Repair Low
DE Repair High |  |  |  |  | DE Repair Low XX
DE Repair High XX |  |  |  |  | DE Repair No Priority
DE Repair Low |  |  |  |  | FR Repair Low
DE Repair Low XX |  |  |  |  | FR Repair Medium
DE Repair No Priority |  |  |  |  | FR Repair No Priority
DE Revisit High |  |  |  |  | UK Repair High
DE Revisit High XX |  |  |  |  | UK Repair High XX
DE Revisit Low |  |  |  |  | UK Repair Medium
DE Revisit Low XX |  |  |  |  | UK Repair Medium XX
DE Revisit No Priority |  |  |  |  | UK Repair Very High
DE Revisit No Priority XX |  |  |  |  | UK Repair Very High XX
FR Preventative Maintenance Low |  |  |  |  | UK Repair Low
FR Preventative Maintenance Medium |  |  |  |  | UK Repair Low XX
FR Repair Low
FR Repair Medium
FR Repair No Priority
FR Revisit Low
FR Revisit Medium
FR Revisit No Priority
UK Preventative Maintenance Low
UK Preventative Maintenance Medium
UK Repair High
UK Repair High XX
UK Repair Low
UK Repair Low XX
UK Repair Medium
UK Repair Medium XX
UK Repair Very High
UK Repair Very High XX
Uk Revisit High
UK Revisit High XX
UK Revisit Low
UK Revisit Low XX
Uk Revisit Medium
UK Revisit Medium XX
UK Revisit Very High