tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 749124d1632515449-extract-data-from-sheet-to-another-sheet-based-on-selected-month-trial-version-tms
Sheet: List2

Month | Aug |  |  |  |  |  | [NAME]
=IFERROR(FILTER(FILTER(List1!A2:G34,List1!G2:G34=MONTH($B$1&0)),{1,1,1,1,1,1,0}),"no data") |  |  |  |  |  |  | =IFERROR(INDEX(List1!A$2:A$1000;AGGREGATE(15;6;(ROW($A$2:$A$1000)-ROW($A$1))/(List1!$G$2:$G$1000=MONTH($B$1&0));ROWS($1:1)));"")
Name | Last name | Address | Adress | arival | departure |  | =IFERROR(INDEX(List1!A$2:A$1000,AGGREGATE(15,6,(ROW($A$2:$A$1000)-ROW($A$1))/(List1!$G$2:$G$1000=MONTH($B$1&0)),ROWS($1:1))),"")
 | Votípková | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Petrq | Votípka | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kroupa | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Pavla | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Zuzana | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kroupová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Votípková | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Jan | Votípka | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
t | t | test | test | 2021-08-20 00:00:00 | 2021-08-22 00:00:00
Štěpánka | [NAME] | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Martin | Král | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Eliška | Králová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Adam | Král | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Šárka | Krocová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Vladimír | Kroc | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Vladimír | Kroc | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Valeria | Krocová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Eva | Kuběnová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Zdeněk | Kuběna | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
[NAME] | Kuběna | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Elena | Kuběnová | test | test | 2021-08-19 00:00:00 | 2021-08-23 00:00:00
Spreadsheet: 93f2685e-fdfb-4ecf-a22f-65dda6ef74c4
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5587 | 30439 | Joleen | Hakker B1 | NED | 478 | 00:53:05 | 00:01:21 | 01:06:51 | 00:01:12 | 00:27:25 | 1 | 02:29:52
Spreadsheet: 160642d1339154826-highlighting-range-of-cells-sample
Sheet: Diary Plan

 | dropdown of instructors
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | available
 |  |  |  | CBT check box |  | CBT check box |  | CBT check box |  | CBT check box |  |  |  |  |  |  | CBT
 |  |  |  | lesson type textbox |  | lesson type textbox |  | lesson type textbox |  | lesson type textbox
timeslots |  |  |  | time | time | time | time | time | time | time | time
 |  |  |  | bike | Customer | bike | Customer | bike | Customer | bike | 1 name |  |  |  |  |  | Bikes | Timeslots | changes colour
Dates |  |  |  |  |  |  |  |  |  |  | Paid  check
Day |  |  |  |  |  |  |  |  |  |  | 2 name
 |  |  |  |  |  |  |  |  |  |  | paid check
 |  |  |  | Module 1 |  | test center
 |  |  | P/F? | timeslots |  | Ref no |  | Customer name |  |  | 650 or 125 |  | Paid to pay?
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  | next day
Spreadsheet: 59011d1259335776-linking-rows-in-two-sheets-then-sorting-data-in-one-but-not-the-other-excelforum-example
Sheet: Sheet2

FILE NUM | TOWNSHIP | Permittee | As Trustee For | LUP# | Notes
ES-1143 | Truman | [NAME] | [NAME] | [PHONE] | Not centralized, no response
ES-1085 | [NAME] | [NAME] | [NAME] | [PHONE] | In Arrears, letter sent Jan 2009
ES-2062 | [NAME] | [NAME] Medina | Fontana Inc. | [PHONE] | In Arrears, PB working on solution
Spreadsheet: 127522d1320391714-expiry-date-indicator-sample-1-
Sheet: Sheet2

