tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 100068d1298540923-how-to-paste-last-row-of-all-sheets-in-master-sheet-in-excel-2007-leave-record
Sheet: Alok Kumar

GO TO MASTER PRESENT STATUS SHEET
 | [NAME] as on Sep 30, 2009
 | Sl | Project | Dates |  | Days worked | Rotational Leave |  |  | ML
 |  |  | From | To |  | Earned | Availed | Balance
 | 1 | Mehasana | 2006-10-27 00:00:00 | 2007-06-29 00:00:00 |  |  | 0 |  | -
 |  | Leave | 2007-06-30 00:00:00 | 2007-09-15 00:00:00 | - | - |  |  | -
 | 2 | HO | 2007-09-16 00:00:00 | 2007-10-01 00:00:00 |  |  | - |  | -
 | 3 | Jayarampur | 2007-10-02 00:00:00 | 2007-11-30 00:00:00 |  |  | 0 |  | -
 |  | Leave | 2007-12-01 00:00:00 | 2007-12-14 00:00:00 | - | - |  |  | -
 | 4 | Jayarampur | 2007-12-15 00:00:00 | 2008-05-19 00:00:00 |  |  | - |  | -
 |  | Leave | 2008-05-20 00:00:00 | 2008-06-15 00:00:00
 | 5 | HO | 2008-06-16 00:00:00 | 2008-06-30 00:00:00
 |  | Leave | 2008-07-01 00:00:00 | 2008-10-03 00:00:00
 | 6 | Madhya Pradesh | 2008-10-04 00:00:00 | 2008-10-10 00:00:00
 |  | Leave | 2008-10-11 00:00:00 | 2008-11-28 00:00:00
 | 7 | Naginimora & Margerita - HOEC | 2008-11-29 00:00:00 | 2009-04-13 00:00:00
 |  | Leave | 2009-04-14 00:00:00 | 2009-05-20 00:00:00
 | 8 | Margerita -HOEC | 2009-05-21 00:00:00 | 2009-09-14 00:00:00
 |  | Leave | 2009-09-15 00:00:00 | 2009-11-17 00:00:00
 | 9 | [NAME] | 2009-11-18 00:00:00 | 2010-02-13 00:00:00
 |  | Leave |  | 2010-03-11 00:00:00
 | 10 | [NAME] -NGRI |  | 2010-03-30 00:00:00
 | 11 | [NAME] |  | 2010-07-07 00:00:00
 |  | Leave |  | 2010-11-04 00:00:00
 | 12 | [NAME]
Spreadsheet: 702857d1604577264-excel-locate-value-in-a1-locate-it-in-page-2-and-find-the-data-from-a-row-next-to-it-excel-example
Sheet: DB

User ID | first name | Surname | Manager
1 | [NAME] | Doe | [NAME]
2 | [NAME] | [NAME] | Rory
3 | [NAME] | Black | [NAME]
4 | [NAME] | Bletchley | [NAME]
5 | Billy | London | [NAME]
6 | Nick | McCaulley | Rory
7 | [NAME] | Simons | [NAME]
8 | Paolo | [NAME] | [NAME]
Spreadsheet: 90d1e871-447d-466e-8dff-cf9282ab304c
Sheet: Sheet1

Unnamed: 0 | UNITED STATES SENATOR - DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
2002-09-10 00:00:00
Belknap County | Shaheen, d | Smith, r | Stremsky, r | [NAME], r | [NAME]
Alton | 127 | 1 | 0 | 2 | 4
Barnstead | 223 | 2 | 0 | 0 | 0
Belmont | 201 | 9 | 0 | 3 | 2
Center Harbor | 52 | 1 | 0 | 0 | 0
Gilford | 302 | 8 | 0 | 9 | 0
Gilmanton | 140 | 3 | 0 | 1 | 0
[NAME] | 127 | 2 | 0 | 3 | 0
[NAME] | 104 | 1 | 0 | 6 | 2
[NAME] 3 | 129 | 1 | 0 | 2 | 0
[NAME] | 112 | 3 | 0 | 7 | 3
[NAME] | 107 | 4 | 0 | 5 | 1
[NAME] 6 | 97 | 8 | 0 | 4 | 0
Meredith | 242 | 6 | 0 | 6 | 0
New Hampton | 114 | 4 | 0 | 4 | 0
Sanbornton | 138 | 4 | 0 | 3 | 1
[NAME] | 148 | 3 | 0 | 2 | 1
TOTALS | 2363 | 60 | 0 | 57 | 14
 | UNITED STATES SENATOR - DEMOCRATIC
