tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: john_griffith__15626__Book1
Sheet: Sheet1

 |  |  | Natural Gas Straddles
 | Month | Strike | Bid | Offer | Mid-Pt. Vol | Net Change
 | M | 4.4 | 0.37 | 0.41 | 0.4781000000000011 | 0.02264999999999751
 | N | 4.45 | 0.62 | 0.66 | 0.4781000000000031 | 0.003599999999999604
 | Q | 4.55 | 0.82 | 0.86 | 0.4936000000000025 | 0.003299999999999637
 | U | 4.55 | 0.99 | 1.04 | 0.5041000000000021 | -0.005099999999999438
 | V | 4.6 | 1.16 | 1.21 | 0.5253000000000003 | 0.009299999999998976
 | X | 4.8 | 1.33 | 1.37 | 0.5238000000000018 | -0.000299999999999967
 | Z | 5 | 1.51 | 1.57 | 0.532100000000001 | -0.001799999999999802
 | F | 5.1 | 1.65 | 1.75 | 0.5408000000000012 | 0.000299999999999967
 | G | 4.95 | 1.7 | 1.8 | 0.5420000000000014 | 0.000299999999999967
 | H | 4.75 | 1.55 | 1.65 | 0.4904000000000007 | -0.003599999999999604
 | J | 4.45 | 1.17 | 1.27 | 0.3821000000000004 | -0.001499999999999835
 | K | 4.35 | 1.1 | 1.2 | 0.357500000000001 | 0.004499999999999504
 |  |  | 2001-05-07 09:29:56.440000
Spreadsheet: 672991d1587109570-if-formula-to-perform-vlookup-or-return-0-help-please-sample-workbook
Sheet: Current Analysis

DPT Current Excl Lunches/TL @ 50% |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Date/Dept |  | Shift Pattern |  | Utilisation
 |  |  |  |  |  |  | Week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Grand Total DPT |  | DPT Days
Day | Operator | Shifts | Days work | Hours Day | Days | Average Daily Hours | 1900-01-02 07:00:00 | 1900-01-02 08:00:00 | 1900-01-02 09:00:00 | 1900-01-02 10:00:00 | 1900-01-02 11:00:00 | 1900-01-02 12:00:00 | 1900-01-02 13:00:00 | 1900-01-02 14:00:00 | 1900-01-02 15:00:00 | 1900-01-02 16:00:00 | 1900-01-02 17:00:00 | 1900-01-02 18:00:00 | 1900-01-02 19:00:00 | 1900-01-02 20:00:00 | 1900-01-02 21:00:00 | 1900-01-02 22:00:00 | 1900-01-02 23:00:00 | 1900-01-03 00:00:00 | 1900-01-03 01:00:00 | 1900-01-03 02:00:00 | 1900-01-03 03:00:00 | 1900-01-03 04:00:00 | 1900-01-03 05:00:00 | 1900-01-03 06:00:00
TL @ 50% | JM | 0700-1500 | M-F | 7.5 | 5 | 7.5
SO | JK | 0700-1500 | M-F | 7.5 | 5 | 7.5
O | EM | 0700-1500 | M-F | 7.5 | 5 | 7.5
O | SP | 0700-1500 | M-F | 7.5 | 5 | 7.5
O | DK | 0700-1500 | M-F | 7.5 | 5 | 7.5
O | RC | 0700-1500 | M-F | 7.5 | 5 | 7.5
Evening |  | Shifts | Days work | Hours Day | hours | Average Daily Hours
TL @ 50% | JM | 1500-2300 | M-F | 7.5 | 5 | 7.5
SO | JK | 1500-2300 | M-F | 7.5 | 5 | 7.5
O | EM | 1500-2300 | M-F | 7.5 | 5 | 7.5
O | SP | 1500-2300 | M-F | 7.5 | 5 | 7.5
O | DK | 1500-2300 | M-F | 7.5 | 5 | 7.5
O | RC | 1500-2300 | M-F | 7.5 | 5 | 7.5
O | RC | 1500-2300 | M-F | 7.5 | 5 | 7.5
Night |  | Shifts | Days work | Hours Day | hours | Average Daily Hours
SO | SA | 2300-0700 | W/end | 7.5 | 2 | 7.5
O | EM | 2300-0700 | W/end | 7.5 | 2 | 7.5
Creative/Design
Creative Lead | LR | 1000-1800 | M-Th | 7.5 | 4
SO | JP | 2300-0700 | M-F | 7.5 | 5 | 7.5
O | RC | 1500-2300 | M-F | 7.5 | 5 | 7.5
Weekend |  | Shifts | Days work | Hours Day | hours | Average Daily Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | * Planned and unplanned abcences not factored in
SO | DB | 1200-2000 | W/end | 7.5 |  | 7.5
O | DK | 1200-2000 | W/end | 7.5 |  | 7.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AH
Creative
DPT Days
DPT Evenings
DPT Nights
DPT Weekend
 |  |  |  | * Planned and unplanned abcences not factored in
