tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 76465d1277024853-sorting-a-football-soccer-league-table-football-season-2010-11
Sheet: TEAMS

 | TEAMS
PREMIER LEAGUE | ARSENAL
 | ASTON VILLA
 | BIRMINGHAM
 | BLACKBURN
 | BLACKPOOL
 | BOLTON
 | CHELSEA
 | EVERTON
 | FULHAM
 | LIVERPOOL
 | MANCHESTER UNITED
 | MANCHESTER CITY
 | NEWCASTLE UNITED
 | STOKE CITY
 | SUNDERLAND
 | TOTTENHAM HOTSPUR
 | WEST BROMWICH
 | WEST HAM UNITED
 | WIGAN
 | WOLVES
CHAMPIONSHIP | LEEDS UNITED
 | BARNSLEY
 | BRISTOL CITY
 | BURNLEY
 | CARDIFF
 | COVENTRY
 | CRYSTAL PALACE
 | DERBY
 | DONCASTER
 | HULL CITY
 | IPSWICH
 | LEICESTER
 | MIDDLESBOURGH
 | MILLWALL
 | NORWICH
 | NOTTINGHAM FOREST
 | PORTSMOUTH
 | PRESTON
 | QUEENS PARK RANGERS
 | READING
 | SCUNTHORPE
 | SHEFFIELD UNITED
 | SWANSEA TOWN
 | WATFORD
LEAGUE ONE | PLYMOUTH ARGYLE
 | BOURNMOUTH
 | BRENTFORD
 | BRIGHTON
 | BRISTOL ROVERS
 | CARLISLE
 | CHARLTON ATHLETIC
 | COLCHESTER
 | DAGENHAM
 | EXETER
 | HARTLEPOOL
 | LEYTON ORIENT
 | MK DONS
 | NOTTINGHAM COUNTY
 | OLDHAM
 | PETERBOROUGH
 | ROCHDALE
 | SHEFFIELD WEDNESDAY
 | SOUTHAMPTON
 | SWINDON TOWN
 | TRANMERE ROVERS
 | WALSALL
 | YEOVIL
LEAGUE TWO | MACCLESFIELD TOWN
 | ACCRINGTON STANLEY
 | ALDERSHOT
 | BARNET
 | BRADFORD
 | BURTON
 | BURY
 | CHELTENHAM
 | CHESTERFIELD
 | CREWE
 | GILLINGHAM
 | HEREFORD
 | LINCOLN
 | MORECAMBE
 | NORTHAMPTON
 | OXFORD
 | PORT VALE
 | ROTHERAM UNITED
 | SHREWSBURY TOWN
 | [NAME]
 | STEVENAGE
 | STOCKPORT
 | TORQUAY UNITED
 | WYCOMBE WANDERS
Spreadsheet: 62962d1263941561-assigning-a-value-to-a-letter-example
Sheet: Sheet1

 | Survey Responses to Questions
Date | 1 | 2 | 3 | 4 | 5 | 6 | Score | Values should be
 | A | A | A | B | B | A |  | 0.9
 | A | A | A | A | A | A |  | 1
 | B | B | B | B | B | B |  | 0.7
 | A | B | A | A | B | A |  | 0.9
 | D | A | D | D | C | B |  | 0.4
 |  |  |  |  |  | TOTAL |  | 0.7799999999999999
 |  | A= | 100% = | Strongly Agree
 |  | B= | 70% = | Agree
 |  | C= | 40% = | Disagree
 |  | D= | 10% = | Strongly Disagree
