tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 41471d1239944759-dynamic-range-help-solution-dynamic-range-help-example
Sheet: Sheet1

Department | Account | Rate | OT % | Hours | Total
Z | Exempt | 0 | 0 | 0 | 0
Z | [NAME] | 0 | 0 | 0 | 0
Z | Resident Care Coord | 0 | 0 | 0 | 0
Z | RNs | 27.6143 | 0.03 | 110 | 3037.573
Z | LPNs | 25.1732 | 0.05 | 470 | 11831.404
Z | CNAs | 12.7411 | 0.05 | 1096 | 13964.2456
Z | [NAME] | 15.3161 | 0.05 | 236.992 | 3629.7931712 |  |  |  | http://www.excelforum.com/excel-general/680019-dynamic-range-help.html
Z | [NAME] | 13.1428 | 0.05 | 112 | 1471.9936
Z | Other Nurses | 0 | 0.03 | 0 | 0
Z | Training | 16.9538 | 0 | 30 | 508.614 |  | Hello,
Z | [NAME] | 0 | 0 | 0 | 1635.99900856
Q | Exempt | 19.38 | 0 | 80 | 1550.4 |  | I have a spreadsheet that has a dynamic list of accounts for departments.
Q | [NAME] | 0 | 0.02 | 0 | 0
Q | Chefs | 0 | 0 | 0 | 0 |  | I have a total column that is for the most part a simple C*E.
Q | Cooks | 12.1176 | 0.05 | 118.72 | 1438.601472
Q | Utility Workers | 0 | 0.03 | 0 | 0 |  | It gets tricky for one account. There is an account (OT) for each department that takes totals for each account in the department and multiples it by an OT %.
Q | Servers | 0 | 0.03 | 0 | 0
Q | Bussers | 10.0674 | 0.06 | 382.13 | 3847.055562 |  | I can do this when the data is static, but the issue is when the data comes back from the source I don't know the order that the departments are coming in as so I have to build a dynamic formula to offset this.
Q | Training | 10.9752 | 0 | 2 | 21.9504
Q | [NAME] | 0 | 0 | 0 | 302.75340732 |  | What are my options on making this happen?
L | Exempt | 17 | 0 | 40 | 680
L | [NAME] | 0 | 0 | 0 | 0
L | HouseKeepers | 10.4854 | 0.05 | 160 | 1677.664
L | Laundry | 10.197 | 0.05 | 112 | 1142.064
L | Training | 10.3824 | 0 | 5 | 51.91200000000001
L | [NAME] | 0 | 0 | 0 | 140.9864
A | Exempt | 0 | 0 | 0 | 0
A | [NAME] | 18.87475 | 0.06 | 120 | 2264.97
A | [NAME] | 0 | 0 | 0 | 135.8982
Spreadsheet: 882183d1730439535-sports-carnival-help-millie0802-swimming-results-v2-spill-2021-aligw
Sheet: Age Champion

Name | HOUSE | BUTTERFLY |  | FREESTYLE |  | BREASTSTROKE |  | BACKSTROKE |  | Total | Place
 |  | Place | Points | Place | Points | Place | Points | Place | Points
Dayton | [NAME] | 1 |  | 2 |  | 3 |  | 5 |  |  |  |  | 1st: | 10
[NAME] | Bribie | 5 |  | 1 |  | 2 |  | 3 |  |  |  |  | 2nd | 6
[NAME] | Strady | 3 |  | 4 |  | 5 |  | 1 |  |  |  |  | 3rd | 3
Greg | [NAME] | 4 |  | 3 |  | 6 |  | 2 |  |  |  |  |  |  |  |  |  | Total
Norm | [NAME] | 2 |  | 5 |  | 1 |  | 6 |  |  |  |  | Age Champion | Points | House |  | [NAME]
[NAME] | Bribie | 6 |  | 6 |  | 4 |  | 4 |  |  |  |  |  | 19 | [NAME] |  | Bribie
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 19 | Bribie |  | Strady
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Up | Points | House
Want to assign points for each event automatically so that if the athlete places first it automatically assigns them 10 points etc |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | [NAME]
Want to tally house points so that all the [NAME] points are tallied [NAME] and all the [NAME] points are tallied S8 etc
Want the 'Age Champion' to populate N8 with the athlete name with the highest total point tally and for Points O8 and House P8 to populate as well
Want the ability, in case there is a tie for age champion or runner up for there to be two athletes named
Want Column L to populate with the placings from 1st to last (however many that may be)
Spreadsheet: kevin_ruscitti__20254__NGPL_RATES
Sheet: NGPL_OFF

