tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1c220043-daa0-4564-bed9-7095a215220c
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 41. OPERATING LEASE FINANCE COMMITMENTS, By Industry: Australia, Original ($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
Agriculture, forestry and fishing ; |  |  | Original | A2413817T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2413818V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2413819W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2413820F | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2413821J | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2413823L | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2413824R | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2413825T | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2413826V | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2413827W | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2413828X | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2413829A | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413830K | 1985-01-01 00:00:00 | 2011-02-01 00:00:00 | 314 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: mary_fischer__25397__ClearSkypavout0302
Sheet: Summary

Summary Of Performance
Month | 2002-01-01 00:00:00 | 2002-02-01 00:00:00 | 2002-03-01 00:00:00
Production, kWh
Monthly Generated kWh, Before Line Loss
Monthly Assumed Line Loss
Monthly Generated kWh, After [NAME] Loss 2
Monthly Generated MWh, After [NAME]
Projected MWh, After [NAME] Loss 1 | Not avail | Not avail | Not avail
Production MWh [NAME], From Projected | Not avail | Not avail | Not avail
YTD Generated kWh, After [NAME]
[NAME] MWh, After [NAME]
Availability
Monthly Contractual Availability
YTD Contractual Availability
Projected Contractual Availability | Ramp Up | Ramp Up | Ramp Up
Notes:
1)  Projections not provided to EWC.   Therefore, no MWh [NAME] comparison is possible.
2)  The January and March production are within 0.3% of the substation values assuming a 2% line loss.  February is still being researched.
Spreadsheet: 702482d1604379078-need-the-drop-down-to-go-through-different-scenarios-by-pressing-f9-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | These cannot be changed. We cannot link it to main model
 |  |  |  |  |  | Is it possible that this goes through 1-3 automatically by pressing F9? |  |  |  |  |  |  |  |  |  | Revenue
 |  |  |  |  | Scenario | 1 |  |  |  |  |  |  |  |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 1 | 5 | 10 | 15 | 20 | 25 | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 2 | 3 | 5 | 7 | 9 | 11 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 3 | 2 | 2 | 4 | 4 | 5 | 5.8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rows in P&L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Revenue
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 | 2021 | 2022 | 2023 | 2024 | 2025
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Scenario 3
Spreadsheet: 866148d1713103104-average-total-cost-on-a-tiered-pricing-table-cost-1-mohamedgadallah
Sheet: Sheet1

Quantity | 13000
Tier | Quantity Range | Cost per Unit | Total Cost
Tier 1 | 1 - 5,999 | 10.5
[NAME] | 6,000 - 7,999 | 10
Tier 3 | 8,000 - 9,999 | 9.5
[NAME] | 10,000 - 12,499 | 9
Tier 5 | 12,500 - 14,999 | 8.5
Tier 6 | 15,000 - 19,999 | 8
Tier 7 | 20,000 or above | 7.5
 |  | Average cost
Spreadsheet: 803053d1667232158-group-and-ungroup-employee-attendance-tracker-4-
Sheet: Company Holidays

 | Company Holidays
 | Company Holidays | Description
 |  | New Years's Day
 |  | New Year Holiday
 |  | Good Friday
 |  | Easter Monday
 |  | May Day
 |  | Late May Bank Holiday
 |  | The Queens's Platinum Jubilee
 |  | Summer bank holiday
 |  | Boxing day
 |  | Christmas day
Spreadsheet: 708539d1607922624-looking-formula-from-other-sheet-and-specific-column-sample-check
Sheet: COM

 |  |  |  |  |  |  | Result should be (example)
