tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 04367d7f-e970-4ceb-b5f9-d9d2a24ef0ed
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
 | Name____________________________________ |  |  |  | ID#____________________________
Area of Concentration Requirements | BA ART
 |  |  |  |  |  | Hrs | Grd | Sem
1. You must have a minimum GPA of 2.2 | Studio Emphasis - Ceramics, Graphic Design, Painting, |  |  |  | Upper Division Drawing Courses
in your area of concentration and a minimum of | Photography, Printmaking, or Sculpture |  |  |  | (3 Hours - 3000-4000 Level)
2.0 TU GPA in order to graduate. |  |  |  |  | Art 3003 Life Drawing  or | _____ | _____ | _____
 | Core (12 hours) | Hrs | Grd | Sem | [NAME] | _____ | _____ | _____
2. No Pass/D/F or CLEP credit may be applied | Art 1103 Drawing I | _____ | _____ | _____
toward your Area of Concentration | Art 1183 Design I | _____ | _____ | _____ | Upper Division Art Elective Courses
 | Art 1193 Design  II | _____ | _____ | _____ | (6  Hours - 3000-4000 Level)
3.  Courses applied to meet Core and General | Art 2023 Drawing II | _____ | _____ | _____ | ___________________________ | _____ | _____ | _____
Curriculum requirements cannot also apply in |  |  |  |  | ___________________________ | _____ | _____ | _____
your Area of Concentration.
 | [NAME] (9 Hours) |  |  |  | REQUIRED MINOR - Art History (12 Hours)
4.   Two thirds of the course work in your Major | (Choose THREE of the following, including |  |  |  | ArtH 2203 Survey of [NAME] I | _____ | _____ | _____
[NAME] must be at the 3000 or 4000 level. | ONE from Area of Emphasis): |  |  |  | ArtH 2223 Survey of Art Hist II | _____ | _____ | _____
 | Art 2113 Painting I | _____ | _____ | _____
 | Art 2123 Printmaking I | _____ | _____ | _____ | (Additional hours - 3000-4000 Level)
 | Art 2133 Ceramics I | _____ | _____ | _____ | ArtH ____  __________________ | _____ | _____ | _____
 | Art 2103 Sculpture I | _____ | _____ | _____ | ArtH ____  __________________ | _____ | _____ | _____
 | Art 2153 Photography | _____ | _____ | _____
 | Art 3243 Graphic Comm I ** | _____ | _____ | _____
 | **Pre-reqs for Art 3243 include:
 | Art 1103, Art 2023 and
 | Art 3343 Photoshop
 | EMPHASIS ______________________     (9 Hours)
 | Upper Division Electives in Emphasis
 | (9hours - 3000-4000 Level)
 | _____________________________ | _____ | _____ | _____
 | _____________________________ | _____ | _____ | _____
 | _____________________________ | _____ | _____ | _____
Updated 9/6/13 sb
Spreadsheet: 28096d1221999545-moving-data-from-one-sheet-to-another-using-a-combobox-move-data
Sheet: Data

