tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 71089d1271814683-copying-entries-between-worksheets-copy-of-account-ledger
Sheet: Subaccount 1

 |  |  |  |  |  |  |  |  |  | YTD P&L Subtotal | -3400
 |  |  |  |  |  |  |  |  |  | Adjustments
 |  |  |  |  |  |  |  |  |  | YTD P&L Total | -3400
 | Date | Description | Bills | Supplies | IT | Transportation | Misc. Charges | Invoice Paid | Invoice Received | Notes | Balance
 | 2010-04-01 00:00:00 | Beginning Balance |  |  |  |  |  |  |  |  | 5000
 | 2010-04-02 00:00:00 | Charge |  | -100 |  |  |  |  |  |  | 4900
 | 2010-04-03 00:00:00 | Charge |  | -300 |  |  |  |  |  |  | 4600
 | 2010-04-04 00:00:00 | Charge | -3000 |  |  |  |  |  |  |  | 1600
 |  |  | -3000 | -400 | 0 | 0 | 0 | 0 | 0
 | NOTES:
Spreadsheet: 0e2b0a84-1055-47d8-a146-7bc806eb96a2
Sheet: ΚΑΤΕΨΥΓΜΕΝΑ

[NAME]
ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ. |  | ΠΕΡΙΓΡΑΦΗ | ΜΟΝ.ΜΕΤΡ.
ΓΑΡΙΔΕΣ |  |  | ΜΥΔΙΑ
ΓΑΡΙΔΑ Νο 4 | ΚΙΛΑ |  | ΜΥΔΙΑ ΨΥΧΑ ΜΕΤΡΙΑ | ΚΙΛΑ
ΓΑΡΙΔΑ Νο 3 (16-20) ΒΙΕΤ. [NAME] | ΤΕΜΑΧΙΑ |  | ΨΑΡΙΑ
ΓΑΡΙΔΑ Νο 2 (13-15) ΒΙΕΤ. [NAME] | ΤΕΜΑΧΙΑ |  | ΤΣΙΠΟΥΡΑ ΧΩΡΙΣ ΕΝΤΟΣΘΙΑ | ΚΙΛΑ
ΓΑΡΙΔΑ Νο 1 (4-6) ΑΡΓ. | ΚΙΛΑ |  | ΛΑΥΡΑΚΙ ΜΕ [NAME]. | ΚΙΛΑ
ΓΑΡΙΔΑ Νο 1 ΑΤΛΑΝΤΙΚΟΥ | ΚΙΛΑ |  | ΠΕΡΚΑ ΦΙΛΕΤΟ | ΚΙΛΑ
ΓΑΡΙΔΑ Νο 2 ΑΡΓΕΝΤΙΝΗΣ | ΚΙΛΑ |  | ΓΑΛΕΟΣ ΦΕΤΑ | ΚΙΛΑ
ΓΑΡΙΔΑ Νο 3 ΑΡΓΕΝΤΙΝΗΣ | ΚΙΛΑ |  | ΜΑΡΙΔΑ IQF | ΚΙΛΑ
ΓΑΡΙΔΑ Β.Τ. No3 | ΚΙΛΑ |  | ΓΑΒΡΟΣ Μ/Κ ΕΛΛ. ΑΛΙΕΙΑΣ | ΚΙΛΑ
ΓΑΡΙΔΑ ΑΠΟΦΛ. 80/120 | ΚΙΛΑ |  | ΓΑΒΡΟΣ ΑΚΕΦΑΛΟΣ | ΚΙΛΑ
ΓΑΡΙΔΕΣ ΑΠΟΦΛ. (60-80) | ΚΙΛΑ |  | ΑΘΕΡΙΝΑ Μ/Κ | ΚΙΛΑ
ΓΑΡΙΔΑ Β.Τ. 21-30 | ΚΙΛΑ |  | ΣΑΡΔΕΛΑ ΦΙΛΕΤΟ | ΚΙΛΑ
ΓΑΡΙΔΑ Β.Τ. 13/15 | ΚΙΛΑ |  | ΣΑΡΔΕΛΑ Μ/Κ | ΚΙΛΑ
ΓΑΡΙΔΑ Β.Τ. 8-12 | ΚΙΛΑ |  | ΒΑΚΑΛΑΟΣ ΞΑΡ/ΝΟΣ 5/1 COD.K. | ΚΙΛΑ
[NAME] |  |  | ΒΑΚΑΛΑΟΣ ΞΑΛ/ΝΟΣ 5/1 S | ΚΙΛΑ
ΚΑΒΟΥΡΟΔΑΓΚΑΝΑ ΠΑΝΕ | ΚΙΛΑ |  | ΒΑΚΑΛΑΟΣ Α/Κ Νο1 ΙΣ. (ΣΟΥΠΑ) | ΚΙΛΑ
ΚΑΒΟΥΡΙ ΣΟΥΡΙΜΙ ΤΑΥΛ. | ΚΙΛΑ |  | ΠΕΣΚΑΝΔΡΙΤΣΑ Α/Κ Α/Δ | ΚΙΛΑ
ΚΑΒΟΥΡΙ ΣΟΥΡΙΜΙ ΙΝΔΙΑΣ | ΚΙΛΑ |  | ΚΟΚΚΙΝΟΨΑΡΟ Α/Κ 500/700 ΙΣΛ. | ΚΙΛΑ
ΧΤΑΠΟΔΙΑ |  |  | ΣΟΛΩΜΟΣ ΚΑΠΝΙΣΤΟΣ ΝΟΡΒ. | ΚΙΛΑ
ΧΤΑΠΟΔΙ 500-800 Τ7 ΜΑΡΟΚΟΥ | ΚΙΛΑ |  | ΣΟΥΠΙΑ ΚΑΘ/ΝΗ 1/2 ΙΝΔΙΩΝ | ΚΙΛΑ
[NAME] ΜΑΡΟΚΟΥ | ΚΙΛΑ |  | ΣΟΥΠΙΑ ΚΑΘ. 2/4ΚΛ | ΚΙΛΑ
[NAME] TYN. | ΚΙΛΑ |  | ΣΟΥΠΙΕΣ ΦΙΛ. U1 | ΚΙΛΑ
[NAME] ΜΑΡΟΚΟΥ | ΚΙΛΑ |  | ΚΟΚΤΕΙΛ ΘΑΛΑΣΣΙΝΩΝ ΟΛΛ. | ΚΙΛΑ
ΧΤΑΠΟΔΙ 1200-1500 Τ4 ΜΑΡΟΚΟΥ | ΚΙΛΑ |  | PANGASIUS ΦΙΛΕΤΟ ΒΙΕΤ. | ΚΙΛΑ
[NAME] | ΚΙΛΑ
ΧΤΑΠΟΔΙ 2000-2500 Τ3 ΜΑΡΟΚΟΥ | ΚΙΛΑ
[NAME] | ΚΙΛΑ
ΧΤΑΠΟΔΙ 3UP           T1 | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ
ΚΑΛΑΜΑΡΙΑ ΦΟΡΜΟΖΑ U10 | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ 3/6 ΤΑΥΛ. | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΙΝΔΙΩΝ (10/20) ΑΚΑΘ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΙΝΔΙΩΝ (6/10) ΑΚΑΘ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΚΑΘ. U10 ΙΝΔΙΩΝ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΚΑΘ. 10/20 INΔΙΩΝ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΚΙΝΑΣ 10/20 ΑΚΑΘ. | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΚΙΝΑΣ 6/10 ΑΚΑΘ. | ΚΙΛΑ
ΚΑΛΑΜΑΡΙ ΚΑΘ. 20/40 ΚΙΝΑΣ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΓΟΝΟΣ KINΑΣ | ΚΙΛΑ
ΚΑΛΑΜΑΡΙΑ ΓΟΝΟΣ ΙΝΔΙΑΣ | ΚΙΛΑ
[NAME] | ΚΙΛΑ
[NAME] ΚΑΘ/ΝΑ 180-200ΓΡ | ΚΙΛΑ
[NAME] ΚΑΘ/ΝΑ Νο 2 | ΚΙΛΑ
Spreadsheet: 680301d1590927777-index-match-with-3-criteria-index-match_match-type-1
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  | Less than |  | With 2 criteria |  | With 3 criteria
 |  |  |  |  |  |  |  |  |  |  |  |  | criteria 1 | hihi
 |  | 2020-05-31 00:00:00 | 2020-04-30 00:00:00 | 2020-03-31 00:00:00 | 2020-02-29 00:00:00 | 2020-01-31 00:00:00 |  |  |  |  |  |  | criteria 2 | big
