tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 105818d1303117294-display-data-from-1-sheet-to-another-sheet-automatically-sample-1000-
Sheet: Bangor-on-Dee

bangor-on-dee
2:05  Bangor-on-Dee | Bangor-on-Dee | Hurdle | 0 | 0
2:40  Bangor-on-Dee | Bangor-on-Dee | Hurdle | 0 | 0
3:15  Bangor-on-Dee | Bangor-on-Dee | Chase | 0 | 0
3:50  Bangor-on-Dee | Bangor-on-Dee | Chase | 161 | 228
4:20  Bangor-on-Dee | Bangor-on-Dee | Hurdle | 0 | 0
[NAME] | Bangor-on-Dee | Chase | 0 | 0
5:25  Bangor-on-Dee | Bangor-on-Dee | Flat | -100 | -100
Spreadsheet: hunter_shively__12678__Nov_01 Volume Changes
Sheet: Nov 13

Pipeline | Producer | Deal | Zone | New Volum | Current Volume | Change | Index | GDA
ANR | Torch | 1059787 | TRan | 125 | 1 |  | -124
ANR | Torch | 1060001 | Tran | 125 | 0 |  |  | -125
HIOS | Panaco | 1135518 | Offshore | 3837 | 1016 |  |  | -2821
NGPl | Texoma | 995584 | Midcon | 0 | 15000 |  | 8004 | 6996
SNAT | Stone | 1054822 | [NAME] | 4332 | 4457 |  | 125
STRY | Linder | 1135987 | Holly Beach | 6000 | 6017 |  |  | 17
TENN | Tristar | 1134747 | Zone 100 | 5000 | 4000 |  |  | -1000
TENN | Torch | 1059749 | Zone 500 | 2274 | 1797 |  |  | -477
TGT | Cohort | 1139749 | ETX | 8500 | 1 |  | -8499
TGT | [NAME] | 1135665 | Zone Sl | 5000 | 0 |  |  | -5000
TRNKL | Forest | 1131185 | ELA | 6400 | 6200 |  |  | -200
TRNKL | Stone | 1054829 | ELA | 730 | 600 |  | -130
TRNKL | Nexen | 1131034 | ELA | 4400 | 6056 |  |  | 1656
 |  |  |  |  |  | Daily Total
 |  |  |  |  |  | MTD Total | -44238 | -3546
Spreadsheet: 787828d1658077272-provide-the-2nd-lastest-price-value-from-a-row-lookup-2nd-last-value-issue
Sheet: Comparison

 |  |  |  | Years | Start Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month updated |  | PY | Pricing |  | Var
 |  |  |  | <1/1/2021 | 2021 |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  | 2021 | 2022 | 2021 | 2nd last | Latest
