tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 153807d1336060484-horizontal-high-low-graph-828892
Sheet: Sheet1

Start Depth End Depth Speed
0 2000 300
2000 5000 500
5000 4000 600
3500 0 400
 |  | [NAME]
 |  |  | Speed | End Depth | Pos Error
 |  | 0 | 300 | 2000
 |  | 2000 | 500 | 5000
 |  | 5000 | 600 | 4000
 |  | 3500 | 400 | 0
Spreadsheet: 789225d1659006572-formula-to-show-hours-base-on-month-column-and-phase-wise-month-and-year-book1
Sheet: Sheet1

Project Code | Project Name | Weightage | Month/Year (PH3) | Yearly Tentative Hours | Monthly Tentative Hours | Hours weightage per month | 2022-08-22 00:00:00 | 2022-09-22 00:00:00 | 2022-10-22 00:00:00 | 2022-11-22 00:00:00 | 2022-12-22 00:00:00 | 2023-01-22 00:00:00 | 2023-02-22 00:00:00 | 2023-03-22 00:00:00 | 2023-04-22 00:00:00 | 2023-05-22 00:00:00 | 2023-06-22 00:00:00 | 2023-07-22 00:00:00 | 2023-08-22 00:00:00 | 2023-09-22 00:00:00 | 2023-10-22 00:00:00 | 2023-11-22 00:00:00 | 2023-12-22 00:00:00
Project-1 | Skoda | 0.33 | Oct-2023 | 500 |  |  | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14 | 14
Project-2 | Ford | 0.33 | Jan-2024 | 200
Project-3 | Mini | 0.66 | Jun-2024 | 150
Project-4 | Cadillac | 1 | Jul-2024 | 200
Project-5 | Chevrolet | 1 | May-2023 | 200
Project-6 | Hyundai | 0.66 | Jul-2022 | 200
Project-7 | hHonda | 0.66 | Jul-2022 | 200
Project-8 | Tata | 1 | Mar-2023 | 150 |  |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
Spreadsheet: 726040d1617025624-copy-value-based-on-date-range-inventory-
Sheet: Butiksliste

899 | HQ
401 | Store1
403 | [NAME]
404 | Store3
408 | Store4
409 | Store5
410 | Store6
411 | Store7
413 | Store8
414 | Store9
415 | Store10
417 | Store11
419 | Store12
420 | Store13
421 | Store14
422 | Store15
423 | Store16
424 | Store17
Spreadsheet: sally_beck__33825__Quick Review of Commodity Logic
Sheet: Headcount

E N R O N   N ET WORKS
2 0 0 1   P L A N |  |  |  |  |  |  |  |  |  |  |  |  |  |  | H E A D C O U N T
SAP PROFIT CENTER: |  | 10733
PROFIT CENTER OWNER: |  | [NAME]
SAP COST CENTER/PROJECT: |  | 102838 |  |  |  |  |  |  |  |  |  |  | DUE DATE: | 2000-09-28 00:00:00
COST CENTER/PROJECT OWNER: |  | [NAME] |  |  |  |  |  |  |  |  |  |  | E-mail to [NAME])
 |  |  |  |  |  |  |  |  |  |  |  |  | or [NAME] (3-7805)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
STAFFING SUMMARY | 2001-01-01 00:00:00 | 2001-01-01 00:00:00 | 2001-02-01 00:00:00 | 2001-03-01 00:00:00 | 2001-04-01 00:00:00 | 2001-05-01 00:00:00 | 2001-06-01 00:00:00 | 2001-07-01 00:00:00 | 2001-08-01 00:00:00 | 2001-09-01 00:00:00 | 2001-10-01 00:00:00 | 2001-11-01 00:00:00 | 2001-12-01 00:00:00 | @ Yearend
Executive | 1
VP | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Director | 1 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
Manager |  | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
Sr. Specialist | 1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Specialist | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Staff | 1
[NAME] | 1 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5 | 0.5
Associate | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Analyst |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Technician
Technician II
Technician III
Technical Support | 1
Administrative Assistant |  | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
Subtotal Headcount
Contractors $25-$50
Contractors $51-$75
Contractors $76-$100
Contractors $101-$125
Contractors $125-$150
Contractors $150-$175
Contractors $176-$200
Contractors $201-$225
Contractors $226-$250
Contractors $251-$275
Contractors $276-$300
Contractors $301-$325
Contractors $326-$350
Contractors $351-$375
Contractors $376-$400 | 1
Subtotal Contractors
TOTAL HEADCOUNT
Spreadsheet: 85843d1285868142-excel-2007-sum-of-unique-items-sumofuniqueitemsexample
Sheet: DATA

