tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: MATH & SCIENCE TITLE IIB

Grant: |  | Title II-B Math & Science Partnerships
CFDA # |  | 84.366
GRANT NUMBER: |  | 5366
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 283C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - SEPTEMBER 30, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013
0030 | Adams 14 | 341140 |  |  |  |  |  |  |  |  | 114719 | 17223 | 26392 |  | 33630 | 52212 | 63037 | 15768 |  |  | 534
0070 | Westminster 50 | 108631 |  |  |  |  |  |  |  |  | 7229 |  |  |  | 7319
0180 | Adams-Arapahoe 28J | 242634 |  |  |  |  |  |  |  |  |  |  |  | 38884 | 14931 | 3964 | 6867 | 61808 | 3383 | 32786 | 5059
0880 | Denver Public Schools | 79644 |  |  |  |  |  |  |  | 41359 |  |  |  | 4651 |  | 4971 |  |  | 321
0910 | Eagle County RE 50 | 57650 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33565 |  | 24085
1010 | Colorado Springs 11 | 348221 |  |  |  |  |  |  |  |  |  | 18950 | 8456 | 8499 | 21646 | 24224 | 158940 | 20952
3120 | [NAME] 6 | 252246 |  |  |  |  |  |  |  | 19442 | 11924 | 38576 | 35239 | 12525 | 47330 | 79039 | 25291
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: Anastasia

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-09-02 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-09-02 00:00:00
Spreadsheet: 139079d1328061536-polynomial-regression-equation-in-a-formula-example
Sheet: Analysis

 | 1991 | 2000 | 2010 | 2020
Population | 1064166 | 1231209 | 1526324
 | Period | Equation
 | 1
 | 2
 | 3
 | 4
 | I need to work out the formula for this projection. I think it needs to use LINEST
 | I can get the value for 2020 by using the equation for the line, but need to apply it
 | to 100 lines of data. Doing some small area population projections.
Spreadsheet: 1303b488-5cb2-4987-b01f-dfe4cc4b6b12
Sheet: Enter Team Data Here

