tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 782117d1653806981-using-xlookup-across-sheets-to-return-data-based-on-cell-testing-1-aligw
Sheet: QB

QB | Rankings
Player | Billy | [NAME] | Bright
Z
AB
AE
Spreadsheet: michelle_lokay__27347__EOLTWdeals
Sheet: EOLNov01

 |  |  |  |  | New This Week
 | PRODUCTION  MONTH : |  |  |  | 2001-11-01 00:00:00 |  |  |  | Transwestern Pipeline Company
 | Contract | Shipper |  | Non | Term | Term | Monthly | # |  | Demand | Demand | Commodity | Total | Monthly | Monthly | Total Monthly | NOTES
 | # |  | Daily | [NAME] | Start | End | Volume | Days | MDQ | Monthly $ | Daily $ | per [NAME] | Rate | Demand | Commodity | Revenue
 | Total Deals
 |  |  |  |  |  |  | MMBtu |  | MMBtu |  |  |  |  | Monthly Demand | Commodity | Total Revenue
Spreadsheet: 151710d1335076313-copying-data-from-sheet1-to-sheet2-based-on-criteria-for-copy-data-from-sheet1-to-sheet2-based-on-criteria
Sheet: Sheet2

Col # ►
Row # | Drawing no | spool no | joint no | [NAME] | size sch
Spreadsheet: 719969d1613934741-how-to-find-different-carracter-test-1-
Sheet: Sheet1

USA |  |  |  |  |  | Incorrect |  | Unique Incorrect
USA
USA
FRA
ENG
ENG
ENG
ENG
ENG
USA
USA
GGG
USA
USA
USA
FRA
ENG
ENG
Spreadsheet: 169520d1342914593-excel-2007-attendance-and-resource-allocation-spreadsheet-estate-attendence-wage-sheet-with-salary-pf-calculation
Sheet: Plotwise Data

Month | Plot # | April |  | May |  | 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
 | Work | No of works | Amount | No of works | Total | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works |  | No of works | Total | Total Works | Total Amount
April | 1
April | 2
April | 3
April | 4
April | 5
April | 6
April | 7
April | 8
April | 9
April | 10
April | 11
April | 12
April | 13
April | 14
April | 15
April | 16
April | 17
April | 18
April | 19
April | 20
April | 21
April | 22
April | 23
April | 24
April | 25
April | 26
April | 27
April | 28
April | 29
April | 30
April | 31
April | 32
April | 33
April | 34
Spreadsheet: 02e4b555-05a6-40f8-a00e-8401a50136eb
Sheet: 13b

 |  | Dealers** |  |  | Buyside |  |  | TOTAL
Product |  | HY*** | IG | Other | HY | IG | Other | HY | IG | Other
Index Tranche* | Asia |  | <100 | 440 |  | <100 |  |  |  | 440
 | Europe |  |  | 764750 |  |  | 83485 |  |  | 848235
 | North America | 108806 | 778082 | 17070 | 9138 | 23499 | 912 | 117943 | 801581 | 17982
Index | Asia | 3545 | 90862 | 162201 | 284 | 8986 | 34105 | 3829 | 99848 | 196307
 | Europe |  |  | 2993467 |  |  | 730268 |  |  | 3723735
 | North America | 273207 | 1448285 | 219570 | 123945 | 615444 | 39364 | 397152 | 2063729 | 258933
TOTAL |  | 385558 | 2317229 | 4157498 | 133366 | 647929 | 888133 | 518924 | 2965158 | 5045631
Estimated gross notional amount outstanding, February 8 weekly snapshot, by product type (millions of USD), all participant types, tenors and currencies.  Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for participant type descriptions.
***See Data Dictionary for product grade descriptions.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: kevin_ruscitti__20327__NGPL_StorageE_Test
Sheet: Pricing

