tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 726770d1617444940-sumifs-function-doesnt-calculate-values-as-expected-accounting-module-1-sumproduct
Sheet: AccountsHeaders

 | ACCOUNTS
 | Typing Information into the HEADERS will carry through to each page of this workbook
 | BUSINESS NAME HEADER
 | Enter Business Name |  |  |  |  |  |  |  |  | Ú | Scroll this way to see the other headers
 | ACCOUNT HEADERS |  |  |  |  |  | Type your headers into the green boxes titled Account 1, Account 2 and so on. You can rename the ones in the other boxes too
 |  |  |  |  |  |  | MONEY IN |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MONEY OUT
 | Details |  |  |  |  |  | Other Funds Received |  | Income |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cost of Goods Sold - Purchases |  |  |  |  |  |  |  |  |  | Expenses |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Funds Paid Out
 | Date | Transaction Type | Requested/ Received By | Descripton of Transaction | Ref/ Invoice No. |  | Owner's Deposit (Capital) | Loans Received | [NAME] | Document Charges | Other Incomes | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Total Money In |  | Example: Stock Purchases | COGS Account 2 | COGS Account 3 | COGS Account 4 | COGS Account 5 | COGS Account 6 | COGS Account 7 | COGS Account 8 | COGS Account 9 | COGS Account 10 | Building Rent | Electricity | Fuel | Internet Charges | Mobile Charges | Statationery | Computers | Furniture | Travelling Costs | Marketing/Advertising | Charitables | Sponsorships | Entertainment | Insurance | Water Bill | Training | Car Maintenance | Motor Bike Maintenance | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Hidden | Asset Purchases | Loan Repayments | Petty Cash | Credit Card Payments | Transfer to/from Other Bank Account (EG "Savings'' | Owner's Personal Expenses (Drawings) | Income Tax | Annual Returns | Total Money Out
 |  |  |  |  |  |  | BS | BS | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L |  |  | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | P&L | BS | BS | BS | BS | BS | BS | BS | BS
 |  |  |  |  |  |  | 1 | 2 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 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 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
Spreadsheet: 801580d1666262817-if-cell_1-x-from-list-1-then-cell_2-x-expanded-from-list-2-doc_register_003
Sheet: Data Registry

 | Group | Expanded |  | Document Type | Expanded
 | A | Group-A |  | AA | Doc-AA
 | B | Group-B |  | BB | Doc-BB
 | C | Group-C |  | CC | Doc-CC
 | D | Group-D |  | DD | Doc-DD
 | E | Group-E |  | EE | Doc-EE
 | F | Group-F |  | FF | Doc-FF
 | G | Group-G |  | GG | Doc-GG
 | H | Group-H |  | HH | Doc-HH
 | J | Group-J |  | JJ | Doc-JJ
Spreadsheet: 688443d1595789160-create-list-of-dates-in-order-from-lists-across-sheets-book1
Sheet: Sheet1

Dates A |  |  |  | Dates C
2015-01-19 00:00:00
2017-11-20 00:00:00 |  |  |  | 2015-01-19 00:00:00 |  | 2015-01-19 00:00:00
2018-11-20 00:00:00 |  |  |  | 2017-05-26 00:00:00 |  | 2017-05-26 00:00:00
2019-01-20 00:00:00 |  |  |  | 2017-11-20 00:00:00 |  | 2017-11-20 00:00:00
 |  |  |  | 2018-05-26 00:00:00 |  | 2018-05-26 00:00:00
 |  |  |  | 2018-11-20 00:00:00 |  | 2018-11-20 00:00:00
 |  |  |  | 2019-01-20 00:00:00 |  | 2019-01-20 00:00:00
 |  |  |  | 2019-05-26 00:00:00 |  | 2019-05-26 00:00:00
 |  |  |  | 2020-05-26 00:00:00 |  | 2020-05-26 00:00:00
*I'd like a formula to use the dates as listed on this sheet in column A under "Dates A" and the dates as listed on Sheet2 in column A under "Dates B" and combine them into a list in chronological order in column E under "Dates C"
Spreadsheet: 804913d1668434289-summing-overlapped-time-intervals-intervals-6-
Sheet: Sheet1

