tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 38818d1236960490-sum-multiple-criteria-with-unique-value-example2
Sheet: Sheet5

 |  | Ticket Number | Service Type | Charge
 |  | 252 | Service | 40
 |  |  | Retail | 33
 |  | 253 | Service | 162
 |  |  | Retail | 73
 |  |  | Retail | 69
 |  | 255 | Retail | 175
 |  |  | Service | 168
 |  |  | Service | 103
 |  | 258 | Service | 62
 |  | 258 | Retail | 127
 |  |  | Retail | 51
 |  |  | Service | 55
 |  |  | Service | 78
 |  |  | Service | 92
 |  |  | Service | 95
 |  |  | Revenue | Transactions
 |  | Retail
 |  | Service
 |  | Retail & Service
Spreadsheet: larry_campbell__21417__EngineTest
Sheet: Sheet1

Ihp | [NAME] | % open bleed vlv | %Load | BHp | Fuel Flow Lb/Hr | LHV         (btu/lb) | Heat Rate     ( btu/Bhp-Hr) | Nox (ppm) | CO (ppm) | UHC (ppm) | Exhaust Flow (lb/sec)
45975 | ABC | 0 |  |  | 12767 | 20653 |  | 22 | 1.7 | 0.017 | 183
30963 | ABC | 67 |  |  | 10066 | 20653 |  | 13 | 3.6 | 0.29 | 145
22006 | AB | 39 |  |  | 7688 | 20653 |  | 20.6 | 9.7 | 1.4 | 129
13457 | BC | 46 |  |  | 5278 | 20653 |  | 23 | 21 | 6.4 | 106
1000 | B? | ? |  |  | 1329 | 20653 |  | 23 | 180 | ? | ?
Notes: Barometric pressure = 14.3 psia, [NAME] = 65-68°F, Inlet loss 4"
Vibrations were mostly 0.4 Mils with a peak @ 0.6 Mils.  [NAME] is 4 mils and shutdown is 7 mils
All Lube oil temps were good
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Mar 7 to Mar 13

 | Week summary (Mar 7 to Mar 13)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place | 1
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 728013d1618248214-match-codes-from-file-1636-match-codes-from-file-master-code-list
Sheet: Test Sheet

 | Product No | Column B Product No located on Master Code List Row No | Next Row No on Master Code List | Product No on next Row No of Master Code List | Column E Product No located on Test Sheet Row No | Sweep Required?
 | 589323 CB
 | 548168 CB
 | 554023 4CB
 | 555567 CB
 | 050001 34211994
 | 554021 CB
 | 513111 CB
 | 589326 CB
 | 579367 SPMEU
 | 554811 2CB
 | 589661 CB
 | 589931 CB
 | 589411 CB
 | 579361 SPPF
 | 588382 CB
 | 513147 CB
 | 513140 1CB
 | 588884 1CBPOF
 | 569800 CBI
 | 589640 CB
 | 555765 CB
 | 589206 CB
 | 555294 CB
 | 509408 SPM
 | 585309 10SPM
 | 585270 10SPM
 | 534199 SPM
 | 554258 1CBEU
 | 513000 1SPM
 | 575568 1SPM
 | 588503 4CB
 | 522631 SPMK
 | 050001 33229086
 | 554870 1CB
 | 537503 SPM
 | 540550 SPM
 | 510404 SPM
 | 585270 SPM
