tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: steven_merriss__39342__4_06act
Sheet: EPEData

 | 37076.10208333333
 | NEWMAN 1 ,MANL, 54  , 65  , 37  , 78  ,  0  ,1
 | NEWMAN 2 ,ECON, 71  , 77  , 37  , 83  ,  7  ,1
 | NEWMAN 3 ,BASE, 37  ,100  , 37  ,103  , 60  ,1
 | NEWMN/GT1,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NEWMN/GT2,UNAV,  0  , 60  , 18  , 60  ,  0  ,1
 | NM/GT1+ST,ECON, 96  ,100  , 61  ,107  ,  4  ,1
 | NM/GT2+ST,UNAV,  0  ,100  , 66  ,107  ,  0  ,1
 | NEWMAN 4 ,UNAV,  0  ,205  , 86  ,214  ,  0  ,1
 | NEWMAN   ,, 259 ,  342,  172, 371 ,  70 ,
 | COPPER   ,ECON, 62  , 69  , 15  , 69  ,  8  ,1
 | RIOGRAN 6,MANL, 39  , 40  , 28  , 48  ,  0  ,1
 | RIOGRAN 7,MANL, 33  , 32  , 30  , 49  ,  0  ,1
 | RIOGRAN 8,MANL,100  ,100  , 50  ,151  ,  0  ,1
 | RIOGRANDE,, 171 ,  172,  108, 248 ,   0 ,
 | PALOVERDE,MANL,398  ,398  ,398  ,600  ,  0  ,1
 | FOURCRNRS,MANL,105  ,105  ,105  ,104  ,  0  ,1
 | LAMBDA, 48.73,  686,  692,  101,    2,    0,28466,224
 | APS     ,STRT    ,FC,  ,   1,   1
 | IID     ,EXCS    ,FC,  ,  50,  50
 | IID     ,FIRM    ,PV,  , 100, 100
 | LDWP    ,ECON    ,PV,  ,  80,  80
 | PGT     ,LOSS    ,PV,  ,  -1,  -1
 | PNM     ,CNTG    ,LC,  ,  11,  11
 | PNM     ,LOSS    ,LC,  ,   2,   2
 | SPS     ,FIRM    ,WM,  ,-103,-103
 | SRP     ,FIRM    ,ED,  ,  25,  25
 | SRP     ,LOSS    ,PV,  ,   1,   1
 | TNP     ,FIRM    ,PV,  ,  25,  25
 | TNP     ,LOSS    ,PV,  ,  -5,  -5
 | WAPA    ,PASS    ,WM,HO,  -1,  -1
Spreadsheet: 156843d1337514871-help-i-need-to-input-date-range-and-1-criteria-then-sumup-sample
Sheet: Sheet1

