tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 215267d1361319773-summing-vlookup-values-sample-average-vlookup
Sheet: Friday

Date: | 2013-02-15 00:00:00
Agent Group: | FL COE
Agent Name | ACD Calls | Avg ACD Time | Avg ACW Time | % Agent Occupancy w/ ACW | % Agent Occupancy w/o ACW | Extn In Calls | [NAME] In Time | Extn Out Calls | [NAME] Time | ACD Time | ACW Time | Agent [NAME] | Other Time | AUX Time | Avail Time | Staffed Time
Totals | 5658 | 02:33:00 | :04 | 79 | 77 | 9 | 01:39:00 | 688 | :09 | 10 days, 1:00:01 | 07:20:44 | 06:08:34 | 12:13:12 | 1 day, 4:39:01 | 2 days, 20:59:22 | 15 days, 3:41:30
agent 8062054 | 208 | 01:55:00 | :01 | 93 | 92 | 0 |  | 32 | :04 | 06:37:30 | :02:46 | :10:28 | :02:38 | :35:02 | :33:29 | 08:01:53
agent 8062005 | 179 | 02:02:00 | :04 | 93 | 90 | 0 |  | 34 | :04 | 06:03:20 | :12:34 | :08:49 | :19:16 | :47:03 | :31:04 | 08:02:06
agent [NAME] | 162 | 02:12:00 | :06 | 89 | 86 | 0 |  | 24 | :10 | 05:57:11 | :15:56 | :08:15 | :13:50 | :41:13 | :46:26 | 08:02:51
agent 8062109 | 148 | 02:29:00 | :00 | 90 | 89 | 0 |  | 12 | :11 | 06:06:20 | :00:29 | :07:28 | :58:37 | :38:49 | :25:13 | 07:58:05
agent 8062100 | 145 | 02:37:00 | :09 | 93 | 88 | 0 |  | 16 | :11 | 06:18:23 | :25:32 | :07:17 | :08:10 | :38:18 | :31:04 | 08:08:44
agent 8062036 | 133 | 02:45:00 | :08 | 95 | 91 | 0 |  | 11 | :16 | 06:06:05 | :18:29 | :06:35 | :07:34 | 01:01:51 | :21:11 | 08:01:45
agent 8062114 | 126 | 02:20:00 | :01 | 94 | 93 | 0 |  | 11 | :08 | 04:54:31 | :02:18 | :06:17 | :05:21 | :32:54 | :20:20 | 06:01:41
agent 8062031 | 113 | 03:22:00 | :15 | 94 | 88 | 0 |  | 10 | :24 | 06:20:41 | :28:09 | :05:38 | :07:30 | :35:38 | :25:13 | 08:02:49
agent [NAME] | 93 | 02:13:00 | :04 | 52 | 50 | 0 |  | 9 | :04 | 03:25:33 | :07:30 | :04:32 | :11:18 | :36:05 | 03:36:00 | 08:00:58
agent 8062053 | 92 | 02:07:00 | :04 | 47 | 46 | 0 |  | 22 | :10 | 03:14:39 | :05:25 | :04:03 | :05:18 | :35:30 | 03:58:57 | 08:03:52
agent 8062044 | 82 | 03:07:00 | :04 | 92 | 90 | 0 |  | 11 | :06 | 04:16:02 | :05:39 | :04:07 | :00:58 | :16:09 | :22:05 | 05:05:00
agent 8062082 | 79 | 02:43:00 | :04 | 90 | 88 | 0 |  | 14 | :06 | 03:34:40 | :06:30 | :04:09 | :03:26 | :21:11 | :24:44 | 04:34:40
agent 8062088 | 77 | 02:50:00 | :01 | 52 | 52 | 1 | 05:01:00 | 7 | :10 | 03:38:06 | :01:35 | :03:21 | :10:06 | :35:35 | 03:33:01 | 08:01:44
agent 8062067 | 70 | 02:33:00 | :13 | 96 | 89 | 0 |  | 8 | :06 | 02:58:25 | :16:07 | :03:33 | :11:15 | :27:09 | :07:42 | 04:04:11
agent 8062033 | 68 | 01:57:00 | :09 | 92 | 86 | 0 |  | 6 | :30 | 02:13:04 | :09:39 | :03:32 | :19:45 | :16:39 | :15:18 | 03:17:57
agent 8062133 | 9 | 03:10:00 | :01 | 67 | 66 | 0 |  | 0 |  | :28:27 | :00:08 | :00:25 | :02:25 | :02:45 | :15:38 | :49:48
agent 8062134 | 4 | 02:07:00 | :02 | 59 | 58 | 0 |  | 0 |  | :08:27 | :00:07 | :00:11 | :00:00 | :02:23 | :06:10 | :17:18
Spreadsheet: 168882d1342621417-conditional-formatting-times-hh-mm-logon-sample
Sheet: Sheet2