Carroll County | Shaheen, d | Smith, r | Stremsky, r | [NAME], r | [NAME]
Albany | 33 | 0 | 0 | 0 | 0
[NAME] | 133 | 6 | 0 | 6 | 0
[NAME] | 34 | 0 | 0 | 2 | 0
Chatham | 8 | 0 | 0 | 0 | 0
Conway | 294 | 9 | 0 | 2 | 2
Eaton | 26 | 0 | 0 | 0 | 0
[NAME] | 71 | 0 | 0 | 0 | 0
Freedom | 70 | 1 | 0 | 3 | 2
Hale's Location | 3 | 0 | 0 | 0 | 0
Hart's Location | 2 | 0 | 0 | 0 | 0
[NAME] | 84 | 0 | 0 | 0 | 0
[NAME] | 82 | 2 | 0 | 0 | 0
Moultonborough | 116 | 11 | 0 | 6 | 9
Ossipee | 114 | 2 | 0 | 4 | 0
Sandwich | 173 | 2 | 0 | 0 | 2
Tamworth | 158 | 0 | 0 | 0 | 0
Tuftonboro | 73 | 4 | 0 | 3 | 0
Wakefield | 126 | 5 | 0 | 3 | 2
Wolfeboro | 230 | 0 | 0 | 0 | 0
TOTALS | 1830 | 42 | 0 | 29 | 17
Spreadsheet: 220551d1363191744-vlookup-or-other-tools-to-retun-more-than-1-match-from-2-criteria-two-variable-vlookup-datavalidation
Sheet: Sheet1

ID | Name | Point | Session |  | Desired result: |  | ID | Name | Session |  |  | Data validation list
1111 | Viking | 5 | 1 |  |  |  | 2222 | [NAME] | 8
2222 | [NAME] | 6 | 7
1111 | Viking | 10 | 2
1111 | Viking | 5 | 3
2222 | [NAME] | 6 | 1
1111 | Viking | 10 | 4
1111 | Viking | 5 | 1
2222 | [NAME] | 6 | 8
1111 | Viking | 10 | 2
Spreadsheet: 192970d1352662084-data-validation-list-that-can-be-updated-both-way-price-book12
Sheet: Sheet1

Bakery
Baking_Powder
Baking_Soda
Beverages
Bleach
Bread
Breakfast
Brushes
Burger_Buns
Cake
Canned_Goods
Categorys
Choco_Chips
Cleaning_Supplies
Coffee
Cola
Condiments
Cooking.Oil.Olive
Corn.Flakes
Corned.Beef
Count
Croisant
[NAME]
Dairy
Detergent
Disinfectant
energy
Ethnic_Food
Fabric.softner
Fish.Sauce
Food_Colouring
Fresh_Produce
Frozen
Fruit.Loops
Fruits
[NAME].Paste
General.Purpose.[NAME]
Ghee
Ginger.Paste
[NAME].[NAME]
Gloves
Granola.Bars
Hot.Choclate
Hot_Dog_Buns
Jelly
Juice
[NAME]
Kitchen_Supplies
Mayonaise
Meat
Milk.Mix
Milk.Powder
Mops
Muffins
Museli
Mushrooms
Musturd.Oil
Naptha.Balls
Nuts
Oats
Oyster.Sauce
Packaged_Dry_Goods
Pasta.Sauce
Pastries
Pizza.sauce
Powder.Juice
Quiche
Salad.Dressing
Sesame.Oil
Snacks
Soup.Mix
Soy.Sauce
Spices
Sponges
Store
Swiss_Rolls
Tea
Toiletries
Tomato.Paste
Tuna
Vanilla_essence
[NAME].Sauce
Yeast
Spreadsheet: 676831d1589011401-sumproduct-with-embedded-if-sumproduct-with-if
Sheet: Combined

 |  | SUMMARY |  |  |  |  |  |  |  |  |  | SOURCE DATA
 |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 |  | Q1 2020 |  |  |  |  | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020 | Q1 2020
 |  | Begin | Transfer | Cont | Dist |  | End |  |  |  |  | Begin | Transfer | Transfer | Transfer | Cont | Dist | End
 |  | Begin | * | Cash | Cash |  | End |  |  |  |  | Begin | Balance | Item 1 | Item 3 | Cash | Cash | End
 |  |  | Net Transfer |  |  |  |  |  |  |  |  |  | TRANSFERS
 | ID | Beginning | Transfer | Cont | Dist |  | Ending | Expected | Difference |  | ID | Beginning | Balance | Item 1 | Item 3 | Cont | Dist | Ending
