tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9c0baecf-0940-4908-82f4-ad3fa2940b2f
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
42366996 | 2014-07-19 17:11:57 | AXIS | 1 | 7 | 5 | 500687 | player500687 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
42367203 | 2014-07-19 17:30:02 | ALLIES | 1 | 7 | 4 | 500687 | player500687 | 7597 | eastern | 1941-10-18 | 1941-10-18 | Gates of Moscow | Aux portes [NAME]
Spreadsheet: 722309d1615192156-trying-to-match-all-duplicate-values-book1-20-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Data set
Access type
Group access 1 |  |  |  |  |  |  |  |  | Kat | Group access 1 | Group access 2 | Group access 3
Group access 2 |  |  |  |  |  |  |  |  | [NAME] | Group access 3
Group access 3 |  |  |  |  |  |  |  |  | [NAME] | Group access 2 | Group access 3
Group access 4 |  |  |  |  |  |  |  |  | [NAME] | Group access 1
Spreadsheet: tracy_geaccone__40573__EA Alloc to Other BUs - Support
Sheet: Fin Ops Detail

Financial Operations
Allocations to Other Business Units
2002 Plan
 |  | Shared |  | Faith |  | [NAME] |  | [NAME] |  | [NAME] |  | Georganne & Susan |  | Elaine |  | Hope |  | Total | % | FTEs | [NAME] | Total Fin Ops | % | FTEs | Bonus | Total Fin Ops incl Bonus | %
Total Gross Expense |  | 246721 |  | 1260837 |  | 1511267 |  | 816537 |  | 4169104 |  | 1184899 |  |  |  | 1449285 |  |  |  |  | 1211826 |  |  |  | 2788000 |  |  | 164
EPI |  | 11565 |  | 39343 |  |  |  |  |  |  |  |  |  | 49103 |  | 739599
ESA |  |  |  |  |  |  |  |  |  |  |  | 14105
EBS |  | 17990 |  | 39343 |  |  |  |  |  |  |  | 42316 |  | 311947
EWS |  |  |  | 153439 |  |  |  |  |  |  |  | 28211 |  | 197007
[NAME] |  | 61680 |  | 38360 |  |  |  |  |  |  |  | 97451 |  | 0
EGM |  | 46260 |  | 45245 |  |  |  |  |  |  |  |  |  | 168331
Europe |  |  |  | 25573 |  |  |  |  |  |  |  |  |  | 0
EIM |  |  |  | 25573 |  |  |  |  |  |  |  |  |  | 168331
ENW |  |  |  | 25573 |  |  |  |  |  |  |  |  |  | 57259
EEOS |  |  |  | 9836 |  |  |  |  |  |  |  |  |  | 0
Xcelerator |  |  |  | 20655 |  |  |  |  |  |  |  |  |  | 0
Total Allocated to Other BU's
Net Expense to ENA
Spreadsheet: 43901d1242555572-average-column-depending-on-values-in-another-column-forex-journal-template
Sheet: JANTOTALS

DATE |  | WINS | LOSSES | WIN AMOUNT | LOSS AMOUNT | Win % | Loss % | GROSS P/L | PIPS | DEPOSITS & WITHDRAWALS
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
MON
TUE
WED
THU
FRI
Week Sub Total
 |  | WINS | LOSSES | WIN $ | LOSE $ | WIN % | LOSE % | ACCOUNT $ TOTAL | PIP TOTAL | TOTAL $ IN/OUT
TOTALS
 |  | ACTUAL WIN/LOSS $ (MONTH) |  |  |  |  |  | AV. PROFIT $/PIP | AV. PIPS/DAY | AV. LOT [NAME] (MONTHLY)
Spreadsheet: 876381d1723056855-table-copied-to-two-sheets-shows-correct-on-one-and-incorrect-on-the-other-table-copy-test
Sheet: Sheet1

DATE | MONTH
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
INFORMATION FOR SHEET 2 AND 3 ARE BEING PULLED FROM HERE.
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 15b

