tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e0a07f5e-9660-4770-acce-b799ae3013e1
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 859219001694 | My Destiny Place | Let Us Entertain You / Never Give Up | 2011-04-19 | DVD | Children | 5.95 | Y | Available
Taseis | 859219001595 | My Destiny Place | Imagine This / Believe In You | 2011-04-19 | DVD | Children | 5.95 | Y | Available
Taseis | 859219001793 | My Destiny Place | Practice, Practice, Practice! [NAME] | 2011-06-21 | DVD | Children | 5.95 | Y | Available
Spreadsheet: 719413d1613658835-sumifs-formula-not-valid-value-hh_job_-template_2021
Sheet: Rate Sheet

 | Nickname | Rate
Spreadsheet: 0a60a79c-c7bf-43fc-a729-2c4ccdbdba32
Sheet: SmAgcy-Timesheet

STUDENT EMPLOYEE TIMESHEET
(Must Be Completed using Excel)
 |  |  | Foundation for California Community Colleges
 |  |  | Student Assistant Program
 |  |  | 1102 Q Street, 3rd Floor
 |  |  | Sacramento, CA  95814 |  |  |  |  |  |  |  |  |  |  |  | Pay Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beginning
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ending
LAST NAME |  |  |  | FIRST NAME |  | M.I.
 |  |  |  |  |  |  |  |  |  |  |  | Region: |  | Select Your Region
STUDENT ASSISTANT EMPLOYEE NUMBER
 |  |  |  |  |  |  |  |  |  |  |  | Task/PCA Code: |  |  | Select Your Task/PCA
Time Entry Sample |  |  | 09:30:00 | 13:30:00
1st Wk | DATE | IN | OUT | IN | OUT | HRS |  |  |  |  |  |  | STUDENT INSTRUCTIONS
Sunday |  |  |  |  |  |  |  |  |  |  |  |  | 1. | Keep your own daily record of time and assignments.
Monday |  |  |  |  |  |  |  | Regular Hours |  |  |  |  | 2. | Check with your supervisor for instructions in preparing
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  | this form.
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  | 3. | Retain a copy of the timesheet for your records.
Thursday |  |  |  |  |  |  |  |  |  |  |  |  | 4. | Complete all timesheets using Excel.
Friday |  |  |  |  |  |  |  | Overtime Hours |  |  |  |  | 5. | Time enteries are recorded by typing  HH:[NAME] (A or P)
Saturday |  |  |  |  |  |  |  |  |  |  |  |  |  | HH is equal to Hour.  MM is equal to Minutes
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A is [NAME]  P is P.M.
2nd Wk | DATE | IN | OUT | IN | OUT | HRS |  |  |  |  |  |  | 6. | Reflect any meal breaks required for hours worked in
Sunday |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  | excess of six (6) hours in one day.
Monday |  |  |  |  |  |  |  |  |  |  |  |  | 7. | Round hrs to the nearest quarter-hour(I.e. .15, [NAME], .45).
Tuesday |  |  |  |  |  |  |  |  |  |  |  |  | 8. | Record only one pay period per timesheet.
Wednesday |  |  |  |  |  |  |  |  |  |  |  |  | 9. | Supervisor must initial  ALL changes.
Thursday |  |  |  |  |  |  |  | Total Hours |  |  |  |  | 10. | Any overtime,or weekend or holiday worktime must be
Friday |  |  |  |  |  |  |  |  |  |  |  |  |  | approved by your Supervisor in writing.
Saturday |  |  |  |  |  |  |  |  |  |  |  |  | 11. | Forward any address changes to FCCC in writing.
 |  |  |  |  | Total Hours
