tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 780765d1652767882-count-times-in-same-golf-foursome-count-matches-in-foursome
Sheet: Sheet1

Name1 | [NAME] | Name3 | Name4 |  | Answer Array | [NAME] | Fred | [NAME] | [NAME] | Marv | Betty
[NAME] | Marv | Jeane | [NAME] |  | [NAME] | 0 | 2 | 1 | 1 | 1 | 1
Fred | [NAME] | [NAME] | Betty |  | Fred | 2 | 0 | 2 | 0 | 1 | 1
[NAME] | Fred | [NAME] | [NAME] |  | [NAME] | 1 | 2 | 0 | 2 | 1 | 1
[NAME] | [NAME] | Fred | Marv |  | [NAME] | 1 | 1 | 2 | 0 | 2 | 1 | <<Yellow cell shows that [NAME] (top) has played in the same foursome with [NAME] (left) 2 times
Betty | [NAME] | [NAME] | Betty |  | Marv | 0 | 1 | 1 | 2 | 0 | 0
 |  |  |  |  | Betty | 1 | 1 | 1 | 1 | 0 | 0
 |  | I need a formula in G2 to pull down and across that fills in the chart above.
 |  | I think it is a Mmult problem somehow. |  |  |  |  | 2 | 1 | 1 | 1 | 1
 |  |  |  |  |  | 2 | 0 | 2 | 1 | 1 | 1
 |  |  |  |  |  | 1 | 2 | 0 | 2 | 1 | 1
 |  |  |  |  |  | 1 | 1 | 2 | 0 | 2 | 1
 |  |  |  |  |  | 1 | 1 | 1 | 2 | 0 | 0
 |  |  |  |  |  | 1 | 1 | 1 | 1 | 0 | 0
 |  |  |  |  |  | Betty | [NAME] | [NAME] | [NAME] | Fred | Jeane | Marv | [NAME]
 |  |  |  |  | Betty |  | 1 | 1 | 1 | 1 | 0 | 0 | 1
 |  |  |  |  | [NAME] | 1 |  | 1 | 0 | 1 | 1 | 2 | 2
 |  |  |  |  | [NAME] | 1 | 1 |  | 1 | 2 | 1 | 1 | 1
 |  |  |  |  | [NAME] | 1 | 0 | 1 |  | 1 | 0 | 0 | 0
 |  |  |  |  | Fred | 1 | 1 | 2 | 1 |  | 0 | 1 | 2
 |  |  |  |  | Jeane | 0 | 1 | 1 | 0 | 0 |  | 1 | 0
 |  |  |  |  | Marv | 0 | 2 | 1 | 0 | 1 | 1 |  | 1
 |  |  |  |  | [NAME] | 1 | 2 | 1 | 0 | 2 | 0 | 1
 |  |  |  |  |  | Betty | [NAME] | [NAME] | [NAME] | Fred | Jeane | Marv | [NAME]
 |  |  |  |  | Betty |  | 1 | 1 | 1 | 1 | 0 | 0 | 1
 |  |  |  |  | [NAME] | 1 |  | 1 | 0 | 1 | 1 | 2 | 2
 |  |  |  |  | [NAME] | 1 | 1 |  | 1 | 2 | 1 | 1 | 1
 |  |  |  |  | [NAME] | 1 | 0 | 1 |  | 1 | 0 | 0 | 0
 |  |  |  |  | Fred | 1 | 1 | 2 | 1 |  | 0 | 1 | 2
 |  |  |  |  | Jeane | 0 | 1 | 1 | 0 | 0 |  | 1 | 0
 |  |  |  |  | Marv | 0 | 2 | 1 | 0 | 1 | 1 |  | 1
 |  |  |  |  | [NAME] | 1 | 2 | 1 | 0 | 2 | 0 | 1
Spreadsheet: 108194d1305241642-selecting-stars-with-mouse-click-and-totaling-lead-scoring-model-designer-3
Sheet: Lead Scoring Model Designer

 |  |  |  |  |  |  |  | Lead Scoring Model Designer
 |  |  |  |  |  |  |  |  |  | Version 1.0
Resource: http://www.leadliaison.com/best-practices/building-a-lead-scoring-model/
STEP 1: Hold an alignment meeting between sales and marketing
Instructions:
Make a list of indivual titles whom you'd like present in your alignment meeting. Check off each attendee when they join the meeting.
Vice President of Sales
Director of Marketing
Chief Marketing Officer
Sales Person #1
Sales Person #2
Chief Executive Officer
 |  | Attendees
