tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: d03d5b43-b23a-44dd-8c4b-22faa0f4391d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GRAB | Test | GRAB | [NAME], IFA | Giardia lamblia Ab, IFA | Immunofluorescence Assay (IFA) | Plain, Red-Top Tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL of serum refrigerated.   Note: Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.075 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK: Cold OK Lipemia	NA Icteric	NA | REFERENCE RANGE:  <1:16   INTERPRETIVE CRITERIA:  <1:16    Antibody Not Detected 1:16  Equivocal; submission of a second specimen  (collected 3-4 weeks after initial specimen) suggested  if clinically warranted > or = 1:32 Antibody Detected   A polyvalent conjugate (recognizing IgG, IgM and IgA) is used to detect  the presence of antibodies to Giardia lamblia.  A four-fold or greater  increase in titer between acute and convalescent sera indicates an acute  active phase.  A single positive reaction represents previous exposure,  since antibody titers are known to remain high for at least six months.   Test Performed by: Focus Diagnostics, Inc.                                       5785 Corporate Avenue                                       Cypress, CA 90630-4750 | Monday through Saturday | 1 - 3 days | 3 - 5 days | 1 | 86674 |  |  |  |  | Focus Diagnositics, Inc.
GRAB | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
GRAB | Result | Z0586 | Giardia lamblia Ab, IFA | Giardia lamblia Ab, IFA | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 862553d1710251313-progress-bar-based-upon-hours-calculate-partial-and-full-day-hours-hwc-contractor-attendance-record
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee name | Start date | End date | Type of leave | Days | Hours
 | Brittany | 2023-12-07 00:00:00 | 2023-12-08 00:00:00 | [NAME]
 | Chelsea | 2024-01-18 00:00:00 | 2024-01-18 00:00:00 | Bereavement
 | [NAME] | 2024-01-19 00:00:00 | 2024-01-19 00:00:00 | Other
 | [NAME] | 2024-02-04 00:00:00 | 2024-02-05 00:00:00 | [NAME]
 | Brittany | 2024-02-05 00:00:00 | 2024-02-05 00:00:00 | [NAME]
 | [NAME] | 2024-02-06 00:00:00 | 2024-02-06 00:00:00 | [NAME]
 | Brittany | 2024-02-12 00:00:00 | 2024-02-12 00:00:00 | [NAME]
 | Chelsea | 2024-02-13 00:00:00 | 2024-02-13 00:00:00 | [NAME]
 | Brittany | 2024-02-14 00:00:00 | 2024-02-15 00:00:00 | [NAME]
 | Brittany | 2024-02-22 00:00:00 | 2024-02-23 00:00:00 | [NAME]
 | Brittany |  |  | Personal |  | 3
Spreadsheet: 105073d1302545592-freight-charges-based-on-zip-someko_freightperzipcode-2-
Sheet: Get Zip Rate

Zip Group | Zip Code | STATE | Basic Charge | Min Charge | 0 - 250 KGS | 251 - 500 KGS | 501 - 1000 KGS | 1001 - 3000 KGS | 3001 + KGS
Zip Group | Zip Code | STATE | Weight | Cost
0 | 830 | FARRAR | 13.5
 |  | Basic charge + (Weight *Rate ) > |  | + |  | = |  | is less  than min
Spreadsheet: 854572d1704394792-select-which-column-to-use-for-data-extraction-last-value
Sheet: Sheet1

Date | Action | D/C | Q | C/B | D/P
2023-10-24 00:00:00 | P |  | 1395 | 5.35 |  |  | 2023 | 80.37 |  |  | 2023 | Answer is 80.37
2023-11-07 00:00:00 | p |  | 1 | 5.56 |  |  | 2024 | 79.16
2023-11-30 00:00:00 | d |  | 14.086 | 5.64 |  |  |  |  |  |  | 2023 | Without row 6 - Answer is 79.45
2023-12-29 00:00:00 | np | 80.37
2024-01-10 00:00:00 | d |  | 14.47 | 5.45 |  |  |  |  |  |  | 2024 | Answer is 76.19
2024-01-15 00:00:00 | p
2024-01-17 00:00:00 | np | 80.66 |  |  |  |  |  |  |  |  | 2024 | Without row 10 the Answer is 80.66
2024-02-01 00:00:00 | d |  | 14.66 | 5.4
I needd a formula that would look at both columns to find the last entry for the year from column C or column F. Every time I add a new date for the year, column I updates with the correct value for the year from column C or F.
Spreadsheet: 753226d1635319807-index-to-match-category-and-date-range-how-to-exceltestinghelp-
Sheet: Sheet2

 | Total
 | 2022 |  |  |  |  |  |  |  |  | 2023
