tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 823922d1680196843-populating-a-value-based-on-a-series-of-data-budget
Sheet: Sheet1

The following are the TYPES of selections I would have the option of choosing per employee.  Note for this first set of data, the options are by column
Insurance Selection | Employee Type | Coverage Selected | Healthcare Selection
Healthcare | Hourly | Employee Only | Standard
Dental | Salary | Employee & Spouse | Buy Up Plan
Vision |  | Employee and Children
 |  | Employee & Family
 |  | Waived
This next set of data would be the amounts that I am looking to populate based on the data chosen from above
Healthcare | Standard | Type | Employee Only | Employee & Spouse | Employee and Children | Employee & Family | Waived
healthcare | Hourly Employee | Standard | 84.42 | 226.41 | 135.91 | 257.75 | 0
healthcare | [NAME] | Standard | 91.45 | 245.28 | 147.23 | 279.24 | 0
healthcare | Hourly Employee | Buy Up | 123.6 | 260.49 | 250.17 | 372.03 | 0
healthcare | [NAME] | Buy Up | 133.61 | 282.2 | 271.03 | 403.03 | 0
dental | Hourly Employee | NA | 4.19 | 8.56 | 15.81 | 15.81 | 0
dental | [NAME] | NA | 4.55 | 9.28 | 17.13 | 17.13 | 0
vision | Hourly Employee | NA | 4.54 | 7.47 | 7.41 | 11.95 | 0
vision | [NAME] | NA | 4.92 | 8.1 | 8.03 | 12.95 | 0
Sample of data I would like to populate - I highlighted different colors from the above table to show my expected value
Employee Name | Employee Type | Healthcare | Expected Value | Dental | Expected | Vision | Expected
[NAME] | [NAME] | Employee Only/Standard |  | Employee & Spouse |  | Employee & Family
[NAME] | Hourly Employee | Employee & Family/Buy Up |  | Employee Only |  | Waived
Spreadsheet: 47a34d1f-c8f1-49d6-8095-09cb372d978f
Sheet: Foglio1

O\F | Future | Forniture | Firm | Fire | Friend | Form/Format | For * | From * | Free | Fashion | Framework/Frame | Focus/Focused | Front | ………….
On
Open
Opportunity
Open mind
Ok
Over
Owner
Office
[NAME]
.net
.biz
.com
Spreadsheet: 869150d1715786036-schedule-formula-that-indicates-off-days-test-schedule
Sheet: Sheet2

 |  |  | YR | MONTH
9 | 0630-1600 | M-F 8s | 2024 | JANUARY
8 | 0700-1530 | 5/4/9 1st Fri off | 2025 | FEBRUARY
9 | 0700-1630 | 5/4/9 2nd Fri off | 2026 | [NAME]
10 | 0700-1730 | 5/4/9 1st Mon off | 2027 | APRIL
8 | 0730-1600 | 5/4/9 2nd Mon off | 2028 | MAY
9 | 0730-1700 | off Mon & Tue | 2029 | [NAME]
8 | 0800-1630 | off Wed & Thur | 2030 | JULY
9 | 0800-1730 | 4/10 Fri off | 2031 | AUGUST
8 | 0830-1700 | 4/10 Mon off |  | SEPTEMBER
 | 1530-2400 | [NAME],Mon, Wed |  | OCTOBER
 | 1430-2300 | Off Mon,[NAME],[NAME] |  | NOVEMBER
 |  |  |  | DECEMBER
Spreadsheet: 674158d1587679513-automate-my-hobby-lemoncello-recipe-and-production-sheet-lemmonchello-recipe-for-disaster
Sheet: Masterdata

