tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 862653d1710319409-attendance-downloaded-data-time-format-issue-time-format
Sheet: Sheet1

SAP No. | [NAME] | Name | AttendanceDate | FirstIn | LastOut | WorkHour | Department |  | FirstIn (Time Format | LastOut (Time Format)
33653 | 33653 | K NARENDER REDDY | 12 Mar 2024 | 05:38:00 | 14:00:00 | 0:00 | CLEARING
33655 | 33655 | MANORANJAN ROUT | 12 Mar 2024 | 05:38 | 14:00 | 8:00 | WAREHOUSE
33657 | 33657 | [NAME] | 12 Mar 2024 | 05:38 | 14:05 | 8:00 | COLDFORM
57238 | 57238 | M RAJU | 12 Mar 2024 | 05:40:00 | 14:02 | 0:00 | COLDFORM
80002649 | 80002649 | [NAME] | 12 Mar 2024 | 08:45 |  | 0:00 | IR
80002657 | 80002657 | SAYED TAJUDDIN | 12 Mar 2024 | 05:40 | 14:04 | 8:00 | IR
80002761 | 80002761 | ABSHEK KUMAR | 12 Mar 2024 | 21:40 | 06:02 | 8:00 | WELDING
80002782 | 80002782 | SUSHANTH KUMAR | 12 Mar 2024 |  |  | 0:00 | FABRICATION
80002787 | 80002787 | BIMLESH KUMAR | 12 Mar 2024 | 05:39 | 14:02 | 8:00 | WELDING
80002788 | 80002788 | SIKANDHAR KUMAR | 12 Mar 2024 | 05:39 | 14:05 | 8:00 | WELDING
80002792 | 80002792 | B ADHI REDDT | 12 Mar 2024 |  |  | 0:00 | WELDING
80002821 | 80002821 | RAJESHWARA SAHOO | 12 Mar 2024 | 21:39 | 06:00 | 8:00 | WELDING
The data shown above is the attendance of employees, downloaded from an Attendance Software.
Col. E & F shows IN and OUT punches.  Since the data is downloaded, it doesn't come in TIME FORMAT.
Col.E & F data converted to Time Format (In Col.J & K) and is working fine.
Due to technical reasons / unrecognised face or finger print, sometimes punch time will be blank.
Time Office executive will force change the data with appropriate timings.
When we enter Time in BLANK cell, the data is showing in Time format, but data in Col. J & K is not showing the time.
Need Col. J & K to display overall timings (Downloaded and manually changed)
Secondly I would be grateful, if the Cells are highlighted in Yellow Colour whenever someone changes the data manually in the sheet (I highlighted now manually in Yellow for your better understanding of the issue)
Kindly help.
Spreadsheet: 858064d1706835853-excel-solver-linearize-a-non-linear-equation-due-to-multiplication-of-variable-solver-work
Sheet: 1C

 |  |  | Warehouses |  |  | Wholesaler
 |  | Supplier | London | [NAME] | [NAME] | 1 | 2 | 3 | 4 | 5 |  |  | Production
 |  | Bristol | 25 | 23 |  | 80 |  | 90 | 100 | 86 |  |  | 40000
 |  | Leeds | 30 | 27 | 30 |  | 70 | 54 |  | 100 |  |  | 50000
 |  | London |  |  |  | 37 | 31 |  | 40 | 44
 |  | Birmingham |  |  |  | 36 | 40 | 43 | 40 | 46
 |  | [NAME] |  |  |  | 45 | 42 | 30 |  | 36
 |  |  |  |  | Wholesale Req | 15000 | 20000 | 13000 | 14000 | 16000
 |  | Decision Variable - Movement Allocation
 |  |  | Warehouses |  |  |  |  |  |  |  | Wholesaler
 |  | Supplier | London | [NAME] | [NAME] |  |  |  |  | Supplier | 1 | 2 | 3 | 4 | 5
 |  | Bristol | 19858.31316031983 | 3950.026904984991 | 0 |  | <= | 40000 |  | Bristol | 5074.993317688727 | 0 | 0 | 5074.996318522728 | 6041.670298483726 |  | <=
 |  | Leeds | 0 | 11049.97309503094 | 3483.316186282858 |  | <= | 50000 |  | Leeds | 0 | 4833.336384263199 | 13000 | 0 | 6041.670309850449 |  | <=
 |  | London |  |  |  |  |  |  |  | London | 1741.657796652394 | 15166.6636157368 | 0 | 1741.657796341307 | 1208.333951589325 |  | <=
 |  | Birmingham |  |  |  |  |  |  |  | Birmingham | 6441.691052531168 | 0 | 0 | 7183.345885135966 | 966.6670869213506 |  | <=
 |  | [NAME] |  |  |  |  |  |  |  | [NAME] | 1741.65783312771 | 0 | 0 | 0 | 1741.658353155149 |  | <=
 |  | x |  |  |  |  |  |  |  | Total
 |  | b | 1 | 1 | 1 |  |  |  |  |  | >= | >= | >= | >= | >=
 |  | M | 1000000 | 1000000 | 1000000 |  |  |  |  | Wholesale Req | 15000 | 20000 | 13000 | 14000 | 16000
 |  | z
 |  | M*b
 |  | x-M(1-b) |  |  |  |  |  |  |  |  | Wholesaler
 |  |  | <= | <= | <= |  |  |  |  | Supplier | 1 | 2 | 3 | 4 | 5
 |  |  | 20000 | 15000 | 12000 |  |  |  |  | Bristol
 |  |  |  |  |  |  |  |  |  | Leeds
 |  | Transportation Cost from Factory to Warehouse |  |  |  |  |  |  |  | London
 |  |  | Warehouses |  |  |  |  |  |  | Birmingham
 |  | Supplier | London | [NAME] | [NAME] |  |  |  |  | [NAME]
 |  | Bristol
 |  | Leeds
 |  | London
 |  | Birmingham
 |  | [NAME]
 |  |  |  |  |  | Total Cost
Spreadsheet: 729238d1618973856-creating-a-new-permit-register-permit-register-example-2
Sheet: ABC Job Register

ABC Job Number | Address | Job Description | Client | Job    Received | Quote Sent | Date of Confirmation  to Proceed | Status | Permit  Number | BP Lodged | OP - Final Inspection | OP - Completed | [NAME] | Invoice Date | Comments
ABC-21001 | Address 1 | Description 1 | Client 1 | 2021-03-01 00:00:00 | 2021-03-02 00:00:00 | 2021-03-05 00:00:00 | BP | 123/123/123
ABC-21002 | Address 2 | Description 2 | Client 2 | 2021-04-01 00:00:00
ABC-21003 | Address 3 | Description 3 | Client 3 | 2021-04-02 00:00:00
ABC-21004 | Address 4 | Description 4 | Client 4 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00
ABC-21005 | Address 5 | Description 5 | Client 5 | 2021-04-04 00:00:00 | 2021-04-05 00:00:00 | 2021-04-10 00:00:00 | BP | 456/456/456
ABC-21006 | Address 6 | Description 6 | Client 6 | 2021-04-04 00:00:00
ABC-21007 | Address 7 | Description 7 | Client 7 | 2021-04-08 00:00:00 | 2021-04-09 00:00:00
ABC-21008 | Address 8 | Description 8 | Client 8 | 2021-04-08 00:00:00
ABC-21009 | Address 9 | Description 9 | Client 9 | 2021-04-10 00:00:00 | 2021-04-11 00:00:00
ABC-21010 | Address 10 | Description 10 | Client 10 | 2021-04-10 00:00:00 | 2021-04-12 00:00:00 | 2021-04-15 00:00:00 | BP | 789/789/789
ABC-21011
ABC-21012
ABC-21013
ABC-21014
ABC-21015
ABC-21016
ABC-21017
ABC-21018
ABC-21019
ABC-21020
ABC-21021
ABC-21022
ABC-21023
ABC-21024
ABC-21025
ABC-21026
ABC-21027
ABC-21028
ABC-21029
ABC-21030
ABC-21031
ABC-21032
ABC-21033
ABC-21034
ABC-21035
ABC-21036
ABC-21037
ABC-21038
ABC-21039
ABC-21040
ABC-21041
ABC-21042
ABC-21043
ABC-21044
ABC-21045
Spreadsheet: 70780d1271454660-names-to-numbers-mileage-log
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form |  |  |  | http://www.hypermiler.co.uk/mpg-calculator.html
 |  |  |  | http://www.hmrc.gov.uk/cars/advisory_fuel_current.htm
Employee Name | [NAME] | Rate Per Mile |  |  | 0.12 |  | per lit | 1.09
Employee ID |  | For Period |  |  | From 25/10/09 to 27/10/09 |  | per gal | 4.9595
Vehicle Description | fiat 500 | Total Mileage |  |  | 200 |  | per mile | 12p
Authorized By |  | Total Reimbursement |  |  | 24
Date | Starting Location | Destination | Description/Notes | Hours | [NAME] | Odometer End | Mileage | Reimbursement
 |  |  |  |  | not used | not used
2009-10-25 00:00:00 | Cwmbran | newport risca | [NAME] | 4 |  |  | 80 | 9.6
2009-10-27 00:00:00 | Cwmbran | newport risca | Shahima, [NAME],[NAME] | 7 |  |  | 120 | 14.4
 |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | 0 | 0
 |  |  |  | 11 |  | Totals | 200 | 24
 |  | mario | 45
 |  | rachelle | 35 |  | Cwmbran
 |  | shahima | 35 |  | Newport
 |  | [NAME] | 40 |  | Risca
 |  | chenga | 35
Spreadsheet: 00fbdf62-0505-450e-bf01-7f96861540c1
Sheet: Slettede matvarer

Slettede matvarer i MVT (14 stk)
01.073 | [NAME], med vaniljesmak
[NAME] | St. paulin, ost
01.180 | [NAME] dressing med urter
01.201 | [NAME] ost, lettere
01.209 | Brunost, Litago
03.293 | Servelat, 3 % fett
03.294 | Leverpostei, 3 % fett
06.561 | Syltetøy, 250 g sukker pr. [NAME]
06.562 | Syltetøy, 500 g sukker pr. [NAME]
06.563 | Syltetøy, 750 g sukker pr. [NAME]
06.564 | [NAME], 1000 g sukker pr. [NAME]
08.020 | Remulade, lett
08.115 | Margarin, ICA, flytende
08.116 | Margarin, [NAME] og stek, Coop
Spreadsheet: 537801d1505269046-using-possible-conditional-averageifs-and-countifs-excel-forum-template-tester-and-assistant
Sheet: Sheet1

 |  |  |  |  | [NAME] | [NAME] | [NAME] |  |  | Multiplier
 |  |  |  | Apples | 4 | 2 | 5 |  |  | 1
 |  |  |  | Oranges | 3 | 2 | 3 |  |  | 2
 |  |  |  | Bananas | 1 | 1 | 2 |  |  | 3
 |  | Fruit | Multiplier |  |  | Result
 |  | Apples | 1 |  | [NAME] |  |  | INDEX($F$2:$F$4, MATCH($C$7,$E$2:$E$4,0))*$D$7 + INDEX($F$2:$F$4, MATCH($C8,$E$2:$E$4,0))*$D$8 + INDEX($F$2:$F$4, MATCH($C9,$E$2:$E$4,0))*$D$9 +  INDEX($F$2:$F$4, MATCH($C10,$E$2:$E$4,0))*$D$10
 |  | Oranges | 1 |  | [NAME]
 |  | Apples | 2 |  | [NAME]
 |  | Bananas | 1
Spreadsheet: 2e48a8d8-c031-4580-9841-9e25995c8e38
Sheet: Notes

 | a. | Reduced historical and projected demand.
 | b. | Increased historical and projected demand.
 | c. | Forecast based upon information provided by the Canadian Numbering Authority (CNA).  The CNA normally provides only one projection per year. Change is from last forecast provided.
 | d. | Canadian NPA.  With an exhaust date beyond 2035, there is generally no exhaust date provided.
 | e. | NPA is at exhaust.  No codes available except for returns.
 | f. | New NPA added.
 | g. | Area Code 321A includes only Brevard County Florida; 321/407 includes the Counties around Orlando in Central Florida.
 | h. | Area Code 305A includes only the [NAME] area of Florida;  Area Code 305/786 is the Miami-Dade area of Florida.
 | i. | Reflects Delta NRUF forecast
 | j. | New NPA overlay complex in Illinois; 872 overlays 312 and 773; 773 and 312 are not overlaying each other.
 | k. | NPA Exhaust is beyond 30 years or the NPA exhaust moves to less than 30 years.
 | l. | NPA 404 (Atlanta) is no longer shown separately but is included with the overlay complex 404/470/678/770
Spreadsheet: 32965d1229124266-adding-tabs-of-same-sheet-how-to-update-summary-tab-2009-employee-attendance-tracker1
Sheet: Summary

 | Summary for all employees
 |  |  | Days
 | Letter | Meaning | Jan. | Feb. | Mar. | Apr. | May | June | July | Aug. | Sep. | Oct. | Nov. | Dec. | Total
 | A | Absent without reason | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | D | Disability | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | E | Essential | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | H | Holiday | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 6
 | I | Illness | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | B | Late back from break | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | L | Leave (unpaid) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | N | No work | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | S | Suspended | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | T | Tardy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | V | Vacation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | W | Workers' compensation | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total days |  | 1 | 0 | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 1 | 6
Spreadsheet: 526125d1499152374-need-dynamic-vlookup-if-possible-without-helper-column-vlookup-problem
Sheet: Sheet1

ID | Created By | Department | New Department | Right Department
2089 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME] |  | This is what I get
2090 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME] |  | This is what I need from sheet 2
2091 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME]
2092 | Johansson, Christoffer | 91700 | 91838 Vehicle and [NAME]
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: June

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 737952d1624698899-dependent-dropdowns-with-spaces-and-symbols-dependent-dropdown-with-spaces-and-symbols-aligw
Sheet: Sheet1

 |  | A1 / Z1 (blablabla) | Zebra - does eat |  | Lookup
 |  | Phase 1 | Test 1 |  | A1 / Z1 (blablabla) | A1___Z1__blablabla
 |  | Phase 2 | Test 2 |  | Zebra - does eat | Zebra___does_eat
 |  | Phase 3 | Test 3
 |  | Phase 4 | Test 4
 |  | Banana (Fruit) and Apples | Test 5
 |  |  | Test 6
 |  |  | Test 7
 |  |  | Test 8
 |  |  | Test 9
 |  |  | Walking & Sleeping - Today
