tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 472755d1469733155-pivot-table-with-calculated-item-with-two-rows-label-pivot-problem
Sheet: Sheet1

Group | Sub Group | Year | Sales
Braking | Pads | 2015 | 10 |  |  |  |  | Pivot Table - Showing All subgroup |  |  |  |  |  | I want below in Pivot
Braking | Disc | 2015 | 23
Braking | Calliper | 2015 | 54 |  |  |  |  | Sum of Sales
Fliters | Air | 2015 | 60 |  |  |  |  | Group | Sub Group | Year | Total |  |  | Group | Sub Group | Year | Total
Fliters | Oil | 2015 | 432 |  |  |  |  | Braking | Air | Varrinance | 0 |  |  | Braking | Calliper | 2015 | 54
Fliters | Pollen | 2015 | 76 |  |  |  |  |  | Calliper | 2015 | 54 |  |  |  |  | 2016 | 45
Fliters | Fuel | 2015 | 30 |  |  |  |  |  |  | 2016 | 45 |  |  |  |  | Varrinance | -9
Braking | Pads | 2016 | 20 |  |  |  |  |  |  | Varrinance | -9 |  |  |  | Disc | 2015 | 23
Braking | Disc | 2016 | 32 |  |  |  |  |  | Disc | 2015 | 23 |  |  |  |  | 2016 | 32
Braking | Calliper | 2016 | 45 |  |  |  |  |  |  | 2016 | 32 |  |  |  |  | Varrinance | 9
Fliters | Air | 2016 | 76 |  |  |  |  |  |  | Varrinance | 9 |  |  |  | Pads | 2015 | 10
Fliters | Oil | 2016 | 120 |  |  |  |  |  | Fuel | Varrinance | 0 |  |  |  |  | 2016 | 20
Fliters | Pollen | 2016 | 34 |  |  |  |  |  | Oil | Varrinance | 0 |  |  |  |  | Varrinance | 10
Fliters | Fuel | 2016 | 56 |  |  |  |  |  | Pads | 2015 | 10 |  |  | Braking Total |  |  | 194
 |  |  |  |  |  |  |  |  |  | 2016 | 20 |  |  | Fliters | Air | 2015 | 60
 |  |  |  |  |  |  |  |  |  | Varrinance | 10 |  |  |  |  | 2016 | 76
 |  |  |  |  |  |  |  |  | Pollen | Varrinance | 0 |  |  |  |  | Varrinance | 16
 |  |  |  |  |  |  |  | Braking Total |  |  | 194 |  |  |  | Fuel | 2015 | 30
 |  |  |  |  |  |  |  | Fliters | Air | 2015 | 60 |  |  |  |  | 2016 | 56
 |  |  |  |  |  |  |  |  |  | 2016 | 76 |  |  |  |  | Varrinance | 26
 |  |  |  |  |  |  |  |  |  | Varrinance | 16 |  |  |  | Oil | 2015 | 432
 |  |  |  |  |  |  |  |  | Calliper | Varrinance | 0 |  |  |  |  | 2016 | 120
 |  |  |  |  |  |  |  |  | Disc | Varrinance | 0 |  |  |  |  | Varrinance | -312
 |  |  |  |  |  |  |  |  | Fuel | 2015 | 30 |  |  |  | Pollen | 2015 | 76
 |  |  |  |  |  |  |  |  |  | 2016 | 56 |  |  |  |  | 2016 | 34
 |  |  |  |  |  |  |  |  |  | Varrinance | 26 |  |  |  |  | Varrinance | -42
 |  |  |  |  |  |  |  |  | Oil | 2015 | 432 |  |  | Fliters Total |  |  | 572
 |  |  |  |  |  |  |  |  |  | 2016 | 120 |  |  | Grand Total |  |  | 766
 |  |  |  |  |  |  |  |  |  | Varrinance | -312
 |  |  |  |  |  |  |  |  | Pads | Varrinance | 0
 |  |  |  |  |  |  |  |  | Pollen | 2015 | 76
 |  |  |  |  |  |  |  |  |  | 2016 | 34
 |  |  |  |  |  |  |  |  |  | Varrinance | -42
 |  |  |  |  |  |  |  | Fliters Total |  |  | 572
 |  |  |  |  |  |  |  | Grand Total |  |  | 766