With embedded IF | 822 |  |  |  |  |  |  |  |  |  | 822 | 5000000 | 100000 | 0 | -5000 | 500000 | -500000
With embedded IF | 822
Only SUMPRODUCT | 822 |  |  |  |  |  |  |  |  |  | 825 | 6000000 | 0 | 157174.61 | 0 | 600000 | -400000
Expected | 822 |  |  |  |  |  |  |  |  |  | 831 | 7000000 | 314349.22 | 0 | 0 | 700000 | -300000
 |  |  |  |  |  |  |  |  |  |  | 1003 | 8000000 | 0 | 0 | 5000 | 800000 | -200000
TEST GROUP
 | 822
 | 825
 | 831
 | 1003
Spreadsheet: 483177d1475519665-find-non-blanks-cells-and-copy-to-another-worksheet-find-non_blank-cell
Sheet: Sheet2

 |  | Other solution
Anchor | Rock | Boars
2016-01-09 00:00:00 | 2016-01-23 00:00:00 | 2016-01-29 00:00:00
Spreadsheet: 771439d1646672189-periodic-table-excel-template-not-working-many-formulas-display-unknown-periodic-table-excel
Sheet: Periodic table

 | Periodic table
 | Use the search and property filters to explore interesting patterns and highlight data.
 |  | Group | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
 | Period
 |  |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | 1 |  | H |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | He
 |  |  |  |  |  |  |  |  | Search the periodic table: |  |  |  |  |  |  |  |  |  | Select a property to highlight in the table:
 |  |  | 3 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10
 | 2 |  | [NAME] |  | Be |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | B |  | C |  | N |  | O |  | F |  | Ne
 |  |  |  |  |  |  |  |  | Enter a name, symbol, or number.
 |  |  | 11 |  | 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 |  | 14 |  | 15 |  | 16 |  | 17 |  | 18
 | 3 |  | Na |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Al |  | Si |  | P |  | S |  | Cl |  | Ar
 |  |  | 19 |  | 20 |  | 21 |  | 22 |  | 23 |  | 24 |  | 25 |  | 26 |  | 27 |  | 28 |  | 29 |  | 30 |  | 31 |  | 32 |  | 33 |  | 34 |  | 35 |  | 36
 | 4 |  | K |  | Ca |  | Sc |  | Ti |  | V |  | Cr |  | Mn |  | Fe |  | Co |  | Ni |  | Cu |  | Zn |  | Ga |  | Ge |  | As |  | Se |  | Br |  | Kr
 |  |  | 37 |  | 38 |  | 39 |  | 40 |  | 41 |  | 42 |  | 43 |  | 44 |  | 45 |  | 46 |  | 47 |  | 48 |  | 49 |  | 50 |  | 51 |  | 52 |  | 53 |  | 54
 | 5 |  | Rb |  | Sr |  | Y |  | Zr |  | Nb |  | Mo |  | Tc |  | Ru |  | Rh |  | Pd |  | Ag |  | Cd |  | In |  | Sn |  | Sb |  | Te |  | I |  | Xe
 |  |  | 55 |  | 56 |  |  |  | 72 |  | 73 |  | 74 |  | 75 |  | 76 |  | 77 |  | 78 |  | 79 |  | 80 |  | 81 |  | 82 |  | 83 |  | 84 |  | 85 |  | 86
 | 6 |  | Cs |  | Ba |  |  |  | Hf |  | Ta |  | W |  | Re |  | Os |  | Ir |  | Pt |  | Au |  | Hg |  | Tl |  | Pb |  | Bi |  | Po |  | At |  | Rn
 |  |  | 87 |  | 88 |  |  |  | 104 |  | 105 |  | 106 |  | 107 |  | 108 |  | 109 |  | 110 |  | 111 |  | 112 |  | 113 |  | 114 |  | 115 |  | 116 |  | 117 |  | 118
 | 7 |  | Fr |  | Ra |  |  |  | Rf |  | Db |  | [NAME] |  | Bh |  | Hs |  | Mt |  | Ds |  | Rg |  | Cn |  | Nh |  | Fl |  | Mc |  | Lv |  | Ts |  | Og
 |  |  |  |  |  |  |  |  | 57 |  | 58 |  | 59 |  | 60 |  | 61 |  | 62 |  | 63 |  | 64 |  | 65 |  | 66 |  | 67 |  | 68 |  | 69 |  | 70 |  | 71
 |  |  |  |  | Lanthanide series |  |  |  | La |  | Ce |  | Pr |  | Nd |  | Pm |  | Sm |  | Eu |  | Gd |  | Tb |  | Dy |  | [NAME] |  | Er |  | Tm |  | Yb |  | [NAME]
 |  |  |  |  |  |  |  |  | 89 |  | 90 |  | 91 |  | 92 |  | 93 |  | 94 |  | 95 |  | 96 |  | 97 |  | 98 |  | 99 |  | 100 |  | 101 |  | 102 |  | 103
 |  |  |  |  | Actinide series |  |  |  | Ac |  | Th |  | Pa |  | U |  | Np |  | Pu |  | Am |  | Cm |  | Bk |  | Cf |  | Es |  | Fm |  | [NAME] |  | No |  | [NAME]
