tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 29804d1224892430-adding-a-number-to-deg-min-dec-abcd
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Time between plots
 |  |  | Latitude DD° MM' SS" | [NAME]° MM' SS" | Latitude DDD MM.MMM | [NAME]
 | Date | Time |  |  |  |  | Distance | Speed | Course
1 | 2008-01-11 00:00:00 | 01:58:00 | 12° 32’ 28 S | 141° 31’ 12 E | 12° 32.467' S | 141° 31.200' E | 0.84 | 3.14 | 24.82
2 | 2008-01-12 00:00:00 | 02:14:00 | 12° 31’ 43 S | 141° 31’ 33 E | 12° 31.717' S | 141° 31.550' E | 0.09 | 0.38 | 26.02 | 00:16:00
3 | 2008-01-13 00:00:00 | 02:28:00 | 12° 31’ 38 S | 141° 31’ 36 E | 12° 31.633' S | 141° 31.600' E | 0.75 | 3.21 | 204.67 | 00:14:00
4 | 2008-01-14 00:00:00 | 02:42:00 | 12° 32’ 19 S | 141° 31’ 16 E | 12° 32.317' S | 141° 31.267' E | 0.71 | 3.05 | 206.02 | 00:14:00
5 | 2008-01-15 00:00:00 | 02:56:00 | 12° 32’ 57 S | 141° 30’ 57 E | 12° 32.950' S | 141° 30.950' E | 0.26 | 1.13 | 242.88 | 00:14:00
6 | 2008-01-16 00:00:00 | 03:10:00 | 12° 33’ 04 S | 141° 30’ 43 E | 12° 33.067' S | 141° 30.717' E | 0.71 | 2.65 | 37.49 | 00:14:00
7 | 2008-01-17 00:00:00 | 03:26:00 | 12° 32’ 31 S | 141° 31’ 09 E | 12° 32.517' S | 141° 31.150' E | 0.71 | 3.05 | 26.02 | 00:16:00
8 | 2008-01-18 00:00:00 | 03:40:00 | 12° 31’ 52 S | 141° 31’ 28 E | 12° 31.867' S | 141° 31.467' E | 0.57 | 2.45 | 11.82 | 00:14:00
9 | 2008-01-19 00:00:00 | 03:54:00 | 12° 31’ 19 S | 141° 31’ 36 E | 12° 31.317' S | 141° 31.600' E | 0.7 | 2.99 | 192.94 | 00:14:00
10 | 2008-01-20 00:00:00 | 04:08:00 | 12° 31’ 59 S | 141° 31’ 26 E | 12° 31.983' S | 141° 31.433' E | 0.75 | 3.21 | 204.67 | 00:14:00
11 | 2008-01-21 00:00:00 | 04:22:00 | 12° 32’ 40 S | 141° 31’ 07 E | 12° 32.667' S | 141° 31.117' E | 0.68 | 2.54 | 207.5 | 00:14:00
12 | 2008-01-22 00:00:00 | 04:38:00 | 12° 33’ 16 S | 141° 30’ 47 E | 12° 33.267' S | 141° 30.783' E | 0.53 | 2.29 | 12.69 | 00:16:00
 |  |  |  |  |  |  |  |  |  |  | 12:32:28 | 12.54111111111111 | 12.63111111111111 | 12:37:52
 |  |  |  |  |  |  |  |  |  |  | 12° 31’ 43 S
 |  |  |  |  |  |  |  |  |  |  | 12° 31’ 38 S
 |  |  |  |  |  |  |  |  |  |  | 12° 32’ 19 S
 |  |  |  |  |  |  |  |  |  |  | 12° 32’ 57 S
 |  |  |  |  |  |  |  |  |  |  | 12° 33’ 04 S
 |  |  |  |  |  |  |  |  |  |  | 12° 32’ 31 S
 |  |  |  |  |  |  |  |  |  |  | 12° 31’ 52 S
 |  |  |  |  |  |  |  |  |  |  | 12° 31’ 19 S
 |  |  |  |  |  |  |  |  |  |  | 12° 31’ 59 S
 |  |  |  |  |  |  |  |  |  |  | 12° 32’ 40 S
 |  |  |  |  |  |  |  |  |  |  | 12° 33’ 16 S
 |  |  |  |  | I start with a column of Latitudes & a column of [NAME] (Cols D & E)  both containing several hundred entries.  I took cell [NAME] and formatted it (by hand) to DD:MM:SS (cell L19).   In cell M19 I then used the formula =L19*24 & formated the cell to General to  convert to Degrees and decimal of degrees.  In cell N19 I placed the formula =M19+0.09 to give my final figure.  In cell O19 I placed the formula =N19/24 formatting the cell to HH:MM:SS  The question is how do I:              bulk convert cell D4 etc from 12° 32' 28" to 12:32:28              bulk convert cell O19 etc from 12:37:52 to DD° MM.MMM'
 |  |  |  |  | ,
 |  |  |  |  |  |  |  |  |  |  |  | m | n | o
