tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 734830d1622535442-its-a-bit-harder-than-i-thought-match-that-contains-recipes-cost-ans
Sheet: Setup

Product code | Product name
1000 | Boudin blanc truffé
 | Faux filet
 | Cumin
 | Mâche
 | Carotte Bio
 | Tournedos
 | Compote fraise
 | Antipasti aux tomates
 | [NAME] brisée
 | [NAME]
 | Saucisse de toulouse au muscadet
 | Lait de coco
 | [NAME]
 | [NAME] fleur
 | Patate douce Bio
 | Panais
 | Noisette
 | Patate douce
 | [NAME]
 | Echalotte
 | Oignon Bio
 | Oignon
 | Fleur de sel de noirmoutier
 | Vanille fraîche
 | Pomme de terre Grenaille
 | Pomme de terre de Noirmoutier
 | Saucisse
 | Saucisse aux herbes
 | Beurre truffé
 | Tagliatelle
 | Pomme de terre Bio
 | Effiloché de canard
 | Pomme de terre purée
 | Châtaignes
 | Pomme de terre
 | [NAME]
 | Sésame
 | [NAME]
 | Poireau
 | Ail Bio
 | Ail
 | [NAME]
 | [NAME]
 | Piment d'Espelette
 | Crème fraîche crue
 | Lard fumé
 | Salicorne
 | [NAME]
 | Epinard
 | Pignon de pin
 | [NAME]
 | [NAME]
 | Beurre demi-sel
 | Crème liquide
 | Daurade
 | [NAME]
 | Saint Jacques
 | Palourde
 | Maigre
 | Turbot
 | [NAME]
 | Origan
 | Herbes de Provence
 | Crevette grise
 | Bœuf haché
 | Tomate Bio
 | Tomate
 | Parmesan
 | Cuisse de poulet
 | Blanc de poulet
 | Œuf *6
 | Emmental râpé
 | Butternut
 | [NAME]
 | Parmesan râpé
 | Chair à saucisses
 | Levure de boulanger
 | Cantal râpé
 | Pain Pita
 | Cuisse de lapin
 | [NAME] à l'ancienne
 | Poudre de coco
 | [NAME]
 | Sauce soja sucrée
 | Sauce soja salée
 | Endive Bio
 | Endive
 | Salade
 | [NAME]
 | Sole
 | Ciboulette
 | Filet de pintade
 | [NAME]
 | Champignon
 | Curcuma
 | Canelle
 | Shiitaké
 | Amande éfilée
 | [NAME]
 | Rôti de porc
 | Chorizo
 | Pleurote
 | Thym
 | Laurier
 | [NAME] de tomate
 | [NAME] déshydratée
 | Morille fraîche
 | Miel
 | Semoule de blé
 | Concombre Bio
 | Pomme Bio
 | Pomme
 | [NAME]
 | [NAME]
 | Haricots rouges
 | Estragon
 | Concombre
 | Cabillaud
 | Filet Mignon de porc
 | Farine
 | Citron vert
 | Lieu
 | Sauce coco/curry potpote
 | Gingembre
 | Tomate concassée
 | Piment doux
 | Orange
 | Piment
 | Riz de camargue
 | Riz long
 | Riz rong
 | Lardons
 | [NAME] feuilletée
 | Bouillon de volaille
 | Truite
 | Bouillon de légumes
 | Citronelle
 | Muscade
 | Merlu
 | Haricots verts
 | Haricots verts Bio
 | Asperges Bio
 | Asperges
 | Coriandre
 | Menthe
 | [NAME]
 | Pain à burger
 | Oignon rouge Bio
 | Oignon rouge
 | Basilic
 | Citron jaune Bio
 | Polenta
 | Olives vertes
 | Nouille de riz
 | Citron jaune
 | Tomate cerise Bio
 | Tomate cerise
 | [NAME]
 | Mogette
 | Germe de soja
 | Sauce nuoc mam
 | Steak de bœuf
 | [NAME]
 | Onglet de bœuf
 | Gruyère râpé
 | Navets Bio
 | Navets
 | Curry
 | Garam
 | Barbue
 | Sardine
 | Betterave Bio
 | Betterave
 | Fourme d'Ambert
 | Lasagne
 | Coulis de tomate
 | [NAME] Bio
 | [NAME]
 | Quinoa
 | [NAME]
 | Courgette
 | Fenouil Bio
 | Fenouil
 | Lentilles corail
 | Cardamome
 | Pois chiches Bio
 | Pois chiches
 | Petits pois Bio
 | Petits pois
