tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 168815d1342597487-code-for-matching-the-data-value-from-two-spreadsheets-if-a-match-then-append-data-buildingtopoedited
Sheet: Description of File

What has been defined based on the: | Denwick_IPSA2_20kV_V0.8.i2f file
Recordings Used based on the: | ENMAC Printout Denwick_RiseCarr.pdf
Definitions:
Define System Network
Define System Version
Define System Scene
Define System SceneData
Define System SceneVersion
Define System SceneView
Define System AnalysisFL
Define System AnalysisLF
Define System AnalysisHM
Define System AnalysisProt
Define System AnalysisTS
Define System Results Display
Define System Results Display LF
Define System Results Display FL
Define System Results Display HM
Define System BusbarGraphic
Define System RadialGraphic
Define System BranchGraphic
Define System BreakerGraphic
Define System GroupGraphic
Define System Automation
Define System Study
Define System Intertrip
Define System Contingency
Define System Annotation
Define System AVR
Define System Breaker
Define System Busbar
Define System Governor
Define System Generator
Define System Grid Infeed
Define System Filter
Define System Harmonic
Define System IndMachine
Define System Line
Define System Load
Define System MechSwCap
Define System StaticVC
Define System Transformer
Define System Umachine
Define System Battery
Define System DCMachine
Define System Converter
Define System ConverterACC
Define System ConverterDCC
Define System DCMachineCtl
Define System MGSet
Define System Group
Define System GroupLoadScale
Define System Representing
Selected other Parameters (3.2.7)
Optimum Power Flow Parameters (3.2.8)
Spreadsheet: 731662d1620491395-help-with-formula-average-with-large-with-sumifs-average-of-top-3-values-excel-lent13-
Sheet: Rate Data

ClientName | ProjName | ProductLine | FeeRev | [NAME] | [NAME] | FeeRev Rank |  | Client | Product Line | [NAME]
Client 1 | Project 1 | ABC | 0 | 0 |  |  |  | Client 1 | ABC
Client 2 | Project 2 | DEF | 4471.53 | 3.75 |  |  |  | Client 1 | DEF
Client 2 | Project 3 | DEF | 27.5 | 0.5 |  |  |  | Client 2 | DEF
Client 1 | Project 4 | ABC | 5331.33 | 288 |  |  |  | Client 3 | X
Client 5 | Project 5 | DEF | 9746.44 | 200.25 |  |  |  | Client 5 | DEF
Client 1 | Project 6 | DEF | -2008.78 | 0 |  |  |  | Client 5 | ABC
Client 1 | Project 7 | ABC | -165.03 | 0
Client 1 | Project 8 | DEF | 7486.57 | 10
Client 1 | Project 9 | ABC | 0 | 0
Client 1 | Project 10 | DEF | 111 | 61.25
Client 5 | Project 11 | DEF | 3413.22 | 46.5
Client 5 | Project 12 | DEF | 1754.68 | 91.25
Client 1 | Project 13 | X | 1267.42 | 2
Client 3 | Project 14 | X | 943.25 | 10.5
Client 3 | Project 15 | X | 38485.29 | 309.5
Client 3 | Project 16 | X | 3279.15 | 0
Client 5 | Project 17 | ABC | 322.46 | 0
Client 5 | Project 18 | ABC | 91944.72 | 901.25
Spreadsheet: john_zufferli__16715__HedgeSummary
Sheet: Sheet1

 | CONFIDENTIAL:  PPA - POWER AND GAS POSITIONS:
 |  |  |  |  |  |  |  |  | Current to | Hedgeable | Current |  | AECO
 |  |  |  |  | Power Price | Aeco Gas Price | Heat Rate | Jan 11/2001 | Beg. Year | Volume | Gas Hedges |  | Hedge
 |  | Power (MWh) | Discount Days | Power (MW) | ($/MWh) | ($[NAME]) | (GJ/MWh) | Heat Rates | HR Delta | (cont/day) | (cont/day) | % Hedged | (cont/day)