Country | Customer Name | Product Segment | Item Description |  | Jan | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Month | Month | Price | Price | Price | % change
CA | OLD Reinhart - LaCr | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz
CA | OLD Reinhart - LaCr | FCD | 70213002 - IMA Oatmeal Rsn 1oz
CA | OLD Reinhart - LaCr | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Reinhart - LaCr | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | OLD Rein - Shaw | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | OLD Rein - Shaw | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | OLD Rein - Shaw | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | OLD Rein - Shaw | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | PC | FCD | 70110434 - Wht Choc Mac 8lbx4 |  |  |  |  |  | 70.63000000000001 |  |  |  |  |  | 74.02 |  |  |  |  |  | 60.92
CA | QMCS | FCD | 7000962- Wht Choc Mac 3oz |  |  |  |  |  | 21.45 |  |  |  |  |  | 38.44 |  |  |  |  |  | 24.66
CA | QMCS | FCD | Flag 7000961 - Choc Chunk 3oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 22.85
CA | RDP Foodservice | FCD | 7000761 - Choc Chunk 1.5oz |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36.3 |  | 20.76
CA | Rein FS | BCS | 70213201 - IMA Choc Chip Bulk Bkd 2oz |  |  |  |  |  |  | 16.71 |  |  |  |  |  |  |  |  |  |  | 18.56
CA | Rein FS | FCD | 70213002 - IMA Oatmeal Rsn 1oz |  |  |  |  |  |  | 27.47 |  |  |  |  |  |  |  |  |  |  | 30.84
CA | Rein FS | FCD | 70213003 - IMA Peanut Btr 1oz |  |  |  |  |  |  | 29.56 |  |  |  |  |  |  |  |  |  |  | 33.13
CA | Rein FS | FCD | 70213027 - IMA Double Choc 1.5oz |  |  |  |  |  |  | 28.05 |  |  |  |  |  |  |  |  |  |  | 31.7
CA | Sy - DET | FCD | 7000110 - Oatmeal Rsn 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | 7000160 - Double Choc 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 29.22
CA | Sy - DET | FCD | Flag 70A0108 - Sugar 2oz |  |  |  |  |  | 34.64 |  |  |  |  |  | 36.3 |  |  |  |  |  | 17.44
CA | Sy - GR | BCS | 7000612 - Choc Chunk Bkd 1.35oz |  |  |  |  |  | 18.05 |  |  |  |  |  |  |  |  |  |  |  | 17.44
USA | [NAME] |  | FG - Choc Chip TH Ns BnB 16.5oz 12.37LB US |  |  |  |  |  |  |  |  |  |  |  |  | 18.04 |  | 22.44 |  |  | 22.16
USA | [NAME] |  | FG Ns 16ozx12 Choc Chip Lovers BNB
Spreadsheet: 692652d1598477154-how-to-copy-every-nth-row-from-sheet1-to-sheet2-worksheetab
Sheet: Sheet1

 |  |  |  | 1001
 |  |  |  | 1002
 |  |  |  | 1003
 |  |  |  | 1004
 |  |  |  | 1005
 |  |  |  | 1006
 |  |  |  | 1007
 |  |  |  | 1008
 |  |  |  | 1009
 |  |  |  | 1010
 |  |  |  | 1011
 |  |  |  | 1012
 |  |  |  | 1013
 |  |  |  | 1014
 |  |  |  | 1015
 |  |  |  | 1016
 |  |  |  | 1017
 |  |  |  | 1018
 |  |  |  | 1019
 |  |  |  | 1020
 |  |  |  | 1021
 |  |  |  | 1022
 |  |  |  | 1023
 |  |  |  | 1024
 |  |  |  | 1025
 |  |  |  | 1026
 |  |  |  | 1027
 |  |  |  | 1028
 |  |  |  | 1029
 |  |  |  | 1030
 |  |  |  | 1031
 |  |  |  | 1032
 |  |  |  | 1033
 |  |  |  | 1034
 |  |  |  | 1035
 |  |  |  | 1036
 |  |  |  | 1037
 |  |  |  | 1038
 |  |  |  | 1039
 |  |  |  | 1040
 |  |  |  | 1041
 |  |  |  | 1042
 |  |  |  | 1043
 |  |  |  | 1044
 |  |  |  | 1045
 |  |  |  | 1046
 |  |  |  | 1047
 |  |  |  | 1048
 |  |  |  | 1049
 |  |  |  | 1050
 |  |  |  | 1051
 |  |  |  | 1052
 |  |  |  | 1053
 |  |  |  | 1054
 |  |  |  | 1055
 |  |  |  | 1056
 |  |  |  | 1057
 |  |  |  | 1058
 |  |  |  | 1059
 |  |  |  | 1060
 |  |  |  | 1061
 |  |  |  | 1062
 |  |  |  | 1063
 |  |  |  | 1064
 |  |  |  | 1065
 |  |  |  | 1066
 |  |  |  | 1067
 |  |  |  | 1068
 |  |  |  | 1069
 |  |  |  | 1070
 |  |  |  | 1071
 |  |  |  | 1072
 |  |  |  | 1073
 |  |  |  | 1074
 |  |  |  | 1075
 |  |  |  | 1076
 |  |  |  | 1077
 |  |  |  | 1078
 |  |  |  | 1079
 |  |  |  | 1080
 |  |  |  | 1081
 |  |  |  | 1082
 |  |  |  | 1083
 |  |  |  | 1084
 |  |  |  | 1085
 |  |  |  | 1086
 |  |  |  | 1087
 |  |  |  | 1088
 |  |  |  | 1089
 |  |  |  | 1090
 |  |  |  | 1091
 |  |  |  | 1092
 |  |  |  | 1093
 |  |  |  | 1094
 |  |  |  | 1095
 |  |  |  | 1096
 |  |  |  | 1097
 |  |  |  | 1098
 |  |  |  | 1099
 |  |  |  | 1100
 |  |  |  | 1101
 |  |  |  | 1102
 |  |  |  | 1103
 |  |  |  | 1104
 |  |  |  | ....
 |  |  |  | ....
 |  |  |  | ....
