tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 193978d1353000977-comparision-of-data-if-excel-question-11-15-12
Sheet: NEW

[NAME] | Description | Components | Validation (Legacy) *Expected Result* | Number of Components (Legacy) *Expected Result* | Percentage of B.O.M. | Validation percentage (Legacy) *Expected Result*
901374 | Chicken | 801041 | If 901374 has component 801041 legacy then return 801041 | Return the number of components in legacy 901374 tab | 0.001111 | If in D2 the component is found then return the percentage of B.O.M. in legacy column D
901374 | Chicken | 801224 | If 901374 has component 801224 legacy then return 801224 | Return the number of components in legacy 901374 tab | 0.002244 | If in D3 the component is found then return the percentage of B.O.M. in legacy column D
901374 | Chicken | 1000711 | If 901374 has component 1000711 in legacy then return 1000711 | Return the number of components in legacy 901374 tab | 0.000556 | If in D4 the component is found then return the percentage of B.O.M. in legacy column D
901374 | Chicken | Open | Return any additional components of 901374 in legacy if applicable | Return the number of components in legacy 901374 tab
901374 | Chicken | Open | Return any additional components of 901374 in legacy if applicable | Return the number of components in legacy 901374 tab
901450 | Beef | 101927 |  |  | 0.041667
901450 | Beef | 801041 |  |  | 0.001754
901450 | Beef | 801541 |  |  | 0.042083
901450 | Beef | 801758 |  |  | 1.03
901450 | Beef | 901450_RETORT |  |  | 1
901451 | Lemon | 101927 |  |  | 0.041667
901451 | Lemon | 801041 |  |  | 0.001122
901451 | Lemon | 801753 |  |  | 1.02
901451 | Lemon | 801759 |  |  | 0.042083
901451 | Lemon | 901451_RETORT |  |  | 1
901452 | Sesame | 101927 |  |  | 0.041667
901452 | Sesame | 801041 |  |  | 0.001122
901452 | Sesame | 801755 |  |  | 1.02
901452 | Sesame | 801759 |  |  | 0.042083
901452 | Sesame | 901452_RETORT |  |  | 1
Spreadsheet: rick_buy__32857__DOUG
Sheet: 0501

4
POWER PLANTS  ACCOUNTS RECEIVABLE AGING
AS OF MAY 31, 2001
 |  |  | CURRENT |  | 1-30 |  | 31-60 |  | 61-90 |  | OVER 90 |  | TOTAL | COMMENTS
SMITH ENRON | A/R |  | 1463248.43 |  | 1249148.06 |  | 5532167.67 |  | 2567970.69 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  | 0 |  | 0 |  |  |  |  | 0
PUERTO QUETZAL | A/R |  | 0 |  | 0 |  | 0 |  | 0 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 2490724.78
HAINAN MEINAN | A/R |  |  |  |  |  |  |  |  |  | 68695.76
 | PER CENT
DABHOL POWER CO | A/R |  | 442285.18 |  | 222492.95 |  | 0 |  | 121847.95 |  |  |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 0
EMPRESA ENERGETICA | A/R |  | 0 |  | 0 |  | 1038874.2 |  | 0 |  | 74964.58 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | 960474.71
EGEMINSA | A/R |  | 5395360.85 |  | 6518635.31 |  | 1980111 |  | 15838.52 |  | 135363.86 |  |  | THIS MONTH TOTAL PAYMENTS
 | PER CENT
TOTALS | A/R
 | PER CENT |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL RECEIPTS
Spreadsheet: 195660d1353593624-find-all-names-according-to-data-00___fotis_find_name_example
Sheet: Sheet1