Spreadsheet: 689579d1596529697-shade-cells-in-staff-rota-if-staff-are-at-work-rota-edit-copy-copy
Sheet: WEEK B

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B WEEK |  |  |  | Task A |  |  |  |  |  |  | Task B |  |  |  |  |  |  | Task C |  |  |  |  |  |  | MANAGEMENT
SUNDAY
 | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00                                                19:00
Staff A
Staff B
Staff C
Staff D
Staff E
Staff F
Staff G
Staff H
Staff I
Staff J
Staff K
 | 00:00:00 |  |  |  | 01:00:00 |  |  |  | 02:00:00 |  |  |  | 03:00:00 |  |  |  | 04:00:00 |  |  |  | 05:00:00 |  |  |  | 06:00:00 |  |  |  | 07:00:00 |  |  |  | 08:00:00 |  |  |  | 09:00:00 |  |  |  | 10:00:00 |  |  |  | 11:00:00 |  |  |  | 12:00:00 |  |  |  | 13:00:00 |  |  |  | 14:00:00 |  |  |  | 15:00:00 |  |  |  | 16:00:00 |  |  |  | 17:00:00 |  |  |  | 18:00:00
Spreadsheet: 775056d1648803885-linearity-condition-not-satisfied-with-solver-when-including-binary-variables-linearity-problem
Sheet: Worksheet

 |  | Inputs
 |  |  | Stock | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  |  |  |  |  | Categorized assets
 |  |  | Average returns | 0.0154670114116332 | 0.0163905038197697 | 0.01727232661323731 | -0.003999890097888 | 0.013392394478057 | 0.0153093319902007 | 0.0193842333029244 | 0.00197678880479271 | 0.0173034174287515 | 0.0142046716387189 |  |  |  |  | Risk group | C1 | C2 | [NAME] | C4 | C5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R1 | 1 |  | 6 |  | 9, 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R2 |  | 4 | 5 | 8
 |  | Decision variables |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R3 | 2 | 3 |  | 7
 |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  | Include in portfolio |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Investment weights |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Objective function
 |  | Maximize portfolio returns
 |  | Constraints
 |  | 1.Portfolio = 100% of total investment |  |  |  |  |  |  |  | = | 1
 |  | 2.The 5 asset categories must be included |  |  |  |  |  | C1 |  | [NAME] | 1
 |  |  |  |  |  |  |  | C2 |  | [NAME] | 1
 |  |  |  |  |  |  |  | [NAME] |  | [NAME] | 1
 |  |  |  |  |  |  |  | C4 |  | [NAME] | 1
 |  |  |  |  |  |  |  | C5 |  | [NAME] | 1
 |  | 3.At most 2 of the assets can be in the least risky group R1 |  |  |  |  |  |  |  | [NAME] | 2
 |  | 4.At least 1 must be in the riskiest group R3 |  |  |  |  |  |  |  | [NAME] | 1
 |  | 5.Exactly 7 assets must be chosen |  |  |  |  |  |  |  | = | 7
 |  | 6.Stock constraints |  |  |  |  |  | 1 |  | <=
 |  |  |  |  |  |  |  | 2 |  | <=
 |  |  |  |  |  |  |  | 3 |  | <=
 |  |  |  |  |  |  |  | 4 |  | <=
 |  |  |  |  |  |  |  | 5 |  | <=
 |  |  |  |  |  |  |  | 6 |  | <=
 |  |  |  |  |  |  |  | 7 |  | <=
 |  |  |  |  |  |  |  | 8 |  | <=
 |  |  |  |  |  |  |  | 9 |  | <=
 |  |  |  |  |  |  |  | 10 |  | <=