Phys/Fin?: | Fin
Today's Date: | 1999-12-23 00:00:00
NGPL STX Index: | 0
NGPL LA Index: | 0
NGPL STX:
Price
Nymex |  | 2.3 | 2.325 | 2.32 | 2.31 | 2.325 | 2.34 | 2.36 | 2.39 | 2.41 | 2.43 | 2.555 | 2.675
Basis
Index
Total:
Libor:
PV Factor: | 1
PV Price:
Fuel %: | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017
Fuel Cost:
Injection Cost:
NGPL LA:
Price
Nymex |  | 2.29 |  |  |  | 2.3 | 2.335 |  | 2.385
Basis |  | -0.0475 |  |  |  | -0.065 | -0.055 | -0.055 | -0.055
Index
Total:
Libor:
PV Factor: | 1
PV Price:
Fuel %: | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017 | 0.017
Fuel Cost:
Injection Cost:
W/D Pricing:
NGPL/LA:
NPGL/STX:
Injection Pricing:
NGPL/LA:
NPGL/STX:
Spreadsheet: 111236d1307650614-too-many-ifs-two-criteria-and-nine-possible-outcomes-toomanyifs
Sheet: Sheet1

Too many IFs, two criteria, and nine possible outcomes
 |  |  |  | S |  |  |  |  | B
 |  |  |  | Scale Score |  |  |  |  | Scale Score
 |  |  |  | Overall |  |  |  |  | Overall
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | Probe |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | Probe |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | Probe
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | Probe |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | -50
 |  |  |  | Probe |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 50
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | -50
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | -50
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | 50 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 50
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | -50
 |  |  |  | -100 |  |  |  |  | Probe
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 100 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -50 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | -100 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
 |  |  |  | 0 |  |  |  |  | 0
Spreadsheet: 437986d1451658601-putting-data-in-another-worksheet-index_match-nrs-van-werkdagen-_-voor-jeroenmioch
Sheet: Alle dagen

Datum | nr1 | [NAME] | nr3 | nr4
2016-01-01 00:00:00 | 20 | 1 | 22 | 2
2016-01-02 00:00:00 | 18 | 16 | 3 | 6
2016-01-03 00:00:00 | 9 | 10 | 23 | 17
2016-01-04 00:00:00 | 19 | 20 | 9 | 2
2016-01-05 00:00:00 | 17 | 19 | 26 | 5
2016-01-06 00:00:00 | 24 | 10 | 8 | 5
2016-01-07 00:00:00 | 27 | 5 | 11 | 22
2016-01-08 00:00:00 | 7 | 12 | 5 | 10
2016-01-09 00:00:00 | 10 | 11 | 20 | 6
2016-01-10 00:00:00 | 22 | 2 | 12 | 23
2016-01-11 00:00:00 | 20 | 25 | 14 | 5
2016-01-12 00:00:00 | 26 | 19 | 3 | 28
2016-01-13 00:00:00 | 7 | 18 | 14 | 6
2016-01-14 00:00:00 | 10 | 13 | 20 | 13
Spreadsheet: 717193d1612527253-formula-for-data-validation-formule
Sheet: Foglio1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | data validation
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | ingl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Good morning | ita
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | benvenuto in | ingl
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | welcome to
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | buon lavoro
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | good job
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | oggi è
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | today is
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sign.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mr.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if ingl put the cells in English column S in column U  if ita put the cells in Italian column S in column U
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | se ingl metti in colonna U le celle in inglese colonna S se ita metti in colonna U le celle in italiano colonna S
Spreadsheet: 74158d1274735683-excel-2007-date-reference-returning-different-date-date-issue-sample
Sheet: Sheet1