User Name | Date | Days Worked | Attendance
User1 | 2008-09-17 00:00:00 | fds | 0.8095238095238095
User1 | 2008-09-16 00:00:00 | 14 | 0.65
User1 | 2008-09-15 00:00:00 | 33 | 0.7555555555555555
User1 | 2008-09-14 00:00:00 | 1 | 1
User1 | 2008-09-13 00:00:00 | 8 | 0.9
User1 | 2008-09-12 00:00:00 | 20 | 0.896551724137931
User1 | 2008-09-11 00:00:00 | 18 | 0.5769230769230769
User1 | 2008-09-10 00:00:00 | 8 | 0.6666666666666666
User1 | 2008-09-09 00:00:00 | 24 | 0.7333333333333333
User1 | 2008-09-08 00:00:00 | 18 | 0.7619047619047619
User1 | 2008-09-06 00:00:00 | 6 | 1
User1 | 2008-09-05 00:00:00 | 19 | 0.7692307692307693
User1 | 2008-09-04 00:00:00 | 23 | 0.65625
User1 | 2008-09-03 00:00:00 | 23 | 0.7096774193548387
User1 | 2008-09-02 00:00:00 | 20 | 0.7931034482758621
User2 | 2008-09-16 00:00:00 | fg | 0.6
User2 | 2008-09-14 00:00:00 | 21 | 0.7777777777777778
User2 | 2008-09-13 00:00:00 | 15 | 0.7894736842105263
User2 | 2008-09-12 00:00:00 | 34 | 0.575
User2 | 2008-09-11 00:00:00 | 26 | 0.6388888888888888
User2 | 2008-09-08 00:00:00 | 27 | 0.5882352941176471
User2 | 2008-09-07 00:00:00 | 14 | 0.8636363636363636
User2 | 2008-09-06 00:00:00 | 15 | 0.7368421052631579
User2 | 2008-09-05 00:00:00 | 36 | 0.7291666666666666
User2 | 2008-09-04 00:00:00 | 36 | 0.7346938775510204
User2 | 2008-09-02 00:00:00 | 22 | 0.8518518518518519
User3 | 2008-09-14 00:00:00 | adf | 0
User3 | 2008-09-13 00:00:00 | 0 | 0
User3 | 2008-09-12 00:00:00 | 0 | 0
User3 | 2008-09-11 00:00:00 | 0 | 0
User3 | 2008-09-09 00:00:00 | 0 | 0
User3 | 2008-09-08 00:00:00 | 0 | 0
User3 | 2008-09-06 00:00:00 | 0 | 0
User3 | 2008-09-05 00:00:00 | 0 | 0
User3 | 2008-09-04 00:00:00 | 0 | 0
User3 | 2008-09-01 00:00:00 | 0 | 0
Spreadsheet: sally_beck__33749__Moratorium
Sheet: Pending Technology

Pending Technology
New Product Type |  | PJM Demand offered by the Weather Desk
 | 2000-08-10 00:00:00 | The Product Type was originally set to Internal Use Only. Trading now wants to offer the
 |  | Product externally. This cannot be done until we have the ability to adjust/remove the
 |  | Weather-related attributes. We should, however, be able to use the existing Product Type.
New Product Type |  | US East Power Unplanned B
 | 2000-08-08 00:00:00 | Product Type is built in Data Manager and has all approvals. Firmness needs to be
 |  | changed to Unplanned B, then we test.
 | 2000-08-10 00:00:00 | Firmness has been changed, but we cannot test new power [NAME] until the
 |  | test website is available.
Products |  | AUS and JPN Weather Products
 | 2000-08-11 00:00:00 | The Maximum Trade Quantity on the Quote Details/Trading Hours tab cannot be adjusted in
 |  | the Product Manager once there are transactions against the Product.
New Product Types |  | Argentina Power and Gas
 | 2000-08-11 00:00:00 | Need an Argentina Standard time zone created.
Products |  | All US-offered Products
 | 2000-08-11 00:00:00 | Have technology set all Products that have 'blank' and 'No Region' in the REGION field
 |  | to 'None'.
Products |  | All US-offered Products
 | 2000-08-15 00:00:00 | Test Next Month and Next Month + 1 Tokenized Reference Periods.
 |  | 4615 and 4654 in TEST.
New Product Types |  | Physical Paper OCC #11
 | 2000-08-16 00:00:00 | Need a Commodity/Deal Type-specific Product attribute for INCOterms.
Spreadsheet: 777654d1650540580-sorting-of-numbers-including-hyphens-excelforum21
Sheet: products_export_1 - 2022-04-21T

