tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: andy_zipper__790__10_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | 22 | 210 | 220 | 52.5 | 55 | 0.74 | 2001-10-26 10:04:00
 | CL F2 | 22 | 333 | 345 | 52.1 | 54 | 0.73 | 2001-10-26 10:04:00
 | CL G2 | 22.5 | 425 | 440 | 50.5 | 52.3 | 0.73 | 2001-10-26 10:04:00
 | CL H2 | 22.5 | 475 | 490 | 48.7 | 50.2 | 0.7 | 2001-10-26 10:04:00
 | CL J2 | 22.5 | 505 | 520 | 46.3 | 47.7 | 0.66 | 2001-10-26 10:04:00
 | CL K2 | 22.5 | 530 | 545 | 43.9 | 45.1 | 0.63 | 2001-10-26 10:04:00
 | CL M2 | 22.5 | 540 | 555 | 41.6 | 42.7 | 0.6 | 2001-10-26 10:04:00
 | CL N2 | 22 | 550 | 565 | 40.4 | 41.5 | 0.57 | 2001-10-26 10:04:00
 | CL Q2 | 22 | 552 | 567 | 38.3 | 39.3 | 0.54 | 2001-10-26 10:04:00
 | CL U2 | 22 | 555 | 570 | 36.7 | 37.7 | 0.51 | 2001-10-26 10:04:00
 | [NAME] | 22 | 560 | 575 | 35.3 | 36.2 | 0.49 | 2001-10-26 10:04:00
 | CL X2 | 22 | 560 | 680 | 33.9 | 41.2 | 0.52 | 2001-10-26 10:04:00
 | [NAME] | 22 | 560 | 580 | 32.7 | 33.9 | 0.46 | 2001-10-26 10:04:00
 | CL M3 | 21.5 | 555 | 575 | 28.1 | 29.2 | 0.39 | 2001-10-26 10:04:00
 | CL Z3 | 21.5 | 555 | 575 | 25.1 | 26 | 0.35 | 2001-10-26 10:04:00
Spreadsheet: 216705d1361858064-find-percentage-of-times-two-adjacent-cells-have-the-same-data-test-sheet-1-
Sheet: Sheet2

Drive Letter: | C: | [NAME]: - 60 | Free Space: | 46Drive Letter: | D: | [NAME]: | 76 | Free Space: | 70
Drive Letter: | C: | [NAME]: - 60 | Free Space: | 45Drive Letter: | D: | [NAME]: | 76 | Free Space: | 70
Drive Letter: | A: | [NAME]: - 0 | Free Space: | 0Drive Letter: | C: | [NAME]: | 24 | Free Space: | 12Drive Letter: | D: | [NAME]: - 9 | Free Space: - 9Drive Letter: - X: | [NAME]: - 4 | Free Space: - 0Drive Letter: - Y: | [NAME]: - 0 | Free Space: - 0 |  |  |  |  | 0 / Free Space: | 0
Drive Letter: | C: | [NAME]: - 60 | Free Space: | 46Drive Letter: | D: | [NAME]: | 76 | Free Space: | 70
Drive Letter: | C: | [NAME]: - 60 | Free Space: | 43Drive Letter: | D: | [NAME]: | 76 | Free Space: | 69
Drive Letter: | C: | [NAME]: - 60 | Free Space: | 46Drive Letter: | D: | [NAME]: | 76 | Free Space: | 70
Drive Letter: | A: | [NAME]: - 0 | Free Space: | 0Drive Letter: | C: | [NAME]: | 24 | Free Space: | 11Drive Letter: | D: | [NAME]: - 9 | Free Space: - 8Drive Letter: - L: | [NAME]: - 100 | Free Space: - 82Drive Letter: - P: | [NAME]: - 100 | Free Space: - 71Drive Letter: - X: | [NAME]: - 4 | Free Space: - 0Drive Letter: - Y: | [NAME]: - 0 | Free Space: - 0 | 100 / Free Space: | 71Drive Letter: | X: / Drive Size: | 4 / Free Space: | 0Drive Letter: | Y: / Drive Size: | 0 / Free Space: | 0
Drive Letter: | C: | [NAME]: - 59 | Free Space: | 34Drive Letter: | D: | [NAME]: | 350 | Free Space: | 309Drive Letter: | E: | [NAME]: - 558 | Free Space: - 481Drive Letter: - O: | [NAME]: - 0 | Free Space: - 0Drive Letter: - V: | [NAME]: - 1000 | Free Space: - 739Drive Letter: - W: | [NAME]: - 1600 | Free Space: - 158Drive Letter: - Y: | [NAME]: - 0 | Free Space: - 0 | 1000 / Free Space: | 739Drive Letter: | W: / Drive Size: | 1600 / Free Space: | 158Drive Letter: | Y: / Drive Size: | 0 / Free Space: | 0
Spreadsheet: 693370d1598948854-consolidating-duplicate-values-excel-forum-b-final-output-example
Sheet: Sheet3

