tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 541900d1507622078-lookup-many-not-standard-data-test
Sheet: Sheet1

Lookup table | Rating |  | Master Table | Rating
BINA DARMA |  |  | bina nusantara University | A
BINA DARMA |  |  | Binadarma | B
Bina Nusantara International University |  |  | [NAME] [NAME] Bangsa | B
binadaram |  |  | Sekolah Tinggi Manajemen Informatika [NAME] | B
Binadarma
bina nusantara international
bina nusantara University
bina nusantara University
Sekoah Tinggi Ilmu [NAME] (STIE) |  |  | with various not standard data, and standard master data, i cant just use vlookup, is there any way to lookup the rating
[NAME] [NAME] (STIE)
[NAME] [NAME] Bangsa
STIE BINA BANGSA BANTEN
Sekolah Tinggi Manajemen Informatika [NAME] (stimik) Bina Mulia [NAME]
Sekolah Tinggi Manajemen Informatika [NAME]
Sekolah Tinggi Manajemen Informatika [NAME] [NAME] Lubuk Linggau
Spreadsheet: 855055d1704780026-course-enrollment-averages-calculations-to-active-terms-book1
Sheet: Sheet1

Course | Term | Mode | ToT Enrl |  |  | Sum of ToT Enrl | Column Labels
HST 3111 | 20231 | Online | 87 |  |  | Row Labels | 20215 | 20231 | 20238 | 20241 | 20245 | Grand Total
HST 3111 | 20231 | Online | 32 |  |  | HST 2122 | 56 |  | 139 | 77 |  | 272
HST 3111 | 20241 | Online | 11 |  |  | Face to Face | 56 |  | 85 |  |  | 141
HST 3111 | 20245 | Face to Face | 74 |  |  | Online |  |  | 54 | 77 |  | 131
HST 3111 | 20215 | Face to Face | 52 |  |  | HST 3111 | 52 | 119 |  | 11 | 74 | 256
HST 2122 | 20215 | Face to Face | 56 |  |  | Face to Face | 52 |  |  |  | 74 | 126
HST 2122 | 20241 | Online | 77 |  |  | Online |  | 119 |  | 11 |  | 130
HST 2122 | 20238 | Online | 54 |  |  | Grand Total | 108 | 119 | 139 | 88 | 74 | 528
HST 2122 | 20238 | Face to Face | 85
 |  |  |  |  |  | Course | Mode | Average
 |  |  |  |  |  |  | Online | 43.33333333333334
 |  |  |  |  |  | HST 3111 | Face to Face | 63
 |  |  |  |  |  | HST 2122 | Face to Face | 70.5
 |  |  |  |  |  | HST 2122 | Online | 65.5
Spreadsheet: 390f6208-6b4e-4ffa-b0fb-222a254e3786
Sheet: Table 2.1