Buy = 1 "Price x 1.00295" | -1.00295
Sell = 0 "Price x 0.99205" | -0.99205
Date | Stock Code | Share | Price | Buy/Sell | Total |  | From Date | To Date | # | Stock Code | Total Shares | Total Value | Ave. Price | Market Price | Gain / Loss | % Gain / Loss | Trade Value
2011-10-24 00:00:00 | PFP | 50 | 1017 | 1 |  |  | 2012-02-26 00:00:00 | 2012-12-12 00:00:00 | 1 | EDC |  |  |  | 5.75
2011-10-26 00:00:00 | MEG | 11000 | 1.92 | 1 |  |  | 2012-02-02 00:00:00 | 2012-12-12 00:00:00 | 2 | JFC |  |  |  | 105.2
2011-11-02 00:00:00 | PFP | 60 | 1017 | 1 |  |  |  |  | 3 | PFP |  |  |  | 1025
2011-11-03 00:00:00 | MEG | -11000 | 1.84 |  |  |  |  |  | 4 | TEL |  |  |  | 2370
2011-11-03 00:00:00 | PFP | 70 | 1017 | 1 |  |  |  |  | 5 | PXP
2011-11-03 00:00:00 | PFP | 10 | 1017 | 1 |  |  |  |  | 6 | CHIB
2011-12-06 00:00:00 | PFP | 15 | 1014 | 1 |  |  |  |  | 7 | AP
2012-02-07 00:00:00 | AP | 30 | 30.25 | 1 |  |  |  |  | 8 | MEG
2012-02-13 00:00:00 | AP | 25 | 29.25 |  |  |  |  |  | 9
2012-02-13 00:00:00 | AP | -1500 | 29.1 |  |  |  |  |  | 10
2012-02-21 00:00:00 | PFP | 50 | 1030 | 1 |  |  |  |  | 11
2012-02-22 00:00:00 | PFP | 50 | 1038 | 1 |  |  |  |  | 12
2012-02-22 00:00:00 | PFP | 290 | 1038 | 1
2012-02-23 00:00:00 | PFP | 100 | 1035 | 1
2012-02-23 00:00:00 | PFP | 50 | 1035 | 1
2012-02-24 00:00:00 | PFP | 61 | 1035 | 1
2012-02-24 00:00:00 | PFP | 6 | 1035 | 1
2012-02-27 00:00:00 | EDC | 3700 | 4.89 | 1
2012-03-01 00:00:00 | PFP | 20 | 1029 | 1
2012-03-02 00:00:00 | EDC | 5000 | 5.3 | 1
2012-03-02 00:00:00 | EDC | 8000 | 5.27 | 1
2012-03-02 00:00:00 | EDC | 4000 | 5.22 | 1
2012-03-09 00:00:00 | PFP | 95 | 1023 | 1
2012-03-19 00:00:00 | EDC | 17300 | 5.8 | 1
2012-03-19 00:00:00 | EDC | 8600 | 5.8 | 1
2012-04-27 00:00:00 | PXP | 2600 | 30 | 1
2012-05-04 00:00:00 | CHIB | 30 | 520.5 | 1
2012-05-16 00:00:00 | JFC | 200 | 100 | 1
2012-05-17 00:00:00 | PFP | 20 | 1020 | 1
2012-05-18 00:00:00 | PXP | -2600 | 32.9
2012-05-18 00:00:00 | CHIB | -30 | 550
2012-05-18 00:00:00 | TEL | 20 | 2380 | 1
2012-05-15 00:00:00 | TEL | 20 | 2360 | 1
Spreadsheet: 38101d1236204631-circular-referencing-excel-coursework
Sheet: Customer

RefNum | Customer Name | Street Address | PostCode | Town/City | Country | Balance
ABI001 | Art Abiram | 115 Carnaby Way | 20176 | Vancouver | Canada | 0
BRA001 | [NAME] | 72 green way | C012 8KS | Colchester | UK | 0
DIX001 | [NAME] | The Manor |  |  |  | 0
EZR001 | [NAME] |  |  |  |  | 0
GER001 | [NAME] |  |  |  |  | 0
HIL001 | Kris Hilary |  |  |  |  | 0
RIC001 | [NAME] |  |  |  |  | 0
VIN001 | [NAME] | 30 Victoria Park | BS162HJ | Bristol | UK | 0
Spreadsheet: 93107d1292605284-add-a-check-box-and-have-weight-added-when-box-is-checked-hiking-checklist
Sheet: Sheet1

Hiking Checklist
Date(s) and Time(s):
Mountain(s):
Trail Description:
Driving Directions:
People:
 | Gear List |  | Weight
 |  |  | Lbs | Oz
 | ¨     Cold weather gear (Gloves, hat, sweater, thermals, ect)
 |  | 0
 |  | 1
 |  | 1
 |  | 0 |  | 3.5
 |  | 0
 |  | 0 | 2 | 10
 |  | 0 | 3 | 8
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1 |  | 2
 |  | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 1 | 5 | 12
 |  |  | Total Weight
 |  |  | 12 | 3.5
Spreadsheet: 221392d1363534173-time-calculations-238-man-hour-calculator
Sheet: Sheet1

 |  | # of Crew | AM
 |  | 3 | PM
Start Time | AM/PM | End Time | AM/PM | Total Hours
730 | AM | 900 | AM
Start Time | AM/PM | End Time | AM/PM | Total Hours
905 | AM | 1100 | AM
Start Time | AM/PM | End Time | AM/PM | Total Hours
1103 | AM | 1210 | PM
Start Time | AM/PM | End Time | AM/PM | Total Hours
1250 | PM | 230 | PM
Spreadsheet: 749979d1633129465-find-a-row-of-info-by-using-keywords-display-rows-of-data-based-on-indexing-keywords-rgrohman-
Sheet: Sheet2

