tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 824398d1680542029-comparing-two-lists-with-multiple-columns-lists
Sheet: INDEX MATCH

Table 1 |  |  |  |  |  |  | Cette méthode utilise les "array" et a la fin
 |  |  |  |  |  |  | pour "entrer" la formule is faut faire
Covo | [NAME] | V |  |  |  |  | CTRL+SHIFT+ENTER puisqu'il y a un
Eastwood | [NAME] | v | 695-3297 |  |  |  | un "array" dans la formule
Arcand | [NAME] | A | 695-2532
Beaulieu | Michel
Legault | [NAME]
Rozon | Gilles |  | 695-7565
Cross | [NAME] | X | 694-4865
Kelso | [NAME]
Du Preez | [NAME]
Arsenault | Stéphane | V | 697-7813
Legault | [NAME]
Table 2
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Le 1 dans …MATCH(1,(F3=A$3$:A$14$...
veut dire TRUE.
Table 3 | Remove #N/A
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Table 4 | Remove 0 | (number formating: Custom > 0;-0;;@)
Eastwood | [NAME]
Arsenault | Stéphane
Kelso | [NAME]
Legault | [NAME]
Mitchell | [NAME]
Arcand | [NAME]
Beaulieu | Michel
Rozon | Gilles
Cross | [NAME]
Du Preez | [NAME]
Covo | [NAME]
Chartrain | [NAME]
Legault | [NAME]
Spreadsheet: 163962d1340573924-formatting-a-list-by-using-contains-contains-v4
Sheet: Formatted Tenant Names

[NAME] | Formatted Tenant Name
JC Penney | JCPenney
J.C. Penney | JCPenney
J.C. Penney | JCPenney
Wal-Mart | WalMart
Walmart | WalMart
Walmart | WalMart
Foot Locker | Foot Locker
Kid's Foot Locker | Foot Locker
Women's Foot Locker | Foot Locker
Gap Kids | Gap
The Gap | Gap
Gap for Children | Gap
Spreadsheet: 4512cddd-8c41-4405-a060-cb4281e6026c
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
11/09/2014 | Men's Basketball | Shepherd (exhibition)
11/14/2014 | Men's Basketball | Monmouth
11/16/2014 | Men's Basketball | Lafayette
11/20/2014 | Men's Basketball | Puerto Rico Tip-Off (San Juan, P.R.)
11/21/2014 | Men's Basketball | Puerto Rico Tip-Off (San Juan, P.R.)
11/23/2014 | Men's Basketball | Puerto Rico Tip-Off (San Juan, P.R.)
11/26/2014 | Men's Basketball | vs. VMI (Charleston, W.Va.)
11/29/2014 | Men's Basketball | College of Charleston (Non-Bracketed Round Game of the Puerto Rico Tip-Off)
12/04/2014 | Men's Basketball | LSU (SEC/Big 12 Challenge)
12/07/2014 | Men's Basketball | at Northern Kentucky
12/14/2014 | Men's Basketball | vs. [NAME] (Chesapeake Energy Capital Classic, Charleston, W.Va.)
12/20/2014 | Men's Basketball | vs. NC State ([NAME], Madison Square Garden)
12/22/2014 | Men's Basketball | Wofford
12/30/2014 | Men's Basketball | [NAME]
Spreadsheet: 1256d0d3-652b-4cf3-9b09-4f41684dd82d
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42734849 | 2014-08-15 16:13:01 | ALLIES | 0 | 5 | 7 | 1553688 | Sturmtiger1944 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42734974 | 2014-08-15 16:25:58 | AXIS | 1 | 7 | 4 | 1553688 | Sturmtiger1944 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42744758 | 2014-08-16 08:39:20 | ALLIES | 1 | 6 | 3 | 1553688 | Sturmtiger1944 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42744816 | 2014-08-16 08:50:38 | AXIS | 1 | 6 | 3 | 1553688 | Sturmtiger1944 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
42744896 | 2014-08-16 09:00:43 | ALLIES | 1 | 6 | 4 | 1553688 | Sturmtiger1944 | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
Spreadsheet: 863400d1710892614-checking-data-between-table-1-and-table-2-what-is-the-easiest-way-taztaztic-need-sorting-v2-190324
Sheet: Solution

 | TABLE 1 |  |  |  |  | TABLE 2
 | ID | Module Number | Module |  |  | ID |  | Module2 | Module3 | Module4 | Module5 | Module6 | Module7 | Module8
 | 124756 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 124756 | Module2 | ANTH0014 - The Anthropology of Kinship and Gender |  |  | 6547896
 | 124756 | Module3 | ANTH0044 - Human Behavioural Ecology |  |  | 8754561
 | 124756 | Module4 | ARCL0030 - Current Issues in Archaeological Theory |  |  | 20132
 | 124756 | Module5 | ARCL0038 - Research and Presentation Skills |  |  | 124575
 | 124756 | Module6 | ARCL0054 - The Aztecs and the Conquest of Mexico
 | 124756 | Module7 | ARCL0208 - The Archaeology of London
 | 124756 | Module8 | LCSP0002 - Spanish Level 1
 | 6547896 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 6547896 | Module2 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 6547896 | Module3 | ANTH0062 - Anthropology of Cultural Heritage and Museum Anthropology
 | 6547896 | Module4 | ANTH0064 - Anthropology of the Built Environment
 | 6547896 | Module5 | ARCL0030 - Current Issues in Archaeological Theory
 | 6547896 | Module6 | ARCL0038 - Research and Presentation Skills
 | 6547896 | Module7 | ARCL0083 - The Early Islamic World
 | 6547896 | Module8 | ARCL0208 - The Archaeology of London
 | 8754561 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 8754561 | Module2 | ANTH0073 - Digital Infrastructure: Materiality, Information and Politics
 | 8754561 | Module3 | ANTH0079 - Aspects of Applied Medical Anthropology
 | 8754561 | Module4 | ARCL0030 - Current Issues in Archaeological Theory
 | 8754561 | Module5 | ARCL0036 - Archaeological Illustration and Imaging
 | 8754561 | Module6 | ARCL0038 - Research and Presentation Skills
 | 8754561 | Module7 | ARCL0041 - Organic Materials in Archaeology
 | 8754561 | Module8 | LCSP0002 - Spanish Level 1
 | 20132 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 20132 | Module2 | ANTH0014 - The Anthropology of Kinship and Gender
 | 20132 | Module3 | ANTH0136 - The Anthropology of Violent Aftermaths
 | 20132 | Module4 | ARCL0027 - Archaeological Surveying
 | 20132 | Module5 | ARCL0030 - Current Issues in Archaeological Theory
 | 20132 | Module6 | ARCL0038 - Research and Presentation Skills
 | 20132 | Module7 | ARCL0049 - The Archaeology of Human Remains
 | 20132 | Module8 | LCBS0001 - British Sign Language Level 1
 | 124575 | Module1 | ANTH0013 - Theoretical Perspectives in Social Anthropology and Material Culture
 | 124575 | Module2 | ANTH0049 - Anthropology of Capitalisms
 | 124575 | Module3 | ANTH0059 - Anthropology of Religion
 | 124575 | Module4 | ARCL0030 - Current Issues in Archaeological Theory
 | 124575 | Module5 | ARCL0038 - Research and Presentation Skills
 | 124575 | Module6 | ARCL0083 - The Early Islamic World
 | 124575 | Module7 | POLS0027 - Human Rights and World Politics
Spreadsheet: 673811d1587551839-is-there-a-way-to-simplify-sumif-formulas-across-multiple-sheets-home-finance-2020
Sheet: CO

 | Janurary |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges | Payments | Charges
 |  |  |  |  |  |  |  |  |  | Total
 | Capital One |  |  |  |  |  |  |  |  | Prior Year
 | Month | Day | Transaction | Category | Description | Subcategory | Amount | Paid
Spreadsheet: 183717d1348991650-sumif-year-to-date-and-horizontal-summing-excel-question-sumif
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Current month:
[NAME] \ month | Jan-2012 | Feb-2012 | Mar-2012 | Apr-2012 | May-2012 | Jun-2012 | Jul-2012 | Aug-2012 | Sep-2012 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | Sum | AVG |  | YTD
[NAME] | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000 | 10000 | 11000 | 12000 | 13000
[NAME] | 8500 | 9250 | 10000 | 10750 | 11500 | 12250 | 13000 | 13750 | 14500 | 15250 | 16000 | 16750
Jake | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000 | 7000
[NAME] | 3500 | 5000 | 3500 | 5000 | 5000 | 5300 | 5600 | 5900 | 6200 | 6500 | 6800 | 7100
Grand Total
Spreadsheet: 289900d1389731866-q-condtl-formatting-not-functioning-draft4forum
Sheet: Reports

 | A-Player Status Monitoring
 | Customer Name | Claim# | Job# | License | Company | Type  of Loss | Assignment Received | Customer Contact | Customer Contact (Min.) | CC Grade | OnSite Arrival | Onsite Arrival Time (Hours:Minutes) | OnSite Arrival Grade | Initial Upload | Initial Upload Time (Hours) | IUP Grade | Final Upload | Final Upload Appr. | Cycle Time (Days:Hours) | CT Grade | Exceptions | ENV | Notes | Notes
True
 | False
Spreadsheet: tracy_geaccone__40256__C0366-112458
Sheet: Dept_100150

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
TRAVEL - Dept. 100150
May, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-12 00:00:00 | TVL70818778.1695515 |  | [PHONE] GADD/ERIC D | Int'l Air Travel | 1 | 215.4 | /MNTH | 215.4
 |  |  |  |  |  |  | Ticket Total |  | 215.4
2001-04-12 00:00:00 | TVL70818917.0938469 |  | [PHONE] GADD/ERIC D | Domestic Air Travel | 1 | 58.81 | /MNTH | 58.81
 |  |  |  |  |  |  | Ticket Total |  | 58.81
2001-04-19 00:00:00 | TVL70818847.6316992 |  | [PHONE] GADD/ERIC D | Domestic Air Travel | 1 | 58.81 | /MNTH | 58.81
 |  |  |  |  |  |  | Ticket Total |  | 58.81
2001-04-25 00:00:00 | TVL70818639.2452561 |  | [PHONE] GADD/ERIC D | Air Commission | 1 | -12 | /MNTH | -12
 |  |  |  |  |  |  | Ticket Total |  | -12
2001-04-25 00:00:00 | TVL70818708.7074038 |  | [PHONE] GADD/ERIC D | Int'l Air Travel | 1 | 215.4 | /MNTH | 215.4
 |  |  |  |  |  |  | Ticket Total |  | 215.4
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 536.42
 |  |  |  |  |  |  | Total for Dept_100150 |  | 536.42
Spreadsheet: 739694d1625858065-running-numerous-countifs-for-formulas-stuck-on-best-way-to-setup-apply-filters-2-recalc-example-2-
Sheet: Scores

 |  | Q5a | Q200a | Q200b | Q201 | QBanker_Polite | QBanker_Listen | QBanker_Appreciated | QBanker_Understand | QBanker_Asked | QBanker_Knowledgeable
 | Count of Top Box/Yes
 | Count of Valid Answers
 | Sum of Top Box/Yes
 | Sum of Valid Answers
Total | Index Score
Problem is I need to do this calculation for a number of filters and capture the "Index Score" from C9 for each of the 23 logic filters below (variables are from the datasheet): I wish there was an easy way to filter the datasheet to just show each logic item below and have it calculate the final "Index Score/C9" but it counts hidden rows from the filter.
 |  |  |  |  |  |  |  |  |  |  |  |  | Mkt_Num | Q14 | Q56 | Q5
# | Filter to use |  |  |  |  |  |  |  |  |  |  |  | M0004 | 1 | 1 | 1
 | Market Num | Q5a | Q200a | Q200b | Q201 | QBanker_Polite | QBanker_Listen | QBanker_Appreciated | QBanker_Understand | QBanker_Asked | Qbanker nowledgeable |  | M0005 | 2 | 2 | 2
 | M0005 |  |  |  |  |  |  |  |  |  |  |  | M0006 | 3 | 3 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  | M0007 | <=3 | <=3 | <=3
 |  |  |  |  |  |  |  |  |  |  |  |  | M0008
 | Q5 |  |  |  |  |  |  |  |  |  |  |  | M0009
 | <=3 |  |  |  |  |  |  |  |  |  |  |  | M0010
 |  |  |  |  |  |  |  |  |  |  |  |  | M0011 |  |  |  |  |  | 1 | All Records (the total above)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | Only Market_Num=M0007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Only Market_Num=M0006
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | Only Market_Num=M0010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | Only Market_Num=M0011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Only Market_Num=M0004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Only Market_Num=M0008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | Only Market_Num=M0005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | Only Market_Num=M0009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | Only Ret=1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | Only Bus=2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | Only Q14=1-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | Only Q14=1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | Only Q14=2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | Only Q14=3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | Only Q56=1-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | Only Q56=1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | Only Q56=2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | Only Q56=3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | Only Q5=1-3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | Only Q5=1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | Only Q5=2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | Only Q5=3
Spreadsheet: 204510d1357560016-substituting-multiple-values-for-data-validation-data-validation
Sheet: Data

JobType | Administrative Staff and Personal Assistants
Administrative Staff and Personal Assistants | [NAME] | Business Development & Consulting Manager
Consulting (Logistics, IT, Management) | [NAME] Assistant | Consultancy Manager
Corporate Strategy, Organisation & Development | Administration Assistant Finance | Consultancy Support Officer
Customer Service | Administration Clerk | Consultant
Engineering | Administration Controller | Environmental Consultancy Researchers
Executive
Finance
Fleet Service & Management
Health, Safety & Environment
Human Resources
Spreadsheet: 3a082a68-7448-42d1-be12-a9e942af8cb3
Sheet: Totals

 | Headcount Of Credit Graded Students
 | MSJC District Total by Ethnic Groups
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Term Total
Academic Year
% of Total | Credit Headcount % of Total
 | MSJC District Total by Ethnic Groups
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Success Rate | Success Rate
 | MSJC District Total by Ethnic Groups
 | AY07-08 |  |  | AY08-09 |  |  | [NAME] |  |  | AY10-11 |  |  | AY11-12
Ethnic Groups | SU07 | FA07 | SP08 | SU08 | FA08 | SP09 | SU09 | FA09 | SP10 | SU10 | FA10 | SP11 | SU11 | FA11 | SP12
White
Hispanic
African American
Asian
Native American
Filipino
Pacific Islander
Multi-Race
Unknown
Term Average
Success rate = # of “A, B, C, CR & P” grades divided by (the # of all grades) “A, B, C, CR, P, D, F, NC, NP, I and W”
Note: district totals exclude dual enrollment data
Spreadsheet: mike_grigsby__27934__HS_WESTall1025
Sheet: QueryPage

 |  |  | BookList
 |  | BookName |  | Date | SheetName | RangeName | SQL
 |  |  |  |  | GRMS Detail | GRMSQueryReturnArea
Spreadsheet: 765978d1643708456-sumifs-with-date-and-time-criteria-rainfall-test-2
Sheet: Rainfall Data

 |  |  |  |  |  | Date | Rainfall
2019-05-02 00:00:00 | 16:55:31 | 0.2
2019-05-02 00:00:00 | 16:56:32 | 0.2
2019-05-02 00:00:00 | 16:57:06 | 0.2
2019-05-02 00:00:00 | 16:57:46 | 0.2
2019-05-02 00:00:00 | 16:58:11 | 0.2
2019-05-02 00:00:00 | 16:58:45 | 0.2
2019-05-02 00:00:00 | 17:00:01 | 0.2
2019-05-02 00:00:00 | 17:02:02 | 0.2
2019-05-02 00:00:00 | 17:08:57 | 0.2
2019-05-02 00:00:00 | 20:53:59 | 0.2
2019-05-02 00:00:00 | 20:57:34 | 0.2
2019-05-02 00:00:00 | 21:04:00 | 0.2
2019-05-03 00:00:00 | 10:04:11 | 0.2
2019-05-03 00:00:00 | 10:14:01 | 0.2
2019-05-03 00:00:00 | 10:47:34 | 0.2
2019-05-03 00:00:00 | 12:12:37 | 0.2
2019-05-03 00:00:00 | 20:11:27 | 0.2
2019-05-04 00:00:00 | 06:01:35 | 0.2
2019-05-04 00:00:00 | 12:33:01 | 0.2
Spreadsheet: 865048d1712142275-index-match-formula-not-returning-the-correct-value-sample1
Sheet: Sheet1

 |  | Tee | Slope | Course Rating | [NAME] | Factor
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [From USGA Tables]
 |  |  |  |  |  |  |  |  |  | Yardage | Unrated Yardage | Diff. |  | Course Rating | Slope
 | Men | Black | 139 | 74.5 |  | 5.381 |  |  |  | 6903
 | Men | Gold | 135 | 73 |  | 5.381 |  |  |  | 6573
 | Men | Silver | 131 | 71.4 |  | 5.381 |  |  |  | 6215
 | Men | Green | 126 | 69.1 |  | 5.381 |  |  |  | 5716
 | Men | [NAME] | 119 | 66.4 |  | 5.381 |  |  |  | 5104 | 4805
 | Men | New tee |  |  |  | 5.381
 | Women | Silver | 140 | 77.1 |  | 4.24
 | Women | Green | 134 | 74.3 |  | 4.24
 | Women | [NAME] | 127 | 70.9 |  | 4.24
 | I'm trying to find the value in cell M10 (299) and match it to the range of values on sheet 2 (Range D8 & E16).  When a match is found, I want to return the value on sheet 2 column F.   My current formula is returning the value on sheet 2 for the range 253 to 274 and not the range from 275 to 300.  Consequently the result is off by 1/10th.
Spreadsheet: 889881d1740880512-identifying-the-patients-having-specific-combination-of-conditions-multiple-rows-sample_mw
Sheet: Sheet1

PID | DISEASE CODE | DESCRIPITON |  | Combined
1 | 51356 | Eczema |  |  | Eczema|Psoriasis|Fracture | 2 |  |  | Eczema|Psoriasis|Fracture | 2
1 | 51355 | Psoriasis |  | 2 | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
1 | 51358 | Fracture |  |  | Fracture|Eczema|Psoriasis | 2 |  |  | Eczema|Psoriasis|Fracture | 2
2 | 51358 | Fracture |  |  | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
2 | 51356 | Eczema |  |  | Eczema|Psoriasis | 2 |  |  | Eczema|Psoriasis|Fracture | 2
2 | 51355 | Psoriasis |  |  |  |  |  | 2 | Fracture|Eczema|Psoriasis | 2
3 | 51355 | Psoriasis |  |  | Eczema|Psoriasis|Fracture | 2 |  |  | Eczema|Psoriasis|Fracture | 2
3 | 51358 | Fracture |  | 2 | Fracture|Eczema|Psoriasis | 2 |  | 2 | Fracture|Eczema|Psoriasis | 2
4 | 51356 | Eczema
Spreadsheet: 109724d1306501121-excel-2007-specific-date-compared-to-date-range-fed-calc-v3
Sheet: Year 22

 | Case Number |  |  |  |  | Date Prepared
 | Non Custodial Parent |  |  |  |  |  | Reconciliation Date
 | CP/Caretaker
 | YEAR 22:
 |  | Amount Due |  |  |  |  |  | Charging
 |  |  |  |  |  |  |  | Order
Month |  | ORDER 1 | ORDER 2 | ORDER 3 | ORDER 4 | ORDER 5 |  | Amount
253 | January
254 | February
255 | March
256 | April
257 | May
258 | June
259 | July
260 | August
261 | September
262 | October
263 | November
264 | December
 | Support Due
 | Support Paid
 | [NAME]
 | Accrued Arrearage
 | Last Year Carryover
 | Lump/TANF
 | This Year
 | Total
 | Interest Rate
 | Arrears Interest
 | Fees Due
 | Fees Paid
 | Fees Owed
Spreadsheet: 786747d1657419183-ignore-blank-cells-calculate-operations-based-on-multi-column-criteria-with-duplicates-sample
Sheet: Sheet1

Trades | Entry  Time (CT) | Exit Time (CT) | Net Profit (Loss) | [NAME] | [NAME] | PnL % | Win/ Loss
1 | 07:33:00 | 07:45:00 | -1562.5 | Long | ZB | -0.15625 | Loss |  | Average Hold Time = |  |  | *Does not allow blank cells (rows 17-20)
2 | 08:15:00 | 08:17:00 | -210 | Long | NQ | -0.02488888888888889 | Loss |  | Average Hold Time = |  |  | *Does not allow blank cells (rows 17-20)
2 | 08:15:00 | 08:17:00 | -300 | Long | NQ | -0.03064351378958121 | Loss
3 | 08:30:00 | 08:58:00 | -343.75 | Long | ZB | -0.03543814432989691 | Loss |  |  |  |  | Answer
3 | 08:30:00 | 08:58:00 | -1500 | Long | ZB | -0.1553398058252427 | Loss |  | Total # Long Trades = |  |  | 4
4 | 08:31:00 | 08:32:00 | 5 | Long | NQ | 0.000588235294117647 | Win |  | Total # Short Trades = |  |  | 4
4 | 08:31:00 | 08:32:00 | 0 | Long | NQ | 0 | Breakeven |  | Long Winning Trades = |  |  | 1
5 | 08:32:00 | 08:33:00 | 1100 | Short | NQ | 0.11 | Win |  | Short Winning Trades = |  |  | 2
5 | 08:32:00 | 08:33:00 | 4380 | Short | NQ | 0.3945945945945946 | Win
6 | 09:09:00 | 09:09:00 | -100 | Short | NQ | -0.006954102920723227 | Loss |  | [NAME] % per trade =
6 | 09:09:00 | 09:09:00 | -105 | Short | NQ | -0.01060606060606061 | Loss |  | [NAME] profit % for winning trades =
6 | 09:09:00 | 09:09:00 | -330 | Short | NQ | -0.03335017685699848 | Loss
7 | 09:11:00 | 09:11:00 | 220 | Short | ZB | 0.0227507755946225 | Win |  | Largest Winning Trade = |  |  | 5480
7 | 09:11:00 | 09:11:00 | 345 | Short | ZB | 0.0352760736196319 | Win |  | Largest win % = |  |  | 0.505
8 | 09:11:00 | 09:12:00 | -100 | Short | NQ | -0.01035732780942517 | Loss
Spreadsheet: 79716d1279901545-tax-calculator-g-n-pay1
Sheet: Tax schedules

 | over | but not over | rate | of the amount over
Single | 0 | 8350 | 0.1 | 0
Single | 83.5 | 33950 | 0.15 | 8350
Single | 339.5 | 82250 | 0.25 | 33950
Single | 822.5 | 171550 | 0.28 | 82250
Single | 1715.5 | 372950 | 0.33 | 171550
Single | 3729.5 |  | 0.35 | 372950
 | over | but not over | rate | of the amount over
married filed jointly | 0 | 16700 | 0.1 | 0
married filed jointly | 16700 | 67900 | 0.15 | 16700
married filed jointly | 67900 | 137050 | 0.25 | 67900
married filed jointly | 137050 | 208850 | 0.28 | 137050
married filed jointly | 208850 | 372950 | 0.33 | 208850
married filed jointly | 372950 |  | 0.35 | 372950
 | over | but not over | rate | of the amount over
married filed separately | 0 | 8350 | 0.1 | 0
married filed separately | 8350 | 33950 | 0.15 | 8350
married filed separately | 33950 | 68525 | 0.25 | 33950
married filed separately | 68525 | 104425 | 0.28 | 68525
married filed separately | 104425 | 186475 | 0.33 | 104425
married filed separately | 186475 |  | 0.35 | 186475
 | over | but not over | rate | of the amount over
head of household | 0 | 11950 | 0.1 | 0
head of household | 11950 | 45500 | 0.15 | 11950
head of household | 45500 | 117450 | 0.25 | 45500
head of household | 117450 | 190200 | 0.28 | 117450
head of household | 190200 | 372950 | 0.33 | 190200
head of household | 372950 |  | 0.35 | 372950