tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 736401d1623594456-monthly-unearned-revenue-unearned-revenue-ws-ans2
Sheet: DR Worksheet (2)

Unearned Revenue Worksheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have not used  columns T and U
Customer | Invoice # | Invoice Amount | Invoice Date | Service Starting Date | Service Ending Date | Subcriptions | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | Unearned Revenue to date 2021 | Unearned Revenue Balance | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
Amazon | 123 | 15000 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | 2022-01-01 00:00:00 | 12 Months
Bell Canada | 456 | 25000 | 2021-04-01 00:00:00 | 2021-04-01 00:00:00 | 2021-07-01 00:00:00 | 3 Months
Financial Times | 789 | 12000 | 2021-03-01 00:00:00 | 2021-03-01 00:00:00 | 2022-03-01 00:00:00 | 12 Months
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I have not used  columns T and U
Step 1 - Determine how many periods between the service starting date and ending date.
Step 2 - Divide the number of periods by the invoice amount to arrive at the monthly revenue.
TOTAL
Spreadsheet: 868232d1714979399-need-excel-formula-to-split-string-and-write-output-in-another-column-sample-excel-1-
Sheet: Sheet1

 |  | Field1 | Field2 | Required Output | Requirement
 | 1 | JU | NE,,,PL | [NAME] | IF [NAME] or NEJU come it should only bring one value
 | 2 | XX | MA,UR,CH,YY,NE, | JUPL | if No value in field 1 then no output | JUPL
 | 3 |  | ,PL,UR,CH,NE | XXMA |  | XXMA
 | 4 | MA,ME,MO,NE,RA,KE | PL,,YY, | XXUR |  | XXUR
 |  |  | JU,ZZ,MA,ME,MO,NE,RA,KE,XX, | XXCH |  | XXCH
 |  |  | ,SU,VE,UR,CH,MA,ZZ,XX | XXYY |  | XXYY
 |  |  | ,JU,SA,ZZ | XXNE |  | XXNE
 |  | YY | ,XX,, | for 3rd row  field 1 value is not exist so no value should come |  | MAPL
 |  | PL | ,ZZ,JU, | MAPL |  | MAYY
 |  | SA | YY,,, | MAYY |  | MEPL
 |  | SU,VE,UR,CH | SA,,PL,YY | MEPL |  | [NAME]
 |  |  | ME,MO,SU,VE,RA,KE,,ME,MO,SU,VE,RA,KE,MA,ME,MO,SU,VE,JU,SA,RA,KE | [NAME] |  | MOPL
 |  |  |  | MOPL |  | MOYY
 |  |  |  | MOYY |  | NEPL
 |  |  |  | So on |  | NEYY
 |  |  |  |  |  | RAPL
 |  |  |  |  |  | RAYY
 |  |  |  |  |  | KEPL
 |  |  |  |  |  | KEYY
 |  |  |  |  |  | YYXX
 |  |  |  |  |  | PLZZ
 |  |  |  |  |  | PLJU
 |  |  |  |  |  | SAYY
 |  |  |  |  |  | SUSA
 |  |  |  |  |  | SUPL
 |  |  |  |  |  | SUYY
 |  |  |  |  |  | VESA
 |  |  |  |  |  | VEPL
 |  |  |  |  |  | VEYY
 |  |  |  |  |  | URSA
 |  |  |  |  |  | URPL
 |  |  |  |  |  | URYY
 |  |  |  |  |  | CHSA
 |  |  |  |  |  | CHPL
 |  |  |  |  |  | CHYY
Spreadsheet: 835374d1688545616-count-cell-with-different-date-and-year-exist-count-cell-with-different-date-and-year-exist
Sheet: Sheet1

Received Date |  |  | this is the data
 |  |  |  | RESULT I WANT
