tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 879077d1726512453-primary-code-and-secondary-code-selection-cpt-groups-ex
Sheet: Secondary group data

Secondary code group 1 | Secondary code group 1 description |  | Secondary code group 2 | Secondary code group 2 description |  | Secondary code group 3 | Secondary code group 3 description
12345 | 12345 description |  | 23456 | 23456 description |  | 34567 | 34567 description
12346 | 12346 description |  | 23457 | 23457 description |  | 34568 | 34568 description
12347 | 12347 description |  | 23458 | 23458 description |  | 34569 | 34569 description
12348 | 12348 description |  | 23459 | 23459 description |  | 34570 | 34570 description
12349 | 12349 description |  | 23460 | 23460 description |  | 34571 | 34571 description
12350 | 12350 description |  | 23461 | 23461 description |  | 34572 | 34572 description
12351 | 12351 description |  | 23462 | 23462 description |  | 34573 | 34573 description
12352 | 12352 description |  | 23463 | 23463 description |  | 34574 | 34574 description
Spreadsheet: 706372d1606667416-generating-incremental-order-number-based-on-date-and-condition-sample
Sheet: Sample

Date (YYMMDD) | Name | Order Number
2020-11-25 00:00:00 | Abrar | 20112501-01
2020-11-25 00:00:00 | Abrar | 20112501-02
2020-11-25 00:00:00 | Dev | 20112502-01
2020-11-25 00:00:00 | Dev | 20112502-02
2020-11-26 00:00:00 | [NAME] | 20112601-01
2020-11-26 00:00:00 | [NAME] | 20112601-02
2020-11-26 00:00:00 | [NAME] | 20112601-03
2020-11-26 00:00:00 | [NAME] | 20112601-04
2020-11-26 00:00:00 | Partha | 20112602-01
Spreadsheet: 0b119784-7f8c-4f03-a8bf-acd867949697
Sheet: Sheet1

Table 5--Wheat: National average price received by farmers (dollars per bushel) 1/, 3/13/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Month | All wheat |  | Winter |  | Durum |  | Other spring
 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12 | 2010/11 | 2011/12
June | 4.16 | 7.41 | 4.05 | 7.13 | 4.58 | 9.18 | 4.58 | 9.26
July | 4.49 | 7.1 | 4.47 | 6.77 | 4.44 | 10.2 | 4.71 | 8.41
August | 5.44 | 7.61 | 5.47 | 7.26 | 4.45 | 10.2 | 5.47 | 8.3
September | 5.79 | 7.55 | 5.76 | 7.01 | 4.89 | 10.7 | 5.97 | 8.05
October | 5.88 | 7.29 | 5.83 | 6.54 | 5.07 | 9.58 | 6.14 | 8.2
November | 6.1 | 7.26 | 6.02 | 6.42 | 5.55 | 10.4 | 6.35 | 8.46
December | 6.44 | 7.19 | 6.4 | 6.41 | 5.71 | 10 | 6.6 | 8.26
January | 6.69 | 7.04 | 6.35 | 6.57 | 7.09 | 8.8 | 7.14 | 8.12
February | 7.42 | 7.09 | 7.03 | 6.49 | 8.45 | 8.88 | 7.68 | 7.97
March | 7.55 |  | 7.02 |  | 8.09 |  | 8.07
April | 8.01 |  | 7.37 |  | 8.6 |  | 8.67
May | 8.16 |  | 7.8 |  | 7.86 |  | 8.85
1/ Preliminary mid-month, weighted-average price for current month. Source: USDA, National Agricultural Statistics Service, Agricultural Prices.
Date run: 3/12/2012
Spreadsheet: 674321d1587755486-information-from-a-column-affecting-column-a-and-or-b-flexi-calendar
Sheet: Jose Augusto Edit

 |  |  | Hours Gained | Minutes Gained |  | Hours Used | Minutes Used |  | [NAME] |  | APRIL Running Balance |  | TOTAL Running Balance
 | Balance b/d from March |  | 5 | 30
 | 2020-04-01 00:00:00
 | 2020-04-02 00:00:00 |  |  | 30 |  | 1
 | 2020-04-03 00:00:00 |  |  | 15 |  | 1
 | 2020-04-04 00:00:00 |  |  |  |  | 1
 | 2020-04-05 00:00:00 |  |  |  |  | 1
 | 2020-04-06 00:00:00 |  |  |  |  |  | 30
 | 2020-04-07 00:00:00 |  | 5
 | 2020-04-08 00:00:00 |  |  |  |  |  | 30
 | 2020-04-09 00:00:00
 | 2020-04-10 00:00:00 |  |  |  |  | 1
 | 2020-04-11 00:00:00
 | 2020-04-12 00:00:00 |  |  |  |  |  | 30
 | 2020-04-13 00:00:00
 | 2020-04-14 00:00:00 |  |  | 30
 | 2020-04-15 00:00:00 |  |  | 15
 | 2020-04-16 00:00:00
 | 2020-04-17 00:00:00
 | 2020-04-18 00:00:00
 | 2020-04-19 00:00:00
 | 2020-04-20 00:00:00 |  |  | 30
 | 2020-04-21 00:00:00
 | 2020-04-22 00:00:00 |  | 1 | 30
 | 2020-04-23 00:00:00 |  | 1
 | 2020-04-24 00:00:00 |  |  | 30
 | 2020-04-25 00:00:00
 | 2020-04-26 00:00:00
 | 2020-04-27 00:00:00
 | 2020-04-28 00:00:00
 | 2020-04-29 00:00:00
 | 2020-04-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  | Balance at end of April
