tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: rick_buy__32763__SUMMARY
Sheet: summary

MARINER ENERGY, INC.
APPENDIX
WEEKLY DRILLING AND COMPLETION SUMMARY
 |  |  |  |  |  |  |  |  |  |  |  |  | PRESENT |  | PROPOSED
 |  |  | PROSPECT |  | AREA |  | WELL |  | E/D |  | [NAME] |  | DEPTH |  | TD |  | COMMENT
 | I. |  | WELLS CURRENTLY DRILLING
 |  |  | Green Canyon 136 |  | Deepwater |  | OCS-G 4508 #8 |  | D |  | 0.25 |  | 2,140' |  | 7,600' |  | Drilling.
 |  |  | (Shasta)
 | II. |  | WELLS REACHING TOTAL DEPTH, TESTING, OR TURNED TO SALES THIS WEEK
 |  |  | Green Canyon 472 |  | Deepwater |  | OCS-G #2 ST #1 |  | D |  | 0.5 |  | 11,484' |  | 11,625' |  | Completed.  WOPL.
 |  |  | (King Kong)
 |  |  | Green Canyon 473 |  | Deepwater |  | OCS-G #2 |  | D |  | 0.5 |  |  |  |  |  | Completing.
 |  |  | (King Kong)
 | III. |  | WELLS ANTICIPATED TO SPUD WITHIN 90 DAYS
 |  |  | None to report.
 | IV. |  | OTHER
 |  |  | None to report.
Spreadsheet: 695d63ee-e5f1-4b20-a0cc-b84a457c8172
Sheet: Sheet1

Colorectal [NAME], by County and Public Health District, Maine 2007- 2009 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Count | Crude Rate |  | Age-adjusted Rate
 |  | Rate | 95% CI | Rate | 95% CI