NOVEMBER 2011
Name | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W
 | 1 | 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
 | 2011-11-01 00:00:00 | 2011-11-02 00:00:00 | 2011-11-03 00:00:00 | 2011-11-04 00:00:00 | 2011-11-05 00:00:00 | 2011-11-06 00:00:00 | 2011-11-07 00:00:00 | 2011-11-08 00:00:00 | 2011-11-09 00:00:00 | 2011-11-10 00:00:00 | 2011-11-11 00:00:00 | 2011-11-12 00:00:00 | 2011-11-13 00:00:00 | 2011-11-14 00:00:00 | 2011-11-15 00:00:00 | 2011-11-16 00:00:00 | 2011-11-17 00:00:00 | 2011-11-18 00:00:00 | 2011-11-19 00:00:00 | 2011-11-20 00:00:00 | 2011-11-21 00:00:00 | 2011-11-22 00:00:00 | 2011-11-23 00:00:00 | 2011-11-24 00:00:00 | 2011-11-25 00:00:00 | 2011-11-26 00:00:00 | 2011-11-27 00:00:00 | 2011-11-28 00:00:00 | 2011-11-29 00:00:00 | 2011-11-30 00:00:00
 | TR | EL | MC | LT
 |  |  |  |  |  |  |  |  | TR | TR | TR |  |  |  |  |  |  |  |  |  | LT | LT
Legend
TR | Training
EL | Emergency Leave
MC | Medical Certificate
LT | Late
Spreadsheet: michelle_lokay__26703__imball0112
Sheet: SidR

 | [NAME]
 | POI 1190 - Keystone Plant Outlet
Day | Measured | Scheduled
1 | 53056 | 52585
2 | 52799 | 52585
3 | 56198 | 57327
4 | 39345 | 38839
5 | 57736 | 57595
6 | 53279 | 52981
7 | 49516 | 48633
8 | 58091 | 56822
9 | 56234 | 59388
10 | 58416 | 59388
11 | 33275 | 41442
12 | 41688 | 38336
13 | 38952 | 38928
14 | 57758 | 58389
15 | 54323 | 54388
16 | 54357 | 54388
17 | 53451 | 52209
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 35912.71
2001-12-17 00:00:00
CBS Volume
 |  |  | 17122
Spreadsheet: 890092d1741268566-return-values-in-array-that-fit-within-multiple-ranges-sample-data
Sheet: Sheet1

 | Well Yield (gpm) | 2000
 | Minimum Well Yield (gpm) | Maximum Well Yield (gpm) | [NAME] of [NAME] (in) | Optimum Size of Well Casing (in) | Smallest Size of Well Casing (in)
 | 0 | 100 | 4 | 6 | 5
 | 75 | 175 | 5 | 8 | 6
 | 150 | 350 | 6 | 10 | 8
 | 300 | 700 | 8 | 12 | 10
 | 500 | 1000 | 10 | 14 | 12
 | 800 | 1800 | 12 | 16 | 14
 | 1200 | 3000 | 14 | 20 | 16
 | 2000 | 3800 | 16 | 24 | 20
 | 3000 | 6000 | 20 | 30 | 24
 |  | [NAME] | Expected Values
 | Smallest Size of Well Casing (in) |  | 16
 | Optimum Size of Well Casing (in) |  | 24
Spreadsheet: 108289d1305303311-excel-2007-pivot-table-formulas-with-custom-subtotals-sample
Sheet: pivot2

 |  | year | month
 |  | 2010 |  | Toplam 2010 | Ortalama 2010 | 2011 |  | Toplam 2011 | Ortalama 2011 | Genel Toplam
name | Değerler | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 |  |  | 2011-01-01 00:00:00 | 2011-02-01 00:00:00
[NAME] | Toplam balance | 10 | 32 | 42 | 21 | 14 | 24 | 38 | 19 | 80
 | Toplam quantity | 2 | 5 | 7 | 3.5 | 2 | 4 | 6 | 3 | 13
 | Toplam tax | 2 | 2 | 4 | 2 | 2 | 2 | 4 | 2 | 8
 | Toplam % | 0.2 | 0.0625 |  |  | 0.1428571428571428 | 0.08333333333333333 |  |  | 0.1
item2 | Toplam balance | 24 | 26 | 50 | 25 | 52 | 53 | 105 | 52.5 | 155
 | Toplam quantity | 3 | 3 | 6 | 3 | 4 | 4 | 8 | 4 | 14
 | Toplam tax | 5 | 6 | 11 | 5.5 | 7 | 8 | 15 | 7.5 | 26
 | Toplam % | 0.2083333333333333 | 0.2307692307692308 |  |  | 0.1346153846153846 | 0.1509433962264151 |  |  | 0.167741935483871
