tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861385d1709250964-formatting-dates-dates
Sheet: Sheet1

DATE
3.4.24
3.4.24
3.4.24
3.4.24
3.6.24
3.6.24
3.6.24
3.6.24
3.11.24
3.11.24
3.11.24
3.11.24
3.11.24
3.13.24
3.13.24
3.13.24
3.13.24
3.18.24
3.18.24
3.18.24
3.18.24
3.18.24
3.20.24
3.20.24
3.20.24
3.20.24
3.25.4
3.25.24
3.25.24
3.27.24
3.27.24
3.27.24
3.27.24
4.8.24
4.8.24
4.10.24
4.10.28
4.13.24
4.13.24
4.17.24
4.17.24
4.29.24
5.13.24
5.13.24
5.29.24
6.3.24
6.3.24
6.5.24
6.17.24
Spreadsheet: 160221d1339010237-dependent-drop-down-list-wage-comparison-v1-modified-by-tigeravatar-
Sheet: Data Entry

 | = entry field, from lookup values
 | = automatically populated
 | = entry field
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURLY |  |  | TOTAL
Project | Desc | DO # | Subcontract | Sub | Week Ending | Worker's Name | 2008 Classification | Hours - S | Rate Paid | Hours - OT | Rate Paid | [NAME] | Amt Paid | 2011/2012 Wage Determination | 2011/2012 Classification | 2011/2012 Rate | 2011/2012 Fringe | OT Rate | 2011/2012 Wages | Net Difference
660000227 |  |  | 001 |  |  |  | Electrician | 8 | 15 | 4 | 22.5 | 4.5 |  | Building | [NAME]
660000201 |  |  | 005
Spreadsheet: 876306d1722987256-formula-to-multiply-cells-by-percentage-if-they-meet-2-conditions-if-and-formula-query-rev1
Sheet: Sheet1

 |  |  |  | 0.1 | 21 Enterprise
 |  |  |  | 0.2 | 22 Channar
 |  |  |  | 0.3 | 23 Lofty
1 | 21 Enterprise | 500 | 500 | 500
2 | 22 Channar | 700 | 700 | 700
3 | 23 Lofty | 900 | 900 | 900
4 | 21 Enterprise | 20 | 20 | 20
1 | 21 Enterprise |  |  | MULTIPLY C7 (no 1 ref in column A) BY 10% by looking up grey table "21 Enterprise"
2 | 22 Channar |  |  | MULTIPLY C8 (no 2 ref in column A) BY 20% by looking up grey table "22 Channar"
3 | 23 Lofty |  |  | MULTIPLY C9 (no 3 ref in column A) BY 30% by looking up grey table "23 Lofty"
4 | 21 Enterprise |  |  | MULTIPLY C10 (no 4 ref in column A) BY 10% by looking up grey table "21 Enterprise"
 |  | ^
 |  | Answer I want
Spreadsheet: 130588d1322477280-vlookup-december
Sheet: 31

 |  |  |  | 2011-12-31 00:00:00
Newspaper | Price | Quantity | Total
Value | 1.2 |  | 0
Value1 | 0.98 |  | 0
Value2 | 1.63 |  | 0
Value3 | 1.63 |  | 0
Value4 | 0.83 |  | 0
Value5 | 1.01 |  | 0
Value6 | 1.03 |  | 0
Value7 | 1.01 |  | 0
Value8 | 0.8 |  | 0
Value9 | 1.2 |  | 0
Value10 | 1.2 |  | 0
Value11 | 1.2 |  | 0
Total |  |  | 0
 | Grand Total |  | 0
Spreadsheet: 26ce8683-43c1-4646-981a-fc57bbdf349b
Sheet: SR_RTDRESP

Real Time Demand Response Report |  |  |  |  |  |  |  |  | Real Time Demand Response Report
SR_RTDRESP_<customer>_<date>_<version>.CSV |  |  |  |  |  |  |  |  | SR_RTDRESP_<customer>_<date>_<version>.CSV
<[NAME] |  |  |  |  |  |  |  |  | <[NAME]
Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT |  |  |  |  |  |  |  |  | Date: <mm/dd/yyyy> and Version: <mm/dd/yyyy hh:[NAME]:ss> GMT
 |  | [NAME] |  |  | Load |  | Demand Response |  | Price Response |  | Profiled Response |  | Charges
