tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 78841d1279136092-formula-to-distribute-payroll-sample
Sheet: Reg Earnings

 |  |  | Labour account | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001 | 700001
 |  |  | Cost Centre | 153511 | 153512 | 153513 | 153514 | 153517 | 153516 | 153531 | 153532 | 153533 | 153550 | 153551 | 153552 | 153531 | 153535 | 153531 | 153625 | 153630 | 153610 | 153605 | 153600 | 153620 | 153515 | 153635 | 153650 | 153561 | 153562 | 153563 | 153561 | 153562 | 153560 | 153560 | 153564 | 153801 | 153801 | 153801 | 153802 | 153802 | 153640 | 153900 | 153500 | 153500 | 153500 | 153500
 |  |  |  | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg | Reg
COMP | DEPT | FILE# | NAME | Process 1 | Process 2 | Process 3 | Process 4 | Process 5 | Process 6 | Process 7 | Process 8 | Process 9 | Process 10 | Process 11 | Process 12 | Process 13 | Process 14 | Process 15 | Process 16 | Process 17 | Process 18 | Process 19 | Process 20 | Process 21 | Process 22 | Process 23 | Process 24 | Process 25 | Process 26 | Process 27 | Process 28 | Process 29 | Process 30 | Process 31 | Process 32 | Process 33 | Process 34 | Process 35 | Process 36 | Process 37 | Process 38 | Process 39 | Process 40 | Process 41 | Process 42 | Process 43
Spreadsheet: 167943d1342164919-i-want-to-send-data-in-multiple-workbook-projcet-05-expense-ledger
Sheet: Payment Received from Owner 

 |  |  |  |  |  | PROJECT # 05
 |  |  |  |  |  | Received from Client-OWNER
DATE | B# | P# | L# | V# | A/C | Description |  |  |  | Cheq#/PS | Bank | Book# | A/C Ref # |  |  | DEBIT | CREDIT | BALANCE
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]# | Page# | Ledger#
2009-07-26 00:00:00 | 1 | 91 | L-06 |  |  | Received cheque H.M.B |  |  |  | 43397176 |  |  |  | 114 | L-05 | 2500000 |  | 2500000
2009-08-09 00:00:00 | 2 | 91 | L-06 |  |  | Received cheque H.M.B |  |  |  | 43397177 |  |  |  | 129 | L-05 | 100000 |  | 2600000
Spreadsheet: 847078d1698166532-multiple-conditional-formatting-rules-applied-to-same-cell-geotech-major-project-schedule-2
Sheet: Betty

Betty |  | [NAME] | Experience |  |  |  |  | Notes:
DOB |  | Phone
Home Airport
Safety Tickets
 | 2023-07-17 00:00:00 | 2023-07-18 00:00:00 | 2023-07-19 00:00:00 | 2023-07-20 00:00:00 | 2023-07-21 00:00:00 | 2023-07-22 00:00:00 | 2023-07-23 00:00:00 | 2023-07-24 00:00:00 | 2023-07-25 00:00:00 | 2023-07-26 00:00:00 | 2023-07-27 00:00:00 | 2023-07-28 00:00:00 | 2023-07-29 00:00:00 | 2023-07-30 00:00:00 | 2023-07-31 00:00:00 | 2023-08-01 00:00:00 | 2023-08-02 00:00:00
[NAME] | N | N | N | D | D | D | D | D | D | D | D | D
Spreadsheet: 471862d1469219876-searching-and-listing-out-information-worker
Sheet: Sheet2

 | order | emp. Id | amount | boats | state |  | emp. Id | 151
 | 1001 | 151 | 150 | st. dream | tx |  | boat | st. dream
 | 1002 | 234 | 175 | hi | ca |  | nth | amount
 | 1003 | 162 | 100 | hi | tn |  | 1
 | 1004 | 151 | 125 | st. dream | tx |  | 2
 |  |  |  |  |  |  | ids = C7:C10
 |  |  |  |  |  |  | amts = D7:D10
 |  |  |  |  |  |  | id = I6
 |  |  |  |  |  |  | bt = I7
 |  |  |  |  |  |  | bts = E7:E10