Spreadsheet: 823582d1680021124-sumif-formula-to-calculate-cells-in-between-sheets-based-on-cell-dropdown-r-and-ft-template
Sheet: Resources - 2024

 | RESOURCE TRACKER - YYYY
 | Date | Forecast Days (At Strategise/Shape) | Forecast Days (At Initiate) | Change Requests |  | TOTALS
 |  |  |  | Reference | Days
 | TOTALS
 | RESOURCES |  |  |  |  |  | MONTHLY ALLOCATION |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
 | Name | Business Area | [NAME] | Resource Requested Until | Resource Confirmed Until | Unit Amount | JAN |  | FEB |  | MAR |  | APR |  | MAY |  | JUN |  | JUL |  | AUG |  | SEP |  | OCT |  | NOV |  | DEC
 |  |  |  |  |  |  | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | FORECAST | ACTUALS | TOTAL FORECAST | TOTAL FORECAST  TO DATE | TOTAL ACTUALS | TOTAL ACTUALS COST | [NAME]
 |  |  | BA Team Managers | JUN | APR | 500 | 1 | 1.2 | 0.5 | 0.7 | 2 | 2.4 | 1.25 | 0.4 | 1 |  | 1 |  | 1
 |  |  | BI Life |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Automation test |  |  |  | 2 | 2.4 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | BillingCenter |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Project Manager |  |  |  | 1 | 1.2 | 2 | 2.4 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MI Tester |  |  |  | 1 | 1.3 | 1 | 1.3 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Technical Service Owner |  |  |  | 1 | 1.2 | 0.5 | 0.7 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | MDM |  |  |  | 1 | 1.3 | 1 | 1.3 | 0.5 | 0.7 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Print ISIS Papyrus |  |  |  | 0.5 | 0.7 | 1 | 1.2 | 1 | 1.2 | 1 |  | 1 |  | 1 |  | 1
 |  |  | Test WSL |  |  |  | 1 | 1.3 | 0.5 | 0.7 | 1 | 1.3 | 1 |  | 1 |  | 1 |  | 1
 | TOTALS DAYS
 | TOTALS IN £s
Spreadsheet: 796332d1663228139-summing-with-a-criterion-uniforms
Sheet: Sheet2

[NAME] |  |  |  | PURCHASED STOCK | TOTAL ISSUED
MAGNUM TROUSERS |  |  |  | 200 |  | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 40 | 42 | 44 | 46 | 48 | 50
COMBAT TROUSERS |  |  |  |  |  | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 40 | 42 | 44 | 46 | 48 | 50
LONG SLEEVE SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
SHORT SLEEVE SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
T-SHIRTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
JERSEY'S |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
PULL OVERS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
COMBAT BOOTS |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
RAIN JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
WARM JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
SHOES |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
SOCKS
WEB BELTS
LEATHER BELTS
BASEBALL CAPS
JUMPSUITS
STEP OUT TUNICS
KENNY JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
REFLECTIVE JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
BULLET PROOF VESTS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
LADIES SKIRTS
GUM BOOTS W/ZIP |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
PANTY [NAME]'S
OVERAL 2-PIECE'S
FORMAL JACKETS |  |  |  |  |  | [NAME] | XS | S | M | L | XL | 2XL | 3XL | 4XL | 5XL | 6XL | 7XL | 8XL
GREEN CROSS SHOES |  |  |  |  |  | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
LANYARDS
APPLETS
BEANIE'S
HAND GLOVES
RANKS
NAME TAGS
SHOULDER FLASHES
LADIES HANDBAG
SCARF
TIE'S
FACIAL MASKS
STUN GUN
TORCHES
PEPPER SPRAYS
BATONS
HOLSTERS
[NAME]
RIOT GEARS
LEG HOLSTERS
BADGES
L/E BUFF'S
ARM SLEEVES
Spreadsheet: 273339d1382685012-shortening-of-long-array-formula-by-short-formula-shortening-array-formula-of-vat
Sheet: Result

Date | Name of Party | Particulars | Vch No. | Reference No. | Taxable Purchase | Taxable Import | [NAME] | [NAME] in Custom | Excise Duty | Total | TDS
 |  |  |  |  |  |  |  |  |  |  | 371
