tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 730546d1619759723-formula-for-the-revenue-row-that-evenly-spreads-each-months-bookings-excel-question-3-ans
Sheet: Sheet1

Ramp Time (Mths) | 6
 | 2021-01-31 00:00:00
Bookings | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000 | 10000 | 11000 | 12000
Total
[NAME]
Revenue
 |  |  |  |  |  | From B:G | From C:H | From D:I | From E:J | From F:K | From G:L | From H:M
Spreadsheet: 5b7752f2-5ed7-4cb2-893d-da9f0d883d96
Sheet: 14d

 | Swap Dealers/MSPs4 |  |  | Others
Product1 | HY3 | IG | Other |  | IG | Other
Index Tranche | 51 | 42 | 364 | 3 | 8 | 310
Index | 959 | 1314 | 2564 | 1289 | 905 | 1331
OTHER* | - | - | 233 | - | - | 85
TOTAL | 1010 | 1356 | 3161 | 1292 | 913 | 1726
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 170620d1343333464-an-annual-salary-into-a-monthly-salary-given-a-start-date-120000
Sheet: Table

 |  |  | Daily Rate | Annual Salary
 |  |  |  | 120000
Row Labels | Count of PAY DAYS | EARNINGS
July | 6
august | 31
September | 30
October | 31
November | 30
December | 31
Grand Total | 159
Spreadsheet: 124894d1318693945-row-wise-color-coded-cells-count-book1
Sheet: Sheet1

0 | 0 | 8 | 8 | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 24
0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 7.503 | 8.24 | 8.073 | 63.816
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 7.415 | 4.907 | 5.436 | 57.758
0 | 0 | 8 | 8 | 8 | 8 | 8 | 0 | 0 | 8.167 | 8.222 | 8.126 | 64.515
Spreadsheet: louise_kitchen__24114__KO_Netco Grp _ EEs on 12-19
Sheet: Fundys

Fundys
GISID | EMPLOYEE_NAME | [NAME] | JOBGROUP
90142440 | AGARWALLA, DIPAK | Mgr Trading | MGR-C
90144898 | BAYER, ADAM R | Analyst - Rotation 1 | ANL-C
90128294 | BENCHLUCH, MOISES S | Associate - Rotation 3 | ASSOC-C
90140245 | BURK, BART R | Analyst - Rotation 1 | ANL-C
90005799 | BUSS, JEREMY D | Associate - Rotation 3 | ASSOC-C
90041249 | CLINE, KEVIN P | Spec Sr Trading Supt | SPECSR-CS
90007579 | DORNIER, BRENT J | ANALYST | ANL-C
90153294 | FALIK, [NAME] | Analyst - Rotation 1 | ANL-C
90010385 | GASKILL, [NAME] | Dir Trading | DIR-C
90154015 | GIRON, GUSTAVO | Trading Associate- Rotation 1 | ASSOC-C
90125284 | IMAI, RIKA | Mgr Trading Supt | MGR-CS
90012034 | JOHNSTON, ROBERT | Dir Competitive Analysis | DIR-CS
90125038 | LIESKOVSKY, JOZEF S | Trading Associate- Rotation 1 | ASSOC-C
90144311 | MARQUEZ, MAURICIO | Associate - Rotation 1 | ASSOC-C
90007668 | O'MALLEY, JUSTIN A | Analyst - Rotation 2 | ANL-C
90127731 | PIMENOV, VLADI | Trading Associate- Rotation 2 | ASSOC-C
90128217 | PLACHY, DENVER D | Trading Analyst- Rotation 1 | ANL-C
90010331 | RUST, WILLIAM C | Mgr Trading | MGR-C
90123707 | THOLAN, SCOTT | Dir Competitive Analysis | DIR-CS
90007647 | [NAME], PATRICK | Mgr Orig Wholesale | MGR-C
90012032 | WALSH, KRISTIN N | Mgr Competitive Analysis | MGR-CS
90144518 | [NAME], RYAN N | Analyst - Rotation 1 | ANL-C
90007304 | YAWAPONGSIRI, VIRAWAN A | Trading Associate- Rotation 4 | ASSOC-C
 |  | Employees
