tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: phillip_m_love__31138__aaaCredit Report
Sheet: Sheet1

DEAL ORIGINATION REPORT
Deals Input on 10/30/01
PENDING CREDIT ITEMS
Counterparty | Deal Number | Deal Type | Comm | Contact/Action Needed
Growmark Inc. | YF6302.1 | F | C3GC | Credit Previously Provided
The Paralan Company | YF3603.1 YF3593.1 YF3586.1 | P | NG | Credit in the confirm--Letter of Credit required
REBOOK ITEMS
Counterparty | Deal Number | Deal Type | Comm | Rebook To--
BP Amoco Chemical Company | YF5594.1 | F | NG | BP Corporation North America Inc.
Tractebel, Inc. | YF5049.1 | F | NG | Tractebel Energy Marketing, Inc.
Spreadsheet: 97952d1297061760-multilookup-alongwith-sorting-for-only-months-plus-clubbing-like-data-multilookup-sort-clubbing
Sheet: V

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED
1 | [NAME] | 801848411 | 2003-01-14 00:00:00 | 48-25-15 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000
2 | [NAME] | 801141846 | 2004-06-28 00:00:00 | 14-30-30 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
3 | [NAME] | 801141848 | 2004-06-28 00:00:00 | 14-31-31 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
4 | [NAME] | 801141849 | 2004-06-28 00:00:00 | 14-32-32 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
5 | [NAME] | 801448161 | 2005-02-15 00:00:00 | 169-22-22 | [NAME] | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000
6 | [NAME] | 801448164 | 2005-02-15 00:00:00 | 14-32-32 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
7 | [NAME] | 801448165 | 2005-02-15 00:00:00 | 14-33-33 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
8 | [NAME] | 801448166 | 2005-02-15 00:00:00 | 14-34-34 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
9 | [NAME] | 801644144 | 2005-07-20 00:00:00 | 150-30-30 | [NAME] | NEW BIMA KIRAN | Insurance | 300000
10 | [NAME] | 801644146 | 2005-07-20 00:00:00 | 14-35-35 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000
11 | [NAME] | 801464814 | 2006-06-21 00:00:00 | 173-70-70 | [NAME] | JEEVAN PLUS | ULIP+Risk | 50000
12 | [NAME] | 801464815 | 2006-06-21 00:00:00 | 172-21-21 | [NAME] | FUTURE PLUS | ULIP | 50000
13 | [NAME] | 801468180 | 2006-08-21 00:00:00 | 181-10-10 | SGL | MARKET PLUS | ULIP | 0
14 | [NAME] | 801181888 | 2008-06-27 00:00:00 | 165-35-35 | ECS | JEEVAN SARAL | Insurance | 250000
Spreadsheet: 863302d1710846086-conditional-formatting-help-needed-conditional-formating-_etaf
Sheet: Sheet1

 |  | A | B | C | A | A | F | G |  | A
 | #01-001 | 1157 | 1046 | 1568 | 1332 | 1318 | 1384 | 1220 |  | #01-001 | *How do I Conditional Formating such if b2:b10=K2 and C1:I1[NAME], then it will highlight Yellow???
 | #01-002 | 1407 | 1729 | 1149 | 1568 | 1686 | 1797 | 1832
 | #01-003 | 1227 | 1452 | 1531 | 1561 | 1421 | 1759 | 1241
 | #01-004 | 1014 | 1742 | 1740 | 1506 | 1627 | 1322 | 1002
 | #01-001 | 1183 | 1973 | 1546 | 1057 | 1445 | 1465 | 1312
 | #01-001 | 1371 | 1956 | 1328 | 1811 | 1915 | 1635 | 1231
 | #01-001 | 1762 | 1683 | 1831 | 1651 | 1690 | 1430 | 1430
 | #01-003 | 1191 | 1603 | 1400 | 1433 | 1369 | 1248 | 1775
 | #01-004 | 1931 | 1438 | 1898 | 1464 | 1793 | 1338 | 1572
 |  | A | B | C | A | A | F | G
 | #01-001 | 1157 | 1046 | 1568 | 1332 | 1318 | 1384 | 1220
 | #01-002 | 1407 | 1729 | 1149 | 1568 | 1686 | 1797 | 1832
 | #01-003 | 1227 | 1452 | 1531 | 1561 | 1421 | 1759 | 1241
 | #01-004 | 1014 | 1742 | 1740 | 1506 | 1627 | 1322 | 1002
 | #01-001 | 1183 | 1973 | 1546 | 1057 | 1445 | 1465 | 1312
 | #01-001 | 1371 | 1956 | 1328 | 1811 | 1915 | 1635 | 1231
 | #01-001 | 1762 | 1683 | 1831 | 1651 | 1690 | 1430 | 1430
 | #01-003 | 1191 | 1603 | 1400 | 1433 | 1369 | 1248 | 1775
 | #01-004 | 1931 | 1438 | 1898 | 1464 | 1793 | 1338 | 1572
