tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110423d1307089401-issue-with-graph-778485
Sheet: Sheet1

 | Single Branch | Total Sale | Avg. Sale
 | Edmonton | 52586.960000017 | 17528.98666667233
 | Branch | Total Sale | Avg. Sale
 | Dallas | 72285.54000000401 | 24095.18000000134 | #N/A | #N/A
 | Vancouver | 58409.000000002 | 29204.500000001 | #N/A | #N/A
 | Edmonton | 52586.960000017 | 17528.98666667233 | 52586.960000017 | 17528.98666667233 | Edmonton
 | Calgary | 47858.000000022 | 15952.666666674 | #N/A | #N/A
 | Houston | 41944.590000007 | 13981.53000000233 | #N/A | #N/A
 | San Antonio | 39924.970000014 | 19962.485000007 | #N/A | #N/A
 | Pittsburgh | 24655.500000033 | 12327.7500000165 | #N/A | #N/A
 | Miami | 24460.760000025 | 12230.3800000125 | #N/A | #N/A
 | Memphis | 22839.400000027 | 11419.7000000135 | #N/A | #N/A
 | San Francisco | 22270.500000018 | 11135.250000009 | #N/A | #N/A
 | Louisville | 22244.130000011 | 11122.0650000055 | #N/A | #N/A
 | [NAME] | 22027.870000009 | 11013.9350000045 | #N/A | #N/A
 | Oklahoma City | 21329.500000032 | 10664.750000016 | #N/A | #N/A
 | Washington DC | 20704.000000008 | 20704.000000008 | #N/A | #N/A
 | Shreveport | 20665.390000015 | 20665.390000015 | #N/A | #N/A
 | Albuquerque | 19524.560000029 | 19524.560000029 | #N/A | #N/A
 | Montreal | 17928.250000024 | 17928.250000024 | #N/A | #N/A
 | New Orleans | 16711.65000001 | 16711.65000001 | #N/A | #N/A
 | [NAME] | 15569.000000003 | 15569.000000003 | #N/A | #N/A
 | Quebec City | 15320.95000003 | 15320.95000003 | #N/A | #N/A
 | Orlando | 14972.000000016 | 14972.000000016 | #N/A | #N/A
 | Charleston | 13173.800000032 | 13173.800000032 | #N/A | #N/A
 | Tampa | 13137.91000002 | 13137.91000002 | #N/A | #N/A
 | Wichita | 12485.110000023 | 12485.110000023 | #N/A | #N/A
 | Concord | 12298.960000021 | 12298.960000021 | #N/A | #N/A
 | Portland | 12025.660000006 | 12025.660000006 | #N/A | #N/A
 | Toronto | 11887.500000019 | 11887.500000019 | #N/A | #N/A
 | Los Angeles | 11759.000000012 | 11759.000000012 | #N/A | #N/A
 | New York | 11507.000000026 | 11507.000000026 | #N/A | #N/A
 | [NAME] | 10583.000000033 | 10583.000000033 | #N/A | #N/A
 | [NAME] | 10039.400000001 | 10039.400000001 | #N/A | #N/A
 | Atlanta | 9796.500000031 | 9796.500000031 | #N/A | #N/A
 | Saskatoon | 9446.050000013 | 9446.050000013 | #N/A | #N/A
 | Atlanta | 9796.500000031 | 9796.500000031 | #N/A | #N/A
 | Saskatoon | 9446.050000013 | 9446.050000013 | #N/A | #N/A
Spreadsheet: 02a4790a-429d-4565-b2f9-0e783e116a82
Sheet: Sheet1

Table 6--Cottonseed oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning |  |  |  |  |  |  |  | Ending
October 1 | stocks | Production | Imports | Total |  | Domestic | Exports | Total | stocks
 | Million pounds