Monthly Statistical Bulletin
2.1 Average weekly ordinary time earnings
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
AWOTE – $ per week
November | 1226.8 | 1275.2 | 1330.1 | 1396 | 1437
May | 1250.1 | 1304.7 | 1349.2 | 1420.9 | 1454.1
Annual average | 1238.5 | 1289.95 | 1339.65 | 1408.45 | 1445.55
AWOTE annual change – per cent
November | 5.9 | 3.9 | 4.3 | 5 | 2.9
May | 5.2 | 4.4 | 3.4 | 5.3 | 2.3
Annual average | 5.6 | 4.2 | 3.85 | 5.1 | 2.6
Real AWOTE (a) – $ per week
November | 1369.95927698033 | 1384.98 | 1399.736998997996 | 1438.811579980373 | 1445.602729885058
May | 1374.782748691099 | 1387.61 | 1414.874987518722 | 1454.483650097466 | 1445.497893989588
Annual average | 1372.444869427592 | 1386.362240982349 | 1407.371767941986 | 1446.725794621027 | 1445.6
Real AWOTE annual change – per cent
November | 4.251624507964835 | 1.096672757232553 | 1.065265725931175 | 2.791565916336292 | 0.4719971676053314
May | 2.159273733216138 | 0.9327658850583287 | 1.965163697697103 | 2.799446094400615 | -0.6177969829551433
Annual average | 3.19756559813742 | 1.014056875054048 | 1.515442814191936 | 2.796277968300354 | -0.0778167241651917
(a) Expressed in average 2013-14 dollars; converted to real terms using the consumer
price index.
Sources: ABS, Average weekly earnings, Cat. no. 6302.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6302.0&viewtitle=Average%20Weekly%20Earnings,%20Australia~Nov%202007~Latest~21/02/2008&&tabname=Past%20Future%20Issues&prodno=6302.0&issue=Nov%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6302.0&viewtitle=Average%20Weekly%20Earnings,%20Australia~Nov%202007~Latest~21/02/2008&&tabname=Past%20Future%20Issues&prodno=6302.0&issue=Nov%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6302.0&viewtitle=Average%20Weekly%20Earnings,%20Australia~Nov%202007~Latest~21/02/2008&&tabname=Past%20Future%20Issues&prodno=6302.0&issue=Nov%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6302.0&viewtitle=Average%20Weekly%20Earnings,%20Australia~Nov%202007~Latest~21/02/2008&&tabname=Past%20Future%20Issues&prodno=6302.0&issue=Nov%202007&num=&view=& |  |  |  | Update
ABS, Consumer price index, Cat. no. 6401.0 | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=6401.0&viewtitle=Consumer%20Price%20Index,%20Australia~Dec%202007~Latest~23/01/2008&&tabname=Past%20Future%20Issues&prodno=6401.0&issue=Dec%202007&num=&view=& |  |  |  |  | 26 February 2015
Spreadsheet: 540768d1506958357-data-validation-copy-of-equipments-calibration
Sheet: Sheet1

PRODUCTION EQUIPMENT CALIBRATION
NAME | New Cal | ID# | CALIBRATION DATE | REMARKS
TIMER/STOP WATCH | 2017-01-17 00:00:00 | SWT-002 | 2018-01-17 00:00:00 | Done
TIMER/STOP WATCH |  | [NAME] | 2018-01-17 00:00:00 | Done
TIMER/STOP WATCH |  | SWT-006 | 2018-01-16 00:00:00 | Done
TIMER/STOP WATCH |  | SWT-007 | 2018-01-17 00:00:00 | Done
TIMER/STOP WATCH |  | SWT-008 | 2018-11-17 00:00:00
TIMER/STOP WATCH |  | SWT-009 | 2018-11-18 00:00:00
TIMER/STOP WATCH |  | SWT-011 | 2018-11-18 00:00:00
TIMER/STOP WATCH |  | SWT-010 | 2018-11-18 00:00:00
Spreadsheet: 163312d1340274526-help-with-formula-for-conditional-summing-of-cells-accounts-2012
Sheet: July - Sept

 | Warrington Parents and Carers Accounts Quarter 2 - July - September 2012
 | No | Date | Category | Description | Amount |  | Totals by category
 | 1.1 | 2012-07-01 00:00:00 | Rep Training | testing rep training | 100
 | 1.2 | 2012-07-02 00:00:00 | [NAME] | Coffee | 1800
 | 1.3 | 2012-07-03 00:00:00 | Forum | Biccies | 5 |  | Category | Total | Brought Forward | Carried Forward
 | 1.4 | 2012-07-04 00:00:00 | Forum | Vodka | 15 |  | Forum
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Rep Training
 |  |  |  |  |  |  | Expenses
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Website
 |  |  |  |  |  |  | Joint Events
 |  |  |  | Total for Quarter
 |  |  |  | Brought forward from Apr - June
 |  |  |  | Carried Forward to Oct - Dec
Spreadsheet: 851704d1701871743-delivery-eta-times-help-cond-frmt-4hrs-etaf
Sheet: Sheet1

