tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 125804d1319220636-excel-2007-extract-add-numbers-from-text-w-blank-cells-book1
Sheet: Sheet1

 | 14.54..20.68
 | 16.47..15.95
 | 9.65..0.98
 | 17.90..6.84
 | 7.41..18.49
 | 3.11..4.67
 | 2.26..13.58
 | 10.13..2.42
 | 13.52..15.05
 | 7.02..6.41
 | 1.87..0.94
 | 2.50..17.69
 | 12.06..17.67
 | 6.92..4.18
 | 12.62..20.81
 | 11.24..18.27
 | 1.80..16.11
 | 8.27..20.69
Left numbers added
Right numbers added
Both Left and Right added
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Dominion

 | Dominion Gas Ventures
 | POI 12354 - Dominion Gas/Tule Lake
Day | Measured | Scheduled
1 | 115 | 240
2 | 58 | 240
3 | 44 | 240
4 | 2 | 240
5 | 35 | 240
6 | 41 | 240
7 | 245 | 240
8 | 171 | 240
9 | 114 | 240
10 | 149 | 240
11 | 171 | 240
12 | 143 | 240
13 | 2 | 240
14 | 184 | 240
15 | 146 | 240
16 | 47 | 240
17 | 197 | 240
18 | 256 | 240
19 | 265 | 240
20 | 250 | 240
21 | 204 | 240
22 | 235 | 239
23 | 199 | 239
24 | 176 | 239
25 | 15 | 239
26 | 255 | 239
27 | 201 | 240
28 | 246 | 240
29 | 170 | 240
30
31
2001-11-30 00:00:00 |  |  | 173805.23
2001-12-29 00:00:00
CBS Volume
 |  |  | 76238
Spreadsheet: 150142d1334310766-need-to-create-ordersheet-test
Sheet: Blad1

Art. nr. | Description | Qty | QT | QTY | QTY
 |  | 100 | 250 | 500 | 1000
10001 | Article A | 28.52005594405595 | 27.09405314685315 | 25.66805034965035 | 24.24204755244755
10002 | Article B | 28.52005594405595 | 27.09405314685315 | 25.66805034965035 | 24.24204755244755
10003 | Article C | 28.52005594405595 | 27.09405314685315 | 25.66805034965035 | 24.24204755244755
10004 | Article D | 28.52005594405595 | 27.09405314685315 | 25.66805034965035 | 24.24204755244755
Order 200011
Qty | Artnr | Description | Price
150 | 10001 |  | ?
450 | 10002 |  | ?
Spreadsheet: 69654d1270208860-sum-result-of-multiple-variables-chuckf-0402
Sheet: Analysis

 |  | O8 |  | O7 |  | O6 |  | O5 |  | O4 |  | O3 |  | O2 |  | W5 |  | W4 |  | W3 |  | [NAME] |  | E9 |  | E8 |  | E7 |  | E6 |  | E5 |  | E4 |  | E3
 | MS | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2 | ST1 | ST2
 | 00
 | 01
 | 02
 | 03
 | 11
 | 13
 | 13
 | 14
 | 15
 | 19
 | 21
 | 24
 | 25
 | 27
 | 30
 | 31
 | 35
 | 36
 | 37
 | 38
 | 40
 | 42
 | 44
 | 45
 | 46
 | 49
 | 50
 | 52
 | 53
 | 56
 | 57
 | 59
 | 60
 | 63
 | 63
 | 65
 | 67
 | 68
 | 70
 | 72
 | 74
 | 88
 | 89
 | 90
 | 91
 | 92
 | 94
 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 744226d1629094803-want-to-pull-in-data-automatically-from-other-sheets-working-lessonplan
Sheet: DATE

1 | 2021-06-14 00:00:00
2
3
4
5
6
7
8
9
10
11
12
13
WEEKLY PLAN OF WORK 2021 Term 1
Spreadsheet: mike_grigsby__27688__WestPenalties
Sheet: Sheet1