INGREDIENT 1 | unit = gr | price / kg | INGREDIENT 2 | unit = gr | price / kg | Spirit | spirit VOL | unit = ML | price / Liter
Leo sidrunit |  | 12.65 | näpuotsa safraniõisi NATCO |  | 12 | [NAME] | 40 |  | 45
Mexico laimi BioMarket |  | 10 | viilu [NAME] |  | 30 | VV | 80 |  | 44
[NAME] veriapelsini |  | 14.75 | [NAME] lehti |  | 11 | BATYA | 79 |  | 35
laimi Mehhikost, BioMarket |  | 10 | [NAME], vist 2018 |  | 11.5
heleroh/kollakad suured ja kõvad [NAME] laimid |  | 12 | [NAME] Biomarket |  | 13.5
[NAME] apelsin |  | 12 | tähtaniisi Lebensbaum |  | 10.75
öko ingver riiviga viilutatud |  | 14 | kaneelipulka Lebensbaum |  | 10
suurt + 2 väikest [NAME] sidrunit |  | 15 | suured [NAME] sidrunid |  | 40
[NAME] suurt kollast bergamoti |  | 17.5 | suurt tähtaniisi Lebensbaum |  | 6
[NAME]'s Amalfi sidrunit |  | 20 | Safran, 3 korralikku näputait (otsas ka) |  | 24
Leo keskmist sidrunit |  | 40 | [NAME], Umamist, [NAME] päritolu |  | 13
Leo pritsimata, seisma [NAME] tasuta apelsini |  | 22 | Poola piparmünt turult 10% Peaks ka vbl suurendama [NAME]? |  | 12
Leo beeswax |  | 32 | münti. [NAME] tuua 10-15% min |  | 32
[NAME] suurt sidrunit |  | 32 | MATE
Leo sidrunut, 9p seisnud |  | 32 | MATCHA
 |  |  | ROOIBOS
 |  |  | HIBISKUS
 |  |  | CHAMOMILLE
 |  |  | VANILLA
 |  |  | LEMONGRASS
 |  |  | CARDAMON
 |  |  | COCOA
 |  |  | GOJI BERRY
 |  |  | HABANERO
 |  |  | MATE
 |  |  | MATCHA
 |  |  | ROOIBOS
 |  |  | HIBISKUS
 |  |  | CHAMOMILLE
 |  |  | VANILLA
 |  |  | LEMONGRASS
 |  |  | CARDAMON
 |  |  | COCOA
 |  |  | GOJI BERRY
 |  |  | HABANERO
Spreadsheet: 794504d1662083636-not-sure-which-formula-or-function-to-use-zipcode
Sheet: cust

Date Rec'd | Customer | # of units | CSS | Status | Line # on PM Agr. | Model | SN | Issue | Zip | Technician | Van | ZONE
2022-08-25 00:00:00 | Fashion Wheels | 10 | Arzhang | ~Waiting on CSS | 6 | 12-E90-13 | TBD | Need the SN. | 77303 | [NAME] | 34
2022-08-30 00:00:00 | TSB Industrial | 1 | Kylie | Complete |  |  |  |  | 77302 | [NAME] | 34
2022-08-30 00:00:00 | Perdue | 1 | Arzhang | Complete |  |  |  |  | 77301 | Chad D | 71
2022-08-30 00:00:00 | Lion's Floor | 3 | [NAME] | Complete |  |  |  |  | 77099 | [NAME] | 79
2022-08-30 00:00:00 | Champion Wholesale | 8 | Arzhang | ~Waiting on ownership |  | All batteries |  | Still on reserved sale | 77306 | Vic | 70
2022-08-30 00:00:00 | Busch USA | 2 | [NAME] | Complete |  |  |  |  | 77301 | Mike c | 59
2022-08-02 00:00:00 | Lions Floor | 6 | [NAME] | ~Waiting on CSS | 5 | 125 BCI 19 | 2205104 | Need pic of data tag to submit to IT. | 77098 | [NAME] | 79
2022-08-25 00:00:00 | Moore Supply | 4 | Arzhang | ~Waiting on CSS | 4 | EO | GGS3241 | Model not in quipware | 77301 | [NAME] | 77
2022-08-25 00:00:00 | Carolina Logistics | 3 | [NAME] | ~Waiting on CSS | 2 | 8FBE15U | 12852 |  | 77095 | Leo S | 65
2022-08-25 00:00:00 | [NAME] | 2 | Arzhang | Complete |  |  |  |  | 77306 | Calen R | 45
 | Harvest Natural - Spring | 1 | Vic | ~Other |  | C5 | 10251808 | Unit already signed up in May. Did they transfer to this location? | 77306 | Calen R | 45
 |  |  |  |  |  |  |  |  | 77302