Trading Date | Trading Interval | Location Id | Location Name | Location Type | Participant Total Load Obligation | Pool Total Load Obligation | Participant Total Interrupted - Demand | Participant Total Pmt. - Demand | Participant Total Interrupted - Price | Participant Total Pmt. - Price | Participant Total Interrupted - Profiled | Participant Total Pmt. - Profiled | Pool Total Interrupted Energy Charge | Participant Total Interrupted Energy Charge
Date | Hour End | Number | String | String | MWh | MWh | MWh | $ | MWh | $ | MWh | $ | $ | $
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: ABC-CLIO

ABC-CLIO
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
[NAME]
Sessions | 104 | 22 | 274 | 478 | 415 | 127 | 73 | 259 | 259 | 234 | 70 | 50
Searches | 182 | 43 | 639 | 662 | 649 | 132 | 128 | 559 | 373 | 289 | 131 | 42 |  | 12248
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
HA Database
Sessions | 26 | 4 | 53 | 230 | 279 | 83 | 29 | 85 | 201 | 165 | 41 | 30
Searches | 26 | 5 | 74 | 300 | 381 | 100 | 30 | 94 | 214 | 163 | 44 | 41 |  | 0 | N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | For both:
Spreadsheet: louise_kitchen__22838__Hot List Update 5-18-01
Sheet: Offshore

Deal Description Sheet - 5/17/01
Production Offshore
YTD P & L | 3052000
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Shallow-Water | VanKirk & Riles | Shallow-water used platform and gathering line sale & lease/financing business with small to mid-sized E&P independents. | 500000 | 2001-05-10 00:00:00 | 0.1 | 2001-06-04 00:00:00 | Target client list being updated; potential deals w/McMoran, ATP, [NAME].  Joint marketing to begin in late May.  Working on proposal for [NAME].
Medusa | Murphy Oil | Deepwater infrastructure development.  PHASE I - Export Pipelines.  PHASE II - Floating Production System | 5000000 | 2001-05-02 00:00:00 | 0.2 | PHASE I - Jul-01  PHASE II - SEP-01 | Murphy claims to be negotiating an LOI with the Pipeline bid winner; public announcement in late May.  Murphy area study underway.  FPS re-bid in July.  FPS bid LOI negotiations in Sept-01.
Bridge | Callon Petroleum | Deferred Volumetric Production payment on Medusa and other deepwater reserves. | 500000 | 2001-05-11 00:00:00 | 0.1 | 2001-08-01 00:00:00 | Working with Enron Energy Capital Resources on joint bridge financing proposal for Callon.  Awaiting results of Callon's 5/14 Sr. note offering; will call.
Gunnison | Kerr McGee | Deepwater infrastructure development. | 5000000 | 2001-05-10 00:00:00 | 0.1 | 2001-09-01 00:00:00 | Well No. 3 is down; a sidetrack is currently being drilled by Kerr-McGee.  The data room will open in early June.  ENA will submit a bid in late June.
Llano | EEX | Deepwater infrastructure development. | 5000000 | 2001-04-17 00:00:00 | 0.1 | 2001-09-01 00:00:00 | Additional appraisal drilling to be completed in Q2.  Open data room and submit final proposal in Q3.
King Kong | Mariner | Deepwater flow-line. | 500000 | 2001-04-16 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Construction in progress; to be completed by 9/30.  Additional well to be drilled in June.  We have reviewed reserves and infrastructure.  Will submit formal proposal for a sale lease-back transaction in August.  Maintaining contact.
[NAME] | Anadarko Petroleum | Deepwater infrastructure development. | 5000000 | 2001-03-31 00:00:00 | 0.1 | 2001-09-01 00:00:00 | Have initiated discussions with Anadarko. Additional appraisal drilling to be complete in Q2.  Companies will evaluate ownership alternatives in Q4.  [NAME] in talks with SparTech in consideration of a joint bid.  Called twice recently & left messages.
Front [NAME] | Murphy / Dominion | Deepwater infrastructure development. | 5000000 | 2001-05-02 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Have initiated discussions with [NAME] and Dominion.  Additional appraisal drilling to be complete in Q3.  Companies will evaluate ownership alternatives in Q4.
Spreadsheet: 154613d1336495761-survey-in-excel-survey
Sheet: Employees

 | Name of the Company |  | B
 | Country of Residence |  | UK
 | Manager |  | BBB BBBBBBBBBBB
 | Employees per dept | Number of employees | Remarks
 | HR | 1
 | SALES | 3
 | MARKETING | 5
 | ADMINISTRATION | 4
 | CATERING | 6
 | RECEPTION | 9