small | haha | 12 | 34 | 56 | 98 | 85 |  |  |  |  |  |  | criteria 3 | 2020-03-30 00:00:00
small | hehe | 78 | 89 | 910 | 54 | 52 |  | Area 1
small | hoho | 1112 | 1314 | 1516 | 321 | 63
big | haha | 1 | 2 | 3 | 4 | 5
big | hehe | 6 | 7 | 8 | 9 | 10 |  | Area 2
big | hoho | 11 | 12 | 13 | 14 | 15
big | hihi | 16 | 17 | 18 | 19 | 20
Spreadsheet: 39142d1237340979-want-to-get-the-last-available-value-in-a-list-of-columns-excel-forum-last-column-data
Sheet: FMV database

air plane | Q3 2006 | Q4 2006 | Q1 2007 | Q2 2007 | Q3 2007 | Q4 2007 | Q1 2008 | Q2 2008 | Q3 2008 | Q4 2008 | Q1 2009
a | 100 | 200 | 200 | 200 | 300 | 300 | 300 | 300 | 300
b | 200 | 200 |  |  |  |  |  |  |  | 500
c | 300 | 300 | 300 | 300 |  |  | 600
Spreadsheet: 704624d1605651522-find-best-players-for-cheapest-price-maximization-hydr-
Sheet: Foglio1

 | 150 |  | 2
