tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 218880d1362597966-lists-and-alternate-cell-return-list-offset
Sheet: Sheet1

 |  | List 1 | Sales |  | List 2 | Sales
 |  | 2012-01-01 00:00:00 | 12 |  | 2012-01-02 00:00:00 | 6
 |  | 2011-01-01 00:00:00 | 13 |  | 2011-01-15 00:00:00 | 5
 |  | 2010-01-01 00:00:00 | 10 |  | 2010-01-22 00:00:00 | 7
 |  | 2009-01-01 00:00:00 | 15 |  | 2009-01-03 00:00:00 | 11
 |  | 2008-01-01 00:00:00 | 16 |  | 2008-01-04 00:00:00 | 18
 |  | 2007-01-01 00:00:00 | 17 |  | 2007-03-06 00:00:00 | 3
 |  | 2006-01-01 00:00:00 | 18 |  | 2006-02-05 00:00:00 | 15
 |  | 2005-01-01 00:00:00 | 19 |  | 2005-04-06 00:00:00 | 0
 |  | 2004-01-01 00:00:00 | 11 |  | 2004-01-01 00:00:00 | 7
 | List | List 2
 | Date | 2007-03-06 00:00:00
 | Sales
Question 1:  How do I get the drop down arrow remain visible when the cell is not active?  (Cell C15 and Cell C17)
Question 2:  How can I get the sales to auto populate based on list and date?
Spreadsheet: 36196cf3-99b2-448d-84c6-d8c2b52da83c
Sheet: Sheet1

Artist | Title | SubTitle | CatalogNumber | Category | Discs | [NAME] | Label | RetailPrice | UPC
VPI | Single Motor/ Flywheel Assembly |  | S VPI MTRFLY | Turntable Upgrade |  |  | Equipment | 900
VPI | Scoutmaster Turntable Upgrade Package A |  | S SCOUTPKGA | Turntable Upgrade |  |  | Equipment | 160
Spreadsheet: 480894d1474129553-need-something-like-a-vlookup-but-matches-two-different-cells-and-averages-the-numbers-copy-of-doublematchexample-v3
Sheet: Sheet1

Name | Number | Color | Shape |  | Average Number |  | Average Number |  | Average Number
TestA | 1 | Blue | Square |  | 3 |  | 3 |  | 3
TestB | 2 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestC | 3 | Yellow | Circle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestD | 4 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestE | 2 | Yellow | Circle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestF | 4 | Blue | Square |  | 3 |  | 3 |  | 3
TestG | 5 | Blue | Triangle |  | 5 |  | 5 |  | 5
TestH | 3 | Red | Circle |  | 2 |  | 2 |  | 2
TestI | 1 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestJ | 1 | Yellow | Square |  | 1 |  | 1 |  | 1
TestK | 2 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestL | 3 | Blue | Square |  | 3 |  | 3 |  | 3
TestM | 3 | Yellow | Circle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestN | 4 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestO | 3 | Blue | Square |  | 3 |  | 3 |  | 3
TestP | 2 | Red | Circle |  | 2 |  | 2 |  | 2
TestQ | 3 | Yellow | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestR | 5 | Blue | Square |  | 3 |  | 3 |  | 3
TestT | 3 | Red | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestU | 1 | Red | Circle |  | 2 |  | 2 |  | 2
TestV | 2 | Yellow | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestW | 3 | Yellow | Triangle |  | 2.666666666666667 |  | 2.666666666666667 |  | 2.666666666666667
TestX | 2 | Red | Circle |  | 2 |  | 2 |  | 2
TestY | 2 | Blue | Square |  | 3 |  | 3 |  | 3
TestZ | 3 | Red | Square |  | 3 |  | 3 |  | 3
Spreadsheet: 850770d1701142392-how-to-solve-sum-with-several-requirements-training_requirements_example
Sheet: Data

Training | Total Amount of lessons
 | Office 1 | Office 2 | Office 3
