tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: gerald_nemec__11391__CostEstimateCarbonBlack
Sheet: PS Costs

.
ENA TECHNICAL SERVICES
PROJECT COST ESTIMATE ANALYSIS
 | CUSTOMER COMPANY NAME:
 | PROJECT NAME:
 | W.O. NUMBER:
 | PROJECT ENGINEER: |  |  | FILE NAME:
 | REVISION NUMBER:
 | PLANNER / MARKETER:
PROJECT SUPPORT COSTS
 |  |  |  |  |  |  | W.O.A. | W.O.A. | W.O.A.
 |  |  |  | Est. | Est. | W.O.A. | COST | CONTINGENCY | CONTINGENCY
 |  |  |  | Quantity | Unit | Unit Cost | ESTIMATE | ESTIMATE | EXPLANATION
 |  |  |  |  |  |  | (2/28/2000)
ENVIRONMENTAL
 | Permit Acquisition |  |  | 0 | Lot | 0 |  | 0
 |  | ENVIRONMENTAL SUB TOTAL
RIGHT OF WAY
 | ROW Direct Salaries |  |  | 0 | Lot | 0 |  | 0
 | ROW Damages |  |  | 0 | Lot | 0 |  | 0
 | ROW Outside Services |  |  | 0 | Lot | 0 |  | 0
 |  | RIGHT OF WAY SUB TOTAL
DISTRICT LABOR
 | DLAB |  |  | 0 | Lp Sum | 0 |  | 0
 |  | DISTRICT LABOR SUB TOTAL
ENGINEERING
 | ENGINEERING - COMPANY |  |  | 1 | Lp Sum | 1500 |  | 0
 | ENGINEERING - CONTRACT
 |  | Drafting, Reprographics, Copying, etc. |  | 0 | Lp Sum | 0 |  | 0
 |  | HMS Support |  | 1 | Lp Sum | 675 |  | 250
 |  | ENGINEERING SUB TOTAL
GAS LOSS (Blowdown & Purge)
 | Gas Blowdown and Purge |  |  | 0 | Ft3 | 2.5 | 0 | 0
 |  | GAS LOSS SUB TOTAL
PROJECT SUPPORT SUB TOTAL BEFORE "OTHER"CATEGORIES
ENTIRE PROJECT SUB TOTAL WITHOUT "OTHER" CATEGORIES
OTHER
As-Built Package (2.0%)
AFUDC (6.5% per year, for 30 days)
Overhead (12.0% HPL & 1.0% NNG)
 |  | OTHER SUB TOTAL
PROJECT SUPPORT SUB TOTAL
CONTINGENCIES
PROJECT SUPPORT SUB TOTAL WITH CONTINGENCIES
TOTAL ESTIMATED COST FOR ENTIRE WORK ORDER
CONTINGENCIES
TOTAL ESTIMATED COST FOR ENTIRE WORK ORDER WITH CONTINGENCIES
Spreadsheet: a401270f-3a75-41e8-b422-5bdfefcb1a11
Sheet: SD

CC ID | Type | Plant | City | State | ID | CBI | Status | Desig | Handles CCW? | Electric Utility? | Special Waste Addition? | Latitude | Longitude | Lined* | Is Leachate Collected? | Distance from Nearest Surface Waterbody (Ft.) | Year Initially Brought Online Or Planned to be Brought Online | Inactive | Representative | Party | Congressional District ID
Big Stone.LANDFILL-1 | Landfill | Big Stone | Big Stone City | SD | LANDFILL-1 | 0 | Active/Inactive/Open Landfills | Ash Disposal Site | YES | YES | NO | 45.304439 | -96.491217 | No | No | 2880 | 1975 | No | [NAME] | Republican | 4600
Big Stone.SPD-2 | Pond | Big Stone | Big Stone City | SD | SPD-2 | 0 | Active/Inactive/Open Pond/Impoundment Units | [NAME] | YES | YES | NO | 45.300014 | -96.510019 | No | No | 3070 | 1975 | No | [NAME] | Republican | 4600
Big Stone.SPD-7 | Pond | Big Stone | Big Stone City | SD | SPD-7 | 0 | Active/Inactive/Open Pond/Impoundment Units | Ash Disposal Site Runoff Pond | YES | YES | NO | 0 | 0 | No | No | 3200 | 1975 | No
*Does not necessarily mean a composite liner
Spreadsheet: john_griffith__15590__CL&F_120600
Sheet: Sheet1

[NAME]
Term 2 years Start date 01/01/01
 |  |  | Sales |  | Desk
