tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273937d1382969866-problem-with-nested-ifs-and-something-else-1234567890
Sheet: Sheet1

 | NAMENAMENAME |  | 12345
 | Big Stuff |  |  |  |  |  |  | Lil' stuff
DATE | Model | Price | Qty. | Bonuses | Check numb. |  | DATE | Model | Price | Qty. | Bonuses | Check numb.
2013-08-30 00:00:00 | ESF 6630 ROX | 420 | 1 |  | 73696 |  | 2013-08-30 00:00:00 | ZEO 5430 | 69.99 | 1 |  | 73692
2013-09-01 00:00:00 | EN 2900 ADX | 249.99 | 1 |  | 4680 |  | 2013-08-30 00:00:00 | ZB 2941 | 119.99 | 1 |  | 4238
2013-09-07 00:00:00 | EN 2900 ADW | 212.49 | 1 |  | 101273 |  | 2013-08-31 00:00:00 | ZB 2943 | 119.99 | 1 |  | 73763
2013-09-08 00:00:00 | EC 220 | 209 | 1 |  | 101366 |  | 2013-08-31 00:00:00 | [NAME] | 99.99 | 1 |  | 73792
2013-09-08 00:00:00 | EN 3450 AOW | 322.99 | 1 |  | 75208 |  | 2013-08-31 00:00:00 | [NAME] | 99.99 | 1 |  | 73806
2013-09-08 00:00:00 | EOC 69400X | 509.99 | 1 |  | 75212 |  | 2013-09-01 00:00:00 | ZUS 3932 G | 149.99 | 1 |  | 101049
2013-09-08 00:00:00 | EN 2900 ADW | 212.49 | 1 |  | 5943 |  | 2013-09-01 00:00:00 | ZUS 3932 G | 149.99 | 1 |  | 101049
2013-09-08 00:00:00 | EWW 1686 HDW | 526 | 1 |  | 5950 |  | 2013-09-06 00:00:00 | ZUP 3820 B | 111.99 | 1 |  | 4582
2013-09-13 00:00:00 | EN 3401 AOW | 299.99 | 1 |  | 75837 |  | 2013-09-06 00:00:00 | Z 8870 | 191.99 | 1 |  | 5612
2013-09-14 00:00:00 | EDH 3386 GDW | 489 | 1 |  | 6955 |  | 2013-09-07 00:00:00 | ZEO 5410 | 41.99 | 1 |  | 101246
2013-09-15 00:00:00 | EWW 1486 HDW | 499.99 | 1 |  | 7062 |  | 2013-09-07 00:00:00 | ZB 5012 | 84.99 | 1 |  | 101279
2013-09-27 00:00:00 | EWP 1074 TDW | 239.99 | 1 |  | 8993 |  | 2013-09-07 00:00:00 | ESTM 6400 | 47.99 | 1 |  | 101246
2013-09-28 00:00:00 | EKC 51100 OW | 249 | 1 |  | 77699 |  | 2013-09-14 00:00:00 | EFB 60550 BX | 269.99 | 1 |  | 6931
2013-09-28 00:00:00 | EN 3450 AOW | 349 | 1 |  | 77699 |  | 2013-09-15 00:00:00 | Z 8870 | 239.99 | 1 |  | 7062
2013-09-28 00:00:00 | EWW 1786 HDW | 629.99 | 1 |  | 2456 |  | 2013-09-15 00:00:00 | [NAME] | 69 | 1 |  | 76131
2013-09-29 00:00:00 | EWT 1266 EDW | 329.99 | 1 |  | 3259 |  | 2013-09-15 00:00:00 | ZE 320 A | 85 | 1 |  | 7104
2013-09-29 00:00:00 | T76280 AC | 479.99 | 1 |  | 77940 |  | 2013-09-28 00:00:00 | ZB 2943 | 119.99 | 1 |  | 77765
TOTAL: |  |  |  |  |  |  | TOTAL:
DATE | Hours | Big stuff | Lil' stuff |  | Bonus calculation | Item price | Bonus Ls
2013-08-30 00:00:00 | 4h |  |  |  | Big stuff | 250 Ls | 2
2013-08-31 00:00:00 | 4h |  |  |  | Big stuff | 300-450 | 3.5
2013-09-01 00:00:00 | 4h |  |  |  | Big stuff | 450 - 700 | 5
2013-09-06 00:00:00 | 4h |  |  |  | Big stuff | 700-1000 Ls | 7.5
2013-09-07 00:00:00 | 4h |  |  |  | Little stuff | 90 Ls | 1.5
2013-09-08 00:00:00 | 4h |  |  |  | Little stuff | 120 Ls | 3
2013-09-13 00:00:00 | 4h
2013-09-14 00:00:00 | 4h |  |  |  | Minimum requirements on big stuff, to claim a bonus - 3 sold items a day or 355Ls a day.
2013-09-15 00:00:00 | 4h |  |  |  | Minimum requirements on little stuff, to claim a bonus - 3 sold items a day or 120Ls a day.
2013-09-27 00:00:00 | 4h
2013-09-28 00:00:00 | 4h
2013-09-29 00:00:00 | 4h
Spreadsheet: lindy_donoho__22196__sharris1101wk2
Sheet: Current Est Vs. Forecast

