tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 583705d1532604404-generating-a-list-of-4-numbers-that-equal-100-in-increments-of-5-combination-list
Sheet: Sheet1

Ingredients
A | B | C | D | Total
0.05 | 0.05 | 0.05 | 0.85
0.05 | 0.05 | 0.1 | 0.8
0.05 | 0.05 | 0.15 | 0.75
0.05 | 0.05 | 0.2 | 0.7
0.05 | 0.05 | 0.25 | 0.65
0.05 | 0.05 | 0.3 | 0.6
0.05 | 0.05 | 0.35 | 0.55
0.05 | 0.05 | 0.4 | 0.5
0.05 | 0.05 | 0.45 | 0.450000000000001
0.05 | 0.05 | 0.5 | 0.400000000000001
0.05 | 0.05 | 0.55 | 0.350000000000001
0.05 | 0.05 | 0.6 | 0.300000000000001
0.05 | 0.05 | 0.65 | 0.250000000000001
0.05 | 0.05 | 0.7 | 0.200000000000001
0.05 | 0.05 | 0.75 | 0.150000000000001
0.05 | 0.05 | 0.8 | 0.100000000000001
0.05 | 0.05 | 0.85 | 0.0500000000000009
Spreadsheet: 733083d1621379079-getting-the-total-orders-of-each-hour-from-many-days-order-by-hours-of-the-day
Sheet: Example

 |  |  | Time of day | Total orders
 |  |  | 12am
 |  |  | 1am
 |  |  | 2am
 |  |  | 3am
 |  |  | 4am
 |  |  | 5am
 |  |  | 6am
 |  |  | 7am
 |  |  | 8am
 |  |  | 9am
 |  |  | 10am
 |  |  | 11am
 |  |  | 12pm
 |  |  | 1pm
 |  |  | 2pm
 |  |  | 3pm
 |  |  | 4pm
 |  |  | 5pm
 |  |  | 6pm
 |  |  | 7pm
 |  |  | 8pm
 |  |  | 9pm
 |  |  | 10pm
 |  |  | 11pm
Spreadsheet: 229860d1366619634-counting-duplicates-between-multiple-columns-in-a-pivot-table-example-of-duplications
Sheet: Sheet1

 |  |  | Name | Team
 |  |  | [NAME] | 1
 |  |  | [NAME] | 1
 |  |  | [NAME] | 1
 |  |  | [NAME] | 1
 |  |  | [NAME] | 1
 |  |  | [NAME] | 1
 |  |  | [NAME] | 4
 |  |  | [NAME] | 3
 |  |  | [NAME] | 4
Spreadsheet: 705581d1606205665-employee-monthly-salary-increased-on-their-anniversary-date-accounting
Sheet: Consulting

 | Budget Template
 | Department:
 | Consulting Budget
 | Instructions - Please update this tab for all consultants, independent contractors, public relations firms, professional services firms and any other support resources your department will utilize for the year.
 |  | What the consultant will be used for? | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  | Total Year | Priority "High / Medium / Low"
 | Clean SOX, Inc. | Consulting Fees | $200/Hour
 | Gibraltar CFO Services | Consulting Fees | $195/Hour
 | Nasif, Hicks, Harris & Co., LLP | Accounting Services | Variable Rate based on Professional Performing Services
 | Consultant 4
 | Consultant 5
 | Consultant 6
 | Consultant 7
 | Consultant 8
 | Consultant 9
 | Consultant 10
 | Total Consultants Cost
 | BDO | Tax Accounting Services | Variable Rate
 | Tax Consultant 2
 | Tax Consultant 3
 | Tax Consultant 4
 | Tax Consultant 5
 | Total Tax Consultants Cost
Spreadsheet: 785795d1656690900-generate-names-based-on-multiple-criteria-and-sort-based-on-smallest-largest-value-sample-revised
Sheet: PERSONNEL (2)

Station Code | EMPLOYEEE NO. | School | Name
5 | 2617019 | LOVE | [NAME]
12 | 4256020 | MERCY | [NAME]
12 | 4257987 | FAITH | [NAME]
 | 4258860 | MERCY | [NAME]