ETA | Actual
08:00:00 | 05:45:00
09:00:00 | 11:17:00
10:00:00 | 11:00:00
10:00:00 | 09:00:00
Spreadsheet: c41217e0-b3b4-423d-8b66-f2997e0feb7c
Sheet: Sheet1

 | BUCS Squash 2010/11
 | Home Team | Men's Results Card |  |  |  |  |  |  |  |  |  |  |  | Away Team
 | University of Hertfordshire 1st | Match Date: |  |  | 20.10.2010 |  |  |  |  |  |  |  |  | University of Portsmouth 1st
 |  | Games | Individual Game Scores |  |  |  |  |  |  |  |  |  | Games
 |  |  | H | A | H | A | H | A | H | A | H | A
 | 1) [NAME] |  | 11 | 8 | 11 | 0 | 11 | 5 |  |  |  |  |  | 1) [NAME]
 | 2) Brent Galloway |  | 11 | 9 | 9 | 11 | 6 | 11 | 11 | 6 | 9 | 11 |  | 2) [NAME]
 | 3) [NAME] |  | 11 | 9 | 10 | 12 | 9 | 11 | 12 | 10 | 8 | 11 |  | 3) [NAME] Man
 | 4) [NAME] |  | 7 | 11 | 11 | 5 | 12 | 10 | 11 | 4 |  |  |  | 4) [NAME]
 | 5) [NAME] |  | 11 | 6 | 11 | 5 | 11 | 7 |  |  |  |  |  | 5) [NAME]
 | MATCH RESULT
 |  |  |  |  |  |  | -
 |  |  |  |  | GAMES
 |  |  |  |  |  |  | -
 |  |  |  |  |  | POINTS
 |  |  |  |  |  |  | -
THIS RESULTS CARD MUST BE EMAILED TO [EMAIL] WITHIN 5 WORKING DAYS OF THE MATCH
 | MATCH RESULT |  | H | A
 | Match 1
 | Match 2
 | Match 3
 | Match 4
 | Match 5
 | GAMES
 |  | Game | 1 | 2 | 3 | 4 | 5 | Total Games
 | Match 1
 | H
 | A
 | Match 2
 | H
 | A
 | Match 3
 | H
 | A
 | Match 4
 | H
 | A
 | Match 5
 | H
 | A
Spreadsheet: 288948d1389357571-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location-excelforumsupersort-2014-01-10-07-34
Sheet: Possible Solution

 |  |  |  |  |  |  |  | Super Sort |  | Super Sort
 |  |  |  |  |  |  |  | Leading | Modified | Trailing
 |  |  | Production ID | ProjectID | Start | Super Sort |  | Code | Super Sort | Code
 |  |  |  | 4 | 12 | 12 |  | N | 12 | N
 |  |  |  | 2 | 14 | 14 |  | N | 14 | N
 |  |  |  | 7 | 16 | 16 |  | N | 16 | N
 |  |  |  | 15 | 23 | 23 |  | N | 23 | N
 |  |  | 5 | 1 | 88 | 88 |  | N | 88 | A1
 |  |  |  | 5 | 88 | 88.1 |  | N | 88 | A2
 |  |  |  | 8 | 88 | 88 |  | N | 88 | N
 |  |  |  | 12 | 88 | 88 |  | N | 88 | N
 |  |  | 14 | 9 | 91 | 91 |  | N | 91 | A1
 |  |  |  | 14 | 1 | 91.1 |  | N | 91 | A2
 |  |  |  | 10 | 115 | 115 |  | N | 115 | N
 |  |  |  | 11 | 123 | 123 |  | N | 123 | N
 |  |  |  | 13 | 236 | 236 |  | N | 236 | N
 |  |  |  | 6 | 458 | 458 |  | N | 458 | N
 |  |  |  | 3 | 498 | 498 |  | N | 498 | N
 |  |  | But when there are other projects with non unique start times (column F) it does not put them in the right spot.  And it won't because 88.1 will never be smaller than  88.  So is there another way I can use a formula to trick sort to get the row of data in column E that is represented by ID 5 to appear emmediatly under ID 1?
 |  |  | Reference: | http://www.excelforum.com/excel-general/980290-sorting-question-trying-to-force-a-row-of-data-to-apper-in-the-wrong-sort-location.html
