tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 753934d1635846263-how-to-find-text-in-a-cell-kgtraderbook3
Sheet: Sheet1

Trigger Date | Name of Instrument | Ticker Symbol | Market | Sector | Entry Price | Initial Stop Distance | Value Per Pip/Point | Long/Short | Risk Taken | Status | Closing Price | Points +/- | [NAME] | [NAME]. | Profit +/- | Date Closed | Names of Instruments |  | Helper
2021-10-26 00:00:00 | [NAME] | REXR | US Stock | Real Estate | 66.54 | 690 | 0.29 | Long | 0.01
2021-10-18 00:00:00 | [NAME] | REXR | Commodity | N/A | 82.73 | 1204 | 0.17 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-10-15 00:00:00 | Brookfield Asset Management | BAM | US Stock | Financials | 58.25 | 717 | 0.28 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-09-23 00:00:00 | [NAME] | REXR | US Stock | Consumer Discretionary | 50.01 | 684 | 0.29 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-09-23 00:00:00 | [NAME] | REXR | US Stock | Industrials | 212.71 | 2551 | 0.39 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-09-01 00:00:00 | Comcast | CMCSA | US Stock | Communication Services | 60.89 | 517 | 0.39 | Long |  | Closed - Loss | 55.72 | -517 | 0.01 |  | -201.63 | 2021-10-14 00:00:00
2021-08-30 00:00:00 | Brookfield Asset Management | BAM | US Stock | Industrials | 77.11 | 515 | 0.39 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-08-27 00:00:00 | Brookfield Asset Management | BAM | US Stock | Industrials | 176.09 | 1566 | 0.13 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-08-27 00:00:00 | Comcast | CMCSA | US Stock | Consumer Discretionary | 45.58 | 859 | 0.23 | Long |  | RF |  | N/A - Open Position | 0.01 |  | N/A - Open Position
2021-08-25 00:00:00 | [NAME] | REXR | US Stock | Information Technology | 221.02 | 4330 | 0.05 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
2021-08-23 00:00:00 | Comcast | CMCSA | US Stock | Industrials | 284.46 | 3342 | 0.06 | Long | 0.01 |  |  | N/A - Open Position |  |  | N/A - Open Position
Spreadsheet: 164059d1340635364-problem-using-exponential-best-fit-line-x-v-y-graph
Sheet: Sheet1

X | Y
0 | 600
0.05 | 600.02
0.1 | 598.77
0.25 | 590.4
0.5 | 572.63
0.75 | 557.05
1 | 541.15
1.25 | 525.96
1.5 | 513.53
1.75 | 502.22
2 | 492.06
2.25 | 482.85
2.5 | 474.46
2.75 | 467.07
3 | 460.48
3.25 | 454.49
3.5 | 449.03
3.75 | 443.14
4 | 438.75
4.25 | 434.75
4.5 | 430.2
4.75 | 426.12
5 | 422.41
5.25 | 419.02
5.5 | 415.91
5.75 | 413.07
6 | 410.47
6.25 | 408.09
6.5 | 406.72
6.75 | 405.43
7 | 404.21
7.5 | 400.14
8 | 398.4
8.5 | 396.81
9 | 393.8
9.5 | 391.26
10 | 389
11 | 383.56
 | 379.75
 | 376.57
 | 373.85
 | 371.45
 | 371.87
 | 371.46
 | 370.54
 | 369.3
 | 367.28
 | 363.87
 | 363.09
 | 361.94
 | 358.3
 | 355.44
 | 353.16
 | 351.4
 | 350.12
 | 348.95
 | 347.88
 | 346.87
 | 348.02
 | 348.42
 | 348.35
 | 345.95
 | 346.18
 | 346.03
 | 343.65
 | 341.88
 | 340.51
 | 339.4
 | 338.46
 | 337.64
 | 336.9
 | 336.21
 | 337.47
 | 338.05
 | 338.22
 | 336.27
 | 336.7
 | 336.79
 | 334.84
 | 333.42
 | 332.28
 | 331.33
 | 330.51
 | 329.8
 | 329.17
 | 328.59
 | 329.82
 | 330.55
 | 330.92
 | 329.33
 | 329.83
 | 330.06
 | 328.39
 | 327.12
 | 326.13
 | 325.34
 | 324.69
 | 324.14
 | 323.67