($[NAME])
November:  11/01/01 thru 11/12/01 |  |  |  |  |  | 2001-11-15 12:29:08.950000
Current Estimate vs. Forecast |  | November, 2001
 |  | 3rd Current | Weekly
 |  | Estimate | Forecast | [NAME] |  | Comments
West Demand Revenues |  | 9.234 | 9.133 | -0.1010000000000009 |  | USGT $0K,  Astra $0K Negotiated Rate
West Commodity Revenues |  | 0.7917959999999997 | 0.7353780000000008 | -0.05641799999999897 |  | Lower West Volumes; West IT deals $4K
East Demand Revenues |  | 1.397 | 1.483 | 0.08600000000000008 |  | Assumed [NAME] turn back in November
East Commodity Revenues |  | 0.157 | 0.2009999999999998 | 0.04399999999999982 |  | Higher Volumes & Higher IT Rates
[NAME] |  | 0.659 | 0.688 | 0.02899999999999991 |  | New Contract: Burlington; Reliant $13K
[NAME] Revenues |  | 0.08599999999999997 | 0.07000000000000006 | -0.0159999999999999 |  | Lower IT Volumes
PNR Revenues |  | 0 | 0.04368375 | 0.04368375
Revenue Variance |  | 12.324796 | 12.35406175 | 0.02926575000000042
Fuel Price [NAME] |  | 0.61 | 0.578 | -0.03200000000000003 |  | MTD index price of $2.40 vs. 3nd CE index price of $2.53
Fuel Volume Variance-Unhedged |  | 0 | -0.209 | -0.209 |  | Lower retained volumes
Sales Margin Variance on Unhedged |  | 0 | 0.007 | 0.007 |  | Over-retained fuel sales
Hedging Adjustment |  | 2.135 | 2.135 | 0
Other Adjustment |  | -0.001 | 0 | 0.001
Fuel Variance (Excludes UAF) |  | 2.744 | 2.512 | -0.233
Current Month Margin Variance |  | 15.068796 | 14.86606175 | -0.2037342499999996
Expenses |  | -0.786 | -0.786 | 0
Non-Recurring |  | 0 | 0 | 0
Other |  | -0.005 | -0.005 | 0
Total Current Month Variance |  | 14.277796 | 14.07506175 | -0.2037342499999996
October Actuals |  | 15.122 | 15.682 | 0.56
[NAME] |  | 48.063 | 46.909 | -1.154000000000003 |  | Includes OBA revaluation for August & September
2nd Qtr |  | 52.348 | 52.348 | 0
1st Qtr |  | 47.819 | 47.819 | 0
November 30, 2001 YTD |  | 177.629796 | 176.83306175 | -0.7977342500000025 |  | Includes October Actuals
Spreadsheet: 52566d1252419734-vlookup-with-duplicate-reference-numbers-book2
Sheet: vlookup

ref num |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | update
573206025 | FLAT | 36 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | on
390075 |  | 94 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
573206025 | FLAT | 36 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
390075 |  | 94 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
573206025 | FLAT | 36 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
390075 |  | 94 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
573206025 | FLAT | 36 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | dup
Spreadsheet: 162617d1340011050-how-to-use-the-index-match-function-to-capture-several-rows-with-one-matching-column-value-example-of-print-challenge
Sheet: Sheet1

