tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 766912d1644164527-problem-regarding-building-a-portfolio-sheet-1portfolio-tracker
Sheet: Home - Full View

 | Portfolio Tracking Template
 | Created by Kryptik. Follow me on Twitter @kryptik_ta and find my new blog at https://coinscribe.substack.com/
 | 📍 Step 1: Select File > Make a copy to enable editing of this sheet
 | 📍 Step 2: Input your desired portfolio mix under Target Allocation
 | ⚠️ Green highighted cells are for you to modify; take care in modifying other cells as formulas might break
 | 📍 Step 3: Override placeholder metrics with your holdings in the Crypto Portfolio and All Positions tabs
 | 📍 Step 4: Check that auto-calculations are correct and play around with the Simple Balance Sheet at the bottom of this page
 | 📍 Step 5: Delete unnecessary instructions and sections; make this your own
 | 🍻 Please share feedback, improvements, etc.
 | Start Here 👇
 | Target Allocation |  |  |  | Actual Allocation |  |  |  |  |  | Difference from Target
 | Input your desired mix (add to 100%) |  |  |  | Don't edit — metrics will auto-populate |  |  |  |  |  | Don't edit — metrics will auto-populate
 | Asset |  | % |  | Asset |  | $ |  | % |  | Asset |  | $
 | Cash |  | 0.1 |  | Cash |  |  |  |  |  | Cash
 | Equities |  | 0.3 |  | Equities |  |  |  |  |  | Equities
 | Real Estate |  | 0.25 |  | Real Estate |  |  |  |  |  | Real Estate
 | Crypto |  | 0.25 |  | Crypto |  |  |  |  |  | Crypto
 | Commodities |  | 0.1 |  | Commodities |  |  |  |  |  | Commodities
 | [Custom - I]
 | [Custom - II]
 | [Custom - III]
 |  | Sum |  |  |  | Sum
 | Simple Balance Sheet
 | Assets |  |  |  |  | Liabilities
 | Modify green cells with assets not included in your investment positions (e.g. paid-off vehicles, collectibles, NFTs, etc.). Non-green cells will auto-populate — don't edit. |  |  |  |  | Log your debts; do not include crypto borrowing debts as those are accounted for in your crypto investment position.
 | Cash |  |  |  |  | Student Loans |  | 20000 |  | 20000
 | Equities |  |  |  |  | Car Loan |  | 8000 |  | 20001
 | Real Estate |  |  |  |  | Credit Card Debt |  | 2000 |  | 20002
 | Crypto |  |  |  |  |  |  | 0 |  | 20003
 | Commodities |  |  |  |  |  |  | 0 |  | 20004
 |  |  |  |  |  |  |  | 0 |  | 20005
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Assets |  |  |  |  | Total Liabilities
 |  |  |  |  |  |  | Net Position
Spreadsheet: 716250d1612121467-retrieve-filtered-rows-from-one-table-into-another-tables-sample
Sheet: Sheet1

id | region | quantity |  | northerns |  | Northerns | Quantity | Height
1 | North | 100 |  |  |  | 1
2 | North | 200 |  |  |  | 2
3 | South | 100 |  |  |  | 4
4 | North | 300 |  |  |  | 7
5 | South | 100 |  |  |  | 8
6 | South | 400 |  |  |  | 9
7 | North | 500 |  |  |  | 11
8 | North | 100 |  |  |  | 14
9 | North | 200 |  |  |  | 15
10 | South | 100 |  |  |  | 16
11 | North | 300 |  |  |  | 18
12 | South | 100 |  |  |  | 21
13 | South | 400
14 | North | 500
15 | North | 100
16 | North | 200 |  |  |  | This table is what I want. Here, the "Northerns" column is manual, but I want it dynamic, from the source table
17 | South | 100
18 | North | 300
19 | South | 100
20 | South | 400
21 | North | 500
source table
Spreadsheet: 40404d1238709389-how-to-keep-avoid-unwanted-negative-numbers-unwanted-negative-numbers
Sheet: Sheet1