Spreadsheet: mary_fischer__25632__31N
Sheet: E18YTD.XLS

ENRON CORP AND CONSOLIDTED SUBSIDIARIES
COMPANY # 031N
COMPANY NAME    EFS C&S
ANALYSIS OF RESERVE ITEMS
FOR THE YEAR ENDED 12-31-2001
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
 |  | 12-31-2000 Balance |  | ADDITIONS  DR (CR) |  |  |  | DEDUCTIONS  DR (CR)
 |  | DR. (CR) |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | RECORDED TO |  | DR. (CR)
[NAME] |  | BEGINNING BALANCE |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | INCOME STATEMENT |  | OTHER ACCOUNTS |  | ENDING BALANCE |  | COMMENTS/EXPLANATIONS
Allowance for Doubtful Accounts
(MUST TIE TO HYPERION LINE 0065)
Asset/Expense Accts:  DR/(CR)  Same signs as Hyperion
Reserve for Regulatory Issues - Current
(MUST TIE TO HYPERION LINE 0641)
Income Accts:  DR/(CR)  Reverse signs from Hyperion
Reserve for Regulatory Issues - Long Term
(MUST TIE TO HYPERION LINE 0815)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Other Reserves - Other
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
(MUST TIE TO HYPERION LINE 0840)
Income Accts: DR/(CR)  Reverse signs from Hyperion
Hyperion Line #   and Description of Other Reserves   (not listed above)
Total Other Reserves  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | E-18
Spreadsheet: 165944d1341403689-problem-creating-ohlc-chart-ohlc
Sheet: Sheet1

date | open | high | low | close
2012-01-01 00:00:00 | 1.582 | 1.592 | 1.499 | 1.501
2012-02-01 00:00:00 | 1.5821 | 1.5925 | 1.4993 | 1.5301
2012-03-01 00:00:00 | 1.5915 | 1.5962 | 1.5011 | 1.5434
Spreadsheet: 125580d1319112807-excel-2007-user-defined-search-and-calculate-example
Sheet: Sheet1

UNIT COMPLIANCE | record 1 | record 2 | record 3 | record 4 | record 5 | record 6 | record 7 | record 8 | record 9 | record 10
Item Code Present | Y | N | Y | Y | Y | Y | Y | Y | Y | N
Date present | Y | Y | Y | N | Y | N | Y | Y | Y | Y
Signature present | Y | N | Y | Y | Y | Y | Y | Y | Y | N
Time present | N | Y | N | N | Y | Y | Y | Y | N | Y
Staff Member responsible | JP | PT | PT | HG | JP | JP | WT | WT | WT | HG
Spreadsheet: 94823d1294587016-how-to-select-multiple-name-box-test
Sheet: FEB

 | 2009-02-01 00:00:00
 | Monthly Income |  |  |  |  | Expenses
 | Funds from Previous month: | 129.46 |  |  |  | Total Monthly Expense | 0
 | New Funds Added: | 0
 | Summary
 | Surplus This Month: | 129.46 | (Expense Limit)
Breakdown
 | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income |  |  | Item | Cost | Extra Income
1st |  |  |  |  | 6th |  |  |  |  | 11th |  |  |  |  | 16th |  |  |  |  | 21st |  |  |  |  | 26th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
2nd |  |  |  |  | 7th |  |  |  |  | 12th |  |  |  |  | 17th |  |  |  |  | 22nd |  |  |  |  | 27th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
3rd |  |  |  |  | 8th |  |  |  |  | 13th |  |  |  |  | 18th |  |  |  |  | 23rd |  |  |  |  | 28th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
4th |  |  |  |  | 9th |  |  |  |  | 14th |  |  |  |  | 19th |  |  |  |  | 24th |  |  |  |  | 29th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
5th |  |  |  |  | 10th |  |  |  |  | 15th |  |  |  |  | 20th |  |  |  |  | 25th
Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0 |  |  | Total: |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Month | Days
 |  |  |  |  |  |  |  |  |  |  |  | Jan | 31
 |  |  |  |  |  |  |  |  |  |  |  | Feb | 28
 |  |  |  |  |  |  |  |  |  |  |  | Mar | 31
 |  |  |  |  |  |  |  |  |  |  |  | Apr | 30
 |  |  |  |  |  |  |  |  |  |  |  | May | 31
 |  |  |  |  |  |  |  |  |  |  |  | Jun | 30
 |  |  |  |  |  |  |  |  |  |  |  | Jul | 30
 |  |  |  |  |  |  |  |  |  |  |  | Aug | 31
 |  |  |  |  |  |  |  |  |  |  |  | Sep | 30
 |  |  |  |  |  |  |  |  |  |  |  | Oct | 31
 |  |  |  |  |  |  |  |  |  |  |  | Nov | 30
 |  |  |  |  |  |  |  |  |  |  |  | Dec | 31