Spreadsheet: 71240d1271934260-goes-over-a-certain-number-sample01
Sheet: Sheet1

 | su | m | t | w | th | f | s | su | m | t | w | th | f | s
[NAME] | d |  | d | d |  | d |  |  |  | d |  | d | d
[NAME] |  | d |  |  | d |  | d | d |  |  | d |  |  | d
Overtime [NAME]
Overtime [NAME]
Spreadsheet: fbedf361-41de-4215-a5a0-4ba54af7ab56
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Home Video | 85391200635 | Peanuts | It'S The Easter Beagle [NAME] | 2010-03-16 | DVD | Children | 19.97 | Y | Available
Warner Home Video | 14764291727 | Various | [NAME], The | 2006-03-14 | DVD | Children | 9.97 | Y | Available
Spreadsheet: 9469be70-6863-4542-a29c-bbe7896e676a
Sheet: Sheet1

GENERAL | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | #070082
Ordinance Fact Sheet |  |  |  |  |  |  |  |  |  | Ordinance Number
 |  |  |  | Brief Title |  | Approval Deadline |  | Reason
 |  |  |  | [NAME] and General Fund Reappropriation |  |  |  | To reappropriate and consolidate funding.
 |  |  |  | City Market Improvements
Details |  |  |  |  |  |  |  | Positions/Recommendations
 |  |  |  | Reason for Legislation |  |  |  | Sponsor |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Councilman [NAME]
 |  |  |  |  |  |  |  | Programs,
 |  |  |  |  |  |  |  | Departments,
 |  |  |  |  |  |  |  | or Groups
 |  |  |  |  |  |  |  | Affected
 |  |  |  |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  |  |  |  | Proponents
 |  |  |  |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  |  | City Planning and Development
 |  |  |  |  |  |  |  |  |  | Other
 |  |  |  |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  |  |  |  |  |  | None Known
 |  |  |  |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  |  |  |  |  |  |  |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  |  |  |  | Council
 |  |  |  |  |  |  |  | Committee |  |  |  | Do pass
 |  |  |  |  |  |  |  | Actions
 |  |  |  |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  |  |  |  | Policy/Program Impact
 |  |  |  |  |  |  |  | Policy or Program
 |  |  |  |  |  |  |  | Change |  | X |  | No |  |  |  | Yes
 |  |  |  |  |  |  |  | Operational
 |  |  |  |  |  |  |  | Impact
 |  |  |  |  |  |  |  | Assessment
 |  |  |  |  |  |  |  | Finances
 |  |  |  |  |  |  |  | Cost & Revenue
 |  |  |  |  |  |  |  | Projections --
 |  |  |  |  |  |  |  | Including Indirect
 |  |  |  |  |  |  |  | Costs
 |  |  |  |  |  |  |  | Financial Impact
 |  |  |  |  |  |  |  | Fund Source (s)
 |  |  |  |  |  |  |  | and Appropriation
 |  |  |  |  |  |  |  | Account Codes
 |  |  |  |  |  |  |  | (Use this space for further discussion, if necessary)
Applicable Dates:
Fact Sheet Prepared by:
 |  |  |  | [NAME]
 |  |  |  | City Planning and Development
Reviewed by:
Reference Numbers
Spreadsheet: 846768d1697908846-display-unique-values-with-a-count-for-a-date-range-unique-values-test-03
Sheet: Sheet1

NAME | Number | DATE | AMOUNT
JOE | 123 | 2023-10-01 00:00:00 | 10
JOE | 123 | 2023-11-02 00:00:00 | 15
SUE | 456 | 2023-10-04 00:00:00 | 30
MARK | 789 | 2023-10-06 00:00:00 | 5
LISA | 12 | 2023-10-15 00:00:00 | 20
SUE | 456 | 2023-10-16 00:00:00 | 60
JOE | 123 | 2023-10-23 00:00:00 | 80
JOE | 123 | 2023-10-24 00:00:00 | 15
Spreadsheet: 106316d1303487619-excel-2007-can-you-use-a-tick-box-as-a-value-invoice-examplemarlettticks
Sheet: Sheet1

