tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: eb76c2e2-fb3b-4720-9d72-c03a95ca4507
Sheet: 3

 | Jan 18 | Jan 25 | Feb 1 | Feb 8 | Feb 15
Total Interest Rate* | N/A*** | N/A | N/A | N/A | N/A
Cleared** | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Credit | 2354931 | 2371959 | 2375235 | 2363068 | 2369283
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Equity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | N/A | N/A | N/A | N/A | N/A
Cleared | N/A | N/A | N/A | N/A | N/A
Uncleared | N/A | N/A | N/A | N/A | N/A
TOTAL | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, net notional amount outstanding by asset class and cleared status (millions of USD), all products, tenors, and participant types.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 706158d1606501994-excel-sum-if-function-with-different-conditions-excel-sum-if-function-different-conditions-
Sheet: Impress

Order No | Salutation | Account Name | Product 1 | Price 1 | Product 2 | Price 2 | Product 3 | Price 3 | Product 4 | Price 4 | Product 5 | Price 5 |  | Total Sum | One time | Recurring
00307275 | Mrs. | A | cAlarm installatie | 59.5 | cAlarm Home | 22.5 |  | 0 |  | 0 |  | 0 |  |  | 59.5 | 22.5
00307276 | Mrs. | B | cAlarm Home | 22.5 | cAlarm installatie | 59.5 |  | 0 |  | 0 |  | 0
00307277 | Mrs. | C | [NAME] huur per maand | 4.95 | cKey installatie en instructie thuis | 59.5 | Korting combinatie plaatsing cKey + cAlarm | -25 |  | 0 |  | 0
00307279 | Mrs. | D | cAlarm Home | 22.5 | cAlarm installatie | 59.5 |  | 0 |  | 0 |  | 0
00312424 | Mrs. | E | cAlarm installatie | 59.5 | cAlarm Home | 16.95 | Professionele opvolging Zuidzorg | 13.75 |  | 0 |  | 0
00319234 | Mrs. | F | Korting combinatie plaatsing cKey + cAlarm | -25 | cKey installatie en instructie thuis | 59.5 | [NAME] huur per maand | 4.95 |  | 0 |  | 0
00323008 | Mrs. | G | Korting combinatie plaatsing cKey + cAlarm | -49.55 | cKey installatie en instructie thuis | 84.7 | [NAME] huur per maand | 4.95 |  | 0 |  | 0
00323011 | Mrs. | H | Korting combinatie plaatsing cKey + cAlarm | -49.55 | cKey installatie en instructie thuis | 84.7 | [NAME] huur per maand | 4.95 |  | 0 |  | 0
Spreadsheet: 217488-sum-totals-purchase
Sheet: L10-0029-000

L10-0029-000
Part # | Description | QTY | [NAME]
20831-01 | GSKT STACK 8 A369 | 2
30020-01 | ANODE MAG ALLOY 1-5/16X24+1-1/4 NPT | 1
30081-01 | [NAME] VINYL 1 | 3
30081-05 | [NAME] VINYL 2 | 1
30125-01 | CHOKE POSITIVE 2 | 1
30127-07 | [NAME] WLLMRK ST4UP | 7
30228-03 | [NAME] WLLMRK 3 X 5 | 3
30334-01 | GAUGE 200 PSI DRY 2-1/2X1/4 BM | 2
30338-01 | GAUGE 30 PSI DRY 2-1/2X1/4 BM | 4
30345-01 | GAUGE 600 PSI DRY 2-1/2X1/4 BM | 2
30402-01 | HEAD RPTR 1 | 1
30405-01 | PSSR PILOT HI 500# 4660-XF | 1
30565-02 | REG 1PR-3P25S 35-80 1/4ORI 1 | 1
30570-01 | REG WATTS R125-04A 0-25 1/2 | 1
30585-02 | [NAME] WLLMRK 1/4 X 10 | 3
30590-26 | RPTR DISC 1 V500 M550 | 1
30624-02 | SIGHT GLASS 2 | 1
30745-01 | THERMOMETER 3X1/2 NPT X 6L 0250 | 2
30747-02 | THERMOSTAT KMRY T12 HAA | 1
30749-01 | THERMOWELL KMRY 4M 1 X 12 HCC | 1
30749-03 | THERMOWELL KMRY 4M 1 X 6 HCB | 2
30777-02 | GAUGE COCK SET BRASS 1/2 300# | 2
30785-03 | VLV MTR KMRY 112 SMT DAB EMB3 | 1
30787-09 | VLV MTR [NAME] 2200 SMA PO ECM | 2
30788-03 | VLV MTR [NAME] 2200 SMT PO ECP | 1
30788-06 | VLV MTR KMRY 2400 SMT PO ECT | 1
30790-12 | VLV PR 1 X 1 500 MERCER D | 1
30793-01 | VLV PR 2 X 2 125 MERCER F | 1
30795-01 | VLV QUICK EXHAUST 544 SILVER PLTD | 4
30829-02 | VLV BALL BALON 2R-S42 SE 1000 | 2
30829-04 | VLV BALL BALON 2F-S32-SE 750 | 2
30893-01 | VLV BCK PSSR KMRY AAATF6 212SGT | 1
31006-01 | GLASS SIGHT REDLINE 5/8 X 14-3/4 300# | 2
Spreadsheet: 797062d1663691065-adding-second-if-criteria-to-array-formula-jade-help-file
Sheet: Tracking Sheet