2011/12 | 165 | 755 | 10.34710675614 | 930.34710675614 |  | 571.6191067561399 | 258.728 | 830.34710675614 | 100
2012/131 | 100 | 800 | 20 | 920 |  | 590 | 230 | 820 | 100
2013/142 | 100 | 695 | 0 | 795 |  | 485 | 210 | 695 | 100
1 Estimated.  2 Forecast.
Source:  USDA, Foreign Agricultural Service, PS&D Online.
Last update: | 2013-09-16 10:13:18.940000
Spreadsheet: 700846d1603370928-excel-formula-for-time-difference-sample
Sheet: Sheet1

Date | Time (Start) | Time (End) | Duration (H:M)
2015-10-22 00:00:00 | 2015-10-22 13:30:00 | 10/22/2015  19:30:00 PM
2015-10-24 00:00:00 | 2015-10-24 10:10:00 | 10/24/2015  16:10:00 AM
2015-11-07 00:00:00 | 2015-11-07 19:50:00 | 2015-11-08 19:50:00
2015-11-24 00:00:00 | 11/24/2015  17:00:00 PM | 2015-11-24 00:00:00
2015-12-03 00:00:00 | 12/3/2015  15:30:00 PM | 2015-12-03 00:00:00
2015-12-22 00:00:00 | 2015-12-22 00:00:00 | 2015-12-22 00:00:00
Spreadsheet: 89821-changing-average-example
Sheet: Sheet5

Average of Value
Day | Total
1.1.2010 - 7.1.2010 | 9.559999999999999
8.1.2010 - 14.1.2010 | 8.842857142857143
15.1.2010 - 21.1.2010 | 9.485714285714286
22.1.2010 - 28.1.2010 | 9.62857142857143
29.1.2010 - 4.2.2010 | 9.142857142857142
5.2.2010 - 11.2.2010 | 9.057142857142855
12.2.2010 - 18.2.2010 | 11.75714285714286
19.2.2010 - 25.2.2010 | 12.58571428571429
26.2.2010 - 4.3.2010 | 16.88571428571429
5.3.2010 - 11.3.2010 | 15.42857142857143
12.3.2010 - 18.3.2010 | 19.75714285714286
19.3.2010 - 25.3.2010 | 11.84285714285714
[NAME] | 12.01428571428571
2.4.2010 - 8.4.2010 | 18.57142857142857
9.4.2010 - 15.4.2010 | 23.15714285714285
16.4.2010 - 22.4.2010 | 23.01428571428572
23.4.2010 - 29.4.2010 | 25.75714285714286
30.4.2010 - 6.5.2010 | 20.64285714285714
7.5.2010 - 13.5.2010 | 28.64285714285714
14.5.2010 - 20.5.2010 | 25.88571428571429
21.5.2010 - 27.5.2010 | 30.65714285714285
28.5.2010 - 3.6.2010 | 23.05714285714285
4.6.2010 - 10.6.2010 | 25.68571428571429
11.6.2010 - 17.6.2010 | 29.15714285714285
[NAME] | 31.78333333333333
25.6.2010 - 1.7.2010 | 29.4
2.7.2010 - 8.7.2010 | 31.34285714285715
9.7.2010 - 15.7.2010 | 31.02857142857143
16.7.2010 - 22.7.2010 | 37.32857142857143
23.7.2010 - 29.7.2010 | 34.34285714285714
30.7.2010 - 5.8.2010 | 29.74285714285714
6.8.2010 - 12.8.2010 | 28.62
13.8.2010 - 19.8.2010 | 32.97142857142857
20.8.2010 - 26.8.2010 | 26.62857142857143
27.8.2010 - 2.9.2010 | 30.02857142857143
3.9.2010 - 9.9.2010 | 26.08571428571429
10.9.2010 - 16.9.2010 | 27.85714285714286
17.9.2010 - 23.9.2010 | 25.47142857142857
24.9.2010 - 30.9.2010 | 22.15714285714285
[NAME] | 25.02857142857143
8.10.2010 - 14.10.2010 | 20.92857142857143
15.10.2010 - 21.10.2010 | 17.42857142857143
22.10.2010 - 28.10.2010 | 13.42857142857143
29.10.2010 - 4.11.2010 | 15.21428571428571
5.11.2010 - 11.11.2010 | 15.67142857142857
12.11.2010 - 18.11.2010 | 9.571428571428571
19.11.2010 - 25.11.2010 | 9.357142857142858
26.11.2010 - 2.12.2010 | 10.21428571428571
[NAME] | 10.87142857142857
10.12.2010 - 16.12.2010 | 6.971428571428572
17.12.2010 - 23.12.2010 | 5.328571428571428
24.12.2010 - 30.12.2010 | 5.7
31.12.2010 - 1.1.2011 | 7.3
Grand Total | 19.92980501392759
Spreadsheet: 258410dc-f7dd-4301-ab6d-68d63e96901b
Sheet: Minors

 | Fresh. | Soph. | Juniors | Seniors | Sem. Total | SPED | PROF ED | ED | RDG | Coach ED | Trad. <24 yrs. | Non-Trad >24 yrs.