5 | 4731383 | LOVE | [NAME]
5 | 4732068 | LOVE | [NAME]
12 | 4770982 | MERCY | [NAME]
95 | 4774472 | LOVE | Destiny Holder
95 | 4774702 | FAITH | [NAME]
95 | 4989372 | LOVE | Willow Dougherty
12 | 5286833 | FAITH | Emmy Walker
12 | 5293457 | FAITH | Bea Loon
5 | 5294436 | FAITH | [NAME]
12 | 5296754 | MERCY | [NAME]
12 | 5296792 | MERCY | [NAME]
5 | 6412708 | MERCY | Brooklyn Hobbs
 | 6412841 | FAITH | Cano Shane
12 | 9220020 | LOVE | [NAME]
12 | NEW | FAITH | [NAME]
12 | NEW | LOVE | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 1638d671-5d6e-4cad-a72a-932257a68138
Sheet: Country

Country | Titles | Percentage
France | 73
Germany | 36
Italy | 21
Russia | 21
China | 18
Japan | 17
Sweden | 17
Spain | 16
Brazil | 13
Norway | 13
Switzerland | 12
South Korea | 11
Argentina | 10
Egypt | 8
Mexico | 8
Quebec | 8
Denmark | 7
Iceland | 7
Poland | 7
Chile | 6
Lebanon | 6
Iran, Islamic Republic of | 5
Israel | 5
Slovenia | 5
Austria | 4
Cuba | 4
Czech Republic | 4
Georgia | 4
Greece | 4
Iraq | 4
Netherlands | 4
Turkey | 4
Libya | 3
Morocco | 3
Palestinian Territory, Occupied | 3
Romania | 3
Ukraine | 3
Various | 3
Afghanistan | 2
Albania | 2
Finland | 2
Guatemala | 2
Hungary | 2
India | 2
Portugal | 2
Serbia and Montenegro | 2
South Africa | 2
Syrian Arab Republic | 2
Algeria | 1
Angola | 1
Bahrain | 1
Belgium | 1
Bulgaria | 1
Cape Verde | 1
Croatia | 1
Equatorial Guinea | 1
Estonia | 1
Faroe Islands | 1
Haiti | 1
Jordan | 1
[NAME] | 1
Martinique | 1
Moldova, Republic of | 1
Pakistan | 1
Peru | 1
Rwanda | 1
Saudi Arabia | 1
Taiwan | 1
Venezuela | 1
Viet Nam (Vietnam) | 1
Spreadsheet: 154219d1336321410-return-count-value-based-on-several-conditions-copy-of-book1_arturas
Sheet: Sheet1

 |  |  |  |  |  | Sent | Received | Sent | Received | Sent | Recieved | Sent | Reeceived | Sent
Date of order | Sent to country | Direction | Country list | Total Sent 2012 | Total Received 2012 | 2012-01-01 00:00:00 |  | 2012-02-01 00:00:00 |  | 2012-03-01 00:00:00 |  | 2012-04-01 00:00:00 |  | 2012-05-01 00:00:00
2012-01-01 00:00:00 | Spain | Sent | Spain | 4 |  | 2 |  | 1 |  | 0 |  | 1 |  | 0
2012-01-01 00:00:00 | Spain | Received | Netherlands | 3 |  | 1 |  | 0 |  | 1 |  | 0 |  | 1
2012-01-02 00:00:00 | Netherlands | Received | Portugal | 1 |  | 0 |  | 1 |  | 0 |  | 0 |  | 0
2012-02-01 00:00:00 | Portugal | Received | Belgium | 4 |  | 0 |  | 1 |  | 1 |  | 0 |  | 2
2012-02-01 00:00:00 | Belgium | Received | England | 4 |  | 0 |  | 1 |  | 1 |  | 0 |  | 2
2012-02-01 00:00:00 | Spain | Received | Poland | 3 |  | 0 |  | 0 |  | 2 |  | 0 |  | 1
2012-03-01 00:00:00 | England | Sent | Ireland | 1 |  | 0 |  | 0 |  | 0 |  | 1 |  | 0
2012-03-01 00:00:00 | Netherlands | Sent | Germany | 2 |  | 0 |  | 0 |  | 0 |  | 2 |  | 0
2012-03-05 00:00:00 | Poland | Sent | Italy | 2 |  | 0 |  | 0 |  | 0 |  | 2 |  | 0
2012-03-05 00:00:00 | Belgium | Sent
2012-03-06 00:00:00 | Poland | Sent
2012-04-05 00:00:00 | Ireland | Sent
2012-04-05 00:00:00 | Germany | Sent
2012-04-05 00:00:00 | Germany | Received
2012-04-10 00:00:00 | Italy | Sent
2012-04-12 00:00:00 | Spain | Received
2012-04-30 00:00:00 | Italy | Received
2012-05-01 00:00:00 | Netherlands | Sent
2012-05-10 00:00:00 | England | Sent
2012-02-15 00:00:00 | England | Received
2012-05-12 00:00:00 | England | Sent
2012-05-13 00:00:00 | Belgium | Received
2012-05-11 00:00:00 | Belgium | Received
2012-05-12 00:00:00 | Poland | Sent
Spreadsheet: 824420d1680572896-comparing-two-lists-with-multiple-columns-s666-pq-ists-difference
Sheet: Sheet10