Spreadsheet: 35503d1233109799-some-type-of-lookup-reduce-list-autocomplete-with-hidden-validation-list
Sheet: Sheet1

 |  | Example | B21
 |  |  | WT181236L
 |  |  | WT181236L.M
 |  |  | WT181236R
 |  |  | WT181236R.M
 |  |  | WT181242L
 |  |  | WT181242L.M
 |  |  | WT181242R
 |  |  | WT181242R.M
 |  |  | WT181248L
 |  |  | WT181248L.M
 |  |  | WT181248R
 |  |  | WT181248R.M
 |  |  | WT181836L
 |  |  | WT181836L.M
 |  |  | WT181836R
 |  |  | WT181836R.M
 |  |  | WT181842L
 |  |  | WT181842L.M
 |  |  | WT181842R
 |  |  | WT181842R.M
 |  |  | WT181848L
 |  |  | WT181848L.M
 |  |  | WT181848R
 |  |  | WT181848R.M
 |  |  | WT241236BUTT
 |  |  | WT241236BUTT.M
 |  |  | WT241242BUTT
 |  |  | WT241242BUTT.M
 |  |  | WT241242L
 |  |  | WT241242L.M
 |  |  | WT241242R
 |  |  | WT241242R.M
 |  |  | WT241248BUTT
 |  |  | WT241248BUTT.M
 |  |  | WT241248L
 |  |  | WT241248L.M
 |  |  | WT241248R
 |  |  | WT241248R.M
 |  |  | WT241836BUTT
 |  |  | WT241836BUTT.M
 |  |  | WT241842BUTT
 |  |  | WT241842BUTT.M
 |  |  | WT241842L
 |  |  | WT241842L.M
 |  |  | WT241842R
 |  |  | WT241842R.M
 |  |  | WT241848BUTT
 |  |  | WT241848BUTT.M
 |  |  | WT241848L
 |  |  | WT241848L.M
 |  |  | WT241848R
 |  |  | WT241848R.M
 |  |  | WT271236
 |  |  | WT271236.M
 |  |  | WT271242
 |  |  | WT271242.M
 |  |  | WT271248
 |  |  | WT271248.M
 |  |  | WT271836
 |  |  | WT271836.M
 |  |  | WT271842
 |  |  | WT271842.M
 |  |  | WT271848
 |  |  | WT271848.M
 |  |  | WT301236
 |  |  | WT301236.M
 |  |  | WT301242
 |  |  | WT301242.M
 |  |  | WT301248
 |  |  | WT301248.M
 |  |  | WT301836
 |  |  | WT301836.M
 |  |  | WT301842
 |  |  | WT301842.M
 |  |  | WT301848
 |  |  | WT301848.M
 |  |  | WT361236
 |  |  | WT361236.M
 |  |  | WT361242
 |  |  | WT361242.M
 |  |  | WT361248
 |  |  | WT361248.M
 |  |  | WT361836
 |  |  | WT361836.M
 |  |  | WT361842
 |  |  | WT361842.M
 |  |  | WT361848
 |  |  | WT361848.M
 |  |  | WTCD15
 |  |  | WTCD18
 |  |  | WTCD21
 |  |  | WTCD24
 |  |  | WTCDK15
 |  |  | WTCDK18
 |  |  | WTCDK21
 |  |  | WTCDK24
 |  |  | WTDK12
 |  |  | WTDK18
 |  |  | WTEP84
 |  |  | WTEP90
 |  |  | WTEP96
 |  |  | WTH1515
 |  |  | WTH2415
 |  |  | WTH3015
 |  |  | WTH3615
 |  |  | WTWR
 |  |  | WTWR
 |  |  | WTWR
 |  |  | WVEP
 |  |  | WVSDC6
 |  |  | WWEP30
 |  |  | WWEP42
 |  |  | WWR630
 |  |  | WWR636
 |  |  | WWR642
 |  |  | WZA1230L
 |  |  | WZA1230R
 |  |  | WZA1242L
 |  |  | WZA1242R
 |  |  | WZAS1212
 |  |  | WZAS1212
 |  |  | WZEP84
 | 1 |  | WZEP84 |  | type WZE and the rest will appear
 | 2
 |  |  |  |  | Hide the validation list directly above the column where the
 |  |  |  |  | validation will occur to create a continuous section with
 |  |  |  |  | no blanks, this allows the built-in [NAME] function
 |  |  |  |  | in Excel to operate if you enable in TOOLS > OPTIONS
