tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 126e1ff5-54ed-4186-a213-f5a9349645c0
Sheet: T53

الجدول 53: مجموع الوفيات المسجلة  2000-2010
Table 53: Registered total deaths, 2000-2010
Country | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | البلد
Bahrain | 2045 | 1979 | 2035 | 2114 | 2215 | 2222 | 2317 | 2270 | … | … | … | البحرين
Egypt | 404699 | 404531 | 424034 | 440149 | 440790 | 450646 | 451863 | 450596 | 461934 | … | … | مصر
Iraq | 179928 | 77727 | 85758 | 95935 | 101820 | 115775 | 211757 | 137685 | 130257 | … | … | العراق
Jordan | 13339 | 16164 | 17220 | 16937 | 17011 | 17883 | 20397 | 20924 | 19403 | 20759 | 22662 | الأردن
Kuwait | 4227 | 4364 | 4342 | 4424 | 4793 | 4784 | 5247 | 5293 | 5701 | 6266 | … | الكويت
Lebanon | 19435 | 17568 | 17294 | 17187 | 17774 | 18012 | 18787 | 21092 | 21048 | 22260 | 22926 | لبنان
Oman | 2547 | 2550 | 2564 | 2701 | 2743 | 2849 | 5814 | 6210 | 7415 | 7098 | … | عمان
Palestine | 9041 | 9177 | 10316 | 10207 | 10029 | 9645 | 9938 | 10203 | … | … | … | فلسطين
Qatar | 1173 | 1210 | 1220 | 1311 | 1341 | 1545 | 1750 | 1776 | 1942 | 2008 | 1970 | قطر
Saudi Arabia | 86291 | 87500 | 88728 | 89976 | 91243 | 92487 | 93752 | 95166 | 96641 | 98289 | … | المملكة العربية السعودية
Sudan | ... | ... | ... | ... | ... | ... | ... | ... | … | … |  | السودان
Syrian Arab Republic | 50116 | 52214 | 53252 | 53778 | 57855 | 61132 | 59671 | 64303 | 76060 | 76650 | … | الجمهورية العربية السورية
United Arab Emirates | 5396 | 5777 | 5994 | 6002 | 6123 | 6361 | 6483 | 7414 | 7755 | 7788 | … | الإمارات العربية المتحدة
Yemen | 18441 | 19868 | 21162 | 20559 | 22225 | 19653 | 20607 | 24449 | 30463 | 31914 | … | اليمن
Spreadsheet: 017738a3-91fe-46a1-8de3-98c9e7ed4f0b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 8731.0 Building Approvals, Australia
 | TABLE 36. Value of Building Approved - Northern Territory
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Value of Approval ;  Northern Territory ;  Total residential building ;  New ; |  |  | Original | A420418X | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A420430R | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total residential building ;  Total (Type of work) ; |  |  | Original | A420442X | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total non-residential building ;  Total (Type of work) ; |  |  | Original | [NAME] | 1970-07-01 00:00:00 | 2010-10-01 00:00:00 | 484 | $'000 | FLOW | Month | 1
Value of Approval ;  Northern Territory ;  Total building ;  Total (Type of work) ; |  |  | Original | A422768K | 1973-07-01 00:00:00 | 2010-10-01 00:00:00 | 448 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 761963d1641316602-google-sheets-how-to-pull-row-numbers-from-different-sheets-based-on-date-solved-reddit-pls-help-sheet-2-
Sheet: Secondary

 | Date | width | length | unique ID | location | source
 | 2021-12-29 09:30:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-29 10:30:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-29 12:30:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-29 13:30:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-29 14:30:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-30 10:28:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-30 12:12:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-30 12:55:00 | 1.5 | 20 | 58048752 | 60 | 1CH2145033
 | 2021-12-30 14:02:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033
 | 2021-12-30 03:00:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033
 | 2021-12-31 06:45:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033
 | 2021-12-31 07:46:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033
 | 2021-12-31 08:47:00 | 1.5 | 20 | 1100028429 | 60 | 1CH2145033
 | 2022-01-01 09:16:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033
 | 2022-01-01 10:13:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033
 | 2022-01-01 07:46:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033
 | 2022-01-01 07:26:00 | 1.5 | 20 | 2425333 | 60 | 1CH2145033