Team | OPR |  | Avg OPR |  | Team List | OPR | CP | RS as R1 | RS as R2 | RS as R3 | RS as B1 | RS as B2 | RS as B3 | QS as R1 | QS as R2 | QS as R3 | QS as B1 | QS as B2 | QS as B3 | RS | QS | QS+CP |  | Do not sort!
1 | 7.13566
1 | 4.21356
20 | 7.95181
20 | 0.15
67 | 41.9942
67 | 39.334
67 | 37.3498
67 | 33.4284
75 | 23.5868
75 | 9.35728
75 | 2.1336
100 | 10.0416
100 | 9.11385
126 | 21.6321
126 | 14.0645
128 | 10.1317
144 | 4.67715
144 | 2.21475
190 | 6.43509
190 | 0.174404
195 | 26.9899
195 | 14.6121
234 | 14.6423
234 | 7.81789
236 | 6.20997
245 | 24.7633
245 | 16.0765
245 | 14.9564
245 | 5.71807
246 | 6.31158
246 | 2.61018
247 | 15.0851
247 | 13.8858
247 | 12.6905
247 | 4.67942
272 | 20.8335
272 | 14.768
272 | 3.6327
359 | 37.1482
359 | 27.4008
369 | 16.6784
587 | 12.7634
587 | 2.81797
692 | 4.87404
692 | 3.67
716 | 23.0361
781 | 15.0746
781 | 9.53379
781 | 6.99094
839 | 13.7516
839 | 10.0625
956 | 1.98328
973 | 29.3312
973 | 17.7643
1014 | 7.5852
1018 | 3.40439
1058 | 4.1453
1058 | 3.79168
1114 | 38.9811
1114 | 31.3451
1114 | 27.1704
1218 | 36.1923
1218 | 32.3174
1218 | 26.2398
1218 | 23.1749
1261 | 13.9792
1261 | 8.32291
1306 | 8.27508
1311 | 24.0612
1311 | 16.8862
1403 | 21.9136
1403 | 16.6296
1403 | 12.5995
1458 | 8.41184
1458 | 1.63366
1504 | 13.0337
1504 | 11.5597
1504 | 10.7802
1592 | 20.9569
1592 | 19.4215
1642 | 8.54294
1642 | 0.786492
1647 | 11.7279
1647 | 9.2772
1647 | 8.76889
1676 | 29.4746
1676 | 29.3304
1676 | 27.4117
1676 | 17.9791
1710 | 4.76386
1736 | 13.358
1756 | 17.9337
1796 | 26.1683
1796 | 18.3239
1816 | 17.8218
1816 | 8.02035
1868 | 20.001
1868 | 6.7093
1875 | 5.57953
1902 | 18.9353
1902 | 13.0337
1987 | 14.7172
1987 | 12.4853
2022 | 11.524
2022 | 1.47637
2046 | 23.3716
2046 | 11.2509
2056 | 38.1207
2056 | 35.3464
2056 | 32.0631
2085 | 4.52226
2085 | 3.8319
2395 | 5.90143
2395 | 1.70012
2403 | 6.26804
2403 | 2.86481
2410 | 4.41746
2410 | 0.157341
2415 | 24.7991
2415 | 18.1301
2512 | 13.6332
2512 | 9.20288
2557 | 23.7105
2557 | 13.9775
2590 | 27.6526
2590 | 17.9671
2590 | 16.4038
2590 | 8.92459
2603 | 15.744
2603 | 9.75755
2614 | 22.78
2614 | 20.3796
2638 | 9.85456
2648 | 6.57676
2648 | 2.66937
2809 | 4.34489
2809 | 1.88446
2815 | 5.6025
2815 | 2.74796
2826 | 28.9502
2826 | 18.8047
2898 | 16.902
2898 | 5.09102
2949 | 15.5218
2949 | 11.6938
2974 | 9.13054
2974 | 7.22297
2996 | 25.5116
2996 | 8.74524
3008 | 12.8739
3008 | 4.54921
3015 | 18.0827
3015 | 6.57402
3081 | 2.81589
3128 | 1.45
3158 | 4.13905
3335 | 7.38891
3335 | 3.12291
3410 | 4.14189
3410 | 2.98107
3456 | 7.83173
3476 | 16.1193
3481 | 8.72044
3481 | 3.43136
3585 | 0.51
3634 | 3.98
3747 | 12.8102
3747 | 9.21477
3927 | 0.8
3927 | 2.67
3947 | 13.9384
3968 | 24.3622
3968 | 12.7565
3997 | 14.6018
3999 | 2.21986
4001 | 9.68445
4082 | 0.356705
4143 | 8.33447
4206 | 1.48768
4218 | 2.91707
4256 | 14.0181
4300 | 4.24457
4334 | 17.3855
4356 | 7.08663
4403 | 4.43047
2851 | 5.3
2851 | 14.4
Spreadsheet: 780612d1652612330-infill-blank-rows-in-a-list-title-sample
Sheet: Sheet1

What I have | What I have
Title 1 | Title 1
 | Title 1
 | Title 1
 | Title 1
Title 2 | Title 2
 | Title 2
 | Title 2
 | Title 2
 | Title 2
Title 3 | Title 3
Title 4 | Title 4
 | Title 4
 | Title 4
 | Title 4
 | Title 4
Title 5 | Title 5
Spreadsheet: 96587d1295964531-how-do-i-look-at-a-date-and-take-off-a-percentage-lookupissue
Sheet: Sheet1

T1
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
One | 456 | 654
Two |  |  | 423 | 32
Three |  |  |  |  | 456
Four |  |  |  | 235 |  | 211
Five | 123 | 456 | 21 | 321 | 12 | 213
T2
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
 | 0.018 | 0.02 | 0.014 | 0.014 | 0.023 | 0.01
T3
 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995
One | 456 | 654
Two |  |  | 417.078 | 31.552
Three
Four
Five
 | After and including year 1992 look at value in T1 and look at % in T2. Then take related percent off the value.
 | Example/expected answer in red.
Spreadsheet: ce1f5e60-c09e-4101-b227-7cb6609698b4
Sheet: Stats