Non Delivery Penalties Charged by Customer
West Desk
 |  | Penalty
Sitara | Counterparty | Amount | Month | Settlements Coordinator
490242 | TransCanada Gas Services | 81724 | 2000-12-01 00:00:00 | [NAME]
221943 | Southwest Gas Corporation | 67599 | 2000-11-01 00:00:00 | [NAME]
386140 | Southwest Gas Corporation | 119373 | 2000-11-01 00:00:00 | [NAME]
416106 | Southwest Gas Corporation | 11055 | 2000-11-01 00:00:00 | [NAME]
221943 | Southwest Gas Corporation | 14432 | 2000-12-01 00:00:00 | [NAME]
416106 | Southwest Gas Corporation | 1954 | 2000-12-01 00:00:00 | [NAME]
221943 | Southwest Gas Corporation | 38206 | 2001-01-01 00:00:00 | [NAME]
386140 | Southwest Gas Corporation | 77825 | 2001-01-01 00:00:00 | [NAME]
416106 | Southwest Gas Corporation | 1272 | 2001-01-01 00:00:00 | [NAME]
504567 | National Fuel Marketing | 15234
Spreadsheet: 533123d1502663021-pivot-table-displaying-old-data-53rd-street-cost-schedule-after
Sheet: Draw 2 - 06.12.17

Description | Line Item | Line Item # | Date | Amount | Payee | Notes |  | Row Labels | Line Number | Sum of Amount
Construction BMP | Erosion Control | 211 | 2017-05-12 00:00:00 | 210 | Art's Trench Plate | Stabilized construction entrance |  | Block/Retaining Walls | 345 | 4500
Fence Repair | Miscellaneous Rentals | 304 | 2017-05-19 00:00:00 | 100 | [NAME] | Labor for temporary fence repair |  | Complaint Abatement/Goodwill | 357 | 302.27
Underground Power Plan | Miscellaneous Costs | 212 | 2017-05-23 00:00:00 | 5525 | EPI Engineers | Underground power plan progress payment |  | Erosion Control | 211 | 330
Site Materials | Rough Grading | 302 | 2017-05-31 00:00:00 | 74.53 | Home Depot | Materials to block off parking in the street for site access for graders |  | Miscellaneous Costs | 212 | 5525
Fence Replacement | Miscellaneous Rentals | 304 | 2017-06-08 00:00:00 | 148.36 | Home Depot | Fence extension materials |  | Miscellaneous Rentals | 304 | 248.36
Retaining Wall Labor | Block/Retaining Walls | 345 | 2017-06-09 00:00:00 | 4500 | B&M Grading | Digging of wall footings, keys and step downs |  | Rough Grading | 302 | 74.53
Construction BMP | Erosion Control | 211 | 2017-06-12 00:00:00 | 120 | Art's Trench Plate | Stabilized construction entrance |  | Grand Total | 280.75 | 10980.16
Windshield Repair | Complaint Abatement/Goodwill | 357 | 2017-05-06 00:00:00 | 302.27 | Safelite | [NAME] windshield repair
Spreadsheet: 736158d1623388460-find-nth-largest-vakue-and-return-with-corrsponding-columns-sample
Sheet: mine

UNIVERSITY | Top Commission | Top Comm. EP | SLAB / Remark | Second Top | Second Top EP | SLAB / Remark | A | SLAB / Remark | B | SLAB / Remark | C | SLAB / Remark | D | SLAB / Remark | E | SLAB / Remark | F | SLAB / Remark | G | SLAB / Remark | H | SLAB / Remark
ANNA |  |  |  |  |  | 8+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 25 | 8+:20 | 17 | 5+:20 | 17 | 8+:20 | 13 | 3+:17.5 | 15 | 8+:20 | 17 | 5+:20
CLT |  |  |  |  |  | 8+:20 | 40 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20 | 13 | 8+:20 | 14 | 8+:20 | 15 | 8+:20 | 8 | 5+:20
UK |  |  |  |  |  | 8+:20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20 | 15 | 3+:17.5 | 16 | 8+:20 | 15 | 10+: 20 | 14 | 10+: 20
Spreadsheet: 165554d1341264908-sorting-question-count-ips
Sheet: Sheet1