STEP 2: Categorize lead scoring criteria into 3 buckets
Instructions:
Demographics |  |  |  |  |  | Total Stars
Location is in the USA
Revenue is > $50M
Lead title is Vice President
[NAME] address is a business email
Number of employees > 100
Demographic #1
Demographic #2
Demographic #3
Demographic #4
Demographic #5
Behavior |  |  |  |  |  | Total Stars
Viewed pricing page
Clicked a link in email campaign
Downloaded eBook XYZ
Visited >= 3 web pages
Used search words containing "XYZ"
Visited more than 1X within past month
Behavior #1
Behavior #2
Behavior #3
Behavior #4
Behavior #5
Qualification |  |  |  |  |  | Total Stars
Uses Salesforce.com as CRM
Industry is finance
Researching or buying a solution
Qualification #1
STEP 3: Define lead scoring thresholds
Instructions:
Enter a numeric value for your lead scoring threshold.
Type | Label |  | Scoring Threshold
Level 1 lead | Engaged Prospect |  | 20
Level 2 lead | Warm Prospect |  | 35
Level 3 lead | Hot Prospect |  | 50
Marketing Qualified Lead | Qualified Prospect |  | 70
STEP 4: Assign a weight to lead scores
Instructions:
Enter a weight (in %) for each of the three categories.
Demographics Score Weight
0.9
Behavior Score Weight
1
Qualification Score Weight
1
STEP 5: Assign a point value per star
Instructions:
Enter a numeric point value for each star. We suggest using a simple point value of 10 per star.
Point Value per Star
10
TEST
Instructions:
Demographics Test Values | Check if Valid |  | Weighted Score
Behavior Test Values | Check if Valid |  | Weighted Score
Qualification Test Values | Check if Valid |  | Weighted Score
 | 0
Lead score for this test lead:
Spreadsheet: 147930d1333039358-data-validation-and-vlookup-counts
Sheet: X-Ray Tech-131

X-Ray Technician: | 131
Job Title | Count |  | Employed Type | Count
None | 1 |  | Independent - Retail | 0
ARRT , (R) RT | 1 |  | Chain - Retail | 0
[NAME]) | 1 |  | Hospital | 0
bone density | 1 |  | Consultant | 0
bsrt | 1 |  | Institutional - Other | 0
CNMT | 2 |  | Retired | 0
CPhT,CNMT,NCT | 1 |  | Unemployed | 1
CRT | 1
LPN, MDX | 1
LSRT | 1
LT | 1
lvn,xraytech | 1
mammographer | 1
Mr | 2
Mr. | 1
pharmacy tech | 1
PHARMACYTECH | 1
pharmD | 1
PTR | 1
r.t | 1
R.T(R),(M) | 1
R.T. | 2
[NAME] (R) (M) (ARRT) | 1
R.T.(R) | 2
R.T.R | 1
radiation therapist | 1
[NAME] | 1
Radiological Technologist | 1
Radiology | 1
Radiology Technician | 1
RADIOLOGY TECHNOLOGIST | 1
rcis / rtr | 1
rdms | 1
Registered Radiologic Technologist | 1
RMA, Nct | 1
RT | 41
RT (R) | 5
RT (R) (M) | 1
RT R CT | 1
RT(M) | 2
[NAME]) | 14
RT(R)(CT) | 3
RT(R)(M) | 3
RT(R)MR | 1
RT, ARDMS, M | 1
RT, CBDT | 1
rt, cmom | 1
RT,R, M | 1
rtr | 7
RTRM | 2
RTT | 1
Shoo | 1
Student | 1
tech | 1
technician | 1
Technologist | 1
x-ray tech | 1
[NAME] | 1
Spreadsheet: 270256d1381423699-combining-two-excel-formulas-sample-2
Sheet: Sheet1

