tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 25949d1217652726-retreiving-data-from-vlookup-mikes-vlookup
Sheet: Mike

1 | Col B 1 | Col C 1 | Col D 1 | Col E 1
2 | Col B 2 | Col C 2 | Col D 2 | Col E 2
3 | Col B 3 | Col C 3 | Col D 3 | Col E 3
4 | Col B 4 | Col C 4 | Col D 4 | Col E 4
5 | Col B 5 | Col C 5 | Col D 5 | Col E 5
6 | Col B 6 | Col C 6 | Col D 6 | Col E 6
7 | Col B 7 | Col C 7 | Col D 7 | Col E 7
8 | Col B 8 | Col C 8 | Col D 8 | Col E 8
9 | Col B 9 | Col C 9 | Col D 9 | Col E 9
10 | Col B 10 | Col C 10 | Col D 10 | Col E 10
11 | Col B 11 | Col C 11 | Col D 11 | Col E 11
12 | Col B 12 | Col C 12 | Col D 12 | Col E 12
13 | Col B 13 | Col C 13 | Col D 13 | Col E 13
14 | Col B 14 | Col C 14 | Col D 14 | Col E 14
15 | Col B 15 | Col C 15 | Col D 15 | Col E 15
16 | Col B 16 | Col C 16 | Col D 16 | Col E 16
17 | Col B 17 | Col C 17 | Col D 17 | Col E 17
18 | Col B 18 | Col C 18 | Col D 18 | Col E 18
19 | Col B 19 | Col C 19 | Col D 19 | Col E 19
20 | Col B 20 | Col C 20 | Col D 20 | Col E 20
Spreadsheet: 526310d1499251833-countifs-matching-rows-and-column-values-countifs
Sheet: Sheet1

Atts type | Ny times | Financial times | Daily | Metro Sun
Attendee | True |  | True
Non-atts |  | True |  | True
Non-atts |  | True |  | True
Attendee | True |  | True
Non-atts |  | True | True
Attendee | True |  |  | True
Attendee | True |  | True
Spreadsheet: 861442d1709295731-formule-to-show-multiples-of-1-cel-only-order-form-multiples-avk
Sheet: Blad1

Product | Min. order quantity | order quanity | Lot Box |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  | Here Select LB Min 1 Max 100 |  | 1
Item A | 24 |  | 7
Item B | 56 |  | 9
Item C | 51 |  | 90
Item D | 39 |  | 72
Spreadsheet: 721279d1614621990-excel-formula-to-transpose-data-from-a-master-sheet-to-other-worksheets-sample-for-discussion
Sheet: MASTER SHEET 

Supplier | Order Number: | Date: | Products | Product Code: | Colour: | [NAME]: | Quantity | Ordered? | In stock? | If Not - Due Date? | Comments
A | 12346 | 02.02.20 |  |  |  |  |  |  | YES
A | 12345 | 02.02.20 | footwear | c124 | black | 5 | 1 |  | NO
b | 12352 | 05.02.2021
b | 12347 | 04.02.20 | Boots | 5236 | [NAME] | 7 | 1 |  | NO
b | 12348
b | 12350 | 04.02.2021 | boots
Spreadsheet: tracy_geaccone__40252__C0366-112458
Sheet: Dept_100186

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
FACILITY OPERATIONS - Dept. 100186
April, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-04-19 00:00:00 | FOP100186-2001-04-0366-112458 |  | Facilities Operations | Sq. Ft. Occupied | 666 | 0.05 | /EACH | 31.97
 |  |  |  |  |  |  | Ticket Total |  | 31.97
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 31.97
 |  |  |  |  |  |  | Total for Dept_100186 |  | 31.97
Spreadsheet: 107152d1304364775-excel-2007-paste-current-date-to-a-row-in-a-sheet-service-sample
Sheet: Service Data