Spreadsheet: 859954d1708180538-xlookup-maybe-nested-indirect-and-excel-tables-to-get-value-sample-for-xlookup-indirect
Sheet: Main Sheet

Project | Column1 | Date |  | Project A Tasks | Date |  | Project B Tasks | Date
Project A | Task 1 | Looking to use XLOOKUP and possibly INDIRECT to match Project A Task 1 to return the date.  In this case the value should be 5 Jan 24 |  | Task 1 | 2024-01-05 00:00:00 |  | Task 4 | 2023-12-12 00:00:00
Project A | Task 2 |  |  | Task 2 | 2024-01-20 00:00:00 |  | Task 5 | 2024-01-15 00:00:00
Project A | Task 3 |  |  | Task 3 | 2024-03-30 00:00:00 |  | Task 6 | 2024-02-28 00:00:00
Project B | Task 4
Project B | Task 5 |  |  | Table on "Proj A sheet" |  |  | Table on "Proj B sheet"
Project B | Task 6
Table on main sheet |  | Values above should be:
 | C2 | 2024-01-05 00:00:00
 | [NAME] | 2024-01-20 00:00:00
 | C4 | 2024-03-30 00:00:00
 | C5 | 2023-12-12 00:00:00
 | C6 | 2024-01-15 00:00:00
 | C7 | 2024-02-28 00:00:00
Spreadsheet: 28232d1222256850-creating-a-pivot-table-using-macro-book2
Sheet: Sheet1

CLIENT | PERSON | MONTH | HOURS | COST
CLIENT A | PERSON A | 2008-09-01 00:00:00 | 0.5 | 7
CLIENT A | PERSON B | 2008-02-01 00:00:00 | 0.5 | 16.5
CLIENT A | PERSON B | 2008-03-01 00:00:00 | 0.5 | 16.5
CLIENT A | PERSON C | 2008-03-01 00:00:00 | 1 | 17
CLIENT A | PERSON D | 2008-03-01 00:00:00 | 1.25 | 18.75
CLIENT A | PERSON E | 2008-02-01 00:00:00 | 1 | 22
CLIENT A | PERSON F | 2008-01-01 00:00:00 | 2 | 26
CLIENT B | PERSON E | 2008-03-01 00:00:00 | 3 | 66
CLIENT B | PERSON E | 2008-05-01 00:00:00 | 3 | 66
CLIENT B | [NAME] | 2008-03-01 00:00:00 | 4 | 80
CLIENT B | PERSON B | 2008-01-01 00:00:00 | 2.5 | 82.5
CLIENT B | PERSON E | 2008-04-01 00:00:00 | 4 | 88
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 216409 | 214564 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 212420 | 214971 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 221572 | 222370 |  | 4477 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 219273 | 224915 |  | 1276 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 185522 | 183474 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 164874 | 182838 |  | 21037 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 170513 | 212981 |  | 46832 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 208241 | 215303 |  | 11936 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 244312 | 252585 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 239584 | 236368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 237058 | 239663 |  | 6248 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 211948 | 213917 |  | 4672 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 217410 | 213983 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 233108 | 238826 |  | 7833
15 | 189384 | 215345 |  | 26468 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 151173 | 189752 |  | 39013 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 129417 | 185365 |  | 52368 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 205779 | 212053 |  | 1879
19 | 191216 | 208174 |  | 7701
20 | 153438 | 202373 |  | 26809
21 | 186072 | 209859 |  | 14484
22 | 160654 | 217616 |  | 47947
23 | 148501 | 189529 |  | 38025
24 | 141423 | 186433 |  | 57326
25
26
27
28
29
30
31
 | 2001-05-31 00:00:00 |  |  |  | -386
 | 2001-06-24 00:00:00
