tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 696291d1600742875-pivottable-formula-that-uses-values-from-pivot-table-book1-hjallis-
Sheet: Table

 | Modell | % | X | Count X |  | Modell | Sum of % | Count of X | %/X
 | A | 0.128 | 546 |  |  | A | 0.168 | 7 | 0.024
 | B | -0.023 | 231 |  |  | B | 0.1217 | 7 | 0.01738571428571429
 | B | 0.018 | 21 |  |  | C | 0.4233 | 11 | 0.03848181818181818
 | C | 0.05 | 21321 |  |  | D | 0.0577 | 4 | 0.014425
 | C | 0.01 | 21321 |  |  | Grand Total | 0.7707 | 29 | 0.02657586206896552
 | A | -0.05 | 2132
 | A | -0.25
 | A | -0.03 | 546
 | A | 0.02 | 51651
 | D | -0.05 | 10
 | D | -0.0423 | 4141
 | C | -0.01 | 41
 | A | -0.01 | 10
 | B | -0.01
 | B | 0.05 | 1
 | C | 0.02
 | C | 0.03 | 10
 | A | 0.02 | 35
 | A | 0.05
 | C | 0.04 | 10
 | A | 0.12
 | D | -0.05
 | D | 0.09 | 10
 | C | 0.0333
 | A | 0.12
 | B | 0.08 | 10
 | B | -0.0333 | 3554
 | C | 0.04
 | C | -0.05 | 10
 | C | -0.02 | 1514
 | A | 0.05 | 10
 | B | 0.02 | 5416
 | B | 0.02 | 10
 | C | 0.06 | 546
 | C | 0.04 | 10
 | C | 0.08 | 10
 | C | 0.1 | 4684
 | D | 0.11 | 10
Spreadsheet: 232309d1367384920-society-scoring-system-template-society-scoring-system-template
Sheet: order merit

 |  |  | Names / Handicaps | Mentmore
 |  |  |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Leaders in Gold
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team ball
Best of Eight scores to count         0 = No points credited
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team ball
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team ball
Spreadsheet: 754330d1636116351-sumifs-on-one-tab-taking-data-from-4-tabs-eh_service-support-management-db_v2
Sheet: Calculations

Month | Projects | Month | SRM Lead | Year
January | =(SUMIFS('Team Samuel'!B5:B39,"Client Project"&'Team Samuel'!2:2, "Jan"))+(SUMIFS('Team Rob'!B5:B39,"Client Project"&'Team Samuel'!2:2,"Jan"))' | January |  | 2000
February |  | February |  | 2001
March |  | March |  | 2002
April |  | April |  | 2003
May |  | May |  | 2004
June |  | June |  | 2005
July |  | July |  | 2006
August |  | August |  | 2007
September |  | September |  | 2008
October |  | October
November |  | November
December |  | December
Month | Tickets
January
February
March
April
May
June
July
August
September
October
November
December
Employee Information
Name |  | 0 | 2000
Hire Date |  | 1 | 2001
Location |  | 2 | 2002
Termination Date |  | 4 | 2003
Employment Type |  | 5 | 2004
Year |  | 6 | 2005
Base Salary |  | 7 | 2006
Bonus |  | 8 | 2007
Overtime |  | 9 | 2008
Commission |  | 10
Total Compensation |  | 11
Department |  | 12
PTO Days |  | 13
Sick Days |  | 14
Performance Score |  | 15
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 12d

 | Swap Dealers/MSPs5 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Cross-Currency Basis | - | 83133 | - | 59459
Cross-Currency Fixed-Fixed | - | 2803 | - | 13422
Cross-Currency Fixed-Float | - | 5965 | - | 3408
TOTAL | - | 91901 | - | 76289
Spreadsheet: 269338d1381134330-reference-data-in-a-row-based-on-data-in-a-cell-training-record-matrix
Sheet: General Training

 |  |  |  |  | LICENCES |  |  |  |  |  |  |  |  |  |  |  |  |  | OPTIONAL TRAINING