NAME | DEPARTMENT | POSITION | [NAME]
[NAME] | Human recourses | Administrator | 50000
[NAME] | Animation | Lead | 70000
Julie | Compositing | Junior | 50000
Martin | Animation | Junior | 35000
[NAME] | Fabrication | Lead | 50000
[NAME] | Animation | Junior | 30000
Pinkus | Compositing | Lead | 70000
Roberta | Fabrication | Junior | 30000
DEPARTMENT | 70000
POSITION | Junior
[NAME]
Spreadsheet: 92050d1291728088-need-to-divide-hours-evenly-between-multiple-fields-to-maintain-averages-solver_production_test2
Sheet: Test 2

Test 2
PRODUCT | Custom Built | Hours | CBPH |  | AVERAGE | keep as close as possible
Sedans & Coupes | 6.7 | 2 | 3.35 |  | 3.3
Sedans & Coupes & Assistance | 6.7 | 3 | 2.233333333333333 |  | 2.6
Sedans | 3.2 | 1 | 3.2 |  | 3.2
Cycle | 10 | 1 | 10 |  | 10
Coupes | 3.5 | 1 | 3.5 |  | 3.5
Assistance | N/A | 1 | 0.25 |  | 0.18
 | TOTAL HOURS | 4
 | Target tot hrs | 8
I've added a starting value in C5
Spreadsheet: 38411d1236598118-excel-2007-issue-with-using-formulas-to-pull-data-from-one-sheet-to-another-lwnnsalariesprojections
Sheet: Giants

San Francisco Giants | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 |  | San Francisco Giants | 2009 | 2010 | 2011 | 2012 | 2013 | 2014
Actual |  |  |  |  |  |  |  | Operations
Budget | 90 | 90 | 90 | 90 | 90 | 90
Difference |  |  |  |  |  |  |  | Fan Base Factors
 |  |  |  |  |  |  |  | Record Reward