Spreadsheet: 7ac0b5c7-6477-4f1b-8566-5cbfb34eaaf2
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
35895106 | 2013-05-11 18:54:05 | AXIS | 0 | 4 | 6 | 914352 | Klaws | 13229 | western | 1943-09-09 |  |  | [META44] Débarquement à Salerne
35895504 | 2013-05-11 19:20:10 | ALLIES | 0 | 1 | 6 | 914352 | Klaws | 13229 | western | 1943-09-09 |  |  | [META44] Débarquement à Salerne
35899544 | 2013-05-12 00:08:17 | AXIS | 0 | 5 | 6 | 542819 | Didorapido | 13229 | western | 1943-09-09 |  |  | [META44] Débarquement à Salerne
35899899 | 2013-05-12 00:36:43 | ALLIES | 1 | 6 | 4 | 542819 | Didorapido | 13229 | western | 1943-09-09 |  |  | [META44] Débarquement à Salerne
35953563 | 2013-05-15 15:28:18 | ALLIES | 1 | 7 | 5 | 1068355 | Dejerik | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
35953763 | 2013-05-15 15:57:39 | AXIS | 1 | 7 | 3 | 1068355 | Dejerik | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
35969263 | 2013-05-16 18:32:44 | AXIS | 1 | 7 | 3 | 1239735 | Vaillants | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
35969608 | 2013-05-16 19:00:39 | ALLIES | 1 | 7 | 5 | 1239735 | Vaillants | 11461 | mediterranean | 1942-06-20 | 1944-06-20 | Attack on Tobruk | Prise de Tobrouk
36008526 | 2013-05-19 10:02:07 | ALLIES | 1 | 10 | 6 | 1307379 | Blackcats16 | 12921 | eastern | 1943-07-05 | 1943-08-20 |  | [méta-jeu] Juillet /Août 1943.
36008696 | 2013-05-19 10:21:40 | AXIS | 1 | 10 | 3 | 1307379 | Blackcats16 | 12921 | eastern | 1943-07-05 | 1943-08-20 |  | [méta-jeu] Juillet /Août 1943.
Spreadsheet: 50844463-9f46-4b92-8a4e-7b616e58d52e
Sheet: Sheet1

LUTHERAN THEOLOGICAL SEMINARY AT GETTYSBURG | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
CERTIFICATE IN THEOLOGICAL STUDIES PROGRAM
REGISTRATION FOR 2014-15
 |  | [NAME]: |  |  |  |  |  | DATE:
 |  | SSN: |  |  | xxx-xx- |  | (last 4 digits only)
 |  | [NAME] (PLEASE PRINT):
Term: |  |  |  |  |  |  |  | Registration Deadline:
September 3-6, 2014 |  |  |  |  |  |  |  | July 31, 2014
 | Wed: 6:30-8:30; Th & F: 8:30-11:30, 1:30-4:00, 6:30-8:30; S: 8:30-11:30
January 7-10, 2015 |  |  |  |  |  |  |  | November 20, 2014
 | Wed: 6:30-8:30; Th & F: 8:30-11:30, 1:30-4:00, 6:30-8:30; S: 8:30-11:30
July  5-11, 2015 |  |  |  |  |  |  |  | May 31, 2015
 | Course A: Su: 5:45-6:45; M-F 8:30-11:45; S: 8:30-9:30
 | Course B: Su: 7:00-8:00; M-F 1:30-4:45; S: 9:45-10:45
 | Course C: Su: 8:15-9:15; M-F 6:15-9:30; S: 11-noon
 |  | REGISTER |  | GRADE
TERM |  | WITH X |  | CHOICE |  | Letter [NAME]; Pass/Fail Grade - PF
SEPT |  |  |  |  |  | 12.300 | Systematic Theology |  |  | Largen
JAN |  |  |  |  |  | 11.100 | Old Testament Foundation |  |  | [NAME]
JULY | A |  |  |  |  | 13.700 | Preaching
JULY | B |  |  |  |  | 11.200 | New Testament Foundation |  |  | [NAME]
JULY | C |  |  |  |  | 13.600 | Christian Education |  |  | [NAME]
 |  | RETURN TO REGISTRAR'S OFFICE AT LTSG
 |  | QUESTIONS? ASK DR. [NAME] at [EMAIL], [PHONE] or
 |  | [NAME], [EMAIL], [PHONE]
 |  | Office Use Only:
 |  |  | Received: |  |  |  | Tech:
 |  |  | Blackbaud: |  |  |  | Business:
Spreadsheet: 107919d1305057156-excel-2007-calculate-value-based-on-formula-result-test-formulas
Sheet: Sheet1