Spreadsheet: geir_solberg__11251__5_16act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 77763d1278239719-extracting-data-test
Sheet: Sheet1

Password | Title | First Name | Last Name | Date of Birth | Address1 | Address2 | Address3 | Day Time Phone | Evening Phone | [NAME] | User Name | AboutMe | City | State | [NAME] | Country | Cellphone | User Type | Company | Description
 | Mr. | Stephen | [NAME] |  |  | ingol |  |  |  |  |  |  |  |  |  | UNITED KINGDOM
Spreadsheet: 84010d1284017989-average-over-a-text-range-using-a-vlookup-in-column-2nd-average
Sheet: grade Sheet

Please do not edit this sheet
…Grade | point
1C | 0.66
1B | 1
1A | 1.33
2C | 1.66
2B | 2
2A | 2.33
3C | 2.66
3B | 3
3A | 3.33
4C | 3.66
4B | 4
4A | 4.33
5C | 4.66
5B | 5
5A | 5.33
6C | 5.66
6B | 6
6A | 6.33
7C | 6.66
7B | 7
7A | 7.33
8C | 7.66
8B | 8
8A | 8.33
1 | 1
2 | 2
3 | 3
4 | 4
5 | 5
6 | 6
7 | 7
8 | 8
1c | 0.66
1b | 1
1a | 1.33
2c | 1.66
2b | 2
2a | 2.33
3c | 2.66
3b | 3
3a | 3.33
4c | 3.66
4b | 4
4a | 4.33
5c | 4.66
5b | 5
5a | 5.33
6c | 5.66
6b | 6
6a | 6.33
7c | 6.66
7b | 7
7a | 7.33
8c | 7.66
8b | 8
8a | 8.33
12 | 1.5
23 | 2.5
34 | 3.5
45 | 4.5
56 | 5.5
67 | 6.5
78 | 7.5
EP | 8.5
ep | 8.5
 | 0
* | 8
A* | 8
A*/A | 7.5
*A | 8
A | 7
AB | 6.5
A/B | 6.5
B | 6
BC | 5.5
B/C | 5.5
C | 5
CD | 4.5
C/D | 4.5
D | 4
DE | 3.5
D/E | 3.5
E | 3
EF | 2.5
E/F | 2.5
F | 2
FG | 1.5
F/G | 1.5
G | 1
GU | 0.5
G/U | 0.5
U | 0
a* | 8
*a | 8
a | 7
ab | 6.5
a/b | 6.5
b | 6
bc | 5.5
b/c | 5.5
c | 5
cd | 4.5
c/d | 4.5
d | 4
de | 3.5
d/e | 3.5
e | 3
ef | 2.5
e/f | 2.5
f | 2
fg | 1.5
f/g | 1.5
g | 1
[NAME] | 0.5
g/u | 0.5
u | 0
Internal Exam: A* | 8
Internal Exam: A*/A | 7.5
Internal Exam: *A | 8
Internal Exam: A | 7
Internal Exam: AB | 6.5
Internal Exam: A/B | 6.5
Internal Exam: B | 6
Internal Exam: BC | 5.5
Internal Exam: B/C | 5.5
Internal Exam: C | 5
Internal Exam: CD | 4.5
Internal Exam: C/D | 4.5
Internal Exam: D | 4
Internal Exam: DE | 3.5
Internal Exam: D/E | 3.5
Internal Exam: E | 3
Internal Exam: EF | 2.5
Internal Exam: E/F | 2.5
Internal Exam: F | 2
Internal Exam: FG | 1.5
Internal Exam: F/G | 1.5
Internal Exam: G | 1
Internal Exam: GU | 0.5
Internal Exam: G/U | 0.5
Internal Exam: U | 0
Internal Exam: NA | 0
* | 8
A | 7
B | 6
C | 5
D | 4
E | 3
F | 2
G | 1
U | 0
Spreadsheet: 811724d1672761698-full-time-part-time-differantiation-full-part-time-1-
Sheet: Sheet1