item3 | Toplam balance | 100 | 102 | 202 | 101 | 107 | 108 | 215 | 107.5 | 417
 | Toplam quantity | 5 | 5 | 10 | 5 | 5 | 5 | 10 | 5 | 20
 | Toplam tax | 22 | 23 | 45 | 22.5 | 24 | 25 | 49 | 24.5 | 94
 | Toplam % | 0.22 | 0.2254901960784314 |  |  | 0.2242990654205607 | 0.2314814814814815 |  |  | 0.2254196642685851
Toplam balance Toplamı |  | 134 | 160 | 294 | 49 | 173 | 185 | 358 | 59.66666666666666 | 652
Toplam quantity Toplamı |  | 10 | 13 | 23 | 3.833333333333333 | 11 | 13 | 24 | 4 | 47
Toplam tax Toplamı |  | 29 | 31 | 60 | 10 | 33 | 35 | 68 | 11.33333333333333 | 128
Toplam % Toplamı |  | 0.2164179104477612 | 0.19375 | #[NAME]! | #[NAME]! | 0.1907514450867052 | 0.1891891891891892 | #[NAME]! | #[NAME]! | 0.196319018404908
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: Dynamic Chart 3x3

All | month 1 | month 2 | month 3 |  |  | Named Ranges | [NAME]
k | 6 | 7 | 3 |  |  | SeriesK
1 | 4 | 2 | 8 |  |  | Series1 |  |  | Legend works because L7 is hidden
2 | 7 | 3 | 7 |  |  | Series2
 |  |  |  |  |  | SLabelK
 |  |  |  |  |  | SLabel1
Grade | All | Month | All |  |  | SLabel2
 |  |  |  |  |  | CatLabels
Spreadsheet: 735205d1622753051-formula-to-convert-range-and-provide-outcome-according-to-2-parameters-formulas
Sheet: Sheet1

 | Range | Score |  |  | 1) | I'm working on a score system which provide a score number. I need then a formula which convert the number (included in the range provided) in the respective letter
17 | from 17 to 23 | A | Days After | 0
23.01 | from 23.01 to 29 | B | Days After | 0.05 | 25
29.01 | from 29.01 to 35 | C | Days After | 0.1
35.01000000000001 | from 35.01 to 41 | D | Days After | 0.15
41.01000000000001 | from 41.01 to 47 | E | Days After | 0.2
47.01000000000001 | from 47.01 to 53 | F | 7 Days | 0
53.01000000000001 | from 53.01 to 59 | G | 7 Days | 0.05
59.01000000000001 | from 59.01 to 65 | H | 7 Days | 0.1
65.01 | from 65.01 to 71 | I | 7 Days | 0.15
71.01 | from 71.05 to 77 | J | 7 Days | 0.2
77.01 | from 77.01 to 83 | K | 30 days | 0
83.01 | from 83.01 to 89 | L | 30 days | 0.05
89.01 | from 89.01 to 95 | M | 30 days | 0.1
95.01 | from 95.01 to 101 | N | 30 days | 0.15
101.01 | from 101.1 to 104 | O | 30 days | 0.2
 |  |  |  |  | 2) | Once the above formula is created, I need then a formula which assign to the letter the correspdondent settlment and collateral result (e.g. H will give the outcome 7 days and 10%)
Settltement | day after | A | B | C | D | E
 | 7 days | F | G | H | I | J
 | 30 days | K | L | M | N | O
 |  | 0 | 0.05 | 0.1 | 0.15 | 0.2
 |  | Collateral
Spreadsheet: 708164d1607632987-another-lookup-problem-excel-example
Sheet: Source_Data

