tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 800217d1665546968-need-formula-to-calculate-pl-and-l-and-mon-and-friday-time_table
Sheet: Sheet1

Name | 2022-10-01 00:00:00 | 2022-10-02 00:00:00 | 2022-10-03 00:00:00 | 2022-10-04 00:00:00 | 2022-10-05 00:00:00 | 2022-10-06 00:00:00 | 2022-10-07 00:00:00 | 2022-10-08 00:00:00 | 2022-10-09 00:00:00 | 2022-10-10 00:00:00 | 2022-10-11 00:00:00 | 2022-10-12 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-15 00:00:00 | 2022-10-16 00:00:00 | 2022-10-17 00:00:00 | 2022-10-18 00:00:00 | 2022-10-19 00:00:00 | 2022-10-20 00:00:00 | 2022-10-21 00:00:00 | 2022-10-22 00:00:00 | 2022-10-23 00:00:00 | 2022-10-24 00:00:00 | 2022-10-25 00:00:00 | 2022-10-26 00:00:00 | 2022-10-27 00:00:00 | 2022-10-28 00:00:00 | 2022-10-29 00:00:00 | 2022-10-30 00:00:00
[NAME] | H | H | PL | P | P | L | P | H | H | PL | P | P | P | P | H | H | L | P | P | P | P | H | H | PL | P | P | L | P | H | H
[NAME] | H | H | P | P | P | P | PL | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H
Ferguson | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H | P | P | P | P | L | H | H | P | P | P | L | P | H | H
Holden | H | H | P | P | P | P | L | H | H | P | P | P | L | P | H | H | P | P | P | P | L | H | H | P | P | P | P | L | H | H
Bull | H | H | L | P | P | P | PL | H | H | PL | P | P | P | P | H | H | P | P | P | P | P | H | H | L | L | L | L | L | H | H
[NAME] | H | H | P | P | P | P | P | H | H | PL | P | P | P | P | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H
[NAME] | H | H | P | P | P | P | L | H | H | PL | P | P | P | P | H | H | PL | P | P | P | P | H | H | P | P | P | P | L | H | H
Hutchinson | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H | P | P | P | P | P | H | H
 |  | IF EITHER MONDAY OR FRIDAY CONTAINS PL OR L FOR CONTINUE 2 WEEKS NEED TO COUNT OTHER WISE LEAVE IT
 |  | EXPECTED RESULT
 | FIRST 2 WEEK |  |  |  | LAST 2 WEEK
 | W-1 | W-2 | TOTAL |  | W-3 | W-4 | TOTAL
[NAME] | 1 | 1 | 2 |  | 1 | 1 | 2
[NAME] | 1 |  | 1
Ferguson | 1 |  | 1 |  | 1 |  | 1
Holden | 1 |  | 1 |  | 1 | 1 | 2
Bull | 2 | 1 | 3
[NAME] |  | 1 | 1 |  | 1 | 1 | 2
[NAME] | 1 | 1 | 2
Hutchinson
Spreadsheet: 124157d1318198064-adding-totals-from-selected-colums-on-diffrent-sheets-films
Sheet: Sheet1

You total selection is :
 | TB
 | GB
List of Films
Sheet2 | Sheet3
Spreadsheet: 50871d1250437486-convert-non-military-time-to-tenths-of-hours-wtr-excel-forum
Sheet: For Me Step 2

DAY OF WEEK |  |  |  |  |  | Regular Hours Worked | Conversion From Time to Hours |  | HOURS CONVERSION CHART
From Sun 12:01 AM to Sat 12:00 midnight | Hour IN | Hour IN | MEAL | Hour IN | Hour IN |  |  |  | FROM | TO | REPORTING INCREMENTS
 | Hour OUT | Hour OUT | BREAK | Hour OUT | Hour OUT |  |  |  | 0 MIN | 2 MIN, 59 SEC | 0