311 | Centre
5857 | Program
Fiche | Last Name | First Name |  | 960515 | 960526 | 960534 | 960544 | 960554 | 960683 | 960562 | 960572 | 960584 | 960596 | 960605 | 960613 | 960623 | 960644 | 960656 | 960666 | 960672 | 960635 | 960695 | 960704 | 960714 | 960722 | 960733 | 960746
 |  |  |  | - | - | - | - | - | - | - | - | - | - | - | - | SU | EC | - | - | - | - | - | - | - | - | - | -
Withdrawn
Spreadsheet: 134762d1325617733-return-multiple-unique-values-for-horiontal-table-sample
Sheet: DATA

Customer # | Username
1 | [NAME]
2 | bob
3 | billy
4 | mark
5 | [NAME]
1 | [NAME]
2 | [NAME]
2 | [NAME]
4 | ray
5 | [NAME]
Spreadsheet: 356120d1414990250-anyone-know-how-to-make-a-chart-from-turnover-and-variance-hr-benefits-specialist-pre-work-assignment
Sheet: Tenure By DivDep

Assoc.# | (Multiple Items)
Count of Tenure | Associate/Tenure
 | NE |  |  | NE Total | SW |  |  | SW Total | Grand Total
Dep/Div | Claims | Sales | SVC |  | Claims | Sales | SVC
7 years, 0 months |  |  |  |  |  |  | 1 | 1 | 1
6 years, 7 months |  |  |  |  |  |  | 1 | 1 | 1
6 years, 5 months | 1 |  |  | 1 |  |  |  |  | 1
6 years, 4 months |  |  |  |  | 1 |  |  | 1 | 1
5 years, 9 months |  |  |  |  |  | 1 |  | 1 | 1
5 years, 8 months |  |  | 1 | 1 |  |  |  |  | 1
5 years, 6 months |  |  |  |  |  |  | 1 | 1 | 1
5 years, 5 months | 1 |  |  | 1 |  |  |  |  | 1
5 years, 11 months |  |  |  |  | 2 |  |  | 2 | 2
5 years, 1 months |  |  | 1 | 1 |  |  |  |  | 1
4 years, 2 months | 1 |  | 1 | 2 |  |  |  |  | 2
4 years, 10 months |  |  | 1 | 1 |  |  |  |  | 1
4 years, 1 months |  |  |  |  |  |  | 1 | 1 | 1
4 years, 0 months |  |  |  |  | 1 |  |  | 1 | 1
3 years, 8 months |  |  | 1 | 1 | 1 |  |  | 1 | 2
3 years, 7 months | 1 |  |  | 1 |  |  |  |  | 1
3 years, 6 months |  |  | 1 | 1 |  |  | 1 | 1 | 2
3 years, 2 months |  |  |  |  | 1 |  |  | 1 | 1
3 years, 11 months |  | 2 |  | 2 |  |  |  |  | 2
3 years, 1 months | 1 |  |  | 1 |  |  |  |  | 1
22 years, 8 months |  | 1 |  | 1 |  |  |  |  | 1
21 years, 9 months | 1 |  |  | 1 |  |  |  |  | 1
2 years, 9 months |  |  |  |  | 1 |  |  | 1 | 1
2 years, 7 months |  |  | 1 | 1 | 1 |  |  | 1 | 2
2 years, 6 months |  | 1 |  | 1 |  | 1 |  | 1 | 2
2 years, 5 months | 1 |  |  | 1 |  |  |  |  | 1
2 years, 4 months | 1 |  |  | 1 | 1 |  | 1 | 2 | 3
2 years, 3 months |  |  |  |  |  |  | 1 | 1 | 1
2 years, 11 months |  |  | 1 | 1 |  |  | 1 | 1 | 2
2 years, 1 months |  |  |  |  | 1 |  |  | 1 | 1
2 years, 0 months |  |  |  |  |  | 1 |  | 1 | 1
14 years, 9 months |  | 1 |  | 1 |  |  |  |  | 1
14 years, 8 months |  |  |  |  |  |  | 1 | 1 | 1
14 years, 4 months |  |  | 1 | 1 |  |  |  |  | 1
10 years, 11 months |  |  | 1 | 1 |  |  |  |  | 1
1 years, 9 months |  |  | 1 | 1 | 1 |  | 3 | 4 | 5
1 years, 8 months |  |  |  |  | 1 |  |  | 1 | 1
1 years, 7 months | 1 |  |  | 1 | 1 |  | 1 | 2 | 3
1 years, 6 months |  |  |  |  |  | 1 |  | 1 | 1
1 years, 3 months |  |  | 1 | 1 |  |  |  |  | 1
1 years, 2 months | 1 |  |  | 1 |  |  |  |  | 1
1 years, 11 months | 1 |  | 1 | 2 | 1 |  |  | 1 | 3
1 years, 1 months |  |  |  |  |  | 1 |  | 1 | 1
1 years, 0 months |  |  | 1 | 1 |  |  | 1 | 1 | 2
0 years, 9 months |  | 2 | 2 | 4 |  |  |  |  | 4
0 years, 8 months |  |  | 1 | 1 |  |  | 1 | 1 | 2
0 years, 7 months |  | 1 | 1 | 2 |  |  |  |  | 2
0 years, 6 months |  |  |  |  |  | 1 | 1 | 2 | 2
0 years, 5 months |  |  | 1 | 1 |  |  |  |  | 1
0 years, 4 months |  |  |  |  |  | 1 |  | 1 | 1
0 years, 3 months | 1 |  | 1 | 2 | 1 | 1 | 3 | 5 | 7
0 years, 2 months | 1 |  |  | 1 |  |  | 1 | 1 | 2
0 years, 11 months | 2 | 1 |  | 3 |  |  |  |  | 3
0 years, 10 months |  |  |  |  | 1 | 1 |  | 2 | 2
0 years, 1 months |  |  |  |  |  | 1 |  | 1 | 1
Grand Total | 15 | 9 | 20 | 44 | 16 | 10 | 20 | 46 | 90
Spreadsheet: 703602d1605081809-monthly-report-using-index-match-sales-report
Sheet: Monthly Sales Report