Cost of Goods
Personnel |  |  |  |  |  |  |  | Income
Chaffee, [NAME] | ML | ML | ML | ML | ML | ML |  | From Indians | -0.3
Hicks, [NAME] | ML | ML | ML | ML | ML | ML |  | From Yankees | -3 | -2
[NAME], Hak-Ju | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML |  | Expenses
[NAME] | ML | ML | ML | ML | ML | ML |  | [NAME], [NAME] | 1.4
Angelini, Carmen | ML | ML | ML | ML | ML | ML |  | Gibbons, [NAME] | 1.3 | 1.3
Baez, [NAME] | ML | ML | ML | ML | ML | ML |  | To Blue Jays | 7.6 | 0.3
Betances, Dellin | ML | ML | ML | ML | ML | ML |  | To Diamondbacks | 3.3
Carignan, [NAME] | ML | ML | ML | ML | ML | ML |  | To Indians | 2 | 2
Gillespie, Cole | ML | ML | ML | ML | ML | ML |  | To Nationals | 3.5
[NAME], Greg | ML | ML | ML | ML | ML | ML |  | To Yankees |  |  | 0.6
[NAME], Hector | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Herrera, Javier | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Lemon, Marcus | ML | ML | ML | ML | ML | ML
McCutchen, [NAME] | ML | ML | ML | ML | ML | ML
Morales, Franklin | ML | ML | ML | ML | ML | ML
Niese, [NAME] | ML | ML | ML | ML | ML | ML
Noonan, Nick | ML | ML | ML | ML | ML | ML
[NAME], Chad | ML | ML | ML | ML | ML | ML
Revere, [NAME] | ML | ML | ML | ML | ML | ML
Scarpetta, [NAME] | ML | ML | ML | ML | ML | ML
Snyder, [NAME] | ML | ML | ML | ML | ML | ML
[NAME], [NAME] | ML | ML | ML | ML | ML | ML
Sulentic, [NAME] | ML | ML | ML | ML | ML | ML
Teheran, [NAME] | ML | ML | ML | ML | ML | ML
Tejada, Ruben | ML | ML | ML | ML | ML | ML
[NAME], Kanekoa | ML | ML | ML | ML | ML | ML
Veal, [NAME] | ML | ML | ML | ML | ML | ML
Young, Delwyn | ML | ML | ML | ML | ML | ML
Utley, Chase | 20.5 | 20.5 | 20.5 | 20.5
[NAME], [NAME] | 19.3
[NAME], [NAME] | 10.6 | 10.6 | 10.6 | 10.6
Rolen, Scott | 8.8 | 8.8
Snyder, [NAME] | 3.2 | A3
Delcarmen, Manny | 2.9 | A2 | A3
[NAME], [NAME] | 1.6 | 1.6 | 1.6 | 1.6
Kobayashi, Masahide | 1.5 | 1.5 | 1.5
Gagne, [NAME] | 1
Gutierrez, Franklin | 0.7 | A1 | A2 | A3
Tulowitzki, Troy | 0.7 | A1 | A2 | A3
Masset, [NAME] | 0.6 | 0.6
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
[NAME], [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Cueto, [NAME] | 0.3 | 0.7 | A1 | A2 | A3
Towles, J.R. | 0.3 | 0.7 | A1 | A2 | A3
Pavano, [NAME] | 0.1 | 0.1 | 0.1
[NAME], [NAME] | 0.1 | 0.1
Spreadsheet: 722187d1615105564-formulas-for-pinochle-score-sheet-pinochle-score-sheet
Sheet: Sheet1

 | MATTHEW | MAYO | JOEL | Dealer
 | 0 | 0 | 0
Bid | 500 |  |  | JOEL
[NAME] | 100 | 140 | 160 |  |  |  | 970
Tricks | 330 |  | 100 |  |  |  | 970
Total | -500 | 140 | 260
Bid | 710 |  |  | MATTHEW |  | -500
[NAME] | 340 | 380 | 600
Tricks | 300 | 100 | 100 |  |  | IF((B4+B5>=B3),(B4+B5),(B2-B3))
Total | -500 | 140 | 260
Bid |  | 610 |  | MAYO
[NAME] | 100 | 540 | 80
Tricks | 0 | 240 | 180
Total | -500 | 140 | 260
Bid | 590 |  |  | JOEL
[NAME] | 360 | 240 | 260
Tricks | 300 | 0 | 110
Total | -500 | 140 | 260
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | -500 | 140 | 260
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | JOEL
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | MATTHEW
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | MAYO
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 3
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 1
[NAME]
Tricks
Total | 0 | 0 | 0
Bid |  |  |  | 2
[NAME]
Tricks
Total | 0 | 0 | 0
 |  |  |  | 3
Spreadsheet: 210962d1359624149-forumlas-with-date-dependency-averageif-user-specific
Sheet: Sheet1

Data | Value | Helper
2013-01-17 00:00:00 | 938
2013-01-18 00:00:00 | 780
2013-01-21 00:00:00 | 560
2013-01-22 00:00:00 | 816
2013-01-23 00:00:00 | 659
2013-01-24 00:00:00 | 864
2013-01-25 00:00:00 | 764
2013-01-28 00:00:00 | 744
2013-01-29 00:00:00 | 626 |  | Your Expectation |  | My Formula
2013-01-30 00:00:00 | 715
2013-01-31 00:00:00
2013-02-01 00:00:00
2013-02-02 00:00:00
2013-02-03 00:00:00
2013-02-04 00:00:00
2013-02-05 00:00:00
2013-02-06 00:00:00
Spreadsheet: 777076d1650123502-pull-data-from-multiple-sheets-floor-stock-sheets-template
Sheet: Breast Rad 2004127

2004127 Breast Rad 2004127 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total | Service Units
Item | Price | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
Lemon Lime- Soda | 0.25
Diet Lemon Lime- Soda | 0.25
Cola- Soda | 0.25
Diet Cola- Soda | 0.25
Bottled Water | 0.14
Juice Orange | 0.23
Juice Apple | 0.23
Crackers, [NAME] | 0.08
[NAME] ea | 0.05
[NAME] | 0.16
Coffee | 95.11
Monthly Total
Spreadsheet: darrell_schoolcraft__7281__saledoc03_9aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-03-08 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/09/2002-03/11/2002 |  |  | FAX Number:
Total Quantity |  |  | 78000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  | 48000 | 2.64
 |  | 30000 | 2.63
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/09/2002 | 2002-03-11 00:00:00 | 78000 |  | 26000 |  | 26000
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas |  |  | 58649 |  | 26000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 05a736a3-7b5a-4238-a833-54cfdb7dca6c
Sheet: Exhibit XVII, Sheet 5, pg 4

Owners Forms
[NAME]
Pennsylvania
Claims, Losses, & Expense Summary
 |  | Paid Loss & LAE
 |  | (incl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2002-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2003-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2004-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2005-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2006-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2007-06-30 00:00:00 |  | 18153 | 31036 | 31036 | 31036
2008-06-30 00:00:00 |  | 146791 | 156442 | 156442 | 156442
2009-06-30 00:00:00 |  | 428840 | 467106 | 482201 | 483568
2010-06-30 00:00:00 |  | 788787 | 977729 | 978337
2011-06-30 00:00:00 |  | 1087207 | 1250507
2012-06-30 00:00:00 |  | 1071532
 |  | Paid Loss & LAE
 |  | (excl [NAME])
Accident Year | as of | 15 Months | 27 Months | 39 Months | 51 Months
2001-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2002-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2003-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2004-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2005-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2006-06-30 00:00:00 |  | 0 | 0 | 0 | 0
2007-06-30 00:00:00 |  | 5940 | 18823 | 18823 | 18823
2008-06-30 00:00:00 |  | 145373 | 155025 | 155025 | 155025
2009-06-30 00:00:00 |  | 399162 | 437428 | 452523 | 453890
2010-06-30 00:00:00 |  | 513733 | 538175 | 538175
2011-06-30 00:00:00 |  | 1037873 | 1156772
2012-06-30 00:00:00 |  | 735662
Spreadsheet: 713031d1610534404-make-list-from-match-in-table-menu-items-and-inventory
Sheet: Menu Items

American Breakfast | American Breakfast Toastie | Ham & Cheese Toastie | Ham Cheese Panini | Pancakes | Yogurt & berries | Chicken & Bacon | Ham Cheese Mayo | [NAME] | Vegan Hummus & Beedroot | Copenhagen Hotdog | Chili Cheese Dog | Roast Beef & Avocado | [NAME] | Vegan [NAME] | Submarine Supreme | Chili Cheese Steak | American Moby | Lucky 13 Burger | The Black Pearl | Vegan Mexican Burger | Premium Cheese Fries | [NAME] | [NAME] | [NAME] | Falafel Balls | French Fries | Fries n Crispy | Onion Rings | [NAME] | Caesar Wrap | [NAME] | [NAME] | Falafel Wrap | [NAME] | Beef mexi wrap | Caesar Salad | Falafel Salad | Smoked Salmon Salad | Tomato Salad | [NAME] | [NAME] | [NAME] | Pancake Dessert
Spreadsheet: 845472d1696969492-problem-with-league-table-golfscoresmultiplayerlive
Sheet: MthlySummary

Sum of Rank18
Team | Team1 | Team2 | Team3 | Team4 | Team5 | Team6 | Team7 | Total
2023-11-13 00:00:00 | 3 | 2 | 7 | 6 | 4 | 1 | 5 | 28
2023-12-04 00:00:00 | 1 | 2 | 6 | 7 | 4 | 3 | 4 | 27
2024-01-08 00:00:00 | 1 | 2 | 6 | 7 | 5 | 3 | 4 | 28
2024-02-05 00:00:00 | 2 | 6 | 7 | 5 | 4 | 1 | 3 | 28
2024-03-04 00:00:00 | 7 | 6 | 5 | 3 | 4 | 2 | 1 | 28
2024-04-08 00:00:00 | 3 | 7 | 3 | 5 | 6 | 1 | 2 | 27
2024-05-06 00:00:00 | 4 | 7 | 5 | 3 | 6 | 1 | 2 | 28
2024-06-03 00:00:00 | 5 | 7 | 3 | 2 | 6 | 4 | 1 | 28
Spreadsheet: chris_germany__2032__AppalPay200201
Sheet: CNRVol

802041 | 00003 | BADGER OIL AND GAS CO INC |  | 1923 | 2250 | 25
821780 | 00058 | [NAME] INC. |  | 2354 | 2648 | 25
805080 | 00081 | HARRIS | J E | 844 | 904 | 25
804452 | 00083 | PAYNE GAS COMPANY |  | 144 | 167 | 25
801852 | 00089 | LITTLETON, EXECUTRIX | [NAME] | 633 | 777 | 25
800785 | 00115 | PUTNAM NATURAL GAS CO.  INC. |  | 179 | 203 | 25
801153 | 00130 | THOMPSON | [NAME] | 490 | 586 | 25
804513 | 00164 | PINE MOUNTAIN OIL AND GAS INC |  | 2569 | 3092 | 25
827984 | 00506 | ARIES PETROLEUM CORPORATION |  | 0 | 0 | 25
826176 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 59 | 65 | 25
833349 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 0 | 0 | 0
800289 | 00552 | JCR PETROLEUM INC. |  | 37 | 52 | 25
833596 | 00552 | JCR PETROLEUM INC. |  | 341 | 414 | 25
833848 | 00552 | JCR PETROLEUM INC. |  | 236 | 383 | 25
800134 | 00612 | [NAME] | WILLIAM T | 35 | 54 | 12.5
800176 | 00612 | [NAME] | WILLIAM T | 318 | 471 | 12.5
834862 | 00618 | STATUS OIL WELLS |  | 42 | 53 | 25
635377 | 00621 | ELTON ENERGY |  | 220 | 240 | 25 | EES
Spreadsheet: 725292d1616605932-sum-data-by-month-p-l-statement-example
Sheet: P&L Statement

Company Name
Profit & Loss Statement as at 31/03/2020
 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | YTD
INCOME
Sales
Other business income
Total turnover
EXPENDITURE
Cost of goods bought for resale or goods used
Total cost of sales
[NAME]
Deductable Expenses
Car, van and travel expense
Wages, salaries and other staﬀ costs
Rent, rates, power and insurance costs
Repairs and renewals of property and equipment
Accountancy, legal and other professional fees
Interest and bank and credit card etc. ﬁnancial charges
Phone, fax, staaonery and other oﬃce costs
Total allowable expenses
Net proﬁt/(loss)
Spreadsheet: 437893d1451561319-countifs-with-multiple-criteria-countifs
Sheet: SAMPLE DATA

DATA |  |  |  | REQUIRED COLUMN
NAME | [NAME] | ENTER DATE | SERIAL NUMBER | COUNTIFS
LONDON | 251 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 252 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 272 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 273 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 274 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 084 | 2015-12-05 00:00:00 | 19 | 1
LONDON | 766 | 2015-12-05 00:00:00 | 33 | 2
LONDON | 764 | 2015-12-05 00:00:00 | 33 | 2
JAPAN | 761 | 2015-12-05 00:00:00 | 32 | 3
JAPAN | 754 | 2015-12-05 00:00:00 | 32 | 3
US | 762 | 2015-12-05 00:00:00 | 23 | 4
US | 777 | 2015-12-05 00:00:00 | 23 | 4
US | 759 | 2015-12-05 00:00:00 | 23 | 4
AUSTRALIA | 085 | 2015-12-07 00:00:00 | 44 | 1
AUSTRALIA | 089 | 2015-12-07 00:00:00 | 44 | 1
AUSTRALIA | 088 | 2015-12-07 00:00:00 | 43 | 2
AUSTRALIA | 090 | 2015-12-07 00:00:00 | 43 | 2
AUSTRALIA | 086 | 2015-12-07 00:00:00 | 49 | 3
AUSTRALIA | 087 | 2015-12-07 00:00:00 | 49 | 3
NETHERLANDS | 754 | 2015-12-07 00:00:00 | 47 | 4
NETHERLANDS | 747 | 2015-12-07 00:00:00 | 47 | 4
SWITZERLAND | 205 | 2015-12-07 00:00:00 | 50 | 5
SWITZERLAND | 208 | 2015-12-07 00:00:00 | 50 | 5
SWITZERLAND | 210 | 2015-12-07 00:00:00 | 50 | 5
SWITZERLAND | 212 | 2015-12-07 00:00:00 | 50 | 5
SWITZERLAND | 214 | 2015-12-07 00:00:00 | 50 | 5
Spreadsheet: 778003d1650771554-work-shifts-with-monthly-update-works-1-
Sheet: mese

Anno | 2022 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | M2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P1 |  |  |  |  |  |  | Sat
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | P2 |  |  |  |  |  |  | Sat
A |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | N1 |  |  |  |  |  |  | Sat
 |  | 2 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 |  |  |  |  |  | N2 |  |  |  |  |  |  | Sat
 |  | 3 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 |  |  | R1
 |  | 4 | P1 | P2 |  | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 | P1 | P2 |  |  |  | R2
 |  | 5 | N1 | N2 | R1 | R2 | M1 | M2 |  | P1 | P2 | N1 | N2 | R1 | R2 |  | M1 | M2 | P1 | P2 | N1 | N2 |  | R1 | R2 | M1 | M2 | P1 | P2 |  | N1 | N2
Spreadsheet: 176110d1345733914-simplified-way-of-displaying-data-for-training-and-information-house-clearance-log
Sheet: KPI's

Stats | Inbound Calls | Viewings Booked | Clearances Booked | Clearances Completed
Week 1 | 10 | 7 | 6 | 5
Week 2 | 11 | 5 | 5 | 5
Week 3 | 12 | 4 | 4 | 4
Week 4 | 13 | 5 | 5 | 5
Month Total
Breakdown | Calls to Viewings | Viewings to Booked Clearances | Booked to Completed Clearances | Call to Completed Clearance Percentage
Week 1
Week 2
Week 3
Week 4
Month Total
Spreadsheet: 130564d1322460249-excel-2007-consolidating-data-ranges-example
Sheet: Sheet1

Example
MASTER TABLE |  |  |  | 20110000 | 2
 |  |  |  | 20110001 | 3
20110000 |  | 2 |  | 20110002 | 5
20110001 |  | 3 |  | 20110003 | 4
20110002 |  | 5 |  | 20110004 | 6
20110003 |  | 4 |  | 20110005
20110004 |  | 6 |  | 20110006 | 8
20110006 |  | 8 |  | 20110007 | 9
20110007 |  | 9 |  | 20110008 | 10
20110008 |  | 10 |  | 20110009 | 11
20110009 |  | 11 |  | 20110010 | 12
20110010 |  | 12 |  | 20110011 | 13
20110011 |  | 13 |  | 20110012
20110014 |  | 15 |  | 20110013
20110015 |  | 16 |  | 20110014 | 15
20120000 |  | 1 |  | 20110015 | 16
20120001 |  | 2
20120002 |  | 3
20120003 |  | 5
20120004 |  | 6
20120005 |  | 8
 |  |  |  | 20120000 | 1
 |  |  |  | 20120001 | 2
 |  |  |  | 20120002 | 3
 |  |  |  | 20120003 | 5
 |  |  |  | 20120004 | 6
 |  |  |  | 20120005 | 8
 |  |  |  | 20120006
 |  |  |  | 20120007
 |  |  |  | 20120008
Spreadsheet: 468049d1467117450-combining-data-from-one-table-into-a-new-table-example-ic52-form-i-may-2016-new-prc
Sheet: TT NOV 2015

IC52 TIMETABLE TAM  09/11/2015
RTE AS PER Form I | SHIFT | SHFT_TIME | ROUTE | DIRECTION | CD_F | CD_V | CD_T | SKM | PRE_SERV | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY | SUNDAY | GROUP | CONTR_NR | DOTNR | OPERATED DAY
410020 | 669 | 3.45 | 0020 | F | VLC | 024 | MT | 130 | False | 130 | 130 | 130 | 130 | 130 |  |  | 01 | IC52 | 002006693.45 | MTWTF
410023 | 464 | 11 | 0023 | R | MT | 015 | RAM | 138 | False | 138 | 138 | 138 | 138 | 138 |  |  | 01 | IC52 | [PHONE] | MTWTF
410023 | 713 | 12 | 0023 | R | MT | 015 | RAM | 138 | False | 138 | 138 | 138 | 138 | 138 |  |  | 01 | IC52 | [PHONE] | MTWTF
410023 | 726 | 13 | 0023 | R | MT | 015 | RAM | 138 | False | 138 | 138 | 138 | 138 | 138 |  |  | 01 | IC52 | [PHONE] | MTWTF
410023 | 750 | 15 | 0023 | F | RAM | 015 | MT | 138 | False | 138 | 138 | 138 | 138 | 138 |  |  | 01 | IC52 | [PHONE] | MTWTF
410025 | 707 | 3.3 | 0025 | F | WNS | 311 | MT | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | 002507073.3 | MTWTF
410025 | 715 | 3.45 | 0025 | F | WNS | 311 | MT | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | 002507153.45 | MTWTF
410025 | 743 | 5.05 | 0025 | F | WNS | 311 | MT | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | 002507435.05 | MTWTF
410025 | 741 | 6 | 0025 | F | WNS | 311 | MT | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | 002507416 | MTWTF
410025 | 749 | 15 | 0025 | F | WNS | 311 | MT | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | [PHONE] | MTWTF
410025 | 749 | 19 | 0025 | R | MT | 311 | WNS | 134 | False | 134 | 134 | 134 | 134 | 134 |  |  | 01 | IC52 | [PHONE] | MTWTF
410025 | 752 | 3.45 | 0025 | F | WNS | 311 | MT | 134 | False |  |  |  |  |  | 134 |  | 01 | IC52 | 002507523.45 | S
410025 | 762 | 4.3 | 0025 | F | WNS | 311 | MT | 134 | False |  |  |  |  |  | 134 |  | 01 | IC52 | 002507624.3 | S
410026 | 741 | 3 | 0026 | F | WOL |  | BT | 59 | False | 59 |  |  |  |  |  |  | 01 | IC52 | 002607413 | M
410027 | 701 | 5.45 | 0027 | R | MT | 011 | RAM | 139 | False | 139 | 139 | 139 | 139 | 139 |  |  | 01 | IC52 | 002707015.45 | MTWTF
410027 | 767 | 13.3 | 0027 | F | RAM | 011 | MT | 139 | False |  |  |  |  |  | 139 |  | 01 | IC52 | [PHONE].3 | S
410031 | 732 | 11 | 0031 | F | WEL | 311 | MT | 136 | False | 136 |  |  |  |  |  |  | 01 | IC52 | [PHONE] | M
410032 | 610 | 15 | 0032 | F | MT | 003 | VLB | 128 | False |  |  |  |  | 128 |  |  | 01 | IC52 | [PHONE] | F
410033 | 748 | 11 | 0033 | F | RAM | 311 | MT | 146 | False | 146 | 146 | 146 | 146 | 146 |  |  | 01 | IC52 | [PHONE] | MTWTF
410034 | 464 | 14.45 | 0034 | F | PSA | 323 | MT | 141.3 | False | 141.3 | 141.3 | 141.3 | 141.3 | 141.3 |  |  | 01 | IC52 | [PHONE].45 | MTWTF
410037 | 745 | 3 | 0037 | F | WAT |  | BT | 72 | False | 72 |  |  |  |  |  |  | 01 | IC52 | 003707453 | M