Player | Year | Goals | Assists
[NAME] | 2016 | 29 | 39
Thorton | 2016 | 7 | 43
Burns | 2016 | 29 | 47
Couture | 2016 | 25 | 27
Meir | 2016 | 3 | 3
Herti | 2016 | 10 | 12
[NAME] | 2017 | 22 | 44
Thorton | 2017 | 13 | 23
Burns | 2017 | 12 | 55
Couture | 2017 | 34 | 27
Meir | 2017 | 21 | 15
Herti | 2017 | 22 | 24
[NAME] | 2018 | 23 | 10
Thorton | 2018 | 6 | 12
Burns | 2018 | 6 | 34
Couture | 2018 | 15 | 24
Meir | 2018 | 18 | 17
Herti | 2018 | 14 | 19
Player | 2016 | 2017 | 2018
[NAME]
Thorton
Burns
Couture
Meir
Herti
Spreadsheet: 668370d1584780285-extracting-names-from-not-uniformed-formatting-sample-workbook-problem
Sheet: Sheet1

Possible Names Submitted: | Extracted Last Name | Extracted First Name | Extracted Middle Extension | Extracted Middle Name |  |  | NOTES:
Samples: |  |  |  |  |  |  | Middle Extensions can be as follows:
DELA CRUZ,JUAN MIGUEL, ANTONIO | DELA CRUZ | JUAN MIGUEL |  | ANTONIO |  |  |  | JR
DELOS SANTOS JR.,MIKE RUIZ, PEREZ | DELOS SANTOS | MIKE RUIZ | JR | PEREZ |  |  |  | I
DELOS REYES SR,ALBERTO | DELOS REYES | ALBERTO | SR |  |  |  |  | II
DE GUZMAN,ROBERT, JR DELA CRUZ | DE GUZMAN | [NAME] | DELA CRUZ | JR |  |  |  | III
 |  |  |  |  |  |  |  | SR
Table:
[NAME] | Last Name | First Name | Middle Extension | Middle Name
DELA CRUZ,JUAN MIGUEL, ANTONIO
DELOS SANTOS JR.,MIKE RUIZ, PEREZ
DELOS REYES SR,ALBERTO
DE GUZMAN,ROBERT, JR DELA CRUZ
Spreadsheet: 9060b7ec-ce3d-4b4f-a1f1-5aeebb7d37fe
Sheet: In-State Travel

IN-STATE TRAVEL
List expenses incurred for program monitoring and all other program-related activities.
Include mileage for facility reviews and other local travel required to manage the program.
Maximum allowable rate is current state rate.
 |  |  | Annual Costs
Employee Name |  | Purpose of Travel | Mileage | Mileage | Lodging | Meals | Total Annual
 |  |  | Total | Rate |  |  | Cost to CACFP
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  |  | Total IN-STATE Travel
Spreadsheet: 804224d1667947493-ledger-balance-amount-column-is-blank-from-date-paid-column-that-is-missing-a-date-camp-ledger-sample
Sheet: 2022

EXPENSE  [NAME] | DUE DATE | EXPENSE AMT | FAMILY MEMBER | DATE PAID | AMOUNT PAID | PAID | DEBIT | CREDIT | Column1 | BALANCE
 |  |  |  |  |  |  |  |  | Starting Balance from 2022