Mitarbeiterliste
Zimmermädchen / Roomboy
[NAME].Nr. | [NAME] | Name | Vorname | Personalnummer | Eintritt | Austritt | Kategorie | [NAME] per Week | Contract |  |  | Hours
1 | x |  | Mariola |  | 2020-05-26 00:00:00 | Unbefristet | Zimmermädchen |  | Fulltime |  | Fulltime | 48
2 | x |  | Ioan |  | 2020-05-26 00:00:00 | Unbefristet | Roomboy |  | Fulltime |  | Part Time | 20
3 | x |  | Ana |  | 2020-06-29 00:00:00 | Unbefristet | Zimmermädchen |  | Mini Job |  | Mini Job | 10
4 | x |  | Johlanta |  | 2020-07-20 00:00:00 | Unbefristet | Zimmermädchen |  | Part Time
5 | x |  | Urszula |  | 2020-07-08 00:00:00 | Unbefristet | Zimmermädchen |  | Fulltime
Spreadsheet: 712825d1610437203-how-to-calculate-daily-average-test
Sheet: Sheet2

Date | ID | Count | Y/N | Daily Average | Working Day | ID & Day Wise Avg. | Date Wise Total Sum |  | Manually Calculated
2021-01-01 00:00:00 | 1311 | 31.99999999999999 | No |  |  |  |  |  | Date | ID | Count | Y/N | Daily Average | Working Day | ID & Day Wise Avg. | Date Wise Total Sum | [NAME]. | [NAME]
2021-01-01 00:00:00 | PS1555 | 60.00000000000001 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | 1311 | 31.99999999999999 | No | 0
2021-01-01 00:00:00 | 1466 | 46.00000000000001 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | PS1555 | 60.00000000000001 | Yes
2021-01-01 00:00:00 | PS1558 | 44 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | 1466 | 46.00000000000001 | Yes
2021-01-02 00:00:00 | PS1555 | 57 | Yes |  |  |  |  |  | 2021-01-01 00:00:00 | PS1558 | 44 | Yes
2021-01-02 00:00:00 | PS1558 | 42 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | PS1555 | 57 | Yes
2021-01-02 00:00:00 | 1465 | 23 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | PS1558 | 42 | Yes
2021-01-03 00:00:00 | 1465 | 49 | Yes |  |  |  |  |  | 2021-01-02 00:00:00 | 1465 | 23 | Yes
2021-01-03 00:00:00 | PS1558 | 50.00000000000001 | Yes |  |  |  |  |  | 2021-01-03 00:00:00 | 1465 | 49 | Yes
2021-01-03 00:00:00 | PS1585 | 61 | Yes |  |  |  |  |  | 2021-01-03 00:00:00 | PS1558 | 50.00000000000001 | Yes
2021-01-03 00:00:00 | 705 | 6 | No |  |  |  |  |  | 2021-01-03 00:00:00 | PS1585 | 61 | Yes
 |  |  |  |  |  |  |  |  | 2021-01-03 00:00:00 | 705 | 6 | No | 0
 |  |  |  |  |  |  |  |  |  |  | *color just for better understanding
Spreadsheet: 07e8ab7d-c398-4d62-91b2-a154190d042f
Sheet: Parameters

LCC | Life Cycle Cost Parameters
PROJECT TITLE:
Location
Project Details:
Owner:
Occupier:
Prepared By:
DATES
Plan |  | Preparation date: |  |  |  |  | Indexing Base
Construction Cost |  | Base Date: |  |  |  |  | Start Date:
 |  | Date of Completion: |  |  |  |  | Date of Hand Over:
Maintenance |  | Start Date: |  |  |  |  | End Date:
Operation |  | Start Date: |  |  |  |  | End Date:
Occupancy |  | Start Date: |  |  |  |  | End Date:
End of Life |  | End Date: |  |  |  |  | Hand Back Liability Period:
Period of Analysis: |  |  | Unit of time: (w/m/year) |  |  |  | Total Asset Life Expectancy:
BASIS OF YEARS (eg. Calendar; financial year) – please state
PROCUREMENT DETAILS
Procurement Route:
Procurement Stage:
Tender Basis:
Market Conditions:
BUILDINGS ENVIRONMENTAL TARGET
Scheme |  |  | Target Score
Other Considerations
BASIS OF COST
Current Price |  |  | Discount Rate
Net Present Value |  |  | Escalation Rate
Escalation Rate |  |  | GIFA |  |  |  | 0
Spreadsheet: 701936d1603992935-sumproduct-with-multiple-criteria-and-slicers-incident-tracker-test-
Sheet: Lists

 | FY16 |  | JUL |  | Head |  | Contracting |  | Yes |  | Day |  | Less than Three Months
 | FY17 |  | AUG |  | Face |  | Fire Department |  | No |  | Night |  | Three to Eleven Months
 | FY18 |  | SEP |  | Neck |  | [NAME] |  |  |  |  |  | One to Five Years
 | FY19 |  | OCT |  | Eyes |  | Logistics |  |  |  |  |  | Over Five Years
 | FY20 |  | NOV |  | Back |  | Maintenance
 | FY21 |  | DEC |  | Shoulders |  | R&D
 | FY22 |  | JAN |  | Arms |  | Security
 | FY23 |  | FEB |  | Elbows
 | FY24 |  | MAR |  | Wrists
 | FY25 |  | APR |  | Hands / Fingers
 | FY26 |  | MAY |  | Trunk
 | FY27 |  | JUN |  | Knees
 |  |  | ALL |  | Multiple
 |  |  |  |  | Illness / Other
 |  |  |  |  | Ankles
 |  |  |  |  | Feet / Toes
Spreadsheet: 134987d1325740069-please-help-formula-to-return-a-value-within-a-range-book1
Sheet: Sheet1

 | Category | Rating |  | Benefit
 | 1 | 2 |  | Min | [NAME]
 | 2 | 1 |  | 1000 | 100000
 | 3 | 3 |  | Employee Benefit from performance
 | 4 | 4
 | 5 | 3
 | 6 | 3
 | 7 | 2
 | 9 | 1
 | 9 | 3
 | 10 | 2
 | 11 | 4
 | 12 | 5
 | Rating:
Spreadsheet: 1c079e99-bd23-4859-8156-0b6b79fc88ad
Sheet: Ancillary Items

 | Various Consumables