Employee | Team | Logon | [NAME] | Lunch End | Logoff | Total Lunch | Total Shift | Total Available Hours
[NAME] | North | 2012-07-17 08:31:00 |  |  | 2012-07-17 17:27:00 |  | 0.3722222222222222 | 0.3722222222222222
[NAME] | South | 2012-07-17 07:25:00 |  |  | 2012-07-17 18:30:00 |  | 0.4618055555555556 | 0.4618055555555556
Goofy | North | 2012-07-17 08:20:00
Spreadsheet: 76474d1277032734-countif-maybe-applications-sent-spreadsheet
Sheet: Stat Overview

Recruitment: Half-Year Overview
June | Domcare | HCA | Senior HCA | RGN | RNLD | RMN | Total
Applications Sent | 19 | 77 | 0 | 4 | 0 | 2 | 105
Applications Returned | 0 |  |  |  |  |  | 8
Medium | Yellow Pages | JCP | TotalJobs | Gumtree | Our Website | Other
Total | 6 | 69 | 6 | 2 | 0 | 6
July | Domcare | HCA's | Senior HCA's | RGN | RNLD | RMN | Total
Applications Sent
Applications Returned
Medium | Yellow Pages | JCP | TotalJobs | Gumtree | Our Website | Other
Total
Spreadsheet: 82b45841-0cbb-4da4-8a16-72f0eced1080
Sheet: Sheet1