Spreadsheet: 105bb9bc-18f1-433c-8f0a-8e0882bef05b
Sheet: Sheet1

APN: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Address: | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 | A.  Residential Project Statistics
EXISTING
Bldg. Floor | [NAME]) |  | Structure Type |  | Zoning           Net | Building & Safety Floor Area      (B&S Gross) | Alteration/     Remodel          B&S Gross
 | existing
 | existing |  |  | +
 | existing |  |  | +
 |  |  | Existing Main Building Area SUBTOTALS: |  | 0 | 0 | 0
 | Garage/Carport
 | existing | attached or detached | Garage | +
 | existing |  | Carport | +
 | [NAME]
 | existing | attached or detached |  | +
 | existing |  |  | +
 | Basement or Cellar
 | existing | attached or detached
 |  |  | Existing Area TOTALS: |  | 0 | 0 | 0
PROPOSED FOR DEMOLITION OR CHANGE OF USE
Bldg. Floor | [NAME]) |  | Structure Type |  | Net | B&S Gross
 | existing | demo. or use change |  |  |  |  | square feet
 | existing |  |  |  |  |  | square feet
 | existing |  |  |  |  |  | square feet
 |  |  | Demolition or Change of Use Area SUBTOTALS: |  | 0 | 0
 | Garage/Carport
 | existing | demo. or use change | Garage |  |  |  | square feet
 | existing |  | Carport |  |  |  | square feet
 | [NAME]
 | existing | demo. or use change |  |  |  |  | square feet
 | existing |  |  |  |  |  | square feet
 | Basement or Cellar
 | existing | demo. or use change |  |  |  |  | square feet
 |  |  | Demolition or Change of Use Area TOTALS: |  | 0 | 0 | square feet
PROPOSED NEW CONSTRUCTION, INCLUDING  ANY "AS BUILT" PROPOSALS
Bldg. Floor | Main Building(s) |  | Structure Type |  | Net | B&S Gross
 | addition or new structure |  |  |  |  |  | square feet
 |  |  |  | + |  |  | square feet
 |  |  |  | + |  |  | square feet
 |  |  | Proposed Area SUBTOTALS: |  | 0 | 0 | square feet
 | Garage/Carport
 | addition or new structure |  |  | + |  |  | square feet
 | [NAME] |  |  |  |  | 0
 | addition or new structure |  |  | + |  |  | square feet
 |  |  |  | + |  |  | square feet
Non-Habitable Accessory Total: |  |  | 0 |  | n.a. | n.a. | square feet
 | Basement or Cellar
 | addition or new structure |  |  |  |  |  | square feet
 |  |  | Proposed Area TOTALS: |  | 0 | 0 | square feet
RESIDENTIAL TOTAL (EXISTING - DEMOLITION + NEW) = |  |  |  |  | 0 | 0 | square feet*
 | *B&S Gross res. sq. ft. includes useable roof deck sq. ft. from "General Sheet".
 |  |  | SCHOOL FEE SQ. FT. ESTIMATE  = |  | 0 |  | (CA Gov. Code §63080)
Note: Any square footage for enclosed attic, cellar or basement areas < 5' in floor to ceiling height is not included. |  |  |  |  |  |  | rev.6/8/07
Spreadsheet: mary_hain__25864__Data_Response_BPA_SP_009
Sheet: Attachment 3 Notes

 | LB CRAC | Rem Aug | Net Augm
 | Price | Q (aMW) | Cost
 | 207.5263042824682 | 2549.657530864197 | 4179.536397757534 |  | The values in this table are found in
 | 112.1167129644154 | 2287.346506233126 | 1838.963773788078 |  | BPA Values in Toolkit file "TK_145_S2000_210Mkt_LR0_021001.xls"
 | 44.31727154985469 | 2159.868751714678 | 461.402277226965 |  | Please see sheet "1B Notes" for further details on cell references
 | 47.25333207419796 | 2001.018560385889 | 485.3469814684757
 | 47.63730412210631 | 2149.758003445949 | 519.2982896350935
 | Also see | BPA WP-01-BPA-E-58 Table 4-1 (row 7) for purchases as of 8/1/00
