tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 871862d1718261987-how-to-count-and-determine-of-filtered-data-efrollingamount
Sheet: Sheet1

Path | Race | On | Off | Total | Box
1 | B4 | [NAME] | 740a |  | B
1 | [NAME] | [NAME] | 740a |  | G
1 | K2 | 715a | 740a |  | K
1 | F1 | 659a | 740a |  | F
1 | K1 | 704a | 740a |  | K
2 | A1 | 708a | 740a |  | A
2 | J1 | 718a | 740a |  | J
2 | B2 | [NAME] | 740a |  | B
2 | H1 | 300p | 332p |  | H
2 | E1 | 300p | 322p |  | E
1 | G3 | 255p | 331p |  | G
2 | G2 | 300p | 317p |  | G
1 | B1 | 255p | 336p |  | B
1 | D1 | 255p | 323p |  | D
1 | B3 | 255p | 323p |  | B
1 | C1 | 255p | [NAME] |  | C
Spreadsheet: 731569d1620413700-help-formula-to-find-a-match-for-cell-and-return-value-of-the-title-of-that-column-league-2
Sheet: ENJ

S.N. | Particulars | Bought  Units | Unit or ENJ Price | Bought/ Sold Price  ($US) | Bought/ Sold Price (BTC) | Token Unit Price During Txn | Activity  Date | Received Date | Fee  ($US) | Fee (%) | Total Price ($US) | Estimated  Price ($US) | Status | Notes
1 | Enjin Coin @ Binance - Purchase | 5494 | 1.83e-05 |  | -0.10065 | 7582.8 | 2018-02-07 00:00:00 | 2018-02-07 00:00:00
2 | Enjin Coin @ Binance - Sale | -4493.5 | 2.25e-05 |  | 0.10108467 | 11166.9 | 2018-02-19 00:00:00
3 | Enjin Coin @ Binance - Sale | -1000 | 1.484e-05 |  |  | 7083 | 2018-03-29 00:00:00
4
5
6
7
8
 | Enjin Coin in Ledger Nano S | 0
 | Enjin Coin in Bittrex | 0
 | Enjin Coin in Binance | 0.5
 | Total Investment Loss/Profit ($US)
 | Website: https://
 | Contract address:
 | Symbol:
 | Decimals:
 | About/Idea
 | Team Members (reputation, prior projects, LinkedIn, social presence)
 | Website Design
 | White Paper
 | ICO Rating
 | www.icoranker.com
 | www.icobench.com
 | www.tokenmarket.net
 | Marketing
 | Twitter
 | Instagram
 | Facebook
 | CEO Presence in the market
 | Roadmap & timeline
 | When are they hitting the exchanges?
Spreadsheet: tracy_geaccone__40323__3rd quarter curr est
Sheet: FundsFlow

DETAIL OF FUNDS FLOW
(Millions of Dollars)
 |  |  |  | 2001 Est |  | 2001 Plan |  | [NAME] |  | Explanation
 | Net Income |  |  |  |  | 87.7 |  |  |  | See below (1)
 | Depreciation, depletion & amortization |  |  |  |  |  |  |  |  | See below (1) and (2)
 | Deferred income taxes |  |  |  |  | 9.9 |  |  |  | See below (3)
 | Equity Earnings |  |  |  |  | 0
 | Net (gain)/loss on sale of assets |  |  |  |  | 8.3 |  |  |  | Purchase accounting valuation allowance reversal (Pelton/RB sale)
 | Unrealized (gain)/loss on price risk mgmt activities |  |  |  |  | 0 |  |  |  | See below (4)
 | Merchant Activities
 |  | Realized (Gains) / Losses on Sales |  |  |  | 0
 |  | Proceeds from Sales |  |  |  | 0
 |  | Additions |  |  |  | 0
 |  | Unrealized (Gains) / Losses |  |  |  | 0
 | Equity/Partnership Distributions |  |  |  |  | 0
 | Oil & gas exploration expenses |  |  |  |  | 0
 | Dividends on Pref Securities of Subsidiary Companies |  |  |  |  | 0
 | Income Attributable to Minority Interest |  |  |  |  | 0
 | Other (including transfers & reclasses) |  |  |  |  | 24.3 |  |  |  | See below (5)
 |  | Funds Flow