Maine | 2315 | 58.5 | 56.2 - 61.0 | 46.9 | 45.0 - 48.9
County
Androscoggin | 151 | 47.1 | 39.9 - 55.3 | 39.7 | 33.6 - 46.7
Aroostook | 186 | 86.4 | 74.4 - 99.7 | 60.6 | 52.1 - 70.3
Cumberland | 433 | 52 | 47.3 - 57.2 | 44.6 | 40.5 - 49.1
Franklin | 57 | 63.8 | 48.4 - 82.7 | 54.5 | 41.0 - 71.3
Hancock | 108 | 67.4 | 55.3 - 81.4 | 47 | 38.4 - 57.1
Kennebec | 213 | 58.7 | 51.1 - 67.1 | 47.1 | 40.9 - 54.0
Knox | 69 | 56.3 | 43.8 - 71.2 | 37.3 | 28.9 - 47.9
Lincoln | 65 | 62.4 | 48.1 - 79.5 | 40.9 | 31.4 - 52.9
Oxford | 101 | 59.6 | 48.5 - 72.4 | 46.6 | 37.8 - 56.9
[NAME] | 279 | 62.4 | 55.3 - 70.1 | 54.2 | 48.0 - 61.0
Piscataquis | 38 | 74.6 | 52.8 - 102.3 | 50.7 | 35.7 - 70.9
Sagadahoc | 56 | 51.1 | 38.6 - 66.3 | 41.1 | 30.8 - 53.8
Somerset | 73 | 47.5 | 37.2 - 59.7 | 38 | 29.7 - 48.1
[NAME] | 63 | 54.8 | 42.1 - 70.1 | 43.9 | 33.5 - 56.8
Washington | 82 | 84.2 | 67.0 - 104.5 | 58.1 | 45.9 - 72.8
York | 340 | 56.2 | 50.4 - 62.5 | 45.9 | 41.1 - 51.2
Public Health District
Aroostook | 186 | 86.4 | 74.4 - 99.7 | 60.6 | 52.1 - 70.3
Central | 286 | 55.4 | 49.1 - 62.2 | 44.4 | 39.4 - 50.0
Cumberland | 433 | 52 | 47.3 - 57.2 | 44.6 | 40.5 - 49.1
Downeast | 190 | 73.8 | 63.7 - 85.0 | 51.4 | 44.2 - 59.5
[NAME] | 253 | 56 | 49.4 - 63.4 | 40.9 | 35.9 - 46.4
Penquis | 317 | 63.6 | 56.8 - 71.0 | 53.8 | 48.0 - 60.1
Western | 309 | 53.4 | 47.6 - 59.7 | 43.8 | 39.0 - 49.1
York | 340 | 56.2 | 50.4 - 62.5 | 45.9 | 41.1 - 51.2
Data Source: Maine Cancer Registry, November 2011 NPCR data submission.
Count: Number of cases diagnosed with malignant cancer, based on county in which patient was residing at the time of diagnosis.
Colorectal Cancer: SEER cancer site recodes: 21041-21049,21051,21052 ( ICD-O-3 codes C180-C189,C260,C199,C209).
Rates are calculated using SEER*Stat Version 7.0.5.
Crude rates are new cases per 100,000 population.
Age-adjusted rates are new cases per 100,000 population age-adjusted to the U.S. 2000 standard population.
95% CI: 95% confidence interval of the rate.
Spreadsheet: 724802d1616398883-filter-data-with-a-summary-by-defining-dynamic-space-needed-rows-without-macros-vba-phase_cost_test
Sheet: test

 |  |  |  |  | SUM
 |  | INCL
 |  | OFFSET | 0
 |  | INCL |  |  |  |  |  |  | Phase 2 returns error since summary/filtered data is overlapping Phase 3
 |  | OFFSET
 |  | INCL
 |  | OFFSET
 |  | INCL
 |  | OFFSET
 |  | INCL
 |  | OFFSET
 |  |  |  | PHASES | CC1 | CC2 | CC3 | CC4 |  |  | EXCLUDING OPTIONAL | last character off | unique list w/out last character
 | Phase 1.A |  |  | Phase 1.A | 121 | 45 | 789 | 68 |  | Pha
 | Phase 1.B |  |  | Phase 1.B | 572 | 798 | 9 | 51 |  | opt | Phase 1.B |  | Phase 2.
 | Phase 1.C |  |  | Phase 1.B | 691 | 295 | 151 | 799 |  |  | Phase 2.A |  | Phase 3.
 | Phase 1.D |  |  |  | 339 | 510 | 33 | 56 |  |  | Phase 2.B |  | Phase 4.
 | Phase 2.A |  |  |  | 808 | 196 | 418 | 500 |  |  | Phase 2.C |  | #[NAME]!
 | Phase 2.B |  |  |  | 361 | 523 | 630 | 893 |  |  | Phase 2.D
 | Phase 2.C |  |  | Phase 2.A | 425 | 129 | 915 | 130 |  |  | Phase 3.A
 | Phase 2.D |  |  | Phase 2.A | 640 | 202 | 776 | 83 |  |  | Phase 3.B
 | Phase 3.A |  |  | Phase 2.B | 184 | 23 | 973 | 510 |  |  | Phase 4.A
 | Phase 3.B |  |  | Phase 2.B | 523 | 246 | 295 | 974 |  |  | Phase 4.C
 | Phase 3.C |  |  | Phase 2.C | 881 | 702 | 940 | 106
 | Phase 3.D |  |  | Phase 2.D | 636 | 95 | 825 | 277
 | Phase 4.A |  |  |  | 55 | 234 | 626 | 976
 | Phase 4.B |  |  | Phase 3.A | 97 | 693 | 364 | 149
 | Phase 4.C |  |  | Phase 3.A | 436 | 354 | 970 | 623
 | Phase 4.D |  |  | Phase 3.B | 110 | 178 | 965 | 261
 | Phase 5.A |  |  |  | 524 | 8 | 158 | 342
 | Phase 5.B |  |  |  | 201 | 691 | 756 | 333
 | Phase 5.C |  |  |  | 424 | 312 | 976 | 249
 | Phase 5.D |  |  | Phase 4.A | 292 | 337 | 644 | 986
 | Phase 6.A |  |  | Phase 4.C | 175 | 536 | 580 | 994
 | Phase 6.B |  |  | Phase 4.C | 682 | 697 | 547 | 267
 | Phase 6.C |  |  |  | 846 | 639 | 738 | 400
 | Phase 6.D |  |  |  | 799 | 847 | 631 | 639
 | Phase 7.A |  |  |  | 857 | 118 | 397 | 30
 | Phase 7.B |  |  |  | 736 | 527 | 581 | 233
 | Phase 7.C |  |  |  | 196 | 182 | 997 | 178
 | Phase 7.D |  |  |  | 155 | 970 | 695 | 908
 |  |  |  |  | 297 | 518 | 579 | 250
 |  |  |  |  | 119 | 104 | 437 | 70
 |  |  |  |  | 812 | 634 | 440 | 711
 |  |  |  |  | 21 | 96 | 197 | 749
 |  |  |  |  | 862 | 713 | 627 | 687
 |  |  |  |  | 899 | 875 | 217 | 806