2009-08-02 00:00:00 | 08:03:00 |  | MEAL | 13:00:00 | 15:30:00 | 6.949999999999999 | 6.9 |  | 3 MIN | 8 MIN, 59 SEC | 0.1
SUN | 12:00:00 |  | BREAK | 14:30:00 | 17:00:00 |  |  |  | 9 MIN | 14 MIN, 59 SEC | 0.2
2009-08-03 00:00:00 | 08:21:00 | 11:30:00 | MEAL |  | 13:00:00 | 6.650000000000002 | 6.4 |  | 15 MIN | 20 MIN, 59 SEC | 0.3
MON | 10:30:00 | 12:00:00 | BREAK |  | 17:00:00 |  |  |  | 21 MIN | 26 MIN, 59 SEC | 0.4
2009-08-04 00:00:00 | 21:30:00 |  | MEAL |  | 1900-01-01 00:00:00 | 9.5 |  |  | 27 MIN | 32 MIN, 59 SEC | 0.5
TUE | 23:00:00 |  | BREAK |  | 08:00:00 |  |  |  | 33 MIN | 38 MIN, 59 SEC | 0.6
2009-08-05 00:00:00 |  |  | MEAL |  | 12:00:00 | 5.000000000000001 |  |  | 39 MIN | 44 MIN, 59 SEC | 0.7
WED |  |  | BREAK |  | 17:00:00 |  |  |  | 45 MIN | 50 MIN, 59 SEC | 0.8
2009-08-06 00:00:00 | 08:00:00 |  | MEAL |  |  | 3 |  |  | 51 MIN | 56 MIN, 59 SEC | 0.9
THU | 11:00:00 |  | BREAK |  |  |  |  |  | 57 MIN | 60 MIN | 1
2009-08-07 00:00:00 | 21:30:00 |  | MEAL |  | 23:30:00 | 10
FRI | 23:00:00 |  | BREAK |  | 08:00:00
2009-08-08 00:00:00 | 08:00:00 |  |  |  | 13:00:00 | 8.000000000000002
SAT | 12:00:00 |  |  |  | 17:00:00
 |  |  |  |  |  | TOTALS | 13.3
Spreadsheet: 135978d1326350580-if-statement-new-to-excel-and-this-forum-sample-ifstatement
Sheet: Before

2012-01-16 00:00:00
Name | Present | Month
[NAME] | Yes | 2012-01-16 00:00:00 |  | IF(B7="Yes",$A$4,"") | <-----look at  $A$4 - this will vary depending on the address of the date or the position...
[NAME] | Yes | 2012-01-16 00:00:00
[NAME] | No
2012-01-17 00:00:00
Name | Present | Month
[NAME] | Yes | 2012-01-17 00:00:00 |  | IF(B14="Yes",$A$11,"") | <---also here
2012-01-18 00:00:00
Name | Present | Month
[NAME] | No |  |  | IF(B19="Yes",$A$16,"") | <---also here
[NAME] | Yes | 2012-01-18 00:00:00
 |  | This column formated as dates
Spreadsheet: 825876d1681605847-sumif-accumulative-and-by-month-book2
Sheet: Report 

 | 2021-08-31 00:00:00
Car
Computer
Table
TV
 | * Date will change with Stroll Bar
 | * Column B to show accumulated balance
 | * For example, to show accumulated for each type, till 31/08/2021 (Sum of Column B to Column U in raw data tab)
 | *For the yellow part, to show the the sum base on Raw Data tab. (For example Column C = sumif Column V in Raw Data Tab etc etc)
21
Spreadsheet: 711315d1609608566-finding-clashes-in-a-table-sixth-form-options-aligw
Sheet: Option Choices 2020