Last Name | First Name | Branch | SAP # | Job Title | Drivers Licence # | DL State | DL Class | Drivers [NAME] | RHL # | [NAME] | Electrical / Refrigeration Licence # | EW / Refrig Expiry | ESC Auth. | Safe Working at Heights MNMG237A | WWH Gap (RioTinto) | Basic First Aid HLTCPR201B | Use portable fire equipment SW2300TP7 or  PRMPFES05B | Construction Safety Awareness (LICENCE #) | Confinded Space Access BCCCM2009B &  MSAPMPER205B | ACMA Open Cabler ICTTC136C & ICTTC137C | [NAME] | Coca Cola Amatil | UGL | HIGH RISK WORK Licence # | HIGH RISK WORK [NAME] | HIGH RISK - WP | HIGH RISK - C2 | HIGH RISK - C6 | HIGH RISK - CV | HIGH RISK - LF | HIGH RISK  - LO | HIGH RISK - DG | HIGH RISK - RB | 4WD | WPCG SW2300TP16 | Apply First Aid HLTFA301B
Required Timeframe |  |  |  |  |  |  |  |  |  |  |  |  |  | Employment & 2 Yrly | 2 Yrly | 12 Monthly | < 3 months employment & 2 yrly | Employment | 2 Yrly |  | 2 Yrly |  |  |  | 5 years |  |  |  |  |  |  |  |  |  | 2 Yrly | 2 Yrly
Builder | [NAME] | Earth | 1111111 | Electrician | 12345678 | WA | C | 2014-10-26 00:00:00 |  |  | EW987987 | 2017-02-23 00:00:00 | 2018-09-16 00:00:00 | 2014-09-26 00:00:00 |  | 2014-05-02 00:00:00 | 2015-06-25 00:00:00 | 81600 | 2014-09-24 00:00:00 |  |  |  |  | WL98787 | 2013-10-16 00:00:00 | Y
Dumpty | Humpty | Earth | 2222222 | Refrigeration Mechanic | 123568741 | QLD | C | 2014-02-09 00:00:00 | L156489 | 2014-06-16 00:00:00 | EW654654 | 2016-11-21 00:00:00 |  | 2013-11-03 00:00:00 | 2013-11-03 00:00:00 | 2013-09-21 00:00:00 | 2015-04-11 00:00:00 | 468174 |  |  | 2013-11-01 00:00:00 | 2014-07-01 00:00:00 | 2013-06-11 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2013-03-03 00:00:00 | 2013-11-09 00:00:00
Jones | Geoff | Earth | 333333 | Refrigeration / Electrician | 6598745 | WA | C | 2017-01-08 00:00:00 | L16564 | 2015-07-21 00:00:00 | EW321321 | 2018-07-26 00:00:00 | 2018-10-01 00:00:00 | 2015-09-23 00:00:00 | 2015-09-23 00:00:00 | 2014-01-01 00:00:00 |  | 690236 |  | 2016-04-19 00:00:00 |  |  | 2013-10-02 00:00:00 | WL654654 | 2016-01-14 00:00:00 |  |  |  |  | Y |  |  |  |  |  | 2016-01-01 00:00:00
Spreadsheet: 141609d1329364391-countif-or-other-option-math-table
Sheet: Sheet1

 | 5 | 8 | 9 | 7 | 9 |  |  | answers here for comparison