Fruits | Code | Unique Codes
[NAME] | 12345
Apple | 67891
Orange | 10111
[NAME] | 12345
Grape | 12131
Orange | 10111
Apple | 67891
[NAME] | 23456
[NAME] | 34567
Orange | 11213
[NAME] | 27836
Orange | 10111
Orange | 13421
Grape | 12131
Apple | 67891
Apple | 78910
[NAME] | 23456
Spreadsheet: 779562d1651853586-extract-date-and-balance-amount-to-be-received-date-and-diff-value
Sheet: Sheet1

Date | Voucher Type | Gross Total | Result required
2019-10-12 00:00:00 | Sales | 30090
2019-10-12 00:00:00 | Sales | 81420
2019-11-23 00:00:00 | Sales | 20060
2019-11-23 00:00:00 | Sales | 67850
2019-11-29 00:00:00 | Receipt | -111510
2019-12-31 00:00:00 | Receipt | -87910
2020-01-01 00:00:00 | Sales | 67850
2020-01-07 00:00:00 | Sales | 154090.3
2020-01-30 00:00:00 | Sales | 30090
2020-01-30 00:00:00 | Sales | 67850
2020-03-02 00:00:00 | Receipt | -221940
2020-03-14 00:00:00 | Sales | 67850
2020-03-14 00:00:00 | Sales | 230100
2020-05-30 00:00:00 | Receipt | -97940
2020-06-11 00:00:00 | Receipt | -297950
2020-07-27 00:00:00 | Sales | 10030
2020-07-27 00:00:00 | Sales | 54280
2020-09-28 00:00:00 | Receipt | -64310
 |  |  | Sum of Gross Total | Column Labels
 |  |  | Row Labels | Receipt | Sales | Grand Total
 |  |  | 2019 | -199420 | 199420 | 0
 |  |  | Qtr4 | -199420 | 199420 | 0
 |  |  | 2020 | -682140 | 682140.3 | 0.3000000000465661
 |  |  | Qtr1 | -221940 | 617830.3 | 395890.3
 |  |  | Qtr2 | -395890 |  | -395890
 |  |  | Qtr3 | -64310 | 64310 | 0
 |  |  | Grand Total | -881560 | 881560.3 | 0.3000000000465661
Spreadsheet: 139599d1328325293-excel-2008-running-total-of-different-accounts-checkbook-register-for-show
Sheet: Sheet1

Acct | Description | Totals | Category
0 | Stall Fees And Membership | 10586 | Income
1 | Office Supplies | 1155.62 | Expense
2 | Meeting Spaces | 60 | Expense
3 | Advertising | 2960.14 | Expense
4 | Permits | 100 | Expense
5 | Market Manager Discretionary | 522.74 | Expense
6 | Market Manager [NAME] | 3130 | Expense
7 | Wednesday Refunds | 140 | Expense
8 | Winter Market Hall Rental | 240 | Expense
9 | Winter Market Stall Fee Receipts | 330 | Income |  | 9
10 | Garden Show | 25 | Expense
11 | Sec/Treas & President [NAME] | 800 | Expense
 | Starting Balance | 1065.62
 | Total Income | 10916
 | Total Spending | 9133.5 |  | Matches to Register Ending Balance:
 | Ending Balance | 2848.12 |  | 1