Different ananlyses | NoBlast | NoBlastHits | NoMapping | NoAnnot | Annot | Total | Annot rate | Abbreviations in this file's tabs | Summarized in this tab
[NAME]-less-than50 | 0 | 11 | 225 | 72 | 1143 | 1451 |  | [NAME] | GO1
Gland-high-depth-no-less-than50 | 0 | 2 | 123 | 55 | 846 | 1206 |  | Gland | GO1
[NAME] | 0 | 3 | 158 | 76 | 274 | 511 |  | Gs | GO1
Group1 | 0 | 1 | 15 | 4 | 42 | 62 |  | [NAME] | GO2
Group2 | 0 | 0 | 5 | 0 | 18 | 23 |  | G2 | GO2
Group3 | 0 | 0 | 10 | 6 | 24 | 40 |  | G3 | GO2
Group5 | 0 | 0 | 0 | 0 | 4 | 4 |  | G5 | GO2
Group7 | 0 | 1 | 113 | 58 | 127 | 299 |  | G7 | GO2
Group9 | 0 | 0 | 8 | 2 | 29 | 39 |  | G9 | GO2
Group10 | 0 | 1 | 7 | 6 | 30 | 44 |  | G10 | GO2
[NAME] | 0 | 3 | 61 | 25 | 201 | 290 |  | Ctlg | GO2
Spreadsheet: 674212d1587721181-calculating-unique-names-book1
Sheet: Sheet1

Name
Name1 |  |  | Name1
Name1 |  |  | [NAME]
Name1 |  |  | Name3
Name1
Name1
Name1
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Name3
Name3
Name3
Name3
Name3
Name3
Spreadsheet: 49057d1248342127-keeping-track-of-payments-test
Sheet: J11

 |  |  |  | Job Name
 |  |  |  | Plot No./Type | [NAME]
 |  |  |  | Labour Times |  | Plot / Type | Labour price
 |  |  |  |  | hrs | Joists 1st floor
 |  |  |  |  | hrs | Joists 2nd floor
 |  |  |  |  | hrs | Roof
 |  |  |  |  | hrs | Low Level
 |  |  |  |  | hrs | Garage Roof
 |  |  |  |  | hrs | First Fix
 |  |  |  |  | hrs | External doors
 |  |  |  |  | hrs | Second Fix
 |  |  |  |  | hrs | Final fix
 |  |  |  |  | hrs | Snag
 |  |  |  |  | hrs | Total
 |  |  |  | Price Quote for plot/type | Total | Profit | Fixings
 |  |  |  | Joists 1st floor
 |  |  |  | Joists 2nd floor
 |  |  |  | Roof
 |  |  |  | Low Level
 |  |  |  | Garage Roof
 |  |  |  | First Fix
 |  |  |  | External doors
 |  |  |  | Second Fix
 |  |  |  | Final fix
 |  |  |  | Snag
 |  |  |  | Extra add on's (see notes)
 |  |  |  | Total
Notes
Job Name |  |  |  |  | Plot No.
Gr | 1st | 2nd | Qty | Item | labour total | my total | fixings | Time
67 |  |  |  | Joist & Decking TJI psm 1st floor
 |  |  |  | Total Joist 1st floor
 |  |  |  | Joist & Decking TJI psm 2nd floor
 |  |  |  | Total Joist 2nd floor
67 |  |  |  | Trusses psm
1 |  |  |  | Pediment [NAME]
 |  |  |  | [NAME]made Timber
 |  |  |  | [NAME]made Fibreglass
 |  |  |  | Attic Trusses psm
 |  |  |  | Velux
12 |  |  |  | Valley pr/m Trusses
 |  |  |  | Hip pr/m
 |  |  |  | Hand cut section
 |  |  |  | Total Roof
5.5 |  |  |  | Low Levels
 |  |  |  | Garage Roof
1 |  |  |  | Stairs -Straight Flight
 |  |  |  | Stairs -Kite over Garage wall
 |  |  |  | Stairs-Double kite
 |  |  |  | Stairs-Kite
3 |  |  |  | Block casing
3 | 8 |  |  | [NAME] casing
1 | 1 |  |  | Plasterboard catch noggins(per floor)
1 | 1 |  |  | Soil boxing
 |  |  |  | Metal Studding pm
10 | 35 |  |  | Studding pm
4 | 7 |  |  | Window board
 |  |  |  | Temp handrail
 |  |  |  | Protect Stairs
 |  |  |  | Total 1st Fix
2 |  |  |  | Front/Back Door & Frame & Lock
 |  |  |  | Fire door