Player | Price | Index | Choice
Iverson | 100 | 20 | 0
[NAME] | 90 | 16 | 0
Ming | 80 | 25 | 1
[NAME] | 20 | 5 | 1
Spreadsheet: 196aaee9-3590-4fe8-8739-1adabd9cdefd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 14. COMMERCIAL FINANCE COMMITMENTS, Summary: Australia, All Series ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Fixed loans ; |  |  | Original | A2414272W | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414273X | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414274A | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414269J | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414270T | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414271V | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414266A | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414267C | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414268F | 1975-10-01 00:00:00 | 2012-11-01 00:00:00 | 446 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2013
Spreadsheet: 738731d1625217888-conditional-formatting-formula-test1
Sheet: DataTable1

 | Status | Required
 | Accepted | Yes
 | Accepted | Yes
 | Accepted | Yes
 | Accepted | Yes
 | Accepted | No
 | Accepted | Yes
 | Accepted | Yes
 | Empty | No
 | Accepted | Yes
 | Accepted | Yes
 | Expired | No
 | Expired | No
 | Empty | Yes
Spreadsheet: 693949d1599223217-dropdown-list-cells-change-values-examplefile-bsb-
Sheet: Sheet1

 |  |  |  |  | Unit-Type | Serialnumber | Unit-Name
 |  | [NAME]
 | Choose Organisation | School 1
Spreadsheet: 98130c5b-3d59-40ab-abb0-028c585af7a6
Sheet: WC 2 - OI Margin