Spreadsheet: 43880d1242510167-reverse-data-in-columns-remedies-1-
Sheet: Sheet1

symptom | cure |  | Count of cure
aches | Small good Releif |  | symptom | cure | Total
aches | Big/Small Elixer |  | aches | Big/Small Elixer | 2
aches | Small good elixer |  |  | Small good elixer | 1
aches | Big/Small Elixer |  |  | Small good Releif | 1
aches |  |  | awake | Big/Small Elixer | 1
awake | Big/Small Elixer |  |  | Small good Releif | 1
awake | Small good Releif |  | discontent | Small good elixer | 1
awake |  |  |  | Small good Releif | 1
awake |  |  | hungry | Big Bad Relief | 1
awake |  |  |  | Big/Small Elixer | 2
discontent | Small good Releif |  |  | Small good elixer | 1
discontent | Small good elixer |  |  | Small good Releif | 1
discontent |  |  | irritated | Big/Small Elixer | 2
discontent |  |  |  | Small good Releif | 2
discontent |  |  | itchy | Big Bad Relief | 1
hungry | Big Bad Relief |  |  | Big/Small Elixer | 1
hungry | Small good Releif |  |  | Small good Releif | 1
hungry | Big/Small Elixer |  | pain | Big/Small Elixer | 1
hungry | Small good elixer |  |  | Small good Releif | 1
hungry | Big/Small Elixer |  | redness | Big Bad Relief | 1
irritated | Small good Releif |  |  | Big/Small Elixer | 1
irritated | Big/Small Elixer |  |  | Small good Releif | 1
irritated | Small good Releif |  | restless | Big Bad Relief | 1
irritated | Big/Small Elixer |  |  | Big/Small Elixer | 1
irritated |  |  | smelly | Big Bad Relief | 1
itchy | Big Bad Relief |  |  | Big Bad Relief | 1
itchy | Small good Releif |  |  | Big/Small Elixer | 1
itchy | Big/Small Elixer |  |  | Small good elixer | 1
itchy |  |  |  | Small good Releif | 1
itchy |  |  | soreness | Big Bad Relief | 1
pain | Small good Releif |  |  | Big/Small Elixer | 2
pain | Big/Small Elixer |  |  | Small good elixer | 1
pain |  |  |  | Small good Releif | 1
pain |  |  | thirsty | Big Bad Relief | 1
pain |  |  |  | Big elixer | 1
redness | Big Bad Relief |  |  | Small elixer | 1
redness | Small good Releif |  |  | Small Reliever | 1
redness | Big/Small Elixer |  | tired | Big Bad Relief | 1
redness |  |  |  | Big/Small Elixer | 2
redness |  |  |  | Small good Releif | 1
restless | Big Bad Relief |  | unaware | Big/Small Elixer | 2
restless | Big/Small Elixer
restless
restless
restless
smelly | Big Bad Relief
smelly | Small good Releif
smelly | Big/Small Elixer
smelly | Big Bad Relief
smelly | Small good elixer
soreness | Big Bad Relief
soreness | Small good Releif
soreness | Big/Small Elixer
soreness | Small good elixer
soreness | Big/Small Elixer
thirsty | Big elixer
thirsty | Small Reliever
thirsty | Small elixer
thirsty | Big Bad Relief
thirsty
tired | Big Bad Relief
tired | Small good Releif
tired | Big/Small Elixer
tired | Big/Small Elixer
tired
unaware | Big/Small Elixer
unaware | Big/Small Elixer
unaware
unaware
unaware
Spreadsheet: 288847d1389318133-consolidate-multiple-worksheets-into-one-reference-cover-sheet-excel-forum
Sheet: 9634