Spreadsheet: 190041d1351511714-how-to-group-matching-values-on-a-spread-sheet-sample-grouping-cells-for-totals
Sheet: Sheet1

Full Code | Full Description | Colour ref | Product ref | Age ref | Qty | Value | Stock Value |  | Total Qty | Total Value
13003E | Red Shirt (1-3yr) | 1 | 3003 | E | 252 | 1 | 252
13003G | Red Shirt (4-5yr) | 1 | 3003 | G | 1297 | 2 | 2594
13003K | Red Shirt (6-9yr) | 1 | 3003 | K | 176 | 3 | 528
13003M | Red Shirt (10-12yr) | 1 | 3003 | M | 325 | 4 | 1300
13003P | Red Shirt (13+yr) | 1 | 3003 | P | 72 | 5 | 360
23003E | Blue Shirt (1-3yr) | 2 | 3003 | E | 922 | 1 | 922
23003G | Blue Shirt (4-5yr) | 2 | 3003 | G | 1300 | 2 | 2600
23003K | Blue Shirt (6-9yr) | 2 | 3003 | K | 59 | 3 | 177
23003M | Blue Shirt (10-12yr) | 2 | 3003 | M | 72 | 4 | 288
23003P | Blue Shirt (13+yr) | 2 | 3003 | P | 2 | 5 | 10
73003G | Black Shirt (4-5yr) | 7 | 3003 | G | 39 | 2 | 78
73003M | Black Shirt (10-12yr) | 7 | 3003 | M | 18 | 4 | 72
73003P | Black Shirt (13+yr) | 7 | 3003 | P | 12 | 5 | 60 |  | 4546 | 9241
11002G | Red Scarf (4-5yr) | 1 | 1002 | G | 1297 | 1 | 1297
11002M | Red Scarf (10-12yr) | 1 | 1002 | M | 325 | 2 | 650
11002P | Red Scarf (13+yr) | 1 | 1002 | P | 72 | 3 | 216
21002G | Blue Scarf (4-5yr) | 2 | 1002 | G | 1300 | 1 | 1300
21002M | Blue Scarf (10-12yr) | 2 | 1002 | M | 72 | 2 | 144
21002P | Blue Scarf (13+yr) | 2 | 1002 | P | 2 | 3 | 6
71002M | Black Scarf (10-12yr) | 7 | 1002 | M | 18 | 2 | 36
71002P | Black Scarf (13+yr) | 7 | 1002 | P | 12 | 3 | 36 |  | 3098 | 3685
Spreadsheet: 57273d1257383549-populating-tables-copy-of-excel-problem
Sheet: Sheet1

