tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 141333d1329223549-calculating-time-differences-depending-on-time-of-the-day-duty-hours-example
Sheet: Sheet1

Download | Start | End | Hours on duty | Desired output | Suggested solution
23:00-07:00 | 23:00 | 07:00 | 8 | 7 | 6.999999999999999
07:00-15:30 | 07:00 | 15:30 | 8.5 | 0 | 0
15:00-23:00 | 15:00 | 23:00 | 8 | 3 | 3
17:00-02:00 | 17:00 | 02:00 | 8.999999999999996 | 6 | 6
00:00-07:30 | 00:00 | 07:30 | 7.5 | 6 | 6
only count the hours on duty between 20:00 and 06:00
 | 06:00:00 | 20:00:00
Spreadsheet: 08bca03b-677b-432c-a7bf-a8e4b2278de0
Sheet: Sheet1

SINGLE ROUTINE SCORESHEET | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | ROUTINE EVENT | Unnamed: 8 | Unnamed: 9 | ORDER OF APPEARANCE
Competition
Place |  |  |  |  |  |  | AGE / DIV.
Date |  |  |  |  |  |  |  |  |  | FINAL      PLACING
Country / Club |  |  |  |  |  |  | 3 LETTER CODE
No. | FIRST NAME / LAST NAME OF COMPETITORS |  |  |  |  |  |  |  |  | R = Reserve
1
2
3
4
5
6
7
8
9
10
11
12
JUDGES AWARDS - TECHNICAL MERIT (Free Routine)
JUDGES AWARDS - EXECUTION (Technical Routine) |  |  |  |  |  |  |  |  | N = No. of Judges
1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL - HI / LO |  | (TOTAL - HI / LO) * 5
 |  |  |  |  |  |  |  |  | (N - 2)
 |  |  |  |  |  |  |  |  |  | Execution Penalty (Technical Elements)  -
 |  |  |  |  |  |  |  |  | SUBTOTAL
JUDGES AWARDS - ARTISTIC IMPRESSION (Free Routine)
JUDGES AWARDS - OVERALL IMPRESSION (Technical Routine) |  |  |  |  |  |  |  |  | N = No. of Judges
1 | 2 | 3 | 4 | 5 | 6 | 7 | TOTAL - HI / LO |  | (TOTAL - HI / LO) * 5
 |  |  |  |  |  |  |  |  | (N - 2)
 |  |  |  |  |  |  |  |  |  | JUDGES AWARDS TOTAL SCORE
 |  |  |  |  |  |  |  |  |  | TEAM ROUTINE ADJUSTMENT (US: .25 BONUS FOR EACH ATHLETE OVER 4)  +
 |  |  |  |  |  |  |  |  |  | TEAM ROUTINE ADJUSTMENT (FINA: .5 [NAME] FOR EACH ATHLETE UNDER 8)  -
PENALTY DESCRIPTION: |  |  |  |  |  |  |  |  |  | PENALTY  -
 |  |  |  |  |  |  |  |  |  | TOTAL ROUTINE SCORE
REFEREE / RECORDER
Spreadsheet: james_steffes__12816__Credit_Gas
Sheet: Sheet1

 |  | CREDIT FOR GAS RETAIL MARKETS
 | Form of | Likely New | Incremental Collateral Likely By:
Utility | Collateral | Form of | 2001-12-15 00:00:00 | 2001-12-31 00:00:00 | 2001-01-15 00:00:00
 | (11/30/01) | Collateral
 |  | (post filing)
SoCal Gas | Margin call on | None. | 0 | 0 | 0
 | Imbalances & | Revised contract
 | Receivables | recently put
 | in excess of | in place
 | $3 million
BGE | $250,000 Letter | None, if gas flows | 0 | 0 | 0
 | of Credit | to City Gate.  No
 |  | new customers
 |  | accepted