Recipient Created Tax Invoice
TO: | worker |  |  |  |  |  | FROM: | Work
 | worker |  |  |  |  |  |  | 123 Work
 | address |  |  |  |  |  |  | Work
 | WA | 6055 |  |  |  |  |  | WA | 6666
 | ABN: | abn |  |  |  |  |  | ABN: | 55 555 555 555
 | Vendor # | 9634
 | APPRENTICE DETAILS |  |  |  |  |  |  | Date: | 2014-01-10 00:00:00
 | Name: |  | [NAME] |  |  |  |  | Invoice #
 | Employee Number: |  | 12000 |  |  |  |  | FN Start
 | Apprenticeship: |  | [NAME] (3YR)
 | G/L Code: |  | 2108
 | 12000#9634
 | Date | Ordinary Hours | Ordinary $ Total | Travel $ Total | OT15 Hours | OT15 $ | OT20 Hours | OT20 $ | Meal | TOTAL
 | 2013-12-10 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-11 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-13 00:00:00 | 5 | 127.85 | 13.12 |  |  |  |  |  | 140.97
 | 2013-12-16 00:00:00 | 4 | 102.28 | 13.12 |  |  |  |  |  | 115.4
 | 2013-12-17 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 | 2013-12-18 00:00:00 | 8 | 204.56 | 13.12 |  |  |  |  |  | 217.68
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  | 0
 | Less Daily Subsidy | CTF |  |  |  |  |  |  |  | 6.730560000000001
 |  | ABBTF |  |  |  |  |  |  |  | 5.780759999999999
 |  | ABN DISCOUNTS |  |  |  |  |  |  |  | 0
 | Net Invoice |  |  |  |  |  |  |  |  | 1114.57868
 | GST |  |  |  |  |  |  |  |  | 111.457868
 | Total payable inclusive of GST |  |  |  |  |  |  |  |  | 1139.60132
Spreadsheet: 117514d1312838725-list-all-values-corresponding-to-another-column-aglove2189
Sheet: Sheet1

Input | User | UserID | UserCode |  | User | Output
35rtuser 45 | 35rtuser | 35rtuser:1 | 35rtuser 45 |  | 35rtuser | 35rtuser 45  22  33
40user 50 | 40user | 40user:1 | 40user 50 |  | 40user | 40user 50  55  22
35rtuser 22 | 35rtuser | 35rtuser:2 | 35rtuser 45  22
40user 55 | 40user | 40user:2 | 40user 50  55
40user 22 | 40user | 40user:3 | 40user 50  55  22
35rtuser 33 | 35rtuser | 35rtuser:3 | 35rtuser 45  22  33
Spreadsheet: 27868d1221582262-printing-only-filled-cells-printarea
Sheet: Sheet1

 | [NAME] in A refers directly to B, Add to B and A fills in and will be incorporated into Print_Area