Spreadsheet: 71720d1272464095-consolidated-printing-print
Sheet: Sheet2

8 |  | Roopa TV |  | 5910 | 709.2 | 216.897 | 492.303
9 |  | [NAME] |  | 5910 | 709.2 | 216.897 | 492.303
10 |  | Sathyavathi L M |  | 2744 | 329.27 | 100.6948 | 228.5752
11 |  | Shadab [NAME] |  | 5910 | 709.2 | 216.897 | 492.303
12 |  | Shraddha V Bhujang |  | 2744 | 329.27 | 100.6948 | 228.5752
13 |  | [NAME] R Rao |  | 2744 | 329.27 | 100.6948 | 228.5752
Spreadsheet: louise_kitchen__22842__Hot List Update 06-18-01
Sheet: E-Commerce -50

Deal Description Sheet - 6/18/01
[NAME]
Project Name | Counterparty | Description | Potential Valuation | Last Customer Contact | Probability | Expected Closing (Month/Year) | Weekly Updates / Comments
Andex | Andex | Outsourcing- scheduling, balancing, settlement, deal confirmations and measurement & accounting. | 50000 | 2001-05-22 00:00:00 | 0.2 | 2001-06-01 00:00:00 | ATS will close in June 2001.  ENA will close in June 2001.
[NAME] | EOTT | Back office accounting services. | *$500,000 | 2001-05-14 00:00:00 | 0.25 | 2001-10-01 00:00:00 | EOTT meeting set up for mid June, 2001 with HMS.
[NAME] | Pure Resources | Integrated outsourcing products. | *$250,000 | 2001-06-11 00:00:00 | 0.25 | 2001-12-01 00:00:00 | ENA to follow up in June
Gather Company | Gather Company | Monetization and metering services. | 200000 | 2001-05-10 00:00:00 | 0.25 | 2001-12-01 00:00:00 | Follow up meeting in June, 2001.
Running Man | Marathon | Integrated outsourcing products. | *$1,000,000 | 2001-06-11 00:00:00 | 0.1 | 2001-12-01 00:00:00 | Meeting in late June.
Callon | Callon | Outsourcing | 100000 | 2001-06-19 00:00:00 | 0.1 | 2001-10-01 00:00:00
 |  |  |  |  |  |  | *Accrual
Spreadsheet: 196033d1353797368-subtotal-value-invisible-when-filter-data-subtotal-problem
Sheet: sample

