tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862987d1710531168-simple-sumif-not-working-sumif-question
Sheet: Sheet1

Name | Jan  Simple | Feb  Simple | [NAME] | Jan  Detailed | Feb  Detailed | [NAME] | # [NAME] | # [NAME] Detailed |  |  |  | [NAME] | Sue | [NAME]
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Total Simple
[NAME] | 0 | 0 | 0 | 0 | 1 | 0 |  |  |  |  | Total Detailed
[NAME] | 1 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Grand Total
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | Why does this formula not work?  I think I should get 2 for [NAME], 3 for [NAME] and 5 for [NAME]
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"Jim",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"Sue",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  | =SUMIF(A2:A25,"John",H2:I25)
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 1
Sue | 1 | 1 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
Sue | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 1 | 1 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 1 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 857e22f4-3fe7-4ff9-b49c-408ff0b26bb1
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
43609690 | 2014-10-16 22:08:37 | AXIS | 1 | 6 | 5 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43610077 | 2014-10-16 22:29:02 | ALLIES | 1 | 6 | 3 | 615831 | cedroxx | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
43666931 | 2014-10-20 22:10:00 | AXIS | 1 | 10 | 7 | 766400 | Shellshock58 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
Spreadsheet: 36495d1234373263-multiple-record-dget-multiple-record-dget
Sheet: Sheet1

A | Car | Lookup value: | A | Car
B | Bus |  |  | Rocket
C | Airplane |  |  | Ship
D | Helicopter |  |  | #N/A
A | Rocket |  |  | #N/A
C | Boat |  |  | #N/A
A | Ship |  |  | #N/A
B | Motorbike |  |  | #N/A
Spreadsheet: 541101d1507120281-need-formula-to-find-a-text-in-a-string-sample
Sheet: Sheet1

Source | Result Should be
[NAME] Downloads\\NC Alamance 2017-07-03-P291254 [1] [445000126].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-05-P291254 [1] [283554430].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-11-P291254 [1] [363502859].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-10-P291254 [1] [277246052].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-11-P291254 [1] [605742242].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-11-P291254 [1] [482801793].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-12-P291254 [1] [452805064].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-13-P291254 [1] [860445085].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-14-P291254 [1] [162922328].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-14-P291254 [1] [311429032].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-17-P291254 [1] [794825797].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-18-P291254 [1] [654136657].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-19-P291254 [1] [808086627].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-20-P291254 [1] [821974222].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-24-P291254 [1] [653353982].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-25-P291254 [1] [914077604].zip | Web Downloads
[NAME] Downloads\\NC Alamance 2017-07-26-P291254 [1] [549335426].zip | Web Downloads
\\\\10.123.221.21\\5-Thursday\\KY Adair 2017-08-03-4665733 [000].zip | 5- Thursday
\\\\10.123.221.21\\2-Tuesday\\KY Adair 2017-09-05-4705237 [000].zip | 2- Tuesday
\\\\10.123.221.21\\5-Friday\\ID Adams 2017-07-07-4635769 [000].zip | 5- Friday
\\\\10.123.221.21\\4-Thursday\\ID Adams 2017-07-13-4641738 [000].zip | 4- Thursday
\\\\10.123.221.21\\5-Friday\\ID Adams 2017-07-21-4651045 [000].zip | 5- Friday
\\\\10.123.221.21\\3-Wednesday\\ID Adams 2017-07-26-4655952 [000].zip | 3- Wednesday
\\\\10.123.221.21\\4-Thursday\\ID Adams 2017-08-03-4665250 [000].zip | 4- Thursday
\\\\10.123.221.21\\5-Friday\\ID Adams 2017-08-11-4675425 [000].zip | 5- Friday
\\\\10.123.221.21\\4-Thursday\\ID Adams 2017-08-17-4682171 [000].zip | 4- Thursday
\\\\10.123.221.21\\4-Thursday\\ID Adams 2017-08-24-4690655 [000].zip | 4- Thursday
Spreadsheet: 853048d1703003777-formula-to-pick-character-based-on-name-and-date-my-requirements_lgs_b
Sheet: Sheet1