NAME | SSN | # CORRECT | # ATTEMPTED | % | REMEDIATE | TLO % | CLS GRADE | CRS GRADE
IF PERCENT = 65.00 then REMEDIATE needs to read YES |  | 1 | 3 | 0.65 | NO | 0.9416666666666668 | 0.9854166666666667 | 0.9951388888888889
 |  | 3 | 3 | 1 | NO
 |  | 9 | 9 | 1 | NO
 |  | 4 | 4 | 1 | NO
 |  | 2 | 2 | 1 | NO
 |  | 22 | 22 | 1 | NO
 |  | 25 | 25 | 1 | NO | 1
 |  | 4 | 4 | 1 | NO
 |  | 29 | 29 | 1 | NO
 |  | 4 | 4 | 1 | NO
 |  | 1 | 1 | 1 | NO | 1
 |  | 0 | 0 | 1 | NO
 |  | 2 | 2 | 1 | NO
 |  | 0 | 0 | 1 | NO | 1
 |  | 0 | 0 | 1 | NO
 |  | 1 | 1 | 1 | NO
 |  | 0 | 0 | 1 | NO
 |  | 0 | 0 | 1 | NO
 |  | 0 | 0 | 1 | NO
 |  | 1 | 1 | 1 | NO
 |  | 4 | 4 | 1 | NO | 1 | 1
 |  | 3 | 3 | 1 | NO
 |  | 4 | 4 | 1 | NO
 |  | 7 | 7 | 1 | NO
 |  | 6 | 6 | 1 | NO | 1 | 1
 |  | 2 | 2 | 1 | NO
 |  | 1 | 1 | 1 | NO | 1
 |  | 2 | 2 | 1 | NO
 |  | 2 | 2 | 1 | NO
Spreadsheet: 163887d1340529648-when-a-number-has-been-drawn-last-time-reverse-list-with-function
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6
5 | 13 | 25 | 26 | 37 | 38 |  |  |  | 1
5 | 11 | 20 | 21 | 32 | 38 |  |  |  | 2
10 | 11 | 27 | 29 | 32 | 38 |  |  |  | 3
3 | 10 | 31 | 36 | 38 | 40 |  |  |  | 4
11 | 15 | 21 | 22 | 24 | 32 |  |  |  | 5
5 | 7 | 8 | 22 | 24 | 32 |  |  |  | 6
8 | 10 | 11 | 31 | 37 | 38 |  |  |  | 7
1 | 6 | 9 | 12 | 22 | 25 |  |  |  | 8
7 | 10 | 17 | 26 | 27 | 35 |  |  |  | 9
4 | 6 | 9 | 25 | 32 | 38 |  |  |  | 10
2 | 10 | 14 | 18 | 20 | 30 |  |  |  | 11
1 | 4 | 11 | 15 | 23 | 40 |  |  |  | 12
6 | 11 | 22 | 27 | 34 | 35 |  |  |  | 13
1 | 4 | 9 | 19 | 31 | 35 |  |  |  | 14
4 | 11 | 12 | 20 | 33 | 35 |  |  |  | 15
1 | 6 | 7 | 9 | 34 | 39 |  |  |  | 16
2 | 11 | 25 | 30 | 33 | 34 |  |  |  | 17
24 | 25 | 26 | 27 | 29 | 36 |  |  |  | 18
13 | 21 | 22 | 24 | 26 | 32 |  |  |  | 19
5 | 9 | 10 | 17 | 39 | 40 |  |  |  | 20
4 | 10 | 13 | 28 | 34 | 36 |  |  |  | 21
6 | 20 | 22 | 26 | 34 | 39 |  |  |  | 22
4 | 6 | 15 | 23 | 27 | 28 |  |  |  | 23
15 | 17 | 19 | 20 | 24 | 26 |  |  |  | 24
5 | 13 | 18 | 21 | 27 | 31 |  |  |  | 25
3 | 5 | 11 | 21 | 29 | 36 |  |  |  | 26
14 | 22 | 23 | 27 | 39 | 40 |  |  |  | 27
1 | 11 | 13 | 15 | 20 | 30 |  |  |  | 28
1 | 5 | 8 | 14 | 33 | 34 |  |  |  | 29
2 | 3 | 4 | 5 | 6 | 7 |  |  |  | 30
Spreadsheet: 118032d1313382661-sumproduct-link-to-another-excel-workbook-summaryfinal
Sheet: Summary

 | [NAME] set |  |  |  |  |  | Desired Result (YTD), I only need YTD data