Drone | 23 | 16 | 24
FwK | 6 | 9 | 3
ELW 2 | 24 | 6 | 36
 | Training Function
 | Office 1 | Office 2 | Office 3
 | ELW 2 Drone | FwK | ELW 2
 | FwK | ELW 2 Drone | ELW 2
 | ELW Drone | ELW Drone | ELW 2 Drone
 | ELW 2 Drone | ELW 2 | FwK
 | FwK | FwK | ELW 2 Drone
 | ELW 2 | FwK | ELW 2 Drone
 | ELW 2 Drone | ELW Drone | ELW 2 Drone
Spreadsheet: 859612d1707936451-getting-last-entry-for-a-year-book1-1-
Sheet: Sheet1

Date | Action | Qty | CS | DS | DP | CS1 | CP1 |  |  | DS Total | DS Median | first of year | Last of year
2023-06-21 00:00:00 | p | 295 | 3.85 |  |  |  |  |  | 2023 |  |  | 12.32 |  | Wrong answer
2023-09-20 00:00:00 | p | 13 | 3.87
2023-10-04 00:00:00 | d | 3.394 | 3.62994 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 12.68
2023-11-03 00:00:00 | d | 3.727 | 3.34317
2023-11-07 00:00:00 | p | 1 | 3.5
2023-11-20 00:00:00 | p | 1 | 3.68
2023-12-05 00:00:00 | d | 3.409 | 3.71957
2024-01-01 00:00:00 | p | 1 | 3.86 |  |  |  |  |  | 2024 |  |  |  |  | Wrong answer
2024-01-16 00:00:00 | d | 3.336 | 3.84293
2024-02-02 00:00:00 | d | 3.455 | 3.75977 |  |  |  |  |  |  |  | Correct answer is in cell F10 is |  | 11.74791
2024-02-10 00:00:00 | d | 3.115 | 3.7714
2025-07-08 00:00:00 | d | 3.478 | 3.978
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Both forfmulas in cell N4 and cell N11 go to the last enter in the column and do not stop at the end of year.
Spreadsheet: 107609d1304720446-copying-multiple-columns-into-single-row-excel-issue
Sheet: input

 |  | Return on assets | Return on equity | Current ratio
company "A" | Y1 | -0.1355283944458302 | 0.4449094713856792 | 0.2319686411149826
 | Y2 | -0.004214359596857609 | -0.03646719431910644 | 0.4087801217376803
 | Y3 | 0.07733865496699563 | 0.1261204515722661 | 0.9403198172472872
 | Y4 | 0.07356177583212391 | 0.1606001973820902 | 1.789343965204784
 | Y5 | 0.09791454655831264 | 0.1594770554995629 | 0.8489134295585908
company "B" | Y1 | 0.009146393272688532 | 0.05321640985077805 | 2.38419855552452
 | Y2 | -0.04653300040291228 | -0.3165285620004399 | 2.016933261901117
 | Y3 | -0.05481229460043081 | -0.4175902244955954 | 2.073707270042349
 | Y4 | 0.007620341029123284 | 0.06668576838748255 | 2.093521972294437
 | Y5 | 0.02548828431246775 | 0.1539064046616917 | 1.925402536603454
company "C" | Y1 | 0.1018091299470296 | 0.2364745416244514 | 0.7643643382944335
 | Y2 | -0.148623009749071 | -0.4720763614927674 | 0.9270019362423069
 | Y3 | -0.6903166076784354 | 4.603205736242183 | 1.429731914320356
 | Y4 | -0.2754837091159961 | 0.6061519778650236 | 1.143366867406969
 | Y5 | -0.2716170656576682 | 0.2844232039147294 | 0.8649672338123009
Spreadsheet: 78448d1278808515-using-a-list-box-to-perform-lookups-on-a-table-archery-example
Sheet: Archery HC

 |  |  |  |  |  |  |  |  | Input Range |  | Cell Link
 |  |  |  | Round A | Round B | Round C | Handicap |  | Round A |  | 3
 | Score | Round |  | 507 | 513 | 520 | 33 |  | Round B
 | 520 |  |  | 512 | 516 | 528 | 32 |  | Round C
 |  |  |  | 516 | 520 | 536 | 31
 |  |  |  | 519 | 523 | 542 | 30
 |  |  |  | 523 | 526 | 549 | 29
 | Handicap |  |  | Handicaps
 |  |  |  | A score of 520 results in a 30 Handicap on Round A (rounded down to the next highest handicap)
 |  |  |  | A score of 520 results in a 31 Handicap on Round B
 |  |  |  | A score of 520 results in a 33 Handicap on Round C