******* |  |  |  |  | ****** |  |  |  |  |  |  |  |  |  | DATE :
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-22 00:00:00
CUSTOMER NAME | ID | PO | SALE | Beginning | Payment Receive Today |  |  |  | Delivery Today |  |  |  |  |  |  | Ending
 |  |  |  |  | Receipt | Date | Plant | TOTAL | NO | QTY | MUTU | Plant | TOT | PRICE | Amount
 |  |  |  |  |  |  |  |  |  |  |  |  | VOL | Inc. PPN
 |  |  |  | 690000 |  |  |  |  |  |  |  |  |  |  |  | 690000
 |  |  |  | -5000000 |  |  |  |  |  |  |  |  |  |  |  | -5000000
 |  |  |  | 5040000 |  |  |  |  |  |  |  |  |  |  |  | 5040000
 |  |  |  | 37250000 |  |  |  |  | 670633 | 26 |  | CKM | 26 | 745000 | 19370000 | 17880000 | Print
 |  |  |  |  | 211516 | 2012-11-22 00:00:00 | CKM | 50000000 |  |  |  |  |  |  |  | 50000000 | Print
 |  |  |  | 904350 |  |  |  |  |  |  |  |  |  |  |  | 904350
 |  |  |  | 2830400 |  |  |  |  |  |  |  |  |  |  |  | 2830400
 |  |  |  | 400000 |  |  |  |  |  |  |  |  |  |  |  | 400000
 |  |  |  | 16605000 |  |  |  |  |  |  |  |  |  |  |  | 16605000
 |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  | 111090000 |  |  |  |  | 670632 | 28 |  | CKM | 28 | 690000 | 19320000 | 91770000 | Print
 |  |  |  | 630000 |  |  |  |  |  |  |  |  |  |  |  | 630000
 |  |  |  | 3570000 |  |  |  |  |  |  |  |  |  |  |  | 3570000
 |  |  |  | 288000 |  |  |  |  |  |  |  |  |  |  |  | 288000
 |  |  |  | 1920000 |  |  |  |  |  |  |  |  |  |  |  | 1920000
 |  |  |  | 600000000 |  |  |  |  | 670614 | 100 |  | CKM | 70 | 780000 | 54600000 | 545400000 | Print
 |  |  |  | 330000 |  |  |  |  |  |  |  |  |  |  |  | 330000
 |  |  |  | 332500 |  |  |  |  |  |  |  |  |  |  |  | 332500
 |  |  |  | 11110000 |  |  |  |  |  |  |  |  |  |  |  | 11110000
 |  |  |  | 4422000 |  |  |  |  | 670631 | 6 |  | CKM | 6 | 670000 | 4020000 | 402000 | Print
 |  |  |  | 54600 |  |  |  |  |  |  |  |  |  |  |  | 54600
 |  |  |  | 42500 |  |  |  |  |  |  |  |  |  |  |  | 42500
 |  |  |  | 3355000 |  |  |  |  |  |  |  |  |  |  |  | 3355000
 |  |  |  | 5000 |  |  |  |  |  |  |  |  |  |  |  | 5000
 |  |  |  |  | 211515 | 2012-11-22 00:00:00 | CKM | 8250000 | 670606 | 11 |  | CKM | 11 | 750000 | 8250000 | 0 | Print
 |  |  |  | 90000000 |  |  |  |  |  |  |  |  |  |  |  | 90000000
 |  |  |  | 820300 |  |  |  |  |  |  |  |  |  |  |  | 820300
 |  |  |  | 68000 |  |  |  |  |  |  |  |  |  |  |  | 68000
 |  |  |  | 85000 |  |  |  |  |  |  |  |  |  |  |  | 85000
 |  |  |  | 56250000 |  |  |  |  |  |  |  |  |  |  |  | 56250000
 |  |  |  | 60000 |  |  |  |  |  |  |  |  |  |  |  | 60000
 |  |  |  | 943152650 |  |  |  | 58250000 |  |  |  |  | 141 |  | 105560000 | 895842650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 895842650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 145377d1331561658-help-choosing-minimum-price-if-in-stock-excelhelp
Sheet: master sheet

Master sheet | Projector | stock ? | cheapest supplier | cheapest supplier price
Spreadsheet: 883601d1732222824-making-an-automatic-on-call-board-recreation-of-the-on-call-board-automatic-2025
Sheet: December

 | December
 |  | 1 | 2 | 3 | 4 | 5 | 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
 | [NAME]
 | [NAME]
 | Romo
 | [NAME]
 | Orlando
 | Nick
 | [NAME]
 | Zach
 | Pando
 | [NAME]
 | Art
 | Manuel
 | [NAME]
Spreadsheet: 871102d1717533672-would-like-to-add-automatic-date-and-day-yearly-xda-sickness-file
Sheet: AUGUST

 | DATE | DAY | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE
 |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours
 | DATE | DAY | STAFF NAME | PAY | TOIL
 |  |  | TOTALS
Spreadsheet: tracy_geaccone__40327__Q3 2001 Accounting Adjustments
Sheet: PGH-PVC

 |  |  | (prepared 9/18/01)