Formula A
[NAME]
Date | Project e.g. HFI | Task Number | CR/INFRA number | Task Description | CR Client | Assigned to | [NAME] (QA) | Expected Delivery from Dev to QA (i.e. [NAME] plus 1 day) | QA Target Completion Date (from Dev Plan QA Finish Date) to meet planned delivery deadline PRIORITY | "R" Ready for Testing | Task Status | Helper Column To Fetch CR Number Below formula is array formula after any change hold control and shift then hit enter | Column For Counting Unique Values which can be hidden after words | Picked up to Test | QA Plan Reviewed By | Defects Raised and Status
2009-09-29 00:00:00 | IF Only |  | CR1954 |  |  |  |  |  |  | R | P |  |  |  |  | 1222
2009-04-13 00:00:00 |  |  | INT006 |  |  |  |  |  |  | R | ON HOLD |  |  |  |  | 1133
2010-02-01 00:00:00 | IF Only |  | INT016 |  |  |  |  |  |  |  | P
2010-02-01 00:00:00 | IF only |  | INT019 |  |  |  |  |  |  | R | ON HOLD |  |  |  |  | 1323
 | IF |  | INT062 |  |  |  |  |  |  |  | P
2010-06-22 00:00:00 | WS |  | INT062 |  |  |  |  |  |  | R | P
2011-01-10 00:00:00 | BO |  | INT062 |  |  |  |  |  |  | R | P
2010-10-04 00:00:00 | BO/IF |  | INT062 |  |  |  |  |  |  | R | P |  |  |  |  | 133
2009-10-13 00:00:00 | ENC | Encore | ENC0013 |  |  |  |  |  |  | R
2009-11-12 00:00:00 | ENC | Encore | ENC0010 |  |  |  |  |  |  | R | P
2009-11-12 00:00:00 | ENC |  | ENC0012 |  |  |  |  |  |  | ? See comments
2011-08-01 00:00:00 | BO/IF |  | R172233 |  |  |  |  |  |  | R | P
2011-10-13 00:00:00 | WS |  | LSR-INT-030 |  |  |  |  |  |  | R | P |  |  |  |  | 12223
2012-01-17 00:00:00 |  |  | CR160 |  |  |  |  |  |  | R | P |  |  |  |  | 1224
2012-02-08 00:00:00 | IF |  | CR160 |  |  |  |  |  |  | R | P
2012-03-16 00:00:00 |  |  | CR160 |  |  |  |  |  |  | R | P
 |  |  |  |  |  |  |  |  |  |  | Results--->
Spreadsheet: 858375d1707092485-create-a-custom-number-code-to-display-fraction-as-ratio-book2
Sheet: Sheet2 (2)

 | % | Fraction | Ratio |  | Want it to display as
5 to 104 | 0.04807692307692308 | 0.04807692307692308 | 0.04807692307692308 |  | 5:104
31 to 104 | 0.2980769230769231 | 0.2980769230769231 | 0.2980769230769231 |  | 31:104
9 to 104 | 0.08653846153846154 | 0.08653846153846154 | 0.08653846153846154
1 to 104 | 0.009615384615384616 | 0.009615384615384616 | 0.009615384615384616
12 to 104 | 0.1153846153846154 | 0.1153846153846154 | 0.1153846153846154
7 to 104 | 0.0673076923076923 | 0.0673076923076923 | 0.0673076923076923
2 to 104 | 0.01923076923076923 | 0.01923076923076923 | 0.01923076923076923
37 to 104 | 0.3557692307692308 | 0.3557692307692308 | 0.3557692307692308
Spreadsheet: 866107d1713048770-index-and-matching-sample
Sheet: Cat

FactSet Fundamentals | 2023-12-01 00:00:00
 | 31 DEC '23 | 31 DEC '22 | 31 DEC '21 | 31 DEC '20 | 31 DEC '19 | 31 DEC '18 | 31 DEC '17 | 31 DEC '16 | 31 DEC '15 | 31 DEC '14 | 31 DEC '13