HASIL PENILAIAN PLPG TAHAP 5-8 TAHUN 2011
NO | NOMOR PESERTA | NAMA PESERTA | ASAL SEKOLAH | KAB/KOTA | STATUS
1 | 11031921710412 | ASRI TUKIYANTINAH | SMP N 4 KUDUS | Kab. Kudus | LULUS
2 | 11031921710430 | HASAN SUNARTO | SMP N 1 KUDUS | Kab. Kudus | LULUS
3 | 11031921710437 | YUSEPIN VIPI INDRIYANTI B | SMP N 1 BAE | Kab. Kudus | LULUS
4 | 11031921710444 | [NAME] | SMP BHAKTI PRAJA KALIWUNGU KUDUS | Kab. Kudus | LULUS
5 | 11031921710508 | ERLYN SURYANINGTYAS | SMP N 1 JATI KUDUS | Kab. Kudus | LULUS
6 | 11031921710527 | JOKO DARONO | SMP PGRI JATI KUDUS | Kab. Kudus | LULUS
7 | 11031921710528 | ANTHON SUGIYANTO | SMP N 1 DAWE | Kab. Kudus | LULUS
8 | 11031921710529 | P. HENDRA YUDHI PRIYANTO | SMP N 4 BAE KUDUS | Kab. Kudus | MENGULANG UJIAN TULIS
9 | 11031921710531 | SUMAKNO | SMP N 4 BAE KUDUS | Kab. Kudus | LULUS
10 | 11031921710532 | AGUS SULISTIONO | SMP N 1 KALIWUNGU KUDUS | Kab. Kudus | LULUS
11 | 11031921710663 | MOH MUCHLAS | SMA N 1 KUDUS | Kab. Kudus | LULUS
12 | 11031922010060 | EDY SAPUTRO | SD N 7 TANJUNGREJO | Kab. Kudus | MENGULANG UJIAN TULIS
13 | 11031922010366 | BEJO MULYONO | SD N 3 MARGOREJO | Kab. Kudus | LULUS
14 | 11031922010401 | TRI PRAWOSO | SMP N 3 JEKULO | Kab. Kudus | LULUS
15 | 11031922010414 | PURWADI | SMP N 1 JEKULO | Kab. Kudus | LULUS
16 | 11031922010422 | SUSIATI PRASETYANINGSIH | SMP N 2 KALIWUNGU | Kab. Kudus | LULUS
17 | 11031922010424 | SOMAN | SMP 2 GEBOG | Kab. Kudus | LULUS
18 | 11031922010429 | ADASANA | SMP N 4 BAE KUDUS | Kab. Kudus | LULUS
19 | 11031922010470 | SUPRIYADI | SMP N 5 KUDUS | Kab. Kudus | LULUS
20 | 11031922010493 | SUNARYO | SMP N 1 JATI KUDUS | Kab. Kudus | LULUS
21 | 11031922010548 | ROHANTI | SMP TAMAN DEWASA KUDUS | Kab. Kudus | LULUS
22 | 11031922010551 | SUNARTO | SMP BHAKTI | Kab. Kudus | TIDAK HADIR
23 | 11031922010591 | HARI TRI WIDIJANTO | SMA N 1 JEKULO | Kab. Kudus | LULUS
24 | 11031922010641 | SUGIHARYONO | SMA N 1 MEJOBO | Kab. Kudus | LULUS
25 | 11031922010658 | SULASHARINI | SMA N 1 MEJOBO | Kab. Kudus | LULUS
26 | 11031922010671 | SUMITRO | SMA 1 GEBOG | Kab. Kudus | LULUS
27 | 11031922010707 | NOOR RAHMAN | SMK N 1 KUDUS | Kab. Kudus | LULUS
28 | 11031922010717 | SULIYONO | SMK N 1 KUDUS | Kab. Kudus | LULUS
29 | 11031922010726 | DJUMONO | SMK N 1 KUDUS | Kab. Kudus | LULUS
30 | 11031922010738 | MEI REJEKI | SMK N 3 KUDUS | Kab. Kudus | LULUS
31 | 11031922010760 | SUWIKNYO | SMK N 2 KUDUS | Kab. Kudus | LULUS
Spreadsheet: 155230d1336735018-excel-2007-line-referenced-drop-downs-example3
Sheet: 1500

 | Rec break 1 |  |  | Rec break 2 |  |  | Rec break 3 |  |  | Rec break 4 |  |  | Rec break 5 |  |  | Rec break 6 |  |  | Rec break 7 |  |  | Rec break 8
 | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date | Value | Description | Date
AUD
CAD
CHF
EUR
GBP
USD | 14.26 | Claim for [NAME] | 2010-05-04 00:00:00
Spreadsheet: tracy_geaccone__40490__OM Schedule - IT 1
Sheet: Variance to C.E.

DIRECT O&M VARIANCE
2001 SECOND C.E. vs. 2002 PLAN
 |  | 2001 C.E. AS STATED | 2001 C.E. IF ADJUSTED FOR 2002 BUDGET CHANGES (1)