Product | Machine | [NAME] start | ProductRunning End | Downtime |  |  | Machine | Machine Downtime start | MachineDowntime end
A | m/c1 | 10:00:00 | 14:00:00 | 65 min |  |  | m/c1 | 09:30:00 | 09:45:00
b | m/c2 | 09:00:00 | 15:00:00 | 25 min |  |  | m/c2 | 08:00:00 | 08:30:00
c | m/c1 | 15:00:00 | 16:00:00 | 30 min |  |  | m/c1 | 09:55:00 | 10:05:00
 |  |  |  |  |  |  | m/c1 | 13:00:00 | 14:15:00
 |  |  |  |  |  |  | m/c1 | 14:30:00 | 15:30:00
 |  |  |  |  |  |  | m/c2 | 08:55:00 | 09:25:00
 |  |  |  |  |  |  | m/c1 | 16:00:00 | 17:00:00
 |  |  |  |  |  |  | m/c2 | 16:00:00 | 17:00:00
Spreadsheet: 271236d1381868519-setting-autofill-to-move-more-than-1-cell-sum-every-nth-number-by-c-pearson
Sheet: Sheet1

1 |  | [NAME] | 6
2 |  |  |  | Use these formulas when the data DOES start in row 1.
3 | 1 |  |  | To start in row N, and sum rows N, 2N, 3N, etc, use
4 | 2 |  |  | =SUM(IF(MOD(ROW($A$1:$A$20),$D$1)=0,$A$1:$A$20,0))
5 | 3
6 | 4
7 | 5 |  |  | To start in row 1, and sum rows 1, 1+N, 1+(2N),etc use
8 | 6 |  |  | =SUM(IF(MOD(ROW($A$1:$A$20)-1,$D$1)=0,$A$1:$A$20,0))
9 | 7
10 | 8
11 | 9
12 | 10 |  |  | Use these formulas when the data does NOT start in row 1.
13 | 11 |  |  | To start in row N (of the range), and sum rows N, 2N, 3N, etc, use
14 | 12 |  |  | =SUM(IF(MOD(ROW($B$3:$B$22)-ROW($B$3)+1,$D$1)=0,$B$3:B$20,0))
15 | 13
16 | 14
17 | 15 |  |  | To start in row 1 (of the range), and sum rows 1, 1+N, 1+(2N),etc use
18 | 16 |  |  | =SUM(IF(MOD(ROW($B$3:$B$22)-ROW($B$3),$D$1)=0,$B$3:B$22,0))
19 | 17
20 | 18
 | 19
 | 20
Spreadsheet: 849096d1699634768-highlight-duplicate-celle-from-a-range-corrected
Sheet: Sheet1 (2)

Topic |  | Name 1 | Name 2 | Name 3 | Name 4 |  | CF - Topic | CF - Name 1 | CF - Name 2 | CF - Name 3 | CF - Name 4 |  |  |  |  |  |  |  | [NAME] is having Topics and Coloumn C, D , E are having Nmaes
Diabetes |  | [NAME] | Ajay | Michel | Prasad |  |  |  |  |  |  |  |  |  |  |  |  |  | I want to highlight the cells if any topic is having repeated names in diffrent rows.
Diabetes |  | George | [NAME] | Pravin | Michel |  |  |  |  |  |  |  |  | [NAME] | Pravin | Michel |  |  | I want to [NAME], C2, E2 and A4, D4, E4 because duplicate name with Same topic.
Cardiac |  | George | Vikas | Ram | [NAME]
Cardiac |  | Ravikant | Pradeep | Rosy
[NAME] |  | Sushhrut | Anup | Mahesh
[NAME] |  | Acharya | Hemant | Anup
Spreadsheet: 105009d1302506492-calculating-asking-price-based-on-cost-of-goods-sold-ebay
Sheet: Sheet1

