tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744923d1629559181-return-max-or-large-for-each-2d-arrays-row-with-only-one-spill-formula-2d-spilled-max-for-each-row-dynamic-ans
Sheet: 2D Spilled MAX for Each Row

100 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
100 | 137 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 40 | 70 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 50 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 50 | 57 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 200 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 0 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 348 | 0 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 348 | 367 | 0
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 300 | 348 | 367 | 376
Spreadsheet: 1474a546-1e41-494a-abb4-8eb36a6d89c0
Sheet: 1996

TYPE OF PERMIT | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | YR TOTAL
-------------- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --------
SINGLE FAMILY DET. | 63 | 92 | 125 | 136 | 93 | 39 | 115 | 85 | 63 | 39 | 61 | 52
$ [NAME] | 9106281 | 12636476 | 17378101 | 19167113 | 13180419 | 5225947 | 16538661 | 12701955 | 9942086 | 5807775 | 8862712 | 7730220
SINGLE FAMILY ATT. | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DUPLEX | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MULTI FAMILY UNITS | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 10658834 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
RESIDENTIAL ADD. | 18 | 12 | 15 | 27 | 27 | 12 | 6 | 11 | 12 | 7 | 15 | 6
$ [NAME] | 112643 | 31461 | 70155 | 85476 | 93634 | 49812 | 77804 | 47375 | 57867 | 49859 | 53281 | 60274
COMMERCIAL | 1 | 0 | 0 | 2 | 0 | 1 | 0 | 1 | 1 | 1 | 1 | 0
$ [NAME] | 1150000 | 0 | 0 | 2200000 | 0 | 13500000 | 0 | 58000 | 600000 | 2600000 | 250000 | 0
COMMERCIAL ADD/F.O. | 4 | 5 | 4 | 2 | 5 | 4 | 2 | 7 | 10 | 8 | 8 | 6
$ [NAME] | 31100 | 113500 | 1668551 | 165000 | 138000 | 132460 | 5100 | 207493 | 107142 | 45650 | 82700 | 83500
INDUSTRIAL | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
PUBLIC BUILDINGS | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 13363000 | 0 | 0 | 0 | 0 | 0 | 285400 | 0 | 0 | 0
PUBLIC BLDG. ADD. | 0 | 0 | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0
$ [NAME] | 0 | 0 | 1483400 | 0 | 0 | 0 | 0 | 0 | 0 | 11650 | 0 | 0
TEMPORARY OFFICE | 2 | 2 | 5 | 2 | 2 | 1 | 0 | 3 | 0 | 4 | 3 | 1
$ [NAME] | 2000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
ACCESSORY BLDG. | 1 | 2 | 6 | 9 | 5 | 6 | 9 | 4 | 3 | 4 | 4 | 6
$ [NAME] | 700 | 750 | 7468 | 11400 | 3750 | 7061 | 5284 | 5129 | 5300 | 2979 | 2679 | 4568
POOLS | 11 | 14 | 22 | 28 | 25 | 22 | 21 | 18 | 12 | 12 | 8 | 5
$ [NAME] | 238800 | 266741 | 478326 | 527390 | 515600 | 428972 | 408631 | 413600 | 221600 | 252300 | 174400 | 116600
SPAS | 1 | 0 | 1 | 1 | 1 | 0 | 2 | 0 | 0 | 3 | 0 | 0
$ [NAME] | 3995 | 0 | 2000 | 5000 | 2000 | 0 | 19134 | 0 | 0 | 13300 | 0 | 0
FENCES | 74 | 37 | 70 | 105 | 84 | 26 | 75 | 44 | 38 | 37 | 64 | 51
$ [NAME] | 73188 | 45270 | 70700 | 90670 | 87488 | 27980 | 87599 | 45738 | 42190 | 39625 | 63600 | 49600
SPRINKLER | 58 | 53 | 79 | 106 | 91 | 67 | 62 | 83 | 54 | 65 | 61 | 66
$ [NAME] | 60000 | 80300 | 122558 | 153805 | 122900 | 83860 | 76350 | 128700 | 65300 | 83550 | 70945 | 86900
SIGNS | 10 | 4 | 9 | 8 | 7 | 13 | 7 | 6 | 10 | 3 | 3 | 5
$ [NAME] | 8820 | 3338 | 6109 | 30000 | 3098 | 44325 | 5469 | 32975 | 10250 | 3160 | 4007 | 14186
MOVING | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 3800 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
DEMOLITION | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0
$ [NAME] | 0 | 0 | 0 | 4000 | 1350 | 2200 | 400 | 0 | 0 | 0 | 0 | 0
TOTAL PERMITS
TOTAL DOLLAR VALUE
Spreadsheet: 161755d1339615002-checking-for-the-days-in-a-column-work-schedule-and-salary-calculation-extreme
Sheet: Personal Data