PRODUCT | VAT RATE | VAT | PID | AMOUNT | PRICE | TOTAL | COST VAT EXCL | PROFIT | CATEGORY TYPE
Delivery Cutlery (per set) | 7 | 0.26 | EX1 | 2 | 2 | 4 | 0 | 3.74 | Unknown (product deleted)
[NAME] | 7 | 2.62 | CT5 | 12 | 10 | 60 | 0 | 56.07 | Unknown (product deleted)
Mayo | 7 | 0.65 | [NAME] | 1 | 10 | 10 | 0 | 9.35 | Unknown (product deleted)
Fresh Marinated Onion 50g | 7 | 7.85 | AT1 | 12 | 10 | 120 | 0 | 112.15 | Unknown (product deleted)
Americano Large | 7 | 3.93 | CT4 | 6 | 30 | 90 | 0 | 84.11 | Unknown (product deleted)
Fresh Orange Juice | 7 | 8.83 | [NAME] | 54 | 255 | 810 | 0 | 757.0199999999998 | Unknown (product deleted)
Mayo | 7 | 6.54 | [NAME] | 5 | 20 | 100 | 0 | 93.46 | Unknown (product deleted)
[NAME] | 7 | 2.62 | [NAME] | 2 | 20 | 40 | 0 | 37.38 | Unknown (product deleted)
Lucky 13 Latte | 7 | 11.78 | CT11 | 13 | 60 | 260 | 0 | 242.98 | Unknown (product deleted)
Egg (1) | 7 | 16.36 | AT21 | 10 | 25 | 250 | 0 | 233.64 | Unknown (product deleted)
[NAME] | 7 | 11.78 | ASD11 | 6 | 30 | 180 | 0 | 168.22 | Unknown (product deleted)
[NAME] | 7 | 3.93 | [NAME] | 2 | 30 | 60 | 0 | 56.07 | Unknown (product deleted)
Choron Dressing | 7 | 11.78 | ASD25 | 6 | 30 | 180 | 0 | 168.22 | Unknown (product deleted)
Home Ketchup | 7 | 3.93 | ASD5 | 2 | 30 | 60 | 0 | 56.07 | Unknown (product deleted)
Chili Sauce | 7 | 13.74 | ASD7 | 7 | 30 | 210 | 0 | 196.26 | Unknown (product deleted)
[NAME] | 7 | 17.66 | ASD9 | 9 | 30 | 270 | 0 | 252.34 | Unknown (product deleted)
Lucky Water | 7 | 217.85 | DKS1 | 111 | 30 | 3330 | 0 | 3112.15 | Unknown (product deleted)
Mild Soft Cheese 1sl | 7 | 20.61 | AC1 | 9 | 35 | 315 | 0 | 294.39 | Unknown (product deleted)
Spreadsheet: 700058d1602929765-looking-up-multiple-columns-in-a-nestled-if-film-club-2020
Sheet: Actors

Actor | Total | Ave Score | Oscars | Ave Time | Best Film | Score | Worst Film | Score | Bechdel | BOAT
[NAME]
[NAME]
[NAME] |  |  |  |  |  |  | Julia
Julia
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Woody Allen
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 175952d1345675314-help-with-rank-auto-sort-features-spreadsheet-attached-sortexample1
Sheet: Tie Breaker Enabled