2022-01-03 00:00:00 |  |  |  | 2022-01-31 00:00:00 | 3 |  | SUMPRODUCT(--1/COUNTIF(A3:A24;A3:A24))
2022-01-03 00:00:00 |  |  |  |  | 3 |  | EOMONTH
2022-01-05 00:00:00 |  |  |  |  | 2
2022-01-05 00:00:00 |  |  |  |  | 4
2022-01-20 00:00:00 |  |  |  |  | 4
2022-01-20 00:00:00 |  |  |  | 2023-01-31 00:00:00 | 3
2022-02-01 00:00:00 |  |  |  |  | 3
2022-02-01 00:00:00 |  |  |  |  | 2
2022-02-15 00:00:00 |  |  |  |  | 4
2022-02-20 00:00:00 |  |  |  |  | 4
2022-03-04 00:00:00
2022-03-05 00:00:00
2022-04-04 00:00:00
2022-04-05 00:00:00
2022-04-06 00:00:00
2022-04-07 00:00:00
2022-05-05 00:00:00
2022-05-06 00:00:00
2022-05-07 00:00:00
2022-05-08 00:00:00
2023-01-03 00:00:00
2023-01-03 00:00:00
2023-01-05 00:00:00
2023-01-05 00:00:00
2023-01-20 00:00:00
2023-01-20 00:00:00
2023-02-01 00:00:00
2023-02-01 00:00:00
2023-02-15 00:00:00
2023-02-20 00:00:00
2023-03-04 00:00:00
2023-03-05 00:00:00
2023-04-04 00:00:00
2023-04-05 00:00:00
2023-04-06 00:00:00
2023-04-07 00:00:00
2023-05-05 00:00:00
2023-05-06 00:00:00
2023-05-07 00:00:00
2023-05-08 00:00:00
Spreadsheet: 466429d1466181688-if-cell-has-date-within-certain-timeframe-change-color-sample
Sheet: Sheet1

Time left | Target Date
 | 2016-06-19 00:00:00
 | 2016-06-30 00:00:00
 | 2016-06-30 00:00:00
 | 2016-07-01 00:00:00
 | 2016-07-01 00:00:00
 | 2016-07-05 00:00:00
 | 2016-07-10 00:00:00
 | 2016-07-30 00:00:00
 | 2016-08-01 00:00:00
 | 2016-08-28 00:00:00
 | 2016-09-25 00:00:00
 | 2016-11-01 00:00:00
 | 2016-11-01 00:00:00
 | 2016-12-31 00:00:00
 | 2017-01-01 00:00:00
 | 2017-12-01 00:00:00
Spreadsheet: 679719d1590597890-match-a-number-to-the-left-of-a-name-across-multiple-arrays-example-list
Sheet: Names 2

Order # | Name |  | Order # | Name |  | Order # | Name |  | Order # | Name |  | Order # | Name
1 | Adam |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Umberto
2 | [NAME] |  | 6 | George |  |  | [NAME] |  |  | Quinn |  |  | Victor
3 | [NAME] |  |  | [NAME] |  | 7 | Mark |  | 8 | Rodger |  | 9 | Walter
4 | [NAME] |  |  | [NAME] |  |  | Nathan |  |  | [NAME] |  |  | Xander
5 | [NAME] |  |  | [NAME] |  |  | Ozzie |  |  | [NAME]
Spreadsheet: 88f405ea-6da8-4b7b-94a2-28eb8e151b33
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
38765351 | 2013-11-30 01:47:27 | ALLIES | 0 | 5 | 6 | 1444600 | greekirene | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38765462 | 2013-11-30 01:59:19 | AXIS | 0 | 3 | 6 | 1444600 | greekirene | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38765587 | 2013-11-30 02:10:35 | ALLIES | 1 | 6 | 1 | 1240009 | Yossarian44 | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38765679 | 2013-11-30 02:28:36 | AXIS | 0 | 3 | 6 | 1240009 | Yossarian44 | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
38765839 | 2013-11-30 02:56:41 | AXIS | 0 | 2 | 6 | 1240009 | Yossarian44 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
38766077 | 2013-11-30 03:23:55 | ALLIES | 0 | 2 | 6 | 1240009 | Yossarian44 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 13b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 63863 | 498850 | 484582 | 1047295
Europe | - | - | 478614 | 478614
North America/Asia | 63863 | 498850 | 5968 | 568681
Other | - | - | - | -
Index | 701610 | 2881240 | 4026693 | 7609543
Asia | - | - | 129410 | 129410
Europe | - | - | 3482236 | 3482236
North America | 701610 | 2881240 | 122489 | 3705339
Other | - | - | 292558 | 292558
OTHER* | - | - | 627457 | 627457
TOTAL | 765473 | 3380090 | 5138732 | 9284295
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 724290d1616095236-highlight-duplicates-based-on-several-columns-table-omitting-conditional-duplicates-casey825-
Sheet: cat