I hereby certify that this employee's timesheet is true and correct for this time period and reflects the actual time worked. |  |  |  |  |  |  |  |  |  |  |  |  |  | Approval By Student Employee Coordinator
I understand that it is my responsibilty to notify FCCC's Student Assistant Coordinator of any changes to this sheet.
STUDENT SIGNATURE |  |  |  |  |  | [NAME] PHONE |  |  |  | DATE
SUPERVISOR'S SIGNATURE |  |  |  |  |  | WORK PHONE |  |  |  | DATE |  |  |  |  | Last Revision | 2007-07-25 00:00:00
Spreadsheet: 720400d1614139403-filter-formula-to-pull-data-from-matching-range-group-filter-group-example
Sheet: DATA TEST

 | CLASS 1 |  |  | CLASS B |  |  | CLASS 4 |  |  | CLASS G
 | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA | NAME | SCORE | CRITERIA
 | [NAME] | 50 | PASS | SAM | 550 | PASS | [NAME] | 51 | PASS | JAKE | 551 | FAIL
 | TOM | 300 | FAIL | WILL | 270 | PASS | FRANK | 301 | FAIL | JENNY | 271 | FAIL
 | BILL | 25 | FAIL | BOB | 15 | PASS | [NAME] | 26 | FAIL | WILMA | 16 | PASS
 | FRED | 250 | FAIL | TOM | 275 | PASS | PAT | 251 | PASS | OLGA | 276 | FAIL
 | SUE | 5 | PASS | [NAME] | 25 | FAIL | [NAME] | 6 | PASS | EUGENE | 26 | PASS
 | [NAME] | 250 | FAIL | HARRY | 50 | PASS | FRED | 251 | PASS | HARRY | 51 | PASS
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA:
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CLASS: | CLASS 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME: | TOM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | SCORE: | 300
 |  |  |  |  |  |  |  |  |  |  |  |  |  | CRITERIA: | FAIL
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: West Power

West Power
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Power |  | West Orig |  | 36360000
[NAME] |  | Power |  | West Orig |  | 52626271
Wehn |  | Power |  | West Orig |  | 0
[NAME] |  | Power |  | West Orig |  | 6500000
[NAME] |  | Power |  | West Orig |  | 18123000
Thome |  | Power |  | West Orig |  | 0
Krebs |  | Power |  | West Orig |  | 0
Choi |  | Power |  | West Orig |  | 0
Rosman |  | Power |  | West Orig |  | 0
Calger |  | Power |  | West Orig |  | 10784435
Wolfe |  | Power |  | West Orig |  | 0
Etringer |  | Power |  | West Orig |  | 0
McDonald |  | Power |  | West Orig |  | 288500
Page |  | Power |  | West Orig |  | 0
Slaughter |  | Power |  | West Orig |  | 0
Rawson |  | Power |  | West Orig |  | 0
Malowney |  | Power |  | West Orig |  | 0
Buerkle |  | Power |  | West Orig |  | 0
[NAME] |  | Power |  | West Orig |  | 0
Scholtes |  | Power |  | West Orig |  | 0
[NAME] |  | Power |  | West Orig |  | 937850
Cocke |  | Power |  | West Orig |  | 0
Total Origination
MPR Activity
Calger |  | Las Vegas Cogen |  | West Generation
Calger |  | [NAME] |  | West Generation
Calger |  | Big Horn |  | West Generation
Total MPR
West Power Services included in Trading |  |  |  |  |  | 8357778
Fountain Valley (PSCO) |  |  |  |  |  | 4675000
Grand Total
Need allocation from [NAME].
Spreadsheet: 792106d1660740948-tier-value-deductions-tier-math-deduction-example
Sheet: Sheet1

Example 1
Allocated Units |  | 842
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499
[NAME] | 501 | 1000 |  | 0.75 |  | 343
Tier 3 | 1001 | 1500 |  | 1 |  | 0
[NAME] | 1501 | 1600 |  | 1.25 |  | 0
[NAME] per unit
Example 2
Allocated Units |  | 1247
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499
[NAME] | 501 | 1000 |  | 0.75 |  | 499
Tier 3 | 1001 | 1500 |  | 1 |  | 249
[NAME] | 1501 | 1600 |  | 1.25 |  | 0
[NAME] per unit
Example 3
Allocated Units |  | 1527
Tier | Range |  |  | Charge |  | Chargeable Units |  | Total Charge
Tier 1 | 1 | 500 |  | 0.25 |  | 499
[NAME] | 501 | 1000 |  | 0.75 |  | 499
Tier 3 | 1001 | 1500 |  | 1 |  | 499
[NAME] | 1501 | 1600 |  | 1.25 |  | 30
[NAME] per unit
Spreadsheet: 153326d1335874995-excel-formula-or-array-to-count-if-certain-text-is-in-adjscent-cells-0-0
Sheet: Φύλλο3