Spreadsheet: 82413d1282480245-to-find-out-the-single-part-on-all-the-sheets-book1
Sheet: CNDDRSSCR

 | Part Code | Part name
 | 12301-GB6-9000 | COVER CYLINDER HEAD |  | 12301-GB6-9000 | COVER CYLINDER HEAD
 | 12301-GB6-9000 | COVER CYLINDER HEAD |  | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE
 | 12341-GB6-9100 | COVER L CYLINDER HEAD SIDE |  | [PHONE] | HOLE CAP TAPPET ADJUSTING
 | [PHONE] | HOLE CAP TAPPET ADJUSTING |  | 12394-GW8-6810 | GASKET CYLINDER HD L SIDE COVER
 | [PHONE] | HOLE CAP TAPPET ADJUSTING |  | 12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER
 | 12394-GW8-6810 | GASKET CYLINDER HD L SIDE COVER |  | 98056-57718-01 | SPARK PLUG
 | 12395-GW8-6810 | GASKET CYLINDER HD R SIDE COVER |  | 90201-GF6-0000 | NUT CAP 7MM
 | 98056-57718-01 | SPARK PLUG |  | 90443-GF6-0000 | WASHER A SEALING 7 MM
 | 90201-GF6-0000 | NUT CAP 7MM |  | [PHONE] | WASHER SEALING 12 MM
 | 90201-GF6-0000 | NUT CAP 7MM |  | 95701-06110-00 | BOLT FLANGE 6X110
 | 90443-GF6-0000 | WASHER A SEALING 7 MM |  | 96001-06020-00 | BOLT FLANGE SH.6X20
 | [PHONE] | WASHER SEALING 12 MM |  | 12191-KRS-C100 | GASKET CYLINDER
 | [PHONE] | WASHER SEALING 12 MM |  | 14321-GB6-9000 | SPROCKET CAM
 | 95701-06110-00 | BOLT FLANGE 6X110 |  | [PHONE] | CHAIN CAM
 | 96001-06020-00 | BOLT FLANGE SH.6X20 |  | 14502-086-000R | ROLLER [NAME] CHAIN TENSIONER
 | 12191-KRS-C100 | GASKET CYLINDER |  | [PHONE] | PIVOT CAM CHAIN TENSIONER
 | 12191-KRS-C100 | GASKET CYLINDER
 | 14321-GB6-9000 | SPROCKET CAM
 | [PHONE] | CHAIN CAM
 | [PHONE] | CHAIN CAM
 | 14502-086-000R | ROLLER [NAME] CHAIN TENSIONER
 | [PHONE] | PIVOT CAM CHAIN TENSIONER
 | [PHONE] | PIVOT CAM CHAIN TENSIONER
Spreadsheet: darrell_schoolcraft__7560__Outweeknng0228
Sheet: Sheet1

NNG WEEKLY OUTAGE REPORT
NORTHERN NATURAL GAS
 | Location | Date | Scope | Comments