UOM | [NAME] | MANUFACTURER | PART NUMBER | PRICE
EA | [NAME] | Panduit | CPNEI | 2.611840000000001
EA | [NAME] White | Panduit | CPNIW | 2.611840000000001
EA | Jetline- PACK OF 6 ONLY | [NAME] | 607 | 138.0456
RL | [NAME] | Neptco | WP1250P | 249.914
EA | Fire Stop Putty | STI | SSP100 | 24.06600000000001
EA | 15' Velcro Roll | Panduit | HLS-15R0 | 19.39
EA | 75' Velcro Roll | Panduit | HLS-75R0 | 79.26800000000003
EA | B-Line 10' slot channel unistrut | B-Line | B22SH | 89.19680000000001
EA | [NAME] screw cover box | [NAME] | ASE8X8X4 | 12.1352
EA | PLP Mini-moray shield connector | Preformed Line Products | 8000745 | 3.203200000000001
EA | 8' ground rod (10 mil) | Anixter | 002942 | 12.88
BG | 11" Zip Ties | TE Connectivity | 1-604751-9 | 12.98528
BG | 7" Zip Ties | TE Connectivity | 1-604772-9 | 11.5808
BX | Saddle Clamps TM3S10-C | Panduit | TM3S10-C | 44.59
TB | Fire Stop Caulk | STI | SSS100 | 12.978
EA | [NAME] (1" or 1 1/2")-Box of 100 | B-Line | BR-24-4W | 199.7072
EA | Beam Clamp | Erico | BC | 89.01200000000001
EA | Innerduct (1" or 1 1/2") | Anixter | 180524 | 2.058
EA | 13' Comm Pole | Panduit | PCPA13R20IWY | 190.792
EA | 12' Comm Pole | Panduit | PCPA13R20IWY | 190.792
EA | 11' Power Pole | Panduit | PCPA11R20IWY | 157.36
EA | 10' Comm Pole | Panduit | PCPA11R20IWY | 157.36
EA | [NAME] (leather 5 pocket) | [NAME] | 0258-13 | 30.3688
EA | Palm Guard | TE Connectivity | 569949-1 | 2.226
FT | Coaxial cable (per foot) | Commscope | CS2279V | 0.92085
Spreadsheet: 79526747-de74-488e-aa19-4eeeefd88931
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
ALDR | Test | ALDR | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK  Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m. - 8 p.m., Saturday; 8 a.m. - 3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
ALDR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ALDR | Result | ALDR | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 15284-3 | Alnus [NAME].IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: kevin_hyatt__19599__Derailment_Summary
Sheet: Oct Train derailment vol.

Transwestern Pipeline Company
October 2000
Train Derailment - Volumes Calculation for Fuel
 |  | Prior Week |  | Actual Daily |  | Displaced
 |  | Average Daily |  | Commodity | Displaced | 4-Day Daily
 |  | [NAME] |  | [NAME] | [NAME] | Average
West  :
2000-10-30 00:00:00 |  | 1090 |  | 783.1
2000-10-31 00:00:00 |  | 1090 |  | 856.2
[NAME] to Blanco  :  636.4
2000-10-30 00:00:00 |  | 636.4 |  | 505.2
2000-10-31 00:00:00 |  | 636.4 |  | 543.1
San Juan to Thoreau
2000-10-30 00:00:00 |  |  |  |  | 120
2000-10-31 00:00:00 |  |  |  |  | 120
Thoreau to East ofThor.
2000-10-30 00:00:00 |  |  |  |  | 120
2000-10-31 00:00:00 |  |  |  |  | 120
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: MITS & TRITS Questionnaire

 |  | 2020-06-29 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Phase 1 | Undertake research on the advantages and disadvantages of three main options for coordinated specifications | 4200 |  |  | 0 | 4200
 | Phase 2A | Formulate framework for consultation with relevant stakeholders (to be confirmed with TCCS before proceeding to Phase 2B) | 5840 |  |  | 0 | 5840
 | Phase 2B | Produce questionnaires to be issued to local industry and the governance team | 3640 |  |  | 0 | 3640
 | Phase 3 | Collect and analyse responses and provide recommendations to TCCS | 6680 |  |  | 0 | 3340
 | Phase 4 | Presentation of results of survey and recommendations to the governance team | 840 |  |  | 0 | 0
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
 |  | 2020-11-25 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Phase 1 | Undertake research on the advantages and disadvantages of three main options for coordinated specifications | 4200 |  |  | 4200 | 0
 | Phase 2A | Formulate framework for consultation with relevant stakeholders (to be confirmed with TCCS before proceeding to Phase 2B) | 5840 |  |  | 5840 | 0
 | Phase 2B | Produce questionnaires to be issued to local industry and the governance team | 3640 |  |  | 3640 | 0
 | Phase 3 | Collect and analyse responses and provide recommendations to TCCS | 6680 |  |  | 3340 | 3340
 | Phase 4 | Presentation of results of survey and recommendations to the governance team | 840 |  |  | 0 | 840
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
 |  |  |  |  |  |  |  |  |  | governance team
 |  |  |  |  |  |  |  |  |  | TCCS
 |  |  |  |  |  |  |  |  |  | governance team
 |  |  |  |  |  |  |  |  |  | 840
 |  |  |  |  |  |  |  |  |  | Total (ex GST) $21,200
