tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 174567d1345116334-combining-2-workbooks-workbook-1
Sheet: January

 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2012-12-30 00:00:00 | 2012-12-31 00:00:00 | 2013-01-01 00:00:00 | 2013-01-02 00:00:00 | 2013-01-03 00:00:00 | 2013-01-04 00:00:00 | 2013-01-05 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 40 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 27 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2013-01-06 00:00:00 | 2013-01-07 00:00:00 | 2013-01-08 00:00:00 | 2013-01-09 00:00:00 | 2013-01-10 00:00:00 | 2013-01-11 00:00:00 | 2013-01-12 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 41 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 28 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2013-01-13 00:00:00 | 2013-01-14 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-19 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 42 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 29 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
 |  |  |  |  |  |  |  |  | Sun | Mon | Tue | Wed | Thurs | Fri | Sat
 |  | Name | Grade | Term | Reason for Absence | Code | Contract Hours | Sick Hours
 |  |  |  |  |  |  |  |  | 2013-01-20 00:00:00 | 2013-01-21 00:00:00 | 2013-01-22 00:00:00 | 2013-01-23 00:00:00 | 2013-01-24 00:00:00 | 2013-01-25 00:00:00 | 2013-01-26 00:00:00
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Year week | 43 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
or |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
Financial week | 30 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Total Hours Lost | 0
 |  |  |  |  |  | Percentage of Workforce off |  | 0
Spreadsheet: jeff_dasovich__14097__Sempra Data
Sheet: Transport & Supply Agmts

SoCalGas & SDG&E Core Demand
Supply, Storage and Transport Contracts
Entity | Agreement | Counter- | Term | Quantity | Functionality
 | Type | Party
SoCalGas | Supply - Canada | ? | 2003 | ?
SDG&E | Storage | SoCalGas | 2001-03-01 00:00:00 | 6 Bcf | Inventory
SoCalGas | Transport | EPNG | 2006-09-01 00:00:00 | 744 MMcfd
SoCalGas | Transport | TW | 2005-10-31 00:00:00 | 300 MMcfd
SDG&E | Transport | EPNG | 2007-02-01 00:00:00 | 10 MMcfd
SDG&E | Transport | PG&E-NW | 2023-10-31 00:00:00 | 52 MMcfd
SoCalGas | Storage | SoCalGas | NA | 70 Bcf | Inventory
 |  |  |  | 327 MMcfd | Injection
 |  |  |  | 1,985 MMcfd | Withdrawal
SoCalGas | Storage | SoCalGas | NA | $50-59 MM | Revenue Requirement
SDG&E | Storage | SoCalGas | NA | $6 MM | Revenue Requirement
Spreadsheet: 60350d1260906320-auto-copy-part-of-row-in-a-worksheet-to-another-worksheet-based-on-criteria-case-assignments2010-temp
Sheet: April2010

 | Week 1 |  |  |  | Week 2 |  |  |  | Week 3 |  |  |  | Week 4 |  |  |  | Week 5
 | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code | Eval | Defendant | Offense | Code
 | Monday |  |  |  | 2010-04-05 00:00:00 |  |  |  | 2010-04-12 00:00:00 |  |  |  | 2010-04-19 00:00:00 |  |  |  | 2010-04-26 00:00:00
1
2
3
4
5
6
7
8
9
 | Tuesday |  |  |  | 2010-04-06 00:00:00 |  |  |  | 2010-04-13 00:00:00 |  |  |  | 2010-04-20 00:00:00 |  |  |  | 2010-04-27 00:00:00
1
2
3
4
5
6
7
8
9
 | Wednesday |  |  |  | 2010-04-07 00:00:00 |  |  |  | 2010-04-14 00:00:00 |  |  |  | 2010-04-21 00:00:00 |  |  |  | 2010-04-28 00:00:00
1
2
3
4
5
6
7
8
9
 | 2010-04-01 00:00:00 |  |  |  | 2010-04-08 00:00:00 |  |  |  | 2010-04-15 00:00:00 |  |  |  | 2010-04-22 00:00:00 |  |  |  | 2010-04-29 00:00:00