MEG SHELL EASTERN PETROLEUM SINGAPORE (PTE) LTD
Overtime/Meal/Transport/Midnight/Acting Allowance Claim Form
Year
2012-06-14 00:00:00
Name
Team |  | 1
Basic salary |  | 2338 | 12.26223776223776 | 161.8615384615385 | 809.3076923076923
Race |  | C | C=Chinese,M=Muslim,I=Indian
Date of Birth |  | 1985-01-01 00:00:00 | [NAME]/dd/yyyy |  |  |  | Age | 1927-06-13 00:00:00
Maritius Status |  | S | S=Single,M=Married
GESPP |  | 890
Shell Staff Co-op |  | 0
Date of Joining |  | 2008-02-18 00:00:00 | [NAME]/dd/yyyy |  |  | Year of Service |  | 1904-04-26 00:00:00
Shift Allowance |  | 775
Night Shift Allowance |  | 26
Meal Allowance |  | 12
Transport Allowance |  | 16
Leave Balance
Time Account |  | Deductible From |  | Deductible To |  | Entitlement | Remainder
SG-Medical Leave |  | 01/01/ | 2012-06-14 00:00:00 | 31/12/ | 2012-06-14 00:00:00 | 14 | 14
SG-Hospitalisation Leave |  | 01/01/ | 2012-06-14 00:00:00 | 31/12/ | 2012-06-14 00:00:00 | 60 | 60
SG-Child Care Leave |  | 01/01/ | 2012-06-14 00:00:00 | 31/12/ | 2012-06-14 00:00:00 | 0 | 0
SG-Carried Forward Leave |  | 01/04/ | 2012-06-14 00:00:00 | 31/03/ | 2013-06-14 00:00:00 | 0 | 0
SG-Other Leave Credit |  | 01/04/ | 2012-06-14 00:00:00 | 31/03/ | 2013-06-14 00:00:00 | 5 |  | 5
SG-Yearly Entitled Leave |  | 01/04/ | 2012-06-14 00:00:00 | 31/03/ | 2013-06-14 00:00:00 | 10 |  | 10
Please fill in your particulars here before you proceed to key in on the respective months
On the "Remarks" column in each sheet, key in "AL" for Annual Leave,"MC" for Medical Leave,"HL" for  Hospitalisation Leave and "CCL" for Childcare Leave. Not following this format will result in the Leave Balance not calculated properly.
Spreadsheet: 143835d1330592353-automatic-entry-into-summary-table-when-matching-various-criteria-blank-sui-form-test-2
Sheet: Incident_Accident

Date of Incident | Month of Indicent | Date Reported | Accident / Injury Happened To: | Name of Service User /  Staff of Other | Name of Provider | Type of notification | What happened | Date CQC notified | Conclusion | Completed by (SW) | What can be learned from this which would prevent a future occurance?
01.01.2011 | April | 01.01.2011 | Staff | [NAME] | Sky | Illness
15.05.2011 |  | 16.05.2011 |  | [NAME] | River
16.06.2011 | April | 17.06.2011 | S U | Un known | un known | Seizures
Spreadsheet: 115557d1311117374-copying-tables-daily-scratch-its-week-1-copy
Sheet: Sold Scratch-Its