2001 2nd C.E. -  NET |  | 25.9 | 28.5
Variances:
SAN Monthly Fee |  | 2.2 | 0
O&E Additional Support |  | 0.7 | 0.3
EPSC |  | 0.8 | 0.8
Operations - Taxes & Benefits Not Included
in 2001 Plan |  | 0.6 | 0.6
2002  PLAN - NET
(1)  2001 Adjusted for $.4 O&E Support  (Offset Should be Reflected in Operations 2002 Plan) and
for a Full Year of SAN ($2.8MM).
Spreadsheet: 133851d1324698010-creating-a-p-and-l-worksheet-need-to-grab-data-within-the-quarter-by-the-date-column-banking-sample-file
Sheet: Bank

Date | Ck # | Entry | Description | Expense | Reference | Income | Reference | Fix Error | BALANCE |  |  |  |  |  |  |  |  |  |  |  | Income | Loan to PP | Credit | Accounting | Advertising | Auto | [NAME] | Client Products / Shirts | Consulting | Dues & Subscriptions | Legal / Professional | Licenses & Permits | [NAME] | Meals | Meetings | Miscellaneous | Office Expense | Office Supplies | Postage | Printing / Embroidery | [NAME] | [NAME] | Shipping | Software | Tools | Travel | Rents | Taxes | Commissions | Bank Fees
 |  |  |  |  |  |  |  |  | 881.8 |  | Reconcilliation
2011-03-03 00:00:00 | 1200 | Subway | Lunch | 35 | Meals |  |  |  | 846.8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35
2011-04-05 00:00:00 |  | Office Max |  | 120 | Advertising |  |  |  | 726.8 |  | Income |  |  | Total Income | 400 |  |  |  |  |  |  |  |  |  | 120
2011-06-12 00:00:00 |  | Deposit | Client Job #215 |  |  | 400 | Income |  | 1126.8 |  | Income | 400 |  |  |  |  |  |  |  |  | 400
 |  |  |  |  |  |  |  |  |  |  | Credit | 0 |  | Total Expenses | 137.5
 |  |  |  |  |  |  |  |  |  |  | Expenses |  |  | Total Profit / Loss | 262.5
 |  |  |  |  |  |  |  |  |  |  | Accounting | 0
 |  |  |  |  |  |  |  |  |  |  | Advertising | 120
 |  |  |  |  |  |  |  |  |  |  | Auto | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
 |  |  |  |  |  |  |  |  |  |  | Client Products / Shirts | 0 |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  | Consulting | 0 |  | [NAME] 1 | 0
 |  |  |  |  |  |  |  |  |  |  | Dues & Subscriptions | 0 |  | [NAME] 2 | 0
 |  |  |  |  |  |  |  |  |  |  | Legal / Professional | 0
 |  |  |  |  |  |  |  |  |  |  | Licenses & Permits | 0 |  | Total Taken for Dist | 0
 |  |  |  |  |  |  |  |  |  |  | Meals | 17.5 | 35
 |  |  |  |  |  |  |  |  |  |  | Meetings | 0
 |  |  |  |  |  |  |  |  |  |  | Miscellaneous | 0
 |  |  |  |  |  |  |  |  |  |  | Office Expense | 0 |  | Must take by 12/31 | 262.5
 |  |  |  |  |  |  |  |  |  |  | Office Supplies | 0 |  | Will be taxed on this
 |  |  |  |  |  |  |  |  |  |  | Postage | 0
 |  |  |  |  |  |  |  |  |  |  | Printing / Embroidery | 0
 |  |  |  |  |  |  |  |  |  |  | Shipping | 0
 |  |  |  |  |  |  |  |  |  |  | Software | 0
 |  |  |  |  |  |  |  |  |  |  | Tools | 0
 |  |  |  |  |  |  |  |  |  |  | Travel | 0
 |  |  |  |  |  |  |  |  |  |  | Rents | 0
 |  |  |  |  |  |  |  |  |  |  | Taxes | 0
 |  |  |  |  |  |  |  |  |  |  | Commissions | 0
 |  |  |  |  |  |  |  |  |  |  | Bank Fees | 0
 |  |  |  |  |  |  |  |  |  |  | Loans
 |  |  |  |  |  |  |  |  |  |  | Loan to PP | 0
 |  |  |  |  |  |  |  |  |  |  | [NAME] | 0