GAAP to Non-GAAP Reconciliation
Operating Income To Underlying Operating Income
For the Three Months Ended March 31,
($ in millions, except percentages) ([NAME])
 |  |  | 2011 |  |  |  |  |  |  |  | 2010
 |  |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) |  | [NAME](Non-GAAP) |  | As Reported (GAAP) |  | Integration Program Costs (1) |  | Acquisition-Related Costs (2) |  | [NAME](Non-GAAP)
Kraft Foods
 | Operating Income |  | 1646 |  | 104 |  | 0 |  | 1750 |  | 1206 |  | 43 |  | 260 |  | 1509
 | Operating Income Margin |  | 0.131 |  |  |  |  |  | 0.139 |  | 0.107 |  |  |  |  |  | 0.133
Kraft Foods North America
 | Segment Operating Income |  | 1036 |  | 8 |  | 0 |  | 1044 |  | 983 |  | -1 |  | 7 |  | 989
 | Segment Operating Income Margin |  | 0.175 |  |  |  |  |  | 0.176 |  | 0.173 |  |  |  |  |  | 0.174
Kraft Foods Europe
 | Segment Operating Income |  | 308 |  | 51 |  | 0 |  | 359 |  | 289 |  | 1 |  | 23 |  | 313
 | Segment Operating Income Margin |  | 0.102 |  |  |  |  |  | 0.119 |  | 0.107 |  |  |  |  |  | 0.116
Kraft Foods Developing Markets
 | Segment Operating Income |  | 405 |  | 35 |  | 0 |  | 440 |  | 359 |  | 0 |  | 27 |  | 386
 | Segment Operating Income Margin |  | 0.112 |  |  |  |  |  | 0.122 |  | 0.123 |  |  |  |  |  | 0.132
 | (1) Integration Program costs are defined as the costs associated with combining the Kraft Foods and Cadbury businesses,
 | and are separate from those costs associated with the acquisition.
 | (2) Acquisition-related costs include transaction advisory fees, U.K. stamp taxes and the impact of the Cadbury inventory revaluation.
Spreadsheet: 749014d1632467005-how-to-extract-text-from-between-delimiter-extract-names-between-delimiter
Sheet: Sheet1

 | How to extract sales rep names from between delimiter
 | Combined Reps | Rep 1 | Rep 2 | Rep 3 | Rep 4 | Rep 5 | Comments
 | Peggy Jones/Autumn Kennedy/Brett Marker/[NAME][NAME] |  |  |  |  |  | The formula used for reps 1-5 work fine
 | [NAME]/[NAME]/[NAME]Suzy Rutledge |  |  |  |  |  | The formula used for reps 1-4 work fine, but not for Rep 5
Spreadsheet: drew_fossum__8696__Scott exp 02-06-01
Sheet: Travel Form

Employee Expense Report
Travel Expense Summary |  |  |  |  |  |  |  |  |  |  |  | Page
LAST NAME |  |  |  | FIRST NAME, INITIAL |  |  | TITLE |  |  | EMPLOYEE NUMBER
TRAVEL EXPENSE - Enter all transportation and lodging expenses by receipt total (airline tickets, rental car receipts, taxis, hotel, tips, personal mileage, etc.).  Exclude meals and entertainment.
Designate type of transportation used: B = Bus,  C = Cab, P = Plane,  PC = Personal Car,  CC = Company Car, RC = Rental Car, T = Train.
Assign a reference symbol for each accounting classification to be used.  Charges to be allocated do not require a reference symbol.
REF | Date |  |  | Location and Business Purpose |  |  |  |  |  |  | Type | Cost/Miles | Rate | $ [NAME]
 |  |  |  |  | Expense allocation |  |  |  | Allocated amount: |  |  | TOTAL
 |  |  |  |  | Enter an allocation factor next to each account receiving allocated |  |  |  |  | Total travel expense must be shown on Page 1,
 |  |  |  |  | charges.  Lines not assigned an allocation factor will not |  |  |  |  | Employee Expense Report Short Form.
 |  |  |  |  | receive an allocation; lines without a REF code will be allocated.
 |  |  |  |  | The total of all allocation factors must equal 1.
