tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 273109d1382615858-compare-number-and-color-cell-if-biger-or-smaller-work-hours
Sheet: Operator

 | Id Badge | Opt | Camp | Turno(ore) | 2013-01-10 00:00:00 | 2013-02-10 00:00:00 | 2013-03-10 00:00:00 | 2013-04-10 00:00:00 | 2013-05-07 00:00:00 | 2013-07-10 00:00:00 | 2013-08-10 00:00:00 | 2013-09-10 00:00:00 | 2013-10-10 00:00:00 | 2013-11-10 00:00:00 | 2013-12-10 00:00:00 | [NAME] | 15/10/2013 | 16/10/2013 | 17/10/2013 | [NAME] | 19/10/2013 | 21/10/2013 | 22/10/2013 | 23/10/2013 | 24/10/2013 | 25/10/2013 | 26/10/2013 | 28/10/2013 | 29/10/2013 | 30/10/2013 | 31/10/2013 | Grand Total | Ore Dovute | Diferenza | Note | 15/10/2013
 | 733 | ADMIR | REDARROW ULL | 4 | 4 | 4 | 4 | 4 | 0 | 4 | 4 | 4 | 4 | 4 | 0 | 4 | 0 | 4 | 4 | 4 | 0 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 959 | AINUR | REDARROW ULL | 3 | 3 | 2.5 | 0 | 2.5 | 2 | 1.5 | 2 | 3 | 1.5 | 2.5 | 2 | 4 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Licenziamento | 2
 | 959 | KASEMI | H3G TLS | 3 | 1 | 1.5 | 2 | 2 | 0 | 0 | 0 | 1 | 1.5 | 1.5 | 0 | 1 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Licenziamento | 1
 | 300 | SAJMIR | H3G TLS | 4 | 4 | 4 | 4 | 3.5 | 0 | 3 | 3.5 | 3 | 4 | 4 | 0 | 4 | 0 | 4 | 0 | 3 | 0 | 4 | 3.5 | 4 |  |  |  |  |  |  |  |  |  |  |  | 0
 | 700 | LINDITA | REDARROW ULL | 4 | 0 | 2 | 6 | 4 | 0 | 6 | 6 | 6 | 6 | 4 | 0 | 4 | 0 | 4 | 4 | 4.5 | 0 | 4 | 4 | 4 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  | 0 | 0
 |  | Tot Ore x gg
 |  | Fte X GG
Spreadsheet: 854365d1704275932-checking-each-field-taking-data-from-latest-field-and-adding-to-one-specific-cell-dummy
Sheet: W5

IDs (Week 5 data (Week 13 since letter)) |  |  |  |  |  |  |  |  | IDs (Week 3 data (Week 15 since letter)) |  |  |  |  |  |  |  |  |  | IDs (Week 1 data (Week 17 since letter))
Group 1 | Group 2 |  |  |  | Group 3 |  |  |  | Group 1 | Group 2 |  |  |  | Group 3 |  |  |  |  | Group 1 | Group 2 |  |  |  | Group 3
No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date SMS Scheduled | SMS Status | Opted out? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | No Contact | IDs | Date SMS Scheduled | SMS Status | Opted out? | IDs | Date call made | Was Call Successful? | Was call rescheduled? | Opted out of receiving calls? | Total Scheduled | Total Delivered | TotaloOpted out | Total Clicks | Total calls made | Total Successful | Total Rescheduled | Total Opt out of calls
 |  |  |  |  | 9605931498 | 2024-07-13 00:00:00 |  |  |  |  |  |  |  | 6417973274 | 2024-07-15 00:00:00 |  |  |  |  |  |  |  |  | 3023178365 | 2023-07-17 00:00:00
Spreadsheet: 139178d1328116085-sum-values-from-one-collumn-according-to-values-from-another-one-excel-problem-sum
Sheet: Sheet1