[NAME] | EMP # | Name | COLORS | Date | ROOM
 | 100 | DOE, [NAME] | RED | 2015-08-28 00:00:00 | 11111
 | 100 | DOE, [NAME] | GOLD | 2015-08-28 00:00:00 | 11111
 | 103 | [NAME], MICKEY | CREAM | 2020-02-27 00:00:00 | 11111
 | 101 | DOE, [NAME] | GOLD | 2016-04-19 00:00:00 | 11111
 | 101 | DOE, [NAME] | CREAM | 2016-08-10 00:00:00 | 11111
 | 101 | DOE, [NAME] | RED | 2015-01-28 00:00:00 | 11111
 | 102 | SOMEBODY, ANNIE | CREAM | 2015-01-30 00:00:00 | 11111
 | 104 | PUBLIC, [NAME] | GOLD | 2015-01-28 00:00:00 | 11111
 | 104 | PUBLIC, [NAME] | CREAM | 2015-01-30 00:00:00 | 11111
 | 104 | PUBLIC, [NAME] | RED | 2020-09-09 00:00:00 | 11111
 | 105 | DUCK, [NAME] | GOLD | 2015-01-28 00:00:00 | 11111
 | 105 | DUCK, [NAME] | CREAM | 2015-01-30 00:00:00 | 11111
Spreadsheet: 860260d1708429153-how-to-get-the-right-date-behind-the-right-name-based-on-today-from-anoher-sheet-map
Sheet: Rooster

Datum | 2024-02-16 00:00:00
Naam | Start | Eind
[NAME]
[NAME]
Kierra Rhodes
[NAME]
[NAME]
Mallory Mercade
Spreadsheet: 139838d1328508530-journal-journal
Sheet: Summary

 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | Total
Beginning
Cash in Bank
Fund Contribution: Unappropriated
Fund Contribution: Appropriated
Accommodation
Air Fare
Communication
Equipment
Honorarium
Gasoline
License
Mandatory
Miscellaneous
Per Diem
Postage/Parcel/Freight
Professional Fee
Repair & Maintenance
Rental & other related
Salary
Supplies & Materials
Travel
Website
Fund Transfer
Spreadsheet: 38659d1236798418-summarizing-data-over-several-sheets-bolts-list-r2
Sheet: BoltsP2

 | BOLTS LIST | BOLTS LIST
CLIENT |  | 0 |  |  |  | JOB No. |  | 0
PLANT |  | 0 |  |  |  |  | LIST No.  2   of  3
 |  | ALL BOLTS GRADE 8.8 ZINC PLATED |  | BOLTS |  | NUTS |  | WASHERS
ITEM | GRIP | [NAME] OF JOINT | QTY | DIA | LGTH | NYLCK | HEX | FORM C | SPRING
20 | 6 |  | 10 | M8 | 20
21 | 14 |  | 12 | M12 | 35
22 | 18 |  | 14 | M12 | 40
23 | 18 |  | 16 | M12 | 40
24 | 24 |  | 18 | M12 | 45
25 | 36 |  | 20 | M12 | 55
26 | 12 |  | 2 | M12 | 35
27 | 8 |  | 4 | M12 | 30
28 | 16 |  | 6 | M12 | 35
29 | 10 |  | 8 | M12 | 30
30 | 8 |  | 10 | M12 | 30
31 | 16 |  | 8 | M12 | 35
32 |  |  |  |  | #N/A
33 |  |  |  |  | #N/A
34 |  |  |  |  | #N/A
35 |  |  |  |  | #N/A
36 |  |  |  |  | #N/A
37 |  |  |  |  | #N/A
38 |  |  |  |  | #N/A
Spreadsheet: 87080d1286986396-sum-numbers-if-creditcardpvt
Sheet: Sheet1

 |  |  | credit card | transaction amount | total purchased per card
 |  |  | 4382 xxxx xxxx 6107 | 393.2183947404466
 |  |  | 4382 xxxx xxxx 6107 | 1085.55163676209
 |  |  | 438x xxxx xxxx 5110 | 688.9724010409534
 |  |  | 438x xxxx xxxx 5110 | 712.4982879057663
 |  |  | 438x xxxx xxxx 5130 | 772.9934255581428
 |  |  | 438x xxxx xxxx 5120 | 322.6407341460074
 |  |  | 438x xxxx xxxx 5120 | 455.99
 |  |  |  |  | Then, if possible, collapse the rows so only one instance of the card number is showing along with the total amount charged to the card
 |  |  | Sum of transaction amount
 |  |  | credit card | Total
 |  |  | 4382 xxxx xxxx 6107 | 1478.770031502537
 |  |  | 438x xxxx xxxx 5110 | 1401.47068894672
 |  |  | 438x xxxx xxxx 5120 | 778.6307341460074
 |  |  | 438x xxxx xxxx 5130 | 772.9934255581428
 |  |  | Grand Total | 4431.864880153406