2002-01-01 00:00:00 | Cal 2002 |  |  |  |  |  |  | 14.25
2003-01-01 00:00:00 | Cal 2003 |  |  |  |  |  |  | 12.03
2004-01-01 00:00:00 | Cal 2004 |  |  |  |  |  |  | 8.9
2005-01-01 00:00:00 | Cal 2005 |  |  |  |  |  |  | 9.06
2006-01-01 00:00:00 | Cal 2006 |  |  |  |  |  |  | 7.5
2007-01-01 00:00:00 | Cal 2007 |  |  |  |  |  |  | 7.02
2008-01-01 00:00:00 | Cal 2008 |  |  |  |  |  |  | 7.09
2009-01-01 00:00:00 | Cal 2009 |  |  |  |  |  |  | 7.1
2010-01-01 00:00:00 | Cal 2010 |  |  |  |  |  |  | 7.14
2011-01-01 00:00:00 | Cal 2011 |  |  |  |  |  |  | 7.11
2012-01-01 00:00:00 | Cal 2012 |  |  |  |  |  |  | 7.08
2013-01-01 00:00:00 | Cal 2013 |  |  |  |  |  |  | 7.04
2014-01-01 00:00:00 | Cal 2014 |  |  |  |  |  |  | 7.03
2015-01-01 00:00:00 | Cal 2015 |  |  |  |  |  |  | 7
2016-01-01 00:00:00 | Cal 2016 |  |  |  |  |  |  | 7
2017-01-01 00:00:00 | Cal 2017 |  |  |  |  |  |  | 7
2018-01-01 00:00:00 | Cal 2018 |  |  |  |  |  |  | 7
2019-01-01 00:00:00 | Cal 2019 |  |  |  |  |  |  | 7
2020-01-01 00:00:00 | Cal 2020 |  |  |  |  |  |  | 7
 | Total
 | Note: Power position is 710MW * Availability factor (of 81-87%) - 9% transmission losses - hedges
Spreadsheet: 24894d1215788068-putting-text-in-a-referenced-cell-wallchart
Sheet: Existing Wall

-  -  -  -
Finish   - Finish Color - Brownstone - 3G
Finish   - Finish Color - Dune - 7L
Finish   - Finish Color - Chai - 7m
Finish   - Finish Color - Grass - 7N
Finish   - Finish Color - Blue Ridge - 7U
Finish   - Finish Color - Loden - 7V
Finish   - Finish Color - Napa - 7W
Finish   - Finish Color - Sedona - 7Y
Finish   - Finish Color - Mink - 7Z
Finish   - Finish Color - Folkstone Grey - 8Q
Finish   - Finish Color - Gull - 8T
Finish   - Finish Color - Moonbeam - 8Y
Finish   - Finish Color - White - 91
Finish   - Finish Color - Sparrow - 9J
Finish   - Finish Color - Blue Medium - B4
Finish   - Finish Color - Black - BK
Finish   - Finish Color - Stonewash - BQ
Finish   - Finish Color - Black Umber - BU
Finish   - Finish Color - Chrome/Polished Aluminum - CD/CH/L/PA
Finish   - Finish Color - Cool Grey Neutral - CL
Finish   - Finish Color - Metallic Champagne - CN
Finish   - Finish Color - Metallic Bronze - EH
Finish   - Finish Color - Graphite - G1
Spreadsheet: 219884d1363003901-column-to-row-calcualtion-column-to-row-calculation
Sheet: Sheet1

 | Customer | Product | Qty |  |  |  | Result: |  | Customer | Product | Qty | Product | QTY | Product | QTY
 | A | ABC | 36 |  |  |  |  |  | A | ABC | 36 | WFG | 23 | FDG | 7
 | A | WFG | 23 |  |  |  |  |  | B | IHJ | 6 | EFG | 6 | RTS | 3
 | A | FDG | 7 |  |  |  |  |  | C
 | B | IHJ | 6 |  |  |  |  |  | D
 | B | EFG | 6
 | B | RTS | 3
 | C | FGGGG | 35
 | C | HIJ | 21
 | C | AZS | 13
 | D | ABN | 59
 | D | QWE | 12
 | D | XYZ | 10