Rank | Name | Points | Standing | Name Rank | Tie Breaker (Based on Alphabetical Name Position)
18 | [NAME] | 421 | 18th Place | 25 | 421.00025
23 | [NAME] | 15 | 23rd Place | 24 | 15.00024
1 | Amanda | 115252 | 1st Place | 23 | 115252.00023
25 | Otis | 3 | 25th Place | 22 | 3.00022
20 | [NAME] | 95 | 20th Place | 21 | 95.00021
15 | [NAME] | 652 | 15th Place | 20 | 652.0002
14 | [NAME] | 662 | 14th Place | 19 | 662.00019
24 | Cameron | 4 | 24th Place | 18 | 4.00018 |  | Standings (Concatenate Formula)
21 | [NAME] | 93 | 21st Place | 17 | 93.00017 |  | 1st Place - Amanda
5 | [NAME] | 9122 | 5th Place | 16 | 9122.00016 |  | 2nd Place - Taylor
10 | [NAME] | 1506 | 10th Place | 15 | 1506.00015 |  | 3rd Place - Trish
11 | Geo | 1506 | 11th Place | 14 | 1506.00014 |  | 4th Place - Stephanie
7 | Jamal | 8452 | 7th Place | 13 | 8452.00013 |  | 5th Place - Darren
12 | [NAME] | 951 | 12th Place | 12 | 951.00012 |  | 6th Place - Stephen
19 | Jolleane | 357 | 19th Place | 11 | 357.00011 |  | 7th Place - Jamal
17 | JT | 482 | 17th Place | 10 | 482.0001 |  | 8th Place - Larry
9 | Kelly | 2112 | 9th Place | 9 | 2112.00009 |  | 9th Place - Kelly
8 | [NAME] | 6759 | 8th Place | 8 | 6759.00008 |  | 10th Place - Eric
16 | Orly | 532 | 16th Place | 7 | 532.00007 |  | 11th Place - Geo
22 | Rich | 48 | 22nd Place | 6 | 48.00006 |  | 12th Place - Joanie
4 | [NAME] | 9624 | 4th Place | 5 | 9624.00005 |  | 13th Place - Will
6 | Stephen | 8863 | 6th Place | 4 | 8863.00004 |  | 14th Place - Brian
2 | [NAME] | 12486 | 2nd Place | 3 | 12486.00003 |  | 15th Place - Brad
3 | Trish | 9647 | 3rd Place | 2 | 9647.00002 |  | 16th Place - Orly
13 | Will | 852 | 13th Place | 1 | 852.00001 |  | 17th Place - JT
 |  |  |  |  |  |  | 18th Place - Alex
 |  |  |  |  |  |  | 19th Place - Jolleane
Rankings | Standing | Name |  |  |  |  | 20th Place - Andy
1 | 1st Place | Amanda |  |  |  |  | 21st Place - Dan
2 | 2nd Place | [NAME] |  |  |  |  | 22nd Place - Rich
3 | 3rd Place | Trish |  |  |  |  | 23rd Place - Allison
4 | 4th Place | [NAME] |  |  |  |  | 24th Place - Cameron
5 | 5th Place | [NAME] |  |  |  |  | 25th Place - Otis
6 | 6th Place | Stephen
7 | 7th Place | Jamal
8 | 8th Place | [NAME]
9 | 9th Place | Kelly
10 | 10th Place | [NAME]
11 | 11th Place | Geo
12 | 12th Place | [NAME]
13 | 13th Place | Will
14 | 14th Place | [NAME]
15 | 15th Place | [NAME]
16 | 16th Place | Orly
17 | 17th Place | JT
18 | 18th Place | [NAME]
19 | 19th Place | Jolleane
20 | 20th Place | [NAME]
21 | 21st Place | [NAME]
22 | 22nd Place | Rich
23 | 23rd Place | [NAME]
24 | 24th Place | Cameron
25 | 25th Place | Otis
Spreadsheet: 0b2c4dd4-7afd-435f-8458-fa7b5b183f8c
Sheet: 2

 | Dec 7 |  | Dec 14 |  | Dec 21 |  | Dec 28
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rates* | 386815002 | 386815002 | 373815958 | 373815958 | 375002189 | 375002189 | 373145478 | 373145478
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16715730 | 16715730 | 14833311 | 14833311 | 16716689 | 16716689 | 16648654 | 16648654
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 22051544 | 22051544 | 22186373 | 22186373 | 20253627 | 20253627 | 20351555 | 20351555
Dealers** | 18742936 | 18712521 | 18853736 | 18819257 | 17188255 | 17188614 | 17262402 | 17260245
Buyside | 3308609 | 3339024 | 3332637 | 3367115 | 3065372 | 3065012 | 3089153 | 3091310
Total Equity | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Commodities | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: joe_parks__14910__3-27-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Mar-27-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Physical or Financial? | Transaction Description
2002-03-27 00:00:00 | -293543 | Duke Field Services | Duke Field Services | [NAME] | Phys | Pmt for post petition supply expenses.
2002-03-28 00:00:00 | -701760 | MCV I | Reliant Energy Services | [NAME] | Phys | Prepay related to baseload gas to serve Midland Cogeneration Ventures I.  Note revised number from $601,494 to 701,760 due to market movement.  Also, revised payment date due to Friday market holiday.
2002-03-28 00:00:00 | -35000 | City of Tallahassee | Reliant | [NAME] | Phys | Swing gas prepay.
2002-03-28 00:00:00 | -646860 | Dominion | Dominion Energy? | [NAME] | Phys | Prepay related to baseload gas to serve City of Tallahasee.  Note the revised payment date.  Also, this is still an estimated amount because Dominion is disputing its obligation to sell the gas.
2002-04-03 00:00:00 | -5313 | Bear Creek Storage | Bear Creek Storage | [NAME] | Phys | Reservation and commodity charges.  Note that this is still an estimated amount.  Cash request still pending.  Payment moved from 3/29/02 to 4/3/02.
Spreadsheet: 290124d1389799718-retrieving-end-time-from-large-list-pulling-dates
Sheet: Tab 2