NNG | Garner | 12/04/01 to 04/30/02 | Refrigerant compressor is being shipped to York International for repairs. | Est. Flow affect - Not able to to liquifey and gas during this outage. The tank is about 80% full going into January.
NNG | Waterloo   Unit 6 | 02/11/02 to 03/06/02 | Packing and compressor rings. | Flow affect = 0 mmcfd.
NNG | Bushton  31 | 02/27/02 to 02/29/02 | Replace a section of the exhaust header. (We will try and wait until north flows drop off). | Flow affect = 0 mmcfd.
NNG | Cunningham  Unit 5 | 02/25/02 to 03/25/02 | [NAME] and repair cracked manifold. (The actual overhaul starts 03/04). | Flow affect = 50 mmcfd from our [NAME] wdl. effort.
NNG | Burdett | 02/27/02 to 02/27/02 | Replace valve. 4 to 5 hrs | Flow affect = 0 mmcfd.
NNG | [NAME] 3 | 03/11/02 to 04/05/02 | [NAME] | Flow affect = 3 mmcfd.
NNG | [NAME] | 03/05/02 to 03/06/02 | Borescope & minor maintenance. | Flow affect = 2 mmcfd.
NNG | Northrup 1&2 | 03/19/02 to 03/19/02 | Relief valve testing.  8 hrs. | Flow affect = 15 mmcfd.
NNG | [NAME] | 03/18/02 to 03/18/02 | Relief valve testing.  8 hrs. | Flow affect = 7 mmcfd.
NNG | Plains Turbine | 03/19/02 to 03/20/02 | Annual ESD  24 hrs. (We will see if EL Paso can work with us during this outage, if so the flow imact will be zero). | Flow affect = 100 mmcfd.
Spreadsheet: lynn_blair__24381__LSPOWER2001ANALYSIS
Sheet: Sheet3

 |  |  |  |  |  |  |  |  | Timely |  | Evening |  | NonGrid |  | ID1 |  | ID 2 |  | True-up
 |  |  |  |  |  |  |  |  | Nomination | Scheduled | Nomination | Scheduled | Nomination | Scheduled | Nomination | Scheduled | Nomination | Scheduled | Nomination | Scheduled
 | 2001-06-19 00:00:00 | 10400 | 11454 | 2158 | -9296 | Y | 9296
 | 2001-06-20 00:00:00 | 2000 | 8989 | 2260 | -6729 | Y | 6729
 | 2001-07-01 00:00:00 | 1845 | 2655 | 2378 | -277 | Y | 277
 | 2001-07-27 00:00:00 | 2100 | 16012 | 2547 | -13465 | N | NOT COVERED
Spreadsheet: 39082d1237295676-solved-need-help-locating-a-cell-mlbbetsystem-version-2-1-2
Sheet: Series

 |  |  |  |  |  |  | Series #2
 |  |  |  |  |  |  |  | Starting Bankroll
 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  | Current Bankroll
Date | Bet Unit | Series # | Game # | Bet Team | VS Team | Line | Risk | To Win | Bankroll | Profit | W/L | Score
2009-04-10 00:00:00 | 1 | 1 | 1 | [NAME] | at Atl | -125 |  |  |  |  | l | 3-6
2009-04-11 00:00:00 | 1 | 1 | 2 | [NAME] | at Atl | -167 |  |  |  |  | l | 3-9
2009-04-11 00:00:00 | 1 | 1 | 3 | [NAME] | at Atl | -146 |  |  |  |  | w | 9-4
2009-04-12 00:00:00 | 1 | 2 | 1 | SEA | at SF | -175 |  |  |  |  | w | 4-2
2009-04-12 00:00:00 | 1 | 3 | 1 | ARZ | SD | -180 |  |  |  |  | l | 2-4
2009-04-12 00:00:00 | 1 | 4 | 1 | TAM | DET | -145 |  |  |  |  | l | 1-5
2009-04-13 00:00:00 | 1 | 3 | 2 | ARZ | SD | -144 |  |  |  |  | w | 4-0
Spreadsheet: 700714d1603300601-unique-alphabetical-order-order-4
Sheet: Foglio1

