tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 13392de5-bd35-43ac-ada0-61c15d45cd3b
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Oppføringer fra [NAME]
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Telekiosken Skien AS | Bruene 1 | 3724 | Skien |  | 947 50 093
Wenma Telemark AS | Signalv 8 | 3724 | Skien | 35 50 37 50 | 35 50 37 60
Telekiosken Herkules AS | Ulefossvegen 32 | 3730 | Skien | 480 00 200 | 947 40 094
I.P.Shop [NAME] | Borgestadholmen 20 | 3712 | Skien
Lyd & Tele Telehuset AS | Strandvegen 2A | 3736 | Skien | 35 50 55 00 | 35 50 55 19
Vegard Johannessen Import & Service | [NAME] | 3731 | Skien | 908 72 273
A-Way AS | [NAME] 43 | 3731 | Skien
Nimtec AS | [NAME] 4 | 3717 | Skien |  | 35 59 86 73
[NAME] | Gregorius Dagssons Gate 120A | 3746 | Skien
Gadget-Grossisten Thomas Mogen Garnes | Lagmannslia Nord 50A | 3715 | Skien
Spesialisten AS | Bedriftsvegen 52 | 3735 | Skien
Vold Engineering AS | [NAME] 37 | 3731 | Skien | 35 59 87 02 | 35 54 65 46
Kk-Import [NAME] | Åfosskleiva 28 | 3731 | Skien
Oyatel AS | Unionsgata 18 Kunnskapsverkstedet | 3732 | Skien | 21 07 48 00
Tele Support [NAME] | Skippergata 2B | 3733 | Skien | 35 53 21 10
[NAME] Tarot [NAME] | Klyveåsen 7 | 3738 | Skien | 35 59 41 40
[NAME] | Prinsessegata 14 | 3724 | Skien
Agder & Grenland Salgsselskap AS | Uniongata 18 | 3732 | Skien
[NAME] | Futehagen 7C | 3738 | Skien
Z Nett AS | Jernverksvegen 50 | 3721 | Skien | 35 50 43 51 | 35 50 43 51
[NAME] | Ulefossvegen 610 | 3729 | Skien
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: richard_shapiro__32171__meals
Sheet: mont-meal-alloc

Montovano (087)
Employee Name | Requested | Approved | Justification
[NAME] |  | 72000 | number derived from prior history; assumes a monthly travel cost of $10,000; on road 90% of the time; covers all of New England
[NAME] |  | 48000 | number derived from prior history; assumes a monthly travel cost of $5,000; covers New York; cost includes two monthly trips to Houston
[NAME] |  | 60000 | number derived from prior history; assumes a monthly travel cost of $10,000; covers New Jersey and Mass; cost also includes two trips to Houston a month and four trips to Boston a month
[NAME] |  | 72000 | number derived from prior history; assumes a monthly travel cost of $10,000; covers PJM; takes two trips to Florida a month to cover RTO and travels to Houston one to two times a month
[NAME] |  | 96000 | number derived from prior history; assumes a monthly travel cost of $10,000; cost includes two trips a month to Houston for TCC and a minimum of three trips a month to Florida for RTO
[NAME] |  | 96000 | number derived from prior history; assumes a monthly travel cost of $10,000; covers Mid Atlantic states; on road at least 60% of the time
[NAME] |  | 96000 | number derived from prior history; assumes a monthly travel cost of $10,000; covers Florida; with legislature heating up in Florida in January cost will include extensive travel to Florida; also covers part of Mid Atlantic states; on road all the time
[NAME] |  | 60000 | number derived from prior history; covers New York
[NAME] |  | 0 | covers SERC; goes throughout SE; cost includes one to two trips to Houston per month
[NAME] |  | 108000 | travesl everyday; goes to New Jersey one day a week; travels to Florida, Georgia and New England one to two times a month to cover his areas of responsibility
TOTAL
Spreadsheet: 890021d1741133737-trying-to-get-pages-to-update-2025-wr-log
Sheet: Holidays