Key (front panel) | START G5 | 2
Key (front panel) | START G6 | 2 |  |  | 4
(front panel) Key | START G7 | 2
Key (front panel) | G8 START | 2
 | START G9 | 1
(front panel) | START G10 | 1
 |  | 0
 |  |  |  |  | Your result
 |  | You can hide this column.
Spreadsheet: 211034d1359639932-simple-filter-g_r_n_2013-2014
Sheet: Sheet3

 | RESTURANT REQUETION
 |  | PARTICULARS (FOR PARTY) | QUANTITY | RECEIVED
 | 1 | OVAL PLATER | 10
 | 2 | SNAKS TROLY | 2
 | 3 | BREAD TONG | 6
 | 4 | ICE CUBES | 5 K.G
 | 5 | STOOL BOX | 6
 | 6 | ICE CREEAM SCOPPER | 2
 | 7 | DISPO BOWL | 06 PAKETS
 | 8 | SOFT NAPKIN | 20 PAKETS
 | 9 | SUGER CANDY | 1 K.G
 | 10 | ANISED | 1 K.G
 | 11 | FUEL CONTAINER | 10
 | 12 | [NAME] PLATES FOR SNAKS | 30PK
 | 13 | TABLE CLOTH | 10
 | 14 | FRILL CLOTH | 6
 | 15 | NAPKIN STAND | 15
 | 16 | SILVER FOIL | 1
 | 17 | [NAME] | 200
 | 18 | SOUP TURINE | 2
 | 19 | SNAKS TRAY | 12
 | 20 | SALVER ROUND | 10
 | 21 | AMRICAN TRAY | 10
 | 22 | HIGH  BALL GLASS | 350
 | 23 | ICE CREAM CONTAINER | 1
 | 24 | DEEP GLASS BOWL (ROUND) | 6
 | 25 | DEEP GLASS BOWL (OVAL) | 6
 | 26 | CHEFFING DISH | 12
 | 27 | SOUP BOWL | 200
 | 28 | SOUP BOWL SAUCCER | 200
 | 29 | SOUP SPOON | 200
 | 30 | SOUP LADDLE | 4
 | 31 | LADDLE | 12
 | 32 | A.P SPOON | 300
 | 33 | A. P FORK | 300
 | 34 | PAPER NAPKINS | 30
 | 35 | DINNING FULL PLATE | 350
 | 36 | DESERT PLATE | 250
 | 37 | WATER CONTAINER | 6
 | 38 | WATER CONTAINER COVER | 2
 | 39 | MOCKTAIL DRUM (MED SIZE) | 2
 | 40 | PICKLE JAR | 1
 | 41 | TEA SPOON | 300
 | 42 | cruet set (steel made) | 6
 | 43 | pineapple juice | 15
 | 44 | vanilla ice cream | 1
 | 45 | freesh cream | 2
 | 46 | coke | 7
 | 47 | sprite | 7
 | 48 | fanta | p
 | 49 | WEAPING CLOTH | 10
 | 50 | TOMATO SAUCE | 01  BOTTLE
 | 51 | TOOTH PICK | 10
 | 52 | BUTTAM PIN | 02PK
 | 53
 | 54
 | 55
 | 56
 | 57
Spreadsheet: 83902d1283940174-pasting-specific-text-from-an-array-of-text-selected-text
Sheet: Sheet1

What I have | Side A | Side B | 1 | 2 | 3
 | a | 1 | PC | Faulty | POKE
 | c | 2 | Faullty | PC | POKE
 | f | 3 | PC | PC | POKE
 | r | 4 | Faullty | PC | POKE
 | e | 5 | Faullty | PC Future | PC Future
 | w | 6 | Faullty | PC Future | PC
What I would like | Side A | Side B | 1 | 2 | 3
 | a | 1 | PC
 | c | 2 |  | PC
 | f | 3 | PC | PC
 | r | 4 |  | PC
 | e | 5
 | w | 6 |  |  | PC