ID | Stato | Anno | YES | 2020
Fami.1 | YES | 2017
Fami.2 | YES | 2017
Fami.3 | YES | 2017
Fami.3 | YES | 2017
Fami.1 | YES | 2017
Fami.1 | YES | 2017
Fami.4 | YES | 2017
Fami.2 | YES | 2017
Fami.1 | YES | 2017
Fami.6 | YES | 2018
Fami.4 | YES | 2018
Fami.6 | NO | 2018
Fami.6 | YES | 2018
!Altro | YES | 2018
Fami.2 | NO | 2018
Fami.1 | YES | 2018
Fami.3 | NO | 2018
Fami.6 | YES | 2018
Fami.7 | YES | 2018
Fami.7 | YES | 2018
Fami.7 | YES | 2018
Fami.5 | YES | 2018
Fami.5 | YES | 2019
Fami.5 | YES | 2019
Fami.5 | YES | 2019
Fami.5 | YES | 2019
[NAME] | YES | 2019
Fami.2 | YES | 2019
[NAME] | YES | 2019
Fami.9 | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
[NAME] | YES | 2019
Fami.6 | YES | 2019
Fami.6 | YES | 2019
Fami.6 | YES | 2019
Fami.2 | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
Fami.7,2 | YES | 2020
Fami.4 | NO | 2020
Fami.7,2 | NO | 2020
[NAME] | NO | 2020
[NAME] | YES | 2020
Fami.9 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
Fami.4 | YES | 2020
[NAME] | YES | 2020
[NAME] | NO | 2020
Fami.7,2 | NO | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
[NAME] | YES | 2020
Fami.10 | BO | 2020
Fami.10 | YES | 2020
Fami.2 | YES | 2020
Fami.3 | YES | 2020
[NAME] | YES | 2020
Fami.4 | NO | 2020
Fami.7 | YES | 2020
Fami.10 | YES | 2020
Fami.10 | YES | 2020
Fami.10 | NO | 2020
Fami.4 | YES | 2020
Fami.2 | YES | 2020
Fami.4 | YES | 2020
Fami.7,2 | YES | 2020
Spreadsheet: 52742d1252583159-excel-2007-calculate-via-list-box-options-excel-list-box
Sheet: Sheet1

[NAME] 500 Orange |  |  |  |  | B/Front | S/Side | Border | Quantity | Cost: | Seats | Backs | 0.92 | 1 | Select Filling
 |  |  |  |  | 20 | 20 | 1 | 1 | 3.194444444444444 |  |  | 1.15 | 2 | [NAME] 500 Orange
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 3 | [NAME] 340 White
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 4 | [NAME] 300 White
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 5 | Fibre (Corovin Case)
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 6 | Fibre (Calico Case)
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 7 | Feather/Foam
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 8 | Feather (Curled Duck)
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 9 | Feather ([NAME])
 |  |  |  |  |  |  |  |  |  |  |  | 1.15 | 10 | Feather (White Duck)
Spreadsheet: 131175d1322772668-excel-2007-find-the-earliest-date-in-a-column-when-there-is-also-text-in-the-column-example
Sheet: Funding Program Status Report

Funding Program Status Report
 |  |  |  |  |  |  | Printed on: 12/1/11 12:02 pm
 | Unit
 | 16-1145
 | 16-1149
 | 16-1153
 | 17-1131
 | 23-1152
 | 55-1221
 | 55-1225
 | 55-1229
 | 55-1233
 | 55-1241
 | 55-1245
 | 55-1253
 | 55-1257
 | 55-1265
 | 55-1269
 | 55-1277
 | 55-1281
 | 55-1301
 | 57-1253
 | 57-1297
 | Report Version: 9-Apr-2010 (7.6.0) |  |  |  |  |  |  |  | Page 1 of 1
Spreadsheet: 0015f0e0-364f-4303-9fec-1743a2e15a36
Sheet: Sheet1

WORLD SENIOR BADMINTON CHAMPIONSHIPS 2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
09-14 SEPTEMBER 2013, ANKARA-TURKEY
PRACTICE PROGRAMME
 | 08.09.2013  SUNDAY
 |  | Main Hall
 | Time | Court 1 | Court 2 | Court 3 | Court 4 | Court 5 | Court 6
1 | 09.00-10.00 | Russia | Russia | Russia | Russia
2 | 10.00-11.00 | Turkey | Turkey | Turkey | Turkey | Turkey | Turkey
3 | 11.00-12.00 | England | Scotland | India | India | India | India
4 | 12.00-13.00 | India | Scotland | England | England | England | England
5 | 13.00-14.00 | India | Japan | Japan | Japan | Japan | Japan
6 | 14.00-15.00 | Canada | Japan | Japan | Japan | Japan | Japan
7 | 15.00-16.00 | Canada | Austria | Austria | Canada
8 | 16.00-17.00 | Norway | Norway | Norway | Czech Republic | Thailand | Thailand
9 | 17.00-18.00 | Sweden | Sweden | Russia | Russia | Thailand | Thailand
10 | 18.00-19.00 | Poland | Poland | India | India |  | Ukrain
11 | 19.00-20.00 | Qatar |  |  | Bulgaria | Bulgaria | Ukrain
12 | 20.00-21.00 | Finland | Finland | Austria | Bulgaria | Bulgaria | Belgium
13 | 21.00-22.00 | Slovakia |  | Turkey | Turkey | Turkey | Turkey
 | 08.09.2013  SUNDAY
 |  | Main Hall
 | Time | Court 7 | Court 8 | Court 9 | Court 10 | Court 11 | Court 12