[NAME]
 |  |  |  |  |  |  | Please invoice:
Month: | 2011-03-01 00:00:00
UID | Customer Name | Course Booked | Net Sale | Fee | Tutor Assist |  | Project |  | Total | Comments
WGT030 |  | IOSH | 245.83
WGT047 |  | NEBOSH | 395
WGT049 |  | IOSH | 275
WGT050 |  | IOSH | 200
WGT051 |  | IOSH | 200
WGT052 |  | IOSH | 200
WGT053 |  | IOSH | 200
WGT054 |  | IOSH | 200
WGT055 |  | NEBOSH | 395
WGT056 |  | IOSH | 220
WGT057 |  | IOSH | 220
WGT058 |  | NEBOSH | 395
WGT059 |  | NEBOSH | 395
WGT060 |  | NEBOSH | 395
WGT061 |  | IOSH | 275 |  |  |  |  | a
WGT035 |  | IOSH | 275 |  |  |  |  | a
WGT028 |  | IOSH
WGT011 |  | IOSH |  |  |  | a |  | a
WGT020 |  | IOSH |  |  |  | a
WGT046 |  | IOSH | 220
WGT026 |  | IOSH |  |  |  | a
WGT041 |  | IOSH | 275
WGT048 |  | IOSH | 275
WGT040 |  | IOSH | 275
WGT042 |  | IOSH | 275
WGT043 |  | IOSH | 275
WGT044 |  | IOSH | 175
WGT045 |  | IOSH | 220
Totals:
 |  | Invoice this amount:
Spreadsheet: 841749d1693919810-sum-without-certain-values-04_09_excelhelp
Sheet: RB Flore

 |  | Placette 1
 |  | Espèce | Recouvrement | Abondance relative | Type bio | Trophie | humidité | Déterminante  ZH | EEE | INDICES
 |  |  |  |  |  |  |  |  |  |  | HUMIDITÉ (H) | Indice humidité |  |  |  | 12
 |  | Agrostis gigantea [NAME], 1788 | 2 |  | [NAME]. | 6 | 7 | Oui
 |  | Cirsium palustre (L.) Scop., 1772 | 2 |  | [NAME]. | 6 | 7 | Oui
 |  | Epilobium tetragonum [NAME], 1753 | 1 |  | [NAME]. | 6 | 6
 |  | Filipendula ulmaria ([NAME]) Maxim., 1879 | 3 |  | [NAME]. | 6 | 7 | Oui |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  | Galium mollugo [NAME], 1753 | 2 |  | [NAME]. | 6 | 5 |  |  |  |  | [NAME] à mésoxérophiles
 |  | Holcus lanatus [NAME], 1753 | 1 |  | [NAME]. | 6 | 5 |  |  |  |  | Mésophiles
 |  | Holcus x hybridus Wein, 1913 | 1 |  |  | 0 | 0 |  |  |  |  | Hygrophiles
 |  | Juncus acutiflorus Ehrh. ex Hoffm., 1791 | 2 |  | Geo. | 3 | 8 | Oui |  |  |  | Hélophytes
 |  | [NAME] effusus L., 1753 | 4 |  | Geo. | 4 | 7 | Oui |  |  |  | Aquatiques
 |  | [NAME], 1753 [nom. et typ. cons.] | 1 |  | [NAME]. | 6 | 5
 |  |  |  |  |  |  |  |  |  |  | TROPHIE (T) | Indice trophie |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Oligotrophes
 |  |  |  |  |  |  |  |  |  |  |  | Mésotrophes
 |  |  |  |  |  |  |  |  |  |  |  | Eutrophes
 |  |  |  |  |  |  |  |  |  |  |  | Hypereutrophes
 |  |  |  |  |  |  |  |  |  |  | TYPE  BIOLOGIQUE (TB) | Recouvrement des ligneux |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces | Indice |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Phanérophytes
 |  |  |  |  |  |  |  |  |  |  |  | Chaméphytes
 |  |  |  |  |  |  |  |  |  |  |  | Hémicryptophytes
 |  |  |  |  |  |  |  |  |  |  |  | Géophytes
 |  |  |  |  |  |  |  |  |  |  |  | Thérophytes
 |  |  |  |  |  |  |  |  |  |  |  | FIABILITÉ DES INDICES H, T et TB :
 |  |  |  |  |  |  |  |  |  |  | EEE | Recouvrement des EEE |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  | Espèces |  |  | Recouvrement
 |  |  |  |  |  |  |  |  |  |  |  | Invasives avérées
 |  |  |  |  |  |  |  |  |  |  |  | Invasives potentielles
 |  |  |  |  |  |  |  |  |  |  |  | À surveiller
 |  |  |  |  |  |  |  |  |  |  | Déterminantes ZH
 |  |  |  |  |  |  |  |  |  |  |  | Emprise de P. aquilinum
 |  |  |  |  |  |  |  |  |  |  |  | Indice de diversité de Simpson :