Spreadsheet: dan_hyvl__4890__Peoples Energy Resources and EMW
Sheet: AMASTPSA 

MASTER FIRM PURCHASE/SALE AGREEMENT INFORMATION SHEET
ENA Entity: | EMW | ATTORNEY: | [NAME]
DATE: | 2000-09-28 00:00:00 | ENA CONTACT: | [NAME]
COUNTERPARTY: | Peoples Energy Resources Corp. | CONTACT:
ADDRESS: |  | TITLE:
 |  | PHONE:
 |  | FAX:
INCORPORATION STATE: |  | S&P RATING: | N/A
STRUCTURE | COUNTERPARTY | EMW | Enron MW, L.L.C.
COLLATERAL
THRESHOLD  in $ | $10MM | $10MM
COMMITTED VOLUMES
THRESHOLD in $[NAME] | N/A | N/A
COLLATERAL REQUIRED FOR:
ALL TRADES
OTHER | N/A | N/A
COLLATERAL TYPE
Letter of Credit | OK | OK
COLLATERAL  MULTIPLE | 250000 | 250000
GUARANTOR (RATING) | Peoples Energy Corp. (A+) | Enron Corp. (BBB+)
LIMIT in $[NAME] | $10MM | $10MM
Incorporation State: |  | Oregon
MATERIAL ADVERSE CHANGE TRIGGERS  APPLY TO:
-Counterparty
-Guarantor | X | X
Debt Ratings Change
-Below = | BBB- | BBB- | S&P
Financial Covenants
-Funded Debt/Net Worth
-Minimum Net worth
-Cash Flow/CMLTD
-Current Ratio
Non-Specific
-Unilateral
Ownership Change
Non-Standard Definitions
-Funded Debt
-Net Worth
-Cash Flow
EVENTS OF DEFAULT
3rd party debt
-Counterparty
-Guarantor ($[NAME]) | $50MM | $100MM
FIN'L STATEMENTS
-Standard | X | X | Upon request
CREDIT DECISION: | APPROVED:  X | DECLINED:
OUTSTANDING PHYSICAL TRADES: |  | YES: | NO: X
ALL TRADES TO ROLL UP UNDER NEW MASTER: |  | YES: | NO: X
OTHER COMMENTS
Worksheet prepared per [NAME] request.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x6-6002
Spreadsheet: 157077d1337612086-offset-doesnt-work-test
Sheet: 1

2012-04-01 00:00:00
2012-04-02 00:00:00 |  |  | 6
2012-04-03 00:00:00 |  | 6
2012-04-04 00:00:00 |  | 36
2012-04-08 00:00:00 |  |  | 1
2012-04-06 00:00:00 | 5 |  | 1
2012-05-01 00:00:00 | 6 |  | 1
2012-04-08 00:00:00 | 7 |  | 11
2012-04-09 00:00:00 |  |  | 12
2012-04-10 00:00:00 | 8 |  | 1
2012-05-02 00:00:00 | 7 |  | 1
2012-04-12 00:00:00 |  | 10
2012-04-13 00:00:00 |  | 8
2012-04-14 00:00:00 |  |  | 1
2012-04-15 00:00:00 | 2 |  | 12
2012-04-16 00:00:00 | 5 |  | 1
2012-04-17 00:00:00 |  |  | 2
2012-04-18 00:00:00 |  |  | 10
2012-04-19 00:00:00 |  |  | 1
Spreadsheet: mark_taylor__24966__methanol plant allowances DERCs ERCs
Sheet: ERCCalcs

 | 1997 | 1998 | 1999 | 2000 | 97-8 | 98-9 | 99-00 | Best
Description | VOC (tpy) | VOC (tpy) | VOC (tpy) | VOC (tpy) | VOC (tpy) | VOC (tpy) | VOC (tpy) | VOC (tpy)
Ammonia Treatment
Low-Pressure Methanol Off-Gas
Water Column Reflux
Light Ends Column Vent
[NAME], South
[NAME]
Flare, E (1)
[NAME]
K101 Leak Gas
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Air Comp. Engine, 265 hp
[NAME], North
TOTAL
 | 1997 | 1998 | 1999 | 2000 | 97-8 | 98-9 | 99-00 | Best