INCLUDES GRI TO MARKET AREA | LA | Gas Cost | 5.37 |  |  |  |  | 5
 | STX |  | 5.29
 | TXOK |  | 5.34
 |  |  |  | Delivered |  | Grossed up Volume
Pipeline | Comm $ | Fuel% | Rate | w/OUT | W/GRI | 9000
NGPL |  |  |  |  | 0.0075
Louisiana |  |  |  |  |  |  |  |  | 5.11 | 5.195
Louisiana to Louisiana |  | 0.011 |  |  |  |  |  |  | 5.275 | 5.21
Texok to Louisiana |  | 0.0196
South Texas to Louisiana |  | 0.0226
MARKET
Louisiana to Market |  | 0.0326
Texok to Market |  | 0.038
South Texas to Market |  | 0.0446
Gulf Coast Mainline to Market | 0.0189 | 0.0303
TXOK
Louisiana to TXOK |  | 0.011
TXOK to TXOK |  | 0.016
STX to TXOK |  | 0.0226
Iowa - Illinois to Market | 0.0118 | 0.0181
Amarillo to Market | 0.0173 | 0.0319
Midcontinent to Market | 0.0243 | 0.0452
Permian to Market | 0.0303 | 0.0629
 | Comm
Penzoil contract | 0.0004 |  |  |  |  | 92000 | 5.25
 |  |  |  |  |  | 35000 | 5.266
 | 0.0015
Spreadsheet: 455686d1460467671-remove-data-without-disrupting-previous-calculations-budgeth
Sheet: Work

 | PERSONALE |  |  | 2016-04-11 00:00:00 |  |  |  |  | I alt |  | PERSONALE |  |  |  |  |  |  |  | I alt
 |  |  |  | 7.4 | 7.4 | 7.4 | 7.4 | 7.4 |  |  |  |  |  | 7.4 | 7.4 | 7.4 | 7.4 | 7.4
 |  |  |  | 7.4 | 7.4 | 7.4 | S | 7.4 |  |  |  |  |  | 7.4 | 7.4
 |  |  |  | S | S | S | S | S |  |  |  |  |  | 7.4 | S | 7.4 | 7.4 | 7.4
 | Total: |  |  |  |  |  |  |  |  |  | Total:
 | Budget hours |  |  |  |  |  |  |  |  |  | Budget hours
 | Difference |  |  |  |  |  |  |  |  |  | Difference
Spreadsheet: 63419d1264344818-results-from-multiple-sheets-to-table-example
Sheet: Prices

Company |  |  |  | Quote No. | 1001
Job Name |  |  |  | O/N
 |  |  | [NAME]
0.1
 |  |  | 15
Item | Time(inc.allowance) | Time (hrs) | Labour price | My price | Time(minutes)
Joist & Decking TJI psm |  |  |  |  | 25
Batten ceilings |  |  |  |  | 25
[NAME] |  |  |  |  | 25
Hand cut roof psm |  |  |  |  | 25
 |  |  |  |  | 25
Trusses psm |  |  |  |  | 25
Pediment [NAME] |  |  |  |  | 25
Dormer Hand Cut |  |  |  |  | 25
[NAME]made Fibreglass |  |  |  |  | 25
Attic Trusses psm |  |  |  |  | 25
Velux |  |  |  |  | 25
Valley pr/m |  |  |  |  | 25
Hip pr/m |  |  |  |  | 25
[NAME] |  |  |  |  | 25
 |  |  |  |  | 25
Low level / Porch |  |  |  |  | 25
Garage Roof |  |  |  |  | 25
[NAME] |  |  |  |  | 25
Floating Floor |  |  |  |  | 25
Stairs -Straight Flight |  |  |  |  | 25
Stairs -Kite over Garage wall |  |  |  |  | 25
Stairs-Double kite |  |  |  |  | 25
Stairs-Kite |  |  |  |  | 25
Stairs-double 1/4 landing |  |  |  |  | 25
Block casing |  |  |  |  | 25
 |  |  |  |  | 25
 |  |  |  |  | 25