1
2
3
4
5
6
7
8
9
 | 2010-04-02 00:00:00 |  |  |  | 2010-04-09 00:00:00 |  |  |  | 2010-04-16 00:00:00 |  |  |  | 2010-04-23 00:00:00 |  |  |  | 2010-04-30 00:00:00
1
2
3
4
5
6
7
8
9
Spreadsheet: kam_keiser__17877__Trader-Matrix template (US Gas)_EOL
Sheet: Sheet1

U.S. Nat Gas
 | TAGG Book (financial) |  | HEDGE BOOK (physical) |  | SITARA Book
Trader: | Short Name: | Global ID Number: | Short Name: | Global ID Number: | Short Name: | Global ID Number: |  |  |  | Books w/o traders
[NAME] | FB-West1 | 166806 | PB-HDG-West1 | 166900 | PB-West1 | 167071 |  |  |  | ENA-FT-WT-SJ
[NAME] | FB-West2 | 166808 | PB-HDG-West2 | 166903 | PB-West2 | 167072 |  |  |  | ENA-FT-WC-SJ
[NAME] | FB-West3 | 166809 | PB-HDG-West3 | 166906 | PB-West3 | 167075
[NAME] | FB-West4 | 166810 | PB-HDG-West4 | 166908 | PB-West4 | 167077
[NAME] | FB-West5 | 166811 | PB-HDG-West5 | 166909 | PB-West5 | 167079
[NAME] | FB-West6 | 166814 | PB-HDG-West6 | 166911 | PB-West6 | 167082
[NAME] | FB-West7 | 166817 | PB-HDG-West7 | 166913 | PB-West7 | 167084
[NAME] | FB-West8 | 166821 | PB-HDG-West8 | 166915 | PB-West8 | 167085
[NAME] | FB-West9 | 166826 | PB-HDG-West9 | 166914 | PB-West9 | 167086
[NAME] | FB-West10 | 167122 | PB-HDG-West10 | 167144 | PB-West10 | 167143
[NAME] | FB-Texas1 | 166856 | PB-HDG-Texas1 | 166905 | PB-Texas1 | 167087
 | FB-Texas2 | 166858 | PB-HDG-Texas2 | 166916 | PB-Texas2 | 167088
[NAME] | FB-Texas3 | 166861 | PB-HDG-Texas3 | 166918 | PB-Texas3 | 167089
[NAME] | FB-Texas4 | 166862 | PB-HDG-Texas4 | 166919 | PB-Texas4 | 167090
 | FB-Texas5 | 166864 | PB-HDG-Texas5 | 166920 | PB-Texas5 | 167091
[NAME] | FB-Texas6 | 166866 | PB-HDG-Texas6 | 166921 | PB-Texas6 | 167092
[NAME] | FB-East1 | 166812 | PB-HDG-East1 | 166899 | PB-East1 | 167073 |  |  |  | EAST-GULF2
[NAME] | FB-East2 | 166816 | PB-HDG-East2 | 166901 | PB-East2 | 167074 |  |  |  | EAST-GULF3
[NAME] | FB-East3 | 166819 | PB-HDG-East3 | 166902 | PB-East3 | 167076 |  |  |  | EAST-MKTEAST
 | FB-East4 | 166820 | PB-HDG-East4 | 166904 | PB-East4 | 167078 |  |  |  | EAST-NEWENGLAND
 | FB-East5 | 166825 | PB-HDG-East5 | 166907 | PB-East5 | 167080 |  |  |  | EAST-CNG