Category | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
Actual Spent
Workshop A
Workshop B
Workshop D
Workshop C
Workshop B
Spreadsheet: e3535fd4-11c6-4e9a-a690-d384bd8ee18e
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
TMP | Test | TMP | Trimethoprim, Serum | Trimethoprim, S | High-Performance Liquid Chromatography (HPLC) | Plain, Red-Top Tube: Red OR |  |  | 1 | mL | Collection Container/Tube: Red top  Submission Container/Tube: Plastic vial [NAME]: 1 mL Collection Instructions:  1. Serum for a peak level should be drawn at least 60 minutes after a dose. 2. Spin down within 2 hours of draw. | 0.2 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | >2.0 mcg/mL | Tuesday, Friday; 1pm | 2 days | 5 days | 1 | 80299 |  |  |  |  | Rochester
TMP | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
TMP | Result | 80146 | Trimethoprim, S | Trimethoprim, S | Numeric |  |  |  |  | mcg/mL |  |  |  |  |  |  |  |  |  | 11005-6 | Trimethoprim:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 356087d1414972200-speedometer-query-speedometer-bvj-
Sheet: Sheet1

 |  | four segment donut chart |  |  | four segment [NAME]
 |  | speedometer dial |  |  | Pointer
 |  | Red Zone | 51 |  | needle swing | 100
 |  | Caution Zone | 24 |  | needle width | 2
 |  | Acceptable  Zone |  |  | upper right segment
 |  | outer donut bottom half | 180 |  | pie chart lower half | 180
 |  | total angle |  |  | total angle
Spreadsheet: 552561d1513650931-compounding-formula-that-only-compounds-at-a-whole-number-usitech-compound-speadsheet-demo-start
Sheet: Sheet1