NO | [NAME] | RO | SEGMEN | Bucket Nov | BUCKET | Loss Rate Nov | Loss Rate Nov | DPD Max | Outstanding | LOSS | % CKPN | ADD
2520089 | [NAME] | 3 | OOO | 1 | 5 | formula ? | 0.422363900149256 |  | 263914916073.32 | 2015140826.59199
1421113 | [NAME] | 3 | OOO | 1 | 4 | formula ? | 0.2972278671695063 |  | 221112228939.0998 | 1748824931.63287
2879593 | [NAME] | 3 | OOO | 1 | 2 | formula ? | 0.09545138732200557 |  | 123528765176.81 | 173298267.9833039
3392134 | [NAME] | 3 | OOO | 1 | 2 | formula ? | 0.09545138732200557 |  | 122968957762.83 | 1003606433.811523
2852066 | [NAME] | 3 | OOO | 1 | 5 | formula ? | 0.4223639001492558 |  | 108563587180.57 | 903301378.498397
2027868 | [NAME] | 2 | OOO | 1 | 2 | formula ? | 0.08251497098306088 |  | 102377757771.63 | 780292344.6672587
1166132 | [NAME] | 4 | OOO | 1 | 5 | formula ? | 0.362254226986679 |  | 100664220009.9 | 317340019.8517557
1128067 | [NAME] | 6 | OOO | 1 | 5 | formula ? | 0.3208682078434202 |  | 91949725515.71994 | 306199202.1679718
1565621 | [NAME] | 4 | OOO | 1 | 3 | formula ? | 0.181581375647561 |  | 89511625734.95998 | 379648320.2113815
3366069 | [NAME] | 4 | OOO | 1 | 2 | formula ? | 0.08859936856898892 |  | 88801226828.24 | 421306527.3399
2060385 | [NAME] | 6 | OOO | 1 | 2 | formula ? | 0.06948185915873285 |  | 86675527263.22998 | 298870494.5509707
3136967 | [NAME] | 15 | OOO | 1 | 2 | formula ? | 0.1339468787572012 |  | 84093761690.97 | 641255799.773328
3391556 | [NAME] | 15 | OOO | 1 | 3 | formula ? | 0.244380539746422 |  | 82580307078 | 687004371.793733
 |  |  |  | I want to fill in the numbers 1 to 5 in the "F" column as per my wish. And in column G, it contains data from the "lookup" sheet based on column F and column RO from sheet "COM". Please kindly help
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 1-12 thru 1-18

 |  |  |  |  |  | System:
 |  |  | 2009-01-12 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-01-12 00:00:00 |  |  |  |  |  |  | Total
1 |  |  | 57 |  |  |  | 65
2 |  |  |  |  |  | 60.71
3 |  |  | 51
4 |  | 31.68 |  | 32.16 |  | 36.73
5 |  |  | 29.52 |  |  |  | 36.28
6 |  |  |  |  | 10.07 | 37.44
7 |  |  |  | 34.54
8 |  |  |  | 33.24 | -
9 |  |  |  | 36.13
10 |  |  |  |  | 31
11
12 |  |  |  |  | 33.51 |  |  | 33.64
13 |  |  |  | 37 |  |  | 36
14 |  | 36.35 |  |  | 36.85
15 |  |  |  | 34.6 |  | 29.41
16 |  | 29.66 |  |  | 35
17 |  |  |  | 32.09 |  | 31.39
18 |  | 30.48 |  |  | 32.03 |  | 31.11
19 |  |  |  | 33.85 |  |  | 30.1
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: MAINE-18

 | COUNTY | CODE
 | Androscoggin | 1
 | Aroostook | 3
 | Cumberland | 5
 | Franklin | 7
 | Hancock | 9
 | Kennebec | 11
 | Knox | 13
 | Lincoln | 15
 | Oxford | 17
 | [NAME] | 19
 | Piscataquis | 21
 | Sagadahoc | 23
 | Somerset | 25
 | [NAME] | 27
 | Washington | 29
 | York | 31
Spreadsheet: 869552d1716165038-i-need-help-with-vacation-time-example2-dutratp-
Sheet: New Test