Day | Stake | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | Sum all stakes from last "day 1" until yesterday
1 | 2 | 0 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 0
1 | 2 | 0 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 0
1 | 2 | 0 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 0
2 | 3 | False | 2 | False | False | False | False | False | False | False | False | False | False | False | False | False | 2
3 | 5 | False | False | 5 | False | False | False | False | False | False | False | False | False | False | False | False | 5
1 | 2 | 0 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 0
2 | 3 | False | 2 | False | False | False | False | False | False | False | False | False | False | False | False | False | 2
3 | 5 | False | False | 5 | False | False | False | False | False | False | False | False | False | False | False | False | 5
4 | 9 | False | False | False | 10 | False | False | False | False | False | False | False | False | False | False | False | 10
5 | 14 | False | False | False | False | 19 | False | False | False | False | False | False | False | False | False | False | 19
6 | 18 | False | False | False | False | False | 33 | False | False | False | False | False | False | False | False | False | 33
1 | 2 | 0 | False | False | False | False | False | False | False | False | False | False | False | False | False | False | 0
2 | 3 | False | 2 | False | False | False | False | False | False | False | False | False | False | False | False | False | 2
3 | 5 | False | False | 5 | False | False | False | False | False | False | False | False | False | False | False | False | 5
Columns A and B will be manually filled in. I need Column R to calculate sum of all stakes from last day one untill yesterday (that means value from today are not included). If value in Column A=1, sum of all previous days is 0.
This calculation works properly but it is too much complicated to fill it with more rows.. I need it untill 200-300 rows to be automatically calculated.
I hope it is possible to solve this formula in one column formula. (Maybe with "offset" function?) . The way I've used above is too complicated.
Any help will be appreciated. Thank you very much in advance.
Spreadsheet: 1acbc5b5-eba7-43ce-aba6-394b78c6d600
Sheet: THART

 | PROGRAM LEVEL | # | SLOs | # | ASSESSMENT METHOD DEFINED | # | ASSESSED  COURSE | # | DISCUSSION/ IMPROVEMENT | #
 | A.A. Degree Theatre Arts | 1 | X | 1
 | TOTAL
 | PERCENTAGE
 | COURSE
1 | THART 100 | 1 | X | 1 | X | 1 | 1 | 1 | 1 | 1
5 | THART 100 H
4 | THART 108 | 1 | X | 1
3 | THART 109 | 1 | X | 1 | X | 1 | X | 1
4 | THART 110 | 1 | X | 1 | X | 1 | X | 1
4 | THART 120 | 1 | X | 1 | X | 1 | X | 1
4 | THART 130X4 | 1
4 | THART 133 | 1
4 | THART 140X4 | 1 | X | 1 | X | 1 | X | 1
4 | THART 145X4 | 1 | X | 1 | X | 1 | X | 1
4 | THART 150X4 | 1 | X | 1 | X | 1
4 | THART 163X4 | 1
4 | THART 174X4 | 1 | X | 1 | X | 1
4 | THART 176X4 | 1 | X | 1 | X | 1
4 | THART 179X4 | 1 | X | 1 | X | 1 | X | 1
4 | THART 205 | 1 | X | 1 | X | 1
4 | THART 220 | 1 | X | 1 | X | 1 | X | 1
4 | THART 221 | 1 | X | 1 | X | 1 | X | 1
4 | THART 226 | 1 | X | 1
4 | THART 246X4 | 1
 | TOTAL
 | PERCENTAGE
Spreadsheet: 220043d1363038876-help-extracting-certain-portion-of-a-cell-pendingtransactions-template
Sheet: Batch

TxnType | Account | MerchantReference | CardNumber | ExpiryDate | Amount | PreAuthNumber | CPC | CarHolderName
Spreadsheet: 849815d1700200282-help-needed-plz-with-if-or-sumif-help-please
Sheet: Sheet4

Individual |  |  |  |  |  |  | -
Aiden |  |  |  |  |  |  | Aiden
 |  |  |  |  |  |  | [NAME]
 | Q1-2024 | Q2-2024 | Q3-2024
Value
Liklihood | Owner | Support | $$$$ | Period
Won | Aiden |  | 10000 | Q1-2024
Won | Aiden |  | 130196.7964511124 | Q1-2024
Won | Aiden |  | 6299.502276325147 | Q2-2024
Maybe | Aiden |  | 19528.45705660796 | Q2-2024
Maybe | [NAME] |  | 5000 | Q2-2024
Maybe | Aiden |  | 2200 | Q2-2024
Maybe | [NAME] |  | 84467.72040541077 | Q2-2024
Maybe | [NAME] |  | 152727.0356369143 | Q2-2024
Maybe | Aiden |  | 133322.6661761454 | Q2-2024
[NAME] | [NAME] |  | 317587.8827813814 | Q3-2024
[NAME] | [NAME] |  | 102274.7817694924 | Q3-2024
[NAME] | [NAME] |  | 224077.7560164972 | Q3-2024
Will Not Win | Aiden |  | 500 | Q2-2024
Will Not Win | Aiden |  | 27087.85978819813 | Q2-2024
Will Not Win | [NAME] |  | 1000 | Q2-2024
Will Not Win | Aiden |  | 25198.00910530059 | Q2-2024
Will Not Win | Aiden |  | 73215.58093695017 | Q2-2024
Maybe | Aiden |  | 22102.15650861425 | Q2-2024
Maybe | [NAME] |  | 25000 | Q2-2024
Won | [NAME] | [NAME] | 6855.716829813276 | Q1-2024
Won | [NAME] | [NAME] | 11592.93624210751 | Q1-2024
Won | [NAME] | Aiden | 7396.71808530408 | Q1-2024
Maybe | [NAME] | Aiden | 5000 | Q2-2024
Maybe | [NAME] | [NAME] | 5855.03459371675 | Q2-2024
 | If either B14 to B37 or C14 to C37 is equal to the indiviual in A2 then
 | I want to sum all the value against them in cell D14 to D37
 | but only if
 | E14 to E37 is the same as B4
 | A14 to A37 is the same says Won
 | A14 to A37 is the same says Maybe
 | A14 to A37 is the same says [NAME]