Spreadsheet: 216636d1361828659-adjacent-cell-reference-avoiding-duplicates-scott-sample-spreadsheet
Sheet: sheet 1

Column 1 | Column 2 | Column 6 | Column 12 | Column 13 | Column 15 | Column 17 | Column 19
 |  |  |  |  |  |  |  | This should be "86", the duplicate value prevents the pulling of adjacent cell
 |  |  |  |  |  |  |  | This should be "78", the duplicate value prevents the pulling of adjacent cell
 |  |  |  |  |  |  |  | FYI, I tried a couple of different formulas, the idea is to find the adjacent cell corresponding to the column 13 number, which finds the top 10 in that column.  Sometimes there will not be a duplicate and sometimes there could be 3 or more of the same numbers.
Spreadsheet: 95961d1295463359-bar-chart-chart1
Sheet: Chart

 |  |  |  |  |  |  |  | Base | Positive | Negative
 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  | 1 | 400 | 10 | 0
 |  |  |  |  |  |  | 2 | 410 | 20 | 0
 |  |  |  |  |  |  | 3 | 430 | 4 | 0
 |  |  |  |  |  |  | 4 | 434 | 1 | 0
 |  |  |  |  |  |  | 5 | 435 | 1 | 0
 |  |  |  |  |  |  | 2010 | 436
Spreadsheet: 42735d1241328911-solved-ignore-text-but-calculate-numbers-in-cells-jacks-gardening
Sheet: Sheet1

JACKS GARDENING                                                                                  PO BOX 1234                                                                                                                    ANYWHERE, WORLD |  |  | INVOICE # | 22009
 |  |  | SERVICE MONTH | YEAR
 |  |  | NOTE
[NAME]                                                                                          122333 S. ATKINS                                                                                           ANYWHERE, WORLD
QTY | [NAME] |  | UNIT PRICE | TOTAL
1 | LABOR (per hour)                                                             $50.00 |  |  | 50
2 | LABOR (per hour)                                                             $50.00 |  |  | 100
1 | LABOR (per hour)                                                             $50.00 |  |  | 50
1 | LABOR (per hour)                                                             $50.00 |  |  | 50
2 | LABOR (per hour)                                                             $50.00 |  |  | 100
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  |  | #N/A
 |  |  | SUBTOTAL | #N/A
 |  |  | TAX
 |  |  | TOTAL
1
2
3
4
5
6
7
8
9 | LABOR (per hour)                                                             $50.00
10
 |  |  | JANUARY | 2009
 |  |  | FEBRUARY | 2010
 |  |  | [NAME] | 2011
 |  |  | APRIL | 2012
 |  |  | MAY | 2013
 |  |  | [NAME] | 2014
 |  |  | JULY | 2015
 |  |  | AUGUST | 2016
THANK YOU |  |  | SEPTEMBER | 2017
THANK YOU FOR YOUR PAYMENT |  |  | OCTOBER | 2018
HAVE A GREAT HOLIDAY |  |  | NOVEMBER | 2019
PLEASE PAY PROMPTLY |  |  | DECEMBER | 2020
TO AVOID SERVICE INTERUPTION,                                                                          PLEASE PAY PROMPTLY
Spreadsheet: 132239d1323633204-extract-data-into-master-work-sheet-given-format
Sheet: SP-3