Spreadsheet: darrell_schoolcraft__7334__imball0203
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19997 | -19960
2 | -20003 | -19960
3 | -19992 | -19793
4 | -20005 | -19793
5 | -20009 | -19960
6 | -19990 | -19960
7 | -20005 | -19960
8 | -19998 | -19960
9 | -19952 | -19960
10 | -19866 | -19688
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  | 0
2002-03-10 00:00:00
CBS Dollars
 |  |  | 0
Spreadsheet: 38519d1236688558-if-statement-help-specimen
Sheet: BIOPSY

Name | Prefix | ID | DOB | Village
TERESA | 9-SC | 298 | 1959-01-01 00:00:00 | Shulinab
[NAME] | 9-SP | 8380 | 1952-02-06 00:00:00 | Paramakatoi
CARRIE | 9-SP | 8234 | 1978-08-16 00:00:00 | Paramakatoi
Spreadsheet: 866183d1713162290-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v3-aligw
Sheet: Sheet1 (2)

 | Explanation
 | In Range B7:B9 you can select a filter (list) you want to use as filter. In this case either Hobbies or Interests.
 | In range C7:C9 you can choose from a list which hobby or interest you are looking for.
 | Filter (list) | Criteria (list) |  | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List |  | Hobby_List | Interest_List
 | Hobby_List | Bowling n/a |  | [NAME] | Tennis | Hockey |  | Reading |  | Tennis | Reading
 | Interest_List | Walking |  | [NAME] | Bowling | n/a |  | Walking |  | Bowling | Bowling
 | Hobby_List | Hockey |  | [NAME] | n/a | n/a |  | Traveling |  | Baseball | Traveling
 |  |  |  | Rachel | Baseball | Bowling |  | Walking |  | Hockey | Walking
 |  |  |  |  |  |  |  |  |  | Darts
 | STATUS: | In the table below the people that meet all the requirements in range B6:C9 you are filtering for to have an EXACT match will pop up. |  |  |  |  |  |  |  | n/a
 | ISSUE: | [NAME] shows up due to the exact match of 'Bowling n/a' in Hobby_List, but not if you only fill in 'Bowling' in C6. |  |  |  |  |  |  |  | Bowling n/a
 |  | [NAME] should also show up with the PARTIAL match of 'Bowling' without the 'n/a'.
 | Matches
 | Name | Hobby_1 | Hobby_2 | Hobby_List | Interest_List
 |  | Tennis | Hockey | Tennis Hockey | Reading
 | [NAME] | Bowling | n/a | Bowling n/a | Walking
 | Rachel | Baseball | Bowling | Baseball Bowling | Walking
Spreadsheet: 89112d1288878073-averages-across-multiple-sheets-with-non-numerical-names-averages
Sheet: Team Member 8

Agent Name: | [NAME]
 | Monday | Tuesday | Wednesday | Thursday | Friday | Average | Sum