Option Choices 2020
Name | Option 1 | Option 2 | Option 3 | Option 4 | Option 5 |  | Group A | Group B | Group C | Group D | Group E |  | Opt Wrong | Opt Rept |  |  | Choices | A | B | C | D | E | Total | Groups | Blocks
Pupil 1 | Ma | Ph | Ch |  |  |  |  |  | Ch | Ma | Ph |  |  |  |  |  | Ar
Pupil 2 | Ma | Bi | Ch | Fr |  |  | Bi | Fr | Ch | Ma |  |  |  |  |  |  | BS |  |  |  |  |  |  |  | B
Pupil 3 | RS | EngLa | Hi |  |  |  | Hi |  |  | EngLa | RS |  |  |  |  |  | Bi |  |  |  |  |  |  |  | A
Pupil 4 | BS | Ec | Ma |  |  |  | Ec | BS |  | Ma |  |  |  |  |  |  | CP |  |  |  |  |  |  |  | C
Pupil 5 | Bi | Ch | Ma | Ph |  |  | Bi |  | Ch | Ma | Ph |  |  |  |  |  | Ch |  |  |  |  |  |  |  | C
Pupil 6 | FM | Ma | Ph | Ch |  |  | FM |  | Ch | Ma | Ph |  |  |  |  |  | DT |  |  |  |  |  |  |  | C
Pupil 7 | Ge | PE | EngLa |  |  |  |  | Ge | PE | EngLa |  |  |  |  |  |  | Dr |  |  |  |  |  |  |  | D
Pupil 8 | Ec | BS | DT |  |  |  | Ec | BS | DT |  |  |  |  |  |  |  | Ec |  |  |  |  |  |  |  | A
Pupil 9 | BS | FS | Ma |  |  |  |  | BS |  | Ma | FS |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  | B
Pupil 10 | Ge | RS | EngLa |  |  |  |  | Ge |  | EngLa | RS |  |  |  |  |  | EngLa |  |  |  |  |  |  |  | D
Pupil 11 | RS | EngLa | Hi |  |  |  | Hi |  |  | EngLa | RS |  |  |  |  |  | FM |  |  |  |  |  |  |  | A
Pupil 12 | Bi | BS |  |  |  |  | Bi | BS |  |  |  |  |  |  |  |  | FS |  |  |  |  |  |  |  | E
Pupil 13 | CP | Ge | FM | Ma | Ph |  | FM | Ge | CP | Ma | Ph |  |  |  |  |  | Fr |  |  |  |  |  |  |  | B
Pupil 14 | Ch | Fr | Bi |  |  |  | Bi | Fr | Ch |  |  |  |  |  |  |  | Ge |  |  |  |  |  |  |  | B
Pupil 15 | Ph | Ch | Ma |  |  |  |  |  | Ch | Ma | Ph |  |  |  |  |  | Hi |  |  |  |  |  |  |  | A
Pupil 16 | Fr | Hi | RS |  |  |  | Hi | Fr |  |  | RS |  |  |  |  |  | Ma |  |  |  |  |  |  |  | D
Pupil 17 | Ch | Ma | Ph | Bi |  |  | Bi |  | Ch | Ma | Ph |  |  |  |  |  | Mu
Pupil 18 | Ma | Sp | Bi | Ch |  |  | Bi |  | Ch | Ma | Sp |  |  |  |  |  | PE |  |  |  |  |  |  |  | C
Pupil 19 | FS | Ma | CP |  |  |  |  |  | CP | Ma | FS |  |  |  |  |  | Ph |  |  |  |  |  |  |  | E
Pupil 20 | RS | BS | Hi |  |  |  | Hi | BS |  |  | RS |  |  |  |  |  | RS |  |  |  |  |  |  |  | E
Pupil 21 | Ph | Ch | Ec | Ma |  |  | Ec |  | Ch | Ma | Ph |  |  |  |  |  | Sp |  |  |  |  |  |  |  | E
Pupil 22 | Hi | Ma | RS |  |  |  | Hi |  |  | Ma | RS |  |  |  |  |  | TOTALS
Pupil 23 | [NAME] | Hi | Ch |  |  |  | Hi | [NAME] | Ch
Pupil 24 | PE | Bi | Ma |  |  |  | Bi |  | PE | Ma
Pupil 25 | Fr | Ma | CP | Ec |  |  | Ec | Fr | CP | Ma
Pupil 26 | Ph | Bi | Ch | Ma |  |  | Bi |  | Ch | Ma | Ph
Pupil 27 | Bi | BS | Ma | RS |  |  | Bi | BS |  | Ma | RS
Pupil 28 | Ch | Dr | Ph | Bi |  |  | Bi |  | Ch | Dr | Ph
Pupil 29 | Ma | Ph | Bi | Ch |  |  | Bi |  | Ch | Ma | Ph
Pupil 30 | BS | DT | FS |  |  |  |  | BS | DT |  | FS
Pupil 31 | Ch | Ma | Ph | Bi |  |  | Bi |  | Ch | Ma | Ph
Pupil 32 | [NAME] | Ph | Bi | Ch |  |  | Bi | [NAME] | Ch |  | Ph
Spreadsheet: 797626d1664013872-consecutive-numbering-spill-formula-cumulative-sum-formula-export-9
Sheet: DATA