Total revenues | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
Recurring | 98.305577 | 98.30121 | 98.215767 | 98.148636 | 98.20475 | 98.396536 | 98.239686 | 98.300732 | 97.923032 | 98.196503 | 98.103177
Implementation and other | 1.694423 | 1.698785 | 1.784232 | 1.851363 | 1.795245 | 1.603465 | 1.760317 | 1.699272 | 2.076981 | 1.803497 | 1.896823
Implementation
Hardware
Total operating expenses | -73.352492 | -72.464074 | -75.977139 | -77.880257 | -69.332667 | -69.326513 | -81.843772 | -82.38719 | -84.671923 | -89.59776 | -91.341157
Total cost of revenues | -16.313058 | -15.46962 | -15.337026 | -14.682791 | -14.877499 | -16.026352 | -16.632837 | -16.426396 | -15.790131 | -18.099902 | -19.415248
Operating expenses | -13.207914 | -12.347569 | -12.361159 | -11.6204 | -12.110547 | -13.460384 | -14.418296 | -14.664841 | -14.150714 | -16.361335 | -17.722884
Operating expenses excluding hardware costs and system development and programming costs
Hardware costs
System development and programming costs
Depreciation and amortization | -3.105143 | -3.12205 | -2.975868 | -3.062391 | -2.766951 | -2.565968 | -2.21454 | -1.761555 | -1.639417 | -1.738566 | -1.692363
Total administrative expenses | -57.039433 | -56.994452 | -60.640114 | -63.19747 | -54.45517 | -53.300161 | -65.210939 | -65.960792 | -68.881789 | -71.497858 | -71.925911
Selling, general and administrative expenses | -53.416713 | -53.375832 | -57.247394 | -59.91676 | -51.499921 | -50.629485 | -62.946745 | -63.580657 | -66.327631 | -68.491145 | -68.504011
Sales and marketing | -24.657462 | -25.200441 | -26.147579 | -28.013605 | -24.304329 | -25.405589 | -34.756503 | -36.233106 | -41.198652 | -42.103904 | -39.665989
Research & Development | -11.746712 | -10.786872 | -11.21964 | -10.725024 | -9.906855 | -8.166001 | -7.026951 | -6.369915 | -3.840145 | -2.865586 | -1.994405
General and administrative | -17.012542 | -17.388516 | -19.880172 | -21.178131 | -17.288736 | -17.057896 | -21.163293 | -20.977636 | -21.288834 | -23.521655 | -26.843618
Depreciation and amortization | -3.622716 | -3.618626 | -3.392722 | -3.280709 | -2.955247 | -2.670676 | -2.264188 | -2.380135 | -2.554161 | -3.006712 | -3.421901
Spreadsheet: 88224d1288109792-unique-values-in-pivot-tables-true_sample
Sheet: Sheet1

Resource Name | Project Name | Type | Floor | Current seating | Count
person 1 | project 1 | full time | 1 | loc a | 1
person 2 | project 1 | contr | 2 | loc b | 1
person 2 | project 2 | contr | 2 | loc b | 1
person 3 | project 3 | full time | 1 | loc c | 1
Row Labels | Sum of Count
1 | 2
2 | 2
Grand Total | 4
Spreadsheet: 141143d1329129334-problem-counting-text-in-excel-example
Sheet: Sheet1

Name | Response
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | Yes
[NAME] | Yes
Adam | Yes
[NAME] | No
[NAME] | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
Sue | No
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | Yes
[NAME] | No
[NAME] | Yes
Adam | Yes
Adam | Yes
Spreadsheet: 35050d1232530458-copying-hyperlinks-december-2008-excel-forum
Sheet: 1(a)

INCOMES |  |  |  |  |  |  | 1(a)
Beginning of 1 December 2008
Name of Company | Money X | Money Y | Total
[NAME] | 3000 | 7000 | 10000 |  |  | [NAME] | A5 | B16 | C16 | F16
Вагриус книги | 5000 | 10000 | 15000 |  |  | Вагриус книги | A20 | B32 | C32 | F32
Вагриус правда | 6000 | 7000 | 13000 |  |  | Вагриус правда | A36 | B48 | C48 | F48
Вагриус минус | 8000 | 9000 | 17000 |  |  | Вагриус минус | A52 | B64 | C64 | F64
Плюс-минус | 10000 | 11000 | 21000 |  |  | Плюс-минус | A68 | B80 | C80 | F80
Издательство Вагриус | 12000 | 15000 | 27000 |  |  | Издательство Вагриус | A84 | [NAME] | C96 | F96
Вагриус плюс-минус | 50000 | 25000 | 75000 |  |  | Вагриус плюс-минус | A100 | B112 | C112 | F112
Grand Total | 94000 | 84000 | 178000 |  |  |  |  | B115 | C115 | F115
 |  |  |  |  |  | [NAME] | A122 | B134 | C134 | F134
 |  |  |  |  |  | Вагриус книги | A138 | B150 | C150 | F150
 |  |  |  |  |  | Вагриус правда | A154 | B166 | C166 | F166