protect stairs |  |  |  |  | 25
Plasterboard catch noggins(per floor) |  |  |  |  | 25
Soil boxing |  |  |  |  | 25
[NAME] casing |  |  |  |  | 25
Studding pm |  |  |  |  | 25
Studding pm(pre-made erect only) |  |  |  |  | 25
 |  |  |  |  | 25
Temp handrail |  |  |  |  | 25
Window board |  |  |  |  | 25
 |  |  |  |  | 25
Metal Stud |  |  |  |  | 25
Plasterboard psm |  |  |  |  | 25
Arcs(per set) |  |  |  |  | 25
Drilling and cutting latches |  |  |  |  | 25
Fire door |  |  |  |  | 25
 |  |  |  |  | 25
Lightweight Door |  |  |  |  | 25
Front/Back Door & Frame & Lock |  |  |  |  | 25
Skirting |  |  |  |  | 25
Hand rails, spindles per flight |  |  |  |  | 25
Door plant on stops |  |  |  |  | 25
 |  |  |  |  | 25
Pipe Boxings p/m |  |  |  |  | 25
Bath/Shower Panel |  |  |  |  | 25
[NAME] |  |  |  |  | 25
 |  |  |  |  | 25
 |  |  |  |  | 25
Door furniture |  |  |  |  | 25
Intumescent strips |  |  |  |  | 25
Re-hang doors |  |  |  |  | 25
Ply Bathroom Floors psm |  |  |  |  | 25
Gas / electric box |  |  |  |  | 25
PITA Factor |  |  |  |  | 25
Spreadsheet: 160713d1339170917-dynamic-charts-help-setting-up-with-named-ranges-table_chart-example
Sheet: Table

Year | Period | 1000 Series | 2000 Series | 3000 Series | 4000 Series | 5000 Series | 6000 Series | 7000 Series | 9000 Series
2010 | 1 | 7763.5 | 10092.09 | 55873.29 | 7913.15 | 521.16 | 4091.32 | 14251.74 | 3105.29
20102 | 2 | 8469.77 | 5325.63 | 62078.31 | 15395.78 | 1108.98 | 3364.03 | 15246.56 | 10053.25
20103 | 3 | 14815.32 | 22213.71 | 64356.14 | 16422.78 | 746.38 | 4649.13 | 18486.33 | 6280.81
20104 | 4 | 11033.26 | 21963.15 | 63029.48 | 9894.11 | 1367.3 | 9092.19 | 19455.33 | 4243.49
20105 | 5 | 5095.31 | 17151.68 | 80443.55 | 9978.63 | 1764.27 | 3881.53 | 14478 | 16914.07
20106 | 6 | 15453.28 | 9628.29 | 83927.28 | 6662.32 | 350.64 | 8939.77 | 26037.78 | 4463.59
20107 | 7 | 10837.89 | 5899.38 | 53788.17 | 5602.92 | 841.5 | 2668.1 | 19175.95 | 3970.94
20108 | 8 | 13496.6 | 14082.57 | 78987.78 | 17048.49 | 1257.86 | 5458.63 | 26168.59 | 3268
20109 | 9 | 12830.25 | 14850.55 | 78974.75 | 7927.92 | 424.92 | 8772.13 | 29650.31 | 11368.6
201010 | 10 | 10793.5 | 9588.31 | 71375.56 | 5155.61 | 210.35 | 6326.73 | 17966.23 | 4175.57
201011 | 11 | 14062.41 | 13304.52 | 74311.65 | 21520.2 | 1380.11 | 6112.38 | 23866.37 | 16848.46
201012 | 12 | 3788.38 | 3775.56 | 48475.32 | 3586.9 | 191.29 | 1361.8 | 15728.87 | 2684.15
Spreadsheet: 854537d1704376464-shift-work-sick-leave-and-hours-worked-calculator-sample-sheet-5-
Sheet: Sheet1

