tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 744d264d-26f3-4bab-9a80-eed99ccca29c
Sheet: Lost Vehicle Permit

LOST/STOLEN/DAMAGED APPLICATION FORM FOR AIRSIDE ACCESS VEHICLE PERMIT
Missing Permit Number
Reason Permit Missing    {please [NAME] as appropriate} |  |  |  | Lost |  | Stolen |  | Damaged
Date/Time you realised Airside Access Vehicle Permit Missing
Single Application |  |  |  | Fleet Application
Name and Address of registered owner of the vehicle |  |  |  | Telephone No:
Name and Address of Employer / Company |  |  |  | Tel No:
 |  |  |  | Mobile No:
 |  |  |  | e-mail address
 |  |  |  | 24 Hour Contact Telephone No:
DETAILS OF VEHICLE
Fleet Number |  |  |  | Registration Number
Vehicle Type |  |  |  | Call Sign
Make |  |  |  | Licence Type Required
Model |  |  |  | Year Of Aquisition
Colour |  |  |  | Fuel Type
Height |  |  |  | Weight
* Applications for Fleet Vehicles may be attached to this application |  |  |  |  |  |  | YES | NO | N/A
Permit Access |  |  |  | Ramp
 |  |  |  | Aeroclub
 |  |  |  | Ramp + Aeroclub
Detailed Reasons for requiring an Airside Access Vehicle Permit. |  |  |  | New Vehicle
(Applications for privately owned vehicles will not be authorised) |  |  |  | Insurance
 |  |  |  | Amber [NAME]
 |  |  |  | Security Keypad
 |  |  |  | Company Livery
 |  |  |  | Permanently Painted
 |  |  |  | [NAME]
 |  |  |  | NCT Certificate
Will you have a requirement to service aircraft within the manoeuvring area?
The Airside Vehicle Access Permit remains the property of Cork Airport and may be withdrawn on request.                                             The permit must be returned to the AMU Support Officer, AMU, Old Terminal, Cork Airport, Kinsale Road, Cork on completion of the contract or expiry of the permit.
 |  |  |  |  |  | OFFICE USE ONLY
Print Name: |  |  |  |  |  | LOST PERMIT NO:
Signature |  |  |  |  |  | NEW PERMIT NO:
Date: |  |  |  |  |  | DATE ISSUED:
Approved by:                                                                       (Authorised Signatory)
 | (Print Name - Line Manager) |  |  |  |  | DATE EXPIRED:
 | (Signature - Line Manager)
Date: |  |  |  |  |  | SIGNED:
Spreadsheet: 807677d1669995087-categorized-modes-of-payment-excel-help
Sheet: Speedpoint