Spreadsheet: 839993d1692350139-count-distinct-countifdistincttemp3
Sheet: Tables

Title
Year 7 Premier League
SACCSS Cross Country
Writers Club participation
Junior Band
Lunchtime Languages Club
Showing the school ethos
Anime Club
Politics Club
DRC Politics Club
Politics Club Attendance
VCC Year 7 Commendations
ASX Club
Chess 2023
Coding Club
Junior Strings
Term 1 attendance and contribution for the animal club
Enviro Friends
SACCSS Junior Girls AFL
Australian Geography Competition 2023
Participation in Class
STEM Robotics Club
STEM Solar Vehicle Challenge
College Musical Production - Rock of Ages
Co-curricular Activity
Great Work Ethic
Sculpture Club
Astrophotography Club
STEM Makers Club
Positive Role Model to Others
Australian Geography Competition
Journaling Club
Writers Club achievement
Recognition of Excellence: Participation in Class
Re-trying work and trying hard
Global Innovator Asia-Pacific Winner
Global Innovators Australian Winner
Participation in Class and College Theme
VCC Year 8 Basketball
Junior Rock Band
Junior Guitar Ensemble
Percussion Ensemble
[NAME]
SACCSS Badminton
VCC Intermediate Basketball Tournament
Really Impressed with Lucas' Effort in English
Global Innovator Australian Winner
Term 1 attendance and contribution for the Environment and Sustainability Team
Stage Band
Generations in Jazz
Excellent effort in Geography
Excellence in Programming
[NAME] (Term 1)
LUNCHTIME LANGUAGES CLUB
SMC Singers
Following instructions and working hard in class
Working hard and well in class
Peer tutor - Digital Technologies
Great Demonstration of Understanding
Displaying Monican attributes
SACCSS Intermediate Futsal
DRC Music Vice Captain
Contributing to class discussions and working hard
Participation in Whole Class Discussions
DRC Music Captain
SACCSS Senior Girls AFL
SACCSS Senior Volleyball
Formula 1 Australian Grand Prix BAE Super Sonic STEM Challenge
Saxophone Ensemble
Senior Boys AFL
Senior Strings
Senior [NAME]
Legal Club
Diligent and Conscientious Start to the Year
Music Information Night assistance
Holiday Homework Completed
DSC Beyond the Book
[NAME]
Senior Vocal Ensemble
VCC Senior Basketball Elite 8
DSC Music Vice Captain
Assistance with Music Information Evening
DSC Music Captain
Spreadsheet: 544053d1508749297-problem-with-range-example
Sheet: Projects

 | Current date |  |  | department | year | planned start (Week) | planned end (Week) | Planned quantity |  | Planned time (hours) | % ready | Time prognosis |  |  |  |  |  |  |  |  |  | planned time per week
 | Current week |  |  |  |  |  |  |  |  |  |  |  |  | department | year | planned start (week) | planned end (week) | duration (week) | time per week |  | department | 43 | 44 | 45 | 46 | 47 | 48
 |  |  | Wall 1.3 linja M | 1301 | 2017 | 42 | 45 | 208 | m2 | 264 | 0.35 |  |  |  |  |  |  |  |  |  | 1301
 |  |  | Roof linja M | 1601 | 2017 | 42 | 44 | 150 | m2 | 150 | 0.25 |  |  |  |  |  |  |  |  |  | 1601
 |  |  | Window 1, 2 | 1301 | 2017 | 43 | 46 | 50 | pcs | 600 | 0
 |  |  | Door office | 1601 | 2017 | 44 | 48 | 5 | pcs | 10 | 0