[NAME] Needed: |  |  |  | Current Estimate vs. Plan
 | (1) Net Income
 |  | Plan has been adjusted by ($3.4) mm for GATX fee and $10.4 mm for transfer of goodwill to ENA
 | (2) DDA
 |  | Forecast includes PCA adjustment of ($86.0) [NAME], plan PCA is ($143) [NAME]
 | (3) Deferred Taxes
 |  | Includes $9 mm reversal of Toli taxes
 | (4) PRMA
 |  | Includes $10.5m cumulative effect of SFAS 133 accounting change, which was previously classified under Other,
 |  | as well as mark-to-market adjustments
 | (5) Other - must net with variance of Merchant Activities due to reclass:
 |  | Contains Dividend on Preferred Securities of Subsidiary Cos., Receivable/Payable - Corp, and Other, net
 |  | No longer contains $10.5m cum effect of SFAS 133 actg change, reclassified as PRMA
Spreadsheet: 737064d1624093836-lookup-in-2-ranges-ranges-and-return-a-value-sample-sheet
Sheet: Sheet1

 |  | [NAME] |  | [NAME] |  | Mark |  | Ian
 |  | Document 1 |  | Document2 |  | Document2 |  | Document1
 |  | Document 2 |  | Document3 |  | Document3 |  | Document2
 |  | Document 3 |  | Document 5 |  | Document4 |  | Document 5
 |  | Document 4 |  | Document 6 |  | Document5 |  | Document 6
 |  | Document 5 |  | Document 7 |  | Document 9 |  | Document 8
 |  | Document 6 |  | Document 9 |  | Document 10 |  | Document 17
 |  | Document 7 |  | Document 15 |  | Document 17 |  | Document 18
 |  | Document 8 |  | Document 16 |  | Document 21 |  | Document 19
 |  | Document 9 |  | Document 17 |  | Document 22 |  | Document 20
 |  | Document 10 |  | Document 21 |  | Document 26 |  | Document 21
 |  | Document 11 |  | Document 22 |  |  |  | Document 22
 |  | Document 17 |  | Document 23
 |  | Document 21
 |  | Document 22
 |  | Document 24
 |  | Document 25
Spreadsheet: 542894d1508158510-classroom-problem-sums-of-rows-with-overlapping-timeslots-overlapping-courses-part-2
Sheet: Time Intervals

Start Time | End Time |  | School A | School B | School C | School D |  | Totals: | How Many Time Slots Overlap? | How Many Classes Overlap? | How Many Classes Overlap? Buffered
13:00:00 | 14:00:00 |  | 5 | 10 | 5 | 2
13:15:00 | 15:00:00 |  | 4 | 0 | 0 | 6
13:30:00 | 14:30:00 |  | 1 | 2 | 9 | 4
14:15:00 | 15:00:00 |  | 3 | 6 | 0 | 7
14:30:00 | 16:30:00 |  | 4 | 2 | 5 | 7
16:00:00 | 18:00:00 |  | 0 | 8 | 5 | 0
16:30:00 | 18:30:00 |  | 4 | 1 | 5 | 0
17:00:00 | 18:15:00 |  | 0 | 12 | 0 | 0
17:30:00 | 19:00:00 |  | 2 | 5 | 8 | 2
17:45:00 | 19:15:00 |  | 5 | 4 | 6 | 7
18:10:00 | 19:00:00 |  | 5 | 4 | 12 | 2
18:50:00 | 20:50:00 |  | 10 | 7 | 0 | 3
19:10:00 | 21:15:00 |  | 7 | 2 | 8 | 4
19:45:00 | 21:30:00 |  | 0 | 0 | 1 | 0
20:00:00 | 22:00:00 |  | 0 | 0 | 5 | 0
Spreadsheet: 102110d1300146775-excel-form-creation-book1
Sheet: Sheet1