Spreadsheet: 582976d1532128314-need-help-with-multiple-conditions-from-multiple-ranges-on-multiple-sheets-new-salary-metric-and-comparison-chart-2018-0719-forum-version
Sheet: Alpha List of All Staff - 2018-

Rec# | Last Name | First Name | Class Code | Range | Monthly Rate | Years Experience in Position | Qualified Tier | Related Experience | Lower Class Experience | Modifier | Tier 1 Modified Salary | [NAME] | Tier 3 Modified Salary | Tier 4 Modified Salary | Projected Salary | Difference | Original Hire Date | Job Entry Date | Grade Entry Date
0 | Name | Name |  |  | 2869
2 | Name | Name |  |  | 3401
0 | Name | Name |  |  | 3642 |  |  | True
0 | Name | Name |  |  | 4700
2 | Name | Name |  |  | 4131
4 | Name | Name |  |  | 4094
Spreadsheet: 297713d1392550902-quarterly-bonuses-incentive-book1
Sheet: Sheet1

 |  |  | Target | Act |  | Target | Act |  | Target | Act
Name | Bonus | % Average | Jan | Jan | % Ach | Feb | Feb | % Ach | Mar | Mar | % Ach
[NAME] |  |  | 10 | 10 |  | 12 | 12 |  | 14 | 14
[NAME] | 0 |  | 10 | 14 |  | 12 | 14 |  | 14 | 10
Crist |  |  | 10 | 11 |  | 12 | 14 |  | 14 | 16
[NAME] |  |  | 10 | 12 |  | 12 | 14 |  | 14 | 18
Spreadsheet: 4e92eaa8-7b27-458d-9b84-a267ceaa05b6
Sheet: Sheet1

Release: Chicago Fed National Activity Index | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=219
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-08-28 8:25 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Chicago Fed National Activity Index | 2011-05-23 00:00:00 | Current
Link:
http://www.chicagofed.org/webpages/publications/cfnai/index.cfm | 2011-05-23 00:00:00 | Current
Source:
Federal Reserve Bank of Chicago | 2011-05-23 00:00:00 | Current
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:
2011-05-23 00:00:00
2011-06-23 00:00:00
2011-07-25 00:00:00
2011-08-22 00:00:00
2011-09-26 00:00:00
2011-10-24 00:00:00
2011-11-21 00:00:00
2011-12-22 00:00:00
2012-01-26 00:00:00
2012-02-21 00:00:00
2012-03-26 00:00:00
2012-04-26 00:00:00
2012-05-21 00:00:00
2012-06-25 00:00:00
2012-07-23 00:00:00
2012-08-20 00:00:00
2012-09-24 00:00:00
2012-10-25 00:00:00
2012-11-26 00:00:00
2012-12-21 00:00:00
2013-01-22 00:00:00
2013-02-25 00:00:00
2013-03-25 00:00:00
2013-04-22 00:00:00
2013-05-20 00:00:00
2013-06-24 00:00:00
2013-07-22 00:00:00
2013-08-20 00:00:00
2013-09-23 00:00:00
2013-11-12 00:00:00
2013-11-27 00:00:00
2013-12-23 00:00:00
2014-01-23 00:00:00
2014-02-24 00:00:00
2014-03-24 00:00:00
2014-04-21 00:00:00
2014-05-22 00:00:00
2014-06-23 00:00:00
2014-07-21 00:00:00
2014-08-25 00:00:00
Spreadsheet: 122018d1316554458-list-content-from-row-in-columns-if-different-from-0-book3
Sheet: Sheet2