6 | 7 |  |  | Standard door
60 | 75 |  |  | Skirting
1 | 3.5 |  |  | Pipe Boxings p/m
 |  |  |  | Furniture
 |  |  |  | Arcs
 |  |  |  | Drilling and cutting latches
 |  |  |  | Strings hand rails, spindles per flight
 |  |  |  | Total 2nd Fix
 | 2 |  |  | Bath/Shower Panel
 | 1 |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Door furniture
 |  |  |  | Intumescent strips
 |  |  |  | Re-hang doors
 |  |  |  | Total Final Fix
 |  |  |  | Snag price
Spreadsheet: 87827d1287683841-excel-2007-weekday-and-workday-november-schedule
Sheet: gant

Job | No of days | Start | End | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00 | 2010-11-30 00:00:00 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00 | 2010-12-03 00:00:00 | 2010-12-04 00:00:00 | 2010-12-05 00:00:00 | 2010-12-06 00:00:00 | 2010-12-07 00:00:00 | 2010-12-08 00:00:00 | 2010-12-09 00:00:00 | 2010-12-10 00:00:00 | 2010-12-11 00:00:00 | 2010-12-12 00:00:00 | 2010-12-13 00:00:00 | 2010-12-14 00:00:00
Task 1 | 4 | 2010-11-01 00:00:00 | 2010-11-08 00:00:00
Task 2 | 4 | 2010-11-09 00:00:00 | 2010-11-15 00:00:00
Task 3 | 4 | 2010-11-16 00:00:00 | 2010-11-22 00:00:00
Task 4 | 4 | 2010-11-23 00:00:00 | 2010-11-29 00:00:00
Task 5 | 15 | 2010-11-01 00:00:00 | 2010-11-23 00:00:00
Task 6 | 28 | 2010-11-12 00:00:00 | 2010-12-22 00:00:00
Task 7 | 8 | 2010-11-01 00:00:00 | 2010-11-12 00:00:00
Task 8
Task 9
Task 10
[NAME]
2010-11-05 00:00:00 | Diwali
2010-11-06 00:00:00 | Saturday
Spreadsheet: 97658d1296768091-finding-last-cell-that-matches-criteria-sample
Sheet: Tally

 | 2011 VACATION & CALL-OFF TALLY
 |  |  | Late |  |  | Vacation |  |  | 1/2 Day |  |  | Call-Off |  |  | NCNS
 |  | Marks | EA | UA | Total | EA | UA | Total | EA | UA | Total | EA | UA | Total | EA | UA | Total | EA's | Sub | Prior
 | Adam
 | [NAME]
 | [NAME]
Spreadsheet: 173452d1344555804-help-calculating-results-of-last-10-games-and-win-loss-tie-streak-in-standings-workbook-2003-04-nhl-season
Sheet: Division

 | Eastern Conference
 |  | Atlantic Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
 |  | Northeast Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
 |  | Southeast Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
 | Western Conference
 |  | Central Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
 |  | Northwest Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
 |  | Pacific Division | GP | W | L | T | Pts | GF | GA | [NAME] | Home | Away | RT | OT | Conf | Div | E #
 | 1
 | 2
 | 3
 | 4
 | 5
Spreadsheet: 886325d1736351342-index-and-match-formula-employee-review-test
Sheet: Jobs list

JakeW
Job Number | Customer Name | Part | Part Description | Closed Date | [NAME] | Qty Mfg | SCRAP | RUN BY | Act Hrs | [NAME] | % of Est
 | Volumetric Technologies | 34563 | 34563 Boss, threaded | 2024-10-24 00:00:00 | 6 | 6 | 2 | JakeW | 3.1 | 1.85 | 1.675675675675676
Spreadsheet: 153148d1335787253-transfer-data-to-workbooks-p
Sheet: Sheet1

PAYMENT LIST
NO | CUSTOMER | TTL | RECEPET NO | [NAME]. | DATE | CTN | AMOUNT | BANK ACCOUNT
1 | محمد |  |  | 5 | 2012-04-29 00:00:00 | 20 | 10000
2 | علي |  |  | 13 | 2012-04-29 00:00:00 | 15 | 5400
3 | احمد |  |  | 20 | 2012-04-30 00:00:00 | 1 | 20000
4
5
6
7
8
9
10
11
12
13
14
15
16
TTL |  |  |  |  |  |  | 35400
Spreadsheet: 872906d1719359939-summing-all-previous-numbers-with-criteria-sum-previous-example-tms
Sheet: Sheet1

