tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 77989d1278450478-asset-matrix-example1
Sheet: Project Calendar

Job A |  | Sun | Mon | Tue | Wed | Thu | Fri | Sat
Job B |  | 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: 134315d1325191645-if-command-to-apply-a-formula-each-time-a-name-appears-commissions-spreadsheet-test
Sheet: Sheet1

Team: | Construction
Period | 2011
KPI's
Unit Sales
Team Members | Weeks | Sales | Avg. Sales | Cash In | Commissions | Placement Bonus | Accelerated Commissions | Management Bonus | Pending Sales | Budget | Expenses | Average
Haigles |  | 1240
Kfly
Brosas
Total
Details |  |  |  |  |  |  |  | Commissions |  |  |  |  | Management
Name | Client | New Title | Team | Billable | Fee % | Fee | Start Date | Cash In | Recruiting | Matching | Marketing | Driving the Deal | Team Lead Override | Team Lead Bonus | Unit Bonus
 |  |  |  |  | 24800 |  |  |  | Haigles | Haigles | Haigles | Brosas
 |  |  |  |  | 22000 |  |  |  | Kfly | Haigles | Brosas | Haigles
Spreadsheet: 720826d1614299451-inserting-additional-criteria-to-an-if-statement-wrkswipes2erref
Sheet: Error 1

 | Overall Day | ARR | STRT | END | WRK | RT | WT |  | Overall Day | ARR | STRT | END | WRK | RT | WT
 |  | 08:36:00 | 08:46:00 | 10:27:00 |  |  |  |  |  | 05:28:00 | 05:38:00 | 10:25:00
 | Break | 14:00:00 | 14:10:00 | 20:53:00 |  |  |  |  | Break | 14:50:00 | 15:00:00 | 16:00:00
 |  |  |  | Total |  |  |  |  |  | 16:00:00 | 16:10:00 | 18:14:00
 |  |  |  |  |  |  |  |  |  |  |  | Total
 | 11th Hour |  |  |  | ST | OT
 | 11 1/2 Hour |  |  |  |  |  |  |  | 11th Hour |  |  |  | ST | OT
 | Guarantee | 8:00:00 |  |  |  |  |  |  | 11 1/2 Hour
 | 11 1/2-11 |  |  |  |  |  |  |  | Guarantee | 8:00:00
 |  |  |  |  |  |  |  |  | 11 1/2-11
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Management Fee Allocation |  | -16093.8
[NAME] (Deferred Payable) |  | -206
[NAME] (Other)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 791167d1660186228-percentage-by-procedure-code-group-and-year-percent_breakdown
Sheet: After

Group | Procedure | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022
1 | 88711 | 0.0603 | 0.0623 | 0.0458 | 0.0408 | 0.0447 | 0.0441 | 0.0442
1 | 88712 | 0.2549 | 0.2375 | 0.2249 | 0.2136 | 0.2106 | 0.1967 | 0.1641
1 | 88713 | 0.6848 | 0.7001 | 0.7293 | 0.7456 | 0.7447 | 0.7592 | 0.7917
2 | 46511 | 0.0725 | 0.0726 | 0.0687 | 0.0679 | 0.0624 | 0.0661 | 0.0699
2 | 46512 | 0.2679 | 0.2611 | 0.256 | 0.25 | 0.2381 | 0.2463 | 0.2393
2 | 46513 | 0.6596 | 0.6663 | 0.6753 | 0.6821 | 0.6995 | 0.6876 | 0.6908
3 | 72312 | 0.0759 | 0.0605 | 0.0736 | 0.0596 | 0.0749 | 0.0591 | 0.0816
3 | 72313 | 0.4338 | 0.4829 | 0.3927 | 0.3938 | 0.3797 | 0.3776 | 0.3734
3 | 72314 | 0.4902 | 0.4565 | 0.5337 | 0.5466 | 0.5455 | 0.5632 | 0.545
4 | 23523 | 0.0536 | 0.0539 | 0.052 | 0.0503 | 0.0473 | 0.0394 | 0.0378
4 | 23524 | 0.4954 | 0.4809 | 0.4724 | 0.458 | 0.4336 | 0.4232 | 0.4158
4 | 23525 | 0.451 | 0.4652 | 0.4756 | 0.4917 | 0.5191 | 0.5374 | 0.5464
5 | 65911 | 0.0846 | 0.1127 | 0.1156 | 0.0828 | 0.0946 | 0.0873 | 0.0698
5 | 65912 | 0.3623 | 0.3818 | 0.3943 | 0.3867 | 0.3162 | 0.3032 | 0.3159
5 | 65913 | 0.5532 | 0.5054 | 0.4901 | 0.5305 | 0.5892 | 0.6095 | 0.6143
6 | 99211 | 0.2566 | 0.2362 | 0.2153 | 0.2035 | 0.1882 | 0.1786 | 0.1589
6 | 99212 | 0.7434 | 0.7638 | 0.7847 | 0.7965 | 0.8118 | 0.8214 | 0.8411
Spreadsheet: 250019d1373724823-combo-box-selection-from-more-than-1-sheet-possible-cuddle-corner-stock
Sheet: Kaycee Bear Purchases