EXPENDITURES |  |  |  |  |  | Вагриус минус | A170 | B182 | C182 | F182
End of 28 November 2008 |  |  |  |  |  | Плюс-минус | A186 | B198 | C198 | F198
Name of Company | Money X | Money Y | Total |  |  | Издательство Вагриус | A202 | B214 | C214 | F214
[NAME] | 75000 | 90000 | 165000 |  |  | Вагриус плюс-минус | A218 | B230 | C230 | F230
Вагриус книги | 30000 | 55980 | 85980 |  |  |  |  | B233 | C233 | F233
Вагриус правда | 23452 | 12334 | 35786
Вагриус минус | 98765 | 33000 | 131765
Плюс-минус | 345678 | 234567 | 580245
Издательство Вагриус | 789789 | 456456 | 1246245
Вагриус плюс-минус | 123123 | 234234 | 357357
Grand Total | 1485807 | 1116571 | 2602378
Spreadsheet: 464065d1464865239-drop-down-list-sum-function-fuel-test-sheet
Sheet: Sheet4

Vehicle | Values | Total
Crash 4 | Sum of Fuel | 44.8
 | Sum of Miles | 56
 | Sum of Hours | 69
Crash 5 | Sum of Fuel | 12.8
 | Sum of Miles | 4
 | Sum of Hours | 2
Engine 12 | Sum of Fuel | 61
 | Sum of Miles | 101
 | Sum of Hours | 57
Engine 9 | Sum of Fuel | 55
 | Sum of Miles | 6
 | Sum of Hours | 36
Tanker 6 | Sum of Fuel | 36
 | Sum of Miles | 87
 | Sum of Hours | 12
Total Sum of Fuel |  | 209.6
Total Sum of Miles |  | 254
Total Sum of Hours |  | 176
Spreadsheet: 63229d1264152726-date-month-and-sum-formula-date-sum-calc
Sheet: Sheet1

 |  |  |  |  |  |  | Current Date: | 2010-01-22 00:00:00
[NAME] | Start Date | 2004-07-01 00:00:00 | 2005-07-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-31 00:00:00 | TOTAL OWING | 2004-07-01 00:00:00 | 2005-07-01 00:00:00 | 2006-07-01 00:00:00 | 2007-07-01 00:00:00 | 2008-07-01 00:00:00 | 2009-07-01 00:00:00 | 2010-01-31 00:00:00
Mr A | 2005-10-01 00:00:00 | 9 | 8 | 18 | 14 | 7 | 2 | 20 | 49 | 0 | 0 | 9 | 21 | 33 | 45 | 52 | 554
 | 2005-06-01 00:00:00 |  | 72 | 216 | 168 | 84 | 14
 |  |  |  |  |  |  |  | 554
Spreadsheet: 734103d1621975770-some-help-needed-with-coding-vllookup-book2
Sheet: Sheet1

Name 1
2021-05-20 00:00:00 |  | 93.04
2021-05-21 00:00:00 |  | 73.94
2021-05-24 00:00:00 |  | 88.86
2021-05-25 00:00:00 |  | 91.79
Totals: |  | 87.19
Name 2
2021-05-24 00:00:00 |  | 97.19
2021-05-25 00:00:00 |  | 97.99
Totals: |  | 97.59
Requried result
Name 1
Name 2
Spreadsheet: 675597d1588361873-fill-unit-cells-received-of-products-through-getting-data-of-lead-time-from-other-cell-help
Sheet: Sheet1

 |  |  | (1) Day |  | (2) Units Received |  | (10) Lead Time
 |  |  | 1 |  | … |  | 2
 |  |  | 2 |  | 1 |  | 1
 |  |  | 3 |  |  |  | 1
 |  |  | 4 |  |  |  | 3
 |  |  | 5 |  |  |  | 1
 |  |  | 6 |  |  |  | 2
 |  |  | 7 |  |  |  | 3
 |  |  | 8 |  |  |  | 1
 |  |  | 9 |  |  |  | 2
 |  |  | 10 |  |  |  | 2
 |  |  | 11 |  |  |  | 2
 |  |  | 12 |  |  |  | 2
 |  |  | 13 |  |  |  | 3
 |  |  | 14 |  |  |  | 2
 |  |  | 15
Spreadsheet: 687877d1595463437-managing-worksheets-in-excel-managing-worksheets-in-excel_chris
Sheet: Sales Journal

