tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 101323d1299487998-unsorted-address-list-adds
Sheet: Sheet1

A & E A Brodie Royal Bank Buildings 40 High Street LP - 2 Banff
A & J C Allan & Co North Bank Chambers 36 Newmarket Street LP - 3 Falkirk
A & R Robertson & Black WS Bank Street LP - 4 Blairgowrie
Ayr Faculty of Solicitors c/o Queen's Court House 39 Sandgate LP - 29 Ayr
B D O LLP 4 Atlantic Quay 70 York Street LP - 55 Glasgow 6
B S W Solicitors 20 Douglas Street LP - 27 Dunfermline
Bailford Trustees Ltd Dalmore House 310 St Vincent Street LP - 2 Glasgow.12
[NAME] 16 Alexander Street LP - 11 Clydebank
Baillies 37 Union Street LP - 4 Dundee
Baird & Co 2 Park Place LP - 3 Kirkcaldy
Baird & Co 7 St. Catherine Street LP - 3 Cupar
Baird & Co North House North Street LP - 3 Glenrothes
Balfour & Manson LLP 54-66 Frederick Street LP - 12 Edinburgh 2
Carr & Co 81 Main Street Baillieston LP - 2 Baillieston
[NAME] Crichton 90 Main Street LP - 13 Rutherglen
[NAME] 97-99 West Regent Street LP - 24 Glasgow 1
[NAME] 71 Main Street LP - 3 Beith
Carruthers Curdie Sturrock & Co 1 Howard Street LP - 4 Kilmarnock
Carruthers Gemmill 81 Bath Street LP - 11 Glasgow 1
Carson & Trotter CA 236 King Street LP - 6 Castle Douglas
[NAME] 123 Irish Street LP - 19 Dumfries
Spreadsheet: 763918d1642455264-irr-from-table-of-mixed-monthly-returns-irrs-from-returns-table
Sheet: Returns

INVESTMENT | RETURN DATE | AMOUNT
Woodside Apartments | 2016-12-18 00:00:00 | -50000
Woodside Apartments | 2017-01-01 00:00:00 | 300
Woodside Apartments | 2017-02-01 00:00:00 | 300 |  |  |  | INVESTMENT | IRR
Woodside Apartments |  | 300 |  |  |  | Woodside Apartments
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 150
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 217
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 485
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 524
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-04-15 00:00:00 | -50000
Woodside Apartments |  | 300
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-06-01 00:00:00 | 315
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-07-01 00:00:00 | 315
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-08-01 00:00:00 | 315
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-09-01 00:00:00 | 315
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-10-01 00:00:00 | 315
Woodside Apartments |  | 300
Lazy Y Ranch | 2021-11-01 00:00:00 | 315
Woodside Apartments |  | 649
Woodside Apartments | 2021-12-01 00:00:00 | 27771
Woodside Apartments | 2021-12-01 00:00:00 | 50000
Lazy Y Ranch | 2021-12-01 00:00:00 | 315
Spreadsheet: 743707d1628681692-create-a-regular-vertical-database-database
Sheet: Sheet7

 | Data |  |  |  |  | Expected Result |  |  | [NAME] results
Name | Blue | Green |  | Name | Quantity | Amount | Color |  | Name | Quantity | Amount | Color
A | 11 | 12 |  | A | 11 | 101 | blue
A | 101 | 102 |  | A | 12 | 102 | green
B | 13 | 14 |  | B | 13 | 103 | blue
B | 103 | 104 |  | B | 14 | 104 | green
C | 15 | 16 |  | C | 15 | 105 | blue
C | 105 | 106 |  | C | 16 | 106 | green
Spreadsheet: 840099d1692427355-copy-all-data-to-a-summary-sheet-on-a-per-date-basis-copy-of-new-microsoft-excel-worksheet
Sheet: raw form

 | ELISEO STARLAND SAUSAGES (VACUUM PACKS & BULK)