Product ID | Product Name | Product Code | Supplier | Unit Cost Purchase | Selling Price | Units Purchased
 | Rosemary |  | [NAME] | 26.88 | 47 | 1
 | Sugar Cane |  | [NAME] | 22.92 | 39 | 1
 | Roxy |  | [NAME] | 29.46 | 52 | 1
 | Jessica |  | [NAME] | 20.04 | 35 | 1
 | [NAME] | [NAME] | [NAME] | 21.72 |  | 1
 | Elvis | [NAME] | [NAME] | 80.04 | 140 | 1
 | [NAME] | Mis | [NAME] | 51.42 | 90 | 1
 | Duchess | duc | [NAME] | 80.04 | 140 | 1
Spreadsheet: 37114d1235062687-insert-new-row-chart-doesnt-count-672633
Sheet: Sum-Nov08

Range | C1 | C2 | [NAME] | HCM | S1 | S2 | S3 |  |  |  |  | Original values
0 - 4.99 |  |  | 1 | 10 | 34 |  |  |  |  | 0 - 4.99 |  |  | 1 | 10 | 34
5 - 5.99 |  |  | 2 | 0 | 40 |  |  |  |  | 5 - 5.99 |  |  | 2 | 0 | 40
6 - 6.99 |  |  | 7 | 0 | 37 |  |  |  |  | 6 - 6.99 |  |  | 7 | 0 | 37
7 - 7.99 |  |  | 8 | 1 | 48 |  |  |  |  | 7 - 7.99 |  |  | 8 | 1 | 48
8 - 8.99 |  |  | 4 | 0 | 44 |  |  |  |  | 8 - 8.99 |  |  | 4 | 0 | 44
9 - 10 |  |  | 2 | 0 | 41 |  |  |  |  | 9 - 10 |  |  | 2 | 0 | 41
Spreadsheet: 299387d1393161386-converting-pivottable-into-sql-statement-book1
Sheet: Sheet1

Brand | Model |  |  | Row Labels | Count of Model
Toyota | [NAME] |  |  | Toyota | 3
Toyota | Corolla |  |  | VW | 3
Toyota | Camry |  |  | Grand Total | 6
VW | Golf
VW | Polo
VW | Passat
Spreadsheet: 191424d1352116772-how-to-achieve-mediated-data-entry-forum_example
Sheet: Entry

Start Month | M6
Entry period
Entry
M1
M2
M3
M4
M5
M6
M7
M8
M9
M10
Spreadsheet: 215849d1361515165-searching-for-a-value-in-multiple-sheets-fame1
Sheet: SN4(040912-23)