Spreadsheet: 104f7425-4f0f-43c7-9057-d861476cd6dc
Sheet: Total

NASP Equipment  - Supplemental Order Form
NASP, Inc. |  |  | Prices effective: |  |  |  |  |  |  | Phone: (920) 523-6040
W4285 Lake Drive |  |  | Jan 1 - Dec 31, 2013 |  |  |  |  |  |  | Fax:     (920) 523-6042
Waldo, WI  53093 |  |  |  |  |  | Email: [EMAIL]
 |  |  |  |  |  | www.archeryintheschools.org
Organization: |  |  |  |  | [NAME]:
Contact Name: |  |  |  |  | (If different)
Ship-To Address: |  |  |  |  | City State Zip:
(NO PO Box) |  |  |  |  | Phone:
City State Zip: |  |  |  |  | Fax:
 | Commercial |  | Residential |  | E-mail:
 | Evidence of Non-Profit Status: |  |  |  | Copy of 501c3 |  |  | Copy of Sales Tax Exemption
 |  | **Sales tax will be added in KY, WI, OH, and MD if sales tax exemption certificate is not rec'd.**
Payment accepted by Check, MasterCard, Visa, or [NAME]: |  |  |  |  |  |  |  | VISA / MasterCard:
 |  |  |  |  |  | Name:
PO Number: |  |  |  |  |  | Card #:
*PO Number is REQUIRED if order is not prepaid. |  |  |  |  |  | Expires: |  |  | 3-Digit Code
 |  |  |  |  |  |  | Retain CC# for future orders?       Yes       No
 | Number | Item |  |  |  | Qty |  | (Includes Shipping) | Price
Mini | 11413 | Mini Right Hand Red |  |  |  |  | Ea | $111/bow
Genesis | 11415 | Mini Right Hand Blue |  |  |  |  | Ea | $111/bow
Bows: | 11417 | Mini Right Hand Black |  |  |  |  | Ea | $111/bow
 | 11414 | [NAME] Red |  |  |  |  | Ea | $111/bow
 | 11416 | [NAME] |  |  |  |  | Ea | $111/bow
 | 11418 | [NAME] Black |  |  |  |  | Ea | $111/bow
Genesis | 10492A | Genesis Pro Right Hand Black |  |  |  |  | Ea | $131/bow |  | ***
Pro | 10496A | Genesis Pro Right Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Bows: | 10491A | Genesis Pro Left Hand Black |  |  |  |  | Ea | $131/bow |  | ***
 | 10497A | Genesis Pro Left Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Replacement | BG20014 | Right Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
Parts: | BG20015 | Left Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
 | BG11498 | String (Orig or Pro) 94 1/4" (Blk & Wht) |  |  |  |  | Ea | $17/each
 | BG10897 | String (Orig or Pro) 94 1/4" (Blk & Red) |  |  |  |  | Ea | $17/each
 | BG11490 | [NAME] 79 1/4" (Blk and Wht) |  |  |  |  | Ea | $17/each
 | BG11491 | [NAME] 79 1/4" (Black and Red) |  |  |  |  | Ea | $17/each
 | BG11497 | Power Cable Genesis & Pro 37.25" |  |  |  |  | Ea | $10/each
 | BG11492 | Power Cable Mini 31" |  |  |  |  | Ea | $10/each
 | 50138 | Cable Rod Slide |  |  |  |  | Ea | $1/each
 | ** All prices include shipping to a commercial
 | address in the lower 48 States |  |  |  |  |  |  | Total