Spreadsheet: 57287d1257398314-help-on-formula-multiple-worksheets-706059-help-on-formula-multiple-worksheets
Sheet: 0620 Reo Fixing

Project: |  |  |  |  |  |  |  |  |  | Claim No.: | 1
Building: |  |  |  |  |  |  |  |  |  | Proj No.:
Trade No / Trade Name | TP 0620 | [NAME] |  |  |  |  |  |  |  | Date Issued: | 2009-10-30 00:00:00
[NAME]
TP No:- | Subcontract / Supply No | Description |  | Subcontractor / Supplier | Original Contract Sum | Adjustment | Adjusted Contract Sum | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 5000 | 0 | 5000 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  |  |  |  | 0 |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 5000 | 0 | 5000 | 0 | 0 | 0 | 0
Variation / Claims
SCVO | Status | Description | Notification / Instruction # | Subcontractor / Supplier | Budget | Adjustment | Adjusted Budget | Approved Commitment | Completed to date | Previous Approved Value | Value this Claim
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  | 0 | 0 | 0 |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | Contract Works Sub-Total | 0 | 0 | 0 | 0 | 0 | 0 | 0
TP 0620 | [NAME] |  |  | NET TOTAL | 5000 | 0 | 5000 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  | Status
 |  |  |  |  |  |  | A | Approved
 |  |  |  |  |  |  | P | Submitted / Pending Approval
 |  |  |  |  |  |  | D | Disputed
 |  |  |  |  |  |  | R | Rejected
Spreadsheet: 224493d1364583387-combine-two-lists-dianaschar_911081-combine-two-lists_29mar13_01
Sheet: Sheet1

Credit? | Invoice # | Their Amount | Our Date | Account # | Our Amount | Offage | Subtotal
Spreadsheet: 111954d1308170580-vlookup-multiple-instances-of-lookup-value-super-vlookup2
Sheet: Sheet2

 | [NAME] | First name | Surname | Course |  | [NAME] | First name | Surname | Course
 | 27052825 | Matthews | [NAME] | NVQ in [NAME] |  | 27061733
 | 27061733 | [NAME] | Sindi | Key Skills in Application of Number - level 1 |  | 28056792
 | 28056792 | bob | [NAME] | NVQ in [NAME] |  | 28058793
 | 28058793 | [NAME] | [NAME] | Key Skills in Application of Number - level 1 |  | 28064165
 | 28064165 | Stevie | [NAME] | Key Skills in Application of Number - level 2 |  | 28070572
 | 28070572 | [NAME] | La | Key Skills in Application of Number - level 2 |  | 28070572
 | 28070572 | Nick | Davies | Key Skills in Application of Number - level 2 |  | 28071961
 | 27061733 | [NAME] | Sindi | Access |  | 27061733
 |  |  |  |  |  |  |  |  | J11 should read access
Spreadsheet: 270901d1381741779-is-there-a-way-to-display-the-week-that-a-date-falls-within-the-range-week-display
Sheet: Sheet2