Description | CO (tpy) | CO (tpy) | CO (tpy) | CO (tpy) | CO (tpy) | CO (tpy) | CO (tpy) | CO (tpy)
Ammonia Treatment
Low-Pressure Methanol Off-Gas
Water Column Reflux
Light Ends Column Vent
[NAME], South
[NAME]
Flare, E (1)
[NAME]
K101 Leak Gas
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Air Comp. Engine, 265 hp
[NAME], North
TOTAL
 | 1997 | 1998 | 1999 | 2000 | 97-8 | 98-9 | 99-00 | Best
Description | PM (tpy) | PM (tpy) | PM (tpy) | PM (tpy) | PM (tpy) | PM (tpy) | PM (tpy) | PM (tpy)
Ammonia Treatment
Low-Pressure Methanol Off-Gas
Water Column Reflux
Light Ends Column Vent
[NAME], South
[NAME]
Flare, E (1)
[NAME]
K101 Leak Gas
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Air Comp. Engine, 265 hp
[NAME], North
TOTAL
 | 1997 | 1998 | 1999 | 2000 | 97-8 | 98-9 | 99-00 | Best
Description | NOx (tpy) | NOx (tpy) | NOx (tpy) | NOx (tpy) | NOx (tpy) | NOx (tpy) | NOx (tpy) | NOx (tpy)
Ammonia Treatment
Low-Pressure Methanol Off-Gas
Water Column Reflux
Light Ends Column Vent
[NAME], South
[NAME]
Flare, E (1)
[NAME]
K101 Leak Gas
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Comp. Engine, 5500 hp
Air Comp. Engine, 265 hp
[NAME], North
TOTAL
Spreadsheet: 877079d1723750793-how-do-i-reference-the-results-of-formulas-multiple-cells-cell-1-or-cell-2-or-cell-3-amateurexceller-submission-for-question
Sheet: Solution

Project EVM Calculations
Total Approved Project Budget = BAC | Value of Deliverables Planned by this Point = PV | Value of [NAME] by this Point | Actual Costs Incurred to Date = AC | Estimate to Completion (Time) = ETC
Budget at Completion (BAC) | Planned Value (PV) | Earned Value (EV) | Actual Cost (AC) | Estimate to Completion = ETC
1000000 | 1100000 | 500000 | 600000 | 500000
EVM Calculations | [NAME] | Result |  | Interpretation
Cost Variance (CV) | CV = EV-AC |  |  | Positive:  Under Budget Negative:  Over Budget
Cost Performance  Index (CPI) | CPI = EV/AC |  |  | CPI > 1 More Productive than Expected CPI < 1 Less Productive than Expected
Variance at Completion (VAC) | VAC = BAC-EAC |  |  | Difference Between BAC and Final Projected Costs
Estimate at Completion (EAC) | EAC = BAC/CPI |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + ETC (ETC is Estimated) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV)/(CPI*SPI) |  |  | Project Cost if Current Trend Unchanged
Remaining Work | Remaining Work = BAC - EV
Remaining Budget | Remaining Budget = BAC-AC
To-Complete Performance Index | TCPI = (BAC – EV) / (BAC – AC) |  |  | TCPI > 1 Over Budget   TCPI < 1 Under Budget
[NAME] (SV) | SV = EV-PV |  |  | Positive:  Ahead of Schedule Negative:  Behind Schedule
Schedule Performance Index (SPI) | SPI = EV/PV |  |  | SPI > 1 Ahead of Schedule SPI < 1 Behind Schedule
Spreadsheet: 290375d1389863965-fill-the-corresponding-cell-with-last-value-entered-st1
Sheet: Before Sheet