Spreadsheet: 813737d1673964518-identifying-text-and-sorting-data-accordingly-text_finden_2-_neu
Sheet: Tabelle1

[NAME] |  |  |  | [NAME] |  |  |  | Anlieferung 3 |  |  |  | [NAME] |  |  |  | Anlieferung 5 |  |  |  | Anlieferung 6 |  |  |  |  |  | Freude | B | C | D | E | F
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should 15
 |  |  | 10 |  |  |  | 15 |  |  |  | 23 |  |  |  | 41 |  |  |  | 7 |  |  |  | 19
The formula is not working when I expend the range.
It should count both "Freude", and each result in one cell (see "Should")
Spreadsheet: 805406d1668664103-trying-to-finalize-consignment-calculator-with-tiered-rates-labyrin
Sheet: Sheet1

2022 Consignment Rates |  |  |  |  |  |  |  | Item Payout Estimator (Enter Your Item Value To Estimate Payout)
THE BEST CONSIGNMENT RATES - YOU PAY ZERO PROCESSING FEES |  |  |  |  |  |  |  | THE BEST CONSIGNMENT RATES - YOU PAY ZERO PROCESSING FEES
RATES FOR INDIVIDUAL AUCTIONS |  |  |  |  |  |  |  | RATES FOR INDIVIDUAL AUCTIONS
SALES PRICE |  |  | Qty |  | PAYOUT |  |  | SALES PRICE |  |  | Qty |  | Enter item Price | Payout
0 | 9.99 |  | 1 |  | 3 |  |  | Item #1 |  |  | 1 |  | 10 | 7.5 | 10 | 0.85 | -1
10 | 49.99 |  | 1 |  | 0.85 | -1 |  | Item #2 |  |  | 1 |  | 2 | 3 | 0 | 3 | 0
50 | 99.99 |  | 1 |  | 0.86 |  |  | Item #3 |  |  | 1 |  | 47 | 38.95 | 10 | 0.85 | -1
100 | 499.99 |  | 5 |  | 0.88 |  |  | Item #4 |  |  | 1 |  | 121 | 106.48 | 100 | 0.88 | 0
500 | 999.99 |  | 1 |  | 0.88 |  |  | Item #5 |  |  | 1 |  | 45 | 37.25 | 10 | 0.85 | -1
1000 | 2499.99 |  | 1 |  | 0.89 |  |  | Item #5 |  |  | 1 |  | 12000 | 11280 | 10000 | 0.94 | 0
2500 | 4999.99 |  | 1 |  | 0.91
5000 | 9999.99 |  | 1 |  | 0.93 |  |  |  |  |  |  |  | Total Payout | 112.23
10000 | And Up |  | 1 |  | 0.94
999999
Spreadsheet: 780285d1652373171-return-multiple-values-across-many-rows-and-columns-20210302-projects
Sheet: Stg1 SIR Kambah

 |  | 2020-03-10 00:00:00
 | Task | Description | Contract Amount (ex GST) | Percent Complete | Billed To Date | Previously Billed | Current Billed
 | Stage 1 | Stage 1 SIR Kambah | 22700 |  |  | 0 | 22700
 |  | Project Total
 |  |  | Subtotal of This Invoice
 |  |  | GST
 |  |  | Invoice Total (Including GST)