Spreadsheet: 117008d1312391966-importing-a-text-file-livescan-stats
Sheet: Sheet1

 | Applicant | Criminal | Hazmat | Juvie | Local | Permit | [NAME]. | Two Finger
nesplss001
nesplss002
nesplss003
nesplss004
nesplss005
nesplss006
nesplss007
nesplss008
nesplss009
nesplss010
nesplss011
nesplss012
[NAME]
nesplss014
[NAME]
[NAME]
nesplss017
nesplss018
nesplss019
nesplss020
nesplss021
nesplss022
[NAME]
nesplss024
nesplss025
nesplss026
nesplss027
nesplss028
Spreadsheet: 814829d1674627126-timesheet-with-dropdown-list-specific-passwords-leave-tracker
Sheet: Time Off Balances

Employee | Vacation | Sick | Birthday | Bereavement
 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 12 | 7 | 1 | 3
0 | 12 | 7 | 1 | 3
0 | 15 | 10 | 1 | 3
0 | 10 | 5 | 1 | 3
0 | 10 | 5 | 1 | 3
0 | 10 | 5 | 1 | 3
0 | 10 | 5 | 1 | 3
0 | 10 | 5 | 1 | 3
Spreadsheet: 812831d1673399218-fonction-si-conditionnelle-ou-recherchev-bar_me-examen-locale-3ac-1-beamer
Sheet: Feuil1

 | Barème examen locale 3AC
 | Course de vitesse
Note /20 | 40m |  |  | 70m |  | 80m | 60m |  |  | Garcons/Filles | Distance | Note
 | Garcons | Filles |  | G |  | G | F |  |  | Garcons | 80 | 20
20 | 5.05 | 5.866666666666667 |  |  |  | 10.1 | 8.8 |  |  | Filles | 60 | 20
19 | 5.3 | 6.066666666666666 |  |  |  | 10.6 | 9.1 |  |  | Garcons | 70 | 1
18 | 5.5 | 6.266666666666667 |  |  |  | 11 | 9.4 |  |  | Filles | 60 | 5
17 | 5.7 | 6.466666666666666 |  |  |  | 11.4 | 9.7
16 | 5.9 | 6.666666666666666 |  |  |  | 11.8 | 10
15 | 6.1 | 6.866666666666667 |  |  |  | 12.2 | 10.3
14 | 6.3 | 7.066666666666666 |  |  |  | 12.6 | 10.6
13 | 6.5 | 7.266666666666667 |  |  |  | 13 | 10.9
12 | 6.7 | 7.466666666666666 |  |  |  | 13.4 | 11.2
11 | 6.9 | 7.666666666666666 |  |  |  | 13.8 | 11.5
10 | 7.1 | 7.866666666666667 |  |  |  | 14.2 | 11.8
9 | 7.3 | 8.066666666666666 |  |  |  | 14.6 | 12.1
8 | 7.5 | 8.266666666666666 |  |  |  | 15 | 12.4
7 | 7.7 | 8.466666666666665 |  |  |  | 15.4 | 12.7
6 | 7.95 | 8.666666666666666 |  |  |  | 15.9 | 13
5 | 8.15 | 8.866666666666667 |  |  |  | 16.3 | 13.3
4 | 8.35 | 9.066666666666666 |  |  |  | 16.7 | 13.6
3 | 8.55 | 9.266666666666666 |  |  |  | 17.1 | 13.9
2 | 8.75 | 9.466666666666665 |  |  |  | 17.5 | 14.2
1 | 8.95 | 9.666666666666666 |  |  |  | 17.9 | 14.5
Spreadsheet: 118096d1313440771-insert-blank-cells-in-lines-missingareblank
Sheet: Sheet1