Spreadsheet: 80339d1280504159-index-problem-index-problem
Sheet: Dept ID

PSGL DeptCode | PSG Dept Name
1148 | CB Program
8300 | TPS Datacentre Serv-In-house
8319 | Service Management – Local IT
8311 | Country Technology
8314 | TPS Desktop Services
8315 | Communications - Voice
1169 | CB Ops-Securities Svc
8318 | TPS Datacentre Serv-Outsource
8343 | [NAME] IT Cost
8310 | Technology & Operations
1173 | CB Credit Control
1177 | CB Credit Approval
1174 | CB Credit Mgmt
1637 | CreditCards-Recoveries
1699 | Personal Loan-Recoveries
1433 | Mortgage-Collection
1457 | Auto-Recoveries
2022 | WM Recoveries
1214 | [NAME]
1761 | CCPL-IS
1803 | BRDB, Service Delivery
1206 | [NAME] Product
1834 | BRDB-Priority Bkg,[NAME]
1182 | CB Service Quality
1809 | BRDB, Phone Banking
1808 | BRDB, Internet Banking
1602 | CCPL,[NAME]
1402 | M&A,[NAME]
2002 | WM-Mgmt
1202 | [NAME], [NAME]
1813 | BRDB-Direct Sales
1805 | BRDB, Branch Mgmt
1181 | Business Intelligence Unit
2402 | CTB–Product Strategy & Mgmt
8260 | Org Learning, General [NAME]
9371 | Central Marketing Dept
1691 | Personal Loan-Mgmt
1218 | [NAME]
1804 | BRDB, Channel Mgmt
1635 | CreditCards-Marketing
1692 | Personal Loan-Marketing
2003 | WM-Marketing
2406 | Transaction Banking-Marketing
1354 | SME-Marketing
1434 | Mortgage-Marketing
1836 | BRDB-Priority Bkg, Marketing
1018 | CB-Marketing
1763 | CCPL-Other projects
1802 | BRDB, [NAME]
1001 | Consumer Bank, Head
8349 | Systems & Process CB
1191 | CB Ops-Item Processing
1153 | CB Ops, Account Svc
1152 | CB Ops,[NAME]
1951 | BRDB-Support and Ops
1194 | Controls & Validation
1196 | Card Services
1832 | BRDB-Priority Bkg,[NAME]
1166 | CB Ops-Applicatn Processing
1163 | CB Ops-Shared Distribution
1772 | CreditCards-Ops
1168 | CB Ops-Oth Projects
1094 | CB, [NAME]
1193 | CB Ops-Loan Admin
1161 | CB Ops-Credit Documentation
1208 | [NAME]
1762 | CCPL-IT
1158 | CB Ops-Electronic Bkg
8342 | CB-Support Chq Deposit Machine
1160 | CB Ops-ATM
8121 | Central Finance Team
8150 | Business Finance,CB
8241 | HR-CB
1094 | CB, [NAME]
8643 | Legal & Compliance-CB
1011 | CB-Operational Risk
8521 | Corporate Affairs
8522 | Corporate Affairs - GM
1954 | BRDB-Shared Distributn Others
9121 | Property Management
1094 | CB, [NAME]
1094 | CB, [NAME]
8348 | CB Projects -Appln Development
8262 | Org Learning,CB
8223 | HR-Others
1094 | CB, [NAME]
9350 | DCR CCC
9351 | DCR Project
1094 | CB, [NAME]
4801 | GSAM Mgmt
1171 | CB Credit Recovery
1172 | CB Credit Collection
1178 | CB Credit Risk
1175 | CB Risk & Policy
1371 | SME Bkg Credit
1216 | [NAME]
8654 | CB TMU
Spreadsheet: chris_germany__1802__enron payment recap
Sheet: summary

 |  | Enron Billing Summary June Y-T-D
 | GMS Volume | GMS Amount |  | Enron Volume | Enron Amt |  | Volume Variance | Amount Variance
 | 54308636 | 165480773.97 |  | 49355817 | 166111380.41
