tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713095d1610553694-data-transfer-from-one-worksheet-to-others-golf-group-composite-spreadsheet2
Sheet: Work Sheet

 | Team #1 | Avg | +/- |  | Team #2 | Avg | +/- |  |  | NAME | AVG
 | [NAME] | 104 | 15 |  | [NAME] | 94 |  |  |  | [NAME] | 104
 | [NAME] | 100 | 9 |  | Billy | 93 |  |  |  | [NAME] | 100
 | Al | 99.33333333333333 | 8 |  | [NAME] | 93 |  |  |  | Al | 99.33333333333333
 | [NAME] | 95.66666666666667 | 6 |  | Rich | 89.66666666666667 |  |  |  | [NAME] | 95.66666666666667
 | [NAME] | 95.5 | 6 |  | [NAME] | 89 |  |  |  | [NAME] | 95.5
 | Sub-Total |  |  |  | Sub-Total |  |  |  |  | [NAME] | 94
 | Total |  |  |  | Total |  |  |  |  | Billy | 93
 |  |  |  |  |  |  |  |  |  | [NAME] | 93
 | Team #3 | Avg | +/- |  | Team #4 | Avg | +/- |  |  | Rich | 89.66666666666667
 | [NAME] | 89 |  |  | JV | 85 |  |  |  | [NAME] | 89
 | [NAME] | 88.5 |  |  | [NAME] | 84.5 |  |  |  | [NAME] | 89
 | Byron | 88.5 |  |  | [NAME] | 82.66666666666667 |  |  |  | [NAME] | 88.5
 | Gene | 88 |  |  | [NAME] | 81 |  |  |  | Byron | 88.5
 | [NAME] | 86.66666666666667 |  |  | [NAME] | 80 |  |  |  | Gene | 88
 | Sub-Total |  |  |  | Sub-Total |  |  |  |  | [NAME] | 86.66666666666667
 | Total |  |  |  | Total |  |  |  |  | JV | 85
 |  |  |  |  |  |  |  |  |  | [NAME] | 84.5
 | Team #5 | Avg | +/- |  |  |  |  |  |  | [NAME] | 82.66666666666667
 | [NAME] | 79.66666666666667 |  |  |  |  |  |  |  | [NAME] | 81
 | [NAME] | 79.66666666666667 |  |  |  |  |  |  |  | [NAME] | 80
 | [NAME] | 78.5 |  |  |  |  |  |  |  | [NAME] | 79.66666666666667
 | Mitch | 75.33333333333333 |  |  |  |  |  |  |  | [NAME] | 79.66666666666667
 |  |  |  |  |  |  |  |  |  | [NAME] | 78.5
 | Sub-Total |  |  |  |  |  |  |  |  | Mitch | 75.33333333333333
 | Total