120.6367930585741 | 120.6367930585741
379.6081282563338 | 379.6081282563338
237.0911054545655 | 237.0911054545655
77.41016928743205 | 77.41016928743205
350.9360718701756 | 350.9360718701756
148.8253369947081 | 148.8253369947081
219.2981250284852 | 219.2981250284852
332.5494047533905 | 332.5494047533905
73.36758304873925 | 73.36758304873925
148.696621668163 | 148.696621668163
455.1849030288053 | 455.1849030288053
476.5961458970582 | 476.5961458970582
256.412355008897 | 256.412355008897
331.4020423777362 | 331.4020423777362
305.1216917470576 | 305.1216917470576
205.7981478527942 | 205.7981478527942
249.2735622914007 | 249.2735622914007
221.3187638466767 | 221.3187638466767
177.2432382118967 | 177.2432382118967
311.5059790374125 | 311.5059790374125
405.8836264282206 | 405.8836264282206
288.7586515547382 | 288.7586515547382
4.380419084182741 | 4.380419084182741
125.7593257586956 | 125.7593257586956
188.0017761496003 | 188.0017761496003
471.1070652249534 | 471.1070652249534
348.1510742671525 | 348.1510742671525
297.363877704969 | 297.363877704969
16.30644050026175 | 16.30644050026175
251.2156530706867 | 251.2156530706867
294.592307214252 | 294.592307214252
Spreadsheet: 742603d1627913090-service-scheduler-that-prevents-double-booking-service-scheduler-example
Sheet: Service Outlook

PM | Job Name | Job Number | Location | On site Needed Date | Site Departure Date | Comments | Service Line(s) | Tech #1 | Tech #2 | Tech #3 | Tech #4 | Tech #5 | Tech #6 | [NAME]
 |  |  |  | 2021-07-12 00:00:00 | 2021-08-10 00:00:00 |  |  | Name 2 | Name 1 | Name 3
 |  |  |  | 2021-07-20 00:00:00 | 2021-07-31 00:00:00 |  |  | Name 2 |  |  |  |  |  |  | Name 2 is double booked for these dates
 |  |  |  | 2021-07-12 00:00:00 | 2021-07-16 00:00:00 |  |  | Name 1 |  |  |  |  |  |  | Name 1 is double booked for these dates
 |  |  |  | 2021-08-03 00:00:00 | 2021-08-06 00:00:00 |  |  | Name 5 | Name 6 | Name 7
 |  |  |  | 2021-07-19 00:00:00 | 2021-08-08 00:00:00 |  |  | Name 8
 |  |  |  | 2021-08-18 00:00:00 | 2021-09-01 00:00:00 |  |  | Name 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insert New Lines Above Here
Spreadsheet: 295044d1391577962-automatically-fitering-values-through-based-on-a-criteria-database-and-constituent-tabs
Sheet: Victoria

 |  |  | Category | List A | List B | List C
 |  |  | Category | List A | List B | List C
 |  |  | A | 0.367089517588567 | 0.2004199707822576 | 0.5642164971521103
 |  |  | B | 0.6866906612341263 | 0.9998021785803782 | 0.07577003464536625
 |  |  | C | 0.3586075039024669 | 0.8944862727421745 | 0.8546364670883694
 |  |  | D | 0.9618628787092993 | 0.40216863136179 | 0.1209537209759846
 |  |  | E | 0.8937803475639466 | 0.4487979585836039 | 0.9517168393507838
 |  |  | F | 0.295242874192561 | 0.3820738826591505 | 0.8318062084577288
Spreadsheet: 837546d1690225541-match-a-name-with-two-columns-then-displaying-the-most-recent-number-excelformula-solution-
Sheet: Hoja4