Spreadsheet: 267966d1380318797-compare-text-in-multiple-cells-and-ingore-blanks-sample
Sheet: Sheet1

Part Number | CATEGORY | Description | Location 1 | Location 2 | Location 3 | Location 4 | Location 5 | Location 6 | Location 7 | Location 8
1234 | TOOL | widget | Vendor 1 |  | Vendor 1 |  | Vendor 1 |  | Vendor 1 | Vendor 1 | GOOD
5678 | TOOL | Gadget |  | Vendor 2 |  | Vendor 4 |  | Vendor 6 | Vendor 7 | Vendor 8 | REVIEW
7654 | HARDWARE | Thingamajig | Vendor 1 |  | Vendor 4 |  | Vendor 4 |  | Vendor 7 |  | REVIEW
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: T18

Boeing Tour - AM |  |  |  |  | 2009-05-25 00:00:00
 | Driver: |  |  |  | Vehicle: |  |  |  |  |  | Prepaid
P/U Time | Booked by |  | Hotel |  | Party | A | C | CT | MF | Amt | CC | Ck | Collect | [NAME]
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
 | Cell#:                                Room #:                   Coupon:                      Notes:
Daily Total:
Pricing
Retail: | Adult | 55 | Child | 45 | Reseller: | Adult |  | 44 | Child |  | 36
Resellers: Alcatraz Media, [NAME], Look Tours, Sightseeing World, TourCorp
Driver Pickup Summary
Spreadsheet: 880469d1728278154-dynamic-lookup-with-multiple-criteria-npt-example
Sheet: NPT

 | Q-L-D |  |  |  | Q-D-L |  |  |  | L-D-Q |  |  |  | L-Q-D |  |  |  | D-L-Q |  |  |  | D-Q-L |  |  | L-D-Q
 | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies |  |  | Men | Ladies