Name | Number1 | Number2 | Number3 | Dup |  | Dup | 0
Cat | 6145 | 6150 | 6160
Cat | 6147 | 6152 | 6162 |  |  | Name | Number1 | Number2 | Number3
Cat | 6189 | 6145 | 6167 |  |  | Cat | 6145 | 6150 | 6160
Dog | 6146 | 6151 | 6161 |  |  | Cat | 6147 | 6152 | 6162
Lion | 6149 | 6156 | 6166 |  |  | Dog | 6146 | 6151 | 6161
Monkey | 6150 | 6155 | 6165 |  |  | Lion | 6149 | 6156 | 6166
Pigeon | 6148 | 6153 | 6163 |  |  | Monkey | 6150 | 6155 | 6165
Pigeon | 6149 | 6159 | 6169 |  |  | Pigeon | 6148 | 6153 | 6163
Tiger | 6192 | 6154 | 6164 |  |  | Pigeon | 6149 | 6159 | 6169
Tiger | 6153 | 6158 | 6192 |  |  | Tiger | 6192 | 6154 | 6164
 |  |  |  |  |  | Grand Total
Spreadsheet: 782812d1654283197-using-aggregate-indexed-to-return-multiple-returns-but-multiple-criteria-sample-ws
Sheet: ARRIVALS

2022-06-05 00:00:00
Num In |  | <-  I can easily show the number that I actually expect to arrive |  |  |  |  | Num In |  |  |  |  |  |  | Num In
{CANCELED}
{EXCHANGED}
{CANCELED}
The 3 marked as cancelled or exchanged have no bearing here, but have taken the place of 3 Reservations that have not cancelled or exchanged.        I need to be able to weed them out.
Num In |  |  |  |  |  |  | Num In
 | The Reservation Number pulls from RS_RESERVATION, aggregated to allow multiple rturns for the date | These are simple Xlookups pulling from RS_PRIMARY_NAME besed on Reservation Number. |  |  | This is a simple formula to calculate length of stay.
Num In |  |  |  |  |  |  | Num In
Spreadsheet: 586743d1534549835-index-formula-or-match-formula-for-calculation-based-on-different-tiers-jtakwformula-bonus
Sheet: Sheet1

 |  |  |  | Criteria | Sales Amount |  | % Bonus
 |  |  |  | Less than 500k | 0 |  | 0
 |  |  |  | Equal or Greater than 500k but less than 750K | 500000 |  | 0.015
 |  |  |  | Equal or Greater than [NAME] but less than 1M | 750000 |  | 0.02
 |  |  |  | Equal or Greater than 1M but less than 2M | 1000000 |  | 0.03
 |  |  |  | Equal or Greater than 2M but less than 3M | 2000000 |  | 0.04
 |  |  |  | Equal or Greater than 3M | 3000000 |  | 0.05
Input | Input |  | [NAME]
[NAME] | Sales amount | Bonus Rate | Bonus Amount
Sales 1 | 560000
Sales 2 | 751000
Sales 3 | 795000
Sales 4 | 2300000
Sales 5 | 3500000
Sales 6 | 1350000
Sales 7 | 480000
Spreadsheet: 748189d1631950521-how-to-do-a-vlookup-in-a-conditional-situation-copy-of-example-1
Sheet: Sheet1

[NAME] | Which warehouse should I order the product from? |  |  |  | Product barcode | Warehouse name | Warehouse inventory stocks
APPLE |  |  |  |  | COCONUT | ISTANBUL | 4
BANANA |  |  |  |  | ORANGE | BERLIN | 3
ORANGE |  |  |  |  | BANANA | PARIS | 2
APPLE |  |  |  |  | APPLE | PARIS | 2
COCONUT |  |  |  |  | PEACH | MOSCOW | 2
PEACH |  |  |  |  | APPLE | MOSCOW | 1
APPLE |  |  |  |  | APPLE | LONDON | 1
AVOCADO |  |  |  |  | APPLE | BERLIN | 1
APPLE |  |  |  |  | AVOCADO | ISTANBUL | 1
APPLE
 | So I want to use vlookup on the blue colored column. My purpose is draw values(warehouse names from 2nd table) with vlookup. But vlookup only take first values when the product barcode is duplicate. So as it in the example APPLE product only takes PARIS warehouse but PARIS inventory has only 2 APPLE product. If paris gives 2 of their stock there wont be any stock for the 3rd apple. So what I want is vlookup(or other formula) bring stocks considering the available inventory stocks.                                                                                  It should be 3rd APPLE takes stock from MOSCOW. 4th one from LONDON and the 5th one take from BERLIN.