BU affected | Primary Resolver Group | Managed By | Priority | BI Rating | System Name | Month | Start Date | Start Time | End Date | End Time | Duration in mins | Duration in Hours & Mins | External Ref No | Internal Ref No | Problem # | Business Impact | Description | Resolution Activity | Repeat,Recurring | Cause Code(E.g: Change, Release, Human Err, [NAME], RC Unknown, Software, Certificate, Network) | Root Cause | Root Cause Details | ICR
drop down | drop down | drop down | radio | radio | text | drop down | need a date and time picker for these 4 |  |  |  | auto calculated from start and end time | auto calculated from start and end time | text | text | text | text | text | text | radio | drop down with options above | radio | text | radio
 |  |  | 1 | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | yes |  | yes |  | yes
 |  |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | no |  | no |  | no
 |  |  |  | 3
 |  |  |  | 4
Spreadsheet: 69282d1269836807-transpose-column-to-rows-transpose
Sheet: Sheet1

Sales Data |  |  | Expected Result
Data | Y |  | Data | Y | N | M
Data | N |  | Data1 | M | Y
Data | M |  | Data2 | N | Y
Data1 | M
Data1 | Y
DATA2 | N
DATA2 | Y
Spreadsheet: 82265d1282253902-excel-2007-lottery-numbers-lotto
Sheet: WINNINGS

Main [NAME] |  |  |  |  |  |  | Bonus |  | Subscription Numbers |  |  |  |  |  |  |  | Max million Numbers
1 | 6 | 8 | 11 | 12 | 16 | 20 | 9 |  | 1 | 3 | 7 | 8 | 9 | 12 | 18 | Would like to count the Green matches and the Red Matches | 1 | 3 | 7 | 8 | 9 | 12 | 18 | I need a complete match to win, so if one of my sets is equal to a Max million set is there a way to show that?
 |  |  |  |  |  |  |  |  | 2 | 6 | 8 | 12 | 14 | 28 | 35 |  |  |  |  |  |  |  |  | Each max million set is compared to each of my sets, so I can't do it the same as the Main draw
Spreadsheet: 50748d1250205452-spreadsheet-w-logic-for-it-app-deployments-example-for-help
Sheet: Sheet1

UserID's in scope for Deployment | Functional Team #1 | Functional Team #2 | Functional Team #3 | Functional Team #4 | Functional Team #5 | Functional Team #6 | Functional Team #7 | Functional Team #8 | Functional Team #9 | Functional Team #10 | Functional Team #11 | UserID that can be deployed | UserID that can't be deployed | If Cannot be deployed, then what Functional Team(s) are they a member of?
bobc |  |  |  |  |  |  |  |  |  |  |  | bobc
amya |  | amya |  |  |  | amya |  |  | amya |  |  |  | amya | 2,6,9
Spreadsheet: 728484d1618482160-sum-columns-where-date-appears-on-column-heading-shipments-in-april-aligw
Sheet: Expected Results

Part Num | Required | Shipped in April | Shipped 08.03.2021 | Shipped 15.03.2021 | Shipped 23.03.2021 | Shipped 02.04.2021 | Shipped 12.04.2021 | Shipped 18.04.2021
A1 | 46 | 17 | 2 | 0 | 13 | 6 | 3 | 8
A2 | 36 | 18 | 2 | 4 | 6 | 5 | 7 | 6
A3 | 41 | 34 | 14 | 6 | 5 | 14 | 6 | 14
A4 | 42 | 34 | 3 | 0 | 10 | 7 | 14 | 13
A5 | 20 | 28 | 12 | 1 | 10 | 15 | 4 | 9
A6 | 27 | 6 | 9 | 11 | 12 | 2 | 4 | 0
A7 | 19 | 23 | 7 | 3 | 14 | 5 | 15 | 3
Spreadsheet: 274552d1383147979-finding-value-using-formulas-functions-or-macros-in-intersection-of-2-data-series-in-graph-example_book_reattachted
Sheet: EXAMPLE2

 | DATA SERIE1
 | DATA FOR BLACK  LINE
 | Y AXE | X AXE
 | 76.19999999999999 | 100
 | 63.5 | 100
 | 50.8 | 100
 | 38.09999999999999 | 91.50101499880945
 | 25.4 | 70.84382260900783
 | 19.05 | 52.00945669897193
 | 12.5 | 36.30945669897193
 | 9.5 | 30.50945669897193
 | 4.75 | 23.00945669897193
 | 2 | 18.90945669897193
 | 0.42 | 16.00945669897193
 | 0.075 | 12.80945669897193
 |  |  |  |  | data for red vertical line
 |  |  | NUMBER THAT I WANT  TO FIND  AUTOMATICALLY USING FUNCTIONS  FORMULAS OR [NAME] |  | 21.5 |  | 0 | 60 | DATA SERIE 2
 |  |  |  |  | THIS NUMBER  IS THE X VALUE FOR WHICH THE Y VALUE FOR THE SERIE1 IS 60 |  |  | NOTE:VALUES IN X AXE IS IN INVERSE ORDER THE SCALE OF X AXE IS IN LOG BASE 10