Q1 | 1 |  |  | Q1 | 1 |  |  | L1 | 1 |  |  | L1 | 1 |  |  | D1 | 1 |  |  | D1 | 1 |  |  | NPT's (Men)
Q2 |  | 2 |  | Q2 |  | 2 |  | L2 |  | 2 |  | L2 |  | 2 |  | D2 |  | 2 |  | D2 |  | 2
[NAME] | 3 |  |  | [NAME] | 3 |  |  | Lake 3 | 3 |  |  | Lake 3 | 3 |  |  | D3 | 3 |  |  | D3 | 3
Q4 |  | 4 |  | Q4 |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4 |  | [NAME] |  | 4
Q5 | 5 |  |  | Q5 | 5 |  |  | L5 | 5 |  |  | L5 | 5 |  |  | D5 | 5 |  |  | D5 | 5
Q6 |  | 6 |  | Q6 |  | 6 |  | L6 |  | 6 |  | L6 |  | 6 |  | D6 |  | 6 |  | D6 |  | 6 |  | NPT's (Ladies)
[NAME] | 7 |  |  | [NAME] | 7 |  |  | L7 | 7 |  |  | L7 | 7 |  |  | [NAME] | 7 |  |  | [NAME] | 7
Q8 |  | 8 |  | Q8 |  | 8 |  | Lake 8 |  | 8 |  | Lake 8 |  | 8 |  | D8 |  | 8 |  | D8 |  | 8
Q9 | 9 |  |  | Q9 | 9 |  |  | L9 | 9 |  |  | L9 | 9 |  |  | D9 | 9 |  |  | D9 | 9
L1 |  | 10 |  | D1 |  | 10 |  | D1 |  | 10 |  | Q1 |  | 10 |  | L1 |  | 10 |  | Q1 |  | 10
L2 | 11 |  |  | D2 | 11 |  |  | D2 | 11 |  |  | Q2 | 11 |  |  | L2 | 11 |  |  | Q2 | 11
Lake 3 |  | 12 |  | D3 |  | 12 |  | D3 |  | 12 |  | [NAME] |  | 12 |  | Lake 3 |  | 12 |  | [NAME] |  | 12
[NAME] | 13 |  |  | [NAME] | 13 |  |  | [NAME] | 13 |  |  | Q4 | 13 |  |  | [NAME] | 13 |  |  | Q4 | 13
L5 |  | 14 |  | D5 |  | 14 |  | D5 |  | 14 |  | Q5 |  | 14 |  | L5 |  | 14 |  | Q5 |  | 14
L6 | 15 |  |  | D6 | 15 |  |  | D6 | 15 |  |  | Q6 | 15 |  |  | L6 | 15 |  |  | Q6 | 15
L7 |  | 16 |  | [NAME] |  | 16 |  | [NAME] |  | 16 |  | [NAME] |  | 16 |  | L7 |  | 16 |  | [NAME] |  | 16
Lake 8 | 17 |  |  | D8 | 17 |  |  | D8 | 17 |  |  | Q8 | 17 |  |  | Lake 8 | 17 |  |  | Q8 | 17
L9 |  | 18 |  | D9 |  | 18 |  | D9 |  | 18 |  | Q9 |  | 18 |  | L9 |  | 18 |  | Q9 |  | 18
D1 | 19 |  |  | L1 | 19 |  |  | Q1 | 19 |  |  | D1 | 19 |  |  | Q1 | 19 |  |  | L1 | 19
D2 |  | 20 |  | L2 |  | 20 |  | Q2 |  | 20 |  | D2 |  | 20 |  | Q2 |  | 20 |  | L2 |  | 20
D3 | 21 |  |  | Lake 3 | 21 |  |  | [NAME] | 21 |  |  | D3 | 21 |  |  | [NAME] | 21 |  |  | Lake 3 | 21
[NAME] |  | 22 |  | [NAME] |  | 22 |  | Q4 |  | 22 |  | [NAME] |  | 22 |  | Q4 |  | 22 |  | [NAME] |  | 22
D5 | 23 |  |  | L5 | 23 |  |  | Q5 | 23 |  |  | D5 | 23 |  |  | Q5 | 23 |  |  | L5 | 23
D6 |  | 24 |  | L6 |  | 24 |  | Q6 |  | 24 |  | D6 |  | 24 |  | Q6 |  | 24 |  | L6 |  | 24
[NAME] | 25 |  |  | L7 | 25 |  |  | [NAME] | 25 |  |  | [NAME] | 25 |  |  | [NAME] | 25 |  |  | L7 | 25
D8 |  | 26 |  | Lake 8 |  | 26 |  | Q8 |  | 26 |  | D8 |  | 26 |  | Q8 |  | 26 |  | Lake 8 |  | 26
D9 | 27 |  |  | L9 | 27 |  |  | Q9 | 27 |  |  | D9 | 27 |  |  | Q9 | 27 |  |  | L9 | 27
Spreadsheet: 835565d1688657664-index-match-with-filters-sample-finder-snapshot
Sheet: CALCIUM

Last name | First name | Birth date | Sex | Sample | Test | Analyser | Result datetime | Result | Unit | Request department | Request physician code
PATIENT 1 | TEST | 2000-01-01 00:00:00 | M | 123456 | CALCIUM | ANALYSER 1 | 2023-07-01 12:00:00 | 2.5 | MMOL/l | A&E | DR TEST
PATIENT 2 | TEST | 2000-01-02 00:00:00 | M | 123457 | CALCIUM | ANALYSER 2 | 2023-07-02 12:00:00 | 2.6 | MMOL/l | A&E | DR TEST
PATIENT 3 | TEST | 2000-01-03 00:00:00 | M | 123458 | CALCIUM | ANALYSER 3 | 2023-07-03 12:00:00 | 2 | MMOL/l | GP | DR TEST
PATIENT 4 | TEST | 2000-01-04 00:00:00 | M | 123459 | CALCIUM | ANALYSER 4 | 2023-07-04 12:00:00 | 2.9 | MMOL/l | GP | DR TEST
PATIENT 5 | TEST | 2000-01-05 00:00:00 | M | 123460 | CALCIUM | ANALYSER 5 | 2023-07-05 12:00:00 | 3.1 | MMOL/l | A&E | DR TEST
Spreadsheet: 606349d1547576859-wrapped-sumproduct-function-wrapped-sumproduct-formula
Sheet: TestData