Make sure that all of the corresponding info in ORANGE (3) is correct prior to investing. Ensure that all data in row 3 is filled in. Investing is a risk and you should never invest more than you are willing to lose.
 |  |  | Start amount |  | Enter average interest rate (%): |  | Enter starting date: (it will show up as "####" SEE cell C8) |  | Reinvestment % |  |  |  |  |  |  | Price Of BTC
 |  |  | 1 |  | 1.4 |  | 43080 |  | 100 |  | https://hambone155.usitech-int.com |  |  |  |  | 19030
 | See Sheet two for more oppertunities withing the Bitcoin community. |  |  |  |  |  |  |  |  |  | Click here ^^^^^^^^^^^^^^^^^^ Click here
 | Term | Date (Start) | Investment Amount | x | Interest Rate + Bonus (not shown) | = | Term Interest (packs) |  | Lending Wallet accumulation (PACKS) | - | Reinvest (packs) | = | Amount left after reinvest |  | Carry the 1
 | 1 |  |  | x |  | = |  |  |  |  | 1 |  | 0.4
 | 2 |  | 1 | x |  | = |  |  | 1.4 |  | 1 |  | 0.4
 | 3 |  | 1 | x |  | = |  |  | 1.4 |  | 1 |  | 1.2 |  | 1
 | 4 |  | 2 | x |  | = |  |  | 2.8 |  | 2 |  | 1 |  | 1
 | 5 |  | 3 | x |  | = |  |  | 4.2 |  | 4 |  | 0.2
 | 6 |  | 4 | x |  | = |  |  | 5.6 |  | 5 |  | 0.8
 | 7 |  | 5 | x |  | = |  |  | 7 |  | 7 |  | 0.8
 | 8 |  | 7 | x |  | = |  |  | 9.8 |  | 9 |  | 1.6 |  | 1
 | 9 |  | 10 | x |  | = |  |  | 14 |  | 14 |  | 0.6
 | 10 |  | 14 | x |  | = |  |  | 19.6 |  | 19 |  | 1.2 |  | 1
 | 11 |  | 20 | x |  | = |  |  | 28 |  | 28 |  | 0.2
 | 12 |  | 28 | x |  | = |  |  | 39.2 |  | 39 |  | 0.4
 | 13 |  | 39 | x |  | = |  |  | 54.6 |  | 54 |  | 1 |  | 1
 | 14 |  | 55 | x |  | = |  |  | 77 |  | 77 |  | 0
 | 15 |  | 77 | x |  | = |  |  | 107.8 |  | 107 |  | 0.8
 | 16 |  | 107 | x |  | = |  |  | 149.8 |  | 149 |  | 1.6 |  | 1
 | 17 |  | 150 | x |  | = |  |  | 210 |  | 210 |  | 0.6
 | 18 |  | 210 | x |  | = |  |  | 294 |  | 294 |  | 0.6
 | 19 |  | 294 | x |  | = |  |  | 411.6 |  | 411 |  | 1.2 |  | 1
 | 20 |  | 412 | x |  | = |  |  | 576.8 |  | 576 |  | 1 |  | 1
 | 21 |  | 577 | x |  | = |  |  | 807.8 |  | 807 |  | 0.8
 | 22 |  | 807 | x |  | = |  |  | 1129.8 |  | 1129 |  | 1.6 |  | 1
 | 23 |  | 1130 | x |  | = |  |  | 1582 |  | 1582 |  | 0.6
 | 24 |  | 1582 | x |  | = |  |  | 2214.8 |  | 2214 |  | 1.4 |  | 1
 | 25 |  | 2215 | x |  | = |  |  | 3101 |  | 3101 |  | 0.4
 | 26 |  | 3101 | x |  | = |  |  | 4341.4 |  | 4141 |  | 0.8
 |  |  | BTC |  |  |  |  |  | This is to demonstrate 1 pack over the course of 10 years. The terms of 260 per year
 |  |  |  |  |  |  |  |  | 140 days per cycle with 100 working days.
 |  |  | BTC Value Currnet rate 10 years from now |  |  |  |  |  | https://hambone155.usitech-int.com
 |  |  |  |  |  |  |  |  | initial BTC investment
 |  |  | BTC Valute at propsed rate in 10 years |  |  |  |  |  | 0.0050346 | << | FILL THIS IN
Spreadsheet: 854195d1704165070-function-to-track-gain-loss-for-weight-bf-bmi-bone-mass-etc-body-measurement-tracker
Sheet: Sheet1

DATE | WEIGHT | BF % | MUSCLE % | PROTEIN MASS lbs | B M I | BONE MASS lbs | VISCERAL INDEX | FAT MASS | METABOLIC AGE |  | B M I
2024-01-01 00:00:00 | 190.5 | 30.8 | 65.5 | 28.4 | 27.6 | 7.1 | 9 | 58.6 | 59
2024-01-15 00:00:00
2024-02-01 00:00:00
2024-02-15 00:00:00
2024-03-01 00:00:00
2024-03-15 00:00:00
2024-04-01 00:00:00
GOAL | 155 | 0.23 | <70 | <45 | <22 | >5.7 | 9 | <55 | <55
DIFFERENCE |  |  |  |  |  |  |  |  |  |  | <== [NAME]'s formula
^^^^^Enter formulas here w/red as a loss in weight and black for a gain, using the start weight at 01/01/2024 as the constant.^^^^^
Spreadsheet: 887253d1737496096-data-not-sorting-or-flowing-correctly-emp_test-dru12233-
Sheet: WK1

Emoloyee ID | Office | Last | First | WK1 Total | M | TU | W | TH | F
643 | ACC | Smith | [NAME] | 7 | 1 | 3 | 2 |  | 1
976 | FIN | [NAME] | Greg | 8 | 2 |  |  | 5
236 | FIN | Jones | [NAME] | 8 | 1 | 2 | 3 | 2
443 | LOG | [NAME] | Pam | 6 |  |  |  |  | 8
123 | NEW | [NAME] | [NAME] | 7 | 3 | 3 | 1
Spreadsheet: 833108d1686792547-search-box-issues-contract-template_sample
Sheet: Search Tool

 | Today's Date
 | SEARCH