Spreadsheet: 691994d1598003545-if-in-current-month-dont-use-growth-otherwise-use-growth-growth-dummy
Sheet: Assumptions

Month
Month | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
Period
2
Days
Working Days
Fiscal Period
AU
AT
BE
AE
FR
DE
IE
JP
LU
NL
SG
ES
CH
UK
US
HK
Spreadsheet: 816076d1675350320-calculating-a-total-when-a-cost-changes-between-ranges-iops-cost-calculator-020223
Sheet: Calculator

[NAME]
[NAME] |  |  |  |  |  |  |  |  | Cost Matrix
other |  | Volume Type | [NAME] |  |  | Input Test: | 36000 |  | 0.065 | 32000
 |  | [NAME] (in GB) | 100 |  |  |  |  |  | 0.046 | 64000
 |  | IOPS Calculation |  |  |  |  |  |  | 0.032 | 320000
 |  | IOPS Recommendation
 |  | Storage Cost (USD) per month
 |  | IOPS Cost (USD) per month
 |  | Total Cost (USD) per month
 |  | Volume Type | Pricing
 |  | Provisioned IOPS SSD ([NAME]) - Storage | $0.125/GB-month
 |  | Provisioned IOPS SSD ([NAME]) - IOPS | $0.065/provisioned IOPS-month up to 32,000 IOPS
 |  |  | $0.046/provisioned IOPS-month from 32,001 to 64,000 IOPS
 |  |  | $0.032/provisioned IOPS-month for greater than 64,000 IOPS†
 |  | Provisioned IOPS SSD (io1) [NAME] | $0.125 per GB-month of provisioned storage AND $0.065 per provisioned IOPS-month