Spreadsheet: 462502d1464080217-selecting-data-according-to-text-and-placing-in-graph-peter-renton-bsb-
Sheet: Immingham

Imminghams Capital Expense 2016-2017
Improment/Equipment | In-house/ Subcontract | Time Scale | Expense | possible Savings
[NAME] machine | sub |  | 2500
line marking in yard | sub |  | 3000 |  |  | Immingham
adblue tank |  |  | 3200 |  |  | expense | Potential Saving
Totals
Spreadsheet: 765863d1643643923-minimum-value-based-on-second-column-and-between-values-sample
Sheet: Sheet1

 |  | Theoretical Conc. (mg/mL) | Recovery  (90-110%)
 |  | 12.5 | 98.82789245061939 |  |  | = | min if
 |  | 8.72 | 99.10046866187112
 |  | 5.64 | 99.07624366778093
 |  | 6.71 | 97.83237538569728
 |  | 1.85 | 100.3759361923322
 |  | 1 | 97.44566138916274
 |  | 0.53 | 92.57199493364881
 |  | 0.21 | 73.19521414531705
 |  | minimum value from this one | if the value from this colum meets the criteria
Spreadsheet: 273973d1382974889-make-2-dependent-drop-down-lists-dynamic-equipment-and-cost-estimate-updated
Sheet: Reference

Size | Description | Price | Price | Price | Price | Price |  | cost | =OFFSET('Piping and Fitting'!$C$3,0,0,COUNTA('Piping and Fitting'!$C$3:$C$1000))
 |  |  |  |  |  |  |  | description
 |  |  |  |  |  |  |  | material_description | =OFFSET('Piping and Fitting'!$B$3,0,0,COUNTA('Piping and Fitting'!$B$3:$B$3:'Piping and Fitting'!$B$1000))
 |  |  |  |  |  |  |  | size
 |  |  |  |  |  |  |  | unique_description | =OFFSET(Reference!$B$2, 0, 0, COUNT(IF(Reference!$B$2:$B$1000="", "", 1)), 1)
Spreadsheet: d703d096-3b0b-41b9-8a51-c902d91fb6b8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | 2009-09-08 00:00:00
 |  |  | ROOTED POT MUM
 |  |  |  | ORDER FORM
ORDER TYPE |  | REASON CODE |  | REF. ORDER # |  | SALES ORG. |  | ORDER #
DISTRIB  # & NAME |  |  |  |  | SHIP TO #
SOLD TO # & NAME |  |  |  |  | SHIP TO NAME
STREET |  |  |  |  | Street
CITY, STATE  ZIP |  |  |  |  | CITY, STATE  ZIP
PHONE # |  |  |  |  | PHONE #
SLSM. NAME / # |  |  | P.O. # |  | VISA / MC / DISC |  | CARDHOLDER NAME
ARE SUBS OK? | IF NO, PHONE ….. |  | WK. WANTED |  | CREDIT CARD NUMBER |  |  |  | EXP DATE
 | CUST
YES / NO | DIST |  | ORDER INFO |  | SHIP VIA |  |  |  | SHIP FROM:
 | SLSM
VARIETY NAME |  |  |  | QUANTITY | VARIETY NAME |  |  |  | QUANTITY
 |  |  |  |  | TOTAL ORDER QUANTITY |  |  |  | 0
 |  |  |  |  | ORDER REQUIREMENTS
 |  |  |  |  | MINIMUM PER VARIETY: |  |  |  | 48
 |  |  |  |  | MULTIPLES OF: |  |  |  | 48
 |  |  |  |  | MINIMUM ORDER: |  |  |  | 480
 |  |  |  |  | PACK / CASE: |  |  |  | 480
FOR INTERNAL USE ONLY
PLACED BY: | CUSTOMER |  | SLSM. |  | DIST. |  | GREEN LEAF
TAKEN BY: |  |  |  | DATE TAKEN: |  |  | KEYED BY:
Spreadsheet: 103467d1301218377-fill-function-down-8-rows-then-over-4-columns-769631_cbrown8131
Sheet: Sheet2