ACCOUNT [NAME]
Show the total amount for each accounting classification referenced above.
REF | GL Acct      Asset | GL Co Trd Ptr |  | Cost Center                  WBS Element |  |  | Order                                      Network |  | Material       Activity | Plant                      Func Area | ALLOC FACTOR |  |  | Amount
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Spreadsheet: vkaminski__40648__Kaminski 1-10-00
Sheet: KAMINSKI

EMPLOYEE_NAME | HIRE_DATE | JOBGROUP | BASE_BONUS
CHAHAL, MANDEEP S | 1996-09-30 00:00:00 | TS2 | 20000
CRENSHAW, SHIRLEY J | 1998-03-23 00:00:00 | ASSTSR | 3270
DHAR, [NAME] | 1998-03-30 00:00:00 | TS2 | 15180
GIBNER, PEYTON S | 1992-09-21 00:00:00 | VPNC | 65000
HRGOVCIC, HRVOJE J | 1994-05-23 00:00:00 | TS2 | 15000
KAMINSKI, WINCENTY J. | 1992-06-29 00:00:00 | VPNC | 165000
KRISHNARAO, PINNAMANENI V | 1993-11-15 00:00:00 | TS2 | 30000
LU, ZIMIN | 1996-09-09 00:00:00 | TS2 | 20000
MASSON, GRANT S | 1994-04-16 00:00:00 | VPNC | 70000
MOORE, KEVIN G | 1997-01-20 00:00:00 | ASSTSR | 4200
RAYMOND, MAUREEN J | 1998-12-31 00:00:00 |  | 0
[NAME], [NAME] A | 1975-09-08 00:00:00 | TS | 70000
SEZGEN, OSMAN | 1998-11-09 00:00:00 | TS2 | 0
SHANBHOGUE, VASANT | 1995-05-01 00:00:00 | TS | 65000
TAMARCHENKO, TANYA V | 1996-11-18 00:00:00 | TS2 | 10000
TANG, XINYU V | 1998-08-17 00:00:00 | SP | 25000
THURAISINGHAM, RAVI | 1998-10-12 00:00:00 | JS | 0
ZADOROZHNY, PAVEL | 1996-05-20 00:00:00 | [NAME] | 30000
* Note:  Associate / Analyst information can be received from the [NAME]. / Analy. Pool
Spreadsheet: 0e5adf9f-f307-43be-aa1a-dabeb0854d01
Sheet: Sheet1

RETIREMENT PLANNING SPREADSHEET | Unnamed: 1
General:
 | Cells in bold are user provided information. All other cells are protected.
 | There are three spreadsheets:
 | 1.  Current assets - the user enters list of current assetds, growth rate, and estimate of percent of growth that is taxable. "Growth" is defined as earnings plus capital appreciation
 | 2.   Growth of Assets - the user enters lump deposits and withdrawls of capital for each year. The spreadsheet calculates growth based on the rate information on the previous page.
 | 3.   Retirement Income - the user specifies a retirement age, monthly budget information, estimates of inflation and Social Security growth, inflation, and overall (not marginal) tax rate.
 | The spreadsheet calculates necessary liquidation of capital to maintain inflated income and resulting capital assets.
Specific Input:
 | Current Assets:
 | Marginal Tax Rate - tax on last dollar earned - assumes that this erodes capital, but actually erodes ability to add to capital.
 | Current age - used to calculate years of earning and inflation
 | Retirement age - used to calculate years of earning and inflation
 | Current year - indexes age to calendar year
 | Estimated inflation - single estimate used for all years of earning and retirement
 | Monthly budget - normal living cost excluding extraordinary items which are entered separately on Growth spreadsheet
 | Growth of Assets:
 | Additions and subtractions - additions to savings and withdrawls for large expenditures not in the monthly budget.
 | Retirement Income Spreadsheet:
 | Monthly Social Security - estimated monthly benefit at time payments begin, before tax.
 | Assumed F.I.T. - assumed overall tax rate. Needs to take into account effects of earlier tax sheltering as well as liquidation of assets on which taxes were paid earlier.
 | Monthly Pension - company financed pension payments
 | Social Security annual increase - estimate of annual increase in monthly benefit after retirement
 | Begin Social Security - age at which the user plans to begin drawing Social Security benefits, Benefit increases as payments are delayed. Social Security Administration can provide information