School | Teacher Surname |  | School2 |  | Teacher Surnames from School in CellD1
School1 | TeacherA
School1 | TeacherB
School1 | TeacherC |  |  |  |  | want to be blank as Teacher F is not at School2
School2 | [NAME] |  |  |  |  | want to be blank as Teacher G is not at School2
School2 | TeacherE
School3 | TeacherF
School3 | TeacherG
Spreadsheet: 7390e8b3-c4c6-450c-87a1-d85361d23ad4
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
MTHFR | Test | MTHFR | 5,10-Methylenetetrahydrofolate Reductase C677T, Mutation, Blood | MTHFR C677T Mutation Analysis, B | Direct Mutation Analysis | Yellow-Top (ACD) Tube: ACD |  |  | 6 | mL | Container/Tube:  Preferred: Yellow top (ACD solution B) Acceptable: Lavender top (EDTA) or blue top (sodium citrate) [NAME]: Full tube Collection Instructions:  1. Invert several times to mix blood.  2. Send specimen in original tube. Additional Information: Can be combined with other molecular coagulation tests: -61730/MTHAC 5,10-Methylenetetrahydrofolate Reductase A1298C, Mutation, Blood -81419/F5DNA Factor V Leiden (R506Q) Mutation, Blood -81742/PTNT Prothrombin G20210A Mutation, Blood -61367/MTHP 5,10-Methylenetetrahydrofolate Reductase C677T and A1298C Mutations, Blood Forms: 1. Coagulation Patient Information Sheet (Supply T675) is available in Special Instructions 2. New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 1 mL in a 3-mL ACD tube | Hemolysis	Mild OK; Gross OK Thawing	Warm OK; Cold OK - phone lab Lipemia	Mild OK; [NAME] OK Icterus	NA Other	Green top (heparin) tube | Negative | Tuesday; 1 p.m. | 3 days | 5 days | 1 | 81291 |  |  |  |  | Rochester
MTHFR | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
MTHFR | Result | 21827 | [NAME], B | [NAME], B | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21709-1
MTHFR | Result | 21828 | MTHFR Interpretation | MTHFR Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9
MTHFR | Result | 21830 | MTHFR Reviewed By | MTHFR Reviewed By | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 766870d1644128080-multiple-rows-into-one-column-google-sheets-and-excel-teachers-and-students
Sheet: Sheet 1

Teacher ID | STUDENT1 ID | STUDENT2 ID | STUDENT3 ID | STUDENT4 ID | STUDENT5 ID | STUDENT6 ID | STUDENT7 ID | STUDENT8 ID | STUDENT9 ID | STUDENT10 ID | STUDENT11 ID | STUDENT12 ID | STUDENT13 ID |  | TEACHER ID | STUDENT ID
60957 | 569498 | 567882 | 683292 | 615818 | 317197 | 679689 | 673591 | 306357 | 307587 | 684986 | 600479 | 568861 | 600117
61244 | 404971 | 724404 | 722805 | 615817 | 684474 | 615776 | 681581 | 304993 | 636606 | 631893 | 685913 | 315949 | 602958
64996 | 563954 | 564470 | 564833 | 565465 | 568271 | 568936 | 568936 | 615731 | 632233 | 632249 | 634665 | 634803 | 637666
62330 | 633582 | 682508 | 559577 | 591389 | 737432 | 567181 | 686343 | 1047590 | 804743 | 671375 | 565429 | 692134 | 612771
64721 | 713261 | 656311 | 689860 | 691369 | 491563 | 684868 | 686678 | 564169 | 521232 | 564519 | 689363 | 601086 | 692000
70455 | 711751 | 604069 | 684114 | 637164 | 567994 | 304578 | 305122 | 305120 | 565455 | 566918 | 635153 | 304582 | 686630
62328 | 635148 | 568999 | 637388 | 570366 | 679868 | 564593 | 794071 | 430013 | 696793 | 663730 | 633506 | 691066 | 690247
61988 | 713261 | 686134 | 684685 | 711757 | 898741 | 559537 | 568284 | 459301 | 566632 | 590264 | 689884 | 635734 | 636435
61264 | 318039 | 398845 | 682005 | 683327 | 615842 | 683932 | 716907 | 711951 | 694713 | 568270 | 733486 | 596221 | 724379
Spreadsheet: 92669d1292250566-2010-to-2003-error-fire-dvd2
Sheet: Overview