DATE | Totals | Passthrough
2010-05-01 00:00:00 | 543263 | 347767
2010-05-02 00:00:00 | 630011 | 407989
2010-05-03 00:00:00 | 641582 | 401888
2010-05-04 00:00:00 | 536935 | 308999
2010-05-05 00:00:00 | 488262 | 270493
2010-05-06 00:00:00 | 375735 | 204983
2010-05-07 00:00:00 | 347448 | 182554
2010-05-08 00:00:00 | 418489 | 281776
2010-05-09 00:00:00 | 429233 | 305470
2010-05-10 00:00:00 | 333011 | 222525
2010-05-11 00:00:00 | 405822 | 228898
2010-05-12 00:00:00 | 609614 | 379522
2010-05-13 00:00:00 | 612162 | 344411
2010-05-14 00:00:00 | 539425 | 289476
2010-05-15 00:00:00 | 401625 | 211104
2010-05-16 00:00:00 | 484498 | 275758
2010-05-17 00:00:00 | 597702 | 354776
2010-05-18 00:00:00 | 552940 | 331013
2010-05-19 00:00:00 | 441770 | 280353
2010-05-20 00:00:00 | 115362 | 43103
2010-05-21 00:00:00 | 278183 | 161424
2010-05-22 00:00:00 | 394293 | 248901
Spreadsheet: 77931d1278423747-excel-2007-excel-formulae-wbds-new
Sheet: Deposits

Hart Hotels |  | Week Ending:
WBDS |  | Period:
Fife Arms |  | Week In Period:
 | [NAME] | Departure | Received | Received |  | Redeemed | Redeemed
Name | Date | Date | Date | £ |  | Date | £ |  | Balance
 | 2010-08-01 00:00:00 |  | 2010-08-01 00:00:00 | 100
 | 2010-08-04 00:00:00 |  | 2010-08-01 00:00:00 | 100
Totals:
Spreadsheet: ae54c9c7-a589-4391-a29f-004db30599b9
Sheet: Sheet1

Newly Reported Chronic Hepatitis B Virus (HBV) Infections,  by Selected Demographics, Maine 2011 and by Year, Maine 2007-2011 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | All |  | Male |  | Female
 |  | Number | Rate* | Number | Rate* | Number | Rate*
Maine Total |  | 105 | 7.905507352874743 | 70 | 10.76818708340576 | 35 | 5.161290322580645
Ethnicity
 | Hispanic | 2 | 11.13709767234659 | 1 | 11.09508487739931 | 1 | 11.1794298490777
 | Not Hispanic | 93 | 7.097990429161292 | 62 | 9.671632477965836 | 31 | 4.632535341761558
 | Unknown | 10 |  | 7 |  | 3
Race
 | American Indian or [NAME] | 0 | 0 | 0 | 0 | 0 | 0
 | Asian, Native Hawaiian or Pacific Islander | 26 | 177.2203667098357 | 13 | 201.8320136624748 | 13 | 157.958687727825
 | Black or African American | 35 | 208.2837419661985 | 24 | 255.291990213807 | 11 | 148.5884101040119
 | White | 36 | 2.839683312206616 | 26 | 4.194326366987426 | 10 | 1.543538593095443
 | Multiple races | 1 | 4.975867044832562 | 1 | 10.04419445560466 | 0 | 0
 | Unknown | 7 |  | 6 |  | 1
Age Group (yrs)
 | 0-4 | 0 | 0 | 0 | 0 | 0 | 0
 | 5-14 | 1 | 0.6608380748465204 | 1 | 1.286968160407712 | 0 | 0
 | 15-24 | 10 | 6.018694063762045 | 8 | 9.404683532399135 | 2 | 2.466547450206573
 | 25-44 | 58 | 18.58360861638626 | 34 | 22.07749199690915 | 24 | 15.18026565464896
 | 45-64 | 31 | 7.47524728600296 | 24 | 11.82184479888087 | 7 | 3.306753335096936
 | 65+ | 5 | 2.312480922032393 | 3 | 3.139126067302863 | 2 | 1.657687525901367
10-Year Trend
 | 2007 | 139 | 10.55263143909803 | 91 | 14.15683596271929 | 48 | 7.117353293555237
 | 2008 | 142 | 10.78653597233785 | 93 | 14.47766003652106 | 49 | 7.269091378412578
 | 2009 | 126 | 9.557756536633136 | 75 | 11.65356288262531 | 51 | 7.558679809876971
 | 2010 | 101 | 7.603354810928656 | 73 | 11.22980174015777 | 28 | 4.12793654771821
 | 2011 | 105 | 7.905507352874743 | 70 | 10.76818708340576 | 35 | 5.161290322580645