Spreadsheet: 883503d1732116576-1-row-and-3-column-wise-lookup-using-index-match-function-excel-comp
Sheet: Comp

 |  |  | Make | Product | Model |  | Column |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Accord | Mag | 6420
 |  |  | Aster | PH | PO650 pH |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Adept | pH | 6440
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aster | Mag | 6410/6415
 | Make |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | BR Instrumentation | PH | A3 Series
 | Product |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Infinity | RO_Panel | A7 Series
 | Application |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proton |  | A9 Series GSM
 | Model |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP 1:1/1:3/3:3
 | Display |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP GSM 1:1/1:3/3:3
 | Type |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AP LED Lite
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Full Bore
 | Flow Range |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRO 11M/13M
 | Mounting |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | IRO 33M
 | Relay |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LITE NXT
 | Raw Water Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MAG 650
 | High Pressure Pump |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NXT11/13/33
 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PO650 pH
 | Input |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA11/13/33
 | Output |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Smart EFM
 | Installation
 | Power supply
 | Pressure rating (kg/cm2)
 | Process temperature
 | Electrode material
 | [NAME]
 | Lining material
 | Cable
 | Body material
 | protection
 | Price
 | Feature
Spreadsheet: 839996d1692351273-sum-product-with-merged-cells-sumproduct-merged-cell
Sheet: Expected Result

 | [NAME] |  |  | McDonaldtrut Ellie |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | Myerstrut [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | Okpevbatrut Victor |  |  |  |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  |  |  |  | Norristrut Robert |  |  | [NAME] |  |  | Mairtrut Ruairidh |  |  | [NAME] |  |  | [NAME]
 | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time | Booked | Original Forcast time | Adjusted Forcast time
Total Days
Days X Rate
Spreadsheet: 165895d1341388487-how-to-empty-the-lookup-output-cells-when-the-primary-cells-are-emptied-development_swing-ticket-20120703_beta
Sheet: SwingTicketOrderForm

Ship To Name |  |  |  |  |  |  | Contact
Address 1 |  |  |  |  |  |  | Phone
Address 2 |  |  |  |  |  |  | Fax
Address 3 |  |  |  |  |  |  | [NAME]
City |  |  |  |  |  |  | Order Date: |  | 2012-06-01 00:00:00
State |  |  |  |  |  |  | Ship Method: |  | REGULAR
Zip |  | 000000 |  |  |  |  | Date Required:
Country |  | ICELAND |  |  |  |  | Total Order Qty: |  | 32
Department No. |  | T32 Shapewear & Separates |  |  |  |  | Stroke No. |  | 5089
[NAME] |  | DIR FOOK WAH CHINA |  |  |  |  | Supplier No. |  | 05254
Lead Factory |  |  | ABC Factory
Contract Number |  |  | 1063710
Ticket/Label Name |  |  | ST/L2101OT - Standard Barcode Swing Ticket
Country of Origin |  |  | China
Line# | Colour |  | Primary Size |  | Pantone | Secondary [NAME] |  | UPC |  | [NAME] |  |  | Part Set | MSRP (GBP) | Qty
1 | T2 - BLUE MIX |  | 6 |  | 134C | SHORT FITTING |  | 86535763 |  | Story Desc Test |  |  |  | 99.99 | 20
2 | T2 - BLUE MIX |  | 30 |  | 702C | SHORT/MEDIUM |  | 77987689 |  |  |  |  | 2 |  | 12
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Spreadsheet: 137610d1327256996-highest-number-in-the-middle-descending-numbers-to-left-and-right-left-right-sort
Sheet: Sheet1

Sorter colomn | S.No | Orignal | Sorted
 | X=Axis | 11 | [NAME]
10 | 1 | 25 | 16
8 | 2 | 24 | 18
6 | 3 | 23 | 20
4 | 4 | 22 | 22
2 | 5 | 21 | 24
1 | 6 | 20 | 25
3 | 7 | 19 | 23
5 | 8 | 18 | 21
7 | 9 | 17 | 19
9 | 10 | 16 | 17
11 | 11 | 15 | 15
Spreadsheet: 726455d1617253973-count-duplicate-occurrences-on-first-instance-only-then-return-0-or-blank-for-remaining-book1
Sheet: Sheet1

name | countifs
[NAME]
[NAME]
michelle
mark
pheobe
michelle
[NAME]
mark
michelle
[NAME]
mark
[NAME]
[NAME]
michelle
michelle
mark
[NAME]
[NAME]
pheobe
Spreadsheet: 40902d1239290525-grabbing-data-from-a-cell-on-another-worksheet-if-example-5
Sheet: Worksheet A

Name | Price | Stock | Sort ID
Pencil | 0.2 | 50 | 1
Eraser | 0.3 | 12 | 2
Ruler | 0.7 | 3 | 2
Pen | 0.25 | 22 | 1
Case | 1.25 | 5 | 2
Highlighter | 1 | 15 | 1
[NAME] | 4 | 7 | 1
Stapler | 1.5 | 20 | 2
Spreadsheet: 723525d1615751985-max-if-not-working-properly-test
Sheet: FEES

2019  ADVISORY FEES |  | 2020 ADVISORY FEES |  | 2021 ADVISARY FEES |  |  | TOTAL  ADVISORY FEES
TOTAL EACH
DATE | 721-29462   ALAN IRA | 721-29463     ALAN ROTH | 721-29464      JOANN IRA | 721-29465    JOANN ROTH | 721-29466    JOINT BROKERAGE | 721-29493     JOINT ADVISORY | 721-30380 JOANN BROKER IRA | 721-33377 CSTM IRA | MONTHLY  ADVISORY FEES | MONTH DIFF | PERCENT DIFF
2021 FEES
2021-01-01 00:00:00 | 82.29 | 20.41 | 452.84 | 47.49 | 0 | 69.06 | 0 | 0
2021-02-01 00:00:00 | 85.34 | 20.62 | 400.47 | 48.9 | 0 | 70.67 | 0 | 117.74
2021-03-01 00:00:00 |  |  |  |  |  |  | 0
2021-04-01 00:00:00 |  |  |  |  |  |  | 0
2021-05-01 00:00:00 |  |  |  |  |  |  | 0
2021-06-01 00:00:00 |  |  |  |  |  |  | 0
2021-07-01 00:00:00 |  |  |  |  |  |  | 0
2021-08-01 00:00:00 |  |  |  |  |  |  | 0
2021-09-01 00:00:00 |  |  |  |  |  |  | 0
2021-10-01 00:00:00 |  |  |  |  |  |  | 0
2021-11-01 00:00:00 |  |  |  |  |  |  | 0
2021-12-01 00:00:00
2021 YTD  FEES
2020 FEES
2020-01-01 00:00:00 | 70.37 | 19.01 | 361.91 | 37.65 | 0 | 62.01 | 0
2020-02-01 00:00:00 | 65.07 | 18.49 | 573.8 | 33.39 | 0 | 58.42 | 0
2020-03-01 00:00:00 | 57.93 | 16.34 | 282.13 | 28.08 | 0 | 50.75 | 0
2020-04-01 00:00:00 | 63.2 | 17.17 | 303.33 | 31.06 | 0 | 54.81 | 0
2020-05-01 00:00:00 | 57.11 | 17.8 | 313.49 | 32.5 | 0 | 65.15 | 0
2020-06-01 00:00:00 | 67.37 | 18.13 | 320.33 | 34.04 | 0 | 58.28 | 0
2020-07-01 00:00:00 | 70.46 | 18.65 | 331.76 | 37.27 | 0 | 60.58 | 0
2020-08-01 00:00:00 | 63.13 | 19.08 | 348.93 | 25.66 | 0 | 63.35 | 0
2020-09-01 00:00:00 | 73.77 | 18.93 | 351.2 | 38.94 | 0 | 61.85 | 0 |  |  |  |  |  |  |  | astjet09
2020-10-01 00:00:00 | 71.29 | 18.83 | 343.75 | 38.01 | 0 | 61.04 | 0
2020-11-01 00:00:00 | 77.45 | 19.88 | 397.06 | 43.43 | 0 | 66.62 | 0
2020-12-01 00:00:00 | 83.94 | 20.36 | 441.39 | 47.34 | 0 | 69 | 0
2020 YTD  FEES
2019 FEES
2019-01-01 00:00:00 | 73.91 | 21.85 | 275.08 | 32.6 | 0 | 0 | 0
2019-02-01 00:00:00 | 59.47 | 17.27 | 708.08 | 26.03 | 0 | 0 | 0
2019-03-01 00:00:00 | 61.02 | 17.62 | 727.79 | 26.56 | 0 | 0 | 0
2019-04-01 00:00:00 | 61.93 | 17.71 | 715.18 | 26.79 | 0 | 0 | 0
2019-05-01 00:00:00 | 64.98 | 17.97 | 778.36 | 29.8 | 0 | 0 | 0
2019-06-01 00:00:00 | 60.3 | 17.67 | 736.24 | 27 | 0 | 0 | 0
2019-07-01 00:00:00 | 66.13 | 18.21 | 560.28 | 30.49 | 0 | 0 | 0
2019-08-01 00:00:00 | 63.29 | 18.17 | 532.02 | 29.31 | 0 | 0 | 0
2019-09-01 00:00:00 | 66.24 | 18.31 | 561.22 | 31.22 | 0 | 0 | 0
2019-10-01 00:00:00 | 63.85 | 18.31 | 544.82 | 49.53 | 0 | 0 | 0
2019-11-01 00:00:00 | 65.6 | 18.48 | 410.01 | 33.61 | 0 | 15.07 | 0
2019-12-01 00:00:00 | 71.09 | 19.01 | 456.8 | 37.97 | 0 | 25.73 | 0
2019 YTD  FEES
2018 FEES
2018-12-31 00:00:00 | 11.86 | 3.51 | 44.08 | 5.22 | 0 | 0 | 0
Spreadsheet: 789152d1658930962-split-dollar-amount-into-different-amounts-based-on-percentage-copy-of-invoice-approval-splits-bg-sfy-2022
Sheet: Reference

BG TFC | 1 |  | BG TFC | 1 |  | BG TFC | 0.33
O'boro TFC |  |  | IL | 0 |  | FPP | 0.67
State Street Telecommunications |  |  |  |  |  |  |  |  | Office Supplies--All
BG TFC |  |  |  | From FPP State Budget |  |  |  |  | BG TFC |  |  | From FPP State Budget
FPP--ZFE1 |  |  |  | 481 | 12727.83 |  |  |  | FPP--ZFE1 |  |  | 481 | 6099.98
FPP--ZFAU |  |  |  | 482 | 4359.68 |  |  |  | FPP--ZFAU |  |  | 482 | 2089.43
FPP--ZAGV |  |  |  | 483 | 1912.5 |  |  |  | FPP--ZAGV |  |  | 483 | 916.59
Repairs & Maintenance |  |  |  |  |  |  |  |  | Membership Dues
BG TFC |  |  |  | From FPP State Budget |  |  |  |  | BG TFC |  |  | From FPP State Budget
FPP--ZFE1 |  |  |  | 481 | 1154.21 |  |  |  | IFPS |  |  | 481 | 148.04
FPP--ZFAU |  |  |  | 482 | 395.35 |  |  |  | FRS |  |  | 482 | 50.71
FPP--ZAGV |  |  |  | 483 | 173.43 |  |  |  | FACTS |  |  | 483 | 22.25
Equipment Rental & Lease |  |  |  |  |  |  |  |  | Office Supplies--FPP Only |  |  | From FPP State Budget
BG TFC |  |  |  | From FPP State Budget |  |  |  |  | FPP--ZFE1 |  |  | 481 | 6099.98
FPP--ZFE1 |  |  |  | 481 | 4886.82 |  |  |  | FPP--ZFAU |  |  | 482 | 2089.43
FPP--ZFAU |  |  |  | 482 | 1673.89 |  |  |  | FPP--ZAGV |  |  | 483 | 916.59
FPP--ZAGV |  |  |  | 483 | 734.3
 |  |  |  |  |  |  |  |  | Program Supplies--FPP Only |  |  | From FPP State Budget
Postage |  |  |  |  |  |  |  |  | FPP--ZFE1 |  |  | 481 | 15206.4
BG TFC |  |  |  | From FPP State Budget |  |  |  |  | FPP--ZFAU |  |  | 482 | 5208.67
FPP--ZFE1 |  |  |  | 481 | 105.84 |  |  |  | FPP--ZAGV |  |  | 483 | 2284.93
FPP--ZFAU |  |  |  | 482 | 36.25
FPP--ZAGV |  |  |  | 483 | 15.9
 |  |  |  |  |  |  |  |  | [NAME]--FPP Only |  |  | From FPP State Budget
 |  |  |  |  |  |  |  |  | FPP--ZFE1 |  |  | 481 | 4360.96
 |  |  |  |  |  |  |  |  | FPP--ZFAU |  |  | 482 | 1493.76
 |  |  |  |  |  |  |  |  | FPP--ZAGV |  |  | 483 | 655.28
 |  |  |  |  |  |  |  |  |  |  |  |  |  | `
Spreadsheet: 877217d1723947124-fully-automatic-seating-plan-exam-hall-for-various-group-input
Sheet: 7th bcom

S. No | Register No | Student Name
1 | 126117001 | Abhi
2 | 126117002 | Aboo
3 | 126117003 | Aksh
4 | 126117004 | Amrt
5 | 126117005 | [NAME]
6 | 126117006 | Anup
7 | 126117007 | Athi
8 | 126117008 | Badh
9 | 126117010 | Dhan
10 | 126117011 | Mall
11 | 126117012 | Hars
12 | 126117013 | [NAME]
13 | 126117014 | Kaus
14 | 126117015 | Kavy
15 | 126117016 | [NAME]
16 | 126117017 | Laks
17 | 126117018 | Maha
18 | 126117019 | Meer
19 | 126117020 | Mrud
20 | 126117021 | Muth
21 | 126117022 | Pira
22 | 126117023 | Poor
23 | 126117024 | Prad
24 | 126117025 | Rash
25 | 126117026 | Shre
26 | 126117027 | Shri
27 | 126117028 | Siva
28 | 126117029 | Siva
29 | 126117030 | Sree
30 | 126117031 | [NAME]
31 | 126117032 | Srik
32 | 126117033 | Sriv
33 | 126117034 | Vish
34 | 126117035 | Yoga
35 | 126117036 | [NAME]
36 | 126117037 | Pran
37 | 126117038 | Gane
Spreadsheet: 829030d1683870910-extract-dates-for-text-split_text
Sheet: Sheet1

My Sample |  |  | Date | My Sample.4
5_7_23_0031b1 |  |  | 2023-07-05 00:00:00 | 0031b1
5_7_23_0031bo1 |  |  | 2023-07-05 00:00:00 | 0031bo1
5_7_23_0031h1 |  |  | 2023-07-05 00:00:00 | 0031h1
5_8_23_0031b1 |  |  | 2023-08-05 00:00:00 | 0031b1
5_8_23_0031bo1 |  |  | 2023-08-05 00:00:00 | 0031bo1
5_8_23_0031h1 |  |  | 2023-08-05 00:00:00 | 0031h1
18_10_22_0021b1 |  |  | 2022-10-18 00:00:00 | 0021b1
18_10_22_0021b01 |  |  | 2022-10-18 00:00:00 | 0021b01
18_10_22_0021h1 |  |  | 2022-10-18 00:00:00 | 0021h1
Spreadsheet: andy_zipper__194__Broker detail 5-23-01
Sheet: BROKER DEAL SUMMARY

EnronOnline Broker Detail for 5/23/2001
Completed Transactions:
TODAY
Date | 2001-05-23 00:00:00
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 8 | 6 | 2081.25 | 676 | 14 | 2757.25
Natsource LLC |  | 10 |  | 519 | 10 | 519
Amerex Natural Gas I, Ltd. | 4 |  | 375 |  | 4 | 375
Amerex Power, Ltd. |  | 1 |  | 236 | 1 | 236
Grand Total | 12 | 17 | 2456.25 | 1431 | 29 | 3887.25
LIFE TO DATE (First Trade March 28, 2001)
 | Data | Commodity
 | DEAL COUNT |  | BROKER SAVING |  | Total DEAL COUNT | Total BROKER SAVING
Broker | Natural Gas | Power | Natural Gas | Power
APB Energy, Inc. | 60 | 148 | 16637.5 | 8988.04 | 208 | 25625.54
Natsource LLC | 28 | 200 | 4207.5 | 17988 | 228 | 22195.5
Power Merchants Group, LLC | 8 |  | 634.83 |  | 8 | 634.83
Amerex Natural Gas I, Ltd. | 32 | 1 | 5300 | 4 | 33 | 5304
Amerex Power, Ltd. |  | 5 |  | 748 | 5 | 748
Grand Total | 128 | 354 | 26779.83 | 27728.04 | 482 | 54507.87
Failed Transactions:
TODAY
Date | 2001-05-23 00:00:00
FAILED TRANSACTION COUNT | Commodity
Broker | Power | Grand Total
Natsource LLC | 1 | 1
Amerex Power, Ltd. | 1 | 1
Grand Total | 2 | 2
LIFE TO DATE (First Trade March 28, 2001)
FAILED TRANSACTION COUNT | Commodity
Broker | Natural Gas | Power | Grand Total
APB Energy, Inc. | 20 | 22 | 42
Natsource LLC | 4 | 37 | 41
Power Merchants Group, LLC | 20 |  | 20
Amerex Natural Gas I, Ltd. | 4 |  | 4
Amerex Power, Ltd. |  | 2 | 2
Grand Total | 48 | 61 | 109
Spreadsheet: 55967d1256126167-copy-of-invoice-using-macro-test
Sheet: Sheet1

 | I N V O I C E
 |  | Invoiced To: | xyz shipping co |  |  |  |  | Invoice No. | 2008/RCL/001
 |  | Address    : | #N/A |  |  |  |  | Date : | 2008-10-06 00:00:00
 |  | [NAME]. No. | #N/A |  | Fax No. | #N/A |  | Ref. No.
 |  | Vessel : | XXXXX |  | No.of Cont.  20' |  | 5
 |  | Voyage: | XXXXX |  | No.of Cont.  40' |  | 3 | Over Wt.20' | 0
 |  | Arrived : | 2008-09-22 00:00:00 |  | No.of D/O s |  | 0 | Over Wt.40' | 0
 |  | A/C: | XXXXX |  | Cargo Wt. In M/Ton |  | 0 | Operator : | 0
 | Sl. No. | Description |  |  |  |  |  | Qty. | Rate | Amount   [KWD ]
 | 1 |  |  |  |  |  |  | 5 | 15 | 75
 | 2 |  |  |  |  |  |  | 3 | 16 | 48
 | 3 |  |  |  |  |  |  | 5 | 17 | 85
 | 4 |  |  |  |  |  |  | 3 | 18 | 54
 | 5 |  |  |  |  |  |  | 5 | 19 | 95
 | 6 |  |  |  |  |  |  | 3 | 20 | 60
 | 7 |  |  |  |  |  |  | 5 | 21 | 105
 | 8 |  |  |  |  |  |  | 3 | 22 | 66
 | 9 |  |  |  |  |  |  | 0 | 23 | 0
 | 10 |  |  |  |  |  |  | 0 | 24 | 0
 | 11 |  |  |  |  |  |  | 0 | 25 | 0
 | 12 |  |  |  |  |  |  | 0 | 26 | 0
 | 13 |  |  |  |  |  |  | 0 | 27 | 0
 | 14 |  |  |  |  |  |  | 0 | 28 | 0
 | 15 |  |  |  |  |  |  |  | 29 | 0
 | T O T A L |  |  |  |  |  |  |  |  | 25890
 | Twenty Five Thousand Eight Hundred Ninety Only
 |  | Prepared By |  |  | Approved  By |  |  | Received By
 |  | Signature |  |  | Signature |  |  | Signature
 |  | Date | 2008-10-06 00:00:00 |  | Date |  |  | Date
 |  |  |  |  |  |  |  |  |  | 1
 | I N V O I C E
 |  | Invoiced To: | mnp shipping co |  |  |  |  | Invoice No. | 2008/RCL/02
 |  | Address    : | #N/A |  |  |  |  | Date : | 2008-10-06 00:00:00
 |  | [NAME]. No. | #N/A |  | Fax No. | #N/A |  | Ref. No.
 |  | Vessel : | xxxx |  | No.of Cont.  20' |  | 5
 |  | Voyage: | xxxx |  | No.of Cont.  40' |  | 3 | Over Wt.20' | 0
 |  | Arrived : | 2008-09-22 00:00:00 |  | No.of D/O s |  | 0 | Over Wt.40' | 0
 |  | A/C: | xxxx |  | Cargo Wt. In M/Ton |  | 0 | Operator : | 0
 | Sl. No. | Description |  |  |  |  |  | Qty. | Rate | Amount   [KWD ]
 | 1 |  |  |  |  |  |  | 5 | 100 | 500
 | 2 |  |  |  |  |  |  | 3 | 101 | 303
 | 3 |  |  |  |  |  |  | 5 | 102 | 510
 | 4 |  |  |  |  |  |  | 3 | 103 | 309
 | 5 |  |  |  |  |  |  | 5 | 104 | 520
 | 6 |  |  |  |  |  |  | 3 | 105 | 315
 | 7 |  |  |  |  |  |  | 5 | 106 | 530
 | 8 |  |  |  |  |  |  | 3 | 107 | 321
 | 9 |  |  |  |  |  |  | 0 | 108 | 0
 | 10 |  |  |  |  |  |  | 0 | 109 | 0
 | 11 |  |  |  |  |  |  | 0 | 110 | 0
 | 12 |  |  |  |  |  |  | 0 | 111 | 0
 | 13 |  |  |  |  |  |  | 0 | 112 | 0
 | 14 |  |  |  |  |  |  | 0 | 113 | 0
 | 15 |  |  |  |  |  |  |  | 114 | 0
 | T O T A L |  |  |  |  |  |  |  |  | 25890
 | Twenty Five Thousand Eight Hundred Ninety Only
 |  | Prepared By |  |  | Approved  By |  |  | Received By
 |  | Signature |  |  | Signature |  |  | Signature
 |  | Date | 2008-10-06 00:00:00 |  | Date |  |  | Date
 |  |  |  |  |  |  |  |  |  | 2
Spreadsheet: 815602d1675082455-check-missing-elements-of-two-sheets-1897-check-lists
Sheet: List1

car |  |  |  | car
ape |  |  |  | ape | <-- red because is missing in List2
bike |  |  |  | bike
ship |  |  |  | ship
 |  | what i need | -->
Spreadsheet: 695874d1600436467-merging-data-by-using-unique-reference-in-excel-investor-detail_merge_fund_perf_vlookup_chris
Sheet: Sheet2

Inv Ref | Total Contribution | Units | Unit price | Current Value | Gains or Losses
EXA001 | 100000 | 1000 | 135.448 | 135448 | 35448
EXA002 | 112000 | 112 | 1209.3571 | 135448 | 23448
EXA003 | 124000 | 124 | 1092.3226 | 135448 | 11448
EXA004 | 136000 | 136 | 995.9412 | 135448 | -552
EXA005 | 148000 | 148 | 915.1892 | 135448 | -12552
EXA006 | 160000 | 160 | 846.55 | 135448 | -24552
EXA007 | 172000 | 172 | 787.4884 | 135448 | -36552
EXA008 | 184000 | 184 | 736.1304 | 135448 | -48552
EXA009 | 196000 | 196 | 691.0612 | 135448 | -60552
EXA010 | 208000 | 208 | 651.1923 | 135448 | -72552
EXA011 | 220000 | 220 | 615.6727 | 135448 | -84552
EXA012 | 232000 | 232 | 583.8276 | 135448 | -96552
EXA013 | 244000 | 244 | 555.1148 | 135448 | -108552
EXA014 | 256000 | 256 | 529.0938 | 135448 | -120552
EXA015 | 268000 | 268 | 505.403 | 135448 | -132552
EXA016 | 280000 | 280 | 483.7429 | 135448 | -144552
EXA017 | 292000 | 292 | 463.863 | 135448 | -156552
EXA018 | 304000 | 304 | 445.5526 | 135448 | -168552
EXA019 | 316000 | 316 | 428.6329 | 135448 | -180552
EXA020 | 328000 | 328 | 412.9512 | 135448 | -192552
EXA021 | 340000 | 340 | 398.3765 | 135448 | -204552
EXA022 | 352000 | 352 | 384.7955 | 135448 | -216552
EXA023 | 364000 | 364 | 372.1099 | 135448 | -228552
EXA024 | 376000 | 376 | 360.234 | 135448 | -240552
EXA025 | 388000 | 388 | 349.0928 | 135448 | -252552
EXA026 | 400000 | 400 | 338.62 | 135448 | -264552
EXA027 | 412000 | 412 | 328.7573 | 135448 | -276552
EXA028 | 424000 | 424 | 319.4528 | 135448 | -288552
EXA029 | 436000 | 436 | 310.6606 | 135448 | -300552
EXA030 | 448000 | 448 | 302.3393 | 135448 | -312552
Spreadsheet: 761747d1641199070-i-need-help-with-automatic-display-of-days-excel-helpdesk-ans
Sheet: Ark1

Losserate | 75 | Fart | 9 | Avg: | 02:50:00 |  | 2022-01-02 00:00:00 |  | <--- | I would like to have the days(marked green) to automatically update when i change the time and date
[NAME] | Tonn | Dist | Lossetid | Seiletid | ETA | ETD | Day | Sekk | <-- | The ETA column is the deciding column for the day
 | 60 | 26.5 |  |  |  | 07:20:00 | Sun | 0 |  |  |  |  |  |  | [NAME] | 00:15:00
 | 57.5 | 10 |  |  |  |  | Sun | 115 |  |  |  |  |  |  | [NAME] | 02:00:00
 | 70 | 17 |  |  |  |  | Sun | 0 |  |  |  |  |  |  | [NAME] | 00:45:00
 | 120 | 1.5 |  |  |  |  | Sun | 0
 | 120 | 2 |  |  |  |  | Sun | 0
 | 75 | 25 |  |  |  |  | Sun | 0
 | 75 | 4 |  |  |  |  | Sun | 0
 |  | 46.5 |  |  |  |  | Mon | 0
 |  |  | [NAME] |  |  |  | Sekk
Spreadsheet: 716510d1612250701-increment-the-value-with-a-decimal-value-after-n-rows-increment-by-decimals
Sheet: Sheet2

Number | C1 |  | Expected
1.1 |  |  | 1.1
 |  |  | 1.1
 |  |  | 1.1
 |  |  | 1.1
 |  |  | 1.1
 |  |  | 1.2
 |  |  | 1.2
 |  |  | 1.2
 |  |  | 1.2
 |  |  | 1.2
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.3
 |  |  | 1.4
 |  |  | 1.4
 |  |  | 1.4
 |  |  | 1.4
 |  |  | 1.4