catdholder | BILLABLE_ENTITY_AMOUNT | [NAME]
qcviq ucut | 5553.9 | 724259
coii tczct | 2466.47 | 798949
coii tczct | 2113.966 | 798949
coii tczct | 211.44 | 798959
coii tczct | 7555.114 | 798959
[NAME] | 1166.99 | 724259
[NAME] | 44.5557 | 724259
coii tczct | 73.0011 | 798959
coii tczct | 1111.11555 | 798959
coii tczct | 24.266 | 798959
coii tczct | 233.311 | 798959
cuvcl tcsciccc | 5553.3555 | 798959
cuvcl tcsciccc | 800.77 | 798959
cuvcl tcsciccc | 11112.98 | 798959
cuvcl tcsciccc | 37.366 | 798959
coii tczct | 355500.411 | 798949
qot tcpti | 11009.47 | 798949
qot tcpti | 11700 | 798949
coii tczct | 1111.766 | 798959
coii tczct | 400.113 | 798959
qot tcpti | 110011.866 | 798949
cuvcl tcsciccc | 5553.22 | 798959
ctit cztci | 342.73 | 722999.97
cuvcl tcsciccc | 113.99 | 798959
coii tczct | 11866.118 | 798949
cuvcl tcsciccc | 223.007 | 798959
pilcq cutccct | 55539 | 798972
ticcctl cttoucs | 669 | 798949
qot tcpti | 1149.92 | 798929
qot tcpti | 11002.966 | 798949
cuvcl tcsciccc | 44.366 | 798959
cuvcl tcsciccc | 47.55511 | 798959
cuvcl tcsciccc | 74.6611 | 798959
coqccc [NAME] qcioi | 5559.555 | 798972
coqccc [NAME] qcioi | 224.555 | 798972
qot tcpti | 117 | 798959
qot tcpti | 700 | 798959
ioct ctcq | 66555.49 | 798959
qot tcpti | 1128 | 798949
ioct ctcq | 11800.002 | 798959
cuvcl tcsciccc | 11112.8 | 798959
ioct ctcq | 117.211 | 798959
coii tczct | 1149 | 798929
coii tczct | 1149.555 | 798949
qcic tisitt | 117800 | 798972
ctit cztci | 45552.8 | 798972
[NAME] [NAME] | 866.9 | 798949
cuvcl tcsciccc | 6666.669 | 798959
ioct ctcq | 1127.55566 | 798959
cuvcl tcsciccc | 222.55566 | 798959
cvi Sccpitc | 400 | 724279
Ipot pov | 711 | 724279
ioct ctcq | 11002.24 | 798959
qcviq ucut | 110000 | 798949
ioct ctcq | 97.966 | 798959
coqccc [NAME] qcioi | 47.8 | 724279
cuvcl tcsciccc | 466.97 | 798959
cuvcl tcsciccc | 98.366 | 798959
cuvcl tcsciccc | 2555.667 | 798959
cuvcl tcsciccc | 1111555.38 | 798959
Ipot pov | 400 | 724279
toticc czulcc | 883 | 798972
ioct ctcq | 113.119 | 798959
toi Zitoi | 110066.2 | 798949
scit.licctip . | 400 | 798949
tot ciztiuttp | 110000 | 798949
[NAME] | 400.4 | 798949
ioct ctcq | 11266.8555 | 798959
toi Zitoi | 74.7 | 798949
ioct ctcq | 1129.5558 | 798949
Scpi-tosct tctoi | 972 | 797289.92
cuvcl tcsciccc | 283.4 | 798959
cloi Oftk | 55500 | 724279
ioct ctcq | 800.911 | 798959
cuvcl tcsciccc | 1187.5552 | 798949
cuvcl tcsciccc | 329.711 | 798949
cuvcl tcsciccc | 11669 | 798929
ioct ctcq | 273.73 | 798949
[NAME] | 11118 | 798949
Spreadsheet: 708542d1607925432-looking-formula-from-other-sheet-and-specific-column-sample-check
Sheet: COM

 |  |  |  |  |  |  | Result should be (example)