ID | End Time
67890 | 2013-12-31 16:30:24
67890 | 2013-12-31 16:35:24
67890 | 2013-12-30 01:35:24
67890 | 2013-12-19 09:35:45
67890 | 2013-12-19 09:00:34
68904 | 2013-12-15 11:00:34
68904 | 2013-12-15 13:00:34
68904 | 2013-12-06 00:05:00
68904 | 2012-12-24 20:23:08
60123 | 2013-12-12 09:45:11
60123 | 2013-12-12 10:45:11
Spreadsheet: geir_solberg__11246__4-29
Sheet: Sheet1

DATE | FERC FILE | SERVICE CUST | HR BEG | HR END | TOTAL HRS | DEL PT | SUPPLY | MW PER HR | TOTAL MW | SCHEDULE ID | BUY PRICE
2001-04-29 00:00:00 |  |  | 1 | 1 | 1 | NP15 | EESI | 20 | 20 |  | 85
2001-04-29 00:00:00 |  |  | 2 | 2 | 1 | NP15 | EESI | 22 | 22 |  | 85
2001-04-29 00:00:00 |  |  | 2 | 2 | 1 | NP15 | EESI | 1 | 1 |  | 145
2001-04-29 00:00:00 |  |  | 3 | 3 | 1 | NP15 | EESI | 3 | 3 |  | 145
2001-04-29 00:00:00 |  |  | 4 | 4 | 1 | NP15 | EESI | 3 | 3 |  | 145
2001-04-29 00:00:00 |  |  | 5 | 5 | 1 | NP15 | EESI | 2 | 2 |  | 145
2001-04-29 00:00:00 |  |  | 6 | 6 | 1 | NP15 | EESI | 19 | 19 |  | 145
2001-04-29 00:00:00 |  |  | 3 | 3 | 1 | NP15 | EESI | 22 | 22 |  | 85
2001-04-29 00:00:00 |  |  | 4 | 5 | 2 | NP15 | EESI | 22 | 44 |  | 85
2001-04-29 00:00:00 |  |  | 3 | 3 | 1 | NP15 | EESI | 9 | 9 |  | 105
2001-04-29 00:00:00 |  |  | 4 | 5 | 2 | NP15 | EESI | 9 | 18 |  | 105
2001-04-29 00:00:00 |  |  | 6 | 6 | 1 | NP15 | EESI | 12 | 12 |  | 105
2001-04-29 00:00:00 |  |  | 7 | 7 | 1 | NP15/SP15 | EES | 25 | 25 |  | 100
2001-04-29 00:00:00 |  |  | 9 | 9 | 1 | NP15/SP15 | EES | 16 | 16 |  | 100
2001-04-29 00:00:00 |  |  | 10 | 10 | 1 | NP15/SP15 | EES | 12 | 12 |  | 100
2001-04-29 00:00:00 |  |  | 11 | 11 | 1 | NP15/SP15 | EES | 9 | 9 |  | 100
2001-04-29 00:00:00 |  |  | 12 | 12 | 1 | NP15/SP15 | EES | 8 | 8 |  | 100
2001-04-29 00:00:00 |  |  | 13 | 13 | 1 | NP15/SP15 | EES | 8 | 8 |  | 100
2001-04-29 00:00:00 |  |  | 14 | 14 | 1 | NP15/SP15 | EES | 6 | 6 |  | 100
2001-04-29 00:00:00 |  |  | 15 | 15 | 1 | NP15/SP15 | EES | 7 | 7 |  | 100
2001-04-29 00:00:00 |  |  | 16 | 16 | 1 | NP15/SP15 | EES | 8 | 8 |  | 100
2001-04-29 00:00:00 |  |  | 17 | 17 | 1 | NP15/SP15 | EES | 8 | 8 |  | 100
2001-04-29 00:00:00 |  |  | 18 | 18 | 1 | NP15/SP15 | EES | 5 | 5 |  | 100
2001-04-29 00:00:00 |  |  | 19 | 19 | 1 | NP15/SP15 | EES | 2 | 2 |  | 100
2001-04-29 00:00:00 |  |  | 21 | 21 | 1 | NP15/SP15 | EES | 1 | 1 |  | 100
2001-04-29 00:00:00 |  |  | 22 | 22 | 1 | NP15/SP15 | EES | 6 | 6 |  | 100
Spreadsheet: 882760d1731226489-ytm-and-accrued-interest-of-bonds-ytm-and-accrued-interest-of-bonds-jt-
Sheet: JT

