tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 207412d1358450293-neatly-present-data-from-a-multi-record-file-producer-example
Sheet: DATA

Last | First | Height | Weight | Eye Color | Vocal Range | InstrumentsPlayed | SummStockPERFExperience | SummStockSpecialSkills | Summer Stock Auditioning for... Area | SummStock Available Dates | SummStock Classical Piece | SummStock Summer or Year Round | SummStockMUSICALTimeSlot
Adams | [NAME] | 5'2" | 145 | [NAME] | Soprano | Tuba | Boeing Boeing - Bernard - Doane College_x000D_ A Funny Thing Happened On The Way To The Forum - Hysterium - Prairie Repertory Theatre_x000D_ Leading Ladies - Jack Gable - Prairie Repertory Theatre_x000D_ | Amateur stilt walker, experienced in educational theatre, competent sewer, and | Performance Only | May 27 to Aug 11 | Classical: No | Summer Only Avail
[NAME] | [NAME] | 5'9 | 140 | Blue | Tenor |  | Pirate-Pirates Of Panzance(Wichita State)_x000D_ [NAME] In The Park)_x000D_ Marcellus-Hamlet(K State) | Can whistle, Raise one Eyebrow, Can Jump High, Grow a beard | Performance Only | Late May- Late August | Classical: No | Summer Only Avail
Smith | [NAME] | 5' 4'' | 140 | Blue | F below middle C to high A flat | basic flute and piano | Play: Circle Mirror Transformation Role: Theresa School: [NAME] University._x000D_ Play: [NAME], a Parable Role: Sister Aloysius School: [NAME] University._x000D_ Play: Dividing the Estate Role: Lucille School: Buena Vista University.   _x000D_ | Singing, hula hooping, viewpoint theory, southern dialect, photoshop, German accent. | Either/Both D&T & Perf | May 27 to Aug 11 | Classical: YES | Summer Only Avail
[NAME] | [NAME] | 5'8" | 155 | Blue | Baritone | 5 string bass guitar, 6 string acoustic and electric, mandolin, kazoo | Boeing Boeing - Bernard - Doane College_x000D_ A Funny Thing Happened On The Way To The Forum - Hysterium - Prairie Repertory Theatre_x000D_ Leading Ladies - Jack Gable - Prairie Repertory Theatre_x000D_ | Driver's license, burp on command, musician, improvisation, classical acting, film acting | Performance Only | Start May 25th, 2013 | Classical: YES | Year Round Avail
[NAME] | [NAME] | 5' 7" | 175 | [NAME] | D3-Ab5 | [NAME] | 9 to 5/ Margaret/ NDSU_x000D_ Anon(ymous)/ Mrs. [NAME], Zyclo's pet bird/ NDSU_x000D_ [NAME] The Wild Party/ Kegs/ NDSU | Amateur stilt walker, experienced in educational theatre, competent sewer, and | Performance Only | June 1-Aug 30 | Classical: No | Summer Only Avail
Spreadsheet: 5b316df9-7e73-470b-be4f-294c7f275ce1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Material- und Personalbedarf
Klasse |  | Übung | Materialbedarf | Personalbedarf
 |  |  |  | Tatigkeit | Name
Klasse ? | Sprint
 | Sprung
 | Wurf
 | Lauf
Klasse ? | Sprint
 | Sprung
 | Wurf
 | Lauf
Klasse ? | Sprint
 | Sprung
 | Wurf
 | Lauf
Klasse ? | Sprint
 | Sprung
 | Wurf
 | Lauf
Klasse ? | Sprint
 | Sprung
 | Wurf
 | Lauf
Spreadsheet: kim_ward__20837__griffith1
Sheet: Sheet1