DATE | [NAME] | CARTON WEIGHT (KG) | TOTAL CTNS | TOTAL WEIGHT
16/08/2023 | [NAME] 3 X 5KG | 15 | 140
 | [NAME] 20 X 500G | 10 | 0
 | [NAME] 15 X 700G | 10.5 | 0
 | [NAME] BULK 20KG | 20 | 0
 | SAVELOY SAUSAGE 4 X 5KG | 20 | 156
 | SAVELOY SAUSAGE 20 X 500G | 10 | 22
 | SAVELOY SAUSAGE 15 X 700G | 10.5 | 30
 | SAVELOY SAUSAGE BULK 20KG | 20 | 0
 |  |  | TOTAL OUTPUT = |  | KGs
 | ELISEO STARLAND LAMB FLAPS (TRAY PACKS & BULK)
 | [NAME] | CARTON WEIGHT (KG) | TOTAL CTNS | TOTAL WEIGHT
 | LAMB FLAP 20 X 500G | 10 | 56
 | LAMB FLAP 15 X 700G | 10.5 | 56
 | SAW DUST |  |  | 40
 |  |  | TOTAL OUTPUT = |  | KGs
Spreadsheet: 675616d1588368932-if-formula-pricing-model
Sheet: Calculator

No. of learners | 600 | Total of contract
Length of contract | 2 | 1,2 or 3 years
[NAME] |  | Number |  | Average Value
OTS Level 1 |  | Number
OTS Level 2
OTS Level 3
XRLP
Prototyper
[NAME]
OOH
 |  |  | Per User/ Month
 |  |  | Per User/ Year
 |  |  | Setup Costs
 |  |  | Monthly Cost
 |  |  | Annual Cost
 |  |  | Contract Value
Spreadsheet: 676328d1588762046-bill-amount-automatically-changing-depending-on-which-month-year-selected-finances
Sheet: MonthsYears

Month | 4 or 5 Week Month | Year
January | 4 | 2020
February | 4 | 2021
March | 5 | 2022
April | 4
May | 4
June | 5
July | 4
August | 5
September | 4
October | 4
November | 5
December | 4
Spreadsheet: 716767d1612359280-how-to-convert-the-currency-and-then-sum-up-into-single-currency-book1
Sheet: Sheet1

CNY | 0.15
HKD | 0.12
IDR | 0.0007
Name | currency | J | F | M
[NAME] | CNY | 100 | 20 | 30
[NAME] | CNY | 50 | 30 | 20
[NAME] | CNY | 100 | 40 | 30
[NAME] | HKD | 50
[NAME] | HKD | 60 |  | 50
[NAME] | HKD
[NAME] | IDR | 50 | 20 | 30
[NAME] | IDR | 20 | 20
[NAME] | IDR | 30 |  | 10
[NAME] | USD
[NAME] | USD
[NAME] | USD
Spreadsheet: 109c013a-c216-4ec0-8a79-5d39449e6aae
Sheet: Sheet1