Spreadsheet: 143045d1330152629-sumproduct-test
Sheet: Sheet1

Database |  |  |  |  |  | MasterData
Date | Customer | Position | Province | Units |  | Customer | Province | Units
Jan | Cust1 | MD | W Cape |  |  | Cust1 | W Cape | 3892.409710207532
Jan | Cust1 | FD | Natal |  |  | Cust1 | Natal | 2365.177775846793
Jan | Cust1 | COO | [NAME] |  |  | Cust1 | [NAME] | 1043.421333500618
Jan | Cust1 | SD | Limpopo |  |  | Cust1 | Limpopo | 1781.874061966079
Jan | Cust1 | MD | OFS |  |  | Cust2 | W Cape | 2669.508535134548
Jan | Cust1 | MD | N Cape |  |  | Cust2 | Natal | 652.7466327266957
Jan | Cust2 | FD | W Cape |  |  | Cust2 | [NAME] | 4055.380384689975
Jan | Cust2 | COO | Natal |  |  | Cust2 | Limpopo | 382.0314110570233
Jan | Cust2 | SD | [NAME] |  |  | Cust2 | OFS | 806.9081538973937
Jan | Cust2 | MD | Limpopo |  |  | Cust2 | N Cape | 4094.39848629988
Jan | Cust2 | MD | OFS |  |  | Cust3 | [NAME] | 2867.544621030409
Jan | Cust2 | FD | N Cape |  |  | Cust3 | Limpopo | 294.5628848502446
Jan | Cust3 | COO | W Cape |  |  | Cust3 | OFS | 3395.798655959547
Jan | Cust3 | SD | Natal |  |  | Cust3 | N Cape | 2219.777145050493
Jan | Cust3 | MD | [NAME] |  |  | Cust4 | W Cape | 106.9604581667904
Jan | Cust3 | MD | Limpopo |  |  | Cust4 | Natal | 2769.849990406505
Jan | Cust3 | FD | OFS |  |  | Cust4 | [NAME] | 4982.033299333515
Jan | Cust3 | COO | N Cape |  |  | Cust4 | Limpopo | 3901.329689603693
Jan | Cust4 | SD | W Cape |  |  | Cust4 | OFS | 513.2001827977978
Jan | Cust4 | MD | Natal |  |  | Cust4 | N Cape | 1106.194786006346
Jan | Cust4 | COO | [NAME]
Jan | Cust4 | SD | Limpopo
Jan | Cust4 | MD | OFS
Jan | Cust4 | MD | N Cape
Spreadsheet: 750763d1633623050-vlookup-reference-function-excel-test-data
Sheet: Sheet1

 | Player | Pos | Team | Bye | Rush Yds | Rush TD | Rec | Rec Yds | [NAME]
 | [NAME] | RB | SD | 10 | 38 | 0 | 5 | 34 | 0
 | [NAME] | RB | NE | 10 | 38 | 0 | 5 | 23 | 0
 | [NAME] | RB | Min | 10 | 75 | 0 | 2 | 18 | 0
 | [NAME] | RB | Atl | 9 | 144 | 2 | 13 | 222 | 3
 | [NAME] | RB | Hou | 10 | 172 | 13 | 2 | 16 | 0
Spreadsheet: 71804d1272515826-how-to-find-min-in-list-samplerates
Sheet: Sheet1