Date | Holiday
2025-01-01 00:00:00 | New Year’s Day
2025-01-20 00:00:00 | Birthday of [NAME], Jr.
2025-02-17 00:00:00 | Washington’s Birthday
2025-05-26 00:00:00 | Memorial Day
2025-06-19 00:00:00 | Juneteenth National Independence Day
2025-07-04 00:00:00 | Independence Day
2025-09-01 00:00:00 | Labor Day
2025-10-13 00:00:00 | Columbus Day
2025-11-11 00:00:00 | Veterans Day
2025-11-27 00:00:00 | Thanksgiving Day
2025-12-25 00:00:00 | Christmas Day
Spreadsheet: 84190d1284164536-2-variable-qty-use-index-match-but-how-example
Sheet: Sheet1

 |  | INPUT
 |  | variable1 | qty | variable 2 |  |  | Weights (kg) | box | carton | pallet
 |  | apple | 1 | box | 5 |  | apple | 5 | 15 | 100
 |  | banana | 2 | carton | 32 |  | banana | 6 | 16 | 110
 |  | oranges | 3 | pallet | 360 |  | oranges | 7 | 17 | 120
 |  |  |  | TOTAL | 397
 | [NAME]
 | 2 variable input + Quantity for each row
 | Want to automatically search the Weights table on the right
 | Return the appropriate weight based on the combination of the 2 variables multiplied by the quantity
 | As an example above:
 | 1. 1 box of apple is 1 x 5kg = 5kg
 | 2. 2 cartons of banana is 2 x 16kg = 32kg and so on
 | What sort of INDEX/MATCH formula to be used for each of the cells F3, F4 and F5?
Spreadsheet: 468049d1467117450-combining-data-from-one-table-into-a-new-table-example-ic52-form-i-may-2016-new-prc
Sheet: FORM I

 |  |  |  |  | TIMETABLE TRIPS
Route | BU | From | To | Route
no. |  |  |  | length
1 |  | 2 | 3 | 4 | MON | TUE | WED | THU | FRI | SAT | SUN
410020 | 41 | VALSCHFONTEIN "C". | MARABASTAD. | 130 | 1 | 1 | 1 | 1 | 1 | 0 | 0
410023 | 41 | MARABASTAD. | RAMOKGELETSANE. | 138 | 4 | 4 | 4 | 4 | 4 | 4 | 4
410025 | 41 | MARABASTAD. | WATERVAL NEW STANDS. | 134 | 6 | 6 | 6 | 6 | 6 | 2 | 0
410026 | 41 | WOLWEKRAAL. | BIG TREE. | 59 | 1 | 0 | 0 | 0 | 0 | 0 | 0
410027 | 41 | MARABASTAD. | RAMOKGELETSANE. | 139 | 1 | 1 | 1 | 1 | 1 | 1 | 0
410031 | 41 | WELTEVREDE. | MARABASTAD. | 136 | 1 | 0 | 0 | 0 | 0 | 0 | 0
410032 | 41 | MARABASTAD. | VAALBANK. | 128 | 0 | 0 | 0 | 0 | 1 | 0 | 0
410033 | 41 | RAMOKGELETSANE. | MARABASTAD. | 146 | 5 | 5 | 5 | 5 | 5 | 0 | 0
410034 | 41 | PIETERSKRAAL "A". | MARABASTAD. | 141.3 | 1 | 1 | 1 | 1 | 1 | 0 | 0
410037 | 41 | WATERVAL. | BIG TREE. | 72 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Values
 |  |  | RTE AS PER Form I | SKM | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  | 410020 | 130 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 |  |  | 410023 | 138 | 4 | 4 | 4 | 4 | 4 | 0 | 0
 |  |  | 410025 | 134 | 6 | 6 | 6 | 6 | 6 | 2 | 0
 |  |  | 410026 | 59 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 410027 | 139 | 1 | 1 | 1 | 1 | 1 | 1 | 0
 |  |  | 410031 | 136 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 410032 | 128 | 0 | 0 | 0 | 0 | 1 | 0 | 0
 |  |  | 410033 | 146 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 |  |  | 410034 | 141.3 | 1 | 1 | 1 | 1 | 1 | 0 | 0
 |  |  | 410037 | 72 | 1 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: gerald_nemec__11493__CASH_Wildhorse_121900