Spreadsheet: 102691d1300676916-index-match-fifthnpop
Sheet: Roll-Up

 |  |  |  |  |  | Jan 10 | Feb 10 | [NAME] 10 | Apr 10 | May 10 | Jun 10 | Jul 10 | Aug 10 | Sept 10 | Oct 10 | Nov 10 | Dec 10 | Jan 11 | Feb 11
 | Ordinary Income/Expense
 |  |  | Income
 |  |  |  | 4010 · Fees
 |  |  |  | 4050 · Sales
 |  |  | Total Income
 |  |  | Cost of Goods Sold
 |  |  |  | 5050 · Shop Supplies
 |  |  |  | 5070 · Member Services
 |  |  |  |  | 5073 - Beer, Wine & Soda
 |  |  |  |  | 5070 · Member Services - Other
 |  |  |  | Total 5070 · Member Services
 |  |  | Total [NAME]
 |  | Gross Profit
 |  |  | Expense
 |  |  |  | 6020 · Advertising Expense
 |  |  |  | 6110 · Automobile Expense
 |  |  |  | 6120 · Bank Service Charges
 |  |  |  | 6135 · Credit Card Merchant Fees
 |  |  |  | 6160 · [NAME] and Subscriptions
 |  |  |  | 6170 · Equipment Rental
 |  |  |  | 6180 · Insurance
 |  |  |  | 6200 · Interest Expense
 |  |  |  |  | 6210 · Finance Charge
 |  |  |  | Total 6200 · Interest Expense
 |  |  |  | 6260 · Printing and Reproduction
 |  |  |  | 6335 · Salon Supply Expenses
 |  |  |  | 6336 · Towels
 |  |  |  | 6340 · Telephone
 |  |  |  | 6341 · Website Services
 |  |  |  | 6342 · Email & Internet Services
 |  |  |  | 6350 · Travel & Ent
 |  |  |  |  | 6370 · Meals
 |  |  |  | Total 6350 · Travel & Ent
 |  |  |  | 6390 · Utilities
 |  |  |  |  | 6393 - CAM
 |  |  |  |  | 6400 · Gas and Electric
 |  |  |  |  | 6410 · Water
 |  |  |  |  | 6415 · Cable
 |  |  |  |  | 6390 · Utilities - Other
 |  |  |  | Total 6390 · Utilities
 |  |  |  | 6550 · Office Supplies
 |  |  |  | 6551 · Outsourced Services
 |  |  |  | 6560 · Payroll Expenses
 |  |  |  | 6820 · Taxes
 |  |  |  | 6862 · To be indentified
 |  |  | Total Expense
 | Net Ordinary Income
Net Income
Spreadsheet: d6e61dd5-4c76-41a0-a566-bcbddc231f0f
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
FATF | Test | FATF | Fat, Feces | Fat, F | Nuclear Magnetic Resonance (NMR) Spectroscopy | Stool Container: Stool |  |  | 5 | g | Container/Tube: Stool container (Supply T291) [NAME]	 Preferred: 48 or 72 hour collection Acceptable: 24 hour or random collection Collection Instructions: Timed or Random Collection 1. For a timed collection, the entire collection is required. a. All containers must be sent together. b. The entire collection must contain at least 5 g. 2. For a random collection, a minimum of 5 g (do not send entire collection) is required. 3. The number of containers sent should be indicated on the labels (1 of 4, for example). 4. See Stool Collection Information Sheet in Special Instructions. Additional Information: 1. Timed Collections: Length of collection period is required. 2. A separate order and collection should take place if stool bicarbonate, calcium, chloride, magnesium, osmolality, pH, potassium, sodium, , or any microbiology testing is desired. 3. For 3 days prior to and during the collection period: a. Patient should be on a fat-controlled diet (100-150 g fat per day). b. No laxatives (particularly mineral oil and castor oil) c. No synthetic fat substitutes (eg, Olestra) or fat-blocking nutritional supplements 4. The use of diaper rash ointments will falsely elevate test results. Discontinue use during collection period.  5. Barium interferes with test procedure; a waiting period of 48 hours before stool collection analysis is recommended. Forms: If not ordering electronically, submit a General Request Form (Supply T239) with the specimen. | 5 g | Hemolysis	NA Thawing	Warm OK; Cold OK  Lipemia	NA Icterus	NA Other	NA | TIMED COLLECTION  > or =18 years: 2-7 g fat/24 hours Reference values have not been established for patients who are <18 years of age.   RANDOM COLLECTION  All ages: 0-19% fat | Monday through Friday | 1 day | 3 days | 1 | 82710 |  |  |  |  | Rochester
FATF | [NAME] | FECAL | Fecal |  |  |  | Frozen | 180 days
FATF | Order Question | [NAME] | Duration |  | Plain Text
FATF | Result | STWT | Total Weight | Total Weight | Numeric |  |  |  |  | g |  |  |  |  |  |  |  |  |  | 30078-0
FATF | Result | [NAME] | Duration | Duration | Alphanumeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13363-7
FATF | Result | PFAT | % Fat | % Fat | Numeric |  |  |  |  | % fat |  |  |  |  |  |  |  |  |  | In Process
FATF | Result | TFAT | Total Fat/24 Hr | Total Fat/24 Hr | Numeric |  |  |  |  | g/24 h |  |  |  |  |  |  |  |  |  | 16142-2
Spreadsheet: 820921d1678350869-need-a-formula-to-count-down-hours-worked-vs-next-pay-increase-on-excel-timesheet-test
Sheet: Mar 16-31