Customer | Rate | Min | Min
[NAME] | 7 | 7 | 4
[NAME] | 7 | 7 | 4
[NAME] | 10 | 7 | 4
[NAME] | 10 | 7 | 4
[NAME] | 15 | 7 | 4
[NAME] | 7 | 7 | 4
[NAME] | 7 | 7 | 4
[NAME] | 15 | 7 | 4
[NAME] | 4 | 7 | 4
[NAME] | 10 | 7 | 4
[NAME] | 10 | 7 | 4
[NAME] | 15 | 7 | 4
[NAME] | 15 | 7 | 4
[NAME] | 15 | 7 | 4
 |  | Using Array | Using Filldown
Spreadsheet: 3d2d5696-5027-422d-9f4c-b361a7c98b77
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0022156 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Morehead City WWTP | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | [NAME] | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00940 | 50060 | 31616 | 00610 | 00620 | 00400 | 70295 | 00530 | 00076
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Chloride | Total Residual Chlorine | Fecal Coliform | Ammonia | Nitrate | pH | Total Dissolved Solids | Total Suspended Solids | Turbidity
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | mg/L | mg/L | NTU
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder | Composite | Grab | Grab | Grab | Composite | Composite | Grab | Grab | Composite | Recorder
Monthly Limit: |  |  |  | 10 |  |  | 14 | 4 |  |  |  | 5
Daily Limit: |  |  |  | 15 |  |  | 25 | 6 |  | 6-9 |  | 10 | 10
Sample Frequency: |  |  | [NAME] | Monthly | 3 x Year | 5 x Week | Monthly | Monthly | Monthly | 5 x Week | 3 x Year | Monthly | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 89297d1289064149-extend-data-format-and-formulas-not-all-columns-extend-formulas
Sheet: Sheet2

1 | 2 |  |  |  |  | 98 | 98 | 63 | 98
200 | 3 |  |  |  |  | 19 | 19 | 14 | 29
250 | 4 |  |  |  |  | 19 | 19 | 14 | 29
300 | 5 |  |  |  |  | 25 | 25 | 25 | 25
330 | 6 |  |  |  |  | 30 | 30 | 30 | 30
win | 4 |  |  |  |  | 40 | 40 | 40 | 40
draw | 2 |  |  |  |  | 19 | 19 | 14 | 29
cancel | 0 |  |  |  |  |  | 50 | 50 | 50
 |  |  |  |  |  | 250 | 300 | 250 | 330
Spreadsheet: 210096d1359380981-status-value-dependant-upon-data-in-certain-cells-excel-query-1
Sheet: Sheet1

Status | Date Account Created | Date Documents Submitted | Date Documents Received | Documents are completed | Provisional Date | [NAME] | File Complete
 | 2013-01-01 00:00:00
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00 | Yes
 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | Yes | 2013-01-05 00:00:00 | Yes | Yes
Account Created | 1
Documents Submitted | 2
Documents Received | 3
Documents Completed | 4
Provisional Date | 5
[NAME] | 6
File Complete | 7
Spreadsheet: 111802d1308086969-making-calculations-based-on-dropdown-selection-dropdownscreatingformulae
Sheet: Report

carrier | policy | premium | total comissionable premium | Column1
MOO | FaceCare | 157
Fake | FaceCare | 1000
Fake | NoseInsurance | 500
Realco | EarsSafe | 142
Spreadsheet: 836011d1689045448-excel-formula-for-merge-duplicate-data-and-sum-the-value-qmedical-supplies
Sheet: Stock Out

Date | Stand No. | Item Name | Item Code No. | Quantity
 |  | Crepe Bandage 5cm | 131230010 | 15
 |  | Crepe Bandage 5cm | 131230010 | 20
 |  | Crepe Bandage 5cm | 131230010 | 36
 |  | Crepe Bandage 7.5cm | 131230012 | 45
 |  | [NAME] | 131230013 | 11
 |  | [NAME] 15cm | 131230014 | 10
 |  | Crepe Bandage 5cm | 131230010 | 12
 |  | Crepe Bandage 5cm | 131230010 | 14
 |  | Crepe Bandage 5cm | 131230010 | 11
 |  | Crepe Bandage 7.5cm | 131230012 | 10
 |  | [NAME] | 131230013 | 15
 |  | [NAME] 15cm | 131230014 | 12
Spreadsheet: 487315d1478017659-simple-nested-lookup-sampleworksheet_110116_122700
Sheet: Data