Week Starting |  | 2011-07-11 00:00:00
Cost | Ticket Name | Book Number | Ticket Number | Mon - Opening | Mon - Closing | Mon - Sold | Mon - Value | Tue - Opening | Tue - Closing | Tue - Sold | Tue - Value | Wed - Opening | Wed - Closing | Wed - Sold | Wed - Value | Thu - Opening | Thu - Closing | [NAME] | Thu - Value | Fri - Opening | Fri - Closing | Fri - Sold | Fri - Value | Sat - Opening | Sat - Closing | Sat - Sold | Sat - Value | Sold Out
 |  | 5651 |  | 63 | 101 |  |  |  | 117 |  |  |  | 122 |  |  |  | 145 |  |  |  | 163 |  |  |  | 195
 |  | 15032 |  | 41 | 49 |  |  |  | 60 |  |  |  | 69 |  |  |  | 85 |  |  |  | 89 |  |  |  | 100
 |  | 12468 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  | 9231 |  | 58 | 59 |  |  |  | 60 |  |  |  | 61 |  |  |  | 63 |  |  |  | 65 |  |  |  | 68
 |  | 12699 |  | 31 | 33 |  |  |  | 40 |  |  |  | 40 |  |  |  | 43 |  |  |  | 50
 |  | 11420 |  | 5 | 7 |  |  |  | 9 |  |  |  | 13 |  |  |  | 14 |  |  |  | 15 |  |  |  | 18
 |  | 6727 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 |  | 118850 |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  | 4 |  |  |  | 16 |  |  |  | 34
 |  | 104438 |  | 23 | 33 |  |  |  | 44 |  |  |  | 48
 |  | 54289 |  | 14 | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14 |  |  |  | 14
Books Open |  |  |  |  | Mon Total |  |  |  | Tue Total |  |  |  | Wed Total |  |  |  | Thu Total |  |  |  | Fri Total |  |  |  | Sat Total |  |  | Weekly Total
Spreadsheet: 743090d1628200066-multiple-data-for-stock-portfolio-x12
Sheet: MJ9617

SL | DATE | TICKER | QTY | RATE | TOTAL BUY | COMMISSION | TOTAL COST | SALE DATE | SALE QTY. | SELL VALUE | TOTAL SALE | COMMISION | NET SALE | NET GAIN | GAIN % | REMARKS
1 | 2021-06-21 00:00:00 | BXPHARMA | 100 | 179.6 |  |  |  | 2021-06-22 00:00:00 | 100 | 177.8
2 | 2021-06-21 00:00:00 | ESQUIRENIT | 340 | 36.8
3 | 2021-06-22 00:00:00 | ESQUIRENIT | 710 | 38.21
4 | 2021-06-22 00:00:00 | ESQUIRENIT | 430 | 40.79
5 | 2021-06-23 00:00:00 | OAL | 235 | 10.5
6 | 2021-06-24 00:00:00 | PRIMELIFE | 140 | 70.1 |  |  |  |  |  |  |  |  |  |  |  | ORDER BY CLIENT
7 | 2021-06-27 00:00:00 | ESQUIRENIT | 115 | 42.81
8 | 2021-06-29 00:00:00 | DSSL | 2490 | 18.18
9 | 2021-06-29 00:00:00 | ESQUIRENIT | 500 | 39.8 |  |  |  | 2021-06-29 00:00:00 | 1595 | 40.9
10 | 2021-07-05 00:00:00 |  |  |  |  |  |  | 2021-07-05 00:00:00 | 500 | 41.9
 | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEPOSIT HISTORY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SL | DATE | PARTICULARS | AMOUNT | BALANCE | Re
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2021-06-19 00:00:00 | OPENING STOCK VALUE AS COUNT DEPOSIT | 0 | 53540.96
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 2021-06-20 00:00:00 | bKash - Deposit | 1970
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2021-06-20 00:00:00 | bKash - Deposit | 2955
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 2021-06-22 00:00:00 | bKash - Deposit | 2462
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 2021-06-23 00:00:00 | bKash - Deposit | 9820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | 2021-06-24 00:00:00 | bKash - Deposit | 4925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | 2021-06-27 00:00:00 | bKash - Deposit | 4925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 2021-06-28 00:00:00 | Client Invest |  |  | 9863.07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 2021-07-06 00:00:00 | bKash - Deposit | 1050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | 2021-07-07 00:00:00 | bKash - Deposit | 4925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | 2021-07-07 00:00:00 | bKash - Deposit | 4925
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
Spreadsheet: 768310d1644923883-have-excel-change-a-text-based-on-different-value-input-values-to-edit
Sheet: WISC-V