2010-12-01 00:00:00
 | Jobs | Not Scheduled | All Done | All Done or Scheduled | % Done/Scheduled |  | [NAME] after 1st
[NAME] | 124 | 0 | 110 | 14 | 1 |  | 0
[NAME] | 131 | 0 | 116 | 15 | 1
[NAME] | 120 | 0 | 109 | 11 | 1
[NAME] | 80 | 0 | 68 | 12 | 1
[NAME] | 40 | 0 | 34 | 6 | 1
[NAME] | 23 | 0 | 8 | 15 | 1
Blank | 0 | 0 | 0 | 0
 | 518 | 0 | 445 | 73
Spreadsheet: 805318d1668619968-sumif-wildcards-not-working-sumif-wildcard
Sheet: Sheet1

 |  |  | Task Number | Hours | Resource Name
 |  |  | 1.3 | 4 | [NAME] |  |  |  | Name | Hours
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  |  | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME] |  |  | I know wildcards don't work on numbers but this
 |  |  | 1.3 | 4 | [NAME] |  |  | still doesn’t work when I convert the column type to Text
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 6 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3 | 4 | [NAME]
 |  |  | 1.3.2 | 0.5 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 3 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 3 | [NAME]
 |  |  | 1.3.2 | 0 | [NAME]
 |  |  | 1.3.2 | 0 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 2 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
 |  |  | 1.3.2 | 4 | [NAME]
Spreadsheet: 9c9dadc9-09fe-4233-83c8-aba9bc6bd017
Sheet: Sheet1

1.4.4 - Evolución del gasto total en consumo de los hogares por grupos de gasto. En millones de euros. 1998-2006 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006
Alimentos y bebidas no alcohólicas | 40732.56 | 42051.35 | 46282.81 | 49542.25 | 52848.46 | 56206.90629 | 58145.24618 | 61028.35000999999 | 65435.74138
[NAME], tabaco y narcóticos | 5587.81 | 5648.66 | 6213.87 | 6612.39 | 6762.87 | 7123.48909 | 7609.4037 | 7724.956429999999 | 8301.352490000001
[NAME] y calzado | 15629.72 | 17158.02 | 19424.52 | 20775.11 | 21335.95 | 21432.56878 | 22649.39097 | 24668.71787 | 31059.83412
[NAME], agua, [NAME], gas y otros combustibles | 64864.85 | 71802.49 | 78566.39 | 85155.72 | 92709.59 | 99737.77225 | 108136.26483 | 121657.72369 | 122997.42401
Mobiliario, equipamiento del hogar y gastos corrientes de conservación de la vivienda | 10181.71 | 10509.96 | 12800.9 | 13581.08 | 13908.45 | 14694.86517 | 15277.05413 | 17052.96463 | 26943.74435
Salud | 5100.8 | 5216.62 | 5530.62 | 5990.68 | 6003.35 | 6631.17416 | 7553.41882 | 8166.82108 | 13419.31818
Transportes | 25533.38 | 27319.54 | 29699.5 | 32120.31 | 30869.62 | 31008.58028 | 35489.29499 | 40399.95445 | 66714.1681
Comunicaciones | 4109.89 | 4553.15 | 5088.42 | 5939.75 | 6734.3 | 7580.77609 | 8843.72875 | 10242.62603 | 13577.68239
Ocio, [NAME] | 12654.64 | 13032.09 | 15575.68 | 16883.23 | 17269.31 | 18288.07565 | 20790.8402 | 22706.9156 | 31454.40506
Enseñanza | 2904.73 | 3051.22 | 3204.13 | 3241.49 | 3397.12 | 3542.47097 | 3611.41681 | 3814.6903 | 4305.51878
Hoteles, cafés y restaurantes | 19230.34 | 20063.93 | 22927.6 | 24723.1 | 25654.02 | 28073.69221 | 30124.05286 | 32616.01205 | 44765.79556000001
Otros bienes y servicios | 10911.19 | 11868.86 | 14612.06 | 16633.58 | 17639.04 | 18818.81322 | 20872.98319 | 22840.7044 | 37083.25458
Total | 217441.62 | 232275.89 | 259926.5 | 281198.69 | 295132.08 | 313139.1841600001 | 339103.09543 | 372920.43654 | 466058.239
Fuente: Elaboración [NAME] a partir de INE, Encuesta continua de presupuestos familiares. Resultados anuales (publicación electrónica), varios años; y datos INE.
Spreadsheet: 274470d1383130445-separating-out-row-excel-fourm
Sheet: Step-3