Citizens Utilities Company
Griffith Power Plant
Gas Supply Proposal #1
Sample Capacity Economics:  Assuming 100% Takes
Transwestern |  |  | Case 1 | Case 2 | Case 3
[NAME] Index = |  |  | 10 | 6 | 38
San Juan Gas Daily Mid-Point = |  |  | 5 | 5 | 5
Spread
[NAME] |  |  | 20 | 20 | 20
Floor |  |  | 3 | 3 | 3
Effective Spread
Price to Griffith
Quantity in Basin
Quantity at Citygate |  |  | 20000 | 20000 | 20000
San Juan Index =
Index Discount |  |  | -0.1 | -0.1 | -0.1
Basin Cost
Pipeline Variable Costs
San Juan Lateral Commodity |  |  | 0.0011 | 0.0011 | 0.0011
Mainline Commodity |  |  | 0.0253 | 0.0253 | 0.0253
Citizens Demand Charge |  |  | 3 | 3 | 3
Transport Spread Premium
Delivered Cost to Griffith
Price to Enron
Gas Costs
Price in Basin
Basin Demand Charge |  |  | 0.07 | 0.07 | 0.07
Total Basin Cost
Total Basin Cost
Pipeline Charges
San Juan - Thoreau
Variable |  |  | 0.0011 | 0.0011 | 0.0011
Fixed |  |  | 0.1031 | 0.1031 | 0.1031
Thoreau - Griffith
Variable |  |  | 0.0253 | 0.0253 | 0.0253
Fixed |  |  | 0.2082 | 0.2082 | 0.2082
Total Pipeline Costs
Total Pipeline Costs
Other Costs
Transwestern Services |  |  | 0.02 | 0.02 | 0.02
Profit to ENA |  |  | 0.13 | 0.13 | 0.13
Total Other Cost
Total Other Cost
Grand Total Cost
Grand Total Cost
Profit to Citizens
Revenue from Griffith
Cost to Enron
Profit
Profit
Spreadsheet: eric_saibi__9939__103101R
Sheet: Comanche 02

Owner Name |  | Public Service Company of Colorado
Station Name |  | Comanche Power Station
Unit Name |  | Comanche 02
NERC Region |  | WSCC
State |  | CO
Fuel Type |  | Coal / Natural Gas
Capacity |  | 350 MW
Start Date |  | 2001-10-01 00:00:00
End Date |  | 2001-11-02 00:00:00
Prv. Start Date |  | 2001-10-01 00:00:00
Prv. End Date |  | 2001-10-30 00:00:00
Comments |  | LP Turbine Inspection
SIC |  | 4911
Plant ID |  | 1016426
Unit ID |  | 1007115
Outage ID |  | 11897
Spreadsheet: 868407d1715159690-calculating-summary-sheet-using-indirect-function-for-multiple-months-payroll-example
Sheet: Summary

Emp Code | [NAME] | Surname | Date Joined | Terminated | Work Month | Total Roster Hour | [NAME] | OW Hour | WW Hour | Total Work Hour | Lateness | Overtime | Early Leave | Total Roster Day | OP Day | OW Day | WW Day | Total Work Days | SL | OFF | NPL | SH | AL
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-04-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-03-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-02-01 00:00:00
147 | [NAME] | [NAME] | 2022-06-01 00:00:00 |  | 2024-01-01 00:00:00
Spreadsheet: 147597d1332874801-formula-to-combine-value-of-two-cells-into-one-one-cell-number-other-text-combine_two_cells_number-and-text-revd-03-27-2012
Sheet: Sheet1