Spreadsheet: 3eb333bb-eb5a-438f-893c-6d0f611d4ff1
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7479 | 57782 | Mark | Shrosbree | JPN | 0 | 00:10:53 | 00:00:56 | 01:03:23 | 00:01:09 | 00:40:28 | 1 | 01:56:50
7479 | 57783 | [NAME] | Keren | JPN | 0 | 00:11:06 | [NAME] | 01:04:41 | 00:01:02 | 00:43:16 | 2 | 02:00:57
7479 | 53655 | Toshinori | Tomioka | JPN | 0 | 00:10:52 | 00:00:54 | 01:06:52 | 00:01:08 | 00:41:45 | 3 | 02:01:32
7479 | 57784 | Mitsuhirp | Shibuya | JPN | 0 | 00:10:50 | 00:01:09 | 01:05:15 | 00:01:09 | 00:44:37 | 4 | 02:02:59
7479 | 57785 | Masato | Murai | JPN | 0 | 00:15:10 | 00:01:14 | 01:22:09 | 00:01:30 | 01:06:31 | 5 | 02:46:36
7479 | 57786 | [NAME] | Boardman | JPN | 0 | [NAME] | 00:00:54 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: matthew_lenhart__26072__socalfcst
Sheet: Lavo Fcst

 |  | Net Receipts | Net Sendout | Inj/WD | Balance |  | Socal/SJ | Socal/Perm
 | 1997-05-01 00:00:00 |  |  |  | 48797000
 |  |  |  |  | 66511000
 |  |  |  |  | 74703000
 |  |  |  |  | 80577000
 |  |  |  |  | 84058000
 |  |  |  |  | 93976000
 |  |  |  |  | 92893000
 |  |  |  |  | 55335000
 |  |  |  |  | 39934000
 |  |  |  |  | 21507000 |  | 0.2268121693121694 | 0.2007010582010587
 |  |  |  |  | 23218000 |  | 0.2827419354838714 | 0.2585483870967744 |  | Variable Rates | EP | TW
 |  |  |  |  | 28262000 |  | 0.3474444444444438 | 0.266908045977011 |  | SJ to Socal | 0.153 | 0.191
 |  |  |  |  | N/A |  | 0.2939784946236559 | 0.2089784946236557 |  | Perm to Socal | 0.197 | 0.239
 |  |  |  |  | N/A |  | 0.3710000000000007 | 0.07550000000000012
 |  |  |  |  | N/A |  | 0.4700268817204298 | 0.2210268817204302 |  | IT Rates | EP
 |  |  |  |  | 74661000 |  | 0.4975806451612916 | 0.452419354838711 |  | SJ to Socal | 0.56
 |  |  |  |  | 77170000 |  | 0.4010402298850573 | 0.3000057471264368 |  | Perm to Socal | 0.53
 |  |  |  |  | 93259000 |  | 0.5112903225806456 | 0.4280645161290328
 |  |  |  |  | 98791000 |  | 0.3799404761904768 | 0.361726190476191
 |  |  |  |  | 81080000 |  | 0.4249499443826477 | 0.4396051167964399
 |  |  |  |  | 65284000 |  | 0.1603503893214677 | 0.1544883203559502
 |  |  |  |  | 52783000 |  | 0.2223214285714292 | 0.1882142857142861
 |  |  |  |  | 44969000 |  | 0.1570967741935481 | 0.1090322580645158
 |  |  |  |  | 38789000 |  | 0.1689999999999998 | 0.1184999999999994
 |  |  |  |  | 56057000 |  | 0.2366129032258064 | 0.1067741935483872
 |  |  |  |  | 68397000 |  | 0.269166666666667 | 0.141833333333333
 |  |  |  |  | 77117000 |  | 0.3325806451612903 | 0.148225806451614
 |  |  |  |  | 78044000 |  | 0.3217741935483862 | 0.07338709677419253
 |  |  |  |  | 86618000 |  | 0.3735000000000013 | 0.251333333333335
 |  |  |  |  | 89228000 |  | 0.3372580645161283 | 0.3309677419354831
 |  |  |  |  | 92944000 |  | 0.4109999999999991 | 0.3963333333333328
 |  |  |  |  | 78580000 |  | 0.2327419354838711 | 0.2277419354838708
 |  |  |  |  | 62970000 |  | 0.1772580645161295 | 0.1582258064516138
 |  |  |  |  | 48405000 |  | 0.2131034482758625 | 0.1739655172413794
 |  |  |  |  | 49222000 |  | 0.2133870967741922 | 0.1695161290322567
 |  |  |  |  | 60911000 |  | 0.2740000000000005 | 0.1995000000000009
 |  |  |  |  | 65633000 |  | 0.4454838709677413 | 0.2599999999999993
 |  |  |  |  | 67650000 |  | 0.6586666666666665 | 0.4721666666666655
 |  |  |  |  | 66434000 |  | 0.9643548387096779 | 0.6238709677419352
 |  |  |  |  |  |  | 1.11 | 0.72625
 | 2002-04-01 00:00:00