Company | Start Date | End Date
Alwine Security | 2020-09-11 00:00:00 | 2025-09-10 00:00:00
Allied Roofing | 2020-09-25 00:00:00 | 2025-09-24 00:00:00
[NAME] | 2020-11-18 00:00:00 | 2025-11-17 00:00:00
A+ Seal Coating | 2020-08-27 00:00:00 | 2025-08-26 00:00:00
Berkshire | 2020-06-25 00:00:00 | 2025-06-24 00:00:00
Capital Painting | 2020-05-26 00:00:00 | 2023-05-25 00:00:00
[NAME] | 2020-05-29 00:00:00 | 2023-05-28 00:00:00
Certipro | 2020-09-23 00:00:00 | 2025-09-22 00:00:00
[NAME] | 2021-03-05 00:00:00 | 2026-03-04 00:00:00
D&T Mechanical Contractor | 2020-08-19 00:00:00 | 2025-08-18 00:00:00
Diamond Automatic Sprinklers | 2020-07-16 00:00:00 | 2025-07-15 00:00:00
Dominion Elevator | 2020-09-18 00:00:00 | 2025-09-17 00:00:00
Dynamech | 2020-07-28 00:00:00 | 2026-07-27 00:00:00
Enginuity | 2020-02-14 00:00:00 | 2025-02-13 00:00:00
Facility Concierge Services | 2020-05-08 00:00:00 | 2023-05-07 00:00:00
Fast Signs (Harrisburg) | 2020-06-15 00:00:00 | 2025-06-14 00:00:00
Full Blast Pressure Washing | 2021-07-29 00:00:00 | 2026-07-28 00:00:00
Hershocks | 2020-08-19 00:00:00 | 2025-08-18 00:00:00
[NAME] | 2021-01-01 00:00:00 | 2026-12-31 00:00:00
Kint | 2020-09-18 00:00:00 | 2025-09-17 00:00:00
LowV | 2020-08-18 00:00:00 | 2025-08-17 00:00:00
NRG | 2020-11-09 00:00:00 | 2025-11-08 00:00:00
OAESYS | 2020-06-23 00:00:00 | 2025-06-22 00:00:00
[NAME] | 2021-06-01 00:00:00 | 2026-05-31 00:00:00
Overhead door | 2020-03-03 00:00:00 | 2023-03-02 00:00:00
Penn Power Systems | 2020-10-22 00:00:00 | 2025-10-21 00:00:00
Pyramid | 2020-08-28 00:00:00 | 2025-08-27 00:00:00
ServiceMaster | 2020-09-18 00:00:00 | 2025-09-17 00:00:00
Sheffield | 2020-05-08 00:00:00 | 2023-05-07 00:00:00
S&L Mechanical | 2020-08-14 00:00:00 | 2025-08-13 00:00:00
[NAME] | 2020-02-24 00:00:00 | 2023-02-23 00:00:00
TruGreen | 2021-02-16 00:00:00 | 2026-02-15 00:00:00
[NAME] | 2020-08-01 00:00:00 | 2025-01-31 00:00:00
[NAME] | 2020-04-01 00:00:00 | 2023-03-31 00:00:00
Weavers [NAME] | 2020-10-28 00:00:00 | 2025-10-27 00:00:00
WTBD | 2020-02-24 00:00:00 | 2023-02-23 00:00:00
Spreadsheet: 866815d1713737920-the-problem-of-cumulative-sum-of-merging-units-4-21-solution
Sheet: Sheet13

DATE | LIST | QTY | TOTAL | TOTAL
2024-04-20 00:00:00 | A | 424 | 468
 | A | 44
2024-04-20 00:00:00 | B | 51 | 9437
 | B | 424
 | B | 4411
 | B | 4551
2024-04-21 00:00:00 | A | 444 | 1499
 | A | 532
 | A | 55
2024-04-21 00:00:00 | B | 35 | 16188
 | B | 6363
 | B | 353
Spreadsheet: 877071d1723739473-how-do-i-reference-the-results-of-formulas-multiple-cells-cell-1-or-cell-2-or-cell-3-amateurexceller-submission-for-question
Sheet: Sheet1