AbderrahmanW. | ScottA. | 2022-06-01 00:00:00 |  | 1500 | 1500 | 0 | 0 | 0 |  |  |  |  |  |  | 1516 | 1484 | 1
AbderrahmanW. | AlvarezM. | 2022-06-02 00:00:00 |  | 1516 | 1500 | 0 | 1 | 1 |  |  |  |  |  |  | 1531 | 1485 | 2
AbderrahmanW. | MarkovaJ. | 2022-06-03 00:00:00 |  | 1531 | 1500 | 0 | 2 | 2 |  |  |  |  |  |  | 1546 | 1485 | 3
AbderrahmanW. | PonwithN. | 2022-06-04 00:00:00 |  | 1545 | 1500 | 0 | 3 | 3 |  |  |  |  |  |  | 1559 | 1486 | 4
AbderrahmanW. | AyukawaM. | 2022-06-05 00:00:00 |  | 1559 | 1500 | 0 | 4 | 4 |  |  |  |  |  |  | 1572 | 1487 | 5
AbderrahmanW. | OmaeA. | 2022-06-06 00:00:00 |  | 1572 | 1500 | 0 | 5 | 5 |  |  |  |  |  |  | 1585 | 1487 | 6
AbderrahmanW. | MiL. | 2022-06-07 00:00:00 |  | 1585 | 1500 | 0 | 6 | 6 |  |  |  |  |  |  | 1597 | 1488 | 7
AbderrahmanW. | RyserV. | 2022-06-08 00:00:00 |  | 1597 | 1500 | 0 | 7 | 7 |  |  |  |  |  |  | 1609 | 1488 | 8
AbderrahmanW. | HenningB. | 2022-06-09 00:00:00 |  | 1620 | 1500 | 0 | 8 | 8 |  |  |  |  |  |  | 1631 | 1489 | 9
AbderrahmanW. | BursulayaS. | 2022-06-10 00:00:00 |  | 1631 | 1500 | 0 | 9 | 9 |  |  |  |  |  |  | 1641 | 1490 | 10
ConwayJ. | AbderrahmanW. | 2022-06-11 00:00:00 |  | 1500 | 1641 |  |  |  |  |  |  |  |  |  | 1522 | 1619
CooperL. | AbderrahmanW. | 2022-06-12 00:00:00 |  | 1500 | 1619 |  |  |  |  |  |  |  |  |  | 1521 | 1598
CorseJ. | AbderrahmanW. | 2022-06-13 00:00:00 |  | 1500 | 1598 |  |  |  |  |  |  |  |  |  | 1520 | 1578
CossuM. | AbderrahmanW. | 2022-06-14 00:00:00 |  | 1500 | 1578 |  |  |  |  |  |  |  |  |  | 1520 | 1558
CozbinovA. | AbderrahmanW. | 2022-06-15 00:00:00 |  | 1500 | 1558 |  |  |  |  |  |  |  |  |  | 1519 | 1539
[NAME] | AbderrahmanW. | 2022-06-16 00:00:00 |  | 1500 | 1539 |  |  |  |  |  |  |  |  |  | 1518 | 1521
DougazA. | AbderrahmanW. | 2022-06-17 00:00:00 |  | 1500 | 1521 |  |  |  |  |  |  |  |  |  | 1517 | 1504
Spreadsheet: 2178852d-16ef-41cb-be22-554ffdd37878
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-04-06 09:09:19.380000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
5.25 | 101.702 | 101.452 | 101.327 | 100.952 |  | and are added to price quote
5.125 | 100.744 | 100.494 | 100.369 | 99.994
5 | 100.306 | 100.056 | 99.931 | 99.556 |  | Note: | Refer To Price [NAME]
4.875 | 99.813 | 99.563 | 99.438 | 99.063 |  |  | For all Price Adjs
4.75 | 98.793 | 98.543 | 98.418
4.625 | 97.561 | 97.311 | 97.186
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.5 | 101.282 | 101.032 | 100.907 | 100.532
4.375 | 100.892 | 100.642 | 100.517 | 100.142
4.25 | 100.318 | 100.068 | 99.943 | 99.568
4.125 | 99.131 | 98.881 | 98.756 | 98.381
4 | 98.786 | 98.536 | 98.411
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-04-20 09:09:19.380000
30 DAY | 2011-05-05 09:09:19.380000
45 DAY | 2011-05-20 09:09:19.380000
60 DAY | 2011-06-04 09:09:19.380000
90 DAY | 2011-07-04 09:09:19.380000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 160583d1339125353-attempting-to-interpolate-from-a-table-interpolation-help
Sheet: Sheet1

 | Temperature