Fall 2010 | 14 | 38 | 32 | 40 | 124 | 14 | 98 | 0 | 0 | 12 | 105 | 19
Spring 2011 | 16 | 41 | 36 | 40 | 133 | 16 | 109 | 0 | 0 | 8 | 111 | 22
Fall 2011 | 9 | 38 | 35 | 43 | 125 | 15 | 105 | 0 | 0 | 5 | 104 | 21
Spring 2012 | 6 | 28 | 32 | 52 | 118 | 17 | 98 | 0 | 0 | 3 | 102 | 16
Fall 2012 | 17 | 36 | 35 | 58 | 146 | 12 | 130 | 2 | 0 | 2 | 130 | 16
Spring 2013 | 16 | 35 | 34 | 51 | 136 | 12 | 123 | 0 | 0 | 1 | 118 | 24
Fall 2013 | 16 | 30 | 34 | 45 | 125 | 8 | 111 | 6 | - | - | 110 | 15
Spreadsheet: larry_may__21617__OStrip2
Sheet: OStrip1

 | Strip of Daily Fixed Price or Forward Start Options
 | Function:OSTRIP2
 | EffDt | 1997-12-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ostrip2 model
 |  |  |  |  |  |  |  |  |  |  |  |  |  | OUTPUTS
 | INPUTS |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | Fwd Price | Strike | Fwd.Start | BeginDt | [NAME] | FwdSt.Flag | Ann.IntRt | Vol_prior | Vol_after | % of Index | Basis Offset | Call=1/Put=0 |  | Price | Delta | Gamma | Vega | Rho | Theta | FixDelta | [NAME] | [NAME] | Charm | Basis Offset
 | 2.354 | 2.354 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00 | 1 | 0.06 | 0.61 | 0.85 | 1 | 0.11 | 0
 | 2.354 | 3 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00 | 1 | 0.06 | 0.61 | 0.85 | 1 | 0 | 0
 | 2.354 | 2 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00 | 0 | 0.06 | 0.61 | 0.85 | 1 | 0 | 0
 | 2.354 | 2.5 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00 | 0 | 0.06 | 0.61 | 0.85 | 1 | 0 | 0
 | 2.354 | 3 | 1998-01-01 00:00:00 |  | 1998-01-31 00:00:00 | 0 | 0.06 | 0.61 | 0.85 | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Price | Delta | Gamma | Vega | Rho | Theta | FixDelta | [NAME] | [NAME] | Charm |  | Charm Check
 |  | EffDt |  |  |  |  | Fwd.Start |  | BeginDt |  |  | [NAME]
 |  |  |  |  |  |  | Strike is set |  | Strip Starts |  |  | Strip Ends
Spreadsheet: 163498d1340328814-isolate-rows-based-on-first-column-840149-isolate_rows_based_on_first_column
Sheet: Details