Spreadsheet: 04ccdaaf-8b06-41c3-a52b-189040dff6f6
Sheet: 6. Drug Costs for PMTCT

 | Drug costs for PMTCT |  | unit costs of ARVs |  |  |  |  | Drug wastage (%)
 |  |  | ABC 300mg |  |  |  |  | Tablets
 |  |  | AZT 10mg/mL |  |  |  |  | Syrups
 |  |  | AZT 300mg
 |  |  | AZT 300mg/3TC 150mg
 |  |  | AZT 300mg/3TC 150mg/NVP 200mg
 |  |  | EFV 600mg
 |  |  | LPV/r 200mg/50mg
 |  |  | NVP 10mg/mL
 |  |  | TDF [NAME]EFV 600mg
 |  |  | TDF 300mg/FTC 200mg/EFV 600mg
 |  |  | Regimen |  | Total units (tablet/mL) needed | Total units with wastage | Unit | Unit cost ($) | Total cost ($) | Total cost with discount ($) | Notes
 | Mother eligible for ART | Mother | AZT + 3TC + NVP | AZT 300 mg/3TC 150 mg/NVP 200mg twice daily |  |  | Tablet
 |  |  | AZT + 3TC + LPV/r | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | LPV/r 200/50 mg 2 pastillas twice daily |  |  | Tablet
 |  | Child | NVP (10mg/mL) 15 mg once daily (birth weight >2500g) from birth until 6 weeks of age |  |  |  | mL |  |  |  | 100 mL bottle
 |  | Child | AZT (10mg/mL) 15 mg per dose twice daily (birth weight >2500g) from birth until 6 weeks of age |  |  |  | mL |  |  |  | 200 mL bottle
 | Mother not eligible for ART | Mother (12 months breastfeeding) | AZT + 3TC + LPV/r | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | LPV/r 200/50 mg 2tab twice daily |  |  | Tablet
 |  |  | AZT + 3TC + ABC | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | ABC 300 mg twice daily |  |  | Tablet
 |  |  | AZT + 3TC + EFV | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | EFV 600 mg once daily |  |  | Tablet
 |  |  | TDF + 3TC + EFV | TDF 300 mg/3TC 300 mg/EFV 600 mg once daily |  |  | Tablet
 |  |  | TDF + FTC + EFV | TDF 300 mg/FTC 200 mg/EFV 600 mg once daily |  |  | Tablet
 |  | Mother (replacement feeding) | AZT + 3TC + LPV/r | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | LPV/r 200/50 mg 2 tablets twice daily |  |  | Tablet
 |  |  | AZT + 3TC + ABC | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | ABC 300 mg twice daily |  |  | Tablet
 |  |  | AZT + 3TC + EFV | AZT 300 mg/3TC 150 mg twice daily |  |  | Tablet
 |  |  |  | EFV 600 mg once daily |  |  | Tablet
 |  |  | TDF + 3TC + EFV | TDF 300 mg/3TC 300 mg/EFV 600 mg once daily |  |  | Tablet
 |  |  | TDF + FTC + EFV | TDF 300 mg/FTC 200 mg/EFV 600 mg once daily |  |  | Tablet
 |  | Child | NVP (10mg/mL) 15 mg once daily from birth until 6 weeks of age |  |  |  | mL |  |  |  | 100 mL bottle
 |  | Child | AZT (10mg/mL) 15 mg per dose twice daily from birth until 6 weeks of age |  |  |  | mL |  |  |  | 200 mL bottle
Spreadsheet: 456926d1461130993-copy-items-from-dropdown-list-to-new-sheets-meal-choices-16-04-15-new-test-b
Sheet: FRI - VOLUNTEER

YOGH | [NAME] |  |  | SOUP | FISH | LAMB |  |  | S FISH | STEAMED FISH |  |  |  | BEEF | QUICHE |  |  |  |  |  |  |  | BEEF | QUICHE
B O T T O M |  |  |  |  |  |  |  |  | MIDDLE |  |  |  |  |  |  |  |  | TOP
NAME | ADDRESS | JUICE | DESSERT | SOUP | CRUMBED FISH | LAMB CASSEROLE |  |  | NAME | ADDRESS | JUICE |  |  |  |  |  |  | NAME | ADDRESS | JUICE |  |  |  |  | SPECIAL ITEMS
PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS |  |  |  |  |  |  |  |  | PLEASE CHECK FOR NAMES ON LIDS
 |  | OJ
 |  |  |  |  |  |  |  |  |  |  | OJ |  |  |  |  |  |  |  |  | NO JUICE
 |  |  |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | NO JUICE
 |  | NO JUICE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  | [NAME] |  |  | LAMB CASSEROLE
 |  | NO JUICE | [NAME] |  | CRUMBED FISH |  |  |  |  |  | AJ
 |  | AJ |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  | AJ
 |  | AJ |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  | FROZEN MEAL
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | OJ |  |  |  |  |  | FROZEN MEAL |  |  |  | [NAME] |  | CRUMBED FISH
 |  | AJ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OJ |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | NO JUICE |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  | [NAME] |  |  | AJ
 |  | NO JUICE |  |  |  |  |  |  |  |  | AJ |  |  |  |  |  |  |  |  | AJ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AJ