Week Number | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13
Week Start And End Indicators | 1.1 | 1.2 | 2.1 | 2.2 | 3.1 | 3.2 | 4.1 | 4.2 | 5.1 | 5.2 | 6.1 | 6.2 | 7.1 | 7.2 | 8.1 | 8.2 | 9.1 | 9.2 | 10.1 | 10.2 | 11.1 | 11.2 | 12.1 | 12.2 | 13.1 | 13.2
 | 2013-09-15 00:00:00 | 2013-09-21 00:00:00 | 2013-09-22 00:00:00 | 2013-09-28 00:00:00 | 2013-09-29 00:00:00 | 2013-10-05 00:00:00 | 2013-10-06 00:00:00 | 2013-10-12 00:00:00 | 2013-10-13 00:00:00 | 2013-10-19 00:00:00 | 2013-10-20 00:00:00 | 2013-10-26 00:00:00 | 2013-10-27 00:00:00 | 2013-11-02 00:00:00 | 2013-11-03 00:00:00 | 2013-11-09 00:00:00 | 2013-11-10 00:00:00 | 2013-11-16 00:00:00 | 2013-11-17 00:00:00 | 2013-11-23 00:00:00 | 2013-11-24 00:00:00 | 2013-11-30 00:00:00 | 2013-12-01 00:00:00 | 2013-12-07 00:00:00 | 2013-12-08 00:00:00 | 2013-12-14 00:00:00
 | 2013-09-28 00:00:00 | 2013-10-04 00:00:00 | 2013-10-05 00:00:00 | 2013-10-11 00:00:00 | 2013-10-12 00:00:00 | 2013-10-18 00:00:00 | 2013-10-19 00:00:00 | 2013-10-25 00:00:00 | 2013-10-26 00:00:00 | 2013-11-01 00:00:00 | 2013-11-02 00:00:00 | 2013-11-08 00:00:00 | 2013-11-09 00:00:00 | 2013-11-15 00:00:00 | 2013-11-16 00:00:00 | 2013-11-22 00:00:00 | 2013-11-23 00:00:00 | 2013-11-29 00:00:00 | 2013-11-30 00:00:00 | 2013-12-06 00:00:00 | 2013-12-07 00:00:00 | 2013-12-13 00:00:00 | 2013-12-14 00:00:00 | 2013-12-20 00:00:00 | 2013-12-21 00:00:00 | 2013-12-27 00:00:00
Start Date | 2013-09-15 00:00:00 |  |  | I need cell B9 to display the week number that the current week falls in in reference to the start date selected in B7
Current Date
Week Number | 5
Spreadsheet: 72507d1273184539-if-statement-to-return-a-blank-with-other-multiple-conditions-book1
Sheet: Sheet1

Date | Multiplier | Long or Short | Entry Qty | Entry Price | [NAME] | Exit Price | P&L | Win / Loss / Scratch
2010-05-06 00:00:00 | 5 | L | 1 | 9945 | 1 | 9960
2010-05-06 00:00:00 | 5 | L | 1 | 9945 | 1 | 9930
2010-05-06 00:00:00 | 5 | L | 1 | 9945 | 1 | 9945
2010-05-06 00:00:00 | 5
Spreadsheet: 808158d1670329967-identifying-numbers-with-the-same-ending-numbers_same_ending
Sheet: Planilha1

 | 120 | 125 | 133 | 135 | 141 |  | 2 | 4 | 5
 | 111 | 121 | 132 | 134 | 150 |  |  |  | 1
 | 114 | 123 | 128 | 129 | 134 |  |  |  | 4
 |  |  |  |  |  |  | The numbers 125 and 135 finishes with 5
 |  |  |  |  |  |  | The column H and I should give me the position.
 |  |  |  |  |  |  | In this case, 125 is in position 2
 |  |  |  |  |  |  | and 135 is in position 4. There are 5 positions
 |  |  |  |  |  |  | The column J is showing me what is the number. In this case is number 5
Spreadsheet: 153643d1335984050-autofil-solutions-multi-row-count
Sheet: Sheet1

0 | 0 | 0 | 0 | 2 | 9 | 1 | 0 | 0
Spreadsheet: 699966d1602862667-need-help-with-nested-if-nested-if
Sheet: Lookups