Product1 | HY3 | IG | Other | TOTAL
Index Tranche | 631 | 109 | 162 | 902
Index | 48758 | 121435 | 121655 | 291848
Asia | . | . | 136 | 136
Europe | . | . | 119373 | 119373
North America | 48758 | 121435 | 50 | 170243
Other | . | - | 2096 | 2096
OTHER* | - | - | 32669 | 32669
TOTAL | 49389 | 121544 | 154486 | 325419
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: vkaminski__40853__ModelingProject
Sheet: MeanReversionJump

 | GBM + Jump + Mean Reversion Model
 | Input Parameters
 | S0 | 20 |  | f | 250
 | a | 2000 |  | k | 0
 | s | 0.3 |  | g | 1.2
 | Dt |  | (hourly) | Sbar | 20
 | dS = a(r-d-lnS)Sdt + sSdz+kSdq
 | St = St-1 * exp[(a (ln(Sbar) - lnS) - 0.5s2)Dt + (se1(Dt)0.5)+(k + ge2)(ui>fDt)]
 | Time | e1 | e2 | u | Condition | Return | St
 | 0
Spreadsheet: 121587d1316182917-graphing-scale-sample_graph_scale
Sheet: Sheet1

 |  | County | Revenue
 |  | Cook County - #1 | 1768421.310000001
 |  | DuPage County - #2 | 11416.74
 |  | Kane County - #3 | 5868.870000000001
 |  | Lake County - #4 | 3290.08
 |  | Will County - #5 | 1088.04
 |  | McHenry County - #6 | 875.76
 |  | Bureau County - #7 | 552.15
 |  | Boone County - #8 | 480
 |  | Kendall County - #9 | 326.75
 |  | Winnebago County - #10 | 200.09
 |  | Woodford County - #11 | 0
 |  | Williamson County - #12 | 0
 |  | Whiteside County - #13 | 0
 |  | White County - #14 | 0
 |  | Wayne County - #15 | 0
 |  | Washington County - #16 | 0
 |  | Warren County - #17 | 0
 |  | Wabash County - #18 | 0
 |  | Vermilion County - #19 | 0
 |  | Union County - #20 | 0
Spreadsheet: 786149d1657014390-football-league-modelling-formula-to-return-result-of-last-5-games-football-league-last-5-games-v2
Sheet: League table

 |  | FOOTBALL LEAGUE
 |  | Date
 |  | Matchday |  | 22
 |  | Qualification |  | 0.4
 |  | # |  | Players | [NAME] |  |  |  |  | Goal Average |  |  | Last 5 Games |  |  |  |  | Ranking
 |  |  |  |  | P | W | D | L | FF | GF | GA | [NAME] | 1 | 2 | 3 | 4 | 5 | Qual? | Pts | Win % | PPG
 |  | 1
 |  | 2
 |  | 3
 |  | 4
 |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20
 |  | 21
 |  | 22
 |  | 23
 |  | 24
 |  | 25
Spreadsheet: 85457d1285583306-match-function-for-non-unique-entries-list-rows-for-particular-col-a-value
Sheet: Sheet1

Name | Count | B
A | 1 | 3
B | 2 | 10
C | 2
D | 3
E | 2
F | 6
A | 3
G | 5
B | 2
C | 1
Spreadsheet: 750582d1633534228-combine-multiple-columns-into-1-excel-data-example
Sheet: Sheet1