Orchard | Fruit | Color
[NAME] | Apples | Green
[NAME] | Pears | Blue
[NAME] | Berries | Black
[NAME] | Apples | Red
[NAME] | Pears | Purple
[NAME] | Berries | Orange
Spreadsheet: 850581d1700937662-transpose-rows-from-one-sheet-to-another-sheet-based-on-a-value-in-one-of-the-columns-transpose-worksheet-copy
Sheet: Sheet1

QUANTITY | COST | DATE | SELLER | BUYER | ITEM | AREA ID
8 | 133 | 2016-03-31 00:00:00 | Seller 3 | Buyer 5 | Item 1 | A
30 | 1713 | 2016-09-13 00:00:00 | Seller 2 | Buyer 3 | Item 2 | D
9 | 289 | 2017-01-29 00:00:00 | Seller 4 | Buyer 3 | Item 6 | B
3 | 285 | 2017-11-13 00:00:00 | Seller 2 | Buyer 3 | Item 4 | B
7 | 287 | 2017-11-20 00:00:00 | Seller 3 | Buyer 6 | Item 5 | E
20 | 283 | 2018-02-08 00:00:00 | Seller 1 | Buyer 6 | Item 3 | D
10 | 166.25 | 2018-03-06 00:00:00 | Seller 1 | Buyer 6 | Item 1 | B
10 | 571 | 2018-03-28 00:00:00 | Seller 2 | Buyer 6 | Item 2 | D
15 | 212.25 | 2018-03-28 00:00:00 | Seller 3 | Buyer 5 | Item 3 | D
20 | 1900 | 2018-03-28 00:00:00 | Seller 4 | Buyer 6 | Item 4 | D
10 | 410 | 2018-03-28 00:00:00 | Seller 1 | Buyer 6 | Item 5 | F
15 | 481.6666666666667 | 2018-03-28 00:00:00 | Seller 2 | Buyer 5 | Item 6 | A
8 | 133 | 2018-03-28 00:00:00 | Seller 3 | Buyer 5 | Item 1 | A
20 | 1142 | 2018-03-28 00:00:00 | Seller 4 | Buyer 5 | Item 2 | A
45 | 636.75 | 2018-03-28 00:00:00 | Seller 1 | Buyer 3 | Item 3 | B
5 | 475 | 2018-03-28 00:00:00 | Seller 2 | Buyer 6 | Item 4 | C
1 | 41 | 2018-03-28 00:00:00 | Seller 3 | Buyer 6 | Item 5 | C
5 | 160.5555555555556 | 2018-03-28 00:00:00 | Seller 4 | Buyer 4 | Item 6 | C
10 | 571 | 2018-12-05 00:00:00 | Seller 4 | Buyer 6 | Item 2 | C
5 | 83.125 | 2019-05-30 00:00:00 | Seller 1 | Buyer 4 | Item 1 | D
Spreadsheet: 279252d1385049116-tweaking-a-excel-schedule-dockschedule
Sheet: Name Lookup

This sheet populates the drop down list of names on the [NAME] sheet in cell H3.  Any changes made to this sheet could result in an error.
UNIQUE NAME | ROW NUMBER
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Top 10 By Gas

Originator | Commodity | Team | Total
Tycholiz | Gas | West | 19943780
Whitt | Gas | West | 10556290
Luce | Gas | Central | 7419391
Le Dain | Gas | Canada | 6477592.45469978
Lucci | Gas | West | 6422228.75
[NAME] | Gas | Derivatives | 5811290.02
Gottlob | Gas | Assets | 5749630
Davies | Gas | Canada | 3339000
Lagrasta | Gas | Derivatives | 2635109.26
Sangwine | Gas | Canada | 2528456.309120084
Total
Spreadsheet: 810376d1671724262-formula-to-determine-how-to-best-fit-a-series-of-number-inside-another-sample-
Sheet: Sheet1

 |  |  |  |  | PCB calculation for given Length
 |  |  |  |  | extrusion length | 123
 |  |  |  |  | Part name | part length | PCB Qtty
 |  |  |  |  | part 1 | 16
 |  |  |  |  | Part 2 | 10
 |  |  |  |  | part 3 | 8
 |  |  |  |  | part 4 | 3
 |  |  |  |  | part 5 | 2