Spreadsheet: 95569d1295163142-need-solution-to-pull-data-from-sheet1-to-sheet2-if-value-0-mafiawars_testsheet
Sheet: Sheet1

 |  |  |  |  | GIFTABLE ITEMS - ATTACK
 |  |  |  |  | Weapons:
 |  |  |  |  | Armor: |  |  |  |  | Results of Macro
 |  |  |  |  | Vehicles:
 |  |  |  |  |  | Executive Decision | 5 | <---  This should be up at weapons
 |  |  |  |  | Animals: | 40mm Bunker Buster | 10 | <--- This should be up at weapons
 |  |  |  |  |  | New Years Resolution | 29 | <--- This should be at weapons
 |  |  |  |  |  | [NAME] and [NAME] | 22 | <--- This should be at Armor
 |  |  |  |  |  | Each type of Armory used should far by it type: (Weapons - Armor - Vehicles - Animals
 |  |  |  |  |  | V
 |  |  |  |  | GIFTABLE ITEMS - ATTACK
 |  |  |  |  | Weapons: | Executive Decision | 5
 |  |  |  |  |  | 40mm Bunker Buster | 10
 |  |  |  |  |  | New Years Resolution | 29
 |  |  |  |  | Armor: | [NAME] and [NAME] | 22
 |  |  |  |  | Vehicles: | Outlander | 10
 |  |  |  |  |  | [NAME] | 87
 |  |  |  |  | Animals: | [NAME] | 15
 |  |  |  |  |  | Diamondback | 33
Spreadsheet: a6872c2b-1fa6-4e8d-832f-aac0bc9aba04
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Produce for People 2013
Produce Donation Record
Community Garden: ______________________
Please track your donations throughout the season, and return this form to Portland Community Gardens by November 1
Date | [NAME] | Weight | Donated By | Donated To
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
 |  |  | □ PFP Plot
 |  |  | □ Plant-a-Row/Gleaned
PFP Plot Plot Total: |  |  | Plant-a-row Page Total:
PFP Plot Running total of lbs: |  |  | Plant-a-row Running Total of lbs:
Spreadsheet: 883188d1731691636-use-the-other-formula-instead-of-vlookup-formula-file-a-vehile-ecel-help-forum-3
Sheet: form

 |  |  | ABC INTERNATIONAL COMPANY
 |  |  | OPERATIONAL VEHICLE DUTY SLIP No: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($B4,$B$84:$AK$165,COLUMN(E1),0) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($L$5,data!$A$4:$P$17,4,FALSE)
Name |  |  |  |  |  |  |  | Employe No. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =INDIRECT("'"&D6&"'!h21")
Designation |  |  |  |  |  |  |  | Type of Vehicle Required: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | '  =INDIRECT(sheet_name&"!A1") |  |  | =VLOOKUP(Sheet1!#REF!,Sheet1!F4:F24,1,)
Date: |  |  | 2024-11-12 00:00:00 |  |  |  | From |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF(Sheet1!#REF!=F4,Sheet1!F4,Sheet1!E4)
Place / Address where vehicle required: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =IF($L$5=data!A2,data!D2,data!D3)
Purpose:-
Place be visited: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | =VLOOKUP($B$9,data!$A$1:$F$11,2,FALSE)
Applied By                                  Recommended By                        Approved By
Vehicle No. |  |  |  |  |  |  |  |  | Make |  |  |  | Power(CC)
[NAME] at the start of duty:-- |  |  |  |  |  |  |  |  |  |  |  |  | at the end of duty
Total running of this visit:-
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I used here [NAME] formula, I want to use another formula for dynmic range and spell all the values
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | from sheet2(data)…
Signature of Driver |  |  |  |  |  |  |  |  |  |  |  |  | Signature of [NAME]
Spreadsheet: 482016d1474857303-turn-a-2-d-table-into-1-d-supporting-characters-and-symbols-calendar-transposition-2d-to-1d
Sheet: CHR

2016 | 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
2016-01-01 00:00:00 | 1 |  | 3 |  | 4 | 5 |  |  | 6 |  |  | 7 |  |  |  | 8 |  |  | 9 |  | 10 |  |  |  |  |  |  |  |  |  | 20
2016-02-01 00:00:00 |  | 21 |  | 23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
2016-03-01 00:00:00
2016-04-01 00:00:00
2016-05-01 00:00:00
2016-06-01 00:00:00
2016-07-01 00:00:00
2016-08-01 00:00:00
2016-09-01 00:00:00
2016-10-01 00:00:00
2016-11-01 00:00:00
2016-12-01 00:00:00
2016-01-01 00:00:00
2016-01-02 00:00:00
2016-01-03 00:00:00
2016-01-04 00:00:00
2016-01-05 00:00:00
2016-01-06 00:00:00
2016-01-07 00:00:00
2016-01-08 00:00:00
2016-01-09 00:00:00
2016-01-10 00:00:00
2016-01-11 00:00:00
2016-01-12 00:00:00
2016-01-13 00:00:00
2016-01-14 00:00:00
2016-01-15 00:00:00
2016-01-16 00:00:00
2016-01-17 00:00:00
2016-01-18 00:00:00
2016-01-19 00:00:00
2016-01-20 00:00:00
2016-01-21 00:00:00
2016-01-22 00:00:00
2016-01-23 00:00:00
2016-01-24 00:00:00
2016-01-25 00:00:00
2016-01-26 00:00:00
2016-01-27 00:00:00
2016-01-28 00:00:00
2016-01-29 00:00:00
2016-01-30 00:00:00
2016-01-31 00:00:00
2016-02-01 00:00:00
2016-02-02 00:00:00
2016-02-03 00:00:00
2016-02-04 00:00:00
2016-02-05 00:00:00
2016-02-06 00:00:00
2016-02-07 00:00:00
2016-02-08 00:00:00
2016-02-09 00:00:00
2016-02-10 00:00:00
2016-02-11 00:00:00
2016-02-12 00:00:00
2016-02-13 00:00:00
2016-02-14 00:00:00
2016-02-15 00:00:00
2016-02-16 00:00:00
2016-02-17 00:00:00
2016-02-18 00:00:00
2016-02-19 00:00:00
2016-02-20 00:00:00
2016-02-21 00:00:00
2016-02-22 00:00:00
2016-02-23 00:00:00
2016-02-24 00:00:00
2016-02-25 00:00:00
2016-02-26 00:00:00
2016-02-27 00:00:00
2016-02-28 00:00:00
2016-02-29 00:00:00
2016-03-01 00:00:00
2016-03-02 00:00:00
2016-03-03 00:00:00
2016-03-04 00:00:00
2016-03-05 00:00:00
Spreadsheet: 64753d1265607887-cut-and-paste-macro-categories
Sheet: Sheet2

Beginners / Kids Mag | Beginner Magic-EZ
Broadcast Special | Street Magic
[NAME] | Accessories;Regular Decks
Card Magic | Close-Up Magic;Card Magic
Close-Up Magic | Close-Up
Collectible/Historic | Collectables
[NAME] | [NAME]
[NAME] (Shop) | Easy to Perform
Exclusive | General [NAME]
Fire Magic | Fire Magic
Gambling Magic | Gambling Magic
Gospel Magic | Gospel Magic
Magic Set | Beginner Magic E-Z;Magic Kits
Magic Staples / Cons | Accessories
Mentalism | Mentalism
Magic For Kids | Magic For Kids
Money Magic | Close up;Money Magic
Seasonal - Christmas | Seasonal;Christmas
Seasonal - Halloween | Seasonal;Halloween
Stage Magic | Platform/Stage
Street Magic | Street Magic
Recommended | General [NAME]
Spreadsheet: 489714d1479399347-summarizing-form-data-into-records-lines-test-form
Sheet: Test Form (3)

 |  |  |  |  |  | LABOR, EQUIPMENT & MATERIAL |  |  |  |  |  |  | # |  | 6151
 | Contact:
 |  |  |  |  | WMLP
 | CUSTOMER: |  |  |  |  |  |  | LINE |  |  |  | DATE:
 | JOB SITE: | MP |  |  | GW |  |  | AFE |  |  |  | JOB #:
 | [NAME] OF WORK: |  |  |  |  |  |  |  |  |  |  | PHASE:
 |  |  |  |  |  |  |  |  |  |  |  | COUNTY:
 | LABOR |  |  |  |  |  |  |  | HOURS |  |  |  | PER  DIEM | TRUCK PAY | Notes
 | TRADE |  |  | EMPLOYEE |  |  |  |  | S.T. |  | O.T. | D.T.
 | EQUIPMENT |  |  |  |  |  |  | EQUIPMENT
 | E-NUMBER | QTY | UoM | [NAME] |  |  |  | E-NUMBER | QTY |  | UoM | DESCRIPTON
 | TRUCKING & VENDORS |  |  |  |  |  |  | PO No. |  |  | FOREMAN'S SIGNATURE:
 |  |  |  |  |  |  |  |  |  |  | INSPECTOR'S PRINTED NAME:
 | MATERIALS |  |  |  |  |  |  | QTY
 |  |  |  |  |  |  |  |  |  |  | INSPECTOR'S SIGNATURE:
Spreadsheet: darrell_schoolcraft__7477__imball0202
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 10187-01 | 9089-01 | 10522
 | Measured | Scheduled | Measured | Scheduled |  |  | Del | recpt
1 |  |  |  |  |  | -20950 | -6
2 |  |  |  |  |  | -21285 | -6
3 |  |  |  |  |  | -12127 | -106
4 |  |  |  |  |  | -3520 | -19935 | 1
5 |  |  |  |  |  | 0 | -14532
6 |  |  |  |  |  | 0 | -10057 | 4
7 |  |  |  |  |  | -11018 | 0
8 |  |  |  |  |  | -27027 | -1 | 3239
9 |  |  |  |  |  | 0 | 0
10 |  |  |  |  |  | 0 | -28
11 |  |  |  |  |  | 0 | -25098 | 1
12 |  |  |  |  |  | 0 | -8
13 |  |  |  |  |  | -2931 | -11558
14 |  |  |  |  |  | -2931
15 |  |  |  |  |  | -14542 | -19966
16 |  |  |  |  |  | 0 | -15603
17 |  |  |  |  |  | -35137
18 |  |  |  |  |  | -19715
19 |  |  |  |  |  | -161
20 |  |  |  |  |  | -7781
21 |  |  |  |  |  | -14775
22 |  |  |  |  |  | -14217
23 |  |  |  |  |  | -28277
24 |  |  |  |  |  | -28905
25 |  |  |  |  |  | -19350
26 |  |  |  |  |  | -14323
27 |  |  |  |  |  | -18186
28 |  |  |  |  |  | -13798
29 |  |  |  |  |  | 23
30 |  |  |  |  |  | -14811
31 |  |  |  |  |  | -16076
index
2002-01-31 00:00:00 |  |  |  |  | 329520.2
2002-01-31 00:00:00
CBS Volume
 |  |  | -36982
Spreadsheet: c9d36f16-6645-42e1-aa4a-c49f855d3f35
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42864950 | 2014-08-24 21:00:12 | AXIS | 0 | 3 | 6 | 969102 | player969102 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42865297 | 2014-08-24 21:21:04 | ALLIES | 1 | 6 | 4 | 969102 | player969102 | 6154 | mediterranean | 1944-08-20 | 1944-08-26 | Toulon | Toulon
42865727 | 2014-08-24 22:32:44 | AXIS | 1 | 10 | 7 | 704824 | DelaWyvern | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42879578 | 2014-08-25 21:22:02 | AXIS | 1 | 5 | 2 | 1624680 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42879938 | 2014-08-25 21:46:41 | ALLIES | 1 | 5 | 3 | 1624680 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42959534 | 2014-08-31 16:00:09 | AXIS | 1 | 6 | 2 | 256598 | sam1812 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42960101 | 2014-08-31 16:32:29 | ALLIES | 0 | 2 | 6 | 256598 | sam1812 | 9579 | western | 1944-07-18 | 1944-07-20 | Operation Goodwood | Opération Goodwood
42961845 | 2014-08-31 18:51:42 | AXIS | 0 | 5 | 10 | 1294353 | gkhan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42962387 | 2014-08-31 19:32:56 | ALLIES | 0 | 5 | 10 | 1294353 | gkhan | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
42964801 | 2014-08-31 22:02:58 | AXIS | 1 | 5 | 1 | 1490806 | Rhinos | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
42965163 | 2014-08-31 22:25:40 | ALLIES | 1 | 5 | 4 | 1490806 | Rhinos | 7470 | mediterranean | 1942-05-27 | 1942-05-27 | [NAME] at Bir Hakeim | Débordement à Bir Hakeim
Spreadsheet: 239196d1369843540-how-to-create-2-dependent-drop-down-lists-with-1-to-2-relationship-price-calcuation-v2
Sheet: Master Calculation Sheet

Vendor | Product Type | Brand Name | [NAME] and Specifications | Color Selection | Other Specifications | Price | Quantity | Total
MenuDesign | MD_AFrames | TableTents | A-Frame Table Tents Two Sided A-Frame (4x5) |  |  |  | 1
CreativeImpressions | CI_MenuJackets | TrimFit4ViewBinders | Trim-Fit 4-View Binders Nickel or Black 3 or 6-Ring Binder - Bengaline Nylon (5.75x11) |  |  |  | 5
CreativeImpressions | CI_CaptainsBooks | SpiralHardcovers | Spiral Hardcover  (5.5x14) |  |  |  | 2
MenuDesign | MD_CornerBooks | DeluxePlaza | Deluxe Plaza Single Panel 1-View (5.5x11) |  |  |  | 1
MenuDesign | MD_AFrames | TableTents | A-Frame Table Tents Two Sided A-Frame (5.5x8.5) |  |  |  | 3
MenuPrinters | MP_CornerBooks | LinensVellums | Linens & Vellums Single Panel 1-View (5.75x12.5) |  |  |  | 7
MenuDesign | MD_Acrylics | Acrylics | 3-Sided Acrylic (3.5x8.5) |  |  |  | 12
CreativeImpressions | CI_AFrames | SoftTouchTableTents | Soft Touch Table Tents Three Sided Triangle Table Tent (4.25x11) |  |  |  | 2
MenuDesign | MD_Acrylics | Acrylics | Clear Acrylic Card Holders - Two Sided Top Open (4x6) |  |  |  | 4
MenuDesign | MD_AFrames | TableTents
 |  |  |  |  |  |  | Grand Total
Spreadsheet: 702902d1604597882-conditional-formatting-highlight-date-that-has-text-sample
Sheet: Sheet1

# | Name | Exp | Notes on conditional formatting
1675-0519 | Name 10 | n/a | don't want red
1648-0119 | Name 12 | 2021-06-01 00:00:00 | don't want red
2021-0221 | Name 1 | 2020-10-15 00:00:00 | should be red
1526-0316 | Name 78 | 10/15/2020-test message | should be red
1991-0720 | Name 0865 | 2020-11-01 00:00:00 | should be red
2034-0721 | Name 293 | 5/1/2021-test message 1; 10/15/2020-test message 2 | should be red
Spreadsheet: 0deed827-f462-4ebb-a7fd-a5cf00b27275
Sheet: Sheet1

Unnamed: 0 | State of New Hampshire - Primary Election | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
2012-09-11 00:00:00 | Governor - Republican
Cheshire County | Ovide Lamontagne, r | [NAME], r | [NAME], r | [NAME], d | [NAME], d | [NAME], d | [NAME]
Alstead | 56 | 52 |  |  | 1
Chesterfield | 147 | 116 | 4 | 1
Dublin | 126 | 37 | 3 | 1
[NAME] | 126 | 93 | 4 | 2 | 1
Gilsum | 45 | 25 | 1 |  |  |  | 1
Harrisville | 48 | 21 |  | 1
Hinsdale | 61 | 63 | 1 |  | 4 |  | 1
[NAME] | 298 | 139 | 6 | 2 | 2
[NAME] | 47 | 30
[NAME] | 135 | 60 | 6 | 3 | 1 | 1 | 1
[NAME] 3 | 181 | 76 | 3 | 5 | 1 |  | 1
[NAME] | 184 | 70 | 7 | 7 | 1 | 1
[NAME] | 199 | 86 | 1
Marlborough | 89 | 39 | 8 |  |  |  | 2
Marlow | 50 | 30 |  | 2 |  | 1
[NAME] | 40 | 16 | 1 | 2
Richmond | 69 | 67 | 2 | 1 | 1
Rindge | 317 | 237 | 22 |  | 2 |  | 1
Roxbury | 15 | 6
Stoddard | 65 | 77 | 3
[NAME] | 28 | 16 | 1 |  | 1
[NAME] | 36 | 28
Swanzey | 273 | 145 | 5 | 1
Troy | 83 | 78 | 2 | 5 | 2 | 2
Walpole | 210 | 92 | 6 | 1 | 1 | 1 | 1
Westmoreland | 140 | 48 | 7 |  |  |  | 1
Winchester | 92 | 54 | 6 | 3 |  | 1 | 1
TOTALS | 3160 | 1801 | 99 | 37 | 18 | 7 | 10
Spreadsheet: 215310d1361342173-workdays-holidays-change-currency
Sheet: Public Holiday

MYR | USD | CNY | TWD | KRW | EUR | SGD | [NAME]
2013-01-01 00:00:00 | 2013-01-01 00:00:00
2013-01-24 00:00:00 | 2013-01-21 00:00:00
2013-01-27 00:00:00 | 2013-02-18 00:00:00
2013-01-28 00:00:00 | 2013-03-10 00:00:00
2013-02-01 00:00:00 | 2013-03-29 00:00:00
2013-02-10 00:00:00 | 2013-05-27 00:00:00
2013-02-11 00:00:00 | 2013-07-04 00:00:00
2013-02-12 00:00:00 | 2013-09-02 00:00:00
2013-05-01 00:00:00 | 2013-10-14 00:00:00
2013-05-24 00:00:00 | 2013-11-03 00:00:00
2013-06-01 00:00:00 | 2013-11-11 00:00:00
2013-08-08 00:00:00 | 2013-11-28 00:00:00
2013-08-09 00:00:00 | 2013-12-25 00:00:00
2013-08-31 00:00:00 | 2014-01-01 00:00:00
2013-09-16 00:00:00 | 2014-01-20 00:00:00
2013-10-15 00:00:00 | 2014-02-17 00:00:00
2013-11-02 00:00:00 | 2014-03-09 00:00:00
2013-11-05 00:00:00 | 2014-04-18 00:00:00
2013-12-25 00:00:00 | 2014-05-26 00:00:00
2014-01-01 00:00:00 | 2014-07-04 00:00:00
2014-02-01 00:00:00 | 2014-09-01 00:00:00
2014-05-01 00:00:00 | 2014-10-13 00:00:00
2014-08-31 00:00:00 | 2014-11-02 00:00:00
2014-09-16 00:00:00 | 2014-11-11 00:00:00
2014-12-25 00:00:00 | 2014-11-27 00:00:00
 | 2014-12-25 00:00:00
[NAME]
Currency2
Day 1
First Business Day |  | (Ccy1)
Second Business Day |  | (Cc1 & 2)
Spreadsheet: 220862d1363284144-finding-a-partial-match-within-a-column-excel-matching-example-jacc
Sheet: BEFORE

COMPLEX LABELS | Matches |  | SIMPLE LABELS
Volume Times/Last 30 Days [Adhesive Bandages: Category Total] |  |  | [NAME]
Volume Times/Last 7 Days [Aftershave Lotion & Cologne For Men: Category Total] |  |  | Aftershave Lotion & Cologne For Men
Volume Number/Last 12 Months [Air Filters: Category Total] |  |  | Aluminum
Volume Containers/Last 3 Months [Air Fresheners, Carpet & Room Deodorizers: Category Total] |  |  | Freeze
Volume Times/Last 7 Days [Aluminum Foil: Category Total]
Volume Pounds/Last 30 Days [American Pasteurized Processed Cheese: Category Total] |  |  |  |  | [NAME]
Volume Gallons/Last 12 Months [Anti-Freeze/Coolant: Category Total]
Spreadsheet: 270587d1381532471-highlighting-a-cell-based-on-formula-with-a-date-test
Sheet: Sheet1

Start | end |  |  |  |  |  |  | 2013-09-01 00:00:00
2013-09-10 00:00:00 | 2014-05-30 00:00:00 |  |  |  |  |  |  | x
2013-11-01 00:00:00 | 2014-02-24 00:00:00 |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
 |  |  |  |  |  |  |  | x
Spreadsheet: 120739d1315491829-autopopulate-changing-info-in-one-sheet-to-a-new-one-copy-of-combined-working-w_matpremix
Sheet: 1302

 |  |  | Q.C. IN-PROCESS INSPECTION REPORT
Pocomoke, MD
Part Number: |  | 918872201 |  |  |  |  | Lot Number (J0#): |  | J1222 | 0
Part Description: |  | BOTTLE |  |  |  |  | Machine Number: |  | 52
Date | Shift | Time | Inspection Results |  |  |  |  |  | Q.C. ID
Defect Codes: A-Short Shot  B-Flash  C-Specks  D-Grease  E-Sinks  F-Surface Defects  G-Warped  H-Splay  J-Burns
K-Bubbles/Voids  L-Discoloration  M-Damaged/Smashed  N-Dimensions  O-Out of Spec  P-Other(Define)
 |  |  |  |  |  |  |  | Form # QASFM0401302 Rev D
 |  |  |  |  |  |  |  | Page 2 of 4