1 | 09.00-10.00 | Denmark | Denmark
2 | 10.00-11.00 | Denmark | Denmark
3 | 11.00-12.00 | Netherland | Netherland | Denmark | Denmark
4 | 12.00-13.00 | Netherland | Netherland | Spain | Germany | Germany
5 | 13.00-14.00 | Ireland | Ireland | Spain | Germany | Germany | Slovenia
6 | 14.00-15.00 | Canada | France | France | Germany | Germany | Philipinnes
7 | 15.00-16.00 | Canada | France | France |  | England | England
8 | 16.00-17.00 | Mongolia | Hong Kong | Russia |  | England | England
9 | 17.00-18.00 | Croatia | Azerbaycan | Russia |  | England | England
10 | 18.00-19.00 | Belgium | Indonesia | Australia |  | England | England
11 | 19.00-20.00 | Italy | Indonesia | Indonesia | Germany | Germany | Sweden
12 | 20.00-21.00 | Switzerland | Hungary | [NAME] | Germany | Germany | Sweden
13 | 21.00-22.00 | Switzerland | S.Africa | Malaysia | Chines Taipei | Chines Taipei | Estonia
Spreadsheet: errol_mclaughlin_jr__10486__New Curve Setup Form
Sheet: Sheet1

 |  |  |  | Enron Corporation
 |  |  |  | New Curve Setup Form
To: | Risk Analysis & Reporting ([NAME]/[NAME]) |  | Request #
From: | Book Administrator |  | Department: | Risk Management
Subject: | New Curve Setup |  | Date:
 | To be Completed by Book Administrator:
 |  |  |  |  | Reporting -Subledger
 | Book Administrator Name:
 |  |  |  |  | MTM | Prud | Realized
 | Trader Requesting New Curve:
 | Curve Code:
 | Full Name and Description of Curve:
 | Commodity:
 | Unit of Measure:
 | [NAME]:
 | To be Provided by Risk Analysis & Reporting/RAC:
 | [NAME]. Factor:
 | Curve Setup Checklist: | Undertaken by (please initial): | Date:
1 | Add Curve to Trading System
2 | [NAME] to GRMS Benchmark Definitions
3 | [NAME] to GRMS Value at Risk
Spreadsheet: 117637d1312925190-consolidated-statistics-query101
Sheet: Sheet1

 |  | The Table:
 |  | No | Qty | Value | Date
 |  | 3100019039 | 81 | 1143.3 | 2011-04-25 00:00:00 |  | In the Table, there are only 3 unique Nos in Col.C are repeating.
 |  | 3100019501 | 38 | 1699.5 | 2011-05-06 00:00:00 |  |  |  | (Col D) | (Col E) | (Col F) | (Col F)
 |  | 3100019039 | 27 | 1391 | 2011-05-18 00:00:00 |  |  | No. | Qty total | Value Total | Date Min | Date Max
 |  | 3100019400 | 11 | 8392 | 2011-05-06 00:00:00 |  | i.e. | 3100019039 |  |  | 2011-02-28 00:00:00 | 2011-07-28 00:00:00
 |  | 3100019039 | 183 | 1884.9 | 2011-05-17 00:00:00 |  |  | 3100019501
 |  | 3100019400 | 27 | 2155.79 | 2011-05-17 00:00:00 |  |  | 3100019400
 |  | 3100019400 | 3 | 18181 | 2011-05-28 00:00:00
 |  | 3100019039 | 1 | 28737 | 2011-07-28 00:00:00 | (Max of C11)
 |  | 3100019501 | 37 | 30333.66 | 2011-06-03 00:00:00
 |  | 3100019400 | 22 | 8742.64 | 2011-06-17 00:00:00
 |  | 3100019501 | 80 | 9939.5 | 2011-05-17 00:00:00 |  |  | Friends,
 |  | 3100019039 | 27 | 15172 | 2011-02-28 00:00:00 | (Min of C11) |  | I want to get the consolidated result as mentioned in  Cols. J7 - M7 for all [NAME]. mentioned in Col.I. Please help me to find the formulas.
 |  | 3100019400 | 11 | 9534 | 2011-05-28 00:00:00
 |  | 3100019039 | 78 | 11917.1 | 2011-03-06 00:00:00
 |  | 3100019501 | 54 | 16152 | 2011-05-06 00:00:00
 |  | 3100019039 | 22 | 21815.4 | 2011-05-06 00:00:00
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 40

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
40 | 2007-02-16 00:00:00 | 7.4 | 0.57 | 3.6 | 1.5 | 2.4 | 2 |  |  |  | 2 |  | 2.125475725296229 | 1.6 | 0 | 5 |  |  |  |  | -0.1
W40 | 2018-05-30 00:00:00 | 8.07 | 0.986 | 3.02 | 1.25 | 2.19 |  | 3.798657181680122 | 0 | 1.05 | 2.449 | 631 |  |  | 0.76 | 28.787 | 0.317 | 0.08 | 0.07 | 0.237
Spreadsheet: 377793d1424172090-showing-changes-only-in-scrolling-list-job-change-example-for-tips
Sheet: Sheet1