Option 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Option 3
Table to be populated
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Nurses
Therapists
Scientists
Medics
Option 1 Table |  |  |  |  |  |  | Option 2 Table |  |  |  |  |  |  | Option 3 Table
 | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 |  |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5
Nurses |  |  |  |  |  |  | Nurses |  |  |  |  |  |  | Nurses
Therapists |  |  |  |  |  |  | Therapists |  |  |  |  |  |  | Therapists
Scientists |  |  |  |  |  |  | Scientists |  |  |  |  |  |  | Scientists
Medics |  |  |  |  |  |  | Medics |  |  |  |  |  |  | Medics
Spreadsheet: 862014d1709818039-reverse-calculation-retirment-calculator-excel
Sheet: Income Tax Table

 |  | Pre-retirement | Post-retirement
 | BC
 | AB
 | SK
 | MB
 | ON
 | QC
 | NB
 | PEI
 | NS
 | NL
 | YK
 | NWT
 | NU
Spreadsheet: 68188d1268745940-vlookup-index-match-help-example
Sheet: Sheet1

 | REPORT | NO: |  |  | CORP. | #14101/14004 | PAGE: | 1
 | [NAME] | STATUS | IN | (SM,SB) | LOCATIONS
 | DATE: | 2010-03-11 00:00:00 | CLAIMS | WITH | RECEIVED | DATES: | >=21 | DAYS, | <=29
 | STATUS/LOCATION: | SB0100
 | ID | DCN | PROVIDER | BILL | FROM | THRU | RECDT | TRANDT | AGED
 | 76506 | 20924501511802ME | 221572 | 813 | 2009-08-01 00:00:00 | 2009-08-31 00:00:00 | 2010-02-10 00:00:00 | 2010-03-06 00:00:00 | 29
 | 676700A | 20927500819902ME | 221572 | 813 | 2009-09-01 00:00:00 | 2009-09-30 00:00:00 | 2010-02-10 00:00:00 | 2010-03-06 00:00:00 | 29
 | A3650350 | 20930000419202ME | 227003 | 339 | 2009-06-06 00:00:00 | 2009-07-31 00:00:00 | 2010-02-10 00:00:00 | 2010-03-11 00:00:00 | 29
 | 79980980 | 20930801054502ME | 221572 | 813 | 2009-10-01 00:00:00 | 2009-10-31 00:00:00 | 2010-02-10 00:00:00 | 2010-03-06 00:00:00 | 29
 | ZP36430 | 20934100986602ME | 221572 | 813 | 2009-11-01 00:00:00 | 2009-11-30 00:00:00 | 2010-02-10 00:00:00 | 2010-03-06 00:00:00 | 29
 | wooww7 | 21000500409602ME | 221572 | 813 | 2009-12-01 00:00:00 | 2009-12-31 00:00:00 | 2010-02-10 00:00:00 | 2010-03-06 00:00:00 | 29
 | REPORT | NO: |  |  | CORP. |  |  | 2
 | [NAME] | STATUS | IN | (SM,SB) | LOCATIONS
 | DATE: | 2010-03-11 00:00:00 | CLAIMS | WITH | RECEIVED | DATES: | >=21 | DAYS, | <=29
 | STATUS/LOCATION: | SM7580
 | IC | DCN | PROVIDER | BILL | FROM | THRU | RECDT | TRANDT | AGED
 | 1323H | 21004300401702ME | 307021 | 329 | 2009-12-10 00:00:00 | 2009-12-17 00:00:00 | 2010-02-12 00:00:00 | 2010-03-11 00:00:00 | 27
 | 76905860560A | 21004300403602ME | 307021 | 339 | 2010-01-17 00:00:00 | 2010-01-18 00:00:00 | 2010-02-12 00:00:00 | 2010-03-11 00:00:00 | 27
 | 645640360J | 21004700370304ME | 200009 | 131 | 2010-01-31 00:00:00 | 2010-02-01 00:00:00 | 2010-02-16 00:00:00 | 2010-03-11 00:00:00 | 23
Spreadsheet: 883838d1732574096-calculating-using-multiple-variables-example
Sheet: 2024Events

 |  | LEAD |  |  | Gros | Company | [NAME] | [NAME] | Staff