Pressure Altitude | 0° | 10° | 20° | 30° | 40°
0 | 640 | 695 | 755 | 810 | 875
1000 | 705 | 765 | 825 | 890 | 960
2000 | 775 | 840 | 910 | 980 | 1055
3000 | 855 | 925 | 1000 | 1080 | 1165
4000 | 940 | 1020 | 1100 | 1190 | 1285
5000 | 1040 | 1125 | 1215 | 1315 | 1420
6000 | 1145 | 1245 | 1345 | 1455 | 1570
7000 | 1270 | 1375 | 1490 | 1615 | 1745
8000 | 1405 | 1525 | 1655 | 1795 | 1940
 |  | If Altitude is 1000, and Temperature is 10 degrees:
 | Response: | 765 | (From Chart)
 |  | If Altitude is 1500 and Temperature is 20 degrees:
 |  | 867.5
 |  | If Altitude is 4367 and Temperature is 23 degrees:
 |  | *FORMULA UNKNOWN*
 |  | **Above requires a formula to interpolate between chart
Spreadsheet: 793808d1661755563-count-how-often-a-value-occurs-per-week-2022-08-28-oeldere-eugz-calculation
Sheet: Tabel1

Cat | Group | Date | value1 | value2 | value3 | value4 | [NAME] |  |  |  | [NAME] | Complete
A | Member | 44774 | 0 | 8 | 7 | 4 | Cancel |  |  |  | Kolom12 | Member
A | Member | 44774 | 0 | 8 | 7 | 4 | Complete
A | Member | 44774 | 0 | 8 | 7 | 4 | Complete |  |  |  | Rijlabels | Aantal [NAME]
A | Member | 44774 | 0 | 8 | 7 | 4 | Cancel |  |  |  | A | 2
A | Member | 44774 | 0 | 8 | 7 | 4 | sa |  |  |  | B | 4
C | Claim | 44778 | 0 | 8 | 7 | 4 | Complete |  |  |  | C | 3
C | Claim | 44778 | 0 | 8 | 7 | 4 | Complete |  |  |  | D | 3
C | Claim | 44778 | 0 | 8 | 7 | 4 | Complete |  |  |  | Eindtotaal | 12
C | Claim | 44778 | 0 | 8 | 7 | 4 | Complete
C | Claim | 44778 | 0 | 8 | 7 | 4 | ds
B | Member | 44776 | 0 | 8 | 7 | 4 | Complete
B | Member | 44776 | 0 | 8 | 7 | 4 | Complete
B | Member | 44776 | 0 | 8 | 7 | 4 | Complete
B | Member | 44776 | 0 | 8 | 7 | 4 | Complete
B | Member | 44776 | 0 | 8 | 7 | 4 | fd
D | Member | 44787 | 1 | 8 | 7 | 4 | Panding
D | Member | 44787 | 1 | 8 | 7 | 4 | Panding
D | Member | 44787 | 1 | 8 | 7 | 4 | Panding
D | Member | 44787 | 1 | 8 | 7 | 4 | Panding
D | Member | 44787 | 1 | 8 | 7 | 4 | sa
A | Claim | 44777 | 1 | 3 | 5 | 0 | Complete
A | Claim | 44777 | 1 | 3 | 5 | 0 | Complete
A | Claim | 44777 | 1 | 3 | 5 | 0 | Panding
A | Claim | 44777 | 1 | 3 | 5 | 0 | Panding
A | Claim | 44777 | 1 | 3 | 5 | 0 | rf
C | Member | 8/222022 | 1 | 3 | 5 | 0 | Complete
C | Member | 8/222022 | 1 | 3 | 5 | 0 | Complete
C | Member | 8/222022 | 1 | 3 | 5 | 0 | Cancel
C | Member | 8/222022 | 1 | 3 | 5 | 0 | Complete
C | Member | 8/222022 | 1 | 3 | 5 | 0 | hg
B | Claim | 8/202023 | 5 | 3 | 5 | 0 | Panding
B | Claim | 8/202023 | 5 | 3 | 5 | 0 | Panding
B | Claim | 8/202023 | 5 | 3 | 5 | 0 | Panding
B | Claim | 8/202023 | 5 | 3 | 5 | 0 | Cancel
B | Claim | 8/202023 | 5 | 3 | 5 | 0 | fd
D | Member | 44801 | 5 | 3 | 9 | 2 | Complete
D | Member | 44801 | 5 | 3 | 9 | 2 | Cancel
D | Member | 44801 | 5 | 3 | 9 | 2 | Complete
D | Member | 44801 | 5 | 3 | 9 | 2 | Complete
D | Member | 44801 | 5 | 3 | 9 | 2 | gg
B | Member | 44792 | 5 | 2 | 9 | 2 | Cancel
B | Member | 44792 | 5 | 2 | 9 | 2 | Cancel
B | Member | 44792 | 5 | 2 | 9 | 2 | Cancel
B | Member | 44792 | 5 | 2 | 9 | 2 | Cancel
B | Member | 44792 | 5 | 2 | 9 | 2 | rr
M | Other | 44804 | 5 | 2 | 9 | 2 | Complete
M | Other | 44804 | 5 | 2 | 9 | 2 | Complete
M | Other | 44804 | 5 | 2 | 9 | 2 | Complete
M | Other | 44804 | 5 | 2 | 9 | 2 | Complete
M | Other | 44804 | 5 | 2 | 9 | 2 | tt
Spreadsheet: 868762d1715438650-help-me-find-the-way-or-formula-help
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | if more than >=1200 red, if not green
 |  |  |  |  |  |  |  |  |  | Data | Result
 |  |  |  |  |  |  |  |  |  | 1400 | 1400
 |  |  |  |  |  |  |  |  |  | 1100 | 1100
 |  |  |  |  |  |  |  |  |  | 1200 | 1200
 |  |  |  |  |  |  |  |  |  | 1300 | 1300
 |  |  |  |  |  |  |  |  |  | 1700 | 1700
 |  |  |  |  |  |  |  |  |  | 900 | 900
 |  |  |  |  |  |  |  |  |  | 800 | 800
 |  |  |  |  |  |  |  |  |  | 1000 | 1000
 |  |  |  |  |  |  |  |  |  | 700 | 700
 |  |  |  |  |  |  |  |  |  | 600 | 600
 |  |  |  |  |  |  |  |  |  | 1200 | 1200