Spreadsheet: 682445d1592112765-find-date-of-which-employee-satisfies-two-conditions-sample-2
Sheet: BONOUS

CODE | NET LIVES | NET FP | DATE(YYYYMMDD) | EXPECTED |  | CHANGE DATE
 |  |  |  |  |  | AS REQUIRED
192 |  |  |  |  |  | 20190401 | 20200331
727 |  |  |  | 20200130
888 |  |  |  | 20190604
 |  |  |  |  |  | PROJECT : IF AN EMPLOYEE (SHOWN IN SHEET NBD COLUMN "EM-CODE) COMPLETES SIX UNIQUE ORDERS(UNIQUE ORDER MEANS: ' ORDER-NO' WITH UNIQUE' DOB')
 |  |  |  |  |  | AND SUM OF ALL ORDER PREM IS >=50000 IN GIVEN DATE RANGE .EMPLOYEE IS ELIGIBLW FOR BONUS FROM DATE ON WHICH HE SATISFIES TWO CONDITIONS.
 |  |  |  |  |  | SOLUTION REQUIRED : I WANT TO DISPLAY DATE IN COL. [NAME] YYYYMMDD FORMAT(AS SHOWN IN COL. 'C' OF 'NBD' SHEET) ON WHICH EMPLOYEE SATISFY ABOVE MENTIONED
 |  |  |  |  |  | TWO CONDITIONS. SO THAT I CAN CALCULATE BONOUS FROM THAT DATE.
 |  |  |  |  |  | EXPECTED RESULT IS GIVEN IN COL. E
Spreadsheet: 239301d1369870705-check-if-number-falls-in-multiple-ranges-check-if-value-in-range
Sheet: Sheet1

Lower Range | Upper Range |  | Value | In range?
5 | 12 |  | 1
18 | 23 |  | 2
27 | 35 |  | 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
 |  |  | 32
 |  |  | 33
 |  |  | 34
 |  |  | 35
 |  |  | 36
 |  |  | 37
 |  |  | 38
 |  |  | 39
 |  |  | 40
 |  |  | 41
 |  |  | 42
 |  |  | 43
 |  |  | 44
 |  |  | 45
 |  |  | 46
 |  |  | 47
 |  |  | 48
 |  |  | 49
 |  |  | 50
Spreadsheet: 393f86bc-5903-4825-b14d-f2d7bc05b41f
Sheet: worksheet

Microsoft® Office SharePoint® Server 2010
Term set details worksheet
Fill this worksheetby  using the following topics:
Plan terms and term sets
Prepared by: |  |  |  | Date:
Term Set:
Description:
Owner:
Open/closed:
L1 | L2 | L3 | [NAME] | L5 | L6 | L7 | Description | Available | Synonym of
Spreadsheet: 04136c9a-212d-4227-bc0f-e3c73cf90ede
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | DATE SUBMITTED | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
WEEKLY [NAME] REPORT |  |  |  |  |  |  |  |  |  |  |  |  | DEPT.
1)  DUE EVERY TUESDAY IN PAYROLL DEPT. |  |  |  |  |  |  |  |  |  |  |  |  | FROM: |  |  | TO:
2)  RETAIN COPY FOR YOUR FILES.
EMPLOYEE |  |  |  |  |  |  |  | DATES ABSENT AND CODE |  |  |  |  |  |  |  | Accounting Use Only
(In alphabetical order) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Absence |  | Remarks
LAST NAME |  |  |  | FIRST NAME |  |  |  |  |  |  |  |  |  |  |  | Paid | Unpaid
ABSENCE CODES |  |  |  |  |  |  |  | I hereby certify that the absence information shown above is true and complete and that
[NAME] |  |  |  | P - PERSONAL - UNPAID |  |  |  | all other employees under my control have worked their regular schedules.
D - DISTRICT APPROVED |  |  |  | PN - PERSONAL NECESSITY
I - ILLNESS |  |  |  | Q - QUARANTINE |  |  |  |  |  |  |  |  |  |  |  | Date:
IA - INDUSTRIAL ACCIDENT |  |  |  | S - SUBPOENA |  |  |  | Department Head Signature |  |  |  |  |  |  |  | Prepared by: |  | Checked by:
J - JURY DUTY |  |  |  | V - VACATION
M - MILITARY |  |  |  |  |  |  |  | Print Name |  |  |  |  |  |  |  | Revised 6-22-11
Spreadsheet: 543473d1508412150-help-sorting-data-sample_data
Sheet: Sheet1