* Rate = number of cases per 100,000 population using the corresponding year census estimate as the denominator.
† Data prior to 2007 are not released due to data quality concerns.
Spreadsheet: 717902d1612892614-iferror-vlookup-query-iferror-question-df
Sheet: ATO Form

 | Amendments to Order
 | Order No:-
 | Customer Name:-
 | Address
 | Postcode:
 | [NAME]. No:
 | Mobile:
 | [NAME]:
 | Summary of Changes
 | Details of Changes with Costs
 | Drawing Showing Changes:
 | In the minority of cases, the original cost and allocated time of installation may have to be altered once work has commenced, due to unforeseen items (see [NAME]) such as hidden or damaged pipework, valves, or replacement of floor boarding (please refer to our Terms and Conditions detailing what is not covered in the original price). Additionally if the Client decides to change the design or product(s) to those different from the original order after work has commenced then this may alter the cost and length of time required to complete the installation.  We will inform you if we need to correct unforeseen items in order to continue with the installation and agree any amendments to the costs of products or labour and ask that you, along with an employee of   AHM Installations sign this form in order to proceed with the work as soon as possible.  Initial Surveyor Installation time estimations are based on company standardised working patterns    founded on a series of quantifiable tasks undertaken to finish the work. This assessment does not however take into account all of the individual nuances of a property and does not represent the  differences in fitting time that may occur between differing fitters carrying out works  Given this situation the fixed and final price submitted to clients on bathroom sales orders represents a    risk to the installers and therefore AHM will not accept discount claims for jobs taking a longer or shorter    time than has been estimated.
 | Signed (Customer):  __________________________________________________ |  |  |  | Dated:   __________________________________
 | Signed (AHM):  ______________________________________________________
Spreadsheet: 849787d1700172765-interval-staffing-formula-not-working-correctly-when-shifts-cross-midnight-interval-template
Sheet: Staff by Hour

 |  |  |  | Within a day | Over midnight
 |  |  |  | Staff | Pre midnight | Post midnight
 | 00:00:00
 | 01:00:00
 | 02:00:00
 | 03:00:00
 | 04:00:00
 | 05:00:00
 | 06:00:00
 | 07:00:00
 | 08:00:00
 | 09:00:00
 | 10:00:00
 | 11:00:00
 | 12:00:00
 | 13:00:00
 | 14:00:00
 | 15:00:00
 | 16:00:00
 | 17:00:00
 | 18:00:00
 | 19:00:00
 | 20:00:00
 | 21:00:00
 | 22:00:00
 | 23:00:00
Spreadsheet: 164784d1340891663-how-to-get-specific-information-from-data-trial_grm
Sheet: Pivot Table

Employee | Type of Product | Skill Level
C Echeverri
 | Analytical Instrumentation
 |  | Trained
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
E Alahyane
 | Analytical Instrumentation
 |  | Expert
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
F Amirouche
 | Analytical Instrumentation
 |  | Expert
 |  | Trained
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
G Labrie
 | Analytical Instrumentation
 |  | Trained
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
N Simard
 | Analytical Instrumentation
 |  | Expert
 |  | Trained
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
P Fortin
 | Analytical Instrumentation
 |  | Expert
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
S Chevrette
 | Analytical Instrumentation
 |  | Expert
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
 | Transmitters
 |  | Expert
S Sava
 | Controllers
 |  | Needs Trained
 |  | Trained
 | Debitmetre
 |  | Trained
 | [NAME]
 |  | Needs Trained
Grand Total
Spreadsheet: lindy_donoho__21962__2002 BLANCO HUB BUDGET
Sheet: 2002 HUB COMB