1 | 4 | 5 | 6 | 7 | 9 | 10 | 11 | 13 | 15 | 16 | 18 | 21 | 23 | 25 |  |  | 1 |  |  | 4 | 5 | 6 | 7 |  | 9 | 10 | 11 |  | 13 |  | 15 | 16 |  | 18 |  |  | 21 |  | 23 |  | 25
2 | 3 | 4 | 6 | 8 | 9 | 10 | 11 | 12 | 13 | 17 | 19 | 23 | 24 | 25 |  |  |  | 2 | 3 | 4 |  | 6 |  | 8 | 9 | 10 | 11 | 12 | 13 |  |  |  | 17 |  | 19 |  |  |  | 23 | 24 | 25
5 | 6 | 7 | 9 | 10 | 12 | 14 | 15 | 16 | 17 | 18 | 19 | 21 | 22 | 23 |  |  |  |  |  |  | 5 | 6 | 7 |  | 9 | 10 |  | 12 |  | 14 | 15 | 16 | 17 | 18 | 19 |  | 21 | 22 | 23
Spreadsheet: 864235d1711475930-retun-a-value-based-on-the-values-dates-in-other-cells-if-values-test-02
Sheet: Sheet1

PATRON | # | SINCE | ACTIVE | LINE | STATUS | LAST APP | LAST RAT | X | X2 | X3 | REQUIRE 1 | REQUIRE 2 | REQUIRE 3
 |  | 2019-08-02 00:00:00 | 2020-01-04 00:00:00 |  | SUSP | 2019-07-29 00:00:00 | 2023-03-22 00:00:00
 |  | 2021-03-23 00:00:00 | No Activity |  | SUSP | 2024-02-01 00:00:00 | 2021-03-17 00:00:00 |  |  |  |  |  |  |  | There may be a case where ACTIVE(D) has a value of "No Activity" in this case, the return should be YES.
 |  | 2021-05-15 00:00:00 | 2024-03-01 00:00:00 |  | CRDSUSP | 2021-05-15 00:00:00 | 2021-05-15 00:00:00
 |  | 2023-03-18 00:00:00 | 2024-01-31 00:00:00 |  | APPROVED | 2023-05-18 00:00:00 | 2023-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  | REQUIRE 1 | REQUIRE 2 | REQUIRE 3
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = APPROVED, RETURN BLANK | IF STATUS(F) = APPROVED, RETURN BLANK | IF STATUS(F) = APPROVED, RETURN BLANK
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = ANYTHING OTHER THAN SUSP, RETURN "SEE NOTES" | IF STATUS(F) = ANYTHING OTHER THAN SUSP, SHOW "SEE NOTES" | IF STATUS(F) = ANYTHING OTHER THAN SUSP, SHOW "SEE NOTES"
 |  |  |  |  |  |  |  |  |  |  | IF STATUS(F) = SUSP, AND LAST RAT(H) IS OLDER THAN 18 MONTHS SHOW "YES", OTHERWISE SHOW "NO" | IF STATUS(F) = SUSP AND LAST APP(G) IS OLDER THAN 36 MONTHS SHOW "YES", OTHERWISE SHOW NO | IF STATUS(F) = SUSP AND ACTIVE(D) IS OLDER THAN 6 MONTHS SHOW "YES", OTHERWISE SHOW NO
Spreadsheet: chris_germany__1961__ENA-Reliant Prepay
Sheet: Summary