Lookup Data |  |  |  | Values Set
Meaning | Value | Symbol |  | Actual Value | Symbol output | What I want it to be
P > 0.05 | 0.05 | Null |  | 0.05 |  | Null
P ≤ 0.05 | 0.05 | * |  | 0.05 |  | *
P ≤ 0.01 | 0.01 | ** |  | 0.01 |  | **
P ≤ 0.001 | 0.001 | *** |  | 0.001 |  | ***
P ≤ 0.0001 | 0.0001 | **** |  | 0.0001 |  | ****
 |  |  |  | 0.0497
 |  |  |  | 0.0098
 |  |  |  | 0.0514
 |  |  |  | 0.000297
 |  |  |  | 1.3e-05
Spreadsheet: 83424d1283409520-excel-2007-a-question-about-logic-and-looks-water10
Sheet: Input

2010-09-01 00:00:00
2010-09-01 00:00:00 | CASH |  |  |  | MEMBERSHIP
Transaction # | C25 | C45 | Credit | CC45 | M25 | Card # | M45 | Card #
1 | 5 |  |  |  | 15 | A001 | 10 | A002
2
3 |  |  |  |  |  |  |  |  |  |  |  | Daily Statistics |  |  |  | [NAME]:
4
5 |  |  |  |  |  |  |  |  |  |  | # 25c Gallons sold: |  |  | 20
6 |  |  |  |  |  |  |  |  |  |  | # 45c Gallons sold: |  |  | 10
7
8 |  |  |  |  |  |  |  |  |  |  | Total Gallons sold: |  |  | 30
9
10 |  |  |  |  |  |  |  |  |  |  | # Cash transactions: |  |  | 1
11 |  |  |  |  |  |  |  |  |  |  | # Membership transactions: |  |  | 2
12
13 |  |  |  |  |  |  |  |  |  |  | Daily dollar total: |  |  | 9.5
14 |  |  |  |  |  |  |  |  |  |  | (Tie this to the cash register)
15
16
17 |  |  |  |  |  |  |  |  |  |  | Daily Credit total: |  |  | 0
18
19 |  |  |  |  |  |  |  |  | 4
20
21
22
23
24
25
26
27
28
Total: | 5 | 0 | 0 |  | 15 |  | 10
Spreadsheet: lisa_gang__22285__ENA_PGE_MAY 2_2002
Sheet: LOSSES

From: | EPMI
To: | PGE System Transactions
Date: | 2002-05-02 00:00:00
HE
ENDING | TOTAL |  | TOTAL
Pacific
Prevailing
Time
(PPT)
0100 | 0
0200 | 0
0300 | 0
0400 | 0
0500 | 0
0600 | 0
0700 | 0
0800 | 0
0900 | 0
1000 | 0
1100 | 0
1200 | 0
1300 | 0
1400 | 0
1500 | 0
1600 | 0
1700 | 0
1800 | 0
1900 | 0
2000 | 0
2100 | 0
2200 | 0
2300 | 0
2400 | 0
 | PGE | PGE | PGE
 | REAL POWER LOSSES | PGE LOSSES | [NAME] [NAME]
 | PGE | PGE | PGE
 | 640902
 | 640903
 | NEW COLUMN
Spreadsheet: 38421d1236605356-countif-with-multiple-criteria-and-with-in-a-range-poker-stats-1
Sheet: Total Stats

Total Stats: | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd
ALL
45 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-7th
1.1
3.25
6.5
12
Totals:
90 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-12th
1.1
3.25
6.5
12
Totals:
180 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-9th
2.2
7.7
12
Totals:
Spreadsheet: 82372d1282393227-secondary-axis-with-pivot-tables-742546
Sheet: Sheet4

Sum of Rating |  | Gender
Category | Animal | Boy | Girl
Cave | [NAME] | 17 | 32
Desert | Camel | 15 | 32
 | Elephant | 17 | 29
 | Hyena | 16 | 29
 | Lion | 17 | 34
 | Zebra | 13 | 32
Forest | Bear | 20 | 35
 | Fox | 15 | 35
 | Moose | 17 | 32
 | Porcupines | 17 | 32
 | Raccoon | 17 | 33
 | [NAME] | 15 | 32
House | Cat | 18 | 32
 | Ferret | 17 | 34
 | Fish | 18 | 33