Time 1 | Time 2 | Interval in Minutes |  | The formula in Column C calculates the interval between the two times in minutes
07:21:00 | 07:39:00 | 17.99999999999994
07:40:00 | 1900-01-01 00:00:00 | -460 |  | Sometimes Time 2 is entered as 0:00
07:24:00 |  | -444 |  | Sometimes Time 2 is left blank
08:00:00 | 08:15:00 | 15.00000000000003 |  | Either way, the output of the formula is a negative number
08:10:00 | 08:11:00 | 1.000000000000076 |  | What I want is for the cell to be either zero or blank if the output of the
 |  |  |  | formula is less than zero
Spreadsheet: 764394d1642707960-determining-work-time-based-on-criteria-splitshiftwttranspose
Sheet: Data (4)

 | Span of Shift | Report for Roll Call | Start 1st Shift of Work | End Shift | Half Pay | Break | Report for 2nd Roll Call | Start of 2nd Shift of Work | 11th hr | End of 2nd Shift and Work Day |  | Job Time | Report Time | Commute Time | Work Time | Straight Time |  | Over Time
 |  |  | 04:30:00 | 08:39:00 |  |  | 12:12:00 | 12:12:00 |  | 15:39:00 |  |  | 0:10:00
 |  |  | 04:35:00 | 11:19:00 |  |  | 14:30:00 | 14:40:00 |  | 15:43:00 |  |  | 0:20:00
 |  |  | 04:36:00 | 09:08:00 |  |  | 12:44:00 | 12:54:00 |  | 16:11:00 |  |  | 0:20:00
 |  |  | 04:44:00 | 12:44:00 |  |  | 14:30:00 | 14:40:00 |  | 15:56:00 |  |  | 0:20:00
 |  |  | 05:05:00 | 07:55:00 |  |  | 11:27:00 | 11:27:00 |  | 16:51:00 |  |  | 0:10:00
 |  |  | 05:08:00 | 08:37:00 |  |  | 11:05:00 | 11:15:00 |  | 15:28:00 |  |  | 0:20:00
 |  |  | 05:20:00 | 10:10:00 |  |  | 12:43:00 | 12:43:00 |  | 17:30:00 |  |  | 0:10:00
 |  |  | 05:28:00 | 10:12:00 |  |  | 13:15:00 | 13:25:00 |  | 19:18:00 |  |  | 0:20:00
 |  |  | 05:30:00 | 11:27:00 |  |  | 12:35:00 | 12:45:00 |  | 16:03:00 |  |  | 0:20:00
 |  |  | 05:35:00 | 11:13:00 |  |  | 16:15:00 | 16:25:00 |  | 17:42:00 |  |  | 0:20:00
 |  |  | 05:55:00 | 08:10:00 |  |  | 11:13:00 | 11:13:00 |  | 17:09:00 |  |  | 0:10:00
 |  |  | 06:00:00 | 10:59:00 |  |  | 14:30:00 | 14:40:00 |  | 17:48:00 |  |  | 0:20:00
 |  |  | 06:01:00 | 10:19:00 |  |  | 14:00:00 | 14:10:00 |  | 17:32:00 |  |  | 0:20:00
 |  |  | 06:06:00 | 12:43:00 |  |  | 14:30:00 | 14:40:00 |  | 16:00:00 |  |  | 0:20:00
 |  |  | 06:25:00 | 09:24:00 |  |  | 12:30:00 | 12:40:00 |  | 17:21:00 |  |  | 0:20:00
 |  |  | 06:15:00 | 08:05:00 |  |  | 10:31:00 | 10:31:00 |  | 17:11:00 |  |  | 0:10:00
 |  |  | 06:25:00 | 10:31:00 |  |  | 13:50:00 | 14:00:00 |  | 17:33:00 |  |  | 0:20:00
 |  |  | 06:27:00 | 11:09:00 |  |  | 14:24:00 | 14:34:00 |  | 18:29:00 |  |  | 0:20:00
 |  |  | 06:30:00 | 11:15:00 |  |  | 13:20:00 | 13:30:00 |  | 17:51:00 |  |  | 0:20:00
 |  |  | 06:33:00 | 15:09:00 |  |  | 17:01:00 | 17:11:00 |  | 18:39:00 |  |  | 0:10:00
 |  |  | 06:51:00 | 08:15:00 |  |  | 10:20:00 | 10:30:00 |  | 18:19:00 |  |  | 0:20:00
 |  |  | 06:55:00 | 10:59:00 |  |  | 14:38:00 | 14:48:00 |  | 19:29:00 |  |  | 0:20:00
 |  |  | 07:03:00 | 08:53:00 |  |  | 10:40:00 | 10:50:00 |  | 18:46:00 |  |  | 0:20:00
 |  |  | 07:21:00 | 11:25:00 |  |  | 14:45:00 | 14:55:00 |  | 18:59:00 |  |  | 0:20:00
 |  |  | 07:24:00 | 08:10:00 |  |  | 11:00:00 | 11:10:00 |  | 21:26:00 |  |  | 0:20:00
 |  |  | 07:25:00 | 12:12:00 |  |  | 15:45:00 | 15:55:00 |  | 18:59:00 |  |  | 0:20:00
 |  |  | 07:55:00 | 10:58:00 |  |  | 14:13:00 | 14:23:00 |  | 19:35:00 |  |  | 0:20:00
 |  |  | 09:25:00 | 11:45:00 |  |  | 14:50:00 | 15:00:00 |  | 20:01:00 |  |  | 0:20:00
 |  |  | 11:05:00 | 14:23:00 |  |  | 15:20:00 | 15:30:00 |  | 21:18:00 |  |  | 0:20:00