Sheet: Cash Flow

Wildhorse Cash Flow
Values in thousands of $'s unless otherwise stated
Dakota Gathering Revenue
Wasatch
Venoco
[NAME]
less: direct pass-through costs
Total Gathering Revenue
Liquids Revenue
TOTAL REVENUE
Cost of Sales (shrink gas)
GROSS MARGIN
O&M
G&A
Ad Valorem
NGL Production Taxes
EBITDA
Capex |  |  |  |  |  |  |  |  |  |  |  |  |  | Terminal Value
FREE CASH FLOW
 |  |  |  |  | Present Value:
 |  |  |  |  | Valuation Date:
 |  |  |  |  | Discount Rate:
Spreadsheet: 672657d1586952447-overtime-formula-matrix-beamernsw-
Sheet: PROD Costs

Production - Event Costs
PROD
Category (DROPDOWN) | Estimated Amount (Net of VAT) | Item detail | Company | Date (if known) | Invoice Number (if known) | Actual charge to CCA | Absorbed Costs | Profit (recharged costs only) | Percentage
Audio |  |  |  |  |  |  |  |  | 0.1
Scoreboard |  |  |  |  |  |  |  |  | 0.1
Video Control |  |  |  |  |  |  |  |  | 0.1
[NAME] |  |  |  |  |  |  |  |  | 0.1
Rigging |  |  |  |  |  |  |  |  | 0.1
Technical Crew & Labour |  |  |  |  |  |  |  |  | 0.1
Spreadsheet: 672661d1586953093-overtime-formula-matrix_formula
Sheet: Cost Matrix

 | EVENT ESTIMATION COST MATRIX
 | Position | Company | Date | Start Time | End Time | Hr | Total Hr | Overtime | Cost / Hr | Qty | Total |  | Doors Open | 14:00:00
 | Medic Service |  |  |  |  |  |  |  |  | 1 |  |  | Show Start | 12:00:00
 | Medical Director |  |  |  |  |  |  |  |  | 1 |  |  | Show End | 19:00:00
 | Crew |  |  |  |  |  |  |  |  | 1
 | Ambulance |  |  |  |  |  |  |  |  | 1 |  |  | Position | Cost | Company | Start | Finish | Start details | End details | Overtime | Column1 | Overtime Cost
 | Parking Supervisor |  |  |  |  |  |  |  |  | 1 |  |  | Crew Chief | 50 | [NAME] |  |  | 05:00:00 | 01:00:00
 | Crew |  |  |  |  |  |  |  |  | 2 |  |  | Crew | 40 | [NAME] |  |  | 01:00:00 | 01:00:00
 | Parking Supervisor |  |  |  |  |  |  |  |  | 1 |  |  | Medical Director | 1500 | GMC Clinic |  |  | 03:00:00 | 01:00:00 | 08:00:00 |  | 150
 |  |  |  |  |  |  |  |  |  |  |  |  | Medic Service | 800 | GMC Clinic |  |  | 03:00:00 | 01:00:00 | 08:00:00 |  | 100
 |  |  |  |  |  |  |  |  |  |  |  |  | Ambulance | 400 | GMC Clinic |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Parking Supervisor | 60 | [NAME] |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Parking Marshal | 55 | [NAME] |  |  | 01:00:00 | 01:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | Company | Role | Total
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Event Crew
 |  |  |  |  |  |  |  |  |  |  |  |  | GMC Clinic | Medical
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Parking Marshals
Spreadsheet: 586314d1534315567-pivot-tables-and-relationships-pivots
Sheet: Sheet1