Name | FV | Buy (Dirty) Price | Buy Date | Issue Date | Maturity Date | [NAME] Payment/ year | Coupon Rate % | Accrued Interest | Clean Price | YTM | Next Interest Payment Date | Last Interest Payment Date | Buy Price using yield per YIELD function |  | Next Interest Payment Date | Check | Last Interest Payment Date | Check | Accrued Interest | Check
AAA | 1000 | 1067 | 2024-11-08 00:00:00 | 2012-01-25 00:00:00 | 2027-01-25 00:00:00 | 1 | 8.3 |  | C2-I2
ZZZ | 100 | 105 | 2024-11-08 00:00:00 | 2012-01-08 00:00:00 | 2030-01-08 00:00:00 | 2 | 7 |  | [NAME]
YYY | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 | 100 |  |  |  |  |  |  |  | [NAME]
 |  | YTM and accrued interest of bonds
 |  | https://www.excelforum.com/excel-formulas-and-functions/1430279-ytm-and-accrued-interest-of-bonds.html#post5993308
 |  | https://quantwolf.com/calculators/bondyieldcalc.html
 |  | You can use the ACCRINT function to calculate the accrued interest, but first you need to find out the next interest payment date.
 |  | There is also an inbuilt function to calculate YTM: YIELD. But that function seemed to give incorrect result.
 |  | YTM calculation using XIRR (AAA) |  |  |  |  | YTM calculation using XIRR (ZZZ) |  |  |  |  | YTM calculation using XIRR (YYY)
 |  |  |  |  | Yield using XIRR |  |  |  |  | Yield using XIRR |  |  |  |  | Yield using XIRR
Spreadsheet: 60871d1261461957-compile-worksheet-list-toll-free-test
Sheet: Attempted Calls

 |  | Attempted Calls
 |  | Phone Number | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | 2010-01-31 00:00:00 | 2010-02-28 00:00:00 | 2010-03-31 00:00:00 | 2010-04-30 00:00:00 | 2010-05-31 00:00:00 | 2010-06-30 00:00:00 | 2010-07-31 00:00:00 | 2010-08-31 00:00:00 | 2010-09-30 00:00:00 | 2010-10-31 00:00:00 | 2010-11-30 00:00:00 | 2010-12-31 00:00:00
$C$25 |  | 8001234567 | 125 | 885 | 26
 |  | 8661234567 | 885 | 0 | 26
 |  | 8771234567 | 26 | 0 | 26