Sr.No | Item Description | Rates
1 | Window Ac | 1
2 | Window Ac | 5
3 | Window Ac | 3
4 | Splite AC | 4
5 | Splite AC | 2
6 | Splite AC | 5
10 | Bar | 4
11 | Bar | 3
12 | Bar | 5
13 | Bar | 2
14 | Bar
15 | Window Ac
16 | Splite AC
17 | Bar
Spreadsheet: 723385d1615657770-formula-to-find-and-replace-special-characters-according-to-a-table-test-formula-spec-characters
Sheet: SpecChar

 |  | [NAME] | [NAME] |  |  |  | Original text | Desired Result based on a formula
 | SUBSTITUTE(H2,C$2,D$2) | à | a | 1 |  |  | République | Republique
 |  | á | a |  |  |  | AAbbCCddEE | AAbbCCddEE
 |  | â | a |  |  |  | õÙŸ á | oUY a
 |  | ã | a |  |  |  | L'Alleud | L Alleud
 |  | ä | a |  |  |  | d'Albon | d Albon
 |  | å | a
 |  | ç | c
 |  | è | e
 |  | é | e
 |  | ê | e
 |  | ë | e
 |  | ì | i
 |  | í | i
 |  | î | i
 |  | ï | i
 |  | ð | o
 |  | ñ | n
 |  | ò | o
 |  | ó | o
 |  | ô | o
 |  | õ | o
 |  | ö | o
 |  | ù | u
 |  | ú | u
 |  | û | u
 |  | ü | u
 |  | ý | y
 |  | ÿ | y
 |  | Š | S
 |  | Ž | Z
 |  | š | S
 |  | ž | Z
 |  | Ÿ | Y
 |  | À | A
 |  | Á | A
 |  | Â | A
 |  | Ã | A
 |  | Ä | A
 |  | Å | A
 |  | Ç | C
 |  | È | E
 |  | É | E
 |  | Ê | E
 |  | Ë | E
 |  | Ì | I
 |  | Í | I
 |  | Î | I
 |  | Ï | I
 |  | Ð | D
 |  | Ñ | N
 |  | Ò | O
 |  | Ó | O
 |  | Ô | O
 |  | Õ | O
 |  | Ö | O
 |  | Ù | U
 |  | Ú | U
 |  | Û | U
 |  | Ü | U
 |  | Ý | Y
 |  | '
 |  | ‘
 |  | ’
Spreadsheet: 703290d1604934521-how-to-count-cells-until-streak-ends-how-to-count-cells-under-certain-value-count-top-10s
Sheet: RESULTS

 | Playing This Week? | WORLD RANK | Consecutive cuts made: | Top 10 finishes: | Houston 2020 | Bermuda 2020 | ZOZO @ Sherwood | CJ CUP @ Shadow Creek | Shriners 2020 | Sanderson 2020 | [NAME] | US Open 2020 | Safeway Open 2020 | Tour Championship | BMW Championship | Northern Trust | Wyndham | PGA Championship | Barracuda | WGC - St Jude | 3M Open | Memorial | Workday Charity | Rocket Mortgage | Travelers Championship | [NAME] | [NAME]
 |  |  |  |  | Nov 5-8 | Oct 29-Nov 1 | Oct 22-25 | Oct 15-18 | Oct 8-11 | Oct 1-4 | Sep 24-27 | Sep 17-20 | Sep 10-13 | Sep 4-7 | Aug 27-30 | Aug 20-23 | Aug 13 - 16 | Aug 6-9 | July 30 - Aug 2 | July 30 - Aug 2 | July 23 - 26 | July 16 - 19 | July 9-12 | July 2-5 | June 25-28 | June 18-21 | [NAME]