the formula I am trying
IF(or($B$14:$B$37=A2,$c$14:$c$37=A2,SUMIFS($D$14:$D$37,$E$14:$E$37,"Q1-2024",$A$14:$A$37,"Won",$A$14:$A$37,"Will Win",$A$14:$A$37,"Maybe"),0)))
Spreadsheet: 42048d1240589533-sumproduct-not-working-due-to-text-in-column-test-planners-2
Sheet: MGMT INFO

 | Management Information for: |  |  |  |  | 0
 | Clients | Competence |  |  |  |  |  |  |  |  |  |  |  |  | Total Per Client
 |  | TM | TCM | LO | COSS | HSM | LXA | PO | PC | ES | MC | CC | TL | SAC
 | Test Client | 6 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 10
 | 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 | 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 | 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 | 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 | 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
 | 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
 | Total Per Competence | 6 | 0 | 0 | 1 | 0 | 2 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 10
 | Trackworkers | 6
 | Safety Critical | 4
 | Other | 0
 | Clients | Shifts Cancelled |  | [NAME] |  |  | Clients |  | Hours Invoiced |  | Turnover |  | Gross Profit |  | GP Margin
 | Test Client | 0 |  | 0 |  |  | Test Client |  | 120 |  | 2064 |  | 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 |  | 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 |  | 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 |  | 0 |  |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 | Total: | 0 |  | 0 |  |  | Total: |  | 120 |  | 2064 |  | 0 |  | 0
Spreadsheet: 83bc0ec1-c77d-4624-89eb-e4b9b0a2b0ab
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
42770126 | 2014-08-18 02:10:35 | AXIS | 0 | 6 | 7 | 601280 | player601280 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42770312 | 2014-08-18 02:37:39 | ALLIES | 1 | 7 | 5 | 601280 | player601280 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
42770592 | 2014-08-18 03:04:53 | ALLIES | 0 | 6 | 7 | 382337 | Ace of Diamonds | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42770819 | 2014-08-18 03:25:52 | AXIS | 1 | 7 | 2 | 382337 | Ace of Diamonds | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
42794317 | 2014-08-19 20:35:31 | AXIS | 1 | 6 | 2 | 1600754 | Philthethrill | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42794522 | 2014-08-19 20:54:09 | ALLIES | 0 | 5 | 6 | 1600754 | Philthethrill | 7664 | pacific | 1944-07-25 | 1944-07-25 | Japanese Counterattack | Contre-attaque japonaise
42794793 | 2014-08-19 21:28:48 | ALLIES | 1 | 7 | 1 | 1623016 | Waldfee1 | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
42795250 | 2014-08-19 21:58:43 | ALLIES | 1 | 7 | 1 | 1623016 | Waldfee1 | 12495 | western | 1944-06-23 |  | Battle for Hill 178 | Combat pour la cote 178
42850507 | 2014-08-23 21:41:18 | AXIS | 0 | 4 | 6 | 1608932 | player1608932 | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
42867195 | 2014-08-24 23:37:54 | ALLIES | 1 | 6 | 1 | 1620635 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42867615 | 2014-08-25 00:16:02 | AXIS | 1 | 6 | 2 | 1620635 | [NAME] | 12504 | mediterranean | 1943-11-05 | 1943-11-13 | [NAME] | [NAME]
42907029 | 2014-08-27 20:26:34 | AXIS | 0 | 4 | 5 | 1392924 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42907327 | 2014-08-27 20:39:02 | ALLIES | 0 | 1 | 5 | 1392924 | [NAME] | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
42939748 | 2014-08-30 05:08:49 | ALLIES | 1 | 6 | 4 | 1452982 | SuluTubee | 12496 | eastern | 1942-07-23 | 1942-08-08 | Battle of Kalatch | Bataille de Kalatch
42940029 | 2014-08-30 05:34:49 | ALLIES | 1 | 6 | 5 | 780030 | keithdone | 12494 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
42940240 | 2014-08-30 06:03:06 | AXIS | 1 | 6 | 4 | 1594070 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
42940429 | 2014-08-30 06:26:50 | ALLIES | 1 | 6 | 3 | 1594070 | [NAME] | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
Spreadsheet: 685797d1594203565-cell-formts-in-a-pivot-table-2020-07-08-oeldere-rider2-685739d1594163835-cell-formts-in-a-pivot-table-kitting-tracking-r2
Sheet: XReport