[NAME] | FB-East6 | 166827 | PB-HDG-East6 | 166917 | PB-East6 | 167081 |  |  |  | EAST-TP1
[NAME] | FB-East7 | 166830 | PB-HDG-East7 | 166910 | PB-East7 | 167083 |  |  |  | EAST-TP3
[NAME] | FB-East8 | 166832 | PB-HDG-East8 | 166912 | PB-East8 | 167070
[NAME] | FB-Cent1 | 166839 | PB-HDG-Cent1 | 166922 | PB-Cent1 | 167093
[NAME] | FB-Cent2 | 166844 | PB-HDG-Cent2 | 166923 | PB-Cent2 | 167094
[NAME] | FB-Cent3 | 166849 | PB-HDG-Cent3 | 166927 | PB-Cent3 | 167095
 | FB-Cent4 | 166852 | PB-HDG-Cent4 | 166924 | PB-Cent4 | 167096
 | FB-Cent5 | 166854 | PB-HDG-Cent5 | 166925 | PB-Cent5 | 167097
[NAME] | FB-Cent6 | 166857 | PB-HDG-Cent6 | 166926 | PB-Cent6 | 167098
[NAME] | FB-Financial1 | 166805 | n/a |  | n/a
[NAME] | FB-Financial2 | 166807 | n/a |  | n/a
[NAME] May | FB-Financial3 | 166813 | n/a |  | n/a
[NAME] | FB-Financial4 | 166815 | n/a |  | n/a
[NAME] | FB-Financial5 | 166818 | n/a |  | n/a
[NAME] | FB-Executive | 166823 | n/a |  | n/a
[NAME] | FB-Crude | 166828 | n/a |  | n/a
[NAME] | FB-Unleaded | 166831 | n/a |  | n/a
[NAME] | FB-Heating Oil | 166833 | n/a |  | n/a
Spreadsheet: 73229d1273852871-formula-not-working-when-range-is-changed-book3
Sheet: Sheet1

first name | last name | age | First name | last name
Abood | [NAME] | 21 | [NAME] | [NAME]
Adair | Teresa | 44 | [NAME] | Emeema
Adams | [NAME] | 36 | Abair | [NAME]
Adams | [NAME] | 33 | Abbasi | Maureen
 |  | 45 | Abbate | [NAME]
 |  | 25 | Abbey | Carol
 |  | 28 | Abbott | Kristina
 |  | 54 | Abbott | Lorri
 |  | 37 | Abbott | Kristen
 |  | 38 | Abdelrahman | Lauri
 |  | 39 | [NAME] | Theresa
 |  | 40 | Abdul-hammed | Marsha
 |  | 41 | [NAME] | [NAME]
 |  | 42 | Abed | [NAME]
 |  | 43 | [NAME] | Alba
 |  | 44 | [NAME] | [NAME]
 |  | 45 | [NAME] | Raimi
 |  | 46 | Abood | [NAME]
 |  | 47 | [NAME] | Julie
 |  | 48 | [NAME] | [NAME]
 |  | 49 | Aburashed | Rany
 |  | 50 | [NAME] | Fadi
 |  | 51 | Achonu | Kimberly
 |  | 52 | Acker | [NAME]
 |  | 53 | Ackerman | Michelle
 |  | 54 | Acker | Jeremy
 |  | 55 | Ackley | [NAME]
 |  | 56 | Ackley | Alicia
 |  | 57 | Ackley | Sue
 |  | 58 | Ackley | [NAME]
 |  | 62 | Adair | Teresa
 |  | 63 | Adams | [NAME]
 |  | 64 | Adams | [NAME]
 |  | 65 | Adams | Darlean
 |  | 66 | Adams | [NAME]
 |  | 67 | Adams | Erin
 |  | 68 | Adams | [NAME]
 |  | 69 | Adamski | Jade
 |  | 70 | Adams | [NAME]
 |  | 71 | Adams | Shelley
 |  | 72 | Adams | Shelly
 |  | 73 | Adams | Semaj
 |  | 74 | Adams | [NAME]
 |  | 75 | Adams | [NAME]
 |  | 76 | Adcock | Suzanne
 |  | 77 | [NAME] | [NAME]
 |  | 78 | Adil | Nazia