NOTES: |  |  |  |  |  |  |  |  | NOTES: |  |  |  |  |  |  |  |  | NOTES:
PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK IF CLIENT DOES NOT RECIEVE |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK IF CLIENT DOES NOT RECEIVE |  |  |  |  |  |  |  |  | PLEASE DO NOT LEAVE MEAL IF CLIENT IS NOT AT HOME. MARK IF CLIENT DOES NOT RECEIVE
PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM |  |  |  |  |  |  |  |  | PLEASE PHONE 0438 424858 IF YOU HAVE A PROBLEM
Spreadsheet: 681514d1591618275-find-unique-names-in-a-column-based-on-a-date-range-claim-for-reimbursement-of-expenses-responses-
Sheet: Output

Date From | 2020-03-01 00:00:00 | Date to | 2020-03-31 00:00:00
Indervidual Names | Gross Reimbursement Due | VAT Reimbursement Due | Total Due |  | User Selects the date ranges via yellow cells
[NAME] | 28.83 | 5.77
[NAME] | 23.76 | 4.75
[NAME] | 117.48 | 23.5
Connor Jones | 25.36 | 5.07
[NAME] in these cells that pulls through from the
responces sheet the indervidual user names that appear
in the date range
 |  | Looks up the user name to the left and totals up
 |  | how much money they are due back for the
 |  | date range that is selected
Spreadsheet: 102354d1300302316-help-with-multipe-lookups-fileforexcelforum-2-
Sheet: Tables

 |  | Year | 2000 |  |  |  | Year |  |  |  |  | Year
Division | Capture | Totals | Percentage |  | Division | Capture | Totals | Percentage |  | Division | Capture | Totals | Percentage
Total |  |  |  |  | Total |  |  |  |  | Total
Main | 267 | 5677.006114349074 |  |  | Main | 28 | 497.7693326144114 |  |  | Main | 24 | 501.7762208983241
Suffolk | 56 | 842.1804703213925 |  |  | Suffolk | 4 | 74.08911209770484 |  |  | Suffolk | 3 | 76.52670861916098
Nassau | 109 | 2087.938728127416 |  |  | Nassau | 10 | 175.9959608580804 |  |  | Nassau | 12 | 176.8959309614777
Westchester | 90 | 1171.541048675944 |  |  | Westchester | 4 | 98.628969169638 |  |  | Westchester | 10 | 99.3614734185425
Rockland | 82 | 1720.575678500465 |  |  | Rockland | 7 | 125.0628877857698 |  |  | Rockland | 4 | 123.364877352923
Central | 93 | 1774.987504199006 |  |  | Central | 1 | 153.7908157151274 |  |  | Central | 5 | 155.7129598850498
Monmouth | 40 | 1016.009099115795 |  |  | Monmouth | 2 | 85.71323049794783 |  |  | Monmouth | 4 | 86.93088999470751
Spreadsheet: 768127d1644847158-checking-to-see-if-multiple-values-from-one-list-exist-in-the-other-test-54-ans-1-
Sheet: Sheet1

Product | Match
apples
pears
bananas
kiwi
watermelon
grapes
strawberries
raspberries
blueberries
avocado
spinach
tomatoes
potato
[NAME]
onions
courgettes
cucumber
lettuce
coconut
peppers
potato feat. Apples And pears
onions, cauliflower
apples & pears
ants, bats, cats
Spreadsheet: 879736d1727285531-format-row-colors-based-on-time-test-chart
Sheet: Sheet1

Date | Time | Syst. | [NAME]. | H | O2
 |  |  |  |  |  |  |  | Morning | Afternoon | Night
 |  |  |  |  |  |  |  | 01:00:00 | 12:00:00 | 18:00:00