ID | Name |  |  | ID | TicketPrice
1 | Name1 |  |  | 1 | 10
2 | [NAME] |  |  | 2 | 20
3 | Name3 |  |  | 3 | 30
4 | Name4 |  |  | 4 | 40
5 | Name5 |  |  | 5 | 50
6 | Name6
Spreadsheet: 882242d1730519822-compare-2-different-lists-and-create-a-new-table-with-the-data-test
Sheet: Compair2

year | code | Size | Desc | Qty | Amt |  |  |  |  |  |  |  |  | Unique | Desc | Code | 2023 | 2023 | 2024 | 2024
2023 | 1 | Pr1 | TSHIRT | 1 | 32.99 |  |  |  |  |  |  |  |  |  |  | 6
2023 | 1 | Pr2 | DRESS | 1 | 31.63
2023 | 1 | Pr3 | [NAME] | 1 | 11.81
2023 | 1 | Pr4 | SOCKS | 2 | 3.13
2023 | 1 | Pr5 | SHOES | 2 | 1.73
2023 | 2 | Pr6 | TSHIRT | 2 | 60.28
2023 | 2 | Pr7 | SHOES | 1 | 26.84
2023 | 3 | Pr5 | SOCKS | 2 | 60.41
2023 | 4 | Pr4 | TSHIRT | 1 | 24.4
2023 | 4 | Pr6 | [NAME] | 2 | 62.62
2023 | 5 | Pr3 | [NAME] | 6 | 205.67
2023 | 5 | Pr8 | SOCKS | 3 | 141.69
2023 | 5 | Pr7 | TSHIRT | 6 | 10.2
2023 | 5 | Pr1 | SHOES | 6 | 11.4
2023 | 6 | Pr2 | TSHIRT | 8 | 553.11
2023 | 6 | Pr10 | DRESS | 2 | 140.02
2023 | 6 | Pr4 | [NAME] | 4 | 189
2023 | 6 | Pr3 | SOCKS | 1 | 47.46
2023 | 6 | Pr5 | DRESS | 1 | 33.29
2023 | 6 | Pr2 | TSHIRT | 2 | 14.42
year | code | Size | Desc | Qty | Amt
2024 | 4 | Pr4 | SOCKS | 3 | 103.2
2024 | 4 | Pr7 | SHOES | 3 | 102.33
2024 | 5 | Pr1 | TSHIRT | 2 | 69.4
2024 | 5 | Pr8 | DRESS | 7 | 325.59
2024 | 5 | Pr7 | [NAME] | 3 | 116.71
2024 | 6 | Pr2 | SOCKS | 1 | 51.47
2024 | 6 | Pr4 | TSHIRT | 1 | 60.12
2024 | 6 | Pr7 | DRESS | 2 | 139.27
2024 | 6 | Pr6 | SOCKS | 1 | 52.21
2024 | 7 | Pr5 | TSHIRT | 1 | 34.05
2024 | 8 | Pr1 | DRESS | 2 | 27.89
Spreadsheet: 695452d1600222659-need-help-to-loop-a-statement-to-shorten-code-test-loop
Sheet: Table2

