tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 688343d1595726935-extract-list-with-formulas-data-label-list-by-month
Sheet: Sheet1

Launch Date | Brand | Item Name
2019-01-01 00:00:00 | Brand A | A0001
2019-01-01 00:00:00 | Brand A | A0002
2019-01-01 00:00:00 | Brand A | A0003
2019-01-01 00:00:00 | Brand C | C0001
2019-01-01 00:00:00 | Brand C | C0002
2019-05-01 00:00:00 | Brand C | C0003
2019-05-01 00:00:00 | Brand C | C0004
2019-05-01 00:00:00 | Brand D | D0001
2019-05-01 00:00:00 | Brand D | [NAME]
2019-05-01 00:00:00 | Brand D | D0003
2019-07-01 00:00:00 | Brand B | B0001
2019-07-01 00:00:00 | Brand B | B0002
2019-07-01 00:00:00 | Brand B | [NAME]
2019-07-01 00:00:00 | Brand B | B0004 |  |  | 2019-01-01 00:00:00
2019-08-01 00:00:00 | Brand A | A0004 |  | New SKUs
2019-08-01 00:00:00 | Brand A | A0005 |  | Cum. # SKUs
2019-08-01 00:00:00 | Brand A | A0006 |  |  | Brand A |  |  |  | Brand C |  | Brand B | Brand A | Brand A |  | Brand D | Brand D
2019-08-01 00:00:00 | Brand B | B0005 |  |  | A0001 |  |  |  | C0003 |  | B0001 | A0004 | A0007 |  | D0004 | D0005
2019-09-01 00:00:00 | Brand A | A0007 |  |  | A0002 |  |  |  | C0004 |  | B0002 | A0005
2019-09-01 00:00:00 | Brand E | E0003 |  |  | A0003 |  |  |  |  |  | [NAME] | A0006 | Brand E |  | Brand E
2019-09-01 00:00:00 | Brand E | E0004 |  |  |  |  |  |  | Brand D |  | B0004 |  | E0003 |  | E0001
2019-11-01 00:00:00 | Brand D | D0004 |  |  | Brand C |  |  |  | D0001 |  |  | Brand B | E0004 |  | E0002
2019-11-01 00:00:00 | Brand E | E0001 |  |  | C0001 |  |  |  | [NAME] |  |  | B0005
2019-11-01 00:00:00 | Brand E | E0002 |  |  | C0002 |  |  |  | D0003
2019-12-01 00:00:00 | Brand D | D0005
Spreadsheet: 106702d1303917415-calculate-comm-based-on-full-collection-within-60days-samplesalescommision
Sheet: Sheet1

Traget Sales
Mth | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00
Sales Target | 7000 | 7000 | 7000 | 8000 | 8000 | 8000
Sales Achieved
% Target
Commission Possible %
Collection Achieved
Commission Actual %
Sales Summary
Date | Inv | Customer | [NAME] | Sales amt | GST | Inv Amt | Commission Amt |  | Collection | Collection | Collection
 |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00
2011-01-01 00:00:00 | INV0001 | AAA | A | 1000 |  |  |  |  | 1000 | 0 | 0
2011-01-02 00:00:00 | INV0002 | AAB | A | 1500 |  |  |  |  | 500 | 500 | 500
2011-01-03 00:00:00 | INV0003 | AAC | A | 2000 |  |  |  |  | 2000 | 0 | 0
2011-01-04 00:00:00 | INV0004 | ABB | B | 2500 |  |  |  |  | 800 | 1000 | 100
2011-02-05 00:00:00 | INV0005 | ABC | B | 3000 |  |  |  |  | 0 | 2700 | 300
2011-02-06 00:00:00 | INV0006 | ACC | B | 3500 |  |  |  |  | 0 | 5000 | 0
2011-02-07 00:00:00 | INV0007 | BBB | C | 4000 |  |  |  |  | 0 | 4000 | 0
2011-03-08 00:00:00 | INV0008 | BBA | C | 4500 |  |  |  |  | 0 | 0 | 4000
2011-03-09 00:00:00 | INV0009 | [NAME] | C | 5000 |  |  |  |  | 0 | 0 | 5000
2011-03-10 00:00:00 | INV0010 | BAB | C | 5500 |  |  |  |  | 0 |  | 5000
Commission Table
1) Calculate based on full Collection on the Sales amt (exclude the GST)
2) Within 60 days due for the collection
Base Commission | 0.07
Sales Target  (%) | Comm Rate (%)
0.8 | 1
0.9 | 1.5
1 | 2
1.2 | 3
Spreadsheet: 133769d1324591666-find-a-value-in-a-range-examplespreadsheet
Sheet: Sheet1