ACRYLON PAINTS (PTY) LTD
CASH SALES - (Speedpoint)
Details
Date | Document Number | Customer Name | Cash Sale Amount | MoP
 | `
Spreadsheet: 21604d1209335899-converting-time-masters-fina-points
Sheet: 50 Free (2)

Base Time = | 3.36.58 | #N/A
AGE | Finnish age conversion factor | Actual swim time | Adjusted swim time | Masters FINA points
20 | 1.012451717102031 |  | 0 | #N/A
21 | 1.010194174094257 |  | 0 | #N/A
22 | 1.007821074065011 |  | 0 | #N/A
23 | 1.005331598692477 |  | 0 | #N/A
24 | 1.002724881198245 |  | 0 | #N/A
25 | 1.000000004731472 |  | 0 | #N/A
26 | 0.9971560006319464 |  | 0 | #N/A
27 | 0.9941918465638804 |  | 0 | #N/A
28 | 0.9911064645114284 |  | 0 | #N/A
29 | 0.9878987186260714 |  | 0 | #N/A
30 | 0.9845674129150168 |  | 0 | #N/A
31 | 0.9811112887586964 |  | 0 | #N/A
32 | 0.9775290222442381 |  | 0 | #N/A
33 | 0.9738192213004667 |  | 0 | #N/A
34 | 0.9699804226185001 |  | 0 | #N/A
35 | 0.9660110883403596 |  | 0 | #N/A
36 | 0.9619096024961666 |  | 0 | #N/A
37 | 0.9576742671684281 |  | 0 | #N/A
38 | 0.9533032983595953 |  | 0 | #N/A
39 | 0.9487948215364724 |  | 0 | #N/A
40 | 0.9441468668221141 |  | 0 | #N/A |  |  |  | 12 | 13.36
41 | 0.9393573638025353 |  | 0 | #N/A
42 | 0.9344241359118071 |  | 0 | #N/A
43 | 0.929344894354863 |  | 0 | #N/A
44 | 0.9241172315225059 |  | 0 | #N/A
45 | 0.9187386138476142 |  | 0 | #N/A
46 | 0.9132063740452624 |  | 0 | #N/A
47 | 0.9075177026722955 |  | 0 | #N/A
48 | 0.9016696389336569 |  | 0 | #N/A
49 | 0.8956590606532975 |  | 0 | #N/A
50 | 0.8894826733165677 |  | 0 | #N/A
51 | 0.8831369980783698 |  | 0 | #N/A
52 | 0.8766183586166821 |  | 0 | #N/A
53 | 0.8699228666940436 |  | 0 | #N/A
54 | 0.8630464062696773 | 4.14.15 | #N/A | #N/A
55 | 0.8559846159816614 |  | 0 | #N/A
56 | 0.8487328697911877 |  | 0 | #N/A
57 | 0.8412862555486943 |  | 0 | #N/A
58 | 0.833639551203484 |  | 0 | #N/A
59 | 0.8257871983330783 |  | 0 | #N/A
60 | 0.8177232726144515 |  | 0 | #N/A
61 | 0.8094414507944523 |  | 0 | #N/A
62 | 0.8009349736386918 |  | 0 | #N/A
63 | 0.7921966042438212 |  | 0 | #N/A
64 | 0.783218580983442 |  | 0 | #N/A
65 | 0.7739925642177944 |  | 0 | #N/A
66 | 0.7645095757252502 |  | 0 | #N/A
67 | 0.7547599296009379 |  | 0 | #N/A
68 | 0.7447331531033574 |  | 0 | #N/A
69 | 0.7344178955988001 |  | 0 | #N/A
70 | 0.723801823336137 |  | 0 | #N/A
71 | 0.7128714972546653 |  | 0 | #N/A
72 | 0.7016122303494611 |  | 0 | #N/A
73 | 0.6900079202431141 |  | 0 | #N/A
74 | 0.6780408514720593 |  | 0 | #N/A
75 | 0.6656914604951216 |  | 0 | #N/A
76 | 0.652938054436825 |  | 0 | #N/A
77 | 0.6397564718952123 |  | 0 | #N/A
78 | 0.6261196704914472 |  | 0 | #N/A
79 | 0.6119972207986507 |  | 0 | #N/A
80 | 0.5973546792305822 |  | 0 | #N/A
81 | 0.5821528024294963 |  | 0 | #N/A
82 | 0.5663465511493877 |  | 0 | #N/A
83 | 0.5498838101504181 |  | 0 | #N/A
84 | 0.5327037181930697 |  | 0 | #N/A
85 | 0.5147344520549864 |  | 0 | #N/A
86 | 0.4958902287123814 |  | 0 | #N/A
87 | 0.4760671588935054 |  | 0 | #N/A
88 | 0.455137362414794 |  | 0 | #N/A
89 | 0.4329403603261103 |  | 0 | #N/A
90 | 0.4092700215959559 |  | 0 | #N/A
91 | 0.3838538831371275 |  | 0 | #N/A
92 | 0.3563185578470395 |  | 0 | #N/A
93 | 0.326127710839453 |  | 0 | #N/A
94 | 0.2924601014378114 |  | 0 | #N/A
95 | 0.2539365986483502 |  | 0 | #N/A
96 | 0.2078748166027259 |  | 0 | #N/A
97 | 0.1473680449303234 |  | 0 | #N/A
Spreadsheet: 867896d1714658595-equivalent-of-sumif-but-for-a-count-excel-count-scenario-to-find-formula
Sheet: Sheet1

COUNTIF scenario
Name | Designation | Mth 1 | Mth 2 | Mth 3 | Mth 4 | Mth 5 | Mth 6
Name 1 | Manager | 3000 | 3000 | 3000 | 3000 | 3000 | 3000
Name 2 | Director |  | 5000 | 5000 | 5000 | 5000 | 5000
Name 3 | Manager | 2500 | 2500 | 2500 | 2500 | 2500 | 2500
Name 4 | Sales Consultant | 1750 | 1750 | 1750 | 1750 |  | 1750
Name 5 | [NAME] | 1000 | 1000 | 1000 | 1000 | 1000 | 1000
Name 6 | [NAME] |  | 900 | 900 | 900 |  | 900
Name 7 | [NAME] | 950 | 950 |  | 950 | 950 | 950
SUMIF (to get value by designation)
 | Manager |  |  |  |  |  |  |  | This is what SUMIF does obviously, no problem
 | Director
 | Sales Consultant
 | [NAME]
I WANT TO LOOK AT A COUNT to tell me in each month how many of each designation, so I get this:
 | Manager | 2 | 2 | 2 | 2 | 2 | 2 |  | Manually typed in expected rust, where I am looking for a forumula similar to SUMIF but to COUNT instead
 | Director | 0 | 1 | 1 | 1 | 1 | 1
 | Sales Consultant | 1 | 1 | 1 | 1 | 0 | 1
 | [NAME] | 2 | 3 | 2 | 3 | 2 | 3
The same thing as SUMIF but to count the number of cells with a value rather than SUM them
Spreadsheet: chris_germany__1884__tp2_ticketsJun2001
Sheet: NFUL_daily

 |  |  |  | June
1
 |  | [NAME]
 |  | NFGS | FT | FT
 |  | comm | 0.0013 | 0.0013
 |  | s/c
 |  | 0.02
 |  |  | FTLR | FTAR
 |  | comm | 0.0076 | 0.0078
 |  | s/c
 |  | 0.0081
 |  | NY | 0.425 | 0.425
 |  | Spread
 |  | Variable
 |  | Demand
 |  | Profit/Loss
 |  | Volume | 2100 | 3900
 |  | Days | 30
 |  | Tot Profit/(Loss)
Spreadsheet: 777761d1650594259-auto-populating-cells-on-multiple-tabs-based-on-the-date-entered-in-a-log-2022-trading-journal
Sheet: November

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  |  |  | 2022-11-01 00:00:00 |  | 2022-11-02 00:00:00 |  | 2022-11-03 00:00:00 |  | 2022-11-04 00:00:00 |  | 2022-11-05 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-11-06 00:00:00 |  | 2022-11-07 00:00:00 |  | 2022-11-08 00:00:00 |  | 2022-11-09 00:00:00 |  | 2022-11-10 00:00:00 |  | 2022-11-11 00:00:00 |  | 2022-11-12 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-11-13 00:00:00 |  | 2022-11-14 00:00:00 |  | 2022-11-15 00:00:00 |  | 2022-11-16 00:00:00 |  | 2022-11-17 00:00:00 |  | 2022-11-18 00:00:00 |  | 2022-11-19 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-11-20 00:00:00 |  | 2022-11-21 00:00:00 |  | 2022-11-22 00:00:00 |  | 2022-11-23 00:00:00 |  | 2022-11-24 00:00:00 |  | 2022-11-25 00:00:00 |  | 2022-11-26 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-11-27 00:00:00 |  | 2022-11-28 00:00:00 |  | 2022-11-29 00:00:00 |  | 2022-11-30 00:00:00
Spreadsheet: 0675e5fe-ba8c-45de-95f4-487e365b6a28
Sheet: NSAMix

No Sugar Added Mix Production Sheet
NSA Mix Produced (gal) |  | 0
Finished Ice Cream (gal)
Ice Cream Remaining (gal)
[NAME] (gal)
Flavor, Volume | Volume | No. of [NAME] | Ice Cream (Gal) | Mix Required (Gal)
Vanilla | 3 gallon
 | 1/2 gallon
Chocolate | 3 gallon
 | 1/2 gallon
[NAME] | 3 gallon
 | 1/2 gallon
Total:
Notes:
Spreadsheet: 235940d1368642816-manual-entry-of-some-data-for-loan-history-loan-calc
Sheet: Sheet1

 |  |  |  |  | Origination Date |  |  |  | Manual
 |  |  |  |  | Payoff Date |  |  |  | Auto Calc
 |  |  |  |  | Int Rate | 0.1 | Annual Rate
 |  |  |  | Change F5 to Leap Rear via dropdown menu --> | Regular |  | Daily Rate
 | Pmt Period | Days in Per | Date | BB | Payment | Int | Prin | Fees | EB
 |  |  | 2013-05-15 00:00:00 | 50000 | 0 | 0 | 0 | 0
 |  |  | 2013-06-15 00:00:00 |  | 3250 |  |  | 0
 |  |  | 2013-07-15 00:00:00 |  | 6000 |  |  | 0
 |  |  | 2013-08-15 00:00:00 |  | 4267 |  |  | 0
 |  |  | 2013-09-15 00:00:00 |  | 14958 |  |  | 0
 |  |  | 2013-10-15 00:00:00 |  | 4265 |  |  | 0
 |  |  | 2013-11-15 00:00:00 |  | 5441 |  |  | 0
 |  |  | 2013-12-15 00:00:00 |  | 531 |  |  | 50
 |  |  | 2014-01-15 00:00:00 |  | 11338 |  |  | 0
Spreadsheet: 218958d1362619001-formula-check-counting-the-number-of-0s-in-a-array-test3
Sheet: Sheet1

1 | Active
1 | Active
1 | Active
1 | Active
1 | Active
1 | Active
3 | Active
1 | Active
4 | Active
1 | Active
0 | current
0 | current
0 | current |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug |  |  | Aug YTD
0 | current |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  | 9 month without activity
 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 851253d1701464136-remove-blank-rows-in-a-column-of-over-1200-rows-blank-rows
Sheet: Sheet1

[NAME] à oeil d'or [NAME] clangula COGO 1
Barrow's [NAME] d'Islande Bucephala islandica BAGO 1
[NAME] piette Mergellus albellus SMEW 3
Hooded [NAME] couronné Lophodytes cucullatus HOME 1
[NAME] Grand [NAME] merganser COME 1
Red-breasted [NAME] huppé Mergus serrator RBME 1
Masked Duck Érismature routoutou Nomonyx dominicus MADU 3
Ruddy Duck Érismature rousse [NAME] jamaicensis RUDU 1
Curassows and Guans (Cracidae)
Plain [NAME] chacamel Ortalis vetula PLCH 2
New World Quail (Odontophoridae)
Mountain [NAME] des montagnes Oreortyx pictus MOUQ 1
Northern Bobwhite [NAME] virginianus NOBO 1
Scaled Quail [NAME] écaillé Callipepla squamata SCQU 1
California Quail [NAME] californica CAQU 1
[NAME]'s Quail [NAME] gambelii GAQU 1
[NAME] [NAME] montezumae MONQ 2
Partridges, Grouse, [NAME], and Old World Quail (Phasianidae)
Wild Turkey Dindon sauvage [NAME] gallopavo WITU 1
[NAME] huppée Bonasa umbellus RUGR 1
Spruce Grouse Tétras du Canada Canachites canadensis SPGR 2
[NAME] des saules Lagopus lagopus WIPT 2
Rock Ptarmigan Lagopède alpin Lagopus muta ROPT 2
Spreadsheet: 868234d1714981536-tier-incentive-will-be-automatically-calculated-based-on-tier-doctors-calculation-april-2024-allan-sampling-of-doing-formula-copy-1-aligw
Sheet: Dr. Osama Ahmad

Contract Terms (*)
 |  | 1- Revenue Target on Dental Procedure | Incentive
 |  | Tier 1 - 25,000 to 35,000 | 0.12
 |  | [NAME] to 45,000 | 0.15
 |  | [NAME] to 55,000 | 0.17
 |  | [NAME] 66,000 | 0.19
 |  | Tier 5 - 66,001 to 77,000 | 0.2
 |  | Tier 6 - 77,001 to 88,000 | 0.22
 |  | Tier 7 - 88,001 Above | 0.24
Doctor Calculation
 |  | Doctor Revenue Dental Procedure | 109411.1799999999
 |  | Clinic Fees 5%
 |  | Dental Lab | 1600
 |  | Net Revenue
 |  | Amount to be Paid
 |  | Total Amount to be Paid
Prepared By …................. |  |  |  | CFO: | .......................
Spreadsheet: 685635d1594120337-if-product-status-are-all-x-status-belongs-to-same-order-add-color-or-warning-product-status
Sheet: Sheet4

Order ID | Product ID | Product Status
1 | 1001 | Sending
1 | 1002 | Sending
1 | 1003 | Sending
2 | 1002 | Open
2 | 1004 | Sending
2 | 1006 | Sending
2 | 1007 | Open
2 | 1008 | Open
3 | 1002 | Sending
3 | 1001 | Sending
4 | 1003 | Sending
4 | 1004 | Short Delivery
4 | 1005 | Open
If [NAME] are all 'Sending' belongs to same Order ID, should look like this,
Order ID | Product ID | Product Status
1 | 1001 | Sending | This Order is Ready
1 | 1002 | Sending | This Order is Ready
1 | 1003 | Sending | This Order is Ready
2 | 1002 | Open | This Order is NOT Ready
2 | 1004 | Sending | This Order is NOT Ready
2 | 1006 | Sending | This Order is NOT Ready
2 | 1007 | Open | This Order is NOT Ready
2 | 1008 | Open | This Order is NOT Ready
3 | 1002 | Sending | This Order is Ready
3 | 1001 | Sending | This Order is Ready
4 | 1003 | Sending | This Order is NOT Ready
4 | 1004 | Short Delivery | This Order is NOT Ready
4 | 1005 | Open | This Order is NOT Ready
Spreadsheet: 123307d1317546536-using-the-sumif-formula-activity-report-new
Sheet: Varun

Sr. No. | Customer Name | Contact person | Designation | [NAME] | Met Customer (YES/NO) | Meeting Date | Current IT  Structure | Solutions discussed | Quotation Sent (YES/NO) | Quotation sent date | Closed Yes/No | Closure expected by  (Date) | Amount | Remarks
1
2 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-05 00:00:00 | 46
3 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-15 00:00:00 | 41434
4 |  |  |  |  |  |  |  |  |  |  |  | 2011-10-12 00:00:00 | 456
5 |  |  |  |  |  |  |  |  |  |  |  | 2011-12-10 00:00:00 | 85465
6
7
8
9
10
11
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  | CLOSURE WITHIN 30 DAYS
Spreadsheet: 829841d1684482794-conditional-formatting-how-to-compare-to-bank-statements-for-inter-company-transactions-demo-etaf
Sheet: Co A

No | Date | Account | Details | Debit | Credit
429 | 2020-10-30 00:00:00 | 1205 | Bank Transfer |  | 600
431 | 2020-11-06 00:00:00 | 1205 | Bank Transfer |  | 700
433 | 2020-11-19 00:00:00 | 1205 | Bank Transfer |  | 12 | 12
435 | 2020-11-27 00:00:00 | 1205 | Bank Transfer |  | 1500
437 | 2020-11-27 00:00:00 | 1205 | Bank Transfer |  | 700
439 | 2020-11-27 00:00:00 | 1205 | Bank Transfer |  | 1600
441 | 2020-11-27 00:00:00 | 1205 | Bank Transfer |  | 1300
443 | 2020-11-27 00:00:00 | 1205 | Bank Transfer |  | 5850
445 | 2020-12-04 00:00:00 | 1205 | Bank Transfer |  | 16700
447 | 2020-12-11 00:00:00 | 1205 | Bank Transfer |  | 1300
449 | 2020-12-11 00:00:00 | 1205 | Bank Transfer |  | 22000
476 | 2020-12-14 00:00:00 | 1205 | Bank Transfer | 20000
451 | 2020-12-18 00:00:00 | 1205 | Bank Transfer |  | 23266
478 | 2020-12-18 00:00:00 | 1205 | Bank Transfer | 1035.42
453 | 2020-12-22 00:00:00 | 1205 | Bank Transfer |  | 5000
Spreadsheet: 749257d1632650593-counting-details-from-multiple-sheets-file_ans
Sheet: Vehicle One

Log
SR.# | DATE | SALES EXECUTIVE
1 | 2021-09-01 00:00:00 | Savanna
2 | 2021-09-02 00:00:00 | Krystin
3 | 2021-09-02 00:00:00 | [NAME]
4 | 2021-09-04 00:00:00 | Isobel
5 | 2021-09-04 00:00:00 | [NAME]
6 | 2021-09-04 00:00:00 | Savanna
7 | 2021-09-04 00:00:00 | Krystin
8 | 2021-09-04 00:00:00 | [NAME]
9 | 2021-09-05 00:00:00 | Isobel
10 | 2021-09-05 00:00:00 | [NAME]
11 | 2021-09-06 00:00:00 | Savanna
12 | 2021-09-06 00:00:00 | Krystin
13 | 2021-09-06 00:00:00 | [NAME]
14 | 2021-09-07 00:00:00 | Isobel
15 | 2021-09-07 00:00:00 | [NAME]
16 | 2021-09-07 00:00:00 | Savanna
17 | 2021-09-07 00:00:00 | Krystin
18 | 2021-09-08 00:00:00 | [NAME]
19 | 2021-09-09 00:00:00 | Savanna
20 | 2021-09-09 00:00:00 | Krystin
21 | 2021-09-09 00:00:00 | [NAME]
22 | 2021-09-09 00:00:00 | Isobel
23 | 2021-09-09 00:00:00 | [NAME]
24 | 2021-09-11 00:00:00 | Savanna
25 | 2021-09-11 00:00:00 | Krystin
26 | 2021-09-11 00:00:00 | [NAME]
27 | 2021-09-11 00:00:00 | Isobel
28 | 2021-09-12 00:00:00 | [NAME]
29 | 2021-09-14 00:00:00 | Savanna
30 | 2021-09-15 00:00:00 | Krystin
31 | 2021-09-15 00:00:00 | [NAME]
32 | 2021-09-16 00:00:00 | Isobel
33 | 2021-09-18 00:00:00 | [NAME]
34 | 2021-09-18 00:00:00 | Savanna
35 | 2021-09-18 00:00:00 | Krystin
36 | 2021-09-18 00:00:00 | [NAME]
37 | 2021-09-19 00:00:00 | Isobel
38 | 2021-09-20 00:00:00 | [NAME]
39 | 2021-09-20 00:00:00 | Savanna
40 | 2021-09-22 00:00:00 | [NAME]
41 | 2021-09-25 00:00:00 | Isobel
42 | 2021-09-25 00:00:00 | [NAME]
43 | 2021-09-25 00:00:00 | Savanna
Spreadsheet: 91519d1291229004-using-a-macro-to-merge-35-worksheets-into-a-single-file-excluding-blank-lines-branch2
Sheet: Sheet1

Branch | GL # | REVENUE | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
2 | 1235456847 | type 1 | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200
2 | 1235456847 | type 2 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300
2 | 1235456847 | type 3 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
2 | 1235456847 | type 1 | 400 | 500 | 600 | 700 | 800 | 900 | 1000 | 1100 | 1200 | 1300 | 1400 | 1500
 |  | I would like a macro to merge the content from a branch1 with branch2 and so on into a single file (consoldiated.xls).
Spreadsheet: 48251d1247500160-projection-of-sales-and-income-below-the-breakeven-point-and-two-above-it-ccjelly_q
Sheet: CCJELLY

This worksheet provides a breakeven analysis for one product.
File name: | CCJELLY_q.xls
Author: | [NAME] | Date:07/14/09
Ranges: |  | Macros: | None
Assumptions:
 | CMU | 22.4 | 2.276353276353277
 | Break even point | 1147.321428571428 | 11289.98748435544
Sale price | 39.95
Fixed Costs
-
Rent | 12000
Advertising | 5550
Commercial Stove | 7200
Cooking Equipment | 950
Total fixed cost: | 25700
Variable Costs
-
Preparation/packaging | 15.6
Shipping | 1.95
Total variable cost: | 17.55
 | CC JELLY, INC. PRO FORMA INCOME STATEMENT
 |  | 0.5 | 1 | 1.5 | 2
 | Number of Sales | of BreakEven | of  BreakEven | of BreakEven | of Breakeven
Units Sold | 20 | 573.6607142857142 | 1147.321428571428 | 1720.982142857143 | 2294.642857142857
Revenue | 799 | 22917.74553571429 | 45835.49107142857 | 68753.23660714286 | 91670.98214285714
Fixed Cost | 25700 | 25700 | 25700 | 25700 | 25700
Variable Cost | 351 | 10067.74553571428 | 20135.49107142857 | 30203.23660714286 | 40270.98214285714
Total Cost | 26051 | 35767.74553571428 | 45835.49107142857 | 55903.23660714286 | 65970.98214285713
Profit/Loss | -25252 | -12850 | 0 | 12850 | 25700.00000000001
Spreadsheet: 834302d1687624840-bill-of-material-example
Sheet: Blad1

level | bom
0 | 1
1 | 1.1
2 | 1.1.1
2 | 1.1.2
2 | 1.1.3
2 | 1.1.4
2 | 1.1.5
1 | 1.2
2 | 1.2.1
3 | 1.2.1.1
3 | 1.2.1.2
3 | 1.2.1.3
4 | 1.2.1.3.1
3 | 1.2.1.4
3 | 1.2.1.5
3 | 1.2.1.6
3 | 1.2.1.7
4 | 1.2.1.7.1
3 | 1.2.1.8
4 | 1.2.1.8.1
3 | 1.2.1.9
4 | 1.2.1.9.1
4 | 1.2.1.9.2
4 | 1.2.1.9.3
5 | 1.2.1.9.3.1
4 | 1.2.1.9.4
4 | 1.2.1.9.5
4 | 1.2.1.9.6
5 | 1.2.1.9.6.1
4 | 1.2.1.9.7
4 | 1.2.1.9.8
4 | 1.2.1.9.9
5 | 1.2.1.9.9.1
4 | 1.2.1.9.10
4 | 1.2.1.9.11
4 | 1.2.1.9.12
4 | 1.2.1.9.13
4 | 1.2.1.9.14
4 | 1.2.1.9.15
4 | 1.2.1.9.16
3 | 1.2.1.10
3 | 1.2.1.11
3 | 1.2.1.12
3 | 1.2.1.12
4 | 1.2.1.12.1
2 | 1.2.2
3 | 1.2.2.1
3 | 1.2.2.2
4 | 1.2.2.2.1
3 | 1.2.2.3
2 | 1.2.3
3 | 1.2.3.1
4 | 1.2.3.1.1
3 | 1.2.3.2
3 | 1.2.3.3
4 | 1.2.3.3.1
3 | 1.2.3.4
4 | 1.2.3.4.1
3 | 1.2.3.5
4 | 1.2.3.5.1
3 | 1.2.3.6
3 | 1.2.3.7
3 | 1.2.3.8
3 | 1.2.3.9
4 | 1.2.3.9.1
3 | 1.2.3.10
3 | 1.2.3.11
3 | 1.2.3.12
3 | 1.2.3.13
3 | 1.2.3.14
3 | 1.2.3.15
3 | 1.2.3.16
2 | 1.2.4
3 | 1.2.4.1
4 | 1.2.4.1.1
3 | 1.2.4.2
4 | 1.2.4.2.1
3 | 1.2.4.3
4 | 1.2.4.3.1
3 | 1.2.4.4
4 | 1.2.4.4.1
3 | 1.2.4.5
4 | 1.2.4.5.1
3 | 1.2.4.6
4 | 1.2.4.6.1
3 | 1.2.4.7
4 | 1.2.4.7.1
3 | 1.2.4.8
4 | 1.2.4.8.1
3 | 1.2.4.9
4 | 1.2.4.9.1
2 | 1.2.5
2 | 1.2.6
2 | 1.2.7
2 | 1.2.8
3 | 1.2.8.1
2 | 1.2.9
2 | 1.2.10
2 | 1.2.11
2 | 1.2.12
2 | 1.2.13
2 | 1.2.14
3 | 1.2.14.1
2 | 1.2.15
2 | 1.2.16
2 | 1.2.17
3 | 1.2.17.1
3 | 1.2.17.2
3 | 1.2.17.3
3 | 1.2.17.4
3 | 1.2.17.5
4 | 1.2.17.5.1
3 | 1.2.17.6
3 | 1.2.17.7
4 | 1.2.17.7.1
2 | 1.2.18
2 | 1.2.19
2 | 1.2.20
2 | 1.2.21
2 | 1.2.22
2 | 1.2.23
3 | 1.2.23.1
2 | 1.2.24
2 | 1.2.25
3 | 1.2.25.1
2 | 1.2.26
2 | 1.2.27
2 | 1.2.28
2 | 1.2.29
1 | 1.3
2 | 1.3.1
2 | 1.3.2
2 | 1.3.3
2 | 1.3.4
2 | 1.3.5
3 | 1.3.5.1
2 | 1.3.6
2 | 1.3.7
2 | 1.3.8
2 | 1.3.9
2 | 1.3.10
3 | 1.3.10.1
2 | 1.3.11
2 | 1.3.12
2 | 1.3.13
3 | 1.3.13.1
4 | 1.3.13.1.1
3 | 1.3.13.2
4 | 1.3.13.2.1
3 | 1.3.13.3
2 | 1.3.14
2 | 1.3.15
2 | 1.3.16
3 | 1.3.16.1
2 | 1.3.17
2 | 1.3.18
2 | 1.3.19
2 | 1.3.20
3 | 1.3.20.1
2 | 1.3.21
2 | 1.3.22
2 | 1.3.23
Spreadsheet: 06945aaf-3deb-4ac4-98d8-ab7543357e0c
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 |  |  |  | Error Index Calculation
 |  | Method being evaluated: |  |  |  |  |  |  |  | Date:
 |  |  | Reference Method: |  |  |  |  |  |  | Total Allowable Error (TEa):
 |  |  |  | Analyte: |  |  |  |  |  | Conc. | Pct.
 |  |  |  | Units: |  |  |  |  |  | 5 | 30
 |  |  | X Method |  | Y Method |  |  | 95% Conf. Limits |  |  |  |  | Grade
 |  |  | MDP |  | Pred. MDP |  |  | Low | Low Index | High | High index
 |  | 15 | 50 |  |  |  |  |  |  |  |  | Unacceptable
 |  | 21 | 70 |  |  |  |  |  |  |  |  | Unacceptable
 |  | 33 | 110 |  |  |  |  |  |  |  |  | Unacceptable
 |  | 120 | 400 |  |  |  |  |  |  |  |  | Unacceptable
 |  | 300 | 1000 |  |  |  |  |  |  |  |  | Unacceptable
 |  | 5
Spreadsheet: 773932d1648121748-returning-the-frequency-value-based-on-the-latest-test-date-example
Sheet: Sheet1

Ref | Test date | Frequency |  |  | Ref | Frequency
123456 | 2022-03-24 00:00:00 | Monthly |  |  | 123456 | Monthly,Monthly | Ref 12345 has four entries, but the latest 2 entries are dated 24/03/22 and the frequency is monthly for both
123456 | 2022-03-24 00:00:00 | Monthly |  |  | 78910 | Quarterly,Monthly | Ref 78910 has four entries, but the latest 2 entries are dated 22/02/21 and the frequency is Quarterly and monthly
123456 | 2018-12-12 00:00:00 | Monthly
123456 | 2018-12-12 00:00:00 | Monthly
78910 | 2020-01-31 00:00:00 | Quarterly
78910 | 2020-01-31 00:00:00 | Quarterly
78910 | 2021-02-22 00:00:00 | Quarterly
78910 | 2021-02-22 00:00:00 | Monthly
Spreadsheet: 877109d1723789747-how-to-list-unpaid-payment-akir4-help4-2-365-aligw
Sheet: Sheet2

 | Data |  |  |  |  |  |  | Result I want using formula
 | Date | Name | Addres | Item | Total | Paid |  | Unpaid
 | 2024-07-02 00:00:00 | A | MHT | bag | 2000 | False |  | Date | Name | Total
 | 2024-07-04 00:00:00 | B | US | shoes | 1222 | True |  |  | A | MHT | bag | 2000
 | 2024-07-06 00:00:00 | C | LA | shirt | 1347 | True |  | 2024-07-08 00:00:00 | D | JP | skirt | 1592
 | 2024-07-08 00:00:00 | D | JP | skirt | 1592 | False |  | 2024-07-14 00:00:00 | G | AF | pencil | 2548
 | 2024-07-10 00:00:00 | E | ID | paper | 2100 | True |  | 2024-07-16 00:00:00 | H | BA | eraser | 1269
 | 2024-07-12 00:00:00 | F | MY | pen | 3456 | True
 | 2024-07-14 00:00:00 | G | AF | pencil | 2548 | False
 | 2024-07-16 00:00:00 | H | BA | eraser | 1269 | False
 | 2024-07-18 00:00:00 | J | IND | glass | 1998 | True
 | 2024-07-20 00:00:00 | K | PAR | cutter | 1569 | True