Spreadsheet: 31906d1227908362-how-to-put-multiple-codes-on-one-sheet-my-sheet
Sheet: Sheet1

 | Good | Good | Good | Good
 | Good | Good | Good | Good
 | Good | Good | Good | Good | <---  These change when clicked on.  (Works Well)
 |  |  |  |  |  | But I would like to this code to the sheet to control these boxes.
 |  |  |  |  |  | When I add this code below, the sheet gives me error codes and does not work.
 |  |  |  |  |  | Private Sub Worksheet_SelectionChange(ByVal Target As Range)
 |  |  |  |  |  | Const WS_RANGE As String = "b11:e13" '<=== change to suit
 |  |  |  |  |  | If ActiveCell.[NAME], -1).Value <> "q" Then
 |  |  |  |  |  | Exit Sub
 |  |  |  |  |  | End If
 |  |  |  |  |  | On Error GoTo err_handler
 |  |  |  |  |  | Application.EnableEvents = False
 |  |  |  |  |  | If Not Application.Intersect(Target, Range(WS_RANGE)) Is Nothing Then
 |  |  |  |  |  | With Target
 |  |  |  |  |  | .Font.Name = "Yes"
 |  |  |  |  |  | Select Case .Value
 |  |  |  |  |  | Case "Yes":   .Value = "No"
 |  |  |  |  |  | Case "No":   .Value = "Maybe"
 |  |  |  |  |  | Case "Maybe":   .Value = ""
 |  |  |  |  |  | Case Else:   .Value = "Yes"
 |  |  |  |  |  | End Select
 |  |  |  |  |  | .Offset(2, 0).Select
 |  |  |  |  |  | End With
 |  |  |  |  |  | End If
 |  |  |  |  |  | err_handler:
 |  |  |  |  |  | Application.EnableEvents = True
 |  |  |  |  |  | End Sub
Spreadsheet: 470429d1468487969-calculating-the-total-between-two-times-that-go-over-midnight-time-difference-example
Sheet: Sheet1

 |  |  |  | Hours/Mins | Decimal | Absolute | =E2*24
5th | Tue | 20:00:00 | 08:00:00 |  |  |  |  |  | ######
8th | Fri | 15:30:00 | 21:00:00 |  |  |  |  |  | 05:30:00
8th | Fri | 18:20:00 | 23:59:00 |  |  |  |  |  | 05:39:00
9th | Sat | 00:00:00 | 23:59:00 |  |  |  |  |  | 23:59:00
 |  |  |  | =24*(C2>D2)+D2-C2
 |  |  |  |  | =(D2-C2)*24
 |  |  |  |  |  | =ABS((D2-C2)*24)
 |  |  |  |  |  |  | =E2*24
Spreadsheet: 757527d1638312146-adding-another-formula-to-a-formula-forum-sample-workbook
Sheet: JACK

YEAR | MONTH | WC | TODAYS DATE | PATIENT NAME | SEEN BY | APT TYPE | COST 1 | ADDITIONS | COST 2 | TOTAL | PAYMENT METHOD | PN | CUT
 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 1
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | xray | 75 | 114 | card | 2 |  | need formula to add £20 to the cut if I2 says [NAME]
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 3
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | xray | 75 | 0 | 0 | 75 | cash | 4 |  | correct
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | Alter G | 15 | 0 | 0 | 15 | cash | 5
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | cash | 6
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 7
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 8
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 9
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 10
2021 | Oct | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 0 | [NAME] | [NAME] | 39 | 0 | 0 | 39 | card | 11
Spreadsheet: 740486d1626356511-multiple-dates-entries-in-a-gantt-chart-in-a-single-row-scheduler-3a-with-new-tab-1-ans
Sheet: Gantt

 |  |  |  |  |  |  |  |  |  | 2
Select Month
Patient Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
Spreadsheet: 110178d1306930487-help-with-data-arrangement-example
Sheet: Sheet1

 |  | CPT | LHR | MUC | FRA
 | SYD | ? | ? | ? | ?
 | HKG | ? | ? | ? | ?
 | LAX | ? | ? | ? | ?
 | MIA | ? | ? | ? | ?
 | CDG/ORY | ? | ? | ? | ?
 | Sum of Passengers | Departing From
 | Arriving at | CDG | CPT | HKG | LAX | MIA | ORY | SYD | Grand Total
 | CPT | 7553 |  | 3673 | 5724 | 38 | 2234 | 10224 | 29446
 | FRA | 33464 |  | 3783 | 665 | 132 | 43756 | 4574 | 86374
 | LHR | 8846 |  | 236 | 8244 | 485 | 23553 | 125743 | 167107
 | MUC | 4534 |  | 8354 | 2536 | 236 | 53445 | 354 | 69459
 | SYD |  | 45367 |  |  |  |  |  | 45367
 | Grand Total | 54397 | 45367 | 16046 | 17169 | 891 | 122988 | 140895 | 397753
