tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: f90770eb-5dd0-4c91-9f06-c5fdbd679946
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
F5HAR | Test | F5HAR | 5-HIAA (5-Hydroxyindoleacetic Acid), [NAME] | 5-HIAA, [NAME] | High Performance Liquid Chromatography, Electrochemical Detection | [NAME]: Urine |  |  | 10 | mL | 10 mL random urine, after collection add 6N HCL to maintain a pH below 3. Submit in a sterile screw capped container shipped ambient.  Note: 1. Urine without preservative is acceptable if pH is below 6 and shipped frozen.          2. Dietary Instructions:              - Patient should avoid food high in indoles: avocado, banana, tomato, plum, walnut, pineapple, and eggplant.              - Patient should also avoid tobacco, tea and coffee three days prior to specimen collection.  Required: 1. Patient age | 5 mL | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icteric	NA | 5-HIAA                             mg/g creat    2-10 YRS: 12.0 or less    >10 YRS:  10.0 or less  Creatinine, [NAME]    mg/dL           Age              mg/dL    0-6   Months        2-32    7-11 Months        2-36    1-2   Years          2-128    3-8   Years          2-149    9-12  Years         2-183    >12   Years              Males:      20-370              Females:  20-320  Test Performed by: Quest Diagnostics Nichols Institute                               33608 [NAME]                               San Juan Capistrano, CA 92690-6130 | Tuesday, Thursday, Saturday | 3 days | 5 - 9 days |  | Profile |  |  |  |  | Quest Diagnostics/Nichols Institute
F5HAR | [NAME] | URINE | [NAME] |  |  |  | Ambient | 7 days
F5HAR | Result | Z2672 | 5-HIAA | 5-HIAA | Numeric |  |  |  |  | mg/g creat |  |  |  |  |  |  |  |  |  | In Process
F5HAR | Result | Z2673 | Creatinine, [NAME] | Creatinine, [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | In Process
F5HAR | Billing Component | F5HAR |  | ASSAY OF 5-HIAA |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83497
F5HAR | Billing Component | F5HAR |  | ASSAY OF URINE CREATININE |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 82570
Spreadsheet: 837822d1690451863-drop-down-chooses-defined-list-test-file-5-aligw
Sheet: Lookups

Ash AM |  | Ash AM |  | Ash PM
Ash PM |  | GP Anima AM |  | Duty (GP) A PM
Duty (GP) A PM |  | GP Routine AM |  | Duty (GP) B PM
Duty (GP) B PM |  | GP Triage AM (Salaried) A |  | Duty (GP) PM
Duty (GP) PM |  | GP Triage AM (Salaried) B |  | Duty (Salaried) A PM
Duty (Salaried) A PM |  | GP Triage AM A |  | Duty (Salaried) B PM
Duty (Salaried) B PM |  | GP Triage AM B |  | Duty (Salaried) PM
Duty (Salaried) PM |  | Minor Illness AM |  | GP Anima PM
GP Anima AM |  | Salaried GP Anima AM |  | GP Routine PM
GP Anima PM |  | Salaried GP Routine AM |  | Minor Illness PM
GP Routine AM |  |  |  | Salaried GP Anima PM
GP Routine PM |  |  |  | Salaried GP Routine PM
GP Triage AM (Salaried) A
GP Triage AM (Salaried) B
GP Triage AM A
GP Triage AM B
Minor Illness AM
Minor Illness PM
Salaried GP Anima AM
Salaried GP Anima PM
Salaried GP Routine AM
Salaried GP Routine PM
Spreadsheet: c1170c28-97a5-4417-9373-3a18b1139d51
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
LCMC1 | Test | LCMC1 | Identification, M.chelonae and M.abscessus,PCR | Id,M.chelonae and M.abcessus,PCR |  |  |  |  |  |  | **For billing purposes only |  |  |  |  |  |  | 1 | 87149 |  |  |  |  | Rochester
LCMC1 | [NAME] | VARIES | Varies |  |  |  | See instructions
Spreadsheet: 810592d1671874556-filtering-data-with-search-box-option-search-sample-file
Sheet: FILTERED DATA

FILTERED DATA
SEARCH |  |  | J
TOTAL :
Sl. No. | Regd. No. | HS ROLL NO. | Name | Father's Name | Class | Sec. | Roll No. | Sex | Lang. 1 | Lang. 2 | Comp. Elec. 1 | Comp. Elec. 2 | Comp. Elec. 3 | Opt. Elec.
Spreadsheet: 115447d1311066349-budget-calc-help-2011budget
Sheet: August

2011 Budget
Payday |  |  |  |  | Amount
1st |  |  |  |  | 0
15th
Total Monthly
Expenses |  | Product |  |  | Amount |  | Paid? | Remainder
1st |  | Ring |  |  | 100 |  | False
 |  | Easynews |  |  | 15 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Verizon |  |  | 100 |  | False
 |  | Bi-Weekly Remainder
15th |  | Chase |  |  | 54 |  | False
 |  | Gas |  |  | 50 |  | False
 |  | Insurance |  |  | 120 |  | False
 |  | Personal |  |  | 100 |  | False
 |  | Savings |  |  | 200 |  | False
 |  | Bi-Weekly Remainder
Total Monthly
Total Remainder
Spreadsheet: 53478d1253358314-the-other-side-of-the-plot-area-graph
Sheet: SCHEDULE

 | ORG | FLIGHT | ETA | FLIGHT | ETD | DEST
 | BER | AB1234 | 1000 | AB1235 | 1300 | FRA | 10 | 13 | 3 | 0 | 10 | 0.18 | 13.18 | 3.18
 | MUC | AC4321 | 2015 | AC4329 | 2400 | NUE | 20.15 | 24 | 3.850000000000001 | 0.3 | 20.45 | 0.24 | 24.24 | 3.789999999999999
 |  | This is now shown |  | This is wht I would
 |  | on the left side |  | like to be shown
 |  | of the graph |  | on the right side
 |  |  |  | of the graph
 | * Even greater still would if there would be a way to display the information from the collumns B, D, F and G also on the graph
 | * the graph is on sheet "GRAPH"
Spreadsheet: 804079d1667874809-calculate-how-late-a-return-is-in-minutes-item-return-sample
Sheet: Returns

Service Request Received  Date & Time | [NAME] to be received by: (Service Request Received + 10 Working Days) | [NAME] Recieved Date & Time | Minutes Overdue
2022-08-31 09:00:00 |  | 2022-09-14 10:00:00 | 60
2022-08-31 09:00:00 |  | 2022-09-13 10:00:00 | 0
2022-08-31 10:00:00 |  | 2022-09-14 10:00:00 | 0
2022-08-31 10:00:00 |  | 2022-09-14 10:30:00 | 30
2022-08-31 10:00:00 |  | 2022-09-15 10:00:00 | 1440
Spreadsheet: 270657d1381576920-required-an-excel-formula-to-meet-the-multiple-conditiond-hr-logic
Sheet: Sheet1

 | X | Y | Z | To be considered at the time of working | Desired Result
 | HR |  |  | If "HR" exist in one column and other two column are empty,then,put 1
 | HR | HR |  | If "HR" exist in two column and one column is empty,then,put 1
 | HR | HR | HR | If "HR" exist in all three column,then,put 1
 | HR | PB | MAH | If "HR" exist in any one of the 3 columns,then,put 2
 | PB | HR | HR | If "HR" exist twice in any two of the 3 columns,then,put 2
 | CH | HR |  | If "HR" exist once in any of the three column ,then,put 2
 | PB |  |  | If "HR" not exist in any of the 3 columns,then put 3
 | PB | KAR |  | If "HR" not exist in any of the 3 columns,then put 3
 | MAH | KAR | DEL | If "HR" not exist in any of the 3 columns,then put 3
Spreadsheet: 28afff7b-982a-4d8f-b06b-c200ee99ad64
Sheet: By classroom

 |  | Mon | [NAME] | Wed | Thurs |  | Mon | [NAME] | Wed | Thurs |  | Mon | [NAME] | Wed | Thurs
09:00:00 |  | EDUC 521-01 |  | EDUC 521-01
10:00:00 |  | EDUC 521-02 |  | EDUC 521-02 |  |  | Free for seminars |  | Free for seminars |  |  | Free for seminars |  | Free for seminars
11:00:00 |  | Free for seminars |  | Free for seminars
12:00:00 |  |  |  |  |  |  | EDUC 510-01 |  | EDUC 510-02 |  |  |  |  | EDUC 514-01
01:00:00 |  | EDUC 521-03           1st half 1:00-3:30 |  | EDUC 521-03           1st half 1:00-3:30 |  |  |  |  |  |  |  | EDUC 514-02
 |  |  | EDUC 535 1:30-3:15 all semester |  | EDUC 535 1:30-3:15 all semester
02:00:00
03:00:00
04:00:00 |  |  | EDUC 580 4:00-7:15 second half |  | EDUC 580 4:00-7:15 second half
05:00:00
06:00:00
07:00:00
08:00:00
Spreadsheet: 708072d1607608577-simplifying-a-very-old-worksheet-bourn
Sheet: Lewis

hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | INDEX 1 | INDEX 2 | INDEX 3 | points | handicap | handicap | HANDICAPPING
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 83413d1283403352-calculating-tax-salary-working
Sheet: Sheet1

 | Salary | Bonus | Accumulated Salary | PF E'er | Taxable income from employment | Insurance | PF E'ee | Taxable amount | Monthly Tax | Tax Paid | Tax O/standing | Deductions | Pay
July | 46306 | 0 |  |  |  |  |  |  |  | 6292.53 |  | 4657
August | 46306 | 17000 |  |  |  |  |  |  | 6646.695833333334
September | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334 | 1852.08
October | 46306 |  |  |  |  |  |  |  | 6646.695833333334 | 1852.08
November | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334 | 1852.08
December | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
January | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
February | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
March | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
April | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
May | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
June | 46306 | 0 |  |  |  |  |  |  | 6646.695833333334
 |  | 200000 | 0.01
 |  | 100000 | 0.15
 |  | REST | 0.25 |  |  |  |  |  |  | 0
 |  |  | Monthly
Spreadsheet: 72568d1273246205-excel-2007-vlookup-across-multiple-worksheets-store
Sheet: Totals

Date | Bananas | Pears | Apples
2010-01-01 00:00:00
2010-02-01 00:00:00
2010-03-01 00:00:00
2010-04-01 00:00:00
2010-05-01 00:00:00
2010-06-01 00:00:00
2010-07-01 00:00:00
2010-08-01 00:00:00
2010-09-01 00:00:00
2010-10-01 00:00:00
Spreadsheet: 456549d1460939017-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-a
Sheet: THU - VOLUNTEER

YOGH | [NAME] |  |  | SOUP | CHICK | BEEF |  |  | [NAME] | CHICKEN FILLET |  |  |  | BEEF | QUICHE |  |  |  |  |  |  |  | BEEF | QUICHE
B O T T O M |  |  |  |  |  |  |  |  | MIDDLE |  |  |  |  |  |  |  |  | TOP
NAME | ADDRESS | JUICE | DESSERT | SOUP | CHICKEN MORNAY | ROAST BEEF |  |  | NAME | ADDRESS | JUICE |  |  |  |  |  |  | NAME | ADDRESS | JUICE
PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS
 |  | OJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  | CHICKEN FILLET
 |  | NO JUICE |  |  |  |  |  |  |  |  | OJ | YOGHURT |  |  | ROAST BEEF |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  | [NAME]
 |  |  | [NAME] |  | CHICKEN MORNAY |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  | OJ |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  | AJ |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | NO JUICE
 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ
 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ | [NAME] |  | CHICKEN MORNAY
 |  |  |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  | AJ
PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK SHEET
PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM
Spreadsheet: 730370d1619675448-combine-data-from-two-columns-combine-data-from-two-columns
Sheet: Sheet1

1) Data from the previous month |  |  | 3) Data from previous month and raw data are combined here |  |  | 2) Raw data from the insurance provider is pasted here
Customers | Comments |  | Customers | Comments |  | Insured
Lazy | Get up |  |  |  |  | Lazy
New | Call |  |  |  |  | New
Old | Boss |  |  |  |  | Old
Cheezy | Good |  |  |  |  | Cheezy
Burger | Later |  |  |  |  | Burger
Chocolate | Smooth |  |  |  |  | Chocolate
Stick |  |  |  |  |  | Stick
Chewy |  |  |  |  |  | Chewy
Puppy |  |  |  |  |  | Puppy
Cat | Get out
Duck | Fly
Dog | Eat a snack
Spreadsheet: 0db58e36-f9e5-4858-8a96-ec40cea93483
Sheet: Sheet1

