tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1cb2bf8b-59e7-4c42-aacf-01cc04d77574
Sheet: PD Pers Development

Personal Development | is growth through applying knowledge gained from life experiences. Personal development leads to a strong foundation of character and competence, fosters balanced and focused individuals, and establishes confidence in real world situations. ~Doctrine of Excellence
 |  | Tier 1 | Tier 2 Points | Tier 3 Points | Documentation Requirements |  |  |  |  |  | Points
Item No. | Performance Area | Foundational Elements |  |  | CA Verif. | GA/UO Verif. | IFC [NAME]. | Written Descript. | HQ [NAME]. | Other | [NAME]. | Bonus | Reporting Time(s) | Tools | Remarks
PD1 | Fraternal Leadership Programs | At least one chapter member attends the Men of Honor Leadership Institute and in Grand Chapter years at least one chapter member attends Grand Chapter. | At least 3 chapter members attend the Men of Honor Leadership Institute or another Phi Kappa Sigma leadership program. | At least 1 chapter member attends a nationally-recognized fraternal (greek) leadership development program (e.g.UIFI, NGLA, AFLV, SEIFC, etc.) |  |  |  |  | X | Tier 3: Program materials, confirmation of attendance | 1 | 1 | Spring
PD2 | Non-Fraternal Leadership Programs | At least one (1) chapter member attends a non-fraternal leadership retreat or conference (e.g. any non-greek sponsored leadership program). | At least three (3) chapter members attend a non-fraternal leadership retreat or conference (e.g. any non-greek sponsored leadership program). | At least five (5) chapter members attend a non-fraternal leadership retreat or conference (e.g. any non-greek sponsored leadership program). |  | X |  | X | X | Program materials, confirmation of attendance | 1 | 1 | Spring
PD3 | Mentoring |  | At least one (1) member participates in the Scepter Mentorship Program (must be paired with a mentee and meet with them at least twice during the year) | At least three (3) members participate in the Scepter Mentorship Program (must be paired with a mentee and meet with them at least twice during the year) |  |  |  |  | X |  | 1 | 1 | Spring | Scepter Program Guide
PD4 | GreekLife.edu | Chapter achieves at least 90% participation level of applicable members successfully  completing the GreekLife.Edu program |  | For 100% of applicable members successfully completing Greek Life Edu. |  |  |  |  | X |  |  | 1 | Spring | GLEdu Instructions
PD5 | Member Development Programming |  | Chapter plans and conducts at least one (1) formal training session for Members (with at least 50% attendance) in time management, personal finance, conflict resolution, leadership styles, etiquette or other approved subject. | Chapter plans and conducts at least three (3) formal training sessions for Members (with at least 50% attendance) in time management, personal finance, conflict resolution, leadership styles, etiquette or other approved subject. |  |  |  | X |  | Program materials, confirmation of attendance | 1 | 1 | Spring | Sample presentations
Notes:
1. | All Foundational Elements in all Categories must be met to be eligible for points (in all Categories.)
Spreadsheet: 302867d1394283510-land-tax-calculator-formula-307-land-tax-calculator-formula
Sheet: Sheet1

Threshold | Tax Rate | Differtial Rate |  |  | Property |  |  | Hard Coded
0 | 0.005 |  |  |  | 401000
55000 | 0.01
250000 | 0.015 |  |  |  | Tax
400000 | 0.02
Spreadsheet: b17956fd-bcf5-47ea-ba87-a74d38ff2a79
Sheet: Sheet1