[NAME]
 |  | 330 | STS-Thomas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pay Period 7
 |  |  |  |  |  |  |  |  |  |  |  |  | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step | Next Step |  | March 16 - 31
 |  |  |  |  |  |  |  |  |  |  |  |  | 50 | 50 | 50 | 50 | 50 | 50 | 50 | 50 |  | 2023
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER |  | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 | JAB | Thur | 14 | 12
 | sns | Fri | 15 | 10 |  |  |  |  |  |  |  | 2
 | JAB | Sat |  | Off
 | JAB | Sat | 16 | Off
 | JAB | Sun | 17 | Off
 | JAB | Mon | 18 | Holiday |  |  |  |  |  | 6
 | JAB | Tue |  | Off |  |  |  |  |  |  | 14
 | JAB | Wed |  | 12
 | JAB | Thur |  | 12
 | JAB | Fri |  | 12
 | JAB | Sat |  | 4 |  |  |  |  |  |  |  | 2
 | JAB | Sat | 23 | 6
 | DLE | Sun | 24 | Off
 | DLE | Mon | 25 | Off |  |  |  |  |  |  | 12
 | DLE | Tue |  | Off |  |  |  |  |  |  | 12
 |  | Tue
 |  | TOTALS
 |  |  |  | REG | COMP USED | SICK | VAC | HOL USED | WORK HOL | WORK HOL OT | OT | Built in OT |  | EARN COMP | OTHER | DAILY TOTAL | OT Premium | COACH | TRAINER | COACH OT | TRAINER OT
 |  |  | reg hours forward |  |  |  |  |  |  |  |  |  |  |  |  |  | 50% | 3% | 9%
 |  |  | available leave
 |  |  | I certify that the foregoing payroll is just, true and correct; that the person whose name appears [NAME]
 |  |  | actually worked or was on authorized leave as shown; and that the salaries are due and unpaid.
 |  | EMPLOYEE SIGNATURE |  |  |  |  |  |  |  |  | DATE |  |  |  |  | AUTHORIZING SIGNATURE |  |  |  |  |  | DATE
Spreadsheet: 268447d1380641868-lookup-with-drop-down-result-simple_lookup
Sheet: Sheet1

name | product1 | product2 | product3 |  | lookup value (manual entry) | product (expected result)
saza | a | b | c |  | [NAME] | x
[NAME] | x | z |  |  |  | z
maria | r |  |  |  | maria | r
etc. |  |  |  |  | saza | a
 |  |  |  |  |  | b
 |  |  |  |  |  | c
 |  |  |  |  | etc
Spreadsheet: 488417d1478644815-keep-different-cells-in-the-same-row-after-moving-one-example2
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | 27.4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | 26.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72 | 25.6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | 24.7
2027 | 67 |  | 100000 |  |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 74 | 23.8
 |  |  |  |  |  |  | 0.03 |  |  |  |  |  |  |  |  |  |  |  |  | 75 | 22.9
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
 |  |  |  |  |  |  | 0.03
Spreadsheet: 194443d1353172831-decision-model-in-terms-of-resource-constraint-solver_production
Sheet: Solver_setup

 | Machine Hours per Product |  |  |  | Optimum Monthly Hours
 | Product_A | Product_B | Product_C | Product_D