Jungle | Alligator | 17 | 32
 | Chimpanzee | 17 | 30
 | Gorilla | 12 | 33
 | Hippopotamus | 14 | 35
 | Lemur | 20 | 31
 | Panda | 17 | 31
 | Python | 16 | 33
 | Rhinoceros | 17 | 30
 | Tiger | 18 | 28
Ocean | Dolphin | 14 | 30
 | Manatee | 12 | 30
 | Penguin | 14 | 33
 | Sea Lion | 16 | 34
 | Sea Otter | 16 | 33
 | Walrus | 19 | 32
Pond | Frog | 16 | 28
 | Otter | 14 | 32
 | Turtle | 19 | 29
Sky | Condor | 23 | 31
 | Eagle | 16 | 28
 | Pelican | 16 | 29
Spreadsheet: 161155d1339431326-compare-three-columns-of-data-to-see-what-is-a-duplicate-and-what-is-not-vlookup-example
Sheet: Sheet1

All Forms | USED IN 2011? | USED IN 2012? |  | 2011 | 2012
FORM 1 |  |  |  | FORM 2 | FORM 1
FORM 2 |  |  |  | FORM 4 | FORM3
FORM 3 |  |  |  | FORM 5 | FORM 5
FORM 4 |  |  |  | FORM 6 | FORM 7
FORM 5 |  |  |  | FORM 7 | FORM 8
FORM 6 |  |  |  | FORM 8 | FORM 9
FORM 7 |  |  |  | FORM 9 | FORM 10
FORM 8 |  |  |  | FORM 10 | FORM 11
FORM 9 |  |  |  | FORM 12 | FORM 12
FORM 10 |  |  |  | FORM 14 | FORM 13
FORM 11 |  |  |  |  | FORM 14
FORM 12
FORM 13
FORM 14
Spreadsheet: 216207d1361641148-aggregating-timestamped-data-up-to-half-hourly-totals-minute-interval-example
Sheet: What I have

Timestamp | Data
2012-01-01 00:00:00 | 7
2012-01-01 00:01:00 | 8
2012-01-01 00:01:00 | 5
2012-01-01 00:03:00 | 5
2012-01-01 00:04:00 | 10
2012-01-01 00:05:00 | 10
2012-01-01 00:06:00 | 6
2012-01-01 00:07:00 | 7
2012-01-01 00:08:00 | 10
2012-01-01 00:09:00 | 10
2012-01-01 00:10:00 | 12
2012-01-01 00:11:00 | 12
2012-01-01 00:12:00 | 10
2012-01-01 00:13:00 | 10
2012-01-01 00:14:00 | 6
2012-01-01 00:15:00 | 9
2012-01-01 00:16:00 | 7
2012-01-01 00:17:00 | 7
2012-01-01 00:18:00 | 6
2012-01-01 00:19:00 | 11
2012-01-01 00:20:00 | 7
2012-01-01 00:21:00 | 11
2012-01-01 00:22:00 | 9
2012-01-01 00:23:00 | 6
2012-01-01 00:24:00 | 6
2012-01-01 00:25:00 | 12
2012-01-01 00:26:00 | 8
2012-01-01 00:27:00 | 12
2012-01-01 00:28:00 | 7
2012-01-01 00:29:00 | 10
2012-01-01 00:30:00 | 6
2012-01-01 00:31:00 | 12
2012-01-01 00:32:00 | 12
2012-01-01 00:33:00 | 8
2012-01-01 00:34:00 | 6
2012-01-01 00:35:00 | 10
2012-01-01 00:36:00 | 7
2012-01-01 00:37:00 | 11
2012-01-01 00:38:00 | 8
2012-01-01 00:39:00 | 5
2012-01-01 00:40:00 | 7
2012-01-01 00:41:00 | 8
2012-01-01 00:42:00 | 8
2012-01-01 00:43:00 | 8
2012-01-01 00:44:00 | 10
2012-01-01 00:45:00 | 8
2012-01-01 00:46:00 | 5
2012-01-01 00:47:00 | 9
2012-01-01 00:48:00 | 9
2012-01-01 00:49:00 | 8
2012-01-01 00:50:00 | 12
2012-01-01 00:51:00 | 6
2012-01-01 00:52:00 | 5
2012-01-01 00:53:00 | 10
2012-01-01 00:54:00 | 6
2012-01-01 00:55:00 | 9
2012-01-01 00:56:00 | 7
2012-01-01 00:57:00 | 6
2012-01-01 00:58:00 | 5
2012-01-01 00:59:00 | 10
… | …
… | …
Spreadsheet: 709331d1608251016-how-do-i-create-a-dynamic-table-from-another-tables-data-testing-file-v2
Sheet: Master