Portland General Group (PGH&PVC)
Q3 2001- Significant Accounting Adjustments
The following accounting adjustments and/or rate case implementation issues are included
in our latest (Third) Current Estimate of results for Q3 2001.  We will need AA&Co. to concur
with our proposed treatment of each of these in our to reach our Q3 earnings forecast.
The items noted under PGH and PVC will need the support of Enron Corp Houston since
AA&Co. Portland will likely pass along their opinion on these items to [NAME] for
any final call as to their appropriateness.
Portland General Holdings (PGH) | IBIT | Net Income | Footnote
Severance Reserve Reversal | 2.7 |  | (1)
Litigation Reserve Reversal | 2 |  | (2)
Total PGH
(1)  This reserve was established in Purchase Accounting at the time Enron purchased PGE.
We've reduced it over time based on actual severance payouts.  At this point, no employees
remain at PGH, so there is no need for the reserve. This has not been discussed yet with AA&Co.
(2)  This reserve was established in Purchase Accounting representing an estimate of
future legal costs to be incurred related to litigation existing at the time of the merger.  Since
the Enron purchase, we reduced the reserve by actual amounts incurred to address cases that
existed at the merger date.  At this point, we don't believe any material costs will be incurred
in the future related to cases that existed at the merger date, so the remaining reserve should
be reversed.  This has not yet been discussed with AA&Co. Portland.
Portland Valuation Company (PVC) | IBIT | Net Income | Footnote
Merger MOU Reserve Reversal | 5.7 |  | (3)
Severance Reserve Reversal | 3.5 |  | (4)
[NAME] to ENA ($750m) | 5.2 | 5.2 | (5)
Total PVC
(3) As part of the Enron merger with PGE, we agreed to spend about $12m for a number of
enviromental causes.  This amount was accrued in purchase accounting, and we've charged
actual expenditures against this reserve to-date.  The remaining obligation at 8/31/01 is $5.7m.
In our rate case (which goes into effect 10/1/01) PGE was able to get revenues from customers
to cover this obligation going forward, so there is no longer a need for the reserve on PVC's
books, accordingly the reserve can be reversed.  Note this issues has been discussed with
AA&Co. Portland and they're currently considering this proposed accounting for Q3.
(4)  This reserve was established in Purchase Accounting at the time Enron purchased PGE.
We've reduced it over time based on actual severance payouts to PGE employees.  At this time
there is no specific severance program in place for any PGE employees, so there is no need/support.
for maintaining this reserve.  This has not been discussed with AA&Co Portland.
(5) This assumes a transfer of $750m of Goodwill from PVC to ENA effective 7/1/01.  If this
transfer is delayed or for some reason not made, both Q3 & Q4 2001 for PGG will be impacted
negatively. This has not been discussed with AA&Co. Portland yet.
NOTE:  See next tab for PGE accounting changes/rate case implementation issues.
Spreadsheet: 215559d1361408272-calculate-lost-minutes-between-redundant-login-and-logout-records-for-each-id-lost-minutes
Sheet: IN-OUT

ID | Login | Logout |  | Converted times |  |  | Value differences
1 | 2:10AM | 4:39AM
1 | 4:39AM | 7:03AM
1 | 7:05AM | [NAME]
2 | 8:02AM | 10:00AM
2 | 10:05AM | 12:30PM
2 | 12:34PM | 2:05PM
2 | 2:15PM | 4:00PM
Spreadsheet: 120397d1315256319-function-to-place-text-in-column-row-intersection-to-excel-forum
Sheet: Sheet1