Number | 0 | 3 | 6 | 9 | 12 | 15 | 18 | 21 | 24 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48 | 51 | 54 | 57 | 60 | 63 | 66 | 69 | 72 | 75 | 78 | 81 | 84 | 87 | 90 | 93 | 96 | 99 | 102 | 105 | 108 | 111 | 114 | 117 | 120 | 123 | 126 | 129 | 132 | 135 | 138 | 141 | 144 | 147 | 150 | 153 | 156 | 159 | 162 | 165 | 168 | 171 | 174 | 177 | 180 | 183 | 186 | 189 | 192 | 195 | 198 | 201 | 204 | 207 | 210 | 213 | 216 | 219 | 222 | 225 | 228 | 231
101010405120W300 | 429 | 432 | 435 | 438 | 441 | 444 | 447 | 450 | 453 | 456 | 459 | 462 | 465 | 468 | 471 | 474 | 477 | 480 | 483 | 486 | 489 | 492 | 495 | 498 | 501 | 504 | 507 | 510 | 513 | 516 | 519 | 522 | 525 | 528 | 531 | 534 | 537 | 540 | 543 | 546 | 549 | 552 | 555 | 558 | 561 | 564 | 567 | 570 | 573 | 576 | 579 | 582 | 585 | 588 | 591 | 594 | 597 | 600 | 603 | 606 | 609 | 612 | 615 | 618 | 621 | 624 | 627 | 630 | 633 | 636 | 639 | 642 | 645 | 648 | 651 | 654 | 657 | 660
101021105020W300 | 414 | 417 | 420 | 423 | 426 | 429 | 432 | 435 | 438 | 441 | 444 | 447 | 450 | 453 | 456 | 459 | 462 | 465 | 468 | 471 | 474 | 477 | 480 | 483 | 486 | 489 | 492 | 495 | 498 | 501 | 504 | 507 | 510 | 513 | 516 | 519 | 522 | 525 | 528 | 531 | 534 | 537 | 540 | 543 | 546 | 549 | 552 | 555 | 558 | 561 | 564 | 567 | 570 | 573 | 576 | 579 | 582 | 585 | 588 | 591 | 594 | 597 | 600 | 603 | 606 | 609 | 612 | 615 | 618 | 621 | 624 | 627 | 630 | 633 | 636 | 639 | 642 | 645
Spreadsheet: 599181d1542888304-help-lookup-function-to-reconcile-receipts-against-bank-transactions-test-reconcille
Sheet: Bank Transactions

Column3 | Column4 | Name | Money In | Money Out | Account Number
130 | 2017-11-10 00:00:00 | [NAME] |  | 130 | 1
130 | 2016-03-05 00:00:00 | Frankies |  | 130 | 3
47 | 2018-09-08 00:00:00 | Guitar |  | 47 | 4
5 | 2016-11-07 00:00:00 | Bike |  | 5 | 3
10 | 30/2/16 | Bus |  | 10 | 1
Spreadsheet: 93832d1293620561-conditional-formatting-using-ifs-help-please-gwynemark_sample-1-
Sheet: Sheet1

Planned Closure Date | Status of Corrective Action |  |  |  |  |  |  |  | Planned Closure Date | Status of Corrective Action
2010-11-15 00:00:00 | Open | 44 |  | 1) I would like column A to color code the cells in RED if the date is greater than 30 days from today and the Status (column B) is "open" |  |  |  |  | 2010-11-15 00:00:00 | Open
2010-12-01 00:00:00 | Open | 28 |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-12-10 00:00:00 | Closed | 19 |  |  |  |  |  |  | 2010-12-10 00:00:00 | Closed
2010-08-11 00:00:00 | Closed | 140 |  |  |  |  |  |  | 2010-08-11 00:00:00 | Closed
2010-09-11 00:00:00 | Closed | 109 |  |  |  |  |  |  | 2010-09-11 00:00:00 | Closed
2010-10-04 00:00:00 | Open | 86 |  |  |  |  |  |  | 2010-10-04 00:00:00 | Open
2010-12-01 00:00:00 | Open | 28 |  | 2) If possible, I would also like to color code the cell YELLOW if the date is within 30 days of today and the status (column B) is "open" |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-12-01 00:00:00 | Closed | 28 |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-06-15 00:00:00 | Open | 197 |  |  |  |  |  |  | 2010-06-15 00:00:00 | Open
2010-06-15 00:00:00 | Closed | 197 |  |  |  |  |  |  | 2010-06-15 00:00:00 | Closed
2010-08-17 00:00:00 | Closed | 134 |  |  |  |  |  |  | 2010-08-17 00:00:00 | Closed
2010-12-28 00:00:00 | Open | 1 |  |  |  |  |  |  | 2010-12-28 00:00:00 | Open
2010-12-01 00:00:00 | Closed | 28 |  | It should look like this to the right but done automatically. |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open | 28 |  |  |  |  |  |  | 2011-01-15 00:00:00 | Open
2010-12-01 00:00:00 | Closed | 28 |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Closed | 28 |  |  |  |  |  |  | 2010-12-01 00:00:00 | Closed
2010-12-01 00:00:00 | Open | 28 |  |  |  |  |  |  | 2010-12-01 00:00:00 | Open
2010-11-27 00:00:00 | Open | 32 |  |  |  |  |  |  | 2010-11-27 00:00:00 | Open
2010-11-26 00:00:00 | Closed | 33 |  |  |  |  |  |  | 2010-11-26 00:00:00 | Closed
2010-12-27 00:00:00 | Open | 2
2011-01-03 00:00:00 | Open | -5
2011-01-10 00:00:00 | Open | -12
2011-01-17 00:00:00 | Closed | -19
2011-01-24 00:00:00 | Open | -26
2011-01-31 00:00:00 | Open | -33
2011-02-07 00:00:00 | Open | -40
2011-02-14 00:00:00 | Open | -47
2011-02-21 00:00:00 | Open | -54
2011-02-28 00:00:00 | Open | -61
Spreadsheet: 328610d1403974225-vlookup-not-working-in-certain-column-but-works-in-others-test-invoice
Sheet: Customer list