Machine_1 | 4 | 2 | 5 | 1
Machine_2 | 3 | 7 | 8 | 1
Machine_3 | 6 | 5 | 7 | 2
Machine_4 | 3 | 5 | 6 | 3
Machine_5 | 4 | 2 | 2 | 2
Monthly demand | 750 | 1000 | 2500 | 1500 | < ---------------- | This can't be right, these values are 10 times to high in my opinion!
Contribution/ Unit | 6 | 8 | 2.5 | 10
 | Machine Hours per Product
 | Product_A | Product_B | Product_C | Product_D
Machine_1 | 4 | 2 | 5 | 1
Machine_2 | 3 | 7 | 8 | 1
Machine_3 | 6 | 5 | 7 | 2
Machine_4 | 3 | 5 | 6 | 3
Machine_5 | 4 | 2 | 2 | 2
 | Units produced |  |  |  |  | Constraint
 | Product_A | Product_B | Product_C | Product_D | Tot hrs used | optimum hrs.
Machine_1 | 0 | 93 | 0 | 1
Machine_2 | 61 | 0 | 0 | 149.0000000004096
Machine_3 | 0 | 2 | 55 | 0
Machine_4 | 14 | 4 | 19 | 0
Machine_5 | 0 | 1 | 87 | 0
Total
Demand (constraint) | 75 | 100 | 250 | 150 |  | <------------ | Scaled down demand by a factor of 10
[NAME] contribution
Spreadsheet: cara_semperger__1437__PGE_NOVEMBER_MIDC_PATHS
Sheet: NOV (16-17)

 |  |  | To Portland General Electric : [NAME], [NAME], and [NAME]
 |  |  | Phone 464-7067
 |  |  | From Enron: Cara, [NAME], and [NAME] |  |  |  |  |  | DAILY COLSTRIP = 0
 |  |  | Phone 464-3814, 3902, 3831 |  |  |  |  |  | MONTH LONG COLSTRIP = 47 ATC
 |  |  |  |  |  |  |  |  | LENDING = 20 [NAME]
 |  |  |  |  | Mid Columbia Paths
11/16-17/2001
 | HLH
 | DAY | 10 | PSPL(G)MIDC | X | PINWEST | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 3 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 9 | GRANT | X | BP | ENRON | PGE | X | COLSTRIP B/R
 | DAY | 6 | LENDING | X | PGE | ENRON | AIRPROD | X | PSEI-CONROL AREA
 | DAY | 5 | LENDING | X | PGE | ENRON | EQUILON | X | PSEI-CONROL AREA
 | DAY | 9 | LENDING | X | PGE | ENRON | SNCL | X | MORGAN-BPA(T)MIDC/JD-BPA(T)JD/MAL5-APX1-CISO(T)MAL5/NP-APX
 | MONTH | 25 | AVISTA(G)CHELAN | X | AVISTA | ENRON | PGE | X | COLSTRIP B/R
 | LLH
 | DAY | 1 | BPA C#10440-CLATSKANPE-BPA(T)BPAP/PGE #10649NF | X | CLATSKANPE | ENRON | PGE |  | COLSTRIP B/R
 | DAY | 21 |  | X | CHELAN | ENRON | PGE |  | COLSTRIP B/R
 | MONTH | 25 | WWP(G)MIDC | X | WWP | ENRON | PGE | X | COLSTRIP B/R
 | MONTH COLSTRIP PATHS
 | ALL HOURS
 | MONTH | 6 |  | X | PGE | ENRON | ASHGROVE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 6 |  | X | PGE | ENRON | EXPRESS PIPE | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 7 |  | X | PGE | ENRON | HOLNAM | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 8 |  | X | PGE | ENRON | LOUISIANA P | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 5 |  | X | PGE | ENRON | LUZENAC | X | MPCO NETWORK TRANSMISSION TO LOAD
 | MONTH | 15 |  | X | PGE | ENRON | SMURFIT | X | MPCO NETWORK TRANSMISSION TO LOAD