Spreadsheet: 859276d1707728596-aggregate-function-not-working-aggregatehelp
Sheet: Sheet1

 | Day | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 | 1 | 5 | 3 | 4 | 6 | 8 | 4 | 14 | 11 | 6 | 10 | 5 | 5
 | 2 | 6 | 12 | 6 | 7 | 12 | 12 | 5 | 12 | 8 | 8 | 13 | 7 |  |  | Rank | Least Records | Month | Day
 | 3 | 5 | 8 | 3 | 5 | 14 | 13 | 12 | 10 | 8 | 6 | 15 | 10 |  |  | 1
 | 4 | 1 | 5 | 3 | 9 | 9 | 9 | 12 | 4 | 9 | 7 | 7 | 7 |  |  | 2
 | 5 | 8 | 2 | 4 | 7 | 5 | 15 | 8 | 9 | 6 | 5 | 8 | 7 |  |  | 3
 | 6 | 6 | 4 | 6 | 15 | 7 | 14 | 11 | 15 | 8 | 5 | 9 | 4 |  |  | 4
 | 7 | 4 | 3 | 6 | 14 | 4 | 13 | 7 | 9 | 15 | 9 | 12 | 1 |  |  | 5
 | 8 | 1 | 10 | 5 | 10 | 4 | 10 | 3 | 4 | 6 | 8 | 16 | 6 |  |  | 6
 | 9 | 4 | 3 | 3 | 5 | 11 | 8 | 3 | 6 | 5 | 6 | 12 | 6 |  |  | 7
 | 10 | 4 | 2 | 6 | 5 | 6 | 15 | 14 | 5 | 7 | 5 | 13 | 7 |  |  | 8
 | 11 | 5 | 0 | 12 | 9 | 4 | 10 | 16 | 8 | 2 | 8 | 11 | 9 |  |  | 9
 | 12 | 7 | 0 | 5 | 8 | 8 | 4 | 5 | 11 | 9 | 7 | 6 | 6 |  |  | 10
 | 13 | 5 | 6 | 9 | 10 | 6 | 12 | 12 | 10 | 10 | 11 | 9 | 4 |  |  | 11
 | 14 | 6 | 8 | 8 | 9 | 2 | 14 | 6 | 18 | 8 | 2 | 12 | 3 |  |  | 12
 | 15 | 1 | 6 | 10 | 7 | 14 | 7 | 12 | 10 | 9 | 7 | 11 | 6 |  |  | 13
 | 16 | 5 | 5 | 7 | 5 | 9 | 13 | 5 | 11 | 7 | 7 | 9 | 4 |  |  | 14
 | 17 | 1 | 11 | 6 | 10 | 12 | 7 | 11 | 13 | 9 | 13 | 8 | 4 |  |  | 15
 | 18 | 1 | 10 | 6 | 16 | 8 | 7 | 16 | 10 | 4 | 9 | 8 | 3 |  |  | 16
 | 19 | 8 | 6 | 8 | 7 | 6 | 14 | 10 | 8 | 4 | 9 | 10 | 4 |  |  | 17
 | 20 | 13 | 6 | 9 | 7 | 4 | 15 | 8 | 12 | 2 | 7 | 5 | 7 |  |  | 18
 | 21 | 7 | 3 | 12 | 5 | 14 | 14 | 10 | 7 | 4 | 6 | 5 | 1 |  |  | 19
 | 22 | 9 | 6 | 9 | 7 | 6 | 9 | 13 | 4 | 6 | 8 | 9 | 3 |  |  | 20
 | 23 | 10 | 5 | 9 | 8 | 15 | 5 | 6 | 6 | 9 | 1 | 8 | 1
 | 24 | 8 | 5 | 11 | 12 | 8 | 4 | 8 | 10 | 5 | 3 | 8 | 3
 | 25 | 6 | 7 | 13 | 12 | 10 | 9 | 1 | 8 | 9 | 4 | 4 | 4
 | 26 | 9 | 5 | 13 | 15 | 7 | 10 | 6 | 10 | 6 | 8 | 9 | 7
 | 27 | 6 | 3 | 7 | 13 | 6 | 8 | 5 | 12 | 8 | 9 | 4 | 6
 | 28 | 6 | 2 | 6 | 9 | 7 | 9 | 11 | 12 | 5 | 9 | 4 | 2
 | 29 | 7 | 8 | 6 | 4 | 8 | 8 | 13 | 11 | 2 | 10 | 4 | 6
 | 30 | 4 |  | 7 | 7 | 5 | 14 | 11 | 10 | 4 | 6 | 3 | 4
 | 31 | 8 |  | 12 |  | 4 |  | 9 | 8 |  | 6 |  | 5