A TODAY() funtion changes the date |  |  |  | This would be an index of hams
each day.
2011-08-26 00:00:00
Checkins:  4 |  |  |  | Call | Name | Co. |  |  | This would be the sheet of dates and number of times they check in.
Call | Name | Co. |  | 1 | 2 | 3
AA3GB | Gene | H |  | W9ILU | [NAME] | C |  |  |  | 2011-08-26 00:00:00 | 2011-08-27 00:00:00 | 2011-08-28 00:00:00 | 2011-08-29 00:00:00 | 2011-08-30 00:00:00 | # checkin
K2JMU | [NAME] | C |  | AA3GB | Gene | H |  |  | W9ILU | X | X |  |  |  | 2
AF4UM | [NAME] | C |  | AC2N | [NAME] | L |  |  | AA3GB | X |  |  |  |  | 1
K4LL | [NAME] | C |  | [NAME] | [NAME] | C |  |  | AC2N |  | X |  |  |  | 1
 |  |  |  | AD6WV | [NAME] | C |  |  | [NAME] | X | X |  |  |  | 2
 |  |  |  | AF4UM | [NAME] | C |  |  | AD6WV | X | X |  |  |  | 2
 |  |  |  | [NAME] | [NAME] | C |  |  | AF4UM | X |  |  |  |  | 1
 |  |  |  | AG4KS | [NAME] | H |  |  | [NAME] |  | X |  |  |  | 1
 |  |  |  | AL7HG | [NAME] | C |  |  | AG4KS | X | X |  |  |  | 2
 |  |  |  | [NAME] | Rich | C |  |  | AL7HG | X | X |  |  |  | 2
 |  |  |  | K0RCT | [NAME] | C |  |  | [NAME] |  |  |  |  |  | 0
 |  |  |  | K1CBX | Rollan | C |  |  | K0RCT | X | X |  |  |  | 2
 |  |  |  | K2IQG | [NAME] | C |  |  | K1CBX |  |  |  |  |  | 0
 |  |  |  | K2JIM | [NAME] | C |  |  | K2IQG | X | X |  |  |  | 2
 |  |  |  | K2JMU | [NAME] | C |  |  | K2JIM |  |  |  |  |  | 0
 |  |  |  | K2MQQ | [NAME] | H |  |  | K2JMU | X | X |  |  |  | 2
 |  |  |  | K3jMT | [NAME] | C |  |  | K2MQQ |  | X |  |  |  | 1
 |  |  |  | K4AQW | [NAME] | C |  |  | K3jMT | X |  |  |  |  | 1
 |  |  |  | K4CFC | Wilson | C |  |  | K4AQW | X | X |  |  |  | 2
 |  |  |  | K4CLH | [NAME] | C |  |  | K4CFC |  |  |  |  |  | 0
 |  |  |  | K4GGK | George | C |  |  | K4CLH |  |  |  |  |  | 0
 |  |  |  | K4JNP | [NAME] | C |  |  | K4GGK |  |  |  |  |  | 0
 |  |  |  | K4JNT | [NAME] | C |  |  | K4JNP |  |  |  |  |  | 0
 |  |  |  | K4KKX | [NAME] | A |  |  | K4JNT |  |  |  |  |  | 0
 |  |  |  | K4LL | [NAME] | C |  |  | K4KKX |  |  |  |  |  | 0
 |  |  |  | [NAME] | Moe | C |  |  | K4LL |  | X |  |  |  | 1
 |  |  |  | K4NSZ | [NAME] | C |  |  | [NAME] |  |  |  |  |  | 0
 |  |  |  | K4PJA | Pam | H |  |  | K4NSZ |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | K4PJA |  |  |  |  |  | 0
Spreadsheet: 119827d1314782356-making-excell-count-in-4s-example
Sheet: FT1

 | 1 | 10
 | 2 | 20
 | 3 | 30
 | 4 | 40
 | 5 | 50
 | 6 | 60
 | 7 | 70
 | 8 | 80
 | 9 | 90
 | 10 | 100
 | 11 | 110
 | 12 | 120
 | 13 | 130
 | 14 | 140
 | 15 | 150
 | 16 | 160
 | 17 | 170
 | 18 | 180
 | 19 | 190
 | 20 | 200
 | 21 | 210
 | 22 | 220
 | 23 | 230
 | 24 | 240
 | 25 | 250
 | 26 | 260
 | 27 | 270
 | 28 | 280
 | 29 | 290
 | 30 | 300
 | 31 | 310
 | 32 | 320
 | 33 | 330
 | 34 | 340
 | 35 | 350
 | 36 | 360
 | 37 | 370
 | 38 | 380
 | 39 | 390
 | 40 | 400