Spreadsheet: 56034d1256160600-criteria-of-counting-cells-example
Sheet: FIWP Totals

CWP | FIWP | Total EHT | Total Installed
25C12 | 25C-F138-12-01 | 23 |  | In cell [NAME] I need to count all the trace insalled in sheet 250 with the fiwp in b3
25D12 | 25D-F138-12-01 | 57
25D12 | 25D-F138-12-03 | 81
25D52 | 25D-F138-52-01 | 76
25D55 | 25D-F138-55-01 | 7
25D55 | 25D-F138-55-02 | 23
25D55 | 25D-F138-55-03 | 5
25D55 | 25D-F138-55-04 | 19
25D55 | 25D-F138-55-05 | 8
25E12 | 25E-F138-12-01 | 2
25E30 | 25E-F138-30-01 | 0
25F12 | 25F-F138-12-01 | 1
25G12 | 25G-F138-12-01 | 10
25G34 | 25G-F138-34-01 | 2
25H12 | 25H-F138-12-01 | 11
25M20 | 25M-F138-20-01 | 9
26B12 | 26B-F138-12-01 | 0
27A13 | 27A-F138-13-01 | 0
27B13 | 27B-F138-13-01 | 0
45D02 | 45D-F138-02-01 | 0
45D02 | 45D-F138-02-02 | 0
45D02 | 45D-F138-02-03 | 113
Spreadsheet: 768676d1645079117-sum-values-based-on-multiple-criteria-learnexcel3
Sheet: Daily

Date | Details | Category | Pay Mode | Sub Details | Amount | Balance | Total
2001-01-01 00:00:00 | Opening | Opening | Cash |  | 323.5
2001-01-01 00:00:00 | Opening | Opening | ENBD |  | 669.3 |  |  |  |  | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
2001-01-01 00:00:00 | Opening | Opening | NoL |  | 113 |  |  |  | Incomes
2001-01-01 00:00:00 | Opening | Opening | Pay IT |  | 1000
2001-01-01 00:00:00 | Opening | Opening | SIB |  | 795.55 |  |  |  | Cash | Need Monthly incomes of only "Cash"
2006-01-01 00:00:00 | December | Salary | ENBD |  | 1000 |  |  |  | ENBD
2009-01-01 00:00:00 | Dinner | Food | Cash |  | -10 |  |  |  | NoL
2009-01-01 00:00:00 | Water | Beverages | Cash |  | -2 |  |  |  | Pay IT
2009-01-01 00:00:00 | Breakfast | Food | Cash |  | -4.5 |  |  |  | SIB
2009-01-01 00:00:00 | RTA | Transport | NoL |  | -7.5
2009-01-01 00:00:00 | Transport | Transport | Cash |  | -250 |  |  |  | Expenses
2009-01-01 00:00:00 | Dinner | Food | Cash |  | -7
2010-01-01 00:00:00 | Office | OfficeRent | Cash |  | 500 |  |  |  | Cash | Need Monthly Expenses of only "Cash"
2010-01-01 00:00:00 | Office | LoanReturn | Cash |  | 969 |  |  |  | ENBD
2010-01-01 00:00:00 | Lunch | Food | ENBD |  | -18.75 |  |  |  | NoL
2010-02-01 00:00:00 | Vegetables | [NAME] | SIB |  | -7.45 |  |  |  | Pay IT
2010-02-01 00:00:00 | Dinner | Food | Cash |  | -5 |  |  |  | SIB
2011-02-01 00:00:00 | Vegetables | [NAME] | SIB |  | -7
2011-02-01 00:00:00 | [NAME] | [NAME] | SIB |  | -2.94
2011-02-01 00:00:00 | Dinner | Food | Cash |  | -13
2012-02-01 00:00:00 | Hyper | [NAME] | SIB |  | -20.66
2012-02-01 00:00:00 | Spieces | [NAME] | SIB |  | -15
2013-02-01 00:00:00 | Dinner | Food | Cash |  | -2
2014-02-01 00:00:00 | Missing | Others | Cash |  | -3
2014-02-01 00:00:00 | Dinner | Food | Cash |  | -2
2015-02-01 00:00:00 | Lunch | Food | Cash |  | -3
2015-02-01 00:00:00 | Masala | [NAME] | SIB |  | -6.25
2015-02-01 00:00:00 | Butchery | [NAME] | SIB |  | -8.99
2015-02-01 00:00:00 | Salad | Food | SIB |  | -3.43
2015-02-01 00:00:00 | Salad | Food | SIB |  | -2.78
2015-02-01 00:00:00 | Butchery | [NAME] | SIB |  | -8.99
2015-02-01 00:00:00 | Yuogart | [NAME] | SIB |  | -5.75
2015-02-01 00:00:00 | Vegetables | [NAME] | SIB |  | -1.4
2015-02-01 00:00:00 | Vegetables | [NAME] | SIB |  | -3.27
2015-02-01 00:00:00 | Vegetables | [NAME] | SIB |  | -2.6
2015-02-01 00:00:00 | [NAME] | [NAME] | SIB |  | -30.45
2015-02-01 00:00:00 | Dinner | Food | Cash |  | -2.75
Spreadsheet: 726746d1617399622-formula-to-return-the-longest-stretch-of-days-from-one-event-to-the-next-event-example
Sheet: Sheet1