Spreadsheet: 837909d1690492858-need-help-with-index-match-formula-sample46
Sheet: Sheet1

 |  |  | Today's Date
 |  |  | CAT1
 |  |  | CAT2
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  | CAT1 |  |  |  |  |  | 156 | 154
 |  |  | CAT2 |  |  |  |  |  | 959 | 159
 |  |  | CAT3 |  |  |  |  |  | 257 | 328
 |  |  | CAT4 |  |  |  |  |  | 2588 | 258
 |  |  | CAT5 |  |  |  |  |  | 144 | 258
 |  |  | [NAME] |  |  |  |  |  | 287 | 154
Spreadsheet: 856938d1706088013-formula-to-get-smallest-number-book1_min
Sheet: Sheet1

Column1 | Column2 | Column3 |  |  | Column1 | Column3 | min
12/01/2024 | 1750.00 | ABCD |  |  | 12/01/2024 | ABCD | 2000
12/01/2024 | 50.00 | ABCD |  |  | 13/01/2024 | XYZ | 500
12/01/2024 | 20.00 | ABCD |  |  | 14/01/2024 | PQR | 500
13/01/2024 | 1330.00 | XYZ
13/01/2024 | 10.00 | XYZ
13/01/2024 | 5.00 | XYZ
14/01/2024 | 275.00 | PQR
14/01/2024 | 5.00 | PQR
Spreadsheet: 147304d1332715903-preserving-organizing-raw-data-question
Sheet: Sheet1

Time | Batch | Target | Actual |  |  | Target | 1313 | 1315 | 1316 | 1317 | 1318 | 1319 | 1320 | 1321
07:30:00 | 1313 | 60 | 34 |  |  | 07:30:00 | 60 | 35 | 34 | 45 | 60 | 90 | 23 | 10
07:30:00 | 1315 | 35 | 20 |  |  | 08:30:00 | 34 | 20 | 29 | 40 | 60 | 89 | 20 | 5
07:30:00 | 1316 | 34 | 29
07:30:00 | 1317 | 45 | 40 |  |  | Actual | 1313 | 1315 | 1316 | 1317 | 1318 | 1319 | 1320 | 1321
07:30:00 | 1318 | 60 | 60 |  |  | 07:30:00 | 34 | 20 | 29 | 40 | 60 | 89 | 20 | 5
07:30:00 | 1319 | 90 | 89 |  |  | 08:30:00 | 30 | 20 | 29 | 32 | 58 | 79 | 19 | 5
07:30:00 | 1320 | 23 | 20
07:30:00 | 1321 | 10 | 5
08:30:00 | 1313 | 34 | 30
08:30:00 | 1315 | 20 | 20
08:30:00 | 1316 | 29 | 29
08:30:00 | 1317 | 40 | 32
08:30:00 | 1318 | 60 | 58
08:30:00 | 1319 | 89 | 79
08:30:00 | 1320 | 20 | 19
08:30:00 | 1321 | 5 | 5
Spreadsheet: 881117d1729032332-fairly-easy-problem-rank-items-by-score-using-a-recursive-function-sample
Sheet: Full

Category | Item | Weighted Score | Ranking
Cat1
 | Item1 | 35
 | Item2 | 33
 | Item3 | 30
 | Item4 | 30
 | Item5 | 22
 | Item6 | 22
Cat2
 | Item1 | 38
 | Item2 | 36
 | Item3 | 35
 | Item4 | 28
 | Item5 | 21
Cat3
 | Item1 | 35
 | Item2 | 32
 | Item3 | 32
 | Item4 | 29
 | Item5 | 27
 | Item6 | 26
 | Item7 | 23
 | Item8 | 21
Cat4
 | Item1 | 20
 | Item2 | 19
 | Item3 | 18
 | Item4 | 16
 | Item5 | 16
