tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__30659__9909_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | -1938963.15 | 59738727.48
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 2000 | 4870
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | -1936963.15 | 59743597.48
 | Purchases:
6 |  | 3rd Party / Inter Enron | 6515640.149999999 | -45569835.54000001
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -7753 | -20157.8
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 56 | 142.86
 | Total Purchases: |  | 6507943.149999999 | -45589850.48
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales | 28594631.15 | 11334756
12 |  | Purchases | -28594631.15 | -11334756
 | Total Intra CTS Sales / Purchases |  | 0 | 0
 | Imbalances:
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 | Storage:
17 |  | Injection (Sales to Stg) | 30000 | 87300
18 |  | W/D (Purchase from Stg) | -65000 | -189150
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -65000 | -189150
 | Total Storage: |  | -35000 | -101850
20 | Linepack: |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
22 | UA4: |  | -4535980 | -13010971.26159053
23 | Fuel: |  | -56 | 0
 | Transport Expense:
24 |  | Commodity | 0 | -472403
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -472403
 | Transport Revenue:
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance | 0 | -1503217.93
31 |  | Prior Month Book Balance | 0 | 1681622
 |  | Total MTM Income | 0 | 178404.07
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 142646.04
34 |  | Originations | 0 | 0
35 |  | Broker Fees | 0 | -2466
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -42013
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | -810329
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 924228
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 240171d1370245244-print-sheet-calculator-papercalc-v2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Size | L | W
 | Paper Product | Length | [NAME] |  | Quantity |  |  |  | Custom
 | SRA1 |  |  |  | 300 | Input Quantity |  |  | DL | 99 | 210
 |  |  |  |  |  |  |  |  | DLE | 110 | 220
 |  |  |  |  |  |  |  |  | F4 | 210 | 330
 |  |  |  |  |  |  |  |  | RA0 | 841 | 189
 | Paper Source | Length | [NAME] |  | Required |  |  |  | RA1 | 610 | 860
 | SRA3 |  |  |  |  | Answer |  |  | RA2 | 430 | 610
 |  |  |  |  |  |  |  |  | RA3 | 305 | 430
 |  |  |  |  |  |  |  |  | RA4 | 215 | 305
 |  |  |  |  |  |  |  |  | SRA0 | 900 | 280
 |  |  |  |  |  |  |  |  | SRA1 | 640 | 900
 |  |  |  |  |  |  |  |  | SRA2 | 450 | 640
 |  |  |  |  |  |  |  |  | SRA3 | 320 | 450
 |  |  |  |  |  |  |  |  | SRA4 | 225 | 320
 |  |  |  |  |  |  |  |  | A3+ | 329 | 483
Spreadsheet: 39386d1237547441-producing-automatic-reports-with-2-variables-sample
Sheet: Inbound Recodring

 | Today |  |  | 2009-03-20 11:09:07
 | Marketing Conversion Cummulative YTD
 |  |  |  |  | Outcome
 | Source Code | Inbound |  | Outcome 1 |  | Outcome 2 |  | Outcome 3 |  | Outcome 4 |  | Outcome 5 |  | Outcome 6 |  | Outcome 7 |  | Outcome 8 |  | Outcome 9 |  | Outcome 10
 |  | % | No | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | % | No | %
Spreadsheet: 0a57367a-2287-48a2-83bd-713c880a3dbf
Sheet: Sheet1

Unnamed: 0 | Attachment J | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 |  |  | SUBCONTRACTOR LINE ITEM BUDGET FORM
 |  |  | (check one)    __ term 1/8/2013 – 6/30/2013
 |  |  | __ term 7/1/2013 – 6/30/2014
 | NOTE: A separate budget must be completed for each term for which funding is requested.
 | RFP # |  | APPLICANT NAME:
 | Line Item | FTE | H&SS | Other Sources | TOTAL
 | Personnel
 | Staff Member 1
 | Staff Member 2
 | Staff Member 3
 | Staff Member 4
 | Benefits
 | SUBTOTAL PERSONNEL
 | Operating Expenses
 | Rent & Utilities
 | Office Supplies & Material
 | Telephone & Communication
 | Postage/Mailing
 | Reproduction/Copying
 | Travel
 | Training/Conferences
 | Start-Up costs (Year 1 only)
 | Other
 | SUBTOTAL OPERATING EXPENSES
 | Subcontractors
 | Subcontractor 1
 | Subcontractor 2
 | SUBTOTAL SUBCONTRACTORS
 | Indirect Costs
 | Indirect Costs
 | SUBTOTAL INDIRECT COSTS
 | GRAND TOTAL EXPENSES