Spreadsheet: 33962d1230929158-new-idea-on-creating-excel-files-to-automatically-determine-proper-entry-john-eastland-example-sheet-with-edward-bentley-sum-if-function-later-version-of-excel-revised
Sheet: 416 TH

 | Key Employee | Account Balance | Allocation as% of Comp. | Forfeiture Allocation
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 |  |  | 0.15
 | Totals
 | [NAME]
Spreadsheet: 36225d1234035945-creating-a-scoresheet-scoresheet-test2
Sheet: TOTALS

GIRLS
PLACE | FIRST NAME | LAST NAME | ID# | RACE1 | RACE2 | [NAME] | RACE4 | RACE5 | RACE6 | SUB TOTAL | MINIMUM ONE | MINIMUM TWO | ADJUSTED TOTAL | GENDER | SCHOOL
1 | Katrin | Larusson | 1456 | 60 | 59 | 60 | 60 | 57 | 0 | 239 | 57 | 59 | 123 | F | AC
2 | Laurel | Fiddler | 1428 | 59 | 60 | 59 | 59 | 60 | 0 | 237 | 59 | 59 | 119 | F | MM
3 | Olivia | Duner | 1531 | 0 | 57 | 58 | 58 | 58 | 0 | 173 | 57 | 58 | 58 | F | AC
4 | [NAME] | [NAME] | 1454 | 52 | 58 | 57 | 54 | 56 | 0 | 221 | 52 | 54 | 115 | F | AC