Data input |  |  |  |  |  |  | Value names | Low value | Hige value |  | <--- Values between low and high
 |  |  |  |  |  |  | Absolute above average | 120 | 129
Name | Leo |  |  |  |  |  | Above average | 110 | 119
Gender pronomen |  |  |  |  |  |  | Avarage | 90 | 109
 |  |  |  |  |  |  | Belove avarage | 80 | 89
Different value names | Score (IQ) | Persentile (%) | Confidenceintervall 95% |  |  |  | Absolute belove average | 70 | 79
Ex1 "Visual" | 95 | 48 | 101-91
Ex2
Ex3
Ex4
Ex5
Ex6
Changable sample text
Leo scored 95. This is Avarage. He needs to work on….
"Name" scored "Ex1 value". This is "value names". "Gender pronomen" need to work on this and this….
Spreadsheet: 1638d671-5d6e-4cad-a72a-932257a68138
Sheet: Publishers (Fiction)

Publisher (Fiction) | Titles | Percentage
[NAME] | 31
Europa Editions | 18
[NAME] | 18
AmazonCrossing | 17
Seagull Books | 16
Other Press | 15
Atria | 9
American University at Cairo | 8
FSG | 8
Melville House | 8
Minotaur | 8
Open Letter | 8
Archipelago | 7
Knopf | 7
And Other Stories | 6
Le French | 6
New Directions | 6
Penguin | 6
Bloomsbury Qatar | 5
HarperCollins | 5
[NAME] | 5
Bloomsbury | 4
Hispabooks Publishing | 4
Houghton [NAME] | 4
New Vessel Press | 4
Pegasus | 4
Quercus | 4
Random House | 4
Seven Stories Press | 4
Talonbooks | 4
Yale University Press | 4
Akashic Books | 3
Interlink | 3
MacLehose Press | 3
New York Review Books | 3
Pantheon | 3
Stockholm Text | 3
Twisted Spoon Press | 3
Two Lines Press | 3
University of Nebraska | 3
Arcade | 2
Bellevue Literary Press | 2
Black Cat | 2
City Lights | 2
Coach House Books | 2
Counterpoint | 2
[NAME] | 2
[NAME] | 2
Garnet Publishing | 2
Glagoslav Publications | 2
Glas | 2
Graywolf | 2
Haikasoru | 2
Library of Arabic Literature | 2
Locked Room International | 2
Mulholland Books | 2
New Press | 2
Restless Books | 2
Soho Press | 2
Tor | 2
Vintage | 2
7Vientos | 1
Arcadia | 1
Atlantic Books | 1
[NAME] | 1
Barcelona Books | 1
Bento Books | 1
Biblioasis | 1
Bitter Lemon | 1
Black Balloon | 1
Coffee House | 1
Crown | 1
DISQUIET | 1
Doubleday | 1
East Slope Publishing Ltd. | 1
Ecco | 1
ECW Press | 1
Exile Editions | 1
[NAME] and [NAME] | 1
Feminist Press | 1
Frisch & Co. | 1
[NAME] | 1
Grand Central | 1
Grove | 1
Hanging Loose Press | 1
[NAME] | 1
House of Anansi | 1
Karolinum Press | 1
Lilliput Press | 1
McGill-Queen's University Press | 1
[NAME]'s Books | 1
Minnesota Historical Society Press | 1
[NAME] | 1
New American Press | 1
New Europe | 1
New London Librarium | 1
New York University Press | 1
Nightboat Books | 1
Norvik Press | 1
OR Books | 1
Overlook | 1
Ox and [NAME] | 1
[NAME] | 1
Picador | 1
PM Press | 1
Portobello | 1
Random House Canada | 1
Sampsonia Way | 1
Schocken Books | 1
Simon & Schuster | 1
Syracuse University Press | 1
Tagus Press | 1
Telegram | 1
University of Minnesota Press | 1
University of Texas | 1
Vertical | 1
W.W. Norton | 1
Wakefield Press | 1
[NAME] | 1
Spreadsheet: 705422d1606121582-find-and-replace-values-book3-copy-1-
Sheet: Sheet1