Spreadsheet: 6fde3684-ae28-4282-a5b7-339f014409aa
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
43594649 | 2014-10-15 19:41:43 | AXIS | 1 | 6 | 5 | 1656083 | klachance1 | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43594902 | 2014-10-15 19:55:38 | ALLIES | 1 | 6 | 3 | 1656083 | klachance1 | 6155 | western | 1944-09-19 | 1944-09-19 | Arracourt | Arracourt
43619782 | 2014-10-17 17:06:06 | AXIS | 0 | 3 | 6 | 1085212 | rafael-r.93 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
43619996 | 2014-10-17 17:20:24 | ALLIES | 1 | 6 | 3 | 1085212 | rafael-r.93 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
Spreadsheet: 726719d1617383957-convert-text-days-hours-minutes-to-total-hours-example
Sheet: Sheet1

Location | Time in location | Actions | Total Dwell | H:MM | Roundup
a | 2 day(s), 17 hour(s), 26 minute(s) | none
b | 4 hour(s), 59 minute(s) | move | 5
c | 8 hour(s), 43 minute(s) | waiting | 9
d | 100 day(s), 4 hour(s), 15 minute(s) | none
e | 7 day(s), 17 minute(s) | move
a | 4 minute(s) | waiting | 1
b | 4 minute(s) | none | 1
c | 6 hour(s), 10 minute(s) | move | 7
d | 17 day(s), 5 hour(s), 34 minute(s) | waiting
e | 8 day(s), 7 hour(s), 16 minute(s) | none
a | 1 day(s), 19 hour(s), 32 minute(s) | move
b | 23 day(s), 10 hour(s), 50 minute(s) | waiting
c | 4 day(s), 9 hour(s), 11 minute(s) | none
d | 1 day(s), 18 hour(s), 54 minute(s) | move
e | 17 day(s), 7 hour(s), 3 minute(s) | waiting
a | 1 day(s), 5 hour(s), 56 minute(s) | none | 30
b | 16 hour(s), 36 minute(s) | move | 17
c | 297 day(s), 6 hour(s), 2 minute(s) | waiting
Spreadsheet: 82979d1282979623-how-to-remove-char-in-cell-with-conditional-remove-space
Sheet: Sheet1

Conditional |  | Text | Result | Description |  | Exericise 1
4 |  | ab c [NAME] | abc ed mjg kjk | if A2=4, then remove the first space
5 |  | ab c [NAME] | abced mjg kjk | if [NAME], then remove the first space, and 2 nd space
6 |  | ab c [NAME] | [NAME] | if A2=6, then remove the first space, 2nd, 3rd space
Conditional |  | Text | Result | Description |  | Exericise 2
4 |  | ab c [NAME] | abc ed mjg kjk | if A2=4, then remove the first space only
5 |  | ab c [NAME] | abced mjg kjk | if [NAME], then remove the 2nd space only
6 |  | ab c [NAME] | [NAME] | if A2=6, then remove the 3rd space only
Spreadsheet: debra_perlingiere__8458__MasterPhys
Sheet: Sheet1

Master Firm Purchase/Sale Agreement Worksheet
 |  | ATTORNEY: | [NAME]
DATE: |  | DEAL MAKER: | Nelson Ferries
COUNTERPARTY: | Matrix Oil & Gas, Inc. | CONTACT:
ADDRESS: | [NAME] 2468 | TITLE:
 | Covington, LA 70434 | PHONE:
 |  | FAX:
Incorporation State | ? | S&P Rating | n/a
STRUCTURE | COUNTERPARTY | ENA
GUARANTOR (RATING)
LIMIT $ MILLIONS
Incorporation State
COLLATERAL  THRESHOLD
 | 500000 | 5000000 | USD
Specify Type of Debt:
COLLATERAL TYPE
Letter of Credit | OK | OK
Cash | OK | OK
MINIMUM TRANSFER $ | 1 | 1
COLLATERAL ROUNDING | 250000 | 250000 | USD
HOLDING and USE OF COLLATERAL
Permitted | X | X
Minimum S & P/Moody's
rating permitted
MATERIAL ADVERSE CHANGE TRIGGERS - if Matrix not applicable
APPLY TO:
-Counterparty | X
-Parent |  | X
Debt Ratings Change
-Below = S&P/Moody's |  | BBB- | S&P
Financial Covenants
-Funded debt/Worth | Greater than 1.25:1
-Minimum Net Worth | $20MM |  | USD
-EBITDA/Interest
Non-Specific
-Unilateral
Non-Standard Definitions
-Funded Debt
-Net Worth
EVENTS OF DEFAULT
3rd party debt | X | X
-Counterparty ($[NAME]) | 100000 | 100000000 | USD
-Guarantor ($[NAME])
Change in ownership
FINANCIAL STATEMENTS
-Standard | X | X
- Request financials on:
CREDIT DECISION: | APPROVED :  X | DECLINED:
OUTSTANDING SWAP TRANSACTIONS: |  | YES: x | NO:
ALL SWAPS TO ROLL UP UNDER NEW MASTER: |  | YES: x | NO:
CREDIT PROVISIONS OF MASTER TO GOVERN: |  | YES: x | NO:
OTHER COMMENTS:
Please deliver to Nelson Ferries for delivery to the counterparty.  He is visiting the counterparty next week and has requested that he
have this in hand for delivery by the end of this week.
CREDIT REVIEW  PREPARED BY: |  | [NAME] | x3-0906
Spreadsheet: 127229d1320245197-3-month-moving-average-dashboard-forum_sample
Sheet: Report 2

Month | 2011-10-01 00:00:00
Average of %_[NAME] | Column Labels
Row Labels | Type 1 | Type 2 Patch | Type 3 Patch | Grand Total
R1 | 0.9771426699547642 | 0.9271061118490258 | 0.9002070475705712 | 0.9348186097914536
R3 | 0.9681151596671164 | 0.9190391334680962 | 0.9696231456455986 | 0.9522591462602704
R2 | 0.9811605081064173 | 0.9742474025523209 | 0.9791666666666666 | 0.9781915257751349
R4 | 0.9490196078431372 | 0.9623797025371829 | 0.8958333333333334 | 0.9357442145712178
Grand Total | 0.9744199515439468 | 0.9361627371297576 | 0.9368039327469838 | 0.9491288738068959
Spreadsheet: 90329d1290078089-colours-in-line-after-completing-fields-for-web-question
Sheet: Sheet1