Point |  | Pipeline | Point | Volume | Bid
[NAME] |  | Stingray | Columbia Gulf | 381 | 0.005
[NAME] 331/332 |  | Sea [NAME] | Columbia Gulf | 2776 | 0.005
[NAME] |  | Sea [NAME] | Columbia Gulf | 0 | 0.005
Grand Isle 83 |  | Northern Nat | Trunkline ELA | 2138 | 0.01
High Island 551 orri |  | TGPL | TGPL | 0 | 0.0025
Vermillion 84 |  |  | Columbia Gulf/TGPL | 758 | 0.0025
Vermillion 143/160 |  | TGPL | NGPL LA | 1029 | 0.0025
Vermillion 202 |  | NGPL | NGPL LA | 0 | 0.0025
Vermillion 281 |  | TGPL | Columbia Gulf | 722 | 0.005
[NAME] |  | Northern Nat | ANR | 2349 | -0.0025
[NAME] 528 |  |  | TETCO WLA | 191 | 0.0025
[NAME] orri |  |  | Columbia Gulf | 87 | 0.005
[NAME] |  |  | Sonat LA | 725 | 0.0025
[NAME] 143/148 |  |  | TETCO WLA | 879 | 0.0025
[NAME] |  | Stingray | NGPL LA | 148 | 0.0025
[NAME] 331/332 |  | Sea [NAME] | Columbia Gulf | 1080 | 0.005
Main Pass 225 unit |  | Main Pass | TETCO ELA | 313 | 0.0025
Mississippi Canyon 365 (320/321) |  |  | TETCO ELA | 188 | 0.0025
South Marsh Island 173/174/175/176 |  |  | [NAME] | 133 | 0.005
South Pass 45/54 |  |  | TGPL | 135 | 0.0025
South Pass 79/82/83 |  |  | Columbia Gulf/TGPL | 4184 | 0.005
Vermillion 160 orri |  |  | Columbia Gulf | 410 | 0.005
Vermillion 161 |  | Sea [NAME] | Columbia Gulf | 385 | 0.005
Total
Spreadsheet: 782473d1654073208-data-clean-up-20220523_coxiril-cen_neg_2019_batch-abc_pulse_centroid_nominal-mass-1-1-
Sheet: Coxiril_CEN_Neg_Batch A1

Raw data
Coxiril_Batch A_Bag 1
1 |  |  | 2 |  |  | 3
Mass | Intensity |  | Mass | Intensity |  | Mass | Intensity
101 | 55256 |  | 100 | 2323 |  | 100 | 2629
102 | 1484 |  | 101 | 24613 |  | 101 | 28560
103 | 4593 |  | 102 | 665 |  | 102 | 12
104 | 531 |  | 103 | 5880 |  | 103 | 10364
105 | 16464 |  | 105 | 11028 |  | 105 | 12282
107 | 325 |  | 107 | 329 |  | 108 | 5922
108 | 6530 |  | 109 | 16332 |  | 109 | 16345
109 | 8250 |  | 111 | 34303 |  | 111 | 23111
110 | 4586 |  | 112 | 26 |  | 112 | 55
111 | 23330 |  | 113 | 68298 |  | 113 | 53636
112 | 11906 |  | 114 | 12257 |  | 114 | 563
Using if formula |  |  |  |  |  |  |  |  |  |  | What I want
1 |  |  | 2 |  |  | 3 |  |  |  |  | 1 |  |  | 2 |  |  | 3
 |  |  |  |  |  |  |  |  |  |  | 101 | 55256 |  | 100 | 2323 |  | 100 | 2629
 |  |  |  |  |  |  |  |  |  |  | 102 | 1484 |  | 101 | 24613 |  | 101 | 28560
 |  |  |  |  |  |  |  |  |  |  | 103 | 4593 |  | 103 | 5880 |  | 103 | 10364
 |  |  |  |  |  |  |  |  |  |  | 105 | 16464 |  | 105 | 11028 |  | 105 | 12282
 |  |  |  |  |  |  |  |  |  |  | 108 | 6530 |  | 109 | 16332 |  | 108 | 5922
 |  |  |  |  |  |  |  |  |  |  | 109 | 8250 |  | 111 | 34303 |  | 109 | 16345
 |  |  |  |  |  |  |  |  |  |  | 110 | 4586 |  | 113 | 68298 |  | 111 | 23111
 |  |  |  |  |  |  |  |  |  |  | 111 | 23330 |  | 114 | 12257 |  | 113 | 53636
 |  |  |  |  |  |  |  |  |  |  | 112 | 11906 |  |  |  |  | 114 | 563
Spreadsheet: 79864d1280127096-conditional-formating-mapsheetname-culturalheritage
Sheet: Data