LIST OF STAFF |  |  |  |  |  |  |  |  | MY REQUIREMENTS
NAME | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00 | 2024-01-06 00:00:00 | 2024-01-07 00:00:00 |  | ABSENT | LEAVE | MEDICAL
A | ABSENT |  |  |  |  | LEAVE | LEAVE |  | 1 | 2
B |  |  | ABSENT | MEDICAL |  |  |  |  | 1 |  | 1
C | MEDICAL |  | MEDICAL |  |  | ABSENT |  |  | 1 |  | 2
D | ABSENT |  |  | MEDICAL |  |  | LEAVE |  | 1 | 1 | 1
Spreadsheet: 182094d1348261037-need-help-with-formatting-data-book2
Sheet: Data

 | address | phone | profile info | suggestions | interests
[NAME] | 12 Cobb Way | 123-1234 | tall | Play basketball | knitting
[NAME] | 23 Cobb Way | 279-2026 | short | Swim more | cross stitch
[NAME] | 45 Cobb Way | 186-7688 | tall | Run more | jacks
[NAME] | 11 Crisp Way | 196-5191 | short | Try boxing | sewing
Mark | 14 Crisp Way | 420-1230 | tall | Hopscotch | quilting
[NAME] | 37 Lonely Drive | 453-1180 | short | Go out for Wrestling | Frisbee
[NAME] | 67 Lonely Drive | 227-9486 | tall | Play Video Games | Grocery Shopping
[NAME] | 51 Prime Avenue | 538-0832 | short | Do nothing | Nothing
Spreadsheet: 73236d1273860550-last-3-cells-in-a-column-lastthreeweekssummary
Sheet: Data

week | # of xxx | # of yyy | # of zzz
2 | 15 | 20 | 25
3 | 20 | 25 | 30
4 | 5 | 5 | 10
5 | 1 | 2 | 3
6 | 5 | 8 | 9
Spreadsheet: 736120d1623354782-historical-stock-inventory-pricing-by-unit-triple-lookup-criteria-find-most-recent-amount-ripvanbob-
Sheet: Transactions