Hours Calculator V1.0 | Thursday XXth January to Wednesday XXst January
Day | T | F | S | Su | M | T | W | T | F | S | Su | M | T | W |  |  |  | Overtime Shift
Month | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Total Hours |  |  | RDO
[NAME] |  |  |  |  |  |  |  |  |  | OT | Nightshift | Nightshift | Training day 8 Hours | Nightshift |  |  |  | nightshift
 |  |  |  |  |  |  |  |  |  |  |  | Leave | RDO |  |  |  |  | day shift
 |  |  |  |  |  |  |  |  | RDO |  |  | Day Shift |  |  |  |  |  | Leave
 |  |  |  |  |  |  |  |  |  |  | WC |  |  | Training day 8 Hours |  |  |  | Training day 8 Hours
 |  |  |  |  |  |  |  |  |  |  |  |  | Sick |  |  |  |  | Sick
 |  |  |  |  |  |  |  |  |  |  |  |  | RDO |  |  |  |  | WC
STAFF NUMBERS
Overtime Shift
roster day off
nightshift 7-7
day shift
leave with detail /alternative duties
nightshift 11-7
Spreadsheet: 131046d1322703531-formulas-referencing-my-month-year-dropdown-list-copy-of-sales_rev_-_samplev2
Sheet: Targets

 | Target Revenue
 |  | Claudia | Sydney | Julia | Gene | Serene | Eunice | Con7 | Con8 | Total
 | 2011-01-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-02-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-03-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-04-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 20000 | 3000
 | 2011-05-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-06-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-07-01 00:00:00 | 6000 | 6000 | 6000 | 6000 | 25000 | 3000
 | 2011-08-01 00:00:00 | 7000 | 7000 | 7000 | 7000 | 25000 | 3000
 | 2011-09-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-10-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-11-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | 2011-12-01 00:00:00 | 8000 | 8000 | 8000 | 8000 | 25000 | 3000
 | Total FY2011
 | 2011-10-07 00:00:00
Spreadsheet: 836331d1689269133-how-to-sum-comparing-two-lists-and-return-differences-compare-data-hd
Sheet: Sheet1

 | Data 1 |  |  |  |  |  |  | Data 2
 | Package | Product Code | Unit | Compare Total Units | Supposed to be |  |  | Package | Product Code | Unit
 | 4 | CK0201 | 1 |  | Not Match |  |  | 1 | Pen01 | 1
 | 4 | AP001 | 1 |  | Not Match |  |  | 1 | AP001 | 1
 | 4 | JK0021 | 1 |  | Not Match |  |  | 2 | MK002 | 2
 | 4 | JK0021 | 1 |  | Not Match |  |  | 2 | MK002 | 1
 | 2 | MK002 | 1 |  | Match |  |  | 2 | AP001 | 1
 | 2 | MK002 | 1 |  | Match |  |  | 3 | MK002 | 1
 | 2 | MK002 | 1 |  | Match |  |  | 3 | [NAME] | 2
 | 2 | AP001 | 1 |  | Match |  |  | 3 | AKW001 | 2
 | 5 | AP001 | 1 |  | Not Match |  |  | 3 | BW0021 | 2
 | 5 | PD0012 | 1 |  | Not Match |  |  | 4 | QB0012 | 1
 | 5 | Pen01 | 1 |  | Not Match |  |  | 4 | CK0201 | 1
 | 5 | [NAME] | 1 |  | Not Match |  |  | 4 | AP001 | 1
 | 5 | AKW001 | 1 |  | Not Match |  |  | 4 | JK0021 | 1
 | 5 | MK002 | 1 |  | Not Match |  |  | 4 | JK0021 | 1
 | 5 | MK002 | 1 |  | Not Match |  |  | 5 | AP001 | 1
 | 1 | Pen01 | 1 |  | Match |  |  | 5 | PD0012 | 1
 | 1 | AP001 | 1 |  | Match |  |  | 5 | Pen01 | 1
 | 3 | BW0021 | 1 |  | Match |  |  | 5 | [NAME] | 1
 | 3 | BW0021 | 1 |  | Match |  |  | 5 | [NAME] | 1
 | 3 | MK002 | 1 |  | Match |  |  | 5 | AKW001 | 1
 | 3 | [NAME] | 1 |  | Match |  |  | 5 | MK002 | 1
 | 3 | [NAME] | 1 |  | Match |  |  | 5 | MK002 | 1
 | 3 | AKW001 | 1 |  | Match |  |  | 5 | AP001 | 1
 | 3 | AKW001 | 1 |  | Match