15.211.169.107 |  |  | ips that appear at least | 3 | times
24.107.229.161 |  |  |  | how many
59.95.131.151 |  |  | 59.164.8.9 | 5
59.164.8.9 |  |  | 68.98.61.117 | 4
59.164.8.9 |  |  | 74.241.171.206 | 4
59.164.8.9 | 6 |  | 79.175.119.42 | 3
59.164.8.9 |  |  | 83.128.52.145 | 4
59.164.8.9 |  |  | 84.194.56.70 | 4
61.246.47.32 |  |  | 91.121.68.133 | 4
62.202.101.196 |  |  | 94.67.52.141 | 4
62.202.101.196 |  |  | 98.228.76.84 | 4
65.182.232.227 |  |  | 99.248.220.250 | 4
65.182.232.227 |  |  | 212.40.138.14 | 4
67.112.121.194
67.202.54.191
67.202.54.191
68.5.126.12
68.98.61.117
68.98.61.117
68.98.61.117 | 20
68.98.61.117
72.64.227.149
72.64.227.149
74.12.57.153
74.12.57.153
74.14.67.225
74.216.62.200
74.241.171.206
74.241.171.206
74.241.171.206 | 30
74.241.171.206
75.91.74.10
75.156.53.209
75.156.53.209
75.157.181.46
76.211.23.125
76.211.23.125
78.174.93.51
78.174.93.51
79.101.157.197
79.166.91.79
79.175.119.42
79.175.119.42
79.175.119.42 | 44
80.133.233.136
81.83.177.68
81.165.166.142
83.128.52.145
83.128.52.145
83.128.52.145 | 50
83.128.52.145
84.71.203.187
84.81.62.237
84.81.62.237
84.194.56.70
84.194.56.70
84.194.56.70 | 57
84.194.56.70
84.197.25.189
84.197.25.189
85.243.58.209
85.243.58.209
86.8.107.235
86.67.88.111
86.96.226.87
86.149.165.8
86.166.174.196
86.166.174.196
87.82.19.177
89.201.202.116
90.202.27.245
91.121.68.133
91.121.68.133
91.121.68.133 | 74
91.121.68.133
93.138.92.149
93.138.92.149
94.67.52.141
94.67.52.141
94.67.52.141 | 80
94.67.52.141
98.228.76.84
98.228.76.84
98.228.76.84 | 84
98.228.76.84
98.243.190.147
98.243.190.147
99.244.157.34
99.244.157.34
99.248.220.250
99.248.220.250
99.248.220.250 | 92
99.248.220.250
119.152.39.236
119.152.39.236
121.242.205.226
122.50.216.114
122.162.176.94
122.162.176.94
124.43.214.144
124.253.113.141
139.80.123.34
144.36.223.201
144.36.223.201
196.35.158.178
203.82.91.104
203.82.91.104
203.99.183.45
206.240.25.208
206.240.25.208
212.40.138.14
212.40.138.14
212.40.138.14 | 113
212.40.138.14
Spreadsheet: 868823d1715531740-record-save-and-filter-rainfall-data-to-show-only-for-the-specific-month-rainfall-record
Sheet: Sheet1

 | January | [NAME] |  |  |  | January | Objectives; record rainfall data for the year
 |  |  |  |  |  | February | 1. select starting month and record rainfall data everyday e.g select January
 |  |  |  |  |  | March | 2. When  month this case january  has come to an end  select a new month, e.g February  the record of the other previous month this case January doesn’t show allowing me to input new data for feb
 |  |  |  |  |  | April | 3. when february dates are completed select new month of march and be able to enter data for march
 |  |  |  |  |  | May | 4. when I select previous months it shows data of the previous month which was already entered
 |  |  |  |  |  | June | 5. if I select a ne month where data wasn’t entred the cells should be empty
 |  |  |  |  |  | July
 |  |  |  |  |  | August
 |  |  |  |  |  | September
 |  |  |  |  |  | October
 |  |  |  |  |  | November
 |  |  |  |  |  | December