Total |  |  |  | Notes
Total1 | GrandTotal |  |  | The sumproduct function in A8 works well
1/12 | 22/24 |  |  | However cell B8 misfunctions because the length of characters is outside the range specified in the formula
8/12 | 22/24
7/12 | 21/24
9/12 | 2/24
3/12 | 17/24
Desired Result
Total
Total1 | GrandTotal
1/12 | 22/24
8/12 | 22/24
7/12 | 21/24
9/12 | 2/24
3/12 | 17/24
 | 87/120 | <-would like to achieve the 87/120 with a formula
Spreadsheet: 1824e6b7-9497-499e-9e91-8a5428eba947
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5676.0 Business Indicators, Australia
 | TABLE 23. INVENTORIES/SALES RATIO, Current prices, Original
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Inventories to sales ratio ;  Total (State) ;  Accommodation and food services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531409K | 1999-03-01 00:00:00 | 2010-09-01 00:00:00 | 47 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Electricity, gas, water and waste services ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531308X | 2001-03-01 00:00:00 | 2010-09-01 00:00:00 | 39 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Manufacturing ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531281K | 1984-06-01 00:00:00 | 2010-09-01 00:00:00 | 106 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  [NAME] ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531254C | 2001-03-01 00:00:00 | 2010-09-01 00:00:00 | 39 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Retail trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531382W | 1999-03-01 00:00:00 | 2010-09-01 00:00:00 | 47 | Quotient | RATIO | Quarter | 3
Inventories to sales ratio ;  Total (State) ;  Wholesale trade ;  Current Price ;  TOTAL (SCP_SCOPE) ; |  |  | Original | A3531355R | 1989-06-01 00:00:00 | 2010-09-01 00:00:00 | 86 | Quotient | RATIO | Quarter | 3
© Commonwealth of Australia  2010
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: ART

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | [NAME] | 1 | X | 1
 | 3D Computer Animation  Certificate | 1 | X | 1
 | Computer Assisted Graphic Design Certificate | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | ART 100 | 1 | X | 1 | 2 | 1 | 2 | 1 | 2 | 1
1 | ART 102 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | ART 105 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | ART 119 | 1
1 | ART 120X4 | 1 | X | 1 | X | 1 | 2 | 1 | 2 | 1
1 | ART 124X4 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | ART 126X4 | 1 | X | 1 | X | 1 | 3 | 1 | 3 | 1
1 | ART 132X4 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
1 | ART 175X4 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
2 | ART 200X4 | 1 | X | 1 | X | 1 | X | 1 | 1 | 1
5 | ART 202X4 | 1 | X | 1
5 | ART 204X4 | 1 | X | 1
5 | ART 247X4 | 1 | X | 1
5 | ART 275X4 | 1 | X | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 28917d1223485909-find-replace-add-delete-data-from-ui-forecast
Sheet: Input

 |  |  |  |  | *Line Item (Exp) | Month/Day/Year | Expenses ($) |  | # of Expenses
1 | Project Name |  |  | 5 | Subcontractor | 2010-01-15 00:00:00 | 5000 |  | 1
 |  | Month/Day/Year |  |  |  |  |  |  | Number of Date