name |  | Replace | Contains
1 oz Eau De Toilette Spray (unboxed) for Men |  |  | eau de toilette
2.5 oz Eau De Toilette Spray (Tester) for Men edt |  |  | spray shampoo1
Bond 1.6 oz spray shampoo for Men |  |  | eau de per
shampoo 3.4 oz eau de perfume Spray (Tester) for Men |  |  | shampoo
body spray |  |  | body spray
Bond 1.6 oz Eau De Toilette Spray for Men |  |  | soap
Bond 1.6 oz Eau De Toilette Spray for Men
Bond 1.6 oz Eau De Toilette Spray for Men
soap
soap
soap
soap
z
 |  |  | Replace table
 |  |  | Contains | Replace with
 |  |  | eau de toilette | edt
 |  |  | spray shampoo | ss111
 |  |  | eau de per | edp
 |  |  | shampoo | sp
 |  |  | body spray | body spray
 |  |  | soap | soap
Spreadsheet: 647749d1572612157-closest-match-with-multiple-criteria-3-criteria-boxes-breakdown-closest-match-sample
Sheet: Sheet1

ID | length | width |  |  |  | [NAME] | length | width
1 | 600 | 400 |  |  |  | Cont1 | 450 | 305
2 | 400 | 300 |  |  |  | Cont2 | 800 | 500
3 | 200 | 150 |  |  |  | Cont3 | 600 | 402
 |  |  |  |  |  | Cont4 | 250 | 200
 |  | WORKING
ID | length | width | depth |  |  | [NAME] | length | width | depth
1 | 600 | 400 | 119 |  |  | Cont1 | 450 | 305 | 430
2 | 400 | 300 | 220 |  |  | Cont2 | 800 | 500 | 135
3 | 200 | 150 | 420 |  |  | Cont3 | 600 | 402 | 250
 |  |  |  |  |  | Cont4 | 250 | 200 | 175
Spreadsheet: 782116d1653806415-how-to-deduct-a-balance-and-maintain-current-amount-balanceef_test
Sheet: Sheet1 (2)

 |  |  |  | Beginning Balance |  | 50
 |  |  | Date | Amount
 |  |  | 2022-05-28 00:00:00 | 5
 |  |  | 2022-05-28 00:00:00 | 5
 |  |  | 2022-05-29 00:00:00 | C
 |  |  | 2022-05-29 00:00:00 | 5
Spreadsheet: 266457d1379617755-trouble-with-indexing-multiple-criteria-with-a-date-range-travel-template-3
Sheet: Rates

IRS Standard Mileage Allowance
Year | Timeframe1 | Rate1 | Timeframe2 | Rate2
2013 | 01/01 - 12/31 | 0.565
2012 | 01/01 - 12/31 | 0.555
2011 | 01/01 - 06/30 | 0.51 | 07/01 - 12/31 | 0.555
2010 | 01/01 - 12/31 | 0.5
2009 | 01/01 - 12/31 | 0.55
2008 | 01/01 - 06/30 | 0.505 | 07/01 - 12/31 | 0.585
 |  |  | TOTAL