NO | [NAME] | RO | SEGMEN | Bucket Nov | BUCKET | Loss Rate Nov | Loss Rate Nov | DPD Max | Outstanding | LOSS | % CKPN | ADD
2520089 | [NAME] | 3 | OOO | 1 | 5 |  | 0.422363900149256 |  | 263914916073.32 | 2015140826.59199
1421113 | [NAME] | 3 | OOO | 1 | 4 |  | 0.2972278671695063 |  | 221112228939.0998 | 1748824931.63287
2879593 | [NAME] | 3 | OOO | 1 | 2 |  | 0.09545138732200557 |  | 123528765176.81 | 173298267.9833039
3392134 | [NAME] | 3 | OOO | 1 | 2 |  | 0.09545138732200557 |  | 122968957762.83 | 1003606433.811523
2852066 | [NAME] | 3 | OOO | 1 | 5 |  | 0.4223639001492558 |  | 108563587180.57 | 903301378.498397
2027868 | [NAME] | 2 | OOO | 1 | 2 |  | 0.08251497098306088 |  | 102377757771.63 | 780292344.6672587
1166132 | [NAME] | 4 | OOO | 1 | 5 |  | 0.362254226986679 |  | 100664220009.9 | 317340019.8517557
1128067 | [NAME] | 6 | OOO | 1 | 5 |  | 0.3208682078434202 |  | 91949725515.71994 | 306199202.1679718
1565621 | [NAME] | 4 | OOO | 1 | 3 |  | 0.181581375647561 |  | 89511625734.95998 | 379648320.2113815
3366069 | [NAME] | 4 | OOO | 1 | 2 |  | 0.08859936856898892 |  | 88801226828.24 | 421306527.3399
2060385 | [NAME] | 6 | OOO | 1 | 2 |  | 0.06948185915873285 |  | 86675527263.22998 | 298870494.5509707
3136967 | [NAME] | 15 | OOO | 1 | 2 |  | 0.1339468787572012 |  | 84093761690.97 | 641255799.773328
3391556 | [NAME] | 15 | OOO | 1 | 3 |  | 0.244380539746422 |  | 82580307078 | 687004371.793733
 |  |  |  | I want to fill in the numbers 1 to 5 in the "F" column as per my wish. And in column G, it contains data from the "lookup" sheet based on column F and column RO from sheet "COM". Please kindly help
Spreadsheet: 792943d1661241892-creating-a-schedule-that-then-creates-a-list-use-if-index-vlookup-book1-1-
Sheet: Main (2)

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday |  | Player | Mon | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
[NAME] | Mon
[NAME]
Balazs G
[NAME]
[NAME] | Mon
[NAME] |  | 1
Bud A | Mon
[NAME] |  |  |  |  |  | 1
Chander B
[NAME]
Spreadsheet: 9a74a5c9-bbdb-466b-9760-07ea3df0e486
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
[NAME] | Test | [NAME] | Methylphenidate (Ritalin), Urine-Forensic | Methylphenidate, Urine-Forensic | Gas Chromatography/Nitrogen Phosphorus Detection (GC-NPD) Gas Chromatography/Mass Spectrometry (GC/MS) | [NAME]: Urine |  |  | 10 | mL | 10 mL from a random or spot urine collection, shipped refrigerate or frozen.  Note:   Submission of the minimum volume results in an elevated                 reporting limit and inability to repeat analysis. | 3.0 mL | Specimens other than	[NAME] Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | [NAME] have not been established for urine specimens.  This specimen was handled by Medtox Laboratories as a  Forensic specimen under chain of custody protocol.  Test Performed By:  Medtox Laboratories                                          402 W. County Road D                                          St. Paul, MN  55112 | Monday through Sunday | 5 days [NAME] specimens can take up to 6 weeks | 7 days [NAME] specimens can take up to 7 weeks | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated
[NAME] | Result | Z1210 | Methylphenidate | Methylphenidate | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 881701d1729846016-calculate-min-and-max-time-in-a-sequence-of-times-over-several-days-min-and-max
Sheet: Sheet1

Date | Time | MIN Time | MAX Time
03/06/2013 | 08:04:49
03/06/2013 | [NAME]
03/06/2013 | 08:36:39
03/06/2013 | 11:01:46
03/06/2013 | 11:02:16
[NAME] | [NAME]
[NAME] | 09:22:59
[NAME] | 09:23:58
[NAME] | 07:46:53
[NAME] | 07:46:56
[NAME] | 08:28:52
[NAME] | 09:31:42
[NAME] | 09:33:41
06/06/2013 | 10:58:50
06/06/2013 | 10:59:28
07/06/2013 | 08:12:55
07/06/2013 | 08:39:07
07/06/2013 | 09:54:34
07/06/2013 | [NAME]
 | =IF(B2=MINIFS($B$2:$B$20,$A$2:$A$20, A2),B2, "")
 | =IF(B2=MAXIFS($B$2:$B$20,$A$2:$A$20, A2),B2, "")