Spreadsheet: 784622d1655879389-extract-values-with-the-help-of-two-criteria-sample
Sheet: Basic Data

 |  |  | Sr. No. | Date | Name of the Department | Name of the Employee | [NAME] | Total Number of Batches | Paper No | Remarks
 |  |  | 1 | 01.01.2022 | Finance | Mr. [NAME] | 1.2 | 2
 |  |  | 2 | 02.01.2022 | Finance | Mr. [NAME] | 3.4 | 2
 |  |  | 3 | 05.01.2022 | Marketing | Mr. [NAME] | 2.1 | 2
 |  |  | 4 | 06.01.2022 | Production | Mrs. A | 1 | 1
 |  |  | 5 | 07.01.2022 | Production | Mr. [NAME] | 6.4 | 2
 |  |  | 6 | 07.01.2022 | Finance | Mrs. B | 5 | 1
 |  |  | 7 | 07.01.2022 | Finance | Mrs. C | 6.7 | 2
 |  |  | 8 | 07.01.2022 | Marketing | Mr. [NAME] | 5.6 | 2
 |  |  | 9 | 07.01.2022 | Finance | Mr. [NAME] | 8.9.10 | 3
 |  |  | 10 | 07.01.2022 | Production | Mr. [NAME] | 2.3.5 | 3
 |  |  | 11 | 10.02.2022 | Marketing | Mr. [NAME] | 3.4 | 2
 |  |  | 12 | 10.02.2022 | Marketing | Mr. [NAME] | 7.8.9.10 | 4
 |  |  | 13 | 10.02.2022 | Production | Mr. [NAME] | 7 | 1
 |  |  | 14 | 10.02.2022 | Finance | Ms. [NAME] | 11.12.13.14 | 4
 |  |  | 15 | 10.02.2022 | Marketing | Ms. [NAME] | 11.14 | 2
 |  |  | 16 | 17.02.2022 | Finance | Mr. [NAME] | 15.16 | 2
 |  |  | 17 | 17.02.2022 | HR | Mr.  A | 20.10 | 2
 |  |  | 18 | 17.02.2022 | HR | Mr. [NAME] | 1.5.2 | 3
 |  |  | 19 | 18.02.2022 | HR | Mr. [NAME] | 25.4.15.30 | 4
Spreadsheet: e39ec1df-9cd4-4af0-9efe-0606f4751689
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
40179542 | 2014-02-22 15:45:59 | AXIS | 0 | 7 | 10 | 524628 | [NAME] | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
40222636 | 2014-02-24 22:07:20 | AXIS | 1 | 6 | 2 | 1442898 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
40222854 | 2014-02-24 22:32:42 | ALLIES | 0 | 3 | 6 | 1442898 | [NAME] | 6147 | western | 1944-06-06 | 1944-06-06 | First Assault Wave | 1ère vague d'assaut
40355868 | 2014-03-04 21:02:17 | AXIS | 1 | 7 | 5 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40356346 | 2014-03-04 21:29:52 | ALLIES | 0 | 5 | 7 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 487679d1478191034-multi-purpose-calander-task-manager-master-worklist
Sheet: Monthly

Column1 | Column2 | Column3 | Column4 | Column5
2016-01-01 00:00:00
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
 | M4MO | M4PU | M4AD
 | AICS
Column1 | Column2 | Column3 | Column4 | Column5
2016-04-25 00:00:00
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
 | MA4B
 | MM
 | MMO1 | MWS | MT
 | MPU2
 | MF
 | MMO2
 | MPU | MW
 | MH
Spreadsheet: 182588d1348544160-automatic-count-across-columns-data-print-1-
Sheet: Label

 |  |  |  |  |  | from the yellow cell drag down
Spreadsheet: 735997d1623312953-vlookup-to-calculate-the-total-per-site-test-example-ans
Sheet: Sheet1

Site | Postcode | Lat | Long | Work | Number
Peacock Lane | BA12 9FA | 51.199468 | -2.174562 | Grass | 20
Peacock Lane | BA12 9FA | 51.19936 | -2.174367 | Grass | 46
Eden Grove | SN12 8QJ | 51.395637 | -2.163002 | Shrub | 61
Eden Grove | SN12 8QJ | 51.395646 | -2.162932 | Shrub | 44
Results to be: | [NAME] which adds up all of the values for a work for the same site |  |  |  |  |  |  | Results to be: | [NAME] which adds up all of the values for a work for the same site
 |  |  |  |  |  |  |  | Peacock Lane | BA12 9FA | 51.199468 | -2.174562 | Grass | 66
 |  |  |  |  |  |  |  | Eden Grove | SN12 8QJ | 51.395637 | -2.163002 | Shrub | 105
Spreadsheet: 483341d1475603037-count-sites-forecasted-per-week-book1
Sheet: Forecasting MMs