0003
0004
0007
0008
0011
0012
0014
0015
0016
0019
0020
0021
0100
0116
0122
0300
0301
0302
0304
0305
0308
0311
0312
0313
0315
0320
0322
0324
0334
0337
0340
0341
0343
0345
0349
0350
Spreadsheet: 778226d1650929759-shift-pattern-dropdown-list-and-auto-populate-calendar-scheduler-draft-missja-
Sheet: Shifts Details

 | Shifts Details
 |  |  | A | B | C | D | E | F | G | H
 | ROSTERS > |  | Shift A | Shift B | Shift C | Shift D | Shift E | Shift F | Shift G | Shift H
 |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Day | Shift Name | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift | Day Shift
 |  | Code | D | D | D | D | D | D | D | D
 |  | Time of Shift | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM | 5:00 AM to 05:00 PM
 | Night | Shift Name | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift
 |  | Code | N | N | N | N | N | N | N | N
 |  | Time of Shift | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM | 05:00 PM to 05:00 AM
 | OFF | Shift Name | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift | Night Shift
 |  | Code | O | O | O | O | O | O | O | O
 |  | Time of Shift
 | Day Off Code |  | x | x | x | x | x | x | x | x
 | Pattern Start Date
 | Shift Pattern |  | doddddd | ddodddd | dddoddd | ddddodd | dddddod | ddddddo | odddddd | ooooddd
Spreadsheet: 45437d1244153877-copying-formulas-from-column-to-column-joe-sales-tracker23
Sheet: Sheet1

 | Chemical |  | density or lbs for pails and totes | $/lb | Jan | Feb | March | April | May | June | July | August | Sept | Oct | Nov | Dec
 | PO5282 | gallons | 9.944 | 0.78
 | NA2260 | gallons | 7.9493 | 4.6
 | 1192 | gallons | 8.5828 | 2.51
 | ADJ575 | pails | 50 | 2.27
 | CT1300 | gallons | 8.034 | 4.09
 | OX909 | totes | 11.2
 | OX1200 | pails | 50 | 5.37
 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | PO5282 | gallons | 9.944 | 0.65
 | 1192 | totes | 7.9493 | 0.97
 | AE1125 | totes |  | 1.57
 | CE1611 | totes | 8.584 | 2.35
 | CDP1301 | gallons
 | PY5200 | gallons | 9.73 | 2.05
 | AZ8104 | gallons | 9.4 | 2.77
 | CDP450 | gallons | 11.92 | 1.1
 | BL5400 | gallons | 12.08 | 1.88
 | CT1300 | totes | 8.034 | 3.71
 | APO520 | totes | 10.052
 | Chemical | gal |  |  | lbs | density | $/lb | total | Order
 | PO5282 | 10 |  |  |  | 9.944 | 0.78 | 77.56320000000001
 | NA2260 |  |  |  |  | 7.9493 | 4.6 | 0
 | 1192 |  |  |  |  | 8.5828 | 2.51 | 0
 | ADJ575 |  |  |  |  |  | 2.27 | 0
 | CT1300 |  |  |  |  | 8.034 | 4.09 | 0
 | OX909 |  |  |  |  | 11.2 |  | 0
 | OX1200 |  |  |  |  |  | 5.37 | 0
 | PO5282 |  |  |  |  | 9.944 | 0.65 | 0
 | 1192 |  |  |  |  | 7.9493 | 0.97 | 0
 | AE1125 |  |  |  |  |  | 1.57 | 0
 | CE1611 |  |  |  |  | 8.584 | 2.35 | 0
 | CDP1301
 | PY5200 |  |  |  |  | 9.73 | 2.05 | 0
 | AZ8104 |  |  |  |  | 9.4 | 2.77 | 0
 | CDP450 |  |  |  |  | 11.92 | 1.1 | 0
 | BL5400 |  |  |  |  | 12.08 | 1.88 | 0
 | CT1300 |  |  |  |  | 8.034 | 3.71 | 0 |  |  | 10
 | APO520 |  |  |  |  | 10.052 |  | 0 |  |  | 10