Purchase price | Sell price | Ebay fee | Paypall fee | Profit margin
49 | 63.7 | 5.88 | 1.47 | 7.35 | 63.7
50 | 65 | 3 | 1.5 | 7.5 | 65
75 | 93 | 4.5 | 2.25 | 11.25 | 102
100 | 124 | 6 | 3 | 15 | 136
200 | 248 | 12 | 6 | 30 | 272
300 | 372 | 18 | 9 | 45 | 407.9999999999999
400 | 496 | 24 | 12 | 60 | 544
500 | 620 | 30 | 15 | 75 | 679.9999999999999
600 | 744 | 36 | 18 | 90 | 815.9999999999999
700 | 868 | 42 | 21 | 105 | 951.9999999999999
800 | 992 | 48 | 24 | 120 | 1088
900 | 1116 | 54 | 27 | 135 | 1224
1000 | 1240 | 20 | 30 | 150 | 1360
1100 | 1320 | 22 | 33 | 165 | 1518
1200 | 1440 | 24 | 36 | 180 | 1656
1300 | 1560 | 26 | 39 | 195 | 1794
1400 | 1680 | 28 | 42 | 210 | 1932
1500 | 1800 | 30 | 45 | 225 | 2070
1600 | 1920 | 32 | 48 | 240 | 2208
1700 | 2040 | 34 | 51 | 255 | 2346
1800 | 2160 | 36 | 54 | 270 | 2484
1900 | 2280 | 38 | 57 | 285 | 2622
2000 | 2400 | 40 | 60 | 300 | 2760
Spreadsheet: 679582d1590508335-average-ifs-with-multiple-criteria-and-multiple-dynamic-columns-excel-help-average-with-multiple
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Result
 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday |  |  | Monday
 | 08:00:00 | 15 | 14 | 13 | 12 | 11 | 10 | 9 | 8 | 7 | 6 | 5 | 4 | 3 | 2 | 14 |  | 08:00:00
 | 08:15:00 | 23 | 69 | 115 | 161 | 207 | 253 | 299 | 345 | 391 | 437 | 483 | 529 | 575 | 621 | 69 |  | 08:15:00
 | 08:30:00 | 45 | 12 | 217 | 263.333333333333 | 349.333333333333 | 435.333333333333 | 521.333333333333 | 607.333333333333 | 693.333333333333 | 779.333333333333 | 865.333333333333 | 951.333333333333 | 1037.33333333333 | 1123.33333333333 | 12 |  | 08:30:00
 | 08:45:00 | 78 | 2 | 319 | 374 | 494.5 | 615 | 735.5 | 856 | 976.5 | 1097 | 1217.5 | 1338 | 1458.5 | 1579 | 2 |  | 08:45:00
 | 09:00:00 | 45 | 9 | 421 | 534.333333333333 | 722.333333333333 | 910.333333333333 | 1098.33333333333 | 1286.33333333333 | 1474.33333333333 | 1662.33333333333 | 1850.33333333333 | 2038.33333333333 | 2226.33333333333 | 2414.33333333333 | 9 |  | 09:00:00
 | 09:15:00 | 1 | 65 | 129 | 193 | 257 | 321 | 385 | 449 | 513 | 577 | 641 | 705 | 769 | 833 | 65 |  | 09:15:00
 | 09:30:00 | 11 | 25 | 39 | 53 | 67 | 81 | 95 | 109 | 123 | 137 | 151 | 165 | 179 | 193 | 25 |  | 09:30:00
 | 09:45:00 | 45 | 62 | 79 | 96 | 113 | 130 | 147 | 164 | 181 | 198 | 215 | 232 | 249 | 266 | 62 |  | 09:45:00
 | 10:00:00 | 65 | 47 | 29 | 17 | 1.66666666666671 | 179 | 199 | 219 | 239 | 259 | 279 | 299 | 319 | 339 | 47 |  | 10:00:00
 | 10:15:00 | 78 | 12 | 4 | 182 | 205 | 228 | 251 | 274 | 297 | 320 | 343 | 366 | 389 | 412 | 12 |  | 10:15:00
 | 10:30:00 | 23 | 1 | 6 | 11 | 16 | 21 | 26 | 31 | 36 | 41 | 46 | 51 | 56 | 485 | 1 |  | 10:30:00
Spreadsheet: 756447d1637570043-order-two-columns-based-off-two-other-columns-order-test
Sheet: Sheet1

 | RAW DATA (UNORDERED) |  |  |  |  |  |  |  | ORDERED LIST