[NAME] | [NAME] | Vendor Phone No. | Contract Number | Line Item | Type of Service/Product | Valid Date | [NAME] | Status            (Days Remaining) | Contract Value | Delivery Timeframe | Unit cost
Spreadsheet: benjamin_rogers__928__PJM Operational Summaries
Sheet: 02-12-02

2002-02-12 08:00:30
 | Operations Summary for Today's Forecast Peak
A | Internal Scheduled Capacity | 44889
B | Scheduled Tie Flows | 3507
C | Capacity Adjustments | 0
D | Total Scheduled Capability | 48396
E | PJM Load Forecast | 37500
F | Operating Reserve | 10896
G | Unscheduled Capacity | 6264
 | Scheduled Tie Flow Breakdown
H | APS | 1525
I | FE | 1421
J | NYPP | -53
K | VP | 614
L | Total | 3507
M | Forecast Eastern Transfer Limit | 6400
N | Forecast Central Transfer Limit | 4100
O | Forecast Western Transfer Limit | 6000
 | Previous Periods Operation Summary
 |  | Day | Evening | Midnight
P | Hour | 1100 | 1900 | 300
Q | PJM  [NAME] | 33700 | 36700 | 22200
R | Actual  Load | 34400 | 37756 | 22202
S | West Dispatch Rate ($/MWhr) | 22.93 | 28.92 | 0
T | East Dispatch Rate ($/MWhr) | 22.93 | 28.92 | 0
Spreadsheet: 2f942ad1-ec3b-4c11-ac9f-36fbdf19fa96
Sheet: Sheet1