Start | End | Period | First time Vacation |  | Second time Vacation
2024-01-01 00:00:00 |  | 12
2024-02-05 00:00:00 |  | 8
2024-06-03 00:00:00 |  | 18
Start | End | Period | First time Vacation 7th month |  | Second time Vacation 1m before the last
2024-01-01 00:00:00 | 2024-12-31 00:00:00 | 12 |  |  |  |  | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is november
2024-01-01 00:00:00 | 2024-09-30 00:00:00 | 9 |  |  |  | 2024-08-31 00:00:00 | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is august
2024-01-01 00:00:00 | 2024-07-30 00:00:00 | 7 |  |  |  |  | the 7th month is between 01-07-2024 until 30-07-2024 | The month before the last is july and it's the same 7th month (No second time vacation)
Spreadsheet: 275395d1383498768-removeing-duplicates-useing-current-sumproduct-formula-employee-count-by-time
Sheet: Sheet1

 | Owner Group | Owner | Time |  | Hours | Empoyee count
 | Service_desk | Employee 1 | 2013-01-02 01:56:14 |  | 1-2 AM | 2
 | uti_clinical | Employee 3 | 2013-01-02 07:31:44 |  | 2-3 Am | 1
 | ldu_apps | Employee 3 | 2013-01-01 00:36:12
 | Service_desk | Employee 1 | 2013-01-01 01:26:42
 | ldu_apps | Employee 3 | 2013-01-01 03:20:22
 | Uti_Clinical | Employee 3 | 2013-01-01 02:21:59
 | ldu_apps | Employee 3 | 2013-01-01 04:30:55
 | Service_desk | Employee 2 | 2013-01-01 01:04:04
 | Service_desk | Employee 1 | 2013-01-01 05:37:13
 | Service_desk | Employee 1 | 2013-01-01 02:30:48
Spreadsheet: 702157d1604128185-need-formula-to-merge-data-table-data-table-merge
Sheet: Sheet3

SIZE |  | AA | BB | DD | EE
COLOUR | QUALITY
1 | A | 10 | 11 | 9 | 8
2 | B | 8 | 15 | 6 | 7
3 | C | 7 | 50 | 5 | 22
5 | E | 5 | 30 | 3 | 44
6 | F | 4 | 35 | 2 | 36
7 | G | 3 | 40 | 1 | 11
Spreadsheet: robin_rodrigue__33364__IMPositions_070700
Sheet: BC GD

BC GAS DAILY POSITIONS
SUMMARY OF POSITIONS - CONTRACTS
 |  | AECOUS | ROCKIES | HEHUB | SUMAS | MALIN | AECO-C$ |  | TOTAL
February
March
April
TOTAL
SUMMARY OF POSITIONS - GJ'S
February |  | 0 | 0 | 0 |  |  | 0
March |  |  |  |  |  |  | 0
April
May
June
Spreadsheet: 726751d1617418030-predictive-modeling-of-unit-sales-by-day-of-week-dow-book3-1-
Sheet: Sheet1