Spreadsheet: 887229d1737472249-excel-formula-to-filter-by-2-criteria-sample-filter
Sheet: Sheet2

Search By | M/S Fabwell
 |  |  |  |  |  |  |  |  |  | Vendor List
Vendor | MT. | [NAME]. | Qty (Nos) |  |  | Filter By |  |  |  | M/S Fabwell
 |  |  |  |  |  |  |  |  |  | M/S Bharat Enterprises
 |  |  |  |  |  |  |  |  |  | M/S Sanika Ent.
 |  |  |  |  |  |  |  |  |  | M/S Y K Enginnering
Spreadsheet: 474634d1470840666-return-value-adjacent-to-two-criteria-duplicates-problem
Sheet: Sheet1

[NAME] | 134 | Apples
[NAME] | 54654 | Apples
Lewis | 78 | Oranges
[NAME] | 78 | Oranges
[NAME] | 324 | Oranges
Carrie | 65 | Pears
Elvis | 34 | Pears
Person with the most: | Apples
 | Oranges
 | Pears
Person with the second most | Apples
 | Oranges
 | Pears
Spreadsheet: 756543d1637621366-retrieve-hours-worked-based-on-day-of-week-in-rota-rota
Sheet: June

 | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU
 | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 855054d1704776729-filter-based-on-tables-wildcards-and-or-test-category-dj
Sheet: E-mailAddress

PrimaryAddress PQ |  |  |  | Helper Column |  | By formula
[EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL] |  |  |  |  |  | [EMAIL]
[EMAIL]
Spreadsheet: 758857d1639129177-index-formula-assistance-to-pull-data-from-multiple-sheets-using-a-single-criterion-invoicing_test_data
Sheet: Summary

ALLOCATED AREA
DATE | SUPPLIER NAME | INVOICES | ALLOCATED AREA | INVOICE NUMBER | OUR ORDER REF | COST1 | COST2 | COST3 | TOTAL | VAT | PURCHASES | MOTOR EXP | SUNDRIES | TELE | RENT/RATES | RFG CONT | TRANS | SUB / INS | STAY | PROF | SKIP HIRE | PLANT
Spreadsheet: 288067d1389085039-daily-sales-target-based-on-yearly-and-monthly-sales-data
Sheet: Sheet1