Spreadsheet: 828883d1683781943-extract-dates-for-text-text-to-date-ans-1-
Sheet: Sheet1

My Sample | Extrate Date
5_7_23_0031b1
5_7_23_0031bo1
5_7_23_0031h1
5_8_23_0031b1
5_8_23_0031bo1
5_8_23_0031h1
18_10_22_0021b1
18_10_22_0021b01
18_10_22_0021h1
Spreadsheet: 29c9df60-f35c-4e07-87bc-ef8db91ba997
Sheet: Sheet1

Table KS05 Country of Birth | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Key Statistics for Birmingham 2006 Districts and 2004 Wards.*
Key Statistics provide headline results about the main Census topics and facilitate comparisons between different areas.
The dataset contains around 380 statistics for each area.  The districts are those in place at 23rd May 2006.
*Best Fit Approximations issued by the Office for National Statistics in December 2004
Results for new wards are based on allocation of whole Census Output Areas.
Data for any Census Output Area that is split by a new ward boundary are allocated to the ward that contains the greatest
share of its population.
For reasons of confidentiality, National Statistics have altered the published results where very small numbers of people in an area fall into any of the categories in a table  (e.g. persons in a Birmingham ward working in the fishing industry). This means that:
- Population and household totals may vary among tables
- Published figures for a larger area may not match the sum of results for its smaller constituent parts.
For more census results please visit our website: |  |  | www.birmingham.gov.uk/community |  |  |  | or visit
www.statistics.gov.uk/neighbourhood
Copyright and Conditions of Use
The material presented is derived from the 2001 Census Area Statistics.  All census material is Crown Copyright.  Birmingham Council has a 'click user licence' issued by Her [NAME]'s Stationary Office.  This allows the re-use and publication of Census data.
 | Persons and organisations outside the City Council should check whether they need to obtain a licence to use and publish the data.  More information can be obtained from the national census website or from her [NAME]'s Stationary Office (HMSO):
http:/www.hmso.gov.uk/click-use-home.htm                                                                                                                                     HMSO,The Licensing Division, St Clements House,                                                                                                                                        2 to 16 Colegate, [NAME], NRS 1BQ(tel 01603 621000)
2001 Census Statistics incorporate measures to protect against the inadvertent disclosure of information relating specifically to an identified person or household.  The material should not be used to attempt to derive information relating specifically to an identified person or household nor should a claim be made that such information has been obtained or derived.
 |  |  |  |  | Development Directorate Demographic Information Service
Source: 2001 Census, [Key Statistics for Local Authorities].  Crown
copyright 2005. Crown copyright material is reproduced with the
permission of the [NAME] of HMSO .
Spreadsheet: d46de8e5-2bd6-4970-b20e-2ebf9917fd42
Sheet: Sheet1

COLORADO DIVISION OF HOUSING  *  HOUSING PROGRAMS SPREADSHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | COLORADO DIVISION OF HOUSING  *  HOUSING DEVELOPMENT ANALYSIS SPREADSHEET
 |  |  |  |  | Spreadsheet directions are to the right ----->
Program Name: |  |  |  |  |  |  |  |  |  |  | <-- [NAME] is to the left
Date:
Applicant: |  |  |  |  |  |  |  |  |  |  | PROGRAM BUDGET - INSTRUCTIONS
Spreadsheet Version: |  |  |  |  |  |  |  |  |  |  | ● This Program Budget is intended for use for Down Payment Assistance Programs.
Down Payment Assistance Program Budget |  |  |  |  |  |  |  |  |  |  | ● Fill in the amount of "State Funds Requested" on the appropriate row in column C, and "Other Funds" in column D.  Use column E to
 |  |  |  |  |  |  |  |  |  |  | name the other sources.  If more than one source will be applied to one prorgam activity, then insert a row or rows.  Make sure that for