CONTRACT LIST AS OF | Unnamed: 1 | Unnamed: 2
April 1, 2008
WAKE FOREST UNIVERSITY HEALTH SCIENCES
HEALTH MAINTENANCE ORGANIZATIONS | WFUP | NCBH
AARP [NAME] (Formerly SECURE HORIZONS MEDICARE COMPLETE by United Healthcare) | x | x
AETNA HEALTH OF THE CAROLINAS, INC. | x | x
BCBS BLUE HMO (for RJR Employees) | x | x
BCBS BLUE CARE | x | x
BLUE MEDICARE HMO (Formerly PARTNERS MEDICARE CHOICE) | x | x
CIGNA EPO | x | x
CIGNA HMO | x | x
[NAME] NORTH CAROLINA, INC. | x | x
UNITED HEALTHCARE | x | x
WELLPATH (A Coventry Health Care Plan) | x | x
POINT OF SERVICE | WFUP | NCBH
AETNA HEALTH OF THE CAROLINAS, INC. | x | x
[NAME] CHOICE | x | x
CIGNA POS | x | x
WELLPATH (A Coventry Health Care Plan) | x | x
PREFERRED PROVIDER ORGANIZATIONS | WFUP | NCBH
AARP [NAME] CHOICE (Formerly SECURE HORIZONS MEDICARE COMPLETE CHOICE by United Healthcare) | x | x
AETNA HEALTH OF THE CAROLINAS, INC. | x | x
BCBS BLUE OPTIONS (Incl SHP offerings:[NAME], Smart Choice and Smart Choice Plus) | x | x
BLUE MEDICARE PPO | x | x
CARELINK OF WEST VIRGINIA (A Coventry Health Care Plan) | x | x
CAROLINA ACCESS | x | x
CIGNA | x | x
CHOICECARE NETWORK/HUMANA | x | x
COVENTRY HEALTH CARE NATIONAL NETWORK (Incl. Mail Handlers) | x | x
COVENTRY HEALTH CARE PLANS (Incl. Southern Health, Carelink of West Va., Coventry One, Assurant) | x | x
CRESCENT | x | x
DIRECT NET | x | x
EVERCARE | x | x
FIRST HEALTH NETWORK (Incl. CCN and SouthCare) | x | x
GATEWAY HEALTH ALLIANCE | x | x
HEALTHCARE ACCESS (Formerly Doctors' Care Plan - Both WFUHS and NCBH accept patients)
HUMANA/CHOICECARE NETWORK | x | x
MAMSI LIFE & HEALTH PPO &  ALLIANCE PPO - Purchased by United HealthCare | x | x
[NAME] | x | x
MEDCOST BENEFIT SERVICES | x | x
MOHAWK CARPETS | x | x
ONENET (New name for ALLIANCE PPO) | x | x
OPTICARE/TOTAL VISION HEALTH PLAN/PRIME VISION (Eye care network for CIGNA) | x
PREFERRED CARE OF VA | x | x
PRIMARY PHYSICIAN CARE | x | x
SOUTHERN HEALTH SERVICES, INC. (A Coventry Health Care Plan) | x | x
TWIN COUNTY PHO | x | x
UNITED HEALTHCARE | x | x
INDEMNITY/COMMERCIAL PRODUCTS | WFUP | NCBH
[NAME] (NC Sate Employees & Teachers Group Health) | x | x
BCBS CLASSIC BLUE | x | x
MAMSI LIFE & HEALTH - USA | x | x
DIRECT EMPLOYER CONTRACTS | WFUP | NCBH
TYSON FOODS INC | x | x
MENTAL HEALTH | WFUP | NCBH
CAROLINA BEHAVIORAL HEALTH ALLIANCE | x | x
CENTERPOINT | x | x
UNITED BEHAVIORAL HEALTH | x
UNITED BEHAVIORAL HEALTH INTENSIVE OUTPATIENT PROGRAM | x
MEDICARE PRIVATE FEE FOR SERVICE - ACCEPT | WFUP | NCBH
ADVANTRA FREEDOM | x | x
HUMANA GOLD CHOICE | x | x
SECURE HORIZONS Medicare Direct by United Helathcare | x | x
SECURITY CHOICE - UNICARE | x | x
STERLING HEALTH PLANS Option 1 and Options 2 | x | x
TODAY'S OPTIONS -PYRAMID LIFE | X | X
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: transcol

 | TransColorado
 | 500632
Day | Measured | Scheduled
1 | 68110 | 67388
2 | 52575 | 52388
3 | 52618 | 52388
4 | 60235 | 59388
5 | 52944 | 52388
6 | 60647 | 62388
7 | 63117 | 62388
8 | 72994 | 72388
9 | 134234 | 133583
10 | 132100 | 133583
11 | 134813 | 133583
12 | 144825 | 137693
13 | 149457 | 148910
14 | 128254 | 127976
15 | 117231 | 116363
16 | 107320 | 106674
17 | 97555 | 96821
18 | 106400 | 105865
19 | 122694 | 121355
20 | 125257 | 129965
21 | 122398 | 122873
22 | 97344 | 96505
23 | 112641 | 111347
24 | 108996 | 108654
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | 93484
2001-06-24 00:00:00
Spreadsheet: sally_beck__34266__PGE_EXPOSURE_JAN23
Sheet: CD-OPT

 |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Phy/ | [NAME] | Opt |  | Option | Monthly | Option | Stike | Mid | Mid | Mid | Premium | Code | Code | Code
Counterparty | Deal Num | Pub Code | Fin | Put | Type | Period | [NAME] | Option Qty | Delta | Price | Price | Vol | Value | Value |  |  |  |  | RECAP: | Physical | Financial | Total |  | Codes
PGEENETRACAN | Q82147.1 | NGMR-AECO/C | F | C | EUR | 2001-01-01 00:00:00 | 2001-01-02 00:00:00 | 0 | 0 | 4.89260815 | 9.02420605 | 0.6 | -1213959.5893 | 0 |  |  |  |  | 2001-01-01 00:00:00 |  |  |  |  | 36892P | 36892F
PGEENETRACAN | Q82147.1 | NGMR-AECO/C | F | C | EUR | 2001-02-01 00:00:00 | 2001-02-01 00:00:00 | -265388.7566 | -264985.2846 | 4.8932448 | 7.91657105 | 0.67 | -801138.557 | 0 |  |  |  |  | 2001-02-01 00:00:00 |  |  |  |  | 36923P | 36923F
PGEENETRACAN | Q82147.1 | NGMR-AECO/C | F | C | EUR | 2001-03-01 00:00:00 | 2001-03-01 00:00:00 | -293823.2663 | -271290.2791 | 4.89393622 | 6.424 | 0.625 | -459677.2002 | 0 |  |  |  |  | Rest
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Check
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BY ENTITY:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | January: | Physical | Financial |  |  | Codes:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRACAN01-JAN-2001 |  |  |  |  | PGEENETRACAN01-JAN-2001P | PGEENETRACAN36892F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRAGAS01-JAN-2001 |  |  |  |  | PGEENETRAGAS01-JAN-2001P | PGEENETRAGAS01-JAN-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEGASNW01-JAN-2001 |  |  |  |  | PGEGASNW01-JAN-2001P | PGEGASNW01-JAN-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG&E01-JAN-2001 |  |  |  |  | PG&E01-JAN-2001P | PG&E01-JAN-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRACAN01-FEB-2001 |  |  |  |  | PGEENETRACAN01-FEB-2001P | PGEENETRACAN36923F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRAGAS01-FEB-2001 |  |  |  |  | PGEENETRAGAS01-FEB-2001P | PGEENETRAGAS01-FEB-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEGASNW01-FEB-2001 |  |  |  |  | PGEGASNW01-FEB-2001P | PGEGASNW01-FEB-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG&E01-FEB-2001 |  |  |  |  | PG&E01-FEB-2001P | PG&E01-FEB-2001F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRACAN |  |  |  |  | PGEENETRACANP | PGEENETRACANF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEENETRAGAS2001 |  |  |  |  | PGEENETRAGASP | PGEENETRAGASF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PGEGASNW |  |  |  |  | PGEGASNWP | PGEGASNWF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PG&E |  |  |  |  | PG&EP | PG&EF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Checks
Spreadsheet: 275998d1383719634-formula-to-check-for-name-and-give-a-percentage-lolchamps
Sheet: After

Champ | VS | [NAME] | Score | Game |  |  |  |  |  |  | Champ | LaneWin% | GameWin%
Irelia |  | Yes | 21/1/10 | Yes |  |  |  |  |  |  | Irelia | 0.6 | 0.2
Irelia |  | No |  | no |  |  |  |  |  |  | [NAME] | 0.5 | 0.5
Kog |  | Yes |  | no |  |  |  |  |  |  | Kog | 1 | 0
Irelia |  | yes |  | No
Irelia |  | yes |  | No
[NAME] |  | yes |  | no
[NAME] |  | No |  | Yes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | I INSERTED THEM MANUALLY, BUT THE FORMULA SHOULD CHECK FOR THE NAME ex. IRELIA AND GIVE ME PERCENTAGE OF ALL IRELIA INSTANCES IN COLUMN A.
Spreadsheet: 83999d1284009667-average-over-a-text-range-using-a-vlookup-in-column-2nd-average
Sheet: Master

MOCK | ATTAINMENT_GRADE | TARGET_GRADE | Y11 Mock | [NAME] | GCSE Result | covert value
Internal Exam: A | AB | A* | BC | A* | B | 6
Internal Exam: C | A | A* | D | A | B | 6
Internal Exam: C | AB | B | BC | A | B | 6
Internal Exam: B | AB | A | C | A | B | 6
Internal Exam: C | B | A | C | A | B | 6
Internal Exam: A | A | A* | B | A* | A | 7
Internal Exam: A | A | A* | B | A* | A* | 8
Internal Exam: A | A | A* | C | A* | NA | 8
Internal Exam: B | AB | A | CD | A | NA | 5
Internal Exam: A* | B | A* | AB | A* | B | 6
Internal Exam: C | C | B | C | B | D | 4
Internal Exam: B | BC | A | AB | A | A | 7
Internal Exam: C | B | A | C | B | C | 5
Internal Exam: B | A | A* | B | A* | A | 7 |  | Aver of GCSE |  |  | <<< should be
Internal Exam: A | A | A | AB | A* | A* | 8
Internal Exam: B | B | A* | B | B | B | 6 |  | Ave of [NAME] | Ave of Y11 Mock | Ave of [NAME]
Internal Exam: A | AB | A | BC | A | B | 6
 |  |  |  |  |  |  |  | Difference GCSE - Y10 | Difference GCSE - Y11 mock | Difference GCSE - Y11 Att
Internal Exam: C | C | B | C | C | E | 3
Internal Exam: A* | A* | A* | BC | A* | A* | 8
Internal Exam: A | A | A* | C | A | A | 7
Internal Exam: D | D | C | D | C | E | 3
Internal Exam: B | A | A* | BC | A* | B | 6
Internal Exam: BC | AB | A | C | B | A | 7 |  | Also it should ingore the "NA" as it divde for the returned average value
Internal Exam: A | A | A* | C | AB | A | 7
Internal Exam: A | A* | A* | A* | A* | A* | 8
Internal Exam: A | A | A* | B | A* | A | 7
Internal Exam: A | A | AB | C | B | C | 5
Internal Exam: A | A | A* | B | A | B | 6
Internal Exam: B | A | A* | B | A* | B | 6
Internal Exam: C | A | A* | A | A* | A | 7
Internal Exam: D | D | B | 0 | C | NA | 0 |  | Aver of GCSE |  |  | <<< should be
Internal Exam: A | A | A* | B | A | C | 5
Internal Exam: A | A* | A* | B | A* | A* | 8 |  | Ave of [NAME] | Ave of Y11 Mock | Ave of [NAME]
Internal Exam: BC | A | A* | A | A* | A* | 8
Internal Exam: A | A | A* | C | B | C | 5 |  | Difference GCSE - Y10 | Difference GCSE - Y11 mock | Difference GCSE - Y11 Att
Internal Exam: A | A | A* | AB | A | A | 7
Spreadsheet: 860222d1708409379-need-help-with-rag-status-for-multiple-projects-project-kpi-status-hd
Sheet: Project KPIs

Project KPIs Status
Project Name | Client | Project KPIs |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00
Project-1 | GS1 | Delivery | Green | Green | Green
Project-1 | GS1 | Utilization | Green | Green | Green
Project-1 | GS1 | Quality | Green | Green | Green
Project-1 | GS1 | Resources | Green | Green | Green
Project-2 | HA1 | Delivery | Amber | Green | Green
Project-2 | HA1 | Utilization | Green | Green | Green
Project-2 | HA1 | Quality | Green | Green | Green
Project-2 | HA1 | Resources | Green | Green | Red
Project-3 | HA1 | Delivery | Green | Green | Green
Project-3 | HA1 | Utilization | Green | Green | Green
Project-3 | HA1 | Quality | Green | Green | Green
Project-3 | HA1 | Resources | Green | Green | Green
Project-4 | HA1 | Delivery | Green | Red | Green
Project-4 | HA1 | Utilization | Green | Green | Green
Project-4 | HA1 | Quality | Green | Green | Green
Project-4 | HA1 | Resources | Green | Green | Green
Project-5 | HA1 | Delivery | Green | Green | Green
Project-5 | HA1 | Utilization | Green | Green | Green
Project-5 | HA1 | Quality | Green | Green | Green
Project-5 | HA1 | Resources | Green | Green | Green
Project-6 | HA1 | Delivery | Green | Green | Green
Project-6 | HA1 | Utilization | Green | Green | Green
Project-6 | HA1 | Quality | Green | Green | Green
Project-6 | HA1 | Resources | Green | Green | Green
Spreadsheet: 153963d1336132164-somewhat-complex-document-problems-extracting-and-organizing-data-from-cells-6maxhyper
Sheet: Sheet1

 | Players | [NAME] | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | Seat 1 | Seat 2 | Seat 3 | Seat 4 | Seat 5 | Seat 6 |  | If there are 6 players and seat #1 has button, seat #2 will have SB, seat #3 BB, #4 UTG, #5 MP and #6 will have CO.
 | 6 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If #2 has button then #3 has SB, #4 BB, #5 UTG, #6 MP and #1 CO and so on. If there are 5 players then there is no MP
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | and if there are 4 players there is no MP and no UTG. If there are only 3 players (the minimum) then there is only
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BU, SB and BB.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | BU | SB | BB | UTG | MP | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | BU | SB | BB | UTG | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | BU | SB | BB | CO
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | BU | SB | BB
Spreadsheet: 105804d1303090919-referencing-other-worksheets-and-then-some-chapterfinancialrecordstemplate
Sheet: Nov

 | November 2010 Account Register
 | Number | Date | Description of Transaction | C | Debit   (-) | Credit (+) | Balance
Spreadsheet: 99111d1297864499-conditional-formatting-following-a-drop-down-box-entry-test_sales-v2
Sheet: Jan-Feb-March Deals

Initial Quote Date | Call Back Date | Renewal Date | Business Name | Contact | Quote Ref | Deal Value | Est Profit | Status | Notes
11/02/2011 |  |  | Company 1 |  |  | 2400 |  | Ongoing - 50/50 Interest |  |  |  |  | Won - Dean
11/02/2011 |  |  | Company 2 |  |  | 23704.8 |  | Won - Dean |  |  |  |  | Won - Eddie
09/02/2011 |  |  | Company 3 |  |  | 8744.4 |  | Lost - To Competitor |  |  |  |  | Lost - To Competitor
08/02/2011 |  |  | Company 4 |  |  | 2090.4 |  | Ongoing - Interested in Booking an Appointment |  |  |  |  | Lost - Purchased Equipment
08/02/2011 |  |  | Company 5 |  |  | 4653.6 |  | Ongoing - Information Sent |  |  |  |  | Lost - Not Interested / Happy with Existing Support
 |  |  |  |  |  |  |  | Won - Eddie |  |  |  |  | Lost - Unable to Obtain Finance
 |  |  |  |  |  |  |  | Lost - Purchased Equipment |  |  |  |  | Ongoing - Interested in Booking an Appointment
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - Awaiting Current Renewal Date
 |  |  |  |  |  |  |  |  |  |  |  |  | Ongoing - 50/50 Interest
 |  |  | example |  |  |  |  | Lost - Purchased Equipment |  |  |  |  | Ongoing - Information Sent
Spreadsheet: 165039d1340995564-excel-2007-how-do-i-use-index-match-formula-to-pull-certain-information-tart-check-grades-by-growers
Sheet: Grower 1

 |  |  |  |  | GRADER
 |  |  |  |  | Scott | SG |  | Ingrid | IR
 |  |  |  |  | Claudia | CG |  | [NAME] | AG
 |  |  |  |  | Teresa | CG |  | [NAME] | AK
 | GRADE | BLOCK | GRADER |  | Becky | RZ |  | Leo | LS
Spreadsheet: 215394d1361368395-subtotal-sum-if-questions-summingnonhidden
Sheet: Sheet1

 |  |  |  |  |  | G | H | I
 |  |  |  |  | A | Actual | 3 | 2
 |  |  |  |  | B | Actual | 6 | 1
 |  |  |  |  | A | Plan | 12 | 3
 |  |  |  |  | B | Actual | 2 | 4
 |  |  |  |  | A | Plan | 1 | 1
 |  |  |  |  | B | Plan | 1 | 1
 |  |  |  |  | A | Actual | 3 | 2
 |  |  |  |  | B | Actual | 6 | 1
 |  |  |  |  | A | Plan | 12 | 3
 |  |  |  |  | B | Actual | 2 | 4
 |  |  |  |  | A | Plan | 1 | 1
 |  |  |  |  | B | Plan | 1 | 1
Spreadsheet: 865004d1712121858-maybe-a-vlookup-or-something-close-help-24-aligw
Sheet: Sheet1

 | TAB 1 |  |  |  | TAB 2
 | Employee | Monday |  |  |  | Search Each Type of area for employee name
 | [NAME] |  |  |  |  | Monday
 | [NAME] | Totes Station 2 |  |  | Ice Station 1 | [NAME]
 | [NAME] | Ice Station 1 |  |  | Ice Station 2 | [NAME]
 | [NAME] | Ice Station 2
 | [NAME] | Dry Station 2 |  |  | Dry Station 1 | [NAME]
 | [NAME] | Totes Station 1 |  |  | Dry Station 2 | [NAME]
 |  |  |  |  | Totes Station 1 | [NAME]
 |  |  |  |  | Totes Station 2 | [NAME]
Spreadsheet: 92013d1291687464-trying-to-pull-only-certian-data-from-a-list-to-a-summary-sheet-sample
Sheet: Month1

Equipment # | Part | Quantity
A1 | 3 | 6 |  | The data here was set up with a Dynamic Named Range
A1 | 4 | 3 |  | The named range is limited to the sheet.  That is, it was
A1 | 3 | 2 |  | created as Month1!Data.  This means when the sheet is
A1 | 2 | 1 |  | copied, there is a named range that is local to the new
A1 | 5 | 3 |  | tab.
A1
A1 |  |  |  | Month1!Data was set up with the following formula:
A1
A1 | 5 | 8 |  | The COUNTA(Month1!$A:$A) should be substituted with a column that has
A1 | 1 | 7 |  | values in every row.
A1 | 6 | 2
A1 | 7 | 1
A1 | AB | 3 |  | A limitation of PivotTables is all the columns in the PivotTable need to have titles.
Spreadsheet: 771798d1646852562-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-sample-for-excel-forums-updated
Sheet: Client00005

 | Simple |  | Medium |  | Complex
Title 1 |  | x |  | x |  | x | Tasks | Simple |  |  |  | Product Type
 |  |  |  | x |  | x |  | Medium
Title 2 |  |  |  |  |  | x |  | Complex
 |  |  |  |  |  |  |  | Total |  |  |  | Type B1
 |  |  |  |  |  |  | >3 Complex = Complex > 10 Medium = Complex > 25 Medium + Simple = Complex
Title 3
Spreadsheet: 267028d1379915443-need-help-with-countif-and-date-range-situation-book1
Sheet: Sheet2

L3AAB8Y - 350M
L3AAC5C - 3L8L
L3AAF6Y - 2DRL
L3AGD7K - 23JC
L3AGD7K - 35ZG
L3AGF8Y - 3FLP
L3AMW9N - 2Y0C
LR007KT47 - 35P0
LR00YCVGV - 38S8
LR028HH - 3191
LR028TX - 3HXH
LR0AX1B - 3HSZ
LR0TKZT - 3DKM
LR0WY39 - 2MFT
LR0XE23 - 36LS
L3AAB8Y - 350M
L3AAC5C - 3L8L
L3AAF6Y - 2DRL
L3AGD7K - 23JC
L3AGD7K - 35ZG
Spreadsheet: 599463d1543093580-solver-not-maximizing-stocks
Sheet: Pivot

Row Labels | Sum of % of Portfolio
Communication Services | 0.1263011074656465
Consumer Des | 0.149559488226613
[NAME] | 0.146755220006658
Energy | 0
Financial | 0
Health Care | 0.1947962822194886
Industrials | 0.2521616141476467
Internet | 0.05782284466107564
IT | 0
Materials | 0.07260344327287163
(blank)
Grand Total | 1
Spreadsheet: 118512d1313742395-return-a-value-from-x-and-y-coordinates-rhc-schedule
Sheet: Timetable

Period | Day 1 |  |  | Day 2 |  |  | Day 3 |  |  | Day 4 |  |  | Day 5 |  |  | Day 6
1 | 11 | SCI | B8 |  |  |  | 12 | BIO | [NAME] | 10 | SCI | B3
2 |  |  |  |  |  |  | 11 | SCI | B8 |  |  |  | 12 | BIO | [NAME] | 10 | SCI | B3
3 | 10 | SCI | B3 |  |  |  | 9 | SCA | Y4 | 11 | SCI | B8 |  |  |  | 12 | BIO | [NAME]
4 |  |  |  | 12 | BIO | [NAME] | 10 | SCI | B3 | 9 | SCA | Y4 |  |  |  | 11 | SCI | B8
5 |  |  |  | 11 | SCI | B8 |  |  |  | 12 | BIO | [NAME] | 9 | SCA | Y4
6
Spreadsheet: 737047d1624059565-lookup-formula-not-working-also-tried-v-and-x-lookups-any-other-suggestions-test-2
Sheet: Master

 | Office Costs |  |  |  |  | Specialty Codes that cost more
 | Procedure Code | Cost | [NAME] | Total |  | Code | Extra Amount
 | 1 | 200 |  |  |  | 2 | 100
 | 2 | 400 |  |  |  | 3 | 200
 | 3 | 600 |  |  |  | 6 | 300
 | 4 | 800 |  |  |  | 9 | 400
 | 5 | 1000 |  |  |  | All Else | 0
 | 6 | 1200
 | 7 | 1400
 | 8 | 1600
 | 9 | 1800
 | 10 | 2000