2024-11-18 00:00:00 | 2024-05-12 00:00:00 | 2024-10-09 00:00:00 | 2024-11-18 00:00:00 | 2024-10-09 00:00:00
50 | 100 | 30 | 75 | 90
2024-11-18 00:00:00
 | n/a | n/a | 125 | n/a
Courtesy: | https://www.mrexcel.com/board/threads/summing-all-previous-numbers-with-criteria.1260809/
 | 2024-05-12 00:00:00 | 2024-10-09 00:00:00 | 2024-11-18 00:00:00 | 2024-10-09 00:00:00
50 | n/a | n/a | 125 | n/a
TMS solution based on Cubist's formula
Spreadsheet: 0de59d67-7dfe-4637-b472-de11f72f2d96
Sheet: Sheet1

Bid Tabulation Report from Carson City Purchasing & Contracts | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
[PHONE]
http://www.carson.org/index.aspx?page=998
Notice to Contractors Bid# 1011-154 C.D.B.G. ADA Complaint Restrooms at the Community Center
Date and Time of Bid Opening:  November 17, 2010 at 11:00 am
Description |  |  |  |  | Bidder # 4 |  | Bidder # 5 |  | Bidder # 6
 |  |  |  |  | F. Evans Construction, Inc. |  | Houston Smith Construction, Inc |  | Anchorage Construction Management
BONDING Provided, $, %, or no |  |  |  |  | 0.05 |  | 0.05
PREFERENTIAL [NAME]
BIDDER acknowledges receipt addendums |  |  |  |  | 2 |  | 2
Description |  | Sched Value | Unit |  | Unit price | Total price | Unit price | Total Price | Unit Price | Total Price
Schedule A:
1 | Mobilization | 1 |  | LS | 2000 | 2000 | 15000 | 15000 | 11815 | 11815
2 | Restrooms | 1 |  | LS | 97000 | 97000 | 107786.65 | 107786.65 | 106332 | 106332
Sub-total of Schedule A: |  |  |  |  | 99000 |  | 122786.65 |  | 118147
12155.75
3 | Room #6 Cleaner, door, finishes and electrical | 1 |  | LS | 5000 | 5000 | 3799.6 | 3799.6 | 12155.75 | 12155.75
4 | Toilet Partitions | 1 |  | LS | 6300 | 6300 | 6589.94 | 6589.94 | 10067.71 | 10067.71
5 | Painting | 1 |  | LS | 2800 | 2800 | 2612.9 | 2612.9 | 9446.34 | 9446.34
6 | Ceramic Tiles | 1 |  | LS | 7100 | 7100 | 6729.94 | 6729.94 | 10659 | 10659
Sub-total of Schedule B: |  |  |  |  | 21200 |  | 19732.38 |  | 42328.8
Sub-total of Schedule A: |  |  |  |  | 99000 |  | 122786.65 |  | 118147
Sub-total of Schedule B: |  |  |  |  | 21200 |  | 19732.38 |  | 42328.8
Total Bid Price |  |  |  |  | 120200 |  | 142519.03 |  | 160475.8
Total Bid Price written in words? y/n |  |  |  |  | Yes |  | Yes |  | Yes
Bidder Information provided? y/n |  |  |  |  | Yes |  | Yes |  | Yes
Sub Contractors listed? y/n or none |  |  |  |  | Yes |  | Yes |  | Yes
Bid Document executed? y/n |  |  |  |  | Yes |  | Yes |  | Yes
END OF DOCUMENT
Spreadsheet: 707521d1607334170-combine-duplicated-pivot-data-combine-pivot-table-1-
Sheet: Sheet1

Row Labels | Status 1 | Status 2 |  | Result | Status 1 | Status 2
0001 - City A | 1 | 1 |  | 0001 - City A | 1 | 9
0003 - City B |  | 1 |  | 0003 - City B |  | 3
0005 - City C | 3 | 1
0007 - City D |  | 1
0009 - City E |  | 1
0003 - City B |  | 2
0001 - City A |  | 8
0014 - City F |  | 5
0016 - City G | 2 | 6
Spreadsheet: 213272d1360418067-help-merge-sheets-data-deep
Sheet: CONSOLIDATION

 |  | TIN |  |  | UIC |  |  | TRG
 |  | AD | SD | TD | AD | SD | TD | AD | SD | TD