Spreadsheet: 769320d1645466687-pull-data-based-on-date-and-name-2-variables-index-match-or-vlookup-example-tip-tracker
Sheet: Cash Owed

Date | Totals | [NAME]
Totals/Mo
2022-03-01 00:00:00 |  |  |  | Goal: In column C, look up "Jane-OWED" and date to pull corresponding value from 'Data Entry' sheet.
2022-03-02 00:00:00
2022-03-03 00:00:00 |  |  |  |  | INDEX/MATCH?
2022-03-04 00:00:00 |  |  |  |  | VLOOKUP?
2022-03-05 00:00:00
2022-03-06 00:00:00
2022-03-07 00:00:00
2022-03-08 00:00:00
2022-03-09 00:00:00
2022-03-10 00:00:00
2022-03-11 00:00:00
2022-03-12 00:00:00
2022-03-13 00:00:00
2022-03-14 00:00:00
2022-03-15 00:00:00
2022-03-16 00:00:00
2022-03-17 00:00:00
2022-03-18 00:00:00
2022-03-19 00:00:00
2022-03-20 00:00:00
2022-03-21 00:00:00
2022-03-22 00:00:00
2022-03-23 00:00:00
2022-03-24 00:00:00
2022-03-25 00:00:00
2022-03-26 00:00:00
2022-03-27 00:00:00
2022-03-28 00:00:00
2022-03-29 00:00:00
2022-03-30 00:00:00
2022-03-31 00:00:00
Spreadsheet: 173838d1344804580-excel-slow-to-respond-aug-11-tms
Sheet: HO-DAA

 |  |  |  |  |  |  |  |  | 2012-08-11 00:00:00
 | VEHICLE  UTILIZATION SUMMARY |  |  |  | VEHICLE STATUS BY TYPE
 |  |  |  | ACTUAL |  |  |  |  | 3RD PARTY | IDLE | VOR
 | DEPLOYED |  | BE | 0 |  | CONTRACT | DEPLOYED | SPOTHIRE | 3RD PARTY | IDLE | VOR
 | STANDBY |  | SB | 0 | OILFIELD | 12 | 0 | 0 | 0 | 0 | 0
 |  |  | YD | 0 | WINCH TRUCK | 25 | 0 | 0 | 0 | 0 | 0
 |  |  | SH | 0 | NON WINCH TRUCK | 13 | 0 | 0 | 0 | 0 | 0
 | THIRD PARTY |  | TP | 0 | HIAB TRUCK | 6 | 0 | 0 | 0 | 0 | 0
 | VEHICLE IDLE |  | VI | 0 | FUEL TANKER | 3 | 0 | 0 | 0 | 0 | 0
 | VEHICLE OFF ROAD |  | VOR | 0 | VACUUM TANKER | 1 | 0 | 0 | 0 | 0 | 0
 | VEHICLE REFURBISHED |  | VR | 0 | LOWBED | 4 | 0 | 0 | 0 | 0 | 0
 | VEHICLE OWN USE |  | VOU | 0 | 50T CRANE | 4 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | 70T CRANE | 4 | 0 | 0 | 0 | 0 | 0
 | Total |  |  | 0 | FORKLIFT | 6 | 0 | 0 | 0 | 0 | 0
 | DEPLOYED TO BE |  |  | 0 | TOTAL | 78 | 0 | 0 | 0 | 0 | 0