Spreadsheet: 679631d1590539102-lookup-based-on-2-criteria-lookup-example
Sheet: Template

ID | Name | 85000.AB.3000 | 85000.AZ.3000 | 90000.AB.3000 | 90000.AZ.3000
12345 | [NAME], [NAME] | 25000 | 300
98765 | Doe, [NAME] |  |  | 4500 | 5000
24680 | [NAME], [NAME] |  | 1000 | 55
13579 | [NAME], [NAME] | 2500 | 700 | 2500
13579 | [NAME], [NAME] |  | 2500
12390 | Nicole, Amber |  |  | 25
Spreadsheet: 131846d1323356576-nested-if-or-and-matched-indexed-statements-janine-2
Sheet: Ams, Ber, Pra, Vie, Ven

Rooming allocation for Amsterdam, Berlin, Prague, Vienna, Venice |  |  |  |  |  |  |  |  |  |  | #N/A
Type | # of Rms
Singles |  | 0
Twins |  | 0
Triples |  | 0
Quads |  | 0
5 bed |  | 0
6 bed |  | 0
Total Pax |  | 0
[NAME] | [NAME] | Single | Twin |  | Triple |  | Quad |  | 5 bed |  | 6 bed
 |  | Driver
 |  | Tour leader
 |  |  | mr s | 1
 |  |  | Mrs s | 1
 |  |  | mr o | 2
 |  |  | mr p | 2
 | h
b
 | v
Spreadsheet: fb2167e0-a9b6-4b71-aacc-8f13d921b777
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
261302 | 7981 | [NAME] | [NAME] | USA | 3046 | 00:14:41 | [NAME] | 00:34:19 | 00:01:36 | 00:24:27 | 1 | 01:16:29
261302 | 43854 | [NAME] | Vogtsberger | USA | 3043 | 00:13:55 | 00:02:48 | 00:32:42 | 00:02:07 | 00:27:34 | 2 | 01:19:04
261302 | 70002 | [NAME] | [NAME] | USA | 3040 | 00:10:41 | [NAME] | 00:44:00 | 00:02:19 | 00:24:37 | 3 | 01:24:06
261302 | 60943 | Rajesh | Durbal | USA | 3047 | 00:16:16 | 00:04:24 | 00:39:37 | 00:04:04 | 00:27:06 | 4 | 01:31:26
261302 | 70552 | Gregory | Tyler | USA | 3041 | 00:37:16 | 00:06:31 | 00:48:12 | 00:03:22 | [NAME] | 5 | 02:22:01
Spreadsheet: 32417d1228544448-list-box-listboxes
Sheet: Sheet1

68 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68
56 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9
42 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95
36
32
84
68 |  |  |  |  |  |  |  |  |  | Control Toolbox
56 |  |  |  |  |  |  |  |  |  |  |  |  |  | Forms Toolbar
95
62
90
52
101
46
61
64
73
28
32
69
32
54
62
59
46
43
Spreadsheet: 787673d1657949428-lookup-not-working-as-i-thought-it-would-lookuptest
Sheet: Sheet1

KB | 4
HC | 712
TP | 625
BP | 6
JR | 58
MR | 232
CS | 541
ZS | 28
RT | 0
JT | 0
AW | 161
Spreadsheet: 840207d1692555646-need-help-creating-a-worksheet-that-when-data-is-entered-it-auto-adds-info-example-attach-example
Sheet: Sheet1

AUGUST TARGETS & TRENDS
Trend Tours | Trend Volume
 |  | Trend Tour Tier | Trend Volume Tier |  |  |  | Targets: | Tours | Volume
 |  |  |  |  |  |  |  | 784 | 5750000
 |  |  |  |  |  |  |  |  |  | The targets change Monthly and I would like to be able to plug in on data Page
 |  |  | I want these in a Large Box up top
 |  |  | The trend formula is take number of tours and divide by number of days that have happened such as I will input numbers from 8/18 today
 |  |  | Same with volume
Date | Tours | Volume
2023-08-01 00:00:00 | 357 | 1200560
2023-08-02 00:00:00
2023-08-03 00:00:00
2023-08-04 00:00:00
2023-08-05 00:00:00 |  |  |  | These I want the numbers and [NAME] to Auto populate when I enter Information on the data Page.
2023-08-06 00:00:00
2023-08-07 00:00:00
2023-08-08 00:00:00
2023-08-09 00:00:00
2023-08-10 00:00:00
2023-08-11 00:00:00
2023-08-12 00:00:00
2023-08-13 00:00:00
2023-08-14 00:00:00
2023-08-15 00:00:00
2023-08-16 00:00:00
2023-08-17 00:00:00
2023-08-18 00:00:00
2023-08-19 00:00:00
2023-08-20 00:00:00
2023-08-21 00:00:00
2023-08-22 00:00:00
2023-08-23 00:00:00
2023-08-24 00:00:00
2023-08-25 00:00:00
2023-08-26 00:00:00
2023-08-27 00:00:00
2023-08-28 00:00:00
2023-08-29 00:00:00
2023-08-30 00:00:00
2023-08-31 00:00:00
Spreadsheet: 743343d1628429458-extend-index-and-match-function-data1
Sheet: Sheet2

Code | dateFrom | dateTo
S035 | 10-July-2015 | 25-August-2015
S035 | 2-April-2018 | 7-April-2018
S035 | 2-March-2018 | 1-April-2018
S035 | 4-February-2017 | 20-February-2017
S035 | 5-February-2016 | 20-February-2016
S035 | 5-May-2019 | 2-June-2019
Spreadsheet: 731011d1620116897-conditional-max-and-rank-of-18-digit-text-numbers-using-dynamic-array-formulas-maxifs
Sheet: MAXIFS

Category | Numbers to be ranked | Last 15 digits from numbers to be run through MAXIFS and RANKIFS | MAXIFS | RANKIFS
15022505 | 100000000000421730 |  |  |  |  |  | 1. Numbers (in text format) to be run through MAXIFS and RANKIFS consist of 18 digits, but Excel only keeps the 15 first digits, while turning the rest into zeroes except when the string is kept as text format.
15022505 | 100000000000421731 | 421731 |  |  |  |  | 2. A formula to output a dynamic array with the results seen in column E is needed, and without the use of helper columns C and D.
15022505 | 100000000000421731 | 421731 |  |  |  |  | 3. LET function not yet available.
15022505 | 100000000000421731 | 421731
15022505 | 100000000000421732 | 421732
15022505 | 100000000000421732 | 421732
15022505 | 100000000000421732 | 421732
15022505 | 100000000000421733 | 421733
15022505 | 100000000000421733 | 421733
15022505 | 100000000000421733 | 421733
15022505 | 100000000000421734 | 421734
15022505 | 100000000000421734 | 421734
15022505 | 100000000000421734 | 421734
15022507 | 100000000000421864 | 421864
15022507 | 100000000000421865 | 421865
15022507 | 100000000000421865 | 421865
15022507 | 100000000000421865 | 421865
15022507 | 100000000000421866 | 421866
15022507 | 100000000000421866 | 421866
15022507 | 100000000000421866 | 421866
15022507 | 100000000000421866 | 421866
15022507 | 100000000000421867 | 421867
15022507 | 100000000000421867 | 421867
15022507 | 100000000000421867 | 421867
15022507 | 100000000000421867 | 421867
15022507 | 100000000000421868 | 421868
15022507 | 100000000000421868 | 421868
15022507 | 100000000000421868 | 421868
15022507 | 100000000000421868 | 421868
15022507 | 100000000000421869 | 421869
15022507 | 100000000000421869 | 421869
15022507 | 100000000000421869 | 421869
Spreadsheet: 46759d1245702392-copying-values-from-matched-rows-test
Sheet: Sheet2

Surname | Postcode | Level | Mode
Smith | BT12 5HT | Non-Advanced | Part-Time
[NAME] | BT34 7TJ | Non-Advanced | Full-Time
[NAME] | BT1 4IS | Advanced | Full-Time
McKay | BT83 8DJ | Non-Advanced | Part-Time
Jones | BT73 3KD | Advanced | Part-Time
Campbell | BT94 7GB | Advanced | Full-Time
O'Neill | BT23 5HV | Non-Advanced | Part-Time
Spreadsheet: 202617d1356647335-how-can-i-create-a-point-system-for-attendance-tardies-absents-etc-absent-moo
Sheet: Data

Employee | Date | [NAME] | Pts. |  | [NAME] | Multiplier
[NAME] | 2012-10-01 00:00:00 | Excused Call-Ins |  |  | Tardies | 0.5
[NAME] | 2012-10-02 00:00:00 | Unexcused Call-ins |  |  | Excused Call-Ins | 1
[NAME] | 2012-10-03 00:00:00 | Unexcused Call-ins |  |  | Unexcused Call-ins | 3
[NAME] | 2012-11-01 00:00:00 | Tardies
[NAME] | 2012-11-02 00:00:00 | Tardies
[NAME] | 2012-11-03 00:00:00 | Tardies |  |  | Employees
[NAME] | 2012-11-04 00:00:00 | Excused Call-Ins |  |  | [NAME]
[NAME] | 2012-11-05 00:00:00 | Excused Call-Ins |  |  | [NAME]
[NAME] | 2012-11-06 00:00:00 | Unexcused Call-ins |  |  | [NAME]
[NAME] | 2012-11-07 00:00:00 | Unexcused Call-ins |  |  | Sue
[NAME] | 2012-11-08 00:00:00 | Unexcused Call-ins
[NAME] | 2012-11-09 00:00:00 | Unexcused Call-ins
[NAME] | 2012-11-10 00:00:00 | Unexcused Call-ins
[NAME] | 2012-11-11 00:00:00 | Unexcused Call-ins
[NAME] | 2012-10-01 00:00:00 | Tardies
[NAME] | 2012-10-02 00:00:00 | Excused Call-Ins
[NAME] | 2012-11-01 00:00:00 | Unexcused Call-ins
[NAME] | 2012-11-02 00:00:00 | Unexcused Call-ins
[NAME] | 2012-10-01 00:00:00 | Tardies
[NAME] | 2012-10-02 00:00:00 | Tardies
[NAME] | 2012-10-03 00:00:00 | Tardies
[NAME] | 2012-10-04 00:00:00 | Tardies
[NAME] | 2012-10-05 00:00:00 | Excused Call-Ins
[NAME] | 2012-10-06 00:00:00 | Excused Call-Ins
[NAME] | 2012-10-07 00:00:00 | Unexcused Call-ins
[NAME] | 2012-11-01 00:00:00 | Tardies
[NAME] | 2012-11-02 00:00:00 | Excused Call-Ins
[NAME] | 2012-11-03 00:00:00 | Unexcused Call-ins
Sue | 2012-10-01 00:00:00 | Excused Call-Ins
Sue | 2012-10-02 00:00:00 | Unexcused Call-ins
Sue | 2012-10-03 00:00:00 | Unexcused Call-ins
Sue | 2012-11-01 00:00:00 | Tardies
Sue | 2012-11-02 00:00:00 | Tardies
Sue | 2012-11-03 00:00:00 | Tardies
Sue | 2012-11-04 00:00:00 | Excused Call-Ins
Sue | 2012-11-05 00:00:00 | Excused Call-Ins
Sue | 2012-11-06 00:00:00 | Excused Call-Ins
Sue | 2012-11-07 00:00:00 | Excused Call-Ins
Sue | 2012-11-08 00:00:00 | Excused Call-Ins
Sue | 2012-11-09 00:00:00 | Excused Call-Ins
Sue | 2012-11-10 00:00:00 | Excused Call-Ins
Sue | 2012-11-11 00:00:00 | Unexcused Call-ins
Spreadsheet: 48844d1248143042-creating-a-time-sheet-trial-timecard
Sheet: Sheet2

Job Number | Name | Date | Time in | Time out |  | Crew 1 | Crew 2 | Crew 3
02-112 | [NAME] | 2009-06-29 00:00:00 | 01:00:00 | 04:00:00
06-037 | af | 2009-06-29 00:00:00 | 13:00:00 | 18:00:00 |  | [NAME] | Martin
09-038 | asdf | 2009-06-30 00:00:00 | 12:00:00 | 16:00:00 |  | [NAME] | Martin | [NAME]
06-047 | asdfsdf | 2009-06-30 00:00:00 | 08:00:00 | 16:00:00 |  | [NAME]
04-132 | osfs | 2009-07-02 00:00:00 | 13:00:00 | 17:00:00 |  |  | Martin | [NAME]
07-098 | asdfc | 2009-07-02 00:00:00 | 12:00:00 | 16:00:00 |  | [NAME] |  | [NAME]
02-112 | ewrs | 2009-07-02 00:00:00 | 10:00:00 | 16:00:00 |  |  | Martin
Spreadsheet: chris_stokley__3956__August Forecast
Sheet: CALCS

AUGUST 2001 FORECAST
*** All Values in MW ***
 | Hour Ending…..
First 5 Weekdays | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | [NAME]. | On-Pk | Off-Pk | S-Pk | [NAME] | Min
NP-15
SP-15
ZP-15
TOTAL
 | Hour Ending…..
Full Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | [NAME]. | On-Pk | Off-Pk | S-Pk | [NAME] | Min
NP-15
SP-15
ZP-15
TOTAL
 | Hour Ending…..
Last 5 Weekdays | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | [NAME]. | On-Pk | Off-Pk | S-Pk | [NAME] | Min
NP-15
SP-15
ZP-15
TOTAL
Spreadsheet: 848167d1698937784-need-help-on-sum-and-indirect-function-combined-sample-file-5-
Sheet: Summary 1

Emp name | Designation | Total Exp in Month | Billing | Per Month ctc in rs. | Per Month CTC in GBP
[NAME] | Sr exexcutive | 12 | 874.32 | 30000
praksh | Sr exexcutive | 15 | 1290.19 | 60000
[NAME] | Sr exexcutive | 22 | 1312 | 20000
rajat | Sr exexcutive | 13 | 600 | 21000
arun | Trainee | 4 | 1100 | 23000
sneha | Trainee | 6 | 120 | 10000
vandana | Trainee | 2 | 120 | 19000
parik | Sr exexcutive | 10 | 120 | 18000
ashish | Trainee | 1 | 120 | 12000
Spreadsheet: 162620d1340011859-how-to-use-the-index-match-function-to-capture-several-rows-with-one-matching-column-value-ciao
Sheet: Sheet1

School | Teacher Surname |  | School2 |  | Teacher Surnames from School in CellD1
School1 | TeacherA |  |  |  | [NAME]
School1 | TeacherB |  |  |  | TeacherE
School1 | TeacherC
School2 | [NAME]
School2 | TeacherE
School3 | TeacherF
School3 | TeacherG
Spreadsheet: tracy_geaccone__40398__BaseGasData
Sheet: Base Gas Sales

NORTHERN NATURAL GAS COMPANY
BASE GAS SALE ANALYSIS
1999 ACTUAL - 2002 PLAN
($000's)
 |  |  |  |  |  | ACT. |  | ACT. |  | 3rd CE |  | PLAN
 |  |  |  |  |  | 1999 |  | 2000 |  | 2001 |  | 2002
Sempra Base Gas Sale (7/99 - 15 Bcf)
 | Income Statement Impact
 |  | Sales Revenue |  |  |  | 33750 |  | 0 |  | 0 |  | 0
 |  | Less: Cost of Sales |  |  |  | 11145 |  | 0 |  | 0 |  | 0
 |  |  | Sales Margin
 |  | TC&S Expense (SBA Fees) |  |  |  | -1502 |  | -3265 |  | -2820 |  | -2214
 |  |  | Operating Income
TransCanada Base Gas Sale (6/00 - 12.2 Bcf)
 | Income Statement Impact
 |  | Sales Revenue |  |  |  | 0 |  | 51240 |  | 0 |  | 0
 |  | Less: Cost of Sales |  |  |  | 0 |  | 9072 |  | 0 |  | 0
 |  |  | Sales Margin
 |  | TC&S Expense (SBA Fees) |  |  |  | 0 |  | -7316 |  | -11256 |  | -11256
 |  |  | Operating Income
Spreadsheet: 759589d1639602052-sum-column-based-on-values-in-2-other-columns-audits-master-2-
Sheet: DC 21 Audits Master

[NAME] | Errors | Cases |  |  |  | [NAME] | Cases without errors | SUMIFS
[NAME] |  | 144 |  |  |  | [NAME]
[NAME] | 1 | 182 |  |  |  | [NAME]
Luc | 1 | 187 |  |  |  | Luc
[NAME] |  | 265 |  |  |  | [NAME]
[NAME] |  | 226
Brae |  | 241
[NAME] |  | 90
[NAME] | 1 | 150
[NAME] | 0 | 100
[NAME] | 0 | 80
[NAME] | 0 | 60
[NAME] | 1 | 40
[NAME] | 1 | 880
[NAME] |  | 100
[NAME] | 1 | 220
[NAME] | 0 | 233
[NAME] | 1 | 80
[NAME] | 1 | 232
[NAME] | 1 | 234
[NAME] |  | 259
[NAME] |  | 191
[NAME] | 1 | 191
Spreadsheet: 216537d1361804004-calculating-frequency-of-unique-texts-within-a-month-under-multiple-criteria-sample
Sheet: Sheet1

Date | Company Name | Payment Mode |  |  | Finding a general formula to calculate transactions per month which updates whenever a new log appears.
2010-01-20 00:00:00 | ABC Hearts | Cash |  |  | If possible, seperated by payment mode (Cash transactoin per month.)
2010-01-21 00:00:00 | [NAME] | Cheque |  |  | Transaction Per Month (No Duplicates)
2010-01-22 00:00:00 | [NAME] | Cash |  |  | January | February | March | April | May | June | July | August | September | October | November | December
2010-01-23 00:00:00 | ABC Hearts | Cash |  | 2010
2010-02-02 00:00:00 | [NAME] | Cash |  | 2011
2010-02-03 00:00:00 | [NAME] | Cheque |  | 2012
2010-02-04 00:00:00 | ABC Hearts | Cash
2010-02-20 00:00:00 | Seri | Cheque
2010-12-21 00:00:00 | Seri | Cheque
2011-01-21 00:00:00 | ABC Hearts | Cash
Spreadsheet: 014db8f2-6d9d-4924-a1e0-44b25b7f72eb
Sheet: Sheet1

Title | Name | Description | Date | Amount
City Council | [NAME] | Newly Elected Official Institute Registration | 2014-03-19 00:00:00 | 75
City Council | [NAME] | Newly Elected Official Institute Registration | 2014-03-19 00:00:00 | 75
City Council | [NAME] | Bishop's Lodge Hotel for MOLI Conference | 2014-06-03 00:00:00 | 165.2
City Council | [NAME] | NMML Conference Registration - MOLI | 2014-06-05 00:00:00 | 300
Mayor | Gregory Hull | Municipal Officials Workshop Registration | 2014-05-14 00:00:00 | 300
Mayor | Gregory Hull | Flight to US Conference of Mayors in Dallas | 2014-05-14 00:00:00 | 248
Municipal Judge | [NAME] | NMML Judges Conference Registration | 2014-04-15 00:00:00 | 95
Municipal Judge | [NAME] | Rental Car for Judges Conference | 2014-05-23 00:00:00 | 264.49
Spreadsheet: 1d19e475-f623-4540-8540-8c073595981d
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 36. LEASE FINANCE COMMITMENTS, By Purpose: State (TAS), Original (Number, $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
1 . . . [NAME] ; |  |  | Original | A2413895X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
1.1 . . . . . New cars and station wagons ; |  |  | Original | A2413896A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [New cars and station wagons (no.)] ; |  |  | Original | A2413897C | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.2 . . . . . Used cars and station wagons ; |  |  | Original | A2413898F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . [Used cars and station wagons (no.)] ; |  |  | Original | A2413899J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3 . . . . . Other motor vehicles  ; |  |  | Original | A2413900F | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
1.3.1a . . . . . . - new trucks ; |  |  | Original | A2413901J | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [new trucks (no.)] ; |  |  | Original | A2413902K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3.3 a. . . . . . - used trucks ; |  |  | Original | A2413903L | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
. . . . . . . . . . . . [used trucks (no.)] ; |  |  | Original | A2413904R | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | Number | FLOW | Month | 1
1.3.5 . . . . . . . - trailers, buses, coaches, other MVs ; |  |  | Original | A2413905T | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
2 . . . Other Transport Equipment ; |  |  | Original | A2413906V | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
3 . . . Agricultural, Construction & Manufacturing Equipment ; |  |  | Original | A2413907W | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
4 . . . Office Equipment ; |  |  | Original | A2413908X | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
5 . . . Other ; |  |  | Original | A2413909A | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2413910K | 1985-01-01 00:00:00 | 2012-07-01 00:00:00 | 331 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 857018d1706116684-use-index-match-to-read-off-of-2-cells-and-return-a-value-test
Sheet: Sheet1

RBArcode | [NAME] | Type | Customer Name | [NAME] | Description | Status | Condition | Unique Barcode Location | RBArcode Location | Date Scanned
2000029*1- | 8000029 | Service | [NAME], [NAME] |  | 17.916 X33.808 SCREEN 1
123456789 | 8000029 | Service | [NAME], [NAME] |  | 17.916 X33.808 SCREEN 1
123456789 |  | Service | [NAME], [NAME] |  | 17.916 X33.808 SCREEN 1
Spreadsheet: 255f02fe-5572-4f12-a0cf-84bd18dda669
Sheet: Sheet1

 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | [NAME] | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  |  |  |  | (This is not a [NAME])
SUGGESTED VENDOR (OPTIONAL) |  |  |  |  | SHIP TO: |  | 66 West 12th St |  |  | 66 Fifth Avenue
 |  |  |  |  |  |  | 2 West 13th St |  |  | 68 Fifth Avenue
 |  |  |  |  |  |  | 55 West 13th St |  |  | 72 Fifth Avenue
 |  |  |  |  |  |  | 64 West 11th St |  |  | 80 Fifth Avenue
 |  |  |  |  |  |  | 65 West 11th St |  |  | 25 East 13th St
 |  |  |  |  |  |  | 150 West 85th St |  |  | 135 East 12th St
 |  |  |  |  |  |  | 65 Fifth Avenue |  |  | 560 Seventh Avenue
 |  |  |  |  |  |  | 71 5th Avenue |  |  | 318 East 15th St
 |  |  |  |  |  |  | 90 5th Avenue |  |  | 300 West 20th St
 |  |  |  |  |  |  | 79 5th Avenue |  |  | 151 Bank St
 |  |  |  |  |  |  | Other:
Attn: |  |  |  |  |  |  | Attn:
Fax/Phone: |  |  |  |  |  |  | Dept: |  |  |  | Rm/Fl:
 |  |  |  |  |  |  | Office extension:
REQUESTED BY |  |  | Budget APPROVAL |  | DATE OF REQ. |  | DATE EXPECTED |  | FOAP to charge
 |  |  |  |  |  |  |  |  | Fund | Org | Acct. | Prog.
[NAME] (Model No., Item No., [NAME], Etc.) |  |  |  |  |  | QUANTITY |  | UNIT COST |  | EXTENDED TOTAL
 |  |  |  |  |  |  |  |  |  | 0
Shipping Charges
 |  |  |  |  |  |  |  | BALANCE DUE |  | 0
NOTE: REQUISITIONS ARE PROCESSED IN THE ORDER WHICH THEY ARE RECEIVED THEY MUST INCLUDE [NAME]'S APPROVAL AND BUDGET ACCOUNT NUMBER
RETAIN A COPY FOR YOUR RECORDS