Today | 2011-05-02 00:00:00
Today-5 | 2011-04-27 00:00:00 | Last Serviced | 5
Service Date | Service Date
<=40660
Serial Number | Instrument | Manufacturer | First Name | Last Name | Address | City, State, Zip | Phone Number | Service Date | Rental? | Service Contract? | [NAME]
123456 | sax | selmer | [NAME] | wilson | 1 Oak Forest Drive | St. Charles, Mo 63301 | [PHONE] | 2011-05-01 00:00:00 | No | No | [EMAIL] |  |  | Serial Number | Instrument | Manufacturer | First Name | Last Name | Address | City, State, Zip | Phone Number | Service Date | Rental? | Service Contract? | [NAME]
124578 | Flute | armstrong | Julie | johns | 123 Rue Grand | lsl, mo 63263 | [PHONE] | 2011-04-01 00:00:00 | Yes | Yes | [EMAIL]
44125 | [NAME] | loree | [NAME] | [NAME] | 23 Elm street | o'fallon,MO 63345 | [PHONE] | 2011-03-01 00:00:00 | No | No | [EMAIL]
44784m | piccolo | Haynes | [NAME] | Smith | 85 Cherry Street | St. Peters, Mo 63367 | [PHONE] | 2011-02-01 00:00:00 | Yes | Yes | [EMAIL]
456789 | Bassoon | Fox | [NAME] | Jans | 45 Forest Park Drive | St. Louis, MO 63031 | [PHONE] | 2010-12-10 00:00:00 | No | No | [EMAIL]
Spreadsheet: 767753d1644605504-sumifs-function-that-looks-at-the-timestamp-to-determine-whether-to-sum-excel-time-sample
Sheet: Sheet1