Spreadsheet: 745243d1629818981-help-with-conditional-formatting-to-highlight-entire-row-book2
Sheet: Sheet1

 |  | Input
1234 | [NAME] | Data Set is Invalid
5678 | Walt Disney | [NAME]
1357 | [NAME] | Data is good.
 |  | Output
1234 | [NAME] | Data Set is Invalid
5678 | Walt Disney | [NAME]
1357 | [NAME] | Data is good.
Spreadsheet: 147935d1333040516-excel-2007-formula-to-retrieve-text-from-a-range-of-cells-example2
Sheet: Sheet1

Col A | Col b | Col c | Col d | Col E | Want to put a single column in F with the text of what is not blank in Col A-E
A1
 | b1
 |  | c1
 |  |  | d1
 |  |  | d2
 |  | c2
 |  |  | d3
 |  |  |  | e1
Spreadsheet: darrell_schoolcraft__7608__imball0201
Sheet: Citizens-Griffith

 | Citizens-Griffith
 | POI 78069 - Citizens Griffith
Day | Measured | Scheduled
1
2
3
4
5 | -214
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 67745
2002-01-05 00:00:00
CBS Volume
 |  |  | 36152
Spreadsheet: 132f810e-9e06-4aea-8d48-3ac4b24002fd
Sheet: 2008-09