material_zone_description | Bench-Flitch | Shot Number | material_description | Bench |  |  |  | Bench numbers increase by 1., 3 flitches in each bench, flitch number increases by 4. Need to Convert flitch numbers back to their bench number
1044-043-06 |  |  | WS_PAF
1044-036-08 |  |  | HG_SPOTTED
1044-043-06 |  |  | WS_PAF |  |  |  |  |  |  | Flitches Contained in Bench
1040-044-04 |  |  | WS_PAF | 1032 |  |  |  | Bench | 1040
1052-039-01 |  |  | WS_PAF | 1040
1044-036-05 |  |  | HG_SPOTTED | 1040
1036-033-06 |  |  | WS_PAF | 1016
1052-039-01 |  |  | WS_PAF | 1040
1044-037-11 |  |  | WS_PAF | 1040
1012-005-01 |  |  | HG_ORE | 1004
1044-037-13 |  |  | WS_PAF | 1040
1032-034-07 |  |  | HG_ORE | 1028
1008-005-07 |  |  | LG_ORE | 1008
1036-033-06 |  |  | WS_PAF | 1028
 |  |  | WS_NAF
1040-037-20 |  |  | WS_PAF | 1028
1036-034-01 |  |  | WS_PAF | 1028
 |  |  | WS_PAF
1040-045-01 |  |  | HG_SPOTTED | 1028
1040-037-20 |  |  | WS_PAF | 1028
1040-044-04 |  |  | WS_PAF | 1028
Spreadsheet: john_hodge__16416__Enron - June 2001
Sheet: Sheet1

Supplier:  [NAME] [PHONE]
Pipeline:  Dominion Transmission
Delivery Point:  Dominion Southpoint
Date of Deal:  Daily Deals
Day | Vol. | Price | Total
2001-06-01 00:00:00 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 3.92
 | 2047 | 4.18
 | 2047 | 4.11
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0 | 0
 | 0
Total Purchase Amount:
Spreadsheet: 105804d1303090919-referencing-other-worksheets-and-then-some-chapterfinancialrecordstemplate
Sheet: Feb

 | February 2011Account Register
 | Number | Date | Description of Transaction | C | Debit   (-) | Credit (+) | Balance
Spreadsheet: 8dba7fe1-714b-4e06-86ce-f91b8fdb382a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Current Client Characteristics
Mental Health Services
SEX |  |  | MARITAL |  |  | AGE
Male: | 372 |  | Single: | 453 |  | 0-9: | 62
Female: | 460 |  | Married: | 203 |  | 10-19: | 212
TOTAL: | 832 |  | Divorced: | 119 |  | 20-29: | 158
 |  |  | Separated: | 41 |  | 30-39: | 151
 |  |  | Widowed: | 13 |  | 40-49: | 124
 |  |  | Other | 3 |  | 50-59: | 87
 |  |  | TOTAL: | 832 |  | Over 60: | 38
 |  |  |  |  |  | TOTAL: | 832