Spreadsheet: 8b18ec97-aed6-49c4-a690-6afb29a6bc84
Sheet: Land Calc

Information Concerning Land or Property
Pursuant to New Construction, Substantial Rehabilitation, Blended Rate and Section 241(a)
Last Arms-Length Transaction
Buyer
[NAME]
Date Acquired
Purchase Price | 0
Additional Cost | 0
Annual Ground Rent | 0
Total Cost
Note: If this is an allocation of a purchase of a larger site or a combination of multiple sites
provide detail (including basis of allocation) below.
Special Assessments
Prepayable, Non-Prepayable or N/A
Principal Balance | 0
Annual Payment | 0
Remaining Term
Value of Land and Cost Certification
Fair Market Value of land fully improved | 0
Deduct unusual land improvements | 0
Equals warranted price of land fully improved
For Cost Certification Purposes:
Demolition | 0
Off-site Cost | 0
Estimate of "as is" by subtraction from improved value
Estimate of "as is" by comparison (from appraisal) | 0
"As is" based on acquisition cost (include legal, title, etc.) | 0
Estimate of value of land "as is" for cost certification purposes
Spreadsheet: 684288d1593268612-how-to-count-same-numbers-products-from-another-data-from-each-rows-c2-i1000000-inventory
Sheet: Cover

Sr no | SAP code | Product A | Product B | Product C | Product D | Product E | Product F | product G | Counted same product from 2nd data (from each rows)
JA-0090-20 | SS-002245 | 125666 | 125667 | 15 | 556 | 557 | 558 | 556
JA-0090-21 | SS-002246 | 01 | 2985 | 02 | 668 | 88855 | 09 | 888
JA-0090-22 | SS-002247 | 21333 | 67345986 | 475 | 4423 | 999323 | 7767987 | 345934
JA-0090-23 | SS-002248
JA-0090-24 | SS-002249
JA-0090-25 | SS-002250
Spreadsheet: 834854d1688122625-how-can-i-list-all-the-corresponding-values-based-on-certain-values-that-appeared-in-anoth-list-of-color-names-by-individuals
Sheet: Sheet1