NIMO | Corp Guaranty | $4.3 million cash | 4.3 | 4.3 | 4.3
Washington Gas | Corp Guaranty | $1.0 million cash | 1 | 1 | 1
Light (MD)
PSEG |  | $1.0 million cash | 1 | 1 | 1
Peoples Gas (IL) | Corp Guaranty | $40,000 cash | 0.04 | 0.04 | 0.04
Northern Illinois
PG&E
Columbia of OH
East Ohio
LILCO
[NAME]
Peoples Natural
Gas (PA)
Lone Star Gas
Spreadsheet: 691295d1597623335-rank-by-3-position-student-t-score-ranks
Sheet: Sheet3

 | student | test 1 | test 2 | test 3 |  | Student T Scores for tests |  |  | Average | Rank
1 | [NAME] | 2.14 | 2.53 | 145
2 | N.N. | 2.09 | 2.51 | 140
3 | P.I. | 2.18 | 2.4 | 145
4 | A.P. | 2.19 | 2.35 | 140
5 | C.G. | 2.23 | 2.45 | 140
6 | R.N. | 2.2 | 2.4 | 135
7 | B.G. | 2.11 | 2.3 | 130
8 | N.V. | 2.19 | 2.35 | 135
9 | A.C. | 2.19 | 2.4 | 135
10 | A.R. | 2.25 | 2.4 | 140
11 | V.V. | 2.21 | 2.4 | 130
12 | P.E. | 2.17 | 2.35 | 125
13 | S.V. | 2.31 | 2.35 | 140
14 | P.M. | 2.29 | 2.3 | 140
15 | [NAME] | 2.3 | 2.35 | 135
16 | T.C. | 2.2 | 2.2 | 135
17 | G.M. | 2.3 | 2.37 | 125
18 | S.I. | 2.27 | 2.2 | 135
19 | T.E. | 2.2 | 2.25 | 125
20 | C.J. | 2.21 | 2.35 | 115
21 | F.G. | 2.25 | 2.17 | 130
22 | M.V. | 2.29 | 2.3 | 125
23 | D.J. | 2.27 | 2.3 | 130
24 | D.E. | 2.31 | 2.34 | 120
25 | O.G. | 2.35 | 2.23 | 125
26 | E.I. | 2.37 | 2.15 | 130
27 | G.N. | 2.41 | 2.2 | 115
28 | I.D. | 2.35 | 2.15 | 105
29 | S.D. | 2.47 | 2.05 | 110
30 | B.I. | 2.29 | 2.05 | 110
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: PHYSIC

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.S. Degree Physics | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
5 | PHYSIC 100 | 1 | X | 1 | X | 1
5 | PHYSIC 110 | 1 | X | 1 | X | 1
5 | PHYSIC 111 | 1 | X | 1 | X | 1
5 | PHYSIC 200 | 1 | X | 1 | X | 1
5 | PHYSIC 201 | 1 | X | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 867637d1714463416-find-the-data-on-the-first-cell-from-the-column-where-a-specific-value-is-book1-h
Sheet: Sheet1

a | b | c | d
Doug | [NAME] | [NAME] | [NAME]
Ruby | [NAME] | Joy | [NAME]
[NAME] | [NAME] | Fredrick | Peggy |  | [NAME]
[NAME] |  | [NAME] | Scott |  | [NAME]
Nazia |  | Ingrid
 |  | [NAME]
 |  | Amber
 |  | April