Spreadsheet: 328539d1403941453-vlookup-with-2-criteria-using-formula-results-and-text-book2excel-jacc
Sheet: Sheet1

Fixtures Needed
1
[NAME] number | Quantity | Description | Total Quantity Needed | [NAME] Ordered | PO #
 |  |  |  |  |  | <--Here is the column I am having trouble with. I want to lookup the detail number Column A of the Job (A3) in the book1 file and return the purchase order number
 |  |  |  |  |  |  |  |  |  | 7119 | [NAME] | 60 | 40416 | 60
 |  |  |  |  |  |  |  |  |  | 7119 | [NAME] | 61 | 40416 | 61
 |  |  |  |  |  |  |  |  |  | 7119 | [NAME] | 44 | 40417 | 44
 |  |  |  |  |  |  |  |  |  | 7119 | [NAME] | 25 | 40427 | 25
 |  |  |  |  |  |  |  |  |  | 7119
 |  |  |  |  |  |  |  |  |  | 7119
 |  |  |  |  |  |  |  |  |  | 7120
 |  |  |  |  |  |  |  |  |  | 7120
 |  |  |  |  |  |  |  |  |  | 7120 | [NAME] | 001 | 40382 | 001
 |  |  |  |  |  |  |  |  |  | 7120 | [NAME] | 002 | 40382 | 002
 |  |  |  |  |  |  |  |  |  | 7120
 |  |  |  |  |  |  |  |  |  | 7120
Spreadsheet: b67b16cf-dd03-4580-9e8c-941daf569348
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
35858746 | 2013-05-09 08:11:58 | AXIS | 1 | 5 | 0 | 1079338 | [NAME] | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
35858822 | 2013-05-09 08:25:22 | ALLIES | 1 | 5 | 2 | 1079338 | [NAME] | 6153 | western | 1944-08-24 | 1944-08-24 | Liberation of Paris | Libération de Paris
35905453 | 2013-05-12 11:21:58 | ALLIES | 1 | 6 | 3 | 309734 | Lamanick | 12508 | pacific | 1942-08-20 | 1942-08-21 | Tenaru | Tenaru
Spreadsheet: 803472d1667481534-return-blank-cell-and-not-zero-excelforum-1-
Sheet: Sheet1

 | [NAME] | فقط [NAME] |  | عدد القطع بعد [NAME] | عدد القطع بالفاتورة | كشف النقص في اكمال العدد |  |  |  | باركودات القطع حسب الفاتورة | باركود | عدد القطع حسب الفاتورة | باركود | عدد القطع حسب الفاتورة | [NAME] لم اضعها في الفاتورة
 |  | 2345 |  |  |  |  |  |  |  | 2345/23 |  | 1
 |  | 2345 |  |  |  |  |  |  |  | 2345/23 |  | 2
 |  | 2345
 |  | انتهى الجدول [NAME]
Spreadsheet: 668589d1584909736-hundreds-of-row-hundreds-of-tabs-there-has-to-be-a-faster-way-sample
Sheet: 002

 |  |  |  | Sole Source: |  | QTY: |  | Spares: | 0 | LOA Line: | 002 | Costs:
Note:  (Note 1, 188)  - This item will resist XXXXX.  Condense training.  This line provides for the production of twelve XXXX Block XXXXX to  include, but  not  limited  to: [NAME] to LO-D-SAA Signed 2 |  |  |  |  |  |  |  |  |  |  |  | (a) Unit | (b) Line Value
# | Item | NSN | PN | Need Date | Date Ordered | Document/ Requisition Number |  | Date Delivered | Date Installed | XXXX Installed | Line Manager Code | $ | $
1 | [NAME] and In Depth Module Sim | XXXX | XXXX | 2022-01-01 00:00:00 | 2020-11-19 00:00:00 | 4589945225 |  | --
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
S
S
S
S
S
Spreadsheet: 812547d1673239566-help-with-an-ifs-function-emojis-and-todays-date-copy-of-workout-tracker-2023
Sheet: Writing