Annual Contribution | 2022-10-01 00:00:00 | 215 | [NAME] | 2022-09-26 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | [NAME] | 2022-10-01 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | Julie | 2022-09-15 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | [NAME] | 2022-09-27 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | Navaughn | 2022-10-01 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | Pam | 2022-10-03 00:00:00
Annual Contribution | 2022-10-01 00:00:00 | 215 | [NAME] | 2022-09-19 00:00:00
Clay Electric | 2022-01-08 00:00:00 | 26 |  | 2022-01-08 00:00:00
Clay Electric | 2022-02-04 00:00:00 | 30 |  | 2022-02-04 00:00:00
Clay Electric | 2022-03-03 00:00:00 | 30 |  | 2022-03-03 00:00:00
Clay Electric | 2022-04-01 00:00:00 | -16 |  | 2022-04-01 00:00:00
Clay Electric | 2022-05-03 00:00:00 | 15 |  | 2022-05-03 00:00:00
Clay Electric | 2022-06-02 00:00:00 | 31 |  | 2022-06-02 00:00:00
Clay Electric | 2022-07-05 00:00:00 | 32 |  | 2022-07-05 00:00:00
[NAME] | 2022-08-01 00:00:00 | 500 |  | 2022-08-01 00:00:00
Clay Electric | 2022-08-09 00:00:00 | 32 |  | 2022-08-09 00:00:00
Clay Electric | 2022-09-06 00:00:00 | 32 |  | 2022-09-06 00:00:00
Clay Electric | 2022-10-03 00:00:00 | 33 |  | 2022-10-03 00:00:00
 |  |  |  |  |  |  |  |  | Ending Balance
Spreadsheet: 848726d1699378603-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists
Sheet: Blue Train

Ref No | Vehicle | Colour
Spreadsheet: 468615d1467387813-help-with-v-look-up-copy-of-packing-slip-template-updated-
Sheet: Packing Slip

Customer: |  | Date:
Billing Address:
Shipping Address:
 | Item | Quantity | Retail Price | Wholesale Rate | Price
 | Shipping:
 | Total:
Spreadsheet: chris_stokley__3864__TAKEOUT_2001_06
Sheet: TIETAKEOUT

ID SUFFIX | SCHEDULE TIE                (TIE_POINT) | ZONE | LOAD GROUP | CONGESTION / CONTROL ZONE (FROM) | CONGESTION / CONTROL ZONE (TO) | [NAME] |  | EFFECTIVE DATE
9000 | CAPJAK_5_OLINDA | [NAME] | NWNF | NW1 | NP15 | CAPTJACK
9001 | CASCAD_1_CRAGVW | [NAME] | NWNC | NW2 | NP15 | CASCADE
9002 | MALIN_5_RNDMTN | [NAME] | NWNF | NW1 | NP15 | MALIN
9003 | SUMITM_1_SPP | SRR2 | SR29 | SR2 | NP15 | SUMMIT
9004 | BLYTHE_1_WALC | WLC2 | LCL2 | LC2 | SP15 | BLYTHE
9005 | DEVERS_2_COCHLA | IID1 | II1 | II1 | SP15 | COACHELLA
9006 | ELDORD_5_PSUEDO | ARZ2 | AZ2 | AZ2 | SP15 | ELDORADO
9007 | FCORNR_5_PSUEDO | ARZ2 | AZ2 | AZ2 | SP15 | FOUR CORNERS
9008 | GOODRH_2_PASA | [NAME] | PSA1 | PAS | SP15 | GOODRICH (PASADENA) | EXPIRED
9009 | MEAD_2_WALC | WLC4 | [NAME] | LC1 | SP15 | MEAD
9010 | [NAME] | IID1 | II1 | II1 | SP15 | MIRAGE | REVISE
9011 | MOHAVE_6_69KV | NEV3 | NVN3 | NV3 | SP15 | LAUGHLIN 69
9012 | MOHAVE_5_500KV | NEV3 | NVN3 | NV3 | SP15 | LAUGHLIN 500
9013 | PARKR_2_GENE | WLC6 | LCL6 | LC3 | SP15 | PARKER
9014 | PVERDE_5_DEVERS | ARZ3 | AZ3 | AZ3 | SP15 | PALOVERDE
9015 | [NAME] | SRR3 | SR30 | SR3 | SP15 | SILVER PEAK
9016 | IVALLY_2_23050 | [NAME] | MXMX | MX | SP15 | IMPERIAL VALLEY (CFE)
9017 | IVALLY_2_230S | IID2 | II2 | II2 | SP15 | IMPERIAL VALLEY (IID)
9018 | NGILA_5_NG4 | ARZ5 | AZ5 | AZ5 | SP15 | N.GILA (BK 4)
9019 | PVERDE_5_NG-PLV | ARZ3 | AZ3 | AZ3 | SP15 | N.GILA (PV)
9020 | TJUANA_2_23040 | [NAME] | MXTJ | MX | SP15 | TIJUANNA
9021 | LUGO_5_VICTVL | LDW4 | LA14 | LA4 | SP15 | [NAME]
9022 | INYOS_2_LDWP | LDW3 | LA13 | LA3 | SP15 | INYO
9023 | ELDORD_5_MCLLGH | LDW2 | LA12 | LA2 | SP15 | MCCULLOUGH
9024 | SYLMAR_2_LDWP | LDW1 | LA11 | LA1 | SP15 | SYLMAR
9025 | SYLMAR_2_NOB | NWS3 | NWNE | NW3 | SP15 | NOB | REVISE
9026 | MOENKO_5_PSUEDO | ARZ2 | AZ2 | AZ2 | SP15 | MOENKOPI | ADD
9055 | MRCHNT_2_ELDORD | NEV4 | [NAME] | NV4 | SP15 | MERCHANT PLANT | ADD | 1999-10-15 00:00:00
Spreadsheet: 275439d1383514497-age-bracket-using-lookup-formula-ex123
Sheet: Task 5