Year | City/County | Timeframe | PER DIEM | Lodging | M&IE
2012 | [NAME], AL | 10/01 - 05/31 | 151 | 100
2008 | Huntsville, AL | 01/01 - 12/31 | 128 | 84
2009 | Huntsville, AL | 01/01 - 12/31 | 128 | 84
2010 | Huntsville, AL | 01/01 - 12/31 | 137 | 86
2012 | Mobile, AL | 01/01 - 12/31 | 145 | 94
2013 | Oceanside, CA | 01/01 - 12/31 | 204 | 133
2009 | [NAME], CA | 10/01 -0 9/30 | 156 | 97
2009 | Washington, DC | 11/01 - 06/30 | 273 | 209
2012 | Cape Canaveral, FL | 01/01 - 12/31 | 150 | 99
2011 | Cocoa Beach, FL | 01/01 - 12/31 | 150 | 99
2010 | Cocoa Beach, FL | 01/01 - 12/31 | 148 | 97
2010 | Tallahassee, FL | 01/01 - 12/31 | 136 | 90
2011 | Valdosta, GA | 01/01 - 12/31 | 123 | 77
2011 | Effingham, IL | 01/01 - 12/31 | 123 | 77
2011 | Springfield, IL | 01/01 - 12/31 | 138 | 82
2011 | [NAME], IA | 01/01 - 12/31 | 123 | 77
2012 | Alexandria, LA | 01/01 - 12/31 | 141 | 80
2012 | New Orleans, LA | 07/01 - 09/30 | 172 | 101
2012 | New Orleans, LA | 10/01 - 06/30 | 206 | 135
2011 | New Orleans, LA | 07/01 - 09/30 | 169 | 98
2011 | New Orleans, LA | 10/01 - 06/30 | 202 | 131
2010 | New Orleans, LA | 07/01 - 09/30 | 175 | 104
2012 | [NAME], MS | 01/01 - 12/31 | 123 | 77
2012 | Hattiesburg, MS | 01/01 - 12/31 | 135 | 84
2012 | Jackson, MS | 01/01 - 12/31 | 123 | 77
2011 | Meridian, MS | 01/01 - 12/31 | 123 | 77
2013 | Meridian, MS | 01/01 - 12/31 | 123 | 77
2009 | Alexandria, VA | 11/01 - 06/30 | 273 | 209
2013 | Sandston, VA | 01/01 - 12/31 | 134 | 83
2012 | Mabank, TX | 01/01 - 12/31 | 123 | 77
2013 | [NAME], TX | 01/01 - 12/31 | 180 | 109
2013 | Houston, TX | 01/01 - 12/31 | 180 | 109
Spreadsheet: 677796d1589529254-formula-for-column-g-searcched-exclusion-of-value-in-column-e-if-values-are-repeated-example_excel-problemxlsx
Sheet: Hoja1

A | B | C | D | E | F | G |  | the idea is to have:
1 | 100 | 1000000000 | 500 | 200 | 4 |  |  | one formula applicable for the whole column G (my original data has more than 3000 lines and is based on makros)
 |  | 1000000001 | 12
 |  | 1000000002 | 12
 |  | 1000000003 | 1
1 | 200 | 1000000000 | 500 | 200 | 1 |  |  | If [NAME], B3 and E3 equal A8, [NAME] and E8, then the value in column E should only be considered once (the first time)
 |  | 1000000001 | 12
 |  | 1000000002 | 12
 |  | 1000000003 | 1
1 | 300 | 1000000004 | 2000 | 50 | 3
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
1 | 400 | 1000000004 | 2000 | 50 | 2 |  |  | if the value in column E has already been considered in the calculation once in this case row 13 (taken into consideration that A13, B13 and [NAME] contained the same information, it should not be considered anymore)
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
2 | 500 | 1000000004 | 2000 | 20 | 2
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
2 | 300 | 1000000004 | 2000 | 20 | 2
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
2 | 700 | 1000000004 | 1500 | 20 | 8
 |  | 1000000003 | 1
 |  | 1000000005 | 1
 |  | 1000000006 | 8
 |  | 1000000007 | 8
Spreadsheet: 00c84f18-4282-4548-b735-a4f8d9624afb
Sheet: Per Diem Worksheet

PER DIEM CALCULATION
The Disbursements Office will calculate the per diem for you if you prefer. Simply fill in the pertinent information.
 |  |  |  |  |  | PER CENT OF DAY |  | LESS MEALS PROVIDED
CITY OF DEPARTURE | DATE | TIME | CITY | OVERNIGHT | Domestic Per Diem Rates | TRAVELING | PER DIEM | Breakfast=20% | PER DIEM
 |  |  | [NAME] | STAY? | Foreign Per Diem Rates | 12:01am to 6am=25% | SUBTOTAL | [NAME] | TOTAL
 |  |  |  |  |  | 6:01am to noon=25% |  | Dinner=60%
 |  |  |  |  |  | 12:01pm to 6pm=25%
 |  |  |  |  | PER DIEM RATE | 6:01pm to midnight=25% |  | ENTER DOLLAR AMT
 |  |  |  |  |  |  |  | TOTAL