Date | Number of Words Written | Goal 1000 +/-
2023-01-07 00:00:00 | 1881 |  | Number of Days Less Than Goal
2023-01-08 00:00:00 | 0 |  | Number of Days Goal Met
2023-01-09 00:00:00 |  |  | Number of Days Goals Exceeded
2023-01-10 00:00:00
2023-01-11 00:00:00
2023-01-12 00:00:00
2023-01-13 00:00:00
2023-01-14 00:00:00
2023-01-15 00:00:00
2023-01-16 00:00:00
2023-01-17 00:00:00
2023-01-18 00:00:00
2023-01-19 00:00:00
2023-01-20 00:00:00
2023-01-21 00:00:00
2023-01-22 00:00:00
2023-01-23 00:00:00
2023-01-24 00:00:00
2023-01-25 00:00:00
2023-01-26 00:00:00
2023-01-27 00:00:00
2023-01-28 00:00:00
2023-01-29 00:00:00
2023-01-30 00:00:00
2023-01-31 00:00:00
2023-02-01 00:00:00
2023-02-02 00:00:00
2023-02-03 00:00:00
2023-02-04 00:00:00
2023-02-05 00:00:00
2023-02-06 00:00:00
2023-02-07 00:00:00
2023-02-08 00:00:00
2023-02-09 00:00:00
2023-02-10 00:00:00
35 situps equals a one minute plank
10 minutes of Apple Fitness equals 150 situps - 20 minutes equals 300, etc.
Spreadsheet: 0ffd0e70-c8c1-47e7-8c4a-72df9908d8dd
Sheet: SpikerBox Raw Materials

Costs of Home-Made SpikerBox
 | Cost/Unit | Digi-Key Part #
Custom Circuit Board | 3.89 | NA
Enclosure Components
Wood (3/16 inch thick basswood) | 0.406 | NA
Nuts (4) | 0.081 | NA
Screws (4) | 0.128 | NA
Cork ( 1 in^2) | 0.0346 | NA
Double-Sided Tape | 0.0438 | NA
[NAME] | 0.06 | NA
Subtotal
Circuit Discreet Components
Header | 0.095 | A26509-40-ND
Chip Holders (3) | 1.11 | A24807-ND
9V battery | 2.25 | N145-ND
Speaker | 4.91 | 102-1554-ND
Audio Line-Out | 0.85 | CP1-3524NG-ND
0.047 uF capacitor | 0.37 | BC1099CT-ND
33 kOhm Resistor | 0.08 | CF14JT33K0CT-ND
0.1 uF capacitor | 0.44 | BC1148CT-ND
RCA input connector | 0.96 | CP-1403-ND
220 uF capacitor | 0.35 | 565-1674-ND
On/Off Switch | 3.18 | 432-1164-ND
LED | 0.54 | 67-1037-ND
10 uF capacitors (3) | 1.41 | 445-2868-ND
10 kOhm Resistor (2) | 0.16 | CF14JT10K0CT-ND
390 Ohm Resistor | 0.09 | CF1/4390JRCT-ND
1 kOhm Resistor | 0.08 | CF14JT1K00CT-ND
0.47 uF capacitor | 0.33 | 445-4804-ND
male 9V connector | 0.55 | 593K-ND
female 9V connector | 0.66 | 594K-ND
560 pF capacitor | 0.33 | 490-3850-ND
speaker header connector | 0.16 | 929974-01-36-ND
220 kOhm resistor | 0.08 | P220KBACT-ND
10 Ohm Resistor | 0.08 | P10BACT-ND
AD623 op amp IC | 4.17 | AD623ANZ-ND
TCL2272 op amp IC | 1.55 | 296-1812-5-ND
[NAME] chip IC | 1.06 | LM386N-3-ND
Subtotal
Electrode Costs
RCA Connector | 1.77 | CP-1452-ND
Sewing Needles (2) | 0.012 | NA
24 gauge Speaker [NAME] (6 inch length) | 0.06 | radioshack 278-1301
Subtotal
Total SpikerBox Material Costs
Custom Circuit Board
Enclosure
Circuit Components
Electrode
Magic Number
Smartphone Cable Costs
10 uF capacitor | 0.47 | 445-2868-ND
4.7k Resistor | 0.12 | 4.7KEBK-ND
3-conductor cable (1/2) | 1.88 | AE10361-ND
4-conductor cable (1/2) | 3.33 | CP-354S-M/M-ND
Stimulation Cable Costs
3-conductor cable (1/2) | 1.88 | AE10361-ND
[NAME] (2) | 3.49 | 461-1014-ND
Cheaper Stimulation Cable
3-conductor cable (1/2) | 1.88 | AE10361-ND
bare copper small clips | 0.64 | RadioShack Micro 1-1/8" Smooth Clips Catalog #270-373
Spreadsheet: 841690d1693859892-excel-formula-for-producing-student-report-student-progress-report
Sheet: Progress Report (2)

 | Kindly asking for excel formula to produce academic progress report as shown on the desired solution using information on database sheet
 | ACADEMIC PROGRESS REPORT
 | Desired solution
 | Select student I.D on Cell B8
 | BHA234 | Name
 |  | Class
 | END OF SECOND TERM 2023
 | Subject | Class Average (%) | Actual Mark (%) | Grade | Teacher’s Comment | Signature
 | MATHMATICS | 53 | 97 | A | Excellent performance | [NAME]
 | PRINCIPLES OF ACCOUNTS | 60 | 80 | A | This is good performance. | [NAME]
 | AGRICULTURE | 66 | 55 | C | Work hard | [NAME]
 | Biology | 62 | 90 | A | This is a splendiferous performance | [NAME]
 | B.Studies | 54 | 70 | B | Work hard | A. Mpala
 | English | 66 | 86 | A | A hardworking student | [NAME]
 | FRS | 70 | 98 | A | Excellent work | [NAME]
 | Geography | 61 | 93 | A | Good work | A. Mpala
 | Woodwork | 50 | 80 | A | Best student | [NAME]
 | Number of subjects recorded: |  |  | Passed : | 8