Red | Orange | Yellow | Green | Blue | Navy | Purple | There are upto 50 columns..
[NAME], [NAME] | Babalola, [NAME] | Brown, Kehau | Abbasi, Imran | Altenbaugh, [NAME] | Abbasi, Imran | [NAME], [NAME]
Adefehinti, Mo | Brown, Kehau | Brown, Kehau | [NAME], [NAME] | Pierce, Karin | King, [NAME] | [NAME], [NAME]
[NAME], [NAME] | Gonring, [NAME] | Etheridge, Christine | Develice, [NAME] | Solanki, Dishal | Pierce, Karin | Drake, [NAME]
Babalola, [NAME] | Khalil, Haydy | Froelich, Sara | Doney, [NAME] |  | [NAME], [NAME] | Platt, Frances
[NAME], [NAME] | [NAME], Lyn | Kieckbusch, [NAME] | [NAME], [NAME] |  | Solanki, Dishal | Schreiner, Trisha
[NAME], Michon | Lewis, Janelle | Kostanyan, Gor | Kieckbusch, [NAME] |  |  | Sokova-Robles, [NAME]
Daigle, Amanda | Michalski, Stacy | [NAME], [NAME] | Linnartz, [NAME] |  |  | Stauceanu, Bogdan
Doney, [NAME] | [NAME], [NAME] |  | [NAME], [NAME]
Doney, [NAME] | Radtke, [NAME] |  | Newcomer, [NAME]
Esalapuram, DIVYA |  |  | Parra, [NAME]
Gonring, [NAME] |  |  | [NAME], Rupal
Hepesh, Wadeda |  |  | Perrotti, Gwen
[NAME], Holly |  |  | Rimarcuk, Jen
Lewis, Janelle |  |  | Schreiner, Trisha
Mabe, Cristal |  |  | Taiwo, Anthonette
Meinen, [NAME] |  |  | [NAME], Rachel
[NAME], [NAME] |  |  | Wagner, [NAME]
Newcomer, [NAME] |  |  | Zeiger, Jessica
Newton, [NAME]
Noonan, [NAME]
Okpara, Chika
Painter, [NAME]
Patwal, Pooja
Spreadsheet: 145908d1331811053-summing-multiple-sheets-indirect-formula-sum-multiple-sheets
Sheet: 1

 |  |  |  |  | Total M2 by Product |  |  |  |  |  |  |  |  |  |  |  | Total Sales by Product
 |  | Product 1 | Extra 1 |  | 7 | 5 | 5 | 5 | 7 | 3 | 3 | 4 | 4 | 5 | 48 |  | 57 | 13 | 93 | 66 | 25 | 10 | 69 | 34 | 31 | 93 | 491
 |  | Product 2 | Extra 2 |  | 8 | 7 | 1 | 8 | 7 | 3 | 3 | 10 | 6 | 9 | 62 |  | 100 | 94 | 73 | 97 | 17 | 97 | 64 | 78 | 51 | 81 | 752
 |  | Product 3 | Extra 3 |  | 4 | 10 | 2 | 5 | 3 | 8 | 2 | 4 | 2 | 10 | 50 |  | 28 | 91 | 54 | 100 | 57 | 69 | 84 | 20 | 94 | 25 | 622
 |  | Product 4 | Extra 4 |  | 3 | 6 | 5 | 8 | 8 | 3 | 10 | 8 | 1 | 10 | 62 |  | 10 | 48 | 83 | 81 | 89 | 26 | 29 | 12 | 31 | 22 | 431
 |  | Product 5 | Extra 5 |  | 8 | 8 | 3 | 4 | 4 | 5 | 6 | 9 | 8 | 10 | 65 |  | 26 | 13 | 19 | 72 | 29 | 93 | 66 | 60 | 66 | 68 | 512
 |  | Product 6 | Extra 6 |  | 10 | 5 | 2 | 4 | 4 | 10 | 6 | 3 | 9 | 2 | 55 |  | 100 | 32 | 100 | 48 | 16 | 56 | 71 | 39 | 66 | 44 | 572
 |  | Product 7 | Extra 7 |  | 5 | 10 | 7 | 10 | 5 | 5 | 4 | 7 | 7 | 2 | 62 |  | 69 | 89 | 85 | 59 | 30 | 81 | 24 | 22 | 54 | 98 | 611
 |  | Product 8 | Extra 8 |  | 8 | 2 | 2 | 6 | 1 | 2 | 10 | 4 | 9 | 1 | 45 |  | 22 | 33 | 84 | 24 | 80 | 55 | 82 | 92 | 67 | 92 | 631
 |  | Product 9 | Extra 9 |  | 2 | 8 | 2 | 2 | 2 | 4 | 2 | 8 | 7 | 1 | 38 |  | 37 | 25 | 17 | 40 | 79 | 54 | 58 | 75 | 34 | 41 | 460
 |  | Product 10 | Extra 10 |  | 4 | 5 | 7 | 3 | 8 | 10 | 9 | 9 | 3 | 4 | 62 |  | 51 | 79 | 88 | 33 | 94 | 100 | 27 | 36 | 87 | 57 | 652
 |  | Product 11 | Extra 11 |  | 9 | 5 | 5 | 5 | 3 | 5 | 5 | 8 | 1 | 6 | 52 |  | 99 | 100 | 61 | 45 | 52 | 44 | 16 | 78 | 94 | 38 | 627
 |  | Product 12 | Extra 12 |  | 9 | 8 | 2 | 1 | 4 | 10 | 3 | 8 | 5 | 2 | 52 |  | 67 | 100 | 80 | 22 | 91 | 18 | 20 | 76 | 60 | 39 | 573
 |  | Product 13 | Extra 13 |  | 7 | 10 | 8 | 5 | 8 | 5 | 5 | 9 | 2 | 8 | 67 |  | 59 | 24 | 87 | 63 | 14 | 20 | 29 | 88 | 77 | 45 | 506
 |  | Product 14 | Extra 14 |  | 8 | 10 | 6 | 10 | 2 | 2 | 5 | 4 | 5 | 7 | 59 |  | 62 | 32 | 45 | 58 | 79 | 92 | 37 | 90 | 54 | 48 | 597
 |  | Product 15 | Extra 15 |  | 2 | 9 | 9 | 8 | 10 | 2 | 5 | 9 | 6 | 4 | 64 |  | 23 | 15 | 30 | 24 | 43 | 32 | 42 | 50 | 84 | 67 | 410
 |  | Product 16 | Extra 16 |  | 4 | 8 | 8 | 3 | 10 | 9 | 6 | 1 | 4 | 2 | 55 |  | 46 | 81 | 55 | 23 | 14 | 56 | 80 | 73 | 13 | 94 | 535
 |  |  |  |  | 98 | 116 | 74 | 87 | 86 | 86 | 84 | 105 | 79 | 83 | 898 |  | 856 | 869 | 1054 | 855 | 809 | 903 | 798 | 923 | 963 | 952 | 8982