PLAYER
[NAME]
Jon Rahm
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Consecutive cuts made: |  | Need to count all events played (showing a number NOT blanks or WD) until the cell says 'CUT'
Top 10 finishes: |  | Count all results where cell value is between 1 and 10. Do not count blanks, text or values above 10
Count from Column F across to AB.
Spreadsheet: 164806d1340897226-vlookup-with-partial-match-problem
Sheet: Sheet1

 | <1100>1 | <1100R>1 | <1018>1 | <1018R>1 | <1019>1 | <1019R>1 | <2005>1 | <2005R>1 | <1100>2 | <1100R>2 | <2005>2 | <2005R>2 |  |  |  | Total
 | <1100> | <1100R> | <1018> | <1018R> | <1019> | <1019R> | <2005> | <2005R> | <1100> | <1100R> | <2005> | <2005R> |  |  | <1018> | 68
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 |  |  | <1019> | 28
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 |  |  | <1100> | 72
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 |  |  | <1100> | 60
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 7 |  |  | <2005> | 32
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 |  |  | <2005> | 40
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 8
 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 2
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6
 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6 | 9 | 1 | 2
 | 5 | 4 | 5 | 9 | 2 | 3 | 4 | 2 | 7 | 2 | 3 | 6
 | :12:20
Spreadsheet: 190435d1351645663-combining-multiple-columns-of-data-into-single-column-multcolumnsexample
Sheet: Sheet1

Away |  | Home |  |  | This is what I want
2011-12-27 00:00:00 | NJ | 2011-12-28 00:00:00 | Was |  | 2011-12-27 00:00:00 | NJ
2011-12-31 00:00:00 | Hou | 2011-12-30 00:00:00 | NJ |  | 2011-12-28 00:00:00 | Was
2012-01-02 00:00:00 | [NAME] | 2012-01-05 00:00:00 | [NAME] |  | 2011-12-30 00:00:00 | NJ
2012-01-03 00:00:00 | Chi | 2012-01-07 00:00:00 | Chi |  | 2011-12-31 00:00:00 | Hou
2012-01-06 00:00:00 | Cha | 2012-01-12 00:00:00 | Cha |  | 2012-01-02 00:00:00 | [NAME]
2012-01-09 00:00:00 | NJ | 2012-01-14 00:00:00 | Min |  | 2012-01-03 00:00:00 | Chi
2012-01-11 00:00:00 | Ind | 2012-01-16 00:00:00 | Tor |  | 2012-01-05 00:00:00 | [NAME]
2012-01-20 00:00:00 | Phi | 2012-01-18 00:00:00 | Por |  | 2012-01-06 00:00:00 | Cha
2012-01-23 00:00:00 | Mil | 2012-01-21 00:00:00 | Cle |  | 2012-01-07 00:00:00 | Chi
2012-01-25 00:00:00 | SA | 2012-02-02 00:00:00 | [NAME] |  | 2012-01-09 00:00:00 | NJ
2012-01-27 00:00:00 | [NAME] | 2012-02-04 00:00:00 | Phi |  | 2012-01-11 00:00:00 | Ind
2012-01-29 00:00:00 | NO | 2012-02-06 00:00:00 | [NAME] |  | 2012-01-12 00:00:00 | Cha
2012-01-31 00:00:00 | Tor | 2012-02-08 00:00:00 | Ind |  | 2012-01-14 00:00:00 | Min
2012-02-10 00:00:00 | Orl | 2012-02-12 00:00:00 | [NAME] |  | 2012-01-16 00:00:00 | Tor
2012-02-14 00:00:00 | LAL | 2012-02-23 00:00:00 | Orl |  | 2012-01-18 00:00:00 | Por
2012-02-15 00:00:00 | [NAME] | 2012-02-29 00:00:00 | GS |  | 2012-01-20 00:00:00 | Phi
2012-02-18 00:00:00 | Por | 2012-03-02 00:00:00 | Mil |  | 2012-01-21 00:00:00 | Cle
2012-02-20 00:00:00 | Chi | 2012-03-03 00:00:00 | OKC |  | 2012-01-23 00:00:00 | Mil
2012-02-22 00:00:00 | NY |  |  |  | 2012-01-25 00:00:00 | SA
 |  |  |  |  | 2012-01-27 00:00:00 | [NAME]
 |  |  |  |  | 2012-01-29 00:00:00 | NO
 |  |  |  |  | 2012-01-31 00:00:00 | Tor
 |  |  |  |  | 2012-02-02 00:00:00 | [NAME]
 |  |  |  |  | 2012-02-04 00:00:00 | Phi
 |  |  |  |  | 2012-02-06 00:00:00 | [NAME]
 |  |  |  |  | 2012-02-08 00:00:00 | Ind
 |  |  |  |  | 2012-02-10 00:00:00 | Orl
 |  |  |  |  | 2012-02-12 00:00:00 | [NAME]
 |  |  |  |  | 2012-02-14 00:00:00 | LAL
 |  |  |  |  | 2012-02-15 00:00:00 | [NAME]
 |  |  |  |  | 2012-02-18 00:00:00 | Por
 |  |  |  |  | 2012-02-20 00:00:00 | Chi
 |  |  |  |  | 2012-02-22 00:00:00 | NY
 |  |  |  |  | 2012-02-23 00:00:00 | Orl
 |  |  |  |  | 2012-02-29 00:00:00 | GS
 |  |  |  |  | 2012-03-02 00:00:00 | Mil
 |  |  |  |  | 2012-03-03 00:00:00 | OKC