PNC | 1 | 2 |  | 4 | 5 | 3 | 12
CONFLICTS | 1 | 2 | 3 | 4 | 5 | 3 | 15
ID'S |  |  | 100 |  |  | 100 | 100
ISA |  |  |  |  |  | #N/A | 0
Spreadsheet: 25578d1216935092-excel-2007-alpha-sort-columns-when-linked-cells-are-sorted-client-review-chart
Sheet: Record of Deposits

 | RECORD OF DEPOSITS            DATE______________________
 | Last Name | First Name | Date | Rent | UDS | Admin. | Deposit | Gas | Other
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 | Parker, | Jeremy
28 | [NAME], | Bo
29 | Watson, | [NAME]
 | 100 |  |  |  | NAME |  |  | AMOUNT
 | 50
 | 20
 | 10
 | 5
 | 1
 | TOTAL CASH
 | CHECKS
 | TOTAL DEPOSIT
Spreadsheet: 00a59bd1-836f-4aa5-a8cc-03ba1cde916e
Sheet: Sheet1

Refresh screen if necessary. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
HOUSING REHABILITATION LOAN COMMITTEE - HISTORY
Name | Appointed | Re-Appointed | Resigned/Term Over | Term Ends
Current Members
Carmen Pascual | 10/08/13 (17) |  |  | 2017
Bianca Placencia | 02/14/12 (15) |  |  | 2015
[NAME] | 09/11/12 (16) |  |  | 2016
[NAME] | 09/11/12 (16) |  |  | 2016
[NAME] (Council Member) | 2013-01-08 00:00:00
Name | Appointed | Re-Appointed | Resigned/Term Over | Term Ends
Past Members
[NAME] | 1905-06-02 00:00:00 |  |  | 1982
Gladys Reese | 1905-06-02 00:00:00 |  |  | 1993
[NAME] | 1905-06-04 00:00:00 |  |  | 1996-06-30 00:00:00
[NAME] | 1905-06-06 00:00:00 |  |  | 1997-06-30 00:00:00
[NAME] | 12/20/88 (Council Member) |  | 1996-12-03 00:00:00
[NAME] | 1994-04-12 00:00:00 |  |  | *1995
[NAME] | 1997-07-22 00:00:00 |  | 1998-09-01 00:00:00 | **1998
[NAME] | 1997 (Council Member) |  |  | 2000
[NAME] | 10/17/95 (99) | 04/13/99 (03) | 2003-06-30 00:00:00 | 2003
[NAME] | 06/30/96 (00) | 04/18/00 (04) | 2004-06-30 00:00:00 | 2004
[NAME] | 10/27/98 (01) | 06/26/01 (05) | ***12/07/04 | 2005
[NAME] | 01/30/01 (Council Member) |  | *12/12/06
[NAME] | 07/15/03 (07) | 04/17/07 (11) | 2011-06-30 00:00:00 | 2011
Brice McQueen | 06/29/04 (08) | 04/15/08 (12) | 2012-06-30 00:00:00 | 2012
[NAME] | 1/9/2007 (Council Member) |  | 2012-12-18 00:00:00
[NAME] | [NAME] (05) | 04/26/05 (09)
 |  | 04/21/09 (13) | 2013-06-30 00:00:00 | 2013
* = Resigned
** = Deceased
*** = Elected to Council
**** = Change in Commission
Updated:  October 9, 2013
Spreadsheet: joe_parks__14777__BridgeDPR0418
Sheet: Bridgeline DPR2

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BRIDGELINE GAS MARKETING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAILY POSITION REPORT
 |  | Position |  |  | Maturity / Gap Risk |  |  | Value-at-Risk |  |  |  | P&L ($000)
Business Unit - Commodity Group |  | Net Open | Limit |  | Sensitivity | Limit |  | 1-Day |  | Limit |  | Today | 5 Day Rolling | MTD | QTD | YTD |  | Yesterday's MTD | Yesterday's QTD | Yesterday's YTD
BRIDGELINE GAS MARKETING
GAS TRADING |  |  | 15 Bcf |  |  |  |  |  |  | 2000
1 Month |  |  |  |  |  | 9 Bcf 1 Month
2-12 Months |  |  |  |  |  | 25 Bcf 2-12 Months
13-18 Months |  |  |  |  |  | 5 Bcf 13-18 Months
TOTAL TRADING
Notes to File
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTD | QTD | YTD
 |  |  |  |  |  |  |  |  |  |  |  |  | ENRON NORTH AMERICA | 1254.625715799998 | 1254.625715799998 | 6545.625715799998
 |  |  |  |  |  |  |  |  |  |  |  |  | GAS TRADING | 1254.625715799998 | 1254.625715799998 | 6545.625715799998
 | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 5923.328615262726
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | -2243.48
 |  |  |  |  |  |  |  |  |  | 998027.0603850778
