tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: cab091e1-b966-4b50-b359-39d7a81587cd
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
41051453 | 2014-04-18 23:35:13 | ALLIES | 0 | 5 | 6 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
41051749 | 2014-04-19 00:00:22 | AXIS | 1 | 6 | 4 | 1531424 | djarv | 7595 | eastern | 1939-12-16 | 1939-12-16 | Suomussalmi | Suomussalmi
41065921 | 2014-04-19 22:35:58 | ALLIES | 1 | 5 | 2 | 16722 | Yerone | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
41066170 | 2014-04-19 22:55:09 | AXIS | 0 | 3 | 5 | 16722 | Yerone | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
41066489 | 2014-04-19 23:27:17 | AXIS | 1 | 6 | 3 | 266715 | effdee | 12493 | western | 1944-12-30 | 1944-12-30 | [NAME] | [NAME]
41066852 | 2014-04-19 23:48:47 | ALLIES | 1 | 5 | 0 | 867821 | b.kuntscher | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
41067053 | 2014-04-20 00:06:16 | AXIS | 1 | 5 | 3 | 867821 | b.kuntscher | 9580 | western | 1944-06-11 | 1944-06-12 | Carentan Causeway | [NAME]
41097666 | 2014-04-21 22:41:42 | ALLIES | 1 | 7 | 4 | 1515794 | Bodega28 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41097948 | 2014-04-21 23:14:47 | AXIS | 0 | 3 | 7 | 1515794 | Bodega28 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41111314 | 2014-04-22 21:34:44 | ALLIES | 1 | 7 | 4 | 506159 | Hurletout | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
41111751 | 2014-04-22 22:01:27 | AXIS | 1 | 7 | 4 | 506159 | Hurletout | 7661 | eastern | 1944-02-16 | 1944-02-17 | Breakout to Lisyanka | [NAME]
41112234 | 2014-04-22 22:27:47 | AXIS | 1 | 7 | 2 | 243373 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41112529 | 2014-04-22 22:55:54 | ALLIES | 1 | 7 | 4 | 243373 | [NAME] | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
41127588 | 2014-04-23 22:42:24 | ALLIES | 1 | 6 | 2 | 734691 | lutzen82 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
41127861 | 2014-04-23 22:59:32 | AXIS | 1 | 6 | 3 | 734691 | lutzen82 | 7663 | pacific | 1944-07-21 | 1944-07-21 | Guam Landings | Débarquement à Guam
41128382 | 2014-04-23 23:40:08 | AXIS | 0 | 6 | 7 | 601280 | player601280 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
41128608 | 2014-04-24 00:01:48 | ALLIES | 0 | 3 | 7 | 601280 | player601280 | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 47543d1246571462-excel-2007-macros-in-original-file-changing-to-new-copied-book-name-sample-sku-facings-share-index-calc
Sheet: Sheet2

Select Sales Basis and Chain |  |  |  |  |  | 26 Weeks Ending May 23, 2009
 |  | Sales | Sales %Chg vs YrAgo | [NAME] | Sales Share Chg vs YrAgo | Enter #SKUs or Facings (by Brand) Per POG | Share of SKUs/ Facings | # SKUs/ Facings Per Sales Share | SKU/ Facing Index vs Sales Share
 | WIDGETS | 0 | 0 | 0 | 0 | 0
 | BRAND A | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND B | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND C | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND D | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND E | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND F | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND G | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND H | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND I | 0 | 0 | 0 | 0 | 0 |  | 0
 | BRAND J | 0 | 0 | 0 | 0 | 0 |  | 0
 | ALL OTHERS (combined) | 0 | 0 | 0 | 0 | 0 |  | 0