Spreadsheet: 0eb5647e-1e03-4f23-a160-f709f4c7c7e1
Sheet: November

FEDERAL COLLEGE WORK-STUDY PROGRAM
 | MASTER SHEET FOR STUDENT WORK HOURS
NAME |  |  |  |  |  |  |  | ASU ID #
PAY PERIOD BEGINNING |  |  | 2013-11-01 00:00:00 |  |  |  |  | PAY PERIOD ENDING |  |  | 2013-11-30 00:00:00
HOURLY RATE |  |  | 7.25 |  | TOTAL Hours |  |  |  |  | DEPARTMENT
TIME
WORKED | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16
IN
OUT
IN
OUT
IN
OUT
TOTAL
TIME
WORKED | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
IN |  |  |  |  |  |  |  |  | Thanksgiving Break
OUT
IN
OUT
IN
OUT
TOTAL
Student's Signature
Supervisor's Name (Print) |  |  |  |  |  |  |  |  | [NAME]'s Signature
Department Head's  Name (Print) |  |  |  |  |  |  |  |  | Department Head's Signature
Note:  This Master [NAME] should reflect the time and hours the student actually worked.  The total hours per day should reflect in the total column.
Students are not authorized to work no more than 20 hours per week.  No EXCEPTIONS!!!
Spreadsheet: 851923d1702044093-need-help-converting-a-google-sheets-formula-to-excel-scheduling-test1
Sheet: HP's

T1 | 37.63 | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 5-Pass | 2024-01-15 00:00:00 |  | HP | For production quote- [NAME]
 | 242695 | 1 | SupplyLogic | 47 | 42 | 42 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP
 | 242683 | 1 | Ad Trends Advertising | 5 | 16 | 94 | ART-4399 - WHT 70/30 PERF VINYL 54X300 | 1 | 5-Pass | 2023-12-01 00:00:00 |  | HP
Spreadsheet: 124829d1318628302-a-vlookup-function-within-another-vlookup-funtion-hills
Sheet: Inventory