Project EVM Calculations
Total Approved Project Budget = BAC | Value of Deliverables Planned by this Point = PV | Value of [NAME] by this Point | Actual Costs Incurred to Date = AC | Estimate to Completion (Time) = ETC
Budget at Completion (BAC) | Planned Value (PV) | Earned Value (EV) | Actual Cost (AC) | Estimate to Completion = ETC
Enter number here | Enter number here | Enter number here | Enter number here | Enter number here
EVM Calculations | [NAME] | Result |  | Interpretation
Cost Variance (CV) | CV = EV-AC |  |  | Positive:  Under Budget
 |  |  |  | Negative:  Over Budget
Cost Performance  Index (CPI) | CPI = EV/AC |  |  | CPI > 1 More Productive than Expected
 |  |  |  | CPI < 1 Less Productive than Expected
Variance at Completion (VAC) | VAC = BAC-EAC |  |  | Difference Between BAC and Final Projected Costs
Estimate at Completion (EAC) | EAC = BAC/CPI |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + ETC (ETC is Estimated) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV) |  |  | Project Cost if Current Trend Unchanged
Estimate at Completion (EAC) | EAC = AC + (BAC-EV)/(CPI*SPI) |  |  | Project Cost if Current Trend Unchanged
Remaining Work | Remaining Work = BAC - EV
Remaining Budget | Remaining Budget = BAC-AC
To-Complete Performance Index | TCPI = (BAC – EV) / (BAC – AC) |  |  | TCPI > 1 Over Budget
 |  |  |  | TCPI < 1 Under Budget
[NAME] (SV) | SV = EV-PV |  |  | Positive:  Ahead of Schedule
 |  |  |  | Negative:  Behind Schedule
Schedule Performance Index (SPI) | SPI = EV/PV |  |  | SPI > 1 Ahead of Schedule
 |  |  |  | SPI < 1 Behind Schedule
Spreadsheet: 861539d1709411330-tracking-last-30-days-blood-readings
Sheet: Feb24

2024-02-01 00:00:00
date | day | time | Sys | [NAME] | Pul | Sugar
2024-02-01 00:00:00 |  | 10:33:00 | 130 | 88 | 62 | 173
2024-02-02 00:00:00 |  | 10:47:00 | 136 | 80 | 60 | 203
2024-02-03 00:00:00 |  | 10:09:00 | 144 | 72 | 58 | 216
2024-02-04 00:00:00 |  | 10:11:00 | 131 | 76 | 65 | 163
2024-02-05 00:00:00 |  | 10:15:00 | 128 | 72 | 61 | 155
2024-02-06 00:00:00 |  | 10:15:00 | 130 | 76 | 60 | 178
2024-02-07 00:00:00 |  | 10:50:00 | 126 | 78 | 59 | 181
2024-02-08 00:00:00 |  | 10:50:00 | 143 | 81 | 57 | 174
2024-02-09 00:00:00 |  | 10:03:00 | 128 | 79 | 59 | 175
2024-02-10 00:00:00 |  | 10:19:00 | 122 | 77 | 62 | 166
2024-02-11 00:00:00 |  | 10:11:00 | 128 | 80 | 56 | 172
2024-02-12 00:00:00 |  | 10:18:00 | 135 | 74 | 59 | 180
2024-02-13 00:00:00 |  | 10:33:00 | 135 | 72 | 63 | 180
2024-02-14 00:00:00 |  | 10:20:00 | 147 | 76 | 66 | 189
2024-02-15 00:00:00 |  | 11:22:00 | 129 | 77 | 56 | 160
2024-02-16 00:00:00 |  | 10:29:00 | 131 | 78 | 60 | 225
2024-02-17 00:00:00 |  | 10:09:00 | 129 | 80 | 56 | 185
2024-02-18 00:00:00
2024-02-19 00:00:00 |  | 10:12:00 | 140 | 81 | 56 | 174
2024-02-20 00:00:00 |  | 10:12:00 | 125 | 81 | 64 | 192
2024-02-21 00:00:00 |  | 11:32:00 | 120 | 75 | 62 | 169
2024-02-22 00:00:00 |  | 12:00:00 | 101 | 78 | 67 | 148
2024-02-23 00:00:00 |  | 10:32:00 | 115 | 73 | 63 | 167
2024-02-24 00:00:00 |  | 10:10:00 | 126 | 76 | 60 | 195
2024-02-25 00:00:00 |  | 10:38:00 | 118 | 74 | 62 | 170
2024-02-26 00:00:00 |  | 10:57:00 | 128 | 81 | 64 | 195
2024-02-27 00:00:00 |  | 10:35:00 | 132 | 75 | 63 | 157
2024-02-28 00:00:00 |  | 11:31:00 | 136 | 84 | 63 | 200
2024-02-29 00:00:00 |  | 10:57:00 | 116 | 74 | 68 | 176
Spreadsheet: 692841d1598605086-multiple-spreadsheet-values-required-and-data-returned-over-48hrs-excel-forum-1-sumproduct-new-model
Sheet: Rolling 17 Weeks