ENA Prepays to Reliant
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
Reliant RES Cash Group |  | [NAME]  [PHONE]  [EMAIL]
 |  |  | Prepayment
 |  | Date | (Purchases) | Comments
 | Wed | 2002-02-06 00:00:00 | 22500
 | Fri | 2002-02-08 00:00:00 | 20000
 | Thu | 2002-02-14 00:00:00 | 26000
 | Thu | 2002-02-21 00:00:00 | 10000
 | Thu | 2002-02-28 00:00:00 | 19000
 |  | Total Prepays Feb 2002
 |  | Feb 2002 Swing Purchases
 |  | Cash Balance on 2/28/02
 | Wed | 2002-03-06 00:00:00 | 42000
 | Thu | 2002-03-14 00:00:00 | 25000
 | Thu |  | 30000 | 3/22/02 9:00AM  verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 40000 | To be applied to Prepayment for FGT and TRKL swing activity.  3/29/02  2:45 PM verfied payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 701760 | To be applied to Apr 2002 Baseload Purchase on Trunkline.  3/29/02 2:45 PM verified payment with [NAME]
 | Thu | 2002-03-28 00:00:00 | 989700 | To be applied to Apr 2002 Baseload Purchase on Florida.  3/29/02 2:45 PM verified payment with [NAME].
 |  | Total Prepays Mar 2002
 |  | Mar 2002 Swing Purchases
 |  | Cash Balance on 3/31/02
 | Thu | 2002-04-04 00:00:00 | 37000 | 4/8/02 1:45 PM verified payment with [NAME]
 | Fri |  | 22000
 | Thu |  | 0
 | Thu |  | 0
 |  | Total Prepays Apr 2002
 |  | Apr 2002 Baseload Purchase on Trunkline |  | Sitara #1202698
 |  | Apr 2002 Baseload Purchase on Florida |  | Sitara #1203148
 |  | Apr 2002 Swing Purchases |  | Sitara #1203186
 |  | Total Apr 2002 Purchases
 |  | Current Cash Balance
Notes: | 4/9/02  2:30 PM - Per [NAME] at Reliant - purchase formula for the March 1st is using [NAME] instead of GD + $.06.  Fixed formula in spreadsheet, total impact to cash balance is ($120.00)
Spreadsheet: 835651d1688700319-separating-auto-updated-data-into-categories-on-other-table-test-1
Sheet: Sheet1 (2)

 | Team Name | Location |  |  | Team A | Team B | Team C | Team D | Team E
 | Team A | London |  |  | London | Singapore | Jakarta | Moscow | Moscow
 |  | Cairo |  |  | Cairo | Quebec | Lima | Paris | Paris
 |  | Tokyo |  |  | Tokyo | Lima |  | Dubai | Dubai
 |  | Moscow |  |  | Moscow | Dubai |  | Tokyo
 |  | Singapore |  |  | Singapore
 | Team B | Singapore
 |  | Quebec
 |  | Lima
 |  | Dubai
 | Team C | Jakarta
 |  | Lima
 | Team D | Moscow
 |  | Paris
 |  | Dubai
 |  | Tokyo
 | Team E | Moscow
 |  | Paris
 |  | Dubai
Spreadsheet: 871692d1718110868-bulk-copying-cell-notes-excel-help-cell-notes
Sheet: Sheet1

 | Input
 |  | Group 1 |  |  |  | Group 2
 |  | Name | First Note | Second Note |  | Name | First Note | Second Note
 |  | Cat |  |  |  | Goat
 |  | Dog |  |  |  | Lion
 |  | Giraffe |  |  |  | Fox
 |  | Elephant |  |  |  | Cat
 |  | Goat |  |  |  | Elephant
 |  | Bird |  |  |  | Hippo
 | Output
 |  |  | Group 1 |  | Group 2
 |  | Name | First Note | Second Note | First Note | Second Note
 |  | Cat
 |  | Dog
 |  | Giraffe
 |  | Elephant
 |  | Goat
 |  | Bird
 |  | Lion
 |  | Fox
 |  | Hippo
Spreadsheet: 105107d1302566596-identifying-number-associated-with-most-recent-unique-id-sample-worksheet
Sheet: Sheet1

Unique ID | Activities | Total Number of Activities |  |  | Check ID |  | Check # | # >=
JANUARY |  |  |  |  | 7 |  | 2
1 | 1
2 | 1
3 | 1
4 | 1
FEBRUARY
1 | 1
2 | 1
3 | 1
4 | 1
5 | 1
6 | 1
7 | 1
[NAME]
1 | 1
2 | 1
3 | 1
4 | 1
7 | 1
8 | 1
9 | 1
Spreadsheet: 199424d1355214360-how-to-calculate-a-formula-when-an-error-occurs-within-the-related-cells-00_f__asample-3
Sheet: Sheet1