Adjustments:
Overbilled Demand |  |  |  |  | -6347657
Demand not in Purchases |  | 12584710
GMS Sales | -2952073 | -10506470.06
Totals:
 |  |  |  | Enron invoice 200007JW dtd 8/8/00 |  |  | 2199546 | 7535872.3
 |  |  |  | Approx balance in GMS not paid
Spreadsheet: 865016d1712127442-sum-single-vs-combined-cell-values-test2-ans2
Sheet: Sheet1

Group | Area | Total/group |  |  | FORMULA
A1 | 10 |  |  |  |  |  | so im looking for a formula that can sum up  values until the group changes. So it would sum the values that belong to the same group
A1 | 20
A2 | 10 |  |  |  | 10
A3 | 30 |  |  |  | 30
A4 | 5 |  |  |  | 20
A4 | 10
A4 | 5
A5 | 10 |  |  |  | 10
A6 | 5 |  |  |  | 5
A7 | 10 |  |  |  | 20
A7 | 10
A8 | 5 |  |  |  | 5
A9 | 10 |  |  |  | 10
Spreadsheet: 796908d1663621220-formula-for-checking-repeat-data-example-tms
Sheet: Working Sheet

Finding | Old/New/Dropped | Date Discovered |  |  |  | D2: | =COUNTIF($A$2:$A2, $A2)
222 |  | 2022-03-31 00:00:00 |  |  |  | E2: | =IF(COUNTIF($A$2:$A2, $A2)>1, "Duplicate", "")
66546 |  | 2022-04-01 00:00:00
3233 |  | 2022-04-02 00:00:00
332 |  | 2022-04-03 00:00:00
321 |  | 2022-04-04 00:00:00
11411 |  | 2022-04-05 00:00:00
11111 |  | 2022-04-06 00:00:00
54555 |  | 2022-04-07 00:00:00
5555 |  | 2022-04-08 00:00:00
5555 |  | 2022-04-09 00:00:00
55555 |  | 2022-04-10 00:00:00
5555 |  | 2022-04-10 00:00:00
10000 |  | 2022-04-10 00:00:00
55 |  | 2022-04-13 00:00:00
200 |  | 2022-04-14 00:00:00
4666 |  | 2022-04-15 00:00:00
50 |  | 2022-04-16 00:00:00
51 |  | 2022-04-17 00:00:00
52 |  | 2022-04-18 00:00:00
53 |  | 2022-04-19 00:00:00
54 |  | 2022-04-20 00:00:00
55 |  | 2022-04-21 00:00:00
Spreadsheet: 695111d1600063040-need-help-to-find-the-serial-number-if-data-match-searching-sn-if-data-match
Sheet: Search

S/N | This is my numbers to Find S/N in Data sheet |  | Not add " ," | Index | Lookup
3 | 5787-0
2 | 987534
 | 23
 | 77
 | 123
 |  | 5467599, 987534, 0-636748-0, 1468-0,
 |  | 45677-3, 5787-0,
Spreadsheet: 330213d1404622060-copy-and-paste-filtered-data-copy-and-paste
Sheet: Sheet1