2024-03-16 00:00:00 | 20:00:00 | 128 | 65 | 57 | 97
2024-03-19 00:00:00 | 7:00 PM | 130 | 69 | 62 | 98
2024-03-21 00:00:00 | 8:00 PM | 144 | 74 | 61 | 98
2024-03-23 00:00:00 | 12:00 PM | 143 | 74 | 53 | 99
2024-03-23 00:00:00 | 8:00 PM | 131 | 75 | 63 | 98
2024-03-26 00:00:00 | 1:00 PM | 132 | 76 | 54 | 96
2024-03-26 00:00:00 | 10:00 PM | 135 | 73 | 64 | 97
2024-03-27 00:00:00 | 10:00 AM | 138 | 71 | 52 | 97
2024-03-27 00:00:00 | 8:00 PM | 132 | 70 | 60 | 98
2024-03-28 00:00:00 | 8:00 PM | 138 | 77 | 60 | 98
2024-03-29 00:00:00 | 8:00 PM | 128 | 76 | 57 | 98
2024-03-30 00:00:00 | 8:00 PM | 119 | 61 | 52 | 97
2024-03-31 00:00:00 | 9:00 PM | 134 | 67 | 56 | 98
2024-04-01 00:00:00 | 8:00 PM | 142 | 70 | 57 | 97
2024-04-04 00:00:00 | 9:00 PM | 145 | 70 | 54 | 97
2024-04-05 00:00:00 | 9:00 PM | 141 | 76 | 55 | 97
2024-04-11 00:00:00 | 9:00 PM | 138 | 67 | 58 | 99
2024-05-15 00:00:00 | 10:00 PM | 140 | 75 | 57 | 97
2024-05-19 00:00:00 | 9:00 PM | 135 | 68 | 53 | 98
2024-05-20 00:00:00 | 9:00 PM | 128 | 69 | 54 | 96
2024-05-22 00:00:00 | 8:00 PM | 123 | 71 | 57 | 97
2024-05-23 00:00:00 | 9:00 PM | 126 | 68 | 57 | 96
2024-05-24 00:00:00 | 9:00 AM | 114 | 62 | 52 | 96
2024-05-24 00:00:00 | 2:00 PM | 130 | 76 | 55 | 95
2024-05-27 00:00:00 | 8:00 PM | 129 | 77 | 57 | 97
2024-05-28 00:00:00 | 9:00 PM | 131 | 77 | 52 | 97
2024-05-29 00:00:00 | 8:00 PM | 133 | 77 | 54 | 96
2024-06-09 00:00:00 | 9:00 PM | 125 | 73 | 54 | 96
2024-06-10 00:00:00 | 10:00 AM | 137 | 73 | 46 | 97 |  | Started walking 1.5 mi./day
2024-06-10 00:00:00 | 6:00 PM | 142 | 78 | 50 | 97
2024-06-14 00:00:00 | 9:00 PM | 124 | 71 | 51 | 96
2024-06-17 00:00:00 | 12:00 PM | 126 | 74 | 47 | 97
2024-06-20 00:00:00 | 8:00 PM | 128 | 77 | 67 | 96 |  | [NAME]
2024-06-21 00:00:00 | 11:00 AM | 139 | 83 | 62 | 96
2024-06-21 00:00:00 | 10:00 PM | 128 | 77 | 65 | 96
2024-06-22 00:00:00 | 9:00 PM | 109 | 68 | 84 | 96
2024-06-23 00:00:00 | 11:00 AM | 133 | 77 | 59 | 96
2024-06-24 00:00:00 | 1:00 PM | 141 | 80 | 65 | 98
2024-06-24 00:00:00 | 10:00 PM | 124 | 75 | 64 | 95
2024-06-25 00:00:00 | 10:00 PM | 125 | 70 | 67 | 97
2024-06-27 00:00:00 | 9:00 PM | 120 | 72 | 69 | 96
2024-06-28 00:00:00 | 1:00 PM | 133 | 78 | 64 | 97
2024-06-30 00:00:00 | 11:00 AM | 130 | 73 | 74 | 96
2024-07-02 00:00:00 | 9:00 PM | 129 | 77 | 73 | 96
2024-07-04 00:00:00 | 11:00 AM | 126 | 75 | 68 | 97
2024-07-24 00:00:00 | 9:00 PM | 112 | 71 | 86 | 96
2024-08-03 00:00:00 | 9:00 PM | 117 | 72 | 86 | 96
2024-08-12 00:00:00 | 1:00 PM | 130 | 74 | 68 | 97
2024-08-15 00:00:00 | 1:00 PM | 138 | 76 | 59 | 98
2024-08-17 00:00:00 | 9:00 PM | 116 | 68 | 75 | 96
2024-08-20 00:00:00 | 1:00 PM | 133 | 80 | 65 | 96
2024-08-21 00:00:00 | 1:00 PM | 138 | 80 | 62 | 97
2024-08-24 00:00:00 | 2:00 PM | 127 | 76 | 66 | 98
2024-08-29 00:00:00 | 8:00 PM | 121 | 75 | 75 | 96
2024-08-31 00:00:00 | 11:00 AM | 138 | 75 | 65 | 98
2024-09-13 00:00:00 | 8:00 PM | 125 | 73 | 73 | 97
Spreadsheet: 873342d1719849752-sum-vlookup-combination-case-sum-vlookup
Sheet: SUM - VLOOKUP

 | Sales Revenue by Store
 | Store Name | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | North | 98 | 20 | 76 | 88 | 23 | 20 | 82 | 88 | 86 | 12 | 17 | 19
 | East | 40 | 51 | 90 | 33 | 50 | 68 | 80 | 73 | 8 | 108 | 110 | 93
 | South | 72 | 7 | 43 | 5 | 78 | 69 | 46 | 42 | 34 | 17 | 58 | 25
 | West | 4 | 57 | 63 | 100 | 8 | 86 | 95 | 14 | 69 | 96 | 92 | 2 |  | example 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Feb
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | North
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | example 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Store Name | Jan | Mar
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | East
Spreadsheet: 124578d1318475942-filling-date-series-dates
Sheet: Sheet1