500 | 2024-02-06 00:00:00 | CB | Wednesday, December 13, 2023 | NHIAA/PEA | 500 | 25 | 50 | 375 | 50
400 | 2024-02-22 00:00:00 | BJ | Thursday, December 14, 2023 | Dual Valley Conference/Northbridge H.S. #1 | 400 | 120 | 240 | 40 | 0
1000 | 2024-02-06 00:00:00 | BJ | Saturday, December 16, 2023 | NHIAA/PEA | 1000 | 275 | 500 | 100 | 125
1500 | 2024-01-01 00:00:00 | CB | Saturday, December 16, 2023 | NHIAA/PSU | 1500 | 350 | 150 | 750 | 250
1000 | 2024-01-01 00:00:00 | CBJ | Thursday, December 21, 2023 | NHIAA/UNH | 1000 | 100 | 450 | 450 | 0
1500 | 2024-01-01 00:00:00 | CB | Saturday, December 23, 2023 | NHIAA/PSU | 1500 | 350 | 150 | 750 | 250
Spreadsheet: 81787d1281957802-grouping-data-for-averaging-on-a-large-data-set-example2
Sheet: Sheet1

What I've Got
Day | Hour | Lat | Long | Wind Direction | Wind Speed | Wave Height | Wave Direction |  | Average Wind Direction | Average Wind Speed
1 | 0 | 527 | 23 | 200 | 20 | n/a | n/a |  | 210 | 19
1 | 0 | 530 | 21 | 210 | 20 | 20 | 210 |  | 210 | 19
1 | 0 | 531 | 22 | 220 | 26 | n/a | n/a |  | 210 | 19
1 | 0 | 535 | 22 | 210 | 10 | n/a | n/a |  | 210 | 19
1 | 1 | 527 | 23 | 200 | 21 | n/a | n/a |  | 210 | 18
1 | 1 | 531 | 22 | 220 | 24 | n/a | n/a |  | 210 | 18
1 | 1 | 535 | 22 | 210 | 9 | n/a | n/a |  | 210 | 18
1 | 2 | 527 | 23 | 210 | 20 | n/a | n/a |  | 216.6666666666667 | 18.66666666666667
1 | 2 | 531 | 22 | 220 | 25 | n/a | n/a |  | 216.6666666666667 | 18.66666666666667
1 | 2 | 535 | 22 | 220 | 11 | n/a | n/a |  | 216.6666666666667 | 18.66666666666667
1 | 3 | 527 | 23 | 210 | 18 | n/a | n/a |  | 213.3333333333333 | 19.66666666666667
1 | 3 | 531 | 22 | 220 | 29 | n/a | n/a |  | 213.3333333333333 | 19.66666666666667
1 | 3 | 535 | 22 | 210 | 12 | n/a | n/a |  | 213.3333333333333 | 19.66666666666667
1 | 4 | 527 | 23 | 250 | 27 | n/a | n/a |  | 230 | 22.66666666666667
1 | 4 | 531 | 22 | 220 | 29 | n/a | n/a |  | 230 | 22.66666666666667
1 | 4 | 535 | 22 | 220 | 12 | n/a | n/a |  | 230 | 22.66666666666667
1 | 5 | 527 | 23 | 250 | 28 | n/a | n/a |  | 273.3333333333333 | 26.33333333333333
1 | 5 | 531 | 22 | 210 | 30 | n/a | n/a |  | 273.3333333333333 | 26.33333333333333
1 | 5 | 535 | 22 | 360 | 21 | n/a | n/a |  | 273.3333333333333 | 26.33333333333333
What I Need
Day | Hour | Lat | Long | Wind Direction | Wind Speed | Wave Height | Wave Direction |  | Average Wind Direction | Average Wind Speed
1 | 0 | 527 | 23 | 200 | 20 | n/a | n/a
1 | 0 | 530 | 21 | 210 | 20 | 20 | 210
1 | 0 | 531 | 22 | 220 | 26 | n/a | n/a
1 | 0 | 535 | 22 | 210 | 10 | n/a | n/a |  | 210 | 19
1 | 1 | 527 | 23 | 200 | 21 | n/a | n/a
1 | 1 | 531 | 22 | 220 | 24 | n/a | n/a
1 | 1 | 535 | 22 | 210 | 9 | n/a | n/a |  | 210 | 18
1 | 2 | 527 | 23 | 210 | 20 | n/a | n/a
1 | 2 | 531 | 22 | 220 | 25 | n/a | n/a
1 | 2 | 535 | 22 | 220 | 11 | n/a | n/a |  | 216.6666666666667 | 18.66666666666667
1 | 3 | 527 | 23 | 210 | 18 | n/a | n/a
1 | 3 | 531 | 22 | 220 | 29 | n/a | n/a
1 | 3 | 535 | 22 | 210 | 12 | n/a | n/a |  | 213.3333333333333 | 19.66666666666667
1 | 4 | 527 | 23 | 250 | 27 | n/a | n/a
1 | 4 | 531 | 22 | 220 | 29 | n/a | n/a
1 | 4 | 535 | 22 | 220 | 12 | n/a | n/a |  | 230 | 22.66666666666667
1 | 5 | 527 | 23 | 250 | 28 | n/a | n/a
1 | 5 | 531 | 22 | 210 | 30 | n/a | n/a
1 | 5 | 535 | 22 | 360 | 21 | n/a | n/a |  | 273.3333333333333 | 26.33333333333333
Spreadsheet: 303488d1394520542-salary-bracket-returns-employees-corresponding-contribution-for-philhealth-sss-workbook
Sheet: Sheet1