Spreadsheet: 803819d1667725548-how-to-do-fast-replacing-of-row-number-accross-different-columns-copy-of-baza-nova-verzija-racuni-1-
Sheet: R53

Ime artikla
Spreadsheet: 40e8eee6-d2d2-44a5-a47a-8203c02b9cad
Sheet: Team

BUCS WINDSURFING CHAMPIONSHIPS 2010 - TEAM RESULTS
 |  | Race 1 | Race 2 | Points
1 | Cardiff 1 | 1 | 1 | 2
2 | Cambridge 1 | 3 | 2 | 5
3 | Bristol 2 | 6 | 6 | 12
4 | Southampton 1 | DNS (10) | 3 | 13
5 | St. Mary's 1 | 2 | DNS (11) | 13
6 | Exeter 1 | DNS (10) | 4 | 14
7 | Southampton 3 | 7 | 7 | 14
8 | Birmingham | DNS (10) | 5 | 15
9 | [NAME] | 4 | DNS (11) | 15
10 | Southampton 2 | 5 | DNS (11) | 16
11 | Southampton 4 | 8 | 10 | 18
12 | Bristol 1 | DNS (10) | 9 | 19
Spreadsheet: 867196d1714057468-change-a-color-of-a-data-bar-conditional-formatting-rule-based-on-a-variable-another-cell-tracking-progress
Sheet: Tracking Progress

Volume | Done | Left | Spent | More | Required (t/d) | Theme | Finish
467 |  |  |  |  |  | Light | 2024-06-30 00:00:00
Started | Finished | Days | Left | Pace (p/h) | Pace (t/d) | Sessions | Expected
 |  |  |  |  | 00:40:45.882000