Employ_ref | Forename | Surname | Leaver | Busarea | Costcentre | Description | Grade_1 | Fromdate_1 | Untildate_1 | [NAME]
16842 | Marcus | Johes | False | ONLINT | 1500 | E | [NAME] | 2014-09-01 00:00:00 |  | PROM
16842 | Marcus | Johes | False | ONLINT | 1500 | E | MT2 | 2013-01-01 00:00:00 | 2014-08-31 00:00:00 | COYSTR
16842 | Marcus | Johes | False | ONLINT | 1500 | E | MT2 | 2012-11-01 00:00:00 | 2012-12-31 00:00:00 | OTH
16842 | Marcus | Johes | False | ONLINT | 1500 | E | MT2 | 2011-06-01 00:00:00 | 2012-10-31 00:00:00 | NS
17227 | [NAME] | Smith | False | KWEAR | 1580 | K | MT3 | 2014-08-18 00:00:00 |  | PROM
17227 | [NAME] | Smith | False | LWEAR | 1560 | K | MT4 | 2013-01-01 00:00:00 | 2014-08-17 00:00:00 | COYSTR
17227 | [NAME] | Smith | False | LWEAR | 1560 | K | MT4 | 2012-09-11 00:00:00 | 2012-12-31 00:00:00 | NS
15116 | [NAME] | White | False | C13 | 4307 | O | MT4 | 2015-02-08 00:00:00 |  | PROM
15116 | [NAME] | White | False | C13 | 4211 | O | CA1 | 2013-03-01 00:00:00 | 2015-02-07 00:00:00 | COYSTR
15116 | [NAME] | White | False | C16 | 4211 | O | CA1 | 2012-03-01 00:00:00 | 2013-02-28 00:00:00 | COYSTR
9709 | Estelle | [NAME] | False | C5 | 4238 | H | MT3 | 2013-02-28 00:00:00 |  | PROM
9709 | Estelle | [NAME] | False | C5 | 4238 | H | MT4 | 2012-08-21 00:00:00 | 2013-02-27 00:00:00 | HOLD
9709 | Estelle | [NAME] | False | C5 | 4145 | H | MT4 | 2011-09-25 00:00:00 | 2012-08-20 00:00:00 | STTFR
Spreadsheet: 866173d1713147187-in-spec-out-of-spec-formula-blank-grade-form
Sheet: Manual Form

Date
Product code
Brand
Product name
Run Number
Production Date
Records Complete Yes/No
If No, what action taken?
Length
Diameter/Width
Density
[NAME]
Dust
Coating
Cross Contamination
Appearance
Odour
Comments
Grade
Actions
Issued To/time frame
Conclusion
Comments
Density (g/l)
Length (mm)
Diam.\Width ([NAME])
Diam.\Height ([NAME])
ref
Spreadsheet: 32466d1228658534-complicated-sum-sum-help
Sheet: Sheet1

 | New Column