Member Age | Lower Age  Limit | Basic Annual  Fees | Car Park Space
Under 25 | 0 | 25 | 10
25 to 40 | 25 | 125 | 50
41 to 65 | 41 | 200 | 75
Over 65 | 66 | 50 | 20
Name | Age | Use of Car Park ? | Age Bracket | Basic Fees | Parking Fees | Total Fees
[NAME] | 23 | N
[NAME] | 45 | Y
[NAME] | 73 | N
[NAME] | 34 | N
[NAME] | 29 | Y
[NAME] | 52 | N
Spreadsheet: 785302d1656335567-formula-required-to-identify-presence-of-activity-by-type-by-individual-per-month-test-files
Sheet: Sheet1

Caller ID | Contact 1 | Contact 1 Result | Contact 2 | Contact 2 Result | Contact 3 | Contact 3 Result | Contact 4 | Contact 4 Result | Contact 5 | Contact 5 Result
1 | 2022-06-27 00:00:00 | Hang up | 2022-06-28 00:00:00 | Hang up | 2022-07-04 00:00:00 | Purchased
2 | 2022-05-28 00:00:00 | Purchased | 2022-06-29 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-07-05 00:00:00 | Call back
3 | 2022-06-29 00:00:00 | Purchased | 2022-06-30 00:00:00 | Purchased | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Purchased | 2022-08-03 00:00:00 | Hang up
4 | 2022-06-30 00:00:00 | Call back | 2022-07-01 00:00:00 | Purchased | 2022-07-04 00:00:00 | Purchased | 2022-08-05 00:00:00 | Call back
5 | 2022-07-01 00:00:00 | Hang up | 2022-07-02 00:00:00 | Call back | 2022-07-03 00:00:00 | Purchased
July
Hang up |  |  | 2
Purchased |  |  | 5
Call Back |  |  | 2
This is the data I do not want
Number of hang up in July |  |  | 2
Number of Purchased in July |  |  | 7
Number of Call back in July |  |  | 2
Spreadsheet: 466489d1466207757-look-up-data-from-two-sheets-and-give-a-result-on-a-third-sheet-service-plan-quotes-vs-car-sales
Sheet: Results

Registration # | Plan Quoted? | [NAME]? | [NAME]
Spreadsheet: 741253d1626938488-vlookup-i-want-to-pull-over-pack-sizes-and-costs-to-my-recipe-builder-blank-recipe-builder-test
Sheet: Recipe

 | Menu Item
Base Recipe |  |  |  | 100 | PORTIONS
Ordered Volume |  |  |  | 500 | PORTIONS
 | ITEM | UNIT SIZE | BASE QUANTITY | QUANTITY REQUIRED | UNIT COST | TOTAL COST
 | Column1 | Column3 | Column4 | Column5 | Column6 | Column7
 | PRISONER MoJ CORNED BEEF CRISPBAKE |  | 2
 | ONE WATER 500ML STILL PET |  | 3
 | MoJ SPICED DATE & HONEY CAKE |  | 4
 | SFS SAUSAGE BEANS & CHIPS MEAL |  | 4
 | PRISONER ,Freshways [NAME] Milk |  | 2
 | PRISONER ,3663 Reduced Sugar & Salt Baked Beans In Tomato Sauce |  | 1
 | 80% Minted Lamb Burgers Halal (Tier 2) |  | 0
 | PRISONER ,Freshways [NAME] Milk |  | 0
 | NON PRISONER ,Coca Cola 330Ml Can |  | 0
 | NON PRISONER ,Coca Cola 330Ml Can |  | 0
 | TOTAL COST FOR RECIPE
 | COST PER PORTION