Template Contract Quote |  |  |  |  |  | ADD COMPANY LOGO HERE
Claim No: |  | Contractor
Claimant: |  | Address:
Site Location: |  | Accreditation No:
EQR Supervisor: |  | [NAME]:
 |  | GST No:
Date: |  | Total Price ([NAME]. GST)
Rooms | Description of Work/s | Unit | Dimension | $ [NAME] | Contractors Quote | Room Total | Scope Change
Lounge: | Gap fill and paint | m | 26
Scope Change
Dining Room:
Scope Change
Kitchen:
Scope Change
Family Room:
Scope Change
Bedroom 1:
Scope Change
Bedroom 2:
Scope Change
Bedroom 3:
Scope Change
Contract Quotation |  |  |  |  | ADD COMPANY LOGO HERE
Address:
Claim #:
Rooms | Description of Work/s | Unit | Dimension | $ [NAME] | Contractors Quote | Room Total | Scope Change
Bedroom 4:
Scope Change
Bedroom 5:
Scope Change
Ensuite:
Scope Change
Bathroom 1:
Scope Change
Bathroom 2:
Scope Change
Toilet 1:
Scope Change
Toilet 2:
Scope Change
Office/Study:
Scope Change
Rumpus:
Scope Change
Contract Quotation |  |  |  |  | ADD COMPANY LOGO HERE
Address:
Claim #:
Rooms | Description of Work/s | Unit | Dimension | $ [NAME] | Contractors Quote | Room Total | Scope Change
Entry:
Scope Change
Hallway:
Scope Change
Stairwell:
Scope Change
Laundry:
Scope Change
Garage:
Scope Change
Conservatory:
Scope Change
Other:
Scope Change
Roof:
Scope Change
External Walls:
North
Scope Change
Contract Quotation |  |  |  |  | ADD COMPANY LOGO HERE
Address:
Claim #:
Rooms | Description of Work/s | Unit | Dimension | $ [NAME] | Contractors Quote | Room Total | Scope Change
External Walls:
South
Scope Change
External Walls:
East
Scope Change
External Walls:
West
Scope Change
Decks:
Scope Change
[NAME]:
Scope Change
Chimney:
Scope Change
Other
Scope Change
Fireplace:
Scope Change
Foundation:
Scope Change
Contract Quotation |  |  |  |  | ADD COMPANY LOGO HERE
Address:
Claim #:
Rooms | Description of Work/s | Unit | Dimension | $ [NAME] | Contractors Quote | Room Total | Scope Change
Piling:
Scope Change
Scaffolding | Please confirm area required
Scope Change
Scope Change
List P&G
 |  | Subtotal (excl. GST)
 |  |  | Add 15% GST
 |  | Total Incl. GST
 | Grand Total with Scope Changes Ext  GST
 | Grand Total with Scope Changes Incl.  GST
Contract Quotation
Estimated time of Completion |  | Days_______________
Start date______________ |  | Finish Date____________
Signature of Contractor______________________________ |  |  |  | Date_______
Spreadsheet: 377554d1424053588-filtering-data-after-summing-up-in-pivot-table-oeldere-377503d1424025896-filtering-data-after-summing-up-in-pivot-table-details
Sheet: Data

 |  |  |  | 25000 |  |  | Choice | Yes
 | Name | Code | Amount | Choice
 | ABC | 560002 | 23400 |  |  |  | Som [NAME]
 | ABC | 560002 | 34566 |  |  |  | Name | Code | Total
 | ABC | 560002 | 90876 |  |  |  | ABC | 560002 | 148842
 | [NAME] | 560032 | 2300 |  |  |  | [NAME] | 4390867 | 30230
 | Dev | 562032 | 6700 |  |  |  | Olive oil | 34008 | 56000
 | Olive oil | 34008 | 56000 |  |  |  | Grand Total |  | 235072
 | [NAME] | 4390867 | 2340
 | [NAME] | 4390867 | 27890
Spreadsheet: 697222d1601272789-conditional-formatting-from-dropdown-and-entire-row-changed-color-excelformula-etaf
Sheet: Sheet1

 |  |  |  |  | Select from Dropdown 👉 | Due