Spreadsheet: b88c6769-5bc8-45b1-bff3-9a38f960c58a
Sheet: Sheet1

President & Vice-President of the United States -  (North Dakota) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Downloaded at 5/18/2013 10:07:58 PM
Precincts Reporting: 607/607 - Total Ballots Cast: 316016
2004 General Election - OFFICIAL RESULTS
Name | [NAME] | [NAME] | [NAME] | [NAME] Peroutka - CON | [NAME] | [NAME] | TOTALS
President & Vice-President of the United States | 196625 | 111036 | 10 | 514 | 851 | 3749 | 312785
TOTAL | 196625 | 111036 | 10 | 514 | 851 | 3749 | 312785
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: 220500d1363182052-group-up-same-values-and-provide-total-sample-data1
Sheet: PROJECT QUOTE

COMPONENT BREAKDOWN |  |  |  | REQUIRED RESULT
 | No. |  |  | 32 | 6000mm x 1100mm Frame - Type 08
 | No. |  |  | 160 | 5025mm x 1100mm Frame - Type 08
 | No.
 | No.
 | No.
 | No. | 2mm Shims - Narrow Aisle
 | No. | 3mm Shims - Narrow Aisle
 | No. | 2mm Shims
 | No. | 3mm Shims
 | No. | [NAME]
 | No. |  |  | 288 | 250mm row [NAME] (incl. fixings)
 | No.
 | No.
 | No.
 | No.
 |  |  |  | 800 | C100S Box Beam Section - 2700mm clear entry ([NAME] UDL 2500Kgs)
 |  |  |  | 96 | U110H Open Beam Section - 2700mm clear entry ([NAME] UDL 2000Kgs)
 |  |  |  | 208 | U70S Open Beam Section - 2700mm clear entry ([NAME] UDL 1500Kgs)
 | No. | Plastic beam safety locks
Spreadsheet: 674906d1588075250-sort-employees-in-roster-test-shops
Sheet: Sheet 3

 |  |  |  | 2020-06-01 00:00:00
 |  |  |  | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN
 |  |  |  | 1 | 2
Shop 1 | SP1 | 2 persons | A
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Shop 2 | SP2 | 2 persons | B
 |  |  |  | [NAME]
 |  |  |  | Terrell Barnes
Shop 3 | SP3 | 2 persons | C
 |  |  |  | [NAME]
 |  |  |  | Jim Haynes
Shop 4 | SP4 | 1 persons | D
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Shop 5 | SP5 | 3 persons | D
 |  |  |  | [NAME]
 |  |  |  | Terence Edwards
 |  |  |  | Crystal Ryan
Shop 6 | SP6 | 4 persons | E
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Shop 7 | SP7 | 2 persons | F
 |  |  |  | [NAME].
 |  |  |  | [NAME]
Shop 8 | SP8 | 2 persons | G
 |  |  |  | [NAME].
 |  |  |  | [NAME].
Shop 9 | SP9 | 2 persons | H
 |  |  |  | [NAME]
 |  |  |  | [NAME]