*** Please note - Genesis Pro does NOT include a rest.  You will have to purchase a rest separately ***
from another source.  [NAME] and [NAME] are not eligible for NASP tournament competition.
*** BY SUBMITTING AN ORDER TO NASP YOU AGREE THESE ITEMS WILL STAY PROPERTY OF THE ORGANIZATION***
Spreadsheet: 10bd6936-350b-43ff-966c-417b5de346fb
Sheet: Sheet1

Table 7--U.S. feed grain imports by selected sources (1,000 metric tons) 1/, 6/14/2013 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Import and country/region |  | ---------- 2010/11 ---------- |  | ---------- 2011/12 ---------- |  | 2012/13
 |  | Mkt year | Jun-Apr | Mkt year | Jun-Apr | Jun-Apr
Oats | Canada | 1393.292808 | 1300.167487 | 1556.499397 | 1472.255389 | 1496.860827
 | Finland | 73.93257200000001 | 73.932572 | 34.84057 | 34.84057
 | Jamaica | 0.159212 | 0.061132 | 0.285218 | 0.285218
 | All other countries | 0.264317 | 0.263605 | 29.802409 | 29.625423 | 1.634067
 | Total 2/ | 1467.648909 | 1374.424796 | 1621.427594 | 1537.0066 | 1498.494894
Malting barley | Canada | 174.724159 | 169.091904 | 263.660306 | 234.260215 | 325.557353
 | All other countries | 0.006579999999999999 | 0.006579999999999999 | 0.244638 | 0.244638 | 0.06603
 | Total 2/ | 174.7307389999999 | 169.098484 | 263.904944 | 234.504853 | 325.623383
Other barley 3/ | Canada | 30.697571 | 24.936364 | 89.27383699999999 | 85.65569199999999 | 151.345737
 | All other countries | 1.288141 | 1.274698 | 0.7575109999999999 | 0.6716679999999999 | 3.082054
 | Total 2/ | 31.985712 | 26.211062 | 90.031348 | 86.32736 | 154.427791
1/ Grain only. Market year (June-May) and market year to date. 2/ Totals may not add due to rounding.
3/ Grain for purposes other than malting, such as feed and seed use. Source: U.S. Department of Commerce, Bureau of the Census, Foreign Trade Statistics.
Date run: 6/14/2013
Spreadsheet: phillip_m_love__30649__9907_OA
Sheet: TX-HPLR-GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
COMPANY:  HPL
REGION:  TEXAS
 |  |  | Total |  | Reclasses |  |  |  |  |  | September |  | October |  | November |  | December |  | January |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
Spreadsheet: e367e7f3-df79-4b1d-8444-e282de5e6606
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
42932905 | 2014-08-29 18:45:57 | ALLIES | 1 | 6 | 1 | 1507591 | darckjester | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
42933115 | 2014-08-29 19:09:08 | AXIS | 0 | 4 | 6 | 1507591 | darckjester | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
Spreadsheet: theresa_staab__39597__Producer Pricing Detail Nov01
Sheet: Phillips Summary

 |  | [NAME] To: |  |  | Remit To:
 |  |  |  |  |  | Verification Date:
 |  | Enron North America Corp. |  |  | Phillips Petroleum Company
 |  |  |  |  | Bank:  Chase Manhattan Bank, N.Y., N.Y.
 | 11829 |  |  |  | ABA:  021000021 | Due Date:
 |  |  |  |  | Acct:  144032070 | 2001-10-31 00:00:00
 |  |  |  |  |  | Payment Method:
 |  | Contact:  [NAME] |  |  | Contact:  [NAME] | Wire
 |  | Tel:  (303) 575-6485 |  |  | Tel:  (713) 669-3493 | Terms:
Enron North America Corp. |  | Fax: (303) 534-0552 |  |  | Fax: (713) 669-7358 | Last Business Day
Delivery Period: | Contract # | Meter # / Meter Name
 | 96028454 | 0814032-Clydesdale 1
 |  | 0814033-Clydesdale 2
 |  | 0814034-Clydesdale 3
 |  | 0814035-Palomino 1
 |  | 0814036-Palomino 2
 |  | Bear Paw Delivery into Fort Union Gas Gathering
 | Index | Discount / Premium | Price/MMBtu |  | MMBtu Quantity | Amount Due
 | CIG GD
 | IF NGPL-Midcont.
 | IF CIG - Rockies |  | 0
 |  | Fuel Loss | $             0.00 |  |  | $                                        0.00