Spreadsheet: 126949d1320076359-time-formated-cells-stay-blank-if-zero-book1-3-llll
Sheet: Sheet1

Venue of meet
Date of meet |  |  |  |  |  |  |  |  | Don't know | 2010-12-13 00:00:00 | 2011-06-19 00:00:00 | 2011-10-22 00:00:00 | 2011-10-23 00:00:00
Event | Offical PB's | Training PB's | county accepted times | Difference from county accepted times | Difference from county accepted times in seconds |  | Difference from county concidered times | Difference from club record
25 free
50 free |  |  | 00:00:33.300000 |  |  | 00:00:36 |  |  | 00:00:40.120000 | 00:00:44.800000 | 00:00:38.850000 |  | 00:00:38.120000
100 free |  |  | 00:01:11.300000 |  |  | 00:01:17 |  |  | 00:01:51.030000
200 free |  |  | 00:02:33.500000 |  |  | 00:02:45.800000 |  |  | 00:03:48.670000
400 free |  |  | 00:05:19.200000 |  |  | 00:05:45.300000
800 free
25 back
50 back |  |  | 00:00:37.700000 |  |  | 00:00:40.700000 |  |  | 00:00:48.200000 | 00:00:52.800000 | 00:00:45.220000 | 00:00:43.420000
100 back |  |  | 00:01:19.400000 |  |  | 00:01:25.400000 |  |  | 00:01:56.560000
200 back |  |  | 00:02:49.200000 |  |  | 00:03:02.800000 |  |  | 00:04:17.290000
400 back
800 back
25 breast
50 breast |  |  | 00:00:42.200000 |  |  | 00:00:45.600000 |  |  | 00:00:52.340000 | 00:01:00.440000 | 00:00:51.930000
100 breast |  |  | 00:01:30.600000 |  |  | 00:01:37.900000 |  |  | 00:02:31.440000
200 breast |  |  | 00:03:14.300000 |  |  | 00:03:29.800000
400 breast
800 breast
25 fly
50 fly |  |  | 00:00:36.400000 |  |  | 00:00:39.300000 |  |  | 00:00:44.480000 | 00:00:50.580000 | 00:00:42.520000 |  | 00:00:41.380000
100 fly |  |  | 00:01:19.100000 |  |  | 00:01:25.400000
200 fly |  |  | 00:02:53.500000 |  |  | 00:03:07.300000
400 fly
800 fly
100 IM |  |  | 00:01:22.900000 |  |  | 00:01:39.600000 |  |  | 00:01:47.670000 | DQ
200 IM |  |  | 00:02:52.900000 |  |  | 00:03:06.700000 |  |  | 00:04:28.530000
400 IM |  |  | 00:06:04.700000 |  |  | 00:06:33.900000
Spreadsheet: 61070d1261662959-multiple-choice-select-a-value-based-on-its-probability-of-occurring-book4
Sheet: Sheet1