Cat5
 | Item1 | 28
 | Item2 | 22
Spreadsheet: 706264d1606575991-count-only-after-number-2-appears-book1-3-ans
Sheet: Sheet1

0 |  |  |  | [NAME]
1 |  | 1
0
2
0
3 |  | 1
0
4 |  | 2
0
2
0
5 |  | 1
0
1 |  | 2
0
2
0
3 |  | 1
0
4 |  | 2
Spreadsheet: 267458d1380082850-capturing-and-saving-updated-data-from-fields-driven-by-selections-from-drop-down-menu-20130924-1230-mockup-mr-excel
Sheet: Summary-Updated

 |  |  |  |  |  |  |  |  | Employee summary - UPDATED
 | Sheet allows manager to make updates to employee summary on the fly. This updated data should be captured in "Data-updated" in the appropriate row/column for each individual for whom updates are provided.
 | Name
 | Venkman, [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skills |  |  | Current
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Skill 3
 | Overall message
 | Strengths
 | Skills that have improved
 | Development objectives
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: end-of-year TOTALS

3148.1 | Do Line Item Totals Agree With Worksheet Totals? | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | Misc Non- Taxable | Owner Loan | Line Item Totals | Line Item Totals Comparision  should = 0
Received From |  | 3148.1 | 2704.5 | 237.63 | 205.97 | 0 | 0 | 0 | 0 | 0
January | YES | 3148.1 | 2704.5 | 237.63 | 205.97 | 0 | 0 | 0 | 0 | 0 | 3148.1 | 0
February | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
March | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
April | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
May | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
June | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
July | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
August | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
September | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
October | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
November | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
December | YES | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Visa Total | 0 |  | Visa Fees Total | 0 |  | Total Deposits |  |  | Quick Sales Tax Calculator
 |  |  |  |  |  |  | 3148.1 |  |  | AMOUNT | 471.34
 |  |  |  |  |  |  |  |  |  | SALES TAX | 30.83532710280374
 |  |  |  |  |  |  |  |  |  | TAXABLE AMOUNT | 440.5
12 MONTH AVERAGE |  | 262.3416666666666 |  |  |  |  |  |  |  | SHIPPING | 27.5
 |  |  |  |  |  |  |  |  |  | TAXABLE MERCH = | 413
 |  |  |  | Total Deposits compared to "Totals" on individual sheets |  | 3148.1
 |  |  |  | should equal zero |  | 0
 |  |  |  | should equal zero |  | 0
 |  |  |  | should equal zero |  | 0
Spreadsheet: 697408d1601341644-max-min-within-a-list-within-a-cell-max-min-within-a-list-within-a-cell
Sheet: Sheet1

 | MAX | MIN
[54.6 38.1 29.68 33.65 61.43]
[56.83 56.19 35.87 69.52 47.94]
[63.33 43.02 80.95 30.79 57.62]
[22.6 26.1 4.81 38.94 44.33]
[45.79 51.33 32.23 26.4 28.73 23.77 98.15]
[22.31 50.75 57.17 15.17 57.6 ]
[41.71 49.44 2.19 48.85]
Spreadsheet: 202af688-9c90-4e31-a7d7-3712287900f2
Sheet: Sheet1

Release: Senior Loan Officer Opinion Survey on Bank Lending Practices | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=191
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-24 3:43 AM [NAME]
 | Real-Time | Period
Name: | Start | End
Senior Loan Officer Opinion Survey on Bank Lending Practices | 2010-04-20 00:00:00 | Current
Link:
http://www.federalreserve.gov/boarddocs/SnLoanSurvey/ | 2010-04-20 00:00:00 | Current
Source:
Board of Governors of the Federal Reserve System | 2010-04-20 00:00:00 | Current
Notes:
For further information, please refer to the Board of Governors of the | 2010-04-20 00:00:00 | Current
Federal Reserve System's Senior Loan Officer Opinion Survey on Bank
Lending Practices release, online at
http://www.federalreserve.gov/boarddocs/SnLoanSurvey/.
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2010-04-20 00:00:00
2010-08-16 00:00:00
2010-11-08 00:00:00
2011-01-31 00:00:00
2011-05-02 00:00:00
2011-08-15 00:00:00
2011-11-07 00:00:00
2012-01-31 00:00:00
2012-04-30 00:00:00
2012-08-06 00:00:00
2012-10-31 00:00:00
2013-02-04 00:00:00
2013-05-06 00:00:00
2013-08-05 00:00:00
2013-11-02 00:00:00
2014-02-03 00:00:00
Spreadsheet: 02d0aba9-4e63-4a58-8fe0-010bf1615e85
Sheet: Mergent

Mergent
2006-2007
 | 2006-07-01 00:00:00 | 2006-08-01 00:00:00 | 2006-09-01 00:00:00 | 2006-10-01 00:00:00 | 2006-11-01 00:00:00 | 2006-12-01 00:00:00 | 2007-01-01 00:00:00 | 2007-02-01 00:00:00 | 2007-03-01 00:00:00 | 2007-04-01 00:00:00 | 2007-05-01 00:00:00 | 2007-06-01 00:00:00 | Total | 2006-2007 price | Price per unit
MergentOnline
Logins | 15 | 18 | 21 | 44 | 58 | 52 | 27 | 11 | 8 | 33 | 6 | 9
Searches | 31 | 39 | 17 | 78 | 65 | 61 | 56 | 20 | 17 | 55 | 3 | 14 |  | 11000
Companies Viewed | 20 | 14 | 15 | 39 | 27 | 49 | 27 | 6 | 4 | 35 | 3 | 3 |  | 11000
COUNTER-Compliant?: | No
Spreadsheet: 871868d1718266794-looking-for-an-efficient-way-to-sum-book3
Sheet: Sheet2

 | AM Init | Store1 | [NAME] | Store3 | Store4 | Store5 | YTD Loss
 | AW | 45 | 199 | 1408 | 1542
 | EC | 305 | 350 | 1675 | 1985
 | KM | 1259 | 1738 | 1903 | 1931
 | KT | 198 | 455 | 1187 | 1766
 | KR | 35 | 407 | 838 | 1172 | 1868
 | MB | 79 | 872 | 1267 | 1684
 | TM | 410 | 1062 | 1394 | 2052
 | AS | 738 | 1586 | 1825 | 1957
 | CL | 46 | 1371 | 1757 | 1759
 | CB | 19 | 1305 | 1768 | 1797
 | DW | 1719 | 1826 | 1909 | 1997
 | DB | 944 | 1730 | 1855 | 2065
 | FP | 710 | 733 | 1743
 | RA | 899 | 1445 | 1700 | 1896
 | SG | 403 | 1553 | 1877
Spreadsheet: 1cc418a4-fc23-4af5-9927-d774f192f3b2
Sheet: Area 5

Location | Title | Name | Mobile | CRCs | CRC Mobile
Area 5 | Area Manager | [NAME] | 07740 565 059
Cheshire | RDO | [NAME] | 07958 631 236 | [NAME] | 07921 283192
 |  |  |  | [NAME] | 07921 283193
Staffordshire | RDO | [NAME] | 07912 541 471 | [NAME] | 07894 489754
 |  |  |  | [NAME] | 07718 706576
Birmingham | RDO | [NAME] | 07889 601 017 | [NAME] | 07894 489419
 |  |  |  | [NAME] | 07841 156808
 |  |  |  | [NAME] | 07718 706578
 |  |  |  | [NAME] | 07590 890816
Shropshire | RDO | [NAME] | 07810 050970 | [NAME] (start date 7/10/13) | 07718 706579
 |  |  |  | [NAME] | 07711 385897
[NAME] | RDO | [NAME] | 07730 814 156 | [NAME] | 07894 489416
 |  |  |  | [NAME] | 07590 890759
NB: [NAME] also covers Area 4
Greater Manchester | RDO | [NAME] | 07736 517 730 | [NAME] | 07718 706569
 | RDO | [NAME] | 07730 814 162 | [NAME] | 07718 706557
 |  |  |  | [NAME] | 07718 706570
 |  |  |  | [NAME] | 07590 890802
 |  |  |  | [NAME] | 07718 706571
 |  |  |  | Stephanie Veal | 07872 827154
Merseyside | RDO | [NAME] | 07764 960 410 | [NAME] | 07921 283194
 |  |  |  | [NAME] | 07894 489418
 |  |  |  | [NAME] | 07715 856703
 |  |  |  | [NAME] | 07738 648 944
Lancashire | RDO | [NAME] | 07740 565 060 | [NAME] | 07894 489730
 |  |  |  | [NAME] | 07894 489731
Isle of Man | RDO | [NAME] | 01624 686808
Area 5 | URDO | [NAME] | 07809 511739
Area 5 | WRDO | [NAME] | 07841 367447
Spreadsheet: 832400d1686310749-price-pick-from-last-updated-date-with-condition-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  | Fruit | Valid From | Price
 |  |  |  |  |  |  |  | APPLE | 2020-06-23 00:00:00 | 100
 |  |  |  |  |  |  |  | APPLE | 2022-12-02 00:00:00 | 113.11 |  |  | Fruit | Date | Price
 |  |  |  |  |  |  |  | APPLE | 2023-01-30 00:00:00 | 121.86 |  | Ex 1 | APPLE | 2023-01-01 00:00:00 | 113.11
 |  |  |  |  |  |  |  | Orange | 2004-11-08 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Orange | 2012-03-01 00:00:00 | 108.05 |  | Ex2 | Grapes | 2008-07-01 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2004-11-08 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Grapes | 2006-07-01 00:00:00 | 76.28 |  | Ex3 | Grapes | 2014-02-27 00:00:00 | 103.35
 |  |  |  |  |  |  |  | Grapes | 2007-07-01 00:00:00 | 76.28
 |  |  |  |  |  |  |  | Grapes | 2008-04-30 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2008-07-01 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2009-07-01 00:00:00 | 78.49
 |  |  |  |  |  |  |  | Grapes | 2010-03-29 00:00:00 | 95.6
 |  |  |  |  |  |  |  | Grapes | 2010-08-26 00:00:00 | 100.19
 |  |  |  |  |  |  |  | Grapes | 2012-03-01 00:00:00 | 108.05
 |  |  |  |  |  |  |  | Grapes | 2012-08-10 00:00:00 | 108.05
 |  |  |  |  |  |  |  | Grapes | 2012-11-19 00:00:00 | 103.35
 |  |  |  |  |  |  |  | Grapes | 2014-03-01 00:00:00 | 106.1
 |  |  |  |  |  |  |  | Grapes | 2015-03-01 00:00:00 | 107.71
 |  |  |  |  |  |  |  | Grapes | 2016-07-01 00:00:00 | 107.71
 |  |  |  |  |  |  |  | Grapes | 2017-09-22 00:00:00 | 113.11
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: Nova&ANG&GLGT$

[NAME]
Nova Receipt Energy |  | GJ/E3M3
Nova Delivery Energy |  | GJ/E3M3
 | $C/GJ | $US/MMBtu
[NAME]. Receipt
[NAME]. Receipt
Firm Delivery Charge
IT Delivery Charge
ANG Tariff Summary
Firm Demand Charge
Firm Commodity Charge
IT Commodity Charge
NEB Cost Recovery
GLGT Tariff Summary
Firm Demand Charge
Firm Commodity Charge |  | 0.0108
IT Commodity Charge |  | 0.25216
ACA |  | 0.0022
GRI |  | 0.007
St. Clair to Dawn |  | 0
Northern Border Tariff Summary
[NAME] |  | 0.036
Commodity Rate |  | 0.0006
Ventura Mileage |  | 821.6518
Ventura Firm Rate
Ventura Commodity
[NAME] |  | 968.5973
Harper Firm Rate
Harper Commodity
Manhattan Mileage |  | 1214.7699
Manhattan Firm Rate
Manhattan Commodity
ACA |  | 0.0022