Spreadsheet: 71293d1271961356-quotation-populate-date-from-price-list-sample-quote-automated
Sheet: DATA

Price List
QTY | PART NO | [NAME] | PRICE
0 | 125458 | Application Software  F/1 | 500
1 | 125459 | Application Software  F/2 | 800
2 | 125460 | Application Software  F/3 | 1100
3 | 125461 | Server Core2Due | 1200
4 | 125462 | Harddisk 34 | 400
5 | 125463 | Raid controller | 200
Spreadsheet: 867265d1714116728-complex-transpose-problem-example-report
Sheet: Sheet1

 | The table has 350+ lines and the quantity columns go up to 10, so not a huge amount of data, but too much to do manually.
 | And this is also a nice exercise for me to improve my Excel skills.
 | Starting table |  |  |  |  |  |  |  | Desired output
 | Item | 1 | 2 | 3 | 4 | 5 |  |  | item | qty | price
 | aaa | 10 | 9 | 8 |  |  |  |  | aaa | 1 | 10
 | bbb | 15 |  |  |  |  |  |  | aaa | 2 | 9
 | [NAME] | 20 | 18 | 16 | 15 | 14 |  |  | aaa | 3 | 8
 | ddd | 10 | 8 | 6 | 5 | 4 |  |  | bbb | 1 | 15
 | eee | 30 | 25 | 22 |  |  |  |  | [NAME] | 1 | 20
 |  |  |  |  |  |  |  |  | [NAME] | 2 | 18
 |  |  |  |  |  |  |  |  | [NAME] | 3 | 16
 |  |  |  |  |  |  |  |  | [NAME] | 4 | 15
 |  |  |  |  |  |  |  |  | [NAME] | 5 | 14
 |  |  |  |  |  |  |  |  | ddd | 1 | 10
 |  |  |  |  |  |  |  |  | ddd | 2 | 8
 |  |  |  |  |  |  |  |  | ddd | 3 | 6
 |  |  |  |  |  |  |  |  | ddd | 4 | 5
 |  |  |  |  |  |  |  |  | ddd | 5 | 4
 |  |  |  |  |  |  |  |  | eee | 1 | 30
 |  |  |  |  |  |  |  |  | eee | 2 | 25
 |  |  |  |  |  |  |  |  | eee | 3 | 22
Spreadsheet: 785860d1656764257-running-total-of-time-2022-07-02-oeldere-stixjohno-time-running-total-flex
Sheet: Sheet1

 |  | DATE | FLEX on or off HRS:MIN | R/TOTAL HRS:MIN | Want to achieve running total with formula as I add "FLEX on or off" value |  |  |  |  | 1440
 |  | 2022-06-01 00:00:00 | 00:00 | +03:47
 |  | 2022-06-02 00:00:00 | 00:20:00 | +04:07
 |  | 2022-06-03 00:00:00 | 00:49:00 | +04:56
 |  | 2022-06-04 00:00:00 | 00:00 | +04:56
 |  | 2022-06-05 00:00:00 | 00:00 | +04:56
 |  | 2022-06-06 00:00:00 | 00:20:00 | +05:16
 |  | 2022-06-07 00:00:00 | 00:00 | +05:16
 |  | 2022-06-08 00:00:00 | 00:00 | +05:16
 |  | 2022-06-09 00:00:00 | 00:00 | +05:16
 |  | 2022-06-10 00:00:00 | 00:00 | +05:16
 |  | 2022-06-11 00:00:00 | 00:00 | +05:16
 |  | 2022-06-12 00:00:00 | 00:00 | +05:16
Negative |  | 2022-06-13 00:00:00 | 00:55:00 | +04:21
 |  | 2022-06-14 00:00:00 | 00:00 | +04:21
 |  | 2022-06-15 00:00:00 | 00:00 | +04:21
 |  | 2022-06-16 00:00:00 | 00:00 | +04:21
Negative |  | 2022-06-17 00:00:00 | 00:56:00 | +03:25
 |  | 2022-06-18 00:00:00 | 00:55:00 | +04:20
Negative |  | 2022-06-19 00:00:00 | 00:40:00 | +03:40
Negative |  | 2022-06-20 00:00:00 | 00:55:00 | +02:45
 |  | 2022-06-21 00:00:00 | 00:20:00 | +03:05