Program Activities | Total Program Cost | State Funds Requested | Other Funds | Source | Status |  |  |  |  |  | each activity, all of the sources add up to that activity's total cost (column B).
Down Payment Assistance Loans  (Expected Production of X Units) |  |  | 0
1st Mortgages (estimated) |  |  | 0 |  |  |  |  |  |  |  | ● In column F, please indicate the status of those other funding sources as either "pending" or "committed."
Closing Costs |  |  | 0
Home Buyer Counseling |  |  | 0 |  |  |  |  |  |  |  | ● Cell B35 will help you to check your work - it should equal Cell B34.
Project Administration
Salaries, Wages, Benefits and other Compensation;
● DPA Loan Specialist |  |  | 0
● Accounting Staff |  |  | 0
● Other Staff – |  |  | 0
● Other Staff – |  |  | 0
Training and Travel |  |  | 0
Program Administration
Salaries, Wages, Benefits and other Compensation;
● Executive Director |  |  | 0
● Accountant |  |  | 0
● Other Staff – |  |  | 0
● Other Staff – |  |  | 0
Operating Expenses (i.e. rent, utilities) |  |  | 0
Equipment, materials and supplies |  |  | 0
Taxes and Insurance |  |  | 0
Communication Cost |  |  | 0
Audit Cost |  |  | 0
Legal Cost |  |  | 0
Totals | 0 | 0 | 0
 | 0
Spreadsheet: 114845d1310553018-count-totals-by-week-and-month-from-separate-worksheet-big-pnl-sample
Sheet: Monthly S&T

 | CASH | CARDS | UNSETTLED | VVIP | VVIP OCUS | CLOAKROOM | TICKETS | ENTs | TOTAL | NET | TARGET | DIFFERENCE
FEB '11 | 333808 |  | 27634 | 17608 | 45068 |  |  |  |  |  | 1000000
MAR '11
APR '11
MAY '11
JUN '11
JUL '11
AUG '11
SEPT '11
OCT '11
NOV '11
DEC '11
JAN '12
TOTALS TYPE
Spreadsheet: 688509d1595835429-dynamic-range-for-lookup-function-for-forum
Sheet: Sheet3

 | Date1 | [NAME] | data2
 | 2020-01-01 00:00:00 | 23 | 33
 |  | 24 | 34
 |  | 25 | 35
 |  | 26 | 36
 |  | 27 | 37
 |  | 28 | 38
 | Conditions
 | Data2 from date2 -2 (2 days prior), if empty, to take the last available data
 | Date2 | data2
 | 2020-01-03 00:00:00
 | 2020-01-04 00:00:00
 | 2020-01-05 00:00:00
 | 2020-01-06 00:00:00
 | 2020-01-07 00:00:00
 | 2020-01-08 00:00:00
 | 2020-01-09 00:00:00
Spreadsheet: 163203d1340220730-matching-values-in-a-table-with-larger-list-of-numbers-and-names-example
Sheet: Sheet2

[NAME] | Project Name
2600047902 | A
2600049291 | B
2600055759 | C
2600059185 | D
3000408917 | E
3001290369 | F
3001387113 | G
3001388391 | H
3001662435 | I
3001662436 | J
3001731053 | K
3002067631 | L
3002109086 | M
3002209337 | N
3002460227 | O
3002518279 | P
3002552154 | Q
3002633807 | R
3002647833 | S
3002650670 | T
3002678532 | U
3002683413 | V
3002695904 | W
3002714139 | X
3002714749 | Y
3002757102 | Z
3002757619 | AA
3002762626 | BB
3002776912 | CC
3002805537 | DD
3002820697 | EE
3002823149 | FF
3002844378 | GG
3002849306 | HH
3002906303 | II
3002912643 | JJ
3002941321 | KK
3002969600 | LL
3003002806 | NN
3003010587 | OO
3003011794 | PP
3003014684 | QQ
3003016319 | RR
3003027084 | SS
3003027281 | TT
3003027549 | UU
3003028174 | VV
3003049391 | WW
3003049769 | XX
3003065586 | ZZ
3003065671 | ZZZ
3003071735 | AAA
3003072053 | BBB
3003073016 | CCC
3003091206 | DDD
3003093577 | EEE
3003104984 | FFF
3003105826 | GGG
3003106880 | HHH
Spreadsheet: 82f53e9e-fcfb-45e3-8624-a26869de5921
Sheet: K-3

 | STAR Tutoring Form 2013-2014
 | K-3 Order Form
 | Mondo Publishing
 | [NAME] |  |  | [NAME]
 | [EMAIL] |  |  | [EMAIL]
 | Cell: (801) 913-0973 |  |  | Cell: (801) 573-4281
 | Fax: (801) 878-9949 |  |  | Fax: (801) 878-9949
 | www.benchmarkeducation.com |  |  | www.benchmarkeducation.com