Spreadsheet: 100575d1298914304-n-a-error-in-vlookup-vlookup-example
Sheet: Sheet1

 | 0 | 665.1416330443435 | 0.001503439192977614 |  | #N/A | 1-0
 | 1 | 102.3294820068221 | 0.009772354754354489
 | 2 | 31.48599446363757 | 0.03176015295165209
 | 3 | 14.5319974447558 | 0.06881366472857953
 | 4 | 8.942767658311261 | 0.1118222051839417
 | 5 | 6.879052044854816 | 0.1453688667391242
 | 6 | 6.349894195250601 | 0.1574829389673846
 | 7 | 6.838347594885262 | 0.1462341576125714
 | 8 | 8.416427809089553 | 0.1188152530602143
 | 9 | 11.65351542797015 | 0.08581101609904364
 | 10 | 17.92848527380023 | 0.05577716046437836
 | 11 | 30.34051354027731 | 0.03295923118349631
 | 12 | 56.01325576666581 | 0.0178529168910605
 | 13 | 112.0265115333316 | 0.00892645844553025
 | 14 | 241.2878709948681 | 0.004144427135424759
 | 15 | 556.8181638343109 | 0.001795918425350729
 | 16 | 1370.629326361381 | 0.0007295918602987338
 | 17 | 3584.722853560534 | 0.0002789615936436335
 | 18 | 9926.924825244556 | 0.0001007361310379788
 | 19 | 29017.16487379177 | 3.44623606182559e-05
 | 20 | 89283.58422705162 | 1.120026720093317e-05
Spreadsheet: 143474d1330438075-excel-2007-rows-from-multiple-sheets-into-one-exclude-those-without-values-safety-tour
Sheet: (24) WWTP

Date: | 1/16 & 1/17 |  | Back to Department Listing
DEPARTMENT/LOCATION: |  | WWTP
 |  | 0
ITEM # | ISSUES FOUND | [NAME] | STATUS | INTERIM SOLUTION
x | emergency light out | [NAME] | carryover
x | spindle needs guarding on pump | pump room | complete
ENVIRONMENT: PROPER HOUSEKEEPING, INSPECTION AND MAINTENANCE, STANDARD OPERATING PROCEDURES - Overall housekeeping was okay
ESCORT:
Spreadsheet: 0904b083-9cf3-4cb2-8200-67cc04fed399
Sheet: Sheet1

Date: | Age/grade:                 K-5 | Lunch | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | COMMENTS/                   RESULTS
 |  | List food from menu that fit into each category |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Results/Totals
Component | New Meal Pattern | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  | Actual Totals | Required Totals (for the week) in cups | Quantity difference (actual vs required) | RESULTS
 |  | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups | Item | cups