Spreadsheet: e2a87c82-283e-4d27-ae18-01110b42c715
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
38766730 | 2013-11-30 04:49:57 | AXIS | 1 | 6 | 4 | 1451598 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38767032 | 2013-11-30 05:14:33 | ALLIES | 1 | 6 | 2 | 1451598 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38767301 | 2013-11-30 06:02:47 | AXIS | 1 | 6 | 2 | 1451598 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
38767681 | 2013-11-30 06:36:06 | ALLIES | 1 | 6 | 4 | 1451598 | [NAME] | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 36

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
36 | 2007-02-16 00:00:00 | 7.8 | 0.31 | 1.8 | 0.7 | 1.3 | 2.4 |  |  |  | 0.5 |  | 1.644384383287557 | 1.2 | 0 | 5 |  |  |  |  | 0.2
Well #36 | 2013-10-11 00:00:00 | 3.3 | 1.07 | 5.08 | 1.99 | 2.2 | <0.1 |  |  | 5.4 | 4.1 |  | 1.2 | 0.3 | 0.03 | 4.9 |  | 0.15 | <0.02 |  | -5.8
Well - 36 | 2014-02-05 00:00:00 | 7.9 | 0.63 | 3.04 | 1.22 | 1.6 | 3.4 |  |  | 0.6 | 1.6 |  | 1.1 | 2.3 | 0.02 | 5.9 |  | <0.10 | <0.02 |  | 0.5
Well 36 | 2015-04-02 00:00:00 | 7.7 | 0.51 | 2.49 | 0.98 | 1.5 | 3.4 |  |  | 0.4 | 1.1 |  | 1.2 | 2.3 | <0.05 | 3.7 |  | <0.10 | <0.02 |  | 0.3
Well 36 | 2016-04-04 00:00:00 | 7.82 | 0.541 | 3.28 | 1.29 | 1.85 | 3.452961393973304 | 3.452961393973304 | 0 | 0.425 | 1.2335 | 345.6 | 1.22 | 2.34 | 0.028 | 4.50997 | 0.007 | 0 | 0 | 0
W36 | 2018-05-29 00:00:00 | 7.95 | 0.378 | 2.09 | 0.838 | 1.6 |  | 3.165214611142195 | 0 | 0.234 | 0.424 | 241.92 |  |  | 0.028 | 2.013 | 0.011 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Comments: alk low 2013
Spreadsheet: 56389d1256588867-find-matches-in-two-columns-of-unique-ids-and-return-result-book1
Sheet: Sheet2

1 | 22 | 22
9 | 1
5 | 13
5 | 23 | 23
15 | 19 | 19
18 | 28 | 28
2 | 12
13 | 4
17 | 15
12 | 26 | 26
10 | 5
16 | 2
8 | 22 | 22
10 | 7 | 7
1 | 25 | 25
18 | 3
4 | 10
3 | 17
12 | 1
17 | 8
20 | 14 | 14
10 | 18
1 | 5
2 | 0 | 0
Spreadsheet: 221097d1363366130-if-statement-with-vlookup-for-text-value-forum-sample
Sheet: Sheet2

 | 1
