tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41987d1240520490-vacation-accrual-copy-of-2009-20vacation-20calendar-20calculation-20test-1-
Sheet: Vacation Time

Vacation Time 2009
Employee | Last | First | Start | # years | Accrual | Hours | Total Entitled |  | Date(s) | Hours | Date(s) | Hours | Date(s) | Hours | Total | Balance
Number | Name | Name | Date | of service | Rate | Earned | # weeks | # hours | Taken | Used | Taken | Used | Taken | Used | Used | Remaining
1 | Doe | [NAME] | 2007-01-08 00:00:00 | 2.291354897710856 | 1.538 | 24.608 | 2 | 80 |  |  |  |  |  |  | 0 | 80 | 24.60799980163574
2 | Doe | [NAME] | 2003-10-06 00:00:00 | 5.549397334398057 | 2.307 | 36.912 | 3 | 120 |  |  |  |  |  |  | 0 | 120 | 36.9119987487793
3 | Doe | [NAME] | 2007-05-21 00:00:00 | 1.927220743022287 | 1.538 | 24.608 | 2 | 80 | 2009-01-28 00:00:00 | 8 | 2009-03-18 00:00:00 | 8 | 2009-04-01 00:00:00 | 8 | 24 | 56 | 24.60799980163574
4 | Doe | [NAME] | 2007-07-09 00:00:00 | 1.793066054452814 | 1.538 | 24.608 | 2 | 80 | 2009-02-11 00:00:00 | 7 |  |  |  |  | 7 | 73 | 24.60799980163574
5 | Doe | Mark | 2005-11-25 00:00:00 | 3.411135869647886 | 1.538 | 24.608 | 2 | 80 |  |  |  |  |  |  | 0 | 80 | 24.60799980163574
6 | Doe | [NAME] | 2008-03-04 00:00:00 | 1.138719716328242 | 1.538 | 24.608 | 2 | 80 | 3/19-3/20 | 16 | 3/23-3/25 | 24 |  |  | 40 | 40 | 17.79685592651367
7 | Doe | Adam | 2001-04-27 00:00:00 | 2.483004452810103 | 1.538 | 24.608 | 2 | 80 | 2009-01-02 00:00:00 | 8 | 1/20-1/21 | 16 |  |  | 24 | 56 | 36.9119987487793
8 | Doe | [NAME] | 2006-10-30 00:00:00 | 7.991560236519891 | 2.307 | 36.912 | 3 | 120 | 2009-01-27 00:00:00 | 8 | 2009-03-24 00:00:00 | 8 |  |  | 16 | 104 | 24.60799980163574
9 | Doe | [NAME] | 2000-10-16 00:00:00 | 8.519965438436387 | 2.307 | 36.912 | 3 | 120 |  |  |  |  |  |  | 0 | 120 | 36.9119987487793
10 | Doe | [NAME] | 2008-10-29 00:00:00 | 0.4843733782036694 | 0.769 | 12.304 | 1 | 40 | 2009-03-13 00:00:00 | 8 | 3/23-3/27 | 16 |  |  | 24 | 16 | 12.30399990081787
11 | Doe | Pam | 2004-04-02 00:00:00 | 5.05932204350141 | 2.307 | 36.912 | 3 | 120 |  |  |  |  |  |  | 0 | 120 | 26.91499900817871
12 | Doe | [NAME] | 2006-07-11 00:00:00 | 2.786905890181766 | 1.538 | 24.608 | 2 | 80 |  |  |  |  |  |  | 0 | 80 | 24.60799980163574
13 | Doe | [NAME] | 2004-03-08 00:00:00 | 5.127768313179713 | 2.307 | 36.912 | 3 | 120 | 2009-01-29 00:00:00 | 8 | 2009-04-10 00:00:00 | 8 | 2009-04-10 00:00:00 | 8 | 24 | 96 | 29.66142845153809
14 | Doe | [NAME] | 2005-05-31 00:00:00 | 3.8984733097574 | 1.538 | 24.608 | 2 | 80 | 2/2-2/6 | 20 | 2009-02-28 00:00:00 | 10 |  |  | 30 | 50 | 24.60799980163574
15 | Doe | [NAME] | 2000-02-07 00:00:00 | 9.209903836793677 | 2.307 | 36.912 | 3 | 120 | 2009-03-02 00:00:00 | 8 | 2009-03-09 00:00:00 | 8 | 2009-03-09 00:00:00 | 8 | 24 | 96 | 36.91200256347656
16 | Doe | [NAME] | 2008-10-14 00:00:00 | 0.525441140010651 | 0.769 | 12.304 | 1 | 40 | 1/26-1/28 | 24 |  |  |  |  | 24 | 16 | 12.30399990081787
17 | Doe | Greg | 2004-05-10 00:00:00 | 4.955283713590391 | 1.538 | 24.608 | 2 | 80 |  |  |  |  |  |  | 0 | 80 | 24.60799980163574
18 | Doe | Betty | 2009-04-20 00:00:00 | 0.01072519202981591 | 0.769 | 12.304 | 1 | 40 |  |  |  |  |  |  | 0 | 40 | 12.30399990081787
Spreadsheet: 756540d1637620230-retrieve-hours-worked-based-on-day-of-week-in-rota-gamersheek-rota
Sheet: December 22

` | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00 | 2021-12-12 00:00:00 | 2021-12-13 00:00:00 | 2021-12-14 00:00:00 | 2021-12-15 00:00:00 | 2021-12-16 00:00:00 | 2021-12-17 00:00:00 | 2021-12-18 00:00:00 | 2021-12-19 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-25 00:00:00 | 2021-12-26 00:00:00 | 2021-12-27 00:00:00 | 2021-12-28 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00 |  | Total Hours
[NAME]
Scott
Adam
 | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT | SUN | MON | TUE | WED | THU | FRI | SAT
 | 2021-12-01 00:00:00 | 2021-12-02 00:00:00 | 2021-12-03 00:00:00 | 2021-12-04 00:00:00 | 2021-12-05 00:00:00 | 2021-12-06 00:00:00 | 2021-12-07 00:00:00 | 2021-12-08 00:00:00 | 2021-12-09 00:00:00 | 2021-12-10 00:00:00 | 2021-12-11 00:00:00 | 2021-12-12 00:00:00 | 2021-12-13 00:00:00 | 2021-12-14 00:00:00 | 2021-12-15 00:00:00 | 2021-12-16 00:00:00 | 2021-12-17 00:00:00 | 2021-12-18 00:00:00 | 2021-12-19 00:00:00 | 2021-12-20 00:00:00 | 2021-12-21 00:00:00 | 2021-12-22 00:00:00 | 2021-12-23 00:00:00 | 2021-12-24 00:00:00 | 2021-12-25 00:00:00 | 2021-12-26 00:00:00 | 2021-12-27 00:00:00 | 2021-12-28 00:00:00 | 2021-12-29 00:00:00 | 2021-12-30 00:00:00 | 2021-12-31 00:00:00
[NAME]
Scott
Adam
Spreadsheet: 258792d1376854846-adult-baseball-league-schedule-2013spring-schedule-5-
Sheet: MUDCATS

week # | Visitors | Home | Field
8 | BAYSOX | MUDCATS | CCC
2 | KEYS | MUDCATS | CCC
6 | REDWINGS | MUDCATS | LBU
10 | ROCKCATS | MUDCATS | CCC
4 | SENATORS | MUDCATS | CCC
1 | MUDCATS | BAYSOX | LBU
5 | MUDCATS | BYE
9 | MUDCATS | KEYS | CCC
3 | MUDCATS | ROCKCATS | GHS
7 | MUDCATS | SEADOGS | GHS
Spreadsheet: 726701d1617378915-need-help-with-countif-formula-sample_time_ledger
Sheet: April

 | Time Ledger |  |  |  |  |  | 2021
 | Totals | Days Worked This Month | Total Month Entries | Total After-Hours Entries | Filtered Timeframe Total | Daily Average This Month | Total Time Logged This Month
 |  | 2021-04-01 00:00:00 |  |  |  |  | 0.75
 |  | 2021-04-01 00:00:00 |  |  |  |  | 0.75
 |  | 2021-04-01 00:00:00 |  |  |  |  | 4
 |  | 2021-04-01 00:00:00
 |  | 2021-04-02 00:00:00 |  |  |  |  | 1
 |  | 2021-04-02 00:00:00 |  |  |  |  | 2
 |  | 2021-04-02 00:00:00 |  |  |  |  | 3
 |  | 2021-04-02 00:00:00 |  |  |  |  | 4
 |  | 2021-04-02 00:00:00
 |  | 2021-04-03 00:00:00
 |  | 2021-04-03 00:00:00
 |  | 2021-04-03 00:00:00
 |  | 2021-04-04 00:00:00
 |  | 2021-04-04 00:00:00
 |  | 2021-04-04 00:00:00
 |  | 2021-04-04 00:00:00
 | TOTALS
Spreadsheet: 134792d1325631576-lookup-on-first-five-char-lookup-on-value
Sheet: Shindel

Dr Shindel
CPT | Count | wRVU |  |  | Modifiers
43235 | 41 |  |  |  | 25 | No Effect
43236 | 1 |  |  |  | 33 | No Effect
43239 | 304 |  |  |  | 51 | 0.5
43244 | 11 |  |  |  | 53 | Discontinued
43245 | 0 |  |  |  | 59 | No Effect
43246 | 15 |  |  |  | AG | No Effect
43247 | 6 |  |  |  | GW | No Effect
43248 | 126 |  |  |  | PT | No Effect
43249 | 15
43251 | 9
43255 | 11
43256 | 0
43260 | 3
43261 | 2
43262 | 25
43264 | 21
43268 | 24
43269 | 17
43271 | 7
43760 | 3
45330 | 1
45331 | 4
45338 | 1
45345 | 0
45378 | 582
45380 | 65
45381 | 60
45382 | 3
45384 | 1006
45385 | 213
45386 | 1
46221 | 6
46606 | 1
46611 | 1
49440 | 0
91110 | 8
99070 | 1
99201 | 1
99202 | 2
99203 | 51
99204 | 230
99205 | 2
99212 | 12
99213 | 281
99214 | 1871
99215 | 37
99219 | 0
99221 | 0
99222 | 37
99231 | 121
99232 | 502
99233 | 26
99234 | 0
99242 | 1
99243 | 12
99244 | 40
99245 | 3
99253 | 1
99254 | 0
99255 | 0
99282 | 0
99283 | 2
99284 | 1
99285 | 1
99304 | 1
99304 | 1
99305 | 1
99306 | 1
99307 | 27
99308 | 5
99309 | 0
43235-53 | 0
43235-gw | 0
43236-59 | 1
43239-51 | 0
43239-59 | 0
43239-ag | 2
43246-53 | 0
43249-59 | 0
43255-59 | 2
43260-53 | 2
43262-53 | 0
43262-ag | 1
43264-51 | 1
43268-51 | 1
43268-59 | 0
43269-53 | 0
43760-59 | 0
45330-53 | 0
45330-59 | 0
45332-53 | 0
45378-33 | 0
45378-51 | 1
45378-53 | 9
45378-59 | 1
45378-ag | 1
45380-33 | 2
45380-53 | 3
45380-59 | 0
45380-ag | 0
45380-gw | 0
45380-pt | 4
45381-59 | 1
45382-59 | 4
45382-gw | 0
45384-33 | 93
45384-53 | 1
45384-ag | 2
45384-pt | 67
45385-33 | 17
45385-53 | 1
45385-ag | 1
45385-pt | 22
99212-25 | 0
99213-25 | 0
99214-25 | 0
99214-gw | 1
99215-25 | 5
99219-25 | 2
99221-25 | 1
99221-gw | 1
99222-25 | 11
99223-25 | 17
99231-25 | 1
99232-25 | 3
99232-gw | 2
99233-25 | 1
99253-25 | 0
99254-25 | 0
99255-25 | 0
99284-25 | 0
99304-25 | 0
G0105 | 3
G0121 | 32
G0121-53 | 2
G8553 | 9
Totals
Spreadsheet: 134275d1325167577-macro-one-row-to-multiple-rows-example-excel
Sheet: Sheet1

Example
Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | City | Position | Date From | Date untill | City | Position | Date From | Date untill | City | Position | Date From | Date untill | City | Position | Date From | Date untill
Person a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 2 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 4 | 4
Person b |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8
Person c |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 9 | 9 | 9 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11 | 12 | 12 | 12 | 12
Spreadsheet: 860238d1708420447-if-formula-to-read-if-dropdown-matches-table-brings-it-into-another-table-at-top-sample
Sheet: Sheet1

Field One |  | Lookup & Return Table |  | Table I want formula to rad
NSW |  | Jurisdiction |  | Read formula
 |  | ACT |  |  |  |  |  |  | Where ever the text is in Column C, I need it to star here in column E
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | ACT
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NSW
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | NT
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | QLD
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
 |  | SA
Spreadsheet: darrell_schoolcraft__7326__imball0202
Sheet: DEFS

 | 23995 |  | 22051
 | 59687 |  | 10703
Day | Measured | Scheduled | Measured | Scheduled | Totals
1 |  |  | 34592 | 34133
2 |  |  | 34669 | 34133
3 |  |  | 34620 | 33692
4 |  |  | 34664 | 34133
5 |  |  | 34596 | 34133
6 |  |  | 34635 | 33999
7 |  |  | 34649 | 34133
8 |  |  | 34575 | 34133
9 |  |  | 34720 | 34133
10 |  |  | 34749 | 34133
11 |  |  | 34735 | 34133
12 |  |  | 34268 | 34133
13 |  |  | 34544 | 34133
14 |  |  | 34736 | 34133
15 |  |  | 34466 | 34133
16 |  |  | 34378 | 34133
17 |  |  | 33610 | 34133
18 |  |  | 34219 | 34133
19 |  |  | 35314 | 34133
20 |  |  | 35347 | 34133
21 |  |  | 35428 | 34133
22 |  |  | 35215 | 34133
23 |  |  | 35358 | 34133
24
25
26
27
28
29
30 |  |  |  |  |  |  | CBS Volume | 23995 | 22051
31 |  |  |  |  |  |  |  | -183967 | -149923
2002-01-31 00:00:00 | Balance | -1035385.61 |  | -616208.42
2002-02-23 00:00:00 | Balance
 |  |  |  | Contract #
 |  |  |  | 22864 | 0 | Zia |  |  | 22864
 |  |  |  | 20379 | -51695.87 | Grayco/Artesia |  |  | 20379 | 2979
 |  |  |  | 26357 |  | [NAME] |  |  | 26357
 |  |  |  | 21544 | 61340.16 | [NAME], [NAME] |  |  | 21544 | 36108
 |  |  |  | 24532 | -1167820 | 500211,500212,500219,500230 - Coburn points |  |  | 24532 | -154244
 |  |  |  | Duke
20379
24532
21544
26357
22864
23995
22051
21665
22664
24361
26393
24268
Spreadsheet: 709562d1608391157-change-formula-to-ignore-hidden-tabs-programme-test
Sheet: Block 4

Item Name | Price | 52 | 53 | 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 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | Total | Totals
Product 1 | 0.05
Product 2 | 0.1
Product 3 | 0.15
Product 4 | 0.2
Product 5 | 0.25
Product 6 | 0.3
Product 7 | 0.35
Product 8 | 0.4
Product 9 | 0.45
Product 10 | 0.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | @ |  | 0.0001 |  |  |  |  |  | Pol:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | + 20% VAT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block | Area | Area | Perimeter (glass/path)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 1 | 23490 | A | 950
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 2 | 6441 | B | 840
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 3 | 5698 | C | 420
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 4 | 8728 | D | 1120
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 5 | 2508 | E | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 6 | 13440 | F | 760
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 7 | 14976 | G | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 8 | 14940 | H | 820
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 9 | 5455 | I | 430
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Block 10 | 5698 | J | 430
Spreadsheet: 862561d1710254720-formula-result-does-not-hold-value-when-referenced-by-another-formula-resulting-in-a-0-progress
Sheet: Progress

TD1599-001 Health & Safety for Employees Only one time | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
 | January
 | February
 | March
Spreadsheet: 688892d1596007176-calculating-work-time-from-all-job-elements-up-to-specific-qty-of-finished-product-book1
Sheet: Sheet1

 |  |  | MANIFEST |  |  |  |  |  |  | WORK JOURNAL
DATE | PRODUCT | QTY | STAFF | COST PER BIT | Weird metric that I need to follow | WORK TIME |  | DATE | PRODUCT | JOB ELEMENT | QTY | STAFF | WORK TIME
2020-07-27 00:00:00 | PRODUCT 1 | 5000 | 6 | =(G4*0.21*D4)/C4 | =G4/D4 | =6*270+3*120+3*200+4*150 |  | 2020-06-23 00:00:00 | PRODUCT 1 | FILLING | 6100 | 6 | 330
 |  |  |  |  |  |  |  | 2020-06-25 00:00:00 | PRODUCT 1 | LABELLING | 5500 | 3 | 120
 |  |  |  |  |  |  |  | 2020-06-25 00:00:00 | PRODUCT 1 | CODING | 4000 | 3 | 200
 |  |  |  |  |  |  |  | 2020-06-25 00:00:00 | PRODUCT 1 | ASSEBMLING | 5100 | 4 | 150
 | * | 0.21 | COST OF MINUTE OF LABOUR |  |  |  |  | 2020-07-27 00:00:00 | PRODUCT 1 | REWORK | 500 | 3 | 30
Spreadsheet: 846518d1697696766-lookup-value-with-2-different-parameters-archers-records-1
Sheet: HANDICAPS

 | 0 | 1 | 2 | 3 | 4 | 5 | 6
York | 1284 | 1281 | 1279 | 1276 | 1272 | 1268 | 1264
Hereford / Bristol I | 1295 | 1294 | 1294 | 1293 | 1292 | 1290 | 1289
Bristol II | 1296 | 1296 | 1296 | 1296 | 1296 | 1296 | 1296
Bristol III | 1296 | 1296 | 1296 | 1296 | 1296 | 1296 | 1296
Bristol IV | 1296 | 1296 | 1296 | 1296 | 1296 | 1296 | 1296
Bristol V | 1296 | 1296 | 1296 | 1296 | 1296 | 1296 | 1296
St. George | 966 | 965 | 963 | 961 | 959 | 957 | 955
Albion | 972 | 971 | 971 | 971 | 970 | 969 | 969
Windsor | 972 | 972 | 972 | 972 | 972 | 972 | 972
Spreadsheet: 128935d1321364853-of-a-currency-masond3-percents
Sheet: Sheet1

 |  |  | Field TCV  Summary |  | docs |  |  |  |  | % docs | % £
 |  |  | Qualfied | 1822821.16 | 213
 |  |  | Docs out | 394238 | 42
 |  |  | Docs in | 197574 | 34
 |  |  | Sent to risk | 1783619 | 178
 |  |  | Approved by risk | 2664309.71 | 453
 |  |  | Direct live transactions | 5286741.599999999 | 748
 |  |  | total | 12149303.47 | 1668
Spreadsheet: 152459d1335387268-do-nothing-or-leave-as-is-formula-for-rolling-totals-do-nothing-rolling-total-
Sheet: Data entry

Material use by month for 12-month period
Enter production below by updating the year (column A) and production amount (Column C).  When you've reached the end (row 29), roll back and start over at row 6.
Year | Month | Production (tons) | Previous 12-month total
2012 | January | 25000
2010 | February | 25000 |  |  | <-- I tried this formula in D7 "=IF(A7>=A6,SUM(C6:C7)+SUM(C20:C29),D7)", but it's a circular reference, so it doesn't seem to work.
2010 | March | 25000
2010 | April | 25000
2010 | May | 25000
2010 | June | 25000
2010 | July | 25000
2010 | August | 25000
2010 | September | 10000
2010 | October | 10000
2010 | November | 10000
2010 | December | 25000
2011 | January | 12000
2011 | February | 17000
2011 | March | 18000
2011 | April | 30000
2011 | May | 22000
2011 | June | 18000
2011 | July | 10000
2011 | August | 4000
2011 | September | 2000
2011 | October | 15000
2011 | November | 25500
2011 | December | 17225
Explanation:
Businesses need to keep a rolling annual total of their production (sum of most current previous 12 months), while maintaining two years worth of data.   Once they reach the end (December 2011), they roll back up to the top and replace January 2010 data with January 2012 and so on, so that the most current two years worth of data is always listed.    I would like to find a way to have column D add up the previous 12 months of data ONLY if the year in column A has been updated (for example, [NAME]). Otherwise, it would leave the value in Column D alone. (This would satisfy the requirement of keeping two years worth of totals).  I'm not sure if a macro would work for this (I have limited experience with macros).  You can see what I tried above, but I get a circular reference warning.
Thanks for any help or ideas you have!
Spreadsheet: rick_buy__32699__0608 summary of issues
Sheet: summary 0528

SUMMARY BY WEEK FOR  05/28-06/01
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation |  |  |  |  |  |  |  | 1
C |  | Breakdown in Officializing Process- Human
D1 |  | Breakdown in Officializing Process- IT (UK)
D2 |  | Breakdown in Officializing Process- IT (US)
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change
G |  | Miscellaneous
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM |  |  |  |  |  |  |  |  |  | —
EGM |  |  |  |  |  |  |  | 1 |  | Not utilizing the Active/Inactive website to see if book was officialized.
EEL |  |  |  |  |  |  |  | 8 |  | Having various problems sending files over due to technical difficulties.
EA-CAN |  |  |  |  |  |  |  |  |  | —
EA - GAS |  |  |  |  |  |  |  | 4 |  | Books not properly officialized
EA - POWER |  |  |  |  |  |  |  | 2 |  | Due to work in South America Model spreadsheet make-up altered, which caused linked formulas to pull incorrect deal valuation
EES |  |  |  |  |  |  |  |  |  | —
EBS |  |  |  |  |  |  |  | 2 |  | Book not properly officialized.
TOTAL ISSUES
Spreadsheet: 46281265-0889-4f8c-848a-db97801ab528
Sheet: Sheet1

Table 4--Cottonseed:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
 |  | Supply |  |  |  |  | Disappearance
Year begin. | Beginning |  |  |  |  |  |  |  |  | Ending
Aug. 1 | stocks | Production | Imports | Total |  | Crush | Exports | Other | Total | stocks
 |  |  |  | 1,000 short tons
2010/11 | 341.601 | 6098.1 | 0 | 6439.701 |  | 2562.55107 | 275.111 | 2984.47593 | 5822.138 | 617.563
2011/121 | 617.563 | 5370 | 100 | 6087.563 |  | 2400 | 135 | 3122.563 | 5657.563 | 430
2012/132 | 430 | 5985 | 0 | 6415 |  | 2500 | 300 | 3115 | 5915 | 500
1 Estimated.  2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and U.S. Department of Commerce,
U.S. Census Bureau, Foreign Trade Statistics.
Last update: | 2012-06-13 16:27:59.740000
Spreadsheet: 91174d1290909796-condense-text-found-in-a-cell-fathead-template-csvi-by-hobstar
Sheet: RawData

PROGRAMNAME | PROGRAMURL | CATALOGNAME | LASTUPDATED | NAME | KEYWORDS | [NAME] | SKU | MANUFACTURER | MANUFACTURERID | UPC | ISBN | CURRENCY | SALEPRICE | PRICE | RETAILPRICE | FROMPRICE | BUYURL | IMPRESSIONURL | IMAGEURL | [NAME] | THIRDPARTYID | [NAME] | AUTHOR | ARTIST | TITLE | PUBLISHER | LABEL | FORMAT | SPECIAL | GIFT | PROMOTIONALTEXT | STARTDATE | ENDDATE | OFFLINE | ONLINE | INSTOCK | CONDITION | WARRANTY | STANDARDSHIPPINGCOST
[NAME] | http://www.fathead.com | Product Catalog | 2010-07-09 00:00:00 | [NAME] | Fathead Sports,college,CFB,Michigan Wolverines,[NAME] | [NAME] | 12-20374 |  |  |  |  | USD |  | 99.99 |  |  | http://www.kqzyfj.com/click-2803789-10446817?url=http%3A%2F%2Fwww.fathead.com%2Fcollege%2Fmichigan-wolverines%2Fdesmond-howard-michigan%2F | http://www.lduhtrp.net/image-2803789-10446817 | http://content.fathead.com/product_images/12-20374.jpg | fathead-sports/college/cfb/Michigan Wolverines |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
[NAME] | http://www.fathead.com | Product Catalog | 2010-04-10 00:00:00 | [NAME] Super Bowl Moment Mural | Fathead Sports,nfl,NFC,Arizona Cardinals,[NAME] Super Bowl Moment Mural | [NAME] Super Bowl Moment Mural | 12-20429 |  |  |  |  | USD |  | 99.99 |  |  | http://www.kqzyfj.com/click-2803789-10446817?url=http%3A%2F%2Fwww.fathead.com%2Fnfl%2Farizona-cardinals%2Flarry-fitzgerald-super-bowl-moment-mural%2F | http://www.lduhtrp.net/image-2803789-10446817 | http://content.fathead.com/product_images/12-20429.jpg | fathead-sports/nfl/nfc/Arizona Cardinals |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
[NAME] | http://www.fathead.com | Product Catalog | 2010-03-11 00:00:00 | [NAME] Clippers Logo | Fathead Sports,nba,NBAW,Los Angeles Clippers,[NAME] Clippers Logo | [NAME] Clippers Logo | 89-00182 |  |  |  |  | USD |  | 14.99 |  |  | http://www.tkqlhce.com/click-2803789-10446817?url=http%3A%2F%2Fwww.fathead.com%2Fnba%2Flos-angeles-clippers%2Ffathead-teammate-los-angeles-clippers-logo%2F | http://www.lduhtrp.net/image-2803789-10446817 | http://content.fathead.com/product_images/89-00182.jpg | fathead-sports/nba/nbaw/Los Angeles Clippers |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes
[NAME] | http://www.fathead.com | Product Catalog | 2010-07-09 00:00:00 | [NAME] Georgia | Fathead Sports,college,CFB,[NAME],[NAME] Georgia | [NAME] Georgia | 12-20368 |  |  |  |  | USD |  | 99.99 |  |  | http://www.jdoqocy.com/click-2803789-10446817?url=http%3A%2F%2Fwww.fathead.com%2Fcollege%2Fgeorgia-bulldogs%2Fmatthew-stafford-georgia%2F | http://www.lduhtrp.net/image-2803789-10446817 | http://content.fathead.com/product_images/12-20368.jpg | fathead-sports/college/cfb/[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Yes