Spreadsheet: 673183d1587231047-consolidate-text-from-several-cells-into-1-cell-200418-music-for-sorting
Sheet: Sheet1

TITLE | GROUPING | ALL TIMES | DAILY | INSTRUMENTAL | DANCE | 2 LONG | SOUNDTRACK | 2 SHORT | WOWWWW
25 Or 6 To 4 |  | x |  |  |  | x
25 To Life |  | x |  | x |  |  | x |  | x
50 Ways To Leave Your Lover |  | x | x |  |  |  |  | x
80s Mercedes |  | x |  |  | x
[NAME] | Daily Instrumental 2 long |  | x | x |  | x
All My Tears | Dance |  |  |  | x
Bizet: Carmen - Act 2: [NAME], [NAME] |  | x |  |  |  |  |  | x
bruch no 1 in g minor |  |  | x |  |  |  |  |  | x
By [NAME] ([NAME]) |  |  |  | x
Calling Elvis |  |  |  |  | x
Carmela With Paco Ibanez - De Terciopelo Negro |  |  | x |  |  |  |  |  | x
Chacha Slide |  |  | x |  | x
Chiquitita |  |  |  | x
Dear Ould Ireland |  |  | x |  |  | x
Dirty Old Town
Don't Let Me Be Misunderstood |  | x |  |  | x
[NAME] |  |  | x | x |  |  | x
El Arriero |  |  |  |  |  |  |  | x
El Preso Numero Nueve |  |  |  |  | x
Elifelet |  |  |  |  |  | x |  |  | x
Elle Était Si Jolie |  | x | x |  |  |  |  |  | x
Spreadsheet: 836369d1689315154-remove-duplicated-in-textjoin-formula-tfs-cr-in-s03-vs-new-wp-and-takt-2023-07-10-example
Sheet: TFS 230710

 | TFS |  |  |  |  | BASELINE |  | Comments to changes |  | SFI |  |  |  |  |  | Oveview
No | ID | Work Item Type | Title 1 | Title 2 | WP | BASELINE TAKT | New WP | Comment Takt | CO level comment | WP started | Released? | PS Responsible |  |  |  | T1 - no split
1 | 196769 | [NAME] | X2 / VT1-2005 / Jumper cable between PH and first coach damaged during operation -PS
2 | 196770 | Task |  | WP133A / Jumper cable between PH and first coach damaged during operation | WP133A | 1 |  | New WP no. | OK | No |  | [NAME]
3 | 198268 | Task |  | 3DX-SRMS / Jumper cable between PH and first coach damaged during operation | 3DX-SRMS
4 | 199668 | Task |  | WP133_PRE / Jumper cable between PH and first coach damaged during operation | WP133_PRE | 6 |  | New WP no. | Jocke skat titta på att införa [NAME] efter sommaren | 2023-05-05 00:00:00 | Yes | [NAME]
5 | 200693 | Task |  | WP133B / Jumper cable between PH and first coach damaged during operation | WP133B | 1 |  | New WP no. | OK | No |  | [NAME]
6 | 200694 | Task |  | WP133C / Jumper cable between PH and first coach damaged during operation | WP133C | 1 |  | New WP no. | OK | No |  | [NAME]
6 | 200947 | Task |  | WP132 / Jumper cable between PH and first coach damaged during operation | WP132 | 1 |  | New WP no. | Ny task skapad 2023-07-13 | No |  | [NAME]
7 | 196823 | [NAME] | Passenger coaches / SJ / Update of retrofit instruction for interior doors (SJ0161) -PS
8 | 196824 | Task |  | WP176 / Update of retrofit instruction for interior doors (SJ0161) | WP176
9 | 198267 | Task |  | 3DX-SRMS / Update of retrofit instruction for interior doors (SJ0161) | 3DX-SRMS
10 | 197077 | [NAME] | URB2 / Swedfix 1833 / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled -PS
11 | 197078 | Task |  | PM4114 / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled | PM4114
12 | 198279 | Task |  | 3DX-SRMS / Fästet ovanför [NAME] i bistron behöver förlängas i höjdled | 3DX-SRMS
13 | 197193 | [NAME] | URB2 / ### / Location of temperature sensor GT10 -PS
14 | 197194 | Task |  | PM4077 / Location of temperature sensor GT10 | PM4077
15 | 198276 | Task |  | 3DX-SRMS / Location of temperature sensor GT10 | 3DX-SRMS
16 | 199243 | Task |  | PM4042 / Location of temperature sensor GT10 | PM4042
17 | 199245 | Task |  | PM4120 / Location of temperature sensor GT10 | PM4120
18 | 199246 | Task |  | PM4139 / Location of temperature sensor GT10 | PM4139
Spreadsheet: 67030d1267667725-indexing-indexing
Sheet: Sheet1