site |  |  | 15 Forecast | 15 Actual | 15 Forecast Week | 20 Forecast | 20 Actual | 15 Forecast Week
1 |  |  | 2016-10-04 00:00:00 | 2016-10-04 00:00:00 |  | 2016-10-11 00:00:00
2 |  |  | 2016-10-04 00:00:00 |  |  | 2016-10-11 00:00:00
3 |  |  | 2016-10-04 00:00:00 | 2016-10-04 00:00:00 |  | 2016-10-11 00:00:00
4 |  |  | 2016-10-04 00:00:00 |  |  | 2016-10-11 00:00:00 | 2016-10-11 00:00:00
5 |  |  | 2016-10-16 00:00:00 |  |  | 2016-10-18 00:00:00
6 |  |  | 2016-10-16 00:00:00 |  |  | 2016-10-18 00:00:00
7 |  |  | 2016-10-16 00:00:00 |  |  | 2016-10-18 00:00:00
8 |  |  | 2016-10-16 00:00:00 |  |  | 2016-10-18 00:00:00
9 |  |  | 2016-10-16 00:00:00 |  |  | 2016-10-18 00:00:00
10 |  |  | 2016-10-17 00:00:00 |  |  | 2016-10-25 00:00:00
11 |  |  | 2016-10-17 00:00:00 |  |  | 2016-10-25 00:00:00
12 |  |  | 2016-10-17 00:00:00 |  |  | 2016-10-25 00:00:00
13 |  |  | 2016-10-17 00:00:00 |  |  | 2016-10-25 00:00:00
14 |  |  | 2016-10-30 00:00:00 |  |  | 2016-10-25 00:00:00
15 |  |  | 2016-10-30 00:00:00 |  |  | 2016-11-01 00:00:00
16 |  |  | 2016-10-30 00:00:00 |  |  | 2016-11-01 00:00:00
17 |  |  | 2016-10-31 00:00:00 |  |  | 2016-11-01 00:00:00
18 |  |  | 2016-10-31 00:00:00 |  |  | 2016-11-08 00:00:00
Spreadsheet: 783701d1655079741-deposits-into-respective-month-closest-match-with-multiple-criteria-dynamic-array-approximate-close-match-with-criteria
Sheet: Sheet2

Region | Sub ID | Sale Date | Total Deposits to Collect | Deposits Collected
North | A | 2020-05-15 00:00:00 | 40000 | 40000
North | B | 2020-12-10 00:00:00 | 40000 | 5000
South | A | 2022-08-05 00:00:00 | 25000 | 0
South | B | 2020-10-20 00:00:00 | 25000 | 30000
East | A | 2021-07-31 00:00:00 | 40000 | 0
East | B | 2021-08-01 00:00:00 | 75000 | 35000
West | A | 2020-11-04 00:00:00 | 40000 | 39800
West | B | 2020-01-01 00:00:00 | 25000 | 5000
Spreadsheet: 0a88d28d-c95e-45c3-bbb4-4d2a0458b650
Sheet: Mobile Action Plan

MOBILE PPC ACTION PLAN
ACTION | [NAME] | [NAME]
LAUNCH MOBILE PREFERRED ADS | Make sure every ad group contains mobile preferred ads.
LAUNCH MOBILE PREFERRED SITE LINKS | Make sure every ad group opted in for mobile has mobile preferred site links.
LAUNCH CALL EXTENSIONS | Every mobile targeted campaign should utilize call extensions (if they make sense for your business).
REVIEW MOBILE KW BID MODIFIERS | Determine a bidding strategy before you launch any mobile campaigns.
REVIEW ALL KW BID MODIFIERS | Review all of the other account modifiers that may interact with your bid modifier.
REVIEW GDN ON MOBILE DEVICES | GDN doesn't work well on mobile. Consider removing mobile devices from these campaigns.
REMOVE APPS FROM MOBILE GDN | If you run GDN on mobile devices, closely review your  placements. [NAME] if needed.
REVIEW CONV OPT & AD DELIVERY | Conversion Optimizer makes adjustments per device. Review all campaign settings.
LAUNCH MOBILE OPTIMIZED PAGE | It may be difficult, but pages optimized for each device really work better. Work on this.
CREATE PROCESS TO REVIEW LEAD QUALITY | Once your are running on mobile, closely monitor your leads/sales to make sure they are high quality.