Spreadsheet: 88537d1288344224-vba-to-group-rows-uat-dashboard-2010-wip2
Sheet: Lists

Awaiting CR Review
Awaiting Estimate
Awaiting Auth To Proceed
Development
System Test
User Testing
Awaiting Implementation
Completed
Motor Claims
HH Claims
Commercial
General
[NAME]
ITP
Swordfish
Multiple
[NAME]
[NAME]
Unassigned
[NAME]
[NAME]
Spreadsheet: 851245d1701457595-lookup-particular-column-in-table-whilst-summing-multiple-rows-with-criteria-npd-kpi-pack-test
Sheet: Jamie

 | Year |  | 2023
 | Month |  | October
 |  |  |  | DPW220
 |  |  |  | SMS310
 |  |  |  | SMS410
 |  |  |  | SMS510
 |  |  |  | SMT030
 |  |  |  | SMT910
 |  |  |  | SPC610
 |  |  |  | SPC710
 | New Product Revenue
 | This Month |  | Year to Date
 | Target |  | Target
Spreadsheet: 674087d1587654549-sum-total-of-cells-that-contain-a-date-seems-simple-but-cannot-get-this-work-sum-up-the-total-entries
Sheet: Sheet1

 | Date of accident 1 | Risk Acc 1 | Date of accident 2 | Risk Acc 2 | Date of accident     3 | Risk Acc 3 | Date of accident 4
 | 2020-01-12 00:00:00 |  | 2020-01-13 00:00:00 |  | 2020-01-12 00:00:00
 | 2020-04-01 00:00:00 |  | 2014-01-01 00:00:00 |  | 2015-01-01 00:00:00 |  | 2016-01-01 00:00:00
 | 2019-05-01 00:00:00
 |  |  | 2020-02-01 00:00:00
 | 2020-04-03 00:00:00 |  |  |  | 2020-07-01 00:00:00
 | 2020-04-01 00:00:00
Total>> | 5 |  | 3 |  | 3 |  | 1
Spreadsheet: 270315d1381436302-return-value-based-on-2-dependent-drop-down-lists-equipment-and-cost-estimate
Sheet: Reference

Size | Description | Price | Price | Price | Price | Price
Spreadsheet: 705581d1606205665-employee-monthly-salary-increased-on-their-anniversary-date-accounting
Sheet: Employee Cost

 | Position | Current Salary | Anniversary | Merit Increase | 2021-01-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  | Total
 | Analyst | 90000 | 2021-08-17 00:00:00 | 0.05
Spreadsheet: 77594d1278024090-multiple-vlookup-in-one-cell-example-lookup
Sheet: Sheet1

 | Input1 | a
 | Input2 | a | Result: | 1 | <- This is looking up from Input1-3 (a,b,c). Thus, it should be 6 (1+2+3). Not sure how to do that.
 | Input3 | a
 |  | Lookup Table
 |  | a | 1
 |  | b | 2
 |  | c | 3
 |  | d | 4
 |  | e | 5
 |  | f | 6
 |  | g | 7
 |  | h | 8
 |  | i | 9
 |  | j | 10