SN | ASSET # | OILFIELDS | STATUS | FLEET | DPLMNT | [NAME] | ACTIVITY | DRIVER | COMMENTS
1 | 544 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
2 | 545 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
3 | 546 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
4 | 547 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
5 | 548 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
6 | 549 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
7 | 550 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
8 | 551 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
9 | 552 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
10 | 553 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
11 | 554 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
12 | 555 | 0 | 0 | 0 | -- | 0 | 0 |  | 0
Spreadsheet: 810339d1671705525-ifs-or-maxifs-formula-help-required-ifs-or-maxifs-test-file
Sheet: Sheet1

Row Labels | Cancelled | Completed | Ext-Eval-Inprocess | Ext-Eval-Pending | Int-Appr-Inprocess | Int-Appr-Pending | Int-Eval-Inprocess | Int-Eval-Pending | Grand Total
Supplier 1 |  | 2 |  |  |  | 3 |  | 1 | 6
Supplier 2 | 5 |  |  | 5 |  |  |  | 1 | 11
Supplier 3 |  |  | 1 | 1 |  |  | 33 | 22 | 2
Spreadsheet: 86b6916e-0353-469f-a2c6-06a451323b64
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42253453 | 2014-07-11 12:37:23 | AXIS | 1 | 6 | 4 | 243582 | Vercingetorix1302 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42253664 | 2014-07-11 13:00:31 | ALLIES | 1 | 6 | 4 | 243582 | Vercingetorix1302 | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42255420 | 2014-07-11 16:19:34 | ALLIES | 0 | 3 | 5 | 642023 | [NAME] | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
42255912 | 2014-07-11 16:43:11 | AXIS | 0 | 3 | 5 | 642023 | [NAME] | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
Spreadsheet: 809304d1671021425-need-correct-formula-to-pull-specific-data-from-a-list-payees-mortage-amount-exp
Sheet: Sheet1

 | (Mortgage) , (Property) , (Equip. Maint.)      YEAR - |  | 2022
 | Choose Month Below | YEAR TO DATE  ----> |  |  | MORTGAGE PAYMENTS FOR THE YEAR
 |  | MONTHLY AVERAGE  ----> |  |  | CURRENT MORTAGE PAYMENT
 |  | CURRENT MONTH  ---->
 | 2022-10-01 00:00:00 | <--------Amount Spent During Selected Month-------->
 | DATE | Decription | AMOUNT
 | 2022-01-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-01-22 00:00:00 | Home Depot (New Freedom, PA) | 207.78
 | 2022-02-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-02-04 00:00:00 | Home Depot (Bel Air, MD) | 16.81
 | 2022-02-11 00:00:00 | Home Depot (New Freedom, PA) | 81.67
 | 2022-02-25 00:00:00 | Home Depot (New Freedom, PA) | 15.88
 | 2022-03-01 00:00:00 | Wells Fargo Mortage | 790.06
 | 2022-03-03 00:00:00 | Home Depot (Bel Air, MD) | 76.26
 | 2022-03-07 00:00:00 | Home Depot (Internet Purchase, GAUS) | 9.52
 | 2022-03-09 00:00:00 | Home Depot (Internet Purchase, GAUS) | 7.15
 | 2022-03-09 00:00:00 | Home Depot (Internet Purchase, GAUS) | 25.41
 | 2022-03-10 00:00:00 | Home Depot (Internet Purchase, GAUS) | 8.4
 | 2022-03-21 00:00:00 | Home Depot (New Freedom, PA) | 51.77
 | 2022-03-22 00:00:00 | Home Depot (Bel Air, MD) | 39.99
 | 2022-03-23 00:00:00 | Home Depot (Bel Air, MD) | 90.01
 | 2022-03-24 00:00:00 | Home Depot (Internet Purchase, GAUS) | 75.43
 | 2022-03-27 00:00:00 | Home Depot (New Freedom, PA) | 12.47
 | 2022-03-27 00:00:00 | Home Depot (Internet Purchase, GAUS) | 31.74
 | 2022-04-01 00:00:00 | Wells Fargo Mortage | 790.06