Spreadsheet: 288586d1389242597-team-list-drop-down-team-list-test2
Sheet: Report

 | Team Name: | Director | <- Data Validation list of Cells B1 through AA1 on Sheet 2
 | Agent 1
 | Agent 2
 | Agent 3
 | Agent 4
 | Agent 5
 | Agent 6
 | Agent 7
 | Agent 8 |  | <- List auto fills from Column based on team selected above
 | Agent 9
 | Agent 10
 | Agent 11
 | Agent 12
 | Agent 13
 | Agent 14
 | Agent 15
 | Agent 16
 | Agent 17
 | Agent 18
 | Agent 19
 | Agent 20
Spreadsheet: 59229d1259720753-drop-down-menus-studio-session-record-with-time-page
Sheet: Item Form

 |  |  |  |  | Studio Session Record
 |  |  |  |  | Session Record No:
 |  | Client: |  |  | Date:
 |  |  |  |  | P.O. No:
 |  |  |  |  | Personnel:
 |  |  | Identification:
 |  | ProTools: | 7.4
 |  | kHz: | 44.1
 |  | Bit-Rate: | 24
 |  | Qty. | Code | Description |  | Disc. | Unit Cost | Extended Price
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  | 0.05 | 35 | 33.25
 |  | 1 | M222 | HOUR(s) KEYLINE/PASTE UP |  |  | 40 | 40
 |  | 1 | S307 | DAT AUDIO MASTER(S) |  |  | 30 | 30
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  | 100 | 100
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  |  | 35 | 35
 |  | 1 | M270 | DINING GUIDE WEEK OF |  |  | 1580 | 1580
 |  | 30 | M206 | FIRST SPOT |  |  | 625 | 18750
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  | 100 | 100
 |  | 1 | M208 | ADDITIONAL SPOT LINERS |  |  | 35 | 35
 |  | 1 | M206 | FIRST SPOT |  |  | 625 | 625
 |  | 1 | M207 | ADDITIONAL SPOTS |  |  | 475 | 475
 |  | 1 | M210 | HOUR(S) CLIENT CONSULTATI |  |  | 100 | 100
 |  | 2 | M207 | ADDITIONAL SPOTS |  |  | 475 | 950
 |  |  |  |  |  |  | Total: | 22853.25
 |  | Authorized By:
 |  | All properties left on our premises are stored at owner's risk.
Spreadsheet: 845191d1696708438-transferring-and-formatting-one-column-data-into-a-table-eftrips
Sheet: Sheet1

7Saturday, May 7. 2 trips. |  | Date | Status | To | Time
Trip 1 of 2. Performed trip. |  | 2022-05-07 00:00:00 | Performed trip | WALMART SUPERCENTER:555, FREE RD | 15:00:00
Dropoff address.WALMART SUPERCENTER, 555 FREE RD , SOMEWHERE, CA, 99999. |  | 2022-05-07 00:00:00 | Performed trip | 12345, MY ST | 18:00:00
Pickup time3:00 PM
Trip 2 of 2. Performed trip.
Dropoff address.(HOME) 1 - 12345 MY ST , ANYPLACE, CA, 99998.
Pickup time6:00 PM
"To" Format
":" AND NO SPACE
"." AFTER BUILDING #
STATE & ZIPCODE REMOVED
Spreadsheet: 763333d1642105511-search-for-a-text-string-to-return-a-value-for-further-calculation-searchstring_returnvalue-for-calculation-1-
Sheet: Sheet1

Material Type | Price per g
PLA | 10
NIN | 20
NINARM | 30
Product | Product Description | Weight in g | Cost
Mount | NINARM_lightMount | 10
Mount | PLA_lightmount | 20
Mount | NIN_lightmount | 30