Customer Name | Phone | Address |  |  |  |  | City, State ZIP
Commercial
CCRT |  | 1325 15th st |  |  |  |  | West Des Moines, IA
[NAME] |  | 23 eagle grove
Physicians Eye Clinic |  | 8974 s 1st St |  |  |  |  | West Des Moines, IA 50265
Anglo International |  | 5456 110th st |  |  |  |  | Clive, IA 50325
[NAME] |  | 3543 burr pointe |  |  |  |  | [NAME], IA 50263
Residential | Phone | Address |  |  |  |  | City, State ZIP
[NAME] | [PHONE] | 4815 S 15th |  |  |  |  | Des Moines, IA 50321
heather | [PHONE] | 16345 nw wilblin dr |  |  |  |  | Urbandale, IA 50323
carey | [PHONE] | 243 oaks point |  |  |  |  | West Des Moines, IA 50266
[NAME] | [PHONE] | 3232 braiar dr |  |  |  |  | West Des Moines, IA 50266
[NAME] | [PHONE] | 34 s 125th st |  |  |  |  | West Des Moines, IA 50266
[NAME] | [PHONE] | 5323 pine court |  |  |  |  | Clive, IA 50325
[NAME] | [PHONE] | 235 burr oak st |  |  |  |  | Clive, IA 50325
sue | [PHONE] | 2333 s 1st st |  |  |  |  | Clive, IA 50325
[NAME] | [PHONE] | 5566 new pointe drive |  |  |  |  | Clive, IA 50325
Spreadsheet: 797314d1663821294-lookup-data-on-another-sheet-by-matching-data-in-two-columns-acl-hamakua
Sheet: report

D A I L Y   L A B O R   R E P O R T
DISTRICT: |  | SOUTH HILO |  |  |  |  |  |  |  |  |  |  |  |  |  | DATE: | 2021-06-14 00:00:00
FOREMAN: |  | Nishijima, [NAME] |  |  |  | R/M HIGHWAY |  | X |  |  | OTHER |  |  |  |  | APPROVED:
 |  |  |  |  |  |  |  |  |  |  | W.O. #
L A B O R |  |  |  |  |  |  |  |  |  |  | E Q U I P M E N T (County & Rental)
HC NO | PAY | NAME |  |  | AREA | JOB | HOURS | HRLY | AMOUNT |  | CH NO. | HOURS | HRLY | EQUIP | REMARKS
 | CODE |  |  |  | CODE | CODE |  | RATE |  |  |  |  | RATE | COST