Table D2
Intercalating Medical Students
Department | Full Time
Anthropology | 10
Division of Biosciences | 137
Division of Infection and Immunity | 13
Division of Medicine | 8
Division of Population Health | 11
Division of Psychology and [NAME]. | 28
Division of Surgery and Interventional Sci. | 31
Institute of Child Health | 42
Medical Physics | 19
Science and Technology Studies | 5
Wellcome Trust Centre History of Medicine | 21
Total
Spreadsheet: 838307d1690905850-total-a-column-where-the-name-to-the-left-is-x-book1
Sheet: Sheet1

 | Week 1 |  |  | Week 2 |  |  | etc
Items | 2 | Ian
 | 56 | Fred
 | 23 | [NAME]
 | 7 | [NAME]
 | 59 | Fred
 | 25 | [NAME]
 | 5000 | Ian
Totals | 5002 | Ian
 | 115 | Fred
 | 30 | [NAME]
 | 25 | [NAME]
Names change all the time, so must work off whatever names it finds
Spreadsheet: 122797d1317152429-creating-a-sorted-spreadsheet-using-data-from-2-separate-sheets-copy-of-copy-of-test-data-1
Sheet: Sheet1

CAPTION_ID | DIRECTORY_CODE | SUB_SECTION | DISPLAY_ORDER | OM_ORDER_ID | ARCHIVE_TYPE | CAPTION_STATUS | LINE_TYPE | LISTING_ID | [NAME] | INDENT_LEVEL | DISPLAY_TEXT | DISPLAY_NUMBER | SORT_TEXT | USE_LISTING_TEXT | USE_LISTING_PHONE | PLA | CREATION_TIMESTAMP | CREATED_BY | UPDATE_TIMESTAMP | UPDATED_BY | APPLICATION_ID | APPLICATION_DATE | [NAME]
1 | 2 | CO1 | 0 | 909090 | B | A | SH | 111111 | 21111 | 0 | Store | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 1 | 909090 | B | A | SH | 111112 | 21112 | 1 | Pharmacy | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 2 | 909090 | B | A | SH | 111113 | 21113 | 2 | Deli | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
1 | 2 | CO1 | 3 | 909090 | B | A | SH | 111114 | 21114 | 3 | Bakery | [PHONE] |  |  |  |  | 2011-03-17 00:00:00 | 1111111 | 2011-03-17 00:00:00 | 1111111 | 1111111 | 2011-03-17 00:00:00
Spreadsheet: 852686d1702637986-formula-for-daily-deduction-of-customer-account-with-daily-limit-dynamic-deduction-aligw
Sheet: Outstanding