Candy Bars |  |  |  | Was it helper column?
 |  |  |  | Delete it.
 | Orig Data
 |  | Flavor | location | Flavor, Location | mon | tue | wed | thu | fri | sat | [NAME] | mon | tue | wed |  | If [NAME], Last non-zero
 |  |  |  |  | 2021-01-01 00:00:00
 |  | Carmel | shelf |  | 1 | 2 | 4 | 2 | 5 | 2 | 4 | 2 | 5 | 4
 |  | Chocolate | shelf |  | 2 | 3 | 4 | 2 | 0 | 2 | 4 | 3 | 0 | 4
 |  | Vanilla | table |  | 3 | 5 | 6 | 2 | 8 | 0 | 0 | 0 | 0 | 0 |  | 9
 |  | Vanilla | shelf |  | 0 | 0 | 0 | 0 | 0 | 3 | 2 | 1 | 0 | 2 |  | 14
 |  | [NAME] | table |  | 2 | 3 | 4 | 2 | 0 | 2 | 4 | 3 | 0 | 4
 |  | Caramel | table |  | 2 | 5 | 6 | 4 | 2 | 4 | 6 | 5 | 2 | 6
 | Final Data
 |  | Flavor | location | Flavor, Location | Mon Ave | Tue Ave | Wed Ave | [NAME] | Fri Ave | Sat Ave | Sun Ave
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | predictive modeling of unit sales by Day of Week (DOW)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | We track unit sales of candy by flavor and location for each DOW. We have hundreds of different flavors and multiple locations. Each flavor resides in a single location.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | We rearrange our candy store frequently.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Since we are predicting unit sales, any data from a previous location has zero value.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The original data is downloaded by DOW.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The desired final data will only have 1 record for each flavor. The desired final data will only use current location unit sales of that flavor.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Due to the volume of flavors, the Original data and the Final data are on separate tabs within the ame workbook.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The original data shows that the [NAME] flavor was move from the table location to the shelf location on saturday.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | I need to calculate the Average Unit Sales of the Vanilla flavor candy for the final location for every DOW.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If this is possible, I would then need to eliminate any records with 0 unit sales. (I realize that some days may contain 0 sales. The impact of those 0 sales' days will be irrelevant in my actual data.)
Spreadsheet: 878680d1725927079-number-of-products-from-different-companies-excel0910
Sheet: Sheet1

Company | Product |  |  | Company | A1 | B1 | C1
X | A1 |  |  | X
X | B1 |  |  | A
X | B1 |  |  | B
A | C1
A | A1
B | C1
B | A1
B | B1
B | B1
Spreadsheet: 8852e34f-6240-4236-a70d-74c7dc4fa25d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LYZKM | Test | LYZKM | Lysozyme (LYZ) Gene, Known Mutation | [NAME], Known Mutation | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | VACUTAINER: VAC |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL Collection Instructions: 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms: 1. Molecular Genetics-Congenital Inherited Diseases Patient Information Sheet (Supply T521) in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Plasma or serum | An interpretive report will be provided. | Tuesday; 10 a.m. | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
LYZKM | [NAME] | VARIES | Varies |  |  |  | Ambient
LYZKM | Result | 33437 | [NAME] | [NAME] | Alphanumeric
LYZKM | Result | 33438 | [NAME] | [NAME] | Alphanumeric
LYZKM | Result | 33439 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
LYZKM | Result | 33440 | Order Date | Order Date | Alphanumeric
LYZKM | Result | 33441 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
LYZKM | Result | 33442 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
LYZKM | Result | 33443 | Result | Result | Alphanumeric
LYZKM | Result | 33444 | Interpretation | Interpretation | Alphanumeric
LYZKM | Result | 33445 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
LYZKM | Result | 33446 | Reviewed By | Reviewed By | Alphanumeric
LYZKM | Result | 33447 | Release Date | Release Date | Alphanumeric
Spreadsheet: 70535d1271258846-excel-2007-making-cells-follow-other-cells-monthly-gas-reports-2010-master-v6
Sheet: WE 1-10 

 |  |  |  |  |  |  | 2010-01-04 00:00:00
 | Truck # | Primary Driver | System | C.O.D. Date | [NAME] | System2 | Mon. | [NAME]. | Wed. | Thur. | Fri. | Sat. | Sun. | Total | Column15 | Column16 | Column17 | Column18 | Column19 | Column20
 |  | [NAME] | Scranton
 |  | [NAME] | Construction
 |  | [NAME] | Winchester
 |  | [NAME] | Ranson
 |  | [NAME] | Scranton
 |  | [NAME] | Harrisonburg
 |  | [NAME]
 |  | [NAME] | Scranton
 |  | [NAME] | Culpeper
 |  | [NAME]
 |  | [NAME] | Winchester
 |  | [NAME] | Charlottesville
 |  | [NAME] | Harrisonburg
 |  | [NAME] | no longer here
 |  | [NAME] | Winchester
 |  | [NAME]
 |  | [NAME] | Culpeper
 |  | [NAME]????? | Winchester
 |  | [NAME] | Scranton
 |  | [NAME] | Scranton
 |  | [NAME] | Staunton
 |  | [NAME] | Harrisonburg
 |  | [NAME] | Scranton
 |  | [NAME] | Parked
 |  | [NAME] | Winchester
 |  | [NAME] | Ranson
 |  | [NAME] | Staunton
 |  | [NAME] | Scranton
 |  | [NAME] | Winchester
 |  | [NAME] | no longer here
 |  | [NAME]
 |  | [NAME] | Scranton
 |  | [NAME] | no longer here
 |  | [NAME] | Scranton
 |  | [NAME] | Charlottesville
 |  | [NAME] | Winchester
 |  | [NAME] | Winchester
 |  | [NAME] | Charlottesville
 |  | [NAME] | Ranson
 |  | [NAME] | Staunton
 |  | [NAME] | Charlottesville
 |  | [NAME] | Scranton
 |  | [NAME] | Ranson
 |  | [NAME] | Staunton
 |  | [NAME] | Winchester
 |  | [NAME] | Winchester
 |  | [NAME] | Ranson
 |  | [NAME] | Winchester
 |  | [NAME] | Scranton
 |  | [NAME] | Harrisonburg
 |  | [NAME]
 |  | [NAME] | WInchester
 |  | [NAME] | Charlottesville
 |  | [NAME] | Staunton
 |  | [NAME]
 |  | [NAME]
 |  | [NAME] | Harrisonburg
 |  | [NAME] | Charlottesville
 |  | [NAME] | Staunton
 |  | [NAME] | Staunton
 |  | [NAME] | Winchester
 |  | [NAME] | Ranson
 |  | [NAME] | Winchester
 |  | [NAME] | Charlottesville
 |  | [NAME]
 |  | [NAME] | Ranson
 |  | [NAME] | Winchester
 |  | [NAME] | Charlottesville
Spreadsheet: 116684d1311996897-automatic-data-update-in-different-sheets-automatic-data-update-in-different-sheets
Sheet: Sheet3

 |  | Enter a Name ► | kathy
 |  | Total Records Found ► | 2
Row # | date | name | item | unit price | qty | due amount
6 | 2011-07-08 00:00:00 | Kathy | pen | 1 | 6 | 6
9 | 2011-07-11 00:00:00 | Kathy | pencil | 2 | 3 | 6
Spreadsheet: 125126d1318885749-maxif-using-ranges-n-a-error-example
Sheet: MASTER SUMMARY

DISTRICT 1 & 2 MASTER SUMMARY
All Work Orders
 | Type of Work Order | Total Number of Work Orders | Average Total Days Open | Max Days Open | Corresponding WO | Min Days Open
Grand Total | FY10, FY11 & FY12 Work Orders
FY12
FY12  Work Orders by Open and Closed
 | Type of Work Order | Total Number of Work Orders | Average Total Days Open | Max Days Open | Corresponding WO | Min Days Open
FY12 Total | Closed
FY12 Total | Open
District FY12 Work Orders
 | Type of Work Order | Total Number of Work Orders | Average Total Days Open | Max Days Open | Corresponding WO | Min Days Open
1 | Closed
 | Open
2 | Closed
 | Open
Spreadsheet: 225346d1364972128-really-complex-problem-remaining-value-check-help-example-fixed
Sheet: My way for calculating 4 values

 | Import1 | Import2 | Import3 | Import4 |  |  | Export1 | Izvoz2 | Izvoz3 |  | Norm1 | Norm2 | Norm3 |  |  | Normative
Quantity | 1000 | 1200 | 1300 | 1400 |  |  | 444 | 0 | 0 |  | 450.75768 | 0 | 0 |  |  | 1.01522
Value | 1300 | 1560 | 1690 | 1820 |  |  | 888 | 0 | 0 |  | 585.984984 | 0 | 0
 | Difference1 | Difference2 | Difference3 | [NAME]
Remaining | 549.2423200000001 | 0 | 0 | 0
value | 714.0150160000001 | 0 | 0 | 0
 |  |  |  |  |  | Criteria
 |  |  |  |  |  | <0 | 1 | 0 | 0
 |  |  |  |  |  | <Izvoz1 | 0 | 0 | 0
 |  |  |  |  |  | <iz1+iz2 | 0 | 0 | 0
 |  |  |  |  |  | <1+2+3 | 0 | 0 | 0
 |  |  |  |  |  | >1+2+3+4 | 0 | 0 | 0
 |  |  |  |  |  | Reaction
 |  |  |  |  |  | 1 | 549.2423200000001
 |  |  |  |  |  | 2 | 1749.24232
 |  |  |  |  |  | 3 | 3049.24232
 |  |  |  |  |  | 4 | 0 | 0 | 0
 |  |  |  |  |  | minimum
 |  |  |  |  |  | 549.2423200000001
Spreadsheet: 461398d1463570197-want-to-highlight-those-cell-which-addition-comes-specific-number-samplle
Sheet: Sheet1

654
4664
46584
1684
6841
9681
134896
100
65
I WANT TO HIGHLIGH THE CELL WHICH ADDTION COMES 11365
654
4664
46584
1684
6841
9681
134896
100
65
Spreadsheet: 804955d1668445313-count-distinct-values-across-a-number-of-columns-eg-values
Sheet: Sheet1

Id 1 | Id 2 | Id 3 | Id 4 | Id 5 | Id 6 | Id 7 |  | Count | Unique
61.68201569312182 | 76 | 56 |  | 67
51.68307623912015 |  |  |  | 65
96.49939286408629 |  |  | 65 | 96 | 62
76.15425630494144 |  |  |  | 92 | 85
92.40488212039213 | 54 |  |  | 4
56.81628452735229 | 34
42.23091877082279 | 23 |  | 8 | 65
88.1464435208498 |  |  |  | 43
84.69597469272826 |  |  |  | 2
68.69339325070986 | 6 |  |  |  | 59
24.16999313251594 | 18
63.96907318087285 | 54
84.60606790195119 | 66
98.6860366441238 | 21
59.40189308380274
43 |  | 45
21 |  | 78
45 |  | 55
67 |  | 43
87 |  | 21
98 |  | 77
90 |  | 8
876
456
436
7
65
368
Spreadsheet: 80799d1280988195-top-5-largest-results-from-list-book2
Sheet: Sheet1

amount | error |  | Rank | Amount |  | Error
1 | large |  | 1 | 111 | 1 | thin
5 | small |  | 2 | 87 | 2 | sad
9 | big |  | 3 | 87 | 2 | old
8 | short |  | 4 | 55 | 4 | young
12 | tall |  | 5 | 29 | 5 | tiny
111 | thin |  | 6 | 16 | 6 | fat
16 | fat
29 | tiny
9 | happy
87 | sad
87 | old
55 | young
Spreadsheet: 491565d1480531349-pivot-not-picking-up-data-ww
Sheet: Sheet1

Area Group | Volume per Area Group | Transfers All | %
BUSINESS BANKING | 6648 | 155925 | 0.04263588263588264
CELLPHONE BANKING | 6245 | 155925 | 0.04005130671797338
DIRECT SALES BALANCE TRANS | 5 | 155925 | 3.20666987333654e-05
DISCOVERY CARD EXISTING | 0 | 155925 | 0
DS FAST APP (CISS) | 65 | 155925 | 0.0004168670835337502
DS FULFILMENT SUPPORT | 12 | 155925 | 7.696007696007696e-05
DS VEHICLE FINANCE | 0 | 155925 | 0
FAST APP | 3 | 155925 | 1.924001924001924e-05
FNB CREDIT CARD | 40882 | 155925 | 0.2621901555234888
FNB DIRECT CARD – LIMITS AND UPGRADES | 100 | 155925 | 0.000641333974667308
FNB HOME LOANS | 8499 | 155925 | 0.0545069745069745
FNB INSURANCE SALES | 2 | 155925 | 1.282667949334616e-05
FNB LIFE RISK INBOUND | 1 | 155925 | 6.41333974667308e-06
FRAUD & CARD CANCELATIONS | 15197 | 155925 | 0.0974635241301908
GENESIS | 0 | 155925 | 0
ISLAMIC DIRECT | 1 | 155925 | 6.41333974667308e-06
JV [NAME] | 0 | 155925 | 0
KULULA CARD SALES | 1 | 155925 | 6.41333974667308e-06
LOC SALES | 0 | 155925 | 0
MVNO | 62 | 155925 | 0.0003976270642937309
NEW BUSINESS | 3 | 155925 | 1.924001924001924e-05
OD REFERRALS | 15 | 155925 | 9.62000962000962e-05
RETENTION PREMA | 25 | 155925 | 0.000160333493666827
SAVINGS AND INVESTMENTS | 2193 | 155925 | 0.01406445406445406
TELEPHONE BANKING | 64169 | 155925 | 0.4115375982042649
TEMPLOANS | 8469 | 155925 | 0.05431457431457432
WALLET SERVICES | 3328 | 155925 | 0.02134359467692801