EVENT TYPE | DATE OF EVENT | LOCATION OF EVENT | #OF DAYS |  |  | # OF DAYS SINCE LAST EVENT
fall | 2021-01-01 00:00:00 | shop 1
cut | 2021-02-04 00:00:00 | shop 2 |  |  |  | FALL | CUT | SCRAPE | TRIP
scrape | 2021-02-10 00:00:00 | shop 3
scrape | 2021-02-16 00:00:00 | shop 2
cut | 2021-02-22 00:00:00 | shop 1 |  |  | previous record ---> | ? | ? | ? | ?
trip | 2021-02-28 00:00:00 | shop 3
trip | 2021-03-06 00:00:00 | shop 1
cut | 2021-03-12 00:00:00 | shop 2
fall | 2021-03-18 00:00:00 | shop 3
Spreadsheet: 218359d1362434713-combine-multiple-rows-into-one-comma-separated-column-compantexample
Sheet: Example

CustomerID | Name | UserID | IsActive | FirstName | LastName | Full Name
10000001 | Company Name 1 | 99911 | 1 | [NAME] | Smith | [NAME]
10000002 | Company Name 2 | 99912 | 0 | [NAME] | Smith | [NAME]
10000003 | Company Name 3 | 99913 | 1 | Emily | Smith | [NAME]
10000004 | Company Name 4 | 99914 | 1 | [NAME] | Smith | [NAME],[NAME]
Spreadsheet: 822335d1679278601-merge-tables-and-sum-in-different-sheets-book1
Sheet: Feb

 |  |  |  |  |  |  |  |  |  |  | Result
PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
A |  | 1 |  | 1 |  |  |  |  |  |  | PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
B |  |  |  |  |  | 1 |  |  |  |  | A | 1 | 1 | 1 | 1 | 1 | 1
C | 1 |  |  | 1 | 1 |  |  |  |  |  | B | 1 | 1 | 1 | 1 | 1 | 1
D |  | 1 |  |  |  | 1 |  |  |  |  | C | 1 | 1 | 1 | 1 | 1 | 1
E | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | D | 1 | 1 | 1 | 1 | 1 | 1
F |  |  |  |  |  | 1 |  |  |  |  | E | 1 | 1 | 1 | 1 | 1 | 1
G |  | 1 | 1 |  |  |  |  |  |  |  | F | 1 | 1 | 1 | 1 | 1 | 1
H | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | G | 1 | 1 | 1 | 1 | 1 | 1
I |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  | H | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | I | 1 | 1 | 1 | 1 | 1 | 1
PRODUCT | 10 | 20 | 30 | 40 | 50 | 60 | TOTAL
H |  |  |  |  |  | 1
I | 1
Spreadsheet: 800376d1665635043-calculate-time-between-two-dates-subjected-to-rigid-time-formats-tme-between-a-and-c
Sheet: Hoja1