A = Complete UIF Form |  | D = Cheque paid in at SARS (date) |  |  |  |  |  |  | I1 = Informed Client per phone (date) |  |  |  |  |  | L = Paid SARS on date
B1 = Informed Client per phone (date) |  | E = Paid SARS on date |  |  |  |  |  |  | I2 = Informed Client per SMS (date) |  |  |  |  |  | M = Payment checked by OZ
B2 =  Informed Client per SMS (date) |  | F = Payment checked by OZ |  |  |  |  |  |  | I3 = Informed Client per E-mail (date) |  |  |  |  |  | N = Proof of Payment received from SARS
B3 =  Informed Client per E-mail (date) |  | G = Proof of Payment received from SARS |  |  |  |  |  |  | J = Received cheque from client |  |  |  |  |  | O = Month complete and finalized
C = Received cheque from client |  | H = Received notice of penalty + Interest |  |  |  |  |  |  | K = Cheque paid in at SARS
Name client | A | B1 | B2 | B3 | C | D | E | F | G | H | I1 | I2 | I3 | J | K | L | M | N | O
A
before
completing data |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00
stil completing till work done |  | 2010-09-01 00:00:00 | 2010-09-01 00:00:00 | np |  |  |  |  |  |  | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 2010-09-07 00:00:00
All work done |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00 |  |  |  |  |  |  | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 2010-09-07 00:00:00
automatically everything green |  | 2010-09-01 00:00:00 | 2010-09-02 00:00:00 | 2010-09-02 00:00:00 | ATM |  |  |  |  |  | 2010-09-07 00:00:00 | 2010-09-07 00:00:00 | 2010-09-07 00:00:00
As you can see are there about 20 fields - steps - before completing the full line in green. When all work is done it is in one sight possible to see
Second question if I add a date after the 8th of the month  at field I1,I2  could it be possible that it will show pink or orange  automitically?
Thank you for your assistance and support
Spreadsheet: 938e248f-25ee-4f04-b63e-58cde807ed89
Sheet: New Table 3

Table 3
Rail Deliveries to Port (carloads)1
 | Mississippi |  | Pacific | Atlantic & |  |  | Cross-Border
Week ending | Gulf | Texas Gulf | Northwest | East Gulf | Total | Week ending | Mexico3
4/09/2014p |  |  |  |  |  | 2014-04-05 00:00:00
4/02/2014r |  |  |  |  |  | 2014-03-29 00:00:00
2014 YTDr |  |  |  |  |  | 2014 YTD
2013 YTDr |  |  |  |  |  | 2013 YTD
2014 YTD as % of 2013 YTD |  |  |  |  |  | % change YTD
Last 4 weeks as % of 20132 |  |  |  |  |  | Last 4wks % 2013
Last 4 weeks as % of 4-year avg.2 |  |  |  |  |  | Last 4wks % 4 yr
Total 2013 |  |  |  |  |  | Total 2013 | 70298
Total 2012 |  |  |  |  |  | Total 2012 | 92008
1 Data is incomplete as it is voluntarily provided
2 Compared with same 4-weeks in 2013 and prior 4-year average.
3 Cross- border weekly data is aproximately 15 percent below the Association of American Railroads reported weekly carloads received by Mexican railroads
to reflect switching between KCSM and FerroMex.
YTD = year-to-date; p = preliminary data; r = revised data; n/a = not available
Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: 725490d1616693933-daily-sales-spreadsheet-month-target-2021-22
Sheet: 2021 QTR1

Monthly Target | 2021-04-01 00:00:00 |  |  |  |  |  | HIDE ME |  | 2021-05-01 00:00:00 |  |  |  |  |  |  | 2021-06-01 00:00:00
35150 |  |  |  |  |  |  | Holidays
Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | 2021-01-01 00:00:00 | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target |  | Day | DATE | Daily Target | Daily Sales | Month To Date | Updated Target
 |  |  |  |  |  |  | 2021-04-02 00:00:00
 |  |  |  |  |  |  | 2021-04-05 00:00:00
 |  |  |  |  |  |  | 2021-05-03 00:00:00
 |  |  |  |  |  |  | 2021-05-31 00:00:00
 |  |  |  |  |  |  | 2021-08-30 00:00:00
 |  |  |  |  |  |  | 2021-12-27 00:00:00
 |  |  |  |  |  |  | 2021-12-28 00:00:00
 |  |  |  |  |  |  | 2022-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  | Target
 |  | Target
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Target
TOTAL |  |  |  |  |  |  |  | TOTAL |  |  |  |  |  |  | TOTAL
Spreadsheet: 881487d1729557953-max-range-position-based-on-cell-value-excel-help-staffing
Sheet: Sheet1

 |  |  |  |  |  | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00 | 2025-08-01 00:00:00 | 2025-09-01 00:00:00 | 2025-10-01 00:00:00 | 2025-11-01 00:00:00 | 2025-12-01 00:00:00 | 2026-01-01 00:00:00 | 2026-02-01 00:00:00 | 2026-03-01 00:00:00 | 2026-04-01 00:00:00 | 2026-05-01 00:00:00 | 2026-06-01 00:00:00 | 2026-07-01 00:00:00 | 2026-08-01 00:00:00 | 2026-09-01 00:00:00 | 2026-10-01 00:00:00 | 2026-11-01 00:00:00 | 2026-12-01 00:00:00