Negative |  | 2022-06-22 00:00:00 | 00:50:00 | +02:15
Negative |  | 2022-06-23 00:00:00 | 00:57:00 | +01:18
Negative |  | 2022-06-24 00:00:00 | 00:45:00 | +00:33
Negative |  | 2022-06-25 00:00:00 | 00:50:00 | -00:17
Negative |  | 2022-06-26 00:00:00 | 00:45:00 | -01:02
 |  | 2022-06-27 00:00:00 | 00:30:00 | -00:32
 |  | 2022-06-28 00:00:00
 |  | 2022-06-29 00:00:00
 |  | 2022-06-30 00:00:00
 |  | 2022-07-01 00:00:00
 |  | 2022-07-02 00:00:00
Spreadsheet: 139058d1328050489-excel-2007-basic-drop-down-list-help-001
Sheet: Φύλλο1

[NAME] | 1
item2 | 2
item3 | 3
item4 | 4
[NAME] | 5
item6 | 6
[NAME] | 7
item8 | 8
item9 | 9
item10 | 10
Spreadsheet: 870601d1717083605-nightwork-timesheet-hours
Sheet: Sheet1

 |  | Mon | Tur | Wed | Thu | Fri | Sat | Sun
 | Date | 2024-05-27 00:00:00
 | Start | 20:00:00 | 20:00:00 | 20:00:00 | 20:00:00 | 20:00:00 |  |  | Hours
 | End | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 | 07:00:00 |  |  | total
 | Hours/total
 | Break/min | 60 | 60 | 60 | 60 | 60
 | Hours/salery
 | Supplement 1
 | Supplement 2
 | Supplement 1
 | 22:00-06:00
 | Supplement 2
 | 21:00-04:00
Spreadsheet: 698939d1602257928-tracking-duplicates-across-multiple-columns-cca_repair-reva
Sheet: Sheet1

Part Num | Name | Current Serial Num | Repaired? | New Serial Num
CCA1 | Circuit Card | 3B2 | Y | 3N7
HD1 | Hard Drive | 1HP | Y | 2K4
HD1 | Hard Drive | 2K4 | Y | 7WS
CCA2 | Circuit Card | 9KB | Y | 3KL
CCA1 | Circuit Card | 3N7 | Y | 4RB
HD2 | Hard Drive | 8TO | Y | 6PL
CCA2 | Circuit Card | 3KL | Y | 8ZS
HD1 | Hard Drive | 7WS | Y | 9PP
CCA1 | Circuit Card | 4RB | Y | 5B8
Spreadsheet: 728113d1618325961-anniversary-start-date-to-reset-employees-sick-leave-and-vacation-time-employee-attendance-record-test-
Sheet: List of Employees

 | List of Employees
 | Employee Names | Sick Days | Vacation Days | Start Date
 | Employee 1 | 3 | 5 | 2018-11-26 00:00:00
 | Employee 2 | 3 | 0 | 2020-06-22 00:00:00
 | Employee 3 | 3 | 5 | 2019-11-11 00:00:00
 | Employee 4 | 3 | 22 | 2012-09-14 00:00:00
 | Employee 5 | 3 | 5 | 2021-02-01 00:00:00
 | Employee 6 | 3 | 15 | 2006-05-22 00:00:00
 | Employee 7 | 3 | 18.125 | 2018-03-26 00:00:00
 | Employee 8 | 3 | 15 | 1998-03-09 00:00:00
 | Employee 9 | 3 | 10 | 2016-05-16 00:00:00
 | Employee 10 | 3 | 16 | 2005-08-22 00:00:00
 | Employee 11 | 3 | 5 | 2019-08-21 00:00:00
 | Employee 12 | 3 | 17 | 2018-01-05 00:00:00
 | Employee 13 | 3 | 18 | 2017-02-07 00:00:00
 | Employee 14 | 3 | 29 | 1999-07-06 00:00:00
 | Employee 15 | 3 | 15 | 2002-08-19 00:00:00
 | Employee 16 | 3 | 0 | 2020-10-12 00:00:00
 | Employee 17 | 3 |  | 1998-12-21 00:00:00
 | Employee 18 | 3 | 5 | 2018-11-26 00:00:00