Timestamp |  |  |  | Amt
1/10/2022 2:13:44 PM |  |  |  | 25 |  |  |  | COUNT | SUM
1/10/2022 2:13:44 PM |  |  |  | 50 |  |  | 5 or earlier |  |  |  | <  What I have now (my formulas don't work)
1/10/2022 2:13:44 PM |  |  |  | 25 |  |  | After 5
1/10/2022 2:13:44 PM |  |  |  | 20
1/10/2022 2:43:09 PM |  |  |  | 200
1/10/2022 3:29:03 PM |  |  |  | 50
1/10/2022 4:25:26 PM |  |  |  | 100
1/10/2022 4:26:22 PM |  |  |  | 100 |  |  |  | COUNT | SUM
1/10/2022 5:46:49 PM |  |  |  | 30 |  |  | 5 or earlier | 8 | 570 |  | <  What I want it to be (these are hardcoded)
1/10/2022 5:46:49 PM |  |  |  | 50 |  |  | After 5 | 10 | 1290
1/10/2022 5:46:49 PM |  |  |  | 10
1/10/2022 5:46:49 PM |  |  |  | 200
1/10/2022 5:46:49 PM |  |  |  | 150
1/10/2022 5:46:49 PM |  |  |  | 200
1/10/2022 5:46:49 PM |  |  |  | 50
1/10/2022 5:46:49 PM |  |  |  | 100
1/10/2022 5:46:49 PM |  |  |  | 100
1/10/2022 5:46:49 PM |  |  |  | 400
Spreadsheet: cd3025f5-8e10-4f80-b586-8ad258b7ba3e
Sheet: F4

 | 4 |  |  |  |  |  |  |  | Purchased Cost of Nutrient
 | Inputs
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the name of this feed? |  | Corn |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Feed | Price per Unit | lbs per unit | %DM | CP | TDN |  |  |  | Rate per mile | miles | Units per load |  | Waste (per cent) |  | Price per Unit | Waste (per cent) |  | Price per Unit | Waste (per cent) | Units consumed
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much does this feed cost? | $ | 6.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | The above price is for how many pounds of feed? |  | 2000 | pounds per unit
 |  | What is the percent dry matter? |  | 0.88 |  |  |  |  | Delivered Cost of Nutrient
 |  | What is the percent Crude Protein (on a DM basis) |  | 0.09 |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | What is the percent TDN (on a DM basis) |  | 0.77 |  |  |  |  |  | $ |  | per pound of TDN
 |  | How far will this feed be transported? |  | 60 | miles |  |  |  |  | $ |  | per pound of DM
 |  | What is the cost per loaded mile? | $ | 5 | per mile
 |  |  |  |  |  |  |  |  | Fed Cost of Nutrient
 |  |  |  | 900
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | How much of the feed will be lost in hauling? |  | 0.005
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | How much will it cost to store this feed? | $ | 0.25
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | How much of the feed will be lost in storage? |  | 0.02
 |  | How much will it cost to feed this feed? | $ | 0.1 |  |  |  |  | Consumed Cost of Nutrient
 |  | How much will be lost when feeding? |  | 0.05 |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
Spreadsheet: 38281d1236375264-conditional-formula-for-unique-issues-issues-list
Sheet: pivot

 |  |  | Data
Issue Topic | School | Start Date | Count of End Date | Average of Length
Fire | Boronia | 2009-01-01 00:00:00 | 2 | 6
water | Boronia | 2009-02-02 00:00:00 | 1 | 150
 | [NAME] | 2009-03-02 00:00:00 | 1 | 3
Grand Total |  |  | 4 | 41.25
Spreadsheet: 490711d1480012458-breaking-a-table-of-2000-rows-and-80-columns-into-a-list-book4
Sheet: Sheet1

 |  |  | a | b | c | d | e | f | g
 |  | h | x | x |  |  | x |  | x
 |  | i |  | x | x | x
 |  | j | x |  |  | x |  | x
 |  | k |  | x |  |  | x
 |  | l | x | x |  | x | x
 |  | m | x |  |  |  |  | x | x
 |  | n |  |  | x
Spreadsheet: 889929d1740963326-separating-numbers-out-of-a-combination-of-text-and-numbers-and-some-text-only-mwal13-mw_030325-tms
Sheet: Sheet1

PID | DISEASE CODE | [NAME] | Final | Final description
178654 | 56007 | 56007 - CT BRAIN WITH CONTRAST |  | [NAME] WITH CONTRAST
178654 | 56501KUB | CT CERVICAL SPINE W/OUT CONTRAST |  | CT CERVICAL SPINE W/OUT CONTRAST
257591 | 56507 | CT KUB |  | CT KUB
987654 | 57357 | CT ABDOMEN & PELVIS WITH CONTRAST |  | CT ABDOMEN & PELVIS WITH CONTRAST
257591 | 56007 | 56007 - CT BRAIN WITH CONTRAST |  | [NAME] WITH CONTRAST
373605 | 57357 | CT SOFT TISSUE NECK WITH CONTRAST |  | CT SOFT TISSUE NECK WITH CONTRAST
987654 | 56507 | CT BRAIN W/OUT CONTRAST |  | CT BRAIN W/OUT CONTRAST
257591 | 56409 | CT ABDOMEN & PELVIS WITH CONTRAST |  | CT ABDOMEN & PELVIS WITH CONTRAST
178654 | 56220 | CT ABDOMEN & PELVIS WITH CONTRAST |  | CT ABDOMEN & PELVIS WITH CONTRAST
373903 | 56501KUB | CT ABDOMEN & PELVIS WITH CONTRAST |  | CT ABDOMEN & PELVIS WITH CONTRAST
337398 | 56507 | [NAME] ANGIOGRAM |  | [NAME] ANGIOGRAM
987654 | 56001 | 56001 - CT BRAIN W/OUT CONTRAST |  | CT BRAIN W/OUT CONTRAST
178654 | 56001 | 56001 - CT BRAIN W/OUT CONTRAST |  | CT BRAIN W/OUT CONTRAST
 |  |  |  | [NAME] WITH CONTRAST
 |  |  |  | CT CERVICAL SPINE W/OUT CONTRAST
 |  |  |  | CT KUB
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  | 56007 | [NAME] WITH CONTRAST
 |  |  |  | CT SOFT TISSUE NECK WITH CONTRAST
 |  |  |  | CT BRAIN W/OUT CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | [NAME] ANGIOGRAM
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
 |  |  |  | [NAME] WITH CONTRAST
 |  |  |  | CT CERVICAL SPINE W/OUT CONTRAST
 |  |  |  | CT KUB
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  | 56007 | [NAME] WITH CONTRAST
 |  |  |  | CT SOFT TISSUE NECK WITH CONTRAST
 |  |  |  | CT BRAIN W/OUT CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | [NAME] ANGIOGRAM
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
 |  |  |  | [NAME] WITH CONTRAST
 |  |  |  | CT CERVICAL SPINE W/OUT CONTRAST
 |  |  |  | CT KUB
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  | 56007 | [NAME] WITH CONTRAST
 |  |  |  | CT SOFT TISSUE NECK WITH CONTRAST
 |  |  |  | CT BRAIN W/OUT CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | CT ABDOMEN & PELVIS WITH CONTRAST
 |  |  |  | [NAME] ANGIOGRAM
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
 |  |  | 56001 | CT BRAIN W/OUT CONTRAST
Spreadsheet: 889857d1740823264-exel-2013-conditional-formatting-lowest-8-scores-and-12-highest-scores-from-last-20-entri-format-last-20-scores-in-column
Sheet: Sheet1

Overall Scores | [NAME] | [NAME] | [NAME]
Handicap
Differential
Handicap Index
Lowest 8 scores average from last 20  (or less ,see table 1)
2024-08-12 00:00:00 | 69 | 65 | 82
2024-08-15 00:00:00 | 73 | 64 | 80
2024-08-19 00:00:00 | 71 | 66 | 78
2024-08-22 00:00:00 | 70 | 69 | 82
2024-08-26 00:00:00 | 68 | 69 | 79 |  | 71 | Indicates lowest 8 scores of last 20 played
2024-08-29 00:00:00 | 75 | 67 | 78 |  | 85 | Indicates rest of scores of last 20 played
2024-09-02 00:00:00 | 80 | 75 | 87
2024-09-09 00:00:00 | 74 | 67 | 69 |  | At the moment  I use Conditional Formating to indicate the bottom 8 scores of last 20 played (via Format the top and bottom rankled values only rule).But I have to manually count back last 20 scores excluding blanks everytime new scores are added. Could this be done automatically.
2024-09-16 00:00:00 |  | 65 | 78
2024-09-26 00:00:00 | 68 |  | 71
2024-10-03 00:00:00 | 75
2024-10-07 00:00:00 | 72 | 68
2024-10-10 00:00:00 |  | 64
2024-10-14 00:00:00 | 76 | 66 | 79
2024-10-21 00:00:00 | 74 | 70 | 75
2024-10-24 00:00:00 |  | 67 | 76
2024-10-28 00:00:00 | 74 | 71 | 69
2024-10-31 00:00:00 | 71 | 69 | 77
2024-11-04 00:00:00 | 75 | 69 | 79
2024-11-11 00:00:00 | 81 | 67 | 78
2024-11-14 00:00:00 | 67 | 68 | 79
2024-11-18 00:00:00 |  | 66 | 72
2024-11-25 00:00:00 | 66 | 76 | 71
2024-11-28 00:00:00 | 78 | 70 | 74
2024-12-02 00:00:00 | 68 | 61
Spreadsheet: louise_kitchen__22631__Pioneer Chlor sale
Sheet: Analysis

Pioneer Chlor
Sale Calculation
09/25/01
If ENA (Condor) and [NAME] each receive 50% of total proceeds:
 |  | Gross
 |  | ENA (Condor) | [NAME] | Total |  | Net to ENA
Proceeds |  | 10375000 | 10375000
Less:
Carry Value |  | 9267000.33 | 9267000
Interest Receivable |  | 633378.63 | 633378.63
Gain on Sale
Less estimated transaction costs:
Out of Pocket (legal, other) |  | -153000 | 153000
CSFB fee (.5% of total proceeds)
Total estimated transaction costs
=Net gain on sale after transaction costs
If ENA (Condor) receives proceeds from [NAME] to cover [NAME] share of estimated transaction costs:
 |  | Gross
 |  | ENA (Condor) | [NAME] | Total |  | Net to ENA
Proceeds
Less:
Carry Value |  | 9267000.33 | 9267000
Interest Receivable |  | 633378.63 | 633378.63
Gain on Sale
Less estimated transaction costs:
Out of Pocket (legal, other) |  | -153000 | 153000
CSFB fee (.5% of total proceeds) |  | 51875 | 51875
Total estimated transaction costs
=Net gain on sale after transaction costs
Spreadsheet: 023ce056-7d2c-4144-836c-311d9da8fade
Sheet: SY 10-11 Price Calculator

 | SY 2010-2011 Weighted Average Price Calculator
 | Enter current prices and number of lunches sold at each price using October 2010 data.
 | Monthly # of Paid Lunches | Paid Lunch Price | Monthly Revenue | SY 2010-11 Weighted Average Price
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
TOTAL |  |  |  |  | is the SY2010-2011 weighted average price
 |  |  | Rounded Weighted Avg Price
 |  |  |  |  |  | Enter this price in the first data entry box on the SY2011-12 Price Requirement tab
 | Click to go back to Unrounded Requirement Finder |  |  |  |  | Go to instructions
Note:  This tool is created to allow the user to only enter the number of paid lunches and the related prices.  If any other parts of the tool are modified, the user runs the risk of calculating an incorrect new average price.  [NAME] should not modify the tool's current functionality.
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: Amoco

 | Florida Plant
Day | Measured | Scheduled | Imbal
1 | 136208 | 142148
2 | 91841 | 120259
3 | 95240 | 97445
4 | 116769 | 114074
5 | 108530 | 114453
6 | 119572 | 113703
7 | 112545 | 111866
8 | 112164 | 113431
9 | 113044 | 111560
10 | 116403 | 112898
11 | 103748 | 104833
12 | 107912 | 106898
13 | 120413 | 125960
14 | 113885 | 111354
15 | 116049 | 114316
16 | 112428 | 116998
17 | 107540 | 109346
18 | 103802 | 104079
19 | 93807 | 102057
20 | 92618 | 90965
21 | 103978 | 103248
22 | 136225 | 140467
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 54883
2001-08-23 00:00:00
CBS Dollars
 |  |  | 411751.53
Spreadsheet: 155506d1336904001-arrays-question-anotherwa2doit2
Sheet: Sheet1

 | [NAME] | coef | Inga | coef | Alise | coef | today() |  | [NAME] | Alise | Inga
[NAME] | 2012-01-01 00:00:00 | 1.688710444469143 | 2012-01-06 00:00:00 | 1.371252155020653 | 2012-01-15 00:00:00 | 1.040553926723608 | 2012-02-14 00:00:00 |  | 2012-03-25 00:00:00 | 2012-02-18 00:00:00 | 2012-03-31 00:00:00
Alise | 2012-02-13 00:00:00 | 0.9871740102151009 | 2012-02-14 00:00:00 | 0.8076068832731258 | 2012-02-18 00:00:00 | 0.6022022025140813 |  |  | 0.07976106303538122 | 0.6022022025140813 | 0.1160746904611686
Inga | 2012-03-25 00:00:00 | 0.07976106303538122 | 2012-03-31 00:00:00 | 0.1160746904611686 | 2012-03-15 00:00:00 | 0.5758473982879398
 |  |  |  | 0.07976106303538122
 |  |  |  | 0.6022022025140813
 |  |  |  | 0.1160746904611686
Spreadsheet: 217890d1362241957-sum-totals-purchase-bb-
Sheet: L10-0030-000

L10-0030-000
Part # | Description | QTY | [NAME]
20830-01 | 2
30020-01 | 2
30081-01 | 3
30081-03 | 1
30081-05 | 1
30125-01 | 1
30220-01 | 3
30334-01 | 2
30338-01 | 5
30345-01 | 2
Spreadsheet: 847695d1698541503-why-does-the-filter-function-work-this-way-table_sort
Sheet: Sheet1

 |  |  |  |  |  | Unsorted |  |  |  |  | Sorted
Prgrm # | Factors | Rank |  |  | Prgrm # | Factors | Rank |  |  | Prgrm # | Factors | Rank
1 | 19 |  |  |  |  | 22 | 2 |  |  |  | 22 | 2
2 | 19 |  |  |  | 5 | 25 | 1 |  |  | 5 | 25 | 1
3 | 22
4 | 15
5 | 25
6 | 20
7 | 10
 |  |  |  |  |  | Unsorted |  |  |  |  | Sorted
Prgrm # | Factors | Rank |  |  | Prgrm # | Factors | Rank |  |  | Prgrm # | Factors | Rank
1 | 19 |  |  |  |  | 22 | 2 |  |  |  | 25 | 1
2 | 19 |  |  |  | 5 | 25 | 1 |  |  | 3 | 22 | 2
3 | 22
4 | 15
5 | 25
6 | 20
7 | 10
Spreadsheet: 154203d1336305384-accounting-ebt-and-negative-tax-ebt
Sheet: Sheet1

Year | 2010 | 2011 | 2011 | 2012 | 2013 | 2014 | 2014 | 2015 | 2016
Earnings before taxes | 100 | 50 | -60 | -20 | 70 | 100 | 100 | -20 | 80 |  | Input actual year figures in this row
Helper row | 100 | 50 | -60 | -80 | -10 | 90 | 100 | -20 | 60 |  | This carries forward any negative from previous years
Net earnings for the year | 74 | 37 | -60 | -80 | -10 | 66.6 | 74 | -20 | 44.4 |  | This calculates net earnings
Tax | 26 | 13 | 0 | 0 | 0 | 23.4 | 26 | 0 | 15.6
Tax | 0.26
Spreadsheet: 101731d1299792082-multiple-ifs-up-to-2-claims
Sheet: Sheet1

Claim | Fee | Fee (Adjusted) | Party Paid
Claim 1 | 227.5 |  | 150
Claim 2 | 227.5 |  | 150
Claim 3 | 227.5 |  | 55
Claim 4 | 1325 |  | 195
Claim 4 | 1325 |  | 195
Claim 5 | 227.5 |  | 125
Claim 6 | 280 |  | 150
Claim 7 | 227.5 |  | 55
Claim 8 | 1100 |  | 135
Claim 8 | 1100 |  | 135
Claim 9 | 262.5 |  | 55
Spreadsheet: a84311c3-590c-49dc-a3a8-7108688f1582
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | [PHONE] | Anointed | If We Pray | 2001-10-03 | Compact Disc | Ac Pop | 13.99 | N | To Be Retired
Word Records | [PHONE] | Anointed | Best Of Anointed, The | 2003-09-23 | Compact Disc | Ac | 7.99 | Y | Available
Taseis | [PHONE] | The Anointed Pace Sisters | Return | 2006-10-24 | Compact Disc | Black Gospel | 17.99 | Y | Available
Taseis | [PHONE] | The Anointed Pace Sisters | Return | 2006-10-24 | Music DVD | Black Gospel | 19.97 | Y | Available
Taseis | [PHONE] | The Anointed Pace Sisters | Access Granted | 2009-10-20 | Compact Disc | Gospel | 15.99 | Y | Available
Taseis | [PHONE] | The Anointed Pace Sisters | Access Granted | 2009-10-20 | Music DVD | Gospel | 15.99 | Y | Available
Taseis | [PHONE] | The Anointed Pace Sisters | Return | 2006-12-05 | Postcard | Black Gospel | 1 | N | To Be Retired
Taseis | 014998418327BB | The Anointed Pace Sisters | Access Granted (Bargain Bin) | 2013-01-22 | Compact Disc | Gospel | 6.99 | Y | Available
Spreadsheet: 718876d1613402195-index-and-match-function-with-several-columns-roster-vs-schedule-example
Sheet: Names

Student Name | System | Site
Student 1 | System 1 | Site 1 (existing)
Student 2 | System 6 | Site 2
Student 3 | System 7 | Site 3
Student 4 | System 5 | Site 1
Student 5 | System 8 | Site 2 (existing)
Student 6 | System 2 | Site 3
Student 7 | System 7 | Site 1
Student 8 | System 3 | Site 2
Student 9 | No System | Site 3
Student 10 | System 8 | Site 1
Student 11 | System 3 | Site 2
Student 12 | System 10 | Site 3
Student 13 | System 9 | Site 1
Student 14 | System 5 | Site 2
Student 15 | No System | Site 3
Student 16 | System 8 | Site 1
Student 17 | System 9 | Site 2
Student 18 |  | Site 3
Student 19 |  | Site 1
[NAME] |  | Site 2
Spreadsheet: 844117d1695907756-totalling-columns-from-one-sheet-onto-another-monthly-business-for-help
Sheet: Oct 2023 - Sept 2024

MONTH OF EVENT | START OF EVENT | DATE RANGE | POTENTIAL % | ACTUAL % EXC VAT
October | 2023-10-01 00:00:00 | 1-14 Oct 23
October | 2023-10-01 00:00:00 | 1-4 Oct 23 | 2500
October | 2023-10-02 00:00:00 | 2-6 Oct 23 | 1632
October | 2023-10-04 00:00:00 | 4-5 Oct 23
September | 2023-10-04 00:00:00 |  | 400
October | 2023-10-10 00:00:00 | 10-12 Oct 23 | 9600
October | 2023-10-10 00:00:00 | 10-11 Oct 23 | 320
October | 2023-10-10 00:00:00 | 2023-10-10 00:00:00 | 95
October | 2023-10-11 00:00:00 | 11-12 Oct 23
October | 2023-10-12 00:00:00 | 12-13 OC 23
October | 2023-10-15 00:00:00 | 15-18 Oct 23 | 4400
October | 2023-10-16 00:00:00 | 16 - 18 Oct 23 | 60
October | 2023-10-17 00:00:00 | 17-21 Oct 23 | 33800
October | 2023-10-17 00:00:00 | 2023-10-17 00:00:00 | 300
October | 2023-10-17 00:00:00 | 17-18 Oct 23
Spreadsheet: 786420d1657188079-formula-to-calculate-tasks-for-the-weeks-sumifs
Sheet: ExpectedResult

 | Expected Result
 | Consolidation
 |  | W1 | [NAME] | W3 | W4 | W5 | W6 | W7
 | Task 1 | 6 | 5 |  | 5 | 5
 | Task 2 | 5 | 3 |  | 6 | 3
 | Task 3 | 3 |  |  | 1
 | Task 4 |  | 3 |  | 6
Spreadsheet: 6177f747-f3c8-49e9-bc98-468709d1f6df
Sheet: Sheet1

Unnamed: 0 | Janauary 2014 - 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 | 8 | 9 | 10 | 11
 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 26 | 27 | 28 | 29 | 30 | 31
Spreadsheet: 13cad7e5-a7bb-4121-9faf-ffdccc7b8550
Sheet: Sheet1

Snap-on Tools - Merchandise | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Location | Name | Title | Phone | Fax | [NAME]
Kenosha, WI | [NAME] | President – Merchandise | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Director, Merchandise Products | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Hand Tools | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Hand Tools | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Power Tools | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Equipment | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Diagnostics | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager – Equipment | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Category Manager–Tool Storage & Equipment | [PHONE] | [PHONE] | [EMAIL]
Kenosha, WI | [NAME] | Director, Merchandise Products (RWD) | [PHONE] | [PHONE] | [EMAIL]