Inv | Due date | Status |  |  | Month | Total Inv "Close"
IN005 | 2020-05-04 00:00:00 | Close |  |  | 2020-01-01 00:00:00
IN006 | 2020-06-01 00:00:00 | Due |  |  | 2020-02-01 00:00:00
IN007 | 2020-06-29 00:00:00 | Due |  |  | 2020-03-01 00:00:00
IN008 | 2020-08-02 00:00:00 | Close |  |  | 2020-04-01 00:00:00
IN009 | 2020-08-30 00:00:00 | Close |  |  | 2020-05-01 00:00:00
IN010 | 2020-09-28 00:00:00 | Due |  |  | 2020-06-01 00:00:00
IN011 | 2020-10-28 00:00:00 | Due |  |  | 2020-07-01 00:00:00
IN012 | 2020-11-26 00:00:00 | Close |  |  | 2020-08-01 00:00:00
IN001 | 2020-01-12 00:00:00 | Close |  |  | 2020-09-01 00:00:00
IN003 | 2020-03-03 00:00:00 | Close |  |  | 2020-10-01 00:00:00
INO12 | 2020-12-12 00:00:00 | Due |  |  | 2020-11-01 00:00:00
 |  |  |  |  | 2020-12-01 00:00:00
 |  |  |  |  | Close
 |  |  |  |  | Due
Spreadsheet: 239343d1369889099-conditional-formatting-based-on-magnitude-of-change-from-previous-value-conditional-formatting-example
Sheet: Sheet1

Month | Sales | Growth
Jan | 100
Feb | 111
Mar | 120
Apr | 125
May | 150
Jun | 130
Jul | 130
Aug | 110
Sep | 101
Oct | 140
Nov | 145
Dec | 200
Spreadsheet: 296492d1392112427-changing-point-to-comma-book1
Sheet: Pivot

 |  | Data
Measures | Region | Sum of Last day | Sum of Last week | Sum of Last Month | Sum of Last 2 months
Builds/day | Canada | 0 | 0 | 0 | 0
 | China | 0 | 0 | 0 | 0
 | Sweden | 0 | 0 | 0 | 0
Builds/day Total |  | 0 | 0 | 0 | 0
Number of builds | Canada | 2808 | 15244 | 73215 | 140856
 | China | 3709 | 20055 | 86306 | 195294
 | Sweden | 4035 | 23629 | 103019 | 207128
Number of builds Total |  | 10552 | 58928 | 262540 | 543278
Grand Total |  | 10552 | 58928 | 262540 | 543278
Spreadsheet: 867119d1713997380-count-the-number-of-days-since-the-last-accident-for-departments-test-accident-counts-by-dept-bvj-
Sheet: Sheet1

Date of Accident | Fault | Department |  |  | Department | Latest Uptime | Count | last accident | previous accident | Previous Uptime workdays
2012-01-05 00:00:00 | yes | garage |  |  | Garage
2012-01-07 00:00:00 | yes | production |  |  | Route Ops
2012-01-16 00:00:00 | Yes | Office |  |  | Product Control
2019-08-06 00:00:00 | yes | product control |  |  | Office
2022-05-04 00:00:00 | yes | garage |  |  | Maintenance
2023-06-01 00:00:00 | yes | product control |  |  | Engineering
2023-07-02 00:00:00 | yes | production
2023-08-06 00:00:00 | yes | garage
2023-10-23 00:00:00 | no | route ops
2024-01-01 00:00:00 | no | route ops
2024-01-04 00:00:00 | yes | route ops
2024-04-01 00:00:00 | no | route ops
2024-04-07 00:00:00 | yes | product control
Spreadsheet: 93900d1293661016-excel-2007-clearing-a-row-after-a-particular-word-selected-cat-working-file
Sheet: 365WE