PRIOR MONTH ADJUSTMENTS
 |  |  | TOTAL PAYMENT
Spreadsheet: dan_hyvl__4889__Daily Loads
Sheet: Sheet1

Citizen's average daily loads per month
 | January | February | March | April | May | June | July | August | September | October | November | December
CIG | 8608.064516129032 | 7095.446428571428 | 6438.677419354839 | 4672.85 | 2541.822580645161 | 2200.633333333333 | 1866.870967741936 | 1882.806451612903 | 2077.533333333333 | 3672.241935483871 | 5371.35 | 10323.85483870968
PSCo | 1585.467741935484 | 1468.607142857143 | 1140.854838709678 | 1061.983333333333 | 595.016129032258 | 363.3333333333334 | 268.0967741935484 | 258.758064516129 | 329.9 | 712.9032258064516 | 1182.133333333333 | 1723.193548387097
Spreadsheet: 815101d1674744405-returning-details-of-every-record-in-a-vertical-range-forum-example-1-
Sheet: Sheet1

FirstSendDate | touchpoint_name | Volume
2022-08-03 00:00:00 | Email-NN-AA-23-22303_A | 30
2022-09-03 00:00:00 | Email-NN-AA-23-22304_A | 40
2022-10-03 00:00:00 | Email-NN-AA-23-22303_A | 12
2022-11-03 00:00:00 | Email-NN-AA-23-22306_A | 11
Search using this | NN-AA-23-22303_A
Return this | touchpoint_name | Volume
 |  | 30
 | Email-NN-AA-23-22303_A | 12
Search using this | NN-AA-23-22304_A
Return this | touchpoint_name | Volume
 |  | 40
Spreadsheet: 846569d1697722583-need-to-correct-formula-for-current-amounts-insurance-calc-example_oct-2023
Sheet: Sheet1

 |  | Auto & Home   Insurance             YEAR - |  | 2023-01-01 00:00:00 |  | AUTO INS. AMT SPENT THIS MONTH: |  | ?
 |  |  | Total (Spent) Year to Date : |  |  | CYCLE & KYMCO INS. AMT SPENT THIS MONTH:
 | Choose month below! |  | Total (Spent in) Current Month : |  |  | HOME OWNER INS.  CURRENT MTH:
 |  | Amt spent in selected Month | Average Weekly Cost of Insurances :
 | 2023-05-23 00:00:00 |  |  |  |  | YEARLY HOME INS PMT |  | Amt's due based on due date only
LINE | DATE | CATEGORY | POLICY NUMBER | PMNT $ |  | YEAR AUTO INS. PMT
1 | 2022-09-12 00:00:00 | AUTO INS. |  | 45 |  | YEARLY CYCLE & KYMCO PMT
 | 2022-10-01 00:00:00 | AUTO INS. |  | 1160
 | 2022-11-01 00:00:00 | MOTORCYCLE & UTV INS. |  | 135 |  | Homeowner Ins. Due Month of January:
 | 2022-12-01 00:00:00 | HOME OWNER INS. |  | 1240 |  | Auto Ins. Due Month of April:
 | 2023-01-01 00:00:00 | HOME OWNER INS. |  | 110.83 |  | Motorcycle & ATV Ins. Due Month September:
 | 2023-04-03 00:00:00 | AUTO INS. |  | 1495
 | 2023-05-21 00:00:00 | MOTORCYCLE & UTV INS. |  | 6.71
 | 2023-09-16 00:00:00 | MOTORCYCLE & UTV INS. |  | 149
 | 2023-10-18 00:00:00 | AUTO INS. |  | 1000
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 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 SPENT ON VEHICLUAR INSURANCE
Spreadsheet: 774847d1648684805-combining-two-columns-retaining-forumla-example-combine-column
Sheet: Sheet1