Given | Preferrable sorting
92582-03-15 | 92582-03-15
92582-03-16 | 92582-04-15
92582-04-15 | 92582-05-15
92582-04-16 | 92582-03-16
92582-05-15 | 92582-04-16
92582-07-16 | 92582-07-16
92582-07-17 | 92582-07-17
92583-03-15 | 92583-03-15
92583-03-16 | 92583-04-15
92583-04-15 | 92583-05-15
92583-04-16 | 92583-03-16
92583-05-15 | 92583-04-16
92583-07-16 | 92583-07-16
92583-07-17 | 92583-07-17
Spreadsheet: 167730d1342085768-custom-data-validation-compare-value-in-different-cells-and-sum-of-value-of-cells-genericorderform-pfl-20120712beta
Sheet: Order Form

 |  |  |  |  | Order Form (Care Label) |  |  |  |  |  |  | Customer |  | Walmart
[NAME] |  |  |  |  |  | Ship-to Name |  |  |  |  |  | Order Date
Vendor ID |  |  |  |  |  | Country-of-Origin |  |  |  |  |  | Vendor's Ref
Contact Name |  |  |  |  |  | Contact Name |  |  |  |  |  | Production Priority |  | REGULAR |  |  | [NAME]:
Phone |  |  |  |  |  | Phone |  |  |  |  |  | Required ETD |  |  |  |  |  | Entry Field
[NAME] |  |  |  |  |  | [NAME] |  |  |  |  |  | Pack ID |  |  |  |  |  | Drop-down
Address 1 |  |  |  |  |  | Address 1 |  |  |  |  |  |  |  |  |  |  |  | Display Field
Address 2 |  |  |  |  |  | Address 2
Address 3 |  |  |  |  |  | Address 3
City |  |  |  |  |  | City
State |  |  |  |  |  | State
Zip |  |  |  |  |  | Zip
Country |  |  |  |  |  | Country |  | ANTARCTICA |  |  |  | Total Qty |  | 0
Product Code |  | Ticket Type           (HT Code) |  | RN | CA | Country-of-origin |  |  |  | Imported Fabric |  |  | Unit Price | Currency | Misc1
 |  |  |  |  |  | ASSEMBLED IN BELGIUM |  |  |  | OF IMPORTED FABRIC
Component1 |  |  | Component2 |  |  | Component3 |  |  |  |  | Style Number |  | Size | Season Code | Qty
SHELL |  |  | LINING |  |  | BOTTOM
Fabric Content1 |  | Total99% | Fabric Content2 |  | Total100% | Fabric Content3 |  | Total100%
Fabric1 |  | % | Fabric1 |  | % | Fabric1 |  | %
Polyester |  | 50 | Alpaca |  | 95 | Cotton |  | 100
Fabric2 |  | % | Fabric2 |  | % | Fabric2
Acrylic |  | 40 | Acrylic |  | 2
Fabric3 |  | % | Fabric3 |  | % | Fabric3
[NAME] |  | 5 | Applique |  | 1
Fabric4 |  | % | Fabric4 |  | % | Fabric4
Batiste |  | 3 | Sanforize |  | 1
Fabric5 |  | % | Fabric5 |  | % | Fabric5
Angora |  | 1 | Sequins |  | 1
Care Instructions
Wash Instruction1 |  | WASH WITH SOAP OR DETERGENT
Wash Instruction2 |  | MACHINE WASH COLD WITH LIKE COLORS
Wash Instruction3
Dry Instruction1 |  | TUMBLE DRY LOW
Dry Instruction2
Dry Instruction2
Bleach Instruction |  | ONLY NON - CHLORINE BLEACH WHEN NEEDED
Iron Instruction
Dry Clean Instruction |  | Dry Clean
Other Instruction1 |  | DO NOT IRON IMPRINT
Other Instruction2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Qty | 0
Sample output of Fabric contents: |  |  | SHELL: 50% Polyester 40% Acrylic  5% Denim  3% Batiste 1% Angora
 |  |  | LINING: 95% Alpaca  2% Acrylic  1% Applique 1% Sanforize 1% Sequins
 |  |  | BOTTOM: 100% Cotton
Spreadsheet: 142949d1330101079-sumproduct-help-dummy-workbook
Sheet: Reference Data