Name | Number |  |  |  |  |  |  |  | Name | Number |  | Name | Number
Scon | 25 |  |  |  |  |  |  |  |  |  |  | Scon | 25
masty | 65
Teeple | 84 |  |  |  |  |  |  |  |  |  |  | Teeple | 84
Peeply | 12
[NAME] | 145 |  |  |  |  |  |  |  |  |  |  | [NAME] | 145
[NAME] | 12
Eristo | 62
Manddo | 22
 |  |  |  |  |  |  |  |  |  |  |  | It should Show like this if I
 |  |  |  |  |  |  |  |  |  |  | 1 | First I filter only Yellow cells
 |  | How can we copy and paste filter |  |  |  |  |  |  |  |  | 2 | then I copy that Filtered cells
 |  |  |  |  |  |  |  |  |  |  | 3 | after that copying that filter cells I did Paste in same rows in J and K column
 |  | For Example I  have copied Row no. 2,4,6 fro this GREEN table and want to paste same date in J and K column (in same row [NAME] how can I do this ?
Spreadsheet: 57171d1257329663-converting-a-number-into-a-word-depending-on-several-factors-age-etc-book1
Sheet: Sheet1

Participant | Age | Age group | Sex
1 | 42 | 40-44 | Male |  |  | Age | Very low | Low | Fair | Moderate | Good | Very Good | Elite
2 | 29 | 25-29 | Female |  |  | 20 | 0 | 32 | 38 | 44 | 51 | 57 | 62
3 | 33 | 30-34 | Female |  |  | 25 | 0 | 31 | 36 | 43 | 49 | 54 | 59
4 | 46 | 45-49 | Male |  |  | 30 | 0 | 29 | 35 | 41 | 46 | 52 | 56
5 | 39 | 35-39 | Male |  |  | 35 | 0 | 28 | 33 | 39 | 44 | 49 | 54
6 | 50 | 50-54 | Male |  |  | 40 | 0 | 26 | 32 | 36 | 42 | 47 | 51
7 | 41 | 40-44 | Male |  |  | 45 | 0 | 25 | 30 | 35 | 40 | 44 | 48
8 | 39 | 35-39 | Male |  |  | 50 | 0 | 24 | 28 | 33 | 37 | 42 | 46
9 | 39 | 35-39 | Male |  |  | 55 | 0 | 22 | 27 | 31 | 35 | 40 | 43
10 | 43 | 40-44 | Female |  |  | 60 | 0 | 21 | 25 | 29 | 33 | 37 | 40
11 | 41 | 40-44 | Male
12 | 34 | 30-34 | Female |  |  | Age | Very low | Low | Fair | Moderate | Good | Very Good | Elite
13 | 0 | <20 | 0 |  |  | 20 | 0 | 27 | 32 | 37 | 42 | 47 | 51
14 | 41 | 40-44 | Male |  |  | 25 | 0 | 26 | 31 | 36 | 41 | 45 | 49
15 | 0 | <20 | 0 |  |  | 30 | 0 | 25 | 30 | 34 | 38 | 43 | 46
16 | 52 | 50-54 | Female |  |  | 35 | 0 | 24 | 28 | 32 | 36 | 41 | 44
17 | 41 | 40-44 | Male |  |  | 40 | 0 | 22 | 26 | 30 | 34 | 38 | 41
18 | 40 | 40-44 | Female |  |  | 45 | 0 | 21 | 24 | 28 | 32 | 36 | 38
19 | 35 | 35-39 | Female |  |  | 50 | 0 | 19 | 23 | 26 | 30 | 33 | 36
20 | 38 | 35-39 | Male |  |  | 55 | 0 | 18 | 21 | 24 | 28 | 31 | 33
21 | 45 | 45-49 | Male |  |  | 60 | 0 | 16 | 19 | 22 | 25 | 28 | 30
Spreadsheet: 742625d1627919791-google-sheets-if-2-criteria-are-met-display-value-from-next-column-on-other-sheet-checker-workings
Sheet: Sheet1

Timestamp | Student no | Assignment
2021-07-29 07:56:34 | 1016 | Art 3
2021-07-29 08:02:41 | 1011 | Business 7
2021-07-29 08:04:27 | 1017 | History 8
2021-07-29 08:07:05 | 1009 | French 1
2021-07-29 08:16:05 | 1017 | Maths 3
2021-07-29 08:28:46 | 1011 | English 6
2021-07-29 09:37:00 | 1009 | German 6
2021-07-29 10:10:49 | 1017 | Tech Graph 4
2021-07-29 16:33:59 | 1011 | Art 4
2021-07-30 06:14:49 | 1011 | Business 8
2021-07-30 06:27:37 | 1009 | History 9
2021-07-30 06:30:34 | 1017 | French 2
2021-07-30 06:40:51 | 1009 | Maths 4
2021-07-30 06:41:24 | 1011 | English 7
2021-07-30 06:46:50 | 1017 | German 7
2021-07-30 06:50:58 | 1017 | Tech Graph 5
2021-07-30 06:53:19 | 1009 | Art 5
2021-07-30 06:59:28 | 1017 | Business 9
2021-07-30 07:22:47 | 1009 | History 10
2021-07-30 07:24:41 | 1011 | French 3
2021-07-30 07:26:22 | 1017 | Maths 5
2021-07-30 07:41:36 | 1009 | English 8
2021-07-30 07:45:51 | 1011 | German 8
2021-07-30 07:48:04 | 1009 | Tech Graph 6
2021-07-30 07:50:44 | 1017 | Art 6
2021-07-30 07:53:28 | 1011 | Business 10
2021-07-30 08:07:15 | 1017 | History 11
2021-07-30 08:08:07 | 1009 | French 4
2021-07-30 08:10:59 | 1011 | Maths 6
2021-07-30 08:46:35 | 1011 | English 9
2021-07-31 08:10:29 | 1017 | German 9
2021-07-31 13:29:49 | 1017 | Tech Graph 7
Spreadsheet: tracy_geaccone__40220__EGS_rev
Sheet: Sheet1

ENRON GLOBAL SERVICES
4th Quarter Forecast
 |  |  |  | Previous |  | Corp
 |  | Forecast |  | Forecast |  | Forecast
ETS |  | 102 |  | 105.1 |  | 103 |  | Financing costs on new debt.
PGG |  | 54.7 |  | 28 |  | 28 |  | Previous forecast assumed $45MM moved to 2002.  Revised forecast assumes $20MM moved.
EGAS |  | -29.8 |  | -14.1 |  | -9.8 |  | Movement of companies between other Enron units.
EEOS |  | -74.7 |  | -26.6 |  | -35.9 |  | Earnings from projects being reduced to reflect current estimates.
EREC |  | 51.2 |  | 53.2 |  | 53.2 |  | Settlement with ENA for cancellation of the Power Purchase Agreement on Indian Mesa and [NAME].
Azurix |  | -19 |  | -19 |  | -17.5 |  | Adjustment for Marlin costs.
Clean Fuels |  | -21.1 |  | -21.1 |  | -21.1
 | Total
Spreadsheet: 76035d1276619455-tally-of-fields-with-entry-sample-workbook
Sheet: Sheet1

Funds | Redemptions
fds
aad | 13
ads
sd | 23423
dasfsd
dasfsd
fdas
fdasf
fs | 23423
dfas
sd
das
ads | 13431
dfsda
dsa | 13431
dsasd
[NAME]
 | Total Tally of Redemptions
 | 1
Spreadsheet: 863376d1710879581-need-help-totaling-based-on-selections-mix-id-calculator-tier
Sheet: Commercial Price Tab

Commercial Mix ID Calculator
Mix ID | Price |  | Add On | Price |  | Distance | Price |  | Tier | Price
COM301510 | 0 |  | Air | 3 |  | 1-10 | 0 |  | T1 | 121
COM351510 | 5 |  | HRWR | 5 |  | 11-20 | 5 |  | T2 | 126
COM401510 | 10 |  | 3/8 Agg | 7 |  | 21-30 | 10 |  | T3 | 131
COM451510 | 15 |  | [NAME] | 13 |  | 31-40 | 20
COM501510 | 20 |  | 1%Retard | 0
COM601510 | 30 |  | 2%Retard | 1
COM701510 | 40 |  | 3%Retard | 2
COM801510 | 50 |  | Fiber | 7
500S | 7 |  | SRA | 75
550S | 12 |  | SS | 7
600S | 17
650S | 22
700S | 27
800S | 32
900S | 37
Spreadsheet: 728547d1618504227-multiple-criteria-lookup-test-multiple-lookup
Sheet: Result

 |  |  |  |  |  | Apple | Mango | [NAME] | Apple | Mango | [NAME]
 |  |  |  |  |  | Shrawan |  |  | Bhadra
Purchase
Spreadsheet: 197125d1354215399-automatic-background-color-in-cells-with-similar-data-test
Sheet: Sheet1

BRAND | PRICE | USERID
XC | 20 | [NAME]
DFG | 22 | [NAME]
FGHJ | 13 | [NAME]
DFG | 19 | [NAME]
DFG | 16 | [NAME]
DFG | 12 | [NAME]
D | 17 | [NAME]
DFG | 8 | [NAME]
FGHJ | 17 | [NAME]
G | 17 | MIKE
DRT | 12 | MIKE
DFG | 14 | MIKE
FGHJ | 4 | MIKE
FGHJ | 4 | MIKE
SDGF | 16 | ALFA
NFG | 14 | ALFA
DFG | 5 | ALFA
FHG | 3 | ALFA
JGF | 20 | CHARLIE
FGHJ | 8 | CHARLIE
DFGFGH | 11 | CHARLIE
FHG | 7 | ECHO
DFG | 4 | ECHO
DF | 7 | ECHO
Spreadsheet: 877667d1724466392-redundancy-calc-with-a-difference-a-formula-question-redundancy-calc-with-a-difference-jt
Sheet: #16 Incorrect

 | Redundancy Calc with a difference
 | https://www.excelforum.com/excel-formulas-and-functions/1427560-redundancy-calc-with-a-difference-a-formula-question.html
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1.5 | 1.75 | Completed | Total | Date @ |  |  | Age @
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks | X | Y | Z | X | Y | Z
 | Empl 001 | 1964-04-23 00:00:00 | 2018-09-20 00:00:00 | 2024-09-30 00:00:00
 | Empl 002 | 1964-04-23 00:00:00 | 2018-09-20 00:00:00 | 2024-09-19 00:00:00
 | Empl 003 | 1964-04-23 00:00:00 | 2017-02-20 00:00:00 | 2024-09-30 00:00:00
 | Empl 004 | 1966-01-28 00:00:00 | 2008-04-21 00:00:00 | 2024-12-31 00:00:00
 | Empl 005 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | correct
 |  | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  | 4 | 11 | 0 |  |  |  |  |  |  |  |  | incorrect
 | Empl 006 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00
 | Empl 007 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | correct
 |  | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  | 0 | 1 | 3 |  |  |  |  |  |  |  |  | incorrect
 | Empl 008 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | correct
 |  | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  | 0 | 2 | 14 |  |  |  |  |  |  |  |  | incorrect
 | Empl 009 | 1990-07-21 00:00:00 | 2012-12-03 00:00:00 | 2024-11-30 00:00:00
 | Empl 010
 | Empl 011
 | Empl 012
 | Empl 013
 | Empl 014
 | Empl 015
 | Empl 016
 | Empl 017
 | Empl 018
Spreadsheet: 889375d1740157742-create-a-new-column-based-on-unique-prices-excel_dynamic_column_with_condition
Sheet: Φύλλο1

TEST1 | TEST2 |  | NEW COLUMN
A | 10
B | 0
C | 20
D | 10
E | 0
A
B | 2
S | 4
S
Spreadsheet: 100787d1299026477-subtracting-column-number-in-workbook-from-one-sheet-to-another-book2
Sheet: Sheet1

Oil Producers Inc. of Kansas |  |  |  | Official Gauge Report
Lease: | Burr 1-4 | Gauger: | Kodi Siroky |  | From: |  |  | To:
Tank #: |  | [NAME]: |  |  | Orifice Plate Size: |  | EGM
Date | Daily Oil Gauge |  | Daily Oil Gauge |  | Daily Oil | Line | Diff | MCF | SW | Remarks
 | Feet | Inches | Feet | Inches | Prod. | Press |  |  | Bbls.
1 |  |  |  |  |  |  |  | 25
2 |  |  |  |  |  |  |  | 25
3 |  |  |  |  |  |  |  | 25
4 |  |  |  |  |  |  |  | 25
5 |  |  |  |  |  |  |  | 25
6 |  |  |  |  |  |  |  | 25
7 |  |  |  |  |  |  |  | 25
8 |  |  |  |  |  |  |  | 25
9 |  |  |  |  |  |  |  | 25
10 |  |  |  |  |  |  |  | 25
11 |  |  |  |  |  |  |  | 25
12 |  |  |  |  |  |  |  | 25
13 |  |  |  |  |  |  |  | 25
14 |  |  |  |  |  |  |  | 25
15 |  |  |  |  |  |  |  | 25
16 |  |  |  |  |  |  |  | 25
17 |  |  |  |  |  |  |  | 25
18 |  |  |  |  |  |  |  | 25
19 |  |  |  |  |  |  |  | 25
20 |  |  |  |  |  |  |  | 25
21 |  |  |  |  |  |  |  | 25
22 |  |  |  |  |  |  |  | 25
23 |  |  |  |  |  |  |  | 25
24 |  |  |  |  |  |  |  | 25
25 |  |  |  |  |  |  |  | 25
26 |  |  |  |  |  |  |  | 25
27 |  |  |  |  |  |  |  | 25
28 |  |  |  |  |  |  |  | 25
29 |  |  |  |  |  |  |  | 25
30 |  |  |  |  |  |  |  | 25
31
Total Oil Produced |  |  |  |  |  | Total MCF
Report of Oil Hauled or Pipeline Runs
Date | Ticket # | Tank # | Open Gauge | Closing Gauge | % BS&W | Net Run | Bbls Oil Sold
Spreadsheet: 149517d1333998557-autocopy-or-autofill-need-help-autocopy-function
Sheet: Sheet1

Name | [NAME] |  | Name | [NAME]
[NAME] | Detial 1 |  | [NAME] | Detial 1
 | Detial 2 |  | [NAME] | Detial 2
 | Detial 3 |  | [NAME] | Detial 3
 | Detial 4 |  | [NAME] | Detial 4
 | Detial 5 |  | [NAME] | Detial 5
 | Detial 6 |  | [NAME] | Detial 6
 | Detial 7 |  | [NAME] | Detial 7
 | Detial 8 |  | [NAME] | Detial 8
 | Detial 9 |  | [NAME] | Detial 9
 | Detial 10 |  | [NAME] | Detial 10
 | Detial 11 |  | [NAME] | Detial 11
[NAME] | Detial 12 |  | [NAME] | Detial 12
 | Detial 13 |  | [NAME] | Detial 13
 | Detial 14 |  | [NAME] | Detial 14
 | Detial 15 |  | [NAME] | Detial 15
 | Detial 16 |  | [NAME] | Detial 16
 | Detial 17 |  | [NAME] | Detial 17
 | Detial 18 |  | [NAME] | Detial 18
 | Detial 19 |  | [NAME] | Detial 19
 | Detial 20 |  | [NAME] | Detial 20
 | Detial 21 |  | [NAME] | Detial 21
 | Detial 22 |  | [NAME] | Detial 22
 | Detial 23 |  | [NAME] | Detial 23
 | Detial 24 |  | [NAME] | Detial 24
 | Detial 25 |  | [NAME] | Detial 25
[NAME] | Detial 26 |  | [NAME] | Detial 26
 | Detial 27 |  | [NAME] | Detial 27
 | Detial 28 |  | [NAME] | Detial 28
 | Detial 29 |  | [NAME] | Detial 29
 | Detial 30 |  | [NAME] | Detial 30
 | Detial 31 |  | [NAME] | Detial 31
 | Detial 32 |  | [NAME] | Detial 32
Spreadsheet: 3adc0c85-5af2-4807-b144-2db2fa864747
Sheet: Rev by Prod Group

 | Net Revenue by Product Grouping
 | (in millions) | 1Q09 | 2Q09 | 3Q09 | 4Q09 | FY09 | 1Q10 | 2Q10 | 3Q10 | 4Q10 | FY10 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11
 | Desktop Solutions | 236.23784703 | 244.58433102 | 250.78905792 | 283.62257241 |  | 255.910403 | 279.76853311 | 277.089829 | 324.556902 |  | 289.1 | 304.65 | 315.982 | 369.047
 | Data Center and Cloud Solutions | 47.16554097 | 59.41931398 | 57.28112807999999 | 67.52987259 |  | 58.204727 | 70.74340489 | 84.239775 | 85.461363 |  | 77.67 | 93.26 | 111.155 | 103.437
 | Online Services | 71.980404 | 75.349282 | 78.879097 | 81.96804 |  | 84.950411 | 89.210602 | 91.659755 | 94.796323 |  | 99.772 | 106.48 | 109.557 | 111.938
 | Other Enterprise** | 13.674383 | 13.474437 | 14.0934 | 18.038807 |  | 15.20691 | 18.70995 | 19.243242 | 24.909229 |  | 24.332 | 26.401 | 28.653
 | Total Net Revenue*
 | Percentage of Total Net Revenue | 1Q09 | 2Q09 | 3Q09 | 4Q09 | FY09 | 1Q10 | 2Q10 | 3Q10 | 4Q10 | FY10 | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11
 | Desktop Solutions
 | Data Center and Cloud Solutions
 | Online Services
 | Other Enterprise**
 | Total Net Revenue
 | *amounts may not add due to rounding
 | ** Includes Edgesight, Provisioning Server, Interval Zero, Freight, Enterprise Education, Consulting Services and ShareFile revenues
 | Note:  This document should be read in conjunction with the Company's SEC Filings.