Series ID | Parent series ID | CHILD_ORDER | level | EA flag | Classification Code |  | Values | [NAME] |  | Desired Result
7121001 | 8105150 | 9 | 2 |  | Total
8128746 | 7121001 | 1 | 3 |  | A
8128747 | 8128746 | 1 | 4 |  | 01
7125125 | 8128747 | 1 | 5 |  | 015
7126170 | 7125125 | 1 | 6 |  | 0159
8190773 | 7126170 | 1 | 7 |  | 01590120
8182568 | 8190773 | 1 | 8 | Y | 01590120 |  | 312.145021234166 |  |  | 312.145021234166
8190774 | 8190773 | 2 | 8 | Y | 01590120 |  | 37.5150760663391 |  |  | 37.5150760663391
8128769 | 8128746 | 2 | 4 |  | 03
8193075 | 8128769 | 1 | 5 | Y | 03 |  | 48.0455247827202 |  |  | 48.0455247827202
8193076 | 8128769 | 2 | 5 | Y | 03 |  | 48.0449172041116 |  |  | 48.0449172041116
8128778 | 7121001 | 2 | 3 |  | B
8128779 | 8128778 | 1 | 4 |  | 06-10
8128780 | 8128779 | 1 | 5 |  | 060-109
8139674 | 8128780 | 1 | 6 |  | 0700
8190781 | 8139674 | 1 | 7 |  | 07000030
8139675 | 8190781 | 1 | 8 | Y | 07000030 |  | 262.257096834577 |  |  | 262.257096834577
8190782 | 8190781 | 2 | 8 | Y | 07000030 |  | 15.9384007685084 |  |  | 15.9384007685084
8190783 | 8139674 | 2 | 7 |  | 07000050
8182575 | 8190783 | 1 | 8 | Y | 07000050 |  | 192.402198663928 |  |  | 192.402198663928
Spreadsheet: 174455d1345061320-need-help-with-solver-failedsolver
Sheet: Sheet1

carrier | 1 | 2 | 3 | best
a | 200 | 200 | 150 | 3
b | 200 | 175 | 150 | 3
c | 120 | 100 | 150 | 1
d | 90 | 80 | 90 | 2
2 | Number of Companies
 | Minimum Spend
 | Don't know why Solver won't go through all of the binary range (B1:D1) and find the minimum.  I did other tests (like finding the [NAME] for cell F1) and Solver is going through the [NAME] operation as expected, but it will not give the correct answer for A11, even though the math seems sound.
Spreadsheet: 85991d1285960963-sum-a-range-based-on-information-from-two-different-columns-test
Sheet: Sheet1

From | To | Distance |  | From | To | Distance
Saanich | GG Trail | 308.8 |  | Saanich | Burnside Exit | 5238.4 | -5838.699999999999
GG Trail | Tillicum | 1009.1 |  | Burnside Exit | Goldstream | 3516.3 | 2101.499999999998
Tillicum | McKenzie | 1080.8
McKenzie | Helmcken | 2079.8
Helmkcen | Burnside Exit | 759.9
Burnside Exit | Island Hwy | 1092.4
Island Hwy | Six Mile | 516.1
Six Mile | [NAME] | 712.6
[NAME] | Ocean Blvd | 813.8
Ocean Blvd | Goldstream | 381.4
Saanich | GG Trail |  |  | Saanich | Burnside Exit
GG Trail | Tillicum |  |  | Burnside Exit | Goldstream
Tillicum | McKenzie
McKenzie | Helmcken
Helmkcen | Burnside Exit
Burnside Exit | Island Hwy
Island Hwy | Six Mile
Six Mile | [NAME]
[NAME] | Ocean Blvd
Ocean Blvd | Goldstream
A | B |  |  | A | F
B | C |  |  | F | K
C | D
D | E
E | F
F | G
G | H
H | I
I | J
J | K