[NAME]
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
60-38X | [NAME], Bookshop series | A-K | 70 | 54-59 | 295
60-398 | Grade 1 Classroom Library, Bookshop series | A-M | 73 | 60-65 | 370
60-401 | [NAME], Bookshop series | E-P | 70 | 66-70 | 400
60-41X | Grade 3 Classroom Library, Bookshop series | J-S | 50 | 71-73 | 290
Reading [NAME], Real-Life Reading
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
33-479 | [NAME] add-on pack | A-E | 35 | 106-107 | 159
35-153 | Grade K Magazine Add-on Pack | A-E | 15 | 106-107 | 89
35-161 | Grade K Little Book Add-on Pack | A-E | 15 | 106-107 | 46
35-17X | Grade K Encyclofact Add-on Pack | A-E | 5 | 106-107 | 24.5
33-487 | Grade 1 add-on pack | B-J | 63 | 108-109 | 318
35-188 | Grade 1 Magazine Add-on Pack | B-J | 27 | 108-109 | 167
35-196 | Grade 1 Little Book Add-on Pack | B-J | 27 | 108-109 | 105
35-20X | Grade 1 Encyclofact Add-on Pack | B-J | 9 | 108-109 | 47
37-296 | [NAME] add-on pack | F-O | 56 | 110-111 | 319
37-687 | Grade 2 Magazine Add-on Pack | F-O | 24 | 110-111 | 159
37-709 | Grade 2 Little Book Add-on Pack | F-O | 24 | 110-111 | 119
37-695 | Grade 2 Encyclofact Add-on Pack | F-O | 8 | 110-111 | 45
37-318 | Grade 3 Encyclofact Add-on Pack | J-R | 49 | 112-113 | 295
37-776 | Grade 3 Encyclofact Add-on Pack | J-R | 21 | 112-113 | 149
37-792 | Grade 3 Encyclofact Add-on Pack | J-R | 21 | 112-113 | 115
37-784 | Grade 3 Encyclofact Add-on Pack | J-R | 7 | 112-113 | 42
Persuasive and Argument Texts
ISBN Number | Description | Level | Book Quantity | Catalog Page | Price | Quantity | Total Price
40-442 | Should We Have Pets? | K | 1 | 116-117 | 6.5
58-172 | Should There be [NAME]? | N | 1 | 116-117 | 6.5
63-389 | Should Kids Play Video Games? | P | 1 | 116-117 | 6.5
 |  |  |  |  | Total
 |  |  |  |  | FREE S & H |  | FREE
 |  |  |  |  | Grand Total
Choose from the following options to order: |  |  | BILL TO:
1. Fax order to [PHONE] |  |  | Name
2. Call Customer Service 1-886-6636 |  |  | District/School
3. Mail order to: |  |  | Address
Mondo Publishing |  |  | City/State/Zip
980 Avenue of the Americas |  |  | Phone  (       )
New York, NY  10018 |  |  | Fax (        )
 |  |  | P.O.#
Payment Method: |  |  | SHIP TO: (if different)
O   Check/Money Order Enclosed |  |  | Name
O   Visa | O   MasterCard |  | District/School
Card Number |  |  | Address
Expiration Date |  |  | City/State/Zip
Signature |  |  | Phone  (       )
 |  |  | Fax (        )
 |  |  | E-mail
Spreadsheet: john_forney__15513__SCHED2001
Sheet: OCT'01

 |  |  |  |  |  |  |  |  |  | 24 HOUR SCHEDULE
 |  |  |  |  |  |  |  |  |  |  |  | OCTOBER