Project Name | Stauts | Unit | AM | PM | Total Budget | Contract Price | CR1 | CR2 | CR3 | CR4 | CR5 | CR6 | CR7 | CR8 | CR9 | CR10 | CR11 | CR12 | CR13 | CR14
Project A | Prospect | TS | EJ | ML |  | 18000 | 500
Project B | Active | TS | EJ | DW |  | 1000 | 501
Project C | Closed | TS | EJ | GR | 20000 | 500 | 502
Project D | Prospect | TS | EJ | TC | 25000 | 600 | 503
Project E | Active | TS | CR | GR |  | 40000 | 504
Project F | Closed | TS | CR | GR |  | 2000 | 505
Project G | Prospect | TS | CR | GR |  | 3000 | 506
Project H | Active | TS | ML | DW |  | 18000 | 507
Project I | Closed | TS | CR | TC |  | 18000 | 508
Project J | Prospect | TS | CR | AN |  | 20000 | 509
Project K | Active | TS | EJ | DW |  | 5000 | 510
Project L | Closed | TS | EJ | DW |  | 6000 | 511
Project M | Prospect | TS | EJ | GR |  | 960 | 512
Project N | Active | TS | EJ | GR |  | 7000 | 513
Project O | Closed | TS | CR | TC |  | 5900 | 514
Project P | Prospect | TS | ML | ML |  | 2000 | 515
Project Q | Active | TS | ML | ML |  | 950 | 516
Project R | Closed | TS | CR | AN |  | 3000
Project S | Prospect | TS | DW | DW |  | 7000 | 518
Project T | Active | TS | DW | DW |  | 6000 | 519
Spreadsheet: 44031d1242715647-need-help-dont-know-if-i-should-use-condiontional-formatting-or-macros-conditionalformat
Sheet: Revised Bill Due Dates

First Pay Period | [NAME]
Second Pay Period
 | 21st Century Mortgage | 15th | Second Pay Period
 | American Exp. ([NAME]) | 18th | Second Pay Period
 | American Exp. (jackie) | 18th | Second Pay Period
 | ATT | 13th | Second Pay Period
 | [NAME] | 22nd | Second Pay Period
 | BOA Visa | 16th | Second Pay Period
 | Best Buy | 18th | Second Pay Period |  |  |  | Pay Days
 | Cirro | 8th | Second Pay Period |  |  |  | 2009-04-09 00:00:00 | 2009-08-27 00:00:00
 | [NAME] | 9th | First Pay Period |  |  |  | 2009-04-23 00:00:00 | 2009-09-10 00:00:00
 | EnerBank | 15th | First Pay Period |  |  |  | 2009-05-07 00:00:00 | 2009-09-24 00:00:00
 | Care Credit | 18th | First Pay Period |  |  |  | 2009-05-21 00:00:00 | 2009-10-08 00:00:00
 | [NAME]'s | 20th | First Pay Period |  |  |  | 2009-06-04 00:00:00 | 2009-10-22 00:00:00
 | Star *3500 | 26th | First Pay Period |  |  |  | 2009-06-18 00:00:00 | 2009-11-05 00:00:00
 | Furniture Row | 25th | First Pay Period |  |  |  | 2009-07-02 00:00:00 | 2009-11-19 00:00:00
 | Sparkletts | 28th | First Pay Period |  |  |  | 2009-07-16 00:00:00 | 2009-12-03 00:00:00
 | Car/Prop. Insurance | 11th | First Pay Period |  |  |  | 2009-07-30 00:00:00 | 2009-12-17 00:00:00
 | USAA Mastercard | 12th | First Pay Period |  |  |  | 2009-08-13 00:00:00 | 2009-12-31 00:00:00
 | Utilities | 15th | First Pay Period
 | Verizon Wireless | 2nd | First Pay Period
 | Southern Cal. Gas | 20th | First Pay Period
 | [NAME]. [NAME] | 26th | First Pay Period
 | Time Warner | 1st | First Pay Period
 | Juniper | 12th | First Pay Period
 | First Pay Period
 | Second Pay Period