Date | Type | Stock | Transacted Units | Transacted Price (per unit) | Fees | Stock [NAME] | Previous Units | Cumulative Units | Transacted Value | Previous Cost | Cost of Transaction | Avg Stock Price | Cumulative Cost | Gains/Losses from Sale | [NAME] %
2000-04-03 00:00:00 | Buy | PG | 20 | 62 | 0 |  | 0 | 20 | 1240 | 0 | - | - | 1240 | 0
2004-06-21 00:00:00 | Split | PG | 20 | 0 | 0 | 2 | 20 | 40 | 0 | 1240 | - | - | 1240 | 0
2020-07-22 00:00:00 | Buy | DIA | 55 | 269.2 | 0 |  | 0 | 55 | 14806 | 0 | - | - | 14806 | 0
2020-07-22 00:00:00 | Buy | QQQ | 100 | 264.06 | 0 |  | 0 | 100 | 26406 | 0 | - | - | 26406 | 0
2020-07-22 00:00:00 | Buy | SPY | 60 | 325.93 | 0 |  | 0 | 60 | 19555.8 | 0 | - | - | 19555.8 | 0
2020-07-22 00:00:00 | Buy | TQQQ | 45 | 117.52 | 0 |  | 0 | 45 | 5288.4 | 0 | - | - | 5288.4 | 0
2020-07-22 00:00:00 | Buy | UCO | 125 | 32.3 | 0 |  | 0 | 125 | 4037.5 | 0 | - | - | 4037.5 | 0
2020-07-22 00:00:00 | Buy | UDOW | 60 | 71.28 | 0 |  | 0 | 60 | 4276.8 | 0 | - | - | 4276.8 | 0
2020-07-22 00:00:00 | Buy | UMDD | 75 | 54.82 | 0 |  | 0 | 75 | 4111.5 | 0 | - | - | 4111.5 | 0
2020-07-22 00:00:00 | Buy | UPRO | 80 | 51.99 | 0 |  | 0 | 80 | 4159.2 | 0 | - | - | 4159.2 | 0
2020-07-22 00:00:00 | Buy | URTY | 115 | 35.34 | 0 |  | 0 | 115 | 4064.1 | 0 | - | - | 4064.1 | 0
2020-07-22 00:00:00 | Buy | VTWO | 125 | 119.13 | 0 |  | 0 | 125 | 14891.25 | 0 | - | - | 14891.25 | 0
2021-01-21 00:00:00 | Split | TQQQ | 0 | 0 | 0 | 2 | 45 | 90 | 0 | 5288.4 | - | - | 5288.4 | 0
2021-01-28 00:00:00 | Sell | DIA | 2 | 307.61 | 0 |  | 55 | 53 | 615.22 | 14806 | 538.4 | 269.2 | 14267.6 | 76.82 | 0.1427
2021-01-28 00:00:00 | Sell | QQQ | 2 | 323.1 | 0 |  | 100 | 98 | 646.2 | 26406 | 528.12 | 264.06 | 25877.88 | 118.08 | 0.2236
2021-01-28 00:00:00 | Sell | SPY | 1 | 379.67 | 0 |  | 60 | 59 | 379.67 | 19555.8 | 325.93 | 325.93 | 19229.87 | 53.74 | 0.1649
2021-01-28 00:00:00 | Sell | TQQQ | 5 | 98.46 | 0 |  | 90 | 85 | 492.3 | 5288.4 | 293.8 | 58.76 | 4994.6 | 198.5 | 0.6756
2021-01-28 00:00:00 | Sell | UCO | 10 | 41.45 | 0 |  | 125 | 115 | 414.5 | 4037.5 | 323 | 32.3 | 3714.5 | 91.5 | 0.2833
2021-01-28 00:00:00 | Sell | UDOW | 5 | 104.45 | 0 |  | 60 | 55 | 522.25 | 4276.8 | 356.4 | 71.28 | 3920.4 | 165.85 | 0.4653
2021-01-28 00:00:00 | Sell | UMDD | 5 | 111.21 | 0 |  | 75 | 70 | 556.05 | 4111.5 | 274.1 | 54.82 | 3837.4 | 281.95 | 1.0286
2021-01-28 00:00:00 | Sell | UPRO | 5 | 79.92 | 0 |  | 80 | 75 | 399.6 | 4159.2 | 259.95 | 51.99 | 3899.25 | 139.65 | 0.5372
2021-01-28 00:00:00 | Sell | URTY | 5 | 95.95 | 0 |  | 115 | 110 | 479.75 | 4064.1 | 176.7 | 35.34 | 3887.4 | 303.05 | 1.7151
2021-01-28 00:00:00 | Sell | VTWO | 3 | 169.86 | 0 |  | 125 | 122 | 509.58 | 14891.25 | 357.39 | 119.13 | 14533.86 | 152.19 | 0.4258
2021-04-19 00:00:00 | Buy | YYY | 80 | 17.16 | 0 |  | 0 | 80 | 1372.8 | 0 | - | - | 1372.8 | 0
2021-04-20 00:00:00 | Split | VTWO | 0 | 0 | 0 | 2 | 122 | 244 | 0 | 14533.86 | - | - | 14533.86 | 0
Spreadsheet: 30866d1226572453-pushing-data-across-column-when-new-data-it-entered-pushdata2
Sheet: Sheet1

 | A |  | B | C | D | E | F | G | H | I | J | K
 | 3 |  | 3 | 0 | 5 | 9 | 10 | 12 | 18 | 16 | 15 | 12
Spreadsheet: 687657d1595337034-sumproduct-if-conditions-are-met-example
Sheet: Sheet1

 | Prelim | Prelim | Classification | Classification | Classification | Classification |  |  | V026 |  |  | 8