Cust_Code | Inv | Amount | Bank_Ref |  | Bank_Ref | Limit/Day
M1201 | #1 | 577 | B1 |  | B1 | 500
M1203 | #2 | 611 | B1 |  | B2 | 600
M1515 | #3 | 300 | B2 |  | B3 | 1000
[NAME] | #4 | 478 | B3 |  | B4 | No Limit
M1619 | #5 | 353 | B2
M1700 | #6 | -545 | B4
Bank_Ref | Outstanding | Limit | Day1 | Day2 | Day3 | Day4
 | 1188 | 500 |  | 500 | 188
B2 | 653 | 600 |  | 53
B3 | 478 | 1000
 |  |  | * is there a way to make the blue portion dynamic?
 |  |  | * How do I exclude in my list in which the outstanding is negative, eg, B4?
 | 1188 | 500 | 500 | 500 | 188
B2 | 653 | 600 | 600 | 53
B3 | 478 | 1000 | 478 | 478
Spreadsheet: 760002d1639901275-family-numbering-family-numbering
Sheet: Sheet1

 |  | NAME
1 | 1 | A |  | 1.1
 | 2 | B |  | 1.2
 | 3 | C |  | 1.3
2 | 1 | D |  | 2.1
 | 2 | E |  | 2.2
 | 3 | F |  | 2.3
 | 4 | G |  | 2.4
3 | 1 | H |  | 3.1
 | 2 | I |  | 3.2
 | 3 | J |  | 3.3
 | 4 | K |  | 3.4
 | 5 | L |  | 3.5
 |  | TO BE CONTINUE
Spreadsheet: 114688d1310413638-pivot-table-subtotal-of-subtotals-subtotal-subtotals-pivot-table
Sheet: Sheet3