[NAME] |  |  |  | [NAME] |  |  |  | Liebeskind - Dubai
Jan | 273752 | 273.752 |  | Jan | 383252 |  |  | Jan | 219000
Feb | 191626 | 191.626 |  | Feb | 268275 |  |  | Feb | 153300
Mar | 219000 | 219 |  | Mar | 306600 |  |  | Mar | 175200
Apr | 219000 | 219 |  | Apr | 306600 |  |  | Apr | 175200
May | 238847 | 238.847 |  | May | 344925 |  |  | May | 197100
Jun | 206682 | 206.682 |  | Jun | 268275 |  |  | Jun | 131400
Jul | 231319 | 231.319 |  | Jul | 344925 |  |  | Jul | 197100
Aug | 206682 | 206.682 |  | Aug | 268275 |  |  | Aug | 153300
Sep | 211472 | 211.472 |  | Sep | 306600 |  |  | Sep | 175200
Oct | 258695 | 258.695 |  | Oct | 383252 |  |  | Oct | 219000
Nov | 253904 | 253.904 |  | Nov | 344925 |  |  | Nov | 175200
Dec | 226528 | 226.528 |  | Dec | 306600 |  |  | Dec | 219000
Total |  |  |  | Total
Spreadsheet: 325206d1402671286-sales-price-volume-mix-variance-analysis-who-can-explain-price-volume-mix-variance-correct-
Sheet: Sheet1

 |  | Sales Volume |  |  |  | Price |  |  |  | Units |  |  | Mix |  |  | [NAME]
Product |  | Actual | Budget | [NAME] |  | Actual | Budget | [NAME] |  | Actual | Budget |  | Actual | Budget |  | Price | Volume | Mix | Total
#1 |  |  |  |  |  | 200 | 210 |  |  | 200 | 150
#2 |  |  |  |  |  | 100 | 180 |  |  | 600 | 50
#3 |  |  |  |  |  | 150 | 200 |  |  | 50 | 150
#4 |  |  |  |  |  | 50 | 70 |  |  | 300 | 150
Total
Proof Calculation
Spreadsheet: darrell_schoolcraft__7783__imbalsumm0107
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -137341 | -136796
2 | -125680 | -124374
3 | -103730 | -110538
4 | -64504 | -65000
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
 | 2001-06-30 00:00:00 |  | 22993
 | 2001-07-04 00:00:00
Spreadsheet: 298816d1392914128-rank-non-unique-values-contiguous-rank-required-cannot-be-found-rank-test-help-needed
Sheet: Sheet1

Name | Value | Rank | Desired Rank
Person 1 | 22 |  | 9
Person 2 | 23 |  | 10
Person 3 | 24 |  | 11 |  |  |  |  | {=sum(--ISNUMBER(MATCH((row(INDIRECT("1:"&RANK(K2,$K$2:$K$9))),RANK($K$2:$K$9,$K$2:$K$9),0)))}
Person 4 | 23 |  | 10
Person 5 | 24 |  | 11
Person 6 | 23 |  | 10
Person 7 | 25 |  | 12
Person 8 | 17 |  | 5
zLeader 1 | 20.11111111111111
Person 9 | 19 |  | 6
Person 10 | 9 |  | 1
Person 11 | 23 |  | 10
Person 12 | 9 |  | 1
Person 13 | 24 |  | 11
Person 14 | 20 |  | 7
Person 15 | 20 |  | 7
Person 16 | 16 |  | 4
[NAME] | 15.55555555555556
Person 17 | 10 |  | 2
Person 18 | 20 |  | 7
Person 19 | 24 |  | 11
Person 20 | 17 |  | 5
Person 21 | 23 |  | 10
Person 22 | 24 |  | 11
Person 23 | 21 |  | 8
Person 24 | 15 |  | 3
[NAME] | 17.11111111111111