Spreadsheet: jeffrey_a_shankman__13994__DWR Rate Increase Summary
Sheet: Sheet1

 |  |  |  | Exhibit 14 DWR Rate Increase (cents/kWh)
 |  |  |  | Scenario
Rate Changes | 1 | 2 | 3 | 4 | 5 | 6
DWR AB 265 Customers | 2.64 | 1.63 | 2.49 | 2.64 | 1.97 | 2.64
DWR AB 43X Customers | 4.86 | 3.32 | 4.86 | 6.51 | 4.86 | 3.82
CTC AB 43X Rate Change | -0.66 | -0.66 | -0.66 | -0.66 | -0.66 | -0.66
Net AB 43X Increase
DWR System Rate Increase | 3.31 | 2.14 | 3.2 | 3.8 | 2.84 | 3
Net Average System Increase | 3.11 | 1.94 | 3 | 3.6 | 2.64 | 2.8
 |  |  |  | Exhibit 18 DWR Rate Increase (cents/kWh)
 |  |  |  | Scenario
Rate Changes | 1 | 2 | 3 | 4 | 5
DWR AB 265 Customers | 3.8 | 2.35 | 3.58 | 3.8 | 2.84
DWR AB 43X Customers | 2.84 | 1.94 | 2.84 | 3.8 | 2.84
CTC AB 43X Rate Change | 0 | 0 | 0 | 0 | 0
Net AB 43X Increase
DWR System Rate Increase | 3.51 | 2.22 | 3.36 | 3.8 | 2.84
Net Average System Increase | 3.51 | 2.22 | 3.36 | 3.8 | 2.84
Scenario 1: Rates from 10/01/01 to 12/31/02, retroactive rate increase to 03/27/01 for AB 43X customers
Scenario 2: Rates from 10/01/01 to 09/30/03, retroactive rate increase to 03/27/01 for AB 43X customers
Scenario 3: Rates from 09/01/01 to 12/31/02, retroactive rate increase to 03/27/01 for AB 43X customers
Scenario 4: Rates from 10/01/01 to 12/31/02 with no retroactive rate increase to AB 43X customers
Scenario 5: Rates from 03/27/01 to 12/31/02 with retroactive rate increase for all customers
Scenario 6: Rates from 10/01/01 to 12/31/02 target system avg. increase to 3.00 c/kWh, $94 million reduction in DWR revenue requirements applied to AB 43X customers.
Spreadsheet: 828735d1683717928-vlookup-and-match-motus-new-contracts-and-apps-v2
Sheet: Sheet1

 |  | AMAROK
VWFS Dealer Code | OEM Dealer Code | Dealer Desription | Dealer Group | Total Apps | Approved Apps | % Approved | Total Contracts | Conversion Rate | Conversion on Approved | Production Value | Easy Finance Contracts | Easy Finance Penetration | 90 Days Deferred Payment
8132 | 5819 | LINDSAY SAKER WELKOM | Motus
500819 | 5819 | LINDSAY SAKER WELKOM | Motus
11804 | 5148 | LINDSAY SAKER BLOEMFONTEIN | Motus
14681 | 5147 | LINDSAY SAKER SELECT VOLKSWAGEN | Motus
500147 | 5147 | LINDSAY SAKER BLOEMFONTEIN | Motus
3598 | 1411 | [NAME] | Motus
3858 | 1444 | [NAME] | Motus
3860 | 1151 | LINDSAY SAKER EAST RAND MALL | Motus
3862 | 1296 | [NAME] | Motus
4452 | 1443 | [NAME] | Motus
8659 | 1310 | [NAME] FOURWAYS | Motus
11782 | #N/A | [NAME] COMMERCIAL | Motus
13389 | 1741 | [NAME] | Motus
100107 | 1107 | LINDSAY SAKER ALBERTON | Motus
100781 | 1740 | LINDSAY SAKER VEREENIGING | Motus
Spreadsheet: 815257d1674835324-finding-percentage-change-in-trendline-joliet_unemployment_rates
Sheet: Unemployment-Joliet