Spreadsheet: 219906d1363010239-autopopulate-formula-from-two-columns-of-data-copy3-of-amc-2013-budget-2-
Sheet: JAN - Report

Allenmore Men's Club                                                        Treasurers Report  -  January 2013
Starting Balance: | 434
Monthly Income: | 125
Monthly Expenses: | 255
Ending Balance: | 304
Change: | -130
Receipts since last report:
Junior member dues |  |  |  |  | 100
Miscellaneous Income |  |  |  |  | 25
0 |  |  |  |  | -
- |  |  |  |  | -
 |  |  | Total Receipts:
Dispursements:
 |  |  | Total Dispursements:
Special Notes:
Prepared By: | Secretary/Treasurer |  | Accepted By:
 | [NAME]
 |  |  | ü | Allenmore Men's Club
 |  |  | ü | General Meeting
 | Signature |  | ü | Membership in Attendance
 |  |  | ü | Passed & Recorded
 |  | Date |  | into Minutes
Spreadsheet: 166263d1341510780-getting-a-cell-to-populate-when-it-sees-a-name-airframe-engine-log-sample-modified-by-tigeravatar-v2
Sheet: Phil

Today is:
 | Date | Hourly | Cost Calculator
 |  |  |  |  | RUNNING TOTAL
 |  |  |  |  |  | Expenses
 |  |  |  |  |  | Date | Cost | Description
 |  |  | Total
Spreadsheet: 740763d1626553333-data-validation-choose-one-data-validation-for-only-unselected-items-jbarter-
Sheet: Equipment

[NAME]'s | Splicer's Used Count | Splicer's Available | Locator's | Locator's Used | Locator's Available | Rodder's | Rodder's Used | Rodder's Available
Spokane Splicer #1 |  |  | Spokane Locator #1 |  |  | Spokane Rodder #1 (300')
Spokane Splicer #2 |  |  | Spokane Locator #2 |  |  | Spokane Rodder #2 (300')
Spokane Splicer #3 |  |  | Spokane Locator #3 |  |  | Spokane Rodder #3 (500')
Spokane Splicer #4 (Repair) |  |  | Spokane Locator #4
Spokane Splicer #5
 | [NAME] | Splicer's Available | Locator List |  |  | Rodder List
[NAME] Tester | Battery Tester Used | Battery Tester Available | Spokane Optical Power Meter | Power Meter Used | Power Meter Available Available
[NAME] Tester #1 |  |  | Spokane Optical Power Meter #1
 | Battery Tester List |  |  | Power [NAME]
Spokane OTDR | Spokane OTDR Used | Spokane OTDR Availble
Spokane OTDR #1
Spokane OTDR #2
 | OTDR List
Spreadsheet: 683493d1592773835-cross-reference-table-help-example
Sheet: Sheet2