[NAME] |  |  |  |  |  |  |  | Desired Data Output
List A | Value | List B | Value | List C | Value |  |  | Total List | Value
4 | 2 | 56 | 3 | 98 | 4 |  |  | 4 | 2
5 | 2 | 57 | 3 | 99 | 4 |  |  | 5 | 2
6 | 2 | 58 | 3 | 100 | 4 |  |  | 6 | 2
7 | 2 | 59 | 3 | 101 | 4 |  |  | 7 | 2
8 | 2 | 60 | 3 | 102 | 4 |  |  | 8 | 2
9 | 2 | 61 | 3 | 103 | 4 |  |  | 9 | 2
10 | 2 | 62 | 3 | 104 | 4 |  |  | 10 | 2
11 | 2 | 63 | 3 | 105 | 4 |  |  | 11 | 2
12 | 2 | 64 | 3 | 106 | 4 |  |  | 12 | 2
13 | 2 | 65 | 3 | 107 | 4 |  |  | 13 | 2
14 | 2 | 66 | 3 | 108 | 4 |  |  | 14 | 2
15 | 2 | 67 | 3 | 109 | 4 |  |  | 15 | 2
16 | 2 | 68 | 3 | 110 | 4 |  |  | 16 | 2
17 | 2 | 69 | 3 | 111 | 4 |  |  | 17 | 2
18 | 2 | 70 | 3 | 112 | 4 |  |  | 18 | 2
19 | 2 | 71 | 3 | 113 | 4 |  |  | 19 | 2
20 | 2 | 72 | 3 | 114 | 4 |  |  | 20 | 2
21 | 2 | 73 | 3 | 115 | 4 |  |  | 21 | 2
22 | 2 | 74 | 3 | 116 | 4 |  |  | 22 | 2
23 | 2 | 75 | 3 | 117 | 4 |  |  | 23 | 2
24 | 2 | 76 | 3 | 118 | 4 |  |  | 24 | 2
25 | 2 | 77 | 3 | 119 | 4 |  |  | 25 | 2
26 | 2 | 78 | 3 | 120 | 4 |  |  | 26 | 2
 |  |  |  |  |  |  |  | 56 | 3
 |  |  |  |  |  |  |  | 57 | 3
 |  |  |  |  |  |  |  | 58 | 3
 |  |  |  |  |  |  |  | 59 | 3
 |  |  |  |  |  |  |  | 60 | 3
 |  |  |  |  |  |  |  | 61 | 3
 |  |  |  |  |  |  |  | 62 | 3
 |  |  |  |  |  |  |  | 63 | 3
 |  |  |  |  |  |  |  | 64 | 3
 |  |  |  |  |  |  |  | 65 | 3
 |  |  |  |  |  |  |  | 66 | 3
 |  |  |  |  |  |  |  | 67 | 3
 |  |  |  |  |  |  |  | 68 | 3
 |  |  |  |  |  |  |  | 69 | 3
 |  |  |  |  |  |  |  | 70 | 3
 |  |  |  |  |  |  |  | 71 | 3
 |  |  |  |  |  |  |  | 72 | 3
 |  |  |  |  |  |  |  | 73 | 3
 |  |  |  |  |  |  |  | 74 | 3
 |  |  |  |  |  |  |  | 75 | 3
 |  |  |  |  |  |  |  | 76 | 3
 |  |  |  |  |  |  |  | 77 | 3
 |  |  |  |  |  |  |  | 78 | 3
 |  |  |  |  |  |  |  | 98 | 4
 |  |  |  |  |  |  |  | 99 | 4
 |  |  |  |  |  |  |  | 100 | 4
 |  |  |  |  |  |  |  | 101 | 4
 |  |  |  |  |  |  |  | 102 | 4
 |  |  |  |  |  |  |  | 103 | 4
 |  |  |  |  |  |  |  | 104 | 4
 |  |  |  |  |  |  |  | 105 | 4
 |  |  |  |  |  |  |  | 106 | 4
 |  |  |  |  |  |  |  | 107 | 4
 |  |  |  |  |  |  |  | 108 | 4
 |  |  |  |  |  |  |  | 109 | 4
 |  |  |  |  |  |  |  | 110 | 4
 |  |  |  |  |  |  |  | 111 | 4
 |  |  |  |  |  |  |  | 112 | 4
 |  |  |  |  |  |  |  | 113 | 4
 |  |  |  |  |  |  |  | 114 | 4
 |  |  |  |  |  |  |  | 115 | 4
 |  |  |  |  |  |  |  | 116 | 4
 |  |  |  |  |  |  |  | 117 | 4
 |  |  |  |  |  |  |  | 118 | 4
 |  |  |  |  |  |  |  | 119 | 4
 |  |  |  |  |  |  |  | 120 | 4