Emp No | First Name | Last Name | Work Location | Week 1 | Week 2 | Week 3 | Average
1 | [NAME] | Smith
2 | [NAME] | Jones
3 | Bobbi | [NAME]
4 | [NAME] | Singh
5 | [NAME] | [NAME]
6 | Bertie | Davies
7 | Obi | Stanley
8 | Bobba | [NAME]
9 | [NAME] | Bloggs
Spreadsheet: 850664d1701077055-formula-to-pull-filtered-list-from-another-sheet-based-on-search-box-calculetor-jacc
Sheet: Search

 |  |  |  |  |  |  | https://www.excelforum.com/excel-formulas-and-functions/1415736-excel-formula.html
 |  |  | front
 |  | Item Name | Brand | Company1 | Price1 | Company2 | Price2 | Company3 | Price3
False
False
False
False
False
7
False
False
False
11
12
13
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
False
Spreadsheet: 05a80bc4-5535-48d5-899e-25d2b3abd1f7
Sheet: SWCC - Central Decatur

Southwestern Community College Career Academies
2012-2013 Central Decatur Career Academy
Course Number | Course Title | Schedule | College Credit Hours | Contact Minutes | SCED Code           Replace 'uu' with sequencing | Comments
Welding Technology
Year 1 - Fall Semester
WEL 114 | Introduction to Fabrication | M-F 8-10 am | 3 credits | 5400 | 13208C075uu
WEL 111 | Welding Blueprint Reading | M-F 8-10 am | 3 credits | 5400 | 13208C075uu
Year 2 - Spring Semester
WEL 139 | Introduction to Oxy, Cutting, & Brazing | M-F 8-10 am | 3 credits | 5400 | 13208C075uu
WEL 162 | Introduction to Shielded Metal Arc Welding | M-F 8-10 am | 3 credits | 5400 | 13208C075uu
Spreadsheet: 146879d1332399965-indexing-numbers-according-to-size-and-number-extract-numbered-list-to-column
Sheet: another example

Account | Entries | helper: finds new start row of each account |  | result
Microsoft | 9 | 1 |  | Microsoft
Nike | 4 | 10 |  | Microsoft
Adidas | 12 | 14 |  | Microsoft
[NAME] | 3 | 26 |  | Microsoft
Oakley | 2 | 29 |  | Microsoft
martin | 10 | 31 |  | Microsoft
oscar | 3 | 41 |  | Microsoft
 |  | 44 |  | Microsoft
 |  | 44 |  | Microsoft
 |  | 44 |  | Nike
 |  | 44 |  | Nike
 |  | 44 |  | Nike
 |  | 44 |  | Nike
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  | 44 |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | Adidas
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | [NAME]
 |  |  |  | Oakley
 |  |  |  | Oakley
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | martin
 |  |  |  | oscar
 |  |  |  | oscar
 |  |  |  | oscar
Spreadsheet: 83546d1283511510-averages-formula-rainfall
Sheet: Modified 2

TIME (min) | TIME (sec) | RAINFALL ([NAME]) |  |  |  |  |  |  |  | Recorded Rainfall |  |  | Time based on recorded rainfall
 |  |  |  |  |  |  |  |  |  | INPUT |  |  | RESULT
 |  |  |  |  |  |  |  |  |  | 135 |  |  | 19.81818181818182
 |  |  |  | 1min | 60 |  |  |  | Input
 |  |  |  | Diff in Min | Diff in Sec | Diff in MM | MM/Sec |  | Diff in MM
5 | 300 | 253
 |  |  |  | 1 | 60 | 17 | 3.529411764705882 |  | 118 | 416.4705882352941 | 716.4705882352941 |  | 11.94117647058824
6 | 360 | 236
 |  |  |  | 4 | 240 | 47 | 5.106382978723405 |  | 101 | 515.7446808510639 | 875.7446808510639 |  | 14.59574468085106