1112 |  |  |  |  | b2 | 210 | 8 |  |  |  | [NAME] | 8
M A T E R I A L S  &  S U P P L I E S |  |  |  |  |  |  |  |  |  |  | J O B  C O S T  SUMMARY
QTY | ITEMS |  |  |  |  | AREA                  CODE | JOB          CODE | UNIT | AMOUNT |  | AREA | JOB | HRS |  |  | M/S | C/S | TOTAL
 |  |  |  |  |  |  |  | COST |  |  | CODE | CODE |  | LABOR | EQUIP
 |  |  |  |  |  |  |  |  |  |  | B2 | 210
 |  |  |  |  |  |  |  |  |  |  | GRAND TOTAL
Spreadsheet: kate_symes__18078__sept graph
Sheet: Sheet1

 | LTCA |  |  | LTNW |  |  | LTSW |  |  | STCA |  |  | STNW |  |  | STSW |  |  | STWHRLY
 | Deal Control | Vol. [NAME] |  | Deal Control | Vol. [NAME] |  | Deal Control | Vol. [NAME] |  | Deal Control | Vol. [NAME] |  | Deal Control | Vol. [NAME] |  | Deal Control | Vol. [NAME] |  | Houston Discrepancies | Vol. [NAME]
June | 7 |  | June | 36 |  | June | 10 |  | June | 23 |  | June | 11 |  | June | 12 |  | June | 5
July | 10 |  | July | 34 |  | July | 4 |  | July | 35 |  | July | 9 |  | July | 6 |  | July | 0
Aug | 3 |  | Aug | 53 |  | Aug | 18 |  | Aug | 31 |  | Aug | 8 |  | Aug | 9 |  | Aug | 1
sept | 3 |  | Sept | 28 |  | Sept | 10 |  | Sept | 19 |  | Sept | 15 |  | Sept | 17 |  | Sept | 5
Spreadsheet: 189717d1351291490-divide-and-distribute-costs-to-multiple-participants-based-on-individual-amount-owed-vacation-cost-calculator
Sheet: VACATION

ê   Please Pay    è | Family1 | Family2 | Family3 | Family4 | Family5 | Family6 | Family7 | Family8 | Family9 | Family10
Family1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Family10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Paid | 300 | 0 | 0 | 0 | 1700 | 50 | 0 | 125 | 0 | 275 | 2450 | Total Spent
Family Members at Parker | 1 | 0 | 0 | 0 | 2 | 2 | 2 | 2 | 2 | 4 | 15 | Total Vacationers
Family Days at Parker | 1 | 0 | 0 | 0 | 4 | 4 | 3 | 2 | 3 | 8 | 25 | Total Family Days
Cost Per Family | 98 | 0 | 0 | 0 | 392 | 392 | 294 | 196 | 294 | 784 | 98 | Daily Cost per [NAME]
Due (Owed) | -202 | 0 | 0 | 0 | -1308 | 342 | 294 | 71 | 294 | 509 | 0
 |  |  |  |  |  |  |  |  |  |  | 2450