1
>>Select Sales Basis<<
Dollar Sales
Unit Sales
Offset=
0
1
>>Select Chain<<
A&P BANNER
A&P FOOD BASICS NY/NJ
ACME DIVISION
ALB DALLAS
ALB FLORIDA
ALB LOUISIANA
ALB ROCKY MNT
ALB SOUTHWEST
ALB INTERMOUNTAIN
ALB NORTHWEST
ALB SO. CALIFORNIA
BASHAS'
BIG Y
BIGG'S
BI-LO
BOZZUTOS
BRUNO'S
BROOKSHIRE
CUB EXCL CUB CHICAGO
COPPS
DEMOULAS
DIERBERGS
DOMINICK'S
DUANE READE
FARM FRESH
FIESTA
FOOD CITY | BACK
FOOD EMOPORIUM
FOOD LION
FOOD 4 LESS EXCL MW
FRED MEYER EXCL AK
FRY'S
GENUARDI'S
GIANT EAGLE
GIANT CARLISLE
GIANT LANDOVER
HANNAFORD
HARRIS-TEETER
HY VEE
INGLES
[NAME]
KING KULLEN
KING SOOPER W/CITY MKT
KROGER ATLANTA
KROGER CENTRAL
KROGER CINCINNATI
KROGER COLUMBUS
KROGER DALLAS
KROGER DELTA
KROGER HOUSTON
KROGER MICHIGAN
KROGER MID ATLANTIC
KROGER MID-SOUTH
KROGER SOUTHWEST
LOWES FOOD
LUCKY BANNER
MARSH COMPANY
MEIJER
PATHMARK
PENN TRAFFIC
PICK N SAVE
PIGGLY WIGGLY
PRICE CHOPPER
PUBLIX
QUALITY FOOD CENTERS
RAINBOW
RALPHS SOUTH
RALEY'S FAMILY w/NOB HILL
RANDALLS
[NAME]
SAFEWAY EAST
SAFEWAY N CALIFORNIA
SAFEWAY PHOENIX
SAFEWAY PORTLAND
SAFEWAY SEATTLE
SAFEWAY HAWAII
SAFEWAY TTL BNR
SAVE MART BNR
SCHNUCK'S
SENTRY MARKETS
SHAWS/STAR
SHOP N SAVE
SHOPPERS FOOD [NAME]
SHOPRITE
SMITH'S INTERMNT
SMITH'S
SPARTAN WHSL & RETAIL
 | BACK
Spreadsheet: 803971d1667826817-extracting-data-from-excel-tables-sales-control
Sheet: Bank 1

 | Bank 1
 | Date | Nane | I.D Number | Transaction description2 | Invoice | Reference | Debit | Credits | Balance
 | 44866 |  |  | Opening Balance |  |  |  |  | 100
 | 44870 | Abi | A002 | Sales |  | 23 | 3000
 | 44870 | Bigboy | A003 | Sales |  | 24 | 2000
 | 44872 | Bern | A005 | Purchase |  | 100 |  | 300
 | 44872 | Rose | A001 | Sales |  |  | 500
 | 44873 | [NAME] | A006 | Purchase |  | 101 |  | 1000
 | 44874 | ADAM | A008 | Rent |  | 102 |  | 500
 | 44874 | [NAME] | A006 | Purchase |  | 103 |  | 300
 | 44875 | [NAME] | A006 | Purchase |  | 101 |  | 1000
Spreadsheet: 725081d1616520300-formula-needed-for-several-scenerios-summary-report
Sheet: July-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC # | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | CR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 12430.46 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 |  |  |  |  |  | 2537.41
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 4139.48 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 |  |  |  |  |  | 1181.25
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 |  |  |  |  |  | 8030.23
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 2458.07 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 |  |  |  |  |  | 838.49
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 845.2 | 1448.59 |  |  |  |  |  | 16282.43
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1040.88 |  |  |  |  |  | 8103.95
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18708.56 | 463.06 | 373.47 |  |  |  |  |  | 2383.56
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 265.16 |  |  |  |  |  | 4300.14
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84057.14 | 76.31 | 67.07 |  |  |  |  |  | 1438.62
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 | 1652.36 | 1279.49 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 |  |  |  |  |  | 2669.68
Used | 1234 | Example Name | 0 | 0 | -2537.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 | -1181.25 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -8030.23 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 | -838.49 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -845.2
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2383.56 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1438.62 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 | -1652.36 | -1017.32 | 0 | 0 | 0 | 0
Remaining/Carried Forward | 1234 | Example Name | 0 | 0
Remaining/Carried Forward | 2345 | Example Name | 0 | 0
Remaining/Carried Forward | 3456 | Example Name | 0 | 0
Remaining/Carried Forward | 4567 | Example Name | 0 | 0
Remaining/Carried Forward | 5678 | Example Name | 0 | 0
Remaining/Carried Forward | 6789 | Example Name | 0 | 0
Remaining/Carried Forward | 7890 | Example Name | 0 | 0
Remaining/Carried Forward | 8901 | Example Name | 0 | 0
Remaining/Carried Forward | 9012 | Example Name | 0 | 0
Remaining/Carried Forward | 9013 | Example Name | 0 | 0
Spreadsheet: 702733d1604505396-returning-the-latest-status-example-3
Sheet: Report by Order ID