365WE
LAST QUARTERLY | QUARTERLY DUE NLT | NEXT QUARTERLY START | UPDATED BY: | LAST MASO | MASO DUE NLT | NEXT MASO START | UPDATED BY: | JACKET REVIEW | IMT 68     DATE | IMT 68 REVIEW
2010-12-06 00:00:00 |  |  | BTO | 2010-08-31 00:00:00 |  |  | mf | 2010-12-01 00:00:00 | 2010-07-16 00:00:00 | 2010-09-08 00:00:00
JACKET REVIEW
NAME |  | DATE ACCOMPLISHED |  | COMMENTS / FINDINGS
Feeney |  | 2010-12-01 00:00:00 |  | Package sent 06 Dec 10-mf
GENERAL ACCOUNT INFORMATION / NOTES
RENNHACK-10OCT10 - SSgt Poirier submitted 7 expenditures this afternoon and 6 of them were incorrect, will follow up next week.
RETURN TO STATUS PAGE |  |  | INVENTORY STATUS PAGE
Spreadsheet: john_griffith__15756__10_17_01ON
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | NG X1 | 260 | 32 | 32.5 | 98.4 | 99.9 | 16.21 | 2001-10-17 12:09:00
 | NG Z1 | 285 | 59.5 | 61 | 78.6 | 80.6 | 14.26 | 2001-10-17 12:09:00
 | NG F2 | 305 | 79 | 83 | 75 | 78.9 | 14.76 | 2001-10-17 12:09:00
 | NG G2 | 305 | 90 | 94 | 70.8 | 74 | 13.88 | 2001-10-17 12:09:00
 | NG H2 | 300 | 89 | 94 | 63.3 | 67 | 12.29 | 2001-10-17 12:09:00
 | NG J2 | 295 | 79 | 82 | 52 | 54 | 9.83 | 2001-10-17 12:09:00
 | NG K2 | 290 | 80 | 84 | 49.3 | 51.8 | 9.22 | 2001-10-17 12:09:00
 | NG M2 | 295 | 84 | 89 | 47.1 | 50 | 9 | 2001-10-17 12:09:00
 | NG N2 | 300 | 89 | 93 | 46.4 | 48.5 | 8.95 | 2001-10-17 12:09:00
 | NG Q2 | 305 | 94 | 102 | 45.8 | 49.7 | 9.16 | 2001-10-17 12:09:00
 | NG U2 | 305 | 101 | 109 | 46.8 | 50.6 | 9.34 | 2001-10-17 12:09:00
 | NG V2 |  |  |  | 45.4 | 48.1 | 8.96 | 2001-10-16 15:08:00
 | [NAME] |  |  |  |  |  | 10.22 | 2001-10-16 14:55:00
 | NG H3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG M3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG U3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG Z3 |  |  |  |  |  |  | 2001-09-17 07:55:00
 | NG H4 |  |  |  |  |  |  | 2001-09-17 07:55:00
Spreadsheet: 792267d1660819274-data-separation-issue-dataexample_08162022
Sheet: Sheet1

Charge-1 Description
1-10yd Front Load - 1x/Week
1-8yd Front Load - 5x/Week
1-8yd Recycling - 5x/Week
1-6yd Recycling - 1x/Week
1-8yd Front Load - 3x/Week
Scrap Metal Service
Scrap Metal Service
1-10yd Scrap Metal - On Call
Scrap Metal Service
Scrap Metal Service
Scrap Metal Service
Fork Lift Rental
Scrap Metal Service
Empty & Return
Scrap Metal Service
Scrap Metal Service
Scrap Metal Service
Empty & Return
1-6yd Rear Load - 2x/Week
1-4yd Front Load - 1x/Week
1-4yd Recycling - 1x/Week
1-6yd Recycling - 1x/Week
10yd Open Top Rental
Empty & Return
(1) 8yd Front Load - 2x/wk
(1) 4yd Front Load - 1x/wk
30 Yard Empty & Return
20 Yard Final Pickup
(1) 8yd Front Load - 1x/wk
40 Yard Empty & Return
(1) 8yd Front Load - 1x/wk
(1) 8yd Front Load - 2x/wk
20 Yard Empty & Return
(1) 6yd Front Load - 3x/wk
20 Yard Empty & Return
10 Yard Empty & Return
30 Yard Empty & Return
20 Yard Final Pickup
30 Yard Final Pickup
(7) Cart Service