Column #
Index # | ID Number | Data 1 | Data 4 | Data 7 | Data 8 | Data 9 | Data 10
Spreadsheet: 08e67304-4beb-41ab-8e37-090c4886c9b8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2013-12-30 09:20:57.350000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5 | 102.625 | 102.5 | 102.375 | 102 |  | and are added to price quote
4.875 | 102.115 | 101.99 | 101.865 | 101.49
4.75 | 101.589 | 101.464 | 101.339 | 100.964 |  | Note: | Refer To Price [NAME]
4.625 | 100.8 | 100.675 | 100.55 | 100.175 |  |  | For all Price Adjs
4.5 | 99.809 | 99.684 | 99.559 | 98.934
4.375 | 98.771 | 98.646 | 98.521 | 97.896
4.25 | 98.176 | 98.051 | 97.926 | 97.301
4.125 | 97.306 | 97.181 | 97.056 | 96.431
4 | 96.23 | 96.105 | 95.98 | 95.355 |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4 | 102.501 | 102.376 | 102.251 | 101.876
3.875 | 101.764 | 101.639 | 101.514 | 101.139
3.75 | 100.988 | 100.863 | 100.738 | 100.363
3.625 | 100.594 | 100.469 | 100.344 | 99.969
3.5 | 100.017 | 99.892 | 99.767 | 99.142
3.375 | 99.251 | 99.126 | 99.001 | 98.376
3.25 | 98.447 | 98.322 | 98.197 | 97.572 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-01-13 09:20:57.350000
30 DAY | 2014-01-28 09:20:57.350000
45 DAY | 2014-02-12 09:20:57.350000
60 DAY | 2014-02-27 09:20:57.350000
90 DAY | 2014-03-29 09:20:57.350000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 44578d1243358705-listing-names-in-a-row-or-column-without-duplication-template-for-the-forum_260509
Sheet: Original

Start Date | End Date | Forecast cost | No. of days | Project Name
2009-01-01 00:00:00 | 2009-02-15 00:00:00 | 1000000 | 46 | Proj A
2009-02-16 00:00:00 | 2009-06-30 00:00:00 | 850000 | 135 | Proj C
2009-07-01 00:00:00 | 2009-07-22 00:00:00 | 1580000 | 22 | Proj B
2009-07-22 00:00:00 | 2009-08-15 00:00:00 | 400000 | 25 | Proj B-2
2009-08-16 00:00:00 | 2009-10-31 00:00:00 | 750000 | 77 | Proj-9
2009-10-31 00:00:00 | 2009-12-15 00:00:00 | 980000 | 46 | Proj-Y
2009-12-16 00:00:00 | 2009-12-31 00:00:00 | 2200000 | 16 | ProjC-3
2009-12-31 00:00:00 | 2010-02-15 00:00:00 | 250000 | 47 | Proj C
2010-02-16 00:00:00 | 2010-04-02 00:00:00 | 1500000 | 46 | Proj-9
2010-04-03 00:00:00 | 2010-06-20 00:00:00 | 2500000 | 79 | Proj A
 |  |  | List of Projects: | Any way I can list the above projects in E1: E11 without duplication and as and when a new proj is added above, the list below gets updated too
 |  |  | 0