Stage | Start | Finish | Done | Progress | Duration | Notes
1 | 2024-03-27 12:43:00 | 2024-03-27 14:04:00 | 1
2 | 2024-03-27 15:19:00 | 2024-03-27 16:12:00 | 2
3 | 2024-03-27 16:14:00 | 2024-03-27 16:28:00 | 3
4 | 2024-03-27 16:30:00 | 2024-03-27 16:42:00 | 4
5 | 2024-03-27 16:56:00 | 2024-03-27 17:06:00 | 5
6 | 2024-03-27 17:09:00 | 2024-03-27 17:32:00 | 6
7 | 2024-03-27 17:34:00 | 2024-03-27 19:18:00 | 7
8 | 2024-03-28 15:30:00 | 2024-03-28 15:36:00 | 8
9 | 2024-03-28 15:37:00 | 2024-03-28 16:14:00
10 | 2024-03-28 16:39:00 | 2024-03-28 17:24:00 | 9
11 | 2024-03-28 17:27:00 | 2024-03-28 17:37:00 | 10
12 | 2024-03-28 17:39:00 | 2024-03-28 17:48:00 | 11
13 | 2024-03-28 20:01:00 | 2024-03-28 20:19:00 | 12
14 | 2024-03-29 19:39:00 | 2024-03-29 20:02:00 | 13
15 | 2024-03-29 20:14:00 | 2024-03-29 20:20:00 | 14
16 | 2024-03-29 20:22:00 | 2024-03-29 20:42:00 | 15
17 | 2024-04-01 22:44:00 | 2024-04-01 22:47:00
18 | 2024-04-01 23:06:00 | 2024-04-01 23:16:00 | 16
19 | 2024-04-02 16:52:00 | 2024-04-02 17:23:00 | 17
20 | 2024-04-02 17:23:00 | 2024-04-02 17:46:00 | 18
21 | 2024-04-02 17:49:00 | 2024-04-02 17:57:00 | 19
22 | 2024-04-02 17:58:00 | 2024-04-02 18:08:00 | 20
23 | 2024-04-02 18:40:00 | 2024-04-02 18:54:00 | 21
24 | 2024-04-02 19:03:00 | 2024-04-02 19:13:00 | 22
25 | 2024-04-02 19:14:00 | 2024-04-02 19:24:00 | 23
26 | 2024-04-03 21:26:00 | 2024-04-03 22:37:00 | 24
27 | 2024-04-12 14:10:00 | 2024-04-12 14:42:00 | 250
Spreadsheet: 840155d1692498459-creating-data-with-randbetween-example
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | izhar
 |  |  |  |  |  |  |  |  |  | inam
 |  |  |  |  |  |  |  |  |  | amin
 |  |  |  |  |  |  |  |  |  | noor
 |  |  |  |  |  |  |  |  |  | shams
 |  |  |  |  |  |  |  |  |  | ahsan
 |  |  |  |  |  |  |  |  |  | rafay
 |  |  |  |  |  |  |  |  |  | umair
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | asim
Spreadsheet: f0682a4b-47f6-48e3-a9b0-4471a51b5ded
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6318 | 7869 | Katja | [NAME] | FIN | 0 | 00:18:49 | 00:00:00 | 00:37:47 | 00:00:00 | 00:29:55 | 1 | 01:26:31
Spreadsheet: 70d3a016-b5e6-4046-b3d6-3e8901f45bb5
Sheet: Sheet1

Libri i Blerjeve | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
Shoqeria |  | Emri i Shoqerise
Nipti |  | Nipti i Shoqerise
Viti |  | Viti per te cilin [NAME]  (yyyy)
[NAME] |  | [NAME] per te cilin plotesohet libri - muaji nga 01 deri 12
Pa veprimtari |  | Ploteso PO nese gjate muajit [NAME] transaksion.
Fatura |  |  | Shitesi |  |  | [NAME] (perfshire TVSH) | Blerje
Nr Fatures | Numri Serial | Data (dd/mm/yyyy) | Emri tregtar / personi | Rrethi | NIPT       /Kodi Fermerit |  | Te perjashtuara,me Tvsh jo te zbritshme dhe pa TVSH | Importe me shkalle 20% |  | Importe me shkalle 10% |  | Nga Furnitore Vendas me shkalle 20% |  | Nga Furnitore Vendas me shkalle 10% |  | [NAME] vendas
 |  |  |  |  |  |  |  | Vlera e Tatueshme | Tvsh | Vlera e Tatueshme | Tvsh | Vlera e Tatueshme | Tvsh | Vlera e Tatueshme | Tvsh | Vlera e Tatueshme | Tvsh
a | b | c | d | e | f | g=(h+i+j+k+l+m+n+o+p+q+r) | h | i | j | k | l | m | n | o | p | q | r
Shuma totale
Kutia sipas Formularit te [NAME] dhe Pageses se TVSH-se |  |  |  |  |  |  | kutia (15) | kutia (16) | kutia (17) | kutia (18) | kutia (19) | kutia (20) | kutia (21) | kutia (22) | kutia (23) | kutia (24) | kutia (25)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emri Mbiemri
Shpjegim:
Ne rastin kur ky liber do te printohet, per qellime te ruajtjes/ mbajtjes se dokumentacionit, cdo faqe e printuar duhet te kete ne krye permbajtjen / rreshtat nga 1 ne 12.
Nr i rreshtave mund te shtohet ne perputhje me nr e transaksioneve
Spreadsheet: 713732d1610900493-how-to-get-multiple-row-data-from-another-sheet-by-matching-entries-crop_damage_forum
Sheet: ENTRY