2022-11-01 00:00:00 | 1 | 4.9
2022-10-01 00:00:00 | 2 | 4.7
2022-09-01 00:00:00 | 3 | 4.7
2022-08-01 00:00:00 | 4 | 5.3
2022-07-01 00:00:00 | 5 | 5.2
2022-06-01 00:00:00 | 6 | 5.3
2022-05-01 00:00:00 | 7 | 4.5
2022-04-01 00:00:00 | 8 | 4.7
2022-03-01 00:00:00 | 9 | 5.7
2022-02-01 00:00:00 | 10 | 6.2
2022-01-01 00:00:00 | 11 | 6.5
2021-12-01 00:00:00 | 12 | 5.2
2021-11-01 00:00:00 | 13 | 5
2021-10-01 00:00:00 | 14 | 5.7
2021-09-01 00:00:00 | 15 | 5.8
2021-08-01 00:00:00 | 16 | 7
2021-07-01 00:00:00 | 17 | 7.7
2021-06-01 00:00:00 | 18 | 8.9
2021-05-01 00:00:00 | 19 | 7.3
2021-04-01 00:00:00 | 20 | 7.8
2021-03-01 00:00:00 | 21 | 8.4
2021-02-01 00:00:00 | 22 | 9.1
2021-01-01 00:00:00 | 23 | 9.2
2020-12-01 00:00:00 | 24 | 8.5
2020-11-01 00:00:00 | 25 | 8.2
2020-10-01 00:00:00 | 26 | 8.3
2020-09-01 00:00:00 | 27 | 9.8
2020-08-01 00:00:00 | 28 | 10.7
2020-07-01 00:00:00 | 29 | 12.7
2020-06-01 00:00:00 | 30 | 14.2
2020-05-01 00:00:00 | 31 | 16.1
2020-04-01 00:00:00 | 32 | 20.5
2020-03-01 00:00:00 | 33 | 8.8
2020-02-01 00:00:00 | 34 | 6.1
2020-01-01 00:00:00 | 35 | 5.8
2019-12-01 00:00:00 | 36 | 4.3
2019-11-01 00:00:00 | 37 | 3.6
2019-10-01 00:00:00 | 38 | 3.7
2019-09-01 00:00:00 | 39 | 3.7
2019-08-01 00:00:00 | 40 | 4.3
2019-07-01 00:00:00 | 41 | 4.9
2019-06-01 00:00:00 | 42 | 5.2
2019-05-01 00:00:00 | 43 | 4.3
2019-04-01 00:00:00 | 44 | 4.9
2019-03-01 00:00:00 | 45 | 5.7
2019-02-01 00:00:00 | 46 | 6.4
2019-01-01 00:00:00 | 47 | 6.8
2018-12-01 00:00:00 | 48 | 5
2018-11-01 00:00:00 | 49 | 3.8
2018-10-01 00:00:00 | 50 | 4.1
2018-09-01 00:00:00 | 51 | 4
2018-08-01 00:00:00 | 52 | 4.6
2018-07-01 00:00:00 | 53 | 5.2
2018-06-01 00:00:00 | 54 | 5.6
2018-05-01 00:00:00 | 55 | 4.4
2018-04-01 00:00:00 | 56 | 4.7
2018-03-01 00:00:00 | 57 | 5.8
2018-02-01 00:00:00 | 58 | 6.9
2018-01-01 00:00:00 | 59 | 7.1
2017-12-01 00:00:00 | 60 | 5.8
2017-11-01 00:00:00 |  | 5.2
2017-10-01 00:00:00 |  | 5.2
2017-09-01 00:00:00 |  | 5.3
2017-08-01 00:00:00 |  | 6.2
2017-07-01 00:00:00 |  | 6.4
2017-06-01 00:00:00 |  | 6.8
2017-05-01 00:00:00 |  | 5.6
2017-04-01 00:00:00 |  | 5.8
2017-03-01 00:00:00 |  | 6.4
2017-02-01 00:00:00 |  | 7.1
2017-01-01 00:00:00 |  | 7.7
2016-12-01 00:00:00 |  | 6.7
2016-11-01 00:00:00 |  | 6
2016-10-01 00:00:00 |  | 6.4
2016-09-01 00:00:00 |  | 6.4
2016-08-01 00:00:00 |  | 6.9
2016-07-01 00:00:00 |  | 7.3
2016-06-01 00:00:00 |  | 7.9
2016-05-01 00:00:00 |  | 6.8
2016-04-01 00:00:00 |  | 7.8
2016-03-01 00:00:00 |  | 8.4
2016-02-01 00:00:00 |  | 8.7
2016-01-01 00:00:00 |  | 9
2015-12-01 00:00:00 |  | 7.5
2015-11-01 00:00:00 |  | 6.6
2015-10-01 00:00:00 |  | 6.4
2015-09-01 00:00:00 |  | 6.2
2015-08-01 00:00:00 |  | 6.7
2015-07-01 00:00:00 |  | 7.6
2015-06-01 00:00:00 |  | 8.1
2015-05-01 00:00:00 |  | 7.5
2015-04-01 00:00:00 |  | 7.6
2015-03-01 00:00:00 |  | 8.4
2015-02-01 00:00:00 |  | 9
2015-01-01 00:00:00 |  | 9.6
2014-12-01 00:00:00 |  | 7.7
2014-11-01 00:00:00 |  | 7.4
2014-10-01 00:00:00 |  | 7.5
2014-09-01 00:00:00 |  | 7.6
2014-08-01 00:00:00 |  | 8.5
Spreadsheet: 173699d1344674905-combining-sumproduct-with-checked-checkboxes-for-my-friend
Sheet: Sheet1