PRIMARY DIAGNOSIS |  |  |  |  |  | UNITS OF SERVICE
Dementia |  |  |  | 1 |  | Diagnostic Assessment |  |  |  | 749.9
Schizophrenia |  |  |  | 44 |  | Medical/Somatic |  |  |  | 619.3
Psychotic Disorders |  |  |  | 7 |  | Ind. Counseling/Psychotherapy |  |  |  | 9852.1
Anxiety Disorders |  |  |  | 34 |  | Group Counseling/Psychotherapy |  |  |  | 3041
Depressive Disorders |  |  |  | 210 |  | Crisis Intervention |  |  |  | 60.8
Organic Disorders |  |  |  | 1 |  | Ind. Community Support Program |  |  |  | 20468.8
Personality Disorders |  |  |  | 4 |  | Group Community Support Program |  |  |  | 1177
[NAME] |  |  |  | 61 |  | Residential Support |  |  |  | 762
Post-Traumatic Stress Disorders |  |  |  | 22 |  | MH Education |  |  |  | 166.6
Alcohol/Drug |  |  |  | 7 |  | Consultation |  |  |  | 940.4
Adjustment Reactions |  |  |  | 261 |  | PASSAR |  |  |  | 0
Impulse Control/Conduct Disorders |  |  |  | 62 |  | Other MH Services |  |  |  | 5102.5
[NAME] |  |  |  | 2 |  | TOTAL DIRECT SERVICES: |  |  |  | 42940.39999999999
Oppositional Disorders |  |  |  | 49
Attention Deficit Disorders |  |  |  | 45
Mental Retardation |  |  |  | 3
Marital/Relationship Problems |  |  |  | 4
Parent/Child Problems |  |  |  | 0
None/Other |  |  |  | 15
TOTAL: |  |  |  | 832
Spreadsheet: 01ed928d-5fe4-486b-ad2f-e95a46266d9b
Sheet: serials productivity stats

Serials Productivity Statistics FY10 and FY11
COLLECTION METRICS
 | FY10 | FY11 | % change
Serial volumes withdrawn | 11999 | 24102
Mform pieces withdrawn | 0 | 608 | 0
Serial volumes added (total) | 2125 | 1620
Subscriptions | 194 | 101
Binding | 1890 | 1509
Gifts | 41 | 10
Mform pieces added (total) | 55 | 34
Film | 55 | 34
Fiche | 0 | 0 | N/A
PRODUCTIVITY METRICS
 | FY10 | FY11 | % change
[NAME] processed | 15781 | 19648
[NAME] temp bound | 0 | 74 | N/A
[NAME] mended (in-house) | 91 | 122
Claims sent | 661 | 305
Pieces checked in | 6330 | 5271
[NAME] returned from bindery (total) | 2866 | 2263
Journals and other materials | 1890 | 1509
Repairs | 562 | 576
Non-Library | 414 | 178
Spreadsheet: 008e64f8-585e-4852-910a-84628a2af80e
Sheet: Sheet1

Table 5--Cottonseed meal:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | 1,000 short tons
2011/12 | 45 | 1090 | 0 | 1135 |  | 982.057769447783 | 102.942230552217 | 1085 | 50
2012/131 | 50 | 1125 | 0 | 1175 |  | 1015 | 110 | 1125 | 50
2013/142 | 50 | 990 | 0 | 1040 |  | 890 | 100 | 990 | 50
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-08-23 11:13:58.560000
Spreadsheet: 329983d1404475093-formula-to-count-empty-cells-when-using-filter-ef_help_filterformula
Sheet: Blad1

 |  | 3 |  | I need a formula that counts the number of cells that dosent have any value in col C. When changing the filter in col B i need the formula to adjust and count those empty cells for that new filter criteria. In this situation (Filter=EMF) i want the result to be 3 cause C51:53 are empty.
 | Dep. | Status
 | ESN | Gr
 | FE | Gu
 | FE | Rd
 | FE | Gr
 | FE | Gu
 | FE | Rd
 | FE | Gr
 | FE | Gu
 | FE | Rd
 | FE | Gr
 | FE
 | FE
 | FE
 | FE | Gr
 | FE | Gu
 | FE | Rd
 | JE | Gr
 | JE | Gr
 | JE | Gu
 | ME | Rd
 | ME | Gr
 | ME | Gu
 | ME
 | ME
 | NE | Rd
 | NE | Gr
 | NE | Gu
 | NE | Gr
 | NE | Gu
 | SE | Rd
 | SE | Gr
 | EVS | Gu
 | EVS | Rd
 | EVS | Gr
 | ESN | Gu
 | ESN | Rd
 | ESN | Gr
 | KVE | Gr
 | KVE | Gu
 | KVE | Rd
 | EMV | Gr
 | EMV | Gu
 | EMV | Rd
 | EMV | Gr
 | VM | Gu
 | EMF | Rd
 | EMF | Gr
 | EMF
 | EMF
 | EMF
 | FE | Gr
 | FE | Gu
 | FE | Rd
 | FE | Gr
 | FE | Gr
 | FE | Gu
 | FE | Rd
 | FE | Gr
 | FE | Gu
 | FE
 | FE
 | FE | Rd
 | FE | Gr
 | FE | Gu
 | FE | Gr
 | FE | Gu
 | JE | Rd
 | JE | Gr
 | JE | Gu
 | JE | Rd
 | JE | Gr
 | JE | Gu
 | NE | Rd
 | NE | Gr
 | NE | Gu
 | NE | Rd
 | NE | Gr
 | NE | Gu
 | NE
 | SE
 | EVS | Rd
 | EVS | Gr
 | EVS | Gu
 | EVS | Gr
 | EVS | Gu
 | EVS | Rd
 | EVS | Gr
 | EVS | Gu
 | EVS | Rd
 | EVS | Gr
 | EVS | Gu
 | EVS | Rd
 | EVS | Gr
 | ESN
 | ESN
 | ESN | Gu
 | ESN | Rd
 | ESN | Gr
 | ESN | Gu