Spreadsheet: 793416d1661452885-new-rolling-total-for-points-scored-in-last-3-games-rolling-total-for-points-scored-in-last-3-games-3-
Sheet: Totals

Name 22 |  |  |  | 3
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Name 21
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Bethany
[NAME]
[NAME]
Nicki
Spreadsheet: 748144d1631912872-hard-time-figuring-out-this-problem-involving-match-and-index-wright_excel_ch05_ps2_musiclessons
Sheet: Report

Student Report
Student ID | 000018 |  | Competiton Fees
Teacher |  |  | Registration Type | Regular
Average Fee |  |  | Travel Type | Bus
Skill Level |  |  | Uniform Size
Total Lessons |  |  | Uniform Fee
Total Paid this Year |  |  | Registration Fee
Bonus Lessons |  |  | Transportation Fee
 |  |  | Total
Competition Report |  |  |  |  |  | Size | Number Needed | Price Per Uniform
Student ID | Student Name | Permission Slip? | Uniform Size | Ready to go! |  | XS
000001 |  |  |  |  |  | S
000002 |  |  |  |  |  | M
000003 |  |  |  |  |  | L
000006 |  |  |  |  |  | XL
000008 |  |  |  |  |  | XXL
000010
000016
000018
000020
000022
000025
000028
000033
000044
000049
000053
000057
000059
000060
000061
000062
000067
000068
000072
000074
 |  |  | Total Students:
Spreadsheet: 691846d1597917823-from-a-set-target-number-search-multple-collums-and-rows-for-a-match-within-a-set-tolerance-workbook-15
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tolerance
target |  |  |  |  |  |  |  | target |  |  |  |  |  |  |  |  | target |  |  |  |  |  |  |  | target |  |  |  |  |  |  | 1
179 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1122.62
135 |  |  |  |  |  |  |  | 252.21
222 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  |  | 2075.16 |  |  |  |  |  |  |  | 22
Spreadsheet: 45822d1244615372-lookup-or-index-sample
Sheet: RAW DATA

 | RAW DATA (From an external program)
 | 2009-03-01 00:00:00 | 2009-03-08 00:00:00 | 2009-03-15 00:00:00 | 2009-03-22 00:00:00 | 2009-03-29 00:00:00 | 2009-04-05 00:00:00 | 2009-04-12 00:00:00 | 2009-04-19 00:00:00
7QLD | 47.1 | 26.5 | 0 | 22.1 | 19.1 | 0 | 39.6 | 13.7
9QLD | 128.6 | 102.8 | 0 | 109.5 | 36.5 | 133.5 | 179.5 | 145.6
10QLD | 0 | 33.5 | 0 | 13.7 | 0 | 0 | 27.6 | 0
Spreadsheet: 237823d1369318469-macro-to-create-reporting-oldstockreportsample
Sheet: Master

SUPPLIER | STOCK # | [NAME] | DESIGN_# | COST | SALES_PRICE | DISC_$ | LIST_PRICE | MRK_UP | GROSS_PROFIT | GP_% | DATE_IN | DATE_SOLD | #_DAYS
GRP | 001-130-01191 | men's ring | gr909 | -6250 | -11500 | -4000 |  |  |  |  | 2012-11-13 00:00:00 | 2013-01-06 00:00:00
FRD | 120004241 | lady's ring | frd5821 | 488 | 895.5 | 99.5 |  |  |  |  | 2012-09-18 00:00:00 | 2013-03-05 00:00:00
KLH | ? | necklace | kl-5635231 | 189 | 472.5 | 52.5 |  |  |  |  | 2012-02-08 00:00:00 | 2012-12-04 00:00:00
FRD | ? | ROW NECKLACE | frd41247 | -334 | -795 | 0 |  |  |  |  | 2013-01-21 00:00:00 | 2013-01-30 00:00:00
MDT | ? | DROP EARRINGS | MD2582 | 70.21 | 171 | 19 |  |  |  |  | 2011-11-02 00:00:00 | 2013-05-01 00:00:00
LOR | 121003138 | TOPAZ EARRINGS | LOR522427 | 142 | 315 | 35 |  |  |  |  | 2012-11-12 00:00:00 | 2013-04-08 00:00:00