OPERATING | FY2013 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Beginning Reserve
Fund Balance | 433409
 | FY2013 | FY2013 | FY2012 | FY2013 | FY2013 | FY2012
 | Annual Budget | Annual Budget | Revenues this time | Actual Revenue | Actual Expenses | Expenses this time | Net | Net
 | Revenue | Expenses | last year | to date | to date | last year | This Year | Last Year
Membership activities
Administration | 0 | 235020 | 575 | 1747 | 56396 | 56126
Membership Promotion | 0 | 2000 |  |  | 0 | 0
Governance Support | 0 | 8850 |  |  | 2317 | 7994
Dues | 187898 | 3905 | 45801 | 44174 | 779 | 784
MW & Annual Conference | 0 | 6300 | 0 | 0 | 205 | 80
External Relations | 13500 | 21205 | 0 | 0 | 0 | 100
Technology Grants | 0 | 500 | 0 | 0 | 0 | 0
50th Anniversary | 0 | 0 | 0 | 0 | 0 | 0
Friends of LITA (LITA Now) | 300 | 0 | 0 | 0 | 0 | 0
Subtotal | 201698 | 277780 | 46376 | 45921 | 59697 | 65084 | -13776 | -18708
Publications
ITAL | 5500 | 8097 | 11189 | 1214 | 1299 | 9710 | -85 | 1479
Classified ads | 15000 | 1800 | 4700 | 4742 | 122 | 106 | 4620 | 4594
Nonperiodical Pubs. | 2800 | 1857 | 0 | 0 | 0 | 0 | 0 | 0
Subtotal | 23300 | 11754 | 15889 | 5956 | 1421 | 9816 | 4535 | 6073
Education
Pre-conferences | 23850 | 14031 | 0 | 0 | 0 | 0 | 0 | 0
MW Workshop | 22305 | 13638 | 0 | 0 | 0 | 0 | 0 | 0
Forum | 103913 | 103893 | 118413 | 110637 | 84467 | 96905 | 26170 | 21508
Institutes | 22800 | 14508 | 0 | 0 | 0 | 0 | 0 | 0
Web CE-1 (courses) | 43500 | 18188 | 5980 | 9645 | 2521 | 950 | 7124 | 5030
Web CE-2 (webinars) | 26400 | 10886 | 2521 | 0 | 0 | 360 | 0 | 2161
Subtotal | 242768 | 175144 | 126914 | 120282 | 86988 | 98215 | 33294 | 28699
TOTAL | 467766 | 464678 | 189179 | 172159 | 148106 | 173115 | 24053 | 16064
ENDOWMENT | FY2013
Fund Balance | 128378
Revenues | 1094
Expenses | 210
Net Revenue/Expense | 1437
Ending Net Asset Balance | 129815
Interest/Dividends @ end of FY | 3455
Spreadsheet: 50315d1249676683-how-can-i-get-around-the-dv-drop-down-list-limit-test
Sheet: CAL Form