Spreadsheet: stacey_white__39200__New Book Request EnPower
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  | Department: |  |  | Risk Management
Subject: | New Power Book Request
System: | EnPower |  |  |  |  |  |  |  |  |  |  |  | Date: |  |  | 2002-01-09 00:00:00
CP/ID | GLOBAL COUNTERPARTY |  | ENPOWER |  |  | BOOK PURPOSE |  |  | ENPOWER |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  |  |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  | Book
 | [NAME]                (15 character limit in CAPS, no spaces, - - dashes permitted) | Long Name | Portfolio/Sub-Portfolio | Sub-to Legal Relationship | EnPower Link | Transactions | Transactions | Transactions | Code | Region | P | Commodity/UOM/Curr | [NAME]) | MTM/ACCRUAL | Reason for Book | Administrator* | MTM | Prud | Realized
 | NETCO-LT-NW | NETCO [NAME] | WEST/NORTHWEST | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R9 |  | POWER/MWH/USD | [NAME] | MTM | NETCO
 | NETCO-LT-SW | NETCO Long Term South West | WEST/SOUTHWEST | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R7 |  | POWER/MWH/USD | [NAME] | MTM | NETCO
 | NETCO-LT-CALI | NETCO Long Term California | WEST/CALIFORNIA | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R11 |  | POWER/MWH/USD | [NAME] | MTM | NETCO
 | NETCO-ST-NW | NETCO Short Term Northwest | WEST/NORTHWEST | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R9 |  | POWER/MWH/USD | Sean Crandall/Diana Scholtes | MTM | NETCO
 | NETCO-ST-SW | NETCO Short Term Southwest | WEST/SOUTHWEST | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R7 |  | POWER/MWH/USD | [NAME] Richter | MTM | NETCO
 | NETCO-ST-CALI | NETCO  Short Term California | WEST/CALIFORNIA | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R11 |  | POWER/MWH/USD | [NAME] | MTM | NETCO
 | NETCO-W-HOURLY | [NAME] | WEST/NORTHWEST,SOUTHWEST,CALIFORNIA | NETCO WEST POWER | NETCO WEST ENPOWER |  |  | x |  | R11 |  | POWER/MWH/USD | [NAME] | MTM | NETCO
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  |  |  |  | I7 | EQUITIES | X | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  |  |  |  | I8 | EQUITIES | X | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  |  |  |  | I3 | EQUITIES | X | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  |  |  |  | QM | DESK | X | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  |  |  |  | V# | DESK | X | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | Access List:
 | [NAME] | jpostle
 | [NAME] | [NAME]
 | [NAME] | slaw
 | Heather Dunton | hdunton
 | Casey Evans | cevans
 | [NAME] | swhite
Spreadsheet: 117141d1312472434-counting-duplicates-in-a-column-with-date-range-duplicates
Sheet: Sheet1