Job No. | Customer | Date | TOTAL HRS.
123456 | Smith Co | 2020-06-05 00:00:00 | 25
 |  | 2020-06-06 00:00:00 | 41.5
 |  | 2020-06-07 00:00:00 | 12
 |  | 2020-06-16 00:00:00 | 42
 |  | 2020-06-17 00:00:00 | 115.5
 |  | 2020-06-18 00:00:00 | 52.5
 |  | 2020-06-19 00:00:00 | 52.5
 |  | 2020-06-20 00:00:00 | 42
 |  | 2020-06-21 00:00:00 | 57
 |  | 2020-06-22 00:00:00 | 73.5
 |  | 2020-06-23 00:00:00 | 42.49999999999999
 |  | 2020-06-24 00:00:00 | 63
 |  | 2020-06-25 00:00:00 | 52.5
Totaal 123456 |  |  | 671.5
456789 | Bobs Co | 2020-06-05 00:00:00 | 8.500000000000002
 |  | 2020-06-06 00:00:00 | 63.74999999999999
Totaal 456789 |  |  | 72.24999999999999
987654 | [NAME] | 2020-06-10 00:00:00 | 60
 |  | 2020-06-11 00:00:00 | 36.00000000000001
 |  | 2020-06-12 00:00:00 | 85.5
 |  | 2020-06-13 00:00:00 | 74.375
 |  | 2020-06-14 00:00:00 | 105
 |  | 2020-06-15 00:00:00 | 89.25
Totaal 987654 |  |  | 450.125
Eindtotaal |  |  | 1193.875
Spreadsheet: 1c537872-343a-44c3-b753-7447cc6e9597
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 30. LEASE FINANCE COMMITMENTS, By Industry: Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2420286X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2420287A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2420288C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2420289F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2420290R | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | A2420291T | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2420292V | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | A2420293W | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2420294X | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2420295A | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Public Administration ; |  |  | Original | A2420296C | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2420297F | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2420298J | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
TOTAL LEASE FINANCE ; |  |  | Original | A2420299K | 1985-01-01 00:00:00 | 2012-02-01 00:00:00 | 326 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2012
Spreadsheet: 221611d1363624030-extracting-matching-row-and-column-data-for-column-greater-than-0-dataextraction-from-table
Sheet: Jake Table

Charge # | Hours | Employee | Sum
 |  | [NAME]
Spreadsheet: 92727d1292278109-scroll-bar-wont-stop-scrolling-scroll-bar-example-working
Sheet: may_data

employee # | area | sales $
1111 | east | 54939.46953070728
1112 | east | 80585.0746377349
1113 | east | 64180.89232465576
1114 | east | 48590.58332005661
1115 | west | 48335.85733975578
1116 | west | 63638.73062854655
1117 | west | 48164.35235942445
1118 | northeast | 37094.58428026009
1119 | northeast | 88845.91123673113
1120 | northeast | 25952.70338918425
1121 | northeast | 53271.63515314881
1122 | northeast | 17221.87757235938
1123 | northwest | 70254.13379038294
1124 | northwest | 6536.589206951327
1125 | northwest | 76625.8369421978
1126 | southeast | 40655.59943768557
1127 | southeast | 84676.25099779796
1128 | southeast | 66518.64296540682
1129 | southeast | 83439.66487265204
1130 | southeast | 10071.06010238172
1131 | southeast | 93229.18080371078
1132 | southwest | 14499.35656097472
1133 | southwest | 24756.07635877522
1134 | southwest | 59513.34193331545
1135 | midwest | 33057.4473843837
1136 | midwest | 6934.869357189655
1137 | midwest | 13426.1401353788
Spreadsheet: 703916d1605226309-converting-data-into-a-monthly-calendar-format-visual-ef1416b_calendar_grid_complete
Sheet: Calendar

Year ==> | 2020
 |  | 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
 | January
 | February
 | March
 | April
 | May
 | June
 | July
 | August
 | September
 | October
 | November
 | December
Spreadsheet: 0057a4cd-6155-4726-92b7-3b732ed81941
Sheet: Sheet1