CALIBRATED BY | DATE | MACHINE # | TIME | 0 | 0 | TIME | 0 | 500 | TIME | 0 | 1000 | TIME | 0 | 2000 | TIME | 0 | 10000 | TIME AM DRIFT | 500 (AM) | TIME (MID) | 500 (MID) | TIME (PM) | 500 (PM) | USED BY
peaches
Nickel
Yellow
bob
Spreadsheet: 226435d1365413232-searching-a-column-for-text-any-text-and-if-its-there-place-it-in-a-specific-cell-example-for-forum
Sheet: Sheet1

 |  |  | BUYS |  |  | SELLS
 |  | 1 | any text in V column |  | 1 | any text in Y column
 |  |  |  |  |  |  |  |  |  |  | .3 - 2 | .2 - 1 |  | MAX | 2nd Big | 3rd Big | 4th Big | 5th Big
 |  | 2 | any text in w column |  | 2 | any text in Z column |  |  |  |  | -1.497005988023952 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.8957133717210494
 |  | 3 | any text in X column |  | 3 | any text in AA column |  |  |  |  | 0.4975124378109453 | 0.9950248756218906 |  |  |  |  |  | AGO
 |  |  |  |  |  |  |  |  |  |  | -2.259887005649718 | 3.389830508474576 |  | AIO
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.09775171065493646
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.2139037433155082
 |  |  |  |  |  |  |  |  |  |  | -0.196078431372549 | 0.5882352941176471
 |  |  |  |  |  |  |  |  |  |  | 0.3853564547206163 | -1.027617212588311
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.4684684684684685
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0.0277623542476402 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.3225806451612903
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0.7672634271099744
 |  |  |  |  |  |  |  |  |  |  | 0.2979145978152929 | -0.397219463753724
 |  |  |  |  |  |  |  |  |  |  | -0.4342431761786602 | 0.8064516129032259
 |  |  |  |  |  |  |  |  |  |  | 0 | 1.02880658436214 |  |  |  | BLD
 |  |  |  |  |  |  |  |  |  |  | 0 | -0.2114164904862579
 |  |  |  |  |  |  |  |  |  |  | 0 | 1.45985401459854 |  |  | BPT
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ANY TEXT in V column HERE
Spreadsheet: 747845d1631726236-counting-text-across-multiple-rows-and-columns-sample3-1-ans2
Sheet: Location B

 | Go to Summary
Floor | Room | DEPARTMENT | MONDAY AM | MONDAY PM | TUESDAY AM | TUESDAY PM | WEDNESDAY AM | WEDNESDAY PM | THURSDAY AM | THURSDAY PM | FRIDAY AM | FRIDAY PM
1 | 1 | PEDIATRICS
1 | 2 | PEDIATRICS | Test | Test | Test |  | Test | Test |  |  | Test | Test
1 | 3 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test
1 | 4 | PEDIATRICS
1 | 5 | PEDIATRICS
1 | 6 | PEDIATRICS | Test | Test | Test |  | Test | Test |  |  | Test | Test
1 | 7 | PEDIATRICS | Test | Test | Test |  | Test | Test |  |  | Test | Test
1 | 8 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test
1 | 9 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test
1 | 10 | PEDIATRICS | Test | Test | Test | Test | Test | Test | Test | Test | Test | Test
1 | 11 | PEDIATRICS
Spreadsheet: 786075d1656964721-xirr-with-noncontiguous-cell-ranges-issue-samplev2
Sheet: Sheet1

Transaction | Dates | Amounts | Contribution Total | XIRR
1 | 2020-01-05 00:00:00 | -100000
2 | 2020-02-15 00:00:00 | 5000 | -100000
3 | 2020-03-15 00:00:00 | 500 | -100000
4 | 2020-03-30 00:00:00 | -50000 | -150000
5 | 2020-04-15 00:00:00 | 700 | -150000
6 | 2020-05-15 00:00:00 | 1200 | -150000
7 | 2020-06-15 00:00:00 | 150000 | -150000
Spreadsheet: 219908d1363011609-auto-reapply-autofilter-test
Sheet: Front Page

Quote No. |  |  |  | Contact Name
Customer |  |  |  | Job Required By
Planned/Quoted By |  |  |  | Number of Details |  | 20
Bought Out Cost
Total hours this Quote | 0 |  | Total prices this Quote | 0 |  | Chosen Rate | Rate 3
Risk Assesment
None
Total (£) |  |  | Quote Compiliation hours
[SELECT]
Rate 1 | 10 |  | 1
Rate 2 | 20 |  | 2
Rate 3 | 40 |  | 3
 |  |  | 4
 |  |  | 5
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 13d

 | Swap Dealers/MSPs5 |  |  | Others
Product1 | HY6 | IG | Other | HY | IG | Other
Index Tranche | 69964 | 750716 | 706445 | 16628 | 77697 | 109602
Index | 867100 | 3698903 | 5610403 | 403204 | 1262540 | 1598912
Asia | 0 | 0 | 186926 | 0 | 0 | 48459
Europe | 0 | 0 | 4846348 | 0 | 0 | 1441985
North America | 867100 | 3698903 | 157731 | 403204 | 1262540 | 45849
Other | 0 | 0 | 419398 | 0 | 0 | 62619
OTHER* | 0 | 0 | 625738 | 0 | 0 | 320893
TOTAL | 937064 | 4449619 | 6942586 | 419832 | 1340237 | 2029407
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 1177bed9-55bf-493a-b4c2-9c5e0209411e
Sheet: Sheet1

Unnamed: 0 | Janauary 2012 - TEMPE DIABLO STADIUM | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | New Year Day
 | City Holiday
 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Tickets on Sale
 |  |  |  |  |  |  | Ticketmaster
 |  |  |  |  |  |  | [PHONE]
 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 |  | MLK Day |  |  |  |  | Porsche Club
 |  | City Holiday |  |  |  |  | East Lot
 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 31
Spreadsheet: 705344d1606042808-formulas-for-counting-and-adding-rolling-data-excel-forum-question
Sheet: Sheet1

Blue | Total count of Blue and Red per last/rolling 100 entries: |  |  | 2 | Sum of all numbers for last/rolling 100 entries:
Blue |  |  |  | 2
Green |  |  |  | -1
Blue |  |  |  | 2
Red | 8 |  |  | 1
Red |  |  |  | 1
Red |  |  |  | 1
Blue |  |  |  | 2
Green |  |  |  | -1
Green |  |  |  | -1
Red |  |  |  | 1
Spreadsheet: 542546d1507907367-please-critique-my-spreadsheet-please-critique-my-spreadsheet-payroll-worksheets-year-2017
Sheet: August 2017 Summary

August 2017 Summary |  | Total Job Hours | Total Hours-Per Job
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
#
Job
1 |  |  | x
2 |  |  |  | x
3 |  |  |  |  | x
4 |  |  |  |  |  | x
5 |  |  |  |  |  |  | x
6 | Shop |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
7 |  |  |  |  |  |  |  |  | x
8 |  |  |  |  |  |  |  |  |  | x
9 |  |  |  |  |  |  |  |  |  |  | x
6 |  |  |  |  |  |  |  | x
 | less shop hours
 | Hours less Shop
Hours without Shop
Shop Hours
Totals |  |  |  |  |  |  |  |  |  |  |  |  | 0
%
Vehicles
 | Fuel
 | Repairs & Maintenance
 | Overhead
 | % of month | 1
Spreadsheet: 162798d1340071235-complex-if-and-logic-help-needed-commscalc-example
Sheet: Example

User defined Values |  |  | User Defined Ramps:
Quota | 1000 |  | Ramps / Accelerators | Low Value | High Value | Multiplier
Commission | 100 |  | Ramp 1 | 0 | 100 | 1
Base Amount | 100 |  | Ramp 2 | 101 | 150 | 2.4
 |  |  | Ramp 3 | 151 | 9999 | 2.7
Calculator | Sales $ | Achievement % | Running Achievement | Commission $ | Answer should be
Q1 | 300 |  |  |  | 30 | Great it works for amounts less than Ramp 1
Q2 | 400 |  |  |  | 40 | Great it works for amounts less than Ramp 2
Q3 | 500 |  |  |  | 78 | Answer is calculated as 30% * Ramp 1 = $30K + 20% * Ramp 2 = $48K = Total of $78K
Q4 | 900 |  |  |  |  | Answer is calculated as 30% * [NAME] 2 Multiplier = $72K + 60% * Ramp 3  Multiplier = $162K = Total of $234K
Total
EXAMPLE:
In this example the sales person has a quota of 1000 and manually inputs their quarterly achievement / Forecast (in GREEN). The Quarterly achievement is automatically calculated and the commission dollar value is calculated based on the Ramp Multipliers.
Commission Calculations based on example ramps
Nought to 100% | if achievement is between 0 and 100 then multiply achievement by commision multiplied by the ramp.
101% -150% | IF achievement is greater than 151% of quota then multiply 50 by ramp by commission value ELSE if achievement is greater than 100% of quota then subtract 100 from the  total achievment then multiply commission by ramp else 0
150%-9999% | IF achievement is greater than 151% of quota then multiply subtract 150 from the  total achievment then multiply commission by ramp 3 else 0