Service ID | Status | [NAME] service start date | [NAME] service end date
805335145 | Active | 2019-08-14 00:00:00
805335414 | Active | 2019-01-28 00:00:00
805337155 | Active | 2019-08-06 00:00:00
805337155 | Ceased | 2019-07-10 00:00:00 | 2019-07-10 00:00:00
805337226 | Ceased | 2019-01-23 00:00:00 | 2019-01-23 00:00:00
805356890 | Active | 2019-01-16 00:00:00
805423465 | Active | 2020-01-20 00:00:00
805424773 | Ceased | 2018-12-20 00:00:00 | 2018-12-20 00:00:00
805424990 | Active | 2019-05-03 00:00:00
805425992 | Active | 2019-02-14 00:00:00
805426479 | Active | 2019-06-04 00:00:00
805426573 | Active | 2019-02-14 00:00:00
805426949 | Ceased | 2018-12-28 00:00:00 | 2018-12-28 00:00:00
805427007 | Active | 2019-04-17 00:00:00
805427082 | Active | 2019-05-22 00:00:00
805427373 | Active | 2019-08-06 00:00:00
805427373 | Ceased | 2018-12-28 00:00:00 | 2018-12-28 00:00:00
805427998 | Active | 2019-02-18 00:00:00
805428235 | Active | 2019-02-15 00:00:00
 | Active | 2019-07-01 00:00:00
Spreadsheet: 870826d1717267569-sumifs-not-working-as-i-thought-it-would-expenses
Sheet: Records

 |  |  |  |  | Date of expenditure | Category | Amount
 |  |  |  |  | 2024-05-09 00:00:00 | Food | 17.51
 |  |  |  |  | 2024-05-21 00:00:00 | Food | 13.17
 |  |  |  |  | 2024-05-21 00:00:00 | Food | 4.52
 |  |  |  |  | 2024-04-13 00:00:00 | Travel | 79.5
 |  |  |  |  | 2024-04-18 00:00:00 | Travel | 5.6
 |  |  |  |  | 2024-04-22 00:00:00 | Travel | 113.9
 |  |  |  |  | 2024-04-24 00:00:00 | Travel | 79.5
 |  |  |  |  | 2024-04-28 00:00:00 | Travel | 15.8
 |  |  |  |  | 2024-05-03 00:00:00 | Travel | 113.9
 |  |  |  |  | 2024-05-07 00:00:00 | Travel | 196.7
 |  |  |  |  | 2024-05-09 00:00:00 | Travel | 3.8
 |  |  |  |  | 2024-05-10 00:00:00 | Travel | 53.5
 |  |  |  |  | 2024-05-12 00:00:00 | Travel | 50.5
 |  |  |  |  | 2024-05-14 00:00:00 | Travel | 3.8
 |  |  |  |  | 2024-05-21 00:00:00 | Travel | 4.85
 |  |  |  |  | 2024-04-24 00:00:00 | Hospitality | 42.94
 |  |  |  |  | 2024-04-30 00:00:00 | Hospitality | 19.21
 |  |  |  |  | 2024-05-02 00:00:00 | Hospitality | 9.6
 |  |  |  |  | 2024-05-08 00:00:00 | Hospitality | 11.3
 |  |  |  |  | 2024-05-20 00:00:00 | Hospitality | 41.81
 |  |  |  |  | 2024-05-09 00:00:00 | Hospitality | 45.1
 |  |  |  |  | 2024-05-23 00:00:00 | Hospitality | 45.85
 |  |  |  |  | 2024-05-13 00:00:00 | Hospitality | 35.95
 |  |  |  |  | 2024-04-29 00:00:00 | Food | 14.5
 |  |  |  |  | 2024-04-29 00:00:00 | Food | 31.2
 |  |  |  |  | 2024-05-08 00:00:00 | Food | 26
 |  |  |  |  | 2024-05-09 00:00:00 | Food | 3.8
 |  |  |  |  | 2024-05-13 00:00:00 | Food | 40.35