question | A | B | C | D | E | OUTPUT
1 | 4 | 2 | 2 | 2 | 90 | E
2 | 6 | 1 | 90 | 2 | 1 | C
3 | 10 | 90 | 0 | 0 | 0 | B
Spreadsheet: 131192d1322778327-generating-list-from-parameters-help-copy-of-experimental-inspection-report
Sheet: Sheet1

Type | Location | Alarm | Zone
SD | unitks | Fail | 1
FT | Unit 106 | Fail | 2
HS | Unit 107 | Fail | 3
HS | Unit 108 | Fail | 4
HS | Unit 109 | Fail | 5
HS | Unit 110 | Pass | 6
HS | Unit 111 | Fail | 7
HS | Unit 112 | Fail | 8
SD | Unit 113 | Pass | 9
HS | Unit 114 | Fail | 10
Spreadsheet: 1a2b06e4-8f49-460f-b9d8-9cf65238814b
Sheet: Expense Report Instructions

Expense Report Instructions
Volunteers are required to submit claims for travel expenses within 45 days after the conclusion
of a trip.  Any claims submitted after the 45 day period will require the approval of the responsible
Vice-President, The [NAME], and the President.   Volunteers who do not meet these requirements
will be given a warning upon the first offense.
1. Enter your name and address onto the expense report.  Hit the arrow down to indicate
what board you belong to, if other, type in board name on the next line.
2. Indicate your member number, if available.
3. Please indicate the purpose of the trip, in the area requested.
4. List all the dates for travelling and destination.
5. List the location(s) of travel.
6. If you used your automobile during your travel, place an “X” under mile.
7. Enter the number of miles under the dates your automobile was used.  The total
expense will automatically pre-populate the amount of cost based on the mileage
allowance at the time.
8. If tolls and parking were charged, please enter amounts per day or as a total.
9. Some expenses such as taxi/bus, meals and tip/gratuities should be itemized on a
separate spreadsheet, supplied.  All but the taxi/bus section is pre-populated with the
dates.  Start on the second line and indicate the dates, fare, and to/from ride.  Only the
amounts and descriptions have to be entered for the other sections of the itemized
spreadsheet.
10. The expense report allows two lines for items that are not covered on the report, so
please provide the details and attach support documents.
11. If there is a different currency than the US dollar, place exchange rate at the time in the
place designated.  Do not mix currencies; please complete a separate report for each
currency.
12. Make sure that all expenses have been placed in the report and indicate if an advance
was given on the “Less Advance” line.
13.  Supply all original receipts for expenses above $25.  For air travel we need the boarding
pass (after travel) and a receipt/invoice.  Please tape or staple receipts to a separate
sheet of paper so they are not lost and submit with the expense report.
14. Expense Reports should be submitted to the designated approval authority or to the Sr.
Governance Budget Analyst at the IEEE Computer Society, 2001 L Street, Suite 700,
Washington, D.C. 20036 for payment.  Expense reports can be e-mailed (with scanned
receipts), faxed or mailed.
15. Please remember to submit all travel expenses within the current year (1 January – 31
December).  Year end submission: expenses above $1K can be accrued for current year
if submitted by the 2nd of January 2015, and amounts below $1K will have to be
submitted by the 12th of December 2014.