Back | Date | Customer Number | Name | VAT Number | Invoice | Invoice Exist | Amount | Vat % | VAT | Amount incl [NAME] | Payment Terms
 | 2020-02-01 00:00:00 | C001 | [NAME] |  | 6000 |  | 5000000 | 0.15
 | 2020-02-02 00:00:00 | C002 |  |  | 6001 |  | 5000000 | 0.15
 | 2020-01-03 00:00:00 | C001 | [NAME] |  | 6002 |  | 5000000
 | 2020-01-04 00:00:00 | C004 |  |  | 6003 |  | 5000000
 | 2020-01-05 00:00:00 | C005 |  |  | 6004 |  | 5000000 | 0.15
Spreadsheet: 9b9fcf11-f2f7-495e-95f3-2446b39e1a5a
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
2759 | 15598 | Germaine | Roullet | ITA | 93 | 00:35:11 | 00:00:50 | 01:01:33 | 00:01:53 | 00:38:33 | 1 | 02:18:00
2759 | 15487 | Yuliya | Barabash | RUS | 91 | 00:33:24 | 00:00:56 | 01:06:31 | 00:01:11 | 00:39:13 | 2 | 02:21:15
2759 | 15827 | [NAME] | [NAME] | SVK | 92 | 00:39:45 | 00:00:59 | 01:12:04 | 00:02:37 | 00:43:44 | 3 | 02:39:09
Spreadsheet: 860530d1708600342-vlookup-combined-with-if-function-example1-1-
Sheet: Tabelle1

 | item # | issue from | issue to | price |  |  | item # | issue | price
 | 1 | 202001 | 202305 | 2.5 |  |  | 1 | 202307
 | 1 | 202306 | 999999 | 2.4 |  |  | 2 | 202305
 | 2 | 202103 | 202212 | 4.1 |  |  | 3 | 202401
 | 2 | 202301 | 999999 | 4.5
 | 3 | 202202 | 202212 | 1.6
 | 3 | 202301 | 999999 | 1.9
Spreadsheet: 803799d1667717857-using-the-internet-to-send-the-excel-cell-value-test
Sheet: Sheet1

Student Record
Student Name |  | Record
Student Name 1 |  | 2
Student Name 2 |  | 4
Student Name 3 |  | 0
Student Name 4 |  | 1
Student Name 5 |  | 5
Student Name 6 |  | 3
Student Name 7 |  | 0
Student Name 8 |  | 0
Student Name 9 |  | 1
Student Name 10 |  | 0
Student Name 11 |  | 10
Student Name 12 |  | 2
Spreadsheet: 297bf4cc-5367-4175-827c-ee3cd4b63d7b
Sheet: Sheet1

Unnamed: 0 | 2013 USA Triathlon Event Accounting Form | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Please submit one form for each Sanctioned event
Event Name:
Event Number:
Event Date:
Race Director:
Race Director Phone #(s):
Race Director [NAME]:
Are you sending  waivers or checks? |  |  |  | Yes |  | No
Please mark any paperwork with Event Name/Number so that we can properly apply it.
Preregistration Service Used (If Any):
Please include preregistration numbers in counts below
Number of Annual Memberships Sold @ $45: |  |  |  |  | 0
Number of Annual Upgrades with $12 One Day Sold @ $33: |  |  |  |  | 0
Number of One Day [NAME] $12: |  |  |  |  | 0
Number of Youth Annual Memberships Sold @ $15: |  |  |  |  | 0
Number of Youth Annual Upgrades with $10 One Day Sold @ $5: |  |  |  |  | 0
Number of Youth One Days Sold @ $10: |  |  |  |  | 0
Number of Participants with Current Memberships: |  |  |  |  | 0
Total Number of Participants (Will Automatically Calculate) |  |  |  |  |  | 0
Total dollar amount of [NAME]: |  |  |  |  | 0
Total dollar amount of Participant Checks Made out to USAT: |  |  |  |  | 0
Total dollar amount of Participant Credit Cards for USAT to Run: |  |  |  |  | 0
Preregistration monies paid directly to USAT: |  |  |  |  | 0
Donations to USAT: |  |  |  |  | 0
Total Fees Due From Race Director To USAT: |  |  |  |  | 0
**Please do not send cash to USAT**
*If you wish to pay by credit card please provide a valid daytime number where we
can reach you or fax your card information along with this sheet to: (719)597-9095
Comments:
Spreadsheet: 861718d1709570452-pulling-data-from-multiple-excel-sheet-payroll-test
Sheet: Summary