Spreadsheet: 817242d1676066718-identifying-independent-rows-and-taking-totals-for-those-rows-and-converting-and-addition-workingcopybyanalystcdnconversion1
Sheet: 1of12Analysts

[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Column1 | Price
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #[NAME]!
 |  |  | Type |  | Date | Future Use | Num | Future Use | Memo |  | Name |  | Item | Qty | Sales Price | Amount | Balance | CAD Equi | CAD Bal
 |  |  | Invoice |  | 2023-01-06 00:00:00 |  | 57993 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 2120
 |  |  | Invoice |  | 2023-01-06 00:00:00 |  | 57994 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 945
 |  |  | Invoice |  | 2023-01-10 00:00:00 |  | 58001 |  | Some Canadian Bank |  | This is also Filler |  | LIS-LRV | 1 | 550
 |  |  | Invoice |  | 2023-01-13 00:00:00 |  | 58006 |  | Some Canadian Bank |  | This is also Filler |  | LIS-LRV | 1 | 475
 |  |  | Invoice |  | 2023-01-13 00:00:00 |  | 58008 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 1665
 |  |  | Invoice |  | 2023-01-18 00:00:00 |  | 58027 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 2780
 |  |  | Invoice |  | 2023-01-19 00:00:00 |  | 58033 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 400
 |  |  | Invoice |  | 2023-01-24 00:00:00 |  | 58039 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 1665
 |  |  | Invoice |  | 2023-01-27 00:00:00 |  | 58058 |  | Some Canadian Bank |  | This is also Filler |  | LIS-LRV | 1 | 2160
 |  |  | Invoice |  | 2023-01-31 00:00:00 |  | 58071 |  | Some USA Bank |  | This is Just Filler |  | US LIS-LRV | 1 | 1665
 |  |  | Invoice |  | 2023-01-31 00:00:00 |  | 58078 |  | Some Canadian Bank |  | This is also Filler |  | LIS-LRV | 1 | 292.25
 |  |  | Invoice |  | 2023-01-31 00:00:00 |  | 58079 |  | Some Canadian Bank |  | This is also Filler |  | LIS-LRV | 1 | 542.75
Spreadsheet: 39078d1237295095-populate-a-cell-from-data-matched-from-3-other-worksheets-stock-inventory-sheet
Sheet: January 2009

Stock Inventory January 2009 | Stock List | Stock List | Stock List | Stock List | Stock List | Stock List | Stock List
[NAME] | Category | Description | Unit Price | Quantity in Stock | Total Value | Last Order Date | Notes
 | Desktop | HP DX2300 AMD | 237 | 30 | 7110
 | Laptop | HP 6735 AMD | 437 | 2 | 874
 | Cables | 3M Cat5 Cable | 4.33 | 10 | 43.3
 | Cables | 5M Cat5 Cable | 6.24 | 10 | 62.40000000000001
 | Cables | 10M Cat5 Cable | 8.88 | 5 | 44.40000000000001
 | Cables | 15M Cat5 Cable | 10.39 | 5 | 51.95
 | Power Accessories | 4 Way Power Extension | 6.48 | 5 | 32.40000000000001
 | Power Accessories | 6 Way Power Extension | 9.88 | 10 | 98.80000000000001
 | Keyboard | KB PS2 105 UK | 4 | 5 | 20
 | Keyboard | KB USB 105 UK | 4.5 | 10 | 45
 | Laptop Peripherals | Targus Carry Case | 19.5 | 2 | 39
 | Laptop Peripherals | Kingston USB 1GB Stick | 33 | 2 | 66