2012-08-01 00:00:00 |  | True
2012-08-02 00:00:00 |  | False
2012-08-03 00:00:00 |  | True
2012-08-04 00:00:00 |  | True
2012-08-05 00:00:00 |  | False
2012-08-06 00:00:00 |  | True
2012-08-07 00:00:00 |  | False |  |  |  |  |  | =sumproduct( --(d9:d25>datevalue("3/1/08")), --(d9:d25<datevalue("6/30/08")) )
2012-08-08 00:00:00 |  | False
2012-08-09 00:00:00 |  | True
2012-08-10 00:00:00 |  | True
2012-08-11 00:00:00 |  | False
2012-08-12 00:00:00 |  | False
2012-08-13 00:00:00 |  | True
2012-08-14 00:00:00 |  | True
2012-08-07 00:00:00 |  | True
2012-08-16 00:00:00 |  | True
2012-08-17 00:00:00 |  | True
2012-08-18 00:00:00 |  | False
2012-08-19 00:00:00 |  | False
2012-08-20 00:00:00 |  | True
2012-08-21 00:00:00 |  | True
2012-08-22 00:00:00 |  | False
2012-08-23 00:00:00 |  | True
2012-08-24 00:00:00 |  | True
2012-08-25 00:00:00 |  | False
2012-08-26 00:00:00 |  | True
2012-08-27 00:00:00 |  | False
2012-08-28 00:00:00 |  | False
2012-08-29 00:00:00 |  | False
2012-08-30 00:00:00 |  | False
2012-08-31 00:00:00 |  | True
Spreadsheet: 886721d1736839672-conditional-operation-between-cells-of-2-columns-of-different-dimensions-guembou-book1-400-2021-or-2016-aligw
Sheet: Sheet1