1 | METHOD STATEMENT
2
3
4
5
6
7
 | ALLERGEN INFORMATION |  | NUTRITIONAL INFORMATION
 | GLUTEN |  | Portion [NAME] in [NAME]
 | EGGS |  | CALORIES
 | MILK |  | CARBOHYDRATE
 | CELERY |  | PROTEIN
 | NUTS |  | TOTAL FAT
 | PEANUTS |  | SATURATED FAT
 | SOYA |  | FIBRE
 | FISH
 | CRUSTACEANS
 | SULPHUR DIOXIDE
 | MUSTARD
 | SESAME SEEDS
 | [NAME]
Spreadsheet: 734683d1622385195-formula-vlookup-does-not-find-values-cerca_vertelenco-etaf-ans
Sheet: ASDX

 |  |  | drop-down menu
 |  |  | A20
 |  |  | A4
 |  |  | A7
 |  |  | A4
 |  |  | A3
 |  |  | A20
 |  |  | A4
 |  |  | A17
 |  |  | a2
 |  |  | A16
 |  |  | A18
 |  |  | BB
 |  |  | A16
 |  |  | A5
Spreadsheet: 688059d1595546306-searching-for-the-most-recent-date-relevant-entry-in-a-table-of-data-example-data
Sheet: Sheet1

Staff Member | Employee Number | Date | Leave Balance |  | First Name | Surname | Employee Number | Leave Balance
[NAME] | 1234567 | 2019-01-15 00:00:00 | 3 |  | [NAME] | Smith | 1234567 | 1.25
[NAME] | 1234567 | 2019-01-10 00:00:00 | 7.25 |  | [NAME] | Gray | 8849566 | 7.3
[NAME] | 1234567 | 2019-01-08 00:00:00 | 0.5 |  | [NAME] | Summers | 9876543 | 15
[NAME] | 1234567 | 2019-01-04 00:00:00 | 0.25
[NAME] | 1234567 | 2019-01-02 00:00:00 | 1.25
[NAME] | 1234567 | 2020-06-23 00:00:00 | 1.25
[NAME] | 1234567 | 2020-06-10 00:00:00 | 2.5
[NAME] | 1234567 | 2020-04-06 00:00:00 | 0.5
[NAME] | 1234567 | 2020-03-24 00:00:00 | 0.25
[NAME] | 8849566 | 2020-03-19 00:00:00 | 7.25
[NAME] | 8849566 | 2019-03-05 00:00:00 | 7.25
[NAME] | 8849566 | 2019-02-28 00:00:00 | 7.25
[NAME] | 8849566 | 2019-02-12 00:00:00 | 0.5
[NAME] | 8849566 | 2019-02-08 00:00:00 | 7.25
[NAME] | 8849566 | 2019-02-06 00:00:00 | 7.25
[NAME] | 8849566 | 2019-02-05 00:00:00 | 0.5
[NAME] | 8849566 | 2019-01-23 00:00:00 | 2.3
[NAME] | 8849566 | 2020-04-15 00:00:00 | 1.3
[NAME] | 8849566 | 2020-03-30 00:00:00 | 4.8
[NAME] | 8849566 | 2020-06-18 00:00:00 | 7.3
[NAME] | 8849566 | 2020-06-17 00:00:00 | 9.9
[NAME] SUMMERS | 9876543 | 2020-06-15 00:00:00 | 15
[NAME] SUMMERS | 9876543 | 2020-06-12 00:00:00 | 3
[NAME] SUMMERS | 9876543 | 2020-06-08 00:00:00 | 0.25
[NAME] SUMMERS | 9876543 | 2020-06-05 00:00:00 | 7.25
[NAME] SUMMERS | 9876543 | 2020-06-01 00:00:00 | 0.5
[NAME] SUMMERS | 9876543 | 2020-05-29 00:00:00 | 7.25
Spreadsheet: 140797d1328891341-counting-days-between-two-set-dates-but-with-different-working-weeks-eekk-example
Sheet: Data

 | Contracted hours per week |  |  |  | 54:00 | 54 | Total Hours worked between given dates
 | Contracted daily hours | 06:00:00
 | What Month is YOUR birthday |  |  |  |  | 9
 | Start date (for this timesheet) | 2012-04-01 00:00:00 |  |  |  | 1
 |  |  |  |  |  | 0
 | Finish date (for this timesheet) | 2012-04-30 00:00:00 |  |  |  | 1
 |  |  |  |  |  |  | 29
 | What days of the week do you normally work
 | Monday | Yes |  |  |  | 2
 | Tuesday |  |  |  |  | 0
 | Wednesday | Yes |  |  |  | 4
 | Thursday |  |  |  |  | 0
 | Friday |  |  |  |  | 0
 | Saturday |  |  |  |  | 0
 | Sunday |  |  |  |  | 0
 | Yes