Spreadsheet: 007e59d2-27c3-4e33-8f57-82a2ee0b8648
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
ONE-YEAR COURSE ELIGIBILITY TEMPLATE
[NAME] should be self verified by reviewing the course decriptions on the eligibility section.
Upon application, you must have either completed five of the seven required courses, or indicate to Admissions which courses will be completed prior to enrollment.  If six of the seven courses are not complete prior to matriculation, Kellogg reserves the right to rescind the offer of admission.
Please note that work experience or training will not meet course requirements.
 | Your Name:
Requirement | Course Title | Grade | Year Course Completed | University | Course Description (you may include link to University website)
ACCOUNTING
[NAME]
FINANCE
MARKETING
OPERATIONS
ORGANIZATIONAL BEHAVIOR
STATISTICS
Spreadsheet: cd3856dc-c491-4be6-91f7-8ac9a8cd8f0b
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Inter-Company | 603967126921 | [NAME] | Panic | 2005-06-14 | Compact Disc | Rock | 12.99 | N | To Be Retired
Spreadsheet: 546891d1510246683-combining-18-columns-into-5-columns-sample-marksheet
Sheet: Sheet1

NAME | ENGLISH | FRENCH | MATHS | ADD MATHS | ACCOUNTS | [NAME] | COMPUTER | PHYSICS | BIOLOGY | CHEMISTRY | DC | DT | ENTERPRISE | TRAVEL N TOURISN | AL | ART | FRENCH LIT | ENGLISH LIT | SOCIOLOGY | PHYSICAL EDUCATION | BUSINESS ST |  | ENGLISH | FRENCH | MATHS | subject 1 name | subject 1 marks | subject 2 name | subject 2 marks | subject3 name | subject 3 marks | subject 4 name | subject 4 marks | subject 5 name | subject 5 marks
BHOOBUN Ivans Madun | 45 | 55 | 40 | 60 |  |  | 10 | 50 |  |  |  | 72 |  |  | 78 |  |  |  |  |  |  |  | 45 | 55 | 40 | add maths | 60 | computer | 10 | physics | 50
BHUDDOO Anikesh Anand | 56 | 25 | 46 | 84 |  |  | 15 | 40 |  |  | 0 |  |  |  |  | 25 |  |  |  |  |  |  | 56 | 25 | 46 | add maths | 84 | computer | 15 | physics | 40
[NAME] | 49 | 62 | 34 |  | 72 | 40 | 20 |  |  |  |  |  |  |  | 62 | 50 |  |  |  |  | 31 |  | 49 | 62 | 34 | accounts | 72 | economics | 40 | computer | 15
BURKATALLY Fardeen | 51 | 52 | 62 | 81 |  | 25 |  | 52 |  |  |  | 70 |  |  |  | 50 |  |  |  |  |  |  | 51 | 52 | 62 | add maths | 81 | economics | 25
CHAMPA Heeman | 56 | 61 | 54 |  |  |  | 30 |  |  |  |  |  |  | 34 | 46 | 40 | 57 |  |  |  | 50 |  | 56 | 61 | 54 | computer | 30 | traveln tou | 34
CHATTUN Lokeshwar | 49 | 63 | 45 |  |  |  | 35 |  |  |  |  |  |  | 41 |  | 44 | 53 |  |  |  |  |  | 49 | 63 | 45 | computer | 35
[NAME] | 44 | 52 | 29 | 34 |  |  | 40 | 54 |  | 48 |  | 43 |  |  |  |  |  |  | 9 |  |  |  | 44 | 52 | 29 | computer | 40
GHOORAHOO [NAME] | 74 | 63 | 91 | 100 | 94 | 75 | 45 |  |  |  |  |  |  |  |  |  |  |  |  |  | 68 |  | 74 | 63 | 91 | add maths | 100
GUNNOO Kheshav | 49 | 44 | 35 |  |  |  | 50 |  |  |  |  |  |  | 36 |  | 40 | 55 |  |  |  |  |  | 49 | 44 | 35 | computer | 50
HEATHY [NAME] | 40 | 63 | 41 | 44 |  | 55 |  | 61 |  |  |  | 44 |  |  |  | 50 |  |  |  |  |  |  | 40 | 63 | 41 | add maths | 44
IMRIT [NAME] | 36 | 67 | 26 | 70 |  |  | 60 | 58 |  |  |  | 44 |  |  |  |  |  |  |  |  |  |  | 36 | 67 | 26 | add maths | 70
JAUNKY [NAME] | 49 | 52 | 63 |  | 67 |  |  |  |  |  |  |  |  | 42 |  | 58 | 57 |  | 37 |  |  |  | 49 | 52 | 63 | accounts | 67
[NAME] ZubeÏr K. M. | 41 | 63 | 26 |  |  |  | 70 |  |  |  |  |  |  | 17 |  | 46 | 58 |  | 31 |  |  |  | 41 | 63 | 26 | computer | 70
KHEDOO Kenny | 59 | 61 | 45 | 60 |  |  | 75 | 67 |  | 33 |  | 67 |  |  | 54 |  |  |  |  |  |  |  | 59 | 61 | 45 | add maths | 60
Spreadsheet: 741381d1627008623-formula-to-look-into-sheet-named-here-and-extract-values-into-columns-in-sheet-named-output-extract-values-into-desired-columns-ans-4
Sheet: OUTPUT

 |  |  |  | Section I |  |  | Section II |  |  | Section III