Item # | Current Item Count | Vendor ID | # to Order | Subtotal | Tax | Total
1001 | 3 | 1 | 1 | 5.5 | 0.31625
1002 | 5 | 2 | 0 | 0 | 0
1003 | 3 | 2 | 9 | 34.2 | 1.9665
1004 | 9 | 3 | 0 | 0 | 0
1005 | 4 | 3 | 1 | 12.98 | 0.8437
1006 | 2 | 4 | 8 | 14.08 | 0.8096
1007 | 5 | 4 | 10 | 20.5 | 1.17875
1008 | 3 | 3 | 3 | 29.7 | 1.9305
1009 | 6 | 1 | 0 | 0 | 0
1010 | 55 | 5 | 20 | 44.8 | 2.912
1011 | 78 | 5 | 47 | 35.25 | 2.29125
1012 | 77 | 2 | 0 | 0 | 0
1013 | 33 | 2 | 17 | 11.05 | 0.635375
1014 | 44 | 2 | 31 | 31 | 1.7825
1015 | 54 | 1 | 46 | 23 | 1.3225
Spreadsheet: 873772d1720341191-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: ΚΥΡΙΑΚΕΣ 2024 (2)

 | ΙΟΥΝΙΟΣ |  |  |  |  |  | ΙΟΥΛΙΟΣ |  |  |  |  |  | ΑΥΓΟΥΣΤΟΣ |  |  |  |  |  | ΣΕΠΤΕΜΒΡΙΟΣ
 | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ |  |  | ΣΚΦ |  |  | ΦΑΙΔΡΑ
 | 2024-06-02 00:00:00 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ |  | 2024-06-02 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  | 2024-07-07 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-07-07 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-02 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-09 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  | 2024-07-07 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 2024-06-09 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ |  | 2024-06-16 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-09 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-23 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-16 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  | 2024-06-30 00:00:00 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | 2024-06-16 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-16 00:00:00 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | 2024-06-23 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 2024-06-23 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-30 00:00:00 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ
 | 2024-06-30 00:00:00 | YAKIMIDI OLESSYA
 | 2024-06-30 00:00:00 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ |  |  | ΚΥΡΙΑΚΕΣ ΠΟΥ ΔΟΥΛΕΨΑΝΕ
 | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ |  |  | ΚΟΝΙΣΣΗ ΒΑΣΙΛΙΚΗ
 | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  |  | YAKIMIDI OLESSYA |  |  | ΒΛΑΤΑΚΗΣ ΚΥΡΙΑΚΟΣ |  |  | YAKIMIDI OLESSYA
 | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ |  |  |  |  |  | ΚΑΛΛΟΥ ΓΕΩΡΓΙΑ
 | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ |  |  |  |  |  | ΟΙΚΟΝΟΜΟΥ ΒΑΡΒΑΡΑ
 | YAKIMIDI OLESSYA |  |  |  |  |  | YAKIMIDI OLESSYA
Spreadsheet: 848215d1698979193-how-to-calculate-a-pay-rate-that-is-affected-by-2-different-pay-conditions-pay-calculator_normal-pay-without-extra-days
Sheet: Pay Calculator

Employee Name : |  |  |  | THIS ROW IS DONE FOR REVISED LINK TO PAY RATES |  |  |  |  |  |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT
Employee Staff # : |  |  |  | PROBLEM - when you work a public holiday this should be zero PLUS ADOC, AND CHECK ALL OTHER ENTRIES |  | TO SOLVE THE PROBLEM INSERT A NEW COLUMN AND LINK TO THE DROP DOWN BOX, THEN NORMAL HOURS PAID LINKED TO THAT COLUMN TO SHOW ZEROSHOULD BE ZERO |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | THIS SHOULD BE LINKED TO TIME NOT AMOUNT
 |  |  |  |  |  |  |  |  | PENALTY AWARDS and ADDITIONS
DATE | DAY | SHIFT [NAME] |  | NORMAL HOURS PAID $ |  | [NAME] |  |  | LATE/EARLY PENALTY | BROKEN SHIFT |  | HIGH CAPACITY ALLOWANCE | TRAVELLING TIME |  | PUBLIC HOLIDAY |  |  |  | ROSTERED DAY OFF CANCELLED (RDOC) |  | ADO | ALLOCATED DAY OFF CANCELLED (ADOC) |  |  |  | ANNUAL LEAVE | ANNUAL LEAVE LOADING | SICK DAY
 |  |  |  |  |  | 1½ | DOUBLE |  | 1st. HALF | 0.5 | 1 |  |  |  | WORK | +  PUBLIC HOLIDAY | NO WORK |  | 1st. 3 hrs | After 3hrs |  | ADO Default | 1st. 3 hrs | After 3hrs
WEEK 1
 |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 1 Totals :
WEEK 2
 |  |  |  |  |  | 0 |  |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 0
 |  | Week 2 Totals :
 |  | COMBINED TOTAL :