1049078 | 1049078 | APL | IPH4D | 1 | 1.275347222217533 | RTS
1049078 | 1049078 | APL | IPH4D | 362 | 6.89321785491515 | AREFX | 372 | 7.507408002413926 | AREFX | 261 | 8.27558172236861 | AREFX | 218 | 9.615490350799634 | AREFX | 4 | 8.847033179011001 | AREFX | 5 | 37.65498070987815 | AREFX
1049078 | 1049078 | APL | IPH4D | 104 | 5.870249860434757 | BER | 215 | 7.59541414120022 | BER | 138 | 9.99794258313497 | BER | 177 | 13.93446576597052 | BER | 62 | 32.42313466265291 | BER | 38 | 29.76363352439708 | BER | 46 | 37.61264161247089 | BER
1049078 | 1049078 | APL | IPH4D | 139 | 8.416739085129501 | ERBSTK | 235 | 7.110103076034421 | ERBSTK | 140 | 10.0759449833614 | ERBSTK | 119 | 13.73180618578255 | ERBSTK | 7 | 19.42989486882773 | ERBSTK | 5 | 37.06767168209748 | ERBSTK | 3 | 38.01493827160448 | ERBSTK
1049078 | 1049078 | APL | IPH4D | 40 | 6.837767018177462 | FNUNRP | 368 | 7.668848376509522 | FNUNRP | 357 | 9.174212531177343 | FNUNRP | 458 | 14.39383943116293 | FNUNRP | 39 | 20.17183445055256 | FNUNRP | 37 | 33.43326985213425 | FNUNRP | 3 | 59.04560185185073 | FNUNRP
1049087 | 1049087 | APL | IPH4E | 71 | 8.192317371721325 | AREFX | 72 | 8.103577994103102 | AREFX | 69 | 9.242626681857317 | AREFX | 58 | 12.25755986615571 | AREFX | 2 | 18.65491898148321 | AREFX
1049087 | 1049087 | APL | IPH4E | 20 | 6.326316671488788 | BER | 45 | 8.32741342868235 | BER | 35 | 11.28579210069438 | BER | 40 | 12.56296579013912 | BER | 9 | 27.7313122106519 | BER | 8 | 32.38562757201766 | BER | 11 | 41.0125122974523 | BER
1049087 | 1049087 | APL | IPH4E | 25 | 8.392385536081179 | ERBSTK | 38 | 8.025887679123397 | ERBSTK | 39 | 10.64566335107376 | ERBSTK | 27 | 12.40336055996318 | ERBSTK | 2 | 15.21460069444583 | ERBSTK |  |  |  | 1 | 48.23576388889342 | ERBSTK
1049087 | 1049087 | APL | IPH4E | 9 | 7.853006606867439 | FNUNRP | 68 | 7.66296425540135 | FNUNRP | 84 | 10.13375168339565 | FNUNRP | 95 | 13.57335831687953 | FNUNRP | 4 | 26.48306134259352 | FNUNRP | 10 | 25.53185821759216 | FNUNRP
1049236 | 1049236 | APL | IPH4D | 32 | 8.38578740800136 | AREFX | 36 | 8.7204304728863 | AREFX | 57 | 9.710222708860012 | AREFX | 39 | 9.213506871376032 | AREFX
1049236 | 1049236 | APL | IPH4D | 8 | 6.603693287037094 | BER | 26 | 9.957540481702104 | BER | 25 | 11.63129972029234 | BER | 17 | 11.02467709711224 | BER | 6 | 20.96630979938345 | BER | 1 | 41.23888888888905 | BER | 4 | 37.77081404321022 | BER
1049236 | 1049236 | APL | IPH4D | 12 | 8.921981524348263 | ERBSTK | 14 | 7.776235210903906 | ERBSTK | 23 | 9.027706481480806 | ERBSTK | 10 | 14.08342418981471 | ERBSTK | 1 | 39.07406250000349 | ERBSTK | 2 | 25.15488425925651 | ERBSTK
1049236 | 1049236 | APL | IPH4D | 5 | 8.815370370371966 | FNUNRP | 14 | 6.873815800754124 | FNUNRP | 34 | 9.780594314923968 | FNUNRP | 26 | 15.89781215871282 | FNUNRP |  |  |  | 6 | 29.41472569444377 | FNUNRP
Spreadsheet: 718535d1613170250-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 13

 |  |  | Date | 2021-01-13 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 15:00:00 | 16:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 1 day, 0:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: Kesha Ram

[NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
I'd like to explain my position
Explain your health care reform position, if you choose
I support collective bargaining rights and the ability of all employees to negotiate for additional benefits and compensation
through that process, as is the case now. In order to achieve meaningful health care reform, we need everyone at the table.
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
I do not know a great deal about this issue besides what I have read from your position statement, and would gladly review
additional information. If it is as cumbersome and out of line with professional growth as it sounds, then I would agree it should
be simplified or improved.
Name | email address | Address | Office sought | Are you an incumbent? |  | County
[NAME] | [EMAIL] | 31 N Prospect Street, Burlington, VT 05401 | State Representative | Yes |  | Chittenden
Spreadsheet: andy_zipper__259__Broker detail 4-23-01
Sheet: Broker Summary

EnronOnline
[NAME] for 4/23/2001
Completed Transactions: |  |  |  |  |  |  |  | Failed Transactions:
DAILY DEAL COUNT |  | Commodity |  |  |  |  |  | FAILED TRANSACTION COUNT |  | Commodity
Broker | Date | Natural Gas | Power | Grand Total |  |  |  | Broker | Date | Natural Gas | Power | Grand Total
APB Energy, Inc. | 2001-04-17 00:00:00 |  | 3 | 3 |  |  |  | APB Energy, Inc. | 2001-04-17 00:00:00 | 1 | 1 | 2
 | 2001-04-18 00:00:00 | 2 | 2 | 4 |  |  |  |  | 2001-04-18 00:00:00 | 1 |  | 1
 | 2001-04-19 00:00:00 | 4 | 2 | 6 |  |  |  |  | 2001-04-23 00:00:00 | 1 |  | 1
 | 2001-04-20 00:00:00 | 1 |  | 1 |  |  |  | APB Energy, Inc. Total |  | 3 | 1 | 4
 | 2001-04-23 00:00:00 | 4 | 3 | 7 |  |  |  | Natsource LLC | 2001-03-28 00:00:00 |  | 3 | 3
APB Energy, Inc. Total |  | 11 | 10 | 21 |  |  |  |  | 2001-04-04 00:00:00 |  | 1 | 1
Natsource LLC | 2001-03-28 00:00:00 |  | 1 | 1 |  |  |  |  | 2001-04-10 00:00:00 |  | 2 | 2
 | 2001-03-30 00:00:00 |  | 1 | 1 |  |  |  |  | 2001-04-17 00:00:00 |  | 1 | 1
 | 2001-04-02 00:00:00 |  | 3 | 3 |  |  |  |  | 2001-04-18 00:00:00 |  | 2 | 2
 | 2001-04-03 00:00:00 |  | 1 | 1 |  |  |  |  | 2001-04-19 00:00:00 |  | 1 | 1
 | 2001-04-04 00:00:00 |  | 1 | 1 |  |  |  |  | 2001-04-20 00:00:00 |  | 1 | 1
 | 2001-04-05 00:00:00 |  | 2 | 2 |  |  |  |  | 2001-04-23 00:00:00 |  | 1 | 1
 | 2001-04-10 00:00:00 | 1 |  | 1 |  |  |  | Natsource LLC Total |  |  | 12 | 12
 | 2001-04-11 00:00:00 | 1 | 2 | 3 |  |  |  | Power Merchants Group | 2001-04-17 00:00:00 | 1 |  | 1
 | 2001-04-12 00:00:00 | 2 | 5 | 7 |  |  |  | Power Merchants Group Total |  | 1 |  | 1
 | 2001-04-16 00:00:00 | 1 | 1 | 2 |  |  |  | Grand Total |  | 4 | 13 | 17
 | 2001-04-17 00:00:00 |  | 8 | 8
 | 2001-04-18 00:00:00 | 3 | 6 | 9
 | 2001-04-19 00:00:00 | 3 | 11 | 14
 | 2001-04-20 00:00:00 |  | 2 | 2
 | 2001-04-23 00:00:00 |  | 6 | 6
Natsource LLC Total |  | 11 | 50 | 61
Power Merchants Groupting & Trading Company | 2001-04-18 00:00:00 | 1 |  | 1
Power Merchants Groupting & Trading Company Total |  | 1 |  | 1
Grand Total |  | 23 | 60 | 83
Spreadsheet: 173116d1344439566-split-string-in-text-and-numbers-nbvc-made-it-today-on-this-forum-splt-text-an-numbers-out-of-a-string-oeldere-
Sheet: Blad1

7D
7,5D
8D
8,5D
9D
9,5D
10EW
10,5EW
11EW
11,5EW
12EW
13EW
Need it to read
"7" Next Column "D"
"7.5" Next Column "D"
"8" Next Column "D"
So on and so forth.
Gemaakt door NBVC op excelforum.com [NAME]. woensdag 08-08-2012
http://www.excelforum.com/excel-general/674193-split-cells-based-on-letters-vs-numbers.html
 | =LOOKUP(9.999999999E+307,--("0"&MID(A1,MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0 123456789")),ROW($1:$10)))) | =SUBSTITUTE(A1,B1,"")
Spreadsheet: 783567d1654911455-match-job-numbers-and-count-line-items-mins-per-line-item
Sheet: Job Times

Ref Number | Transaction Date | Total Hours | Start Time | End Time | Number of Line Items | Mins per Line |  | found rows:
JS00207629 | 2022-05-16 00:00:00 | 0.8 | 06:14:00 | 07:02:00
JS00208541 | 2022-05-16 00:00:00 | 3.483 | 09:15:00 | 12:44:00
JS00208605 | 2022-05-18 00:00:00 | 1.25 | 07:05:00 | 08:20:00
JS00208654 | 2022-05-16 00:00:00 | 1.45 | 11:08:00 | 12:35:00
JS00208775 | 2022-05-17 00:00:00 | 0.5 | 07:36:00 | 08:06:00
JS00208833 | 2022-05-17 00:00:00 | 1.967 | 06:07:00 | 08:05:00
JS00208868 | 2022-05-16 00:00:00 | 0.883 | 07:38:00 | 08:31:00
JS00208869 | 2022-05-16 00:00:00 | 0.983 | 09:39:00 | 10:38:00
JS00208870 | 2022-05-17 00:00:00 | 1.367 | 10:06:00 | 11:28:00
JS00208881 | 2022-05-17 00:00:00 | 0.117 | 14:10:00 | 14:17:00
JS00208883 | 2022-05-16 00:00:00 | 0.483 | 08:31:00 | 09:00:00
JS00208886 | 2022-05-16 00:00:00 | 1.917 | 15:05:00 | 17:00:00
JS00208888 | 2022-05-16 00:00:00 | 0.567 | 07:04:00 | 07:38:00
JS00208891 | 2022-05-17 00:00:00 | 0.317 | 08:06:00 | 08:25:00
JS00208894 | 2022-05-16 00:00:00 | 1.85 | 07:02:00 | 08:53:00
JS00208895 | 2022-05-17 00:00:00 | 0.083 | 10:01:00 | 10:06:00
JS00208896 | 2022-05-17 00:00:00 | 0.65 | 09:19:00 | 09:58:00
JS00208897 | 2022-05-17 00:00:00 | 0.3 | 08:42:00 | 09:00:00
JS00208899 | 2022-05-17 00:00:00 | 0.417 | 12:08:00 | 12:33:00
JS00208903 | 2022-05-16 00:00:00 | 0.617 | 13:31:00 | 14:08:00
JS00208904 | 2022-05-18 00:00:00 | 1.733 | 06:07:00 | 07:51:00
JS00208910 | 2022-05-16 00:00:00 | 0.483 | 09:10:00 | 09:39:00
JS00208913 | 2022-05-17 00:00:00 | 0.167 | 09:05:00 | 09:15:00
JS00208915 | 2022-05-16 00:00:00 | 0.95 | 14:08:00 | 15:05:00
JS00208917 | 2022-05-17 00:00:00 | 0.367 | 10:45:00 | 11:07:00
JS00208934 | 2022-05-18 00:00:00 | 1.567 | 12:26:00 | 14:00:00
JS00208964 | 2022-05-17 00:00:00 | 0.95 | 13:03:00 | 14:00:00
JS00208967 | 2022-05-18 00:00:00 | 0.5 | 11:13:00 | 11:43:00
JS00208968 | 2022-05-18 00:00:00 | 0.35 | 11:13:00 | 11:34:00
JS00208969 | 2022-05-18 00:00:00 | 0.367 | 11:45:00 | 12:07:00
JS00208970 | 2022-05-18 00:00:00 | 1.083 | 09:40:00 | 10:45:00
[NAME] | 2022-05-18 00:00:00 | 0.15 | 11:21:00 | 11:30:00
JS00208973 | 2022-05-18 00:00:00 | 0.35 | 09:10:00 | 09:31:00
JS00208974 | 2022-05-17 00:00:00 | 1.783 | 14:25:00 | 16:12:00
JS00208977 | 2022-05-18 00:00:00 | 0.75 | 13:15:00 | 14:00:00
JS00208989 | 2022-05-19 00:00:00 | 3.233 | 07:23:00 | 10:37:00
JS00208995 | 2022-05-19 00:00:00 | 1.65 | 07:21:00 | 09:00:00
JS00208997 | 2022-05-19 00:00:00 | 1.783 | 07:13:00 | 09:00:00
JW00007821 | 2022-05-16 00:00:00 | 2.983 | 06:01:00 | 09:00:00
JW00007822 | 2022-05-17 00:00:00 | 0.633 | 10:52:00 | 11:30:00
Spreadsheet: 63665d1264548066-lookup-v-to-clearly-show-difference-mismatches
Sheet: Sheet2

A Not in B | B Not in A
10 | 50
34 | 42
34 | 20
23 | 13
30 | 50
11 | 48
36 | 19
10 | 12
36 | 47
 | 42
 | 13
 | 19
 | 48
 | 50
 | 38
 | 38
 | 45
 | 39
 | 17
Spreadsheet: 868849d1715580759-merged-cells-and-dragging-formulas-layout-cells
Sheet: Sheet1

 | LAYOUT RESULT (how to reference data cells and drag down?) |  |  |  |  |  |  |  | REFERENCE DATA
 |  |  |  |  |  |  |  |  | A | aa | aaa | aaaa
 |  |  |  |  |  |  |  |  | B | bb | bbb | bbbb
 |  |  |  |  |  |  |  |  | C | cc | [NAME] | cccc
 |  | bb | bbb |  |  |  |  |  | D | dd | ddd | dddd
 |  |  | bbbb |  |  |  |  |  | E | ee | eee | eeee
 |  |  |  |  |  |  |  |  | F | ff | [NAME] | ffff
 |  |  |  |  |  |  |  |  | G | gg | ggg | gggg
 |  |  |  |  |  |  |  |  | H
Spreadsheet: 833490d1687010250-hide-used-items-in-drop-down-list-sample-chart
Sheet: Sheet1

BLOOD | NAME | AGE | GENDER |  |  |  | SUPPORT | SUPPORT | NAME
A | [NAME] | 18 | Male |  |  |  |  |  | [NAME]
B | [NAME] | 22 | Female |  |  |  |  |  | [NAME]
O | [NAME] | 32 | Female
AB | [NAME] | 23 | Male
O | [NAME] | 11 | Male
B | [NAME] | 25 | Male
AB | [NAME] | 24 | Male
O | [NAME] | 23 | Female
B | Drake | 22 | Female
O | [NAME] | 11 | Female
Spreadsheet: 131974d1323424912-how-to-fill-columns-based-on-other-values-dummy
Sheet: Sheet2

TASK_NUM | DEBRIEF_NUMBER | RECEIPT_DATE | SHIPMENT_NUM | RECEIPT_NUMBER
44567 | 6532 | 2011-11-11 00:00:00 | ES7766987 | 1123
77689 | 7699 | 2011-01-01 00:00:00 | ES760012 | 3266
88946 | 9999 | 2011-02-01 00:00:00 | ES880011 | 7786
1124 | 9824 | 2011-01-03 00:00:00 | ES770001 | 2289
 | 1178 | 2011-11-02 00:00:00 | ES99820 | 9999
 | 4432 | 2011-01-01 00:00:00 | ES99440 | 8432
Spreadsheet: 170021d1343141602-excel-2007-copying-data-from-list-to-multiple-worksheets-sample-2-for-forum
Sheet: template

Name |  |  |  | MONTH
 | PG | ATP | SPG | bond c/f | bond return | BOND CARRIED FORWARD last month
MONTH | 20 | 20 | 20 |  |  | Total Bond In
 |  |  |  |  |  | Total Bond Out
 |  |  |  |  |  | Bond pay back
 |  | TOTAL SALES |  |  |  | Bond Balance for Month
 |  |  |  |  |  | Total Rejects
 |  |  |  |  |  | Total Submissions
 |  |  |  |  |  | [NAME]
MONTH | PG | ATP70 | ATP80 | SPG | TOTAL REJECTS
 | 20 | 20 | 20 | 20
TOTAL
Spreadsheet: 7d8bbcd9-1886-4d15-a35b-8999776f5871
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Entreprenører
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
A T Maskin Anders Tenvik | [NAME] 5 | 3264 | Larvik
[NAME] | [NAME] 80 | 3160 | Stokke
AB Maskin [NAME] | [NAME] | 3256 | Larvik
AST Entreprenør AS | Borgeskogen 4 | 3160 | Stokke
Aage Schau | Hedrumveien 274 | 3270 | Larvik
Abc Anlegg & Ingeniør AS | [NAME] vei 4 | 3120 | Nøtterøy
Abi Drift AS | Bekkevar | 3275 | Svarstad
[NAME] | Solbergveien 20 | 3232 | Sandefjord
Abt Bygg AS | [NAME] | 3138 | Skallestad | 33 35 11 50
Aker Bjørn Vidar | Adalveien 113 | 3157 | Barkåker
[NAME] | Ringveien 26 | 3070 | Sande i Vestfold
[NAME]. innehaver [NAME] | Sauegata 18 | 3260 | Larvik
Allround Entreprenør AS | Adalveien 113 | 3157 | Barkåker
Allum Arne M | Leiv Eirikssons vei 54 | 3269 | Larvik
Andebuveien 322 AS | Andebuveien 322 | 3171 | Sem
Anders Moe | [NAME] 37 | 3215 | Sandefjord
Anders og Arnfinn Tveitan ANS | Trollsås | 3243 | Kodal
[NAME] | [NAME] | 3233 | Sandefjord
[NAME] | [NAME] A | 3150 | Tolvsrød
Andersen Willy N AS | Harpunv. 1 | 3128 | Nøtterøy | 33 30 40 60 | 33 30 40 69
[NAME] | Galsrødveien 22 | 3220 | Sandefjord
Andersens Entreprenørservice | [NAME] 1 | 3222 | Sandefjord
[NAME] | Krokenveien 165 | 3275 | Svarstad
Andreassens Graver Service | Storg 17 | 3183 | Horten
Andrè Lunde | Steinsholt Søndre | 3277 | Steinsholt
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: DR. Nour Jihad

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | [NAME] to 25,000 | 0.05
 |  | [NAME] to 35,000 | 0.075
 |  | [NAME] to 45,000 | 0.1
 |  | Over (45000) | 0.15
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 30,000 to 40,000 | 0.05
 |  | [NAME] 50,000 | 0.075
 |  | [NAME] to 60,000 | 0.1
 |  | [NAME] to 70,000 | 0.125
 |  | Tier 5 - 70,001 to 80,000 | 0.15
 |  | Tier 6 - 80,001 to 90,000 | 0.175
 |  | Tier 7 -90,001 to 100,000 | 0.2
 |  | 2- Revenue on Dental Procedure After Deducting to fees then 5% Admin | 0.3
Doctto Calculation
 |  | Gross Revenue
 |  | Doctor Revenue Dental Procedure | 34318.37
 |  | Clinic Fees 5%
 |  | Dental Lab | 1098
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Docttos One day Surgery | 0
 |  | OR Fee | 0
 |  | Consumables (Implant 900) | 0
 |  | Clinic Fees 5%
 |  | ODS Net Revenue
 |  | Amount to be Paid | 5000
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 858778d1707332373-how-to-analyze-survey-text-data-multiple-answers-are-selected-expected-outcomeupdated
Sheet: Sheet1

Name | department | study IDs
[NAME] | Department Urology | 2022-0234
[NAME] | Department Cardiovascular | 123-4567
[NAME] | Department Cardiovascular | 3456-1234
[NAME] | Department Cardiovascular | 2020-1090
Mandy | Department Cardiovascular | 2020-0444
Mandy | Department Cardiovascular | 2020-0472
Mandy | Department Cardiovascular | 2023-1001
[NAME] | Department Cardiovascular
[NAME] | Department Myloma | 2022-0111;
[NAME] | Department Myloma | 2023-0444;
[NAME] | Department Myloma | 2019-0335
Celine | Department Lymphoma | 2024-2024
Celine | Department Investigational | 2019-0001
Celine | Department Investigational | nci0923434
Celine | Department Investigational | alliance000114