S/N | Name + Unique # | Name | Sales # | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | Sales Code | Sales #-1 | Sales #-2 | NOTE
 |  |  |  |  |  |  |  |  |  |  |  |  | Further sections can be extended without change of formula
Spreadsheet: 140355d1328716209-excel-2007-looking-for-help-with-if-statement-to-add-multiple-cells-copy-of-weekly-template-for-business-1
Sheet: Instructions

Beginning of the Day
The cells highlighted in yellow are the cells which need data entered into
Enter the date in the Monday Sheet Cell A1. Do not enter dates on other sheets. It is automatic
Rename each sheet using the following format |  |  |  |  | Mon 1/25 | [NAME] 1-26
Count the cash in the drawer at beginning of day and enter it in Cell E1.
List all employees who work this week starting in cell A24
Select cells A24-A32 then copy. Select the tabs of all the other sheets for the week.
Click on [NAME] sheet and select cell A24. Paste. It will paste all the mployees into the correct cells for the rest of the week.
be sure to de-select the other sheets by clicking on another sheet such as the weekly summary
Enter in the starting counter for the day from the equipment room in cell I1
Dollar amounts for the discounts and [NAME] redeemed MUST be entered in as a negative amount
When entering the times IN and OUT. Please type using the following format |  |  |  |  |  |  |  | 11:00:00 | 16:30:00
End of the Day
Enter the ending wash counter in cell I2
Enter the time in and time out for all employees
Using CR+ print out the report showing a list of receipts for the day. Ensure that all receipts are included with the paperwork.
Using CR+ print out report of the tips that were wrung up. Print out a summary from the CC machine. Ensure that all tips match.
Using CR+ print a report showing the CC payments and compare to the CC batch to ensure that al CC payments were entered into CR+
Make sure that all paid outs have been entered into [NAME], Self Serve Refunds, expenses.
Using [NAME] reports button print out the daily summary for verification.
Remove tips from the cash drawer and place in cash bag for disbursement the next day.
separate the tickets to count tickets and dollars for each type of wash and other items.
Enter the appropriate numbers  on the sheet and match the numbers listed on the daily summary.
Use the SCRATCH area to talley the different typoes of washes and dollars
Use the scratch sheet to enter and count the currancy from the drawer
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: OCT