Role | Lead Time (Months) | Monthly Unit Capacity |  | Units |  | 25 | 25 | 35 | 35 | 55 | 55 | 75 | 75 | 100 | 75 | 75 | 75 | 55 | 55 | 75 | 75 | 100 | 100 | 125 | 125 | 150 | 150 | 125 | 125
Assist 1 | 2 | 15 |  | Staff Count
Assist 2 | 3 | 35
Assist 3 | 4 | 50
Spreadsheet: 890044d1741181558-if-cell-contains-a-certain-range-display-a-value-in-another-cell-book1
Sheet: Sheet1

 |  |  |  | LOW 1- 6 | 10
 |  |  |  | MEDIUM 8 - 12 | 17
 |  |  |  | HIGH 15 - 20 | 33
 |  |  |  | 25 | 100
 |  | Total risk matrix score | Percentage
 |  | 9 | 17
 |  | 16 | 33
 |  | 16 | 33
 |  | 12 | 17
 |  | 4 | 10
 |  | 16 | 33
 |  | 25 | 10
 |  | 6 | 10
 |  | 12 | 17
 |  | 9 | 17
 |  | 25 | 10
 |  | 8 | 17
 |  | 12 | 17
 |  | 6 | 10
 |  | 6 | 10
Spreadsheet: 173068d1344434388-mail-merge-book1
Sheet: Sheet1

Name | No | Street | Town | Postcode
NE One | 3 | Coronation Street | Brighton | BR1 5NU
NE One | 4 | Coronation Street | Brighton | BR1 5NU
NE One | 5 | Coronation Street | Brighton | BR1 5NU
NE One | 6 | Coronation Street | Brighton | BR1 5NU
NE One | 7 | Coronation Street | Brighton | BR1 5NU
NE One | 8 | Coronation Street | Brighton | BR1 5NU
NE One | 9 | Coronation Street | Brighton | BR1 5NU
NE One | 10 | Coronation Street | Brighton | BR1 5NU
NE One | 11 | Coronation Street | Brighton | BR1 5NU
NE One | 12 | Coronation Street | Brighton | BR1 5NU
NE One | 13 | Coronation Street | Brighton | BR1 5NU
NE One | 14 | Coronation Street | Brighton | BR1 5NU
NE One | 15 | Coronation Street | Brighton | BR1 5NU
NE One | 16 | Coronation Street | Brighton | BR1 5NU
NE One | 17 | Coronation Street | Brighton | BR1 5NU
NE One | 18 | Coronation Street | Brighton | BR1 5NU
NE One | 19 | Coronation Street | Brighton | BR1 5NU
NE One | 20 | Coronation Street | Brighton | BR1 5NU
Spreadsheet: 142714d1329983835-using-mod-sumif-and-vlookup-for-a-table-test1
Sheet: CALCULATOR

 |  |  |  |  |  | 12 | 15 |  |  |  | 12 | 15
 | WIDTH | 5.5 |  | W
 | LENGTH | 6.5 |  | L
 |  |  |  | L+W
 | QUANTITY | 10 |  | 2L+W
 |  |  |  | 2L+W 15 FEET |  |  | 2L+W 15 FEET | 2L+W
 |  |  |  | 2L+W 12 FEET |  |  | 2L+W 12 FEET | 2L+W
 |  |  |  | L+W 15 FEET |  |  | L+W 15 FEET | L
 |  |  |  | L+W 12 FEET |  |  | L+W 12 FEET | L
 |  |  |  | L 15 FEET |  |  | L 15 FEET | W
 |  |  |  | L 12 FEET |  |  | L 12 FEET | W
 |  |  |  | W 15 FEET |  |  | W 15 FEET | L
 |  |  |  | W 12 FEET |  |  | W 12 FEET | L |  |  |  |  |  |  | 4500 |  | 5000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4500
 | How to get best combination with minimum loss |  |  |  |  |  |  |  |  |  |  |  |  |  | 58500
 |  |  |  |  |  |  |  |  |  |  |  | 4500 | 5000
 |  |  |  |  |  |  |  |  |  |  |  | 375