Spreadsheet: 758729d1639043246-excel-dashboard-help-sum-data-from-multiple-tabs-service-support-management-db_v2
Sheet: Team_Dashboard

 | 1. Filter by manager
 |  |  |  |  |  |  | Number of Client Projects by month |  |  |  | Holidays this month
 |  |  | Total Client Projects |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Projects completed |  | COUNT TOTAL CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Projects 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Client Calls |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Client Calls completed |  | COUNT TOTAL CLIENT CALLS (column b) AND CLIENT IS NOT N/A (column c) & status (column G)
 |  |  | Total Client Calls 'not completed' |  | COUNT TOTAL CLIENT CALLS & CLIENT PROJECT (column b) AND CLIENT IS NOT N/A (column c)
 |  |  | Total Training Days |  | COUNT TOTAL holiday (column b)
 |  |  | Total Holidays |  | COUNT TOTAL training (column b)
 | 2. Filter by month
 | 3. Filter by Client
 |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Team Information
 |  |  | Client Name | =Client
 |  |  | Total number of Client Calls |  | Total number of Client Proects
 |  |  | Average number of Client Calls |  | Total number of Client Projects
 |  |  | Not started |  | Average number of Client Projects
 |  |  | On hold |  | Not started
 |  |  | In progress |  | On hold
 |  |  | Completed |  | In progress
 |  |  | Time spent on Client Calls |  | Completed
 |  |  |  |  | Time spent on Client Projects
Spreadsheet: 836145d1689127074-simple-pdf-wont-convert-in-excel-pseg-payments-from-charmaine-_-elton-parker-2022-w2
Sheet: Sheet1

Payment History
 |  | 29 Payment Records
Date | Amount | Balance | Activity
12/21/2022 | $-218.00 | $182.27 | PAYMENT
[NAME] | $179.00 | $400.27 | Budget [NAME]
[NAME] | $3.27 | $221.27 | Adjustment
11/18/2022 | $-202.08 | $218.00 | PAYMENT
11/03/2022 | $218.00 | $420.08 | Budget [NAME]
11/03/2022 | $-15.92 | $202.08 | Adjustment
10/18/2022 | $-218.00 | $218.00 | PAYMENT
10/06/2022 | $-218.00 | $436.00 | PAYMENT
10/05/2022 | $218.00 | $654.00 | Budget [NAME]
09/06/2022 | $218.00 | $436.00 | Budget [NAME]
08/23/2022 | $-218.00 | $218.00 | PAYMENT
08/03/2022 | $218.00 | $436.00 | Budget [NAME]
07/12/2022 | $-217.61 | $218.00 | PAYMENT
07/06/2022 | $218.00 | $435.61 | Budget [NAME]
06/21/2022 | $[NAME] | $217.61 | PAYMENT
06/03/2022 | $218.00 | $390.61 | Budget [NAME]
05/24/2022 | $-174.32 | $172.61 | PAYMENT
05/04/2022 | $170.00 | $346.93 | Budget [NAME]
05/04/2022 | $2.61 | $176.93 | Adjustment
04/19/2022 | $-346.00 | $174.32 | PAYMENT
04/05/2022 | $170.00 | $520.32 | Budget [NAME]
04/05/2022 | $5.18 | $350.32 | Adjustment
03/03/2022 | $170.00 | $345.14 | Budget [NAME]
03/03/2022 | $2.59 | $175.14 | Adjustment
02/08/2022 | $-170.00 | $172.55 | PAYMENT
02/03/2022 | $170.00 | $342.55 | Budget [NAME]
02/03/2022 | $2.55 | $172.55 | Adjustment
01/10/2022 | $-170.00 | $170.00 | PAYMENT
01/05/2022 | $170.00 | $340.00 | Budget [NAME]
Spreadsheet: 833325d1686907440-filter-with-dynamic-number-of-conditions-nested-list-formula-example-2-ans
Sheet: Sheet1