DONOTIMPORT | JOURNAL | DATE | REVERSEDATE | [NAME] | REFERENCE_NO | LINE_NO | ACCT_NO | LOCATION_ID | DEPT_ID | DOCUMENT | MEMO | DEBIT | CREDIT | SOURCEENTITY | ALLOCATION_ID | BILLABLE | TAXIMPLICATIONS | TAXSOLUTIONID | TAX_VENDORID | TAX_CUSTOMERID | TAX_CONTACTID | TAX_DETAILID | TAX_AMOUNT | [NAME] | SAGE50_REFERENCE | SAGE50_JOURNAL | GLENTRY_VENDORID | GLENTRY_EMPLOYEEID | GLENTRY_CLASSID | TAX_LINE_NO
 | GJ |  |  |  | 1 |  |  | [NAME] |  |  | Net Wages |  |  |  |  |  |  | United Kingdom - VAT
 | GJ |  |  |  | 1 |  |  | ACC |  |  | Net Wages
 | GJ |  |  |  | 1 |  |  | CHT |  |  | Net Wages
 | GJ |  |  |  | 1 |  |  | FMB |  |  | Net Wages
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 | GJ |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
 |  |  |  |  | 1
Spreadsheet: 872008d1718367964-summing-2-different-columns-only-when-names-match-help3-1-aligw
Sheet: Sheet1

Claimant 03rd | 03/06/2024 | No Appt Reason 3rd | Claimant 10t | 10/06/2024 | No Appt Reason 10th |  |  | without reason | with reason |  | SUMPRUDUCT |  |  | SPILL |  |  | ALL-IN-ONE
[NAME] | 1 | ill | [NAME] | 1 | ill |  | [NAME] | 2 | 0 |  |  |  |  |  |  |  |  | 0 | 2
[NAME] | 1 | ill | [NAME] | 1 |  |  | [NAME] | 2 | 2 |  |  |  |  | 0 | 2 |  | [NAME] | 1 | 1
Spreadsheet: 753505d1635483156-conditionally-format-multiple-dates-in-a-single-row-book1-2-
Sheet: Sheet1

IDENTIFYING NO | PERSON | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00
123 | PERSON A
321 | PERSON B
456 | PERSON C
REPORT PROVIDED
123 | SICK LEAVE | 2022-01-02 00:00:00 | 2022-01-03 00:00:00
123 | LEAVE | 2022-01-03 00:00:00 | 2022-01-05 00:00:00
123 | LEAVE | 2022-01-10 00:00:00 | 2022-01-10 00:00:00
321 | LEAVE | 2022-01-01 00:00:00 | 2022-01-08 00:00:00
321 | SICK LEAVE | 2022-01-08 00:00:00 | 2022-01-10 00:00:00
456 | LEAVE | 2022-01-01 00:00:00 | 2022-01-02 00:00:00
456 | LEAVE | 2021-01-04 00:00:00 | 2022-01-05 00:00:00
456 | SICK LEAVE | 2022-01-05 00:00:00 | 2022-01-07 00:00:00
456 | LEAVE | 2022-01-07 00:00:00 | 2022-01-10 00:00:00
The report doesn’t always have a set number of leave, PERSON A can take upto 6 different types of leave during the month or year.
The report needs to be projected onto the cells using conditional formatting as the cells are filled with formulas
Spreadsheet: 850225d1700588769-interval-staffing-formula-not-working-correctly-when-shifts-cross-midnight-interval-template-jadams169-working-version2-
Sheet: Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In time | Out Time | Cross Midnight? |  | 23:00:00 | Over Midnight | Within Day | Combined Formula
 |  |  |  | Paste Here-> |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 |  |  |  |  |  | 00:01:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 20:00:00 | 2024-01-01 08:00:00 | 12 | 2023-12-31 20:00:00 | 2024-01-01 08:00:00 | 12 |  |  |  |  |  | 01:01:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 | 2023-12-31 08:00:00 | 2023-12-31 20:00:00 | 12 |  |  |  |  |  | 02:01:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  | 2023-12-31 20:00:00 | 2024-01-01 08:00:00 | 12 | 2023-12-31 20:00:00 | 2024-01-01 08:00:00 | 12 |  |  |  |  |  | 03:01:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 04:01:00
 |  |  |  |  |  |  |  | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 05:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 06:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 08:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 09:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22:01:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23:01:00