NAME | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUES | WED
ERCOT | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] |  |  | D | D |  |  |  | N | N | N |  |  | D | D | D |  |  |  | D | D | D |  |  |  | N | N |  |  | N | N | N
ALEX McELREATH |  |  | N | N |  |  |  | D | D | D |  |  |  | N | N |  |  |  | N | N | N |  |  |  | D | D | D |  |  | D | D
JOHN FORNEY | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
[NAME] | D | D |  |  | N | N | N |  |  |  | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  | N | N
[NAME] | N | N |  |  | D | D | D |  |  |  | N | N | N |  |  | D | D | D |  |  |  | N | N | N |  |  |  | D | D
[NAME]
NEW HIRE
SOUTHEAST
[NAME] | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
MIGUEL GARCIA | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
MAURICIO TREJO |  |  | D | D |  |  |  |  | N | N | N | N |  |  |  | D | D | D |  |  |  | N | N | N | N |  |  |  | D | D | D
[NAME] | N | N |  |  | D | D | D |  |  |  |  | N | N | N | N |  |  |  |  | D | D | D |  |  | N | N | N | N
BRANT REVES |  |  | N | N | N |  |  | D | D | D |  |  | N | N | N | N |  |  |  | D | D | D |  |  |  |  |  | N | N | N | N
[NAME] | D | D |  |  |  | N | N | N | N |  |  |  | D | D | D | D |  |  |  | N | N | N | N |  |  |  |  | D | D | D
[NAME] |  |  |  | D | D | D | D |  |  | N | N | N | N |  |  |  | D | D | D | D |  |  |  | N | N | N | N |  |  |  | D
MIDWEST
[NAME] | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D |  |  |  |  | D | D | D | D | D |  |  | D | D | D
DEAN LAURENT | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D |  | V |  |  | V | D | D
[NAME] | N | N | N |  |  |  |  | N | N | N |  |  |  |  |  | N | N | N | N |  |  |  | N | N | N | N |  |  |  | N | N
ANDREW GREER |  |  | N | N | N | N |  |  |  | D | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D |  |  |  |  | N | N
PUNIT RAWAL | N | N |  |  | D | D | D |  |  |  |  |  |  | N | N | N | N |  |  |  | D | D | D |  |  | N | N | N | N
CARRIE LARKWORTHY | D |  |  | N | N | N | N |  |  |  | D | D | D |  |  |  |  | N | N | N | N |  |  | D | D | D | D |  |  | N | N
PAUL SCHIAVONE |  |  | D | D | D | D |  |  | N | N | N |  |  | D | D | D | D |  |  |  | N | N | N |  |  |  | D | D | D
E-SERVICES
[NAME] | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D | D | D |  |  | D | D | D
NIGHTS
DAYS
Spreadsheet: 839749d1692196646-rearrange-the-order-of-columns-of-a-block-by-the-value-of-a-certain-cell-column-rearrangement
Sheet: Munka1

 | me | you | he | she | it | us | them
Mon | 2 | 1 | 3 | 7 | 3 | 9 | 3 | Given daily score by office
Tue | 2 | 1 | 3 | 7 | 4 | 9 | 5
Wed | 1 | 4 | 3 | 7 | 6 | 8 | 6
Thur | 4 | 8 | 6 | 8 | 5 | 3 | 9 |  |  | The result on the weekend of each individual is the sum of the daily scores in row 9.
Fri | 3 | 7 | 8 | 2 | 5 | 4 | 10
Sut | 9 | 10 | 6 | 10 | 2 | 6 | 10
Sun | 8 | 6 | 7 | 2 | 10 | 2 | 6
 |  |  |  |  |  |  |  | Weekend result
 |  |  |  |  |  |  |  | Name
Mon
Tue
Wed
Thur |  |  |  |  |  |  |  |  |  | According the result of the weely scores to the block B1:H9 should be rearranged column by column to B11:H19 in in rising order of B9:H9
Fri
Sut
Sun
 |  |  |  |  |  |  |  | Results
Spreadsheet: 155722d1337017160-look-up-one-item-and-return-a-list-of-values-with-constraints-book2
Sheet: Sheet1

A | B
item 11 | 1 |  |  | item 11
item 12 | 2 |  |  | item 12
item 13 | 3 |  |  | item 13
item 11 | 4 |  |  | item 14
item 14 | 5 |  |  | item 15
item 15 | 6 |  |  | item 16
item 16 | 7 |  |  | item 17
item 11 | 8 |  |  | item 18
item 17 | 9
item 18 | 10
Spreadsheet: 184311d1349207144-usage-in-advanced-filter-test-17-
Sheet: Blad1

 |  | <>*Lidl* | <>*C1000* | <>*Albert*
Datum | Type | Omsc | Bed
 | [NAME] | ING | 10
 | Betaal | C1000 | 10
 | [NAME] | ING | 10
 | Betaal | [NAME] | 10
 | Betaal | Praxis | 10
 | Betaal | Lidl | 10
 | [NAME] | [NAME] | 10
 | Betaal | Praxis | 10
 | Betaal | Gamma | 10