3.067 | 3.04 | 3.103 | TIC | 24537 | 0.38 | 12202 | 0.52 | 2.01 |  | 4-Dimethyl(chloromethyl)silyloxytetradecane
3.16 | 3.147 | 3.17 | TIC | 1812 | 0.03 | 2407 | 0.1 | 0.75 |  | Tetrahydroionone
3.188 | 3.17 | 3.233 | TIC | 8582 | 0.13 | 4146 | 0.18 | 2.07 | V | 9,12-Octadecadienoic acid (Z,Z)-, methyl ester (CAS) Methyl linoleate
3.243 | 3.233 | 3.263 | TIC | 1039 | 0.02 | 2041 | 0.09 | 0.51 |  | 7,8-Epoxylanostan-11-ol, 3-acetoxy-
3.27 | 3.263 | 3.277 | TIC | 935 | 0.01 | 2024 | 0.09 | 0.46 | V | Dihydroartemisinin, 6-deshydro-5-deshydroxy-3-desoxy-
3.31 | 3.277 | 3.34 | TIC | 6320 | 0.1 | 3527 | 0.15 | 1.79 |  | 1H-Imidazol-1-yloxy, 4-(dibromomethyl)-2,5-dihydro-2,2,5,5-tetramethyl-, 3-oxide
3.55 | 3.53 | 3.583 | TIC | 4581 | 0.07 | 3361 | 0.14 | 1.36 |  | 9,10-Secochola-5,7,10(19)-triene-3,24-diol, (3.beta.,5Z,7E)- (CAS) 25,26,27-Trisnor-24-hydroxycholecalciferol
3.615 | 3.583 | 3.65 | TIC | 7309 | 0.11 | 3807 | 0.16 | 1.92 |  | 2,6-Octadien-4-ol, 8-(4"-carboxy-6"-t-butyldimethysilyloxy-2",3",3a",4",7",7a"-hexahydro-3a"-hydroxy-5"-methylbenzofuran-3"-yli
3.708 | 3.65 | 3.747 | TIC | 73278 | 1.13 | 33942 | 1.44 | 2.16 |  | METHYL TETRADECANOATE
3.763 | 3.75 | 3.81 | TIC | 4305 | 0.07 | 2189 | 0.09 | 1.97 |  | (E)-2-tridecyl-2-heptadecenal
3.817 | 3.81 | 3.853 | TIC | 3339 | 0.05 | 575 | 0.02 | 5.81 |  | N-METHYLCYCLOHEXYLCYANAMIDE
3.868 | 3.853 | 3.877 | TIC | 2962 | 0.05 | 3361 | 0.14 | 0.88 | V | 2(1H)-Naphthalenone, octahydro-1,1,4a-trimethyl-, trans- (CAS) TRANS-1,1,10-TRIMETHYLDECALONE-2
3.936 | 3.877 | 3.957 | TIC | 6413 | 0.1 | 2852 | 0.12 | 2.25 | V | ISOBORNYL 3-METHYLBUTANOATE
Spreadsheet: 776949d1650016144-row-conditonal-formating-depending-on-cell-value-test-dashboard-3-etaf
Sheet: CLIENTS

CID | DENOMINATION | PHONE | VAT | FIRST NAME | LAST NAME | ADDRESS | POST | CITY | COUNTRY | [NAME] | WEBSITE | ACTIVITY | LAST BILLED
10
9 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
8 | Drinkland |  |  |  |  |  |  |  |  |  |  | Active
7 | Air & Chaleur |  |  |  |  |  |  |  |  |  |  | Inactive
6 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
5 | A.A. [NAME] |  |  |  |  |  |  |  |  |  |  | Active
4 | [NAME] |  |  |  |  |  |  |  |  |  |  | Active
3 | J-R Bat |  |  |  |  |  |  |  |  |  |  | Active
2 | Gremibel |  |  |  |  |  |  |  |  |  |  | Active
1 | DRL Express |  |  |  |  |  |  |  |  |  |  | Active
Spreadsheet: 86001d1285965675-select-data-based-on-user-input-boxes
Sheet: Sheet2

USER INPUT
 | [NAME] | Min
Length | 3 | 2
[NAME] | 3 | 2
Height | 3 | 2
Box's Meeting the above inputs:
Box Type | [NAME] (ft) | [NAME] (ft) | [NAME] (ft) | Available Colors
B | 2 | 3 | 2 | Brown, Grey
F | 2 | 2 | 2 | Red, Yellow
I | 3 | 3 | 3 | White
J | 2 | 2 | 2 | Green, Orange
L | 2 | 3 | 2 | Blue
Spreadsheet: 60651d1261146303-inputing-and-collecting-data-tank-thickness-2-
Sheet: Model 1190

 |  |  | Data Entry: |  | Entry 1 | Entry 2 | Entry 3 | Entry 4 | Entry 5 | Entry 6 | Entry 7 | Entry 8 | Entry 9 | Entry 10
 |  |  |  | Date
 |  |  |  | Model Letter
 |  |  |  | Height
 |  |  |  | Zone 1
 |  |  |  | Zone 2
 |  |  |  | Zone 3
 |  |  |  | Zone B/C
 |  |  |  | Zone B/E
 |  |  |  | Tank Circumference
 |  |  |  | Base Circumference
Spreadsheet: 90410d1290126769-statistical-data-sheet-assistance-october-2010-1
Sheet: Leave

September = 14X22=308 | Staff Member | Leave start | Return | Total leave days (minus weekends) | Total  days  308( # staff x working days
 |  | 2010-09-10 00:00:00 | 2010-09-14 00:00:00 | 3
 |  | 2010-09-02 00:00:00 | 2010-09-07 00:00:00 | 4
 |  | 2010-09-17 00:00:00 | 2010-09-20 00:00:00 | 2
 |  | 2010-09-29 00:00:00 | 2010-09-30 00:00:00 | 2
 |  | 2010-09-01 00:00:00 | 2010-09-03 00:00:00 | 3
 |  | 2010-09-23 00:00:00 | 2010-09-24 00:00:00 | 2
 |  | 2010-09-13 00:00:00 | 2010-09-13 00:00:00 | 1 | 0.9253246753246753
 |  | 2010-09-14 00:00:00 | 2009-09-16 00:00:00 | 2
 |  | 2010-09-20 00:00:00 | 2010-09-23 00:00:00 | 4
 |  |  |  | 23 | 95% *( Total days – leave days total /Total days
October - 14X21=294 | Staff Member | Leave start | Return | Total leave days (minus weekends) | Total  days   308( # staff x working days
 |  | 2010-10-01 00:00:00 | 2010-10-18 00:00:00 | 16
 |  | 2010-10-05 00:00:00 | 2010-10-08 00:00:00 | 4
 |  | 2010-10-18 00:00:00 | 2010-10-19 00:00:00 | 2
 |  | 2010-09-19 00:00:00 | 2010-09-19 00:00:00 | 1
 |  |  |  | 23 | 0.9217687074829932
 |  |  |  |  | 95% *( Total days – leave days total /Total days
Spreadsheet: 853223d1703122364-combining-data-from-multiple-sheets-vstack-etc-example
Sheet: Sheet1

 |  | Consolidated |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 1 |  | Name | Party | Badge # |  |  |  |  | Name | Party | Badge # |  | Name | Party | Badge #
 |  |  | Independent | 11 |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | 11
 |  | [NAME] | Democrat | 15 |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | 15
 |  | [NAME] | Independent | 18 |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | 19
 |  | [NAME] | Republican | 19 |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | 22
 |  | [NAME] | Independent | 20 |  |  |  |  |  |  |  |  | [NAME] | Independent | 20
 |  | [NAME] | Republican | 22
 |  | [NAME] | Republican | 31
 |  | [NAME] | Democrat | 45
 |  | Consolidated |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 2 |  | Name | Party | Badge # |  |  |  |  | Name | Party | Badge # |  | Name | Party | Badge #
 |  |  | Democrat | 45 |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent
 |  | [NAME] | Republican | 22 |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat
 |  | [NAME] | Independent | 18 |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican
 |  | [NAME] | Republican | 31 |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican
 |  | [NAME] | Independent | 0 |  |  |  |  |  |  |  |  | [NAME] | Independent
 |  | [NAME] | Democrat | 0
 |  | [NAME] | Republican | 0
 |  | [NAME] | Republican | 0
 |  | [NAME] | Independent | 0
 |  | Consolidated |  |  |  |  |  |  | 2022 |  |  |  | 2023
EXAMPLE 3 |  | Name | Party | Badge # | Committee Room |  |  |  | Name | Party | Badge # |  | Name | Party | Committee Room
 |  |  | Democrat | 45 |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | A10
 |  | [NAME] | Republican | 22 |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | B25
 |  | [NAME] | Independent | 18 |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | A10
 |  | [NAME] | Republican | 31 |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | A15
 |  | [NAME] | Independent | A10 |  |  |  |  |  |  |  |  | [NAME] | Independent | C12
 |  | [NAME] | Democrat | B25
 |  | [NAME] | Republican | A10
 |  | [NAME] | Republican | A15
 |  | [NAME] | Independent | C12
EXAMPLE 4 |  | Consolidated |  |  |  |  |  |  | 2022 |  |  |  | 2023
 |  | Name | Party | Badge # | Committee Room |  |  |  | Name | Party | Badge # |  | Name | Party | Committee Room
 |  |  |  |  |  |  |  |  | [NAME] | Democrat | 45 |  | [NAME] | Independent | A10
 |  | [NAME] |  |  |  |  |  |  | [NAME] | Republican | 22 |  | [NAME] | Democrat | B25
 |  | [NAME] |  |  |  |  |  |  | [NAME] | Independent | 18 |  | [NAME] | Republican | A10
 |  | [NAME] |  |  |  |  |  |  | [NAME] | Republican | 31 |  | [NAME] | Republican | A15
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  | [NAME] | Independent | C12
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
Spreadsheet: 832827d1686624927-find-the-longest-word-find-the-longest-word
Sheet: Sheet1

ARWEN | OLORIN |  |  |  |  |  |  | Available letters |  | A | L | D | F | V | A | N | G
GALADRIEL | SARUMAN
CELEBORN | GLAMDRING |  |  |  |  |  |  | RESULT
GANDALF | SHINE |  |  | GANDALF
PIPPIN | BAGGINS
TREEBEARD | GOLLUM
BARAHIR | SAURON
BILBO | ELROND
ARAGORN | LAVA |  |  |  | LAVA
SHELOB
ANDUIN
MITHRANDIR
Spreadsheet: 2e7c4ee6-7e5f-4edd-a040-7ae51341a4bc
Sheet: Sheet1

Please [NAME] This Form To: [EMAIL]
Your Name |  |  |  | Your [NAME]
Your Phone |  |  |  | Group Name
 |  |  |  | (specify club/conference)
[NAME]'s [NAME]
Account KSA/SOFO (required) or |  |  |  | Company Sponsor Name (if any)
Conference [NAME] (if applicable)
Order Request Date |  |  |  | Delivery Date
Delivery Time |  |  |  | Delivery Room
Want a Table? |  | YES | NO | Number of People
 |  |  |  | Expected (required)
 | Tried and Tested Vendors (circle or highlight)
 | Asterisk * = Wildcat Express Delivery Vendor - $35 delivery fee applies.
 | Aguas Tortas |  | *Buffalo Wild Wings |  | *Chipotle |  | Corner Bakery
 |  |  |  |  | (need 4 days notice)
 | Cosi |  | *[NAME] |  | [NAME]'s Pizza |  | [NAME]
 | *[NAME] |  | [NAME] |  | Koi |  | *[NAME]
 |  |  | (click here to order) |  |  |  | (delivery after 4pm only)
 | *Noodles & Co |  | [NAME] |  | [NAME] |  | [NAME]
 | Potbelly's |  | *Rollin' To Go |  | Sarpino's |  | [NAME]
 |  |  |  |  |  |  | (closed Mondays)
 |  |  | Uru Swati |  | *[NAME]
Specify Unlisted Vendor:
Unlisted Vendor Contact Details:
 | List food, drinks, and any additional items below:
Student Affairs Use: |  | Order Placer |  |  |  | Date Placed
 | [NAME] |  |  |  |  | Card Used
 | Order Amount |  |  |  |  | Tip
 |  | Notes
Spreadsheet: 188838d1351005182-calculating-value-between-two-points-solar
Sheet: Apr

 |  | Service Dates: |  | 2012-04-03 00:00:00 |  |  | thru | 2012-05-02 00:00:00
 | PG&E RATES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | Baseline |  | 101-130% |  | 131-200% |  | 201-300% |  | 301%+
 | 842.94 |  | 842.94 | 1095.822 | 1095.822 | 1685.88 | 1685.88 | 2528.82 | 2528.82
 | 0.12845 |  | 0.14602 |  | 0.2994 |  | 0.3394 |  | 0.3394
 | 724.7099999999999 |  |  | 0 |  | 0 | 0 |  | 0
 | RATE CHARGES
 | T1 |  | T2 |  | T3 |  | T4 |  | T5
 | 93.0889995 |  | 0 |  | 0 |  | 0 |  | 0
 | Total Consumed |  |  | PG&E |  |  |  | Solar
 | 724.7099999999999 |  |  | 121 |  |  |  | 603.7099999999999
 | Total Charges |  |  | PG&E |  |  |  | Solar Savings
 |  |  |  | Billed |  | Min
 | 93.0889995 |  |  | 15.57 |  | 4.43 |  | 73.0889995
 |  |  |  |  | 20
 | Date | Solar |  | Date | Solar |  |  | Total
 | 2012-04-01 00:00:00 |  |  | 2012-04-17 00:00:00 | 22.12 |  |  | Solar | 603.7099999999999
 | 2012-04-02 00:00:00 |  |  | 2012-04-18 00:00:00 | 22.8
 | 2012-04-03 00:00:00 | 18.6 |  | 2012-04-19 00:00:00 | 22.6
 | 2012-04-04 00:00:00 | 17.9 |  | 2012-04-20 00:00:00 | 20.81 |  | [NAME] |  | 2.00847928740073
 | 2012-04-05 00:00:00 | 24.54 |  | 2012-04-21 00:00:00 | 19.3 |  | Estimate |  | 300.5806451612903
 | 2012-04-06 00:00:00 | 24.5 |  | 2012-04-22 00:00:00 | 18.9 |  | Actual |  | 603.7099999999999
 | 2012-04-07 00:00:00 | 23.1 |  | 2012-04-23 00:00:00 | 22.14 |  | Estimate
 | 2012-04-08 00:00:00 | 21.83 |  | 2012-04-24 00:00:00 | 12.42 |  |  |  | Apr | May
 | 2012-04-09 00:00:00 | 21.2 |  | 2012-04-25 00:00:00 | 17.11 |  | Proposed Prod |  | 300 | 319
 | 2012-04-10 00:00:00 | 23.5 |  | 2012-04-26 00:00:00 | 14.62 |  | Days |  | 30 | 31
 | 2012-04-11 00:00:00 | 14.4 |  | 2012-04-27 00:00:00 | 23.6 |  | Per Day |  | 10 | 10.29032258064516
 | 2012-04-12 00:00:00 | 18.41 |  | 2012-04-28 00:00:00 | 22.93 |  | Billed Days |  | 28 | 2
 | 2012-04-13 00:00:00 | 6.9 |  | 2012-04-29 00:00:00 | 21.7 |  | Total |  | 280 | 20.58064516129032
 | 2012-04-14 00:00:00 | 15.34 |  | 2012-04-30 00:00:00 | 20.4 |  |  | T2 | -118.2300000000001
 | 2012-04-15 00:00:00 | 24.6 |  | 2012-04-01 00:00:00 | 22.3 |  |  |  | 0.01757
 | 2012-04-16 00:00:00 | 22.81 |  | 2012-04-02 00:00:00 | 22.33 |  |  | T3 | -371.1120000000002
 |  |  |  |  |  |  |  |  | 0.15338
 |  |  |  |  |  |  |  | T4 | -961.1700000000002
 |  |  |  |  |  |  |  |  | 0.03999999999999998
Spreadsheet: 859111d1707561883-number-of-days-between-similar-record-types-warmcoldrecords
Sheet: Sheet1

 | Desired Table |  |  |  |  |  |  |  | Test Table
 | Date | Type of Record | # of Days Between Similar Records | # of Similar Records in a Row | End Date for Similar Records | # of Similar Records in Streak |  |  | Date | Type of Record | # of Days Between Similar Records | # of Similar Records in a Row | End Date for Similar Records | # of Similar Records in Streak
 | 1900-01-14 00:00:00 | Warmest |  | 1 | 1900-01-20 00:00:00 | 2 |  |  | 1900-01-14 00:00:00 | Warmest
 | 1900-01-20 00:00:00 | Warmest |  | 2 |  |  |  |  | 1900-01-20 00:00:00 | Warmest
 | 1900-01-22 00:00:00 | Coldest |  | 1 | 1900-01-23 00:00:00 | 2 |  |  | 1900-01-22 00:00:00 | Coldest
 | 1900-01-23 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-01-23 00:00:00 | Coldest
 | 1900-01-24 00:00:00 | Warmest |  | 1 | 1900-01-24 00:00:00 | 1 |  |  | 1900-01-24 00:00:00 | Warmest
 | 1900-01-31 00:00:00 | Coldest |  | 1 | 1900-01-31 00:00:00 | 1 |  |  | 1900-01-31 00:00:00 | Coldest
 | 1900-02-15 00:00:00 | Warmest |  | 1 | 1900-02-15 00:00:00 | 1 |  |  | 1900-02-15 00:00:00 | Warmest
 | 1900-02-24 00:00:00 | Coldest |  | 1 | 1900-02-24 00:00:00 | 1 |  |  | 1900-02-24 00:00:00 | Coldest
 | 1900-02-25 00:00:00 | Warmest |  | 1 | 1900-02-25 00:00:00 | 1 |  |  | 1900-02-25 00:00:00 | Warmest
 | 1900-03-15 00:00:00 | Coldest |  | 1 | 1900-03-16 00:00:00 | 3 |  |  | 1900-03-15 00:00:00 | Coldest
 | 1900-03-15 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-03-15 00:00:00 | Coldest
 | 1900-03-16 00:00:00 | Coldest |  | 3 |  |  |  |  | 1900-03-16 00:00:00 | Coldest
 | 1900-03-17 00:00:00 | Warmest |  | 1 | 1900-03-17 00:00:00 | 1 |  |  | 1900-03-17 00:00:00 | Warmest
 | 1900-03-22 00:00:00 | Coldest |  | 1 | 1900-04-07 00:00:00 | 3 |  |  | 1900-03-22 00:00:00 | Coldest
 | 1900-04-06 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-04-06 00:00:00 | Coldest
 | 1900-04-07 00:00:00 | Coldest |  | 3 |  |  |  |  | 1900-04-07 00:00:00 | Coldest
 | 1900-04-08 00:00:00 | Warmest |  | 1 | 1900-05-12 00:00:00 | 5 |  |  | 1900-04-08 00:00:00 | Warmest
 | 1900-04-27 00:00:00 | Warmest |  | 2 |  |  |  |  | 1900-04-27 00:00:00 | Warmest
 | 1900-04-28 00:00:00 | Warmest |  | 3 |  |  |  |  | 1900-04-28 00:00:00 | Warmest
 | 1900-05-03 00:00:00 | Warmest |  | 4 |  |  |  |  | 1900-05-03 00:00:00 | Warmest
 | 1900-05-12 00:00:00 | Warmest |  | 5 |  |  |  |  | 1900-05-12 00:00:00 | Warmest
 | 1900-05-13 00:00:00 | Coldest |  | 1 | 1900-06-26 00:00:00 | 2 |  |  | 1900-05-13 00:00:00 | Coldest
 | 1900-06-26 00:00:00 | Coldest |  | 2 |  |  |  |  | 1900-06-26 00:00:00 | Coldest
Spreadsheet: 151109d1334781159-matching-multiple-rows-to-column-compilingsonglist
Sheet: Sheet1

Song | Artist
Hide your love away | Beatles |  |  | Beatles
Penny lane | Beatles |  |  | Rolling Stones
Come together | Beatles
Paint it black | Rolling Stones
Wild Horses | Rolling Stones
Spreadsheet: 98215d1297213968-pulling-data-based-off-a-date-entered-test-spreadsheet
Sheet: Quotas

Daily Forecast | 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
Factory 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Factory 3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 5 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Factory 6 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 7 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 8 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Factory 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Factory 10 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3
Factory 11 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
All Factories | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26 | 26
[NAME]
Factory 1 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 2 |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4
Factory 3 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 4 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 5 |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4
Factory 6 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 7 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 8 |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4
Factory 9 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
Factory 10 |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4 |  |  |  |  | 4 | 4 | 4
Factory 11 |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3 |  |  |  |  | 3 | 3 | 3
All Factories |  |  |  | 33 | 33 | 33 |  |  |  |  | 33 | 33 | 33 |  |  |  |  | 33 | 33 | 33 |  |  |  |  | 33 | 33 | 33
Spreadsheet: 752897d1635079142-trying-to-find-solution-for-blank-spaces-123
Sheet: Sheet1

No | Name | 0 or 1
1 |  | 1
2 |  | 1
3 |  | 1
4 | [NAME] | 1
5 | [NAME] | 1
6 | Nataly | 1
7 |  | 1
8 | Angie | 1
9 |  | 1
10 |  | 1
11 | Marko | 1
12 | Stephen | 1
13 | Mario | 1
14 | [NAME] | 1
15 |  | 1
16 | Nikola | 1
17 | Norton | 1
18 | Ana | 1
19 |  | 1
20 |  | 1
21 | Maria | 1
22 |  | 1
23 |  | 1
24 |  | 1
25 |  | 0
26 |  | 0
27 |  | 0
28 |  | 0
29 |  | 0
30 |  | 0