I'm kindly asking for a Less complicated formula which show the Sales Report by Month so that when I click on cell D5, I select the month and
the report for that month comes out. The current formulas produces report for all months. See my desired outcome below.
 | Sales for Month of: |  | 2020-01-01 00:00:00
 | Date | Customer Code | Customer Name | VAT Number | Invoice | Amount Excl VAT | VAT | Amount Incl VAT | 2020-01-01 00:00:00
 |  |  |  |  | 1 |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  | 2 |  |  |  | 2020-03-01 00:00:00
 |  |  |  |  | 3 |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  | 4 |  |  |  | 2020-05-01 00:00:00
 |  |  |  |  | 5 |  |  |  | 2020-06-01 00:00:00
 |  |  |  |  | 6 |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  | 7 |  |  |  | 2020-08-01 00:00:00
 |  |  |  |  | 8 |  |  |  | 2020-09-01 00:00:00
 |  |  |  |  | 9 |  |  |  | 2020-10-01 00:00:00
 |  |  |  |  | 10 |  |  |  | 2020-11-01 00:00:00
 |  |  |  |  | 11 |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  | 12
 | DESIRED OUTCOME
 | Sales for Month of: |  | 2020-01-01 00:00:00
 | Date | Customer Code | Customer Name | VAT Number | Invoice | Amount Excl VAT | VAT | Amount Incl VAT
 |  |  |  |  | 1
 |  |  |  |  | 2
 |  |  |  |  | 3
Spreadsheet: 204282d1357422857-sorting-and-counting-letters-ef316_letters_needed
Sheet: Sheet1

Total needed: | 5 | 1 | 0 | 3 | 1 | 0 | 0 | 3 | 2 | 0 | 0 | 1 | 0 | 0 | 2 | 2 | 0 | 2 | 1 | 1 | 1 | 1 | 0 | 4 | 3 | 0
Message | A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z
I Love you Dad X | 1 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 1 | 1 | 0
Happy Birthday [NAME] xxx | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 3 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 2 | 1 | 1 | 0 | 0 | 0 | 3 | 2 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: bcfe6127-54c9-4fb3-a256-ec3a6b8856e5
Sheet: Sheet1

Release: Debt to Gross Domestic Product Ratios | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=263
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-09-01 7:51 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Debt to Gross Domestic Product Ratios | 2012-10-26 00:00:00 | Current
Source:
Federal Reserve Bank of St. Louis | 2012-10-26 00:00:00 | Current
The White House: Office of Management and Budget | 2013-03-20 00:00:00 | Current
Notes:
These series are constructed using debt, deficit, and nominal GDP | 2012-10-26 00:00:00 | Current
series.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2012-10-26 00:00:00
2012-11-29 00:00:00
2012-12-06 00:00:00
2012-12-20 00:00:00
2013-01-30 00:00:00
2013-02-28 00:00:00
2013-03-11 00:00:00
2013-03-20 00:00:00
2013-03-28 00:00:00
2013-04-10 00:00:00
2013-04-26 00:00:00
2013-05-30 00:00:00
2013-06-06 00:00:00
2013-06-26 00:00:00
2013-07-31 00:00:00
2013-08-29 00:00:00
2013-09-26 00:00:00
2013-09-27 00:00:00
2013-11-07 00:00:00
2013-12-05 00:00:00
2013-12-20 00:00:00
2014-01-30 00:00:00
2014-02-28 00:00:00
2014-03-14 00:00:00
2014-03-25 00:00:00
2014-03-27 00:00:00
2014-04-30 00:00:00
2014-05-29 00:00:00
2014-06-25 00:00:00
2014-07-30 00:00:00
2014-08-28 00:00:00
Spreadsheet: 542293d1507794855-workflow-how-to-show-this-weeks-tasks-sum-product-pivot-workflow-this-weeks-tasks-full-answer
Sheet:  WK END 14TH OCT

SHOWDATE | ARTIST | TOWN / CITY | VENUE | FACEBOOK TOUR 3 | FACEBOOK TOUR 4 | FACEBOOK INDIVIDUAL 1 | FACEBOOK INDIVIDUAL 2 | FACEBOOK INDIVIDUAL 3 | FACEBOOK INDIVIDUAL 4 | ASK VENUE TO DO MAILSHOT | ASK TICKET OUTLET NEXT MAILER | CUSTOMER EMAILS
2017-10-27 00:00:00 | BAND 398 | ST HELENS | CITADEL | 2017-10-09 00:00:00
2017-10-28 00:00:00 | BAND 400 | BURY | THE MET | 2017-10-09 00:00:00
2017-10-21 00:00:00 | BAND 393 | MANCHESTER | CLUB ACADEMY |  | 2017-10-09 00:00:00
2017-10-27 00:00:00 | BAND 397 | LIVERPOOL | o2 ACADEMY |  | 2017-10-09 00:00:00
2017-11-25 00:00:00 | BAND 422 | PRESTON | GUILD HALL |  |  | 2017-10-09 00:00:00
2017-12-01 00:00:00 | BAND 427 | LIVERPOOL | o2 ACADEMY 2 |  |  | 2017-10-09 00:00:00
2018-03-23 00:00:00 | BAND 454 | EDINBUGH | LIQUID ROOMS |  |  | 2017-10-09 00:00:00
2018-05-12 00:00:00 | BAND 474 | NOTTINGHAM | RESCUE ROOMS |  |  | 2017-10-09 00:00:00
2017-10-21 00:00:00 | BAND 394 | MANCHESTER | ACADEMY 3 |  |  |  | 2017-10-11 00:00:00
2017-11-04 00:00:00 | BAND 403 | BRISTOL | THEKLA |  |  |  | 2017-10-09 00:00:00
2017-11-10 00:00:00 | BAND 404 | LIVERPOOL | o2 ACADEMY 2 |  |  |  | 2017-10-09 00:00:00
2017-11-18 00:00:00 | BAND 416 | LEEDS | BRUDENELL |  |  |  | 2017-10-09 00:00:00
2017-11-24 00:00:00 | BAND 419 | BLACKBURN | KING GEORGES HALL |  |  |  | 2017-10-09 00:00:00
2017-10-21 00:00:00 | BAND 393 | MANCHESTER | CLUB ACADEMY |  |  |  |  | 2017-10-11 00:00:00
2017-10-27 00:00:00 | BAND 397 | LIVERPOOL | o2 ACADEMY |  |  |  |  | 2017-10-11 00:00:00
2017-11-11 00:00:00 | BAND 410 | MANCHESTER | CLUB ACADEMY |  |  |  |  | 2017-10-09 00:00:00
2017-10-28 00:00:00 | BAND 402 | PRESTON | 53 DEGREES |  |  |  |  |  | 2017-10-09 00:00:00
2017-10-27 00:00:00 | BAND 397 | LIVERPOOL | o2 ACADEMY |  |  |  |  |  |  | 2017-10-13 00:00:00
2017-10-27 00:00:00 | BAND 398 | ST HELENS | CITADEL |  |  |  |  |  |  | 2017-10-13 00:00:00
2017-10-28 00:00:00 | BAND 401 | NEWCASTLE | o2 ACADEMY |  |  |  |  |  |  | 2017-10-14 00:00:00
2017-10-27 00:00:00 | BAND 397 | LIVERPOOL | o2 ACADEMY |  |  |  |  |  |  |  | 2017-10-13 00:00:00
2017-10-27 00:00:00 | BAND 398 | ST HELENS | CITADEL |  |  |  |  |  |  |  | 2017-10-13 00:00:00
2017-10-28 00:00:00 | BAND 401 | NEWCASTLE | o2 ACADEMY |  |  |  |  |  |  |  | 2017-10-14 00:00:00
2017-10-28 00:00:00 | BAND 402 | PRESTON | 53 DEGREES |  |  |  |  |  |  |  | 2017-10-14 00:00:00
2017-10-06 00:00:00 | BAND 387 | NEWCASTLE | o2 ACADEMY |  |  |  |  |  |  |  |  | 2017-10-09 00:00:00
2017-10-07 00:00:00 | BAND 388 | SHEFFIELD | GREYSTONES |  |  |  |  |  |  |  |  | 2017-10-10 00:00:00
2017-10-07 00:00:00 | BAND 389 | GLASGOW | o2 ABC |  |  |  |  |  |  |  |  | 2017-10-10 00:00:00
Spreadsheet: 53397d1253280190-how-to-create-signals-for-top-20-stock1
Sheet: Sheet1

 | Time | Open | High | Low | Closing | Volume |  |  | Signal
1999.09.01 | 01:00:00 | 1.0565 | 1.0566 | 1.0559 | 1.0564 | 25
1999.09.01 | 02:00:00 | 1.0563 | 1.0572 | 1.0561 | 1.0571 | 29
1999.09.01 | 03:00:00 | 1.057 | 1.0575 | 1.0565 | 1.0572 | 96
1999.09.01 | 04:00:00 | 1.0575 | 1.0579 | 1.0568 | 1.0571 | 98
1999.09.01 | 05:00:00 | 1.0572 | 1.0574 | 1.0566 | 1.0572 | 105
1999.09.01 | 06:00:00 | 1.0572 | 1.0577 | 1.0569 | 1.0577 | 71
1999.09.01 | 07:00:00 | 1.0572 | 1.0576 | 1.0565 | 1.0571 | 140
1999.09.01 | 08:00:00 | 1.0572 | 1.0581 | 1.0564 | 1.0575 | 233
1999.09.01 | 09:00:00 | 1.0573 | 1.0602 | 1.0562 | 1.0596 | 413 |  |  | top 20%
1999.09.01 | 10:00:00 | 1.0595 | 1.064 | 1.0595 | 1.0634 | 444 |  |  | top 20%
1999.09.01 | 11:00:00 | 1.0639 | 1.064 | 1.061 | 1.062 | 351
1999.09.01 | 12:00:00 | 1.0619 | 1.0632 | 1.0616 | 1.0632 | 96
1999.09.01 | 13:00:00 | 1.0631 | 1.0632 | 1.061 | 1.0618 | 307
1999.09.01 | 14:00:00 | 1.0619 | 1.0629 | 1.0609 | 1.0616 | 415 |  |  | top 20%
1999.09.01 | 15:00:00 | 1.0617 | 1.0619 | 1.0584 | 1.0595 | 333
1999.09.01 | 16:00:00 | 1.0593 | 1.0603 | 1.0588 | 1.0603 | 300
1999.09.01 | 17:00:00 | 1.06 | 1.0615 | 1.0595 | 1.0596 | 417 |  |  | top 20%
1999.09.01 | 18:00:00 | 1.0595 | 1.0596 | 1.0576 | 1.0584 | 375 |  |  | top 20%
1999.09.01 | 19:00:00 | 1.0581 | 1.0591 | 1.057 | 1.0578 | 278
1999.09.01 | 20:00:00 | 1.058 | 1.0598 | 1.0571 | 1.0596 | 277
1999.09.01 | 21:00:00 | 1.0596 | 1.0609 | 1.0592 | 1.0599 | 187
1999.09.01 | 22:00:00 | 1.0592 | 1.0608 | 1.0586 | 1.0586 | 66
1999.09.01 | 23:00:00 | 1.0588 | 1.0594 | 1.0577 | 1.058 | 74
1999.09.01 | 09:00:00 | 1.0573 | 1.0602 | 1.0562 | 1.0596 | 413
1999.09.01 | 14:00:00 | 1.0619 | 1.0629 | 1.0609 | 1.0616 | 415
1999.09.01 | 17:00:00 | 1.06 | 1.0615 | 1.0595 | 1.0596 | 417
1999.09.01 | 10:00:00 | 1.0595 | 1.064 | 1.0595 | 1.0634 | 444
Spreadsheet: 148363d1333375000-how-can-i-shrink-this-vlookup-function-test
Sheet: Sheet2

 |  |  |  |  |  |  |  |  | Margin Based Pricing - 39mo | '[NAME] Sheet'!A72:B77
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 42mo | '[NAME] Sheet'!A72:B77
 | Margin Based Pricing - 42mo |  |  |  |  |  |  |  | Margin Based Pricing - 45mo | '[NAME] Sheet'!A72:B77
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 51mo | '[NAME] Sheet'!A80:B85
 | FORMULA | [NAME] |  |  |  |  |  |  | Margin Based Pricing - 54mo | '[NAME] Sheet'!A80:B85
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 57mo | '[NAME] Sheet'!A80:B85
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 63mo | '[NAME] Sheet'!A88:B93
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 63mo | '[NAME] Sheet'!A88:B93
 |  |  |  |  |  |  |  |  | Margin Based Pricing - 69mo | '[NAME] Sheet'!A88:B93
Spreadsheet: c7202c85-4643-42d3-9211-01b3d0dc3954
Sheet: Tilling scoring results

Participant | Final Rank | Total Points | Entry Points | Forum Points | Performance Points | [NAME]
akki | 1 | 247.8095238095238 | 100 | 25 | 73.80952380952381 | 49
denghui0815 | 2 | 232.9047619047619 | 100 | 25 | 61.9047619047619 | 46
protocolocon | 3 | 195.047619047619 | 100 | 10 | 44.04761904761905 | 41
[NAME] | 4 | 194.8503401360544 | 100 | 25 | 20.85034013605442 | 49
[NAME] | 5 | 189.1360544217687 | 100 | 25 | 15.13605442176871 | 49
Minh-Nhut Hong | 6 | 182.3333333333333 | 100 | 25 | 8.333333333333334 | 49
Valentina Kustikova | 7 | 174.4444444444445 | 100 | 25 | 4.444444444444445 | 45
oshapovalov | 8 | 172.8571428571429 | 100 | 25 | 2.857142857142857 | 45
Vasiliy | 9 | 171.9047619047619 | 100 | 25 | 11.90476190476191 | 35
[NAME] | 10 | 152.956043956044 | 100 | 5 | 3.956043956043956 | 44
[NAME] | 11 | 144.5408163265306 | 100 | 20 | 14.54081632653061 | 10
nuriyasov | 12 | 141.1904761904762 | 100 | 5 | 1.19047619047619 | 35
[NAME] | 13 | 122.5873015873016 | 100 | 0 | 1.587301587301587 | 21
Val | 14 | 121 | 100 | 0 | 0 | 21
iberenger | 15 | 106.469387755102 | 100 | 0 | 3.469387755102041 | 3
Spreadsheet: b441bb7e-ef67-49e0-a304-232f8c454c69
Sheet: Data Valid