MapName | SiteName | SiteType | Painting | Engraving | Burial | StoneArrangement | EarthenArrangement | [NAME] | ScarredCarvedTree | HearthOven | [NAME] | ShellMidden | ArtefactScatter | Well | WeirFishTrap | AxeGrindingGroove | Dwelling | StoryPlace | LandscapeFeature | ContactSite | ResourceArea | CulturalSite | Other | MaterialNone | MaterialStone | MaterialShell | MaterialBone | [NAME] | MaterialVegetable | MaterialCharcoal | EuropeanMaterial | [NAME] | OtherMaterial | Structure | SiteDescription | LGA | RecorderName | Recorddate | IndigenousConsultation | Contact | FirstReport | SecondReport | LocationDataAccuracy | Zone | Scale | MapSheetName | MapDatum | PreGDA94Easting | PreGDA94Northing | PreGDA94LatitudeDecimal | PreGDA94LongitudeDecimal | PreGDA94LatitudeDeg | PreGDA94LatitudeMin | PreGDA94LatitudeSec | PreGDA94LongitudeDeg | PreGDA94LongitudeMin | PreGDA94LongitudeSec | GDA94EastingGDA | GDA94NorthingGDA | GDA94LatitudeDecimalGDA | GDA94LongitudeDecimalGDA | GDA94LatitudeDegGDA | GDA94LatitudeMinGDA | GDA94LatitudeSecGDA | GDA94LongitudeDegGDA | [NAME] | GDA94LongitudeSecGDA
Spreadsheet: 73284d1273912702-automatic-number-genaretion-all-numbers-between
Sheet: Sheet1

 | 3 | 27
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
Spreadsheet: 288674d1389277191-how-to-extract-unique-numbers-from-a-list-and-sort-them-by-date-or-age-test-list-number-ndmv2
Sheet: Φύλλο1

number | name1 | [NAME] | age | phone number | date | Dup? | helper | Keeper
278164 | ΑΛΕΞΙΟΥ | ΑΠΟΣΤΟΛΟΣ | 56 | 6906241928 | 2013-04-28 00:00:00
314168 | ΡΙΤΤΑ | ΝΙΚΟΛΕΤΑ | 55 | 6906241928 | 2013-07-07 00:00:00
276354 | ΚΕΛΟ | ΝΤΕΙΒΙΝΤ | 10 | 6984940786 | 2013-03-28 00:00:00
273526 | ΜΑΛΕΗ | ΝΙΚΟΛΑΟΣ | 30 | 6984940786 | 2013-02-16 00:00:00
313973 | ΜΕΛΑΣ | ΛΕΩΝ | 60 | 6984940786 | 2013-07-02 00:00:00
319151 | ΒΕΡΓΟΥ | ΒΑΣΙΛΙΚΗ | 40 | 6942706543 | 2012-06-28 00:00:00
313706 | ΠΕΡΑΚΗ | ΕΛΕΝΗ | 60 | 6944333450 | 2013-06-26 00:00:00
316701 | ΑΝΤΩΝΑΤΟΥ |  | 30 | 6944445382 | 2012-04-18 00:00:00
318026 | ΚΟΥΚΟΥΤΣΗΣ | ΤΗΛΕΜΑΧΟΣ | 20 | 6944834332 | 2012-05-12 00:00:00
280714 | ΤΑΤΗΣ | ΑΡΕΝ | 40 | 6946622276 | 2013-06-18 00:00:00
245184 | ΑΒΑΠΤΙΣΤΟ | [NAME] | 33 | 6947434752 | 2012-08-10 00:00:00
245127 | ΣΑΡΙΔΑΚΗΣ | ΑΒΑΠΤΙΣΤΟ | 20 | 6950514384 | 2012-08-05 00:00:00
271475 | ΜΑΓΓΙΝΑΣ | - | 20 | 6955099985 | 2013-01-17 00:00:00
315784 | MAC FARLEY | LEONARDO | 20 | 6972550865 | 2012-04-11 00:00:00
319598 | [NAME] | ΑΒΑΠΤΙΣΤΟ | 44 | 6972648522 | 2012-07-30 00:00:00
275641 | ΜΠΑΚΑ | ΑΒΑΠΤΙΣΤΟ | 20 | 6972882192 | 2013-03-18 00:00:00
261154 | ΚΟΡΕΞΙΑΝΙΔΟΥ | - | 50 | 6974879427 | 2012-07-29 00:00:00
273003 | ΜΕΛΙΣΣΑΡΗΣ | ΕΥΑΓΓΕΛΟΣ | 50 | 6982160551 | 2012-08-01 00:00:00
Spreadsheet: 6e5645b5-51be-4cd2-8c27-18a9d5151607
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2932 | 13684 | Team I | Germany | GER | 0 | 00:37:30 | 00:00:00 | 00:38:32 | 00:00:00 | 00:35:42 | 1 | 01:51:45
2932 | 14078 | Team I | Norway | NOR | 0 | 00:37:53 | 00:00:00 | 00:38:05 | 00:00:00 | 00:36:34 | 2 | 01:52:32
2932 | 11835 | Team I | Austria | AUT | 0 | 00:37:46 | 00:00:00 | 00:42:03 | 00:00:00 | 00:36:55 | 3 | 01:56:45
2932 | 11830 | Team I | Italy | ITA | 0 | 00:40:05 | 00:00:00 | 00:39:48 | 00:00:00 | 00:38:01 | 4 | 01:57:54
2932 | 14169 | Team I | United States | USA | 0 | 00:40:54 | 00:00:00 | 00:41:48 | 00:00:00 | 00:41:59 | 5 | 02:04:41
Spreadsheet: 773237d1647724476-vlookup-and-if-functions-example
Sheet: By Employee