NAME | REGION |  | STORE | REGION | GROSS SALES 2019 | GROSS SALES 2020 | Name |  |  |  | Row Labels | Sum of GROSS SALES 2019 | Sum of GROSS SALES 2020
BOB | CENTRAL |  | STORE 1 | CENTRAL | 50 | 65 |  |  |  |  | STORE 1 | 411 | 629
BOB | EAST |  | STORE 2 | CENTRAL | 20 | 60 |  |  |  |  | STORE 2 | 147 | 167
SUSAN | WEST |  | STORE 3 | CENTRAL | 80 | 100 |  |  |  |  | STORE 3 | 282 | 308
SUSAN | CENTRAL |  | STORE 4 | CENTRAL | 100 | 40 |  |  |  |  | STORE 4 | 291 | 180
MIKE | CENTRAL |  | STORE 5 | CENTRAL | 5 | 5 |  |  |  |  | STORE 5 | 579 | 506
[NAME] | ECOMMERCE |  | STORE 1 | EAST | 20 | 23 |  |  |  |  | Grand Total | 1710 | 1790
SCOTT | ECOMMERCE |  | STORE 2 | EAST | 10 | 12
JOE | CENTRAL |  | STORE 3 | EAST | 45 | 44
JOE | SOUTH |  | STORE 4 | EAST | 105 | 45
 |  |  | STORE 5 | EAST | 80 | 90
 |  |  | STORE 1 | WEST | 0 | 2
 |  |  | STORE 2 | WEST | 22 | 35
 |  |  | STORE 3 | WEST | 28 | 35
 |  |  | STORE 4 | WEST | 60 | 23
 |  |  | STORE 5 | WEST | 20 | 64
 |  |  | STORE 1 | SOUTH | 1 | 3
 |  |  | STORE 2 | SOUTH | 50 | 26
 |  |  | STORE 3 | SOUTH | 70 | 64
 |  |  | STORE 4 | SOUTH | 23 | 62
 |  |  | STORE 5 | SOUTH | 69 | 23
 |  |  | STORE 1 | ECOMMERCE | 340 | 536
 |  |  | STORE 2 | ECOMMERCE | 45 | 34
 |  |  | STORE 3 | ECOMMERCE | 59 | 65
 |  |  | STORE 4 | ECOMMERCE | 3 | 10
 |  |  | STORE 5 | ECOMMERCE | 405 | 324
Spreadsheet: 157712d1337853671-index-match-vlookup-returning-values-from-worksheets-based-upon-matching-cells-test1
Sheet: 1

Material | Short Text | OPEN QUANTITY | PO NUMBER | DEL. DATE | MATCH
 |  |  | 4500633332
 |  |  | 4500632540
 |  |  | 4500636245
 |  |  | 4500632544
 |  |  | 4500632563
 |  |  | 4500636242
 |  |  | 4500637921
 |  |  | 4500640467
 |  |  | 4500640471
 |  |  | 4500642501
 |  |  | 4500642499
 |  |  | 4500640465
 |  |  | 4500640468
 |  |  | 4500640464
 |  |  | 4500643518
 |  |  | 4500643521
 |  |  | 4500642834
 |  |  | 4500642836
 |  |  | 4500642838
 |  |  | 4500642846
 |  |  | 4500642847
 |  |  | 4500640159
 |  |  | 4500642832
 |  |  | 4500642840
 |  |  | 4500643517
 |  |  | 4500647337
 |  |  | 4500646186
 |  |  | 4500647081
 |  |  | 4500647080
 |  |  | 4500643522
 |  |  | 4500651708
 |  |  | 4500647078
 |  |  | 4500649679
 |  |  | 4500643510
 |  |  | 4500649680
 |  |  | 4500651526
 |  |  | 4500647076
 |  |  | 4500647079
 |  |  | 4500653945
 |  |  | 4500653930
 |  |  | 4500653928
 |  |  | 4500653932
 |  |  | 4500653946
 |  |  | 4500653931
 |  |  | 4500653925
Spreadsheet: 720559d1614190576-formula-curve-workbook2
Sheet: Sheet1

 |  |  | A | B | C
1 |  |  | 800 | 600 | 200
2
3
4
5
6 |  |  |  |  | 650
7
8
9
10
11
12
13
14
15
16
17
18
19
20 |  |  |  |  | 800
Spreadsheet: 782487d1654076132-associating-different-text-cells-to-one-text-cell-to-calculate-cost-average-average-with-range-criteria-aligw
Sheet: Sheet1

Quarter | item | Sales
Q1 | Lego | 466.44
 | [NAME] | 345.55
 | Games
 | Cards
 | Pen
 | Stickers | 145.75
 | Books | 1753.43
 | Highlighters | 276.23
Q2 | Lego | 434.93
 | [NAME]
 | Games | 60.65
 | Cards
 | Pen
 | Stickers | 368.93
 | Books | 2546.23
 | Highlighters | 203.65
Q3 | Lego | 554.65
 | [NAME] | 768.75
 | Games | 84.9
 | Cards
 | Pen
 | Stickers | 124.98
 | Books | 1345.63
 | Highlighters
Channel | Average CPM
Toys
Stationary
Lego
[NAME]
Games
Cards
Pen
Stickers
Books
Highlighters
Spreadsheet: 060f1e81-82d9-4615-b934-8fcbe6763616
Sheet: TP1