10 | 600 | 189
 |  |  |  | 10 | 600 | 55 | 10.90909090909091 |  | 54 | 589.090909090909 | 1189.090909090909 |  | 19.81818181818182
20 | 1200 | 134
Sorry I still don't understand what is what, is it saying that after 5min there was 253mm of rain in the gauge, if so, why is it that after 6min there is 236mm in the
gauge, after 10min,189mm and after 20min there is 134mm???  How can there be getting less in the gauge???
Any way I don't know if this is what you are after or not, if it is then what rate did you want to work with outside these parameters, e.g. if the input was 100mm or
400mm??
I have left all the working logic so you can see how it all links together, if this is what you are after then the formula can be made to incorporate
all of the individual formulas, therefore removing every thing within the red border, but this would be a fair bit of effort,
so me not knowing if it is correct and if it is critical to have it consolidated I wouldn't bother.
Spreadsheet: 196459d1354019188-groupin-multiple-rows-into-multiple-groups-groupinghelp
Sheet: Sheet1

Order planned, not entered
Order entered, booking confirmation pending
Booking confirmed
Order shipped
billing block
Location | Customer PO no. | order no.
London | 1 | A1
London | 2 | A2
London | 3 | A3
London | 4 | A4
Berlin | 1 | A5
Berlin | 2 | A6
Berlin | 3 | A7
Berlin | 4 | A8
Berlin | 5 | A9
Berlin | 6 | A10
Berlin | 7 | A11
Berlin | 8 | A12
Madrid | 9 | A13
Madrid | 10 | A14
Madrid | 11 | A15
Madrid | 12 | A16
Madrid | 13 | A17
Tokyo | 14 | A18
Tokyo | 15 | A19
Tokyo | 16 | A20
Tokyo | 17 | A21
Beijing | 18 | A22
Beijing | 19 | A23
Beijing | 20 | A24
Beijing | 21 | A25
Beijing | 22 | A26
Beijing | 23 | A27
Beijing | 24 | A28
Beijing | 25 | A29
New York | 26 | A30
New York | 27 | A31
New York | 28 | A32
New York | 29 | A33
New York | 30 | A34
New York | 31 | [NAME]
Spreadsheet: 5375ca64-7c4a-4ac8-9682-34fdade405ac
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
43583872 | 2014-10-14 22:51:58 | ALLIES | 1 | 5 | 3 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43584090 | 2014-10-14 23:05:57 | AXIS | 0 | 4 | 5 | 752090 | lespieuch | 6160 | western | 1944-06-06 | 1944-06-06 | Sword Beach | Sword Beach
43729814 | 2014-10-25 11:30:23 | ALLIES | 0 | 4 | 7 | 240776 | DoctorSchizzo | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
43730246 | 2014-10-25 12:03:51 | AXIS | 0 | 3 | 7 | 240776 | DoctorSchizzo | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
Spreadsheet: 138685d1327834139-calculate-total-sums-from-multiple-text-entries-example-monthly-expenses-tracking
Sheet: January Balance Sheet

 | Date | Monthly Debit Card Expenditures |  |  |  | Total
 | 2012-01-04 00:00:00 | Groceries |  |  | (Cub Foods) | 103.57
 | 2012-01-05 00:00:00 | Gas |  |  | (Car) | 49
 | 2012-01-05 00:00:00 | Groceries |  |  | (Target) | 72.45
 | 2012-01-06 00:00:00 | Dining Out |  |  | (Café A) | 5.5
 | 2012-01-06 00:00:00 | Dining Out |  |  | ([NAME]'s Café) | 26.23
 | 2012-01-07 00:00:00 | Gas |  |  | (Van) | 45
 | 2012-01-10 00:00:00 | Groceries |  |  | (Rainbow Foods) | 33.03
 | 2012-01-11 00:00:00 | Groceries |  |  | (Target) | 28.47
 | 2012-01-11 00:00:00 | Health/Home/Beauty |  |  | (Target) | 27.99 |  | Monthly Expenditures
 | 2012-01-11 00:00:00 | Cash |  |  | (Gas Station) | 25 |  | Item |  | Actual
 | 2012-01-12 00:00:00 | Gas |  |  | (Car) | 46.25 |  | Gas |  | 140.25
 | 2012-01-13 00:00:00 | Dining Out |  |  | ([NAME]'s Café) | 46 |  | Groceries |  | 237.52
 | 2012-01-14 00:00:00 | Health/Home/Beauty |  |  | (Target) | 42.78 |  | Health/Home/Beauty |  | 147.77
 | 2012-01-20 00:00:00 | Health/Home/Beauty |  |  | (Marshalls) | 77 |  | Cash |  | 25
 |  |  |  |  |  |  |  | Dining Out |  | 77.73
 |  |  |  |  |  |  |  | TOTAL |  | 628.27
 |  |  |  |  | Total: | 628.27
Spreadsheet: 04e35715-b9b1-4c62-be73-df9ed5dcc97b
Sheet: Page 2

 |  | Purchasing Card Cycle Transaction Log
PURCHASING SERVICES |  |  |  |  |  |  |  |  |  | Page 2
[1] Cardholder: |  | [2] Dept/Unit: | [3] Card Number: xxxx-xxxx-xxxx- |  |  |  |  | [4] Purchasing Cycle Date:
[5] | [6] | [7] | [8] | [9] | [10] | [11] | [12] | [13] | [14] | [15]
Trans Date | Supplier/Vendor | Description Goods/Services Ordered | Sub-Total | Cost of Goods  (Use Tax applicable) | Use/ | Sales Tax | Use Tax | Shipping Costs | Total Cost | Travel TA/TP Document Number
 |  | /Public Purpose : |  |  | Sales Tax |  | Rate: 5.6%
 |  |  |  |  | Exempt
 |  | Purchasing Card Transaction Totals:
With my signature below, I certify that I, as the cardholder, personally made all purchases identified on this Purchasing Card Cycle Transaction Log, have not received or requested reimbursement for these same transactions, that they serve the public purpose indicated to further the goals of the University, were conducted in accordance with the policies and procedures set forth by the University and the Arizona Board of Regents and I acknowledge understanding of ARS §35-301, specifically, that a public officer or other person, including justices of the peace and constables, charged with the receipt, safekeeping, transfer or disbursement of public money is guilty of a class 4 felony who without authority of law, appropriates it, or any portion thereof, to his own use, or to the use of another.
[16] Cardholder Signature: |  |  |  |  |  |  |  |  |  | Date:
With my signature below, I certify that, to the best of my knowledge, the items purchased on this claim are correct, serve a public purpose and that no duplicate reimbursement payments have been made.
[17] Dept/Unit Fiscal Liaison Signature:                                                                                                                        *Approval and reconciliation shall not be completed by the Cardholder. |  |  |  |  |  |  |  |  |  | Date:
Spreadsheet: 00f6d122-f9a8-4390-aea5-c6048c21631c
Sheet: Sheet1

TABLE 1 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
CONTINUING EDUCATION ENROLLMENT
UNIVERSITY OF HAWAI‘I, BY CAMPUS
SPRING 2010
 | CAMPUS |  |  |  | TOTAL
 |  |  |  |  | No. | V%
 |  | TOTAL 1/ ......................................................................................... |  |  | 20557 | 100
 |  | UH Mānoa ................................................................................. |  |  | 7755 | 37.73
 |  |  | Outreach College………………….. |  | 2736 | 13.31
 |  |  | Community Service ................................ |  | 4976 | 24.21
 |  |  | Public Events ................................................................................ |  | 43 | 0.21
 |  | UH Hilo ....................................................................................... |  |  | 1247 | 6.07
 |  |  | Conference Center ............................. |  | 170 | 0.83
 |  |  | Continuing Education .................................. |  | 917 | 4.46
 |  |  | Senior Programs ...................................... |  | 160 | 0.78
 |  | UH Community Colleges .................................................. |  |  | 11555 | 56.2
 |  |  | Hawai‘i ............................................................................... |  | 1257 | 6.11
 |  |  | Honolulu ....................................................................... |  | 3129 | 15.22
 |  |  | Kapi‘olani ......................................................................... |  | 2677 | 13.02
 |  |  | Kaua‘i .................................................................................... |  | 523 | 2.54
 |  |  | Leeward ....................................................................................... |  | 1029 | 5.01
 |  |  | Maui ........................................................................................... |  | 1932 | 9.4
 |  |  | [NAME] .................................................................................. |  | 788 | 3.83
 |  |  | ETC ......................................................................................... |  | 220 | 1.07
 |  | 1/  Counts are registration counts, and may include multiple
 |  |  | counting of individuals.