Location | Core Logging | Core Photography | Natural Moisture Content | Bulk & Dry Density | [NAME] (4 Point Method) | PSD (wet sieve to 63 micron) |  |  | V026 |  |  | 4
V026 | 0.8 | 1 | 1 | 1 |  | 1
V026 | 0.2
V026 | 0.8 |  | 2 | 2 |  | 1
V026 | 0.2
V026 | 0.7999999999999998 |  | 2 | 2 | 1 | 1
V026 | 0.2000000000000002
V026 | 1 |  | 1 | 1 |  | 1
V026 | 1
V030 | 0.72 | 1 | 1 | 1 |  | 1
V030 | 0.2000000000000001
V030 | 0.7999999999999999 |  | 2 | 2 |  | 1
V030 | 0.2
V030 | 0.8000000000000003 |  | 2 | 2 |  | 1
V030 | 0.1999999999999997
V030 | 1.14 |  | 2 | 2
V033 | 0.8 | 1 | 1 | 1 |  | 1
V033 | 0.2
V033 | 0.8 |  | 2 | 2 |  | 1
V033 | 0.2
V033 | 0.7999999999999998 |  | 2 | 2 |  | 1
V033 | 0.2000000000000002
V033 | 1 |  | 1 | 1
V033 | 1.02
V034 | 0.8 | 1 | 1 | 1 |  | 1
V034 | 0.2
Spreadsheet: 874131d1720699940-creating-a-table-of-information-from-a-data-set-based-on-certain-criteria-excel-help
Sheet: Yearly Plan

 |  | SERVICE SCHEDULE
 |  | UNIT
WEEK |  |  |  |  | 123 |  | HIJ |  |  | DEF | 456 | 987
 |  | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T IVECO | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania | 44T Scania
2523 | 2024-01-01 00:00:00 | P | M | T | CP |  | CF |  |  |  | CM | CT
2623
2723 |  |  |  |  | CM
2823
2923 |  |  |  |  |  |  |  |  |  | CP
3023 |  |  |  |  |  |  | CT
3123
Spreadsheet: 583776d1532635975-index-match-for-sheet-name-in-another-workbook-md_de_dash-forum_help
Sheet: 063600-020

07/24/18
10:47 AM |  |  |  |  |  | 12 Month Actual
 |  |  |  |  |  | DE
063600-020 |  |  |  |  |  | For the Month Ending June 30, 2018
 | July | August | September | October | November | December | January | February | March | April | May | June | Year to Date
Operating Income | 240996 | 230803 | 221130 | 230662 | 219010 | 217297 | 210853 | 193877 | 230283 | 222739 | 226003 | 234722 | 2678375
Personnel Expenses | 69032 | 69611 | 68842 | 70847 | 76296 | 71618 | 75013 | 69869 | 74155 | 72506 | 73886 | 70133 | 861808
Operating Expenses | 128264 | 152161 | 120969 | 136782 | 143850 | 132897 | 118155 | 116492 | 137671 | 137599 | 136365 | 136344 | 1597549
Total Direct Expenses | 197296 | 221772 | 189811 | 207629 | 220146 | 204515 | 193168 | 186361 | 211826 | 210105 | 210251 | 206477 | 2459357
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Program Operating Margin | 43700 | 9031 | 31319 | 23033 | -1136 | 12782 | 17685 | 7516 | 18457 | 12634 | 15752 | 28245 | 219018
Program Operating % | 0.181330810469883 | 0.0391286075137672 | 0.141631619409397 | 0.0998560664522115 | -0.00518697776357244 | 0.0588227172947625 | 0.0838735991425306 | 0.0387668470215652 | 0.0801492077139867 | 0.0567210950933604 | 0.0696981898470374 | 0.120333841736182 | 0.965125623931111
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Overhead Expenses | 21745 | 18997 | 19274 | 19457 | 19808 | 20881 | 17540 | 20063 | 16882 | 19393 | 18434 | 21172 | 233646
Total Expenses | 219041 | 240769 | 209085 | 227086 | 239954 | 225396 | 210708 | 206424 | 228708 | 229498 | 228685 | 227649 | 2693003
 | - | - | - | - | - | - | - | - | - | - | - | - | -
Income Over/Under Expenses | 21955 | -9966 | 12045 | 3576 | -20944 | -8099 | 145 | -12547 | 1575 | -6759 | -2682 | 7073 | -14628
 | = | = | = | = | = | = | = | = | = | = | = | = | =
6020 Population | 24 | 25 | 25 | 24 | 24 | 26 | 27 | 28 | 29 | 29 | 29 | 0
6021 Population | 29 | 29 | 30 | 31 | 30 | 25 | 23 | 23 | 27 | 27 | 27 | 0
6022 Population | 22 | 20 | 16 | 19 | 15 | 16 | 17 | 16 | 15 | 15 | 14 | 0
Spreadsheet: 00ff0bbb-7eeb-4a74-b13f-bb0d246df010
Sheet: Students