Spreadsheet: 46566d1245411431-summing-variable-data-across-rigid-boundaries-qty-problem-modified-example-fnished
Sheet: Sheet1

 |  |  |  | Example of My Problem :)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Pitch m (from start to finsh)
 |  |  |  |  | Table 1 |  |  |  |  |  |  |  |  |  | Table 2 |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | ---Colour coded reaches
 |  |  | Start (m) | Finish (m) | [NAME] (m3) |  | Reach 1 |  | Reach 2 |  | Reach 3 |  | Reach 4 |  | Reach 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Day 1 | 0 | 3 | 1 |  | 0.6666666666666666 | 0.6666666666666666 | 0.3333333333333333 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0.7m3 |  | 0.3m3 |  |  |  |  |  |  |  | 1
 |  | Day 2 | 0 | 6 | 4 |  | 1.333333333333333 | 1.333333333333333 | 2 | 0 | 0.6666666666666666 | 0 | 0 | 0 | 0 | 0 |  |  |  | 1.3m3 |  | 2.0m3 |  |  | 0.7m3 |  |  |  |  | 4
 |  | Day 3 | 3 | 7 | 3 |  | 0 | 0 | 1.5 | 1.5 | 0.75 | 0 | 0.75 | 0 | 0 | 0 |  |  |  |  |  |  | 1.5m3 |  | 0.75m3 | 0.75m3 |  |  |  | 3
 |  | Day 4 | 3 | 8 | 5 |  | 0 | 0 | 2 | 2 | 1 | 0 | 2 | 0 | 0 | 0 |  |  |  |  |  |  | 2.0m3 |  | 1.0m3 | 2.0m3 |  |  |  | 5
 |  | Day 5 | 6 | 10 | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 0 |  |  |  |  |  |  |  |  |  | 1m3 |  | 1m3 |  | 2
 |  | Day 6 | 2 | 10 | 8 |  | 0 | 0 | 3 | 3 | 1 | 0 | 2 | 0 | 2 | 0 |  |  |  |  |  | 3.0m3 |  |  | 1.0m3 | 2.0m3 |  | 2.0m3 |  | 8
 |  |  |  |  | 23 | m3 | 2 |  | 8.833333333333334 |  | 3.416666666666667 |  | 5.75 |  | 3 |  | 23 | m3 | Total | 0.7 |  | 0.3 |  |  | 0.66 |  | 0.75 |  | 1 | 23 | m3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1.3 |  | 2 |  |  | 0.75 |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | 1.5 |  |  | 1 |  | 1 |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  |  | 1 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  | 3.4 |  | 5.75
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8.8
 | Boundary |  |  | [NAME]
 | 0-2m |  | Reach 1 | 2 | M3
 | 2-5m |  | Reach 2 | 8.833333333333334 | M3
 | 5-6m |  | Reach 3 | 3.416666666666667 | M3
 | 6-8m |  | Reach 4 | 5.75 | M3
 | 8-10m |  | Reach 5 | 3 | M3
 |  |  | Total | 23 | m3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Table 2
 |  |  |  |  |  |  | Reach 1 |  | Reach 2 |  | Reach 3 |  | Reach 4 |  | Reach 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SR1 |  |  |  |  |  |  |  |  |  | ER's
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Reach | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 1 |  | 2 |  | 3 |  | 4 |  | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  | 2 |  | 5 |  | 6 |  | 8 |  | 2 |  | 5 |  | 6 |  | 8 |  | 10
 |  |  |  |  |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 5d7e25aa-3927-414d-b3a2-b5e1d45f3557
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
5004 | 7804 | Corinne | [NAME] | RSA | 27 | 00:22:55 | 00:00:00 | [NAME] | 00:00:00 | 00:36:43 | 1 | 02:08:15
5004 | 12801 | Fabienne | St Louis | MRI | 29 | 00:23:21 | 00:00:00 | 01:10:46 | 00:00:00 | [NAME] | 2 | 02:08:36
5004 | 7803 | Vicky | [NAME] | RSA | 28 | 00:22:01 | 00:00:00 | 01:00:37 | 00:00:00 | 00:35:28 | DQ | 00:00:00
Spreadsheet: 83351d1283344784-show-when-a-student-has-a-mark-updated-in-a-column-with-their-orginals-practiceplz
Sheet: MASTER

 | Student Details |  |  |  | MM |  |  | SP |  |  | AM |  |  | CB |  |  | GM |  |  | IABM |  |  | IDMC |  |  | IMC |  |  | MM |  |  | OM |  |  | PM |  |  | PRCC |  |  | SP |  |  | WMAE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RMTH | DIS | Notes
 | Surname | First Name | ID | Cohort | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Cwrk | Exam | Total | Total | Total
1 |  |  | a100 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | #N/A
2 |  |  | a200 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | #N/A
3 |  |  | a300 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | #N/A
4 |  |  | a400 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 50
5 |  |  | a500 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 30
6 |  |  | a600 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A | 6
7 |  |  | a700 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | 50
8 |  |  | a800 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 10
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
52
53
54
55
57
58
59
60
61
62
65
67
69
70
71
73
74
75
82
84
85
86
90
91
93
97
98
99
100
101
103
104
105
106
108
110
112
117
120
122
123
125
126
129
130
131
133
136
138
140
141
142
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
Spreadsheet: 803467d1667479473-vlook-up-formula-for-child-parent-relationship-child-issues
Sheet: Sheet1