P-[PHONE]-[PHONE] | 1708 | 115.28 | 132.79
P-[PHONE]-[PHONE] | 1753 | 100.5
P-[PHONE]-[PHONE] | 1783
P-[PHONE]-[PHONE] | 1708 | 185.89
P-[PHONE]-[PHONE] | 1753 | 1765.45
Project Code | Total
P-[PHONE]-[PHONE] | 301.17
P-[PHONE]-[PHONE] | 1865.95
Spreadsheet: 878296d1725369180-auto-generated-id-column-for-self-referencing-table-with-power-query-self-ref-test
Sheet: Sheet1

 | Project Name | Location From Project Schedule | Ship Date |  |  |  | Project Name | Location From Project Schedule | Ship Date | Notes | Approved
 | 180930 - Willow St | BLDG B Level 1 | 2024-10-06 00:00:00 |  |  |  | 180930 - Willow St | BLDG B Level 1 | 2024-10-06 00:00:00 | Till Test 2 | True
 | 180930 - Willow St | BLDG A Level 6 | 2024-10-13 00:00:00 |  |  |  | 180930 - Willow St | BLDG A Level 6 | 2024-10-13 00:00:00
 | 201005 - Chestnut Ave | A.2 Islands | 2024-09-30 00:00:00 |  |  |  | 201005 - Chestnut Ave | A.2 Islands | 2024-09-30 00:00:00 |  | False
 | 201005 - Chestnut Ave | P2S4F4 - D.4 | 2024-10-08 00:00:00 |  |  |  | 201005 - Chestnut Ave | P2S4F4 - D.4 | 2024-10-08 00:00:00 |  | False
 | 211020 - Maple Creek | Area 3 (West) Level 4 | 2024-10-10 00:00:00 |  |  |  | 211020 - Maple Creek | Area 3 (West) Level 4 | 2024-10-10 00:00:00 |  | False
 | 220903 - Oak Hill Estates |  | 2024-09-23 00:00:00 |  |  |  | 220903 - Oak Hill Estates |  | 2024-09-23 00:00:00 |  | False
 | 2301 - River Bend Apartments | Level 6 East | 2024-10-11 00:00:00 |  |  |  | 2301 - River Bend Apartments | Level 6 East | 2024-10-11 00:00:00 |  | False
 | 2302 - Seaside Villas | Cube 4 Floor 3 | 2024-10-08 00:00:00 |  |  |  | 2302 - Seaside Villas | Cube 4 Floor 3 | 2024-10-08 00:00:00 |  | False
 | 2305 - Mountain View Retreat | Building 2 Level 3 | 2024-10-11 00:00:00 |  |  |  | 2305 - Mountain View Retreat | Building 2 Level 3 | 2024-10-11 00:00:00 |  | False
 | 2308 - Aspen Grove | 4th Floor | 2024-10-07 00:00:00 |  |  |  | 2308 - Aspen Grove | 4th Floor | 2024-10-07 00:00:00 |  | False
 | 2310 - Pine Ridge | 6th Floor Units (A) | 2024-09-23 00:00:00 |  |  |  | 2310 - Pine Ridge | 6th Floor Units (A) | 2024-09-23 00:00:00 |  | False
 | 2310 - Pine Ridge | 6th Floor Units (B) | 2024-09-25 00:00:00 |  |  |  | 2310 - Pine Ridge | 6th Floor Units (B) | 2024-09-25 00:00:00 |  | False
 | 2310 - Pine Ridge | 5th Floor Units (A) | 2024-10-07 00:00:00 |  |  |  | 2310 - Pine Ridge | 5th Floor Units (A) | 2024-10-07 00:00:00 |  | False
 | 2310 - Pine Ridge | 5th Floor Units (B) | 2024-10-09 00:00:00 |  |  |  | 2310 - Pine Ridge | 5th Floor Units (B) | 2024-10-09 00:00:00 |  | False