Spreadsheet: 673657d1587481421-calculate-last-work-day-minus-n-without-using-workday-function-wd-due
Sheet: Configs

Days | Time
WD1 | 4
WD2 | 4.5
WD3 | 5
WD4 | 5.5
WD5 | 6
WD6 | 6.5
WD7 | 7
WD8 | 7.5
[NAME] | 8
WD10 | 8.5
WD11 | 9
WD12 | 9.5
WD13 | 10
WD14 | 10.5
WD15 | 11
WD16 | 11.5
WD17 | 12
WD18 | 12.5
WD19 | 13
WD20 | 13.5
WD-4 | 14
WD-3 | 14.5
WD-2 | 15
WD-1 | 15.5
LWD | 16
WD+1 | 16.5
WD+2 | 17
WD+3 | 17.5
WD+4 | 18
WD+5 | 18.5
WD+6 | 19
WD+7 | 19.5
Spreadsheet: 695908d1600453869-vlookup-and-populate-data-into-a-cell-id-reference
Sheet: Reference

Example: Meter ID to Long ID Reference
[NAME] | Long ID | Alphabet | Number
MU-W52 | 13212252 | A | 1
MU-Y51 | 13212551 | B | 2
 |  | C | 3
 |  | D | 4
 |  | E | 5
 |  | F | 6
 |  | G | 7
 |  | H | 8
 |  | I | 9
 |  | J | 10
 |  | K | 11
 |  | L | 12
 |  | M | 13
 |  | N | 14
 |  | O | 15
 |  | P | 16
 |  | Q | 17
 |  | R | 18
 |  | S | 19
 |  | T | 20
 |  | U | 21
 |  | V | 22
 |  | W | 23
 |  | X | 24
 |  | Y | 25
 |  | Z | 26
Spreadsheet: 23571d1213129394-comparing-two-tables-sample-2
Sheet: Sheet1

[NAME] | level | qty | price
9101 | 1 | 6 | 9.49
9101 | 3 | 24 | 33.99
9103 | 1 | 6 | 9.49
9103 | 3 | 24 | 33.99
3700 | 1 | 6 | 7.49
3700 | 3 | 24 | 27.49
2628 | 1 | 6 | 7.49
2628 | 3 | 24 | 25.99
9121 | 1 | 6 | 8.49
9121 | 3 | 24 | 29.99
9122 | 1 | 6 | 8.49
9122 | 3 | 24 | 29.99
331 | 1 | 6 | 7.49
331 | 3 | 24 | 25.99
0070 | 1 | 6 | 5.99
0084 | 3 | 24 | 23.99
0084 | 1 | 6 | 4.99
0084 | 1 | 6 | 2.99
0089 | 3 | 24 | 10.99
0089 | 1 | 12 | 8.99
0089 | 3 | 24 | 16.99
0089 | 1 | 30 | 18.99
0089 | 1 | 6 | 4.99
0089 | 3 | 24 | 17.99
0089 | 1 | 12 | 8.99
0091 | 3 | 24 | 17.99
0091 | 1 | 30 | 18.99
0092 | 1 | 6 | 4.99
317 | 3 | 24 | 17.99
3661 | 1 | 4 | 5.49
9128 | 1 | 6 | 5.99
9128 | 3 | 24 | 21.49
9127 | 1 | 1 | 2.89
9127 | 3 | 12 | 30.99
2092 | 1 | 12 | 8.99
2092 | 3 | 24 | 16.99
9137 | 1 | 6 | 4.99
9137 | 3 | 24 | 17.99
9138 | 1 | 6 | 2.99
9138 | 3 | 24 | 9.99
9140 | 1 | 6 | 3.99
9141 | 1 | 12 | 5.99
9141 | 3 | 24 | 11.49
4569 | 1 | 30 | 13.99
199 | 1 | 6 | 3.99
Spreadsheet: chris_germany__1889__Transco_Doyle_confirms_May_2001
Sheet: external