Spreadsheet: 79983d1280236737-if-iserror-vlookup-all-within-if-excel-help-spreaddie
Sheet: Quarter data

 | CONTRACTS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PRIOR YEAR 4TH QUARTER
 |  | Quarter | Q1 | Q1 | Q1 | Q1 | Q1 | Q1 | Q1 | Q1 | Q1 |  | Q1 |  |  |  |  |  | Quarter | Q2 | Q2 | Q2 | Q2 | Q2 | Q2 | Q2 | Q2 | Q2 |  | Q2 |  |  |  |  |  | Quarter | Q3 | Q3 | Q3 | Q3 | Q3 | Q3 | Q3 | Q3 | Q3 |  | Q3 |  |  |  |  |  | Quarter | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 |  | Q4 |  |  |  |  |  | Quarter | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 | Q4 |  | Q4
 |  | Acctmo | 1 | 1 | 1 | 2 | 2 | 2 | 3 | 3 | 3 | Month 3 | Total |  |  |  |  |  | Acctmo | 4 | 4 | 4 | 5 | 5 | 5 | 6 | 6 | 6 | Month 3 | Total |  |  |  |  |  | Acctmo | 7 | 7 | 7 | 8 | 8 | 8 | 9 | 9 | 9 | Month 3 | Total |  |  |  |  |  | Acctmo | 10 | 10 | 10 | 11 | 11 | 11 | 12 | 12 | 12 | Month 3 | Total |  |  |  |  |  | Acctmo | 10 | 10 | 10 | 11 | 11 | 11 | 12 | 12 | 12 | Month 3 | Total
 |  | Contractnum | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | GP% | Revenue $k | Cost $k | GP $k | GP% |  |  | Contractnum | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | GP% | Revenue $k | Cost $k | GP $k | GP% |  |  | Contractnum | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | GP% | Revenue $k | Cost $k | GP $k | GP% |  |  | Contractnum | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | GP% | Revenue $k | Cost $k | GP $k | GP% |  |  | Contractnum | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | Revenue $k | Cost $k | GP $k | GP% | Revenue $k | Cost $k | GP $k | GP%
1 |  | abcdef | 400 | 200 | 200 | 500 | 300 | 200 | 600 | 100 | 500 | 0.8333333333333334 | 1500 | 600 | 900 | 0.6 |  |  | abcdef | 1000 | 850 | 150 | 1200 | 800 | 400 | 1000 | 650 | 350 | 0.35 | 3200 | 2300 | 900 | 0.28125 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  | abcdef | 1200 | 800 | 400 | 1000 | 750 | 250 | 1100 | 1250 | -150 | -0.1363636363636364 | 3300 | 2800 | 500 | 0.1515151515151515
Spreadsheet: 87357d1287164409-excel-2007-using-xirr-with-dynamic-ranges-test-workbook-for-xirr-no-vba
Sheet: 8 APR 09

MKSYM | PTDate | Transaction | NSB | CDCR | BasisValue | Show
BNI | 2008-06-04 00:00:00 | PURCHASE | 200 |  | 22130.35 | X
BNI | 2008-07-01 00:00:00 | Cash Dividend |  | 64 | 64 | X
BNI | 2008-10-01 00:00:00 | Cash Dividend |  | 80 | 80 | X
 | 2009-04-08 00:00:00 |  |  |  | 12778
IJT | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 4016.78 | X
IJT | 2009-03-31 00:00:00 | Cash Dividend |  | 1.69 | 1.69 | X
 | 2009-04-08 00:00:00 |  |  |  | 4376.9
IWP | 2009-01-16 00:00:00 | PURCHASE | 70 |  | 2119.6 | X
IWP | 2009-02-24 00:00:00 | PURCHASE | 110 |  | 3077.66 | X
IWP | 2009-03-30 00:00:00 | Cash Dividend |  | 15.45 | 15.45 | X
 | 2009-04-08 00:00:00 |  |  |  | 5691.6
LQD | 2009-01-16 00:00:00 | PURCHASE | 20 |  | 2023.79 | X
LQD | 2009-02-06 00:00:00 | Cash Dividend |  | 9.82 | 9.82 | X
LQD | 2009-03-30 00:00:00 | Cash Dividend |  | 9.65 | 9.65 | X
 | 2009-04-08 00:00:00 |  |  |  | 1875