Current Year | 2012 |  |  | [NAME]
Prior Year | 2011 |  |  | 2011-01-01 00:00:00 | 1
Current Period | 2012-01-01 00:00:00 |  |  | 2011-02-01 00:00:00 | 2
Prior Period | 2011-01-01 00:00:00 |  |  | 2011-03-01 00:00:00 | 3
 |  |  |  | 2011-04-01 00:00:00 | 4
 |  |  |  | 2011-05-01 00:00:00 | 5
 |  |  |  | 2011-06-01 00:00:00 | 6
 |  |  |  | 2011-07-01 00:00:00 | 7
 |  |  |  | 2011-08-01 00:00:00 | 8
 |  |  |  | 2011-09-01 00:00:00 | 9
 |  |  |  | 2011-10-01 00:00:00 | 10
 |  |  |  | 2011-11-01 00:00:00 | 11
 |  |  |  | 2011-12-01 00:00:00 | 12
Spreadsheet: 390312d1429597236-please-help-me-formula-for-sum-for-text-and-number-in-same-cells-example-az-1
Sheet: Sheet1

 | [NAME] | [NAME] | BABU
Apple | 1 PLATE + 2 BOWLS | BOWLS 2 | 1 BOWLS + 1 PLATE
Salads | 2 BOWLS | 1 PLATE + 2 BOWLS | 2 PLATE + 2 BOWLS
[NAME] | 2 PLATE | 1 PLATE | 1 PLATE
Pineapple | 2 BOWLS + 1 PLATE | 1 PLATE + 1 BOWLS | 2 BOWLS
TOTAL
 | [NAME]
Spreadsheet: 694362d1599567977-copy-names-from-one-sheet-to-other-workbook-sheets-sample-scoring-spreadsheet1
Sheet: OVERALL SCORES

 | ORGANISATION NAME | PROJECT NAME | PROCEED TO SHORTLISTING STAGE? YES/NO | OVERALL SCORE | More Information Required | Type | Notes
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
Spreadsheet: 82765d1282781623-extract-data-to-different-workbook-example-workbook
Sheet: 5

 |  |  | 2008-01-05 00:00:00
Location | Trips | Liters | Gallons
[NAME] | 1 | 378.5 | 100
Centurion | 2 | 757 | 200
Dragon | 3 | 1135.5 | 300
Bldg 0039 | 4 | 1514 | 400
Fac 1 | 5 | 1892.5 | 500
Man | 6 | 2271 | 600
Dog Pen | 7 | 2649.5 | 700
Canal | 8 | 3028 | 800
Hot | 9 | 3406.5 | 900
Fac2 | 10 | 3785 | 1000
 | 55 | 20817.5 | 5500
 | 275 | 104087.5 | 27500
Spreadsheet: 79580d1279808871-linking-if-statements-from-multiple-rows-dummybook
Sheet: Sheet1

 | Life Cycle expectancy (yrs) | 4
 | Start Year | 2010
 | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15
 | 2008 | 2009 | 2010 | 2011 | 2012 | 2013 | 2014 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023
 | 0 | 0 | First Year of Acquisition | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | First Year of Acquisition | 0 | 0 | 0 | First Year of Acquisition | 0 | 0 | 0 | First Year of Acquisition | 0 | 0 | 0
 | ***I'm trying to link rows 9 & 10 up, so that when both cells C4, or [NAME] are changed, they respond accordingly.  So far row 10 only reads off of 2008…
Spreadsheet: 858929d1707411945-trying-to-filter-out-a-table-list-when-two-lists-match-test-excel
Sheet: Sheet1

Custom SIM List | Pulled Sales History SIM List | SIM Description | Sell Contract | SPA Cost | SPA Name | 2610 WTT Cost | [NAME] | Loaded Margin | [NAME] Months | QTY Sold - Revenue | [NAME] Cost | [NAME]
[PHONE] | 78621054105 | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | 78621054506 | a | f | f | s | s | s | s | g | h | v | v
[PHONE] | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | [PHONE] | a | f | f | s | s | s | s | g | h | v | v
 | 78621054112 | a | f | f | s | s | s | s | g | h | v | v
 | 78621005266 | a | f | f | s | s | s | s | g | h | v | v
 | 78621005262 | a | f | f | s | s | s | s | g | h | v | v