Problem: Use a formula to find the count of unique Countries selected by dynamically parsing the required keys from a single text field.
Manual example:  1. Parse the keys from each yellow cell (this list of keys can be arbitrarily long) 2. Get only blue rows with one of the desired keys 3. Select all Countries for these rows 4. [NAME], then count the countries
Key | Country |  | Sample Combined Key Conditions |  |  | Expected
CAT | Aruba |  | CAT,BAM |  |  | 5
CAT | Scuba |  | BAM |  |  | 4
CAT | Pine
CAT | Palm
CAT | Cove
SAM | Aruba
SAM | Palm
SAM | Cove
BAM | Scuba
BAM | Pine
BAM | Palm
BAM | Cove
Spreadsheet: 818930d1677131820-sorting-unique-array-by-year-and-month-sort_unique
Sheet: Data

 | Created
 | 2022-01-31 16:44:16
 | 2022-01-31 17:04:23
 | 2022-02-24 17:35:51
 | 2022-03-11 13:36:05
 | 2022-04-05 10:26:59
 | 2022-07-12 06:57:05
 | 2022-08-23 10:03:47
 | 2022-09-02 16:28:16
 | 2022-09-02 17:14:05
 | 2022-09-08 10:00:03
 | 2022-10-04 09:37:55
 | 2022-10-06 10:22:24
 | 2022-10-07 07:56:52
 | 2022-10-14 13:20:29
 | 2022-10-26 11:27:23
 | 2022-10-28 17:49:03
 | 2022-11-07 09:15:02
 | 2022-11-10 10:10:06
 | 2022-11-11 13:34:46
 | 2022-11-24 15:16:08
 | 2023-01-31 15:32:08
 | 2023-02-17 08:30:08
 | 2023-02-21 12:10:33
 | 2022-05-20 14:33:46
 | 2022-06-24 09:29:10
 | 2022-07-22 11:13:51
 | 2022-07-29 10:42:34
 | 2022-08-05 10:36:45
 | 2022-08-11 09:34:26
 | 2022-08-12 11:57:27
 | 2022-09-02 13:41:24
 | 2022-09-12 08:56:41
 | 2022-09-19 10:44:52
 | 2022-09-30 14:32:01
 | 2022-10-04 17:29:28
 | 2022-10-06 08:03:51
 | 2022-11-08 16:31:04
 | 2022-11-10 11:20:10
 | 2022-12-01 10:18:19
 | 2023-01-18 13:57:54
 | 2023-01-18 13:59:32
 | 2023-01-23 13:58:14
 | 2023-01-24 10:21:43
 | 2023-02-01 14:39:37
Spreadsheet: 456243d1460715611-finding-perfect-matches-finding-perfect-matches
Sheet: Before

Your name | 1.you want to meet | 2. you want to meet | 3. you want to meet
Ana | [NAME] | [NAME] | [NAME]
[NAME] | Camilla | [NAME] | [NAME]
[NAME] | [NAME] | [NAME]
Camilla | [NAME] | Monika | [NAME]
[NAME] | Monika | Camilla | [NAME]
[NAME] | Camilla | [NAME] | Ana
Monika | Camilla | [NAME] | [NAME]
[NAME] | Monika | Camilla | [NAME]
[NAME] | [NAME] | [NAME] | Camilla
Spreadsheet: 852042d1702124447-formula-for-plus-and-minus-specific-values-amt-st-09-12-23
Sheet: 17933690

SRI AMBIKA SOLVEX LIMITED AKOLA
ACCOUNT STATEMENT
From 01-APR-23 To 09-DEC-23
MANDI AMRAVATI
Opening : |  |  |  |  |  |  |  |  |  | 9942972.00 CR
 |  | Date | Document No | Mode | Particular | Cheq.No. | Debit |  |  | Credit | Balance |  | 9942972
 |  | 2023-04-05 00:00:00 | 165 | BP | [NAME] To Party Against Purchase Of Soya Seed M/S Nandkishor Nathuji Kakde | RTGS | 224865 | 224865 | 165 | 0 | 9718107 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being [NAME] No.576370 Issue To Party Against Purchase Of Soya Seed M/S Nilesh Mukandrao Deshmukh | 576370 | 29177 | 128966 | 31 | 0 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being Chaque No.576363 Issue To Party Against Purchase Of Soya Seed M/S Jai Salasar Traders | 576363 | 64978 |  | 31 | 566 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 31 | BP | Being Chaque No.576367 Issue To Party Against Purchase Of Soya Seed M/S Khanteshwari Traders | 576367 | 34811 |  | 31 | 452 | 9589141 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576419 Issue To Party Against Purchase Of Soya Seed M/S Jai Shivalay Traders | 576419 | 328877 | 906236 | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576376 Issue To Party Against Purchase Of Soya Seed M/S Rahul Traders | 576376 | 125858 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being [NAME] To Party Against Purchase Of Soya Seed M/S Khanteshwari Traders | 576373 | 94631 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576418 Issue To Party Against Purchase Of Soya Seed M/S Manthan Traders | 576418 | 60798 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-06 00:00:00 | 32 | BP | Being Chaque No.576374 Issue To Party Against Purchase Of Soya Seed M/S Jayshri Traders | 576374 | 296072 |  | 32 | 0 | 8682905 | CR
 |  | 2023-04-07 00:00:00 | 166 | BP | Being Cheque No. 576364 Issue To Party Aginst Purchase Of Soya Seed M/S Rajesh Mahadeoprasad Agarwal | 576364 | 114852 | 114852 | 166 | 0 | 8568053 | CR
 |  | 2023-04-10 00:00:00 | 44 | BP | [NAME] To Party Aginst Purchase Of Soya Seed M/S Tushar Suresh Karale | RTGS | 433590 | 815133 | 44 | 0 | 7752920 | CR