[NAME] (COMBINED)
2002 O&M BUDGET
 |  |  |  |  |  |  |  | SALARIES AND WAGES - 000 |  |  |  |  | EMPLOYEE EXPENSES - 050
 |  |  |  |  |  | SALARIES | TAXES/BENEFITS | TOTAL | 2001 EMPL | STAFF ADDS | 2002 EMPL |  | SMNR/SCHL | DUES | BUSINESS | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 62376 | 16049 |  | 1 | 0 |  |  | 0 | 0 | 5691
 | GAS CONTROL - ATTACHMENT #2 |  |  |  |  | 88862 | 23993 |  | 1.6 | 0 |  |  | 0 | 0 | 1552
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 41060 | 11219 |  | 0.76 | 0 |  |  | 0 | 0 | 1863
 |  |  | TOTAL
 |  |  |  |  |  |  | COMPANY EQUIP USE - 100 |  |  |  | SUPPLIES AND EXPENSES - 150
 |  |  |  |  |  | NUMBER | EXPENSE | POOL CAR | TOTAL |  | CHEMICALS | ELECT POWER | OTHERS | ENVIRON | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 0 | 4590 | 0 |  |  | 0 | 28688 | 25556 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  | OUTSIDE SERVICES - 200 |  |  |  |  | RENTS - 250
 |  |  |  |  |  | CNTRCTS | TMPRR | OTHERS | TOTAL |  | EQP | WRHS | OTHERS | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 18670 | 0 | 0 |  |  | 1147 | 0 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  | COMPUTER SERVICES - 600 |  |  |  |  | TOTAL | TOTAL | BUDGET
 |  |  |  |  |  | PC'S | CMNCTN | TOTAL |  |  | P/R | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 1147 | 0
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 0 | 2070
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  | NUMBER OF |  |  | SALARIES | EMPLOYEE | COMPANY | SUPPLIES | OUTSIDE |  | COMPUTER | TOTAL
 |  | GROSS |  |  |  | EMPLOYEES | TAXES/BENEFITS |  | & WAGES | EXPENSES | EQP USE | EXPENSES | SERVICES | RENTS | SERVICES | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS - ATTACHMENT #1 |  |  |  |  | 1
 | GAS CONTROL - ATTACHEMENT #2 |  |  |  |  | 1.6 |  |  |  |  | 0 | 0 | 0 | 0
 | MARKET SERVICES - ATTACHMENT #3 |  |  |  |  | 0.76 |  |  |  |  | 0 | 0 | 0 | 0
 | TOTAL GROSS
 | TRANSWESTERN OPERATIONS/GAS CONTROL/MARKET SERVICES (36.19%) $ 121,068
 | PNM (27.62%) $ 92,398
 | (15%) OVHD:   $ 13,860
 | TOTAL:           $106,258
 | NWPL (36.19%) $ 121,067
 | (15%) OVHD:     $   18,160
 | TOTAL:              $ 139,227
Spreadsheet: 27651d1221070899-subtotal-by-item-in-a-pivottable-pivot-by-item
Sheet: PivotTable

What I can get now... |  |  |  |  | What I want to see...
Sum of Amount |  |  |  |  | Sum of Amount
Business | Subgroup | Month | Total |  | Business | Subgroup | Month | Total
1 | A | January | 52 |  | 1 | A | January | 52
 |  | February | 77 |  |  |  | February | 77
 |  | March | 70 |  |  |  | March | 70
 | B | January | 22 |  |  | B | January | 22
 |  | February | 12 |  |  |  | February | 12
 |  | March | 49 |  |  |  | March | 49
 | C | January | 93 |  |  | C | January | 93
 |  | February | 33 |  |  |  | February | 33
 |  | March | 85 |  |  |  | March | 85
1 Total |  |  | 493 |  | January Total |  |  | 167
2 | D | January | 37 |  | February Total |  |  | 122
 |  | February | 56 |  | March Total |  |  | 204
 |  | March | 53 |  | 2 | D | January | 37
 | E | January | 86 |  |  |  | February | 56
 |  | February | 16 |  |  |  | March | 53
 |  | March | 93 |  |  | E | January | 86
 | F | January | 34 |  |  |  | February | 16
 |  | February | 30 |  |  |  | March | 93
 |  | March | 94 |  |  | F | January | 34