Computer and Information Science University Students Survey 2-16-12 | Computer and Information Science University Students Survey 2-16-12.1 | Computer and Information Science University Students Survey 2-16-12.2 | Computer and Information Science University Students Survey 2-16-12.3
I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student. | I am a current four-year college/university student.
Answer Options | Answer Options | Response Percent | Response Count
Yes | Yes | 0.8 | 4
No | No | 0.2 | 1
answered question | answered question | 5 | 5
skipped question | skipped question | 0 | 0
Spreadsheet: 544083d1508761365-multiplying-a-number-in-a-cell-containing-both-a-number-and-text-diet-planner
Sheet: Calculations

 |  |  | Food | Measure | Protein(Grams) | Carbs ([NAME] | Fats ([NAME]) | Fibre ([NAME]) | Calories | Total Serving
 |  | Breakfast |  |  |  |  |  |  |  | IF(ISNUMBER('Meal Planner(Day)'!F8,'Meal Planner(Day)'!F8*'Meal Planner(Day)'!Calculations!K10,VALUE(LEFT(TRIM('Meal Planner(Day)'!F8),FIND(" ",TRIM('Meal Planner(Day)'!F8),1)-1)))*'Meal Planner(Day)'!G8)
 |  | Lunch
 |  | Dinner
 |  | Supper
 |  | Snacks
Spreadsheet: 109511d1306343965-if-then-formula-tracking
Sheet: Sheet9

 |  |  |  |  |  |  |  |  | 1 | BYU | SFC. [NAME] | AD | YES
 |  |  |  |  |  |  |  |  | 2 | Dixie | SFC. DAHL | AR | NO
 |  |  |  |  |  |  |  |  | 3 | SUU | SFC. [NAME] | UTNG
 |  |  |  |  |  |  |  |  | 4 | USU | SFC. [NAME] | NG-Other
 |  |  |  |  |  |  |  |  |  | UVU | SFC. SANCHEZ
 |  |  |  |  |  |  |  |  |  | UofU | SSG. SMITH
 |  |  |  |  |  |  |  |  |  | Weber | SFC. TOBIN
Spreadsheet: 870420d1716934060-barclays-premier-league-best-11-for-2024-toty-23-24-premier-league-alif
Sheet: Sheet8

 |  |  |  | # | Player | Club
 |  |  |  | 1 | [NAME] | Arsenal FC
 |  |  |  | 2 | [NAME] | Liverpool FC
 |  |  |  | 3 | [NAME] | Manchester City
 |  |  |  | 4 | [NAME] | Manchester City
 |  |  |  | 5 | [NAME] | [NAME]
 |  |  |  | 6 | [NAME] | Liverpool FC
 |  |  |  | 7 | [NAME] | Liverpool FC
 |  |  |  | 8 | Heung-min Son | [NAME]
 |  |  |  | 9 | [NAME] | Newcastle United
 |  |  |  | 10 | [NAME] | Brighton & Hove Albion
 |  |  |  | 11 | Raheem Sterling | Chelsea FC
 |  |  |  | 12 | Alejandro Garnacho | [NAME]
 |  |  |  | 13 | [NAME] | Arsenal FC
 |  |  |  | 14 | Mykhaylo Mudryk | Chelsea FC
 |  |  |  | 15 | [NAME] | [NAME]
 |  |  |  | 16 | [NAME] | Newcastle United
 |  |  |  | 17 | Ansu Fati | Brighton & Hove Albion
 |  |  |  | 18 | [NAME] | [NAME]
 |  |  |  | 19 | [NAME] | [NAME]
 |  |  |  | 20 | Dango Ouattara | AFC Bournemouth
 |  |  |  | 21 | [NAME] | [NAME]
 |  |  |  | 22 | [NAME] | [NAME]
 |  |  |  | 23 | [NAME] | AFC Bournemouth
 |  |  |  | 24 | [NAME] | [NAME]
 |  |  |  | 25 | Manor [NAME] | [NAME]
 |  |  |  | 26 | [NAME] | [NAME]
 |  |  |  | 27 | [NAME] | Burnley FC
 |  |  |  | 28 | [NAME] | [NAME]
 |  |  |  | 29 | [NAME] | AFC Bournemouth
 |  |  |  | 30 | [NAME] | Burnley FC
 |  |  |  | 31 | [NAME] | West Ham United
 |  |  |  | 32 | Mikkel Damsgaard | [NAME]
 |  |  |  | 33 | Morgan Rogers | [NAME]
 |  |  |  | 34 | [NAME] | Burnley FC
 |  |  |  | 35 | [NAME] | Sheffield United
 |  |  |  | 36 | Willian | Fulham FC
 |  |  |  | 37 | [NAME] | Burnley FC
 |  |  |  | 38 | [NAME] | Chelsea FC
 |  |  |  | 39 | [NAME] | [NAME]
 |  |  |  | 1 | [NAME] | Arsenal FC
 |  |  |  | 2 | [NAME] | Manchester City
 |  |  |  | 3 | [NAME] | Liverpool FC
 |  |  |  | 4 | [NAME] | [NAME]
 |  |  |  | 5 | [NAME] | [NAME]
 |  |  |  | 6 | [NAME] | [NAME]
 |  |  |  | 7 | [NAME] | West Ham United
 |  |  |  | 8 | [NAME] | Crystal Palace
 |  |  |  | 9 | [NAME] | [NAME]
 |  |  |  | 10 | [NAME] | [NAME]
 |  |  |  | 11 | [NAME] | Brighton & Hove Albion
 |  |  |  | 12 | Antony | [NAME]
 |  |  |  | 13 | [NAME] | [NAME]
 |  |  |  | 14 | [NAME] | Chelsea FC
 |  |  |  | 15 | [NAME] | Manchester City
 |  |  |  | 16 | [NAME] | [NAME]
 |  |  |  | 17 | Solly March | Brighton & Hove Albion
 |  |  |  | 18 | [NAME] | [NAME]
 |  |  |  | 19 | [NAME] | Newcastle United
 |  |  |  | 20 | [NAME] | [NAME]
 |  |  |  | 21 | [NAME] | Fulham FC
 |  |  |  | 22 | Reiss [NAME] | Arsenal FC
 |  |  |  | 23 | [NAME] | Newcastle United
 |  |  |  | 24 | Pablo Sarabia | [NAME]
 |  |  |  | 25 | [NAME] | AFC Bournemouth
 |  |  |  | 26 | [NAME] | Liverpool FC
 |  |  |  | 27 | [NAME] | Fulham FC
 |  |  |  | 28 | Chiedozie Ogbene | [NAME]
 |  |  |  | 29 | [NAME] | Burnley FC
 |  |  |  | 30 | [NAME] | Burnley FC
 |  |  |  | 31 | [NAME] | [NAME]
 |  |  |  | 32 | [NAME] | Crystal Palace
 |  |  |  | 33 | [NAME] | [NAME]
 |  |  |  | 34 | [NAME] | Burnley FC
Spreadsheet: 788692d1658648479-using-concatenate-and-ifs-functions-to-convert-us-dates-into-british-dates-us-to-gb-date-conversion-problem
Sheet: Worksheet

DATE (US) | YEAR | MONTH | DAY | DATE (GB)
2021-12-01 | 2021 | 12 | 1
2021-12-02 | 2021 | 12 | 2
2021-12-03 | 2021 | 12 | 3
2021-12-06 | 2021 | 12 | 6
2021-12-07 | 2021 | 12 | 7
2021-12-08 | 2021 | 12 | 8
2021-12-09 | 2021 | 12 | 9
2021-12-10 | 2021 | 12 | 10
2021-12-13 | 2021 | 12 | 13
2021-12-14 | 2021 | 12 | 14
2021-12-15 | 2021 | 12 | 15
2021-12-16 | 2021 | 12 | 16
2021-12-17 | 2021 | 12 | 17
2021-12-20 | 2021 | 12 | 20
2021-12-21 | 2021 | 12 | 21
2021-12-22 | 2021 | 12 | 22
2021-12-23 | 2021 | 12 | 23
2021-12-29 | 2021 | 12 | 29
2021-12-30 | 2021 | 12 | 30
2022-01-04 | 2022 | 1 | 4
2022-01-05 | 2022 | 1 | 5
2022-01-06 | 2022 | 1 | 6
2022-01-07 | 2022 | 1 | 7
2022-01-10 | 2022 | 1 | 10
2022-01-11 | 2022 | 1 | 11
2022-01-12 | 2022 | 1 | 12
2022-01-13 | 2022 | 1 | 13
2022-01-14 | 2022 | 1 | 14
2022-01-17 | 2022 | 1 | 17
2022-01-18 | 2022 | 1 | 18
2022-01-19 | 2022 | 1 | 19
2022-01-20 | 2022 | 1 | 20
2022-01-21 | 2022 | 1 | 21
2022-01-24 | 2022 | 1 | 24
2022-01-25 | 2022 | 1 | 25
2022-01-26 | 2022 | 1 | 26
2022-01-27 | 2022 | 1 | 27
2022-01-28 | 2022 | 1 | 28
2022-01-31 | 2022 | 1 | 31
2022-02-01 | 2022 | 2 | 1
2022-02-02 | 2022 | 2 | 2
2022-02-03 | 2022 | 2 | 3
2022-02-04 | 2022 | 2 | 4
2022-02-07 | 2022 | 2 | 7
2022-02-08 | 2022 | 2 | 8
2022-02-09 | 2022 | 2 | 9
2022-02-10 | 2022 | 2 | 10
Spreadsheet: 59757d1260318114-league-spreadsheet-vs2_league_spreadsheet_test
Sheet: Results

Week | 2 | results |  |  |  |  |  |  | data entry |  | enter week number in B1
number of pairings |  | 5
team # | team name | rank | team members | previous average | Score | Spot | adj. Score | X's | points won | VS | team # | team name | rank | team members | previous average | Score | Spot | adjusted Score | x's | points won
 | 1
9 | amber | 1 | monkey | 278 | 285 | 8.8 | 293.8 | 5 | 1 |  | 10 | mauve | 1 | sheep | 289 | 286 | 0 | 286 | 4 | 0
 |  | 2 | sloth | 247 | 287 | 5.600000000000001 | 292.6 | 5 | 1 |  |  |  | 2 | goat | 254 | 284 | 0 | 284 | 4 | 0
 |  | 3 | dog | 245 | 281 | 0 | 281 | 4 | 0 |  |  |  | 3 | cow | 237 | 285 | 6.4 | 291.4 | 44 | 1
 | 2
8 | chartreuse | 1 | snake | 300 | 269 | 0 | 269 | 4 | 0 |  | 9 | amber | 1 | monkey | 278 | 285 | 17.6 | 302.6 | 5 | 1
 |  | 2 | lizzard | 284 | 254 | 0 | 254 | 14 | 0 |  |  |  | 2 | sloth | 247 | 287 | 29.6 | 316.6 | 5 | 1
 |  | 3 | gecko | 255 | 289 | 0 | 289 | 12 | 1 |  |  |  | 3 | dog | 245 | 281 | 8 | 289 | 4 | 0
 | 3
7 | pink | 1 | fawn | 289 | 291 | 8.8 | 299.8 | 5 | 1 |  | 8 | chartreuse | 1 | snake | 300 | 269 | 0 | 269 | 4 | 0
 |  | 2 | rabbit | 271 | 295 | 10.4 | 305.4 | 5 | 1 |  |  |  | 2 | lizzard | 284 | 254 | 0 | 254 | 14 | 0
 |  | 3 | deer | 260 | 265 | 0 | 265 | 4 | 0 |  |  |  | 3 | gecko | 255 | 289 | 4 | 293 | 12 | 1
 | 4
6 | orange | 1 | oliver | 300 | 554 | 0 | 554 | 10 | 1 |  | 7 | pink | 1 | fawn | 289 | 291 | 8.8 | 299.8 | 5 | 0
 |  | 2 | [NAME] | 234 | 512 | 29.6 | 541.6 | 57 | 1 |  |  |  | 2 | rabbit | 271 | 295 | 0 | 295 | 5 | 0
 |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A |  |  |  | 3 | deer | 260 | 265 | #N/A | #N/A | 4 | #N/A
 | 5
5 | purple | 1 | [NAME] | 282 | 561 | 14.4 | 575.4 | 54 | 1 |  | 6 | orange | 1 | oliver | 300 | 554 | 0 | 554 | 10 | 0
 |  | 2 | pete | 269.5 | 531 | 0 | 531 | 4 | 0 |  |  |  | 2 | [NAME] | 234 | 512 | 28.4 | 540.4 | 57 | 1
 |  | 3 | [NAME] | 253.5 | 550 | #N/A | #N/A | 57 | #N/A |  |  |  | 3 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | This sheet compares the results entered on the Scores Sheet for the week selected above and calculates who gets points
 | The points then need to be entered manually for each player in the Scores sheet.
 | No data entry here! All scores and points are entered on the Scores sheet!!
Spreadsheet: 49613d1248969286-creating-sheets-while-referencing-a-new-row-in-some-cells-sample-data4
Sheet: Data Tab

Sheet Name | Name | Address | city | state | zip | account | id# | type | amount 1 | amount 2 | amount 3 | amount 4 | amount 5 | amount 6 | amount 7 | amount 8 | amount 9 | amount 10 | Percentage
1 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | 0.01
2 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 53 | 54 | 55 | 56 | 57 | 58 | 59 | 60 | 61 | 62 | 0.0117
3 | Mon | [NAME] | Wed | Tue | [NAME] | Thu | Wed | [NAME] | Fri | Thu | [NAME] | Sat | Fri | [NAME] | Sun | Sat | [NAME] | Mon | 0.0125
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Spreadsheet: 92727d1292278109-scroll-bar-wont-stop-scrolling-scroll-bar-example-working
Sheet: mar_data

employee # | area | sales $
1111 | east | 78834.35902807747
1112 | east | 68174.49537320988
1113 | east | 99677.4225617886
1114 | east | 14055.86024671841
1115 | west | 58337.24574862637
1116 | west | 3548.252354626858
1117 | west | 4116.356378150265
1118 | northeast | 15396.44741538162
1119 | northeast | 88812.56631500261
1120 | northeast | 1208.779963534212
1121 | northeast | 69091.19389780551
1122 | northeast | 42972.53558311853
1123 | northwest | 97770.95232227416
1124 | northwest | 49400.14012608689
1125 | northwest | 56013.04545148084
1126 | southeast | 62268.94273987567
1127 | southeast | 71357.02347541237
1128 | southeast | 18059.0483714667
1129 | southeast | 82918.48222011943
1130 | southeast | 65776.3854297787
1131 | southeast | 47321.37118381683
1132 | southwest | 78942.15594515353
1133 | southwest | 45703.36261754291
1134 | southwest | 12579.48135636702
1135 | midwest | 71934.63663238821
1136 | midwest | 10992.45153864925
1137 | midwest | 39731.8173649482