BIKE RENTAL INFORMATION
Group Name:
Event Date:
Time of Arrival:
Students:
Changes |  |  | General Information | Guide Information |  |  |  |  |  | Rentals Information
 |  |  |  | Rider Type
Add | Delete |  | Name | Novice | Intermediate | Adv/Expert | Gender | Age | Height (Feet/Inches) or (cm) |  | Weight (lbs) or (kg)
EXAMPLE |  |  | [NAME] |  | x |  | M | 11 | 5 | 2 | 115
 |  | 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
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
 |  | 40
 |  | 41
 |  | 42
 |  | 43
 |  | 44
 |  | 45
 |  | 46
 |  | 47
 |  | 48
 |  | 49
 |  | 50
 |  | 51
 |  | 52
 |  | 53
 |  | 54
 |  | 55
Spreadsheet: 43113fbd-ac04-478f-be12-cdeb6a2ed10b
Sheet: 7c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Basis | 1784283 | 1218814 | 1940647 | 2705946 | 3545260 | 1619745 | 1121131 | 90299 | 14026125
Fixed-Float | 16719337 | 6977563 | 13156558 | 27471704 | 61759935 | 42992236 | 19338236 | 2034127 | 190449696
FRA | 27796807 | 12903237 | 12916085 | 3967026 | 326374 | - | - | - | 57909529
OIS | 13086262 | 6207425 | 7020438 | 6257367 | 2087166 | 327940 | 184715 | 15684 | 35186997
Swaption | 3286921 | 1500879 | 2401222 | 3171729 | 4135863 | 2007264 | 913219 | 12226 | 17429323
OTHER* | 2429094 | 1142195 | 1496049 | 2219451 | 4556938 | 3892309 | 2360673 | 172774 | 18269483
TOTAL | 65102704 | 29950113 | 38930999 | 45793223 | 76411536 | 50839494 | 23917974 | 2325110 | 333271153
*OTHER variable includes the following products: Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: sally_beck__34335__Cashflow Forecast Estate 12-18r
Sheet: O&M Detail 2002

OPERATING EXPENSES - Cash Basis
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  |  | 2002-01-31 00:00:00 |  | 2002-02-28 00:00:00 |  | 2002-03-31 00:00:00 |  | 2002-04-30 00:00:00 |  | 2002-05-31 00:00:00 |  | 2002-06-30 00:00:00 |  | 2002-07-31 00:00:00 |  | 2002-08-31 00:00:00 |  | 2002-09-30 00:00:00 |  | 2002-10-30 00:00:00 |  | 2002-11-30 00:00:00 |  | 2002-12-31 00:00:00 |  | Year
Headcount
 | Full Time
 | Part Time
 | Temporary
 | VOE / Student Learners
 | 3rd Party Contractors
 |  | Total
Salaries, Wages & Benefits
 | Salaries & Wages
 | Benefits
 |  | Total
Severance
Employee  Expenses
 | Individual and Group Meals - Non-Client
 | Group Entertainment - Non-Client
 | Client and Recruiting Meals & Entertainment
 | Travel-Airfare
 | Travel-Lodging
 | Travel-Meals
 | Travel-Other
 | Other employee expenses
 |  | Total
Outside Services
 | Outside Services-Legal
 | Outside Services-IT
 | Outside Services-Audit
 | Outside Services-Tax
 | Outside Services-Accounting
 | Outside Services-Other
 |  | Total
Technology Expense
 | Computer Expense
 | Other
 |  | Total
Other Operating Expenses
 | Rent (cash exp only)
 | Analyst / Associate Allocation
 | Advertising
 | Communications Expense
 | Supplies & Expenses
 | Subscriptions & Publications
 | Charitable Contributions
 | Other Operating Expenses
 |  | Total
Taxes Other Than Income
 | Payroll Taxes
 | Property Taxes
 | Other Taxes
 |  | Total
(Allocation) to NETco
 | Salaries, Wages & Benefits
 | Employee  Expenses
 | All Other
 |  | Total
TOTAL OPERATING EXPENSES
Spreadsheet: 57572d1257784184-excel-2007-visual-representation-of-rota-copy-of-4-week-rota-v2
Sheet: Basic rota layout