DATES: | DAY: | BOARD  £: | PAID (Y or N) | REASON FOR UNPAID? | DATE of UNPAID to be PAID? | NOW PAID  (Y or N) | UNPAID totals
1st | MON |  |  |  |  |  | 0
2nd | TUE |  |  |  |  |  | 0
3rd | WED |  |  |  |  |  | 0
4th | THU |  |  |  |  |  | 0
5th | FRI |  |  |  |  |  | 0
6th | SAT |  |  |  |  |  | 0
7th | SUN |  |  |  |  |  | 0
8th | MON | 20 | N | UNKNOWN |  |  | 1
9th | TUE |  |  |  |  |  | 1
10th | WED |  |  |  |  |  | 1
11th | THU |  |  |  |  |  | 1
12th | FRI |  |  |  |  |  | 1
13th | SAT |  |  |  |  |  | 1
14th | SUN |  |  |  |  |  | 1
15th | MON |  |  |  |  |  | 1
16th | TUE |  |  |  |  |  | 1
17th | WED |  |  |  |  |  | 1
18th | THU |  |  |  |  |  | 1
19th | FRI |  |  |  |  |  | 1
20th | SAT |  |  |  |  |  | 1
21st | SUN |  |  |  |  |  | 1
22nd | MON |  |  |  |  |  | 1
23rd | TUE |  |  |  |  |  | 1
24th | WED |  |  |  |  |  | 1
25th | THU |  |  |  |  |  | 1
26th | FRI |  |  |  |  |  | 1
27th | SAT |  |  |  |  |  | 1
28th | SUN |  |  |  |  |  | 1
29th | MON |  |  | Wk finishs start of next month | 2012-11-04 00:00:00 |  | 1
30th | TUE |  |  |  |  |  | 1
31st | WED |  |  |  |  |  | 1
TOTAL of PAID |  | 0
TOTAL of UNPAID |  | 20
 |  |  |  | UNKNOWN
Spreadsheet: 542069d1507705254-calculate-workers-in-and-time-in-out-timings
Sheet: Sheet1

Day | In Time | Out time | Net | 08:15:00
2017-10-03 00:00:00 | 09:13:00 | 16:47:00
Leave -04/10/2017
2017-10-05 00:00:00 | 08:10:00 | 19:00:00
2017-10-06 00:00:00 | 09:19:00 | 13:57:00
2017-10-09 00:00:00 | 09:10:00 | 18:30:00 | 09:10:00
2017-10-10 00:00:00 | 09:10:00 | 18:30:00
 |  |  | sum |  |  |  |  | this cell values should have net time i.e., (SUM =  -F2 + F4 - F5 + F6 + F7), however I am getting total time.
Note:
Worker will work 8 hr 15 min every day.
Assumption
using 24 hours format (hh:[NAME]:ss)
Need
In coloumn "E" I am using equal formula i.e., E1 ([NAME]) - D2(7:34:00)  = E2 (0:41:00)
When an employee spend morethan 8 hr 15 min when I use same formula its given "#######" message in cell. So I am using [NAME]) - E1 ([NAME]) = E2 (02:35:00)
The formula could calcuate automatically like if Row time is less than 8.15 hr comes in -(minus) values, If row is more than 8.15 hr should comes in -(plus) value.
Once the minus & plus values arrived I will use sum option to check the net time.
Spreadsheet: 846214d1697490023-cf-for-same-last-name-with-different-first-names-maemime-sample-
Sheet: Sheet1

First | Last
Anna | Smith | 500
[NAME] | Smith | 150
[NAME] | Lack | 300
Anna | Jones | 4896
[NAME] | Smith | 10
[NAME] | Lack | 500
Wayne | Dary | 75
Anna | Smith | 2580
Spreadsheet: 33000d1229200027-value-and-codes-template-2-
Sheet: Break Down