Spreadsheet: 2a5b30fe-d103-4030-88f3-e935e5242337
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
3060 | 5506 | [NAME] | Kinsley | RSA | 22 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:30:04
3060 | 12801 | Fabienne | St Louis | MRI | 24 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2 | 02:34:57
3060 | 15004 | Lidia | Rekas | POL | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 3 | 02:38:41
3060 | 15020 | Molly | Fonner | USA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 4 | [NAME]
3060 | 9863 | Charmaine | Shannon | NAM | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 5 | 02:55:22
Spreadsheet: michelle_lokay__26556__imbalsumm0012
Sheet: summary

Index is high - payback should be done on Dollar Valued payables
- payback should be done on Volumetric receivable
- payback should not be done on Dollar valued receivables
- payback should not be done on Volumetric payables
Positive = due [NAME]
Negative = due operator
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments |  |  |  |  |  |  |  | index
El Paso |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | SJ
PG&E |  |  |  | Volumetric | [NAME] |  |  |  |  |  |  |  |  | AVG
NGPL |  |  |  | Volumetric | [NAME]
SoCal |  |  |  | Volumetric | [NAME]
Mojave Pipeline |  |  |  | Volumetric | [NAME]
Mewborne |  |  |  | Dollar Valued | [NAME]
Duke |  |  |  | Dollar Valued | [NAME]
PNM |  |  |  | Dollar Valued | [NAME]
Oasis |  |  |  | Volumetric | [NAME]
Burlington |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month $214,357 is the 11/30/00 balance
Lonestar |  |  |  | Volumetric | [NAME]
TransColorado |  |  |  | Dollar Valued | [NAME]
PG&E TX |  |  |  | Dollar Valued | [NAME] | This balance is cashed out every month
NNG |  |  |  | Dollar Valued | [NAME]
Receivable imbalances
Operator | Dollars | Volume | As of Date | Imbal Type | MS rep | Comments
Pan-Alberta-shipper |  |  | 2000-11-30 00:00:00 | Dollar Valued | [NAME] | no payback to date
EOG |  |  |  | Dollar Valued | [NAME]
Conoco |  |  |  | Dollar Valued | [NAME]
Northwest |  |  |  | Volumetric | [NAME]
Agave |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Volumetric | Hernandez
Amoco Abo |  |  |  | Dollar Valued | [NAME]
Amoco |  |  |  | Volumetric | [NAME]
Red Cedar |  |  |  | Dollar Valued | [NAME]
[NAME] |  |  |  | Dollar Valued | [NAME]
Payable imbalances
Net imbals
 | 3111077
Note -  This report does not represent the total population of imbalances on Transwestern.