dd/hhmm | hhh+mm | dd/hhmm
21/1345 |  | 05/1111 |  | Because of dependency on volatile month
30/1000 |  | 02/0415 |  | This formula will work for about four weeks
16/0544 |  | 21/1155 |  | when the dates are in different months
02/1205 |  | 05/1305
13/1825 |  | 14/1900
29/1621 |  | 23/1200
Best Solution: |  |  |  | Having the right initial month and year
 |  |  |  | Initial
dd/hhmm | hhh+mm | dd/hhmm |  | Month | Year | Starting Date
21/1345 |  | 05/1111 |  | 10 | 2022
30/1000 |  | 02/0415 |  | 10 | 2022
16/0544 |  | 21/1155 |  | 12 | 2022
02/1205 |  | 05/1305 |  | 10 | 2022
13/1825 |  | 14/1900 |  | 10 | 2022
29/1621 |  | 23/1200 |  | 10 | 2022
Spreadsheet: 75895d1276512825-average-of-value-in-different-cells-in-multiple-worksheet-test-vsb-reco-201011-and-summary-sheet
Sheet: Oct'10

 |  | [NAME]
 |  | Monthly Reconciliation
 |  | 2010-10-31 00:00:00
 |  | Summary of Stocks
 |  | New Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value
 |  |  |  |  |  |  |  |  | 0 | 0
 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Used Stock | Fully Paid |  | Int. Bearing |  | Free Funded |  | Totals |  | Units over | % Of Stock
 |  |  | Units | Value | Units | Value | Units | Value | Units | Value | 70 Days | Overage
 |  | Stock 1 |  |  |  |  |  |  | 0 | 0
 |  | Stock 2 |  |  |  |  |  |  | 0 | 0
 |  | Stock 3 |  |  |  |  |  |  | 0 | 0
 |  | Stock 4 |  |  |  |  |  |  | 0 | 0
 |  | Stock 5 |  |  |  |  |  |  | 0 | 0
 |  | Stock 6 |  |  |  |  |  |  | 0 | 0
 |  | Totals | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 0064f787-13e0-41fa-bcba-96215b953a37
Sheet: L

Course color corresponds with term of offering. BLUE for Spring  semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Latin
LATN 211-212 | Foreign Language
LATN 215 | Foreign Language
LATN 341 | Arts & Literature-Literature
LATN 342 | Arts & Literature-Literature
LATN 343 | Arts & Literature-Literature
LATN 344 | Arts & Literature-Literature
LATN 345 | Arts & Literature-Literature
LATN 346 | Arts & Literature-Literature
LATN 347 | Arts & Literature-Literature
LATN 348 | Arts & Literature-Literature
LATN 481-482 |  | Experiential-Research
LATN 487-488 |  | Experiential-Research
LATN 496-498 |  | Experiential-Research
Spreadsheet: 830911d1685242962-conditional-formatting-cells-based-on-multiple-cell-contents-test-13-
Sheet: Sheet1