Spreadsheet: 828813d1683739334-nested-xlookup-formula-returns-value-error-copyplantmeasurements2023-v3-mo
Sheet: GrowthChart2

Company1-Cust1-'Pink'-6.5-1PP-PW34 |  |  |  |  | <-Select crop from the drop-down menu
Plant Week
Pinch Week |  |  | Min Ht
Sell Week |  |  | [NAME]
Pot Size (in) |  |  | Curve | Standard | <-Select standard or late curve from the drop-down menu
Weeks After Pinch | Calendar Week | Avg Ht | Min Ht | [NAME] | Calendar Week Helper Column |  | Calendar Week | Grouping
 |  |  |  |  |  |  | 36 | 36
1 |  |  |  |  |  |  | 37 | 37
2 |  |  |  |  |  |  | 38 | 38
3 |  |  |  |  |  |  | 39 | 39
4 |  |  |  |  |  |  | 40 | 40
5 |  |  |  |  |  |  | 41 | 41
6 |  |  |  |  |  |  | 42 | 42
7 |  |  |  |  |  |  | 43 | 43
8 |  |  |  |  |  |  | 44 | 44
9 |  |  |  |  |  |  | 45 | 45
10 |  |  |  |  |  |  | 46 | 46
11 |  |  |  |  |  |  | 47 | 47
 |  |  |  |  |  |  | 48 | 48
 |  |  |  |  |  |  | 49 | 49
 |  |  |  |  |  |  | 50 | 50
 |  |  |  |  |  |  | 51 | 51
 |  |  |  |  |  |  | 52 | 52
Spreadsheet: 737558d1624467554-formula-to-use-one-calc-or-the-other-if-cell-is-blank-faculty-add-pay-worksheet
Sheet: Type 2

Use: | Use this spreadsheet for payments during Academic Year only. (Example 2 of TL-SA2015-22) |  |  |  |  |  |  |  |  |  |  |  |  |  | CONCERNS
Instructions: | Fill out the data in the gray boxes. Change "Total Work Days in Month" as applicable per the note in yellow.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1. If the award is too small of an amount, based on the period in which the work is performed, a fraction that is smaller than XX/XX is required and PIMS doesn't allow it. Additionally minimum monthly base must be $4229. How can this be paid? (Example: $100 for 01/18/22 - 05/21/22 - Would need a fraction of 2/339)
Name | [NAME] |  | Total Award |  | 9900 |  | Time Base |  |  | Total Days Worked
Empl ID | 150 |  | Start Date |  | 2022-01-18 00:00:00 |  | End Date | 2022-05-21 00:00:00
Note: If the actual dates worked span over multiple pay periods and ALL periods are 22 days, do not change row 11 (Total Work Days); if even one period is 21 days, then change ALL months to 21 days.
 |  | 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 | 2022-06-01 00:00:00
Days Worked |  | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 20 | 21 | 16 | 16 | 0
Monthly Payment
Total Work Days in Month |  | 22 | 22 | 22 | 22 | 22 | 22 | 21 | 21 | 21 | 21 | 21 | 22
Daily Rate
Monthly Rate
Base Salary for PS
Total Paid |  |  |  |  | Time Base Calculator
Settlement Due
 |  | This number cannot exceed 25 --> |  |  |  | x |  | <-- Select the monthly rate during the period of work. Otherwise, leave blank.
 |  |  |  |  | 100 |  | 10500 | <-- Adjust until the orange cell is below 25%
 |  |  |  |  | *** | *OR* | ***
 |  |  |  |  | [NAME] in Excess of 40 per week
 |  |  |  |  |  | 1 |  | <-- Please erase cell if not using.
Spreadsheet: 98c1d090-af35-41c6-879e-4b66f1ce88ee
Sheet: divisions