LOW FLOW SAMPLING
FIELD DATA SHEETS
 |  |  | Client:
 | Site:
 | Date: |  |  | 2011-11-18 00:00:00
 |  |  | Monitoring Well #: | SP-3 |  |  |  | Well Depth: | 15.97 |  | ft |  |  | Screened/Open Interval: | 10 |  | ft
 |  |  | Well Permit #: |  |  |  |  | Well Diameter: | 2 |  | inches
 | PID Readings (ppm)
 |  |  |  | Background: |  | 0 |  |  | Pump Intake Depth: |  |  | 8.5 |  |  | ft below TOC
 |  |  |  | [NAME]: |  | 0 |  |  |  |  |  |  | Depth to Water Before Pump Installation: | 3 |  | ft below TOC
 |  |  |  | Beneath Inner Cap: |  | 0 |  |  |  |  |  |  | [NAME] | stainless steel submersible pump
 | TIME | Purging | Sampling |  |  |  |  | Specific |  | Dissolved |  | Redox |  |  |  |  | Depth to
 |  |  |  | pH |  | Temperature |  | Conductivity |  | [NAME] |  | Potential |  | Turbidity |  | Pumping | Water
 |  |  |  | (pH units) |  | (oC) |  | (uS/cm) |  | (mg/L) |  | (mV) |  | (NTU) |  | Rate | (ft below
 |  |  |  | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | Reading | Change | (ml/min) | TOC)
 | 840 | x |  | 6.64 | NA | 13.48 | NA | 1278 | NA | 0.59 | NA | 66.7 | NA | 18.7 | NA | 410 | 3
 | 845 | x |  | 6.63 |  | 13.54 |  | 1277 |  | 0.57 |  | 69.9 |  | 15.1 |  | 410 | 3
 | 850 | x |  | 6.59 |  | 13.26 |  | 914 |  | 0.41 |  | 65.9 |  | 5.2 |  | 410 | 3
 | 855 | x |  | 6.59 |  | 13.27 |  | 899 |  | 0.39 |  | 57.2 |  | 2.73 |  | 410 | 3
 | 900 | x |  | 6.58 |  | 13.13 |  | 814 |  | 0.35 |  | 66.3 |  | 1.66 |  | 410 | 3
 | 905 | x |  | 6.57 |  | 13.08 |  | 809 |  | 0.34 |  | 64 |  | 1.72 |  | 410 | 3
 | 910 | x |  | 6.57 |  | 12.98 |  | 796 |  | 0.33 |  | 64.5 |  | 1.64 |  | 410 | 3
 | 915 |  | x | 6.56 |  | 12.77 |  | 745 |  | 0.28 |  | 60.4 |  | 1.22 |  | 410 | 3
 | Comments:
 |  | Purge start: |  |  | 08:36:00 |  |  | Sample time: |  | 09:12:00
 |  | Purge end: |  |  | 09:10:00
 | *INDICATOR PARAMETERS HAVE STABILIZED WHEN 3 CONSECUTIVE READINGS ARE WITHIN: + 0.1 for pH; + 3% for Specific Conductivity and
 | Temperature; + 10 mV for Redox Potential; and + 10% for [NAME] and Turbidity
Spreadsheet: 101588d1299689728-convert-horizontal-to-vertical-normalizinglist1
Sheet: Sheet1

DC | Type | DC$Type | 2011-01-08 00:00:00 | 2011-02-08 00:00:00 | 2011-03-08 00:00:00 | 2011-04-08 00:00:00
68225 | GrossSales | 68225$GrossSales | 450781 | 505799 | 525418 | 854186
42244 | GrossSales | 42244$GrossSales | 1082832 | 2045248 | 1966902 | 1479986
45239 | GrossSales | 45239$GrossSales | 973195 | 1626944 | 1210509 | 986249
68225 | Iincentives | 68225$Iincentives | 575963 | 1301511 | 1473719 | 1492196
42244 | Iincentives | 42244$Iincentives | 1001224 | 1051184 | 1247438 | 1244621
45239 | Iincentives | 45239$Iincentives | 844135 | 1229691 | 1038124 | 899851