3 | 15 |  |  |  |  |  |  |  |  |  |  |  | this table is to check the multiplication table
4
5
6
7 |  |  |  | 2
8
9
 | enter on the yellow shaded part |  |  |  |  |  |  |  |  |  |  |  | just  another formula to return true or false ( compareing the two tables....
 |  |  |  |  |  |  |  |  |  |  |  |  |  | this is the countif true
 |  |  |  |  |  |  |  |  |  |  |  |  |  | this is to count if false
 |  |  |  |  |  |  |  | side columns can be hidden..( helper column )
Spreadsheet: 864386d1711571066-index-match-reversed-need-to-find-the-value-in-column-a-classeur2
Sheet: Feuil1

Scale | Pointing1 | Pointing2 | Pointing3 | Pointing4
0 | Horrible | 1,10 and more GJ/m2 | 0-20% | Extreme
1 | Bad | 0,95 to 1,09999 GJ/m2 | 20-40% | Very high
2 | Passable | 0,8 to 0,94999 GJ/m2 | 40-60% | High
3 | Average | 0,65 to 0,79999 GJ/m2 | 60-80% | Moderate
4 | Good | 0,5 to 0,64999 GJ/m2 | 80-100% | Low
5 | Excellent |  |  | Very low
 |  |  | Expected result
Criterion 1 : | Pointing3 | 60-80% | 3
Criterion 2 | Pointing1 | Excellent | 5 |  | [NAME] to give me the scale according to the Pointing column and the date in said column.
Spreadsheet: 680484d1591041800-all-time-high-of-live-data-stock
Sheet: Sheet1

Company | Type | Ticker | # | Cost | Current | Dividends
Chevron | Energy | CVX | 1 | 75.03 | 93.125 | 0
Inovio | BioTech | INO | 2 | 6.01 | 14.93 | 0
 |  |  |  | 6.01
Gilead Sciences | BioTech | GILD | 2 | 78.1 | 75.305 | 0
 |  |  |  | 78.28
Plug Power | Energy | PLUG | 3 | 2.82 | 4.3 | N/A
 |  |  |  | 2.82
 |  |  |  | 2.82
Oneoke | Energy | OKE | 4 | 26.4 | 38.035 | 0.935
 |  |  |  | 26.4
 |  |  |  | 26.4
 |  |  |  | 26.4
[NAME] | BioTech | MRNA | 7 | 28.18 | 60.835 | 0
 |  |  |  | 28.18
 |  |  |  | 26.47
 |  |  |  | 26.47
 |  |  |  | 26.47
 |  |  |  | 78.16
 |  |  |  | 78.16
Orbcomm | Tech | ORBC | 13 | 2.8 | 2.935
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  |  |  | 2.8
 |  | Total Shares
All-time High |  |  | Total
All-time Low |  |  | Profit
Spreadsheet: 544774d1509025107-index-and-match-formula-with-multiple-criteria-sample-workbook-for-payroll
Sheet: Salary Data

 | Department Head | Department | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | A | Human Resource | 5 | 15 | 20 | 40 | 25 | 30 | 45 | 50 | 65 | 75 | 85 | 95
 | A | Finance
 | A | Account
 | A | IT
 | A | Software Development
 | B | Human Resource
 | B | Finance
 | B | Account
 | B | IT
 | B | Software Development
Spreadsheet: 746816d1631044000-rank-order-including-manual-overriding-rank-order-input-example-rank-including-overriding-order-input
Sheet: Sheet1

 | Asset ID | Due Date | Order (Auto) | Order (Manual) | Order (Final)
 | Asset 1 | 2021-04-18 00:00:00 |  |  | 1 |  |  |  | = Variable Cell To allow manual  overriding entry of order
 | Asset 2 | 2021-10-17 00:00:00 |  |  | 2
 | Asset 3 | 2022-08-06 00:35:52.406000 |  | 3 | 3
 | Asset 4 | 2022-06-19 00:00:00 |  |  | 8
 | Asset 5 | 2022-02-12 01:55:18.075000 |  |  | 7 |  |  |  | = Expected result To return new order including any overriding manual inputs
 | Asset 6 | 2021-12-20 12:06:27.538000 |  |  | 5
 | Asset 7 | 2022-06-22 05:43:32.826000 |  |  | 10
 | Asset 8 | 2021-11-19 06:56:25.719000 |  |  | 4
 | Asset 9 | 2022-01-27 05:07:35.182000 |  |  | 6
 | Asset 10 | 2022-06-21 12:49:18.904000 |  |  | 9
Spreadsheet: 39136d1237332778-record-count-meeting-4-criteria-count-multiple-criteras
Sheet: Sheet1

FY | Month | Type | POOM | Meets # criteria
2009 | March | MOTOR VEHICLE | 0 | 3
2008 | October | INDUSTRIAL | 0 | 2 |  | Records meeting criteria of : | 3
2007 | January | INDUSTRIAL | 0 | 2 | 2009 | FY = 2009
2005 | October | INDUSTRIAL | 0 | 2 | March | Month_Desc = March
2006 | October | MOTOR VEHICLE | 7 | 0 | INDUSTRIAL | Type_Descript = Industrial
2004 | October | INDUSTRIAL | 6 | 1 | 0 | POOM = 0
2009 | March | MOTOR VEHICLE | 0 | 3
2007 | October | INDUSTRIAL | 3 | 1 |  | (All conditions must be met)
2007 | March | MOTOR VEHICLE | 5 | 1 |  | Answer = 3 records
2007 | October | INDUSTRIAL | 4 | 1
2009 | March | INDUSTRIAL | 0 | 4
2008 | October | INDUSTRIAL | 1 | 1
2009 | March | INDUSTRIAL | 0 | 4
2005 | March | INDUSTRIAL | 0 | 3
2006 | March | INDUSTRIAL | 0 | 3
2009 | March | INDUSTRIAL | 0 | 4
Spreadsheet: 49669d1249006702-single-vs-mutiple-entry-sheets-testing
Sheet: Result Expected

Name | Alphabet | Number |  | OR |  | Name | Alphabet | Number
[NAME] | A | 1 |  |  |  | [NAME] | A | 1
 |  | 2 |  |  |  | [NAME] | A | 2
 |  | 3 |  |  |  | [NAME] | A | 3
 | B | 1 |  |  |  | [NAME] | B | 1
 |  | 2 |  |  |  | [NAME] | B | 2
 |  | 3 |  |  |  | [NAME] | B | 3
Shyama | C | 1 |  |  |  | Shyama | C | 1
 |  | 2 |  |  |  | Shyama | C | 2
 |  | 3 |  |  |  | Shyama | C | 3
 | D | 1 |  |  |  | Shyama | D | 1
Deepti | E | 2 |  |  |  | Deepti | E | 2
 |  | 3 |  |  |  | Deepti | E | 3
 | F | 2 |  |  |  | Deepti | F | 2
 |  | 3 |  |  |  | Deepti | F | 3
 |  | 1 |  |  |  | Deepti | F | 1
Spreadsheet: 879361d1726839712-sum-a-range-of-cells-sum-to-forum
Sheet: Sheet1

 |  |  |  |  |  |  | # of occcurances | Day |  |  |  | total of Occurances
 |  |  |  |  |  |  | 10 | 1 |  | 1 | 5
 |  |  |  |  |  |  | 2 | 2
 |  |  |  |  |  |  | 5 | 3 |  |  | 20
 |  |  |  |  |  |  | 6 | 4 |  |  | 30
 |  |  |  |  |  |  | 12 | 5
 |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  | 1 | 7
 |  |  |  |  |  |  | 8 | 8
 |  |  |  |  |  |  | 4 | 9
 |  |  |  |  |  |  | 3 | 10
 |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  | 9 | 12
 |  |  |  |  |  |  | 8 | 13
 |  |  |  |  |  |  | 4 | 14
 |  |  |  |  |  |  | 2 | 15
 |  |  |  |  |  |  | 6 | 16
 |  |  |  |  |  |  | 6 | 17
 |  |  |  |  |  |  | 8 | 18
 |  |  |  |  |  |  | 5 | 19
 |  |  |  |  |  |  | 6 | 20
 |  |  |  |  |  |  | 4 | 21
 |  |  |  |  |  |  | 4 | 22
 |  |  |  |  |  |  | 3 | 23
 |  |  |  |  |  |  | 2 | 24
 |  |  |  |  |  |  | 2 | 25
 |  |  |  |  |  |  | 1 | 26
 |  |  |  |  |  |  | 1 | 27
 |  |  |  |  |  |  | 5 | 28
 |  |  |  |  |  |  | 3 | 29
 |  |  |  |  |  |  | 4 | 30
 |  |  |  |  |  |  | 1 | 31
Spreadsheet: 857497d1706516136-having-problems-using-formulas-and-functions-timber-for-modules
Sheet: Total Required

TOTAL TIMBER REQUIRED
SIZE # | DIMENSIONS | COST EACH | REQU-IRED | USED | REMA-INING | TOTALJOB COST | ROLLING COST | REMAIN COST
A | 1200 X 64 X 19 | 6.93 | 4 | 0
B | 1800 X 64 X 19 | 12.85 | 9 | 0
C | 2400 X 64 X 19 | 14.99 | 2 | 0
D | 3000 X 64 X 19 | 18.15 | 0 | 0
E | 1200 X 42 X 42 | 13.4 | 12 | 6
F | 1800 X 42 X 42 | 21.4 | 0 | 0
 | Note  1. | All Dimensions are in millimetres (mm)
Spreadsheet: richard_shapiro__32144__EastPowerReOrgE
Sheet: Sheet2

24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | Cyril Price | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
24 Hour Trading | [NAME] | 107311
Spreadsheet: 761759d1641206657-problem-with-text-and-weekday-function-text-function_sample
Sheet: Sheet1

Date | =TEXT(A1,"yyyymmdd") | =Weekday(B1)
2021-12-29 00:00:00
2021-12-29 00:00:00
2021-10-05 00:00:00
2021-07-28 00:00:00
2021-06-28 00:00:00
2021-06-28 00:00:00
2021-06-28 00:00:00
2021-06-28 00:00:00
2021-06-28 00:00:00
2021-06-28 00:00:00
2021-05-07 00:00:00
2021-05-07 00:00:00
2021-05-07 00:00:00
2021-03-11 00:00:00
2021-03-03 00:00:00
2021-02-24 00:00:00
2021-02-24 00:00:00
2021-02-23 00:00:00
2021-02-23 00:00:00
2021-02-19 00:00:00
2021-02-19 00:00:00
2021-02-19 00:00:00
2021-02-18 00:00:00
2021-02-10 00:00:00
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Midwest Power

Midwest Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
Clynes |  | Power |  | Midwest Orig
Baughman |  | Power |  | Midwest Orig |  | 1156703
[NAME] |  | Power |  | Midwest Orig
[NAME] |  | Power |  | Midwest Orig |  | 564466
Kelly |  | Power |  | Midwest Orig |  | 500000
Sewell |  | Power |  | Midwest Orig |  | 298791
Wang |  | Power |  | Midwest Orig |  | 50000
Wheeler |  | Power |  | Midwest Orig
Total
Spreadsheet: 772070d1646996076-need-help-on-formula-to-get-score-for-help-calculation
Sheet: For Help

 |  |  |  |  |  |  |  |  |  |  | 1st Scenario |  |  | 2nd Scenario
 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5 |  |  | Transaction Per Hr | Expected Score Out of 5 |  | Transaction Per Hr | Expected Score Out of 5
 |  | 17.25 |  | 16 | 21 | 24 | 27 |  |  | A --- > | 16 | 2 |  | 2 | 2
 |  |  |  |  |  |  |  |  |  | mid of A & B
 |  |  |  |  |  |  |  | it should be 2.12 |  | B --- > | 21 | 2.5 |  | 4 | 2.5
 |  |  |  |  |  |  |  |  |  | mid of B & C
 |  |  |  |  |  |  |  |  |  | C --- > | 24 | 3.5 |  | 6 | 3.5
 |  |  |  |  |  |  |  |  |  | mid of C & D
 |  |  |  |  |  |  |  |  |  | D --- > | 27 | 4.5 |  | 8 | 4.5
 |  |  |  | 2 | 2.5 | 3.5 | 4.5
 |  | Transaction Per Hr | Weight | Range |  |  |  | Out of 5
 |  | 7.5 |  | 2 | 4 | 6 | 8
 |  |  |  |  |  |  |  | it should be 4.25
Spreadsheet: 166690d1341724836-excel-2007-automnatically-copy-formula-to-next-row-when-a-cell-is-populated-in-that-row-excel-q
Sheet: Sheet1

 |  | Question1 |  |  |  | Question2 |  |  |  | Question3 |  |  |  | Question4
Number | Load (Yes / No) | Q1 | Q2 | Q3 | A4 | Q4 | Q1 | Q2 | A5 | Q3 | Q4 | Q1 | A6 | Q1 | Q2 | Q3 | Q4 | Yes | No | N/A
 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
222 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
222222 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
111 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
6436 |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
a |  | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10 | Yes |  |  | 10
Spreadsheet: 840421d1692718566-powerquery-how-to-add-new-row-with-data-based-on-on-values-in-a-columne-add-new-rows-example
Sheet: Original

Issue ID | Description | Country | Problem Code | Issue Hit | Created Date
A1 | BA1 had 1 issue need to create Issue ID | USA | 15 | ACCT US - Wrong info | 2023-08-01 00:00:00
A2 | 2 Issue found | EU | 16 | ACCT EU | 2023-08-02 00:00:00
A3 | 3 Issue found | EU | 17 | ACCT EU | 2023-08-03 00:00:00
A4 | 4 Issue found | EU | 18 | ACCT EU | 2023-08-04 00:00:00
A5 | BA2 had 1 need to create Issue ID | EU | 19 | ACCT EU | 2023-08-05 00:00:00
A6 | 6 Issue found | USA | 20 | ACCT US | 2023-08-06 00:00:00
A7 | 7 Issue found | USA | 21 | ACCT US | 2023-08-07 00:00:00
A8 | BA3 had 1 need to create Issue ID | USA | 22 | ACCT US | 2023-08-08 00:00:00
A9 | 9 Issue found | EU | 23 | ACCT EU | 2023-08-09 00:00:00
A10 | 10 Issue found | EU | 24 | ACCT EU | 2023-08-10 00:00:00
Spreadsheet: 851854d1701972565-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: TAURO 2

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 8 Pass | 2024-01-15 00:00:00 |  |  | For production quote- [NAME]
 | 819 | 67.1-R | SURL | 20 | 22 | 22 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 45261 |  | T2
 | 819 | 134.1-R | SURL | 7 | 52 | 10 | PAP-SO-1354 - ULTRABOARD 3/16IN WHITE 48X96 | 2 | 4 Pass | 45261 |  | T2
 | 242778 | 2 | Equestrian Sports Productions LLC | 6999 | 8 | 6 | PAP-444450 - 48X96 30PT STYRENE | 1 | 4 Pass | 45261 |  | T2
 | 242697 | 1 | Perfect Promotions | 10 | 36 | 24 | PAP-SO-0016 - 48X96 COROPLAST | 2 | 4 Pass | 45261 |  | T2
 | 242684 | 1 | Wompas Graphix | 18 | 22 | 16 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 1 | 4 Pass | 45261 |  | T2
Spreadsheet: 694618d1599720264-depreciation-computation-in-a-single-row-depreciation-computation
Sheet: Sheet1

 | Depreciation Computation
 | Shelf Life (years) | 5 |  | SUMPRODUCT($H243:H243,(COLUMN(H243)-COLUMN($H243:H243)<$G$234)/$G$234)
 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Capex | 46000 | 39000 | 45000 | 23000 | 45000 | 10000 | 21000 | 40000 | 37000 | 43000
 | Depreciation for
 | Year 1 Capex
 | Year 2 Capex
 | Year 3 Capex
 | Year 4 Capex
 | Year 5 Capex
 | Year 6 Capex |  |  |  |  |  |  |  |  |  |  |  |  | this is how I calculate the depreciation
 | Year 7 Capex
 | Year 8 Capex
 | Year 9 Capex
 | Year 10 Capex
 | Total Depreciation
 | Total Depreciation |  |  |  |  |  |  |  |  |  |  |  |  | this single row is what is desired
 |  | formula required to calculate depreciation based on shelf life, without the details in the table above
Spreadsheet: 2784cab1-12a7-4968-98db-1d0ecd470825
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4465 | 13989 | Team I | Denmark | DEN | 0 | 06:30:15 | 00:00:00 | 06:42:17 | 00:00:00 | 06:50:32 | 1 | 20:03:04
4465 | 14070 | Team I | Netherlands | NED | 0 | 06:31:56 | 00:00:00 | 06:40:33 | 00:00:00 | 06:51:44 | 2 | 20:04:13
4465 | 14169 | Team I | United States | USA | 0 | 06:54:52 | 00:00:00 | 07:08:37 | 00:00:00 | 07:11:23 | 3 | 21:14:52
4465 | 11830 | Team I | Italy | ITA | 0 | 06:49:00 | 00:00:00 | 07:10:46 | 00:00:00 | [NAME] | 4 | 21:17:16
Spreadsheet: 203231d1356987186-methods-of-comparison-sample
Sheet: Sheet1

Name | My organization | Organization 1 | Organization 2 | Organization 3 | Organization 4 | Organization 5 | Organization 6 | Organization 7 | Organization 8 | Comparison Organization Average | Difference Vs. Hospital
Service 1 | 121.54 | 39.36 | 42.16 | 72.47 | 60.44 | 83.23 | 41.57 | 62.06 | 44.34
Service 2 | 576.49 | 478.1 | 503.04 | 510.5 | 622.4 | 528.26 | 673.74 | 528.95 | 523.48
Spreadsheet: 106029d1303256784-convert-horizontal-table-to-vertical-list-excel-forum-example
Sheet: Sheet1

Trying to get this
Key | Ring | Ring | Ring | Ring
A | 1 | 2 | 3 | 4
B | 1 | 2
C | No Ring
D | 1 | 2 | 3
E | 1 | 2 | 3 | 4
to look like this
Key | Ring
A | 1
A | 2
A | 3
A | 4
B | 1
B | 2
B | 3
B | 4
C | No Ring
D | 1
D | 2
D | 3
E | 1
E | 2
E | 3
E | 4
Spreadsheet: 4a2f423c-0fe5-41ba-85f9-383afef141a2
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
261203 | 79384 | Beatriz | Serrano | MEX | 168 | 00:21:53 | 00:01:55 | 00:39:30 | 00:02:14 | 00:11:28 | 1 | 01:17:00
261203 | 79385 | [NAME] | Vega | MEX | 172 | 00:25:05 | 00:02:28 | 00:47:45 | 00:01:55 | 00:12:53 | 2 | 01:30:06
261203 | 79386 | [NAME] Eugenia | Reyes | MEX | 244 | 00:36:19 | 00:03:30 | [NAME] | 00:03:01 | 00:21:03 | 3 | 01:53:56
Spreadsheet: 1ef50df9-fd95-4868-9812-e00d22eb4d07
Sheet: 9b

Product1 | EUR3 | GBP | [NAME] | USD | AUD | CAD | OTHER | TOTAL
Fixed-Float | 208514 | 73975 | 32201 | 825687 | 14231 | 37424 | 138269 | 1330301
OTHER* | 74622 | 52079 | 23845 | 176491 | 57196 | 31795 | 9299 | 425327
TOTAL | 283136 | 126054 | 56046 | 1002178 | 71427 | 69219 | 147568 | 1755628
*OTHER variable includes the following products: Swaption, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, Basis, OIS, and FRA.
Spreadsheet: 6e39f86b-5bb0-4cbe-a225-4f9cb70d14a3
Sheet: Arkusz1

Table S3. Ethnic origin of the samples for which complete mitochondrial genome sequences were determined in the current study.
 | Sequence ID | Ethnic origin
Figure 2 | P526 | Polish, Podhale
Figure 3 | K202 | Polish, [NAME]
 | K422 | Polish, [NAME]
 | P584 | Polish, Podhale
 | UKR_150 | Ukrainian, Lviv region
 | UKR_160 | Ukrainian, Lviv region
 | UKR_190 | Ukrainian, Lviv region
Figure 4 | K320 | Polish, [NAME]
 | P536 | Polish, Podhale
 | P583 | Polish, Podhale
Figure S1 | B121 | Polish, Pomerania-Kujawy region
 | B150 | Polish, Pomerania-Kujawy region
 | B176 | Polish, Pomerania-Kujawy region
 | BEL-I-5 | Russian, Belgorod region
 | BEL-I-14 | Russian, Belgorod region
 | CZ-III-46 | Czech
 | CZ-I-1631 | Czech
 | CZ-III-19 | Czech
 | CZ-IV-13 | Czech
 | CZ-V-311 | Czech
 | GD26 | Polish, [NAME]
 | GD54 | Polish, [NAME]
 | K337 | Polish, [NAME]
 | K343 | Polish, [NAME]
 | K356 | Polish, [NAME]
 | K656 | Polish, [NAME]
 | KL-64 | Russian, Kaluga region
 | N055 | Polish, Bydgoszcz
 | N057 | Polish, Bydgoszcz
 | O-17 | Russian, Oryol region
 | O-54 | Russian, Oryol region
 | P17 | Polish, Podhale
 | P41 | Polish, Podhale
 | P138 | Polish, Podhale
 | P148 | Polish, Podhale
 | P531 | Polish, Podhale
 | PS-21 | Russian, Pskov region
 | PS-34 | Russian, Pskov region
 | PS-41 | Russian, Pskov region
 | PS-67 | Russian, Pskov region
 | SLV-2 | Slovak
 | SLV-69 | Slovak
 | SLV-74 | Slovak
 | SLV-107 | Slovak
 | SLV-115 | Slovak
 | SLV-148 | Slovak
 | SLV-149 | Slovak
 | SLV-230 | Slovak
 | T-42 | Russian, [NAME] region
 | T-63 | Russian, [NAME] region
 | T-81 | Russian, [NAME] region
 | T-88 | Russian, [NAME] region
 | T-96 | Russian, [NAME] region
 | T-104 | Russian, [NAME] region
 | UKR-123 | Ukrainian, Lviv region
 | UKR-126 | Ukrainian, Lviv region
 | UKR-154 | Ukrainian, Lviv region
 | V-75 | Russian, Yaroslavl region
 | Y-9 | Russian, Yaroslavl region
 | Y-56 | Russian, Yaroslavl region
 | Y-120 | Russian, Yaroslavl region
Figure S2 | B381 | Polish, Pomerania-Kujawy region
 | B51 | Polish, Pomerania-Kujawy region
 | Cz_III-50 | Czech, western Bohemia
 | Cz_I-18 | Czech, western Bohemia
 | Cz_II-19 | Czech, western Bohemia
 | Sl_246 | Slovak, western Slovakia
 | Sl_233 | Slovak, eastern Slovakia
 | Sl_140 | Slovak, eastern Slovakia
 | BG_I-10 | Russian, Belgorod region
 | BG_II-20 | Russian, Belgorod region
 | 412_M | Ukrainian, eastern Ukraine