DOYLE
MAY    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  |  |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  | STA 85 Gas Daily +0.05 |  | FT | IT @ .1861 | COST
DAY | REQUEST * |  |  |  |  |  |  |  | none for May |  | DEL'd x Comm.
2001-05-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-02 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
*   3-May | 4030 | 4250 | 4250 | 4027 |  |  | fixed price del'd $4.90 |  | 0.0306 | 0.1861 | 0
2001-05-04 00:00:00 | 0 | 0 |  | 5 |  |  |  |  | 0.0306 | 0.1861
2001-05-05 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-06 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-07 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-08 00:00:00 | 4500 | 4500 |  | 5683 |  |  | 4.395 |  | 0.0306 | 0.1861
2001-05-09 00:00:00 | 10000 | 10000 |  | 6586 |  |  | 4.29 |  | 0.0306 | 0.1861
2001-05-10 00:00:00 | 12500 | 10000 |  | 11781 |  |  | 4.2 |  | 0.0306 | 0.1861
2001-05-11 00:00:00 | 5250 | 5500 |  | 4859 |  |  | 4.245 |  | 0.0306 | 0.1861
2001-05-12 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-13 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-14 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-15 00:00:00 | 0 | 0 |  | 5 |  |  |  |  | 0.0306 | 0.1861
2001-05-16 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
**  17-May | 32000 | 32000 |  | 34031 |  |  | fixed price @ Sta 85=$4.40 |  | 0.0306 | 0.1861
2001-05-18 00:00:00 | 14500 | 15000 |  | 14675 |  |  | 4.29 |  | 0.0306 | 0.1861
2001-05-19 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-20 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-21 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-22 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-23 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-24 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-25 00:00:00 | 0 | 1893 |  | 0 |  |  | 4.22 |  | 0.0306 | 0.1861
2001-05-26 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-27 00:00:00 | 0 | 0 |  | 3 |  |  |  |  | 0.0306 | 0.1861
2001-05-28 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-29 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-30 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1861
2001-05-31 00:00:00 | 0 | 3 |  | 0 |  |  | Gas Daily+.05 |  | 0.0306 | 0.1861
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | * Interruptible transport restricted for May 1 - 5, gas purchased from ENA at a delivered price at gate.
 | ** called for 17th @ 3:00pm on 16th.
 | Total Transport Commodity charges for May = $14405.05
Spreadsheet: 28939d1223522201-formula-question-ifs-sample
Sheet: Sheet33

 |  | Game | Game | Game | Totals
 |  | 789 | 879 | 789 | 2457
 |  | W | W |  |  | Games Won-(2pts/game) |  | 4
 |  |  |  |  |  | Points for Totals (3pts)
 |  |  |  |  |  | Total Points |  | 4
 |  | Game | Game | Game | Totals
 |  | 788 | 799 | 877 | 2464
 |  |  |  | W | W | Games Won-(*2pts/game) |  | 2
 |  |  |  |  |  | Points for Totals (3pts) |  | 3
 |  |  |  |  |  | Total Points |  | 5
Spreadsheet: 150565d1334602720-sign-pricing-grid-for-estimating-signs-sign-estimating
Sheet: Signboard

233-A Jefferson Street • Newnan, GA 30263 |  |  |  | Phone: [PHONE]
 | Quantity
Size | 18 | 24 | 36 | 48 | 60 | 72 | 96
12 | 7 | 7 | 40 | 60 | 100 | 100 | 90
18 | 7 | 7 | 40 | 60 | 100 | 100 | 90
24 | 7 | 40 | 40 | 60 | 100 | 100 | 90
36 | 40 | 40 | 50 | 60 | 100 | 100 | 90
48 | 25 | 40 | 50 | 50 | 80 | 90 | 80