Spreadsheet: 860756d1708734737-want-a-drop-down-menu-to-format-group-of-cells-from-a-reference-sheet-formatting-help
Sheet: 3

 |  | 1 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | 3 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | 3 |  |  | NA | NA
 |  | 4 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | 3 |  |  | NA | NA
 |  | 4 |  |  | NA | NA
 |  | 5 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | 3 |  |  | NA | NA
 |  | 4 |  |  | NA | NA
 |  | 5 |  |  | NA | NA
 |  | 6 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 |  |  | NA | NA
 |  | 2 |  |  | NA | NA
 |  | 3 |  |  | NA | NA
 |  | 4 |  |  | NA | NA
 |  | 5 |  |  | NA | NA
 |  | 6 |  |  | NA | NA
 |  | 7 |  |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 | CD |  | NA | NA
 |  | 2 | CD |  | NA | NA
 |  | 3 | CD |  | NA | NA
 |  | 4 | CD |  | NA | NA
 |  | 5 | CD |  | NA | NA
 |  | 6 | CD |  | NA | NA
 |  | 7 | CD |  | NA | NA
 |  | 8 | CD |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 | CD |  | NA | NA
 |  | 2 | CD |  | NA | NA
 |  | 3 | CD |  | NA | NA
 |  | 4 | CD |  | NA | NA
 |  | 5 | CD |  | NA | NA
 |  | 6 | CD |  | NA | NA
 |  | 7 | CD |  | NA | NA
 |  | 8 | CD |  | NA | NA
 |  | 9 | CD |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 | CD |  | NA | NA
 |  | 2 | CD |  | NA | NA
 |  | 3 | CD |  | NA | NA
 |  | 4 | CD |  | NA | NA
 |  | 5 | CD |  | NA | NA
 |  | 6 | CD |  | NA | NA
 |  | 7 | CD |  | NA | NA
 |  | 8 | CD |  | NA | NA
 |  | 9 | CD |  | NA | NA
 |  | 10 | CD |  | NA | NA
 |  | TOTAL | - | -
 |  | 1 | EDS |  | NA | NA
 |  | 2 | EDS |  | NA | NA
 |  | 3 | EDS |  | NA | NA
 |  | 4 | EDS |  | NA | NA
 |  | 5 | EDS |  | NA | NA
 |  | 6 | EDS |  | NA | NA
 |  | 7 | EDS |  | NA | NA
 |  | 8 | EDS |  | NA | NA
 |  | 9 | EDS |  | NA | NA
 |  | 10 | EDS |  | NA | NA
 |  | 11 | EDS |  | NA | NA
 |  | TOTAL | - | -
Spreadsheet: 107221d1304435156-excel-2007-scatter-plot-plotting-one-variable-against-another-variable-my_data_scatterplot
Sheet: data

years | 10-19 | 20-29 | 30-39 | 40-49
30 | 4
40 | 8 |  | 1
50 | 6 | 2 | 3
60 | 6 | 9 | 2 | 3
70 | 4 | 6
80 | 4 | 3 | 3
Spreadsheet: 131979d1323427772-logic-query-with-nested-if-or-statements-and-final-yez-sample
Sheet: Pre.Post Accom

 | Pre-tour Accommodation in Amsterdam |  |  |  |  |  | Post-tour Accommodation in Amsterdam
 | Tour code |  | Date tour starts |  | Room Type |  | Tour code |  | Date tour ends |  | Room Type
 | Name |  | # of nights | Pax arrives at hotel |  |  | Name |  | # of nights | Pax departs hotel
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: 739515d1625754621-index-match-or-other-formula-to-copy-cells-until-next-value-example
Sheet: Sheet1

PROJECTNUMBER | ItemNumber | ItemDescription/ProjectLocation | Date | Unit/Quantity | Engr.EST. | AverageBid | AwardedBid
 | 20100000 | Clear and [NAME] |  | LUMPSUM | =============== | ================ | ================
FSA0253262 |  | Job 1 | 2011-01-01 00:00:00 | 1 | 15000 | 30509 | 20000
FSA0341097 |  | Job 2 | 2011-01-01 00:00:00 | 1 | 7500 | 30000 | 30000
NHPP0343041 |  | Job 3 | 2011-01-01 00:00:00 | 1 | 12500 | 55801.76 | 13596
 | 20100001 | Clear and [NAME] |  | Acre | ================ | ================ | ================
[NAME] |  | Job 1 | 2011-01-01 00:00:00 | 4 | 6250 | 21150 | 18300
NHPP0171105 |  | Job 2 | 2011-01-01 00:00:00 | 157 | 1000 | 820.85 | 957.54
STR2871038 |  | Job 3 | 2011-01-01 00:00:00 | 13 | 8000 | 1602.61 | 1010.53
 | 20100005 | Rem of Debris |  | LUMP SUM | =============== | ================ | ================
NHPP0343041 |  | Job 1 | 2011-01-01 00:00:00 | 1 | 5000 | 13834.15 | 23656
NHPP 0852116 |  | Job 2 | 2011-01-01 00:00:00 | 1 | 15000 | 27500 | 25000