FRUIT
FRUIT | ½ cup of Fruit |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 3.5 | -3.5 | DOES NOT MEET
Fruit Totals (for each day |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0
VEGETABLE
VEGETABLES - ¾ cup of vegs/day | ½ cup dark green |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 | ¾ cup of red/orange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.75 | -0.75 | DOES NOT MEET
 | ½ cup of legumes |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
 | ½ cup of starchy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
Required total adds up to 2¾c; weekly total of all vegs  is 5¼c | ½ cup of other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0.5 | -0.5 | DOES NOT MEET
VEG TOTALS (for each day) |  | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 | Daily Requirement | 0 |  | 0 | 5.25 | -5.25 | DOES NOT MEET
Component | New Meal Pattern | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. | Item | oz. eq. |  | Actual Totals | Required Totals (for the week)
GRAINS & BREADS
 | Grains (list all WGR and non-WGR) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 11-12.5 (1 oz eq per day minimum) |  | DOES NOT MEET
 | List only WGR |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Half of all grains must be whole grain |  | MEETS
MEAT / MEAT ALTERNATE |  |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz |  | oz
 | Minimum of 1 oz per day |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 11-14 per week (minimum of 1 oz eq per day) |  | DOES NOT MEET
MILK |  |  | cup |  | cup |  | cup |  | cup |  | cup |  | cup |  | cup
 | Non-fat (flavored or unflavored) or 1% unflavored |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | Offer 1 cup/day |  | DOES NOT MEET
 |  |  |  |  |  |  | 8/31/2012       PDE  Develpoment credit Idaho State Agency with revisions by MARO
Spreadsheet: 117769d1313007195-need-formula-for-price-based-on-quantity-and-product-name-on-a-separate-sheet-example1
Sheet: Sheet1

PURCHASE ORDER # | STYLE | COLOR | QTY ORDERED | SHIP DATE | DELIVERY DATE |  |  | BUDGET
 | NUMBER | NUMBER |  |  | DELIVERY DATE
1 | PRODUCT1 | WHITE | 98 |  |  |  |  | 158.76
2 | PRODUCT2 | BLACK | 67 |  |  |  |  | 117.25
3 | PRODUCT3 | NAVY | 12 |  |  |  |  | 21.6
Spreadsheet: 098abecb-b017-4ccd-90f9-eb9ee3e64bd3
Sheet: Sheet1

Unnamed: 0 | Date: ____________________________ | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | For Office Use Only: | Unnamed: 9
 | Civil Cover Sheet
 | Text to indicate what this cover sheet does (and does not do) according to court rule, any instructions for how to properly fiil out the form, and whether it must be completed by the filing atorney.  See examples from other states at: [NAME]
 | Please check only one box
 | Tort |  |  | Contract |  |  |  |  | Probate/Estate
 | Automobile tort |  |  | Buyer plaintiff |  |  |  |  | Conservatorship/Trusteeship
 | Intentional tort |  |  | Employment - discrimination |  |  |  |  | Guardianship-Adult
 | Malpractice - medical |  |  | Employment - other |  |  |  |  | Guardianship-Juvenile
 | Malpractice - legal |  |  | Fraud |  |  |  |  | Probate/Wills/Intestate
 | Malpractice - other |  |  | Landlord/tenant - Unlawful det. |  |  |  |  | Other Probate/Estate
 | Premises liability |  |  | [NAME]/tenant - Other
 | Product liability - Asbestos |  |  | Mortgage foreclosure |  |  |  |  | Small Claims
 | Product liability - Tobacco |  |  | Seller plaintiff (debt collection) |  |  |  |  | Mental Health
 | Product liability - Other |  |  | Other contract
 | Slander/libel/defamation |  |  |  |  |  |  |  | Miscellaneous Civil
 | Other tort |  |  | Civil Appeals |  |  |  |  | [NAME]
 |  |  |  | Administrative Agency |  |  |  |  | Non-Domestic Restraining Order
 | Real Property |  |  | Other Civil Appeal |  |  |  |  | Tax
 | Eminent domain |  |  |  |  |  |  |  | Other Writs
 | Other real property |  |  |  |  |  |  |  | Other Civil (describe)
 | Jury Demand? (Check only if jury demand is included in petition or attached as a separate pleading)
 | Plaintiff Information: |  |  |  |  | Defendant Information:
 | Name: _______________________________________________ |  |  |  |  | Name: _______________________________________________
 | Address: ______________________________________________ |  |  |  |  | Address: ______________________________________________
 | _____________________________________________________ |  |  |  |  | _____________________________________________________
 | _____________________________________________________ |  |  |  |  | _____________________________________________________
 | Phone: _______________________________ |  |  | Sex:  M       F |  | Phone: _______________________________   Sex:   M     F
 | SSN: _________________________________ |  | DOB: ___________ |  |  | SSN: _________________________________   DOB: __________
 | DL or ID Number: ______________________________________ |  |  |  |  | DL or ID Number: ______________________________________
 | Attorney(s): |  |  |  |  | Attorney(s) (If known):
 | (Firm name, Address, Telephone and Supreme Court ID Number) |  |  |  |  | (Firm name, Address, Telephone and Supreme Court ID Number)
 | Space for any additional instruction, court rules, caveats, or explanations.
Spreadsheet: 717265d1612545100-dynamic-named-range-for-a-non-contiguous-range-dnr_for_noncontig
Sheet: sum

Food | ALAN | BILLY | CATHY |  | ALAN | BILLY | CATHY
apple | 70.55474853515625 | 53.34240341186523
spinach | 19.1922492980957 | 67.8913345336914 | 45.42078399658203
cocoa | 98.53739166259766 | 80.25873565673828
broccoli | 65.2376708984375 | 90.03338623046875 | 23.15966415405273
squash | 42.01113510131836 |  | 55.84447860717773
blueberry | 49.33584213256836 | 45.28281784057617 | 59.779541015625
[NAME] | 15.65493965148926 | 64.30648803710938
orange | 94.22235870361328 | 46.68283462524414 | 72.4007797241211
lemon | 39.71416473388672 |  | 80.5818862915039
lettuce | 22.73047637939453
banana | 85.31307220458984 | 17.29496765136719 | 66.41155242919922
chocolate | 65.60359954833984 | 15.20514488220215 | 68.83580017089844
candy | 44.76734924316406 | 32.99952697753906
pumpkin | 94.30778503417969
radish | 26.89656639099121 | 31.06988716125488
walnut | 78.84426879882812 | 47.21164703369141 | 7.63074779510498
almond | 77.33670806884766 | 5.848085880279541
tofu | 70.5619125366211 | 69.44639587402344 | 73.76341247558594
bread | 23.85267639160156 |  | 91.58826446533203
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(PE) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(PE): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 20010-11
 | Major Group | PE - Pre-Engineering/Engineering
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | na | na | na | na
 |  | Part Time | na | na | na | na
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | na | na | na | na
 | Cert. graduates admitted to a college program |  | na | na | na | na
Associate Degree |  |  | na | na | na | na
 | Assoc. graduates admitted to four-year program |  | na | na | na | na
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | na | na | na | na
Graduates who completed remedial courses during their time at the TCU |  |  | na | na | na | na
Graduates who received A*CF support at some point during their coursework |  |  | na | na | na | na
Notes:
Spreadsheet: 5c130852-c2b4-4f15-b025-37874af598a5
Sheet: Sheet1

ROASTER FOR THE PERIOD OF MARCH TO APRIL
NAME/DATE | MON26 | TUES27 | WED28 | THURS29 | FRI30 | SAT31 | SUN01
ALVIN | P.M | A.M | OFF | OFF | P.M | P.M | P.M
SHAHIL | OFF | P.M | P.M | P.M | OFF | A.M | A.M
ANUSHKA | A.M | OFF | A.M | A.M | A.M | OFF | OFF
TINA | A.M | OFF | A.M | A.M | A.M | OFF | OFF
NAME/DATE | MON02 | TUES03 | WED04 | THURS05 | [NAME] | SAT07 | SUN08
ALVIN | OFF | A.M | P.M | OFF | A.M | P.M | P.M
SHAHIL | P.M | P.M | OFF | P.M | P.M | OFF | OFF
ANUSHKA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
TINA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
NAME/DATE | [NAME] | TUES10 | WED11 | THURS12 | FRI13 | SAT14 | SUN15
ALVIN | OFF | P.M | P.M | P.M | A.M | OFF | OFF
SHAHIL | P.M | OFF | A.M | OFF | P.M | P.M | P.M
TINA | A.M | A.M | OFF | A.M | OFF | A.M | A.M
ANUSHKA | A.M | A.M | OFF | A.M | OFF | A.M | A.M
NAME/DATE | MON16 | TUES17 | WED18 | THURS19 | FRI20 | SAT21 | SUN22
ALVIN | P.M | P.M | OFF | OFF | A.M | P.M | P.M
SHAHIL | OFF | A.M | P.M | P.M | P.M | OFF | OFF
ANUSHKA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
TINA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
NAME/DATE | MON23 | TUES24 | WED25 | THURS26 | FRI27 | SAT28 | SUN29
ALVIN | OFF | P.M | P.M | P.M | A.M | OFF | OFF
SHAHIL | P.M | A.M | OFF | OFF | P.M | P.M | P.M
ANUSHKA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
TINA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
Spreadsheet: 849801d1700188698-ifs-or-if-and-statement-for-multiple-conditions-book4
Sheet: Sheet1

 |  |  | Salaries | 80000 | 75000 | 72500
District | Location | Department | Headcount | Employee1 | Employee2 | Employee3
Boise | BOISE | Body Shop | 6 | 0 | 0 | 0 |  |  | Employee1 | Employee2 | Employee3
Boise | BOISE | NewTrucks | 1 | 0 | 0 | 0 |  |  | Boise | Elko | Las Vegas
Boise | BOISE | Parts | 12 |  | 0 | 0 |  |  | Caldwell | [NAME] | Salina
Boise | CALDWELL | Parts | 6 |  | 0 | 0 |  |  | Ontario | [NAME] | Vernal
Boise | CALDWELL | Service | 3 | 0 | 0 | 0 |  |  | Pocatello | Idaho Falls | Price
Boise | ONTARIO | Parts | 7 |  | 0 | 0
Boise | ONTARIO | Service | 25 | 0 | 0 | 0
Boise | POCATELLO | Parts |  |  | 0 | 0
Boise | IDAHO FALLS | Parts | 12 | 0 |  | 0
[NAME] | ELKO | Parts | 22 | 0 |  | 0
[NAME] | ELKO | Service | 3 | 0 | 0 | 0
[NAME] | HEYBURN | Parts | 22 | 0 |  | 0
[NAME] | HEYBURN | Service | 28 | 0 | 0 | 0
[NAME] | JEROME | Body Shop | 6 | 0 | 0 | 0
[NAME] | JEROME | NewTrucks | 12 | 0 | 0 | 0
[NAME] | JEROME | Parts | 7 | 0 |  | 0
[NAME] | JEROME | Service | 5 | 0 | 0 | 0
[NAME] | JEROME | UsedTrucks | 6 | 0 | 0 | 0
Las Vegas | LASVEGAS | Parts | 7 | 0 | 0
Las Vegas | LASVEGAS | Service | 4 | 0 | 0 | 0
Las Vegas | LASVEGAS | UsedTrucks | 1 | 0 | 0 | 0
Las Vegas | SALINA | Parts | 3 | 0 | 0
Las Vegas | SALINA | Service | 16 | 0 | 0 | 0
Las Vegas | SALINA | Body Shop | 4 | 0 | 0 | 0
Las Vegas | VERNAL | Parts | 6 | 0 | 0
Las Vegas | PRICE | Parts | 3 | 0 | 0
Spreadsheet: 214075d1360792324-need-help-cannot-keep-track-of-occurences-lottery-numbers
Sheet: Sheet2

WINNING NUMBERS |  |  |  |  |  |  | NUMBER | Draw | occurrence
2 | 5 | 6 | 20 | 21 | 26 |  | 1
 |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 3
 |  |  |  |  |  |  | 4
next time 2 and 20 are drawn occurrence |  |  |  |  |  |  | 5
should = 2 not 1 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
how do I keep a running total each time |  |  |  |  |  |  | 8
the same number is drawn |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
 |  |  |  |  |  |  | 13
 |  |  |  |  |  |  | 14
 |  |  |  |  |  |  | 15
 |  |  |  |  |  |  | 16
 |  |  |  |  |  |  | 17
 |  |  |  |  |  |  | 18
 |  |  |  |  |  |  | 19
 |  |  |  |  |  |  | 20
 |  |  |  |  |  |  | 21
 |  |  |  |  |  |  | 22
 |  |  |  |  |  |  | 23
 |  |  |  |  |  |  | 24
 |  |  |  |  |  |  | 25 |  | 5
 |  |  |  |  |  |  | 26 |  | 1
 |  |  |  |  |  |  | 27 |  | 3
 |  |  |  |  |  |  | 28 |  | 5
 |  |  |  |  |  |  | 29 |  | 2
 |  |  |  |  |  |  | 30 |  | 3
 |  |  |  |  |  |  | 31 |  | 4
 |  |  |  |  |  |  | 32 |  | 6 |  | 6
 |  |  |  |  |  |  | 33 |  | 6 |  | 6
 |  |  |  |  |  |  | 34 |  | 2 |  | 2
 |  |  |  |  |  |  | 35 |  | 5 |  | 5
 |  |  |  |  |  |  | 36
 |  |  |  |  |  |  | 37 |  | 3 |  | 3
 |  |  |  |  |  |  | 38 |  | 3 |  | 3
 |  |  |  |  |  |  | 39 |  | 6 |  | 6
 |  |  |  |  |  |  | 40 |  | 1 |  | 1
 |  |  |  |  |  |  | 41 |  | 4 |  | 4
 |  |  |  |  |  |  | 42 |  | 3 |  | 3
 |  |  |  |  |  |  | 43 |  | 4 |  | 4
 |  |  |  |  |  |  | 44 |  | 1 |  | 1
 |  |  |  |  |  |  | 45 |  | 3 |  | 3
 |  |  |  |  |  |  | 46 |  | 4 |  | 4
 |  |  |  |  |  |  | 47 |  | 2 |  | 2
 |  |  |  |  |  |  | 48 |  | 5 |  | 5
Spreadsheet: 59497d1259997950-excel-2007-chi-square-chi-square
Sheet: Sheet1

Row Labels | No Sat with PA | Sat with PA | Grand Total
No Autonomy | 3 | 14 | 17
Freedom to Act | 6 | 22 | 28
Grand Total | 9 | 36 | 45
Expected Range
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]