Voter | AFC East | AFC North | AFC South | AFC West | NFC East | NFC North | NFC South | NFC West | Average (should equal 16.5)
[NAME] | 18.75 | 15.75 | 22 | 20.25 | 13.75 | 12.25 | 19 | 10.25 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 19 | 15.25 | 22 | 20.25 | 14.75 | 12.75 | 17.5 | 10.5 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 20.25 | 15.75 | 22.25 | 20.25 | 11.25 | 12.25 | 17.5 | 12.5 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 20 | 16 | 19.75 | 21 | 12.25 | 13.25 | 19 | 10.75 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] | 18.5 | 16 | 21.75 | 18.25 | 11.25 | 14.25 | 20 | 12 | 16.5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Average | 19.3 | 15.75 | 21.55 | 20 | 12.65 | 12.95 | 18.6 | 11.2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Rank | 6 | 4 | 8 | 7 | 2 | 3 | 5 | 1
Spreadsheet: 177403d1346302486-index-match-with-row-information-offset-from-the-match-cell-sample-1
Sheet: How it should Look

 |  | Revenue
 |  | July Production |  | August Production
Clinical Affairs |  | 50 |  | 1
Community Health July 2012(07/01/2012 - 07/31/2012) |  | 200 |  | 200
Dental Hygiene July 2012(07/01/2012 - 07/31/2012) |  | 0 |  | 0
Diagnostic Science July 2012(07/01/2012 - 07/31/2012) |  | 125 |  | 125
Endodontics July 2012(07/01/2012 - 07/31/2012) |  | 920 |  | 920
Special Care July 2012(07/01/2012 - 07/31/2012) |  | -150 |  | -150
Implant July 2012(07/01/2012 - 07/31/2012) |  | 1300 |  | 1300
Oral Surgery July 2012(07/01/2012 - 07/31/2012) |  | 650 |  | 650
Pedo July 2012(07/01/2012 - 07/31/2012) |  | 1000 |  | 1000
Periodontics July 2012(07/01/2012 - 07/31/2012) |  | 800 |  | 800
Spreadsheet: 168621d1342528269-drop-down-list-if-or-sumproduct-is-it-possible-fruit
Sheet: Sheet1

 |  |  |  |  | fruit | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct
 |  |  |  |  | number | 2.75 | 4.5 | 5.5 | 3.5 | 3.5 | 3.75 | 3.75 | 5.75 | 6.75 | 6.5
 |  |  |  |  | cost | 6000
 |  |  |  |  |  | cost | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | oct
 |  |  |  | apple | fruit | 1000 | 0.25 | 2 | 3 | 1 | 1 | 0.25 | 0.25 | 0.25 | 0.25 | 2
 |  |  |  | bannana | fruit | 2000 | 1 | 1 | 1 | 1 | 1 | 2 | 2 | 4 | 5 | 3
 |  |  |  | watermelon | fruit | 1500 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  |  |  | pineapple | fruit | 3000 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  | fish | animal | 5000 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
 |  |  |  | beef | animal | 7000 | 2 | 3 | 4 | 1 | 2 | 1 | 3 | 2 | 1 | 3
 |  |  |  | chicken | animal | 3000 | 2 | 2 | 2 | 2 | 1 | 2 | 2 | 2 | 1 | 2
 |  |  |  |  |  | cost of fruit | 6000 | 7750 | 8750 | 6750 | 6750 | 8000 | 8000 | 12000 | 14000 | 11750
 |  |  |  |  |  | cost of animal | 22500 | 29500 | 36500 | 15500 | 19500 | 15500 | 29500 | 22500 | 12500 | 29500
Spreadsheet: 716372d1612189363-running-total-formula-book1
Sheet: Sheet1