ENTRY NUMBER | OUTPUT_survey
721468155261
968047478678
558862288012
597882830394
399900960516
394588931704
214880810005
840352530148
827853029063
363276262465
472116109840
888443886880
483278995489
458020255975
385291345637
507145249800
994588620209
897818448887
350910187470
635340796248
342276210202
709310903391
274726168458
989685953421
507468221728
698122155915
404673635421
576977801502
416252875853
201328094894
881700929090
940465231889
780600840974
420476284557
740252787736
573639020337
573275752520
607424311888
763383563525
987906951019
655773911445
732333003115
963258385708
494728102774
505632342203
245755630955
603386751964
810829261815
703539890657
561598098569
619313011545
693578007959
430570964109
679224591379
325610712737
630928545676
937167810080
371226046753
740222514316
611912683888
885243644294
554777273528
552529500854
959632508807
358499405281
256242713615
955858359065
826706848246
625546448059
315815792660
893378791115
823757444311
447249375852
707814348159
590016634753
594044027725
893336946397
822769047145
203048866149
716800274959
545440484267
477644154278
402418208184
556515541498
766456060526
318109223507
633884781867
501173918273
587779773640
352912009909
955463425027
652885776075
573027861381
610655245644
735700984298
370464426681
237636028359
762818705508
643573434719
964631323046
990727020614
679478590938
968167010499
868241651090
654384006450
734739314878
776890526946
867959747088
468727892883
912543297977
402930281417
622686104331
623914051773
451036809220
920201997069
908428507962
850821400940
252889501962
386797707260
375779898935
861541642277
495205971521
605315820358
279071201872
899807296688
824415066093
644546513242
829412958589
701862963251
317390933614
688282937240
891008501313
425358764814
383500920069
707848393916
878736280278
451828146705
688170502234
481347258638
866521427291
544817108103
424871238953
758601256055
535286845884
611729210757
516519797999
633625335557
772245648352
409207086978
564033834134
837607689065
782226321970
607915727072
908921340810
315609231337
519701877407
604498111914
381807369641
556595317945
289141454821
675361867392
960670905959
541398733094
986135748691
586285919483
362968736694
768964097182
436443767411
721297532815
904704913240
692959113936
723061128124
349042051324
987294550265
416346574784
643433756681
476790809364
259853454017
317550675147
713722500483
963483740465
257211302149
627068500504
418064932515
330934732470
Spreadsheet: 690731d1597254775-counting-how-many-records-on-a-specific-date-date-counts
Sheet: Data

 |  |  |  |  |  | Wednesday | Thursday | Friday | Saturday | Monday
 |  |  |  |  |  | 2020-07-29 00:00:00 | 2020-07-30 00:00:00 | 2020-07-31 00:00:00 | 2020-08-01 00:00:00 | 2020-08-03 00:00:00
Date | Tracking Number |  |  |  | Count of Requests
2020-07-29 00:00:00 | 111111111111 |  |  |  | [NAME]
2020-07-29 00:00:00 | 111111111112
2020-07-29 00:00:00 | 111111111113 |  |  |  | WHAT DATA SHOULD BE | 5 | 5 | 5 | 1 | 1
2020-07-29 00:00:00
2020-07-29 00:00:00 | 111111111115
2020-07-29 00:00:00 | 111111111116
2020-07-30 00:00:00 | 111111111117
2020-07-30 00:00:00
2020-07-30 00:00:00 | 111111111119
2020-07-30 00:00:00 | 111111111120
2020-07-30 00:00:00 | 111111111121
2020-07-30 00:00:00 | 111111111122
2020-07-31 00:00:00 | 111111111123
2020-07-31 00:00:00 | 111111111124
2020-07-31 00:00:00 | 111111111125
2020-07-31 00:00:00
2020-07-31 00:00:00 | 111111111127
2020-07-31 00:00:00 | 111111111128
2020-08-01 00:00:00
2020-08-01 00:00:00 | 111111111130
2020-08-03 00:00:00
2020-08-03 00:00:00
2020-08-03 00:00:00
2020-08-03 00:00:00 | 111111111134