[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 4/31/2010
[NAME] | 4/31/2010
[NAME] | 4/31/2010
[NAME] | 4/31/2010
[NAME] | 4/31/2010
[NAME] | 4/31/2010
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2010-01-31 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
[NAME] | 2009-02-22 00:00:00
Spreadsheet: 768233d1644891604-simple-formula-ifs-countif-case-monitoring
Sheet: Sheet1

Company | Month | Positive on | Quarantine until
GSCB |  | 2022-01-01 00:00:00 | 2022-01-31 00:00:00
GSCB |  | 2022-02-09 00:00:00
GSCB |  | 2022-02-09 00:00:00
GSV |  | 2022-02-13 00:00:00
GSV |  | 2022-02-13 00:00:00
Spreadsheet: 1d6e8a51-37f2-4a3a-8876-964637385b9f
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 14. COMMERCIAL FINANCE COMMITMENTS, Summary: Australia, All Series ($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
Fixed loans ; |  |  | Original | A2414272W | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Original | A2414273X | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Original | A2414274A | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Seasonally Adjusted | A2414269J | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Seasonally Adjusted | A2414270T | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Seasonally Adjusted | A2414271V | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Fixed loans ; |  |  | Trend | A2414266A | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
Revolving credit ; |  |  | Trend | A2414267C | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
TOTAL ; |  |  | Trend | A2414268F | 1975-10-01 00:00:00 | 2012-02-01 00:00:00 | 437 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 688911d1596018609-array-formula-suddenly-stops-working-vat-statement
Sheet: Sales Journal

Sales Journal
Date | Customer Number | Name | Vat Number | Invoice | Invoice Exist | Amount | Vat % | VAT | Amount incl [NAME]
2020-03-01 00:00:00 | C001 | GRAIG | 10002346 | 6000 |  | 2000 | 0.15
2020-03-02 00:00:00 | C002 | ASHTON | 10002347 | 6001 |  | 2000 | 0.15
2020-01-03 00:00:00 | C003 | DESIRE | 10002348 | 6002 |  | 2000 | 0.15
2020-01-04 00:00:00 | C004 | CLINT |  | 6003 |  | 2000
2020-11-05 00:00:00 | C005 | OMEGA | 10002350 | 6004 |  | 2000 | 0.15
2020-11-06 00:00:00 | C006 | ETHAN | 10002346 | 6005 |  | 2000 | 0.15
2020-01-07 00:00:00 | C007 | NOLLEN | 10002346 | 6006 |  | 2000 | 0.15
2020-01-08 00:00:00 | C008 | GABRIEL | 10002346 | 6007 |  | 2000 | 0.15
2020-01-09 00:00:00 | C001 | GRAIG | 10002346 | 6008 |  | 2000 | 0.15
2020-02-10 00:00:00 | C002 | ASHTON | 10002347 | 6009 |  | 2000 | 0.15
2020-02-11 00:00:00 | C003 | DESIRE | 10002348 | 6010 |  | 2000 | 0.15
Spreadsheet: 680767d1591189769-array-formula-help-earlydate
Sheet: Sheet1

Name | Date | Earliest Date
Adam | 2020-02-02 00:00:00
[NAME] | 2020-03-03 00:00:00
[NAME] | 2018-01-19 00:00:00
[NAME] | 2020-02-04 00:00:00
[NAME] | 2019-03-03 00:00:00
[NAME] | 2019-01-05 00:00:00
Adam | 2020-01-31 00:00:00
[NAME] | 2020-04-04 00:00:00
Spreadsheet: 724182d1616055331-reconcile-bank-statement-forumla-reconcile-sample
Sheet: Sheet1

My Register |  |  |  |  |  |  |  | The Bank
Date | Transaction | Withdrawal | Deposit | Balance | [NAME] | [NAME] | Reconcile Deposits | Date | Transaction | Withdrawal | Deposit | Balance
 | Starting Balance |  |  | 2000 |  |  |  |  | Starting Balance |  |  | 2000
2021-02-02 00:00:00 | Electric | 50.44 |  | 1949.56 | R |  |  | 2021-02-03 00:00:00 | Transaction - Electric Company | 50.44 |  | 1949.56
2021-02-15 00:00:00 | Cable | 49.99 |  | 1899.57 | R |  |  | 2021-02-18 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1899.57
2021-02-25 00:00:00 | Car | 215.68 |  | 1683.89 | R |  |  | 2021-02-25 00:00:00 | Car Financer Co. | 215.68 |  | 1683.89
2021-02-26 00:00:00 | Rebate |  | 100.5 | 1784.39 | ? |  |  | 2021-02-26 00:00:00 | Deposit |  | 100.5 | 1784.39
2021-02-25 00:00:00 | Water Co. | 47.27 |  | 1737.12 | R |  |  | 2021-02-25 00:00:00 | City Water Company | 47.27 |  | 1737.12
2021-03-02 00:00:00 | Electric | 62.32 |  | 1674.8 | R |  |  | 2021-03-06 00:00:00 | Transaction - Electric Company | 62.32 |  | 1674.8
2021-03-10 00:00:00 | B-day gift |  | 50 | 1724.8 | ? |  |  | 2021-03-10 00:00:00 | Deposit |  | 50 | 1724.8
2021-03-15 00:00:00 | Cable | 49.99 |  | 1674.81 | R |  |  | 2021-03-20 00:00:00 | Joe's Cable, Inc | 49.99 |  | 1674.81
2021-03-25 00:00:00 | Water Co. | 63.89 |  | 1610.92 | R |  |  | 2021-03-25 00:00:00 | City Water Company | 63.89 |  | 1610.92
2021-03-25 00:00:00 | Car | 215.68 |  | 1395.24 | R |  |  | 2021-03-26 00:00:00 | Car Financer Co. | 215.68 |  | 1395.24
What I would like is a formula that will: |  |  |  |  |  |  | Dates may differ slightly from what was entered in My Register
- Match date, transaction, and amount, then return "R" in Column F if match or "?" if no match |  |  |  |  |  |  | Transaction may be different but will contain key words in both lists
- Date (I guess month and year; unless can do within x days of the date in my register |  |  |  |  |  |  | The amount will match for the date, but could be different month to month
Spreadsheet: 713651d1610864716-is-countifs-the-easiest-way-to-complete-this-request-sample-workbook
Sheet: Sheet1

Week | Associate | Manager | Agent Group | ID | 1.1 | Checkbox 1 | Checkbox 2 | Checkbox 3 | 1.2 | Checkbox 4 | Checkbox 5 | Check box 6
Week 1 | Erick | Manager A | ABC | 1 | PASS | Reason 1 | Reason 2 | Reason 3 | FAIL | Reason 4 | Reason 5 | Reason 6
Week 1 | [NAME] | Manager A | ABC | 36 | FAIL | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 1 | [NAME] | Manager B | ABC | 2 | PASS | Reason 1 | Reason 2 | Reason 3 | FAIL | Reason 4 | Reason 5 | Reason 6
Week 1 | [NAME] | Manager A | XYZ | 4 | PASS | Reason 2 | Reason 3 |  | FAIL | Reason 5 | Reason 6
Week 1 | [NAME] | Manager C | XYZ | 38 | PASS | Reason 2 | Reason 3 |  | PASS | Reason 5 | Reason 6
Week 1 | [NAME] | Manager A | XYZ | 39 | PASS | Reason 2 |  | Reason 1 | PASS | Reason 5
Week 1 | [NAME] | Manager B | XYZ | 40 | PASS | Reason 1 |  |  | FAIL | Reason 4
Week 1 | [NAME] | Manager B | ABC | 37 | FAIL | Reason 3 |  |  | PASS | Reason 6
Week 1 | [NAME] | Manager C | XYZ | 3 | PASS | Reason 3 |  | Reason 1 | FAIL | Reason 6
Week 2 | [NAME] | Manager A | XYZ | 8 | PASS | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 2 | [NAME] | Manager A | XYZ | 35 | FAIL | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 2 | [NAME] | Manager C | XYZ | 7 | PASS | Reason 1 | Reason 3 |  | PASS | Reason 4 | Reason 6
Week 2 | [NAME] | Manager C | XYZ | 34 | FAIL | Reason 1 | Reason 3 |  | PASS | Reason 4 | Reason 6
Week 2 | Erick | Manager A | ABC | 5 | PASS | Reason 2 |  |  | PASS | Reason 5
Week 2 | [NAME] | Manager A | ABC | 32 | FAIL | Reason 2 | Reason 1 |  | PASS | Reason 5
Week 2 | [NAME] | Manager B | ABC | 6 | PASS | Reason 1 |  | Reason2 | PASS | Reason 4
Week 2 | [NAME] | Manager B | ABC | 33 | PASS | Reason 1 |  |  | PASS | Reason 4
Week 3 | Erick | Manager A | ABC | 9 | PASS | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 3 | [NAME] | Manager A | XYZ | 28 | PASS | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 3 | [NAME] | Manager A | ABC | 29 | PASS | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6
Week 3 | [NAME] | Manager C | XYZ | 11 | FAIL | Reason 2 | Reason 3 |  | PASS | Reason 5 | Reason 6
Week 3 | [NAME] | Manager C | XYZ | 31 | FAIL | Reason 2 | Reason 3 |  | PASS | Reason 5 | Reason 6
Week 3 | [NAME] | Manager B | ABC | 10 | FAIL | Reason 3 |  |  | PASS | Reason 6
Week 3 | [NAME] | Manager B | ABC | 30 | FAIL | Reason 3 |  |  | PASS | Reason 6
Week 4 | [NAME] | Manager A | XYZ | 15 | FAIL | Reason 1 | Reason 2 | Reason 3 | PASS | Reason 4 | Reason 5 | Reason 6