rang_id | rang_val | start date | end date |  |  | Every Day | Amount
1001 | 500 | 2020-01-01 00:00:00 | 2020-02-08 00:00:00 |  |  | 2020-01-01 00:00:00
1002 | 700 | 2020-01-01 00:00:00 | 2020-07-07 00:00:00 |  |  | 2020-01-02 00:00:00
1003 | 600 | 2020-01-02 00:00:00 | 2020-05-13 00:00:00 |  |  | 2020-01-03 00:00:00
1004 | 150 | 2020-01-02 00:00:00 | 2020-10-09 00:00:00 |  |  | 2020-01-04 00:00:00
1005 | 350 | 2020-01-03 00:00:00 | 2020-10-03 00:00:00 |  |  | 2020-01-05 00:00:00
1006 | 750 | 2020-01-04 00:00:00 | 2020-11-08 00:00:00 |  |  | 2020-01-06 00:00:00
1007 | 1300 | 2020-01-04 00:00:00 | 2020-08-04 00:00:00 |  |  | 2020-01-07 00:00:00
1008 | 70 | 2020-01-05 00:00:00 | 2020-07-08 00:00:00 |  |  | 2020-01-08 00:00:00
1009 | 270 | 2020-01-06 00:00:00 | 2020-08-03 00:00:00 |  |  | 2020-01-09 00:00:00
1010 | 400 | 2020-01-07 00:00:00 | 2020-10-08 00:00:00 |  |  | 2020-01-10 00:00:00
1011 | 350 | 2020-01-07 00:00:00 | 2020-04-21 00:00:00 |  |  | 2020-01-11 00:00:00
1012 | 555 | 2020-01-07 00:00:00 | 2020-10-03 00:00:00 |  |  | 2020-01-12 00:00:00
1013 | 650 | 2020-01-08 00:00:00 | 2020-03-05 00:00:00 |  |  | 2020-01-13 00:00:00
1014 | 250 | 2020-01-08 00:00:00 | 2020-07-07 00:00:00 |  |  | 2020-01-14 00:00:00
1015 | 150 | 2020-01-08 00:00:00 | 2020-02-01 00:00:00 |  |  | 2020-01-15 00:00:00
1016 | 50 | 2020-01-08 00:00:00 | 2020-10-03 00:00:00 |  |  | 2020-01-16 00:00:00
1017 | 50 | 2020-01-09 00:00:00 | 2020-02-08 00:00:00 |  |  | 2020-01-17 00:00:00
1018 | 87 | 2020-01-09 00:00:00 | 2020-07-19 00:00:00 |  |  | 2020-01-18 00:00:00
1019 | 75 | 2020-01-10 00:00:00 | 2020-04-06 00:00:00 |  |  | 2020-01-19 00:00:00
1020 | 95 | 2020-01-10 00:00:00 | 2020-11-08 00:00:00 |  |  | 2020-01-20 00:00:00
 |  |  |  |  |  | 2020-01-21 00:00:00
 |  |  |  |  |  | 2020-01-22 00:00:00
 |  |  |  |  |  | 2020-01-23 00:00:00
 |  |  |  |  |  | 2020-01-24 00:00:00
 |  |  |  |  |  | 2020-01-25 00:00:00
 |  |  |  |  |  | 2020-01-26 00:00:00
 |  |  |  |  |  | 2020-01-27 00:00:00
 |  |  |  |  |  | 2020-01-28 00:00:00
 |  |  |  |  |  | 2020-01-29 00:00:00
 |  |  |  |  |  | 2020-01-30 00:00:00
 |  |  |  |  |  | 2020-01-31 00:00:00
 |  |  |  |  |  | 2020-02-01 00:00:00
 |  |  |  |  |  | 2020-02-02 00:00:00
 |  |  |  |  |  | 2020-02-03 00:00:00
 |  |  |  |  |  | 2020-02-04 00:00:00
 |  |  |  |  |  | 2020-02-05 00:00:00
 |  |  |  |  |  | 2020-02-06 00:00:00
 |  |  |  |  |  | 2020-02-07 00:00:00
 |  |  |  |  |  | 2020-02-08 00:00:00
 |  |  |  |  |  | 2020-02-09 00:00:00
 |  |  |  |  |  | 2020-02-10 00:00:00
 |  |  |  |  |  | 2020-02-11 00:00:00