Spreadsheet: 0b6336e5-daae-427d-a480-5233b1e85818
Sheet: Data

 | 2007-08-01 00:00:00 | 2007-09-01 00:00:00 | 2007-10-01 00:00:00 | 2007-11-01 00:00:00 | 2007-12-01 00:00:00 | 2008-01-01 00:00:00 | 2008-02-01 00:00:00 | 2008-03-01 00:00:00 | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00 | 2009-04-01 00:00:00 | 2009-05-01 00:00:00 | 2009-06-01 00:00:00 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00
Items to date | 150 | 153 | 163 | 201 | 217 | 230 | 240 | 252 | 287 | 331 | 339 | 348 | 365 | 380 | 397 | 450 | 451 | 495 | 644 | 974 | 1076 | 1361 | 1524 | 1730 | 1887 | 2182 | 2511 | 2597 | 2885
Number of new items | X
Percent change | X
Downloads to date | 5029 | 6657 | 8626 | 10405 | 12004 | 13900 | 15916 | 18446 | 21339 | 25062 | 29031 | 33509 | 37137 | 41158 | 45640 | 50226 | 53908 | 58062 | 62237 | 68560 | 75704 | 82737 | 89647 | 98271 | 107420 | 118209 | 133608 | 148800 | 161375
Downloads for month
Percent change | X
Total number of participants |  |  | 113 | 135 | 140 | 143 | 156 | 161 | 196 | 226 | 226 | 231 | 238 | 248 | 255 | 269 | 292 | 326 | 350 | 386 | 430 | 491 | 577 | 650 | 711 | 764 | 790 | 848 | 881
Number of new participants | X | X | X |  | x
Percent change | X | x | x | x | x
Selected Works pages to date | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | 43 | 55 | 59 | 65 | 72 | 81 | 83 | 85 | 89 | 91 | 122 | 123
Number of new SWPs | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x
Number of ETDs | 59 | 60 | 63 | 64 | 75 | 75 | 76 | 77 | 94 | 142 | 155 | 158 | 162 | 168 | 173 | 180 | 196 | 215 | 230 | 245 | 300 | 314 | 319 | 377 | 410 | 433 | 454 | 549 | 576
Percent of ETDs to the whole
ETD downloads to date | 3674 | 4817 | 6152 | 7322 | 8254 | 9211 | 10398 | 11841 | 13534 | 15886 | 18504 | 21415 | 23207 | 25609 | 28254 | 30901 | 32970 | 35403 | 37532 | 40508 | 43707 | 47188 | 50312 | 54149 | 56996 | 60525 | 65577 | 71925 | 76246
Percent of downloads that are ETDs
Downloads per item
 | Number for months represent total AT THE END OF THE MONTH
Spreadsheet: b86e337f-d89e-4df2-be7c-d7f22374f004
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-06-23 09:33:54.610000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.875 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.75 | 101.502 | 101.377 | 101.252 | 100.877
4.625 | 100.835 | 100.71 | 100.585 | 100.21 |  | Note: | Refer To Price [NAME]
4.5 | 100.32 | 100.195 | 100.07 | 99.695 |  |  | For all Price Adjs
4.375 | 99.711 | 99.586 | 99.461
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
4.125 | 101.747 | 101.622 | 101.497 | 101.122
4 | 101.395 | 101.27 | 101.145 | 100.77
3.875 | 100.991 | 100.866 | 100.741 | 100.366
3.75 | 100.426 | 100.301 | 100.176 | 99.801
3.625 | 99.312 | 99.187 | 99.062
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-07-07 09:33:54.610000
30 DAY | 2011-07-22 09:33:54.610000
45 DAY | 2011-08-06 09:33:54.610000
60 DAY | 2011-08-21 09:33:54.610000
90 DAY | 2011-09-20 09:33:54.610000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 83511d1283467402-formula-across-2-worksheets-results-in-0-in-blank-cells-book1
Sheet: Sheet2