Description | Child Issue | Parent issue | Result
BIO89-100-122 | 4067802 | 4057301
SARO.20.002 | 4054357 | 4048585
NATIV3 DXA | 4052988 | 4047512
NATIV3 DXA | 4050320 | 4047512
NATiV3 | 4050302 | 4054497
NATiV3 | 4049596 | 4045173
NATiV3 | 4049397 | 4054354
NATiV3 | 4048586 | 4045173
NATiV3 DXA | 4047514 | 4045147
AK-US-001-0103 | 4045174 | 4057848 | Concord Repatriation General Hospital, Concord AUS, GE Lunar Prodigy, 502004
AK-US-001-0103 | 4045153 | 4045147
SARO.20.002 | 4036188 | 4033375
BIO89-100-122 | 4034822 | 4054354
AK-US-001-0103 | 4033392 | 4033375
AK-US-001-0103 | 4033376 | 4031499
SARO.20.002 | 4031500 | 4057848 | Concord Repatriation General Hospital, Concord AUS, GE Lunar Prodigy, 502004
AK-US-001-0103 | 4024182 | 4031499
AK-US-001-0103 | 4021646 | 4031499
AK-US-001-0103 | 4018990 | 4017765
AK-US-001-0103 | 4018989 | 4050301
BIO89-100-122 | 4018206 | 4017765
AK-US-001-0103 | 4017766 | 4050301
AK-US-001-0103 | 4014253 | 4014251
SARO.20.002 | 4011443 | 4014251
SARO.20.002 | 4011436 | 4014251
SARO.20.002 | 4011433 | 4057848 | Concord Repatriation General Hospital, Concord AUS, GE Lunar Prodigy, 502004
AK-US-001-0103 691 | 4004518 | 4049594
AK-US-001-0103 | 3984701 | 4017765
BIO89-100-122 | 3983387 | 4049594
Spreadsheet: 871274d1717663356-0-and-empty-value-issue-planned-sp-calculation_review-aligw
Sheet: Sheet1

Campaign Details |  |  |  |  | [NAME] Details |  |  |  | Campaign Setup Details |  | Data Setup Details | New Request Planned SP |  |  | CR Planned SP |  |  | Total SP
User Story ID | Campaign ID | Items | State | Iteration Path / Sprint | Touchpoints | Segments/Varient | No. of dynamic Emails | No. of Non-dynamic emails | No. Workflow | No. Deliveries | No. PayloadID | Content SP | Campaign SP | Data SP | Content SP | Campaign SP | Data SP | New Total Planned SP | CR Total Planned SP
47311 | XXX12 | Sample Name_v1 | Submitted | FY24\May 24 - S2 | 1 | 1 | 2 | 3
47480 | XXX13 | Sample Name_v2 | Submitted | FY24\May 24 - S3 | 1 |  | 3 |  | 3
40654 | XXX14 | Sample Name_v3 | Planning | FY24\May 24 - S3 | 1 | 0 | 3 | 2 | 6
39797 | XXX87 | Sample Name_v4 | In Progress | FY24\June 24 - S1 | 2 | 0 | 3 | 3 | 18
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 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: 878898d1726221261-help-with-a-formula-report-example
Sheet: Report

Start Date | 2024-04-01 00:00:00 |  |  |  |  | Start Date |  |  |  |  |  | Start Date |  |  |  |  |  | Start Date |  |  |  |  |  | Start Date
Open within Month | Open Last of Month | Closed within Month | In Progress | Completed within 30 Days | % Completed within 30 Days | Open within Month | Open Last of Month | Closed within Month | In Progress | Completed within 30 Days | % Completed within 30 Days | Open within Month | Open Last of Month | Closed within Month | In Progress | Completed within 30 Days | % Completed within 30 Days | Open within Month | Open Last of Month | Closed within Month | In Progress | Completed within 30 Days | % Completed within 30 Days | Open within Month | Open Last of Month | Closed within Month | In Progress | Completed within 30 Days | % Completed within 30 Days
Check
Spreadsheet: darrell_schoolcraft__7286__saledoc03_15TW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Richardson Products
Deal Date: |  |  | 2002-03-14 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/15/2002 |  |  | FAX Number:
Total Quantity |  |  | 30000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.63
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/15\/2002 | 2002-03-15 00:00:00 | 30000 |  | 30000 |  | 30000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58649 |  | 30000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date: