tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 790510d1659748291-search-table-given-dates-and-numbers-as-criteria-help_please
Sheet: Sheet1

VOLUME DISCOUNT PER ITEM TABLE BASED ON INVOICE DATE
VOLUME PER ITEM: |  | 30000 |  | CHANNEL: |  | EU
INVOICE DATE: |  | 2022-01-15 00:00:00 |  | VOLUME DISCOUNT: |  |  | <<<--- HELP
 |  |  |  | EXCEL 365 FORMULA: |  |  | <<<--- OK
SORT DATE THEN VOL ASCENDING
VOL | FR_DATE | TO_DATE | EU | DL | DR | TB | PL | RM
0 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
5000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
10000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
15000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
20000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
25000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
30000 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
0 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0
2000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.02 | 0 | 0 | 0 | 0 | 0
5000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.04 | 0 | 0 | 0 | 0 | 0
10000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.06 | 0 | 0 | 0.02 | 0.02 | 0
15000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.08 | 0 | 0 | 0.04 | 0.04 | 0
20000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.06 | 0.06 | 0
25000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.08 | 0.08 | 0
30000 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
999999999 | 2022-02-01 00:00:00 | 2022-12-31 00:00:00 | 0.1 | 0 | 0 | 0.1 | 0.1 | 0
Spreadsheet: 730267d1619618526-highlight-column-of-current-weeknumber-csp_blanco
Sheet: Blad1

CRITICAL SALES PATH
Event name
Event dates
B2B | B2R | B2C
Bucket size
Final sales target in # exh
Final sales target in # sqm |  |  |  |  |  |  |  |  |  | 2021-04-01 00:00:00 |  |  |  | 2021-05-01 00:00:00 |  |  |  | 2021-06-01 00:00:00 |  |  |  |  | 2021-07-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 |  |  |  |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-12-01 00:00:00 |  |  |  |  | 2022-01-01 00:00:00 |  |  |  | 2022-02-01 00:00:00 |  |  |  | 2022-03-01 00:00:00 |  |  |  |  | 2022-04-01 00:00:00 |  |  |  | 2022-05-01 00:00:00
Sold sqm
Final sales target in exh revenues |  |  |  |  |  |  |  |  |  | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21
Current exh revenue
[NAME] |  |  |  |  |  |  |  | START | CURRENT
EXH - Weekly sales target in # of exhibitors
EXH - Monthly sales target in # of exhibitors (cumulative for that month)
EXH - Needed monthly # of exhibitors to stay on target
EXH - Weekly sales results in # of exhibitors WON
EXH - Monthly sales results in # of exhibitors WON (cumulative for that month)
EXH - % achieved in # exhibitors
SQM - Weekly sales target in # sqm
SQM - Monthly sales target in # sqm (cumulative for that month)
SQM - Weekly  sales results in # sqm
SQM - Monthly sales results in # sqm (cumulative for that month)
SQM - % achieved in # sqm
[NAME] sales target in exh rev to intermediate
[NAME] sales target in exh rev to budget
[NAME] sales target in exh rev (cumulative for that month)
[NAME] sales results in exh rev
[NAME] sales results in exh rev (cumulative for that month)
[NAME] achieved in exh rev
Spreadsheet: 12f7303a-c328-4b6b-82be-9335ac689a91
Sheet: Sheet1

IRR & Sensitivity Analysis Calculation Sheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Basic Data Table
No. | Items | Unit | Figure | Note
1 | Installed capacity | kW | 49500 | FSR
2 | No. of wind turbines |  | 33 | FSR
3 | Capacity of the wind turbine | kW | 1500 | FSR
4 | Annual electricity supplied | 10000kWh | 10020 | FSR
5 | Annual operation hours | Hrs | 2024.242424242424 | FSR
6 | Electricity tariff (including VAT) | Yuan/kWh | 0.61 | FSR
7 | Static total investment | 10000Yuan | 46292 | FSR
8 | Equivalent Substitutes by VAT of experted equipments | 10000Yuan | 4100 | FSR
9 | Self-raised capital in static investment | 10000Yuan | 9359 | FSR
10 | Long-term loan | 10000Yuan | 36933 | FSR
11 | Interest incurred during construction period | 10000Yuan | 1096.9101 | FSR
12 | Liquid capital | 10000Yuan | 149 | FSR
13 | Construction period | Year | 1 | FSR
14 | Operation period | Year | 20 | FSR
15 | Rate of long-term loan | % | 0.0594 | FSR
17 | Repayment period | Year | 11 | FSR
18 | Rate of VAT | % | 0.17 | FSR
19 | Rate of income tax | % | 0.25 | FSR
20 | Rate of city maintenance and construction tax | % | 0.05 | FSR
21 | Rate of additional education fee | % | 0.03 | FSR
22 | Depreciable life | Year | 15 | FSR
23 | Rate of residual value of fixed assets | % | 0.05 | FSR
24 | Average rate of depreciation | % | 0.06333333333333332 | FSR
25 | Rate of insurance premium of fixed assets | % | 0.00405 | FSR
26 | No. of employee |  | 25 | FSR
27 | Annual salary per capita | 10000Yuan | 5 | FSR
28 | Rate of fixed assets maintenance | % | 0.016 | FSR
29 | Rate of material benefits | % | 0.14 | FSR
30 | Rate of labor insurance | % | 0.17 | FSR
31 | Rate of house fund | % | 0.1 | FSR
32 | Material cost | Yuan/kW | 10 | FSR
33 | Other costs | Yuan/kW | 30 | FSR
34 | CER price | EUR/tCO2 | 10.5 | ERPA
35 | Exchange rate of EUR and RMB | EUR:Yuan | 9.3792 | 20110420
36 | Emission factor | tCO2/MWh | 0.918 | China DNA
37 | CERs | tCO2/year | 91983.6 | Calculated
Spreadsheet: 04608b3a-ff08-45d7-8c13-8b5212ea2ef7
Sheet: Instructions

Production Record Instructions
Menu:  List the food components for lunch (five food components are required).  Be clear as to which choices are available with each serving line.
For planned quantities, use the on-line Food Buying Guide at:
http://fbg.nfsmi.org
Example: Salisbury Steak & Whole Wheat Roll (M/MA & G), [NAME] (F), Baked Potato (SV), Milk
Ham and Cheese Sandwich (M/MA & G), Orange (F), [NAME] (DGV), Milk
Date/Site:  [NAME] with the date the menu is to be served and the site the menu will be served.
Offer vs. [NAME]:  Check CNPweb to see if the school is approved for offer vs. serve.  [NAME] vs. serve is required in senior high schools and optional for junior high, middle, and elementary schools.  Senior high students may decline two of the five required food components.  Local school food authorities decide if lower grade levels can decline one or two items.
Menu/Component:  List each item of the menu that contributes to the meal requirements.  Include details such as frozen, fresh, diced and actual contribution to the meal pattern.  If grade serving sizes differ, be sure to indicate this on the record.
Other: List all condiments and food items that do not contribute to the meal pattern.
Product or Recipe:  Record the product name or recipe number.  Remember product labels and standardized recipes must be kept in a filing system.
Student Meals:  Record the planned (projected) number of student meals and serving sizes (portion size or scoop size) of each item.
Adult Meals & Al a carte:  Record the number of projected meals/al a carte to be prepared and include serving size.
Quantity Prepared:  Record the total amount to be prepared for all meals and al a carte items.
Purchase Unit:  Record common units of measurement (pound, No. 10 can, each) as purchased.  Round up numbers.
Food Temp.:  These columns can be used as part of your HACCP plan to record food temperatures during preparation/holding and before serving time.
Leftovers:  Document the total amount leftovers and if they will be reused or discarded.
Substitutions:  If a substitution is needed for a menu item, date when the substitution was known and the substituted item.
Actual Number of Meals Served:  Record the actual number of meals served for each category.
Note:  Compare the planned amounts to the actual number of meals served and leftovers.  Make necessary adjustments.  For further information on Menu Planning refer to A Menu Planner for Healthy School Meals, Food Buying Guide for Child Nutrition Programs, and Child Nutrition Program Administrative manual & Regulations 7 CFR 210.10
Spreadsheet: 728413d1618435864-ifs-formula-that-allows-whole-and-decimals-rea-point-tracker-test
Sheet: Thursday

Thursday | 2021-04-15 00:00:00 | Day Shift |  |  |  |  |  | Swing Shift
Last Name | First Name | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Behavior / Attitude | Relationships (staff/peers) | Program/School/GEO | Personal/Room Appearance | Furlough/Outing | Shift Total | Today's Score | REA Bucks | Weekly Average | Weekly REA Bucks
Spreadsheet: 330452d1404753025-nested-if-statements-exel-2010-maximum-reached-oeldere-330447d1404751518-nested-if-statements-exel-2010-maximum-reached-packaging-as-of-june
Sheet: June

PRODUCTION |  |  | June 2014
Customer Name | Item Description | Pallets Produced | Tonns
 | 112/25# D | 65 |  |  | 112/25# |  |  |  |  |  |  | 112/25#
 | 112/25# P | 67 |  |  | 2000# | 1 |  |  |  |  |  | 2000#
 | 112/25# P | 68 |  |  | 2200# |  |  |  |  |  |  | 2200#
 | 2000# D | 93 |  |  | 42/50# |  |  |  |  |  |  | 42/50#
 | 2000# D | 93 |  |  | 45/50# |  |  |  |  |  |  | 45/50#
 | 2000# D | 91 |  |  | 50/50# |  |  |  |  |  |  | 50/50#
 | 2200# P | 86 |  |  | 55/50# |  |  |  |  |  |  | 55/50#
 | 2200# P | 86
 | 2200# P | 87
 | 2200# P | 86
 | 2200# P | 86
 | 55/50# D | 67
 | 55/50# D | 68
 | 55/50# D | 69
 | 55/50# D | 66
 | 55/50# D | 67
 | 55/50# D | 66
 | 55/50# P | 69
 | 55/50# P | 68
 | 55/50# P | 68
 | 55/50# P | 68
 | 55/50# P | 70
 | 55/50# P | 69
 | 55/50# P | 69
 | 55/50# P | 69
 | 55/50# P | 69
 | 55/50# P | 70
 | 55/50# P | 69
 | 42/50# E | 88
 | 42/50# E | 91
 | 42/50# E | 90
 | 42/50# E | 90
 | 50/50# D | 75
 | 50/50# D | 77
 | 50/50# D | 77
 | 50/50# D | 76
 | 50/50# D | 77
 | 50/50# D | 77
 | 45/50# V | 85
Spreadsheet: 456667d1460987719-long-list-show-top-5-example
Sheet: Sheet1

[NAME] | 1st | [NAME]
Scott | 2nd | [NAME]
[NAME] | 3rd | Tie
[NAME] | 4th | Tie
[NAME] | 5th | Tie
[NAME]
[NAME]
Rich
[NAME]
Cleavland
Spreadsheet: 875241d1721827351-allocating-percetage-amount-to-correct-cells-test
Sheet: Sheet1

A | B | C | D |  | 100 | A | B | C | D
55 | 324 | 14 | 1 |  |  | 26.4 | 52.8 | 13.2 | 6.6
25 | -58 | 34 | 44 |  |  | 14.28 | 0 | 28.56 | 57.12
5 | 45 | -18 | 299 |  |  | 14.28 | 28.56 | 0 | 57.12
225 | 71 | 82 | 455 |  |  | 26.4 | 6.6 | 13.2 | 52.8
Spreadsheet: 2f600bc5-96cb-4122-95aa-144b64b5c14e
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688777722 | Satellites & Sirens | Satellites & Sirens | 2010-03-02 | Compact Disc | Ac | 11.99 | N | To Be Retired
Word Records | 80688796426 | Satellites & Sirens | Breaking The Noise Ep | 2009-09-18 | EP version of CD | Ac | 5.99 | N | To Be Retired
Spreadsheet: 779447d1651780768-formula-to-return-the-second-highest-value-in-a-column-excel-example
Sheet: Sheet1

Send Date | Per IP Volume | Total Volume | Audience | Values
2022-06-09 21:07:12 | 50 | 100 |  | 1 - 101
2022-06-11 21:07:12 | 100 | 200 |  | 102 - 302
2022-06-13 21:07:12 | 200 | 400 |  | 202 - 602
2022-06-15 21:07:12 | 400 | 800 |  | 402 - 1202
2022-06-17 21:07:12 | 800 | 1600 |  | 802 - 2402
2022-06-19 21:07:12 | 1600 | 3200 |  | 1602 - 4802
2022-06-21 21:07:12 | 3200 | 6400 |  | 3202 - 9602
2022-06-23 21:07:12 | 6400 | 12800 |  | 6402 - 19202
2022-06-25 21:07:12 | 12800 | 25600 |  | 12802 - 38402
2022-06-27 21:07:12 | 25600 | 51200 |  | 25602 - 76802
2022-06-29 21:07:12 | 51200 | 102400 |  | 51202 - 153602
2022-07-01 21:07:12 | 102400 | 150000 |  | 102402 - 252402 |  |  | I need a formula here to return the second highest  value in this column.  In this case, C12
Spreadsheet: 475a90af-f4c8-44a8-9806-19de01fa5d80
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | FACTORY PRESET LIST |  | Ped |  |  |  | Ped
F11 | SUPER PUNCH |  |  | F61 | DISTORTED 5THS
F12 | CRISP CLEAN OCTABASS |  |  | F62 | SPACE SLAP
F13 | SYNTH BASS |  |  | F63 | FACINATION
F14 | PSEUDO BOW |  |  | F64 | WAH BABY
F21 | EXTREME ENVELOPE |  |  | F71 | GRINDY TREMOLO
F22 | DELAYED PHASE |  |  | F72 | OCTO SOLO
F23 | PEDAL 5 STRING |  |  | F73 | SOUND ON SOUND
F24 | VIBRATO PUNCH |  |  | F74 | INDUSTRIAL ENVELOPE
F31 | EXIT 13 |  |  | F81 | MID PUNCH
F32 | BASS SYNTH |  |  | F82 | DRIPPY
F33 | PICK FLANGE |  |  | F83 | REGGAE MON
F34 | SVT GRIT |  |  | F84 | PEDAL FRETLESS
F41 | CHORUSED CLEAN |  |  | F91 | PEDAL GLISSANDO
F42 | COMPRESSED SLAP |  |  | F92 | WHAMMY UP
F43 | OCTO CAVERN |  |  | F93 | DIRTY TREMOLO
F44 | GROWL WAH |  |  | F94 | OCTABASS
F51 | FAT SUSTAIN |  |  | F101 | SUPER ENVELOPE
F52 | BEEFY AUTOWAH |  |  | F102 | CHEWY OCTAVE
F53 | FAT PICK |  |  | F103 | OCTAVE WHAMMY DOWN
F54 | MID SCOOP |  |  | F104 | FLANGE THING
Digitech BP8 USER PRESET LIST |  |  | Ped |  |  |  | Ped
U11 |  |  |  | U61
U12 |  |  |  | U62
U13 |  |  |  | U63
U14 |  |  |  | U64
U21 |  |  |  | U71
U22 |  |  |  | U72
U23 |  |  |  | U73
U24 |  |  |  | U74
U31 |  |  |  | U81
U32 |  |  |  | U82
U33 |  |  |  | U83
U34 |  |  |  | U84
U41 |  |  |  | U91
U42 |  |  |  | U92
U43 |  |  |  | U93
U44 |  |  |  | U94
U51 |  |  |  | U101
U52 |  |  |  | U102
U53 |  |  |  | U103
U54 |  |  |  | U104
Spreadsheet: 376662d1423673935-dynamic-compound-annual-growth-rate-formula-cagr-dynamic-cagr-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 365
Dates_Annual | 1998-12-31 00:00:00 | 1999-12-31 00:00:00 | 2000-12-29 00:00:00 | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-30 00:00:00 | 2006-12-29 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-30 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 |  |  |  | CAGR
Sales | 813.2 | 363.7 | 533.8 | 817.4 | 698.1 | 790.8 | 768 | 1046.9 | 1813.5 | 2143.8 | 2450.4 | 1945.9 | 1696.8 | 2797.7 | 4300.7 | 4919.8 | 5000
Spreadsheet: 160800d1339199094-lookup-duplicate-values-lookup-nth-instance
Sheet: Problem

 | Top 15 metrics |  | Top 15 labels |  |  |  |  | Named Ranges/[NAME] used in this sheet
 |  |  |  |  |  |  |  | availMonths |  | =Data!$C$6:$T$6
 |  |  |  |  |  |  |  | labels |  | =Data!$B$7:$B$56
 |  |  |  |  |  |  |  | metrics |  | =LARGE(unorderedMetrics,ROW(Data!$1:$16))
 |  |  |  |  |  |  |  | refDate |  | =Data!$C$2
 |  |  |  |  | <- should return Label 5 |  |  | unorderedMetrics |  | =OFFSET(Data!$B$6,1,MATCH(refDate,availMonths,0),50,1)
 |  |  |  |  | <- should return Label 49
Spreadsheet: 134314d1325191333-if-command-to-apply-a-formula-each-time-a-name-appears-commissions-test-spreadsheet
Sheet: Sheet1

Team: | Construction
Period | 2011
KPI's
Unit Sales
Team Members | Weeks | Sales | Avg. Sales | Cash In | Commissions | Placement Bonus | Accelerated Commissions | Management Bonus | Pending Sales | Budget | Expenses | Average
Haigles |  | 1240
Kfly
Brosas
Total
Details |  |  |  |  |  |  |  | Commissions |  |  |  |  | Management
Name | Client | New Title | Team | Billable | Fee % | Fee | Start Date | Cash In | Recruiting | Matching | Marketing | Driving the Deal | Team Lead Override | Team Lead Bonus | Unit Bonus
 |  |  |  |  | 24800 |  |  |  | Haigles | Haigles | Haigles
Spreadsheet: 538811d1505838094-finding-a-point-on-a-grid-armour-trips
Sheet: Atholville

Atholville To: | [NAME]
Bathurst, NB | 72
Belledune, NB | 51
[NAME], QC | 130
Chatham, NB | 116
[NAME], NB | 20
Dartmouth, NS | 349
Edmundston, NB | 121
Eel River Crossing, NB | 17
Fredericton, NB | 236
[NAME], NB | 109
Hartland, NB | 170
Kedgwick, NB | 46
Kentville, NS | 403
[NAME], QC | 53
Matane, QC | 96
Matapedia, QC | 10
[NAME], NB | 209
New Richmond, QC | 56
Newcastle, NB | 118
Newport, QC | 121
[NAME], NB | 248
Pokesudie, NB | 122
[NAME], NB | 97
[NAME], NB | 57
Sussex, NB | 254
Tracadie, NB | 114
Spreadsheet: ed21fb7b-109d-4efd-acb0-f90383479697
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44184722 | 2014-11-26 02:56:37 | AXIS | 1 | 7 | 5 | 578329 | Valentin de Ramillies | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44184929 | 2014-11-26 03:20:43 | ALLIES | 0 | 3 | 7 | 578329 | Valentin de Ramillies | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 53031d1252945247-conditional-formatting-under-changing-condition-shadingcf
Sheet: Sample

 |  |  |  |  | Start Month | apr | 14
Item | Value 1 | Value 2 | Value 3 |  |  | The rows that precede any chosen month ,
A | 20 |  | 17 | Jan |  | [which is the month in cell "G4"], have to be distinct
B | 15 | 10 |  |  |  | from the following rows, by giving them some shading.
 |  |  |  |  |  | If it is March, then tows 8 to 16  to be shaded, if it is
A | 8 | 6 |  |  |  | May instead, the shading should cover rows 8 to 25
 |  |  |  |  |  | and so on.
C | 13 | 11 | 24 | Feb
B | 9
D | 5 |  | 16
D | 23 | 19 |  | Mar
 |  | 25
C |  |  | 14
B | 16 |  |  | Apr
A |  | 14
D |  | 12
C | 27 |  | 13 | May
B |  | 5 | 18
 |  |  |  | Jun
 |  |  |  | Jul
 |  |  |  | Aug
 |  |  |  | Sep
 |  |  |  | Oct
 |  |  |  | Nov
 |  |  |  | Dec
Spreadsheet: 164830d1340902317-excel-2003-matching-similar-names-from-different-columns-some-middle-initial-some-dont-excel-forum-name-match-2
Sheet: Sheet1

Name | Date |  | Name | Date | [NAME] (if exists) | first space | second space | cleave from second space
[NAME], [NAME] | 2012-02 |  | [NAME], [NAME] | 2012-03
[NAME], [NAME] | 2012-03 |  | [NAME], [NAME] | 2012-04
[NAME], [NAME] | 2012-04 |  | [NAME], [NAME] | 2012-05
[NAME], [NAME] | 2012-05 |  | [NAME], [NAME] | 2012-06
[NAME], [NAME] | 2012-06 |  | [NAME], [NAME] | YTD
[NAME], [NAME] | YTD |  | [NAME], Mary | 2012-03
[NAME], [NAME] | 2012-01 |  | [NAME], Mary | 2012-04
[NAME], [NAME] | 2012-02 |  | [NAME], Mary | 2012-05
[NAME], [NAME] | 2012-03 |  | [NAME], Mary | 2012-06
[NAME], [NAME] | 2012-04 |  | [NAME], Mary | YTD
[NAME], [NAME] | 2012-05 |  | Still, [NAME] | 2012-03
[NAME], [NAME] | 2012-06 |  | Still, [NAME] | 2012-04
[NAME], [NAME] | YTD |  | Still, [NAME] | 2012-05
Still, [NAME] | 2012-01 |  | Still, [NAME] | 2012-06
Still, [NAME] | 2012-02 |  | Still, [NAME] | YTD
Still, [NAME] | 2012-03 |  | Durant, | 2012-03
Still, [NAME] | 2012-04 |  | Durant, [NAME] | 2012-04
Still, [NAME] | 2012-05 |  | Durant, [NAME] | 2012-05
Still, [NAME] | 2012-06
Still, [NAME] | YTD
Durant, [NAME] | 2012-01
Durant, [NAME] | 2012-03
Durant, [NAME] | 2012-04
Durant, [NAME] | 2012-05
Durant, [NAME] | YTD
Spreadsheet: 698290d1601906314-seeking-advice-regarding-formulas-for-rebate-template-rebate-test-5-
Sheet: Sheet1

 | Y or N |  |  |  |  |  |  |  |  |  |  | Parameters |  |  |  |  | 2020
Customer Number | New Rebate? | Gate 1 $ | Gate 2 $ | Gate 3 $ | Gate 4 $ | Gate 5 $ | Gate 1 % | Gate 2 % | Gate 3 % | Gate 4 % | Est. 2021 Rev | If NEW must be 500k+ | Contractor must be over $2m to get a top rate of 4% | Contractor must be over $2m to get a rate gate change to 4% | Any change above 4% requires approval | No gate can be changed more than .5% | Gate 1 $ | Gate 2 $ | Gate 3 $ | Gate 4 $ | Gate 5 $ | Gate 1 % | Gate 2 % | Gate 3 % | Gate 4 % | Est. 2020 Gate Achieved | Est. 2020 Rev
101 | Y | 500000 | 750000 | 1000000 | 1500000 | 2000000 | 0.01 | 0.02 | 0.03 | 0.04 | 495000 |  |  |  |  |  | 2025000 | 2225000 | 2325000 |  |  | 0.015 | 0.025 | 0.035 | 0 | 1 | 2100000
Spreadsheet: 97770d1296853940-sumif-help-with-multiple-tabs-payroll-cards-formula-test
Sheet: PSYCH

 |  |  | Hourly | Therapy
 | Hrly Rate | Hrs | Wages | Wages | Salary | OnCall | Total
Noni |  |  |  |  | 517
[NAME] |  |  |  | 1750
[NAME]
[NAME]
[NAME]
[NAME]
Michelle |  |  |  |  | 349.37
Bettina
[NAME] |  |  |  |  | 125
Jessica |  |  |  |  | 2500 | 50
[NAME]
[NAME] |  |  |  | 1380
Spreadsheet: 708616d1607951159-finding-highest-value-across-sheets-book1
Sheet: Wk3

 | 2020-11-01 00:00:00 |  |  |  |  |  |  |  |  | 968
 | 2020-11-02 00:00:00 |  |  |  |  |  |  |  |  | 627
 | 2020-11-03 00:00:00 |  |  |  |  |  |  |  |  | 333
 | 2020-11-04 00:00:00 |  |  |  |  |  |  |  |  | 556
 | 2020-11-05 00:00:00 |  |  |  |  |  |  |  |  | 29
 | 2020-11-06 00:00:00 |  |  |  |  |  |  |  |  | 383
 | 2020-11-07 00:00:00 |  |  |  |  |  |  |  |  | 577
 | 2020-11-08 00:00:00 |  |  |  |  |  |  |  |  | 465
 | 2020-11-09 00:00:00 |  |  |  |  |  |  |  |  | 244
 | 2020-11-10 00:00:00 |  |  |  |  |  |  |  |  | 487
 | 2020-11-11 00:00:00 |  |  |  |  |  |  |  |  | 643
 | 2020-11-12 00:00:00 |  |  |  |  |  |  |  |  | 222
 | 2020-11-13 00:00:00 |  |  |  |  |  |  |  |  | 94
 | 2020-11-14 00:00:00 |  |  |  |  |  |  |  |  | 160
 | 2020-11-15 00:00:00 |  |  |  |  |  |  |  |  | 422
 | 2020-11-16 00:00:00 |  |  |  |  |  |  |  |  | 460
 | 2020-11-17 00:00:00 |  |  |  |  |  |  |  |  | 56
 | 2020-11-18 00:00:00 |  |  |  |  |  |  |  |  | 339
 | 2020-11-19 00:00:00 |  |  |  |  |  |  |  |  | 25
 | 2020-11-20 00:00:00 |  |  |  |  |  |  |  |  | 626
 | 2020-11-21 00:00:00 |  |  |  |  |  |  |  |  | 530
 | 2020-11-22 00:00:00 |  |  |  |  |  |  |  |  | 451
 | 2020-11-23 00:00:00 |  |  |  |  |  |  |  |  | 718
 | 2020-11-24 00:00:00 |  |  |  |  |  |  |  |  | 461
 | 2020-11-25 00:00:00 |  |  |  |  |  |  |  |  | 693
 | 2020-11-26 00:00:00 |  |  |  |  |  |  |  |  | 434
 | 2020-11-27 00:00:00 |  |  |  |  |  |  |  |  | 616
 | 2020-11-28 00:00:00 |  |  |  |  |  |  |  |  | 335
 | 2020-11-29 00:00:00 |  |  |  |  |  |  |  |  | 277
 | 2020-11-30 00:00:00 |  |  |  |  |  |  |  |  | 465
Spreadsheet: 865946d1712901290-power-query-move-every-second-row-book1-290-aligw
Sheet: Sheet1

Emp ID | Level | Employee Name | Attendance/Score |  |  | Emp ID | Level | Employee Name | Attendance | Score
1 | OO1 | A | 0.3 |  |  |  |  |  | 0.3 | 0
1 | OO1 | A | 0 |  |  | 2 | PP1 | B | 0.6 | 1
2 | PP1 | B | 0.6 |  |  | 3 | CC3 | C | 0.8 | 1
2 | PP1 | B | 1 |  |  | 4 | OI11 | D | 0.1 | 0
3 | CC3 | C | 0.8
3 | CC3 | C | 1
4 | OI11 | D | 0.1 |  |  | DESIRED RESULTS
4 | OI11 | D | 0
 |  |  |  |  |  |  | Level | Employee Name | Attendance | Score
RAW |  |  |  |  |  | 1 | OO1 | A | 0.3 | 0
 |  |  |  |  |  | 2 | PP1 | B | 0.6 | 1
 |  |  |  |  |  | 3 | CC3 | C | 0.8 | 1
 |  |  |  |  |  | 4 | OI11 | D | 0.1 | 0
Spreadsheet: 50994d1250600320-comparing-excel-sheets-datasheets
Sheet: Sheet2

Entity | Name | Trade Date | Side | Val | Inst_Desc | Inst_Type | _Date | ID
BC | 0066 | 1909-08-18 00:00:00 | S | 1359 | ADR | EQTY | 2009-12-08 00:00:00 | 88
BED | CVBFGR0058 | 1909-08-18 00:00:00 | P | 100 | EUR | EQTY | 2009-12-08 00:00:00 | 74894
BED | GHGHTGH0183 | 1909-08-19 00:00:00 | P | 100 | EUR | EQTY | 2009-12-08 00:00:00 | 74897
BED | 0089 | 1909-08-18 00:00:00 | P | 1500 | ADR | EQTY | 2009-12-08 00:00:00 | 1391
BED | 0074 | 1909-08-18 00:00:00 | P | 150 | ADR | EQTY | 2009-12-08 00:00:00 | 74890
BED | VVBRTG0041 | 1909-08-19 00:00:00 | P | 100 | EUR | EQTY | 2009-12-08 00:00:00 | 74895
BED | FGFGFHC01 | 1909-08-19 00:00:00 | P | 100 | EUR | EQTY | 2009-12-08 00:00:00 | 74896
BED | ABCD0036 | 1909-08-18 00:00:00 | S | 500 | EUR | EQTY | 2009-12-08 00:00:00 | 74891
BED | ADFGH0004 | 1909-08-18 00:00:00 | S | 100 | EUR | EQTY | 2009-12-08 00:00:00 | 74892
Spreadsheet: 47644d1246770499-how-do-i-count-a-date-if-it-falls-between-two-dates-specified-in-other-cells-excel-june-bill
Sheet: JUNE BILL

[NAME] | 2009-06-01 00:00:00 |  |  |  |  | Per Diem | 37.18
[NAME] | 2009-06-30 00:00:00
Sex | Type | ID # | Last Name | First Name | Service Type | Admit Dt | [NAME] | [NAME] | Billable Days | Cost | Count as Admit?
M | DOCC | 223344 | [NAME] | MICKEY | FULL | 2009-05-31 00:00:00 | 2009-06-01 00:00:00 | 2009-06-20 00:00:00 | 20 | 743.6
F | DOCP | 457678 | [NAME] | MINNIE | FULL | 2009-04-03 00:00:00 | 2009-06-01 00:00:00 | 2009-06-30 00:00:00 | 30 | 1115.4
F | MTND | 423112 | RA | SHE | FULL | 2009-06-22 00:00:00 | 2009-06-23 00:00:00 | 2009-06-27 00:00:00 | 5 | 185.9
TOTAL |  |  |  |  |  |  |  |  | 55 | 2044.9