A1 | A2 |  | A1 | A2 |  | A1 | A2 |  | Delta |  | 2021+ |  | 2016
4.5 | 1 |  |  | 1 |  | 4.5 | 1
8.5 | 2 |  |  | 2 |  | 4.5 | 2 |  |  |  | 2.5
12.5 | 3 |  |  | 3 |  | 4.5 | 3 |  |  |  | 1.5
16.5 | 4 |  |  | 4 |  | 4.5 | 4 |  |  |  | 0.5
20.5 | 5 |  | 4.5 |  |  | 8.5 | 5 |  |  |  | 3.5
24.5 | 6 |  |  | 5 |  | 8.5 | 6 |  |  |  | 2.5
28.5 | 7 |  |  | 6 |  | 8.5 | 7 |  |  |  | 1.5
 | 8 |  |  | 7 |  | 8.5 | 8 |  |  |  | 0.5
 | 9 |  |  | 8 |  | 12.5 | 9 |  |  |  | 3.5
 | 10 |  | 8.5 |  |  | 12.5 | 10 |  |  |  | 2.5
 | 11 |  |  | 9 |  | 12.5 | 11 |  |  |  | 1.5
 | 12 |  |  | 10 |  | 12.5 | 12 |  |  |  | 0.5
 | 13 |  |  | 11 |  | 16.5 | 13 |  |  |  | 3.5
 | 14 |  |  | 12 |  | 16.5 | 14 |  |  |  | 2.5
 | 15 |  | 12.5 |  |  | 16.5 | 15 |  |  |  | 1.5
 | 16 |  |  | 13 |  | 16.5 | 16 |  |  |  | 0.5
 | 17 |  |  | 14 |  | 20.5 | 17 |  |  |  | 3.5
 | 18 |  |  | 15 |  | 20.5 | 18 |  |  |  | 2.5
 | 19 |  |  | 16 |  | 20.5 | 19 |  |  |  | 1.5
 | 20 |  | 16.5 |  |  | 20.5 | 20 |  |  |  | 0.5
 | 21 |  |  | 17 |  | 24.5 | 21 |  |  |  | 3.5
 | 22 |  |  | 18 |  | 24.5 | 22 |  |  |  | 2.5
 | 23 |  |  | 19 |  | 24.5 | 23 |  |  |  | 1.5
 | 24 |  |  | 20 |  | 24.5 | 24 |  |  |  | 0.5
 | 25 |  | 20.5 |  |  | 28.5 | 25 |  |  |  | 3.5
 |  |  |  | 21
 |  |  |  | 22
 |  |  |  | 23
 |  |  |  | 24
 |  |  | 24.5
 |  |  |  | 25
 |  |  | 28.5
Spreadsheet: 328750d1404054261-condtional-formatting-with-symbol-conditionalformatting
Sheet: Sheet1

 | Limit |  | Point 1 | Point 2 | Point 3 | Point 4 | Point 5 | Point 6 | Point 7 | Point 8 | Point 9 | Point 10 | Point 11
 | <=5 |  | <1,0 | 5 | 5.1 | 4.9 | <2,0 | 5.4 | 4.1 | 7.9 | >10
 |  |  | Point 1 and Point 5 should be black.
Spreadsheet: 186803d1350230408-list-of-records-related-to-condition-book1_-faizee
Sheet: Sheet1

S# | CARD NO | NAME | DATE | [NAME] | AMOUNT
1 | 4 | [NAME] | 2012-01-01 00:00:00 | Advance | 7000
2 | 1 | Aslam | 2012-01-02 00:00:00 | Loan | 3500
3 | 2 | [NAME] | 2012-02-04 00:00:00 | Advance | 7000
4 | 3 | Micheal | 2012-02-10 00:00:00 | loan returned | 2000
5 | 4 | [NAME] | 2011-03-05 00:00:00 | Loan | 1000
6 | 1 | Aslam | 2011-04-09 00:00:00 | Advance | 6000
7 | 2 | [NAME] | 2012-04-09 00:00:00 | Loan given | 7300
8 | 3 | Micheal | 2012-02-04 00:00:00 | loan returned | 9000
9 | 1 | Aslam | 2012-02-10 00:00:00 | Loan | 7000
10 | 2 | [NAME] | 2011-03-05 00:00:00 | loan returned | 2000
11 | 3 | Micheal | 2011-04-09 00:00:00 | loan given | 3000
I want the list of only data related to specific card no.
suppose
 | Card No. | 4 | [NAME]
S# | Date | Decription | Amount
1 | 2012-01-01 00:00:00 | Advance | 7000
2 | 2011-03-05 00:00:00 | Loan | 1000
Spreadsheet: 740701d1626463776-wanting-the-unit-type-of-the-set-of-data-to-be-copied-next-to-all-of-the-quantities-example3-edit-2-
Sheet: Sheet1