[NAME] | [NAME] | First Name | Last Name | [NAME] | [NAME] |  |  |  | First Name | Last Name
4656 | 645 | [NAME] | [NAME] | 2313 | 8493 |  |  |  | Felix | [NAME]
4656 | 645 | [NAME] | [NAME] | 46546 | 879 |  |  |  | [NAME] | Doe
5652 | 885 | [NAME] | Doe | 21329 | 8 |  |  |  | [NAME] | Brew
2123 | 2122 | [NAME] | Brew | 1365 | 12 |  |  |  | [NAME] | [NAME]
2131 | 5657 | Felix | [NAME] | 46887 | 62014 |  |  |  | [NAME] | [NAME]
 |  | DESIRED RESULTS
[NAME] | [NAME] | First Name | Last Name | [NAME] | [NAME]
2131 | 5657 | Felix | [NAME] | 46887 | 62014
5652 | 885 | [NAME] | Doe | 21329 | 8
2123 | 2122 | [NAME] | Brew | 1365 | 12
4656 | 645 | [NAME] | [NAME] | 46546 | 879
4656 | 645 | [NAME] | [NAME] | 2313 | 8493
Spreadsheet: 697577d1601412156-if-column-f-equals-column-h-equals-xlf20200929-test4forum-for_tails1-as_with_pete_uk_formula
Sheet: Sheet1

Date | Who | Department | Budget Code | Event/Job No | Product | Quantity | Price | Total price | [NAME] | Qty Used
A - Data | B - Data | C - Data | D - Data | E - Data | Balloons | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Bubble blowers | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Bunting | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Cotton bags | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Glow in the dark pens | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Heat sensitive mugs | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Lanyards | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | A5 notepads | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | USB sticks | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Pencils | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Safety specs/glasses | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Stickers - English | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Stickers - French | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Stylus pen | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Top trump cards | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Rular | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Tablecloths - Free | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Tablecloths - Price | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | CC Cotton bags | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Wristbands | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | [NAME] | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Solar power charger | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Plug USA | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Recycled pens | 0 |  |  | 0
A - Data | B - Data | C - Data | D - Data | E - Data | Brand tshirt | 0 |  |  | 0
 |  |  |  |  | Some random item
Spreadsheet: 711382d1609667459-same-formula-two-different-cells-two-different-results-schedule-test
Sheet: Schedule

 |  | Year |  | OFF | Weekends |  |  |  | OT | Overtime |  |  |  | EDO | Extra Day Unpaid |  |  |  | AL | Acting Lead |  |  |  | BCA | MICS 46
 |  | 2021 |  | ON | Working |  |  |  | C/O | Sick |  |  |  | FTO | Flex Time |  |  |  | AT | Equipment Check |  |  |  | TCA | MICS 97
 |  | Month |  | NA | Not Applicable |  |  |  | LOA | Leave of Absence |  |  |  | RDO | Requested Day Unpaid |  |  |  | 1HC | 1 HR Cage Audit |  |  |  | AH | Schedule Change
 |  | January |  |  | Vacation |  |  |  | LO | [NAME] |  |  |  | FMLA | Medical |  |  |  | CCA | Cage Checkout Audit
 | Grave Shift 12a-8a |  | Op#
1 | Supervisor
2 | Lead
3 | Operator 1
4 | Operator 2
17 | Operator 3
 | Day Shift 8a-4p |  | Op#
5 | Supervisor
6 | Lead
7 | Operator 1
8 | Operator 2
 | Swing Shift 4p-12a |  | Op#
9 | Manager
10 | Lead
11 | Operator 1
12 | Operator 2
13 | Operator 3
 | Day Techs 6a-2p |  | Op#
14 | Tech Lead
15 | Tech 1
16 | Tech 2
Spreadsheet: 600365d1543631705-trying-populate-nonrepeating-dates-based-on-date-range-and-specific-name-vehicle-info-example
Sheet: Vehicle Log

 |  |  | Vehicle/Gas Card Tracking Record
 |  |  |  | 2018-07-01 00:00:00
 |  |  | VEHICLE REGISTERED TO BELOW |  |  | VEHICLE # | Van 1
 |  |  | NAME: |  |  | LICENSE PLATE #
 |  |  |  |  |  | GAS CARD #
 |  |  | BEGINNING MILEAGE AT THE START OF THE MONTH: |  |  | Date:
 |  |  | ENDING MILEAGE AT THE END OF THE MONTH: |  |  | Date:
Date | Driver Name | Beginning Mileage | Ending Mileage | [NAME] | Gas Purchase Amount | Notes
TOTAL AMOUNT OF GAS PURCHASED FOR THE MONTH: |  |  |  |  |  | Date:
TOTAL [NAME] ACCUMULATED FOR THE MONTH
Spreadsheet: 104770d1302224896-question-about-linking-formulas-from-one-page-to-another-new-accts-payable-2011
Sheet: Apr

april expenses
total
advertising
date | po# | suppplier.description | amount
subtotal
x
educational
date | po# | suppplier.description | amount
subtotal
x
supplies. blanks
date | po# | suppplier.description | amount
subtotal
x
supplies. designs
date | po# | suppplier.description | amount
subtotal
s
supplies. notions
date | po# | suppplier.description | amount
subtotal
supplies. machinery
date | po# | suppplier.description | amount
subtotal
supplies. office
date | po# | suppplier.description | amount
subtotal
etsy maintenance
date | po# | suppplier.description | amount
subtotal
website maintenance
date | po# | suppplier.description | amount
subtotal
shipping
date | po# | suppplier.description | amount
subtotal
utilities
date | po# | suppplier.description | amount
subtotal
Spreadsheet: 712456d1610216312-lookup-or-loop-through-planning_example
Sheet: Sheet5

Training | Training |  |  |  |  |  |  |  | Update ERP | Operations
ERM Tools | Operations |  |  |  |  |  |  |  | Public Involvement – Phone Update | Field
Software | Software |  |  |  |  |  |  |  | Update Site Sections | Operations
[NAME] | Engineering |  |  |  |  |  |  |  | Program Management | Operations
Regulatory | Engineering |  |  |  |  |  |  |  | Notifications | Operations
GIS and Mapping | GIS |  |  |  |  |  |  |  | Government Consultation | Operations
Distribute | Operations |  |  |  |  |  |  |  | Truck Books | Operations
Create ERP | Operations |  |  |  |  |  |  |  | Update EST Plan | Operations
 |  |  |  |  |  |  |  |  | ICS 200 | Training
 |  |  |  |  |  |  |  |  | H2Notify | Software
 |  |  |  |  |  |  |  |  | Other | HSE
 |  |  |  |  |  |  |  |  | Table Top | Training
 |  |  |  |  |  |  |  |  | Public Involvement | Field
 |  |  |  |  |  |  |  |  | Meetings | Operations
 |  |  |  |  |  |  |  |  | HSE MS Maintenance | HSE
 |  |  |  |  |  |  |  |  | Create Site Sections | Operations
 |  |  |  |  |  |  |  |  | [NAME] | GIS
 |  |  |  |  |  |  |  |  | GIS and Mapping Services | GIS
 |  |  |  |  |  |  |  |  | Create EST Plan | Operations
 |  |  |  |  |  |  |  |  | EST Training | Training
 |  |  |  |  |  |  |  |  | [NAME] | Software
 |  |  |  |  |  |  |  |  | HSE MS Development | HSE
 |  |  |  |  |  |  |  |  | Indoctrination Program Development | HSE
 |  |  |  |  |  |  |  |  | Develop Orientation Program | HSE
 |  |  |  |  |  |  |  |  | [NAME] | Training
 |  |  |  |  |  |  |  |  | Expert Witness Services | Operations
 |  |  |  |  |  |  |  |  | MARS | Software
 |  |  |  |  |  |  |  |  | EPZ Calculations | Engineering
 |  |  |  |  |  |  |  |  | Reproduction Services | Operations
 |  |  |  |  |  |  |  |  | Incident Management | HSE
 |  |  |  |  |  |  |  |  | Orientation | Training
 |  |  |  |  |  |  |  |  | ICS 300 | Training
 |  |  |  |  |  |  |  |  | AFDS | Software
 |  |  |  |  |  |  |  |  | Regulatory Reporting | HSE
 |  |  |  |  |  |  |  |  | Inspection | HSE
 |  |  |  |  |  |  |  |  | Contractor Management | HSE
 |  |  |  |  |  |  |  |  | SOP Development | HSE
 |  |  |  |  |  |  |  |  | EM Consulting | Operations
 |  |  |  |  |  |  |  |  | Mobilization Exercise | Training
 |  |  |  |  |  |  |  |  | Wildfire Plan | Operations
 |  |  |  |  |  |  |  |  | EDS | Software
 |  |  |  |  |  |  |  |  | Support Services | HSE
 |  |  |  |  |  |  |  |  | ICS Vests | ICS Vests
 |  |  |  |  |  |  |  |  | Gap Analysis | Operations
 |  |  |  |  |  |  |  |  | Environmental Reporting | HSE
 |  |  |  |  |  |  |  |  | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  | Financial | Operations