MLN | 2009-01-16 00:00:00 | PURCHASE | 120 |  | 2060.08 | X
MLN | 2009-02-24 00:00:00 | PURCHASE | 120 |  | 2046.47 | X
MLN | 2009-02-26 00:00:00 | Cash Dividend |  | 7.2 | 7.2 | X
MLN | 2009-03-06 00:00:00 | Cash Dividend |  | 17.28 | 17.28 | X
 | 2009-04-08 00:00:00 |  |  |  | 4053.6
OAKBX | 2002-01-10 00:00:00 | PURCHASE | 2165.67 |  | 40000 | X
 | 2009-04-08 00:00:00 |  |  |  | 58163.27
PHB | 2009-01-16 00:00:00 | PURCHASE | 130 |  | 2089.1 | X
PHB | 2009-02-07 00:00:00 | Cash Dividend |  | 14.86 | 14.86 | X
PHB | 2009-03-31 00:00:00 | Cash Dividend |  | 15.85 | 15.85 | X
 | 2009-04-08 00:00:00 |  |  |  | 1976
ROTH DIA | 2009-01-16 00:00:00 | PURCHASE | 25 |  | 2049.5 | X
ROTH DIA | 2009-03-16 00:00:00 | Cash Dividend |  | 9.13 | 9.13 | X
 | 2009-04-08 00:00:00 |  |  |  | 1959.25
ROTH FIGRX | 2005-06-06 00:00:00 | PURCHASE | 490.844 |  | 13792.72 | X
ROTH FIGRX | 2006-01-13 00:00:00 | PURCHASE | 119.796 |  | 4000 | X
 | 2009-04-08 00:00:00 |  |  |  | 14834.99
ROTH ITM | 2009-02-24 00:00:00 | PURCHASE | 100 |  | 2090.82 | X
ROTH ITM | 2009-03-06 00:00:00 | Cash Dividend |  | 6.3 | 6.3 | X
ROTH ITM | 2009-04-07 00:00:00 | Cash Dividend |  | 6.4 | 6.4 | X
 | 2009-04-08 00:00:00 |  |  |  | 2050
ROTH IYC | 2009-01-16 00:00:00 | PURCHASE | 50 |  | 2020 | X
ROTH IYC | 2009-03-31 00:00:00 | Cash Dividend |  | 7.46 | 7.46 | X
 | 2009-04-08 00:00:00 |  |  |  | 2077
[NAME] TAVIX | 2005-06-06 00:00:00 | PURCHASE | 669.758 |  | 13000 | X
 | 2009-04-08 00:00:00 |  |  |  | 10362.09
RWJ | 2009-01-16 00:00:00 | PURCHASE | 130 |  | 2054 | X
 | 2009-04-08 00:00:00 |  |  |  | 2037.1
WGGFX | 2008-03-18 00:00:00 | PURCHASE | 985.724 |  | 16274.31 | X
 | 2009-04-08 00:00:00 |  |  |  | 8273.25
XRT | 2009-01-16 00:00:00 | PURCHASE | 100 |  | 2010.77 | X
XRT | 2009-02-24 00:00:00 | PURCHASE | 155 |  | 3056.24 | X
 | 2009-04-08 00:00:00 |  |  |  | 6186.3
 |  |  |  |  |  |  |  | PORTFOLIO RETURN
Spreadsheet: 805615d1668790994-i-cannot-figure-out-a-formula-to-get-the-results-i-need-budget
Sheet: Budget