2 Total |  |  | 499 |  |  |  | February | 30
3 | G | January | 87 |  |  |  | March | 94
 |  | February | 2 |  | January Total |  |  | 157
 |  | March | 84 |  | February Total |  |  | 102
 | H | January | 93 |  | March Total |  |  | 240
 |  | February | 11 |  | 3 | G | January | 87
 |  | March | 89 |  |  |  | February | 2
 | I | January | 21 |  |  |  | March | 84
 |  | February | 3 |  |  | H | January | 93
 |  | March | 11 |  |  |  | February | 11
3 Total |  |  | 401 |  |  |  | March | 89
 |  |  |  |  |  | I | January | 21
 |  |  |  |  |  |  | February | 3
 |  |  |  |  |  |  | March | 11
 |  |  |  |  | January Total |  |  | 201
 |  |  |  |  | February Total |  |  | 16
 |  |  |  |  | March Total |  |  | 184
Spreadsheet: 779277d1651677205-using-concat-and-sunif-for-two-different-columns-rd-build-up
Sheet: R & S

ROAD FINAL SURFACING
 |  |  | this description needs to add a CONCAT for the wearing  finish | this quantity needs to differentiate between the thickness but also the finish
 |  |  | so this should be "30mm thick wearing course, [NAME]" | the quantity should be 173
 |  |  | so this should be "30mm thick wearing course, HRA Black chip" | the quantity should be 290
 |  |  | etc down  for the different build up thicknesses, but also the finish
Spreadsheet: mary_fischer__25636__31S
Sheet: E1.XLS 

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031S
COMPANY NAME   Limbach Company
ANALYSIS OF A/R - OTHER
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:  Sonya City
EXTENSION:  3 9690 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
 |  | 12-31-2000 Balance
 |  | BEGINNING |  | OTHER |  | 03-31-2001 |  | OTHER |  | 06-30-2001 |  | OTHER |  | 09-30-2001 |  | OTHER |  | 12-31-2001
[NAME] |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE |  | CHANGES |  | BALANCE
 |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVDUAL ITEMS
IN EXCESS OF $200,000.)
Accts Receivables - Unconsolidated Assoc Companies:
Total (Hyperion line 0053)
Asset/Expense Accts:  DR/(CR)
Accts Receivables - Other:
Total (Hyperion line 0060)
Asset/Expense Accts:  DR/(CR)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-1
Spreadsheet: 810169d1671583461-combine-data-in-2-rows-into-1-single-row-afl_data_4_rows-merge
Sheet: Output

 | Team Name |  | Result |  | PREPLAY_LAST_TRADED_PRICE |  | PREPLAY_MIN_PRICE |  | PREPLAY_MAX_PRICE |  | INPLAY_MIN_PRICE |  | INPLAY_MAX_PRICE
Date | T1 | T2 | T1 result | T2 result | P_LTP T1 | P_LTP T2 | P_MIN T1 | P_MIN T2 | P_MAX T1 | P_MAX T2 | I_MIN T1 | I_MIN T2 | I_MAX T1 | I_MAX T2
2018-03-03 00:00:00 | Hawthorn | Western Bulldogs | L | W | 2.12 | 1.89 | 2 | 1.67 | 2.46 | 1.89 | 1.64 | 1.05 | 4 | 1.34
Spreadsheet: 132953d1324053349-cannot-get-microsoft-query-to-work-on-excel-files-data-tables
Sheet: Sls Class

Code | Sales Class
BB | Bid Business Only
BOD | Bodega
CD | Cheese Distributor
CLUB | Club
COOP | Co-Operative
DELI | Deli
DRG | Drug Stores
EXP | Exporter
FD | Food Distributor
FM | Food Manufacturer
FSD | Food Service Distributor
IMP | Importer
IND | Industrial
INS | Institution (School, Prison, Hospital, Etc)
MD | Meat Distributor
MSC | Miscellaneous
OOB | Out of Business
P | Provisioner
PD | Pizza Distributor
REDS | Re-Distributor
REST | Restaurant
SAL | Salvager
SC | Ships [NAME]
SD | Speciality Distributor
SMR | Salad Maker
SRA | Speciality Retail Account
SUPE | Supermarket
TRD | Trader
WH | WholeSaler
ZZZZ | Un-Assigned