RM | fund$ | Loan$ | mortgage (#) | mortgage ($) | od(#) |  | RM | fund$ | Loan$ | mortgage (#) | mortgage ($) | od(#)
[NAME] | #N/A |  |  |  |  |  | [NAME] | 3000 | 3000 | 100 | 3000 | 300
Dylan ben |  |  |  |  |  |  | Dylan ben | 40002 | 2300 | 400 | 40002 | 500
Gract pet |  |  |  |  |  |  | Gract pet | 0 | 0 | 500 | 3999 | 0
Spreadsheet: 70816d1271507608-excel-2007-formula-copying-no-longer-works-book1
Sheet: Apr 10

PAYMENTS DUE AT END FEBRUARY 2010 |  |  |  |  |  |  | CHECKED
 |  |  | CHQ/
Description |  | Total | EFT | Pd | Bal
[NAME]
Cosmic Industrial Suppl (100)
[NAME] (060)
Elgin Engineering |  | 2793 |  | 2793
Hilti
[NAME] (014)
Malibu Steel (088) |  |  |  |  |  |  |  | DEBIT ORDERS
OC Plant Hire (042) |  |  |  |  |  |  |  | Automated Office Tech
Panasonic Welding (049) |  |  |  |  |  |  |  | Canon
Phoenix Steel (101) |  |  |  |  |  |  |  | Bond (Loan to [NAME])
Progas (076) |  |  |  |  |  |  |  | Chubb
Reliable Fasteners (102) |  |  |  |  |  |  |  | Credit Card
RPE [NAME] |  |  |  |  |  |  |  | [NAME]
Scotclean (089) |  |  |  |  |  |  |  | Isuzu Instalment
Smith's Supplies (090) |  |  |  |  |  |  |  | Matrix260817 (Isuzu) | 118.69
Thoran Technology (074) |  |  |  |  |  |  |  | Matrix96929 (Hilux) | 124.7
Triple X Trading |  |  |  |  |  |  |  | Outsurance
Universal Bolt & Nut (125) |  |  |  |  |  |  |  | TOTAL
Waltons (075)
Universal Bolt & Nut (125) |  |  |  |  |  |  |  | BREAKDOWN
Ziep Construction (080) |  | 46460.7 |  |  |  |  |  | Rent
TOTAL |  |  |  |  |  |  |  | Unit 2:
 |  |  |  |  |  |  |  | Unit 5:
MONTHLY PAYMENTS |  | MAR 2010
Rent (018)
[NAME] (030)
Telkom
MEIBC- Prov (050)
MEIBC- [NAME] (041)
PAYE/SDL/UIF
TOTAL
Spreadsheet: benjamin_rogers__1013__Pro Forma2
Sheet: 144A FCF

Free Cash Flows |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-07-01 00:00:00 | 2002-07-01 00:00:00 | 2003-07-01 00:00:00 | 2004-07-01 00:00:00 | 2005-07-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-07-01 00:00:00 | 2011-07-01 00:00:00 | 2012-07-01 00:00:00 | 2013-07-01 00:00:00 | 2014-07-01 00:00:00 | 2015-07-01 00:00:00 | 2016-07-01 00:00:00 | 2017-07-01 00:00:00 | 2018-07-01 00:00:00 | 2019-07-01 00:00:00 | 2020-07-01 00:00:00
Cash To(From) Equity from Draw
Cash To Equity from Ops |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  | 0
TOTAL FCF
XNPV
XIRR
Spreadsheet: 713587d1610817361-translating-multiple-column-index-to-other-work-sheets-film-tester
Sheet: Info

Total Number of Films
Total Film Time
Average Film Length
Longest Film
Shortest Film
Average Year
Oldest Film
Newest Film
Total Oscars
Total Oscar Nominations
Passed Bechdel Test
Based On A True Story
Most Seen Director
Most Seen Actor
Most [NAME]
Best Director by Ave Score
Dest Actor by Ave Score
[NAME] by Ave Score
Best Director (10 Film Min)
Best Actor (10 Film Min)
[NAME] (10 Film Min)
Best Film
Worst Film
Spreadsheet: 767268d1644387370-allocate-amount-into-monthly-columns-formula-fails-for-specific-years-networkdays-issue-allocation6
Sheet: Weekdays

Weekdays
Click Consulting
Purpose | To update the allocation table to exclude weekend days.
Function | NETWORKDAYS - returns the number of workdays, excluding weekends, between two dates (inclusive)
Allocation
 | Amount | Alloc Start | Alloc End |  | WeekDays | DailyAmt |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Diff
 | 1000 | 2022-01-01 00:00:00 | 2022-12-31 00:00:00
 | 1000 | 2025-11-01 00:00:00 | 2025-12-31 00:00:00
 | 1000 | 2026-12-01 00:00:00 | 2026-12-31 00:00:00
 | 1000 | 2027-12-01 00:00:00 | 2027-12-31 00:00:00
 | 1000 | 2028-12-01 00:00:00 | 2028-12-31 00:00:00
 | 1000 | 2029-12-01 00:00:00 | 2029-12-31 00:00:00
 | 1000 | 2030-12-01 00:00:00 | 2030-12-31 00:00:00
 | 1000 | 2007-12-01 00:00:00 | 2007-12-31 00:00:00
 | 1000 | 2008-12-01 00:00:00 | 2008-12-31 00:00:00
 | 1000 | 2013-12-01 00:00:00 | 2013-12-31 00:00:00
 | 1000 | 2012-12-01 00:00:00 | 2012-12-31 00:00:00
 | 1000 | 2011-12-01 00:00:00 | 2011-12-31 00:00:00
 | 1000 | 2010-12-01 00:00:00 | 2010-12-31 00:00:00
 | 1000 | 2023-12-01 00:00:00 | 2023-12-31 00:00:00
Spreadsheet: 600188d1543511981-vlookup-if-formula-help-to-report-summary-of-tasks-sample-task-list-ans
Sheet: Bob

BOB
MONTHLY TASK LIST
CLIENT | TASK | DUE | PRIORITY
Spreadsheet: 870302d1716841036-can-anyone-tell-what-mistake-i-am-doing-in-my-formulas-given-in-the-sample-file-sample-file
Sheet: Table 39

कार्यक्रम PROGRAM |  |  | AGRICULTURAL FINANCING FOR BRANCH HEADS (AGRICULTURAL FINANCE FOR BRANCH IN-CHARGES) | PROG CODE
 |  |  |  | IT 1697
तर्षर् समूह/JOB FAMILY |  |  | CREDIT
उद्देश्य/OBJECTIVE |  |  | TO    IMPART    INTEGRATED    WORKING    KNOWLEDGE    IN AGRICULTURE AND OTHER RELATED AREAS.
लतक्षि समूह/TARGET GROUP |  |  | [NAME]
अर्तध/DURATION |  |  | 3 DAYS
DAY | SESSION | CONTENTS
Day 1 | I | Priority Sector-Importance and Classification (with special reference to Agriculture and MSME),Agricultural lending norms, Credit Policy on Agriculture
 | II | Pre  and  Post    sanction  visits  importance  and  Customer  Due Diligence, CIBIL, Overview on LAPS
 | III | SHG  &  KCCS,  PMFBY  &  Atmanirbhar  Bharat  Schemes  especially AIF, AHIDF, PM-FME, [NAME], CBG, EBP.
 | IV | Agricultural Term loan, Investment & development loan schemes
Day 2 | I | Mortgage and legal aspects of Documentation
 | II | Government sponsored Scheme, MUDRA, CGTMSE, CGFMU & Area specific schemes.
 | III | Retail lending in specific to Agri. Housing, , [NAME]. Vehicle
 | IV | Aspects of Credit Monitoring
Day 3 | I | Restructuring - Auto NPA concept & Recovery
 | II | Customer    Relationship    Management,    Motivation    &    Effective Communication Skills
 | III | Business Ethics and Value System
 | IV | Implementation   of   OL,   Prevention   of   Sexual   Harassment   at workplace and Valediction
Spreadsheet: 90272d1290025397-excel-2007-how-to-get-a-total-for-a-series-of-numbers-book6
Sheet: Sheet1

Phone | Minutes
[PHONE] | 1
[PHONE] | 6
[PHONE] | 12
[PHONE] | 3
[PHONE] Total
[PHONE] | 9
[PHONE] | 14
[PHONE] | 8
[PHONE] | 7
[PHONE] Total
[PHONE] | 3
[PHONE] | 1
[PHONE] | 15
[PHONE] Total
[PHONE] | 9
[PHONE] | 3
[PHONE] | 1
[PHONE] | 2
[PHONE] | 5
[PHONE] | 7
[PHONE] Total
Grand Total
Spreadsheet: sally_beck__35151__MgmtSum-Q3-0914_Global
Sheet: GrossMargin

PLAN2000
[NAME] | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
2000-09-01 00:00:00 | 3RD QUARTER 2000 DETAIL OF GROSS MARGIN
M.QTD | Results based on activity through September 14, 2000
ENA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forecast Margin Calculation
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Margin |  |  |  | Earnings Before Allocated Expenses
 | Business Team |  | DPR(1) | MPR | Accruals | Other | FTA | Margin | Identified | Margin | Margin | Plan | [NAME] |  |  | Plan | Forecast | [NAME]
 | Liquids |  | 14561 | 0 | 0 | 0 | 0 | 14561 |  | 0 | 14561 | 20000 | -5439
COAL | Coal |  | 1439 | -7366.075 | 11.89 | 0 | 0 | -5915.184999999999 |  | 0 | -5915.184999999999 | 12747 | -18662.185 |  |  | 9507.2 | -10071.477 | 19578.677
SO2 | Emissions |  | 2380 | 0 | 0 | 0 | 0 | 2380 |  | 0 | 2380 | 750 | 1630 |  |  | 645.9 | 2201.39 | -1555.49
WEATHER | Weather |  | 3721.8 | 0 | 0 | 0 | 0 | 3721.8 |  | 0 | 3721.8 | 3215 | 506.8 |  |  | 2332.4 | 2839.2 | -506.8
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 7712 | -7712 |  |  | #REF! | #REF! | #REF!
ECT_INV_IRFX | Equity Trading |  | 12282.419 | 0 | 0 | 0 | 0 | 12282.419 |  | 0 | 12282.419 | 8947 | 3335.419
 | FX / Int Rate Trading |  | 1566 | 0 | 0 | 0 | 0 | 1566 |  | 0 | 1566 | 0 | 1566 |  |  | 0 | 1464.064 | -1464.064
 | Subtotal Financial Trading |  | 13848.419 | 0 | 0 | 0 | 0 | 13848.419 |  | 0 | 13848.419 | 8947 | 4901.419
 | Soft Commodities Trading |  | -7.549 | 0 | 0 | 0 | 0 | -7.549 |  | 0 | -7.549 | 0 | -7.549
 | Grain Trading |  | -38.737 | 0 | 0 | 0 | 0 | -38.737 |  | 0 | -38.737 | 0 | -38.737
 | Meat Trading |  | -1.428 | 0 | 0 | 0 | 0 | -1.428 |  | 0 | -1.428 | 0 | -1.428
 | Subtotal Agricultural Trading |  | -47.714 | 0 | 0 | 0 | 0 | -47.714 |  | 0 | -47.714 | 0 | -47.714
 | Office of the Chairman |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | Overview |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 6786 | -6786
 | Subtotal Gross Margin |  | 35902.505 | -7366.075 | 11.89 | 0 | 0 | 28548.32 | 0 | 0 | 28548.32 | 60157 | -31608.68 |  |  | #REF! | #REF! | #REF!
 | Other Interest Related Charges |  | 0 | 0 | 0 | -538.419 | 0 | -538.419 |  | 0 | -538.419 | -538.419 | 0
 | EGM Gross Margin |  | 35902.505 | -7366.075 | 11.89 | -538.419 | 0 | 28009.901 | 0 | 0 | 28009.901 | 59618.581 | -31608.68
 | (1) Excludes Cap. Charge & Operating Costs
Spreadsheet: 758742d1639048804-countifs-with-blank-criteria-countifs-with-blank-criteria
Sheet: Sheet1

Criteria 1 | [NAME] | Criteria 3 | [NAME]: | Expected: |  |  | Fruit | Price | Season
Apple | 18 | Autumn |  | 2 |  |  | Apple | 18 | Autumn
Apple | 18 |  |  | 2 |  |  | Orange | 15 | Winter
[NAME] |  | Summer |  | 2 |  |  | [NAME] | 16 | Summer
[NAME] |  |  |  | 0 |  |  | [NAME] | 18 | Summer
 |  |  |  |  |  |  | Apple | 18 | Autumn
 |  |  |  |  |  |  | Orange | 56 | Winter
 |  |  |  |  |  |  | [NAME] | 76 | Summer
 |  |  |  |  |  |  | [NAME] | 45 | Summer
Spreadsheet: 751429d1634110116-highlight-or-list-volunteers-who-having-been-assigned-volunteer-schedulefilterandisna
Sheet: Volunteers

Master List | Region |  |  | Who's available on Monday | Who's available on Tuesday | Who's available on Wednesday | Who's available on Thursday | Who's available on Friday |  |  | Regions
Volunteer 1 | Region 1 |  |  | Volunteer 2 | Volunteer 10 | Volunteer 1 | Volunteer 16 | Volunteer 7 |  |  | Region 1
Volunteer 2 | Region 1 |  |  | Volunteer 5 | Volunteer 7 | Volunteer 3 | Volunteer 4 | Volunteer 9 |  |  | Region 2
Volunteer 3 | Region 2 |  |  | Volunteer 7 | Volunteer 16 | Volunteer 16 | Volunteer 9 | Volunteer 1 |  |  | Region 3
Volunteer 4 | Region 4 |  |  | Volunteer 10 |  | Volunteer 4 |  | Volunteer 8 |  |  | Region 4
Volunteer 5 | Region 1 |  |  | Volunteer 12 |  | Volunteer 9 |  | Volunteer 13 |  |  | Region 5
Volunteer 6 | Region 3 |  |  | Volunteer 16 |  |  |  |  |  |  | Region 6
Volunteer 7 | Region 1 |  |  |  |  |  |  |  |  |  | Region 7
Volunteer 8 | Region 4 |  |  |  |  |  |  |  |  |  | Region 8
Volunteer 9 | Region 2 |  |  |  |  |  |  |  |  |  | Region 9
Volunteer 10 | Region 2 |  |  |  |  |  |  |  |  |  | Region 10
Volunteer 11 | Region 5
Volunteer 12 | Region 2
Volunteer 13 | Region 4
Volunteer 14 | Region 5
Volunteer 15 | Region 1
Volunteer 16 | Region 3
Spreadsheet: 743446d1628513910-sort-and-align-2-tables-upload-forum
Sheet: Sheet1

Subnet | CIDR | Status | Container | Parent |  | Server | Subnet pool | Prefix | [NAME] | Type | Total | Used | Free | Util
 |  |  | Container 1 |  |  |  | Pool 1
 |  |  | Container 2
 |  |  | Container 3
 |  |  | Container 4
 |  |  | Container 5
 |  |  | Container 6
 |  |  | Container 7
 |  |  | Container 8
 |  |  | Container 9
 |  |  | Container 10
 |  |  | Container 11
 |  |  | Container 12
 |  |  | Container 13
 |  |  | Container 14
 |  |  | Container 15
 |  |  | Container 16
 |  |  | Container 17
 |  |  | Container 18
This is what the final sort should look like.
10.217.0.0 | /24 | In-Use/Deployed | Container 1 | 10.217.0.0/17 |  | 172.19.17.116 | WRBNCAPC05-BG01 | 10.217.0.0 | /24 | MTA | 253 | 252 | 1 | 100
 |  |  |  |  |  | 172.19.17.116 | WRBNOLMN06-VL100 | 10.217.19.0 | /25 | MTA | 125 | 1 | 124 | 1
10.217.11.0 | /25 | In-Use/Deployed | Container 13 | 10.217.0.0/17
10.217.3.0 | /24 | In-Use/Deployed | Container 3 | 10.217.0.0/17 |  | 172.19.17.116 | WRBNCAPC06-BG01 | 10.217.3.0 | /24 | MTA | 253 | 253 | 0 | 100
Spreadsheet: 119807d1314760038-how-to-sum-data-sourced-through-indirect-and-match-prworkbook2
Sheet: 30Aug2011

Name | Net Cons | CCY | Date
1 | 542560 | AUD | 2011-08-30 00:00:00 | 542560
2 | 180671 | AUD | 2011-08-30 00:00:00 | 180671
3 | 116981 | AUD | 2011-08-30 00:00:00 | 116981
4 | 480025 | BRL | 2011-08-30 00:00:00 | 480025
5 | 300854 | BRL | 2011-08-30 00:00:00 | 300854
6 | 211160 | BRL | 2011-08-30 00:00:00 | 211160
7 | 674436 | HUF | 2011-08-30 00:00:00 | 674436
8 | 251012 | HUF | 2011-08-30 00:00:00 | 251012
9 | 212897 | HUF | 2011-08-30 00:00:00 | 212897
10 | 218560 | HUF | 2011-08-30 00:00:00 | 218560
11 | 87586 | DKK | 2011-08-30 00:00:00 | 87586
12 | 392420 | DKK | 2011-08-30 00:00:00 | 392420
13 | 128719 | DKK | 2011-08-30 00:00:00 | 128719
14 | 382172 | DKK | 2011-08-30 00:00:00 | 382172
15 | 1246735 | DKK | 2011-08-30 00:00:00 | 1246735
16 | 1397933 | DKK | 2011-08-30 00:00:00 | 1397933
17 | 1959879 | DKK | 2011-08-30 00:00:00 | 1959879
18 | 1164575 | DKK | 2011-08-30 00:00:00 | 1164575
19 | 1858946 | DKK | 2011-08-30 00:00:00 | 1858946
20 | 3141655 | AUD | 2011-08-30 00:00:00 | 3141655
21 | 1484487 | AUD | 2011-08-30 00:00:00 | 1484487
22 | 1321908 | AUD | 2011-08-30 00:00:00 | 1321908
23 | 1550474 | AUD | 2011-08-30 00:00:00 | 1550474
24 | 1167807 | AUD | 2011-08-30 00:00:00 | 1167807
25 | 896436 | AUD | 2011-08-30 00:00:00 | 896436
26 | 496597 | AUD | 2011-08-30 00:00:00 | 496597
27 | 290700 | AUD | 2011-08-30 00:00:00 | 290700
28 | 1225900 | USD | 2011-08-30 00:00:00 | 1225900
29 | 561838 | GBP | 2011-08-30 00:00:00 | 561838
30 | 611476 | GBP | 2011-08-30 00:00:00 | 611476
31 | 644174 | GBP | 2011-08-30 00:00:00 | 644174
32 | 541685 | GBP | 2011-08-30 00:00:00 | 541685
33 | 548868 | USD | 2011-08-30 00:00:00 | 548868
34 | 456083 | GBP | 2011-08-30 00:00:00 | 456083
35 | 540984 | GBP | 2011-08-30 00:00:00 | 540984
36 | 716847 | GBP | 2011-08-30 00:00:00 | 716847
37 | 1306110 | USD | 2011-08-30 00:00:00 | 1306110
38 | 782784 | GBP | 2011-08-30 00:00:00 | 782784
39 | 623832 | USD | 2011-08-30 00:00:00 | 623832
40 | 670602 | GBP | 2011-08-30 00:00:00 | 670602
41 | 517072 | GBP | 2011-08-30 00:00:00 | 517072
42 | 558660 | GBP | 2011-08-30 00:00:00 | 558660
Spreadsheet: sally_beck__34335__Cashflow Forecast Estate 12-18r
Sheet: O&M_Detail

OPERATING EXPENSES - Cash Basis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | 2001-12-31 00:00:00 |  | 2002-01-31 00:00:00 |  | 2002-02-28 00:00:00 |  | 2002-03-31 00:00:00 |  | 2002-04-30 00:00:00 |  | 2002-05-31 00:00:00 |  | 2002-06-30 00:00:00 |  | 2002-07-31 00:00:00 |  | 2002-08-31 00:00:00 |  | 2002-09-30 00:00:00 |  | 2002-10-30 00:00:00 |  | 2002-11-30 00:00:00 |  | 2002-12-31 00:00:00 |  | 2003-01-31 00:00:00 |  | 2003-02-28 00:00:00 |  | 2003-03-31 00:00:00 |  | 2003-04-30 00:00:00 |  | 2003-05-31 00:00:00 |  | 2003-06-30 00:00:00 |  | 19 Months
Headcount
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | 3rd Party Contractors
 |  | Total
Salaries, Wages & Benefits
 | Salaries & Wages
 | Benefits
 |  | Total
Severance
Employee  Expenses
 | Individual and Group Meals - Non-Client
 | Group Entertainment - Non-Client
 | Client and Recruiting Meals & Entertainment
 | Travel-Airfare
 | Travel-Lodging
 | Travel-Meals
 | Travel-Other
 | Other employee expenses
 |  | Total
Outside Services
 | Outside Services-Legal
 | Outside Services-IT
 | Outside Services-Audit
 | Outside Services-Tax
 | Outside Services-Accounting
 | Outside Services-Other
 |  | Total
Technology Expense
 | Computer Expense
 | Other
 |  | Total
Other Operating Expenses
 | Rent (cash exp only)
 | Analyst / Associate Allocation
 | Advertising
 | Communications Expense
 | Supplies & Expenses
 | Subscriptions & Publications
 | Charitable Contributions
 | Other Operating Expenses
 |  | Total
Taxes Other Than Income
 | Payroll Taxes
 | Property Taxes
 | Other Taxes
 |  | Total
(Allocation) to NETco
 | Salaries, Wages & Benefits
 | Employee  Expenses
 | All Other
 |  | Total
TOTAL OPERATING EXPENSES
Spreadsheet: 208846d1358948896-extracting-data-based-on-partial-data-in-a-cell-example-data-extract-requirement
Sheet: Sheet1

ps23487 | CIG-HAS-CS | 15487.25 |  | Extract this row
UY67543 | CIG-KGF-OCC | 26545
JG5643 | REV-HAS-GB | 6969.25
KY1298 | SAW-CS-GAV | 3568.21 |  | Extract this row
PU7867 | GQ-ZAQ-KY | 1548
DS2534 | Acc-CS | 1547.24 |  | Extract this row