Spreadsheet: 23904d1213773432-look-up-wip
Sheet: Sheet1

 |  |  |  | Master [NAME]
Date | Shop | [NAME] | KTV | Address | Post Code | Phone | Project | Type of | Description of Work Required | Day / | Assigned To | Status | Invoice No
Raised | No | No | No |  |  | Number | Manager | Job |  | Night
 | 1277 | #N/A |  | #N/A
Spreadsheet: 97830d1296926163-lookup-or-match-formula-tourney-lookup
Sheet: Sheet2

 |  | Table 1 |  |  |  |  |  |  | Table 2
Round 1 | 8 | 2 | 3 | 5 |  |  | Round 1 | 8 | 2 | 3 | 5 |  |  | [NAME] | 2
 | 1 | 6 | 4 | 7 |  |  |  | 1 | 6 | 4 | 7 |  |  | Warrick | 4
Round 2 | 8 | 3 | 4 | 6 |  |  | Round 2 | 8 | 3 | 4 | 6 |  |  | [NAME] | 8
 | 2 | 7 | 5 | 1 |  |  |  | 2 | 7 | 5 | 1 |  |  | Cheatham | 7
Round 3 | 8 | 4 | 5 | 7 |  |  | Round 3 | 8 | 4 | 5 | 7 |  |  | Buford | 1
 | 3 | 1 | 6 | 2 |  |  |  | 3 | 1 | 6 | 2 |  |  | Irwin | 6
Round 4 | 8 | 5 | 6 | 1 |  |  | Round 4 | 8 | 5 | 6 | 1 |  |  | [NAME] | 5
 | 4 | 2 | 7 | 3 |  |  |  | 4 | 2 | 7 | 3 |  |  | Nisbet | 3
Round 5 | 8 | 6 | 7 | 2 |  |  | Round 5 | 8 | 6 | 7 | 2
 | 5 | 3 | 1 | 4 |  |  |  | 5 | 3 | 1 | 4
Round 6 | 8 | 7 | 1 | 3 |  |  | Round 6 | 8 | 7 | 1 | 3
 | 6 | 4 | 2 | 5 |  |  |  | 6 | 4 | 2 | 5
Round 7 | 8 | 1 | 2 | 4 |  |  | Round 7 | 8 | 1 | 2 | 4
 | 7 | 5 | 3 | 6 |  |  |  | 7 | 5 | 3 | 6
Spreadsheet: 30985d1226678789-transfering-data-from-sheet-to-sheet-excel-help
Sheet: SUPPLIST