Employee ID | Task Order | Employee Name | 2021-12-15 00:00:00 | 2021-12-31 00:00:00 | 2022-01-15 00:00:00 | 2022-01-31 00:00:00 | 2022-02-14 00:00:00 | 2022-02-28 00:00:00 | 2022-03-15 00:00:00 | 2022-03-31 00:00:00 | 2022-04-15 00:00:00
 |  |  | 80 | 88 | 80 | 80 | 80 | 72 | 88 | 96 | 88
 | [NAME], [NAME] |  |  |  |  |  |  |  |  |  |  |  | Answer:
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | [NAME], [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 01 AA.AD | [NAME], [NAME] | 0 | 0 | 0 | 5 | 0 | 0 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  | 1001 | 02 AC.AD | [NAME], [NAME] | 0 | 5 | 5 | 5 | 5 | 5 | 5
 |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
2403 | Doe, [NAME] |  |  |  |  |  |  |  |  |  |  |  | 2403 | Doe, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 01 AA.AD | Doe, [NAME] | 0 | 0 | 0 | 0 | 0 | 9 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | 2403 | 02 AC.AD | Doe, [NAME] | 0 | 10 | 10 | 10 | 10 | 10 | 10
 |  | Total Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Total Hours:
 |  | Extra Hours: |  |  |  |  |  |  |  |  |  |  |  |  | Extra Hours:
 | Fisher, Mary
 |  | Total Hours:
 |  | Extra Hours:
1920 | [NAME], [NAME]
 |  | Total Hours:
 |  | Extra Hours:
Spreadsheet: 121693d1316294000-copy-multiple-rows-to-separate-worksheet-based-on-cell-value-sample
Sheet: Sheet1

Product code | description | Date | Solids | pH | operator
99 | tank 1 | 2011-08-01 00:00:00 | 56 | 4 | jk
33 | Front gate | 2011-04-05 00:00:00 | 71 | 7.4 | ed
56 | water outlet #1 | 2011-09-03 00:00:00 | 14 | 1.8 | nb
78 | south side | 2011-02-04 00:00:00 | 54 | 8.1 | xn
99 | tank 1 | 2011-01-09 00:00:00 | 72 | 5.1 | ed
33 | Front gate | 2011-06-03 00:00:00 | 48 | 0.42 | ol
99 | tank 1 | 2011-06-01 00:00:00 | 21 | 4 | us
56 | water outlet #1 | 2011-05-24 00:00:00 | 9 | 3 | zo
78 | south side | 2011-08-16 00:00:00 | 0.5 | 5 | pf
33 | Front gate | 1900-01-08 09:36:00 | 93 | 2.9 | jh
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: ΤΥΡΟΚΟΜΙΚΑ

ΤΥΡΟΚΟΜΙΚΑ
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
[NAME] |  |  | ΕΝΤΑΜ ΤΡΙΜΜΕΝΟ | ΚΙΛΑ
ΦΕΤΑ ΔΟΧΕΙΟ ΜΥΤΙΛΗΝΗΣ | ΚΙΛΑ |  | ΡΕΓΓΑΤΟ ΣΚΛ. ΤΥΡΙ ΙΝVERTIA | ΚΙΛΑ
ΦΕΤΑ ΚΟΛΙΟΣ ΤΑΠΕΡ 4ΚΛ | ΤΕΜΑΧΙΑ |  | EMMENTAL ΓΕΡΜΑΝΙΑΣ | ΚΙΛΑ
[NAME] 100ΓΡ | TEMAXIA |  | ΜΠΛΕ ΤΥΡΙ ΔΑΝΙΑΣ (ΡΟΚΦΟΡ) | ΚΙΛΑ
ΦΕΤΑ ΔΟΧΕΙΟ ΕΒΡΟΥ ΔΟΧ. 15ΚΛ | ΚΙΛΑ |  | ΜΠΛΕ ΤΥΡΙ ΔΑΝΙΑΣ ΦΡΑΝΤΖ. (ΡΟΚΦΟΡ) | ΚΙΛΑ
ΦΕΤΑ ΔΟΧΕΙΟ ΕΒΡΟΥ ΔΟΧ. 7ΚΛ | ΚΙΛΑ |  | [NAME] ([NAME]) | ΚΙΛΑ
ΛΕΥΚΟ ΤΥΡΙ ΑΓΕΛΑΔΟΣ | ΚΙΛΑ |  | GRAN MORAVIA ΙΤΑΛΙΑΣ (ΠΑΡΜΕΖΑΝΑ) | ΚΙΛΑ
ΤΥΡΙ ΠΡΟΒΕΙΟ ΔΟΧΕΙΟ | ΚΙΛΑ |  | [NAME] (ΠΑΡΜΕΖΑΝΑ) | ΚΙΛΑ
ΗΜΙΣΚΛΗΡΑ |  |  | ΤΣΕΝΤΑΡ ΣΕ ΦΟΡΜΑ 2.5ΚΛ | ΚΙΛΑ
ΗΜΙΣΚΛΗΡΟ ΤΥΡΙ ΜΕΤΕΩΡΑ | ΚΙΛΑ |  | [NAME] ΦΙΛΑΔΕΛΦΕΙΑ 2ΚΛ | ΤΕΜΑΧΙΑ
ΗΜΙΣΚΛΗΡΟ ΤΥΡΙ ΚΑΦΑΣΩΤΟ | ΚΙΛΑ |  | [NAME]. 125ΓΡ. ΣΕ ΝΕΡΟ | ΤΕΜΑΧΙΑ
ΓΙΑΟΥΡΤΙΑ |  |  | MOZZARELLA  ΦΡΑΝΤΖΟΛΑ 40% ΒΕΛΓΙΟΥ | ΚΙΛΑ
ΕΔΕΣΜΑ ΓΙΑΟΥΡΤΙΟΥ FULL 5ΚΛ | ΚΙΛΑ |  | ΓΑΛΑΤΑ
ΕΔΕΣΜΑ ΚΟΛΙΟΣ 5ΚΛ | ΚΙΛΑ |  | ΓΑΛΑ ΕΒΑΠΟΡΕ 410 ΓΡ. FRISIAN COW | ΤΕΜΑΧΙΑ
ΚΑΣΕΡΙΑ ΓΡΑΒΙΕΡΕΣ |  |  | ΓΑΛΑ ΕΒΑΠΟΡΕ ΟΛΛ. 410ΓΡ. EASY OPEN | ΤΕΜΑΧΙΑ
ΓΡΑΒΙΕΡΑ ΚΡΗΤΗΣ 3ΚΛ ΠΟΠ | ΚΙΛΑ |  | ΓΑΛΑ Μ.Δ. 3,5% ΛΙΠ. 1LT ΓΕΡΜ. | ΤΕΜΑΧΙΑ
ΓΡΑΒΙΕΡΑ ΝΑΞΟΥ 3ΚΛ ΠΟΠ | ΚΙΛΑ |  | ΓΑΛΑ Μ.Δ. 1,5% ΛΙΠ. 1LT ΓΕΡΜ. | ΤΕΜΑΧΙΑ
ΚΕΦ/ΡΙΑ ΣΚΛΗΡΑ ΤΥΡΙΑ |  |  | ΓΑΛΑ ΤΥΡΑΣ 3,5% ΛΙΠ. 1LT | ΤΕΜΑΧΙΑ
ΣΚΛΗΡΟ ΤΥΡΙ ΡΟΔΑ 40% | ΚΙΛΑ |  | ΓΑΛΑ ΤΥΡΑΣ 1,5% ΛΙΠ. 1LT | ΤΕΜΑΧΙΑ
ΣΚΛΗΡΟ ΤΥΡΙ ΡΟΔΑ 45% | ΚΙΛΑ |  | ΚΡΕΜΕΣ ΓΑΛΑΚΤΟΣ
[NAME] ΦΡΑΝΤΖΟΛΑ 45% ΒΟΣΚΟΤ. | ΚΙΛΑ |  | [NAME] 2LT | ΤΕΜΑΧΙΑ
[NAME] ΜΠΑΣΤ.45%ΛΙΠ | ΚΙΛΑ |  | [NAME]. 1,5LT 35% ΛΙΠ. | ΤΕΜΑΧΙΑ
[NAME] 45% ΚΑΡΑΒΑΚΙ | ΚΙΛΑ |  | ΚΡΕΜΑ ΓΑΛΑΚΤΟΣ 23-25% ΛΙΠ. 1LT | ΤΕΜΑΧΙΑ
ΔΙΑΦΟΡΑ ΤΥΡΟΚΟΜΙΚΑ |  |  | ΣΑΝΤΙΓΙ ΣΠΡΕΥ 700ML DEBIC | ΤΕΜΑΧΙΑ
ΓΚΙΖΑ | ΚΙΛΑ |  | ΣΑΝΤΙΓΙ ΣΠΡΕΥ 500ML ΓΕΡΜ. | ΤΕΜΑΧΙΑ
ΧΑΛΟΥΜΙ ΚΥΠΡΟΥ (≈230gr/τεμ.) | ΚΙΛΑ
ΧΑΛΟΥΜΙ ΠΛΑΚΑ 1ΚΛ | ΚΙΛΑ
ΑΝΘΟΤΥΡΟ | ΚΙΛΑ
ΜΑΡΓΑΡΙΝΗ 2ΚΛ | ΤΕΜΑΧΙΑ
ΒΟΥΤΥΡΟ ΜΕΡ. 10ΓΡ LURPAK 600 ΤΕΜ. | ΚΙΒΩΤΙΟ
ΤΥΡΙΑ ΕΙΣΑΓΩΓΗΣ
ΓΚΟΥΝΤΑ BLOCK 48% ΛΙΠΑΡΑ ΟΛΛΑΝ | ΚΙΛΑ
ΓΚΟΥΝΤΑ ΦΡΑΤΖΟΛΑ ΓΕΡΜ. | ΚΙΛΑ
ΓΚΟΥΝΤΑ ΦΕΤΕΣ ΣΥΣΚ. | ΚΙΛΑ
ΓΚΟΥΝΤΑ ΤΡΙΜΕΝΗ (2ΚΙΛΑ) ΣΥΣΚΕΥΑΣΜ. | ΚΙΛΑ
ΕΝΤΑΜ BLOCK ΟΛΛΑΝΔΙΑΣ | ΚΙΛΑ
ΕΝΤΑΜ ΦΡΑΝΤΖΟΛΑ | ΚΙΛΑ
ΕΝΤΑΜ ΓΕΡΜ. Κ/Σ | ΚΙΛΑ
Spreadsheet: 793357d1661429118-compare-two-lists-find-unique-non-duplicate-values-make-new-list-with-those-excellaborer_sampleworkbook
Sheet: Mailing List

Mailing List
First Name | Last Name | Emails
[NAME] | King | [EMAIL]
[NAME] | Langly | [EMAIL]
[NAME] | [NAME] | [EMAIL]
[NAME] | Singer | [EMAIL]
[NAME] | Lamare | [EMAIL]
Louis | [NAME] | [EMAIL]
[NAME] | Bourdin | [EMAIL]
Spreadsheet: 740314d1626276179-first-contact-resolution-calculation-fcr-calc-call-data-example-1
Sheet: Sheet1

 | Call Back Window: |  |  | 3 | Days
 | Call Date | Agent ID | Name | ANI | Resolved
 | 2021-07-01 00:00:00 | 123456 | Scott | fa | 0 |  |  |  |  |  |  |  |  |  | FCR Score By Agent
 | 2021-07-01 00:00:00 | 123456 | Scott | 2222 | 1 |  |  |  |  |  |  |  |  |  | Agent Name | Calls | Resolved Calls | % Repeat Call Rate
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 3333 | 1 |  |  |  |  |  |  |  |  |  | Scott
 | 2021-07-02 00:00:00 | 123457 | [NAME] | 1111 | 1 |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-03 00:00:00 | 123458 | Jennie | 5555 | 0 |  |  |  |  |  |  |  |  |  | Jennie
 | 2021-07-03 00:00:00 | 123460 | [NAME] | 5555 | 1 |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123456 | Scott | 6666 | 1 |  |  |  |  |  |  |  |  |  | [NAME]
 | 2021-07-04 00:00:00 | 123459 | [NAME] | 7777 | 0
 | 2021-07-05 00:00:00 | 123459 | [NAME] | 1111 | 1
 | 2021-07-06 00:00:00 | 123457 | [NAME] | 7777 | 1
 | 2021-07-07 00:00:00 | 123458 | Jennie | 8888 | 1
 | 2021-07-08 00:00:00 | 123459 | [NAME] | 2222 | 1
 | 2021-07-09 00:00:00 | 123458 | Jennie | 1111 | 1
Spreadsheet: fletcher_sturm__11022__Trading Universe
Sheet: Sheet1

 | VaR Portfolio | Commodity | Trader | Book | Instrument | Location | Tenor | Liquidity (volume/day) | Best Risk Mitigator
 |  | NG | Lavo | NG Price | Futures | HH -Hub | 1 - 7 years | 10,000k/day
 |  | NG | Lavo | IM-Gas Daily | Swing swaps | HEHUB | <30 days | 1,000k/day
Spreadsheet: 766630d1643973641-day-count-for-act-365-fixed-convention-day-count-aligw
Sheet: Sheet1

2020-12-31 00:00:00 |  | ACT/365 for range in Column A:
 |  |  | Start: | 2022-06-01 00:00:00
 |  |  | End: | 2024-12-31 00:00:00
Spreadsheet: 168102d1342215752-sorting-and-returning-values-using-formula-usehelper
Sheet: Sheet1

 | Math | English | Spanish |  | Math | English | Spanish |  | yellow cells  uniqe ranks
anne | 85 | 90 | 95 |  | 3 | 4 | 4
tom | 85 | 87 | 89 |  | 2 | 2 | 1
sue | 98 | 89 | 93 |  | 4 | 3 | 3
howard | 70 | 75 | 93 |  | 1 | 1 | 2
Math | English | Spanish
sue | anne | anne
anne | sue | sue
tom | tom | howard
howard | howard | tom
Spreadsheet: 744509d1629280263-vcard-to-excel-two-way-lookup-skip-blanks-vcard-export-sample
Sheet: Sheet2

Last Name | First Name | WORK | HOME | FAX | CELL |  | Last Name | First Name | TEL CELL | TEL PREF | TEL HOME | TEL WORK | TEL FAX | TEL A.M.
 |  |  | PREF |  |  |  | Bgood | [NAME] | (123) 156-1234 | [NAME]
 |  |  |  |  |  |  | Football | [NAME] | (456) 789-1234 |  | (123) 123-4567 | (234) 234-4567 | (345) 678-9123
 |  |  |  |  |  |  | Schmo | [NAME] | (001) 987-6543 |  | PREF
I would like to populate the above using functions. My real Sheet 1 has 16,000 rows
Spreadsheet: 738669d1625163612-average-first-two-numerical-entries-in-a-row-aaa-excel-formula-sample
Sheet: Sheet1

Last | First | Member No. | Broad 1 | Heart 1 | Cloud 1 | [NAME] | Blue | Cody 1 | Broad 2 | Heart 2 | HiLine | Heart 3 | Cloud 2 | [NAME] | Badger | AEM | Broad 4 | [NAME] | Broad 5 | Cloud 3 | [NAME] | Cloud 4 | Broad 6 | [NAME] | Cody 3 | Broad 7 | [NAME] | [NAME] | Heart 4 | Heart 5 | [NAME] | Broad 8 | Cody 5 | Cloud 5 | Broad 9 | Broad 10 | Qualify Average
Cameron | [NAME] | W003 |  |  | 58.78 |  | 67.19 | 63.47 |  |  |  |  |  |  |  | 93.22
[NAME] | [NAME] | W115 |  |  | 87.4 |  |  | 69.94 |  |  |  |  | 81.99 |  | 77.27 | 77.54
Spreadsheet: 107207d1304427354-need-to-calculate-certain-cells-based-on-what-one-cell-shows-profits
Sheet: Sheet1

24-49 | 50-99 | 100-199 | 200-499 | Qty | Profit
7 | 6 | 5.5 | 5 | 50
8 | 7 | 5 | 4.5 | 50
9 | 8 | 4.5 | 4 | 50
10 | 9 | 4 | 3.5 | 50
Percentage Calc |  | 1.35
Spreadsheet: 870979d1717448753-all-data-in-one-line-needs-to-be-sorted-into-separate-entries-of-the-same-id-for-excel-forum
Sheet: Tab 1 - Current Format

 | QU_1 | QU_2 | QU_3 | QU_4 | QU_5 | QU_6 | QU_7 | QU_8 | QU_9 | QU_10
Record ID | I love this website | I  am a fan of bonjovi | I live in the UK | I do not get sea sick | I am dog lover | I drive a car | I love my job | I have a smarphone | my laptop is old | I love going to the cinemas
1 | Agree | Disagree | Agree | Disagree | Agree | Agree | Agree | Not sure | Agree | Agree
2 | Disagree | Not sure | Disagree | Not sure | Agree | Not sure | Not sure | Not sure | Agree | Disagree
3 | Agree | Disagree | Disagree | Disagree | Disagree | Not sure | Disagree | Agree | Agree | Agree
4
5
6
7
8
etc
This is the currem format and there are over 6000 Record ID's
Spreadsheet: 525849d1498949863-closest-avarage-match-es-battery-log
Sheet: Battery Log

[NAME]
Date | Brand | Type | ID | # | Pair | mAh Label | Measured |  | % remaining | Application
2015-02-05 00:00:00 | [NAME] | AA | HR-3UTGA | 1 |  | 2000 | 1940
2015-02-05 00:00:00 | [NAME] | AA | HR-3UTGA | 2 |  | 2000 | 1925
2015-02-12 00:00:00 | [NAME] | AA | HR-3UTGA | 3 |  | 2000 | 1938
2015-02-12 00:00:00 | [NAME] | AA | HR-3UTGA | 4 |  | 2000 | 1933
2015-02-05 00:00:00 | [NAME] | AA | HR-3UWXA | 1 |  | 2500 | 2456
2015-02-05 00:00:00 | [NAME] | AA | HR-3UWXA | 2 |  | 2500 | 2436
2015-02-12 00:00:00 | [NAME] | AA | HR-3UWXA | 3 |  | 2500 | 2470
2015-02-12 00:00:00 | [NAME] | AA | HR-3UWXA | 4 |  | 2500 | 2460
2015-03-11 00:00:00 | [NAME] | AAA | BK-4MCCA4BA | 1 |  | 800 | 795
2015-03-11 00:00:00 | [NAME] | AAA | BK-4MCCA4BA | 2 |  | 800 | 801
2015-03-11 00:00:00 | [NAME] | AAA | BK-4MCCA4BA | 3 |  | 800 | 792
2015-03-11 00:00:00 | [NAME] | AAA | BK-4MCCA4BA | 4 |  | 800 | 788
Sunbeam
Date | Brand | Type | ID | # |  | mAh Label | Measured |  | % remaining
 | Sunbeam | AA |  |  |  | 800
 | Sunbeam | AA |  |  |  | 800
 | Sunbeam | AA |  |  |  | 800
 | Sunbeam | AA |  |  |  | 800
Spreadsheet: 849959d1700326138-calculating-paydates-business-rules-for-sat-sun-mon-calculate-pay-dates
Sheet: Sheet1

Start Date: | 2023-12-31 00:00:00
Pay Day | Pay Date | EOMonth | Business Rule | Actual Pay Date (Manual Entry) | Actual Pay Date (Automated)
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-01-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-01-20 00:00:00
7th |  |  | Ok | 2024-02-07 00:00:00
22nd |  |  | Ok | 2024-02-22 00:00:00
7th |  |  | Ok | 2024-03-07 00:00:00
22nd |  |  | Ok | 2024-03-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-04-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-04-20 00:00:00
7th |  |  | Ok | 2024-05-07 00:00:00
22nd |  |  | Ok | 2024-05-22 00:00:00
7th |  |  | Ok | 2024-06-07 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-06-21 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-07-05 00:00:00
22nd |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-07-20 00:00:00
7th |  |  | Ok | 2024-08-07 00:00:00
22nd |  |  | Ok | 2024-08-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-09-06 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-09-20 00:00:00
7th |  |  | IF pay day falls on a Monday, THEN pay date will be on the prior Saturday. | 2024-10-05 00:00:00
22nd |  |  | Ok | 2024-10-22 00:00:00
7th |  |  | Ok | 2024-11-07 00:00:00
22nd |  |  | Ok | 2024-11-22 00:00:00
7th |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-12-06 00:00:00
22nd |  |  | IF pay day falls on weekend (Saturday or Sunday), THEN pay date will be on the prior Friday. | 2024-12-20 00:00:00
Spreadsheet: 214895d1361181213-insert-absolute-reference-in-formula-excel-2010-book1-2-
Sheet: M drum minim

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1 | 0 | 2539 | 2130 | 3231 | 3813 | 3450 | 6222 | 3842 | 5131 | 6752
2 | 2539 | 0 | 1031 | 1377 | 2183 | 3221 | 5504 | 3235 | 4107 | 5154
3 | 2130 | 1031 | 0 | 2278 | 3084 | 3743 | 6339 | 3901 | 5008 | 6055
4 | 3231 | 1377 | 2278 | 0 | 806 | 2818 | 4127 | 2252 | 2730 | 3777
5 | 3813 | 2183 | 3084 | 806 | 0 | 2012 | 3321 | 1446 | 1924 | 3374
6 | 3450 | 3221 | 3743 | 2818 | 2012 | 0 | 2772 | 733 | 1681 | 3643
7 | 6222 | 5504 | 6339 | 4127 | 3321 | 2772 | 0 | 2438 | 1657 | 3766
8 | 3842 | 3235 | 3901 | 2252 | 1446 | 733 | 2438 | 0 | 1347 | 2910
9 | 5131 | 4107 | 5008 | 2730 | 1924 | 1681 | 1657 | 1347 | 0 | 2109
10 | 6752 | 5154 | 6055 | 3777 | 3374 | 3643 | 3766 | 2910 | 2109 | 0
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
1
2
3
4
5
6
7
8
9
10
 | 37110 | 25812 | 30970 | 20017 | 17196 | 18328 | 21854 | 15795 | 16117 | 23509
 | 25812 | 28351
 | 30970 | 26911
 | 20017 | 20080
 | 17196 | 16453
 | 18328 | 15788
 | 21854 | 17763
 | 15795 | 13821
 | 16117 | 13665
 | 23509 | 19136