Project No | Year | Item No | Item No | Item Description | Item Description/Job | Date | Unit/Quantity |  | Bid
=============== | 2015 | 203-01597 |  |  | Potholing |  | Hour |  | ==============
STA 340A-017 | 2015 |  |  |  | Job 1 | 05/21/15 | 50 |  | 200
ER R400-325 | 2015 |  |  |  | Job 2 | 05/28/15 | 40 |  | 225
NHPP 076A-008 | 2015 |  |  |  | Job 3 | 05/28/15 | 100 |  | 185
FSA0703-413 | 2015 |  |  |  | Job 4 | 05/28/15 | 10 |  | 175
FSA145A-057 | 2015 |  |  |  | Job 5 | 05/28/15 | 40 |  | 350
NH0341-081 | 2015 |  |  |  | Job 6 | 06/04/15 | 80 |  | 200
FSA 0703-411 | 2015 |  |  |  | Job 7 | 06/11/15 | 40 |  | 250
SHE165A-012 | 2015 |  |  |  | Job 8 | 06/11/15 | 6 |  | 200
ITSSW01-536 | 2015 |  |  |  | Job 9 | 06/18/15 | 200 |  | 150
SHE151A-008 | 2015 |  |  |  | Job 10 | 06/25/15 | 40 |  | 390
SHE172A-018 | 2015 |  |  |  | Job 11 | 06/25/15 | 20 |  | 250
=============== | 2015 | 202-00001 |  |  | Rem Structure |  | Each |  | ==============
CR600-409 | 2015 |  |  |  | Job 1 | 04/30/15 | 6 |  | 500
IM0762-049 | 2015 |  |  |  | Job 2 | 05/07/15 | 169 |  | 350
SHE172A-018 | 2015 |  |  |  | Job 3 | 06/25/15 | 1 |  | 1000
Spreadsheet: 107929d1305060285-search-a-list-for-name-put-amount-beside-it-vlookup-example
Sheet: Sheet1

 |  | Dollar
Acct # | Names | Amount
List A
1001 | Cash
1201 | Investment - Common Shares
1202 | Investment - Mutual Funds
1203 | Investment - Common Share - Foreign
1501 | Investment in ABC Ltd.
2400 | Due to shareholder
3000 | Corporate tax payable
3400 | Share Capital
3450 | Refundable dividend taxes
3500 | [NAME]
4001 | Dividend Income
4002 | Interest Income
4003 | Dividend income - US
6001 | Gain on sale of shares
6100 | Withholding taxes - Dividends US
8000 | Corporate tax expense
List B
 | Cash | 21100.65
 | Bank acct 645BMO 33 | 7564
 | Investment - Common Shares | -27671.49
 | Investment - Common Shares 33 | 446
 | Investment - Mutual Funds | -4882.09
 | Investment - property 224 St. | 44999
 | Investment - Common Share - Foreign | -5733.89
 | Investment in ABC Ltd. | 4465
 | Due to shareholder | 10000
 | Due to shareholder -other | 18974.64
 | Corporate tax payable | -64
 | Share Capital | -22
 | Refundable dividend taxes | 344
 | [NAME] | -44054
 | Dividend Income | -195.15
 | Interest Income | -22.7
 | Legal fees | 3345
 | Bank charges & interest | 66
 | Office expense | 7954
 | Dividend income - US | -987
 | Gain on sale of shares | -2042.97
 | Gain on property | 2246
 | Gain on property US | 323
 | Withholding taxes - Dividends US | 75
 | Corporate tax expense | 193
Spreadsheet: 219980d1363026365-minute-and-second-formula-issues-question-234-sample-worksheet
Sheet: Sheet1

time in min | multiplied by | total time
 |  |  |  | general # to show the sum doesn't add correctly
00:05:00 | 1 | 00:05:00 |  | 5
00:01:45 | 200 | 05:50:00 |  | 50
00:02:00 | 1 | 00:02:00 |  | 2
00:01:00 | 5 | 00:05:00 |  | 5
00:02:00 | 1 | 00:02:00 |  | 2
00:01:30 | 10 | 00:15:00 |  | 15
00:08:00 | 1 | 00:08:00 |  | 8
 |  | 06:27:00 | grand total time | 87 | grand total time should be 87hrs or 1:27:00
 | Total Time (SUMPRODUCT):
5 | 1
1.75 | 200
2 | 1
1 | 5
2 | 1
1.5 | 10
8 | 1