Name | Hired | Date |  | 2 | Names | Hired Date
[NAME] | Yes | 2009-12-02 00:00:00 |  | 1 | [NAME] | 2009-12-02 00:00:00
[NAME] | No |  |  | 2 | [NAME] | 2010-01-01 00:00:00
[NAME] | Yes | 2010-01-01 00:00:00 |  | 3
 |  |  |  | 4
 |  |  |  | 5
 |  |  |  | 6
 |  |  |  | 7
 |  |  |  | 8
 |  |  |  | 9
 |  |  |  | 10
 |  |  |  | 11
 |  |  |  | 12
 |  |  |  | 13
 |  |  |  | 14
 |  |  |  | 15
 |  |  |  | 16
 |  |  |  | 17
 |  |  |  | 18
Spreadsheet: 771729d1646820313-cohort-for-app-downloads-calculate-use-of-app-3-months-per-year-every-year-cohort-ap-users-excel-2013
Sheet: Sheet1

App users |  |  | This is an example with CHURN. However what I need is that the first download in jun 22, is only active for 3 months per year.
 |  | Churn | In the rows jun 22 and jul 22 I have marked the 9 month which should disapear. And reapear in the following year. To show you what I mean.
 |  | 0
Mthly New |  |  | 1000 | 2000 | 3000 | 4000 | 5000 | 6000 | 7000 | 8000 | 9000 | 10000 | 11000 | 12000 | 13000 | 14000 | 15000 | 16000 | 17000 | 18000 | 19000 | 20000 | 21000 | 22000 | 23000 | 24000 | 25000 | 26000 | 27000 | 28000 | 29000 | 30000 | 31000 | 32000 | 33000 | 34000 | 35000 | 36000 | 37000 | 38000 | 39000 | 40000 | 41000 | 42000 | 43000 | 44000 | 45000 | 46000 | 47000 | 48000 | 49000 | 50000 | 51000 | 52000 | 53000 | 54000 | 55000 | 56000 | 57000 | 58000
Cohort
2022-11-01 00:00:00
2022-12-01 00:00:00
2023-01-01 00:00:00
2023-02-01 00:00:00
2023-03-01 00:00:00
2023-04-01 00:00:00
2023-05-01 00:00:00
2023-06-01 00:00:00
2023-07-01 00:00:00
2023-08-01 00:00:00
2023-09-01 00:00:00
2023-10-01 00:00:00
2023-11-01 00:00:00
2023-12-01 00:00:00
2024-01-01 00:00:00
2024-02-01 00:00:00
2024-03-01 00:00:00
2024-04-01 00:00:00
2024-05-01 00:00:00
2024-06-01 00:00:00
2024-07-01 00:00:00
2024-08-01 00:00:00
2024-09-01 00:00:00
2024-10-01 00:00:00
2024-11-01 00:00:00
2024-12-01 00:00:00
2025-01-01 00:00:00
2025-02-01 00:00:00
2025-03-01 00:00:00
2025-04-01 00:00:00
2025-05-01 00:00:00
2025-06-01 00:00:00
2025-07-01 00:00:00
2025-08-01 00:00:00
2025-09-01 00:00:00
2025-10-01 00:00:00
2025-11-01 00:00:00
2025-12-01 00:00:00
2026-01-01 00:00:00
2026-02-01 00:00:00
2026-03-01 00:00:00
2026-04-01 00:00:00
2026-05-01 00:00:00
2026-06-01 00:00:00
2026-07-01 00:00:00
2026-08-01 00:00:00
2026-09-01 00:00:00
2026-10-01 00:00:00
2026-11-01 00:00:00
2026-12-01 00:00:00
2027-01-01 00:00:00
2027-02-01 00:00:00
2027-03-01 00:00:00
Total Users