Supplier | Part Number | Source Facility | Entry Point | Order Frequency | Last Rcpt Date | Part Dist Class | Current Lead Time to Dock (calendar days) | Last LTD Maint Date | Default LTD Flag (Y/N) | New Lead Time to Dock (calendar days) | Part-Level Comments | Calender Time
Us | 252627 | 39 | Z109 | 6 | 2008-10-15 00:00:00 | B | 59 | 2008-06-30 00:00:00 | Y
Us | 131415 | NJ | Z109 | 2 | 2008-08-22 00:00:00 | A | 52 | 2008-09-22 00:00:00 | Y
Us | 789 | NJ | Z109 | 22 | 2008-08-01 00:00:00 | A | 52 | 2008-09-22 00:00:00 | Y
Us | 222324 | 39 | Z109 | 2 | 2008-10-31 00:00:00 | A | 52 | 2008-08-04 00:00:00 | Y
Us | 192021 | 39 | Z109 | 4 | 2008-10-10 00:00:00 | A | 52 | 2006-08-21 00:00:00 | Y
Us | 161718 | 39 | Z109 | 4 | 2008-09-09 00:00:00 | A | 52 | 2006-11-06 00:00:00 | Y
Us | 101112 | NJ | Z109 | 3 | 2008-01-11 00:00:00 | A | 52 | 2008-09-22 00:00:00 | Y
Us | 456 | 39 | Z109 | 2 | 2008-10-31 00:00:00 | A | 52 | 2006-08-21 00:00:00 | Y
Us | 123 | 39 | Z109 | 4 | 2008-10-31 00:00:00 | A | 52 | 2006-08-21 00:00:00 | Y
Spreadsheet: kimberly_watson__20555__imbalsumm0108
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -151076 | -150326
2 | -186416 | -184781
3 | -210011 | -208808
4 | -245094 | -241726
5 | -236194 | -235157
6 | -172231 | -181280
7 | -117605 | -116400
8 | -109940 | -109486
9 | -138076 | -137436
10 | -158047 | -156889
11 | -221811 | -219321
12 | -161285 | -160322
13 | -180446 | -185322
14 | -179929 | -178986
15 | -198888 | -198260
16 | -201390 | -202819
17 | -221368 | -219862
18 | -246242 | -245186
19 | -212136 | -211394
20 | -189598 | -188009
21 | -122945 | -120841
22 | -180542 | -179917
23 | -162154 | -161135
24 | -176509 | -174939
25 | -174033 | -170727
26 | -176005 | -174969
27 | -177989 | -178155
28
29
30
31
2001-07-31 00:00:00 |  |  | 24900
2001-08-27 00:00:00
CBS Dollars
 |  |  | -156083.38
Spreadsheet: benjamin_rogers__1213__United American Energy 03-23-00
Sheet: Returns Analysis

RETURNS ANALYSIS
 | 0
('000 $) | Close
EBITDA | 0
Less Interest Payments | 0
Pre-Tax Cashflow
Less Cash Taxes | 0
Less Principal Payments | 0
Less Capex | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Cashflow to Equity
Distribution to Equity | 1
Equity RROR | 0.14
Beginning Balance
RROR Target Coupon | 0
Actual Cash Flow
Equity Paydown | 0
Ending Balance
ENRON'S RETURNS ANALYSIS
Zero Residual Value
Equity Return
Actual Cash Flow
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Equity Return
Actual Cash Flow
Residual Value | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Cash Flow
 | IRR
Spreadsheet: andy_zipper__154__ICE - Mar28 Power & Gas VOL
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Mar-28-01 thru Mar-28-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
No Activity
Spreadsheet: 274862d1383240353-perform-a-vlookup-between-worksheets-biscuits
Sheet: Sheet2

Country | Germany |  |  |  |  |  |  | Locations
Biscuit type | Model | Customer | Order status
Spreadsheet: 884113d1733101189-is-it-possible-for-formulas-to-update-themselves-with-data-typed-in-another-cell-u77-shareable-copy
Sheet: Test Sheet

% Complete | Circuit | TOTAL | RT | RT-R/A | UT | UT-R/A | Total Remaining | Backlog
 | 801-01 |  |  |  |  |  |  |  |  |  | Total CML's | Total CML's Complete |  | % |  | CML's Remaining
 | 226-02 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Backlog
 |  |  |  |  |  |  |  |  |  |  | Total RT's | RT's [NAME]
 | 236-02
 | 239-03 |  |  |  |  |  |  |  |  |  | Total UT's | UT's [NAME]
 | 239-04
 |  |  |  |  |  |  |  |  |  |  | Ropes | Scaffold | Grade | Ladder | Harness | Manlift
 | 254-03 |  |  |  |  |  |  |  |  | RT |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMAINING
 |  |  |  |  |  |  |  |  |  | UT |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | REMAINING