Name | WEEKLY Hours | week 1 | week2 | week3 | week 4 | Reg Hours | OT
JACKIE | 80
KAREN | 80
WISLY | 80
TWIN | 80
SHARON | 80
[NAME] | 40
OSCAR | 40
IBRAHIMA | 40
DARIUS | 40
WILNER | 80
CASSANDRA | 40
CATHERINE | 80
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9812

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
1998-12-01 00:00:00
IFGMR (TRKL/TX) |  |  | 2.03 |  |  | No. of Days: | 31
IFGMR (TRKL/LA) |  |  | 2.05
IFGMR (PEPL/TX/OK) |  |  | 2.06
IFGMR (ANR/LA) |  |  | 2.06
IFGMR (HENRY HUB) |  |  | 2.12
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001
 | 1993 | 2.4 | 2002
 | 1994 | 2.51 | 2003
 | 1995 | 2.61 | 2004
 | 1996 | 2.53 | 2005
 | 1997 | 2.65 | 2006
 | 1998 |  | 2007 | 6.37
 | 1999
 | 2000
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 771515d1646704505-assistance-with-2-spreadsheets-and-a-3rd-tally-spreadsheet-howiwouldlikeittolookb
Sheet: Sheet1

Customer Name | Paid? | Item 1 | Item 2 | Item 3
[NAME] | Yes
[NAME] | Yes
JACK DOUGH | N/A
PETER DOUGH | N/A
JON DOUGH | N/A
JACKSON DOUGH | N/A
Spreadsheet: tracy_geaccone__40504__2002 EGF Allocations ETS HQ
Sheet: ETS-Headquarters

Enron Global Finance
2001 Allocations |  |  |  | ETS-Headquarters
 |  |  |  | 2001 |  | 2002
106188 | Schnapper | Corp Finance |  | 0 | 0 | 0 | 0
106189 | Perkins | Treasury |  | 0 | 0 | 0 | 0
106190 | Kopper | Structured Finance |  | 0 | 0 | 0 | 0
106191 | [NAME] | Commercial Support |  | 0 | 0 | 0 | 0
106192 | Glisan | Treasury VP |  | 0 | 0 | 163234 | 0.1306001555354291
106193 | Boots | Investor/Debt Relations |  | 0 | 0 | 0 | 0
106194 | [NAME] | Legal |  | 0 | 0 | 0 | 0
106195 | [NAME] | Capital Market Equity |  | 0 | 0 | 0 | 0
106196 | EGF | G&A |  | 0 | 0 | 0 | 0
106285 | Fastow | Executive |  | 0 | 0 | 0 | 0
107038 | EGF | Projects |  | 0 | 0 | 0 | 0
140411 | Glisan | Intl Asset Structures |  | 0 | 0 | 0 | 0
 |  | S/T |  |  | 0 |  | 0.004517956784392957
Spreadsheet: 148138d1333148175-help-with-overage-calculation-weekly-expense-report-ap-weekly-expenses-1-
Sheet: Q1

 | Hotel and Airfare Expenses
Position | Sum of Airfare | Sum of Hotel | Total Hotel and Airfare
MN | 2247.1 | 848.77
S1 | 505.96 | 828.95
S2 | 848.54 | 1949.85
SU | 608.71 | 670.26
Grand Total | 4210.309999999999 | 4297.83
Spreadsheet: 53739d1253651757-excel-2007-generate-numbers-between-max-and-min-value-700306-allocation
Sheet: Sheet1

 | n1 | n2 | n3 | n4 | n5 | n6 | n7 | Total
[NAME] | 25 | 15 | 20 | 25 | 10 | 15 | 10 | 120
Min Vector | 22 | 6 | 14 | 7 | 7 | 1 | 3 | 60 | B3: {=SumTo(I3, B2:H2)}
Result | 22 | 8 | 15 | 13 | 9 | 7 | 6 | 80 | B4: {=SumToMM(I4, B3:H3, B2:H2, TRUE)}