Winter 2008 | TRA1000
Surname | GivenName | StudentNumber | Status | Faculty | [NAME] | TP1 (35) | TP1 (10) | %
Surname1 | GivenName1 | 12345 |  | Arts | [EMAIL] | 23
Surname2 | GivenName2 | 23456 |  | Arts | [EMAIL]
Surname3 | GivenName3 | 34567 |  | Arts | [EMAIL]
Surname4 | GivenName4 | 45678 |  | Arts | [EMAIL]
Surname5 | GivenName5 | 56789 |  | Arts | [EMAIL]
Average
Spreadsheet: 0bf53f37-2674-4d3a-8ab4-59666a4497fd
Sheet: 1.2 Unemployment

1.2 Unemployment
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
Number unemployed (a) – '000
July | 603.1044836 | 602.2242438 | 623.3584273 | 691.0389428 | 749.7777466
August | 600.0975807 | 609.8506328 | 629.6089024 | 693.7330634 | 757.2341634
September | 598.4272231 | 614.9001405 | 635.5883384 | 698.187019 | 763.649064
October | 597.0057885 | 617.2816412 | 640.5176165 | 704.5159601 | 768.681131
November | 594.464274 | 617.0110768 | 645.233069 | 711.1917483
December | 590.8274618 | 614.9436617 | 650.5239809 | 716.7531415
January | 587.0984425 | 612.7359555 | 656.7381964 | 720.4044641
February | 583.7191711 | 612.0299347 | 664.0686297 | 722.7668822
March | 581.6880732 | 611.7032466 | 672.1870235 | 725.1256712
April | 583.1657171 | 611.9016591 | 679.8694399 | 728.4180647
May | 587.741142 | 613.8969009 | 685.2291714 | 733.8297746
June | 594.2870876 | 617.9827187 | 688.6403398 | 741.426086
Annual average | 591.8022037666666 | 613.0384843583333 | 655.9635946 | 715.6159014916667
Unemployment rate (a) – per cent
July | 5.1890237 | 5.0965245 | 5.2048371 | 5.6832538 | 6.0794067
August | 5.148958 | 5.1525716 | 5.2510059 | 5.7030812 | 6.1348309
September | 5.1204154 | 5.1882559 | 5.2937142 | 5.7367061 | 6.1828366
October | 5.0955619 | 5.2034252 | 5.3266539 | 5.7845191 | 6.2204696
November | 5.0636937 | 5.1982665 | 5.3571601 | 5.8333208
December | 5.0255826 | 5.177887 | 5.3919758 | 5.8715941
January | 4.9895559 | 5.1545814 | 5.4343366 | 5.893357
February | 4.9590237 | 5.1416841 | 5.4856108 | 5.9037023
March | 4.9411777 | 5.1313217 | 5.5438976 | 5.9127267
April | 4.9522631 | 5.1258812 | 5.6002046 | 5.9289367
May | 4.9876207 | 5.1364353 | 5.6400795 | 5.9634534
June | 5.0371008 | 5.1651851 | 5.6655906 | 6.0176203
Annual average | 5.0424981 | 5.156001625 | 5.432922225 | 5.852689291666668
(a) Monthly figures are trend. Annual figures are from the original series.
 |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-12-11 00:00:00
Spreadsheet: mark_taylor__24791__Development Checklist
Sheet: Life Support

These items are close to "dead" - not being pursued for the time being
 |  | Done |  | Responsibility | Resources | Date | Status Notes
Analytics (this may be dropped)
 | Functional Specification |  |  | [NAME] | [NAME]
 | Functional Construction |  |  | [NAME] | [NAME]
 | Look and Feel |  |  | [NAME] | [NAME] | 2000-11-05 00:00:00 | Selected Viant as outside agency.  [NAME] definition and project comencement begins 12/5/00. Project deadline 29/06/00
Price Data Feeds
 | Functional Specification |  |  | [NAME] |  | 19/5/00 | Available feeds include Nymex, IPE, CME
 | Functional Construction |  |  | [NAME] |  | 2000-10-05 00:00:00 | Awaiting Functional Spec
 | Look and Feel |  |  | [NAME] | [NAME] | 30/5/00 | Selected Viant as outside agency.  [NAME] definition and project comencement begins 12/5/00. Comps decision on June 1/00