Spreadsheet: 855234d1704885006-help-to-find-latest-previous-related-value-book1
Sheet: Sheet1

7 | [NAME]
No. | Name | Point
1 | [NAME] | 10
2 | [NAME] | 8
3 | [NAME] | 6
4 | [NAME] | 10
5 | [NAME] | 7
6 | [NAME] | 6
7 | [NAME] | 10
Spreadsheet: 68952d1269481648-distance-calculator-and-resource-assignment-example1
Sheet: CALCULATOR

location | resource | location [NAME] | latitude 1 | longitude1 | resource Zip | latitude 2 | longitude2 | distance |  |  |  |  |  |  |  |  |  | location | zip |  | name | zip
a | [NAME] | 35006 | 0.583843 | -1.52262 | 35014 | 0.582171 | -1.505821209 | 22.9634 |  |  |  |  |  |  |  |  |  | a | 35006 |  | [NAME] | 35014
b | [NAME] | 35007 | 0.580015 | -1.5151 | 35016 | 0.599062 | -1.50958379 | 39.6383 |  |  |  |  |  |  |  |  |  | b | 35007 |  | [NAME] | 35016
b | [NAME] | 35007 | 0.580015 | -1.5151 | 35019 | 0.598518 | -1.51206687 | 74.0043 |  |  |  |  |  |  |  |  |  | c | 35010 |  | [NAME] | 35019
a | [NAME] | 35006 | 0.583843 | -1.52262 | 35019 | 0.598518 | -1.51206687 | 67.7329
I would like excel to decide which location each resource will go to, based on the shortest distance.
Spreadsheet: a984cf02-7510-4d84-b18e-4f9086984606
Sheet: Cashflow - 12 Quarters

ELECTRONIC ARTS INC. AND SUBSIDIARIES
Unaudited Supplemental Financial Information
(in millions)
 |  |  |  | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2 | Q3 | Q4 | Q1 | Q2
CASH FLOW DATA |  |  |  | FY09 | FY09 | FY10 | FY10 | FY10 | FY10 | FY11 | FY11 | FY11 | FY11 | FY12 | FY12
 | Operating cash flow |  |  | 212 | 215 | -328 | 6 | 221 | 253 | -148 | -134 | 349 | 253 | -274 | -211
 | Operating cash flow - TTM |  |  | 82 | 12 | -25 | 105 | 114 | 152 | 332 | 192 | 320 | 320 | 194 | 117
 | Capital expenditures |  |  | 27 | 25 | 8 | 26 | 16 | 22 | 11 | 12 | 15 | 21 | 32 | 52
 | Capital expenditures - TTM |  |  | 112 | 115 | 92 | 86 | 75 | 72 | 75 | 61 | 60 | 59 | 80 | 120
 | Purchase of headquarters facilities |  |  | 0 | 0 | 0 | 233 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Free cash flow |  |  | 185 | 190 | -336 | -20 | 205 | 231 | -159 | -146 | 334 | 232 | -306 | -263
 | Free cash flow - TTM |  |  | -30 | -103 | -117 | 19 | 39 | 80 | 257 | 131 | 260 | 261 | 114 | -3