months with errors
some month 1
some month 7
some month 8
some month 9
some month 13
some month 14
some month 15
some month 16
some month 17
some month 18
some month 19
some month 20
some month 22
some month 24
some month 25
some month 26
some month 27
some month 28
some month 29
some month 30
some month 31
some month 32
some month 33
some month 34
some month 35
some month 36
some month 46
some month 47
some month 48
some month 49
some month 51
some month 53
some month 55
some month 60
some month 61
some month 65
some month 67
some month 71
some month 72
Spreadsheet: 194422d1353164865-count-unique-text-string-pre-authorization
Sheet: Dash Board Report

MIN | AREA | Dental Cases | Optical Cases | Out-Patient Cases | In-Patient Cases | Maternity Cases | Other Cases
> 40 | RED |  |  |  |  |  |  | 00:40:00
30-40 | ORANGE |  |  |  |  |  |  | 00:30:00
20-29 | GREEN |  |  |  |  |  |  | 00:29:00
< 20 | BLUE |  |  |  |  |  |  | 00:20:00
Total |  |  |  |  |  |  |  | 00:19:00
Spreadsheet: 583911d1532736308-how-to-match-one-sheet-column-data-with-another-sheet-copy-of-workbook-2-step01-
Sheet: MATCH 

NO | date | ID | item | A001 | A002 | A003 | A004 | A005 | A006
1 |  | 1001001
2 |  | 1001002 |  | X |  |  |  | X
3 |  | 1001003
4 |  | 1001004 |  |  | X
5 |  | 1001005 |  | X |  | X |  | X
6 |  | 1001006
7 |  | 1001007 |  |  |  | X
8 |  | 1001008 |  | X |  |  |  | X
9 |  | 1001009
10 |  | 1001010 |  | X |  |  | X | X
11 |  | 1001011
12 |  | 1001012 |  |  | X
13 |  | 1001013 |  |  |  |  | X
14 |  | 1001014 |  | X |  |  |  | X
15 |  | 1001015 |  |  |  |  |  |  | X
16 |  | 1001016
17 |  | 1001017 |  |  |  |  |  |  | X
18 |  | 1001018
19 |  | 1001019
20 |  | 1001020
Spreadsheet: 8eada6d7-a665-4db4-8523-756d7daf3fd9
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HL57O | Test | HL57O | HLA-B 5701 Genotype, Abacavir Hypersensitivity, Saliva | HLAB 5701 [NAME], Saliva | [NAME] (PCR)  (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | [NAME] DNA Self-Collection Kit (Supply T651) |  |  | 4 | mL | Multiple saliva genotype tests can be performed on a single specimen. See Multiple Saliva Genotype Tests in Special Instructions for a list of tests that can be ordered together.   Container/Tube: [NAME] DNA Self-Collection Kit (Supply T651)  [NAME]: Full tube  Collection Instructions: 1. Fill tube to line. 2. Send specimen in original container per kit instructions. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. Specimen Collection Information (Internal) Fasting: None indicated Collect full tube saliva (fill to line per kit instructions) | 1 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Tuesday, Friday | 1 day | 5 days | 1 | 81381 |  |  |  |  | Rochester
HL57O | [NAME] | SALIVA | Saliva |  |  |  | Ambient
HL57O | Result | 33022 | HLA-B 5701 Result | HLA-B 5701 Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
HL57O | Result | 33024 | HLA-B 5701 Interpretation | HLA-B 5701 Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
HL57O | Result | 33023 | HLA-B 5701 Reviewed by | HLA-B 5701 Reviewed by | Numeric
Spreadsheet: 01bdedcf-8cd2-43ab-8291-fde4e0d5125d
Sheet: Sheet1

Today’s Date: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
League Name: |  |  |  |  |  | League Number:
To enter your Teams into a playing league, please complete this form.  A TEAM ENTRY form (Comp or [NAME]) must also be attached for each team.  When you submit the forms, please include your LEAGUE CHECK, payable to Cal North District 5 for your teams’ playing league fees.
 |  |  | PREFERRED PLAYING LEAGUE → | CYSA DISTRICT 5 FALL |  | CYSA DISTRICT 5 WINTER
 |  |  |  | (Recreation ONLY) |  | (Comp ONLY)
 |  |  | AGE GROUP | BOYS TEAM COUNT | GIRLS TEAM COUNT | BOYS TEAM COUNT | GIRLS TEAM COUNT
 |  |  | U14
 |  |  | U15
 |  |  | U16
 |  |  | U19
 |  |  | TOTALS: | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | DUE DATE:
 | $900 x TOTAL DISTRICT 5 COMP WINTER TEAMS: |  |  |  |  | 0 | x $900.00 = | 0 | Oct 15th
 | $100 x TOTAL DISTRICT 5 REC FALL TEAMS: |  |  |  |  | 0 | x $100.00 = | 0 | Jul 1st
 | TOTAL OF ALL FEES DUE WITH SUBMISSION OF FORMS: |  |  |  |  |  |  | 0
League Check should be made payable to "Cal North District 5"
Send forms and fees to:
Cal North District 5 Commissioner
[NAME]
1387 [NAME]
Santa Rosa, CA 95407-7733
-----------------------------------------------------------------------------------------------------------------------------------------------
Official use only:
Date Rec'd: |  |  |  | Amt Pd |  |  | Check #:
 |  |  |  | Amt Owed
 |  |  |  | Bal
Spreadsheet: 727803d1618129250-enter-function-survival-scorebord-aligw
Sheet: Blad1

 | 30 | A | B | C | D |  | A | B | C | D
 | 1 | 2 | 0 | 1 | 0
 | 2 | 2 | 1 | 1 | 0
 | 3 | 0 | 2 | 1 | 4
 | 4 | 0 | 0 | 1 | 0
 | 5 | 0 | 0 | 0 | 0
 | 6 | 2 | 0 | 1 | 0
 | 7 | 0 | 1 | 1 | 2
 | 8 | 0 | 2 | 0 | 0
 | 9 | 0 | 0 | 0 | 3
 | 10 | 0 | 1 | 0 | 0
 | 11 | 0 | 3 | 1 | 0
 | 12 | 2 | 0 | 0 | 2
 | 13 | 0 | 0 | 0 | 1
 | 14 | 0 | 0 | 0 | 2
 | 15 | 0 | 0 | 0 | 0
 | 16 | 1 | 1 | 0 | 0
 | 17 | 0 | 0 | 0 | 0
 | 18 | 0 | 1 | 1 | 0
 | 19 | 0 | 0 | 2 | 0
 | 20 | 0 | 0 | 0 | 0
 | 21 | 0 | 0 | 1 | 0
 | 22 | 0 | 0 | 2 | 0
 | 23 | 0 | 1 | 0 | 0
 | 24 | 0 | 0 | 2 | 0
 | 25 | 2 | 0 | 0 | 1
Spreadsheet: 780158d1652318627-highest-number-of-sales-in-a-period-with-other-criteria-sales-ops-practice
Sheet: Questions

1 | What was the average monthly unit price of "Product 2" for deals booked from June 2020 until September 2020? Note: SACV (Software Annual Contract Value) is the value of a 12-month subscription of each respective Phreesia product.
 | How many full, partial, and phase opportunities were sold in November 2020 with providers on account ranging from 7 to 75?
 | Based on data from Full, Partial, and Phase opportunities, what month in 2020 had the longest average sale cycle (i.e. month with closed/won deals having the longest average sales cycle)?
 | How many more units of Product 2 did Phreesia sell as an upsell/cross sell versus an add-on in 2020?
 | Which market has the highest win rate for the period from Feb 2020 to December 2020? For the purpose of this calculation, only Full, Partial, and Phase deals should be used as "logos."
Answers
1
 | Avg. Sales cycle
 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00
 | [NAME]. Sales cycle
Spreadsheet: 126124d1319539071-excel-2007-help-needed-with-countifs-function-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | dept |  |  |  |  |  |  |  |  |  |  |  | target |  |  |  | actual
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Factory Quality |  |  |  |  |  |  |  |  |  |  |  | 2011-10-25 00:00:00
Spreadsheet: 98125d1297173646-excel-2007-macro-to-remove-blanks-weekly-hilltop-ag-version-v2
Sheet: Weekly

Jan 24th 2011 | This Week | RH | TS | AG | CL | AN
BOARD MEETING | do board meeting | 1 | 1 | 1
 | [NAME] | 2 | 1
COMPLIANCE
FAMILY | lo ree lo |  | 1
 | see family |  |  | 4
HT BUSINESS | dipsum dipsum |  | 2
 | ipsum ipsum | 1 | 1
 | [NAME] | 1 | 1
 | [NAME] | 1 | 1
 | do business | 8 |  | 3
[NAME] | [NAME] | 1
 | see investors |  |  | 6
INVESTOR COMMS | communicate |  |  | 1
 | [NAME] lipsum | 2 |  |  |  | LB
IT | speak with IT |  |  | 1
LEGALS / DOCS
MARKETING
 | [NAME] | 2
 | do marketing | 1 | 1
 | [NAME] | 3
MARKETING MATERIALS | [NAME] lipsum [NAME] | 1
 | [NAME] lipsum [NAME] | 8 | 2 |  |  | LB
 | [NAME] lipsum [NAME] | 4 |  |  |  | LB
MISC | [NAME] lipsum [NAME] | 4 |  |  | 4
 | [NAME] lipsum [NAME] | 1
OPS DD
OPERATIONS - HT | look at operations |  | 2 | 1
product | [NAME] lipsum [NAME] | 1 | 8
 | [NAME] lipsum [NAME] | 1 | 1
 | build a product | 2 |  | 8
 | check the product |  |  | 2
PR/MEDIA
QUANT
 | do quant work | 2 |  | 2
 | check quant work |  |  | 4
 | [NAME] lipsum [NAME]
 | [NAME] quant work |  |  | 8
INTERN | [NAME] lipsum [NAME] |  |  |  |  | 120
 | [NAME] lipsum [NAME]
RISK MGMT | risk manage | 8 |  | 4
SINGLE MGRS
SHAREHOLDERS
SYSTEMS
 | [NAME] lipsum [NAME] |  | 1
 | look at systems | 1 | 3 | 3
 | [NAME] lipsum [NAME] | 1 |  |  |  | FF
 |  | RH | TS | AG | CL | AN
Total |  | 57 | 26 | 48 | 4 | 120
Key
Spreadsheet: 146363d1332149753-character-string-search-and-update-searchlet
Sheet: Sheet1

Dimension-All Products | 0 | Client Change Request | WO013178 | C
Dimension-eLockbox | 30 | Client Implementation | WO017660 | I
Legacy-eCollect | 50 | [NAME] | WO015724 | C
Dimension-PayAnyone | 20 | Internal Project | WO011877 | Int
Spreadsheet: 126258d1319591406-staggered-start-dates-normalize-to-day-1-and-take-average-formula-floating-averages-depending-on-first-day-of-production-excel-help
Sheet: Sheet1

 |  |  |  |  |  | 2011-01-01 00:00:00
 |  |  |  | Production by Well | Well 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 3 | 3 | 5 | 5 | 6 | 7 | 0 | 0 | 9
 |  |  |  |  | Well 2 | 0 | 2 | 2 | 2 | 5 | 5 | 5 | 5 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6
 |  |  |  |  | Well 3 | 0 | 0 | 0 | 0 | 6 | 6 | 6 | 5 | 5 | 5 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 0 | 0 | 0 | 9
 |  |  |  |  | Well 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 2 | 4 | 4 | 4 | 4 | 6 | 0 | 0 | 0 | 7 | 7 | 7
 |  |  |  |  | Well 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 5 | 6
 |  |  |  |  | Well 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 3 | 3 | 4 | 5 | 6 | 0 | 3 | 3 | 5 | 6
 |  |  |  |  |  | Index | First production day | 30-day average | 630-day average | 90-day average
 |  |  |  |  | Well 1
 |  |  |  |  | Well 2
 |  |  |  |  | Well 3
 |  |  |  |  | Well 4
 |  |  |  |  | Well 5
 |  |  |  |  | Well 6