Colorado Department of Public Health and Environment | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Water Quality Control Division
Safe Drinking Water Program
REIMBURSEMENT INVOICE FORM
http://www.colorado.gov/cs/Satellite/CDPHE-Main/CBON/[PHONE]
 | Date of Invoice:
 | Invoice Period: |  | To:
 | Invoice #:
 | FEIN:
 | Agreement #:
 | Final Invoice: | Yes | No
Remit To: | [Name of CBU Project Manager] |  |  | Name of Payee: | [Name]
 | Colorado Department of Public Health and Environment |  |  |  | [Company Name]
 |  |  |  |  | [Street Address]
 | Water Quality Control Division |  |  |  | [City, St. Zip Code]
 | 4300 Cherry Creek Dr. [NAME] |  |  |  | [Phone]
 | Denver, CO 80246-1530 |  |  |  | [Fax]
 | Mail Stop: WQCD-CBU-B2 |  |  |  | [Email]
Invoice Details
Task | Task Description | Budgeted Total | Previously Billed to Date | % Complete | Funds Remaining | Amount Due
 |  | 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 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
Total |  | 0 | 0 | 0 | 0 | 0
 | To be Signed by Contractor/Vendor
 | I/We affirm the claimed expenses comply with the budget provisions of the contract and are reasonable and necessary, that all relevant progress or other reports have been timely filed, and all contract milestones and/or tasks related to the billing period have been achieved.
 | Signature & Title |  |  |  | Date
 | To be Signed by CDPHE Program Director or Delegate
 | I affirm that I or my staff have reviewed the contractor's invoice and supporting documentation (as required), progress reports and other communications with the contractor, and believe to the best of my knowledge, that the contractor is in compliance with all contract provisions.
 | Signature & Title |  |  |  | Date
 | To be Signed by CDPHE Fiscal Officer or Delegate
 | I certify that the claimed expenses have been reviewed by me for compliance with the requirements of the funding source and the State of Colorado Fiscal Rules, and are charged to the appropriate funding source.
 | Signature & Title |  |  |  | Date
 |  |  | v3.Oct2012
Spreadsheet: 761752d1641203154-dynamic-dropdown-in-excel-dnamic-dropdown-1-
Sheet: CoCo

 |  |  |  |  |  |  |  |  | CoCo | Acct
YEAR | MONTH | PARTNAME | SRCCoCo | TARGCoCo | ERP
2021 | Oct | 1C_LB_U005_FM | PR_OG00000153 | LB_U654 | 1C
2021 | Oct | 1C_LB_U005_FM | FSB_1 | LB_U317 | 1C
2021 | Oct | 1C_LB_U125_FM | T810 | LB_T810 | 1C
2021 | Oct | [NAME] | 215740_2505 | LB_1625 | BH
2021 | Oct | [NAME] | 520848_9001 | LB_9008 | BH
2021 | Oct | [NAME] | 89901000_1030 | LB_1030 | BH
2021 | Oct | IF1222_FM | 620662_2025 | LB_017F | BH
2021 | Oct | IF1222_FM | 370251_9001 | LB_9008 | BH
2021 | Oct | IF1222_FM | CHIADJ_9001 | LB_9008 | BH
2021 | Oct | [NAME] | 7140 | LB_7140 | DS
2021 | Oct | [NAME] | 5040 | LB_5040 | DS
2021 | Oct | [NAME] | 6080 | LB_6080 | DS
2021 | Oct | MC_SAP_FM | 6211 | LB_6210 | DS
2021 | Oct | MC_SAP_FM | 6210 | LB_6210 | DS
2021 | Oct | MC_SAP_FM | 6070 | LB_607X | DS
2021 | Oct | MC_SAP_FM | 5024 | LB_502X | DS
2021 | Oct | MC_SAP_FM | 5260 | LB_5260 | DS
2021 | Oct | MC_SAP_FM | 6047 | LB_6040 | DS
2021 | Oct | [NAME] | 5500 | LB_5500 | DS
2021 | Oct | [NAME] | 3000 | LB_3000 | DS
2021 | Oct | DTS_100173_FM | ADNUS | LB_T005 | [NAME]
2021 | Oct | DTS_100173_FM | OGI42 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | XXX88 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | N83 | LB_H002 | [NAME]
2021 | Oct | DTS_100173_FM | GHS1 | LB_H002 | [NAME]
2021 | Oct | [NAME] | CL044 | [NAME] | [NAME]
2021 | Oct | [NAME] | HSR02 | LB_T005 | [NAME]
2021 | Oct | PASCAL_ES_FM | LB_LH05 | LB_LH05 | Pascal