Spreadsheet: 1fbaafda-7640-4a13-9551-073ac8b98b44
Sheet: HOMELESS

Grant: |  | McKinney-Vento Homeless |  |  |  |  |  |  | McKinney-Vento Homeless
CFDA # |  | 84.196
GRANT NUMBER: |  | 5196
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Limited to 15%
Question regarding payments: |  | [NAME]  [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez [PHONE] or [EMAIL]
GBL/ORG: |  | 273C/7000
LAST DAY TO SUBMIT REQUEST FOR THIS GRANT  - November 15, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | JULY 2012 | AUGUST 2012 | SEPTEMBER 2012 | OCTOBER 2012 | NOVEMBER 2012 | DECEMBER 2012 | JANUARY 2013 | FEBRUARY 2013 | MARCH 2013 | APRIL 2013 | MAY 2013 | JUNE 2013 | JULY 2013 | AUGUST 2013 | SEPTEMBER 2013 | OCTOBER 2013 | NOVEMBER 2013 | DECEMBER 2013
0020 | Adams 12 | 54859 |  |  |  |  |  |  | 11989 |  | 3190 | 4606 |  | 6400 | 10550 |  |  | 9464 | 4109
0030 | Adams 14 |  |  |  |  |  |  | 6594 |  | 3074 | 5280 | 3477 | 3339 | 2696 | 5333 |  |  | 4247 |  |  | 49
0070 | Adams 50 |  |  |  |  |  |  | 2103 | 3016 | 5741 | 8525 | 3900 | 3140 | 2704 | 159 |  | 2431 | 6931 | 568 |  | 3648
0123 | [NAME] | 19500 |  |  |  |  |  |  |  |  |  | 6183 |  |  |  |  |  |  |  | 2302 |  | 11015
0180 | APS |  |  |  |  |  |  | 7178 | 3387 | 2695 | 2800 | 2771 | 3118 | 3568 | 3071 | 3026 | 2880 | 6075
0470 | St Vrain |  |  |  |  |  |  | 1818 |  | 4667 |  |  | 7510 | 4195 | 9474 |  |  |  |  | 6627
0480 | BVSD | 44000 |  |  |  |  |  | 3079 | 2133 |  | 2100 | 5743 | 2586 | 2304 | 4528 | 2744 | 2640 |  | 4606 | 11537
0880 | DPS | 44000 |  |  |  |  |  |  | 12882 | 4132 | 4746 | 3489 | 3311 |  | 1943 | 676 |  |  |  | 12821
1000 | Fountain | 24500 |  |  |  |  |  | 6141 | 2046 | 2048 | 2047 | 2046 | 2074 | 2061 | 2062 | 2061 | 1914
1420 | Jeffco |  |  |  |  |  |  |  | 3036 | 456 | 4901 | 1268 | 1110 | 1462 | 1092 | 2518 | 7425 | 2623
1550 | Poudre |  |  |  |  |  |  |  |  |  |  | 21976 |  | 4255 |  |  | 9935 |  |  | 3127
2000 | Mesa 51 | 37000 |  |  |  |  |  | 3776 | 3740 |  |  | 3209 | 3528 | 2651 | 2265 | 3028 | 6067
2690 | Pueblo 60 | 44000 |  |  |  |  |  |  | 1473 |  | 7697 |  |  | 6951 |  |  |  |  | 4277 | 1671
2790 | Mt. Valley | 9800 |  |  |  |  |  |  |  |  | 4301 |  |  |  | 5499
3120 | [NAME] 6 |  |  |  |  |  |  |  | 7148 | 1056 | 1954 | 3067 | 2798 | 2855 | 2106 | 2961 | 4763
9035 | CBOCES | 44500 |  |  |  |  |  |  | 5248 | 4224 | 2868 | 3600 | 3200 | 3300 | 2900 | 3977 | 2538
9055 | SLVBOCES | 43985 |  |  |  |  |  |  |  |  |  | 25058 |  |  | 10026 |  | 6677
Spreadsheet: 879310d1726792364-intersection-formula-to-populate-matrix-where-matching-combinations-were-found-formula-for-intersection
Sheet: Formula

MOD_REF | ORG_REF |  |  | O01 | O02 | O03 | O04 | O05 | O06 | O07 | O08 | [NAME] | O10 | O11 | O12 | O13 | O14 | O15 | O16 | O17 | O18 | O19 | O20 | O21 | O22 | O23
M16 | O01 |  | M01
M18 | O01 |  | M02
M26 | O01 |  | M03
M36 | O01 |  | M04
M38 | O01 |  | M05
M01 | O02 |  | M06
[NAME] | O02 |  | M07
M16 | O02 |  | M08
M18 | O02 |  | M09
M19 | O02 |  | M10
M24 | O02 |  | M11
M26 | O02 |  | M12
M29 | O02 |  | [NAME]
M32 | O02 |  | M14
M36 | O02 |  | M15
M38 | O02 |  | M16 | x
M26 | O03 |  | [NAME]
M09 | O04 |  | M18 | x
[NAME] | O04 |  | M19
M16 | O04 |  | M20
M18 | O04 |  | M21
M19 | O04 |  | M22
M23 | O04 |  | M23
M24 | O04 |  | M24
M26 | O04 |  | M25
M29 | O04 |  | M26
M31 | O04 |  | M27
M32 | O04 |  | M28
M36 | O04 |  | M29
M37 | O04 |  | M30
M38 | O04 |  | M31 |  |  |  | x
M09 | O05 |  | M32
M11 | O05 |  | M33
[NAME] | O05 |  | M34
M16 | O05 |  | M35
M18 | O05 |  | M36
M19 | O05 |  | M37
M23 | O05 |  | M38
M24 | O05
M26 | O05
M29 | O05
M31 | O05
M32 | O05
M36 | O05
M37 | O05
M38 | O05
M01 | O06
M07 | O06
M08 | O06
[NAME] | O06
M16 | O06
M18 | O06
M19 | O06
M20 | O06
M22 | O06
M24 | O06
M26 | O06
M29 | O06
M32 | O06
M33 | O06
M34 | O06
M35 | O06
M36 | O06
M37 | O06
M38 | O06
[NAME] | O07
M18 | O07
M24 | O07
M26 | O07
M36 | O07
M38 | O07
M01 | O08
M06 | O08
M07 | O08
M08 | O08
[NAME] | O08
M16 | O08
M18 | O08
M19 | O08
M20 | O08
M24 | O08
M26 | O08
M29 | O08
M32 | O08
M33 | O08
M36 | O08
M37 | O08
M38 | O08
M07 | [NAME]
M18 | [NAME]
M19 | [NAME]
M24 | [NAME]
M26 | [NAME]
M36 | [NAME]
M38 | [NAME]
M01 | O10
M02 | O10
M04 | O10
M07 | O10
[NAME] | O10
M16 | O10
M18 | O10
M19 | O10
M22 | O10
M24 | O10
M26 | O10
M29 | O10
M32 | O10
M36 | O10
M37 | O10
M38 | O10
[NAME] | O11
M16 | O11
M18 | O11
M19 | O11
M24 | O11
M26 | O11
M36 | O11
M38 | O11
M07 | O12
[NAME] | O12
M16 | O12
[NAME] | O12
M18 | O12
M19 | O12
M20 | O12
M24 | O12
M26 | O12
M29 | O12
M32 | O12
M36 | O12
M37 | O12
M38 | O12
M09 | O13
[NAME] | O13
M15 | O13
M16 | O13
[NAME] | O13
M18 | O13
M19 | O13
M20 | O13
M22 | O13
M24 | O13
M26 | O13
M29 | O13
M30 | O13
M32 | O13
M34 | O13
M35 | O13
M36 | O13
M38 | O13
M10 | O14
[NAME] | O14
M16 | O14
M18 | O14
M20 | O14
M24 | O14
M26 | O14
M29 | O14
M36 | O14
M38 | O14
M24 | O15
M26 | O15
M29 | O15
M36 | O15
M38 | O15
[NAME] | O16
M16 | O16
M18 | O16
M19 | O16
M24 | O16
M26 | O16
M29 | O16
M32 | O16
M36 | O16
M38 | O16
M03 | O17
M03 | O17
M05 | O17
M12 | O17
[NAME] | O17
M14 | O17
M16 | O17
M18 | O17
M19 | O17
M21 | O17
M22 | O17
M22 | O17
M22 | O17
M24 | O17
M25 | O17
M27 | O17
M29 | O17
M32 | O17
M36 | O17
M38 | O17
[NAME] | O18
M18 | O18
M24 | O18
M26 | O18
M29 | O18
M36 | O18
M38 | O18
M18 | O19
M26 | O19
M32 | O19
M38 | O19
[NAME] | O20
M16 | O20
M18 | O20
M19 | O20
M24 | O20
M26 | O20
M29 | O20
M32 | O20
M36 | O20
M38 | O20
[NAME] | O21
M16 | O21
M18 | O21
M19 | O21
M22 | O21
M24 | O21
M26 | O21
M28 | O21
M29 | O21
M32 | O21
M36 | O21
M38 | O21
M18 | O22
M19 | O22
M24 | O22
M26 | O22
M29 | O22
M36 | O22
M38 | O22
M18 | O23
M36 | O23
M38 | O23
Spreadsheet: 669120d1585217296-solver-delivery-planning-delivery_planning-hydr2-
Sheet: Feuil1

 |  |  | Shipping quantity (t)
customer | Shipping quantity (t) | Deadline delivery (week) | week 3 | week 4 | week 5 | week 6
[NAME] | 30 | 3 | 30 | 0 | 0 | 0 |  | =
Michelle | 100 | 5 | 0 | 0 | 100 | 0 |  | =
[NAME] | 75 | 6 | 0 | 0 | 6 | 69 |  | =
[NAME] | 50 | 5 | 0 | 6 | 44 | 0 |  | =
Valery | 159 | 3 | 159 | 0 | 0 | 0 |  | =
[NAME] | 64 | 4 | 0 | 64 | 0 | 0 |  | =
Total
 |  | contraints
 |  |  | <= | <= | <= | <=
 | truck payload (t) |  | 189 |  | 150
Spreadsheet: 884327d1733416146-conditional-adding-example3
Sheet: Sheet1

Pair | Buy price | Size | Reserve
EURUSDTSHORT 16 | 6970.15924060414 | 732537.3
Add Reserve |  | 12153.28
EURUSDTLONG 20 | 7268.15279022877 | 708057.36
EURUSDTLONG 20 | 7446.54696768 | 737361.33
Add Reserve |  | 2114.03
EURUSDTLONG 20 | 8045.55126290948 | 1039588.44
Add Reserve |  | 96.78
EURUSDTLONG 20 | 8025.35258067907 | 1081895.74
Add Reserve |  | 589.56
EURUSDTLONG 12 | 8404.83306199336 | 709289.86
Add Reserve |  | 3128.24
EURUSDTLONG 20 | 8957.96784322828 | 1304639.74
EURUSDTSHORT 10 | 8640.86612497366 | 729218.57
Add Reserve |  | 399.08
EURUSDTLONG 10 | 8726.38974294753 | 741405.14
Add Reserve |  | 6765.54
EURUSDTLONG 24 | 9456.61284334023 | 2064336.08
EURUSDTSHORT 23 | 9262.93194490644 | 2091009.97
Add Reserve |  | 684.58
EURUSDTLONG 20 | 9394.79264656037 | 1928936.82
Add Reserve |  | 18102.94
EURUSDTSHORT 21 | 9997.07847676397 | 3056131.82
EURUSDTLONG 11 | 10251.7072986215 | 1805862.71
EURUSDTSHORT 11 | 9541.267034273 | 1850500.38
Add deposit |  | 44034.07 | $0,00
EURUSDTSHORT 19 | 9556.97402369288 | 2574577.56
Add Reserve |  | 72091.87
EURUSDTLONG 12 | 9095.8577753263 | 2609341.04
EURUSDTSHORT 20 | 8954.70146689864 | 4091802.3
Add Reserve |  | 50946.34
EURUSDTSHORT 14 | 7652.46242478179 | 5859823.21
Add deposit |  | 123038.22 | $0,00
EURUSDTSHORT 11 | 7615.79195159953 | 3940991.73
Add Reserve |  | 391380.37
Out |  | 1224068.03
Spreadsheet: 0442c9f2-30dc-4cc0-8949-0c2e0acac3ed
Sheet: Served Tracking

CMH Clients Served | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
Region 1 | 68 | 65 | 55 | 63 | 57 | 63 | 69 | 68 | 70 | 76 | 68 | 61 | 66 | 74 | 79 | 79
Region 2 | 67 | 70 | 69 | 73 | 71 | 80 | 84 | 69 | 85 | 80 | 81 | 74 | 72 | 60 | 68 | 75
Region 3 | 70 | 76 | 67 | 67 | 81 | 72 | 77 | 79 | 81 | 82 | 86 | 83 | 89 | 80 | 80 | 86
Region 4 | 132 | 130 | 126 | 153 | 152 | 158 | 175 | 161 | 181 | 187 | 169 | 166 | 170 | 158 | 165 | 162
Region 5 | 72 | 67 | 69 | 87 | 75 | 77 | 85 | 86 | 95 | 96 | 99 | 90 | 85 | 89 | 82 | 91
Region 6 | 54 | 48 | 53 | 58 | 55 | 51 | 58 | 61 | 69 | 65 | 68 | 59 | 51 | 47 | 49 | 60
Region 7 | 167 | 188 | 185 | 180 | 172 | 157 | 170 | 172 | 189 | 180 | 189 | 206 | 203 | 179 | 167 | 164
CMH Clients Served |  |  |  |  |  |  |  |  |  | 766 | 760 |  | 736 | 687 | 690 | 717
AMH Clients Served | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00
Region 1 | 324 | 336 | 305 | 342 | 349 | 348 | 323 | 302 | 329 | 337 | 334 | 333 | 361 | 348 | 343 | 379
Region 2 | 220 | 221 | 230 | 251 | 221 | 223 | 227 | 205 | 226 | 225 | 200 | 197 | 213 | 189 | 182 | 195
Region 3 | 438 | 430 | 426 | 475 | 484 | 584 | 615 | 580 | 571 | 615 | 623 | 578 | 638 | 653 | 631 | 676
Region 4 | 608 | 644 | 627 | 648 | 572 | 602 | 649 | 647 | 625 | 652 | 683 | 662 | 688 | 710 | 713 | 676
Region 5 | 302 | 245 | 221 | 248 | 243 | 234 | 250 | 240 | 239 | 231 | 247 | 258 | 265 | 271 | 258 | 262
Region 6 | 269 | 249 | 220 | 225 | 231 | 228 | 244 | 219 | 256 | 268 | 261 | 255 | 242 | 275 | 249 | 270
Region 7 | 478 | 545 | 449 | 486 | 462 | 488 | 477 | 459 | 495 | 518 | 480 | 530 | 539 | 555 | 538 | 583
AMH Clients Served |  |  |  |  |  |  |  |  |  | 2846 | 2828 |  | 2946 | 3001 | 2914 | 3041
Spreadsheet: 757017d1637939184-probability-function-find-distrib
Sheet: solver freq

 | mean | std dev | min | median | [NAME] | total | count
Choice1 |  | 4.6 | 1 | 5 | 27 | 16919 | 2850
Choice2 |  | 6.1 | 2 | 11 | 35 | 33786 | 2850
Choice3 |  | 6.7 | 3 | 17 | 39 | 50124 | 2850
Choice4 |  | 6.7 | 4 | 24 | 41 | 67228 | 2850
Choice5 |  | 6.2 | 9 | 30 | 43 | 84160 | 2850
Choice6 |  | 5 | 12 | 37 | 44 | 101005 | 2850
choice #1
numbers | prob distrib | [NAME] | stats
1 |  | 311.5770645058976 |  | goal=0
2 |  | 322.7145913468385 |  | count
3 |  | 365.1626239061839 |  | < med
4 |  | 425.545720242493 |  | >= med
5 |  | 409.5352756420506 |  | mean
6 |  | 87.69504531499788 |  | sd
7 |  | 113.838577169484
8 |  | 91.99516865137491
9 |  | 169.8922496937862
10 |  | 3
11 |  | 145.2606319855581
12 |  | 139.8113422264855
13 |  | 129.0401031107479
14 |  | 3
15 |  | 13.30928362606462
16 |  | 64.79485055369592
17 |  | 3.000000000000005
18 |  | 3.088985775516425
19 |  | 3.197746226732924
20 |  | 3.326281524092769
21 |  | 3.474591213080594
22 |  | 3.64267555883037
23 |  | 3.830534712847204
24 |  | 4.038168125925049
25 |  | 4.26557659346577
26 |  | 4.512759623077734
27 |  | 17.45015267218579
Spreadsheet: 781589d1653424643-return-number-value-based-on-text-in-a-different-cell-gold-siver-bronze-values-etaf
Sheet: Sheet1

"Silver - Some questions asked,
"Silver - Some
been appropriate" "Silver - Some questions asked,
been appropriate" "Silver - Some questions asked,
Some questions asked,
"GOLD - Some
been appropriate" "GOLD - Some questions asked,
been appropriate" "GOLD - Some questions asked,
"Bronze - Some questions asked,
"Bronze - Some
been appropriate" "Bronze - Some questions asked,
been appropriate" "Bronze - Some questions asked,
Spreadsheet: 77854d1278353952-excel-2007-averaging-no-blanks-and-no-zeros-over-several-sheets-test-monthly
Sheet: WK1 Fri

 | Monthly Total
 | Desktop |  | Network |  |  |  | Install | Add |  |  | Total
 | Opened |  | Opened
 | Closed |  | Closed
 | Backlog |  | Backlog
 | Frozen |  | Frozen
 | Active Install Tickets |  | 4
 | Install Tickets Frozen |  | 4
 | Install Tickets in Responded |  | 4
Spreadsheet: 848996d1699565492-date-format-doing-my-head-in-book1-10-aligw
Sheet: Sheet1

 | 2023-05-09 00:00:00 | C | 6216AEV483
 | 2023-05-09 00:00:00 | C | 6216AEV480
 | 31/05/23 | O | 649444
 | 2023-06-07 00:00:00 | I | 6216AES129
 | 21/10/23 | C | 6216AEY303
 | 17/07/23 | I | 6216AES677
 | 31/10/23 | C | 6216AEZ023
 | 2023-02-08 00:00:00 | I | 6165AEC741
 | 2023-04-08 00:00:00 | I | 6165AEC796
 | 2023-04-08 00:00:00 | I | 6165AEC800
 | 2023-04-08 00:00:00 | I | 6165AEC801
 | 2023-04-08 00:00:00 | I | 6165AEC802
 | 2023-07-08 00:00:00 | I | 6165AEC883
 | 28/09/23 | C | 6165AEF319
 | 2023-10-08 00:00:00 | I | 6216AEU116
 | 31/10/23 | C | 6216AEZ024
 | 15/08/23 | I | 6216AEU414
 | 21/10/23 | C | 6216AEY302
 | 2023-07-09 00:00:00 | C | 6216AEV636
 | 2023-07-09 00:00:00 | C | 6216AEV637
 | 2023-07-09 00:00:00 | C | 6216AEV638
 | 2023-07-09 00:00:00 | C | 6216AEV639
 | 2023-07-09 00:00:00 | C | 6216AEV640
 | 28/09/23 | C | 6165AEF318
 | 29/08/23 | I | 6216AEV123
 | 29/08/23 | I | 6216AEV124
 | 14/09/23 | C | 6216AEV989
 | 14/09/23 | C | 6216AEV990