Aries Building Services |  | Sunstate Equipment |  | Sunstate Equipment
9137.39 |  | 14361.3 |  | 39253.74
2022-08-01 00:00:00 |  | 2022-08-17 00:00:00 |  | 2022-11-09 00:00:00
261182 |  | 10941659-001 |  | 10941659-003
5538.5 | True | 2235.57 | True | 547.22
2022-08-18 00:00:00 |  | 2022-08-18 00:00:00 |  | 2022-11-09 00:00:00
5815 |  | 5817 |  | VS
2022-09-01 00:00:00 |  | 2022-08-17 00:00:00 |  | 2022-11-09 00:00:00
266570 |  | 10941662-001 |  | 10941662-003
1199.63 | True | 3155.16 | True | 635.89
2022-09-06 00:00:00 |  | 2022-08-18 00:00:00
5862 |  | 5817
2022-10-03 00:00:00 |  | 2022-09-06 00:00:00
270878 |  | [PHONE]
1199.63 | True | 3902.59 | True | 3902.59
2022-10-03 00:00:00 |  | 2022-09-06 00:00:00
5924 |  | 5868
2022-11-07 00:00:00 |  | 2022-09-06 00:00:00
276759 |  | [PHONE]
1199.63 | True | 4611.66 | True | 4611.66 |  |  |  | (($[NAME]=TRUE),$CK$9:$CK$40)
2022-11-10 00:00:00 |  | 2022-09-06 00:00:00
6019 |  | 5868
 |  | 2022-09-09 00:00:00
 |  | [PHONE]
 |  | 162.38 | True | 162.38
 |  | 2022-09-14 00:00:00
 |  | 5874
 |  | 2022-09-09 00:00:00
 |  | [PHONE]
 |  | 293.94 | True | 29394
 |  | 2022-09-14 00:00:00
 |  | 5874
 |  |  |  | 0
Spreadsheet: 752036d1634545773-formula-to-calculate-average-difference-between-dates-example
Sheet: Sheet1

CONF/11 | 2020.12.23 | 2021.01.26
CONF/12 | 2021.01.06 | 2021.03.04
CONF/13 | 2021.03.04 | 2021.03.25
CONF/14 | 2021.03.18 | 2021.03.31
CONF/15 | 2021.03.31 | 2021.05.10
CONF/16 | 2021.05.10 | 2021.06.09
CONF/17 | 2021.06.09 | 2021.08.05
CONF/18 | 2021.08.05 | 2021.09.07
CONF/19 | 2021.08.27 | 2021.10.06 |  | Average diff of dates:
CONF/20 | 2021.09.07
CONF/21
CONF/22
CONF/23
Spreadsheet: 0d638492-e25c-4642-a453-05eb154849e1
Sheet: DegreesAwardedLong2012

Degrees Awarded -- Statewide by Institution Type
 | FY | FY | FY | FY | FY
 | 2012 | 2011 | 2010 | 2009 | 2008
Public University | 125534 | 120938 | 115263 | 111302 | 106705
Independent College or University | 29919 | 28390 | 28152 | 27596 | 26689
Public 2-year College | 87539 | 81314 | 74190 | 64649 | 59049
Independent 2-year College | 118 | 126 | 77 | 84 | 111
Public Health-related Institution | 7216 | 6496 | 5921 | 5303 | 5085
Independent Health-related Institution | 772 | 1401 | 895 | 942 | 659
 | 251098 | 238665 | 224498 | 209876 | 198298
Spreadsheet: 771758d1646834802-calculation-based-on-dropdown-selection-dv-hlookup-aligw
Sheet: Sheet1

1
2 |  | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | Yearly | Semi Annualy | Quarterly
3
4 | [NAME] | 5 | 10 | 15 | 20 | 5 | 10 | 15 | 20 | 25 | 5 | 10 | 15
5
6
 |  | Yearly |  | Yearly
 |  | Semi Annually
 |  | Quarterly
 |  | JAN
 |  | FEB
 |  | MAR
 |  | APR
 |  | MAY
 |  | JUN
 |  | JUL
 |  | AUG
 |  | SEP
 |  | OCT
 |  | NOV
 |  | DEC