2 | [NAME] | 2010-01-01 00:00:00 |  |  |  |  |  |  | Errors in 5
 | Production Begins | 2011-01-01 00:00:00 |  |  |  |  |  |  | 0
 | Installation Begins | 2012-01-01 00:00:00
 | Project Completion | 2013-01-01 00:00:00
 |  | $
3 | Design Payment Total | 12000 |  | 6 | *Line Item (Inc) | Month/Day/Year | Income ($) |  | # of Income ($)
 | Production Payment Total | 25000 |  |  | Milestone 1 Payment | 2010-03-10 00:00:00 | 7500 |  | 1
 | Installation/Closeout Total | 15000
 |  |  |  |  |  |  |  |  | Number of Date
 |  | Schedule of Income ($) |  |  |  |  |  |  | Errors in 6
4 | Design Payment Total |  |  |  |  |  |  |  | 0
 | Production Payment Total
 | Installation/Closeout Total
 |  | Time (Days)
 | Design | 365
 | Production | 365
 | Installation/Closeout | 366
 | Total | 1096
 |  | Time (As % of Project)
 | Design | 0.333029197080292
 | Production | 0.333029197080292
 | Installation/Closeout | 0.3339416058394161
 | Total | 1
 | Total Design Exp Items | Total Production Exp Items |  |  | Total Install/Cout Exp Items
 | 5000 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0 |  | # of Exp. In time
 | 0 | 0 |  |  | 0 |  | 1
 | 0 | 0 |  |  | 0 |  | 0
 | 0 | 0 |  |  | 0 |  | 0
 | 5000 | 0 |  |  | 0 |  | 1
 | Total Design Rev Items | Total Production Rev Items |  |  | Total Install/Cout Rev Items
 | 7500 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0
 | 0 | 0 |  |  | 0 |  | # of Rev. In time
 | 0 | 0 |  |  | 0 |  | 1
 | 0 | 0 |  |  | 0 |  | 0
 | 0 | 0 |  |  | 0 |  | 0
 | 7500 | 0 |  |  | 0 |  | 1
Spreadsheet: 682992d1592416388-cell-range-not-changing-when-rows-columns-inserted-excel-example
Sheet: Sheet4

mountain
placement | b martin | [NAME] | c checker | j charlton | b martin | r burton | j charlton | j greaves |  | S hernandez
 |  |  |  |  |  |  |  |  |  | b Martin
 |  |  |  |  |  |  |  |  |  | C Checker
 |  |  |  |  |  |  |  |  |  | J charlton
 |  |  |  |  |  |  |  |  |  | r burton
 |  |  |  |  |  |  |  |  |  | j greaves
Lone star
placement | a apple | b goat | b martin | r burton | j greaves | a apple | [NAME] | m maria |  | a apple
 |  |  |  |  |  |  |  |  |  | b goat
 |  |  |  |  |  |  |  |  |  | b martin
 |  |  |  |  |  |  |  |  |  | r burton
 |  |  |  |  |  |  |  |  |  | j greaves
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | m maria
Big Six
placement | m maria | c king | [NAME] | [NAME] | r burton | c checker | [NAME] | a apple |  | m maria
 |  |  |  |  |  |  |  |  |  | c king
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | r burton
 |  |  |  |  |  |  |  |  |  | c checker
 |  |  |  |  |  |  |  |  |  | a apple
Spreadsheet: 204478d1357550234-how-to-select-data-of-the-next-cell-after-some-condition-forum_eg
Sheet: Sheet2

052N |  | 052N | 2012-12-17 09:38:00
2012-12-17 09:38:00 |  | 052S | 2012-12-06 13:36:00
2012-12-17 09:39:00 |  | 126E | 2012-12-12 10:28:00
2012-12-17 09:54:00
052S
2012-12-06 13:36:00
2012-12-10 11:37:00
2012-12-10 11:38:00
2012-12-11 01:32:00
2012-12-11 01:33:00
126E
2012-12-12 10:28:00
2012-12-14 14:53:00
2012-12-14 14:54:00