Row | Column | Value
1010 | S | 1
1010 | M | 2
1010 | L | 1
1010 | XL | 2
1011 | S | 4
1011 | M | 4
1011 | L | 2
1011 | XL | 2
1012 | S | 2
1012 | M | 1
1012 | L | 0
1012 | XL | 1
Spreadsheet: 274531d1383144271-help-with-sumifs-formula-projects
Sheet: Projects

[NAME]. | USD Amount | Date
52445 | 37219.28 | 2014-03-27 00:00:00
54200 | 5600 | 2014-03-27 00:00:00
54200 | 12320 | 2014-03-27 00:00:00
54200 |  | 2013-11-30 00:00:00
52836 |  | 2014-03-30 00:00:00
52836 |  | 2014-05-27 00:00:00
52836 |  | 2014-06-27 00:00:00
53230 |  | 2014-01-15 00:00:00
53230 |  | 2014-02-15 00:00:00
53230 |  | 2014-01-15 00:00:00
53230 |  | 2014-02-15 00:00:00
53230 |  | 2014-01-15 00:00:00
53230 |  | 2014-02-15 00:00:00
54299 | 80984.53 | 2014-02-10 00:00:00
52458 | 5000 | 2014-04-10 00:00:00
55500 | 7264 | 2014-09-30 00:00:00
53458 | 3230 | 2014-08-14 00:00:00
53254 | 4500 | 2014-03-13 00:00:00
53068 | 100000 | 2014-02-15 00:00:00
Spreadsheet: 780456d1652459385-getting-an-error-code-when-trying-to-add-more-conditions-columns-to-an-if-statement-calendar-draft
Sheet: 10 Events Per Day Monthly View

2022 |  | COMLEX-USA
June
Spreadsheet: 02036122-71bc-4b90-b9a0-d60c95816e0e
Sheet: my college budget

Income
 | my college budget
 | percentage of income spent
 | net monthly income
 | net monthly expenses
 | balance
 | monthly income |  |  | monthly expenses |  |  | semester expenses *
 | Item | Amount |  | Item | Amount |  | Item | Amount | Per Month
 | Fixed income | 1500 |  | Rent | 20 |  | Tuition | 750
 | Financial aid | 500 |  | Utilities | 50 |  | Lab fees | 250
 | Loans | 500 |  | Cell phone | 75 |  | Books | 500
 | Other income | 250 |  | Groceries | 250 |  | Deposits | 0
 | Total |  |  | Auto expenses | 50 |  | Transportation | 0
 |  |  |  | Student loans | 500 |  | Other fees | 0
 |  |  |  | Credit cards | 275 |  | Total
 |  |  |  | Insurance | 125 |  | * based on a 4 month semester
 |  |  |  | Hair cuts | 50
 |  |  |  | Entertainment | 0
 |  |  |  | Miscellaneous | 0
 |  |  |  | Total
Spreadsheet: 41384d1239858811-conditional-formula-conditional-formula-solution
Sheet: Solution-1

L Name | Wage Base | Percent | Tier | W/ [NAME] | Adjusted Amount |  |  |  | 2500 | 0.4370629370629371 | 392.6573426573427
Doe | 200 | 87.41258741258741 | 1 | 87.41258741258741 | 117.6169983862292 |  | [NAME] | 1 | 150
Doe | 250 | 109.2657342657343 | 1 | 109.2657342657343 | 139.470145239376 |  | [NAME] | 2 | 250
Doe | 225 | 98.33916083916084 | 1 | 98.33916083916084 | 128.5435718128026 |  | [NAME] | 3 | 350
Doe | 20 | 8.741258741258742 | 1 | 8.741258741258742 | 38.94566971490049
Doe | 100 | 43.70629370629371 | 1 | 43.70629370629371 | 73.91070467993546
Doe | 225 | 98.33916083916084 | 1 | 98.33916083916084 | 128.5435718128026 |  | 150
Doe | 250 | 109.2657342657343 | 1 | 109.2657342657343 | 139.470145239376
Doe | 350 | 152.972027972028 | 2 | 152.972027972028 | 183.1764389456697
Doe | 500 | 218.5314685314685 | 2 | 218.5314685314685 | 248.7358795051103
Doe | 400 | 174.8251748251748 | 2 | 174.8251748251748 | 205.0295857988166
Doe | 1000 | 437.0629370629371 | 3 | 350 | 380.2044109736418 |  | 1
Doe | 1500 | 655.5944055944057 | 3 | 350 | 380.2044109736418
Doe | 700 | 305.9440559440559 | 3 | 305.9440559440559 | 336.1484669176977
TOTAL | 5720 | 2500 |  | 2107.342657342657 | 2500
 |  |  | AUTO | AUTO | AUTO