Keepers Crescent 4 week rolling rota.
Key | red text = admin but in-house to be 4th person for activities to take place |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: The weekend 'needed' shifts are part of our contracted hours and are available for Keepers Crescent staff to pick up, other service's staff, then relief staff, and then (as a last resort) agency staff.
 | Blue text = Admin
 | This version to be used from:
Spreadsheet: 30487d1226000825-sum-cells-which-have-font-color-red-conditionalformatting1
Sheet: Sheet1

Amount | Expected Date
3500 | 2008-11-13 00:00:00
132500 | 2008-11-11 00:00:00
3500 | 2008-11-16 00:00:00
23600 | 2008-11-11 00:00:00
2500 | 2008-11-14 00:00:00
500 | 2008-11-26 00:00:00
1500 | 2008-11-23 00:00:00
3500 | 2008-11-08 00:00:00
13230 | 2008-11-09 00:00:00
750000 | 2008-11-05 00:00:00
Total of Red Cells (Amount)
Spreadsheet: 24530d1215005895-duplicate-cells-with-different-values-wine-example
Sheet: Sheet1

Vintage | Wine | Appellation | Size | Qty (Blles) | Price | Negociant | Updated
2005 | Leoville las Cases | [NAME] | 0.75 | 84 | 355 | Negociant A | 2008-06-22 00:00:00
2005 | Leoville las Cases | [NAME] | 0.75 | 48 | 385 | Negociant B | 2008-06-22 00:00:00
2005 | Leoville las Cases | [NAME] | 0.75 | 120 | 350 | Negociant D | 2008-06-22 00:00:00
2005 | Leoville las Cases | [NAME] | 0.75 | 120 | 350 | Negociant F | 2008-06-22 00:00:00
2005 | Leoville las Cases | [NAME] | 1.5 | 48 | 650 | Negociant B | 6.27.2008
2005 | Leoville las Cases | [NAME] | 1.5 | 36 | 750 | Negociant C | 6.27.2008
2005 | Leoville las Cases | [NAME] | 1.5 | 6 | 700 | Negociant D | 6.27.2008
2005 | Leoville las Cases | [NAME] | 1.5 | 18 | 725 | Negociant G | 6.27.2008
Spreadsheet: 864658d1711735499-excel-formula-dynamically-auto-fill-with-reference-column-filter
Sheet: Sheet1

Department | Country | Index
HR | Australia | 1
HR | Srilanka | 2 |  |  | Planning
Planning | India | 3
Planning | America | 4 |  |  | Country | Sum
Planning | UK | 5
Planning | Germany | 6 |  |  | America |  | 8
Planning | Belguim | 7 |  |  | UK |  | 10
Performance | Netherlands | 8 |  |  | Germany |  | 12
Performance | France | 9 |  |  | Belguim |  | 14
Performance | Poland | 10
Performance | Ireland | 11
Performance | Japan | 12
Performance | Austria | 13
Performance | Italy | 14
Performance | Swiss | 15
HR | Australia | 1
HR | Srilanka | 2
Planning | India | 3
Planning | America | 4
Planning | UK | 5
Planning | Germany | 6
Planning | Belguim | 7
Performance | Netherlands | 8
Performance | France | 9
Performance | Poland | 10
Performance | Ireland | 11
Performance | Japan | 12
Performance | Austria | 13
Performance | Italy | 14
Performance | Swiss | 15
Spreadsheet: 134450d1325287898-matching-values-from-2-columns-and-returning-the-value-in-3rd-column-my-data-v2
Sheet: Main

 |  | YTD | [NAME] | Training
CIS Billing & Clarity | [NAME] | FY12 TEAM TARGET  (All counted from From 1/10/11) | > 88.5% | > 5 Training Creation | > 15 Training Delivery
[NAME] | Smith, [NAME] | [NAME], [NAME] | #N/A | 0 | 0
 |  | Effort %
[NAME] | Jones, Alec | Jones, Alec | #N/A | 0 | 0
 |  | Effort %
 |  | TOTAL | #N/A | #N/A | #N/A