Priority: | Job #: | Job name: | Supervisor: | Technician:
HIGH | 1234 | ABC & Co | [NAME] | [NAME]
LOW | 1235 | Smiths | [NAME] | [NAME]
MEDIUM | 1236 | Seven Inc | [NAME] | [NAME]
0 | 0 | 0 | 0 | 0
Spreadsheet: 879986d1727598516-using-xlookup-with-2-criteria-to-search-in-table-to-return-results-problem
Sheet: vxlookup

[NAME] | Type | Jan | Feb | Mar | Q1 | Payout
[NAME] | Budget | 30 | 40 | 50
Role | Actual | 30 | 50 | 71
Sales | Perf
[NAME] | Budget | 10 | 15 | 20
Role | Actual
Tech | Perf
[NAME] | Budget
Role | Actual
Manager | Perf
Spreadsheet: 829991d1684602835-excel-formula-to-calculate-tax-recoupment-recoupment
Sheet: Sheet1

 | I Kindly asking for a formula to calculate tax recoupment and scrapping allowance as shown in column I
 |  |  |  |  |  |  |  | [NAME].
 |  | Year of purchase | Cost | `Book value | ITV | Profit | Proceeds
 | Caterpillar | 2017 | 5000 | 0 | 0 | 34600 |  | 5000
 | Utility truck | 2019 | 3000 | 1200 | 750 | 6900 |  | 2250
 | Computer equipment | 2017 | 1000 | 0 | 0 | 800 |  | 800
 | Compressor | 2019 | 500 | 300 | 150 | -200 |  | -50
 | Total
Spreadsheet: 825394d1681296601-transferring-data-from-one-tab-into-another-mini-table-assessment-look-up
Sheet: UPDATES

Colleague/Employee ID | Surname | Forename | Audiometry surveillance | Last audiometry (Date) | Respiratory surveillance | Last respiratory (Date) | Skin surveillance | Last skin (Date) | [NAME] | HAVS T3 | [NAME] (Date) | Last HAVS T3 (Date) | [NAME] | Last confined space (Date) | Wellbeing | Last Wellbeing (Date)
420284 | [NAME] | Wayne | Y | 2019-11-09 00:00:00 | Y | 2022-05-17 00:00:00 | Y | 2022-05-17 00:00:00 | y |  | 2021-05-28 00:00:00 |  |  |  | y | 2022-03-04 00:00:00
421114 | Adamms | [NAME]
430437 | Adams | [NAME]
414034 | ADKIN | [NAME]
428271 | Aitken | [NAME]
417187 | Alker | [NAME]
220956 | [NAME] | Stephen
406967 | [NAME] | [NAME]
400570 | [NAME] | [NAME]
Spreadsheet: holden_salisbury__12322__Enron prepayment 1-3-02
Sheet: Sheet1

[NAME]
Public Service Company of New Mexico
January 3, 2002
Power Sale to Enron Power Marketing
Prepayment Calculation
Deal discription: For the dates 1/8/02 through 1/14/02 PNM sells to Enron 75MW on-peak @ $26.00 and 75MW off-peak @ 17.50
 | Date | On-Peak Hrs |  | Off-Peak Hrs |  | On-Peak $ |  | Off-Peak $
 | 2002-01-08 00:00:00 | 16 |  | 8
 | 2002-01-09 00:00:00 | 16 |  | 8
 | 2002-01-10 00:00:00 | 16 |  | 8
 | 2002-01-11 00:00:00 | 16 |  | 8
 | 2002-01-12 00:00:00 | 16 |  | 8
 | 2002-01-13 00:00:00 | 0 |  | 24
 | 2002-01-14 00:00:00 | 16 |  | 8
 |  |  |  |  | Totals
Amount of required prepayment $281,700.00
Spreadsheet: 736559d1623743561-output-only-column-rows-where-adjacent-column-rows-are-not-blank-book1
Sheet: Sheet1

 | Item 1
 | Item 2
3 | Item 3
 | Item 4
 | Item 5
 | Item 6
 | Item 7
 | Item 8
 | Item 9
8 | Item 10
 | Item 11
 | Item 12
 | Item 13
 | Item 14
 | Item 15
 | Item 16
 | Item 17
 | Item 18
1 | Item 19
 | Item 20
 | Item 21
 | Item 22
 | Item 23
 | Item 24
 | Item 25
 | Item 26
 | Item 27
 | Item 28
5 | Item 29
 | Item 30
 | Item 31
 | Item 32
 | Item 33
 | Item 34
 | Item 35
 | Item 36
 | Item 37
 | Item 38
Spreadsheet: 216737d1361874576-find-data-betwwen-two-dates-datest
Sheet: Sheet2

2012-11-02 00:00:00 | Suppose I Give Assigned Date as 11/2/2012
2013-02-19 00:00:00 | Suppose I Give Closed Date as 2/5/2012
Incident No. | Description | Assignee Individual | Assigned date | Closed date | Acknowledment time(mins) | Resolution time (hrs) | Effots spent | Resolved within  SLA
 |  |  |  |  |  |  |  |  |  | 32680254 | AAAA | A | 41215 | 41215 | 5.4 | 0.74 | 0.65 | Y
 |  |  |  |  |  |  |  |  |  | 33114036 | BBBBB | B | 41245.11165509259 | 41245.13618055556 | 0.03222222222 | 0.6194444444 | 0.5872222222 | Y
 |  |  |  |  |  |  |  |  |  | 33905199 | CCCCC | C | 41302.82412037037 | 41302.86300925926 | 0.01638888889 | 0.9494444444 | 0.8847222222 | Y
 |  |  |  |  |  |  |  |  |  | 33991266 | DDDDD | D | 41308.2690625 | 41308.39582175926 | 0.1113888889 | 3.153333333 | 3.041944444 | Y
 |  |  |  |  |  |  |  |  |  | 33987989 | EEEEE | E | 41307.78501157407 | 41307.87902777778 | 0.03555555556 | 2.291666666 | 0.7191666667 | Y
 |  |  |  |  |  |  |  |  |  | 33986990 | GGGGG | F | 41307.58538194445 | 41307.63405092592 | 0.07138888889 | 1.239166667 | 1.167777778 | Y
 |  |  |  |  |  |  |  |  |  | 34033456 | HHHHH | G | 41310.83681712963 | 41310.87174768518 | 0.1133333333 | 0.9513888889 | 0.8380555556 | Y
IT should give result as above shown from Sheet1
Spreadsheet: 781506d1653385302-sum-average-and-median-time-difference-between-time-stamps-excel-time-stamps
Sheet: Sheet1

Time Stamp 1 |  | Time Stamp 2
2022-05-19 16:45:13 |  | 2022-05-23 09:18:39
Remove seconds: |  | Remove seconds:
Start time: | Time difference: | End time:
2022-05-19 16:45:13 |  | 2022-05-23 09:18:39
2022-02-11 01:15:13 |  | 2022-05-02 18:12:39
2022-01-15 12:56:13 |  | 2022-05-19 22:38:39
2022-04-29 18:13:13 |  | 2022-05-11 05:41:39
2022-03-05 23:02:13 |  | 2022-05-06 15:02:39
2022-01-24 19:51:13 |  | 2022-05-17 20:37:39
2022-04-16 05:06:13 |  | 2022-05-04 21:25:39
2022-02-07 12:26:13 |  | 2022-05-13 01:56:39
2021-12-27 17:39:13 |  | 2022-05-08 11:15:39
SUM =
AVERAGE =
MEDIAN =
Spreadsheet: 455583d1460408246-matching-customers-with-sales-reps-xlf-index-match-sales-reps-to-clients
Sheet: Sheet1

Customer Name | Invoice Date | State | AM |  |  |  | CUSTOMER NAME | AM
NAVITUS HEALTH SOLUTIONS | 02/24/2015 | WI | JOSH |  |  |  | NAVITUS HEALTH SOLUTIONS | JOSH
STARR COMPANIES | 03/04/2016 | IL | 0 |  |  |  | STARR COMPANIES
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | KRISTOFER  (1879) |  |  |  | UNIVERSITY OF ALABAMA | KRISTOFER  (1879)
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | KRISTOFER  (1879) |  |  |  | MEDICAL SECURITY CARD
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | KRISTOFER  (1879) |  |  |  | NATIONAL RECOVERIES INC | TIMOTHY (N490)
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | KRISTOFER  (1879) |  |  |  | CROZER CHESTER MEDICAL CENTER | KEVIN  (Q047)
UNIVERSITY OF ALABAMA | 03/30/2016 | AL | KRISTOFER  (1879) |  |  |  | LAYERED TECH/DATAPIPE | MATTHEW (N537)
UNIVERSITY OF ALABAMA | 03/20/2015 | AL | KRISTOFER  (1879) |  |  |  | [NAME] ROVIRA CTR | CARRIE (6513)
UNIVERSITY OF ALABAMA | 03/10/2015 | AL | KRISTOFER  (1879) |  |  |  | ROGERS | [NAME] (F064)
UNIVERSITY OF ALABAMA | 03/10/2015 | AL | KRISTOFER  (1879)
MEDICAL SECURITY CARD | 03/04/2016 | AZ | 0
NATIONAL RECOVERIES INC | 03/28/2015 | MN | TIMOTHY (N490)
CROZER CHESTER MEDICAL CENTER | [NAME] | PA | KEVIN  (Q047)
CROZER CHESTER MEDICAL CENTER | 03/24/2015 | PA | KEVIN  (Q047)
CROZER CHESTER MEDICAL CENTER | 03/24/2015 | PA | KEVIN  (Q047)
CROZER CHESTER MEDICAL CENTER | 02/05/2015 | PA | KEVIN  (Q047)
LAYERED TECH/DATAPIPE | 03/28/2015 | VA | MATTHEW (N537)
[NAME] ROVIRA CTR | 03/24/2015 | NY | CARRIE (6513)
ROGERS | [NAME] | AZ | [NAME] (F064)
ROGERS | [NAME] | AZ | [NAME] (F064)
ROGERS | [NAME] | AZ | [NAME] (F064)
ROGERS | 02/26/2016 | CT | [NAME] (F064)
ROGERS | 03/20/2015 | AZ | [NAME] (F064)
Spreadsheet: 89249d1288989665-making-a-specific-randbetween-function-counterbalance-scheme
Sheet: Sheet1

Counterbalance Scheme | Scenario Condition
 | Manual | Semi-Auto | Semi-Auto /w Vis | Full-Auto
Target Route 1 | Manual + Route 1 | Semi-Auto + Route 1 | Semi-Auto /w Vis + Route 1 | Full-Auto + Route 1
Target Route 2 | Manual + Route 2 | Semi-Auto + Route 2 | Semi-Auto /w Vis + Route 2 | Full-Auto + Route 2
Target Route 3 | Manual + Route 3 | Semi-Auto + Route 3 | Semi-Auto /w Vis + Route 3 | Full-Auto + Route 3 |  | Hit F9 to recalculate randomized
Target Route 4 | Manual + Route 4 | Semi-Auto + Route 4 | Semi-Auto /w Vis + Route 4 | Full-Auto + Route 4 |  | selections for each participant
Target Route
 |  |  | 1 |  | <-------- | Scenario/Route Combination Selection
 |  |  |  |  | <--------- | Scenario Order Selection
Spreadsheet: 594710d1539914619-from-row-to-column-book2
Sheet: Sheet1

Name | List
a | 1
a | 2
a | 3
b | 1
b | 2 |  |  |  |  |  |  | Sum of List | Column Labels
b | 3 |  |  |  |  |  |  | Row Labels | 1 | 2 | 3 | 4 | 5
b | 4 |  |  |  |  |  |  | a | 1 | 2 | 3
b | 5 |  |  |  |  |  |  | b | 1 | 2 | 3 | 4 | 5
c | 1 |  |  |  |  |  |  | c | 1 | 2 | 3 | 4 | 5
c | 2
c | 3
c | 4
c | 5
Spreadsheet: darrell_schoolcraft__7323__imball0202
Sheet: NGPL

 | 52862 |  | 6828 |  | 6838
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Imbalance
1 | 38753 | 38839 |  | -1752 | 27848 | 23815
2 | 40637 | 40684 |  |  | 27871 | 25215
3 | 40652 | 40676 |  |  | 28102 | 25164
4 | 40650 | 40684 |  |  | 27824 | 25215 |  |  |  | Winkler/Eddy OBA |  |  |  |  |  |  | Gray  OBA
5 | 37651 | 37644 |  |  | 24510 | 24952
6 | 37652 | 37684 |  |  | 26762 | 25198 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount |  | Month | Measured | Scheduled | Imbalance | Index | Amount
7 | 37653 | 37684 |  |  | 26569 | 25217
8 | 39631 | 39684 |  |  | 21066 | 25215 |  |  |  | 2001-05-01 00:00:00 | 1103057 | 1120793 |  | 4.01 |  |  | 2001-05-01 00:00:00 | -202726 | -185000 |  | 4.01 |  |  | 2001-05-01 00:00:00 | 4.01
9 | 45455 | 45458 |  |  | 24054 | 23449 |  |  |  | 2001-06-01 00:00:00 |  | 1681871 |  | 3.51 |  |  | 2001-06-01 00:00:00 | -153623 | -88473 |  | 3.51 |  |  | 2001-06-01 00:00:00 | 3.51
10 | 45361 | 45458 |  |  | 23079 | 23449 |  |  |  | 2001-07-01 00:00:00 |  | 1270571 |  | 2.94 |  |  | 2001-08-01 00:00:00 | -34269 | -27046 |  | 2.85 |  |  | 2001-07-01 00:00:00 | 2.94
11 | 45428 | 45458 |  |  | 27403 | 19517 |  |  |  | 2001-08-01 00:00:00 |  | 1418897 |  | 2.85 |  |  | 2001-09-01 00:00:00 | -1191628 | -1210937 |  | 1.96 |  |  | 2001-08-01 00:00:00 | 2.85
12 | 45768 | 37497 |  |  | 14699 | 23449 |  |  |  | 2001-09-01 00:00:00 | 1109912 | 1111335 |  | 1.96 |  |  |  |  |  |  |  |  |  | 2001-09-01 00:00:00 | 1.96
13 | 33659 | 33643 |  |  | 29075 | 28943
14 | 33891 | 33684 |  |  | 28918 | 28943 |  |  |  | 5/01 - 9/01  balance |  |  |  |  |  |  | 5/01 - 9/01  balance
15 | 33682 | 33684 | -3456 | -10000 | 28439 | 28452
16 | 33687 | 33684 |  | -4795 | 28439 | 28452 |  |  |  | Volume balance @ 4/30/01 |  |  | 19880 |  |  |  | Volume balance @ 4/30/01 |  |  | 37185
17 | 33681 | 33684 |  | -5000 | 28436 | 28452
18 | 33667 | 33684 |  | -4813 | 28416 | 28452
19 | 33680 | 33684 |  | -5000 | 28419 | 28452
20
21
22
23
24
25
26
27
28
29
30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10000 | 2
31 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -10000 | 1.5
2002-01-31 00:00:00
2002-02-19 00:00:00
CBS Dollars
 |  |  |  |  | 338741