Row Labels | Sum of Payment Amount
[NAME]
Electric Company
2011-01-01 00:00:00 | 60
2011-02-01 00:00:00 | 5
2011-03-01 00:00:00 | 65
2011-04-01 00:00:00 | 125
Electric Company Total | 255
Gas Company
2011-01-11 00:00:00 | 20
2011-02-11 00:00:00 | 45
2011-03-11 00:00:00 | 105
Gas Company Total | 170
Water Company
2011-01-09 00:00:00 | 25
2011-02-09 00:00:00 | 25
2011-03-09 00:00:00 | 85
2011-04-09 00:00:00 | 145
Water Company Total | 280
[NAME] | 705
[NAME]
Electric Company
2011-01-01 00:00:00 | 50
2011-02-01 00:00:00 | 26
2011-03-01 00:00:00 | 28
2011-04-01 00:00:00 | 30
2011-05-01 00:00:00 | 32
Electric Company Total | 166
Water Company
2011-01-06 00:00:00 | 25
2011-02-06 00:00:00 | 27
2011-03-06 00:00:00 | 29
2011-04-06 00:00:00 | 31
Water Company Total | 112
[NAME] | 278
[NAME]
Electric Company
2011-02-04 00:00:00 | 15
2011-03-01 00:00:00 | 25
2011-04-01 00:00:00 | 65
Electric Company Total | 105
Water Company
2011-01-04 00:00:00 | 55
2011-01-07 00:00:00 | 35
2011-02-07 00:00:00 | 5
2011-03-07 00:00:00 | 45
Water Company Total | 140
[NAME] | 245
Electric Company Grand Total
Water Company Grand Total
Gas Company Grand Total
Grand Total | 1228
Spreadsheet: 85911d1285905528-dynamic-number-of-points-to-plot-in-chart-dynamic-names-and-charts-ver-3
Sheet: sheet1

mon | 10
tue | 30
wed | 23
thu | 34
fri | 6
sat | 56
[NAME] | 34
mon | 56
tue | 76
wed | 23
thu | 45
fri | 44
sat | 89
[NAME] | 50
mon | 111
tue | 125
wed | 55
thu | 23
fri | 18 |  | Number of Points to Plot | 9
sat | 66
[NAME] | 78 |  | XValues | =OFFSET(sheet1!$A$1,(MATCH(9.9E+30,sheet1!$B:$B))-10,0,10,1)
mon | 113 |  | YValues | =OFFSET(sheet1!XValues,0,1)
tue | 84
wed | 34 |  | MATCH FORMULA | =MATCH(9.9E+30,B:B)
thu |  |  | MATCH VALUE | 24
fri
sat
[NAME]
mon
tue
wed
thu
fri
sat
[NAME]
Spreadsheet: adc757a2-73f5-49e1-bb94-be7f33d71bb0
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7365 | 40957 | Iain | Dawson | GBR | 7 | [NAME] | 00:01:10 | [NAME] | 00:00:00 | 00:24:09 | 1 | 01:04:38
7365 | 47908 | [NAME] | Filipovic | SRB | 8 | 00:13:19 | 00:01:45 | 00:29:01 | 00:00:00 | 00:21:33 | 2 | 01:05:39
7365 | 57308 | Oren | Blitzblau | ISR | 3 | 00:14:05 | 00:02:11 | 00:32:41 | 00:00:00 | [NAME] | 3 | 01:14:02
7365 | 56297 | [NAME] | Bocchi | ITA | 6 | 00:13:44 | 00:01:27 | [NAME] | 00:00:00 | 00:25:27 | 4 | 01:14:47
7365 | 17485 | Alberto | Ceriani | ITA | 5 | 00:15:04 | 00:01:46 | 00:32:23 | 00:00:00 | 00:26:51 | 5 | [NAME]
7365 | 56085 | Evangelos | Barlas | GRE | 4 | 00:23:22 | 00:02:20 | 00:32:25 | 00:00:00 | 00:27:25 | 6 | 01:25:37
Spreadsheet: 107797d1304952321-find-tangency-portfolio-copy-of-relativeresourcemanager
Sheet: ws10 (1)

m1 | 0.1 |  | Tangency portfolio
m2 | 0.15 |  | excess return | weight
sig1 | 0.2 |  | 0.05
sig2 | 0.25 |  | 0.09999999999999999
rho | 0.3
rf | 0.05 |  | mu | sig
 |  |  | 0.05 | 0
k | 1-k | mup | sigp
0 | 1 | 0.15 | 0.25
0.1 | 0.9 | 0.145 | 0.2317865397299852
0.2 | 0.8 | 0.14 | 0.2154065922853802
0.3 | 0.7 | 0.135 | 0.201308221391974
0.4 | 0.6 | 0.13 | 0.19
0.5 | 0.5 | 0.125 | 0.182002747232013
0.6 | 0.4 | 0.12 | 0.1777638883463118
0.7 | 0.3 | 0.115 | 0.177552809045647
0.8 | 0.2 | 0.11 | 0.1813835714721706
0.9 | 0.09999999999999998 | 0.105 | 0.189010581714358
1 | 0 | 0.1 | 0.2