Spreadsheet: 59838d1260375941-drop-down-list-values-dependant-on-value-of-another-drop-down-list-dummy-worksheet1
Sheet: Sheet1

Status | Cancellation/ NTU Reason |  | NTU Drop
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Status | Cancellation/ NTU Reason
Lapse | Global Policy
NTU | policy wording not as concise
NTU | policy wording not as concise
NTU | policy wording not as concise
NTU | policy wording not as concise
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Lapse
Spreadsheet: 72091d1272791279-excel-2007-updating-data-to-another-sheet-with-update-command-button-book2
Sheet: Invoice 

 | INVOICE
 |  | Company Name
 |  | Address |  |  | DATE:
 |  |  |  |  | INVOICE #
 |  |  |  |  | D.C Date:
 |  |  |  |  | D.C #
 | [NAME] To:         ID |  |  | Ship To
 | Customer
 | Address
 | City
 | Pin Code
 | Mobile
 | [NAME]
 | Sales By | Purchase Order No. | P.O.Date | Ship Via | Ship Date | Due Date
 | PRODUCT ID | [NAME] | UNIT | QUANTITY | UNIT PRICE | AMOUNT
 | P01 | Backing Compound | Kits | 2 | 2437
 |  |  |  | SUB TOTAL
 |  |  |  | CST / VAT
 |  |  |  | SHIPPING & HANDLING |  | 0
 |  |  |  | TOTAL
 |  |  |  | ADVANCE |  | 0
 |  |  |  | TOTAL DUE
 | Terms & Conditions:
 | this command button to get userform for inputing customer details |  |  | I want to update the filled in data on this Invoice template,into InvoiceDate Sheet on clicking Update Invoice
 | I have no problem with this
Spreadsheet: 543c38ce-72d6-48c0-b208-806d440517a4
Sheet: Sheet1

Oct - Nov 2010
NAME/DATE | Sun 24 | Mon 25 | [NAME] 26 | Wed 27 | Thurs 28 | Fri 29 | Sat 30
ALVIN | OFF | P.M | P.M | OFF | P.M | OFF | P.M
SHAHIL | P.M | OFF | A.M | P.M | A.M | P.M | OFF
ANUSHKA | A.M | A.M | OFF | A.M | OFF | A.M | A.M
TINA | A.M | A.M | OFF | A.M | OFF | A.M | A.M
NAME/DATE | Sun 31 | Mon 01
ALVIN | P.M | P.M
SHAHIL | OFF | A.M
ANUSHKA | P.M | OFF
TINA | P.M | OFF
NAME/DATE | Mon 01 | [NAME] 02 | Wed 03 | Thurs 04 | Fri 05 | Sat 06 | Sun 07
ALVIN | P.M | OFF | OFF | P.M | P.M | P.M | P.M
SHAHIL | A.M | P.M | P.M | OFF | A.M | OFF | OFF
ANUSHKA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
TINA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
NAME/DATE | Mon 08 | [NAME] 09 | Wed 10 | Thurs 11 | Fri 12 | Sat 13 | Sun 14
ALVIN | P.M | P.M | P.M | P.M | OFF | OFF | OFF
SHAHIL | A.M | OFF | OFF | A.M | P.M | P.M | P.M
ANUSHKA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
TINA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
NAME/DATE | Mon 15 | [NAME] 16 | Wed 17 | Thurs 18 | Fri 19 | Sat 20 | Sun 21
ALVIN | OFF | OFF | OFF | OFF | OFF | P.M | P.M
SHAHIL | P.M | P.M | P.M | P.M | P.M | OFF | A.M
ANUSHKA | A.M | A.M | A.M | A.M | A.M | A.M | OFF
TINA | A.M | A.M | A.M | A.M | A.M | A.M | OFF
NAME/DATE | Mon 22 | [NAME] 23 | Wed 24 | Thurs 25 | Fri 26 | Sat 27 | Sun 28
ALVIN | P.M | P.M | OFF | A.M | P.M | OFF | OFF
SHAHIL | A.M | OFF | P.M | P.M | OFF | P.M | P.M
ANUSHKA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
TINA | OFF | A.M | A.M | OFF | A.M | A.M | A.M
Spreadsheet: 879532d1727105205-problem-in-auto-generating-12-mths-of-eomonth-eomonth
Sheet: Interest

 |  |  |  |  |  |  | From A4:A5, I wish to get the Yellow colour
 |  |  |  |  |  |  | Why my formula do not work? B4 and C4.
 |  |  |  | What I want