Section | District | District Description | District Description Formulated?
1 | B | 1B
1 | B | 1B
1 | B | 1B
1 | C | 1C
1 | C | 1C
5 | B | 5B
5 | B | 5B
5 | B | 5B
5 | C | 5C
23 | C | 23C
23 | B | 23B
23 | C | 23C
41 | B | 41B
23 | C | 23C
5 | C | 5C
36 | C | 36C
36 | C | 36C
19 | B | 19B
36 | C | 36C
 |  |  |  |  | This color represents what I desire to be formulated (automated) in column D (titled "District Description Formulated").
 |  |  |  |  | This is where I would like the formula to be used and copied down to match the values in column C (titled "District Description).
 | THANK YOU!!!!!!!!!
Spreadsheet: 54439d1254414661-figuring-out-stats-09-eagles-offense
Sheet: RUSHvsPASS

GAME: | EAGLES |  |  |  |  | DATE: | 2009-08-29 00:00:00
 |  |  |  | RUSHING vs. PASSING
 |  |  |  | G A M E   S U M M A R Y
 |  |  | R U S H I N G |  |  | P A S S I N G |  |  |  |  |  |  | R | R | R | R | P | P | P | P
 |  | QTY | YARDS | Prob. | QTY | YARDS | Prob. |  |  |  |  |  | 1st | 2nd | 3rd | 4th | 1st | 2nd | 3rd | 4th
 | 1ST DOWN | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | population_s | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 2ND DOWN | 0 | 0 | 0 | 0 | 0 | 0
 | 3RD DOWN | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 1st | 2nd | 3rd | 4th
 | 4TH DOWN | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | number_population = | 1e-05 | 1e-05 | 0.0001 | 1e-05
 | GAME TOTAL | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 52277d1251986662-data-pick-from-another-tab-rajah_costing_vik
Sheet: Beach

 | STATEMENT OF REVENUE FOR RAJAH BEACH AS ON |  |  |  |  |  |  | 2009-09-03 00:00:00
 | [NAME] | No of Rooms | No of Rooms Occupied | Occupancy % | Room Rate | Room Revenue | Discounts | Net Room Revenue
 | Beach Revenue
 | Ordinary room |  |  | #N/A |  | 0 |  | 0
 | Delux Room |  |  | #N/A |  | 0 |  | 0
 | Cottages |  |  |  |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 |  |  |  | #N/A |  | 0 |  | 0
 | Restaurant
 | Total Revenue |  |  |  |  | 0 |  | 0
 | Costing
 | Fixed Costs
 | Rent / Property Expenses
 | Electricity
 | Water
 | Land Maintenance
 | Interest on capital
 |  | No. | Average Cost | Total Cost
 | Fixed Manpower Costs
 | -- |  |  | 0
 | -- Doctor/ Administrator |  |  | 0
 | -- Cooks / Chef |  |  | 0
 | -- Admin Staff |  |  | 0
 | -- Drivers |  |  | 0
 | -- Massage Crew |  |  | 0
 | -- Support Staff |  |  | 0
 | -- |  |  | 0
 | -- |  |  | 0
 | Total Fixed Costs |  |  | 0
 | Variable Costs (Depending on No. of Patients)
 | Medicine Cost
 | Treatment Materials
 |  | No. | Average Cost | Total Cost
 | Variable Manpower Costs
 | -- |  |  | 0
 | -- Doctor/ Administrator |  |  | 0
 | -- Cooks |  |  | 0
 | -- Admin Staff |  |  | 0
 | -- Drivers |  |  | 0
 | -- Massage Crew |  |  | 0
 | -- Support Staff |  |  | 0
 | -- |  |  | 0
 | -- |  |  | 0
 | Total Variable Costs |  |  | 0
 | Total Costs |  |  | 0
 | Total Profit |  |  | 0
Spreadsheet: 80dbe1d2-a509-4382-928f-ed1804352fc8
Sheet: Lenders

Lenders
Firm Name | Contact Person | [NAME] | Phone Number | Address
Intervest | [NAME] | [EMAIL] | (510) 622-8515 | 180 Grand Ave, Suite 1400, Oakland, CA 94612
[NAME] | [NAME] | [EMAIL] | (415) 419-8811 | 819 Mitten Road, Burlingame, CA 94010
California Mortgage Advisors | [NAME] | [EMAIL] | (415) 562-6411 | 2147 Union St. San Francisco, CA 94123 (Place this table next to Structured Finance)
One PacificCoast Bank | [NAME] | [EMAIL] | (510) 550-8408 | 1438 [NAME], Suite 100, Oakland, CA 94612
Structured Finance Associates | [NAME] | [EMAIL] | (760) 304-4371
Wells Fargo | [NAME] | [EMAIL] | (415) 537-8248 | 333 Market Street, 25th Floor | San Francisco, CA 94105
First Republic Bank | [NAME] | [EMAIL] | (415) 392-1400 | 111 Pine Street, San Francisco,CA 94111
Portrush Wealth | [NAME] | [EMAIL] | (480) 518-3539
Jones Pacific Land Company, Inc. | [NAME] | [EMAIL] | (800) 985-1865 | 25 Kearny Street, Suite 302, San Francisco, CA 94108
Capital Trust Advisors | [NAME] | [EMAIL] | (415) 577-4685
Sterling Bank | [NAME] | [EMAIL] | (415) 773-1530 x49120 | 400 Montgomery Street, Ste. 100, San Francisco, CA 94104
SF Fire Credit Union | [NAME] | [EMAIL] | (415) 674-4800 | 3201 California Street, San Francisco, CA 94118
Trust Deed Investments, Inc. | [NAME] | [EMAIL] | (415) 864-8403 | 414 Gough Street, #2 San Francisco, CA 94102
Rubicon Mortgage Fund, LLC | [NAME] | [EMAIL]
First Bank | [NAME] | [EMAIL] | (415) 273-2016 | 460 Montgomery Street  San Francisco, CA 94104
Spreadsheet: 122441d1316799335-repeating-vertical-data-to-horizontal-layout-without-repeats-steepleboy04-pivot
Sheet: Sheet1

[NAME] | Component | Parts |  | Sum of Parts | Column Labels
1 | 10 | 50 |  | Row Labels | 10 | 20 | 30
1 | 20 | 50 |  | 1 | 50 | 50
2 | 10 | 100 |  | 2 | 100
3 | 10 | 50 |  | 3 | 50 | 25 | 25
3 | 20 | 25
3 | 30 | 25
Spreadsheet: 804237d1667960365-formula-to-count-the-number-of-dates-entered-invoice-bvj-
Sheet: Sheet1

Stable Name
Address
Address 2
[NAME] Period: | October 01-31, 2022
Horse Owner Name
Address
Address 2
Horse Name:
Board |  |  |  |  | 100
NYS 7% Tax
Turnout, Lunge & Walks
Date/s | 01, 02, 03, 04, 05, 07, 08, 09,10,12,14,15,16, |  | 6
 | 17,19, 21, 23, 24, 25, 26, 27, 29, 30
Staff [NAME]
Date/s | 03, 07,13, 20, 28 |  | 20
Lessons
Date/s (Semi Private) | 22 |  | 40
Date/s (Private) | 01, 06, 08,13,15, 20, 27 |  | 45
Special Care
Subtotal
Previous Balance:
Payments Received:
Balance carried forward:
Please Remit
Spreadsheet: 885701d1735528582-create-multiple-vertical-lines-programmatically-from-single-cell-mcmxd-sample-workbook-error
Sheet: Export

 |  | Start date | Start time | End date | End time | Description
 | Day | 2024-02-03 00:00:00 | 07:30:00 | 2024-02-03 00:00:00 | 17:30:00 | Days (Wed off)
 | Day | 2024-02-04 00:00:00 | 07:30:00 | 2024-02-04 00:00:00 | 17:30:00 | Days (Wed off)
 | Day | 2024-02-06 00:00:00 | 07:30:00 | 2024-02-06 00:00:00 | 17:30:00 | Days (Wed off)
 | Day | 2024-02-07 00:00:00 | 07:30:00 | 2024-02-07 00:00:00 | 17:30:00 | Days (Wed off)
 | Day | 2024-02-10 00:00:00 | 07:30:00 | 2024-02-10 00:00:00 | 17:30:00 | Days ([NAME] off)
 | Day | 2024-02-11 00:00:00 | 07:30:00 | 2024-02-11 00:00:00 | 17:30:00 | Days ([NAME] off)
 | Day | 2024-02-12 00:00:00 | 07:30:00 | 2024-02-12 00:00:00 | 17:30:00 | Days ([NAME] off)
 | Day | 2024-02-13 00:00:00 | 07:30:00 | 2024-02-13 00:00:00 | 17:30:00 | Days ([NAME] off)
 | Evening | 2024-03-09 00:00:00 | 12:00:00 | 2024-03-09 00:00:00 | 22:00:00 | RLEAVE
 | On Call | 2024-03-09 00:00:00 | 22:00:00 | 2024-03-10 00:00:00 | 07:30:00 | RLEAVE
 | Evening | 2024-03-10 00:00:00 | 12:00:00 | 2024-03-10 00:00:00 | 22:00:00 | WEEKDAY EVENING
 | Evening | 2024-03-11 00:00:00 | 12:00:00 | 2024-03-11 00:00:00 | 22:00:00 | WEEKDAY EVENING
 | On Call | 2024-03-11 00:00:00 | 22:00:00 | 2024-03-12 00:00:00 | 07:30:00 | WEEKDAY EVENING
 | Evening | 2024-03-12 00:00:00 | 12:00:00 | 2024-03-12 00:00:00 | 22:00:00 | WEEKDAY EVENING
 | Day | 2024-03-16 00:00:00 | 07:30:00 | 2024-03-16 00:00:00 | 17:30:00 | WEEKDAY EVENING
 | Day | 2024-03-17 00:00:00 | 07:30:00 | 2024-03-17 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-03-21 00:00:00 | 07:30:00 | 2024-03-21 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-03-22 00:00:00 | 07:30:00 | 2024-03-22 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-03-23 00:00:00 | 07:30:00 | 2024-03-23 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-03-25 00:00:00 | 07:30:00 | 2024-03-25 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-03-26 00:00:00 | 07:30:00 | 2024-03-26 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-03-27 00:00:00 | 07:30:00 | 2024-03-27 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-03-30 00:00:00 | 07:30:00 | 2024-03-30 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-03-31 00:00:00 | 07:30:00 | 2024-03-31 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-04-04 00:00:00 | 07:30:00 | 2024-04-04 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-04-05 00:00:00 | 07:30:00 | 2024-04-05 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-04-06 00:00:00 | 07:30:00 | 2024-04-06 00:00:00 | 17:30:00 | WEEKEND DAYS 10
 | Day | 2024-04-08 00:00:00 | 07:30:00 | 2024-04-08 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-04-09 00:00:00 | 07:30:00 | 2024-04-09 00:00:00 | 17:30:00 | DAYS (Tue Off)
 | Day | 2024-04-10 00:00:00 | 07:30:00 | 2024-04-10 00:00:00 | 17:30:00 | DAYS (Tue Off)
Spreadsheet: david_delainey__8087__Q400
Sheet: Sheet1

 |  | [NAME] |  | Q4
 |  | East | [NAME]
 |  |  |  |  |  | Probability | Key Issues
 |  | [NAME] |  |  | 10
 |  | NJN or PSEG |  |  | 10
 |  | Chicago Hub |  |  | 8
 |  | Alamac |  |  | 6
 |  | AES/Calvert City |  |  | 5
 |  | Intergen |  |  | 2
 |  | NYSEG |  |  | 2
 |  | AES NY |  |  | 1
 |  | West | Calger
 |  | Pastoria |  |  | 30
 |  | LV |  |  | 10
 |  | Ahlstrom |  |  | 5
 |  | PSCo |  |  | 4
 |  | DWR |  |  | 2
 |  | WAPA |  |  | 2
 |  | Calif -LODI |  |  | 1
 |  | [NAME] | Duran
 |  | [NAME] |  |  | 10
 |  | ANP |  |  | 10
 |  | Dynegy |  |  | 8
 |  | Alhstrom |  |  | 8
 |  | Canada | Milly
 |  | British Energy |  |  | 50
 |  | PML |  |  | 4
 |  | Sunoco PPA |  |  | 2
 |  | [NAME] |  |  | 2
 |  | Petro |  |  | 2
 |  | Mexico | [NAME]
 |  | Vitro |  |  | 30
 |  | [NAME] |  |  | 10
 |  | PI | Donahue
 |  | Utiliquest |  |  | 12
 |  | Upstream Orig | Mrha
 |  | Blackwater |  |  | 6
 |  | JM Huber |  |  | 4
 |  | NUI |  |  | 2
 |  | North Central Oil |  |  | 1
 |  | ECR | Thompson/Josey
 |  | ?? |  |  | ??
 |  | Total
Spreadsheet: 464488d1465153087-how-count-occurences-in-multiple-separated-columns-using-countif-or-other-function-tr-eng
Sheet: K.Pisarska ORG

MIESIĘCZNY  PLAN  TRAS
 | Region....................................... |  |  |  |  |  | [NAME]
Lp. | PONIEDZIAŁEK  I | TYP KLIENTA | TYP WIZYTY | WTOREK  I | TYP KLIENTA | TYP WIZYTY | ŚRODA  I | TYP KLIENTA | TYP WIZYTY | CZWARTEK  I | TYP KLIENTA | TYP WIZYTY | PIĄTEK  I | TYP KLIENTA | TYP WIZYTY
1. | MAKRO AL.JEROZOLIMSKIE |  |  | SELGROS POŁCZYŃSKA |  |  | K&M PATRIOTÓW |  |  | MAKRO AL. JEROZOLIMSKIE |  |  | AUCHAN GÓRCZEWSKA
2. | [NAME] |  |  | HALA WOLA |  |  | K&M WSPÓLNA |  |  | CENTRAL AL. JEROZOLIMSKIE |  |  | PIP BLUE CITY
3. | PIP BLUE CITY |  |  | BAGPOL |  |  | K&M TRAKT BRZESKI |  |  | PIP STAWKI |  |  | BAGPOL
4. | AUCHAN ŁOMIANKI |  |  | PIP BRWINÓW |  |  | PIP JÓZEFÓW |  |  | PIP AL.WILANOWSKA |  |  | [NAME]
5. | ALMA WROCŁAWSKA |  |  | [NAME] |  |  | AUCHAN GÓRCZEWSKA |  |  | PIP ŁOPUSZAŃSKA |  |  | CARREFOUR REDUTA
6. | CARREFOUR ARKADIA |  |  | ALMA OKOPOWA |  |  | AUCHAN ŁOMIANKI |  |  | CARREFOUR BEMOWO |  |  | ELEA BRONIEWSKIEGO
7. | AUCHAN GÓRCZEWSKA |  |  | [NAME] |  |  |  |  |  | SELGROS POŁCZYŃSKA |  |  | WARSZADIS
8. | ALMA SŁAWOJA |  |  |  |  |  |  |  |  |  |  |  | AUCHAN ŁOMIANKI
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
Lp. | PONIEDZIAŁEK  II | TYP KLIENTA | TYP WIZYTY | WTOREK  II | TYP KLIENTA | TYP WIZYTY | ŚRODA  II | TYP KLIENTA | TYP WIZYTY | CZWARTEK  II | TYP KLIENTA | TYP WIZYTY | PIĄTEK  II | TYP KLIENTA | TYP WIZYTY
1. | MAKRO AL.JEROZOLIMSKIE |  |  | SELGROS POŁCZYŃSKA |  |  | K&M PATRIOTÓW |  |  | PIP PŁOCK MAZOWIA |  |  | AUCHAN GÓRCZEWSKA
2. | [NAME] |  |  | HALA WOLA |  |  | K&M WSPÓLNA |  |  | PIP PŁOCK TYSIĄCLECIA |  |  | PIP BLUE CITY
3. | PIP BLUE CITY |  |  | BAGPOL |  |  | K&M TRAKT BRZESKI |  |  | PIP WYSZOGRODZKA |  |  | BAGPOL
4. | AUCHAN ŁOMIANKI |  |  | PIP BRWINÓW |  |  | PIP JÓZEFÓW |  |  | AUCHAN PŁOCK WYSZOGRODZKA |  |  | [NAME]
5. | ALMA WROCŁAWSKA |  |  | [NAME] |  |  | AUCHAN GÓRCZEWSKA |  |  | PIP STAWKI WARSZAWA |  |  | CARREFOUR REDUTA
6. | CARREFOUR ARKADIA |  |  | ALMA OKOPOWA |  |  | AUCHAN ŁOMIANKI |  |  | PIP AL.WILANOWSKA W-WA |  |  | ELEA BRONIEWSKIEGO
7. | AUCHAN GÓRCZEWSKA |  |  | [NAME] |  |  | M&L JÓZEFÓW |  |  |  |  |  | [NAME]
8. | ALMA SŁAWOJA |  |  |  |  |  |  |  |  |  |  |  | WARSZADIS
9. |  |  |  |  |  |  |  |  |  |  |  |  | AUCHAN ŁOMIANKI
10.
Spreadsheet: 839777d1692215702-automate-spreadsheet-to-work-out-who-owes-who-or-a-macro-that-can-do-it-splitting-bills-
Sheet: Per App

 |  | COST | 1.16 |  | All £ sterling |  |  |  |  |  |  |  |  |  | Bank
Paid by |  | € actual | £ equiv |  | R | SI | D | B | ST | C | N | P | M |  | Who | (Paid)/Withdrawn
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | R | -374
ST |  | 525 |  |  |  |  |  |  |  |  |  |  |  |  | SI | 154.43
R |  | 104.8 |  |  |  |  |  |  |  |  |  |  |  |  | D | 200
C |  | 435 |  |  |  |  |  |  |  |  |  |  |  |  | B | -300
P |  | 600
D |  | 139
M |  | 220
P |  | 711
P |  | 22.74
SI |  | 624
C |  | 49.71
ST |  | 43
B |  | 99
P |  | 31.5
D |  | 46.3
N |  | 640
D |  | 57.8
ST |  | 43
ST |  | 76.3
ST |  | 58.8
D |  | 633.5
SI |  | 70.8
ST |  | 70.2
ST |  | 22.5
C |  | 51.08
Total Owed
Total Paid
Total (Due) / Owed
Equalizing (Payment) / Withdrawal
New balance
Spreadsheet: 812201d1673014564-find-result-between-two-dates-based-on-multiple-criteria-find-result-between-two-dates-based-on-multiple-criteria
Sheet: Feuil1

ID | leave | Return | Type |  | ID | 2023-02-01 00:00:00 | 2023-02-02 00:00:00 | 2023-02-03 00:00:00 | 2023-02-04 00:00:00 | 2023-02-05 00:00:00 | 2023-02-06 00:00:00 | 2023-02-07 00:00:00 | 2023-02-08 00:00:00 | 2023-02-09 00:00:00 | 2023-02-10 00:00:00 | 2023-02-11 00:00:00 | 2023-02-12 00:00:00 | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 2023-02-15 00:00:00 | 2023-02-16 00:00:00 | 2023-02-17 00:00:00 | 2023-02-18 00:00:00 | 2023-02-19 00:00:00 | 2023-02-20 00:00:00 | 2023-02-21 00:00:00 | 2023-02-22 00:00:00 | 2023-02-23 00:00:00 | 2023-02-24 00:00:00 | 2023-02-25 00:00:00 | 2023-02-26 00:00:00 | 2023-02-27 00:00:00 | 2023-02-28 00:00:00 | 2023-03-01 00:00:00 | 2023-03-02 00:00:00
E001 | 2023-02-01 00:00:00 | 2023-02-15 00:00:00 | LO |  | E001
E002 | 2023-02-06 00:00:00 | 2023-02-10 00:00:00 | LO |  | E002
E001 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | MI |  | E003
E002 | 2023-02-18 00:00:00 | 2023-02-28 00:00:00 | MI |  | E004
Spreadsheet: 738848d1625282273-predict-future-re-orders-of-a-product-product-repurchase-model-template
Sheet: JeteMc

Product Repurchase Estimates
 |  | REPURCHASE ASSUMPTIONS
 |  | Product |  | 1st Re Order |  | 2nd Re Order |  | 3rd Re Order |  | 4th Re Order |  | 5th Re Order |  | 6th Re Order
 |  |  |  | % | Time Lag (Months) | % | Time Lag (Months) | % | Time Lag (Months) | % | Time Lag (Months) | % | Time Lag (Months) | % | Time Lag (Months)
 |  | Product 1 | Serum | 0.2 | 2 | 0.35 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2
 |  | Product 2 | Serum | 0.2 | 2 | 0.35 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2
 |  | Product 3 | Serum | 0.2 | 2 | 0.35 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2 | 0.5 | 2
 |  | Product 4
 |  | Product 5
 |  | Product 6
 |  | Product 7
 |  | Product 8
 |  | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24
PRODUCT 1 -  UNIT SALES
- First Orders (Units) |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106
- Repeat Orders | 1st Re Order
 | 2nd Re Order
 | 3rd Re Order
 | 4th Re Order
 | 5th Re Order
 | 6th Re Order
PRODUCT 2 -  UNIT SALES
- First Orders (Units) |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106
- Repeat Orders
PRODUCT 3 -  UNIT SALES
- First Orders (Units) |  | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 101 | 102 | 103 | 104 | 105 | 106
Spreadsheet: 802920d1667147206-aggregate-function-problem-in-expenses-spreadshhet-expenses-
Sheet: Results required

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | those
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emma
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The blue formula will look up the green code in the report to produce a vertical list of only the results that match the green codes in line 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The pink formula would have to look up the code (ie AAA111) and the description (ie in column AU) to het the totals for column AV
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is th [NAME] I cant make work in AU2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There are hundreds of green codes - so the final result will be a very wide spreadsheet
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | There us average of about 5000 lines of expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Each individual expense is then printed below line 25 for each code- that bit I have had not trouble with - I just cant create the summary at the top
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AAA111 |  |  |  |  | AAA222 |  |  |  |  | BBB111 |  |  |  |  | CCC111