Judgeship Number 6 (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 10/22/2014 6:04:48 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 321133
2008 General Election - OFFICIAL RESULTS
County | [NAME] | TOTALS
[NAME] | 56811 | 56811
Steele | 848 | 848
Traill | 3411 | 3411
TOTAL | 61070 | 61070
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 759273d1639470553-popup-message-for-codes-question_pop-up-message
Sheet: Sheet1

 |  |  | Operations | Codes for Operations
 |  |  | Reaming | R1
 |  |  | Cementing | C1
 |  |  | Surveying | S1 |  |  | Main Data Report Worksheet
 |  |  | Casing | Z1
 |  |  | Drilling | D1 |  |  | Time1 | Time2 | Time3
 |  |  | [NAME] | W1 |  | Machine1 | R1 | S1 | C1
 |  |  | Water Swivel | V1 |  | Machine1 | C1 | W1 | R1
 |  |  | Overshot | O1 |  | Machine1 | S1 | P1 | Z1
 |  |  | Inner Tube Stuck | I1 |  | Machine1 | M1 | F1 | W1
 |  |  | Bit Change | B1 |  | Machine1 | D1 | O1 | V1
 |  |  | Pull In/Out | P1
 |  |  | MDD | M1 |  | How can I create this pop up message system for all the
 |  |  | Fishing | F1 |  | codes in the main data report sheet.
Spreadsheet: joe_parks__15034__bridgeline 6-7
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGN2 | 3150 | 5 | 08:53:15 | 905 | 97563 | 4C | 4082 | amk | EO-4082 | 1971 | 0 | N
B | NGN2 | 3155 | 8 | 08:53:37 | 905 | 97563 | 4C | 4085 | amk | EO-4085 | 1973 | 0 | N
B | NGN2 | 3155 | 2 | 08:53:37 | 905 | 97563 | 4C | 4085 | amk | EO-4085 | 1974 | 0 | N
S | NGN2 | 3170 | 5 | 22:32:52 | 905 | 97563 | 4C | 2774 | amk | EO-2774 | 1050 | 0 | Y
S | NGN2 | 3170 | 5 | 22:33:16 | 905 | 97563 | 4C | 2774 | amk | EO-2774 | 1053 | 0 | Y
Spreadsheet: 879499d1727084091-fishing-league-table-and-result-spreadsheet-fgpac-2024-league-table
Sheet: Summary

 | FGPAC League Table - 2024
 |  | Points |  |  |  | Total Weight
 | Name | Rank | Total |  |  | lbs | oz
 | Biggest Weight to date :
 | Biggest fish to date :
 | Golden peg Pot :
 | Leauge Prize Pot :
Spreadsheet: 675522d1588342257-ranking-according-to-multiple-conditions-ranking
Sheet: Sheet1

Name | GPA | Total Mark | Roll | RANK
Baron | 5 | 800 | 1
Abbi | 4.92 | 792 | 2
Markus | 5 | 810 | 3
[NAME] | 4.62 | 762 | 4
Clarke | 4.5 | 755 | 5
Murphy | 4.12 | 550 | 6
Bellami | 3.92 | 525 | 7
Octavia | 3.5 | 500 | 8
Echo | 3.62 | 510 | 9
Madi | 5 | 800 | 10
[NAME] | 4.5 | 752 | 11
Raven | 2 | 420 | 12
Jasper | 3.12 | 512 | 13
Maya | 4.92 | 791 | 14
Lincon | 5 | 805 | 15
[NAME] | 3.5 | 500 | 16
Lexa | 3.62 | 512 | 17
[NAME] | 2 | 402 | 18
Spreadsheet: 66612d1267228355-multiple-page-layout-in-worksheet-print
Sheet: Sheet6

ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
ffffffff | ffffffff | ffffffff | ffffffff | ffffffff | ffffffff
Spreadsheet: 57086d1257262891-excel-2007-is-there-an-easy-way-to-change-my-lists-format-705802
Sheet: Sheet1

Current Format |  |  |  |  |  |  |  | Box | Year | File
 |  | First File in Box | Last File in box | Box | Year
 |  | 1 | 5 | 1 | 2002
 |  | 6 | 8 | 2 | 2002
 |  | 9 | 12 | 3 | 2002
[NAME]
Box | Year | File
1 | 2002 | 1
1 | 2002 | 2
1 | 2002 | 3
1 | 2002 | 4
1 | 2002 | 5
2 | 2002 | 6
2 | 2002 | 7
2 | 2002 | 8
3 | 2002 | 9
3 | 2002 | 10
3 | 2002 | 11
3 | 2002 | 12
Spreadsheet: 49775d1249134279-excel-2007-how-can-i-genereate-report-based-on-cell-value-report
Sheet: Sheet1

student | info 1 | info 2 | info 3 | [NAME] | [NAME] | grade %
fred 1 | blah 1 | stuff 1 | more stuf 1 | [NAME]1 | rhubarb 1 | 0.84
fred 2 | blah 2 | stuff 2 | more stuf 2 | [NAME]2 | rhubarb 2 | 0.79
fred 3 | blah 3 | stuff 3 | more stuf 3 | [NAME]3 | rhubarb 3 | 0.69
fred 4 | blah 4 | stuff 4 | more stuf 4 | [NAME]4 | rhubarb 4 | 0.84
fred 5 | blah 5 | stuff 5 | more stuf 5 | [NAME]5 | rhubarb 5 | 0.44
fred 6 | blah 6 | stuff 6 | more stuf 6 | [NAME]6 | rhubarb 6 | 0.84
fred 7 | blah 7 | stuff 7 | more stuf 7 | [NAME]7 | rhubarb 7 | 0.49
fred 8 | blah 8 | stuff 8 | more stuf 8 | [NAME]8 | rhubarb 8 | 0.84
fred 9 | blah 9 | stuff 9 | more stuf 9 | [NAME]9 | rhubarb 9 | 0.84
fred 10 | blah 10 | stuff 10 | more stuf 10 | [NAME]10 | rhubarb 10 | 0.67
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Tibia

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2018-04-15 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2018-04-15 00:00:00
Spreadsheet: 734389d1622135593-remove-non-numbers-excel-question-5-27-2021
Sheet: Sheet1

 | Data | Need Result
 | 123 | 123
 | F500 | 123
 | 234 | 234
 | F500 | 234
 | 345 | 345
 | MH5 | 345
 | 456 | 456
 | MH5 | 456
 | MH5 | 456
 | 567 | 567
 | MH67 | 567
 | 678 | 678
 | F500 | 678
 | F500 | 678
 | 890 | 890
 | MH855 | 890
 | MH855 | 890
 | MH855 | 890
Spreadsheet: 888698d1739278156-if-and-vlookup-together-new-absence-log-sample
Sheet: Data Analysis

 | I - Illness | September | October | November | December | January | February | March | April | May | June | July | August
 | Staff 1
 | Staff 2
 | Staff 3
 | Staff 4
 | Staff 5
 | Staff 6
 | Staff 7
 | Staff 8
 | Staff 9
 | Staff 10
 | Staff 11
 | Staff 12
 | Staff 13
 | Staff 14
 | Staff 15
 | Staff 16
 | Staff 17
 | Staff 18
 | Staff 19
 | Staff 20
 | Staff 21
 | Staff 22
 | Staff 23
 | Staff 24
 | Staff 25
 | Staff 26
 | Staff 27
 | Staff 28
 | Staff 29
 | Staff 30
 | Staff 31
 | Staff 32
 | Other Leave Type | September | October | November | December | January | February | March | April | May | June | July | August
 | Staff 1
 | Staff 2
 | Staff 3
 | Staff 4
 | Staff 5
 | Staff 6
 | Staff 7
 | Staff 8
 | Staff 9
 | Staff 10
 | Staff 11
 | Staff 12
 | Staff 13
 | Staff 14
 | Staff 15
 | Staff 16
 | Staff 17
 | Staff 18
 | Staff 19
 | Staff 20
 | Staff 21
 | Staff 22
 | Staff 23
 | Staff 24
 | Staff 25
 | Staff 26
 | Staff 27
 | Staff 28
 | Staff 29
 | Staff 30
 | Staff 31
 | Staff 32
Spreadsheet: 837691d1690359790-formula-to-use-indirect-with-index-and-match-from-different-sheets-index-match-problem-with-indirect
Sheet: Inspector 2

 | Inspectors | COMPANY
 |  | Company 1 | Company 2 | Company 3 | Company 4 | Company 5
 | Inspector 1
 | Inspector 2
 | Inspector 3
 | Inspector 4
 | Inspector 5
 | Inspector 6
 |  | 0.1575 | 0.18 | 0.2025 | 0 | 0
 |  | 0.035 | 0.035 | 0.035 | 0 | 0
 |  | 0.13 | 0.1525 | 0.1675 | 0 | 0
 |  | 0.08 | 0.105 | 0.09499999999999999 | 0 | 0
 |  | 0.1066666666666667 | 0.1333333333333333 | 0.14 | 0 | 0
 |  | 0.02333333333333333 | 0.03166666666666667 | 0.035 | 0 | 0
 |  | 0.64 | 0.63 | 0.53 | 0 | 0
Spreadsheet: 871983d1718357919-combining-cells-over-sheets-and-keeping-conditional-formatting-example-sheet
Sheet: Sheet2

 | STAGE
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
A | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
B
C
D
E
F
G
H
J
K
L
M
Spreadsheet: louise_kitchen__24062__NETCO 2pm312
Sheet: Accounting

New Co.
1 | [NAME], [NAME]
2 | Day, Misti
3 | Hardy, [NAME]
4 | Hardy, Stacy
5 | Hodges, [NAME]
6 | [NAME], [NAME]
7 | [NAME], [NAME]
8 | [NAME], [NAME]
9 | [NAME], [NAME]
10 | [NAME], [NAME]
11 | [NAME], [NAME]
12 | Vargas, [NAME] (Hope)
13 | Warwick, Todd
14 | Whiting, Gregory
15 | Wolfe, Stephen
16 | [NAME], [NAME]
17 | Eastwood, Anne
18 | Green, [NAME]
19 | Gruesen, [NAME]
20 | Guilliams, [NAME]
21 | Harris, Kimberly
22 | [NAME], [NAME]
23 | Hernandez, Anamaria
24 | Kacal, [NAME]
25 | [NAME], [NAME]
26 | Mayeux, [NAME]
27 | [NAME], Shannon
28 | Schultz, Amanda
29 | Simper, [NAME]
30 | Smith, [NAME]
31 | [NAME], [NAME]
32 | Ellis, [NAME]
33 | Fellers, [NAME]
34 | Guerra, Ricardo
35 | Hospeti, Savithri
36 | Ingram, [NAME]
37 | [NAME], [NAME]
38 | Leschber, [NAME]
39 | Lewchuk, [NAME]
40 | [NAME], [NAME]
41 | [NAME], [NAME]
42 | Moore, [NAME]
43 | [NAME], [NAME]
44 | Price, [NAME] ([NAME])
45 | Tijerina, [NAME]
46 | [NAME], Angeles
47 | [NAME], [NAME]
48 | Krogmeier, [NAME]
49 | Myers, [NAME]
50 | Khoja, Sayed
51 | Solias, [NAME]
52 | Stokes, [NAME]
53 | [NAME], [NAME]
Spreadsheet: 154655d1336504537-excel-2007-sum-numerical-values-regardless-of-text-test
Sheet: Month

 |  | GRANDEUR HOUSING LTD
 |  | PRODUCTION LABOR COST
 |  | 2012-05-01 00:00:00
 |  |  |  | Previous | Current | Total | Labor Cost @ |  | Previous | Current
 |  | Unit # | Finished | Hours | Hours | Hours | 22 |  | Month | Month
 |  | 100
 |  | 101
 |  | 102
 |  | 103
 |  | 104
 |  | 105
 |  | 106
 |  | 107
 |  | 108
 |  | 109
 |  | 110
 |  | 111
 |  | 714 |  | 705 |  |  |  | 14258.64 | 14258.64
 |  |  |  | 0
 |  | TOTAL
Spreadsheet: 704968d1605819057-remove-first-two-digits-cell-nos-v3
Sheet: Sheet1

TELE_CELL_PRIMARY | text | number
82906451
603193793
603890194
603994547
603998252
604173945
604471051
604673926
604676268
[PHONE]
605020758
605208905
605250444
605261525
605268466
605290266
605330693
605338673
605449274
605484070
605587530
605857696
606007860
606034659
606107623
606238019
606369786
606388643
606585097
606677666
606847000
606995864
607148865
607698420
607736577
607826733
607866213
607877853
608143859
[PHONE]
608305661
608383446
608441397
608578995
608963394
609360513
609479459
609627199
609716204
609718540
609868967
609887943
610081479
[PHONE]
610293532
610506760
610604004
610698655
[PHONE]
610883525
610916375
611231171
611454455
611598035
611626963
611637020
611811583
611934567
612012772
612190326
612241234
612312968
612405921
612616542
612821173
612877877
613118526
613138766
613426756
613623974
613718955
613935606
[PHONE]
614084971
614089633
614104010
614109141
614158453
614194816
614214602
614222291
614226725
614227486
614296999
614300613
614345360
614370612
614424888
[PHONE]
614552620
614571546
614612933
614658035
614690824
614744300
614747734
[PHONE]
614774370
614806388
614863436
614939929
614969358
614985085
615080589
618985877
619122177
[PHONE]
619331820
619550809
619690469
619697546
620034323
620143083
620328847
620480015
620514229
620828514
[PHONE]
[PHONE]
621140849
621297530
621544303
621558002
621665496
621740600
621985473
622792750
[PHONE]
623098827
623356156
623695542
623824953
623984795
624346001
624391427
624422781
624429767
624980025
625001923
625140838
625309835
625456120
625612409
625668064
625669969
625735348
626433125
626482504
[PHONE]
626735199
626797662
626824369
626996633
627126480
627170152
[PHONE]
627758600
627808634
628169624
628532025
[PHONE]
629304338
629774329
629846978
629857345
629942431
629952579
630042226
630148376
630241085
630424889
630647246
630744462
630806871
631109604
632921009
632929506
632946429
[PHONE]
633537743
270847867758
270847868401
270848003786
270848078696
270848383565
270848400021
270848503851
270848677010
270848786048
270849012375
270849178638
270849226526
270849295860
270849456603
270849683784
270849846414
270849854368
[PHONE]
276143395516
276771300780
277724198763
277761044786
277769291883
Spreadsheet: 887476d1737709022-slicer-example1
Sheet: RESULT

Company Name |  | UNIT |  |  | 00 | 35 | 40 | 41 | 45 | 46 | 47 | 51 | 55 | 58 | 75
 |  | Supply |  |  | A | B | C | NEW
 |  | Handling
 |  | Fabrication
Unit | Company Name | Sum of Stage 1 | Sum of Stage 2 | Sum of Stage 3
00 | A | 31.319 | 31.319 | 31.319
35 | A | 720.9550000000002 | 720.9550000000002 | 720.9550000000002
35 | B | 317.898 | 317.898 | 317.898
40 | A | 536.2200000000001 | 536.2200000000001 | 536.2200000000001
41 | A | 56.99500000000001 | 56.99500000000001 | 56.99500000000001
41 | B | 64.84099999999998 | 64.84099999999998 | 64.84099999999998
45 | A | 1129.522 | 1129.522 | 1129.522
45 | B | 276.328 | 276.328 | 276.328
46 | A | 78.18399999999998 | 78.18399999999998 | 78.18399999999998
46 | B | 3.27 | 3.27 | 3.27
47 | A | 193.3300000000001 | 193.3300000000001 | 193.3300000000001
47 | B | 58.105 | 58.105 | 58.105
51 | A | 15911.88100000006 | 15911.88100000006 | 15911.88100000006
51 | B | 6050.338 | 6050.338 | 6050.338
51 | C | 0 | 0 | 0
51 | NEW | 1434.467 | 1434.467 | 1434.467
55 | A | 1849.978999999997 | 1849.978999999997 | 1849.978999999997
55 | B | 281.934 | 281.934 | 281.934
55 | C | 0 | 0 | 0
58 | A | 85.05699999999997 | 85.05699999999997 | 85.05699999999997
58 | B | 1.699 | 1.699 | 1.699
75 | A | 1997.449999999997 | 1997.449999999997 | 1997.449999999997
75 | B | 264.593 | 264.593 | 264.593
Grand Total |  | 31344.36500000006 | 31344.36500000006 | 31344.36500000006
Spreadsheet: 808092d1670282859-filtered-data-error-excel-help-6
Sheet: All

 | Using the below formula to populate this data, however not working in this case.
 | =LET(T,HSTACK(Tim!$B$4:$I$10),Z,HSTACK(Jane!$B$4:$I$100),M,HSTACK(Fiona!$B$4:$I$100),d,VSTACK(T,J,F),FILTER(d,(INDEX(d,,6)="1")))
 | Name | Position | State | Clinic | Hiring Manager | Entity | Employment Type | Start Date
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | 2022-09-12 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PPT | 2022-10-14 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-09-19 00:00:00
 | Mathias Friedman | MR | SA | PRA | [NAME] | 1 | Fixed Casual | 2022-06-02 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Casual | 2022-09-12 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | PFT | 2022-08-29 00:00:00
 | [NAME] | MR | SA | PRA | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-14 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-09-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Casual | 2022-10-05 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | Fixed Casual | 2022-09-19 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PPT | 2022-09-05 00:00:00
 | Essence Esparza | NER | WA | ERD | [NAME] | 1 | PPT | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-31 00:00:00
 | [NAME] | NER | WA | ERD | [NAME] | 1 | PFT | 2022-10-06 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-11 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-10 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-10-04 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-24 00:00:00
 | Alayna Woods | ONAC | VIC | CCDM | [NAME] | 1 | Casual | 2022-10-17 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PFT | 2022-10-05 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-08-15 00:00:00
 | [NAME] | ONAC | VIC | CCDM | [NAME] | 1 | PPT | 2022-07-25 00:00:00
 |  | In the real data [NAME] is an array of data from 3 spreadsheets merged into 1 using the above formula but working.
Spreadsheet: 714324d1611172420-distribute-payment-over-the-year-based-on-invoice-term-sample-2
Sheet: Sheet1

Start Date | End Date | Order Value/year | Invoice term | Amount | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
2015-07-01 00:00:00 | 2021-01-31 00:00:00 | 5982516 | 12 | 498543
2018-02-01 00:00:00 | 2022-06-30 00:00:00 | 1200000 | 12 | 100000
2018-03-01 00:00:00 | 2021-05-28 00:00:00 | 28500 | 3 | 2375
2018-03-01 00:00:00 | 2021-02-01 00:00:00 | 45000 | 12 | 7500
2018-02-01 00:00:00 | 2021-01-31 00:00:00 | 95000 | 3 | 7916.666666666667
Spreadsheet: 775595d1649214330-formula-to-extract-day-of-week-extract-day-of-week
Sheet: Sheet1

Date | Day of Week
Spreadsheet: 587339d1534966167-help-in-graphing-book1
Sheet: Sheet1

Month and Year | Billions (PHp)
JUL 2015 | 11.35
 | 11.76
JAN 2016 | 9.18
 | 10.2
JUL 2016 | 10.35
 | 10.56
JAN 2017 | 12.43
 | 13.55
JUL 2017 | 16.15
 | 18.32
JAN 2018 | 19.21
 | 23.6
Spreadsheet: sara_shackleton__36834__Enron_Final_Version
Sheet: Gas_Opt_Final

Transact | Trade Date | B/S | Type | Beg Date | End_Date | Vol | Location | [NAME]
107553 | Aug 30 2000 12:00AM | SELL | PUT | 2001-03-18 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM
116964 | Feb 20 2001  2:45PM | BUY | CALL | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM
117231 | Feb 23 2001 12:00AM | BUY | CALL | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM
112085 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM
112087 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 5000 | Southern California | Mar 30 2001 12:00AM
112123 | Nov 14 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2001-04-01 00:00:00 | 10000 | Southern California | Mar 30 2001 12:00AM
112353 | Nov 17 2000 12:00AM | SELL | PUT | 2001-03-19 00:00:00 | 2003-01-01 00:00:00 | 10000 | Southern California | Dec 30 2001 12:00AM
112358 | Nov 17 2000 12:00AM | SELL | PUT | 2001-07-02 00:00:00 | 2001-10-01 00:00:00 | 10000 | Southern California | Sep 29 2001 12:00AM
112360 | Nov 17 2000 12:00AM | SELL | PUT | 2001-07-02 00:00:00 | 2001-10-01 00:00:00 | 10000 | Southern California | Sep 29 2001 12:00AM
Spreadsheet: 856620d1705819912-match-and-extract-lambda-map-filter-extract_3
Sheet: P3

 | Match
 | Lon-2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.12 | Apps,ND | Jasmine
 | B-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 133.05 | ABC,US | Apple
 | X-5
 | B-2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DAX,[NAME] | Apple
 | B-3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ABC,US | Apple
 | M-5
 | Lon-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | Apps,ND | Lily
 | Lon-5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apps,ND | Jasmine
 | S-4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101.36 | [NAME],Matrix | Rose
 | S-1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 416 | [NAME] | Hopkins
Spreadsheet: 861951d1709769286-simplifying-cohort-analysis-formula-in-1-row-book1
Sheet: Sheet1

Month | 1
New Users | 100 | 0 | 0 | 50 | 0 | 10 | 0 | 0 | 0 | 0 | 0 | 0
Intake Decay 1
Intake Decay 2 | 0 | 0 | 0
Intake Decay 3 | 0 | 0 | 0 | 0 | 0
Total
Total
This is a cohort analysis. I am trying to find a formula that gets me the total in 1 row as opposed to adding the decay rows together. Only  use row 1 and 3.