2019-04-01 00:00:00 |  |  |  | 2019-04-30 00:00:00
2020-04-01 00:00:00 |  |  |  |  |  | 2019-05-31 00:00:00
 |  |  |  |  |  | 2019-06-30 00:00:00
 |  |  |  |  |  | 2019-07-31 00:00:00
 |  |  |  |  |  | 2019-08-31 00:00:00
 |  |  |  |  |  | 2019-09-30 00:00:00
 |  |  |  |  |  | 2019-10-31 00:00:00
 |  |  |  |  |  | 2019-11-30 00:00:00
 |  |  |  |  |  | 2019-12-31 00:00:00
 |  |  |  |  |  | 2020-01-31 00:00:00
 |  |  |  |  |  | 2020-02-29 00:00:00
 |  |  |  |  |  | 2020-03-31 00:00:00
Spreadsheet: 836a833b-78b6-41ab-b35d-e973325c1abe
Sheet: Summer 2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
HSE Continuing Studies
Summer 2016
Subject | Course and Title | Subtitle/Alternate Title | Section | [NAME] | Part of Term | Dates | Days | Times | Credits | Instructor(s) | Instructor ID | FT or Adj | Contract Code | Percentage | Tuition Code | Amount Per Credit | Registration Approval | [NAME] | Blackboard Y/N | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list?   SUBJ CRSE SEC | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 710007d1608660102-need-help-calculating-lunch-breaks-example-clock-in_out-data
Sheet: Sheet1

State | Project | FirstName | LastName | Manager | TrackingDate | StartTime | EndTime | Lunch
WA | XYZ | [NAME] | [NAME] | J Childs | 2020-12-14 00:00:00 | 08:00:00 | 12:30:00
WA | XYZ | [NAME] | [NAME] | J Childs | 2020-12-14 00:00:00 | 12:59:16 | 17:00:00
WA | XYZ | Doug | Wills | D Bax | 2020-12-14 00:00:00 | 07:59:00 | 12:22:00
WA | XYZ | Doug | Wills | D Bax | 2020-12-14 00:00:00 | 12:49:16 | 17:00:00
WA | XYZ | [NAME] | [NAME] | J Childs | 2020-12-15 00:00:00 | 07:30:00 | 11:25:00
WA | XYZ | [NAME] | [NAME] | J Childs | 2020-12-15 00:00:00 | 11:56:00 | 16:30:00
WA | XYZ | Doug | Wills | D Bax | 2020-12-15 00:00:00 | 06:32:00 | 10:40:33
WA | XYZ | Doug | Wills | D Bax | 2020-12-15 00:00:00 | 11:15:22 | 15:15:00
WA | ABC | [NAME] | Moore | D Bax | 2020-12-16 00:00:00 | 05:01:01 | 09:55:21
WA | ABC | [NAME] | Moore | D Bax | 2020-12-16 00:00:00 | 10:22:23 | 15:30:55