Budget |  |  | Inst. - Salaries (0100) |  |  | Equipment (0730)
[NAME] |  |  | Inst. - Employee Benefits (0200) |  |  | Equipment (0735)
Annual Financial Report |  |  | Inst. - Purchased Professional & Technical Services (0300)
 |  |  | Inst. - Other Purchased Services (0500)
Project 1-Year 1 |  |  | Inst. - Travel, Registration and Entrance (0580)
Project 2-Year 1 |  |  | Inst. - Supplies (0600)
Project 3-Year 1 |  |  | Support - Salaries (0100)
Project 4-Year 1 |  |  | Support - Employee Benefits (0200)
Project 5-Year 1 |  |  | Support - Purchased Professional & Technical Services (0300)
Project 1-Year 2 |  |  | Support - Other Purchased Services (0500)
Project 2-Year 2 |  |  | Support - Travel, Registration and Entrance (0580)
Project 3-Year 2 |  |  | Support - Supplies (0600)
Project 4-Year 2
Project 5-Year 2
Project 1-Year 3
Project 2-Year 3
Project 3-Year 3
Project 4-Year 3
Project 5-Year 3
Spreadsheet: 5bf024a1-573a-4ece-94ce-67a07abb9cc7
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
5446 | 15575 | [NAME] | Isom | USA | 0 | 00:23:06 | 00:00:00 | 00:34:49 | 00:00:00 | [NAME] | 1 | 01:29:48
5446 | 39249 | [NAME] | White | USA | 0 | 00:25:10 | 00:00:00 | 00:44:54 | 00:00:00 | 00:33:13 | 2 | 01:43:18
5446 | 39248 | [NAME] | [NAME] | USA | 0 | [NAME] | 00:00:00 | 00:43:55 | 00:00:00 | 00:39:39 | 3 | 01:50:12
5446 | 19237 | [NAME] | Wilkinson | USA | 0 | 00:23:40 | 00:00:00 | 00:46:43 | 00:00:00 | [NAME] | 4 | 01:50:43
Spreadsheet: 474803d1470915482-count-cost-from-one-tab-into-a-table-in-another-tab-test
Sheet: Sheet1

serving time | April | [NAME] | [NAME] | [NAME] | Harley |  | Cost
Breakfast | 10 | {=COUNT(IF((Sheet2!$A$2:$a$5=$B$2)*(Sheet2!$b$2:$b$5=c$2)*(Sheet2!$c$2:$c$5='Summary '!$a3),$A$3:$A$5)) | 0 | 0 | 0 | 1
Lunch |  | 0 | 0 | 0 | 0 | 0
Dinner |  | 0 | 0 | 0 | 0 | 0
Spreadsheet: 141084d1329079873-excel-2007-how-to-grab-information-from-other-sheets-and-place-it-in-the-main-sheet-fulllist
Sheet: Soccer

 |  |  | Soccer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accounts (see 'EventList' Worksheet for Entry Fees)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insert $ pd in appropriate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pymt Method
Event (select from dropdown list) | Team Name | Level of Play | First Name | Last Name | Capt(*) | Sex | Date of Birth | Address | Suburb | State(abbr) | Postcode | Phone # | [NAME] | [NAME] | Golf Club | Squash Grade |  |  | Preferred Day | Time | Rego/Soc | Business Unit | Employee# | T-Shirt Size | Cheque | Cash | Direct Deb | Total |  | Notes