Spreadsheet: 785100d1656148540-status-based-on-multiple-date-entries-test-book-statement-based-on-date-entry-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | This data to be based on date in A1
Status | Ref Number | Date received | Start Date | Completion Date |  |  |  |  | Cell Ref | data entered into cell | Status requirements in Cell A5
 |  |  |  |  |  |  |  |  | B5 | empty | empty
 |  |  |  |  |  |  |  |  | B5 | anything | Insert more data
 |  |  |  |  |  |  |  |  | C5 | date entry | Outstanding
 |  |  |  |  |  |  |  |  | D5 | date entry | In Progress
 |  |  |  |  |  |  |  |  | E5 | date entry | Completed
Spreadsheet: darrell_schoolcraft__7808__imbalsumm0108
Sheet: NW

 | LaPlata Recpt |  | LaPlata Delivery
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monthly |  | Monthly
Day | Measured | Scheduled | Measured | Scheduled |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56419 | 500516 | 500535 | 500539 | [NAME] | Index | Dollars
1 | 199740 | 206461 |  | -6136 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-02-01 00:00:00 |  |  |  |  |  | 1.57
2 | 124221 | 140424 |  | -16997 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-03-01 00:00:00 |  |  |  |  |  | 1.84
3 | 208560 | 226875 |  | -13759 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-04-01 00:00:00 |  |  |  |  |  | 1.91
4 | 174497 | 201790 |  | -27623 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-05-01 00:00:00 |  |  |  |  |  | 2.21
5 | 170484 | 195304 |  | -25217 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-06-01 00:00:00 |  |  |  |  |  | 1.67
6 | 171739 | 196507 |  | -26132 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-07-01 00:00:00 |  |  |  |  |  | 1.8
7 | 181261 | 192920 |  | -9874 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-08-01 00:00:00 |  |  |  |  |  | 1.88
8 | 197070 | 204844 |  | -4417 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-09-01 00:00:00 |  |  |  |  |  | 2.02
9 | 193826 | 201331 |  | -8466 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-10-01 00:00:00 |  |  |  |  |  | 1.81
10 | 183951 | 200529 |  | -19807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-11-01 00:00:00 |  |  |  |  |  | 1.79
11 | 205187 | 209202 |  | -5480 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1993-12-01 00:00:00 |  |  |  |  |  | 2.28
12 | 196282 | 206942 |  | -11937 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-01-01 00:00:00 |  |  |  |  |  | 1.94
13 | 208969 | 209066 |  | -807 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-02-01 00:00:00 |  |  |  |  |  | 2.2
14 | 200915 | 207816 |  | -8506
15 | 185028 | 192042 |  | -7418 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-04-01 00:00:00 |  |  |  |  |  | 1.74
16 | 205829 | 210433 |  | -5000 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-05-01 00:00:00 |  |  |  |  |  | 1.58
17 | 203994 | 209294 |  | -5929 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1994-06-01 00:00:00 |  |  |  |  |  | 1.6
18 | 230790 | 250585 |  | -6265
19 | 180146 | 245466 |  | -6387
20 | 216439 | 221942 |  | -6231
21 | 183412 | 215195 |  | -28318
22 | 167828 | 203102 |  | -36302
23
24
25
26
27
28
29
30
31
 | 2001-07-31 00:00:00 |  |  |  | 5110
 | 2001-08-22 00:00:00
 | CBS Dollars
 |  |  |  | -487771.44