Spreadsheet: 462049d1463847596-keep-only-one-cell-active-involves-locked-cells-links-led
Sheet: Tape Calculator (2)

 |  |  |  |  |  | Web Links
 | Run Length | Total Watts in Run | TW+20% | Driver to Use |  | Power | [NAME]
 | Single Color |  |  |  |  | Web Links
 | Run Length | Total Watts in Run | TW+20% | Driver to Use |  | Power | [NAME]
 |  |  |  | [NAME]
 | LED Tape |  |  | [NAME]
 | 24 Volt |  |  | Blue |  |  |  |  |  |  | 4 in link??
 | Power Calculator |  |  | Red
 | 16 ft [NAME] (rated) |  |  | Green |  |  |  |  |  |  | 4 in link??
 | 18 ft RGB -  21 ft Single (Actual) |  |  | Yellow |  |  |  |  |  |  | 4 in link??
 | Enter Run Length: |  |  | 1
Spreadsheet: 7760bc41-686d-44b5-b56a-0ccc690d41a6
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
GCLIP | Test | GCLIP | Phospholipid (Cardiolipin) Antibodies, IgG, Serum | Phospholipid Ab IgG, S | Enzyme-Linked Immunosorbent Assay (ELISA) | Serum Gel Tube: SGT OR |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; [NAME] OK Other	NA | <10.0 GPL (negative) 10.0-14.9 GPL (borderline) 15.0-39.9 GPL (weakly positive) 40.0-79.9 GPL (positive) > or =80.0 GPL (strongly positive) GPL refers to IgG Phospholipid Units. One GPL unit is 1 microgram of IgG antibody.  Reference values apply to all ages. | Monday through Saturday; 4 p.m. | Same day/1 day | 3 days | 1 | 86147 |  |  |  |  | Rochester
GCLIP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 21 days
GCLIP | Result | GCLIP | Phospholipid Ab IgG, S | Phospholipid Ab IgG, S | Numeric |  |  |  |  | GPL |  |  |  |  |  |  |  |  |  | 3286-2 | [NAME].[NAME]:ACnc:Pt:Ser:Qn:EIA
Spreadsheet: 0567f1ae-183b-4019-be82-0c0a5259758a
Sheet: Sheet1

Table 3 - World sugar production, supply, and distribution (continued) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Country/Mktg year | Beginning | Total sugar | Total | Total | Total | Total | Ending
 | stocks | production | imports | supply | exports | use | stocks
World
2008/09 | 43650 | 143888 | 44859 | 232397 | 47881 | 152955 | 31561
2009/10 | 31561 | 153517 | 51194 | 236272 | 51902 | 154521 | 29849
2010/11 | 29849 | 161642 | 51921 | 243412 | 56088 | 156766 | 30558
2011/12 | 30558 | 170967 | 48870 | 250395 | 57819 | 160965 | 31611
2012/13 | 31611 | 174453 | 49105 | 255169 | 58326 | 163761 | 33082
Unrecorded
2008/09 | ' ' | ' ' | ' ' | 3022 | ' ' | ' ' | ' '
2009/10 | ' ' | ' ' | ' ' | 708 | ' ' | ' ' | ' '
2010/11 | ' ' | ' ' | ' ' | 4167 | ' ' | ' ' | ' '
2011/12 | ' ' | ' ' | ' ' | 8949 | ' ' | ' ' | ' '
2012/13 | ' ' | ' ' | ' ' | 9221 | ' ' | ' ' | ' '
Source: USDA, FAS, PSD online.
Spreadsheet: 721956d1614963677-odd-calculation-formula-for-profit-margin-please-help-cost-calc-formula
Sheet: Sheet1

 |  |  |  |  |  | Profit margin
Sku | Sold Price | Ship Cost | Additional fees | Item Cost |  | Website | eBay & Amazon |  |  | Additional Funds needed to make 15% profit margin (on total amount paid - Including additional amount)
ASX07 105 | 60 | 18.78 | 0 | 22.39
ASX07 005 | 85 | 20.5 | 5 | 29.91
ASX02 120 | 32 | 8 | 0 | 13.87
abc123 | 46 | 18.78 | 0 | 22.39
efg456 | 15 | 20.5 | 5 | 29.91
SAMPLE of How I would like it to calculate |  |  |  |  |  |  |  |  |  |  | % Margin
hij789 | 22 | 8 | 0 | 13.87 |  |  |  |  |  | 3.9
Total Paid with additional funds ->