ROOM | TABLE | LOT | ITEM | ITEM #
2B | A | 2 | 1
2B | D | 2 | 10
2B | D | 2 | 100
2B | D | 2 | 101
2B | B | 2 | 11
2B | B | 2 | 12
2B | B | 2 | 13
2B | A | 2 | 14
2B | A | 2 | 15
2B | B | 2 | 2
2B | C | 2 | 21
2B | C | 2 | 22
2B | A | 2 | 25
2B | A | 2 | 26
2B | C | 2 | 29
2B | B | 2 | 3
2B | C | 2 | 30
2B | B | 2 | 34
2B | A | 2 | 36
2B | B | 2 | 37
2B | B | 2 | 38
2B | D | 2 | 4
2B | D | 2 | 5
2B | B | 2 | 55
2B | C | 2 | 57
2B | D | 2 | 6
2B | C | 2 | 67
2B | C | 2 | 68
2B | C | 2 | 69
2B | A | 2 | 7
2B | A | 2 | 8
2B | D | 2 | 89
2B | D | 2 | 9
Spreadsheet: 124246d1318268514-vlookup-help-billablehrsedit-1-
Sheet: Sheet1

O'Donovan & Sullivan Law Associates
BILLING SUMMARY
OCTOBER 8 TO 12, 2012
File | Client | Date | Attorney Code | Billable Hours | [NAME] | Legal Fees | Billing Statistics
FL-325 | 10104 | 2012-10-08 00:00:00 | 1 | 26.75 |  |  | Total Legal Fees Billed by Attorney
EP-652 | 10106 | 2012-10-08 00:00:00 | 1 | 12.1 |  |  | 1 | [NAME]
CL-412 | 10125 | 2012-10-08 00:00:00 | 2 | 33.25 |  |  | 2 | [NAME]
IN-745 | 10210 | 2012-10-09 00:00:00 | 3 | 24.25 |  |  | 3 | [NAME]
EL-632 | 10225 | 2012-10-09 00:00:00 | 3 | 12.11 |  |  | 4 | [NAME]
RE-475 | 10285 | 2012-10-09 00:00:00 | 4 | 42.3 |  |  |  | TOTAL
CL-501 | 10341 | 2012-10-10 00:00:00 | 2 | 15.25
CL-521 | 10334 | 2012-10-10 00:00:00 | 2 | 20.25 |  |  | Average Billable Hours by Attorney
PL-348 | 10420 | 2012-10-10 00:00:00 | 3 | 25 |  |  | 1 | [NAME]
RE-492 | 10425 | 2012-10-10 00:00:00 | 4 | 22.7 |  |  | 2 | [NAME]
EL-632 | 10225 | 2012-10-11 00:00:00 | 3 | 23 |  |  | 3 | [NAME]
PL-512 | 10290 | 2012-10-11 00:00:00 | 3 | 16.2 |  |  | 4 | [NAME]
IN-745 | 10210 | 2012-10-11 00:00:00 | 3 | 14.5
FL-385 | 10278 | 2012-10-11 00:00:00 | 1 | 24 |  |  | Attorney Code Table
CL-412 | 10125 | 2012-10-12 00:00:00 | 2 | 15.25 |  |  | Code | Attorney | [NAME]
CL-450 | 10358 | 2012-10-12 00:00:00 | 2 | 23.5 |  |  | 1 | [NAME] | 85
IN-801 | 10346 | 2012-10-12 00:00:00 | 3 | 14.25 |  |  | 2 | [NAME] | 75
EP-685 | 10495 | 2012-10-12 00:00:00 | 3 | 23.75 |  |  | 3 | [NAME] | 100
RE-501 | 10384 | 2012-10-12 00:00:00 | 4 | 13.75 |  |  | 4 | [NAME] | 90
 |  |  | TOTAL |  | TOTAL
Spreadsheet: 4ec44d6a-6137-4345-9cf0-c90b58e65dc9
Sheet: 10b

Product | EUR** | GBP | [NAME] | USD | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A
Estimated net notional amount outstanding, October 25 weekly snapshot, by product type and supermajor currency (millions of USD), cleared swaps only, all participant types and tenors.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for currency descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 808542d1670511240-2-formulas-subtract-from-specific-columns-formulatest
Sheet: Data