Total Employees | 13
Avail able Bonus | 2500
Total Amount Availed | 2107.342657342657
Remaing Amount | 392.6573426573427
Equally Distributed | 30.20441097364175
 |  | Hi everyone,
 |  | I've been trying to figure this out without have a ton of formulas and columns, and I'm stuck. Basically, I have a $ figure that is available as a bonus to our employees. I want to distribute that dollar figure based on two criteria:
 |  | 1. Based on a percentage of each persons' wage base.
 |  | 2. No more than a cap based on which "tier" a person falls into.
 |  | However, when the cap comes into play, I'd like that $ to be redistributed among the remaining people. The problem that keeps cropping up, is that redistribution triggers another cap, and the whole thing needs to cycle and recaclulate again.
 |  | I'd like to set up this worksheet, so one could enter the total $ available for bonus, and then the cap for each tier, and the figures would automatically populate. I'm attaching a small scale sample of what I've pieced together so far.
 |  | Thanks in advance for any help!
Spreadsheet: 171993d1343940292-copy-tab-within-excel-suddenly-wont-work-1
Sheet: PENDING_MANAGER_APPROVAL_-_ (2

Concur Reports Pending Manager [NAME]
Employee Last Name | Employee First Name | Report Name | Report [NAME] | Employee Assigned Approving Manager | Report Approval Date | Report Submit Date | Report Receipts Received | Report Amount Payable to Company | Report Amount Payable to Employee | Report Amount Total
Employee Last Name | Employee First Name | Report Name | Report [NAME] | Employee Assigned Approving Manager | Report Approval Date | Report Submit Date | Report Receipts Received | Report Amount Payable to Company | Report Amount Payable to Employee | Report Amount Total
x | a | [NAME] | Pending | th |  | 2012-08-01 00:00:00 | No | 1 | 0 | 100
y | b | ha ha ha | Resubmit | xl | 2012-05-01 00:00:00 | 2012-03-06 00:00:00 | No | 0 | 0 | 700
z | c | yada yada | Resubmit | sd |  | 2012-08-01 00:00:00 | No | 0 | 117.77 | 600
x | a | [NAME] | Pending | nf | 2012-05-25 00:00:00 | 2012-05-22 00:00:00 | No | 0 | 144.4 | 261.13
Spreadsheet: 102652d1300634121-retrieve-first-non-blank-cell-value-order-monitor
Sheet: MONITOR

 |  | NEXT ORDER | ORDER AMOUNT | DAYS LEFT | STOCK
 | PRODUCT 1 | DATE? | AMOUNT? | ? | 1000
 | PRODUCT 2 | DATE? | AMOUNT? | ? | 50
 | PRODUCT 3 | DATE? | AMOUNT? | ? | 200
 | PRODUCT 4 | DATE? | AMOUNT? | ? | 300
 | PRODUCT 5 | DATE? | AMOUNT? | ? | 0
 | PRODUCT 6 | DATE? | AMOUNT? | ? | 0
 | PRODUCT 7 | DATE? | AMOUNT? | ? | 0
 | PRODUCT 8 | DATE? | AMOUNT? | ? | 50
 | PRODUCT 9 | DATE? | AMOUNT? | ? | 42
 | PRODUCT 10 | DATE? | AMOUNT? | ? | 56
 | PRODUCT 11 | DATE? | AMOUNT? | ? | 49
 | PRODUCT 12 | DATE? | AMOUNT? | ? | 800
 | PRODUCT 13 | DATE? | AMOUNT? | ? | 512
 | PRODUCT 14 | DATE? | AMOUNT? | ? | 483
 | PRODUCT 15 | DATE? | AMOUNT? | ? | 567
 | PRODUCT 16 | DATE? | AMOUNT? | ? | 78
 | PRODUCT 17 | DATE? | AMOUNT? | ? | 53
 | PRODUCT 18 | DATE? | AMOUNT? | ? | 27
 | PRODUCT 19 | DATE? | AMOUNT? | ? | 97
 | PRODUCT 20 | DATE? | AMOUNT? | ? | 982
Spreadsheet: 92727d1292278109-scroll-bar-wont-stop-scrolling-scroll-bar-example-working
Sheet: jan_data

employee # | area | sales $
1111 | east | 36710.11741586065
1112 | east | 75036.6444719413
1113 | east | 33168.17765249367
1114 | east | 26542.96455745326
1115 | west | 55892.52749389506
1116 | west | 41936.57581026891
1117 | west | 80818.9442808402
1118 | northeast | 22324.61933621217
1119 | northeast | 46938.46895515526
1120 | northeast | 18905.66814303627
1121 | northeast | 85754.54668314659
1122 | northeast | 64965.18404485026
1123 | northwest | 81757.93702875546
1124 | northwest | 54045.22352161352
1125 | northwest | 74651.1287001816
1126 | southeast | 71369.80938844477
1127 | southeast | 73248.82010104362
1128 | southeast | 53401.40958770947
1129 | southeast | 17550.66624735746
1130 | southeast | 21277.29366382276
1131 | southeast | 84302.02253412071
1132 | southwest | 6061.146116400007
1133 | southwest | 71095.89424340898
1134 | southwest | 71147.7268508868
1135 | midwest | 69504.9626839216
1136 | midwest | 94104.55346992332
1137 | midwest | 82884.89341841274
Spreadsheet: 129894d1321965260-limits-for-using-vlookup-sales_help
Sheet: Países

Name | Sale Tax | Approval | Value | Quantity
Portugal | 0.01 | Imediata | 0 | 0
Espanha | 0.02 | Imediata | 0 | 0
UK | 0.05 | Valor | 500 | 0
USA | 0.1 | Quantidade | 0 | 1000
China | 0.1 | Quantidade | 0 | 1000
Name |  | Sale Tax Type |  | Approval Type
Portugal |  | 0.01 |  | Imediata
Espanha |  | 0.02 |  | Valor
UK |  | 0.03 |  | Quantidade
USA |  | 0.04
China |  | 0.05
 |  | 0.06
 |  | 0.07
 |  | 0.08
 |  | 0.09
 |  | 0.09999999999999999
Spreadsheet: 868441d1715175527-sort-function-broken-keep-dreaming-league-standings
Sheet: 5 - APR 18

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | W |  | L |  | PTS |  | PF |  | PA
JASON | 5 |  |  | 10 |  |  |  | 6 |  |  | 10 |  |  |  | 10 |  |  | 10
WAYNE | 10 |  |  |  | 10 |  |  |  | 6 |  |  | 10 |  |  |  | 10 |  |  | 6
[NAME] |  | 10 |  |  | 6 |  |  | 10 |  |  |  |  | 6 |  |  |  | 7 |  |  | 7
[NAME] |  | 7 |  |  |  | 5 |  |  | 10 |  |  |  |  | 10 |  |  |  | 7 |  |  | 5
MIKE |  |  | 5 |  |  | 10 |  |  |  | 6 |  | 4 |  |  | 6 |  |  |  |  | 10
MOUNTNEY |  |  | 10 |  |  |  | 10 |  |  |  | 6 |  | 10 |  |  | 7 |  |  |  |  | 10
MAYFIELD |  |  |  | 6 |  |  | 7 |  |  | 10 |  |  |  | 5 |  |  | 10 |  | 10
 | 1-2 | 3-4 | 5-6 | 1-7 | 2-3 | 4-5 | 6-7 | 1-3 | 2-4 | 5-7 | 1-6 | 2-5 | 3-6 | 4-7 | 1-5 | 2-6 | 3-7 | 1-4 | 2-7 | 3-5 | 4-6