EMPLOYEE | BASIC PAY | SSS Employee Share | SSS Employer Share
A | 14500
B | 15500
C | 16000
 | [NAME] |  | Employer Share | Employee Share | Total
 | 0 | 10249.99 | 746.7 | 363.3
 |  |  | 783.5 | 381.5
 |  |  | 820.3 | 399.7
 |  |  | 857.2 | 417.8
 |  |  | 894 | 436
 |  |  | 930.8 | 454.2
 |  |  | 967.7 | 472.3
 |  |  | 1004.5 | 490.5
 |  |  | 1041.3 | 508.7
 |  |  | 1078.2 | 526.8
 |  |  | 1135 | 545
 |  |  | 1171.8 | 563.2
 |  |  | 1208.7 | 581.3
Spreadsheet: 212924d1360280065-repeating-a-calculation-and-recording-results-in-a-column-annuity-analysis
Sheet: random

 | Press F9 to generate new result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 | GLWB base growth
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.03 | Inflation rate |  |  |  |  |  |  | Investment account if SPIA is purchased
 |  |  | year start |  | year start |  |  |  |  |  |  | Growth of $12,000 |  |  | 12000 | Annual withdrawal
 | Sue age |  | GLWB base |  | Account value |  | withdrawal |  | market return |  |  | to keep up w/inflation |  |  |  |  |  |  |  |  |  |  |  | Starting year value
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average of random number sequence
2013-03-01 00:00:00 | 66 |  | 240000 |  | 240000 |  |  |  |  |  |  | 12000 |  |  |  |  |  |  |  |  |  |  |  | 57000
2014-03-01 00:00:00
2015-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected portfolio average return
2016-03-01 00:00:00
2017-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Average return |  | 0.08 |  | Input portfolio average return
2018-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | stnd dev |  | 0.115 |  | and standard deviation in the yellow cells
2019-03-01 00:00:00
2020-03-01 00:00:00
2021-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VA fees
2022-03-01 00:00:00
2023-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0059 | moderate
2024-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.0095 | gwlb
2025-03-01 00:00:00
2026-03-01 00:00:00
2027-03-01 00:00:00
2028-03-01 00:00:00
2029-03-01 00:00:00
2030-03-01 00:00:00
2031-03-01 00:00:00
2032-03-01 00:00:00
2033-03-01 00:00:00
2034-03-01 00:00:00
2035-03-01 00:00:00
2036-03-01 00:00:00
2037-03-01 00:00:00
2038-03-01 00:00:00
2039-03-01 00:00:00
2040-03-01 00:00:00
2041-03-01 00:00:00
2042-03-01 00:00:00
Spreadsheet: 743526d1628577411-formula-s-for-choosing-and-calculating-milage-rates-expenses_sheet_main-_jt
Sheet: April