Department | Name | Target | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00
DepC | Person19 | 68
DepC | Person21 | 9
DepC | Person23 | 4987
DepC | Person25 | 9848
DepC | Person27 | 18
[NAME] | [NAME] | 897
[NAME] | Person22 | 598
[NAME] | Person24 | 98
[NAME] | Person26 | 99
[NAME] | Person28 | 9
DeptA | Person1 | 1750
DeptA | Person1 | 1750
DeptA | Person1 | 1750
DeptA | Person11 | 1255
DeptA | [NAME] | 654
DeptA | Person15 | 651
DeptA | Person17 | 651
DeptA | Person7 | 2485
DeptA | Person9 | 251
DeptB | Person1 | 1750
DeptB | Person10 | 25455
DeptB | Person12 | 255
DeptB | Person14 | 654
DeptB | Person16 | 651
DeptB | Person18 | 651
DeptB | Person2 | 1300
DeptB | Person6 | 1250
DeptB | Person8 | 2552
Spreadsheet: 0a3354a0-0890-44bd-a508-d6e7c890ae93
Sheet: College - Avts

.
 |  |  |  |  |  |  | Return to Index
Enrolled Minutes Calculator
College - AVTS
 |  |  |  |  |  |  |  | Example
Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday
 | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins |  | Begin | End | Mins
Col Algebr | 08:00:00 | 08:50:00 |  |  |  |  |  | Col Algebr | 08:00:00 | 08:50:00 |  |  |  |  |  | Col Algebr | 08:00:00 | 08:50:00
 |  |  |  |  |  |  |  | [NAME] | 06:30:00 | 09:30:00
 |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00
 |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00 |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0:00:00
 |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes |  |  |  | Total Minutes
 |  | Minutes per Day
Spreadsheet: 712929d1610479132-possible-vlookup-formula-fy21-resource-management
Sheet: FTE Calcs

Project | Category | Status | PM | Start Date | End Date | Work Days | Associate | Total Hours | FTE | 1/1/2021 | 2/1/2021 | 3/1/2021
ASA Replacement |  |  |  |  |  |  | [NAME]
DMVPN Replacement - CLQ |  |  |  |  |  |  | [NAME]
General [NAME] |  |  |  |  |  |  | [NAME]
General App |  |  |  |  |  |  | [NAME]
General [NAME] |  |  |  |  |  |  | [NAME]
General Servers |  |  |  |  |  |  | [NAME]
General [NAME] |  |  |  |  |  |  | [NAME]
General Telecommunications |  |  |  |  |  |  | [NAME]
[NAME] |  |  |  |  |  |  | [NAME]
PC Refresh |  |  |  |  |  |  | [NAME]
Phone Refresh |  |  |  |  |  |  | [NAME]
RBCV Phone System |  |  |  |  |  |  | [NAME]
RSCV Nurse Call |  |  |  |  |  |  | [NAME]
Security Systems (LMCV) |  |  |  |  |  |  | [NAME]
Security Systems (TELP) |  |  |  |  |  |  | [NAME]
Track-It |  |  |  |  |  |  | [NAME]
Umbrella Revamp |  |  |  |  |  |  | [NAME]
Wireless Upgrade - Meraki ([NAME], LMCV, THCV, HPCV) |  |  |  |  |  |  | [NAME]
WVEL on MPLS |  |  |  |  |  |  | [NAME]
Total
Spreadsheet: 117509d1312834836-formula-version-issue-787364-formula-version-issue
Sheet: Sheet1

Date | Salesperson
2010-01-01 00:00:00 | D |  | 2011
2010-01-02 00:00:00 | D |  | Salesperson | January | February | March | April | May | June | July | August | September | October | November | December
2010-02-08 00:00:00 | D |  | A
2010-02-08 00:00:00 | D |  | B
2010-03-31 00:00:00 | D |  | C
2011-01-01 00:00:00 | A |  | D
2011-01-02 00:00:00 | B |  | E
2011-02-08 00:00:00 | A
2011-02-08 00:00:00 | C
2011-03-31 00:00:00 | B
2012-01-01 00:00:00 | E
2012-01-02 00:00:00 | E
2012-02-08 00:00:00 | E
2012-02-08 00:00:00 | E
2012-03-31 00:00:00 | E
Sample Year List
2010
2011
2012