Spreadsheet: 700426d1603192700-formula-to-automatically-sum-all-the-figures-in-cell-b-when-cell-a-has-the-same-data-excel-help
Sheet: Sheet1

NEWCASTLE2020-10-131 | 0.2101922705468248 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.1102376496655036 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.03367438691858807 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.2471701915607549 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.1818181818181818 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.06896551724137931 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.01122258662539968 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.01111575269101361 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.004924317585780636 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.009769552368228686 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.03333333333333333 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.01649524011053272 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.04347826086956522 | 0.9836892878425901
NEWCASTLE2020-10-131 | 0.001292046507503708 | 0.9836892878425901
NEWCASTLE2020-10-132 | 0.3368498922156192 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.06896551724137931 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.03929278140945117 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.1246021082342615 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.1084503309447775 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.1550573868179406 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.04853595090805979 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.02352402058999926 | 0.9886113216948218
NEWCASTLE2020-10-132 | 0.08333333333333333 | 0.9886113216948218
NEWCASTLE2020-10-133 | 0.1 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.3597122302158274 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.133655229269878 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.01176470588235294 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.09090909090909091 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.2002294542024862 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.02941176470588235 | 0.9918940487639563
NEWCASTLE2020-10-133 | 0.06621157357843853 | 0.9918940487639563
NEWCASTLE2020-10-134 | 0.1072150180652599 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.2439024390243903 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.319735380920877 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.03561505160792357 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.1 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.07407407407407407 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.007754355992958065 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.007077217322457448 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.06399243942519357 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.002036366972153049 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.007299368895608677 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.025 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.00320488925123167 | 1.002957726576608
NEWCASTLE2020-10-134 | 0.006051125024480642
Spreadsheet: 175253d1345471351-vlookup-multiple-conditions-rt-test
Sheet: Sheet1

2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00
 | 2012-09-30 00:00:00 | 2012-09-30 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00
IA 1 |  | 11:45:00 | 11:45:00 | 11:45:00 | 11:45:00 | 11:45:00
IA 2 |  | 10:30:00 | 10:30:00 | 10:30:00 | 10:30:00 | 10:30:00
IA 3 |  | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00 | 09:00:00
IA 4 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 5 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 6 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
OA 1
OA 2
OA 3
SA 1 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
SA 2 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
M1
M2
2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00 | 2012-10-07 00:00:00
 | 2012-10-01 00:00:00 | 2012-10-01 00:00:00 | 2012-10-02 00:00:00 | 2012-10-03 00:00:00 | 2012-10-04 00:00:00 | 2012-10-05 00:00:00 | 2012-10-06 00:00:00
IA 1 |  | 08:00:00 | 11:45:00 | 08:00:00 | 11:45:00 | 09:00:00
IA 2 |  | 11:45:00 | 08:00:00 | 10:30:00 | 10:30:00 | 08:00:00
IA 3 |  | 09:00:00 | 09:00:00 | 11:45:00 | 11:45:00 | 11:45:00
IA 4 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 5 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
IA 6 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
OA 1
OA 2
OA 3
SA 1 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
SA 2 |  | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00 | 08:00:00
M1
M2
Spreadsheet: 77111d1277554509-formula-calculation-based-on-yes-no-list-quote_analyser-1-
Sheet: Overview

Week Commening | # of Jobs Quoted | Jobs Quoted Value | Average Value/Job | # of Jobs Attained | Jobs Attained Value | Average Value/Job | # of Jobs Success Rate | Job Value Success Rate
2010-06-28 00:00:00
2010-07-05 00:00:00
2010-07-12 00:00:00
2010-07-19 00:00:00
2010-07-26 00:00:00
2010-08-02 00:00:00
2010-08-09 00:00:00
2010-08-16 00:00:00
2010-08-23 00:00:00
2010-08-30 00:00:00
2010-09-06 00:00:00
2010-09-13 00:00:00
2010-09-20 00:00:00
2010-09-27 00:00:00
2010-10-04 00:00:00
2010-10-11 00:00:00
2010-10-18 00:00:00
2010-10-25 00:00:00
2010-11-01 00:00:00