Job/Veh | Job no | 44273 | Client | SMITH | Com/PO | 1234 | Make | MERC | Model | SPRINTER | Cab | S/C | WB | LWB | DRW | Y | Chassis | 123456789 | [NAME]. | AB12CDE
Storage | Arrived | 2023-10-10 00:00:00 | Yard | F3 | Tag | 643 | Colour | BLACK | Stk chk'd | Y |  |  |  |  |  |  | Disp. Dt
Production | [NAME] |  | [NAME] | Y | BLD Spec | 14ft, K-DS, [NAME], Beac, [NAME], Tool B |  |  |  |  |  |  |  |  | %Fin | 1 | Sent S2 | Y | PDI | Y
Dispatch | Damage | OSR wheel arch scuff |  |  |  |  | Notes | signature on handover |  |  |  |  |  |  |  |  | Delivery | customer pickup
Job/Veh | Job no | 44273 | Client | SMITH | Com/PO | 1234 | Make | MERC | Model | SPRINTER | Cab | S/C | WB | LWB | DRW | Y | Chassis | 123456789 | [NAME]. | AB12CDE
Storage | Arrived | 2023-10-10 00:00:00 | Yard | F3 | Tag | 643 | Colour | BLACK | Stk chk'd | Y |  |  |  |  |  |  | Disp. Dt
Production | [NAME] | 25 | [NAME] | Y | BLD Spec | 14ft, K-DS, [NAME], Beac, [NAME], Tool B |  |  |  |  |  |  |  |  | %Fin | 1 | Sent S2 | Y | PDI | Y
Dispatch | Damage | OSR wheel arch scuff |  |  |  |  | Notes | signature on handover |  |  |  |  |  |  |  |  | Delivery | customer pickup
Job/Veh | Job no | 44273 | Client | SMITH | Com/PO | 1234 | Make | MERC | Model | SPRINTER | Cab | S/C | WB | LWB | DRW | Y | Chassis | 123456789 | [NAME]. | AB12CDE
Storage | Arrived | 2023-10-10 00:00:00 | Yard | F3 | Tag | 643 | Colour | BLACK | Stk chk'd | Y |  |  |  |  |  |  | Disp. Dt | 2023-12-15 00:00:00
Production | [NAME] | 25 | [NAME] | Y | BLD Spec | 14ft, K-DS, [NAME], Beac, [NAME], Tool B |  |  |  |  |  |  |  |  | %Fin | 1 | Sent S2 | Y | PDI | Y
Dispatch | Damage | OSR wheel arch scuff |  |  |  |  | Notes | signature on handover |  |  |  |  |  |  |  |  | Delivery | customer pickup
Spreadsheet: 846002d1697296300-how-to-count-no-of-employees-per-interval-excel-coverage-template
Sheet: Coverage

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
All Depts | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 2023-10-07 00:00:00 | 2023-10-08 00:00:00
00:00:00 | 0
01:00:00 | 1
02:00:00 | 2
03:00:00 | 3
04:00:00 | 4
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
Spreadsheet: 716264d1612131645-solved-return-the-first-time-a-value-appears-sample
Sheet: Sheet1

 | 2021-01-31 00:00:00 | 2021-01-30 00:00:00 | 2021-01-29 00:00:00 | 2021-01-28 00:00:00 | 2021-01-27 00:00:00 | 2021-01-26 00:00:00 | Function result should be:
City
Los Angeles | 1 | 0 | 1 | 0 | 1 | 0 | 2021-01-27 00:00:00
Palo Alto | 1 | 1 | 0 | 0 | 0 | 0 | 2021-01-30 00:00:00
San Francisco | 0 | 0 | 0 | 0 | 0 | 0 | 0
San Mateo | 1 | 0 | 0 | 0 | 0 | 0 | 2021-01-31 00:00:00
[NAME] | 1 | 1 | 1 | 1 | 1 | 1 | 2021-01-26 00:00:00
Spreadsheet: 126217d1319569517-automated-list-of-discrepancies-in-columns-and-arrays-separate-sheets-list-sample
Sheet: Actual

ID | State
99827 | PA
99828 | PA
99829 | PA
99830 | PA
99831 | PA
99832 | NY
99833 | NY
99834 | NY
99835 | PA
99836 | PA
99837 | NY
99838 | PA
99839 | PA
99840 | PA
99841 | PA
99842 | PA
47443 | NY
47444 | PA
47445 | PA
47448 | NY
47459 | PA
47480 | NY