2011-10-02 00:00:00
 |  |  | 2011-10-02 00:00:00 |  | 2011-10-03 00:00:00 |  | 2011-10-04 00:00:00 |  | 2011-10-05 00:00:00 |  | 2011-10-06 00:00:00 |  | 2011-10-07 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | 2011-10-08 00:00:00 |  | 2011-10-09 00:00:00 |  | 2011-10-10 00:00:00 |  | 2011-10-11 00:00:00 |  | 2011-10-12 00:00:00 |  | 2011-10-13 00:00:00 |  | 2011-10-14 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | 2011-10-15 00:00:00 |  | 2011-10-16 00:00:00 |  | 2011-10-17 00:00:00 |  | 2011-10-18 00:00:00 |  | 2011-10-19 00:00:00 |  | 2011-10-20 00:00:00 |  | 2011-10-21 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | 2011-10-22 00:00:00 |  | 2011-10-23 00:00:00 |  | 2011-10-24 00:00:00 |  | 2011-10-25 00:00:00 |  | 2011-10-26 00:00:00 |  | 2011-10-27 00:00:00 |  | 2011-10-28 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | 2011-10-29 00:00:00 |  | 2011-10-30 00:00:00 |  | 2011-10-31 00:00:00 |  | 2011-11-01 00:00:00 |  | 2011-11-02 00:00:00 |  | 2011-11-03 00:00:00 |  | 2011-11-04 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
 | 2011-11-05 00:00:00 |  | 2011-11-06 00:00:00 |  | 2011-11-07 00:00:00 |  | 2011-11-08 00:00:00 |  | 2011-11-09 00:00:00 |  | 2011-11-10 00:00:00 |  | 2011-11-11 00:00:00 |  | Week Total
 | Saturday |  | Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R7

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | Determine flexibilities to be maintained within the ADvantage waiver | [NAME] | 2022-11-22 00:00:00 | 2022-12-30 00:00:00 | 2022-12-30 00:00:00 |  |  |  |  | Draft document of flexibilities to be maintained completed; meeting scheduled with MSU-AA team
Planning & Scope | Create timeline for waiver activities to assure timely waiver submission to meet CMS requirements | [NAME] | 2022-11-22 00:00:00 | 2023-01-06 00:00:00 | 2022-12-30 00:00:00 |  |  |  |  | Draft timeline completed for review with MSU-AA team
Plan Outline | Review flexibilities with waiver team and assign tasks according to agreed upon timeline | [NAME] | 2022-12-30 00:00:00 | 2023-01-13 00:00:00
Implementation | Complete waiver amendment documentation | Waiver Review Team | 2022-12-30 00:00:00 | 2023-02-28 00:00:00
Review & Refine | Final review of waiver amendment documentation | Waiver Leadership Team | 2022-12-30 00:00:00 | 2023-03-17 00:00:00
Review & Refine | Submit to OHCA for review | [NAME] | 2022-12-30 00:00:00 | 2023-03-20 00:00:00
Review & Refine | Make any corrections to waiver amendment documentation requested by OHCA | Waiver Leadership Team | 2022-12-30 00:00:00 | 2023-03-29 00:00:00
Review & Refine | Submit to OHCA for final review | [NAME] | 2022-12-30 00:00:00 | 2023-03-31 00:00:00
[NAME] | Obtain notification from OHCA that waiver amendment has been submitted to CMS | OHCA | 44925 | 2023-03-31 00:00:00
Spreadsheet: 877024d1723715722-add-two-columns-for-all-combinations-lamlam28-add-for-combinations-365-aligw
Sheet: V1

 | Raw Data |  |  |  | Step 1 |  |  |  | Step 2 |  |  |  |  |  |  |  |  |  |  |  | Step 3
 | Here we have two sets of raw data (Column B ,Column D)  in ascending order |  |  |  | We extract the raw data that fulfill these conditions: |  |  |  | We add up the numbers in Column F and H for all possible combinations |  |  |  |  |  |  |  |  |  |  |  | We match all possible combinations from step 2 against specific numbers.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The formula in Column W returns the number if a match is found.
 |  |  |  |  | 1. Number < the maximum limit in the respective yellow cells
 |  |  |  |  | 2. Difference of (Succeeding Number - Number) >1
 |  |  |  |  | [NAME] for Column B |  | [NAME] for Column D
 |  |  |  |  | 30 |  | 50
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ???
 | 1 |  | 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | No. to match | Return if exist in result per step 2
 | 3 |  | 6 |  | 3
 | 5 |  | 7 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11
 | 9 |  | 8 |  | 9 |  | 8 |  | 9 | 11 | 13 | 17 | 19 |  | 22 | 26 | 30 | 32 | 37 |  | 17
 | 11 |  | 10 |  | 11 |  | 10 |  | 11 | 13 | 15 | 19 | 21 |  | 24 | 28 | 32 | 34 | 39 |  | 23
 | 13 |  | 13 |  |  |  | 13 |  | 14 | 16 | 18 | 22 | 24 |  | 27 | 31 | 35 | 37 | 42 |  | 46
 | 14 |  | 17 |  | 14 |  | 17 |  | 18 | 20 | 22 | 26 | 28 |  | 31 | 35 | 39 | 41 | 46 |  | 54
 | 18 |  | 19 |  | 18 |  | 19 |  | 20 | 22 | 24 | 28 | 30 |  | 33 | 37 | 41 | 43 | 48 |  | 63
 | 22 |  | 21 |  | 22 |  | 21 |  | 22 | 24 | 26 | 30 | 32 |  | 35 | 39 | 43 | 45 | 50
 | 24 |  | 26 |  | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Result
 | 27 |  | 27 |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Is it possible to do it in one single formula?
 | 32 |  | 28 |  |  |  | 28 |  | 29 | 31 | 33 | 37 | 39 |  | 42 | 46 | 50 | 52 | 57
 | 33 |  | 32
 | 45 |  | 33 |  |  |  | 33 |  | 34 | 36 | 38 | 42 | 44 |  | 47 | 51 | 55 | 57 | 62
 | 48 |  | 37 |  |  |  | 37 |  | 38 | 40 | 42 | 46 | 48 |  | 51 | 55 | 59 | 61 | 66
 | 55 |  | 41 |  |  |  | 41 |  | 42 | 44 | 46 | 50 | 52 |  | 55 | 59 | 63 | 65 | 70
 | 56 |  | 43
 | 57 |  | 44 |  |  |  | 44 |  | 45 | 47 | 49 | 53 | 55 |  | 58 | 62 | 66 | 68 | 73
 | 61 |  | 52