Employee Business Kilometres & Subsistence Expenses Claim |  |  |  |  |  | Period Ended:
Employee Name: |  |  |  |  | Car Reg
 |  |  |  |  | Engine Size
Home Address:
 |  |  |  |  | Start Odometer Reading
 |  |  |  |  | Current Odometer Reading
Mileage |  |  |  |  |  | Subsistence
 |  |  |  |  |  | <10HR | >10HR | O/N
Date | Reason for Journey |  | To | From | Total | 15.41 | 36.97 | 147
 |  |  |  |  | 200
 |  |  |  |  | 100
 |  |  |  |  | 400
 |  |  |  |  | 350
 |  |  |  |  | 200
 |  |  |  |  | 160
 |  | This Month | Last Month | Annual to date
Total Business Kilometres |  |  |  |  | Total
Rate Applicable
Value of Mileage Claim (KM x rate) |  |  |  |  | Total Claim (mileage & subsistence)
Rates per Kilometre are determined by Engine Size
 |  | Distance (KM) | Under 1200cc | 1201 to 1500cc | 1501 and over
 |  | 0 - 1500 | 0.3795 | 0.3986 | 0.4479
 |  | 1501 - 5500 | 0.7 | 0.7321 | 0.8353
 |  | 5501 - 25000 | 0.2755 | 0.2903 | 0.3221
 |  | *Rates change after completing 1500/5500 business kilometres
Signed |  |  |  |  | Date
Approved by |  |  |  |  | Date
Return this form within seven days of month end to accounts department
Spreadsheet: 102952d1300824065-compare-data-in-two-column-and-report-differences-differences
Sheet: Sheet1

 |  | in a not in b | in b not in a
ABC | ABC
AEG | ADB | AEG
ADB | CDA |  | CDA
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
 |  | 0 | 0
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_15

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
Discover | Mount Pleasant | SC | [NAME] |  | [NAME] | patra@patr |  | (843) 696-4553 | 0 | 58 | S
Charleston |  |  | zine, |  | iscovercharl | ataylor.net
 |  |  | consu |  | eston.com
 |  |  | [NAME]
DiscoverSD | San Diego | CA | Onlin |  | [NAME] | mguerin@di |  | (619) 342-3155 | 0 | 58 | S
 |  |  | e, |  | iscoversd.c | scoversd.co |  | x5
 |  |  | consu |  | om | m
 |  |  | [NAME]
E- | [NAME] | PA | Onlin |  | http://www.e | info@e- |  | (215) 675-1800 | 0 | 40 | S
Hospitality.com |  |  | e, |  | - | hospitality.c
 |  |  | news |  | hospitality.c | om
 |  |  | and |  | om
 |  |  | busin
 |  |  | ess
EnViva | Brooklyn | NY | [NAME] |  | http://enviva | enviva.ed@i |  | (347) 294-1220 | 0 | 45 | S
Magazine |  |  | zine, |  | magazine.c | nk-
 |  |  | consu |  | om/ | publishing.c
 |  |  | [NAME] |  |  | om
Epicurus.com | Wall Township | NJ | Onlin |  | http://www.e | magazine@ |  | (732) 693-8850 | 0 | 38 | S
 |  |  | e, |  | picurus.com | epicurus.co
 |  |  | consu |  | / | m
 |  |  | [NAME]
Fillmore, | Toronto | ON | Freel |  | http://www.s | cathleen@s |  | (416) 532-9886 | 0 | 56 | S
Cathleen |  |  | ance |  | peakersgold | peakersgold
 |  |  | Journ |  | .com/ | .com
 |  |  | alist
GlobalHotelNetw | San Diego | CA | [NAME] |  | http://www.g | ghr@global |  | (858) 793-3366 | 0 | 49 | S
ork.com |  |  | zine, |  | lobalhotelne | [NAME]
 |  |  | trade/ |  | twork.com | k.com
 |  |  | indust
 |  |  | ry
Go World Travel | Westminster | CO | Onlin |  | http://www.g | submissions |  | (303) 216-1628 | 0 | 60 | S
 |  |  | e, |  | oworldtravel | @behinddo
 |  |  | consu |  | .com | or7.com
 |  |  | [NAME]
Page: 15 |  |  |  |  |  |  |  |  |  |  | 12/13/2011